Transcript 5 - Elte
Controlling the Database Copyright © 2004, Oracle. All rights reserved. Objectives After completing this lesson, you should be able to do the following: • Start and stop iSQL*Plus • Start and stop Enterprise Manager Database Control • Start and stop the Oracle Listener • Start up and shut down Oracle Database 10g 5-2 Copyright © 2004, Oracle. All rights reserved. Starting and Stopping iSQL*Plus 5-3 $ isqlplusctl start iSQL*Plus 10.1.0.2.0 Copyright (c) 2004 Oracle. Starting iSQL*Plus ... iSQL*Plus started. All rights reserved. $ isqlplusctl stop iSQL*Plus 10.1.0.2.0 Copyright (c) 2004 Oracle. Stopping iSQL*Plus ... iSQL*Plus stopped. All rights reserved. Copyright © 2004, Oracle. All rights reserved. Management Framework The three components of the Oracle Database 10g 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 10g Database Control Release 10.1.0.2.0 Copyright (c) 1996, 2004 Oracle Corporation. All rights reserved. http://edrsr9p1.us.oracle.com: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_1/edrsr9p1.us.oracle.com_orcl/sys man/log $ emctl stop dbconsole TZ set to US/Pacific Oracle Enterprise Manager 10g Database Control Release 10.1.0.2.0 Copyright (c) 1996, 2004 Oracle Corporation. All rights reserved. http://edrsr9p1.us.oracle.com:5500/em/console/aboutApplication Stopping Oracle Enterprise Manager 10g 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-10 Copyright © 2004, Oracle. All rights reserved. Starting Up a Database NOMOUNT OPEN STARTUP MOUNT NOMOUNT Instance started SHUTDOWN 5-11 Copyright © 2004, Oracle. All rights reserved. Starting Up a Database MOUNT OPEN STARTUP MOUNT NOMOUNT Control file opened for this instance Instance started SHUTDOWN SHUTDOWN 5-12 Copyright © 2004, Oracle. All rights reserved. Starting Up a Database OPEN 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 SHUTDOWN 5-13 Copyright © 2004, Oracle. All rights reserved. Shutting Down the Database Shutdown Mode A I T N Allow new connections No No No No Wait until current sessions end No No No Yes Wait until current transactions end No No Yes Yes Force a checkpoint and close files No Yes 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 spfiledb01.ora 5-18 Copyright © 2004, Oracle. All rights reserved. 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 iSQL*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 iSQL*Plus • Stopping and starting Enterprise Manager Database Control • Stopping and starting the database • Stopping and starting iSQL*Plus 5-22 Copyright © 2004, Oracle. All rights reserved.