|
|
admin
发表于 2014-7-20 12:28:10
Solution
4 V7 e0 z) I+ n- |( w/ H, `
0 O8 f8 ^; Q/ J5 z6 [5 [& ^This is due to the Oracle Password having expired and needs to be reset.( z9 \# ?5 f. l b! N
, u/ p+ A4 A1 }% y. o5 r
Perform the following in a OS CMD window making the necessary changes for your5 Y( c5 b0 H- W+ v
environment and directory structure.0 [' m9 I. w& v* ]8 Q8 o
2 }% t' `; ~: m--
3 s$ Q0 r; r5 Lset oracle_home=C:\Oracle\product\11.2.0\dbhome_1
7 X+ ]8 {' ?/ g$ o
# U; R! E, r* v5 D% U- Pset oracle_sid=tc
- Z2 T, ~/ T; y3 s8 M+ o5 _# ~( G, p; }5 m# Q
%oracle_home%\bin\sqlplus /nolog* B& ?' v: c, {* d9 q+ [
( l; Y9 u$ M. Z' h/ q+ ^/ W" G& p
connect / as sysdba
+ L: r! E0 u2 @9 z
9 R5 \, `5 ?/ ?5 L- Dalter user infodba identified by infodba;
: _0 T, w: R, J. ]6 C
# \4 M1 m. Y; b8 N3 {6 {5 aselect expiry_date from dba_users where username='INFODBA';6 x N% e0 S1 {2 Z. U0 K
* c. e7 b( x1 K8 ?1 C
select profile from dba_users where username='INFODBA';1 ]; q5 ~6 z+ N( D- Y4 r
$ P/ T5 H; k! s
alter profile default limit password_life_time unlimited;
; @+ i$ G. ^9 G. x" n/ L4 j5 r* X1 [0 h% N* ^# V% T7 P" K0 _; f1 ~
select expiry_date from dba_users where username='INFODBA';
/ \8 v. q! o9 k9 K/ @) c--0 O6 Z- f2 J+ j
' i, _/ q `& e3 L A7 U7 |% E8 {* q; t
Expected output in command window.
' U7 B( ^, j* [0 L% L. S4 H==# v+ c! L' j: _6 o m _! r
C:\Users\<user id>>set oracle_home=C:\Oracle\product\11.2.0\dbhome_1
% C, D, U2 b, A. O0 T. T1 r5 m/ K; X% u# j) `& s: L# p7 q% [( x* _/ s
C:\Users\<user id>>" `" [ G0 s9 k( A5 `
C:\Users\<user id>>set oracle_sid=tc
5 ~+ h E! J$ r2 J6 L
! T% Q4 x% G' P/ u* rC:\Users\<user id>>
0 Q) N- k2 e) S% QC:\Users\<user id>>%oracle_home%\bin\sqlplus /nolog3 x1 e5 b2 I) ^
7 E* H+ C1 b7 b% ?# T
SQL*Plus: Release 11.2.0.1.0 Production on Tue Dec 3 17:25:43 2013
9 J! @2 c1 Q* e# O5 P9 T f# \6 X0 R" l- R! s
Copyright (c) 1982, 2010, Oracle. All rights reserved.
, m% b) T8 |# H7 L5 c, e! V. T1 f6 a! B: @; V% o$ w5 X9 y- E9 E+ m
SQL>; l! }* w4 K$ A. a
SQL> connect / as sysdba
1 ]9 L0 r% E; K# s% EConnected.
" b/ ~0 I) d x% s2 ISQL>( ]' X, A& o: A2 s T v& Q; V) e. c
SQL> alter user infodba identified by infodba;9 d# c, n' p& l3 _3 M
+ |1 N. a' B* J
User altered.
5 y9 \4 P, s. `# M4 K# ?: I- J: q4 q* d( [8 T
SQL>
+ c3 k- X0 e2 q0 M' s/ XSQL> select expiry_date from dba_users where username='INFODBA';
- e" ~$ B$ u% n: k+ {3 c9 m. m, t' G' l0 x- z
EXPIRY_DA
/ c0 U1 P9 ^( f4 ^9 n1 c8 r---------
5 @- p+ P! x2 {01-JUN-14: t/ f P% ]6 `1 J' Q* y
" h! E6 |6 ^: K8 {SQL>
9 ~& l N8 L: x8 p4 k; V/ ASQL> select profile from dba_users where username='INFODBA';7 S3 w* o6 }, f4 o7 E0 `* f
' f4 Y5 i) @1 v$ c, [PROFILE
! n+ x# W/ J1 l9 l$ n$ o------------------------------. g8 u. }, l6 f) ^8 N: \
DEFAULT: c0 W( {1 O5 \6 b7 o
. U# _6 w8 a8 D; e5 J& ], r. B
SQL>" |4 b/ x9 O4 X) e0 z# g2 M9 }
SQL> alter profile default limit password_life_time unlimited;
7 R, P( J2 X( ]6 M4 t! _8 A( T0 G4 ?* |$ M3 l
Profile altered.
) G" Q$ Y: c. L6 l% l( @
: e. H( J8 Q3 |' c: H' RSQL>
1 ]2 N5 C/ {0 L5 j& K3 ~SQL> select expiry_date from dba_users where username='INFODBA';( f N; T8 ^+ y/ k/ J0 O/ T! U
& n3 f% |7 B) @/ {EXPIRY_DA; i- o# i) U/ n6 O3 c* H1 M+ f
---------" f& u7 i% Z r& b* i
# q) d* u/ {+ t3 a" w$ p
SQL>4 `( V( U& n; n, r
SQL>% ^- s8 D# B0 i6 o7 j
7 V/ p/ e) B& p4 h1 P
2 A5 ~" a( r/ f' I5 {; P
|
|
[复制链接]
|小黑屋|手机版|PLM之家-企业数智化转型工业软件学习平台
