Re: how can I start my orcle database??? [message #52145] |
Fri, 05 July 2002 01:38 |
seng
Messages: 191 Registered: February 2002
|
Senior Member |
|
|
Two method to start db. Automatic (after start server) or Manually.
Automtic method, the user is needed to set the setting on SERVICE in Control Panel or use OEM to start the database.
Manually method, to start a database. below is the step
START:
- SET ORACLE_SID=<Oracle Sid>
- NET START ORACLESERVICE<sid name> (for NT only and UNIX doesn't need to start the service)
- SVRMGRL CINNECT INTERNAL;
- SVRMGRL STARTUP;
STOP:
- SVGMGRL CONNECT INTERNAL;
- SVRMGRL SHUTDOWN;
- NET STOP ORACLESERVICE<sid name> (for NT only and UNIX doesn't need to start the service)
To start other database, you just need to SET ORACLE_SID to point to database sid.
Hope this is helping
|
|
|