Feed aggregator

#GoldenGate Microservices (2 of 5) … Administration Service

DBASolved - 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:


Filed under: Golden Gate
Categories: DBA Blogs

Simple password encryption package to demonstrate how

Learn DB Concepts with me... - Tue, 2017-09-12 11:51
rem -----------------------------------------------------------------------
rem Purpose:   Simple password encryption package to demonstrate how
rem                  values can be encrypted and decrypted using Oracle's
rem                  DBMS Obfuscation Toolkit
rem Note:        Connect to SYS AS SYSDBA and run ?/rdbms/admin/catobtk.sql
rem Author:     Frank Naude, Oracle FAQ
rem -----------------------------------------------------------------------

---- create table to store encrypted data

-- Unable to render TABLE DDL for object ATOORPU.USERS_INFO with DBMS_METADATA attempting internal generator.


   function encrypt(i_password varchar2) return varchar2;
   function decrypt(i_password varchar2) return varchar2;
show errors


  -- key must be exactly 8 bytes long
  c_encrypt_key varchar2(8) := 'key45678';

  function encrypt (i_password varchar2) return varchar2 is
    v_encrypted_val varchar2(38);
    v_data          varchar2(38);
     -- Input data must have a length divisible by eight
     v_data := RPAD(i_password,(TRUNC(LENGTH(i_password)/8)+1)*8,CHR(0));

        input_string     => v_data,
        key_string       => c_encrypt_key,
        encrypted_string => v_encrypted_val);
     return v_encrypted_val;
  end encrypt;

  function decrypt (i_password varchar2) return varchar2 is
    v_decrypted_val varchar2(38);
        input_string     => i_password,
        key_string       => c_encrypt_key,
        decrypted_string => v_decrypted_val);
     return v_decrypted_val;
  end decrypt;

show errors

-- Test if it is working...

select password.encrypt('PASSWORD1') from dual;
select password.decrypt(app_password.encrypt('PASSWORD1')) from dual;
select password.encrypt('PSW2') from dual;
select password.decrypt(app_password.encrypt('PSW2')) from dual;

--- Insert encrypted Password ---

insert into USERS_INFO values ('redddy',( select password.encrypt('REDDY1') from dual) );
select password.decrypt((pass)) from USERS_INFO where USERNAME='redddy';

Categories: DBA Blogs

Log Buffer #521: A Carnival of the Vanities for DBAs

Pythian Group - Tue, 2017-09-12 11:36

While cloud technologies are roaring ahead in full force; the traditional RDBMS like Oracle, Microsoft SQL Server and MySQL are adapting pretty fast. This Log Buffer Edition covers blogs related to that and more.


Oracle JET Simple Table with Fake JSON Server

Every time any page is requested from your website by a human or another program or an automated bot, the event is tracked in a log file that is stored on the web server.

Gitora 2 enabled developers to manage database objects that support the CREATE OR REPLACE command, namely PACKAGES, PROCEDURES, FUNCTIONS, TRIGGERS, VIEWS, SYNONYMS and TYPES in a Git repository.

Oracle just released its first REST JDBC driver on OTN, in conjunction with the 17.3.0 Oracle REST Data Services Beta release.

When you are restrained in the JRE that you can use with SQLcl, you can embed your own in the sqlcl directory tree.

SQL Server:

Understanding Azure Data Factory – A Cloud Based Integration Service

The Shortcomings of Predictive Accuracy

Setting Variables in Calling T-SQL Code While Using sp_executesql

Azure DWH part 15: PolyBase and Azure Data Lake

Creating Basic Indexes on the Stack Overflow Public Database


Heads Up: The List of Replication Defaults That Have Changed in 8.0.2

IO-bound table scan performance for MyRocks, InnoDB and TokuDB

MyRocks Experimental Now Available with Percona Server for MySQL 5.7.19-17

Timing load & index for sysbench tables

Automatic Partition Maintenance in MariaDB

Categories: DBA Blogs

Benefits of Dashboards for IT

Nilesh Jethwa - Tue, 2017-09-12 09:54

The process of examining sets of data using specialized computer systems is called data analytics or data analysis. These computer systems make data easier to interpret by transforming, arranging, and modeling it to form patterns.

Data analytics tools guide businesspeople in coming up with better business decisions. Researchers and scientists also use these tools to evaluate scientific hypotheses, theories, and models.

Real-time report of data about the performance of a company, a specific department, a project, or group of employees can be accessed through a so-called data analytics dashboard. This is an information management tool, which monitors a group or a company’s metrics, key data points, and key performance indicators (KPI).

