Embedded Files
Tôi mới thử thực hiện việc cài đặt oracle APEX kết hợp sử dụng Oracle Rest Data service, ghi lại mấy thông tin để sau này nhớ sử dụng lại nếu cần.
----------------------------------------------------------------
1. Tạo máy ảo 1
2. Cài đặt Oracle Linux
3. Cài đặt Prerequirement Oracle
4. Clone Disk
5. tạo máy ảo 2
6. Thiết lập thông tin trên máy 1 và máy 2
7. Add Shared disk ASM (asm1)
ls /dev/sd*
fdisk /dev/sdb
n
enter (p)
enter (1)
enter
enter
w
enter
7. Cài đặt Oracle Grid (sys / Orcl$$1234)
8. Cài đặt Oracle Database
9. Tạo cơ sở dữ liệu
10. Enable TDE Cơ sở dữ liệu
-----------------------------
11. Cài đặt và config Oracle Apex
-----------------------------
12. Cài đặt Oracle BI Publisher
13. Enable SSL weblogic BI Publisher
14. Cài đặt và config ords 18
-----------------------------
-------- Mô tả các bước thực hiện ------------------------------
mount dvd and set local yum
mount /dev/sr0 /media/OL7U3
cd /etc/yum.repos.d/
mkdir org
mv * org/*
vi OL73.repo
[OL77]
name=Oracle Linux 7.7 x86_64
baseurl=file:///media/OL7U7
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY
gpgcheck=1
enabled=1
:wq!
----------------------------------------------------------------
bước 1: Tạo máy ảo ords1
- Thông số chung
+ RAM = 10Gb
+ CPU = 2
+ LocalDisk = 100Gb
+ Pointing Device = USB Tablet
- Network:
+ NAT network = 10.1.5.11 - private & ASM
+ NAT network = 10.1.7.11 - public
bước 2: Cài đặt oracle linux 7 update 6
- Format disk:
+ Swap = 16Gb
+ home = 5Gb
+ boot = 1Gb
+ root (/) = 78Gb
- Cài đặt Add-in VirtualBox
+
- Mount DVD:
+
Bước 3: Chuẩn bị cài đặt Oracle Grid và Oracle Database
----------------------------------------------------------------
------- Note chi tiết-------------------------------------------
----------------------------------------------------------------
Completed:
rpm -ivh binutils-2.27-34.base.0.1.el7.x86_64.rpm
rpm -ivh compat-libstdc++-33-3.2.3-72.el7.x86_64.rpm
rpm -ivh gcc-4.8.5-36.0.1.el7.x86_64
rpm -ivh gcc-c++-4.8.5-36.0.1.el7.x86_64
rpm -ivh glibc-2.17-260.0.9.el7.x86_64
rpm -ivh glibc-devel-2.17-260.0.9.el7.x86_64.rpm
rpm -ivh ksh-20120801-139.0.1.el7.x86_64.rpm
rpm -ivh libstdc++-4.8.5-36.0.1.el7.x86_64.rpm
rpm -ivh libstdc++-devel-4.8.5-36.0.1.el7.x86_64.rpm
rpm -ivh libaio-0.3.109-13.el7.x86_64.rpm
rpm -ivh libaio-devel-0.3.109-13.el7.x86_64.rpm
rpm -ivh libaio-0.3.109-13.el7.i686.rpm
rpm -ivh libaio-devel-0.3.109-13.el7.i686.rpm
rpm -ivh libXext-1.3.3-3.el7.x86_64.rpm
rpm -ivh libXtst-1.2.3-1.el7.x86_64.rpm
rpm -ivh libX11-1.6.5-2.el7.x86_64.rpm
rpm -ivh libXau-1.0.8-2.1.el7.x86_64.rpm
rpm -ivh libxcb-1.13-1.el7.x86_64.rpm
rpm -ivh libXi-1.7.9-1.el7.x86_64.rpm
rpm -ivh make-3.82-23.el7.x86_64.rpm
rpm -ivh sysstat-10.1.5-17.el7.x86_64.rpm
rpm -ivh unixODBC-2.3.1-11.el7.x86_64.rpm
rpm -ivh unixODBC-devel-2.3.1-11.el7.x86_64.rpm
rpm -ivh zlib-devel-1.2.7-18.el7.x86_64.rpm
false:
rpm -ivh compat-libstdc++-33-3.2.3-72.el7.i686.rpm --nodeps
rpm -ivh glibc-2.17-260.0.9.el7.i686 --nodeps
rpm -ivh glibc-devel-2.17-260.0.9.el7.i686.rpm --nodeps
rpm -ivh libstdc++-4.8.5-36.0.1.el7.i686.rpm --nodeps
rpm -ivh libstdc++-devel-4.8.5-36.0.1.el7.i686.rpm --nodeps
rpm -ivh libXext-1.3.3-3.el7.i686.rpm --nodeps
rpm -ivh libXtst-1.2.3-1.el7.i686.rpm --nodeps
rpm -ivh libX11-1.6.5-2.el7.i686.rpm --nodeps
rpm -ivh libXau-1.0.8-2.1.el7.i686.rpm --nodeps
rpm -ivh libxcb-1.13-1.el7.i686.rpm --nodeps
rpm -ivh libXi-1.7.9-1.el7.i686.rpm --nodeps
rpm -ivh zlib-devel-1.2.7-18.el7.i686.rpm --nodeps
------------------------------------------------------------
vi /etc/hosts:
127.0.0.1 localhost.localdomain localhost
# Public
10.1.7.11 ords1.localdomain ords1
10.1.7.12 ords2.localdomain ords2
# Private
10.1.5.11 ords1-priv.localdomain ords1-priv
10.1.5.12 ords2-priv.localdomain ords2-priv
# Virtual
10.1.7.13 ords1-vip.localdomain ords1-vip
10.1.7.14 ords2-vip.localdomain ords2-vip
# SCAN
10.1.7.15 ords-scan.localdomain ords-scan
10.1.7.16 ords-scan.localdomain ords-scan
10.1.7.17 ords-scan.localdomain ords-scan
--------------------------------
vi /etc/resolv.conf
# Generated by NetworkManager
search localdomain
nameserver 10.1.7.1
#nameserver 10.1.6.31
#nameserver 10.1.6.32
#nameserver 10.2.6.11
# NOTE: the libc resolver may not support more than 3 nameservers.
# The nameservers listed below may not be recognized.
#nameserver 10.2.6.13
--------------------------------
chattr +i /etc/resolv.conf
Neu can sua noi dung file nay: chattr -i /etc/resolv.conf
--------------------------------
vi /etc/selinux/config
SELINUX=permissive
--------------------------------
systemctl stop firewalld
systemctl disable firewalld
--------------------------------
systemctl enable chronyd
systemctl restart chronyd
chronyc -a 'burst 4/4'
chronyc -a makestep
-------------------------------
groupadd -g 54321 oinstall
groupadd -g 54322 dba
groupadd -g 54323 oper
groupadd -g 54324 backupdba
groupadd -g 54325 dgdba
groupadd -g 54326 kmdba
groupadd -g 54327 asmdba
groupadd -g 54328 asmoper
groupadd -g 54329 asmadmin
groupadd -g 54330 racdba
useradd -u 54321 -g oinstall -G dba,oper,backupdba,dgdba,kmdba,asmdba,asmoper,asmadmin,racdba,vboxsf oracle
passwd oracle
----------------------------------------------------------------------------------------------------
-------------------------------
mkdir -p /u01/app/19.3.0/grid
mkdir -p /u01/app/oracle/product/19.3.0/db_1
chown -R oracle:oinstall /u01
chmod -R 775 /u01/
-------------------------------
# Oracle Settings
export TMP=/tmp
export TMPDIR=$TMP
export ORACLE_HOSTNAME=rac19c1
export ORACLE_UNQNAME=CDB19
export ORACLE_BASE=/u01/app/oracle
export GRID_HOME=/u01/app/19.3.0/grid
export DB_HOME=$ORACLE_BASE/product/19.3.0/db_1
export ORACLE_HOME=$DB_HOME
export ORACLE_SID=cdb191
export ORACLE_TERM=xterm
export BASE_PATH=/usr/sbin:$PATH
export PATH=$ORACLE_HOME/bin:$BASE_PATH
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib
export CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib
alias grid='. /home/oracle/bin/grid'
alias db='. /home/oracle/bin/db'
-------------------------------
vi /home/oracle/grid_env
export ORACLE_SID=+ASM2
export ORACLE_HOME=$GRID_HOME
export PATH=$ORACLE_HOME/bin:$BASE_PATH
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib
export CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib
-------------------------------
vi /home/oracle/db_env
export ORACLE_SID=cdb192
export ORACLE_HOME=$DB_HOME
export PATH=$ORACLE_HOME/bin:$BASE_PATH
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib
export CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib
-------------------------------
node 1:vi /etc/hostname
ords1
node 2:vi /etc/hostname
ords2
--------------------------------------------------------
[root@rac19c1 u01]# fdisk /dev/sdb
Welcome to fdisk (util-linux 2.23.2).
Changes will remain in memory only, until you decide to write them.
Be careful before using the write command.
Device does not contain a recognized partition table
Building a new DOS disklabel with disk identifier 0x87d6aa60.
Command (m for help): n
Partition type:
p primary (0 primary, 0 extended, 4 free)
e extended
Select (default p): p
Partition number (1-4, default 1):
First sector (2048-1048575, default 2048):
Using default value 2048
Last sector, +sectors or +size{K,M,G} (2048-1048575, default 1048575):
Using default value 1048575
Partition 1 of type Linux and of size 511 MiB is set
Command (m for help): w
The partition table has been altered!
Calling ioctl() to re-read partition table.
Syncing disks.
[root@rac19c1 u01]# fdisk /dev/sdc
Welcome to fdisk (util-linux 2.23.2).
Changes will remain in memory only, until you decide to write them.
Be careful before using the write command.
Device does not contain a recognized partition table
Building a new DOS disklabel with disk identifier 0x6b492e5a.
Command (m for help): n
Partition type:
p primary (0 primary, 0 extended, 4 free)
e extended
Select (default p): p
Partition number (1-4, default 1):
First sector (2048-2097151, default 2048):
Using default value 2048
Last sector, +sectors or +size{K,M,G} (2048-2097151, default 2097151):
Using default value 2097151
Partition 1 of type Linux and of size 1023 MiB is set
Command (m for help): w
The partition table has been altered!
Calling ioctl() to re-read partition table.
Syncing disks.
[root@rac19c1 u01]# fdisk /dev/sdd
Welcome to fdisk (util-linux 2.23.2).
Changes will remain in memory only, until you decide to write them.
Be careful before using the write command.
Device does not contain a recognized partition table
Building a new DOS disklabel with disk identifier 0x47ed8d80.
Command (m for help): n
Partition type:
p primary (0 primary, 0 extended, 4 free)
e extended
Select (default p): p
Partition number (1-4, default 1):
First sector (2048-2097151, default 2048):
Using default value 2048
Last sector, +sectors or +size{K,M,G} (2048-2097151, default 2097151):
Using default value 2097151
Partition 1 of type Linux and of size 1023 MiB is set
Command (m for help): w
The partition table has been altered!
Calling ioctl() to re-read partition table.
Syncing disks.
[root@rac19c1 u01]# ls -l /dev/sd*
brw-rw----. 1 root disk 8, 0 Feb 26 08:03 /dev/sda
brw-rw----. 1 root disk 8, 1 Feb 26 08:03 /dev/sda1
brw-rw----. 1 root disk 8, 2 Feb 26 08:03 /dev/sda2
brw-rw----. 1 root disk 8, 16 Feb 26 13:11 /dev/sdb
brw-rw----. 1 root disk 8, 17 Feb 26 13:11 /dev/sdb1
brw-rw----. 1 root disk 8, 32 Feb 26 13:12 /dev/sdc
brw-rw----. 1 root disk 8, 33 Feb 26 13:12 /dev/sdc1
brw-rw----. 1 root disk 8, 48 Feb 26 13:12 /dev/sdd
brw-rw----. 1 root disk 8, 49 Feb 26 13:12 /dev/sdd1
brw-rw----. 1 root disk 8, 64 Feb 26 08:03 /dev/sde
brw-rw----. 1 root disk 8, 80 Feb 26 08:03 /dev/sdf
brw-rw----. 1 root disk 8, 96 Feb 26 08:03 /dev/sdg
brw-rw----. 1 root disk 8, 112 Feb 26 08:03 /dev/sdh
[root@rac19c1 u01]# fdisk /dev/sde
Welcome to fdisk (util-linux 2.23.2).
Changes will remain in memory only, until you decide to write them.
Be careful before using the write command.
Device does not contain a recognized partition table
Building a new DOS disklabel with disk identifier 0x6dffa620.
Command (m for help): n
Partition type:
p primary (0 primary, 0 extended, 4 free)
e extended
Select (default p): p
Partition number (1-4, default 1):
First sector (2048-104857599, default 2048):
Using default value 2048
Last sector, +sectors or +size{K,M,G} (2048-104857599, default 104857599):
Using default value 104857599
Partition 1 of type Linux and of size 50 GiB is set
Command (m for help): w
The partition table has been altered!
Calling ioctl() to re-read partition table.
Syncing disks.
[root@rac19c1 u01]# ls -l /dev/sd*
brw-rw----. 1 root disk 8, 0 Feb 26 08:03 /dev/sda
brw-rw----. 1 root disk 8, 1 Feb 26 08:03 /dev/sda1
brw-rw----. 1 root disk 8, 2 Feb 26 08:03 /dev/sda2
brw-rw----. 1 root disk 8, 16 Feb 26 13:11 /dev/sdb
brw-rw----. 1 root disk 8, 17 Feb 26 13:11 /dev/sdb1
brw-rw----. 1 root disk 8, 32 Feb 26 13:12 /dev/sdc
brw-rw----. 1 root disk 8, 33 Feb 26 13:12 /dev/sdc1
brw-rw----. 1 root disk 8, 48 Feb 26 13:12 /dev/sdd
brw-rw----. 1 root disk 8, 49 Feb 26 13:12 /dev/sdd1
brw-rw----. 1 root disk 8, 64 Feb 26 13:13 /dev/sde
brw-rw----. 1 root disk 8, 65 Feb 26 13:13 /dev/sde1
brw-rw----. 1 root disk 8, 80 Feb 26 08:03 /dev/sdf
brw-rw----. 1 root disk 8, 96 Feb 26 08:03 /dev/sdg
brw-rw----. 1 root disk 8, 112 Feb 26 08:03 /dev/sdh
[root@rac19c1 u01]# fdisk /dev/sdf
Welcome to fdisk (util-linux 2.23.2).
Changes will remain in memory only, until you decide to write them.
Be careful before using the write command.
Device does not contain a recognized partition table
Building a new DOS disklabel with disk identifier 0x45e5e404.
Command (m for help): n
Partition type:
p primary (0 primary, 0 extended, 4 free)
e extended
Select (default p): p
Partition number (1-4, default 1):
First sector (2048-104857599, default 2048):
Using default value 2048
Last sector, +sectors or +size{K,M,G} (2048-104857599, default 104857599):
Using default value 104857599
Partition 1 of type Linux and of size 50 GiB is set
Command (m for help): w
The partition table has been altered!
Calling ioctl() to re-read partition table.
Syncing disks.
[root@rac19c1 u01]# ls -l /dev/sd*
brw-rw----. 1 root disk 8, 0 Feb 26 08:03 /dev/sda
brw-rw----. 1 root disk 8, 1 Feb 26 08:03 /dev/sda1
brw-rw----. 1 root disk 8, 2 Feb 26 08:03 /dev/sda2
brw-rw----. 1 root disk 8, 16 Feb 26 13:11 /dev/sdb
brw-rw----. 1 root disk 8, 17 Feb 26 13:11 /dev/sdb1
brw-rw----. 1 root disk 8, 32 Feb 26 13:12 /dev/sdc
brw-rw----. 1 root disk 8, 33 Feb 26 13:12 /dev/sdc1
brw-rw----. 1 root disk 8, 48 Feb 26 13:12 /dev/sdd
brw-rw----. 1 root disk 8, 49 Feb 26 13:12 /dev/sdd1
brw-rw----. 1 root disk 8, 64 Feb 26 13:13 /dev/sde
brw-rw----. 1 root disk 8, 65 Feb 26 13:13 /dev/sde1
brw-rw----. 1 root disk 8, 80 Feb 26 13:13 /dev/sdf
brw-rw----. 1 root disk 8, 81 Feb 26 13:13 /dev/sdf1
brw-rw----. 1 root disk 8, 96 Feb 26 08:03 /dev/sdg
brw-rw----. 1 root disk 8, 112 Feb 26 08:03 /dev/sdh
[root@rac19c1 u01]# fdisk /dev/sdg
Welcome to fdisk (util-linux 2.23.2).
Changes will remain in memory only, until you decide to write them.
Be careful before using the write command.
Device does not contain a recognized partition table
Building a new DOS disklabel with disk identifier 0x6d5d25c7.
Command (m for help): n
Partition type:
p primary (0 primary, 0 extended, 4 free)
e extended
Select (default p): p
Partition number (1-4, default 1):
First sector (2048-20971519, default 2048):
Using default value 2048
Last sector, +sectors or +size{K,M,G} (2048-20971519, default 20971519):
Using default value 20971519
Partition 1 of type Linux and of size 10 GiB is set
Command (m for help): w
The partition table has been altered!
Calling ioctl() to re-read partition table.
Syncing disks.
[root@rac19c1 u01]# fdisk /dev/sdh
Welcome to fdisk (util-linux 2.23.2).
Changes will remain in memory only, until you decide to write them.
Be careful before using the write command.
Device does not contain a recognized partition table
Building a new DOS disklabel with disk identifier 0x935a4e10.
Command (m for help): n
Partition type:
p primary (0 primary, 0 extended, 4 free)
e extended
Select (default p): p
Partition number (1-4, default 1):
First sector (2048-20971519, default 2048):
Using default value 2048
Last sector, +sectors or +size{K,M,G} (2048-20971519, default 20971519):
Using default value 20971519
Partition 1 of type Linux and of size 10 GiB is set
Command (m for help): w
The partition table has been altered!
Calling ioctl() to re-read partition table.
Syncing disks.
[root@rac19c1 u01]# ls -l /dev/sd*
brw-rw----. 1 root disk 8, 0 Feb 26 08:03 /dev/sda
brw-rw----. 1 root disk 8, 1 Feb 26 08:03 /dev/sda1
brw-rw----. 1 root disk 8, 2 Feb 26 08:03 /dev/sda2
brw-rw----. 1 root disk 8, 16 Feb 26 13:11 /dev/sdb
brw-rw----. 1 root disk 8, 17 Feb 26 13:11 /dev/sdb1
brw-rw----. 1 root disk 8, 32 Feb 26 13:12 /dev/sdc
brw-rw----. 1 root disk 8, 33 Feb 26 13:12 /dev/sdc1
brw-rw----. 1 root disk 8, 48 Feb 26 13:12 /dev/sdd
brw-rw----. 1 root disk 8, 49 Feb 26 13:12 /dev/sdd1
brw-rw----. 1 root disk 8, 64 Feb 26 13:13 /dev/sde
brw-rw----. 1 root disk 8, 65 Feb 26 13:13 /dev/sde1
brw-rw----. 1 root disk 8, 80 Feb 26 13:13 /dev/sdf
brw-rw----. 1 root disk 8, 81 Feb 26 13:13 /dev/sdf1
brw-rw----. 1 root disk 8, 96 Feb 26 13:13 /dev/sdg
brw-rw----. 1 root disk 8, 97 Feb 26 13:13 /dev/sdg1
brw-rw----. 1 root disk 8, 112 Feb 26 13:14 /dev/sdh
brw-rw----. 1 root disk 8, 113 Feb 26 13:14 /dev/sdh1
--------------------------------------------------------
oracleasm configure -i
oracleasm createdisk vote /dev/sdb1
oracleasm createdisk redo1 /dev/sdc1
oracleasm createdisk redo2 /dev/sdd1
oracleasm createdisk data1 /dev/sde1
oracleasm createdisk data2 /dev/sdf1
oracleasm createdisk arch1 /dev/sdg1
oracleasm createdisk arch2 /dev/sdh1
-------------------------------
E:
cd E:\Lab
"c:\Program Files\Oracle\VirtualBox\VBoxManage" createhd --filename asm1.vdi --size 102400 --format VDI --variant Fixed
"c:\Program Files\Oracle\VirtualBox\VBoxManage" createhd --filename asm2.vdi --size 102400 --format VDI --variant Fixed
"c:\Program Files\Oracle\VirtualBox\VBoxManage" createhd --filename asm3.vdi --size 102400 --format VDI --variant Fixed
"c:\Program Files\Oracle\VirtualBox\VBoxManage" createhd --filename asm4.vdi --size 102400 --format VDI --variant Fixed
E:\Lab\shared\asm2.vdi
-------------------------------
---- clone Local disk
-------------------------------
"c:\Program Files\Oracle\VirtualBox\VBoxManage" clonehd "E:\Lab\ords1\ords1.vdi" "E:\Lab\ords2\ords2.vdi"
-------------------------------
sửa /etc/hostname
ords1 => ords2
-------------------------------
completed install oracle database
-------------------------------
-- Cai dat apex 5.1.4
-------------------------------
copy thu muc apex da giai nen vào /u01/app/oracle/apex5.1.4/
-------------------------------
cd /u01/app/oracle/apex5.1.4/apex/
sqlplus / as sysdba
alter session set container=ords;
@apxins.sql SYSAUX SYSAUX TEMP /i/
------completed-----------------------
SELECT DBMS_XDB.gethttpport FROM DUAL;
GETHTTPPORT
———–
0
EXEC DBMS_XDB.sethttpport(8080);
EXEC DBMS_XDB.sethttpport(8081);
SELECT DBMS_XDB.gethttpport FROM DUAL;
GETHTTPPORT
———–
8080
sqlplus / as sysdba
ALTER USER XDB ACCOUNT UNLOCK;
alter session set container=ords;
ALTER USER APEX_PUBLIC_USER ACCOUNT UNLOCK;
ALTER USER ANONYMOUS ACCOUNT UNLOCK;
ALTER USER FLOWS_FILES ACCOUNT UNLOCK;
ALTER USER APEX_INSTANCE_ADMIN_USER ACCOUNT UNLOCK;
exec dbms_xdb_config.SetGlobalPortEnabled(TRUE);
EXEC DBMS_XDB.sethttpport(8080);
ALTER USER ANONYMOUS ACCOUNT UNLOCK;
ALTER USER XDB ACCOUNT UNLOCK;
ALTER USER ANONYMOUS IDENTIFIED BY anonymous;
ALTER USER XDB IDENTIFIED BY xdb;
--------------------------------------------
@apex_rest_config.sql
--------------- password: Orcl$$1234------------------------------------------------
-------------------------------------------------------------------------------------
/home/oracle/java/jdk1.8.0_202
[oracle@ords2 params]$ cd ..
[oracle@ords2 ords18]$ ls
docs examples index.html logs ords.war params
[oracle@ords2 ords18]$ $JAVA_HOME/bin/java -jar ords.war
This Oracle REST Data Services instance has not yet been configured.
Please complete the following prompts
Enter the location to store configuration data:/u01/app/oracle/ords18/
Enter the name of the database server [localhost]:ords-scan
Enter the database listen port [1521]:
Enter 1 to specify the database service name, or 2 to specify the database SID [1]:
Enter the database service name:ords
Enter the database password for ORDS_PUBLIC_USER:
Confirm password:
Requires SYS AS SYSDBA to verify Oracle REST Data Services schema.
Enter the database password for SYS AS SYSDBA:
Confirm password:
Retrieving information.
Enter 1 if you want to use PL/SQL Gateway or 2 to skip this step.
If using Oracle Application Express or migrating from mod_plsql then you must enter 1 [1]:
Enter the database password for APEX_PUBLIC_USER:
Confirm password:
Enter 1 to specify passwords for Application Express RESTful Services database users (APEX_LISTENER, APEX_REST_PUBLIC_USER) or 2 to skip this step [1]:
Enter the database password for APEX_LISTENER:
Confirm password:
Enter the database password for APEX_REST_PUBLIC_USER:
Confirm password:
Aug 14, 2019 4:08:47 PM
INFO: Updated configurations: defaults, apex, apex_pu, apex_al, apex_rt
Installing Oracle REST Data Services version 18.1.1.95.1251
... Log file written to /u01/app/oracle/ords18/logs/ords_install_core_2019-08-14_160847_00507.log
... Verified database prerequisites
... Created Oracle REST Data Services schema
... Created Oracle REST Data Services proxy user
... Granted privileges to Oracle REST Data Services
... Created Oracle REST Data Services database objects
... Log file written to /u01/app/oracle/ords18/logs/ords_install_datamodel_2019-08-14_160920_00953.log
... Log file written to /u01/app/oracle/ords18/logs/ords_install_apex_2019-08-14_160924_00919.log
Completed installation for Oracle REST Data Services version 18.1.1.95.1251. Elapsed time: 00:00:41.431
Enter 1 if you wish to start in standalone mode or 2 to exit [1]:2
[oracle@ords2 ords18]$
[oracle@ords2 ords18]$
[oracle@ords2 ords18]$ ls
cfg docs examples index.html logs ords ords.war params
[oracle@ords2 ords18]$ cd params/
[oracle@ords2 params]$ ls
ords_params.properties
[oracle@ords2 params]$ ll
total 4
-rw-r--r--. 1 oracle oinstall 681 Aug 14 16:10 ords_params.properties
[oracle@ords2 params]$ cat ords_params.properties
#Wed Aug 14 16:10:32 ICT 2019
db.hostname=ords-scan
db.password=@050D22296F535FFF8ABA07BA2E1763B27F8F57A99110015D68
db.port=1521
db.servicename=ords
db.username=APEX_PUBLIC_USER
migrate.apex.rest=false
plsql.gateway.add=true
rest.services.apex.add=true
rest.services.ords.add=true
schema.tablespace.default=SYSAUX
schema.tablespace.temp=TEMP
standalone.http.port=8080
standalone.mode=false
user.apex.listener.password=@052F43C3DE1739D3A78028BE96EE3006AAED152C71B67E660A
user.apex.restpublic.password=@057B17191C46E41FFF63D3280D10FF5F3DBE4A77608993EA97
user.public.password=@05E880214C002087C20B97FC56E666C7BED5DAAC4845C05636
user.tablespace.default=USERS
user.tablespace.temp=TEMP
[oracle@ords2 params]$ cd ..
[oracle@ords2 ords18]$ ls
cfg docs examples index.html logs ords ords.war params
[oracle@ords2 ords18]$ cd cfg
[oracle@ords2 cfg]$ ls
[oracle@ords2 cfg]$ cd ..
[oracle@ords2 ords18]$ ls
cfg docs examples index.html logs ords ords.war params
[oracle@ords2 ords18]$ rm -rf cfg
[oracle@ords2 ords18]$ ls
docs examples index.html logs ords ords.war params
[oracle@ords2 ords18]$ pwd
/u01/app/oracle/ords18
[oracle@ords2 ords18]$
------------------------------------------------------------------------------------------
-- defaults.xml
<entry key="db.connectionType">customurl</entry>
<entry key="db.customURL">jdbc:oracle:thin:@(DESCRIPTION=(FAILOVER=ON)(ADDRESS_LIST=
(LOAD_BALANCE=ON)(ADDRESS=(PROTOCOL=TCP)(HOST=ords-scan)(PORT=1521)))
(CONNECT_DATA=(SERVICE_NAME=ords)))</entry>
<entry key="jdbc.enableONS">true</entry>
<entry key= "jdbc.ONSConfig">nodes=racnode1:4200,racnode2:4200\nwalletfile=/oracle11/onswalletfile</entry>
ALTER USER APEX_PUBLIC_USER IDENTIFIED BY Orcl$$1234 ACCOUNT UNLOCK;
BEGIN
DBMS_NETWORK_ACL_ADMIN.APPEND_HOST_ACE(
host => '*',
ace => xs$ace_type(privilege_list => xs$name_list('connect'),
principal_name => 'APEX_050100',
principal_type => xs_acl.ptype_db));
END;
/
----------------------------
nohup java -jar ords.war standalone --port 9988 --apex-images /data/app/oracle/ords18/images &
00006945 - Quyen giam doc chi nhanh
--------------------------------------------------------------
--- config printing
DECLARE
ACL_PATH VARCHAR2(4000);
BEGIN
-- Look for the ACL currently assigned to 'localhost' and give APEX_050100
-- the "connect" privilege if APEX_040200 does not have the privilege yet.
SELECT ACL INTO ACL_PATH FROM DBA_NETWORK_ACLS
WHERE HOST = 'localhost' AND LOWER_PORT IS NULL AND UPPER_PORT IS NULL;
IF DBMS_NETWORK_ACL_ADMIN.CHECK_PRIVILEGE(ACL_PATH, 'APEX_050100',
'connect') IS NULL THEN
DBMS_NETWORK_ACL_ADMIN.ADD_PRIVILEGE(ACL_PATH,
'APEX_050100', TRUE, 'connect');
END IF;
EXCEPTION
-- When no ACL has been assigned to 'localhost'.
WHEN NO_DATA_FOUND THEN
DBMS_NETWORK_ACL_ADMIN.CREATE_ACL('local-access-users.xml',
'ACL that lets users to connect to localhost',
'APEX_050100', TRUE, 'connect');
DBMS_NETWORK_ACL_ADMIN.ASSIGN_ACL('local-access-users.xml','localhost');
END;
/
COMMIT;
DECLARE
ACL_PATH VARCHAR2(4000);
BEGIN
-- Look for the ACL currently assigned to ‘*’ and give APEX_050100
-- the “connect” privilege if APEX_050100 does not have the privilege yet.
SELECT ACL INTO ACL_PATH FROM DBA_NETWORK_ACLS
WHERE HOST = '*' AND LOWER_PORT IS NULL AND UPPER_PORT IS NULL;
IF DBMS_NETWORK_ACL_ADMIN.CHECK_PRIVILEGE(ACL_PATH, 'APEX_050100',
'connect') IS NULL THEN
DBMS_NETWORK_ACL_ADMIN.ADD_PRIVILEGE(ACL_PATH,
'APEX_050100', TRUE, 'connect');
END IF;
EXCEPTION
-- When no ACL has been assigned to '*'.
WHEN NO_DATA_FOUND THEN
DBMS_NETWORK_ACL_ADMIN.CREATE_ACL('power_users.xml',
'ACL that lets power users to connect to everywhere',
'APEX_050100', TRUE, 'connect');
DBMS_NETWORK_ACL_ADMIN.ASSIGN_ACL('power_users.xml','*');
END;
/
commit;
oracle@rac19c1 ~]$ cd /$ORACLE_BASE
[oracle@rac19c1 oracle]$ pwd
//u01/app/oracle
[oracle@rac19c1 oracle]$ cd admin
[oracle@rac19c1 admin]$ ls
+ASM rac19c
[oracle@rac19c1 admin]$ cd rac19c
[oracle@rac19c1 rac19c]$ ls
adump dpdump hdump pfile xdb_wallet
[oracle@rac19c1 rac19c]$ mkdir wallet
[oracle@rac19c1 rac19c]$ cd wallet
[oracle@rac19c1 wallet]$ sqlplus / as sysdba
Step 1: Configure the Wallet Root
{
mkdir -p ${ORACLE_BASE}/admin/${ORACLE_SID}/wallet/tde
sqlplus / as sysdba << EOF
create pfile='${ORACLE_BASE}/admin/${ORACLE_SID}/pfile/${ORACLE_SID}-`date +%F`.ora' from spfile;
alter system set WALLET_ROOT="/u01/app/oracle/admin/rac19c/wallet" scope=spfile;
shutdown immediate
startup
alter system set TDE_CONFIGURATION="KEYSTORE_CONFIGURATION=FILE";
EOF
}
-------------------------------------------------
Step 2: Create the password protected key store
{
sqlplus / as sysdba << EOF
administer key management create keystore '/u01/app/oracle/admin/rac19c/wallet/tde' identified by welcome1;
set lines 300
column WRL_PARAMETER format a40
select WRL_TYPE, WRL_PARAMETER, STATUS, CON_ID from v$encryption_wallet;
EOF
ll ${ORACLE_BASE}/admin/${ORACLE_SID}/wallet/tde
}
WRL_TYPE WRL_PARAMETER STATUS CON_ID
-------------------- ---------------------------------------- ------------------------------ ----------
FILE /u01/app/oracle/admin/CN01/wallet/tde/ CLOSED 1
FILE CLOSED 2
FILE CLOSED 3
-rw-------. 1 oracle oinstall 2555 May 17 13:59 ewallet.p12
--------------------------------------------------
Step 3: Open the key store CDB & PDB
------------------------------------------------------
unzip -q fmw_12.2.1.3.0_infrastructure_Disk1_1of1.zip
--- Cai infrastructure
tar xvzf /dir/to/file.tar.gz -C /dir/to/output/
$JAVA_HOME/bin/java -d64 -jar fmw_12.2.1.3.0_infrastructure.jar
--- cai bi
./bi_platform-12.2.1.4.0_linux64.bin
---- create rcu
cd /u01/oracle/obiee12c/oracle_common/bin
./rcu
----- config BI
cd /u01/oracle/obiee12c/bi/bin
./config.sh
-----------------------------------------------------
-- download, giai nen, config ords
-----------------------------------------------------
unzip -q /media/sf_AppSetup/ords-19.4.0.352.1226.zip -d /u01/oracle/ords/
cd /u01/oracle/ords
$JAVA_HOME/bin/java -jar ords.war setup
$JAVA_HOME/bin/java -jar ords.war static C:\ords\images
-----------------------------------------------------
customURL
jdbc:oracle:thin:@(DESCRIPTION=(FAILOVER=ON)(ADDRESS_LIST=(LOAD_BALANCE=ON)(ADDRESS=(PROTOCOL=TCP)(HOST=10.1.7.15)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=pdb1)))
-----------------------------------------------------
--create user ADM identified by "Loilm$$123";
--create user MBHR identified by MBHR;
--create profile APP_PROFILE limit PASSWORD_REUSE_TIME unlimited;
--alter user ADM profile APP_PROFILE;
--alter user APPS profile APP_PROFILE;
--alter user MBHR profile APP_PROFILE;
--create user ATM identified by ATM;
--alter user ATM profile APP_PROFILE;
--grant connect, resource to ADM;
--grant connect, resource to APPS;
--grant connect, resource to MBHR;
--grant connect, resource to ATM;
--grant create table, create view, create procedure, create sequence, create job, create trigger, create synonym to ADM;
--grant create table, create view, create procedure, create sequence, create job, create trigger, create synonym to APPS;
--grant create table, create view, create procedure, create sequence, create job, create trigger, create synonym to MBHR;
--grant create table, create view, create procedure, create sequence, create job, create trigger, create synonym to ATM;
--alter user ORDS_PUBLIC_USER identified by "Loilm$$123" profile APP_PROFILE;
--alter user APEX_PUBLIC_USER identified by "Loilm$$123" profile APP_PROFILE;
--alter user APEX_PUBLIC_USER identified by "Loilm$$123" profile APP_PROFILE;
--alter user APEX_REST_PUBLIC_USER identified by "Loilm$$123" profile APP_PROFILE;
--alter user APEX_LISTENER identified by "Loilm$$123" profile APP_PROFILE;
--select username,account_status from dba_users where username like '%APEX%';
--create user DEMO identified by DEMO profile APP_PROFILE;
--grant connect, resource, create table, create view, create procedure, create sequence, create job, create trigger, create synonym to DEMO;
---------------------------------------------------------------------------------
enable ssl (su dung demo cert) tren weblogic
-- cai dat va config nfs ---------------
mkdir /shared
chown -R oracle:oracle /shared
yum install nfs-utils
vi /etc/exports
/shared 10.1.5.22(rw,sync)
vi /etc/sysctl.conf
fs.nfs.nlm_tcpport = 32803
fs.nfs.nlm_udpport = 32769
vi /etc/sysconfig/nfs
MOUNTD_PORT=892
STATD_PORT=662
systemctl start nfs-server
exportfs -i -o rw 10.1.5.22:/shared
----------------------------------------
node 2:
mount -t nfs -o rw,nosuid 10.1.5.21:/shared /shared
vi /etc/fstab
10.1.5.21:/shared /shared nfs rw,nosuid 0 0
----------------------------------------
---------------------------------------------------------------------------------
--- Cai dat oracle HTTP Server
---------------------------------------------------------------------------------
rpm -ivh libaio-devel-0.3.109-13.el7.x86_64.rpm
rpm -ivh ksh-20120801-139.0.1.el7.x86_64.rpm
cd /media/sf_AppSetup
./fmw_12.2.1.3.0_ohs_linux64.bin
-> Thuc hien cai dat xong (chọn cùng home với bi : /u01/app/obiee
cd /u01/oracle/ora
Page updated
Google Sites
Report abuse