Home » RDBMS Server » Server Administration » Oracle11G Database startup problem (Windows 2003 ENT 32 bit)
Oracle11G Database startup problem [message #445020] Thu, 25 February 2010 04:39 Go to next message
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

Re: Oracle11G Database startup problem [message #445024 is a reply to message #445020] Thu, 25 February 2010 05:10 Go to previous messageGo to next message
Michel Cadot
Messages: 63807
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
Re: Oracle11G Database startup problem [message #445094 is a reply to message #445020] Thu, 25 February 2010 21:29 Go to previous messageGo to next message
ramoradba
Messages: 2454
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
Re: Oracle11G Database start up problem [message #445103 is a reply to message #445094] Thu, 25 February 2010 22:32 Go to previous messageGo to next message
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 Go to previous messageGo to next message
ramoradba
Messages: 2454
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
Re: Oracle11G Database start up problem [message #445110 is a reply to message #445103] Thu, 25 February 2010 23:01 Go to previous messageGo to next message
BlackSwan
Messages: 24912
Registered: January 2009
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
Re: Oracle11G Database start up problem [message #445118 is a reply to message #445110] Thu, 25 February 2010 23:27 Go to previous messageGo to next message
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

Re: Oracle11G Database start up problem [message #445121 is a reply to message #445118] Thu, 25 February 2010 23:32 Go to previous messageGo to next message
Michel Cadot
Messages: 63807
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
Re: Oracle11G Database start up problem [message #445510 is a reply to message #445121] Tue, 02 March 2010 05:05 Go to previous messageGo to next message
halim
Messages: 100
Registered: September 2008
Senior Member

try to startup with pfile

like :

SQL> startup <pfile location> ;



regards
Halim
Re: Oracle11G Database start up problem [message #445514 is a reply to message #445510] Tue, 02 March 2010 05:20 Go to previous message
Michel Cadot
Messages: 63807
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
But read the topic: pfile itself is wrong.

Regards
Michel
Previous Topic: LMT tablespace
Next Topic: Database Sizing
Goto Forum:
  


Current Time: Wed Sep 28 14:21:47 CDT 2016

Total time taken to generate the page: 0.10935 seconds