경력만 많은 초보개발자

서버 재시작할때 자동으로 오라클이 올라오도록 설정.

1. oratab 수정

vi /etc/oratab
아래 구문을

orcl:/usr/oracle/app/product/12.2.0/dbhome_1:N
아래 처럼 수정
orcl:/usr/oracle/app/product/12.2.0/dbhome_1:Y

--------------------------------------------------------
파일 생성 1
--------------------------------------------------------
아래 파일을 추가 설치시 설정한 SID를 반영해야 한다.

# vi /etc/sysconfig/orcl.oracledb
아래 내용을 추가
설치시 설정한 경로 및 SID를 반영해야 한다.

# create new : define environment variables
ORACLE_BASE=/app/oracle
ORACLE_HOME=/app/oracle/product/11.2.0/dbhome_1
ORACLE_SID=orcl

--------------------------------------------------------
파일 생성 2
--------------------------------------------------------
아래 파일을 추가
설치시 설정한 SID를 반영해야 한다.

# vi /usr/lib/systemd/system/orcl@lsnrctl.service
# vi /usr/lib/systemd/system/lsnrctl.service
아래 내용을 추가
설치시 설정한 경로 및 SID를 반영해야 한다.

# this is an example, modify for free
[Unit]
Description=Oracle Net Listener
After=network.target
 
[Service]
Type=forking
EnvironmentFile=/etc/sysconfig/orcl.oracledb
ExecStart=/app/oracle/product/11.2.0/dbhome_1/bin/lsnrctl start
ExecStop=/app/oracle/product/11.2.0/dbhome_1/bin/lsnrctl stop
User=oracle
 
[Install]
WantedBy=multi-user.target

--------------------------------------------------------
파일 생성 3
--------------------------------------------------------
아래 파일을 추가
설치시 설정한 SID를 반영해야 한다.

vi /usr/lib/systemd/system/orcl@oracledb.service
vi /usr/lib/systemd/system/oracledb.service
아래 내용을 추가
설치시 설정한 경로 및 SID를 반영해야 한다.

# this is an example, modify for free
[Unit]
Description=Oracle Database service
After=network.target lsnrctl.service
 
[Service]
Type=forking
EnvironmentFile=/etc/sysconfig/orcl.oracledb
ExecStart=/app/oracle/product/11.2.0/dbhome_1/bin/dbstart $ORACLE_HOME
ExecStop=/app/oracle/product/11.2.0/dbhome_1/bin/dbshut $ORACLE_HOME
User=oracle
 
[Install]
WantedBy=multi-user.target


--------------------------------------------------------
자동 실행 등록
--------------------------------------------------------
systemctl daemon-reload
systemctl enable orcl@lsnrctl orcl@oracledb

systemctl enable lsnrctl oracledb