cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

ORA-01017: invalid username/password; logon denied

Former Member

on ‎03-09-2009 9:47 AM

0 Kudos

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?

Show replies
Show replies
Answer

Accepted Solutions (0)

Answers (11)

Answers (11)

Former Member
‎03-11-2009 9:14 AM
0 Kudos

solved

Show replies
Show replies
Former Member
‎05-15-2009 12:57 PM
0 Kudos

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

Former Member
‎05-15-2009 12:58 PM
0 Kudos

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

fidel_vales
Employee
Employee
‎05-15-2009 5:28 PM
0 Kudos

For starters, this thread is closed, problem solved, therefore do not continue with it.

So, open a new "question" and indicate if you have done any of the recommendations here.

indicate also what user are you using for the backup AND the command being executed with all the options

Former Member
‎05-30-2013 6:00 AM
0 Kudos

This message was moderated.

former_member204746
Active Contributor
‎03-10-2009 11:45 AM
0 Kudos

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.

Show replies
Show replies
Former Member
‎03-10-2009 1:00 PM
0 Kudos

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).

debasissahoo
Active Contributor
‎03-10-2009 2:49 PM
0 Kudos

check this.

former_member204746
Active Contributor
‎03-10-2009 2:52 PM
0 Kudos

please provide resulting newer trans.log again.

Former Member
‎03-10-2009 2:56 PM
0 Kudos

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'"

former_member204746
Active Contributor
‎03-10-2009 5:34 PM
0 Kudos

ok, try this (Repalce ZZZZ with your domain name)

sqlplus / as sysdba

truncate "OPS$ZZZZ\GW1ADM".SAPUSER;

insert into "OPS$ZZZZ\GW1ADM".SAPUSER values ('SAPSR3','your_password');

grant select, update on "OPS$ZZZZ\GW1ADM".SAPUSER to "OPS$ZZZZ\SAPSERVICEGW1";

EXIT;

former_member603052
Contributor
‎03-11-2009 4:34 AM
0 Kudos

Hi,

Also check the parameter DBS_ORA_SCHEMA is set to SAPSR3.

Regards,

Kalyan

Former Member
‎03-11-2009 9:14 AM
0 Kudos

Many thanks for all.

Problem solved.

former_member603052
Contributor
‎03-10-2009 10:50 AM
0 Kudos

Hi,

Login to the SAP System with sidadm user and run brtools from command prompt.

Regards,

Kalyan

Show replies
Show replies
Former Member
‎03-10-2009 7:10 AM
0 Kudos

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.

Show replies
Show replies
former_member603052
Contributor
‎03-10-2009 5:24 AM
0 Kudos

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

Show replies
Show replies
Former Member
‎03-10-2009 7:37 AM
0 Kudos

Could you please specify which sidadm can't connect to the database: sidadm sap gateway or sisadm application?

Former Member
‎03-10-2009 5:04 AM
0 Kudos

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

Show replies
Show replies
Former Member
‎03-09-2009 12:31 PM
0 Kudos

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

Show replies
Show replies
Former Member
‎03-09-2009 1:08 PM
0 Kudos 
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'"
debasissahoo
Active Contributor
‎03-09-2009 2:24 PM
0 Kudos

Hi Vladislav,

Did you change the password of the database schema user by sql recently? in that case, you can change the password again by brtools.

Thanks,

Debasis.

former_member603052
Contributor
‎03-09-2009 10:43 AM
0 Kudos

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

Show replies
Show replies
Former Member
‎03-09-2009 10:36 AM
0 Kudos

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

Show replies
Show replies
Former Member
‎03-09-2009 10:14 AM
0 Kudos

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.

Show replies
Show replies
Former Member
‎03-09-2009 10:28 AM
0 Kudos

O/S - Windows 2003

SAP Version - 7.00

Former Member
‎03-09-2009 9:55 AM
0 Kudos

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

Show replies
Show replies
Ask a Question