How to configure the oracle database in win7

How to configure the oracle database in win7:

Environment: Windows 7 (64bit), oracle 11g (64bit ).

In the course of the experiment, oracle is damaged. You need to uninstall it before installing oracle again.

Steps for uninstalling oracle 11g:

1. Stop all oracle-related services in the service;

2. Delete oracle related folders in the following three locations in the registry:

HKEY_LOCAL_MACHINE \ SOFTWARE

HKEY_LOCAL_MACHINE \ SYSTEM \ CurrentControlSet \ services

HKEY_LOCAL_MACHINE \ SYSTEM \ CurrentControlSet \ Services \ Eventlog \ Application

3. In the environment variable path, delete the oracle information;

4. Delete the oracle folder and oraodbc. ini file in the Windows, Program Files, and Program Files (x86) folders of the system disk;

5. Delete the oracle installation directory and restart the machine.

After you reinstall oracle 11g, You need to configure PL/SQL. We need oracle 11g (32bit) client, PL/SQL of version 8.0 and later.

1. Make sure your oracle can be connected using SQL/PLUS;

2. In environment variables, configure the following values in the oracle database:

Variable name: ORACLE_SID; variable value: oracle Instance name

Variable name: NLS_LANG; variable value: AMERICAN_AMERICA.ZHS16GBK; character set can be selected as needed

Variable name: TNS_ADMIN; variable value: D: \ app \ Andreas \ product \ 11.2.0 \ dbhome_1 \ NETWORK \ ADMIN. My oracle is in the D: \ app \ Andreas directory.

3. Open PL/SQL and connect to the database. An initialization error is reported. Click OK. After three consecutive times, you can enter PL/SQL without logon. Under Tool --> Preferences --> Connection, there are two input items: Oracle Home (empty is autodetect) and OCI Library (empty is autodetect), respectively filled in the oracle installation directory, and the unzipping directory of the 32-bit client, such:

Oracle Home D: \ app \ Andreas \ product \ 11.2.0 my oracle is installed in the D: \ app \ Andreas directory.

OCI Library D: \ app \ Andreas \ instantclient_11_2 \ oci. dll my client is decompressed under the D: \ app \ Andreas directory.

4. Close PL/SQL and re-open it to log on.

The above is how to configure the oracle database in win7.

I believe that through the above learning, everyone can now master how to configure the oracle database in win7, so that you can easily solve similar problems in future work, I hope the content mentioned above will be helpful to you.