Red Hat Enterprise Linux6.4-64λ °²×°Oracle11.2.0.3-64λ(Áù)

(Áù)½¨¿âºóÏà¹ØÅäÖÃ

²Ù×÷ϵͳ£ºRed Hat Enterprise Linux6.4-64λ

Êý¾Ý¿â£º Oracle11.2.0.3-64λ

Èí¼þ¼°°²×°°ü£º

VirtualBox-4.3.12-93733-Win.exe

SecureCRT

xmanagerenterprise3.0/4.0/5.0

p13390677_112040_Linux-x86-64_1of7.zip

p13390677_112040_Linux-x86-64_2of7.zip

pdksh-5.2.14-36.el5.x86_64.rpm

rhel-server-6.4-x86_64-dvd.iso

rlwrap-0.37.tar.gz

1.6 ½¨¿âºóÏà¹ØÅäÖÃ

1.6.1 sqlplusÃüÁîÌáʾ·û

[Oracle@rhel64 ~]$ cd $ORACLE_HOME/sqlplus/admin

[Oracle@rhel64 admin]$ vi glogin.sql

define _editor=vi

set linesize 100

set pagesize 9999

set sqlprompt "_user'@'_connect_identifier>"

[Oracle@rhel64 ~]$ sqlplus / as sysDBA

1.6.2 sqlplusÀúÊ·ÃüÁî

xftp ÉÏ´«Èí¼þ°ürlwrap Ô´´úÂë°ü

yum°²×°readline gcc

[root@rhel64 ~]# yum install readline*

[root@rhel64 ~]# yum install gcc*

ÑéÖ¤gcc make ÃüÁî¿ÉÓÃ

[root@rhel64 ~]# which make

[root@rhel64 ~]# which gcc

½â°ü

[root@rhel64 db]# tar -zxvf rlwrap-0.37.tar.gz

ÅäÖÃ

[root@rhel64 db]# cd rlwrap-0.37

[root@rhel64 rlwrap-0.37]# ./configure

±àÒë °²×°

[root@rhel64 rlwrap-0.37]# make

[root@rhel64 rlwrap-0.37]# make install

[root@rhel64 rlwrap-0.37]# which rlwrap

±à¼­OracleÓû§.bash_profileÎļþ ×·¼ÓÁ½ÐÐÅäÖÃ

[Oracle@rhel64 ~]$ vi .bash_profile

alias sqlplus='/usr/local/bin/rlwrap sqlplus'

alias rman='/usr/local/bin/rlwrap rman'

[Oracle@rhel64 ~]$ source .bash_profile

sqlplus µÇ¼²âÊÔ ÉÏÏ·½Ïò¼ü¿É²é¿´ÀúÊ·ÃüÁî

[Oracle@rhel64 ~]$ sqlplus / as sysDBA

1.6.3 scottÓû§

SYS@PROD>conn scott/tiger

SCOTT@PROD>show user

SCOTT@PROD>select * from emp;

SCOTT@PROD>select * from dept;

1.6.4 Õý³£¹Ø±ÕÊý¾Ý¿â

¹Ø±Õ²Ù×÷ϵͳ֮ǰ£¬±ØÐëÏÈʹÓÃsysÓû§Õý³£¹Ø±ÕÊý¾Ý¿âʵÀý¡£

SCOTT@PROD>conn / as sysDBA

SYS@PROD>show user

SYS@PROD>shutdown immediate;

Ïà¹Ø½ø³ÌÒѲ»´æÔÚ

1.6.5 Æô¶¯Êý¾Ý¿âÃüÁî

[Oracle@rhel64 ~]$ sqlplus / as sysDBA

idle instance ˵Ã÷Êý¾Ý¿âʵÀýûÓÐÆô¶¯

SYS@PROD>startup

SYS@PROD>select status from v$instance;