linux下oracle 启动/关闭 isqlplus、me 启动/关闭

RIA知识库

flex

RIA

变量设置

$su-oracle

$vi.bash_profile

添加以下变量（目录更改自己安装目录）

exportORACLE_BASE=/01u/app/oracle

exportORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_1

exportORACLE_SID=orcl

exportPATH=$ORACLE_HOME/bin:$PATH

exportORACLE_BASEORACLE_HOMEORACLE_SIDPATH

启动orcale

----------------------------------------

Runthefollowingcommandstostarttheinstance:

$sqlplus/nolog

SQL>CONNECTSYS/sys_passwordasSYSDBA

SQL>STARTUP

-----------------------------------------

关闭oracle

Runthefollowingcommandstoshutdowntheinstance:

$sqlplus/nolog

QL>CONNECTSYS/sys_passwordasSYSDBA

QL>SHUTDOWNNORMAL

-----------------------------------------

StoppingandStartinganOracleNetListener

$lsnrctlstart

查看tnslsnr进程

$ps-ef|greptnslsnr

RunthefollowingcommandtostoptheOracleNetlistener:

$$ORACLE_HOME/bin/lsnrctlstoplistenername

RestartingOracleNetListener

RunthefollowingcommandtorestarttheOracleNetlistener:

$$ORACLE_HOME/bin/lsnrctlstart[listenername]

Youmustspecifythelistenernameonlyifitisdifferentfromthedefaultlistenername,LISTENER.Thelistenernameismentionedinthelistener.orafile.Todisplaythecontentsofthisfile,runthefollowingcommand:

$more$ORACLE_HOME/network/admin/listener.ora

--------------------------------------------

StoppingandStartingiSQL*Plus

RunthefollowingcommandtostopiSQL*Plus:

$$ORACLE_HOME/bin/isqlplusctlstop

RunthefollowingcommandtostartiSQL*Plus:

$$ORACLE_HOME/bin/isqlplusctlstart

---------------------------------------------

StoppingandStartingOracleEnterpriseManagerDatabaseControl（ME）

RunthefollowingcommandtostoptheDatabaseControl:

$$ORACLE_HOME/bin/emctlstopdbconsole

RunthefollowingcommandtostarttheDatabaseControl:

$$ORACLE_HOME/bin/emctlstartdbconsole

----------------------------------------------------------