on 11-24-2006 7:43 AM
Hi All,
I am installing a dialog instance(ABAP System of SAP Netweaver 2004) on SOLARIS. I have central instance on AIX. Installation was successful but after starting the instance I am unable to connect to it using SAP GUI. I have run R3trans and got trans.log. It shows some errors. Please find the trans.log attached.
Please suggest me on this.
-Shivender
-
4 ETW000 R3trans version 6.09 (release 640 - 13.01.05 - 10:38:00).
4 ETW000 ===============================================
4 ETW000
4 ETW000 date&time : 23.11.2006 - 23:58:57
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 Nov 23 23:58:57 2006 992 0.000992
4 ETW000 [dev trc ,00000] db_con_init called 70 0.001062
4 ETW000 [dev trc ,00000] create_con (con_name=R/3) 499 0.001561
4 ETW000 [dev trc ,00000] Loading DB library '/usr/sap/C11/SYS/exe/run/dboraslib.so' ...
4 ETW000 203 0.001764
4 ETW000 [dev trc ,00000] Thu Nov 23 23:58:58 2006 127095 0.128859
4 ETW000 [dev trc ,00000] load shared library (/usr/sap/C11/SYS/exe/run/dboraslib.so), hdl 0
4 ETW000 138 0.128997
4 ETW000 [dev trc ,00000] Library '/usr/sap/C11/SYS/exe/run/dboraslib.so' loaded
4 ETW000 185 0.129182
4 ETW000 [dev trc ,00000] function DbSlExpFuns loaded from library /usr/sap/C11/SYS/exe/run/dboraslib.so
4 ETW000 133 0.129315
4 ETW000 [dev trc ,00000] Version of '/usr/sap/C11/SYS/exe/run/dboraslib.so' is "640.00", patchlevel (0.55)
4 ETW000 704 0.130019
4 ETW000 [dev trc ,00000] function dsql_db_init loaded from library /usr/sap/C11/SYS/exe/run/dboraslib.so
4 ETW000 102 0.130121
4 ETW000 [dev trc ,00000] function dbdd_exp_funs loaded from library /usr/sap/C11/SYS/exe/run/dboraslib.so
4 ETW000 247 0.130368
4 ETW000 [dev trc ,00000] New connection 0 created 173 0.130541
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 126 0.130667
4 ETW000 [dev trc ,00000] db_con_connect (con_name=R/3) 150 0.130817
4 ETW000 [dev trc ,00000] find_con_by_name found the following connection for reuse:
4 ETW000 92 0.130909
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 110 0.131019
4 ETW000 [dev trc ,00000] Got ORACLE_HOME=/oracle/D11/920_64 from environment
4 ETW000 3358 0.134377
4 ETW000 [dev trc ,00000] -->oci_init1 114 0.134491
4 ETW000 [dev trc ,00000] -->oci_initialize (con_hdl=0) 86 0.134577
4 ETW000 [dev trc ,00000] Client NLS settings: AMERICAN_AMERICA.WE8DEC 14289 0.148866
4 ETW000 [dev trc ,00000] Logon as OPS$-user to get SAPC11's password 84 0.148950
4 ETW000 [dev trc ,00000] Connecting as /@D11 on connection 0 (nls_hdl 0) ...
4 ETW000 91 0.149041
4 ETW000 [dev trc ,00000] Nls Characterset Natcharacterset C EnvHp ErrHp ErrHpBatch
4 ETW000 188 0.149229
4 ETW000 [dev trc ,00000] 0 1 100ef0820 100ef9aa8 100ef94b8
4 ETW000 140 0.149369
4 ETW000 [dev trc ,00000] Allocating service context handle for con_hdl=0 183 0.149552
4 ETW000 [dev trc ,00000] Allocating server context handle 82 0.149634
4 ETW000 [dev trc ,00000] Attaching to DB Server D11 (con_hdl=0,svchp=100ef93e8,svrhp=100efb798)
4 ETW000 450 0.150084
4 ETW000 [dev trc ,00000] Assigning server context 100efb798 to service context 100ef93e8
4 ETW000 113960 0.264044
4 ETW000 [dev trc ,00000] Allocating user session handle 221 0.264265
4 ETW000 [dev trc ,00000] Starting user session (con_hdl=0,svchp=100ef93e8,srvhp=100efb798,usrhp=100f05168)
4 ETW000 128 0.264393
4 ETW000 [dev trc ,00000] Assigning user session 100f05168 to service context 100ef93e8
4 ETW000 61060 0.325453
4 ETW000 [dev trc ,00000] Now '/@D11' is connected (con_hdl 0, nls_hdl 0).
4 ETW000 14414 0.339867
4 ETW000 [dev trc ,00000] Got SAPC11's password from OPS$-user 27091 0.366958
4 ETW000 [dev trc ,00000] Disconnecting from connection 0 ... 82 0.367040
4 ETW000 [dev trc ,00000] Rolling back transaction ... 103 0.367143
4 ETW000 [dev trc ,00000] Closing user session (con_hdl=0,svchp=100ef93e8,usrhp=100f05168)
4 ETW000 12026 0.379169
4 ETW000 [dev trc ,00000] Now I'm disconnected from ORACLE 12415 0.391584
4 ETW000 [dev trc ,00000] Connecting as SAPC11/<pwd>@D11 on connection 0 (nls_hdl 0) ...
4 ETW000 152 0.391736
4 ETW000 [dev trc ,00000] Nls Characterset Natcharacterset C EnvHp ErrHp ErrHpBatch
4 ETW000 119 0.391855
4 ETW000 [dev trc ,00000] 0 1 100ef0820 100ef9aa8 100ef94b8
4 ETW000 96 0.391951
4 ETW000 [dev trc ,00000] Assigning username to user session 100f05168 63 0.392014
4 ETW000 [dev trc ,00000] Assigning password to user session 100f05168 115 0.392129
4 ETW000 [dev trc ,00000] Starting user session (con_hdl=0,svchp=100ef93e8,srvhp=100efb798,usrhp=100f05168)
4 ETW000 109 0.392238
4 ETW000 [dboci.c ,00000] *** ERROR => OCI-call 'OCISessionBegin' failed: rc = 1017
4 ETW000 41300 0.433538
4 ETW000 [dbsloci. ,00000] *** ERROR => CONNECT failed with sql error '1017'
4 ETW000 107 0.433645
4 ETW000 [dblink ,00419] ***LOG BY2=>sql error 1017 performing CON [dblink#2 @ 419]
4 ETW000 513 0.434158
4 ETW000 [dblink ,00419] ***LOG BY0=>ORA-01017: invalid username/password; logon denied [dblink#2 @ 419]
4 ETW000 102 0.434260
2EETW169 no connect possible: "DBMS = ORACLE --- dbs_ora_tnsname = 'D11'"
-
Yes, it looks as thought there may be a conflict of SIDs, between D11 and C11. Are you running anything else on this server?
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 using D11 central database instance and C11 SAP
> Central Instance while installing I have given
> database schema as SAPC11.... is it correct?
>
> Thanks in advance.
>
> Thanks,
> Shivender.
Hi,
you can not use different system ID for database, central and dialog instance.
Please setup your central instance and dialog instance using the same SID of database and it will work fine.
Regards
Ermanno Gallo
Hi Shivender,
Is the listener started?
Regards
Juan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
in logs there are manu mismatch between D11 and C11.
what is the right systemID?
you are trying to connect to D11 system as SAPC11 using /usr/sap/C11/SYS/exe/run/dboraslib.so library.
Is this right for your environment?
Dialog instance have to have the same systemID of central instance.
Regards
Ermanno Gallo
User | Count |
---|---|
85 | |
10 | |
10 | |
9 | |
6 | |
6 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.