Solved

Need to determine the version of an Oracle JDBC driver

Posted on 2011-09-05
5
893 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 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

Master Your Team's Linux and Cloud Stack

Come see why top tech companies like Mailchimp and Media Temple use Linux Academy to build their employee training programs.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Rate limit for DNS queries 7 75
how to trim oracle sql sentence in unix 17 53
oracle- set role and grant privileges 6 28
Help on model clause 5 32
Cursors in Oracle: A cursor is used to process individual rows returned by database system for a query. In oracle every SQL statement executed by the oracle server has a private area. This area contains information about the SQL statement and the…
Why Shell Scripting? Shell scripting is a powerful method of accessing UNIX systems and it is very flexible. Shell scripts are required when we want to execute a sequence of commands in Unix flavored operating systems. “Shell” is the command line i…
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.
This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.

777 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