今天连接数据库oracle10突然报错“Ora-12514:tns: 监听程序当前无法识别连接描叙符中请求的服务”,很是奇怪,以前都是好好的,为什么现在报错呢?上网一搜,经过检验,问题解决了,记录下来。
打开C:/oracle/product/10.2.0/db_2/network/admin/listener.ora的listener.ora文件,修改如下:
注意:绿色字体部分是新增加的,蓝色字体部分是修改的,oracle10是数据库实例
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:/oracle/product/10.2.0/db_2)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = oracle10)
(ORACLE_HOME = C:/oracle/product/10.2.0/db_2)
(SID_NAME = oracle10)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1 )(PORT = 1521))
)
)
打开:C:/oracle/product/10.2.0/db_2/network/admin/tnsnames.ora的tnsnames.ora文件,修改如下:
注意:绿色字体部分是新增加的,蓝色字体部分是修改的
ORACLE10 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1 )(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = oracle10)
)
)
思考:1.在listener .ora文件中指定监听的实例名;
2. 将host地址改成本机ip地址就可以了。