Tag Archives: 18c

Grid Infrastructure, Linux, Oracle, Silent Installation

How to install Oracle 18c in silent mode

1 Comment
FacebooktwitterredditpinterestlinkedinmailFacebooktwitterredditpinterestlinkedinmail

installation Of Oracle 18c in silent mode

This installation is for:

Oracle Linux Server release 7.7
Oracle Database 18c Enterprise Edition Release 18.0.0.0.0

Disabling SELINUX:

[root@dba18 ~]# vi /etc/selinux/config
[root@dba18 ~]# cat /etc/selinux/config
SELINUX=disabled
SELINUXTYPE=targeted

Disabling the Firewall:

[root@dba18 ~]# service firewalld stop
Redirecting to /bin/systemctl stop firewalld.service
[root@dba18 ~]# systemctl disable firewalld
Removed symlink /etc/systemd/system/multi-user.target.wants/firewalld.service.
Removed symlink /etc/syst
… Read more
Database Administration, diag and trace, Grid Infrastructure, Linux, Oracle

How to Delete alert log files, Trace Files Automated in Oracle Database

Leave a comment
FacebooktwitterredditpinterestlinkedinmailFacebooktwitterredditpinterestlinkedinmail

Deleting  alert log files, Trace Files Automated in Oracle Database

[oracle@localhost ~]$ adrci

ADRCI: Release 12.1.0.2.0 - Production on Tue Mar 7 10:42:16 2018

Copyright (c) 1982, 2014, Oracle and/or its affiliates. All rights reserved.

ADR base = "/u01/app/grid"
adrci> show homes
ADR Homes:
diag/rdbms/_mgmtdb/-MGMTDB
diag/asm/+asm/+ASM2
diag/clients/user_root/host_1450230238_82
diag/clients/user_grid/host_1450230238_82
diag/crs/node2/crs
diag/tnslsnr/node2/mgmtlsnr
diag/tnslsnr/node2/listener
diag/tnslsnr/node2/listener_scan1
adrci> show h
… Read more
Backup & Recovery, Linux, Oracle, pluggable database, Unpluggable database

Plugging an Unplugged Pluggable Database with No copy method

Leave a comment
FacebooktwitterredditpinterestlinkedinmailFacebooktwitterredditpinterestlinkedinmail

Plugging an Unplugged Pluggable Database

Unplugging the PDB

To unplug a PDB, you first close it and then generate an XML manifest file. The XML file contains information about the names and the full paths of the tablespaces, datafiles of the unplugged PDB. The information will be used by the plugging operation.
We are going to unplug the PDB to plug them with No copy methods.

[oracle@localhost pdb3]$ . oraenv
ORACLE_SID = [cdb1] ? cdb1
The Oracle base remains unchanged with value /u01/app/oracle

[oracle@localhost pdb3]$ sqlplus / as sysdba

SQL> show con_name

CON_NAME
----------------
… Read more
Backup & Recovery, Linux, Oracle, pluggable database, Unpluggable database

Plugging an Unplugged Pluggable Database with copy method

3 Comments
FacebooktwitterredditpinterestlinkedinmailFacebooktwitterredditpinterestlinkedinmail

Plugging an Unplugged Pluggable Database

Unplugging the PDB

To unplug a PDB, you first close it and then generate an XML manifest file. The XML file contains information about the names and the full paths of the tablespaces, datafiles of the unplugged PDB. The information will be used by the plugging operation.

We are going to unplug the PDB to plug them with Copy methods.

[oracle@localhost pdb3]$ . oraenv
ORACLE_SID = [cdb1] ? cdb1
The Oracle base remains unchanged with value /u01/app/oracle

[oracle@localhost pdb3]$ sqlplus / as sysdba

SQL> show con_name

CON_NAME
------------------
… Read more
Database Administration, Linux, Oracle

Installation of 18c oracle binaries and Database at same time

1 Comment
FacebooktwitterredditpinterestlinkedinmailFacebooktwitterredditpinterestlinkedinmail

In this Article you will se how to install oracle 18c binaries as well as Database

Step 1 :
Disable firewall and selinux:
first check the status of firewalld status weather is active or not:

[root@localhost /]# systemctl status firewalld
● firewalld.service – firewalld – dynamic firewall daemon
Loaded: loaded (/usr/lib/systemd/system/firewalld.service; enabled; vendor preset: enabled)
Active: active (running) since Mon 2021-05-03 01:47:30 IST; 4h 12min ago
Docs: man:firewalld(1)
Main PID: 957 (firewalld)
Tasks: 2
CGroup: /system.slice/firewalld.service
└─957 … Read more