在NetBSD/i386上运行Oracle

源地址：http://www.telefonica.net/web2/joseyluis/

　　RunningOracle9.2.0.4/9.2.0.7onNetBSD/i386

　　Foranyquestionsendaemailto:joseyluisatgmaildotcom

　　PagebyJoseLuisRodriguezGarcia

　　AtthemomentitispossibletocreateanduseOracledatabases

　　andthesetools/servers:

　　DatabaseConfigurationAssistant(dbca)

　　NetConfigurationAssistant(netca)

　　OracleEnterpriseManager(OEM)Consoleinstandalonemode(oemappconsole)

　　OraclePerformanceManager

　　OracleListener(lsnrctl)

　　Thesearethetoolsserversthatdon'tworkatthemoment:

　　IntelligentAgent(lsnrctl)

　　Version1.227/11/2005

　　GuideforinstallingOracle9.0.4onNetBSD/i386.

　　Installationofthe9.2.0.7patch

　　Databasecreation

　　Graphicaldatabasecreation

　　Manualdatabasecreation

　　Networkconfiguration(OracleNet)

　　Graphicaladministration

　　Knownissues

　　Screenshots

　　Logs:kdumps,etc..

　　Changestothedocument

　　GuideforinstallingOracle9.0.4onNetBSD/i386.

　　First,youneedaNetBSDkernelwiththelastchangesontheipcstuffforLinuxcompatibility:

　　Current:Afterof10Novemberof2005.Thisversionhasalltherequiredpatchesapplied.

　　Otherereleases:3.xafter5Novemberof2005,andcurrentafter3November2005,youneedtoapplyonlythiskernelpatch:diff.linux-shm.6.

　　

　　Otherreleases:2.x,3.xandcurrentyouneedtoapplythesekernelpatches:diff.linux-shm.6anddiff.semopm.

　　UsingNetBSD1.6.xisnotpossible,becausetheLinuxJavadoesn'tworkwiththisversion:Theinstallerandthegraphicaltoolsusejava.

　　IhaveinstalledthenextSusepackages:

　　pc-jose#pkg_info|grep-isuse

　　suse_base-9.1nb7

　　Linuxcompatibilitypackage

　　suse_expat-9.1nb1

　　Linuxcompatibilitypackageforexpatbinaries

　　suse_fontconfig-9.1Linuxcompatibilitypackageforfontconfigbinaries

　　suse_freetype2-9.1

　　LinuxcompatibilitypackageforFreeType2library

　　suse_libjpeg-9.1nb1LinuxcompatibilitypackagefortheJPEGlibrary

　　suse_libpng-9.1nb1

　　LinuxcompatibilitypackageforthePNGlibrary

　　suse_libtiff-9.1nb1LinuxcompatibilitypackagefortheTIFFlibrary

　　suse_x11-9.1nb2

　　LinuxcompatibilitypackageforX11binaries

　　suse_gtk2-9.1nb3

　　LinuxcompatibilitypackageforGTK2binaries

　　suse_locale-9.1

　　LocalefilesfortheLinuxcompatibilitypackage

　　suse_glx-9.1

　　LinuxcompatibilitypackagefortheGLlibrary

　　suse_compat-9.1

　　Linuxcompatibilitypackagewitholdsharedlibraries

　　pc-jose#

　　Java1.3mustbeinstalledforusetheOracleInstaller:

　　pc-jose#pkg_info|grep-isun-jre13

　　sun-jre13-1.0.15nb2Sun'sJava(tm)RuntimeEnvironment1.3.1

　　

　　pc-jose#

　　Downloadanduncompressthefollowingrpms:

　　binutils-2.15.90.0.1.1-31.i586.rpm

　　coreutils-5.2.1-23.8.i586.rpm

　　cpp-3.3.3-41.i586.rpm

　　gcc-c++-3.3.3-41.i586.rpm

　　gcc_old-2.95.3-175.2.i586.rpm

　　glibc-devel-2.3.3-98.i586.rpm

　　grep-2.5.1-416.i586.rpm

　　libstdc++-devel-3.3.3-41.i586.rpm

　　make-3.80-184.i586.rpm

　　orarun-1.8-109.15.i586.rpm

　　Foruncompresstherpms,Iexecuted:

　　cd/emul/linux

　　rpm2pkg/path-to-rpm-file

　　SetdefaultcompilerforLinuxgcc/c++2.95

　　bash$cd/emul/linux/usr/bin

　　mvc++c++.old

　　mvg++g++.old

　　ln-s../../opt/gcc295/bin/gccgcc

　　ln-s

　　../../opt/gcc295/bin/c++c++

　　ln-s../../opt/gcc295/bin/gccgcc

　　Createsymboliclinksforawkandsed:

　　cd/emul/linux/bin

　　ln-s/usr/bin/awkawk

　　ln-s/usr/bin/sedsed

　　Createthearchscript

　　cd/emul/linux/bin

　　#!/emul/linux/bin/bash

　　cat>arch

　　echoi686

　　^D

　　chmoda+xarch

　　Downloadthesoftware

　　Downloadthe3CDsfrom:

　　http://www.oracle.com/technology/software/products/oracle9i/index.html

　　ChooseOracle9iDatabaseRelease2Enterprise/StandardEditionforLinux.FordownloadtheseCDsyouhavetoregister.Itisfreeandeasytodo.

　　Uncompressthe3CDs:

　　gzcatship_9204_linux_disk1.cpio|cpio-idmv

　　gzcatship_9204_linux_disk2.cpio|cpio-idmv

　　gzcatship_9204_linux_disk3.cpio|cpio-idmv

　　

　　Mountprocfswiththefollowingoptionsinthe/etc/fstabfile:

　　Addthislinetovfstab:

　　/emul/linux/procprocfsrw,linux

　　Mounttheprocfsfilesystem:

　　$mountprocfs

　　Create/proc/statand/proc/swaps

　　Idon'tknowthatOraclesearchsforthesefiles.Maybethatinstallationworkswithoutthesefiles.

　　Copythesefilesto/proc:statandswaps.

　　CreatetheOracleaccountandgroups:

　　Itisneededaoracleuser.Ihavechosenthelinuxbashasshell.

　　Twogroupsareneeded:oinstall:ownsthefilesforanyinstallationofOracleonthemachine.

　　Byexample:ifthereisaOracle9iandOracle10g,andifitiscreatedtwousers:oracle8andoracle9bothusersmusthaveoinstallasprimarygroup)anddba.Theoinstallgroupmustbetheprimarygroup(theonethatappearsasgidin/etc/passwd/etc.masterpasswd.

　　Aoptionalthirdgroup:oper.Ithasrestrictedprivilegesandisusefulforoperators.

　　Youcanchooseanynamefortheuserandgroupaccounts.Ihavechosenthedefaultaccounts:oracle,oinstall,dbaandoper.Thesearetheresulting/etc/passwdand/etc/group:

　　/etc/passwd:

　　

　　oracle:*:101:100:Oracleadministrator:/usr/oracle:/emul/linux/bin/bash

　　/etc/group:

　　oinstall:*:1000:oracle

　　dba:*:1001:oracle

　　oper:*:1002:oracle

　　Kerneloptions

　　Ihaveusedthefollowingkerneloptions:

　　options

　　SYSVMSG

　　#SystemV-likemessagequeues

　　options

　　SYSVSEM

　　#SystemV-likesemaphores

　　options

　　SEMMNI=128

　　#numberofsemaphoreidentifiers

　　options

　　SEMMNS=256

　　#numberofsemaphoresinsystem

　　#options

　　SEMUME=10

　　#maxnumberofundoentriesperprocess

　　#options