Skip to content

Instantly share code, notes, and snippets.

@dawud-tan

dawud-tan/setup_fedora_oracle.md

Created June 20, 2022 05:29
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save dawud-tan/e3a98ff6414eb4b3768e8c3606eb7b0c to your computer and use it in GitHub Desktop.
Save dawud-tan/e3a98ff6414eb4b3768e8c3606eb7b0c to your computer and use it in GitHub Desktop.
Download ZIP
setup_fedora_oracle.md
Raw
setup_fedora_oracle.md

Pengaturan Oracle di Fedora 23.0 setelah berhasil dipasang

Oracle 11gR2 (11.2.0.1) versi 64-bit

konfigurasi jaringan

[root ~]# vi /etc/sysconfig/network-scripts/ifcfg-enp0s20f0u6c2
[root ~]# Alt + i
DEVICE=enp0s20f0u6c2
BOOTPROTO=none
ONBOOT=yes
NETMASK=255.255.255.240
IPADDR=183.81.158.230
GATEWAY=183.81.158.225 
DNS1=203.160.56.18
PEERDNS=yes
USERCTL=no
[root ~]# Ctrl + [ :x
[root ~]# vi /etc/sysconfig/network-scripts/ifcfg-enp0s20f0u4
[root ~]# Alt + i
DEVICE=enp0s20f0u4
BOOTPROTO=none
ONBOOT=yes
NETMASK=255.255.255.0
IPADDR=10.109.10.245
USERCTL=no
[root ~]# Ctrl + [ :x
[root ~]# vi /etc/sysconfig/network-scripts/route-enp0s20f0u4
[root ~]# Alt + i
10.0.0.0/8 via 10.109.10.1 dev enp0s20f0u4
[root ~]# Ctrl + [ :x

restart pengaturan jaringan

[root ~]# ifdown enp0s20f0u4
[root ~]# ifdown enp0s20f0u6c2
[root ~]# ifup enp0s20f0u4
[root ~]# ifup enp0s20f0u6c2

modifikasi pengaturan repo:

adoptium.repo

dependensi yang diinstal ikuti yang langkah berikut ini:

[root ~]# wget https://yum.oracle.com/repo/OracleLinux/OL7/latest/x86_64/getPackage/compat-libcap1-1.10-7.el7.x86_64.rpm
[root ~]# dnf install ./compat-libcap1-1.10-7.el7.x86_64.rpm
[root ~]# dnf install bc bind-utils binutils compat-libstdc++-33 compat-libstdc++-33.i686 elfutils-libelf-devel ethtool gcc gcc-c++ glibc glibc-common glibc-devel glibc-devel.i686 glibc-headers glibc.i686 initscripts ksh libaio libaio-devel libaio-devel.i686 libaio.i686 libgcc libgcc.i686 libstdc++ libstdc++-devel libstdc++-devel.i686 libstdc++.i686 make module-init-tools nfs-utils numactl numactl-devel openssh-clients pam procps psmisc smartmontools sysstat unixODBC unixODBC-devel unixODBC-devel.i686 unixODBC.i686 util-linux-ng xorg-x11-utils xorg-x11-xauth
[root ~]# wget https://yum.oracle.com/repo/OracleLinux/OL7/latest/x86_64/getPackage/oracle-rdbms-server-11gR2-preinstall-1.0-6.el7.x86_64.rpm
[root ~]# mkdir -p oracle-rdbms-server-11gR2-preinstall-1.0-6
[root ~]# cd oracle-rdbms-server-11gR2-preinstall-1.0-6/
[root ~]# rpm2cpio ../oracle-rdbms-server-11gR2-preinstall-1.0-6.el7.x86_64.rpm | cpio -idmv
[root ~]# cd ./etc/sysconfig/oracle-rdbms-server-11gR2-preinstall
[root ~]# chmod 744 oracle-rdbms-server-11gR2-preinstall-verify
[root ~]# ./oracle-rdbms-server-11gR2-preinstall-verify
[root ~]# mkdir -p /u01/app/oracle/product/11.2.0/dbhome_1
[root ~]# mkdir /u01/software
[root ~]# mv /home/pkras/Unduhan/V17530* /u01/software/
[root ~]# chown -R oracle:oinstall /u01
[root ~]# chmod -R 775 /u01
[root ~]# mkdir -p /u02/oradata
[root ~]# chown -R oracle:dba /u02

