Oracle Database 23c Setup#

1
#!/bin/bash
2
echo "=== Oracle Database 23c Prerequisites Check ==="
3
echo
4

5
# Check CPU
6
echo "CPU Information:"
7
lscpu | grep -E "Architecture|CPU\(s\)|Thread|Core|Socket"
8
echo
9

10
# Check Memory
11
echo "Memory Information:"
12
free -h
13
echo "Oracle 23c Requirements:"
14
echo "- Minimum RAM: 2 GB (8 GB recommended for production)"
15
echo "- Minimum Swap: 1.5 times RAM when RAM < 2 GB"
16
echo
17

18
# Check Disk Space
19
echo "Disk Space:"
20
df -h
21
echo "Oracle 23c Requirements:"
22
echo "- Oracle Software: 10 GB"
23
echo "- Data Files: 20 GB minimum (varies based on use)"
24
echo "- Recovery Area: 20 GB minimum"
25
echo
26

27
# Check OS Version
28
echo "Operating System:"
29
cat /etc/os-release | grep -E "NAME|VERSION"
30
echo "Supported OS: Oracle Linux 8.6+, RHEL 8.6+, SLES 15 SP3+"
31
echo
32

33
# Check Kernel Parameters
34
echo "Kernel Parameters Check:"
35
echo "Current values vs. Required minimums:"
36
echo
37

38
# Shared Memory
39
echo -n "kernel.shmall: "
40
sysctl -n kernel.shmall 2>/dev/null || echo "not set"
41
echo "  Required: $(getconf PAGE_SIZE) * $(getconf PHYS_PAGES) / 2"
42

43
echo -n "kernel.shmmax: "
44
sysctl -n kernel.shmmax 2>/dev/null || echo "not set"
45
echo "  Required: $(getconf PHYS_PAGES) * $(getconf PAGE_SIZE) / 2"
46

47
echo -n "kernel.shmmni: "
48
sysctl -n kernel.shmmni 2>/dev/null || echo "not set"
49
echo "  Required: 4096"
50

51
# Semaphores
52
echo -n "kernel.sem: "
53
sysctl -n kernel.sem 2>/dev/null || echo "not set"
54
echo "  Required: 250 32000 100 128"
55

56
# File Handles
57
echo -n "fs.file-max: "
58
sysctl -n fs.file-max 2>/dev/null || echo "not set"
59
echo "  Required: 6815744"
60

61
echo -n "fs.aio-max-nr: "
62
sysctl -n fs.aio-max-nr 2>/dev/null || echo "not set"
63
echo "  Required: 1048576"
64

65
# Network
66
echo -n "net.ipv4.ip_local_port_range: "
67
sysctl -n net.ipv4.ip_local_port_range 2>/dev/null || echo "not set"
68
echo "  Required: 9000 65500"
69

70
echo -n "net.core.rmem_default: "
71
sysctl -n net.core.rmem_default 2>/dev/null || echo "not set"
72
echo "  Required: 262144"
73

74
echo -n "net.core.rmem_max: "
75
sysctl -n net.core.rmem_max 2>/dev/null || echo "not set"
76
echo "  Required: 4194304"
77

78
echo -n "net.core.wmem_default: "
79
sysctl -n net.core.wmem_default 2>/dev/null || echo "not set"
80
echo "  Required: 262144"
81

82
echo -n "net.core.wmem_max: "
83
sysctl -n net.core.wmem_max 2>/dev/null || echo "not set"
84
echo "  Required: 1048576"

1
#!/bin/bash
2
# Set variables
3
ORACLE_BASE=/u01/app/oracle
4
ORACLE_HOME=$ORACLE_BASE/product/23c/dbhome_1
5
ORACLE_SID=ORCL23C
6
ORACLE_INVENTORY=/u01/app/oraInventory
7

8
echo "=== Preparing OS for Oracle Database 23c ==="
9

