| Oracle forms [message #631070] |
Thu, 08 January 2015 14:26  |
 |
fatfish
Messages: 20
Registered: January 2015
|
Junior Member |
|
|
I am using Oracle forms version version 10.1.2.0.2 on a windows virtual pc running Windows XP.
When I run the form, I get the error message ORA-12560 TNS protocol adapter error.
I have configures tnsnames.ora and Listener.ora files with the Host name, but I am still getting the error.
I can run sqldeveloper,sqlplus and Reports builder with no problem.
Tns names file:
# tnsnames.ora Network Configuration File: C:\ORACLE\DevSuiteHome_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = VirtualXP-12345)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = PLSExtProc)
)
)
Listener.ora file
# listener.ora Network Configuration File: C:\oracle\product\10.2.0\db_1\network\admin\listener.ora
# Generated by Oracle configuration tools.
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
(ADDRESS = (PROTOCOL = TCP)(HOST = VirtualXP-12345)(PORT = 1521))
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:\oracle\product\10.2.0\db_1)
(PROGRAM = extproc)
)
)
|
|
|
|
|
|
|
|
|
|
|
|
| Re: Oracle forms [message #631183 is a reply to message #631171] |
Fri, 09 January 2015 23:26  |
 |
jgjeetu
Messages: 373
Registered: July 2013
Location: www.Orafaq.com/Forum
|
Senior Member |
|
|
did you start oracle services .
go to run ---> type services.msc -->restart orcale services where name ends with TNSlistener and ORCL (or restart all the services).
now try to login using / as sysdba.
if still you get error then open tnsnames.ora file and make following changes as mentioned below:-
type db name here for ex. orcl =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST =type computer name or ip here)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = type sid name here)
)
)
i am not sure first one is db name or something else. i will request to seniors please clearify this .
[Updated on: Fri, 09 January 2015 23:27] Report message to a moderator |
|
|
|
|
|
| Re: Oracle forms [message #631193 is a reply to message #631185] |
Sat, 10 January 2015 02:43 |
|
jgjeetu
Messages: 373
Registered: July 2013
Location: www.Orafaq.com/Forum
|
Senior Member |
|
|
i am quite sure you made changes in default block which is by default in tnsnames.ora file
which looks like:-
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = jgjeetu)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = PLSExtProc)
)
)
which is wrong , or you copied same block and pasted below but you didn't change db name i.e EXTPROC_CONNECTION_DATA
following can also be the cause:-
you didn't login on oracle forms using user/password@EXTPROC_CONNECTION_DATA.
possible solution could be:-
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = jgjeetu)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = PLSExtProc)
)
)
ORCL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST =computername)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl)
)
)
FATFISH =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST =computername)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl)
)
)
and login to forms using user/pwd@orcl or user/pwd@fatfish
[Updated on: Sat, 10 January 2015 02:48] Report message to a moderator |
|
|
|
|
|
|
|
|
|
| Re: Oracle forms [message #631587 is a reply to message #631352] |
Thu, 15 January 2015 10:40 |
|
fatfish
Messages: 20
Registered: January 2015
|
Junior Member |
|
|
I deleted all of Oracle from Windows Virtual PC and re-installed it.
I am still using the same TNSNAMES.ORA file.
Every thing is connecting and working properly.
Thanks for the help...
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
