Skip to content

Oracle Database: Reset User Password and disable passowrd expiration.

● cpx October 17, 2013 1 min read Database Oracle/ORA_PMON/1521 
SQL> select resource_name,limit from dba_profiles where profile='DEFAULT' and RESOURCE_NAME='PASSWORD_LIFE_TIME';

RESOURCE_NAME                    LIMIT
-------------------------------- ----------------------------------------
PASSWORD_LIFE_TIME               180

alter profile DEFAULT limit password_life_time UNLIMITED;
alter user oblicore identified by oblicore;

 

# recommended

posts that share tags with this one
Database

SQL Performance Optimization: Finding the Right Queries to Fix

# contents11 sectionscollapse01The Impact of Query Optimization02Query Identification Methods03Method 1: Debug Bar Analysis04Method 2: MySQL Slow Query Log05Method 3: Non-Indexed Query Detection06Method…

2025-09-22 5 min read →
Academic # academic

MySQL vs MongoDB

2014-01-06 1 min read →
Oracle/ORA_PMON/1521 # oracle

Oracle unix DBA group

1.1) DBA Group ~~~~~~~~~~~~~~ The ‘DBA’ group is chosen at installation time and is usually the group ‘dba’ by default. The DBA…

2013-10-02 2 min read →

Be the first to comment

protected · no tracking

0 comments