Win7 64-bit system oracle32bit + PL/SQL Access Orale Service, Oracle 11g installation, Chinese garbled problem resolution

A few days ago because of a oracle32bit client + PL/SQL connection not Oracle was the leader despise, asked me to use PL/SQL No, I installed the open PL/SQL login interface is not the same as his, there is no connection for normal, sysdba options , also asked why I have PL/SQL also installed Oracle client, at that time I also can not answer, later on the Internet or found the answer, in the heart also despised him a, oneself do not understand bullying new? The level does not seem to drop well. the reason to install the Oracle client is that the Oci.dll is 64-bit and the 32-bit application Plsql developer cannot load.

　　In order to save trouble on the Internet to download a free installation version of the Oracle32bit client. Extracted to the following path E:\oracle\instantclient_12_1. And in this path to create a new level two directory network\admin, create a Tnsnames.ora file, configure the following things, probably means that we want to connect the Oracle service address, and database named Test.

test =
  (DESCRIPTION =
     (ADDRESS = (PROTOCOL = TCP) (HOST = 10.0.3.29) (PORT = 1521))
    (connect_data =
  & nbsp;   (SERVER = dedicated)
      (service_name = oracle.bak)
    
 )

oracle Home is the Oracle client path, mine is e:\oracle\instantclient _12_1,oci Library is < Span style= "color: #000000;" >e:\oracle\instantclient_12_1 \oci.dll.

With these two things you should be able to access someone else's Oracle service.

--------------------------------------------------------------------------------------------------------------- -----------------------------------------------

The following describes the next oracle11g Server installation process (the installation process is very simple, before the school was frightened by the teacher thought it is very troublesome, so feel when learning something when you want to take it as a simple illusion, so learn to at least easy to point, do not scare yourself) and how to configure network services.

1. Download Oracle 11g

2. Extract the two compressed packages to the same directory, i.e. "database" and click on the "setup.exe" file under the extracted directory.

3. The following command prompt will appear when the installer is executed.

4. Wait a moment and the splash screen will appear.

5. After the splash screen, the installation screen will appear, cancel the "I want to receive security updates through my Oracle support" check, click "Next" to continue, and in the information prompt box that appears, click "Yes".

6. The Installation Options dialog box appears, by default select "Create and Configure Database" and click "Next" to continue.

7. The Installation Type dialog box appears and click "Next" to continue. If the installation environment is on Windows Server, select the server class.

8. Grid installation options. By default, single instance database installation is selected. If the server is configured as a RAC (application cluster), select the "Real Application Clusters Database Installation" installation configuration. Click "Next" to continue.

9. Installation type. "Typical Installation" is selected by default, and if detailed settings are required, select "Advanced Installation" and click "Next" to continue.

10. Install the configuration. It is important to note that the format of the administrative password contains at least one uppercase letter, one lowercase letters, and one number, otherwise you will be prompted for a warning, and then click "Next" to continue when you have entered it correctly.

11. Prerequisite checks. If you see a project that does not meet the installation requirements, select Ignore All and click Next to continue.

12. Click "Finish" to start the installation.

13. In the installation process, if Windows Security Warning appears, click "Allow access".

14. Click "OK" to return to the main screen, then click "Close" to complete the installation. Note: Here is a password management, click can go in to unlock Scott users, only SYS and system users are not locked, and set the change password.

15. At this point, the Oracle 11g has been installed. You can open the Access URL in the Start menu->oracle-oradb11g_home1->database CONTROL-ORCL. You can manage the database by logging in as a SYSDBA connection.

This approach is for Oracle 11g server + oralce 32bit client + plsql.

　　Here's how to configure network services to use Plsql

　

This installs the oracle32bit client software. After the installation succeeds and you configure the network service, you can use PL/SQL.

--------------------------------------------------------------------------------------------------------------- ------------------------------------------------

Environment: Windows 7 Chinese, Oracle 11g Client

Idea: The registry is consistent with the character set in the system environment variables.
1. Enter regedit in the run, open Registry Editor
2.hkey_local_machine->software->oracle->key_oraclient11g_home1 See Nls_lang will: SIMPLIFIED CHINESE_CHINA. Zhs16gbk
3.cmd--Set found Nls_lang=american_america. We8iso8859p1
4. My Computer--right-click--Properties--environment variables--system variables--change Nls_lang to simplified Chinese_china. Zhs16gbk-->
Restarting plsql resolves the issue.

　　

　　

　　

Win7 64-bit system oracle32bit + PL/SQL Access Orale Service, Oracle 11g installation, Chinese garbled problem resolution