on 04-02-2008 9:07 PM
Good Afternoon everybody
Kindly would help me at this problem under:
I am migration the SAP version 4.5 from Solaris to SAP version 4.5 to Windows NT 4.0.
When the command r3trans -x is executed log generated is attached under:
This is r3trans version 6.05 (release 45B - 08.04.99 - 13:23:00).
2EETW169 no connect possible: "DBMS = ORACLE --- dbs_ora_tnsname = 'CBP'"
r3trans finished (0012).
See the trans.log
4 ETW000 r3trans version 6.05 (release 45B - 08.04.99 - 13:23:00).
4 ETW000 ===============================================
4 ETW000
4 ETW000 control file:
4 ETW000 date&time : 02.04.2008 - 12:09:05
4 ETW000 trace at level 2 opened for a given file pointer
4 ETW000 Wed Apr 02 12:09:05 2008 165 0.000165
4 ETW000 Loading library 'dboraslib.dll' ...
4 ETW000 124 0.000289
4 ETW000 load shared library (dboraslib.dll), hdl 0
4 ETW000 30386 0.030675
4 ETW000 Library 'dboraslib.dll' loaded
4 ETW000 174 0.030849
4 ETW000 function DbSlExpFuns loaded from library dboraslib.dll
4 ETW000 62 0.030911
4 ETW000 Version of 'dboraslib.dll' is '45B.01'
4 ETW000 74 0.030985
4 ETW000 function dsql_db_init loaded from library dboraslib.dll
4 ETW000 48 0.031033
4 ETW000 function dbdd_exp_funs loaded from library dboraslib.dll
4 ETW000 60 0.031093
4 ETW000 New connection 0 created 58 0.031151
4 ETW000 db_con_connect (con_name=R/3) 37 0.031188
4 ETW000 Got ORACLE_HOME=D:orant from environment
4 ETW000 172 0.031360
4 ETW000 Got ORACLE_SID=CBP from environment
4 ETW000 165 0.031525
4 ETW000 Found NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P1 in Registry
4 ETW000 100 0.031625
4 ETW000 Logon as OPS$-user to get SAPR3's password
4 ETW000 43 0.031668
4 ETW000 Connecting as /@CBP on connection 0 ...
4 ETW000 44 0.031712
4 ETW000 Wed Apr 02 12:09:09 2008 3431643 3.463355
4 ETW000 *** ERROR => CONNECT failed with sql error '12154'
4 ETW000 65 3.463420
4 ETW000 Try to connect with default password
4 ETW000 43 3.463463
4 ETW000 Connecting as SAPR3/@CBP on connection 0 ...
4 ETW000 47 3.463510
4 ETW000 Wed Apr 02 12:09:12 2008 3014075 6.477585
4 ETW000 *** ERROR => CONNECT failed with sql error '12154'
4 ETW000 67 6.477652
4 ETW000 ***LOG BY2=>sql error 12154 performing CON
4 ETW000 78 6.477730
4 ETW000 ***LOG BY0=> 33 6.477763
2EETW169 no connect possible: "DBMS = ORACLE --- dbs_ora_tnsname = 'CBP'"
SAP was installed after imported all data inside.
The status now is I can connect by Oracle client but I can't start SAP.
I tested the listener and he is responding fine.
N:>tnsping sap_10.137.1.22
TNS Ping Utility for 32-bit Windows: Version 9.2.0.8.0 - Production on 02-APR-20
08 16:33:45
Copyright (c) 1997, 2006, Oracle Corporation. All rights reserved.
Used parameter files:
c:oracleora92
etworkadminsqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)
(HOST = 10.137.1.22)(PORT = 1527))) (CONNECT_DATA = (SID = CBP) (SERVER = DEDICA
TED)))
OK (10 msec)
Please give a light because I don't what can do.
Any advice would be appreciated?
Thank
Renato
Hi Shaji
I'm really appreciated for your information the problem was resolved.
Thank you very much
Renato
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
I am facing the similar problem like this one my 5 app servers are not able to connect to the DB/CI, R3trans is showing error "apsrv4-f:proadm 9> R3trans -D
This is R3trans version 5.36 (release 31I - 04.03.02 - 09:55:00).
2EETW169 no connect possible: "DBMS = ORACLE --- dbs_ora_tnsname = 'PRO'"
R3trans finished (0012).'
we have recently upgraded our oracle version to 10.2.0.2. after this we are getting this probelm.
Please help.
Thanks,
Kamal Bhargava
Read this note and the related notes :
Note 403004 - Database connect using R3trans fails
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.