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
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.
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.
Fixed in CVS.
Thx, makes it more comfortable a little bit :-)