Home » Infrastructure » Windows » ORA-12541: TNS:no listener , Help me
ORA-12541: TNS:no listener , Help me [message #180255] Sat, 01 July 2006 23:53 Go to next message
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
Re: ORA-12541: TNS:no listener , Help me [message #180268 is a reply to message #180255] Sun, 02 July 2006 09:07 Go to previous messageGo to next message
Frank Naude
Messages: 4579
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!

Re: ORA-12541: TNS:no listener , Help me [message #180272 is a reply to message #180255] Sun, 02 July 2006 10:31 Go to previous messageGo to next message
h_kabiri
Messages: 5
Registered: June 2006
Junior Member
hello
Thanks Frank Naude

the result attached
  • Attachment: tnsping.bmp
    (Size: 1.15MB, Downloaded 3703 times)
Re: ORA-12541: TNS:no listener , Help me [message #180273 is a reply to message #180272] Sun, 02 July 2006 12:20 Go to previous messageGo to next message
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.
Re: ORA-12541: TNS:no listener , Help me [message #180298 is a reply to message #180273] Mon, 03 July 2006 00:17 Go to previous messageGo to next message
Frank Naude
Messages: 4579
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.
Re: ORA-12541: TNS:no listener , Help me [message #180304 is a reply to message #180255] Mon, 03 July 2006 00:55 Go to previous messageGo to next message
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 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Of course; Oracle XE could be the right choice for you.
Re: ORA-12541: TNS:no listener , Help me [message #180365 is a reply to message #180255] Mon, 03 July 2006 04:59 Go to previous messageGo to next message
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 2580 times)
Re: ORA-12541: TNS:no listener , Help me [message #180514 is a reply to message #180255] Tue, 04 July 2006 00:47 Go to previous message
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."
Previous Topic: Reset sysman in Oracle 8i
Next Topic: Install Developer 6i on Windows XP Professional
Goto Forum:
  


Current Time: Thu Mar 28 12:31:44 CDT 2024