Problem? PL/SQL Developer client installation and configuration and handling of some problems
First, the problem analysiswhen using the PL/SQL Developer Client tool, be sure to look at the two-point knowledge that is different from SQL Server and MySQL client as it can be used directly. Oracle database, also divided into 32-bit and 64-bit, but PL/SQL is a 32-bit client, so there are different ways for the database. for a 64-bit database: Because it is a 64-bit database, a 32-bit database server is required for the PL/SQ to link to the Oracle database. So altogether two tools are needed, one is the database service and the PL/SQL Client tool. for a 32-bit database: This is much simpler than 64-bit, just need a PL/SQL tool, then the final configuration (this configuration is required to use a Tnsnames.ora file,
The file needs to be the same as the Oracle database file, otherwise it cannot be connected ).
Second, installation stepshere for the 32-bit database, I do not introduce, because the market now on the computer is basically 64 bits, and my computer is 64-bit, 32-bit configuration, can be found on the Internet.
1. First install the Oracle database (*64), this is not much to say the installation steps to connect
2. Download and install the Oracle database server (decompression version, download decompression can be used * * Remember to download 32-bit server, otherwise not connected to pl/sql**), click on the download link (official website), easily extracted to that drive letter, remember the location can be, You need to configure it later .
3. Finally, download the PL/SQL Developer Client Tool, because this tool is not free, the gadget has been found on the internet and has cracked tools. Once downloaded, proceed directly to the next step of installation.
Resource Pack downloads (including database remote server and PL/SQL): Click the download link
Iii. Configuring links for Oracle database and PL/SQL customershere, the light click PL/SQL to search for the Oracle database and login on the client, because this time is not linked to the Oracle service and Oracle database.
1. Check that the Oracle service is turned on and you need to turn on three services.
2. Configure environment variables (System variables)Assumptions:Directory of Oracle databases: D:\Oracle11gFile\product\11.2.0\dbhome_1\NETWORK\ADMIN (as to why this is here, because opening it is Tnsnames.ora) Directory extracted by Oracle database service: D:\OracleClientFile\instantclient_12_1
To configure environment variables:This step differs slightly from the other methods, where you can not copy the Tnsnames.ora file to the client directory (32-bit method). Create a new two variable in the system environment variable:
Tns_admin =:D:\Oracle11gFile\product\11.2.0\dbhome_1\NETWORK\ADMIN
Nls_lang = Simplified Chinese_china. ZHS16GBK
Description: Tns_admin, refers to the directory name where the Tnsnames.ora file resides.
If you specify to the client directory, you must copy the Tnsnames.ora file.
Nls_lang environment variables, to be set to the same as the database side, you can query the character set information in Sqlplus
Sql> Select Userenv (' language ') Nls_lang from dual;
Nls_lang
----------------------------------------------------
Simplified Chinese_china. Zhs16gbk
3. Client connection to Oracle database and servicesenvironment variable configuration still unable to log in normally, and the search is not a database, this is because this time the client is not associated, you can cancel the login, you can enter the main interface to set.
go to Tools----Arrow point, one is Oracle database directory, and the other is the directory of the OCI library (extracted Oracle service)Automatic Detection if not, you need to fill it up manually.
set up Oracle Home for Oracle installation directory homesuch as: D:\Oracle11gFile\product\11.2.0\dbhome_1
set the full path name of the Oci.dll file for the OCI library to the Oracle client. such as: D:\OracleClientFile\instantclient_12_1\oci.dll
Click Apply, Exit, re-click to enter, you can find the database directory.
here is a problem, under normal circumstances can be logged in your account, I use the Super User rights to log in, the other does not have permission to log in, you can go to the administrator to run the net Cnfiguration Assistant reconfiguration (this in your menu bar Oracle) , you can go to the bathroom.
References:
Http://jingyan.baidu.com/article/ea24bc39a535d3da62b331c6.html
Http://zhidao.baidu.com/link?url=Kt-Fh9MIgoo069fullNU-fy0x1-RjQjlUGp24iFzskkwJyl_xK9RnF88c_hadL0XE5btPC1eBs6p5uhlgNQsGq
http://blog.csdn.net/netdevgirl/article/details/27818709
PL/SQL Developer client Installation and configuration
