Configuration Details:
Database: Oracle 23c Free Developer Edition
Operating System: Oracle Linux 8.7 64 BitOracle Database 23c Free can be installed in below two ways. Here, I am performing installation by 1st method i.e. RPM based installation.
- RPM based installation
- Silent Installation
Pre-requisites to be checked before installing Oracle Database 23c Software.
1) Minimum supported version: Red Hat Enterprise Linux 8.6: 4.18.0-372.26.1.0.1.el8_6.x86_64 or later
2) Ensure that OpenSSH is installed on your servers. OpenSSH is the required SSH software.
3) Install the latest released versions of the below RPM packages:
- bc
- binutils
- compat-openssl10
- elfutils-libelf
- glibc
- glibc-devel
- ksh
- libaio
- libXrender
- libX11
- libXau
- libXi
- libXtst
- libgcc
- libnsl
- libstdc++
- libxcb
- libibverbs
- libasan
- liblsan
- make
- policycoreutils
- policycoreutils-python-utils
- smartmontools
- sysstat
Optional packages are also required based on requirement:
- ipmiutil (for Intelligent Platform Management Interface)
- libnsl2 (for Oracle Database Client only)
- libnsl2-devel (for Oracle Database Client only)
- net-tools (for Oracle RAC and Oracle Clusterware)
- nfs-utils (for Oracle ACFS)
4) The following Network protocols are supported:
- IPC
- UDP
- TCP/IP
- TCP/IP with SSL
5) Minimum 1 GB RAM is required and 2 GB is recommended. For Oracle Database Free, Oracle recommends a minimum swap space of 2 GB or twice the size of RAM, whichever is lesser.
6) 10 GB minimum Disk space is required.
7) Server Component Kernel Parameter Requirements:
Kernel Parameter Setting
semmsl 250
semmns 32000
semopm 100
semmni 128
shmmax 4398046511104
shmmni 4096
shmall 1073741824
file-max 6815744
aio-max-nr 1048576
ip_local_port_range 9000–65500
panic_on_oops 1
rmem_default 262144
rmem_max 4194304
wmem_default 262144
wmem_max 1048576
Note: The Oracle Database Free installation does not support symbolic links or symlinks for that disk.
Step 1: Download Oracle 23c pre-installation and database free RPM packages from Oracle Site.
- oracle-database-preinstall-23c-1.0-0.5.el8.x86_64.rpm
- oracle-database-free-23c-1.0-1.el8.x86_64.rpm
Copy and paste below URL to download pre-installation RPM package.
Refer below steps to download oracle database 23c RPM package.
Step 2: Download Oracle Linux 8.7 setup from Oracle website as below:
Step 3: Configure Virtual Box to install Oracle Linux 8.7 setup considering you have already installed virtual box latest version.
Step 5: Once Linux Installation is done, you can make below changes on server.
- Disable Firewall
- Disable SELINUX settings
- Add IP address in /etc/hosts file
If you try to install pre-installation RPM package then you will get below error message. You need to install below RPM packages.
[root@orahost sf_Software]# rpm -ivh oracle-database-preinstall-23c-1.0-0.5.el8.x86_64.rpm
warning: oracle-database-preinstall-23c-1.0-0.5.el8.x86_64.rpm: Header V3 RSA/SHA256 Signature, key ID ad986da3: NOKEY
error: Failed dependencies:
compat-openssl is needed by oracle-database-preinstall-23c-1.0-0.5.el8.x86_64
ksh is needed by oracle-database-preinstall-23c-1.0-0.5.el8.x86_64
libnsl is needed by oracle-database-preinstall-23c-1.0-0.5.el8.x86_64
sysstat is needed by oracle-database-preinstall-23c-1.0-0.5.el8.x86_64
[root@orahost sf_Software]#
Install below RPM packages:
- compat-openssl10-1.0.2o-4.el8_6.x86_64.rpm
- rpm -ivh ksh-20120801-257.0.1.el8.x86_64.rpm
- sysstat-11.7.3-7.0.1.el8.x86_64.rpm
- libnsl.so.1
[root@orahost Packages]# rpm -ivh compat-openssl10-1.0.2o-4.el8_6.x86_64.rpm
warning: compat-openssl10-1.0.2o-4.el8_6.x86_64.rpm: Header V3 RSA/SHA256 Signature, key ID ad986da3: NOKEY
Verifying... ################################# [100%]
Preparing... ################################# [100%]
Updating / installing...
1:compat-openssl10-1:1.0.2o-4.el8_6################################# [100%]
[root@orahost Packages]#
[root@orahost Packages]# rpm -ivh ksh-20120801-257.0.1.el8.x86_64.rpm
warning: ksh-20120801-257.0.1.el8.x86_64.rpm: Header V3 RSA/SHA256 Signature, key ID ad986da3: NOKEY
Verifying... ################################# [100%]
Preparing... ################################# [100%]
Updating / installing...
1:ksh-20120801-257.0.1.el8 ################################# [100%]
[root@orahost Packages]#
[root@orahost Packages]# rpm -ivh sysstat-11.7.3-7.0.1.el8.x86_64.rpm
warning: sysstat-11.7.3-7.0.1.el8.x86_64.rpm: Header V3 RSA/SHA256 Signature, key ID ad986da3: NOKEY
Verifying... ################################# [100%]
Preparing... ################################# [100%]
Updating / installing...
1:sysstat-11.7.3-7.0.1.el8 ################################# [100%]
[root@orahost Packages]#
warning: compat-openssl10-1.0.2o-4.el8_6.x86_64.rpm: Header V3 RSA/SHA256 Signature, key ID ad986da3: NOKEY
Verifying... ################################# [100%]
Preparing... ################################# [100%]
Updating / installing...
1:compat-openssl10-1:1.0.2o-4.el8_6################################# [100%]
[root@orahost Packages]#
[root@orahost Packages]# rpm -ivh ksh-20120801-257.0.1.el8.x86_64.rpm
warning: ksh-20120801-257.0.1.el8.x86_64.rpm: Header V3 RSA/SHA256 Signature, key ID ad986da3: NOKEY
Verifying... ################################# [100%]
Preparing... ################################# [100%]
Updating / installing...
1:ksh-20120801-257.0.1.el8 ################################# [100%]
[root@orahost Packages]#
[root@orahost Packages]# rpm -ivh sysstat-11.7.3-7.0.1.el8.x86_64.rpm
warning: sysstat-11.7.3-7.0.1.el8.x86_64.rpm: Header V3 RSA/SHA256 Signature, key ID ad986da3: NOKEY
Verifying... ################################# [100%]
Preparing... ################################# [100%]
Updating / installing...
1:sysstat-11.7.3-7.0.1.el8 ################################# [100%]
[root@orahost Packages]#
For libnsl.so.1 RPM package, you need to configure YUM repository as below:
Click on below link to setup Yum repository on local server.
[root@orahost yum.repos.d]# yum install libnsl.so.1
Repository ol8_UEKR7 is listed more than once in the configuration
Latest Unbreakable Enterprise Kernel Release 7 for Ora 76 MB/s | 3.4 MB 00:00
Last metadata expiration check: 0:00:01 ago on Thu 04 May 2023 06:01:06 AM EDT.
Dependencies resolved.
=======================================================================================
Package Arch Version Repository Size
=======================================================================================
Installing:
libnsl i686 2.28-211.0.1.el8 ol8_UEKR7 109 k
Installing dependencies:
glibc i686 2.28-211.0.1.el8 ol8_UEKR7 2.0 M
Installing weak dependencies:
glibc-gconv-extra i686 2.28-211.0.1.el8 ol8_UEKR7 1.6 M
Transaction Summary
=======================================================================================
Install 3 Packages
Total size: 3.7 M
Installed size: 11 M
Is this ok [y/N]: y
Downloading Packages:
Latest Unbreakable Enterprise Kernel Release 7 for Ora 3.0 MB/s | 3.1 kB 00:00
Importing GPG key 0xAD986DA3:
Userid : "Oracle OSS group (Open Source Software group) <build@oss.oracle.com>"
Fingerprint: 76FD 3DB1 3AB6 7410 B89D B10E 8256 2EA9 AD98 6DA3
From : /etc/pki/rpm-gpg/RPM-GPG-KEY-oracle
Is this ok [y/N]: y
Key imported successfully
Running transaction check
Transaction check succeeded.
Running transaction test
Transaction test succeeded.
Running transaction
Preparing : 1/1
Installing : glibc-gconv-extra-2.28-211.0.1.el8.i686 1/3
Running scriptlet: glibc-gconv-extra-2.28-211.0.1.el8.i686 1/3
Running scriptlet: glibc-2.28-211.0.1.el8.i686 2/3
Installing : glibc-2.28-211.0.1.el8.i686 2/3
Running scriptlet: glibc-2.28-211.0.1.el8.i686 2/3
Installing : libnsl-2.28-211.0.1.el8.i686 3/3
Running scriptlet: libnsl-2.28-211.0.1.el8.i686 3/3
Verifying : glibc-2.28-211.0.1.el8.i686 1/3
Verifying : glibc-gconv-extra-2.28-211.0.1.el8.i686 2/3
Verifying : libnsl-2.28-211.0.1.el8.i686 3/3
Installed:
glibc-2.28-211.0.1.el8.i686 glibc-gconv-extra-2.28-211.0.1.el8.i686
libnsl-2.28-211.0.1.el8.i686
Complete!
[root@orahost yum.repos.d]#
Repository ol8_UEKR7 is listed more than once in the configuration
Latest Unbreakable Enterprise Kernel Release 7 for Ora 76 MB/s | 3.4 MB 00:00
Last metadata expiration check: 0:00:01 ago on Thu 04 May 2023 06:01:06 AM EDT.
Dependencies resolved.
=======================================================================================
Package Arch Version Repository Size
=======================================================================================
Installing:
libnsl i686 2.28-211.0.1.el8 ol8_UEKR7 109 k
Installing dependencies:
glibc i686 2.28-211.0.1.el8 ol8_UEKR7 2.0 M
Installing weak dependencies:
glibc-gconv-extra i686 2.28-211.0.1.el8 ol8_UEKR7 1.6 M
Transaction Summary
=======================================================================================
Install 3 Packages
Total size: 3.7 M
Installed size: 11 M
Is this ok [y/N]: y
Downloading Packages:
Latest Unbreakable Enterprise Kernel Release 7 for Ora 3.0 MB/s | 3.1 kB 00:00
Importing GPG key 0xAD986DA3:
Userid : "Oracle OSS group (Open Source Software group) <build@oss.oracle.com>"
Fingerprint: 76FD 3DB1 3AB6 7410 B89D B10E 8256 2EA9 AD98 6DA3
From : /etc/pki/rpm-gpg/RPM-GPG-KEY-oracle
Is this ok [y/N]: y
Key imported successfully
Running transaction check
Transaction check succeeded.
Running transaction test
Transaction test succeeded.
Running transaction
Preparing : 1/1
Installing : glibc-gconv-extra-2.28-211.0.1.el8.i686 1/3
Running scriptlet: glibc-gconv-extra-2.28-211.0.1.el8.i686 1/3
Running scriptlet: glibc-2.28-211.0.1.el8.i686 2/3
Installing : glibc-2.28-211.0.1.el8.i686 2/3
Running scriptlet: glibc-2.28-211.0.1.el8.i686 2/3
Installing : libnsl-2.28-211.0.1.el8.i686 3/3
Running scriptlet: libnsl-2.28-211.0.1.el8.i686 3/3
Verifying : glibc-2.28-211.0.1.el8.i686 1/3
Verifying : glibc-gconv-extra-2.28-211.0.1.el8.i686 2/3
Verifying : libnsl-2.28-211.0.1.el8.i686 3/3
Installed:
glibc-2.28-211.0.1.el8.i686 glibc-gconv-extra-2.28-211.0.1.el8.i686
libnsl-2.28-211.0.1.el8.i686
Complete!
[root@orahost yum.repos.d]#
Step 6: Once you install above RPM packages then start pre-installation and DB software installation task.
[root@orahost sf_Software]# pwd
/media/sf_Software
[root@orahost sf_Software]# ls -ltr
-rwxrwx--- 1 root vboxsf 91653 Jun 12 2012 'prerequiste of oracle on linux.txt'
-rwxrwx--- 1 root vboxsf 1849 Sep 12 2017 'root.sh script.txt'
-rwxrwx--- 1 root vboxsf 414 Sep 12 2017 'How to create new mount-point in Linux.txt'
drwxrwx--- 1 root vboxsf 0 Oct 10 2018 'VM ware 6'
drwxrwx--- 1 root vboxsf 0 Oct 10 2018 VMware-workstation-full-11.0.0-2305329
drwxrwx--- 1 root vboxsf 4096 Jan 10 2022 'ASM Grid Software Installation'
drwxrwx--- 1 root vboxsf 4096 Jun 17 2022 'How to install oracle 10g'
drwxrwx--- 1 root vboxsf 4096 Aug 10 2022 'Route Issue'
drwxrwx--- 1 root vboxsf 8192 Apr 7 07:53 'RAC Setup'
-rwxrwx--- 1 root vboxsf 30688 Apr 23 03:31 oracle-database-preinstall-23c-1.0-0.5.el8.x86_64.rpm
-rwxrwx--- 1 root vboxsf 1758776440 Apr 23 03:39 oracle-database-free-23c-1.0-1.el8.x86_64.rpm
drwxrwx--- 1 root vboxsf 4096 May 4 05:15 Linux
drwxrwx--- 1 root vboxsf 4096 May 4 2023 'Ready Setup VDIs'
[root@orahost sf_Software]# id
uid=0(root) gid=0(root) groups=0(root)
An RPM-based pre-installation activity performs below tasks:
- Pre-installation checks
- Extracts the database software
- Reassigns ownership of the extracted software to the preconfigured user and groups.
- Maintains the Oracle inventory.
- Runs all root operations required to configure the Oracle Database software for a single-instance Oracle Database creation and configuration.
- Add kernel parameters in /etc/sysctl.conf file.
- It does not add limits parameters in /etc/security/limits.conf file. You can add these manually.
[root@orahost sf_Software]# rpm -ivh oracle-database-preinstall-23c-1.0-0.5.el8.x86_64.rpm
Verifying... ################################# [100%]
Preparing... ################################# [100%]
Updating / installing...
1:oracle-database-preinstall-23c-1.################################# [100%]
[root@orahost sf_Software]#
[root@orahost /]# id oracle
uid=54321(oracle) gid=54321(oinstall) groups=54321(oinstall),54322(dba),54323(oper),54324(backupdba),54325(dgdba),54326(kmdba),54330(racdba)
[root@orahost /]#
[root@orahost sf_Software]# cat /etc/passwd | grep oracle
oracle:x:54321:54321::/home/oracle:/bin/bash
[root@orahost sf_Software]# cat /etc/group | grep oinstall
oinstall:x:54321:oracle
[root@orahost sf_Software]# cat /etc/group | grep dba
dba:x:54322:oracle
backupdba:x:54324:oracle
dgdba:x:54325:oracle
kmdba:x:54326:oracle
racdba:x:54330:oracle
[root@orahost sf_Software]# cat /etc/sysctl.conf | grep -v "#"
fs.file-max = 6815744
kernel.sem = 250 32000 100 128
kernel.shmmni = 4096
kernel.shmall = 1073741824
kernel.shmmax = 4398046511104
kernel.panic_on_oops = 1
net.core.rmem_default = 262144
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 1048576
net.ipv4.conf.all.rp_filter = 2
net.ipv4.conf.default.rp_filter = 2
fs.aio-max-nr = 1048576
net.ipv4.ip_local_port_range = 9000 65500
[root@orahost sf_Software]# cat /etc/security/limits.conf | grep -v "#"
[root@orahost sf_Software]#
Now start Oracle 23c Free database software installation as below:
[root@orahost sf_Software]# rpm -ivh oracle-database-free-23c-1.0-1.el8.x86_64.rpm
Verifying... ################################# [100%]
Preparing... ################################# [100%]
Updating / installing...
1:oracle-database-free-23c-1.0-1 ################################# [100%]
[INFO] Executing post installation scripts...
[INFO] Oracle home installed successfully and ready to be configured.
To configure Oracle Database Free, optionally modify the parameters in '/etc/sysconfig/oracle-free-23c.conf' and then run '/etc/init.d/oracle-free-23c configure' as root.
[root@orahost sf_Software]#
You can view the contents of the configuration file "oracle-free-23c.conf" located in "/etc/sysconfig" directory.
[root@orahost sf_Software]# cat /etc/sysconfig/oracle-free-23c.conf
#This is a configuration file to setup the Oracle Database.
#It is used when running '/etc/init.d/oracle-free-23c configure'.
# LISTENER PORT used Database listener, Leave empty for automatic port assignment
LISTENER_PORT=
# Character set of the database
CHARSET=AL32UTF8
# Database file directory
# If not specified, database files are stored under Oracle base/oradata
DBFILE_DEST=
# DB Domain name
DB_DOMAIN=
# SKIP Validations, memory, space
SKIP_VALIDATIONS=false
You can keep all parameters as default. Here, I am creating separate directory for storing data files.
[root@orahost ~]# cd /
[root@orahost /]# mkdir -p /u01/DB
[root@orahost /]# chown -R oracle:oinstall /u01
[root@orahost /]# chmod -R 755 /u01
[root@orahost /]# ls -ld /u01
drwxr-xr-x 2 oracle oinstall 6 May 4 06:46 /u01
[root@orahost DB]# cat /etc/sysconfig/oracle-free-23c.conf | grep DBFILE_DEST
DBFILE_DEST=/u01/DB
[root@orahost DB]# id
uid=0(root) gid=0(root) groups=0(root)
Execute below command by root user to configure database.
[root@orahost DB]# /etc/init.d/oracle-free-23c configure
Specify a password to be used for database accounts. Oracle recommends that the password entered should be at least 8 characters in length, contain at least 1 uppercase character, 1 lower case character and 1 digit [0-9]. Note that the same password will be used for SYS, SYSTEM and PDBADMIN accounts:
Confirm the password:
Configuring Oracle Listener.
Listener configuration succeeded.
Configuring Oracle Database FREE.
Enter SYS user password:
**********
Enter SYSTEM user password:
*******
Enter PDBADMIN User Password:
*******
Prepare for db operation
7% complete
Copying database files
29% complete
Creating and starting Oracle instance
30% complete
33% complete
36% complete
39% complete
43% complete
Completing Database Creation
47% complete
49% complete
50% complete
Creating Pluggable Databases
54% complete
71% complete
Executing Post Configuration Actions
93% complete
Running Custom Scripts
100% complete
Database creation complete. For details check the logfiles at:
/opt/oracle/cfgtoollogs/dbca/FREE.
Database Information:
Global Database Name:FREE
System Identifier(SID):FREE
Look at the log file "/opt/oracle/cfgtoollogs/dbca/FREE/FREE.log" for further details.
Connect to Oracle Database using one of the connect strings:
Pluggable database: orahost.localdomain/FREEPDB1
Multitenant container database: orahost.localdomain
[root@orahost DB]#
You can view the installation log files in detail which are located in directory "/opt/oracle/cfgtoollogs/dbca/FREE".
cd /opt/oracle/cfgtoollogs/dbca/FREE
[root@orahost FREE]# ls -ltr
-rw-r----- 1 oracle oinstall 0 May 4 06:53 rmanUtil
-rw-r----- 1 oracle oinstall 422 May 4 06:54 CloneRmanRestore.log
-rw-r----- 1 oracle oinstall 18759680 May 4 06:54 tempControl.ctl
-rw-r----- 1 oracle oinstall 1715 May 4 06:55 cloneDBCreation.log
-rw-r----- 1 oracle oinstall 4739 May 4 06:56 utlfixdirs0.log
-rw------- 1 oracle oinstall 3153 May 4 06:56 utlfixdirs_catcon_16894.lst
-rw-r----- 1 oracle oinstall 5373 May 4 06:57 execemx0.log
-rw------- 1 oracle oinstall 3141 May 4 06:57 execemx_catcon_16978.lst
-rw-r----- 1 oracle oinstall 1650 May 4 06:57 postScripts.log
-rw-r----- 1 oracle oinstall 902 May 4 06:57 lockAccount.log
-rw-r----- 1 oracle oinstall 9995 May 4 06:58 utlrp0.log
-rw------- 1 oracle oinstall 3133 May 4 06:58 utlrp_catcon_17083.lst
-rw-r----- 1 oracle oinstall 2226 May 4 07:00 postDBCreation.log
-rw-r----- 1 oracle oinstall 0 May 4 07:00 PDBCreation.log
-rw-r----- 1 oracle oinstall 354 May 4 07:02 plugDatabase.log
-rw-r----- 1 oracle oinstall 46 May 4 07:02 postPDBCreation.log
-rw-r----- 1 oracle oinstall 0 May 4 07:02 customScripts.log
-rw-r----- 1 oracle oinstall 915 May 4 07:02 FREE.log
-rw-r----- 1 oracle oinstall 1138821 May 4 07:02 trace.log_2023-05-04_06-52-31AM
[root@orahost FREE]# cat FREE.log
[ 2023-05-04 06:52:52.079 EDT ] Prepare for db operation
DBCA_PROGRESS : 7%
[ 2023-05-04 06:52:52.305 EDT ] Copying database files
DBCA_PROGRESS : 29%
[ 2023-05-04 06:54:54.169 EDT ] Creating and starting Oracle instance
DBCA_PROGRESS : 30%
DBCA_PROGRESS : 33%
DBCA_PROGRESS : 36%
DBCA_PROGRESS : 39%
DBCA_PROGRESS : 43%
[ 2023-05-04 06:57:03.832 EDT ] Completing Database Creation
DBCA_PROGRESS : 47%
DBCA_PROGRESS : 49%
DBCA_PROGRESS : 50%
[ 2023-05-04 07:00:47.344 EDT ] Creating Pluggable Databases
DBCA_PROGRESS : 54%
DBCA_PROGRESS : 71%
[ 2023-05-04 07:02:04.338 EDT ] Executing Post Configuration Actions
DBCA_PROGRESS : 93%
[ 2023-05-04 07:02:04.493 EDT ] Running Custom Scripts
DBCA_PROGRESS : 100%
[ 2023-05-04 07:02:09.609 EDT ] Database creation complete. For details check the logfiles at:
/opt/oracle/cfgtoollogs/dbca/FREE.
Database Information:
Global Database Name:FREE
System Identifier(SID):FREE
[root@orahost FREE]#
[root@orahost FREE]# ps -ef | grep pmon
oracle 17232 2113 0 07:00 ? 00:00:00 db_pmon_FREE
root 18320 2750 0 07:04 pts/0 00:00:00 grep --color=auto pmon
[root@orahost FREE]# ps -ef | grep tns
root 5 2 0 04:55 ? 00:00:00 [netns]
oracle 14702 2113 0 06:51 ? 00:00:00 /opt/oracle/product/23c/dbhomeFree/bin/tnslsnr LISTENER -inherit
oracle 18417 18341 0 07:06 pts/0 00:00:00 grep --color=auto tns
Once installation and configuration are done then you can login to the database using below commands. The default services created by Oracle Database Free are FREE and FREEPDB1. The Oracle Database FREE service connects to the root container of the database i.e. CDB$ROOT and the FREEPDB1 service connects to the default pluggable database FREEPDB1.
[root@orahost FREE]# su - oracle
[oracle@orahost ~]$ . oraenv
ORACLE_SID = [oracle] ? FREE
The Oracle base has been set to /opt/oracle
[oracle@orahost ~]$ env | grep ORA
ORACLE_SID=FREE
ORACLE_BASE=/opt/oracle
ORACLE_HOME=/opt/oracle/product/23c/dbhomeFree
[oracle@orahost ~]$ sqlplus / as sysdba
SQL*Plus: Release 23.0.0.0.0 - Developer-Release on Thu May 4 07:05:07 2023
Version 23.2.0.0.0
Copyright (c) 1982, 2023, Oracle. All rights reserved.
Connected to:
Oracle Database 23c Free, Release 23.0.0.0.0 - Developer-Release
Version 23.2.0.0.0
SQL> set lines 300 pages 3000
SQL> select name,open_mode,log_mode,database_role,flashback_on,controlfile_type from v$database;
NAME OPEN_MODE LOG_MODE DATABASE_ROLE FLASHBACK_ON CONTROLFIL
---- ----------- --------------- ------------- ------------ ----------
FREE READ WRITE NOARCHIVELOG PRIMARY NO CURRENT
OR
[oracle@orahost ~]$ sqlplus sys@orahost.localdomain:1521 as sysdba
SQL*Plus: Release 23.0.0.0.0 - Developer-Release on Thu May 4 07:21:16 2023
Version 23.2.0.0.0
Copyright (c) 1982, 2023, Oracle. All rights reserved.
Enter password:
Connected to:
Oracle Database 23c Free, Release 23.0.0.0.0 - Developer-Release
Version 23.2.0.0.0
SQL> select name,open_mode from v$database;
NAME OPEN_MODE
--------- --------------------
FREE READ WRITE
OR
[oracle@orahost ~]$ sqlplus sys@orahost.localdomain/FREEPDB1:1521 as sysdba
SQL*Plus: Release 23.0.0.0.0 - Developer-Release on Thu May 4 07:19:29 2023
Version 23.2.0.0.0
Copyright (c) 1982, 2023, Oracle. All rights reserved.
Enter password:
Connected to:
Oracle Database 23c Free, Release 23.0.0.0.0 - Developer-Release
Version 23.2.0.0.0
SQL> select name,open_mode from v$database;
NAME OPEN_MODE
--------- --------------------
FREE READ WRITE
We can start/stop database manually or set it to start automatically when the system shuts down or starts up. To automate the start up and shutdown of the listener and database, execute below commands by root user:
# systemctl daemon-reload
# systemctl enable oracle-free-23c
To stop/start/restart the listener and the database:
# systemctl stop oracle-free-23c
# systemctl start oracle-free-23c
# systemctl restart oracle-free-23c
[root@orahost FREE]# systemctl status oracle-free-23c
Unit oracle-free-23c.service could not be found.
[root@orahost FREE]# systemctl daemon-reload
[root@orahost FREE]#
[root@orahost FREE]# systemctl status oracle-free-23c
● oracle-free-23c.service - SYSV: This script is responsible for taking care of config>
Loaded: loaded (/etc/rc.d/init.d/oracle-free-23c; generated)
Active: inactive (dead)
Docs: man:systemd-sysv-generator(8)
[root@orahost FREE]# systemctl enable oracle-free-23c
oracle-free-23c.service is not a native service, redirecting to systemd-sysv-install.
Executing: /usr/lib/systemd/systemd-sysv-install enable oracle-free-23c
[root@orahost FREE]# systemctl status oracle-free-23c
● oracle-free-23c.service - SYSV: This script is responsible for taking care of config>
Loaded: loaded (/etc/rc.d/init.d/oracle-free-23c; generated)
Active: inactive (dead)
Docs: man:systemd-sysv-generator(8)
[root@orahost FREE]# vi /etc/oratab
[root@orahost FREE]# systemctl daemon-reload
[root@orahost FREE]# systemctl status oracle-free-23c
● oracle-free-23c.service - SYSV: This script is responsible for taking care of config>
Loaded: loaded (/etc/rc.d/init.d/oracle-free-23c; generated)
Active: inactive (dead)
Docs: man:systemd-sysv-generator(8)
[root@orahost FREE]# /etc/init.d/oracle-free-23c status
Status of the Oracle FREE 23c service:
LISTENER status: RUNNING
FREE Database status: RUNNING
[root@orahost FREE]#
[root@orahost FREE]# systemctl start oracle-free-23c
[root@orahost FREE]#
[root@orahost FREE]# systemctl status oracle-free-23c
● oracle-free-23c.service - SYSV: This script is responsible for taking care of config>
Loaded: loaded (/etc/rc.d/init.d/oracle-free-23c; generated)
Active: active (exited) since Thu 2023-05-04 07:15:19 EDT; 13s ago
Docs: man:systemd-sysv-generator(8)
Process: 19012 ExecStart=/etc/rc.d/init.d/oracle-free-23c start (code=exited, status>
May 04 07:15:19 orahost.localdomain systemd[1]: Starting SYSV: This script is responsi>
May 04 07:15:19 orahost.localdomain oracle-free-23c[19012]: The Oracle Database instan>
May 04 07:15:19 orahost.localdomain systemd[1]: Started SYSV: This script is responsib>
Thanks for reading this post ! Please comment if you like this post ! Click on FOLLOW to get next blog updates !
Wonderful job Rupesh !
ReplyDeleteExcellent and very detailed, Thanks Rupesh!!!!!!!!!
ReplyDeleteVery detailed, any fresher DBA can install oracle software's using these blogs....
ReplyDelete