oracle jdbc No listner error12541

[Sanjay Kumar Suri]

Before you do that, can you check the entry in the file tnsnames.ora (location same as listener.ora)

ORCL=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = host_name)(PORT = 1521))
)
(CONNECT_DATA = (SID = ORCL)(SERVER = DEDICATED))
)

Also check the entry sqlnet.ora

NAMES.DIRECTORY_PATH=(TNSNAMES, ONAMES, HOSTNAME)

sks

[far]

this is the tsn file:

# TNSNAMES.ORA Network Configuration File: D:\oracle\ora90\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = farlau)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = data)
)
)

INST1_HTTP =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = farlau)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = SHARED)
(SERVICE_NAME = MODOSE)
(PRESENTATION = http://HRService)
)
)

EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)

and this is the sql file:

# SQLNET.ORA Network Configuration File: D:\oracle\ora90\network\admin\sqlnet.ora
# Generated by Oracle configuration tools.

SQLNET.AUTHENTICATION_SERVICES= (NTS)

NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)

[Sanjay Kumar Suri]

Can you match last two lines

(CONNECT_DATA =
(SERVICE_NAME = data)

on the lines of what I have listed.

Also commant the following line (with #):

#SQLNET.AUTHENTICATION_SERVICES= (NTS)

And give it all a fresh try. I am now logging out.

All the best.

sks

[Yogeeraj_1]

hi,

can you post the output of the following command (run from command prompt on the server):

lsnrctl serv

regards
Yogeeraj

[R. Allan Hicks]

Haven't done anything with JDBC but...

Can you ping the server from the client?

Open a command window and at the prompt type

ping farlau

If it works, then I'm on the wrong track, however if you get 100% packet loss, try

Look at the hosts file under C:\WINNT\system32\drivers\etc (it may be in a different place on XP). Find the farlau entry and verify the IP address.

If it is there and correct, try pinging the IP instead of the hostname. It could also be that you don't have a route to the server.

If you don't have a network path to the server you can get a TNS-12541 too.

-Good Luck

[Yogeeraj_1]

hi,
on the client, can you also try to do a tnsping?

e.g. tnsping

also, can you try to connect using sqlplus using the following:
sqlplus /nolog
then:
sql> Connect /@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=myserver.mu)(PORT=1521))(CONNECT_DATA=(SID=dev10g)))

just to check if you can connect from the client...

regards
Yogeeraj