What is required for Oracle TAF support?


How to setup DataGuard with TAF enabled on Oracle Database for HP Service Manager 9.31?

Source: https://softwaresupport.hpe.com/group/softwaresupport/search-result/-/facetsearch/document/KM00558641?lang=en&cc=us&hpappid=202392_SSO_PRO_HPE

NOTE: Please refer to oracle documentation to get details on the parameter. The following configuration uses Primary oracle server with Standby. It does not use RAC.

High Level Steps

  1. Create production service on primary node
    2. Start service on production node
    3. Ensure standby database is know to srvctl
    4. Create production service on standby node.
    5. Create production service entry in tnsnames on primary and standby nodes.

DataGuard Configuration
With the environment using the “Oracle Restart” cluster services on a standalone VM server, The DataGuard database is registered to the Oracle Restart configuration.
Add standby database to the srvctl on standby node.

  • srvctl add database –d SM9PROD –o  /oracle/home/… -p /U01/app/oracle/spfileSM9PROD.ora –r PHYSICAL_STANDBY –a “SBDAT,SBFRA”On each server, create a SERVICE that will only be in effect when the database is in the PRIMARY role while on that server.  In the configuration of this SERVICE, the TAF parameters are set to “NONE”.

Notes:

The production service does not get started on the standby database as it cannot be started on the standby node as it is already running on the production node. At failover time the service will be moved to the standby node.

  • srvctl add service –d SM9PROD –s SM93P –l PRIMARY –m NONE –e NONE –w 1 –z 180
  • srvctl add service –d SM9P   –s SM93P –l PRIMARY –m NONE –e NONE –w 1 –z 180

TESTING results:

Active users updating incidents when the switch over to the standby server is tested. The sm.log shows following error and the connection fails over from primary to standby /dataguard.

Sm.log:

12713996(83034157) 09/05/2013 10:32:39  RTE I Undisplayed message:SQL code=12516 message=ORA-12516: TNS:listener could not find available handler with matching protocol stack  (se.get.record,get.record)
12713996(83034157) 09/05/2013 10:32:39  RTE I Undisplayed message:API=OCIServerAttach-Remote [in sqociConnect] (se.get.record,get.record)
12713996(83034157) 09/05/2013 10:32:39  RTE I Undisplayed message:SQL code=12516 message=ORA-12516: TNS:listener could not find available handler with matching protocol stack  (se.get.record,get.record)
12713996(83034157) 09/05/2013 10:32:39  RTE I Undisplayed message:API=OCISessionEnd() (se.get.record,get.record)

…….40512894(102105241) 09/05/2013 10:33:12  RTE E API=OCIBindByPos, Statement=SELECT * FROM LICENSEINFOM1 WHERE “ID”=:Y  FOR UPDATE
20512894(102105241) 09/05/2013 10:33:12  RTE E Error: SQL code=1036 message=ORA-01036: illegal variable name/number
20512894(102105241) 09/05/2013 10:33:12  RTE E API=OCIBindByPos, Statement=SELECT * FROM LICENSEINFOM1 WHERE “ID”=:Y  FOR UPDATE
20512894(102105241) 09/05/2013 10:33:12  RTE E Error: SQL code=1036 message=ORA-01036: illegal variable name/number
20512894(102105241) 09/05/2013 10:33:12  RTE E API=OCIBindByPos, Statement=SELECT * FROM LICENSEINFOM1 WHERE “ID”=:Y  FOR UPDATE
20512894(102105241) 09/05/2013 10:33:12  RTE E Error: SQL code=1036 message=ORA-01036: illegal variable name/number

….

20512894(102105241) 09/05/2013 10:33:12  RTE I Undisplayed message:SQL code=12516 message=ORA-12516: TNS:listener could not find available handler with matching protocol stack  (build.list,select)
20512894(102105241) 09/05/2013 10:33:12  RTE I sql total 4.000  call#:4559 –>sqociDisconnect:OCISessionEnd
20512894(102105241) 09/05/2013 10:33:12  RTE I sql total 4.000  call#:4560 –>sqociDisconnect:OCIServerDetach
20512894(102105241) 09/05/2013 10:33:12  RTE I Thread termination cleanup complete
13828260(117899357) 09/05/2013 10:33:12  RTE I sync process attempting to remove resources for pid(16711798) tid(42270967)
21430272(82182147) 09/05/2013 10:33:12  RTE I Connection to dbtype ‘oracle10’ Oracle server ‘sm93P’ as user ‘sm’ successful

 

NOTE:This is not oracle RAC with TAF enabled but oracle dataguard with TAF as service.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s