on 11-16-2006 6:26 AM
hi,
we are getting an alert with the text:"initialization DB-Connect Failed, with return code 000256"
i have done all the regualr checks to figure out what is the cause for this alert. but couldnt figure out anything
i ahev also tried to look up for sap notes at the service market place but didnt find any
can some one compe up with a solution for this
thanks n regards,
sri srirangam
Delete the previous <b>trans.log</b> file (if exist)
Execute the command R3trans -x
Provide output of the newly created trans.log file.
[I guess this is something to do with the archive destination]
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
dear ammey,
thank you very much for your timely and valuable suggestion
but my team had diff appraoch to this problem and they had simply restarted the instance and the problem is solved.
so i could quite implement your suggestion and come up with the new log file
anyways will remember your suggestion n will try it the next time i come across this problem
thanks heaps once again
regards,
sri r. srirangam
Hi,
I have similar problem. I am producing the trans log file here. could anyone help me on this?
4 ETW000 r3trans version 6.09 (release 640 - 26.10.04 - 15:45:42).
4 ETW000 unicode enabled version
4 ETW000 ===============================================
4 ETW000
4 ETW000 date&time : 05.04.2007 - 12:23:25
4 ETW000 control file: <no ctrlfile>
4 ETW000 R3trans was called as follows: r3trans -d
4 ETW000 trace at level 2 opened for a given file pointer
4 ETW000 [dev trc ,00000] Thu Apr 05 12:23:25 2007 2209 0.002209
4 ETW000 [dev trc ,00000] db_con_init called 119 0.002328
4 ETW000 [dev trc ,00000] create_con (con_name=R/3) 101 0.002429
4 ETW000 [dev trc ,00000] Loading DB library 'dboraslib.dll' ... 90 0.002519
4 ETW000 [dev trc ,00000] load shared library (dboraslib.dll), hdl 0 17115 0.019634
4 ETW000 [dev trc ,00000] using "C:\usr\sap\SMT\SYS\exe\run\dboraslib.dll"
4 ETW000 70 0.019704
4 ETW000 [dev trc ,00000] Library 'dboraslib.dll' loaded 28 0.019732
4 ETW000 [dev trc ,00000] function DbSlExpFuns loaded from library dboraslib.dll
4 ETW000 50 0.019782
4 ETW000 [dev trc ,00000] Version of 'dboraslib.dll' is "640.00", patchlevel (0.39)
4 ETW000 144 0.019926
4 ETW000 [dev trc ,00000] function dsql_db_init loaded from library dboraslib.dll
4 ETW000 47 0.019973
4 ETW000 [dev trc ,00000] function dbdd_exp_funs loaded from library dboraslib.dll
4 ETW000 62 0.020035
4 ETW000 [dev trc ,00000] New connection 0 created 44 0.020079
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 67 0.020146
4 ETW000 [dev trc ,00000] db_con_connect (con_name=R/3) 46 0.020192
4 ETW000 [dev trc ,00000] find_con_by_name found the following connection for reuse:
4 ETW000 47 0.020239
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 62 0.020301
4 ETW000 [dev trc ,00000] Got ORACLE_HOME=C:\ORACLE\SMT\920 from environment
4 ETW000 1085 0.021386
4 ETW000 [dev trc ,00000] -->oci_initialize 33 0.021419
4 ETW000 [dev trc ,00000] Client NLS settings: AMERICAN_AMERICA.UTF8 44060 0.065479
4 ETW000 [dev trc ,00000] Logon as OPS$-user to get SAPSMT's password 86 0.065565
4 ETW000 [dev trc ,00000] Connecting as /@SMT on connection 0 ... 40 0.065605
4 ETW000 [dev trc ,00000] Allocating service context handle 13488 0.079093
4 ETW000 [dev trc ,00000] Allocating server context handle 85 0.079178
4 ETW000 [dev trc ,00000] Attaching to DB Server SMT (con_hdl=0,svchp=026D3964,svrhp=026D44F4)
4 ETW000 108 0.079286
4 ETW000 [dev trc ,00000] Thu Apr 05 12:23:30 2007 4532887 4.612173
4 ETW000 [dboci.c ,00000] *** ERROR => OCI-call 'OCIServerAttach' failed: rc = 12154
4 ETW000 75 4.612248
4 ETW000 [dbsloci. ,00000] *** ERROR => CONNECT failed with sql error '12154'
4 ETW000 181 4.612429
4 ETW000 [dev trc ,00000] Try to connect with default password 277 4.612706
4 ETW000 [dev trc ,00000] Connecting as SAPSMT/<pwd>@SMT on connection 0 ...
4 ETW000 44 4.612750
4 ETW000 [dev trc ,00000] server_detach(con_hdl=0,stale=0,svrhp=026D44F4) 37 4.612787
4 ETW000 [dev trc ,00000] Detaching from DB Server (con_hdl=0,svchp=026D3964,srvhp=026D44F4)
4 ETW000 50 4.612837
4 ETW000 [dev trc ,00000] Deallocating server context handle 026D44F4 44 4.612881
4 ETW000 [dev trc ,00000] Allocating server context handle 43 4.612924
4 ETW000 [dev trc ,00000] Attaching to DB Server SMT (con_hdl=0,svchp=026D3964,svrhp=026D44F4)
4 ETW000 89 4.613013
4 ETW000 [dev trc ,00000] Thu Apr 05 12:23:34 2007 4530160 9.143173
4 ETW000 [dboci.c ,00000] *** ERROR => OCI-call 'OCIServerAttach' failed: rc = 12154
4 ETW000 74 9.143247
4 ETW000 [dbsloci. ,00000] *** ERROR => CONNECT failed with sql error '12154'
4 ETW000 51 9.143298
4 ETW000 [dblink ,00419] ***LOG BY2=>sql error 12154 performing CON [dblink#1 @ 419]
4 ETW000 25258 9.168556
4 ETW000 [dblink ,00419] ***LOG BY0=>ORA-12154: TNS:could not resolve service name [dblink#1 @ 419]
4 ETW000 51 9.168607
2EETW169 no connect possible: "DBMS = ORACLE --- dbs_ora_tnsname = 'SMT'"
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Srirangam,
that error is pretty general.
Please start
R3Trans -d
and check the file <b>
trans.log
</b> which will be generated into your current working directory.
In this file there should be error information of more detail.
Post this information then.
KR Lars
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
6 | |
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.