Sitemap

Amicuk Programming Answers

SQL Developer can't see tnsnames.ora

-0001-11-30   Views:1

Advertisement

Hiya. I hope someone can help with this. I installed Oracle instant client (basic lite) on my new Windows 7 machine (32 bit) - yeah, I know Windows 7 is not supported, but my gut feeling is that this isn't the issue I'm having. I've put my tnsnames.o

Hiya. I hope someone can help with this. I installed Oracle instant client (basic lite) on my new Windows 7 machine (32 bit) - yeah, I know Windows 7 is not supported, but my gut feeling is that this isn't the issue I'm having.
I've put my tnsnames.ora file in the same folder as instant client (C:\program files\oracle\instantclient), have created a system environment variable TNS_ADMIN which points to that folder, and have added that folder to the system "path" environment variable. That should do it, right?
When I try to create a new connection in SQL Developer 2.1.0.63, and change my connection type to "tns", I don't see any database connections.
Troubleshooting ideas? Other ways to test that the needed Oracle files are installed properly?
Thanks!

The replay answer
Advertisement
Here's how to debug where it's looking:
http://krisrice.blogspot.com/2008/04/it-seems-to-come-up-often-that-some.html
-kris

Go to See the other 5 answers

SQL Developer not only reading tnsnames.ora

Category:DefaultRelease time:-0001-11-30Views:130

Hello, I have found a very odd behaviour in SQL Developer 1.2 (running on Windows 2000): I have set TNS_ADMIN to point to a directory on a network drive residing on a Linux host. In this directory there were many backup files of tnsnames.ora created[More]

SQL Developer can't see tnsnames.ora

Category:DefaultRelease time:-0001-11-30Views:130

Hiya. I hope someone can help with this. I installed Oracle instant client (basic lite) on my new Windows 7 machine (32 bit) - yeah, I know Windows 7 is not supported, but my gut feeling is that this isn't the issue I'm having. I've put my tnsnames.o[More]

Sql Developer not reading right tnsnames.ora

Category:DefaultRelease time:-0001-11-30Views:130

I have both a local 9iv2 and a 10xe (app_express) databases installed. Oracle home is set to ora92 and therefore should be reading the tnsnames.ora file in c:\oracle\ora92\network\admin. However, I recently used SQL Developer to connect to the 10xe d[More]

TNS_ADMIN not respected, or how do I get sql developer to see my tnsnames

Category:DefaultRelease time:2015-10-11Views:130

When I installed sql developer at home with a 'static' tnsnames.ora file, sql-developer picked it up right away, and I was able to use the 'connect identifier' pull down menu. However, at work, all of developer's computers have a TNS_ADMIN registry s[More]

JDBC-Connection in SQL-Developer via Connection-Manager gives ORA-12529

Category:DefaultRelease time:-0001-11-30Views:130

Hi ! This is a followup of this Thread: https://community.oracle.com/thread/3568462 I have the same problem but I have ConnectionManager 11g (11.2.0.1.0) , which doesn't know the setting for AUTHENTICATION_LEVEL=0 And I have to use JDBC, so the OCI/T[More]

Developing without  Full client / tnsnames.ora

Category:DefaultRelease time:-0001-11-30Views:130

I am trying to develop an OCI application using Borland C++ Builder. I want to deploy and develop using Instant Client 10G without tnsnames.ora file. I have 2 PCs - NT4 & XP. On the NT4 PC I had installed the full Oracle Client and was using the tnsn[More]

Bulk import of tnsnames.ora file into SQL developer on first run

Category:DefaultRelease time:-0001-11-30Views:130

Is there a way for SQL developer to read the tnsnames.ora file and import all of the connections from that? Near as I can see, I would either have to manually add each of them or import an xml file of some kind...Thoughts?There's a feature request fo[More]

SQL Developer 1.5 having problems with JDK 6 Update 7

Category:DefaultRelease time:-0001-11-30Views:130

I tried to open a table using SQL Developer 1.5 but connection timed out. when using SQL developer 1.2 i don't get any problems opening it. i have JDK 6 update 7 installed. the only problem with SQL Developer 1.2 is that i get a jdbc in the error log[More]

Urgent : Is there any c++ parsers available for reading tnsnames.ora

Category:DefaultRelease time:-0001-11-30Views:130

I have to parse the tnsnames.ora and get the connection string , host name , instance name , port etc .. and store it in my local memory structure . Is there any c++ parsers available , which parses and gives the desired output or do i have write my[More]

Ora 12505 error in Sql developer

Category:DefaultRelease time:-0001-11-30Views:130

can any one help.... when i was about to create a table in oracle sql developer i got error mesg ora 12505 listener refused the connection... tns doesnt respond892111 wrote: can any one help.... when i was about to create a table in oracle sql develo[More]

Oracle SQL Developer Tool Error:

Category:DefaultRelease time:-0001-11-30Views:130

Hi, i have installled Oracle 11g in Win2003 Server. When create new connection in Oracle SQL Developer its throwing following error ORA-12505, TNS:listener does not currently know of SID given in connect descriptor. The Connection Descriptor used by[More]

Hot
Every time I go to check for purchases I receive this message. Ive been recieving it for a couple weeks now and its reallly starting to annoy me. Based on what info I found, I tried adding different program and port exceptions to my firewall, and I t [More]
Hey, I have a question on using trim function in ABAP. According to all documents, I should be able to use rtrim as shorttext = rtrim('abcde-xx', '-xx'). But when I do that, it gives me an error message "Comma without preceding colon (after shorttest [More]
Is anyone using the new Mini with a CRT TV. I have a Mitsubishi WS-65813 rear projection TV that I'd like to connect to the New Mini using HDMI to DVI. I had one of the older Mini's and the problem was the screen on the TV was not full screen or it w [More]
How do I update iPad 2 to ios5 or 6?Connect your iPad to iTunes on the computer you usually Sync with and Check for Updates. See iOS: How to update your iPhone, iPad or iPod touch and go to the section Updating your device using iTunes. See also iPad [More]
Hi, How can I remove the row for second repeated data in my 2D array regardless of the 2D array size.Try this... There are many variations possible. LabVIEW Champion . Do more with less code and in less time . Attachments: RemoveExtraRowsWithDuplicat [More]
I am not able to scroll thru the commands with FM7.2p158 in Windows 7 Pro. You can see the button go in, it just does not make the toolbar scroll to the next line of tools? please help. Any way to get around this? is/are there some other tool to get [More]
Dear guys, i have Module pool program ZSDMODPOOL,which is transaction ZSDORD(ADDON SCREEN),Which creates sales order and shipment. Now i want, one new screen to display before this ZSDORD Screen. In new screen i will have Table control having Interna [More]
Will there be a way to utilize the responsive layout tools in Edge Reflow with modules in Business catalyst?https://www.google.co.nz/search?q=how+to+do+responsive+web+design&oq=how+to+do+responsive+ web+design&sugexp=chrome,mod=0&sourceid=chro [More]
in the job definition on the run tab on the "option scan output: abnormal string" we use this command pipe to search for the string to force the job to get abnormal status. there are some case that when the job runs and the program being called [More]
Hello, I have solaris 10 installed on an Virtual Machine and suddenly partition /var was not accessible. A reboot solved the problem but after about 12 hours the problem reappeared. Also with fdisk I have done: umount /var fsck /var ** /dev/rdsk/c1t0 [More]