on 07-08-2015 7:56 PM
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
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,
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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=
Hi Udaya,
Please check the following note.
1198150 - Error: "ORA-12154 - TNS:could not resolve the connect identifier specified"
Regards,
Adil
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello,
R3trans -d is giving 0012 error.
SSFS comes into the picture later right?
Thx.
Uday
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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:
Regards
Adil
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..
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
80 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.