[Webinar] Streamline your web hosting managementRegister Today

x
?
Solved

Need to determine the version of an Oracle JDBC driver

Posted on 2011-09-05
5
Medium Priority
?
931 Views
Last Modified: 2012-05-12
Hello I need to find the version of an oracle jdbc driver.

I have used the method bellow , but i can't find it please help!!



•      Problem
How to determine the version of an Oracle JDBC driver?

Solution
Steps:
1.  Locate the classes12.jar file being used. This is located in: <Cognos Installation Location>\c8\webapps\p2pd\WEB-INF\lib
2.  Make a copy of the classes12.jar file.
3.  Rename the classes12.jar to classes12.zip
4.  Use Winzip or some other file compression tool, extract the content of the classes12.zip to a temporary location.
5.  In the temporary location, locate the file called MANIFEST.MF
6.  Open the MANIFEST.MF file with notepad
7.  Look for the line Specification-Version: "Oracle JDBC Driver version - 9.0.2.0.8" indicates that the version of this JDBC classes12 driver is 9.0.2.0.8.

This Oracle JDBC Driver version, must be exactly same as the version of the Oracle database server were you want to create a metric or content store. Ask the Oracle DBA how to obtain the correct JDBC version is necessary.

•      Check in the crontab for DB BACKU SCHEDULE
0
Comment
Question by:cismoney
  • 3
  • 2
5 Comments
 
LVL 5

Accepted Solution

by:
DerZauberer earned 2000 total points
ID: 36483730
The *.jar for the Oracle driver can have different names, e.g. ojdbc14.jar, ojdbc5.jar or ojdbc6.jar.
Well it should always be a *.jar file that contains a zipped file named "OracleDriver.class", so maybe you can search for a *.jar with "OracleDriver.class" in it.
0
 

Author Comment

by:cismoney
ID: 36483789
ok thanx, what is the command to locate it?
0
 
LVL 5

Expert Comment

by:DerZauberer
ID: 36484067
Something like this should do:

findstr /M /C:OracleDriver.class /D:<Cognos Installation Location>\c8\webapps\p2pd\WEB-INF\lib *.jar

You can use /S option to search subdirectories.
0
 

Author Comment

by:cismoney
ID: 36484110
not working, i am using solaris
0
 
LVL 5

Assisted Solution

by:DerZauberer
DerZauberer earned 2000 total points
ID: 36484154
Ah i only saw the backslashes and thougt you are on windows box.
Ehm you have winzip on solaris box? ^^

cd <Cognos Installation Location>\c8\webapps\p2pd\WEB-INF\lib
grep -rl "OracleDriver.class" *.jar
0

Featured Post

Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
In the first part of this tutorial we will cover the prerequisites for installing SQL Server vNext on Linux.
This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.
This video shows how to recover a database from a user managed backup
Suggested Courses
Course of the Month7 days, 14 hours left to enroll

607 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question