HDTenEightyP/NetNews huggingface dataset:
From: nye@voglnp.oname (JP Nye)
Newsgroups: comp.databases.oracle
Subject: Re: Job:  UNIX/Networking/SQL in Atlanta
Date: 7 Oct 92 17:51:39 GMT
Article-I.D.: oracle.1992Oct7.175139.16731
Reply-To: nye@voglnp.oname
Organization: Battelle Pacific N.W. Lab's


In article 718381143@gsusgi1.gsu.edu, cuikrnx@gsusgi2.gsu.edu (Keith Nelms) writes:
>
>
>MEMORANDUM
>
>TO:       Interested Parties
>
>FROM:     Winfred Owens
>
>DATE:     October 5, 1992
>
>SUBJECT:  Position Opening
>

[...remainder deleted.]


Please post offers like this to misc.jobs.offered, NOT to this
newsgroup.  You may want to look over the "Guidelines for posting to
USENET" and "USETNET Netiquette" FAQs that appear periodically in
news.answers.


--
Jeff Nye           Battelle, Pacific Northwest Laboratory
PO Box 999  MSIN: K3-67             voice: (509) 375-2514
Richland, WA 99352                  email: jp_nye@pnl.gov
 
Newsgroups: comp.databases.oracle
From: oliver@delphi (George Oliver)
Subject: Re: MAC Oracle Puzzle
Organization: San Diego State University, College of Sciences
X-Newsreader: TIN [version 1.1 PL6]
Date: Thu, 15 Oct 1992 15:02:57 GMT

simard@vax.sonoma.edu wrote:
: We have about 100 MAC's running Oracle for MacIntosh both versions 
: 1.2 and 2.0, all in a client/server relationship with Oracle under 
: VMS.  On some MAC's whenever Oracle Shell (V1.2) or SQL*Plus (v2.0) 
: is run all MicroSoft Word documents assume the icon and data type of 
: a SQL document and can no longer be launched by double clicking 
: them.  If Word is launched first all the Doc's can be opened and they 
: appear as unaltered Word Docs.  The machines which do this have been 
: checked for virus etc and none have been found.
: 
: Has anyone else had this problem?  Any fixes?  Why should Oracle only 
: affect MS Word and not Excell etc, and why on only some machines?
: 
: Puzzled
: Ernie
: Simard@Sonoma.Edu

We had the same problem here when we spooled output to a file.  This was in
V1.2.  We called Oracle about it and they didn't have a fix for it.  Sorry.
What happens, is that the bundle bit on all MS Word documents.  Strange.  I
don't no if this is still a feature of V2.0

Good luck,

George Oliver
NRaD, Code 423
email oliver@nosc.mil
From: hatzinger_m@bmwf1f.bmwf.gv.at
Newsgroups: comp.databases.oracle
Subject: SQL*Reportwriter BUG
Date: 9 Oct 92 15:32:16 GMT
Organization: (Klaus-Michael Hatzinger), BMWF, Vienna

Since we upgraded ORACLE to 6.0.34.2.0 and SQL*Reportwriter to 1.1.13.1 we have
a problem with Reportwriter-Fields:

If I create a field with a SQL Statement as source for this field, 
SQL*Reportwriter allways truncates the last character of the result

e.g

&SQL SELECT 'Text' INTO :TEXT_FIELD FROM dual

     Text Field
     ---------------------
     Tex


I can solve this problem, if I enlarge the text with a blank.


&SQL SELECT 'Text ' INTO :TEXT_FIELD FROM dual

     Text Field
     ---------------------
     Text


Oracle told me, it's a official *bug* in version 1.1.13 and fixed in 1.1.14

I also think that setting the parameter READONLY=NO has no effect. It's always
YES.

KMH

================================================================================
                                                                          ^
 Federal Ministry of Science and Research                               B | M
<-------------------------------------------------------------------------+---->
 Computer Center                                                        W | F
                                                                          |
 Klaus-Michael Hatzinger            mail: hatzinger_m@bmwf1f.bmwf.gv.at   |
 Bankgasse 1/209                   phone: 0043-222-53120/5188             |
 1014 Vienna, Austria                fax: 0043-222-53120/5155             V
