PI 7.31 - JDBC driver query

[former_member183906]

hi,

PI 7.31 has to connect to Oracle 11.2.0.4.

Can you please let me know the exact driver name and details for this version and how to install it in PI 7.31

[former_member192343 · Accepted solution]

Hi

you need to deploy jdbc driver.

choose suitable here http://www.oracle.com/technetwork/database/enterprise-edition/jdbc-112010-090769.html

JDBC Driver installation procedure is described here http://help.sap.com/saphelp_nw73ehp1/helpdata/en/48/cafc972fbb5c97e10000000a42189d/frameset.htm

Regards, Mikhail

[former_member183906 · Accepted solution]

My PI 731 is having JDK16.

From the link shared by u , i see dis fits. Can I proceed with installing this JDBC driver for Oracle 11.2.0.4 ? Please confirm

ojdbc6.jar (2,739,616 bytes) - Classes for use with JDK 1.6. It contains the JDBC driver classes except classes for NLS support in Oracle Object and Collection types.

[Former Member · Accepted solution]

Hi,

we also had very bad exp for deploying the JDBC drivers in 7.4 PI  netweaver system. if you deploy through SUM and test your scenario, it will not work for you.

so just copy the JDK path with driver details in config tool and restart your PI system and test your JDBC interfaces it will work .

Regards,

krushi.

[Former Member · Accepted solution]

Hi

this is the below path we updated for SQL, you can replace with Oracle jar files and update in conf tool and take a system restart and test your interface it will work for you.

E:\usr\sap\SID\DVEBMGS00/j2ee/cluster/bin/boot/jaas.jar;

E:\usr\sap\SID\DVEBMGS00/j2ee/cluster/bin/system/sap.com~tc~bl~bytecode~library.jar;

E:\usr\sap\SID\DVEBMGS00/j2ee/cluster/bin/boot/memoryanalyzer.jar;

E:\usr\sap\SID\DVEBMGS00\j2ee\cluster\bin\ext\com.sap.aii.adapter.lib\lib\lib\mssqlserver.jar;

E:\usr\sap\SID\DVEBMGS00\j2ee\cluster\bin\ext\com.sap.aii.adapter.lib\lib\lib\msutil.jar;

E:\usr\sap\SID\DVEBMGS00\j2ee\cluster\bin\ext\com.sap.aii.adapter.lib\lib\lib\mysql.jar;

E:\usr\sap\SID\DVEBMGS00\j2ee\cluster\bin\ext\com.sap.aii.adapter.lib\lib\lib\msbase.jar;

com.microsoft.sqlserver.jdbc.SQLServerDrive

Regards,

krushi.

[former_member192343 · Accepted solution]

Yes, you can proceed with ojdbc6.jar

[former_member202642]

Hi,

Once you have deployed the jdbc driver. In ID part under the connection tab make following entries:

JDBC Driver: oracle.jdbc.driver.OracleDriver

Connection:  jdbc:oracle:thin:@[HOST][:PORT]:SID

along with valid Username and Password.

[iaki_vila]

Hi,

I hope these links helps:

An how-to:

Central note in SAP: 1878198 - Oracle: Add. Information - Software Update Manager 1.0 SP10

Regards.

[Former Member]

Hi mate,

       May this short guide can help you: http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/8000cffc-6b92-2d10-3493-f2ac13992...

[Former Member]

hi,

Just you need to update the driver oracle details in config -Admin tool and restart the system, it will work. no need to deploy the drivers through SUM.

Regards,

Krushi.