Installation and guidance for Oracle 11g XE Release2

I installed Oracle 11g Enterprise this morning and found that it was too much memory, considering the Express version of MS SQL, so I was thinking about trying to try the Oracle 11g Express version, which is the ex version. The following are the specific installation steps.

1, download Oracle 11g XE version, address Oracle 11g EX

2, that is, click on the next installation

After installation, it is found that the memory is much less. Because the ex version occupies up to 1G of memory, this has no effect on individual users.

Then there are the following programs in the Setup program

　　

3, use PL SQL to connect to Oracle database

A, download install-client-packet from the official website, the URL is client-packet (note that the download is a 32-bit version)

b, install the downloaded client package to, for example, D:\OracleClient, the final client home directory is D:\OracleClient\instantclient_11_2

C, then create a new network subdirectory under D:\OracleClient\instantclient_11_2, then create a new admin subdirectory under Network, and end up in D:\OracleClient\instantclient_11 _2\network\admin new Tnsnames.ora file, the contents of the file are as follows:

XE =
(DESCRIPTION =
(Address_list =
(ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.1.100) (PORT = 1521))
)
(Connect_data =
(service_name = XE)
)
)

Red content is the content to be modified, 192.168.1.100 is the IP address of the server, XE is the server DB instance

d. Open PL/SQL Developer, select Cancel in the Login window, and then complete the following in the menu tool-preferences

Oracle Home directory Name: D:\OracleClient\instantclient_11_2

OCI Library: D:\OracleClient\instantclient_11_2\oci.dll

E, shut down the server-side firewall (set firewall allow policy according to your own needs), this step is very important, testing many times the last discovery is a firewall problem.

F, at this time, re-open client PL/SQL Developer, log in with system, and then the following error occurs

　　　　

G, if you appear above the exception, this indicates that PLSQL does not support 64-bit system, then you should download the wrong version, you should download the 32-bit version, and then repeat the above steps.

4, in the execution of query data, if there is Chinese characters, may appear garbled, the solution is as follows:

The character set is divided into server-side character sets and client character sets.

1, the server-side character set general installation of the Oracle database will choose the Chinese character set, if not, it can only be modified by other methods.

This case assumes that the server-side character set is the Chinese character set, via Sql>select userenv (' language ') from dual;

The results are as follows: Simplified Chinese_china. Zhs16gbk

2. Client Character Set

Under the Windows platform, the system environment variable nls_lang=simplified Chinese_china is set in the system environment variable. ZHS16GBK.

You can also set the DOS window itself, for example: Set Nls_lang=simplified Chinese_china. Zhs16gbk

This will only affect the environment variables in this window.

You can view and insert Chinese characters by setting them.

Installation and guidance for Oracle 11g XE Release2