Error when start SAP system after a Oracle Instant Client update

[Former Member]

Hello,

OS - Solaris v10 (SPARC)

SAP - ERP 6.0 EHP5

DB - Oracle 11.2 (11.2.0.2)

I performed an update to the Oracle Instant Client from the version 10.2.0.2 to 11.2.0.2.

I followed the instructions in SAP note 819829 (Oracle Instant Client Installation and Configuration on Unix). I also changed the BR*Tools version from release 7.20 to the release 7.20_EXT (but I´m still running the Kernel 7.20 UC (level 401) and DBSL level 327) and I did this because in sap note 819829 is described in "Configuring Oracle Instant Client 11.2 for SAP BR*Tools 7.20" that is necessary to change it to that EXT kernel version because this version is based on 11.2 instant client!

After that I tried to start the SAP system, I started the oracle database (with ora<sid>) and then with <sid>adm I ran the command startsap r3 but unfortunatelly the system doesn´t started!

I believe there is a problema with something related with OCI... Can you help me please to correct this issue!?

I ran the command R3trans -x and it show me the following lines:

...

4 ETW000  [	dev trc,00000]  -->DbSlControl(con=-1,cmd=47=DBSL_CMD_IMP_FUNS_SET) -> changed=30, tagset=1
4 ETW000	1363  0.021144
4 ETW000  [	dev trc,00000]  -->DbSlControl(con=-1,cmd=39=DBSL_CMD_SET_SINGLETASK)	48  0.021192
4 ETW000  [	dev trc,00000]  -->DbSlControl(con=-1,cmd=10=DBSL_CMD_DBCA_PTR_GET)	44  0.021236
4 ETW000  [	dev trc,00000]  New connection 0 created	39  0.021275
4 ETW000  [	dev trc,00000]  0: name = R/3, con_id = -000000001, state = DISCONNECTED, tx = NO , bc = NO , hc = NO , perm = YES, reco = NO , frco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO , prog =
4 ETW000	75  0.021350
4 ETW000  [	dev trc,00000]  -->DbSlControl(con=-1,cmd=10=DBSL_CMD_DBCA_PTR_GET)	46  0.021396
4 ETW000  [	dev trc,00000]  db_con_connect (con_name=R/3)	37  0.021433
4 ETW000  [	dev trc,00000]  determine_block_commit: no con_hdl found as blocked for con_name = R/3
4 ETW000	59  0.021492
4 ETW000  [	dev trc,00000]  find_con_by_name found the following connection:	36  0.021528
4 ETW000  [	dev trc,00000]  0: name = R/3, con_id = 000000000, state = DISCONNECTED, tx = NO , bc = NO , hc = NO , perm = YES, reco = NO , frco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO , prog =
4 ETW000	71  0.021599
4 ETW000  [	dev trc,00000]  -->DbSlConnect(vers=-1, type=0, env='[default env]', usr='[default usr]', kernel dbsl='720')
4 ETW000	127  0.021726
4 ETW000  [	dev trc,00000]  Register application info.	286  0.022012
4 ETW000  [	dev trc,00000]  Oracle client version: 10.2.0.2.0, (dbsl 720 291112, UNICODE[2])	95  0.022107
4 ETW000  [	dev trc,00000]  Detailed Oracle client (patch) info not available.	43  0.022150
4 ETW000  [	dev trc,00000]  Oracle instant client is out-of-date or not delivered by SAP.	40  0.022190
4 ETW000  [	dev trc,00000]  See SAP note 819829 for more info.	38  0.022228
4 ETW000  [	dev trc,00000]	Default connection: tnsname ='AZQ'	40  0.022268
4 ETW000  [	dev trc,00000]  -->oci_initialize(con=0, char='UTF16', nchar='AL16UTF16', nls=-1),uc_ln=2
4 ETW000	72  0.022340
4 ETW000  [	dev trc,00000]	OCIEnvCreate(mode=16384=OCI_UTF16) failed with -1=OCI_ERROR	35420  0.057760
4 ETW000  [	dev trc,00000]  OCIErrorGet() failed with rc=-2	121  0.057881
4 ETW000  [	dev trc,00000]	-> no further error details available	46  0.057927
4 ETW000  [	dev trc,00000]  OCIEnvCreate(mode=16384=OCI_UTF16) returned -1 (for default NLS handle)
4 ETW000	70  0.057997
4 ETW000  [	dev trc,00000]  Nls CharacterSet	NationalCharSet	EnvHp	ErrHp	ErrBt
4 ETW000	103  0.058100
4 ETW000  [	dev trc,00000]	0 UTF16	AL16UTF16	0000NULL	0000NULL	0000NULL
4 ETW000	99  0.058199
4 ETW000  [	dev trc,00000]	set_ocica() -> OCI return code -1	64  0.058263
4 ETW000  [	dev trc,00000]	DbSlConnect(con=0) -> orc=-1, 99=DBSL_ERR_DB	51  0.058314
4 ETW000  [	dblink  ,00000]  ***LOG BY2=>sql error -1	performing CON	90  0.058404
4 ETW000  [	dblink  ,00000]  ***LOG BY0=>OCI returned error code -1.	49  0.058453
4 ETW000  [	dev trc,00000]  -->DbSlControl(con=-1,cmd=41=DBSL_CMD_RELINFO_GET)	52  0.058505
4 ETW000  [	dev trc,00000]  -->DbSlControl(con=-1,cmd=14=DBSL_CMD_VERSION_GET)	45  0.058550
4 ETW000  [	dev trc,00000]  -->DbSlControl(con=-1,cmd=50=DBSL_CMD_GET_PATCH_INFO)	44  0.058594
4 ETW000  [	dev trc,00000]  -->DbSlControl(con=-1,cmd=13=DBSL_CMD_VENDOR_NAME_GET)	142  0.058736
4 ETW000  [	dev trc,00000]  -->DbSlControl(con=-1,cmd=52=DBSL_CMD_GET_DBLIB_VERSION)	46  0.058782
4 ETW000  [	dev trc,00000]	-> 'OCI_102, 10.2.0.2.0'	45  0.058827
2EETW169 no connect possible: "DBMS = ORACLE	--- dbs_ora_tnsname = 'AZQ'"

