UC知道oracle连接失败
来源：百度知道 编辑：UC知道 时间：2024/06/20 13:34:41
C:\Users\lenovo>sqlplus "system/oralce"@oracle
SQL*Plus: Release 10.2.0.3.0 - Production on 星期六 12月 12 17:22:53 2009
Copyright (c) 1982, 2006, Oracle. All Rights Reserved.
加有sid就卡在那边，去掉后面的sid就可以成功连上．
sqlnet.ora文件：
SQLNET.AUTHENTICATION_SERVICES= (NTS)
tnsname.ora文件
oracleXDB=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = lenovo-PC)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME =oracleXDB)
(INSTANCE_NAME = oracle)
)
)
listener.ora文件
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = lenovo-PC)(PORT = 1521))
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = ORACLE)
(ORACLE_HOME = C:\oracle\product\10.2.
SQL*Plus: Release 10.2.0.3.0 - Production on 星期六 12月 12 17:22:53 2009
Copyright (c) 1982, 2006, Oracle. All Rights Reserved.
加有sid就卡在那边，去掉后面的sid就可以成功连上．
sqlnet.ora文件：
SQLNET.AUTHENTICATION_SERVICES= (NTS)
tnsname.ora文件
oracleXDB=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = lenovo-PC)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME =oracleXDB)
(INSTANCE_NAME = oracle)
)
)
listener.ora文件
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = lenovo-PC)(PORT = 1521))
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = ORACLE)
(ORACLE_HOME = C:\oracle\product\10.2.
你的配置有问题
(CONNECT_DATA =
(SERVICE_NAME =oracleXDB)
(INSTANCE_NAME = oracle)
)
不能这么配，oracleXDB 是ORACLE10G自带的服务，你应该配两个服务名，分开访问
比如
oracle=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = lenovo-PC)(PORT = 1521))
)
(CONNECT_DATA =
(INSTANCE_NAME = oracle)
)
)
然后把你原来配的那条oracleXDB中的 (INSTANCE_NAME = oracle)删掉
因为你写错了，应该是@oraclexdb,你的TNSNAMES里面第一行不写着嘛，@后面连的不叫SID，而是服务名，是由TNSNAMES解析的，它会帮你连到SID也就是你的ORACLE。
如果这样还是有错的话就有可能是监听没起，cmd下lsnrctl status 试试，没有起就lsnrctl start
补充：你用@oraclexdb不成功？