OraFAQ Forum: Server Administration » Error in identifying Controlfile

Home » RDBMS Server » Server Administration » Error in identifying Controlfile

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Error in identifying Controlfile [message #212889]

Mon, 08 January 2007 14:44

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

Report message to a moderator

Re: Error in identifying Controlfile [message #212890 is a reply to message #212889]

Mon, 08 January 2007 14:50

BlackSwan
Messages: 26766
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?

Report message to a moderator

Re: Error in identifying Controlfile [message #212903 is a reply to message #212889]

Mon, 08 January 2007 15:27

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

Report message to a moderator

Re: Error in identifying Controlfile [message #212905 is a reply to message #212903]

Mon, 08 January 2007 15:32

ebrian
Messages: 2794
Registered: April 2006

Senior Member

Have you verified '/oracle92/oracle/product/9.2.0/dbs/orapw' file exists?

Report message to a moderator

Re: Error in identifying Controlfile [message #212906 is a reply to message #212889]

Mon, 08 January 2007 15:37

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

Report message to a moderator

Re: Error in identifying Controlfile [message #212909 is a reply to message #212906]

Mon, 08 January 2007 15:50

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 15:37:44 CDT 2024