5 Controlling the Database Copyright 2004 Oracle All

Objectives After completing this lesson, you should be able to do the following: • Start and stop i. SQL*Plus • Start and stop Enterprise Manager Database Control • Start and stop the Oracle Listener • Start up and shut down Oracle Database 10 g 5 -2 Copyright © 2004, Oracle. All rights reserved.

Starting and Stopping i. SQL*Plus 5 -3 $ isqlplusctl start i. SQL*Plus 10. 1. 0. 2. 0 Copyright (c) 2004 Oracle. Starting i. SQL*Plus. . . i. SQL*Plus started. All rights reserved. $ isqlplusctl stop i. SQL*Plus 10. 1. 0. 2. 0 Copyright (c) 2004 Oracle. Stopping i. SQL*Plus. . . i. SQL*Plus stopped. All rights reserved. Copyright © 2004, Oracle. All rights reserved.

Management Framework The three components of the Oracle Database 10 g management framework are: • Database instance • Listener • Management interface – Database Control – Management agent (when using Grid Control) Management agent -or- Database Control Management interface 5 -4 Listener Copyright © 2004, Oracle. All rights reserved.

Starting and Stopping Database Control $ emctl start dbconsole TZ set to US/Pacific Oracle Enterprise Manager 10 g Database Control Release 10. 1. 0. 2. 0 Copyright (c) 1996, 2004 Oracle Corporation. All rights reserved. http: //edrsr 9 p 1. us. oracle. com: 5500/em/console/about. Application Starting Oracle Enterprise Manager 10 g Database Control. . . . . started. ---------------------------------Logs are generated in directory /u 01/app/oracle/product/10. 1. 0/db_1/edrsr 9 p 1. us. oracle. com_orcl/sys man/log $ emctl stop dbconsole TZ set to US/Pacific Oracle Enterprise Manager 10 g Database Control Release 10. 1. 0. 2. 0 Copyright (c) 1996, 2004 Oracle Corporation. All rights reserved. http: //edrsr 9 p 1. us. oracle. com: 5500/em/console/about. Application Stopping Oracle Enterprise Manager 10 g Database Control. . . Stopped. 5 -5 Copyright © 2004, Oracle. All rights reserved.

Accessing Database Control 5 -6 Copyright © 2004, Oracle. All rights reserved.

SYSOPER and SYSDBA 5 -7 Copyright © 2004, Oracle. All rights reserved.

Database Home Page 5 -8 Copyright © 2004, Oracle. All rights reserved.

Changing the Listener Status 5 -9 Copyright © 2004, Oracle. All rights reserved.

Startup and Shutdown Click Advanced Options to select startup options and shutdown mode 5

Starting Up a Database NOMOUNT OPEN STARTUP MOUNT NOMOUNT Instance started SHUTDOWN 5 -11

Starting Up a Database MOUNT OPEN STARTUP MOUNT NOMOUNT Control file opened for this

Starting Up a Database OPEN STARTUP MOUNT NOMOUNT All files opened as described by the control file for this instance Control file opened for this instance Instance started SHUTDOWN 5 -13 Copyright © 2004, Oracle. All rights reserved.

Shutting Down the Database Shutdown Mode A I T N Allow new connections No No Wait until current sessions end No No No Yes Wait until current transactions end No No Yes Force a checkpoint and close files No Yes Yes Shutdown mode: • A = ABORT • I = IMMEDIATE • T = TRANSACTIONAL • N = NORMAL 5 -14 Copyright © 2004, Oracle. All rights reserved.

SHUTDOWN Options During On the way down: • Database buffer cache written to the data files • Uncommitted changes rolled back • Resources released SHUTDOWN NORMAL or SHUTDOWN TRANSACTIONAL or SHUTDOWN IMMEDIATE Consistent database (clean database) 5 -15 Copyright © 2004, Oracle. All rights reserved. On the way up: • No instance recovery

SHUTDOWN Options On the way down: • Modified buffers are not written to the data files • Uncommitted changes are not rolled back On the way up: • Online redo SHUTDOWN ABORT log files used or to reapply Instance Failure changes or STARTUP FORCE • Undo segments used to roll back uncommitted changes • Resources Inconsistent database released (dirty database) 5 -17 During Copyright © 2004, Oracle. All rights reserved.

Initialization Parameter Files spfiledb 01. ora 5 -18 Copyright © 2004, Oracle. All rights

Viewing Initialization Parameters 5 -19 Copyright © 2004, Oracle. All rights reserved.

Viewing the Alert Log 5 -20 Copyright © 2004, Oracle. All rights reserved.

Summary In this lesson, you should have learned how to: • Start and stop i. SQL*Plus • Start and stop Enterprise Manager Database Console • Start and stop the listener • Start up and shut down the database 5 -21 Copyright © 2004, Oracle. All rights reserved.

Practice 5: Controlling the Database This practice covers the following topics: • Connecting to the database using SQL*Plus and i. SQL*Plus • Stopping and starting Enterprise Manager Database Control • Stopping and starting the database • Stopping and starting i. SQL*Plus 5 -22 Copyright © 2004, Oracle. All rights reserved.