on 03-09-2009 9:47 AM
Hi guys. I've been having the same problem for the last few days. The application and DB (Oracle) are located on different servers, SAP gateway is installed on the server with the database. When I try to update DB13 statistics it comes up with the following log:
Date Time Message
06.03.2009 10:24:47 Job started
06.03.2009 10:24:47 Step 001 started (program RSDBAJOB, variant &0000000000032, user ID SVA)
06.03.2009 10:24:48 Execute logical command BRCONNECT On host sap-dup
06.03.2009 10:24:48 Parameters: -u / -jid STATS20090306102447 -c -f stats -t ALL
06.03.2009 10:24:48 BR0801I BRCONNECT 7.00 (40)
06.03.2009 10:24:48 BR0805I Start of BRCONNECT processing: ceablvkp.sta 2009-03-06 10.24.47
06.03.2009 10:24:48 BR0484I BRCONNECT log file: F:\oracle\SID\sapcheck\ceablvkp.sta
06.03.2009 10:24:48 BR0280I BRCONNECT time stamp: 2009-03-06 10.24.47
06.03.2009 10:24:48 BR0301E SQL error -1017 at location db_connect-2,SQL statement:
06.03.2009 10:24:48 CONNECT /'
06.03.2009 10:24:48 ORA-01017: invalid username/password; logon denied
06.03.2009 10:24:48 BR0310E Connect to database instance SID failed
06.03.2009 10:24:48 BR0280I BRCONNECT time stamp: 2009-03-06 10.24.47
06.03.2009 10:24:48 BR0301E SQL error -1017 at location db_connect-2,SQL statement:
06.03.2009 10:24:48 CONNECT /'
06.03.2009 10:24:48 ORA-01017: invalid username/password; logon denied
06.03.2009 10:24:48 BR0310E Connect to database instance SID failed
06.03.2009 10:24:48
06.03.2009 10:24:48 BR0806I End of BRCONNECT processing: ceablvkp.sta2009-03-06 10.24.47
06.03.2009 10:24:48 BR0280I BRCONNECT time stamp: 2009-03-06 10.24.47
06.03.2009 10:24:48 BR0804I BRCONNECT terminated with errors
06.03.2009 10:24:48 External program terminated with exit code 3
06.03.2009 10:24:48 BRCONNECT returned error status E
06.03.2009 10:24:48 Job finished
I don't understand why the service can't log into the database. Any suggestions?
solved
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Dear Friend,
I am also having the same Issue with My Sandbox system During the Backup.as Below.
###############################################################################
BR0051I BRBACKUP 7.00 (40)
BR0055I Start of database backup: beaigmxx.afd 2009-04-11 12.28.21
BR0484I BRBACKUP log file: F:\oracle\SDX\sapbackup\beaigmxx.afd
BR0280I BRBACKUP time stamp: 2009-04-11 12.28.22
BR0301E SQL error -1017 at location BrDbConnect-2, SQL statement:
'CONNECT /'
ORA-01017: invalid username/password; logon denied
BR0310E Connect to database instance SDX failed
BR0280I BRBACKUP time stamp: 2009-04-11 12.28.23
BR0301E SQL error -1017 at location BrDbConnect-2, SQL statement:
'CONNECT /'
ORA-01017: invalid username/password; logon denied
BR0310E Connect to database instance SDX failed
BR0056I End of database backup: beaigmxx.afd 2009-04-11 12.28.22
BR0280I BRBACKUP time stamp: 2009-04-11 12.28.23
BR0054I BRBACKUP terminated with errors
###############################################################################
BR0292I Execution of BRBACKUP finished with return code 3
BR0668I Warnings or errors occurred - you can continue to ignore them or go back to repeat the last acti
BR0280I BRTOOLS time stamp: 2009-04-11 12.28.23
BR0670I Enter 'c[ont]' to continue, 'b[ack]' to go back, 's[top]' to abort:
I just saw Your Message in SDN .I tried but could not help me out.
Please can you send me detail solution about the Issue .
Thanks & regards;
Rajkumar
Dear Friend,
I am also having the same Issue with My Sandbox system During the Backup.as Below.
###############################################################################
BR0051I BRBACKUP 7.00 (40)
BR0055I Start of database backup: beaigmxx.afd 2009-04-11 12.28.21
BR0484I BRBACKUP log file: F:\oracle\SDX\sapbackup\beaigmxx.afd
BR0280I BRBACKUP time stamp: 2009-04-11 12.28.22
BR0301E SQL error -1017 at location BrDbConnect-2, SQL statement:
'CONNECT /'
ORA-01017: invalid username/password; logon denied
BR0310E Connect to database instance SDX failed
BR0280I BRBACKUP time stamp: 2009-04-11 12.28.23
BR0301E SQL error -1017 at location BrDbConnect-2, SQL statement:
'CONNECT /'
ORA-01017: invalid username/password; logon denied
BR0310E Connect to database instance SDX failed
BR0056I End of database backup: beaigmxx.afd 2009-04-11 12.28.22
BR0280I BRBACKUP time stamp: 2009-04-11 12.28.23
BR0054I BRBACKUP terminated with errors
###############################################################################
BR0292I Execution of BRBACKUP finished with return code 3
BR0668I Warnings or errors occurred - you can continue to ignore them or go back to repeat the last acti
BR0280I BRTOOLS time stamp: 2009-04-11 12.28.23
BR0670I Enter 'c[ont]' to continue, 'b[ack]' to go back, 's[top]' to abort:
I just saw Your Message in SDN .I tried but could not help me out.
Please can you send me detail solution about the Issue .
Thanks & regards;
Rajkumar
run these commands:
brconnect -u / -c -l E -f chpass -o SAPSR3 -password whatever_you_want
sqlplus /nolog @sapdba_role.sql SID NT
good luck.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
E:\usr\sap\GW1\SYS\exe\nuc\NTIA64>brconnect -u / -c -l E -f chpass -o SAPSR3 -password My_Pwd
BR0801I BRCONNECT 7.00 (38)
BR0280I BRCONNECT time stamp: 2009-03-10 14.50.46
BR0828I Changing password for database user SAPSR3
BR0280I BRCONNECT time stamp: 2009-03-10 14.50.46
BR0829I Password changed successfully in database for user SAPSR3
BR0830I Password changed successfully in table OPS$SAP-DUP\PUPADM.SAPUSER for user SAPSR3
BR0280I BRCONNECT time stamp: 2009-03-10 14.50.46
BR0802I BRCONNECT completed successfully
E:\usr\sap\GW1\SYS\exe\nuc\NTIA64>sqlplus '/ as sysdba' @sapdba_role.sql PUP
SQL*Plus: Release 10.2.0.2.0 - Production on Tue Mar 10 14:57:39 2009
Copyright (c) 1982, 2005, Oracle. All Rights Reserved.
Enter password:
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
E:\usr\sap\GW1\SYS\exe\nuc\NTIA64>r3trans -dx
This is r3trans version 6.14 (release 700 - 05.02.09 - 11:17:00).
2EETW169 no connect possible: "DBMS = ORACLE --- dbs_ora_tnsname = 'PUP'"
r3trans finished (0012).
4 ETW000 r3trans version 6.14 (release 700 - 05.02.09 - 11:17:00).
4 ETW000 ===============================================
4 ETW000
4 ETW000 date&time : 10.03.2009 - 16:55:02
4 ETW000 control file: <no ctrlfile>
4 ETW000 R3trans was called as follows: r3trans -dx
4 ETW000 trace at level 2 opened for a given file pointer
4 ETW000 [dev trc ,00000] Tue Mar 10 16:55:05 2009 0 0.000000
4 ETW000 [dev trc ,00000] db_con_init called 0 0.000000
4 ETW000 [dev trc ,00000] create_con (con_name=R/3) 0 0.000000
4 ETW000 [dev trc ,00000] Loading DB library 'dboraslib.dll' ... 0 0.000000
4 ETW000 [dev trc ,00000] load shared library (dboraslib.dll), hdl 0 6533 0.006533
4 ETW000 [dev trc ,00000] using "E:\usr\sap\GW1\SYS\exe\nuc\NTIA64\dboraslib.dll" 17 0.006550
4 ETW000 [dev trc ,00000] Library 'dboraslib.dll' loaded 13 0.006563
4 ETW000 [dev trc ,00000] function DbSlExpFuns loaded from library dboraslib.dll 17 0.006580
4 ETW000 [dev trc ,00000] Version of 'dboraslib.dll' is "700.08", patchlevel (0.167) 157 0.006737
4 ETW000 [dev trc ,00000] function dsql_db_init loaded from library dboraslib.dll 14 0.006751
4 ETW000 [dev trc ,00000] function dbdd_exp_funs loaded from library dboraslib.dll 22 0.006773
4 ETW000 [dev trc ,00000] New connection 0 created 26 0.006799
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 37 0.006836
4 ETW000 [dev trc ,00000] db_con_connect (con_name=R/3) 20 0.006856
4 ETW000 [dev trc ,00000] find_con_by_name found the following connection for reuse: 13 0.006869
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 27 0.006896
4 ETW000 [dev trc ,00000] CLIENT_ORACLE_HOME is not set as environment variable or 162 0.007058
4 ETW000 DIR_CLIENT_ORAHOME is not set as profile parameter.
4 ETW000 assuming using instant client with unspecified location.
4 ETW000 [dev trc ,00000] Oracle Client Version: '10.2.0.2.0' 36030 0.043088
4 ETW000 [dev trc ,00000] -->oci_initialize (con_hdl=0) 25 0.043113
4 ETW000 [dev trc ,00000] Client NLS settings: AMERICAN_AMERICA.UTF8 2358 0.045471
4 ETW000 [dev trc ,00000] Logon as OPS$-user to get SAPSR3's password 30 0.045501
4 ETW000 [dev trc ,00000] Connecting as /@PUP on connection 0 (nls_hdl 0) ... (dbsl 700 030508)
4 ETW000 26 0.045527
4 ETW000 [dev trc ,00000] Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch
4 ETW000 25 0.045552
4 ETW000 [dev trc ,00000] 0 UTF8 1 000000000030C840 0000000000314A70 0000000000332238
4 ETW000 27 0.045579
4 ETW000 [dev trc ,00000] Allocating service context handle for con_hdl=0 86 0.045665
4 ETW000 [dev trc ,00000] Allocating server context handle 21 0.045686
4 ETW000 [dev trc ,00000] Attaching to DB Server PUP (con_hdl=0,svchp=00000000003320F8,srvhp=00000000003364C8)
4 ETW000 45 0.045731
4 ETW000 [dev trc ,00000] Assigning server context 00000000003364C8 to service context 00000000003320F8
4 ETW000 30038 0.075769
4 ETW000 [dev trc ,00000] Allocating user session handle 40 0.075809
4 ETW000 [dev trc ,00000] Starting user session (con_hdl=0,svchp=00000000003320F8,srvhp=00000000003364C8,usrhp=0000000000315288)
4 ETW000 35 0.075844
4 ETW000 [dev trc ,00000] Assigning user session 0000000000315288 to service context 00000000003320F8
4 ETW000 43940 0.119784
4 ETW000 [dev trc ,00000] -->oci_prepare_stmt(con_hdl=0, len=55, stmth_p=000000000EF33918) 39 0.119823
4 ETW000 [dev trc ,00000] BEGIN DBMS_APPLICATION_INFO.SET_MODULE (:A0, :A1); END;
4 ETW000 27 0.119850
4 ETW000 [dev trc ,00000] -->oci_prepare_stmt(con_hdl=0, len=55, stmth_p=000000000EF34970) 96 0.119946
4 ETW000 [dev trc ,00000] BEGIN DBMS_APPLICATION_INFO.SET_CLIENT_INFO (:A0); END;
4 ETW000 26 0.119972
4 ETW000 [dev trc ,00000] -->oci_prepare_stmt(con_hdl=0, len=0, stmth_p=000000000EF34970) 639 0.120611
4 ETW000 [dev trc ,00000] SELECT SID FROM V$MYSTAT WHERE ROWNUM<2
4 ETW000 26 0.120637
4 ETW000 [dev trc ,00000] Connected to session 22. 415 0.121052
4 ETW000 [dev trc ,00000] Now '/@PUP' is connected: con_hdl=0, nls_hdl=0, session_id=22. 18 0.121070
4 ETW000 [dev trc ,00000] -->oci_prepare_stmt(con_hdl=0, len=0, stmth_p=000000000EF34970) 23 0.121093
4 ETW000 [dev trc ,00000] ALTER SESSION SET NLS_SORT = BINARY
4 ETW000 25 0.121118
4 ETW000 [dev trc ,00000] -->oci_prepare_stmt(con_hdl=0, len=0, stmth_p=000000000EF34970) 333 0.121451
4 ETW000 [dev trc ,00000] SELECT USERID, PASSWD FROM SAPUSER WHERE USERID IN (:A0, :A1)
4 ETW000 26 0.121477
4 ETW000 [dbsloci. ,00000] *** ERROR => Cannot decrypt password I got from table SAPUSER: rc = 128
4 ETW000 379 0.121856
4 ETW000 [dev trc ,00000] Disconnecting from connection 0 ... 14 0.121870
4 ETW000 [dev trc ,00000] Rolling back transaction ... 55 0.121925
4 ETW000 [dev trc ,00000] Closing user session (con_hdl=0,svchp=00000000003320F8,usrhp=0000000000315288)
4 ETW000 201 0.122126
4 ETW000 [dev trc ,00000] Now I'm disconnected from ORACLE 497 0.122623
2EETW169 no connect possible: "DBMS = ORACLE --- dbs_ora_tnsname = 'PUP'"
Hi,
Login to the SAP System with sidadm user and run brtools from command prompt.
Regards,
Kalyan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Does your password for SAPSR3 contains "@" special character. If it does then normally you will face problems logging. This is a bug especially if the Oracle is installed on Windows Server.
Please change the password using brtools without @ special character and see if this works out for you.
Thanks,
Faisal.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Samorukov,
Its clear that you need to change the password of SAPSR3 schema owner of your Database.
Yo can change password of this using BRTools
Login with sidadm and from command prompt
-
>BRTools
>Enter 8 (to select Additional functions)
>Enter 4 (to select change password)
> enter 2(and give system/password)
> enter 3(give SAPSR3 to change password)
>Enter new password
>Retype new password
>press c to continue
The password changed will be confirmed.Now start the instance.
Regards,
Kalyan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Vlacislav,
Change your schema password with below OS command.
brconnect -u system/<password> -f chpass -o <sapowner> -p <password>
Then delete old R3trans logs and retry.
Regards
Nick Loy
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Vladislav,
Go through the sapnote 400241, this should help you to avoid these type of issues.
Mean while send us the R3trans -dx log file to analysis.
Regards
Nick Loy
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
4 ETW000 r3trans version 6.14 (release 700 - 18.09.06 - 09:35:00).
4 ETW000 ===============================================
4 ETW000
4 ETW000 date&time : 09.03.2009 - 15:05:33
4 ETW000 control file: <no ctrlfile>
4 ETW000 R3trans was called as follows: r3trans -dx
4 ETW000 trace at level 2 opened for a given file pointer
4 ETW000 [dev trc ,00000] Mon Mar 09 15:05:35 2009 0.000000
4 ETW000 [dev trc ,00000] db_con_init called 0.000000
4 ETW000 [dev trc ,00000] create_con (con_name=R/3) 0.000000
4 ETW000 [dev trc ,00000] Loading DB library 'dboraslib.dll' ... 0.000000
4 ETW000 [dev trc ,00000] load shared library (dboraslib.dll), hdl 0 6414 0.006414
4 ETW000 [dev trc ,00000] using "E:\usr\sap\GW1\SYS\exe\nuc\NTIA64\dboraslib.dll"
4 ETW000 22 0.006436
4 ETW000 [dev trc ,00000] Library 'dboraslib.dll' loaded 10 0.006446
4 ETW000 [dev trc ,00000] function DbSlExpFuns loaded from library dboraslib.dll
4 ETW000 22 0.006468
4 ETW000 [dev trc ,00000] Version of 'dboraslib.dll' is "700.08", patchlevel (0.144)
4 ETW000 9382 0.015850
4 ETW000 [dev trc ,00000] function dsql_db_init loaded from library dboraslib.dll
4 ETW000 20 0.015870
4 ETW000 [dev trc ,00000] function dbdd_exp_funs loaded from library dboraslib.dll
4 ETW000 26 0.015896
4 ETW000 [dev trc ,00000] New connection 0 created 26 0.015922
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 37 0.015959
4 ETW000 [dev trc ,00000] db_con_connect (con_name=R/3) 12 0.015971
4 ETW000 [dev trc ,00000] find_con_by_name found the following connection for reuse:
4 ETW000 17 0.015988
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 24 0.016012
4 ETW000 [dev trc ,00000] CLIENT_ORACLE_HOME is not set as environment variable or
4 ETW000 DIR_CLIENT_ORAHOME is not set as profile parameter.
4 ETW000 assuming using instant client with unspecified location.
4 ETW000 174 0.016186
4 ETW000 [dev trc ,00000] Oracle Client Version: '10.2.0.2.0' 35265 0.051451
4 ETW000 [dev trc ,00000] -->oci_initialize (con_hdl=0) 23 0.051474
4 ETW000 [dev trc ,00000] Client NLS settings: AMERICAN_AMERICA.UTF8 2451 0.053925
4 ETW000 [dev trc ,00000] Logon as OPS$-user to get SAPSR3's password 24 0.053949
4 ETW000 [dev trc ,00000] Connecting as /@PUP on connection 0 (nls_hdl 0) ... (dbsl 700 250407)
4 ETW000 23 0.053972
4 ETW000 [dev trc ,00000] Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch
4 ETW000 24 0.053996
4 ETW000 [dev trc ,00000] 0 UTF8 1 000000000030E840 0000000000316A70 0000000000334238
4 ETW000 95 0.054091
4 ETW000 [dev trc ,00000] Allocating service context handle for con_hdl=0 20 0.054111
4 ETW000 [dev trc ,00000] Allocating server context handle 16 0.054127
4 ETW000 [dev trc ,00000] Attaching to DB Server PUP (con_hdl=0,svchp=00000000003340F8,srvhp=00000000003364C8)
4 ETW000 43 0.054170
4 ETW000 [dev trc ,00000] Assigning server context 00000000003364C8 to service context 00000000003340F8
4 ETW000 62895 0.117065
4 ETW000 [dev trc ,00000] Allocating user session handle 40 0.117105
4 ETW000 [dev trc ,00000] Starting user session (con_hdl=0,svchp=00000000003340F8,srvhp=00000000003364C8,usrhp=0000000000317288)
4 ETW000 32 0.117137
4 ETW000 [dev trc ,00000] Assigning user session 0000000000317288 to service context 00000000003340F8
4 ETW000 43518 0.160655
4 ETW000 [dev trc ,00000] BEGIN DBMS_APPLICATION_INFO.SET_MODULE (:A0, :A1); END;
4 ETW000 46 0.160701
4 ETW000 [dev trc ,00000] BEGIN DBMS_APPLICATION_INFO.SET_CLIENT_INFO (:A0); END;
4 ETW000 105 0.160806
4 ETW000 [dev trc ,00000] Now '/@PUP' is connected (con_hdl 0, nls_hdl 0).
4 ETW000 722 0.161528
4 ETW000 [dev trc ,00000] ALTER SESSION SET NLS_SORT = BINARY
4 ETW000 26 0.161554
4 ETW000 [dev trc ,00000] SELECT USERID, PASSWD FROM SAPUSER WHERE USERID IN (:A0, :A1)
4 ETW000 395 0.161949
4 ETW000 [dbsloci. ,00000] *** ERROR => Cannot decrypt password I got from table SAPUSER: rc = 128
4 ETW000 499 0.162448
4 ETW000 [dev trc ,00000] Disconnecting from connection 0 ... 14 0.162462
4 ETW000 [dev trc ,00000] Rolling back transaction ... 41 0.162503
4 ETW000 [dev trc ,00000] Closing user session (con_hdl=0,svchp=00000000003340F8,usrhp=0000000000317288)
4 ETW000 196 0.162699
4 ETW000 [dev trc ,00000] Now I'm disconnected from ORACLE 500 0.163199
2EETW169 no connect possible: "DBMS = ORACLE --- dbs_ora_tnsname = 'PUP'"
Hi,
Check the password of SAPSID(db schema owner).
Run R3trans -d to check if any connectivity problems exists between R/3 and Database.
You can change password of SAPSID using BRTools.
Regards,
Kalyan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
You seems to have some permission issue. Please check attached note.
[https://websmp130.sap-ag.de/sap(bD1lbiZjPTAwMQ==)/bc/bsp/spn/sapnotes/index2.htm?numm=113747]
Hope this helps.
Manoj chintawar
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Could you please let us know whats the database, O/S and SAP Version.
Also try the following commands on DB Server (If the database is Oracle and you have only ABAP Engine) and let us know the result.
sqlplus /nolog
conn SAPR3
Then enter the password.
Thanks,
Faisal.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi
Check your database schema user id and password
For example the user will be like SAPR3
Try to connect database with this user.
Hope it helps
Regards
KT
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
82 | |
9 | |
9 | |
7 | |
7 | |
7 | |
6 | |
6 | |
5 | |
5 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.