SAP is unable to connect Oracle

[Former Member]

Hi All,

geupg:updadm 58% startsap r3

Checking UPD Database

-

---

ABAP Database is not available via R3trans

Starting SAP-Collector Daemon

-

---

Cannot create Shared Memory

Start of saposcol failed

ABAP Database UPD must be started first

-

---

geupg:updadm 61% R3trans -x

This is R3trans version 6.13 (release 640 - 10.07.07 - 13:48:00).

unicode enabled version

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

R3trans finished (0012).

-

---

geupg:updadm 62% more trans.log

4 ETW000 R3trans version 6.13 (release 640 - 10.07.07 - 13:48:00).

4 ETW000 unicode enabled version

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

4 ETW000

4 ETW000 date&time : 04.11.2008 - 12:19:29

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] Tue Nov 4 12:19:29 2008 788 0.000788

4 ETW000 [dev trc ,00000] db_con_init called 154 0.000942

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

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

4 ETW000 385 0.001655

4 ETW000 [dev trc ,00000] load shared library (/usr/sap/UPD/SYS/exe/run/dboraslib.so), hdl 0

4 ETW000 51821 0.053476

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

4 ETW000 315 0.053791

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

4 ETW000 266 0.054057

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

4 ETW000 1169 0.055226

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

4 ETW000 258 0.055484

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

4 ETW000 363 0.055847

4 ETW000 [dev trc ,00000] New connection 0 created 230 0.056077

4 ETW000 [dev trc ,00000] 0: name = R/3, con_id = -000000001 state = DISCONNECTED, perm = YES, reco = NO , timeout = 000

, con_max = 255, con_opt = 255, occ = NO

4 ETW000 291 0.056368

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

4 ETW000 [dev trc ,00000] find_con_by_name found the following connection for reuse:

4 ETW000 238 0.056770

4 ETW000 [dev trc ,00000] 0: name = R/3, con_id = 000000000 state = DISCONNECTED, perm = YES, reco = NO , timeout = 000,

con_max = 255, con_opt = 255, occ = NO

4 ETW000 275 0.057045

4 ETW000 [dev trc ,00000] Got ORACLE_HOME=/oracle/UPD/102_64 from environment

4 ETW000 1544 0.058589

4 ETW000 [dev trc ,00000] -->oci_initialize (con_hdl=0) 362 0.058951

4 ETW000 [dev trc ,00000] got NLS_LANG='AMERICAN_AMERICA.UTF8' from environment

4 ETW000 249 0.059200

4 ETW000 [dboci.c ,00000] *** ERROR => OCI-call 'OCIEnvCreate' failed: rc = -1

4 ETW000 7409 0.066609

4 ETW000 [dev trc ,00000] set_ocica() -> OCI or SQL return code -1 166 0.066775

4 ETW000 [dboci.c ,00000] *** ERROR => OCI-call 'OCIErrorGet' failed: rc = -2

4 ETW000 304 0.067079

4 ETW000 [dblink ,00428] ***LOG BY2=>sql error -1 performing CON [dblink#3 @ 428]

4 ETW000 296 0.067375

4 ETW000 [dblink ,00428] ***LOG BY0=>Cannot get Oracle error text. [dblink#3 @ 428]

4 ETW000 274 0.067649

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

Please provide the solution.

Regards,

Venu

[Former Member]

done

[Former Member]

*** ERROR => OCI-call 'OCIEnvCreate' failed: rc = -1

See below link, it is more revelent to your problem.

[;

also check you are using the correct Oracle Client Version.

[;

Thanks,

Shambo

[Former Member]

Hi ,

Try to login to oracle with ::

sqlplus /nolog

connect <schema>\<schemapassword>

Here this will give you the hint of error which it is facing to connect to oracle.

I faced similar problem once & according to error msg i got from it ,it was showing issue with pfile does not exist.So we created pfile from spfile & started our oracle.

Please check & reply if this work fine.

Thanks..

Mohit

[Former Member]

Hello,

I think even if your client is not proper, i.e as per your kernel version. then still your sap will start.

Only it will throw some dumps.

Check listener, environmental variables seems to be fine.

Thanks,

anu.

[Former Member]

Hello All,

can you all please help in identifying the issue.

Error 000052 : Missing file or filesystem in Module rslgcoll(041)

Thanks,

Anu

[markus_doehr2]

> Hello All,

>

>

> can you all please help in identifying the issue.

>

> Error 000052 : Missing file or filesystem in Module rslgcoll(041)

Can you tell us how this is related to the original error posted?

Markus

[sebastian_sebaraj]

Check whether Oracle Listener is running

[Former Member]

Hi.. Is it Java Stack or Double Stack.. If it is a Java Stack R3trans Command will not work..

[Former Member]

Hi Venugopal,

Here issue related to environment variable. Please confirm that your database owner is SID or not?....otherwise i wll suggest you to change the env variable dbs_ora_schema to exact dtabase owner....then try to re start....it iwll works...

warm regards

Harish K Reddy

[Former Member]

Hi,

Please check the env

geupg:oraupd 13% env

HOME=/oracle/UPD

PATH=/oracle/UPD/102_64/bin:/oracle/UPD:/usr/sap/UPD/SYS/exe/run:/usr/bin:.:/usr/ccs/bin:/usr/ucb

LOGNAME=oraupd

HZ=

TERM=xterm

SHELL=/bin/csh

MAIL=/var/mail/oraupd

TZ=Asia/Calcutta

PWD=/oracle/UPD/102_64/network/admin

USER=oraupd

SAPSYSTEMNAME=UPD

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

LD_LIBRARY_PATH=/usr/sap/UPD/SYS/exe/run:/oracle/UPD/102_64/lib

THREAD=NOPS

dbms_type=ORA

dbs_ora_tnsname=UPD

dbs_ora_schema=SAPUPD

ORACLE_PSRV=UPD

ORACLE_SID=UPD

DB_SID=UPD

ORACLE_HOME=/oracle/UPD/102_64

ORACLE_BASE=/oracle

NLS_LANG=AMERICAN_AMERICA.UTF8

SAPDATA_HOME=/oracle/UPD

ORA_NLS10=/oracle/UPD/102_64/nls/data

Regards,

Venu

[fidel_vales]

Hi,

Yes, it is interesting to know if it is JAVA or ABAP stack.

Looking at the environment variables seems that there is an ABAP stack and that you are working with 10g.

Your kernel is 640.

The 640 kernel is linked to oracle 9i libraries

The 640_EX2 kernel is linked to oracle 10g libraries

Your environment variables are a "mess", not one not the other.

first question >> which of the previous kernels are you using?

second question >> have you installed the proper oracle client?

The environment variables you show are for the oracle user (oraupd)

This user is not supposed to use R3trans.

If you are getting the mentioned error with this user, forget and try with updam.

If you are also getting the error with updadm, then provide the environment variables for this user.

Thanks in advance for the info

[Former Member]

Hi Venu,

Check if your database is up and running.

Regards

Ashok

[Former Member]

Hi,

From error log it seems that either your sidadm environment (mainly nls parameters) or oracle client has problem.

Make sure that environment and client are proper.

Regards,

- Nirav Shah.