Bug List: (This bug is not in your last search results)   Show last search results      Search page      Enter new bug
Bug#: 215100
Alias:
Product:
Component:
Status: RESOLVED
Resolution: FIXED
Assigned To: Tobias Scherbaum <dertobi123@gentoo.org>
Hardware:
OS:
Version:
Priority:
Severity:
Reporter: Trenton D. Adams <trenton.d.adams@gmail.com>
Add CC:
CC:
Remove selected CCs
URL:
Summary:
Status Whiteboard:
Keywords:

Filename Description Type Creator Created Size Actions
Create a New Attachment (proposed patch, testcase, etc.) View All

Bug 215100 depends on: Show dependency tree
Bug 215100 blocks:
Votes: 0    Show votes for this bug    Vote for this bug

Additional Comments: (this is where you put emerge --info)


Not eligible to see or edit group visibility for this bug.






View Bug Activity   |   Format For Printing   |   XML   |   Clone This Bug

Description:   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

------- Comment #1 From Tobias Scherbaum 2008-03-27 21:06:11 0000 ------- 
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 From Trenton D. Adams 2008-03-27 22:24:14 0000 ------- 
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 From Tobias Scherbaum 2008-05-02 19:44:43 0000 ------- 
Fixed in CVS.

------- Comment #4 From Jan Schubert 2008-06-02 08:03:00 0000 ------- 
Thx, makes it more comfortable a little bit :-)
Bug List: (This bug is not in your last search results)   Show last search results      Search page      Enter new bug