================================================================================
From: nick@us.oracle.com (Nick J. Pattakos)
Newsgroups: comp.databases.oracle
Subject: Re: Oracle file managerCLOSE
Date: 9 Oct 92 04:20:34 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.

ballt@osshe.edu (Terry Ball) writes:

>We currently have one database on a raw device.  In order to make a backup
>of this database, we have a background process start up each evening to
>make an export of the database.  It is NOT possible to make a backup of
>the files from the raw device.

>Terry Ball
  Terry-
      It is very possible to do a backup of raw partions in unix.  In
      order to perform a hot backup of oracle tablespaces that are
      in raw partions try the following.

      0.  Make sure your database is in Archive Log Mode
      1.  Place the tablespace in backup mode
	  
	  alter tablespace XXX begin backup;

      2.  you the unix 'dd' command to backup the raw patition to 
	  disk.

	  dd if=rawdevice of=tapefile

      3.  take the tablespace out of backup mode.

	  alter database XXX end backup

      Please Check you the Unix man pages on dd and the oracle
      DBA Guide.  If you have large amounts of data you will find
      this much faster than export.  Remember not to forget to back-
      up your controlfile.  If you are not in archive mode and want 
      a full backup, just shutdown normal the database and dd your
      database files, log files and controlfiles.


      Hope this helps.

      Nick Pattakos
Newsgroups: comp.databases.oracle
From: wkaufman@us.oracle.com (William Kaufman)
Subject: Re: Need Info .. Re.. Ver 7.0 's Multiprotocol Networking Software
Organization: Oracle Corporation, Redwood Shores CA
Date: Thu, 15 Oct 1992 15:40:29 GMT
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.

In article <1992Oct13.192408.12652@tamsun.tamu.edu> nakkala@cs.tamu.edu (Venkatesh Nakkala) writes:
]    
[...talking about Multi-Protocol networking...]
]     
]    Now, suppose we have ORACLE on the DG that uses some protocol(the one used by
]     DG's to communicate with one another..I think it's called CEO Connect
]     -- for sure it does not support   TCP/IP)
]     and ORACLE on the SUN which would normally use TCP/IP.

    Point of clarification: CEO Connect isn't a networking protocol, but
a CEO-to-CEO connection that runs *on top* of a network.  Oracle
supports several protocols on DG's MV, including Xodiac (X.25), TCP/IP,
and LU 6.2.

]     Is it possible for the application software on these two machines 
]     (either database to database or an application accessing a remote
]     database) to communicate without the
]     DG's having to go in for an ETHERNET card i.e. without TCP/IP.

    Well, you need *some* kind of networking hardware and software.  As
for connecting without TCP/IP, you already have some non-TCP/IP choices.
If you currently have LU 6.2, for example, you can *currently* connect
to a Sun running LU 6.2, using Oracle 6.0, etc.  But you still need some
connection path between the two machines, and that means having the DG
card and software for that.

    What the Multiprotocol buys you is this: If you have an MV connected
to an IBM via LU 6.2, and the IBM connected to a Sun via TCP/IP, SQL*Net
will support a connection between, say, SQL*Form 4.0 running on the Sun
on Motif connecting to an Oracle database on the MV.

                                           -- Bill K.

Bill Kaufman               | "ENJOY LIFE!
wkaufman@us.oracle.com     |           -- Eat out more often."
                           |                           -- S. E. Rykoff
Newsgroups: comp.databases.oracle
From: ncronin@unix1.tcd.ie (noel cronin)
Subject: forsm conversion from 2.0 2.1 to 3.0
Summary: where does the trigger text go
Keywords: forms conversion
Organization: Trinity College, Dublin
Date: Tue, 13 Oct 1992 09:35:21 GMT

	We recently converted some forms from 2.0, 2.1
	to 3.0. They work etc. but when we try to call
	up the trigger text it's not there. Any ideas.
	Noel Cronin.

	ncronin@unix1.tcd.ie
