关闭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 startLSNRCTL for Linux: Version 10.2.0.1.0 - Production on 17-APR-2012 16:21:36Copyright （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 - ProductionSystem parameter file is /oracle/product/10.2.0/db_1/network/admin/listener.oraLog messages written to /oracle/product/10.2.0/db_1/network/log/listener.logListening 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 LISTENERVersion TNSLSNR for Linux: Version 10.2.0.1.0 - ProductionStart Date 17-APR-2012 16:21:37Uptime 0 days 0 hr. 0 min. 0 secTrace Level offSecurity ON: Local OS AuthenticationSNMP OFFListener Parameter File /oracle/product/10.2.0/db_1/network/admin/listener.oraListener Log File /oracle/product/10.2.0/db_1/network/log/listener.logListening 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 ~]$ dbstartProcessing Database instance "SiebelDB": log file /oracle/product/10.2.0/db_1/st artup.log[oracle@crmdb ~]$ emctl start dbconsoleTZ set to PRCOracle Enterprise Manager 10g Database Control Release 10.2.0.1.0Copyright （c） 1996, 2005 Oracle Corporation. All rights reserved.http://crmdb:1158/em/console/aboutApplicationStarting 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 stopLSNRCTL for Linux: Version 10.2.0.1.0 - Production on 08-MAY-2012 22:13:18Copyright （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 dbconsoleTZ set to PRCOracle Enterprise Manager 10g Database Control Release 10.2.0.1.0Copyright （c） 1996, 2005 Oracle Corporation. All rights reserved.http://crmdb:5500/em/console/aboutApplicationStarting 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 ~]$Oracle学习时关于SQL语言的总结在64位Win7系统下安装Oracle 11g和Oracle SQL Developer客户端相关资讯 Oracle基础教程怎么启动Oracle Oracle启动

CentOS 6.4下让Oracle开机启动（10/26/2014 10:20:46）
配置Oracle随系统启动和关闭（05/12/2014 20:02:39）
Oracle块编程返回结果集详解（11/10/2013 10:45:58）

Oracle dbstart 无法正常启动处理（06/04/2014 12:23:34）
Oracle启动与spfile文件（03/29/2014 14:11:35）
Oracle基础教程之tkprof程序详解（10/22/2013 11:49:50）

本文评论查看全部评论（0）