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

[Former Member]

Hola Fabian.

Tengo el Mismo Problema en este momento y no fue suficiente con las Variables de Oracle, tienes alguna otra idea o realizaste alguna otra actividad para solucionar este problema ?.

Muchas Gracias

Ricardo Cardona

--------------------------------------------------------------------------------------------------------------------------

Hi Fabian

I have the same problem at the moment and was not enough environment Oracle, have you made any other ideas or some other activity to solve this problem?.

Best Regards

Ricardo Cardona

[fabianlarav]

Hello Jesus,

Have you tried running the command manually?

/oracle/<SID>/112/bin/srvctl add database -d <SID> -o /oracle/<SID>/112 -p +<SID>_DATA/<SID>/spfile<SID>.ora -a <SID>_DATA

What is the output of the command?

Best Regards,

Fabian

[Former Member]

Hello Fabian,

Thanks for the help.

Yes I tried, The execute command manually '/oracle/<SID>/112/bin/srvctl add database -d <SID> -o /oracle/<SID>/112 -p +<SID>_DATA/<SID>/spfile<SID>.ora -a <SID>_DATA'   with user oracle  complete successfully.

Also in set environment user <SID>ADM, Re-Exec SWPM whit result the same error.

Already have an incident at SAP but have not answered me. do not know what else to do.

Best Regards

Ricardo Cardona.

[fabianlarav]

If running the command manually executes successfully, it means that sapinst is using oracle user with the incorrect variables.

Force set the variables in both bash and csh profiles on the oracle user.

Remember to run SWPM with root user and with csh, also umask 022

Best Regards,

Fabian

[Former Member]

hi fabian,

We have checked again all environment in the ORACLE User Profiles (.profile,  *.csh, *.sh ) and continue with the same error. Even canceled the installation and started again.

Check User root and umask 022 is OK.

have any idea?

Best regards

Ricardo Cardona

[Former Member]

Hello Fabian-

Something I forgot to say. On the server there is a DB ORACLE RAC + ASM having a data base BQ3 corresponds to a BI system. This server will share several DB one for each SID and its own ORACLE_HOME. PQ2 (Problem) is the second system of this server, then others will be installed.

bach(/oracle)# ls -lrt

total 56

drwxr-xr-x    4 root     oinstall        256 Mar  4 16:04 GRID

drwxr-xr-x   10 oracle   oinstall       4096 Mar 14 08:53 BASE

drwxrwxr-x   25 oracle   oinstall       8192 Mar 14 09:20 BQ3

drwxr-xr-x    4 oracle   oinstall        256 May 14 09:04 client

drwxr-x---    3 root     sapinst         256 May 30 16:17 stage

drwxrwxr-x   14 oracle   oinstall       4096 Jun  5 12:05 PQ2

drwxrwx---    7 oracle   oinstall       4096 Jun  5 12:22 oraInventory

This will have something to do?

Best Regards

Ricardo Cardona