-------------使用如下命令------------------
SELECT * FROM dba_profiles s WHERE s.profile='DEFAULT' AND resource_name='PASSWORD_LIFE_TIME';
ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED;
alter system set processes = 5000 scope = spfile;
alter system set O7_DICTIONARY_ACCESSIBILITY=false scope=spfile;
alter system set remote_login_passwordfile=NONE scope=spfile;
shutdown immediate;
startup;
lsnrctl status
.............................................具体操作..............................
Connection established.
Escape character is '^@]'.
Last login: Thu Dec 6 14:49:49 2018 from 10.10.1.220
[root@oracledb ~]# su - oracle
Last login: Thu Dec 6 09:16:38 CST 2018 from 10.10.1.220 on pts/0
[oracle@oracledb ~]$ source /home/oracle/.bash_profile
[oracle@oracledb ~]$ sqplus / as sysdba
bash: sqplus: command not found...
[oracle@oracledb ~]$ sqplus / as sysdba
bash: sqplus: command not found...
[oracle@oracledb ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.1.0 Production on Thu Dec 27 16:52:21 2018
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> SELECT * FROM dba_profiles s WHERE s.profile='DEFAULT' AND resource_name='PASSWORD_LIFE_TIME';
PROFILE RESOURCE_NAME RESOURCE
------------------------------ -------------------------------- --------
LIMIT
----------------------------------------
DEFAULT PASSWORD_LIFE_TIME PASSWORD
180
SQL> ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED;
Profile altered.
" - rest of line ignored.
SQL> ^[[A^[[A
SQL> 042: unknown command "
SQL>
SQL>
SQL> SELECT * FROM dba_profiles s WHERE s.profile='DEFAULT' AND resource_name='PASSWORD_LIFE_TIME';
PROFILE RESOURCE_NAME RESOURCE
------------------------------ -------------------------------- --------
LIMIT
----------------------------------------
DEFAULT PASSWORD_LIFE_TIME PASSWORD
UNLIMITED
SQL> alter system set processes = 5000 scope = spfile;
System altered.
SQL> alter system set remote_login_passwordfile=NONE scope=spfile;
System altered.
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup;
ORACLE instance started.
Total System Global Area 1.3429E+10 bytes
Fixed Size 2217992 bytes
Variable Size 7650412536 bytes
Database Buffers 5704253440 bytes
Redo Buffers 71770112 bytes
Database mounted.
Database opened.