Newsgroups: comp.databases.oracle
From: uucm000@uxa.ecn.bgu.edu (Tingli Pan)
Subject: Manuals for Oracle
Organization: Educational Computing Network
Date: Wed, 14 Oct 1992 21:04:26 GMT

I'm looking for a Oracle manual for Oracle runing on a Sun unix
platform. It is mainly from user's point of view. The reason is that the
manuals from Oracle might be a heavy burden to us finacially.
Thanks.

Tingli Pan                           
Academic Computing Services          Internet: uucm000@uxa.ecn.bgu.edu
Northeastern Illinois University     Bitnet:   uucm000@ecnuxa.bitnet
From: jgb@prism.gatech.EDU (James G. Baker)
Newsgroups: comp.databases.oracle
Subject: Re: MS-Windows based tools
Date: 8 Oct 92 04:20:37 GMT
Distribution: na
Organization: Georgia Institute of Technology

In article <1992Oct7.055014.18461@usl.edu> cdc6586@usl.edu (Charbonnet Clement D) writes:
>I am currently running Oracle on a Data General AViiON 6220 
>with DOS based clients communicating with SQL*Net TCP/IP.
>I am not pleased with the fact that Oracle's tools are not 
>compatible with the enhanced mode of MS-Windows which is our 
>standard user interface.

It depends how robust your needs are.  $300 at Egghead will get you
ObjectVision Pro, which has SQL (SQL Server/Sybase, Oracle, etc)
access included.  It is good for the price, but there are stronger
products out there...  PowerBuilder is probably the leading one, IMHO,
but it is a bit more in cost.  I am using MicroSoft Excel via Oracle's
DDE Manager to access a server - it certainly has the reporting 
capabilities, along with dialog boxes, custom menus, etc of Excel 4.0...
It might be a good place to start... The DDE Manager (~$300) would let other
programs, MS-Word, VisualBASIC, and even some C++ if you want... :-) 

There was a review in the September 29 PC Magazine for SQL Front Ends...

Let me know if you need more info...  Good luck.

-- 
James G. Baker                   | Phone: (404) 853-9984 
School of Electrical Engineering | GIT: jgb@prism, jgb@ee, jgb@cc, jgb@eecom
Georgia Institute of Technology  | uucp: ...!{hplabs,purdue}!gatech!prism!jgb 
Atlanta, Georgia 30332-0250      | Internet: jgb@prism.gatech.edu
Newsgroups: comp.databases.oracle,comp.databases.sybase,comp.databases.ingress,comp.databases.informix
From: andy@homebase.vistachrome.com (Andy Finkenstadt)
Subject: Re: Did you use E-R modelling for your database design ?
Reply-To: andy@homebase.vistachrome.com
Organization: Vista-Chrome Incorporated
Date: Wed, 14 Oct 1992 15:37:32 GMT

kortikar@mipos2.intel.com (Aniruddha Kortikar) writes:
>Specifically I would be interested in
>1. Did you use E-R modelling for database design project

Yes, many projects.

>2. How big was the result (Approx no of tables  20,50,150 etc)

Some as small as 10, most end up being around 50, and three are at
200+ tables, not including validation lookup tables.  Total rows for
the 250 table model is around 14 million not including a 28 million
"lookup" table. :>

>3. Did you use any software for designing the database. (to generate schema)

Depending on the task we used one of:
   Mac Flow 3.7.3 -- used to partition and have pretty pictures on paper
                     it has no E-R smarts within it.
   TurboCase 2.1 and 3.0 -- another mac product supports 
   a number of modeling conventions and data dictionary support.  No
   importation to Oracle directly though.

   Oracle CASE Dictionary 5.0 -- easy to use once you get used to it.
   Highly capable and generates all DDL as well as
   imports directly into Generators for forms and reports.

>4. Are you aware of any company that has a business of database design ?
>   (NOT programming etc but exclusively information modelling and giving
>    you generated schema and all the documentation.)

>    I do not want to know the products, or product development company
>    but the consulting company which uses some of these products and give
>    you the design.
>5. did you really benefit from such design efforts ?

