Oracle Database XE Installation(oracle-xe-11.2.0-1.0.x86_64.rpm) 오라클 설치

To install Oracle Database XE:

1. Log on to your computer with root permissions.

2. Go to the following Web site:

   http://www.oracle.com/technetwork/database/express-edition/downloads/index.html

3. Click Free Download and follow the instructions to select and download the Linux version of Oracle Database XE.

4. Run the Oracle Database XE executable oracle-xe-11.2.0-1.0.x86_64.rpm to install Oracle Database XE.

   # rpm -ivh downloads/oracle-xe-11.2.0-1.0.x86_64.rpm
   

   The installation displays a status of its progress.

5. When prompted, run the following command:

   # /etc/init.d/oracle-xe configure
   

6. Enter the following configuration information:

   • A valid HTTP port for the Oracle Application Express (the default is 8080)

   • A valid port for the Oracle database listener (the default is 1521)

   • A password for the SYS and SYSTEM administrative user accounts

   • Confirm password for SYS and SYSTEM administrative user accounts

   • Whether you want the database to start automatically when the computer starts (next reboot)

This completes configuration. The database starts during the boot process.

Note:

The password for the INTERNAL and ADMIN Oracle Application Express user accounts is initially the same as the SYS and SYSTEM administrative user accounts.

To start the database manually, run this command as root user:

# /etc/init.d/oracle-xe start

To stop the database manually, run the following command as root user:

# /etc/init.d/oracle-xe stop

-- 직접 설치해보니 rpm 은 제대로 설치되었으나 아래처럼 구성중 오류 발생 (Oracle Linux 6)

[root@oracle Disk1]# /etc/init.d/oracle-xe configure

Oracle Database 11g Express Edition Configuration
-------------------------------------------------
This will configure on-boot properties of Oracle Database 11g Express 
Edition.  The following questions will determine whether the database should 
be starting upon system boot, the ports it will use, and the passwords that 
will be used for database accounts.  Press <Enter> to accept the defaults. 
Ctrl-C will abort.

Specify the HTTP port that will be used for Oracle Application Express [8080]:

Specify a port that will be used for the database listener [1521]:

Specify a password to be used for database accounts.  Note that the same
password will be used for SYS and SYSTEM.  Oracle recommends the use of 
different passwords for each database account.  This can be done after 
initial configuration:
Password can't be null. Enter password:
Confirm the password:

Do you want Oracle Database 11g Express Edition to be started on boot (y/n) [y]:

Starting Oracle Net Listener...Done
Configuring database...
Database Configuration failed.  Look into /u01/app/oracle/product/11.2.0/xe/config/log for details

DB 생성중 오류 발생, 직접 DB를 올려보니

[root@oracle bin]# sqlplus /nolog

SQL*Plus: Release 11.2.0.2.0 Production on 목 3월 14 15:56:19 2013

Copyright (c) 1982, 2011, Oracle.  All rights reserved.

SQL> conn as sysdba
Enter user-name: sys
Enter password:
Connected to an idle instance.
SQL> startup
ORA-00119: invalid specification for system parameter LOCAL_LISTENER
ORA-00130: invalid listener address '(ADDRESS=(PROTOCOL=TCP)(HOST=oracle)(PORT=1521))'

SQL> startup
ORACLE instance started.

Total System Global Area  835104768 bytes
Fixed Size                  2231096 bytes
Variable Size             490734792 bytes
Database Buffers          339738624 bytes
Redo Buffers                2400256 bytes
ORA-00205: error in identifying control file, check alert log for more info

SQL> shutdown
ORA-01507: database not mounted

ORACLE instance shut down.
SQL>

결국 host name 문제였다.

vi /etc/hosts 에서 내 host 인 oracle 추가 후 다시 진행

[root@oracle ~]# /etc/init.d/oracle-xe configure

Oracle Database 11g Express Edition Configuration
-------------------------------------------------
This will configure on-boot properties of Oracle Database 11g Express 
Edition.  The following questions will determine whether the database should 
be starting upon system boot, the ports it will use, and the passwords that 
will be used for database accounts.  Press <Enter> to accept the defaults. 
Ctrl-C will abort.

Specify the HTTP port that will be used for Oracle Application Express [8080]:

Specify a port that will be used for the database listener [1521]:

Specify a password to be used for database accounts.  Note that the same
password will be used for SYS and SYSTEM.  Oracle recommends the use of 
different passwords for each database account.  This can be done after 
initial configuration:
Confirm the password:

Do you want Oracle Database 11g Express Edition to be started on boot (y/n) [y]:

Starting Oracle Net Listener...Done
Configuring database...Done
Starting Oracle Database 11g Express Edition instance...Done
Installation completed successfully.
[root@oracle ~]# 

땡큐.