Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Data guard configuration

710205Mar 10 2010 — edited Mar 10 2010
Hi
I am trying to create a manual Primary database on 10g and for that I have made some changes in the pfile(at primary DB side) While creating spfile for standby database from Primary pfile.

I am getting this error---


SQL> startup nomount pfile='D:\oracle\product\10.2.0\admin\PRIM\pfile\init.ora.2
42010175632';
ORACLE instance started.

Total System Global Area 289406976 bytes
Fixed Size 1248576 bytes
Variable Size 83886784 bytes
Database Buffers 197132288 bytes
Redo Buffers 7139328 bytes
SQL> create spfile from pfile='D:\oracle\product\10.2.0\admin\PRIM\pfile\init.or
a.242010175632';
create spfile from pfile='D:\oracle\product\10.2.0\admin\PRIM\pfile\init.ora.242
010175632'
*
ERROR at line 1:
ORA-01078: failure in processing system parameters
LRM-00123: invalid character 146 found in the input file


Can anybody please help me here?

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Apr 7 2010
Added on Mar 10 2010
#general-database-discussions
4 comments
525 views