Pl Sql Developer Oracle Client Not Properly Installed Oracle Home Key

Bmw diagnostic software. Connect Application Development Tools SQL*Plus and SQL Developer and other client tools are installed with Oracle Database. SQL*Plus is a command line tool for transmitting SQL and PL/SQL to the database. SQL Developer is a graphical development environment for SQL and PL/SQL. You can use the Data Mining PL/SQL API in either SQL*Plus or SQL Developer. Within SQL Developer you can use both the Data Miner graphical tool and the Data Mining PL/SQL API.

For information about the PL/SQL API, see. If you have installed Oracle Database locally on your PC, you can follow these steps to start SQL*Plus or SQL Developer: • From the Windows Start menu, select Oracle – OraDb11g_home n. Connect SQL Developer The first time you run SQL Developer, you may be prompted to provide the path to the Java executable. If so, specify the full path of jdk bin java.exe under the Oracle home directory for the database. For the installation described in, the path would be: C: app myuser product 11.2.0 dbhome_1 jdk bin java.exe To define a connection to the local database: • Right click Connections and choose New. • The New/Select Database Connection dialog appears.

• For Connection Name, specify a meaningful name that you will remember. • For Username/Password, provide a user name and password for the connection. The user must have data mining privileges as described in.

1 Installing Oracle SQL Developer. Do not install SQL Developer into any existing ORACLE_HOME. You will not be able to uninstall it using Oracle Universal Installer.

• For Hostname, specify localhost to indicate that the database is hosted on the local computer. • For Port, specify the port where the database will listen to requests from the client. The default port is 1521. • For SID (Service Identifier), specify the simple database name. This is the first component of the global database name described in the installation instructions in. Click Connect to connect to the database using the specified credentials. Oracle Client and Oracle Net To connect to an Oracle Database, a client application must identify the database and present appropriate credentials.

The connection mechanism depends on the type of client and whether it is running locally or remotely. Some connections require the installation of Oracle Client software. There are several methods for specifying login credentials.

For example, a client may present login credentials at the time of the connection, as shown below. The system will prompt for a password and establish a connection. SQL>CONNECT username @ ' hostname[: port][/ databasename]' You may also identify a connection with a predefined Net Service Name. Oracle Spreadsheet Add–In for Predictive Analytics, whether running locally or remotely, requires the installation of Oracle Client and the creation of a Net Service Name. Note: To stop an Oracle database, first stop the database service ( OracleService service_name), then stop the database listener ( OracleOraDb11g_homeTNSListener).

• Log on to your computer as a member of the Administrator's group. If you are unsure if your user ID is in the Administrator's group, check User Accounts in Windows Control Panel. • To start the installation, go to the Client installation directory and run SETUP.EXE to start Oracle Universal Installer. • On the Select Installation Type page, choose Administrator. • In the Download Software Updates page, provide your My Oracle Support credentials if you want to automatically download software updates. • On the Select Product Languages page, select the language for the Oracle Client user interface.

If you are using PLSQL developer to connect to the ORACLE database may have faced the problem 'SQL*Net not properly installed '. This problem occur beacause ORACLE_HOME and the oci.dll path location may not have been configured in. To make both oracle 11g and pl/sql developer work in. To acess locally installed Oracle 11 g. Pointed pl/sql developer the home path of my client. From within PL/SQL Developer: Tools > Preferences, Under Oracle > Connection * Oracle Home (point to where tnsnames.ora file is, under the Oracle Client Installation).

• On the Specify Install Location page, provide the path of the Base directory in which you installed Oracle Database. (See step.) The Installer provides a Software Location under Oracle Base. This will be the home directory of the Oracle client that you are installing (Oracle home). If this directory does not exist, the Installer will create it.

If the directory does exist, make sure that it is empty. • The Installer performs prerequisite checks, then displays the Summary page. Click Install to complete the set up process and begin the installation. • On the Install Product page, the Installer displays a progress bar. When the installation is successfully completed, click Close. • Oracle Net Configuration Assistant starts and displays the Welcome page.

Choose Local Net Service Name Configuration, then click Next. Oracle Net Configuration Assistant determines that Oracle Client can use the Easy Connect naming method, as described in. A Net Service Name is not needed. Simply click Next. • Oracle Net Configuration Assistant displays summary information about the connection configuration.

Click the Password Management button at the bottom of the page to unlock any schemas that you plan. If you wish, you can also reset the system passwords. If you will use the Oracle Data Mining sample programs and you did not unlock the SH schema when you installed the database, you should do so now. (See.) Click Exit to exit Oracle Net Configuration Assistant, then click Finish to complete the installation of Oracle Client. • On the End of Installation page, click Exit to exit Oracle Universal Installer.

• If you stopped any Oracle services before running Oracle Universal Installer, you can restart them at this time. In Windows Control Panel, choose Administrative Tools, then Services. Find the service names that start with 'Oracle'. Choose Start for each one. Note: If there are n installations of Oracle Client, they will appear as Oracle – OraClient11g_home1, Oracle – OraClient11g_home2. Oracle – OraClient11g_home n in the Start menu. Be sure to select the appropriate one.

