About me

Name: Ivan Kartik
Location: Bratislava, Slovakia
I'm working as Senior Database Administrator in Bratislava, Slovak Republic. My interests are in RDBMS mainly Oracle, Unix (like) operating systems and in free time I am watching or playing ice-hockey, also I like to play golf.

[contact me]


Oracle (favourite) links

Oracle Technology Network
OTN Forums
Oracle Documentation
Ask Tom


Linux (favourite) links

Linux.com Portal
Linux section on OTN
The Linux Documentation Project


Favourite Blogs

Nicolas Gasparotto
Hans Forbrich
Jonathan Lewis
Frits Hoogland
H.Tonguç YIlmaz
Laurent Schneider
Christopher Jones
Jeff Hunter
Oracle WTF


My install articles

9i
Oracle 9i(R2) on Fedora 2,3,4,5,6
Oracle 9i(R2) on Enteprise Linux 4
Oracle 9i(R2) on SuSE 9.x,10.1
10g
Oracle 10g(R2) on EL and RH EL 3,4,5
Oracle 10g(R2) on Fedora 2,3,4
Oracle 10g(R2) on SuSE 9.x
Oracle 10g(R2) on Solaris 10 x86
11g
Oracle 11g(R1) on EL and RH EL 4,5
Oracle 11g(R1) on SLES10 and OpenSuSE
Oracle 11g(R2) on Solaris x86(64)


Downloads

rlwrap for Fedora (x86)
rlwrap for Redhat (x86)
rlwrap for SuSE (x86)
rlwrap for Redhat (x86_64)
rlwrap for Suse (x86_64)
rlwrap for Solaris 10 (x86)
readline for Solaris 10 (x86)
rlwrap for Solaris (SPARC 64)
readline for Solaris (SPARC 64)


Archives

January 2010
December 2009
November 2009
February 2009
January 2009
May 2008
April 2008
March 2008
February 2008
January 2008
December 2007
September 2007
August 2007
July 2007
April 2007
March 2007
February 2007
December 2006
November 2006
October 2006
September 2006
July 2006



First installation of 11g

I found some free time (not so much in these days) to try fresh release of Oracle Database 11g (released few days ago).
So I took some free machine with certified Linux and downloaded 1.7 GB installation archive from well known site. Then I've installed all required packages (surprise #1: some of the RPM packages aren't required anymore).
At first look nothing has changed in OUI (just background image).
Installation went without problems and the SW was installed in a while.

I noticed that diag directory has been created in my $ORACLE_BASE directory but I didn't pay attention to it for that moment.
After succesfull install I've decided create the database manually, so I created my own init.ora with common parameters along with other files (as orapw file and custom database creation script). Issued "startup nomount" and as usually watched output from "tail -f alert.log" in other terminal. Suddenly there new message appeared in output (suprise #2):
"Thu Aug 16 17:22:41 2007
WARNING: The background_dump_dest init.ora parameter has been deprecated.
WARNING: Please remove the background_dump_dest parameter from the init.ora
file.
WARNING: The diagnostic_dest init.ora parameter now determines the location of
the diagnostic data
WARNING: The new location for the background logs and traces is /opt/oracle/diag/rdbms/orcl/ORCL/trace
Thu Aug 16 17:22:41 2007
WARNING: The user_dump_dest init.ora parameter has been deprecated.
WARNING: Please remove the user_dump_dest parameter from the init.ora file.
WARNING: The diagnostic_dest init.ora parameter now determines the location of
the diagnostic data
WARNING: The new location for the user logs and traces is /opt/oracle/diag/rdbms/orcl/ORCL/trace
".

Time to check the New Features Guide... I found that background_dump_dest and user_dump_dest were replaced by new parameter diagnostic_dest (yes, the diag directory...).
So I changed the parameters, started instance and created the database and EM repository.
I found that alert.log is not plan text anymore but it became little "well formed" - so now it is XML (surprise #3).
But there is still option how to read alert.log as plain text. For this purpose here is new utility adrci which has many features and of course this one.
So instead of
tail -f alertORCL.log
you need now execute following:

[oracle@ika ~]$ adrci
ADRCI: Release 11.1.0.6.0 - Beta on Mon Aug 16 22:01:28 2007
Copyright (c) 1982, 2007, Oracle. All rights reserved.
ADR base = "/opt/oracle/admin"
adrci> show alert -tail -f


One thing that I don't understand is why Oracle guys made the adrci utility comfortable such as SQL*Plus (I mean not so comfortable). Well another tool for good old rlwrap.
Btw look at the banner:

ADRCI: Release 11.1.0.6.0 - Beta on Mon Aug 16 22:01:28 2007.

Maybe Oracle guys forgot something (maybe not but it is little surprising when the "Beta" word occurs in final release).

Oracle 11g brings new features (and of course EM got face lifting too :-D ) so don't wait and check the New Features Guide.

As usually, I have prepared the installation paper. It's valid for Enterpise
Linux 4,5 (shipped by Oracle) and also for Redhat Enterprise Linux 4 and 5.
You can find it here:http://ivan.kartik.sk/oracle/install_ora11gR1_elinux.html (and of course in the right menu of this page).

Posted on Monday, August 20, 2007 Comments [4]


Oracle 11g release 1 (for Linux) available for download

Finally, Oracle 11g release 1 for Linux x86 is available for download here: http://www.oracle.com/technology/software/products/database/index.html.
Enjoy it!

Posted on Friday, August 10, 2007 Comments [0]