| TNS:no listener [message #300940] |
Mon, 18 February 2008 15:46  |
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 #300946 is a reply to message #300941] |
Mon, 18 February 2008 15:59  |
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 #300950 is a reply to message #300948] |
Mon, 18 February 2008 16:11 |
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 
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 |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
