Results 1 to 4 of 4
  1. #1
    Join Date
    Apr 2010
    Posts
    30

    Unanswered: ORA-12154: TNS: could not resolve the connect identifier specified

    Hi,

    I am trying to connect to oracle DB from Oracle forms developer and getting this TNS error.How do I resolve it?.read some info regarding appending the tnsname.ora file but the connection still did not happen.

    Kindly Advise

    Thanks

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    does SQL*Net (username/password@REMOTE_DB) ever work for you?
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Apr 2010
    Posts
    30
    Hi,
    Not is is not allowing me to login into SQL +.I am using root as UID and PWD root

  4. #4
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >Not is is not allowing me to login into SQL +.I am using root as UID and PWD root
    Oracle knows nothing about "root"

    SQL*Net(@TNS_ALIAS) is NOT required to access local DB
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •