To convert RAC to Non-RAC DB on normal file system we need to first convert it into ASM storage Converting RAC db to Non-RAC db In this article we will see conversion database from ASM to Normal File System : Step 1 : Check details of ASM database and create pfile from spfile : [oracle@rac1 […]
Monthly Archives: March 2018
Converting RAC db to Non-RAC db
In previous Articles we have seen conversion from Single Instance DB to RAC db using various methods.In this Article we will see conversion of RAC to Normal DB[Single Instance]. Prerequisites : RAC Instance Node RAC Node Name RAC DB Name RAC Instance Name Single Instance DB name Node 1 RAC1 test db1 test Node 2 […]
Basic on Administrator Managed and Policy Managed Database in Oracle Rac
There are two methods to manage your cluster database. Administrator Managed database Policy Managed Database Administrator Managed Database : In Administrator Managed database , a DBA manages each instance of the database by defining specific instances to run on specific nodes in the cluster.It is traditional way of cluster management. Policy Managed Database : It’s […]
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 […]
Oracle Database 18c Technical Architecture
This interactive diagram shows the Oracle Database 18c technical architecture. An Oracle Database consists of at least one database instance and one database. The database instance handles memory and processes. The database consists of physical files called data files, and can be a non-container database or a multitenant container database. An Oracle Database also uses […]
Apply Patch without shutting the Database
Most of the time, we can shut down the database and listener for patching the database home. But there is a method to apply the patch without shutting down the database and listener. Checking the database and listener running [oracle@oem 12834800]$ ps -ef|grep pmon oracle 16816 1 0 03:11 ? 00:00:00 ora_pmon_PROD4 oracle 18385 1 […]
Installing Oracle 18c Data Guard on Cloud
This article shows how to create Oracle 18c Data Guard in Oracle Database Cloud Service database deployment with simple steps. Create a New Instance of Oracle Data Guard Cloud Service Log in to your Oracle Cloud services account, go to the Oracle Database Cloud Service page, and create a new service:- For Instance Name enter DG18. – […]
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 […]