SAP J2EE and Oracle Database Connectivity

[Former Member]

Hi Guys,

I have a pure JAVA portal system installed on HP-UX and oracle database.

i have been recieving alerts

Oracle database is open but cannot connect with OPS$SIDADM user.

So my questions are .

1) How to test database connectivity between pure SAP java and oracle database?

2) How is connection established in SAP java and Oracle Database ? I mean what plays an important role in this connection?

I think JDBC is the main component , but how to test connection using it?

R3trans -d is not appropriate as it is for testing connection between SAP ABAP and oracle database , SAPUSER table is also created in ABAP .

Kindly help me im clearing this concepts?

Regards,

Ameya

Edited by: Ameya Joshi on Mar 30, 2010 5:22 PM

[former_member204746 · Accepted solution]

check this:

also, you can check the DB connection by launching the config tool.

[stefan_koehler]

Hello Ameya,

> 1) How to test database connectivity between pure SAP java and oracle database?

Run the config tool like Eric already mentioned.

> 2) How is connection established in SAP java and Oracle Database ? I mean what plays an important role in this connection?

The database connection parameters are stored in the "secure store" in the file system.

For more information check this:

http://help.sap.com/saphelp_nw04/helpdata/en/cd/14c93ec2f7df6ae10000000a114084/content.htm

Regards

Stefan

[Former Member]

Hello Stefan,

I would like to know more about the Oracle DB administration on SAP AS Java (standalone).

Can you please let me know about the default tablespaces I dont see PSAPSR3DBUSR and PSAPSR3DB740<REL> while they will be available in ABAP stack, how user management takes place and which tablespace stores the user masters? please can you clear my query.

Thanks in advance..