"One of Oracle XE series" WINDOWS10_X64 Environment installs Oracle XE11GR2 X64 database

First, installation

1. Go to Oracle's official website to download the XE version of the installation package [download path] (Oracle Database Express Edition 2 for Windows x64), unzip.

2. Double-click Setup.exe to start the installation program

Ii. modifying The character set of Oracle xe

1 、--problem: In character set Al32utf8, a Chinese character occupies 3 characters

Sql> Select LENGTHB (' Wang Lifu ') from dual; LENGTHB (' Wang Lifu ')-------------            3

If you do not modify the character set, then you are suffering, but fortunately, I have a method here is quite simple.

The process is fairly straightforward, starting with the command line (start-run-"CMD"). Then execute the following command.

1.) Run under Command Line window: Sqlplus.exe/nolog

2.) and then sqlplus inside to execute the following command

Connect Sys_name/sys_password as SYSDBA--log in to shutdown immediate according to your own situation;   Startup Mount   alter system enable restricted session;   alter system set job_queue_processes=0;   alter system set aq_tm_processes=0;   ALTER DATABASE Open;alter database character set Internal_use ZHS16GBK;   Shutdown immediate  Startup

You can complete the conversion of the character set as follows

Sql> Select LENGTHB (' Wang Lifu ') from dual; LENGTHB (' Wang Lifu ')-------------            2

Of course, your apex will also become garbled at the same time, there are 3 solutions:

• one is not apex;
• One is to set the language of IE to English (or http://127.0.0.1:8080/apex/apex_admin can be in the interface below the "English" and "Chinese (Simplified)" between the language switch)
• The last one is to upgrade apex, and install the Chinese package (recommended) The following will introduce this method, listen carefully ah;)

2. Install APEX 5.0.2

1.) Unpack the Apex folder in Apex_5.0.2.zip to c:/oraclexe/; (Download path)

2.) Open the CMD console window, switch the current path to c:/oraclexe/apex/, start Sql*plus, and log in to the database SYSDBA role:

D:/oraclexe/apex>sqlplus/nologsql> CONNECT SYS as sysdbaenter password: <sys password >

3.) Execute the installation script Apexins.sql:

sql> @apexins Sysaux Sysaux temp/i/

4.) After the installation is complete, execute the APXLDIMG.ASL script to install the images, CSS, and JS scripts needed in APEX:

Sql> @apxldimg c:/oraclexe/

It is important to note that the parameters passed to the Apxldimg.sql script are the parent directory of the Apex home directory (for example: your apex installation path is C:/oraclexe/apex, then the path parameter is C:/oraclexe), which can be viewed by viewing The Apxldimg.sql script is verified, which is why many people on the web say that a path error occurred while installing the picture.

5.) Execute the Apxchpwd.sql script below and follow the prompts to set APEX Admin password: Password to meet complexity requirements! )

Sql> @apxchpwd

6.) After the installation is completed through the http://127.0.0.1:8080/apex/apex_admin can enter the apex management background, that is, the installation is successful.

3. Install the Chinese Language pack
1.) Open the CMD console window to set the environment variable Nls_lang:

Set Nls_lang=american_america.al32utf8

Note: If you have previously opened the Sql*plus window, you must remember to close it before setting the environment variable Nls_lang.

2.) switch to the C:\ORACLEXE\APEX\BUILDER\ZH-CN path, start Sql*plus and execute the following statement in the SYSDBA role:

Sql>alter SESSION SET current_schema = apex_040000; Sql> @load_zh-cn.sql

After waiting for the installation to complete, re-enter http://127.0.0.1:8080/apex/apex_admin to switch between "中文版" and "Chinese (Simplified)" below the interface.

Additional additions:

Resolves an issue where APEX cannot be accessed through the network and hostname: Start Sql*plus and log in to the database with the SYSDBA role, executing the following statement:

Sql>execute dbms_xdb.setlistenerlocalaccess (l_access = FALSE);

4, set the background running parameters

alter system set job_queue_processes=2;

Note: job_queue_processes=0, after the job does not have the job scheduling process, is not run.

Third, modify the 1521, 8080 ports occupied by Oracle XE Listener
When installing Oraclexe, there is a hint

1.Destination folder:d:\oraclexe\   2.Port for ' Oracle Database Listener ': 1521   3.Port for ' Oracle Services for Mic Rosoft Transaction Server ': 2030   4.Port for HTTP listener:8080

As you can see, the Default Web console service port is 8080 and cannot be changed at installation time. After installation conflicts with servers such as Tomcat, JBoss, and so on, you will encounter many problems. There is a SQL in the XE installation file that can be used to change the port of HTTP.
In the D:\oraclexe\app\oracle\product\11.2.0\server\config\scripts\postDBCreation.sql file. There is a SQL code like this:

1.begin   2.   Dbms_xdb.sethttpport (' 8080 ');   3.   dbms_xdb.setftpport (' 0 ');   4.end;   

Then look at the log file D:\oraclexe\app\oracle\product\11.2.0\server\config\log\postDBCreation.log, there is a record:

1.sql> begin   2.  Dbms_xdb.sethttpport (' 8080 ');   3.  dbms_xdb.setftpport (' 0 ');   4. End;   

You can see that Oracle XE is using it to set up an HTTP port and open the Sql*plus console. Log in with SYS or system. Then run:

1.begin   2.   Dbms_xdb.sethttpport (' 8088 ');   3.   dbms_xdb.setftpport (' 0 ');   4.end;   5./

This will set the port to 8088.

"One of Oracle XE series" WINDOWS10_X64 Environment installs Oracle XE11GR2 X64 database