suse 命令行oracle安装,SUSE LINUX配置ORACLE命令

1,创建system文件，添加文件

# vi  /etc/system

set shmsys:shminfo_shmmax=4294967295

set shmsys:shminfo_shmmin=1

set shmsys:shminfo_shmmni=100

set shmsys:shminfo_shmseg=10

set semsys:seminfo_semmni=100

set semsys:seminfo_semmsl=100

set semsys:seminfo_semmns=2500

set semsys:seminfo_semopm=100

set semsys:seminfo_semvmx=32767

set noexec_user_stack=1

重启

root进入：

1，# groupadd dba

# useradd -g dba –d /export/home/oracle –m oracle

# passwd oracle

2，建立文件夹Oracle

3，# chown -R oracle:dba  /oracle

# chown -R oracle:dba  /software

# chmod -R 755  /oracle

4，su oracle

mkdir  /oracle/u01

mkdir  /oracle/u02

mkdir  /oracle/u03

mkdir  /oracle/u04

5  su root

# vi  /etc/profile

ORACLE_BASE=/oracle/u01/app/oracle

ORACLE_HOME=$ORACLE_BASE/product/10g

ORACLE_SID=uep

NLS_LANG=AMERICAN_AMERICA.ZHS16GBK    PATH=$PATH:$ORACLE_HOME/bin:/bin:/sbin:/usr/bin:/usr/ccs/bin:/usr/xpg4/bin:/usr/local/bin

LD_LIBRARY_PATH=$ORACLE_HOME/lib:$ORACLE_HOME/network/lib:/usr/local/lib:/usr/lib

TMPDIR=/var/tmp

export ORACLE_BASE ORACLE_HOME ORACLE_SID NLS_LANG PATH LD_LIBRARY_PATH  DISPLAY TMPDIR

umask 022

6  生效：cd /etc

./profile

7 ＃ vi  /etc/sysctl.conf

kernel.shmall = 2097152

kernel.shmmax = 2147483648

kernel.shmmni = 4096

# semaphores: semmsl, semmns, semopm, semmni

kernel.sem = 250 32000 100 128

fs.file-max = 65536

net.ipv4.ip_local_port_range = 1024 65000

net.core.rmem_default=262144

net.core.rmem_max=262144

net.core.wmem_default=262144

net.core.wmem_max=262144

8  生效：＃/sbin/sysctl –p

9  vi  /etc/security/limits.conf

*               soft    nproc   2047

*               hard    nproc   16384

*               soft    nofile  1024

*               hard    nofile  65536

10  vi /etc/pam.d/login

session    required     /lib/security/pam_limits.so

重启

Oracle用户登陆

oracle@linux:~>cd /software

oracle@linux:/software>cpio -idmv < 10201_database_linux_x86_64.cpio

oracle@linux:/software>export  LANG=en_US

oracle@linux:/software>cd database/

oracle@linux:/software/database>./runInstaller

安装过程中的问题解决：

(1)ORA-27125:unable to create shard memory segment

问题解决：

oracle@linux:~>cd $ORACLE_HOME/bin

oracle@linux:/oracle/u01/app/oracle/product/10g/bin>mv oracle oracle.bin

oracle@linux:/oracle/u01/app/oracle/product/10g/bin>cat >oracle <

> #!/bin/bash

> export DISABLE_HUGETLBFS=1

> exec $ORACLE_HOME/bin/oracle.bin $@

> EOF

oracle@linux:/oracle/u01/app/oracle/product/10g/bin># chmod +x oracle

oracle@linux:/oracle/u01/app/oracle/product/10g/bin>

(2)Bash:/oracle/u01/app/oracle/oralnventory/orainstRoot.sh:没有那个文件或目录的错误

解决方法：

su root

linux:~ # cd /oracle/u01/app/oracle

linux:/oracle/u01/app/oracle # ls

.  ..  admin  oraInventory  oradata  product

linux:/oracle/u01/app/oracle #  cd oraInventory/

linux:/oracle/u01/app/oracle/oraInventory # chown  -R  root:root  orainstRoot.sh

linux:/oracle/u01/app/oracle/oraInventory # chmod 777 orainstRoot.sh

跑脚本

oracle@linux:~> su root

