Islamic Invocations with Urdu Translation

In loving memory of my Son Zaryaab, who left me on 27th July, 2011 at 7:30 evening!

I have compiled 3 booklets for Islamic Invocations with Urdu Translation:

Quranic Invocations
Masnoon Invocations
Morning & Evening Invocation

The main purpose of these booklets is collect the invocations in Quran and authentic books of hadeeth into a single file which can benefit all Muslims and wish that we all can recite these invocation in our daily prayers.

I dedicate these booklet to my father Late Abdul Latif who taught me how to read and write and my son Zaryaab, who left me at the age of 9 years on 27 July, 2011 and went back to our creator Allah (SWT). Zaryaab losing him I learned that everything in this world is mortal and how to be a better Muslim.

I request every reader to please read Surat Al-Fatihah (1 Time) and Surat Al-Ikhlas (3 Times )for my Father Abdul Latif, Son Zaryaab and all the Muslims those who had passed away and pray that Allah (SWT) may ease their and our last journey.

May Allah Almighty accept the effort

Ameen!
بِسْمِ اللَّهِ الرَّحْمَنِ الرَّحِيمِ
الْحَمْدُ لِلَّهِ رَبِّ الْعَالَمِينَ۞الرَّحْمَنِ الرَّحِيمِ۞مَالِكِ يَوْمِ الدِّينِ۞اِيَّاكَ نَعْبُدُ وَاِيَّاكَ نَسْتَعِينُ۞اهْدِنَا الصِّرَاطَ الْمُسْتَقِيمَ۞صِرَاطَ الَّذِينَ أَنْعَمْتَ عَلَيْهِمْ غَيْرِ الْمَغْضُوبِ عَلَيْهِمْ وَلا الضَّالِّينَ۞
آمین۔
بِسْمِ اللَّهِ الرَّحْمَنِ الرَّحِيمِ
قُلْ هُوَ اللَّهُ أَحَدٌ۞ اللَّهُ الصَّمَدُ ۞ لَمْ يَلِدْ وَلَمْ يُولَدْ ۞ وَلَمْ يَكُن لَّهُ كُفُوًا أَحَدٌ ۞
جزاکم اللہ
You can download the files from following:

http://www.4shared.com/document/CpTHeyW1/Quranic_Invocations.html

http://www.4shared.com/document/ZD_PCyY7/Masnoon_Invocations.html

http://www.4shared.com/document/bDJ1NzLo/Morning_Evening_Invocation.html

http://www.4shared.com/document/1qCo3NRY/Invocations.html (Complete Bundle)

You can view and read the online versions from following:

http://www.scribd.com/doc/63726068/Invocations (Complete Bundle)

Quranic invocations http://slidesha.re/p1tN4t
Masnoon invocations http://slidesha.re/p0C8X4
Morning evening invocation http://slidesha.re/otWPSs
Islamic Invocations http://slidesha.re/qnws91 (Complete Bundle)

New Features of Firefox 5

Mozilla released Firefox 5 on Tuesday by successively following accelerated update schedule. As expected, the updates to the new version is very limited with no much changes like what users saw from Firefox 3 and Firefox 4.

Firefox 5 released on Tuesday, comes with a redesigned user interface with some of new features. Features like “Tell websites I do not want to be tracked” which is accessible from the “Privacy” menu instead of concealed in the “Advanced” options, App Tabs,  which allow you to always keep your favorite web apps like Facebook, Gmail and Twitter open and just a click away by pining those into browser which can’t be closed accidentally and open automatically when you start Firefox and Tab Groups (also known as Panorama) are an easy way to organize a lot of tabs. With Tab Groups you can visually group related tabs, switch between groups and quickly search through all of your tabs.

The update also has a slide of improved support for CSS animations. Now they will also releasing a software developers kit (SDK) for Windows, Mac and Linux and a beta Add-on Builder for those interested in making add-ons for the browser which I will be trying for sure. With all what they have done they are still falling back in speed and performance when compared to Chrome. By the way IE 9 is also not bad when compared with other 2.

The only I ran into was the compatibility of add-ons with this version and other than that everything was smooth and I hope those add-ons will be updated soon so they are supported in Firefox 5.

So did you tried Firefox 5 yet? Let me know what your experience with it was […]

Difference between utlchain.sql and utlchn1.sql

A very small thought

The difference between utlchain.sql and utlchn1.sql is the column head_rowid data type:

