install_oracle10g_linux_record

以root用户登录

 

Checking the following packages

-----------------------------

binutils-2.15.92.0.2-13.EL4

compat-db-4.1.25-9

compat-libstdc++-296-2.96-132.7.2

control-center-2.8.0-12

gcc-3.4.3-22.1.EL4

gcc-c++-3.4.3-22.1.EL44

glibc-2.3.4-2.9

glibc-common-2.3.4-2.9

gnome-libs-1.4.1.2.90-44.1

libstdc++-3.4.3-22.1

libstdc++-devel-3.4.3-22.1

make-3.80-5

pdksh-5.2.14-30

sysstat-5.0.5-1

xscreensaver-4.18-5.rhel4.2

setarch-1.6-1

libaio-0.3.105-2.i386

 

rpm -qa | grep openmotif ... 检查是否都在

或者用这个命检查

rpm -q package_name

==============================================

openmotif21-2.1.30-8

sysstat-5.0.5-1

libaio-0.3.105-2.i386.rpm

==================================

Configuring Name Resolution

参考oracle安装文档

==================================

Setting the ORACLE_HOSTNAME Environment Variable

-----------------------------

Use the following procedure to set the ORACLE_HOSTNAME environment variable.

For example, if the fully qualified host name is somehost.us.acme.com, then enter

one of the following commands:

Bourne, Bash, or Korn shell:

    $ ORACLE_HOSTNAME=somehost.us.acme.com

    $ export ORACLE_HOSTNAME

C shell:

    % setenv ORACLE_HOSTNAME somehost.us.acme.com

==================================

Creating an OSOPER Group

-----------------------

[root@localhost ~]# groupadd oinstall

[root@localhost ~]# groupadd dba

[root@localhost ~]# cd /

[root@localhost /]# mkdir -p /u01/oracle

[root@localhost /]# useradd -g oinstall -G dba -d /u01/oracle oracle

useradd: user oracle exists

[root@localhost /]# userdel -f oracle

[root@localhost /]#useradd -g oinstall -G dba -d /u01/oracle oracle

[root@localhost ~]# passwd oracle

Changing password for user oracle.

New UNIX password:

BAD PASSWORD: it is based on a dictionary word

Retype new UNIX password:

passwd: all authentication tokens updated successfully.

[root@localhost ~]# cd /

[root@localhost /]# ls -l

total 168 ............

drwxr-xr-x 3 oracle oinstall 4096 Apr 20 17:03 u01

 

[root@localhost /]# chown -R oracle:oinstall u01

[root@localhost /]# ls -l

total 168

............

drwxr-xr-x 3 oracle oinstall 4096 Apr 20 17:03 u01

 

[root@localhost /]# id nobody

uid=99(nobody) gid=99(nobody) groups=99(nobody)

[root@localhost /]# vi /etc/sysctl.conf

 

# sysctl.conf(5) for more details.

 

# Controls IP packet forwarding

net.ipv4.ip_forward = 0

 

# Controls source route verification

net.ipv4.conf.default.rp_filter = 1

 

# Do not accept source routing

net.ipv4.conf.default.accept_source_route = 0

 

# Controls the System Request debugging functionality of the kernel

kernel.sysrq = 0

 

# Controls whether core dumps will append the PID to the core filename.

# Useful for debugging multi-threaded applications.

kernel.core_uses_pid = 1

 

 

kernel.shmall = 2097152

kernel.shmmax = 2147483648

kernel.shmmni = 4096

kernel.sem = 250 32000 100 128

fs.file-max = 65536

net.ipv4.ip_local_port_range = 1024 65000

rmem_default = 262144

rmem_max = 262144

wmem_default = 262144

wmem_max = 262144

"/etc/sysctl.conf" 32L, 851C 32,1 Bot

 

[root@localhost /]# df -k

Filesystem 1K-blocks Used Available Use% Mounted on

/dev/sda1 15472768 2756084 11930708 19% /

none 257184 0 257184 0% /dev/shm

[root@localhost /]# su - oracle

[oracle@localhost ~]$ ls

[oracle@localhost ~]$ ls -la

total 72

drwxr-xr-x 2 oracle oinstall 4096 Apr 20 18:30 .

drwxr-xr-x 3 oracle oinstall 4096 Apr 20 17:03 ..

-rw------- 1 oracle oinstall 207 Apr 20 18:31 .bash_history

-rw-r--r-- 1 oracle oinstall 24 Apr 20 18:37 .bash_logout

-rw-r--r-- 1 oracle oinstall 191 Apr 20 18:37 .bash_profile

-rw-r--r-- 1 oracle oinstall 124 Apr 20 18:37 .bashrc

-rw-r--r-- 1 oracle oinstall 383 Apr 20 18:37 .emacs

-rw-r--r-- 1 oracle oinstall 120 Apr 20 18:37 .gtkrc

-rw------- 1 oracle oinstall 905 Apr 20 18:25 .viminfo

[oracle@localhost ~]$ vi .bash_profile

 

# .bash_profile

 

# Get the aliases and functions

if [ -f ~/.bashrc ]; then

. ~/.bashrc

fi

 

# User specific environment and startup programs

 

PATH=$PATH:$HOME/bin

 

export PATH

unset USERNAME

 

ORACLE_BASE=/u01

ORACLE_HOME=$ORACLE_BASE/oracle

ORACLE_SID=luowei

PATH=$ORACLE_HOME/bin:$PATH

 

export ORACLE_BASE ORACLE_HOME ORACLE_SID PATH

~

~

~

".bash_profile" 20L, 335C written

 

 

 

[oracle@localhost ~]$ exit

logout

 

[root@localhost /]# su - oracle

[oracle@localhost ~]$ env | grep ORA

ORACLE_SID=luowei

ORACLE_BASE=/u01

ORACLE_HOME=/u01/oracle

 

[oracle@localhost ~]$ su - root

Password:

[root@localhost ~]# ls

anaconda-ks.cfg install.log.syslog

database openmotif21-2.1.30-11.RHEL4.6.i386.rpm

Desktop sysstat-5.0.5-25.el4.i386.rpm

install.log

[root@localhost ~]# mv database/ /u01

[root@localhost ~]# pwd

/root

[root@localhost ~]# cd ..

[root@localhost /]# pwd

/

[root@localhost /]# cd u01

[root@localhost u01]# pwd

/u01

[root@localhost u01]# ls -l

total 16

drwxr-xr-x 6 root root 4096 Jul 3 2005 database

drwxr-xr-x 2 oracle oinstall 4096 Apr 20 19:10 oracle

 

[root@localhost u01]# chown -R oracle:oinstall database/

[root@localhost u01]# cd database/

[root@localhost database]# ls -l

total 52

drwxr-xr-x 9 oracle oinstall 4096 Jul 3 2005 doc

drwxr-xr-x 5 oracle oinstall 4096 Jul 3 2005 install

drwxr-xr-x 2 oracle oinstall 4096 Jul 3 2005 response

-rwxr-xr-x 1 oracle oinstall 1327 Jul 3 2005 runInstaller

drwxr-xr-x 9 oracle oinstall 4096 Jul 3 2005 stage

-rwxr-xr-x 1 oracle oinstall 5213 Jul 3 2005 welcome.html

[root@localhost database]# reboot

Broadcast message from root (pts/2) (Wed Apr 20 19:42:44 2011):

 

The system is going down for reboot NOW!

 

Last login: Wed Apr 20 19:37:05 2011 from 192.168.0.1

 

[root@localhost ~]# ifconfig

eth0 Link encap:Ethernet HWaddr 00:0C:29:5D:18:EE

inet addr:192.168.0.99 Bcast:192.168.0.255 Mask:255.255.255.0

inet6 addr: fe80::20c:29ff:fe5d:18ee/64 Scope:Link

UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1

RX packets:37 errors:0 dropped:0 overruns:0 frame:0

TX packets:40 errors:0 dropped:0 overruns:0 carrier:0

collisions:0 txqueuelen:1000

RX bytes:4329 (4.2 KiB) TX bytes:5003 (4.8 KiB)

Interrupt:193 Base address:0x2000

 

lo Link encap:Local Loopback

inet addr:127.0.0.1 Mask:255.0.0.0

inet6 addr: ::1/128 Scope:Host

UP LOOPBACK RUNNING MTU:16436 Metric:1

RX packets:201 errors:0 dropped:0 overruns:0 frame:0

TX packets:201 errors:0 dropped:0 overruns:0 carrier:0

collisions:0 txqueuelen:0

RX bytes:15920 (15.5 KiB) TX bytes:15920 (15.5 KiB)

 

[root@localhost ~]# vi /etc/hosts

 

 

# Do not remove the following line, or various programs

# that require network functionality will fail.

127.0.0.1 localhost.localdomain localhost

192.168.0.99 oracle10g

~

~

~

~

~

"/etc/hosts" 4L, 171C written

 

 

[root@oracle10g ~]# /u01/oraInventory/orainstRoot.sh

Changing permissions of /u01/oraInventory to 770.

Changing groupname of /u01/oraInventory to oinstall.

The execution of the script is complete

[root@oracle10g ~]# /u01/oracle/root.sh

Running Oracle10 root.sh script...

 

The following environment variables are set as:

ORACLE_OWNER= oracle

ORACLE_HOME= /u01/oracle

 

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 ...

 

 

Creating /etc/oratab file...

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.

[root@oracle10g ~]#

[root@oracle10g ~]# 安装过程提示错误，修改内核参数

[root@oracle10g ~]# [root@localhost ~]# vi /etc/sysctl.conf

 

# sysctl.conf(5) for more details.

 

# Controls IP packet forwarding

net.ipv4.ip_forward = 0

 

# Controls source route verification

net.ipv4.conf.default.rp_filter = 1

 

# Do not accept source routing

net.ipv4.conf.default.accept_source_route = 0

 

# Controls the System Request debugging functionality of the kernel

kernel.sysrq = 0

 

# Controls whether core dumps will append the PID to the core filename.

# Useful for debugging multi-threaded applications.

kernel.core_uses_pid = 1

 

 

kernel.shmall = 2097152

kernel.shmmax = 2147483648

kernel.shmmni = 4096

kernel.sem = 250 32000 100 128

fs.file-max = 65536

net.ipv4.ip_local_port_range = 1024 65000

rmem_default = 110592

rmem_max = 131071

wmem_default = 110592

wmem_max = 131071

"/etc/sysctl.conf" 32L, 851C written

[root@localhost ~]# /sbin/chkconfig boot.sysctl on

error reading information on service boot.sysctl: No such file or directory

[root@localhost ~]# reboot

 

Broadcast message from root (pts/1) (Wed Apr 20 20:07:05 2011):

 

The system is going down for reboot NOW!

[root@localhost ~]#

Last login: Wed Apr 20 19:49:51 2011 from 192.168.0.1

 

=====================================================

Configuring Kernel Parameters

vi /etc/sysctl.conf

--------------------------------

kernel.shmall = 2097152

kernel.shmmax = 2147483648

kernel.shmmni = 4096

kernel.sem = 250 32000 100 128

fs.file-max = 65536

net.ipv4.ip_local_port_range = 1024 65000

rmem_default = 110592

rmem_max = 131071

wmem_default = 110592

wmem_max = 131071

 

==================================================

Setting Shell Limits for the oracle User

-----------------------------------

/etc/security/limits.conf

-------------------------

oracle soft nproc 2047

oracle hard nproc 16384

oracle soft nofile 1024

oracle hard nofile 65536

 

-------------------------------------

/etc/profile file (or the file on SUSE systems)/etc/profile.local

--------------------------

if [ $USER = "oracle" ]; then

if [ $SHELL = "/bin/ksh" ]; then

ulimit -p 16384

ulimit -n 65536

else

ulimit -u 16384 -n 65536

fi

fi

 

===================================================

Configuring the oracle User's Environment

vi /u01/oracle/.bash_profile

---------------------------

ORACLE_BASE=/u01

ORACLE_HOME=$ORACLE_BASE/oracle

ORACLE_SID=luowei

PATH=$ORACLE_HOME/bin:$PATH

 

export ORACLE_BASE ORACLE_HOME ORACLE_SID PATH

 

===================================================

In the installing oracle remind to run the shell script

-----------------

/u01/oraInventory/orainstRoot.sh

/u01/oracle/root.sh

 

===================================================

erase sqlplus' command echo error

---------------------

vi u01/oracle/.bash_profile

----------------

stty erase ^h

 

================================================================

================================================================

using oracle in linux

-----------------------

[oracle@oracle10g luowei]$ sqlplus /nolog

 

SQL*Plus: Release 10.2.0.1.0 - Production on Wed Apr 20 20:39:42 2011

 

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

 

SQL> conn /s^Has^H^H^H^H

SP2-0306: Invalid option.

Usage: CONN[ECT] [logon] [AS {SYSDBA|SYSOPER}]

where <logon> ::= <username>[/<password>][@<connect_identifier>] | /

SQL> conn /as sysdba

Connected.

SQL> l^H

SP2-0223: No lines in SQL buffer.

SQL> quit

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

With the Partitioning, OLAP and Data Mining options

[oracle@oracle10g luowei]$ stty erase ^H

[oracle@oracle10g luowei]$ ls

control01.ctl example01.dbf redo03.log temp01.dbf

control02.ctl redo01.log sysaux01.dbf undotbs01.dbf

control03.ctl redo02.log system01.dbf users01.dbf

[oracle@oracle10g luowei]$ pwd

/u01/oradata/luowei

[oracle@oracle10g luowei]$ cd ..

[oracle@oracle10g oradata]$ cd ..

[oracle@oracle10g u01]$ ls

admin database flash_recovery_area oracle oradata oraInventory

[oracle@oracle10g u01]$ cd admin/

[oracle@oracle10g admin]$ ls

luowei

[oracle@oracle10g admin]$ cd luowei

[oracle@oracle10g luowei]$ ls

adump bdump cdump dpdump pfile udump

[oracle@oracle10g luowei]$ cd ..

