Oracle實踐

一:資料庫的登入:

首先保證資料庫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
已連線。

[@more@]

如果不能連線,可能是監聽沒有啟動,那麼就啟動監聽程式

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.

訪問即可

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.

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.

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.

OracleDBConsoleorcl10g 服務正在停止.........................................
.........
OracleDBConsoleorcl10g 服務已經成功停止。