I don’t like to import certificates, so i cannot use httpuritype for HTTPS pages and I decided to create package which will work with https as http.
It was pretty easy with java stored procedures
java source: xt_http.jsp
create or replace and compile java source named xt_http as
By Elena Avesani, Principal Strategy Manager, Oracle
September 2015 marked two remarkable events in the fight
against global warming. Pope Francis addressed a joint session of Congress on
Sept. 24, the first time the head of the Roman Catholic Church has addressed
the body, and called on Congress to protect our environment, laying out the argument presented in his June 2015 “Laudato Si” Encyclical Letter for a new partnership
between science and religion to combat (more...)
In this series of posts and videos, we will explore creating and deploying a SOA composite using Oracle Developer Cloud Service.
< Previous Chapter | Next Chapter >
Chapter 12 - Populating Remote Maven Repository
If you followed a previous chapter, you should have your local Maven repository populated with the necessary SOA binaries. In order to build on the cloud, the project's remote Maven repository needs to be seeded with the same binaries. (more...)
Java’s rapid rise to
fame 20 years ago began with a tumbling duke applet running in the HotJava browser. Applets allowed richer development
functionality at a time when browser capabilities were very limited, and
provided centralized distribution of applications without requiring users to install
or update applications locally.
HotJava’s support for
applets was picked up by Netscape. In 1995 Netscape Navigator 2.0 and plugins became more popular to expand the
kind of content that (more...)
New to Analytics 15.2 release is the addition of historical facts and subject areas for user defined fields fact data such as project, wbs, activity, resource, and resource assignment for their cost
and number udf's. For these UDF's to be available they will have had to been selected either from configStar or from the Analytics web configuration utility and have the UDF's and opted in.
Opting them in means that history will now (more...)
A common question is what is the data flow for adding a user and getting that user into Primavera Analytics. For this example we are going to follow the P6 user flow.
1- Log into P6 application and add new user. Give this user module access for P6 Analytics. Assign Project Access and Responsible ManagerOBS to this user.
2- Run the Global Services Security Service.
3- Run StarETL process.
4- Make sure user (more...)
About 14 months ago I spotted a problem with the PDB Logging Clause. I opened an SR and several months later I got a patch, which unfortunately didn’t fix the issue, just altered the symptom somewhat. I wrote about that patch here.
Yesterday I got a new patch, which actually does fix the problem, so now the PDB Logging Clause works as documented!
I’ve updated the PDB Logging Clause article to reflect the change.
I realise (more...)
That’s not really a problem but annoying issue I had with OEM 12c. Once a standby database is promoted, the database system for the same is showing as metric collections error OR Status Pending.
The standby database doesn’t need its own system since it will join the primary database system. The solution is to associate the standby database with the primary system and then remove the standby database system.
For example – we’ve got primary (more...)
Since the upgrade to Cloud Control 220.127.116.11, we’ve been having a couple of issues, mostly around EMCLI.
Some of our databases use Service Guard, so you don’t know which node they are running on. Rather than having an agent per package, we have one on each node. One of my colleagues wrote a little script to check which node the instance is running on, and relocate it if it has moved. This (more...)
Just a quick comment about something I noticed while rebuilding a test VM on my Mac. There is a long lead up to this, so bear with me…
I use VirtualBox on three different host operating systems.
Mac : My main desktop is a Mac, so most of my tests are done using Oracle 12c on Oracle Linux 6 or 7, running under VirtualBox. Most of the VMs I use are quite old, but I (more...)
So you may ask, why go through all the trouble?
Have you ever had to move scripts from one directories to another to find out the script is now broken?
This is due to the hard coding of the location for SQL script in the shell script.
When possible, I would like to separate shell / SQL scripts so they can be run individually and easier for debugging.
Don’t you hate it when copy/paste SQL (more...)
VirtualBox 5.0.6 has been released.
It’s a maintenance release. You can find the downloads and changelog in the usual places.
was first posted on October 3, 2015 at 2:31 pm.
©2012 "The ORACLE-BASE Blog
". Use of this feed is for personal non-commercial use only. If you are not reading this article in your feed reader, then the site is guilty of copyright infringement.
Do you find it cumbersome having to format controlfile trace?
For the most part, it’s a manual and tedious process.
Using sed, it may be possible to automate task.
RESUSE overwrites existing controlfile trace.
alter database backup controlfile to trace as ‘/tmp/cf.sql’ REUSE RESETLOGS;
ARROW:(SYS@hawklas):PRIMARY> alter database backup controlfile to trace as '/tmp/cf.sql' RESETLOGS;
alter database backup controlfile to trace as '/tmp/cf.sql' RESETLOGS
ERROR at line 1:
ORA-01277: file '/tmp/cf.sql' (more...)
Oracle 12c introduced feature to move table partitions and sub-partitions as online operations.So, this blog is related to this feature and the issue I faced.
The database was upgraded from 18.104.22.168 to 22.214.171.124 and this issue is seen in upgraded databases only.
SQL> create table sales_part
(product char(25),channel_id number,cust_id number,
amount_sold number, time_id date)
partition by range (time_id)
partition sale_jan values less than (to_date('01-02-2015','dd-mm-yyyy')),
Yes boy and girls, it is that time of year again. Time for the BIG show in San Francisco – OOW15 I will as usual, attend, but only for a few days this year (been away from home too much). My Talk I will be presenting my session Worst Practices in Data Warehouse Design (UGF9985) […]
Often, the biggest problem with regular expressions is that those who use them sometimes don’t use them correctly. A great example occurs in the Oracle Database with the
REGEXP_LIKE function. For example, some developer use the following to validate whether a string is a number but it only validates whether the first character is a number.
lv_input VARCHAR2(100 (more...)