Oracle数据库数据恢复、性能优化

找回密码
注册
搜索
热搜: 活动 交友 discuz
发新帖

0

积分

1

好友

8

主题
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>

5#
发表于 2014-12-3 16:37:29
本帖最后由 zndavid 于 2014-12-3 17:08 编辑

两个节点sqlplus as sysasm  strace文件

strace ebs1.TXT

50.46 KB, 下载次数: 1499

strace ebs2.TXT

43.78 KB, 下载次数: 1484

回复 只看该作者 道具 举报

4#
发表于 2014-12-3 16:26:50

SQL> select * from v$pwfile_users;

USERNAME                       SYSDB SYSOP SYSAS
------------------------------ ----- ----- -----
SYS                            TRUE  TRUE  TRUE

回复 只看该作者 道具 举报

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

回复 只看该作者 道具 举报

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

回复 只看该作者 道具 举报

您需要登录后才可以回帖 登录 | 注册

QQ|手机版|Archiver|Oracle数据库数据恢复、性能优化

GMT+8, 2024-12-21 03:52 , Processed in 0.049660 second(s), 24 queries .

Powered by Discuz! X2.5

© 2001-2012 Comsenz Inc.

回顶部
TEL/電話+86 13764045638
Email service@parnassusdata.com
QQ 47079569