Category: shell

mount -F nfs 192.168.6.36:/cdrom/cdrom0 /mnt

(*) To determine the size of the configured swap space, enter the following command: /usr/sbin/swap -s (*) To determine whether the system architecture is 64-bit, enter the following command: /bin/isainfo -kv This command should return the following output. If you do not see the expected output, you cannot install the 64-bit Oracle software on this…

Read More “Important Solaris Commands” »

eaappprod21->UAS@(/export/home/oracle/paresh/uocuat)ipcs -A IPC status from as of Wed Aug 31 15:17:54 EDT 2005 T ID KEY MODE OWNER GROUP CREATOR CGROUP CBYTES QNUM QBYTES LSPID LRPID STIME RTIME CTIME Message Queues: T ID KEY MODE OWNER GROUP CREATOR CGROUP NATTCH SEGSZ CPID LPID ATIME DTIME CTIME ISMATTCH Shared Memory: m 0 0x500004cf –rw-r–r– root root…

Read More “To seee semaphores and shared memory segments in Solaris” »

Use $ top last pid: 17552; load averages: 0.04, 0.03, 0.04 15:16:01 93 processes: 88 sleeping, 2 zombie, 3 on cpu CPU states: % idle, % user, % kernel, % iowait, % swap Memory: 8192M real, 3841M free, 2867M swap in use, 5629M swap free PID USERNAME THR PRI NICE SIZE RES STATE TIME CPU…

Read More “To see mem usage and CPU usage system wide.” »

use $psrinfo 0 on-line since 03/10/05 14:49:00 1 on-line since 03/10/05 14:49:09 4 on-line since 03/10/05 14:49:09 5 on-line since 03/10/05 14:49:09 8 on-line since 03/10/05 14:49:09 9 on-line since 03/10/05 14:49:09 10 on-line since 03/10/05 14:49:09 11 on-line since 03/10/05 14:49:09 12 on-line since 03/10/05 14:49:09 13 on-line since 03/10/05 14:49:09

How does one monitor and trace Unix processes? To trace what a Unix process is doing enter: truss -rall -wall -p truss -p $ lsnrctl dbsnmp_start NOTE: The “truss” command works on SUN and Sequent. Use “tusc” on HP-UX, “strace” on Linux, “trace” on SCO Unix or call your system administrator to find the equivalent…

Read More “Monitor and Trace Unix processes using truss” »

This example uses the Unix split command to create multiple files, each smaller than the Unix (and imp/exp) 2 Gigabyte file size limit. This method can typically be used for import, export and SQL*Loader operations. cd /tmp/data rm exp.dmp mknod exp.dmp p # mkfifo on certain Unix flavours split -b2047m /tmp/data/exp.dmp & imp scott/tiger file=/tmp/data/exp.dmp…

Read More “How does one overcome the Unix 2 Gig file limit?” »

One can select a value from a database column directly into a Unix environment variable. Look at the following shell script examples: #!/bin/sh VALUE=`sqlplus -silent user/password@instance

sh -x ./myshellfile.sh

***** Both hourly jobs ***** 01 * * * * /export/home/oracle/scripts/move_arch_files_uoc.ksh > /export/home/oracle/scripts/log/move_arch_files_uoc.log 2> /export/home/oracle/scripts/log/move_arch_files_uoc.err 01 * * * * /export/home/oracle/scripts/move_arch_files_cif.ksh > /export/home/oracle/scripts/log/move_arch_files_cif.log 2> /export/home/oracle/scripts/log/move_arch_files_cif.err ***** for 15 mins interval ***** 01,16,31,46 * * * * /export/home/oracle/scripts/move_arch_files_uoc.ksh > /export/home/oracle/scripts/log/move_arch_files_uoc.log 2> /export/home/oracle/scripts/log/move_arch_files_uoc.err