Oracle Archives - Page 15 of 30

Oracle-maintained users password change

From oracle 12c onwards the default user’s account passwords have to change from cdb container. container class is optional. sys user password change ======================= CDB level using container class with…

asrblogger April 3, 2023No Comments

Oracle

Lockdown Profile:

From 12c onwards we have new feature called lockdown profile to control the PDB level activities. It can be created in CDB container. SQL> show con_name CON_NAME ------------------------------ CDB$ROOT SQL>…

asrblogger April 3, 2023No Comments

Oracle

Common Roles Vs Local Roles

Privilege Management: Privilege management has been classified into 2 sub divisions. They are: 1) Grants 2) Roles Roles: Collection of privileges called role. In 12c we have 2 different types…

asrblogger April 3, 2023No Comments

Oracle

Common Grant Vs Local Grant

Privilege Management: Privilege management has been classified into 2 sub divisions. They are: 1) Grants 2) Roles Grants: oracle12c have two variant of grants. They are: 1) Common grants 2)…

asrblogger April 3, 2023No Comments

Interview Questions Oracle

Redolog Buffer Cache : SGA Component of Oracle

The redo log buffer is a circular buffer in the SGA that stores redo entries describing changes made to the database.A redo record is a data structure that contains the information necessary to reconstruct,…

asrblogger March 31, 2023No Comments

Interview Questions Oracle

Shared /Large/Java/Result Pool: SGA Component of Oracle

The shared pool caches various types of program data.For example, the shared pool stores parsed SQL, PL/SQL code, system parameters, and data dictionary information. The shared pool is involved in almost every operation that…

asrblogger March 29, 2023No Comments

Linux Oracle Scripts

Crontab : RMAN Backup

Automate RMAN Backup using Shell Script In a real environment, you will not manually trigger all the Oracle database backups. You need an automated mechanism to trigger RMAN backups. Create…

asrblogger March 26, 2023No Comments

DataGuard Oracle

Recovery Point Objective(RPO) and Recovery Time Objective (RTO)

A) Recovery Point Objective(RPO) A recovery point objective (RPO) is the maximum length of time permitted that data can be restored from, which may or may not mean data loss.…

asrblogger March 21, 2023No Comments

Oracle

How to Change SQL*Plus Prompt to Reflect Username & Instance Name ??

1. Verify that client networking connections are functional. Clients must be able to login to sql*plus with username/password/host string (where host string is the alias created for the specific sid).…

asrblogger March 14, 2023No Comments

ASM Oracle

Background Processes in Oracle ASM

Once the ASM instance is started, all the basic background processes, as well as some that are specific to the operation of ASM, are started. On Linux, the ASM processes…