| ora-12541 error [message #118382] |
Wed, 04 May 2005 16:11  |
wsyeager
Messages: 8
Registered: May 2005
|
Junior Member |
|
|
While trying to establish a connection via an oracle dataadapter from within visual studio, I am getting the infamous : "ORA-12541: TNS:No Listener" msg.
I may also get the "ORA-12514:TNS:Listener does not currently know of service requested in connect descriptor"
I have allowed access to ORACLE.EXE with my mcAfee personal firewall.
I am able to TNSping my server.
The "OracleOraDb10g_home1TNSListener" windows service is Started. I've even tried restarting it.
Here is the contents of my tnsnames.ora file:
# tnsnames.ora Network Configuration File: C:\oracle\product\10.1.0\Db_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = DBTYZQ41)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
Here is the contents of my Listener.ora file:
# listener.ora Network Configuration File: C:\oracle\product\10.1.0\Db_1\network\admin\listener.ora
# Generated by Oracle configuration tools.
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:\oracle\product\10.1.0\Db_1)
(PROGRAM = extproc)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = DBTYZQ41)(PORT = 1521))
)
)
)
I'm really tearing my hair out on this one. Can someone please help me with this error.
I'm typing in "DBTYZQ41" as my server name within visual studio and entering my "SYSTEM" userid and my password which I know is correct.
I can't believe it's this hard to work with ORACLE and resolve a simple connection issue.
|
|
|
|
| Re: ora-12541 error [message #118428 is a reply to message #118382] |
Thu, 05 May 2005 03:27  |
girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)
|
Senior Member |
|
|
Add the following entry in listener.ora file under the SID_LIST parameter & then try:
(SID_DESC =
(ORACLE_HOME = C:\oracle\product\10.1.0\Db_1)
(SID_NAME = orcl)
)
|
|
|
|
| Re: ora-12541 error [message #118534 is a reply to message #118428] |
Thu, 05 May 2005 13:23 |
wsyeager
Messages: 8
Registered: May 2005
|
Junior Member |
|
|
I'm trying to configure an oracle dataadapter within VS.NET 2003, and am having problems doing so.
I wanted to find out if the OracleDataAdapter is capable of generating Typed Datasets....
I keep getting the error:
"Microsoft DataLink Error
Test connection failed because of an error in initializing provider. ORA-12514: TNS:listener does not currently know of service requested in connect descriptor"
I am placing the server name of: DBTYZQ41 and a Username of: "SYSTEM" and my password as something else. When I try testing the connection, I get the above error.
Here is some more info:
While trying to establish a connection via an oracle dataadapter from within visual studio, I am getting the infamous : "ORA-12541: TNS:No Listener" msg.
I may also get the "ORA-12514:TNS:Listener does not currently know of service requested in connect descriptor"
I have allowed access to ORACLE.EXE with my mcAfee personal firewall.
I am able to TNSping my server.
I can connect to the DBTYZQ41 server via SQLPlus by typing in "SYSTEM" for the UserID and my password as something else.
The "OracleOraDb10g_home1TNSListener" windows service is Started. I've even tried restarting it.
Here is the contents of my tnsnames.ora file:
# tnsnames.ora Network Configuration File: C:\oracle\product\10.1.0\Db_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = DBTYZQ41)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
Here is the contents of my Listener.ora file:
# listener.ora Network Configuration File: C:\oracle\product\10.1.0\Db_1\network\admin\listener.ora
# Generated by Oracle configuration tools.
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:\oracle\product\10.1.0\Db_1)
(PROGRAM = extproc)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = DBTYZQ41)(PORT = 1521))
)
)
)
When I also hover my mouse over the "Oracle Explorer" tab, just the Oralce Output window comes up and no databases are shown.
I'm really tearing my hair out on this one. Can someone please help me with this error.
I'm typing in "DBTYZQ41" as my server name within visual studio and entering my "SYSTEM" userid and my password which I know is correct.
I can't believe it's this hard to work with ORACLE and resolve a simple connection issue. I've unistalled and reinstalled the 10g database software 3 times, and I refuse to do it any further.
How can I properly configure this connection issue? No wonder why ORACLE needs a DBA to administer it. It's simply too cumbersome for a developer to configure and work with.
The above errors (ORA-12514 & ORA-12541) appear all over the internet, but there doesn't seem to be a definite resolution to fix any of them. Anything that you try, doesn't fix the problem.
Does anyone know how this can be resolved???
|
|
|
|
| Re: ora-12541 error [message #118641 is a reply to message #118534] |
Fri, 06 May 2005 11:49 |
girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)
|
Senior Member |
|
|
Use the following listener.ora file:
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:\oracle\product\10.1.0\Db_1)
(PROGRAM = extproc)
)
(SID_DESC =
(ORACLE_HOME = C:\oracle\product\10.1.0\Db_1)
(SID_NAME = orcl)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = DBTYZQ41)(PORT = 1521))
)
)
)
After refreshing listener type the following at the command prompt:
tnsping orcl
If u get OK response then ur listener configuration is fine.
|
|
|
|
|
|
|
|
|
|
| Re: ora-12541 error [message #118747 is a reply to message #118663] |
Sat, 07 May 2005 15:05 |
girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)
|
Senior Member |
|
|
As per last screen shot the listener hasn't got refreshed.
First stop the listener.
lsnrctl stop
& then start it again
lsnrctl start.
After this do try out.
|
|
|
|
|
|
|
|
|
|
| Re: ora-12541 error [message #119187 is a reply to message #118934] |
Wed, 11 May 2005 01:48 |
girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)
|
Senior Member |
|
|
HI
Uncomment the follwing line in sqlnet.ora:
NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
& then try after refreshing the listener.
This time it shd work.
Regds
Girish
|
|
|
|
| Re: ora-12541 error [message #119188 is a reply to message #119187] |
Wed, 11 May 2005 01:52 |
girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)
|
Senior Member |
|
|
Also add the following entry in tnsnames.ora
ORCL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = DBTYZQ41)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
