cancel
Showing results for 
Search instead for 
Did you mean: 

System copy error of init.ora

Former Member
0 Kudos

Hi,

I am doing system copy. My versions are ERP04, DB is oracle and OS is AIX 5.3

I have restored datafiles and others and also init<SID>.ora files

But I am getting an error

It is at step Oracle Preload Actions. It is giving me the following error:-

ERROR 2008-12-28 01:28:17

MDB-06177 Bad entry in the init.ora file: Bad parameter value. Starts

with '=' or white space or contains '(' or ')'. Line 15 near string ','.

ERROR 2008-12-28 02:26:45

MDB-06021 Could not read file: [/oracle/<SID>/920_64/dbs/initRD1.ora].

I am doing system copy. I have copied the init<SID>.ora file from too.

Line 15 is the line with parameter control files.

I have checked it and rewrote it manually, but it did not help.

I tried to remove *. from every paramter and restarted the DB and retried

installation, but it did not help.

I have searched for notes and on SDN but did not get anything.

I am not getting what can be the problem.

Kindly help

Regards,

Tajinder

Accepted Solutions (0)

Answers (4)

Answers (4)

Former Member
0 Kudos

Thanks for the solution. Even it worked for me.

Former Member
0 Kudos

hi tajinder,

You cannot write init.ora manually or edit it directly. Use BRTOOLS to edit this parameter.

You could also directly open it by using command :>brspace -f dbparam

ardhian

http://ardhian.kioslinux.com

http://sapbasis.wordpress.com

Former Member
0 Kudos

Hi,

Changed the line for control files parameter to:-

control_files=("/oracle/RD1/origlogA/cntrl/cntrlRD1.dbf","/oracle/RD1/sapdata1/system_1/cntrl/cntrlRD1.dbf","/oracle/RD1/saparch/cnrtl/cntrlRD1.dbf")

And it worked.

I think SAPINST has problem recognizing ','

Thank you all for your answers.

Closing the thread.

Regards,

Tajinder

0 Kudos

Hi ,

Can you please clear how to resolved the problem .

I am facing the same problem.

My initPRD.ora file is as below.

oraprd 131> cat initPRD.ora

########################################################################

  1. This init.ora profile is a transparent copy of Oracle spfile. #

  2. It was created by BRARCHIVE at 2009-12-18 22.00.05. #

  3. Please do not change this file! Maintain only the spfile. #

  4. You can use BRSPACE for the altering of database parameters: #

  5. brspace -f dbparam #

########################################################################

*._b_tree_bitmap_plans=FALSE

*._optim_peek_user_binds=FALSE

*._optimizer_join_sel_sanity_check=TRUE

*._push_join_predicate=FALSE

*._sort_elimination_cost_ratio=10

*.background_dump_dest='/oracle/PRD/saptrace/background'

*.compatible='9.2.0'

*.control_file_record_keep_time=30

*.control_files='/oracle/PRD/origlogA/cntrl/cntrlPRD.dbf','/oracle/PRD/sapdata1/system_1/cntrl/cntrlPRD.dbf','/oracle/PRD/saparch/cntrl/cntrlPRD.dbf'

*.core_dump_dest='/oracle/PRD/saptrace/background'

*.db_block_checksum=FALSE

*.db_block_size=8192

*.db_cache_size=3707680849

*.db_file_multiblock_read_count=8

*.db_files=254

*.db_name='PRD'

*.db_writer_processes=2

*.dml_locks=4000

*.enqueue_resources=8000

*.event='10183 trace name context forever, level 1','10191 trace name context forever, level 1','10028 trace name context forever, level 1'#SAP Notes 128648, 128221, 596420

*.fast_start_mttr_target=900

*.hash_join_enabled=false

*.log_archive_dest='/oracle/PRD/oraarch/PRDarch'

*.log_archive_start=true

*.log_buffer=1048576

*.log_checkpoint_interval=0

*.log_checkpoint_timeout=0

*.log_checkpoints_to_alert=true

*.open_cursors=800

*.optimizer_features_enable='9.2.0'

*.optimizer_index_cost_adj=10

*.optimizer_mode='choose'

*.pga_aggregate_target=4943574466

*.processes=240

*.remote_os_authent=true

*.sessions=300

*.sga_max_size=7415361699

*.shared_pool_reserved_size=370768084

*.shared_pool_size=3707680849

*.sort_area_retained_size=0

*.sort_area_size=2097152

*.statistics_level='typical'

*.timed_statistics=true

*.transaction_auditing=FALSE

*.undo_management='AUTO'

*.undo_retention=21600

*.undo_tablespace='PSAPUNDO'

*.user_dump_dest='/oracle/PRD/saptrace/usertrace'

*.workarea_size_policy='AUTO'

oraprd 132>

0 Kudos

Worked for me too .. had to change file manually

added ( to start,  ...

and ) at the end

and changed all ' to " on that particular line.

Thanks

stefan_koehler
Active Contributor
0 Kudos

Hello Tajinder,

can you please verify that there are no spaces at the end of the lines.

If you are using VIM on unix then you can see some special characters very well.

Regards

Stefan

Former Member
0 Kudos

Pasting my init<SID>.ora file

########################################################################

    1. This init.ora profile is a transparent copy of Oracle spfile. #*

    2. It was created by BRCONNECT at 2008-12-26 04.00.45. #*

    3. Please do not change this file! Maintain only the spfile. #*

    4. You can use BRSPACE for the altering of database parameters: #*

    5. brspace -f dbparam #*

########################################################################

*._b_tree_bitmap_plans=FALSE

*._eliminate_common_subexpr=FALSE

*._optim_peek_user_binds=FALSE

*._optimizer_join_sel_sanity_check=TRUE

*.background_dump_dest='/oracle/RD1/saptrace/background'

*.compatible='9.2.0'

*.control_file_record_keep_time=30

*.control_files='/oracle/RD1/origlogA/cntrl/cntrlRD1.dbf','/oracle/RD1/sapdata1/system_1/cntrl/cntrlRD1.dbf',

'/oracle/RD1/saparch/cnrtl/cntrlRD1.dbf'

*.core_dump_dest='/oracle/RD1/saptrace/background'

*.db_block_size=8192

*.db_cache_size=429486243

*.db_file_multiblock_read_count=8

*.db_files=254

*.db_name='RD1'

*.dml_locks=4000

*.enqueue_resources=8000

*.fast_start_mttr_target=900

*.hash_join_enabled=TRUE

*.log_archive_dest='/oracle/RD1/oraarch/RD1arch'

*.log_archive_start=true

*.log_buffer=1048576

*.log_checkpoint_interval=0

*.log_checkpoint_timeout=0

*.log_checkpoints_to_alert=true

*.open_cursors=800

*.optimizer_features_enable='9.2.0'

*.optimizer_index_cost_adj=10

*.optimizer_mode='choose'

*.parallel_execution_message_size=16384

*.parallel_max_servers=20

*.pga_aggregate_target=572648325

*.processes=92

*.remote_os_authent=true

*.sessions=100

*.sga_max_size=858972487

*.shared_pool_reserved_size=42948624

*.shared_pool_size=429486243

*.sort_area_retained_size=0

*.sort_area_size=2097152

*.star_transformation_enabled='TRUE'

*.statistics_level='typical'

*.timed_statistics=true

*.transaction_auditing=FALSE

*.undo_management='AUTO'

*.undo_retention=43200

*.undo_tablespace='PSAPUNDO'

*.user_dump_dest='/oracle/RD1/saptrace/usertrace'

*.workarea_size_policy='AUTO'