源地址：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