DB cannot start

[Former Member]

Hello,

I just did a system copy on a sandbox,

and when trying to start SAP I get the following:

startsap

Checking SID Database

ABAP Database is not available via R3trans

Starting SAP-Collector Daemon

***********************************************************************

• This is Saposcol Version COLL 20.95 700 - AIX v11.65 5L-64 bit 090118

• Usage: saposcol -l: Start OS Collector

• saposcol -k: Stop OS Collector

• saposcol -d: OS Collector Dialog Mode

• saposcol -s: OS Collector Status

• The OS Collector (PID 3342808) is already running .....

************************************************************************

saposcol already running

Running /usr/sap/SID/SYS/exe/run/startdb

Trying to start SID database ...

Log file: /home/sidadm/startdb.log

/usr/sap/SID/SYS/exe/run/startdb: Terminating with error code 12

DB startup failed

LISTSNER:

lsnrctl status

LSNRCTL for IBM/AIX RISC System/6000: Version 10.2.0.5.0 - Production on 14-SEP-2011 18:48:18

Copyright (c) 1991, 2010, Oracle. All rights reserved.

Connecting to (ADDRESS=(PROTOCOL=IPC)(KEY=SEC.WORLD))

STATUS of the LISTENER

Alias LISTENER

Version TNSLSNR for IBM/AIX RISC System/6000: Version 10.2.0.5.0 - Production

Start Date 14-SEP-2011 18:45:09

Uptime 0 days 0 hr. 3 min. 9 sec

Trace Level off

Security ON: Local OS Authentication

SNMP OFF

Listener Parameter File /oracle/SID/102_64/network/admin/listener.ora

Listener Log File /oracle/SID/102_64/network/log/listener.log

Listening Endpoints Summary...

(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=SID.WORLD)))

(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=SEC)))

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=sdfr340)(PORT=1527)))

Services Summary...

Service "SID" has 1 instance(s).

Instance "SID", status UNKNOWN, has 2 handler(s) for this service...

The command completed successfully

LOG:

Wed Sep 14 19:00:39 CUT 2011

Connect to the database to verify, that the database is now open

R3trans check finished with return code: 12

• ERROR: Startup of database failed

Notify Database Administrator.

/usr/sap/SID/SYS/exe/run/startdb: Terminating with error code 12

R3trans -d

This is R3trans version 6.14 (release 700 - 23.07.10 - 09:23:00).

unicode enabled version

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

R3trans finished (0012).

Can you please advise ?

[Former Member · Accepted solution]

lrwxrwxrwx 1 orasec dba 17 Sep 08 14:19 libclntsh.so.old -> libclntsh.so.10.1

Why its showing .old for the softlink?

Check and correct, for refference check your other system or Oracle 10G Install/Upgrade guide

Regards,

Nick Loy

[Former Member · Accepted solution]

ON the source system:

ls -la libclnt*

-rw-rr 1 orafec dba 25031924 Aug 19 00:54 libclntsh.a

-rwxr-xr-x 1 orafec dba 24447632 Aug 19 00:54 libclntsh.so

-rwxr-xr-x 1 orafec dba 24476547 Aug 10 2010 libclntsh.so.10.1

lrwxrwxrwx 1 orafec dba 17 Aug 10 2010 libclntsh.so.old -> libclntsh.so.10.1

-rw-rr 1 orafec dba 0 Aug 14 2005 libclntst10.a

On target:

ls -la libclnt*

-rwxrwxrwx 1 orasec dba 25031924 Sep 14 17:59 libclntsh.a

-rwxrwxrwx 1 orasec dba 24447632 Sep 14 17:59 libclntsh.so

-rwxr-xr-x 1 orasec dba 24476547 Aug 10 2010 libclntsh.so.10.1

lrwxrwxrwx 1 orasec dba 17 Sep 08 14:19 libclntsh.so.old -> libclntsh.so.10.1

-rw-rr 1 orasec dba 0 Aug 14 2005 libclntst10.a

-

---

>

They are both the same.