>regards,

>Aniruddha Kortikar (kortikar@mipos2.intel.com)

>-------------------------------------------------------------------------------
>E-mail 	: kortikar@mipos2.intel.com | for every action there is an 
>Phone(W): 408 765 5515              | equal and opposite government program.
>-------------------------------------------------------------------------------
-- 
Andrew Finkenstadt       | Vista-Chrome, Inc.   |     NIC Handle: AF136
GEnie Unix Sysop/Manager | The Printing House   |    ...!uunet!rde!andy 
+1 904 222 2639 home     | 1600 Capital Cir SW  |   andy@GEnie.geis.com
+1 904 575 0189 work     | Tallahassee FL 32310 |  andy@vistachrome.com

     The game of love is never called off on account of darkness.
Newsgroups: comp.databases.oracle
From: plaisted@broke.enet.dec.com (Grahame Plaisted)
Subject: ORACLE/RUNFORM/VMS/Captive account weirdness (DISCTLY ignored?)
Reply-To: plaisted@broke.enet.dec.com (Grahame Plaisted)
Organization: Digital Equipment Corporation
Date: Fri, 9 Oct 92 12:59:16 GMT


I am entering this on behalf of someone who does not currently have USENET
access. Anyone ever hear of this?

o  Details

   DSSI cluster with a MicroVAX 3400 and VAX 4000.
   ORACLE V6.0
   Captive accounts are used (DISCTLY is set)

    At some point the application uses the command #HOST from within
    RUNFORM to get into VMS and perform a command procedure and
    then return back in RUNFORM.
    
    If a user presses CTRL-Y while the application runs the command
    #HOST the application breaks and the user is given access to VMS.
    
    All user accounts are captive, and tests have been executed consisting of
    a VMS command procedure with SPAWN command and it never broke to allow           access into VMS.
    
    The unusual thing is that when the user enters the MicroVAX 3400 the             application does not break to give him access into VMS, it only happens
    on the VAX 4000. The user performs exactly the same steps in either system.
    
    The question is what does the HOST command do? Does it create a 
    subprocess into VMS? Why does it gives the user access into VMS since
    the DISCTLY flag is set in AUTHORIZE?

    All suggestions welcome.

    Thanks,

    Grahame (on behalf of Maria)
From: kpalm@athena.qualcomm.com (Kent Palm)
Newsgroups: comp.databases.oracle
Subject: Re: Recovering ORACLE db after system crash
Keywords: recover, oracle
Date: 8 Oct 92 17:52:44 GMT
Organization: Qualcomm, Inc., San Diego, CA

This is off the top of my head, but I what I think should have been done
is:

First, if you want to be able to recover to the point-in-time when the
system crashed, you needed to be running in archive log mode.  This means
you would be doing online (hot) backups as well. 

Then,

To recover, copy your latest hot backup of the data files that make up the
tablespace that contained the invalid rollback segment.  After that, use
the command

   RECOVER TABLESPACE tablespace

and roll forward your log files.  If the tablespace was the system
tablespace, then you would probably have to use the RECOVER DATABASE
command.

It's in the DBA guide and online document, recovery.doc.
Newsgroups: comp.databases.oracle
From: bill@chaos.cs.umn.edu ( Hari Seldon     psychohistorian )
Subject: Re: Recovering ORACLE db after system crash
Keywords: recover, oracle
Organization: University of Minnesota
Date: Wed, 14 Oct 1992 00:56:35 GMT

In <1992Oct6.225552.27031@cerberus.bhpese.oz.au> brad@cerberus.bhpese.oz.au (Brad Keifer) writes:


>We are currently running ORACLE Version 6.0.31.0.1 on an RS/6000, running
>AIX Version 3.2.  A power failure took out the machine the other day while
                     ^^^^^
>What should I have done?

very simply you should be using a ups. it should have sw to do a shutdown
when the power goes away (for a specifiec period of time) and it should wait
a bit after power coes back prior to restarting the machine.
it's cheep, its simple, it's good insurance.

