ORA-01078: failure in processing system parameters
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.
Welcome to our forum for Oracle error: ORA-01078 Add your own message
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'
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'
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
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
Your pfile will have the name init
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
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'
Next, execute following command:
create spfile from pfile;
Remove the initorcl.ora and restart the instance
you cannot modify a read-only file
what to do
Or your user might not have the necessary privileges to edit the file, use a user with administrative privileges.
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
If so, shutdown the 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
startup mount
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......
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
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.
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.
