I’ve received a number of inquiries lately about the support of DB2 on Delphix and yes, Delphix 5.0 now supports full automation of virtual data for DB2. With the addition of DB2, Delphix now supports full automation of virtual data on all three of the major enterprise databases
as well as Sybase, MySQL and Postgres.
For more information on DB2 in Delphix 5.0 see
The Universal Theme introduced with APEX 5 is immensly good looking and comes with a powerful Theme Roller to customize it.
With that new theme most, if not all, older themes are obsolete.
That leaves us just with a few corporate designs which can’t (or don’t want to) be replaced by the UT.
Now ideally you want your developers to use that custom theme in all applications and also subscribe to that.
Historically I recommended (more...)
I feel like I have not been posting very much on this blog lately. I have been focused on things outside of Oracle performance so I haven’t had a lot of new scripts to post. I have been quietly updating my Python source code on GitHub so check that out. I have spent a lot of time educating myself in various ways including through the leadership and communication training program that comes from Toastmasters. My new (more...)
AuraPlayer was thrilled to attend Mobile World Congress (MWC) in Barcelona. It was our first time attending this epic conference, and we can assure you it lived up to all the hype.
Suhas Uliyar, Oracle’s VP Mobile Strategy, visits the AuraPlayer Booth
The conference emphasized the mobile revolution occurring throughout all industries and how organizations need to mobilize their business practices or they’ll be left behind. This further reinforces what Grant Ronald always says, “If (more...)
Cedar held its annual Oracle Day in Oracle’s City office last Thursday – it was actually our 6th year of running the event. The attendance was great – just short of 100 – and with 3 streams of content there was plenty to choose from. If you weren’t there, here’s the highlights of the sessions that I attended:
After the opening keynote from Dan Woolstone, Oracle’s James King and myself spoke to a full room (more...)
A question was raised in Martin Widlake’s session this morning in OUG Ireland 2016. The (excellent) session was about the performance of calling PL/SQL functions from SQL, and Martin scared the audience (or at least tried to scare…) with the fact that read consistency is not kept (with respect to the base SQL statement) when the PL/SQL functions are called from that SQL statement.
The question that was raised was whether this is also (more...)
NFS is the future, has larger bandwidth than FC, market is growing faster than FC, cheaper, easier, more flexible, cloud ready and improving faster than FC.
photo by Paul Oka
- Legacy : FC is becoming legacy like Cobal and the Mainframe. Not going way, but not what you want to invest in.
- Throughput : FC throughput has fallen behind NFS and is the gap is only widening.
- Price : FC is much (more...)
In my “write less with more” presentation today at OUG Ireland 2016, I showed the ability to change an identity column from GENERATED BY DEFAULT AS IDENTITY to GENERATED ALWAYS AS IDENTITY with the START WITH LIMIT VALUE option. You can read about this option (and about identity columns in general) in detail in Write Less with More – Part 2.
Jonathan Lewis raised a good question – if the identity column is not indexed, (more...)
When I am trying to restore the full database to target new host, I have used to catalog the backup piece but It took more time but not complete
RMAN> catalog start with ‘/u02/backup/backup/’;
Starting implicit crosscheck backup at 26-FEB-16
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=6 device type=DISK
Crosschecked 27 objects
Finished implicit crosscheck backup at 26-FEB-16
Starting implicit crosscheck copy at 26-FEB-16
using channel ORA_DISK_1
Disable the recovery file destination, and (more...)
If you are plan to implement rac setup in virtul box for your lab practise, you need to setup a dns configuration necessary steps to use single client access name (SCAN) introduced in 11gR2 RAC.
The DNS setup may be a separate server, or you can make it on any one of the nodes you’re preparing for rac implementation.
Here I have chosed to setup on rac first node, so you need to do some (more...)
The 12c version has introduced a new features called “OCI Client-Side Deployment Parameters” this feature gives you the possibility to override some OCI parameters without even changing your application code.
Let’s make a simple test case using Python and the cx_oracle module (which use the OCI interface) for connecting to the oracle database.
You can find this module for your python version and the database 12c version here.
This is the code of our test case:
Its necessary to take the backup of siebel gateway name server data before or after making any configuration changes. So you should take the backup of siebns.dat file
Administration- system configuration –> Enterprises
Click Backup enterprise ( it will generate siebns.dat along with date in gateway server).
or Command prompt
[siebel@premiadb siebsrvr]$ srvrmgr /g premiadb /e MigEnt /u SADMIN /p password
srvrmgr> backup nameserver
Command completed successfully.
We can use below (more...)
Hello Guys, If you are looking the siebel installation guide on redhat linux 6 , this document will guide you to install siebel 15.o industry application on redhat linux 6.2. This document may be useful for you when you’re going to deployment siebel on your environment.
Download the document :
Step by step Siebel 15.0 industry applications installation guide on Redhat linux 6.2
If you work with I/O benchmarking of Oracle databases, you are almost certainly familiar with SLOB. SLOB is more than just an I/O benchmark — it’s become a de-facto industry standard. It’s simple, powerful and efficient, and it captures a plethora of metrics, both from the OS (output of iostat, mpstat etc.) and the database itself (in the form of an AWR report).
One thing that is missing though is visualization. It’s fairly (more...)
Michael Ferrante, the Oracle Form Product Manager, has been asked to clarify the database repository licensing for Forms 12c. He was generous enough to share his response with the Oracle Forms Community as the second post in our Oracle Forms 12c guest series. If you’re a Forms guru and want to contribute click here for more information.
Be sure not to miss our webinar with Michael on 2/29 at 1pm EST: Oracle Forms 12c: New Features Unveiled and (more...)
Are you in Vienna/Austria on February 25th 2016 and interested in APEX?
Then you have to come and join us at the “APEX in the Cloud Day” – reserve your seat right away!
Create a user
The user should not able to access through terminal like putty…etc
The user Should able to access his custom report directory path only with ftp client
the user need that directory path read and write permission
OS: Redhat 5.6 64bit
check below package are installed or not
[root@ebsdev ~]# rpm -qa|grep vsftpd
Step2 : If its not installed, install below rpm package
[root@ebsdev install]# ls
In this article, I’ll summarize my observations regarding nested loop join mechanisms as well as previously known facts, so that everything would be in one place.
1) Nested loops are the simplest join mechanism in Oracle, where as data is read from one table (or more generally, row source), for each row another table (or more generally, row source), is probed (typically with an index proble, such as INDEX RANGE/UNIQUE SCAN) to see if there (more...)
When a table is accessed by multiple members of a parallel query server set, the execution plan may show the use of block range granules (PX BLOCK ITERATOR) or partition range granules (PX PARTITION [RANGE|LIST|HASH] ITERATOR or PX PARTITION [RANGE|LIST|HASH] ALL).
The basic ideas surrounding these concepts are discussed in numerous blogs and books, including my own, but discussion of partition range granules is normally restricted to either partition wise joins or the creation (more...)