Home » Developer & Programmer » Forms » ORA-12514: TNS: Listner does not currently know of service requested in connector descriptor
ORA-12514: TNS: Listner does not currently know of service requested in connector descriptor [message #411529] Sat, 04 July 2009 14:04 Go to next message
alez1601
Messages: 2
Registered: July 2009
Location: Student
Junior Member

Now another issue I get. I have Oracle App Server XE 10g and Forms and Reports 10. The Forms builder does not connect to the App server.

ORA-12514: TNS: Listner does not currently know of service requested in connector descriptor.

Here are:

sqlnet.ora
# sqlnet.ora Network Configuration File: C:\oracle\product\10.1.0\DB\network\admin\sqlnet.ora
# Generated by Oracle configuration tools.

SQLNET.AUTHENTICATION_SERVICES= (NTS)

NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)


tnsnames.ora
# tnsnames.ora Network Configuration File: C:\oracle\product\10.1.0\db_3\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

ORCL =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(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)
    )
  )


listner.ora
# listener.ora Network Configuration File: C:\oraclexe\app\oracle\product\10.2.0\server\NETWORK\ADMIN\listener.ora
# Generated by Oracle configuration tools.

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = D:\DevSuiteHome_1)
      (PROGRAM = extproc)
    )
  )

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
      )
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
      )
    )
  )

[EDITED by DJM: removed reference to another thread]

[Updated on: Mon, 13 July 2009 01:12] by Moderator

Report message to a moderator

Re: ORA-12514: TNS: Listner does not currently know of service requested in connector descriptor [message #412841 is a reply to message #411529] Mon, 13 July 2009 01:13 Go to previous message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Search this forum for the error messages that you have found. Also search this forum for 'tns_admin'.

David
Previous Topic: report called from form is taking long time to print
Next Topic: add picture on button
Goto Forum:
  


Current Time: Fri Sep 20 10:45:14 CDT 2024