|
|
admin
发表于 2014-7-20 12:28:10
Solution
% @& y! d- `( B& g/ l% K) b0 n y: C* p% V4 {$ h
This is due to the Oracle Password having expired and needs to be reset.
y2 \0 U, P; y: @& e
1 \# Z, @" N V/ K! `Perform the following in a OS CMD window making the necessary changes for your
% _0 z4 r. ~8 Jenvironment and directory structure.8 |- f% N1 v; B* H4 X6 ~; c
( V! D/ a8 R7 N--
6 J. G, \: j$ S- t6 Uset oracle_home=C:\Oracle\product\11.2.0\dbhome_1
* l9 w' x1 l! t6 ?
) l4 L7 Z. o/ P4 `set oracle_sid=tc
2 y. Y a) j, _$ E$ F# `8 M' k: d6 e* @ n7 U% `" e& T9 Z
%oracle_home%\bin\sqlplus /nolog. Q& R' [; `# h0 O" D% y" I
5 j" V3 Z% n+ B# N. P
connect / as sysdba! l) _8 Q3 S( I0 D( ]
* ]1 P, g/ K/ N/ i+ S' v2 |. r! X) xalter user infodba identified by infodba;
0 Q$ b y+ F& N! E5 g* k, r* G! ]8 F
select expiry_date from dba_users where username='INFODBA';
1 p9 q. X# H# J- I: b- |. U7 k3 s. p. T9 f* B4 u: D0 E1 q$ q
select profile from dba_users where username='INFODBA';8 S J% b& B( n' ?: o0 |
( `6 g) j; e9 c# P; B
alter profile default limit password_life_time unlimited;
9 i; Z1 m; l5 U5 _8 l8 V" q) ~) j0 Z" X
select expiry_date from dba_users where username='INFODBA';/ }2 |. e3 U& s3 ?
--9 b8 D* S" I" c: y
" X* i. z' C! d' {2 Z9 EExpected output in command window.( g4 \/ y# L) `1 r3 V/ A$ y) O
==1 Z* Z0 J0 q b! ?4 g7 q' T7 E2 j! E0 q; {
C:\Users\<user id>>set oracle_home=C:\Oracle\product\11.2.0\dbhome_10 x" Y0 P7 C7 z, C* f4 \
5 E3 n7 F5 `0 F& y* u0 `
C:\Users\<user id>>
: m) h8 A, X a; gC:\Users\<user id>>set oracle_sid=tc
, z2 @) W, {9 S } T( G4 Q' B7 O |4 Y+ c% j9 c& `; n
C:\Users\<user id>>
2 B9 ?; ?& o! \6 B8 E$ `) e+ QC:\Users\<user id>>%oracle_home%\bin\sqlplus /nolog8 ^) R% w0 e A s7 N5 F' D
: m; x+ f/ X+ Z0 L" D' BSQL*Plus: Release 11.2.0.1.0 Production on Tue Dec 3 17:25:43 2013
r2 W! z- {6 _
' I4 g8 I, j. \$ @) A9 {! J5 dCopyright (c) 1982, 2010, Oracle. All rights reserved.0 Z1 O" o6 F7 O0 \- Y. c
. g* `' _# T+ d) d( @. A* ^SQL>1 H% e4 F9 y; R0 h8 y2 o, {$ l. w
SQL> connect / as sysdba E% ?! T/ M+ g$ {7 _8 e! b
Connected.6 y8 J9 s5 Z! B9 g/ A" o9 q
SQL> L4 V5 F: w2 y4 [- }" P* [1 G- x
SQL> alter user infodba identified by infodba;& ?; `. f0 r t" E/ y
6 Q% ^2 a3 b) G& I; w4 j4 h9 R% AUser altered.; a1 I* [+ E# `8 F3 l! z! j
* r; V3 H4 B* ~
SQL>
. M: x5 S1 ^" Z% I8 h0 NSQL> select expiry_date from dba_users where username='INFODBA';
8 Z0 B1 ~6 _7 p! ~7 V6 q; e2 V! {* N+ F5 }" H/ s) C. W4 _! f
EXPIRY_DA8 B; k( B9 ?9 v" Q1 [# T
---------
( \ ~3 k7 [6 u6 | o01-JUN-14
* K6 t; H2 {( p F0 U* p- p! a- I) j9 {0 m( S
SQL>
; s- }# X' K. @% PSQL> select profile from dba_users where username='INFODBA';
4 T1 j# G% B. s7 Z4 y) U2 i. @& Y& g& m: D s
PROFILE# C) S1 ?) ]# R! t+ Y: ]
------------------------------
* C1 d# [; k d( j m* Y% zDEFAULT
- c6 T3 |* B. a
( ~* ~) M. w2 c) q' q5 V4 {SQL>
# g5 s+ R7 |; t' kSQL> alter profile default limit password_life_time unlimited;$ J: [2 F3 f& R* m3 M) g9 }
7 T8 f3 I1 ^4 RProfile altered.$ K$ G1 Z/ G; v' l% p3 {, ~
2 O5 w, k6 T3 C6 ^. gSQL>
( C0 G4 F! F: U5 xSQL> select expiry_date from dba_users where username='INFODBA';' P, n8 P2 h# [
$ k. A7 K; L4 _0 I
EXPIRY_DA
! d& f% k$ {/ j# [: W---------
; H) b3 ^' A* c0 g7 ~! O: a4 W5 k+ ]* n) X
SQL>
: v4 R5 ~( S6 z+ y6 KSQL>
h! s4 E1 a! Z# |1 C) b+ O
# l) T/ B0 |* c; f' N* ?# ?+ f6 k- r5 x- j8 x- k
|
|
[复制链接]
|小黑屋|手机版|PLM之家-企业数智化转型工业软件学习平台
