SAPINST permission error

[Former Member]

We are performing HSC from a JAVA stack system.

The sapinst stopped at the Restore Backup step and it is trying to read the files init* and the following error appears:

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

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

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

<br>DIAGNOIS: You do not have the required permissions to read this

file. <br>SOLUTION: Check and if necessary modify the permissions of

the directory tree.

The oracle directory has 775 permission and its tree. The user which execute the sapinst has root permission and can open and change the files

Tks a lot

Re

[Former Member]

Hi,

May i know, how many database and sap instances you have on this server.

Thanks,

Abha

[Former Member]

Hello Re

Just check the permission what orasid,sidadm users have on that directory.

As well go through permissions on each directory whih are being shown in your thread here.

I think once you fix the permissions of the directory for orasid and sidadm it will work.

Regards

Vivek

[former_member208104]

Hi,

Can you check your init.ora file at line 1. Looks like some some space is there.

Bad parameter value. Starts with '=' or white space or contains '(' or ')'. Line 1 near string

Please correct this. If still get error, rebuild your spfile.

Looks like permision error is misleading because of this issue.

-Sanjay

[former_member208104]

Hi,

Check if you are able to open this file using <sid>adm

/oracle/SID/102_64/dbs/initSID.ora

if not provide permision to <sid>adm

-Sanjay

[sivakumar_kilari3]

Hi,

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

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

Check initsid.ora file line 1 ','

or can you paste file here

Thanks

Siva

[former_member208104]

Hi,

Can you please provide following trace file:

/oracle/<SID>/saptrace/usertrace

sapinst_dev.log

-Sanjay

[Former Member]

Hi

Please, take a look. I don't know how to attach a file here...so..

TRACE [iaxxccontrolfile.cpp:77]

CControlFile::getControlFilePath()

Running with control file path

INFO 2011-04-28 01:10:42 [syxxcfile.cpp:523]

CSyFileImpl::copy(const CSyPath & /usr/sap/tmp/sapinst_instdir/NW04/COPY/IMPORT/JAVA/COPY/CENTRAL/ONE_HOST/keydb.10.xml, ISyNode::eCopyMode 3, ISyProgressObserver*) const

Copying file /usr/sap/tmp/sapinst_instdir/NW04/COPY/IMPORT/JAVA/COPY/CENTRAL/ONE_HOST/keydb.xml to: /usr/sap/tmp/sapinst_instdir/NW04/COPY/IMPORT/JAVA/COPY/CENTRAL/ONE_HOST/keydb.10.xml.

INFO 2011-04-28 01:10:42 [syuxcpath.cpp:369]

CSyPath::createFile()

Creating file /usr/sap/tmp/sapinst_instdir/NW04/COPY/IMPORT/JAVA/COPY/CENTRAL/ONE_HOST/keydb.10.xml.

TRACE [iaxxcwalker.cpp:296]

CDomWalker::processStep()

Executing installation step J2EE_SystemCopy_OneHost|ind|ind|ind|WebAS|640|0|J2EE_SystemCopy|ind|ind|ind|ind|ind|0|J2EE_EngineEnterpriseDialogs|ind|ind|ind|WebAS|630|0|J2EE_Engine|ind|ind|ind|J2EE_Engine|630|0|J2EEDB|ind|ind|ind|J2EEDB|10|0|OraBRJ2EE|ind|ind|ind|ind|ind|0|registerControlFilesInInitOra_OBR

TRACE [iaxxejsexp.cpp:208]

EJS_Installer::writeTraceToLogBook()

Oracle Version: 102

TRACE [iaxxejsexp.cpp:208]

EJS_Installer::writeTraceToLogBook()

OraVersion result: 10.2

INFO 2011-04-28 01:10:42 [iaxxclib.cpp:83]

load()

Working directory changed to /usr/sap/tmp/sapinst_exe.852014.1303967355.

TRACE [iaxxclib.cpp:165]

load()

Opened iajsmod.o

INFO 2011-04-28 01:10:42 [iaxxclib.cpp:108]

load()

Working directory changed to /usr/sap/tmp/sapinst_instdir/NW04/COPY/IMPORT/JAVA/COPY/CENTRAL/ONE_HOST.

ERROR 2011-04-28 01:10:42 [iaxob_configfile.cpp:609]

COraConfigFileEditor::readInitOra_impl(const iastring&)

MDB-06177 Bad entry in the init.ora file: Bad parameter value. Starts with '=' or white space or contains '(' or ')'. Line 1 near string ','.

