Website Design, Website Development, Shopping Carts, Content Management Systems, Custom Programming, Custom Applications Appsdba: How to append DB parameters in RAC Database !!!!!

Oracle Applications, Middleware, Database, DB RAC & HA

It is place where anyone grab more knowledge about Oracle Applications, middleware etc.

 
APPS R12
  • File System
  • Tech Stack
  • Admin Scripts
  • Forms Mode
  • APPS 11i
  • Know more
  • Maintenance Mode
  • Maintenance Mode(New)
  • Patching
  • APPS Scripts
  • Database Scripts
  • Protect APPS Password
  • Concurrent Manager
  • Database Refersh
  • Patchset Utility
  • Forms Data Loader
  • Web Server
  • Space Required
  • Responsibilities Of APPSDBA
  • OAS 9i/10gR2
  • Software Load Balancer
  • OAS 10gR3
  • Components
  • HTTP Server as Port 80
  • Database
  • Enable Archive
  • Clear Temp Tablespace
  • Drop DB (New in 10g)
  • Database Performance
  • Oracle Process
  • Advanced Topic
  • Database RAC

  • Do you know
  • Clusterware
  • Manage RAC Environment
  • High Availability
  • Certifications
  • EBS R12 Beta Exam
  • APPS 11i - 1z0-233
  • RAC 10gR2 - 1z0-048
  • Oracle Certifications
  • DBA Tools
  • TOAD
  • KEEP TOOL
  • ORACLE's SQL DEVELOPER
  • Spotlight on Oracle E-Business
  • DBDiff For Oracle

  • How to append DB parameters in RAC Database !!!!!
    Monday, November 30, 2009
    -> Take the backup of existing SPFILE which is located at shared location.
    In my case it's in (spfileTEST.ora) under /test/oradata/data01

    -> Create the pfile from spfile.

    -> Add the required parameter in pfile for both instancs all the RAC nodes

    *.parameter_name

    -> Create the spfile(spfiletest.ora) in temporary location from pfile.

    -> Bring down the services of TEST instance.

    -> Move the spfile (spfileTEST.ora created above) from temporary location to /test/oradata/data01

    -> Bring up the services of TEST instance.
    posted by Jaswinder Singh @ 4:34 AM  
    1 Comments:
    • At Saturday, December 19, 2009, Anonymous 8GB SD Karte said…

      For a complete list of kernel settings read Configure Kernel Subsystem Attributes on Tru64 UNIX.
      The current settings can be viewed using the following commands:
      /sbin/sysconfig -q ipc
      /sbin/sysconfig -q proc
      If any settings need to be altered they can be added to the end of the "/etc/sysconfigtab" file.

       
    Post a Comment
    << Home
     
    About Me

    Name: Jaswinder Singh
    Home: Bangalore, Karnataka, India
    Certifications: RAC Certified Expert, OCP 9i, 10g & 11i
    About Me: I am working as APPSDBA, have hands on experience on DB RAC, HA on OAS 10g and Oracle Applications.
    See my complete profile
    Previous Post
    Archives
    Links
    Powered by

    Free Blogger Templates

    BLOGGER

    ADVERTISEMENT
    click here
    © 2006 Appsdba .