Clicky Web Analytics

Clicky


Aug
21
Sat
Posted By Ritesh Chhajer on Saturday, August 21, 2010
23383 Views | 7 Comments

It's all good to be an architect and discuss Oracle internals at length but in real time production issues, when the shit hits the fan, everyone runs for the cover. Anyways, without digressing further, I've tried to consolidate various issues pertinent to 10g CRS along with troubleshooting tips and specific examples to fix them.



Jul
30
Fri
Posted By Ritesh Chhajer on Friday, July 30, 2010
15043 Views | 15 Comments

For last few months, I've been busy like hell dealing with umpteen number of Oracle 11gR2 RAC installations and upgrades and it's been a roller coaster ride discovering a new feature or bug every day. So I reckon it's high time to consolidate and put together a summarized checklist for fellow DBAs. Obviously, I won't be able to cover all the 11gR2 features but nevertheless would like to share my learnings and discoveries.

Categories
RAC



Mar
4
Wed
Posted By ritzy on Wednesday, March 04, 2009
18619 Views | 7 Comments

Using Oracle's heterogenous services also known as HS, we can make a connection to non-Oracle databases and access the data remotely. I used MS SQL server as the target non-Oracle database on Windows and used HS to access from Oracle database residing on Linux. Here, we'll see step by step instructions on how to set up a connection from Oracle database to Microsoft SQL server.


Categories



Feb
24
Tue
Posted By ritzy on Tuesday, February 24, 2009
54820 Views | 13 Comments

Physical Standby Concepts

Data Guard broker helps to efficiently manage a dataguard configuration through a client connection to any database in the configuration and it's very easy to switchover/failover with one command thereby minimizing overall downtime associated with planned/unplanned outage. It's also integrated with CRS so that database role changes occur smoothly and seamlessly. Here, we'll see how easy it is to setup using command line interface DGMGRL with an example.


Categories



Posts Tagged listener in blog OraTalk   - www.ritzyblogs.com

Recommended Oracle DBA Books Minimize

     

Tag Cloud Minimize


Archive Posts Minimize
 
Monthly
    Yearly

    Disclaimer:
    This posting is provided "AS IS" with no warranties, and confers no rights. You assume all risk for your use.

    This posting has nothing to do with my present or past employer.