OraFAQ Forum: Server Administration » creating spfile from pfile error

Home » RDBMS Server » Server Administration » creating spfile from pfile error (xp 2000)

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

creating spfile from pfile error [message #513285]

Sat, 25 June 2011 19:37

abhisheksolankicse12
Messages: 22
Registered: June 2011
Location: india

Junior Member

whenever i tried to create spfile from pfile i got this error...
.
oracle not available and shared memory realme does not exist

please help me out to solve this problem......

Attachment: my probe.txt
(Size: 0.37KB, Downloaded 1159 times)

[Updated on: Sat, 25 June 2011 19:45]

Report message to a moderator

Re: creating spfile from pfile error [message #513286 is a reply to message #513285]

Sat, 25 June 2011 19:47

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

SQL> CREATE SPFILE FROM PFILE;
what results from above?

>It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/

are you logged onto OS as same OS user that owns the Oracle software?

Are both ORACLE_HOME & ORACLE_SID defined in registry?

[Updated on: Sat, 25 June 2011 19:56]

Report message to a moderator

Re: creating spfile from pfile error [message #513287 is a reply to message #513286]

Sat, 25 June 2011 20:37

abhisheksolankicse12
Messages: 22
Registered: June 2011
Location: india

Junior Member

sorry to say but i have only one user account and that is the same from which i access the oracle sql plus....

and i dont know about the registry setting... if you can tell me then i'll be highly obliged.

and the error was
ora-01078: failure in processing the system parameter
ora-00109:could not open parameter file
'f:\oracle\product\10.1.0\db_1\databse\initorcl1.ora'

[Updated on: Sat, 25 June 2011 20:46]

Report message to a moderator

Re: creating spfile from pfile error [message #513288 is a reply to message #513287]

Sat, 25 June 2011 20:40

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

sqlplus
/ as sysdba
create spfile from pfile;
startup;
exit

It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/

Report message to a moderator

Re: creating spfile from pfile error [message #513289 is a reply to message #513288]

Sat, 25 June 2011 20:48

abhisheksolankicse12
Messages: 22
Registered: June 2011
Location: india

Junior Member

and the errors were
ora-01078: failure in processing the system parameter
ora-00109:could not open parameter file
'f:\oracle\product\10.1.0\db_1\databse\initorcl1.ora'

and i have already tried what u have replied but it still not working.... please help me.. Sad

Report message to a moderator

Re: creating spfile from pfile error [message #513290 is a reply to message #513289]

Sat, 25 June 2011 20:58

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

open Command Window & do as below

dir f:\oracle\product\10.1.0\db_1\databse\

COPY command & results then PASTE all back here

Is "databse" above is error?

should it be "database"?

[Updated on: Sat, 25 June 2011 20:59]

Report message to a moderator

Re: creating spfile from pfile error [message #513293 is a reply to message #513289]

Sat, 25 June 2011 22:56

muzahid
Messages: 281
Registered: September 2004
Location: Dhaka, Bangladesh

Senior Member

abhisheksolankicse12 wrote on Sun, 26 June 2011 07:48

and the errors were
ora-01078: failure in processing the system parameter
ora-00109:could not open parameter file
'f:\oracle\product\10.1.0\db_1\databse\initorcl1.ora'

Is it ora-00109 or LRM-00109?

Report message to a moderator

Re: creating spfile from pfile error [message #513326 is a reply to message #513293]

Sun, 26 June 2011 20:45

abhisheksolankicse12
Messages: 22
Registered: June 2011
Location: india

Junior Member

THANX FOR SUPPORTING....
it was LRM.
but what is the difference between ORA ERROR AND LRM ERROR???
and i hv successed in creating spfile from pfile
but now when i am trying to open database after shutdown immediate,its giving followng error.

SQL> shutdown immediate;
SQL> connect / as sysdba;
connected to an idle instance
SQL> startup;
ORA-01078: failure in processing system parameters
LRM-00123: invalid character 0 found in the input file
SQL> Embarassed

[Updated on: Sun, 26 June 2011 20:47]

Report message to a moderator

Re: creating spfile from pfile error [message #513331 is a reply to message #513326]

Sun, 26 June 2011 20:59

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

1078, 00000, "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.
bcm@bcm-laptop:~$ oerr LRM 123
123, 0, "invalid character %u found in the input file"
// *Cause: A character that is invalid was found in the input file.
// *Action: Specify an input file that contains only valid characters.

the "oerr" utility exists for *NIX, but not for Windows

bcm@bcm-laptop:~$ oerr
Usage: oerr facility error

Facility is identified by the prefix string in the error message.
For example, if you get ORA-7300, "ora" is the facility and "7300"
is the error.  So you should type "oerr ora 7300".

If you get LCD-111, type "oerr lcd 111", and so on.

ORA are standard Oracle errors
I am not sure what/which facility throw LRM errors; but it appears to be rather low level.

Report message to a moderator

Re: creating spfile from pfile error [message #513343 is a reply to message #513331]

Sun, 26 June 2011 22:44

muzahid
Messages: 281
Registered: September 2004
Location: Dhaka, Bangladesh

Senior Member

Please see the alert_<SID>.log file.

Report message to a moderator

Re: creating spfile from pfile error [message #513349 is a reply to message #513326]

Sun, 26 June 2011 23:25

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

Senior Member
Account Moderator

abhisheksolankicse12 wrote on Mon, 27 June 2011 03:45

THANX FOR SUPPORTING....
it was LRM.
but what is the difference between ORA ERROR AND LRM ERROR???
and i hv successed in creating spfile from pfile
but now when i am trying to open database after shutdown immediate,its giving followng error.

SQL> shutdown immediate;
SQL> connect / as sysdba;
connected to an idle instance
SQL> startup;
ORA-01078: failure in processing system parameters
LRM-00123: invalid character 0 found in the input file
SQL>

Do NOT post the same question in different hijacked topics, now we have the same question from you and different answers in several topics and no one can profit of a wrap-up.
Please read OraFAQ Forum Guide.

Regards
Michel

Report message to a moderator

Previous Topic:	SPFILE problem
Next Topic:	DIFFERENCE BETWEEN LRM AND ORA ERROR(2 Merged)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed May 01 22:42:07 CDT 2024