oracle显示服务器未连接服务器,在线求助,oracle客户端不能连接服务器。

客户端可以连接远程的一个服务器,但是连接不到当前的服务器上。报错:协议适配器错误。

服务器是redhat 7.2

oracle是8.1.7

是什么方面的错误?

tnsnames.ora:

# TNSNAMES.ORA Network Configuration File: /home/oracle/product/8.1.7/network/admin/tnsnames.ora

# Generated by Oracle configuration tools.

SCHOOL1.LOCALDOMAIN =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = TCP)(HOST = localhost.localdomain)(PORT = 1521))

)

(CONNECT_DATA =

(SERVICE_NAME = school1)

)

)

SCHOOL1_210.28.65.2 =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = TCP)(HOST = 210.28.65.2)(PORT = 1521))

)

(CONNECT_DATA =

(SERVICE_NAME = school1)

)

)

####################################

# Date..........: Sat Aug 09 15:31:18 EDT 2003

####################################

INST1_HTTP.LOCALDOMAIN =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = TCP)(HOST = localhost.localdomain)(PORT = 1521))

)

(CONNECT_DATA =

(SERVER = SHARED)

(SERVICE_NAME = school1)

(PRESENTATION = http://admin)

)

)

EXTPROC_CONNECTION_DATA.LOCALDOMAIN =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))

)

(CONNECT_DATA =

(SID = PLSExtProc)

(PRESENTATION = RO)

)

)

listener.ora:

# LISTENER.ORA Network Configuration File: /home/oracle/product/8.1.7/network/admin/listener.ora

# Generated by Oracle configuration tools.

LISTENER =

(DESCRIPTION_LIST =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = TCP)(HOST = localhost.localdomain)(PORT = 1521))

)

)

)

SID_LIST_LISTENER =

(SID_LIST =

(SID_DESC =

(SID_NAME = PLSExtProc)

(ORACLE_HOME = /home/oracle/product/8.1.7)

(PROGRAM = extproc)

)

(SID_DESC =

(GLOBAL_DBNAME = school1)

(ORACLE_HOME = /home/oracle/product/8.1.7)

(SID_NAME = school1)

)

)

sqlnet.ora:

# SQLNET.ORA Network Configuration File: /home/oracle/product/8.1.7/network/admin/sqlnet.ora

# Generated by Oracle configuration tools.

NAMES.DEFAULT_DOMAIN = localdomain

NAMES.DIRECTORY_PATH= (TNSNAMES)

服务器自己tnsping可以通,但是客户端tnsping就不通。

哪位高手指点一下。在线等待。

3x.

参与评论 您还未登录,请先 登录 后发表或查看评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
©️2022 CSDN 皮肤主题:游动-白 设计师:我叫白小胖 返回首页
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、C币套餐、付费专栏及课程。

余额充值