Solved: Connect to SAP gateway failed during Installatio(S...

Hi,

I am doing SAP 2004S installation with Oracle10.2

Oracle installation completed.

SAP installation completed till step : ABAP post installation (28 out of 43 completed)

Now I am stuck in Check DDIC Password phase.

but my problem is not able to start Sap instance.

dev_rfc.trc says...

>TS> Mon Jul 13 11:34:02 2009

T:612 ======> Connect to SAP gateway failed

Connect_PM TPNAME=IGS.ANK, GWHOST=INLD50057853A, GWSERV=3301

LOCATION CPIC (TCP/IP) on local host

ERROR internal error

(this retcode should be handled by caller of NI-layer)

TIME Mon Jul 13 11:34:02 2009

RELEASE 700

COMPONENT NI (network interface)

VERSION 38

RC -8

MODULE nixx.c

LINE 1537

DETAIL NiCloseHandle: invalid hdl -1

COUNTER 12

>TS> Mon Jul 13 11:35:03 2009

T:612 ======> Connect to SAP gateway failed

Connect_PM TPNAME=IGS.ANK, GWHOST=INLD50057853A, GWSERV=3301

LOCATION CPIC (TCP/IP) on local host

ERROR internal error

(this retcode should be handled by caller of NI-layer)

TIME Mon Jul 13 11:35:03 2009

RELEASE 700

COMPONENT NI (network interface)

VERSION 38

RC -8

MODULE nixx.c

LINE 1537

DETAIL NiCloseHandle: invalid hdl -1

COUNTER 14

Could you please let me know what is problem here...where can I adjust gateway if it is the only problem.

Thanks,

Regards,

Ankit Baphna

SAP Managed Tags:
Oracle Database

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Accepted Solutions (1)

Ankit

Can you paste the content of your default profile?

Please also let us know what is ur system number.

Anindya

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

default.pfl goes here...

SAPDBHOST = INLD50057853A

j2ee/dbtype = ora

j2ee/dbname = ANK

j2ee/dbhost = INLD50057853A

SAPSYSTEMNAME = ANK

SAPGLOBALHOST = INLD50057853A

#----

# SAP Central Service Instance for J2EE

#----

j2ee/scs/host = INLD50057853A

j2ee/scs/system = 00

j2ee/ms/port = 3900

rdisp/bufrefmode = sendoff,exeoff

#----

# SAP Messaging Service for ABAP

#----

rdisp/mshost = INLD50057853A

rdisp/msserv = sapmsANK

rdisp/msserv_internal = 3901

login/system_client = 001

Regards,

Ankit Baphna

Windows server?

Is any process running ( check from task manager) for SAP unser user id SAPServiceSID? like sapstartsrv, disp+work?

If yes, kill all those and then try to start afresh.

But gateway connect may fail due to unavailibility of port also. You can run FPORT analysis for your system ( from OS) and then check which service is running on which port.

1) I tried killing all services and started again but same situation not able to login and not able to start instance.

msg_server.exe stoppoed

disp+work.exe stopped

2) FPORT is not working my Windows XP it says command not found

also tried fport -p

any other way to find ports

also where do we config sap gateway?

Regards,

Ankit Baphna

FPORT is a utility you have to download from Net.

Check the link below..

http://www.scanwith.com/download/Fport.htm

dev_w0 says...

Mon Jul 13 17:07:46 2009

C Client NLS settings: AMERICAN_AMERICA.UTF8

C Logon as OPS$-user to get SAPSR3's password

C Connecting as /@ANK on connection 0 (nls_hdl 0) ... (dbsl 700 310805)

C Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch

C 0 UTF8 1 063AC828 063B1DC4 063B164C

C Attaching to DB Server ANK (con_hdl=0,svchp=063B1598,svrhp=063C2E64)

C Starting user session (con_hdl=0,svchp=063B1598,srvhp=063C2E64,usrhp=063D7BC8)

C *** ERROR => OCI-call 'OCISessionBegin' failed: rc = 1017

[dboci.c 4325]

C *** ERROR => CONNECT failed with sql error '1017'

[dbsloci.c 10015]

C Try to connect with default password

C Connecting as SAPSR3/<pwd>@ANK on connection 0 (nls_hdl 0) ... (dbsl 700 310805)

C Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch

C 0 UTF8 1 063AC828 063B1DC4 063B164C

C Starting user session (con_hdl=0,svchp=063B1598,srvhp=063C2E64,usrhp=063D7BC8)

