Running SQL scripts against several Pluggable Databases with SQL*Plus is tedious, because the DBA have to login into every Pluggable Database and run the required script or SQL Statement . In this article, I’ll show you how to run SQL Statements easily across all Pluggable Databases. In a container database (CDB) Environment, the Oracle catcon.pl […]
Catégorie : Procedures
listener.log too big
My listener.log file is growing and now it is very big; I have difficulties to open it. What can I do when the listener.log is growing? Indeed, if you delete the LISTENER.LOG, the file will be recreated only after stopping and starting the listener … I want to archive it without boucing the listener (online […]
Change primary key value in Oracle
I want to modify the value of a primary key (PK) but there are foreign keys (FK) with data. You will need to: – Disable the foreign key constraints – Change the values of the foreign keys – Change the primary key values – Re-enable the foreign key constraints. The difficulty here is to quickly […]
Resize online redo log in a dataguard configuration
One of my clients in Montreal wants to resize the online redologs in a dataguard configuration. The technique used by the Oracle DBA comprises: – On the primary database: drop and re-create the online redologs and the standby online redologs – On the standby database: after stopping the replication, drop and re-create the online redologs […]
remove_agent_gridcontrol
— ################################################ — # Creator: Grégory RECHIGNAC (DBA Oracle) — # Created: 2012/03/01 — # Name: remove_agent_gridcontrol.sql — ################################################ — # — # Compatible: Oracle Grid Control 10g 11g 12c — # — ################################################ — # — # Remove agent and it s target from Grid Control — # — ################################################ SELECT ‘exec mgmt_admin.cleanup_agent( »’ || […]