[Former Member · Accepted solution]

Hi,

First of all, have you actually gone into sqlplus "/ as sysdba" and run startup, what do you get ?

You say this is a system copy was the source system oracle software 10.2.0.5.0 you have here.

Mark

[Former Member · Accepted solution]

Hi Mark,

SQL> startup

ORA-01081: cannot start already-running ORACLE - shut it down first

SQL> shutdown

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL> startup

ORACLE instance started.

Total System Global Area 1929379840 bytes

Fixed Size 2097344 bytes

Variable Size 452988736 bytes

Database Buffers 1459617792 bytes

Redo Buffers 14675968 bytes

Database mounted.

Database opened.

Yes, Oracle is the same on both:

cat version.txt

SAP Bundle Patch 10.2.0.5.4 - 201108

Thanks.

Edited by: Jordy_tof on Sep 15, 2011 11:56 AM

[Former Member · Accepted solution]

Great!

what's the permissions on he dboraslib.o ?

Mark

[Former Member · Accepted solution]

Should I have a link between /usr/sap/SEC/SYS/profile/START_DVEBMGS00_ulvcp705d and /usr/sap/SEC/SYS/exe/run/stopsap on /home/secadm ??

Can this help ?

@Mark:

/oracle/SEC/102_64/lib:] ls -lart libclntsh.a

-rw------- 1 orasec dba 25031924 Sep 14 17:59 libclntsh.a

I have changed the permisison to read for all the users: -rw-rr for libclntsh.so and libclntsh.a.

Edited by: Jordy_tof on Sep 15, 2011 12:02 PM

[Former Member · Accepted solution]

Hi,

I was looking for permissions of the dboraslib.o file in /sapmnt/<SID>/exe

Mark

[Former Member · Accepted solution]

Hi Mark,

/sapmnt/SEC/exe:] ls -lart dboraslib.o

-rwxrwxrwx 1 secadm sapsys 5459828 Oct 29 2010 dboraslib.o

[Former Member · Accepted solution]

Thanks...

Looking back up through the thread, if I'm correct your oracle client (env) is looking at the instant client ?

For testing purposes can you point it at what the ora<sid> is set too. E.G /oracle/SEC/102_64/lib and then run

R3trans -x

Mark

[Former Member · Accepted solution]

Hi Jordy,

Please check if path "/usr/sap/SEC/SYS/exe/run" really exists...

Please set below environment as <sid>adm and try "R3trans -d"

export LIB_DIRECTORY=/usr/sap/sec/SYS/exe/run:/oracle/client/10x_64/instantclient

OR

setenv LIB_DIRECTORY /usr/sap/sec/SYS/exe/run:/oracle/client/10x_64/instantclient

(depend on your shell csh or sh)

Refer the below notes carefully.

