目录搜索
oracle知识ORACLE的数据类型Oracle技术网—DBMS_Job包的用法Oracle技术网—Oracle for NT系统实用工具介绍Oracle技术网—Oracle常见错误代码Oracle技术网—Oracle常用ScriptOracle技术网—Oracle常用数据字典Oracle技术网—ORACLE数据库简介Oracle技术网—Oracle特殊包Oracle技术网—Oracle相关站点Oracle技术网—哪些初始化参数最影响Oracle系统性能PL/SQLDBAOracle7 7.3.2.2Oracle技术网—listener.log的内容增长很快,是否可以删除重建Oracle技术网—ORACLE表空间恢复方案Oracle技术网—Oracle常用系统文件有哪些Oracle技术网—ORACLE回滚段管理(上)Oracle技术网—ORACLE回滚段管理(下)Oracle技术网—Oracle如何决定使用哪个回退段Oracle技术网—Oracle数据库的空间管理技巧Oracle技术网—Oracle数据库碎片整理Oracle技术网—Oracle数据库有哪几种关闭方式Oracle技术网—Oracle数据库有哪几种启动方式Oracle技术网—Oracle预定义角色有哪些Oracle技术网—ROLLBACK不能回滚的命令Oracle技术网—查看哪些session正在使用哪些回滚段Oracle技术网—存储参数(storage子句)含义及设置技巧Oracle技术网—和权限有关的表有哪些Oracle技术网—漫谈数据库的启动和关闭Oracle技术网—哪些初始化参数最影响Oracle系统性能Oracle技术网—如何备份控制文件Oracle技术网—如何查出前台正在发出的sql语句Oracle技术网—如何查看Oracle版本及安装了哪些选项Oracle技术网—如何查看Oracle数据表的建表语句Oracle技术网—如何查看SGA区剩余可用内存Oracle技术网—如何查看各个表空间占用磁盘情况Oracle技术网—如何查看后台进程Oracle技术网—如何查看什么时间有哪些数据库对象结构被修改过Oracle技术网—如何查看数据库的各种数据文件Oracle技术网—如何查看数据库的字符集Oracle技术网—如何查看数据文件是否自动扩展Oracle技术网—如何查看数据文件所在的路径Oracle技术网—如何查看用户表上的约束内容Oracle技术网—如何查看用户表所占空间的大小Oracle技术网—如何查询出primary key和forgen key的关系表Oracle技术网—如何改变当前联机日志文件的大小Oracle技术网—如何利用DBMS_SQL包和游标计算当前用户下所有表的行数Oracle技术网—如何启动ARCHIVELOG模式Oracle技术网—如何取出某一用户的密码,再原封不动的改回去Oracle技术网—如何设置BLOCK_SIZE大于2K,如:4K、16KOracle技术网—如何手工指定使用哪个回退段Oracle技术网—如何修改internal的口令Oracle技术网—如何移动控制文件到新的目录中Oracle技术网—如何移数据库文件Oracle技术网—如何增加表空间的大小Oracle技术网—怎样查看init.ora文件Oracle技术网—怎样查看SGA值Oracle技术网—怎样查看哪些用户拥有SYSDBA、SYSOPER权限?Oracle技术网—怎样快速查出Oracle 数据库中的锁等待Oracle技术网—怎样识别IO竞争和负载平衡Exp vs ImpOracle技术网—EXP、IMP 命令详解Oracle技术网—Exp/Imp大量数据Oracle技术网—Export/Import 使用技巧与常见错误Oracle技术网—Oracle数据库的备份与恢复Oracle技术网—如何把数据exp到Sql loader里Oracle技术网—如何单独备份一个或多个表Oracle技术网—如何单独备份一个或多个用户Oracle技术网—如何导入指定表Oracle技术网—如何建立一个与现存数据库相同,但不包含数据的空库Oracle技术网—如何在oracle7和oracle8之间exp/imp数据Oracle技术网—提高ORACLE数据库系统import性能Oracle技术网—为何我的导出文件只有500KOracle技术网—自动备份Oracle数据库Oracle技术网—作Export或Import时,如何记录LOG信息?SQL技巧Oracle技术网—LONG数据类型使用上的一些说明Oracle技术网—Oracle8 PL/SQL编程风格与系统性能的提高Oracle技术网—Oracle8中用户名、表名、列名、索引名...可以用中文命名吗Oracle技术网—Oracle中如何实现某一字段自动增加1Oracle技术网—SQL(Structured Query Language)语句分哪几类Oracle技术网—SQL*PLUS常用命令列表Oracle技术网—SQL*Plus系统环境变量有哪些?如何修改?Oracle技术网—SQL*Plus中缓冲区命令列表Oracle技术网—SQL*Plus中能运行哪几种命令Oracle技术网—SQLPlus中的复制和粘贴技巧Oracle技术网—查看本用户下的各种对象的SQL脚本Oracle技术网—查找a表中有,而在b表中没有的记录Oracle技术网—利用PL/SQL打印ASCII表Oracle技术网—如何查找、删除表中重复的记录Oracle技术网—如何对CLOB行字段执行全文检索Oracle技术网—如何对CLOB字段进行全文检索?Oracle技术网—如何改变表中列的名字Oracle技术网—如何改变一个字段初始定义的Check范围Oracle技术网—如何给表、列加注释Oracle技术网—如何将 primary key 建在其它的表空间上Oracle技术网—如何删除表中的列Oracle技术网—如何使‘CREATE TABLE AS SELECT’能支持ORDER BY ?Oracle技术网—如何通过 SQL*PLUS 将符号 & 、'号(单引号) 插入Oracle数据库的表中Oracle技术网—如何用SQL生成SQL批处理文件Oracle技术网—如何在PL_SQL中读写文件Oracle技术网—如何自动生成一个含有20000101至20500101共50年日期的表Oracle技术网—如何自动生成一个含有2000年01月至2050年01月共50年月份的表Oracle技术网—删除a表中和b表相同的数据Oracle技术网—在Oracle快速进行数据行存在性检查Oracle技术网—怎样查看表的结构Oracle技术网—怎样改变SQL*Plus启动时默认路径Oracle技术网—怎样计算表中的记录数Oracle技术网—怎样在SQL*Plus中使用 '&' 来实现自定义参数变量?Oracle技术网—怎样在查询记录时给记录加锁Oracle错误Oracle7 7.3.2.2Oracle技术网—Oracle 816中如何启动Enterprise ManagerOracle技术网—Oracle Enterprise Manager(OEM)工具中如何以SYSOPER、SYSDBA方式登录Oracle技术网—ORACLE数据库应用开发常见问题及排除Oracle技术网—监听器错误Oracle技术网—联机热备份失败后,如何打开数据库Oracle技术网—没有备份、只有归档日志,如何恢复数据文件Oracle技术网—某个数据文件损坏,如何打开数据库Oracle技术网—如何使用归档日志进行完全恢复Oracle技术网—如何正确建立TYPE、partition(分区)Oracle技术网—一个控制文件被损坏,如何启动Oracle技术网—在SQL*Plus中insert进的都是中文的,为什么一存入服务器后,再select出的就是???了Oracle技术网—重装Oracle服务器后,以前的数据可以恢复吗Oracle初学者入门Oracle技术网—Oracle 8.1.6 for Win2000 系统文件解释Oracle技术网—Oracle 基本知识Oracle技术网—Oracle8 数据类型Oracle技术网—what is sql?Oracle技术网—安装、配置后,SQL*Plus操作初步Oracle技术网—安装Oracle后,经常使用的修改表空间的SQL代码Oracle安装、删除Oracle技术网—Oradim工具的用法Oracle技术网—WINDOWS NT上,如何删除ORACLE SERVICEOracle技术网—如何连接两台Oracle服务器Oracle技术网—如何在Windows 2000下将Oracle完全卸载Oracle技术网—如何在WINDOWS NT上删除所有的Oracle安装?Oracle技术网—手工安装数据库时需要安装那些系统包Oracle技术网—手工创建数据库的全部脚本及说明Oracle安全性问题Oracle技术网—Linux ORACLE 8.1.5漏洞Oracle技术网—Oracle 8.1.6的oidldapd中的漏洞Oracle技术网—Oracle8的不安全因素及几点说明Oracle技术网—Oracle数据库的安全策略Oracle技术网—Oracle数据库密码文件的使用和维护Oracle技术网—提高Oracle数据库应用系统安全的举例与分析数据库安全性策略Oracle系统设置、优化、连接《Oracle8 优化技术》摘录 (第一章 安装)《Oracle8 优化技术》摘录 (第二章 内存/CPU)《Oracle8 优化技术》摘录 (第三章 输入/输出)Oracle技术网—ASP 中通过OLEDB访问 Oracle 的代码Oracle技术网—Delphi5 企业版使用BDE访问 Oracle方法Oracle技术网—oracle database access objectOracle技术网—Oracle基于Client/Server的性能调整Oracle技术网—PB7 连接 Oracle 的配置方法Oracle技术网—PB内置Oracle数据库接口的使用方法Oracle技术网—PHP+Oracle(OCI) 初步Oracle技术网—PHP4连接Oracle 8i的方法(转译)Oracle技术网—多个数据库时,如何设置默认数据库Oracle技术网—如何备份Oracle设置Oracle技术网—如何让你的SQL运行得更快Oracle技术网—如何修改 SQL*Plus 的启动参数Oracle技术网—如何在Windosws 2000中安装JSP并访问OracleOracle技术网—如何在Windosws 2000中安装perl并访问OracleOracle技术网—如何在Windosws 2000中安装PHP4并访问OracleOracle技术网—如何在Windosws NT中使用批处理命令自动启动或关闭Oracle ServicesOracle技术网—如何在客户端省略输入数据库串,而只输入用户名、密码即可Oracle技术网—使用Database Configuration Assistant安装第二个数据库Oracle技术网—修改Oracle7数据库maxdatafiles参数的方法索引、序列、快照、数据库链路、触发器Oracle技术网—触发器的几种应用Oracle技术网—建立触发器时最容易忽略的两个地方Oracle技术网—快照和触发子结合使用的例子Oracle技术网—能否通过视图更新表中的数据Oracle技术网—如何创建一个简单的JAVA存储过程?Oracle技术网—如何创建隐藏IP地址的最后一项的函数?Oracle技术网—如何加密Oracle中的存储过程Oracle技术网—为什么有时ORACLE数据库不用索引来查找数据Oracle技术网—我的数据库链路为什么不工作Oracle技术网—一个建立快照的简单例子Oracle技术网—怎样创建一个简单的自定义过程并引用Oracle技术网—怎样手工刷新快照oracle与其他数据库的比较MySQL 测试Oracle技术网—Oracle 和 mysql 的一些简单命令对比参照Oracle技术网—Oracle8i和Microsoft SQL Server7.0比较Oracle技术网—比较SQL Server与Oracle、DB2Oracle技术网—各种数据类型的比较Oracle技术网—戏说SQL—几种SQL 服务器的比较关键任务      在Internet上运作公司是一项艰苦的任务其它知识OEM常见问题及其解决办法Oracle 8 资料库函式库Oracle 资料库函式库Oracle技术网—Decode()函数使用技巧(NT+IIS+ASP+ORACLE)Oracle技术网—Dual伪列Oracle技术网—NULL 使用详解Oracle技术网—OLAP及其多维数据分析Oracle技术网—Oracle for NT系统实用工具介绍Oracle技术网—ORACLE 用户的规范化管理Oracle技术网—user、uid伪列Oracle技术网—大型数据库设计原则Oracle技术网—留言簿(带Oracle数据库分页的显示功能)Oracle技术网—漫谈oracle中的空值Oracle技术网—如何正确利用Rownum来限制查询所返回的行数Oracle技术网—什么是ROWID,为什么需要它Oracle技术网—数据库技术考试大纲(中级)Oracle技术网—数据库行业的现状和展望Oracle技术网—在客户端处理Oracle的数据行加锁问题如何对CLOB行字段执行全文检索Developer 2000Oracle技术网—Developer/2000中各键盘触发子所对应的“按键”Oracle技术网—FORM调用REPORT时,如何去掉report serverOracle技术网—FORM中,Exception(例外)都有哪些,如何书写Oracle技术网—FORM中,FORM中,如何引入图像Oracle技术网—FORM中,WINDOW标题的设置Oracle技术网—FORM中,常用快捷键有哪些Oracle技术网—FORM中,触发子exit_form的两种功能是什么Oracle技术网—FORM中,当光标走到块的最后一项时,如何让按“enter回车”键时,光标自动走到下一条记录的第一项?Oracle技术网—FORM中,当用鼠标点击标签画布的某一“标签页”时,如何判断点击的是哪一页Oracle技术网—FORM中,如何屏蔽默认的功能键Oracle技术网—FORM中,如何实现屏幕同步刷新?Oracle技术网—FORM中,如何使用警告Oracle技术网—FORM中,如何通过 ODBC 访问 Acress 数据?Oracle技术网—FORM中Oracle技术网—FORM中,设置应用特性(光标类型)Oracle技术网—FORM中,怎样创建动态下拉列表ListOracle技术网—FORM中如何存取声音Oracle技术网—FORM中如何存取图象?如何把图象从一个表中导到另一个表中?Oracle技术网—MIS中的图像应用技术Oracle技术网—MIS中的图像应用技术Oracle技术网—从FORM中调用REPORT时,如何使打印结果直接输出到打印机上Oracle技术网—如何从FORM中调用REPORT程序Oracle技术网—如何改变FORM(FMX模块)运行时的title?Oracle技术网—如何在FORM运行中,使定制菜单中的“窗口(W)”菜单项不显示Oracle技术网—如何在启动FORM程序时直接登录到Oracle数据库上?Oracle技术网—运行FORM时,如何使按钮变灰(即无效)Oracle技术网—运行FORM时,如何使窗口(runtime窗口、画布窗口)自动变成最大化、最小化?Oracle技术网—在Developer/2000中如何读写文本型操作系统文件Oracle技术网—在Oracle中实现报表的定长输出linux vs UnixHow To Install Oracle 8.0.5 onto RedHat Linux 6HOWTO: OAS for Linux on FreeBSDHOWTO: Oracle for Linux on FreeBSDOracle 7.3.4 Enterprise Edition for SCO UNIX 安装步骤Oracle技术网—Oracle .com 套件在TurboLinux上的安装Oracle技术网—ORACLE 7.3 Enterprise在SCO OPEN SERVER 5.02 及 5.04 的安装过程Oracle技术网—ORACLE 7.3.4.2 for SCO Unix 安装说明Oracle技术网—Oracle 8 for solaris 2.6 安装步骤Oracle技术网—Oracle 8(8.0.5)标准版安装指南Oracle技术网—Oracle 8i(8.1.5)企业版安装指南Oracle技术网—ORACLE FOR SUN SOLARIS 安装手册Oracle技术网—ORACLE FOR SUN SOLARIS 维护手册Oracle技术网—ORACLE V.7.3.4.3 FOR AIX 安装说明Oracle技术网—ORACLE8I FOR SUN SOLARIS2.7 安装说明Oracle技术网—RedHat 6.1 Step-by-step Install notes for Oracle 8iOracle技术网—RedHat Linux 6.0 上 Oracle 8(8.0.5)标准版 安装实例Oracle技术网—RedHat Linux 6.0 上 Oracle 8i R2 (8.1.6) 企业版安装实例Oracle技术网—如何集成Linux/Apache/PHP4/FastCGI/Oracle/MySQL环境Oracle技术网—如何在你的Linux机器上安装运行OracleOracle技术网—为Linux配备Oracle 8Oracle技术网—在RedHat 6.0上安装Oracle 8i(全攻略)
文字

