Tuesday, April 15, 2008

Different ways of Starting Up a Database

Options for Starting Up a Database
-----------------------------------
1)Starting Up a Database Using SQL*Plus
-----------------------------------------------
$sqlplus /nolog
SQL>conn / as sysdba
SQL>startup


2)Starting Up a Database Using Recovery Manager
---------------------------------------------------

1)oracle@neptune:~$ rman target /

Recovery Manager: Release 10.2.0.1.0 - Production on Tue Apr 15 18:08:04 2008

Copyright (c) 1982, 2005, Oracle. All rights reserved.

connected to target database (not started)

2)RMAN> startup


Oracle instance started
database mounted
database opened

3)Starting Up a Database Using Oracle Enterprise Manager
---------------------------------------------------------------

1)emctl start dbconsole
2)paste the url in to the browser.
3)Enter host credential and database credential as sysdba.
4)Press yes.

No comments:

Post a Comment