oracle rac 12154,rac sqlplus无法连接出现ORA-12154

配置好rac后,两个节点用tnsping都可以ping通,但用sqlplus连接都出现以下错误,不知道哪里出了问题

[oracle@rac2 admin]$ lsnrctl status

LSNRCTL for Linux: Version 9.2.0.4.0 - Production on 04-MAR-2008 08:32:26

Copyright (c) 1991, 2002, Oracle Corporation.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=rac2)(PORT=1521)))

STATUS of the LISTENER

------------------------

Alias                     LISTENER

Version                   TNSLSNR for Linux: Version 9.2.0.4.0 - Production

Start Date                04-MAR-2008 08:29:03

Uptime                    0 days 0 hr. 3 min. 22 sec

Trace Level               off

Security                  OFF

SNMP                      OFF

Listener Parameter File   /home/oracle/9.2.0.4/network/admin/listener.ora

Listener Log File         /home/oracle/9.2.0.4/network/log/listener.log

Listening Endpoints Summary...

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=rac2)(PORT=1521)))

Services Summary...

Service "PLSExtProc" has 1 instance(s).

Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...

Service "esal" has 2 instance(s).

Instance "rac1", status READY, has 1 handler(s) for this service...

Instance "rac2", status READY, has 1 handler(s) for this service...

The command completed successfully

[oracle@rac2 admin]$ lsnrctl service

LSNRCTL for Linux: Version 9.2.0.4.0 - Production on 04-MAR-2008 08:32:32

Copyright (c) 1991, 2002, Oracle Corporation.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=rac2)(PORT=1521)))

Services Summary...

Service "PLSExtProc" has 1 instance(s).

Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...

Handler(s):

"DEDICATED" established:0 refused:0

LOCAL SERVER

Service "esal" has 2 instance(s).

Instance "rac1", status READY, has 1 handler(s) for this service...

Handler(s):

"DEDICATED" established:0 refused:0 state:ready

REMOTE SERVER

(address=(protocol=tcp)(host=rac1)(port=1521))

Instance "rac2", status READY, has 1 handler(s) for this service...

Handler(s):

"DEDICATED" established:0 refused:0 state:ready

LOCAL SERVER

The command completed successfully

[oracle@rac2 admin]$ sqlplus cy/zh@esal

SQL*Plus: Release 9.2.0.4.0 - Production on Tue Mar 4 08:32:45 2008

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.

ERROR:

ORA-12154: TNS:could not resolve service name

Enter user-name:

ERROR:

ORA-01017: invalid username/password; logon denied

Enter user-name: cy/zh@rac1

ERROR:

ORA-12154: TNS:could not resolve service name

SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus

[oracle@rac2 admin]$ sqlplus cy/zh@rac2

SQL*Plus: Release 9.2.0.4.0 - Production on Tue Mar 4 08:32:59 2008

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.

ERROR:

ORA-12154: TNS:could not resolve service name

Enter user-name:

[本帖最后由 lifewise 于 2008-3-4 10:02 编辑]