Home » RDBMS Server » Server Administration » SPFILE problem
SPFILE problem [message #67563] Mon, 11 October 2004 00:03 Go to next message
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 ?
creating server parameter file [message #316595 is a reply to message #67563] Sat, 26 April 2008 02:05 Go to previous messageGo to next message
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
Re: SPFILE problem [message #316600 is a reply to message #67563] Sat, 26 April 2008 02:38 Go to previous messageGo to next message
Michel Cadot
Messages: 64140
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: SPFILE problem [message #316615 is a reply to message #67563] Sat, 26 April 2008 09:24 Go to previous messageGo to next message
BlackSwan
Messages: 25046
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 Go to previous messageGo to next message
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).
Re: SPFILE problem [message #316980 is a reply to message #67563] Tue, 29 April 2008 01:25 Go to previous messageGo to next message
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.



Re: SPFILE problem [message #513333 is a reply to message #316980] Sun, 26 June 2011 21:10 Go to previous messageGo to next message
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
Re: SPFILE problem [message #513334 is a reply to message #513333] Sun, 26 June 2011 21:32 Go to previous messageGo to next message
BlackSwan
Messages: 25046
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.
Re: SPFILE problem [message #513347 is a reply to message #513333] Sun, 26 June 2011 23:22 Go to previous message
Michel Cadot
Messages: 64140
Registered: March 2007
Location: Nanterre, France, http://...
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
Previous Topic: Pfile very small(2 Merged)
Next Topic: creating spfile from pfile error
Goto Forum:
  


Current Time: Fri Dec 09 06:00:18 CST 2016

Total time taken to generate the page: 0.08623 seconds