Duplicate report ORA-01017 permission issue

Duplicate Report ORA-01017 permission issue

Environment:

OS: RedHat EnterPrise Linux 5.8 x64

Cluster: Oracle Grid 11.2.0.4

Database: Oracle Database EnterPrise 11.2.0.4

Archive: Rac+dg

today, in the process of configuring DG, the pre-environment is ready, and the last step is to duplicate the RAC data to the standby end, but the odd thing happens in this step, and try not to duplicate the data over a few times. Of course, I try to copy the Rman backup to the end can not be completed recovery, death or death reported ORA-01017 error, after a few hours of effort, the problem finally has been a better solution. For example, the following :

Failure Phenomena

Rmantarget sys/[email protected] Auxiliary sys/[email protected] Recoverymanager:release 11.2.0.4.0- Production on Mon May 16:14:36 Copyright (c) 1982, and Oracle and/or its affiliates. All rights reserved.connectedto target Database:jetdb (dbid=2170518470) connectedto auxiliary database:jetdb (not Mounte d) rman>duplicate target database for standby from active database Nofilenamecheck; Startingrestore at 26-may-14usingtarget database control file instead of recovery catalogallocatedchannel:ora_disk_ 1channelora_disk_1:sid=416 device Type=disk channelora_disk_1:restoring control filerman-00571:==================== =======================================rman-00569:=============== ERROR MESSAGE STACK follows =============== Rman-00571:===========================================================rman-03002:failure of Restore command at 05/ 26/2014 16:14:54ora-19870:error while restoring backup piece/dbbackup/phycal/stdb_cntl_0fp98vq2_1_1.bkpora-19504: Failed to CreaTe file "+data001/jetdb/controlfile/control01.ctl" Ora-17502:ksfdcre:3 Failed to create file +data001/jetdb/ Controlfile/control01.ctlora-15001:diskgroup "DATA001" does not exist or isn't mountedora-15055:unable to connect to ASM Instanceora-01017:invalid Username/password; Logon denied

Problem Analysis:

1, from the above alarm log, ORA-01017 can be very clearly seen because of the permissions problem caused.

Immediately, we start to check the password file of the repository, $ORACLE _home/dbs/orapw{sid} is present.

[Email protected] dbs]$ ll$oracle_home/dbs/orapw*-rw-r-----1 ORACLE oinstall 1536 may 2617:49/dbsoft/oracle/product/ 11.2.4/dbhome_1/dbs/orapwstandby

2, this time we should look at the database of the alter alarm file:

Errorsin file/dbsoft/oracle/diag/rdbms/standby/standby/trace/standby_asmb_11087.trc (incident=24130): ORA-00600: Internal error code, arguments: [osdep_internal], [], [], [], [], [], [], [],[], [], [], []ora-27302:failure occurred at: Skfnbeqopeniincidentdetails in:/dbsoft/oracle/diag/rdbms/standby/standby/incident/incdir_24130/standby_asmb_ 11087_i24130.trcuseadrci or support Workbench to the incident. See Note411.1 on My Oracle support for error and packaging details. Ora-00210:cannot Open the specified control Fileora-00202:control file: ' +data001/jetdb/controlfile/control01.ctl ' Ora-17503:ksfdopn:2 Failed to open file +data001/jetdb/controlfile/control01.ctlora-15001:diskgroup ' DATA001 ' does not exist or isn't mountedora-15055:unable to connect to ASM instanceora-15055:unable to connect to ASM Instanceora-00600:int Ernal error code, arguments: [osdep_internal], [], [], [], [], [], [], [],[], [], [], []ora-27302:failure occurred AT:SKF nbeqopeniora-1013signalled During:alter DATAbase MOUNT ... Mon May26 16:31:34 2014

from the alarm file, we can see very clearly thatASMThere is a problem with the disk. Enter intoGridusers underwithSrvctlcommand CheckASMStatus:

[Email protected]~]$ srvctl status asmasm isrunning on standby sql>select name,state,free_mb from V$asm_diskgroup; NAME       State          free_mb-------------------------------DATA001    mounted         121112arc001     mounted         122483bak001     mounted         122826

The result seemsASMand there's no problem, so the only thing that could go wrong isOracleWhere to configure the issue.

3, this time we should first look at whether it is the authority of the question:

[[email protected] ~]# ID oracleuid=501 (Oracle) gid=504 (oinstall) groups=504 (Oinstall), 505 (DBA) [[email protected] ~]# ID griduid=500 (GRID) gid=504 (Oinstall) groups=504 (Oinstall), 503 (Asmadmin), 506 (ASMDBA), 507 (Asmoper)

here, we find that the problem may be on the right now.

Oracle No ASMDBA permissions, and then add to it.

[[Email protected]~]# usermod-g 503,506 oracle[[email protected]~]# ID oracleuid=501 (Oracle) gid=504 (Oinstall) groups= 504 (Oinstall), 503 (Asmadmin), 505 (DBA), 506 (ASMDBA)

we can see for example the following. Run againDuplicate. Success:

