Oracle database 12560 and Change password to Permanent

The programmer in the small factory also has to toss Oracle maintenance. Here's a simple record of some of the problems that the Oracle database server encountered and resolved when it was used.

1. On the Oracle database server (the machine on which the Oracle database is installed), you can use the command "sqlplus/nolog" (cmd command) and "Conn/as sysdba" (SQL command) to log on as a DBA, without a password. Here's the principle.

2. When you use the "conn/as sysdba" command on an Oracle server-side server, and you open the two most critical services, "monitoring service Listerservice and database service Yoursidservice", still reporting 12560 errors, you should

A. Log in using the "conn Sys/[email protected] as SYSDBA" command

B. After the cmd window "set Oracle_sid=yoursid", reopen a new CMD window (at which point the previous command takes effect) and log in using "Sqlplus/nolog" and "Conn/as sysdba".

If you know the password of SYS is recommended method A.

3. Oracle's passwords often expire for several months, resulting in systems that are delivered to the user that are not working properly. So, for a small factory programmer, this is disgusting. Therefore, it is necessary to modify the age of the account password for Oracle. Change to Unlimited.

Key statement: ALTER DEFAULT LIMIT Password_life_time UNLIMITED;

1, check the user's proifle is which, is generally default:

Sql> SELECT username,profile from Dba_users;

2. View the password expiration settings for the specified profile (such as default):

Sql> SELECT * from dba_profiles s WHERE s.profile= ' DEFAULT ' and resource_name= ' password_life_time ';

3. Change the password validity period from the default of 180 days to "unlimited":

sql> ALTER profile DEFAULT LIMIT password_life_time UNLIMITED;

You do not need to restart the database after you modify it, it takes effect immediately.

4, after the modification, has not been prompted ORA-28002 warning account will not encounter the same prompt;

The account that has been prompted must change the password again

sql> ALTER user < username > identified by < original password >----do not change the new password

< finish >

Oracle database 12560 and Change password to Permanent