ORACLE Account Tips EXPIRED (GRACE) Problem Solving2013-01-30 15:09:24Tags: Oracle userOriginal works, allow reprint, please be sure to use hyperlinks in the form of the original source of the article, author information and this statement.
Oracle 11g password expired lock reported ORA-28000 the account is locked, 11gora-28000
I. Reasons for triggering this error and Related Factors
This is because "PASSWORD_LIFE_TIME = 180 days" is set in the default profile in oracle11g by
1. When Oracle UCM is started, the console reports an error.The following exception occurs when you view logs:
------
#### Java. SQL. SQLException: ORA-28001: the password has expired
------
Java. SQL. SQLException: ORA-28001: the password
After installing Oracle 10g, you want to open sql*plus to learn, and then follow the steps in the book to connect to the database with Scott users, you can lose several times prompted an error.
Error:the account is locked
Then after checking the
Yesterday, we received guests from Beijing and showed us our new system. Unfortunately, our normal system cannot be started at this critical moment. After searching the event logs, confirm that the problem lies in Oracle, and then configure the net
Problem Status:SYS, System user's password expires, unable to login.Error--ora-28001:the Password has expired (DBD Error:ocisessionbegin) after running the EM consoleWorkaround:1. Open SQL PLUS, enter user name sys/oracle as Sysdba2. Execute script--
One, the user password is about to expire, causing autotrace cannot openIf the user password is about to expire, you will receive the following prompt when you log in to the database:ERROR:Ora-28002:the password'll expire within 7 daysOf course, the
Oracle users seldom pay attention to their passwords. Generally, the password expiration time is set to never expire after the database is installed, but an error occurs when autotrace is enabled.
Oracle users seldom pay attention to their passwords.
The following ERROR was reported when logging on to the database: ERROR: ORA-28002: thepasswordwillexpirewithin7days the default profile was not found before Oracle11g
The following ERROR was reported when logging on to the database: ERROR: ORA-28002
The following error is reported during database Logon:ERROR: ORA-28002: the password will expire within 7 daysThe default profile of Oracle before 11g has no restrictions on password expiration. in Oracle 11g, the default profile enables the
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.