rh4上安裝oracle 11g r1

Vm LINUX 4

安裝oracle 11g R1

檢查rpm 包

binutils-2.15.92.0.2-18

compat-libstdc++-33.2.3-47.3

elfutils-libelf-0.97-5

elfutils-libelf-devel-0.97-5

glibc-2.3.4-2.19

glibc-common-2.3.4-2.19

glibc-devel-2.3.4-2.19

glibc-headers-2.3.4-2.19

gcc-3.4.5-2

gcc-c++-3.4.5-2

libaio-devel-0.3.105-2

libaio-0.3.105-2

libgcc-3.4.5

libstdc++-3.4.5-2

libstdc++-devel-3.4.5-2

make-3.80-5

sysstat-5.0.5

檢查沒有的從LINUX安裝ZIP中獲取

[root@oracle11g ~]# rpm -qa|grep binutils-2.15.92.0.2-18

[root@oracle11g ~]# rpm -qa|grep compat-libstdc++-33.2.3-47.3

[root@oracle11g ~]# rpm -qa|grep elfutils-libelf-0.97-5

[root@oracle11g ~]# rpm -qa|grep elfutils-libelf-devel-0.97-5

[root@oracle11g ~]# rpm -qa|grep glibc-2.3.4-2.19

[root@oracle11g ~]# rpm -qa|grep glibc-devel-2.3.4-2.19

[root@oracle11g ~]# rpm -qa|grep glibc-headers-2.3.4-2.19

[root@oracle11g ~]# rpm -qa|grep gcc-3.4.5-2

[root@oracle11g ~]# rpm -qa|grep gcc-c++-3.4.5-2

[root@oracle11g ~]# rpm -qa|grep libaio-devel-0.3.105-2

[root@oracle11g ~]# rpm -qa|grep libaio-0.3.105-2

libaio-0.3.105-2

[root@oracle11g ~]# rpm -qa|grep libgcc-3.4.5

[root@oracle11g ~]# rpm -qa|grep libstdc++-3.4.5-2

[root@oracle11g ~]# rpm -qa|grep libstdc++-devel-3.4.5-2

[root@oracle11g ~]# rpm -qa|grep make-3.80-5

[root@oracle11g ~]# rpm -qa|grep sysstat-5.0.5

[root@oracle11g ~]#

將這些包防入11gpkg中FTP 傳到linux root家目錄

[root@oracle11g ~]# cd ~

[root@oracle11g ~]# ls

11gpkg install.log linux_11gR1_database_1013.zip

anaconda-ks.cfg install.log.syslog

[root@oracle11g ~]# cd 11gpkg

[root@vm11g 11gpkg]# rpm -ivh gcc*

warning: gcc-3.4.6-3.i386.rpm: V3 DSA signature: NOKEY, key ID db42a60e

Preparing... ########################################### [100%]

package gcc-3.4.6-3 is already installed

package gcc-c++-3.4.6-3 is already installed

[root@vm11g 11gpkg]# rpm -ivh make-3.80-6.EL4.i386.rpm

warning: make-3.80-6.EL4.i386.rpm: V3 DSA signature: NOKEY, key ID db42a60e

Preparing... ########################################### [100%]

package make-3.80-6.EL4 is already installed

[root@vm11g 11gpkg]# rpm -ivh sysstat-5.0.5-11.rhel4.i386.rpm

warning: sysstat-5.0.5-11.rhel4.i386.rpm: V3 DSA signature: NOKEY, key ID db42a60e

Preparing... ########################################### [100%]

1:sysstat ########################################### [100%]

[root@vm11g 11gpkg]# ls

把包都裝下，然後再檢查一次

建立目錄,使用者，user group

[root@vm11g ~]# groupadd oracle

[root@vm11g ~]# groupadd install

[root@vm11g ~]# groupdrop install

-bash: groupdrop: command not found

[root@vm11g ~]# groupadd oinstall

[root@vm11g ~]# groupdel install

[root@vm11g home]# groupdel oracle

[root@vm11g home]# groupadd dba

[root@vm11g ~]# cd /home

[root@vm11g home]# mkdir oracle

[root@vm11g home]# cd oracle

[root@vm11g oracle]# mkdir product

