Create a new database by using the Oracle database configuration assistant (dbca) or manually.
Make the necessary changes in the Oracle
listner.orafiles in order to define addresses of the databases for establishing connections to the newly created database.
After configuring the
.orafiles, start the Oracle instance using the following command:
$ sudo /etc/init.d/oracle-xe restart
Connect to Oracle using SQL*Plus as SYSDBA as follows:
$ ./$<ORACLE_HOME>/config/scripts/sqlplus.sh sysadm/password as SYSDBA
Connect to the instance with the username and password using the following command:
As SYSDBA, create a database user and grant privileges to the user as shown below:
Code Block language powershell
Create user <USER_NAME> identified by password<PASSWORD> account unlock; grant connect to <USER_NAME>; grant create session, create table, create sequence, create trigger to <USER_NAME>; alter user <USER_NAME> quota <SPACE_QUOTA_SIZE_IN_MEGABYTES> on '<TABLE_SPACE_NAME>'; commit;
- Exit from the SQL*Plus session by executing the