Protected: Oracle License SQL
# recommended
posts that share tags with this one
Database
# database
Oracle Database: Reset User Password and disable passowrd expiration.
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…
2013-10-17
1 min
read →
ORACLE/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 →
ORACLE/1521
# oracle
Oracle Database 11g Installation
0. /etc/sysctl.conf fs.suid_dumpable = 1 fs.aio-max-nr = 1048576 fs.file-max = 6815744 kernel.shmall = 2097152 kernel.shmmax = 536870912 kernel.shmmni = 4096 # semaphores:…
2013-09-18
2 min
read →