Oracle 11g Express 설치!!!
Database/Oracle / 2012. 2. 2. 11:26
CentOS 6 에 오라클을 설치할 일이 생겨서 11g express 버전을 설치하였습니다.
다운로드
아래의 페이지에서 rpm 을 다운로드 받습니다.http://www.oracle.com/technetwork/database/express-edition/downloads/index.html
설치
다운로드 받은 패키지를 설치합니다. WAS 를 설치할 예정이라면 Oracle Application Express 포트를 적절하게 변경합니다.# rpm -ivh oracle-xe-11.2.0-1.0.x86_64.rpm
준비 중... ########################################### [100%]
1:oracle-xe ########################################### [100%]
Executing post-install steps...
You must run '/etc/init.d/oracle-xe configure' as the root user to configure the database.
# /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]:9090
Specify a port that will be used for the database listener [1521]: (enter)
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: (SYS, SYSTEM 패스워드 입력)
Confirm the password: (SYS, SYSTEM 패스워드 재입력)
Do you want Oracle Database 11g Express Edition to be started on boot (y/n) [y]: (enter)
Starting Oracle Net Listener...Done
Configuring database...Done
Starting Oracle Database 11g Express Edition instance...Done
Installation completed successfully.
준비 중... ########################################### [100%]
1:oracle-xe ########################################### [100%]
Executing post-install steps...
You must run '/etc/init.d/oracle-xe configure' as the root user to configure the database.
# /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]:9090
Specify a port that will be used for the database listener [1521]: (enter)
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: (SYS, SYSTEM 패스워드 입력)
Confirm the password: (SYS, SYSTEM 패스워드 재입력)
Do you want Oracle Database 11g Express Edition to be started on boot (y/n) [y]: (enter)
Starting Oracle Net Listener...Done
Configuring database...Done
Starting Oracle Database 11g Express Edition instance...Done
Installation completed successfully.
환경설정
express 버전은 환경 설정도 간단합니다.(bourne, bash, korn shell)
. /u01/app/oracle/product/11.2.0/xe/bin/oracle_env.sh
(c shell)
source /u01/app/oracle/product/11.2.0/xe/bin/oracle_env.csh
. /u01/app/oracle/product/11.2.0/xe/bin/oracle_env.sh
(c shell)
source /u01/app/oracle/product/11.2.0/xe/bin/oracle_env.csh
위의 환경설정이 각 쉘 시작시에도 실행될 수 있게 .bash_profile (bash) 이나 .bashrc 와 같은 파일에 추가합니다.
외부 연결 설정
오라클에서 사용하는 포트 1521 을 오픈하도록 설정을 합니다. 그 후 lsnrctl 명령을 이용하여 리스너가 정상적인지를 확인합니다.# system-config-firewall
# lsnrctl status
LSNRCTL for Linux: Version 11.2.0.2.0 - Production on 02-2월 -2012 14:08:28
Copyright (c) 1991, 2011, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC_FOR_XE)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 11.2.0.2.0 - Production
Start Date 02-2월 -2012 13:20:06
Uptime 0 days 0 hr. 48 min. 24 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Default Service XE
Listener Parameter File /u01/app/oracle/product/11.2.0/xe/network/admin/listener.ora
Listener Log File /u01/app/oracle/diag/tnslsnr/localhost/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC_FOR_XE)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost.localdomain)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost.localdomain)(PORT=9090))(Presentation=HTTP)(Session=RAW))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "XE" has 1 instance(s).
Instance "XE", status READY, has 1 handler(s) for this service...
Service "XEXDB" has 1 instance(s).
Instance "XE", status READY, has 1 handler(s) for this service...
The command completed successfully
# lsnrctl status
LSNRCTL for Linux: Version 11.2.0.2.0 - Production on 02-2월 -2012 14:08:28
Copyright (c) 1991, 2011, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC_FOR_XE)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 11.2.0.2.0 - Production
Start Date 02-2월 -2012 13:20:06
Uptime 0 days 0 hr. 48 min. 24 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Default Service XE
Listener Parameter File /u01/app/oracle/product/11.2.0/xe/network/admin/listener.ora
Listener Log File /u01/app/oracle/diag/tnslsnr/localhost/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC_FOR_XE)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost.localdomain)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost.localdomain)(PORT=9090))(Presentation=HTTP)(Session=RAW))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "XE" has 1 instance(s).
Instance "XE", status READY, has 1 handler(s) for this service...
Service "XEXDB" has 1 instance(s).
Instance "XE", status READY, has 1 handler(s) for this service...
The command completed successfully
설치부터 접속까지 10분 내로 처리되네요~ 계정을 생성하지 않아도 되고... 간단한 테스트 용도로는 XE 버전이 좋을 듯 합니다.
참고자료
http://docs.oracle.com/cd/E17781_01/install.112/e18802/toc.htm