Pl Sql Developer Oracle Client Not Properly Installed O...

Return to site

Pl Sql Developer Oracle Client Not Properly Installed Oracle Home Key

Cause: When you install Oracle Developer Tools, it typically creates a new 'Oracle Home' (a new Oracle subdirectory, for example C: oracle product 10.2.0 mynewhome ) Each Oracle home maintains it's own copy of your connect aliases in a file called TNSNAMES.ORA. When you try to connect from this new Oracle home, none of your old connect.
How I can install and use Oracle Developer 6i and Oracle Developer Suite 10g on the computer? It needed registry edition or is there any 'official' way? View 1 Replies View Related.
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 ORACLEHOME 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. Nov 17, 2019 Tool to pl sql developer for postgresql new features pl sql 9 0 allround oracle pl sql developer connects to a pl sql developer plsql developer login oracle ears Creating A Base Connection Using Sql.
Well, anyone that has tried to use tnsping with Oracle's InstantClient (http://www.oracle.com/technology/tech/oci/instantclient/index.html) was in for a big nasty surprise... it's not included. Not only is not included, you can't download a version that is compatible with InstantClient.I've been a fan of tnsping for some time. It has always been valuable as a quick way to test the 'reachability' factor of a particular database. I now have to admit that it's not required since SQLPlus technically can perform this functionality. Well, habits die hard.
Goal: Get InstantClient working with tnspingand AllAroundAutomation's PL/SQL Developer (http://www.allroundautomations.nl/plsqldev.html).
Solution:
Disclaimer:
I don't want to tell you how long it took me to figure this all out, but it was way too long.
It's an unacceptable solution from a long-term maintenance, support standpoint.

Pl sql developer oracle client not properly installed oracle home key fob

Steps:Download the appropriate InstantClient 'base' (in other words, English-only or International).
Download the InstantClient SQL-Plus 'add-on'.
Extract both Zip files into the same directory [for this example, 'c:oracleinstantclient'].
At this point, we haven't done anything special.
Define an environment variable oracle_home that points to the location of your InstantClient directory (e.g.: 'c:oracleinstantclient').
Create a subdirectory called 'network' (c:oracleinstantclientnetwork).
In 'network', create a subdirectory called 'admin'.
If desired, put your tnsnames.ora and sqlnet.ora in c:oracleinstantclientnetworkadmin [technically, this isn't required but it follows Oracle's 'standards'].
Define an environment variable tns_admin that points to the location of your tnsnames.ora (if you are using one).
In 'network', create a subdirectory called 'mesg'.
From an Oracle 10.x Fat client installation, copy tnsus.msb into c:oracleinstantclientnetworkmesg. 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.Create a subdirectory called 'bin' (c:oracleinstantclientbin), and yes, it must be called bin.
From an Oracle 10.x Fat client installation the following files into c:oracleinstantclientbin:
heteroxa10.dll
oci.dll
ocijdbc10.dll
ociw32.dll
oraclient10.dll
oracommon10.dll
oracore10.dll
orageneric10.dll
orahasgen10.dll
oraldapclnt10.dll
oran10.dll
orancds10.dll
orancrypt10.dll
oranhost10.dll
oranl10.dll
oranldap10.dll
oranls10.dll
orannzsbb10.dll
oranro10.dll
orantcp10.dll
orantns10.dll
oraocci10.dll
oraociicus10.dll
oraocr10.dll
oraocrb10.dll
oraplp10.dll
orapls10.dll
ORASLAX10.DLL
orasnls10.dll
orasql10.dll
Orasqlplusic10.dll
oraunls10.dll
orauts.dll
orauts_imp.dll
oravsn10.dll
oraxml10.dll
sqora32.dll
sqoras32.dll
sqresja.dll
sqresus.dll
tnsping.exe
Now, copy all the files from c:oracleinstantclient into c:oracleinstantclientbinexcept those that already exist.
At this point, InstantClient is 'valid', PL/SQL Developer works [but it's actually using c:oracleinstantclientbin, and tnsping should work from c:oracleinstantclientbin.Talk about smells bad.So if you want tnsping

Pl Sql Developer Oracle Client Not Properly Installed Oracle Home Key

Pl sql developer oracle client not properly installed oracle home key chain

Pl sql developer oracle client not properly installed oracle home key lock

Steps:Download the appropriate InstantClient 'base' (in other words, English-only or International).
Download the InstantClient SQL-Plus 'add-on'.
Extract both Zip files into the same directory [for this example, 'c:oracleinstantclient'].
At this point, we haven't done anything special.
Define an environment variable oracle_home that points to the location of your InstantClient directory (e.g.: 'c:oracleinstantclient').
Create a subdirectory called 'network' (c:oracleinstantclientnetwork).
In 'network', create a subdirectory called 'admin'.
If desired, put your tnsnames.ora and sqlnet.ora in c:oracleinstantclientnetworkadmin [technically, this isn't required but it follows Oracle's 'standards'].
Define an environment variable tns_admin that points to the location of your tnsnames.ora (if you are using one).
In 'network', create a subdirectory called 'mesg'.
From an Oracle 10.x Fat client installation, copy tnsus.msb into c:oracleinstantclientnetworkmesg. 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.Create a subdirectory called 'bin' (c:oracleinstantclientbin), and yes, it must be called bin.
From an Oracle 10.x Fat client installation the following files into c:oracleinstantclientbin:
heteroxa10.dll
oci.dll
ocijdbc10.dll
ociw32.dll
oraclient10.dll
oracommon10.dll
oracore10.dll
orageneric10.dll
orahasgen10.dll
oraldapclnt10.dll
oran10.dll
orancds10.dll
orancrypt10.dll
oranhost10.dll
oranl10.dll
oranldap10.dll
oranls10.dll
orannzsbb10.dll
oranro10.dll
orantcp10.dll
orantns10.dll
oraocci10.dll
oraociicus10.dll
oraocr10.dll
oraocrb10.dll
oraplp10.dll
orapls10.dll
ORASLAX10.DLL
orasnls10.dll
orasql10.dll
Orasqlplusic10.dll
oraunls10.dll
orauts.dll
orauts_imp.dll
oravsn10.dll
oraxml10.dll
sqora32.dll
sqoras32.dll
sqresja.dll
sqresus.dll
tnsping.exe
Now, copy all the files from c:oracleinstantclient into c:oracleinstantclientbinexcept those that already exist.
At this point, InstantClient is 'valid', PL/SQL Developer works [but it's actually using c:oracleinstantclientbin, and tnsping should work from c:oracleinstantclientbin.Talk about smells bad.So if you want tnsping for InstantClient, create this nightmare-ish drink from this recipe or complain to Oracle and ask for a InstantClient-compatible version of tnsping.JasonNote:
Pl Sql Developer Oracle Client Not Properly Installed Oracle Home KeypadThis guide assumes that you plan to download SQL Developer and run it as a freestanding tool.
Pl Sql Developer Oracle Client Not Properly Installed Oracle Home Key LargoFor information about operating system versions supported for Oracle JDK 8, see http://www.oracle.com/technetwork/java/javase/certconfig-2095354.html.
Pl Sql Developer Oracle Client Not Properly Installed Oracle Home Key Windows 10If you plan to use SQL Developer as part of an Oracle Database release installation, see the Oracle Database installation documentation.
Pl Sql Developer Oracle Client Not Properly Installed Oracle Home Key LockPlease read the information in this chapter before you install Oracle SQL Developer. This chapter contains the following major sections: