Bug 215100 - dev-db/oracle-instantclient-basic - tnsnames.ora does not exist
|
Bug#:
215100
|
Product: Gentoo Linux
|
Version: unspecified
|
Platform: All
|
|
OS/Version: Linux
|
Status: RESOLVED
|
Severity: normal
|
Priority: P2
|
|
Resolution: FIXED
|
Assigned To: dertobi123@gentoo.org
|
Reported By: trenton.d.adams@gmail.com
|
|
Component: Ebuilds
|
|
|
URL:
|
|
Summary: dev-db/oracle-instantclient-basic - tnsnames.ora does not exist
|
|
Keywords:
|
|
Status Whiteboard:
|
|
Opened: 2008-03-27 20:34 0000
|
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.
Thx, makes it more comfortable a little bit :-)
