|
|
楼主 |
发表于 2014-7-20 12:28:10
|
显示全部楼层
Solution% j* e5 W6 C' j; R( `* |4 e6 \* p
9 S* X p7 M( g7 M$ y- v" S; k9 [This is due to the Oracle Password having expired and needs to be reset.: P: h! @' `* C( i! Q1 w2 r& ~
0 S7 Z. Q) s5 ~7 t5 hPerform the following in a OS CMD window making the necessary changes for your
* g5 x6 D. y6 aenvironment and directory structure.1 v, s/ r1 m) Q; i* H+ F
& E7 j+ C! d) H5 K9 M--
" h. e; g: z# W/ J8 e, ~* ?set oracle_home=C:\Oracle\product\11.2.0\dbhome_1$ P" G; [1 f( d5 ~+ D1 ]) t
! B4 k1 q& Q8 D+ Q a7 c8 b6 j0 Q. _" c( _set oracle_sid=tc6 q" P/ { i( d9 B
d% u$ |8 ^: U& |+ B7 L3 v
%oracle_home%\bin\sqlplus /nolog
/ {0 m2 M: x+ g% m, `* L
* ^0 w: ?; `$ Z/ w9 lconnect / as sysdba, L2 H9 ?' Y/ J' ]) [* e4 K
& m& k, D+ }& u; Dalter user infodba identified by infodba;, O: h& Y; Z6 _; G: T2 T
- A3 d" Q# A# J. y7 mselect expiry_date from dba_users where username='INFODBA';
0 m# R' X1 T; z: Y% @2 P, t+ Z+ H$ v0 ]3 |
select profile from dba_users where username='INFODBA';
# s$ t3 x% M: m0 Q
0 ]0 Z7 w8 Z( C5 @alter profile default limit password_life_time unlimited;
5 N& x; v* I- a6 T8 X' B
) h+ ~' u, o. ~- B! eselect expiry_date from dba_users where username='INFODBA';
3 W9 j. D. B' x0 R$ [- Z--' ~) m4 P. `: P6 b% c( l9 \. p
& Q/ j# I( w; [" B3 T2 U
Expected output in command window.: C4 z- w' S& U0 G7 [7 `
==
- s3 F6 h* a# j# ` i+ p: A* TC:\Users\<user id>>set oracle_home=C:\Oracle\product\11.2.0\dbhome_1
& G2 i5 ]+ F: D+ m# Y' t9 ?" O! H9 P+ i# h( u
C:\Users\<user id>>
! D; U$ A L* Z( ~C:\Users\<user id>>set oracle_sid=tc
5 }- O; z; n, l/ v' O. ~; ?
) @1 M. r7 Y: j( f1 F4 D7 Z3 MC:\Users\<user id>>
+ |* @+ [6 n7 \& ^) F9 B& |) M3 kC:\Users\<user id>>%oracle_home%\bin\sqlplus /nolog' ~1 f. U: Q4 R" V5 b( f
1 [; Y' D8 n1 Q& |* `6 n- ]SQL*Plus: Release 11.2.0.1.0 Production on Tue Dec 3 17:25:43 2013) P& p; d* K# `* A M
6 s- y/ Y. Z9 E! ^/ {# a- F! QCopyright (c) 1982, 2010, Oracle. All rights reserved.
8 a2 T9 L \0 g. w" r
+ u, s7 A' L% w9 d- _& \SQL>
2 W2 I. t2 ?% |2 H+ PSQL> connect / as sysdba
# S! V! E% K2 e- T5 uConnected.
( B' n& e1 h, p8 USQL>
; v5 ~9 c; A0 I$ s% ESQL> alter user infodba identified by infodba;- {- N" P4 }! V5 Y* C: s
- M4 j; ^1 n7 z ?
User altered.
1 k* T$ k7 e5 H
0 U/ g- L9 s2 ~# F1 b5 d# R7 m0 FSQL>3 |9 U- m! U/ E0 c0 G3 I
SQL> select expiry_date from dba_users where username='INFODBA';
+ T4 q; y6 d* U, F d9 }1 z5 e: d$ t" v
EXPIRY_DA5 Y) Z/ O1 l. j# E% e
---------
& S- E+ s8 S v* Z5 k) G1 A" A01-JUN-14% J# Z! L/ x3 [% p5 @8 y
0 b! G" J( T! V6 @SQL>
1 t9 a: Z1 N; ZSQL> select profile from dba_users where username='INFODBA';
i0 X& \5 i1 ^) J6 V
$ T) ~# t3 L: W! CPROFILE
$ \3 i: h) M5 n- x; z. \------------------------------
$ H( E. n$ W7 Y3 C9 l! }; xDEFAULT
7 Q5 R0 c4 o h
3 x; F5 F% [( Q S( r* jSQL>
0 {) a/ t( x2 b$ D: _4 jSQL> alter profile default limit password_life_time unlimited;
) Z: b/ B) p4 [+ ]) r; [4 O: |$ |0 ~# q z# z; m
Profile altered., @" s- `. `2 u' J4 W$ ^4 N# q; ]) x
5 m7 \) v! m; b$ ~) T. l) K" R
SQL>
$ h) x& n/ V5 I3 r, y( ISQL> select expiry_date from dba_users where username='INFODBA';7 b! R+ O4 x" x3 [9 a8 a
9 x- J: k7 o, G) Y
EXPIRY_DA' |/ w9 l* t4 R) K- x
---------7 d( V. @; N0 e" U( K
; B- e; J- k# a" J: s
SQL>
( v6 |/ F: D: s# v& GSQL>5 `' i8 Y, [& i* N& z+ L- F+ F+ k
# U2 O5 }' f' X D X+ Y6 a
/ S. G, }: z* y8 H& @
|
|
发表于 2014-7-20 12:27:14
发表于 2014-12-8 11:04:41
