遇到了問題，哪位大神解答一下
uj5u.com熱心網友回復：
https://blog.51cto.com/12573184/2427113uj5u.com熱心網友回復：
1. 打開Oracle安裝目錄下的/network/admin/listener.ora檔案，通常內容如下：SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = PLSExtProc) (ORACLE_HOME = E:\oracle\product\10.2.0\db) (PROGRAM = extproc) )
……
2. 修改這個檔案，增加下面的內容：
(SID_DESC = (GLOBAL_DBNAME = ORACLE) (ORACLE_HOME = E:\oracle\product\10.2.0\db) (SID_NAME = orcl) )
這里的orcl換成具體的實體名稱。
3.完整的listener.ora檔案的內容如下：
SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = PLSExtProc) (ORACLE_HOME = E:\oracle\product\10.2.0\db) (PROGRAM = extproc) ) (SID_DESC = (GLOBAL_DBNAME = ORACLE) (ORACLE_HOME = E:\oracle\product\10.2.0\db) (SID_NAME = orcl) ) )
LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1)) ) (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.18.2)(PORT = 1521)) ) )
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/18027.html
標籤：基礎和管理
上一篇：關于子查詢陳述句的疑惑
下一篇：windows 下data guard傳送失敗 ORA-01017: invalid username/password; ORA-01031