Skip to content
Advertisements

Archive for

Oracle database 18c yum installation on Oracle linux 7.6

I have downloaded the oracle database 18c rpm package from oracle and have plan to install manually without ULN support.

Installing Oracle Database RPM Manually

 

[root@dbhost1 ~]# cat /etc/hosts
127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4
::1 localhost localhost.localdomain localhost6 localhost6.localdomain6
10.1.9.88 dbhost1.localdomain dbhost1

Download software :

https://www.oracle.com/technetwork/database/enterprise-edition/downloads/oracle18c-linux-180000-5022980.html

[root@dbhost1 ~]# yum -y install oracle-database-preinstall-18c
BDB2053 Freeing read locks for locker 0xbb: 12147/139929030764352
BDB2053 Freeing read locks for locker 0xbd: 12147/139929030764352
Loaded plugins: langpacks, ulninfo
Resolving Dependencies
–> Running transaction check
—> Package oracle-database-preinstall-18c.x86_64 0:1.0-1.el7 will be installed

–> Finished Dependency Resolution

Dependencies Resolved

========================================================================================================================================================================
Package Arch Version Repository Size
========================================================================================================================================================================
Installing:
oracle-database-preinstall-18c x86_64 1.0-1.el7 ol7_latest 18 k

Transaction Summary
========================================================================================================================================================================
Install 1 Package

Total download size: 18 k
Installed size: 55 k
Downloading packages:
oracle-database-preinstall-18c-1.0-1.el7.x86_64.rpm | 18 kB 00:00:02
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
Installing : oracle-database-preinstall-18c-1.0-1.el7.x86_64 1/1
Verifying : oracle-database-preinstall-18c-1.0-1.el7.x86_64 1/1

Installed:
oracle-database-preinstall-18c.x86_64 0:1.0-1.el7

Complete!

[root@dbhost1 install]# ls -ltr
total 6874960
drwxr-xr-x 7 oracle oinstall 117 Jan 26 2017 database
-rw-r–r– 1 root root 3586257564 Oct 24 2018 oracle-database-ee-18c-1.0-1.x86_64.rpm
-rwxrwxr-x. 1 oracle oinstall 3453696911 Jun 13 11:45 linuxx64_12201_database.zip

Install database software

[root@dbhost1 install]# yum -y localinstall oracle-database-ee-18c-1.0-1.x86_64.rpm
Loaded plugins: langpacks, ulninfo
Examining oracle-database-ee-18c-1.0-1.x86_64.rpm: oracle-database-ee-18c-1.0-1.x86_64
Marking oracle-database-ee-18c-1.0-1.x86_64.rpm to be installed
Resolving Dependencies
–> Running transaction check
—> Package oracle-database-ee-18c.x86_64 0:1.0-1 will be installed
–> Finished Dependency Resolution

Dependencies Resolved

========================================================================================================================================================================
Package Arch Version Repository Size
========================================================================================================================================================================
Installing:
oracle-database-ee-18c x86_64 1.0-1 /oracle-database-ee-18c-1.0-1.x86_64 7.8 G

Transaction Summary
========================================================================================================================================================================
Install 1 Package

Total size: 7.8 G
Installed size: 7.8 G
Downloading packages:
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
Installing : oracle-database-ee-18c-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-18c configure
Verifying : oracle-database-ee-18c-1.0-1.x86_64 1/1

Installed:
oracle-database-ee-18c.x86_64 0:1.0-1

Complete!

Oracle Database software created at /opt/oracle/product/18c/dbhome_1

Creating and Configuring an Oracle Database

there is a location to find the details for creating the database,

/etc/init.d/oracledb_ORCLCDB-18c

you can manually edit the db creation configuration. I modified the database name is UATCDB, Pluggable database is UATPDB1
As a root user, create the database.

[root@dbhost1 ~]# /etc/init.d/oracledb_UATCDB-18c configure
Configuring Oracle Database UATCDB.
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/UATCDB.
Database Information:
Global Database Name:UATCDB
System Identifier(SID):UATCDB
Look at the log file “/opt/oracle/cfgtoollogs/dbca/UATCDB/UATCDB.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.

Verify database Creation as oracle user

[oracle@dbhost1 ~]$ export ORACLE_HOME=/opt/oracle/product/18c/dbhome_1
[oracle@dbhost1 ~]$ export PATH=$ORACLE_HOME/bin:$PATH
[oracle@dbhost1 ~]$ export ORACLE_SID=UATDB
[oracle@dbhost1 ~]$ export ORACLE_SID=UATCDB
[oracle@dbhost1 ~]$ sqlplus / as sysdba

SQL*Plus: Release 18.0.0.0.0 – Production on Sun Jun 30 16:03:19 2019
Version 18.3.0.0.0

Copyright (c) 1982, 2018, Oracle. All rights reserved.

Connected to:
Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 – Production
Version 18.3.0.0.0

SQL> select name from v$database;

NAME
———
UATCDB

SQL> show user con_name
USER is “SYS”

CON_NAME
——————————
CDB$ROOT
SQL> select con_id, name from v$containers;

