Installing Oracle Database RPM Manually
1. Log in asroot.2. Download and install the Oracle Preinstallation RPM: here
Oracle Database Preinstall check got filed due to Package errors (libaio-devel, compact-libstdc++-33 and ksh)
Install required packagers to fix the preinstall check failure.
[code] [root@localhost Packages]# rpm -ivh libaio-devel-0.3.109-13.el7. libaio-devel-0.3.109-13.el7.i686.rpm libaio-devel-0.3.109-13.el7.x86_64.rpm [root@localhost Packages]# rpm -ivh libaio-devel-0.3.109-13.el7.x86_64.rpm warning: libaio-devel-0.3.109-13.el7.x86_64.rpm: Header V3 RSA/SHA256 Signature, key ID fd431d51: NOKEY Preparing... ################################# [100%] Updating / installing... 1:libaio-devel-0.3.109-13.el7 ################################# [100%] [root@localhost Packages]# rpm -ivh ksh-20120801-137.el7.x86_64.rpm warning: ksh-20120801-137.el7.x86_64.rpm: Header V3 RSA/SHA256 Signature, key ID fd431d51: NOKEY Preparing... ################################# [100%] Updating / installing... 1:ksh-20120801-137.el7 ################################# [100%] [root@localhost Packages]# cd /media/sf_Oracle/rpm/ [root@localhost rpm]# ls -lrt total 2744820 -rwxrwx---. 1 root vboxsf 115791336 Jan 20 21:00 VirtualBox-6.0-6.0.17_135763_el7-1.x86_64.rpm -rwxrwx---. 1 root vboxsf 15264 Jan 20 21:01 epel-release-latest-7.noarch.rpm -rwxrwx---. 1 root vboxsf 194444 Jan 20 22:32 compat-libstdc++-33-3.2.3-72.el7.x86_64.rpm -rwxrwx---. 1 root vboxsf 18204 Jan 24 06:26 oracle-database-preinstall-19c-1.0-1.el7.x86_64.rpm -rwxrwx---. 1 root vboxsf 2694664264 Jan 24 06:39 oracle-database-ee-19c-1.0-1.x86_64.rpm [root@localhost rpm]# rpm -ivh compat-libstdc++-33-3.2.3-72.el7.x86_64.rpm warning: compat-libstdc++-33-3.2.3-72.el7.x86_64.rpm: Header V4 DSA/SHA1 Signature, key ID 192a7d7d: NOKEY Preparing... ################################# [100%] Updating / installing... 1:compat-libstdc++-33-3.2.3-72.el7 ################################# [100%] [/code]
[code] [root@localhost rpm]# yum -y localinstall oracle-database-preinstall-19c-1.0-1.el7.x86_64.rpm Loaded plugins: langpacks, product-id, search-disabled-repos, subscription-manager This system is not registered with an entitlement server. You can use subscription-manager to register. Examining oracle-database-preinstall-19c-1.0-1.el7.x86_64.rpm: oracle-database-preinstall-19c-1.0-1.el7.x86_64 Marking oracle-database-preinstall-19c-1.0-1.el7.x86_64.rpm to be installed Resolving Dependencies --> Running transaction check ---> Package oracle-database-preinstall-19c.x86_64 0:1.0-1.el7 will be installed --> Finished Dependency Resolution Dependencies Resolved ============================================================================================================================ Package Arch Version Repository Size ============================================================================================================================ Installing: oracle-database-preinstall-19c x86_64 1.0-1.el7 /oracle-database-preinstall-19c-1.0-1.el7.x86_64 55 k Transaction Summary ============================================================================================================================ Install 1 Package Total size: 55 k Installed size: 55 k Downloading packages: Running transaction check Running transaction test Transaction test succeeded Running transaction Warning: RPMDB altered outside of yum. Installing : oracle-database-preinstall-19c-1.0-1.el7.x86_64 1/1 Verifying : oracle-database-preinstall-19c-1.0-1.el7.x86_64 1/1 Installed: oracle-database-preinstall-19c.x86_64 0:1.0-1.el7 Complete! [/code]
3. Access the software download page for Oracle Database RPM-based installation from Oracle Technology Network: here
4. Download the
Where, oracle-database-ee-19c-1.0-1.x86_64.rpm is the fully qualified name of the Oracle Database RPM.
[code] [root@localhost rpm]# pwd /media/sf_Oracle/rpm [root@localhost rpm]# ls -lrt oracle-database-ee-19c-1.0-1.x86_64.rpm -rwxrwx---. 1 root vboxsf 2694664264 Jan 24 06:39 oracle-database-ee-19c-1.0-1.x86_64.rpm [root@localhost rpm]# yum -y localinstall oracle-database-ee-19c-1.0-1.x86_64.rpm Loaded plugins: langpacks, product-id, search-disabled-repos, subscription-manager This system is not registered with an entitlement server. You can use subscription-manager to register. Examining oracle-database-ee-19c-1.0-1.x86_64.rpm: oracle-database-ee-19c-1.0-1.x86_64 Marking oracle-database-ee-19c-1.0-1.x86_64.rpm to be installed Resolving Dependencies --> Running transaction check ---> Package oracle-database-ee-19c.x86_64 0:1.0-1 will be installed --> Finished Dependency Resolution Dependencies Resolved ============================================================================================================================================================================================= Package Arch Version Repository Size ============================================================================================================================================================================================= Installing: oracle-database-ee-19c x86_64 1.0-1 /oracle-database-ee-19c-1.0-1.x86_64 6.9 G Transaction Summary ============================================================================================================================================================================================= Install 1 Package Total size: 6.9 G Installed size: 6.9 G Downloading packages: Running transaction check Running transaction test Transaction test succeeded Running transaction Installing : oracle-database-ee-19c-1.0-1.x86_64 1/1 [INFO] Executing post installation scripts... [INFO] Oracle home installed successfully and ready to be configured. To configure a sample Oracle Database you can execute the following service configuration script as root: /etc/init.d/oracledb_ORCLCDB-19c configure Verifying : oracle-database-ee-19c-1.0-1.x86_64 1/1 Installed: oracle-database-ee-19c.x86_64 0:1.0-1 Complete! [/code]
The installation of Oracle Database software is now complete.
Creating and Configuring an Oracle Database
To create a sample database with the default settings, perform the following steps:
1. Log in as root
2. To configure a sample Oracle Database instance, run the following service configuration script:
[code]
# /etc/init.d/oracledb_ORCLCDB-19c configure
[root@localhost rpm]# cd
[root@localhost ~]# /etc/init.d/oracledb_ORCLCDB-19c configure
Configuring Oracle Database ORCLCDB.
Prepare for db operation
8% complete
Copying database files
31% complete
Creating and starting Oracle instance
32% complete
36% complete
40% complete
43% complete
46% complete
Completing Database Creation
51% complete
54% complete
Creating Pluggable Databases
58% complete
77% complete
Executing Post Configuration Actions
100% complete
Database creation complete. For details check the logfiles at:
/opt/oracle/cfgtoollogs/dbca/ORCLCDB.
Database Information:
Global Database Name:ORCLCDB
System Identifier(SID):ORCLCDB
Look at the log file "/opt/oracle/cfgtoollogs/dbca/ORCLCDB/ORCLCDB.log" for further details.
Database configuration completed successfully. The passwords were auto generated, you must change them by connecting to the database using 'sqlplus / as sysdba' as the oracle user.
[/code]
Check the connection and CDB/PDB details.
[code] [oracle@localhost ~]$ sqlplus / as sysdba SQL*Plus: Release 19.0.0.0.0 - Production on Mon Jan 27 00:18:05 2020 Version 19.3.0.0.0 Copyright (c) 1982, 2019, Oracle. All rights reserved. Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.3.0.0.0 SQL> select name from v$database; NAME --------- ORCLCDB SQL> col name for a20 SQL> col pdb for a20 SQL> select name , pdb from v$services order by name; NAME PDB -------------------- -------------------- ORCLCDB CDB$ROOT ORCLCDBXDB CDB$ROOT SYS$BACKGROUND CDB$ROOT SYS$USERS CDB$ROOT orclpdb1 ORCLPDB1 [/code]
Install required packagers to fix the preinstall check failure.
[code] [root@localhost Packages]# rpm -ivh libaio-devel-0.3.109-13.el7. libaio-devel-0.3.109-13.el7.i686.rpm libaio-devel-0.3.109-13.el7.x86_64.rpm [root@localhost Packages]# rpm -ivh libaio-devel-0.3.109-13.el7.x86_64.rpm warning: libaio-devel-0.3.109-13.el7.x86_64.rpm: Header V3 RSA/SHA256 Signature, key ID fd431d51: NOKEY Preparing... ################################# [100%] Updating / installing... 1:libaio-devel-0.3.109-13.el7 ################################# [100%] [root@localhost Packages]# rpm -ivh ksh-20120801-137.el7.x86_64.rpm warning: ksh-20120801-137.el7.x86_64.rpm: Header V3 RSA/SHA256 Signature, key ID fd431d51: NOKEY Preparing... ################################# [100%] Updating / installing... 1:ksh-20120801-137.el7 ################################# [100%] [root@localhost Packages]# cd /media/sf_Oracle/rpm/ [root@localhost rpm]# ls -lrt total 2744820 -rwxrwx---. 1 root vboxsf 115791336 Jan 20 21:00 VirtualBox-6.0-6.0.17_135763_el7-1.x86_64.rpm -rwxrwx---. 1 root vboxsf 15264 Jan 20 21:01 epel-release-latest-7.noarch.rpm -rwxrwx---. 1 root vboxsf 194444 Jan 20 22:32 compat-libstdc++-33-3.2.3-72.el7.x86_64.rpm -rwxrwx---. 1 root vboxsf 18204 Jan 24 06:26 oracle-database-preinstall-19c-1.0-1.el7.x86_64.rpm -rwxrwx---. 1 root vboxsf 2694664264 Jan 24 06:39 oracle-database-ee-19c-1.0-1.x86_64.rpm [root@localhost rpm]# rpm -ivh compat-libstdc++-33-3.2.3-72.el7.x86_64.rpm warning: compat-libstdc++-33-3.2.3-72.el7.x86_64.rpm: Header V4 DSA/SHA1 Signature, key ID 192a7d7d: NOKEY Preparing... ################################# [100%] Updating / installing... 1:compat-libstdc++-33-3.2.3-72.el7 ################################# [100%] [/code]
Run the preinstall RPM again
[code] [root@localhost rpm]# yum -y localinstall oracle-database-preinstall-19c-1.0-1.el7.x86_64.rpm Loaded plugins: langpacks, product-id, search-disabled-repos, subscription-manager This system is not registered with an entitlement server. You can use subscription-manager to register. Examining oracle-database-preinstall-19c-1.0-1.el7.x86_64.rpm: oracle-database-preinstall-19c-1.0-1.el7.x86_64 Marking oracle-database-preinstall-19c-1.0-1.el7.x86_64.rpm to be installed Resolving Dependencies --> Running transaction check ---> Package oracle-database-preinstall-19c.x86_64 0:1.0-1.el7 will be installed --> Finished Dependency Resolution Dependencies Resolved ============================================================================================================================ Package Arch Version Repository Size ============================================================================================================================ Installing: oracle-database-preinstall-19c x86_64 1.0-1.el7 /oracle-database-preinstall-19c-1.0-1.el7.x86_64 55 k Transaction Summary ============================================================================================================================ Install 1 Package Total size: 55 k Installed size: 55 k Downloading packages: Running transaction check Running transaction test Transaction test succeeded Running transaction Warning: RPMDB altered outside of yum. Installing : oracle-database-preinstall-19c-1.0-1.el7.x86_64 1/1 Verifying : oracle-database-preinstall-19c-1.0-1.el7.x86_64 1/1 Installed: oracle-database-preinstall-19c.x86_64 0:1.0-1.el7 Complete! [/code]
3. Access the software download page for Oracle Database RPM-based installation from Oracle Technology Network: here
4. Download the
.rpm file required for performing an RPM-based installation to a directory of your choice. For example, download the oracle-database-ee-19c-1.0-1.x86_64.rpm file to the /media/sf_Oracle/rpm directory.Where, oracle-database-ee-19c-1.0-1.x86_64.rpm is the fully qualified name of the Oracle Database RPM.
[code] [root@localhost rpm]# pwd /media/sf_Oracle/rpm [root@localhost rpm]# ls -lrt oracle-database-ee-19c-1.0-1.x86_64.rpm -rwxrwx---. 1 root vboxsf 2694664264 Jan 24 06:39 oracle-database-ee-19c-1.0-1.x86_64.rpm [root@localhost rpm]# yum -y localinstall oracle-database-ee-19c-1.0-1.x86_64.rpm Loaded plugins: langpacks, product-id, search-disabled-repos, subscription-manager This system is not registered with an entitlement server. You can use subscription-manager to register. Examining oracle-database-ee-19c-1.0-1.x86_64.rpm: oracle-database-ee-19c-1.0-1.x86_64 Marking oracle-database-ee-19c-1.0-1.x86_64.rpm to be installed Resolving Dependencies --> Running transaction check ---> Package oracle-database-ee-19c.x86_64 0:1.0-1 will be installed --> Finished Dependency Resolution Dependencies Resolved ============================================================================================================================================================================================= Package Arch Version Repository Size ============================================================================================================================================================================================= Installing: oracle-database-ee-19c x86_64 1.0-1 /oracle-database-ee-19c-1.0-1.x86_64 6.9 G Transaction Summary ============================================================================================================================================================================================= Install 1 Package Total size: 6.9 G Installed size: 6.9 G Downloading packages: Running transaction check Running transaction test Transaction test succeeded Running transaction Installing : oracle-database-ee-19c-1.0-1.x86_64 1/1 [INFO] Executing post installation scripts... [INFO] Oracle home installed successfully and ready to be configured. To configure a sample Oracle Database you can execute the following service configuration script as root: /etc/init.d/oracledb_ORCLCDB-19c configure Verifying : oracle-database-ee-19c-1.0-1.x86_64 1/1 Installed: oracle-database-ee-19c.x86_64 0:1.0-1 Complete! [/code]
The installation of Oracle Database software is now complete.
Creating and Configuring an Oracle Database
To create a sample database with the default settings, perform the following steps:
1. Log in as root
.2. To configure a sample Oracle Database instance, run the following service configuration script:
Note:
You can modify the configuration parameters by editing the /etc/sysconfig/oracledb_ORCLCDB-19c.conf file.
This script creates a container database (
ORCLCDB) with one pluggable database (ORCLPDB1) and configures the listener at the default port (1521).
Oracle will be installed under /opt (/opt/oracle/product/19c/dbhome_1)
[code]
[oracle@localhost dbhome_1]$ pwd
/opt/oracle/product/19c/dbhome_1
[oracle@localhost dbhome_1]$ ls
addnode dbs inventory odbc plsql sqldeveloper
apex deinstall javavm olap precomp sqlj
assistants demo jdbc OPatch QOpatch sqlpatch
bin diagnostics jdk opmn R sqlplus
cfgtoollogs dmu jlib oracore racg srvm
clone drdaas ldap oraInst.loc rdbms suptools
crs dv lib ord relnotes ucp
css env.ora log ords root.sh usm
ctx has md oss runInstaller utl
cv hs mgw oui schagent.conf wwg
data install network owm sdk xdk
dbjava instantclient nls perl slax
[/code]
Check the connection and CDB/PDB details.
[code] [oracle@localhost ~]$ sqlplus / as sysdba SQL*Plus: Release 19.0.0.0.0 - Production on Mon Jan 27 00:18:05 2020 Version 19.3.0.0.0 Copyright (c) 1982, 2019, Oracle. All rights reserved. Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.3.0.0.0 SQL> select name from v$database; NAME --------- ORCLCDB SQL> col name for a20 SQL> col pdb for a20 SQL> select name , pdb from v$services order by name; NAME PDB -------------------- -------------------- ORCLCDB CDB$ROOT ORCLCDBXDB CDB$ROOT SYS$BACKGROUND CDB$ROOT SYS$USERS CDB$ROOT orclpdb1 ORCLPDB1 [/code]
No comments:
Post a Comment