Thursday, May 31, 2012

Improve windows networking

›
Improve windows networking (especially if hosting webservers) First of all, I forgive you for having to use windows to host your w...
Tuesday, May 29, 2012

Login Oracle database using Windows User

›
Create Oracle External users in Windows 1. Create the Windows user: start --> settings --> control panel --> administrative to...
Friday, May 25, 2012

SQL Session Tracing

›
1. Start a sqlplus session to the database, and enable sql tracing with this command: alter session set events '10046 trace name co...

Listener Tracing

›
We will need to trace a connection on both CLIENT ,SERVER and Listener endpoints to see what is happening. Please collect traces for the ...
Tuesday, May 22, 2012

Database Link Creation Script

›
set pagesize 0 set linesize 30000 set long 500000 set longchunksize 500000 set trimspool on set feed off ------------Drop Database...

ORACLE 11G work with IPv6 addresses in addition to IPv4

›
ORACLE 11G work with IPv6 addresses in addition to IPv4 These are the simple steps that will make your DB 11g instance work with IPV6 env...

in 11g UTL_INADDR.GET_HOST_ADDRESS gives me IPv6, while I need IPv4

›
in 11g UTL_INADDR.GET_HOST_ADDRESS gives me IPv6, while I need IPv4 SELECT  UTL_INADDR.GET_HOST_ADDRESS  FROM DUAL; disable ipv6 on OS ...
Monday, May 21, 2012

ORA-12839: cannot modify an object in parallel after modifying it

›
ORA-12839: cannot modify an object in parallel after modifying it Affects: Product (Component)  Oracle Server (Rdbms) Range of versi...
Friday, May 18, 2012

Resolving common Oracle Wait Events

›
Resolving common Oracle Wait Events Wait Event Possible Causes Actions Remarks db file sequential reads Use of an unsel...