|
|
admin
发表于 2014-7-20 12:28:10
Solution$ M0 b# a& o. U
. N5 q5 w6 T S# `$ s& p5 S
This is due to the Oracle Password having expired and needs to be reset.
' M: V2 Y+ T6 _5 X+ y
! I; ]9 D! I, H1 [Perform the following in a OS CMD window making the necessary changes for your9 R! e9 i7 [- E+ V E
environment and directory structure.& n e' N0 E( {$ o2 e
4 X$ R5 o+ S6 C--- X X' b8 s; ^+ y8 a7 }
set oracle_home=C:\Oracle\product\11.2.0\dbhome_1$ x/ s2 ]% u' ]- |( G# a
- [/ e: A& E m. aset oracle_sid=tc u9 ]) d' r; R& U2 j! y, D: ^& U
3 R1 d% @7 x* V" T8 Q%oracle_home%\bin\sqlplus /nolog
+ J; S1 m" W8 L/ m8 y: v$ y6 n: S- p5 B7 c& p0 d
connect / as sysdba
3 z) l9 I. L' M+ m* t% t. m* Z1 Q
! R- T+ X+ N; Ralter user infodba identified by infodba;5 z# }; L1 Z. [: y: |; ?( U$ |) E
2 J1 \! |3 u& J
select expiry_date from dba_users where username='INFODBA';: d( N) n& V7 E! y. F
( V6 X$ v1 a& j. @: q* v: l) h+ ? ~select profile from dba_users where username='INFODBA';
2 I6 J8 ^% x/ d1 v W" X$ J8 ~) S8 }6 O: Q) n, W; r
alter profile default limit password_life_time unlimited;6 b: t& c! o( ?7 P# L [8 u% g
% ^# M, P5 H' d+ i8 L: u
select expiry_date from dba_users where username='INFODBA';8 T/ z3 \& @) W
--/ c9 Q& X8 S F9 Y7 V
# y% b5 J7 ]/ s1 ]" n! R% n5 }) k* m
Expected output in command window.
4 k4 V k3 r' X& v- r9 x==) {4 t U3 L1 u; s
C:\Users\<user id>>set oracle_home=C:\Oracle\product\11.2.0\dbhome_16 i3 V& t8 b6 X7 _- ^
8 T+ `# }4 Q# Z7 W: ]3 K( rC:\Users\<user id>>
* n: o+ c0 d; H- r% m& SC:\Users\<user id>>set oracle_sid=tc) y2 g7 ?6 m0 I8 e) e- ^
% ?5 n v1 N( V6 g. u
C:\Users\<user id>>8 ^2 Q: a1 B" |# M
C:\Users\<user id>>%oracle_home%\bin\sqlplus /nolog3 o3 [: t9 ]2 j+ T- ?1 L, O7 @
3 O" Z0 T& c ]& F' u
SQL*Plus: Release 11.2.0.1.0 Production on Tue Dec 3 17:25:43 2013$ n2 j7 l7 s i
& b6 L6 Q( _" TCopyright (c) 1982, 2010, Oracle. All rights reserved.
/ \. s' z$ k3 y; \/ I9 \1 B
1 ^( [6 a5 M7 r2 RSQL>
; ^- _1 b; h- N2 `9 L# c% YSQL> connect / as sysdba/ G. s) }# B" f8 i
Connected. G! H1 C% t+ z' `3 q) h
SQL>4 i) f& K% a' W7 I* ^+ e
SQL> alter user infodba identified by infodba;
; G8 V4 ?8 }( X9 ^/ L0 }4 f! u" g$ a+ A9 {( w
User altered.
" r8 k p8 M0 w [; u
0 I2 y& U7 W! y- c& aSQL>
6 _% Z1 g9 e% u- L; w9 SSQL> select expiry_date from dba_users where username='INFODBA';
- \3 w* ?3 o$ l% |3 q% _6 ]
- B; i. q9 |& y- |, A/ {9 t$ e) ]EXPIRY_DA
: Q, ~; b/ L* E6 f---------- C2 H; q* ^) d) W6 A% y3 t
01-JUN-14
! c. N6 m3 R# ?, ]6 @% z& k* m; n. W
SQL>
7 E& a# Y( Y4 N' b3 FSQL> select profile from dba_users where username='INFODBA';
) V% L1 f1 P7 o Z
7 _% B! L* Q7 hPROFILE) h$ e: o$ K* G: u! @, i5 Z: w
------------------------------2 N8 m& E) f2 ~; T
DEFAULT
- M1 P# a( j! W6 Z, Y( _! }9 ?: V
' j A5 j9 y) Z4 _SQL>3 I4 }. c. n w' p. C( y7 v! ]( ]
SQL> alter profile default limit password_life_time unlimited;
0 Z$ v- e N9 \6 \" p& h0 e. M# o& O% r4 z
Profile altered.5 }5 m- n8 C" T3 s |' F. P& ^. e
8 l8 g& d2 O$ N' b' D2 ~/ ~SQL>" ^. _1 K% ^0 F+ J' ~: T
SQL> select expiry_date from dba_users where username='INFODBA';
: Q! C S% Q2 i& B' `7 f1 I. _
9 a, ~) @" h F* H% uEXPIRY_DA. I/ I6 S' u# h, G `' ^, x: ^% q
---------" u6 K" h, N2 K$ W7 m
5 c- ^ o8 o/ E/ q. X- JSQL>
! S6 Q4 S+ v& ]" t, t, e6 tSQL>
- T% W' U( v& j7 c/ L( ]2 p7 V- G8 l5 z1 ?0 `
. W: J2 X2 A: D+ n |
|
[复制链接]
|小黑屋|手机版|PLM之家-企业数智化转型工业软件学习平台
