Hello Experts,
I have created database manually and it is created. After restart the database i am seeing the error:
SQL> startup
ORACLE instance started.
Total System Global Area 849530880 bytes
Fixed Size 1339824 bytes
Variable Size 499125840 bytes
Database Buffers 343932928 bytes
Redo Buffers 5132288 bytes
ORA-00205: error in identifying control file, check alert log for more info
Here my alert log
tail: cannot open `10' for reading: No such file or directory
==> alert_uat03.log <==
starting up 1 shared server(s) ...
ORACLE_BASE from environment = /opt/oracle
Sun Sep 27 09:10:14 2015
ALTER DATABASE MOUNT
ORA-00210: cannot open the specified control file
ORA-00202: control file: '/opt/oracle/product/11.2.0.1/dbhome/dbs/cntrluat03.dbf'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3
ORA-205 signalled during: ALTER DATABASE MOUNT...
How to fix it up?
Note: In pfile I have not added any controlfile path
Please read my question and revert back I have created new manual database. I don't have backup for it. while opening the database i am seeing this error.
Please check how many control file you have in database.
Check in your pfile edit tht control file parameter and check if that file exists in that same location or is there any changes need to be done and change that later start the database again with that updated control file and your done.