Results 1 to 12 of 12
  1. #1
    Join Date
    Dec 2011
    Posts
    6

    Unanswered: Oracle Installation

    I have installed Oracle 11G R2 for Microsoft Windows(x64)--Enterprise Edition on my laptop with Windows 7 Enterprise 64 bit Operating System

    I am having problems with the installation.

    This is how I installed it--

    Step 2--Create and Configure a Database
    Step 3--Desktop Class
    Step 4--Typical Installation
    Step 5--Prerequisite Checks
    Step 6--Summary
    Step 7--Install Product
    Step 8--Finish
    The Installation of Oracle Database was successful

    I am trying to install a financial software that will use this Oracle database.

    It asks me Database Properties

    I enter the following:

    Server Address--P7WZAC9
    Port--1521
    Oracle Version--Oracle 11G R2
    Oracle Home: C:\Oracle\product\11.2.0\dbhome_1
    TNS Alias--orcl
    Database Instance--orcl
    Schema Owner--DBO
    User: dbo
    Password--ababab

    It performs Verify Database properties

    It fails on Verify SQL tool OS bits compatilibility

    I get two error messages

    1) The SQL tool (SQLPLUS) used to connect to the database has not the correct bits compatibility (like 32 bits tool with a 64 bits distribution),Please install a correct version.

    2) Error cannot connect with JDBC.Oracle.Thin
    Error cannot connect with JDBC.Oracle.Thin@P7WZAC9.1521.orcl(user=dbo,password=ababab)


    How do I fix this?

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >I get two error messages
    ERROR? What Error? I don't see any error.
    Oracle error codes & messages look like below.
    Code:
    SQL> insert into friends values (1,1);
    insert into friends values (1,1)
    *
    ERROR at line 1:
    ORA-00001: unique constraint (USER1.PK_FRIENDS) violated
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Dec 2011
    Posts
    6
    The error messages are from the financial software in relation to the database

  4. #4
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    Change the line below "DriverManager.getConnection" to match your environment to
    independently verify network connectivity.

    Code:
    import java.sql.*;
    class Conn {
      public static void main (String[] args) throws Exception
      {
       Class.forName ("oracle.jdbc.OracleDriver");
    
       Connection conn = DriverManager.getConnection
         ("jdbc:oracle:thin:@//localhost:1521/orcl", "scott", "tiger");
                            // @//machineName:port/SID,   userid,  password
       try {
         Statement stmt = conn.createStatement();
         try {
           ResultSet rset = stmt.executeQuery("select BANNER from SYS.V_$VERSION");
           try {
             while (rset.next())
               System.out.println (rset.getString(1));   // Print col 1
           } 
           finally {
              try { rset.close(); } catch (Exception ignore) {}
           }
         } 
         finally {
           try { stmt.close(); } catch (Exception ignore) {}
         }
       } 
       finally {
         try { conn.close(); } catch (Exception ignore) {}
       }
      }
    }
    post COPY & PASTE proof of successful test using code template from above
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  5. #5
    Join Date
    Dec 2011
    Posts
    6
    Where do I do this--Change the line below "DriverManager.getConnection" to match your environment to
    independently verify network connectivity.

    In the command prompt?

  6. #6
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    Code:
    bcm@bcm-laptop:~$ cat Conn.java
    import java.sql.*;
    class Conn {
      public static void main (String[] args) throws Exception
      {
       Class.forName ("oracle.jdbc.OracleDriver");
    
       Connection conn = DriverManager.getConnection
         ("jdbc:oracle:thin:@//localhost:1521/v112", "scott", "tiger");
                            // @//machineName:port/SID,   userid,  password
       try {
         Statement stmt = conn.createStatement();
         try {
           ResultSet rset = stmt.executeQuery("select BANNER from SYS.V_$VERSION");
           try {
             while (rset.next())
               System.out.println (rset.getString(1));   // Print col 1
           } 
           finally {
              try { rset.close(); } catch (Exception ignore) {}
           }
         } 
         finally {
           try { stmt.close(); } catch (Exception ignore) {}
         }
       } 
       finally {
         try { conn.close(); } catch (Exception ignore) {}
       }
      }
    }
    bcm@bcm-laptop:~$ javac Conn.java
    bcm@bcm-laptop:~$ export CLASSPATH=/u01/app/oracle/product/11.2.0/dbhome_1/owb/wf/lib/ojdbc14.jar:.
    bcm@bcm-laptop:~$ java Conn
    Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
    PL/SQL Release 11.2.0.1.0 - Production
    CORE	11.2.0.1.0	Production
    TNS for Linux: Version 11.2.0.1.0 - Production
    NLSRTL Version 11.2.0.1.0 - Production
    bcm@bcm-laptop:~$
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  7. #7
    Join Date
    Dec 2011
    Posts
    6
    I do not understand your response.

  8. #8
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >I do not understand your response.

    what do you understand?
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  9. #9
    Join Date
    Dec 2011
    Posts
    6
    cat Conn.java--This is Unix Correct?

    I installed Oracle on Windows 7

  10. #10
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >I installed Oracle on Windows 7
    I showed Java source program file content, how to compile the source code & how run code.
    You can use stand alone Java code to validate JDBC connectivity to your Oracle DB.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  11. #11
    Join Date
    Dec 2011
    Posts
    6
    How do I do that

  12. #12
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >How do I do that
    do what I did.
    I showed all necessary actions
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •