安装数据库及数据库问题解决方法

1、安装数据库：
打开ftp服务：  vi /etc/ftpuser
2、建立oracle用户
useradd oracle -g oinstall -G dba -d /opt/oracle
3、检查包有没有安装全

SUSE Linux Enterprise Server 10 The following packages (or later versions) must be installed:
binutils-2.16.91.0.5   binutils-2.16.91.0.5-23.34.33 
compat-libstdc++-5.0.7   ----rpm -ivh compat-openssl097g-0.9.7g-13.16.i586.rpm
gcc-4.1.2   gcc-4.1.2_20070115-0.29.6
gcc-c++-4.1.2  gcc-c++-4.1.2_20070115-0.29.6
glibc-2.4-31.63  glibc-2.4-31.74.1
glibc-devel-2.4-31.63  glibc-devel-2.4-31.74.1
ksh-93r-12.9    ksh-93s-59.11.35
libaio-0.3.104  libaio-0.3.104-14.2
libaio-devel-0.3.104  libaio-devel-0.3.104-14.2
libelf-0.8.5   libelf-0.8.5-47.2
libgcc-4.1.2   libgcc-4.1.2_20070115-0.29.6
libstdc++-4.1.2  libstdc++-4.1.2_20070115-0.29.6
libstdc++-devel-4.1.2 libstdc++-devel-4.1.2_20070115-0.29.6
make-3.80   make-3.80-202.2
sysstat-8.0.4  rpm -ivh sysstat-8.0.4-1.7.27.i586.rpm

4、修改内核参数
vi /etc/sysctl.conf
fs.aio-max-nr = 1048576
fs.file-max = 6815744
kernel.shmall = 2097152
kernel.shmmax = 4294967295
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
net.ipv4.ip_local_port_range = 9000 65500
net.core.rmem_default = 262144
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 1048576

/sbin/chkconfig boot.sysctl on  保证重启也是这个内核参数
/sbin/sysctl -p   改变当前内核参数

echo 103 > /proc/sys/vm/hugetlb_shm_group
vi /etc/sysctl.conf
vm.hugetlb_shm_group = 103
5、创建oracle基本目录
6、创建oracle环境变量DISPLAY
    vi .bash_profile
    export DISPLAY=:0.0
    export ORACLE_BASE=/opt/oracle/product  oracle用户在base的平级目录需要有权限
    export ORACLE_HOME=/opt/oracle/product/11.1
    export ORACLE_SID=orcl