Can you help me please?

Thank you,

samid raif

[Reagan · Accepted solution]

Hello Samid

What is the version of Solaris you have ?

If you have Solaris 11 then you need to use EXT version of the kernel.

1669684 - SAP on Oracle Solaris 11

1643799 - Support for Oracle Solaris 11

The SAP note 819829 says that for Solaris 11, you must use Oracle Instant Client 11.2.0.3 or higher. See SAP note 1642058.

Maybe this is the reason why the kernel is looking for the 10G instant client files.

The last thing I would try is to adapt these files to 11G instant client location

liszgpsap002:oraazq 2% grep client .*

.dbenv.csh:  set ADD=/oracle/client/10x_64/instantclient

.dbenv.sh:  ADD=/oracle/client/10x_64/instantclient

.dbenv_liszgpsap002.csh:  set ADD=/oracle/client/10x_64/instantclient

.dbenv_liszgpsap002.sh:  ADD=/oracle/client/10x_64/instantclient

I know it is stupid and not used by the system but worth trying.

Once done log off from the session and then switch to the sidadm user and run R3trans -d and provide the output.

Regards

RB

[Former Member · Accepted solution]

Hi Reagan,

What is the version of Solaris you have ?

It´s a Solaris version 10

liszgpsap002:azqadm 4% uname -a

SunOS liszgpsap002 5.10 Generic_147440-16 sun4v sparc sun4v

The last thing I would try is to adapt these files to 11G instant client location

I did that, but when I tried to start again the SAP with user <sid>adm with startsap r3 once again it show me an error:

liszgpsap002:azqadm 1% startsap r3

Checking AZQ Database

Database is not available via R3trans

-------------------------------------------

Database AZQ must be started first

The oracle database is started!

I ran again the R3trans -d:

4 ETW000 R3trans version 6.23 (release 720 - 31.10.12 - 20:12:06).

4 ETW000 unicode enabled version

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

4 ETW000

4 ETW000 date&time   : 07.12.2013 - 19:02:33

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]  Sat Dec  7 19:02:33 2013                                                 165  0.000165

4 ETW000  [     dev trc,00000]  db_con_init called                                                        41  0.000206

4 ETW000  [     dev trc,00000]  set_use_ext_con_info(): rsdb/ssfs_connect not set => ssfs not used        55  0.000261

4 ETW000  [     dev trc,00000]  determine_block_commit: no con_hdl found as blocked for con_name = R/3

4 ETW000                                                                                                  64  0.000325

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

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

4 ETW000  [     dev trc,00000]  DlLoadLib() success: dlopen("/usr/sap/AZQ/SYS/exe/run/dboraslib.so"), hdl 0

4 ETW000                                                                                               17309  0.017756

4 ETW000  [     dev trc,00000]  Library '/usr/sap/AZQ/SYS/exe/run/dboraslib.so' loaded                    62  0.017818

4 ETW000  [     dev trc,00000]  function DbSlExpFuns loaded from library /usr/sap/AZQ/SYS/exe/run/dboraslib.so

4 ETW000                                                                                                  78  0.017896

4 ETW000  [     dev trc,00000]  Version of '/usr/sap/AZQ/SYS/exe/run/dboraslib.so' is "720.00", patchlevel (0.327)

4 ETW000                                                                                                 637  0.018533

4 ETW000  [     dev trc,00000]  function dsql_db_init loaded from library /usr/sap/AZQ/SYS/exe/run/dboraslib.so

4 ETW000                                                                                                  73  0.018606

4 ETW000  [     dev trc,00000]  function dbdd_exp_funs loaded from library /usr/sap/AZQ/SYS/exe/run/dboraslib.so

4 ETW000                                                                                                 122  0.018728

4 ETW000  [     dev trc,00000]  -->DbSlControl(con=-1,cmd=47=DBSL_CMD_IMP_FUNS_SET) -> changed=30, tagset=1

4 ETW000                                                                                                1225  0.019953

4 ETW000  [     dev trc,00000]  -->DbSlControl(con=-1,cmd=39=DBSL_CMD_SET_SINGLETASK)                     47  0.020000

4 ETW000  [     dev trc,00000]  -->DbSlControl(con=-1,cmd=10=DBSL_CMD_DBCA_PTR_GET)                       44  0.020044

4 ETW000  [     dev trc,00000]  New connection 0 created                                                  39  0.020083

4 ETW000  [     dev trc,00000]  0: name = R/3, con_id = -000000001, state = DISCONNECTED, tx = NO , bc = NO , hc = NO , perm = YES, reco = NO , frco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO , prog = 

4 ETW000                                                                                                  74  0.020157

4 ETW000  [     dev trc,00000]  -->DbSlControl(con=-1,cmd=10=DBSL_CMD_DBCA_PTR_GET)                       45  0.020202

4 ETW000  [     dev trc,00000]  db_con_connect (con_name=R/3)                                             37  0.020239

4 ETW000  [     dev trc,00000]  determine_block_commit: no con_hdl found as blocked for con_name = R/3

4 ETW000                                                                                                  59  0.020298

4 ETW000  [     dev trc,00000]  find_con_by_name found the following connection:                          36  0.020334

4 ETW000  [     dev trc,00000]  0: name = R/3, con_id = 000000000, state = DISCONNECTED, tx = NO , bc = NO , hc = NO , perm = YES, reco = NO , frco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO , prog = 

4 ETW000                                                                                                  69  0.020403

4 ETW000  [     dev trc,00000]  -->DbSlConnect(vers=-1, type=0, env='[default env]', usr='[default usr]', kernel dbsl='720')

4 ETW000                                                                                                 120  0.020523

4 ETW000  [     dev trc,00000]  Register application info.                                               262  0.020785

4 ETW000  [     dev trc,00000]  Oracle client version: 10.2.0.2.0, (dbsl 720 291112, UNICODE[2])          88  0.020873

4 ETW000  [     dev trc,00000]  Detailed Oracle client (patch) info not available.                        43  0.020916

4 ETW000  [     dev trc,00000]  Oracle instant client is out-of-date or not delivered by SAP.             39  0.020955

4 ETW000  [     dev trc,00000]  See SAP note 819829 for more info.                                        38  0.020993

4 ETW000  [     dev trc,00000]    Default connection: tnsname ='AZQ'                                      40  0.021033

4 ETW000  [     dev trc,00000]  -->oci_initialize(con=0, char='UTF16', nchar='AL16UTF16', nls=-1),uc_ln=2

4 ETW000                                                                                                  69  0.021102

4 ETW000  [     dev trc,00000]     OCIEnvCreate(mode=16384=OCI_UTF16) failed with -1=OCI_ERROR     32971  0.054073

4 ETW000  [     dev trc,00000]  OCIErrorGet() failed with rc=-2                                          108  0.054181

4 ETW000  [     dev trc,00000]    -> no further error details available                                   45  0.054226

4 ETW000  [     dev trc,00000]  OCIEnvCreate(mode=16384=OCI_UTF16) returned -1 (for default NLS handle)

4 ETW000                                                                                                  67  0.054293

4 ETW000  [     dev trc,00000]  Nls CharacterSet                      NationalCharSet                   EnvHp            ErrHp            ErrBt          

4 ETW000                                                                                                 100  0.054393

4 ETW000  [     dev trc,00000]    0 UTF16                             AL16UTF16                         0000NULL         0000NULL         0000NULL       

4 ETW000                                                                                                  98  0.054491

4 ETW000  [     dev trc,00000]     set_ocica() -> OCI return code -1                                      60  0.054551

4 ETW000  [     dev trc,00000]     DbSlConnect(con=0) -> orc=-1, 99=DBSL_ERR_DB                           50  0.054601

4 ETW000  [    dblink  ,00000]  ***LOG BY2=>sql error -1     performing CON                               85  0.054686

4 ETW000  [    dblink  ,00000]  ***LOG BY0=>OCI returned error code -1.                                   48  0.054734

4 ETW000  [     dev trc,00000]  -->DbSlControl(con=-1,cmd=41=DBSL_CMD_RELINFO_GET)                        49  0.054783

4 ETW000  [     dev trc,00000]  -->DbSlControl(con=-1,cmd=14=DBSL_CMD_VERSION_GET)                        45  0.054828

4 ETW000  [     dev trc,00000]  -->DbSlControl(con=-1,cmd=50=DBSL_CMD_GET_PATCH_INFO)                     43  0.054871

4 ETW000  [     dev trc,00000]  -->DbSlControl(con=-1,cmd=13=DBSL_CMD_VENDOR_NAME_GET)                   123  0.054994

4 ETW000  [     dev trc,00000]  -->DbSlControl(con=-1,cmd=52=DBSL_CMD_GET_DBLIB_VERSION)                  46  0.055040

4 ETW000  [     dev trc,00000]                 -> 'OCI_102, 10.2.0.2.0'                                   44  0.055084

2EETW169 no connect possible: "DBMS = ORACLE                           --- dbs_ora_tnsname = 'AZQ'"

Any tips?

Kind regards,

samid raif

[Reagan · Accepted solution]

Do you have any files under /oracle/client/10x_64 ?

If not rename that directory and create a symbolic link and see whether it helps.

ln -s /oracle/client/11x_64 /oracle/client/10x_64

Regards

RB

[Reagan · Accepted solution]

I don't know how or why the kernel is still pointing to the 10G client.

As the environment variables are pointing to the 11G location then most probably a new version of kernel could be the solution.

su - azqadm

ldd /usr/sap/AZQ/SYS/exe/run/dboraslib.so

