0

I need urgent Help plz.
scenario: Oracle Database and Client 10g are installed on same system.
I want to connect my website with database ( i am new to oracle and ASP.Net)
ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
My web.config file contains code

<?xml version="1.0"?>
<configuration xmlns="http://schemas.microsoft.com/.NetConfiguration/v2.0">
	<appSettings>
  <add key="MM_CONNECTION_HANDLER_ictmdb" value="default_oledb.htm" />
  <add key="MM_CONNECTION_STRING_ictmdb" value="Provider=MSDAORA.1;User ID=ictm;Password=ictm;data source=orcl"/>
  <add key="MM_CONNECTION_DATABASETYPE_ictmdb" value="OleDb" />
  <add key="MM_CONNECTION_SCHEMA_ictmdb" value="" />
  <add key="MM_CONNECTION_CATALOG_ictmdb" value="" />
  <add key="CSS_PATH" value="/ictm/css" />
  <add key="IMG_PATH" value="/ictm/soft/tmp/" />
 </appSettings>
	<connectionStrings/>

tnsnames.ora

# tnsnames.ora Network Configuration File: e:\oracle\database\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

ICTMUSER =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = Demo)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = orcl)
    )
  )

ORCL =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orcl)
    )
  )

EXTPROC_CONNECTION_DATA =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
    )
    (CONNECT_DATA =
      (SID = PLSExtProc)
      (PRESENTATION = RO)
    )
  )

It will be kindness if help me step by step I am trying to connect my database on same machine

1
Contributor
1
Reply
6
Views
6 Years
Discussion Span
Last Post by naveedqadri
0

Hi every Body, Problem is solved by my self,

I jut delete the "data source=orcl" from my web.config file
its running now


I need urgent Help plz.
scenario: Oracle Database and Client 10g are installed on same system.
I want to connect my website with database ( i am new to oracle and ASP.Net)
ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
My web.config file contains code

<?xml version="1.0"?>
<configuration xmlns="http://schemas.microsoft.com/.NetConfiguration/v2.0">
	<appSettings>
  <add key="MM_CONNECTION_HANDLER_ictmdb" value="default_oledb.htm" />
  <add key="MM_CONNECTION_STRING_ictmdb" value="Provider=MSDAORA.1;User ID=ictm;Password=ictm;data source=orcl"/>
  <add key="MM_CONNECTION_DATABASETYPE_ictmdb" value="OleDb" />
  <add key="MM_CONNECTION_SCHEMA_ictmdb" value="" />
  <add key="MM_CONNECTION_CATALOG_ictmdb" value="" />
  <add key="CSS_PATH" value="/ictm/css" />
  <add key="IMG_PATH" value="/ictm/soft/tmp/" />
 </appSettings>
	<connectionStrings/>

tnsnames.ora

# tnsnames.ora Network Configuration File: e:\oracle\database\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

ICTMUSER =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = Demo)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = orcl)
    )
  )

ORCL =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orcl)
    )
  )

EXTPROC_CONNECTION_DATA =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
    )
    (CONNECT_DATA =
      (SID = PLSExtProc)
      (PRESENTATION = RO)
    )
  )

It will be kindness if help me step by step I am trying to connect my database on same machine

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.