• Choose Configuration and Migration Tools. • Choose Net Configuration Assistant. • Oracle Net Configuration Assistant displays the Welcome page. Choose Local Net Service Name configuration, then Next.

• On the next page, choose Add to add a new Net Service Name. Then click Next. • Provide the Global Database Name in the Service Name text box. (See.) Choose Next. • On the next page specify the communication protocol.

The default is TCP. • On the next page, choose Yes, perform a test to test the new connection. The connection will probably fail until you provide a new user ID and password. Choose Change Login. Provide the user ID and password of an account that has data mining privileges on the host.

• If the user name and password were the only problem with the connection, Oracle Net Configuration Assistant makes a successful test connection. • Oracle Net Configuration Assistant reports that the connection configuration was successful. When you click Next, you are returned to the Welcome page, where you have the opportunity to perform additional configuration. Click Finish to exit Oracle Net Configuration Assistant. Connect the Spreadsheet Add–In Oracle Spreadsheet Add–In for Predictive Analytics implements predictive analytics ('one–click' data mining) within Microsoft Excel.

You can use the Spreadsheet Add–In to analyze data stored in Excel or in Oracle and to import/export data mining models to/from Oracle Database. Whether the data is stored in Excel or in the database, the Spreadsheet Add–In requires a database connection. The Spreadsheet Add–In requires Oracle Client. It uses a Net Service Name to connect to the database.

Even if the database is local, Oracle Client and a Net Service Name are required. To connect to Oracle, follow these steps: • Install Oracle Client on your computer as described in.

• Create a Net Service Name as described in. • Add the Add–In to Excel as described in.

• From the Add–In menu, choose Connect. • The Connect (Oracle Database) dialog appears. From the list of predefined Net Service Names, choose the connection you want to use. Provide a user name and password and click Connect to activate the Spreadsheet Add–In.

HKEY_LOCAL_MACHINE SOFTWARE ORACLE 'inst_loc'='C: Program Files Oracle Inventory' 'API'='D: oracle product 10.1.0 db_1' HKEY_LOCAL_MACHINE SOFTWARE ORACLE ALL_HOMES 'HOME_COUNTER'='1' 'DEFAULT_HOME'='HOME0' 'LAST_HOME'='0' HKEY_LOCAL_MACHINE SOFTWARE ORACLE ALL_HOMES ID0 'NAME'='Oracle - ORACLE_HOME' 'PATH'='D: oracle product 10.1.0 db_1' 'NLS_LANG'='NA' HKEY_LOCAL_MACHINE SOFTWARE ORACLE HOME0 'ID'='0' 'ORACLE_GROUP_NAME'='Oracle - ORACLE_HOME' 'ORACLE_HOME_NAME'='ORACLE_HOME' 'ORACLE_HOME'='D: oracle product 10.1.0 db_1' Maybe just check it out and compare to yours.

I have Oracle 64-bit client installed to run with my weblogic application. I learnt that pl-sql developer doesn't work with oracle 64-bit client so now i have both 32-bit and 64-bit clients installed on my machine and my ORACLE_HOME variable points to 64-bit client. I am not able to start pl/sql developer even i specify the 32-bit client in Tools->Preferences of pl-sql developer version 8.0.4. I changed my oracle client to 32-bit client then i was able to start pl-sql developer but my application doesn't work. Is there a way i can run PL/SQL developer whilst pointing ORACLE_HOME to 64-bit oracle client.

I am not sure specifying the ORACLE_HOME explicitly in Tools->Preferences of pl sql developer (for user/default as well as system preferences) has any effect as it picks the oracle home from the environment variable i believe. Thanks, Adithya. You'll need to install the two clients into separate Oracle Home locations, for example I've gone for C: OracleHome and C: OracleHome32 Then set up an Environment Variable, called TNS_ADMIN with the folder that contains your default TNSnames.ora file as the value (for me it is C: OracleHome network admin) Keep your preferences in PL/SQL Developer, and make sure you also specify the OCI library (mine is C: OracleHome32 oci.dll) Finally, using regedit.exe, add a second key under ORACLE ( HKEY_LOCAL_MACHHINE SOFTWARE ORACLE). I've called mine KEY_OraClient11g_home1 and KEY_OraClient11g_home2. Create the same 4 strings in the second key, with the appropriate changes to the data (e.g.

ORACLE_HOME should have C: OracleHome32 as it's data field in my example) Restarting all applications should now let you use PL/SQL Developer seamlessly, whilst also defaulting to the 64-bit Oracle home for your weblogic application. Quick post: I was trying to connect to a 64-bit Oracle database using PL/SQL Developer. Despite ORACLE_HOME being set the right values and oci.dll available, PL/SQL Developer could not connect to the database. Further probing indicated that the Oracle installation was a 64-bit one, and PL/SQL Developer is incapable of loading 64-bit version of oci.dll file. To fix this, download the 32-bit version of Oracle Instant Client, extract it to a directory such as instant_client.