[root@vm11g oracle]# mkdir 11g

[root@vm11g oracle]# ls

product

[root@vm11g oracle]# cd product

[root@vm11g product]# mkdir 11g

[root@vm11g product]# cd 11g

[root@vm11g 11g]# mkdir database

[root@vm11g 11g]# ls

database

[root@vm11g 11g]# cd ..

[root@vm11g product]# ls

11g

[root@vm11g product]# cd ..

[root@vm11g oracle]# ls

product

[root@vm11g oracle]# cd .

[root@vm11g oracle]#

[root@vm11g oracle]# cd ..

[root@vm11g home]# ls

oracle

[root@vm11g home]# useradd -g oinstall -G dba -d /home/oracle ora

[root@vm11g home]# passwd oracle

Changing password for user oracle.

New UNIX password:

Retype new UNIX password:

passwd: all authentication tokens updated successfully.

[root@vm11g home]#

[root@vm11g home]# cd /home

[root@vm11g home]# ls

oracle

[root@vm11g home]# ll

total 8

drwxr-xr-x 4 root root 4096 Dec 10 09:18 oracle

[root@vm11g home]# chown -R oracle:oinstall oracle

[root@vm11g home]# ls

oracle

[root@vm11g home]# lls

-bash: lls: command not found

[root@vm11g home]# ll

total 8

drwxr-xr-x 4 oracle oinstall 4096 Dec 10 09:18 oracle

[root@vm11g home]#

設定oracle user 環境變數

[root@vm11g home]# su - oracle

[oracle@vm11g ~]$ ls -a

. .bash_logout .bashrc .gtkrc product

.. .bash_profile .emacs .kde .zshrc

[oracle@vm11g ~]$ 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

exprot ORACLE_SID=xh

export ORACLE_BASE=/home/oracle

export ORACLE_HOME=$ORACLE_BASE/product/11g/database

export ORACLE_TERM=xterm

export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib:$ORACLE_HOME/rdbms/lib

export CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib

export CLASSPATH=$CLASSPATH:$ORACLE_HOME/network/jlib

export PATH=$PATH:/home/oracle/OPatch

export CV_HOME=/home/oracle/support/cvu

alias ss="sqlplus '/ as sysdba'"

alias bdump="cd $ORACLE_BASE/admin/xh11g/bdump"

alias dblog="more $ORACLE_BASE/admin/*/bdump/alert_$ORACLE_SID.log"

alias tailog="tail -f $ORACLE_BASE/admin/*/bdump/alert_$ORACLE_SID.log &"

stty kill '^X' intr '^C'

".bash_profile" 30L, 861C written

[oracle@vm11g ~]$ env |grep ORA

ORACLE_BASE=/home/oracle

ORACLE_TERM=xterm

ORACLE_HOME=/home/oracle/product/11g/database

修改核心引數

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

# Kernel sysctl configuration file for Red Hat Linux

#

# For binary values, 0 is disabled, 1 is enabled. See sysctl(8) and

# 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

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

"/etc/sysctl.conf" 30L, 868C written

[root@vm11g ~]# sysctl -p

net.ipv4.ip_forward = 0

net.ipv4.conf.default.rp_filter = 1

net.ipv4.conf.default.accept_source_route = 0

kernel.sysrq = 0

kernel.core_uses_pid = 1

kernel.shmall = 2097152

kernel.shmmax = 2147483648

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

[root@vm11g ~]# vi /etc/pam.d/login

#%PAM-1.0

auth required pam_securetty.so

auth required pam_stack.so service=system-auth

auth required pam_nologin.so

account required pam_stack.so service=system-auth

password required pam_stack.so service=system-auth

# pam_selinux.so close should be the first session rule

session required pam_selinux.so close

session required pam_stack.so service=system-auth

session required pam_loginuid.so

session optional pam_console.so

# pam_selinux.so open should be the last session rule

session required pam_selinux.so open

session required pam_limits.so

"/etc/pam.d/login" 16L, 593C writte

[root@vm11g ~]# vi /etc/security/limits.conf

# /etc/security/limits.conf

#

#Each line describes a limit for a user in the form.:

#

#Where:

# can be:

# - an user name

