pvmehta.com

Adding a new disk and mount it automatically. on VMWARE LINUX

30-Jan-2010 Admin No Comments

Adding a new disk and mount it automatically. Step-1 Add virtual disk to vmware server. ========================================= Step-2 Bounce the box ========================================= Step-3 Make sure the new hard drive should be identified by your linux box. ========================================= As following example, you can see I added /dev/sdc worth of 20GB. [root@oem ~]# fdisk -l Disk /dev/sda: 10.7…

Linux/Unix, shell

sqlnet.ora paramters

30-Jan-2010 Admin No Comments

-Default order of NAMES. DIRECTORY_PATH is TNSNAMES, OID, HOSTNAME in sqlnet.ora. -EZCONNECT is available after 10g onwards. -Make sure Names.default_domain is set property to avoid any kind of client connectivity issues.

Oracle, SQL scripts

TNSNAMES entries details

30-Jan-2010 Admin No Comments

Option: Try each address, in order, until one succeeds ( Failover only). By default failover=true if you have more than one entry in address list. ============================================================================= MEHTA = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = NYBOX)(PORT = 1555)) (ADDRESS = (PROTOCOL = TCP)(HOST = FLBOX)(PORT = 1600)) ) (CONNECT_DATA = (SERVICE_NAME =…

Read More “TNSNAMES entries details” »

Oracle, SQL scripts

Oracle 11g Training on 29JAN1010

29-Jan-2010 Admin No Comments

-SERVICE_NAMES = INSTANCE_NAME + DB_DOMAIN -GLOBAL DATABASE NAME should be same as SERVICE_NAMES -If system ts is LMT then temporary tablespace is required. -if system ts is lmt then no dmt can be created in db. -When system ts is LMT then undo tbs is also must. -1 tbs can have max 1022 dbfs. -1…

Oracle, SQL scripts

Very clear article about oracle dataguard

29-Jan-2010 Admin No Comments

http://www.dbazine.com/oracle/or-articles/liu4

Oracle, rman-dataguard

oracle fast start failover best practice

27-Jan-2010 Admin No Comments

http://www.oracle.com/technology/deploy/availability/pdf/MAA_WP_10gR2_FastStartFailoverBestPractices.pdf

Oracle, rman-dataguard

Difference between SYNC and AFFIRM

27-Jan-2010 Admin No Comments

LGWR SYNC AFFIRM in Oracle Data Guard is used for zero data loss. How does one ensure zero data loss? Well, the redo block generated at the primary has to reach the standby across the network (that’s where the SYNC part comes in – i.e. it is a synchronous network call), and then the block…

Oracle, rman-dataguard

useful dg links

27-Jan-2010 Admin No Comments

http://www.oracle.com/technology/obe/11gr2_db_prod/ha/dataguard/dg_broker/dg_broker.htm http://www.oracle.com/technology/obe/11gr2_db_prod/ha/dataguard/activedg/activedg.htm http://www.oracle.com/technology/obe/11gr2_db_prod/ha/dataguard/physstby/physstdby.htm

Oracle, rman-dataguard

Does DBMS_JOB recompute the NEXT_DATE interval after or before

24-Jan-2010 Admin No Comments

goal: Does DBMS_JOB recompute the NEXT_DATE interval after or before executing the procedure or job? fact: PL/SQL fix: The NEXT_DATE is computed AFTER the job gets executed successfully. The INTERVAL date function is evaluated immediately before a job is executed. If the job completes successfully, the date calculated from INTERVAL becomes the new NEXT_DATE. If…

Oracle, SQL scripts

Committing distributed transaction using commit force

22-Jan-2010 Admin No Comments

Committing Using Only the Transaction ID The following SQL statement commits an in-doubt transaction: COMMIT FORCE ‘transaction_id’; The variable transaction_id is the identifier of the transaction as specified in either the LOCAL_TRAN_ID or GLOBAL_TRAN_ID columns of the DBA_2PC_PENDING data dictionary view. For example, assume that you query DBA_2PC_PENDING and determine that LOCAL_TRAN_ID for a distributed…

Oracle, SQL scripts