1809 POUG


Look at the label!
You would also be forgiven for thinking POUG stood for Polish Oracle User Group but the official name is Pint with Oracle User Group. 

I remember last year lots of speakers saying how much fun this event was, and later in the year Kamil, the brains behind this event and fellow ACE Director, asked me why I had not been part of it and I promised I would (more...)

Oracle Cloud: start/stop automatically the Autonomous Databases

In the previous post I've setup all the environment to be able to easily control the OCI services without bothering with the sign-in headers, and without installing anything. In this post I'll used the oci-curl() function to stop all my Autonomous Database services. In the previous post, I've set the environment variables for the private and public key, and the user, tenant and compartment OCIDs.

Oracle Cloud Infrastructure API Keys and OCID

As you may have read in the news, CERN is testing some Oracle Cloud services. When a large organisation is using the Cloud Credits, there's a need to control the service resources. This requires automation and then the GUI interface from the Cloud portal is not sufficient. We can control the Oracle Cloud Infrastructure through the REST API, OCI CLI, OCI SDKs, and all those methods require a RSA key for sign-in and some OCI (more...)

Jenkins 2.0 pipeline: Scripting active parameters for SCM

Last year I got introduced to the new features 2nd generation Jenkins at a workshop of CloudBees . This year I got also the opportunity to discover them in practice.

One of the most interesting and often challenging part of working with scripted pipelines is the gap between the list of plugins supported in Jenkinsfiles vs. only effective from the GUI. Even though the gap is very small, sometimes it involves an operation crucial or (more...)

Integrated SOA gateway page loading long time no response

When you try to open ‘Integrated SOA gateway page in EBS and loading  long time with no response”

 

Solution :

Run Gather schema statistics

exec fnd_stats.gather_schema_statistics(‘ALL’);

 

 

Updating Exadata Software summary

Updating an Exadata software is one of the crucial tasks for any Database Machine Administrator (DMA). Though not necessarily one has to patch the environments whenever there is a new patch released by Oracle, but, it is highly recommended to patch the systems at least twice a year to fix any known &unknown bugs, security vulnerabilities and other issues.

This blog post summarizes the overall overview of software updates on an Exadata Database Machine. The (more...)

Oracle Core Audit – Do you Audit your Core database engine for breach?

Oracles core database audit is a useful tool to monitor activity of the core database engine or applications and detect potential abuses. It seems to be a sad fact that with a lot of companies that i visit and from....[Read More]

Posted by Pete On 15/09/18 At 08:28 AM

Advanced SoapUI: Mocking a Async Request Response Service supporting WS-Addressing

Lately, I sat down with my appreciated colleague Frank, prepping for a SoapUI/ReadyAPI training due next week. After having solved some issues he had, we agreed upon designing an advanced lab.

In the past I wrote an article about how to test een Asynchronous Request Response BPEL process, with WS-Addressing. This uses SoapUI as a test client, to test an Async BPEL Process and catching the response. Frank suggested to create a SoapUI project (more...)

Exadata and Capacity on Demand (CoD)

As most of us knew that the Exadata Database Machine comes in different sizes with different resource capacity. Not sure how many of you aware that Capacity on Demand (CoD) option can enable customers to start with limited active cores processors and increase them dynamically on demand. If CoD option is not enabled during the initial EDM configuration, then, all active cores are enabled by default and can't be reduced any further.

With X4-2 or (more...)

Upgrade SOA 11g to 12c: Invalid Composite File

You might not get it, but not every customer already moved from SOA Suite 11g to 12c. My current customer isn't for instance. Because we're in a bit of a lee period, I'm looking into upgrading their composite projects.

Solve invalid composite files

One thing I ran into quite immediately is that for several projects the composite.xml was invalid. It turned out that it wasn't even upgraded.

I found this support.oracle.com article, (more...)

Living the Dream

I was watching a rerun of X Factor at my brother’s house at the weekend. Most of the time I was wincing at all the bum notes sung by the people the judges were saying were fantastic, or wincing at everyone who was doing it for their { mom | dad | grandma | grandad | dead parrot } in an attempt to get me emotionally invested. Apart from all that cringe, the other thing (more...)

Add record count to collapsed region

I have a diagnostics page where I wanted to display how many records are in a collapsible region's title.

