监听程序成功启动,但数据库无法注册到监听程序中
listener.ora:
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = CLRExtProc)
(ORACLE_HOME = E:\OracleDataBase\app\Administrator\product\11.2.0\dbhome_1)
(PROGRAM = extproc)
(ENVS = "EXTPROC_DLLS=ONLY:E:\OracleDataBase\app\Administrator\product\11.2.0\dbhome_1\bin\oraclr11.dll")
)
)LISTENER_TEST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = hua)(PORT = 1523))
)LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = hua)(PORT = 1521))
)
)
tnsnames.ora:
LISTENER_TEST =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = hua)(PORT = 1523))
)ORACLR_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
(CONNECT_DATA =
(SID = CLRExtProc)
(PRESENTATION = RO)
)
)TEST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = hua)(PORT = 1523))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = test.beijing)
)
)ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = hua)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
listener.ora:
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = CLRExtProc)
(ORACLE_HOME = E:\OracleDataBase\app\Administrator\product\11.2.0\dbhome_1)
(PROGRAM = extproc)
(ENVS = "EXTPROC_DLLS=ONLY:E:\OracleDataBase\app\Administrator\product\11.2.0\dbhome_1\bin\oraclr11.dll")
)
)LISTENER_TEST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = hua)(PORT = 1523))
)LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = hua)(PORT = 1521))
)
)
tnsnames.ora:
LISTENER_TEST =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = hua)(PORT = 1523))
)ORACLR_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
(CONNECT_DATA =
(SID = CLRExtProc)
(PRESENTATION = RO)
)
)TEST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = hua)(PORT = 1523))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = test.beijing)
)
)ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = hua)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
解决方案 »
- linux下安装oracle报错,哪位大侠帮忙解决下
- 求助oracle大师,帮忙看下这个函数哪错了
- 求一个简单的存储过程
- 这是锁表问题吗?这是避免解锁的办法吗?
- 我想对就求和的结果进行分类,如0-10,10-30,30-50,50-100,100-200,如此,求出计数,如何用SQL语句来实现呢?
- 请教一个sql语句
- ORACLE中能不能更改一个表的所有者?怎么改?
- SQL SERVER 2000 中的库一次性转换到 ORACLE 当中!(急)
- 如何运行脚本?
- sqlldr问题,想了一星期还是不会
- 请问如何快速的清除,Oracle数据库的全部数据!
- oracleDBconsole启动不了,发现问题了却解决不了请高手指教
不劳烦各位了!