一硬件
曙光服务器G RAM / XERON CPU/ SCSI HD
二操作系统
RH SERVER/ G SWAP/用一块硬盘建立ORACLE分区其它用另一块
三设置内核
echo > /proc/sys/kernel/sem
echo > /proc/sys/kernel/shmmax
echo > /proc/sys/fs/filemax
ulimit n
echo > /proc/sys/net/ipv/ip_local_port_change
ulimit u
四安装JDK
听说O不需要安装JDK不过还是安装的好装在/usr/local/java中
五建立组用户目录
groupadd oinstall
groupadd dba
groupadd oper
groupadd apache
useradd g oinstall G dba oracle
passwd oracle
useradd g oinstall G apache apache
passwd apache
mkdir /oracle/oracle/product
mkdir /oracle/oracle/product/
chown R oracleoinstall /oracle/oracle
六建立文件 bash_profile放在oracle用户主目录下
ORACLE_BASE=/oracle/oracle; export ORACLE_BASE
ORACLE_HOME=$ORACLE_BASE/product/; export ORACLE_HOME
ORACLE_TERM=xterm; export ORACLE_TERM
PATH=$PATH:$ORACLE_HOME/bin:/usr/local/java/bin; export PATH
ORACLE_SID=ora; export ORACLE_SID
LD_LIBRARY_PATH=$ORACLE_HOME/lib; export LD_LIBRARY_PATH
CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib; export CLASSPATH
TMP=/temp; export TMP
TMPDIR=$TMP; export TMPDIR
七准备oraclei源盘
gunzip lnx__diskcpiogz
gunzip lnx__diskcpiogz
gunzip lnx__diskcpiogz
cpio idmv < lnx__diskcpio
cpio idmv < lnx__diskcpio
cpio idmv < lnx__diskcpio
八安装
#export DISPLAY=本机名:
# /Disk/runInstaller
九安装中的错误
希望不要碰到错误但是免不了我碰到的是无法启动net configer assistantdatabase configer assitant
还用很多错误如果是mk 的错误请用ignore
十创建数据库
dbca 不能启动只能自己创建数据库
建立initsidora
在$ORACLE_HOME/dbs/下 #cp initora initorora
用编辑器把initorora中的数据库名改为实例名
sqlplus /nolog 启动sqlplus 下面是sqlplus 中的操作
connect sys/change_on_install as sysdba;
startup nomount;
@createdatabase; 建立数据库
@createtablespace 建立表空间
@createDL –建立数据字典
createdatabasesql
CREATE DATABASE or
LOGFILE $ORACLE_HOME/dbs/or/oradata/redolog SIZE K
$ORACLE_HOME/dbs/or/oradata/redolog SIZE K
$ORACLE_HOME/dbs/or/oradata/redolog SIZE K
MAXLOGFILES
MAXLOGMEMBERS
MAXLOGHISTORY
DATAFILE $ORACLE_HOME/dbs/or/oradata/systemdbf SIZE M REUSE AUTOEXTEND ON NEXT K
MAXDATAFILES
MAXINSTANCES
createtablespace
CREATE TABLESPACE RBS DATAFILE $ORACLE_HOME/dbs/or/oradata\rbsdbf SIZE M REUSE
AUTOEXTEND ON NEXT K
MINIMUM EXTENT K
DEFAULT STORAGE ( INITIAL K NEXT K MINEXTENTS MAXEXTENTS )
/
CREATE TABLESPACE USERS DATAFILE $ORACLE_HOME/dbs/or/oradata\usersdbf SIZE M REUSE
AUTOEXTEND ON NEXT K
MINIMUM EXTENT K
DEFAULT STORAGE ( INITIAL K NEXT K MINEXTENTS MAXEXTENTS PCTINCREASE )
/
CREATE TABLESPACE TEMP DATAFILE $ORACLE_HOME/dbs/or/oradata\tempdbf SIZE M REUSE
AUTOEXTEND ON NEXT K
MINIMUM EXTENT K
DEFAULT STORAGE ( INITIAL K NEXT K MINEXTENTS MAXEXTENTS UNLIMITED PCTINCREASE ) TEMPORARY
/
CREATE TABLESPACE TOOLS DATAFILE $ORACLE_HOME/dbs/or/oradata\toolsdbf SIZE M REUSE
AUTOEXTEND ON NEXT K
MINIMUM EXTENT K
DEFAULT STORAGE ( INITIAL K NEXT K MINEXTENTS MAXEXTENTS PCTINCREASE )
/
CREATE TABLESPACE INDX DATAFILE $ORACLE_HOME/dbs/or/oradata\indxdbf SIZE M REUSE
AUTOEXTEND ON NEXT K
MINIMUM EXTENT K
DEFAULT STORAGE ( INITIAL K NEXT K MINEXTENTS MAXEXTENTS PCTINCREASE )
/
CREATE PUBLIC ROLLBACK SEGMENT RBS TABLESPACE RBS STORAGE ( OPTIMAL K )
/
CREATE PUBLIC ROLLBACK SEGMENT RBS TABLESPACE RBS STORAGE ( OPTIMAL K )
/
CREATE PUBLIC ROLLBACK SEGMENT RBS TABLESPACE RBS STORAGE ( OPTIMAL K )
/
CREATE PUBLIC ROLLBACK SEGMENT RBS TABLESPACE RBS STORAGE ( OPTIMAL K )
/
CREATE PUBLIC ROLLBACK SEGMENT RBS TABLESPACE RBS STORAGE ( OPTIMAL K )
/
CREATE PUBLIC ROLLBACK SEGMENT RBS TABLESPACE RBS STORAGE ( OPTIMAL K )
/
CREATE PUBLIC ROLLBACK SEGMENT RBS TABLESPACE RBS STORAGE ( OPTIMAL K )
/
CREATE PUBLIC ROLLBACK SEGMENT RBS TABLESPACE RBS STORAGE ( OPTIMAL K )
/
CREATE PUBLIC ROLLBACK SEGMENT RBS TABLESPACE RBS STORAGE ( OPTIMAL K )
/
CREATE PUBLIC ROLLBACK SEGMENT RBS TABLESPACE RBS STORAGE ( OPTIMAL K )
/
CREATE PUBLIC ROLLBACK SEGMENT RBS TABLESPACE RBS STORAGE ( OPTIMAL K )
/
CREATE PUBLIC ROLLBACK SEGMENT RBS TABLESPACE RBS STORAGE ( OPTIMAL K )
/
CREATE PUBLIC ROLLBACK SEGMENT RBS TABLESPACE RBS STORAGE ( OPTIMAL K )
/
CREATE PUBLIC ROLLBACK SEGMENT RBS TABLESPACE RBS STORAGE ( OPTIMAL K )
/
CREATE PUBLIC ROLLBACK SEGMENT RBS TABLESPACE RBS STORAGE ( OPTIMAL K )
/
CREATE PUBLIC ROLLBACK SEGMENT RBS TABLESPACE RBS STORAGE ( OPTIMAL K )
/
CREATE PUBLIC ROLLBACK SEGMENT RBS TABLESPACE RBS STORAGE ( OPTIMAL K )
/
CREATE PUBLIC ROLLBACK SEGMENT RBS TABLESPACE RBS STORAGE ( OPTIMAL K )
/
CREATE PUBLIC ROLLBACK SEGMENT RBS TABLESPACE RBS STORAGE ( OPTIMAL K )
/
CREATE PUBLIC ROLLBACK SEGMENT RBS TABLESPACE RBS STORAGE ( OPTIMAL K )
/
CREATE PUBLIC ROLLBACK SEGMENT RBS TABLESPACE RBS STORAGE ( OPTIMAL K )
/
CREATE PUBLIC ROLLBACK SEGMENT RBS TABLESPACE RBS STORAGE ( OPTIMAL K )
/
CREATE PUBLIC ROLLBACK SEGMENT RBS TABLESPACE RBS STORAGE ( OPTIMAL K )
/
CREATE PUBLIC ROLLBACK SEGMENT RBS TABLESPACE RBS STORAGE ( OPTIMAL K )
/
CREATE PUBLIC ROLLBACK SEGMENT RBS TABLESPACE RBS STORAGE ( OPTIMAL K )
/
ALTER ROLLBACK SEGMENT RBS ONLINE
/
ALTER ROLLBACK SEGMENT RBS ONLINE
/
ALTER ROLLBACK SEGMENT RBS ONLINE
/
ALTER ROLLBACK SEGMENT RBS ONLINE
/
ALTER ROLLBACK SEGMENT RBS ONLINE
/
ALTER ROLLBACK SEGMENT RBS ONLINE
/
ALTER ROLLBACK SEGMENT RBS ONLINE
/
ALTER ROLLBACK SEGMENT RBS ONLINE
/
ALTER ROLLBACK SEGMENT RBS ONLINE
/
ALTER ROLLBACK SEGMENT RBS ONLINE
/
ALTER ROLLBACK SEGMENT RBS ONLINE
/
ALTER ROLLBACK SEGMENT RBS ONLINE
/
ALTER ROLLBACK SEGMENT RBS ONLINE
/
ALTER ROLLBACK SEGMENT RBS ONLINE
/
ALTER ROLLBACK SEGMENT RBS ONLINE
/
ALTER ROLLBACK SEGMENT RBS ONLINE
/
ALTER ROLLBACK SEGMENT RBS ONLINE
/
ALTER ROLLBACK SEGMENT RBS ONLINE
/
ALTER ROLLBACK SEGMENT RBS ONLINE
/
ALTER ROLLBACK SEGMENT RBS ONLINE
/
ALTER ROLLBACK SEGMENT RBS ONLINE
/