Check which files it is looking for.

Regards

RB

[Former Member · Accepted solution]

Hi Reagan,

Yes, I have the following files under /oracle/client/10x_64:

liszgpsap002:azqadm 18% cd 10x_64

liszgpsap002:azqadm 19% ls -ltra

total 12

drwxrwxr-x   2 azqadm   sapsys         9 Mar 27  2006 instantclient_10202

-rwxrwxr-x   1 azqadm   sapsys       100 Mar 27  2006 dbclient.lst

lrwxrwxrwx   1 azqadm   sapsys        41 Jun 19  2012 instantclient -> /oracle/client/10x_64/instantclient_10202

drwxrwxr-x   3 azqadm   sapsys         5 Jun 19  2012 .

drwxr-xr-x   4 root     root           4 Dec  6 18:54 ..

I did what you said, I rename the 10x_64 and I created a symbolic link:

liszgpsap002# mv 10x_64 10x_64_old

liszgpsap002# ls -ltr

total 6

drwxrwxr-x   3 azqadm   sapsys         5 Jun 19  2012 10x_64_old

drwxrwxrwx   3 azqadm   sapsys         5 Dec  6 19:18 11x_64

liszgpsap002# ln -s /oracle/client/11x_64 /oracle/client/10x_64

liszgpsap002# ls -ltr

total 7

drwxrwxr-x   3 azqadm   sapsys         5 Jun 19  2012 10x_64_old

drwxrwxrwx   3 azqadm   sapsys         5 Dec  6 19:18 11x_64

lrwxrwxrwx   1 root     root          21 Dec  7 20:14 10x_64 -> /oracle/client/11x_64

But the SAP system doesn´t start... now is other error:

liszgpsap002:azqadm 2% R3trans -x

This is R3trans version 6.23 (release 720 - 31.10.12 - 20:12:06).

unicode enabled version

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

R3trans finished (0012).

echo $DIR_LIBRARY

/usr/sap/AZQ/SYS/exe/run

The output of R3trans -x command:

4 ETW000 R3trans version 6.23 (release 720 - 31.10.12 - 20:12:06).

4 ETW000 unicode enabled version

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

4 ETW000

4 ETW000 date&time   : 07.12.2013 - 20:20:45

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]  Sat Dec  7 20:20:45 2013                                                 180  0.000180

4 ETW000  [     dev trc,00000]  db_con_init called                                                        41  0.000221

4 ETW000  [     dev trc,00000]  set_use_ext_con_info(): rsdb/ssfs_connect not set => ssfs not used        58  0.000279

4 ETW000  [     dev trc,00000]  determine_block_commit: no con_hdl found as blocked for con_name = R/3

4 ETW000                                                                                                  64  0.000343

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

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

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

4 ETW000                          "ld.so.1: R3trans: fatal: /oracle/client/11x_64/instantclient/libclntsh.so.10.1: unknown file type"

4 ETW000                                                                                                1108  0.001571

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

4 ETW000                                                                                                 113  0.001684

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

Any tips?

Kind regards,

samid raif

[Reagan · Accepted solution]

Hello Samid

Did you use the right Oracle Instant Client for the OS ?

ls -la /oracle/client/11x_64/instantclient_11202

ls -la /oracle/client/11x_64/instantclient/libclntsh.so.10.1

Also provide the output of this command:

su - sidadm

sapcontrol -nr NN -function GetVersionInfo

Replace NN with the right system number.

Regards

RB

[Former Member · Accepted solution]

Hello Reagan,

The DVD media of Oracle Instant Client that I downloaded was the 51042930 and I´m using the files in .SAR file into the directory OCL_SOLARIS_SPARC:

\51042930\OCL_SOLARIS_SPARC

I believe this is the correct file of Oracle Instant Client 11.2.0.2!

liszgpsap002:azqadm 5% ls -la /oracle/client/11x_64/instantclient_11202

total 294275

drwxrwxrwx   2 azqadm   sapsys        16 Dec  6 19:07 .

drwxrwxrwx   3 azqadm   sapsys         5 Dec  6 19:18 ..

-rwxrwxrwx   1 azqadm   sapsys      3481 Mar 14  2012 SAPIC_README

-rwxrwxrwx   1 azqadm   sapsys     23456 Mar 14  2012 adrci

-rwxrwxrwx   1 azqadm   sapsys   1629710 Mar 14  2012 classes12.jar

-rwxrwxrwx   1 azqadm   sapsys     34656 Mar 14  2012 genezi

-rwxrwxrwx   1 azqadm   sapsys         0 Mar 14  2012 libclntsh.so

-rwxrwxrwx   1 azqadm   sapsys         0 Mar 14  2012 libclntsh.so.10.1

-rwxrwxrwx   1 azqadm   sapsys   48252544 Mar 14  2012 libclntsh.so.11.1

-rwxrwxrwx   1 azqadm   sapsys         0 Mar 14  2012 libnnz10.so

-rwxrwxrwx   1 azqadm   sapsys   7780640 Mar 14  2012 libnnz11.so

-rwxrwxrwx   1 azqadm   sapsys   85980664 Mar 14  2012 libociei.so

-rwxrwxrwx   1 azqadm   sapsys   1578277 Mar 14  2012 ojdbc14.jar

