Home » RDBMS Server » Server Administration » Error in identifying Controlfile
Error in identifying Controlfile [message #212889] Mon, 08 January 2007 14:44 Go to next message
plshelp
Messages: 205
Registered: January 2007
Senior Member
Hi,

When I start the instance, I get this error saying

startup pfile='/oracle92/oracle/product/9.2.0/dbs/initAR314V.ora'
ORACLE instance started.

Total System Global Area 694126376 bytes
Fixed Size 730920 bytes
Variable Size 385875968 bytes
Database Buffers 307200000 bytes
Redo Buffers 319488 bytes
ORA-00205: error in identifying controlfile, check alert log for more info

Please advise what the issue can be. In the initAR314V.ora, the path mentioned for control file is correct. So please help me with the problem is.

Thank you
Geetha
Re: Error in identifying Controlfile [message #212890 is a reply to message #212889] Mon, 08 January 2007 14:50 Go to previous messageGo to next message
BlackSwan
Messages: 25035
Registered: January 2009
Location: SoCal
Senior Member
>ORA-00205: error in identifying controlfile, check alert log for more info
So what is in the alert log file?
Re: Error in identifying Controlfile [message #212903 is a reply to message #212889] Mon, 08 January 2007 15:27 Go to previous messageGo to next message
plshelp
Messages: 205
Registered: January 2007
Senior Member
I had it fixed. I updated the correct path in the init file and now its fixed. But i am facing another problem now.

startup migrate pfile='/oracle92/oracle/product/9.2.0/dbs/initAR314V.ora'
ORACLE instance started.

Total System Global Area 694126376 bytes
Fixed Size 730920 bytes
Variable Size 385875968 bytes
Database Buffers 307200000 bytes
Redo Buffers 319488 bytes
ORA-01990: error opening password file
'/oracle92/oracle/product/9.2.0/dbs/orapw'
ORA-27037: unable to obtain file status
SVR4 Error: 2: No such file or directory
Additional information: 3

Please help me.

Thanks
Re: Error in identifying Controlfile [message #212905 is a reply to message #212903] Mon, 08 January 2007 15:32 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Have you verified '/oracle92/oracle/product/9.2.0/dbs/orapw' file exists?
Re: Error in identifying Controlfile [message #212906 is a reply to message #212889] Mon, 08 January 2007 15:37 Go to previous messageGo to next message
plshelp
Messages: 205
Registered: January 2007
Senior Member
I just did this after this:


SQL> host
$ cd $ORACLE_HOME
$ orapwd file=$ORACLE_HOME/dbs/orapwAR314V password=secret entries=5
$ exit

SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-07446: sdnfy: bad value '/oracle92/oracle/admin/AR314V/udump' for parameter
user_dump_dest.

Please help.
Thanks
Geetha
Re: Error in identifying Controlfile [message #212909 is a reply to message #212906] Mon, 08 January 2007 15:50 Go to previous message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Looks like you need to validate the entries in your init file. Verify the value for user_dump_dest and while you at it, verify the other entries in the file as well.

[Updated on: Mon, 08 January 2007 15:52]

Report message to a moderator

Previous Topic: Refresh database
Next Topic: what is difference between rowlevel trigger and statement level trigger
Goto Forum:
  


Current Time: Sat Dec 03 20:22:09 CST 2016

Total time taken to generate the page: 0.09985 seconds