[EC2] Ubuntu 오라클 11g XE 설치하기 (+환경변수)

1. Ubuntu 오라클 설치하기

*설치전에 EC2 서버 스왑 영역 만들기 (링크)

Oracle 다운로드

#로컬PC 파일을 ubuntu 서버로 업로드 하기
~$ scp -i 키파일.pem 업로드파일 ubuntu@IP주소:~
gen_inst.sql                                  100%   10KB  59.4KB/s   00:00    
.DS_Store                                     100% 6148    65.1KB/s   00:00    
xe.rsp                                        100% 2748    27.0KB/s   00:00    
oracle-xe-11.2.0-1.0.x86_64.rpm               100%  303MB 497.6KB/s   10:22

EC2 서버에 ssh 연결후 rpm -> deb 변환하기

#서버 접속하기
ubuntu:~$ ssh -i [키파일이름].pem ubuntu@[인스턴스 탄력IP]

#패키지 업데이트
ubuntu:~$ sudo apt update
ubuntu:~$ sudo apt upgrade

#파일변환을 위한 alien 설치
ubuntu:~$ sudo apt -y install alien libaio1 unixodbc

#업로드 폴더로 이동후 변환 (.rpm -> .deb)
ubuntu:~$ cd Disk1
ubuntu:~/Disk1$ ls
oracle-xe-11.2.0-1.0.x86_64.rpm  response  upgrade
ubuntu:~/Disk1$ sudo alien --scripts -d oracle*
oracle-xe_11.2.0-2_amd64.deb generated

deb 로 변환된 파일 설치하기

ubuntu:~$ sudo dpkg --install oracle*.deb


ubuntu:~$ sudo /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.
#포트번호 설정 8000으로 바꿔준다. (충돌방지)
Specify the HTTP port that will be used for Oracle Application Express [8080]:8000

#데이터베이스 리스너를 위한 포트를 지정 (기본값 1521) 
Specify a port that will be used for the database listener [1521]:

#system 계정의 비밀번호 설정 (꼭 외우자)
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:

#자동으로 오라클 실행할것인지 선택 (기본값 Y)
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.
#설치 완료

 

2. 오라클 사용하기 

환경변수

ubuntu:~$ sudo vi ~/.bashrc

#아래 설정을 넣어준다.
export ORACLE_HOME=/u01/app/oracle/product/11.2.0/xe 
export ORACLE_SID=XE 
export NLS_LANG=`$ORACLE_HOME/bin/nls_lang.sh` 
export ORACLE_BASE=/u01/app/oracle
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH 
export PATH=$ORACLE_HOME/bin:$PATH

ubuntu:~$ source ~/.bashrc

리스너 상태 확인하기 (successfully)

ubuntu:~$ lsnrctl status

LSNRCTL for Linux: Version 11.2.0.2.0 - Production on 27-NOV-2022 00:49:30

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                27-NOV-2022 00:42:13
Uptime                    0 days 0 hr. 7 min. 16 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/ip-172-31-12-203/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC_FOR_XE)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ip-172-31-12-203.ap-northeast-2.compute.internal)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ip-172-31-12-203.ap-northeast-2.compute.internal)(PORT=8000))(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

오라클 접속확인

#sqlplus를 실행하고 user-name에 system, password에 아까 설정한 비밀번호를 입력
ubuntu:~$ sqlplus

SQL*Plus: Release 11.2.0.2.0 Production on Sun Nov 27 00:55:59 2022

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

Enter user-name: system
Enter password: 

Connected to:
Oracle Database 11g Express Edition Release 11.2.0.2.0 - 64bit Production

SQL>

완료!😊 

 

 

 

참고1 : https://bantree.tistory.com/370

[Oracle] 우분투20.04 oracle 11gR2 설치

참고2 : https://thinmug.tistory.com/21

[리눅스] 오라클 Oracle 11g XE 설치