Home » RDBMS Server » Server Administration » TNS:no listener
TNS:no listener [message #300940] Mon, 18 February 2008 15:46 Go to next message
itguru
Messages: 19
Registered: July 2007
Junior Member
Oracle9i Enterprise Edition Release 9.0.1.1.1 - Production
on Windows XP


Iam able to login with user name & password.
SQL> connect t1/t1
Connected.

But when i specify database (sid) gives error.

SQL> connect t1/t1@t1
ERROR:
ORA-12541: TNS:no listener

Warning: You are no longer connected to ORACLE.

listner service (OracleOra9iTNSListener) restarted then
restated databse service (OracleServiceT1)so pmon should reister same. & if TNS is not register how it allow me to login.

listener.ora file

LISTENER =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = best)(PORT = 1521))
)

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = Test)
(ORACLE_HOME = J:\Oracle)
(SID_NAME = Test)
)
(SID_DESC =
(GLOBAL_DBNAME = T1)
(ORACLE_HOME = J:\Oracle)
(SID_NAME = T1)
)
(SID_DESC =
(PROGRAM = extproc)
(SID_NAME = extproc)
(ORACLE_HOME = J:\Oracle)
)
)

[Updated on: Mon, 18 February 2008 15:50]

Report message to a moderator

Re: TNS:no listener [message #300941 is a reply to message #300940] Mon, 18 February 2008 15:53 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>> connect t1/t1
Will work, because there is only one database in the node or
ORACLE_SID is explicitly set so.
>>connect t1/t1@t1
may not work unless you have configured your tnsnames.ora file and have a tns entry for service name t1.
Search the forum/read documentation. Way too many examples to deal with this.
Re: TNS:no listener [message #300946 is a reply to message #300941] Mon, 18 February 2008 15:59 Go to previous messageGo to next message
itguru
Messages: 19
Registered: July 2007
Junior Member
tnsnamed.ora is already configure.

T1 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = best)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = T1)
)
)


it single home pc. So can say single tire working directly on server.



in afternoon i was not able to connect by user/passowrd.

When I supplied username/password@sid then was able to login.


So why its being change now.
Re: TNS:no listener [message #300948 is a reply to message #300946] Mon, 18 February 2008 16:06 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
You have to say. It is your environment Smile
May be the listener is down.

>>tnsnamed.ora
you mean tnsnames.ora ?
Watch for typos when using technical terms.
Re: TNS:no listener [message #300950 is a reply to message #300948] Mon, 18 February 2008 16:11 Go to previous message
itguru
Messages: 19
Registered: July 2007
Junior Member
Mahesh Rajendran wrote on Mon, 18 February 2008 16:06
You have to say. It is your environment Smile
May be the listener is down.

>>tnsnamed.ora
you mean tnsnames.ora ?
Watch for typos when using technical terms.



that’s true.



is already 3:30am & typing in half sleep.

from windows services chk listener is running fine & as mention earlier even restarted same.




TNSNAMES.ORA
T1 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = best)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = T1)
)
)

TEST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = best)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = Test)
)
)

can I confirm from GUI mode eg net manager that is running & database SID is register.

[Updated on: Mon, 18 February 2008 16:15]

Report message to a moderator

Previous Topic: fuzzy from V$datafile_header
Next Topic: Check free extents for TABLE and Index Segment
Goto Forum:
  


Current Time: Sat Dec 10 07:20:11 CST 2016

Total time taken to generate the page: 0.14116 seconds