This discussion is archived
0 Replies Latest reply: Dec 19, 2013 12:00 PM by YoungDBA RSS

Error Connecting to database URL jdbc:oracle:oci:@rmsdbtst as user rms13 java.lang.Exception:UnsatisfiedLinkError encountered when using the Oracle driver

YoungDBA Newbie
Currently Being Moderated

Trying to Install RMS application 13.2.2 and I get past the pre-installation checks and when I get to the Data Source details and enter the data source details with the check box checked to validate the schema/Test Data Source I get the following error:

Error Connecting to database URL jdbc:oracle:oci:@rmsdbtst as user rms13 java.lang.Exception:UnsatisfiedLinkError encountered when using the Oracle driver. Please check that the library path is set up properly or switch to the JDBC thin client oracle/jdbc/driver/T2CConnection.getLibraryVersioNumber()


Checks performed:

RMS Application code location and directory contents:

[oracle@test-rms-app application]$ pwd

/binary_files/STAGING_DIR/rms/application

[oracle@test-rms-app application]$ ls -ltr

total 144

-rw-r--r-- 1 oracle oinstall   272 Dec 7  2010 version.properties

-rw-r--r-- 1 oracle oinstall   405 Jan 16 2011 expected-object-counts.properties

-rw-r--r-- 1 oracle oinstall   892 May 13 2011 ant.install.properties.sample

-rw-r--r-- 1 oracle oinstall 64004 Jun  6  2011 build.xml

drwxr-xr-x 9 oracle oinstall  4096 Jun 16 2011 rms13

drwxr-xr-x 3 oracle oinstall  4096 Jun 16 2011 installer-resources

drwxr-xr-x 3 oracle oinstall  4096 Jun 16 2011 antinstall

drwxr-xr-x 2 oracle oinstall  4096 Jun 16 2011 ant-ext

drwxr-xr-x 5 oracle oinstall  4096 Jun 16 2011 ant

-rw-r--r-- 1 oracle oinstall 11324 Dec 18 09:18 antinstall-config.xml.ORIG

-rwxr-xr-x 1 oracle oinstall  4249 Dec 18 10:01 install.sh

drwxr-xr-x 4 oracle oinstall  4096 Dec 18 10:06 common

-rw-r--r-- 1 oracle oinstall 16244 Dec 19 10:37 antinstall-config.xml

-rw-r--r-- 1 oracle oinstall   689 Dec 19 10:37 ant.install.log

[oracle@test-rms-app application]$

 

Application installation:

[oracle@test-rms-app application]$ ./install.sh

THIS IS the driver directory

.

Verified $ORACLE_SID.

Verified SQL*Plus exists.

Verified write permissions.

Verified formsweb.cfg read permissions.

Verified Registry.dat read permissions.

Verified Java version 1.4.2.x or greater. Java version - 1.6.0

Verified Tk2Motif.rgb settings.

Verified frmcmp_batch.sh status.

WARNING: Oracle Enterprise Linux not detected.  Some components may not install properly.

Verified $DISPLAY - 172.16.129.82:0.0.

This installer will ask for your "My Oracle Support" credentials.

Preparing installer. This may take a few moments.

Your internet connection type is: NONE

Integrating My Oracle Support into the product installer workflow...

     [move] Moving 1 file to /binary_files/STAGING_DIR/rms/application

Installer preparation complete.

 

MW_HOME=/u01/app/oracle/Middleware/NewMiddleware1034

ORACLE_HOME=/u01/app/oracle/Middleware/NewMiddleware1034/as_1

ORACLE_INSTANCE=/u01/app/oracle/Middleware/NewMiddleware1034/asinst_1

DOMAIN_HOME=/u01/app/oracle/Middleware/NewMiddleware1034/user_projects/domains/rmsClassDomain

WLS_INSTANCE=WLS_FORMS

ORACLE_SID=rmsdbtst

JAVA_HOME=/u01/app/oracle/jrockit-jdk1.6.0_45-R28.2.7-4.1.0

 

Launching installer...

 

To make sure I have connectivity from the app server to the database (on a database server) here are the steps followed:

[oracle@test-rms-app application]$ tnsping rmsdbtst

 

TNS Ping Utility for Linux: Version 11.1.0.7.0 - Production on 19-DEC-2013 10:41:40

 

Copyright (c) 1997, 2008, Oracle.  All rights reserved.

Used parameter files:

 

 

Used TNSNAMES adapter to resolve the alias

Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = test-rms-db.vonmaur.vmc)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SID = rmsdbtst)))

OK (0 msec)

[oracle@test-rms-app application]$

 

[oracle@test-rms-app application]$ sqlplus rms13@rmsdbtst

 

SQL*Plus: Release 11.1.0.7.0 - Production on Thu Dec 19 10:46:18 2013

 

Copyright (c) 1982, 2008, Oracle.  All rights reserved.

 

Enter password:

 

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

 

SQL> exit

Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

[oracle@test-rms-app application]$

 

 

 

[oracle@test-rms-app application]$ ping test-rms-db

PING test-rms-db.vonmaur.vmc (192.168.1.140) 56(84) bytes of data.

64 bytes from test-rms-db.vonmaur.vmc (192.168.1.140): icmp_seq=1 ttl=64 time=0.599 ms

64 bytes from test-rms-db.vonmaur.vmc (192.168.1.140): icmp_seq=2 ttl=64 time=0.168 ms

64 bytes from test-rms-db.vonmaur.vmc (192.168.1.140): icmp_seq=3 ttl=64 time=0.132 ms

64 bytes from test-rms-db.vonmaur.vmc (192.168.1.140): icmp_seq=4 ttl=64 time=0.158 ms

64 bytes from test-rms-db.vonmaur.vmc (192.168.1.140): icmp_seq=5 ttl=64 time=0.135 ms

 

--- test-rms-db.vonmaur.vmc ping statistics ---

5 packets transmitted, 5 received, 0% packet loss, time 4001ms

rtt min/avg/max/mdev = 0.132/0.238/0.599/0.181 ms

[oracle@test-rms-app application]$

 

 

[oracle@test-rms-app application]$ uname -a

Linux test-rms-app.vonmaur.vmc 2.6.18-128.el5 #1 SMP Wed Jan 21 08:45:05 EST 2009 x86_64 x86_64 x86_64 GNU/Linux

[oracle@test-rms-app application]$

 

[oracle@test-rms-app application]$ cat /etc/*-release

Enterprise Linux Enterprise Linux Server release 5.3 (Carthage)

Red Hat Enterprise Linux Server release 5.3 (Tikanga)

[oracle@test-rms-app application]$

 

 

The database is created and all the batch file scripts have been successfully deployed.  Now working on the application server.  The  Weblogic server is installed and 11g forms and reports are installed successfully.

 

Any help would be helpful.

 

Thanks,
Ram.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points