Has a problem, who is a great god solve

CodePudding user response:

https://blog.51cto.com/12573184/2427113

CodePudding user response:

1. Open the Oracle installation directory/network/admin/listener. Ora file, usually content is as follows:
SID_LIST_LISTENER=(SID_LIST=(SID_DESC=(SID_NAME=PLSExtProc) (ORACLE_HOME=E: \ \ product \ 10.2.0 \ oracle db) (PROGRAM=extproc))
.
2. Modify the file, add the following content:
(SID_DESC=(GLOBAL_DBNAME=ORACLE) (ORACLE_HOME=E: \ \ product \ 10.2.0 \ ORACLE db) (SID_NAME=former))
The former into specific instance name,
3. Complete the listener. Ora file content is as follows:
SID_LIST_LISTENER=(SID_LIST=(SID_DESC=(SID_NAME=PLSExtProc) (ORACLE_HOME=E: \ \ product \ 10.2.0 \ oracle db) (PROGRAM=extproc)) (SID_DESC=(GLOBAL_DBNAME=oracle) (ORACLE_HOME=E: \ \ product \ 10.2.0 \ oracle db) (SID_NAME=former)))
The LISTENER=(DESCRIPTION_LIST=(DESCRIPTION=(ADDRESS=(PROTOCOL=IPC) (KEY=EXTPROC1))) (DESCRIPTION=(ADDRESS=(TCP) PROTOCOL=(HOST=172.16.18.2) (1521) PORT=)))