To ： penitent(只取一瓢) : 这个oracle的BUG有针对工具的么？ 我同样的代码在JB5下运行就是可以的哦。
901的jdbc driver实际上是817的，有bugfact: 9iAS 1.0.2.2 fact: Portal 3.0.9.8.0 fact: Oracle JDBC Thin 8.1.7 symptom: Installing Portal on Oracle EE 9.0.1 symptom: Error in install.log file symptom: ORA-00600: internal error code, arguments: [ttcgcshnd-1], [0], [], [], [], [], [], [] symptom: Almost every database tasks fails cause: This Problem is caused due to <Bug:1725012> and happens when accessing Oracle 9.0.1 Database with JDBC 8.1.7.0.0. This bug is caused by the mismatch between the 9i server and the 8.1.7 Jdbc-Thin clients.<<Bug:1725012>> OERI:ttcgcshnd-1 using JDBC thin pre-9i to 9i databasefix:You have two alternatives to solve this issue:1. This is fixed in the JDBC Thin Driver bundled in Database patchset 8.1.7.2 or higher version. This patchset should be applied into the iAS Oracle Home NOT database Oracle Home.2. Upgrading the JDBC drivers into the iAS Oracle Home, following the steps in the note How to Install JDBC Drivers.References: How to Determine the JDBC Driver Version. .
This article contains information on how to install the following two types of JDBC drivers: - OCI - Thin The JDBC OCI driver, as the name suggests, is an OCI based driver. The JDBC OCI driver uses C entrypoints into the OCI library. The JDBC thin driver is entirely java based. This article is intended for DBAs or developers who need to install new versions of the JDBC drivers. Installing the JDBC OCI Driver ------------------------------ Before using the JDBC OCI driver, you must install an appropriate version of an Oracle client installation that includes SQL*Net, Required Support Files, and OCI. For example, if you wish to use the JDBC OCI 8.1.5 driver, then you must install an 8.1.5 Oracle client. If you wish to use JDBC on a machine that has an Oracle database installed, then you need not install an Oracle client. For a UNIX Installation: Copy the .so file for the driver onto your machine into your ORACLE_HOME/lib directory. Ensure that this directory is in your LD_LIBRARY_PATH environment variable. For a Windows NT Installation: Copy the .dll file for the driver onto your machine into your ORACLE_HOME\bin directory. Ensure that this directory is in your PATH environment variable. Installing the JDBC Thin Driver ------------------------------- An Oracle client installation is not required for use of the JDBC thin driver on the machine where the application or applet runs. The JDBC thin driver requires a TCP/IP listener be up and running on the database machine. The OCI driver requires any listener, not specifically a TCP/IP listener, to be up and running on the database machine. Setting Environment Variables ----------------------------- For both OCI and thin JDBC drivers, copy the classesxxx.zip onto your machine. This file contains the java classes for the JDBC drivers and is named according to the JDK version that it works with. For example, classes111.zip is for use with the JDK 1.1.x. Caution: Do NOT unzip the CLASSESXXX.ZIP FILE. If you have an Oracle install (client or database), they can be copied into your ORACLE_HOME/jdbc/lib directory. If not, then copy to some directory on your machine. Add the directory, along with the name of the classesxxx.zip file, to your CLASSPATH environment variable. For example, if you copied the classes111.zip file into your ORACLE_HOME/jdbc/lib directory, then you must add ORACLE_HOME/jdbc/lib/classes111.zip to your CLASSPATH environment variable. Add *ONLY ONE* of the zip files in the CLASSPATH. If you are using JDBC OCI, ensure that you have ORACLE_HOME/lib/ in your LD_LIBRARY_PATH environment variable. On Windows NT, ensure that ORACLE_HOME\bin is in the PATH environment variable. Make sure that you have the appropriate .so or .dll JDBC OCI file in the directory. Testing the JDBC OCI driver --------------------------- - Use samples from ORACLE_HOME/JDBC/samples directory. Or, in the case of Oracle 8.1.5, JDBC samples can be found in the demo.zip or demo.tar file located in the ORACLE_HOME/JDBC/demo directory. For example: * In samples/oci7: jdbcCheckup.java * Compile with : javac JdbcCheckup.java * Run with : java JdbcCheckup Note: In order to successfully compile and run the JdbcCheckup application, you must have a JDK installed for java. You also need to add the JDK zip file(s) to your CLASSPATH environment variable. You can obtain a copy of the JDK from the following web sites: For the latest JDK 1.1.x: http://www.java.sun.com/products/jdk/1.1 For the latest JDK 1.2.x: http://www.java.sun.com/products/jdk/1.2 The output of the program appears as follows like when it is successful: Please enter information to test connection to the database user: scott password: tiger database (a TNSNAME entry): <a tnsname entry here> Connecting to the database...Connecting... connected. Hello World Your JDBC installation is correct. Testing JDBC Thin driver ------------------------ - Use samples from ORACLE_HOME/JDBC/samples directory. Or, in the case of Oracle 8.1.5, JDBC samples can be found in the demo.zip or demo.tar file located in the ORACLE_HOME/JDBC/demo directory. For example: * In samples/thin: Employee.java * Edit connect string to reflect user database Connection conn= DriverManager.getConnection ("jdbc:oracle:thin:@dlsun511:1521:dbms733","scott","tiger"); | | | machine(ip@) : port# : sid * Compile with : javac Employee.java * Run with : java Employee * It prints the ENAME column of the EMP table References ---------- For more information on JDBC client installation, refer to the "JDBC Developer's Guide and Reference", (A64685-01), Chapter 2 Getting Started, Verifying a JDBC Client Installation Section. For instructions on how to install JDBC drivers using the 8.0.x Oracle installer, refer to the "Oracle8 JDBC Drivers", (A58237-01), Getting Started section. Do not use these Oracle installer directions on an 8.1.5 database. Oracle JDBC Drivers can be downloaded from the following web site: http://technet.oracle.com/software/download.htm .
Subject: Example: How to Determine the JDBC Driver Version Type: BULLETIN Status: PUBLISHED Content Type: TEXT/PLAIN Creation Date: 11-AUG-1999 Last Revision Date: 27-NOV-2001 Overview -------- This article provides a simple piece of Java code that can be used to determine the JDBC Driver Versions being used. It invokes the getDriverVersion() method of the OracleDatabaseMetaData class and is intended for JAVA developers and technical support analysts. Note that you must modify the JDBC connect string in the method call to DriverManager.getConnection() with information for your database environment. References ---------- "JDBC Developers Guide and Reference", (A64685-01), Chapter 2 'Getting Started', Section 'Verifying a JDBC Client Installation, Determining the Version of the JDBC Driver' For JDBC connection information, refer to the "JDBC Developer's Guide and Reference", (A64685-01), Chapter 3 'Basic Features', Section 'Opening a Connection to a Database' Note:60822.1 JDBC Frequently Asked Questions Program ------- import java.sql.*; import oracle.jdbc.driver.*; class JDBCVersion { public static void main (String args []) throws SQLException { // Load the Oracle JDBC driver DriverManager.registerDriver (new oracle.jdbc.driver.OracleDriver()); // Change the following code line to reflect a valid connection to your // server Connection conn = DriverManager.getConnection ("jdbc:oracle:thin:@<your db host>:<your db port>:<your db SID>","scott","tiger"); // Create Oracle DatabaseMetaData object DatabaseMetaData meta = conn.getMetaData (); // gets driver info: System.out.println("\n=============\nDatabase Product Name is ... " + meta.getDatabaseProductName()); System.out.println("\nDatabase Product Version is " + meta.getDatabaseProductVersion()); System.out.println("\n=============\nJDBC Driver Name is ........ " + meta.getDriverName()); System.out.println("\nJDBC Driver Version is ..... " + meta.getDriverVersion()); System.out.println("\nJDBC Driver Major Version is " + meta.getDriverMajorVersion()); System.out.println("\nJDBC Driver Minor Version is " + meta.getDriverMinorVersion()); System.out.println("\n============="); } } Sample Output ------------- ============= Database Product Name is ... Oracle Database Product Version is Oracle8i Enterprise Edition Release 8.1.5.0.0 - Production With the Partitioning and Java options PL/SQL Release 8.1.5.0.0 - Production ============= JDBC Driver Name is ..... Oracle JDBC driver JDBC Driver Version is 7.3.4.0.2 JDBC Driver Major Version is 7 JDBC Driver Minor Version is 3 =============
可以大概说说么？？我是在Java里调用的，原来是在JB5里写的，完全可以运行的。现在把代码copy到JB7里，就出这个错了。。
请你大概说说可能的原因可以么？谢谢
一个bug??那应该怎么补救？？？
那是oracle的bug。oracle自己都不知道什么情况下出这个错误，
需要你的返回值才能定位。
如果bug已修正，就会有patch
如果没有修正，谁也没有办法
这个oracle的BUG有针对工具的么？
我同样的代码在JB5下运行就是可以的哦。
fact: Portal 3.0.9.8.0
fact: Oracle JDBC Thin 8.1.7
symptom: Installing Portal on Oracle EE 9.0.1
symptom: Error in install.log file
symptom: ORA-00600: internal error code, arguments: [ttcgcshnd-1], [0], [],
[], [], [], [], []
symptom: Almost every database tasks fails
cause: This Problem is caused due to <Bug:1725012> and happens when accessing
Oracle 9.0.1 Database with JDBC 8.1.7.0.0. This bug is caused by the mismatch
between the
9i server and the 8.1.7 Jdbc-Thin clients.<<Bug:1725012>>
OERI:ttcgcshnd-1 using JDBC thin pre-9i to 9i databasefix:You have two alternatives to solve this issue:1. This is fixed in the JDBC Thin Driver bundled in Database patchset 8.1.7.2
or higher version. This patchset should be applied into the iAS Oracle Home NOT
database Oracle Home.2. Upgrading the JDBC drivers into the iAS Oracle Home, following the steps in
the note How to Install JDBC Drivers.References:
How
to Determine the JDBC Driver Version.
.
.
Type: BULLETIN
Status: PUBLISHED
Content Type: TEXT/PLAIN
Creation Date: 11-AUG-1999
Last Revision Date: 27-NOV-2001
Overview -------- This article provides a simple piece of Java code that can be used to determine the JDBC Driver Versions being used. It invokes the getDriverVersion() method of the OracleDatabaseMetaData class and is intended for JAVA developers and technical support analysts. Note that you must modify the JDBC connect string in the method call to DriverManager.getConnection() with information for your database environment. References ---------- "JDBC Developers Guide and Reference", (A64685-01), Chapter 2 'Getting Started', Section 'Verifying a JDBC Client Installation, Determining the Version of the JDBC Driver' For JDBC connection information, refer to the "JDBC Developer's Guide and Reference", (A64685-01), Chapter 3 'Basic Features', Section 'Opening a Connection to a Database' Note:60822.1 JDBC Frequently Asked Questions Program ------- import java.sql.*; import oracle.jdbc.driver.*; class JDBCVersion { public static void main (String args []) throws SQLException { // Load the Oracle JDBC driver DriverManager.registerDriver (new oracle.jdbc.driver.OracleDriver()); // Change the following code line to reflect a valid connection to your // server Connection conn = DriverManager.getConnection ("jdbc:oracle:thin:@<your db host>:<your db port>:<your db SID>","scott","tiger"); // Create Oracle DatabaseMetaData object DatabaseMetaData meta = conn.getMetaData (); // gets driver info: System.out.println("\n=============\nDatabase Product Name is ... " + meta.getDatabaseProductName()); System.out.println("\nDatabase Product Version is " + meta.getDatabaseProductVersion()); System.out.println("\n=============\nJDBC Driver Name is ........ " + meta.getDriverName()); System.out.println("\nJDBC Driver Version is ..... " + meta.getDriverVersion()); System.out.println("\nJDBC Driver Major Version is " + meta.getDriverMajorVersion()); System.out.println("\nJDBC Driver Minor Version is " + meta.getDriverMinorVersion()); System.out.println("\n============="); } } Sample Output ------------- ============= Database Product Name is ... Oracle Database Product Version is Oracle8i Enterprise Edition Release 8.1.5.0.0 - Production With the Partitioning and Java options PL/SQL Release 8.1.5.0.0 - Production ============= JDBC Driver Name is ..... Oracle JDBC driver JDBC Driver Version is 7.3.4.0.2 JDBC Driver Major Version is 7 JDBC Driver Minor Version is 3 =============