OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » SPFILE problem

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

SPFILE problem [message #67563]

Mon, 11 October 2004 00:03

Naveen
Messages: 75
Registered: June 2001

Member

I have a small problem with creating the SPFILE, can someone help me ?

These are the commands i had issued :-

1. startup nomount
2. create SPFILE from PFILE ;

Then i got an error :-

ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file 'C:ORACLEORA92DATABASEINITORCL.ORA'

Ever since this happened i am unable to connect to ORACLE under any schema !

I get the following error : -

SQL> conn scott/tiger
ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist

Warning: You are no longer connected to ORACLE.

WHY DOES THIS HAPPEN AND HOW CAN I OVERCOME IT ?

Report message to a moderator

creating server parameter file [message #316595 is a reply to message #67563]

Sat, 26 April 2008 02:05

elsherbiny.ahmed
Messages: 2
Registered: September 2007

Junior Member

Dear Neveen
you are try to create spfile without determine the path of input pfile to deal with.

to continue without receiving any errors

SQL>create spfile from pfile='full path here';

or like you did

SQL> create SPFILE from PFILE ; "but in this case you must start the database 1st with any pfile (startup nomount pfile='full path';)so no error return.
----------------------------------------------------------
----------------------------------------------------------

ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist

The cause is the database is down & the SGA components does't allocated in the memory.

The default path for the parameter file

Report message to a moderator

Re: SPFILE problem [message #316600 is a reply to message #67563]

Sat, 26 April 2008 02:38

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

Senior Member
Account Moderator

Quote:

ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist

Previously you did:

Quote:

1. startup nomount

So database is not open.
Use:
alter database mount;
alter database open;
then you can connect as scott (if database is able to open)

Regards
Michel

Report message to a moderator

Re: SPFILE problem [message #316615 is a reply to message #67563]

Sat, 26 April 2008 09:24

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>2. create SPFILE from PFILE ;
The spfile can be created in any database state; down, mount, open ; as long as Oracle can find or is explicitly told where to find the appropriate pfile.

create SPFILE from PFILE='$ORACLE_HOME/dbs/newpfile.ora';

corrected minor typo in previous post

[Updated on: Sat, 26 April 2008 09:38] by Moderator

Report message to a moderator

Re: SPFILE problem [message #316618 is a reply to message #316615]

Sat, 26 April 2008 09:31

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

>>>The spfile can be created in any database state; down, mount, open ;
It should be PFILE (If database started with SPFILE).

Report message to a moderator

Re: SPFILE problem [message #316980 is a reply to message #67563]

Tue, 29 April 2008 01:25

pokhraj_das
Messages: 64
Registered: February 2008

Member

Hi,

You are trying to create spfile from pfile means there is no spfile at your server at this moment.

So start the instance by using the approprite pfile path.

sql> startup pfile='<path name?';

Then fire the below command:

sql> create spfile from pfile;

-------------------
----------------------
Error: ORA-27101
Text: shared memory realm does not exist

As you are not starting your instance by specifying the pfile oracle confused as how to Allocate the memory.

Report message to a moderator

Re: SPFILE problem [message #513333 is a reply to message #316980]

Sun, 26 June 2011 21:10

abhisheksolankicse12
Messages: 22
Registered: June 2011
Location: india

Junior Member

DEAR NAVEEN
I HAVE FACED THE SAME PROBE. TO GET OVER THIS DO AS FOLLOWS
SQL> CONNECT / AS SYSDBA;
CONNECTED TO AN IDLE INSTANCE
SQL> STARTUP PFILE='<PFILE PATH>'
(NOW U WILL BE IN OPEN DATABASE STATE)
SQL> CREATE SPFILE='<SPFILE PATH>'
FROM PFILE='<PFILE PATH>'
FILE CREATED
AND U R DONE....

BUT NOW WHEN YOU AGAIN STARTUP THE DATABASE AFTER SHUTDOWN IMMEDATE
SQL> SHUTDOWN IMMEDIATE;
SQL> CONNECT / AS SYSDBA;
SQL> STARTUP;
NOW TELL ME IF YOU ARE FACING ERRORS HERE ALSO AS
ORA-01078: failure in processing system parameters
LRM-00123: invalid character 0 found in the input file

Report message to a moderator

Re: SPFILE problem [message #513334 is a reply to message #513333]

Sun, 26 June 2011 21:32

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

oracle@bcm-laptop:/u01/app/oracle/product/11.2.0/dbhome_1/dbs$ sqlplus

SQL*Plus: Release 11.2.0.1.0 Production on Sun Jun 26 19:28:29 2011

Copyright (c) 1982, 2009, Oracle.  All rights reserved.

Enter user-name: / as sysdba

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> create pfile from spfile;

File created.

SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup pfile='initv112.ora';
ORACLE instance started.

Total System Global Area 1553305600 bytes
Fixed Size		    2213656 bytes
Variable Size		 1275070696 bytes
Database Buffers	  268435456 bytes
Redo Buffers		    7585792 bytes
Database mounted.
Database opened.
SQL> create spfile from pfile;

File created.

SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.

Total System Global Area 1553305600 bytes
Fixed Size		    2213656 bytes
Variable Size		 1275070696 bytes
Database Buffers	  268435456 bytes
Redo Buffers		    7585792 bytes
Database mounted.
Database opened.
SQL>

It works for me.

Report message to a moderator

Re: SPFILE problem [message #513347 is a reply to message #513333]

Sun, 26 June 2011 23:22

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

Senior Member
Account Moderator

1/ Do not post in UPPER case
2/ Use SQL*Plus and copy and paste your session, the WHOLE session.
3/ Please read OraFAQ Forum Guide and How to use [code] tags and make your code easier to read.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code, use code tags and align the columns in result.
Use the "Preview Message" button to verify.
4/ Always post your Oracle version, with 4 decimals.
5/ You have an invalid chr(0) character in your file

Regards
Michel

Report message to a moderator

Previous Topic:	Pfile very small(2 Merged)
Next Topic:	creating spfile from pfile error

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Jan 27 01:47:20 CST 2025