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...)
Users are always complaint about siebel erp integration performance issue when they are doing push the approval data to erp r12. It will take approximately 2 to 4 minutes.
So I took the awr reports from both database and crosschecked both with some interval, the siebel database performance is good but erp database saying there is integration related packages sql elasped time little bit more.
So i just went to siebel application and look the all components group log (more...)
In the previous parts (here and here) of the series we looked at some aspects of nested loop I/O optimizations, but we have left out the most important question (from the practical point of view): how these methods are doing time-wise? Which one(s) is(are) faster, and how much savings are they offering compared to the non-optimized plan? We will turn to these questions now.
First of all, if we simply run everything with (more...)
Delphix support helped me resolve an issue yesterday and the experience gave me the idea of writing this post about several general computer issue troubleshooting tips that I have learned down through the years. Never mind that I ignored these lessons during this particular problem. This is more of a “do as I say” and not a “do as I do” story. Actually, some times I remember these lessons. I didn’t do so well this (more...)
HCM Data Loader (HDL) data ready to load into Oracle HCM Cloud is in pipe separated text file format, however most people will create and manipulate these files in MS Excel as it’s the handy swiss-army-knife for data manipulation that almost everyone is familiar with.
The way that we’ve worked is that we create template files containing the sheets and columns corresponding to the fields that the client is using, which the client then populates, (more...)
We are excited to post the first in our Oracle Forms 12c guest series and introduce our first contributor and a loyal member of the Oracle Forms Community, Holger Lehmann. If you’re a Forms guru and want to contribute click here for more information
We also have an awesome upcoming Oracle Forms 12c webinar with Michael :WEBINAR: ORACLE FORMS 12C: NEW FEATURES UNVEILED AND EXPLAINED – Register here!
Oracle Forms 12: New Runtime Options (more...)
In the previous part of this mini-series we looked at differences in multiblock read behavior for different nested loop optimization mechanisms depending on degree of ordering of the data. In this post I’ll continue to explore the subject, but this time we’ll focus on decision-making process: what factors (other than the obvious ones — like optimizer hints and/or parameters) affect the specific choice of a mechanism?
Previously, we saw that in all nested (more...)
The ‘Year in Blogging’ reports have come through so I can see what posts and newsletter items garnered the most views.
The Fusion Tipster Blog
So, according to the summary, the most popular post was Introducing OTBI-E, followed by What’s Coming in Taleo 14B, and then the posts on specialisation. Of those, only the former was written in 2015, with the other two coming from 2014. The other popular posts written in 2015 (more...)
Next Tuesday at 11:20 am at Oracle headquarters there will be a panel discussion on SQL. You can participate whether you are there or not as we are collecting questions ahead of time and will video the panel to be posted later. The panel’s participants will be
In my last blog I talked about trying out Jenkins. In this blog post I want to talk about the new Jenkins plugin for Delphix.
Delphix plugin is easy to add. Just navigate to “Manage Jenkins” in the top left
Then click on “Manage Plugins”
Then type in “delphix” in the search bar and then click on the “Delphix Jenkins plugin” to install
Now we can access Delphix APIs through the Jenkins (more...)
Jenkins seems to be the top code build, integration and QA automation tool to support continuous delivery.
Jenkins allows me to kick of jobs on a schedule or ofter certain events and Jenkins will keep track of the status of the jobs and the results.
To get Jenkins installed, I read wiki.jenkins-ci.org and then read biouno.org to try my first Jenkins example.
I installed Jenkins on one of the VMs from the “landshark” demo environment for (more...)