Page 1 of 2 12 LastLast
Results 1 to 15 of 23
  1. #1
    Join Date
    Oct 2011
    Posts
    25

    Unanswered: 12154-ORA: could not resolve service name

    Hi Folks,

    I have installed PL/SQL developer version 7.1.0.1337 for Oracle Express Edition 10.2.0

    While connecting to oracle XE, I'm recieving the following error :
    12154-ORA: could not resolve service name.

    Despite of the fact I have valid entry in the tnsnames.ora file at path C:\oraclexe\app\oracle\product\10.2.0\server\NETWO RK\ADMIN
    I'm recieving this error.

    Pls suggest appropriate solution for the same.

    Best Regards,
    Vikrant Bishnoi

  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 occurs when client requests a connection to some DB server system using some connection string.
    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
    Oct 2011
    Posts
    25
    I have tried it with SQL command line prompt, it's working fine.

    But using PL/SQL Developer, I'm unable to login Oracle 10g XE.
    Does that means my license has got expired?

    Vikrant

  4. #4
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >I have tried it with SQL command line prompt, it's working fine.
    post COPY & PASTE proof above is true.

    >But using PL/SQL Developer, I'm unable to login Oracle 10g XE.
    name software vendor & software version

    when did it last work OK?
    What changed since then?
    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.

  5. #5
    Join Date
    Oct 2011
    Posts
    25
    SQL*Plus: Release 10.2.0.1.0 - Production on Sun Dec 4 23:45:03 2011

    Copyright (c) 1982, 2005, Oracle. All rights reserved.

    SQL> conn hr/hr;
    Connected.
    SQL>

    I got the above message after login fron SQL command line prompt.

    As far as the the software vendor of the Oracle 10g Express Edition, I have downloaded it from Oracle | Hardware and Software, Engineered to Work Together with version :10.2.0.1.0

    Till today only it was working fine. I was debugging a procedure, when PL/SQL Developer stops responding. I finally close the application. And when I again try to login, I started to get that error.

    Vikrant

  6. #6
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    on DB server system issue following OS commands

    lsnrctl status
    lsnrctl service

    COPY commands & results then PASTE all back here
    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.

  7. #7
    Join Date
    Oct 2011
    Posts
    25
    C:\oraclexe\app\oracle\product\10.2.0\server\BIN>l snrctl status

    LSNRCTL for 32-bit Windows: Version 10.2.0.1.0 - Production on 05-DEC-2011 13:02
    :42

    Copyright (c) 1991, 2005, Oracle. All rights reserved.

    Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC_F OR_XE)))
    STATUS of the LISTENER
    ------------------------
    Alias LISTENER
    Version TNSLSNR for 32-bit Windows: Version 10.2.0.1.0 - Produ
    ction
    Start Date 26-NOV-2011 21:08:23
    Uptime 8 days 15 hr. 54 min. 18 sec
    Trace Level off
    Security ON: Local OS Authentication
    SNMP OFF
    Default Service XE
    Listener Parameter File C:\oraclexe\app\oracle\product\10.2.0\server\netwo rk\a
    dmin\listener.ora
    Listener Log File C:\oraclexe\app\oracle\product\10.2.0\server\netwo rk\l
    og\listener.log
    Listening Endpoints Summary...
    (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\ pipe\EXTPROC_FOR_XEipc)))
    (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=vikrant) (PORT=1521)))
    (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0. 1)(PORT=8080))(Presentation=
    HTTP)(Session=RAW))
    Services Summary...
    Service "CLRExtProc" has 1 instance(s).
    Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
    Service "PLSExtProc" has 1 instance(s).
    Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
    Service "XEXDB" has 1 instance(s).
    Instance "xe", status READY, has 1 handler(s) for this service...
    Service "XE_XPT" has 1 instance(s).
    Instance "xe", status READY, has 1 handler(s) for this service...
    Service "xe" has 1 instance(s).
    Instance "xe", status READY, has 1 handler(s) for this service...
    The command completed successfully


    C:\oraclexe\app\oracle\product\10.2.0\server\BIN>l snrctl service

    LSNRCTL for 32-bit Windows: Version 10.2.0.1.0 - Production on 05-DEC-2011 13:19
    :44

    Copyright (c) 1991, 2005, Oracle. All rights reserved.

    Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC_F OR_XE)))
    Services Summary...
    Service "CLRExtProc" has 1 instance(s).
    Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
    Handler(s):
    "DEDICATED" established:0 refused:0
    LOCAL SERVER
    Service "PLSExtProc" has 1 instance(s).
    Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
    Handler(s):
    "DEDICATED" established:0 refused:0
    LOCAL SERVER
    Service "XEXDB" has 1 instance(s).
    Instance "xe", status READY, has 1 handler(s) for this service...
    Handler(s):
    "D000" established:0 refused:0 current:0 max:1002 state:ready
    DISPATCHER <machine: VIKRANT, pid: 6100>
    (ADDRESS=(PROTOCOL=tcp)(HOST=vikrant)(PORT=62360))
    Service "XE_XPT" has 1 instance(s).
    Instance "xe", status READY, has 1 handler(s) for this service...
    Handler(s):
    "DEDICATED" established:0 refused:0 state:ready
    LOCAL SERVER
    Service "xe" has 1 instance(s).
    Instance "xe", status READY, has 1 handler(s) for this service...
    Handler(s):
    "DEDICATED" established:0 refused:0 state:ready
    LOCAL SERVER
    The command completed successfully

  8. #8
    Join Date
    Apr 2008
    Location
    Iasi, Romania
    Posts
    561
    Provided Answers: 2
    Make sure that TNSNAMES is listed as one of the values of the NAMES.DIRECTORY_PATH parameter in the DB server sqlnet.ora file.
    Florin Aparaschivei
    DB2 9.7, 10.5 on Windows
    Iasi, Romania

  9. #9
    Join Date
    Oct 2011
    Posts
    25
    I have following entries in sqlnet.ora file :

    SQLNET.AUTHENTICATION_SERVICES = (NTS)
    NAMES.DIRECTORY_PATH = (TNSNAMES)

    But still it's not working.

    Vikrant

  10. #10
    Join Date
    Apr 2008
    Location
    Iasi, Romania
    Posts
    561
    Provided Answers: 2
    1. I think that you are trying to use PL/SQL developer on the same system as Oracle DB server. Please confirm.
    2. Your command prompt test is not concludent, as you are not using service name. Please use the syntax connect user/password@tnsname and post the results. (in your case, that should be connect hr/hr@xe)
    Florin Aparaschivei
    DB2 9.7, 10.5 on Windows
    Iasi, Romania

  11. #11
    Join Date
    Oct 2011
    Posts
    25
    Yes, I'm using PL/SQL Developer on the same system as DB server.

    Also please find the result for command: connect user/password@tnsname on SQL command line prompt.

    SQL*Plus: Release 10.2.0.1.0 - Production on Mon Dec 5 23:40:28 2011

    Copyright (c) 1982, 2005, Oracle. All rights reserved.

    SQL> connect hr/hr@xe;
    Connected.
    SQL>

  12. #12
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >I have following entries in sqlnet.ora file :
    >SQLNET.AUTHENTICATION_SERVICES = (NTS)

    remove line above from sqlnet.ora
    It is NOT valid when connect to Unix DB Server system
    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.

  13. #13
    Join Date
    Oct 2011
    Posts
    25
    Hi Anacedent,

    I have tried by removing the following entry in sqlnet.ora file :
    SQLNET.AUTHENTICATION_SERVICES = (NTS)

    But the result is still the same.
    This problem is getting more n more cumbersome n I'm losing time.

    What should I do now ?

    Vikrant

  14. #14
    Join Date
    Apr 2008
    Location
    Iasi, Romania
    Posts
    561
    Provided Answers: 2
    Quote Originally Posted by vbishnoi View Post
    SQL> connect hr/hr@xe;
    Connected.
    SQL>
    And from PL/SQL Developer you are trying to connect to xe and you are getting ORA-12154?
    Try to unregister the datasource and then register again in PL/SQL Developer.
    Florin Aparaschivei
    DB2 9.7, 10.5 on Windows
    Iasi, Romania

  15. #15
    Join Date
    Oct 2011
    Posts
    25
    Yes Florin,

    While connecting from the PL/SQL Developer , I'm getting this error.
    Where as on SQL command prompt line it's working fine.

    Since I'm very new to all this, can you pls specify what is refered to datasource here.

    Thanks,
    Vikrant

Posting Permissions

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