DBASolved

Subscribe to  DBASolved feed  DBASolved
Updated: 15 hours 53 min ago

Upgrading GoldenGate Microservices Architecture – GUI Based

Thu, 2018-01-18 10:45

In August of 2017, Oracle released two architectures for Oracle GoldenGate. These architectures were the Classic Architecture and the Microservices Architecture. Since then there has been some discussion around upgrading Oracle GoldenGate to Microservices. Due to the change in architecture, there is no direct upgrade path from Classic Architecture to Microservices Architecture. If you want to use the new Microservices Architecture, you will have to do a fresh install and migrate to the architecture.

Let’s say that you are bold and forward thinking and have already made move to the Oracle GoldenGate Microservices Architecture upon the release of 12.3.0.1.0 in August 2017 … great and I’m happy you did! It is a really cool architecture to be on and will provide you a stepping stone into the cloud world. Now what to do when Oracle releases a new release of Microservices Architecture? … The answer is upgrade!

Now upgrading Oracle GoldenGate Microservices Architecture is not a hard as it has been in the past with Oracle GoldenGate. It has actually gotten simpler to upgrade … all you have to do now is install a new set of binaries and switch the deployment home for your deployments and ServiceManager over to it.

To perform the upgrade simply follow these steps:

1. Login and verfiy what Oracle GoldenGate Home the ServiceManager is using
a. Login to ServiceManager (http(s)://<hostname>:<port>)

b. Review the Deployment section (bottom of page)

2. Install new Oracle GoldenGate for Microservices binaries next to existing binaries. (Technically an out of place upgrade)

3. Update the ServiceManager and/or Deployments with new Oracle GoldenGate Home Information
a. Click the ServiceManager or Deployment (hyperlink)

b. Click the pencil icon. This will open the dialog box for editing

c. Update the GoldenGate Home with the new Oracle GoldenGate Home Path
d. Click Apply

f. From the Overview page, use the Action button to restart the ServiceManager out of the new Oracle GoldenGate home

After hitting “restart” from the Action button, you will lose access to ServiceManager. This is due to the old ServiceManager being shutdown and the new ServiceManager being started out of the new Oracle GoldenGate Home. Once the new ServiceManager is up and running, the same steps can be followed to move your deployment homes to the new Oracle GoldenGate Home.

Note: Ensure you stop all extract/replicat processes within the Deployment Home before moving GoldenGate Home of a deployment.

Enjoy!!!

Categories: DBA Blogs

Changing the port number on a GoldenGate Microservice using REST

Sun, 2017-11-19 12:34

The new Oracle GoldenGate Microservices architecture provides a lot of new functionality and opens up a lot of possibilities. Part of these possiblies is to ability to interact with Oracle GoldenGate from a REST API stand point. The framework provides so much flexability and functionality, it is hard to highlight everything it can do.

Since services are the new thing in Oracle GoldenGate, I figured I do something simple and still show you how easy it is to work with the framework.

Upon inital installation, you have to setup a max of five (5) ports that the microservices will use. We actually recommend putting Oracle GoldenGate Microservices behind a reverse proxy but that is another discussion. With these five ports, you may inadventantly select ports that are in use. So how do you fix this issue after installation?

Answer is quite simple, just change the port number.

In order to change the port number, you need to write a JavaScript Object Notation (JSON) file for the services you want the port number changed for. In my case, I want to change my deployment (Atlanta_1) administration services port from 16001 to 16010. Figure 1 shows you that I’m on 16001.

Figure 1:

Now I want to change the port to 16010. In order to do this I need write a JSON file. My file looks like the sample code below.

{
“config”: {
“network”: {
“serviceListeningPort”:16010
}
},
“configForce”:true,
“enabled”:true,
“status”:”restart”
}

Then I need to come up with a cURL command.

curl -u oggadmin:******* -H “Content-Type: application/json” -H “Accept: application/json” -X PATCH http://localhost:16000/services/v2/deployments/Atlanta_1/services/adminsrvr -d @change_adminsrvr_port.json | python -mjson.tool

The cURL command is going to run the JSON document against my ServiceManager for deployment Atlanta_1, then restart the Administration Service. Figures 2 and , shows you the end result and that the Administration Service is still up and running.

Figure 2:

Figure 3:

There you have it, a simple way via REST to change port numbers for Oracle GoldenGate 12c Microservices.

Enjoy!!!

Categories: DBA Blogs

FORMAT RELASE changes in #GoldenGate #12.3

Sun, 2017-11-19 09:52

This is just a quick note for those who are looking to using Oracle GoldenGate 12.3.0.1 (Classic or Microservices) and want to send trails of a lower version. This information can be found in the Release Notes for Oracle GoldenGate 12.3.0.1 (here).

The default behavior for FORMAT RELEASE settings supported with EXTTRAIL, RMTTRAIL, EXTFILE and RMTFILE has changed. This is due to changes need to support PDBs with Local Undos. The three bullet points below provide a summary of what has changed.

  • Non-CDB databases with compatibility set to 12.1, FORMAT RELEASE 12.2 or above is supported.
  • Non-CDB databases with compatibility set to 12.2, FORMAT RELEASE 12.2 or above is supported.
  • CDB/PDB databases with compatibility set to 12.2, only FORMAT RELEASE 12.3 is supported. This is due to the use of local undo for PDBs, which requires augmenting the transaction ID with the PDB number to ensure uniqueness of trx IDs.

 

Enjoy!!!

Categories: DBA Blogs

Build a Parallel Replicat from #Oracle #GoldenGate #AdminClient

Sun, 2017-11-19 08:33

One of the new features that came out with Oracle GoldenGate 12.3.0.1.0 was the introduction of the Parallel Replicat. This new replicat is designed to help users quickly load data into their envrionments by using multiple parallel mappers and threads. Figure 1 shows you what this concept is about.

Figure 1:

What you need to understand about this architecture is that we are still reading a single trail file. We are just providing a wider road with mulitple lanes for reading (mappers) and writing (appliers). In the middle of all this, the replicat is ensuring that the all transactions are ordered based on key dependancies (PK, FK and UK). This is to ensure that we have all transactions in the order that is required for each individual writer to apply independantly of each other. This is a huge difference from the integrated replicat, where the dependancy and writing was done within the database.

Additonally, the parallel replicat can be configured to run in one of two modes. The first mode is the “integrated” mode. This mode is similar to the current integrated replicat. The big difference is that the readers/writers are external of the database now, but we are still using the internals of the database to manage the processes.

The second mode of the parallel replicat is “non-integrated”. This means the replicat still runs in parallel, but now it is completly outside of the database. Take a moment and think where this could go ….

Now that, you understand the high-level view of the Parallel Replicat, lets take a look at how you can build one from the AdminClient.

The following steps are what you need to do from AdminClient to build a parallel replicat:

1. Open AdminClient

$ cd $OGG_HOME/bin
$ bin> ./adminclient

2. Login to the ServiceManager for the target you want to run against

adminclient> connect http://<host&gt;:<port> deployment <deploment> as <security user> password <password>

3. Create the Parallel Replicat

adminclient> add replicat <group name>, integrated, parallel, exttrail pr

Note: After creating the replicat, you will see a warning as such: 2017-11-19T14:04:06Z INFO OGG-12029 The file with name ‘PREP1.prm’ does not exist.

Note: After creating the replicat, it will automatically show up in the associated Administration Service.

4. Edit Parameter file

adminclient> edit params prep1

5. Start Parallel Replicat

adminclient> start replicat prep1

After the replicat starts, you should see the number of threads that you specified for readers (mappers) and writers (appliers) in the report files.

Take a look and have fun with this new feature. Looks like it is going to be a really good one.

Just for reference, here is my parameter file for parallel replicat:

replicat PREP1
useridalias TGGATE2 domain TGGATE2
INSERTUPDATES
REPERROR(1, DISCARD)
MAP_PARALLELISM 2
MIN_APPLY_PARALLELISM 2
MAX_APPLY_PARALLELISM 8
SPLIT_TRANS_RECS 4
TARGETCATALOG PDB2;
MAP PDB1.SOE.ADDRESSES, TARGET SOE1.ADDRESSES;
MAP PDB1.SOE.CUSTOMERS, TARGET SOE1.CUSTOMERS;
MAP PDB1.SOE.ORDERS, TARGET SOE1.ORDERS;
MAP PDB1.SOE.ORDER_ITEMS, TARGET SOE1.ORDER_ITEMS;
MAP PDB1.SOE.CARD_DETAILS, TARGET SOE1.CARD_DETAILS;
MAP PDB1.SOE.LOGON, TARGET SOE1.LOGON;
MAP PDB1.SOE.PRODUCT_INFORMATION, TARGET SOE1.PRODUCT_INFORMATION;
MAP PDB1.SOE.INVENTORIES, TARGET SOE1.INVENTORIES;
MAP PDB1.SOE.PRODUCT_DESCRIPTIONS, TARGET SOE1.PRODUCT_DESCRIPTIONS;
MAP PDB1.SOE.WAREHOUSES, TARGET SOE1.WAREHOUSES;

MAP PDB1.SOE.ORDERENTRY_METADATA, TARGET SOE1.ORDERENTRY_METADATA;

Enjoy!!!

Categories: DBA Blogs

#GoldenGate Procedural Replication Support

Thu, 2017-10-26 17:32

With the release of Oracle GoldenGate 12c (12.3.0.1.x), came the support for Procedural Replication. This option is an enhancement to the integrated replicat which allows you to replicat Oracle-supplied PL/SQL procedures that cannot be replicated as DML or DDL.

Note: In order to replicate these packages and procedures, you need to be on Oracle Database Release 2 (12.2) an later and using the integrated extract and replicat.

To find out what packages and procedures are support, Oracle has provided new data dictionary views that can be used to see what packages and procedures can be used with Oracle GoldenGate. These views are DBA_GG_SUPPORTED_PACKAGES and DBA_GG_SUPPORTED_PROCEDURES. These views can be found in Oracle Database Release 2 (12.2).

As of Oracle GoldenGate 12.3, there are 309 procedures and 36 packages that are support. This number will increase over time.

The packages that are currently supported are:

DBMS_AQ
DBMS_AQADM
DBMS_AQELM
DBMS_AQJMS
DBMS_DBFS_CONTENT_ADMIN
DBMS_DBFS_SFS
DBMS_DBFS_SFS_ADMIN
DBMS_DDL
DBMS_FGA
DBMS_GOLDENGATE_ADM
DBMS_GOLDENGATE_IMP
DBMS_REDACT
DBMS_REDEFINITION
DBMS_RESCONFIG
DBMS_RLS
DBMS_RULE_ADM
DBMS_SQL_TRANSLATOR
DBMS_XDB
DBMS_XDBRESOURCE
DBMS_XDBZ
DBMS_XDB_ADMIN
DBMS_XDB_CONFIG
DBMS_XDB_REPOS
DBMS_XDB_VERSION
DBMS_XMLINDEX
DBMS_XMLSCHEMA
DBMS_XMLSCHEMA_LSB
SDO_META
SDO_META_USER
XS_ACL
XS_ADMIN_UTIL
XS_DATA_SECURITY
XS_DATA_SECURITY_UTIL
XS_NAMESPACE
XS_PRINCIPAL
XS_SECURITY_CLASS

Packages with associated procedures that are currentlly supported are:

DBMS_AQ AQ$_BACKGROUND_OPER
DBMS_AQ AQ$_BACKGROUND_OPER_PAS
DBMS_AQ AQ$_DELETE_DIOT_TAB
DBMS_AQ AQ$_DELETE_HIST_TAB
DBMS_AQ AQ$_DELETE_TIOT_TAB
DBMS_AQ AQ$_DEQUEUE
DBMS_AQ AQ$_ENQUEUE
DBMS_AQ AQ$_INSERT_DIOT_TAB
DBMS_AQ AQ$_INSERT_HIST_TAB
DBMS_AQ AQ$_INSERT_TIOT_TAB
DBMS_AQ AQ$_UPDATE_HIST_TAB
DBMS_AQ AQ$_UPDATE_HIST_TAB_EX
DBMS_AQ BIND_AGENT
DBMS_AQ DEQUEUE
DBMS_AQ DEQUEUE_INTERNAL
DBMS_AQ DEQUEUE_INTERNAL_PAS
DBMS_AQ ENQUEUE
DBMS_AQ ENQUEUE_INT_SHARD
DBMS_AQ ENQUEUE_INT_SHARD_JMS
DBMS_AQ ENQUEUE_INT_UNSHARDED
DBMS_AQ ENQUEUE_INT_UNSHARDED_PAS
DBMS_AQ LISTEN
DBMS_AQ POST
DBMS_AQ REGISTER
DBMS_AQ REGISTRATION_REPLICATION
DBMS_AQ UNBIND_AGENT
DBMS_AQ UNREGISTER
DBMS_AQADM ADD_ALIAS_TO_LDAP
DBMS_AQADM ADD_CONNECTION_TO_LDAP
DBMS_AQADM ADD_SUBSCRIBER
DBMS_AQADM ALTER_AQ_AGENT
DBMS_AQADM ALTER_PROPAGATION_SCHEDULE
DBMS_AQADM ALTER_QUEUE
DBMS_AQADM ALTER_QUEUE_TABLE
DBMS_AQADM ALTER_SHARDED_QUEUE
DBMS_AQADM ALTER_SUBSCRIBER
DBMS_AQADM CREATE_AQ_AGENT
DBMS_AQADM CREATE_EXCEPTION_QUEUE
DBMS_AQADM CREATE_NP_QUEUE
DBMS_AQADM CREATE_QUEUE
DBMS_AQADM CREATE_QUEUE_TABLE
DBMS_AQADM CREATE_SHARDED_QUEUE
DBMS_AQADM DEL_ALIAS_FROM_LDAP
DBMS_AQADM DEL_CONNECTION_FROM_LDAP
DBMS_AQADM DISABLE_DB_ACCESS
DBMS_AQADM DISABLE_PROPAGATION_SCHEDULE
DBMS_AQADM DROP_AQ_AGENT
DBMS_AQADM DROP_QUEUE
DBMS_AQADM DROP_QUEUE_TABLE
DBMS_AQADM DROP_SHARDED_QUEUE
DBMS_AQADM ENABLE_DB_ACCESS
DBMS_AQADM ENABLE_JMS_TYPES
DBMS_AQADM ENABLE_PROPAGATION_SCHEDULE
DBMS_AQADM GET_PROP_SEQNO
DBMS_AQADM GET_REPLAY_INFO
DBMS_AQADM GET_TYPE_INFO
DBMS_AQADM GET_WATERMARK
DBMS_AQADM GRANT_QUEUE_PRIVILEGE
DBMS_AQADM GRANT_SYSTEM_PRIVILEGE
DBMS_AQADM GRANT_TYPE_ACCESS
DBMS_AQADM MIGRATE_QUEUE_TABLE
DBMS_AQADM NONREPUDIATE_RECEIVER
DBMS_AQADM NONREPUDIATE_SENDER
DBMS_AQADM PURGE_QUEUE_TABLE
DBMS_AQADM RECOVER_PROPAGATION
DBMS_AQADM REMOVE_SUBSCRIBER
DBMS_AQADM RESET_REPLAY_INFO
DBMS_AQADM REVOKE_QUEUE_PRIVILEGE
DBMS_AQADM REVOKE_SYSTEM_PRIVILEGE
DBMS_AQADM SCHEDULE_PROPAGATION
DBMS_AQADM SET_WATERMARK
DBMS_AQADM START_QUEUE
DBMS_AQADM START_TIME_MANAGER
DBMS_AQADM STOP_QUEUE
DBMS_AQADM STOP_TIME_MANAGER
DBMS_AQADM UNSCHEDULE_PROPAGATION
DBMS_AQADM VERIFY_QUEUE_TYPES
DBMS_AQADM VERIFY_QUEUE_TYPES_GET_NRP
DBMS_AQADM VERIFY_QUEUE_TYPES_NO_QUEUE
DBMS_AQELM GET_MAILHOST
DBMS_AQELM GET_MAILPORT
DBMS_AQELM GET_PROXY
DBMS_AQELM GET_SENDFROM
DBMS_AQELM GET_TXTIMEOUT
DBMS_AQELM HTTP_SEND
DBMS_AQELM SEND_EMAIL
DBMS_AQELM SET_MAILHOST
DBMS_AQELM SET_MAILPORT
DBMS_AQELM SET_PROXY
DBMS_AQELM SET_SENDFROM
DBMS_AQJMS AQ$_GET_PROP_STAT
DBMS_AQJMS AQ$_GET_TRANS_TYPE
DBMS_AQJMS AQ$_REGISTER
DBMS_AQJMS AQ$_UNREGISTER
DBMS_AQJMS AQ$_UPDATE_PROP_STAT_QNAME
DBMS_AQJMS CLEAR_DBSESSION_GUID
DBMS_AQJMS CLEAR_GLOBAL_AQCLNTDB_CTX_CLNT
DBMS_AQJMS CLEAR_GLOBAL_AQCLNTDB_CTX_DB
DBMS_AQJMS GET_DB_USERNAME_FOR_AGENT
DBMS_AQJMS SET_DBSESSION_GUID
DBMS_AQJMS SET_GLOBAL_AQCLNTDB_CTX
DBMS_AQJMS SUBSCRIBER_EXISTS
DBMS_DBFS_CONTENT_ADMIN EXIM_MOUNT
DBMS_DBFS_CONTENT_ADMIN EXIM_MOUNTP
DBMS_DBFS_CONTENT_ADMIN EXIM_STORE
DBMS_DBFS_CONTENT_ADMIN MOUNTSTORE_LOG
DBMS_DBFS_CONTENT_ADMIN REGISTERSTORE_LOG
DBMS_DBFS_CONTENT_ADMIN UNMOUNTSTORE_LOG
DBMS_DBFS_CONTENT_ADMIN UNREGISTERSTORE_LOG
DBMS_DBFS_SFS NORMALIZEFS
DBMS_DBFS_SFS REORGANIZEFS
DBMS_DBFS_SFS SHRINKFS
DBMS_DBFS_SFS_ADMIN CREATEFILESYSTEM_LOG
DBMS_DBFS_SFS_ADMIN DELETE_ORPHANS_LOG
DBMS_DBFS_SFS_ADMIN DROPFILESYSTEM_LOG
DBMS_DBFS_SFS_ADMIN EXIM_ATTRV
DBMS_DBFS_SFS_ADMIN EXIM_FS
DBMS_DBFS_SFS_ADMIN EXIM_GRANTS
DBMS_DBFS_SFS_ADMIN EXIM_SEQ
DBMS_DBFS_SFS_ADMIN EXIM_SNAP
DBMS_DBFS_SFS_ADMIN EXIM_TABP
DBMS_DBFS_SFS_ADMIN EXIM_TAB_LOG
DBMS_DBFS_SFS_ADMIN EXIM_VOL
DBMS_DBFS_SFS_ADMIN INITFILESYSTEM_LOG
DBMS_DBFS_SFS_ADMIN PARTITION_SEQUENCE_LOG
DBMS_DBFS_SFS_ADMIN RECACHE_SEQUENCE_LOG
DBMS_DBFS_SFS_ADMIN REGISTERFILESYSTEM_LOG
DBMS_DBFS_SFS_ADMIN SETFSPROPERTIES_LOG
DBMS_DBFS_SFS_ADMIN UNREGISTERFILESYSTEM_LOG
DBMS_DDL SET_TRIGGER_FIRING_PROPERTY
DBMS_FGA ADD_POLICY
DBMS_FGA DISABLE_POLICY
DBMS_FGA DROP_POLICY
DBMS_FGA ENABLE_POLICY
DBMS_GOLDENGATE_IMP ACDR_COLUMN
DBMS_GOLDENGATE_IMP ACDR_COLUMN_GROUP
DBMS_GOLDENGATE_IMP ACDR_END
DBMS_GOLDENGATE_IMP ACDR_START
DBMS_GOLDENGATE_IMP ACDR_TABLE
DBMS_REDACT ADD_POLICY
DBMS_REDACT ALTER_POLICY
DBMS_REDACT APPLY_POLICY_EXPR_TO_COL
DBMS_REDACT CREATE_POLICY_EXPRESSION
DBMS_REDACT DISABLE_POLICY
DBMS_REDACT DROP_POLICY
DBMS_REDACT DROP_POLICY_EXPRESSION
DBMS_REDACT ENABLE_POLICY
DBMS_REDACT FPM_MASK
DBMS_REDACT FPM_UNMASK
DBMS_REDACT UPDATE_FULL_REDACTION_VALUES
DBMS_REDACT UPDATE_POLICY_EXPRESSION
DBMS_REDEFINITION ABORT_REDEF_TABLE
DBMS_REDEFINITION ABORT_ROLLBACK
DBMS_REDEFINITION ABORT_UPDATE
DBMS_REDEFINITION CAN_REDEF_TABLE
DBMS_REDEFINITION COPY_TABLE_DEPENDENTS
DBMS_REDEFINITION EXECUTE_UPDATE
DBMS_REDEFINITION FINISH_REDEF_TABLE
DBMS_REDEFINITION REDEF_TABLE
DBMS_REDEFINITION REGISTER_DEPENDENT_OBJECT
DBMS_REDEFINITION ROLLBACK
DBMS_REDEFINITION SET_PARAM
DBMS_REDEFINITION START_REDEF_TABLE
DBMS_REDEFINITION SYNC_INTERIM_TABLE
DBMS_REDEFINITION UNREGISTER_DEPENDENT_OBJECT
DBMS_RESCONFIG ADDREPOSITORYRESCONFIG
DBMS_RESCONFIG ADDRESCONFIG
DBMS_RESCONFIG APPENDRESCONFIG
DBMS_RESCONFIG DELETEREPOSITORYRESCONFIG
DBMS_RESCONFIG DELETERESCONFIG
DBMS_RULE_ADM GRANT_OBJECT_PRIVILEGE
DBMS_RULE_ADM GRANT_SYSTEM_PRIVILEGE
DBMS_RULE_ADM REVOKE_OBJECT_PRIVILEGE
DBMS_RULE_ADM REVOKE_SYSTEM_PRIVILEGE
DBMS_SQL_TRANSLATOR CLEAR_SQL_TRANSLATION_ERROR
DBMS_SQL_TRANSLATOR CREATE_PROFILE
DBMS_SQL_TRANSLATOR DEREGISTER_ERROR_TRANSLATION
DBMS_SQL_TRANSLATOR DEREGISTER_SQL_TRANSLATION
DBMS_SQL_TRANSLATOR DROP_PROFILE
DBMS_SQL_TRANSLATOR ENABLE_ERROR_TRANSLATION
DBMS_SQL_TRANSLATOR ENABLE_SQL_TRANSLATION
DBMS_SQL_TRANSLATOR REGISTER_ERROR_TRANSLATION
DBMS_SQL_TRANSLATOR REGISTER_SQL_TRANSLATION
DBMS_SQL_TRANSLATOR SET_ATTRIBUTE
DBMS_SQL_TRANSLATOR SET_ERROR_TRANSLATION_COMMENT
DBMS_SQL_TRANSLATOR SET_SQL_TRANSLATION_COMMENT
DBMS_SQL_TRANSLATOR SET_SQL_TRANSLATION_MODULE
DBMS_XDBZ ADD_APPLICATION_PRINCIPAL
DBMS_XDBZ CHANGE_APPLICATION_MEMBERSHIP
DBMS_XDBZ DELETE_APPLICATION_PRINCIPAL
DBMS_XDBZ DISABLE_HIERARCHY
DBMS_XDBZ ENABLE_HIERARCHY
DBMS_XDBZ SET_APPLICATION_PRINCIPAL
DBMS_XDB_ADMIN CREATENONCEKEY
DBMS_XDB_ADMIN INSTALLDEFAULTWALLET
DBMS_XDB_ADMIN MOVEXDB_TABLESPACE
DBMS_XDB_ADMIN REBUILDHIERARCHICALINDEX
DBMS_XDB_CONFIG ADDAUTHENTICATIONMAPPING
DBMS_XDB_CONFIG ADDAUTHENTICATIONMETHOD
DBMS_XDB_CONFIG ADDTRUSTMAPPING
DBMS_XDB_CONFIG ADDTRUSTSCHEME
DBMS_XDB_CONFIG CLEARHTTPDIGESTS
DBMS_XDB_CONFIG DELETEAUTHENTICATIONMAPPING
DBMS_XDB_CONFIG DELETEAUTHENTICATIONMETHOD
DBMS_XDB_CONFIG DELETETRUSTMAPPING
DBMS_XDB_CONFIG DELETETRUSTSCHEME
DBMS_XDB_CONFIG ENABLECUSTOMAUTHENTICATION
DBMS_XDB_CONFIG ENABLECUSTOMTRUST
DBMS_XDB_CONFIG ENABLEDIGESTAUTHENTICATION
DBMS_XDB_CONFIG ISGLOBALPORTENABLED
DBMS_XDB_CONFIG SETDYNAMICGROUPSTORE
DBMS_XDB_CONFIG SETGLOBALPORTENABLED
DBMS_XDB_CONFIG SETHTTPCONFIGREALM
DBMS_XDB_VERSION CHECKIN_INT
DBMS_XDB_VERSION CHECKOUT
DBMS_XDB_VERSION MAKEVERSIONED_INT
DBMS_XDB_VERSION UNCHECKOUT_INT
DBMS_XMLINDEX CREATEDATEINDEX
DBMS_XMLINDEX CREATENUMBERINDEX
DBMS_XMLINDEX DROPPARAMETER
DBMS_XMLINDEX MODIFYPARAMETER
DBMS_XMLINDEX PROCESS_PENDING
DBMS_XMLINDEX REGISTERPARAMETER
DBMS_XMLINDEX SYNCINDEX
DBMS_XMLSCHEMA COMPILESCHEMA
DBMS_XMLSCHEMA COPYEVOLVE
DBMS_XMLSCHEMA DELETESCHEMA
DBMS_XMLSCHEMA GENERATEBEAN
DBMS_XMLSCHEMA INPLACEEVOLVE
DBMS_XMLSCHEMA PURGESCHEMA
DBMS_XMLSCHEMA_LSB COPYEVOLVE
DBMS_XMLSCHEMA_LSB REGISTERSCHEMA_BLOB
DBMS_XMLSCHEMA_LSB REGISTERSCHEMA_OID
DBMS_XMLSCHEMA_LSB REGISTERSCHEMA_STR
DBMS_XMLSCHEMA_LSB REGISTERSCHEMA_XML
SDO_META CHANGE_ALL_SDO_GEOM_METADATA
SDO_META CHANGE_IMP_SDO_GEOM_METADATA
SDO_META DELETEGEORSYSENTRY
SDO_META DELETE_ALL_SDO_GEOM_METADATA
SDO_META DELETE_TOPO_METADATA
SDO_META INSERTGEORSYSENTRY
SDO_META INSERT_ALL_SDO_GEOM_METADATA
SDO_META INSERT_TOPO_METADATA
SDO_META UPDATE_TOPO_METADATA
SDO_META_USER CREATEDMLTRIGGER
SDO_META_USER CREATE_TOPO_BTREE
XS_ACL ADD_ACL_PARAMETER
XS_ACL APPEND_ACES
XS_ACL CREATE_ACL
XS_ACL DELETE_ACL
XS_ACL REMOVE_ACES
XS_ACL REMOVE_ACL_PARAMETERS
XS_ACL SET_DESCRIPTION
XS_ACL SET_PARENT_ACL
XS_ACL SET_SECURITY_CLASS
XS_ADMIN_UTIL DROP_SCHEMA_OBJECTS
XS_ADMIN_UTIL GRANT_SYSTEM_PRIVILEGE
XS_ADMIN_UTIL REVOKE_SYSTEM_PRIVILEGE
XS_DATA_SECURITY ADD_COLUMN_CONSTRAINTS
XS_DATA_SECURITY APPEND_REALM_CONSTRAINTS
XS_DATA_SECURITY APPLY_OBJECT_POLICY
XS_DATA_SECURITY CREATE_ACL_PARAMETER
XS_DATA_SECURITY CREATE_POLICY
XS_DATA_SECURITY DELETE_ACL_PARAMETER
XS_DATA_SECURITY DELETE_POLICY
XS_DATA_SECURITY DISABLE_OBJECT_POLICY
XS_DATA_SECURITY ENABLE_OBJECT_POLICY
XS_DATA_SECURITY REMOVE_COLUMN_CONSTRAINTS
XS_DATA_SECURITY REMOVE_OBJECT_POLICY
XS_DATA_SECURITY REMOVE_REALM_CONSTRAINTS
XS_DATA_SECURITY SET_DESCRIPTION
XS_NAMESPACE ADD_ATTRIBUTES
XS_NAMESPACE CREATE_TEMPLATE
XS_NAMESPACE DELETE_TEMPLATE
XS_NAMESPACE REMOVE_ATTRIBUTES
XS_NAMESPACE SET_DESCRIPTION
XS_NAMESPACE SET_HANDLER
XS_PRINCIPAL ADD_PROXY_TO_DBUSER
XS_PRINCIPAL ADD_PROXY_USER
XS_PRINCIPAL CREATE_DYNAMIC_ROLE
XS_PRINCIPAL CREATE_ROLE
XS_PRINCIPAL CREATE_USER
XS_PRINCIPAL DELETE_PRINCIPAL
XS_PRINCIPAL ENABLE_BY_DEFAULT
XS_PRINCIPAL ENABLE_ROLES_BY_DEFAULT
XS_PRINCIPAL GRANT_ROLES
XS_PRINCIPAL REMOVE_PROXY_FROM_DBUSER
XS_PRINCIPAL REMOVE_PROXY_USERS
XS_PRINCIPAL REVOKE_ROLES
XS_PRINCIPAL SET_ACL
XS_PRINCIPAL SET_DESCRIPTION
XS_PRINCIPAL SET_DYNAMIC_ROLE_DURATION
XS_PRINCIPAL SET_DYNAMIC_ROLE_SCOPE
XS_PRINCIPAL SET_EFFECTIVE_DATES
XS_PRINCIPAL SET_GUID
XS_PRINCIPAL SET_PASSWORD
XS_PRINCIPAL SET_PROFILE
XS_PRINCIPAL SET_USER_SCHEMA
XS_PRINCIPAL SET_USER_STATUS
XS_PRINCIPAL SET_VERIFIER
XS_SECURITY_CLASS ADD_IMPLIED_PRIVILEGES
XS_SECURITY_CLASS ADD_PARENTS
XS_SECURITY_CLASS ADD_PRIVILEGES
XS_SECURITY_CLASS CREATE_SECURITY_CLASS
XS_SECURITY_CLASS DELETE_SECURITY_CLASS
XS_SECURITY_CLASS REMOVE_IMPLIED_PRIVILEGES
XS_SECURITY_CLASS REMOVE_PARENTS
XS_SECURITY_CLASS REMOVE_PRIVILEGES
XS_SECURITY_CLASS SET_DESCRIPTION

 

Enjoy!!!


Filed under: Golden Gate
Categories: DBA Blogs

#GoldenGate/#Database Patches

Wed, 2017-10-25 16:35

In searching for patches for Oracle GoldenGate you have to also look for Oracle Database patches. To make this search a bit easier, some of the great guys on the Oracle GoldenGate team has created a My Oracle Support (MOS) note or two. These notes should be upkept over time. For now, just know these are reference points for you to find out what patches are required for your Oracle GoldenGate environments!

Doc Id: 2193391.1 – Latest GoldenGate/Database (OGG/RDBMS) Patch recommendations

Doc Id: 1557031.1 – Oracle GoldenGate — Oracle RDBMS Server Recommended Patches

Enjoy!!!


Filed under: Golden Gate
Categories: DBA Blogs

OGG-00868/ORA-01291 – Missing log files with Integrated Extract

Sun, 2017-10-22 10:05

Oracle GoldenGate is reliant on the Oracle Redo Logs and Archive Logs when capturing transactions. Since I do a lot of testing on VMs (limited space) and in the cloud (limited space … don’t want to burn to much $), I often delete my archive logs. Normally this is not a problem; however, every once-in-awhile I delete more archivelogs than I should. This throws the IE into a state where it will not start because of OGG-00868/ORA-01291 – Missing Log Files.

On some level this is to be expected, but when you are using IE you have to remember that the extract is registered with the database. Since I’m using Integrated Extract, we have to reset how the extract is registered with the database. The below steps will show you how this should be done:

Note: Registering/Unregistering process have to be done at the container database (CDB) level.

adminclient> dblogin useridalias <alias> domain <domain>
adminclient> stop extract <extract_name>
adminclient> unregister extract <extract_name> database
adminclient> register extract <extract_name> database container <container_name>
adminclient> start extract <extract_name>
adminclient> info extract <extract_name>

Once the extract is re-registered with the database; the integrated extract will start.

Enjoy!!!


Filed under: Golden Gate
Categories: DBA Blogs

#GoldenGate Microservices (4 of 5) … Receiver Service

Mon, 2017-09-25 12:23

This is post 4 of a 5 part post related to Oracle GoldenGate 12.3 Microservices. This series of posts will provide some details over the new graphical user interface (GUI) that has been built into Oracle GoldenGate 12.3.

The Receiver Serivice is the least complicated of the microservices with Oracle GoldenGate 12.3 Microservices. This service is taking the place of the collectors in classic architectures. When you fist login to the Reciever Service, you land on the Overview page (Figure 1). On this page, you can clearly see that the host were it is running on what trail file it is writing to.

Figure 1:

If you click on the “Action” button, you willl be presented with a “Details” option. This option takes you to the Path Information page. On this page, you can see the Network Statistics and File IO Statistics (Figure 2). All this information provides you a view into how your transactions are being written to the trail file and at what rate.

Figure 2:

Lastly, if you go back to the overview page. On the context menu, just like other pages, you have a Diagnosis & Reports page (Figure 3). This page, provides you a quick and easy look at the log file associated with the services. It is color coded (greed, yellow, red) to help you quickly identify what needs to be looked at.

Figure 3:

Enjoy!!!


Filed under: Golden Gate
Categories: DBA Blogs

#GoldenGate Microservices (3 of 5) … Distribution Service

Mon, 2017-09-25 09:44

This is post 3 of a 5 part post related to Oracle GoldenGate 12.3 Microservices. This series of posts will provide some details over the new graphical user interface (GUI) that has been built into Oracle GoldenGate 12.3.

The third part of setting up the replication enviornment with Microservices is to understand what the Distributuion Server is. The component is the replacement for the Data Pump Extract in classic architecture. Distribution Server does all the same things as the Data Pump Extract except with from transformations. If you use transformations in the Data Pump, you really should relook where this is being done.

Note: Transformations should be done at the source, target, or with Oracle Data Integrator.

Distribution Server is your path way for shipping trail files from source to target in the Microservices architecture. Let’s take a closer look at this service.

Upon accessing the Distribution Server page, you see a blank page (Figure 1). This is the overview page and where you will configure you distribution paths needed for replication.

Figure 1:

To begin adding a distribution path, click the plus ( + ) sign on the right hand side of the page. This will take you to the Add Path page (Figure 2). On the Add Path page, you will provide the details for the path. These details include extract/trail file to read from, protocol to use for transmissions, log positioning and many other options. A lot of the items you could do in the data pump extract, can be configured on this page as well.

Figure 2:

After adding a distribution path, you will be able to see clearly where the transactions are coming from and being shipped to (Figure 3). You will also see what database, extract, and trail if being used for the transactions.

Figure 3:

If you click on the “Action” button, you are taken to a menu where you can perform operations on the Distribution Path. There is an option for “Details”. By looking at the details, you can quickly see, in more detail, what is happening with the Distrubtuion Path. You can see the source and target, database, extract, trail name, source trail file, as well as many other item (Figure 4). Additonally, on the details page, you can see the statistics for what is running through the Distribution path.

Figure 4:

Lastly, if you return to the context menu on the left hand side, you will see an option for “Diagnosis & Reports”. Here is where you will be able to take a look at the report file for the Distribution Server (Figure 5). This page provides you with a date sorted view of the log file for easy reading. You will also be able to quickly find items that are wrong or warnings by the color indicator used with the log file.

Figure 5:

Enjoy!!!


Filed under: Golden Gate
Categories: DBA Blogs

#GoldenGate sessions at #OOW17

Thu, 2017-09-21 14:52

We are a little over a week out from Oracle Open World 2017; hopefully you are filling out your schedules! This year there is a lot of items going on; so I figured I would help you out and point out where you can find the Oracle GoldenGate sessions this year! With the release of Oracle GoldenGate 12.3, there is a lot of new features and updates. So check them out (in no particular order)!

Sessions:

  • Oracle GoldenGate Product Update and Strategy
    • Tuesday, Oct 03, 5:45 p.m. – 6:30 p.m. | Moscone West – Room 3003
  • Maximizing Availability for Oracle GoldenGate Microservices
    • Tuesday, Oct 03, 4:45 p.m. – 5:30 p.m. | Moscone West – Room 3014
  • Oracle GoldenGate for Big Data
    • Wednesday, Oct 04, 4:30 p.m. – 5:15 p.m. | Moscone West – Room 3005
  • Deep Dive into Automating Oracle GoldenGate Using the New Microservices
    • Monday, Oct 02, 1:15 p.m. – 2:00 p.m. | Moscone West – Room 3010
  • Accelerate Cloud Onboarding Using Oracle GoldenGate Cloud Service
    • Tuesday, Oct 03, 3:45 p.m. – 4:30 p.m. | Moscone West – Room 3024
  • Oracle Data Integrator and Oracle GoldenGate for Big Data
    • Wednesday, Oct 04, 11:30 a.m. – 12:30 p.m. | Hilton San Francisco Union Square (Ballroom Level) – Continental 4
  • Replicate Data Across Data Centers with Equinix and Oracle GoldenGate
    • Wednesday, Oct 04, 10:30 a.m. – 10:50 a.m. | The Exchange @ Moscone South – Showcase Theater 1
  • An Enterprise Databus: Oracle GoldenGate in the Cloud Working with Kafka and Spark
    • Wednesday, Oct 04, 3:30 p.m. – 4:15 p.m. | Moscone West – Room 3003
  • Oracle GoldenGate Cloud Service: Real-Time Data Replication in the Cloud
    • Monday, Oct 02, 6:00 p.m. – 7:00 p.m. | Hilton San Francisco Union Square (Ballroom Level) – Continental 4
  • Best Practices and Deep Dive on Oracle GoldenGate 12.3 Microservices at Cloud
    • Wednesday, Oct 04, 3:30 p.m. – 4:15 p.m. | Moscone West – Room 3011
  • How to Replicate Data in the Cloud in Real Time
    • Wednesday, Oct 04, 11:00 a.m. – 1:00 p.m. | Hilton San Francisco Union Square (Lobby Level) – Golden Gate 2/3
  • Oracle Data Integration Platform Cloud Strategy and Roadmap
    • Monday, Oct 02, 12:15 p.m. – 1:00 p.m. | Moscone West – Room 3024
  • Oracle Data Integration Platform Empowers Enterprise-Grade Big Data Solutions
    • Monday, Oct 02, 4:45 p.m. – 5:30 p.m. | Marriott Marquis (Golden Gate Level) – Golden Gate C1/C2
  • Kafka’s Role in Implementing Oracle’s Big Data Reference Architecture  
    • Sunday, Oct 01, 1:45 p.m. – 2:30 p.m. | Marriott Marquis (Yerba Buena Level) – Salon 12
  • Oracle Maximum Availability Architecture Best Practices: Oracle Database 12 c
    • Tuesday, Oct 03, 5:45 p.m. – 6:30 p.m. | Moscone West – Room 3006

As you can tell, there is a lot of information that is going to be helpful for your Oracle GoldenGate, BigData and various other areas. Make sure you check all these out.

Enjoy!!


Filed under: Golden Gate
Categories: DBA Blogs

#GoldenGate and #Docker!

Wed, 2017-09-13 22:55

Check this out … Oracle GoldenGate is now avaliable on Docker! All the details you need to get up and running on an image is included in Oracle’s public github.

https://github.com/oracle/docker-images/tree/master/OracleGoldenGate

Enjoy!!!


Filed under: Docker, Golden Gate
Categories: DBA Blogs

#GoldenGate Microservices (2 of 5) … Administration Service

Tue, 2017-09-12 14:30

This is post 2 of a 5 part post related to Oracle GoldenGate 12.3 Microservices. This series of posts will provide some details over the new graphical user interface (GUI) that has been built into Oracle GoldenGate 12.3.

The second interface of the Microservices Architecture that you need to understand is the Administration Service. This service is the interface where you will setup the capture (extract) process and the apply (replicat) process. On the left hand side of the page, in the context menu, you will see a few options … overview, configuration, diagnosis and administrator. These are the primary areas that you interact with the administrator server.

On the overview page, as previously mentioned you can setup your capture (extract) and apply (replicat) processes. You also get a view of the critical events that is are happening within the environment (Figure 1).

Figure 1:

On the configuration page, you will be able to configure credentials that are needed for your replication environment. The addtions of the credential page allows you to create your standard logins for the goldengate user within the database, plus what I’m calling “protocol” users that can be used within the replication environment. Next is the maintenance tab; this tab you can setup tasks like auto start, auto restart, purging trail files, and purge tasks. Additionally, you can add a master key that is used with encryption. Lastly the parameter files tab, will list all the parameter files that is configured in the environment. From here you can edit all the parameters files (Figure 2).

Figure 2:

Next is the diagnosis page. This page is where you can see what is happening in the log file for the Administraton Service. Items on this page will be color coded, green, yellow and red. This give you an indication of what is happening on what you should be looking at (Figure 3).

Figure 3:

Lastly, you have the Administrator page. This page is where you can create users that can access the Oracle GoldenGate environment. When you create a user for access purposes, you get four roles to choose from … Security, Administrator, Operator, and User. Each one of these roles provide a varying level of access (Figure 4).

Note: Do not delete the security user that is created during the intital install of the software.

Figure 4:

Enjoy!!!


Filed under: Golden Gate
Categories: DBA Blogs

#GoldenGate Microservices (1 of 5) … ServiceManager

Mon, 2017-09-11 14:30

This is post 1 of a 5 part post related to Oracle GoldenGate 12.3 Microservices. This series of posts will provide some details over the new graphical user interface (GUI) that has been built into Oracle GoldenGate 12.3.

The first of the Oracle GoldenGate Microservices that you need to understand is that ServiceManager. This service is main interface into the Oracle GoldenGate environment. From the HTML5 page that is provided with ServiceManager, you can quickly get an overview of what is running on the server that Oracle GoldenGate is running on. Additonally the ServiceManager acts as the watch dog process for the environment. This means that if a service was to go down, it can be restarted via the ServiceManager.

The ServiceManager can be configured in three different modes. These modes range from manual to Real Application Cluster (RAC) aware. These modes are:

  1. Manual
  2. Deamon
  3. XAG

These configuration options are selectable during the inital run of Oracel GoldenGate Configuration Assistant (oggca.sh) (Figure 1). If you wanted to use it manually, you woudn’t select anything on this screen. If you want to run it on a single server, than the deamon option is a good choice. For the XAG option, you need to make sure you have the current XAG agent (here).

Figure 1:

After ServiceManage is installed, then you will be able to access the interface via a URL (Figure 2). In the example, you will see that I’m usign port 16000. This is not the default port, but a port that I had configured during the installation using Oracle GoldenGate Configuration Assistant.

Figure 2:

Once the ServerManager page is up, then you just need to login with the administrator account you created during installation of ServiceManager. Keep in mind, if you do not know the userid or password, the consult the people who initally configured the ServiceManager.

After logging in, you are taken directly to the overview page. This page has a few items of importance for the Oracle GoldenGate environment. First you will notice on the left hand side of the page, is a context menu that provides a link to Overview and Diagnostics. This is basically a navigation menu that will be in every microservice (different per service). Then notice at the top of the page, a summary of processes that are running, stopped, or other Lastly, at the middle and bottom of the page, you see the services and deployments that are associated with the installation (Figure 3).

Figure 3:

If you want to know details of the ServiceManager and/or deployments, you can click on the associated deployment under Deployments. This will take you to a summary page, where you can identify items releated to the deployment and change the $OGG_HOME (more on this later).

As you can tell, we have made some great improvments to the Oracle GoldenGate product. Hopefully, this post has you excited to see what else is hiding in the product and my next couple of posts.

Enjoy!!!


Filed under: Golden Gate
Categories: DBA Blogs

Events to round out 2017 … where I’ll be!

Mon, 2017-09-11 08:23

The first half of 2017 started off with me joining Oracle and getting the first looks at the new Microservices Architecture for Oracle GoldenGate. So where does this leave me for the second half of 2017?

As some of you may know, I’m currently working on a Oracle GoldenGate 12.3 roadshow; where I’m explaining the new features in 12.3 and giving attendees hands-on to the new product. After two stops on the roadshow, so far, we have seen so much excitement for this new architecture. It is going to change the way we, as a community, replicate data both on-premise, in the cloud, and in hybrid architecture.

Check out the new Microservice Architecture by downloading it from OTN (here).

As we continue the roadshow, we will be hitting a few more cities in the US before moving on to EMEA in November. Once we get to EMEA, there will be some cool places we plan on holding events and/or meeting customers. The excitement for Oracle GoldenGate 12.3 continues to grow as we attend more cities.

If you want to know the cities in the US, please see this blog post (here).

On top of the US and EMEA legs of the Oracle GoldenGate 12.3 roadshow, I will be attending two conferences in EMEA. I’m sure you can guess at which two … DOAG and UKOUG. This will my first time at both events and I hope I get to see a lot of great friends and make many new ones.

At DOAG, I will be speaking, on November 22, 2017 @ 08:00, about Oracle GoldenGate Peformance Tuning. Additionally, I will have another product manager in tow (hopefully) so attendees will have direct access to the PMs who are responsible for the core Oracle GoldenGate product.

At UKOUG, I will be speaking, need to confirm date, about the Conflict, Detection and Resolution (CDR) in Oracle GoldenGate 12.3 Both the manual process and the new Automatic CDR. Then if needed, by the UKOUG board, I may have another Oracle GoldenGate 12.3 presentation.

All in all, 2017 is rounding out to be a great first year at Oracle along with many first on top of that. Looking forward to seeing everyone on the roadshow!

Enjoy!!!


Filed under: Golden Gate
Categories: DBA Blogs

#GoldenGate Classic vs Microservices Architecture

Fri, 2017-08-25 23:30

With the release of Oracle GoldenGate 12c (12.3.0.1.0) came the introduction of a new architecture that can be used to replicat your business information. This architecture had many different names over the years as it was being developed; which we (Oracle) finally settled on the name of “Microservices” Architecture as we got closer to general release. There are many benefits to the Microservices Architecture and these benefits should give you pause to look closely at this new feature for Oracle GoldenGate 12c.

Before we get into the Microservices Architecture, let’s review the Classic Architecture. In the below image, you see a pretty standard Oracle GoldenGate implementation.

In this architecture, the primary access into the Oracle GoldenGate enviornmentis is through the GoldenGate Service Command Interface (GGSCI). After logging into GGSCI, you can interact and administrate the associated processes, i.e. Manager, Extract (Capture), Data Pump, and Replicat (Apply). The Collectors are pretty much hidden on the target systems, but they are there; just not seen through GGSCI. In this architecture, you data is replicated over TCP/IP between the Data Pump process and Collectors using local and remote trail files.

The downside to this architecture is that, in order to administer the environment, you have to physically login to the server where Oracle GoldenGate is running. With this requirement, many organizations were restrictive on who had access to the server and often caused a debate over who were truely the owners of Oracle GoldenGate.

Althought the Classic Architecture of Oracle GoldenGate has been a bedrock of replication for nearly 20 years, we (Oracle) wanted to leverage that bedrock to transform the way we (industries) replicate data today. This lead to the more flexible and super scalable Microservices Architecture. As you may have guessed, “Microservices” is the mechanism that we are suing to provide access to the “RESTful API” end points. By using RESTful APIs, we (Oracle) have taken a huge leap forward in the replication space. We have broken down the limitations we had around administration and access, while at the same time remaining true to the bedrock that is the foundation of Oracle GoldenGate.

The below image is a view of a simple Oracle GoldenGate Microservices Architecture, for you to review.

As you will notice there are some traditional components of Oracle GoldenGate missing, while there are still extracts (capture), trail files, and replicats (apply). This is due to being a completely new replication architecture which had many benefits. A few of these benefits are:

  • Remote Administration
  • SSL Support
  • HTML 5 webpages for each service/server
  • Additional replication protocols (WSS, WS, UDT, OGG)
  • Real-time Performance Metrics

In order to understand the Microservices Architecture, you have to understand what each of the servers (or services) provide within the architecture. So, let’s take a moment and talk about these items starting with the ServiceManager.

ServiceManager:
The ServiceManager is the watchdog process for the architecture on each server in the replication enviornment. Ideally, you should only have one of these processes running. This process can be configured to run in one of 3 ways. These ways are:

  • Manually
  • As a daemon
  • Integrated with XAG

While the ServiceManager is running, this process will be the main entry point into the Oracle GoldenGate environment. During the configuration process, you will be asked to assign ports for each the servers to run on. The ServiceManager will be the first port you assign. From the HTML5 page of the ServiceManager, you will be able to see all of your deployment homes and associated servers.

AdminServer:
The AdminServer is the service that will take the place GGSCI (don’t worry, we still have a command line in this architecture) and Manager in the Classic Architecture. From here, you will be able to setup your credential store, extract and replicats. Most Oracle GoldenGate Administrators will spend their time here. Additionally, from this service you can drill into the running process and review current status, statistics, parameter files, and report file. Making your administration in general much simpler.

DistributionServer:
The DistributionServer is the replacement for the Data Pump Extract. The service performs all the same functionality as the Data Pump Extract with the exception of transformations. Besides providing all the same functionality, you also get a visual representation of where your trail file is being read from and shipped to. It is very clear to see from the overview page of this services. As you dig into the details of the DistributionServer, you can see the statistics on what is being read and written to trail files and adjust TCP/IP items within the distribution path.

ReceiverServer:
The ReceiverServer is the replacement for the Collectors. The whole job of the ReceiverServer is to accept transmissions from the DistributionServer and write out the remote trail files. From the overview page of this service, you can clearly see where the information is coming from and what trail it is writing to. Just like the DistributionServer, if you look at the details of this service you can see alot of useful information.

Lastly, is the most interesting of the services with the Microservices Architecture. This would be:

Performance Metrics Server:
Finally, we (Oracle) have provide a real-time performance monitoring services with Oracle GoldenGate. Before you get all happy about having a new way to monitor performance, you must have a license for the Oracle Managment Pack for GoldenGate before you can use the GUI or associated metric APIs. If you have that in place, there is so much performance metric information you can retrieve and use in both the GUI and APIs. I would encourage you to take a look.

With that my friends, hopefully, you are a bit excited about using the new Microservices Architecture. There is so much you can do with this architecture and it is going to change how we replicat data, both on-primese, in the cloud, and in hybrid environments.

Enjoy!!!


Filed under: Golden Gate
Categories: DBA Blogs

5 City #GoldenGate Tour

Fri, 2017-08-18 19:59

Oracle GoldenGate is the best replication platform on the market, so much so, the product management team is hitting the road to show customers!  Over the next two months (August 2017 /September 2017) we will be taking to the road to provide customers with hands-on experience of the latest release.  These events will be limited in space and many have filled up already; but if you have the opportunity to attend these will be great events!

The cites and dates that we will be attending (US Leg):

August 23, 2017 – San Francisco, Oracle Headquarters, Redwood Shores
August 29, 2017 – Atlanta, Ga, Oracle Offices
September 12, 2017 – Chicago, Il, Willis Tower (Oracle Offices)
September 13, 2017 – Chicago, Il, Deerfield (Oracle Office)
September 19, 2017 – Dallas, TX
September 26, 2017 – Boston, MA 

If you are interested in attending one of these events, please contact Patrick Cassidy (patrick.cassidy@oracle.com) to register.  Hurry seats are filling up, if not already filled up!!!

Look forward to seeing you at one of the shows.

Note: for the international people reading, we have not forgotten about you.  We are planning on seeing you soon!

Enjoy!!


Filed under: Golden Gate
Categories: DBA Blogs

Oracle #GoldenGate 12.3.0.1 has arrived!

Fri, 2017-08-18 18:46

As of today, August 18, 2017, the latest release of Oracle GoldenGate 12c (12.3.0.1.0) is avaliable for download! You should checkout the new Microservices Architecture!

You can find the links to download Oracle GoldenGate 12c (12.3.0.1.0) at this link: http://www.oracle.com/technetwork/middleware/goldengate/downloads/index.html

This release bring many new features to Oracle Goldengate:

GoldenGate 12.3 Platform Features – All Platforms For the Oracle Database

Support for Oracle Database 12.2.0.1
Oracle Database 12.2.0.1 provides many exciting features for organizations to use. Oracle GoldenGate 12.3 is designed to leverage many of these features in Oracle Database 12.2.0.1 as well. Organizations will have a fully supported and integrated replication framework that provides organizations with performance and throughput enhancements within the Integrated Capture, Integrated Apply and many others processes.

-Microservices Architecture

A new services based architecture that simplifies configuration, administration and monitoring for large scale and cloud deployments. The RESTFul services enable secure remote access using role based authorization over HTTPS and Websocket (streaming) protocols. Each service also has an embedded HTML5 browser based UI for better user experience in addition to traditional command line access for ggsci style scripting/automation. It enables Applications to embed, automate, and orchestrate GoldenGate across the enterprise.

Parallel Replicat
Highly scalable apply engine for the Oracle database that can automatically parallelize the apply workload taking into account dependencies between transactions. Parallel Replicat provides all the benefits of Integrated Replicat performing the dependency computation and parallelism outside the database. It parallelizes the reading and mapping of trail files and provides the ability to apply large transactions quickly in Oracle Database 11g (11.2.0.4) and later.

Automatic Conflict-Detection-Resolution (CDR) without application changes
Quickly enable active/active replication while ensuring consistent conflict-detection-resolution (CDR) without modifying application or database structure. With automatic CDR you can now configure and manage Oracle GoldenGate to automate conflict detection and resolution when it is configured in Oracle Database 12c Release 2 (12.2) and later.

Procedural Replication to enable simpler application migrations and upgrades
Procedural Replication in Oracle GoldenGate allows you to replicate Oracle-supplied PL/SQL procedures, avoiding the shipping and applying of high volume records usually generated by these operations.

Database Sharding
Oracle Sharding is a scalability and availability feature designed OLTP applications that enables distribution and replication of data across a pool of Oracle databases that share no hardware or software. The pool of databases is presented to the application as a single logical database. Data redundancy is managed by Oracle GoldenGate via Active-Active replication that is automatically configured and orchestrated through the database engine invoking the RestFul API’s.

Fast Start Capture
Fast Start Capture is a new feature for Integrated Capture that will improve overall performance and enable you to quickly start capturing and replicating transactions.

For SQL Server

Introducing a new, CDC based Capture

Oracle GoldenGate 12.3 will introduce a new Change Data Capture based Extract, which offers new functional advantages over our existing transaction log based capture method.Benefits include:

  •   Capture from SQL Server 2016
  •   Remote Capture
  •   Transparent Data Encryption (TDE) support

Certification to capture, from an AlwaysOn primary and/or synchronous secondary database
With an increase in uptake of our customers running their application critical databases in an AlwaysOn environment, Oracle GoldenGate 12.3 is the first version to certify capture from either the Primary database, or a read-only Synchronous Secondary database.

-Delivery to SQL Server 2016 Enterprise Edition

For DB2 z/OS

Remote Execution
The new remote execution includes both remote capture and delivery for DB2 z/OS. Running Oracle GoldenGate off the z/OS server significantly reduces the MIPS consumption and allows the support of AES encryption and credential store management.

For DB2 i

Support for IBM i 7.3
Oracle GoldenGate supports the latest DB2 for i platform.

For MySQL

– DDL replication between MySQL Databases
With the DDL replication between MySQL databases, there is no need to stop Oracle GoldenGate replication when there are DDL changes on the source database.

Enjoy!!


Filed under: Golden Gate
Categories: DBA Blogs

#GoldenGate Manager Access Rules

Sat, 2017-06-10 22:21

Starting in Oracle GoldenGate 12.2.0.1, the manager process is more secure than in previous releases of Oracle GoldenGate. After the inital install and running of the Manager process, you may run into the following warning message upon a restart of the Oracle GoldenGate environment:

WARNING OGG-01877 Missing explicit accessrule for server collector.

The inital description of the error message doesn’t make much sense. Using OGGERR, you can find out more about this error message:

$ oggerr ogg-01877
01877, 00000, "Missing explicit accessrule for server collector."
// *Cause: There was no explict ACCESSRULE specified for SERVER.
// *Action: Only allow accessing SERVER from hosts where data pump(s) might

// send trail files to this host.

As you can tell, the error message is pointing you to the ACCESSRULE parameter.

Now that you have more detail, you know that there is a new parameter called ACCESSRULE that needs to be specificed in the manager parameter file. To find out more information on the ACCESSRULE parameter look at this link.

The defnition of this parameter is:

“Use ACCESSRULE to control connection access to the Manager process and the processes under its control. You can establish multiple rules by specifying multiple ACCESSRULE statements in the parameter file and control their priority. To establish priority, you can either list the rules in order from most important to least important,or you can explicitly set the priority of each rule with the PRI option.” 

This parameter is not a default configured parameter for the manager process. This is something that you will need to decided on and how to control access to your environments. The syntax for this parameter is as follows:

ACCESSRULE[, PROG program_name][, IPADDR address][, PRI rule][, login_ID]{,ALLOW | DENY}

There are multiple example of how to define an access rule in the Oracle GoldenGate 12.2.0.1 documentation. The example that I’m providing here is how I resolved the warning message in my Vbox test environment.

ACCESSRULE, PROG * ALLOW

With this access rule, you can now start the manager process without issue. You would be allowing access to all processes in the Oracle GoldenGate environment.

Enjoy!

-Bobby


Filed under: Golden Gate
Categories: DBA Blogs

Oracle GoldenGate 101 at IOUG 17 and GaOUG TechDays 17 within two month

Fri, 2017-03-31 08:00

Losts have changed for me since my last blog post. A new job and new responsibilities, which will include presenting more at conferences on the conference circuit and a few roadshows that are planned in the near future.

Back in the fall of 2016, when most of the Call for Papers open, I had a great idea for introducing people to Oracle GoldenGate. This idea is walk everyone through the progression of replication technology from CDC through Oracle GoldenGate, including some future road map items; that will ensure Oracle GoldenGate stays the number 1 replication tool on the market.

Over the next two months, I will be presenting this great idea/topic in a presentation called Oracle GoldenGate 101 – Replication from the beginning starting at IOUG Collaborate next week (April 2-6, 2017) and then at the best keep secret in the south – Georgia Oracle User Group (GaOUG) Tech Days 17 on May 9th-1th, 2017 (register here). This is going to be a session you will not want to miss, espeically if your organization uses Oracle GoldenGate for any architecture.

Additionally, the great guys who run the Georgia Oracle User Group (GaOUG) have done some amazing things since the planning of Tech Days 17 started. Just getting the key note speaker was a great addition to the already packed schedule of talks. This year, the keynote speaker is Maria Colgan, Master Product Manager for Oracle. She will be sharing some new and exciting items related to the Oracle Database and the direction Oracle is taking with new and exciting products.

GaOUG will also have dozens of Oracle ACE’s and ACE Director’s talking about topics accross multiple track (Database Development, Big Data, Applications, Middleteir). As an added bouns this year, GaOUG has added a half day Cloud track where you can learn all the items needed for your future Cloud deployments.

Hope to see everyone at both of these events, especially GaOUG in the coming months!

If you want to learn more about GaOUG Tech Days and the other impressive speakers, check out the blog hop posts below! What is a blog hop? It’s a group of bloggers who all get together to blog on a similar topic, giving you a lot of useful information from different perspectives, but in one stream. Enjoy your “hop” between blog posts and register for GaOUG Tech Days today!

Stewart Bryson
, RedPill Analytics
Jim Czuprynski, OnX Enterprise Solutions
Chris Lawless, Dbvisit Software
Danny Bryant, Accenture Enkitec Group
Eric Helmer, Mercury Technology Group


Filed under: GaOUG
Categories: DBA Blogs

Next Chapter … Time for a Change

Sat, 2017-01-21 20:06

It has been about three months since I’ve published a post. Well this time it has been a mix of work and decision making on my next chapter in my career that has kept me from posting. Hopefully, in the near future I will have more time to publish articles on topics I really want to discuss.

For the people close to me, many of you already know what this change is. I appreciate that you have kept it quite while all the details were worked out.

Before I get into what the next chapter of my career is, I have to say thanks to the management and team members at Accenture Enkitec Group (Enkitec/AEG). It has been a pleasure to work with everyone at Enkitec/AEG over the last couple of years. You truely are a great group of individuals and I will miss working daily with many of you. AEG is such a brain trust of people, it is almost hard to leave! I know that this will continue to be the trend at AEG.

Now what is the next chapter?

As of late January 2017, I have decided to leave Enkitec/AEG in pursuit of an opportunity that I feel is a good mix of my technical skills and allow me to grow in a challenging direction. Come Feburary 6th, 2017, I will be starting my new role as Senior Principal Product Manager on the GoldenGate team at Oracle. This position will allow me to work with a technology I’m very interested in and help shape the path forward for it. After all we know “cloud” is the next best thing right? How are you getting your data into or out of that “cloud”? Well, I will be part of the team that will help provide a path to do that. I’ll have to keep you posted on the technology as it evolves.

Now that you know where I’m going, just a few house keeping items to take care of. I’ve already said thanks to my friends at Enkitec/AEG. Without your support on many fronts, I wouldn’t be where I’m at as I proceed on this new chapter. Again, I greatly appreciate it.

For the community as a whole, many of you know that I’m an ACE Director (ACED) or at least was an ACED … LOL. Well, just like many of former ACEDs, when you go to Oracle you have to give it up. So, as of January 20, 2017, I resigned my ACED status and now listed as an ACE Alumni.

Blog site! I plan on keeping dbasolved.com up and running. I will be posting more article on GoldenGate here after starting with Oracle. So keep checking back to see if I’ve posted anything new. After all, GoldenGate is starting to become a hot topic!

I hope you will join me in my excitement on this new chapter of my career with Oracle and the GoldenGate team! I look forward to seeing many of you out and about within the community as I take on this new chapter.

Enjoy!

about.me:http://about.me/dbasolved


Filed under: Golden Gate
Categories: DBA Blogs

Pages