求助oracle9201 for redhat7.3

teaflower

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

在tnsnames.ora文件中加入connect string 'sah'

teaflower

我不是加了(SERVICE_NAME =sah)
) 了吗？