Chinaunix

标题: 求助oracle9201 for redhat7.3 [打印本页]

作者: teaflower 时间: 2004-01-04 13:42
标题: 求助oracle9201 for redhat7.3
dgmgrl
DGMGRL>; connect system/manager@sah
Unable to connect to database
ORA-12154: TNS:could not resolve service name

Failed. 报这个错怎么改啊

我的[oracle@oracle admin]$ more listener.ora
# LISTENER.ORA Network Configuration File: /opt/oracle/product/9.0.2/network/admin/listener.ora
# Generated by Oracle configuration tools.

LISTENER =
   (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = oracle)(PORT = 1521)
  )

SID_LIST_LISTENER =
  (SID_LIST =
(SID_DESC =
   (SID_NAME = sah)
   (ORACLE_HOME = /opt/oracle/product/9.0.2)
   (PROGRAM = extproc)
)
  )
我的# TNSNAMES.ORA Network Configuration File: /opt/oracle/product/9.0.2/network/admin/tnsnames.ora

# Generated by Oracle configuration tools.

EXTPROC_CONNECTION_DATA =
  (DESCRIPTION =
(ADDRESS_LIST =
   (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(CONNECT_DATA =
   (SID = sah)
   (PRESENTATION = RO)
)
  )

TESTRCA =
(DESCRIPTION =

(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.19)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME =sah)
)
)

oracle@oracle bin]$ lsnrctl
监听没问题

作者: pearaep 时间: 2004-01-04 15:20
标题: 求助oracle9201 for redhat7.3
在tnsnames.ora文件中加入connect string 'sah'

作者: teaflower 时间: 2004-01-04 16:15
标题: 求助oracle9201 for redhat7.3
我不是加了(SERVICE_NAME =sah)
) 了吗？

欢迎光临 Chinaunix (http://bbs.chinaunix.net/)