metalink all dynamic view reference notes.
V$ View Definitions Library Doc ID: Note:220021.1
how to find VIP from ifconfig
As u see in front of VIP, “:1” will be there. sunlight1/800P>ifconfig -a lo0: flags=2001000849 mtu 8232 index 1 inet 127.0.0.1 netmask ff000000 hme0: flags=1000843 mtu 1500 index 2 inet 192.168.9.36 netmask ffffff00 broadcast 192.168.9.255 hme0:1: flags=1000843 mtu 1500 index 2 inet 192.168.9.10 netmask ffffff00 broadcast 192.168.9.255 hme1: flags=1000843 mtu 1500 index 3 inet 192.168.9.38…
ORA-00064: object is too large to allocate on this O/S during startup
(1) When you attempt to set the ‘Processes’ parameter to high value (for example> 14000), the instance startup fails with ORA-00064: object is too large to allocate on this O/S ORA-00064: object is too large to allocate on this O / S. Solution: Change PROCESSES parameter. or The workaround to bypass this limit is to…
Read More “ORA-00064: object is too large to allocate on this O/S during startup” »
standard Monitoring – 1
ALL DB = Primary + DR databases. -> Implement checkfile concept so script will not page for planned maitenance. (1) Connect and update all Primary db for hang check. (2) Check for pmon for all db. (3) Check Alert log for ORA error for Primary database. (4) Purge Alert log of Primary and keep backup…
Zip and unzip with tar
***** ZIP IT ************ eaappprod22->UOCUAT@(/export/home/oracle/paresh)ls -rlt total 0 -rw-r–r– 1 oracle dba 0 Jun 2 11:08 2 -rw-r–r– 1 oracle dba 0 Jun 2 11:08 3 -rw-r–r– 1 oracle dba 0 Jun 2 11:08 4 -rw-r–r– 1 oracle dba 0 Jun 2 11:08 5 -rw-r–r– 1 oracle dba 0 Jun 2 11:09 1 eaappprod22->UOCUAT@(/export/home/oracle/paresh)tar -cvf…
RAC 11g with vmware
http://www.oracle-base.com/articles/11g/OracleDB11gR1RACInstallationOnOEL5UsingVMware.php
oracle 11g RAC on vmware
http://startoracle.com/2007/09/30/so-you-want-to-play-with-oracle-11gs-rac-heres-how/
OEM-troubleshooting on 20-MAY-08
FROM TUNINGDB21 (Target) =============== tuningdb21*-/db1/home/oracle/paresh ==>ping 10.180.1.144 10.180.1.144 is alive tuningdb21*-/db1/home/oracle/paresh ==>ping oem2k.1800flowers.int ping: unknown host oem2k.1800flowers.int tuningdb21*-/db1/home/oracle/paresh ==>nslookup 10.180.1.144 *** Can’t find server name for address 127.0.0.1: Unspecified error *** Default servers are not available tuningdb21*-/db1/home/oracle/paresh ==>nslookup oem2k.1800flowers.int *** Can’t find server name for address 127.0.0.1: Unspecified error *** Default servers are not available…
normal maintenance for exp-imp and renaming table
exp userid=vivek file=ats_florist_zips_20MAY08.dmp log=ats_florist_zips_20MAY08.log grants=N indexes=N tables=ats.ats_florist_zips triggers=N statistics=None feedback=5000 imp userid=vivek file=ats_florist_zips_20MAY08.dmp log=imp_ats_florist_zips_20MAY08.log buffer=20971520 grants=N indexes=N fromuser=ats touser=5049 commit=Y constraints=N feedback=5000 statistics=None alter table “5049”.ATS_FLORIST_ZIPS rename to ats_florist_zips_05_20_2008;
Guide to Linux System Command Mastery
An introduction to system commands for newcomers to Linux In “Guide to Linux File Command Mastery,” we covered the basic information needed to take advantage of the most essential and commonly used Linux file commands. In this article, I’ll do the same with Linux system commands. As we learned in the previous article, everything is…