| dataguard error in startup using pfileORCL.ora [message #563498] |
Tue, 14 August 2012 08:22  |
 |
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 |
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
