- 最后登录
- 2014-12-4
- 在线时间
- 9 小时
- 威望
- 0
- 金钱
- 48
- 注册时间
- 2013-4-11
- 阅读权限
- 10
- 帖子
- 20
- 精华
- 0
- 积分
- 0
- UID
- 1035
|
1#
发表于 2014-12-3 15:30:32
|
查看: 7580 |
回复: 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>
|
|