[Note 830578 - Oracle database 10g: Unix environment variable|https://service.sap.com/sap/support/notes/830578]

and

[Note 602843 - Environment settings for R/3/Oracle on UNIX|https://service.sap.com/sap/support/notes/602843]

You can also try upgrading the SAP Kernel with latest one...

Regards.

Rajesh Narkhede

[Former Member · Accepted solution]

Hi Rajesh,

Thanks.

Should I setenv LIB_DIRECTORY or setenv DIR_LIBRARY ... ?

[Former Member · Accepted solution]

Hi Jordy,

Should I setenv LIB_DIRECTORY or setenv DIR_LIBRARY ... ?

Extremely sorry for my typo mistake...

you should set it as DIR_LIBRARY

export DIR_LIBRARY=/usr/sap/sec/SYS/exe/run:/oracle/client/10x_64/instantclient

OR

setenv DIR_LIBRARY /usr/sap/sec/SYS/exe/run:/oracle/client/10x_64/instantclient

Rajesh Narkhede

[Former Member · Accepted solution]

Hi, No problem.

it is the same

setenv DIR_LIBRARY /usr/sap/SEC/SYS/exe/run:/oracle/client/10x_64/instantclient

ulvcp705d:secadm 2> R3trans -d

This is R3trans version 6.14 (release 700 - 23.07.10 - 09:23:00).

unicode enabled version

2EETW169 no connect possible: "maybe someone set invalid values for DIR_LIBRARY ('/usr/sap/SEC/SYS/exe/run:/oracle/client/10x_64/instantclient') or dbms_type ('ORA')"

R3trans finished (0012).

[Former Member · Accepted solution]

HI Jordy,

Can you paste the fresh "trans.log"

Regards.

Rajesh Narkhede

[Former Member · Accepted solution]

ulvcp705d:secadm 2> R3trans -d

This is R3trans version 6.14 (release 700 - 23.07.10 - 09:23:00).

unicode enabled version

2EETW169 no connect possible: "maybe someone set invalid values for DIR_LIBRARY ('/usr/sap/SEC/SYS/exe/run:/oracle/client/10x_64/instantclient') or dbms_type ('ORA')"

R3trans finished (0012).

I have changed it back the way it was to /usr/sap/SEC/SYS/exe/run

/sapmnt/SEC/profile:] cat trans.log

4 ETW000 R3trans version 6.14 (release 700 - 23.07.10 - 09:23:00).

4 ETW000 unicode enabled version

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

4 ETW000

4 ETW000 date&time : 14.09.2011 - 18:12:38

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] Wed Sep 14 18:12:39 2011 51205 0.051205

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

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

4 ETW000 [dev trc ,00000] Loading DB library '/usr/sap/SEC/SYS/exe/run/dboraslib.o' ... 561 0.053455

4 ETW000 [dlux.c ,00000] *** ERROR => DlLoadLib()==DLENOACCESS - dlopen("/usr/sap/SEC/SYS/exe/run/dboraslib.o") FAILED

4 ETW000 "Permission denied" (errno=13,Permission denied) 51240 0.104695

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

4 ETW000 1411 0.106106

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

[Former Member · Accepted solution]

Hi Jordy,

I would recommend try upgrading your SAP Kernel.

All environment settings and permissions seems to be correct for me... so try updating whole kernel or at lease DBSL.

(At least you will have something different for further analysis...)

Regards.

Rajesh Narkhede

[Former Member · Accepted solution]

Hi all,

what is strange is that I have ora porcesses running for the source system )

I am going crazy.

ps -ef | grep orasec

orasec 1835198 1 0 18:45:09 - 0:00 /oracle/SEC/102_64/bin/tnslsnr LISTENER -inherit

orasec 3604650 1 0 15:22:49 - 0:00 ora_smon_DEC

orasec 4456674 1 0 15:22:49 - 0:00 ora_mman_DEC

orasec 4718628 1 0 15:22:49 - 0:00 ora_ckpt_DEC

orasec 5242942 5308872 0 11:03:24 pts/2 0:00 sqlplus

orasec 5439496 1 0 15:22:49 - 0:00 ora_mmnl_DEC

orasec 5505026 1 0 15:22:49 - 0:00 ora_dbw0_DEC

orasec 5636112 5242942 0 11:03:24 - 0:00 oracleSEC (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))

orasec 2097410 1 0 15:22:49 - 0:00 ora_psp0_DEC

orasec 3735924 1 0 15:22:49 - 0:00 ora_reco_DEC

orasec 4325746 1 0 15:22:49 - 0:00 ora_mmon_DEC

orasec 4653338 1 0 15:22:49 - 0:00 ora_lgwr_DEC

orasec 4718946 1 0 15:22:49 - 0:04 ora_pmon_DEC

orasec 5308872 2818258 0 11:00:28 pts/2 0:00 -csh

root 5439904 4260120 0 11:06:28 pts/1 0:00 grep orasec

[Former Member]

what is strange is that I have ora porcesses running for the source system :))
I am going crazy.

I think system is behaving correctly, It seems your database is up and running.

But while starting the application its not connecting (I am sure that some where the link has broken).

*I remember that couple of times I faced the same issue with libclntsh library (with invalid softlink and insufficient permissions)

