Today I noticed the reason why I have not bothered to use ezconnect method with sqlplus connections.

sqlplus system/oracle@localhost/orcl

I do not like to reveal my passwords on screen if possible.

sqlplus system@localhost/orcl

ORA-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA

Additional quotes are needed with ezconnect, when I do not want to write the password on command line.

sqlplus system@\"localhost/orcl\"
Enter password:


sqlplus /nolog
SQL> conn system@"localhost/orcl"
Enter password:

Seems like 11.2 client does not need NAMES.DIRECTORY_PATH= (ezconnect) line in sqlnet.ora anymore to use the method. 10.1, 10.2 and 11.1 version client installations need that line there.

No comments:

Post a Comment

About Me

My photo
I am Timo Raitalaakso. I have been working since 2001 at Solita Oy as a Senior Database Specialist. My main focus is on projects involving Oracle database. Oracle ACE alumni 2012-2018. In this Rafu on db blog I write some interesting issues that evolves from my interaction with databases. Mainly Oracle.