Hi Everybody,
Oracle Version: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
OS:Win XP
I am trying to a create a standby database...for which i have modified the pfile parameter in the primary database...
but when i am trying to create a spfile from pfile its giving the following errors
Pfile----Entries
db_name=PRIMARY
db_unique_name=PRIMARY
control_files= 'D:\ORACLE\PRODUCT\10.2.0\ORADATA\PRIMARY\CONTROL01.CTL', 'D:\ORACLE\PRODUCT\10.2.0\ORADATA\PRIMARY\CONTROL02.CTL', 'D:\ORACLE\PRODUCT\10.2.0\ORADATA\PRIMARY\CONTROL03.CTL'
LOG_ARCHIVE_CONFIG='DG_CONFIG=(PRIMARY,STANDBY)'
LOG_ARCHIVE_DEST_1=
'LOCATION=D:\oracle\product\10.2.0\flash_recovery_area\Archive_redo
VALID_FOR=(ALL_LOGFILES,ALL_ROLES)
DB_UNIQUE_NAME=PRIMARY'
LOG_ARCHIVE_DEST_2=
'SERVICE=STANDBY LGWR ASYNC
VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE)
DB_UNIQUE_NAME=STANDBY'
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=STANDBY
FAL_CLIENT=PRIMARY
STANDBY_FILE_MANAGEMENT=AUTO
DB_FILE_NAME_CONVERT='E:\Oracle\standby','D:\oracle\product\10.2.0\oradata\PRIMARY'
LOG_FILE_NAME_CONVERT=’E:\Oracle\standby’,’D:\oracle\product\10.2.0\oradata\PRIMARY’
compatible=10.2.0.1.0
Ii am executing the follwoing steps..
SQL> startup nomount pfile='c:\primarypfile.ora'
ORACLE instance started.
Total System Global Area 113246208 bytes
Fixed Size 1247588 bytes
Variable Size 58721948 bytes
Database Buffers 50331648 bytes
Redo Buffers 2945024 bytes
SQL> create spfile from pfile='c:\primarypfile.ora';
create spfile from pfile='c:\primarypfile.ora'
*
ERROR at line 1:
ORA-01078: failure in processing system parameters
LRM-00123: invalid character 146 found in the input file
SQL>
Any help appreciated.......
Regards,
Prosenjit Mukherjee.