手动建库发现scott 用户没有，下面来建一下：
step1：
Check user:
SQL> select username,password from dba_users;
USERNAME PASSWORD
------------------------------ ------------------------------
OUTLN 4A3BA55E08595C81
SYS 8A8F025737A9097A
SYSTEM 2D594E86F93B17A1
EZHOUDG 8A92EDCB3A36EBD7
DBSNMP E066D214D5421CCC
TSMSYS 3DF26A8B17D0F29F
DIP CE4A36B8E06CA59C
total 7 users.
Step2: create user from utlsampl.sql
[oracle@aoracle admin]$ sqlplus / as sysdba;
SQL*Plus: Release 10.2.0.1.0 - Production on Thu Sep 22 09:43:55 2011
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
SQL> show user;
USER is "SYS"
SQL> @?/rdbms/admin/utlsampl
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
[oracle@aoracle admin]$ sqlplus / as sysdba;
SQL*Plus: Release 10.2.0.1.0 - Production on Thu Sep 22 09:44:48 2011
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
SQL> select username ,account_status from dba_users;
USERNAME ACCOUNT_STATUS
------------------------------ --------------------------------
OUTLN OPEN
SYS OPEN
SYSTEM OPEN
EZHOUDG OPEN
SCOTT OPEN
DBSNMP EXPIRED & LOCKED
TSMSYS EXPIRED & LOCKED
DIP EXPIRED & LOCKED
8 rows selected.
发现scott 么有被lock, 如果lock 的话：
SQL> alter user scott account unlock;
User altered.