Share |

ORA-01078: failure in processing system parameters

There was an incorrect parameter specified in the startup file for Oracle (init.ora).

Remove the incorrect parameter or value from the init file and restart the database.

Usually the init file can be found in your %ORACLE_HOME%\database (Windows) or $ORACLE_HOME/dbs (Unix) directory.

It might be that this pfile links to antoher pfile (ifile=) or spfile (spfile=). Just follow the location to find the correct startup file.

Should you be using an spfile instead of a pfile, you can create a pfile using following command:
create pfile from spfile;
This pfile will be created in the default destination, as specified above.

 Related Oracle Parameters 
server parameter file
 Was this information helpful?  Yes No
If it was not helpful, please take some time to explain why. This is not to ask questions, you can do so in the forum.

Welcome to our forum for Oracle error: ORA-01078 Add your own message



You are starting the database with a normal pfile.
Does the file in the location specified in the error message exist?

If you only have an spfile, try to start the database with startup spfile='path to spfile'
SQL> connect / as sysdba
Connected to an idle instance.
SQL> startup nomount
ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file 'C:\ORACLE\PRODUCT\10.2.0\DB_1\DATABASE
\INITLLOYDSRMAN.ORA'
 
hi dears !

i wana to create a spread database for RMAN catalog so to create database manually,i copied the pfile from target database (i.e 'mydb' in e:\oracle\database) then i maked some changes in pfile for my new database(i.e 'catdb' in d:\catdb\ora92\database\initcatdb.ora).After maked some changes in pfile i had set the Environment variable on command prompt(WIN XP) i.e "c:>set oracle_sid=catdb"
after it
c:>sqlplus /nolog
.....
.....
idele connection

but when i apply following statement then this error generated...plz tell me the steps create new mannually database..and what i do if i already have an instance?and is it necessary that i create listner by "GUI Assistance" or it is good if i just copy the listner file and make some changes on it like service name? and plz tell me same for TNS.ora file

SQL> startup nomount pfile=D:\catdb\ora92\database\INITcatdb.ora
LRM-00109: could not open parameter file 'D:\catdb\ora92\database\INITcatdb.ora'

ORA-01078: failure in processing system parameters

 
SQL> startup
ORA-01078: failure in processing system parameters
SQL> create pfile from spfile;

File created.

SQL> startup immediate;
SP2-0714: invalid combination of STARTUP options
SQL> startup
ORA-01078: failure in processing system parameters
SQL> startup pfile='init.ora';
LRM-00109: could not open parameter file 'init.ora'
ORA-01078: failure in processing system parameters
SQL> startup pfile='initorcl.ora'
LRM-00109: could not open parameter file 'initorcl.ora'
ORA-01078: failure in processing system parameters
Check you pfile, there is a parameter that is not correct.

Your pfile will have the name init.ora, check for it in the appropriate destination (depending if you're on Linux or Windows).

 
Enter user-name: / as sysdba
Connected to an idle instance.

SQL> startup
ORA-01078: failure in processing system parameters
SQL> startup pfile='F:\app\samraj\product\11.1.0\db_1\database\INITorcl.ora';

ORA-01078: failure in processing system parameters
SQL> create pfile from spfile
2 ;

File created.

SQL> startup pfile='F:\app\samraj\product\11.1.0\db_1\database\INITorcl.ora';

ORA-01078: failure in processing system parameters
Can you please post the content of F:\app\samraj\product\11.1.0\db_1\database\INITorcl.ora
 
orcl.__db_cache_size=306184192
orcl.__java_pool_size=12582912
orcl.__large_pool_size=4194304
orcl.__oracle_base='F:\app\samraj'#ORACLE_BASE set from environment
orcl.__pga_aggregate_target=322961408
orcl.__sga_target=536870912
orcl.__shared_io_pool_size=0
orcl.__shared_pool_size=201326592
orcl.__streams_pool_size=4194304
*.audit_file_dest='F:\app\samraj\admin\orcl\adump'
*.audit_trail='DB_EXTENDED','EXTENDED'
*.compatible='11.1.0.0.0'
*.control_files='F:\app\samraj\oradata\orcl\control01.ctl','F:\app\samraj\oradata\orcl\control02.ctl','F:\app\samraj\oradata\orcl\control03.ctl'
*.db_block_size=8192
*.db_domain=''
*.db_flashback_retention_target=10
*.db_name='orcl'
*.db_recovery_file_dest='F:\app\samraj\flash_recovery_area'
*.db_recovery_file_dest_size=3221225472
*.diagnostic_dest='F:\app\samraj'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=orclXDB)'
*.memory_target=857735168
*.open_cursors=300
*.processes=150
*.remote_login_passwordfile='EXCLUSIVE'
*.undo_tablespace='UNDOTBS1'
The value for audit_trail is incorrect, change it in the pfile to DB,EXTENDED.
Next, execute following command:
create spfile from pfile;