Regards,

Nick Loy

[Former Member]

Hello,

Problem solved.

In /oracle -> the directory client was not having read permissions and it was not set to secadm:dba.

I also killed all the non related processes.

I did it and now:

R3trans -d

This is R3trans version 6.14 (release 700 - 23.07.10 - 09:23:00).

unicode enabled version

R3trans finished (0000).

Amazing, no ?

How can a machine play tricks with our brains ?

Anyway, THANKS TO ALL.

I have learnt a lot of things today from you, and I wish you all the best for this.

Have a good day !!

[Former Member]

Just fire ls -la libclnt*

If there is no --> then there is no soft link inbetween libclnt.

Regards,

Nick Loy

[Former Member]

Hey Nick,

/oracle/SEC/102_64/lib:] ls -la libclnt*

-rwxrwxrwx 1 orasec dba 25031924 Sep 14 17:59 libclntsh.a

-rwxrwxrwx 1 orasec dba 24447632 Sep 14 17:59 libclntsh.so

-rwxr-xr-x 1 orasec dba 24476547 Aug 10 2010 libclntsh.so.10.1

lrwxrwxrwx 1 orasec dba 17 Sep 08 14:19 libclntsh.so.old -> libclntsh.so.10.1

-rw-rr 1 orasec dba 0 Aug 14 2005 libclntst10.a

Edited by: Jordy_tof on Sep 15, 2011 11:35 AM

[Former Member]

Check whether libclntsh has the read permissions for SIDADM user.

Check the softlinks as well.

Regards,

Nick Loy

[Former Member]

Have you done all post-restore steps?

DB recovery, startup, creation of OPS$users etc

Just follow the standard homogenous system copy guide and complete all the steps.

*Return code 12 is a very generic error , you can find the exact cause of the error in dev_w0 log file

Regards,

Nick Loy

[Former Member]

Please check if you have placed the valid oracle libraries under '/usr/sap/SID/SYS/exe/run'

Thanks

Srikanth M

[volker_borowski2]

Hi,

find out if the db is really running or not !

brconnect -c -u / -f dbstate

sqlplus / as sysdba

select status, instance_name from v$instance;

exit

Either the DB is not OPEN at all, or the listener/tnsnames configuration prohibits a connect to the DB.

To check the listener, check environment:

ORACLE_HOME / TNS_ADMIN

and the sqlnet configfiles sqlnet.ora, listener.ora, tnsnames.ora

Volker

Oh, and you DID adjust the ops$ connect for the new sid after the sys copy ? -> Say YES !

Edited by: Volker Borowski on Sep 14, 2011 9:31 PM

[Former Member]

Hi all,

trans.log shows:

4 ETW000 R3trans version 6.14 (release 700 - 23.07.10 - 09:23:00).

4 ETW000 unicode enabled version

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

4 ETW000

4 ETW000 date&time : 15.09.2011 - 07:24:39

4 ETW000 control file: <no ctrlfile>

4 ETW000 R3trans was called as follows: R3trans -d -w /home/sidadm/dbconn.log

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

4 ETW000 [dev trc ,00000] Thu Sep 15 07:24:39 2011 90 0.000090

4 ETW000 [dev trc ,00000] db_con_init called 15 0.000105

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

4 ETW000 [dev trc ,00000] Loading DB library '/usr/sap/SID/SYS/exe/run/dboraslib.o' ... 23 0.000168

4 ETW000 [dlux.c ,00000] *** ERROR => DlLoadLib()==DLENOACCESS - dlopen("/usr/sap/SID/SYS/exe/run/dboraslib.o") FAILED

4 ETW000 "Permission denied" (errno=13,Permission denied) 413 0.000581

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

4 ETW000 49 0.000630

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

$OPS users script: -> ORADBUSR.SQL, which I think it worked fine:

sqlplus /NOLOG @/oracle/SID/sapbackup/ORADBUSR.SQL SAPSR3 UNIX SEC X

SQL*Plus: Release 10.2.0.5.0 - Production on Wed Sep 14 16:19:59 2011