-rwxrwxrwx   1 azqadm   sapsys   2047217 Mar 14  2012 ojdbc5.jar

-rwxrwxrwx   1 azqadm   sapsys   2169317 Mar 14  2012 ojdbc6.jar

-rwxrwxrwx   1 azqadm   sapsys    456760 Mar 14  2012 wrc

liszgpsap002:azqadm 6% ls -la /oracle/client/11x_64/instantclient/libclntsh.so.10.1

-rwxrwxrwx   1 azqadm   sapsys         0 Mar 14  2012 /oracle/client/11x_64/instantclient/libclntsh.so.10.1

liszgpsap002:azqadm 7% sapcontrol -nr 00 -function GetVersionInfo

08.12.2013 02:35:40

GetVersionInfo

OK

Filename, VersionInfo, Time

/usr/sap/AZQ/DVEBMGS00/exe/sapstartsrv, 720, patch 401, changelist 1386868, optu (Jan 16 2013, 01:00:57), sun_64, 2013 01 16 02:54:14

/usr/sap/AZQ/DVEBMGS00/exe/disp+work, 720, patch 401, changelist 1386868, optu (Jan 15 2013, 15:37:50), sun_64, 2013 01 16 01:28:21

/usr/sap/AZQ/DVEBMGS00/exe/gwrd, 720, patch 401, changelist 1386868, optu (Jan 15 2013, 15:37:50), sun_64, 2013 01 16 01:33:43

/usr/sap/AZQ/DVEBMGS00/exe/msg_server, 720, patch 414, changelist 1391469, optu (Feb  2 2013, 07:46:34), sun_64, 2013 02 03 19:23:03

/usr/sap/AZQ/DVEBMGS00/exe/dboraslib.so, 720, patch 401, changelist 1386868, optu (Jan 15 2013, 15:37:50), sun_64, 2013 01 15 15:29:53

/usr/sap/AZQ/DVEBMGS00/exe/dbdb6slib.so, 720, patch 401, changelist 1386868, optu (Jan 15 2013, 15:37:50), sun_64, 2013 01 15 15:28:14

/usr/sap/AZQ/DVEBMGS00/exe/dbsybslib.so, 720, patch 401, changelist 1386868, optu (Jan 15 2013, 15:37:50), sun_64, 2013 01 15 18:54:00

/usr/sap/AZQ/DVEBMGS00/exe/enserver, 720, patch 401, changelist 1386868, optu (Jan 16 2013, 01:00:57), sun_64, 2013 01 16 02:43:48

/usr/sap/AZQ/DVEBMGS00/exe/icman, 720, patch 401, changelist 1386868, optu (Jan 16 2013, 01:00:57), sun_64, 2013 01 16 02:35:36

/usr/sap/AZQ/DVEBMGS00/exe/sapwebdisp, 720, patch 401, changelist 1386868, optu (Jan 16 2013, 01:00:57), sun_64, 2013 01 16 02:36:26

/usr/sap/AZQ/DVEBMGS00/exe/jcontrol, 720, patch 401, changelist 1386868, optu (Jan 16 2013, 01:00:57), sun_64, 2013 01 16 03:40:35

/usr/sap/AZQ/DVEBMGS00/exe/jlaunch, 720, patch 401, changelist 1386868, optu (Jan 16 2013, 01:00:57), sun_64, 2013 01 16 03:40:44

/usr/sap/AZQ/DVEBMGS00/exe/jstart, 720, patch 401, changelist 1386868, optu (Jan 16 2013, 01:00:57), sun_64, 2013 01 16 03:36:41

regards,

samid raif

[Former Member · Accepted solution]

Hi Reagan,

Yes... it´s weird!

As I said in my first message, besides the Oracle Instant Client update from 10.2.0.2 to 11.2.0.2 I also changed the BR*Tools version from release 7.20 to the release 7.20_EXT (but I´m still running the Kernel 7.20 UC (level 401) and DBSL level 327) and I did this because in sap note 819829 is described in "Configuring Oracle Instant Client 11.2 for SAP BR*Tools 7.20" that is necessary to change it to that EXT kernel version because this version is based on 11.2 instant client!

The path where I replace the new BR*Tools files release 7.20_EXT (DBATL720O10_35-20006731.SAR) was the /sapmnt/AZQ/exe, I believe this is the right path of Kernel directory!

Tell me one thing, it´s not supposed that the /sapmnt/AZQ/exe it is the same directory of /usr/sap/AZQ/DVEBMGS00/exe ?

Because I believe that /usr/sap/AZQ/DVEBMGS00/exe has differents files than into /sapmnt/AZQ/exe!!

ldd /usr/sap/AZQ/SYS/exe/run/dboraslib.so
Check which files it is looking for.

liszgpsap002:azqadm 10% ldd /usr/sap/AZQ/SYS/exe/run/dboraslib.so

        libdl.so.1 =>    /lib/64/libdl.so.1

        libnsl.so.1 =>   /lib/64/libnsl.so.1

        libsocket.so.1 =>        /lib/64/libsocket.so.1

        libCstd.so.1 =>  /usr/lib/64/libCstd.so.1

        libCrun.so.1 =>  /usr/lib/64/libCrun.so.1

        libm.so.1 =>     /lib/64/libm.so.1

        libclntsh.so.10.1 =>     /oracle/client/11x_64/instantclient/libclntsh.so.10.1  - unknown file type

        libnnz10.so =>   /oracle/client/11x_64/instantclient/libnnz10.so  - unknown file type

        libc.so.1 =>     /lib/64/libc.so.1

        libmp.so.2 =>    /lib/64/libmp.so.2

        libmd.so.1 =>    /lib/64/libmd.so.1

        libscf.so.1 =>   /lib/64/libscf.so.1

        libdoor.so.1 =>  /lib/64/libdoor.so.1

        libuutil.so.1 =>         /lib/64/libuutil.so.1

        libgen.so.1 =>   /lib/64/libgen.so.1

        libm.so.2 =>     /lib/64/libm.so.2

        /lib/sparcv9/../libm/sparcv9/libm_hwcap1.so.2

        /platform/sun4v/lib/sparcv9/libc_psr.so.1

        /platform/sun4v/lib/sparcv9/libmd_psr.so.1

Kind regards,

samid raif

[Former Member · Accepted solution]

Yo have errors in Oracle client installation. You can correct them manually. But the simpler solution is:

1) remove content of /oracle/client/11x_64/instantclient_11202 directory

2) reinstall oracle instant client 11

3) rename /oracle/client/10x_64 directory to any you want (save it for some time)

4) create symbolic link 10x_64 -> 11x_64

Check the connection with R3trans -d.

[Reagan · Accepted solution]

Hello Samid

I think I know where the problem is.

liszgpsap002:azqadm 5% ls -la /oracle/client/11x_64/instantclient_11202
total 294275
drwxrwxrwx   2 azqadm   sapsys        16 Dec  6 19:07 .
drwxrwxrwx   3 azqadm   sapsys         5 Dec  6 19:18 ..
-rwxrwxrwx   1 azqadm   sapsys      3481 Mar 14  2012 SAPIC_README
-rwxrwxrwx   1 azqadm   sapsys     23456 Mar 14  2012 adrci
-rwxrwxrwx   1 azqadm   sapsys   1629710 Mar 14  2012 classes12.jar
-rwxrwxrwx   1 azqadm   sapsys     34656 Mar 14  2012 genezi
-rwxrwxrwx   1 azqadm   sapsys         0 Mar 14  2012 libclntsh.so
-rwxrwxrwx   1 azqadm   sapsys         0 Mar 14  2012 libclntsh.so.10.1
-rwxrwxrwx   1 azqadm   sapsys   48252544 Mar 14  2012 libclntsh.so.11.1
-rwxrwxrwx   1 azqadm   sapsys         0 Mar 14  2012 libnnz10.so
-rwxrwxrwx   1 azqadm   sapsys   7780640 Mar 14  2012 libnnz11.so
-rwxrwxrwx   1 azqadm   sapsys   85980664 Mar 14  2012 libociei.so
-rwxrwxrwx   1 azqadm   sapsys   1578277 Mar 14  2012 ojdbc14.jar
-rwxrwxrwx   1 azqadm   sapsys   2047217 Mar 14  2012 ojdbc5.jar
-rwxrwxrwx   1 azqadm   sapsys   2169317 Mar 14  2012 ojdbc6.jar
-rwxrwxrwx   1 azqadm   sapsys    456760 Mar 14  2012 wrc

The files libclntsh.so libclntsh.so.10.1 and libnnz10.so are not good.

If you see the file sizes they are just 0 bytes.

It looks like the file OCL11264.SAR was not extracted properly.

Did you extract these on Solaris or on Windows and then uploaded them to the server ?

Try creating these symbolic links and see whether it helps.

cd /oracle/client/11x_64/instantclient_11202

rm libclntsh.so.10.1 libnnz10.so

ln -s libclntsh.so.11.1 libclntsh.so.10.1

ln -s libnnz11.so libnnz10.so

Regards

RB

[Reagan · Accepted solution]

The path where I replace the new BR*Tools files release 7.20_EXT (DBATL720O10_35-20006731.SAR) was the /sapmnt/AZQ/exe, I believe this is the right path of Kernel directory!

Correct.

Tell me one thing, it´s not supposed that the /sapmnt/AZQ/exe it is the same directory of /usr/sap/AZQ/DVEBMGS00/exe ?

When you do a kernel update you need to put the all the kernel files under /sapmnt/AZQ/exe which is the DIR_CT_RUN location. In short it is the central location for the kernel files.

When you start the SAP system the sapcpe program will be called by the script to copy the files files from the DIR_CT_RUN ( /sapmnt/AZQ/exe) location to DIR_EXECUTABLE (/usr/sap/AZQ/DVEBMGS00/exe) location.

Because I believe that /usr/sap/AZQ/DVEBMGS00/exe has differents files than into /sapmnt/AZQ/exe!!

The files under /sapmnt/AZQ/exe and /usr/sap/AZQ/DVEBMGS00/exe should always be same.

You can manually copy the files from /sapmnt/AZQ/exe and /usr/sap/AZQ/DVEBMGS00/exe or call the sapcpe program manually.

Regards

RB

[Former Member · Accepted solution]

Hello Reagan,

The files under /sapmnt/AZQ/exe and /usr/sap/AZQ/DVEBMGS00/exe should always be same.