RedHat 6.1
Step-by-step Install notes for Oracle 8i

IMPORTANT! NOTES ABOUT ORACLE 8i
Despite the release of some patches in December (which are part of this doc's install process), this product is still very buggy. Hopefully, Oracle 8i, release 2, which hasn't been released for Linux yet, will fix some of the problems. 

The machine I used to install Oracle
 Though Oracle recommends at least 256 megs RAM, I used a Pentium III 450 with 128 megs. Building the database took a long time on this machine, but it works.

What's in this doc
There are six parts:
RedHat initial install - Covers what is needed at minimum to install with RedHat 6.1, plus memory parameters recommended by Oracle and why you shouldn't use them.
Stuff you have to download before installing - You need the Java RunTime Environment and a patch before even proceeding with the installation.
Oracle pre-install - Setting up your users, groups, mount points and environment variables. 
Oracle install - Where you actually install the software.
Changing permissions and applying the patch -  Highly recommended you apply this patch.
Oracle post-install - Clean-up tasks and testing. 
I make no guarantees that the installation will work if you decide to just use part of these instructions vs. the whole thing.

Editorial comment about this document
I'm not a Linux guru, but I proceeded to put these pages up to help other lost soles like me. If you see something that makes you laugh hysterically here, do me a favor: When you're done laughing, drop a note to me, tbissett@fwn.fortwayne.com, and (kindly) let me know where I'm nuts. 

Why use Redhat?
Oracle used RedHat when they ported the server to Linux and will continue to use RedHat when developing. It likely will be the least hassle to install.


Redhat Initial Install
Install any way you would like, keeping the following steps in mind as you're doing it.

A. Partitioning
1) Make swap partitions (max. 128 mb ea.) equivalent to three times RAM installed.

