Tuesday, March 24, 2015

How to use the nmap tool for Oracle networking troubleshooting

›
The Network exploration tool and security / port skanner (nmap) came in handy as I was checking the prerequisites for a Golden Gate installa...
Thursday, March 12, 2015

How to use DECODE to create a script for compilation of both packages and package bodies

›
connect scott/tiger alter session set nls_language='AMERICAN'; set heading off set trimspool on set feedback off set verify off set ...
Monday, February 23, 2015

How to solve ORA-02180 when specifying COMPRESSION type

›
You get ORA-02180: invalid option for CREATE TABLESPACE when executing a create tablespace statement like this one: CREATE TABLESPACE test...
Tuesday, February 17, 2015

How cloning from backup became a little more secure in Oracle 11g

›
From version 11, Oracle supplied another method to use during cloning, namely "Backup-based duplication without a target connection...

The emcli utility

›
If you're working in a large Enterprise and are using Cloud Control, you will have access to a neat utility called emcli. emcli is sho...
Friday, January 23, 2015

What is the difference between a BEQUEATH connection and an IPC connection?

›
A bequeath connection runs on your local host bypasses the listener the protocol creates the server process for you directly An IPC (I...
1 comment:
Thursday, January 22, 2015

A complete script for gathering system, data dictionary and fixed objects stats

›
alter session set nls_language='AMERICAN'; set timing on set serveroutput on set lines 200 col pname format a20 BEGIN DBMS_STATS.GA...