RE: PO8 connectivity with D2K under Windows95
Date: 1998/01/20
Message-ID: <6a3r31$o0k_at_bgtnsc01.worldnet.att.net>#1/1
Lynch,
Thanks! It worked!
But there is another problem I'm facing between Des2K and PO8
That is I'm unable to install the Repository.
When I start the Repository Admin utility and try to
install, it seems to try to import and that process is
terminated with the following series of mesgs.
Connecte to Personal Oracle 8.0.3.0.0 production
Imp ..... Oracle error 942 encountered ............ Table or view does not exist ............ Import views not installed notify your DBA ............ Import terminated unsuccessfully.
Anybody has done this ?
Please help me
Madhu Cherukuri <Madhu.Cherukuri_at_worldnet.att.net>
-----Original Message-----
From: Michael D. Lynch [SMTP:c-lmd1_at_math.utah.edu]
Sent: Tuesday, January 20, 1998 3:33 AM
To: Madhu.Cherukuri_at_worldnet.att.net
Subject: Re: PO8 connectivity with D2K under Windows95
Not so easy, eh. Took me a little while as well. Here's the source of the problem:
D2K can only use the Oracle 2.3.x.x SQL-Net and protocol adapters. Why then
is net80 there then? Beats me! The only net8 component you'll use (or
need)
is the listener. Therefore, you'll need to do a custom installation of
SQL-Net 2.3.x.x. I believe its on the PO8 disk. Be sure to leave Net8
installed as well.
Here's how I did it. First setup your listener.ora under
orawin95/net80/admin so that it reads as follows (notice I got rid of the
localhost hostname - it was causing me problems!):
LISTENER =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = TCP)
(Host = 127.0.0.1)
(Port = 1521)
)
)
STARTUP_WAIT_TIME_LISTENER = 0
CONNECT_TIMEOUT_LISTENER = 99
TRACE_LEVEL_LISTENER = ADMIN
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = ORCL)
)
)
Secondly, make sure that your HOSTS file (not HOSTS.SAM but HOSTS -
duplicate
with no suffix) has the following:
127.0.0.1 localhost 127.0.0.1 lynch
In my case lynch is the name of my computer (under the identification tab in the control panel - network settings). Change yours appropriately.
Run regedit and change HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\LISTENER_STARTUP
TO
AUTO (FROM NOAUTO ORIGINALLY). This way your NET8 listener will startup
automatically when you start PO8.
Edit your tnsnames.ora (for sql-net 2.3) under orawin95/network/admin so
that
you have a TCP/IP connection to the corresponding Net8 listener. Here's the
respective lines from mine so you can follow along:
lynchtcp.world =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcp.world)
(PROTOCOL = TCP)
(Host = 127.0.0.1)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = ORCL)
)
)
You probably want to use SQL-Net Easy Config (for 2.3 - not 8!) to simplify this task.
You should be able to make a connection via any 2.3 SQL-Net tools - this
would include SQL-Plus 3.X and D2K anything (including 2.0!). This seems
odd
to me but it seems any older files are hard-coded in some way to only be
able
to access SQL-Net 2.3.
You may have to hard-code your scripts so that they access this 2.3 connection as system/manager_at_lynchtcp (for example).
Anyway, its working great for me.
Please tell me how this works and do me the return favor of posting this to the newsgroup so others can benefit from this as well. I don't have this capability setup at the present time.
Thanks,
Mike Lynch
Data Warehouse Practice Mgr.
BEST Consulting
On Mon, 19 Jan 1998 21:36:22 -0500, you wrote: Madhu,
>Can anybody help me how to connect PO8 database >to work with Dev2K/Des2K under Winows95? >PO8 and D2K both are installed in ORAWIN95 home directory. >Sqlplus80 connects fien with the database but if I try to connect >with Sqlplus33 or Forms4.5 it returns an error >ORA-03121 No interface driver connected function not performed > >Any help is appreciated. > >Thanks > >Reply to >Madhu Cherukuri <Madhu.Cherukuri_at_worldnet.att.net> > > > > > >Received on Tue Jan 20 1998 - 00:00:00 CET