shutdown linux
shutdown -h now
Processes parameter and its dependencies on OS kernel parameters
At this time in 800P, we are having following parameter set. NAME TYPE VALUE ———————————— ———– —————————— processes integer 3500 sessions integer 9000 The main parameter is “processes” parameter as it depends upon the # of semaphores in the system. This parameter depends upon followng kernel values. nproc – Maximum number of processes that can…
Read More “Processes parameter and its dependencies on OS kernel parameters” »
Nice Article about semaphores and init.ora Processes parameter relations
metalink note: 15566.1 PURPOSE Shared memory and semaphores are two important resources for an Oracle instance on Unix. An instance cannot start if it is unable to allocate what it needs. This paper primarily discusses the process Oracle goes through to allocate shared memory and semaphores at instance startup. Other important points unrelated to startup…
Read More “Nice Article about semaphores and init.ora Processes parameter relations” »
default permission on ~/.ssh/authorized_keys2 or authorized_keys
The permission on this file must be 600. else even after changing the authorized keys you will be asked for password authentications.
Temporary Tablespace Information and restriction.
Temporary Tablespace (1) The DEFAULT TEMPORARY TABLESPACE must be of TEMPORARY type. (2) The DEFAULT TEMPORARY TABLESPACE cannot be converted to PERMANENT once it has been defined as the DEFAULT TEMPORARY TABLESPACE. (3) Before dropping the DEFAULT TEMPORARY TABLESPACE, create another one. (4) The DEFAULT TEMPORARY TABLESPACE cannot be taken OFFLINE: (5) The temporary tablespace…
Read More “Temporary Tablespace Information and restriction.” »
Oracle Metalink useful notes
Note:144152.1 Understanding 9i Real Application Clusters Cache Fusion Recovery
When error comes for temporary tablespace with version <= 9i
Step-1 Run @temp_use.sql as following. Following is the code for temp_use.sql SELECT b.TABLESPACE, b.segfile#, b.segblk#, b.blocks, a.SID, a.serial#, a.username, a.osuser, a.status, c.sql_text FROM v$session a, v$sort_usage b, v$sqlarea c WHERE a.saddr = b.session_addr AND a.SQL_HASH_VALUE = c.HASH_VALUE and a.sid not in (select distinct sid from v$mystat) ORDER BY b.TABLESPACE, b.segfile#, b.segblk#, b.blocks / set pagesize…
Read More “When error comes for temporary tablespace with version <= 9i” »
Establishing trusted relationship between dbmonitor( central monitoring) and monitoring targets.
[1] We have logserver as existing central monitoring server. [2] need to establish other monitoring server same as logserver. [3] so login as oracle copy ~/.ssh from logserver1 to dbmonitor. on dbmonitor: cd .ssh cat id_dsa.pub id_rsa.pub > both_keys then do the following for target servers. pls note that where ssh2 is installed the file…
Finding last recovered file on DR and remove all chanracters before any “/”
sunflower1/800P>ssh sunlight1 “grep “Media ” /EMCdb19/oracle/800L/bdump/alert_800L.log| grep -v grep | grep “arch” | tail -1 ” Media Recovery Log /EMCdb16/archlog/800P/arch0000296866.arc sunflower1/800P> sunflower1/800P>ssh sunlight1 “grep “Media ” /EMCdb19/oracle/800L/bdump/alert_800L.log| grep -v grep | grep “arch” | tail -1 | sed -e s#^.*/##” arch0000296866.arc sunflower1/800P>
replace alphabets using sed
Following will replace anything except numeric digits. sunflower1/800P>echo /db15/archlogbak/800P/arch0000295711.arc | awk -F”/” ‘{print $NF}’ | sed -e ‘s|[^0-9]||g’ 0000295711