First, start, turn off the database 1, start the database listening su - oracle --- Switch Oracle users (if you use Su Oracle, start the .profile user environment configuration file) $ lsnrctl start - start monitor 2, start the database $ SQLPLUS "/ as sysdba" --- use Sys users to log in SQLUSSQL * Plus: Release 9.2.0.5.0 - Production on Thu Oct 9 15:06:11 2003CopyRight (C) 1982, 2002, Oracle Corporation. All Rights Reserved. Connected to an idle instance.SQL> startup --- start the database ORACLE instance started.Total System Global Area 538412728 bytesFixed Size 743096 bytesVariable Size 268435456 bytesDatabase Buffers 268435456 bytesRedo Buffers 798720 bytesDatabase mounted.Database opened.SQL> exit --- exit sqlplusDisconnected from Oracle9i Enterprise Edition Release 9.2.0.5.0 - 64bit Productionwith The Partitioning OptionjServer Release 9.2.0.5.0 - Production or $ DBSTART3, View Database Process $ PS - EF | GREP ORA _ --- View Oracle Process Oracle 688322 1 0 15:06 : 20 - 0:00 ORA_SMON_BXMIS ORACLE 696534 704704 0 15:06:35 PTS / 4 0:00 grep ora_ oracle 729224 1 0 15:06:20 - 0:00 ora_dbw0_bxmis oracle 745618 1 0 15:06:20 - 0: 00 ora_reco_bxmis Oracle 770216 1 0 15:06:20 - 0:00 ORA_C KPT_BXMIS ORACLE 778394 1 0 15:06:20 - 0:00 Ora_PMON_BXMIS ORACLE 843876 1 0 15:06:20 - 0:00 Ora_QMN0_BXMIS ORACLE 901342 1 0 15:06:20 - 0:00 Ora_LGWR_BXMIS ORACLE 925704 1 0 15:06 : 20 - 0:00 ORA_CJQ0_BXMIS $ PS-EF | GREP LSNR --- View Oracle Listening Process 4, Turn off Database $ SQLPLUS "/ As SQL * Plus: Release 9.2.0.5.0 - Production On Th 10: . 07:04 2003Copyright (c) 1982, 2002, Oracle Corporation All rights reserved.Connected to: Oracle9i Enterprise Edition Release 9.2.0.5.0 - 64bit ProductionWith the Partitioning optionJServer Release 9.2.0.5.0 - ProductionSQL> shutdown immediate ---
Close the database Database closed.Database dismounted.ORACLE instance shut down.SQL> exitDisconnected from Oracle9i Enterprise Edition Release 9.2.0.5.0 - 64bit ProductionWith the Partitioning optionJServer Release 9.2.0.5.0 - Production or $ dbshut5, stop the database listener $ lsnrctl stop --- Stop listening
