HDTenEightyP/NetNews huggingface dataset:
From: orville%weyrich@uunet.uu.net (Orville R. Weyrich)
Subject: Loading Oracle 5.1A on OS/2 2.0 in a DOS BOX
Reply-To: uunet.uu.net!weyrich!orville
Organization: Weyrich Computer Consulting
Date: Sun, 20 Dec 92 01:00:06 GMT

Well, I have Oracle 5.1A for DOS, and the only machine I have handy that 
will meet the hardware requirements is the one running OS/2 2.0.

Yes, I know that Oracle 5.1A is old and obsolete, but hey, I need to develop
some stuff and don't have time nor money for an upgrade just now.

Anyway, the installation goes fine [after transferring to 3.5" disks and
makeing sure the disk labels are correct] until I get the messages

	Initializing the database
	IOR: Error 3121 Connecting to Oracle

	This installation did NOT pass our verification test.

	Error: Insufficient memory: 896K of extended memory required.

Well, I have 16M of memory installed, but even if I didn't, OS/2 is supposed 
to go virtual, right? I tried making a new dos program icon attached to
a:orainst, with XMS set to 10M, but the same problem occurred. I don't know
how to cause all the programs installed by orainst to access the XMS, and
evidently orainst runs some of these just-installed programs during the 
install.

Has anyone successfully installed this version of Oracle with OS/2 2.0?

How?

[Or does anyone have a developer's copy of Oracle that works with OS/2
for sale real cheap?]

Thanks for advice,


orville

--------------------------------------           ******************************
Orville R. Weyrich, Jr.                           Weyrich Computer Consulting
Certified Data Processor                         POB 5782, Scottsdale, AZ 85261
Certified Systems Professional                        Voice: (602) 391-0821
Internet: orville%weyrich@uunet.uu.net                Fax:   (602) 661-0660
--------------------------------------           ******************************
Newsgroups: comp.databases.oracle
From: nmrdb@vms.macc.wisc.edu (BEVERLY SEAVEY)
Subject: What is correct Pro*C syntax for selecting max?
Organization:  University of Wisconsin Academic Computing Center
Date: 17 DEC 92 13:01:12    

I'm writing a Pro*C program that needs to select a maximum on a column.

If I write the Pro*C as


     EXEC SQL SELECT max(seq_number)
     INTO :max_seq
     FROM protein_sequence

It hangs up. Removing the max fixes things, but that isn't the result
I want.

Sqlplus is perfectly happy with the analogous statement:

   SELECT mac(seq_number)
   FROM protein_sequence;

IS it possible to do this in Pro*C?
From: mikem@otc.otca.oz (Mike Mowbray)
Newsgroups: comp.databases.oracle
Subject: Looking for M.I.T.I SQL*C++ email contact
Keywords: SQL C++ Oracle MITI
Date: 17 Dec 92 01:51:47 GMT
Reply-To: mikem@otc.oz.au (Mike Mowbray)
Organization: R&D, OTC Sydney, Australia


Could someone please send me an email contact for an organization called
"MITI" in Long Beach CA USA. (They have a product called SQL*C++).

Thanks,

- Mike Mowbray		mikem@otc.oz.au



Newsgroups: comp.databases.oracle
From: mike@cray.com (Mike Carney)
Subject: Re: Question about OPS$LOGIN and Oracle Pas
Reply-To: mike@cray.com
Organization: Cray Research, Inc.
Date: 19 Dec 92 11:22:13 CST

We have taken a different approach to solving this problem.
We created a front-end routine that looks up the Oracle Id/password
based upon UNIX id.  The primary security issue is keeping the 
front-end procedure hidden.  People can use or not use the routine
as their needs dictate.  The primary reason we don't use OPS$
is that most of our users would need two Oracle accounts: 
<unix login> and OPS$<unix login>.    
---

