|
|
admin
发表于 2014-7-20 12:28:10
Solution: c/ F: K- |) X3 M6 n2 m5 A
$ x, k8 ?" l' t' \( s9 \This is due to the Oracle Password having expired and needs to be reset.
+ U) }- W+ x1 X
$ X R. E' [( ]% J# {. H0 IPerform the following in a OS CMD window making the necessary changes for your
/ L5 ~" x( C4 l! p1 ^/ Wenvironment and directory structure.
% b. \9 `5 `0 G6 U7 ~
8 P0 S, [2 i% N- p3 W. F& v8 N--
9 S. T9 ~% `% a0 b2 Dset oracle_home=C:\Oracle\product\11.2.0\dbhome_1* A1 X4 C5 }% g! i. S; n7 ?# Z
' P9 l' ]; R5 c8 e% g& j- c; }9 wset oracle_sid=tc: S, D$ n. Y" t
3 C3 P" M0 K7 K%oracle_home%\bin\sqlplus /nolog$ i1 e- n" y! x3 W
% l9 L1 x4 X0 L3 Fconnect / as sysdba8 Q9 Q R. j5 ?4 L
; m! ^8 n, ]2 Salter user infodba identified by infodba;7 |. B% D2 S2 z( O8 O$ a( ^
- S' \3 E# e4 o( ]! yselect expiry_date from dba_users where username='INFODBA';: k( ~4 e" T5 V# I* u* N
8 w# G5 G v. \select profile from dba_users where username='INFODBA';- F8 d9 d% M% f$ b' U, U$ j
* h- p/ ^9 M% g o% ?2 D+ l) k- a
alter profile default limit password_life_time unlimited;4 x" y8 B6 {9 v z2 Q
3 N" |- {6 g5 y/ n( Q8 Q! S" u
select expiry_date from dba_users where username='INFODBA';
# `: r, c" W5 h. o- H6 b7 N--
" ?1 g7 k# r3 L; `- j1 ^
9 y0 s, m7 j/ A" k, z. OExpected output in command window.3 O2 f0 ^- N+ f8 v# x
==( P) O. p t, ~$ o$ _4 i3 {
C:\Users\<user id>>set oracle_home=C:\Oracle\product\11.2.0\dbhome_1
6 C- X# T6 b( j W; c; S U2 G4 |8 b# c2 W
C:\Users\<user id>> o4 \% \" f- h1 }- f/ N _: t( I
C:\Users\<user id>>set oracle_sid=tc
2 q5 p! A6 |6 O+ U; O6 u$ n' a6 X9 X1 g. f/ |% A( v6 g
C:\Users\<user id>>
% P/ F5 J. ?+ s/ F2 U4 h# A: s0 YC:\Users\<user id>>%oracle_home%\bin\sqlplus /nolog0 I9 D+ w* [# D4 F% ? c; K
2 M$ [% M$ b1 h# c0 a
SQL*Plus: Release 11.2.0.1.0 Production on Tue Dec 3 17:25:43 2013
1 X+ \. ]9 R: W! z; }
9 D: E- w3 o9 ?3 LCopyright (c) 1982, 2010, Oracle. All rights reserved.5 N. [2 Z6 K+ c
( a" F& z. y1 c, Z2 VSQL>3 b* V8 x" [0 G6 u8 {
SQL> connect / as sysdba% Y6 u: K7 x0 c' I
Connected.: z+ n7 D6 ~, f# R$ ]9 e+ M
SQL>+ r$ H ~" H4 J0 s0 B
SQL> alter user infodba identified by infodba;
; V( D- ]7 g9 a1 W$ p6 S
- K( |/ d# y7 T" JUser altered.5 v* n3 \# e: B5 j
7 }3 i2 M, [, N. nSQL>: P/ g' V( R& W' D; p# Z0 H9 f+ N- f
SQL> select expiry_date from dba_users where username='INFODBA';+ R$ x! \% Q; g, m5 A: T" q
0 o: q& L+ P, |; h
EXPIRY_DA3 j/ X& R2 h# a3 C5 }* p
---------
4 n% O+ f) c- N01-JUN-14- b! S/ A; Q. I+ u: Z9 R1 j ^
2 m. W) I' y: a( Y* H
SQL>& M0 v$ Y$ Y" q5 D
SQL> select profile from dba_users where username='INFODBA';$ a8 X/ l. W8 @2 a# n a( A- P
! P7 l4 I0 }3 Z y S
PROFILE
0 l( g, n0 b/ G# U# ]6 q------------------------------
( X, j. U" c% I: |DEFAULT* f4 o5 W4 \# J
% `$ @( W. U; O: i
SQL>
( p1 G/ K8 |; ZSQL> alter profile default limit password_life_time unlimited;$ u1 c7 V4 A, K" T7 N2 k/ Q ?* Z
" G' F7 c; ?& U" ~- q7 A: N0 lProfile altered.; ~& ~( _5 G3 ~
: l, E/ y* U. \: e- \4 |0 ~6 G
SQL>: i, r! H0 X& |. k: {+ W9 }
SQL> select expiry_date from dba_users where username='INFODBA';
8 J2 I& t4 J; R
2 {8 p) I1 I% m6 jEXPIRY_DA
, \* ?$ d0 u+ ~---------5 S1 A" @% `2 z! \4 X4 ]
5 C0 Z' b' ?) i9 q- h0 [
SQL>& `" x+ ?" N( A" h, n4 t/ K* R
SQL>3 y( X) s% K, I( S P
, B* w. W4 v( j/ B1 E* Q
' J! C7 m- g. }# ? k+ u5 h4 Y% v+ h |
|
[复制链接]
|小黑屋|手机版|PLM之家-企业数智化转型工业软件学习平台
