This post is about Unified Audit Trail In Oracle 12c . Few starting lines give the overview of ” Unified Audit Trail ” . With Oracle 12c, unified auditing has been introduced. It consolidates all audit trails into a single audit trail table. It will capture audit records from below sources. SYS audit records ( which was […]
Monthly Archives: November 2017
Oracle Database Gateway for PostgreSQL
An organization have lot of choices to choose from the RDBMS world. Oracle Database, Microsoft SQL Server, IBM DB2,PostgreSQL, MySQL are few of them. Most of the organizations out there do have a mix of all these which are used to store their data and in course of time it is inevitable that they would […]
ASM (Sector Size Validations)
From the technical background, we have an idea of Validations. I talk about normal life we notice that we have lots of Validations in our life. Let’s have look at today about ASM (Sector Size Validations). First few lines will explain the technical definition of Validations. Validation is the name given to the process whereby the information entered […]
ASM -(Sector Disk Drives)
This post is about ASM’s attribute deep knowledge. Before going ahead we must have an idea about the topic. Let’s some line must explain about ASM -(Sector Disk Drives). The database and Oracle’s Automatic Storage Management (ASM) volume manager explicitly understood 4k devices. In this and subsequent versions of ASM, disk groups created on native mode […]
ASM Disk Group Attributes
We are the part of RDBMS world. As a student when we entered in the world of RDBMS we learned about the attributes of the entity. I hope you have the idea what we are going to do in this post. As the heading of the post explains. Today we are going to have look at ASM Disk […]
raccli update databasepassword
The update databasepassword subcommand of the raccli utility updates the password in the keystore (wallet) and optionally updates the password of the SYS and SYSTEM users. raccli update databasepassword -password password [-saveonly] If you are executing this command following an update to the cloud tooling from release 17.2.1 or earlier, you must execute the command with […]
Oracle Database Gateway for Microsoft SQL Server
The gateway system identifier (SID) is an alphanumeric character string that identifies a gateway instance. You need one gateway instance, and therefore one gateway SID, for each SQL Server database you are accessing. The SID is used as part of the file name for the initialization parameter file. The default SID is dg4msql. You can […]
Oracle 18c: RMAN New Features
This article was written by Skant Gupta and Joel Perez in Oracle OTN. Full Index of Oracle Cloud Articles: Sir.CloudDBaaSjoelperez Before starting to read, if you want to access others Oracle RMAN Cloud Articles, you can go here: #6 Oracle Cloud (DBaaS): Migrating Databases to Oracle Cloud Using RMAN Backup #11 Oracle Cloud (DBaaS): Migration “On-prem” database to Cloud Using […]
Oracle 18c: Data Warehousing New Features
This article was written by Skant Gupta and Joel Perez in Oracle OTN. Full Index of Oracle Cloud Articles: Sir.CloudDBaaSjoelperez If you want to be updated with all our articles send us the Invitation or Follow us: Joel Perez’s LinkedIn: www.linkedin.com/in/SirDBaaSJoelPerez Skant Gupta’s LinkedIn: www.linkedin.com/in/skantali/ or Join our LinkedIn group: Oracle Cloud DBaaS Data Warehousing will be the focus of […]
Shutdown mode in Oracle ASM Instance
Being an Oracle DBA we have learned about the db instance in Oracle database. As we know db instance has shutdown mode. In this post, we are going to have look at Oracle ASM Instance. The ASM shutdown process is initiated when you run the SHUTDOWN command in SQL*Plus. While running this command we must ensure […]