Oracle common commands that run on Linux

Switch to Oracle User

Su-oracle #目录转到oracle用户的HOME下, together with the user's shell to switch, only the environment variable that switches Shell,path is valid. Su only switches identities, and the shell environment is still the original user's shell environment.

/********************************************/

1.1 Do not log into the sqlplus environment.

Sqlplus/nolog

1.2 Connecting users

Sql>connect username/[email protected]_servicename# Local connection can omit network service name

1.3 Turn off DB instance

Sql>connect/as sysdba; #需要以sysdba身份登录才能进行此操作.

sql>startup;

Sql>shutdown immediate; #执行完当前正在执行的语句后断开连接.

/********************************************/

2.1 Entering the Monitor control interface

Lsnrctl #listener Control Abbreviations

Lsnrctl>status #查看监听状态

Lsnrctl>start #开启监听

Lsnrctl>stop #停止监听

Lsnrctl>exit #退出监听控制界面

Description: Listens for the connection phase only for remote connections.

The local connection uses IPC communication, does not need to listen, the connection establishment also no longer needs to listen.

Oracle common commands that run on Linux