sqlplus命令

Microsoft Windows XP [版本 5.1.2600]
(C) 版权所有 1985-2001 Microsoft Corp.

C:/Documents and Settings/Administrator>SQLPLUS /NOLOG

SQL*Plus: Release 9.2.0.1.0 - Production on 星期四 3月 30 21:23:26 2006

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.

SQL> CONN SYS/SYS@LORCL
ERROR:
ORA-12541: TNS: 没有监听器

SQL> HOST SET ORACLE_SID=ORCL

SQL> CONN SYS/SYS@LORCL
ERROR:
ORA-12541: TNS: 没有监听器

SQL> CONN SYS/SYS@LORCL
ERROR:
ORA-12541: TNS: 没有监听器

SQL> CONN SYS/SYS@LORCL
ERROR:
ORA-12541: TNS: 没有监听器

SQL> CONN SYS/SYS
ERROR:
ORA-28009: connection to sys should be as sysdba or sysoper

SQL> CONN SYS/SYS AS SYSDBA
已连接。
SQL> SELECT USERNAME FROM DBA_USERS;

USERNAME
------------------------------
SYS
SYSTEM
DBSNMP
SCOTT
OUTLN
WMSYS
ORDSYS
ORDPLUGINS
MDSYS
CTXSYS
XDB

USERNAME
------------------------------
ANONYMOUS
WKSYS
WKPROXY
ODM
ODM_MTR
OLAPSYS
RMAN
HR
OE
PM
SH

USERNAME
------------------------------
QS_ADM
QS
QS_WS
QS_ES
QS_OS
QS_CBADM
QS_CB
QS_CS

已选择30行。

SQL> ^A