Starting sap getting problem

[Former Member]

Oracle can be started but when try to start sap with startsap then it is thorowing error 12

After executing R3trans -x getting the following error

-

---

4 ETW000 [dev trc ,00000] Loading DB library '/usr/sap/YC5/SYS/exe/run/dboras

lib.so' ...

4 ETW000

94 0.000743

4 ETW000 [dlux.c ,00000] *** ERROR => DlLoadLib: dlopen()= Unable to find li

brary 'libclntsh.so.10.1'. -> DLENOACCESS (0,Error 0)

4 ETW000

1345 0.002088

4 ETW000 [dbcon.c ,00000] *** ERROR => Couldn't load library '/usr/sap/YC5/SY

...skipping...

4 ETW000 R3trans version 6.13 (release 700 - 20.02.06 - 16:15:00).

4 ETW000 unicode enabled version

4 ETW000 ===============================================

4 ETW000

4 ETW000 date&time : 26.09.2007 - 09:34:01

4 ETW000 control file: <no ctrlfile>

4 ETW000 R3trans was called as follows: R3trans -x

4 ETW000 trace at level 2 opened for a given file pointer

4 ETW000 [dev trc ,00000] Wed Sep 26 09:34:01 2007 432 0.000432

4 ETW000 [dev trc ,00000] db_con_init called 40 0.000472

4 ETW000 [dev trc ,00000] create_con (con_name=R/3) 177 0.000649

4 ETW000 [dev trc ,00000] Loading DB library '/usr/sap/YC5/SYS/exe/run/dboraslib.so' ...

4 ETW000 94 0.000743

4 ETW000 [dlux.c ,00000] *** ERROR => DlLoadLib: dlopen()= Unable to find library 'libclntsh.so.10.1'. -> DLENOACCESS (0,Error 0)

4 ETW000 1345 0.002088

4 ETW000 [dbcon.c ,00000] *** ERROR => Couldn't load library '/usr/sap/YC5/SYS/exe/run/dboraslib.so'

4 ETW000 46 0.002134

2EETW169 no connect possible: "invalid values set for DIR_LIBRARY '/usr/sap/YC5/SYS/exe/run' or dbms_type 'ORA'"

sd2n1v5:yc5adm>

[markus_doehr2 · Accepted solution]

Do you have the Oracle 10g instantclient installed? When does this error happen - what did you do before it came up?

--

Markus

[Former Member]

Please see the output

-

---

sd2n1v5:yc5adm> ls -l

total 16

drwxrwxr-x 3 y71adm sapsys 96 Sep 26 16:24 10x_64

drwxr-xr-x 8 oray71 dba 8192 Sep 25 13:15 92x_64

-

---

sd2n1v5:yc5adm> ls -l

total 32

-rw-rr 1 y71adm sapsys 100 Mar 27 2006 dbclient.lst

lrwxr-xr-x 1 z5qdm users 41 Sep 26 16:24 instantclient -> /oracle/client/10x_64/instantclient_10201

drwx------ 2 z51adm sapsys 8192 Sep 26 16:00 instantclient_10201

[fidel_vales]

Hi,

little things:

1) instantclient_10201 <<< You should be using the instant client 10.2.0.2

2) <b>drwx------ </b>2 z51adm sapsys 8192 Sep 26 16:00 instantclient_10201

ONLY the user z51adm ( nobody else, only this user ) can read directory instantclient_10201

How do you want the user yc5adm to be able to read the client?

This is <b>basic </b>UNIX, nothing to do with SAP, nothing to do with Oracle.

[Former Member]

this is the output

-

---

sd2n1v5:yc5adm> ls -l /oracle/client/10x_64/instantclient/libclntsh.so.10.1

/oracle/client/10x_64/instantclient/libclntsh.so.10.1 not found

sd2n1v5:yc5adm>

[Former Member]

I logon to the system with yc5adm and run that and this is the output

-

---

sd2n1v5:yc5adm> ldd /sapmnt/YC5/exe/dboraslib.so

libnsl.so.1 => /usr/lib/hpux64/libnsl.so.1

libpthread.so.1 => /usr/lib/hpux64/libpthread.so.1

libsapu16.so => /usr/sap/YC5/SYS/exe/run/libsapu16.so

Unable to find library 'libclntsh.so.10.1'.

[Former Member]

try:

yc5adm> <b>ls -l /oracle/client/10x_64/instantclient/libclntsh.so.10.1</b>

[Former Member]

So the 10g client is not properly installed. See SAP Note 819829 for details.

- either yc5adm does not have read permissions on /oracle/client/10x_64

- the link /oracle/client/10x_64/instant_client does not exist

- the files needed are completely missing (but that would mean your other sap instances would probably not be running)