Copyright (c) 1982, 2010, Oracle. All Rights Reserved.

Connected.

old 6: if length('&&1') = 5 then

new 6: if length('SAPSR3') = 5 then

old 7: if substr(upper('&&1'),1,5) = 'SAPR3' then

new 7: if substr(upper('SAPSR3'),1,5) = 'SAPR3' then

old 11: if upper('&&2') = 'NT' then

new 11: if upper('UNIX') = 'NT' then

old 18: :sDomain := upper('&&3');

new 18: :sDomain := upper('SEC');

old 19: :sSapSid := upper('&&4');

new 19: :sSapSid := upper('X');

old 21: :sSapSid := upper('&&3');

new 21: :sSapSid := upper('SEC');

old 37: :sSchema := upper('&&1');

new 37: :sSchema := upper('SAPSR3');

old 39: if upper('&&2') = 'NT' then

new 39: if upper('UNIX') = 'NT' then

old 46: :sDomain := upper('&&3');

new 46: :sDomain := upper('SEC');

old 47: :sSapSid := upper('&&4');

new 47: :sSapSid := upper('X');

old 49: :sSapSid := upper('&&3');

new 49: :sSapSid := upper('SEC');

using following Parameters:

.

. Oracle Version: 10.2.0.5.0

. Parametervalue os_authent_prefix: OPS$

. Schema Id: SR3

. Database User (Schema): SAPSR3

. SAP R/3 Administrator: OPS$SECADM

. SAP R/3 Serviceuser: OPS$SAPSERVICESEC

.

Connected.

Connected.

Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production

With the Partitioning, Data Mining and Real Application Testing options

Edited by: Jordy_tof on Sep 15, 2011 9:27 AM

[Former Member]

Hi

4 ETW000 dev trc ,00000 Loading DB library '/usr/sap/SID/SYS/exe/run/dboraslib.o' ... 23 0.000168
4 ETW000 http://dlux.c ,00000 *** ERROR => DlLoadLib()==DLENOACCESS - dlopen("/usr/sap/SID/SYS/exe/run/dboraslib.o") FAILED
4 ETW000 "Permission denied" (errno=13,Permission denied) 413 0.000581
4 ETW000 http://dbcon.c ,00000 *** ERROR => Couldn't load library '/usr/sap/SID/SYS/exe/run/dboraslib.o'

Seems that permissions of kernel binaries are not set properly.

1. login to the OS as ROOT user.

2. Navigate to /sapmnt/<SID>/exe directory.

3. execute "# sh /sapmnt/<SID>/exe/saproot.sh <SID>" command

4. execute "# sh /sapmnt/<SID>/exe/oraroot.sh <SID>" command

it will set the permission correctly. Then try again...

OR run "R3trans -d" and paste fresh log "trans.log"

Also check environment variable "DIR_LIBRARY"

It should return something '/usr/sap/SEC/SYS/exe/run'

Regards.

Rajesh Narkhede

[Former Member]

Hello,

I have done these:

sh /sapmnt/SID/exe/saproot.sh SID

Preparing /usr/sap/SID/SYS/exe/run/brbackup ...

Preparing /usr/sap/SID/SYS/exe/run/brarchive ...

Preparing /usr/sap/SID/SYS/exe/run/brconnect ...

Preparing saposcol ...

Preparing icmbnd ...

done

:root:/sapmnt/SID/exe:] sh /sapmnt/SID/exe/oraroot.sh SID

done

:root:/sapmnt/SID/exe:] su - oraSID

YOU HAVE NEW MAIL

:oraSID 1> R3trans -d

This is R3trans version 6.14 (release 700 - 23.07.10 - 09:23:00).

unicode enabled version

R3trans finished (0000).

:oraSID 2> echo $DIR_LIBRARY

/usr/sap/SID/SYS/exe/run

Still same errors:

R3trans -d

This is R3trans version 6.14 (release 700 - 23.07.10 - 09:23:00).

unicode enabled version

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

