Startup tutorial for multiple Oracle instances under Linux platform

  
 

Environment Description: The SID of Oracle instance 1 is orcl1, and the SID of instance 2 is orcl2. Log in using Oracle user:

  1. Start monitoring:

    [oracle@ dbserver01 ~] $ lsnrctl start

  2. modified example of the current SID SID is to be started, such as orcl1:

    [oracle @ dbserver01 ~] $ export ORACLE_SID = orcl1

  3. Starting after logging in with the database administrator:

    [oracle@dbserver01 ~]$sqlplus /as sysdba SQL*Plus: Release 11.2.0.1.0 Production on Thu May 2 09:00:54 2013 Copyright (c) 1982, 2009, Oracle. All rights reserved. Connected to an idle instance. SQL> startup; ORACLE instance started. Total System Global Area 4275781632 bytes Fixed Size 2220200 bytes Variable Size 2332036952 bytes Database Buffers 1929379840 bytes Redo Buffers 12144640 bytes database mounted database opened SQL & gt;.. exit

  4. to modify the current SID orcl2, start the database in the same way. Of course, the shutdown method is the same.



Copyright © Windows knowledge All Rights Reserved