2) Partition the drive to your preferences. I ignored the OFA-compliance and just made one mount point (/u01). You can also fake OFA by making four directories, but you won't gain any performance from this. You'll gain some performance by creating four distinct partitions (/u01, /u02, /u03, /u04) and you'll gain the most performance by having each of these mount points on four distinct drives, as Oracle recommends. 

B. X Windows
Love it or hate it, you have to have X Windows for Oracle 8i. The installer is now GUI-based. With Redhat 6.1, you can use Gnome or KDE. They both work fine right out of the box.

C. Install options
Will the Redhat WORKSTATION installation work? Yes.
Will the RedHat SERVER installation work? Yes.
Will the RedHat CUSTOM installation work? As long as you install the following packages:

  • XWindows of some sort
  • Development
  • You can add other packages to suit your needs. 
D. If you want to reconfigure the kernel:
1) If you have the RedHat 6.1 CD, place it in your CD drive. If it doesn't automatically mount, mount it and change to the /RedHat/RPMS directory. 
  • mount -t iso9660 /dev/cdrom /mnt/cdrom
  • cd /cdrom/RedHat/RPMS
2) Install the kernel source RPM. You only need to do this if you want to change the kernel parameters:
  • rpm -ivh kernel-source-2.2.12-20.i386.rpm. This is the kernel source, so that we can recompile the kernel for new memory parameters. More on that later.