[oracle@oracle10g admin]$ CD ..

-bash: CD: command not found

[oracle@oracle10g admin]$ cd ..

[oracle@oracle10g u01]$ ls

admin database flash_recovery_area oracle oradata oraInventory

[oracle@oracle10g u01]$ cd oracle

[oracle@oracle10g ~]$ ls

assistants diagnostics lib oracle10g_luowei root.sh

bin has log oracore root.sh.old

cdata hs md oraInst.loc slax

cfgtoollogs install mesg ord sqlj

clone install.platform mgw oui sqlplus

config inventory network owm srvm

crs javavm nls perl sysman

css jdbc oc4j plsql uix

ctx jdk odbc precomp wwg

dbs jlib olap racg xdk

demo jre OPatch rdbms

Desktop ldap opmn relnotes

[oracle@oracle10g ~]$ ls -la

total 680

drwxr-xr-x 67 oracle oinstall 4096 Apr 20 20:36 .

drwxr-xr-x 8 oracle oinstall 4096 Apr 20 20:29 ..

drwxr-x--- 7 oracle oinstall 4096 Apr 20 20:16 assistants

-rw------- 1 oracle oinstall 459 Apr 20 20:36 .bash_history

-rw-r--r-- 1 oracle oinstall 24 Apr 20 18:37 .bash_logout

-rw-r--r-- 1 oracle oinstall 335 Apr 20 19:10 .bash_profile

-rw-r--r-- 1 oracle oinstall 124 Apr 20 18:37 .bashrc

drwxr-xr-x 2 oracle oinstall 12288 Apr 20 20:19 bin

drwxr-x--- 3 oracle oinstall 4096 Apr 20 20:18 cdata

drwxr-x--- 7 oracle oinstall 4096 Apr 20 20:25 cfgtoollogs

drwxr-x--- 4 oracle oinstall 4096 Apr 20 20:16 clone

drwxr-x--- 2 oracle oinstall 4096 Apr 20 20:18 config

drwxr-xr-x 3 oracle oinstall 4096 Apr 20 19:25 .config

drwxr-x--- 6 oracle oinstall 4096 Apr 20 20:16 crs

drwxr-x--- 7 oracle oinstall 4096 Apr 20 20:18 css

drwxr-x--- 10 oracle oinstall 4096 Apr 20 20:18 ctx

drwxr-x--- 2 oracle oinstall 4096 Apr 20 20:33 dbs

drwxr-x--- 3 oracle oinstall 4096 Apr 20 20:16 demo

drwxr-xr-x 2 oracle oinstall 4096 Apr 20 19:25 Desktop

drwxr-x--- 3 oracle oinstall 4096 Apr 20 20:16 diagnostics

drwxr-x--- 2 oracle oinstall 4096 Apr 20 19:25 .eggcups

-rw-r--r-- 1 oracle oinstall 383 Apr 20 18:37 .emacs

drwx------ 4 oracle oinstall 4096 Apr 20 20:12 .gconf

drwx------ 2 oracle oinstall 4096 Apr 20 20:36 .gconfd

drwx------ 3 oracle oinstall 4096 Apr 20 19:25 .gnome

drwx------ 7 oracle oinstall 4096 Apr 20 20:36 .gnome2

drwx------ 2 oracle oinstall 4096 Apr 20 19:25 .gnome2_private

drwxr-xr-x 2 oracle oinstall 4096 Apr 20 19:25 .gstreamer-0.8

-rw-r--r-- 1 oracle oinstall 120 Apr 20 18:37 .gtkrc

-rw-r--r-- 1 oracle oinstall 136 Apr 20 19:25 .gtkrc-1.2-gnome2

drwxr-x--- 3 oracle oinstall 4096 Apr 20 20:16 has

drwxr-x--- 6 oracle oinstall 4096 Apr 20 20:19 hs

-rw------- 1 oracle oinstall 380 Apr 20 20:36 .ICEauthority

drwxr-x--- 5 oracle oinstall 4096 Apr 20 20:35 install

-rw-r----- 1 oracle oinstall 37 Apr 20 20:16 install.platform

drwxr-x--- 12 oracle oinstall 4096 Apr 20 20:19 inventory

drwxr-x--- 7 oracle oinstall 4096 Apr 20 20:16 javavm

drwxr-x--- 4 oracle oinstall 4096 Apr 20 20:17 jdbc

drwxr-x--- 7 oracle oinstall 4096 Apr 20 20:18 jdk

drwxr-x--- 2 oracle oinstall 4096 Apr 20 20:18 jlib

drwxr-x--- 3 oracle oinstall 4096 Apr 20 20:16 jre

drwxr-x--- 13 oracle oinstall 4096 Apr 20 20:18 ldap

