Linux Oracle Management

Use the Xshell tool.

Log in as root:

[Email protected] ~]#

To view (Oracle related) process status:

[[Email protected] ~]# PS Aux|grep Oracle

Or

[Email protected] ~]# Ps-eaf | grep Oracle

Kill Process:

[email protected] ~]# kill-9 13118

Log on as an Oracle User:

[Email protected] ~]# su-oracle

[Email protected] ~]$

View Listenter Status:

[Email protected] ~]$ lsnrctl status

Start Listenter:

[[email protected] ~]$ lsnrctl start

Stop Listenter:

[[email protected] ~]$ Lsnrctl stop

View $oracle_sid:

[Email protected] ~]$ echo $ORACLE _sid

set up and View $oracle_sid:

[Email protected] ~]$ export Oracle_sid=haiguaninf
[Email protected] ~]$ echo $ORACLE _sid

To start a stop instance:

[Email protected] ~]# su-oracle
[Email protected] ~]$ Sqlplus/nolog

Sql*plus:release 11.2.0.1.0 Production on Tue 16 15:37:33 2016

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

Sql> Conn/as SYSDBA

Start:

sql> Startup

Stop it:

sql> shutdown

Linux Oracle Management