Fosdccf.blog.chinaunix.net
sdccf
全部博文(19283)
Linux酷软(214)
tmp(0)
PostgreSQL(93)
Solaris(383)
AIX(173)
SCOUNIX(575)
DB2(1005)
Shell(386)
C/C++(1187)
MySQL(1750)
Sybase(465)
Oracle(3695)
Informix(548)
HP-UX(0)
IBM AIX(2)
Sun Solaris(0)
BSD(1)
Linux(8597)
SCO UNIX(23)
2011年(1)
2009年(125)
2008年(19094)
2007年(63)
clifford
linky521
曾德标
fengzhan
leon_yu
mcuflowe
yt200902
guanyuji
GY123456
snow888
carlos94
丸喵喵
sean229
cxunix
可怜的猪
cqxc413
xzzgege
wb123456
分类: Oracle
2008-03-31 22:32:51
1. 在服务中起动 OracleServiceORCL.或运行oracle.exe ORCL 2. 启动实例: sqlplus sys/aaaaaaaa as sysdba SQL>startup ******************例子开始**************** d:\>SQLPLUS sys/aaaaaaaa as sysdba SQL*Plus: Release 10.1.0.2.0 - Production 星期六 8月 28 19:42:29 2004 Copyright (c) 1982, 2004, Oracle. All rights reserved. Connected to an idle instance. SQL> startup ORACLE instance started. Total System Global Area 134217728 bytes Fixed Size 787808 bytes Variable Size 61864608 bytes Database Buffers 71303168 bytes Redo Buffers 262144 bytes Database mounted. Database opened. SQL> select * from scott.a; ID NAME ---- -------------------- ADDRESS ------------------------------------ 01 姚湘 CHINA,中国吉林 SQL> *******************例子结束********** 3. 关闭 SQL> shutdown 4. 停相应的服务(OracleServiceORCL) 注释:开放port 1521 用 lsnrctl start,看状态用lsnrctl status,关闭用lsnrctl stop。
1. 在服务中起动 OracleServiceORCL.或运行oracle.exe ORCL
2. 启动实例:
sqlplus sys/aaaaaaaa as sysdba SQL>startup ******************例子开始**************** d:\>SQLPLUS sys/aaaaaaaa as sysdba SQL*Plus: Release 10.1.0.2.0 - Production 星期六 8月 28 19:42:29 2004 Copyright (c) 1982, 2004, Oracle. All rights reserved. Connected to an idle instance. SQL> startup ORACLE instance started. Total System Global Area 134217728 bytes Fixed Size 787808 bytes Variable Size 61864608 bytes Database Buffers 71303168 bytes Redo Buffers 262144 bytes Database mounted. Database opened. SQL> select * from scott.a; ID NAME ---- -------------------- ADDRESS ------------------------------------ 01 姚湘 CHINA,中国吉林 SQL> *******************例子结束**********
3. 关闭
SQL> shutdown
4. 停相应的服务(OracleServiceORCL)
注释:开放port 1521 用 lsnrctl start,看状态用lsnrctl status,关闭用lsnrctl stop。
上一篇:在Oracle中用于数据备份的触发器及表结构
下一篇:快速掌握Oracle数据库中的左连接与右连接
登录 注册