ERROR 2011-04-28 01:10:42 [iaxob_configfile.cpp:67]

COraConfigFileEditor::readInitOra_impl(const iastring&)

MDB-06021 Could not read file: [/oracle/SID/102_64/dbs/initSID.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.

Edited by: Juan Reyes on Apr 29, 2011 9:37 AM

[sivakumar_kilari3]

Hi

Check initsid.ora file.

Bad parameter value. Starts with '=' or white space or contains '(' or ')'. Line 1 near string ','

Thanks

Siva

[former_member208104]

Hi,

Looks like issue with your init.ora file. Please correct syntex error in initSID file and recreate pfile.

Thanks,

Sanjay

[Former Member]

Hi Sanjay

I forgot the usertrace

Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production

With the Partitioning, OLAP, Data Mining Scoring Engine and Real Application Testing options

ORACLE_HOME = /oracle/SID/102_64

System name: AIX

Node name: server

Release: 3

Version: 5

Machine: 00C457B54C00

Instance name: SID

Redo thread mounted by this instance: 1

Oracle process number: 12

Unix process pid: 1400876, image: oracle@server (TNS V1-V3)

• ACTION NAME:() 2011-04-28 12:04:21.604

• MODULE NAME:(sqlplus@server (TNS V1-V3)) 2011-04-28 12:04:21.604

• SERVICE NAME:(SYS$USERS) 2011-04-28 12:04:21.604

• SESSION ID:(930.3) 2011-04-28 12:04:21.604

kwqmnich: current time:: 12: 4: 22

kwqmnich: instance no 0 check_only flag 1

kwqmnich: initialized job cache structure

server(qqfer1w):

[Former Member]

Guy,

The DBA sdjusted the in<SID> ora and the error now is another:

Error message: SP2-0310: unable to open file "CONTROL.SQL"

unable to open file "CONTROL.SQL"

[former_member208104]

Hi,

check this thread

-Sanjay

[Former Member]

I have already put () in the controfiles parameters and the error persists:

Take a look at my init:

*._fix_control='5705630:ON','5765456:3'

*._optim_peek_user_binds=false

*._optimizer_mjc_enabled=false

*._push_join_union_view=FALSE

*._sort_elimination_cost_ratio=10

*.audit_trail='DB'

*.background_dump_dest='/oracle/<SID>/saptrace/background'

*.compatible='10.2.0'

*.control_file_record_keep_time=30

*.control_files='/oracle/<SID>/sapdata1/cntrl/cntrl<SID>.dbf','/oracle/<SID>/sapdata2/cntrl/cntrl<SID>.dbf','/oracle/<SID>/sapdata3/cntrl/cntrl<SID>.dbf'

*.core_dump_dest='/oracle/<SID>/saptrace/background'

*.db_block_size=8192

*.db_cache_size=800M

*.db_files=254

*.db_name='<SID>'

*.dml_locks=25000

*.event='10091 trace name context forever, level 1','10027 trace name context forever, level 1','10028 trace name context forever, level 1','10142 trace name context forever, level 1','10183 trace name context forever, level 1','10191 trace name context forever, level 1','10411 trace name context forever, level 1','10629 trace name context forever, level 32','10753 trace name context forever, level 2','14532 trace name context forever, level 1','38068 trace name context forever, level 100','38085 trace name context forever, level 1','38087 trace name context forever, level 1','44951 trace name context forever, level 1024'

*.fast_start_mttr_target=900

*.filesystemio_options='setall'

*.large_pool_size=10M

*.log_archive_dest_1='LOCATION=/oracle/<SID>/oraarch/<SID>. MANDATORY REOPEN=10'

*.log_archive_format='%t_%r_%S.log'

*.log_buffer=1048576

*.log_checkpoints_to_alert=true

*.max_dump_file_size='20000'

*.open_cursors=800

*.pga_aggregate_target=200m

*.processes=850

*.query_rewrite_enabled='false'

*.recyclebin='off'

*.remote_login_passwordfile='exclusive'

*.remote_os_authent=true

*.replication_dependency_tracking=false

*.sessions=900

*.sga_max_size=1200M

*.shared_pool_size=230M

*.star_transformation_enabled='true'

*.undo_management='AUTO'

*.undo_retention=1800

*.undo_tablespace='PSAPUNDO'

*.user_dump_dest='/oracle/<SID>/saptrace/usertrace'