A dashboard can be customized according to a department or a company’s needs. It connects to your attachments, services, files, and Application Program Interface (API).

IT Management Dashboards

Some of the available dashboards for IT include the following:


Read more at http://www.infocaptor.com/dashboard/data-analytics-and-benefits-of-dashboards-for-it

Oracle Advanced Queues dequeue throughput

Tom Kyte - Tue, 2017-09-12 09:46
I am a developer, not a DBA, so know just enough about this to be dangerous. I have a setup a queue using the fairly standard scripts that are on multiple sites. I have used this one: http://www.oracle-developer.net/display.php?id=411 The trouble s...
Categories: DBA Blogs

Update a rows in a table with data from other table with only table name and primary key.

Tom Kyte - Tue, 2017-09-12 09:46
I'm trying to restore a data from a backup data with some special condition for rows. Example: Today database in DB1: <code>City ID Name location type 1 A [SDO.geom] 1 2 B [SDO.geom] 2 District ID Name At...
Categories: DBA Blogs

ORA-24263: Certificate of the remote server does not match the target address.

Tom Kyte - Tue, 2017-09-12 09:46
I encountered ORA-24263 when migrating from Oracle Database 11g to This error is thrown when using UTL_HTTP to access a site via HTTPS, and that site is a multi-server domain (as is common in today's cloud based world). I no longer have...
Categories: DBA Blogs

PL/SQL - Array collection of Records

Tom Kyte - Tue, 2017-09-12 09:46
Hi Tom, I am a regular visitor of your site and I love it. Every time I visit this site, I learn new things. Here is my problem. I tried using a collection(PL/SQL Tables) of Records in Oracle 8i but later came to know that ...
Categories: DBA Blogs

Pro*C procedure call taking longer time

Tom Kyte - Tue, 2017-09-12 09:46
I have below code in pro*c EXEC SQL CALL SP_INTL_BATCH(:l_wrapper, :l_func, :p_env_data, :l_paramstr, :l_user,:l_error); This simple code taking 12 to 13 second to execute and move to next line , while if i normally execute store procedure from...
Categories: DBA Blogs

DB Link Intermittent Failures

Tom Kyte - Tue, 2017-09-12 09:46
Hi Tom We have a DB Link to a database run by an external institution. Some days we can run our import/export processes just fine through the DB Link to the external database. On other days it will go through periods where it just seems to cut...
Categories: DBA Blogs

#GoldenGate Microservices (1 of 5) … ServiceManager

DBASolved - 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.


Filed under: Golden Gate
Categories: DBA Blogs

Oracle JET List Implementation based on WorkBetter Alta UI

Andrejus Baranovski - Mon, 2017-09-11 14:04
During weekend I was playing with JET WorkBetter sample app. I thought it would be nice to extract People list UI into my own app - so that it will be easy to reuse this UI pattern in our own JET applications. I succeeded to achieve my goal and would like to share WorkBetter Alta UI list sample with you.

This is how my own JET list UI looks like, based on sample app:

Header block is implemented in separate div, this contains title and toolbar for buttons. List content is rendered out of template located in its own div:

Template renders JET list component. List in turn is based based on item template:

Item template defines list row content and structure - through set of JET and custom CSS styles. Data attributes are referenced directly from template structure:

For this sample I'm using basic set of mock data defined in JS module, but obviously it can fetch data from REST service too:

Set of custom styles (created based on WorkBetter example) is located in override.css file within JET application structure:

Sample JET list application can be downloaded from GitHub - jetlistapp.

To build this application, I was using JET CLI commands. Especially useful I found options to strip application leaving only sources and then to restore JET environment - this helps to share code.

Here is the sequence of commands how I was using JET CLI:

ojet create jetlistapp --template=navdrawer (creates JET application)

ojet serve (runs JET application)

ojet strip (removes all files except your sources)

ojet restore (brings back JET environment, after application was stripped)

ojet serve (you can run application again, after it was restored)

Benefit of Dashboard Reporting for Government Operations

Nilesh Jethwa - Mon, 2017-09-11 12:45

Dashboard reporting has never been more important to the government. Considering the humungous streams of data collected through government agencies and programs, the challenge is how to make sense of these data in a way that they will benefit the organization and perhaps save large amounts of money as a result. The use of this type of reporting has been exalted by the US.

In the US

The US administration flaunted the advantages of using dashboards during the presidency of Barack Obama. They said that using a dashboard is an effective way of collating and filtering data so that these data become useful to decision makers. They credited the dashboard for being able to make them see better the implications of data and act on them appropriately.

One example cited by the government is how a dashboard helped them see the status of their investments, particular in pursuing the advance of technology.

The claim from the administration of Obama was that they were able to make better decisions using the data presented by the dashboard. According to them, this led to billions of dollars in savings and cutting delivery time for technological projects.

The US Congress has communicated a positive sentiment on the matter of using a government dashboard for federal decision-making and operations. It expressed interest in increasing the use of transparency tools, such as dashboards, across federal spending programs.

It is expected that more efforts will be exerted towards this goal and the use of dashboards may even be continued to be implemented after Obama relinquishes his office.

Other governments

Read more at http://www.infocaptor.com/dashboard/dashboard-reporting-for-government-and-how-it-can-benefit-government-operations

Sending Emails from Visual Builder Cloud Service

Shay Shmeltzer - Mon, 2017-09-11 12:23

Sending emails as a result of some changes to data is a common requirement we've been hearing from customers of Oracle Visual Builder Cloud Service (VBCS). In previous versions we already added a function that allows you to fire up the client email software from your app. In the new version we rolled out a couple of weeks ago we added a new function that can manage the whole email processing inside VBCS - on the backend/server/cloud side.

When you define a new trigger on a business object you now have the option to add "send email notification" step to your logic flow. 

When you are defining this, you'll be able to pick or define a template for your email. The email template can have parameters to increase reusability. These parameters can then have their value set from expressions that can include values of fields from your objects.

Here is a complete demo video that shows you how to add an email notification to an event on your business object:

Categories: Development

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

DBASolved - 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!


Filed under: Golden Gate
Categories: DBA Blogs

Few Steps to use EMC – SAN (LUNs) in Oracle Solaris – Part 02 Enable Device Multipathing

Online Apps DBA - Mon, 2017-09-11 06:24

Note: Enabling Device Multipathing requires a reboot. First, In order to enable Multipathing on OS level, Check Multi Path Utility package is installed. If Not, You need to install it. # pkg install system/storage/multipath-utilities Enable Multipathing Click Here to Continue : Few Steps to use EMC - SAN (LUNs) in Oracle Solaris - Part 03 […]

The post Few Steps to use EMC – SAN (LUNs) in Oracle Solaris – Part 02 Enable Device Multipathing appeared first on Oracle Trainings for Apps & Fusion DBA.

Categories: APPS Blogs

Few Steps to use EMC – SAN (LUNs) in Oracle Solaris – Part 01 Unisphere Host Agent?

Online Apps DBA - Mon, 2017-09-11 05:59

Step # 1 : Installation of Unisphere Host Agent. Download and Install the Package, as per OS Version e.g. HostAgent-Solaris-32-sparc-en_US- # cd /var/share/pkg/repositories # pkgadd -d ./HostAgent-Solaris-32-sparc-en_US- Make sure that the required package is installed successfully. Step # 2: Add the VNX Storage Servers in the /etc/hosts file. Step # 3: Add the environment specific […]

The post Few Steps to use EMC – SAN (LUNs) in Oracle Solaris – Part 01 Unisphere Host Agent? appeared first on Oracle Trainings for Apps & Fusion DBA.

Categories: APPS Blogs

fetch the latest total value

Tom Kyte - Sun, 2017-09-10 21:06
Hi, We want to fetch the latest total value for emp id = 2 but its summing total_value for all the rows for emp_id = 2. we want the result(total_value) only for the latest row of emp_id = 2. the statements and query are shown as below, cre...
Categories: DBA Blogs

Creation of Composite sub-partitions on multiple columns using template

Tom Kyte - Sun, 2017-09-10 21:06
Hi, Can we create Composite sub-partitions on multiple columns using template Example CREATE TABLE sgs.part_test ( order_date_time SYSTIMESTAMP, modulo_store_id NUMBER, recurring_flag CHAR (1) ) PARTITION BY RANGE (orde...
Categories: DBA Blogs

Why is there a limit on DBMS_OUTPUT?

Tom Kyte - Sun, 2017-09-10 21:06
I always run into an error that the dbms output exceeds 2000 and I can increase to max of 1000000. My question is, why is there a limit on this? I have gigs of space, why does oracle have to be so stingy with the output log?
Categories: DBA Blogs


Subscribe to Oracle FAQ aggregator