|
|
楼主 |
发表于 2014-7-20 12:28:10
|
显示全部楼层
Solution7 @2 |( C+ L: A, r& S" b
$ K0 R& x/ {6 B) B6 @9 m2 ]
This is due to the Oracle Password having expired and needs to be reset.
: }4 O7 d4 |' l# a3 }: ]9 ?) ?5 x2 q1 B
Perform the following in a OS CMD window making the necessary changes for your
3 q5 i M0 ]& T+ l, fenvironment and directory structure.7 { [9 Z1 Z: U2 Z3 D
8 M; {! |! q2 @8 T# B
--) N2 k' p# Z2 U# A
set oracle_home=C:\Oracle\product\11.2.0\dbhome_1, A( f; G8 p% t+ R
3 a1 [7 f4 O1 hset oracle_sid=tc
, y6 R- u& m4 n7 J, z
. S* n6 }, ?: C7 h1 s& P%oracle_home%\bin\sqlplus /nolog
# J8 u' h6 S) K
; I/ D! a5 K0 V; }& I( B4 Aconnect / as sysdba
* g. f0 _' k$ W
$ Q2 F- P7 o4 Balter user infodba identified by infodba;
: L- K5 r+ X; R3 F# Q, W- \% K! p! C @) ]
select expiry_date from dba_users where username='INFODBA';& E V: E" ]% S+ F/ G; [4 `
# D+ ]' \" j6 Z6 z* R
select profile from dba_users where username='INFODBA';9 o2 ^) a: P$ D# s3 F: w/ |
" G! m: }7 d& A3 @2 f4 Lalter profile default limit password_life_time unlimited;5 _/ Q1 W/ ^) _/ [3 m
# l# m) j6 b& V9 Z" G+ uselect expiry_date from dba_users where username='INFODBA';5 V1 D! f4 [# n2 o, M& ]; @1 o1 n
--
9 C' Y8 k6 a5 i9 x* V+ Z8 w" E; a; f+ |
Expected output in command window.
7 n$ e9 s8 N/ e* D; B==( }4 r% I& C3 k: R1 J( |( b
C:\Users\<user id>>set oracle_home=C:\Oracle\product\11.2.0\dbhome_1) {' t) W$ l: e9 j1 E D+ B
& @; P3 z! a/ j9 c; L
C:\Users\<user id>>
# o: g- V8 b# lC:\Users\<user id>>set oracle_sid=tc4 w, Y- t4 B8 W% S
4 d" `4 b# ]# R' U1 n v5 m
C:\Users\<user id>>
9 h& p$ X7 j$ E6 T/ PC:\Users\<user id>>%oracle_home%\bin\sqlplus /nolog
6 i: I# [. A& {- z4 v t9 `
5 m: P) _/ e" S( S7 M4 h* ESQL*Plus: Release 11.2.0.1.0 Production on Tue Dec 3 17:25:43 20136 ?; w; |" D) g5 O2 v8 z$ ] u! `
% O9 o4 o* U dCopyright (c) 1982, 2010, Oracle. All rights reserved.$ P7 O6 }1 K9 s+ B; i
5 W6 x7 }* U+ Q% f; j
SQL>+ _/ R. U# k: H: C* Q
SQL> connect / as sysdba
4 p% J1 h% s G9 ]1 r6 L8 W$ pConnected.6 p& r' q1 [9 t: {
SQL>" v, R$ F) R% p0 E
SQL> alter user infodba identified by infodba;
6 F4 \: [/ X, {# `! \) S5 j0 x+ N& n2 I5 T
User altered.
4 @# T6 `) g4 d
1 y, S) B, J) W' l' s, P5 G, mSQL>
1 K& E) G" @2 m, M: USQL> select expiry_date from dba_users where username='INFODBA';
) U7 v" U& r5 i" a9 z
3 @$ A* [; v- m8 l/ _( REXPIRY_DA2 X/ f. c8 V; [5 L" l
---------
7 i0 M Z# A: s' N0 \6 M01-JUN-14" H: Q$ H, M0 L0 s
& r- d/ d) a! C( `0 o' c1 E
SQL>6 S0 q: K, w/ D
SQL> select profile from dba_users where username='INFODBA';
$ \" m* }( S7 m% X" ]
+ d1 y0 ^' s; M% p! } DPROFILE
7 B8 {$ Q! N; X( a' {------------------------------& L: C( G6 L9 W
DEFAULT
7 X/ ?% x( M) Q
& s9 r! i6 N/ T: g7 ?1 `SQL>
, D/ \: j" N/ f8 W6 O MSQL> alter profile default limit password_life_time unlimited;
2 M$ [) w! i# B8 H, v0 a
: X% G8 D, `! d1 O: C& PProfile altered.& O9 ?3 s9 @3 h6 O
! B& E: L6 z: c/ V C! Q
SQL>
2 _& F0 L1 I* x; m+ i- nSQL> select expiry_date from dba_users where username='INFODBA';: N4 j" V C, i2 F4 @0 I+ ?
. q8 S* J b& ~2 K2 s$ mEXPIRY_DA- z& P6 O8 N% w' m3 ]' e& O
---------
5 t0 o8 _! o! i( q. I( G2 X, P# M; Z& A
SQL>
" _" v' m) l+ `4 R1 j5 ]/ {SQL>
6 n8 X- D: u D# T
* q6 _8 c3 t! Z& Q2 T- x! ?# B6 L* { S# B- ?* j4 ^$ W+ F
|
|
发表于 2014-7-20 12:27:14
发表于 2014-12-8 11:04:41
