CCL Home Page
Up Directory CCL RH6.2-CDPACK
ORACLE 8.1.7.0.1 install for Linux

Oracle 8.1.7.0.1 for RedHat Linux 6.2

These are my notes (jkl@ccl.net, Jan Labanowski) on installing Oracle 8.1.7.0.1 for Linux on Pentium III computer with 256MB of memory, with 2 256M swap partitions (SwapTotal: 385440 kB as given by: cat /proc/meminfo). I am using RH Linux 6.2 with current updates (as of Feb 15, 2001) I am using GNOME as my desktop environment in X-windows. Please send me (jkl@ccl.net) corrections and comments about the stuff which is fuzzy and hard to follow, so I can make it better. Thank you in advance... Disclaimer: All below is a nonsence. If you want to learn the truth, hire a competent lawyer. They will tell you what is right for a fee.

Installing RH6.2 Linux

Booted from the CD Nr. 1 in the Linux 6.2 distribution (CD Version: 10539-1) and hit Enter. Since I also have a Adaptex SCSI controller on board, it loaded driver aic7xxx. Then showed the the GUI. I chose English, Generic 101PC Keyboard Model with US ENglisg/ISO 9995-3 layout., enabled dead keys, and 3 button PS/2 mouse. My partitions were done before, on previous install with fdisk: Device Boot Start End Blocks Id System Mount Point /dev/hda1 * 1 1023 8217216 c Win95 FAT32 (LBA) /win /dev/hda2 1024 1040 136552+ 83 Linux /boot /dev/hda3 1041 1171 1052257+ 83 Linux /ftp /dev/hda4 1172 3720 20474842+ 5 Extended /dev/hda5 1172 1204 265041 82 Linux swap swap /dev/hda6 1205 1237 265041 82 Linux swap swap /dev/hda7 1238 3720 19944666 83 Linux / So I did not bother them, but just assigned /boot, /ftp, and / to them on the page by clicking on Edit after highlighting a partition. Then chose Time zone, Root password (did not create any users at this time). CHose no MD5 pass, but enabled shadow passwords. The packages I chose were: * Printer Support * Samba server * X Window * Anon FTP * Gnome * Web Server * KDE * SQL Server/Postgress * Mail/WWW/News Tools * Network Management Workstation * Dos/Windows connectivity * Authoring/Publishing * Graphic Manipulations * Emacs * Multimedia Support * Development * Networked Workstation * Kernel development * Dial up Workstation * Utilities. * NFS Connectivity My monitor is Cornerstone c1025. It is not on the list, so I took default "DDC Probed Montor/CRN0018, and entered: 30-95 kHz as horizontal scan, and 50-160 Hz as vertical sync (from the monitor manual book). I have ATI XPERT 98 PCI with 8Megs, so I clicked on ATI Xpert 98, 8192k, [Test this configuration], checked [Customize X Config]. I said Yes on the next test screen asking me if I can see the question. In Customize X screen I chose 1280x1024 16 bits as my resolution settings. It installed all packages, but froze on me when creating boot diskette. I rebooted the machine from CD, but chose UPGRADE (not the INSTALL) on the screen which asked for type of installation. Clicked on Next, which got me to Installing 118 Packages. Then, it created the Boot Diskette. Then I removed CD and Diskette and computer rebooted. It went through fsck to repair the disk left with bad inodes after it froze during install. When I logged in, and did startx the X was at wrong resolution and wrong sync. I used Xconfigurator to fix it. It never wanted to ask me for the amount of memory on the video card, so I had to do [Back] several times at the X Configuration screen to get to the appropriate screen.

Getting Oracle and Docs

I went to Oracle Store, and bought the CD PACK for Linux Intel. It came with a lot of CDs (16 to be exact). Then I did exactly what they wanted. I put a 1st CD "Start Here" in: mkdir /cdrom chmod 777 /cdrom # if you put CD in, it will usually mount itself as /mnt/cdrom # So you need to unmount it, if you want to do what they want umount /mnt/cdrom mount -t iso9660 /dev/cdrom /cdrom Then I fired my Netscape browser with the URL: file:///cdrom/welcome.html The "Start Here" CD does not really have any information on it (it has only 122 kBytes of data on it). They suggest that you read their Installation manual for the product. This is what I did. I went to documentation site http://otn.oracle.com/docs/index.htm and kept downloading PDF files until I filled up my disk {:-)}. I probably did not have to do it, since they have the "Oracle 8i On-Line Generic Documentation CD-ROM. Release 3 (8.1.7)." I then burned a CD with all this stuff for my personal use (it would be a crime to give it to someone!!!), so I do not have to download it again and again... Then I unmounted the CDROM and removed it cd umount /cdrom Beside the "official" Installation Manual from Oracle, I also looked for the docs on the web, and found: http://jordan.fortwayne.com/oracle/817.html (my local copy is here) which I am following closely here (great page), and http://www.zx81.org.uk/computing/oracle/oracle-howto/oracle-howto.html (my local copy is here) which is slightly out of date by full of great ideas and prescriptions when you actually want to use Oracle.

Getting some upgrades for Red Hat Linux 6.2

First, I installed a utility called wget. It allows retrieving files from Web and Anon FTP easily on a command line. I got it from the original RH6.2 CD Number 1. Somehow, it was not installed as default: a) Put your RH CD1 in the drive b) wait until it is mounted itself [DO NOT RUN AUTORUN!!!] c) check iif it is mounted (df -k will list /mnt/cdrom). d) If did not mount bu itself, do mount /mnt/cdrom Then install it: rpm -Uhv /mnt/cdrom/RedHat/RPMS/wget-1.5.3-6.i386.rpm I went to ftp.rpmfind.net late at night (whey US sleeps, and Europe did not wake up yet ) and retrieved the updates: ftp ftp.rpmfind.net Name: anonymous Password: quest cd linux/redhat/updates/6.2 binary prompt !mkdir i386 lcd i386 cd i386 mget * !mkdir ../i586 lcd ../i586 cd ../i586 mget * !mkdir ../i586 lcd ../i586 cd ../i586 mget * !mkdir ../i686 lcd ../i686 cd ../i686 mget * !mkdir ../i686 lcd ../i686 cd ../i686 mget * !mkdir ../SRPMS lcd ../SPRMS cd ../SRPMS get kernel-2.2.17-14.src.rpm To tell you the truth, I burned a CD with this stuff, since I have 6 PCs to update. And it is so much easier than copying and downloading several times the same thing. You can get the updates from the RedHat itself, ftp://updates.redhat.com but this site is usuall overbooked. So go to the list of mirrors http://www.redhat.com/download/mirror.html and pick up the one which is not under siege. The first update I made was to update the updating package, i.e., RPM. In my case, as you remember, I have it on the CD. cd /mnt/cdrom/6.2/i386 rpm -Uhv rpm* I also needed badly the ssh. And to compile ssh, I needed openssl. While there is a newer openssl out there, I took the older one from the Red Hat updates RPM, so it is known as a RPM package to the system, since other RPMs are dependent on it. I also installed pam, since ssh needs it. cd /mnt/cdrom/6.2/i386 rpm -Uhv openssl* rpm -Uhv pam* Now, I took the OpenSsh cd /root/updates wget ftp://ftp.eecs.umich.edu/pub/OpenBSD/OpenSSH/portable/openssh-2.3.0p1.tar.gz tar zxvf openssh-2.3.0p1.tar.gz cd openssh-2.3.0p1 Looked at INSTALL file and did ./configure make make install PATH=${PATH}://usr/local/bin export PATH

