ORA-12162: TNS:net service name is incorrectly specified on Mac OS X Lion

osx-lion sqlplus tnsnames
Omanand picture Omanand · Nov 27, 2011 · Viewed 35.3k times · Source

I am trying to connect to an oracle database using oracle sqlplus instant client using tnsnames.ora. But getting this error: ORA-12162: TNS:net service name is incorrectly specified.

I have following environmental value set up :

DYLD_LIBRARY_PATH,TNS_ADMIN, ORACLE_HOME

The location of sqlplus is added to the PATH Variable. My instantclient10_2 deploying is located at ~/Library/oracle direcoty. The oracle folder has all the access to the user.

I am able to connect with TNS using oracle SqlDeveloper. Please help me resolve this issue.

OS Version:- Mac OS X 10.7.2 (Lion)

Answer

phray2002 picture phray2002 · Apr 27, 2017 
set ORACLE_SID=YOUR_SID_IN_tnsnames.ora
export ORACLE_SID

Related questions

Set environment variables on Mac OS X Lion

When someone says "edit your .plist file" or "your .profile" or ".bash_profile" etc, this just confuses me. I have no idea where these files are, how to create them if I have to do that, etc, and also why …

Read More
start MySQL server from command line on Mac OS Lion

I installed mySQL for my Mac. Beside starting the SQL server with mySQL.prefPane tool installed in System Preference, I want to know the instruction to start from command-line. I do as follow: After su root I start the mySQL …

Read More
Completely uninstall PostgreSQL 9.0.4 from Mac OSX Lion?

This question may look like a duplicate of: How to uninstall postgresql on my Mac (running Snow Leopard) however, there are two major differences. I'm running Lion and I'm trying to uninstall PostgreSQL 9.0.4. I've looked at the last question and …

Read More