|
|
楼主 |
发表于 2014-7-20 12:28:10
|
显示全部楼层
Solution1 F6 S. K: P' u& W! V" V
, C: X0 W( N4 nThis is due to the Oracle Password having expired and needs to be reset.# n2 p% g# K! u% R- Y
; T; v. s9 f. t/ ~( A
Perform the following in a OS CMD window making the necessary changes for your
4 {8 m: `/ n4 B% T. k; p n$ ?' penvironment and directory structure.
8 c$ q. |* h' A% U4 F2 o! T% E) f
1 ^# m! D) a; }9 h3 Y--7 s h3 R& W6 @) X! `
set oracle_home=C:\Oracle\product\11.2.0\dbhome_1- S+ p3 S' C+ E! |5 x6 p H
( x1 m/ j7 s$ X9 F
set oracle_sid=tc; {& K; M* I: w
9 b" t) }3 K4 t7 Z8 `
%oracle_home%\bin\sqlplus /nolog
* h# f [. R' r. f
' V2 V+ B0 I. r! x8 v0 iconnect / as sysdba
7 |; x& @% q7 e. \( B9 l2 [5 l. D0 t$ d; I. U2 S! H/ V [0 W3 V5 i
alter user infodba identified by infodba;
5 [. L& u& Y2 b" r/ |3 n
9 j3 a5 o1 ~* m7 }' ^* bselect expiry_date from dba_users where username='INFODBA';$ W; B q M& j. K' S$ N: y
& Q r# Q. X# ]
select profile from dba_users where username='INFODBA';
|. x3 i! R6 y" P1 O8 v1 E6 w0 m7 A- l+ Y
alter profile default limit password_life_time unlimited;
3 F1 J) a4 F9 n. d' e3 o3 m3 s4 b; f2 S; E1 l, D2 i- {( `
select expiry_date from dba_users where username='INFODBA';
% c8 }0 M1 C* a--
2 u! \5 N6 y% h' a
8 O" n2 X+ p/ Z! Y' q- P- OExpected output in command window.& }: _2 ~' [1 f* \6 y( B8 g
==
: ^3 ^% ]' U! U2 ^8 zC:\Users\<user id>>set oracle_home=C:\Oracle\product\11.2.0\dbhome_1
7 H3 `. @) x& z& H$ K. S" J$ v) I4 Y6 Y% @: E0 H. y% K
C:\Users\<user id>>$ e+ ^# k; L; v1 _
C:\Users\<user id>>set oracle_sid=tc/ K( E6 W1 C& L& Q, m* u1 V5 _2 }) ^
: H5 }3 S& g/ G& ^$ B, L: fC:\Users\<user id>>' A9 A# w4 r/ Z: T- W' L/ [9 R
C:\Users\<user id>>%oracle_home%\bin\sqlplus /nolog
+ g# j' j& Y D3 ?& x3 i! s2 Y
' p8 r" d$ F, t, j: SSQL*Plus: Release 11.2.0.1.0 Production on Tue Dec 3 17:25:43 2013
' y# c6 ~1 B' _! c. z: U* v
% B/ S+ b) }# {- @# XCopyright (c) 1982, 2010, Oracle. All rights reserved.7 q! c0 d9 o6 s6 M, m4 P Q$ l, L
" U3 p; v+ z* c, QSQL>; q6 Y% f% W1 I9 \% M
SQL> connect / as sysdba" M. K) P' s" b1 ?
Connected.6 M" U2 j7 v" P) {! l* c# S0 f
SQL>
7 [- r/ @; J! g' ^" S3 NSQL> alter user infodba identified by infodba;
1 M! x1 [# u7 ]: N" F3 K. D: v; M# B6 @
User altered.) K) j. @# b; Q7 o) i* a* S8 r
& \0 b$ \! M% bSQL>9 a9 _. \$ M* D. A
SQL> select expiry_date from dba_users where username='INFODBA';
; ?* p) z0 t, z& O& t# X3 R. {6 A b' m% m- C; K
EXPIRY_DA
0 {1 ^/ ^3 G7 N/ D @---------
& o) G- K: w/ I% M# k01-JUN-14
+ F- n- e# X+ k. f( V' ?6 x, q+ l/ y0 @6 d7 i1 F7 J) _
SQL> T6 K/ w1 }, _( m. h
SQL> select profile from dba_users where username='INFODBA';4 l% \% v% y! h" p
* A* O p5 A1 K6 D
PROFILE
5 m5 r+ ~4 t. E( Z8 j; I------------------------------
0 `- N8 b6 d8 r3 I7 R0 mDEFAULT
. h9 w4 P; u$ k% y3 ?+ H, @5 v# J2 J ?6 D( [4 c7 h5 d
SQL>
" m7 F. {0 N9 E& R) }& a& p' K; MSQL> alter profile default limit password_life_time unlimited;
, {/ e1 u9 f2 l0 R) e! S, [) i2 N p" l& H. M$ E
Profile altered.
) ~ N' D/ U, l
+ e- F/ d. o5 H7 w; H0 Y% l, G- x. c4 PSQL># K) B C- s' Z# `8 u7 B
SQL> select expiry_date from dba_users where username='INFODBA';$ q. ~5 \, U- n( Q# E) k2 x. W
" Q* y8 j# u x g* A( ]1 U- @EXPIRY_DA
6 ?* y4 Y5 T' A( a+ q6 U---------5 p% M3 v4 x9 {7 v' J+ [6 b0 b1 r5 v' E
- \( F/ Q" ^/ V) u8 i! w+ F/ @
SQL>
w2 n. a s% I9 Q: t# NSQL>
6 P( U0 T1 _! e- s2 J; b8 B1 y% N6 M% ^" \2 p
4 s1 m, j2 C2 M1 |" W! _ |
|
[复制链接]
|小黑屋|PLM之家-专注工业软件生态建设，大模型CAD创新生态
( 沪ICP备2026005248号-1 )
发表于 2014-7-20 12:27:14
发表于 2014-12-8 11:04:41
