Author: Admin

Deleting first line and lastline of a file using sed

04-Feb-2010 Admin No Comments

Delete last line of a file. =========================== sed ‘$d’ < input_file > output_file Delete First line of a file. ============================ sed ‘1d’ input_file > output_file

Linux/Unix, shell

Pending Transaction Neighbors Script

03-Feb-2010 Admin No Comments

COL LOCAL_TRAN_ID FORMAT A13 COL IN_OUT FORMAT A6 COL DATABASE FORMAT A25 COL DBUSER_OWNER FORMAT A15 COL INTERFACE FORMAT A3 SELECT LOCAL_TRAN_ID, IN_OUT, DATABASE, DBUSER_OWNER, INTERFACE FROM DBA_2PC_NEIGHBORS / SQL> CONNECT SYS@hq.acme.com AS SYSDBA SQL> @neighbors_script LOCAL_TRAN_ID IN_OUT DATABASE DBUSER_OWNER INT ————- —— ————————- ————— — 1.15.870 out SALES.ACME.COM SYS C

Oracle, SQL scripts

Pending Distributed Transations

03-Feb-2010 Admin No Comments

COL LOCAL_TRAN_ID FORMAT A13 COL GLOBAL_TRAN_ID FORMAT A30 COL STATE FORMAT A8 COL MIXED FORMAT A3 COL HOST FORMAT A10 COL COMMIT# FORMAT A10 SELECT LOCAL_TRAN_ID, GLOBAL_TRAN_ID, STATE, MIXED, HOST, COMMIT# FROM DBA_2PC_PENDING /

Oracle, SQL scripts

Good Oracle Architecture In Short and point to point

02-Feb-2010 Admin No Comments

http://www.toadworld.com/KNOWLEDGE/KnowledgeXpertforOracle/tabid/648/TopicID/2471975d4f31c8aa/Default.aspx

Oracle, SQL scripts

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