|
|
admin
发表于 2014-7-20 12:28:10
Solution) q0 \, k O( n0 }* I
5 B" W$ z: }/ n" R3 A- D
This is due to the Oracle Password having expired and needs to be reset.) z2 m3 l; }8 ]
1 P E4 K; Z, z$ RPerform the following in a OS CMD window making the necessary changes for your5 K* X) X$ ~* r5 n" J6 C, X8 E6 `
environment and directory structure.7 [- T) y; M0 i9 R0 e! Y$ z
- h& m% N$ I9 Y--
3 l- D0 r! n5 ~# iset oracle_home=C:\Oracle\product\11.2.0\dbhome_10 U- V* G- c& m7 C U9 s
" F9 t' Q7 ^+ g- k( H) ~. \. |# p; H' pset oracle_sid=tc
0 r2 e5 |1 Y/ C% t! g" o" g0 q$ r. G# }( ^# }. I4 \
%oracle_home%\bin\sqlplus /nolog
d$ Y2 u9 T6 W& z- w: R4 m- `* }7 l
connect / as sysdba* F) V6 N' k2 M$ L
" k" a5 _4 v. w- Q `/ palter user infodba identified by infodba;
: r- ?- I% x( f6 e4 H8 }
% [ x* f8 r) T5 ], B8 jselect expiry_date from dba_users where username='INFODBA';
$ \; p6 a, J- Q4 ?' U& r) x9 H: w3 r1 ]0 N( E% q2 t
select profile from dba_users where username='INFODBA';0 o" Q% Y3 G3 x1 d% {- W
- K/ q) v5 T3 _. T( salter profile default limit password_life_time unlimited;
" a$ x$ _2 l; k: T0 s* Y; p+ q+ s2 j/ F; v, |" ^
select expiry_date from dba_users where username='INFODBA';9 \9 m" k+ K" J+ E/ i
--
3 P; n0 ~& k; g6 B1 L) I& a2 V9 u& V$ p! Z4 C6 X+ y$ O& l+ f
Expected output in command window.
! l7 Z& @9 Q F; J==& O0 k; ?; I2 j3 H7 ?
C:\Users\<user id>>set oracle_home=C:\Oracle\product\11.2.0\dbhome_1
; S& M" n* C y" n9 Y \" D4 y- ~
C:\Users\<user id>>4 V: v8 `2 [) F$ o+ Q! C
C:\Users\<user id>>set oracle_sid=tc
& k5 N9 z6 {, l- I; [; }* }( V6 E& g/ b. S# g3 P
C:\Users\<user id>>
T8 z$ i& [' N7 [; NC:\Users\<user id>>%oracle_home%\bin\sqlplus /nolog) z6 ]/ v. g- S3 ]
" D2 \' O3 L) N% RSQL*Plus: Release 11.2.0.1.0 Production on Tue Dec 3 17:25:43 2013
; ^7 `7 G3 v1 h; x' E! I) _* @4 N) t2 h9 H" e' Y, K# C1 D
Copyright (c) 1982, 2010, Oracle. All rights reserved.
+ k7 ~& M( X4 {' Y V9 d1 E6 q
+ X1 u9 s" g; @. \& DSQL>% h. K8 R! z$ a9 v+ P+ S; A: k9 f
SQL> connect / as sysdba
$ ~8 j" E5 o' a/ [* IConnected.; N/ ~; [& n5 b) _. e+ p5 [
SQL>
' \1 q/ T L9 _* k& x3 y+ X: ~SQL> alter user infodba identified by infodba;* g3 R* X( L+ r. ~& B& q2 k) Z; ?$ R
& [7 k g* G9 w$ gUser altered.- A- x* z# ?# T
" I+ B" I7 T0 G+ W. u7 v9 B
SQL>4 o$ x o' a8 @3 R' Y) n3 ` y
SQL> select expiry_date from dba_users where username='INFODBA';: |" j* B1 [, s
& B+ Q! v: L; u C3 F L
EXPIRY_DA
# D; [4 z5 {- A3 T. N5 x---------
+ V0 q4 `/ ]8 f ^2 S8 x01-JUN-148 ^- D" d" g" ^( B: ?0 I2 q
* f& e2 \8 {$ a, h& S/ r& b, O
SQL>
$ n' n; i( w0 T& {4 J z: WSQL> select profile from dba_users where username='INFODBA';
! D/ d- E. R1 L& L+ j
. @0 B4 P- y1 [4 C2 g& }3 V. t8 i" }( iPROFILE
$ T1 }/ r# j8 K# [, r0 M% N( q! f------------------------------
+ ]% u0 F7 ?: o( [8 [DEFAULT
8 B' n* J5 n; w0 L: ?9 `. A, t- H" G8 F v. e* s( ^ H1 I+ k' \
SQL>
$ Z3 \% l- r- m: |. gSQL> alter profile default limit password_life_time unlimited;
' |0 r4 F" d% u R6 e0 Z$ P6 S
- W8 I& y$ N: p9 N9 j! OProfile altered.
+ f& {' a; X& O2 T, ?7 e) o
7 m4 Q9 Y* T2 E* I0 s! V0 b8 HSQL>3 W5 z3 y H: U1 P
SQL> select expiry_date from dba_users where username='INFODBA';
# U3 ^3 e$ y3 d& F1 H) v
D# m# w1 \8 B- hEXPIRY_DA
, T* `1 J, S, y8 `---------
$ g2 K' I7 {/ p; E, D
% M% M7 C0 L- p2 J1 p8 D8 tSQL>; F& A2 r; Q% F+ u7 l3 e) _) L( k
SQL>$ ~8 c' C( g" h+ F- w" A0 z
3 f+ b. K7 r( v& c8 L
/ P, ~8 K/ z4 d |
|
[复制链接]
|小黑屋|手机版|PLM之家-专注工业软件生态建设，大模型CAD创新生态
( 沪ICP备2026005248号 )
