1. Open a terminal in the graphic interface of the Linux server and enter the following command;
Xhost +
2. Switch to an Oracle user and run the following command:
Su-oracle
3. Specify the variables and values of the database instance. Assume that the SID of the data instance to be created is test.
Export ORACLE_SID = test
4. Use DBCA to create an instance
Dbca
5. Start two instances manually
Su-oracle
Lsnrctl start
-- Assume that one instance is itsm and the other is test.
Export ORACLE_SID = itsm
Sqlplus/as sysdba
Startup
Quit
Export ORACLE_SID = test
Sqlplus/as sysdba
Startup
Quit
6. Automatic startup. You can set it in/etc/rc. local and add the following content:
-- Start the default database instance
Su-oracle <lsnrctl start
Sqlplus/as sysdba
Startup
Quit
EOF
-- Start the second database instance
Su-oracle <export ORACLE_SID = test
Sqlplus/as sysdba
Startup
Quit
EOF