[oracle@oramain admin]$ sqlplus "sys/oracle@oramain as sysdba"
SQL*Plus: Release 9.2.0.2.0 - Production on Tue Aug 8 22:41:48 2006
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to:
Oracle9i Enterprise Edition Release 9.2.0.2.0 - 64bit Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.2.0 - Production
SQL> exit
Disconnected from Oracle9i Enterprise Edition Release 9.2.0.2.0 - 64bit Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.2.0 - Production
[oracle@oramain admin]$ sqlplus "sys/change_on_install@orastanby as sysdba"
SQL*Plus: Release 9.2.0.2.0 - Production on Tue Aug 8 22:42:46 2006
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to:
Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.4.0 - Production
SQL> exit
Disconnected from Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.4.0 - Production
[oracle@orastanby admin]$ more listener.ora
# LISTENER.ORA Network Configuration File: /opt/oracle/product/9.2.0.4/network/admin/listener.ora
# Generated by Oracle configuration tools.
SQL*Plus: Release 9.2.0.4.0 - Production on Tue Aug 8 22:50:03 2006
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to:
Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.4.0 - Production
SQL> exit
Disconnected from Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.4.0 - Production
[oracle@orastanby admin]$ sqlplus "sys/oracle@oramain as sysdba"
SQL*Plus: Release 9.2.0.4.0 - Production on Tue Aug 8 22:50:09 2006
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
ERROR:
ORA-12560: TNS:protocol adapter error
Enter user-name:
ERROR:
ORA-01017: invalid username/password; logon denied
Enter user-name:
ERROR:
ORA-01017: invalid username/password; logon denied
TNS Ping Utility for Linux IA64: Version 9.2.0.2.0 - Production on 08-AUG-2006 23:46:33
Copyright (c) 1997 Oracle Corporation. All rights reserved.
Used parameter files:
/opt/oracle/product/9.2.0.4/network/admin/sqlnet.ora
TNS-03505: Failed to resolve name
[oracle@oramain ~]$ tnsping orastanby
TNS Ping Utility for Linux IA64: Version 9.2.0.2.0 - Production on 08-AUG-2006 23:46:41
Copyright (c) 1997 Oracle Corporation. All rights reserved.
Used parameter files:
/opt/oracle/product/9.2.0.4/network/admin/sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = tcp) (HOST=210.35.207.33) (PORT=1521))) (CONNECT_DATA = (SID = tt)))
OK (0 msec)
[oracle@oramain ~]$
[oracle@orastanby oracle]$ tnsping orastanby
TNS Ping Utility for Linux: Version 9.2.0.4.0 - Production on 08-AUG-2006 23:47:48
Copyright (c) 1997 Oracle Corporation. All rights reserved.
Used parameter files:
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS= (PROTOCOL=tcp)(HOST=210.35.207.33) (PORT=1521))) (CONNECT_DATA = (SID = tt)))
OK (0 msec)
[oracle@orastanby oracle]$ tnsping oramain
TNS Ping Utility for Linux: Version 9.2.0.4.0 - Production on 08-AUG-2006 23:47:57
Copyright (c) 1997 Oracle Corporation. All rights reserved.
Used parameter files:
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = tcp) (HOST=210.35.207.32) (PORT=1521))) (CONNECT_DATA = (SID = stby)))
TNS-12560: TNS:protocol adapter error
[oracle@orastanby oracle]$作者: bitao 時間: 2006-08-09 00:17
[size=-1]暈死,,我的剛才問題解決了,,原來 是沒把ORAMAIN這臺機的防火墻給關掉