?
Http://140.138.144.144/~freebsd/application/undle/oracle.htm
Sender: nekobe.bbs@hikaru.tku.net (cyberexistence), Word: BSD Title: [How-to] Install Oracle 8.0.5 in FreeBSD 3.x: Mini Circle Station (THU Jan 6 01 : 16: 41 2000) Transmission Station: bbs.yzu! News.yzu! News.ncu! News2.csie.ncu! News.csie.ncu! Netnews.csie.nc
-1. This article is a saying that the younger brother refers to many documents. Plus a little experimental results, the success of 3.3-stable, although it has established success, but also made DB, but due to the relationship that it is unfamiliar , So I don't have a comprehensive test with Benchmark, interested friends can try :)
0. "Before installation"
0-1. "Kernel Adjustment" first check your KERNEL setting file, please add the following settings
options SHMMAL = 4097options SHMMAXPGS = 4097options "SHMMAX = (SHMMAXPGS * PAGE_SIZE 1) options SEMMAP = 255options SEMMNI = 100options SEMMNS = 200options SEMMNU = 235options SEMMSL = 61options SEMOPM = 201options SEMUME = 201options SEMSEG = 10
Replay Kernel, first "don't" restart, vi /etc/rc.conf, join
Linux_enable = "yes" ibcs2_enable = "yes"
Restart, there is a environment that can run Linux simulator
0-2. "Installing Linux Simulator", please find a FTP station to catch the following DistFiles
Linux_base-5.2.tgzlinux_devel-0.2.tgz
Find a FTP station with Linux, caught the following RPM
Glibc-2.1.1-6.i386.rpmtcl-8.0.5-30.i386.rpmkernel-headers-2.0.36-0.7.i386.rpm
Use pkg_add to install Linux_Base-5.2.tgz with Linux_Devel-0.2.tgz, and then install it in the RPM:
Kernel-headers-2.0.36-0.7.i386.rpmglibc-2.1.1-6.i386.rpmtcl-8.0.5-30.i386.rpm
PS: Installation method is rpm -i --ignoreos --root / compat / linux - dbpath / var / lib / rpm
If you encounter the message installed, please
RPM -U - IGNOREOS - ROOT / COMPAT / Linux --Dbpath / VAR / LIB / RPM
0-3. "Establishing the USER" VI / ETC / Group required for Oracle, join a line
DBA: *: 82: Oracle
Vi / etc / shells, join a line
/ compat / linux / bin / bash
VIPW joins a line
Oracle:
: 82: 82 :: 0: 0: Oracle DBA: / usr / local / oracle: / compat / linux / bin / bash
Contents
Mkdir / home / oracle; ln -s / home / oracle / usr / local / oraclemkdir -p / usr / local / oracle / etc / oracle: Y> / usr / local / oracle / etc / oracaN -S / usr / local / oracle / etc / oratab / etc / oratabchown -r oracle: DBA / Home / Oracle grab Source, unope
Fetch ftp://ftp.Orcle.com/pub/www/undle8/linux/oracle8051ee_intel.tgz
Look for a Source directory unpack
Mkdir / usr / local / oracle / source; cd / usr / local / oracle / source -xzspvf /usr/local/oracle/oracle8051ee_intel.tgz (to solve a while, you can go to the cup of tea to take a break)
0-4. "Establish an environment variable of Oracle users" first SU into Oracle, editor /usr/local/oracle/.profile joins the following lines
ORACLE_BASE = / home / oracle; export ORACLE_BASEORACLE_HOME = / home / oracle; export ORACLE_HOMELD_LIBRARY_PATH = $ ORACLE_HOME / lib; export LD_LIBRARY_PATHORACLE_SID = WHATEVER; export ORACLE_SIDORACLE_TERM = 386x; export ORACLE_TERMCLASSPATH = $ ORACLE_HOME / jdbc / lib / classes111.zip; export CLASSPATHPATH = / compat / linux / bin: / compat / linux / sbin: // compat / linux / usr / sbin: / bin: / usr / usr / bin: / usr / sbin: / USR / local / bin: / $ oracle_home / bin;
Please don't be wrong !!
1. "Start installation"
1-1. "Detailed installation process"
CD / usr / local / oracle / source / orapct; ./orainst
a) Please choose Custom installb) press twice OK will see Installation Activity Choice Please select Install, Upgrade, or De-Install Softwarec) Installation Options Please choose Install New Product - Do Not Create DB Objectsd) ORACLE_BASE and ORACLE_HOME please fill / USR / local / oraclee) Logging and status Please press ENTAL Source, please select Install from staging areag) Source Staging Area, please fill in / usr / local / oracle / sourceh) NLS Select All Languagesi), then press OK After you will enter Software Asset Manager, don't hesitate, all the elections J), then ask the DBA Group after the OK will be asked to fill in DBAK. ENTER Over N) Documentation Format is free to set it. Then it officially started installed. Any error occurs on the installation of Ignore it will slowly solve these problems.
1-2. "Solve Linked questions first"
The solution to this problem is very useless, but it is very useful ...
Cp / usr / local / oracle / source / bin / * / usr / local / oracle / bin2. "Modify Error"
When you install, you will have six errors, we must solve it by one by one, please use the Oracle User to do.
2-1. "Modify" Oracle Names "error"
CD / usr / local / oracle / source / libvi sysliblist, cut "-lnsl -lm" partial, change the content below
/compat/linux/lib/ld-linux.so.2/compat/linux/lib/libm.so.6/compat/linux/lib/libdl.so.2/compat/linux/lib/libpthread.so.0 /compat/linux/lib/libc.so. 6/compat/linux/lib/libnsl.so.1/compat/linux/usr/lib/libtcl.so/compat/linux/usr/lib/libtcl8.0.so
CD / USR / LOCAL / ORACLE / NETWORK / libvi env_network.mk, modified part of the following
150C150, 151
Make -f INS_NETWORK.MK NAMES_TARGS
2-2. "Modify" WARP EXECUTABLE "error"
CD / usr / local / oracle / plsql / libvi env_plsql.mk, modified part of the following
149C149, 150
Make -f INS_PLSQL.MK INSTALL
2-3. "Modify" Oracle TRACE "error"
CD / USR / LOCAL / ORACLE / OTRACE / LIBVI ENV_OTRACE.MK, modified part of the following
149C149, 150
Make -f INS_OTRACE.MK INSTALL
2-4. "Modify" Oracle8 Standard RDBMS "error"
CD / usr / local / oracle / rdbms / libvi env_rdbms.mk, modify the following part
149C149, 150
2-5. "Modify" Oracle Intelligent Agent "error"
CD / usr / local / oracle / network / libvi env_oemagent.mk, modify the following part
149C149, 150
Vi INS_OEMAGENT.MK, modify the following part
27c27, 28
Make -f INS_OEMAGENT.MK INSTALL
2-6. "Modify" SQL * PLUS "error"
CD /us/local/oque/sqlplus/lib/env_sqlplus.mk150c150, 151
Make -f INS_SQLPLUS.MK INSTALL
He has already completed the six mistakes in the installation !! Tired ?! Drink cups, it is fun !!
3. "Start playing Oracle bar"
3-1. "ROOT.SH modification"
CD / usr / local / oracle / orapostvi root.sh, modify the following part
1C1 <#! / Usr / bin / sh ---> #! / Compat / linux / bin / sh34c34
Use "root" Run /us R / OTT.SHA) "Y" B) "Y" B) Fill in / usr / local / oracle / bin3-2. "Let Oracle run"
Cp /usr/local/oracle/dbs/ininit.ora /usr/local/oracle/dbs/initwhatever.oravi /usr/local/oracle/dbs/initwhatever.ora, change Default to Whatever
/ Usr / local / oracle / bin / svrmgrl, should enter the correct svrmgrlconnect internalstartupcreate database WHATEVER character set WE8ISO8859P1; alter tablespace SYSTEMadd datafile '/usr/local/oracle/dbs/dbs2WHATEVER.dbf'size 10M autoextend on; @ $ ORACLE_HOME /rdbms/admin/catalog.sql@ /oacle_home/rdbms/admin/catproc.sql@@ioracle_home/sqlplus/admin/pupbld.sql (here there will be Error, don't take him ~~)
Then you can SQLPLUS SYS / Manager can also select * from Tab; of course, you can also complete it !!!
Is it fun?!
- ================================================================================================================================================================== ============================== Nekobe wu. (Wu Zhu Xing) | http://hikaru.tku.net/nekobe@tku .NET | (PURE DB Web BBS) Nekobe@hikaru.tku.net | http://www.nekobe.tku.net/ | (Personal HomePage) Network, FreeBSD, Windows NT, HTML, PHP, Perl, Database .. .
- ※ ORIGIN: Mini Circle Station ◆ from: hikaru.tku.net -