Solaris 11.4 oracle 19.5 설치

https://www.oracle.com/database/technologies/oracle19c-solarisx86-1950000-downloads.html

파일은 admin 계정에 업로드 한다.

환경 설정

#환경 확인

isainfo -kv
cat /etc/release

#swap 늘리기

zfs create -V 6G rpool/swap2
swap -a /dev/zvol/dsk/rpool/swap2
swap -l
vi /etc/vfstab   # 아래 줄 추가
/dev/zvol/dsk/rpool/swap2 - - swap - no -

#설치환경 확인

df -h

#hostname 확인 (솔라리스 설치할떄 설정한게 그대로 있음)

cat /etc/hosts

#nodename 에 hostname 등록

vi /etc/nodename

#locale확인 후 bash_profile 등록

locale
vi ~/.bash_profile
export LANG=ko_KR.UTF-8
export LC_ALL=ko_KR.UTF-8
export PS1='\u@\h:\w\$ '

. ~/.bash_profile

#oracle유저 생성 및 패스워드 설정

groupadd dba
useradd -g dba -G oinstall -m oracle
passwd oracle

비밀번호 Oracle#2025

#시스템 세팅

projadd -U oracle -K "project.max-shm-memory=(priv,4g,deny)" user.oracle

#패키지 설치

pkg set-publisher -Pe -O http://pkg.oracle.com/solaris/release solaris
pkg install compatibility/packages/SUNWxwplt SUNWmfrun SUNWarc SUNWhea SUNWlibm
pkg install assembler (보통 이미 설치되어 있음)
/usr/bin/pkg install pkg:/x11/library/libxp 
pkg update --accept

#디렉토리 생성

mkdir -p /oracle/app/oracle/product/19c/db_home
mkdir -p /oracle/app/oraInventory
mkdir /oradata
mkdir /oraarch
mkdir /oracd

#소유자 및 권한 변경

chown -R oracle:dba /oracle
chown -R oracle:dba /oradata
chown -R oracle:dba /oraarch
chown -R oracle:dba /oracd


chmod -R 775 /oracle
chown -R oracle:dba /ora*

#설치 디렉토리 생성 및 설치파일 압축해제
#admin 계정으로 설치파일 옮기기

root 계정으로 
cd /export/home/admin/
mv SOLARIS.X64_195000_db_home.zip /oracd
chown -R oracle:dba SOLARIS.X64_195000_db_home.zip
chown -R oracle:dba /oracd
su - oracle

여기서 홈 디렉토리가 없어서 만들어줌

mkdir -p /export/home/oracle
chown oracle:dba /export/home/oracle
chmod 755 /export/home/oracle

root@solaris:~# ls -ld /export/home/oracle
drwxr-xr-x   2 oracle   dba            2 5월 29 10:26 /export/home/oracle
---------------

su - oracle

unzip SOLARIS.X64_195000_db_home.zip -d /oracle/app/oracle/product/19c/db_home

• oracle 계정의 profile 변수를 저장

export ORACLE_HOSTNAME=test
export ORACLE_BASE=/oracle/app/oracle
export ORACLE_HOME=/oracle/app/oracle/product/19c/db_home
export ORACLE_SID=orcl
export LD_LIBRARY_PATH=$ORACLE_HOME/lib
export PATH=/usr/sbin:/usr/bin:$ORACLE_HOME/bin:$ORACLE_HOME/OPatch
export LANG=C

alias ss='sqlplus / as sysdba'

#명령어

cd ~/
vi .profile
source .profile

#설치 GUI 시작 oracle로 들어가라

cd $ORACLE_HOME
./runInstaller

patch

admin 에 파일 업로드 후 /oracd 로 옮기기

 cd /export/home/admin/
root@solaris:/export/home/admin# ls
p37642901_190000_Solaris86-64.zip  p6880880_190000_Solaris86-64.zip

 mv p37642901_190000_Solaris86-64.zip /oracd
 mv p6880880_190000_Solaris86-64.zip /oracd

cd /oracd
chown -R oracle:dba p37642901_190000_Solaris86-64.zip
chown -R oracle:dba p6880880_190000_Solaris86-64.zip

-bash-4.4$ cd /oracd
-bash-4.4$ ls -alrt
total 8547283
-rw-r--r--   1 oracle   dba      2893531744 May 29 08:09 SOLARIS.X64_195000_db_home.zip
drwxr-xr-x  28 root     sys           33 May 29 08:27 ..
-rw-r--r--   1 oracle   dba      78775478 May 29 11:33 p6880880_190000_Solaris86-64.zip
-rw-r--r--   1 oracle   dba      1400662862 May 29 11:43 p37642901_190000_Solaris86-64.zip
drwxr-xr-x   2 oracle   dba            5 May 29 11:47 .


cd $ORACLE_HOME/OPatch

$ opatch version
OPatch Version: 12.2.0.1.17

OPatch succeeded.

mv $ORACLE_HOME/OPatch $ORACLE_HOME/OPatch_OLD
unzip /oracd/p6880880_190000_Solaris86-64.zip -d $ORACLE_HOME

cd /oracd
unzip p37642901_190000_Solaris86-64.zip

실행조건 검사   < /oracd 에서
$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -ph ./37642901


cd 37642901
#####opatch apply      < /oracd/37642901 에서 
cd 37642901
$ORACLE_HOME/OPatch/opatch apply

########패치 완료 후 검사

$ORACLE_HOME/OPatch/opatch lspatches
$ORACLE_HOME/OPatch/opatch lsinventory

netca

lsnrctl start LISTENER_SOL
lsnrctl status LISTENER_SOL

dbca

캐릭터셋

swap 공간 부족하면 늘려주기

작아

키움

어떻게

zfs create -V 4G rpool/swap_extra
swap -a /dev/zvol/dsk/rpool/swap_extra
swap -l

완료

---

패치파일 다운

https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=355926925967749&id=2118136.2&_afrWindowMode=0&_adf.ctrl-state=awc57rhxu_30