drwxr-x--- 3 oracle oinstall 12288 Apr 20 20:19 lib

drwxr-xr-t 3 oracle oinstall 4096 Apr 20 20:23 log

drwxr-x--- 6 oracle oinstall 4096 Apr 20 20:16 md

drwxr-x--- 2 oracle oinstall 4096 Apr 20 20:16 mesg

drwx------ 3 oracle oinstall 4096 Apr 20 19:25 .metacity

drwxr-x--- 7 oracle oinstall 4096 Apr 20 20:18 mgw

drwxr-xr-x 3 oracle oinstall 4096 Apr 20 19:25 .nautilus

drwxr-x--- 11 oracle oinstall 4096 Apr 20 20:19 network

drwxr-x--- 6 oracle oinstall 4096 Apr 20 20:16 nls

drwxr-x--- 15 oracle oinstall 4096 Apr 20 20:19 oc4j

drwxr-x--- 6 oracle oinstall 4096 Apr 20 20:16 odbc

drwxr-x--- 5 oracle oinstall 4096 Apr 20 20:16 olap

drwxr-x--- 4 oracle oinstall 4096 Apr 20 20:18 OPatch

drwxr-x--- 7 oracle oinstall 4096 Apr 20 20:18 opmn

drwxr----- 3 oracle oinstall 4096 Apr 20 20:33 oracle10g_luowei

drwxr-x--- 4 oracle oinstall 4096 Apr 20 20:16 oracore

-rw-r--r-- 1 oracle oinstall 52 Apr 20 20:13 oraInst.loc

drwxr-x--- 8 oracle oinstall 4096 Apr 20 20:16 ord

drwxr-x--- 7 oracle oinstall 4096 Apr 20 20:18 oui

drwxr-x--- 4 oracle oinstall 4096 Apr 20 20:16 owm

drwxr-x--- 6 oracle oinstall 4096 Apr 20 20:16 perl

drwxr-x--- 7 oracle oinstall 4096 Apr 20 20:16 plsql

drwxr-x--- 7 oracle oinstall 4096 Apr 20 20:16 precomp

drwxr-x--- 7 oracle oinstall 4096 Apr 20 20:18 racg

drwxr-x--- 13 oracle oinstall 4096 Apr 20 20:19 rdbms

-rw------- 1 oracle oinstall 0 Apr 20 19:25 .recently-used

drwxr-x--- 4 oracle oinstall 4096 Apr 20 20:17 relnotes

drwx------ 2 oracle oinstall 4096 Apr 20 19:25 .rhn-applet

-rw------- 1 oracle oinstall 554 Apr 20 20:27 .rhn-applet.conf

-rwxr-xr-x 1 oracle oinstall 9474 Apr 20 20:19 root.sh

-rwxr-xr-x 1 oracle oinstall 0 Jun 7 2005 root.sh.old

drwxr-x--- 3 oracle oinstall 4096 Apr 20 20:16 slax

drwxr-x--- 3 oracle oinstall 4096 Apr 20 20:16 sqlj

drwxr-x--- 9 oracle oinstall 4096 Apr 20 20:18 sqlplus

drwxr-x--- 12 oracle oinstall 4096 Apr 20 20:18 srvm

drwxr-x--- 12 oracle oinstall 4096 Apr 20 20:18 sysman

drwxr-x--- 4 oracle oinstall 4096 Apr 20 20:16 uix

-rw------- 1 oracle oinstall 966 Apr 20 19:10 .viminfo

drwxr-x--- 3 oracle oinstall 4096 Apr 20 20:16 wwg

-rw------- 1 oracle oinstall 115 Apr 20 20:36 .Xauthority

drwxr-x--- 6 oracle oinstall 4096 Apr 20 20:17 xdk

[oracle@oracle10g ~]$ vi .bash_profile

 

# .bash_profile

 

# Get the aliases and functions

if [ -f ~/.bashrc ]; then

. ~/.bashrc

fi

 

# User specific environment and startup programs

 

PATH=$PATH:$HOME/bin

 

export PATH

unset USERNAME

 

ORACLE_BASE=/u01

ORACLE_HOME=$ORACLE_BASE/oracle

ORACLE_SID=luowei

PATH=$ORACLE_HOME/bin:$PATH

 

export ORACLE_BASE ORACLE_HOME ORACLE_SID PATH

 

stty erase ^h

~

~

~

~

~

~

".bash_profile" 22L, 350C written

[oracle@oracle10g ~]$ sqlplus /nolog

 

SQL*Plus: Release 10.2.0.1.0 - Production on Wed Apr 20 20:47:56 2011

 

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

 

SQL> conn /as sysdba

Connected.

SQL> create table testtb1(id integer,name char(10));

 

Table created.

 

SQL> insert into testtb1 values(0,'wilson');

 

