Home » Server Options » Data Guard » dataguard error in startup using pfileORCL.ora
dataguard error in startup using pfileORCL.ora [message #563498] Tue, 14 August 2012 08:22 Go to next message
priteshranjan.preet
Messages: 131
Registered: April 2012
Location: delhi
Senior Member
hi expert i m trying to configure dataguard from one machine to another machine both machine have redhat 5 oracle 10g(10.2.0.1.0)
i m facing a problem when i try to start the database on primary database machine.

primary database name= orcl
standby database name=black
i create the pfile by using the command

sql>create pfile='/u01/app/pfileORCL.ora' from spfile;
SQL> shutdown immediate;
SQL> startup nomount pfile='/u01/app/pfileORCL.ora';
LRM-00123: invalid character 128 found in the input file
ORA-01078: failure in processing system parameters

pfileORCL.ora contain is below

orcl.__db_cache_size=197132288
orcl.__java_pool_size=4194304
orcl.__large_pool_size=4194304
orcl.__shared_pool_size=71303168
orcl.__streams_pool_size=4194304
*.audit_file_dest='/u01/app/oracle/admin/orcl/adump'
*.background_dump_dest='/u01/app/oracle/admin/orcl/bdump'
*.compatible='10.2.0.1.0'
*.control_files='/u01/app/oracle/oradata/orcl/control01.ctl','/u01/app/oracle/oradata/orcl/control02.ctl','/u01/app/oracle/oradata/or cl/control03.ctl'
*.core_dump_dest='/u01/app/oracle/admin/orcl/cdump'
*.db_block_size=8192
*.db_domain=''
*.db_file_multiblock_read_count=16
*.db_name='orcl'
*.db_recovery_file_dest='/u01/app/oracle/flash_recovery_area'
*.db_recovery_file_dest_size=2147483648
*.dg_broker_start=TRUE
*.dispatchers='(PROTOCOL=TCP) (SERVICE=orclXDB)'
*.job_queue_processes=10
*.open_cursors=300
*.pga_aggregate_target=94371840
*.processes=150
*.recyclebin='ON'
*.remote_login_passwordfile='EXCLUSIVE'
*.resource_limit=TRUE
orcl.resource_manager_plan='FORCE:DAY_PLAN'
*.sga_target=285212672
*.undo_management='AUTO'
*.undo_tablespace='UNDOTBS1'
*.user_dump_dest='/u01/app/oracle/admin/orcl/udump'
db_name=ORCL
db_unique_name=ORCL
LOG_ARCHIVE_CONFIG='DG_CONFIG=(orcl,black)'
LOG_ARCHIVE_DEST_1=
'LOCATION=/u01/app/oracle/flash_recovery_area/ORCL/ARCHIVELOG
VALID_FOR=(ALL_LOGFILES,ALL_ROLES)
DB_UNIQUE_NAME=orcl'
LOG_ARCHIVE_DEST_2=
'SERVICE=BLACK LGWR ASYNC
VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE)
DB_UNIQUE_NAME=black
LOG_ARCHIVE_DEST_STATE_1=ENABLE
LOG_ARCHIVE_DEST_STATE_2=ENABLE
LOG_ARCHIVE_FORMAT=%t_%s_%r.arc
LOG_ARCHIVE_MAX_PROCESSES=30
remote_login_passwordfile='EXCLUSIVE'
FAL_SERVER=black
FAL_CLIENT=orcl
standby_file_management=auto
db_file_name_convert='/u01/app/oracle/oradata/black/','/u01/app/oracle/oradata/orcl/'
log_file_name_convert='/u01/app/oracle/oradata/black/onlinelog/','/u01/app/oracle/oradata/orcl/onlinelog/'

please suggest me where i m wrong.

thanks & regards
pritesh ranjan
7827825499

[Updated on: Tue, 14 August 2012 08:37] by Moderator

Report message to a moderator

Re: dataguard error in startup using pfileORCL.ora [message #563503 is a reply to message #563498] Tue, 14 August 2012 08:36 Go to previous message
Michel Cadot
Messages: 59149
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
LRM-00123: invalid character 128 found in the input file

Search for it!

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.
Also always post your Oracle version, with 4 decimals.

Regards
Michel

[Updated on: Tue, 14 August 2012 08:37]

Report message to a moderator

Previous Topic: DATAGUARD SYNC BUT...?
Next Topic: Configuring rman for dataguard environment.
Goto Forum:
  


Current Time: Sun Sep 21 15:35:48 CDT 2014

Total time taken to generate the page: 0.07309 seconds