1. Start and Stop a database
1. Start the database
1.1 log on.
XX-laptop :~ $ Sqlplus "scott/tiger as sysdba"
The following Connection database information is displayed:
SQL * Plus: Release 10.2.0.1.0-Production on Mon Aug 9 15:30:16 2010
Copyright (c) 1982,200 5, Oracle. All rights reserved.
Connected to an idle instance.
SQL>
Indicates that you have successfully logged on to the database system.
1.2 start the database. Run the startup command to start the database.
SQL> startup
ORACLE instance started.
Total System Global Area 603979776 bytes
Fixed Size 1220796 bytes
Variable Size 171970372 bytes
Database Buffers 423624704 bytes
Redo Buffers 7163904 bytes
Database mounted.
Database opened.
SQL>
Indicates that the database is started normally.
2. Shut down the database
2.1 log on. Same as 1.1.
2.2 After successfully logging on to the database system, run the shudown command to close the database.
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
Indicates that the database is closed.
2. Start and Stop the listener
Oracle listeners provide interfaces for client connection. In the console window, enter the following command:
1. Start the listener.
Note: Not in SQL, but in bsh.
XX-laptop :~ $ Lsnrctl
The following listener information appears:
LSNRCTL for Linux: Version 10.2.0.1.0-Production on 09-AUG-2010 15:37:47
Copyright (c) 1991,200 5, Oracle. All rights reserved.
Welcome to LSNRCTL, type "help" for information.
LSNRCTL> start
Lists the startup and configuration information of the listener. When The last line of The information line is "The command completed successfully", The listener starts successfully.
2. Close the Oracle10g listener: run the stop command to close the listener.
LSNRCTL> stop
When The last line of The information line is "The command completed successfully", The listener stops successfully.
========================================================== ==================================
3. Start and Stop iSQL * Plus.
1. Start iSQL * Plus.
XX-laptop :~ $ Isqlplusctl start
ISQL * Plus 10.2.0.1.0
Copyright (c) 2003,200 5, Oracle. All rights reserved.
Starting iSQL * Plus...
ISQL * Plus started.
ISQL * Plus started. indicates that iSQL * Plus is successfully started.
2. Disable iSQL * Plus.
XX-laptop :~ $ Isqlplusctl stop
ISQL * Plus 10.2.0.1.0
Copyright (c) 2003,200 5, Oracle. All rights reserved.
Stopping iSQL * Plus...
ISQL * Plus stopped.
ISQL * Plus stopped indicates that iSQL * Plus has stopped successfully.
========================================================== ==================================
4. Use Enterprise Manager
1. Start the Console
XX-laptop :~ $ Emctl start dbconsole
TZ set to PRC
Oracle Enterprise Manager 10g Database Control Release 10.2.0.1.0
Copyright (c) 1996,200 5 Oracle Corporation. All rights reserved.
Http: // xhlh-laptop: 1158/em/console/aboutApplication
Starting Oracle Enterprise Manager 10g Database Control.
------------------------------------------------------------------
Logs are generated in directory/opt/ora10/product/10.2.0/db_1/xhlh-laptop_openlab/sysman/log
Indicates that the startup is successful.
2. Stop the console:
XX-laptop :~ $ Emctl stop dbconsole
TZ set to PRC
Oracle Enterprise Manager 10g Database Control Release 10.2.0.1.0
Copyright (c) 1996,200 5 Oracle Corporation. All rights reserved.
Http: // xhlh-laptop: 1158/em/console/aboutApplication
Stopping Oracle Enterprise Manager 10g Database Control...
... Stopped.
Indicates that the service is disabled successfully.