From: deepthought!neil (Neil Greene)
Subject: Re: Linking to SPARC based ORACLE using DBKit ?
Reply-To: Neil_Greene@kynug.org
Organization: Kentucky NeXT User Group, Inc.
Date: Fri, 18 Dec 1992 20:45:40 GMT

In article <1992Dec18.180203.4193@bas-a.bcc.ac.uk> sheep@tankgirl (Sheep  
T. Iconoclast) writes:
> Hi we just upgrade to Next Step 3.0 , and I noticed this pretty funky
> DBKit. We have some nothing but ORACLE running on a SPARC is
> possible people in another deparment working on a collaboartive project.
> 
> I wanted to show off the Next Step by linking to there own database from 
> our next machines (both on the Internet why not ?). As far as I  
understand 
> you begin by createing a DBModel using the DBModeler. 
> 
> Stage 1. in DBModeler do new and Select the Adaptor. 
> Ok Select ORACLE
> Stage 2. Fill in the link information
> SERVER ID, Hostmachine,Login, Password.
> for SERVER ID I used the setenv ORACLE_SID value let's say ualoracle
> for hostmachine i used fish (I tested and can ping fish ok).
> for login I used patric (they only have one user on the DB)
> for the password I used flatfish (the only password for the only user) 
> 
> I press the OK button and the same dialog box returns.
> QUESTION What's missing ? What's wrong ?
> 
> The RTFM says "In general, if you can connect with Sybase's isql or  
> Oracle's sqlplus, then you should be able to connect from DBModeler".
> OK I want to get this straight. Does this mean that 
> a) you cannot link to a remote machine running SQL ie if you
> want to use the adapter then you must perchase Oracle first.
> b) You cannot link to a remote non next machine running Oracle 
> ie you can only link to Oracle on  remote Next. 
> 
> I have problems with this because they can talk to the Oracle 
> server from some Macs they have in there department.
> 
> As far as DBModeler goes why is there not any error messages. Networking 
> with other machines is really really difficuly, error messages must come  
> up
> to help work out who's at fault. I think this is a fundermental fault of 
> client server computing. 
> 
> Will the DB modler link not go beyond the local gateway (they are in a  
> diffrent 
> department).
> We know the wacky symbols to type in like the 
> "scott/tiget@T:alexandra:sjOracle"
> but cannot get to the Login string stage (shown later in the DBModeler 
> documentation).
> 
> I'm looking for help finding out what's going wrong. I know I get
> some Input/output packets at the first attempt but after that nothing.
> 
> All help gratefully accepted 
> sheep.
> 
> Ps 
> happy Xmas ! 

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:

> Q:  What should I do on the NeXT in order to use my Oracle server with 
> DBKit?
> 
> A:  You need to do the following: 
> 
> 1) If you just want to use the NeXT as a client:
> 
> a) Check with the Oracle DBA to verify that the database is using socket 
> 1525 (this is the default).  Enter the following into /etc/services:
> 	orasrv     1525/tcp     oracle
> 
> b) Niload the Oracle services.  Be sure to check with the Oracle DBA to 
> verify that the database is using socket 1525 (this is the default).  If 
> you want your entire network of NeXT machines to see the server,  niload 
> the entry in  the root NetInfo domain on the master NetInfo server.
>  	localhost> su
> 	localhost# niload services / </etc/services
> 

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:

> Q:  The model that I built via DBModeler only shows the views and tables 
> owned by me.  How can I access all the views and tables from my Oracle 
> database? 
> 
> A:  By default, DBModeler will load in tables and views owned by  the 
> current user only.  However, you can extend the list of users for whom 
> tables and views should be loaded in.  To do so, add the following to 
> the defaults database for example, to show the tables and views owned by 
> the users David, Joe, Tony:
> 
> localhost> dwrite OracleAdaptor OracleTableOwners "'DAVID','JOE','TONY'"

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
	
--
Neil Greene
President, Kentucky NeXT User Group, Inc.
Email: Neil_Greene@kynug.org [NeXTMail]
-- 
Neil Greene
President, Kentucky NeXT User Group, Inc.
Email: Neil_Greene@kynug.org [NeXTMail]
Newsgroups: comp.sys.next.programmer