10
# Create Oracle user and groups
11
echo "Creating Oracle groups..."
12
groupadd -g 54321 oinstall
13
groupadd -g 54322 dba
14
groupadd -g 54323 oper
15
groupadd -g 54324 backupdba
16
groupadd -g 54325 dgdba
17
groupadd -g 54326 kmdba
18
groupadd -g 54327 asmdba
19
groupadd -g 54328 asmoper
20
groupadd -g 54329 asmadmin
21
groupadd -g 54330 racdba
22

23
echo "Creating Oracle user..."
24
useradd -u 54321 -g oinstall -G dba,oper,backupdba,dgdba,kmdba,racdba oracle
25

26
# Set password for oracle user
27
echo "oracle:Oracle123!" | chpasswd
28

29
# Create directories
30
echo "Creating Oracle directories..."
31
mkdir -p $ORACLE_BASE
32
mkdir -p $ORACLE_HOME
33
mkdir -p $ORACLE_INVENTORY
34
mkdir -p /u01/app/oracle/oradata
35
mkdir -p /u01/app/oracle/recovery_area
36
chown -R oracle:oinstall /u01
37
chmod -R 775 /u01
38

39
# Configure kernel parameters
40
echo "Configuring kernel parameters..."
41
cat > /etc/sysctl.d/97-oracle-database-sysctl.conf << EOF
42
# Oracle Database 23c Kernel Parameters
43
fs.aio-max-nr = 1048576
44
fs.file-max = 6815744
45
kernel.shmall = $(echo "$(getconf PHYS_PAGES) / 2" | bc)
46
kernel.shmmax = $(echo "$(getconf PHYS_PAGES) * $(getconf PAGE_SIZE) / 2" | bc)
47
kernel.shmmni = 4096
48
kernel.sem = 250 32000 100 128
49
net.ipv4.ip_local_port_range = 9000 65500
50
net.core.rmem_default = 262144
51
net.core.rmem_max = 4194304
52
net.core.wmem_default = 262144
53
net.core.wmem_max = 1048576
54
vm.dirty_background_ratio = 3
55
vm.dirty_ratio = 15
56
vm.dirty_expire_centisecs = 500
57
vm.dirty_writeback_centisecs = 100
58
EOF
59

60
sysctl -p /etc/sysctl.d/97-oracle-database-sysctl.conf
61

62
# Configure user limits
63
echo "Configuring user limits..."
64
cat > /etc/security/limits.d/97-oracle.conf << EOF
65
# Oracle Database 23c User Limits
66
oracle   soft   nofile    1024
67
oracle   hard   nofile    65536
68
oracle   soft   nproc     16384
69
oracle   hard   nproc     16384
70
oracle   soft   stack     10240
71
oracle   hard   stack     32768
72
oracle   soft   memlock   unlimited
73
oracle   hard   memlock   unlimited
74
EOF
75

76
# Configure PAM
77
echo "Configuring PAM..."
78
echo "session required pam_limits.so" >> /etc/pam.d/login
79

80
# Install required packages
81
echo "Installing required packages..."
82
yum install -y \
83
    bc \
84
    binutils \
85
    compat-openssl11 \
86
    elfutils-libelf \
87
    elfutils-libelf-devel \
88
    fontconfig-devel \
89
    glibc \
90
    glibc-devel \
91
    ksh \
92
    libaio \
93
    libaio-devel \
94
    libdtrace-ctf-devel \
95
    libXrender \
96
    libXrender-devel \
97
    libX11 \
98
    libXau \
99
    libXi \
100
    libXtst \
101
    libgcc \
102
    librdmacm-devel \
103
    libstdc++ \
104
    libstdc++-devel \
105
    libxcb \
106
    make \
107
    net-tools \
108
    nfs-utils \
109
    python3 \
110
    python3-configshell \
111
    python3-rtslib \
112
    python3-six \
113
    smartmontools \
114
    sysstat \
