Home Database Mysql Tutorial Solaris10 sparc 安装Oracle 9i之实践

Solaris10 sparc 安装Oracle 9i之实践

Jun 07, 2016 pm 04:57 PM
oracle

A.硬件配置要求 安装Oracle 9i要求的最低硬件配置如下: Memory:512MB Swap space:1G Disk space: Database s

A.硬件配置要求
 安装Oracle 9i要求的最低硬件配置如下:  
  Memory:512MB
  Swap space:1G
  Disk space: Database software:3.5G;seed database:1G
  Temporary disk space:400MB in /tmp 
1. 如果swap不够,执行下面:
#mkfile 1000m filename
#swap -a filename
#swap -l
note: swap选项: -a表示增加,-l表list, -d表delete.
2. 临时目录/tmp不够:
# mkdir tmp
# chmod 777 tmp
# set TEMP=/tmp; export TEMP
# set TMPDIR=/tmp ;export TEMP
B.设置系统参数:
1。配置系统信息:
#vi /etc/system
添加下面
set shmsys:shminfo_shmmax=268435456
set shmsys:shminfo_shmmin=1
set shmsys:shminfo_shmmni=100
set shmsys:shminfo_shmseg=10
set semsys:seminfo_semmni=110
set semsys:seminfo_semmns=1024

2。设置用户/组
#groupadd dba
#useradd -g dba -d /export/home/oracle -m oracle
#passwd //设定密码。
3. 退出root, 启动 user oracle
#su - oracle
#vi .profile
添加下面:
ORACLE_BASE=/export/home/oracle
ORACLE_HOME=$ORACLE_BASE/product/9.0
ORACLE_SID=9i
PATH=$ORACLE_HOME/bin:/usr/sbin:/usr/bin:/bin
TMPDIR=/var/tmp
LD_LIBRARY_PATH=$ORACLE_HOME/lib:$ORACLE_HOME/network/lib:/usr/lib
export ORACLE_BASE ORACLE_HOME ORACLE_SID PATH TMPDIR LD_LIBRARY_PATH
DISPLAY=172.16.244.83:0.0
export DISPLAY
umask 022

执行.profile, 让其生效。
#./.profile
#sync
#sync //同步。
#su
#reboot


C.用oracle用户登陆系统,下载ORACLE软件,地址如下:

选择:Oracle9iDatabase Release 2 Enterprise Edition for Sun SPARC Solaris (64-bit)
下载三个文件:
solaris64_9.2.0.1.0.disk1.cpio.gz
solaris64_9.2.0.1.0.disk3.cpio.gz
solaris64_9.2.0.1.0.disk2.cpio.gz
1. gunzip solaris64_9.2.0.1.0.disk1.cpio.gz, 用gunzip解包
2. 用cpio -idmv 将三个文件按照这个顺序都导出来

D.安装
1。打开Disk1,运行runinstaller
$./runinstaller
2.开始安装,时间比较长,其中会提示换盘,在提示中要修改PATH为:/$SOURCEFILE/disk2 & /$SOURCEFILE/disk3
3.根据提示一一下一步, 在安装完成时候,,会让你用root运行,/$oraclehome/bin/root.sh
4.运行完后,在点击ok, 继续安装。
5。全部完成后,设置数据库sys,system密码。
6。用sqlplus 检验。
$ sqlplus /nolog
$ connect / as sysdba
$ startup (or shutdown)
启动监听
$lsnrctl start
停止监听
$lsnrctl stop
E. Oracle服务器在操作系统启动时自动开始
1. 修改文件/var/opt/oracle/oratab
#su -oracle

$ cd /var/opt/oracle

$ vi oratab //将ota:/home/oracle/product/9.2:N中最后的N修改为Y

2. 编写启动脚本/etc/init.d/dbora

#su - root

$ cd /etc/init.d

$ vi dbora

ORACLE_HOME=/home/oracle/product/9.2

ORACLE_OWNER=oracle

if [ ! "$1" ]; then echo "no parameter"; exit; fi

if [ ! -f $ORACLE_HOME/bin/dbstart -o ! -d $ORACLE_HOME]

then

echo "Oracle startup: cannot start"

exit

fi

case "$1" in

'start')

su - $ORACLE_OWNER -c "$ORACLE_HOME/bin/dbstart"

su - $ORACLE_OWNER -c "Isnrctl start listener"

;;

'stop')

su - $ORACLE_OWNER -c "$ORACLE_HOME/bin/dbshut &"

su - $ORACLE_OWNER -c "lsnrctl stop listener &"

sleep 30 #give datebase some time to shutdown

;;

esac

$ ln -s /etc/init.d/dbora /etc/rc0.d/K10dbora

$ ln -s /etc/init.d/dbora /etc/rc2.d/S99dbora

$ reboot // 重启系统检查

linux

Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

Hot Article Tags

Notepad++7.3.1

Notepad++7.3.1

Easy-to-use and free code editor

SublimeText3 Chinese version

SublimeText3 Chinese version

Chinese version, very easy to use

Zend Studio 13.0.1

Zend Studio 13.0.1

Powerful PHP integrated development environment

Dreamweaver CS6

Dreamweaver CS6

Visual web development tools

SublimeText3 Mac version

SublimeText3 Mac version

God-level code editing software (SublimeText3)

Function to calculate the number of days between two dates in oracle Function to calculate the number of days between two dates in oracle May 08, 2024 pm 07:45 PM

Function to calculate the number of days between two dates in oracle

How long will Oracle database logs be kept? How long will Oracle database logs be kept? May 10, 2024 am 03:27 AM

How long will Oracle database logs be kept?

The order of the oracle database startup steps is The order of the oracle database startup steps is May 10, 2024 am 01:48 AM

The order of the oracle database startup steps is

How to use interval in oracle How to use interval in oracle May 08, 2024 pm 07:54 PM

How to use interval in oracle

Oracle database server hardware configuration requirements Oracle database server hardware configuration requirements May 10, 2024 am 04:00 AM

Oracle database server hardware configuration requirements

How to see the number of occurrences of a certain character in Oracle How to see the number of occurrences of a certain character in Oracle May 09, 2024 pm 09:33 PM

How to see the number of occurrences of a certain character in Oracle

How to determine whether two strings are contained in oracle How to determine whether two strings are contained in oracle May 08, 2024 pm 07:00 PM

How to determine whether two strings are contained in oracle

How much memory does oracle require? How much memory does oracle require? May 10, 2024 am 04:12 AM

How much memory does oracle require?

See all articles