sorry have to run, beer is waiting ))

[Former Member]

Please clarify this one .My instance name is YC5 but what I have seen just now is that

dbclient.lst is used by Y71ADM

instantclient is used by Z5ADM (NORMAL user doing new installation)

instantclient_10202 is by Z51ADM

Is is ok or I have to change something .

Second query is just to add lib path this is ok

$ ldd /sapmnt/SID/exe/dboraslib.so after login to sidadm user.

-

---

ll /oracle/client/10x_64

-rwxrwxr-x 1 sidadm sapsys 33 Mar 27 2006 dbclient.lst

lrwxrwxrwx 1 sidadm sapsys 41 Nov 29 2006 <b>instantclient -> /oracle/client/10x_64/instantclient_10202</b>

dr-xr-xr-x 2 sidadm sapsys 1024 Nov 15 2006 instantclient_10202

[Former Member]

you have to switch to the sidadm which is starting sap. i guess this should be yc5adm in your case. then run <b>ldd /sapmnt/YC5/exe/dboraslib.so</b>

check this line:

libclntsh.so.10.1 => /oracle/client/10x_64/instantclient/libclntsh.so.10.1

if this does not show up correctly, you might have no read permissions on the client dir for the yc5adm.

regards Michael

[Former Member]

I am trying to start oracle it is on mounted status but not open.

When I am giving startsap command it is showing database connected error and giving return code 12

when I am executing R3trans -x and trans.log file is giviing me the following error.

I am in the server and db and sap are here only

[markus_doehr2]

First you will need to get your Oracle database up and running.

check the Oracle alert log for the error, you can find it in

/oracle//saptrace/background

You initial problem is not, that SAP is not coming up but the Oracle database can´t be started.

--

Markus

[Former Member]

Hi there

The DB has to be open and the listener must be running, otherwise SAP or R3trans cannot connect.

For the client library problem, please check if you have the lib here. Path should be something like /oracle/client/10x_64/instantclient_10202/libclntsh.so.10.1

A very common error is the missing link:

ll /oracle/client/10x_64

-rwxrwxr-x 1 sidadm sapsys 33 Mar 27 2006 dbclient.lst

lrwxrwxrwx 1 sidadm sapsys 41 Nov 29 2006 <b>instantclient -> /oracle/client/10x_64/instantclient_10202</b>

dr-xr-xr-x 2 sidadm sapsys 1024 Nov 15 2006 instantclient_10202

Please do also check if the SAP Kernel Lib can resolve to the client lib, here is an example:

sidadm 53><b> ldd /sapmnt/SID/exe/dboraslib.so</b>

libnsl.so.1 => /usr/lib/hpux64/libnsl.so.1

libpthread.so.1 => /usr/lib/hpux64/libpthread.so.1

libclntsh.so.10.1 => <b>/oracle/client/10x_64/instantclient/libclntsh.so.10.1</b>

libnnz10.so => /oracle/client/10x_64/instantclient/libnnz10.so

libc.so.1 => /usr/lib/hpux64/libc.so.1

libxti.so.1 => /usr/lib/hpux64/libxti.so.1

/oracle/client/10x_64/instantclient/libnnz10.so => /oracle/client/10x_64/instantclient/libnnz10.so

librt.so.1 => /usr/lib/hpux64/librt.so.1

libnss_dns.so.1 => /usr/lib/hpux64/libnss_dns.so.1

libdl.so.1 => /usr/lib/hpux64/libdl.so.1

libm.so.1 => /usr/lib/hpux64/libm.so.1

libpthread.so.1 => /usr/lib/hpux64/libpthread.so.1

libunwind.so.1 => /usr/lib/hpux64/libunwind.so.1

libnsl.so.1 => /usr/lib/hpux64/libnsl.so.1

libdl.so.1 => /usr/lib/hpux64/libdl.so.1

libuca.so.1 => /usr/lib/hpux64/libuca.so.1

If you cannot resolve the problem with this info, just post the outputs of these commands here.

Best regards

Michael

[Former Member]

actualy we have superdome and multiple instance are running

now another new installation is running .That is the cause or can you tell how to rectify the error

[markus_doehr2]

I don´t know since I can´t see you machine and you are giving very few information.

Your error is:

4 ETW000 *** ERROR => DlLoadLib: dlopen()= Unable to find library 'libclntsh.so.10.1'. -> DLENOACCESS (0,Error 0)

Is that file in your oracle instant client?

--

Markus

[Former Member]

This is a new installation ,so only one time we started the instance and yesterday it was running fine .When we saw that sapgui is taking long time to get the logon pad that time we stopped oracle and sap.

After that when we trying to start sap we are getting this error.

[markus_doehr2]

Your Oracle client is not found - missing mountpoint?

--

Markus