3) Change out of the cdrom directory and unmount the RedHat CD: 
  • cd /
  • umount /cdrom
Kernel memory params
The front of the Oracle installation manual lists some memory parameters which, according to the Oracle install manual, need to be changed before installing the software. 

Oracle will run fine without changing any of the RedHat parameters. This is because nearly all the RedHat parameters are already above Oracle's recommendation.
(somebody, please correct me if I am wrong).

The only parameter you MIGHT have to worry about is the SHMMAX setting, and you should only worry about this one if your machine has more than 64 megs RAM, and you are really going to do some heavy database work. If you feel like you MUST change it (and I wouldn't necessarily recommend it), here's how:

WARNING!
Changing the kernel parameters requires recompiling the Linux kernel. If you have never done this, I highly recommend you get a good book that walks you through the process and all the 100+ different options when you run the configure script. If you aren't sure of some of them, choosing the wrong one may prevent you from booting your system! 

Changing memory params
1) Change to the directory listed below and edit the shmparam.h file. 

  • cd /usr/src/linux/include/asm
  • vi shmparam.h
2) A little further down is a line that says "#define SHMMAX 0x2000000." The 0x2000000 is hex for 32 megs. Oracle says this value should be one-half of your installed memory. Change it to the appropriate value. For example, I have 128 megs RAM in my machine, so Oracle suggests I change this setting to 0x4000000, or slightly above 64 megs. 
Other values: 
0x4000000 = 67108854 
0x6000000 = 100663296
0x8000000 = 134217728

