linux、aix上oracle 9i拷贝安装步骤:
1、将oracle打包上传解压;
打包、上传、解压;
tar -zcvf *.tar.gz *
ftp *
tar -zxvf *.tar.gz
2、创建用户:
mkdir -p /oracle
groupadd -g 115 dba
useradd -u 173 -c "Oracle Owner" -d /oracle -g "dba" -m -s /bin/bash oracle
3、配置参数文件
export ORACLE_SID=ORA920
export ORACLE_BASE=/oracle
export ORACLE_HOME=$ORACLE_BASE/product/9.2.0
export ORACLE_DOC=$ORACLE_HOME/doc
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib:/usr/local/lib
export TNS_ADMIN=$ORACLE_HOME/network/admin
export NLS_LANG=AMERICAN_AMERICA.AL32UTF8
export ORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/data
export ORACLE_OWNER=oracle
export ORACLE_TERM=xterm
# +--------------------------+
# | LINUX STUFF |
# +--------------------------+
export LD_ASSUME_KERNEL=2.4.19
export THREADS_FLAG=native
# +--------------------------+
# | SETUP SEARCH PATH |
# +--------------------------+
PATH=$ORACLE_HOME/bin:/opt/bin:/bin:/usr/bin:/usr/local/bin:/usr/sbin:/usr/X11R6/bin:/usr/local/java/bin:.
# +--------------------------+
# | SETUP JAVA ENVIRONMENT |
# +--------------------------+
export JAVA_HOME=/usr/java/jdk1.6.0_18
export CLASSPATH=$ORACLE_HOME/jdbc/lib/ojdbc14.jar:$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib:$ORACLE_HOME/network/jlib:.
4、运行root。sh文件;
必须切换root用户。sh root.sh
5、准备收工创建数据库
创建相关目录、配置参数文件等。
mkdir -p /u1/oradata/ORA920/
mkdir -p /u2/oradata/ORA920/
mkdir -p /u3/oradata/ORA920/
mkdir -p /u4/oradata/ORA920/
mkdir -p /u5/oradata/ORA920/
其实,拷贝安装时,会把原机器参数文件拷贝过来。注意针对本机作可能的参数调整。
6、创建数据库。
rm $ORACLE_HOME/dbs/orapwORA920
orapwd file=$ORACLE_HOME/dbs/orapwORA920 password=admin entries=5
connect SYS/change_on_install as SYSDBA
spool create_dilas_database.log
startup nomount
CREATE DATABASE "ORA920" ARCHIVELOG
MAXLOGFILES 32
MAXLOGMEMBERS 5
MAXDATAFILES 600
MAXINSTANCES 10
MAXLOGHISTORY 1000
DATAFILE
'/u1/oradata/ORA920/system01.dbf' size 80M
REUSE
AUTOEXTEND ON NEXT 50M MAXSIZE UNLIMITED
EXTENT MANAGEMENT LOCAL
DEFAULT TEMPORARY TABLESPACE temp
TEMPFILE '/u1/oradata/ORA920/temp01.dbf' SIZE 300M REUSE
AUTOEXTEND ON NEXT 5M MAXSIZE 800M
UNDO TABLESPACE "UNDOTBS1"
DATAFILE '/u1/oradata/ORA920/undotbs1_01.dbf' SIZE 300M REUSE
AUTOEXTEND ON NEXT 5M MAXSIZE 800M
CHARACTER SET AL32UTF8
NATIONAL CHARACTER SET AL16UTF16
LOGFILE
GROUP 1
('/u1/oradata/ORA920/redo_g01a.log',
'/u2/oradata/ORA920/redo_g01b.log',
'/u3/oradata/ORA920/redo_g01c.log') SIZE 20M,
GROUP 2
( '/u1/oradata/ORA920/redo_g02a.log',
'/u2/oradata/ORA920/redo_g02b.log',
'/u3/oradata/ORA920/redo_g02c.log') SIZE 20M,
GROUP 3
( '/u1/oradata/ORA920/redo_g03a.log',
'/u2/oradata/ORA920/redo_g03b.log',
'/u3/oradata/ORA920/redo_g03c.log') SIZE 20M
/
connect SYS/change_on_install as SYSDBA
@$ORACLE_HOME/rdbms/admin/catalog.sql;
@$ORACLE_HOME/rdbms/admin/catproc.sql;
connect SYSTEM/manager
@$ORACLE_HOME/sqlplus/admin/pupbld.sql;
connect SYSTEM/manager
set echo on
@$ORACLE_HOME/sqlplus/admin/help/hlpbld.sql helpus.sql;
spool off
exit
7、搞定。
拷贝安装简单、速度快、无副作用。AIX和linux操作系统上屡试不爽。
1、将oracle打包上传解压;
打包、上传、解压;
tar -zcvf *.tar.gz *
ftp *
tar -zxvf *.tar.gz
2、创建用户:
mkdir -p /oracle
groupadd -g 115 dba
useradd -u 173 -c "Oracle Owner" -d /oracle -g "dba" -m -s /bin/bash oracle
3、配置参数文件
export ORACLE_SID=ORA920
export ORACLE_BASE=/oracle
export ORACLE_HOME=$ORACLE_BASE/product/9.2.0
export ORACLE_DOC=$ORACLE_HOME/doc
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib:/usr/local/lib
export TNS_ADMIN=$ORACLE_HOME/network/admin
export NLS_LANG=AMERICAN_AMERICA.AL32UTF8
export ORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/data
export ORACLE_OWNER=oracle
export ORACLE_TERM=xterm
# +--------------------------+
# | LINUX STUFF |
# +--------------------------+
export LD_ASSUME_KERNEL=2.4.19
export THREADS_FLAG=native
# +--------------------------+
# | SETUP SEARCH PATH |
# +--------------------------+
PATH=$ORACLE_HOME/bin:/opt/bin:/bin:/usr/bin:/usr/local/bin:/usr/sbin:/usr/X11R6/bin:/usr/local/java/bin:.
# +--------------------------+
# | SETUP JAVA ENVIRONMENT |
# +--------------------------+
export JAVA_HOME=/usr/java/jdk1.6.0_18
export CLASSPATH=$ORACLE_HOME/jdbc/lib/ojdbc14.jar:$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib:$ORACLE_HOME/network/jlib:.
4、运行root。sh文件;
必须切换root用户。sh root.sh
5、准备收工创建数据库
创建相关目录、配置参数文件等。
mkdir -p /u1/oradata/ORA920/
mkdir -p /u2/oradata/ORA920/
mkdir -p /u3/oradata/ORA920/
mkdir -p /u4/oradata/ORA920/
mkdir -p /u5/oradata/ORA920/
其实,拷贝安装时,会把原机器参数文件拷贝过来。注意针对本机作可能的参数调整。
6、创建数据库。
rm $ORACLE_HOME/dbs/orapwORA920
orapwd file=$ORACLE_HOME/dbs/orapwORA920 password=admin entries=5
connect SYS/change_on_install as SYSDBA
spool create_dilas_database.log
startup nomount
CREATE DATABASE "ORA920" ARCHIVELOG
MAXLOGFILES 32
MAXLOGMEMBERS 5
MAXDATAFILES 600
MAXINSTANCES 10
MAXLOGHISTORY 1000
DATAFILE
'/u1/oradata/ORA920/system01.dbf' size 80M
REUSE
AUTOEXTEND ON NEXT 50M MAXSIZE UNLIMITED
EXTENT MANAGEMENT LOCAL
DEFAULT TEMPORARY TABLESPACE temp
TEMPFILE '/u1/oradata/ORA920/temp01.dbf' SIZE 300M REUSE
AUTOEXTEND ON NEXT 5M MAXSIZE 800M
UNDO TABLESPACE "UNDOTBS1"
DATAFILE '/u1/oradata/ORA920/undotbs1_01.dbf' SIZE 300M REUSE
AUTOEXTEND ON NEXT 5M MAXSIZE 800M
CHARACTER SET AL32UTF8
NATIONAL CHARACTER SET AL16UTF16
LOGFILE
GROUP 1
('/u1/oradata/ORA920/redo_g01a.log',
'/u2/oradata/ORA920/redo_g01b.log',
'/u3/oradata/ORA920/redo_g01c.log') SIZE 20M,
GROUP 2
( '/u1/oradata/ORA920/redo_g02a.log',
'/u2/oradata/ORA920/redo_g02b.log',
'/u3/oradata/ORA920/redo_g02c.log') SIZE 20M,
GROUP 3
( '/u1/oradata/ORA920/redo_g03a.log',
'/u2/oradata/ORA920/redo_g03b.log',
'/u3/oradata/ORA920/redo_g03c.log') SIZE 20M
/
connect SYS/change_on_install as SYSDBA
@$ORACLE_HOME/rdbms/admin/catalog.sql;
@$ORACLE_HOME/rdbms/admin/catproc.sql;
connect SYSTEM/manager
@$ORACLE_HOME/sqlplus/admin/pupbld.sql;
connect SYSTEM/manager
set echo on
@$ORACLE_HOME/sqlplus/admin/help/hlpbld.sql helpus.sql;
spool off
exit
7、搞定。
拷贝安装简单、速度快、无副作用。AIX和linux操作系统上屡试不爽。
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/83911/viewspace-674296/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/83911/viewspace-674296/