Shulou(Shulou.com)06/01 Report--

The server, of course, provides oracle database services, as well as listening services, which are used to receive client connections.

The client provides a set of tools, including library files and header files used for development, similar to client sdk in informix, or some utilities, such as sqlplus. The client is responsible for communicating with the server.

The pl/sql developer or toad mentioned by someone is a third-party development tool that works on oracle client.

one

Check which user's proifle is, usually default:

Sql > SELECT username,PROFILE FROM dba_users

two

View the password validity settings for the specified profile, such as default:

Sql > SELECT * FROM dba_profiles 's WHERE s.profileholders default AND resource_name='PASSWORD_LIFE_TIME'

three

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

ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED

After the modification, there is no need to restart the database, it will take effect immediately.

four

After modification, accounts that have not been prompted for ORA-28002 warning will not encounter the same prompt again

Accounts that have been prompted must change their passwords again, for example:

$sqlplus / as sysdba

Sql > alter user smsc identified by-there is no need to change a new password

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.