3) Save the file. 

4) You're now ready to proceed with the process of recompiling the kernel. Recompile it, then continue below. 



Stuff you have to download before installing
Java RunTime Environment
Starting with 8i, Oracle requires a Java RunTime Environment to run the installer. The bad news is that RedHat doesn't come with one, so you have to download it. the good news is it's real easy to obtain and install.

1) Login as root and use a web browser to go to http://www.blackdown.org

2) Click on the downloads link.

3) Pick an FTP site that is geographically near you.

4) The file to look for is jre_1.1.6-v5-glibc-x86.tar.gz. Do NOT download a newer version and make sure you are downloading the file that begins with jre... and NOT the one that starts with jdk... This is the wrong file.

5) Download this file to /usr/local.

6) Open a terminal window. We'll now extract the file and create a symbolic link so the Oracle Installer can find it. Run the following commands:

  • tar xzvf jre_1.1.6-v5-glibc-x86.tar.gz
  • ln -s /usr/local/jre116_v5 /usr/local/jre
7) That's all there is to it!

The oracle 8i patchset
These patches fix some critical problems in Oracle 8i for Linux. It is highly recommended you install these patches!

1) Use your web browser to go to http://technet.oracle.com.

2) If you haven't registered, do so now. It's free and and is a good site for getting help.

