1、通过oracle--配置和移植工具--Net Configuration Assistant添加监听LISTENER1,监听端口如9030
2、打开oracle--配置和移植工具--Net Manager,在服务命名中创建服务名如orcl_9030,端口号指定9030,测试提示
ORA-12514: TNS: 监听程序当前无法识别连接描述符中请求的服务解决
解决办法
打开oracl_home\NETWORK\ADMIN\listener.ora
SID_LIST_LISTENER1 =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = D:\oracle\product\10.2.0\db_1)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = orcl)
(ORACLE_HOME = D:\oracle\product\10.2.0\db_1\BIN)
(SID_NAME = ORCL)
)
)
LISTENER1 =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = hntl-33361faaf6)(PORT = 9030))
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
)
说明:
1、SID_LIST_LISTENER1和LISTENER1名字保持一定规则
2、增加蓝色部分内容
SID_LIST_LISTENER1 =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = D:\oracle\product\10.2.0\db_1)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = orcl)
(ORACLE_HOME = D:\oracle\product\10.2.0\db_1\BIN)
(SID_NAME = ORCL)
)
)