Learn Oracle


I have created this learn oracle "The step 10 process" Oracle Tutorial to help Database aspirants to accomplish their dream of working as Oracle Database administrator. I have tried to keep it simple and Oracle DBA friendly. Use NEXT and PREVIOUS Button to navaigate away and to a chapter. Since i myself had been a Database adminstrator trainer and has got real life experience of working as a Oracle DBA, I would welcome any sort of queries and doubts or modifications to webmaster@oracleonline.info.

Step 5 - Starting and Shutting Database

Learn Oracle - Starting and Shutting Down the Database Instance on Windows

Oracle DBA can start and shut down your Oracle database with the Windows Services program.

To start Oracle, Oracle DBA must start three services:

OracleService, which is your Oracle Database instance

OracleTNSListener, which is your listener required to allow clients to connect to your database

OracleDBConsole, which enables clients to connect to Enterprise Manager

To start these services:

From the Control Panel, select Administrative Tools->Services. A list of all available services on Oracle DBA system appears.

Locate the three Oracle services listed earlier. For example, if your SID is Sales1 and Oracle home is OraHome10, then locate the following services:




Start all three services. Oracle DBA can start a service by right-clicking the service, and selecting Start. Oracle DBA can also choose Start from the Actions menu. If Oracle DBA double click the service, the service properties page appears where Oracle DBA can Start or Stop the service, and select your Startup Type.

To shut down the database, Oracle DBA do the reverse: locate the services and stop them, by selecting Stop from the Actions menu.
Oracle Tutorial - BLOGS

STEP 5 - Next Topics
This step discusses starting and stopping the database instance, and managing initialization parameters.Learn Oracle DBA Step 5 by clicking links below:
Instance Memory StructureConfiguring Network
Oracle Background ProcessesBackground processes
Accessing the DatabaseAccessing the Database
Shuting down and Restarting the instance and DatabaseStarting and shutting the database
Viewing and Modifying Initialization
Managing Memory Parameters
Oracle Database - PODCASTS
More Tutorials on Oracle dba ...

Liked it ? Want to share it ? Social Bookmarking
Add to: Mr. Wong Add to: BoniTrust Add to: Newsider Add to: Digg Add to: Del.icio.us Add to: Reddit Add to: Jumptags Add to: StumbleUpon Add to: Slashdot Add to: Netscape Add to: Furl Add to: Yahoo Add to: Spurl Add to: Google Add to: Blinklist Add to: Technorati Add to: Newsvine Information

Source : Oracle Documentation | Oracle DBA

Want to share or request Oracle Tutorial articles to become a Oracle DBA. Direct your requests to webmaster@oracleonline.info