:::::::::::::: utlchain.sql ::::::::::::::
create table CHAINED_ROWS (
owner_name varchar2(30),
table_name varchar2(30),
cluster_name varchar2(30),
partition_name varchar2(30),
subpartition_name varchar2(30),
head_rowid rowid,
analyze_timestamp date );

and

:::::::::::::: utlchn1.sql ::::::::::::::
create table CHAINED_ROWS (
owner_name varchar2(30),
table_name varchar2(30),
cluster_name varchar2(30),
partition_name varchar2(30),
subpartition_name varchar2(30),
head_rowid urowid,
analyze_timestamp date );

ROWID and UROWID Datatypes

Oracle uses a ROWID datatype to store the address (rowid) of every row in the database.

Physical rowids store the addresses of rows in ordinary tables (excluding index-organized tables), clustered tables, table partitions and subpartitions and index partitions and subpartitions.

Logical rowids store the addresses of rows in index-organized tables.
A single datatype called the universal rowid, or UROWID, supports both logical and physical rowids, as well as rowids of foreign tables such as non-Oracle tables accessed through a gateway.

ROWID:
Physical rowids store the addresses of rows in ordinary tables (excluding index-organized tables), clustered tables, table partitions and subpartitions, indexes, and index partitions and subpartitions.

UROWID
U as Universal, supports both logical and physical rowids, as well as rowids of foreign tables such as non-Oracle tables accessed through a gateway. UROWIDs can save both “physical” as well as “logical” ROW IDs.

So if you have IOT in your database use utlchn1.sql to create the CHAINED_ROWS or else you will get ORA-01496: specified chain row table form incorrect

Hope this helps…

 

Using Oracle AMM (Automatic Memeory Managment) 11g

The basic memory structures associated with Oracle Database include:

System Global Area (SGA)

The SGA is a group of shared memory structures, known as SGA components, that contain data and control information for one Oracle Database instance. The SGA is shared by all server and background processes.

Program Global Area (PGA)

A PGA is a memory region that contains data and control information for a server process. It is nonshared memory created by Oracle Database when a server process is started. Access to the PGA is exclusive to the server process. There is one PGA for each server process. Background processes also allocate their own PGAs. The total PGA memory allocated for all background and server processes attached to an Oracle Database instance is referred to as the total instance PGA memory, and the collection of all individual PGAs is referred to as the total instance PGA, or just instance PGA.

It contains global variables and data structures and control information for a server process. example of such information is the runtime area of a cursor. Each time a cursor is executed, a new runtime area is created for that cursor in the PGA memory region of the server process executing that cursor.

The performance of complex long running queries, typical in a DSS environment, depend to a large extent on the memory available in the Program Global Area (PGA) which is also called work area.

Below figure illustrates the relationships among these memory structures.

Memory management has evolved with each database release

Oracle 9i

Beginning with Oracle9i, the dynamic SGA infrastructure allowed for the sizing of the Buffer Cache, Shared Pool and the Large Pool without having to shutdown the database. Key features being
Dynamic Memory resizing
DB_CACHE_SIZE instead of DB_BLOCK_BUFFERS
DB_nK_CACHE_SIZE for multiple block sizes
PGA_AGGREGATE_TARGET […]

Enable Tracing Oracle Listener

Just in case if you need to generate trace of Listener Do the following:
vi /u01/oracle/11.2/network/admin/listener.ora
And add the Following:
TRACE_LEVEL_listener=support
TRACE_TIMESTAMP_listener=true
valid values for trace level can be from following depending upon the information required.
user or 4 for user trace information
admin or 10 for administration trace information
support or 16 for Oracle Support Services trace information
Bounce the Listener and check the location of trace files, this will also provide you the information about the parameter and log files.
$ lsnrctl stat
LSNRCTL for Linux: Version 11.2.0.1.0 – Production on 21-MAR-2011 10:24:44
Copyright (c) 1991, 2009, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
STATUS of the LISTENER
————————
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 11.2.0.1.0 – Production
Start Date                21-MAR-2011 09:44:43
Uptime                    0 days 0 hr. 40 min. 3 sec
Trace Level               support
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/oracle/11.2/network/admin/listener.ora
Listener Log File         /u01/oracle/diag/tnslsnr/11g/listener/alert/log.xml
Listener Trace File       /u01/oracle/diag/tnslsnr/11g/listener/trace/ora_6339_47673611031200.trc
Listening Endpoints Summary…
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=TOSH)(PORT=1521)))
Services Summary…
Service “TOSH” has 1 instance(s).
Instance “TOSH”, status READY, has 1 handler(s) for this service…
Service “TOSHXDB” has 1 instance(s).
Instance “TOSH”, status READY, has 1 handler(s) for this service…
The command completed successfully