bill pociengel
--
llbi locgeenpi " i'm a little confused right now"
Newsgroups: comp.databases.oracle
From: bill@chaos.cs.umn.edu ( Hari Seldon ... psychohistorian )
Subject: Re: Recovering ORACLE db after system crash
Keywords: recover, oracle
Organization: University of Minnesota
Date: Thu, 15 Oct 1992 17:37:10 GMT

In <68wNsB1w165w@netlink.cts.com> tumidity@netlink.cts.com (Joel Garry) writes:

>bill@chaos.cs.umn.edu ( Hari Seldon     psychohistorian ) writes:
>> 
>> >We are currently running ORACLE Version 6.0.31.0.1 on an RS/6000, running
>> >AIX Version 3.2.  A power failure took out the machine the other day while
>>                      ^^^^^
>> >What should I have done?
>> 
>> very simply you should be using a ups. it should have sw to do a shutdown
>> when the power goes away (for a specifiec period of time) and it should wait
>> a bit after power coes back prior to restarting the machine.
>> it's cheep, its simple, it's good insurance.

>Yes, ours only cost $20,000 plus a diesel generator, concrete block
>building and new transformers on the pole.  Then it blew up when the
>electricians installed it and turned the lever that says "do not turn".

pity. but that had nothing to do with the rs/6000, oracle, or even (sigh)
aix. for an rs/6000 you should be able to get a ups for <$3k that can
provide for an orderly shutdown of the system. thats what i was pointing
out. not that you could spend mondo bucks trying to keep the system *up*.
that is already a given.

bill pociengel

ps all that for $20k? installed? thats really not a bad price. probably
a bit much for the systems i run at my home office tho;-)
--
llbi locgeenpi " i'm a little confused right now"
From: deepthought!neil@ms.uky.edu (Neil Greene)
Newsgroups: comp.databases.oracle
Subject: Re: Recovering ORACLE db after system crash
Date: 9 Oct 92 13:39:03 GMT
Reply-To: Neil Greene <deepthought!neil@ms.uky.edu>
Organization: ARCI, Inc.

In article <1992Oct8.225459.18039@gbrmpa.gov.au> wayne@gbrmpa.gov.au  
(Wayne Amisano) writes:
> hans@iris.mincom.oz.au (Hans Plambeck) writes:
> 
[stuff deleted]

I was wondering if some knowledgeable oracle dba with experience in  
recovering from several system crashes (instance, power, media, etc.)  
could post a short message outlining the things to consider and steps to  
follow in order to perform successful database recoveries.

I have read the DBA manual, but it can be complicated at times and nowhere  
is there a section that just really says do this, do that.

Thanks in advance.  Then again, proabaly the best way to learn would be  
the day I actually have to recover from some crashes.  :-)

--
Neil Greene
President, Kentucky NeXT User Group, Inc.
deepthought!neil@ms.uky.edu [NeXTMail]
-- 
Neil Greene
President, Kentucky NeXT User Group, Inc.
deepthought!neil@ms.uky.edu [NeXTMail]
Newsgroups: comp.databases.oracle
From: garth@.comm.mot.com (Garth Kennedy)
Subject: How to DROP "PUBLIC ROLLBACK" Segment ?
Organization: Private Trunked Systems Div. Motorola Inc.
Distribution: comp.databases.oracle
Date: Tue, 13 Oct 1992 12:47:13 GMT
Summary: Cannot DROP Rollback Segment created as PUBLIC

Subject:  Trouble Dropping a PUBLIC ROLLBACK SEGMENT

I have a system from which I wish to drop a PUBLIC ROLLBACK SEGMENT.
If I read the DBA manual, I am supposed to shut the database down and 
restart it in an EXCLUSIVE mode.  At this point the STATUS of the ROLLBACK 
SEGMENT is supposed to be available, so it can be DROPPED.

Problem is that it still shows as being IN USE.    
Taking the ROLLBACK SEGMENT out of the init file does not make any difference.

If I create a ROLLBACK SEGMENT  not declaring it as PUBLIC, this all works as
described.

The question is how can I drop a ROLLBACK SEGMENT that was originally declared
as PUBLIC ??