Remove the initorcl.ora and restart the instance
 
i cant edit INITorcl.ora file....it saying that
you cannot modify a read-only file
what to do
You might need to stop the OracleORCL service before you can edit it.
Or your user might not have the necessary privileges to edit the file, use a user with administrative privileges.
 
RMAN> restore database;

Starting restore at 22-JUN-09
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=115 device type=DISK

channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_DISK_1: restoring datafile 00001 to F:\APP\SAMRAJ\ORADATA\ORCL\SYSTE
M01.DBF
channel ORA_DISK_1: restoring datafile 00002 to F:\APP\SAMRAJ\ORADATA\ORCL\SYSAU
X01.DBF
channel ORA_DISK_1: restoring datafile 00003 to F:\APP\SAMRAJ\ORADATA\ORCL\UNDOT
BS01.DBF
channel ORA_DISK_1: restoring datafile 00004 to F:\APP\SAMRAJ\ORADATA\ORCL\USERS
01.DBF
channel ORA_DISK_1: restoring datafile 00005 to F:\APP\SAMRAJ\ORADATA\ORCL\EXAMP
LE01.DBF
channel ORA_DISK_1: reading from backup piece F:\APP\SAMRAJ\FLASH_RECOVERY_AREA\
ORCL\BACKUPSET\2009_06_22\O1_MF_NNNDF_TAG20090622T111239_53Y6GYTC_.BKP
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 06/22/2009 13:20:06
ORA-19870: error while restoring backup piece F:\APP\SAMRAJ\FLASH_RECOVERY_AREA\
ORCL\BACKUPSET\2009_06_22\O1_MF_NNNDF_TAG20090622T111239_53Y6GYTC_.BKP
ORA-19573: cannot obtain exclusive enqueue for datafile 1
Can it be that our database is still open while you are trying to restore it?
If so, shutdown the database
 
RMAN> restore database;

Starting restore at 22-JUN-09
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=115 device type=DISK

channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_DISK_1: restoring datafile 00001 to F:\APP\SAMRAJ\ORADATA\ORCL\SYSTE
M01.DBF
channel ORA_DISK_1: restoring datafile 00002 to F:\APP\SAMRAJ\ORADATA\ORCL\SYSAU
X01.DBF
channel ORA_DISK_1: restoring datafile 00003 to F:\APP\SAMRAJ\ORADATA\ORCL\UNDOT
BS01.DBF
channel ORA_DISK_1: restoring datafile 00004 to F:\APP\SAMRAJ\ORADATA\ORCL\USERS
01.DBF
channel ORA_DISK_1: restoring datafile 00005 to F:\APP\SAMRAJ\ORADATA\ORCL\EXAMP
LE01.DBF
channel ORA_DISK_1: reading from backup piece F:\APP\SAMRAJ\FLASH_RECOVERY_AREA\
ORCL\BACKUPSET\2009_06_22\O1_MF_NNNDF_TAG20090622T111239_53Y6GYTC_.BKP
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 06/22/2009 13:20:06
ORA-19870: error while restoring backup piece F:\APP\SAMRAJ\FLASH_RECOVERY_AREA\
ORCL\BACKUPSET\2009_06_22\O1_MF_NNNDF_TAG20090622T111239_53Y6GYTC_.BKP
ORA-19573: cannot obtain exclusive enqueue for datafile 1



so i showdown the database then tryed to restore it ...it gives like


