| connection problem [message #167860] |
Mon, 17 April 2006 09:41  |
leo1
Messages: 7
Registered: April 2006
|
Junior Member |
|
|
I've successfully installed Oracle 9i Release 9.2.0.1.0 and Oracle
Forms Developer and Forms Server 6i (Patch 2) on a stand-alone PC
running on Windows XP Pro but cannot connect to my Oracle server through form6i i get the error ORA-12154: TNS:could not resolve service name.
The TNSNAMES.ORA file for Oracle 9i reads as follows:
# TNSNAMES.ORA Network Configuration File:
C:\oracle\ora92\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.
OPSDATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = jgyk801)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = OpsData.jgyk801)
)
)
INST1_HTTP =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = jgyk801)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = SHARED)
(SERVICE_NAME = MODOSE)
(PRESENTATION = http://HRService)
)
)
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
DEMO =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = jgyk801)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = demo.jgyk801)
)
Any one please help
[Updated on: Mon, 17 April 2006 09:45] Report message to a moderator |
|
|
|
| Re: connection problem [message #167889 is a reply to message #167860] |
Mon, 17 April 2006 14:14  |
andrew again
Messages: 2577
Registered: March 2000
|
Senior Member |
|
|
http://www.orafaq.com/faqnet.htm
Each Oracle installation directory looks for it's own tnsnames.ora file. This means that if you run SQL*Plus or whatever from cmd prompt, it may be a different Oracle home to Forms. You can set TNS_ADMIN environment variable to point to a single tnsnames location for all Oracle homes. By default I think (check the docs) it looks in your current directory, then TNS_ADMIN location (if defined) then the regular ...\network\admin location for that home.
C:\>echo %TNS_ADMIN%
C:\ORACLE\TNS_ADMIN
C:\>tnsping db123
TNS Ping Utility for 32-bit Windows: Version 9.2.0.6.0 - Production on 17-APR-2006 11:59:39
Copyright (c) 1997 Oracle Corporation. All rights reserved.
Used parameter files:
C:\ORACLE\TNS_ADMIN\sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (COMMUNITY = tcp.world) (PROTOCOL = TCP) (HOST = myhost) (PORT = 1521)) (CONNECT_DATA = (SID = DB123)))
OK (60 msec)
C:\>
Also check the contents of your sqlnet.ora to see if NAMES.DEFAULT_DOMAIN is defined. Try specifying your connect string with and without the domain (.world or whatever) in Forms. Set TRACE_LEVEL_CLIENT in sqlnet.ora if all else fails to see more detail.
|
|
|
|
|
|
|
|
| Re: connection problem [message #168197 is a reply to message #167860] |
Wed, 19 April 2006 04:38 |
leo1
Messages: 7
Registered: April 2006
|
Junior Member |
|
|
I have sorted my problem Yahooo! What I did is that I first installed the oracle 9i server and then form6i, after installation I went to C:\oraform6i\net80\\admin\tnsnames.ora and done the following changes to the file.
The TNSNAMES.ORA file for Developer 6i before change reads as follows:
Beq-local.world =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = beq.world)
(PROTOCOL = BEQ)
(PROGRAM = oracle73)
(ARGV0 = oracle73ORCL)
(ARGS = '(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq))) ')
)
)
(CONNECT_DATA = (SID = ORCL)
)
)
Tcp-loopback.world =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcp.world)
(PROTOCOL = TCP)
(Host = 127.0.0.1)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = ORCL)
))
Example1.world =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcp.world)
(PROTOCOL = TCP)
(Host = Production1)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = SID1)
)
)
Example2.world =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = spx.world)
(PROTOCOL = SPX)
(Service = Server_lsnr)
)
)
(CONNECT_DATA = (SID = ORCL)
)
)
Example3.world =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = nmp.world)
(PROTOCOL = NMP)
(Server = FinanceServer1)
(Pipe = ORAPIPE)
)
)
(CONNECT_DATA = (SID = ORCL)
)
)
I only changed the bold portion as follows:
ntc =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcp.world)
(PROTOCOL = TCP)
(Host = pc1)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = ntc)
Note:ntc is the SID name of database and pc1 is my PC name.
Hope this will help others having the same problem.
[Updated on: Wed, 19 April 2006 04:41] Report message to a moderator |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
