cancel
Showing results for 
Search instead for 
Did you mean: 

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

fabianlarav
Explorer
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

fabianlarav
Explorer
0 Kudos

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_member185239
Active Contributor
0 Kudos

Hi Fabian,

Got busy into something so not able to reply.

Nice to know that it has resolve.

With Regards

Ashutosh Chaturvedi

Former Member
0 Kudos

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.

Answers (6)

Answers (6)

Former Member
0 Kudos

Hi ,

We are facing the same issue

oracle@psapecpdb01:/sapinstDB$ cat srvctl.log

/oracle/ECP/11203/bin/srvctl[87]: dirname: not found [No such file or directory]

/oracle/ECP/11203/bin/srvctl[94]: dirname: not found [No such file or directory]

/oracle/ECP/11203/bin/srvctl[148]: uname: not found [No such file or directory]

PRKH-1010 : Unable to communicate with CRS services.

PRKH-1000 : Unable to load the SRVM HAS shared library

PRKN-1008 : Unable to load the shared library "libsrvmhas11.so"

  or a dependent library, from

  LD_LIBRARY_PATH="/oracle/ECP/11203/lib"

  [java.lang.UnsatisfiedLinkError: /oracle/ECP/11203/lib/libsrvmhas11.so: ld.so.1: java: fatal: /oracle/ECP/11203/lib/libsrvmhas11.so: wrong ELF class: ELFCLASS64 (Possible cause: architecture word width mismatch)]

oracle@psapecpdb01:/oracle/grid/11203/bin$ ./crsctl check crs

CRS-4638: Oracle High Availability Services is online

CRS-4537: Cluster Ready Services is online

CRS-4529: Cluster Synchronization Services is online

CRS-4533: Event Manager is online

ls -l /oracle/ECP/112/lib/libsrvmhas11*

-rw-r--r--   1 oracle   oinstall 2095128 Sep 16  2011 /oracle/ECP/112/lib/libsrvmhas11.so

Pls provide the exact solution as we are stuck in production environment.

Thanks

Kishore

former_member306220
Discoverer
0 Kudos

If anybody install two instance on one  RAC enviorment ?

I means that i want to instal both of the develop database instance and QAS database instance on one RAC software. And the application software of the SAP are depart install on another standalone hardware and OS.

with the white paper ,I know the database host must share the locaction of the application host which like '/usr/sap' and '/sapmnt' ,So how i can share both DEV and QAS /usr/sap' and '/sapmnt' on one RAC enviorment.

Former Member
0 Kudos

You should mount the filesystems from source server with a different name (for example /app/SID/usr/sap/SID) and then use links to the mount points /usr/sap/SID -> /app/SID/usr/sap/SID; same to /sapmnt/SID. This message should have been open in a new topic though.

Former Member
0 Kudos

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

fabianlarav
Explorer
0 Kudos

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

antonionunes
Discoverer
0 Kudos

Hello Ricardo,

Changing the bin srvctl with the PATH solved my problem!

SAP should advise this error....

Best regards

António

antonionunes
Discoverer
0 Kudos

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
Explorer
0 Kudos

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

Former Member
0 Kudos

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
Explorer
0 Kudos

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
0 Kudos

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
Explorer
0 Kudos

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
0 Kudos

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
0 Kudos

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

former_member220071
Active Participant
0 Kudos

Dear Fabian,

Please provide srvctl.log .

Regards,

Abhijit

fabianlarav
Explorer
0 Kudos

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,

former_member185239
Active Contributor
0 Kudos

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



fabianlarav
Explorer
0 Kudos

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,

former_member185239
Active Contributor
0 Kudos

Hi Fabian,

Kindly paste the output of

Appserver:

id <sid>adm

id oracle

DB Server:

id <sid>adm

id oracle

With Regards

Ashutosh Chaturvedi

fabianlarav
Explorer
0 Kudos

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