Feed aggregator

Backup ORA-19806: cannot make duplex backups in recovery area

Tom Kyte - Wed, 2017-05-03 07:46
Hi Tom, I have try to copy the two copies of backup as with default format as: backup as backupset copies 2 database; error :ORA-19806: cannot make duplex backups in recovery area I have check the space in recovery_area, all right. P...
Categories: DBA Blogs

Importing sequences along with table using DBMS_DATAPUMP package.

Tom Kyte - Wed, 2017-05-03 07:46
Hello All I am trying to import sequence along with tables. In the exported file all three tables(T_VISIT,T_SUBVISIT,T_SERVICES) and sequences(PATIENT_INFO_SEQ,PATIENT_SERVICES_REG2_SEQ) are present. For export, I have already used DBMS_DATAPUMP...
Categories: DBA Blogs

Alter Table Exchange Partition fails with > 1000 subpartitions

Tom Kyte - Wed, 2017-05-03 07:46
We have a list-range(number, timestamp) partitioned table called STREAMING_RESULTS. The table stores very high volume streaming data from a telemetry device. Depending on the channel resolution, some partitions have ~ 3000 subpartitions. I can exchan...
Categories: DBA Blogs

Challenges in pl/sql

Tom Kyte - Wed, 2017-05-03 07:46
What is the challenge you faced as pl/sql developer?
Categories: DBA Blogs

SQL Code Analyzer and CI

Tom Kyte - Wed, 2017-05-03 07:46
Hello AskTom team, could you please suggest any SQL code analyzer/ CI framework or tool for Oracle similar to the following. https://www.slideshare.net/markginnebaugh/microsoft-sql-server-continuous-integration Thanks!
Categories: DBA Blogs

Column usage statistic

Tom Kyte - Wed, 2017-05-03 07:46
Hi I know the usage Statistic based on DML also on DBMS_STATS . REPORT_COL_USAGE. But i mean usage statistic based on select column from table queries. Without Join predicat or smth. like that. I heared about the heatmap. But it is based on an ...
Categories: DBA Blogs

Upgrade from non CDB to CDB - Oracle Metadata

Tom Kyte - Wed, 2017-05-03 07:46
I have two scenarios for upgrade. I have 12cR1 non CDB and 11g database . What is the best way to upgrade these dbs into 2 pdbs in one 12c R2 CDB ( Same OS). If I do a full import from a non CDB into a pdb , will not import all the extraneo...
Categories: DBA Blogs

Unexpected results with NUMBER(32,16) datatype

Tom Kyte - Wed, 2017-05-03 07:46
Hi Number(32,16) datatype columns are behaving differently, When we update those columns, oracle automatically rounding the values to something else. For eg. when we try to update the existing value from 1.0690000000000000 to 1.0690000000001234...
Categories: DBA Blogs

End users still on IE8? Upgrade them before upgrading to Application Express 5.1 or later

Joel Kallman - Wed, 2017-05-03 07:30
If you have end users of your Application Express (APEX) applications still using Internet Explorer 8, you should upgrade their browsers before upgrading to Oracle Application Express 5.1 or later.

The documented general browser compatibility for Oracle Application Express is N-1, where N is the latest production version of a browser, and N-1 is the major production version prior to that.  At the time of release of Application Express 5.1, Microsoft Edge was the current Microsoft browser and Internet Explorer 11 was the prior major version.

The Oracle Cloud Database Schema Service was recently upgraded to APEX 5.1.1, and a customer contacted me directly, saying that some of his end users who were still on IE8 couldn't even login to the application.  "We" (Anthony and John) reviewed these issues, but concluded that there really wasn't any practical way for us to resolve this for the customer.  We'll move heaven and earth to not impact a customer and avoid unplanned cost and work for them, but in this case, there simply wasn't anything we could do.

If you need a compelling reason to have your end users upgrade to a modern version of Internet Explorer, remember that Microsoft no longer supports or provides security patches for the older IE versions.

Oracle OGG JAGENT 12.2 installation for GoldenGate monitoring using the Cloud Control plugin

Yann Neuhaus - Wed, 2017-05-03 06:34

