Parm Patram

Oracle, Linux and UNIX tips, tricks and stuff
  • Home
  • Site Map
  • Change TimeZone in RHEL

    Enterprise Manager, HEADS UP, Linux 02-14-2011 Comments Off

    mv /etc/localtime /etc/localtime-old

    ln -sf /usr/share/zoneinfo/GMT /etc/localtime

    hwclock –systohc (or –utc)

  • SSL Cert workaround for Oracle Forms behind F5

    Enterprise Manager 02-01-2011 Comments Off

    JInitiator workaround for F5 certificates.

    1. Download the JInit from the server:
    2. Work out with app folks which version of Jinit the modified one will become (use a different one in QA and Prod).
    3. Download the decided upon version from the web. In this case we will download “25” and install it.
    4. Within the ‘C:\Program Files\Oracle\JInitiator 1.3.1.25\lib\security’ folder of the ‘new’ Jinit, open certdb.txt and append the new cert at the end.
    5. Create a self-extracting zip file for the certdb.txt file and remember the path to this .exe file (use WinZip).
    6. open iexpress
      Next
      Next
      Package Title: jinit <Next>
      Next
      Next
      Click Add and add the downloaded JInit package and the self-extracting exe file created in step #5.
      Next
      Install is the jinit .exe and the post-install command is the exe for the zipfile.
      Next
      Next
      Next
      Next
      Save the package (it will need to be uploaded to the server).
      Next until the creating .exe starts, then Finish.
    7. Login to the server:  then switch to ‘oracle’
    8. Go to oracle home (‘oh’)
    9. replace the jinit.exe located at $ORACLE_HOME/jinit/jinit.exe with the one we created.
    10. Modify the following files in $ORACLE_HOME/jinit/us/ :
      jinit_download.htm: We are changing the original jinit version number to the one we are uploading.
      jinit-version.ini : The version numbers are different in this file, but they need to match the new jinit version.
    11. In file $ORACLE_HOME/forms/server, change the file formsweb.cfg to point to the newly created version numbers.
  • Oracle Applications online resources

    Enterprise Manager 09-08-2009 Comments Off

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

  • Provisioning Pack

    Enterprise Manager 08-06-2009 Comments Off

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

  • Add databases to OEM

    Enterprise Manager, OEM 05-01-2009 Comments Off

    emca -deconfig dbcontrol db

    then

    emca -config dbcontrol db

  • datapump export/import using OEM

    DataPump, Enterprise Manager 04-20-2009 Comments Off

    SYSDBA users cannot do export/import.

    Users need to be added to OEM Administrators in order to login to OEM. (’Setup’ link at top of screeen).

  • Administer Linux host using EM

    Documentation, Enterprise Manager, Installation 08-29-2008 Comments Off

    Oracle can use yast to enable EM to manage the system. The yast packages are available from http://oss.oracle.com/projects/yast/

  • Starting/Stopping EM

    Enterprise Manager, Startup/Shutdown 08-27-2008 Comments Off

    $ emctl start|stop dbconsole

    EM is accessable via URL: https://localhost.localdomain:1158/em/

    Login as SYS and the password set during installation and ‘AS’ SYSDBA

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
  • Articles
  • 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
    • iptables
    • Networking
  • Monitoring
    • Big Brother
  • MQ
  • NFS
  • NXclient/server
  • Online Resources
  • PERL
  • python
  • RMAN
    • RMAN Catalog Setup
  • Routing & Switching
  • SAN – NAS
    • Netapp
  • Scripts
  • Serial-Parallel-Port-Testers
  • SNMP
  • Software
  • Solaris
  • Spiritual
  • SQL & PL/SQL
  • SQLPLUS
  • Startup/Shutdown
  • Streams
  • Tuning
    • INDEXES
    • SQL Tuning
      • TKPROF and sql_trace
  • Version Control
  • Vertias
    • VCS
    • VxFS
  • VMWare
  • VNC
  • Windows XP
  • ZFS
© Blogname. All Rights Reserved. Entries RSS Comments RSS Login Open Source