|
|
admin
发表于 2014-7-20 12:28:10
Solution
" B- x0 j* h" Z2 b6 H0 J. l
% e( V- J* B0 E3 n) d2 ZThis is due to the Oracle Password having expired and needs to be reset.
% _8 ^' X' ?" L( R
. i/ e: Y( J' @Perform the following in a OS CMD window making the necessary changes for your
$ b# P$ F k# \5 k3 j7 ~# venvironment and directory structure., ^ k- @$ T6 y$ ~* E" O
6 |7 h( |: o( e) B! z+ }" ?# a
--
. r* `' g8 u) D$ b- {; {) }- p" Kset oracle_home=C:\Oracle\product\11.2.0\dbhome_10 M% M( U( ^/ K8 ]' w. j
% k$ h# y. n# g) @3 H3 Q( `set oracle_sid=tc
: \+ N1 O& o; r
% k( l! V3 U$ @; E& {" X$ ]%oracle_home%\bin\sqlplus /nolog( {8 U: E5 Q: b6 A8 B& s9 O. o# w
- F8 n; X# Q5 s3 A4 S3 e6 Y9 `connect / as sysdba
8 K+ f6 r% l) O, c R# p. f3 o2 t) [- k1 \3 k. w. i7 |) r5 Q
alter user infodba identified by infodba;
% v, r* p2 P; }. h$ A7 E( w+ M$ L
select expiry_date from dba_users where username='INFODBA';
% X% q- W2 V1 h5 `; }+ ]/ ]4 ^
' Z: e' E$ [& l; E$ lselect profile from dba_users where username='INFODBA';
7 l3 I2 }" N# j' o8 U3 k( w2 S* c4 P
) C) I, p+ h3 t/ r/ U1 lalter profile default limit password_life_time unlimited;
& ]# t8 d+ a6 i% Z1 }. m6 y/ c0 p4 F: E5 ^1 j
select expiry_date from dba_users where username='INFODBA';
0 Q9 g3 A6 _8 U6 Q8 E4 Q--9 e, T' k0 G" k* I1 M" H
+ J! w- @$ p# S. xExpected output in command window.% J/ \% Y, v5 Z0 s
==
5 C- o' E# Q& y8 ~8 CC:\Users\<user id>>set oracle_home=C:\Oracle\product\11.2.0\dbhome_1
3 z9 o# [0 A/ p
+ O1 w% Y4 Z5 ?C:\Users\<user id>>" z0 e+ k( j: ~. @
C:\Users\<user id>>set oracle_sid=tc2 G1 f3 L0 y2 n! F9 Z y
9 A4 u7 k2 H9 J9 a L7 P! S! WC:\Users\<user id>>
4 r3 e7 F7 u9 F0 dC:\Users\<user id>>%oracle_home%\bin\sqlplus /nolog
# g$ a+ }* B4 v
C' R9 [: ^; m) p; C8 M: ]( i) oSQL*Plus: Release 11.2.0.1.0 Production on Tue Dec 3 17:25:43 2013
) P1 `& Y" j; e8 J! A) E6 j# w/ \/ P
Copyright (c) 1982, 2010, Oracle. All rights reserved., v: d' e. P: q3 Y; z/ G' B4 g
& V, M$ v1 r4 l- ^5 @! S2 h
SQL>& g7 `8 y# s0 x' ]
SQL> connect / as sysdba
5 K( e' F& N1 g9 H6 P) B4 M- [Connected.0 {/ P0 k8 T+ m3 d
SQL> i6 v' J7 b8 D( u, j8 l
SQL> alter user infodba identified by infodba;
' t$ \1 t( J2 y ?* C# y" Q
( `- m7 t j3 E1 T5 |& U- I/ TUser altered.
* k) |3 Z0 N* U7 w. I$ z
! V7 W H5 K; C; c- R2 [SQL>
* W# R% o0 e# j+ Y$ vSQL> select expiry_date from dba_users where username='INFODBA';" Q8 v: T4 ^+ m: b( k" P: |
2 v, U# E0 W; Q+ S6 }) r; JEXPIRY_DA
1 x w, n8 P/ B4 b& J+ I( `---------. A0 X Z( D) i0 S: L, ]- u
01-JUN-14
2 m6 F6 f" }. E, u0 [0 l; R- }' w7 y" J' D9 Y q+ _
SQL>
' ~) R( D' l; K; V/ |# ESQL> select profile from dba_users where username='INFODBA';% T- `. H2 S$ I; ?* y: T
$ V! x' e7 w* m
PROFILE
" A% K8 }' O* b4 w* [% g& o8 b------------------------------# o0 t9 t+ p: J4 [
DEFAULT7 ]5 z1 }/ L/ x8 D
3 P$ y- K) g- V
SQL>
, h4 }( k" k$ t# `$ M1 q. n/ CSQL> alter profile default limit password_life_time unlimited;
( e9 b/ @6 m& z9 Z
$ y& [; v8 v1 Q. ~Profile altered.
* \" A5 e; M. k n
1 R& C( ]# l+ q4 g& zSQL>: ~* X( b2 m* l# \ p0 y. v g; }+ R
SQL> select expiry_date from dba_users where username='INFODBA';
+ y' f) i6 G/ T" Q$ W7 H, \
- y1 p6 `. w0 W& a( w s% HEXPIRY_DA# T0 Z2 g; p* N+ J1 e5 p8 K5 Z
---------. a/ \. h# S! i4 ^. f8 T, d9 i
- `$ G1 A' @' j( ?
SQL>
6 k" ]7 F# I9 a. HSQL>9 X0 ^0 Z% A. K, ^ y! S
0 t- @3 N# t. l; }* G. U5 X' N, N& D/ n( Q
|
|
[复制链接]
|小黑屋|手机版|PLM之家-企业数智化转型工业软件学习平台
