In last article, we discussed step by step environment readiness before starting installation of oracle database 19c on Linux/Oracle Linux 8.x version. but in this article we will learn the step by step guide, Installing oracle 19c on Linux. In this article we will learn in detail how to oracle 19c step-by-step installation on Linux.
Before starting oracle 19c installation on Linux
How to ready environment before starting Installing Oracle Database 19c on Linux/Oracle Linux 8.
Step -1
First, need to download oracle database 19c zip file for Linux x86–64. as downloading process starts, system will prompt to save the file, by default the file will save into download folder.
use wget command to download the installation file.
wget https://download.oracle.com/otn/linux/oracle19c/190000/LINUX.X64_193000_db_home.zip?AuthParam=1693307841_d35df7f8be50a8077bea61fcadf1549d
Step-2
We are now going to copy the installation files to the ORACLE_HOME location “/u01/app/oracle/product/19c/dbhome_1” that we created in the previous step and unzip the downloaded oracle database installation file.
[oracle@oraclelinux dbhome_1]$ unzip -q LINUX.X64_193000_db_home.zip
Start Installation
For interactive mode, I generally launch the installer through MobaXterm. Download MobaXterm on the Host machine, open a console and connect to your Linux machine using ‘ssh’ and IP address of the Linux machine with oracle user, as shown in the screenshot below.
Run oracle installer
Navigate to the folder where you have unzipped the Oracle using MobaXterm console and execute ‘runInstaller’.
[oracle@oraclelinux /]$ cd /u01/app/oracle/product/19c/dbhome_1
[oracle@oraclelinux dbhome_1]$ ./runInstaller
Then you will see the installation wizard started, first the oracle splash screen then wizard ask to click on Next to move next step. if you counter an issue ” [INS-08101] Unexpected error while executing the action at state: ‘supportedOSCheck” then click on below link
How to resolve INS-08101 Unexpected error
Once you resolved the above issue then the normal installation wizard will start and again the same error [INS-08101] will not appear.
Step 1:
Click create and configure a single instance database
Step 2:
select the class on which environment you want to install server. Here we will select “server Class” to install on central server.
Step 3:
On the basis of requirement and license agreement, we will select database edition. Here we will select Enterprise Edition as the taken license from Oracle.
Step 4:
Next, we will choose oracle base path as we already set in setenv.sh file while configuration .bash_profile environment.
Step 5:
Oracle database will choose the oraInventory directory to save installation files. and select the group name that has the privileges of oraInventory directory.
Step 6:
select the type of database that we want to create as for the environment requirements.
Step 7:
Provide the information of Global database and SID. IF you want to create a container database, then follow oracle official documentation.
Step 8:
Here, adjust the memory allocation that you oracle will use to reside data.
Step 9:
in Next step, will specify the database file location.
Step 10:
Step 11:
enable or disable database recovery location, from where we can recover the database in case of any disaster.
Step 12:
Create a password for system level users. it can be set separately for each or can be set single for all users.
Step 13:
Step 14:
if we set root password in below screen, oracle database wizard will run the scrips automatically. else we need to execute the scripts separately from terminal with root user.
Step 16: Summary
Step 17:
Step 17-1:
we already had done configuration in Step-14 to proceed automatically, here just we click on Yes button to proceed.
Step 17-2:
Step 18:
If you encounter error ” [INS-20802] Oracle Database Configuration Assistant failed”, then use below link to follow how to resolve issue. once the issue resolve then click on “Retry” button to proceed the process.
How to Resolve [INS-20802] Oracle Net Configuration Assistant failed
This is the last step of oracle database 19c installation on Linux/Oracle Linux 8.9 version.
Post Installation steps
1- After oracle successful installation, First need to start oracle “Listener” or check Listener status with below commands but error message “Command not found”
[oracle@testora bin]$ lsnrctl start
bash: lsnrctl: command not found
[oracle@testora bin]$ lsnrctl status
bash: lsnrctl: command not found
2- Run below command to find the processes are running and oracle service
[root@testora ~]# ps -ef|grep smon
oracle 11803 1 0 Sep04 ? 00:00:01 ora_smon_testora
root 48834 48755 0 10:54 pts/0 00:00:00 grep –color=auto smon
[root@testora ~]#
3- Switch to user oracle and locate oracle home directory.
[root@testora ~]# su oracle
[oracle@testora root]$ . oraenv
bash: .oraenv: command not found
[oracle@testora root]$ cd /u01/app/oracle/product/19c/dbhome_1/bin
4- Run oraenv file to configure oracle SID
[oracle@testora bin]$ . oraenv
ORACLE_SID = [oracle] ? testsora
The Oracle base has been set to /u01/app/oracle
[oracle@testora bin]$
5- Now find the oracle environment with ora parameter.
[oracle@testora bin]$ env |grep ora
LD_LIBRARY_PATH=/u01/app/oracle/product/19c/dbhome_1/lib
ORACLE_SID=testora
ORACLE_BASE=/u01/app/oracle
ORACLE_HOME=/u01/app/oracle/product/19c/dbhome_1
HOSTNAME=testora.pdc.com
USER=oracle
PWD=/u01/app/oracle/product/19c/dbhome_1/bin
HOME=/home/oracle
LOGNAME=oracle
PATH=/home/oracle/.local/bin:/home/oracle/bin:/usr/share/Modules/bin:/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/root/bin:/u01/app/oracle/product/19c/dbhome_1/bin
[oracle@amsora bin]$
6- after all above configuration done, we will check Listener status
[oracle@amsora bin]$ lsnrctl status
LSNRCTL for Linux: Version 19.0.0.0.0 – Production on 05-SEP-2023 10:59:26
Copyright (c) 1991, 2019, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=amsora.pdc.com)(PORT=1521)))
STATUS of the LISTENER
this is
Alias LISTENER
Version TNSLSNR for Linux: Version 19.0.0.0.0 – Production
Start Date 04-SEP-2023 20:13:02
Uptime 0 days 14 hr. 46 min. 24 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/oracle/product/19c/dbhome_1/network/admin/listener.ora
Listener Log File /u01/app/oracle/diag/tnslsnr/amsora/listener/alert/log.xml
Listening Endpoints Summary…
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=amsora.pdc.com)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=amsora.pdc.com)(PORT=5500))(Security=(my_wallet_directory=/u01/app/oracle/admin/testora/xdb_wallet))(Presentation=HTTP)(Session=RAW))
Services Summary…
Service “testora.pdc.com” has 1 instance(s).
Instance “testora”, status READY, has 1 handler(s) for this service…
Service “testoraXDB.pdc.com” has 1 instance(s).
Instance “testora”, status READY, has 1 handler(s) for this service…
The command completed successfully
For permanent solution
Conclusion:
Hopefully, this blog post will helpful where we illustrate how to oracle 19c step-by-step installation on Linux as well as Oracle Linux 8 version.
