深入了解Oracle 10g for NT的起动和关闭
来源：岁月联盟
时间：2008-01-28
1. 在服务中起动 OracleServiceORCL.或运行oracle.exe ORCL
2. 启动实例:
sqlplus sys/aaaaaaaa as sysdbaSQL>startup******************例子开始****************d:/>SQLPLUS sys/aaaaaaaa as sysdbaSQL*Plus: Release 10.1.0.2.0 - Production 星期六 8月 28 19:42:29 2004Copyright (c) 1982, 2004, Oracle. All rights reserved.Connected to an idle instance.SQL> startupORACLE instance started.Total System Global Area 134217728 bytesFixed Size 787808 bytesVariable Size 61864608 bytesDatabase Buffers 71303168 bytesRedo Buffers 262144 bytesDatabase 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。
