sqlplus connect string issue

  • From: hrishy <hrishys@xxxxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Mon, 29 Jun 2009 09:09:07 +0000 (GMT)

For one of my databases i am unable to connect using
sqlplus user/password
but when i try 
sqlplus username/password@connect-string  it connects
The error message i get using sqlplus username/password is 
ORA-01017: invalid username/password; logon denied
There are many other databases on this server and they work fine.
The thing that is different about this database is
The tnsnames.ora has an entry for this database pointing to another host on 
port 1522.
The local listener parameter on the database says the database is registered 
for a listener on port 1527
i did a truss -o log sqlplus username/password but clueless on what i should 
look or fix so i can connect using just sqlplus username/password without the 
connection string.


Other related posts: