Oracle Database Basic Operations

1.su-oracle #进入到oracle数据库的用户里面

2. Start the database

$sqlplus/nolog

Mysql>conn/as SYSDBA Log in to the database as an administrator

Mysql>startup starting the database

Mysql>shudown immediate Closing the database

Mysql>quit exiting the database

3. Start monitoring Oracle Database $lsnrctl start

$lsnrctl Status View database listening status

$lsnrctl stop listening to the Oracle database

$lsnrctl Reload Restart Oracle Listener

You can also start stop detection of Oracle's status in Oracle's installation directory
As follows:
$ cd/opt/oracle/product/11.2.0/dbhome_1/bin

bin$ Lsnrctl

lsnrctl> Start Oracle Database detection

Stop to turn off Oracle database detection

Status View Oracle Database open Status

Oracle Database Basic Operations