Parm Patram

Oracle, Linux and UNIX tips, tricks and stuff
  • Home
  • Site Map
  • Create local yum repository

    Linux 05-25-2009 Comments Off

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

  • iscsi-ls for redhat Enterprise Linux 5

    RAC 05-23-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

  • Actual RAC build notes

    RAC 05-18-2009 Comments Off
    1. tmpfs needs to be expanded: /etc/fstab put size=4G in place of ‘default’ for the tmpfs. This is necessary to get isci to start! I beat myself up for 2 days on this :(
    2. openfiler host/netmask is somewhat misleading. Use the EXACT rac nodes IP addresses and the netmask 255.255.255.255 (specifying the host explicitly).
    3. ocfs2 rpms need to match ‘uname -a’ exactly or it wil NOT work. It will install without warning, but will NOT work.
    4. iscsi-ls is not available for RHEL5. You can run ocfs2console and it will show you the scsi ID on the local machine that the disks are attached to. You can then mount them manually.
    5. java not installed to /usr/local/java/bin, but at /bin/java/jre/1.4.2_06/bin so I had to symlink like so
      cd /usr/local
      mkdir java
      cd java
      ln -s /bin/java/jre/1.4.2_06/bin
    6. vipca and srvctl have a wierd bug where it uses LS_ASSUME_KERNEL. They need to be commented out as explained in http://cs.felk.cvut.cz/10gr2/relnotes.102/b15659/toc.htm#CJABAIIF
  • Getting APC back-UPS UPS’s to work on Linux

    Linux, RAC 05-15-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

  • Wake On Lan software

    RAC 05-14-2009 Comments Off

    Download from here: http://www.depicus.com/download.aspx?product=gui

  • OCFS2 and ASMlib downloads

    RAC 05-12-2009 Comments Off

      OCFS2:

      • http://oss.oracle.com/projects/ocfs2/files/RedHat/RHEL5/i386/

      OCFS2 tools/console:

      • http://oss.oracle.com/projects/ocfs2-tools/files/RedHat/RHEL5/i386/1.4.1-1/
      • http://oss.oracle.com/projects/oracleasm/dist/files/RPMS/rhel5/x86/2.0.5/2.6.18-92.1.17.el5/oracleasm-2.6.18-92.1.17.el5-2.0.5-1.el5.i686.rpm
    • Getting OEM to work on Vision 12i

      OEM 05-09-2009 Comments Off

      1. emca -config dbcontrol db -repos create

      2. by default the sys user is NOT in the remote password file and will NOT be able to login via OEM. Add the user:
      $ORACLE_HOME/bin/orapwd file=$ORACLE_HOME/dbs/orapw<INST> password=hullahoop

    • Show grants for a specific user

      GRANTS 05-09-2009 Comments Off

      select privname,object_name from ku$_objgrant_view join all_objects on object_id=obj_num where grantee=’THE_USER’;

    • recovering from hung nxclient session

      Linux, NXclient/server 05-09-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

    • Identify invalid online redo logs

      REDO LOGS, SQLPLUS 05-04-2009 Comments Off

      select group#,l.sequence#,archived,l.status running, lf.status os_status,member from v$log l join v$logfile lf using(group#) order by group#;

      NOTES:

      • The STATUS column of v$logfile (os_status) is NOT refreshed in real-time. Information is updated on log switch.
    « Previous 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
    • 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
    • NXclient/server
    • Online Resources
    • PERL
    • PERSONAL
      • RECIPES
    • python
    • RMAN
      • RMAN Catalog Setup
    • Routing & Switching
    • 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
    • VMWare
    • VNC
    • VPN
    • Windows XP
    © Blogname. All Rights Reserved. Entries RSS Comments RSS Login Open Source