Archive for December, 2008

Is user equivelance really required at the OS level after RAC installation?

Posted on December 18, 2008. Filed under: DBA/Admin Tips, Database, Operating System, RAC, TroubleShooting, Uncategorized | Tags: , , , |

A wild though came to my head late this evening about the user equivelance in RAC. What will happen if i remove the user equivelance for the oracle home owner between the RAC nodes. What do you think – will this mess up the normal operation of the database ???
BTW, User Equivelance = Ability to [...]

Read Full Post | Make a Comment ( None so far )

Single Putty Window – Multiple Tabs – for multiple server connections

Posted on December 18, 2008. Filed under: DBA/Admin Tips | Tags: , |

Is it possible to have a tabbed putty like firefox or internet explorer? Yes you can, check out below URL
http://www.thegeekstuff.com/2008/08/turbocharge-putty-with-12-powerful-add-ons-software-for-geeks-3/
Look for Putty connection Manager.
cheers,
OraclePitStop.

Read Full Post | Make a Comment ( 1 so far )

How to migrate PUTTY settings from one windows desktop/laptop to the other?

Posted on December 18, 2008. Filed under: DBA/Admin Tips | Tags: |

Migrating putty settings from one desktop/laptop to the other box comes in handy when you had already customized your putty with saved sessions. The migration will also help a new member of an exisitng DBA support team.
Here are the steps
Start -> Run (or Windows Button + R)
Type in ‘regedit’ and press enter – this command [...]

Read Full Post | Make a Comment ( None so far )

Oracle Apps R12 : How to find the list of responsibilities assigned to user(s)

Posted on December 17, 2008. Filed under: DBA/Admin Tips, R12, Scripts | Tags: , , |

SELECT FURGA.USER_ID
, FU.USER_NAME
, FURGA.RESPONSIBILITY_ID
, FRTL.RESPONSIBILITY_NAME
, FURGA.RESPONSIBILITY_APPLICATION_ID
, FA.APPLICATION_SHORT_NAME
, FURGA.SECURITY_GROUP_ID
, FSG.SECURITY_GROUP_KEY
, FURGA.START_DATE
, [...]

Read Full Post | Make a Comment ( 1 so far )

dbca – Creating RAC Database using dbca in silent mode

Posted on December 16, 2008. Filed under: DBA/Admin Tips, Database, Linux, RAC, TroubleShooting | Tags: , , |

During the course of the DBA life, we all know how irritating it is to create a DB or to install a Oracle Software on a UNIX Flavour box from a remote machine using a X – Server. Each click would take minutes to react (My favourite is the tab button on the keyboard) but [...]

Read Full Post | Make a Comment ( 2 so far )

Interesting enhancements in 12.0.6 – R12.ATG_PF.A.DELTA.6

Posted on December 2, 2008. Filed under: Apps Technology Stack, DBA/Admin Tips, R12, Technology | Tags: , , |

Oracle Applications Technology Stack Release Update Pack 6 (R12.ATG_PF.A.DELTA.6)
Autoconfig has two new options
1. Parallel Mode
2. Profile Mode
Parallel Mode
This mode enables autoconfig to be executed parallel across all mid-tiers. Oh man, i love this feature … it really helps when you have multiple mid-tiers.
Just add -parallel to your normal adconfig command
Profile Mode
This option provides a drill [...]

Read Full Post | Make a Comment ( 1 so far )

  • a

  • Blog Stats

    • 176,733 hits

Liked it here?
Why not try sites on the blogroll...