|
|
admin
发表于 2014-7-20 12:28:10
Solution2 S0 p3 s, }+ S
; G) W# B5 `' J
This is due to the Oracle Password having expired and needs to be reset.0 y" l4 C0 g6 g2 J
& c3 S9 x$ e& \Perform the following in a OS CMD window making the necessary changes for your
/ u( g8 O# O( w% A7 @5 tenvironment and directory structure.
- ?1 J2 l3 Y, R
$ M. {$ n0 B0 s* r+ Y--6 u8 O0 K, ] N( ^7 q
set oracle_home=C:\Oracle\product\11.2.0\dbhome_1
" [$ |( |+ {1 `
! |, z( t4 V( }2 x# B, E2 pset oracle_sid=tc
: t8 X$ Q# M. M, I( e* {( X- s: O9 K2 [ P
%oracle_home%\bin\sqlplus /nolog
3 V- v* c u( K n1 C3 l
3 o- C- j* U1 N' o- [$ G) iconnect / as sysdba. k: |/ A8 w& @# G
! G6 U) [2 z: U
alter user infodba identified by infodba;
9 ?1 Q3 {4 k( I' {* q `4 T' |: S/ R/ R) e4 O/ ?, E
select expiry_date from dba_users where username='INFODBA';1 l8 ], s' X2 R! d! r/ j7 b
3 Z% e" r5 ?* q5 ?7 R. ]9 g/ J4 R6 N
select profile from dba_users where username='INFODBA';2 R6 ?5 R E( A7 h% L
* `! \9 h0 [$ w% O8 U' R! b; l9 O
alter profile default limit password_life_time unlimited;
" j" O) g) n9 \1 d" V; K! z8 g, `# e! D. B; C
select expiry_date from dba_users where username='INFODBA';7 M: {0 K0 P+ b( L" Q
--
8 z8 A/ F2 D2 G1 p" }- o. P! r
% t) U- o) J3 M/ U1 ` p3 \Expected output in command window. E( V8 ^# G* b2 Y# A
==. L2 _) ?6 }0 q" r
C:\Users\<user id>>set oracle_home=C:\Oracle\product\11.2.0\dbhome_1
2 ^' M0 i/ h, }! a; f* Z* S0 C" J- W
C:\Users\<user id>>4 M0 ?3 U2 i, J' I' M
C:\Users\<user id>>set oracle_sid=tc: ]# J% s" _. p/ B
2 M2 a. S" e5 s% q A* \
C:\Users\<user id>>
, O; M! P$ N0 U8 g8 _C:\Users\<user id>>%oracle_home%\bin\sqlplus /nolog; Y+ `) F5 n4 H' [/ O6 g
8 p4 V: V) `! j. r1 C
SQL*Plus: Release 11.2.0.1.0 Production on Tue Dec 3 17:25:43 20133 A% G$ A3 Z& K: t3 t
8 M4 ^( z( d- ?& XCopyright (c) 1982, 2010, Oracle. All rights reserved.
/ A& l3 |5 j; i0 I7 M$ M8 d
7 Q M, C; s$ F' C' \( [2 SSQL>
0 ]( O" [9 v: z! y! W, vSQL> connect / as sysdba
& ?7 K3 O2 [" Y7 F3 ?" j/ OConnected.
( ?. K- q# u0 V5 x9 O5 w9 o MSQL>
2 ^' ]4 T8 @+ @, wSQL> alter user infodba identified by infodba;
( y+ o5 ~1 p- \! a! }
) w1 z7 P$ X I' ^ b% B9 }* MUser altered.
' R- [( L- m' d- A6 d, O
: i. u4 Y8 T* @( A2 S) u% v8 _! h1 aSQL>4 @, h- L: w' y! w
SQL> select expiry_date from dba_users where username='INFODBA';. f' x) |9 }2 m4 S! f6 P: z% M
0 O# A6 R* e4 H, n9 gEXPIRY_DA
3 x5 u& L, K, k- L. B---------
4 X$ I i9 f0 r01-JUN-14" c: ^0 M1 B/ k0 \4 @ @+ K
3 c/ O6 H* q6 W+ t2 mSQL>
8 N# G8 E7 O( k: m+ W$ nSQL> select profile from dba_users where username='INFODBA';0 h/ H2 a% x8 r5 U( S- m# ]
/ P* h8 \3 U1 L2 G
PROFILE
9 W+ D1 D( k+ _1 Q" w------------------------------
5 m4 g2 x6 f0 ]. ]DEFAULT( [# Q+ D8 u! ]; x! l6 {
/ t' Z: h4 L* G7 p. f4 ~. S% YSQL>3 ~6 x, ]: {9 X
SQL> alter profile default limit password_life_time unlimited;( @6 o# \2 k6 n0 ^
7 {+ Z; \( I @ S. T$ r5 g, tProfile altered., d% [% G- c. {% p' y% y4 n) u; S. I( R
( p+ ~: X' A( G" a( ~0 O" [( _SQL>( {5 k, A$ }- g
SQL> select expiry_date from dba_users where username='INFODBA';! O' b) [4 @5 M# h
8 p# R* L: @$ N
EXPIRY_DA
# A0 w( d! u0 L, Z1 c---------
7 R4 I% B2 `, F* M5 a/ {! O
; p2 o! `5 }: b- ESQL>
/ |& O' r1 P Z2 _SQL>
j/ \% T+ B0 H& ]+ o6 I# n& I7 p6 s" I
; U+ P) U$ e3 s" Q$ k% C* n2 l2 d |
|
[复制链接]
|小黑屋|手机版|PLM之家-企业数智化转型工业软件学习平台
