How to modify the Oracle 11G password after the expiration of 180 days, oracle11g
Due to the new features of Oracle11G, often encounter the use of sqlplus login oracle Database prompts "ORA-28002: 7 days after the password will expire" and so on. The default password expiration
Warning:your Password has expired. Password change Required but no TTY available.Prompt for password expiration,To set the expiration time for a new user passwordThe following example:[[email protected]/]# passwd-x Euser, after the operation, the
racle11g, after a silent installation, the user's password expiration is set to 180 days by default, and after 180 days the password expires and Oracle prompts to change the password. Our project uses JDBC to connect to Oracle database, unable to automatically handle this kind of Oracle
Problem description: the customer reports that the client cannot connect when it cannot log on to the application.Environment: AIX 5.3 + Oracle 11gR2Solution: remote Telnet to the Database Host, sqlplus/as sysdba after the connection operation is normal, indicating that the database server should be normal, and then in the client to connect to the database with sqlplus prompt Password Expiration error: ORA-
There are generally two possible reasons for password expiration:
One, due to the default in Oracle set "Password_life_time=180 days" in the defaults profile.
Second, the default profile in Oracle is set to "failed_login_attempts=10", which causes this problem when the number of password errors reaches the set value.
The first case resolution is as follows:
1
Tags: oracle password expirationOracle System account password expiration resolution.The password for the system account is valid for 180 days, and when the password hint has expired,This can be resolved in the following ways:1> input sqlplus in DOS window, prompt to enter a
By default, the database locks the user after 10 failed attempts;
1. view the FAILED_LOGIN_ATTEMPTS Value
Select * from dba_profiles;
2. Change it to 30 alter profile default limit FAILED_LOGIN_ATTEMPTS 30;
3. Change it to an unlimited number of times (not recommended for security reasons) alter profile default limit FAILED_LOGIN_ATTEMPTS unlimited;
User unlock:
Alter user user_name account unlock;
Oracle Password
Sometimes when you log in to MySQL, the password expiration prompt is prompted, such as:650) this.width=650; "src=" Https://s4.51cto.com/wyfs02/M02/8E/E6/wKioL1jPPGnBHHRDAAAQ6eqyaJ0296.png "title=" Clipboard.png "alt=" Wkiol1jppgnbhhrdaaaq6eqyaj0296.png "/>At this time, the client window will not be able to log on to the MySQL database server, but through the command line operation, you can log on to the My
/wKioL1SMRQCQpTzBAAA67zhd6DA882.jpg " title= "view site directory. jpg" alt= "wkiol1smrqcqptzbaaa67zhd6da882.jpg"/>4. View the JDBC file configuration for the client site connection to the Oracle database:650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M01/56/BE/wKioL1SMRdXi2F3TAACTM9BFS0Y977.jpg "title=" Web site Connection database JDBC configuration. jpg "alt=" wkiol1smrdxi2f3taactm9bfs0y977.jpg "/>5. View the user name of the Web site in the Oracle database:650) this.width=650; "src="
How to set the connection expiration time in the email after retrieving the password is shown in the following figure: I have used PHPMailer to send emails.
However, how should I generate a hyperlink to change the password that should be sent to the user, and how should I control its expiration time?
Please give me s
This is when I just finished installing the system to change some policies for password-free sharingRemoved guest who denied access to this computer from the networkNetwork access: Sharing and security model for local accounts changed to guest only-authenticates local users with guest statusNetwork access: Apply the Everyone permission to anonymous usersAfter you have modified these, you will be able to access the
Problem descriptionCustomer reflects the system can not login;ReasonThrough testing, it was found that the Oracle user password expired, mainly because "password_life_time=180 days" was set by default in oracle11g in the defaults profile.WorkaroundThe method of writing online is basically the same, refer to the article for modification.1, check the user's proifle is which, is generally default:Sql>select username,profile from Dba_users;2. View the
ORACLE 11G Password Expiration issue:1. Use the Oracle user to enter the SQL Editor to execute the Change password (original password, remain unchanged) commandSql>alter user username identified by "password";2, the view user's proifle is that, generally is the default:Sql>s
MySQL user password expiration function detailsMySQL user password expiration function details
Two terms are described first.
Payment Card IndustryThat is, the payment card industry. The PCI industry represents debit cards, credit cards, pre-payment cards, e-wallets, ATM and POS cards and related businesses.PCI DSSThat
The Oracle11g startup parameter resource_limit takes effect regardless of whether it is set to false or true. Therefore, you must modify the password in the preceding method. The preceding account name
Whether set to false or true, the Oracle 11g startup parameter resource_limit takes effect for the password validity period. Therefore, you must modify the password
Label:The following error was used today in the Oracle times: ora-28002:the password would expire within 7 days===============================================ERROR:Ora-28002:the password'll expire within 7 days===============================================Prompt password expires, due to the need to connect the test database, so decided to set the password to nev
How to modify the Oracle Default user password expiration time
1, look at the user's proifle, which is generally default:
Sql>select username,profile from Dba_users;
2. View password expiration settings for the specified profile (such as default):
Sql>select * from Dba_profiles s WHERE s.profile= ' DEFAULT
Failure Phenomenon
Oracle 11g Database Common user logon prompt ora-28002:the password'll expire within 7 days
[11:01:00oracle@dvd db_1] $sqlplus wang/oracle
Sql*plus:release 11.2.0.1.0 Production on Fri Nov 16 11:01:23 2012
Copyright (c) 1982, 2009, Oracle. All rights reserved.
ERROR:
ora-28002:the password would expire within 7 days
Connected to:
Oracle Database 11g Enterprise Edition release 11.2.0.1.0-production
With the OLAP and Data Mining opti
This article describes in detail the user password expiration function of MySQL. For more information, see
Payment Card IndustryThat is, the payment card industry. the PCI industry represents debit cards, credit cards, pre-payment cards, e-wallets, ATM and POS cards and related businesses.
Pci dss,That is, the PCI Data Security Standard (Payment Card Industry Data Security Standard) is developed by the PCI
Original works, from the "Blue Blog" blog, Welcome to reprint, please be sure to indicate the following sources, otherwise, the legal responsibility to pursue copyright.Deep Blue Blog:http://blog.csdn.net/huangyanlong/article/details/44001867After logging into the operating system, how to resolve the password expiration?Original works, from the "Blue Blog" blog, Welcome to reprint, please be sure to indicat
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.