Category: shell

find the runnung process’s environment

Goal After a process has been started, in order to find out the environment that was used to start it, the following methods can be used, depending on the OS platform: Solution 1. Determine the pid of the process at OS level, eg for the smon process: ps -ef | grep smon 2. Get the…

Read More “Which environment is used by currently running process ( Very good)” »

Following command will be used for Tarring/copying local files and untarring/extracting at target folder. $ tar cf – * | ( cd /target; tar xfp -)

Copy on Select The Copy on select feature allows you to speed up the process of copying text from the terminal screen to the Clipboard. If this feature is enabled, text is copied to the Clipboard as soon as it is selected. To enable/disable the Copy on select feature: 1. Select the Terminal category in…

Read More “secure crt settings” »

scp -p -o ‘protocol 2’ SOURCE_FILE TARGET_HOST:TARGET_FILE

==>cat tns_entry_list DB1 Db2 Db3 db4 ==>cat find_max_dbfs.ksh #!/bin/ksh for tns_entry in `cat tns_entry_list` do echo “–” echo “——— TNS ENTRY ${tns_entry} ———-” /oracle/app/oracle/product/9.2.0.8/bin/sqlplus monioring_user/monitoring_password@${tns_entry} cat find_max_dbfs.sql set lines 120 pages 200 col “-?db_files_value” format a20 col “MAXDATAFILES” format 9999999999999999 col “USED MAXDATAFILES” format 99999999999999 select ‘-?’ || x.value as “-?db_files_value”, y.records_total “MAXDATAFILES”, y.records_used “USED…

Read More “Running some SQL on multiple databases connecting using monitoring userid and password” »

1) Add hard drive in vmware console. Select any SCSE disk type. 2) From vmware itself you will know that what will its sd number. like will it be sda,sdb.. or sdz. 3) start virtual machine and do the following as root: # fdisk /dev/sdg1 Here create a primary partition and write partition table. now…

Read More “Adding addidional hard drive and attach it to a linux box.” »

shutdown -h now

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” »

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” »