oracle本机使用一

# su - oracle

$ lsnrctl status

$ lsnrctl start  //如果no listener

cd /u01/app/oracle/product/11.2.0/dbhome_1/sqlplus/admin 

vim glogin.sql                    //定义一些参数，如oracle所用编辑器，用户名提示

$sqlplus / as sysdba

SQL> startup

SQL> ALTER USER SCOTT IDENTIFIED BY TIGER ACCOUNT UNLOCK;

SQL> EXIT

$ sqlplus scott/tiger

SCOTT> SELECT * FROM TAB；

             > SELECT * FROM EMP;

             > L

             > /

            > SAVE OUT.SQL

            > @OUT

           > SPOOL OUT.TXT

           > SELECT * FROM TAB;

          > SPOOL OFF

          > HOST

          EXIT

           > HOST ls

          > desc EMP;