1 row created.

 

SQL> insert into testtb1 values(1,'luowei');

 

1 row created.

 

SQL> commit;

 

Commit complete.

 

SQL> select * from testtb1;

 

ID NAME

---------- ----------

0 wilson

1 luowei

 

SQL> exit

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

With the Partitioning, OLAP and Data Mining options

[oracle@oracle10g ~]$ exit

logout

 

[root@oracle10g ~]# su -oracle

su: invalid option -- o

Try `su --help' for more information.

[root@oracle10g ~]# su - oracle

[oracle@oracle10g ~]$ sqlplus /nolog

 

SQL*Plus: Release 10.2.0.1.0 - Production on Wed Apr 20 20:53:48 2011

 

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

 

SQL> !

[oracle@oracle10g ~]$ exit

exit

 

SQL> !ps -ef

UID PID PPID C STIME TTY TIME CMD

root 1 0 0 20:07 ? 00:00:01 init [3]

root 2 1 0 20:07 ? 00:00:00 [migration/0]

root 3 1 0 20:07 ? 00:00:00 [ksoftirqd/0]

root 4 1 0 20:07 ? 00:00:00 [migration/1]

root 5 1 0 20:07 ? 00:00:00 [ksoftirqd/1]

root 6 1 0 20:07 ? 00:00:00 [events/0]

root 7 1 0 20:07 ? 00:00:00 [events/1]

root 8 1 0 20:07 ? 00:00:00 [khelper]

root 9 1 0 20:07 ? 00:00:00 [kthread]

root 10 9 0 20:07 ? 00:00:00 [kacpid]

root 91 9 0 20:07 ? 00:00:00 [kblockd/0]

root 92 9 0 20:07 ? 00:00:00 [kblockd/1]

root 93 1 0 20:07 ? 00:00:00 [khubd]

root 110 9 0 20:07 ? 00:00:01 [pdflush]

root 111 9 0 20:07 ? 00:00:04 [pdflush]

root 112 1 0 20:07 ? 00:00:03 [kswapd0]

root 113 9 0 20:07 ? 00:00:00 [aio/0]

root 114 9 0 20:07 ? 00:00:00 [aio/1]

root 260 1 0 20:07 ? 00:00:00 [kseriod]

root 503 1 0 20:07 ? 00:00:00 [scsi_eh_0]

root 519 9 0 20:07 ? 00:00:00 [ata/0]

root 520 9 0 20:07 ? 00:00:00 [ata/1]

root 521 9 0 20:07 ? 00:00:00 [ata_aux]

root 532 1 0 20:07 ? 00:00:07 [kjournald]

root 1141 9 0 20:07 ? 00:00:00 [kauditd]

root 1328 1 0 20:08 ? 00:00:00 udevd

root 5100 1 0 20:08 ? 00:00:00 syslogd -m 0

root 5104 1 0 20:08 ? 00:00:00 klogd -x

root 5118 1 0 20:08 ? 00:00:00 irqbalance

rpc 5137 1 0 20:08 ? 00:00:00 portmap

rpcuser 5147 1 0 20:08 ? 00:00:00 rpc.statd

root 5178 1 0 20:08 ? 00:00:00 rpc.idmapd

root 5260 1 0 20:08 ? 00:00:00 /usr/sbin/acpid

root 5273 1 0 20:08 ? 00:00:00 cupsd

root 5350 1 0 20:08 ? 00:00:00 /usr/sbin/sshd

root 5375 1 0 20:08 ? 00:00:00 xinetd -stayalive -pidfil

root 5394 1 0 20:10 ? 00:00:00 sendmail: accepting conne

smmsp 5404 1 0 20:11 ? 00:00:00 sendmail: Queue runner@01

root 5415 1 0 20:11 ? 00:00:00 gpm -m /dev/input/mice -t

root 5425 1 0 20:11 ? 00:00:00 crond

xfs 5445 1 0 20:11 ? 00:00:00 xfs -droppriv -daemon

root 5464 1 0 20:11 ? 00:00:00 /usr/sbin/atd

dbus 5475 1 0 20:11 ? 00:00:00 dbus-daemon-1 --system

root 5489 1 0 20:11 ? 00:00:00 cups-config-daemon

root 5500 1 0 20:11 ? 00:00:01 hald

root 5510 1 0 20:11 tty2 00:00:00 /sbin/mingetty tty2

root 5511 1 0 20:11 tty3 00:00:00 /sbin/mingetty tty3

root 5512 1 0 20:11 tty4 00:00:00 /sbin/mingetty tty4

root 5513 1 0 20:11 tty5 00:00:00 /sbin/mingetty tty5

root 5514 1 0 20:11 tty6 00:00:00 /sbin/mingetty tty6

oracle 6450 1 0 20:12 ? 00:00:00 /usr/libexec/gam_server

root 9305 5350 0 20:20 ? 00:00:00 sshd: root@pts/1

root 9307 9305 0 20:20 pts/1 00:00:00 -bash

oracle 9470 1 0 20:23 ? 00:00:00 /u01/oracle/bin/tnslsnr L

root 9603 5350 0 20:29 ? 00:00:00 sshd: root@pts/2

root 9605 9603 0 20:29 pts/2 00:00:00 -bash

oracle 9797 1 0 20:33 ? 00:00:00 ora_pmon_luowei

oracle 9799 1 0 20:33 ? 00:00:00 ora_psp0_luowei

oracle 9801 1 0 20:33 ? 00:00:00 ora_mman_luowei

oracle 9803 1 0 20:33 ? 00:00:00 ora_dbw0_luowei

oracle 9805 1 0 20:33 ? 00:00:01 ora_lgwr_luowei

oracle 9807 1 0 20:33 ? 00:00:00 ora_ckpt_luowei

oracle 9809 1 0 20:33 ? 00:00:01 ora_smon_luowei

oracle 9811 1 0 20:33 ? 00:00:00 ora_reco_luowei

oracle 9813 1 0 20:33 ? 00:00:00 ora_cjq0_luowei

oracle 9815 1 0 20:33 ? 00:00:01 ora_mmon_luowei

oracle 9817 1 0 20:33 ? 00:00:00 ora_mmnl_luowei

oracle 9819 1 0 20:33 ? 00:00:00 ora_d000_luowei

oracle 9821 1 0 20:33 ? 00:00:00 ora_s000_luowei

oracle 9825 1 0 20:33 ? 00:00:00 ora_qmnc_luowei

oracle 9893 1 0 20:33 ? 00:00:00 ora_q000_luowei

oracle 9895 1 0 20:33 ? 00:00:00 ora_q001_luowei

oracle 10820 1 0 20:33 ? 00:00:00 /u01/oracle/perl/bin/perl

oracle 10845 10820 2 20:33 ? 00:00:32 /u01/oracle/jdk/bin/java

oracle 10943 1 0 20:33 ? 00:00:06 oracleluowei (LOCAL=NO)

oracle 10948 1 0 20:33 ? 00:00:00 oracleluowei (LOCAL=NO)

oracle 10950 1 0 20:33 ? 00:00:01 oracleluowei (LOCAL=NO)

oracle 12532 10820 0 20:35 ? 00:00:01 /u01/oracle/bin/emagent

oracle 12539 1 0 20:35 ? 00:00:04 oracleluowei (LOCAL=NO)

oracle 12575 1 0 20:35 ? 00:00:04 oracleluowei (LOCAL=NO)

oracle 12636 1 0 20:35 ? 00:00:01 oracleluowei (LOCAL=NO)

oracle 12960 1 0 20:36 ? 00:00:00 /usr/bin/esd -terminate -

root 13004 1 0 20:36 tty1 00:00:00 /sbin/mingetty tty1

root 13518 9605 0 20:53 pts/2 00:00:00 su - oracle

oracle 13519 13518 0 20:53 pts/2 00:00:00 -bash

oracle 13547 13519 0 20:53 pts/2 00:00:00 sqlplus

oracle 13589 1 16 20:55 ? 00:00:00 ora_j000_luowei

oracle 13590 13547 0 20:55 pts/2 00:00:00 ps -ef

 

SQL> !ps -ef | grep oracle

oracle 6450 1 0 20:12 ? 00:00:00 /usr/libexec/gam_server

oracle 9470 1 0 20:23 ? 00:00:00 /u01/oracle/bin/tnslsnr LISTENER -inherit

oracle 9797 1 0 20:33 ? 00:00:00 ora_pmon_luowei

oracle 9799 1 0 20:33 ? 00:00:00 ora_psp0_luowei

oracle 9801 1 0 20:33 ? 00:00:00 ora_mman_luowei

oracle 9803 1 0 20:33 ? 00:00:00 ora_dbw0_luowei

oracle 9805 1 0 20:33 ? 00:00:01 ora_lgwr_luowei

oracle 9807 1 0 20:33 ? 00:00:00 ora_ckpt_luowei

oracle 9809 1 0 20:33 ? 00:00:01 ora_smon_luowei

oracle 9811 1 0 20:33 ? 00:00:00 ora_reco_luowei

oracle 9813 1 0 20:33 ? 00:00:00 ora_cjq0_luowei

oracle 9815 1 0 20:33 ? 00:00:01 ora_mmon_luowei

oracle 9817 1 0 20:33 ? 00:00:00 ora_mmnl_luowei

oracle 9819 1 0 20:33 ? 00:00:00 ora_d000_luowei

oracle 9821 1 0 20:33 ? 00:00:00 ora_s000_luowei

oracle 9825 1 0 20:33 ? 00:00:00 ora_qmnc_luowei

oracle 9893 1 0 20:33 ? 00:00:00 ora_q000_luowei

oracle 9895 1 0 20:33 ? 00:00:00 ora_q001_luowei

oracle 10820 1 0 20:33 ? 00:00:00 /u01/oracle/perl/bin/perl /u01/oracle/bin/emwd.pl dbconsole /u01/oracle/oracle10g_luowei/sysman/log/emdb.nohup

oracle 10845 10820 2 20:33 ? 00:00:32 /u01/oracle/jdk/bin/java -server -Xmx256M -XX:MaxPermSize=96m -XX:MinHeapFreeRatio=20 -XX:MaxHeapFreeRatio=40 -DORACLE_HOME=/u01/oracle -Doracle.home=/u01/oracle/oc4j -Doracle.oc4j.localhome=/u01/oracle/oracle10g_luowei/sysman -DEMSTATE=/u01/oracle/oracle10g_luowei -Doracle.j2ee.dont.use.memory.archive=true -Djava.protocol.handler.pkgs=HTTPClient -Doracle.security.jazn.config=/u01/oracle/oc4j/j2ee/OC4J_DBConsole_oracle10g_luowei/config/jazn.xml -Djava.security.policy=/u01/oracle/oc4j/j2ee/OC4J_DBConsole_oracle10g_luowei/config/java2.policy -Djava.security.properties=/u01/oracle/oc4j/j2ee/home/config/jazn.security.props -DEMDROOT=/u01/oracle/oracle10g_luowei -Dsysman.md5password=true -Drepapi.oracle.home=/u01/oracle -Ddisable.checkForUpdate=true -Djava.awt.headless=true -jar /u01/oracle/oc4j/j2ee/home/oc4j.jar -config /u01/oracle/oc4j/j2ee/OC4J_DBConsole_oracle10g_luowei/config/server.xml

oracle 10943 1 0 20:33 ? 00:00:06 oracleluowei (LOCAL=NO)

oracle 10948 1 0 20:33 ? 00:00:00 oracleluowei (LOCAL=NO)

oracle 10950 1 0 20:33 ? 00:00:01 oracleluowei (LOCAL=NO)

oracle 12532 10820 0 20:35 ? 00:00:01 /u01/oracle/bin/emagent

oracle 12539 1 0 20:35 ? 00:00:04 oracleluowei (LOCAL=NO)

oracle 12575 1 0 20:35 ? 00:00:04 oracleluowei (LOCAL=NO)

oracle 12636 1 0 20:35 ? 00:00:01 oracleluowei (LOCAL=NO)

oracle 12960 1 0 20:36 ? 00:00:00 /usr/bin/esd -terminate -nobeeps -as 2 -spawnfd 28

root 13518 9605 0 20:53 pts/2 00:00:00 su - oracle

oracle 13519 13518 0 20:53 pts/2 00:00:00 -bash

oracle 13547 13519 0 20:53 pts/2 00:00:00 sqlplus

oracle 13589 1 1 20:55 ? 00:00:00 ora_j000_luowei

oracle 13652 13547 0 20:55 pts/2 00:00:00 /bin/bash -c ps -ef | grep oracle

oracle 13653 13652 0 20:55 pts/2 00:00:00 ps -ef

oracle 13654 13652 0 20:55 pts/2 00:00:00 grep oracle

 

SQL> shutdown immediate

ORA-01012: not logged on

SQL> !conn /as sysdba

/bin/bash: conn: command not found

 

SQL> !

[oracle@oracle10g ~]$ conn /as sysdba;

bash: conn: command not found

[oracle@oracle10g ~]$ exit

exit

 

SQL> conn /as sysdba;

Connected.

 

SQL> quit

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

With the Partitioning, OLAP and Data Mining options

[oracle@oracle10g ~]$ sqlplus /nolog

 

SQL*Plus: Release 10.2.0.1.0 - Production on Wed Apr 20 21:06:33 2011

 

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 167772160 bytes

Fixed Size 1218292 bytes

Variable Size 75499788 bytes

Database Buffers 83886080 bytes

Redo Buffers 7168000 bytes

Database mounted.

Database opened.

SQL> select * from testtb1;

 

ID NAME

---------- ----------

0 wilson

1 luowei

 

SQL> quit

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

With the Partitioning, OLAP and Data Mining options

[oracle@oracle10g ~]$ exit

logout

 

[root@oracle10g ~]#

[root@oracle10g ~]# shutdown now

 

Broadcast message from root (pts/1) (Wed Apr 20 21:11:51 2011):

 

The system is going down to maintenance mode NOW!

[root@oracle10g ~]#