Re: Unable to connect to Oracle 9i database via Oracle 6i Developer
Re: Unable to connect to Oracle 9i database via
Oracle 6i Developer
Source:
http://newsgroups.derkeiler.com/Archive/Comp/comp.databases.oracle.tools/2006−02/msg00164.html
• From: rangoon
• Date: Thu, 23 Feb 2006 19:08:56 GMT
Virgil wrote:
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 databases via
Developer's various functions −− Graphics Builder, Query Builder,
Schema Builder, Procedure Builder, and Translation Builder. As you
know, these functions want to connect to a database but I get this
error at the Connect screen:
ORA−12154: TNS:could not resolve service name
As info, the user name and password are fine for both Oracle 9i and
Developer. Oracle 9i works fine. I can connect to my databases (Demo
and OpsData) with no problem in 9i's SQLPlus window. It's the
connections via Developer that's the problem. (In case you need to
know, Oracle 9i reside in the C:\Oracle\ora92 directory with ora92 as
the HOME. Developer 6i resides in the C:\Oracle\ora9i directory with
ora9i as its HOME.)
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 =
Re: Unable to connect to Oracle 9i database via Oracle 6i Developer 1
Re: Unable to connect to Oracle 9i database via Oracle 6i Developer
(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)
)
)
I understand this file OK, as I can see the parameters I supplied
during installation. (Yes, jgyk801 is my computer's name.)
The TNSNAMES.ORA file for Developer 6i 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)
)
Re: Unable to connect to Oracle 9i database via Oracle 6i Developer 2
Re: Unable to connect to Oracle 9i database via Oracle 6i Developer
)
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)
)
Re: Unable to connect to Oracle 9i database via Oracle 6i Developer 3
Re: Unable to connect to Oracle 9i database via Oracle 6i Developer
)
I don't understand this file at all as I don't recall supplying any of
these parameters during the installation.
Have I install the wrong Developer product? Is there a solution short
of uninstalling both applications and installing release 10g for both?
On a hunch, I saw a similar proble with Oracle 10g and tried copying
both the Oracle 9i TNSNAMES.ORA and SQLNET.ORA to the Developer
..\Net80\ADMIN directory, but I got another error
ORA−03106: fatal two−task communication protocol error.
As you can tell I'm very new to Oracle applications and may not
understand your answer if you respond in a way that assumes anything
but shear novice knowledge of the Oracle configuration process.
Try removing the tnsnames.ora file for the oracle forms 6i (save first somewhere) and copying tthe
tnsnames.ora from the 9l installation in its place. Also you can delete the tnsnames.ora from the oracle forms
(save first somewhere)create an system environment variable named tns_admin and set to the directory where
the tnsnames.ora for the Oracle 9i installation resides.
.
Re: Unable to connect to Oracle 9i database via Oracle 6i Developer 4