一般安装Oracle之后,如果scott用户无法登录,则需要以system用户登录,然后解锁即可


SQL> ALTER user scott account UNLOCK  
SQL> ALTER user scott IDENTIFIED BY tiger;修改scott用户密码


可是发现速成版中根本就没有scott用户,自然也就无法解锁,这应该是需要运行soctt.sql文件,从$ORACLE_HOME/rdbms/admin


文件夹中寻找,发现也并没有scott.sql文件。


这可能是由于express版本中本来就不带有该文件的缘故,可以从其他版本中复制,soctt.sql文件内容如下,可以复制,运行即可


Rem   Copyright   (c)   1990   BY   Oracle   Corporation
Rem NAME
REM UTLSAMPL.SQL
Rem FUNCTION
Rem NOTES
Rem MODIFIED
Rem gdudey 06/28/95 - Modified FOR desktop seed DATABASE
Rem glumpkin 10/21/92 - Renamed FROM SQLBLD.SQL
Rem blinden 07/27/92 - Added PRIMARY AND FOREIGN KEYS TO EMP AND DEPT
Rem rlim 04/29/91 - CHANGE char TO varchar2
Rem mmoore 04/08/91 - USE unlimited tablespace priv
Rem pritto 04/04/91 - CHANGE SYSDATE TO 13-JUL-87
Rem Mendels 12/07/90 - bug 30123;add to_date calls so LANGUAGE independent
Rem
rem
rem $Header: utlsampl.sql 7020100.1 94/09/23 22:14:24 cli Generic <base> $ sqlbld.sql
rem
SET TERMOUT OFF
SET ECHO OFF

rem CONGDON Invoked IN RDBMS at build time. 29-DEC-1988
rem OATES: Created: 16-Feb-83

GRANT CONNECT,RESOURCE,UNLIMITED TABLESPACE TO SCOTT IDENTIFIED BY TIGER;
ALTER USER SCOTT DEFAULT TABLESPACE USERS;
ALTER USER SCOTT TEMPORARY TABLESPACE TEMP;
CONNECT SCOTT/TIGER
DROP TABLE DEPT;
CREATE TABLE DEPT
(DEPTNO NUMBER(2) CONSTRAINT PK_DEPT PRIMARY KEY,
DNAME VARCHAR2(14) ,
LOC VARCHAR2(13) ) ;
DROP TABLE EMP;
CREATE TABLE EMP
(EMPNO NUMBER(4) CONSTRAINT PK_EMP PRIMARY KEY,
ENAME VARCHAR2(10),
JOB VARCHAR2(9),
MGR NUMBER(4),
HIREDATE DATE,
SAL NUMBER(7,2),
COMM NUMBER(7,2),
DEPTNO NUMBER(2) CONSTRAINT FK_DEPTNO REFERENCES DEPT);
INSERT INTO DEPT VALUES
(10, 'ACCOUNTING', 'NEW YORK');
INSERT INTO DEPT VALUES (20, 'RESEARCH', 'DALLAS');
INSERT INTO DEPT VALUES
(30, 'SALES', 'CHICAGO');
INSERT INTO DEPT VALUES
(40, 'OPERATIONS', 'BOSTON');
INSERT INTO EMP VALUES
(7369, 'SMITH', 'CLERK',7902,to_date( '17-12-1980', 'dd-mm-yyyy'),800,NULL,20);
INSERT INTO EMP VALUES
(7499, 'ALLEN', 'SALESMAN',7698,to_date( '20-2-1981', 'dd-mm-yyyy'),1600,300,30);
INSERT INTO EMP VALUES
(7521, 'WARD', 'SALESMAN',7698,to_date( '22-2-1981', 'dd-mm-yyyy'),1250,500,30);
INSERT INTO EMP VALUES
(7566, 'JONES', 'MANAGER',7839,to_date( '2-4-1981', 'dd-mm-yyyy'),2975,NULL,20);
INSERT INTO EMP VALUES
(7654, 'MARTIN', 'SALESMAN',7698,to_date( '28-9-1981', 'dd-mm-yyyy'),1250,1400,30);
INSERT INTO EMP VALUES
(7698, 'BLAKE', 'MANAGER',7839,to_date( '1-5-1981', 'dd-mm-yyyy'),2850,NULL,30);
INSERT INTO EMP VALUES
(7782, 'CLARK', 'MANAGER',7839,to_date( '9-6-1981', 'dd-mm-yyyy'),2450,NULL,10);
INSERT INTO EMP VALUES
(7788, 'SCOTT', 'ANALYST',7566,to_date( '13-JUL-87')-85,3000,NULL,20);
INSERT INTO EMP VALUES
(7839, 'KING', 'PRESIDENT',NULL,to_date( '17-11-1981', 'dd-mm-yyyy'),5000,NULL,10);
INSERT INTO EMP VALUES
(7844, 'TURNER', 'SALESMAN',7698,to_date( '8-9-1981', 'dd-mm-yyyy'),1500,0,30);
INSERT INTO EMP VALUES
(7876, 'ADAMS', 'CLERK',7788,to_date( '13-JUL-87')-51,1100,NULL,20);
INSERT INTO EMP VALUES
(7900, 'JAMES', 'CLERK ',7698,to_date( '3-12-1981', 'dd-mm-yyyy'),950,NULL,30);
INSERT INTO EMP VALUES
(7902, 'FORD', 'ANALYST',7566,to_date( '3-12-1981', 'dd-mm-yyyy'),3000,NULL,20);
INSERT INTO EMP VALUES
(7934, 'MILLER', 'CLERK',7782,to_date( '23-1-1982', 'dd-mm-yyyy'),1300,NULL,10);
DROP TABLE BONUS;
CREATE TABLE BONUS
(
ENAME VARCHAR2(10) ,
JOB VARCHAR2(9) ,
SAL NUMBER,
COMM NUMBER
) ;
DROP TABLE SALGRADE;
CREATE TABLE SALGRADE
( GRADE NUMBER,
LOSAL NUMBER,
HISAL NUMBER );
INSERT INTO SALGRADE VALUES (1,700,1200);
INSERT INTO SALGRADE VALUES (2,1201,1400);
INSERT INTO SALGRADE VALUES (3,1401,2000);
INSERT INTO SALGRADE VALUES (4,2001,3000);
INSERT INTO SALGRADE VALUES (5,3001,9999);
COMMIT;

SET TERMOUT ON
SET ECHO ON

OK,将该文件导入即可

[root@localhost human_resources]# sqlplus system

SQL*Plus: Release 10.2.0.1.0 - Production ON Fri Nov 5 11:17:29 2010

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

Enter password:

Connected TO:
Oracle DATABASE 10g Express Edition Release 10.2.0.1.0 - Production

SQL> @/root/scott.sql
SQL> conn scott
Enter password:
Connected.


以scott用户登录,可以正常使用了。开始享受中^_^