oracle安装
建立组和用户
groupadd -g 601 dba
useradd -u 801 -g dba -G dba oracle
查看系统物理内存
# grep MemTotal /proc/meminfo
查看系统交换空间
# /sbin/swapon –s
修改计算机名
# vi /etc/hosts
127.0.0.1 PKIBM7 localhost.localdomain localhost
192.168.123.7 PKIBM7
192.168.123.8 PKIBM7
修改网络配置
# vi /etc/sysconfig/network
NETWORKING=yes
HOSTNAME=PKIBM7
重起网络
# service network restart
修改系统参数
# vi /etc/sysctl.conf
###bgn
kernel.sysrq=1
kernel.msgmni=1024
kernel.shmmax=2147483648
kernel.shmmni=4906
kernel.shmall=2097152
kernel.sem=1024 64000 200 512
fs.file-max=65536
net.ipv4.ip_local_port_range=1024 65000
net.ipv4.tcp_sack=0
net.ipv4.tcp_timestamps=0
net.ipv4.tcp_max_syn_backlog=8192
net.ipv4.tcp_keepalive_time=120
net.core.rmem_default=262144
net.core.rmem_max=262144
net.core.wmem_default=262144
net.core.wmem_max=262144
###end
使内核参数生效
/sbin/sysctl –p
切换到oracle用户
su – oracle
修改Oracle用户配置文件
$ vi .bash_profile
###bgn
export LD_ASSUME_KERNEL=2.4.1
export LC_CTYPE=en_US.UTF-8
export ORACLE_SID= SYTSP
export ORACLE_BASE=/oraapp/oracle
export ORACLE_HOME=/oraapp/oracle/92
export TNS_ADMIN=$ORACLE_HOME/network/admin
export ORA_DB=$ORACLE_HOME/dbs
export ORACLE_BDUMP=$ORACLE_BASE/shtkt/bdump
export ORACLE_TERM=xterm
export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK
export ORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/data
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib:/usr/local/lib
export LIBPATH=$ORACLE_HOME/lib:$ORACLE_HOME/ctx/lib
export CLASSPATH=$ORACLE_HOME/JRE/lib:$ORACLE_HOME/JRE/lib/rt.jar:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib
PATH=$PATH:$HOME/bin:$ORACLE_HOME/bin
export PATH
umask 022
###end
使oracle用户配置文件生效
$ source .bash_profile
添加安全限制
# vi /etc/security/limits.conf
###bgn
* soft nproc 2047
* hard nproc 16384
* soft nofile 1024
* hard nofile 65536
###end
添加登陆模块
# vi /etc/pam.d/login
###bgn
session required /lib/security/pam_limits.so
###end
修改系统配置文件
# vi /etc/profile
###bgn
if [ $USER = "oracle" ]; then
if [ $SHELL = "/bin/ksh" ]; then
ulimit -p 16384
ulimit -n 65536
else
ulimit -u 16384 -n 65536
fi
fi
###end
$ ulimit ##验证
把编译器降版本
# mv /usr/bin/gcc /usr/bin/gcc34
# ln -s /usr/bin/gcc32 /usr/bin/gcc
# mv /usr/bin/g++ /usr/bin/g++34
# ln -s /usr/bin/g++32 /usr/bin/g++
文件系统
[root@PKIBM95 ~]# df -h
Filesystem |
Size |
Used |
Avail |
Use% |
Mounted on |
/dev/hda3 |
20G |
2.7G |
17G |
15% |
/ |
/dev/hda1 |
99M |
8.4M |
86M |
9% |
/boot |
none |
502M |
0 |
502M |
0% |
/dev/shm |
/dev/hda2 |
20G |
77M |
19G |
1% |
/oradata |
安装oracle
开启smb服务
# vi /etc/samba/smb.conf
###
path=/home/oracle/pub
vailduser=oracle
public=Yes
writable=Yes
comment="......."
###
测试 # testparm
修改密码 # smbpasswd -a oracle
启动服务 # service smb restart
关闭防火墙 # setup
解压资源包
gunzip
cpio -idmv <
安装
先安装缺失的资源包
[root@PKIBM6 pub]# rpm -ivh libaio-devel-0.3.103-3.i386.rpm
[root@PKIBM6 pub]# rpm -ivh compat-oracle-rhel4-1.0-5.i386.rpm
[root@PKIBM6 pub]# rpm -ivh compat-libcwait-2.1-1.i386.rpm
目录
# mkdir /oraapp
# chown oracle:dba /oraapp
# su – oracle
$ mkdir -p /oraapp/oracle/oralnventory
$ mkdir -p /oraapp/oracle/92
在服务器上运行
# xhost +
# su – oracle
DISK1中的./runInstaller
数据库建立
在PKIBM6上面
SYTSPcreate.sql
CONNECT SYS/sys AS SYSDBA
SET ECHO ON
SPOOL createDB.log
STARTUP NOMOUNT PFILE='/oraapp/oracle/92/dbs/initSYTSP.ora'
CREATE DATABASE SYTSP
LOGFILE
GROUP 1 ('/oradata/SYTSP/data/SYTSP_redo11','/oradata/SYTSP/data/SYTSP_redo12') SIZE 5M,
GROUP 2 ('/oradata/SYTSP/data/SYTSP_redo21','/oradata/SYTSP/data/SYTSP_redo22') SIZE 5M,
GROUP 3 ('/oradata/SYTSP/data/SYTSP_redo31','/oradata/SYTSP/data/SYTSP_redo32') SIZE 5M
MAXINSTANCES 4
MAXLOGHISTORY 1
MAXLOGFILES 12
MAXLOGMEMBERS 3
MAXDATAFILES 1024
NOARCHIVELOG
CHARACTER SET ZHS16GBK
NATIONAL CHARACTER SET AL16UTF16
DATAFILE '/oradata/SYTSP/data/SYTSP_system01' SIZE 200M REUSE
AUTOEXTEND ON NEXT 50M MAXSIZE 2000M
UNDO TABLESPACE UNDOTBS
DATAFILE '/oradata/SYTSP/data/SYTSP_undo01' SIZE 10M REUSE
AUTOEXTEND ON NEXT 10M MAXSIZE 2000M EXTENT MANAGEMENT LOCAL
DEFAULT TEMPORARY TABLESPACE TEMPTBS
TEMPFILE '/oradata/SYTSP/data/SYTSP_temp01' SIZE 10M REUSE
AUTOEXTEND ON NEXT 5M MAXSIZE 2000M
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 512K;
SET ECHO OFF
@/oraapp/oracle/92/rdbms/admin/catalog.sql;
@/oraapp/oracle/92/rdbms/admin/catproc.sql;
CONNECT SYS/sys AS SYSDBA
ALTER USER SYS IDENTIFIED BY sys;
ALTER USER SYSTEM IDENTIFIED BY sys;
connect SYSTEM/sys
@/oraapp/oracle/92/sqlplus/admin/pupbld.sql;
connect SYSTEM/sys
@/oraapp/oracle/92/sqlplus/admin/help/hlpbld.sql helpus.sql;
CONNECT SYS/sys AS SYSDBA
SET ECHO ON
SHUTDOWN IMMEDIATE
CONNECT SYS/sys AS SYSDBA
STARTUP MOUNT PFILE='/oraapp/oracle/92/dbs/initSYTSP.ora'
ALTER DATABASE ARCHIVELOG;
ALTER DATABASE OPEN;
CREATE SPFILE FROM PFILE='/oraapp/oracle/92/dbs/initSYTSP.ora';
SHUTDOWN IMMEDIATE;
CONNECT SYS/sys AS SYSDBA
STARTUP
CREATE TABLESPACE sysaux
DATAFILE '/oradata/SYTSP/data/SYTSP_sysaux01' SIZE 10M
AUTOEXTEND ON NEXT 5M MAXSIZE 2000M
LOGGING ONLINE PERMANENT EXTENT MANAGEMENT LOCAL
SEGMENT SPACE MANAGEMENT AUTO UNIFORM SIZE 128K;
DROP TABLE outln.ol$ ;
CREATE TABLE outln.ol$(
ol_name VARCHAR2(30),sql_text LONG,textlen NUMBER,
signature RAW(16),hash_value NUMBER,hash_value2 NUMBER,
category VARCHAR2(30),version VARCHAR2(64),creator VARCHAR2(30),
timestamp DATE,flags NUMBER,hintcount NUMBER,spare1 NUMBER,
spare2 VARCHAR2(1000))TABLESPACE sysaux INITRANS 4;
ALTER TABLE outln.ol$hints MOVE TABLESPACE sysaux INITRANS 4;
ALTER TABLE outln.ol$nodes MOVE TABLESPACE sysaux INITRANS 4;
ALTER USER outln DEFAULT TABLESPACE sysaux;
ALTER USER outln IDENTIFIED BY LOCKEDBYDBA ACCOUNT LOCK;
ALTER USER dbsnmp DEFAULT TABLESPACE sysaux;
ALTER USER dbsnmp IDENTIFIED BY LOCKEDBYDBA ACCOUNT LOCK;
CREATE USER PKIBM IDENTIFIED BY PKIBM ACCOUNT UNLOCK;
GRANT CREATE SESSION TO PKIBM;
ALTER USER PKIBM DEFAULT TABLESPACE sysaux;
ALTER USER PKIBM ACCOUNT UNLOCK;
REVOKE UNLIMITED TABLESPACE FROM PKIBM;
ALTER USER PKIBM QUOTA UNLIMITED ON sysaux;
SPOOL OFF
DISCONNECT
EXIT
SYTSPinit.ora
DB_BLOCK_SIZE=8192
LOG_BUFFER=3145728
SORT_AREA_SIZE=524288
SGA_MAX_SIZE=268435456
DB_CACHE_SIZE=167772160
JAVA_POOL_SIZE=0
LARGE_POOL_SIZE=25165824
SHARED_POOL_SIZE=50331648
PGA_AGGREGATE_TARGET=67108864
LOG_ARCHIVE_DEST_1=('LOCATION=/oradata/SYTSP/arch') MANDATORY REOPEN
LOG_ARCHIVE_FORMAT='%t_%s.arc'
LOG_ARCHIVE_START=TRUE
# DISPATCHERS='(PROTOCOL=TCP)(DISPATCHERS=1)'
# SHARED_SERVERS=1
# MAX_DISPATCHERS=5
# MAX_SHARED_SERVERS=8
UTL_FILE_DIR='/oradata/SYTSP/logmnr'
BACKGROUND_DUMP_DEST='/oradata/SYTSP/bdump'
CORE_DUMP_DEST='/oradata/SYTSP/cdump'
USER_DUMP_DEST='/oradata/SYTSP/udump'
CONTROL_FILES=('/oradata/SYTSP/data/SYTSP_ctrl01','/oradata/SYTSP/data/SYTSP_ctrl02','/oradata/SYTSP/data/SYTSP_ctrl03')
DB_DOMAIN='PKIBM.COM'
DB_NAME='SYTSP'
INSTANCE_NAME='SYTSP'
UNDO_MANAGEMENT=AUTO
UNDO_RETENTION=7200
UNDO_TABLESPACE='UNDOTBS'
DB_FILE_MULTIBLOCK_READ_COUNT=16
OPEN_CURSORS=100
OPTIMIZER_MODE=CHOOSE
CURSOR_SHARING=SIMILAR
TIMED_STATISTICS=TRUE
COMPATIBLE=9.2.0.0.0
HASH_JOIN_ENABLED=TRUE
STAR_TRANSFORMATION_ENABLED=FALSE
QUERY_REWRITE_ENABLED=TRUE
QUERY_REWRITE_INTEGRITY=TRUSTED
PROCESSES=200
FAST_START_MTTR_TARGET=300
REMOTE_LOGIN_PASSWORDFILE=EXCLUSIVE
DML_LOCKS=2048
O7_DICTIONARY_ACCESSIBILITY=FALSE
WORKAREA_SIZE_POLICY=AUTO
JOB_QUEUE_PROCESSES=2
REPLICATION_DEPENDENCY_TRACKING=TRUE
OPEN_LINKS=2
GLOBAL_NAMES=FALSE
AQ_TM_PROCESSES=1
SYTSPlistener.ora
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1688))
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = SYTSP.PKIBM.COM)
(ORACLE_HOME = /oraapp/oracle/92)
(SID_NAME = SYTSP)
)
)
SYTSPtnsnames.ora
SYTSP =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1688))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SID = SYTSP)
)
)
SYTSPcreate.sh
#!/bin/sh
mkdir -p /oradata/PROD/bdump
mkdir -p /oradata/PROD/cdump
mkdir -p /oradata/SYTSP/udump
mkdir -p /oradata/SYTSP/data
mkdir -p /oradata/SYTSP/arch
mkdir -p /oradata/SYTSP/bkup
mkdir -p /oradata/SYTSP/logmnr
export ORACLE_SID=SYTSP
cp ./SYTSPinit.ora /oraapp/oracle/92/dbs/initSYTSP.ora
/oraapp/oracle/92/bin/orapwd file=/oraapp/oracle/92/dbs/orapwSYTSP password=sys entries=5
/oraapp/oracle/92/bin/sqlplus /nolog @./SYTSPcreate.sql
cp ./SYTSPlistener.ora /oraapp/oracle/92/network/admin/listener.ora
cp ./SYTSPtnsnames.ora /oraapp/oracle/92/network/admin/tnsnames.ora
/oraapp/oracle/92/bin/lsnrctl stop
/oraapp/oracle/92/bin/lsnrctl start
阅读(885) | 评论(0) | 转发(0) |