Starting restore at 22-JUN-09
using target database control file instead of recovery catalog
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 06/22/2009 17:47:01
RMAN-12010: automatic channel allocation initialization failed
RMAN-06403: could not obtain a fully authorized session
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Try mounting the database before doing the recovery.
startup mount
 
 
i have take back up on 20-06-2009 and 22-06-2009 both days
when i am trying to restore database....i using the backup set which was taken on 22-06-2009
i want to use the backup set which was taken on 20-06-2009
can you help me regard this......
The best thing you can do is to read the backup and restore manual.
You can download it free from http://technet.oracle.com

 

From the steps below,Its obvious i want to configure a Stanby Database with Data Guard but i cant seem to create a pfile from my spfile, From the line marked (X--) is where my problem is,pls could you help me solve it soonest.thanks                     

Microsoft Windows [Version 5.2.3790]

(C) Copyright 1985-2003 Microsoft Corp.

 

C:\Documents and Settings\Administrator>sqlplus/nolog

 

SQL*Plus: Release 9.2.0.4.0 - Production on Fri Aug 7 13:26:43 2009

 

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.

 

SQL> conn / as sysdba

Connected.

SQL> ALTER DATABASE FORCE LOGGING;

 

Database altered.

 

SQL> select * from V$pwd_users;

select * from V$pwd_users

              *

ERROR at line 1:

ORA-00942: table or view does not exist

 

 

SQL> select * from V$pwfile_users;

 

USERNAME                       SYSDB SYSOP

------------------------------ ----- -----

SYS                            TRUE  TRUE

 

SQL> select bytes from V$log;

 

     BYTES

----------

 104857600

 104857600

 104857600

 

SQL> select group#,member from V$log;

select group#,member from V$log

              *

ERROR at line 1:

ORA-00904: "MEMBER": invalid identifier

 

 

SQL> select group#,member from V$logfile;

 

    GROUP#

----------

MEMBER

--------------------------------------------------------------------------------

 

         3

C:\ORACLE\ORADATA\PRODOC\REDO03.LOG

 

         2

C:\ORACLE\ORADATA\PRODOC\REDO02.LOG

 

         1

C:\ORACLE\ORADATA\PRODOC\REDO01.LOG

 

 

SQL> ALTER DATABASE ADD STANDBY LOGFILE GROUP 4 SIZE 100M;

ALTER DATABASE ADD STANDBY LOGFILE GROUP 4 SIZE 100M

                                           *

ERROR at line 1:

ORA-02236: invalid file name

 

 

SQL> ALTER DATABASE ADD STANDBY LOGFILE GROUP 4 'C:\ORACLE\ORADATA\PRODOC\REDO04

.LOG' SIZE 100M;

 

Database altered.

 

SQL> ALTER DATABASE ADD STANDBY LOGFILE GROUP 5 'C:\ORACLE\ORADATA\PRODOC\REDO05

.LOG' SIZE 100M;

 

Database altered.

 

SQL> ALTER DATABASE ADD STANDBY LOGFILE GROUP 6 'C:\ORACLE\ORADATA\PRODOC\REDO06

.LOG' SIZE 100M;

 

Database altered.

 

SQL> select * from V$standby_log;

 

    GROUP#    THREAD#  SEQUENCE#      BYTES       USED ARC STATUS

---------- ---------- ---------- ---------- ---------- --- ----------

FIRST_CHANGE# FIRST_TIM LAST_CHANGE# LAST_TIME

------------- --------- ------------ ---------

       &

 

 

 


From the steps below,Its obvious i want to configure a Stanby Database with Data Guard but i cant seem to create a pfile from my spfile, From the line marked (X--) is where my problem is,pls could you help me solve it soonest.thanks                     

Microsoft Windows [Version 5.2.3790]

(C) Copyright 1985-2003 Microsoft Corp.

 

C:\Documents and Settings\Administrator>sqlplus/nolog

 

SQL*Plus: Release 9.2.0.4.0 - Production on Fri Aug 7 13:26:43 2009

 

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.

 

SQL> conn / as sysdba

Connected.

 

SQL> ALTER DATABASE FORCE LOGGING;

 

Database altered.