# - a group name, with @group syntax

# - the wildcard *, for default entry

# - the wildcard %, can be also used with %group syntax,

# for maxlogin limit

#

# can have the two values:

# - "soft" for enforcing the soft limits

# - "hard" for enforcing hard limits

#

# can be one of the following:

# - core - limits the core file size (KB)

# - data - max data size (KB)

# - fsize - maximum filesize (KB)

# - memlock - max locked-in-memory address space (KB)

# - nofile - max number of open files

# - rss - max resident set size (KB)

# - stack - max stack size (KB)

# - cpu - max CPU time (MIN)

# - nproc - max number of processes

# - as - address space limit

# - maxlogins - max number of logins for this user

# - maxsyslogins - max number of logins on the system

# - priority - the priority to run user process with

# - locks - max number of file locks the user can hold

# - sigpending - max number of pending signals

# - msgqueue - max memory used by POSIX message queues (bytes)

#

#* soft core 0

#* hard rss 10000

#@student hard nproc 20

#@faculty soft nproc 20

#@faculty hard nproc 50

#ftp hard nproc 0

#@student - maxlogins 4

oracle soft nproc 2047

oracle hard nproc 16384

oracle soft nofile 1024

oracle hard nofile 65536

"/etc/security/limits.conf" 52L, 1800C written

[root@vm11g ~]# vi /etc/profile

# /etc/profile

# System wide environment and startup programs, for login setup

# Functions and aliases go in /etc/bashrc

pathmunge () {

if ! echo $PATH | /bin/egrep -q "(^|:)$1($|:)" ; then

if [ "$2" = "after" ] ; then

PATH=$PATH:$1

else

PATH=$1:$PATH

fi

}

# Path manipulation

if [ `id -u` = 0 ]; then

pathmunge /sbin

pathmunge /usr/sbin

pathmunge /usr/local/sbin

fi

pathmunge /usr/X11R6/bin after

# No core files by default

ulimit -S -c 0 > /dev/null 2>&1

USER="`id -un`"

LOGNAME=$USER

MAIL="/var/spool/mail/$USER"

HOSTNAME=`/bin/hostname`

HISTSIZE=1000

if [ -z "$INPUTRC" -a ! -f "$HOME/.inputrc" ]; then

INPUTRC=/etc/inputrc

fi

export PATH USER LOGNAME MAIL HOSTNAME HISTSIZE INPUTRC

for i in /etc/profile.d/*.sh ; do

if [ -r "$i" ]; then

. $i

fi

done

unset i

unset pathmunge

if [ $USER = "oracle" ]; then

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

ulimit -p 16384

ulimit -n 65536

else

ulimit -u 16384 -n 65536

fi

"/etc/profile" 60L, 1013C written

UNZIP oracle software

[root@vm11g ~]# ls

11gpkg install.log

anaconda-ks.cfg install.log.syslog

binutils-2.15.92.0.2-21.i386.rpm linux_11gR1_database_1013.zip

database

[root@vm11g ~]# rm -Rf linux_11gR1_database_1013.zip

[root@vm11g ~]# mv database /home/oracle

[root@vm11g ~]# cd /home/oracle

[root@vm11g oracle]# ls

database product

[root@vm11g oracle]# ll

total 16

drwxr-xr-x 5 root root 4096 Oct 7 2008 database

drwxr-xr-x 3 oracle oinstall 4096 Dec 10 09:14 product

[root@vm11g oracle]# chown -R oracle:oinstall database

[root@vm11g oracle]# ls

database product

[root@vm11g oracle]# ll

total 16

drwxr-xr-x 5 oracle oinstall 4096 Oct 7 2008 database

drwxr-xr-x 3 oracle oinstall 4096 Dec 10 09:14 product

配置使用XMANAGER

[oracle@vm11g ~]$ vi .bash_profile

# User specific environment and startup programs

PATH=$PATH:$HOME/bin

export PATH

unset USERNAME

exprot ORACLE_SID=xh11g

export ORACLE_BASE=/home/oracle

export ORACLE_HOME=$ORACLE_BASE/product/11g/database

export ORACLE_TERM=xterm

export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib:$ORACLE_HOME/rdbms/lib

export CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib

export CLASSPATH=$CLASSPATH:$ORACLE_HOME/network/jlib

export PATH=$PATH:/home/oracle/OPatch

export CV_HOME=/home/oracle/support/cvu

alias ss="sqlplus '/ as sysdba'"

alias bdump="cd $ORACLE_BASE/admin/xh11g/bdump"

alias dblog="more $ORACLE_BASE/admin/*/bdump/alert_$ORACLE_SID.log"

