on 04-29-2009 11:06 PM
SAP cant be started with DB connect failure error code: 0256.
Using SAPDBA to change SAPR3 password, get following error: error druing CONNECT (ststr1)
Working diretory dev_w5 log file as following:
-
trc file: "dev_w5", trc level: 1, release: "640"
-
*
ACTIVE TRACE LEVEL 1
ACTIVE TRACE COMPONENTS all, M
*
B
B Wed Apr 29 08:13:00 2009
B create_con (con_name=R/3)
B Loading DB library 'D:\usr\sap\ERQ\SYS\exe\run\dboraslib.dll' ...
B Library 'D:\usr\sap\ERQ\SYS\exe\run\dboraslib.dll' loaded
B Version of 'D:\usr\sap\ERQ\SYS\exe\run\dboraslib.dll' is "640.00", patchlevel (0.220)
B New connection 0 created
M sysno 00
M sid ERQ
M systemid 560 (PC with Windows NT)
M relno 6400
M patchlevel 0
M patchno 247
M intno 20020600
M make: multithreaded, ASCII
M pid 3020
M
M ***LOG Q0Q=> tskh_init, WPStart (Workproc 5 3020) [dpxxdisp.c 1170]
I MtxInit: -2 0 0
M DpSysAdmExtCreate: ABAP is active
M DpShMCreate: sizeof(wp_adm) 7712 (964)
M DpShMCreate: sizeof(tm_adm) 2379840 (11840)
M DpShMCreate: sizeof(wp_ca_adm) 18000 (60)
M DpShMCreate: sizeof(appc_ca_adm) 6000 (60)
M DpShMCreate: sizeof(comm_adm) 192000 (384)
M DpShMCreate: sizeof(vmc_adm) 0 (364)
M DpShMCreate: sizeof(wall_adm) (22440/34344/56/100)
M DpShMCreate: SHM_DP_ADM_KEY (addr: 06DF0040, size: 2666544)
M DpShMCreate: allocated sys_adm at 06DF0040
M DpShMCreate: allocated wp_adm at 06DF17D8
M DpShMCreate: allocated tm_adm_list at 06DF35F8
M DpShMCreate: allocated tm_adm at 06DF3620
M DpShMCreate: allocated wp_ca_adm at 07038660
M DpShMCreate: allocated appc_ca_adm at 0703CCB0
M DpShMCreate: allocated comm_adm_list at 0703E420
M DpShMCreate: allocated comm_adm at 0703E438
M DpShMCreate: allocated vmc_adm_list at 0706D238
M DpShMCreate: system runs without vmc_adm
M DpShMCreate: allocated ca_info at 0706D260
M DpShMCreate: allocated wall_adm at 0706D268
M
M Wed Apr 29 08:13:01 2009
M ThTaskStatus: rdisp/reset_online_during_debug 0
X EmInit: MmSetImplementation( 2 ).
X <ES> client 5 initializing ....
X Using implementation flat
M <EsNT> Memory Reset disabled as NT default
X ES initialized.
M
M Wed Apr 29 08:13:02 2009
M calling db_connect ...
C Prepending d:\oracle\ERQ to Path.
C got NLS_LANG='AMERICAN_AMERICA.US7ASCII' from environment
C Client NLS settings: AMERICAN_AMERICA.US7ASCII
C Logon as OPS$-user to get SAPR3's password
C Connecting as /@ERQ on connection 0 (nls_hdl 0) ... (dbsl 640 070308)
C Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch
C 0 US7ASCII 1 04DD9E28 096DB2A8 096DAD10
C Attaching to DB Server ERQ (con_hdl=0,svchp=096DAC64,srvhp=04DDE444)
C
C Wed Apr 29 08:13:03 2009
C Starting user session (con_hdl=0,svchp=096DAC64,srvhp=04DDE444,usrhp=04DE7058)
C Now '/@ERQ' is connected: con_hdl=0, nls_hdl=0, session_id=18.
C Got SAPR3's password from OPS$-user
C Disconnecting from connection 0 ...
C Close user session (con_hdl=0,svchp=096DAC64,usrhp=04DE7058)
C Now I'm disconnected from ORACLE
C Connecting as SAPR3/<pwd>@ERQ on connection 0 (nls_hdl 0) ... (dbsl 640 070308)
C Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch
C 0 US7ASCII 1 04DD9E28 096DB2A8 096DAD10
C Starting user session (con_hdl=0,svchp=096DAC64,srvhp=04DDE444,usrhp=04DE7058)
C Now 'SAPR3/<pwd>@ERQ' is connected: con_hdl=0, nls_hdl=0, session_id=15.
C
C Wed Apr 29 08:13:04 2009
C Database NLS settings: AMERICAN_AMERICA.US7ASCII
C DB instance ERQ is running on CBSERP11 with ORACLE version 9.2.0.7.0 since APR 29, 2009, 08:12:29
B Connection 0 opened (DBSL handle 0)
B Wp Hdl ConName ConId ConState TX PRM RCT TIM MAX OPT Date Time DBHost
B 000 000 R/3 000000000 ACTIVE NO YES NO 000 255 255 20090429 081302 CBSERP11
M db_connect o.k.
M ICT: exclude compression: .zip,.cs,.rar,.arj,.z,.gz,.tar,.lzh,.cab,.hqx,.ace,.jar,.ear,.war,.css,.pdf,.js,.gzip,.uue,.bz2,.iso,.sda,.sar,.gif
I MtxInit: 5 0 0
you must run sapdba_role.sql as per SAP note 400241.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Can you connect to oracle manually using SQLPLUS?
Refer to notes 50088 and 400241
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
try this
brconnect -u system/password -c -f chpass -o SAPR3 -p password
as sidadm, check R3trans -d and check trans.log
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Here is trans logs
4 ETW000 R3trans version 6.13 (release 640 - 17.07.08 - 08:11:00).
4 ETW000 ===============================================
4 ETW000
4 ETW000 date&time : 30.04.2009 - 09:39:08
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 30 09:39:10 2009 6692 0.006692
4 ETW000 [dev trc ,00000] db_con_init called 113 0.006805
4 ETW000 [dev trc ,00000] create_con (con_name=R/3) 95 0.006900
4 ETW000 [dev trc ,00000] Loading DB library 'dboraslib.dll' ... 82 0.006982
4 ETW000 [dev trc ,00000] load shared library (dboraslib.dll), hdl 0 14121 0.021103
4 ETW000 [dev trc ,00000] using "D:\usr\sap\ERQ\SYS\exe\run\dboraslib.dll"
4 ETW000 309 0.021412
4 ETW000 [dev trc ,00000] Library 'dboraslib.dll' loaded 23 0.021435
4 ETW000 [dev trc ,00000] function DbSlExpFuns loaded from library dboraslib.dll
4 ETW000 40 0.021475
4 ETW000 [dev trc ,00000] Version of 'dboraslib.dll' is "640.00", patchlevel (0.220)
4 ETW000 29904 0.051379
4 ETW000 [dev trc ,00000] function dsql_db_init loaded from library dboraslib.dll
4 ETW000 39 0.051418
4 ETW000 [dev trc ,00000] function dbdd_exp_funs loaded from library dboraslib.dll
4 ETW000 58 0.051476
4 ETW000 [dev trc ,00000] New connection 0 created 39 0.051515
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 48 0.051563
4 ETW000 [dev trc ,00000] db_con_connect (con_name=R/3) 34 0.051597
4 ETW000 [dev trc ,00000] find_con_by_name found the following connection for reuse:
4 ETW000 35 0.051632
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 44 0.051676
4 ETW000 [dev trc ,00000] Setting DIR_CLIENT_ORAHOME is not set as environment variable,
4 ETW000 assuming using instant client with unspecified location.
4 ETW000 13767 0.065443
4 ETW000 [dev trc ,00000] -->oci_initialize (con_hdl=0) 2299 0.067742
4 ETW000 [dev trc ,00000] got NLS_LANG='AMERICAN_AMERICA.US7ASCII' from environment
4 ETW000 45 0.067787
4 ETW000 [dev trc ,00000] Thu Apr 30 09:39:11 2009 140697 0.208484
4 ETW000 [dev trc ,00000] Client NLS settings: AMERICAN_AMERICA.US7ASCII 38 0.208522
4 ETW000 [dev trc ,00000] Logon as OPS$-user to get SAPR3's password 25 0.208547
4 ETW000 [dev trc ,00000] Connecting as /@ERQ on connection 0 (nls_hdl 0) ... (dbsl 640 070308)
4 ETW000 6636 0.215183
4 ETW000 [dev trc ,00000] Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch
4 ETW000 47 0.215230
4 ETW000 [dev trc ,00000] 0 US7ASCII 1 03576050 0357B0B8 0357AB20
4 ETW000 236 0.215466
4 ETW000 [dev trc ,00000] Allocating service context handle for con_hdl=0 11771 0.227237
4 ETW000 [dev trc ,00000] Allocating server context handle 32 0.227269
4 ETW000 [dev trc ,00000] Attaching to DB Server ERQ (con_hdl=0,svchp=0357AA74,srvhp=0357B67C)
4 ETW000 75 0.227344
4 ETW000 [dev trc ,00000] Assigning server context 0357B67C to service context 0357AA74
4 ETW000 237441 0.464785
4 ETW000 [dev trc ,00000] Allocating user session handle 70 0.464855
4 ETW000 [dev trc ,00000] Starting user session (con_hdl=0,svchp=0357AA74,srvhp=0357B67C,usrhp=03584248)
4 ETW000 50 0.464905
4 ETW000 [dev trc ,00000] Assigning user session 03584248 to service context 0357AA74
4 ETW000 73073 0.537978
4 ETW000 [dev trc ,00000] BEGIN DBMS_APPLICATION_INFO.SET_MODULE (:A0, :A1); END;
4 ETW000 79 0.538057
4 ETW000 [dev trc ,00000] BEGIN DBMS_APPLICATION_INFO.SET_CLIENT_INFO (:A0); END;
4 ETW000 125 0.538182
4 ETW000 [dev trc ,00000] SELECT SID FROM V$MYSTAT WHERE ROWNUM<2
4 ETW000 1241 0.539423
4 ETW000 [dev trc ,00000] Connected to session 14. 937 0.540360
4 ETW000 [dev trc ,00000] Now '/@ERQ' is connected: con_hdl=0, nls_hdl=0, session_id=14.
4 ETW000 41 0.540401
4 ETW000 [dev trc ,00000] ALTER SESSION SET NLS_SORT = BINARY
4 ETW000 48 0.540449
4 ETW000 [dev trc ,00000] SELECT USERID,PASSWD FROM SAPUSER WHERE USERID IN (:A0, :A1)
4 ETW000 440 0.540889
4 ETW000 [dev trc ,00000] Got SAPR3's password from OPS$-user 1119 0.542008
4 ETW000 [dev trc ,00000] Disconnecting from connection 0 ... 26 0.542034
4 ETW000 [dev trc ,00000] Rolling back transaction ... 38 0.542072
4 ETW000 [dev trc ,00000] Close user session (con_hdl=0,svchp=0357AA74,usrhp=03584248)
4 ETW000 257 0.542329
4 ETW000 [dev trc ,00000] Now I'm disconnected from ORACLE 443 0.542772
4 ETW000 [dev trc ,00000] Connecting as SAPR3/<pwd>@ERQ on connection 0 (nls_hdl 0) ... (dbsl 640 070308)
4 ETW000 42 0.542814
4 ETW000 [dev trc ,00000] Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch
4 ETW000 41 0.542855
4 ETW000 [dev trc ,00000] 0 US7ASCII 1 03576050 0357B0B8 0357AB20
4 ETW000 50 0.542905
4 ETW000 [dev trc ,00000] Assigning username to user session 03584248 24 0.542929
4 ETW000 [dev trc ,00000] Assigning password to user session 03584248 30 0.542959
4 ETW000 [dev trc ,00000] Starting user session (con_hdl=0,svchp=0357AA74,srvhp=0357B67C,usrhp=03584248)
4 ETW000 37 0.542996
4 ETW000 [dboci.c ,00000] *** ERROR => OCI-call 'OCISessionBegin' failed: rc = 1017
4 ETW000 17898 0.560894
4 ETW000 [dbsloci. ,00000] *** ERROR => CONNECT failed with sql error '1017'
4 ETW000 35 0.560929
4 ETW000 [dev trc ,00000] set_ocica() -> OCI or SQL return code 1017 21 0.560950
4 ETW000 [dblink ,00428] ***LOG BY2=>sql error 1017 performing CON [dblink#3 @ 428]
4 ETW000 23931 0.584881
4 ETW000 [dblink ,00428] ***LOG BY0=>ORA-01017: invalid username/password; logon denied [dblink#3 @ 428]
4 ETW000 34 0.584915
2EETW169 no connect possible: "DBMS = ORACLE --- dbs_ora_tnsname = 'ERQ'"
User | Count |
---|---|
91 | |
10 | |
10 | |
9 | |
9 | |
7 | |
6 | |
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.