Oracle常用操作

Start oracle    
    su - oracle
    lsnrctl start
    -->The command completed successfully
    sqlplus sys/PASSWORD@DBNAME as sysdba #(sys:user name, PASSWORD:password, DBNAME:database name, sysdba:mode)
    SQL> startup
 
Stop oracle
    su - oracle
    sqlplus sys/PASSWORD@DBNAME as sysdba #(sys:user name, PASSWORD:password, DBNAME:database name, sysdba:mode)
    SQL> shutdown immediate
    SQL> quit
    lsnrctl stop

Check Oracle version
    SQL> select * from v$version;                   

    BANNER
    ----------------------------------------------------------------
    Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Prod
    PL/SQL Release 10.2.0.1.0 - Production
    CORE    10.2.0.1.0      Production
    TNS for Linux: Version 10.2.0.1.0 - Production
    NLSRTL Version 10.2.0.1.0 - Production

    SQL>

Check Charset

    SQL> select userenv('lang') from dual;

    USERENV('LANG')
    ----------------------------------------------------
    US