FBackup Silent Install params 29 April, 2020; How to Disable UAC in Windows 10? Here Are Four Simple Ways! 15 April, 2020 How to install TP-Link Print Server by using Standard TCP/IP port in Windows Vista and Windows 7 14 April, 2020. Hi Peter, I tried what you suggested and it doesn't work. The drop down list does not list the tnsnames.ora entries and it is complaining about OracleHomeKey and OracleHomeDir which are not required to be set when using instantclient.
OracleHomeKey: SOFTWARE ORACLE OracleHomeDir: 原因大概是Oracle10g的安装目录结构变了，需要在PLSQL Developer中重新配置ORACLEHOME and 'OCI Library'的目录。. On win7 64 bit, PL/SQL Developer client login message: 'Initailization error, SQL.Net not properly installed, OracleHomeKey:;OracleHomeDir:'. The server is a remote server, I only have a sql clie. OracleHomeKey: OracleHomeDir: I have entered in this into the Tns Name: plant-dev.dbs.tde.timberside.com:1521:SPFND01D with a valid user/password I can connect to this Oracle DB with those same details using another tool. What's wrong with this Database Browser tool? I would have search for this in the forums but I can't see a way to do that.
Log normal with sqlplus, and using PLSQL making the same user login with a database error: initialization error making
SQL*NET is not completely set making
OracleHomekey:software/oracle
OracleHomedir
Can be solved by the following methods:
1, Download Instant Client
http://www.oracle.com/technetwork/database/features/instant-client/index-097480.html
Find and system corresponds to the version download.
Here to 32 bit windows system as an example:
instantclient-basic-nt-11.2.0.3.0.zip
instantclient-sqlplus-nt-11.2.0.3.0.zip
If you only client tools, do not use the command line sqlplus, second bags can not
2, Unzip the package to the specified path, here for example to extract: C:instantclient_11_2
3, Set the system variables:
NLS_lANG=SIMPLIFIED CHINESE_CHINA.ZHS16GBK (note the space, the middle of this if not set, toad query Chinese will be garbled)
TNS_ADMIN=C:instantclient_11_2(consistent and decompression path)
Path=C:instantclient_11_2(consistent and decompression path)
4, The establishment of tnsnames.ora, configure the Oracle database here in the server IP, and save the installation directory: C:instantclient_11_2, Explain: The ora file must be connected when the user program, including PL/SQL Developer
Such as: mydbname =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.17.146)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = center)
)
)
Such a connection with one or more
5, Configuration after the restart PLSQL Developer, will find the login interface multi column Connect as content. Then you can login.
Posted by Johnny at November 08, 2014 - 5:04 AM
PL/SQL Developer
---------------------------
Initialization error
SQL*Net not properly installed
OracleHomeKey:
OracleHomeDir:
（方法一）下载 ok！
http://download.csdn.net/detail/reginadeng/5857081#comment
（方法二）官方下载
下载32位客户端，配置进navicat中
下载地址：http://www.oracle.com/technetwork/topics/winsoft-085727.html
第1步：在上述地址中下载文件：instantclient-basic-nt-11.2.0.3.0.zip
第2步：解压此安装包，并将解压出的文件合并到：D:appDavidproductinstantclient_11_2
第3步：打开Navicat，选择工具→选项→其他→OCI，
设置OCI library为：D:appDavidproductinstantclient_11_2oci.dll
设置SQL *plus为：D:appDavidproduct11.2.0dbhome_1BINsqlplus.exe
点击确定。
第4步：测试成功。
pl/sql> Tools>Preferences>Oracle>Connection> like this. then is ok!!
OracleHomeKey: D:appOracleAdministratorproduct11.2.0
OracleHomeDir:D:appOracleinstantclient-basic-nt-11.2.0.3.0instantclient_11_2oci.dll
D:appAdministratorproduct11.2.0dbhome_1BINoci.dll
D:oracleappAdministratorproduct11.2.0client_1instantclientoci.dll
也可以在pl/sql的安装目录下D:Program Files (x86)PLSQL DeveloperPreferencesAdministratordefault.ini
[Preferences]
CheckConnection=True
SelectedHome=D:appOracleAdministratorproduct11.2.0
OCIFile=D:appOracleAdministratorproduct11.2.0dbhome_1binoci.dll
改成自己在路径。
oracle 配置监听程序
Net Configuration Assistant
system，127.0.0.1:1521/orcl
Oraclehomekey Oracle Home Dir