Start multiple Oracle Instances
To build a second Oracle instance step on Linux:
1, in the Linux server graphics interface, open a terminal, enter the following command;
Xhost +
2, switch to the Oracle user, use the following command:
Su-oracle
3. Specify the variables and values for the database instance, assuming that the SID of the data instance to be established is test
Export Oracle_sid=test
4, use the DBCA tool to establish the example
Dbca
5, manually start two instances
Su-oracle
Lsnrctl start
--Suppose 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 start, can be set up in the/etc/rc.local, add the following content
--Start the default database instance
Su-oracle <<eof
Lsnrctl start
Sqlplus/as SYSDBA
Startup
Quit
Eof
--Start a second database instance
Su-oracle <<eof
Export Oracle_sid=test
Sqlplus/as SYSDBA
Startup
Quit
Eof