SQL> ALTER DATABASE ADD STANDBY LOGFILE GROUP 4 'C:\ORACLE\ORADATA\PRODOC\REDO04

.LOG' SIZE 100M;

 

Database altered.

 

SQL> ALTER DATABASE ADD STANDBY LOGFILE GROUP 5 'C:\ORACLE\ORADATA\PRODOC\REDO05

.LOG' SIZE 100M;

 

Database altered.

 

SQL> ALTER DATABASE ADD STANDBY LOGFILE GROUP 6 'C:\ORACLE\ORADATA\PRODOC\REDO06

.LOG' SIZE 100M;

 

Database altered.

SQL> shutdown immediate;

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL> startup mount;

ORACLE instance started.

 

Total System Global Area  135339844 bytes

Fixed Size                   454468 bytes

Variable Size             109051904 bytes

Database Buffers           25165824 bytes

Redo Buffers                 667648 bytes

Database mounted.

SQL> alter database archivelog;

Database altered.

SQL> archive log list

Database log mode              Archive Mode

Automatic archival             Disabled

Archive destination            C:\oracle\ora92\RDBMS

Oldest online log sequence     1

Next log sequence to archive   2

Current log sequence           2

SQL> create pfile='C:\oracle\ora92\database\pfilePRODOC.ora' from spfile;

File created.

SQL> shutdown immediate;

ORA-01109: database not open

Database dismounted.

ORACLE instance shut down.

(X--) SQL> startup nomount pfile='C:\oracle\ora92\database\pfilePRODOC.ora';

LRM-00101: unknown parameter name 'LOG_ARCHIVE_CONFIG'

ORA-01078: failure in processing system parameters

SQL> startup nomount pfile='C:\oracle\ora92\database\pfilePRODOC.ora';

ORACLE instance started.

Total System Global Area  135339844 bytes

Fixed Size             &nbs

There is no such parameter log_archive_config on an Oracle version 9.2 database

 

Enter your messagerewrite the given query without using join and group by

 

sql>select b.title,max(bc.returneddate-bc.checkoutdate) ''most days out'' from bookshelf_checkout bc,bookshelf b where bc.title(+)=b.title group by b.title;

 

 

Pls. could some1 hlp me out wt ds error msg dat is showing when starting up d database after showing connected 2 idle instance. when I type $>startup it shows error 1078 failure in processing system parameters n LRM-00109 :could nt open parameter file.

Are you sure you have a valid pfile or spfile in your $ORACLE_HOME/dbs directory?

 

 

SQL> startup
ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file '/oracle/app/oracle/dbs/initDELHIST.ora
'

Oracle could not find or access the parameter file /oracle/app/oracle/dbs/initDELHIST.or

This either means:

- You are using an incorrect ORACLE_SID. Is the name of your database DELHIST?

- Oracle has no privileges to the init file

- The fle was (incidentally) dropped

 

 

 

You are using an incorrect ORACLE_SID. Is the name of your database DELHIST?

(yes - DELHIST IS THE DBNAME)

- Oracle has no privileges to the init file

(What to do)

- The fle was (incidentally) dropped

(not understood)

 

 

You need to connect to the Unix/Linux server as the user who owns the Oracle software (typically oracle).

Next , you need to check if you have access to the file /oracle/app/oracle/dbs/initDELHIST.ora)

If you cannot access the file, make sure it exists. Connect as root, and do:

ls -l /oracle/app/oracle/dbs/initDELHIST.ora

Its done,

Thank you very much for your help.

Add your message

 Please provide your personal info 



 Please ask your message as briefly and clear as possible 

 Spam Protection 
Validation Code: sus4rakrvapq78pc8


Ask Your Question

If you need more information about this particular error message, you can leave a forum message.

We are replying to this message whenever we have some spare time, so please do not consider this as a private 'solve my critical issue asap' service.

Should you need professional Oracle Assistance to make your project a success, please have a look at our consultancy services.


Spam Protection

In order to prevent automatic generation of messages, we are asking for a validation code. This code is unique and is generated every time a new message is asked.

If you do not enter the validation correctly, your message will not be recorded.


Forum Rules

Please be polite, do not USE ALL UPPERCASE, no insults, violance or any other threats.