Some useful Oracle programs

First, log on as an Oracle user

1. $/oracle/app/product/101/bin/dbstart: Start the database.

2. $/oracle/app/product/101/bin/dbshut: Shut down the database.

3. $/oracle/app/product/101/bin/dbca: Database Configuration assistant for database installation, deletion, and modification.

4. $/oracle/app/product/101/bin/netca: database network service configuration management.

5. $/oracle/app/product/101/bin/netmgr: Database Network Service and Listener Configuration assistant.

6. $/oracle/app/product/101/bin/sqlplus: runs SQL statements, performs database operations, and starts and stops databases. Run the sqlplus command, enter the sys user and password, and run the following command:

> Shutdown immediate immediately shut down the database

> Startup start the database

7. $/oracle/app/product/101/bin/lsnrctl start: start database listening

$/Oracle/app/product/101/bin/lsnrctl stop: Disable database listening

$/Oracle/app/product/101/bin/lsnrctl status: view database listening

8. emctl stop dbconsole disable oracle EM Management