Help! I can’t connect to my database (part duex)

This article has been moved to my new blog at edstevensdba.com.

 

Click here to go to the new location of this article.

Advertisements

16 thoughts on “Help! I can’t connect to my database (part duex)

  1. Nice article Ed!

    For my work computer I prefer to set the TNS_ADMIN as an environment variable associated with my operating system account (not specific to the computer) for a couple of reasons.

    First, as you mentioned it removes the linkage between the installation and configuration. I’ve run many different Oracle clients on my machine.

    Secondly, I may logon to multiple computers in my company. Setting the TNS_ADMIN in my profile to a network share allows me to carry my configuration to any company’s network.

    Also, there is a small spelling mistake in the first sentence of your second paragraph. It is currently displaying as “accuratly.”

    Keep up the good work!

  2. This may be a topic for another blog post but, another question that I’m surprised doesn’t come up more often is how does Oracle know which registry key to read the values from?

    I haven’t done any extensive testing, but I believe this is driven by a file in %ORACLE_HOME%\bin named oracle.key.

    For example on my machine this value in an 11.2 home is: SOFTWARE\ORACLE\KEY_OraClient11g_home1

    This value allows Oracle to read the correct values from the root HKEY_LOCAL_MACHINE key

    • On Oracle’s use of the registry — I have noticed that over the versions, the way oracle even structures its registry entry and keeps key inof seems to change. I had a pretty good handle on it at 8.0/8.1, kept up at 9.x, but gave up even trying at 10.x.

  3. Ed,

    I like the approach that you used to create the article – this series will certainly be a big help to people who are new to Oracle Database (and probably a few who have been simply copying and pasting the same setup for so long, that it no longer fully applies to newer release versions).

    If you have a couple of minutes, find this blog article on my blog:
    “Finding a New Home for a Client on Windows”

    If you do not manually set environment variables or registry entries, the PATH environment variable can also determine which sqlnet.ora file is accessed (I suspect that you probably planned this for a later article).

    A couple of tips:
    * Edit your profile on OTN to include your blog’s web address.
    * Consider building a page that links to all of your blog articles – blog articles have a tendency to be hard to find after a very short period of time, and it is nice to have a quick index to all of the articles.

    • Charles – thanks for the comments. I particularly appreciate them coming from you.

      Yes, I’m already looking into restructuring so things aren’t just a scrolling list of postings. I really like the way Richard Foote put his site together and will probably go with something similar.

  4. Pingback: Oracle – tnsping – Message 3513 not found; product=NETWORK; facility=TNS « RNM

  5. Pingback: Sourcecode markup tweaks in Wordpress « RNM

  6. Thanks Ed! you are a great teacher. Tonight I am readling all articles in the series one by one. I request you to write a series of articles explaining regular netwrok bascis. That is also another confusing area for many.

  7. FWIW, at my job, TNS_ADMIN points to a network location to which I don’t have, and can’t get, read access. If I change it to a local directory, *something* changes it back again after several minutes, and my client app will no longer connect.

    I ended up writing a batch file to make the change I want. I run the batch file, then immediately start my client. The hoops I have to jump through around here…

    Thanks for the helpful article. Without information like this, I’d never be able to get any work done.

    • I can see net/workstation admins pushing a tns_admin setting out to the clients, though I’ve only ever seen it done at logon time. Not sure how it would be changed ‘after several minutes’. Have you talked to your sysadmin people?

      In addition, tns_admin points to a network location to which you don’t have read access, then how is your local client process able to read it?

  8. Hi Ed,,
    I am working on Windows 7. I have DevSuit 10g installed and Oracle XE 11g installed as well. I need to connect Reports Builder to the XE but I always get this error: “TNS:could not resolve the connect identifier specified”

    I read lots of your posts but still cannot do it. Can you help?

  9. Thanks for making this Ed, it helped me maintain my sanity while troubleshooting a new client install.

    One quick note – the server I was configuring the client on was appending “.txt” to my tnsnames.ora file. So I was getting the TNS-03505 error even though I thought my file was fine. Turned out this new server didn’t have extensions automatically visible, so my tns file was actually named “tnsnames.ora.txt”. Dropped the “.txt” and everything worked. Wanted to post this here in-case some weary traveler finds his/herself in the same jam.

    20 minutes of my life I’ll never get back.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s