The MOS document says, compat-oracle-el5-1.0-5 RPM is installed but it shouldn’t be. This RPM causes, 10.1 executables (it seems it would affect any Oracle DB software version) are not being relinked correctly (they are not relinked with the -m32 parameter). So MOS asks to uninstall compat-oracle-el5-1.0-5, and my co-worker uninstalled the RPM but he still got the error.

It’s obvious that uninstall is not enough to fix the problem because the Oracle binaries are not linked correctly. So we need to relink the all Oracle binaries:

[oraprod@renamed ~]$ $ORACLE_HOME/bin/relink all

Another option would be re-install Oracle database software but relinking is a much faster.

TYPE html_pieces IS TABLE OF VARCHAR2(2000) INDEX BY BINARY_INTEGER;

So I created a small function to demonstrate how we can fetch a web page using utl_http.request_pieces:

CREATE OR REPLACE FUNCTION readfromweb (url VARCHAR2)
   RETURN CLOB
IS
   pcs    UTL_HTTP.html_pieces;
   retv   CLOB;
BEGIN
   pcs := UTL_HTTP.request_pieces (url, 50);
   FOR i IN 1 .. pcs.COUNT
   LOOP
      retv := retv || pcs (i);
   END LOOP;
   RETURN retv;
END;

And tested it:

SELECT readfromweb ('http://..../awebpage.aspx') FROM DUAL;

[appldemo@appldemo ~]$ admsi.pl 
Invoking Oracle Patch Application Assistant.... 
Please set the DISPLAY variable and re-run this script

Yes I know that it seems a very familiar problem for XWindow applications, but because I’ve logged in directly to XWindow, I shouldn’t get this error… Anyway, I checked if the DISPLAY variable is set, and see that it’s set to “:0.0″ (as expected). All applications including Oracle Database Tools was working without error.

First I searched the My Oracle Support but couldn’t find a solution (maybe I missed), so I checked the source code of the script. admsi.pl simply sets same environment variables and calls “admsi_main.pl”. When I checked the admsi_main.pl, I see that it intentionally gives an error when the DISPLAY variable is set to “:0.0″. So to fix the problem, I opened the $AD_TOP/bin/admsi_main.pl file with a text editor, found the following line:

