Skip to content

Oracle Database check PFILE or SPFILE usage

● cpx September 17, 2013 1 min read ORACLE/1521

 

SQL> SELECT DECODE(value, NULL, 'PFILE', 'SPFILE') "Init File Type"   FROM sys.v_$parameter WHERE name = 'spfile';

Init File Type
--------------------------------
SPFILE

 

SQL> SELECT DECODE(value, NULL, 'PFILE', 'SPFILE') "Init File Type"   FROM sys.v_$parameter WHERE name = 'spfile';

Init F
------
PFILE

 

# 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 →
0 0 votes
Article Rating
guest

0 Comments
Oldest
Newest Most Voted
0
Would love your thoughts, please comment.x
()
x