I believe that /usr/sap/AZQ/DVEBMGS00/exe has differents files than into /sapmnt/AZQ/exe

Look at the following two pictures, the first from /usr/sap/AZQ/DVEBMGS00/exe and the second one from /sapmnt/AZQ/exe

regards,

samid raif

[Reagan · Accepted solution]

Hello Samid

That is not a problem. The sapcpe program files from the /sapmnt/AZQ/exe location to the /usr/sap/AZQ/DVEBMGS00/exe location based on certain .lst files.

Now back to the Oracle client issue. I believe you used some FTP tool like Winscp to transfer the extracted files to the server.

That could be the reason why the files are corrupted or invalid.

I suggest you to upload the .SAR file and extract the file on the server and copy them using the command line.

Try this and let me know.

cd /oracle/client/11x_64

cp /sapmnt/AZQ/exe/SAPCAR .

./SAPCAR -xvf OCL11264.SAR

ln -s instantclient_11202 instantclient

chown -R azqadm:sapsys /oracle/client/11x_64

chmod -R a+rwx /oracle/client/11x_64

ls -la /oracle/client/11x_64/instantclient_11202

Regards

RB

[Former Member · Accepted solution]

Hello Reagan,

Now everything is Ok

I believe, that was in fact the main problem here! I uploaded the .SAR file and I extracted the file on the server and I did all the procedure in sap note 819829 again!

Now the system is running without problems!

Many many thanks Reagan you helped me a lot!!

Thank you

samid raif

[Former Member]

Hello Samid,

The Oracle client version still shows as old one (10.2.0.2.0 ).  Have you replaced the old oracle client as expected or just upgraded it?

Have you checked the Oracle client version after upgrade with command 'genezi -v ' ?

Refer to the link and verify the steps you have followed

Link : http://scn.sap.com/docs/DOC-49953

Your error log :

4 ETW000  [     dev trc,00000]  Oracle client version: 10.2.0.2.0, (dbsl 720 291112, UNICODE[2])		95  0.022107
4 ETW000  [     dev trc,00000]  Detailed Oracle client (patch) info not available.

Mudasir.

[Former Member]

Hello Mudasir,

Yes... I don´t know why it still shows as old one (10.2.0.2)!!!

When I ran the command genezi -v it show me the following output:

liszgpsap002:azqadm 4% genezi -v

Client Shared Library 64-bit - 11.2.0.2.0

System name:    SunOS

Release:        5.10

Version:        Generic_147440-16

Machine:        sun4v

Operating in Instant Client mode.

Small timezone file = timezone_14.dat

Large timezone file = timezlrg_14.dat

I also checked the environment variables:

USER=azqadm

LOGNAME=azqadm

HOME=/export/home/azqadm

PATH=/oracle/AZQ/112_64/bin:/usr/j2se/bin:/usr/bin:/bin:/usr/sap/AZQ/SYS/exe/uc/sun_64:/usr/sap/AZQ/SYS/exe/run:/export/home/azqadm:.:/usr/ccs/bin:/usr/ucb

MAIL=/var/mail//azqadm

SHELL=/bin/csh

TZ=Europe/Lisbon

SSH_CLIENT=10.8.0.30 54197 22

SSH_CONNECTION=10.8.0.30 54197 10.8.0.13 22

SSH_TTY=/dev/pts/1

TERM=xterm

DISPLAY=localhost:10.0

PWD=/export/home/azqadm

SAPSYSTEMNAME=AZQ

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

LD_LIBRARY_PATH=/usr/sap/AZQ/SYS/exe/run:/usr/sap/AZQ/SYS/exe/uc/sun_64:/oracle/client/11x_64/instantclient

JAVA_HOME=/usr/j2se

SAPEXE=/usr/sap/AZQ/SYS/exe/run

THREAD=NOPS

dbms_type=ORA

dbs_ora_tnsname=AZQ

dbs_ora_schema=SAPSR3

ORACLE_SID=AZQ

DB_SID=AZQ

ORACLE_BASE=/oracle

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

ORACLE_HOME=/oracle/AZQ/112_64

NLS_LANG=AMERICAN_AMERICA.UTF8

SAPDATA_HOME=/oracle/AZQ

The env LD_LIBRARY_PATH show me the correct path of 11x_64:

liszgpsap002:azqadm 6% echo $LD_LIBRARY_PATH

/usr/sap/AZQ/SYS/exe/run:/usr/sap/AZQ/SYS/exe/uc/sun_64:/oracle/client/11x_64/instantclient

During the activity of oracle client instant update, I changed the following user files (<sid>adm) to replace the oracle client path from 10x to 11x:

.dbenv.csh

.dbenv.sh

.dbenv_liszgpsap002.csh

.dbenv_liszgpsap002.sh

Any tips?

Please help me!!

Kind regards,

samid raif

[Reagan]

Hello Samid

ls -la /oracle/client

ls -la /oracle/client/11x_64

su - azqadm

cd /oracle/client/11x_64/instantclient

./genezi -v

Output please

Regards

RB

[Former Member]

Hello Reagan,

The outputs:

liszgpsap002:azqadm 5% ls -la /oracle/client

total 12

drwxr-xr-x   4 root     root           4 Dec  6 18:54 .

drwxr-xr-x   8 oraazq   dba           11 Nov 14 10:54 ..

