Re: Installing Oracle 8.0.3
Date: 1998/01/28
Message-ID: <6analo$sec_at_bgtnsc03.worldnet.att.net>
Hi,
I had some problem to install and connect to PO8.
But not with JAVA (I have IE4 installed in my computer)
Have a look at my earlier posted mesg.
Hope that will help.
Madhu Cherukuri
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> > > > > > >
Juergen Stienecke wrote in message <34CE0826.C88ABCF6_at_dicad.de>...
Hi all,
today I tried to install on Oracle8 Database.
After Installing server I tried to configure database alias using
'SQL*Net8 Easy Config'.
This program always gets an execption in JAVA.EXE. We are using WinNT4.0 service pack 3. Installed was the Internet Explorer 3.2. Because we couldn't read online-docu we installed netscape 3.1: Now java in documentation was better, but SQL*NET just ends in JAVA.EXE. Do we have to install Client Software on this computer, too ?
Greetings
Juergen Stienecke
mailto:stien_at_dicad.de
/^\
/^\
| \ /^\ /****\ |*****| |****\
| | | | | | |*/ |*| |*| |*| |*| |*|
| | | | | | |*| |*****| |*| |*|
| | | | | | |*\ |*| |*| |*| |*| |*|
| / | | \****/ |*| |*| |****/
Software GmbH Tel +49-2203-9313-0
Theodor-Heuss-Str. 92-100 Fax -199
D-51149 Koeln http://www.dicad.de/
---------------------------------------------------
--Received on Wed Jan 28 1998 - 00:00:00 CET