1.要将listener.ora中的 (DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
(ORACLE_HOME = home路径)
(SID_NAME = 数据库全局名称)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
) host值填写为修改后的计算机名称或者localhost
2.将tnsnames.ora中的host值修改为localhost
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
重启监听服务,访问数据库,如果报’ora12514 监听程序当前无法识别‘ 错误
3.在listener.ora中找到(SID_LIST =)在里面加入(SID_DESC =
(GLOBAL_DBNAME = 数据库全局名称)(ORACLE_HOME = home路径)
(SID_NAME = 数据库全局名称)
) 注意红色标记部分!