3) Click on the Software button.

4) On the "Select a Product" pulldown, select "8i Enterprise Edition," even if you are are installing the Standard edition. The patchset is the same.

5) Enter in your name and password when it asks.

6) Click on the appropriate product on the next screen.

7) Accept the license agreement.

3) Finally, the file you are looking for is linux_815patches.tgz

4) Save this file to root's home directory for now. We'll move it later.

Now that you have downloaded these files, it's time for the Oracle pre-install tasks.


Oracle Pre-Install
In this section, we create the necessary user groups and accounts which will ultimately manage the oracle software..

Set up Oracle account and group
The oracle account is what we will use to install software and start and stop the oracle database. It should not be used for day-to-day operations. The dba groups is for Database Administrators.

1) If you don't have a terminal window already open, open one now.

2) In the terminal windows, create your groups. 

  • groupadd dba
3) Create the oracle user.
  • useradd oracle -g dba (sub number with dba group number from above)
  • passwd oracle (to change password)


4) Remember the linux_815patches.tgz file we downloaded earlier? Let's move it to a directory within oracle's home directory now and change the permissions so oracle can run it later. Enter the following commands in a terminal window:

  • mv ~/linux_815patches.tgz /home/oracle
  • chown -R oracle.dba /home/oracle/linux_815patches.tgz
5) If you didn't make mount points with disk partitioning, make a directory for oracle, such as /u01. 
  • mkdir /u01. (You can also fake the OFA-compliancy by mkdir /u01, /u02, /u03 and /u04.
6) Change owner and group permissions on these mount points. 
  • chown oracle.dba /u01 (run same command for /u02, /u03 and /u04 if you have them)
7) Log out. 

8) Log in as oracle.

Setting up the oracle user's environment
1) If you don't have a terminal window open, open one now.

2) If your Oracle CD isn't already in the CD drive, put it in now. If it doesn't mount automatically, you can use the following commands to mount it:

  • su root (enter password)
  • mount -t iso9660 /dev/cdrom /mnt/cdrom (sub w/ your CD device locator).
  • exit (to exit superuser privileges).


3) Verify umask is 022 by typing umask [enter]. If it is, great. If not, you'll need to put it in .bash_profile, which we edit in the next step. 

