{"id":4669,"date":"2025-06-07T14:10:00","date_gmt":"2025-06-07T14:10:00","guid":{"rendered":"https:\/\/w3buddy.com\/?post_type=cposts&#038;p=4669"},"modified":"2025-07-17T15:21:04","modified_gmt":"2025-07-17T15:21:04","slug":"oracle-19c-silent-install-db-creation-on-oracle-linux-8","status":"publish","type":"cposts","link":"https:\/\/w3buddy.com\/blog\/notes\/oracle-dba-d2d-tasks\/oracle-19c-silent-install-db-creation-on-oracle-linux-8\/","title":{"rendered":"Oracle 19c Silent Install &amp; DB Creation on Oracle Linux 8"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\"><strong>In this guide, you\u2019ll learn how to perform a fully silent Oracle 19c installation and create a database on Oracle Linux 8, step-by-step.<\/strong> We cover pre-setup, download, silent install, and post checks to get your lab or project environment ready quickly and cleanly.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">1\ufe0f\u20e3 Pre-Installation Preparation (Prestuff)<\/h2>\n\n\n\n<pre class=\"wp-block-code\"><code># ---------------------------------------------------------\n# Oracle 19c FULL SILENT INSTALLATION ON ORACLE LINUX 8.10\n# Pre-Installation Preparation\n# ---------------------------------------------------------\n\n# Check OS\nuname -a\ncat \/etc\/os-release\n\n# Check RAM &amp; Swap\ngrep MemTotal \/proc\/meminfo\ngrep SwapTotal \/proc\/meminfo\n\n# Adjust Swap to 4GB\nsudo swapoff -a\nsudo cp \/etc\/fstab \/etc\/fstab.bak\nsudo sed -i '\/swap\/d' \/etc\/fstab\nsudo fallocate -l 4G \/swapfile\nsudo chmod 600 \/swapfile\nsudo mkswap \/swapfile\nsudo swapon \/swapfile\necho '\/swapfile swap swap defaults 0 0' | sudo tee -a \/etc\/fstab\nswapon --show\ngrep SwapTotal \/proc\/meminfo\n\n# Check CPU &amp; Disk\nlscpu\ndf -h\n\n# Install prerequisites\nyum install -y oracle-database-preinstall-19c\n\n# Verify kernel parameters\nsudo sysctl -p\n\n# Verify shell limits\nulimit -a\n\n# Create\/verify groups, user, and set password\ngetent group oinstall\ngetent group dba\nid oracle\npasswd oracle\n\n# Create required directories\nsudo mkdir -p \/u01\/app\/oracle\/product\/19.0.0\/dbhome_1\nsudo mkdir -p \/u01\/app\/oraInventory\nsudo mkdir -p \/u02\/oradata\nsudo mkdir -p \/u02\/fra\nsudo mkdir -p \/u03\/oracle\/export\n\n# Set ownership and permissions\nsudo chown -R oracle:oinstall \/u01 \/u02 \/u03\nsudo chmod -R 775 \/u01 \/u02 \/u03\n\n# Verify directories, permissions, ownership\nls -ld \/u01\/app\/oracle\nls -ld \/u01\/app\/oracle\/product\/19.0.0\/dbhome_1\nls -ld \/u01\/app\/oraInventory\nls -ld \/u02\/oradata\nls -ld \/u02\/fra\nls -ld \/u03\/oracle\/export\nfind \/u01 \/u02 \/u03 -type d -exec ls -ld {} \\;\n\n# Set Oracle environment for oracle user\nsudo su - oracle\nvi ~\/.bash_profile\n\n# Add:\nexport ORACLE_BASE=\/u01\/app\/oracle\nexport ORACLE_HOME=$ORACLE_BASE\/product\/19.0.0\/dbhome_1\nexport ORACLE_INVENTORY=\/u01\/app\/oraInventory\nexport ORACLE_SID=ORCL\nexport PATH=$PATH:$ORACLE_HOME\/bin\nexport LD_LIBRARY_PATH=$ORACLE_HOME\/lib\nexport CLASSPATH=$ORACLE_HOME\/jlib:$ORACLE_HOME\/rdbms\/jlib\n\nsource ~\/.bash_profile\n\n# Copy or download Oracle installation zip:\n# Copy:\ncp \/mnt\/software\/LINUX.X64_193000_db_home.zip $ORACLE_HOME\n# OR download:\nwget --no-check-certificate --content-disposition \"https:\/\/download.oracle.com\/otn\/linux\/oracle19c\/190000\/LINUX.X64_193000_db_home.zip?AuthParam=xxxx\"\n\n# Unzip the installer:\ncd $ORACLE_HOME\nunzip LINUX.X64_193000_db_home.zip<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\">2\ufe0f\u20e3 Download, Installation &amp; DB Creation<\/h2>\n\n\n\n<pre class=\"wp-block-code\"><code># ---------------------------------------------------------\n# Oracle 19c Silent Installation &amp; Database Creation\n# ---------------------------------------------------------\n\n# Prepare db_install.rsp response file:\ncd $ORACLE_HOME\/install\/response\ncp db_install.rsp db_install.rsp_backup\nvi db_install.rsp\n# Edit your required parameters.\n\n# Run prerequisites:\ncd $ORACLE_HOME\nexport CV_ASSUME_DISTID=OEL7.6\n.\/runInstaller -executePrereqs -silent -responseFile $ORACLE_HOME\/install\/response\/db_install.rsp\n\n# Run silent installation:\n.\/runInstaller -silent -responseFile $ORACLE_HOME\/install\/response\/db_install.rsp\n\n# As root, execute post-install scripts:\nsudo \/u01\/app\/oraInventory\/orainstRoot.sh\nsudo \/u01\/app\/oracle\/product\/19.0.0\/dbhome_1\/root.sh\n\n# Verify SQL*Plus installation\nsqlplus -v\n\n# Create database using DBCA in silent mode:\nmkdir -p \/home\/oracle\/scripts\ncd \/home\/oracle\/scripts\nvi create_db.sh\n\n# Add the following:\n#!\/bin\/bash\ndbca -silent -createDatabase \\\n-templateName General_Purpose.dbc \\\n-gdbname ORCL \\\n-sid ORCL \\\n-dbUniqueName ORCL_LAB \\\n-responseFile NO_VALUE \\\n-characterSet AL32UTF8 \\\n-createAsContainerDatabase true \\\n-numberOfPDBs 1 \\\n-pdbName PDB1 \\\n-pdbAdminPassword 'Your_Password' \\\n-createListener LISTENER,port=1521 \\\n-emConfiguration NONE \\\n-sysPassword 'Your_Password' \\\n-systemPassword 'Your_Password' \\\n-dbsnmpPassword 'Your_Password' \\\n-datafileDestination \/u02\/oradata \\\n-recoveryAreaDestination \/u02\/fra \\\n-recoveryAreaSize 2048 \\\n-redoLogFileSize 50 \\\n-storageType FS \\\n-memoryPercentage 30 \\\n-ignorePreReqs\n\n# Save and run:\nchmod +x create_db.sh\n.\/create_db.sh\n\n# Check DBCA logs:\nls \/u01\/app\/oracle\/cfgtoollogs\/dbca\/ORCL_LAB\n\n# Optional: Configure autostart\nsudo vi \/etc\/oratab\n# Add:\nORCL:\/u01\/app\/oracle\/product\/19.0.0\/dbhome_1:Y\n\n# To manually start\/stop:\ndbstart $ORACLE_HOME\ndbshut $ORACLE_HOME<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\">Refer Ready Response File (<code>db_install.rsp<\/code>) for Silent Install (Configure as Needed)<\/h2>\n\n\n\n<pre class=\"wp-block-code\"><code>####################################################################\n## Copyright(c) Oracle Corporation 1998,2019. All rights reserved.##\n##                                                                ##\n## Specify values for the variables listed below to customize     ##\n## your installation.                                             ##\n##                                                                ##\n## Each variable is associated with a comment. The comment        ##\n## can help to populate the variables with the appropriate        ##\n## values.                                                        ##\n##                                                                ##\n## IMPORTANT NOTE: This file contains plain text passwords and    ##\n## should be secured to have read permission only by oracle user  ##\n## or db administrator who owns this installation.                ##\n##                                                                ##\n####################################################################\n\n\n#------------------------------------------------------------------------------\n# Do not change the following system generated value.\n#------------------------------------------------------------------------------\noracle.install.responseFileVersion=\/oracle\/install\/rspfmt_dbinstall_response_schema_v19.0.0\n\n#-------------------------------------------------------------------------------\n# Specify the installation option.\n# It can be one of the following:\n#   - INSTALL_DB_SWONLY\n#   - INSTALL_DB_AND_CONFIG\n#-------------------------------------------------------------------------------\n<strong>oracle.install.option=INSTALL_DB_SWONLY<\/strong>\n\n#-------------------------------------------------------------------------------\n# Specify the Unix group to be set for the inventory directory.\n#-------------------------------------------------------------------------------\n<strong>UNIX_GROUP_NAME=oinstall<\/strong>\n\n#-------------------------------------------------------------------------------\n# Specify the location which holds the inventory files.\n# This is an optional parameter if installing on\n# Windows based Operating System.\n#-------------------------------------------------------------------------------\n<strong>INVENTORY_LOCATION=\/u01\/app\/oraInventory<\/strong>\n#-------------------------------------------------------------------------------\n# Specify the complete path of the Oracle Home.\n#-------------------------------------------------------------------------------\n<strong>ORACLE_HOME=\/u01\/app\/oracle\/product\/19.0.0\/dbhome_1<\/strong>\n\n#-------------------------------------------------------------------------------\n# Specify the complete path of the Oracle Base.\n#-------------------------------------------------------------------------------\n<strong>ORACLE_BASE=\/u01\/app\/oracle<\/strong>\n\n#-------------------------------------------------------------------------------\n# Specify the installation edition of the component.\n#\n# The value should contain only one of these choices.\n#   - EE     : Enterprise Edition\n#   - SE2    : Standard Edition 2\n\n\n#-------------------------------------------------------------------------------\n\n<strong>oracle.install.db.InstallEdition=EE<\/strong>\n###############################################################################\n#                                                                             #\n# PRIVILEGED OPERATING SYSTEM GROUPS                                          #\n# ------------------------------------------                                  #\n# Provide values for the OS groups to which SYSDBA and SYSOPER privileges     #\n# needs to be granted. If the install is being performed as a member of the   #\n# group \"dba\", then that will be used unless specified otherwise below.       #\n#                                                                             #\n# The value to be specified for OSDBA and OSOPER group is only for UNIX based #\n# Operating System.                                                           #\n#                                                                             #\n###############################################################################\n\n#------------------------------------------------------------------------------\n# The OSDBA_GROUP is the OS group which is to be granted SYSDBA privileges.\n#-------------------------------------------------------------------------------\n<strong>oracle.install.db.OSDBA_GROUP=oinstall<\/strong>\n\n#------------------------------------------------------------------------------\n# The OSOPER_GROUP is the OS group which is to be granted SYSOPER privileges.\n# The value to be specified for OSOPER group is optional.\n#------------------------------------------------------------------------------\n<strong>oracle.install.db.OSOPER_GROUP=oinstall<\/strong>\n\n#------------------------------------------------------------------------------\n# The OSBACKUPDBA_GROUP is the OS group which is to be granted SYSBACKUP privileges.\n#------------------------------------------------------------------------------\n<strong>oracle.install.db.OSBACKUPDBA_GROUP=oinstall<\/strong>\n\n#------------------------------------------------------------------------------\n# The OSDGDBA_GROUP is the OS group which is to be granted SYSDG privileges.\n#------------------------------------------------------------------------------\n<strong>oracle.install.db.OSDGDBA_GROUP=oinstall<\/strong>\n\n#------------------------------------------------------------------------------\n# The OSKMDBA_GROUP is the OS group which is to be granted SYSKM privileges.\n#------------------------------------------------------------------------------\n<strong>oracle.install.db.OSKMDBA_GROUP=oinstall<\/strong>\n\n#------------------------------------------------------------------------------\n# The OSRACDBA_GROUP is the OS group which is to be granted SYSRAC privileges.\n#------------------------------------------------------------------------------\n<strong>oracle.install.db.OSRACDBA_GROUP=oinstall<\/strong>\n################################################################################\n#                                                                              #\n#                      Root script execution configuration                     #\n#                                                                              #\n################################################################################\n\n#-------------------------------------------------------------------------------------------------------\n# Specify the root script execution mode.\n#\n#   - true  : To execute the root script automatically by using the appropriate configuration methods.\n#   - false : To execute the root script manually.\n#\n# If this option is selected, password should be specified on the console.\n#-------------------------------------------------------------------------------------------------------\n<strong>oracle.install.db.rootconfig.executeRootScript=false<\/strong>\n\n#--------------------------------------------------------------------------------------\n# Specify the configuration method to be used for automatic root script execution.\n#\n# Following are the possible choices:\n#   - ROOT\n#   - SUDO\n#--------------------------------------------------------------------------------------\noracle.install.db.rootconfig.configMethod=\n#--------------------------------------------------------------------------------------\n# Specify the absolute path of the sudo program.\n#\n# Applicable only when SUDO configuration method was chosen.\n#--------------------------------------------------------------------------------------\noracle.install.db.rootconfig.sudoPath=\n\n#--------------------------------------------------------------------------------------\n# Specify the name of the user who is in the sudoers list.\n# Applicable only when SUDO configuration method was chosen.\n# Note:For Single Instance database installations,the sudo user name must be the username of the user installing the database.\n#--------------------------------------------------------------------------------------\noracle.install.db.rootconfig.sudoUserName=\n\n###############################################################################\n#                                                                             #\n#                               Grid Options                                  #\n#                                                                             #\n###############################################################################\n\n#------------------------------------------------------------------------------\n# Value is required only if the specified install option is INSTALL_DB_SWONLY\n#\n# Specify the cluster node names selected during the installation.\n#\n# Example : oracle.install.db.CLUSTER_NODES=node1,node2\n#------------------------------------------------------------------------------\noracle.install.db.CLUSTER_NODES=\n\n###############################################################################\n#                                                                             #\n#                        Database Configuration Options                       #\n#                                                                             #\n###############################################################################\n\n#-------------------------------------------------------------------------------\n# Specify the type of database to create.\n# It can be one of the following:\n#   - GENERAL_PURPOSE\n#   - DATA_WAREHOUSE\n# GENERAL_PURPOSE: A starter database designed for general purpose use or transaction-heavy applications.\n# DATA_WAREHOUSE : A starter database optimized for data warehousing applications.\n#-------------------------------------------------------------------------------\noracle.install.db.config.starterdb.type=\n\n#-------------------------------------------------------------------------------\n# Specify the Starter Database Global Database Name.\n#-------------------------------------------------------------------------------\noracle.install.db.config.starterdb.globalDBName=\n\n#-------------------------------------------------------------------------------\n# Specify the Starter Database SID.\n#-------------------------------------------------------------------------------\noracle.install.db.config.starterdb.SID=\n\n#-------------------------------------------------------------------------------\n# Specify whether the database should be configured as a Container database.\n# The value can be either \"true\" or \"false\". If left blank it will be assumed\n# to be \"false\".\n#-------------------------------------------------------------------------------\noracle.install.db.ConfigureAsContainerDB=\n\n#-------------------------------------------------------------------------------\n# Specify the  Pluggable Database name for the pluggable database in Container Database.\n#-------------------------------------------------------------------------------\noracle.install.db.config.PDBName=\n\n#-------------------------------------------------------------------------------\n# Specify the Starter Database character set.\n#\n#  One of the following\n#  AL32UTF8, WE8ISO8859P15, WE8MSWIN1252, EE8ISO8859P2,\n#  EE8MSWIN1250, NE8ISO8859P10, NEE8ISO8859P4, BLT8MSWIN1257,\n#  BLT8ISO8859P13, CL8ISO8859P5, CL8MSWIN1251, AR8ISO8859P6,\n#  AR8MSWIN1256, EL8ISO8859P7, EL8MSWIN1253, IW8ISO8859P8,\n#  IW8MSWIN1255, JA16EUC, JA16EUCTILDE, JA16SJIS, JA16SJISTILDE,\n#  KO16MSWIN949, ZHS16GBK, TH8TISASCII, ZHT32EUC, ZHT16MSWIN950,\n#  ZHT16HKSCS, WE8ISO8859P9, TR8MSWIN1254, VN8MSWIN1258\n#-------------------------------------------------------------------------------\noracle.install.db.config.starterdb.characterSet=\n\n#------------------------------------------------------------------------------\n# This variable should be set to true if Automatic Memory Management\n# in Database is desired.\n# If Automatic Memory Management is not desired, and memory allocation\n# is to be done manually, then set it to false.\n#------------------------------------------------------------------------------\noracle.install.db.config.starterdb.memoryOption=\n\n#-------------------------------------------------------------------------------\n# Specify the total memory allocation for the database. Value(in MB) should be\n# at least 256 MB, and should not exceed the total physical memory available\n# on the system.\n# Example: oracle.install.db.config.starterdb.memoryLimit=512\n#-------------------------------------------------------------------------------\noracle.install.db.config.starterdb.memoryLimit=\n\n#-------------------------------------------------------------------------------\n# This variable controls whether to load Example Schemas onto\n# the starter database or not.\n# The value can be either \"true\" or \"false\". If left blank it will be assumed\n# to be \"false\".\n#-------------------------------------------------------------------------------\noracle.install.db.config.starterdb.installExampleSchemas=\n\n###############################################################################\n#                                                                             #\n# Passwords can be supplied for the following four schemas in the             #\n# starter database:                                                           #\n#   SYS                                                                       #\n#   SYSTEM                                                                    #\n#   DBSNMP (used by Enterprise Manager)                                       #\n#                                                                             #\n# Same password can be used for all accounts (not recommended)                #\n# or different passwords for each account can be provided (recommended)       #\n#                                                                             #\n###############################################################################\n\n#------------------------------------------------------------------------------\n# This variable holds the password that is to be used for all schemas in the\n# starter database.\n#-------------------------------------------------------------------------------\noracle.install.db.config.starterdb.password.ALL=\n\n#-------------------------------------------------------------------------------\n# Specify the SYS password for the starter database.\n#-------------------------------------------------------------------------------\noracle.install.db.config.starterdb.password.SYS=\n\n#-------------------------------------------------------------------------------\n# Specify the SYSTEM password for the starter database.\n#-------------------------------------------------------------------------------\noracle.install.db.config.starterdb.password.SYSTEM=\n\n#-------------------------------------------------------------------------------\n# Specify the DBSNMP password for the starter database.\n# Applicable only when oracle.install.db.config.starterdb.managementOption=CLOUD_CONTROL\n#-------------------------------------------------------------------------------\noracle.install.db.config.starterdb.password.DBSNMP=\n\n#-------------------------------------------------------------------------------\n# Specify the PDBADMIN password required for creation of Pluggable Database in the Container Database.\n#-------------------------------------------------------------------------------\noracle.install.db.config.starterdb.password.PDBADMIN=\n\n#-------------------------------------------------------------------------------\n# Specify the management option to use for managing the database.\n# Options are:\n# 1. CLOUD_CONTROL - If you want to manage your database with Enterprise Manager Cloud Control along with Database Express.\n# 2. DEFAULT   -If you want to manage your database using the default Database Express option.\n#-------------------------------------------------------------------------------\noracle.install.db.config.starterdb.managementOption=\n\n#-------------------------------------------------------------------------------\n# Specify the OMS host to connect to Cloud Control.\n# Applicable only when oracle.install.db.config.starterdb.managementOption=CLOUD_CONTROL\n#-------------------------------------------------------------------------------\noracle.install.db.config.starterdb.omsHost=\n\n#-------------------------------------------------------------------------------\n# Specify the OMS port to connect to Cloud Control.\n# Applicable only when oracle.install.db.config.starterdb.managementOption=CLOUD_CONTROL\n#-------------------------------------------------------------------------------\noracle.install.db.config.starterdb.omsPort=\n\n#-------------------------------------------------------------------------------\n# Specify the EM Admin user name to use to connect to Cloud Control.\n# Applicable only when oracle.install.db.config.starterdb.managementOption=CLOUD_CONTROL\n#-------------------------------------------------------------------------------\noracle.install.db.config.starterdb.emAdminUser=\n\n#-------------------------------------------------------------------------------\n# Specify the EM Admin password to use to connect to Cloud Control.\n# Applicable only when oracle.install.db.config.starterdb.managementOption=CLOUD_CONTROL\n#-------------------------------------------------------------------------------\noracle.install.db.config.starterdb.emAdminPassword=\n\n###############################################################################\n#                                                                             #\n# SPECIFY RECOVERY OPTIONS                                                    #\n# ------------------------------------                                        #\n# Recovery options for the database can be mentioned using the entries below  #\n#                                                                             #\n###############################################################################\n\n#------------------------------------------------------------------------------\n# This variable is to be set to false if database recovery is not required. Else\n# this can be set to true.\n#-------------------------------------------------------------------------------\noracle.install.db.config.starterdb.enableRecovery=\n\n#-------------------------------------------------------------------------------\n# Specify the type of storage to use for the database.\n# It can be one of the following:\n#   - FILE_SYSTEM_STORAGE\n#   - ASM_STORAGE\n#-------------------------------------------------------------------------------\noracle.install.db.config.starterdb.storageType=\n\n#-------------------------------------------------------------------------------\n# Specify the database file location which is a directory for datafiles, control\n# files, redo logs.\n#\n# Applicable only when oracle.install.db.config.starterdb.storage=FILE_SYSTEM_STORAGE\n#-------------------------------------------------------------------------------\noracle.install.db.config.starterdb.fileSystemStorage.dataLocation=\n\n#-------------------------------------------------------------------------------\n# Specify the recovery location.\n#\n# Applicable only when oracle.install.db.config.starterdb.storage=FILE_SYSTEM_STORAGE\n#-------------------------------------------------------------------------------\noracle.install.db.config.starterdb.fileSystemStorage.recoveryLocation=\n\n#-------------------------------------------------------------------------------\n# Specify the existing ASM disk groups to be used for storage.\n#\n# Applicable only when oracle.install.db.config.starterdb.storageType=ASM_STORAGE\n#-------------------------------------------------------------------------------\noracle.install.db.config.asm.diskGroup=\n\n#-------------------------------------------------------------------------------\n# Specify the password for ASMSNMP user of the ASM instance.\n#\n# Applicable only when oracle.install.db.config.starterdb.storage=ASM_STORAGE\n#-------------------------------------------------------------------------------\noracle.install.db.config.asm.ASMSNMPPassword=<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\">3\ufe0f\u20e3 Post-Installation Verification Checklist<\/h2>\n\n\n\n<pre class=\"wp-block-code\"><code># ---------------------------------------------------------\n# Oracle 19c Post-Installation Verification Checklist\n# ---------------------------------------------------------\n\n# Verify environment:\necho $ORACLE_HOME\necho $ORACLE_SID\necho $ORACLE_BASE\nsource ~\/.bash_profile\n\n# Check listener:\nlsnrctl status\n# If not running:\nlsnrctl start\n\n# Create listener.ora if needed:\nvi $ORACLE_HOME\/network\/admin\/listener.ora\nLISTENER =\n  (DESCRIPTION_LIST =\n    (DESCRIPTION =\n      (ADDRESS = (PROTOCOL = TCP)(HOST = vbox)(PORT = 1521))\n      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))\n    )\n  )\nDEDICATED_THROUGH_BROKER_LISTENER = ON\nDIAG_ADR_ENABLED = ON\nSID_LIST_LISTENER =\n  (SID_LIST =\n    (SID_DESC =\n      (GLOBAL_DBNAME = ORCL)\n      (ORACLE_HOME = \/u01\/app\/oracle\/product\/19.0.0\/dbhome_1)\n      (SID_NAME = ORCL)\n    )\n  )\n\n# Reload:\nlsnrctl reload\nlsnrctl status\n\n# Verify tnsnames.ora:\nvi $ORACLE_HOME\/network\/admin\/tnsnames.ora\nORCL =\n  (DESCRIPTION =\n    (ADDRESS = (PROTOCOL = TCP)(HOST = vbox)(PORT = 1521))\n    (CONNECT_DATA =\n      (SERVICE_NAME = ORCL)\n    )\n  )\nPDB1 =\n  (DESCRIPTION =\n    (ADDRESS = (PROTOCOL = TCP)(HOST = vbox)(PORT = 1521))\n    (CONNECT_DATA =\n      (SERVICE_NAME = pdb1)\n    )\n  )\n\n# Connect to SQL*Plus:\nsqlplus \/ as sysdba\n\n# Check database status:\nset lines 200 pages 200\ncol name for a10\ncol db_unique_name for a15\ncol open_mode for a15\ncol log_mode for a15\ncol logins for a8\ncol instance_name for a15\ncol host_name for a15\nalter session set nls_date_format='DD\/MM\/YYYY HH24:MI:SS';\nselect name,db_unique_name,created,open_mode,log_mode,logins,instance_name,database_role,host_name,startup_time from v$instance,v$database;\n\n# Check PDBs:\nSHOW CON_NAME;\nSELECT NAME, OPEN_MODE FROM V$PDBS;\nALTER PLUGGABLE DATABASE ALL OPEN;\nSHOW PDBS;\n\n# If needed:\nALTER SESSION SET CONTAINER=PDB1;\n\n# Check datafiles:\nSELECT NAME FROM V$DATAFILE;\n\n# Check FRA:\nSELECT SPACE_LIMIT\/1024\/1024\/1024 AS GB_LIMIT, SPACE_USED\/1024\/1024\/1024 AS GB_USED FROM V$RECOVERY_FILE_DEST;\n\n# Verify connectivity:\nsqlplus sys\/Kallu2025#\\$@localhost:1521\/ORCL_LAB as sysdba\n\n# Optional: Create additional PDBs\nCREATE PLUGGABLE DATABASE CUSTDB1 \n  ADMIN USER pdbadmin IDENTIFIED BY StrongPass123\n  FILE_NAME_CONVERT=('\/u02\/oradata\/ORCL\/pdbseed','\/u02\/oradata\/ORCL\/CUSTDB1');\nALTER PLUGGABLE DATABASE CUSTDB1 OPEN;\nALTER PLUGGABLE DATABASE CUSTDB1 SAVE STATE;\n\n# \u2705 Oracle 19c Fully Installed, Verified, and Ready for W3Buddy Labs<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"<p>In this guide, you\u2019ll learn how to perform a fully silent Oracle 19c installation and create a database on Oracle Linux 8, step-by-step. We cover pre-setup, download, silent install, and post checks to get your lab or project environment ready quickly and cleanly. 1\ufe0f\u20e3 Pre-Installation Preparation (Prestuff) 2\ufe0f\u20e3 Download, Installation &amp; DB Creation Refer Ready [&hellip;]<\/p>\n","protected":false},"template":"","meta":{"googlesitekit_rrm_CAowu461DA:productID":""},"categories":[952,984],"class_list":["post-4669","cposts","type-cposts","status-publish","hentry","category-notes","category-oracle-dba-d2d-tasks"],"_links":{"self":[{"href":"https:\/\/w3buddy.com\/blog\/wp-json\/wp\/v2\/cposts\/4669","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/w3buddy.com\/blog\/wp-json\/wp\/v2\/cposts"}],"about":[{"href":"https:\/\/w3buddy.com\/blog\/wp-json\/wp\/v2\/types\/cposts"}],"wp:attachment":[{"href":"https:\/\/w3buddy.com\/blog\/wp-json\/wp\/v2\/media?parent=4669"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/w3buddy.com\/blog\/wp-json\/wp\/v2\/categories?post=4669"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}