Mike Carney  mike@cray.com         Cray Research, Inc.    (612) 683-5635
From: dave@us.oracle.com (Dave Dargo)
Newsgroups: comp.databases.oracle
Subject: Re: Question about OPS$LOGIN and Oracle Passwords
Date: 17 Dec 92 21:31:05 GMT
Organization: Oracle Corp., Redwood Shores CA
X-Disclaimer: This message was written by an unauthenticated user
              at Oracle Corporation.  The opinions expressed are those
              of the user and not necessarily those of Oracle.

lev@ipxed5.nswses.navy.mil (Lloyd E Vancil) writes:

>In article <1992Dec14.200952.22697@netcom.com> sjs@netcom.com (Stephen Schow) writes:
>>We routinely use the OPS$LOGIN feature of Oracle for all of our users.  This
>>way they don't have to worry about anything once they are logged onto the
>>UNIX machine.  They just type program / to run it with their UNIX login info.
>>
>>Question:  
>>

>>Could a user go into sql*plus with any convienient name and type
>>
>>	connect ops$user/bogus
>>
>>to get into that user's oracle accoun


>Emphatically YES


>This is a known security hole in the OPS$ user under oracle 6.. 
>I am not aware of the fix if any in trusted oracle or in
>oracle7.  

The syntax in ORACLE7 would be:

	create user <user_name> identified externally;

The <user_name> would be something of the order OPS$DAVE, i.e.

	create user ops$dave identified externally;

This would create a database user called ops$dave identified by
the operating system userid of dave.

However, you could specify
os_authent_prefix=""
in the init.ora file so that OPS$ would not be necessary, the same
definition would then be

	create user dave identified externally;

This would create a database user called dave identified by the
operating system userid of dave.

To prevent these accounts from being used over a network, set the
following init.ora parameter

remote_os_authent=false  (I'm not sure that I remember the name
				exactly)

Hope this helps,
Dave Dargo  (ddargo@oracle.com)
From: echoy@alfred.carleton.ca (Eugene Choy)
Newsgroups: comp.databases.oracle
Subject: Question using BETWEEN/AND cond with NEXT_DAY/DAY math
Summary: Question on using BETWEEN/AND with NEXT_DAY/DAY math
Date: 20 Dec 92 20:13:43 GMT
Organization: Carleton University


i am some trouble understanding how the BETWEEN/AND condition works
in conjunction with the NEXT_DAY function and DAYs arithmatic.

The following statement displays 'ok' >
SELECT 'ok' FROM DUAL WHERE 4 BETWEEN 4 AND 6;
SELECT 'ok' FROM DUAL WHERE 5 BETWEEN 4 AND 6;
SELECT 'ok' FROM DUAL WHERE 6 BETWEEN 4 AND 6;

which i assume that for the condition
   WHERE a BETWEEN b AND c
TRUE will be returned if 
   b >= a >= c
This is fine since it agrees with the oracle:sql maunual

Now, consider this statement 
   (assume NEXT_DAY(sysdate,'sunday') returns 3-jan-93):
----------------------------
SELECT 'ok' FROM DUAL 
WHERE
   to_date('1-jan-93','dd-mm-yy') BETWEEN
   NEXT_DAY(sysdate,'sunday')-2 AND
   NEXT_DAY(sysdate,'sunday');
----------------------------
this does not return 'ok'!!!!!
why is this the case? since,     
   NEXT_DAY(sysdate,'sunday')-2                 means 01-jan-93
   NEXT_DAY(sysdate,'sunday')                   means 03-jan-93




