|
|
admin
发表于 2014-7-20 12:28:10
Solution9 R( w m' ?+ L( {3 S1 u! l4 X
% L1 i; H0 n/ d2 C1 m( d
This is due to the Oracle Password having expired and needs to be reset.( _0 m l% V. o; y) c
8 i0 O; t9 M1 C9 Z% R r$ v6 mPerform the following in a OS CMD window making the necessary changes for your
8 L& W. N; f( {! ~/ Fenvironment and directory structure.
+ g6 x2 _: f/ R3 I1 X0 c- o, j, I e" `( ?2 b/ H7 d& S
--; u/ Y& R3 {6 ^" U, Q: A8 j
set oracle_home=C:\Oracle\product\11.2.0\dbhome_15 y* M. k: t' Y- v+ y
' F" B* N& C7 b l
set oracle_sid=tc
+ f8 @. [( G6 |( X. v6 p6 Y% j2 ?4 D* t# ]7 d) G9 b6 \, \" H
%oracle_home%\bin\sqlplus /nolog
* _* k: R* P! E' q
# W) X1 \$ I7 Kconnect / as sysdba9 y6 |1 H n. _' F( {
0 C% e, l1 K& w* o
alter user infodba identified by infodba;
. g# ^. |6 S# L1 ?8 Y# e& B- k$ f9 g- y9 b5 {! k$ K: J+ ?
select expiry_date from dba_users where username='INFODBA';
! m, n0 c# c. J& f7 P+ U
& g9 D. h- `- i4 v' B; ]9 Iselect profile from dba_users where username='INFODBA';
- Y/ x" n# R0 O( ?0 m8 U
5 K' E8 M: [. z0 Z3 S! s# Walter profile default limit password_life_time unlimited;
* k$ Q1 r4 Z, b0 @9 ^' I1 L$ K H; w2 C- A
select expiry_date from dba_users where username='INFODBA';
- S4 S, C. y5 }5 @( b--! d& c; D- X" v# D; x
* E2 t6 i! o) f% ^5 K/ P9 Q
Expected output in command window.
, t" N3 l- f& p0 J4 h==# |6 `; F6 K( b1 J1 g k
C:\Users\<user id>>set oracle_home=C:\Oracle\product\11.2.0\dbhome_1
) ?# K9 \) |) Z$ C+ g n, ^
3 g# |0 t/ [+ U( gC:\Users\<user id>>3 x$ \. K N R' M
C:\Users\<user id>>set oracle_sid=tc# g; p! G$ B% Y! S; w+ S, T& V) k
2 M" a2 M4 ]* \6 o2 R" N6 SC:\Users\<user id>>: m1 l2 t- X- Y/ c
C:\Users\<user id>>%oracle_home%\bin\sqlplus /nolog/ K7 c# @, X4 H0 G
9 Y& L6 W2 v5 X' I$ b% x
SQL*Plus: Release 11.2.0.1.0 Production on Tue Dec 3 17:25:43 2013) M/ l p2 ^9 U, D6 M3 `
. e; Z3 M5 J2 a5 X* y
Copyright (c) 1982, 2010, Oracle. All rights reserved.
$ x" E" ?; v' ], W: r
% t! @* f% R' a3 ^SQL>% D5 {% ?5 C; V, L2 p) u! D4 `3 q
SQL> connect / as sysdba
5 j4 x/ B0 Q; C. ^. vConnected.
# F$ b9 P, N" W' B9 o, Q" S, BSQL>
) q2 v/ _, q1 |+ ZSQL> alter user infodba identified by infodba;
* X& j; R5 e7 Z0 U% {' m; y7 x
6 x1 U5 c( J8 QUser altered.1 E6 b# X) P$ b# t9 \1 F) M
" x8 u/ \* g6 |# n# O" ~: iSQL>% z7 G+ a4 T& N% b: b: d
SQL> select expiry_date from dba_users where username='INFODBA';
8 f! e+ S9 B0 Z2 t
6 M( u$ f% T* k: i* VEXPIRY_DA( C' Y6 O! n! r& N
---------9 ~5 S- P8 a& L' V6 N0 P) X7 ^& Y
01-JUN-14
3 h% }6 o' B0 R" q3 W% O+ U+ p! @5 ?3 a9 f% u6 n4 a. N
SQL>2 S8 i" V8 b4 d2 `2 G( [
SQL> select profile from dba_users where username='INFODBA';, P; S" |1 [" C7 M' k
6 d# Y5 p; g2 D7 i. z& G! i8 GPROFILE- v- z4 m; D1 N
------------------------------
( J3 {& m" r3 u' i' Z- CDEFAULT
1 n! O/ O9 H8 G/ Z- z( [7 G9 _- R9 Z, p( X7 x$ i
SQL>
9 p( I6 |" K* j. k7 S2 x. T0 JSQL> alter profile default limit password_life_time unlimited;, g/ g* B* B. S& `
o7 C# d9 g$ m @0 k1 F3 M2 eProfile altered.
, t& g0 T* p; k1 i {0 z- l! j5 \+ T% C
SQL>
3 l% A1 W$ s. S B" R/ s' dSQL> select expiry_date from dba_users where username='INFODBA';
" G5 a3 Q6 {$ Q7 C5 e/ @5 ~' Q' s( e3 |" ~: i5 W
EXPIRY_DA
, u3 Q* @& R( m---------
% L* x9 j! F3 v" C; t- S! y
/ n$ q$ c# g! e* ?SQL>
: |1 _ N2 K$ J, k% ~SQL>* O" v" ^" [0 z& m
0 _3 ~7 N) b7 ~$ e. `) {
: R1 A, T* e7 k' Z H
|
|
[复制链接]
|小黑屋|手机版|PLM之家-企业数智化转型工业软件学习平台
