介绍Windows/Linux下Oracle数据库进程如何启动和关闭
来源:互联网 发布:电脑硬盘修复软件 编辑:程序博客网 时间:2024/06/09 13:59
本文来自http://www.jzxue.com/shujuku/oracle/201101/10-5556.html
Windows:
C:/>net stop OracleServiceWBQ
The OracleServiceWBQ service is stopping........
The OracleServiceWBQ service could not be stopped.
C:/>net start OracleServiceWBQ
The OracleServiceWBQ service is starting...............
The OracleServiceWBQ service was started successfully.
C:/>lsnrctl stop
LSNRCTL for 32-bit Windows: Version 9.2.0.1.0 - Production on 15-MAR-2007 13:19:17
Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC0)))
The command completed successfully
C:/>lsnrctl start
The command completed successfully
C:/>sqlplus /nolog
SQL*Plus: Release 9.2.0.1.0 - Production on Thu Mar 15 13:19:28 2007
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
SQL> connect sys/change_on_install as sysdba
Connected.
Linux
1、启动ORACLE监听
首先要登录用户oracle:su - oracle
[oracle@localhost ~]$ cd product/10.2.0/db_1/bin/ --找到oracle安装bin下
[oracle@localhost bin]$ lsnrctl --启动oracle监听命令
LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 29-OCT-2010 19:36:02
Copyright (c) 1991, 2005, Oracle. All rights reserved.
Welcome to LSNRCTL, type "help" for information.
LSNRCTL> help --查看lsnrctl有哪些参数
The following operations are available
An asterisk (*) denotes a modifier or extended command:
start stop status
services version reload
save_config trace spawn
change_password quit exit
set* show*
LSNRCTL>start
Starting /home/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 /home/oracle/product/10.2.0/db_1/network/admin/listener.ora
Log messages written to /home/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=localhost.localdomain)(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 09-JUN-2010 10:26:45
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /home/oracle/product/10.2.0/db_1/network/admin/listener.ora
Listener Log File /home/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=localhost.localdomain)(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
(至此监听启动完成);
LSNRCTL> exit
2、启动数据库
[oracle@localhost bin]$ sqlplus /nolog;
SQL*Plus: Release 10.2.0.1.0 - Production on Wed Jun 9 10:27:18 2010
Copyright (c) 1982, 2005, Oracle. All rights reserved.
SQL> conn / as sysdba;
Connected to an idle instance.
SQL> startup
ORACLE instance started.
Total System Global Area 2147483648 bytes
Fixed Size 1220432 bytes
Variable Size 335544496 bytes
Database Buffers 1795162112 bytes
Redo Buffers 15556608 bytes
Database mounted.
Database opened.
(至此数据库启动)
SQL> exit
- 介绍Windows/Linux下Oracle数据库进程如何启动和关闭
- 介绍Windows/Linux下Oracle数据库进程如何启动和关闭
- Linux下启动和关闭Oracle服务与数据库
- Linux下启动和关闭Oracle服务与数据库
- Linux下oracle数据库启动和关闭操作
- Linux下oracle数据库启动和关闭操作
- Linux下oracle数据库启动和关闭操作
- Linux下oracle数据库启动和关闭操作
- Linux下oracle数据库启动和关闭操作
- Linux下oracle数据库启动和关闭操作
- Linux下oracle数据库启动和关闭操作
- Linux下oracle数据库启动和关闭操作
- Linux下oracle数据库启动和关闭操作
- Linux下oracle数据库启动和关闭操作
- Linux下oracle数据库启动和关闭操作
- 如何在linux下启动和关闭ORCALE数据库
- Linux下Oracle数据库启动及关闭
- Linux下如何启动关闭Oracle
- KDTable常用代码
- KDTable常用代码
- 错误代码中文查询GetLastError返回代码的含义
- 如何获取excel对应的sheet个数和对应的名字
- android上Bitmap获取的方法
- 介绍Windows/Linux下Oracle数据库进程如何启动和关闭
- map的应用(swap_word)
- Windows下安装Object C开发环境,及Hello Word
- mianArg.cpp 使用mian函数的参数 f0512.cpp
- a:visited 权重
- 一道上级面试题: 接受单词并按字典序排序
- 用VC写DLL中"error LNK2005: _DllMain@12 already defined"的错误
- (转载)Ext2 文件系统的硬盘布局
- .net 调用scilab 示例