|
|
admin
发表于 2014-7-20 12:28:10
Solution9 h% E' R: e9 S! q+ |( t
2 f0 R4 ?7 q' t: ^6 ZThis is due to the Oracle Password having expired and needs to be reset.
& M3 i+ i& T; |' i
6 }: n/ q1 p& g! O* I- h7 DPerform the following in a OS CMD window making the necessary changes for your
; i! i% ?9 S- k; w8 h. _( }+ B) Fenvironment and directory structure.7 \/ S: g1 o+ U, ]( ~) p" y* C
& }- \; p+ o, \
--
5 C; H& x0 b1 P3 u. O9 c! r% Y) ~5 ]set oracle_home=C:\Oracle\product\11.2.0\dbhome_1 Q- v# s- e$ D- c- `/ S
- ? _( ~4 c4 y8 }1 @$ o' w+ Pset oracle_sid=tc/ T8 x$ z) g6 B! i* `, G0 O: [) X
! s E+ E# x* r. h8 U& Q6 p* |* E
%oracle_home%\bin\sqlplus /nolog
; h/ B! ~8 R' [8 @0 S6 U& X
, V" p" U- K- E1 ?* Tconnect / as sysdba6 P1 X. z) Q) \: C
, g/ B2 j- {6 [alter user infodba identified by infodba;3 S/ w0 s$ W+ J
+ D' c& G" m" ^, W6 ~" s
select expiry_date from dba_users where username='INFODBA';+ S- H. \; z6 {* v
" ~# u! L* \1 r* A% _select profile from dba_users where username='INFODBA';
; [2 x, i/ c4 g. x& k/ ]( R4 T7 w* x
alter profile default limit password_life_time unlimited;$ q9 U1 H5 K% m# V
6 r6 X$ y4 |1 Lselect expiry_date from dba_users where username='INFODBA';
4 Q3 j+ q4 t! j5 t9 G# i7 ~& `--
9 K% D ~7 p# P6 [! n; Z* I' s3 }: Z
Expected output in command window.) X% W' L P) @1 |# X- @
==
4 Q5 j* _+ J# H) m6 n- Z1 \C:\Users\<user id>>set oracle_home=C:\Oracle\product\11.2.0\dbhome_1( i5 q: k- v% d
( B$ y6 Z, n) ?
C:\Users\<user id>>1 f$ @% W+ o& Z4 A. k5 a
C:\Users\<user id>>set oracle_sid=tc
5 J4 O% G6 H. f2 G2 L& c4 a8 r4 I; L+ ]
C:\Users\<user id>>
% Y7 ^, `# c, k. J5 ^C:\Users\<user id>>%oracle_home%\bin\sqlplus /nolog7 R! S/ Q1 n+ d- B/ i0 i% u, |
9 N; s1 ]6 K" y1 ]- QSQL*Plus: Release 11.2.0.1.0 Production on Tue Dec 3 17:25:43 20130 k7 i1 o' x! }: s- v& Z2 R( N5 P4 m
- q P1 ^7 P2 {. X% gCopyright (c) 1982, 2010, Oracle. All rights reserved.0 ?) b6 G, C* _; F2 y
& E o+ T+ M* y" ?! E; N2 R
SQL>
- q$ l8 f" ^* M PSQL> connect / as sysdba
# [- ^3 ~! v1 l" V! }7 {5 E8 sConnected.' A& G( g7 e y* Z6 D
SQL>
, c8 j& |5 O/ RSQL> alter user infodba identified by infodba;
* E6 o- V- e0 j8 n! ?- q* M* \
User altered.( H! j( ]' J6 N, R2 h B/ \
( H8 Y6 ?. y# m& \
SQL>9 [# y! W- @4 u5 K, e8 ?3 o& M9 n) f T
SQL> select expiry_date from dba_users where username='INFODBA';8 `) }( [6 b4 G* t# E- o
& p9 [6 v0 e n6 x9 t
EXPIRY_DA7 v: j# P/ _1 v2 R
---------: ?. ~7 ]$ L) ^: h
01-JUN-14
+ z8 A0 B0 n7 \) O+ _, f6 H$ l0 h) y& u9 `
SQL>& V* j | e. z% e# }
SQL> select profile from dba_users where username='INFODBA';8 @4 Q1 i# l, N* o+ e! E
- r! C3 i8 o% O+ h/ R
PROFILE) r# Q: I9 ~- U; T2 ^
------------------------------
. y: x$ z }2 I0 x2 u, uDEFAULT
0 Z. m! u, Y" s) q1 k. u) Y0 ^0 F: K7 ^; I* m
SQL>
5 g2 C8 t Q9 P0 {0 |SQL> alter profile default limit password_life_time unlimited;
% }6 a% m" `$ `' t5 G
9 ]5 m0 |+ r q; @/ L0 jProfile altered.1 j9 {! |# C4 g5 ~; C$ ~' H
# a- r4 R6 p; O$ Z8 ~SQL>
8 V3 a9 W$ s, R/ eSQL> select expiry_date from dba_users where username='INFODBA';
) h9 Z& p4 F. ^" H3 p# \2 P* k* m1 r& n4 a
EXPIRY_DA
- h( G6 j8 q6 |---------
3 E! q: C3 T3 p9 p1 W
( q+ Z d2 u% R/ Y, ~7 I. \SQL>8 v% n3 D& v0 \
SQL>: {" X5 e, x- @. @3 K
9 t5 x* W# S) t7 N- [9 Y7 [" v* S3 Q3 B2 }: L/ q( A# q
|
|
[复制链接]
|小黑屋|手机版|PLM之家-专注工业软件生态建设，大模型CAD创新生态