alias tailog="tail -f $ORACLE_BASE/admin/*/bdump/alert_$ORACLE_SID.log &"

stty kill '^X' intr '^C'

stty erase ^h

DISPLAY=192.168.0.1:0;export DISPLAY

".bash_profile" 33L, 913C written

[oracle@vm11g ~]$ su - oracle

Password:

-bash: exprot: command not found

[oracle@vm11g ~]$ env | grep DIS ~檢查下

DISPLAY=192.168.0.1:0

hecking operating system requirements ...

Expected result: One of enterprise-4,enterprise-5,redhat-4,redhat-5,SuSE-10,asianux-2,asianux-3

Actual Result: redhat-4

Check complete. The overall result of this check is: Passed

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

Checking operating system package requirements ...

Checking for make-3.80; found make-1:3.80-6.EL4-i386. Passed

Checking for binutils-2.15.92.0.2; found binutils-2.15.92.0.2-21-i386. Passed

Checking for gcc-3.4.5; found gcc-3.4.6-3-i386. Passed

Checking for libaio-0.3.105; found libaio-0.3.105-2-i386. Passed

Checking for libaio-devel-0.3.105; found libaio-devel-0.3.105-2-i386. Passed

Checking for libstdc++-3.4.5; found libstdc++-3.4.6-3-i386. Passed

Checking for elfutils-libelf-devel-0.97; found elfutils-libelf-devel-0.97.1-3-i386. Passed

Checking for sysstat-5.0.5; found sysstat-5.0.5-11.rhel4-i386. Passed

Checking for libgcc-3.4.5; found libgcc-3.4.6-3-i386. Passed

Checking for libstdc++-devel-3.4.5; found libstdc++-devel-3.4.6-3-i386. Passed

Checking for unixODBC-2.2.11; found unixODBC-2.2.11-1.RHEL4.1-i386. Passed

Checking for unixODBC-devel-2.2.11; Not found. Failed <<<<

Check complete. The overall result of this check is: Failed <<<<

Problem: Some packages required for the Oracle Database 11g to function properly are missing (see above).

Recommendation: Install the required packages before continuing with the installation.

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

dc++-devel-3.4.5; found libstdc++-devel-3.4.6-3-i386. Passed

Checking for unixODBC-2.2.11; found unixODBC-2.2.11-1.RHEL4.1-i386. Passed

Checking for unixODBC-devel-2.2.11; Not found. Failed <<<<

Check complete. The overall result of this check is: Failed <<<<

Problem: Some packages required for the Oracle Database 11g to function properly are missing (see above).

Recommendation: Install the required packages before continuing with the installation.

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

Checking kernel parameters

Checking for semmsl=250; found semmsl=250. Passed

Checking for semmns=32000; found semmns=32000. Passed

Checking for semopm=100; found semopm=100. Passed

Checking for semmni=128; found semmni=128. Passed

Checking for shmmax=536870912; found shmmax=2147483648. Passed

Checking for shmmni=4096; found shmmni=4096. Passed

Checking for shmall=2097152; found shmall=2097152. Passed

Checking for file-max=65536; found file-max=121159. Passed

Checking for VERSION=2.6.9; found VERSION=2.6.9-42.ELsmp. Passed

Checking for ip_local_port_range=1024 - 65000; ip_local_port_range=9000 - 65500. Failed <<<<

Checking for rmem_default=4194304; rmem_default=262144. Failed <<<<

Checking for rmem_max=4194304; found rmem_max=4194304. Passed

Checking for wmem_default=262144; found wmem_default=262144. Passed

Checking for wmem_max=262144; found wmem_max=1048576. Passed

Check complete. The overall result of this check is: Failed <<<<

Problem: The kernel parameters do not meet the minimum requirements (see above).

