Error during database startup
ORA-00221: error on write to control fileORA-00206: error in writing (block 1, # blocks 1) of control file
ORA-00202: control file: '/oracle/DQ1/sapdata1/cntrl/cntrlDQ1.dbf'
ORA-27041: unable to open file
Linux-x86_64 Error: 13: Permission denied
Additional information: 3
ORA-01110: data file 1: '/oracle/DQ1/sapdata1/system_1/system.data1'
ORA-01114: IO error writing block to file 1 (block # 1)
ORA-27041: unable to open file
Linux-x86_64 Error: 13: Permission denied
Additional information: 3
Cause:
Incorrect file permissions for database files / control files
Solution:
$ chown -R oracle:oinstall sapdata*
Error during database startup
ORA-09925: Unable to create audit trail file
Linux-x86_64 Error: 13: Permission denied
Additional information: 9925
Cause #1:
Incorrect file permissions for SAPTRACE directory
Solution #1:
$ chown -R oracle:oinstall saptrace
Cause #2:
Incorrect audit trace file destination
Solution #2:
Check database parameter audit_file_dest in SPFILE and set to correct value
Cause #3:
No write permissions in default audit file destinations.
<ORACLE_BASE>/admin/<ORACLE_SID>/adump directory does not exist
Solution #3:
Create default audit file destinations with correct permissions for oracle:oinstall
[root]# cd <ORACLE_BASE>
[root]# mkdir -p admin/<ORACLE_SID>/adump
[root]# chown -R oracle:oinstall admin/<ORACLE_SID>/adump
1st default: <ORACLE_BASE>/admin/<ORACLE_SID>/adump
2nd default: <ORACLE_HOME>/rdbms/audit
3rd default: AUDIT_FILE_DEST (only when instance is started)
Error during database startup
ORA-00221: error on write to control file
ORA-00206: error in writing (block 1, # blocks 1) of control file
ORA-00202: control file: '/oracle/DQ1/origlogA/cntrl/cntrlDQ1.dbf'
ORA-27041: unable to open file
Linux-x86_64 Error: 13: Permission denied
Additional information: 3
Cause:
Incorrect file permissions for redo log files / control files
Solution:
$ chown -R oracle:oinstall origlog*
$ chown -R oracle:oinstall mirrlog*
Error during database operation
Mon Sep 15 16:09:01 2014
ARCH: Archival stopped, error occurred. Will continue retrying
ORACLE Instance DQ1 - Archival Error
ORA-16038: log 1 sequence# 65 cannot be archived
ORA-19504: failed to create file ""
ORA-00312: online log 1 thread 1: '/oracle/DQ1/origlogA/log_g11m1.dbf'
ORA-00312: online log 1 thread 1: '/oracle/DQ1/mirrlogA/log_g11m2.dbf'
ARCH: Archival stopped, error occurred. Will continue retrying
ORACLE Instance DQ1 - Archival Error
ORA-16014: log 1 sequence# 65 not archived, no available destinations
ORA-00312: online log 1 thread 1: '/oracle/DQ1/origlogA/log_g11m1.dbf'
ORA-00312: online log 1 thread 1: '/oracle/DQ1/mirrlogA/log_g11m2.dbf'
Cause:
Incorrect file permissions for archive destination
Solution
$ chown -R oracle:oinstall oraarch
Error during clone Oracle Home operation
% ./config04_clone_oh.sh
DESCRIPTION: This script runs the clone command (clone.pl) for the Oracle home.
Cloning Oracle home /oracle/QO1/112_64
./config04_clone_oh.sh[56]: /oracle/QO1/112_64/clone/bin/clone.pl: cannot execute
OUI finished with return code 126
%
Cause:
Incorrect ownership of files in Oracle Home.
Files in Oracle home still belong to ora<dbsid>, not to 'oracle'.
The script config03_set_swowner.sh did not recursively change
the ownership to 'oracle' because variable C_ORACLE_HOME uses
the Runtime Oracle Home <OHRDBMS> instead of Installation Oracle Home <IHRDBMS>.
% ls -l /oracle/QO1/112_64/clone/bin/clone.pl
-rwxr-xr-x 1 oraqo1 dba 17067 Mar 16 2011 /oracle/QO1/112_64/clone/bin/clone.pl
%
Solution #1:
Check config03_set_swowner.sh and change C_ORACLE_HOME to Installation Oracle Home
Example: config03_set_swowner.sh
#export C_ORACLE_HOME=/oracle/<SID>/112_64
export C_ORACLE_HOME=/oracle/<SID>/11204
Rerun the script.
% ls -l /oracle/QO1/112_64/clone/bin/clone.pl
ls -l /oracle/QO1/112_64/clone/bin/clone.pl
-rwxr-xr-x 1 oracle oinstall 17067 Mar 16 2011 /oracle/QO1/112_64/clone/bin/clone.pl
%
Solution #2:
Rerun the assistant 'clone_assistant.sh'. When you enter the path for Oracle home, make sure
that you use the <IHRDBMS>, not the <OHRDBMS>.
0 comments:
Post a Comment