OraFAQ Forum: Server Administration » database cant be started

Home » RDBMS Server » Server Administration » database cant be started

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

database cant be started [message #556507]

Mon, 04 June 2012 22:58

priteshranjan.preet
Messages: 131
Registered: April 2012
Location: delhi

Senior Member

i m facing a problem in my databse when going to startup.
sql> startup
ora:00824- can not set sga_target due to existing inernal setting see alert log for more information .
when i checked the alert log file i found

cannot set sga_target with statistics_level=basic.
acutally last time i change the parameter statistics_level=basic scope=spfile (typical to basic).now my database is not open.what can i do to startup the database.I have no any type of backup

please help me to shot out the problem.

thanks & regards
pritesh ranjan

Report message to a moderator

Re: database cant be started [message #556508 is a reply to message #556507]

Mon, 04 June 2012 23:02

priteshranjan.preet
Messages: 131
Registered: April 2012
Location: delhi

Senior Member

os rhel 4 oracle 10.2.0.1.0(oracle 10g)

Report message to a moderator

Re: database cant be started [message #556509 is a reply to message #556508]

Mon, 04 June 2012 23:10

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Start in nomount mode and change back the parameter to TYPICAL and then mount and open the database.

Regards
Michel

Report message to a moderator

Re: database cant be started [message #556511 is a reply to message #556509]

Mon, 04 June 2012 23:48

priteshranjan.preet
Messages: 131
Registered: April 2012
Location: delhi

Senior Member

when startup in nomount mode it give the following error.

sql> startup nomount

ora-01078:faliure in processing system parameters
LMR-00109:could not open parameter file '/u01/app/oracle/product/10.2.0/db_1/dbs/initorcl.ora';

but when i start the database with the following command

sql>STARTUP PFILE='/u01/app/oracle/admin/orcl/pfile/init.ora.3102010057'

then it is starting and work fine every thing but when shutdown the database and startup again without specifying the pfile location that i maintain above the problem is same.after starting the database run the command

alter system set statistics_level=typical;

database alterred.
if define scope=spfile then it gives error.

regards
pritesh ranjan

Report message to a moderator

Re: database cant be started [message #556512 is a reply to message #556511]

Mon, 04 June 2012 23:54

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

SQL> create spfile from PFILE='/u01/app/oracle/admin/orcl/pfile/init.ora.3102010057' ;
SQL> STARTUP

[Updated on: Mon, 04 June 2012 23:55]

Report message to a moderator

Re: database cant be started [message #556514 is a reply to message #556512]

Tue, 05 June 2012 00:09

priteshranjan.preet
Messages: 131
Registered: April 2012
Location: delhi

Senior Member

many many thanks to your response i just create the spfile in the location /u01/app/........../dbs/spfileORCL.ora from pfile location PFILE='/u01/app/oracle/admin/orcl/pfile/init.ora.3102010051' and now it work fine.

thanks & regards
pritesh ranjan

Report message to a moderator

Previous Topic:	How can FGA audit the statements of sysdba
Next Topic:	Want To tablespace Autoextend OFF?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 29 02:45:56 CST 2024