Steps to configure the JDBC connection under the conditions of the Solaris operating system installed in the WAS and Oracle clients:
1. Make the .profile file of the root user, add the root user to launch the environment variable of the Oracle program. The contents need to be added as follows:
Set Oracle_Home = / OPT / ORACLE,
Setting ld_library_path to add a path: ld_library_path = $ ld_library_path: / opt / oracle / lib32 (ensuring lib32 of the OCI driver and 32-bit Oracle library), because Oracle9i is a 64-bit system, and WAS and JDK are now only support 32-bit procedures, so we need to modify the default startup of Oracle, set to 32-bit lib.
Set Oracle_Base = / OPT / Oracle / BIN,
Create the following Oracle Curde Ruan Connections from the / usr / lib directory:
For Oracle9i: Link to: LibWTC9.SO, LibClntsh.SO.9.0 and Libocijdbc9.so
The configuration here See the contents of the .profile file under the operating system using Oracle.
2. Modify the .profile file After restarting the system to generate the system to make the modified environment variable. Use the root user login system, execute the command line program: SQLPlus epstar / epstar @ URPDB (modify according to different databases and password) Test modification Whether the environment variable takes effect. If you can log in to the database normally, the configuration of the environment has been successful.
3. Start the WAS management console and enter the configure interface of the WAS.
Enter the environment -> Manage WebSphere environment variables to modify the environment variables of Oracle, modify the key value:
OACLE_JDBC_DRIVER_PATH = / OPT / Oracle / JDBC / LIB
As shown below:
4. Set up JDBC, set up a new Oracle JDBC Driver in Resources -> JDBC
As shown below:
5. Enter: JDBC: Oracle: OCI: @epstar as shown below: @epstar as shown below:
6. Other configurations see WAS configuration documents, which will not be described in detail here. 7. Copy the /opt/oracle/jdbc/lib/classes12.zip to the / OPT / WebSphere / AppServer / lib / ext / directory, please do not remember not to put the / opt / oracle / jdbc / libaraba The files are copied together to the / OPT / WebSphere / AppServer / lib / ext / directory to prevent confusing access to the database when using the launcher. 8. Need to indicate that the JDBC in the cluster is needed to note that you need to select a scope (unit, node, server) when you create JDBC, we choose nodes: you need to choose the Jhong (machine name) node, not JhhongManager (Server for clustering). The system default creation environment is in the JhongManager environment, you need to make changes, the same when setting the environment, you need to make a selection node when setting the WebSphere environment variable, where the default node is also a node environment like JhongManager.
