cancel
Showing results for 
Search instead for 
Did you mean: 
Subscribe

Dear Experts,

we are using Oracle 10g on RHEL5.4 64Bit ecc 6.0 with eph 4 i have moved all my sap data files along with Temp file.

when i startup my database getting error.

SQL> startup mount

ORACLE instance started.

Total System Global Area 535662592 bytes

Fixed Size 1334380 bytes

Variable Size 306185108 bytes

Database Buffers 222298112 bytes

Redo Buffers 5844992 bytes

ORA-00205: error in identifying control file, check alert log for more info

when i checked initSID.ora then found old location of control file.

1)/oracle/SID/sapdata1/cntrl

2)/oracle/SID/origlogA/cntrl

3)/oracle/SID/origlogB/cntrl

i have manually changed location of control file.

1)/oracle/SID/sapdata10/cntrl

2)/oracle/SID/origlogA/cntrl

3)/oracle/SID/origlogB/cntrl

SQL> Create Pfile from Spfile;

File Created.

i would like to mount my database from Pfile plese help me i execute scripts below.

SQL> STARTUP MOUNT=/oracle/SID/ORACLE_HOME/dbs/initSID.ora

invalid startup option.

or suggest me some other way so that i can startup my Database.

with Regards

0 Likes
View Entire Topic
Former Member
0 Likes

Dear Experts,

>

> we are using Oracle 10g on RHEL5.4 64Bit ecc 6.0 with eph 4 i have moved all my sap data files along with Temp file.

>

> when i startup my database getting error.

You should not move any files manually because control file has location of all files. If you move it manually then control file will not recognize it. This process is not supported.

Thanks

Sunny