OraFAQ Forum: Server Administration » Oracle11G Database startup problem

Home » RDBMS Server » Server Administration » Oracle11G Database startup problem (Windows 2003 ENT 32 bit)

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

Oracle11G Database startup problem [message #445020]

Thu, 25 February 2010 04:39

ume_john
Messages: 6
Registered: February 2010

Junior Member

I had newly installed oracle 11g database, for tesitng & learning purpose.

Don't know wht happen to it after successfull installation , I am not able to start database.

Following error is appearing, need help to resolve this.

Ora-01078:failure in processing system parameters

I can do only login to idle instance.

Rgards

Umesh

Report message to a moderator

Re: Oracle11G Database startup problem [message #445024 is a reply to message #445020]

Thu, 25 February 2010 05:10

Michel Cadot
Messages: 68647
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

ORA-01078: failure in processing system parameters
 *Cause:  Failure during processing of INIT.ORA parameters during
            system startup.
 *Action:  Further diagnostic information should be in the error stack.

Regards
Michel

Report message to a moderator

Re: Oracle11G Database startup problem [message #445094 is a reply to message #445020]

Thu, 25 February 2010 21:29

ramoradba
Messages: 2456
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...

Senior Member

Quote:

By Brian Peasland, Database Administrator, SGT, Inc.
"ORA-01078: failure in processing system parameters."
You should get Quote:
LRM-00109: could not open parameter file 'File name and path'

Just the error message is not a lot of information to go on. I'm assuming that you were attempting to start your database when you received this error. The ORA-1078 error is indicating that parameters in your PFILE or SPFILE are incorrect. You might have spelled the parameter name incorrectly or the parameter has been given incorrect values. Correct the parameter file and your database should be able to start.

sriram

Report message to a moderator

Re: Oracle11G Database start up problem [message #445103 is a reply to message #445094]

Thu, 25 February 2010 22:32

ume_john
Messages: 6
Registered: February 2010

Junior Member

I had tried to correct spfile , after which following message is appearing.
SQL> startup;
ORA-01078: failure in processing system parameters
LRM-00116: syntax error at '285212672testorc' following '='
SQL>

Tell me how to resolve this.

Umesh Bhosale.

[Updated on: Thu, 25 February 2010 23:19]

Report message to a moderator

Re: Oracle11G Database start up problem [message #445106 is a reply to message #445103]

Thu, 25 February 2010 22:36

ramoradba
Messages: 2456
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...

Senior Member

ume_john wrote on Fri, 26 February 2010 10:02

I had tried to correct spfile , after which following message is appearing.
Tell me how to resolve this.

Umesh Bhosale.

But i am un able to see what/how you tried... and what you get after that.

sriram Smile

Report message to a moderator

Re: Oracle11G Database start up problem [message #445110 is a reply to message #445103]

Thu, 25 February 2010 23:01

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

spfile is not human readable so we need to see the content of the pfile.

please do the following

cd $ORACLE_HOME/dbs
sqlplus
create pfile from spfile;
exit

there should be a new file with the name like the following
init<SID>.ora

please post content of new pfile

Report message to a moderator

Re: Oracle11G Database start up problem [message #445118 is a reply to message #445110]

Thu, 25 February 2010 23:27

ume_john
Messages: 6
Registered: February 2010

Junior Member

Contents of Pfile is given below,

testorcl.__db_cache_size=285212672testorcl.__java_pool_size=12582912testorcl.__large_pool_size=4194304testorcl.__oracle_base='E:\Supp ort\oracle\Ora11gapp\administrator'#ORACLE_BASE set from environmenttestorcl.__pga_aggregate_target=322961408testorcl.__sga_target=536870912testorcl.__shared_io_pool_size=0testorcl.__shared_ pool_size=226492416testorcl.__streams_pool_size=0*.audit_file_dest='E:\Support\oracle\Ora11gapp\administrator\admin\testorcl\adump'*. audit_trail='db'*.compatible='11.1.0.0.0'*.control_files='E:\Support\oracle\Ora11gapp\administrator\oradata\testorcl\control01.ctl',' E:\Support\oracle\Ora11gapp\administrator\oradata\testorcl\control02.ctl','E:\Support\oracle\Ora11gapp\administrator\oradata\testorcl \control03.ctl'*.db_block_size=8192*.db_domain=''*.db_name='testorcl'*.db_recovery_file_dest='E:\Support\oracle\Ora11gapp\administrat or\flash_recovery_area'*.db_recovery_file_dest_size=2147483648*.diagnostic_dest='E:\Support\oracle\Ora11gapp\administrator'*.dispatch ers='(PROTOCOL=TCP) (SERVICE=testorclXDB)'*.local_listener='LISTENER_TESTORCL'*.memory_target=857735168*.open_cursors=300*.processes=150*.remote_login_pa sswordfile='EXCLUSIVE'*.undo_tablespace='UNDOTBS1'

locate where the error is.

Umesh

Report message to a moderator

Re: Oracle11G Database start up problem [message #445121 is a reply to message #445118]

Thu, 25 February 2010 23:32

Michel Cadot
Messages: 68647
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

First put a new line before each parameter (which begins with "testorcl" or "*.").

Regards
Michel

Report message to a moderator

Re: Oracle11G Database start up problem [message #445510 is a reply to message #445121]

Tue, 02 March 2010 05:05

halim
Messages: 100
Registered: September 2008

Senior Member

try to startup with pfile

like :

SQL> startup <pfile location> ;

regards
Halim

Report message to a moderator

Re: Oracle11G Database start up problem [message #445514 is a reply to message #445510]

Tue, 02 March 2010 05:20

Michel Cadot
Messages: 68647
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

But read the topic: pfile itself is wrong.

Regards
Michel

Report message to a moderator

Previous Topic:	LMT tablespace
Next Topic:	Database Sizing

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Apr 30 18:54:16 CDT 2024