|
|
admin
发表于 2014-7-20 12:28:10
Solution3 Q; m5 ^9 X/ j5 s% }" J0 f- P& P
1 Q' }% W5 N" F' r+ k) @This is due to the Oracle Password having expired and needs to be reset.
- G. b: x% z' [) U$ F# T# m" a0 }2 Q' M6 o
Perform the following in a OS CMD window making the necessary changes for your
- {2 Q* [1 ]4 x: m6 _- B2 h. g! _8 Jenvironment and directory structure.# g0 O& F. z0 F" D, }7 Y g
- t s. T9 Q' a- c
--
! k1 b6 ]$ z8 fset oracle_home=C:\Oracle\product\11.2.0\dbhome_1
* ^7 B7 J- I: j/ s# k( }. Y3 ~$ {; K4 g. E. p, o
set oracle_sid=tc7 R" D7 _' S `; B7 H
. F, z w5 U& ~% H, j/ k( a
%oracle_home%\bin\sqlplus /nolog
% P" C9 K& @. U. w5 ?& s
' T7 \1 f+ Q! b- Dconnect / as sysdba" a" |7 S( m( C* e
, g3 z2 _- y/ L! A+ c! Falter user infodba identified by infodba;
+ L9 u6 c N9 g/ t2 u+ r
?1 [, U: V V) e- Mselect expiry_date from dba_users where username='INFODBA';
1 ~( q* S, b, O( P5 f6 x8 ?! A
4 {2 l _& q# Iselect profile from dba_users where username='INFODBA';: @6 C3 H8 R* t A% D {) B
& [: y; ^# A! i; Nalter profile default limit password_life_time unlimited;; z! y; |2 t. i5 w: ?
! C1 @6 f/ r( F d. O+ o U
select expiry_date from dba_users where username='INFODBA';5 r) b3 [" m5 H; E1 B7 D
--( _3 r6 \/ \' Z9 m4 r- y7 [
! {' A9 w3 S t8 c* V; I3 D# wExpected output in command window.* t$ V5 `. ?5 {' v
==. e* n/ c0 w; E) w
C:\Users\<user id>>set oracle_home=C:\Oracle\product\11.2.0\dbhome_1
* |1 V1 d2 K) k
/ X9 `. {# p$ a0 P% K7 iC:\Users\<user id>>+ \# {9 Y! y% z; g
C:\Users\<user id>>set oracle_sid=tc( l* {" x$ w, h$ v3 i$ l
, d; ` S8 U/ J6 h3 W. EC:\Users\<user id>>2 Z2 N9 x, z. @$ ^& O5 U- k
C:\Users\<user id>>%oracle_home%\bin\sqlplus /nolog* B* h) ^ m& N
$ g2 Q" c/ h/ v, y
SQL*Plus: Release 11.2.0.1.0 Production on Tue Dec 3 17:25:43 2013
2 i; b3 y9 d; j1 i
5 a s" T" \6 I) r6 b& M5 j& yCopyright (c) 1982, 2010, Oracle. All rights reserved. A2 {) {5 l- x; `' [6 K4 g0 E/ K
- _) I' P4 t; D5 G2 f
SQL>6 A/ C1 \5 M+ w' ~( U$ M
SQL> connect / as sysdba$ S) P8 j- A2 J" T
Connected.
2 m/ r6 [/ Z \3 ?, M* B XSQL>
! }6 h7 g" K- F- I' s: d2 @ KSQL> alter user infodba identified by infodba;# K9 ?( k2 m q9 ~% }* Z, J! B
* g( S9 d \. h( ]User altered.5 f5 C5 v3 }2 f/ E. r. `
; C0 Z8 z# Y" f9 {3 P: rSQL>% M# t7 V/ B3 E9 n, y
SQL> select expiry_date from dba_users where username='INFODBA';8 ~: j! q# y! f7 I6 e) J, f
, o3 z+ a+ ]& y# Q+ l
EXPIRY_DA
5 x2 u" X6 E# B8 Z& n X---------
! |0 Z& F/ }, o# ?01-JUN-14
1 T2 {0 p+ d1 J
/ c. u5 s8 y7 {- L- w% t/ vSQL>+ X' E% q# {0 r4 Y) ^
SQL> select profile from dba_users where username='INFODBA';
d2 y1 ~$ b2 Y, U4 ]* U: P9 v: K9 _3 r P* N" l& Y& _
PROFILE% G2 l" L* h" _; G
------------------------------3 n/ d9 w- v2 K4 x# G
DEFAULT
1 J( w' t1 p5 q: r1 n/ i( x
3 j# `, U# Q4 z8 gSQL>/ V4 w' B0 H+ C) v
SQL> alter profile default limit password_life_time unlimited;
1 E4 Q5 ~1 w) w3 G7 B& W, V. k. ]1 p& H8 N* n; n) D
Profile altered.
. Y. Q$ J. P$ y9 A, V' g, [: c5 L+ J; l. E7 e- G) f
SQL>
4 Q' A- m, E' b% U- H0 p) DSQL> select expiry_date from dba_users where username='INFODBA';/ R; N1 {6 s! ^
# ~/ M' u. z. X7 \7 G& ]EXPIRY_DA
( A: V. f! M& p* M* p---------* }% j2 E$ J X5 {2 Q
! b' _5 K7 v7 QSQL>6 o( _ L. Y( ]) F5 |( ^) e8 ]
SQL>
; q) d0 @9 ]( j; h+ T2 _+ b9 a& u* {1 P/ J
$ n3 {! Z: F9 O2 Y: y; K |
|
[复制链接]
|小黑屋|手机版|PLM之家-企业数智化转型工业软件学习平台
