HOW TO UPGRADE ORACLE JDBC DRIVERS ON SOLARIS 10

I need to install  Oracle Database 10g Release 2 (10.2.0.5) JDBC Drivers

ojdbc14.jar

http://www.oracle.com/technetwork/database/enterprise-edition/jdbc-10201-088211.html


please helpppppppppppppppp

I don't even know which command to type

java -jar ojdbc14.jar.  

please give me another procedure

What is your error message when you run that?  You may not have 'java' in your PATH variable or may not have java even installed on your machine. That means you would first have to download and install java.  Make sure the directory with java is in your PATH and that your CLASSPATH variable is properly set.

here is the error that I get

bash-3.00$ ls
local.cshrc    local.login    local.profile  ojdbc14.jar
bash-3.00$ java -jar ojdbc14.jar 
Failed to load Main-Class manifest attribute from
ojdbc14.jar

Select allOpen in new window

You probably need to set your CLASSPATH variable to include the directory where ojdbc14.jar is located

do you know how?

It's an upgrade. an old version of ojdbc is installed already. How can i find the classpath? where do I have to execute this driver?

Where do you need to upgrade the driver?
Do you have Java application which connects to  oracle?
Is it a web applicaction or normal (non-web) appliaction?

You need to replace tthe older driver in the classpath with ojdbc.jar
How you would do it depends on what kind of application are you upgrading.
Please, provide these details and we'll figure out how to do it.  

>on a  production server  (solaris 10)

What kind of java application serevr are you riuning kon Solaris - it it Tomcat, Weblogic ?

@for yan :how can i find exactly which appplication server do  i have, and what are the different types?

I need to upgrade the driver on a server with solaris 10 . The upgrade is for oracle database. how do i find the classpath?

What are the results of the following command in your ORACLE_HOME?
>cd $ORACLE_HOME
>find . -name '*jdb*jar'

in case there is an old ojdbc  jar file in ORACLE_HOME/owb/wf/lib/ , will i have to delete the old one to upgrade?

I would just copy it under a new name like ojdbc14.jar_bak.  I never delete files if I don't have to. It makes for a really quick recovery if things go horribly wrong.  I would perform this in each directory where/if ojdbc14.jar exists, because in my old Oracle Homes I didn't do anything special to put ojdbc14.jar in any of the directories and they are in three different places. That means by default Oracle software must be looking for that jar file in each one of those locations.

you should try to uinderstand why you need to upgrade the driver and only then you can know how to do it. I can hardly imagine the situation where you want to replace jdbc driver inside ORACLE_HOME. Thios is usually internal Oracle business and when you upgrade Oracle to new version it will be upgraded if necessary. On the contrary if you are runing Java application server or servleet engine like say tomcat, that is quite understandable situation when you want to replace old oracle driver (say file classes12.zip) with the ojdbc14.jar (by the way, I believe this one seems to me not to be the latest).
In java app server you would normally need to replace the previos jar in some lib folder within the home of application server. If you find out what applicatioin server you are running on your machoine we can find the place where to put it.
Jdbc driver is in fact a piece of the code whoch java clients use to access oracle server. Older drivers may not allow to connect to newer oraclke server(s) which may or may not be sitting on the same hosat where you run the client - usually theey are different hoists). In suc situation you'll need ti uppgrade jdbc driver which is used by the client (and the client of Oracle database may be either stand alone java applicatioin or java sevlet engine which can run many servlest and they all usually go throiugh jdbc driver installed with this java servlet engine). The bottomline is you need to understand for what kind of java client you are upgrading the driver.

This is for an Oracle 10.2.0.5 database not an application server, and if he got it from the http://www.oracle.com/technetwork/database/enterprise-edition/jdbc-10201-088211.html it is the latest.  There should be no problems with this upgrade. It looks like a standalone process, and should be ok.  

They are the latest drivers for his database 10.2.0.5 patch set if you look at the begining of this thread. His boss did not ask him to move the Oracle Home to 11g just to upgrade the jdbc drivers in the 10.2.0.5 Oracle Database Home.wistiles. The database comes with a full set of JDBC drivers there is an actual OHS version of the Apache server in every database Oracle Home also.  These are on the Oracle Home database for a reason. They could be using the database software just for its OHS, so they don't have to pay for the expensive application server licenses just as we do at our shop.  Then the middle teir comes with the Oracle Database software. If your shop only uses mod_plsql you don't need all the other expensive bells and   He is not using 11g, so he doesn't need those drivers. I already told him how to back it up, and how to get jdbc into the right directory.  They are just java class files.  It's not some big install.

@achelstorm

please check the result of the output, how can i know that the upgrade is a success?

$ cd $ORACLE_HOME
$ ls
META-INF       local.cshrc    local.login    local.profile  ojdbc14.jar    oracle

Select allOpen in new window

$ cd ORACLE_HOME/owb/wf/lib/ 
ORACLE_HOME/owb/wf/lib/: does not exist

Select allOpen in new window

$ find . -name '*jdb*jar'
./ojdbc14.jar

Select allOpen in new window

Can I assume thet the ojdbc14.jar that is in your Oracle Home is one you put there?  Your Oracle Home does not appear to be set up for the application server.  Are you using this Oracle Home for delivering your application? You do need to put it on your application server which in all likelyhood is on another machine.  I would find out what machine that is and then find out what version of middleware it has on it just as  for_yan recommended.  Then let me know what that application server is.