115
    unixODBC \
116
    libnsl
117

118
# Configure firewall
119
echo "Configuring firewall..."
120
firewall-cmd --permanent --add-port=1521/tcp
121
firewall-cmd --permanent --add-port=5500/tcp
122
firewall-cmd --permanent --add-port=5501/tcp
123
firewall-cmd --reload
124

125
# Disable SELinux (for installation)
126
echo "Configuring SELinux..."
127
setenforce 0
128
sed -i 's/SELINUX=enforcing/SELINUX=permissive/g' /etc/selinux/config
129

130
# Create Oracle environment script
131
echo "Creating Oracle environment script..."
132
cat > /home/oracle/.bash_profile << 'EOF'
133
# Oracle Database 23c Environment Variables
134
export ORACLE_BASE=/u01/app/oracle
135
export ORACLE_HOME=$ORACLE_BASE/product/23c/dbhome_1
136
export ORACLE_SID=ORCL23C
137
export PATH=$PATH:$ORACLE_HOME/bin
138
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH
139
export CLASSPATH=$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib
140
export NLS_LANG=AMERICAN_AMERICA.AL32UTF8
141
export NLS_DATE_FORMAT="YYYY-MM-DD HH24:MI:SS"
142

143
# Aliases
144
alias sqlplus='rlwrap sqlplus'
145
alias rman='rlwrap rman'
146
alias dgmgrl='rlwrap dgmgrl'
147
alias alert='tail -f $ORACLE_BASE/diag/rdbms/orcl23c/ORCL23C/trace/alert_ORCL23C.log'
148

149
# Functions
150
function sids {
151
    ps -ef | grep pmon | grep -v grep | awk '{print $NF}' | cut -d_ -f3-
152
}
153

154
function setdb {
155
    export ORACLE_SID=$1
156
    echo "ORACLE_SID set to $ORACLE_SID"
157
}
158
EOF
159

160
chown oracle:oinstall /home/oracle/.bash_profile
161

162
echo "OS preparation completed successfully!"

1
#!/bin/bash
2
# Run as oracle user
3
if [ "$(whoami)" != "oracle" ]; then
4
    echo "This script must be run as oracle user"
5
    exit 1
6
fi
7

8
# Set environment
9
export ORACLE_BASE=/u01/app/oracle
10
export ORACLE_HOME=$ORACLE_BASE/product/23c/dbhome_1
11
export ORACLE_SID=ORCL23C
12
export PATH=$PATH:$ORACLE_HOME/bin
13

14
# Extract Oracle software
15
echo "Extracting Oracle Database 23c software..."
16
cd $ORACLE_HOME
17
unzip -q /path/to/LINUX.X64_232000_db_home.zip
18

19
# Run installer in silent mode
20
echo "Starting Oracle Database 23c installation..."
21
./runInstaller -silent \
22
    -responseFile /home/oracle/db_install.rsp \
23
    -ignorePrereqFailure \
24
    -waitforcompletion
25

26
# Check installation log
27
echo "Installation completed. Check logs at:"
28
echo "$ORACLE_BASE/oraInventory/logs/installActions*.log"
29

30
# Run root scripts
31
echo "Please run the following commands as root:"
32
echo "1. $ORACLE_BASE/oraInventory/orainstRoot.sh"
33
echo "2. $ORACLE_HOME/root.sh"

1
#!/bin/bash
2
# Set environment
3
source /home/oracle/.bash_profile
4

5
echo "=== Creating Oracle Database 23c ==="
6

7
# Create listener
8
echo "Creating listener..."
9
cat > $ORACLE_HOME/network/admin/listener.ora << EOF
10
LISTENER =
11
  (DESCRIPTION_LIST =
12
    (DESCRIPTION =
13
      (ADDRESS = (PROTOCOL = TCP)(HOST = $(hostname))(PORT = 1521))
14
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
15
    )
16
  )
17

