|
|
admin
发表于 2014-7-20 12:28:10
Solution1 C# J* ?6 B& w+ i
! I& K' n) F: t. S) L' QThis is due to the Oracle Password having expired and needs to be reset.
* {) X. @2 q0 h$ R r+ y8 \: a
6 x- O5 p: r; q {# P! @) TPerform the following in a OS CMD window making the necessary changes for your B$ z* |) K( b
environment and directory structure.
% x: Q* [4 v& w2 \5 w
: M/ F: M; N% s7 u--# o P1 i# N& L- _1 X
set oracle_home=C:\Oracle\product\11.2.0\dbhome_1
! g% ^, ?% l: s& @5 w
" a: L( D+ m( e( U3 ]) cset oracle_sid=tc/ [' r4 H) Q) Z1 I; b
9 A$ Y6 R* g: |( A9 P1 l- K O
%oracle_home%\bin\sqlplus /nolog
7 \2 P9 {3 X% _ e! a2 j0 h
6 m/ h1 T$ Q1 F* T |0 p) k! I$ }connect / as sysdba. _8 X B9 f: Y g6 v# z
( l% T; W; E8 b0 Y, A) R1 ]8 qalter user infodba identified by infodba;
8 G) i1 }( `" M/ q2 ?9 K
' F; }! a! y/ w' l0 z& L& L; `select expiry_date from dba_users where username='INFODBA';
6 X+ R, o% U1 x \3 v7 }6 ^% H9 U/ x
select profile from dba_users where username='INFODBA';( Y, [1 S: g' x7 s
- d/ i* h; ~; [9 ~9 v9 L
alter profile default limit password_life_time unlimited;
4 w6 U8 w" V- F5 I6 m( w& V! m* F$ n: k
select expiry_date from dba_users where username='INFODBA';. s7 s2 ?2 X* W
--, h( o, @2 ]% V
6 O; [, R) H- w; T
Expected output in command window.
; a4 {- {! J+ O# O==1 n5 p! C0 |5 L, A& M) R% n
C:\Users\<user id>>set oracle_home=C:\Oracle\product\11.2.0\dbhome_1& \5 E0 X( J d
( D. ~( O! @3 u' E' l5 }$ c
C:\Users\<user id>>( A& Q: j* H. s$ x! ~0 Z/ J
C:\Users\<user id>>set oracle_sid=tc
% H6 s* E7 O9 n# d0 z" f# h$ W
; w( J( W" u6 UC:\Users\<user id>>
5 F+ M1 {7 Q& d0 g+ |: k( PC:\Users\<user id>>%oracle_home%\bin\sqlplus /nolog
* x- }. U4 ?& |9 g; s7 C
/ G! T, b7 P) X. G9 v7 U5 YSQL*Plus: Release 11.2.0.1.0 Production on Tue Dec 3 17:25:43 2013
) r$ ~# p! \ o7 G+ u8 |! M8 `, v2 w2 w
4 C, m/ g9 |' U! G) O S8 zCopyright (c) 1982, 2010, Oracle. All rights reserved.* h) j2 B8 p& B. @ N1 {% r4 ^4 E: R
. i! L+ e. M, }& DSQL>
5 {# z; j. N0 c6 G: g0 tSQL> connect / as sysdba
) e% R( K* }/ \6 {Connected.
7 M$ k- Q' q+ ~5 ?, `% hSQL> @0 d" \* I6 E. p% D/ x" f
SQL> alter user infodba identified by infodba;
* L$ f% o* [2 K/ t+ h* g1 Y* Z& ^4 g7 S9 T5 f
User altered., L9 p& }) N( o$ [ l( w k
+ c4 A( y& a" z; P6 O# ^+ bSQL>
: Q& q$ O& ]2 v1 C( p2 PSQL> select expiry_date from dba_users where username='INFODBA';
* g/ a0 {( R0 M( r1 ]2 B- ?3 F' V2 U4 W
; \& J' M' h. N. p BEXPIRY_DA
7 ^7 Y; I+ K( E---------7 g5 R* Z S o% g I- Y
01-JUN-14
3 v% h5 A- z/ X$ R' X T/ J0 V: x+ T$ z; h ]
SQL>% v5 z* ]' B" N7 Q6 V
SQL> select profile from dba_users where username='INFODBA';
/ V; j1 u) y$ h" r" i5 r, p' i
- Y0 q% e+ l# N s+ h7 Q: a7 JPROFILE
& M1 I8 ]( }8 c u------------------------------
, K7 V6 {* I/ j! Y1 u0 T& m5 _0 fDEFAULT
) n; Z J! q- m# @( |# Y- w2 D& Q2 j) K# h n4 q
SQL>' C& ?% [7 e- J0 p
SQL> alter profile default limit password_life_time unlimited;
' N; H1 ?4 K: m& Y5 e
, z( p8 [4 ~! S) h) A% gProfile altered.0 m3 [* m* Y2 Z9 l
- }0 V2 r" _5 _5 |! G# A2 i% M
SQL>
& c5 F, u( O5 g! H0 Y! P8 ]SQL> select expiry_date from dba_users where username='INFODBA';% L. Q" I. ~. {, M3 E& r
! U! @. ~& @" J
EXPIRY_DA
$ A; C/ V: u3 x8 y& o5 ` \---------9 ]& W1 f, r: ^2 c2 o
4 m Q; p8 I! n) Y
SQL>
- ~- c+ H N9 W; c+ T* O" PSQL>
7 ?) d+ ~1 n$ @2 `7 E. Q% Z5 ^2 X4 P" F8 z( I& K6 k
( z9 i5 q u9 _" d7 S4 K1 \
|
|
[复制链接]
|小黑屋|手机版|PLM之家-专注工业软件生态建设，大模型CAD创新生态
