How to Share / Add / Embed Youtube Video to Blogger Posts?

YouTube Videos are another way of making money through Adsense. If you have your own channels on the YouTube, you can embed those videos to the blog. Even you can embed/share the useful videos from other channels.

1. Find the video from YouTube to be shared and click on the link to play.

Google Animated Music Doodle on Valentine’s Day 2012

Google published a very cute music doodle on Valentine ’s Day 2012. It is with a beautiful animation movie. Doodle start with a play button. When you click on the play button, the animation starts. Boy goggling different items from Google which cannot win girls heart. Only true love can win the love. Watch the full video in following link.

Purpose of ADR_BASE_Listener & DIAG_ADR_ENABLED_listener : Oracle 11gR1 Listener ADR Parameter

Automatic Diagnostic Repository (ADR) is introduced in Oracle 11g. ADR is a common repository location for all logs and trace files etc. 

ADR More details

1. ADR_BASE_ListenerName: This parameter is to specify the ADR location for the database where listener generates the log and trace files to the directory. ADR location is specified in “diagnostic_dest” parameter of the database.  

Unique Index Creation Failed: ORA-12801: error signaled in parallel query server P018, instance

Error Description:

Oracle Unique Index creation failed with ORA-12801: error signaled in parallel query server P018.

CREATE UNIQUE INDEX

*

ERROR at line 1:

ORA-12801: error signaled in parallel query server P018,

Oracle 11g LMon RAC Background Process Functions

1. LMon (lock Monitor) is one of the mandatory background process in Oracle RAC instance.
2. It is also called as Global Enqueue Service Monitor
3. It manages the Global enqueues and resources.
4. LMON manages the instance and process failures. Which includes the

Terminate/Kill/Stop Data Pump EXPDP IMPDP Executing Jobs

Terminate Data Pump (EXPDP IMPDP) Executing Jobs exited without KILL_JOB command?

Here is the Scenario.

I have initiated an expdp job and exited without killing the job. In this scenario I cannot reinitiate the expdp with the same name again as it is in the executing status. You can use “drop table <jobname>;” to terminate such kind of jobs. See the below example.

$ expdp dumpfile=exp_table.dmp logfile=exp_table.log

Oracle SQL Script to Compile All Package, Body in a Schema

This script will compile all the Package and package body in the schema. If you wanted to compile all the packages in the all schema, change the user_objects to dba_objects and you have to connect as a DBA privileged user.

1. Create a sql file and copy below script.
2. Connect to sqlplus with the username where you wanted to compile all packages.