Wednesday, August 18, 2010

Oracle remove the parameter from spfile

How to remove the parameter from the spfile.

I was getting following in the alert log:

Deprecated system parameters with specified values:
remote_os_authent
End of deprecated system parameter listing

that means there is a deprecated system parameter which we are using. At the same time I was getting the following message while startup:

SQL> startup
ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
ORACLE instance started.

Total System Global Area 544030720 bytes
Fixed Size 1337776 bytes
Variable Size 406849104 bytes
Database Buffers 130023424 bytes
Redo Buffers 5820416 bytes
Database mounted.
Database opened.


Steps to resolve the issue are:
SQL> alter system reset remote_os_authent scope=spfile sid='*';

System altered.

SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.

Total System Global Area 544030720 bytes
Fixed Size 1337776 bytes
Variable Size 406849104 bytes
Database Buffers 130023424 bytes
Redo Buffers 5820416 bytes
Database mounted.
Database opened.
SQL>

No comments: