您好,欢迎访问一九零五行业门户网

在RedHat Linux环境下手工启动/关闭Oracle 服务

在redhat linux环境下手工启动/关闭oracle 服务
在redhat linux环境下设置手工启动oracle 10g数据库
1、修改文件/oracle/product/10.2.0/db_1/bin/dbstart
# vi /oracle/product/10.2.0/db_1/bin/dbstart
将以下内容修改为:
oracle_home_listner=/oracle/product/10.2.0/db_1/(将oracle监听的路径修改正确)
2、修改文件etc/oratab (如果没有此文件,请执行/oracle/product/10.2.0/db_1目录下的root.sh文件,完成10g安装会提示你运行此脚本)
# vi etc/oratab --此用户必须是root
将以下内容修改:
siebeldb:/oracle/product/10.2.0/db_1:y --(将n修改成y,注意必须大写)
开始启动oracle数据库:
[oracle@crmdb ~]$ lsnrctl start
lsnrctl for linux: version 10.2.0.1.0 - production on 17-apr-2012 16:21:36
copyright (c) 1991, 2005, oracle. all rights reserved.
starting /oracle/product/10.2.0/db_1/bin/tnslsnr: please wait...
tnslsnr for linux: version 10.2.0.1.0 - production
system parameter file is /oracle/product/10.2.0/db_1/network/admin/listener.ora
log messages written to /oracle/product/10.2.0/db_1/network/log/listener.log
listening on: (description=(address=(protocol=ipc)(key=extproc1)))
listening on: (description=(address=(protocol=tcp)(host=crmdb)(port=1521)))
connecting to (description=(address=(protocol=ipc)(key=extproc1)))
status of the listener
------------------------
alias listener
version tnslsnr for linux: version 10.2.0.1.0 - production
start date 17-apr-2012 16:21:37
uptime 0 days 0 hr. 0 min. 0 sec
trace level off
security on: local os authentication
snmp off
listener parameter file /oracle/product/10.2.0/db_1/network/admin/listener.ora
listener log file /oracle/product/10.2.0/db_1/network/log/listener.log
listening endpoints summary...
(description=(address=(protocol=ipc)(key=extproc1)))
(description=(address=(protocol=tcp)(host=crmdb)(port=1521)))
services summary...
service plsextproc has 1 instance(s).
instance plsextproc, status unknown, has 1 handler(s) for this service...
the command completed successfully
[oracle@crmdb ~]$ dbstart
processing database instance siebeldb: log file /oracle/product/10.2.0/db_1/st artup.log
[oracle@crmdb ~]$ emctl start dbconsole
tz set to prc
oracle enterprise manager 10g database control release 10.2.0.1.0
copyright (c) 1996, 2005 oracle corporation. all rights reserved.
:1158/em/console/aboutapplication
starting oracle enterprise manager 10g database control ............................. started.
------------------------------------------------------------------
logs are generated in directory /oracle/product/10.2.0/db_1/crmdb_siebeldb/sysman/log
[oracle@crmdb ~]$
关闭oracle10g服务
停止em服务 :emctl stop dbconsole
停止oracle服务:dbshut
停止监听服务:lsnrctl stop
[oracle@crmdb ~]$ lsnrctl stop
lsnrctl for linux: version 10.2.0.1.0 - production on 08-may-2012 22:13:18
copyright (c) 1991, 2005, oracle. all rights reserved.
connecting to (description=(address=(protocol=ipc)(key=extproc1)))
the command completed successfully
[oracle@crmdb ~]$
emctl status dbconsole --查看em状态
安装了2个实例的话,自动启动第一实例的em后,输入如下命令启动第二实例的em
[oracle@crmdb ~]$ export oracle_sid=uatdb --uatdb 是第二实例的sid
[oracle@crmdb ~]$ emctl start dbconsole
tz set to prc
oracle enterprise manager 10g database control release 10.2.0.1.0
copyright (c) 1996, 2005 oracle corporation. all rights reserved.
:5500/em/console/aboutapplication
starting oracle enterprise manager 10g database control .............................. started.
------------------------------------------------------------------
logs are generated in directory /oracle/product/10.2.0/db_1/crmdb_uatdb/sysman/log
[oracle@crmdb ~]$

其它类似信息

推荐信息