- 论坛徽章:
- 0
|
hostname ramain IP:210.35.207.32 SID:stby 在这台机上连本地库或连IP为33的库都成功
hostname rastanby IP:210.35.207.33 SID:tt 在这台机上连本地库成功,但连IP为32的库却不成功
下面给出了两台的listener.ora 和tnsnames.ora文件
33上的数据库版本是9.2.0.2
32上的数据库版本是9.2.0.4
请问是什么原因连接不上呢?????
[oracle@oramain admin]$ more listener.ora
STENER.ORA Network Configuration File: /opt/oracle/product/9.2.0.4/network/admin/listener.ora
# Generated by Oracle configuration tools.
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /opt/oracle/product/9.2.0.4)
(PROGRAM = extproc)
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = stby)
(ORACLE_HOME = /opt/oracle/product/9.2.0.4)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 210.35.207.32)(PORT = 1521))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
)
)
[oracle@oramain admin]$ more tnsnames.ora
# TNSNAMES.ORA Network Configuration File: /opt/oracle/product/9.2.0.4/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.
oramain =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = tcp)
(HOST=210.35.207.32)
(PORT=1521)
)
)
(CONNECT_DATA =
(SID = stby)
)
)
orastanby =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = tcp)
(HOST=210.35.207.33)
(PORT=1521)
)
)
(CONNECT_DATA =
(SID = tt)
)
)
[oracle@oramain admin]$
[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.
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /opt/oracle/product/9.2.0.4)
(PROGRAM = extproc)
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = tt)
(ORACLE_HOME = /opt/oracle/product/9.2.0.4)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 210.35.207.33)(PORT = 1521))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
)
)
[oracle@orastanby admin]$ more tnsnames.ora
orastanby=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS=
(PROTOCOL=tcp)(HOST=210.35.207.33) (PORT=1521)
)
)
(CONNECT_DATA =
(SID = tt)
)
)
oramain =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = tcp)
(HOST=210.35.207.32)
(PORT=1521)
)
)
(CONNECT_DATA =
(SID = stby)
)
)
[oracle@orastanby admin]$ sqlplus "sys/change_on_install@orastanby as sysdba"
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
SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus
[oracle@orastanby admin]$ |
|