|
|
admin
发表于 2014-7-20 12:28:10
Solution
( Y5 v$ z1 J% x% w3 |( w* O+ l' m0 z/ Y- L- x
This is due to the Oracle Password having expired and needs to be reset.
5 ]# \, P8 ?' F5 X& v) {
6 A$ b3 D6 ~2 Q$ d8 o0 Z3 h# qPerform the following in a OS CMD window making the necessary changes for your1 {( [, {8 r8 Z
environment and directory structure.
$ q" X# z. a5 h; m& B
7 y0 g9 w" Y4 R: q: w6 T O--4 o* f3 \/ c9 a9 Z+ l
set oracle_home=C:\Oracle\product\11.2.0\dbhome_1
2 J+ ^7 ~1 d$ O0 j7 s* ~7 q1 Z' Q* }$ }) O
set oracle_sid=tc
3 o# |' {, L+ _ r. u) C, K5 R8 q, B
( c9 ] `* R+ b# C3 S& P7 w+ Q%oracle_home%\bin\sqlplus /nolog' j8 K0 h1 H( N& W
" `. z7 o' |) s' v9 k# _connect / as sysdba+ k2 P6 P# A. v
% J" ]* X% ~& j" ^7 p- K6 Ialter user infodba identified by infodba;8 I9 m! l+ ^) Z' z* Z
: Z- W2 s, q0 s* [select expiry_date from dba_users where username='INFODBA';
; z( G4 I; g3 C K, F8 f5 o* ^" W: p7 f J6 J& R
select profile from dba_users where username='INFODBA';3 U2 I. T2 J/ P8 k5 b7 R( T6 H& v- p
- d& ~9 J7 s0 E) `0 b6 E2 q* j
alter profile default limit password_life_time unlimited;
7 B7 {2 n: j2 @, K: J# O* C3 q- d* i2 d* b4 a3 _
select expiry_date from dba_users where username='INFODBA';
9 z/ r, k% v: k- k9 I! g! u+ l--
, F7 `2 U; C1 d8 z7 k7 Z6 U2 h3 L3 }1 z1 Y9 e. m% U
Expected output in command window.
1 B N/ O" R: Z& f, N==
$ {9 c7 W* m4 F, n9 j+ [1 S' E) zC:\Users\<user id>>set oracle_home=C:\Oracle\product\11.2.0\dbhome_1 L3 ~) s+ U% ]7 X1 k
1 b% ^: |* e: p- A1 w$ Z$ VC:\Users\<user id>>
7 ]9 o7 _+ \7 W5 P! @C:\Users\<user id>>set oracle_sid=tc
0 r5 N8 `$ ?4 p, b# x1 i) O: C$ n* q Z, o2 {8 z
C:\Users\<user id>>
- U$ T. z0 a/ |9 G, r2 l- Z4 sC:\Users\<user id>>%oracle_home%\bin\sqlplus /nolog
8 P/ x7 y8 x( C5 y/ M9 \5 Z9 Z7 B* z
SQL*Plus: Release 11.2.0.1.0 Production on Tue Dec 3 17:25:43 2013. d( \- a& b% o! X3 D
. p- s7 I% b8 b2 o3 ^) `Copyright (c) 1982, 2010, Oracle. All rights reserved.
+ m8 g9 n5 l+ p( d f% H" y q8 K3 `& q: l( z
SQL>
6 S' R7 H) H! y% Q' SSQL> connect / as sysdba
1 w8 X, p) |9 ?/ d/ S6 ^6 SConnected." ~, w' Q" L, R& ?! r
SQL>
0 Z8 s6 H4 ?5 v- S6 _& DSQL> alter user infodba identified by infodba;5 K4 i; p4 P5 o
' ?- B6 W) [, V8 q" ^6 h
User altered.
8 d% r* |( E& h A: s( W0 L0 Q' M% x4 C& [9 x/ V }! ?
SQL>1 y9 W9 M6 F- ?+ O4 i
SQL> select expiry_date from dba_users where username='INFODBA';/ H/ i8 _, C, @1 l" B: M# m
) n+ s* D/ |; |2 T, H3 G, ZEXPIRY_DA
' W. A) @1 W; j! B---------2 l {% |, y1 y3 i
01-JUN-147 | |/ ~ b* u0 {; w J8 s
; r: I m8 e' i! ~SQL>* B+ G: T @8 j! U* {8 L* d
SQL> select profile from dba_users where username='INFODBA';
% _8 r/ h) E+ a3 p* e7 [) a5 m
) w; ?" P6 r7 ZPROFILE/ {1 e- c( C5 x+ S* t5 c8 N+ j( ]
------------------------------
6 V: s6 h5 r% M- D$ T) zDEFAULT
% f% {& {) ^: x2 p" t8 {, A l% ]% O( s: R, w0 C4 ?
SQL>
) x; P7 ^0 t; O' t& YSQL> alter profile default limit password_life_time unlimited;9 g! d H1 d3 z; {+ \8 i1 [1 Y
2 ]' K8 }, d p# r& y1 h* s9 M
Profile altered.
9 M% d, t8 D' k5 {7 Y$ T7 d& |" r. B- C( N! V( @
SQL>5 A2 g1 }, @4 y8 Z" ?6 C0 f0 l
SQL> select expiry_date from dba_users where username='INFODBA';1 m0 M7 G6 S! j/ |9 [) o( R
0 g5 y. ]; O/ n- b( i) b2 DEXPIRY_DA
# E! n0 p+ s4 \5 t$ S7 I- y/ B2 A---------! r- u" n0 J2 o0 m( Z+ ~7 X1 @! J
: ~* I4 k( F4 G: t. J
SQL>
4 m0 b* v$ {: R/ V! X2 C, m6 mSQL>
5 j9 K$ y0 b" h" {. K! P5 x" F' F# t+ [7 d
; {" f) A, A- |' `1 w& L
|
|
[复制链接]
|小黑屋|手机版|PLM之家-企业数智化转型工业软件学习平台
