Feed aggregator

Leveraging "On Field Value Changes" Event in Visual Builder Cloud Service - Redone

Shay Shmeltzer - Tue, 2018-05-15 16:08

With the new Oracle Visual Builder Cloud Service (VBCS) released this month, some of my past how-to's that shows tricks in VBCS are no longer valid/needed.

The direct access we provide to both REST services and the UI components in your application make things that in the past required code or hacking much simpler.

Here is one example - reacting to value change events on fields and modifying other UI components based on them.

Input component have a "value" event that you can hook into and provide an action chain that will be executed when the value change.

In the video below you see for example how I can use a value selected in a drop down list to control whether other components on the page are shown or hidden.

To do this, you define a page variable that you can change in the "value" event. You can then rely on that page variable to control another component behavior.

As you can see - no coding needed - just drag and drop your way to create the functionality.

action chain

 

 

Categories: Development

Enabling Automatic EBS Application Tier Failover Between Physical Nodes on Oracle Solaris Clusters

Steven Chan - Tue, 2018-05-15 15:28

This is a long-overdue tip of the hat to my colleagues in the Oracle Solaris group. I recently learned about an article they posted a couple of years ago about E-Business Suite 12.2 running on Oracle Solaris Cluster:

It is possible to install an EBS primary application tier and the associated WebLogic Administration Server on a logical host using Oracle Solaris Clusters. If the physical node hosting these EBS services fail, then Oracle Solaris Cluster will automatically failover to another physical node in the cluster.

This is very cool! In a traditional EBS multinode environment, any user sessions on an affected failed node that were in-flight (meaning, in the middle of a transaction) would be lost. Users would need to redo any transactions that were not saved when their node when down. Deploying EBS on Oracle Solaris Clusters allow for the failover without any impact to those in-flight transactions.

If you're already running EBS on Solaris, you should definitely monitor this blog.

Related Articles

Categories: APPS Blogs

Configuring WebLogic Server 12.2.1.3 Diagnostics Framework policies and actions

Yann Neuhaus - Tue, 2018-05-15 09:28

Configure a Policy-action (new name for watch-notification) to send a JMX notification when the monitored WebLogic Server is having stuck threads or high memory usage. We will use a simple JMX notification listener program which can process WLDF JMX notifications. In this case, it will simply print the contents of the notification.
For simplicity, we will have only two servers in the domain, AdminServer (admin-server) and Server1 (managed-server). We will configure WLDF on the Server1 to send a JMX notification when the Heap Free of the managed-server Server1 (actually, any server it is targeted to within the domain) is less than 20% or as soon as there is a Stuck thread.
We will use WebLogic Server Administration Console to configure WLDF. It can also be done with WLST. Console provides a nice feature to Create Repeatable Configuration Scripts, which can be handy for building such scripts. Configuration steps for this case consist of:
1. Create a Diagnostic Module.
2. Enable periodic metrics collection in the Diagnostic module.
3. Create a JMX notification type.
4. Create a policy to detect if the WebLogic Server is having stuck threads
5. Create a policy to detect high memory usage on the WebLogic Server
6. Target the Diagnostic module to the WebLogic Server server1
We will go over these steps and see how to configure WLDF using Console for this task.

1. Create a Diagnostic Module.

a) Log into Console and acquire Edit Lock so we can add new configuration to WebLogic Server.
b) From the left navigation tree, open the Diagnostics node and click on Diagnostic Modules. Console will show a table of existing Diagnostic modules within the domain. Click the New button to create a new diagnostic module. Call it myWLDF. Click OK to create the module. At this point, we have an empty myWLDF diagnostic module.

2. Enable periodic metrics collection in the Diagnostic module.

a) Click on the myWLDF module link in the table of Diagnostics modules.
b) Click on Collected Metrics sub-tab under Configuration tab.
c) Check the Enabled checkbox and set the Sampling Period to 10000 (10 seconds). Click Save.

3. Create a JMX notification type.

a) Configuring a policy/actions (Watch and Notifications in earlier versions) has two aspects. The first aspect is a policy (watch rule) which specifies the condition that WLDF will check. The second aspect is the set of actions (notifications) that will be sent when the rule condition is met. Console provides configuration assistants to make the configuration task easier. To create an action type:
b) Click Policies and Actions sub-tab under Configuration tab.
On the Actions sub-tab, click New in the Actions table.
c) Select “JMX Notification” for the notification type from the drop down list and click Next.
d) Give a name to the notification type (myJMX)
e) Keep the Notification Type to its default value
f) Check the Enable Notification checkbox and click OK to create the notification type.

4. Create a policy to detect servers having stuck threads

Now, we will create the policy rule based on runtime mbean data. Specifically, we will use the StuckThreadCount attribute on the WorkManagerRuntime mbeans. For each server within the domain, there is a WorkManagerRuntime mbean in the domain runtime mbean server. The StuckThreadCount attribute reflects the current number of stuck thread on the server. We will configure a rule which will fire as soon one server in the targets list is having a stuck thread.
a) Click on the Policies sub-tab -> Configuration. Click New in the Policies table.
b) Set Policy Name to WatchServerStuckThread. Select Collected Metrics for Policy Type, check Enabled checkbox and click Next.
c) Set the Policy Expression as below and Click Next:

wls.runtime.query('com.bea:Type=WorkManagerRuntime,*','StuckThreadCount').stream().anyMatch( x -> x > 0 )

Note that the syntax of Policy Expressions has changed from the previous WebLogic Versions. Starting from this version, the policy expression is to be provided in Java Expression Language (EL).

d) Keep The Frequency to “Every N Seconds” and Click Next
e) Set the Repeat parameter to 5 and click Next
f) In this wizard keep the default and click Next
g) In the diagnostic Actions part, in the available actions, select the myJMX created earlier and move it to the “chosen” actions.
h) Click Finish

5. Create a policy to detect high memory usage on the WebLogic Server

Now, we will create the policy rule based on runtime mbean data. Specifically, we will use the StuckThreadCount attribute on the WorkManagerRuntime mbeans. For each server within the domain, there is a WorkManagerRuntime mbean in the domain runtime mbean server. The StuckThreadCount attribute reflects the current number of stuck thread on the server. We will configure a rule which will fire as soon one server in the targets list is having a stuck thread.
a) Click on the Policies sub-tab -> Configuration. Click New in the Policies table.
b) Set Policy Name to WatchServerStuckThread. Select Collected Metrics for Policy Type, check Enabled checkbox and click Next.
c) Set the Policy Expression as below and Click Next:

wls.runtime.serverRuntime.JVMRuntime.heapFreePercent < 20

