Today we are going to have look on the topic of “PFile and SPFile”. This is the most important element of the Oracle database. Being Oracle DBA we must aware about “PFile and SPFile”. This file plays an important role in Oracle database. Let’s have look at the technical definition of “PFile and SPFile”. It will be […]
All posts by Anuradha Mudgal
Anuradha Mudgal
How to Check/Validate That RMAN Backups Are Good
From today’s post, I am going to remind you all about those colleges day when we used to learn about the validation in programming languages. In daily life are aware of validation. In the database world, it is little different. Let’s have look at the types of validation in general terms. Some of […]
Installing Oracle Database Using RPM Packages in Oracle 18c
Starting with Oracle Database 18c, you can use the Oracle Preinstallation RPM and the rpm -ivh command to perform an RPM-based single-instance Oracle Database or Oracle Database Client installation. Note: An RPM-based Oracle Database installation is supported only on Oracle Linux systems. Use RPM packages to perform a single-instance, Oracle Database installation on Oracle Linux […]
Purging AUDIT TRAIL RECORDS -AUD$ Table
Today we are going to have look at the database security’s phase. In this phase, we are going to have look at Purging AUDIT TRAIL RECORDS The parameterAUDIT_TRAIL_TYPE is specified using one of three constants. DBMS_AUDIT_MGMT.AUDIT_TRAIL_AUD_STD: Standard audit trail (AUD$). DBMS_AUDIT_MGMT.AUDIT_TRAIL_FGA_STD: Fine-grained audit trail (FGA_LOG$). DBMS_AUDIT_MGMT.AUDIT_TRAIL_DB_STD: Both standard and fine-grained audit trails. If you want […]
Facts about Instance
Today we are going to have look at some more interesting facts about “Oracle Technology”. This post about is the “ASM Instance and Database Instance”. Being an Oracle DBA our Oracle journey starts with Database Instance. As we go into the deep knowledge of Oracle we get new terms of Oracle technology. We are going to learn about ASM instance and […]
Updating dbaascli in Oracle Cloud
Normally, you use the dbaascli utility to update the cloud tooling on Database Cloud Service database deployments hosting a single-instance database or Oracle Data Guard configuration. However, older deployments don’t support the two dbaascli subcommands you use: dbaascli dbpatchm –run -list_tools dbaascli dbpatchm –run -toolsinst Connect as the opc user to the compute node. Start […]
RESTful API in Oracle Cloud
A RESTful API is an application program interface (API) that uses HTTP requests to GET, PUT, POST and DELETE data. A RESTful API — also referred to as a RESTful web service — is based on representational state transfer (REST) technology, an architectural style and approach to communications often used in web services development. Oracle […]
Converting Normal Disk Groups to Flex Disk Groups in Oracle 18c
In this post, You can convert a conventional disk group ie created before Oracle ASM 18c to an Oracle ASM flex disk group without using the restrictive mount (MOUNTED RESTRICTED) option. Migrating (converting) to a flex disk group can be performed for a NORMAL or HIGH redundancy disk group with the CONVERT REDUNDANCY TO FLEX […]
New look of ASMCA in Oracle 18c
Oracle ASM Configuration Assistant (ASMCA) supports installing and configuring Oracle ASM instances, disk groups, volumes, and Oracle Automatic Storage Management Cluster File System (Oracle ACFS). In addition, you can use the ASMCA command-line interface as a non-GUI utility. In Oracle 18c database, ASMCA comes up with new GUI interface which looks cool and easy to […]
Upgrading Oracle Grid Infrastructure 11gR2 to 18c
Here I would be discussing how to upgrade Oracle 11gR2 (11.2.0.4) Grid Infrastructure to Oracle 18c (18.0.0.0) on the same server. This upgrade process was done on Linux 7 (x86_64). Before the GI upgrade backup the OCR manually. This could be used in downgrading the GI from 18.0.0.0 to 11.2.0.4 later one. If you want […]