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
Request clarification before answering.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
> 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
| User | Count |
|---|---|
| 5 | |
| 4 | |
| 4 | |
| 3 | |
| 2 | |
| 2 | |
| 2 | |
| 2 | |
| 2 | |
| 2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.