d) Keep The Frequency to “Every N Seconds” and Click Next
e) Set the Repeat parameter to 5 and click Next
f) In this wizard keep the default and click Next
g) In the diagnostic Actions part, in the available actions, select the myJMX created earlier and move it to the “chosen” actions.
h) Click Finish
6. Target the Diagnostic module to the WebLogic Server server1
a) Click on the Targets TAB
b) In the list of possible Targets, select the Server1 and click on Save
c) Activate Changes

Receiving Notifications

WLDF sends a JMX notification on a specific WLDF runtime mbean, whose ObjectName is of the form:
com.bea:Name=DiagnosticsJMXNotificationSource,ServerRuntime=$SERVER,Type=WLDFWatchJMXNotificationRuntime,WLDFRuntime=WLDFRuntime,WLDFWatchNotificationRuntime=WatchNotification
where $SERVER is the name of the WebLogic Server instance. For our case (Server1), it is:
com.bea:Name=DiagnosticsJMXNotificationSource,ServerRuntime=Server1,Type=WLDFWatchJMXNotificationRuntime,WLDFRuntime=WLDFRuntime,WLDFWatchNotificationRuntime=WatchNotification
By registering for JMX notifications on this mbean, a client program can listen to generated notifications.
We will use the JMXWatchNotificationListener.java provided in the Oracle WLDF documentation (see references). It is a simple notification listener for WLDF JMX notifications. It simply prints the contents of received notification, but can be easily adapted to perform other actions.

A sample Java code of such listener can be downloaded from the Oracle WebLogic Diagnostic Framework documentation (here)

To run it for this blog sample run:

java JMXWatchNotificationListener vm01 7006 weblogic Welcome1 Server1

Note: The WebLogic Managed Server named Server1 is listening on port 7006.

Sample WLDF message sent when the WebLogic Server is having Stuck Threads

Notification name: myJMXNotif called. Count= 79.
Watch severity: Notice
Watch time: Apr 24, 2018 12:08:35 PM CEST
Watch ServerName: Server1
Watch RuleType: Harvester
Watch Rule: wls.runtime.query('com.bea:Type=WorkManagerRuntime,*','StuckThreadCount').stream().anyMatch( x -> x > 0 )
Watch Name: WatchServerStuckThread
Watch DomainName: wldf_domain
Watch AlarmType: None
Watch AlarmResetPeriod: 60000

Sample WLDF message sent when the WebLogic Server heap free becomes low (less than 20%)

Notification name: myJMXNotif called. Count= 114.
Watch severity: Notice
Watch time: Apr 24, 2018 12:11:45 PM CEST
Watch ServerName: Server1
Watch RuleType: Harvester
Watch Rule: wls.runtime.serverRuntime.JVMRuntime.heapFreePercent < 20
Watch Name: WatchServerLowHeapFreePercent
Watch DomainName: wldf_domain
Watch AlarmType: None
Watch AlarmResetPeriod: 60000

 

Cet article Configuring WebLogic Server 12.2.1.3 Diagnostics Framework policies and actions est apparu en premier sur Blog dbi services.

PDB RMAN backups available after plugging in on a new CDB with Oracle 18c

Yann Neuhaus - Tue, 2018-05-15 08:53

With Oracle 18c, it is possible to use PDB rman backups created on the source CDB (they are called PREPLUGIN backups) when the PDB has been relocated to a target CDB.

In my environment, my original CDB is DB18, with the PDB named pdborig. The target CDB is PSI18.

The first step consist in running a rman backup on pdborig:

oracle@localhost:/u00/app/oracle/ [DB18] rman target sys/manager@pdborig
Recovery Manager: Release 18.0.0.0.0 - Production on Tue May 15 10:57:38 2018
Version 18.1.0.0.0
Copyright (c) 1982, 2018, Oracle and/or its affiliates.  All rights reserved.

connected to target database: DB18:PDBORIG (DBID=3031125269)

RMAN> backup pluggable database pdborig plus archivelog;

Starting backup at 15-MAY-2018 10:57:55
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=80 device type=DISK
skipping archived logs when connected to a PDB
backup cancelled because there are no files to backup
Finished backup at 15-MAY-2018 10:57:56

Starting backup at 15-MAY-2018 10:57:56
using channel ORA_DISK_1
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00029 name=/u00/app/oracle/oradata/DB18/pdborig/undotbs01.dbf
input datafile file number=00027 name=/u00/app/oracle/oradata/DB18/pdborig/system01.dbf
input datafile file number=00028 name=/u00/app/oracle/oradata/DB18/pdborig/sysaux01.dbf
input datafile file number=00030 name=/u00/app/oracle/oradata/DB18/pdborig/users01.dbf
channel ORA_DISK_1: starting piece 1 at 15-MAY-2018 10:57:56
channel ORA_DISK_1: finished piece 1 at 15-MAY-2018 10:57:59
piece handle=/u00/app/oracle/fast_recovery_area/DB18/DB18/
6C3BAD3B7C73354AE0530100007F9AD9/backupset/
2018_05_15/o1_mf_nnndf_TAG20180515T105756_fho88nn0_.bkp 
tag=TAG20180515T105756 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:03
Finished backup at 15-MAY-2018 10:57:59

Starting backup at 15-MAY-2018 10:57:59
using channel ORA_DISK_1
skipping archived logs when connected to a PDB
backup cancelled because there are no files to backup
Finished backup at 15-MAY-2018 10:57:59

Then we have to export the RMAN backup metadata for the non CDB into its dictionary using dbms_pdb.exportrmanbackup()

oracle@localhost:/u00/app/oracle/ [DB18] sqlplus sys/manager@pdborig as sysdba

SQL*Plus: Release 18.0.0.0.0 Production on Tue May 15 11:00:38 2018
Version 18.1.0.0.0

Copyright (c) 1982, 2017, Oracle.  All rights reserved.

Connected to:
Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production
Version 18.1.0.0.0

SQL> execute dbms_pdb.exportrmanbackup();

PL/SQL procedure successfully completed.

As my environment is configured with TDE, in order to unplug the pdborig, we need to export the master key of the container database otherwise we will receive the following error message:

SQL> alter pluggable database pdborig 
unplug into '/home/oracle/pdborig.xml';
alter pluggable database pdborig unplug into '/home/oracle/pdborig.xml'
*
ERROR at line 1:
ORA-46680: master keys of the container database must be exported

We export the master key:

SQL> alter session set container=PDBORIG;
Session altered

SQL> administer key management 
  2  export encryption keys with secret "manager_cdb" 
  3  to '/home/oracle/pdborig.p12'
  4  identified by manager_cdb;

