修改oracle密碼
sqlplus /nolog
SQL> conn /as sysdba
已連接。
SQL> alter user system identified by password;
oracle提供兩種驗證方式，一種是OS驗證，另一種密碼檔驗證方式，如果是第一種方式用以下方法修改密碼：
sqlplus /nolog;
connect / as sysdba
alter user sys identified by ;
alter user system identified by ;
如果是第二種方法用以下方法修改密碼：
orapwd file=pwdxxx.ora password=你設定的新密碼 entries=10
設定完後，重新開機服務，再次登陸就可以了。
-----------------------------------------------------
1.設置sqlnet.ora檔中的SQLNET.AUTHENTICATION_SERVICES= (NTS)
把在這行前面加"#"注釋去掉即可
2.以sysdba許可權，連接到資料庫
[oracle@as4forora ~]$ sqlplus / as sysdba
SQL*Plus: Release 10.2.0.1.0 - Production on Wed Jul 16 21:48:18 2008
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
3.更改sys及system密碼
SQL> alter user sys identified by wu1982$;
User altered.
SQL> alter user system identified by bo1982#;
User altered.
查看：
SQL> select username,password from dba_users;
USERNAME PASSWORD
------------------------------ ------------------------------
MGMT_VIEW 3E73C05C2FD51FAC
SYS 30EA3B9ED52E9B8E
SYSTEM B1F508A08B495071
DBSNMP DDF477F4A91DB26D
SYSMAN C485C2BEE2DBEB78
OUTLN 4A3BA55E08595C81
MDSYS 72979A94BAD2AF80
ORDSYS 7EFA02EC7EA6B86F
CTXSYS 71E687F036AD56E5
ANONYMOUS anonymous
EXFSYS 66F4EF5650C20355
USERNAME PASSWORD
------------------------------ ------------------------------
DMSYS BFBA5A553FD9E28A
WMSYS 7C9BA362F8314299
XDB 88D8364765FCE6AF
ORDPLUGINS 88A2B2C183431F00
SI_INFORMTN_SCHEMA 84B8CBCA4D477FA3
OLAPSYS 3FB8EF9DB538647C
MDDATA DF02A496267DEE66
DIP CE4A36B8E06CA59C
TSMSYS 3DF26A8B17D0F29F
20 rows selected.
SQL> alter user system identified by oracle;
User altered.
SQL> alter user system account unlock;
User altered.
SQL> select username,password from dba_users;
USERNAME PASSWORD
------------------------------ ------------------------------
MGMT_VIEW 3E73C05C2FD51FAC
SYS 30EA3B9ED52E9B8E
SYSTEM 2D594E86F93B17A1
DBSNMP DDF477F4A91DB26D
SYSMAN C485C2BEE2DBEB78
OUTLN 4A3BA55E08595C81
MDSYS 72979A94BAD2AF80
ORDSYS 7EFA02EC7EA6B86F
CTXSYS 71E687F036AD56E5
ANONYMOUS anonymous
EXFSYS 66F4EF5650C20355
USERNAME PASSWORD
------------------------------ ------------------------------
DMSYS BFBA5A553FD9E28A
WMSYS 7C9BA362F8314299
XDB 88D8364765FCE6AF
ORDPLUGINS 88A2B2C183431F00
SI_INFORMTN_SCHEMA 84B8CBCA4D477FA3
OLAPSYS 3FB8EF9DB538647C
MDDATA DF02A496267DEE66
DIP CE4A36B8E06CA59C
TSMSYS 3DF26A8B17D0F29F
20 rows selected.
SQL> connect system/oracle
Connected.
SQL>
//還原system密碼;
SQL> alter user system identified by values 'B1F508A08B495071';
User altered.
SQL> alter user system account unlock;
User altered.
SQL> connect system/linlong;
Connected.
SQL>
$ orapwd file=$ORACLE_HOME/dbs/orapwtech password=oracle entries=5 force=y
$ sqlplus /nolog
SQL*Plus: Release 10.2.0.2.0 - Production on Mon Sep 21 14:35:27 2009
Copyright (c) 1982, 2005, Oracle. All Rights Reserved.
SQL> connect sys/oracle as sysdba;
Connected.
文章轉載http://fecbob.pixnet.net/blog/post/38072467-%E4%BF%AE%E6%94%B9oracle%E5%AF%86%E7%A2%BC
留言列表