R3trans finished (0012).

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

4 ETW000 [dev trc ,00000] Loading DB library '/usr/sap/SID/SYS/exe/run/dboraslib.o' ... 25 0.000210

4 ETW000 [dlux.c ,00000] *** ERROR => DlLoadLib()==DLENOACCESS - dlopen("/usr/sap/SID/SYS/exe/run/dboraslib.o") FAILED

4 ETW000 "Permission denied" (errno=13,Permission denied) 386 0.000596

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

4 ETW000 53 0.000649

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

[Former Member]

Hi,

:oraSID 2> echo $DIR_LIBRARY
/usr/sap/SID/SYS/exe/run

What is your actual SID ?

can you paste the out or "env" command for both <sid>adm and ora<sid>

"Do not replace SID in output", paste it as it is...

Regards.

Rajesh Narkhede

[Former Member]

Hi Jordy,

Check, whether the permissions correctly configured under /etc/groups;

dba -> ora<sid>, <sid>adm

oper -> ora<sid>, <sid>adm

sapsys -> <sid>adm

Best regards,

Orkun Gedik

[Former Member]

Hi Orkun,

Just checked that, seems fine for all 3.

Thanks.

[Former Member]

Hi,

Have you read my [previous post |]?

Paste the output of "env" command for both <sid>adm and ora<sid>

There must be something wrong in environment of one of the user.

Regards.

Rajesh Narkhede

[Former Member]

Hi Jordy,

In order to be at the safe side, provide the output of the items, below;

1) "echo $DIR_LIBRARY" under <sid>adm

2) ls -ltr /usr/sap/SID/SYS/exe/run/dbora*

Best regards,

Orkun Gedik

[Former Member]

Hi again,

Rajesh:

secadm 1> echo $DIR_LIBRARY

/usr/sap/SEC/SYS/exe/run

root:/usr/sap/SEC/SYS/exe/run:] su - orasec

YOU HAVE NEW MAIL

orasec 1> echo $DIR_LIBRARY

/usr/sap/SEC/SYS/exe/run

ENV -> ORASEC:

orasec 2> env

TERM=xterm

AUTHSTATE=files

SHELL=/usr/bin/csh

HOME=/oracle/SEC

USER=orasec

PATH=/oracle/SEC/102_64/bin:/oracle/SEC:/usr/sap/SEC/SYS/exe/run:/usr/bin:/etc:/usr/sbin:/usr/ucb:/oracle/SEC/bin:/usr/bin/X11:/sbin:.

TZ=CUT0

LANG=en_US

LOCPATH=/usr/lib/nls/loc

LC__FASTMSG=true

ODMDIR=/etc/objrepos

WSM_DOC_DIR="/usr/websm/http/com.ibm.websm.http.server_1.0.0"

WSM_CGI_DIR=

WSM_WS_CMD="startsrc -s http4websm"

DSM_CONFIG=/usr/tivoli/tsm/client/ba/bin/dsm.opt

DSMI_CONFIG=/usr/tivoli/tsm/client/api/bin64/dsm.opt

DSM_LOG=/exploit/logs/tsm

DSMI_LOG=/exploit/logs/tsm

DSM_DIR=/usr/tivoli/tsm/client/ba/bin

DSMI_DIR=/usr/tivoli/tsm/client/api/bin64

LOGNAME=orasec

LOGIN=orasec

SAPSYSTEMNAME=SEC

DIR_LIBRARY=/usr/sap/SEC/SYS/exe/run

THREAD=NOPS

dbms_type=ORA

dbs_ora_tnsname=SEC

dbs_ora_schema=SAPSR3

ORACLE_SID=SEC

DB_SID=SEC

ORACLE_BASE=/oracle

ORACLE_HOME=/oracle/SEC/102_64

NLS_LANG=AMERICAN_AMERICA.UTF8

SAPDATA_HOME=/oracle/SEC

MAIL=/var/spool/mail/orasec

MAILMSG=YOU HAVE NEW MAIL

