Connectivity with Oracle

[Former Member]

Hi All:

I tried to connect with oracle but I am unable to connect it, I insatalled oracle with XI installation..i am trying username and password as scott and tiger to connect with Oracle SQL tool but it is not connecting..how can I resolve it..

[moorthy]

Hi,

I think you have got list of tips from the other post:

Still quick checks:

1) check out the Correct JDBC driver is installed in XI server?

2) then check the connection parameters given in the JDBC adapter? Does it correct ? check out the upper/lower case etc

3) User ID and Password

4) btw, what is the exact error you are getting ? and where? in communication channel?

Rgds,

Moorthy

[agasthuri_doss]

Hi,

This will help you

http://help.sap.com/saphelp_nw04/helpdata/en/2e/96fd3f2d14e869e10000000a155106/content.htm.

/people/laxman.molugu/blog/2006/08/13/integration-with-databases-made-easy-150-part-1

/people/sriram.vasudevan3/blog/2005/02/14/calling-stored-procs-in-maxdb-using-sap-xi

/people/alessandro.berta/blog/2005/10/04/save-time-with-generalized-jdbc-datatypes

http://help.sap.com/saphelp_nw04/helpdata/en/2e/96fd3f2d14e869e10000000a155106/content.htm.

/people/thorsten.nordholmsbirk/blog/2006/07/25/structuring-integration-repository-content--part-1-software-component-versions

Regards

Agasthuri Doss