Password:  (密码root)

linux:/export/home/oracle #

linux:/export/home/oracle # /oracle/u01/app/oracle/oraInventory/orainstRoot.sh

Changing permissions of /oracle/u01/app/oracle/oraInventory to 770.

Changing groupname of /oracle/u01/app/oracle/oraInventory to dba.

The execution of the script is complete

linux:/export/home/oracle # cd /oracle/u01/app/oracle

linux:/oracle/u01/app/oracle # cd product/

linux:/oracle/u01/app/oracle/product # ls -l

total 12

drwxrwx---   3 oracle dba 4096 2009-06-23 21:09 .

drwxrwx---   6 oracle dba 4096 2009-06-23 21:40 ..

drwxr-x---  60 oracle dba 4096 2009-06-23 21:42 10g

linux:/oracle/u01/app/oracle/product # cd 10g/

linux:/oracle/u01/app/oracle/product/10g # ./root.sh

Running Oracle10 root.sh script...

The following environment variables are set as:

ORACLE_OWNER= oracle

ORACLE_HOME=  /oracle/u01/app/oracle/product/10g

Enter the full pathname of the local bin directory: [/usr/local/bin]:

Copying dbhome to /usr/local/bin ...

Copying oraenv to /usr/local/bin ...

Copying coraenv to /usr/local/bin ...

Entries will be added to the /etc/oratab file as needed by

Database Configuration Assistant when a database is created

Finished running generic part of root.sh script.

Now product-specific root actions will be performed.

linux:/oracle/u01/app/oracle/product/10g #

启动Oracle数据库

linux:~ # su - oracle

oracle@linux:~> sqlplus /nolog

SQL*Plus: Release 10.2.0.1.0 - Production on Tue Jun 23 22:43:42 2009

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

SQL> conn / as sysdba

Connected.

SQL> startup(挂载数据库)

ORA-01081: cannot start already-running ORACLE - shut it down first

SQL> exit

Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production

With the Partitioning, OLAP and Data Mining options

oracle@linux:~> lsnrctl

LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 23-JUN-2009 22:44:21

Copyright (c) 1991, 2005, Oracle.  All rights reserved.

Welcome to LSNRCTL, type "help" for information.

LSNRCTL> start(启动监听器)

TNS-01106: Listener using listener name LISTENER has already been started

LSNRCTL> exit

oracle@linux:~> sqlplus

SQL*Plus: Release 10.2.0.1.0 - Production on Tue Jun 23 22:45:08 2009

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

Enter user-name: system

Enter password:  (密码oracle)

Connected to:

Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production

With the Partitioning, OLAP and Data Mining options

SQL> exit

Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production

With the Partitioning, OLAP and Data Mining options

oracle@linux:~> sqlplus

SUSE上删除Oracle的方法：

第一步：

oracle@linux:~> cd /software

oracle@linux:/software> cd database/

oracle@linux:/software/database> ./runInstaller

出现界面，选择已安装产品，删除

第二步删除/Oracle 下的app文件夹

SSH打开：

linux:~ # vi /etc/ssh/sshd_config

把：permitRootlogin   yes  的注释去掉

passwordAuthentication no  中的no改为yes

linux:~ # cd /etc

linux:/etc # chmod 777 profile

linux:/etc # rcSuSEfirewall2 off

Usage: /sbin/rcSuSEfirewall2 {start|stop|status|restart|reload|force-reload}

linux:/etc # /etc/init.d/sshd start

Starting SSH daemon                                                  done

linux:/etc #

重启

X manager打开

第一步：YAST   Network Service    Remote Administration下选择Allow Remote Administration

第二步： 打开SHELL, 执行 rcxdm restar

linux:~ # su - oracle

oracle@linux:~> sqlplus /nolog

SQL*Plus: Release 10.2.0.1.0 - Production on Wed Jun 24 23:21:54 2009

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

SQL> conn / as sysdba

Connected to an idle instance.

SQL> startup

ORACLE instance started.

Total System Global Area 2147483648 bytes

Fixed Size                  2022144 bytes

Variable Size             486540544 bytes

Database Buffers         1644167168 bytes

Redo Buffers               14753792 bytes

Database mounted.

Database opened.