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 orcl and the other is test.
Export oracle_sid = orcl
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