Monthly Archives: March 2012

How to check if your oracle instance was started using a PFILE or an SPFILE?

You can run the below command:
SQL> select count(*) from v$spparameter where value is not null;

If the result of this query is zero, the instance was started using a PFILE.
If the result is a non-zero value, the instance was started using an SPFILE.

When an instance has been started using a server side parameter file (SPFILE), the v$spparameter contains NOT NULL values for several parameters.
When an instance has been started using the ‘classic’ PFILE, this view only contains NULL values.

You can also run the below command:
SELECT DECODE(value, NULL, ‘PFILE’, ‘SPFILE’) “Init File Type” FROM sys.v_$parameter WHERE name = ‘spfile’


Leave a comment

Filed under Oracle

Receiving error “Useradd: unable to lock password file” on linux

I got the below error when running the useradd command on  linux.

“Useradd: unable to lock password file

This issue occurs if there is passwd.lock or passwd-  or passwd~ file in the /etc/directory. You can remove it or move to some other directory to fix the issue and restart the server. Sometimes you will not be able to move as well and if that’s the case, then you need to restart linux server to fix the issue.



Filed under Linux