I have just finished upgrading database from 10G to 11G with AIX/ ECC6, I have started the database after
the upgrade, but whe i run R3trans -d i get following error.
I can connect via $sqlplus SAPSR3/********@IDU
I am using orcle Instant Client 10.2.0.4.0 V3
Please help
4 ETW000 R3trans version 6.14 (release 701 - 19.11.10 - 18:10:00).
4 ETW000 unicode enabled version
4 ETW000 ===============================================
4 ETW000
4 ETW000 date&time : 05.01.2011 - 21:25:36
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] Wed Jan 5 21:25:36 2011 189 0.000189
4 ETW000 [dev trc ,00000] db_con_init called 43 0.000232
4 ETW000 [dev trc ,00000] create_con (con_name=R/3) 73 0.000305
4 ETW000 [dev trc ,00000] Loading DB library '/usr/sap/IDU/SYS/exe/run/dboraslib.o' ... 66 0.000371
4 ETW000 [dev trc ,00000] DlLoadLib() success: dlopen("/usr/sap/IDU/SYS/exe/run/dboraslib.o"), hdl 0
4 ETW000 10642 0.011013
4 ETW000 [dev trc ,00000] Library '/usr/sap/IDU/SYS/exe/run/dboraslib.o' loaded 52 0.011065
4 ETW000 [dev trc ,00000] function DbSlExpFuns loaded from library /usr/sap/IDU/SYS/exe/run/dboraslib.o
4 ETW000 75 0.011140
4 ETW000 [dev trc ,00000] Version of '/usr/sap/IDU/SYS/exe/run/dboraslib.o' is "700.08", patchlevel (0.110)
4 ETW000 465 0.011605
4 ETW000 [dev trc ,00000] function dsql_db_init loaded from library /usr/sap/IDU/SYS/exe/run/dboraslib.o
4 ETW000 68 0.011673
4 ETW000 [dev trc ,00000] function dbdd_exp_funs loaded from library /usr/sap/IDU/SYS/exe/run/dboraslib.o
4 ETW000 125 0.011798
4 ETW000 [dev trc ,00000] New connection 0 created 76 0.011874
4 ETW000 [dev trc ,00000] 000: name = R/3, con_id = -000000001, state = DISCONNECTED, tx = NO , hc = NO , perm = YES,
4 ETW000 reco = NO , frco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO
4 ETW000 109 0.011983
4 ETW000 [dev trc ,00000] db_con_connect (con_name=R/3) 66 0.012049
4 ETW000 [dev trc ,00000] find_con_by_name found the following connection for reuse: 44 0.012093
4 ETW000 [dev trc ,00000] 000: name = R/3, con_id = 000000000, state = DISCONNECTED, tx = NO , hc = NO , perm = YES,
4 ETW000 reco = NO , frco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO
4 ETW000 103 0.012196
4 ETW000 [dev trc ,00000] Got LIBPATH=/usr/lib:/lib:/usr/sap/IDU/SYS/exe/run:/oracle/client/10x_64/instantclient from environment
4 ETW000 694 0.012890
4 ETW000 [dev trc ,00000] -->oci_init1 51 0.012941
4 ETW000 [dev trc ,00000] Oracle Client Version: '10.2.0.4.0', (dbsl 701 140910) 253 0.013194
4 ETW000 [dev trc ,00000] Default connection: tnsname ='IDU' 49 0.013243
4 ETW000 [dev trc ,00000] -->oci_initialize(con_hdl=0, char='', nchar='') 60 0.013303
4 ETW000 [dev trc ,00000] application info callback registered 46 0.013349
4 ETW000 [dev trc ,00000] ➖ OCIEnvCreate(mode=16384=OCI_UTF16) returned 0 (for default NLS handle)
4 ETW000 2582 0.015931
4 ETW000 [dev trc ,00000] OCIHandleAlloc(OCI_HTYPE_ERROR, con_hdl=0, ErrHp=0x11100ce38) 75 0.016006
4 ETW000 [dev trc ,00000] OCIHandleAlloc(OCI_HTYPE_ERROR, con_hdl=0, ErrBt=0x11100c6e8) 53 0.016059
4 ETW000 [dev trc ,00000] NLS env. settings: lang=0041004D00450052004900430041004E00000000000000000000000000000000
4 ETW000 296 0.016355
4 ETW000 [dev trc ,00000] terr=0041004D00450052004900430041000000000000000000000000000000000000
4 ETW000 100 0.016455
4 ETW000 [dev trc ,00000] char=0055005400460031003600000000000000000000000000000000000000000000
4 ETW000 99 0.016554
4 ETW000 [dev trc ,00000] Client character set UTF16 -> UTF8 45 0.016599
4 ETW000 [dev trc ,00000] Client NLS setting (OCINlsGetInfo): connection handle 0 -> 'AMERICAN_AMERICA.UTF8'
4 ETW000 83 0.016682
4 ETW000 [dev trc ,00000] charset='', chset='UTF8', UNI_ASC=FALSE/FALSE 46 0.016728
4 ETW000 [dev trc ,00000] Logon as OPS$-user to get SAPSR3's password 50 0.016778
4 ETW000 [dev trc ,00000] Connecting as /@IDU on connection 0 (nls_hdl 0) ... (dbsl 701 140910)
4 ETW000 70 0.016848
4 ETW000 [dev trc ,00000] Nls CharacterSet NationalCharSet EnvHp ErrHp ErrHpBatch
4 ETW000 75 0.016923
4 ETW000 [dev trc ,00000] 0 UTF8 0x110ff4740 0x11100ce38 0x11100c6e8
4 ETW000 75 0.016998
4 ETW000 [dev trc ,00000] Allocating service context handle for con_hdl=0 59 0.017057
4 ETW000 [dev trc ,00000] Allocating server context handle 51 0.017108
4 ETW000 [dev trc ,00000] Attaching to DB Server IDU (con_hdl=0,svchp=0x111010418,srvhp=0x111011fb8)
4 ETW000 137 0.017245
4 ETW000 [dev trc ,00000] Wed Jan 5 21:25:37 2011 273206 0.290451
4 ETW000 [dev trc ,00000] Assigning server context 0x111011fb8 to service context 0x111010418 68 0.290519
4 ETW000 [dev trc ,00000] Allocating user session handle 85 0.290604
4 ETW000 [dev trc ,00000] Starting user session: OCISessionBegin(con_hdl=0, usr='/',svchp=0x111010418, srvhp=0x111011fb8, usrhp=0x111089340)
4 ETW000 115 0.290719
4 ETW000 [dev trc ,00000] OCISessionBegin(OCI_DEFAULT) failed with -1=OCI_ERROR 40498 0.331217
4 ETW000 [dev trc ,00000] OCISessionBegin(OCI_DEFAULT) failed with SQL error 1017: 245 0.331462
4 ETW000 [dev trc ,00000] ORA-01017: invalid username/password; logon denied
4 ETW000 80 0.331542
4 ETW000 [dbsloci. ,00000] *** ERROR => CONNECT failed with sql error '1017' 60 0.331602
4 ETW000 [dev trc ,00000] set_ocica() -> SQL error code 1017 85 0.331687
4 ETW000 [dev trc ,00000] -->oci_get_errmsg (con_hdl=0, rc=1017) 47 0.331734
4 ETW000 [dev trc ,00000] OCIErrorGet -> SQL error code: 1017 145 0.331879
4 ETW000 [dev trc ,00000] ORA-01017: invalid username/password; logon denied
4 ETW000 75 0.331954
4 ETW000 [dev trc ,00000] Info: 99=DBSL_ERR_DB, oerr=1017, try to connect with default password.
4 ETW000 74 0.332028
4 ETW000 [dev trc ,00000] Connecting as SAPSR3/<pwd>@IDU on connection 0 (nls_hdl 0) ... (dbsl 701 140910)
4 ETW000 73 0.332101
4 ETW000 [dev trc ,00000] Nls CharacterSet NationalCharSet EnvHp ErrHp ErrHpBatch
4 ETW000 77 0.332178
4 ETW000 [dev trc ,00000] 0 UTF8 0x110ff4740 0x11100ce38 0x11100c6e8
4 ETW000 77 0.332255
4 ETW000 [dev trc ,00000] Assigning username to user session: con_hdl=0, usrhp=0x111089340 50 0.332305
4 ETW000 [dev trc ,00000] Assigning password to user session: con_hdl=0, usrhp=0x111089340 61 0.332366
4 ETW000 [dev trc ,00000] Starting user session: OCISessionBegin(con_hdl=0, usr=SAPSR3/<pwd>, svchp=0x111010418, srvhp=0x111011fb8, usrhp=0x111089340)
4 ETW000 355 0.332721
4 ETW000 [dev trc ,00000] OCISessionBegin(OCI_DEFAULT) failed with -1=OCI_ERROR 18664 0.351385
4 ETW000 [dev trc ,00000] OCISessionBegin(OCI_DEFAULT) failed with SQL error 1017: 202 0.351587
4 ETW000 [dev trc ,00000] ORA-01017: invalid username/password; logon denied
4 ETW000 78 0.351665
4 ETW000 [dbsloci. ,00000] *** ERROR => CONNECT failed with sql error '1017' 57 0.351722
4 ETW000 [dev trc ,00000] set_ocica() -> SQL error code 1017 47 0.351769
4 ETW000 [dev trc ,00000] -->oci_get_errmsg (con_hdl=0, rc=1017) 46 0.351815
4 ETW000 [dev trc ,00000] OCIErrorGet -> SQL error code: 1017 142 0.351957
4 ETW000 [dev trc ,00000] ORA-01017: invalid username/password; logon denied
4 ETW000 75 0.352032
4 ETW000 [dblink ,00433] ***LOG BY2=>sql error 1017 performing CON [dblink#4 @ 433] 171 0.352203
4 ETW000 [dblink ,00433] ***LOG BY0=>ORA-01017: invalid username/password; logon denied [dblink#4 @ 433]
4 ETW000 73 0.352276
2EETW169 no connect possible: "DBMS = ORACLE --- dbs_ora_tnsname = 'IDU'"