读书人

dbca silent 创设数据库 修改密码

发布时间: 2012-08-15 16:57:17 作者: rapoo

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文件里进行参数设置,后来不知道默认密码,于是就给它重新设置密码

读书人网 >其他数据库

热点推荐