Summary of oracle thin client and plsql Installation Problems

Summary of oracle thin client and plsql installation problem installation environment: After the oracle thin client is installed on win7 www.2cto.com, problems encountered during plsql login: Access violation at adress 614A2909 in module 'oran9. dll '. read of address 0000008 uses the oracle thin client: http://ishare.iask.sina.com.cn/f/35627668.html 1. After installing the oracle client, install PL/SQL. There is no sequence, but we recommend that you first install the oracle client. When PL/SQL is installed, PL/SQL automatically identifies the directory. The Client installation location is optional. I installed the following directory: D: \ database \ OracleClient. 2. After installing the oracle client, modify D: \ database \ OracleClient \ ora90 \ network \ ADMIN tnsnames. ora. I will not talk about how to modify it here. After PLSQL is installed, overwrite the existing tnsnames. ora. There is still a problem. Let's talk about several situations I have encountered: a) I have configured several database connections in my original tnsnames. ora. When I log on to PLSQL, the database is not selected, and the original database name cannot be obtained. At this time, you can click Cancel directly, then PLSQL will open, and then look at help> support Info to check whether your paths are correct. Several of my parameters are as follows: parameters: D: \ Program Files \ PLSQL Developer \ plsqldev.exe Preference Files D: \ Program Files \ PLSQL Developer \ Preferences \ Default. ini D: \ Program Files \ PLSQL Developer \ Preferences \ Administrator \ default. iniPlug-Ins Homes OraHome90 (D: \ database \ OracleClient \ ora90) DLLs D: \ database \ OracleClient \ ora90 \ bin \ oci. dll TNS File D: \ database \ OracleClient \ ora90 \ network \ ADMIN \ tnsnames. ora and above are correct configurations. If you have any questions, let's take a look. Note that if the preceding Homes, DLLs, and TNS files are not modified as follows: Configure Homes in system environment variables to check whether the path is correct. After installation, it should be available. If you install it multiple times (I will), it may not be the path of the oracle client you want to use now. TNS File is also configured in environment variables. Www.2cto.com and then there is the dlls: it should be configured in your plsql. After plsql is enabled, the connection under Oracle (the first item by default) in the first item Perference... In tools includes Oracle Home and OCI library. Oracle Home directly selects OraHome90. This should be the system variable you Just configured. It doesn't matter if you don't have it. You can also directly stick the directory. However, the file may not be found. We recommend that you configure it in the environment variable. I can't find it. Some people can find it directly. My options include: OraHome90, D: \ database \ OracleClient \ ora90, And the directory in oci library: should also be optional. If there is no option, the Directory of the client you installed will also be pasted. Note that oci should be included. dll: D: \ database \ OracleClient \ ora90 \ bin \ oci. in this case, the dll should be okay. If it still cannot be installed, especially if the TNS File remains unchanged, Open regedit in the registry. Search for TNS and check whether other oracle clients you have installed have occupied this space. If you have found it, change it to the current path. In addition, when Windows 7 is running, a blank logon window is displayed. This issue is about permissions. You can run it as an administrator. If the Administrator is running, a blank box is displayed, indicating that your environment variable is configured incorrectly. Especially the environment variable Homes.