if(($DISPLAY eq "") || ($DISPLAY eq ":0.0")){

…and modified it:

if($DISPLAY eq "") {

Saved the file and then tried to run admsi.pl again, and it worked:

drop table MTH.MTH_RESOURCES_D_TEMP;

Then run adctrl, enter 2 (Tell worker to restart a failed job), and then enter the number of the failed worked. ADPatch will continue to apply the patch.

The book is designed for technology architects and database administrators. Kratochvil plans to write another book which will will focus on developers and storage architects.

First chapter covers key concepts, later chapters cover technical details for database administrators.

Here is the list of the chapters:

1. What is Unstructured Data? First chapter defines unstructured data and explains why you need to store unstructured data in a relational database.
2. Understanding Digital Objects: Second chapter focuses on the definitions and terminologies widely used when working with digital objects.
3. The Multimedia Warehouse: This chapter focuses on data warehouse concepts when storing multimedia. multimedia warehouse structures, metadata standards, data types are explained.
4. Searching the Multimedia Warehouse: This chapter includes the different ways a multimedia database can be searched for multilingual data and how to represent the results.
5. Loading Techniques: This chapter covers loading methods and strategies for attaching metadata to digital objects.
6. Delivery Techniques: This chapter focues on managing digital rights on e-commerce while deliver digital objects (specially images) to customers.
7. Techniques for Creating a Multimedia Database: This chapter covers technical aspects such as multi-tier architecture, database configuration concepts, Oracle securefile, storage system (ASM, Raid, SSD, SANs, and NAS).
8. Tuning: This chapter covers tuning methodologies for an Oracle Database containing unstructured data.
9. Understanding the Limitations of Oracle Products: This chapter covers Oracle Database features, options, and add-ons which can be used to work with unstructured data.
10. Working with the Operating System: When the Oracle Database cannot handle a multimedia object, you need to handle it using external processing. This chapter describes the methods and techniques for working with the Unix and Windows operating systems.

The book contains very detailed information about unstructured data to help Database Administrator to understand fundamental concepts, challenges and methods of building a multimedia datawarehouse. It’s not for people who look for quick and step by step instructions to build a multimedia warehouse. If you want to go deeper on this subject, this is probably the best book in the market.

Overview of Oracle Enterprise Manager 12c Administration Cookbook eBook:

• Recipes for installing, configuring, and getting up and running with Oracle Enterprise Manager
• Set up automatic discovery, create and clone databases, and perform provisioning
• Monitor Oracle Fusion Middleware, and remotely use incident and problem management using iPad/iPhone

How to Enter?
Simply post your expectations from this book in comments section. You could be one of the 3 lucky participants to win the e-copy.

DeadLine:
The contest will close on April 12th, 2013. Winners will be contacted by email, so be sure to use your real email address when you comment!

Failed to create the host-only network interface.

VBoxNetAdpCtl: Error while adding new interface: 
failed to open /dev/vboxnetctl: No such file or directory.

Result Code: NS_ERROR_FAILURE (0x80004005)
Component: HostNetworkInterface
Interface: IHostNetworkInterface {87a4153d-6889-4dd6-9654-2e9ff0ae8dec}

I haven’t seen this error before. I have checked if “/dev/vboxnetctl” exists, and unfortunately it doesn’t. It’s obvious that the “vboxnetctl” file should be a part of VirtualBox software but it wasn’t there. One of the good thing of VirtualBox is, you can do everything using command line. So I tried to add host-only network using command line, and this time I see “a warning message” before the error:

gokhan@genesis:~/Desktop$ sudo VBoxManage hostonlyif create

WARNING: The vboxdrv kernel module is not loaded. Either there is no module
         available for the current kernel (3.5.0-26-generic) or it failed to
         load. Please recompile the kernel module and install it by

           sudo /etc/init.d/vboxdrv setup

         You will not be able to start VMs until this problem is fixed.
0%...
Progress state: NS_ERROR_FAILURE
VBoxManage: error: Failed to create the host-only adapter
VBoxManage: error: VBoxNetAdpCtl: Error while adding new interface: 
failed to open /dev/vboxnetctl: No such file or directory

As you see, vboxdrv kernel module is not loaded because it doesn’t work with the current kernel of my system. So I need to recompile vboxdrv kernel modules. When I run the “/etc/init.d/vboxdrv setup”, I get another error because the kernel headers for my current kernel are not installed:

* Stopping VirtualBox kernel modules                                    [ OK ] 
 * Uninstalling old VirtualBox DKMS kernel modules                       [ OK ] 
 * Trying to register the VirtualBox kernel modules using DKMS                  
Error! Your kernel headers for kernel 3.5.0-26-generic cannot be found.
Please install the linux-headers-3.5.0-26-generic package,
or use the --kernelsourcedir option to tell DKMS where it's located

 * Failed, trying without DKMS
 * Recompiling VirtualBox kernel modules                                        
 * Look at /var/log/vbox-install.log to find out what went wrong

So I installed the kernel headers and re-compile VirtualBox kernel modules:

gokhan@genesis:~/Desktop$ sudo apt-get install linux-headers-3.5.0-26-generic
...
gokhan@genesis:~/Desktop$ sudo /etc/init.d/vboxdrv setup
 * Stopping VirtualBox kernel modules                                    [ OK ] 
 * Uninstalling old VirtualBox DKMS kernel modules                       [ OK ] 
 * Trying to register the VirtualBox kernel modules using DKMS           [ OK ] 
 * Starting VirtualBox kernel modules                                    [ OK ]

After the kernel modules started, I re-tried to add “Add Host-Only Network” and it worked successfully.

The authors of the book (Dhananjay Papde, Tushar Nath and Vipul Patel) are experienced on Oracle Fusion Middleware, so you’ll also be able to find the integration of Oracle Fusion Middleware products such as Oracle Business Intelligence, Oracle GoldenGate, Oracle Business Intelligence Publisher and Oracle WebLogic. The book also covers recipes on Incident and Problem Management using iPhone or iPad, and there are recipes for creating and cloning databases and creating templates.

List of the chapters:

1. Prerequisites of OEM 12c Installation: This chapter covers hardware and OS requirements (user and groups, packages, kernel parameters), installing the Oracle 11gR2 RDBMS software and creating OEM repository database.
2. Installation of OEM 12c: You will see how to install Enterprise Manager System with Simple and Advanced configuration options. This chapter also covers various Agent deployment methods.
3. Upgrade to OEM 12c: If you want to upgrade your OEM 10g/11g to OEM 12c, this chapter shows how to upgrade using the 1-system and the 2-system upgrade approach.
4. Configuring OEM 12c: Automatic discovery, promoting discovered targets, adding host (and non-hosts) targets manually, configuring a software Library are shown in this chapter.
5. Managing Oracle Database Using OEM 12c: This chapter explains how to configure a database target, create database templates and creating Oracle Database clones and provisioning Oracle Database software.
6. Managing Database Performance Using OEM 12c: This chapter shows how to use Active Session History Analytics, the Real-Time ADDM and compare period reports.
7. Middleware Management Using OEM 12c: You can find the required information to manage Oracle Business Intelligence, Oracle GoldenGate and Weblogic Server targets using Oracle Enterprise Manager 12c.
8. Incident and Problem Management Using an iDevice: This chapter explains how to set up OEM12c and use incident management on an iDevice (iPhone, iPod Touch, or iPad).

In ebook PDF version, the screen images are blur. I think Packt can fix this if you contact them. I prefer to read the books on ipad, and the screen images are readable in epub (ipad) version. On the other hand, all steps are detailed so it’s easy to follow the instructions and complete the tasks.

I recommend all Enterprise Manager users to buy “Oracle Enterprise Manager 12c Administration Cookbook“.

Here’s the SQL script (rmanfind.sql) to query RMAN backups. Our customer takes archive log backups during the day, so I needed to state full backup jobs while querying.

SET HEA OFF
SET FEED OFF
SET LINES 500
SET PAGES 500
SET TRIM ON

SELECT handle
from V$BACKUP_PIECE
where rman_Status_stamp IN (
select  stamp from V$RMAN_STATUS where parent_stamp =
 (SELECT session_stamp
from V$RMAN_BACKUP_JOB_DETAILS
where start_time =
(select max(start_time) from 
V$RMAN_BACKUP_JOB_DETAILS where input_type = 'DB FULL')));

The bash script (rmanftp.sh) can divided to 3 parts. In first part, the required credentials and environment variables are defined. On second part, rmanfind.sql is called. On last part, the resultset is processed and files are uploaded via FTP:

#!/bin/bash

#---------------------------------------------------------------------
# rmanftp (C) 2013 Gokhan Atil http://www.gokhanatil.com
#---------------------------------------------------------------------

# Required Info to Connect Oracle
. oraenv <<EOF
ORCL
EOF
ORACLE_CREDENTIALS=gokhan/atil

# Required Info to Connect FTP Server
TARGETSERVER=192.168.0.10
FTPUSER=oracle
FTPPASS=oracle
TARGETDIR=DAILY_BACKUP

# Query Latest Backup
SENDFILES=(`$ORACLE_HOME/bin/sqlplus -s $ORACLE_CREDENTIALS @rmanfind.sql`)

COUNT=${#SENDFILES[*]}
IDX=0
SENDTHEMALL=''

while (( $IDX < $COUNT ))
do
LOCALPATH=`echo ${SENDFILES[$IDX]} | sed 's|\(.*\)/.*|\1|'`
FILENAME=`echo ${SENDFILES[$IDX]} | sed 's|.*/\(.*\)|\1|'`
SENDTHEMALL="${SENDTHEMALL}lcd $LOCALPATH\n"
SENDTHEMALL="${SENDTHEMALL}put $FILENAME\n"
IDX=$(($IDX+1))
done

# Convert Newlines to Enters?
FTPCMD=`echo -e $SENDTHEMALL`

# Upload Files
ftp -d -n $TARGETSERVER <<EOF
user $FTPUSER $FTPPASS
cd $TARGETDIR
bin
$FTPCMD
bye
EOF

Here are the important parts of the script:

Line 20: The resultset returned from SQL Plus is put into an array variable. Be careful about the brackets.
Line 22: How many rows we have?
Line 26: A while loop starts here to processes all rows in the result set.
Line 30-31: I extract the path and file name because ftp client does not support full path names. So I create “cd” and “put” commands for each backup piece.
Line 36: SENDTHEMALL variable has newline (\n) characters but when I put it directly to EOF block, these newline characters are not honored, so I call “echo -e” and assign the result to FTPCMD variable.
Line 43: FTPCMD contains ftp commands such as “lcd XXXXX put YYYYY”.

Anyway, in this blog post, I’ll describe how to manually remove Enterprise Manager Grid/Cloud Control Agent and then enable Enterprise Manager Database Control on the target system. First we need to stop the agent:

$AGENT_HOME/bin/emctl stop agent

If your Cloud Control is up, we need to remove agent. Login as oracle user and run the following commands:

emcli login -username=SYSMAN
emcli sync
emcli delete_target -name="targetsystem.testdomain.com:1836" \
-type="oracle_emd" -delete_monitored_targets

If you have Grid Control 10g/11g, then login to the repository database as SYSMAN and execute the following:

exec mgmt_admin.cleanup_agent('targetsystem.testdomain.com:3872');

Now we’re ready to uninstall the agent software. Run the installer:

export ORACLE_HOME=export ORACLE_HOME=/u01/app/agent/core/12.1.0.2.0
$ORACLE_HOME/oui/bin/runInstaller -deinstall -removeallfiles

Click “deinstall products..” button to see Inventory (installed Oracle products on the server). For Grid Control Agents, all you need is to select agent home and click “Remove”. For Cloud Control Agents, you need to first select and remove plug-in homes (OraHome1..5), then select and remove sbin12cX home, and lastly select and remove agent home.

After we uninstall the agent, we’re ready to reconfigure Enterprise Manager Database Control. All you need is to run the following command. It will ask us to enter some information such as the Database SID, listener port number, passwords of SYS, DBSNMP and SYSMAN users:

emca -config dbcontrol db -repos recreate

After a few minutes, you’ll see that Database Control is up.