cancel
Showing results for 
Search instead for 
Did you mean: 

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

0 Kudos

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

View Entire Topic
Former Member
0 Kudos

Hi Ankit,

Reset DDIC password from sapsr3.usr02 through SQL .

SurendraJain

0 Kudos

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

Former Member
0 Kudos

Ankit,

Once i faced problem in DDIC password check ...

and solved

-


During installation error in DDIC password checking

Solution :

login :sap*

Password :06071992

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

-


SurendraJain

former_member603052
Contributor
0 Kudos

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

0 Kudos

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

former_member475159
Participant
0 Kudos

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

Former Member
0 Kudos

If you are connected through sys then

use

SQL> SELECT * FROM sapsr3.USR02;

0 Kudos

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

former_member603052
Contributor
0 Kudos

Hi

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

0 Kudos

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

7E867EA66F30CD98D7668B6D76E20ACA47A2754C

Regards,

Ankit Baphna

former_member603052
Contributor
0 Kudos

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