Bug 215100 – dev-db/oracle-instantclient-basic - tnsnames.ora does not exist

• Product: Gentoo Linux
• Status: RESOLVED FIXED

[Description Trenton D. Adams 2008-03-27 20:34:31 UTC]

The tnsnames.ora file does not exist in the package.  It should have an example one, and the /etc/env.d/50oracle-instantclient-basic file should be updated to have TNS_ADMIN=/etc/oracle/, or something similar.

Reproducible: Always

Steps to Reproduce:
1.try and run sqlplus username@database_name
2.
3.

Actual Results:  
ERROR:
ORA-12154: TNS:could not resolve the connect identifier specified


Expected Results:  
Connected to:
OracleXX Enterprise Edition Release X.X.X.X.X - Production
With the Partitioning option
JServer Release X.X.X.X.X - Production

[Comment 1 Tobias Scherbaum (RETIRED) 2008-03-27 21:06:11 UTC]

simply put, of course you need your own tnsnames.ora if you don't want to specify all parameters on the command line every connect. But as a tnsnames.ora isn't required to successfully run sqlplus i consider this being an enhancement. Feel free to provide a well documented templated and reopen this bug. 

[Comment 2 Trenton D. Adams 2008-03-27 22:24:14 UTC]

I agree, it's not a bug, it's an enhancement.

Basically, all that would happen for this is...

Create /etc/oracle

Change /etc/env.d/50oracle-instantclient-basic to be like this...

ORACLE_HOME=/usr/lib/oracle/10.2.0.3/client
LDPATH=/usr/lib/oracle/10.2.0.3/client/lib
C_INCLUDE_PATH=/usr/lib/oracle/10.2.0.3/client/include
TNS_ADMIN=/etc/oracle/

Then, perhaps print something out at the end of the install that tells the user how to finish installation, if they want to be able to go "sqlplus username@database_name".  Those instructions would simply tell them to put tnsnames.ora in /etc/oracle.

[Comment 3 Tobias Scherbaum (RETIRED) 2008-05-02 19:44:43 UTC]

Fixed in CVS.

[Comment 4 Jan Schubert 2008-06-02 08:03:00 UTC]

Thx, makes it more comfortable a little bit :-)