on 04-29-2014 7:00 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
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
Dear Fabian,
Please provide srvctl.log .
Regards,
Abhijit
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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,
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,
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
User | Count |
---|---|
84 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.