oracle jdbc No listner error12541

[far]

this is the first time i try to connect oracle with java (jdbc) i have the correct url in my java code but still i can;t get connected, i checked the lsnrctl status:

tns-12541:tns:no listner
also protocol adaptor error
no listner
windows :61:unknow error

plz can anyone help me

[Kenneth_19 · Accepted solution]

Try checking the status of the listener on your database server:

$ORACLE_HOME/bin/lsnrctl status

If it is not running, start the listener:

$ORACLE_HOME/bin/lsnrctl start

If your instance is not yet configured in the listener file:

edit the $ORACLE_HOME/network/admin/listener.ora

Kenneth

[far]

hi kenneth, i am glade u answered me so soon, can plz help me configure my lisnter file, by the way i am runing client and server on one machine, i am a student ,i have a project, java and database, i just need them get conected.

[far]

maybe this file can help

[Sanjay Kumar Suri]

A sample file is listed below:

# LISTENER.ORA Network Configuration File: E:\oracle\ora90\network\admin\listener.ora
# Generated by Oracle configuration tools.

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = HOST_NAME)(PORT = 1521))
)
)
)

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = orcl)
(ORACLE_HOME = E:\oracle\ora90)
(SID_NAME = orcl)
)
)

Change the values on the RHS of = and start the listener by command given in previous post.

sks

[far]

thanks sks,this is my file what should be changed?..waiting for ur reply..thanks again


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

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = farlau)(PORT = 1521))
)
)
)

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = D:\oracle\ora90)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = data)
(ORACLE_HOME = D:\oracle\ora90)
(SID_NAME = data)
)
)

[Sanjay Kumar Suri]

You listener.ora file seems to be ok. Can you check

Start --> Settings --> Control Panel --> Administrative tools --> Services

And look for the Oracle Service like OracleOraHome90TNSLinstener and start/stop/start the same.

sks

[far]

i realy appreaciate that u are helping me.. i did what u told me, but windowsxp gave me an error, do u think i should reinstall oracle.. here is a snapshot of the error

[Sanjay Kumar Suri]

Can you stop OracleServiceDATA before acting on my previous post?

Once Listener started, OracleServiceDATA can be started.

Check the status of Listener with

lsnrctl status

If all works:
set oracle_sid=DATA
(DATA seems to be the database name)

and then try to start the database.

sks

[far]

hi sks, it gave me the same error even though i stoped the OracleServiceDATA,so do u think if i reinstalled oracle it might work????
note:host=falau
and sid=data
i am workin on one machine,trying to make forte4j to work with oracle sql,i got the driver and the correct url but still can't get connected. it just seems that i cant get the OracleServiceDATA started..should i reinstall oracle???