This post is mainly for self documentation as I have to search my old notes every time I want to do this (I am faster by searching on our blog :) ): If you want to monitor GoldenGate with Cloud Control using the GoldenGate plugin you’ll have to install the JAGENT on the host where GoldenGate is running on and the documentation is not quite clear on what you have to do exactly (at least when you want to use the silent installation). This is what you need to do for 12.2:

Download “Oracle GoldenGate Monitor″ from here. You need to have Java 8 installed (Oracle version, not openjdk) on the server you want to install the JAGENT on. You can download it from here.

Once you have Java 8 installed create a response file like this:

oracle@oelogg1:/var/tmp/ [rdbms12102] cat oggmon.rsp 
Response File Version=
#The oracle home location. This can be an existing Oracle Home or a new Oracle Home
INSTALL_TYPE=GoldenGate Monitor Agent Installation

Then you are ready to install:

oracle@oelogg1:/var/tmp/ [rdbms12102] /usr/java/jdk1.8.0_131/bin/java -jar fmw_12. -silent -responseFile /var/tmp/oggmon.rsp  

The result when everything went fine:

Launcher log file is /tmp/OraInstall2017-05-03_11-00-32AM/launcher2017-05-03_11-00-32AM.log.
Extracting the installer . . . . Done
Checking if CPU speed is above 300 MHz.   Actual 2793.552 MHz    Passed
Checking swap space: must be greater than 512 MB.   Actual 3967 MB    Passed
Checking if this platform requires a 64-bit JVM.   Actual 64    Passed (64-bit not required)
Checking temp space: must be greater than 300 MB.   Actual 8719 MB    Passed

Preparing to launch the Oracle Universal Installer from /tmp/OraInstall2017-05-03_11-00-32AM
Log: /tmp/OraInstall2017-05-03_11-00-32AM/install2017-05-03_11-00-32AM.log
Copyright (c) 2016, Oracle and/or its affiliates. All rights reserved.
Reading response file..
Skipping Software Updates
Starting check : CertifiedVersions
Expected result: One of oracle-6,oracle-7,redhat-7,redhat-6,SuSE-11,SuSE-12
Actual Result: oracle-7.3
Check complete. The overall result of this check is: Passed
CertifiedVersions Check: Success.

Starting check : CheckJDKVersion
Expected result: 1.8.0_101
Actual Result: 1.8.0_131
Check complete. The overall result of this check is: Passed
CheckJDKVersion Check: Success.

Validations are enabled for this session.
Verifying data
Copying Files
Percent Complete : 10
Percent Complete : 20
Percent Complete : 30
Percent Complete : 40
Percent Complete : 50
Percent Complete : 60
Percent Complete : 70
Percent Complete : 80
Percent Complete : 90
Percent Complete : 100

The installation of Oracle Fusion Middleware 12c GoldenGate Monitor & Veridata completed successfully.
Logs successfully copied to /u01/app/oraInventory/logs.

Once installed you can proceed by creating the Agent instance:

oracle@oelogg1:/u01/app/ogg/product/agent/ [rdbms12102] pwd
oracle@oelogg1:/u01/app/ogg/product/agent/ [rdbms12102] ./createMonitorAgentInstance.sh
Please enter absolute path of Oracle GoldenGate home directory : /u01/app/ogg/product/
Please enter absolute path of OGG Agent instance : /u01/app/ogg/product/ 
Please enter unique name to replace timestamp in startMonitorAgent script (startMonitorAgentInstance_20170503113738.sh) : 
Successfully created OGG Agent instance.

Create the wallet for the Agent:

oracle@oelogg1:/u01/app/ogg/product/ [rdbms12102] pwd
oracle@oelogg1:/u01/app/ogg/product/ [rdbms12102] export JAVA_HOME=/usr/java/jdk1.8.0_131
oracle@oelogg1:/u01/app/ogg/product/ [rdbms12102] ./pw_agent_util.sh -jagentonly
Please create a password for Java Agent: 
Please confirm password for Java Agent: 
May 03, 2017 11:46:06 AM oracle.security.jps.JpsStartup start
INFO: Jps initializing.
May 03, 2017 11:46:06 AM oracle.security.jps.JpsStartup start
INFO: Jps started.
Wallet is created successfully.

Adjust the Agent configuration file for your environment:

oracle@oelogg1:/u01/app/ogg/product/ [rdbms12102] pwd
oracle@oelogg1:/u01/app/ogg/product/ [rdbms12102] cat Config.properties | egrep -v "^#|^$"

