SWPM RAC DB instance install error on srvctl add database -d

[#1]

Hello,

We are currently installing a distributed NW 7.31 system with Oracle RAC on ASM.

SCS ran successfully ,and now we are trying to install db instance.

During phase 'Create database' the installation stops with error code 1.

The log is:

WARNING    2014-04-28 19:14:00.451
           CJSlibModule::writeWarning_impl()
Execution of the command "/oracle/ISP/112/bin/srvctl add database -d ISP -o /oracle/ISP/112 -p +ISP_DATA/ISP/spfileISP.ora -a ISP_DATA" finished with return code 1. Output:
/oracle/ISP/112/bin/srvctl: line 87: dirname: No such file or directory
/oracle/ISP/112/bin/srvctl: line 94: dirname: No such file or directory
/oracle/ISP/112/bin/srvctl: line 148: uname: No such file or directory
****ORACLE_HOME environment variable is not set.
    ORACLE_HOME should be set to the main
    directory that contains Oracle products.
    Set and export ORACLE_HOME, then re-run.

ERROR      2014-04-28 19:14:00.454
           CJSlibModule::writeError_impl()
CJS-30023  Process call '/oracle/ISP/112/bin/srvctl add database -d ISP -o /oracle/ISP/112 -p +ISP_DATA/ISP/spfileISP.ora -a ISP_DATA' exits with error code 1. For details see log file(s) srvctl.log.

I don't know why the SWPM asks for the spfile if this is a fresh installation. The only file that exists is initISP.ora

Perhaps SWPM was supposed to create an spfile<SID>.ora from init<SID>.ora?

I hope someone out there has encountered this before

Best Regards,

Fabian

[antonionunes]

Hello,

I'm facing the same problem with SWPM:

An error occurred while processing option SAP NetWeaver 7.0 including Enhancement Package 2 > Software Life-Cycle Options > System Copy > Oracle > Target System Installation > Distributed System > Based on AS Java > Database Instance( Last error reported by the step: Process call '/oracle/DEP/112/bin/srvctl add database -d DEP -o /oracle/DEP/112 -p +DEVDEP01/DEP/spfileDEP.ora -a DEVDEP01' exits with error code 2. For details see log file(s) srvctl.log.)

[oracle@sapdtdb01 DB]$ cat srvctl.log

/oracle/DEP/112/bin/srvctl: line 87: dirname: No such file or directory

/oracle/DEP/112/bin/srvctl: line 94: dirname: No such file or directory

/oracle/DEP/112/bin/srvctl: line 148: uname: No such file or directory

PRCD-1025 : Failed to create database DEP

PRCT-1011 : Failed to run "srvctl". Detailed error: [/oracle/DEP/112/bin/srvctl: line 87: dirname: No such file or directory, /oracle/DEP/112/bin/srvctl: line 94: dirname: No such file or directory, /oracle/DEP/112/bin/srvctl: line 148: uname: No such file or directory]

Manualy I can execute and register the db:

/oracle/DEP/112/bin/srvctl add database -d DEP -o /oracle/DEP/112 -p +DEVDEP01/DEP/spfileDEP.ora -a DEVDEP01

I updated de .bash_profile and .bashrc

PATH=$PATH:$HOME/bin:/oracle/DEP/112/bin

ORACLE_HOME=/oracle/DEP/112

ORACLE_SID=DEP

ORACLE_BASE=/oracle/DEP

GRID_HOME=/crs/product/11.2.0.3/

LD_LIBRARY_PATH=/oracle/DEP/112/lib

export PATH

export ORACLE_HOME

export ORACLE_SID

export ORACLE_BASE

export LD_LIBRARY_PATH

Can you please advise?

Best regards

António

[fabianlarav]

Hello António,

Try changing your ORACLE_BASE variable to just /oracle in both .bash_profile and .bashrc profiles and please try again.

Best Regards,

Fabian