The following is a simple solution, but will only work properly if all records are displayed, and no pagination is used.
Otherwise, check this past post for alternative methods to get the number of rows in a region.

Pick a column in the region and add a class. I chose "cnt".

Column attribute

To be selective, (more...)

Connor and Chris at OpenWorld

Chris and I will be at OpenWorld next month, so our session details are below, but you can also click on the links below to add entries to your calendar to make sure you don’t miss us. Don’t forget to use the official Schedule Builder to make sure you have booked your spot at our sessions!

If you can’t get to our sessions, you might catch us wandering the halls or at The Hub. Feel (more...)

Create Oracle Database 18c on Windows – Advanced Configuration for the pros

If you are setting up a production system or similar, you will need to go through the advanced configuration. The best option is to choose "Set Up Software Only" in Oracle Universal Installer (OUI) to complete the Oracle software installation, then use Database Configuration Assistant (DBCA) to create a new database. OUI and DBCA have the advanced configuration. The OUI advanced configuration is not "advanced" enough, DBCA lets you customize the database configuration options - (more...)

Cloud Access Security Broker (CASB) for Oracle Cloud Infrastructure (OCI)

Customer adoption to cloud services (IaaS, PaaS, SaaS)  has been rapidly grown and growing. The most challenging aspect moving to cloud is the ability to secure the application and data that is put on the cloud. Oracle's hetrogenous security solution Cloud Access Security Broker (CASB) helps customers protecting their cloud-based infrastructure, platforms, applications across vendors. CASBs have emerged as  the go-to cloud security solution. CASB has the ability to provide security to entire cloud footprint (more...)

ORAchk (EXAchk) und der Collection Manager (Teil 2)

Nun geht es mit Teil 2 weiter.

Nach dem nun die APEX Installation fertig ist, geht es darum den Collection Manager zu installieren und zu konfigurieren.

Dazu empfehle ich sich für das Setup parallel die Dokumentation, also das User’s Guide „Oracle® ORAchk and EXAchk“ und hier Kapitel 1.9 Oracle Health Check Collections Manager for Oracle“ zu öffnen.

Wir melden uns nun am Admin Service an:

 

http://o1:8080/apex/apex_admin

Der neue „Workspace“ wird erstellt. Im zweiten Schritt (more...)

Community participation is not cheap!

I’m in a really privileged position where I’ve spent over a decade speaking at events all over the world. That has been made possible by being part of the Oracle ACE Program, and more recently the Oracle Developer Champion program, who have provided funding for some of the events I’ve participated in.

I guess it’s easy for someone on the outside looking in to think this is a really cushy number, but after my latest (more...)

How to test REST Service (POST) for EBS 12.1/12.2

Step 1: Deployed rest service in EBS

(Create package & body for inserting data into table & Create Business entity, then you create pls & upload it & Deployed)

Give grant to specific user, That particular responsibility should be assigned to user.

Note the “Responsibility Key”

Step 2: Install Chrome Rest Service Client

Step 3:  Now you have WADL file for you deployed service

Step 4:  Example POST Data

 

 

oracle.apps.fnd.isg.common.error.ISGException: Could not find the package.

When you’re trying to deploy rest service , you might be get the below issue

 

Error in the generating PLSQL package oracle.apps.fnd.isg.common.error.ISGException: Error in the generating PLSQL package at oracle.apps.fnd.isg.app.common.designer.db.DBServiceDesigner.generateArtifacts(DBServiceDesigner.java:494) at oracle.apps.fnd.isg.app.ebs.designer.db.DBRestDesigner.generateService(DBRestDesigner.java:52) at oracle.apps.fnd.isg.app.common.designer.AbstractServiceDesigner.designService(AbstractServiceDesigner.java:34) at oracle.apps.fnd.isg. (more...)

sqlplus: error while loading shared libraries: libclntsh.so.10.1: cannot open shared object file

When you’re doing clone on the Redhat 7, you may get the below error

 

“sqlplus: error while loading shared libraries: libclntsh.so.10.1: cannot open shared object file”

 

This is bug as per note Oracle E-Business Suite Installation and Upgrade Notes Release 12 (12.2) for Linux x86-64 (Doc ID 1330701.1)

 

you need to install “binutils” rpm package version as per noted in the documentation.

After installed also, you still get (more...)