4) Use your favorite editor to edit the .bash_profile file in your oracle account's home directory. Put the following lines in this file: 

  • ORACLE_HOME=/u01/app/oracle/product/8.1.5; export ORACLE_HOME
  • LD_LIBRARY_PATH=/u01/app/oracle/product/8.1.5/lib; export LD_LIBRARY_PATH
  • ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE
  • ORACLE_SID=ORCL; export ORACLE_SID
  • ORACLE_TERM=vt100; export ORACLE_TERM
  • ORA_NLS33=/u01/app/oracle/product/8.1.5/ocommon/nls/admin/data; export ORA_NLS33
  • PATH=$PATH:/u01/app/oracle/product/8.1.5/bin; export PATH
  • (optional) umask 022 (only if umask does not default to 022)
3) There is one more environment variable you need to add to your .bash_profile. it is the NLS_LANG variable and depends on which language set you want to use. You MUST add this variable or the database creation will likely fail! Here are the available values (use the quotes in your NLS_LANG variable if they appear below):

In my case, since I use US English, I'll put the following in my .bash_profile:

  • NLS_LANG=american; export NLS_LANG
Language NLS_LANG value
US English american
Arabic arabic
Brazilian Portugese "brazilian portugese"
Canadian French frc
Czech czech
Danish danish
Dutch dutch
Finnish finnish
French french
German german
Hungarian hungarian
Icelandic is
Italian italian
Japanese japanese
Korean korean
Lithuanian lt
Mexican Spanish esm
Norweigan norweigan
Polish polish
Portugese portugese
Russian russian
Simplified Chinese "simplified chinese"
Slovak slovak
Swedish swedish
Thai th
Traditional Chinese "traditional chinese"
Turkish turkish

 

3) Log out, then back in as oracle. Open a terminal window again if one isn't open and type env to see if all the above variables now appear in your environment. 

4) Also make sure all the following paths are in your path statement, in addition to the Oracle path you specified above: /bin, /usr/bin, /usr/local/bin.

5) If everything isn't there, double-check your spelling, etc. in your .bash_profile. If everything is there, great! We're ready to install some software.


Oracle Install
Since we are using RedHat, we have to run a special version of the installer. If you do NOT use RedHat try running runInstall at the CD's root level. For RedHat, follow the instructions below.

1) If your CD isn't mounted when you log back in, use a terminal windows to mount it again with the following commands:

  • su root (enter root password)
  • mount -t iso9660 /dev/cdrom /mnt/cdrom
  • exit (to exit superuser privledges).
2) In a terminal window, change to the directory containing the RedHat install script.
  • cd /mnt/cdrom/install/linux
2) Start the installer
  • ./runIns.sh
3) A GUI window appears. Welcome to the Java-based Oracle installer.

4) Click the Next button.

5) Verify that the Source path says [cd mount point]/stage/products.jar

6) The Destination path should be the same as your $ORACLE_HOME environment variable.

7) Click Next.

8) At the Unix Group Name window, enter "dba" as the group, then click Next.

9) A window will now pop up asking you to run the orainstRoot.sh script. Here is how to do that:

  • Open a new terminal window
  • su root (enter your password)
  • cd /tmp/orainstall
  • ./orainstRoot.sh
  • exit (to exit the SU privileges)
  • exit (to close the terminal session)


10) Go back to that popup window that appeared and click the Retry button.

11) You will now get the Available Products screen. Select Oracle 8i 8.1.5.0.0 and click Next.

12) On the next screen, select Custom, then Next. It seems this is the only option that works halfway decently.

13) You will now be at the Available Product Components screen. You can pretty much leave it as is. The one option you may wish to deselect is Oracle Intermedia. It doesn't work too well yet, so why bother? You're choice, though. Click Next when you finished.

14) Now, the installer asks you if you want to create a database. Select No. Even though you select No, it will still try to create one later. We just choose No for now to get rid of a few extra windows. Click Next.