tambahkan baris berikut ke dalam file /etc/pam.d/login

session    required     pam_limits.so

penambahan aturan firewall dan simpan pengaturan firewall-cmd joon

[root ~]# firewall-cmd --zone=public --add-port=80/tcp --permanent #untuk tomcat
[root ~]# firewall-cmd --zone=public --add-port=1521/tcp --permanent #untuk port oracle
[root ~]# firewall-cmd --zone=public --add-port=22/tcp --permanent #untuk port ssh server
[root ~]# firewall-cmd --reload

perintah untuk memasang akses ssh

[root ~]# yum install openssh-server

batasi akses ssh server

[root ~]# nano /etc/ssh/sshd_config
AllowUsers      pkras dawud_tan
DenyUsers       oracle

enable the ssh server on reboot

[root ~]# systemctl enable sshd.service

sunting berkas /etc/redhat-release

[root ~]# vi /etc/redhat-release
redhat release 6

pengaturan berkas db_install.rsp dengan pengguna oracle ($)

[oracle ~]$ vi /u01/software/database/response/db_install.rsp
oracle.install.option=INSTALL_DB_SWONLY
ORACLE_HOSTNAME=dbupgrade
UNIX_GROUP_NAME=oinstall
INVENTORY_LOCATION=/u01/app/oraInventory/
SELECTED_LANGUAGES=en
ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1
ORACLE_BASE=/u01/app/oracle
oracle.install.db.InstallEdition=EE
oracle.install.db.DBA_GROUP=dba
oracle.install.db.OPER_GROUP=dba
oracle.install.db.config.starterdb.characterSet=AL32UTF8
oracle.install.db.config.starterdb.memoryOption=true
SECURITY_UPDATES_VIA_MYORACLESUPPORT=false
DECLINE_SECURITY_UPDATES=true

memasang oracle software (only) in silent mode:

[oracle ~]$ ./runInstaller -ignorePrereq -waitforcompletion -silent  -responseFile /u01/software/database/response/db_install.rsp

Execute orainstRoot.sh and root.sh script from ROOT (#) user:

[root ~]# /u01/app/oracle/product/11.2.0/dbhome_1/root.sh

Menambahkan environment variable di /home/oracle/.bashrc

[oracle ~]$ vi /home/oracle/.bashrc
export ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1
export ORACLE_SID=PKRAS
export PATH=$PATH:/u01/app/oracle/product/11.2.0/dbhome_1/bin
[oracle ~]$ source /home/oracle/.bashrc
[oracle ]$ dbca -silent -createDatabase -templatename General_Purpose.dbc -gdbname PKRAS -sid PKRAS -datafileDestination /u02/oradata/PKRAS -emConfiguration none -syspassword sandi123 -systempassword sandi123

Edit the "/etc/redhat-release"

[root ~]# vi /etc/redhat-release
Fedora release 23 (Twenty Three)

sunting berkas listener.ora

[oracle ]$ vi $ORACLE_HOME/network/admin/listener.ora
LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 0.0.0.0)(PORT = 1521))
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
    )
  )

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (GLOBAL_DBNAME = PKRAS)
        (SID_NAME = PKRAS)
        (ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1 )
    )
  )

berikan ruang cukup

[root ~]# vi /etc/fstab
tmpfs      /dev/shm      tmpfs   defaults,size=6g   0   0

Menjalankan perintah berikut di terminal:

[oracle ]$ lsnrctl start LISTENER
[oracle ]$ sqlplus / as sysdba
SQL> startup
SQL> exit
[oracle ]$ sqlplus SYS/sandi123@127.0.0.1/PKRAS as sysdba
SQL> startup
SQL> exit

eksekusi sql untuk berikan hak akses

SQL> CREATE USER PKRAS IDENTIFIED BY pkid123456 DEFAULT TABLESPACE USERS QUOTA UNLIMITED ON USERS;
SQL> GRANT CREATE SESSION, CREATE PUBLIC DATABASE LINK, DROP PUBLIC DATABASE LINK, CREATE TABLE, CREATE VIEW, CREATE PROCEDURE, CREATE SEQUENCE TO PKRAS;
SQL> ALTER USER PKRAS QUOTA UNLIMITED ON USERS;
SQL> exit
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment