OraFAQ Forum: Data Guard » Error ORA-01078

Home » Server Options » Data Guard » Error ORA-01078 (ORACLE 10g R2 (10.2.0.1.0))

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

Error ORA-01078 [message #485096]

Mon, 06 December 2010 04:07

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

Report message to a moderator

Re: Error ORA-01078 [message #485104 is a reply to message #485096]

Mon, 06 December 2010 04:46

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

Report message to a moderator

Re: Error ORA-01078 [message #485167 is a reply to message #485104]

Mon, 06 December 2010 09:40

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'"

Report message to a moderator

Re: Error ORA-01078 [message #485195 is a reply to message #485096]

Mon, 06 December 2010 12:43

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

Senior Member
Account Moderator

What is your edition?
select * from v$version;

Regards
Michel

Report message to a moderator

Re: Error ORA-01078 [message #485236 is a reply to message #485195]

Mon, 06 December 2010 23:50

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

Report message to a moderator

Re: Error ORA-01078 [message #485243 is a reply to message #485236]

Tue, 07 December 2010 00:25

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

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

Report message to a moderator

Re: Error ORA-01078 [message #485247 is a reply to message #485243]

Tue, 07 December 2010 00:37

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

Report message to a moderator

Re: Error ORA-01078 [message #485317 is a reply to message #485247]

Tue, 07 December 2010 07:24

John Watson
Messages: 8964
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.

Report message to a moderator

Re: Error ORA-01078 [message #485418 is a reply to message #485317]

Tue, 07 December 2010 23:25

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

Report message to a moderator