Make sure you change “agent.type.enabled” to “OEM”.

Enable monitoring in the GLOBALS file:

oracle@oelogg1:/var/tmp/ [OGG122] ggi

Oracle GoldenGate Command Interpreter for Oracle
Version OGGCORE_12.
Linux, x64, 64bit (optimized), Oracle 12c on Dec 12 2015 02:56:48
Operating system character set identified as UTF-8.

Copyright (C) 1995, 2015, Oracle and/or its affiliates. All rights reserved.

GGSCI (oelogg1) 1> view params ./GLOBALS


Restart ggscsi:

oracle@oelogg1:/var/tmp/ [OGG122] ggi

Oracle GoldenGate Command Interpreter for Oracle
Version OGGCORE_12.
Linux, x64, 64bit (optimized), Oracle 12c on Dec 12 2015 02:56:48
Operating system character set identified as UTF-8.

Copyright (C) 1995, 2015, Oracle and/or its affiliates. All rights reserved.

GGSCI (oelogg1) 1> info all

Program     Status      Group       Lag at Chkpt  Time Since Chkpt

MANAGER     RUNNING                                           
JAGENT      STOPPED                                           

GGSCI (oelogg1) 2> start jagent

Sending START request to MANAGER ...

GGSCI (oelogg1) 3> info all

Program     Status      Group       Lag at Chkpt  Time Since Chkpt

MANAGER     RUNNING                                           
JAGENT      RUNNING                              

… and you’re done. Hope this helps.


Cet article Oracle OGG JAGENT 12.2 installation for GoldenGate monitoring using the Cloud Control plugin est apparu en premier sur Blog dbi services.

BPEL Certified for Prebuilt EBS 12.1 and 12.2 SOA Integrations

Steven Chan - Wed, 2017-05-03 02:00

Service Oriented Architecture (SOA) integrations with Oracle E-Business Suite can either be custom integrations that you build yourself or prebuilt integrations from Oracle.  For more information about the differences between the two options for SOA integrations, see this previously-published certification announcement.

The prebuilt BPEL business processes in Oracle E-Business Suite Release 12.1 and 12.2 are:

  • Oracle Price Protection (DPP)
  • Advanced Supply Chain Planning (MSC)
  • Oracle Transportation Management: Oracle Warehouse Management (WMS)
  • Oracle Transportation Management: Oracle Shipping Execution (WSH)
  • Oracle Transportation Management: Oracle Purchasing (PO)
  • Complex Maintenance, Repair & Overhaul (CMRO/AHL)

BPEL integration architecture diagram example


These prebuilt BPEL processes have now been certified with Oracle BPEL Process Manager 12c version (in Oracle Fusion Middleware SOA Suite 12c) for Oracle E-Business Suite Release 12.2.


Certified Platforms

Oracle SOA Suite Release 12g is certified to run on any operating system upon which Oracle WebLogic Server 12c is certified. Check the following for more details:

For information on operating systems supported by Oracle SOA Suite, refer to this document:

Integration with Oracle SOA Suite involves components spanning several different suites of Oracle products. There are no restrictions on which platform any particular component may be installed so long as the platform is supported for that component.

Pending Certifications 

The certification for BPEL 12.2.1 with prebuilt EBS 12.1 SOA integrations is underway now. Oracle's Revenue Recognition rules prohibit us from discussing certification and release dates, but you're welcome to monitor or subscribe to this blog. I'll post updates here as soon as soon as they're available.   

Getting Support If you need support for the prebuilt EBS BPEL business processes, you can log Service Requests against the Applications Technology Group product family.

Related Articles

Categories: APPS Blogs

Welcome to the new OPAL look & feel

Christopher Jones - Tue, 2017-05-02 20:21

Welcome to the new look & feel of blogs.oracle.com/opal

As you can probably guess, this is really just a test post!

Kicking the habit of WM_CONCAT for a delimited list of rows, with LISTAGG

The Anti-Kyte - Tue, 2017-05-02 15:40

I gave up smoking recently.
Among other bad habits that I need to kick is using the (not so) trusty WM_CONCAT.

Say I want to get a record set consisting a comma-delimited list of columns in the EMPLOYEES table. In the past, this may have been somewhat challenging to do in a single SQL query, unless you knew about the undocumented WM_CONCAT…

