11.2.0.3RAC 报ORA-12537，请刘达进来看看
节点1：# Do not remove the following line, or various programs
# that require network functionality will fail.
127.0.0.1 localhost.localdomain localhost
#::1 localhost6.localdomain6 localhost6
128.199.59.210 T171PC07VM09_MGT
#public eth1
128.192.77.134 T171PC07VM09
128.192.77.135 T171PC08VM09
#private eth2
192.168.9.139 T171PC07VM09-priv
192.168.9.140 T171PC08VM09-priv
#virtual
128.192.77.131 T171PC07VM09-vip
128.192.77.132 T171PC08VM09-vip
#scan
128.192.77.133 pmidb-scan
PMIDB =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = pmidb-scan)(PORT = 11521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = pmidb)
)
)
PMIDB1 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = T171PC07VM09-vip)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = pmidb)
(INSTANCE_NAME = pmidb1)
)
)
PMIDB2 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = T171PC08VM09-vip)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = pmidb)
(INSTANCE_NAME = pmidb2)
)
)
节点2：
127.0.0.1 localhost.localdomain localhost
#::1 localhost6.localdomain6 localhost6
128.199.59.230 T171PC08VM09_MGT
#public eth1
128.192.77.134 T171PC07VM09
128.192.77.135 T171PC08VM09
#private eth2
192.168.9.139 T171PC07VM09-priv
192.168.9.140 T171PC08VM09-priv
#virtual
128.192.77.131 T171PC07VM09-vip
128.192.77.132 T171PC08VM09-vip
#scan
128.192.77.133 pmidb-scan
PMIDB =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = pmidb-scan)(PORT = 11521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = pmidb)
)
)
PMIDB1 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = T171PC07VM09-vip)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = pmidb)
(INSTANCE_NAME = pmidb1)
)
)
PMIDB2 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = T171PC08VM09-vip)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = pmidb)
(INSTANCE_NAME = pmidb2)
)
)
~
节点1、2都可以sqlplus ***/***@pmidb1 as sysdba 登陆
就是不能 sqlplus ***/***@pmid2 as sysdba
报下面这个错误
ERROR:
ORA-12537: TNS:connection closed
在mos中 :解释中似乎是权限问题，在我的环境中貌似是正常的，请问还有什么原因？谢谢
ls -l oracle
-rwsr-s--x 1 oracle asmadmin 232399431 Jan 3 22:14 oracle
sqlplus sys/oracle@pmidb1 as sysdba
SQL*Plus: Release 11.2.0.3.0 Production on Fri Feb 14 10:05:15 2014
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management and Real Application Testing options
SQL>
oracle@T171PC08VM09:/home/db/oracle/product/11.2.0/db_1/network/admin$ sqlplus sys/oracle@pmidb2 as sysdba
SQL*Plus: Release 11.2.0.3.0 Production on Fri Feb 14 10:05:42 2014
Copyright (c) 1982, 2011, Oracle. All rights reserved.
ERROR:
ORA-12537: TNS:connection closed
Enter user-name:
tnsping pmidb2
TNS Ping Utility for Linux: Version 11.2.0.3.0 - Production on 14-FEB-2014 10:06:06
Copyright (c) 1997, 2011, Oracle. All rights reserved.
Used parameter files:
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = T171PC08VM09-vip)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = pmidb) (INSTANCE_NAME = pmidb2)))
OK (0 msec)
本帖最后由 anbob 于 2014-2-14 10:37 编辑
$ ls -l $ORACLE_HOME/bin/oracle on NODE2 site
Enable sql*net trace ls -l $ORACLE_HOME/bin/oracle
-rwsr-s--x 1 oracle asmadmin 232399431 Jan 3 22:14 /u01/app/oracle/product/11.2.0/db_1/bin/oracle 输出每台服务器 #lsnrctl status 你2节点的linstner启动着吗?
页:
[1]