Oracle Database 10g スタートアップ手順


Oracle Databaseの開始手順を度忘れに備えてメモ

    No. 内容 コマンド
    1. 起動

    [oracle@oolong ~]$ sqlplus /nolog
    
    SQL*Plus: Release 10.1.0.2.0 - Production on Sat Dec 4 22:41:58 2004
    
    Copyright (c) 1982, 2004, Oracle.  All rights reserved.
    
    SQL> conn system/****** as sysdba
    Connected.
    SQL> startup
    ORACLE instance started.
    
    Total System Global Area  188743680 bytes
    Fixed Size                   778036 bytes
    Variable Size             162537676 bytes
    Database Buffers           25165824 bytes
    Redo Buffers                 262144 bytes
    Database mounted.
    Database opened.
    

    2. リスナーの起動

    [oracle@oolong ~]$ lsnrctl start
    
    LSNRCTL for Linux: Version 10.1.0.2.0 - Production on 04-DEC-2004 22:43:37
    
    Copyright (c) 1991, 2004, Oracle.  All rights reserved.
    
    Starting /u01/app/oracle/product/10.1.0/db_2/bin/tnslsnr: please wait...
    
    TNSLSNR for Linux: Version 10.1.0.2.0 - Production
    System parameter file is /u01/app/oracle/product/10.1.0/db_2/network/admin/listener.ora
    Log messages written to /u01/app/oracle/product/10.1.0/db_2/network/log/listener.log
    
    

    3. Enterprise Mnager Consoleの開始

    [oracle@oolong ~]$ emctl start dbconsole
    TZ set to Japan
    Oracle Enterprise Manager 10g Database Control Release 10.1.0.2.0
    Copyright (c) 1996, 2004 Oracle Corporation.  All rights reserved.
    http://oolong.cafeaulait.bne.jp:5500/em/console/aboutApplication
    Starting Oracle Enterprise Manager 10g Database Control ..................... started.
    ------------------------------------------------------------------
    Logs are generated in directory /u01/app/oracle/product/10.1.0/db_2/oolong.cafeaulait.bne.jp_libra/sysman/log
    

    4. iSQLPlusの開始

    [oracle@oolong bin]$ isqlplusctl start
    iSQL*Plus 10.1.0.2.0
    Copyright (c) 2004 Oracle.  All rights reserved.
    Starting iSQL*Plus ...
    iSQL*Plus started.