On November 5th and 6th, I attended to Oracle Database 12c Partner Roadshow in Istanbul. During this 2-day partner-only (and free) briefing, François Pons from Oracle Server Technologies, gave detailed technical information about new features of Oracle 12c to Oracle partners in Turkey. Although it was not a workshop, Mr. (more...)
I’ve installed Ubuntu to my laptop (another try to live with Linux), and now trying to organize useful stuff. I wanted to install Oracle SQL Developer and couldn’t find an up-to-date document about it, so decided to write one (which will be use most straight forward steps).
First we download (more...)
Oracle Database 12c Backup and Recovery Survival Guide, written by Francisco Munoz Alvarez and Aman Sharma, is published by Packt. I’m one of the technical editors of the book and I can say that it’s well-written, easy-to-read, and covers all important topics about backup and recovery and provides the (more...)
I got an error when trying to start Oracle Enterprise Manager Cloud Control 12c. It says AdminServer couldn’t be started:
[oracle@oem12c bin]$./emctl start oms
Oracle Enterprise Manager Cloud Control 12c Release 3
Copyright (c) 1996, 2013 Oracle Corporation. All rights reserved.
Starting Oracle Management Server...
WebTier Successfully (more...)
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 configuration to tell which IP addresses will be served by SCAN VIP services. So when you (more...)
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 structure of the new server. It becomes a time-consuming task if you’re dealing with hundreds of datafiles. Today (more...)
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 Support, he found MOS Document ID 1480089.1. Although this document explains the reason of the error, (more...)
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 page instead of full html. She says she already uses it to fetch from other web pages (more...)
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-installation tasks, so I tried to run Oracle Patch Application Assistant (admsi.pl). I got (more...)
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. All you need is to drop that table and restart the worker. Connect your database as sys/system, (more...)