Gokhanatil - gokhanatil.com - Gokhan Atil's Oracle Blog
General Information:
Latest News:
How to Change IP adresses of SCAN Name in Oracle 11gR2 RAC 1 Aug 2013 | 01:52 am
Today, I needed to update the IP adresses of scan name in Oracle 11gR2 RAC environment. As you know, these IP addresses are defined in DNS but they also stored in Oracle Clusterware resource configura...
Renaming Files for RMAN Restore 22 Jun 2013 | 12:50 am
We usually need to duplicate our databases to test servers which have different disk layouts than production server. So we need to distribute the datafiles according to the disk space and directory st...
Segmentation Fault When Running Sqlplus and Tnsping From R12 10gR2 ORACLE_HOME 14 Jun 2013 | 05:58 pm
My co-worker has encountered a “Segmentation Fault” error while he tried to run sqlplus on a newly installed server which will host E-Business Suite R12 database. After a short search on My Oracle Sup...
How to Read Web Pages Using utl_http.request_pieces 10 Jun 2013 | 07:43 pm
UTL_HTTP package provides easy to use methods to fetch data from web using http protocol. Today, one of my co-workers complained that “utl_http.request” method returns only a small part of the web pag...
Oracle Patch Application Assistant and DISPLAY Variable 26 May 2013 | 12:59 am
I installed EBS 12.1.3 to my laptop for testing purposes, and applied some patches. Although I carefully check the readme files of the patches, I wanted to be sure that I have followed post-installati...
mth_pre_upgrade.sql Failed While Applying EBS Patch 9239090 23 May 2013 | 01:59 am
This error may occur when you try to re-apply the patch 9239090 (EBS 12.1.3), because the mth_pre_upgrade.sql tries to create a table named “MTH.MTH_RESOURCES_D_TEMP” without checking if it exists. Al...
Book Review: Managing Multimedia and Unstructured Data in the Oracle Database 8 May 2013 | 02:23 pm
Managing unstructured data in a relational database system is one of the least know subjects. There is a large amount of unstructured data in the real world and a relational database designed to store...
Win A Free Copy of Packt’s Oracle Enterprise Manager 12c Administration Cookbook e-book 9 Apr 2013 | 01:45 am
I’m pleased to announce that we have teamed up with Packt Publishing and are organizing a give away especially for you. All you need to do is just comment below this post and win a free copy of Oracle...
VirtualBox: Failed to Create Host-only Network Interface on Ubuntu Linux 24 Mar 2013 | 07:36 pm
After I installed Ubuntu to my Laptop, I began to install my favorite applications. Everything went smooth. One of my favorite application is VirtualBox. I’m big fan of it, and I use it on both Window...
Book Review: Oracle Enterprise Manager 12c Administration Cookbook 23 Mar 2013 | 03:05 pm
Oracle Enterprise Manager is getting highly popular so we see more and more books about it. Recently, Packt published a new book titled “Oracle Enterprise Manager 12c Administration Cookbook“. It is a...