C:\Documents and Settings\Administrator>tnsping oracleTNS Ping Utility for 32-bit Windows: Version 8.1.7.0.0 - Production on 09-9月 -2
008 14:21:57(c) Copyright 1997 Oracle Corporation. All rights reserved.Attempting to contact (ADDRESS=(PROTOCOL=TCP)(HOST=oracle)(PORT=1521))
TNS-12560: TNS:协议适配器出现错误下面是linux下的两上文件:listener.ora与tnsnames.oralistener.oraLISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST))
(ADDRESS = (PROTOCOL = TCP)(HOST = DATA(PORT = 1521))
)
)
)
SID_LIST_LISTENER
(SID_LIST
(SID_DESC
(SID_NAME=PLSExtProc)
(ORACLE_HOME=/oracle/app/oracle/product/8.1.7)
(PROGRAM=extproc)
) (SID_DESC=
(GLOBAL_DBNAME=gaac)
(ORACLE_HOME=/oracle/app/oracle/product/8.1.7)
(SID_NAME=gaac)
)
)
tnsnames.ora文件
INST1_HTTP=
(DESCREPTION=
(ADDRESS_LIST)=
(ADDRESS = (PROTOCOL = TCP)(HOST = data(PORT = 1521))
)
(CONNECT_DATA=
(SERVER=SHARED
(SERVICE_NAME=gaac
(PRESENTATION=Http://admin
)
)
GAAC=
(DESCRIPTION=
(ADDRESS_LIST=
(ADDRESS = (PROTOCOL = TCP)(HOST = data(PORT = 1521))
)
(CONNECT_DATA
(SERVICE_NAME=gaac)
)
)
在域的DNS里,ORACLE就是linux的IP.linux的主机名是data.我不太懂oracle.大家帮我看看.多谢!
008 14:21:57(c) Copyright 1997 Oracle Corporation. All rights reserved.Attempting to contact (ADDRESS=(PROTOCOL=TCP)(HOST=oracle)(PORT=1521))
TNS-12560: TNS:协议适配器出现错误下面是linux下的两上文件:listener.ora与tnsnames.oralistener.oraLISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST))
(ADDRESS = (PROTOCOL = TCP)(HOST = DATA(PORT = 1521))
)
)
)
SID_LIST_LISTENER
(SID_LIST
(SID_DESC
(SID_NAME=PLSExtProc)
(ORACLE_HOME=/oracle/app/oracle/product/8.1.7)
(PROGRAM=extproc)
) (SID_DESC=
(GLOBAL_DBNAME=gaac)
(ORACLE_HOME=/oracle/app/oracle/product/8.1.7)
(SID_NAME=gaac)
)
)
tnsnames.ora文件
INST1_HTTP=
(DESCREPTION=
(ADDRESS_LIST)=
(ADDRESS = (PROTOCOL = TCP)(HOST = data(PORT = 1521))
)
(CONNECT_DATA=
(SERVER=SHARED
(SERVICE_NAME=gaac
(PRESENTATION=Http://admin
)
)
GAAC=
(DESCRIPTION=
(ADDRESS_LIST=
(ADDRESS = (PROTOCOL = TCP)(HOST = data(PORT = 1521))
)
(CONNECT_DATA
(SERVICE_NAME=gaac)
)
)
在域的DNS里,ORACLE就是linux的IP.linux的主机名是data.我不太懂oracle.大家帮我看看.多谢!
解决方案 »
- 关于统计核算的一个 存储过程 请大家帮帮忙!
- create view的本质是什么?
- 求一个ORACLE导入和导出XML文件的例子
- C#程序连接Oracle问题
- 我怎样才能查看oracle数据库表空间里面到底有哪些表?
- Oracle 815TNSListener 无法自动启动
- 救命啊,奔4安装不了Oracle8i !来者有分!急!!
- 求救!在服务中也不能启动监听器?!怎么办?!
- oracle中用c++如何存取longraw型的数据?有现成的程序段最好!
- 關于crystal report 開發問題
- 求一SQL语句如何 得到某表中某字段中指定相同行数的值?
- Oracle 调用store procedre的问题
试试:ping oracle是否能解析的了。
如果解析不了,修改你本地的tnsnames.ora,把主机名改成ip。
类似如下的格式:
gaac =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.1.1.2)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = gaac)
)
)
丢失了括号,应该是我的错误.