Recommendation: Perform. operating system specific instructions to update the kernel parameters.

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

Checking Recommended glibc version

Expected result: ATLEAST=2.3.4-2.19

Actual Result: 2.3.4-2.25

Check complete. The overall result of this check is: Passed

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

Checking physical memory requirements ...

Expected result: 922MB

Actual Result: 1192MB

Check complete. The overall result of this check is: Passed

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

Checking available swap space requirements ...

Expected result: 1788MB

Actual Result: 2400MB

Check complete. The overall result of this check is: Passed

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

Checking Network Configuration requirements ...

Check complete. The overall result of this check is: Not executed <<<<

Recommendation: Oracle supports installations on systems with DHCP-assigned public IP addresses. However, the primary network interface on the system should be configured with a static IP address in order for the Oracle Software to function properly. See the Installation Guide for more details on installing the software on systems configured with DHCP.

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

Checking PATH environment variable...

Check complete. The overall result of this check is: Passed

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

Checking for sufficient diskspace in TEMP location...

Check complete. The overall result of this check is: Passed

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

Checking LD_LIBRARY_PATH environment variable...

Check complete. The overall result of this check is: Passed

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

Validating ORACLE_BASE location (if set) ...

Check complete. The overall result of this check is: Passed

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

Checking Oracle Home path for spaces...

Check complete. The overall result of this check is: Passed

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

Checking for proper system clean-up....

Check complete. The overall result of this check is: Passed

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

Checking for Oracle Home incompatibilities ....

Actual Result: NEW_HOME

Check complete. The overall result of this check is: Passed

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

[root@vm11g ~]# cd /home/oracle/oraInventory/

[root@vm11g oraInventory]# sh orainstRoot.sh

Changing permissions of /home/oracle/oraInventory to 770.

Changing groupname of /home/oracle/oraInventory to oinstall.

The execution of the script. is complete

[root@vm11g oraInventory]# cd /home/oracle/product/11g/database/

[root@vm11g database]# sh root.sh

Running Oracle 11g root.sh script...

The following environment variables are set as:

ORACLE_OWNER= oracle

ORACLE_HOME= /home/oracle/product/11g/database

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.

Finished product-specific root actions.

[root@vm11g database]#

Dbca netca在 oracle home BIN 下

[oracle@vm11g ~]$ echo $ORACLE_HOME

/home/oracle/product/11g/database

[oracle@vm11g ~]$ cd $ORACLE_HOME

[oracle@vm11g database]$ cd bin

[oracle@vm11g bin]$ ll dbca

-rwxr-xr-x 1 oracle oinstall 6775 Dec 10 10:21 dbca

[oracle@vm11g bin]$ sh dbca

在安裝時在OEM 步驟要求先配置LINSTER （netca）

[oracle@vm11g bin]$ ./sqlplus "/ as sysdba"

SQL*Plus: Release 11.1.0.6.0 - Production on Thu Dec 10 11:01:25 2009

Connected to:

Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> select name from v$database;

NAME

---------

XH

User oracle 環境變數不對
[oracle@vm11g ~]$ 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

export ORACLE_SID=xh

export ORACLE_BASE=/home/oracle

export ORACLE_HOME=$ORACLE_BASE/product/11g/database

export ORACLE_TERM=xterm

export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib:$ORACLE_HOME/rdbms/lib

export CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib

export CLASSPATH=$CLASSPATH:$ORACLE_HOME/network/jlib

export PATH=$ORACLE_HOME/bin:$PATH

export CV_HOME=/home/oracle/support/cvu

".bash_profile" 35L, 909C written

Netca 配置 LISTENER，TNSNAME.ORA

[oracle@vm11g admin]$ lsnrctl status

LSNRCTL for Linux: Version 11.1.0.6.0 - Production on 10-DEC-2009 11:42:22

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=vm11g)(PORT=1521)))

STATUS of the LISTENER

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

Alias LISTENER

Version TNSLSNR for Linux: Version 11.1.0.6.0 - Production

Start Date 10-DEC-2009 11:40:15

Uptime 0 days 0 hr. 2 min. 7 sec

Trace Level off

Security ON: Local OS Authentication

SNMP OFF

