|
|
admin
发表于 2014-7-20 12:28:10
Solution
% y, I7 K6 ~2 A9 J. U0 R: H
& I8 N, N; A6 G/ H+ n$ HThis is due to the Oracle Password having expired and needs to be reset.+ v3 N. C6 Z# A' y" l
$ a1 K* @- o4 w+ l. `8 |% A0 L$ }Perform the following in a OS CMD window making the necessary changes for your2 d% B- i c. M: L% N2 e1 `- p0 X
environment and directory structure.
W* I8 G3 W& e4 X) Q q# E; `0 W0 r# @* r/ Y
--
, w% ~ h: j# D! E' A/ a4 v0 uset oracle_home=C:\Oracle\product\11.2.0\dbhome_1
' C" z$ b% [5 q( i* u4 _' Q7 p- H- j3 |1 ~' H, @4 ^# v9 w* X1 h
set oracle_sid=tc5 t& F$ S& y( T6 \9 i
6 C& \7 r. ^( i' v%oracle_home%\bin\sqlplus /nolog
% ]& T+ Y9 _& T. a, z* }0 E/ H3 P
1 }( M. w, }. y0 c4 E/ ?. yconnect / as sysdba. \. D/ j! {5 ^) ~7 o5 U
6 e; p _2 ^. e7 oalter user infodba identified by infodba;
. D9 \. i9 ]( f* _% d* ^* O- e7 c! j$ j
select expiry_date from dba_users where username='INFODBA';
( h/ X7 q ?! C; P
% r* h: M& w# E) N% k* k0 Iselect profile from dba_users where username='INFODBA';
/ ^, F) b# T: `) z, ^4 A* T, B7 z+ w! i( D! c; j
alter profile default limit password_life_time unlimited;
9 y( y, [# |+ k e! x" ]: v* ^2 f/ W6 G7 m$ O H% V' O7 T8 P
select expiry_date from dba_users where username='INFODBA';5 c0 Y6 k' g$ [5 {9 ^/ s% k, y" J
--% }( _3 S" n& q, z
% y8 F# a* J! k# j" WExpected output in command window.
, n, Y$ D/ \2 F/ ^==( V/ O+ E% b$ v/ J
C:\Users\<user id>>set oracle_home=C:\Oracle\product\11.2.0\dbhome_1) ^$ V6 p7 a( \( x, J6 H
K& n" s3 b4 j: W9 EC:\Users\<user id>>
5 g" Y# I! V" tC:\Users\<user id>>set oracle_sid=tc
$ g8 g. G* I' R: Z% {7 ^- K* ?% I9 U" }
C:\Users\<user id>>
+ x) d7 Z% n0 Z( [$ ?4 JC:\Users\<user id>>%oracle_home%\bin\sqlplus /nolog
% ?, m7 s/ [. E: z0 V8 C3 H5 G
% d8 G3 x) B4 b; eSQL*Plus: Release 11.2.0.1.0 Production on Tue Dec 3 17:25:43 2013. V/ C! D E3 }+ _4 e( `& L- F
: o5 G/ V/ h3 }+ E g$ S
Copyright (c) 1982, 2010, Oracle. All rights reserved.+ F+ K9 w: ~! Z) ]+ b! ^) S; F
& w5 A% i$ L0 Y# m) wSQL>
' I5 C* g3 Q I8 D7 `7 cSQL> connect / as sysdba
: D* H5 w; J$ Z4 z) LConnected.. b/ r: V( r6 @- U
SQL>$ ] I2 z9 b8 \
SQL> alter user infodba identified by infodba;: v o( J6 ]* _4 K' S* I
! r' Z6 a0 f6 W( |User altered.
/ X& e" H8 u, {( H0 o# z
' g2 d0 E& V2 S% _2 kSQL>
( o' o4 z+ `5 P% S1 A) E6 m4 {SQL> select expiry_date from dba_users where username='INFODBA';' E6 h' j, N7 m7 |: C
7 Q }% ^7 V s' {8 ~7 MEXPIRY_DA
7 {5 k: @' Y, Q: d- X---------
# A3 g3 d: U* k7 e ^' H3 l/ B01-JUN-14
4 o" D3 | p$ f$ M8 G$ p8 ^9 u- u3 B$ q$ ^4 }2 n
SQL>3 _/ B: E3 V7 q5 ?
SQL> select profile from dba_users where username='INFODBA';3 V3 i. L/ _: r, F+ l t
5 l8 Q8 H: Q, k! P0 TPROFILE
; C+ i' s) ~4 O5 P! O------------------------------' i H: {$ O4 ?0 V$ P
DEFAULT
" o3 n3 M% j; N2 G3 ^$ o; n- c) u6 q% w& |
SQL>8 o4 w" m, [) B7 B
SQL> alter profile default limit password_life_time unlimited;
9 r$ `; H/ Q( Y5 a3 b4 ~+ `- \9 H8 e/ Q9 z
Profile altered.
5 v1 T" l$ {" I
6 b. O) Z" @/ Q- Z$ USQL>
9 O! ~( K" l/ MSQL> select expiry_date from dba_users where username='INFODBA';
6 B, s( P! ~6 m+ ]/ V! u( _
, y2 ] B7 S7 k5 G4 r/ |6 z9 {) D5 WEXPIRY_DA7 w6 Q; n2 G& K. \- \' _
---------
% h7 N, P C) a1 h
+ }2 v& B5 C$ \2 b; ^3 ]% A4 zSQL>0 V8 i* \1 B' j3 R9 H: ?( I
SQL>3 O; ]: L% D: h) T3 X
: k0 i4 i" O( r4 J8 w
$ j0 _" K3 B, ~" z) o
|
|
[复制链接]
|小黑屋|手机版|PLM之家-企业数智化转型工业软件学习平台
