Posted on Leave a comment

Startup Shutdown Oracle DB

Listner commands at command prompt:

lsnrctl status
lsnrctl stop
lsnrctl start

Connect to Oracle

SET ORACLE_SID={SID}

sqlplus / AS SYSDBA

or

sqlplus /nolog
SQL>connect / AS SYSDBA

Shutdown

SQL>shutdown immediate

Startup

SQL>startup

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.