J2ee Stack not comming up after configuring RAC

[Former Member]

Hello

We have installed High availability system in HP Unix box IA64 with

Oracle 10g database with virtual host name and ip for usage type PI7.0

ABAP+JAVA dual stack. System was up and running successfully after the

installation.

We configure RAC Real time Application Cluster for our PI production system. After converting single instance database

to RAC database, JAVA Stack is not comming up but ABAP stack is working fine.

DB is connecting thro OS by checking the command ps -ef | grep -i smon, ps -ef | grep -i pmon, and R3trans value 0000. But Configtool unable to connect. We checked in secure store for the value of the below parmeters

jdbc/pool/MIP/usr value is SAPR3DB

jdbc/pool/MIP/Password

values are correct. values are correct.

since it is a RAC we dont the know value for jdbc/pool/MIP/url

Please let know us know whether it is work for me

jdbc:oracle:thin:@(DESCRIPTION=(LOAD_BALANCE=on)

(ADDRESS=(PROTOCOL=TCP)(HOST=spxic023) (PORT=1527))

(ADDRESS=(PROTOCOL=TCP)(HOST=spxid019) (PORT=1527))

(CONNECT_DATA=(SERVICE_NAME=MIP.World)))

Note: sapxic023 is node A host name, spxid019 is node B. Since we have three SERVICE_NAME in tnsnames.ora file, so tell us which name we need to mention for SERVICE_NAME ?

1) MIP01.World 2)MIP02.World 3) MIP.World

[Former Member]

Hi all,

Problem got solved by executing the same parameter for JDBC .

jdbc:oracle:thin:@(DESCRIPTION=(LOAD_BALANCE=on)

(ADDRESS=(PROTOCOL=TCP)(HOST=spxic023) (PORT=1527))

(ADDRESS=(PROTOCOL=TCP)(HOST=spxid019) (PORT=1527))

(CONNECT_DATA=(SERVICE_NAME=MIP.World)))

and also refered the note 576919.

Thanks for your help.

[Former Member]

Hello,

Please refer to SAP Note: 576919 and see if that helps.

Please mention the entire exception/error message which is thrown when you try to start the configtool.

Regards,

Snehal Bhaidasna

Palo Alto, CA(USA)

[Former Member]

Hi Vijay,

What error do you get when you try to connect?

Kind regards,

Mark Dijsselbloem