NLSPATH=/usr/lib/nls/msg/%L/%N:/usr/lib/nls/msg/%L/%N.cat

LIBPATH=/usr/lib:/lib:/usr/sap/SEC/SYS/exe/run:/oracle/SEC/102_64/lib

ENV -> SECADM

secadm 1> env

TERM=xterm

AUTHSTATE=files

SHELL=/usr/bin/csh

HOME=/home/secadm

USER=secadm

PATH=/oracle/SEC/102_64/bin:/usr/java14_64/bin:/home/secadm:/usr/sap/SEC/SYS/exe/run:/usr/bin:/etc:/usr/sbin:/usr/ucb:/home/secadm/bin:/usr/bin/X11:/sbin:.

TZ=CUT0

LANG=en_US

LOCPATH=/usr/lib/nls/loc

LC__FASTMSG=true

ODMDIR=/etc/objrepos

WSM_DOC_DIR="/usr/websm/http/com.ibm.websm.http.server_1.0.0"

WSM_CGI_DIR=

WSM_WS_CMD="startsrc -s http4websm"

DSM_CONFIG=/usr/tivoli/tsm/client/ba/bin/dsm.opt

DSMI_CONFIG=/usr/tivoli/tsm/client/api/bin64/dsm.opt

DSM_LOG=/exploit/logs/tsm

DSMI_LOG=/exploit/logs/tsm

DSM_DIR=/usr/tivoli/tsm/client/ba/bin

DSMI_DIR=/usr/tivoli/tsm/client/api/bin64

LOGNAME=secadm

LOGIN=secadm

SAPSYSTEMNAME=SEC

DIR_LIBRARY=/usr/sap/SEC/SYS/exe/run

JAVA_HOME=/usr/java14_64

IBM_JAVA_OPTIONS=-Xmx256M -Xj9

THREAD=NOPS

dbms_type=ORA

dbs_ora_tnsname=SEC

dbs_ora_schema=SAPSR3

ORACLE_SID=SEC

DB_SID=SEC

ORACLE_BASE=/oracle

TNS_ADMIN=/usr/sap/SEC/SYS/profile/oracle

ORACLE_HOME=/oracle/SEC/102_64

NLS_LANG=AMERICAN_AMERICA.UTF8

SAPDATA_HOME=/oracle/SEC

MAIL=/var/spool/mail/secadm

MAILMSG=YOU HAVE NEW MAIL

NLSPATH=/usr/lib/nls/msg/%L/%N:/usr/lib/nls/msg/%L/%N.cat

LIBPATH=/usr/lib:/lib:/usr/sap/SEC/SYS/exe/run:/oracle/client/10x_64/instantclient

-

---

@Orkun :

secadm 1> echo $DIR_LIBRARY

/usr/sap/SEC/SYS/exe/run

root:/usr/sap/SEC/SYS/exe/run:] su - orasec

YOU HAVE NEW MAIL

orasec 1> echo $DIR_LIBRARY

/usr/sap/SEC/SYS/exe/run

ls -ltr /usr/sap/SEC/SYS/exe/run/dbora*

-rwxr-xr-x 1 secadm sapsys 4835554 Dec 11 2009 /usr/sap/SEC/SYS/exe/run/dboraslib.o.old

-rwxrwxrwx 1 secadm sapsys 5459828 Oct 29 2010 /usr/sap/SEC/SYS/exe/run/dboraslib.o

-

---

@Nick:

/oracle/SEC/102_64/lib:] ls -lart libclntsh.a

-rw------- 1 orasec dba 25031924 Sep 14 17:59 libclntsh.a

I have changed the permisison to read for all the users: -rw-rr for libclntsh.so and libclntsh.a.

How can I check the softlinks ?

Thanks to all

Edited by: Jordy_tof on Sep 15, 2011 11:22 AM

Edited by: Jordy_tof on Sep 15, 2011 11:25 AM

Edited by: Jordy_tof on Sep 15, 2011 11:25 AM

[Former Member]

With sidadm user, run R3trans -d and paste trans.log contents here

Thanks