keystore altered.

SQL> alter pluggable database PDBORIG close immediate;

Pluggable database altered.

SQL> alter pluggable database PDBORIG unplug into '/home/oracle/pdborig.xml';

Pluggable database altered.

Finallly on the target CDB named PSI18, we first have to create a wallet and 
open the keystore. Just remember you have to define wallet_root and 
tde_configuration in your CDB environment in order to use TDE:


SQL> show parameter wallet

NAME		       TYPE	    VALUE
-------------------- ----------- -------------------------------------
wallet_root	       string	 /u00/app/oracle/admin/PSI18/walletcdb

SQL> alter system set tde_configuration="keystore_configuration=file";
System altered.

We create and open the keystore on the target CDB and we import the master key:

SQL> administer key management create keystore identified by manager_cdb;

keystore altered.

SQL> administer key management set keystore open 
identified by manager_cdb container=all;

keystore altered.

SQL> alter session set container=pdb1;

Session altered.

SQL> administer key management import encryption keys 
     with secret "manager_cdb" from '/home/oracle/pdborig.p12'
     identified by "manager_cdb" with backup;

keystore altered.

We create pdbnew on the target CDB using pdborig.xml:

SQL> create pluggable database pdbnew using '/home/oracle/pdborig.xml'
file_name_convert=
('/u00/app/oracle/oradata/DB18/pdborig','/home/oracle/oradata/PSI18/pdbnew');

Pluggable database created.

We open the pluggable database pdbnew:

SQL> alter pluggable database pdbnew open;

Pluggable database altered.

SQL> show pdbs

    CON_ID CON_NAME			  OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
	 2 PDB$SEED			  READ ONLY  NO
	 4 PDBNEW			  READ WRITE NO

And now the non CDB PDBNEW has been plugged in the target CDB, we can ask if the rman backups are visible because we had exported the rman metadata backup. To visualize that we have to use the preplugin clause:

RMAN> list preplugin backup of pluggable database pdbnew;


List of Backup Sets
===================


BS Key  Type LV Size       Device Type Elapsed Time Completion Time     
------- ---- -- ---------- ----------- ------------ --------------------
9       Full    463.15M    DISK        00:00:01     15-MAY-2018 10:56:51
        BP Key: 9   Status: AVAILABLE  Compressed: NO  Tag: TAG20180515T105650
        Piece Name: /u00/app/oracle/fast_recovery_area/DB18/DB18/
6C3BAD3B7C73354AE0530100007F9AD9/backupset/2018_05_15/
o1_mf_nnndf_TAG20180515T105650_fho86ltx_.bkp
  List of Datafiles in backup set 9
  File LV Type Ckp SCN    Ckp Time             Abs Fuz SCN Sparse Name
  ---- -- ---- ---------- -------------------- ----------- ------ ----
  20 Full 1081248 15-MAY-2018 10:56 /home/oracle/oradata/PSI18/pdbnew/system01.dbf
  21 Full 1081248 15-MAY-2018 10:56 /home/oracle/oradata/PSI18/pdbnew/sysaux01.dbf
  22 Full 1081248 15-MAY-2018 10:56 /home/oracle/oradata/PSI18/pdbnew/undotbs01.dbf
  23 Full 1081248 15-MAY-2018 10:56 /home/oracle/oradata/PSI18/pdbnew/users01.dbf

BS Key  Type LV Size       Device Type Elapsed Time Completion Time     
------- ---- -- ---------- ----------- ------------ --------------------
10      Full    463.15M    DISK        00:00:01     15-MAY-2018 10:57:57
        BP Key: 10   Status: AVAILABLE  Compressed: NO  Tag: TAG20180515T105756
        Piece Name: /u00/app/oracle/fast_recovery_area/DB18/DB18/6C3BAD3B7C73354AE0530100007F9AD9/backupset/2018_05_15/o1_mf_nnndf_TAG20180515T105756_fho88nn0_.bkp
  List of Datafiles in backup set 10
  File LV Type Ckp SCN    Ckp Time             Abs Fuz SCN Sparse Name
  ---- -- ---- ---------- -------------------- ----------- ------ ----
  20 Full 1081326 15-MAY-2018 10:57 /home/oracle/oradata/PSI18/pdbnew/system01.dbf
  21 Full 1081326 15-MAY-2018 10:57 /home/oracle/oradata/PSI18/pdbnew/sysaux01.dbf
  22 Full 1081326 15-MAY-2018 10:57 /home/oracle/oradata/PSI18/pdbnew/undotbs01.dbf
  23 Full 1081326 15-MAY-2018 10:57 /home/oracle/oradata/PSI18/pdbnew/users01.dbf

We can also display the archive logs preplugin backups:

RMAN> list preplugin archivelog all;

List of Archived Log Copies for database with db_unique_name PSI18
=====================================================================

Key     Thrd Seq     S Low Time            
------- ---- ------- - --------------------
.....

6       1    16      A 15-MAY-2018 10:08:53
/u00/app/oracle/fast_recovery_area/archivelog/2018_05_15/o1_mf_1_16_fho5r944_.a
...

So let’s see if we can make a restore and recover test:

We delete the user01.dbf datafile:

oracle@localhost:/u00/app/oracle/ [PSI18] rm /home/oracle/oradata/PSI18/pdbnew/users01.dbf

oracle@localhost:/u00/app/oracle/oradata/DB18/pdbseed/ [PSI18] sq

SQL*Plus: Release 18.0.0.0.0 Production on Tue May 15 11:20:47 2018
Version 18.1.0.0.0

Copyright (c) 1982, 2017, Oracle.  All rights reserved.


Connected to:
Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production
Version 18.1.0.0.0

SQL> alter pluggable database pdbnew close;

Pluggable database altered.

SQL> alter pluggable database pdbnew open;
alter pluggable database pdbnew open
*
ERROR at line 1:
ORA-01157: cannot identify/lock data file 23 - see DBWR trace file

Now we try to restore: we connect with rman to the target CDB and we set the PDB that needs to be restored with the command set preplugin container=pdbnew:

oracle@localhost:/u00/app/oracle/ [PSI18] rman target sys/manager@psi18

Recovery Manager: Release 18.0.0.0.0 - Production on Tue May 15 11:25:06 2018
Version 18.1.0.0.0

Copyright (c) 1982, 2018, Oracle and/or its affiliates.  All rights reserved.

connected to target database: PSI18 (DBID=3896993764)

RMAN> set preplugin container=pdbnew;

