|
|
admin
发表于 2014-7-20 12:28:10
Solution+ I4 W* b5 S7 m- O
9 q' B! W4 O- x# f3 M
This is due to the Oracle Password having expired and needs to be reset.
$ E+ C3 q& o0 d w2 A! F& a, n# _* C* w; D2 C1 z+ k h* `: f7 ~' m
Perform the following in a OS CMD window making the necessary changes for your5 O1 X& d4 ?& O- p! K3 j. m
environment and directory structure.0 S2 d2 `& h. g
# n$ |9 }- M: p7 t, Q, s: D+ n6 x--( w( n, U3 }" v G9 ]0 D
set oracle_home=C:\Oracle\product\11.2.0\dbhome_1$ H# [# _9 K' P; c! Y7 W5 A* H
* z( L5 T& E* Z$ w9 P! G
set oracle_sid=tc
/ M! _' o) ?0 w& B# K8 [. x2 i& F- W5 E& ~
%oracle_home%\bin\sqlplus /nolog. o7 K/ `. e- W1 @/ w o, g
# o( X- T7 s+ [connect / as sysdba
: V8 ~* m" W- u1 p" M4 B! n# Y+ p8 l& b9 G5 k
alter user infodba identified by infodba;; X% J7 q7 y) h, S
n& i) ?; B# L% R; ~6 m6 tselect expiry_date from dba_users where username='INFODBA';
' ]$ W, I% A- r9 D1 j3 f6 Z* K8 Q& W" N7 C/ U9 {% a
select profile from dba_users where username='INFODBA';
, y" p0 z* K8 k) }, f/ a! t3 @) C+ v7 d
alter profile default limit password_life_time unlimited;+ O8 z& s/ S& ~2 c
1 l9 v4 }9 J8 I! \. G/ I1 k7 c$ O+ aselect expiry_date from dba_users where username='INFODBA';
! m; L. l1 y5 r- h6 o# _--& ]6 H, E2 \, B: v# \' L! w; o
) u* z$ \0 e3 S4 A* h* [& AExpected output in command window.
6 t3 j0 u/ c9 z& H==
$ L" `' X+ d! _% ^C:\Users\<user id>>set oracle_home=C:\Oracle\product\11.2.0\dbhome_1
# T& Q" N$ a0 Y4 D2 j; _7 Y% t" T/ A3 `9 b3 s& q4 P
C:\Users\<user id>>
/ H" l) Z- V5 R$ VC:\Users\<user id>>set oracle_sid=tc
. A3 K. M2 J$ y/ Q. O/ X' S- R- E; O
C:\Users\<user id>>. L* m! V+ x. o t
C:\Users\<user id>>%oracle_home%\bin\sqlplus /nolog( \9 M( {" w$ S# _3 N
+ F! Z% B" k9 g/ u
SQL*Plus: Release 11.2.0.1.0 Production on Tue Dec 3 17:25:43 2013
, J1 h4 M, |( a5 C
( U: |; o0 ?/ S9 }- |$ nCopyright (c) 1982, 2010, Oracle. All rights reserved.# b. x8 N E. C
3 i+ a3 }; J1 w, X( d
SQL>" \; k8 b- R# D! W
SQL> connect / as sysdba- I: S( f( H% d' y: S# M4 P' [
Connected.7 J: T5 n# u" G0 `" c0 d( R
SQL>1 v# V& [6 }* Z$ D4 I4 V* h5 U
SQL> alter user infodba identified by infodba;, v. H4 C3 S3 p5 Z, l9 B' J/ p/ N
! U" c: }. M3 ^4 G
User altered.5 @9 ]3 N, T: Z
. F9 N( t/ n, Q1 e6 TSQL>% g# v6 D, q6 ^. F4 z* `% v0 p
SQL> select expiry_date from dba_users where username='INFODBA';
) b- _& a$ P0 W8 c' f" [5 |" B5 F5 Z4 M, s& @8 R
EXPIRY_DA
% F6 G' u9 K7 }3 q& S7 {---------- Y; ^8 e. f/ x/ l7 t% k5 [& [8 @9 Q
01-JUN-14# w% ]8 @8 g# X8 D
% B9 L- h- p$ ISQL>
$ q8 c' I* Z6 Y' b# g1 VSQL> select profile from dba_users where username='INFODBA';+ d, h7 V, j% I/ `. F! a( _
2 ^3 `3 d3 \: z' H- mPROFILE
; S: u" L5 L* @: t$ F F2 u$ O* v------------------------------
& Z8 T3 {2 N9 [3 UDEFAULT; E I- g8 H, e/ y! F* S6 U
4 z+ p; G% E2 ?; KSQL>* J; }8 E( g$ l' n
SQL> alter profile default limit password_life_time unlimited;9 Y+ l- t8 E* w2 O! @
5 z% N9 V' R I5 y
Profile altered.2 O% E3 D/ E4 z% n
' L! {3 }1 N. W+ j; }' P, X
SQL>+ B$ y) F2 Z: V
SQL> select expiry_date from dba_users where username='INFODBA';
. ~3 X4 H# V7 p6 u8 F# |; P0 n# c
EXPIRY_DA1 t% s6 B* y [4 Y; @+ T
---------; R3 i& b6 P# E3 C5 `3 t& p
3 `7 Q# k, t6 P& r+ CSQL>' x% E3 _* Q' V1 ^! I0 M: r5 n
SQL># G0 U& g2 _7 f2 |
c( D6 w( F5 [
: L" L" V/ J! c& z6 ?9 R |
|
[复制链接]
|小黑屋|手机版|PLM之家-企业数智化转型工业软件学习平台
