Pl Sql Developer Oracle Client Not Properly Installed Oracle Home Key

Posted on by admin

Pl Sql Developer Oracle Client Not Properly Installed Oracle Home Key

Installing SQL Developer for Remote Access to Oracle 12g
(Fall 2020 configuration)

Sql

Oct 12, 2007 From an Oracle 10.x Fat client installation, copy tnsus.msb into c: oracle instantclient network mesg. This is the file that tnsping uses to 'lookup' the message text while running. At this point, you should be able to fire up PL/SQL Dev and still have things work. Okay, now the weird part starts. 1.2.1 Windows Systems with JDK1.5. To install and start SQL Developer on a Windows system on which the Sun Java SDK release 1.5 is installed, follow these steps: Unzip the SQL Developer kit into a folder (directory) of your choice (for example, C:Program Files).This folder will be referred to as install. Unzipping the SQL Developer kit causes a folder named sqldeveloper to be. PL/SQL Developer is a 32 Bit application, so it cannot interface with a 64 Bit Oracle Client. The 32 Bit Oracle Client can communicate with a 64 Bit Server, even on the same machine if necessary. The 32 Bit client can coexist with a 64 Bit Oracle installation when installed in separate Oracle Home directories.

Pl Sql Developer Oracle Client Not Properly Installed Oracle Home Keyless

You can install SQL-Developer at home or on your laptop, and access the Oracle 12g server, without having to use client access tools in the labs. The procedure is as follows (Mac instructions are at the bottom of the page):

1. Download SQL-Developer to your computer

  • Download the SQL Developer software from the Oracle web site: https://www.oracle.com/tools/downloads/sqldev-v192-downloads.html). Keep in mind that Oracle keeps reconfiguring their website and this URL is not stable.
  • Oracle now releases products quarterly. The current version is 19.2.1. This version is installed in the labs.
  • Use the version with the JDK8 bundled in it (approx 490 MB).
  • Save it to a convenient location on your computer (e.g. C:SQLDeveloper).
  • You may need to create an account on Oracle to download the software.
Pl Sql Developer Oracle Client Not Properly Installed Oracle Home Key

2. Install the software

Pl Sql Developer Oracle Client Not Properly Installed Oracle Home Key Windows 10

  • Unzip the files to the current folder.
  • See instructions on the Oracle website for how to proceed. These are not included here as they tend to change.
  • You may need to create a shortcut on the desktop manually. Ditto for including it in the list of All Programs.

3. Configure the software

    • Start the program by clicking on the program icon.
    • Right-click on the Connections icon in the left pane and select New Connection.
    • Use the following parameters for the connection – may vary by version):

Connection Name: orcl
Authentication Type: Default
Username: {your panther id}
Role: default
Password: {your Oracle/LSB password}
Save Password: {keep checked}
Connection Type: Basic
Role: default
Hostname: luboradb.ad.uwm.edu
Port: 1521
Service name: orcl.ad.uwm.edu

Your Oracle/LSB password is 12 characters and you would have received this is two installments (the first starting with alphabets, and the second starting with numbers). You must use this password to access Oracle. No other password will work. If you use any other password, it will treat it as an unsuccessful login attempt. After 10 unsuccessful login attempts, your Oracle account will be locked for 24 hours, and there is nothing that I can do to override this – this is an Oracle policy.

Alternatively, see the configuration screen below:

Remember that this is configured for you as a user and cannot be shared. If you expect to run this on a shared computer, then leave your Username and Password blank.

4. Using SQL-Developer

  • You can enter SQL statements in the Worksheet tab of the orcl pane, and either press function key F5 or use the Run Script button to execute the statements.
  • Note that SQL-Developer will likely not display times by default. You will need to use the TO_DATE function in the INSERT and UPDATE statements if you need to incorporate times into your data. Likewise, you would use the TO_CHAR function in the SELECT statements to display the times. Alternatively, you can alter the session to display times.

Pl Sql Developer Oracle Client Not Properly Installed Oracle Home Key Lock

Mac Installation
If you use a Mac, then the instructions are a little different. Caveat: I do not have access to a Mac, so I am unable to verify these instructions.

Pl Sql Developer Oracle Client Not Properly Installed Oracle Home Keys

  • Download the Mac OSX version (338MB) from the same page.
  • This version assumes you have JDK8 or JDK11 on your computer. If not, look through the Installation notes page as to how to obtain it, and which version to get.
  • Save the SQL-Developer for OSX zip file to your Downloads folder on your computer.
  • Double-click the SQL Developer icon in the Downloads folder to unzip it.
  • You can move the software to a different folder of your choice, if needed.
  • As with any downloads from Oracle, you may need to create an account on Oracle to download the software.