E-Mail responses would be appreciated. I will distribute a summary.

Thanks
 Garth      e-mail garth@comm.mot.com


-- 
+------------------------------------------------------------------+
| Garth Kennedy                      Internet: garth@comm.mot.com  |
| Shared Systems/Component Products                                |
|      Factory Systems                    Internal Mail: IL02-2317 |
From: rsingi@penuts.enet.dec.com (Rajesh Singi)
Subject: Re: How to get VMS logicals or symbols into SQL*forms 3.0
Organization: Digital Equipment Corporation
Date: Thu, 15 Oct 1992 18:35:44 GMT


In article <1992Oct15.144742.12108@Urmel.Informatik.RWTH-Aachen.DE>, marten@ilt.fhg.de (Lutz Marten) writes...
> 
>Hello,
>is there any possibility to read VMS logicals or symbols from a SQL*forms 3.0 trigger ?
Only way is a user-exits.

-rajesh
>ThanX !
>--
># Lutz Marten,  Postmaster and general dogsbody 
># Fraunhofer-Gesellschaft Institut fuer Lasertechnik 
># BITNET: KQ040MA@DACTH11 , InterNet: marten@ilt.fhg.de                        
># HEPNET: 13533::52714::MARTEN, Phone: +49/241/8906-112, -0
> 
+-----------------------------------------------------------------------------+
|  Rajesh Singi                             rsingi@penuts.enet.dec.com        |
|  Digital Equipment Corp., Andover MA      (508)-474-3407                    |
+-----------------------------------------------------------------------------+
Newsgroups: comp.databases.oracle
From: tssmith@netcom.com (Tim Smith)
Subject: I/O in PL/SQL
Organization: Netcom - Online Communication Services  (408 241-9760 guest) 
Date: Tue, 13 Oct 1992 08:39:59 GMT

There were several questions within the past month about doing i/o
from a PL/SQL program.

When ORACLE7 goes to production release, there will be several ways
to do non-database input/output to/from PL/SQL V2.0.

The first is a general package, called dbms_output, that includes
routines like put (overloaded by type for NUMBERs, VARCHAR2s, and
DATES), put_line (like put but adding a newline), new_line, get_line,
get_lines, and more.  These routines put output to a buffer (stored
in the SGA), or retrieve output from the buffer, within a single
session.

The big win here is that SQL*DBA and SQL*Plus will have an option
(SET SERVEROUTPUT ON/OFF) that can, when activated, automatically
collect (get_line) buffered output and print it on the active client
terminal.  So, as you write and debug your stored procedures, you
can see debug output as you execute them from within SQL*DBA (or
SQL*Plus).

The second input/output mechanism involves a more generalized named
pipes package.  A PL/SQL program can put data to a named pipe, and
that output can be read by a PL/SQL program in another session.  This
could be used for debugging.  For example, the PL/SQL program you are
debugging writes debug info to a named pipe.  In another window on
your terminal, you have a session involving an OCI or Pro*? program
that calls PL/SQL routines to read the named pipe, and print the
debug output.

There are many other uses for named pipes.  For example, you can
implement external routines written in C or any other supported host
language that use pipes to receive parameters from stored PL/SQL
procedures in the database, and return information to stored
procedures.  By this means, an external server that does things
like retrieve stock prices, or read temperatures in a mixing vat,
can respond to and return info to a database stored procedure.  The
possibilities are endless.

--Tim (tssmith@oracle.com) or (tssmith@netcom.com)
From: wrb2@ra.msstate.edu (Warren R Bennett)
Newsgroups: comp.databases.oracle
Subject: Need info on Ada tools for Windows Apps accessing remote Oracle DB
Date: 16 Oct 92 03:26:21 GMT
Organization: Mississippi State University


We are developing software for DoD.  Hence, we need to use Ada.

Anybody know of tools available that would help us develop Windows Apps
using Ada? 

We also need to access a remote database using SQL?  Anybody know of help
with this?

Thanks for the help!!

Warren Bennett (u4imcwb1@wescs1.wes.army.mil)