15) The Oracle Protocol Support window now appears. It will be blank, which is fine. TCP/IP is always installed, so don't worry about not seeing it as an option. Click Next.

16) Finally, we're at the Summary window, which lists everything you're about to install. Click the Install button.

17) I have noticed a bug where the installer might tell you that you don't have enough disk space to install everything. If you are sure you do, just hit OK on the warning(s).

18) The software begins installing! Woo-woo!

19) After files have been copied, you will get another pop-up asking you to run the root.sh script.

  • Open a terminal window
  • su root (enter password)
  • cd $ORACLE_HOME
  • chmod 744 root.sh (fixes the script to execute)
  • ./root.sh
  • Just hit Enter when it asks for the Path to your local bin directory
  • exit (to exit superuser privileges)
  • exit (to exit the terminal window)
20) Return to that pop-up window and hit OK.

21) The Oracle Database Configuration Assistant now starts (even though we told it not to earlier).

22) You will get an error message that starts with "JNLS Exception." Ignore it. Hit OK.

23) When the Database Configuration Assistant comes up, just hit the Cancel button.

24) Confirm that you want to exit at the next window.

25) You will now get a message saying one or more tools have failed. You can ignore this window. Hit OK.

26) Hit the Next button.

27) You are now at the End of Installation screen. Hit Exit.

28) Confirm that you want to exit.

29) Now, we change permissions on some files and apply the patch.


Changing permissions and patching Oracle 8i
Changing the permissions
This script will change permissions on certain files. Use the same terminal window that you used to apply the patch.

1) Run the following commands:

  • cd $ORACLE_HOME/install/utl
  • ./linux.sh
2) Move on to applying the patch when this script finishes..

The patch
The version you just installed was Oracle 8i 8.1.5.0.0. This patch will take it to 8.1.5.0.2. Oracle strongly recommends applying this patch.

1) Do the following commands:

  • cd ~
  • tar xzvf linux_815patches.tgz
  • cd linux_815patches
  • ./linux_815patches.sh
2) You will now get a couple of messages telling you the patches are being applied. Don't worry about the message at the end telling you to link the Intelligent Agent executables.

3) It's time to create the database.


Create the Database
This is where we create the original database. This can take a long time. It took over an hour on my Pentium III 450.

1) In your teminal window, enter the following command:

  • dbassist &
2) You will once again get the annoying but meaningless JNLS Exception error. Hit OK.

3) Select Create a Database and hit Next.

4) Select Custom and hit Next.

5) You can pretty much accept the defaults on the next four screens. Hit Next through them, stopping at the screen that asks you for the Global Database Name.

6) At this prompt, enter a name to identify this database. The name MUST be eight characters or less. Your SID should also be the same as you entered earlier in your environment variables.

7) Hit Next.

8) You can accept the defaults through the next six screens. Hit next until you get to the window that asks to Create database now.

9) Make sure Create database now is selected, then hit the Finish button.

10) Confirm that you want to proceed by hitting Yes.

11) Go get some lunch or watch TV. It's going to take a while.

12) When the database creation is finished, you will get a message saying so. Hit OK and proceed to the post-install tasks.



Oracle post-install
Now comes the fun part!

IMPORTANT! Default passwords
Oracle installed two accounts off the bat for administering the database. Here are the names and passwords for both:
sys - change_on_install
system - manager


1) Use the same terminal window as before. 

2) If you want to access the Oracle server with the GUI management tools from another PC, you will need to start the TNS listener. The default config works for most TCP/IP installations, but you may need to change it. It worked for us. 

  • lsnrctl start
3) The Oracle Server should be running. If not, you can start it with the following commands:
  • svrmgrl
  • connect internal
  • startup
  • quit
4) If you want to set up the sample tables for user scott/tiger, you can do it this way:
  • cd $ORACLE_HOME/rdbms/admin
  • sqlplus (Connect as sys)
  • @utlsampl.sql
5) Now start SQLPlus and login as user scott and password "tiger". Do a "select * from emp" and you should get some records back.

6) You should now be able to create users tables etc. Your RDBMS is up and running!

上一篇:下一篇: