|
|
admin
发表于 2014-7-20 12:28:10
Solution' Q$ U3 t& d' H: R! }8 P' w
- `. P1 k) L8 I
This is due to the Oracle Password having expired and needs to be reset.' X( v+ R3 m/ o2 Y+ C6 g7 @
3 ]1 R8 }" G# {# n* w' A3 Q3 m8 XPerform the following in a OS CMD window making the necessary changes for your9 Q9 s$ L0 i, m
environment and directory structure.
- a5 B0 p4 x4 _; B6 f) S* C5 B- x% e8 ~! b( R
--
2 d: Z9 ^6 w2 j- Q4 N* E& uset oracle_home=C:\Oracle\product\11.2.0\dbhome_1
! T* h( H8 ^8 [2 a# A; l" t: ], \8 u) C }; D8 a4 |- ?& L% u+ `
set oracle_sid=tc( x- c0 Z, {9 ]! o
& d# Y. l9 Y# Q, t%oracle_home%\bin\sqlplus /nolog
# M1 ^& H7 ^7 K5 r- f
$ m6 O e$ T/ h! k! Kconnect / as sysdba
( f( W. u" v1 b* [# J
4 c& Y* L1 m' [alter user infodba identified by infodba;
: n5 l2 m7 ?0 W5 n% V
3 ^# B+ ?" u! l+ v( Sselect expiry_date from dba_users where username='INFODBA';0 A8 g J0 g3 w1 A0 s
$ d* z% Z& I" ^3 [! m! z
select profile from dba_users where username='INFODBA';
' g. G+ H" M2 J1 E% D7 L* U) p' Q9 Q
: ]* l( g. k4 r8 y- o) D) n% xalter profile default limit password_life_time unlimited;( o! N5 P \+ Z+ M( j5 F" w: e
6 A5 y R* X" s7 V+ h& I2 g; b6 H
select expiry_date from dba_users where username='INFODBA';
. `6 M' a% g5 c* S; C--
$ J. r# Q6 r$ I: U2 i" t, M& M) s- Q7 R+ W9 K1 t% A% k
Expected output in command window.9 ]" _- t" u8 t1 o
==
% Q' u0 m8 {9 Q0 X4 C* aC:\Users\<user id>>set oracle_home=C:\Oracle\product\11.2.0\dbhome_1
5 `" ?; L2 x+ \6 n4 [0 _
: C/ G5 j9 s, P8 t' Y# IC:\Users\<user id>>; o* [" F6 U. n! u' Q2 A7 M! ]
C:\Users\<user id>>set oracle_sid=tc- A0 X/ B* Z0 P& r5 j
' C- ?0 i2 x. BC:\Users\<user id>>$ g& k9 S$ ?& D2 e
C:\Users\<user id>>%oracle_home%\bin\sqlplus /nolog
: Q+ J+ v+ i* Z4 g7 W, @. y% d
0 R7 r' S( H- D/ O4 zSQL*Plus: Release 11.2.0.1.0 Production on Tue Dec 3 17:25:43 2013; R2 B* O* q# b+ V/ r% v
- F/ I* ^; l* {" w" s# H* m0 e' L( jCopyright (c) 1982, 2010, Oracle. All rights reserved.9 k3 @* z) \1 L; {; L
$ @; P3 s, }1 A% W" B6 GSQL>
, ?: n S) R5 _" \! v" ]4 {' J- ~SQL> connect / as sysdba1 j$ U" t$ A* Y" d/ a
Connected.
q5 c3 I: ~7 S3 L) O6 E6 o; R3 ISQL>
0 o" C; |. r0 K X T9 ?SQL> alter user infodba identified by infodba;
( ~$ L d+ [7 L7 U+ L% r9 D i+ K: Z3 J# a2 c9 U, t, N% p5 l1 R
User altered.3 Y% G+ F, `* [9 r( S+ e
b5 I# Y# v, X) b! |( X- k: Q, D6 r n
SQL>
- Q8 n2 ]0 j' x9 y6 YSQL> select expiry_date from dba_users where username='INFODBA';
& ~9 S9 e6 w6 R: t+ A9 C' n4 N6 P/ T3 l% s; ^
EXPIRY_DA* y7 I3 }/ U) D8 D ] U
---------" U1 r& T% T+ B2 b* i/ R1 E/ m& E- d
01-JUN-14" c6 I& U& Q. Z' {' I8 Q$ y: P0 o
+ z1 g/ E' k8 u: R4 j& f. uSQL>6 ~- X, [8 L- I* \" S0 U
SQL> select profile from dba_users where username='INFODBA';4 y8 i4 U# k8 c( q5 a1 m% L$ `* D7 j
$ E% s$ [. X" s6 t6 |! g5 fPROFILE
% y+ n" n$ r- v1 {/ `8 I* T------------------------------, p1 n" }: ]1 [1 J% u
DEFAULT+ U# k+ T2 O' J: Q: H6 Q
, A* T* r) Z' P0 `; ~
SQL>
+ V: q$ K( F G; m7 w2 D4 TSQL> alter profile default limit password_life_time unlimited;
- b9 Y- r0 z: ?( F; d' \& Y8 V$ |2 s) l' e) }; V* p0 u. j# |$ e
Profile altered.1 [7 x# G( G. B/ K! y7 C# P, G
( w a$ z* r" c H- GSQL>
; d6 { r. f" P+ }SQL> select expiry_date from dba_users where username='INFODBA';
- Q d3 v1 i9 P$ A# L5 [7 H- Z' O! Q: d E7 Z6 ]
EXPIRY_DA
6 m& t1 S& c: }& v---------
7 p+ x' O: X* g4 _7 K$ R7 W# l- T& H. C$ D& V4 L5 V& \5 K% w2 X0 U9 a
SQL>
# S: `6 X) g* O5 qSQL>
3 Y$ }2 e0 T9 b: o5 y
" r4 J) g# `$ B) K; B; z
, T% N) r% D! g |
|
[复制链接]
|小黑屋|手机版|PLM之家-专注工业软件生态建设，大模型CAD创新生态
( 沪ICP备2026005248号 )
