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



Linux 101 Hacks - Free eBook

If you are working with Linux or you are just Linux fan you will be probably interested in new Free eBook named "Linux 101 Hacks" released on The Geek Stuff server. The book contains 12 chapter which brings 101 tips and tricks for beginers but also experienced users could find some useful things there.
Use this link http://www.thegeekstuff.com/2009/02/linux-101-hacks-download-free-ebook/ to download this free eBook.

Posted on Saturday, February 14, 2009 Comments [0]


Exploring and playing with NAS Raidon SL3620-2S-LB2

I needed some lowcost NAS for Oracle especially for a shared storage for RAC.
So I was searching for some product which would meet all my requirements such as Gigabit Ethernet, RAID 0 and 1 capability, EXT2, 3 support and of course support for SATA drives.
I found Raidon SL3620-2S-LB2 and I bought it because it met all of my needs.




I putted in two SATA 750GB drives and created RAID 1 without problems as Web based console is very intuitive. I setted up the NFS mount for RAC but unfortunatelly I was unable to set specific parameters for RAC such as no_root_squash using Web console.
This parameter is needed to allow to change ownership for files and directories (more info).
So If you are installing RAC on NFS and you aren't able to create voting files(disks) during CRS installation or you are getting "chown: changing ownership of `...': Operation not permitted" then missing no_root_squash will be probaly the reason.

So I checked (using nmap) which ports are open on NAS.

# nmap -nsS 192.168.1.1|egrep 'PORT|open'
PORT STATE SERVICE
80/tcp open http
111/tcp open rpcbind
917/tcp open unknown
2006/tcp open invokator
2049/tcp open nfs

So no Telnet nor SSH service is running on my NAS.

So I used one of my utilities to explore all directories and files on web server.

Gotcha! I found http://192.168.1.1/cgi/telnet/telnet.cgi which is not able to find in Web Console. This page (script) can be used to enable or disable telnet daemon.

Now we check the nmap output again:

# nmap -nsS 192.168.1.1|egrep 'PORT|open'
PORT STATE SERVICE
23/tcp open telnet
80/tcp open http
111/tcp open rpcbind
917/tcp open unknown
2006/tcp open invokator
2049/tcp open nfs

Heureka, there is telnet service running.
Now I could try to logon using telnet with credentials for "admin".

$ telnet 192.168.1.1
Trying 192.168.1.1...
Connected to 192.168.1.1.
Escape character is '^]'.

mystore login: admin
Password:

BusyBox v1.00-rc3 (2007.05.09-07:20+0000) Built-in shell (ash)
Enter 'help' for a list of built-in commands.

mystore> uname -a
Linux mystore 2.6.15 #136 Wed Jun 27 13:16:02 CST 2007 armv4l unknown

According to banner it is clear that this NAS is running on Linux (2.6.15 kernel) and well known BusyBox project http://www.busybox.net on ARM processor.

So I could to use "vi" to modify /etc/exports file to add parameters for NFS export. But first I needed to login as root user which has the same password as admin.

mystore> cat /etc/exports
# /mnt/IDE1 *(rw,no_root_squash,no_all_squash,sync)
/mnt/md1/storage *(rw,no_root_squash)

Due this change I was able to install RAC succesfully.
Of course I'm going deeper because I want to install SSH (I hate telnet) and ISCSI target.
If my installation will be succesfull then I'll try to compile latest kernel to add OCFS2 and Brtfs (experimental but included since 2.6.28) support (I don't know yet whether it is possible to replace kernel). My next update may come soon...

Posted on Friday, February 06, 2009 Comments [2]


New HW for my blog

My blog was unaccessible few days due HW failure (HDD has gone after power failure(...yes we are using UPS :-D )).
Me and my friends made a decision to say bye to our old HW and say hello to new one.

Old machine specification:


# cat /proc/cpuinfo |egrep 'processor|model\ name'
processor : 0
model name : AMD Athlon(tm) XP 2400+

# free|grep Mem|awk {'print $1$2'}
Mem:1034836


New machine specification:

# cat /proc/cpuinfo |egrep 'processor|model\ name'
processor : 0
model name : Intel(R) Xeon(TM) CPU 2.40GHz
processor : 1
model name : Intel(R) Xeon(TM) CPU 2.40GHz
processor : 2
model name : Intel(R) Xeon(TM) CPU 2.40GHz
processor : 3
model name : Intel(R) Xeon(TM) CPU 2.40GHz

# free|grep Mem|awk {'print $1$2'}
Mem:3115900

Personally I like AMD but you can see the difference...

Posted on Wednesday, February 04, 2009 Comments [0]