|
|
admin
发表于 2014-7-20 12:28:10
Solution# x# C/ Z" O7 r/ K' v6 I9 k4 @
* _( q9 Z0 d% `( e, o; Q1 \$ DThis is due to the Oracle Password having expired and needs to be reset.8 L# ?/ U: J5 W0 r4 A9 u
/ z. x; c# ?& A* A7 g$ O* {, a( XPerform the following in a OS CMD window making the necessary changes for your
2 C0 p% R9 R& F' U0 h2 ienvironment and directory structure.! _9 t# N4 r/ }4 e4 M7 m
( Q" j! E- x7 t9 w# B--$ I- S4 D! {& k4 e8 {5 a- m
set oracle_home=C:\Oracle\product\11.2.0\dbhome_1. {) R* V6 R9 z1 J% m+ R' |% k# t+ w6 v
& _* e- X+ M, t$ e8 H
set oracle_sid=tc
5 z5 U+ A1 A( K. Q3 A& i4 S1 S% Z6 V* @6 ?+ v2 t# R
%oracle_home%\bin\sqlplus /nolog
$ ]' X5 g6 ~( c/ N p5 \; _6 d) s; _# v
' J. T; ?: E4 \2 [: @) G3 Qconnect / as sysdba
$ _% J9 P3 t2 k, U5 ]# M/ A; J* \; b* d% h, A2 H( s) N) M
alter user infodba identified by infodba;
* \- c/ Z/ `4 Y
/ C& z% l8 D; l( i3 J) A2 M% zselect expiry_date from dba_users where username='INFODBA';
6 ^) m* P+ p {* h
5 ?# N& b s w, [9 {select profile from dba_users where username='INFODBA';
6 [+ [6 B) }/ ^7 h7 S3 _- v* e) o/ l9 g
3 N4 M6 x$ m! B7 xalter profile default limit password_life_time unlimited;
. n+ O- S+ p. I) J5 }) w( R1 Q' \. \) ]1 ]. D
select expiry_date from dba_users where username='INFODBA';2 K! s3 P" I+ @+ I. U
--2 i1 p% x( _4 y# ?
. r0 @( b2 B$ x. U7 ~# J EExpected output in command window.
3 ^4 L" p3 c' m6 v" g- k==+ q# `0 T3 q. Q8 m
C:\Users\<user id>>set oracle_home=C:\Oracle\product\11.2.0\dbhome_1
! s( [! E6 `6 z' p; s9 d8 L8 o* U* L* u" F# r' o
C:\Users\<user id>>
, x5 X, i7 U5 D! T: V# E* h! q* \' PC:\Users\<user id>>set oracle_sid=tc
, r$ R' N! f0 i$ {
" M& t! U# ?3 L2 U7 x0 w+ BC:\Users\<user id>>+ J& D. O' f5 s; k& g- T; Q5 I( x
C:\Users\<user id>>%oracle_home%\bin\sqlplus /nolog( @7 f, ?! r2 t0 C
' J$ t0 r2 I: Y" X
SQL*Plus: Release 11.2.0.1.0 Production on Tue Dec 3 17:25:43 2013
$ d: O: ]8 A% {( Q
2 a6 k7 W* U( x2 GCopyright (c) 1982, 2010, Oracle. All rights reserved.5 `) m& c/ X+ ~0 j' ]" `9 L- F
! R5 c1 e- H' }
SQL>% Q+ `: Q" L/ |7 v9 \1 r/ K
SQL> connect / as sysdba
" a: b4 {* U4 ?5 [ NConnected.
% J: `, g- @3 ~( A4 a) CSQL>4 t4 f: Z$ J" ~1 Y) e; y l
SQL> alter user infodba identified by infodba;# O% v: d+ H, q
: Z! M/ ?7 k; h: ]: Z( lUser altered.
; \* ], O# A) ]/ p( g: [
9 ^9 R! v( z# h( N4 iSQL>+ s: p2 u: R3 u% I: U2 ~
SQL> select expiry_date from dba_users where username='INFODBA';
' h$ v+ b3 o. j9 g5 Z/ k2 \% a- l" |$ u/ w( J8 d. M
EXPIRY_DA
. n, U7 x; b; V5 P. e! j---------
9 ~6 `# e3 J3 Z% G9 Y, ~8 t01-JUN-14
' {5 ? h& M6 X# i) V, C
9 y% ]. k/ }: _% N9 f+ iSQL>7 x9 a/ i6 p, s6 t4 S: y
SQL> select profile from dba_users where username='INFODBA';' ]9 I' a2 p/ b7 X, Y. ~
& O# c) Q8 W3 x/ E* P; a6 pPROFILE
f6 F# D% T: p. l- s, q------------------------------: q6 W+ ~7 c: Z- V$ Q2 O& q, ]3 P
DEFAULT5 R, |! Z, {* g$ A2 i8 l
1 \& p1 X% P4 d ~& bSQL>' N" w/ q7 _8 Z( n9 M4 h+ D/ b
SQL> alter profile default limit password_life_time unlimited;: P x+ ]& t' ^8 @
G! t0 y: Q } f
Profile altered.
0 g- {$ \' }% c$ P9 H% A0 |" w, N+ J* X1 ~) {, k/ i; E# _
SQL>+ L5 h# ^- h" `% d$ b# p. V
SQL> select expiry_date from dba_users where username='INFODBA';0 R6 K3 S! h' }5 z+ y5 X2 b [! @: K" s% E
k) I9 O& Q- ]6 }/ M
EXPIRY_DA
* `# i7 I" u; C9 y3 Y) p8 F6 E---------
$ E. E& f5 O$ b, U- @+ g f! H! l! j D% [' j, h: G
SQL>
3 _5 X. P+ I) T' m' oSQL>7 T H3 a, ? j
. V2 b6 `; A% q# _1 I
+ [* F; ]& L. i7 o$ _; Y1 y# u |
|
[复制链接]
|小黑屋|手机版|PLM之家-企业数智化转型工业软件学习平台
