12cR1 not being able to connect “as / sysdba” locally

This came as a surprise when I came back from vacation to discover that all of a sudden can’t do this on my Linux box sqlplus / as sysdba. I was getting ORA-01017. Something like this:

[oracle@dbtest dbs]$ sqlplus / as sysdba

SQL*Plus: Release Production on Wed Aug 3 09:59:29 2016

Copyright (c) 1982, 2014, Oracle. All rights reserved.

 ORA-01017: invalid username/password; logon denied

Enter user-name: ^C
 [oracle@dbtest dbs]$

In my case, one of my colleagues, took the liberty to set TWO_TASK variable. After removing/unsetting the variable, all came to my desired situation.

As you may know, this TWO_TASK variable overwrites the ORACLE_SID & ORACLE_HOME variables and prohibits the local connections and is letting you to use the sqlnet path.

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

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

Google photo

You are commenting using your Google 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 )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.