nagadbadmin

Sunday, May 24, 2026

ANJANI APPS DBA: How to apply Oracle 19C RU - January 2026 step by ...: Hi All, In this post i am going to share about Oracle 19C JAN-2026 RU patch apply step by step lab . Firstly we need to login support.oracl...

Oracle DBA by Example. Code samples, Scripts, Reference.: Oracle Encryption - Encrypt data on storage with w...: --Specify location for wallet root ALTER SYSTEM SET WALLET_ROOT='$ORACLE_BASE/admin/igt/wallet' SCOPE=SPFILE; Restart Oracle is req...

Oracle DBA by Example. Code samples, Scripts, Reference.: Oracle Encryption - encrypt data: Permissions on Oracle package DBMS_CRYPTO ======================================== GRANT EXECUTE ON DBMS_CRYPTO TO TEST_USER; =============...

Bryan's Oracle Blog: Automating cloning of your Exadata Database Servic...: One of the questions I often get from customers is "How do I automate the cloning of a production database backup to a non-prod c...

Labels: EXACS/EXACC

Bryan's Oracle Blog: Autonomous Recovery Service Live Lab available: One of the latest additions to Oracle's Live Labs is the Autonomous Recovery Service. This lab allow you to understand how to utilize t...

Database-Box: Logging Options in Oracle for Data Guard: Logging Options in Oracle for Data Guard When preparing a primary Oracle Database for use with Oracle Data Guard , enabling the correct...

Bryan's Oracle Blog: MCP Server for Autonomous Recovery Service: Wouldn't it be nice if I could just use AI and ask my tenancy to tell me about my Autonomous Recovery Service database backups ? I want...

Minimalistic Oracle: A SQL-centric and a session-centric way to query V... : Version 1: SQL-Centric This version starts from V$SQL and...

Automatic failback of an Orace RAC database Service - 19c new feature

When a rac database instance fails, a service which is running on this failed instance (configured as preferred) will fail over to the avail...
Minimalistic Oracle: How to detach an ORACLE_HOME to an existing inventory

Minimalistic Oracle: How to detach an ORACLE_HOME to an existing inventory : I want to detach an existing oracle_home from my inventory. No...
How to see EXADATA machine information on OCI GEN-2 Cloud (EXACC / EXACS)?

To see EXADATA machine information of OCI cloud, follow below method. 1) Log in to EXACS/EXACC compute (db server) node with ROOT user. 2)...