Home » Server Options » Data Guard » Error ORA-01078 (ORACLE 10g R2 (10.2.0.1.0))
Error ORA-01078 [message #485096] Mon, 06 December 2010 04:07 Go to next message
dkdms2124
Messages: 369
Registered: April 2010
Location: INDIA
Senior Member

Hi All,

I am trying to create standby database on second machine ie. not on my machine. For this i have made added the required parameters in the pfile of the primary database but when I am trying to startup the database using the new pfile I am receiving some errors.

SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup nomount pfile='E:\oracle\product\10.2.0\db_1\database\initden1.ora'
LRM-00101: unknown parameter name 'L0G_ARCHIVE_DEST_2'
ORA-01078: failure in processing system parameters
SQL>


Below are the parameters of my pfile:

*.core_dump_dest='E:\oracle\product\10.2.0/admin/den/cdump'
*.db_block_size=8192
*.db_domain=''
*.db_file_multiblock_read_count=16
*.db_name='den'
*.db_recovery_file_dest='E:\oracle\product\10.2.0/flash_recovery_area'
*.db_recovery_file_dest_size=2147483648
*.dispatchers='(PROTOCOL=TCP) (SERVICE=denXDB)'
*.job_queue_processes=10
*.local_listener='(ADDRESS = (PROTOCOL = TCP)(HOST = DB-4.bebo.com)(PORT = 1521)(SID=DEN))'
*.open_cursors=300
*.pga_aggregate_target=203423744
*.processes=150
*.remote_login_passwordfile='EXCLUSIVE'
*.sga_target=612368384
*.undo_management='AUTO'
*.undo_tablespace='UNDOTBS1'
*.user_dump_dest='E:\oracle\product\10.2.0/admin/den/udump'
#STANDBY DATABASE PARAMETERS
LOG_ARCHIVE_CONFIG='DG_CONFIG=(DEN,DENSTAN)'
LOG_ARCHIVE_DEST_1='LOCATION=E:\oracle\product\10.2.0\flash_recovery_area\DEN\ARCHIVELOG
VALID_FOR=(ALL_LOGFILES,ALL_ROLES)
DB_UNIQUE_NAME=DEN'
L0G_ARCHIVE_DEST_2=
'SERVICE=DENSTAN
VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE)
DB_UNIQUE_NAME=DENSTAN'
LOG_ARCHIVE_DEST_STATE_1=ENABLE
LOG_ARCHIVE_DEST_STATE_2=ENABLE
LOG_ARCHIVE_FORMAT=%t_%s_%r.arc
LOG_ARCHIVE_MAX_PROCESSES=30
FAL_SERVER=ORCL36
FAL_CLIENT=DEN
STANDBY_FILE_MANAGEMENT=auto
#SPECIFY THE LOCATION OF THE STANDBY DB DATAFILES FOLLOWED BY THE PRIMARY LOCATIONS.
DB_FILE_NAME_CONVERT='E:\oracle\product\10.2.0\oradata\DENSTAN','E:\oracle\product\10.2.0\oradata\den'
#SPECIFY THE LOCATION OF THE STANDBY ONLINE REDO LOGFILES FOLLOWED BY THE PRIMARY LOCATION.
LOG_FILE_NAME_CONVERT='E:\oracle\product\10.2.0\oradata\DENSTAN','E:\oracle\product\10.2.0\oradata\den','E:\oracle\product\10.2.0\fla sh_recovery_area\DENSTAN\ONLINELOG',
'E:\oracle\product\10.2.0\flash_recovery_area\DEN\ONLINELOG'


If anyone can tell me where exactly the problem is?

Thanks
Deepak
Re: Error ORA-01078 [message #485104 is a reply to message #485096] Mon, 06 December 2010 04:46 Go to previous messageGo to next message
dkdms2124
Messages: 369
Registered: April 2010
Location: INDIA
Senior Member

No one has ever come across this error or there is some thing different in it.

Regards
Deepak
Re: Error ORA-01078 [message #485167 is a reply to message #485104] Mon, 06 December 2010 09:40 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>Below are the parameters of my pfile:

For give me, but I do not believe you.
Oracle is too dumb to lie.
Oracle detects something amiss with "LRM-00101: unknown parameter name 'L0G_ARCHIVE_DEST_2'"
Re: Error ORA-01078 [message #485195 is a reply to message #485096] Mon, 06 December 2010 12:43 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
What is your edition?
select * from v$version;

Regards
Michel
Re: Error ORA-01078 [message #485236 is a reply to message #485195] Mon, 06 December 2010 23:50 Go to previous messageGo to next message
dkdms2124
Messages: 369
Registered: April 2010
Location: INDIA
Senior Member

SQL> SELECT * FROM V$VERSION;

BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Prod
PL/SQL Release 10.2.0.1.0 - Production
CORE 10.2.0.1.0 Production
TNS for 32-bit Windows: Version 10.2.0.1.0 - Production
NLSRTL Version 10.2.0.1.0 - Production

Thanks
deepak
Re: Error ORA-01078 [message #485243 is a reply to message #485236] Tue, 07 December 2010 00:25 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
L0G_ARCHIVE_DEST_2=
'SERVICE=DENSTAN
VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE)
DB_UNIQUE_NAME=DENSTAN'

Have you really this new lines in your pfile? If so remove them.

Regards
Michel
Re: Error ORA-01078 [message #485247 is a reply to message #485243] Tue, 07 December 2010 00:37 Go to previous messageGo to next message
dkdms2124
Messages: 369
Registered: April 2010
Location: INDIA
Senior Member

Sir If you can explain the reason to do so it will be much helpful for me to understand.

Regards
Deepak
Re: Error ORA-01078 [message #485317 is a reply to message #485247] Tue, 07 December 2010 07:24 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
The line breaks make it look like four parameters, not one. Remove the line breaks (as Michel said) and it will probably work.
Re: Error ORA-01078 [message #485418 is a reply to message #485317] Tue, 07 December 2010 23:25 Go to previous messageGo to next message
dkdms2124
Messages: 369
Registered: April 2010
Location: INDIA
Senior Member

With due respect Sir, I have tried the way you are saying and more over I have put the single inverted comma in the starting and at the end.

Thanks
Deepak
Re: Error ORA-01078 [message #485419 is a reply to message #485418] Tue, 07 December 2010 23:33 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
Then your only recourse is to submit a Bug Report to My Oracle Support.
Re: Error ORA-01078 [message #485428 is a reply to message #485419] Wed, 08 December 2010 00:15 Go to previous message
dkdms2124
Messages: 369
Registered: April 2010
Location: INDIA
Senior Member

ok, Thanks everyone for you effort.

Regards
Deepak
Previous Topic: Creation of the Standby Database
Next Topic: DG broker switchover problem
Goto Forum:
  


Current Time: Thu Mar 28 07:47:09 CDT 2024