pls email back or post , any suggestions will be appreciated
#----------------------------------------------------------------------------
from Eugene Choy
echoy@alfred.ccs.carleton.ca
Ottawa (the Nation's capital), Canada. North America.
'Software stands between the user and the machine'
#----------------------------------------------------------------------------
From: casivils@lescsse.jsc.nasa.gov (craig sivils)
Newsgroups: comp.databases.oracle
Subject: Re: Explain THIS, please!
Date: 20 Dec 92 23:42:49 GMT
Organization: Lockheed Engineering and Sciences

In <1gtd91INN7ln@ef2007.efhd.ford.com> wwm@ef5003.efhd.ford.com (Bill Meahan) writes:

>I'm tearing my hair out at the following:


>SQL> l
>  1  select '%' Shift,
>  2   p.prefix||'-'||p.base_code||'-'||p.suffix||p.control_code PartNumber,
>  3   s.scrap_code Reason,
>  4   SUM(s.cost) TotalDollars
>  5   FROM cimcmms.scrap_count_history s, acg.part p
>  6   WHERE s.part_key=p.key
>  7    AND s.work_center_code = '75021'
>  8    AND s.production_date BETWEEN '1-Dec-92' AND '13-Dec-92'
>  9    AND s.shift LIKE '%'
> 10    AND s.part_key IN ( SELECT ss.part_key
> 11       FROM cimcmms.scrap_count_history ss
> 12       WHERE ss.work_center_code = '75021'
> 13        AND ss.production_date BETWEEN '1-Dec-92' AND '13-Dec-92'
> 14        AND ss.shift LIKE '%'
> 15        AND ROWID <11
> 16       GROUP BY ss.part_key
> 17       ORDER BY SUM(ss.cost) desc )
> 18   GROUP BY '%',
> 19   p.prefix||'-'||p.base_code||'-'||p.suffix||p.control_code,
> 20   s.scrap_code
> 21   ORDER BY p.prefix||'-'||p.base_code||'-'||p.suffix||p.control_code,
> 22*  SUM(s.cost) desc

>SQL> /
>     ORDER BY SUM(ss.cost) desc )
>     *
>ERROR at line 17: 
>ORA-00907: missing right parenthesis 

>SQL> spool off

>There certainly AREN'T any mismatched parentheses!

>Any ideas what is going on?

To answer your question: Take the order by clause out of the subquery.  

To answer your problem, (the reason you had the order by in, was to try to
                         get the top 10 somethings) Try rewriting the in as
                         a correlated Exists subquery with a nested subquery
                         to check that it is in the top 10 items. 

Example.

Table animals
ID   number,
Kind char(30),
Name char(30)

to select the id for the top 10 names within a kind, use the following query.

SELECT ID 
FROM   ANIMALS
WHERE  10 >= ( SELECT COUNT(*)
               FROM   ANIMALS CNT
               WHERE  CNT.KIND  = ANIMALS.KIND
               AND    CNT.NAME <= ANIMALS.NAME )

				Craig
Newsgroups: comp.databases.oracle
From: sjs@netcom.com (Stephen Schow)
Subject: Screen painting methods
Organization: Netcom - Online Communication Services  (408 241-9760 guest) 
Date: Fri, 18 Dec 1992 22:57:58 GMT


Anyone out there developed any good methods to avoid having to repaint the
screen every time they use the BLOCK-DEFAULT feature to automatically create
all the master-detail logic?
-- 
------------------------------------------------------------------
Steve Schow    | But you don't have to use the claw, if you
sjs@netcom.com | pick the pear with the big paw paw......
(415) 354-4908 | Have I given you a clue......?
               |                       - Baloo the Bear
------------------------------------------------------------------
From: pytlik@ra.cs.umb.edu (Marek Pytlik)
Newsgroups: comp.databases.oracle
Subject: Re: OPS$LOGIN : security hole?
Date: 17 Dec 92 01:55:56 GMT
Organization: University of Massachusetts at Boston, Dept of Math and CS