drwxrwxr-x   3 azqadm   sapsys         5 Jun 19  2012 10x_64

drwxrwxrwx   3 azqadm   sapsys         5 Dec  6 19:18 11x_64

liszgpsap002:azqadm 6% ls -la /oracle/client/11x_64

total 12

drwxrwxrwx   3 azqadm   sapsys         5 Dec  6 19:18 .

drwxr-xr-x   4 root     root           4 Dec  6 18:54 ..

-rwxrwxrwx   1 azqadm   sapsys       163 Mar 14  2012 dbclient.lst

lrwxrwxrwx   1 azqadm   sapsys        19 Dec  6 19:18 instantclient -> instantclient_11202

drwxrwxrwx   2 azqadm   sapsys        16 Dec  6 19:07 instantclient_11202

liszgpsap002:azqadm 10% ./genezi -v

Client Shared Library 64-bit - 11.2.0.2.0

System name:    SunOS

Release:        5.10

Version:        Generic_147440-16

Machine:        sun4v

Operating in Instant Client mode.

Small timezone file = timezone_14.dat

Large timezone file = timezlrg_14.dat

Any tips?

Regards,

samid raif

[Reagan]

Are they both running on the same server ? I mean SAP and Oracle

Please provide the environment variables of oraazq and azqadm users.

su - azqadm

env

grep client .*

su - oraazq

env

grep client .*

Regards

RB

[Former Member]

Hi Reagan,

Yes, they both running on the same server (SAP + Oracle)!

- Env of azqadm:

liszgpsap002:azqadm 11% env

USER=azqadm

LOGNAME=azqadm

HOME=/export/home/azqadm

PATH=/oracle/AZQ/112_64/bin:/usr/j2se/bin:/usr/bin:/bin:/usr/sap/AZQ/SYS/exe/uc/sun_64:/usr/sap/AZQ/SYS/exe/run:/export/home/azqadm:.:/usr/ccs/bin:/usr/ucb

MAIL=/var/mail//azqadm

SHELL=/bin/csh

TZ=Europe/Lisbon

SSH_CLIENT=10.8.0.30 57254 22

SSH_CONNECTION=10.8.0.30 57254 10.8.0.13 22

SSH_TTY=/dev/pts/1

TERM=xterm

DISPLAY=localhost:10.0

PWD=/oracle/client/11x_64/instantclient

SAPSYSTEMNAME=AZQ

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

LD_LIBRARY_PATH=/usr/sap/AZQ/SYS/exe/run:/usr/sap/AZQ/SYS/exe/uc/sun_64:/oracle/client/11x_64/instantclient

JAVA_HOME=/usr/j2se

SAPEXE=/usr/sap/AZQ/SYS/exe/run

THREAD=NOPS

dbms_type=ORA

dbs_ora_tnsname=AZQ

dbs_ora_schema=SAPSR3

ORACLE_SID=AZQ

DB_SID=AZQ

ORACLE_BASE=/oracle

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

ORACLE_HOME=/oracle/AZQ/112_64

NLS_LANG=AMERICAN_AMERICA.UTF8

SAPDATA_HOME=/oracle/AZQ

liszgpsap002:azqadm 1% grep client .*

.dbenv.csh:  set ADD=/oracle/client/11x_64/instantclient

.dbenv.sh:  ADD=/oracle/client/11x_64/instantclient

.dbenv_liszgpsap002.csh:  set ADD=/oracle/client/11x_64/instantclient

.dbenv_liszgpsap002.sh:  ADD=/oracle/client/11x_64/instantclient

- Env of oraazq:

liszgpsap002:oraazq 1% env

HOME=/oracle/AZQ

PATH=/oracle/AZQ/112_64/bin:/usr/bin:.:/usr/sap/AZQ/SYS/exe/uc/sun_64:/usr/sap/AZQ/SYS/exe/run:/oracle/AZQ:/usr/ccs/bin:/usr/ucb

LOGNAME=oraazq

HZ=

TERM=xterm

SHELL=/bin/csh

MAIL=/var/mail/oraazq

TZ=Europe/Lisbon

PWD=/oracle/AZQ

USER=oraazq

SAPSYSTEMNAME=AZQ

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

LD_LIBRARY_PATH=/usr/sap/AZQ/SYS/exe/run:/usr/sap/AZQ/SYS/exe/uc/sun_64:/oracle/AZQ/112_64/lib

SAPEXE=/usr/sap/AZQ/SYS/exe/run

THREAD=NOPS

dbms_type=ORA

dbs_ora_tnsname=AZQ

dbs_ora_schema=SAPSR3

ORACLE_SID=AZQ

DB_SID=AZQ

ORACLE_BASE=/oracle

ORACLE_HOME=/oracle/AZQ/112_64

NLS_LANG=AMERICAN_AMERICA.UTF8

SAPDATA_HOME=/oracle/AZQ

liszgpsap002:oraazq 2% grep client .*

.dbenv.csh:  set ADD=/oracle/client/10x_64/instantclient

.dbenv.sh:  ADD=/oracle/client/10x_64/instantclient

.dbenv_liszgpsap002.csh:  set ADD=/oracle/client/10x_64/instantclient

.dbenv_liszgpsap002.sh:  ADD=/oracle/client/10x_64/instantclient

Kind regards,

samid raif