|
|
admin
发表于 2014-7-20 12:28:10
Solution
: N, y. C+ x0 w( p; y1 Z# O
4 b x7 ]4 x' J% ^6 bThis is due to the Oracle Password having expired and needs to be reset.
+ ^# O( Z7 v, \5 d! ^( K+ Z. Y0 \( m( r
Perform the following in a OS CMD window making the necessary changes for your
8 B% K6 b: B) D* |$ c3 Yenvironment and directory structure.
2 x4 y# b" v' ~& f3 Y' \6 g+ z2 C: c! h9 n
--$ b! d" @* ?! _& |! h! Z* A
set oracle_home=C:\Oracle\product\11.2.0\dbhome_1 J/ E6 t4 }8 `0 t
5 f' `& H) u% a3 e# Nset oracle_sid=tc7 Y0 o5 A l# N: c& l
6 A' j5 Z& S- \, `: \1 }%oracle_home%\bin\sqlplus /nolog/ `( j$ H W9 J' n# R( P A
' L* u" m0 W/ q5 L% V
connect / as sysdba8 m; B" E' f u5 c1 p: |
: R3 q5 n7 f4 A% {, Ialter user infodba identified by infodba; Z0 B. P8 i1 W
" P7 m4 T! K' r6 Z* ~6 S. wselect expiry_date from dba_users where username='INFODBA';3 ~9 Q& ]. h. g% h7 ]4 _& [6 h
W; T9 y4 k! I5 eselect profile from dba_users where username='INFODBA';
- S3 v2 v5 n( {) n6 q3 @& j; n
0 b% D) W4 ~2 n4 i" l" }alter profile default limit password_life_time unlimited;. T. D, ?% _# A- C
Y- Z: N3 {. `select expiry_date from dba_users where username='INFODBA';( f3 a ?4 J" m6 u0 D" G
--
& q& v, q3 X0 [. e/ \/ m* x# f8 b; _$ @8 C- C% G
Expected output in command window.) l+ C% H1 I" U. x
==! m0 H6 T( O* e% A/ \
C:\Users\<user id>>set oracle_home=C:\Oracle\product\11.2.0\dbhome_1
, f2 [0 a3 f# M: n/ b e% ~! } |7 x
C:\Users\<user id>>
. i- n& f3 G- y1 v7 sC:\Users\<user id>>set oracle_sid=tc! x6 A, y. \1 E, t8 d
* G2 p$ ~0 W0 d" S9 t$ C0 r
C:\Users\<user id>>
5 l [; O7 o E' S% ?/ {& F% \C:\Users\<user id>>%oracle_home%\bin\sqlplus /nolog
2 y+ B Z+ r3 L. k2 x1 M3 A: K9 p/ ~: D- k/ M* ]8 T* G
SQL*Plus: Release 11.2.0.1.0 Production on Tue Dec 3 17:25:43 2013 | a$ Z6 I" f4 L. U# I, [8 S
! _4 D) h& w' \/ J: r4 k; SCopyright (c) 1982, 2010, Oracle. All rights reserved.
p( y; A3 |; ?+ u4 Z
) Y9 u* c1 y3 R) O- V" l: a- }: hSQL>3 N8 O K6 ~5 H! B+ A6 I+ ?9 ~
SQL> connect / as sysdba
" d/ o; T5 p$ K, I- ^Connected.
* S# u- S6 ~. `( X) }: c$ l2 B( u vSQL>2 {& V6 |( j6 _' ]4 \4 w2 U% L3 L3 }
SQL> alter user infodba identified by infodba;
& z; i; k5 @% T/ G$ i1 q1 t6 V5 c
User altered.
/ a& d' D5 p6 Y5 m. o3 j/ F7 R% U4 b/ k9 j
SQL>" N7 T9 o- l. r7 l$ @
SQL> select expiry_date from dba_users where username='INFODBA';
0 a3 V9 P2 k- K: o; _. f0 b1 y
/ s. E h' q* g! v# SEXPIRY_DA6 w- Q. S+ I( \" n8 E; P' g8 y* s
---------
1 U0 K& m, K) C6 s! ?01-JUN-148 N- D" l0 n( ?3 w
% o1 |. F0 a! w# j9 USQL>. C0 O0 ^) v6 ?. T# ]6 D* Z
SQL> select profile from dba_users where username='INFODBA';( S7 V: }2 X) {5 E: t6 L2 m
5 ?3 i/ b2 P1 ^0 @8 P
PROFILE8 H, ?" M& o! G9 n, u' G
------------------------------
3 D3 Z# M" X$ X# bDEFAULT; J- }7 G2 h& h
8 e8 }. X5 A3 x: @SQL>8 ^) `4 h+ Q3 l
SQL> alter profile default limit password_life_time unlimited;
4 p& T2 e9 a: W9 g; e& U* A7 H2 r) p* s0 ~, v
Profile altered.
/ ~3 ^( p8 H* q% y2 |) |8 u. G. y$ p) M3 v1 y3 F6 x
SQL>6 {- p D4 j: n
SQL> select expiry_date from dba_users where username='INFODBA';
' t0 {# X; \0 a J3 T9 c t
9 R2 V# J+ p$ _+ n8 \! T+ BEXPIRY_DA i m3 U0 \. e4 w4 T
---------
+ G' G/ n# e' W$ z5 R$ P) v" \. f( y. z C: j$ W6 n' l
SQL>+ f z/ J4 U7 |1 Z5 E. U6 G
SQL>
" A& R/ w3 O% [% h {) U; k' |- Z2 \" w/ [, u% F0 K
% w- |/ {) X- Q: f0 s
|
|
[复制链接]
|小黑屋|手机版|PLM之家-专注工业软件生态建设，大模型CAD创新生态