executing command: SET PREPLUGIN CONTAINER
using target database control file instead of recovery catalog

RMAN> list preplugin backup of pluggable database pdbnew;


List of Backup Sets
===================


BS Key  Type LV Size       Device Type Elapsed Time Completion Time     
------- ---- -- ---------- ----------- ------------ --------------------
9       Full    463.15M    DISK        00:00:01     15-MAY-2018 10:56:51
        BP Key: 9   Status: AVAILABLE  Compressed: NO  Tag: TAG20180515T105650
        Piece Name: /u00/app/oracle/fast_recovery_area/
/6C3BAD3B7C73354AE0530100007F9AD9/backupset/
2018_05_15/o1_mf_nnndf_TAG20180515T105650_fho86ltx_.bkp
  List of Datafiles in backup set 9
  Container ID: 4, PDB Name: PDBNEW
  File LV Type Ckp SCN    Ckp Time             Abs Fuz SCN Sparse Name
  ---- -- ---- ---------- -------------------- ----------- ------ ----
  20 Full 1081248 15-MAY-2018 10:56 /home/oracle/oradata/PSI18/pdbnew/system01.dbf
  21 Full 1081248 15-MAY-2018 10:56 /home/oracle/oradata/PSI18/pdbnew/sysaux01.dbf
  22 Full 1081248 15-MAY-2018 10:56 /home/oracle/oradata/PSI18/pdbnew/undotbs01.dbf
  23 Full 1081248 15-MAY-2018 10:56 /home/oracle/oradata/PSI18/pdbnew/users01.dbf

BS Key  Type LV Size       Device Type Elapsed Time Completion Time     
------- ---- -- ---------- ----------- ------------ --------------------
10      Full    463.15M    DISK        00:00:01     15-MAY-2018 10:57:57
        BP Key: 10   Status: AVAILABLE  Compressed: NO  Tag: TAG20180515T105756
        Piece Name: /u00/app/oracle/fast_recovery_area
/6C3BAD3B7C73354AE0530100007F9AD9/backupset/2018_05_15/
o1_mf_nnndf_TAG20180515T105756_fho88nn0_.bkp
  List of Datafiles in backup set 10
  Container ID: 4, PDB Name: PDBNEW
  File LV Type Ckp SCN    Ckp Time             Abs Fuz SCN Sparse Name
  ---- -- ---- ---------- -------------------- ----------- ------ ----
  20 Full 1081326 15-MAY-2018 10:57 /home/oracle/oradata/PSI18/pdbnew/system01.dbf
  21 Full 1081326 15-MAY-2018 10:57 /home/oracle/oradata/PSI18/pdbnew/sysaux01.dbf
  22 Full 1081326 15-MAY-2018 10:57 /home/oracle/oradata/PSI18/pdbnew/undotbs01.dbf
  23 Full 1081326 15-MAY-2018 10:57 /home/oracle/oradata/PSI18/pdbnew/users01.dbf

We run the restore command with the preplugin clause:

RMAN> restore pluggable database pdbnew from preplugin;

Starting restore at 15-MAY-2018 11:26:23
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=108 device type=DISK

channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_DISK_1: restoring datafile 00020 to 
/home/oracle/oradata/PSI18/pdbnew/system01.dbf
channel ORA_DISK_1: restoring datafile 00021 to 
/home/oracle/oradata/PSI18/pdbnew/sysaux01.dbf
channel ORA_DISK_1: restoring datafile 00022 to 
/home/oracle/oradata/PSI18/pdbnew/undotbs01.dbf
channel ORA_DISK_1: restoring datafile 00023 to 
/home/oracle/oradata/PSI18/pdbnew/users01.dbf
channel ORA_DISK_1: reading from backup piece /u00/app/oracle/fast_recovery_area/
DB18/DB18/6C3BAD3B7C73354AE0530100007F9AD9/backupset/2018_05_15/
o1_mf_nnndf_TAG20180515T105756_fho88nn0_.bkp
channel ORA_DISK_1: piece handle=/u00/app/oracle/fast_recovery_area/DB18/DB18/
6C3BAD3B7C73354AE0530100007F9AD9/backupset/2018_05_15/
o1_mf_nnndf_TAG20180515T105756_fho88nn0_.bkp tag=TAG20180515T105756
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:03
Finished restore at 15-MAY-2018 11:26:28

We run the recover command with the preplugin clause:

RMAN> recover pluggable database pdbnew from preplugin;

Starting recover at 15-MAY-2018 11:27:02
using channel ORA_DISK_1

starting media recovery

unable to find archived log
archived log thread=1 sequence=17
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 05/15/2018 11:27:03
RMAN-06054: media recovery requesting unknown archived log 
for thread 1 with sequence 17 and starting SCN of 1081326

We have to catalog the archive logs generated after the backup into the target CDB by issuing the catalog preplugin archivelog command :

RMAN> catalog preplugin archivelog '/u00/app/oracle/fast_recovery_area/
DB18/DB18/archivelog/2018_05_15/o1_mf_1_17_fhob69t7_.arc';

cataloged archived log
archived log file name=/u00/app/oracle/fast_recovery_area/DB18/DB18/
archivelog/2018_05_15/o1_mf_1_17_fhob69t7_.arc RECID=7 STAMP=0

Finally the recover command runs successfully:

RMAN> recover pluggable database pdbnew from preplugin;

Starting recover at 15-MAY-2018 11:32:25
using channel ORA_DISK_1

starting media recovery

archived log for thread 1 with sequence 17 is already on disk as file 
/u00/app/oracle/fast_recovery_area/DB18/DB18/archivelog/2018_05_15/
o1_mf_1_17_fhob69t7_.arc
media recovery complete, elapsed time: 00:00:00
Finished recover at 15-MAY-2018 11:32:26

We finish the recover and open the target PDB:

RMAN> recover pluggable database pdbnew;

Starting recover at 15-MAY-2018 11:33:10
using channel ORA_DISK_1

starting media recovery
media recovery complete, elapsed time: 00:00:00

Finished recover at 15-MAY-2018 11:33:10

RMAN> alter pluggable database pdbnew open;

Statement processed

RMAN> exit


Recovery Manager complete.

As far we can see, the target PDB has been successfully restored and recovered:

oracle@localhost:/u00/app/oracle/oradata/DB18// [PSI18] sq

SQL*Plus: Release 18.0.0.0.0 Production on Tue May 15 11:33:37 2018
Version 18.1.0.0.0

Copyright (c) 1982, 2017, Oracle.  All rights reserved.


Connected to:
Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production
Version 18.1.0.0.0

SQL> show pdbs

    CON_ID CON_NAME			  OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
	 2 PDB$SEED			  READ ONLY  NO
	 4 PDBNEW			  READ WRITE NO

The preplugin clause can be used on the target CDB with rman commands like restore, recover, crosscheck, list and delete.

This new feature helps to maintain the backup compliance after moving to a new target CDB.

 

Cet article PDB RMAN backups available after plugging in on a new CDB with Oracle 18c est apparu en premier sur Blog dbi services.

New Oracle Billing and Revenue Management Features Help Cloud, Telco Providers Monetize Emerging Services

Oracle Press Releases - Tue, 2018-05-15 07:00
Press Release
New Oracle Billing and Revenue Management Features Help Cloud, Telco Providers Monetize Emerging Services New capabilities empower communication service providers to deliver exceptional service to customers

TM FORUM, Nice, France—May 15, 2018

Helping customers capitalize on new digital communications services and revenue opportunities, Oracle today announced major new enhancements to Oracle Communications Billing and Revenue Management (BRM). With new operational user experience features, enhanced security capabilities and updated technology platform support, Oracle Communications BRM supports the rapid design and monetization of consumption and subscription based offerings across cloud, IoT, and future 5G services.

Oracle Communications BRM provides complete revenue management including the high volume, low latency, and convergent usage processing required by new digital communication services. With its Elastic Charging Engine technology, the offering is designed to support advanced charging models for today’s mobile, fixed and cable digital services and provide a foundation for IoT and future 5G services.

“This major release of Oracle Communications BRM underscores Oracle’s ongoing commitment to delivering powerful, scalable monetization solutions that enable our customers to fully capitalize on the digital revolution,” said Doug Suriano, senior vice president, general manager, Oracle Communications. “With this offering, service providers have a modern monetization platform to innovate, profit and grow as they evolve to support broadband technology innovations and deliver new services to market.”

Oracle Communications BRM was recently noted as a Leader in the IDC MarketScape: Worldwide Subscription Relationship Management (SRM) 2017 Vendor Assessment.

Modern Monetization for the Digital Era

In today’s competitive business environment, delivering a superior customer experience is more critical than ever. Oracle Communications Billing and Revenue Management’s Billing Care module enables CSPs to serve their customers through intuitive interfaces that provide real-time views of customer’s balance and allow easy access to all aspects of account history. CSPs and digital service providers can build customer loyalty by awarding non-currency assets such as movie downloads, gigabytes of storage or throughput, or access to games.

Real-time tracking of consumption enables notification to customers when they approach thresholds. Flexible options for invoice design and delivery create additional opportunities to personalize subscriber relationships. Oracle BRM 12.0 enhances these capabilities, empowering CSPs to leverage powerful, scalable monetization capabilities to accelerate customer success and time to market for digital services.

New capabilities include:

  • New unified functionality available in the modern, browser based Billing Care user interface:
    • Advanced customer and asset management with subscription group services
    • Corrective invoicing, credit profile management and sharing
    • SEPA Payments, account and bill unit level refunds, item and event level disputes
    • Collections management, write-off and recovery
  • Secure and documented Billing Care REST API
  • Enhanced security including use of Oracle Wallet
  • Updated core technology support

Oracle Communications BRM is part of Oracle’s complete monetization service portfolio, which also includes Oracle Monetization Cloud and Oracle Communications Network Charging and Control. With Oracle’s monetization solutions, customers can fuel disruptive innovation, brand differentiation, and business transformation with a service-, industry-, and business-model-agnostic real-time charging, billing, and settlement solution designed for an increasingly connected world.

1 IDC, “MarketScape: Worldwide Subscription Relationship Management 2017 Vendor Assessment”, Jordan Jewell and Eric Newmark, DC #US43172417, November 2017

Contact Info
Katie Barron
Oracle
+1.202.904.1138
katie.barron@oracle.com
Kristin Reeves
Blanc & Otus
+1.925.787.6744
kreeves@blancandotus.com
About Oracle Communications

Oracle Communications provides integrated communications and cloud solutions for Service Providers and Enterprises to accelerate their digital transformation journey in a communications-driven world from network evolution to digital business to customer experience. www.oracle.com/communications.

About Oracle

The Oracle Cloud offers complete SaaS application suites for ERP, HCM and CX, plus best-in-class database Platform as a Service (PaaS) and Infrastructure as a Service (IaaS) from data centers throughout the Americas, Europe and Asia. For more information about Oracle (NYSE:ORCL), please visit us at www.oracle.com.

Trademarks

Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.

Talk to a Press Contact

Katie Barron

  • +1.202.904.1138

Kristin Reeves

  • +1.925.787.6744

Partner Webcast – Autonomous Data Warehouse in the Cloud: Practical Use Case Guide

Today’s leading-edge organizations differentiate themselves through analytics to further their competitive advantage by extracting value from all their data sources. However, the velocity and...

We share our skills to maximize your revenue!
Categories: DBA Blogs

Generating Duplicate Rows

Tom Kyte - Tue, 2018-05-15 03:46
Hi I am new to oracle plsql and want advise on a Biz scenario: Biz want to run a shipping label report and each shipping has one record. They will choose particular shipping record and based on provided parameter they want to see number of labe...
Categories: DBA Blogs

Goldengate REPORTING P2

Michael Dinh - Mon, 2018-05-14 21:35

Previous post for Goldengate REPORTING

Goldengate reporting has to be the least implemented functionality until it is needed and often in hindsight.

Here is an example of what I would normally implement.

STATOPTIONS RESETREPORTSTATS
REPORT AT 00:01
REPORTROLLOVER AT 00:01
REPORTCOUNT EVERY 15 MINUTES, RATE
DISCARDROLLOVER AT 00:01 ON SUNDAY

If business only cares about monthly data, then would not make sense to collect daily nor would it make sense for business to request such.

Leading Analyst Firm: Oracle Continues Strong Cloud Growth

Oracle Press Releases - Mon, 2018-05-14 15:09
Press Release
Leading Analyst Firm: Oracle Continues Strong Cloud Growth New IDC report finds Oracle gained the most share out of all Enterprise Applications SaaS vendors and grew the fastest out of the top 10 PaaS vendors in the last two calendar years

Redwood Shores, Calif.—May 14, 2018

Oracle today announced that IDC has recognized the momentum and growth of Oracle Cloud. According to the IDC Public Cloud Services Tracker, April, 2018¹, Oracle gained the most share out of all Enterprise Applications SaaS vendors in CY’2016 as well as CY’2017. In addition, the same report found that Oracle grew the fastest out of the top 10 PaaS vendors in CY’2016 as well as CY’2017.

