We have added search box. Key in SAP issue keyword to search
TopBottom

Announcement: wanna exchange links? contact me at sapchatroom@gmail.com.

RE:[sap-basis] MDB-06177 error in parameter value of init.ora

Posted by Admin at
Share this post:
Ma.gnolia DiggIt! Del.icio.us Yahoo Furl Technorati Reddit

Posted by Superbasis (SAP Basis Administrator)
on Jun 27 at 1:43 PM
Hi, did you ever solved this problem_?
Im facing the same issue with an homg copy ORA9/AIX5
Already beent thorugh line 11 at file and it seems to be ok.

ERRORS

ERROR 2011-06-27 09:33:39
MDB-06177 Bad entry in the init.ora file: Bad parameter value. Starts with '=' or white space or contains '(' or ')'. Line 11 near string ','.


ERROR 2011-06-27 09:33:39
MDB-06021 Could not read file: [/oracle/QAS/920_64/dbs/initQAS.ora]. <br />
DIAGNOSIS: You do not have the required permissions to read this file. <br />
SOLUTION: Check and if necessary modify the permissions of the directory tree.

initSID.ora
########################################################################
# This init.ora profile is a transparent copy of Oracle spfile. #
# It was created by BRBACKUP at 2010-10-15 17.27.59. #
# Please do not change this file! Maintain only the spfile. #
# You can use BRSPACE for the altering of database parameters: #
# brspace -f dbparam #
########################################################################
*.background_dump_dest='/oracle/QAS/saptrace/backgro und'
*.compatible='9.2.0'
*.control_file_record_keep_time=30
*.control_files='/oracle/QAS/origlogA/cntrl/cntrlQAS .dbf','/oracle/QAS/sapdata1/system_1/cntrl/cntrlQA S.dbf','/oracle/QAS/saparch/cntrl/cntrlQAS.dbf'
*.core_dump_dest='/oracle/QAS/saptrace/background'
*.db_block_size=8192
*.db_cache_size=898608660
*.db_file_multiblock_read_count=8
*.db_files=254
*.db_name='QAS'
*.dml_locks=4000
*.enqueue_resources=8000
*.fast_start_mttr_target=900
*.hash_join_enabled=false
*.log_archive_dest='/oracle/QAS/oraarch/QASarch'
*.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=1198144880
*.processes=80
*.remote_os_authent=true
*.sessions=96
*.sga_max_size=1797217320
*.shared_pool_reserved_size=89860866
*.shared_pool_size=898608660
*.sort_area_retained_size=0
*.sort_area_size
97152
*.statistics_level='typical'
*.timed_statistics=true
*.transaction_auditing=FALSE
*.undo_management='AUTO'
*.undo_retention=43200
*.undo_tablespace='PSAPUNDO'
*.user_dump_dest='/oracle/QAS/saptrace/usertrace'
*.workarea_size_policy='AUTO'

---------------Original Message---------------
From: janz
Sent: Thursday, November 06, 2008 12:25 PM
Subject: MDB-06177 error in parameter value of init.ora

Hi,
I am doing a system copy and got an error : MDB-06177 Bad entry in the
init.ora file: Bad parameter value. starts with '=' or wite space or
contains '(' or ')' line 11 string','
I have already checked my init.ora and it seems nothing is wrong (below is
my init.ora), also the permissiong was alread in 777. Thanks for your usual
support.

########################################################################
# This init.ora profile is a transparent copy of Oracle spfile. #
# It was created by BR*Tools at 2008-11-06 21.00.12. #
# Please do not change this file! Maintain only the spfile. #
# You can use BRSPACE for the altering of database parameters: #
# brspace -f dbparam #
########################################################################
*.background_dump_dest='/oracle/P11/saptrace/background'
*.compatible='9.2.0'
*.control_file_record_keep_time=30
*.control_files='/oracle/P11/origlogA/cntrl/cntrlP11.dbf','/oracle/P11/sapdata1/system_1/cntrl/cntrlP11.dbf','/oracle/P11/saparch/cntrl/cntrlP11.dbf'
*.core_dump_dest='/oracle/P11/saptrace/background'
*.db_block_size=8192
*.db_cache_size=5363340410
*.db_file_multiblock_read_count=8
*.db_files=254
*.db_name='P11'
*.dml_locks=2500
*.enqueue_resources=8000
*.fast_start_mttr_target=900
*.global_names=TRUE
*.hash_join_enabled=false
*.log_archive_dest='/oracle/P11/oraarch/P11arch'
*.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=7151120547
*.processes=300
*.remote_os_authent=true
*.sessions=96
*.sga_max_size=10726680821
*.shared_pool_reserved_size=536334041
*.shared_pool_size=5363340410
*.sort_area_retained_size=0
*.sort_area_size
97152
*.statistics_level='typical'
*.timed_statistics=true
*.transaction_auditing=FALSE
*.undo_management='AUTO'
*.undo_retention=43200
*.undo_tablespace='PSAPUNDO'
*.user_dump_dest='/oracle/P11/saptrace/usertrace'
*.workarea_size_policy='AUTO'

__.____._
Copyright © 2011 Toolbox.com and message author.

Toolbox.com 4343 N. Scottsdale Road Suite 280, Scottsdale, AZ 85251
Mark as helpful
View this online
  
Popular White Papers

In the Spotlight
Discover how today's organizations are "Managing the Application Life Cycle", 6/30 at 1pm EST. Register now for the webcast.
_.____.__

0 comments:

Post a Comment

T r a n s l a t e to your language