Daily Archives: February 10, 2014
Profiles and Password Verify Function – Oracle 11g
Verify Function is a quick and easy way to enforce quality of database passwords—for example, they should contain a certain number of characters, should not be identical to the username, and so on. In Oracle Database 11g, verify_fnction_11g function could be found on password verification file utlpwdmg.sql in $ORACLE_HOME/rdbms/admin. At the end of the script […]
SQL command to find size of Oracle database
######## datafiles size ########## SQL> select sum(bytes/1024/1024/1024) from dba_data_files; ######## actual database size ######### SQL> select sum(bytes/1024/1024/1024) from dba_segments;
ORA-00020: maximum number of processes (600) exceeded
bash-3.2$ export ORACLE_SID=ANARDB bash-3.2$ bash-3.2$ rman Recovery Manager: Release 11.2.0.3.0 – Production on Mon Feb 10 09:00:00 2014 Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved. RMAN> connect target /; RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== ORA-00020: maximum number of processes (600) exceeded RMAN> RMAN> RMAN> exit […]
anargodjaev.wordpress.com 