Ask the Expert

Can connect from command line but not client

Hi Maria. I've created a new instance on 10g (Solaris). I can connect fine from the command line but I can't seem to connect from a client. I have edited my tnsnames and listener files; is there anything else I have to edit? It's a four-node cluster if that helps.

Listener:

LISTENER_DSC =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = iecsbx02-vip)(PORT = 1522))
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.162.123.57)(PORT = 1522)(IP = FIRST))
tnsnames:
DSC.xxxxxxxx.IE =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 10.162.123.57)(PORT = 1522))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = DSC.xxxxxxx.ie)
      (INSTANCE_NAME = DSC)
    )
  )

    Requires Free Membership to View

First, you will need a tnsnames.ora file on the client. If a tnsnames.ora file exists on the client machine, you should confirm that the SERVICE_NAME and host IP address in the tnsnames.ora is accurate. In other words, the IP address must point back to the server where the database resides.

This was first published in February 2006

There are Comments. Add yours.

 
TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: