zndavid

0 积分	1 好友	8 主题

发消息

[Exadata常规管理] 两节点RAC，其中一个不能以sqlplus / as sysasm连接ASM

1^#

发表于 2014-12-3 15:30:32 | 查看: 7238| 回复: 4

两个节点RAC，都是11.1.0.7，连接ASM的时候，其中一个节点可以用sqlplus / as sysasm连接，另一个节点却不能，可以用sqlplus sys/oracle as sysasm和sqlplus / as sysdba连接，password file存在，只用了ORACLE一个用户，都在DBA组里面，PASSWORD FILE也重新建过：

[oracle@ebs1 bin]$ . oraenv
ORACLE_SID = [+ASM1] ?
The Oracle base for ORACLE_HOME=/urac/rdbms/product/11.1.0/db_1 is /urac/rdbms

[oracle@ebs1 bin]$ 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:

[oracle@ebs1 bin]$ 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
[oracle@ebs1 bin]$ 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>

分享0

收藏0 回复只看该作者道具举报

zndavid

2^#

发表于 2014-12-3 15:34:15

补充一下，两边的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][3086870208] [14500][3086870208][ora.ebs1.ASM1.asm]:
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][3086870208] [14500][3086870208][ora.ebs1.ASM1.asm]: Enter user-name: SP2-0306: Invalid option.
Usage: CONN[ECT] [logon] [AS {SYSDBA|SYSOPER|SYSASM}]
where <logon> ::= <username>[/<password>][@<connect_identifier>] [edition=value] | /
Enter user-name: Enter password:
ERROR:

2014-12-03 20:42:36.282: [ RACG][3086870208] [14500][3086870208][ora.ebs1.ASM1.asm]: ORA-01005: null password given; logon denied

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

回复只看该作者道具举报

zndavid

3^#

发表于 2014-12-3 16:12:48

[oracle@ebs2 PROD2_ebs2]$ id oracle
uid=500(oracle) gid=500(dba) groups=500(dba)
[oracle@ebs2 PROD2_ebs2]$ 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
[oracle@ebs1 PROD1_ebs1]$ id oracle
uid=500(oracle) gid=500(dba) groups=500(dba)
[oracle@ebs1 PROD1_ebs1]$ 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

回复只看该作者道具举报