Unlock Windows 7 Master Mode

The Windows Master Control Panel shortcut or Windows 7 Master Mode basically lets users access all of the operating system’s control panels from within a single folder like one huge control panel for all the OS settings.

This is very simple to unlock, all you have to do is create a folder in a directory of your choice and name it with the following string:
1337-Mode.{ED7BA470-8E54-465E-825C-99712043E01C}

Requirements for Installing Oracle 11gR2 RDBMS on RHEL Quick Review

This procedure is meant for those planning/trying to install Oracle Server 11.2.0.1.0 (or above) on Red Hat Server 5.2 (or greater) on the 64-bit (x86-64) platform. Since it is the expressed goal to keep Oracle Enterprise Linux functionally IDENTICAL to RHEL, this NOTE is also completely applicable to 64-bit (x86-64) OEL 5.2 or greater.

Requirements for Installing 64-bit Oracle 11gR2 RDBMS on RHEL or OEL 5.2 (or greater) 64-bit (x86_64)

I. Hardware:

1. Minimum Hardware Requirements
a.) At least 1.0 Gb (1024 MB) of physical RAM
b.) Swap disk space proportional to the system’s physical memory as follows:
RAM                                 Swap Space
1024 Mb to 2048 Mb        1.5 x RAM
2049 Mb to 16 Gb             1 x RAM
greater than 16 Gb              16 Gb
c.) 1024 Mb of disk space (and less than 2Tb of disk space) in the /tmp directory.
d.) approximately 4.4 Gb of local disk space for the database software.
e.) approximately 1.7 Gb of disk space for a preconfigured database that uses file system storage (optional)

II. Software:

1. As is specified in section 1.3.2 of the Oracle Database Installation Guide for 11gR2 on Linux (part number E10840-02), Oracle recommends that you install the Linux operating system with the default software packages (RPMs) and do not customize the RPMs during installation. For additional information on “default-RPMs”, please see Note 376183.1, “Defining a “default RPMs” installation of the RHEL OS”

2. Red Hat Enterprise Linux Server 5.2 (or greater), which is Kernel 2.6.18-92 or newer.

3. Required OS Components (per Release Notes, and Install Guide)
a.) The exact version number details of this list are based upon 64-bit (x86_64) RHEL Server 5.2 (aka “update 2″). When a higher “update” level is used, the RPM release numbers (such as 4.1.2-44) may be slightly different (such as 4.1.2-57 or 4.1.3-10). Since […]

Recover Objects from Oracle Recyclebin 11g/10g

Using my previous example
SQL> select object_name, original_name, type, can_undrop, can_purge, droptime
from recyclebin;

OBJECT_NAME    ORIGINAL_NAME    TYPE    UND    PUR    DROPTIME
————-    ————–    —-    —-    —    ———
BIN$GI74VOhyTp29f91G/w1VOg==$0    T1    TABLE    YES    YES    2011-02-08:04:23:01
BIN$LPbnFGYmST+6vTnvrdb9WQ==$0    T1    TABLE    YES    YES    2011-02-08:04:22:26

SQL> flashback table t1 to before drop;

Flashback complete.

SQL> select object_name, original_name, type, can_undrop, can_purge, droptime
from recyclebin;

OBJECT_NAME    ORIGINAL_NAME    TYPE    CAN_UNDROP    CAN_PURGE    DROPTIME
————–    ————-    ——    ———-    ———-    ———-
BIN$LPbnFGYmST+6vTnvrdb9WQ==$0    T1    TABLE    YES    YES    2011-02-08:04:22:26
Oracle will always restore the last version of the dropped table. But if we want to restore the earlier version of the table, we can simply refer to the correct version of the table by using the correct BIN$ name of the object
SQL> flashback table “BIN$LPbnFGYmST+6vTnvrdb9WQ==$0″ to before drop;

Flashback complete.
Oracle will leave objects in recyclebin until the tablespace runs out of space, or until users reach quota on the tablespace. At that point, Oracle purges the objects one at a time in chronological order, until there is enough space for the current operation.

Use Oracle Recyclebin in 10g/11g

