Article View: comp.sys.next.programmer
Article #2169Re: Linking to SPARC based ORACLE using DBKit ?
From: David Apfelbaum
Date: Sun, 03 Jan 1993 19:46
Date: Sun, 03 Jan 1993 19:46
59 lines
2642 bytes
2642 bytes
Sorry folks, but my email bounces to the origianl sender & I thought
this might be of general use...
Excerpts from netnews.comp.sys.next.programmer: 18-Dec-92 Re: Linking to
SPARC based .. by Neil Greene@???
>In article <1992Dec18.180203.4193@bas-a.bcc.ac.uk> sheep@tankgirl (Sheep
>T. Iconoclast) writes:
>>
>> <Messege deleted for space, basically questions about connecting to
>> an oracle server on a SPARC from a NeXT, and said difficulties...>
>
>You will have to modify your NeXT NetInfo database alittle to allow it to
>communicate with the Oracle server on port 1525. This information can now
>be found in the 93_Winter_NeXTAnswers, but here it is:
>
Keep in mind that this is merely registering the tcp socket-port number.
It also helps to be running the deamon process that will listen on this
socket -- namely oracle's ORASRV. Note: DBKit can NOT talk to Oracle
without this process running! (Even when it's on the same machine...)
I suggest you ask the SPARC guys to contact Oracle & obtain this program!
>
>Also remember, that the Oracle Adaptor is _only_ going to see tables owned
>by the user logging into the Oracle server thru the adaptor. To see
>tables used by others for use in the DBModeler, see the following. Also
>found in 93_Winter_NeXTAnswers:
>
humf. Running DBModeler, under the "Entity" menu,
select "Choose Entities...". Then log into oracle as the oracle user of
your choice. Select the tables you wish to build a model for... Boom,
your halfway there... (You still need to enter the relationships...
And allow the original account permission to select said tables...)
Anyway, it makes life easier...
>If that still does not work, I would check for the correct information to
>be correct:
>
> Oracle instance name (this is the database name)
> Oracle user account
> Oracle user password
>
YES!!! Particularly check that the letter-CASE is correct! And that
your NeXT can access the SPARC-machine! (telnet sparc.machine??).
Good luck.
-David.
Technical Details
Message-ID:
<YfFwx=G00WA74v8YUO@andrew.cmu.edu>Path:
arc1-ca.pugleaf.net!sparky!uunet!spool.mu.edu!uwm.edu!ogicse!das-news.harvard.edu!cantaloupe.srv.cs.cmu.edu!crabapple.srv.cs.cmu.edu!andrew.cmu.edu!da0g+Show Full Headers
Complete Article Headers
Path: arc1-ca.pugleaf.net!sparky!uunet!spool.mu.edu!uwm.edu!ogicse!das-news.harvard.edu!cantaloupe.srv.cs.cmu.edu!crabapple.srv.cs.cmu.edu!andrew.cmu.edu!da0g+ From: da0g+@andrew.cmu.edu (David Apfelbaum) Newsgroups: comp.sys.next.programmer Subject: Re: Linking to SPARC based ORACLE using DBKit ? Message-ID: <YfFwx=G00WA74v8YUO@andrew.cmu.edu> Date: 3 Jan 93 19:46:51 GMT Article-I.D.: andrew.YfFwx=G00WA74v8YUO Organization: Carnegie Mellon, Pittsburgh, PA Lines: 59 In-Reply-To: <1992Dec18.204540.8033@kynug.org>