oracle教程:linux下啟動服務(wù)與監(jiān)聽命令

字號:


    在linux操作系統(tǒng)下,如何啟動服務(wù)與監(jiān)聽命令?首先必須以oracle用戶登陸:
    1、啟動數(shù)據(jù)庫:
    以下為引用的內(nèi)容:
    oracle@suse92:~> sqlplus /nolog
    sql*plus: release 9.2.0.4.0 - production on fri jan 20 02:29:37 2006
    copyright (c) 1982, 2002, oracle corporation. all rights reserved.
    sql> connect /as sysdba
    connected to an idle instance.
    sql> startup
    oracle instance started.
    total system global area 135352820 bytes
    fixed size 455156 bytes
    variable size 109051904 bytes
    database buffers 25165824 bytes
    redo buffers 679936 bytes
    database mounted.
    2、關(guān)閉數(shù)據(jù)庫:
    以下為引用的內(nèi)容:
    oracle@suse92:~> sqlplus /nolog
    sql*plus: release 9.2.0.4.0 - production on fri jan 20 02:29:37 2006
    copyright (c) 1982, 2002, oracle corporation. all rights reserved.
    sql> connect /as sysdba
    connected to an idle instance.
    sql> shutdwon abort;
    3、啟動監(jiān)聽器
    以下為引用的內(nèi)容:
    oracle@suse92:~> lsnrctl start
    4、停止監(jiān)聽器
    以下為引用的內(nèi)容:
    oracle@suse92:~> lsnrctl stop
    5、查看監(jiān)聽器狀態(tài)
    以下為引用的內(nèi)容:
    oracle@suse92:~> lsnrctl
    lsnrctl> status
    lsnrctl> exit