Clicky Web Analytics

Clicky


Oct
2
Sat
Posted By Ritesh Chhajer on Saturday, October 02, 2010
8179 Views | 1 Comments

EMC Powerpath basically provides multipathing and improves I/O over SAN. When dealing with CLARiiON array, database backup would be taken at LUN level using Navisphere CLI(naviseccli) snapview that would allow to create a copy of LUN using snapshots. That's why it becomes highly imperative to have mapping of LUN to physical device and ASM diskgroup. I'll be covering on the script to have that kind of mapping using powerpath management utility and also a little bit on I/O.

Categories



Apr
6
Mon
Posted By ritzy on Monday, April 06, 2009
9745 Views | 12 Comments

In Oracle 10g RAC, when an instance goes down, services running on that instance are relocated to other available instances. But when that instance comes back up, those relocated services need to be manually put back to their preferred instance. By using FAN callouts, we can automate this task.


Categories



Mar
4
Wed
Posted By ritzy on Wednesday, March 04, 2009
18653 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



Mar
2
Mon
Posted By ritzy on Monday, March 02, 2009
37950 Views | 6 Comments

Physical Standby Concepts

This time around, we'll do a switchover and switchback exercise using Oracle dataguard broker. If you need help on setting up the broker, refer my previous post How to setup DGMGRL, broker with example. We'll see how easy it is to switchover using just one command provided the broker is configured correctly. We'll also cover sample examples along with troubleshooting tips and comprehensive sanity checks.


Categories



Feb
24
Tue
Posted By ritzy on Tuesday, February 24, 2009
54913 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



Feb
24
Tue
Posted By ritzy on Tuesday, February 24, 2009
5809 Views | 1 Comments

If you need to setup encrypted connection between your Oracle client and Oracle server, here are the steps on how to configure stunnel for Oracle with sample configuration files


Categories



OraTalk in 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.