#!/bin/ksh LOGFILE=/export/home/oracle/paresh/mylog.log NOTIFY_LIST=me@pvmehta.com while true do echo “Reading Time : `date` n” >> ${LOGFILE} echo “Following Files are currently copying” >>${LOGFILE} ls -rlt /db*/oradata/800JPOE/*.dbf | tail -2 >>${LOGFILE} echo “Out of 116 files, `ls -rlt /db*/oradata/800JPOE/*.dbf | wc -l` files copied so far” >> ${LOGFILE} echo “df -k /800JPOEARCH” >> ${LOGFILE} df -k /800JPOEARCH >>…
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…
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” »
