日期:2014-05-16  浏览次数:20719 次

linux下oracle 启动/关闭 isqlplus、me 启动/关闭
RIA知识库
flex
RIA
变量设置
$su - oracle
$vi .bash_profile
添加以下变量(目录更改自己安装目录)

export ORACLE_BASE=/01u/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_1
export ORACLE_SID=orcl
export PATH=$ORACLE_HOME/bin:$PATH
export ORACLE_BASE ORACLE_HOME ORACLE_SID PATH


启动orcale
----------------------------------------
Run the following commands to start the instance:
$ sqlplus /nolog
SQL> CONNECT SYS/sys_password as SYSDBA
SQL> STARTUP

-----------------------------------------
关闭oracle
Run the following commands to shut down the instance:
$ sqlplus /nolog
QL> CONNECT SYS/sys_password as SYSDBA
QL> SHUTDOWN NORMAL

-----------------------------------------
Stopping and Starting an Oracle Net Listener

$lsnrctl start
查看tnslsnr进程
$ ps -ef | grep tnslsnr

Run the following command to stop the Oracle Net listener:
$ $ORACLE_HOME/bin/lsnrctl stop listenername

Restarting Oracle Net Listener

Run the following command to restart the Oracle Net listener:

$ $ORACLE_HOME/bin/lsnrctl start [listenername]

You must specify the listener name only if it is different from the default listener name, LISTENER. The listener name is mentioned in the listener.ora file. To display the contents of this file, run the following command:

$ more $ORACLE_HOME/network/admin/listener.ora
--------------------------------------------
Stopping and Starting iSQL*Plus

Run the following command to stop iSQL*Plus:
$ $ORACLE_HOME/bin/isqlplusctl stop

Run the following command to start iSQL*Plus:
$ $ORACLE_HOME/bin/isqlplusctl start

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

Stopping and Starting Oracle Enterprise Manager Database Control(ME)

Run the following command to stop the Database Control:
$ $ORACLE_HOME/bin/emctl stop dbconsole

Run the following command to start the Database Control:
$ $ORACLE_HOME/bin/emctl start dbconsole

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