Results 1 to 4 of 4
  1. #1
    Join Date
    Jul 2013
    Posts
    2

    Unanswered: TNS , Login error

    hi, i am working on Peoplesoft Campus solution 11g and peopletools 8.50.16. suddenly I m getting an error while starting Application Designer and Data mover as well, the error i got:

    File: SQL Access ManagerSQL error. Stmt #: 2 Error Position: 0 Return: 12154 - ORA-12154: TNS:could not resolve the connect identifier specified

    sql server is working, i can connect sql but tools giving error ,, i tried many options but can't get rid off this problem , can anyone guide me to cover this issue as soon as possoble ..

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    ORA-12154 ALWAYS only occurs on SQL Client & no SQL*Net packets ever leave client system
    ORA-12154 NEVER involves the listener, the database itself or anything on the DB Server.
    ORA-12154 occurs when client requests a connection to some DB server system using some connection string.
    TNS-03505 is thrown by tnsping & is same error as ORA-12154 thrown by sqlplus or others.
    The lookup operation fails because the name provided can NOT be resolved to any remote DB.
    The analogous operation would be when you wanted to call somebody, but could not find their name in any phonebook.
    The most frequent cause for the ORA-12154 error is when the connection alias can not be found in tnsnames.ora.
    The lookup operation of the alias can be impacted by the contents of the sqlnet.ora file; specifically DOMAIN entry.
    TROUBLESHOOTING GUIDE: ORA-12154 & TNS-12154 TNS:could not resolve service name [ID 114085.1]
    ora-12154/tns-03505 | Ed Stevens, DBA
    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
    Jul 2013
    Posts
    2
    Hi, thanx alot with your response, i done and check all the things but still issue while starting peopletools . Here is a attached pic so you can better understand and guide .. Thanx




    Quote Originally Posted by anacedent View Post
    ora-12154 always only occurs on sql client & no sql*net packets ever leave client system
    ora-12154 never involves the listener, the database itself or anything on the db server.
    Ora-12154 occurs when client requests a connection to some db server system using some connection string.
    Tns-03505 is thrown by tnsping & is same error as ora-12154 thrown by sqlplus or others.
    The lookup operation fails because the name provided can not be resolved to any remote db.
    The analogous operation would be when you wanted to call somebody, but could not find their name in any phonebook.
    The most frequent cause for the ora-12154 error is when the connection alias can not be found in tnsnames.ora.
    The lookup operation of the alias can be impacted by the contents of the sqlnet.ora file; specifically domain entry.
    Troubleshooting guide: Ora-12154 & tns-12154 tns:could not resolve service name [id 114085.1]
    ora-12154/tns-03505 | ed stevens, dba
    Attached Thumbnails Attached Thumbnails Untitled.jpg  

  4. #4
    Join Date
    Jun 2004
    Posts
    796
    Provided Answers: 1
    i can connect sql but tools giving error
    So the problem is with PeopleTools & how it connects (or in your case, doesn't connect) with the database. Start by looking there for the problem.
    90% of users' problems can be resolved by punching them - the other 10% by switching off their PCs.

Posting Permissions

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