Use SQL * Plus to access the database to run SQL * Plus: $ SQLPLUS
ENTER User-name: / as sysdba
Using Oracle Enterprise Manager 10g database Control In a web browser, connect to the URL provided during the installation process. For example: http: //ds1.orademo.org: 5500 / em (If the server is not in DNS, you must use the IP address instead of the host name.) Username: SYS password:
$ EMCTL Stop DBCONSOLE Use ISQL * Plus to access the database http://ds1.orademo.org:5560/ISQLPLUS (if the database server is not in DNS, you must use the IP address instead of the host name.) Username: System Name:
$ IsqlplusctL Stop Starts and Stop listeners: The listener accepts the client's connection request and creates a database connection after verifying the certificate. To use OEM or ISQL * Plus, you must first start the listener. $ LSNRCTL START
$ LSNRCTL STOP
Start and stop the database: The easiest way to start and stop the database is to start and stop from the OEM console. To do this from the command line, use SQL * Plus as shown in Oracle as follows: Start: $ SQLPLUS
ENTER User-name: / as sysdbasql> Startup
SQL> EXIT stop: $ SQLPLUS
Enter User-name: / as sysdbasql> shutdown immediate
SQL> EXIT
List Oracle processes: $ PS A € "Fuoracle
