Ubuntu 10.04 starts/disables databases, listeners, iSQL * Plus, and Enterprise Manager

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.