日期:2014-05-16  浏览次数:20467 次

dbca silent 创建数据库 修改密码
racle@hadoop-hhu:~/soft/10g_db/database$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.1.0 - Production on Mon Feb 28 20:48:33 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,password from dba_users;

USERNAME        PASSWORD
------------------------------ ------------------------------
SYS        D4C5016086B2DC6A
SYSTEM        D4DF7931AB130E37
OUTLN        4A3BA55E08595C81
MGMT_VIEW        4F538DF5F344F348
MDSYS        72979A94BAD2AF80
ORDSYS        7EFA02EC7EA6B86F
CTXSYS        71E687F036AD56E5
ANONYMOUS        anonymous
EXFSYS        66F4EF5650C20355
DMSYS        BFBA5A553FD9E28A
DBSNMP        E066D214D5421CCC

USERNAME        PASSWORD
------------------------------ ------------------------------
WMSYS        7C9BA362F8314299
SYSMAN        447B729161192C24
XDB        88D8364765FCE6AF
ORDPLUGINS        88A2B2C183431F00
SI_INFORMTN_SCHEMA        84B8CBCA4D477FA3
OLAPSYS        3FB8EF9DB538647C
MDDATA        DF02A496267DEE66
DIP        CE4A36B8E06CA59C
SCOTT        F894844C34402B67
TSMSYS        3DF26A8B17D0F29F

21 rows selected.

SQL> alter user system identified by hhu;

User altered.

SQL> alter user sys identified by hhu;

User altered.


刚开始没有在hhudbca.rsp文件里进行参数设置,后来不知道默认密码,于是就给它重新设置密码