Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

OSX SQLPLUS error:ORA-12162:TNS:net service name is incorrectly specified

675165Dec 11 2008 — edited Sep 1 2010
Dear oracle community,

just stepped today into oracle world.
Installed OracleXE on my remote UBUNTU server.
From the server, sqlplus works perfectly.
From my client (followed this tutorial http://www.danilovizzarro.it/?p=10 ), i can connect via the
sqlplus connection string: #sqlplus hr/PASS@HOSTipADDRESS/XE .

But when i try just sqlplus and enter username/password later on, i get
ORA-12162:TNS:net service name is incorrectly specified .

My config:
OS - MAC OS X LEOPARD 10.5.5
#echo $ORACLE_SID
XE
#echo $ORACLE_HOME
/opt/oracle/instantclient_10_2/
#echo $TNS_ADMIN
/opt/oracle/tns/
# cat /opt/oracle/tns/tnsnames.ora

XE =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = HOSTipADDRESS)(PORT = 1521))
)
(CONNECT_DATA =
(SID = XE)
)
)


Any ideas - is it that sqlplus doesn't locate my tnsnames.ora file, or, maybe, there's an error in it?
thanks for any ideas, recipies, suggestions :)

enjoy the day,
james
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 29 2010
Added on Dec 11 2008
5 comments
40,545 views