Oracle Installation

ordbas11 · #1 (**permalink**) 12-03-11, 21:56

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?

anacedent · #2 (**permalink**) 12-03-11, 22:14

>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

ordbas11 · #3 (**permalink**) 12-04-11, 12:54

The error messages are from the financial software in relation to the database

anacedent · #4 (**permalink**) 12-04-11, 13:04

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

ordbas11 · #5 (**permalink**) 12-04-11, 13:30

Where do I do this--Change the line below "DriverManager.getConnection" to match your environment to
independently verify network connectivity.

In the command prompt?

anacedent · #6 (**permalink**) 12-04-11, 14:25

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:~$

ordbas11 · #7 (**permalink**) 12-04-11, 15:13

I do not understand your response.

anacedent · #8 (**permalink**) 12-04-11, 16:16

>I do not understand your response.

what do you understand?

ordbas11 · #9 (**permalink**) 12-04-11, 16:39

cat Conn.java--This is Unix Correct?

I installed Oracle on Windows 7

anacedent · #10 (**permalink**) 12-04-11, 16:46

>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.

ordbas11 · #11 (**permalink**) 12-04-11, 17:40

How do I do that

anacedent · #12 (**permalink**) 12-04-11, 17:45

>How do I do that
do what I did.
I showed all necessary actions

Internet Services

Web Development

Digital Marketing

Consumer Tech