QUOTE:
最初由 nash 发布
原来如此。那为什么我用别的用户名不可以登录呢?
你用什么用户名不可以登录呢
列出來看看!
[oracle@uwmesdev product]$ sqlplus /nolog
SQL*Plus: Release 10.1.0.2.0 - Production on Tue Mar 20 20:07:28 2001
Copyright (c) 1982, 2004, Oracle. All rights reserved.
SQL> conn / as sysdba
Connected.
SQL> col username format a20
SQL> col account_status format a20
SQL> select username,account_status from dba_users;
USERNAME ACCOUNT_STATUS
-------------------- --------------------
SYS OPEN
SYSTEM OPEN
DBSNMP OPEN
SYSMAN OPEN
XDB OPEN
OUTLN EXPIRED & LOCKED
MDSYS EXPIRED & LOCKED
ORDSYS EXPIRED & LOCKED
EXFSYS EXPIRED & LOCKED
只有account_status是open才可以喲!