|
|
admin
发表于 2014-7-20 12:28:10
Solution' V1 S# y8 h9 X
: n |/ A( O! ]* dThis is due to the Oracle Password having expired and needs to be reset.
0 \: H4 n* @. u5 I& Q
8 o0 y8 G& p) T3 ?' bPerform the following in a OS CMD window making the necessary changes for your; z9 m T; n. k. T0 F* J3 H
environment and directory structure." L6 L3 _7 a0 h9 s( `! h( o& [6 p
- C- i3 G5 y4 k5 t0 i0 ]--
7 h+ J5 t/ @% s" N1 S! \' }; uset oracle_home=C:\Oracle\product\11.2.0\dbhome_1+ @+ o* @# p0 H6 O
# K0 ?& c) O6 B; B/ ]. N3 Y7 F* ~set oracle_sid=tc
0 O' |( t6 ~6 w1 X+ E/ t/ M+ j1 b, A3 u& C
%oracle_home%\bin\sqlplus /nolog
6 J7 x0 O) u4 s7 h: h) C4 X! _0 m( R) h ]. ~) R
connect / as sysdba
/ G2 B5 q/ ?! i% j; G
; u% ?9 H4 h' o" }8 k X$ Galter user infodba identified by infodba;
8 b/ ]2 r' S3 m7 l2 {/ C6 J% i( P* H
select expiry_date from dba_users where username='INFODBA';2 e( N: C; r; n
" s/ x9 g: Z, Q7 N6 @7 G( o& l, `5 {select profile from dba_users where username='INFODBA';
* F: K4 ?; D- g& k, b* u: Z* o) g+ ], Q5 y l- j$ L" Q
alter profile default limit password_life_time unlimited;
; H5 I9 x& C3 Z+ ]# ?. O; [9 }+ d1 [# w3 n+ [3 f
select expiry_date from dba_users where username='INFODBA';( M& W; u2 ?* L* w
--+ ]8 ~! ?! d. F# k- J# S, {/ U" j
: s$ Y# [/ h& f/ [% K8 A2 E r8 WExpected output in command window.
, r; ^ y' T4 f: s==: U) {" @/ ^8 m6 O
C:\Users\<user id>>set oracle_home=C:\Oracle\product\11.2.0\dbhome_1# V0 P' `4 y( W4 k; L" a
% \. r$ a# e* V" T
C:\Users\<user id>>) o3 Z. z r/ z3 P8 S4 ]" q# h( ?
C:\Users\<user id>>set oracle_sid=tc
2 u8 d F b) z3 X! V5 J) D) c G1 P/ O
C:\Users\<user id>>
v. J, @$ H2 a% f# FC:\Users\<user id>>%oracle_home%\bin\sqlplus /nolog
1 r7 q8 a7 R5 H0 ~' s8 f2 ]7 U% ?8 }. S* Y
SQL*Plus: Release 11.2.0.1.0 Production on Tue Dec 3 17:25:43 2013' Q# i6 b0 V9 Z% H3 x; C
. O7 Y6 ~9 Q7 ACopyright (c) 1982, 2010, Oracle. All rights reserved. O; l% `6 |4 @! _# j
* U; T# g( b: Z3 v" ?, |/ |
SQL>
8 h: m, m5 e! OSQL> connect / as sysdba4 p3 j, e/ H; c0 o
Connected.
d1 R3 `3 \& G$ K8 G2 w! _SQL>% j5 M1 c% s! d, m2 P: i& c5 a
SQL> alter user infodba identified by infodba;
- E% E7 K5 N+ u, Z- Q) e* J0 ?& s8 q7 T
User altered.3 R# d- s# d4 w0 A6 y% ^
) k$ N* K4 C* BSQL>1 B) k* q% B3 c+ Q8 a
SQL> select expiry_date from dba_users where username='INFODBA';
6 K4 s" s" }( I$ Q" X( \& h6 R
/ X3 d% ~4 p. v- VEXPIRY_DA
. u4 A! }8 b! b---------
; M/ b9 W0 j, p8 X( f01-JUN-14 ~! y7 N6 n- l' W/ T
7 _# Z2 B+ |) B. M- B1 k* l. rSQL>
) ]+ }3 y/ q& c/ D+ gSQL> select profile from dba_users where username='INFODBA';
3 @: }" Z" ~6 _# {3 s/ F/ V ]" |/ L" J" f5 _
PROFILE" O# L+ U5 t r+ l
------------------------------
m9 ^% d/ P% [) s) Y1 d% W! EDEFAULT0 U/ n/ Q+ v; Q
6 ~5 y& o4 b$ r, W
SQL>+ p1 k" w/ L( r# O) K
SQL> alter profile default limit password_life_time unlimited;
! Y% h! q X" S" q
( H/ `2 P; ^. T+ jProfile altered.
3 [ W( @+ k+ @- a# n! q) Y% k3 s% T( |% c8 E( V& k# G
SQL>
- \# S. H0 W* d5 V+ gSQL> select expiry_date from dba_users where username='INFODBA'; k! g7 M% w5 B5 ?5 t* z* x
2 m$ [: L0 [4 Y: l8 P% i4 q# n* i1 r9 D# C
EXPIRY_DA2 P4 J8 ?4 i G) \
---------
% B% C( |' Y3 }* Y9 r1 t- |. Q7 O3 J" Z+ i' F! {9 v8 v
SQL>, s- `4 @6 c, r( X( l1 q* z
SQL>7 }1 p# x t! q
+ @3 Z. l' X; v, k X' v2 x" v0 @
|
|
[复制链接]
|小黑屋|手机版|PLM之家-企业数智化转型工业软件学习平台
