我在XP上装完数据库,当时可以用SQL PLUS登陆
但是重新启动机器后,就不能用SQL PLUS登陆了,提示
ORA-12154: TNS:无法解析指定的连接标志符
数据库应该是启动的,在任务里面能看到.tnsnames.ora文件内容如下# tnsnames.ora Network Configuration File: D:\oracleDB\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = liz)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(CONNECT_DATA =
(SID = ORCL)
(PRESENTATION = RO)
)
)
listener.ora文件的内容如下
# listener.ora Network Configuration File: D:\oracleDB\network\admin\listener.ora
# Generated by Oracle configuration tools.SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = orcl)
(ORACLE_HOME = D:\oracleDB)
(PROGRAM = extproc)
)
)LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = liz)(PORT = 1521))
)
)
)
sqlnet.ora文件内容如下
# sqlnet.ora Network Configuration File: D:\oracleDB\network\admin\sqlnet.ora
# Generated by Oracle configuration tools.SQLNET.AUTHENTICATION_SERVICES= (NTS)NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
请高手帮忙看看是什么地方出错了。
但是重新启动机器后,就不能用SQL PLUS登陆了,提示
ORA-12154: TNS:无法解析指定的连接标志符
数据库应该是启动的,在任务里面能看到.tnsnames.ora文件内容如下# tnsnames.ora Network Configuration File: D:\oracleDB\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = liz)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(CONNECT_DATA =
(SID = ORCL)
(PRESENTATION = RO)
)
)
listener.ora文件的内容如下
# listener.ora Network Configuration File: D:\oracleDB\network\admin\listener.ora
# Generated by Oracle configuration tools.SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = orcl)
(ORACLE_HOME = D:\oracleDB)
(PROGRAM = extproc)
)
)LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = liz)(PORT = 1521))
)
)
)
sqlnet.ora文件内容如下
# sqlnet.ora Network Configuration File: D:\oracleDB\network\admin\sqlnet.ora
# Generated by Oracle configuration tools.SQLNET.AUTHENTICATION_SERVICES= (NTS)NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
请高手帮忙看看是什么地方出错了。
还有看看你的服务监听起来了吗?
1, 在cmd命令行里面执行 tnsping orcl,如果ok的话。就关掉你的卡巴斯基杀毒软件试试。否则报错的话,就检查下你的配置文件里面的orcl配置的ip以及端口、服务名是否正确。
Inthirties关注Oracle数据库 维护 优化,安全,备份,恢复,迁移,故障处理如果你需要帮助或想和我一起学习的请联系
联系方式QQ:370140387
电子邮件:[email protected]
网站: http://www.inthirties.com