I was getting following in the alert log:
Deprecated system parameters with specified values:remote_os_authentEnd 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> startupORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instanceORACLE instance started.Total System Global Area 544030720 bytesFixed Size 1337776 bytesVariable Size 406849104 bytesDatabase Buffers 130023424 bytesRedo Buffers 5820416 bytesDatabase mounted.Database opened.
Steps to resolve the issue are:
SQL> alter system reset remote_os_authent scope=spfile sid='*';System altered.SQL> shutdown immediateDatabase closed.Database dismounted.ORACLE instance shut down.SQL> startupORACLE instance started.Total System Global Area 544030720 bytesFixed Size 1337776 bytesVariable Size 406849104 bytesDatabase Buffers 130023424 bytesRedo Buffers 5820416 bytesDatabase mounted.Database opened.SQL>
No comments:
Post a Comment