CON_ID
———-
NAME
——————————————————————————–
1
CDB$ROOT

2
PDB$SEED

3
UATPDB1

SQL>

Advertisements

Oracle database 12c (12.2.0.1.0) step by step installation guide on windows server 2016

Oracle Database 12cR2 installation documentation on Windows Server 2016

Oracle database 12c (12.2.0.1.0) step by step installation guide on windows server 2016

Oracle database 12c (12.2.0.1.0) step by step installation guide on oracle linux 7.6

Installation document :

Oracle Database 12.2.0.1.0 step by step installation guide on oracle linux 7.6

 

Issue faced:

 

[root@dbhost1 ~]# xhost +
access control disabled, clients can connect from any host
[root@dbhost1 ~]# su – oracle
Last login: Mon Jun 17 14:36:55 +03 2019 on pts/1
[oracle@dbhost1 ~]$ cd /u01/install/database/
[oracle@dbhost1 database]$ ./runInstaller
Starting Oracle Universal Installer…

Checking Temp space: must be greater than 500 MB. Actual 35971 MB Passed
Checking swap space: must be greater than 150 MB. Actual 2047 MB Passed
Checking monitor: must be configured to display at least 256 colors
>>> Could not execute auto check for display colors using command /usr/bin/xdpyinfo. Check if the DISPLAY variable is set. Failed <<<<

Some requirement checks failed. You must fulfill these requirements before

continuing with the installation,

Continue? (y/n) [n] n

User Selected: No

Exiting Oracle Universal Installer, log for this session can be found at /tmp/OraInstall2019-06-17_02-39-33PM/installActions2019-06-17_02-39-33PM.log

solution :

[oracle@dbhost1 database]$ export DISPLAY=:0
[oracle@dbhost1 database]$ ./runInstaller

ORA-19809 ORA-19804

I trying to open a one of our old database and I am getting following error

 

SQL> startup
ORACLE instance started.

Total System Global Area 5117050880 bytes
Fixed Size 8757424 bytes
Variable Size 1207963472 bytes
Database Buffers 3892314112 bytes
Redo Buffers 8015872 bytes
Database mounted.
ORA-03113: end-of-file on communication channel
Process ID: 7328
Session ID: 373 Serial number: 9392

 

Alert log file :

Errors in file C:\APP\ORACLE\diag\rdbms\auditdb\auditdb\trace\auditdb_ora_1280.trc:
ORA-16038: log 3 sequence# 63 cannot be archived
ORA-19809: limit exceeded for recovery files
ORA-00312: online log 3 thread 1: ‘C:\APP\ORACLE\ORADATA\AUDITDB\ONLINELOG\O1_MF_3_G3XO7R8J_.LOG’
ORA-00312: online log 3 thread 1: ‘C:\APP\ORACLE\FAST_RECOVERY_AREA\AUDITDB\AUDITDB\ONLINELOG\O1_MF_3_G3XO7YNR_.LOG’
2019-06-12T12:06:43.111652+03:00
USER (ospid: 1280): terminating the instance due to error 16038
ERROR: Unable to normalize symbol name for the following short stack (at offset 125):
dbgeGetAsyncActivForED()+939<-dbkif_record_dde_actions()+421<-ksuitm_opt()+2482<-ksuitm()+14<-kcfopd()+10758<-adbdrv_options..0()+38247<-adbdrv()+161<-opiexe()+29912<-opiosq0()+6886<-kpooprx()+464<-kpoal8()+1173<-opiodr()+1378<-ttcpip()+1368<-opitsk()+2474<-opiino()+1265<-opiodr()+1378<-opidrv()+1833<-sou2o()+112<-opimai_real()+499<-opimai()+231<-OracleThreadStart()+745<-00007FFDB0B084D4<-00007FFDB340E851
2019-06-12T12:06:43.181682+03:00
Errors in file C:\APP\ORACLE\diag\rdbms\auditdb\auditdb\trace\auditdb_tt00_12308.trc:
ORA-19809: limit exceeded for recovery files
ORA-19804: cannot reclaim 209715200 bytes disk space from 10009706496 bytes limit
2019-06-12T12:06:43.489757+03:00
System state dump requested by (instance=1, osid=1280), summary=[abnormal instance termination].
System State dumped to trace file C:\APP\ORACLE\diag\rdbms\auditdb\auditdb\trace\auditdb_diag_13476_20190612120643.trc
2019-06-12T12:06:47.049651+03:00
Instance terminated by USER, pid = 1280

 

Solution :

Deleted  the old archivelog file and reclaim space

SQL> startup mount
ORACLE instance started.

Total System Global Area 5117050880 bytes
Fixed Size 8757424 bytes
Variable Size 1207963472 bytes
Database Buffers 3892314112 bytes
Redo Buffers 8015872 bytes
Database mounted.

RMAN> crosscheck archivelog all;  or delete archivelog all

RMAN> delete expired archivelog all;

SQL> alter database open;

Database altered.

SQL> select status from v$instance;

STATUS
————
OPEN