🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: comp.sys.next.programmer
Article #2169

Re: Linking to SPARC based ORACLE using DBKit ?

#2169
From: David Apfelbaum
Date: Sun, 03 Jan 1993 19:46
59 lines
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>