05/09/2014

[Oracle] Stop/start database and listener from command line

You can start or stop an Oracle database instance (you can dbca to configure one) from command line via the SQLPlus tool by connecting to it as SYSDBA user:

sqlplus
CONNECT SYS as SYSDBA

then to stop:

SHUTDOWN NORMAL

and to start:

STARTUP

To manage listeners on Linux (use netca to configure one) you can run instead:

$ORACLE_HOME/bin/lsnrctl stop|start

Where is the name of the listener as configured via netca or found as the output of:

ps -ef | grep tnslsnr

No comments:

Post a Comment

With great power comes great responsibility.

Da grandi poteri derivano grandi responsabilità.