Solved

Need to determine the version of an Oracle JDBC driver

Posted on 2011-09-05
5
900 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
5 Comments
 
LVL 5

Accepted Solution

by:
DerZauberer earned 500 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 500 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

Get 15 Days FREE Full-Featured Trial

Benefit from a mission critical IT monitoring with Monitis Premium or get it FREE for your entry level monitoring needs.
-Over 200,000 users
-More than 300,000 websites monitored
-Used in 197 countries
-Recommended by 98% of users

Question has a verified solution.

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

Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
Shell script to create broker configuration file using current broker Configuration, solely for purpose of backup on Linux. Script may need to be modified depending on OS-installation. Please deploy and verify the script in a test environment.
Via a live example, show how to take different types of Oracle backups using RMAN.
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.

726 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