1. SQL Plus?? DBA? ???

??? ??/password@serverSID? sysdba?

?? 1: (??? ????? ??? ???.)

C:/Documents and Settings/ssy>sqlplus sys/system@test as sysdba

SQL*Plus: ??? 9.2.0.1.0 - ???: 3? 17? ??? 18:01:41 2008 ???( c) 1982, 2002, Oracle Corporation. ??: Oracle9i Enterprise Edition ??? 9.2.0.1.0 - ????, OLAP ? Oracle ??? ??? ?? JServer ??? 9.2.0.1.0 - ????

?? 2:

C:/Documents and Settings/ssy>sqlplus /nolog SQL*Plus: ??? 9.2.0.1.0 - 2008? 3? 17? ??? 17:59:08 ?? Copyright (c) 1982, 2002, Oracle Corporation.

SQL> conn sys/system@test_192.168.80.38 as sysdba 已連接。
SQL> quit

3. ??? ???? ???? ?? ?? ??? ?????(?: ???). :

sql>SELECT username,PROFILE FROM dba_users;

4. ???? ?? ??? ?? 180??? "???"?? ?????:

sql>SELECT * FROM dba_profiles s WHERE s.profile='DEFAULT' AND resource_name='PASSWORD_LIFE_TIME';

?? ? ?? ?? ??????? ?? ???? ?? ?????.

ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED;

5. ?? ??? ORA-28002 ?? ???? ???? ?? ???? ??? ???? ?? ???? ????.

???? ??? ??? ????? ?? ???? ???. ?:

??? ??/????@serverSID(sysdba)

$sqlplus / as sysdba
sql> alter user smsc identified by <原來的密碼> ----不用換新密碼1、在SQL Plus下，以DBA身份登陸

?? 1: (??? ????? ??? ???.)

C:/Documents and Settings/ssy>sqlplus sys/system@test as sysdba

SQL*Plus: ??? 9.2.0.1.0 - 2008? 3? 17? ??? 18:01:41 ?? Copyright (c) 1982, 2002, Oracle Corporation. ?? ??: Oracle9i Enterprise Edition ??? 9.2.0.1.0 - ????, OLAP ? Oracle ??? ??? ??? ??? ???? JServer ??? 9.2.0.1.0 - ????

?? 2:

C:/Documents and Settings/ssy>sqlplus /nolog SQL*Plus: ??? 9.2.0.1.0 - 2008? 3? 17? ??? 17:59:08 ?? Copyright (c) 1982, 2002, Oracle Corporation.

SQL> conn sys/system@test_192.168.80.38 as sysdba ???.

SQL> ??

2. ????? ???? ??? ???? ?????.

3. ??? ??? ???? ?? ?? ??(?: ???):

sql>SELECT username,PROFILE FROM dba_users;

4. ???? ?? ??? ?? 180??? "???"?? ?????. :

sql>SELECT * FROM dba_profiles s WHERE s.profile='DEFAULT' AND resource_name='PASSWORD_LIFE_TIME';

?? ? ??????? ?? ??? ??? ??? ?? ?????.

ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED;

5. ?? ??? ORA-28002 ?? ???? ???? ?? ???? ??? ???? ?? ???? ????.

???? ??? ??? ????? ?? ???? ???. ?:

?? ??? Oracle ??? ????? ???? ??? ???? ?? ???? ???? ? ?? ?????. ???. ???? ?? ??? ????? ?? ?? ?????????. ?? PHP ??? ????? ??? ?? ?? ??? ??????!

$sqlplus / as sysdba
sql> alter user smsc identified by <原來的密碼> ----不用換新密碼

Oracle ??? ????? ???? ??? ???? ? ?? ??? ?? ??? ?? ??? ??? PHP ??? ????? ?????!