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

Furher Log

ALTER DATABASE MOUNT

MMNL started with pid=12, OS id=4432

Wed Nov 16 18:49:19 2011

ORA-00202: control file: '/oracle/PRD/sapdata1/cntrl/cntrlPRD.dbf'

ORA-27037: unable to obtain file status

Linux-x86_64 Error: 2: No such file or directory

Additional information: 3

Wed Nov 16 18:49:19 2011

ORA-205 signalled during: ALTER DATABASE MOUNT...

Wed Nov 16 18:49:27 2011

Shutting down instance (abort)

License high water mark = 1

Instance terminated by USER, pid = 4433

Wed Nov 16 18:55:40 2011

Starting ORACLE instance (normal)

Wed Nov 16 18:55:40 2011

Specified value of sga_max_size is too small, bumping to 1191182336

LICENSE_MAX_SESSION = 0

LICENSE_SESSIONS_WARNING = 0

Picked latch-free SCN scheme 3

Autotune of undo retention is turned on.

Version: 10.2.0.4.0.

ALTER DATABASE MOUNT

Wed Nov 16 18:26:27 2011

ORA-00202: control file: '/oracle/PRD/sapdata1/cntrl/cntrlPRD.dbf'

ORA-27037: unable to obtain file status

Linux-x86_64 Error: 2: No such file or directory

Additional information: 3

Wed Nov 16 18:26:27 2011

ORA-205 signalled during: ALTER DATABASE MOUNT...

Wed Nov 16 18:27:46 2011

Shutting down instance (abort)

License high water mark = 1

Instance terminated by USER, pid = 4328

Wed Nov 16 18:49:18 2011

Former Member
0 Likes

> Wed Nov 16 18:49:19 2011

> ORA-00202: control file: '/oracle/PRD/sapdata1/cntrl/cntrlPRD.dbf'

> ORA-27037: unable to obtain file status

> Linux-x86_64 Error: 2: No such file or directory

> Additional information: 3

Does control file present at location '/oracle/PRD/sapdata1/cntrl/cntrlPRD.dbf' ?

Thanks

Sunny