Oracle new add-on instance

[[Email protected]_normal2_db ~]$ dbca--oracle user to execute this command, will come out of the graphical interface

650) this.width=650; "Src=" Http://s2.51cto.com/wyfs02/M00/85/3D/wKiom1edzMrzHbSzAADirwpnAsY727.png-wh_500x0-wm_3 -wmp_4-s_1687704557.png "title=" 1.png "alt=" Wkiom1edzmrzhbszaadirwpnasy727.png-wh_50 "/>

650) this.width=650; "Src=" Http://s5.51cto.com/wyfs02/M00/85/3D/wKioL1edzPzCoUp3AAFsxYxkuxI892.png-wh_500x0-wm_3 -wmp_4-s_2806205873.png "title=" 1.png "alt=" Wkiol1edzpzcoup3aafsxyxkuxi892.png-wh_50 "/>

650) this.width=650; "Src=" Http://s5.51cto.com/wyfs02/M01/85/3D/wKioL1edzTmw2zYeAAFKQcnf72s306.png-wh_500x0-wm_3 -wmp_4-s_1508780542.png "title=" 1.png "alt=" Wkiol1edztmw2zyeaafkqcnf72s306.png-wh_50 "/>

650) this.width=650; "Src=" Http://s4.51cto.com/wyfs02/M01/85/3D/wKiom1edza3yLd0jAAFeoygJB10445.png-wh_500x0-wm_3 -wmp_4-s_880718589.png "title=" 1.png "alt=" Wkiom1edza3yld0jaafeoygjb10445.png-wh_50 "/>

650) this.width=650; "Src=" Http://s4.51cto.com/wyfs02/M01/85/3D/wKioL1edzefAYZgEAAFU7UU_Mcs861.png-wh_500x0-wm_3 -wmp_4-s_786200738.png "title=" 1.png "alt=" Wkiol1edzefayzgeaafu7uu_mcs861.png-wh_50 "/>

650) this.width=650; "Src=" Http://s5.51cto.com/wyfs02/M00/85/3D/wKiom1edziKRQrprAAFPkMeobvs769.png-wh_500x0-wm_3 -wmp_4-s_3519093211.png "title=" 1.png "alt=" Wkiom1edzikrqrpraafpkmeobvs769.png-wh_50 "/>

650) this.width=650; "Src=" Http://s1.51cto.com/wyfs02/M01/85/3D/wKiom1edznXRvsBGAAGGnW1ZUUs563.png-wh_500x0-wm_3 -wmp_4-s_413397139.png "title=" 1.png "alt=" Wkiom1edznxrvsbgaaggnw1zuus563.png-wh_50 "/>

650) this.width=650; "Src=" Http://s4.51cto.com/wyfs02/M02/85/3D/wKioL1edzqaQaavDAAFq3M2t3Pc620.png-wh_500x0-wm_3 -wmp_4-s_1653625223.png "title=" 1.png "alt=" Wkiol1edzqaqaavdaafq3m2t3pc620.png-wh_50 "/>

650) this.width=650; "Src=" Http://s2.51cto.com/wyfs02/M01/85/3D/wKioL1edzu-Qgbs3AAFeR0GzFDI257.png-wh_500x0-wm_3 -wmp_4-s_3642685905.png "title=" 1.png "alt=" Wkiol1edzu-qgbs3aafer0gzfdi257.png-wh_50 "/>

650) this.width=650; "Src=" Http://s1.51cto.com/wyfs02/M02/85/3D/wKiom1edzxejtQqZAAFNNIfDdJ4253.png-wh_500x0-wm_3 -wmp_4-s_2104590815.png "title=" 1.png "alt=" Wkiom1edzxejtqqzaafnnifddj4253.png-wh_50 "/>

650) this.width=650; "Src=" Http://s5.51cto.com/wyfs02/M00/85/3D/wKiom1edz4OCBU5OAAGQCqPVCck600.png-wh_500x0-wm_3 -wmp_4-s_2967667035.png "title=" 1.png "alt=" Wkiom1edz4ocbu5oaagqcqpvcck600.png-wh_50 "/>

650) this.width=650; "Src=" Http://s3.51cto.com/wyfs02/M02/85/3D/wKiom1edz6GxB-o3AAEJ5BPtHAA284.png-wh_500x0-wm_3 -wmp_4-s_4081395204.png "title=" 1.png "alt=" Wkiom1edz6gxb-o3aaej5bpthaa284.png-wh_50 "/>

Complete the creation of the instance with direct finish

Here's how to modify the configuration file

In a database with only one instance, it's best to follow the settings below

650) this.width=650; "Src=" Http://s1.51cto.com/wyfs02/M00/85/3D/wKioL1ed0BDSuV_FAAC-kmHPY44609.png-wh_500x0-wm_3 -wmp_4-s_1957000351.png "title=" 1.png "alt=" Wkiol1ed0bdsuv_faac-kmhpy44609.png-wh_50 "/>

The red frame is the first name entered, changed to that name in the config file, and then

The source Cat/home/oracle/.bash_profile lets the configuration take effect.

This is the instance that starts when it is started. If there are two instances in the database, how do I start?

Su-oracle

Lsnrctl start

-Suppose 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

Auto-start, can be set in/etc/rc.local, add the following content

--Start the default DB instance

Su-oracle < Lsnrctl start

Sqlplus/as SYSDBA

Startup

Quit

Eof

--Start a second DB instance

Su-oracle < export oracle_sid=test

Sqlplus/as SYSDBA

Startup

Quit

Eof

Oracle new add-on instance