In article <8aT=R#A@engin.umich.edu> lwk@engin.umich.edu (Lewis W Kellum) writes:
>In article <1992Dec15.144220.25349@relay.nswc.navy.mil> rlarson@nswc-wo.nswc.navy.mil (Ruth Larson) writes:
>>
>>Steve Schow writes:
>>>We routinely use the OPS$LOGIN feature of Oracle for all of our users.  This
>>>way they don't have to worry about anything once they are logged onto the
>>>UNIX machine.  They just type program / to run it with their UNIX login info.
>>
>>>Question:  
>>
>>>When we create a new user as follows:
>>
>>>	grant connect to ops$user identified by bogus;
>>
>>>and we actually use the word 'bogus' as the oracle password.
>>
>>>Does this mean that user ops$user could login to Oracle with either
>>>the /, which would use his UNIX login info, or with 'bogus' as the
>>>password?
>>
>>Yes, this is EXACTLY the case.
>>
>>>Could a user go into sql*plus with any convienient name and type
>>
>>>	connect ops$user/bogus
>>
>>>to get into that user's oracle account
>>
>>Again, Yes.
>>
>>>We routinely use bogus to define new oracle users, but I am concerned about
>>>security loop holes.  We also use a number of macintosh client products that
>>>use the ops$user with the UNIX password to login.  I am beginning to think
>>>that we should make sure that the Oracle password is the same as the UNIX
>>>password and NOT use bogus for everyone?!@#%               
>>
>>I would NOT suggest making the Oracle password the same as the system password.
>>In many systems the logon password should only be known by the individual
>>user.  However, there's now need for *anyone* to have to know the ops$ password
>>for an individual user - he/she doesn't need to know it, and the DBA can 
>>always reset it without the user even being aware that it has been reset.
>>So use something random, and different for each ops$ account.  I like to pick 
>>a 3 or 4 digit (or larger) number and then spell it out in words.  Example: 
>>two_thousand_three_hundred_eleven.  *Nobody* including you will remember 
>>*that*, and it's pretty hard to guess!
>
>Here's another question: If I know Mr.Schow's unix login id, and the internet 
>hostname of his Oracle server, what keeps me from creating his login id
>on my host and connecting to his ops$ oracle account?  - Woody Kellum

sid of the datatabase that is running on that machine. You have to know
that to use connect string.

Subject of security hole using OPS$logins and Unix was discussed on this 
newsgroup before, so maybe you want to look for some archives of that 
group. (does such exist?).
From: dmcohen@anywhere.umd.edu (Dan Cohen)
Newsgroups: comp.databases.oracle
Subject: Oracle Comment
Summary: Oracle Sux!!!
Keywords: hate oracle weenie
Date: 14 Dec 92 20:03:02 GMT
Followup-To: /dev/null
Distribution: usa
Organization: Maryversity of Uniland


Oracle bites my weenie.  It is a lousy database.  No one should be 
tortured to use it.

-Dan

BTW- Hello Jeff!
From: cjackso@uswnvg.com (Clay Jackson)
Newsgroups: comp.databases.oracle
Subject: Re: SQL*Net IP interface
Date: 17 Dec 92 02:02:30 GMT
Organization: U S WEST NewVector Group, Inc.
X-Newsreader: Tin 1.1 PL5

