Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Oracle Failover from Primary to Secondary Server (SSIS) Expand / Collapse
Author
Message
Posted Friday, April 11, 2014 9:55 AM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Yesterday @ 8:20 AM
Points: 4,195, Visits: 4,267
I have some packages that have Oracle as their Data Source.

I'm not clear as to what I do and\or not need to do.

The primary Server has been failing so I added entries into the 32 and 64 bit tnsnames.ora file to point to the secondary server.

I also created a ODBC Connections and Linked Servers.

I want to failover to the secondary sever as transparent as possible.

I don't recall where you define which Oracle Instance that you are referring to in the SSIS Package?

Any advise would be greatly appreciated.


For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Post #1561036
Posted Friday, April 11, 2014 1:25 PM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Yesterday @ 8:20 AM
Points: 4,195, Visits: 4,267
I basically came up with a solution

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Post #1561118
Posted Saturday, April 12, 2014 11:58 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 12:44 PM
Points: 1,390, Visits: 6,339
was it Oracle TAF automatic fail over using tnsnames ?
Post #1561232
Posted Saturday, April 12, 2014 4:32 PM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Yesterday @ 8:20 AM
Points: 4,195, Visits: 4,267
Jo Pattyn (4/12/2014)
was it Oracle TAF automatic fail over using tnsnames ?


Could you please expand on that?

I do not have control of the Oracle Servers but I can make suggestions to the vendors who Server is constantly failing over.

Thanks again.


For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Post #1561243
Posted Sunday, April 13, 2014 12:23 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 12:44 PM
Points: 1,390, Visits: 6,339
You can click on the link TAF in the above post.
I don't have experience with it but know that you can specify multiple addresses under one TNS-alias. Sometimes an oracle connection manager is used.
If the first address is barred the Oracle-Net layer connects to the second address to the application (but doesn't recover lost work)

The mechanism is quite transparent as you only have one tns-alias for the application to connect to.
You need the full OCI-driver. Another link for java
Post #1561289
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse