1. Open a terminal in the graphic interface of the Linux server and enter the following command. xhost + 2. Switch to the Oracle user and run the following command: su
1. Open a terminal in the graphic interface of the Linux server and enter the following command. xhost + 2. Switch to the Oracle user and run the following command: su-oracle 3
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 start. 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