[One of Oracle XE series] install Oracle XE11gR2 X64 database in Windows10_X64 environment, and create database in oraclexe

[One of Oracle XE series] install Oracle XE11gR2 X64 database in Windows10_X64 environment, and create database in oraclexe

I. Installation

1. Go to the Oracle official website to download the XE installation package [Download path] (Oracle Database Express Edition 11GRelease 2 for Windows x64), decompress.

2. Double-click setup.exe to start the installer.

2. Modify the character set of Oracle XE

1. -- problem: in the character set AL32UTF8, one Chinese Character occupies three characters

SQL> select lengthb ('wang lif') from dual; LENGTHB ('wang lif') ----------- 3

If you do not modify the character set, you will suffer. But fortunately, I have a simple method here.

The process is also quite simple. First, start the command line (START-run-CMD ). Then execute the following command.

1) Run sqlplus.exe/nolog in the command line window.

2) then execute the following command in sqlplus:

Connect sys_name/sys_password as sysdba -- log on to shutdown immediate according to your actual 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

Character Set conversion can be completed as follows:

SQL> select lengthb ('wang lif') from dual; LENGTHB ('wang lif') ----------- 2

Of course, your APEX also becomes garbled at the same time. There are three 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 "English" and "Chinese (simplified)" at the bottom of the interface))
• The last one is to upgrade APEX and install the Chinese package (recommended). I will introduce this method below. I have listened carefully ;)

2. InstallationAPEX 5.0.2

1) decompress 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 on to the database as SYSDBA:

D:/OracleXE/apex> sqlplus/nologSQL> connect sys as SYSDBAEnter password: <SYS password>

3) run the installation script apexins. SQL:

SQL>@apexins SYSAUX SYSAUX TEMP /i/

4.) After the installation is complete, run the apxldimg. asl script to install the images, CSS, and JS scripts required by APEX:

SQL>@apxldimg C:/OracleXE/

It should be noted that it is passed to apxldimg. the SQL script parameter is the parent directory of the APEX main directory (for example, if your APEX installation path is c:/oraclexe/apex, the path parameter here is c:/oraclexe ), for this, you can view apxldimg. the SQL script is verified, which is why many people on the Internet say that the path error occurs during image installation.

5.) run the apxchpwd. SQL script and set the Admin (Password: The Password Must Meet the complexity requirements !)

SQL>@apxchpwd

6) after the installation is complete, you can access the apex management background through http: // 127.0.0.1: 8080/APEX/apex_admin, indicating that the installation is successful.

3. Install the Chinese Language Pack
1) Open the cmd Console window and set the environment variable NLS_LANG:

set NLS_LANG=American_America.AL32UTF8

Note: If you have opened the SQL * PLUS window, you must close it before setting the environment variable NLS_LANG.

2) switch to the C: \ oraclexe \ apex \ builder \ zh-cn path, start SQL * PLUS, and run the following statements as SYSDBA:

SQL>ALTER SESSION SET CURRENT_SCHEMA = APEX_040000;SQL>@load_zh-cn.sql

After the installation is complete, go to http: // 127.0.0.1: 8080/apex/apex_admin to switch the language between "English" and "Chinese (simplified)" at the bottom of the interface.

Additional supplement:

Solve the problem that APEX cannot be accessed through the network or host name: start SQL * PLUS and log on to the database as SYSDBA, and execute the following statements:

SQL>execute dbms_xdb.setListenerLocalAccess(l_access => FALSE);

4. Set backend running parameters

alter system set JOB_QUEUE_PROCESSES=2;

NOTE: If JOB_QUEUE_PROCESSES is set to 0, the subsequent Job will not run without the Job scheduling process.

3. Modify ports 1521 and 8080 occupied by Oracle XE Listener
When installing OracleXE, there is a prompt

 1.Destination Folder: D:\oraclexe\   2.Port for 'Oracle Database Listener': 1521   3.Port for 'Oracle Services for Microsoft Transaction Server': 2030   4.Port for HTTP Listener: 8080

It can be seen that the default web console service port is 8080 and cannot be changed during installation. After installation, it conflicts with Tomcat, Jboss, and other servers, so many problems may occur. There is such an SQL statement in the XE installation file that can be used to change the http port.
In the D: \ oraclexe \ app \ oracle \ product \ 11.2.0 \ server \ config \ scripts \ postDBCreation. SQL file. There is such an SQL code:

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

Take a look at the log file D: \ oraclexe \ app \ oracle \ product \ 11.2.0 \ server \ config \ log \ postDBCreation. log, which contains the following records:

 1.SQL> begin   2.  dbms_xdb.sethttpport('8080');   3.  dbms_xdb.setftpport('0');   4. end;   5. /PL/SQL procedure successfully completed. 

We can see that Oracle XE uses it to set the http port and open the SQL * Plus console. Use sys or system to log on. Then run:

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

In this way, the port is set to 8088.