Question Re: SWPM RAC DB instance install error on srvctl add database -d in Technology Q&A

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

fabianlarav — Tue, 29 Apr 2014 18:00:49 GMT

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

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

former_member220071 — Wed, 30 Apr 2014 09:47:20 GMT

Dear Fabian,

Please provide srvctl.log .

Regards,

Abhijit

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

fabianlarav — Wed, 30 Apr 2014 14:27:12 GMT

Certainly Abhijeet

These are the contents of srvctl.log

/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

PRCD-1025 : Failed to create database ISP

PRCT-1011 : Failed to run "srvctl". Detailed error:

[/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]

I've just updated SWPM to the latest version.

Best Regards,

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

Former Member — Wed, 30 Apr 2014 17:16:31 GMT

Hi Fabian,

Kindly run the command manually

/oracle/ISP/112/bin/srvctl add database -d ISP -o /oracle/ISP/112 -p +ISP_DATA/ISP/spfileISP.ora -a ISP_DATA

Let us know know the output.

Also set the oracle home

With Regards

Ashutosh Chaturvedi

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

fabianlarav — Wed, 30 Apr 2014 19:00:43 GMT

Ok.

I logged on with oracle user.

I executed . oraenv

ORACLE_SID = [ISP] ? ISP

ORACLE_HOME = [/home/oracle] ? /oracle/ISP/112

Now run directly the command:

/oracle/ISP/112/bin/srvctl add database -d ISP -o /oracle/ISP/112 -p +ISP_DATA/ISP/spfileISP.ora -a ISP_DATA

and it runs successfully.

Now, back to sapinst, I hit retry and it still fails, the srvctl.log output is this:

# more srvctl.log

/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

PRCS-1007 : Server pool ISP already exists

PRCR-1086 : server pool ora.ISP is already registered

Might this suggest something is wrong with oracle environment? I am running SWPM with root of course.

Best Regards,

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

Former Member — Thu, 01 May 2014 03:52:08 GMT

Hi Fabian,

Kindly paste the output of

Appserver:

id <sid>adm

id oracle

DB Server:

id <sid>adm

id oracle

With Regards

Ashutosh Chaturvedi

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

fabianlarav — Thu, 01 May 2014 13:07:54 GMT

Sure,

Appserver:

[root@appserver ~]# id m1padm

uid=505(m1padm) gid=505(sapsys) groups=505(sapsys),504(sapinst)

[root@appserver ~]# id oracle

uid=200(oracle) gid=200(oinstall) groups=200(oinstall),201(dba),202(oper),506(asmoper),507(asmadmin),508(asmdba)

DB server:

[root@dbserver DB]# id m1padm

uid=505(m1padm) gid=505(sapsys) groups=505(sapsys),200(oinstall),201(dba),202(oper),504(sapinst),506(asmoper),508(asmdba)

[root@dbserver DB]# id oracle

uid=200(oracle) gid=200(oinstall) groups=200(oinstall),10(wheel),201(dba),202(oper),504(sapinst),506(asmoper),507(asmadmin),508(asmdba)

Best Regards,

Fabian

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

fabianlarav — Fri, 02 May 2014 20:15:52 GMT

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

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

Former Member — Sat, 03 May 2014 06:08:34 GMT

Hi Fabian,

Got busy into something so not able to reply.

Nice to know that it has resolve.

With Regards

Ashutosh Chaturvedi

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

Former Member — Thu, 22 May 2014 20:45:06 GMT

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.

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

Former Member — Thu, 05 Jun 2014 14:52:46 GMT

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

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

fabianlarav — Fri, 06 Jun 2014 13:57:48 GMT

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

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

Former Member — Fri, 06 Jun 2014 14:14:42 GMT

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.

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

fabianlarav — Fri, 06 Jun 2014 14:27:19 GMT

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

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

Former Member — Fri, 06 Jun 2014 20:26:37 GMT

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

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

antonionunes — Mon, 09 Jun 2014 12:42:58 GMT

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

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

fabianlarav — Mon, 09 Jun 2014 13:37:59 GMT

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

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

Former Member — Mon, 09 Jun 2014 21:01:10 GMT

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

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

Former Member — Tue, 10 Jun 2014 13:54:23 GMT

Hello everyone.

Now we solve the problem, thank you very much for the help.

Solution: change archive srvctl "/oracle/<SID>/11204/bin/srvctl" add the following line.

PATH=/usr/bin:/etc:/usr/sbin:/usr/ucb:/home/oracle/bin:/usr/bin/X11:/sbin:/oracle/<SID>/11204/bin

Best Regards.

Ricardo Cardona

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

fabianlarav — Tue, 10 Jun 2014 14:08:15 GMT

Ricardo,

Thank you for sharing your solution. It appears SAP has to make amendments to the current installer. I hope they do that soon.

Best Regards,

Fabian Lara