C *** ERROR => OCI-call 'OCISessionBegin' failed: rc = 28000

[dboci.c 4325]

C Detaching from DB Server (con_hdl=0,svchp=063B1598,srvhp=063C2E64)

C *** ERROR => CONNECT failed with sql error '28000'

[dbsloci.c 10015]

B ***LOG BY2=> sql error 28000 performing CON [dbsh#2 @ 1204] [dbsh 1204 ]

B ***LOG BY0=> ORA-28000: the account is locked [dbsh#2 @ 1204] [dbsh 1204 ]

B ***LOG BY2=> sql error 28000 performing CON [dblink#3 @ 431] [dblink 0431 ]

B ***LOG BY0=> ORA-28000: the account is locked [dblink#3 @ 431] [dblink 0431 ]

M ***LOG R19=> ThInit, db_connect ( DB-Connect 000256) [thxxhead.c 1400]

M in_ThErrHandle: 1

M *** ERROR => ThInit: db_connect (step 1, th_errno 13, action 3, level 1) [thxxhead.c 10017]

Regards,

Ankit Baphna

Dear Ankit,

Please see the below log.

Attaching to DB Server ANK (con_hdl=0,svchp=063B1598,svrhp=063C2E64)
C Starting user session (con_hdl=0,svchp=063B1598,srvhp=063C2E64,usrhp=063D7BC8)
C *** ERROR => OCI-call 'OCISessionBegin' failed: rc = 1017
http://dboci.c 4325
C *** ERROR => CONNECT failed with sql error '1017'
<a href="http://dbsloci.c" TARGET="test_blank">http://dbsloci.c</a> 10015
C Try to connect with default password
C Connecting as SAPSR3/<pwd>@ANK on connection 0 (nls_hdl 0) ... (dbsl 700 310805)
C Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch
C 0 UTF8 1 063AC828 063B1DC4 063B164C
C Starting user session (con_hdl=0,svchp=063B1598,srvhp=063C2E64,usrhp=063D7BC8)
C *** ERROR => OCI-call 'OCISessionBegin' failed: rc = 28000
http://dboci.c 4325
C Detaching from DB Server (con_hdl=0,svchp=063B1598,srvhp=063C2E64)
C *** ERROR => CONNECT failed with sql error '28000'
http://dbsloci.c 10015
B ***LOG BY2=> sql error 28000 performing CON dbsh#2 @ 1204 dbsh 1204 
B ***LOG BY0=> ORA-28000: the account is locked dbsh#2 @ 1204 dbsh 1204 
B ***LOG BY2=> sql error 28000 performing CON dblink#3 @ 431 dblink 0431 
B ***LOG BY0=> ORA-28000: the account is locked dblink#3 @ 431 dblink 0431 
M ***LOG R19=> ThInit, db_connect ( DB-Connect 000256) http

ORA-1017 shows that your entering the wrong password.

ORA-28000 shows your SAPSR3 password is wrong.

Please try below queries at SQL prompt.

to unlock the user account : - ALTER USER SAPSR3 ACCOUNT UNLOCK;

Use BR*Tools to change the password.

Please see the below link.

[;

Tnx

Shambo

unlock your account as described in SAP note 951167

ok I have unlocked SAPSR3

How do I change password?

if now I restart my instance I get same message still..

dev_w0 says connect failed with sql error 1017

C *** ERROR => OCI-call 'OCISessionBegin' failed: rc = 1017

[dboci.c 4325]

C *** ERROR => CONNECT failed with sql error '1017'

[dbsloci.c 10015]

C Try to connect with default password

C Connecting as SAPSR3/<pwd>@ANK on connection 0 (nls_hdl 0) ... (dbsl 700 310805)

C Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch

C 0 UTF8 1 063AC828 063B1DC4 063B164C

C Starting user session (con_hdl=0,svchp=063B1598,srvhp=063C2E64,usrhp=063D7BC8)

C *** ERROR => OCI-call 'OCISessionBegin' failed: rc = 1017

dev_rfc says Connect to SAP gateway failed

>TS> Tue Jul 14 09:37:13 2009

T:3636 ======>

Connect_PM TPNAME=IGS.ANK, GWHOST=INLD50057853A, GWSERV=3301

LOCATION CPIC (TCP/IP) on local host

ERROR internal error

(this retcode should be handled by caller of NI-layer)

TIME Tue Jul 14 09:37:13 2009

RELEASE 700

COMPONENT NI (network interface)

Regards,

Ankit Baphna

Ankit

.CONNECT failed with sql error '1017'

Did you check note https://service.sap.com/sap/support/notes/400241 ?

Have a look at it, if it helps.

For changing password, use SQL

Alter user <shcema_id>.<username> identified by <password>;

Btw, can you please paste the out put of the below sql

select username from dba_users;

Best Regards

Anindya

Edited by: Anindya Bose on Jul 14, 2009 10:30 AM

Hi Ankit,

Please see the link

[;

Also please paste the R3trans -x command & paste the trans.log file output.

Tnx,

Shambo

By the way why are we trying workprocess to connect first(i.e. dev_w0) we should make sure that Message server is running fine(i.e. dev_rfc).

As said earlier I am not able to start message server.

T:3636 ======> Connect to SAP gateway failed

Connect_PM TPNAME=IGS.ANK, GWHOST=INLD50057853A, GWSERV=3301

in services file I can see entry

sapgw00 3300/tcp

sapgw01 3301/tcp

Could you please let me know how to make this message server work then it makes sense to check workprocess issue.

Regards,

Ankit Baphna

Hi,

You can change password of the user SAPSR3 using BRTools.

Regards,

Kalyan

Hi,

can u please paste the dev_ms trace file.

did u check r3trans -x is successful or not???

tnx

shambo

r3trans -x

C:\usr\sap\ANK\SYS\exe\uc\NTI386>r3trans -x

This is r3trans version 6.13 (release 700 - 22.09.05 - 11:11:00).

unicode enabled version

2EETW169 no connect possible: "connect failed with DBLI_RC_LOAD_LIB_FAILED."

r3trans finished (0012).

dev_ms

trc file: "dev_ms", trc level: 1, release: "700"

[Thr 2228] Tue Jul 14 14:46:45 2009

[Thr 2228] MsSSetTrcLog: trc logging active, max size = 20971520 bytes

systemid 560 (PC with Windows NT)

relno 7000

patchlevel 0

patchno 26

intno 20050900

make: multithreaded, Unicode

pid 3524

[Thr 2228] ***LOG Q01=> MsSInit, MSStart (Msg Server 1 3524) [msxxserv.c 1828]

[Thr 2228] ***LOG Q0I=> NiPGetServByName2: service 'sapmsANK' not found: getservbyname_r [ninti.c 530]

[Thr 2228] *** ERROR => MsSCommInit: NiBufListen(sapmsANK) (rc=NIESERV_UNKNOWN) [msxxserv.c 10082]

[Thr 2228] *** ERROR => MsSInit: MsSCommInit [msxxserv.c 1861]

[Thr 2228] *** ERROR => main: MsSInit [msxxserv.c 5871]

[Thr 2228] ***LOG Q02=> MsSHalt, MSStop (Msg Server 3524) [msxxserv.c 5919]

Regards,

Ankit Baphna

Hi Ankit,

2EETW169 no connect possible: "connect failed with DBLI_RC_LOAD_LIB_FAILED."
r3trans finished (0012).

Please run this command by login as <sid>adm user & paste the trans.log file here. You will find this file under C:\Documents and Settings\<SID>adm folder.

Also refer OSS Note Note 556232 - Environment settings for R/3/Oracle on Windows

Thr 2228 ***LOG Q0I=> NiPGetServByName2: service 'sapmsANK' not found: getservbyname_r http://ninti.c 530
Thr 2228 *** ERROR => MsSCommInit: NiBufListen(sapmsANK) (rc=NIESERV_UNKNOWN) http://msxxserv.c 10082
Thr 2228 *** ERROR => MsSInit: MsSCommInit http://msxxserv.c 1861
Thr 2228 *** ERROR => main: MsSInit http://msxxserv.c 5871

Fo this please refer OSS Note 896973.

Tnx.

Shambo

Hi,

Also check the entry in hosts file under C:\WINDOWS\system32\drivers\etc\hosts like

<IP_ADDRESS>     <HOSTNAME>

Also check the entry like C:\WINDOWS\system32\drivers\etc\services

sapmsANK   33<INSTANCE NO>/tcp

Thanks,

Shambo

my one issue solved i.e. of message server.

well I added sapmsANK 3301/tcp

I was now able to start instance but only for few seconds.

Message server is green now but dispatcher went down

dev_w0 says....

Tue Jul 14 16:24:17 2009

C Starting user session (con_hdl=0,svchp=063B1598,srvhp=063C2E64,usrhp=063D7BC8)

C *** ERROR => OCI-call 'OCISessionBegin' failed: rc = 1017

[dboci.c 4325]

C *** ERROR => CONNECT failed with sql error '1017'

[dbsloci.c 10015]

C Try to connect with default password

C Connecting as SAPSR3/<pwd>@ANK on connection 0 (nls_hdl 0) ... (dbsl 700 310805)

C Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch

C 0 UTF8 1 063AC828 063B1DC4 063B164C

C Starting user session (con_hdl=0,svchp=063B1598,srvhp=063C2E64,usrhp=063D7BC8)

C *** ERROR => OCI-call 'OCISessionBegin' failed: rc = 28000

[dboci.c 4325]

C Detaching from DB Server (con_hdl=0,svchp=063B1598,srvhp=063C2E64)

C *** ERROR => CONNECT failed with sql error '28000'

Regards,

Ankit Baphna

also dispatcher log says...

ue Jul 14 16:31:05 2009

rdisp/http_min_wait_dia_wp : 1 -> 1

***LOG CPS=> DpLoopInit, ICU ( 3.0 3.0 4.0.1) [dpxxdisp.c 1611]

***LOG Q0K=> DpMsAttach, mscon ( INLD50057853A) [dpxxdisp.c 11163]

CCMS: AlInitGlobals : alert/use_sema_lock = TRUE.

CCMS: Initalizing shared memory of size 60000000 for monitoring segment.

CCMS: start to initalize 3.X shared alert area (first segment).

DpMsgAdmin: Set release to 7000, patchlevel 0

MBUF state PREPARED

MBUF component UP

DpMBufHwIdSet: set Hardware-ID

***LOG Q1C=> DpMBufHwIdSet [dpxxmbuf.c 1050]

DpMsgAdmin: Set patchno for this platform to 33

Release check o.K.

Tue Jul 14 16:31:45 2009

ERROR => W0 (pid 5556) died [dpxxdisp.c 13748]
ERROR => W1 (pid 2768) died [dpxxdisp.c 13748]

my types changed after wp death/restart 0xbf --> 0xbe

ERROR => W2 (pid 4376) died [dpxxdisp.c 13748]

my types changed after wp death/restart 0xbe --> 0xbc

ERROR => W3 (pid 3708) died [dpxxdisp.c 13748]

my types changed after wp death/restart 0xbc --> 0xb8

ERROR => W4 (pid 5392) died [dpxxdisp.c 13748]

my types changed after wp death/restart 0xb8 --> 0xb0

ERROR => W5 (pid 1544) died [dpxxdisp.c 13748]

my types changed after wp death/restart 0xb0 --> 0xa0

ERROR => W6 (pid 3872) died [dpxxdisp.c 13748]

my types changed after wp death/restart 0xa0 --> 0x80

DP_FATAL_ERROR => DpWPCheck: no more work processes
DISPATCHER EMERGENCY SHUTDOWN ***

increase tracelevel of WPs

killing W0-5556 (SIGUSR2)

ERROR => DpWpKill(5556, SIGUSR2) failed [dpxxtool.c 2586]

killing W1-2768 (SIGUSR2)

ERROR => DpWpKill(2768, SIGUSR2) failed [dpxxtool.c 2586]

killing W2-4376 (SIGUSR2)

ERROR => DpWpKill(4376, SIGUSR2) failed [dpxxtool.c 2586]

killing W3-3708 (SIGUSR2)

ERROR => DpWpKill(3708, SIGUSR2) failed [dpxxtool.c 2586]

killing W4-5392 (SIGUSR2)

ERROR => DpWpKill(5392, SIGUSR2) failed [dpxxtool.c 2586]

killing W5-1544 (SIGUSR2)

ERROR => DpWpKill(1544, SIGUSR2) failed [dpxxtool.c 2586]

killing W6-3872 (SIGUSR2)

ERROR => DpWpKill(3872, SIGUSR2) failed [dpxxtool.c 2586]

NiWait: sleep (10000ms) ...

NiISelect: timeout 10000ms

NiISelect: maximum fd=1673

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Tue Jul 14 16:31:55 2009

NiISelect: TIMEOUT occured (10000ms)

dump system status

Workprocess Table (long) Tue Jul 14 11:01:55 2009

========================

and syslog says...

SAPBasis:MEssage server disconnected

SAP Gateway closed

Database error: 1017 at CON

ORA01017: invalid username/password; logon denied

Which username is this referring to?

Regards,

Ankit Baphna

Edited by: I041468 on Jul 14, 2009 1:09 PM

Hi Ankit,

C *** ERROR => OCI-call 'OCISessionBegin' failed: rc = 1017
C *** ERROR => CONNECT failed with sql error '28000'

The dispatcher went down because of the above error. Please paste the log of R3trans -x command from trans.log file.

The above error shows that the SAPSR3 user is still locked.

Thanks,

Shambo

ORA01017: invalid username/password; logon denied* Which username is this referring to? Regards, Ankit Baphna Edited by: I041468 on Jul 14, 2009 1:09 PM

Referring to user SAPSR3. Please unlock this user using sql query

alter user <username> account unlock;

commit;

Use BR*Tools to change the password of SAPSR3 user id. To do so start brtools choose option 8 Additional Functions

then choose Option 4 Change password of database user

& follow the instructions.

Tnx,

Shambo

Hi,

here goes output of r3trans -x by userid ankadm

C:\Documents and Settings\ankadm>r3trans -x

This is r3trans version 6.13 (release 700 - 22.09.05 - 11:11:00).

unicode enabled version

2EETW169 no connect possible: "DBMS = ORACLE --- dbs_o

ra_tnsname = 'ANK'"

r3trans finished (0012).

and I have unlocked user id sapsr3 many times..

SQL> conn /as sysdba

Connected.

SQL> alter user SAPSR3 account unlock;

User altered.

SQL> commit;

Commit complete.

Regards,

Ankit Baphna

Hi Ankit,

Please paste the contents of the trans.log file.

You will find this under c:\documnets and settings\ankadm folder.

also post the result of the sql command

select username,account_status from dba_users;

Did you change the password of SAPSR3 using BR*tools ?

Tnks

Shambo

Edited by: Shambo on Jul 14, 2009 5:19 PM


> ORA01017: invalid username/password; logon denied* Which username is this referring to? Regards, Ankit Baphna Edited by: I041468 on Jul 14, 2009 1:09 PM
> 
> 
> Referring to user SAPSR3. Please unlock this user using sql query 
> 
> alter user <username> account unlock;
> commit;
> 
> Use BR*Tools to change the password of SAPSR3 user id. To do so start brtools choose option 8 Additional Functions
> 
> then choose Option 4 Change password of database user
> 
> & follow the instructions.
> 
> Tnx,
> Shambo

hi,

I'm not in the mood to read the complete thread, too long, sorry.

But, I wonder if all advise given has been as this one.

The error is that the password for the user is wrong.

If, as consequence of that, the user is locked (not shown here) unlocking the user will not solve the problem. the password still is WRONGGGGGGGGG. An the user will be locked again, and so on and so forth

to the OP, The output of "R3trans -x" is not interesting (if there are errors) what is important is the "trans.log" file created by the mentioned statement.

please, post that here if the error is NOT ORA01017 and post it formatted (use code Markup)

if the password still is wrong, then change it to the default one and then (when installation is finished and you can start SAP) change it with BR* tools to something that is not the default

Hello ,,

Please change the password for "SAPSR3" user to "sap".

This is default password which the installer expects during installation.

The current issue is that :the installer tries to login with user :ops$ "connect /@<sid> " ., to get the current password of SAPSR3 user , but this fails .

As a fallback the installer then tries with default password "sap".

Hence use the brtools to set password for SAPSR3 to "sap" and then try r3trans -d.

More details: SAP Note:400241

Regards

-Ranjiv

Answers (3)

Hi,

The simple way to resolve password problem is.

Run the script from SQL> delete from <SCHEMA_ID>.usr02 where mandt= '000' and bname= 'SAP*';

Set the parameter

Restart the instance & log in by user sap* & password = pass or PASS

Regards,

Darshan..

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Hi,

ok I can go with deletion part(previous message) but I have problem during accessing BRtools

During shutting down db from brtools I got message

BR0259I Program execution will be continued...

BR0252E Function fopen() failed for 'ANK\sapbackup\.user.pas' at location BrTool

Call-2

BR0253E errno 2: No such file or directory

How to proceed from here...I am not able to do any activity from brtools(this is another problem with my original problem)

Regards,

Ankit Baphna

Ankit,

use login :sap*

Password :06071992

and change password ddic or update passcode with null value 'don't give welcome

SurendraJain

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Hi Ankit,

Reset DDIC password from sapsr3.usr02 through SQL .

SurendraJain

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

I dont think so its problem with DDIC pass...SAP instance needs in startup status and for this I need to resolve gateway issue.

I mentioned DDIC phase but its a problem with gateway.

Could you please again have a look or if you are very sure than I can try to change DDIC pass but will this help?

Thanks,

Regards

Ankit Baphna

Ankit,

Once i faced problem in DDIC password check ...

and solved

During installation error in DDIC password checking

Solution :

Password :06071992

If still not working then update sap* with passcode='';

SurendraJain

Hi,

As surendra already said ...reset DDIC password either through SQL(changing USR02 table) or login with SAP*/06071992 and change the password of DDIC user(The instance will be started). After changing DDIC password ..login with DDIC id and also change the initial password.

Now try to continue the installation and enter the new password of DDIC when asked. I also got the same error and got rectified doing the same.

Regards,

Kalyan

Ok I tried....but unfrotunately I am not able to find table USR02 itself...as I said installation is not completed.

SQL> SELECT * FROM USR02;

SELECT * FROM USR02

ERROR at line 1:

ORA-00942: table or view does not exist

Any other option to resolve gateway issue? or setting DDIC password is only solution?

I am not able to login to ABAP system as not yet completed installation.

Regards,

Ankit Baphna

Hi,

Please try the below sql

SELECT * FROM <schema_id>.USR02;

Then reset the password of DDIC. always call table USR02 along with Schema_id i.e <schema_id>.USR02

Thanks and Regards

Debdeep

If you are connected through sys then

use

SQL> SELECT * FROM sapsr3.USR02;

ok I did...but still the same.

If I right click on instance and say start it says "already started"

but my instance is in yellow colour and MSG_Server.exe + disp+work.exe are down

and during right click->logon it says below erros

>TS> Mon Jul 13 11:35:03 2009

T:612 ======> Connect to SAP gateway failed

Connect_PM TPNAME=IGS.ANK, GWHOST=INLD50057853A, GWSERV=3301

LOCATION CPIC (TCP/IP) on local host

ERROR internal error

(this retcode should be handled by caller of NI-layer)

TIME Mon Jul 13 11:35:03 2009

RELEASE 700

COMPONENT NI (network interface)

VERSION 38

RC -8

MODULE nixx.c

LINE 1537

DETAIL NiCloseHandle: invalid hdl -1

COUNTER 14

Regards,

Ankit Baphna

Edited by: I041468 on Jul 13, 2009 11:59 AM

Your statement is wrong and you already changed to records mistakenly.If you did not commit the statement then please rollback it.

As surendra already said the statement should be update SAPSR3.usr02 set passcode='' where bname='DDIC' and mandt=000;

But i prefer login with SAP*/06071992 into SAP Instance and change the password of DDIC user since the SAP Instance is already Up and running.(Recomended).

Regards,

Kalyan

yes I rolledback those wrong commands...

now I executed this command

SQL> UPDATE SAPSR3.USR02 SET PASSCODE='welcome' where BNAME='DDIC' and MANDT=000;

UPDATE SAPSR3.USR02 SET PASSCODE='welcome' where BNAME='DDIC' and MANDT=000

ERROR at line 1:

ORA-01465: invalid hex number

what value should I enter for passcode?

current value is somewhat like this...

SQL> SELECT PASSCODE FROM SAPSR3.USR02 WHERE BNAME='DDIC'

2 ;

PASSCODE

----

7E867EA66F30CD98D7668B6D76E20ACA47A2754C

Regards,

Ankit Baphna

Hi,

The password will be stored in hexadecimal format and cannot be entered maually.

So please use the second option for changing the password of DDIC.

The instance is up and running...so why dont you login with SAP* and change the password of DDIC and then login with DDIC and change the initial password of DDIC. Now continue the installation

Regards,

Kalyan

Ask a Question

Top Q&A Solution Author

User

Count

Connect to SAP gateway failed during Installatio(SAP 2004s with Oracle10.2)

Accepted Solutions (1)

Accepted Solutions (1)

Answers (3)

Answers (3)

Re: Fiori app Manage bank statements F1564 - addin...

Re: SAP Fiori Elements - Save Variant/Layout not w...

Re: Getting error while configuring SAP system in ...

Re: When changing text interpretation to HTML Crys...

Re: SAP Analytics Cloud for planning - Comparator ...