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

[fabianlarav · Accepted solution]

To anyone facing the same or similar issue:

Check oracle user's environment variables. I was able to install successfully, but had to write in .bash_profile the following:

PATH=$PATH:$HOME/bin

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

ORACLE_HOME=/oracle/ISP/112

ORACLE_SID=ISP

ORACLE_BASE=/oracle

GRID_HOME=/oracle/GRID/11203

LD_LIBRARY_PATH=/oracle/ISP/112/lib

export PATH

export ORACLE_HOME

export ORACLE_SID

export ORACLE_BASE

export LD_LIBRARY_PATH

Also, the environment variable ORACLE_BASE is supposed to be /oracle/SID (recommended by the oracle white paper referenced by SAP in )

But it only work for us with ORACLE_BASE set to /oracle

Good luck,

Fabian

[Former Member · Accepted solution]

Hi Fabian,

Got busy into something so not able to reply.

Nice to know that it has resolve.

With Regards

Ashutosh Chaturvedi

[Former Member · Accepted solution]

For me the solution provided was not enough. Only went thru after inserting the following entry to /oracle/SID/112/bin/srvctl:

PATH=/usr/lib64/qt-3.3/bin:/usr/local/bin:/bin:/usr/bin:/usr/local/sbin:/usr/sbin:/sbin:/home/oracle/bin

Hope it helps further persons with some problem.