Skip to Content
avatar image
Former Member

SAP is unable to connect Oracle

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

7 Answers

  • avatar image
    Former Member
    Nov 04, 2008 at 07:24 AM

    Hi Venu,

    Check if your database is up and running.

    Regards

    Ashok

    Add comment
    10|10000 characters needed characters exceeded

    • 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.

  • avatar image
    Former Member
    Nov 04, 2008 at 08:27 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      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

  • avatar image
    Former Member
    Nov 04, 2008 at 09:26 AM

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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 07, 2008 at 03:21 PM

    Check whether Oracle Listener is running

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 10, 2008 at 02:44 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded

    • > 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

  • avatar image
    Former Member
    Aug 27, 2009 at 09:35 AM
    *** ERROR => OCI-call 'OCIEnvCreate' failed: rc = -1

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

    [sap-java-system-not-coming-up-after-restart;

    also check you are using the correct Oracle Client Version.

    [DbSl Trace: OCI-call 'OCIEnvCreate(mode=0)' failed with rc=-1;

    Thanks,

    Shambo

    Add comment
    10|10000 characters needed characters exceeded

    • 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

  • avatar image
    Former Member
    Dec 14, 2010 at 08:04 PM

    done

    Add comment
    10|10000 characters needed characters exceeded