Oracle Database Client on Windows

Background

In the last couple of posts we touched on installing Oracle XE to avail a small footprint Oracle DB Server.

Later we used SQLPlus to validate connectivity and add a new ‘regular‘ user.

 

Lineage

  1. “Oracle Database 11g Express Edition” – Installation on Windows
    Link
  2. Oracle – SQLPlus – Create new User
    Link

Download Area

The current version of the Oracle Database Engine Client is Oracle Database 11g Release 2 (11.2.0.1.0).

It is available for download here.

Which App

We will be using the Oracle Client DB Connectivity layer on MS Windows x64 bit.

Unfortunately, the client tool is Microsoft’s Business Intelligence Development and that client is 32 bit, we will have to take the Oracle 32-bit Client.

Here it is….

Size wise It is 700 MB.

Install

Select Installation Type

Image

Details

  1. InstantClient ( 174 MB )

 

Specify Installation Location ( Step 2 )

Image

Before

After

Details

  1. Changed from user specific folder to generic folder

Perform Prerequisite Checks ( Step 3 )

Image

Before

After

Details

  1. Path
    • Path’s Length
      • Value
        • Expected Value :- 1023
        • Actual Value :- 1239
      • Oracle will like for the path length to be less than 1024
      • Chose to Ignore

 

Summary ( Step 4 )

Image

Details

  1. Global Settings
    • Disk Space :-  174 MB
    • Install Type :- Instant Client
    • Oracle Home Location :- D:\app\oracle\product\11.2.0\client_1
  2. Inventory Information
    • Inventory Location :-  C:\Program Files (x86)\Oracle\Inventory

 

Install Product ( Step 5 )

Image

Validation

tnsping

Let us tnsping to see if we can connect to our locally installed Oracle XE ( Oracle Express Engine ).

Command


tnsping XE

Output

tnsnames.ora

Please review and modify tnsnames.ora to add new & modify existing alias.

Commendation

Please review Tyler Chessman very generous write-up for a good, solid, write-up on connectivity installation & configuration between SQL Server and Oracle.

 

References

  1. Tyler Chessman
    • Connecting to an Oracle Database from SQL Server and Microsoft BI Tools
      Avoid common pitfalls
      Published On :- 2014-May-14th
      Link

Oracle – 11 G/R2 Client – Install – Error moving orandce11.dll.dbl

Tried installing Oracle 11G/R2, but failing saying that it could not move orandce11.dbl.dll:


INFO: moving 'E:\app\oracle\x32\product\11.2.0\client_1\bin\orandce11.dll.dbl' to 'E:\app\oracle\x32\product\11.2.0\client_1\bin\orandce11.dll' 

INFO: moving 'E:\app\oracle\x32\product\11.2.0\client_1\bin\orandce11.dll.dbl' to 'E:\app\oracle\x32\product\11.2.0\client_1\bin\orandce11.dll' 

INFO: Exception thrown from action: moveFile 

Exception Name: FileNotFoundException Exception String: File not found E:\app\oracle\x32\product\11.2.0\client_1\bin\orandce11.dll.dbl Exception Severity: 2 

INFO: Exception handling set to prompt user with options to Retry Ignore User Choice: Retry 

INFO: moving 'E:\app\oracle\x32\product\11.2.0\client_1\bin\orandce11.dll.dbl' to 'E:\app\oracle\x32\product\11.2.0\client_1\bin\orandce11.dll' 

INFO: moving 'E:\app\oracle\x32\product\11.2.0\client_1\bin\orandce11.dll.dbl' to 'E:\app\oracle\x32\product\11.2.0\client_1\bin\orandce11.dll' 

INFO: Exception thrown from action: moveFile Exception Name: FileNotFoundException Exception String: File not found E:\app\oracle\x32\product\11.2.0\client_1\bin\orandce11.dll.dbl Exception Severity: 2  

Please ignore the error\warning and proceed with installation.

Oracle – 11G – Client – SQL Developer (64-bit) – Error – WARNING: Could not find jvm.cfg!

Introduction

When the SQL Developer that is bundled with 64-bit Oracle 11G Client is launched, one is prompted for the location of java.exe.

As the SQL Developer is running on a 64-bit system, the more natural choice is to go with 64-bit Java run-time.

Doing so will be a mistake and if one would have done so, one would be greeted with this error message.

Text

WARNING: Could not find jvm.cfg! in 'E:\Program Files\Java\jdk1.6.0_26\jre\lib\jvm.cfg'
WARNING: Cannot find default VM "client" at E:\Program Files\Java\jdk1.6.0_26
ERROR: Cannot find VM at: E:\Program Files\Java\jdk1.6.0_26
Aborting!

Image

Correction

To correct:

  1. Identify the folder where the sqldeveloper is located
  2. In our case the folder is E:\app\oracle\x64\product\11.2.0\client_1\SQLDEVELOPER\SQLDEVELOPER\BIN
  3. Open the sqldeveloper.conf in a text editor
  4. Comment out the SetJavaHome that references the 64-bit Java.exe
    E:\Program Files and add a new line that references the 32-bit E:\Program Files (x86)

    #SetJavaHome E:\Program Files\Java\jdk1.6.0_26
    SetJavaHome E:\Program Files (x86)\Java\jdk1.6.0_26
    
  5. Save the edited file
  6. Relaunch SQL Developer

Credit

Crediting 561237.   He referenced the solution in a response he gave on the “OTN Community”.

 

Addendum

2016-08-30

Posted about changes post SQL Developer v4 here

 

References 

  1. SQLDeveloper 1.5.1 won’t recognise JDK.
    http://kr.forums.oracle.com/forums/thread.jspa?threadID=672963&tstart=13