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

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

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

>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?

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

on DB server system issue following OS commands

lsnrctl status
lsnrctl service

COPY commands & results then PASTE all back here

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

Make sure that TNSNAMES is listed as one of the values of the NAMES.DIRECTORY_PATH parameter in the DB server sqlnet.ora file.

I have following entries in sqlnet.ora file :

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

But still it's not working.

Vikrant

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)

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>

>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

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

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.

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