Oracle Study Guide

For 10g OCP DBA
  • Home
  • Site Map
  • Packing scripts into an rpm

    Linux 06.11.2009 Comments Off

    Name: <<< name package will have in rpm db >>>
    Version: <<< version number of sources >>>
    Release: <<< release number of the rpm build >>>
    BuildArch: noarch
    Source0: <<< path to source files.
    NOTE: source files must be packed in a directory in this format %{name}-%{version}  then tarred and gzipped >>>
    License: GPL
    Group: Development/Tools
    Buildroot: %{_tmppath}/%{name}-root

    %description
    <<< description as seen from rpm -qi >>>

    %prep
    %setup -q

    %build
    %install
    rm -rf $RPM_BUILD_ROOT
    mkdir -p $RPM_BUILD_ROOT/<<< directory in the rpm repo >>>
    …
    install -m 755 <<< script in the source build >>> $RPM_BUILD_ROOT/<<< destination in the rpm repo >>>
    …

    %post
    <<< post install script here >>>

    %postun
    <<< post uninstall script here >>>

    %clean
    rm -rf $RPM_BUILD_ROOT

    %files
    %defattr(-,root,root)
    <<< list of files/directories in the package here >>>

    Tags: build your own rpm, building an rpm from source files

  • Create local yum repository

    Linux 25.05.2009 Comments Off

    http://dotancohen.com/howto/yum_repo.html

  • Getting APC back-UPS UPS’s to work on Linux

    Linux, RAC 15.05.2009 Comments Off

    Guide at : http://www.mscs.dal.ca/~selinger/ups/backups.html

    you will need to change the following line if you use dual NIC’s (as in the case of our RAC systems) in /usr/etc/upsd.conf

    LISTEN localhost

  • recovering from hung nxclient session

    Linux, NXclient/server 09.05.2009 Comments Off

    If the server crashes while there are active nxclient connections nxclient will continue to detect the stale connection and will not allow you to connect. The easy way to get around this is by stopping the statistics daemon for NX:

    /usr/NX/bin/nxstat stop

    It is a good idea to restart it after you successfully login:

    /usr/NX/bin/nxstat start

  • Create raw devices for ASM

    ASM, Linux 03.05.2009 Comments Off

    http://oracle.3dub.com/ASM_20.shtml

  • Command line history/editing for sqlplus (rlwrap)

    HEADS UP, Linux, SQLPLUS 11.11.2008 Comments Off

    install rlwrap (available from http://utopia.knoware.nl/~hlub/rlwrap/)

    then add this to the bash_profile:

    alias sqlplus=’rlwrap sqlplus’

  • Login over serial port (with laptop)

    Linux 28.10.2008 Comments Off

    http://www.vanemery.com/Linux/Serial/serial-console.html

  • Increasing size of /dev/shm

    Linux 06.10.2008 Comments Off

    change ‘default’ to ’size=Xg’ in /etc/fstab

    Then remount the filesystem

    mount -o remount /dev/shm

Category:

  • Administration
    • ASM
    • BLOCK SIZE
    • Database Recovery
    • DBVERIFY
    • GRANTS
    • OEM
    • REDO LOGS
  • APPS
    • AutoConfig
    • Change EBS IP Address
    • Cloning
    • DB Environment Vars
    • Discoverer
    • Environment Vars
    • Patching
    • Problems
    • Resources Online
    • Tricks & Tips
    • Upgrading
    • Workflow
  • Backup & Recovery
  • Certification
  • Configuration
  • DATABASE STRUCTURE
    • Data Dictionary
    • Logical Database Structure
    • Physical Database Structure
    • SCHEMA
  • DATAGUARD
  • Documentation
    • ASM (Automatic Storage Magement)
    • Command Reference
    • DataPump
    • Documentation Library
    • SQL Developer
  • EBS
  • Enterprise Manager
  • FLASHBACK
  • HACKING
  • HEADS UP
  • Installation
    • RAC
  • JDeveloper
  • Linux
  • NXclient/server
  • Online Resources
  • PERL
  • python
  • RMAN
    • RMAN Catalog Setup
  • Scripts
  • Serial-Parallel-Port-Testers
  • SNMP
  • Software
  • Solaris
  • Spiritual
  • SQL & PL/SQL
  • SQLPLUS
  • Startup/Shutdown
  • Streams
  • Tuning
    • INDEXES
    • SQL Tuning
      • TKPROF and sql_trace
  • VNC
  • Windows XP
© Blogname. All Rights Reserved. Entries RSS Comments RSS Login Open Source