R3trans and sqlplus/@SID hang when the AS is started

[Former Member]

Hi all,

I have migrated one platform on Windows 2003 with SAP 4.6C Oracle 10.2.2 and client 920

Everything is working fine with the DBCI + the first AS

SAP + DB + DB COnnect ...

I can perform an R3tans with return code 000 from the DBCI , the first AS and the 2nd AS as well

But When I start the 2nd Application Server ; the R3trans hangs, and I can't connect to the Database (sqlplus /@SDI hangs) through the 2nd AS, the first and the DBCI neighter.

If someone has encountered this issue, thanks for your help

Cheers

Yacine

[former_member204746 · Accepted solution]

check initSID.ora

check values for SESSIONS and PROCESSES.

[Former Member · Accepted solution]

Hi Eric,

Many thanks for your answer and sorry for the delay of my anser.

Indeed we have adjusted these parameters and deceased the WP for both AS.

Currently it's a closing period for us so the 2 AS si stopped for security, but for the next month we will start it whith these changes.

Thanks to all for your help

Yacine

[Former Member]

Hi Thanks for your quick feedback,

Both AS have been installed with the Oracle 9i.

I heard that the client 10g is not supported by SAP.

Yacine

[Former Member]

Oracle client 10 is supported by SAP but client is dependent on you SAP Kernel.

Thanks

Prince Jose

[Former Member]

Yes the client is supported but not for my Kernel

SAP 4.6C Kernel 4.6D Ext32.

That's the raison why I have installed the client 9i and I got this issue.

Currentlt the landscape is working with the DBCI+ one AS (client 9i)

Cheers

Yacine

[ImtiazKaredia]

Hi,

Have you upgraded oracle client on second AS?

Thanks

Imtiaz