Starting and stopping an environment
Normally, we would develop on an environment provided by an organization that employs a full time DBA. Their role is to manage the environment and ensure that it is up and running. However, sometimes we may have to manage our own environment for training purposes or there is a small development team. Therefore, the next recipe will cover the following tasks:
Starting an environment
Stopping an environment
Starting an environment
The following steps will start an idle environment. The install has completed and the environment is idle.
How to do it...
To start an environment, perform the following.
Open PuTTY and log on to the database server with the database OS owner.
Set the environment (if not already set).
Connect to SQL*Plus as
sysdbawith the following command:DB Tier> sqlplus “/as sysdba”
When connected to SQL*Plus, type the following command to start the database:
SQL>startup
Exit SQL*Plus by typing
exit.When back in the UNIX prompt, start the listener...
