|
|
admin
发表于 2014-7-20 12:28:10
Solution
" A7 A: b5 M% }$ B- R& o& K2 w/ A0 v) r' o9 B5 V
This is due to the Oracle Password having expired and needs to be reset.7 C( E" Q' A+ Y( U& Z7 _
( H: ^: o+ j& u( d* g& R0 rPerform the following in a OS CMD window making the necessary changes for your4 S$ G$ J2 `/ l
environment and directory structure.
. }) a; I, b# g3 E' a2 j! J+ W9 T- \( J! X+ I2 k8 R- o
--
1 F5 _- k* V& z6 k& _# H& \set oracle_home=C:\Oracle\product\11.2.0\dbhome_1
/ @, Q2 m6 W7 ~! r' ?& l' n( C' K. Z; E6 T' |
set oracle_sid=tc
5 G6 V8 q1 v! N5 H4 R
p- V+ }2 B# p% H8 G- M%oracle_home%\bin\sqlplus /nolog
- o6 h, F) ~# N4 M/ I4 j0 K6 p+ s. j, Z/ p
connect / as sysdba. R2 M: ^% s5 x% w# [
( v! q- a0 O# {4 b# m1 a0 X
alter user infodba identified by infodba;
5 D7 l; a# U" ]3 t, @3 a% j$ n
7 U: H$ J- p* Z3 }0 D) Nselect expiry_date from dba_users where username='INFODBA';
; x. x) O; G5 R6 f0 S
2 y) v5 r+ b* N$ i) oselect profile from dba_users where username='INFODBA';0 @' c5 I7 e. K, B& j- w/ ]" g
* T' z% S( U$ D4 y5 B' ]
alter profile default limit password_life_time unlimited;
' L }; D2 f8 j
* ]8 p* ]/ p0 W( cselect expiry_date from dba_users where username='INFODBA';
% T0 { y4 S# T% O* @' e. ?1 f" _--+ v! M" e) ^" n& W8 e
& X3 n z6 n6 I" T
Expected output in command window./ j1 L2 B1 l; f
==
2 v6 d& Q8 X9 a2 W6 f2 w& c5 VC:\Users\<user id>>set oracle_home=C:\Oracle\product\11.2.0\dbhome_18 F, s& \' W" }" f- l8 y
3 v, b2 u, K+ P) U) p# L" b+ Y& Q
C:\Users\<user id>>
$ W* _# ]/ p' ~. K& yC:\Users\<user id>>set oracle_sid=tc% m/ G# C6 f" O4 } d
1 S0 s: k) W+ X* p1 E. M
C:\Users\<user id>>
6 M) ]- `3 b+ z Y6 D- RC:\Users\<user id>>%oracle_home%\bin\sqlplus /nolog
; Z/ E: y; R7 Z" v5 h! n( i9 }% J3 V% O# [( ]$ P) \ A7 ]" Z, _
SQL*Plus: Release 11.2.0.1.0 Production on Tue Dec 3 17:25:43 2013
0 M1 @9 m, I- J" o' L9 Y. k6 j: [, l" S9 t6 _5 r
Copyright (c) 1982, 2010, Oracle. All rights reserved.; [2 H0 N8 f( ]0 f7 w6 V8 X
$ W- P+ Q2 Y+ ?( O& R
SQL>
7 C1 y' r5 t, V6 d' w; @2 mSQL> connect / as sysdba5 D; |* ]- C# c+ a3 {' d
Connected.5 ~+ H: C$ w/ d0 Y% ~$ w' T: U
SQL>: u1 i: I0 z* b$ Y
SQL> alter user infodba identified by infodba;* i0 Y- N) P! \* \2 R# l
( M7 o3 w: e# w/ r( {' UUser altered.0 X. |7 c! p$ b0 Q
$ l* `5 @3 r' {- j; `4 lSQL>. f }0 v/ x" Y! d3 ^6 A% E% ~( Y, p
SQL> select expiry_date from dba_users where username='INFODBA';* ]8 i6 P6 e6 A3 \2 |( @, c) B/ I! ]: s
$ D8 H% [9 y3 v! nEXPIRY_DA
6 d6 w$ g, s( G; z---------% y6 `' v8 P) l' Y: I a
01-JUN-14
: d0 B" v; Q1 B7 N$ [9 A# D. w7 v: w2 T H: L: z# m
SQL>
J( F m6 s, o" z. D c. {SQL> select profile from dba_users where username='INFODBA';, B1 [, N4 |0 C E- x _4 i
; d( Z, d b4 ^; e! W( @6 d
PROFILE
7 `) n) V4 @) A5 V5 d! V------------------------------1 d2 k o) Z$ t) d7 b. Z8 q, K
DEFAULT
- f! z; x# l P* I) [. G
6 W" j! e: e/ A& ?, g; M6 jSQL>
+ u# T) A9 a6 V& n2 FSQL> alter profile default limit password_life_time unlimited;
+ r: i( e" {2 | b1 o
/ ^+ r( T* B$ u0 t5 ~, [% i& m; fProfile altered.
3 J6 B5 E& I8 W8 c- D! t' d" K/ Z* k6 o/ I5 ?* s! L! ^ l
SQL>
9 g+ j' I- ^3 S; aSQL> select expiry_date from dba_users where username='INFODBA';; a! i3 n! y' ?: o7 m
6 x C" ]4 V- z3 I: REXPIRY_DA/ x/ E8 h7 M( M
---------
5 D4 S, P: V, k0 L2 Y
. ?& \; S$ c& tSQL>
' X/ J5 Y0 k$ cSQL>* Y4 w8 h* ?5 c
$ g8 k# r4 {9 b; k- h0 @7 W4 ]
; A9 j1 q& H" Z2 v8 V/ I
|
|
[复制链接]
|小黑屋|手机版|PLM之家-企业数智化转型工业软件学习平台