18
ADR_BASE_LISTENER = $ORACLE_BASE
19
ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER=ON
20
EOF
21

22
# Create tnsnames.ora
23
cat > $ORACLE_HOME/network/admin/tnsnames.ora << EOF
24
ORCL23C =
25
  (DESCRIPTION =
26
    (ADDRESS = (PROTOCOL = TCP)(HOST = $(hostname))(PORT = 1521))
27
    (CONNECT_DATA =
28
      (SERVER = DEDICATED)
29
      (SERVICE_NAME = ORCL23C)
30
    )
31
  )
32

33
PDB1 =
34
  (DESCRIPTION =
35
    (ADDRESS = (PROTOCOL = TCP)(HOST = $(hostname))(PORT = 1521))
36
    (CONNECT_DATA =
37
      (SERVER = DEDICATED)
38
      (SERVICE_NAME = PDB1)
39
    )
40
  )
41
EOF
42

43
# Start listener
44
lsnrctl start
45

46
# Create database using DBCA
47
dbca -silent -createDatabase \
48
    -templateName General_Purpose.dbc \
49
    -gdbname ORCL23C \
50
    -sid ORCL23C \
51
    -responseFile NO_VALUE \
52
    -characterSet AL32UTF8 \
53
    -sysPassword Oracle123! \
54
    -systemPassword Oracle123! \
55
    -createAsContainerDatabase true \
56
    -numberOfPDBs 1 \
57
    -pdbName PDB1 \
58
    -pdbAdminPassword Oracle123! \
59
    -databaseType MULTIPURPOSE \
60
    -automaticMemoryManagement false \
61
    -totalMemory 2048 \
62
    -storageType FS \
63
    -datafileDestination "$ORACLE_BASE/oradata" \
64
    -recoveryAreaDestination "$ORACLE_BASE/recovery_area" \
65
    -emConfiguration NONE \
66
    -ignorePreReqs
67

68
# Configure database for autostart
69
echo "Configuring database for autostart..."
70
cat > /etc/oratab << EOF
71
ORCL23C:$ORACLE_HOME:Y
72
EOF
73

74
# Create startup script
75
cat > /etc/systemd/system/oracle-database.service << EOF
76
[Unit]
77
Description=Oracle Database 23c
78
After=network.target
79

80
[Service]
81
Type=forking
82
User=oracle
83
Group=oinstall
84
Environment="ORACLE_HOME=$ORACLE_HOME"
85
Environment="ORACLE_SID=ORCL23C"
86
ExecStart=$ORACLE_HOME/bin/dbstart $ORACLE_HOME
87
ExecStop=$ORACLE_HOME/bin/dbshut $ORACLE_HOME
88
TimeoutSec=300
89

90
[Install]
91
WantedBy=multi-user.target
92
EOF
93

94
systemctl daemon-reload
95
systemctl enable oracle-database

1
#!/bin/bash
2
source /home/oracle/.bash_profile
3

4
# Function to check database status
5
check_db_status() {
6
    echo "=== Database Status ==="
7
    sqlplus -s / as sysdba << EOF
8
SET PAGESIZE 0 FEEDBACK OFF VERIFY OFF HEADING OFF ECHO OFF
9
SELECT 'Database Status: ' || status FROM v\$instance;
10
SELECT 'Database Name: ' || name FROM v\$database;
11
SELECT 'Instance Name: ' || instance_name FROM v\$instance;
12
SELECT 'Version: ' || version FROM v\$instance;
13
EOF
14
    echo
15
}
16