“Oracle Cloud is redefining how organizations modernize, innovate and compete,” said Thomas Kurian, president, product development, Oracle. “Regardless of where organizations want to start their cloud journeys, Oracle delivers complete and integrated cloud services that deliver faster innovation and business transformation. We believe that the results from the latest IDC Public Cloud Services Tracker further demonstrate the value Oracle Cloud provides.”

IDC’s Worldwide Semiannual Public Cloud Services Tracker® monitors public cloud services with frequent releases of semiannual revenue estimates. It tracks and details individual public cloud services providers’ historical business performance and forecasts market sizes five years into the future—across 53 geographies and up to 80 discrete market segments. In the report, Enterprise Applications SaaS refers to the IDC markets CRM, Enterprise Resource Management (including HCM, Financials, Procurement, Order Management, PPM, EAM), Engineering, SCM, Operations and Manufacturing Applications.

Oracle provides its customers with a unique advantage as it is the only company in the world to deliver a complete cloud portfolio, spanning Infrastructure as a Service (IaaS), Platform as a Service (PaaS) and Software as a Service (SaaS). Today, organizations in 195 countries and territories process more than 55 billion transactions a day through the Oracle Cloud.

To learn more about how organizations around the globe are rapidly adopting Oracle Cloud solutions, see: Organizations Worldwide Turn to Oracle Cloud to Fuel their Modernization Efforts

1 IDC’s Worldwide Semiannual Public Cloud Services Tracker®, 27 April, 2018 [Enterprise Applications SaaS refers to the IDC markets CRM, Enterprise Resource Management (including HCM, Financials, Procurement, Order Management, PPM, EAM), Engineering, SCM, Operations and Manufacturing Applications.]

Contact Info
Simon Jones
Oracle
+1.415.202.4574
s.jones@oracle.com
About Oracle

The Oracle Cloud offers complete SaaS application suites for ERP, HCM and CX, plus best-in-class database Platform as a Service (PaaS) and Infrastructure as a Service (IaaS) from data centers throughout the Americas, Europe and Asia. For more information about Oracle (NYSE:ORCL), please visit us at www.oracle.com.

Trademarks

Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.

Talk to a Press Contact

Simon Jones

  • +1.415.202.4574

Loading Tables with Oracle GoldenGate and REST APIs

DBASolved - Mon, 2018-05-14 12:11

With Oracle GoldenGate 12c (12.3.0.1.x), you can now quickly load empty target tables with data from your source database. You could always do this in previous releases of Oracle GoldenGate, but the process has now been simplified using REST APIs and some scripting know-how. In this post, I’m going to show you, high level, how you can use the REST APIs and a bit of scripting to do an initial load of a two table with a single command.

In previous releases of Oracle GoldenGate, a similar task could be done, but it required you to include the Oracle Database Export/Import data pumps or some other drawn out process. With this new process, you can effectively get around that and only need to use trail files to perform the initial load.

In this scenario, I have two table with a total of 14,000 records in them. This will be a small example of an initial load, but you should get the idea behind how this will work. This approach will also work for adding tables into an existing replication scheme.

The below architcture diagram illistrates how the architecture would look with an existing GoldenGate capture running and incorprating an File-Based Initial Load process to load a few tables.

Image 1:

This may look a bit confusing, but this is quite simple to understand. The red items are the GoldenGate extract, trails (local and remote), and the GoldenGate replicat. This is an existing replication stream. The GoldenGate extract is capturing from the source database, moving transactions to the local trail file (aa). Then the DistroService picks up/reads the local trail and ships the transactions across the GoldenGate Path to the ReceiverService. The Receiver Service then writes to the remote trail (ab) where the GoldenGate replicat processes the transactions into the target database. Pretty simple and this is doing a continuous replication of transactions.

Now, you want to just setup a few new tables, but do not want to take the day or two it would take to configure, export, import, apply and then catch up. Along the bottom, is the initial load path (green) using a File-Based approach to initially load tables. This process is what I’ve scripted out to using cURL and Shell scripts. Normally, you would spend time doing an export/import for the table(s) that you want to move to the target system after setting up the initial load extract.

Using Oracle GoldenGate Microservices architecture, this initial load process can be simplied and done very quickly. Below is a link to a script which I wrote to perform an File-Based Initial Load within Oracle GoldenGate Microservices.

FB_InitialLoad.sh <— Use at your own risk! This is only an example script of how this can be done.

What this script does, is creates the File-Based Initial Load process and populates the two tables I’ve identified in the target system.

As you run this script, everything I needed to build has been reduced down to functions that I can call when needed within the script. Granted this script if very simple but it orchatrates the whole initial load process for the tables I wanted. After the tables have been loaded, then they can be merged into the existing replication stream.

Enjoy!!!

Categories: DBA Blogs

DB Change from 12.1 to 12.2 RAC getting ORA-02297

Tom Kyte - Mon, 2018-05-14 09:26
We recently changed from a 12.1 Single Instance to a 12.2 Version running in a RAC environment with two nodes. Wa are now facing the problem that a PL/SQL procedure nearly takes factor 3 longer to run than on the single instance. Our Adminis...
Categories: DBA Blogs

Sorting and comparation alphanumeric

Tom Kyte - Mon, 2018-05-14 09:26
Hello Tom, We have configure the client this way: <code>SQL> select parameter, value from nls_session_parameters where parameter in ('NLS_COMP','NLS_SORT','NLS_LANGUAGE'); PARAMETER VALUE ------------------------------ -------------------...
Categories: DBA Blogs

SQL Query to remove duplicate values across columns

Tom Kyte - Mon, 2018-05-14 09:26
I have three field in the table say from_city,to_city and distance. <code> Table name: City_distance From_city to_city distance ---------------------------------------- A B 100 B A 100 C B 200 C A 300 E F 700 F E 700 </code> Here I ...
Categories: DBA Blogs

Logical Storage Structures\chained and migrated rows

Tom Kyte - Mon, 2018-05-14 09:26
if we have multiple datafiles of 32GB and there are fully utilized. Can chained and migrated rows occurs due to the maximum datafile utilization?
Categories: DBA Blogs

performance tunning for Sql query

