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 on 星期六 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