虽然在论坛上查看了同样问题的帖子,也试着修改tnsnames.ora和sqlnet.ora,但是都没有解决,TOAD可以连接数据库,就是datawindow连接数据库时,提示“ORA-12154: TNS: 无法处理服务名”。
tnsnames.ora内容如下: oop=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.10)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = oop)
)
)
sqlnet.ora内容如下:
SQLNET.AUTHENTICATION_SERVICES= (NTS) NAMES.DIRECTORY_PATH= (TNSNAMES) SQLNET.CRYPTO_SEED = 4fhfguweotcadsfdsafjkdsfqp5f201p45mxskdlfdasf 请问如何解决,重新安装了oracle数据库,也重装了系统也是无法解决,本人刚刚接触oracle和pb,请问如何解决?在此先谢谢了
tnsnames.ora内容如下: oop=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.10)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = oop)
)
)
sqlnet.ora内容如下:
SQLNET.AUTHENTICATION_SERVICES= (NTS) NAMES.DIRECTORY_PATH= (TNSNAMES) SQLNET.CRYPTO_SEED = 4fhfguweotcadsfdsafjkdsfqp5f201p45mxskdlfdasf 请问如何解决,重新安装了oracle数据库,也重装了系统也是无法解决,本人刚刚接触oracle和pb,请问如何解决?在此先谢谢了
1,如果是装在windows下面的话,进入-->控制面板-->管理工具-->服务里面将OracleOraDb10g_home1TNSListener服务启动起来。 2,如果是安装在linux下的话:
SQL> connect /as sysdba
Connected to an idle instance.
SQL> shutdwon abort;
(1)启动监听器
oracle@suse92:~> lsnrctl start
(2)、停止监听器
oracle@suse92:~> lsnrctl stop
(3)查看监听器状态
oracle@suse92:~> lsnrctl
LSNRCTL> status
LSNRCTL> exit
(4)启动em
emctl start dbconsole
地址:http://ip:1158/em
(5)启动sqlplus
isqlplusctl start
地址:http://ip:5560/isqlplus
009 11:41:07(c) Copyright 1997 Oracle Corporation. All rights reserved.TNS-03505: 未能分解名称
2、确认192.168.1.10 这个地址是正确的