Tom Kyte - Mon, 2018-05-14 09:26
hi Team, I am struggling in one of query tunning , below are details assoicated with , please analyse and recommend on it . <code> SELECT * FROM (SELECT /*+ INDEX(A INDX14_TABLE1) INDEX(B IDX51_TABLE2) */ * F...
Categories: DBA Blogs

Tables Access

Tom Kyte - Mon, 2018-05-14 09:26
In our Production database is has been decided to drop a tablespace because already a datafile was lost due to accidentally file was dropped at OS level with command rm -rf, somehow luckily there was not huge loss but some of index which were cre...
Categories: DBA Blogs

Connecting to Database.

Tom Kyte - Mon, 2018-05-14 09:26
Hi, I have two versions of Oracle Databses(12C,11G) installed on my personal computer running on Windows 8. When i execute below command its connecting to 12C instance. sqlplus system/welcome; i would like to know how can i connect to 11G instan...
Categories: DBA Blogs

Heineken Urban Polo Uses Oracle Cloud to Inject AI into the Sport of Kings

Oracle Press Releases - Mon, 2018-05-14 07:00
Press Release
Heineken Urban Polo Uses Oracle Cloud to Inject AI into the Sport of Kings Intelligent bot provides polo-and-music fans a modern digital experience

Redwood Shores, Calif.—May 14, 2018

Oracle today announced that Heineken Urban Polo is using Oracle Cloud Platform, including artificial intelligence (AI) and AI-powered intelligent bots, to create a unique and customized customer experience at its premier polo events throughout New Zealand.

Working with Oracle, Heineken Urban Polo has helped revolutionize the “Sport of Kings” through a digital concierge on today’s most popular social platforms, whilst including all the flagship event’s key information. Using a conversational bot accessed via Facebook Messenger, users are able to quickly and easily find directions, on-site activity times (parades, DJ sessions, bar locations, etc.), match times, polo rules, player details and more.

Oracle Intelligent Bots uses deep learning-based natural language understanding (NLU) to comprehend and determine intent of end-user conversations. It can then help companies, such as Heineken Urban Polo, process these conversations, integrate each with existing business application data, and automatically respond within context. It also allows Heineken Urban Polo to directly contact customers and followers with important information in a personal and non-invasive manner.

“Oracle Cloud has significantly enhanced the customer experience through more personalized communication,” said Simon Wilson, director, Heineken Urban Polo. “Attendees can get all the information they want, when they want, through the messaging tools they’re already using.  The digital concierge has been very well received and we are looking to continue testing as we expand the event series later this year.”

Heineken Urban Polo showcases a fusion of sport and music in the heart of New Zealand. The match is played on a significantly smaller playing field, bringing the game as close to spectators as possible, while also featuring not-to-be-missed musicians, including Kilter and Miami Horror. Heineken Urban Polo is a four game series played in various locations including Auckland, Christchurch, Hamilton and Wellington.

“Events have truly become a digital experience through mobile ticket sales, mobile entrance, photos, videos and social sharing,” said Duncan Richards, Digital Specialist, Oracle Australia and New Zealand. “By engaging with customers on platforms they already use and leveraging emerging technologies, mobile devices can now become intimate, personal experiences. We are excited to work with organizations like Heineken Urban Polo who are focused on creating the ultimate fan experience.”

The solution was implemented in four weeks in conjunction with Oracle gold-level OPN partners, Friday Solutions and Eyemagnet.

Contact Info
Nicole Maloney
Oracle
+1.650.506.0806
nicole.maloney@oracle.com
Kristin Reeves
Blanc and Otus
+1.925.787.6744
kristin.reeves@blancandotus.com
About Oracle

The Oracle Cloud offers complete SaaS application suites for ERP, HCM and CX, plus best-in-class database Platform as a Service (PaaS) and Infrastructure as a Service (IaaS) from data centers throughout the Americas, Europe and Asia. For more information about Oracle (NYSE:ORCL), please visit us at www.oracle.com.

Trademarks

Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.

Talk to a Press Contact

Nicole Maloney

  • +1.650.506.0806

Kristin Reeves

  • +1.925.787.6744

Corporación GPF Optimizes Inventory Performance Across Health, Wellness and Convenience Store Business with Oracle Retail

Oracle Press Releases - Mon, 2018-05-14 07:00
Press Release
Corporación GPF Optimizes Inventory Performance Across Health, Wellness and Convenience Store Business with Oracle Retail Ecuadorian Pharmacy and Convenience Store Giant Increases Operational Efficiencies and Store Productivity With New Inventory Insights

Redwood Shores, Calif.—May 14, 2018

Today, Oracle announced that one of Ecuador's largest retailers, Corporación GPF has implemented Oracle Retail Merchandising and Oracle Retail Warehouse Management as part of a continued strategy to deliver innovative health and wellness solutions to consumers. Corporación GPF has expanded rapidly in recent years and recognized the need to replace its existing merchandising management, logistics and point-of-sale systems to position for continued growth across more than 600 pharmacies and convenience stores nationwide, three owned brands and $500 million in annual revenue. GPF turned to Oracle with the goal of unifying business processes and democratizing access to data insights across their business to empower teams to make proactive business decisions and enhance the customer experience.

After analyzing various market solutions, GPF's leadership chose Oracle as the focal point of a transformational project after recognizing the ability of Oracle Retail solutions to adhere to business needs, integrate with existing systems and continued evaluation of best business processes. Retail Consult, an Oracle Platinum level partner, drove the implementation of Oracle Retail bringing their industry expertise and demonstrated success in optimizing Oracle technology and best practices.

"Transformational products requires company engagement and the right partner for the success of the implementation," says Fernando Jacome, Technology and Process Director of GPF Corporation. "We have achieved success by creating multifunctional teams. Leaders must engage users from the beginning, allow enough time for testing, employ project governance, and rely on efficient risk management processes. With a clear mission established by the Executive Board, we created a culture of engaged and dedicated employees.”

“We are proud to empower the operational transformation of Corporacion GPF,” said Carlos Victoria, Vice President Latin America, Oracle Retail. “With a full suite of Oracle Retail solutions, GPF now has increased visibility into out of stock inventory across stores and distribution channels and can more accurately plan and anticipate fulfillment needs.”

"We are pleased to contribute with the ability to accelerate the growth of Corporación GPF through the implementation of Oracle Retail solutions, bringing well-structured processes and system integration," said Silvia Gomes, partner, Retail Consult.

Corporación GPF adopted a phased implementation starting with Oracle Retail Merchandising System and Oracle Retail Warehouse Management solutions and a second phase including Oracle Retail Xstore and Oracle Retail Store Inventory Management. The project was supported by a diverse team with expertise in implementation, risk management, business process review and integration with legacy systems. With the completion of this project, GPF expects to optimize their core business processes and ensured data consistency across their enterprise. In addition, achieve comprehensive visibility into out of stock inventory in stores and distribution centers, analysis of daily inventory deliveries to stores, perspective on automatic orders and the ability to synchronize inventory and logistics to the point of purchase.

GPF’s successful implementation was built upon a foundation of C-level sponsorship from the Board of Directors and CEO, down through the key business managers and IT, operational and tactical levels; a clear mindset on the importance of technology to support sustainable and continuous growth and a visionary perspective of the transformational needs and investments in people and technology necessary to maintain leadership in a highly competitive environment.

Contact Info
Matt Torres
Oracle
415-595-1584
matt.torres@oracle.com
About Oracle Retail

Oracle provides retailers with a complete, open, and integrated suite of best-of-breed business applications, cloud services, and hardware that are engineered to work together and empower commerce. Leading fashion, grocery, and specialty retailers use Oracle solutions to anticipate market changes, simplify operations and inspire authentic brand interactions. For more information, visit our website at www.oracle.com/retail.

About Oracle

The Oracle Cloud offers complete SaaS application suites for ERP, HCM and CX, plus best-in-class database Platform as a Service (PaaS) and Infrastructure as a Service (IaaS) from data centers throughout the Americas, Europe and Asia. For more information about Oracle (NYSE:ORCL), please visit us at www.oracle.com.

Trademarks

Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.

About Corporacion GPF

Ecuadorian pharmacy and convenience store group founded in 1930 under the principles of “Integrity and Trust”. Its Business Units Fybeca, SanaSana, Okidoki, Provefarma and Abefarm are houlsehold names known nationwide for their customer excellence, high quality portfolio and innovative  approach.  Contribute to local society wellbeing and quality life is GPF´s Mission.  www.corporaciongpf.com

About Retail Consult

Retail Consult is a highly specialized group that has a big focus on technology solutions for retail, offering clients global perspective and experience with operations in Europe, North, South and Central America. The most senior resources average 15 years of retail experience, and the multilingual team integrates retail-specific skills in strategy, technology architecture, business process, change management, support, and management.

Talk to a Press Contact

Matt Torres

  • 415-595-1584

JTB Corporation Adopts Oracle Cloud for Its International Travel Processing System Infrastructure

Oracle Press Releases - Mon, 2018-05-14 07:00
Press Release
JTB Corporation Adopts Oracle Cloud for Its International Travel Processing System Infrastructure Oracle Cloud at Customer enables public cloud services to be deployed in a customer’s data center, delivering lower TCO, flexible IT resource allocation and security enhancements

Redwood Shores, Calif.—May 14, 2018

Oracle today announced that JTB Corporation, a leading tourism company in Japan, has adopted Oracle Cloud at Customer for in-house data use to support its international travel processing system infrastructure as part of its IT strategy towards 2020.

Since its founding in 1912 as the Japan Tourist Bureau, JTB has evolved with customers for over 100 years, serving as an agency to sell tickets and issue coupons for inbound tourists, planning and running tours in Japan. The JTB sells international and domestic travel packages for Japanese tourists, offering services for organizations including school excursions, corporate trips and MICE (meetings, incentives, convention and conference, exhibition and events), and continues to expand its global network. To leap forward, JTB established a new business domain called Multicultural Exchange Creation Business in April 2018, which offers solutions unique to JTB (products, services, information and systems) to create a panorama of multicultural exchanges on a global stage to inspire and evoke empathy. In its group management vision, JTB seeks to generate value that exceeds its customers’ expectations and ensure success by integrating a human touch in a digital world. With an IT strategy in line with its business strategy, and by maximizing existing systems, JTB works to focus investments on growth fields and actively utilizes digital technologies.

As part of its IT strategy, JTB wanted to upgrade its system infrastructure in a way that it could support the business strategy more flexibly and improve performance as part of utilizing existing systems. Previously, the company built infrastructure on premises or deployed in the private cloud for each system. In upgrading hardware components of the infrastructure, it had faced increased initial cost for building each element separately and needed to reduce costs by consolidating infrastructure operations. JTB also needed to improve efficiency by consolidating separately-built infrastructures because they were vulnerable to seasonality due to the nature of the system for selling travel products. It was also indispensable to meet security requirements of each system.

To solve these challenges, JTB selected Oracle Cloud at Customer (IaaS), allowing use of Oracle Cloud services at its own data center, and Oracle Exadata Cloud at Customer as a database infrastructure. The following are the main benefits JTB chose to adopt Oracle Cloud at Customer:

  • Reduction of total cost of ownership (TCO): Reducing initial investment, management and maintenance costs with flat-rate pricing like public cloud; and comprehensive management operation services offered by Oracle

  • High performance and flexibility with the ability to allocate IT resources for Oracle Cloud at Customer (IaaS) and Oracle Exadata Cloud at Customer to support peak data traffic, and surge in transactions while benefitting from the proven performance of Oracle Exadata in cloud environment

  • Support for security requirements to ensure cloud flexibility while avoiding the need to take sensitive data outside the in-house data center

This system will be implemented, transferred and operated by NS Solutions Corporation, an Oracle Cloud Managed Service Provider. Oracle Cloud Managed Service Provider is one of Oracle’s cloud partner programs that specifically certifies providers that have the skills, tools and processes required to build, implement, execute and manage Oracle and third party systems in Oracle Cloud Platform. NS Solutions is a one-stop service provider of Oracle Cloud implementation assessment, system transfer consultation, database migration service and operation/management service that supports customers from the stage of considering cloud migration through building and operating a system.

“Travel agency systems tend to be susceptible to high workloads in certain seasons and during events. It is essential to consolidate various systems and even out the entire processing to reduce costs. However, high system workloads do not always happen as we expect,” said Kenichi Yajima, Senior Manager, Corporate Strategy, JTB. “Flexibly scalable infrastructure is indispensable. We cannot compromise on security requirements such as handling of sensitive data. Oracle Cloud at Customer (IaaS) has enabled us to strengthen security and performance while using the cloud service at a flat rate, regardless of seasonal fluctuations to run a system in a cost-efficient manner. We look forward to Oracle’s cloud technologies’ excellent performance and security in addition to its track record of use with databases.”

Contact Info
Dan Muñoz
Oracle
+1.650.506.2904
dan.munoz@oracle.com
About Oracle

The Oracle Cloud offers complete SaaS application suites for ERP, HCM and CX, plus best-in-class database Platform as a Service (PaaS) and Infrastructure as a Service (IaaS) from data centers throughout the Americas, Europe and Asia. For more information about Oracle (NYSE:ORCL), www.oracle.com.

Trademarks

Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.

Talk to a Press Contact

Dan Muñoz

  • +1.650.506.2904

Pages

Subscribe to Oracle FAQ aggregator