17
# Function to check tablespace usage
18
check_tablespace_usage() {
19
    echo "=== Tablespace Usage ==="
20
    sqlplus -s / as sysdba << EOF
21
SET LINESIZE 200
22
SET PAGESIZE 100
23
COLUMN tablespace_name FORMAT A30
24
COLUMN used_gb FORMAT 999,999.99
25
COLUMN free_gb FORMAT 999,999.99
26
COLUMN total_gb FORMAT 999,999.99
27
COLUMN pct_used FORMAT 999.99
28

29
SELECT
30
    tablespace_name,
31
    ROUND(used_space/1024/1024/1024, 2) AS used_gb,
32
    ROUND(free_space/1024/1024/1024, 2) AS free_gb,
33
    ROUND(total_space/1024/1024/1024, 2) AS total_gb,
34
    ROUND((used_space/total_space)*100, 2) AS pct_used
35
FROM (
36
    SELECT
37
        tablespace_name,
38
        SUM(bytes) AS total_space,
39
        SUM(CASE WHEN autoextensible = 'YES' THEN maxbytes ELSE bytes END) AS max_space
40
    FROM dba_data_files
41
    GROUP BY tablespace_name
42
) df,
43
(
44
    SELECT
45
        tablespace_name,
46
        SUM(bytes) AS free_space
47
    FROM dba_free_space
48
    GROUP BY tablespace_name
49
) fs
50
WHERE df.tablespace_name = fs.tablespace_name(+)
51
AND df.tablespace_name NOT LIKE 'UNDO%'
52
ORDER BY pct_used DESC;
53
EOF
54
    echo
55
}
56

57
# Function to check active sessions
58
check_active_sessions() {
59
    echo "=== Active Sessions ==="
60
    sqlplus -s / as sysdba << EOF
61
SET LINESIZE 200
62
SET PAGESIZE 100
63
COLUMN username FORMAT A20
64
COLUMN program FORMAT A30
65
COLUMN machine FORMAT A30
66
COLUMN status FORMAT A10
67

68
SELECT
69
    sid,
70
    serial#,
71
    username,
72
    program,
73
    machine,
74
    status,
75
    last_call_et
76
FROM v\$session
77
WHERE username IS NOT NULL
78
AND status = 'ACTIVE'
79
ORDER BY last_call_et DESC;
80
EOF
81
    echo
82
}
83

84
# Function to check alert log
85
check_alert_log() {
86
    echo "=== Recent Alert Log Entries ==="
87
    tail -20 $ORACLE_BASE/diag/rdbms/${ORACLE_SID,,}/$ORACLE_SID/trace/alert_$ORACLE_SID.log | grep -E "ORA-|Error|Warning"
88
    echo
89
}
90

91
# Function to check backup status
92
check_backup_status() {
93
    echo "=== Recent Backup Status ==="
94
    sqlplus -s / as sysdba << EOF
95
SET LINESIZE 200
96
SET PAGESIZE 100
97
COLUMN start_time FORMAT A20
98
COLUMN end_time FORMAT A20
99
COLUMN input_type FORMAT A15
100
COLUMN status FORMAT A10
101
COLUMN input_gb FORMAT 999,999.99
102
COLUMN output_gb FORMAT 999,999.99
103

104
SELECT
105
    TO_CHAR(start_time, 'YYYY-MM-DD HH24:MI') AS start_time,
106
    TO_CHAR(end_time, 'YYYY-MM-DD HH24:MI') AS end_time,
107
    input_type,
108
    status,
109
    ROUND(input_bytes/1024/1024/1024, 2) AS input_gb,
110
    ROUND(output_bytes/1024/1024/1024, 2) AS output_gb
111
FROM v\$rman_backup_job_details
112
WHERE start_time > SYSDATE - 7
113
ORDER BY start_time DESC;
114
EOF
115
    echo
116
}
117

118
# Main monitoring loop
119
while true; do
120
    clear
121
    echo "Oracle Database 23c Monitoring - $(date)"
122
    echo "========================================="
123

124
    check_db_status
125
    check_tablespace_usage
126
    check_active_sessions
127
    check_alert_log
128
    check_backup_status
129

130
    echo "Refreshing in 60 seconds... (Press Ctrl+C to exit)"
131
    sleep 60
132
done