Oracle DBA Solution !!

RPM: REDHAT PACKAGE MANAGER rpm: its a low level utility to install/manage/erase packages rpm -q: to query for a package (installed) ex: rpm -q openssh rpm -qa : to query all installed packages ex: rpm -qa rpm -qa | grep "ssh" rpm -q -i - package information ex: rpm -q -i openssh-server rpm -q -l -- lists files installed by package rpm -q -c -- lists only config files installed by package rpm -q -d -- lists only document files installed by package How to install a package: rpm -ivh vsftpd-2.2.2-11.el6.x86_64.rpm How to remove a package: rpm -e vsftpd yum - yellowdog updater modified yum need repository configuration before using it for installing/updating/query packages. 1. create a file with extention '.repo' in /etc/yum.repos.d vim /etc/yum.repos.d/hello.repo [ftprepo] name=its a ftp repo baseurl=ftp://192.168.2.1/pub enabled=1 gpgcheck=0 [cdrepo] name=its a cd repo baseurl=file:///media/RHEL6.3 enabled=1 gpgcheck=0 ----------------------------...

NFS: Network File System 1. install NFS in server yum install nfs-utils note: how to verify if a package is already installed or not rpm -qa | grep "nfs" 2. start and enable the serivce # service nfs start # chkconfig nfs on 3. add the follwoing entry in /etc/exports file /king -rw 192.168.2.0/24 /queen -ro 192.168.2.0/24 4. restart nfs service service nfs restart --------------------------------------------------------------------------- how to access NFS share in client machine: 1. verify the NFS shares available at server #showmount -e 192.168.2.250 2. mount the network file system(share) # mount -t nfs 192.168.2.250:/king /sample 3. mounting permanently # vi /etc/fstab 192.168.2.250:/king /sample nfs defaults 0 0 ==================================================================== autofs: In NFS once if FS is mounted, it will be utilizing n/w resources till the FS is unmounted. to overcome this, we have autofs which will automatically unmount the partit...

                                 Steps to apply hrglobal.drv    DataInstall for hrglobal >>>>   java oracle.apps.per.DataInstall apps <apps_password> thin proddb.prod.nec.com:1571:PROD    +-------------------------------------------------+ |             DataInstall Main Menu               | +-------------------------------------------------+ 1.    Select legislative data to install/upgrade 2.    Select college data to install/upgrade 3.    Select JIT or OTL to install/upgrade 4.    Exit to confirmation menu Enter your choice : 1  # Localisation       ...

How to find session details using SPID: col STATUS for a14 col USERNAME for a14 col OSUSER for a14 col SERVER for a14 col MACHINE for a28 col PROGRAM for a28 col MODULE for a28 col EVENT for a30 set lines 300 pages 3000 select p.Spid,s.SID,s.SERIAL#,s.STATUS,s.USERNAME,s.OSUSER,s.MACHINE,s.PROGRAM,s.MODULE, to_char(s.LOGON_TIME,'DD-MM-YYYY HH24:MI:SS') Logon_Time,s.LAST_CALL_ET,s.EVENT,s.SQL_ID from v$session s,v$process p where s.paddr=p.addr and p.spid=&spid; How to find session details using PID: SELECT    'USERNAME : ' || s.username  || CHR (10)           || 'SCHEMA : '  || s.schemaname || CHR (10)         || 'OSUSER : '  || s.osuser    || CHR (10)          || 'PROGRAM : ' || s.program   || CHR (10)          || 'MACHINE : ' || s.machine ...

Hi All,            We have upgraded JDK    From jdk1.6.0_45  10.3.6.0  To jdk1.6.0_19  on  WebLogic Server 10.3.6.0. Kindly go through the below steps to perform on Web logic. Step 1:     Bring down All the services of weblogic server.                 Bring Down All Managed server ,Admin server  and Node manager .(Stop opmn services) Step 2.     Take a backup of weblogic server. (Parent directory backup)                nohup tar -cvzf Middleware.gz Middleware & Step 3.  Download Patch 27411678: Oracle JRE 6 Update 191. Step 4. Unzip the patch on different directory location  (temporary location) Step 5.  Go to parent directory of Existing JDK directory on server.           ...