Home » Developer & Programmer » Forms » ORA-12514 Error in Oracle Forms (Oracle 10g,Developer suite 10g,Windows XP)
ORA-12514 Error in Oracle Forms [message #317841] Sun, 04 May 2008 03:55 Go to next message
kishorebonthala
Messages: 15
Registered: May 2008
Location: Bangalore
Junior Member

Hi friend,

Here i have one query. Please help me.
I installed oracle 1og(10.1.0.2.0) and Developer suite 10g in different folders(Paths), after that copied tnsnames.ora of oracle 10g to developer suite 10g.First time wast working properly, After restarting system occrured error as ORA-12514:TNS:listener does not currently know of services request in connection descriptor


Here i am pasting tnsnames.ora,sqlnet.ora and linstner.ora.

tnsnames.ora

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

SAMPLE =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = sample)
)
)

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



Sqlnet.ora
# sqlnet.ora Network Configuration File: D:\oracle\product\10.1.0\db_1\network\admin\sqlnet.ora
# Generated by Oracle configuration tools.

SQLNET.AUTHENTICATION_SERVICES= (NTS)

NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)


listener.ora
# listener.ora Network Configuration File: D:\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 = D:\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 = localhost)(PORT = 1521))
)
)
)


sqlnet.ora of devleopre suite.

# sqlnet.ora Network Configuration File: D:\DevSuiteHome_1\network\admin\sqlnet.ora
# Generated by Oracle configuration tools.

SQLNET.AUTHENTICATION_SERVICES= (NTS)

NAMES.DIRECTORY_PATH= (LDAP, TNSNAMES, EZCONNECT, ONAMES, HOSTNAME)


Please help me.

Regards,
Kishore
Re: ORA-12514 Error in Oracle Forms [message #318171 is a reply to message #317841] Tue, 06 May 2008 00:27 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Why do you guys keep on KILLING your tnsnames.ora files by blindly copying another file over the top of it!!!

Search this forum for 'tns_admin' and do things the EASY way.

David
Previous Topic: Connectivity Of D2K with MS Access
Next Topic: Auto Generated Record
Goto Forum:
  


Current Time: Thu Dec 08 02:05:06 CST 2016

Total time taken to generate the page: 0.08745 seconds