資料介紹

• 數據庫SQL Server/Oracle/MySQL/DB2教程

http://www.oracle.com/admin/images/ocom/oralogo_small.gif

為了方便大家使用，我寫的一個安裝文檔，僅供參考

安裝方法（原創）

安裝前准備
1.1. 創建用戶和組
# scoadmin->account manager->groups->add new group
創建 dba組
users->add new user
創建oracle用戶，並把oracle用戶添加到dba組去，更改Login group 為dba組
1.2. 修改環境變量
用oracle用戶登錄
# su – oracle
編輯.profile文件
$ vi .profile
在文件中加入下面幾行
ORACLE_BASE=/u/oracle
ORACLE_HOME=/u/oracle/product/734
ORACLE_SID=oracle
ORACLE_TERM=ansi
LD_LIBRARY_PATH=$ORACLE_HOME/lib:/usr/lib
ORACLE_NLS32=$ORACLE_HOME/ocommon/nls/admin/data
ORACLE_PATH=$ORACLE_HOME/bin:/bin:/usr/bin:/opt/bin:/usr/lbin:.
ULIMIT=2297152
TERM=ansi
TMPDIR=/u/tmp
PATH=$PATH:$HOME/bin:$ORACLE_HOME/bin:/opt/bin:/usr/lbin:.
export ORACLE_BASE ORACLE_HOME ORACLE_SID
export ORACLE_TERM LD_LIBRARY_PATH
export ORACLE_NLS32 ORACLE_PATH ULIMIT TERM TMPDIR PATH
NLS_LANG=AMERICAN_AMERICA.ZHS16CGB231280
export NLS_LANG
export LANG=english_us.8859
set –o vi
export EDITOR=vi


1.3. 特殊設置
SCO505用戶
需要打補丁oss459b
# mv oss459b /tmp/VOL.000.000
# custom->Software->Install New->From scosysv->Media Image
輸入路徑 /tmp
然後就OK了。
如果沒有補丁，這裡有 （在資源中的安裝文檔裡）
SCO507用戶
$ su –
Passwd:
# cd /opt/K/SCO/unixds/5.2.0A/usr/ccs/lib
下面這兩個文件不要弄丟了，裝完後還要改回來
# mv crt0.o crt0.o.bak
# mv crt1.o crt1.o.bak
從SCO5.0.5的/opt/K/SCO/unixds/5.1.1A//lib下把這兩個同名文件COPY過來。如果你沒有，點擊這裡 （在資源的安裝文檔裡）
1.4. 建臨時目錄
$ su –
Passwd:
# mkdir /u/tmp
# chmod 777 tmp
# vi /etc/services
找到1521這個端口，把這一行用“#”注釋掉，再添加一行
listener 1521/tcp
1.5. 改核心參數
# /etc/conf/bin/idtune NBUF 20000
# /etc/conf/bin/idtune NHBUF 262144
# /etc/conf/bin/idtune NMPBUF 500
# /etc/conf/bin/idtune MAXUP 300
# /etc/conf/bin/idtune SEMMNI 70
# /etc/conf/bin/idtune SHMMAX 65536000
重新連接核心
# /etc/conf/cf.d/link_unix -y
# sync
# reboot

1.6. 開始安裝
# mount /dev/cd0 /mnt
# su – oracle
$ cd /mnt/orainst
$ ./orainst
當出現
Select the installation method,
either Default Install or Custom Install, and whether
you want to view the Readme files:
選擇Custom Install
當出現
Select the Installer activity:
選擇默認Install, Upgrade, or De-Install Software
當出現
Select the Installer option:
Note: there are two different Install New Product
options.
選擇Install New Product - Create DB Objects
當出現
Confirm, change, or enter values for the environment variables
listed:
直接回車
當出現
Confirm (or Change) Log File Location:
If current versions of these log files exist in these locations,
they will be archived and reinitialized. Select Help for more
details.
直接回車
當出現
Your platform requires the root user to perform certain pre-
installation OS preparation. The root user should run the shell
script 'rootpre.sh' before you proceed with Oracle installation.
rootpre.sh can be found in the newoi/ directory (if installing
from tape) or the orainst/ directory (if installing from CDROM).

Select (Yes) if root has run 'rootpre.sh' so you can proceed with
Oracle installation. Select (No) to abort installation and then
ask root to run 'rootpre.sh'.
先不要動，重新開一屏，用root登錄
# cp /mnt/orainst/rootpre.sh /tmp
# cp /mnt/orainst/orafiles
# cd /tmp
# vi rootpre.sh
在ORACLE_LPSTAT="/usr/bin/lpstat"下面一行加一個環境變量ORACLE_HOME
ORACLE_HOME= /u/oracle/product/734
# sh rootpre.sh
Do you want to install Oracle Icons for SCO ODT System? (Y/N) N
Exit Oracle Icon Installation
Continue with rootpre.sh ? (Y/N) y
Please enter the name of oracle user: oracle
Please enter the group the oracle user belongs to: dba
The following files will be created:
Filename Owner Group Mode
/usr/lbin/oraenv oracle dba 644
/usr/lbin/coraenv oracle dba 644
/usr/lbin/dbhome oracle dba 755
/etc/oratab oracle dba 644
/etc/sqlnet oracle dba 644
/etc/tnsnames.ora oracle dba 644
/etc/listener.ora oracle dba 644
Continue with the above settings? (Y/N) y
Are you installing Oracle through a floppy device? (Y/N) n
Please continue installation with Oracle*Installer as oracle user.
OK後，再切到原來的shell，選擇(YES)繼續
當出現
Select one of the following:
選擇(o) Install from CD-ROM
當出現
Select the native language to be installed:
選擇Simplified Chinese
當出現
Do you want to relink Oracle product executables? By default, the
Installer will not relink any product executables, with the
exception of the Oracle7 Server, which is relinked automatically
if necessary.
選擇默認
當出現
Post-installation steps that need to be run by root will
be written to /u/oracle/product/734/orainst/root.sh.
選擇默認

然後選擇你要安裝的組件
安裝完成後
# cd /u/oracle/product/734/orainst
# sh root.sh
Running ORACLE7 root.sh script...

The following environment variables are set as:
ORACLE_OWNER= oracle
ORACLE_HOME= /u/oracle/product/734
ORACLE_SID= oracle
Are these settings correct (Y/N)? [Y]: y

Enter the full pathname of the local bin directory [/usr/lbin]:

Checking for "oracle" user id...
ORACLE_HOME does not match the home directory for oracle.
Okay to continue? [N]: y
Updating /etc/oratab file...

Leaving common section of ORACLE7 root.sh.
現在你的ORACLE就可以用了。