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
----------------------------------------------------------