OraFAQ Forum: Windows » ORA-12541: TNS:no listener , Help me

Home » Infrastructure » Windows » ORA-12541: TNS:no listener , Help me

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ORA-12541: TNS:no listener , Help me [message #180255]

Sat, 01 July 2006 23:53

h_kabiri
Messages: 5
Registered: June 2006

Junior Member

hello
i install oracle 10g client in windows XP
when i setup (in net manager) service name , i can not connect to oracle
Test result is :
"
Initializing first test to use userid: scott, password: tiger
Attempting to connect using userid: scott
The test did not succeed.
ORA-12541: TNS:no listener

There may be an error in the fields entered,
or the server may not be ready for a connection. "

my listener.ora is:

# listener.ora Network Configuration File: D:\Oracle\product\10.1.0\Client_1\NETWORK\ADMIN\li stener.ora 
# Generated by Oracle configuration tools. 

SID_LIST_LISTENER = 
(SID_LIST = 
(SID_DESC = 
(SID_NAME = PLSExtProc) 
(ORACLE_HOME = D:\Oracle\product\10.1.0\Client_1) 
(PROGRAM = extproc) 
) 
) 

LISTENER = 
(DESCRIPTION_LIST = 
(DESCRIPTION = 
(ADDRESS = (PROTOCOL = TCP)(HOST = GBG)(PORT = 1521)) 
) 
(DESCRIPTION = 
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC)) 
) 
)

my tnsnames.ora is:

# tnsnames.ora Network Configuration File: D:\Oracle\product\10.1.0\Client_1\NETWORK\ADMIN\tn snames.ora 
# Generated by Oracle configuration tools. 

HD_GBG = 
(DESCRIPTION = 
(ADDRESS_LIST = 
(ADDRESS = (PROTOCOL = TCP)(HOST = gbg)(PORT = 1521)) 
) 
(CONNECT_DATA = 
(SID = hd) 
(SERVER = DEDICATED) 
) 
)

and i can not find lsnrctl.exe in my computer.
please help me

Report message to a moderator

Re: ORA-12541: TNS:no listener , Help me [message #180268 is a reply to message #180255]

Sun, 02 July 2006 09:07

Frank Naude
Messages: 4595
Registered: April 1998

Senior Member

1) Post output from "ping GBG"
2) Post output from "tnsping HD_GBG"

PS: Only new entries my start in col 1, but all lines in your *.ora files start in col 1!

Report message to a moderator

Re: ORA-12541: TNS:no listener , Help me [message #180272 is a reply to message #180255]

Sun, 02 July 2006 10:31

h_kabiri
Messages: 5
Registered: June 2006

Junior Member

hello
Thanks Frank Naude

the result attached

Attachment: tnsping.bmp
(Size: 1.15MB, Downloaded 3957 times)

Report message to a moderator

Re: ORA-12541: TNS:no listener , Help me [message #180273 is a reply to message #180272]

Sun, 02 July 2006 12:20

ebrian
Messages: 2794
Registered: April 2006

Senior Member

Not sure why your client home has a listener configuration file? You should verify the listener.ora file on the GBG server.

The listener control utility (lsnrctl.exe) should be located on the database server (GBG) in the %ORACLE_HOME%\bin directory.

You should go on the GBG database server and pull up a command prompt and enter:

C:\lsnrctl

Once in the utility, enter the following:

LSNRCTL> status

and

LSNRCTL> services

Make sure the output from these commands don't have any errors and that it shows the HD_GBG database service.

Report message to a moderator

Re: ORA-12541: TNS:no listener , Help me [message #180298 is a reply to message #180273]

Mon, 03 July 2006 00:17

Frank Naude
Messages: 4595
Registered: April 1998

Senior Member

Yes, looks like you've only installed the client software.

Solutions:

1. Change your TNSNAMES.ORA file to point to a remote machine where a database and listener is running.

2. Install the database/server software locally and create a database on your local machine.

Report message to a moderator

Re: ORA-12541: TNS:no listener , Help me [message #180304 is a reply to message #180255]

Mon, 03 July 2006 00:55

h_kabiri
Messages: 5
Registered: June 2006

Junior Member

hello
I can not find lsnrctl.exe in my computer,this file dont install on my computer(C:\Oracle\product\10.1.0\Client_1\BIN)

can install database/server software on windows xp sp2?

[Updated on: Mon, 03 July 2006 00:57]

Report message to a moderator

Re: ORA-12541: TNS:no listener , Help me [message #180330 is a reply to message #180304]

Mon, 03 July 2006 02:24

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Of course; Oracle XE could be the right choice for you.

Report message to a moderator

Re: ORA-12541: TNS:no listener , Help me [message #180365 is a reply to message #180255]

Mon, 03 July 2006 04:59

h_kabiri
Messages: 5
Registered: June 2006

Junior Member

hello
I remove oracle client and install database/server
in database/server i find lsnrctl.exe and run it
result attached

Attachment: lsnrctl.bmp
(Size: 222.87KB, Downloaded 2864 times)

Report message to a moderator

Re: ORA-12541: TNS:no listener , Help me [message #180514 is a reply to message #180255]

Tue, 04 July 2006 00:47

h_kabiri
Messages: 5
Registered: June 2006

Junior Member

hello
i run "net config assistant" -> local net service name con.. -> Test -> ORCL
test result is :
"Connecting...ORA-12528: TNS:listener: all appropriate instances are blocking new connections
The test did not succeed."

if i add new test result is :
"Connecting...ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
The test did not succeed."

Report message to a moderator

Previous Topic:	Reset sysman in Oracle 8i
Next Topic:	Install Developer 6i on Windows XP Professional

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Mar 11 16:47:15 CDT 2025