Skip to Content
avatar image
Former Member

ERROR ORA - 12154

Hello world,

Users are complaining that they ARE NOT ABLE TO IMPORT the transports from a dev system to quality.

Transport control program tp ended with error code 0232


is the error they are getting.


R3trans -d is giving error ----0012.


ERROR: Connect to SID failed (20150708172051, ORA-12154: TNS:could not resolve the connect identifier specified) .


Listener is restarted  ---- it is running now.


Any help!


Thanks

uday

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

5 Answers

  • Best Answer
    Jul 08, 2015 at 07:00 PM

    Hi Uday,

    Please have a look at below KBA and see if that helps.

    443867 - ORA-12154 Collective SAP note


    If that doesn't help, then please share trans.log of r3trans.


    Regards,

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 08, 2015 at 07:37 PM

    Hi,

    Also check the permission of ssfs file and folders too

    4 ETW000 [dbcon.c ,00000] *** ERROR => Connect to R/3 failed. USERID and/or PASSWD could not be retrieved from SSFS


    Check the kernel version u r having and compatible with the system. May be a different version will fix the issue .

    Regards,

    Nikhil

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 08, 2015 at 07:38 PM

    No Type  Pid    Status  Cause Start Rstr  Err Sem Time Program          Cl  User         Action                    Table

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

    0 DIA    26036 Wait          yes   no    15   0    0                                    NO_ACTION

    1 DIA       -1 Ended         no    no    34   0    0                                    NO_ACTION

    2 DIA       -1 Ended         no    no    43   0    0                                    NO_ACTION

    3 DIA       -1 Ended         no    no    16   0    0                                    NO_ACTION

    4 DIA       -1 Ended         no    no    26   0    0                                    NO_ACTION

    5 DIA       -1 Ended         no    no    34   0    0                                    NO_ACTION

    6 DIA     3965 Wait          yes   no     0   0    0                                    NO_ACTION

    7 DIA       -1 Ended         no    no    33   0    0                                    NO_ACTION

    8 DIA       -1 Ended         no    no    16   0    0                                    NO_ACTION

    9 DIA       -1 Ended         no    no    19   0    0                                    NO_ACTION

    10 UPD     4375 Wait          yes   no     0   0    0                                    NO_ACTION

    11 UPD    24762 Wait          yes   no    14   0    0                                    NO_ACTION

    12 UPD    29107 Wait          yes   no    13   0    0                                    NO_ACTION

    13 UPD    24768 Wait          yes   no     0   0    0                                    NO_ACTION

    14 UPD    29112 Wait          yes   no    13   0    0                                    NO_ACTION

    15 ENQ    27580 Wait          yes   no     0   0    0                                    NO_ACTION

    16 BTC       -1 Ended         no    no    35   0    0                                    NO_ACTION

    17 BTC       -1 Ended         no    no    32   0    0                                    NO_ACTION

    18 BTC       -1 Ended         no    no    20   0    0                                    NO_ACTION

    19 BTC       -1 Ended         no    no    12   0    0                                    NO_ACTION

    20 BTC       -1 Ended         no    no    23   0    0                                    NO_ACTION

    21 SPO    28352 Wait          yes   no     0   0    0                                    NO_ACTION

    22 SPO    27587 Wait          yes   no     0   0    0                                    NO_ACTION

    23 UP2    27588 Wait          yes   no     0   0    0                                    NO_ACTION

    24 UP2    29367 Wait          yes   no     0   0    0                                    NO_ACTION

    25 UP2    27590 Wait          yes   no     0   0    0                                    NO_ACTION

    26 UP2    27591 Wait          yes   no     0   0    0                                    NO_ACTION

    27 UP2    27592 Wait          yes   no     0   0    0                                    NO_ACTION

    2015-07-08 21:37:02;OK ;SID;20150708#213702 0 0 0 0 0 0 0 # 14 72 1 0 1 1 1

    Work processes are stopped now..

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 08, 2015 at 07:41 PM

    Hello,

    R3trans -d is giving 0012 error.

    SSFS comes into the picture later right?

    Thx.

    Uday

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Uday,

      Please check the following note:

      2153975 - Database connectivity fails with ORA-12154


      Cause

      You are trying to connect using the service name created (<SERVICE>) in the dbs_ora_tnsname, and this service is not added to the tnsnames.ora file.

      Resolution

      There are two possible solutions, the first one is preferred:

      1. Adjust the dbs_ora_tnsname (and dbs/ora/tnsname in the profile) to use //<SCAN_NAME>/<SERVICE>
      2. Add the <SERVICE> entry to the tnsnames.ora in the defined TNS_ADMIN location


      Regards


      Adil

  • avatar image
    Former Member
    Jul 10, 2015 at 10:33 AM

    Hello,

    The issue was with 'tnsnames.ora' file permissions which were changed during some checks by the migration team.

    We reverted back the permissions and connection is OK now.

    Thanks a lot!

    Uday.

    Add comment
    10|10000 characters needed characters exceeded