Starting from 10g, The recyclebin is enabled by default and there are two recyclebin views a) USER_RECYCLEBIN and b)DBA_RECYCLEBIN. The synonym RECYCLEBIN points to session USER_RECYCLEBIN. To turn it on or off you need to change the RECYCLEBIN initialization parameter, at the session or system level.

When the recyclebin is enabled, any table that you drop is not actually gets dropped instead it is just renamed which beings with BIN$ and all its associated objects indexes, triggers, etc also gets a system generated name which also begins with BIN$.

A Simple example will be:
create table t1
(col1 varchar2(10),
col2 number);

insert into t1 values (‘a’,1);
insert into t1 values (‘b’,2);

Commit;

select * from t1;

COL1    COL2
—-    —-
a    1
b    2

DROP TABLE T1;

create table t1
(col1 varchar2(10),
col2 date);

insert into t1 values (‘a’,sysdate);
insert into t1 values (‘b’,sysdate);
insert into t1 values (‘c’,sysdate);

Commit;

select * from t1;

COL1    COL2
—–    ——————-
a    08/02/2011 04:17:55
b    08/02/2011 04:17:55
c    08/02/2011 04:17:55

DROP TABLE T1;

SQL> select object_name, original_name, operation from user_recyclebin;

OBJECT_NAME        ORIGINAL_NAME    OPERATION
———————  —————    ———-
BIN$GI74VOhyTp29f91G/w1VOg==$0    T1    DROP
BIN$LPbnFGYmST+6vTnvrdb9WQ==$0    T1    DROP

SQL> select object_name, original_name, type, can_undrop, can_purge, droptime
from recyclebin;

OBJECT_NAME    ORIGINAL_NAME    TYPE    UND    PUR    DROPTIME
————-    ————–    —-    —-    —    ———
BIN$GI74VOhyTp29f91G/w1VOg==$0    T1    TABLE    YES    YES    2011-02-08:04:23:01
BIN$LPbnFGYmST+6vTnvrdb9WQ==$0    T1    TABLE    YES    YES    2011-02-08:04:22:26
Table t1 was dropped, recreated then dropped again and both version were available in recyclebin. We can query these table just like any other tables
SQL> select * from “BIN$LPbnFGYmST+6vTnvrdb9WQ==$0″;

COL1    COL2
—-    —-
a    1
b    2

SQL> select * from “BIN$GI74VOhyTp29f91G/w1VOg==$0″;

COL1    COL2
—–    ——————-
a    08/02/2011 04:17:55
b    08/02/2011 04:17:55
c    08/02/2011 04:17:55
To drop table without having it in recyclebin use
SQL> DROP TABLE t1 purge;
Table dropped.

SQL> select * from user_recyclebin;
no rows selected
To purge table that was dropped earlier
SQL> PURGE TABLE “BIN$LPbnFGYmST+6vTnvrdb9WQ==$0″;
Table purged.
To remove or empty the user recyclebin use
SQL> PURGE recyclebin;
Recyclebin purged.
To remove or empty the system wide recyclebin use
SQL> PURGE DBA_RECYCLEBIN;
Recyclebin purged.

Turn Off Recyclebin in Oracle 10g/11g

One of the coolest feature in Oracle starting from 10g is recyclebin but sometimes it is annoying to scroll down and see a long list objects dropped, especially in development environment  where you drop more tables than you create.
SQL> SHOW PARAMETER RECYCLEBIN

NAME                                 TYPE        VALUE
———————————— ———– ——————————
recyclebin                           string      on
SQL>
To turn the feature ON or OFF here what you have to do:

In Oracle 10g database:
SQL> ALTER SYSTEM SET recyclebin = OFF;
System altered.

SQL> ALTER SYSTEM SET recyclebin = ON;
System altered.

SQL>
In Oracle 11g database:
SQL> ALTER SYSTEM SET recyclebin = OFF DEFERRED;
System altered.

SQL> ALTER SYSTEM SET recyclebin = ON DEFERRED;
System altered.
SQL>
NOTE:  DEFERRED is used because it takes effect in new sessions in the database.

You will face ORA-02096 in 11g if skipped DEFERRED i.e
SQL> ALTER SYSTEM SET recyclebin = OFF;
ALTER SYSTEM SET recyclebin = OFF
*
ERROR at line 1:
ORA-02096: specified initialization parameter is not modifiable with this option
To enable the recycle bin for a session:
SQL> ALTER SESSION SET recyclebin = ON;
To disable the recycle bin for a session:
SQL> ALTER SESSION SET recyclebin = OFF;