Not that I'm an expert in Oracle license agreements, particularly those
with the Feds (and, I suspect that you'll probably be able to get at least
two divergent opinions from Oracle, depending on who you ask); but, it's
my understanding that Oracle is normally licensed by the total number of
USERS, no matter how they connect.  As far as multiple copies of
SQL*NET are concerned, at least on Unix, the SQL*NET "interface" is linked 
into both the tools (including the PRO*<language of your choice> runtime
libraries and the RDBMS "kernel" at INSTALL time.  At runtime, you should
only need ONE "server process" per SERVER.  The tools on each client
(including whatever code you develop in 3GLs) only need to be linked with
the correct libraries (which you would presumably do on the one machine).

As always, YMMV.


#include <std_disclaimer.h>
--
Clay Jackson - N7QNM
US WEST NewVector Group Inc
Bellevue, WA
uunet!uswnvg!cjackso
From: p228@uni05.larc.nasa.gov (Bailey Bob)
Newsgroups: comp.databases.oracle
Subject: Re: Accessing remote ORACLE data from a PC.
Date: 11 Dec 1992 17:56:50 GMT
Organization: Unisys-Hampton VA
NNTP-Posting-Host: uni05.larc.nasa.gov

In article <1992Dec8.212302.8619@esrican.uucp> aladak@esri.com writes:
>I need to bring ORACLE data located on a SUN 360 to EXCEL for WINDOWS running
>on a PC. We tried using a product called SECOND WIND which runs on EXCEL. The
>product needs SQL*Net with TPC/IP installed on the PC. After trying almost
>everything under the SUN, we still get a connect error.
>
>Has anyone done anything like this successfully with either of these or another
>product? I would appreciate any suggestions or pointers.

SQL*Net requires two files to be set up correctly before it will work:

	hosts
	services

The hosts file should contain a list of the system names & IP addresses:

	IP ADDRESS		HOSTNAME	ALIAS
	128.155.001.001		XYZSYSTEM	XYZ
	128.155.001.002		ABCSYSTEM	ABC

The services file must contain the following:

	ORASRV		1525/TCP

NOTE: the TCP assumes you are using TCP/IP protocol.

Bob Bailey

Newsgroups: comp.databases.oracle
From: mkay@sequent.com (Mary Kay Petersen)
Subject: Re: Accessing remote ORACLE data from a PC.
Organization: Sequent Computer Systems, Inc.
Distribution: na
Date: Fri, 11 Dec 92 20:49:30 GMT

p228@uni05.larc.nasa.gov (Bailey Bob) writes:

>In article <1992Dec8.212302.8619@esrican.uucp> aladak@esri.com writes:
>>I need to bring ORACLE data located on a SUN 360 to EXCEL for WINDOWS running
>>on a PC. We tried using a product called SECOND WIND which runs on EXCEL. The
>>product needs SQL*Net with TPC/IP installed on the PC. After trying almost
>>everything under the SUN, we still get a connect error.
>>
>>Has anyone done anything like this successfully with either of these or another
>>product? I would appreciate any suggestions or pointers.

>SQL*Net requires two files to be set up correctly before it will work:

>	hosts
>	services

>The hosts file should contain a list of the system names & IP addresses:

>	IP ADDRESS		HOSTNAME	ALIAS
>	128.155.001.001		XYZSYSTEM	XYZ
>	128.155.001.002		ABCSYSTEM	ABC

>The services file must contain the following:

>	ORASRV		1525/TCP

>NOTE: the TCP assumes you are using TCP/IP protocol.

>Bob Bailey

Also, you must specify the location of the hosts and services
file in the Oracle "config.ora" file on the PC.

What network package are you using on the PC?  I just setup
SQL*Net on a PC running PC-NFS.  It is required to start 'rtm',
then 'sqltcp' otherwise my connection hung.  

I installed sqlplus so I could test the PC -> HOST connection 
before running WINDOWS software.  If you try to run SQL*Plus,
you must also start 'sqlpme'.  You must stop 'sqlpme' before
firing up WINDOWS (I think the command is 'rempme').

Good luck.
---
  /_ _   /		sequent computer system, inc.	+-----+
 / / /  /__/ __		15450 sw koll parkway		|   # |
/ / /  / \__(_/_/_/	beaverton, or  97006-6063	|     |
mary kay petersen/	mkay@sequent.com 		+-----+
(503)578-5817 __/
From: carl.pedersen@dartmouth.edu (L. Carl Pedersen)
Newsgroups: comp.databases.oracle
Subject: Re: Question about OPS$LOGIN and Oracle Passwords
Date: 15 Dec 92 00:46:29 GMT
Article-I.D.: kip-sn-1.carl.pedersen-141292193658
Followup-To: comp.databases.oracle
Organization: Dartmouth College

In article <1992Dec14.200952.22697@netcom.com>, sjs@netcom.com (Stephen
Schow) wrote:
> 
> We routinely use the OPS$LOGIN feature of Oracle for all of our users.  This
> way they don't have to worry about anything once they are logged onto the
> UNIX machine.  They just type program / to run it with their UNIX login info.
> 
> Question:  
> 
> When we create a new user as follows:
> 
> 	grant connect to ops$user identified by bogus;
> 
> and we actually use the word 'bogus' as the oracle password.
> 
> Does this mean that user ops$user could login to Oracle with either
> the /, which would use his UNIX login info, or with 'bogus' as the
> password?

Yes.  They could login using ops$user/bogus
> 
> Could a user go into sql*plus with any convienient name and type
> 
> 	connect ops$user/bogus
> 
> to get into that user's oracle accoun

Yes.  At least this is true on VMS.

Why did you have to ask this on the net?  Couldn't you just try it and see?
 I hesitated to respond so publically, but decided you had left yourself
fairly open to attack already.

> We routinely use bogus to define new oracle users, but I am concerned about
> security loop holes.  We also use a number of macintosh client products that
> use the ops$user with the UNIX password to login.  I am beginning to think
> that we should make sure that the Oracle password is the same as the UNIX
> password and NOT use bogus for everyone?!@#$%^

Yes.  Using the Unix password is a reasonable idea - especially if you have
a lot of Mac clients.

For people who *never* need to use the ORACLE password, we use:

   grant connect to ops$user identified by values 'bogus';

This set the *encoded* password to "bogus".  This is quite secure, because
even if someone finds out the encoding, they are not likely to figure out
what produces that encoding.  We do this using the user's SSN, so a DBA can
match to our employee tables.
Newsgroups: comp.databases.oracle
From: orion@polaris.unm.edu (Tim Guerrette)
Subject: Oracle 7 Book Wanted...
Date: Thu, 17 Dec 92 23:28:03 GMT
Organization: University of New Mexico, Albuquerque

Does anyone know if an Oracle 7 book has been published yet? 

Please respond directly..

Thanks,

-- Tim

===============================================================================
Timothy Guerrette	    		Internet: orion@polaris.unm.edu
University of New Mexico
Albuquerque, NM
    "Yesterday is history, tomorrow is vision, today is just a bitch!"
===============================================================================
Newsgroups: comp.databases.oracle
From: podgorny@npac.syr.edu (Marek Podgorny)
Subject: Using and RDBMS for scientific apps?
Keywords: RDBMS scientific apps
Organization: Northeast Parallel Architectures Center at Syracuse University (NPAC)
Distribution: usa
Date: Wed, 16 Dec 92 12:05:05 EST


We are considering use of the Oracle RDBMS as database engine
for scientific applications (Earth science, physics). I would
appreciate any pointers to similar work, completed or in progress.
Oracle not essential, relational technology yes.
 
Marek Podgorny, NPAC, Syracuse University
From: p228@uni05.larc.nasa.gov (Bailey Bob)
Newsgroups: comp.databases.oracle
Subject: Re: How to emulate Yes/No Cancel Dialog?
Date: 15 Dec 1992 17:03:19 GMT
Organization: Unisys-Hampton VA
NNTP-Posting-Host: uni05.larc.nasa.gov

In article <1992Dec10.205650.19707@netcom.com> sjs@netcom.com (Stephen Schow) writes:
>Anyone have any solutions for emulating a Dialog Box that prompts for 
>yes/No/Cancel?
>
>I did one solution that even used the arrow keys, but when I ran the form on
>the mac runforms, it did not look acceptable, so I have to figure a better way.
>

Have you seen the white paper from Oracle titled:

	"Developing Bit-mapped Applications with SQL*Forms and SQL*Menu"

This paper describes a method of simulating check boxes that can be selected
with the mouse.  I have tried it and it seems to work satisfactorily.  Granted,
the appearance is not exactly according to Mac standards, but, it does make
for a user friendly point & click selection.

The paper also discusses several other points of interest to developers that
will be implementing on Macs or in the X windows environment.

Bob Bailey


Newsgroups: comp.databases.oracle
From: jfedorko@ncsa.uiuc.edu (Joel Fedorko)
Subject: Re: SQL*Loader REALLY unique sequences
Originator: jfedorko@mars.ncsa.uiuc.edu
Organization: Day Data @ Dow 
Date: Fri, 11 Dec 1992 20:19:22 GMT

To get a unique sequence on each load you can also use

 colname SEQUENCE (startnum,increment)    ! where startnum is spec'd by you
 colname SEQUENCE (MAX,increment) ! where (if I remember right) MAX is the
                                  ! largest value for the col currently in
                                  ! the table and loader will start #'ing 
                                  ! w/MAX+increment

-- 
Joel Fedorko                         Remember Bit Hopper, 
Consultant                     You must become one with the machine.
Day Data 
jfedorko@ncsa.uiuc.edu        Any opinions I express will be ignored.