HOW to start,Stop, Start and bounce an Oracle Database
Connect as SYS DBA or SYSOPER privilege
Stop:
SQL> shutdown
Options
-NORMAL
-IMMEDIATE
-TRANSACTIONAL
-ABORT
START:
SQL> startup
Options
– NOMOUNT
-MOUNT
-OPEN
BOUNCE:
SQL>startup force
It is a combination of shutdown abort + startup open (But beware of this command if there are other connections to database – they will be forcefully closed)
Stop:
SQL> shutdown
Options
-NORMAL
-IMMEDIATE
-TRANSACTIONAL
-ABORT
START:
SQL> startup
Options
– NOMOUNT
-MOUNT
-OPEN
BOUNCE:
SQL>startup force
It is a combination of shutdown abort + startup open (But beware of this command if there are other connections to database – they will be forcefully closed)
Subscribe to:
Post Comments
(
Atom
)
No comments :
Post a Comment