ORA-12541: TNS: no listener process
than24
Posted messages
70
Status
Membre
-
Manutche -
Manutche -
Hello,
I just installed Oracle 11g and I'm integrating it with Toad for Oracle.
When I use SQL Plus, I can access the database normally
but I can't access it from Toad for Oracle (this error message appears: "ORA-12541: TNS: no listener process"). The problem persists when I try to connect from a Java program.
I don't know if there's a way to fix this issue; I've done some research on Google but haven't been able to find a solution. If anyone has any insight, please respond. Thank you.
Configuration: Windows XP / Firefox 3.6.8
I just installed Oracle 11g and I'm integrating it with Toad for Oracle.
When I use SQL Plus, I can access the database normally
but I can't access it from Toad for Oracle (this error message appears: "ORA-12541: TNS: no listener process"). The problem persists when I try to connect from a Java program.
I don't know if there's a way to fix this issue; I've done some research on Google but haven't been able to find a solution. If anyone has any insight, please respond. Thank you.
Configuration: Windows XP / Firefox 3.6.8
2 réponses
Thank you for responding:
The content of the tnsnames.ora file is as follows:
**************************************************
# tnsnames.ora Network Configuration File: E:\app\belhocine\product\11.1.0\db_1\NETWORK\ADMIN\tnsnames.ora
# Generated by Oracle configuration tools.
ORCL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = belhocin-e2b233)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
*******************************************************
And the content of the listener.ora file is:
***********************************************
# listener.ora Network Configuration File: E:\app\belhocine\product\11.1.0\db_1\network\admin\listener.ora
# Generated by Oracle configuration tools.
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = belhocin-e2b233)(PORT = 1521))
(PROTOCOL_STACK =
(PRESENTATION = GIOP)
(SESSION = RAW)
)
)
)
***********************************************************
For the listener services, I don't know how to check.
I hope the information I just provided will help you find the problem because I really don't know how to fix it.
Thank you again.
The content of the tnsnames.ora file is as follows:
**************************************************
# tnsnames.ora Network Configuration File: E:\app\belhocine\product\11.1.0\db_1\NETWORK\ADMIN\tnsnames.ora
# Generated by Oracle configuration tools.
ORCL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = belhocin-e2b233)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
*******************************************************
And the content of the listener.ora file is:
***********************************************
# listener.ora Network Configuration File: E:\app\belhocine\product\11.1.0\db_1\network\admin\listener.ora
# Generated by Oracle configuration tools.
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = belhocin-e2b233)(PORT = 1521))
(PROTOCOL_STACK =
(PRESENTATION = GIOP)
(SESSION = RAW)
)
)
)
***********************************************************
For the listener services, I don't know how to check.
I hope the information I just provided will help you find the problem because I really don't know how to fix it.
Thank you again.
Yet I did all the configurations.