cancel
Showing results for 
Search instead for 
Did you mean: 

ERROR ORA - 12154

Former Member
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

divyanshu_srivastava3
Active Contributor
0 Kudos

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,

Former Member
0 Kudos

Hi ,

trans.log

4 ETW000 [ dev trc,00000] RSecSSFs: File "/usr/sap/BD5/SYS/global/security/rsecssfs/data/SSFS_SID.DAT" cannot be opened in mode "rb": Permission denied (errno = 13). Wai
ting cycle number 1 for 450 ms, then retrying. [rsecssfs.c 1243]
4 ETW000 38 0.660393
4 ETW000 [ dev trc,00000] RSecSSFs: File "/usr/sap/BD5/SYS/global/security/rsecssfs/data/SSFS_SID.DAT" cannot be opened in mode "rb": Permission denied (errno = 13). Wai
ting cycle number 2 for 470 ms, then retrying. [rsecssfs.c 1243]
4 ETW000 450207 1.110600
4 ETW000 [ dev trc,00000] Wed Jul 8 18:58:49 2015 470156 1.580756
4 ETW000 [ dev trc,00000] RSecSSFs: File "/usr/sap/BD5/SYS/global/security/rsecssfs/data/SSFS_SID.DAT" cannot be opened in mode "rb": Permission denied (errno = 13). Wai
ting cycle number 3 for 388 ms, then retrying. [rsecssfs.c 1243]
4 ETW000 19 1.580775
4 ETW000 [dbcon.c ,00000] *** ERROR => RSecSSFs: File "/usr/sap/BD5/SYS/global/security/rsecssfs/data/SSFS_SID.DAT" cannot be opened in mode "rb": Permission denied (err
no = 13) [rsecssfs.c 1223]
4 ETW000 388129 1.968904
4 ETW000 [ dev trc,00000] RSecSSFs: Exiting function "RSecSSFsGetRecord" with return code -3 (message: File "/usr/sap/BD5/SYS/global/security/rsecssfs/data/SSFS_BD5.DAT"
cannot be opened in mode "rb": Permission denied (errno = 13)) [rsecssfs.c 940]
4 ETW000 40 1.968944
4 ETW000 [dbcon.c ,00000] *** ERROR => read_ssfs_record(): RSecSSFsGetRecord(DB_CONNECT/DEFAULT_DB_USER)=-3 : File "/usr/sap/BD5/SYS/global/security/rsecssfs/data/SSFS_SID.DAT" cannot be opened in mode "rb": Permission denied (errno = 13)
4 ETW000 13 1.968957
4 ETW000 [ dev trc,00000] read_ssfs_record(): deregister callback ssfs_dbi_trace 6 1.968963
4 ETW000 [dbcon.c ,00000] *** ERROR => Connect to R/3 failed. USERID and/or PASSWD could not be retrieved from SSFS

Former Member
0 Kudos

4 ETW000 [ dev trc,00000] charset='UTF16', ncharset='AL16UTF16', UNI_ASC=FALSE 6 0.011543
4 ETW000 [ dev trc,00000] Logon as OPS$-user to get SAPSR3's password 9 0.011552
4 ETW000 [ dev trc,00000] Connecting as /@BD5 on connection 0 (nls 0) ... (dbsl 721 231014, UNICODE[2])
4 ETW000 10 0.011562
4 ETW000 [ dev trc,00000] OCIHandleAlloc(con=0): New service handle svc=1deb928, rc=0 14 0.011576
4 ETW000 [ dev trc,00000] OCIHandleAlloc(con=0,svc=1deb928): New server hdl. srv=1deebe0, rc=0
4 ETW000 35 0.011611
4 ETW000 [ dev trc,00000] Wed Jul 8 18:56:59 2015 3393171 3.404782
4 ETW000 [ dev trc,00000] OCIServerAttach(OCI_DEFAULT) failed with -1=OCI_ERROR 19 3.404801
4 ETW000 [ dev trc,00000] OCIServerAttach(OCI_DEFAULT) failed with SQL error 12154: 96 3.404897
4 ETW000 [ dev trc,00000] ORA-12154: TNS:could not resolve the connect identifier specified
4 ETW000 11 3.404908
4 ETW000 [ dev trc,00000] OCIServerAttach(con=0, svc=1deb928): Error 12154 attaching srv=1deebe0 to 'BD5'
4 ETW000 11 3.404919
4 ETW000 [ dev trc,00000] OCIHandleFree(con=0): Server handle srv=1deebe0 freed 31 3.404950
4 ETW000 [ dev trc,00000] server_detach(con=0, svc=1deb928; srv=0000NULL, stale=2) 12 3.404962
4 ETW000 [ dev trc,00000] rc=12154 -> Trying to reattach to server 'BD5' 8 3.404970
4 ETW000 [ dev trc,00000] OCIHandleAlloc(con=0,svc=1deb928): New server hdl. srv=1deebe0, rc=

divyanshu_srivastava3
Active Contributor
0 Kudos

Hi Uday,


/usr/sap/BD5/SYS/global/security/rsecssfs/data/SSFS_SID.DAT" cannot be opened in mode "rb": Permission denied (errno = 13) [rsecssfs.c 1223]

Have you configured SSFS ?

Also, check above note completely.

Regards,

Former Member
0 Kudos
Former Member
0 Kudos

SSFS is configured.

Answers (4)

Answers (4)

Former Member
0 Kudos

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.

Former Member
0 Kudos

Hello,

R3trans -d is giving 0012 error.

SSFS comes into the picture later right?

Thx.

Uday

Former Member
0 Kudos

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

Former Member
0 Kudos

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

Former Member
0 Kudos

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