Updating packages

Before updating kernel, I installed all updates but kernel itself.

Updating other packages

Note that it is assumed that openssl and pam are already installed as described above. cd /mnt/cdrom/6.2/i386 rpm -Uhv SysVinit* rpm -Uhv apache-* rpm -Uhv bash* rpm -Uhv ed* rpm -Uhv emacs* rpm -Uhv esound* rpm -Uhv fetchmail* rpm -Uhv gdm* rpm -Uhv ghostscript* rpm -Uhv glibc* rpm -Uhv gnorpm* rpm -Uhv gnu* rpm -Uhv gpm* rpm -Uhv imap* rpm -Uhv inetd* rpm -Uhv iputils* rpm -Uhv joe* rpm -Uhv krb* rpm -Uhv libtiff* rpm -Uhv lpr* rpm -Uhv mailx* rpm -Uhv man* rpm -Uhv mgetty* rpm -Uhv mod_perl* rpm -Uhv modutils* rpm -Uhv mutt* rpm -Uhv ncurses* rpm -Uhv netscape* rpm -Uhv nfs-utils* rpm -Uhv nscd* rpm -Uhv openldap* nss_ldap* rpm -Uhv perl* rpm -Uhv php* rpm -Uhv pine* rpm -Uhv popt* rpm -Uhv python* rpm -Uhv rmt* rpm -Uhv samba* rpm -Uhv slocate* rpm -Uhv sysklogd* rpm -Uhv tcsh* rpm -Uhv textutils* rpm -Uhv tmpwatch* rpm -Uhv traceroute* rpm -Uhv transfig* rpm -Uhv umb-scheme* rpm -Uhv wu-ftpd* rpm -Uhv xchat* rpm -Uhv xpdf* rpm -Uhv up2date* usermode* ../noarch/*.rpm Then, I rebooted the machine.

Updating the kernel for Red Hat Linux 6.2

The updates contained also a newer kernel (the kernel which I originally installed was: 2.2.14-5.0. You can check your kernel version with uname -a The latest Red Hat kernel update is 2.2.17-14. The latest kernel 2.2.X on the http://www.kernel.org/pub/linux/kernel/v2.2/ site is 2.2.18. I decided to go with the 2.2.18 upgrade from http://www.us.kernel.org/pub/linux/kernel/v2.2/linux-2.2.18.tar.gz I first saved the sources, binaries, and config files of the 2.2.14-5.0 kernel just in case. Before you start upgrading the kernel, you should read the piece "Upgrading the Linux Kernel on Red Hat Linux Systems" which is available from: http://www.redhat.com/support/docs/howto/kernel-upgrade/kernel-upgrade.html. This were my actions:

Save/Backup whatever you can...

cd /usr/src # remove link to linux-2.2.14 rm linux # make a copy of /boot dir mkdir /boot-old cd /boot tar cvf - . | ( cd /boot-old; tar xvf - ) mkdir /etc-old cd /etc tar cvf - . | ( cd /etc-old; tar xvf - )

Make boot-up/rescue disk

First check what is your current kernel and enter its version for mkbootdisk uname -r fdformat /dev/fd0H1440 mkbootdisk --device /dev/fd0H1440 2.2.14-5.0 I rebooted the computer with a dikette in the drive to see that disk really works.

Saving old configuration

I was running X. To make sure that my option for the working kernel will be passed over to the new build, I saved the old kernel options: cd /usr/src/linux-2.2.14 make xconfig # pushed Store Configuration to File # /root/config-2.2.14-5.0 # pushed Quit Without Saving I also copied a file from configs directory: cp /usr/src/linux-2.2.14/configs/kernel-2.2.14-i686.config /root Quite frankly, I am not sure which one corresponds to the config of the Kernel which came with the distribution. The differences between them are quite minor: diff config-2.2.14-5.0 kernel-2.2.14-i686.config 13c13 < CONFIG_M386=y --- > # CONFIG_M386 is not set 18,21c18,27 < # CONFIG_M686FX is not set < # CONFIG_X86_PN_OFF is not set < # CONFIG_X86_FX is not set < # CONFIG_X86_CPU_OPTIMIZATIONS is not set --- > CONFIG_M686FX=y > CONFIG_X86_WP_WORKS_OK=y > CONFIG_X86_INVLPG=y > CONFIG_X86_BSWAP=y > CONFIG_X86_POPAD_OK=y > CONFIG_X86_TSC=y > CONFIG_X86_GOOD_APIC=y > CONFIG_X86_PN_OFF=y > CONFIG_X86_FX=y > CONFIG_X86_CPU_OPTIMIZATIONS=y 38c44 < # CONFIG_BIGMEM is not set --- > CONFIG_BIGMEM=y 83,86d88

Upgrading Linux kernel

I retrieved new kernel to /usr/src directory from the standard www.country.kernel.org site, in my case www.us.kernel.org. The latest was: 2.2.18: cd /usr/src wget http://www.us.kernel.org/pub/linux/kernel/v2.2/linux-2.2.18.tar.bz2 Then I unpacked it as (make sure that linux link is deleted from /usr/src): cd /usr/src tar Ixvf linux-2.2.18.tar.bz2 mv linux linux-2.2.18 ln -s linux-2.2.18 linux While obviously, this is the virgin source, I still go by the book: cd /usr/src/linux make mrproper make xconfig The last one brought a GUI. I clicked first on the [Load Configuration from File] and entered /root/kernel-2.2.14-i686.config as a file. In another terminal window I did: diff /usr/src/linux/arch/i386/defconfig \ /root/kernel-2.2.14-i686.config | more To see what are the differences between default settings of the virgin kernel and the RedHat settings. Then I went through the options to see what they say and change some. I first clicked at the upper leftmost button [Code Mature] and than at [Next] button of each table. I made changes indicated with the ***********. You probably should leave the original defaults, if you are using different hardware (namely motherboard) than I do. I use: ASUS P3V133. It has the VIA VT82C596B PCI to ISA bridge and also all this USB stuff which I do not use. Code Maturity Prompt for development: Y Processor type PPro Processor Family /dev/cpu/microcode - Intel P6 CPU microcode: M /dev/cpu/*/msr - Model specific register support: N /dev/cpu/*/cpuid -- CPU info support: N 1GB Max Physical Memory Math Emulation: Y MTRR: Y Symmetric Multiprocessing: N Loadable Module Support Enable loadable: Y Set version info on all symbols: Y Kernel module loader: Y General Setup: Networking: Y PCI support: Y [Any] PCI Access Mode: ANY PCI quirks: Y PCI bridge optimization: N Backward compatible /proc/pci: Y MCA Support: N SGI SUpport: N System V IPC: Y BSD Process Accounting: Y Sysctl: Y Kernel support for a.out: M Kernel support for ELF: Y Kernel support for Misc: Y Kernel support for Java Binaries: M Parallel port Support: M PC-style hardware: M Support for Foreign hardware: N Advvanced Power Management BIOS support: Y Ignore USER SUSPEND: N Enable PM at boot time: N Make CPU Idle calls when idle: N Enable console blanking using APM: N RTC stores time in GMT: Y Allow interrupts during APM BIOS calls: N Use real mode APM Bios call to power off: N Toshiba Laptop Support: N Plug and Play support Plug and Play support: Y Auto-probe for Paralle devices: M Block Devices Floppy: Y Enhanced IDE: Y Use old disk: N Include IDE/ATA-2: Y Include IDE/ATAPI CDROM: Y Include IDE/ATAPI Tape: M Include IDE/ATAPI Floppy: M Include SCSI emulation: M CMD640 chipset: Y CMD640 enhanced support: N RZ1000 chipset: Y Generic PCI IDE: Y Generic PCI bus-master: Y Generic PSI bus-master DMA support: Y Boot off-board chipsets first support: N Use DMA by default when available: Y ********** OPTi82C621 chipset: N ALI15X3 chipset: N Tekram TRM290 chipset: N NS87415 chipset: N VIA82 C586 chipset: Y ********** CMD646 chipset: Y Cyrix CS5530 MediaGX chipset: N Other IDE chipset: N Additional Block Devices: M Network block device: M Myltiple device driver support: Y Linear mode: M RAID-0: M RAID-1: M RAID-4/5: M RAM disk support: Y Default RAM disk size: 4096 XT hard disk support: N ************ Mylex DAC960: M Parallel port IDE support: M Parallel IDE high level drivers Parallel port IDE disk: M Parallel port ATAPI CD-ROMS: M Parallel port ATAPI disks: M Parallel port ATAPI tapes: M Parallel port generic ATAPI devices: M Prallel IDE protocol modules ATEN EH-100: M MicroSolutions: M Data Store Commuter: M FIT TF-2000: M FIT TF-3000: M Shuttle EPAT/EPEZ: M Shuttle EPIA: M Freecom IQ ASIC-2: M Freecom powewr: M King Byte: M KT PHd: M OnSpec 90c20: M OnSpec 90c26: M Compaq SMART2: M Compaq CISS Array: N Networking options: Packet socket: Y Kernel/User netling: Y Routing messages: Y Netlink device emulation: Y Network firewals: Y Socket Filtering: Y Unix domain sockets: Y TCP/IP Networking: Y IP multicasting: Y Advanced router: N ... IP:kernel: N ... IP:firewalling: Y IP:firewall packed netling: Y IP:transparent proxy: Y IP:masquerading: Y Protocol-specific masquerading as modules IP:ICMP masquerading: Y Protocol-specifc masquerading support IP:masq special: Y IP:ipautofw: M IP:ipportwf: M IP:ip fwmark mask: M IP:optimize: N IP:tunnel: M IP:GRE: M IP: multicast routing: N ... IP:aliasing: Y IP:ARP: N IP: TCP syncookie support: Y IP: Reverse ARP: M IP: Allo large window: M The IPv6: N ........ The IPX: M IPX full internal IPX net: N IPX SPX network: N Appletalk DDP: M CCITT X.25: N LAPB: N Bridging: N Frame diverter: N 802.2 LLC: N Acorn: N ... WAN router: M Forwarding between high speed interfaces: N CPU is too slow to handle full bandwith: N QoS: None checked Telephony Support: Linux telephony support: M QuickNet Internet: M SCSI Support SCSI Support: Y SCSI disk support: Y SCSI tape support: M SCSI CD-ROM support: Y Enable vendor specific extensions: Y SCSI Generic Support: M Proble all LUNs on each SCSI device : Y Verbose SCSI Error: Y SCSI loggin: Y SCSI low-level drivers: 3ware Hardware: N 7000FASST: M ACARD SCSI: M Adaptec AHA152X: M Adaptec AHA1542: M Adaptec AHA1740: M Adaptec Raid: M Adaptec AIC7xxx: M Enable Tagged Command: N Max number of TCQ: 8 Collect Stats to report in /proc: Y Delay in seconds after SCSI reset: 5 IBM ServeRAID: M Advansys Support: M Advansys IN200: M AMI: M Buslogic: M Omit FlashPoint: N Compaq Fibre: N DTC3180: M EATA: M enable tagged command queueing: Y enable elevator sorting: N 16 Maximum number of queued commands EATA-DMA: M EATA-PIO: M Future DOmain: M GDT: M Generic NCR5380: M Enable NCR53c400 extensions: N PORT: NCR5380/53c400 mapping Initio 9100U: M Initio INI: M IOMEGA parallel ppa: M IOMEGA parallel imm: M ppa/imm option slow: N ppa/imm option assume slow: N NCR53c406a: M symbios 53c416: M Simple: 53c710: M ... and so on... Did not change anything. I2O device support I2O Support: N Network device support: Network device support: Y ARCnet: Dummy net driver: M Bonding: M EQL: M Ethertap: M General Instruments Surf: N Ethernet (10 or 100MBit) Ethernet (1000 Mbut) FDDI driver: Y Digital DEFEA: N SysKonnect FDDI PCI: M Hippi driver: N Appletalk devices PLIP: M PPP: M SLIP: M CSLIP: Y Keepalive: Y Six bit SLIP: Y Wireless LAN: Y STRIP: M ATT: M Airnet: M Token Ring Fibre Channel: Y Interphase: M RedCreek: M Traffic: M WAN interfaces SBNI12-xx: M ARCnet devices ARCnet support: N Ethernet (10 and 100Mbit) Ethernet: Y 3COM cards: Y 3c501: M 3c503: M 3c505: M 3c507: M 3c509/3c579: M 3c515 ISA: M 3c590/3c900: M AMD LANCE: M Wester DIgital/SMC cards: Y WD80*3 support: M SMC Ultra: M SMC Ultra32: M SMC 9194: M RacalInterlan: Y NI6010: M NI5210: M NI6510: M RealTek 8129: M RealTek 8139: N Other ISA: Y ATI70/1720: M Cabletron: M ... accepted all defaults Ethernet (1000MBit) Alteon: M Packet Engines GNIC-II: N Packet Engines Yellowfin: M SysKonnect: M Appletalk devices Took defaults Token Ring devices Took defaults Wan Interaces: Took defaults Amateur Radio Support: Amateur Radio: N IrDA support Defaults Infrared-port device drivers Defaults ISDN Subsystems Defaults ISDN Features Defaults ... Passive ISDN Defaults Active ISDN Defaults Old CDROM Drivers Defaults Character devices: Defaults Mice: ATIXL busmouse: M Logitech busmouse: M Microsoft busmouse: M PS2 Mouse: Y C&T 82C710 mouser: M PC1010 digitizer pad: M Joystick: Default Video for Linux Default Ftape, Floppy tape device: Default Watchdog card: Default I2C Support I2C Support: N Hardware sensors support none USB Support Support for USB: M USB verbose: N Miscelaneous USB Options Preliminary USB device filesystem: N Support for hot: N Enforce: N USB Controllers: UHCI: M UHCI Alternative: M OHCI: M USB Devices: USB printer: M USB Scanner: M USB Modem : M USB Serial Convertor: M USB Generic Serial Driver: N Filesystems Quota support: Y Kernet automounter: Y AFFS: N Amiga: N Apple: N DOS FAT: M MSDOS fs support: M UMSDOS Unix like: M VFAT: M ISO9660: Y MS Joiliet: Y Minix: N NTFS: M OS/2 HPFS: M Network file systems: Coda: N NFS: Y NFS Version 3 support: Y NFS Server support: Y NFS Server Ver3 support: Y SMB: M Use a default NLS: N NCP: N Partition types: BSD: Y Macintosh : Y SMD: Y Solaris: Y Unixware: Y Native language support: Default: cp437 437: Y 737: M 775: M 850: M 852: M 855: N 860: N 861: N 862: N 863: N 864: N 865: N 866: M 869: M 874: N 932: N 936: N 949: N 950: N 8859-1: M 8859-2: M 8859-3: N 8859-4: N 8859-5: M 8859-6: N 8859-7: M Console Drvers VGA TEXT: Y Video mode selection: Y MDA: M SUpport for frame buffer: Y Permedia2: M ATI MAch64: M VESA VGA: N VGA 16: N Matrox acceleration: M Millenium: Y Mistique: Y G100/G200: Y Multihead: Y Sound SOund card Support: M Support for C-Media: M Enable legacy FM Enable legacy MPU-401 Crystal SoundFusion: M Creative SBLive: M Ensonic AudioPCI: M Creative Ensonic AudioPCI 97: M ESS Mastro: M ESS Maesto3: M Rest took defaults Additional low level sound: Additional low lever sound drivers: Y Took defaults Kernel hacking Magic SysRq Key: Y Then, at the end I clicked on: Main Menu, Store Configuration File: /root/kernel_config_1 Save and Exit Then, in the xterm window I ran: make dep Then I made the following changes in header files, as suggested on the page 2-2 of Oracle Installation Guide: cd /usr/src/linux/include/asm cp -p shmparam.h shmparam.h-orig and edited shmparam.h (the 0x8000000 is half of my memory in hex): #define SHMMAX 0x2000000 --> #define SHMMAX 0x8000000 (I have 256Megs, i.e. 0x10000000 of it and 0x8000000 is half) #define SHMMNI (1<<_SHM_ID_BITS) --> #define SHMMNI 100 #define SHMSEG SHMMNI --> #define SHMSEG 10 and then cd /usr/src/linux/include/linux cp -p sem.h sem.h-orig and edited sem.h: #define SEMOPM 32 --> #define SEMOPM 100 then edited the Makefile in /usr/src/linux and changed: EXTRAVERSION = --> EXTRAVERSION = -01 Now I was ready to build kernel and modules: cd /usr/src/linux make bzImage make modules make modules_install After doing this the directory /lib/modules/2.2.18-01 was created, as well as new kernel and System.map. I installed the files in /boot partition and made a RAM disk: cd /boot rm vmlinuz cp /usr/src/linux/arch/i386/boot/bzImage vmlinuz-2.2.18-01 ln -s vmlinuz-2.2.18-01 vmlinuz rm System.map cp /usr/src/linux/System.map System.map-2.2.18-01 ln -s System.map-2.2.18-01 System.map mkinitrd /boot/initrd-2.2.18-01.img 2.2.18-01 Now is time to fix lilo. I first edited /etc/lilo.conf to be: boot=/dev/hda map=/boot/map install=/boot/boot.b prompt timeout=50 linear default=linux image=/boot/vmlinuz-2.2.18-01 label=test initrd=/boot/initrd-2.2.18-01.img read-only root=/dev/hda7 image=/boot/vmlinuz-2.2.14-5.0 label=linux initrd=/boot/initrd-2.2.14-5.0.img read-only root=/dev/hda7 other=/dev/hda1 label=dos It will load new kernel when you type test after boot: prompt. Then I ran lilo to put these changes on hard drive. lilo -v This generated the following output: # lilo -v LILO version 21, Copyright 1992-1998 Werner Almesberger Reading boot sector from /dev/hda Merging with /boot/boot.b Boot image: /boot/vmlinuz-2.2.18-01 Mapping RAM disk /boot/initrd-2.2.18-01.img Added test Boot image: /boot/vmlinuz-2.2.14-5.0 Mapping RAM disk /boot/initrd-2.2.14-5.0.img Added linux * Boot other: /dev/hda1, loader /boot/chain.b Added dos /boot/boot.0300 exists - no backup copy made. Writing boot sector. Then I created a boot rescue diskette with a new kernel: cd /boot fdformat /dev/fd0H1440 mkbootdisk --device /dev/fd0 2.2.18-01 Then I silently prayed and rebooted the machines. During kernel recompilation I was greatly helped by the Kernel-HOWTO by Brian Ward ftp://sunsite.unc.edu/pub/Linux/docs/HOWTO/other-formats/html_single/Kernel-HOWTO.html (my local copy is here). I also used: http://www.redhat.com/support/manuals/RHL-7-Manual/ref-guide/s1-sysadmin-build-kernel.html and Jason Costomiris note on RedHat discussion list: http://www.linuxarkivet.nu/mlists/redhat-list/0009/msg02713.html (local copy is here).

Oracle Installation

Then I prepared for Oracle install.

Installing JDK1.1.8

Installed Java JDK1.1.8v3 for Linux from Blackdown taken from: (you may want to right click on these links if you do not have bz2 MIME type set) ftp://metalab.unc.edu/pub/linux/devel/lang/java/blackdown.org/JDK-1.1.8/i386/v3/jdk118_v3-glibc-2.1.3.tar.bz2. Local copy is here. I placed it in /tmp, and then unpacked it as: cd /tmp tar Ixvf jdk118_v3-glibc-2.1.3.tar.bz2 mv jdk118_v3 /usr/local cd /usr/local ln -s jdk118_v3 java

Creating accounts and groups for Oracle

Then I created needed users and groups groupadd oinstall groupadd dba groupadd oper useradd oracle -g oinstall -G dba,oper passwd oracle

Removing traces of previous failed installs of Oracle

Since I had oracle installed before, I deleted all traces of it namely: rm -rf /u01 rm /etc/oratab rm /etc/oraInst.loc Note, if you have a running/needed/usefull installation of Oracle on your system DO NOT DO THAT!!! Use Oracle GUI to do uninstall (the same which you used to install -- it is described below).

Directories and Environment Varialbles

Created directory for Oracle Install: mkdir /u01 chown oracle.dba /u01 Then I put the "Oracle 81 Enterprise Edition Release 3 (8.1.7) for Linux Intel and it mounted itself as /mnt/cdrom. I killed the directory gizmo which appeared on my Xwindow screen, I unmounted it and remounted it as /cdrom: umount /mnt/cdrom mount -t iso9660 /dev/cdrom /cdrom In the browser, I looked at URL file:///cdrom/index.htm and looked at release notes. Then I logged out as root, and logged in as user oracle, started Xwindow, created .bash_profile in /home/oracle as shown below: PATH=${PATH}:${HOME}/bin BASH_ENV=${HOME}/.bashrc USERNAME="oracle" export USERNAME BASH_ENV PATH JAVA_HOME=/usr/local/java export JAVA_HOME ORACLE_BASE=/u01/app/oracle export ORACLE_BASE ORACLE_HOME=${ORACLE_BASE}/product/8.1.7.0.1 export ORACLE_HOME ORACLE_SID=linux817 export ORACLE_SID PATH=${PATH}:${ORACLE_HOME}/bin:${JAVA_HOME}:/bin export PATH if [ "${LD_LIBRARY_PATH:-}" == "" ]; then LD_LIBRARY_PATH=${ORACLE_HOME}/lib:/usr/lib:/usr/local/lib else LD_LIBRARY_PATH=${ORACLE_HOME}/lib:${LD_LIBRARY_PATH} fi export LD_LIBRARY_PATH CLASSPATH=${JAVA_HOME}/lib/classes.zip export CLASSPATH You can find a copy of my .bash_profile here. Note that people usually use ORCL as ORACLE_SID. In my case it is: ORACLE_SID=linux817 After changing the file you have to do: . .bash_profile to actually set your environment variables, or log out and then log in again as user oracle.

Running Oracle Installer

Then I started Oracle install (as user oracle); cd /cdrom ./runInstaller The window appeared: Welcome with bunch of options. I clicked on [Next] File Locations Accepted the defaults on next window (Source and Destination Paths) since they came from myself (current directory and ORACLE_HOME environment variable) by clicking [Next]. Unix Group Name Unix Group Name: oinstall Clicked [Next] and it asked me to execute a script: /u01/app/oracle/product/8.1.7.0.1/orainstRoot.sh First, I checked the script for bugs... It looked fine to me. I opened the xterm and su - and as a root cd /u01/app/oracle/product/8.1.7.0.1 ./orainstRoot.sh It told me: Creating Oracle Inventory pointer file (/etc/oraInst.loc) Changing groupname of /u01/app/oracle/oraInventory to oinstall. I did not close the xterm since I will need it later on. Then I clicked on the [Retry] button in the pop off window. It then came with available product information window: Available Products I selected Oracle8i Enterprise Edition 8.1.7.0.1 and clicked [Next] Installation Types Accepted default Typical Installation (837 MB) and clicked [Next] Choose JDK Home Directory Since there is so much fuzz about Oracle not liking new JDKs, I accepted /usr/local/java which was a link to jdk118_v3 as described above. Database Identification I chose to use the linux817 for a name, and the Internet Name for my computer, i.e.: Global Database Name: linux817.mymachine.mycompany.com SID linux817 and clicked [Next] Summary It displayed a bunch of products to be installed. Impressive. I clicked on [Install] Install A window was was reporting installation progress. You can get a cup of coffee made now, since it takes time. It actually takes too much time... It just died in the middle of install (about 64% or something), and I woke it up by clicking on Help button. It displayed HELP and it started running again. BTW the HELP is for Windows, i.e., garbage (e.g. they tell you to look into "C:\Program Files" directory, and similar things). Oh well, it is only $40... You have got what you paid for. After about 30 minutes it popped off small window asking to run /u01/app/oracle/product/8.1.7.0.1/root.sh as root. I first opened the /u01/app/oracle/product/8.1.7.0.1/root.sh in an editor, since my previous experience was that this script has errors. The script is wrong... It is actually two scripts merged together. At line 63 we have: $ECHO "IMPORTANT NOTE: Please delete any log and trace files previously" $ECHO " created by the Oracle Enterprise Manager Intelligent" $ECHO " Agent. These files may be found in the directories" $ECHO " you use for storing other Net8 log and trace files." $ECHO " If such files exist, the OEM IA may not restart." #!/usr/bin/sh # # $Header # $Copyright # Then at line 102 we have RMF=/bin/rm -f which is obviously wrong since "/bin/rm -f" should be quoted: RMF="/bin/rm -f " and finally, at line 156 we have: RUID=`/usr/bin/id|$AWK -F\( '{print $2}'|$AWK -F\) '{print $1}` which should obviously be: RUID=`/usr/bin/id|$AWK -F\( '{print $2}'|$AWK -F\) '{print $1}'` I corrected the script and ran, but frankly, I am not sure I should have had. I wonder why they cannot run the damned thing before sending it to people who are potential customers. I must not be understanding modern marketing. Maybe they want to get "intimate" with the software. I opened the the xterm, logged as root and did: su - /u01/app/oracle/product/8.1.7.0.1/root.sh It displayed: IMPORTANT NOTE: Please delete any log and trace files previously created by the Oracle Enterprise Manager Intelligent Agent. These files may be found in the directories you use for storing other Net8 log and trace files. If such files exist, the OEM IA may not restart. Running Oracle8 root.sh script... \nThe following environment variables are set as: ORACLE_OWNER= oracle ORACLE_HOME= /u01/app/oracle/product/8.1.7.0.1 ORACLE_SID= linux817 Enter the full pathname of the local bin directory: [/usr/local/bin]: I entered Enter (i.e., took default). It told me: Entry will be added to the /etc/oratab file by Database Configuration Assistant when a database is created Finished running generic part of root.sh script. Now product-specific root actions will be performed. Then I clicked OK button in the small window, and the installation continued... It displayed the new window: Configuration Tools and was popping new windows for individual components to configure: Net8 Configuration Assistant: Welcome Selected Perform typical configuration and clicked [Next] (I actually once wanted to use the installer and configure Net8 manually -- the installer froze, and I had to delete everything and start anew. Maybe it was bad luck, but try ANYTHING custom in the installer with "extreme prejudice".) Database Creation Progress window (just showed progress). v- Creating and starting Oracle instance v- Copying database files v- Initializing database v- Database creation complete Then it displayed the window: Database creation completed. Database Information: global database name: jkl.mymachine.mycompany.com database system identifier (SID): linux817 SYS account password: change_on_install SYSTEM account password: manager I clicked OK button. Then it started the Apache web server and displayed: End of Installation clicked [Exit] (do not do Next Install, or you will waste your current install).

Starting Oracle

All instructions below assume that you are logged in as user oracle. DO NOT DO ANYTHING AS root, unless specifically instructed!!! I first saved all processes which were running as user oracle (or had some oracle somewhere in the command line). I saved them to file. There are a lot of processes which belonged to the GNOME desktop environment for XWindow. The ones belonging to installer have /cdrom/stage/Components... The lines with ora_*-linux817 are actually the components of Oracle server. The /u01/app/oracle/product/8.1.7.0.1/bin/tnslsnr LISTENER -inherit is a listener (i.e., the component which allows remote access to the database via clients or JDBC). The lines with: /u01/app/oracle/product/8.1.7.0.1/Apache/Apache/bin/httpd -d /u01/app are processes of Apache Web server. ps auwx | grep oracle > oracle_processes I am including the list of processes here. Then, it was time to test if the thing actually works. First logged in and logged out to sqlplus. $ sqlplus SQL*Plus: Release 8.1.7.0.0 - Production on Tue Mar 13 02:33:42 2001 (c) Copyright 2000 Oracle Corporation. All rights reserved. Enter user-name: sys Enter password: change_on_install Connected to: Oracle8i Enterprise Edition Release 8.1.7.0.1 - Production With the Partitioning option JServer Release 8.1.7.0.1 - Production SQL> quit Disconnected from Oracle8i Enterprise Edition Release 8.1.7.0.1 - Production With the Partitioning option JServer Release 8.1.7.0.1 - Production I.e., it logged me in, and logged me out... Good... I stopped the database: svrmgrl connect internal shutdown quit I was nicely surprized that the errors which showed up in the Oracle 8i EE 8.1.7.0.0 Web downloadable version (my log of installation is available here) were not here anymore. The stuff produced on the screen is given below. $ svrmgrl Oracle Server Manager Release 3.1.7.0.0 - Production Copyright (c) 1997, 1999, Oracle Corporation. All Rights Reserved. Oracle8i Enterprise Edition Release 8.1.7.0.1 - Production With the Partitioning option JServer Release 8.1.7.0.1 - Production SVRMGR> connect internal Connected. SVRMGR> shutdown Database closed. Database dismounted. ORACLE instance shut down. SVRMGR> quit Server Manager complete. $ I also killed listener. lsnrctl stop which put these things on the screen. $ lsnrctl stop LSNRCTL for Linux: Version 8.1.7.0.0 - Production on 13-MAR-2001 12:26:05 (c) Copyright 1998 Oracle Corporation. All rights reserved. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC))) The command completed successfully I also killed the httpd (Apache) on port 7777 which was started by the installation. cd $ORACLE_HOME cd Apache/Apache/bin ./apachectl stop ps auwx | grep httpd I will deal with Apache later. Actually, this is good reading, so go and look at pages at http://localhost:7777/ and you will find a few useful things. Then I restarted again oracle again. But I started listener first, so when oracle starts it will register itself with the listener. While it probably does not matter much, you should start oracle after you start the listener. lsnrctl start svrmgrl connect internal startup quit The screen output looked like (italic is what I typed): $ lsnrctl start LSNRCTL for Linux: Version 8.1.7.0.0 - Production on 13-MAR-2001 14:41:38 (c) Copyright 1998 Oracle Corporation. All rights reserved. Starting /u01/app/oracle/product/8.1.7.0.1/bin/tnslsnr: please wait... TNSLSNR for Linux: Version 8.1.7.0.0 - Production System parameter file is /u01/app/oracle/product/8.1.7.0.1/network/admin/listener.ora Log messages written to /u01/app/oracle/product/8.1.7.0.1/network/log/listener.log Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC))) Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=axanar)(PORT=1521))) Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=axanar)(PORT=2481))(PROTOCOL_STACK=(PRESENTATION=GIOP)(SESSION=RAW))) Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC))) STATUS of the LISTENER ------------------------ Alias LISTENER Version TNSLSNR for Linux: Version 8.1.7.0.0 - Production Start Date 13-MAR-2001 14:41:38 Uptime 0 days 0 hr. 0 min. 0 sec Trace Level off Security OFF SNMP OFF Listener Parameter File /u01/app/oracle/product/8.1.7.0.1/network/admin/listener.ora Listener Log File /u01/app/oracle/product/8.1.7.0.1/network/log/listener.log Services Summary... PLSExtProchas 1 service handler(s) linux817has 1 service handler(s) The command completed successfully $ $ svrmgrl Oracle Server Manager Release 3.1.7.0.0 - Production Copyright (c) 1997, 1999, Oracle Corporation. All Rights Reserved. Oracle8i Enterprise Edition Release 8.1.7.0.1 - Production With the Partitioning option JServer Release 8.1.7.0.1 - Production SVRMGR> connect internal Connected. SVRMGR> startup ORACLE instance started. Total System Global Area 72704160 bytes Fixed Size 73888 bytes Variable Size 55681024 bytes Database Buffers 16777216 bytes Redo Buffers 172032 bytes Database mounted. Database opened. SVRMGR> quit Server Manager complete. $ So I tried to log in and changed passwords for sys and system users. This is what was on the screen: $ sqlplus SQL*Plus: Release 8.1.7.0.0 - Production on Tue Mar 13 15:01:43 2001 (c) Copyright 2000 Oracle Corporation. All rights reserved. Enter user-name: sys Enter password: change_on_install Connected to: Oracle8i Enterprise Edition Release 8.1.7.0.1 - Production With the Partitioning option JServer Release 8.1.7.0.1 - Production SQL> password Changing password for SYS Old password: change_on_install New password: guess_what Retype new password: guess_what SQL> quit Disconnected from Oracle8i Enterprise Edition Release 8.1.7.0.1 - Production With the Partitioning option JServer Release 8.1.7.0.1 - Production $ $ sqlplus SQL*Plus: Release 8.1.7.0.0 - Production on Tue Mar 13 15:03:21 2001 (c) Copyright 2000 Oracle Corporation. All rights reserved. Enter user-name: system Enter password: manager Connected to: Oracle8i Enterprise Edition Release 8.1.7.0.1 - Production With the Partitioning option JServer Release 8.1.7.0.1 - Production SQL> password Changing password for SYSTEM Old password: manager New password: somethingElse Retype new password: somethingElse SQL> quit Disconnected from Oracle8i Enterprise Edition Release 8.1.7.0.1 - Production With the Partitioning option JServer Release 8.1.7.0.1 - Production $ Now, I did another ps auwx | grep oracle > oracle_processes1 to see if things are running. The output is here. It seems it ran.

Checking permissions on directories and files

Logged in as user oracle and did the stuff suggested in the Oracle 8i Installation Guide (Part Number: A86017-02) on page 4-3 and 4-4. The permissions are mostly OK since the installer does a good job. But I am just documenting/checking what they should set to: ls -ld $ORACLE_HOME/bin chmod 751 $ORACLE_HOME/bin ls -ld $ORACLE_HOME/bin/oracle chmod 6751 $ORACLE_HOME/bin/oracle ls -ld $ORACLE_HOME/lib chmod 755 $ORACLE_HOME/lib ls -l $ORACLE_HOME/lib chmod 644 $ORACLE_HOME/lib/* ls -ld $ORACLE_HOME/rdbms/log chmod 751 $ORACLE_HOME/rdbms/log ls -ld $ORACLE_HOME/rdbms chmod 751 $ORACLE_HOME/rdbms find $ORACLE_HOME/rdbms -type f -exec chmod 644 {} \; ls -ld $ORACLE_HOME/sqlplus chmod 751 $ORACLE_HOME/sqlplus find $ORACLE_HOME/sqlplus -type f -exec chmod 644 {} \; ls -ld $ORACLE_HOME/network/trace chmod 777 $ORACLE_HOME/network/trace

Starting Oracle on bootup automatically

I became a root... File /etc/oratab lists all databases which are installed. In my case it only had: linux817:/u01/app/oracle/product/8.1.7.0.1:N i.e., that there is a $ORACLE_SID linux817, and that $ORACLE_HOME for it is /u01/app/oracle/product/8.1.7.0.1, and N which means do not start it on boot up by dbstart script. But I want to start it on boot up, so I changed the line to: linux817:/u01/app/oracle/product/8.1.7.0.1:Y Then I logged out as root and logged in again as user "oracle". I made a directory for oracle stdout/stderr logs cd $ORACLE_HOME mkdir logs This directory will contain a file oracle_on_off.log which collects when oracle is started and shut down. Then I created two scripts in $ORACLE_HOME/bin. One, oracle_startup to start up oracle and whatever else I need (e.g., listener, apache, etc...). Another script was oracle_shutdown to shutdown down oracle. The scripts call the original Oracle startup/shutdown scripts: dbstart and dbshut (in $ORACLE_HOME/bin) and also other things which you want started with oracle. Note that I start listener BEFORE I start oracle db, since this way the oracle db will register its readines with listener as soon as it is up, while otherwise it would happen with delay (I believe that listener is scanning what is running at intervals). I also remembered to change their permissions: cd $ORACLE_HOME/bin chmod 755 oracle_startup oracle_shutdown These scripts can be used to start and stop oracle and associated services when you are logged in as user oracle. They can also be used to start and stop oracle automatically on boot up and halt as described later, but have to be called with "su - oracle -c "command" (read on...). Then I created a script to start and stop oracle on boot-up/shutdown: /etc/rc.d/init/dbora. It just calls the oracle_startup and oracle_shutdown scripts and makes sure oracle runs as user oracle. Note that the script calls oracle_startup and oracle_shutdown scripts (which in turn call original dbstart and dbshut scripts provided in $ORACLE_HOME/bin). The scripts are called with "su - oracle", i.e., the .bashrc and .bash_profile scripts for user oracle are executed before any other actions, like you actually logged in. That is why oracle's components will inherit environment variables set in the login scripts. Then I tested if dbora works: cd /etc/rc.d/init.d chmod 755 dbora chkconfig --add dbora chkconfig --list dbora ./dbora start ps auwx | grep oracle ./dbora stop ps auwx | grep oracle and it pretended that it did.

Adding environment variables on log in to oracle account

After reading the Post Installation chapter (pages 4-7 to 4-9) in Oracle 8i Installation Guide (Release 3 8.1.7 for Linux Intel, Part No. A86017-02, December 2000) I am quite confused what one should put in the CLASSPATH. They say to put stuff like $ORACLE_HOME/JRE/lib:$ORACLE_HOME/jlib in the CLASSPATH. The problem is that this is probably wrong, since you should put jars or directories with classes, something like: $ORACLE_HOME/JRE/lib/rt.jar:$ORACLE_HOME/JRE/lib/i18n.jar... These directories do not contain classes but jar files. The directory $ORACLE_HOME/jlib contains 16 jar files. Should I put all or some? This is not an easy question since, for example, the directory contains jars: jssl-1_1.jar and jssl-1_2.jar which are different versions of the same package oracle.security.*... They probably refer to JDK 1.1.X and 1.2.X, but who knows... I decided not to add jars if I do not know what they do. I can always change CLASSPATH later when I get ClassNotFound. I did not use the /usr/local/bin/oraenv script since, IMHO, it is not working correctly, and even if $ORACLE_HOME is correctly set, and ORAENV_ASK=NO it still asks for ORACLE_HOME. My final .bash_profile script is available here. For Net8 I added a line in the /etc/services: listener 1521/tcp #Net8 listener

Testing Oracle

Retrieving info from the test database with sqlplus

I logged in as user oracle, and started the oracle with one of my scripts: oracle_startup Oracle comes with the trial database, and a test user: scott (password: tiger). This is what I did to check if I can run anything: $ sqlplus scott/tiger SQL*Plus: Release 8.1.7.0.0 - Production on Sat Mar 10 02:50:32 2001 (c) Copyright 2000 Oracle Corporation. All rights reserved. Connected to: Oracle8i Enterprise Edition Release 8.1.7.0.1 - Production With the Partitioning option JServer Release 8.1.7.0.1 - Production SQL> select ENAME from EMP where SAL < 2000; ENAME ---------- SMITH ALLEN WARD MARTIN TURNER ADAMS JAMES MILLER 8 rows selected. SQL> quit Disconnected from Oracle8i Enterprise Edition Release 8.1.7.0.1 - Production With the Partitioning option JServer Release 8.1.7.0.1 - Production $

Trying simple JDBC application with Oracle

Note, all examples below assume that you are running Bourne/K/Bash shell. I wrote a simple Java application, JDBCTest.java which retrieves the same information as above, but it uses the JDBC driver. I saved it as JDBCTest.java, and placed it in /tmp. I updated CLASSPATH and added the entry for Oracle JDBC driver and current directory. Then I compiled it and ran it. I used the URL for the OCI driver, i.e., run it on the same machine as the oracle. cd /tmp CLASSPATH=${CLASSPATH}:${ORACLE_HOME}/jdbc/lib/classes111_g.zip:. export CLASSPATH javac JDBCTest.java ARG_DRIVER="oracle.jdbc.driver.OracleDriver" ARG_DB_URL="jdbc:oracle:oci8:@" ARG_USER="scott" ARG_PASSWORD="tiger" java JDBCTest $ARG_DRIVER $ARG_DB_URL $ARG_USER $ARG_PASSWORD Which produced: Arg[0]=oracle.jdbc.driver.OracleDriver Arg[1]=jdbc:oracle:oci8:@ Arg[2]=scott Arg[3]=tiger Connected to jdbc:oracle:oci8:@ as user scott Results of the query: select ENAME from EMP where SAL < 2000 SMITH ALLEN WARD MARTIN TURNER ADAMS JAMES MILLER Database connection closed The classes111.zip JDBC driver for JDK 1.1.X (1.1.8 in this case) which came with the Oracle 8.1.7 was woring fine locally, since it was a OCI (Oracle Call Interface) driver (i.e., one which accesses directly the binary C libraries of the Oracle and contains native code and is not portable to other OSes or platforms, e.g., the driver for Linux Intel need not work on Solaris). Obviously such JDBC drivers can only be used on the same machine on which either Oracle server or Oracle client is running. I could not find Linux Intel JDBC-OCI drivers for JDK 1.2.*/1.3 on the Oracle Web Site. Either they are not yet available or you need to use 3rd party drivers. It is logical, since Oracle itself uses JDK 1.1.8 under Linux. The above JDBC example was working on the virigin install of Oracle as described above. Unfortunately, this configuration will not work if we want to access Oracle from another machine. Whever you do, you will get: Exception in thread "main" java.lang.RuntimeException: SQL Exception Io exception: The Network Adapter could not establish the connection at JDBCTest.main(JDBCTest.java:70) To access Oracle from another machine you need to edit configuration files in the $ORACLE_HOME/network/admin directory. It is probably "Elementary, my dear Watson" for the Oracle gurus, but it was hours of digging through manuals, Web archives, etc, before it started working for me. Anyhow, I provide here the originals and the modified files which worked for the remote ORACLE access. listener.ora original listener.ora corrected sqlnet.ora original sqlnet.ora corrected tnsnames.ora original tnsnames.ora corrected There is another type of JDBC driver for Oracle. It is called a JDBC-Thin driver, and it is pure Java. You can get it from Oracle Technet page: http://technet.oracle.com/software/tech/java/sqlj_jdbc/htdocs/ftp.htm. There are actually two sets of Thin Drivers: for JDK1.1 and JDK1.2 under: Oracle8i 8.1.7 JDBC Drivers for use with JDK 1.2.x and Oracle8i 8.1.7 JDBC Drivers for use with JDK 1.1.x respectively. To check if thin driver is working, I copied the JDBCTest.java to another (Linux) machine which did not have Oracle installed. I had two JDKs installed on this machine: JDK1.3 and the Blackdown 1.1.8. I copied the classes12.zip (the Oracle-Thin JDBC driver for JDK1.2) and classes111.zip (the thin JDBC Oracle driver for JDK 1.1.8) to the directory /usr/local/oracle-jdbc and first tried the JDK1.2 driver. JAVA_HOME=/usr/local/jdk1.3 export JAVA_HOME PATH=${PATH}:${JAVA_HOME}/bin export PATH CLASSPATH=${JAVA_HOME}/lib/dt.jar:${JAVA_HOME}/lib/dt.tools CLASSPATH=${CLASSPATH}:/usr/local/oracle-jdbc/classes12.zip:. export CLASSPATH javac JDBCTest.java ARG_DRIVER="oracle.jdbc.driver.OracleDriver" ARG_DB_URL="jdbc:oracle:thin:@axanar.ccl.net:1521:linux817" ARG_USER="scott" ARG_PASSWORD="tiger" java JDBCTest $ARG_DRIVER $ARG_DB_URL $ARG_USER $ARG_PASSWORD It produced: Arg[0]=oracle.jdbc.driver.OracleDriver Arg[1]=jdbc:oracle:thin:@axanar.ccl.net:1521:linux817 Arg[2]=scott Arg[3]=tiger Connected to jdbc:oracle:thin:@axanar.ccl.net:1521:linux817 as user scott Results of the query: select ENAME from EMP where SAL < 2000 SMITH ALLEN WARD MARTIN TURNER ADAMS JAMES MILLER Database connection closed I then checked if the JDK1.1.8 will behave as well: JAVA_HOME=/usr/local/jdk1.1.8 export JAVA_HOME PATH=${PATH}:${JAVA_HOME}/bin export PATH CLASSPATH=${JAVA_HOME}/lib/classes.zip CLASSPATH=${CLASSPATH}:/usr/local/oracle-jdbc/classes111.zip:. export CLASSPATH javac JDBCTest.java ARG_DRIVER="oracle.jdbc.driver.OracleDriver" ARG_DB_URL="jdbc:oracle:thin:@axanar.ccl.net:1521:linux817" ARG_USER="scott" ARG_PASSWORD="tiger" java JDBCTest $ARG_DRIVER $ARG_DB_URL $ARG_USER $ARG_PASSWORD The result was the same, i.e., worked... Then I tried a really convoluted stuff, Oracle specific naming as: JAVA_HOME=/usr/local/jdk1.1.8 export JAVA_HOME PATH=${PATH}:${JAVA_HOME}/bin export PATH CLASSPATH=${JAVA_HOME}/lib/classes.zip CLASSPATH=${CLASSPATH}:/usr/local/oracle-jdbc/classes111.zip:. export CLASSPATH javac JDBCTest.java ARG_DRIVER="oracle.jdbc.driver.OracleDriver" ARG_DB_URL="jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(HOST=axanar.ccl.net)(PROTOCOL=tcp)(PORT=1521))(CONNECT_DATA=(SID=linux817)))" ARG_USER="scott" ARG_PASSWORD="tiger" java JDBCTest $ARG_DRIVER "$ARG_DB_URL" $ARG_USER $ARG_PASSWORD I was quite positively surprised when I saw: Arg[0]=oracle.jdbc.driver.OracleDriver Arg[1]=jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(HOST=axanar.ccl.net)(PROTOCOL=t cp)(PORT=1521))(CONNECT_DATA=(SID=linux817))) Arg[2]=scott Arg[3]=tiger Connected to jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(HOST=axanar.ccl.net)(PROT OCOL=tcp)(PORT=1521))(CONNECT_DATA=(SID=linux817))) as user scott Results of the query: select ENAME from EMP where SAL < 2000 SMITH ALLEN WARD MARTIN TURNER ADAMS JAMES MILLER Database connection closed
Modified: Fri Jan 18 16:30:35 2002 GMT
Page accessed 28792 times since Fri Mar 16 03:43:56 2001 GMT