select wm_concat(column_name)
from user_tab_cols
where hidden_column = 'NO'
and table_name = 'EMPLOYEES';

From around 10g, right up to 11g R2 Enterprise Edition, this function would return your result set in a single, comma-delimited list.
However, if you attempt to execute the same query in 12g, or even 11g Express Edition, you’ll get a nasty surprise …

Error at Command Line : 1 Column : 8
Error report -
SQL Error: ORA-00904: "WM_CONCAT": invalid identifier
00904. 00000 -  "%s: invalid identifier"

Fortunately, a more modern (and supported) alternative has been around since 11g…

select listagg( column_name, ',') within group( order by column_id)
from user_tab_cols
where hidden_column = 'NO'
and table_name = 'EMPLOYEES'


Unlike WS_CONCAT, LISTAGG allows you to specify the order in which the delimited values should be concatenated. It also allows you to specify the delimiter to use.
So you could use a “|” symbol, for example, or, if you have definite ideas about how a list of columns should be written you may consider something like :

select listagg( column_name, chr(10)||',') within group( order by column_id)
from user_tab_cols
where hidden_column = 'NO'
and table_name = 'EMPLOYEES'


Now, if only I could remember not to squeeze the toothpaste tube in the middle…

Filed under: Oracle, SQL Tagged: listagg, wm_concat

How to create Teradata Server Dashboard

Nilesh Jethwa - Tue, 2017-05-02 15:10

Teradata delivers better business outcomes through technology-enabled solutions in the areas that matter most ? from operational excellence and asset optimization, to customer experience and product innovation, to finance transformation and risk mitigation. It works with leading businesses in over 75 countries worldwide including many of the top performers and best-known brands in telecom, transportation, consumer packaged goods, financial services and manufacturing.

Are you using Teradata Server for your data marts or data-warehouse? If so, build your Free Teradata Server infocaptor dashboard software.

Read more at http://www.infocaptor.com/ice-database-connect-dashboard-to-teradata-sql

How to calculate current DB size

Tom Kyte - Tue, 2017-05-02 13:26
We requested oracle apex work space area 100MB?It exceeds the over 90% size? How to calculate Current file Utilization and current database size? Requested Size: 100(in MB) Current File Utilization: 6.49(in MB) What is this? Curr...
Categories: DBA Blogs

Peculiar syntax error with analytic functions and division operator. Same error does not occur with multiplication operator

Tom Kyte - Tue, 2017-05-02 13:26
<code> CREATE TABLE lhtest1( C1 varchar(10 char), C2 varchar(10 char), C3 varchar(10 char), C4 varchar(10 char), C5 varchar(10 char), C6 varchar(10 char), C7 varchar(10 char), C8 varchar(10 char), C9 varchar(10 char), C10 varchar(10 char)...
Categories: DBA Blogs

How to find out if the date is a weekend or weekdays

Tom Kyte - Tue, 2017-05-02 13:26
Hi all, I'm having trouble figuring out how to find out if the date is a weekday or a weekend from a column. Scenario CREATE TABLE A (a_id VARCHAR2(20), date_a DATE DEFAULT SYSDATE, CONSTRAINT A_PK PRIMARY KEY (a_id)); TABLE A have...
Categories: DBA Blogs

how to count active login hours with minutes of a employee

Tom Kyte - Tue, 2017-05-02 13:26
how to count login hours with minutes of a employee my scenario is if a employee login at time 'x' and he continue his work up to a certain time period 'y'. my question is how to calculate the active login hours of a employee from time 'x' to ...
Categories: DBA Blogs

Nonblocking mode for the oci connection

Tom Kyte - Tue, 2017-05-02 13:26
Hi Tom! I can create a nonblocking OCI connection and get OCI_STILL_EXECUTING status with ORA-03123 (Operation would block) error, but what is the way to determine which operation would block - reading or writing. I want to handle many Oracle con...
Categories: DBA Blogs

Want to remove special characters from this ِِAA07E01A. Need to get result as AA07E01A

Tom Kyte - Tue, 2017-05-02 13:26
I want a query which will remove special characters from this word: ??AA07E01A. I need a result back as AA07E01A.
Categories: DBA Blogs


Subscribe to Oracle FAQ aggregator