| ORA-12514 Error in Oracle Forms [message #317841] |
Sun, 04 May 2008 03:55  |
kishorebonthala
Messages: 16
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  |
 |
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS 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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