Listener Parameter File /home/oracle/product/11g/database/network/admin/listener.ora

Listener Log File /home/oracle/diag/tnslsnr/vm11g/listener/alert/log.xml

Listening Endpoints Summary...

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=vm11g)(PORT=1521)))

(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))

Services Summary...

Service "xh" has 1 instance(s).

Instance "xh", status READY, has 1 handler(s) for this service...

Service "xhXDB" has 1 instance(s).

Instance "xh", status READY, has 1 handler(s) for this service...

Service "xh_XPT" has 1 instance(s).

Instance "xh", status READY, has 1 handler(s) for this service...

The command completed successfully

[oracle@vm11g admin]$ sqlplus system/a831115@xh

SQL*Plus: Release 11.1.0.6.0 - Production on Thu Dec 10 11:42:36 2009

Connected to:

Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> select * from v$version;

BANNER

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

Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - Production

PL/SQL Release 11.1.0.6.0 - Production

CORE 11.1.0.6.0 Production

TNS for Linux: Version 11.1.0.6.0 - Production

NLSRTL Version 11.1.0.6.0 – Production

SQL> show parameter backg

NAME TYPE VALUE

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

background_core_dump string partial

background_dump_dest string /home/oracle/diag/rdbms/xh/xh/

trace

SQL> show parameter user

NAME TYPE VALUE

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

license_max_users integer 0

parallel_adaptive_multi_user boolean TRUE

redo_transport_user string

user_dump_dest string /home/oracle/diag/rdbms/xh/xh/

trace

SQL>

[oracle@vm11g ~]$ vi .bash_profile

# Get the aliases and functions

if [ -f ~/.bashrc ]; then

. ~/.bashrc

fi

# User specific environment and startup programs

PATH=$PATH:$HOME/bin

alias bdump="cd /home/oracle/diag/rdbms/xh/xh/

alias bdump="cd /home/oracle/diag/rdbms/xh/xh/trace

alias tailog="tail -f /home/oracle/diag/rdbms/xh/xh/trace/alert_$ORACLE_SID.log export PATH

unset USERNAME

export ORACLE_SID=xh

export ORACLE_BASE=/home/oracle

export ORACLE_HOME=$ORACLE_BASE/product/11g/database

export ORACLE_TERM=xterm

export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib:$ORACLE_HOME/rdbms/lib

export CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib

export CLASSPATH=$CLASSPATH:$ORACLE_HOME/network/jlib

export PATH=$ORACLE_HOME/bin:$PATH

export CV_HOME=/home/oracle/support/cvu

alias ss="sqlplus '/ as sysdba'"

alias bdump="cd /home/oracle/diag/rdbms/xh/xh/trace"

alias dblog="more /home/oracle/diag/rdbms/xh/xh/trace/alert_$ORACLE_SID.log"

alias tailog="tail -f /home/oracle/diag/rdbms/xh/xh/trace/alert_$ORACLE_SID.log &"

stty kill '^X' intr '^C'

stty erase ^h

".bash_profile" 36L, 933C written

[oracle@vm11g ~]$ su - oracle

Password:

[oracle@vm11g ~]$ ss

SQL*Plus: Release 11.1.0.6.0 - Production on Thu Dec 10 11:50:32 2009

Connected to:

Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> exit

Disconnected from Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

[oracle@vm11g ~]$ bdump

[oracle@vm11g trace]$ taillog

-bash: taillog: command not found

[oracle@vm11g trace]$ tailog

[1] 21527

[oracle@vm11g trace]$ db_recovery_file_dest_size of 2048 MB is 0.00% used. This is a

user-specified limit on the amount of space that will be used by this

database for recovery-related files, and does not reflect the amount of

space available in the underlying filesystem or ASM diskgroup.

Thu Dec 10 10:56:11 2009

Completed: ALTER DATABASE OPEN

Thu Dec 10 11:10:55 2009

Starting background process CJQ0

Thu Dec 10 11:10:55 2009

CJQ0 started with pid=25, OS id=21300

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/12020513/viewspace-622204/，如需轉載，請註明出處，否則將追究法律責任。

rh4上 安裝oracle 11g r1

相關文章

rh4上安裝oracle 11g r1