R3trans error ( rc12) while starting up SAP

[Former Member]

Hi Experts,

I am not able to start my SAP system up.

DB is oracle.

I am able to startup the DB from SQL command prompt but R3trans is not working.

It is giving the following error.

2EETW169 no connect possible: "maybe someone set invalid values for DIR_LIBRARY ('/usr/sap/IN1/SYS/exe/run') or dbms_type ('ORA')"

R3trans finished (0012).

When I am checking the above values, it is showing like following:

in1adm 26> echo $DIR_LIBRARY

/usr/sap/IN1/SYS/exe/run

in1adm 27> echo $dbms_type

ORA

I cant understand where lies the problem.

Moreover,

When separately starting the DB, it is showing all DB processes but after that when I am executing startsap command, it is stopping the DB processes.

Can anyone help regarding this matter?

Anupam.

[Former Member]

Hi Anupam,

This error is due the the permission that set to the Oracle client is not correct.

Please check the authorizations of the file dboraslib.o and the directory path as the error you are getting is caused by wrong

authorization setting on the file or directory.

Regards,

Sumanth

[Former Member]

Hi,

This problem generally occurs when logged user has not proper authorization.

Did you logged with Admin user. In this case by default it give the RC = 0012

Please logg in with SIDadm user.

If you till getting error as rc =0012 and DB is up.. the LISTENER service might not be running....

Please analysis for the errors in trans.log in drive://document and setting/user(SIDadm)/trans.log

Regards,

Shanker

[Former Member]

Hi,

This is Moulinath from the same team of Anupam.

Please let me continue.

I am logged in as <sidadm> only.

the dboraslib.so file is in the path /sapmnt/IN1/exe and having authorization as <sid>adm sapsys.

Are you talking of this authorization and is this correct?

####################################

in1adm 55> pwd

/sapmnt/IN1/exe

in1adm 56> ls -lrt |grep dboraslib*

-rwxr-xr-x 1 in1adm sapsys 2186040 Jan 23 2008 dboraslib.so

####################################

Please let me know the location of trans.log.

N.B. Listener is UP also.

Thanks and Regards,

Moulinath

Edited by: Moulinath Ray on Jul 27, 2009 10:10 AM

[Former Member]

Hi Moulinath

trans.log file will be cteated when you will execute the command r3trans -d

Aslo analyze dev_w0 file for errors.

Reagrd

Ashok Dalai

[Former Member]

Hi,

Please find the details of trans.log file.

4 ETW000 R3trans version 6.14 (release 700 - 14.02.08 - 14:55:00).

4 ETW000 unicode enabled version

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

4 ETW000

4 ETW000 date&time : 27.07.2009 - 14:37:18

4 ETW000 control file: <no ctrlfile>

4 ETW000 R3trans was called as follows: R3trans -d

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

4 ETW000 [dev trc ,00000] Mon Jul 27 14:37:18 2009 217 0.000217

4 ETW000 [dev trc ,00000] db_con_init called 27 0.000244

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

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

4 ETW000 47 0.000365

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

0,Error 0)

4 ETW000 839 0.001204

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

4 ETW000 42 0.001246

2EETW169 no connect possible: "maybe someone set invalid values for DIR_LIBRARY ('/usr/sap/IN1/SYS/exe/run') or dbms_type ('OR

A')"

Thanks and Regards,

Moulinath

[JPReyes]

Does the file exist?... you might have uploaded the wrong kernel?... can you please let us know if this is a new installation or is a system that it was running already?

Regards

Juan

[Former Member]

Yes...A system was running Already...

Anupam..

[JPReyes]

What OS are you using?....

Did you check that the varible is properly set on <ora>sid as well as <sid>adm?...

Regards

Juan

[Former Member]

hello Experts,

in ideal case,What will be the OWNER GROUP & PERMISSION of the following two files & 1 directory??

1. libclntsh.so.10.1

2. dboraslib.so

and

3. /oracle/client

Please Help...

Anupam..