Oracle Study Guide

For 10g OCP DBA
  • Home
  • Site Map
  • Serial and Parallell testers

    Serial-Parallel-Port-Testers 07.10.2009 Comments Off

    9wayloopback1

    Files are located at http://3dub.com/wp-content/SerialParallelTesters/

  • Oracle Applications online resources

    Enterprise Manager 08.09.2009 Comments Off

    http://oracle.anilpassi.com/basic-concepts-list-of-useful-oracle-apps-articles-2.html

  • EBS 11i docs

    Resources Online 18.08.2009 Comments Off

    http://download.oracle.com/docs/cd/B25284_01/current/html/docset.html

  • Change IP address after installing Oracle Apps

    Change EBS IP Address 17.08.2009 Comments Off

    I tried following the instructions for changing the IP in the document http://download.oracle.com/docs/cd/B32110_01/core.1013/b32196/host.htm#CIHHADCE, but it kept erroring out with ‘file not found’ errors. As a quick and easy work-around, I bound the old IP to the loopback and voila!

    create the file /etc/sysconfig/network-scripts/ifcfg-lo:1 like so:
    DEVICE=”lo:1″
    IPADDR=”PUT_YOUR_OLD_IP_HERE”
    NETMASK=”255.255.255.255″

    Tags: change ebs IP, change IP Address EBS, change IP r12 EBS

  • Good blog site for apps

    Resources Online 17.08.2009 Comments Off

    http://practicalappsdba.wordpress.com/

  • Provisioning Pack

    Enterprise Manager 06.08.2009 Comments Off

    http://www.oracle.com/technology/products/oem/pdf/BMP_best_practice.pdf

  • perl to python functions

    python 28.07.2009 Comments Off

    http://linuxmafia.com/faq/Devtools/python-to-perl-conversions.html

  • setting up a kiosk using XP

    Windows XP 19.06.2009 Comments Off

    http://support.microsoft.com/kb/555463

    1. dell computer gx620 has an auto on feature. Auto on time set to 9:45AM.
    2. scheduled task set ’shutdown -s -t 01′ to shutdown at 1:30AM every day.
    3. Windows set to autologin Customer user (http://support.microsoft.com/kb/315231).
    4.  All scripts are stored in vidmenu on Customer desktop.
    5. Screensaver turned off for Customer.
    6. Login script: automate ftp in windows: ftp -n -s:”c:\Documents and Settings\Customer\Desktop\vidmenu\cmdftp.txt” oasisbowl.com cmdftp.txt contains:

     lcd “c:\Documents and Settings\Customer\Desktop\vidmenu”
    user xxxxxx
    <password>
    bin
    cd /httpdocs/vidmenu get menuBuford.txt
    quit

    7. set iexplore homepage to C:\Documents and Settings\Customer\Desktop\vidmenu\menu.html which contains:
    <head>
    <meta HTTP-EQUIV=”REFRESH” content=”60; url=http://www.oasisbowl.com/vidmenu/menu.swf”>
    </head>
    <center>
    Please wait. Menu is loading…
    </center>

  • Create local yum repository

    Linux 25.05.2009 Comments Off

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

  • iscsi-ls for redhat Enterprise Linux 5

    RAC 23.05.2009 Comments Off

    You can download a perl script I wrote to replace the work of iscsi-ls here.

    From the linux server:

    wget http://oracle.3dub.com/iscsi-ls
    chmod 755 iscsi-ls
    ./iscsi-ls

    Tags: iscsi-ls red hat EL5, iscsi-ls redhat, iscsi-ls RHEL 5

« Previous Entries Next Entries »

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