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 […]
Category: Procedures
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(”’ || […]
External table Use
How the DBA Oracle can use external table. Here is a small example — ################################################ — # Creator: Vincent Fenoll (DBA Oracle) — # Created: 2011/11/08 — # Name: External table Use — ################################################ — # — # Compatible: Oracle 10g 11g — # — ################################################ — # — # Insert data into a table […]