SQL> startup nomount
ORA-15124: ASM file name '+DATA/QA/CONTROLFILE/control01.ctl,+DATA/QA/CONTROLFILE/control02.ctl' contains an invalid alias name
Solution:
Change Control_files Entry: Single Quote each control file name separately.
Original:
*.control_files='+DATA/CONTROLFILE/control01.ctl,+DATA/CONTROLFILE/control02.ctl'
Correct One:
*.control_files='+DATA/CONTROLFILE/control01.ctl','+DATA/CONTROLFILE/control02.ctl'
Tuesday, June 21, 2016
Monday, June 20, 2016
Restore control file
SQL> startup
ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
ORACLE instance started.
Total System Global Area 4009738240 bytes
Fixed Size 2165512 bytes
Variable Size 2768246008 bytes
Database Buffers 1224736768 bytes
Redo Buffers 14589952 bytes
ORA-00214: control file '/dbfs/data2/ORCL/control02.ctl' version 2077610
inconsistent with file '/dbfs/data1/ORCL/control01.ctl' version 2090226
Solution:
Shutdown the database, then use correct control file to replace corrupted one.
ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
ORACLE instance started.
Total System Global Area 4009738240 bytes
Fixed Size 2165512 bytes
Variable Size 2768246008 bytes
Database Buffers 1224736768 bytes
Redo Buffers 14589952 bytes
ORA-00214: control file '/dbfs/data2/ORCL/control02.ctl' version 2077610
inconsistent with file '/dbfs/data1/ORCL/control01.ctl' version 2090226
Solution:
Shutdown the database, then use correct control file to replace corrupted one.
Oracle: Create Directory and Grant Access
create or replace directory oradir as '/path/to/destination';
GRANT READ,WRITE on directory ora_dir to public;
GRANT READ,WRITE on directory ora_dir to user1;
Subscribe to:
Posts (Atom)