安装完oracle密码,安装好Oracle后，发现sys账号进不去，可能是密码没有设置

[oracle@localhost ~]$ echo $ORACLE_HOME

/opt/oracle/app/oracle/product/10.2.0/db_1

[oracle@localhost ~]$ sqlplus /nolog

SQL*Plus: Release 10.2.0.1.0 - Production on Thu Sep 20 15:12:57 2012

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

SQL> conn /as sysdba

Connected.

SQL> select * from all_users;

USERNAME                          USER_ID CREATED

------------------------------ ---------- ---------

BI                                     60 17-SEP-12

PM                                     59 17-SEP-12

SH                                     58 17-SEP-12

IX                                     57 17-SEP-12

OE                                     56 17-SEP-12

HR                                     55 17-SEP-12

SCOTT                                  54 30-JUN-05

MGMT_VIEW                              53 30-JUN-05

MDDATA                                 50 30-JUN-05

SYSMAN                                 51 30-JUN-05

MDSYS                                  46 30-JUN-05

USERNAME                          USER_ID CREATED

------------------------------ ---------- ---------

SI_INFORMTN_SCHEMA                     45 30-JUN-05

ORDPLUGINS                             44 30-JUN-05

ORDSYS                                 43 30-JUN-05

OLAPSYS                                47 30-JUN-05

ANONYMOUS                              39 30-JUN-05

XDB                                    38 30-JUN-05

CTXSYS                                 36 30-JUN-05

EXFSYS                                 34 30-JUN-05

WMSYS                                  25 30-JUN-05

DBSNMP                                 24 30-JUN-05

TSMSYS                                 21 30-JUN-05

USERNAME                          USER_ID CREATED

------------------------------ ---------- ---------

DMSYS                                  35 30-JUN-05

DIP                                    19 30-JUN-05

OUTLN                                  11 30-JUN-05

SYSTEM                                  5 30-JUN-05

SYS                                     0 30-JUN-05

EMSYLY                                 61 17-SEP-12

28 rows selected.

SQL> alter user sys identified by system;

User altered.

SQL> commit;

Commit complete.

SQL>

阅读(4072) | 评论(0) | 转发(0) |