两节点RAC，其中一个不能以sqlplus / as sysasm连接ASM
两个节点RAC，都是11.1.0.7，连接ASM的时候，其中一个节点可以用sqlplus / as sysasm连接，另一个节点却不能，可以用sqlplus sys/oracle as sysasm和sqlplus / as sysdba连接，password file存在，只用了ORACLE一个用户，都在DBA组里面，PASSWORD FILE也重新建过：$ . oraenv
ORACLE_SID = [+ASM1] ?
The Oracle base for ORACLE_HOME=/urac/rdbms/product/11.1.0/db_1 is /urac/rdbms
$ sqlplus / as sysasm
SQL*Plus: Release 11.1.0.7.0 - Production on Wed Dec 3 23:12:31 2014
Copyright (c) 1982, 2008, Oracle. All rights reserved.
ERROR:
ORA-03113: end-of-file on communication channel
Process ID: 0
Session ID: 0 Serial number: 0
Enter user-name:
$ sqlplus sys/oracle as sysasm
SQL*Plus: Release 11.1.0.7.0 - Production on Wed Dec 3 23:20:00 2014
Copyright (c) 1982, 2008, Oracle. All rights reserved.
Connected to an idle instance.
SQL> exit
Disconnected
$ sqlplus / as sysdba
SQL*Plus: Release 11.1.0.7.0 - Production on Wed Dec 3 23:20:10 2014
Copyright (c) 1982, 2008, Oracle. All rights reserved.
Connected to an idle instance.
SQL>
补充一下，两边的SQLNET.ora文件内容一致如下：
NAMES.DIRECTORY_PATH=(TNSNAMES, ONAMES, HOSTNAME)
SQLNET.EXPIRE_TIME= 10
现在可以手工以sqlplus / as sysdba或者sqlplus sys/oracle as sysasm登陆节点1启动+ASM1，但是CRS不能启动+ASM1，因为
./crs_stat -p ora.ebs1.ASM1.asm
USR_ORA_CONNECT_STR=/ as sysasm
日志文件中也提示：
more ora.ebs1.ASM1.asm.log
2014-12-03 20:42:36.282: [ RACG] :
SQL*Plus: Release 11.1.0.7.0 - Production on Wed Dec 3 20:42:35 2014
Copyright (c) 1982, 2008, Oracle. All rights reserved.
Enter user-name: ERROR:
ORA-03113: end-of-file on communication channel
Process ID: 0
Session ID: 0 Serial number: 0
2014-12-03 20:42:36.282: [ RACG] : Enter user-name: SP2-0306: Invalid option.
Usage: CONN
where <logon> ::= <username>[/<password>][@<connect_identifier>] | /
Enter user-name: Enter password:
ERROR:
2014-12-03 20:42:36.282: [ RACG] : ORA-01005: null password given; logon denied
SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus
$ id oracle
uid=500(oracle) gid=500(dba) groups=500(dba)
$ ls -ltr $ORACLE_HOME/bin/oracle
-rwsr-s--x 1 oracle dba 158617291 Nov 21 05:29 /urac/rdbms/product/11.1.0/db_1/bin/oracle
$ id oracle
uid=500(oracle) gid=500(dba) groups=500(dba)
$ ls -ltr $ORACLE_HOME/bin/oracle
-rwsr-s--x 1 oracle dba 158617291 Dec 3 23:03 /urac/rdbms/product/11.1.0/db_1/bin/oracle
SQL> select * from v$pwfile_users;
USERNAME SYSDB SYSOP SYSAS
------------------------------ ----- ----- -----
SYS TRUE TRUE TRUE 本帖最后由 zndavid 于 2014-12-3 17:08 编辑
两个节点sqlplus as sysasm strace文件
页:
[1]