Williams225
asked on
Need to determine the version of an Oracle JDBC driver
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\li b
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
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\
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Something like this should do:
findstr /M /C:OracleDriver.class /D:<Cognos Installation Location>\c8\webapps\p2pd\ WEB-INF\li b *.jar
You can use /S option to search subdirectories.
findstr /M /C:OracleDriver.class /D:<Cognos Installation Location>\c8\webapps\p2pd\
You can use /S option to search subdirectories.
ASKER
not working, i am using solaris
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER