一:数据库的登录:

首先保证数据库is running;

打开sqlplus:

C:oracle10gproduct10.2.0db_1BIN>sqlplus /nolog

SQL*Plus: Release 10.2.0.1.0 - Production on 星期三 4月 12 12:34:52 2006

Copyright (c) 1982, 2005, Oracle. All rights reserved.

SQL> connect / as sysdba
已连接。

如果不能连接,可能是监听没有启动,那么就启动监听程序

C:oracle10gproduct10.2.0db_1BIN>lsnrctl

LSNRCTL> status / start / stop 查看状态 / 启动 / 停止

二:启动isqlplus网络访问

C:oracle10gproduct10.2.0db_1BIN>isqlplusctl startiSQL*Plus 10.2.0.1.0
Copyright (c) 2003, 2005, Oracle. All rights reserved.
Starting iSQL*Plus ...
iSQL*Plus started.

http://fshzh:5560/isqlplus访问即可

C:oracle10gproduct10.2.0db_1BIN>isqlplusctl stop
iSQL*Plus 10.2.0.1.0
Copyright (c) 2003, 2005, Oracle. All rights reserved.
Stopping iSQL*Plus ...
iSQL*Plus stopped.

三:启动EM

C:Documents and SettingsAdministrator>emctl status dbconsole
Oracle Enterprise Manager 10g Database Control Release 10.2.0.1.0
Copyright (c) 1996, 2005 Oracle Corporation. All rights reserved.
http://fshzh:1158/em/console/aboutApplication
Oracle Enterprise Manager 10g is running.说明em在运行

emctl start dbconsole 启动
emctl stop dbconsole 停止

如果提示:

C:Documents and SettingsAdministrator>emctl start dbconsole
Environment variable ORACLE_SID not defined. Please define it.

需要设置ORACLE_SID

C:Documents and SettingsAdministrator>set ORACLE_SID=DEREK

C:Documents and SettingsAdministrator>ECHO %ORACLE_SID%DEREK

C:Documents and SettingsAdministrator>emctl start dbconsole
Oracle Enterprise Manager 10g Database Control Release 10.1.0.2.0
Copyright (c) 1996, 2004 Oracle Corporation. All rights reserved.
http://derek:5500/em/console/aboutApplication
Starting Oracle Enterprise Manager 10g Database Control ...OracleDBConsoleorcl10
g 服務正在啟動 .................................................................
................................................
OracleDBConsoleorcl10g 服務已經啟動成功。

C:Documents and SettingsAdministrator>emctl stop dbconsole
Oracle Enterprise Manager 10g Database Control Release 10.1.0.2.0
Copyright (c) 1996, 2004 Oracle Corporation. All rights reserved.
http://derek:5500/em/console/aboutApplication
OracleDBConsoleorcl10g 服務正在停止.........................................
.........
OracleDBConsoleorcl10g 服務已經成功停止。