Oracle DBA Tips and Techniques

By Arjun Raja


Posted by Arjun Raja on February 10, 2011

If you have a situation where connections to a newly upgraded 11g database are from a remote box as an OPS$ account….follow this.

Connections will fail with the following error.

ERROR: ORACLE connection error: ORA-01017: invalid username/password; logon denied.

Reason –

Once an upgrade to 11g is complete, the REMOTE_OS_AUTHENT is set to false by default to stop remote connections to the database.

show parameter os

os_authent_prefix string ops$
os_roles boolean FALSE
remote_os_authent boolean FALSE
remote_os_roles boolean FALSE

For remote connections to work, remote_os_authent must be= TRUE.

To achieve this , a database bounce is essential, so incorporate this step as part of the upgrade steps to avoid outage at a later time.

alter system set remote_os_authent=true scope=spfile;

Now bounce the database.

When the database restarts, the foll warning message ( ORA-32004) will appear – ignore it – the database starts without further issues…


ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance – expected – can be ignored.
ORACLE instance started.

Total System Global Area 977076224 bytes
Fixed Size 2212744 bytes
Variable Size 729812088 bytes
Database Buffers 239075328 bytes
Redo Buffers 5976064 bytes
Database mounted.
Database opened.

show paramter os

os_authent_prefix string ops$ os_roles boolean FALSE
remote_os_authent boolean TRUE
remote_os_roles boolean FALSE

Now connections from remote boxes as OPS$ logins will succeed.


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: