Dear All,
I am going to connect Oracle form 6i installed on Windows 7 32 Bit OS with Database 11G R2 installed on WIndows Server 2008 R2. But i am facing the number of issues. By the way i also knew that Oracle could not certify 6i forms any more but problem is that we can not upgrade the form due to some reason.
I have copied the tns entry from the database server and copied in form 6i tnsname file. The tnsname entry is also listed below. But when i click on the application, i got the error
"ora-12154 tns could not resolve service name.
hmis =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.29.3)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = hmis)
)
)
But when i add the word "world" with tns entry like "hmis.world" and click on the application than i got the error
ora-12514 message 12514 not found product=rdbms80 facility=ora
More over my form 6i sqlnet file entry is given below.
TRACE_LEVEL_CLIENT = OFF
#sqlnet.authentication_services = (NONE)
names.directory_path = (TNSNAMES, HOSTNAME)
names.default_domain = world
name.default_zone = world
automatic_ipc = off
Please help me to solve this problem. What is the impact of word world on the tns entry and what is the issues. My Database 11G R2 tnslistner
The command completed successfully
LSNRCTL> status
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 64-bit Windows: Version 11.2.0.1.0 - Produ
ction
Start Date 02-SEP-2015 13:42:43
Uptime 0 days 2 hr. 44 min. 13 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File D:\app\Administrator\product\11.2.0\dbhome_1\network\a
dmin\listener.ora
Listener Log File d:\app\administrator\diag\tnslsnr\WIN-HV65NT4VJGS\list
ener\alert\log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1521ipc)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=172.16.29.3)(PORT=1521)))
Services Summary...
Service "CLRExtProc" has 1 instance(s).
Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully