|
|
admin
发表于 2014-7-20 12:28:10
Solution. u# x# x* ]2 q$ o$ ]/ t- e% P
' k4 D4 N. P3 H" `- YThis is due to the Oracle Password having expired and needs to be reset.
% H7 t$ |# ~4 g5 u# B7 r- M
' G. E. X% x2 xPerform the following in a OS CMD window making the necessary changes for your0 v0 u" e: z, W
environment and directory structure.1 W2 ]0 _4 c$ K) N, V4 D4 A
' F* ^% E8 }& R--5 l# F6 b7 K9 s$ g. w3 ?# M: u0 u
set oracle_home=C:\Oracle\product\11.2.0\dbhome_1
7 h" |) a+ M: R" p5 o7 S0 n
1 F" K3 T. N% |% e d7 z% [set oracle_sid=tc
. O. q2 ^. ^: d. ]( }" ~7 G8 z, U2 M3 U M: o' l2 R# p) E: Q
%oracle_home%\bin\sqlplus /nolog! ]- y$ v# a6 f" f/ O
8 v2 q, ? e4 X2 X& ^4 `
connect / as sysdba
. H4 A K/ ]9 L( }$ t5 e; X! w+ J L' ]7 r* _: K
alter user infodba identified by infodba;6 S4 o. R8 x$ V4 Z
; Z1 t4 q! S9 @ V. B
select expiry_date from dba_users where username='INFODBA';
% c% ~) r9 t$ k# s8 ?
8 @2 `# x# \6 f/ Aselect profile from dba_users where username='INFODBA';
1 [4 P# d& b( x9 S4 T4 X6 p+ Y# ?4 a7 l: E
alter profile default limit password_life_time unlimited;' H# f/ Z7 ]. d- i
; C8 U. H& W( Z/ a6 A* pselect expiry_date from dba_users where username='INFODBA';/ s; J& f" a/ _" t0 V* a
--7 Z+ y5 m8 t0 |) R; E5 T6 |: B+ W
% Z: j: {5 l+ \4 M+ i* u
Expected output in command window.
, R% M- k! L y6 s) y# i5 d==9 y j4 @; k+ u- h* p% ]
C:\Users\<user id>>set oracle_home=C:\Oracle\product\11.2.0\dbhome_1
" {/ P& i6 t* h5 H1 H5 O" |( K: p" o5 o6 Q
C:\Users\<user id>>
" o: k" F3 P, ?# A: A# VC:\Users\<user id>>set oracle_sid=tc/ c! t9 Z5 y; F2 q0 i
" R0 _$ z# {( e1 i
C:\Users\<user id>>5 B# X. R9 `1 A: m
C:\Users\<user id>>%oracle_home%\bin\sqlplus /nolog0 T6 o2 o- o' o3 ]: G$ K* m: x
5 C' V' S5 q; a& `+ B
SQL*Plus: Release 11.2.0.1.0 Production on Tue Dec 3 17:25:43 2013
' m& w; K* |) J4 ~- a v2 J$ F/ n% {+ c4 o# ?( A
Copyright (c) 1982, 2010, Oracle. All rights reserved.! j- E/ a' X6 D! [2 I
7 h- ]5 \0 ^6 `# f' y4 }SQL>% e' ?* v1 e) ]; M+ ~& r& R
SQL> connect / as sysdba. C0 G; ?, z1 T( u" G u9 P$ _
Connected.
+ B2 L. C; R$ N. A& ZSQL>& Q5 i) }1 y7 [) ^
SQL> alter user infodba identified by infodba;9 [4 x$ o+ v; u: u. }: F7 m$ n
5 ~( [! y% D' w7 K% h
User altered.* A# V4 C, ]* S- r. W5 c' {8 w" ?
$ J1 L" u( i0 Y: h3 D. PSQL>& t+ h3 O& @$ Q4 S% O( n1 `
SQL> select expiry_date from dba_users where username='INFODBA';, M/ u5 w/ I- X0 k/ T
, r; I3 C8 w) _) d8 @EXPIRY_DA
9 D# L) Q) W1 H% X8 v1 O---------; A6 ~9 B0 }* ]6 n2 k6 v
01-JUN-14% I3 X: u. ?# f, s
8 l1 A4 n; w" |( W. i( M
SQL>( K9 p2 F: }; P) o2 |& M) a( H
SQL> select profile from dba_users where username='INFODBA';
/ Y. q. G- i; S! V9 o/ M& Z
' A# A; o7 k5 V4 {1 y# `PROFILE0 L- x+ J# H& @$ ?
------------------------------
4 ^7 \$ K! Z! W. s- e/ L4 B: z I6 u9 tDEFAULT
4 \8 J3 R! E4 {; u* _- t
: r' x! y) X2 z+ a. ?SQL>
, Q# T; s+ \9 k9 OSQL> alter profile default limit password_life_time unlimited;
; U R; B4 m0 H/ F6 u5 X
3 o0 h: r2 d4 d4 ~0 U |Profile altered.
|+ F M: u% g8 N9 Z
7 B6 X. s7 i* ]( ~5 B2 YSQL>1 Y( @5 a' V- J |8 I" Q/ t) S; L
SQL> select expiry_date from dba_users where username='INFODBA';
2 y, y6 Y0 a9 B. ]) X# X) |. G3 H$ s
9 [$ V3 J2 G7 Y0 g1 _* kEXPIRY_DA/ r" O( T9 t4 h$ T
---------
7 h3 \! }$ t- d" d5 Q. H# M% v2 O% N- u5 O) V: b; n4 i$ [+ ^5 ?
SQL>
0 W) c# W1 O. ]# a) g. s9 \7 A6 jSQL># n+ _$ W1 ^* l7 A. f0 u
# U7 K3 y& i* ^% x9 c, O0 N2 e# Y; X0 X" Z
|
|
[复制链接]
|小黑屋|PLM之家-专注工业软件生态建设，大模型CAD创新生态
( 沪ICP备2026005248号-1 )