[[email protected]~]$ Rman target sys/[email protected] Auxiliary sys/[email protected] Recoverymanager:release 11.2.0.4.0-production on Mon May 17:48:39 Copyright (c) 1982, +, Oracle and/or its AF Filiates. All rights reserved. Connectedto Target Database:jetdb (dbid=2170518470) connectedto auxiliary database:jetdb (not mounted) RMAN> Duplicate target database for standby from active database Nofilenamecheck; Startingduplicate Db at 26-may-14usingtarget database control file instead of recovery catalogallocatedchannel:ora_aux_d isk_1channelora_aux_disk_1:sid=122 device Type=disk contentsof Memory script:{Backup as copy Reuse TargetFile '/DBSo Ft/oracle/product/11.2.4/dbhome_1/dbs/orapwjetdb1 ' Auxiliaryformat '/dbsoft/oracle/product/11.2.4/dbhome_1/dbs/ Orapwstandby ';} Executingmemory Script startingbackup at 26-may-14allocatedchannel:ora_disk_1channelora_disk_1:sid=14 instance= JETDB1 device type=diskfinishedbackup at 26-may-14 contentsof Memory Script:{Backup as copy current Controlfile forstandby auxiliary format ' +data001/jetdb/controlfile/control01.ctl ';} Executingmemory Script startingbackup at 26-may-14usingchannel ora_disk_1channelora_disk_1:starting datafile Copycopyingstandby control Fileoutputfile name=+bak001/rman/snapcf_jetdb1.f tag=tag20140526t174956 RECID=11STAMP= 848598598channelora_disk_1:datafile copy complete, elapsed time:00:00:01finishedbackup at 26-may-14 contentsof Memory S cript:{SQL clone ' ALTER DATABASE Mount Standbydatabase '; Executingmemory Script sqlstatement:alter Database mount standby Databaserman-05529:warning:db_file_name_convert resulted in invalid ASM names; Names changed Todisk group only.   Contentsof Memory script:{set newname for Tempfile 1 to "+data001";   Switch clone tempfile all;   Set newname for datafile 1 to "+data001";   Set newname for datafile 2 to "+data001";   Set newname for DataFile 3 to "+data001";   Set newname for datafile 4 to "+data001"; Set newname for DaTafile 5 to "+data001"; Backup as Copy reuse datafile 1 auxiliary format "+data001" datafile 2 auxiliary format "+data001" DataFile 3 Auxili   ary format "+data001" datafile 4 auxiliary format "+DATA001" datafile 5 auxiliary format "+data001"; SQL ' alter system archive log current ';} Executingmemory Script executingcommand:set NEWNAME renamedtempfile 1 to +data001 in control file Executingcommand:set N Ewname executingcommand:set NEWNAME executingcommand:set NEWNAME executingcommand:set NEWNAME executingcommand:set NEW NAME startingbackup at 26-may-14usingchannel ora_disk_1channelora_disk_1:starting datafile copyinputdatafile file number=00001 Name=+data001/jetdb/datafile/system.268.848240089outputfile name=+data001/standby/datafile/ system.257.848598605 tag=tag20140526t175005channelora_disk_1:datafile copy complete, elapsed time: 00:00:15channelora_disk_1:starting datafile copyinputdatafile file number=00002 name=+data001/jetdb/datafile/ Sysaux.260.848240091outputfiLe name=+data001/standby/datafile/sysaux.258.848598619 tag=tag20140526t175005channelora_disk_1:datafile copy Complete, elapsed time:00:00:07channelora_disk_1:starting datafile copyinputdatafile file number=00003 name=+DATA001/ Jetdb/datafile/undotbs1.263.848240091outputfile name=+data001/standby/datafile/undotbs1.259.848598627tag= Tag20140526t175005channelora_disk_1:datafile copy complete, elapsed time:00:00:01channelora_disk_1:starting datafile copyinputdatafile file number=00005 name=+data001/jetdb/datafile/undotbs2.264.848240331outputfile name=+ Data001/standby/datafile/undotbs2.260.848598627tag=tag20140526t175005channelora_disk_1:datafile copy Complete, Elapsed time:00:00:01channelora_disk_1:starting datafile copyinputdatafile file number=00004 name=+DATA001/jetdb/ Datafile/users.267.848240091outputfile name=+data001/standby/datafile/users.261.848598629 tag= Tag20140526t175005channelora_disk_1:datafile copy complete, elapsed time:00:00:02finishedbackup at 26-may-14 SqlstatemeNt:alter System archive Log current contentsof Memory script:{switch clone datafile all;} Executingmemory Script Datafile1 switched to datafile copyinputdatafile copy recid=11 stamp=848598635 filename=+data001/ Standby/datafile/system.257.848598605datafile2 switched to datafile copyinputdatafile copy RECID=12 STAMP=848598635 File Name=+data001/standby/datafile/sysaux.258.848598619datafile3 switched to datafile copyinputdatafile copy RECID= stamp=848598635 Filename=+data001/standby/datafile/undotbs1.259.848598627datafile4 switched to DataFile Copyinputdatafile copy recid=14 stamp=848598635 file name=+data001/standby/datafile/users.261.848598629datafile5 Switched to datafile copyinputdatafile copy recid=15 stamp=848598635 filename=+data001/standby/datafile/ Undotbs2.260.848598627finishedduplicate Db at 26-may-14

Duplicate report ORA-01017 permission issue