Skip to Main Content

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!

ORA-01078 error message when trying to start database

532367Sep 7 2006 — edited Sep 7 2006
Hi,

I am trying to clone a production database to use it as a standby on a different server. When I try to startup the database I get the below error message. I tryied starting it up from EM, but got "ORA-01078: failure in processing system parameters" error message.

SQL> startup nomount pfile='D:\oracle\admin\MYDB\pfile\initmydb.ora'
LRM-00101: unknown parameter name 'db_cache_size'
LRM-00101: unknown parameter name 'dispatchers'
LRM-00101: unknown parameter name 'fast_start_mttr_target'
LRM-00101: unknown parameter name 'pga_aggregate_target'
LRM-00101: unknown parameter name 'undo_management'
LRM-00101: unknown parameter name 'undo_retention'
LRM-00101: unknown parameter name 'undo_tablespace'
ORA-01078: failure in processing system parameters
SQL>

This is my "ini" file:

*.aq_tm_processes=1
*.background_dump_dest='d:\oracle\admin\mydb\bdump'
*.compatible='9.2.0.0.0'
*.control_files='d:\oracle\oradata\mydb\control01.ctl','d:\oracle\oradata\mydb\control02.ctl','d:\oracle\oradata\mydb\control03.ctl'
*.core_dump_dest='d:\oracle\admin\mydb\cdump'
*.db_block_size=8192
*.db_cache_size=629145600
*.db_domain='skmconsulting.com'
*.db_file_multiblock_read_count=16
*.db_name='mydb'
*.dispatchers='(PROTOCOL=TCP)'
*.fast_start_mttr_target=300
*.hash_join_enabled=TRUE
*.instance_name='mydb'
*.java_pool_size=33554432
*.job_queue_processes=10
*.large_pool_size=8388608
*.log_archive_format='arch_mydb_%t_%s.arc'
*.log_archive_dest = D:\oracle\archive-logs\mydb
*.log_archive_start=TRUE
*.max_enabled_roles=148
*.open_cursors=500
*.optimizer_mode='rule'
*.pga_aggregate_target=25165824
*.processes=200
*.query_rewrite_enabled='FALSE'
*.remote_login_passwordfile='EXCLUSIVE'
*.shared_pool_size=83886080
*.sort_area_size=524288
*.star_transformation_enabled='FALSE'
*.timed_statistics=TRUE
*.undo_management='AUTO'
*.undo_retention=10800
*.undo_tablespace='UNDOTBS1'
*.user_dump_dest='d:\oracle\admin\mydb\udump'

Any ideas?

Thanks.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 5 2006
Added on Sep 7 2006
11 comments
882 views