Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> Re: ORACLE-L Digest - 2 Feb 1996 to 3 Feb 1996

Re: ORACLE-L Digest - 2 Feb 1996 to 3 Feb 1996

From: Chris Brown - Oracle Corporation UK Ltd. <CBBROWN_at_UK.ORACLE.COM>
Date: Sun, 4 Feb 1996 11:43:01 GMT
Message-Id: <>


unsubscribe ORACLE-L Chris Brown

Content-Type: message/rfc822

Date: 04 Feb 96 00:00:55
From:"Automatic digest processor " <> To: Recipients,of,ORACLE-L,digests, Subject: ORACLE-L Digest - 2 Feb 1996 to 3 Feb 1996 Reply-to:
X-Orcl-Application: Return-Path: <> X-Orcl-Application: Sender: "ORACLE database mailing list."  <>

There are 7 messages totalling 256 lines in this issue.

Topics of the day:

  1. Disaster Recovery Plan
  2. lost view
  3. Positions Available
  4. Valid Dates in Oracle
  5. Automating hot standby db
  6. sqldba segmentation fault (core dump) w/ Monitor (2)

Date: Tue, 30 Jan 1996 07:54:07 +0000 From: Pisano Fiore <pisano_at_SOLARIA.BSAV.BULL.IT> Subject: Re: Disaster Recovery Plan

At 09.10 29/01/96 -0600, you wrote:
>I have included the text of the document in the email.....
>Good luck and Regards!
>Chris Larson
>Disaster Recovery
>Written by Chris Larson
>Control Data Systems

Very Thanks for this information.
Pisano Fiore
e-mail address <> phone 0-825-764388
Bull Sud HN
(Avellino) Italy

Date: Sat, 3 Feb 1996 05:56:00 CST
From: James Koopmann <JKOOPM1_at_TANDY.COM> Subject: lost view

fellow users,
i have come across an interesting problem that i hope someone else has come across and solved. our database has a view , composed of six tables and uses the outer join facility. this view has been in production
for about 4 months with no problem. yesterday users were no longer able to select or even describe the object when it was there and all had select access on it. i ended up dropping the view, synonym and revoking access ; i then recreated the view , synonym and privileges and all was fine. after the users bang on the view for about 20-30 minutes (with no problems)
the view becomes inaccessible again. this is not an authorization problem, the owner can not even describe or select from the view. please reply if you have had a similar experience. I will also repost the solution if it comes from oracle (or this list) and is solved.

James F. Koopmann,
Data Base Analyst
Tandy Information Services
E-Mail :
Phone : (817)878-0313

Date: Fri, 2 Feb 1996 13:51:26 EST
From: Jack Fairservice <JFAIRSER_at_VDH.BITNET> Subject: Positions Available

Thrive on Challenges? Highly Skilled Computer professional? Exciting job opportunities available in The Office of Information Systems located at Main Street Station in historic downtown Richmond. Become a vital part of a large distributed client/server network providing service to health departments throughout Virginia.

Computer Systems Senior Engineer (3 positions) Position #08346-As the agency security officer, develops and implements all data security policies, monitors for security breaches, authorizes access and serves as audit contact. Considerable working knowledge of database security, methodologies and operating systems in a network environment; general knowledge of multiple operating systems and vulnerabilities required. Ability to access, develop and take corrective action to resolve security problems. Experience in installing and maintaining virus protection programs required. Prefer CISA/CISSP certification and considerable work experience in network security for complex systems.

Position #04843 & #08343-As the Senior technical specialists for the Unix Host System, monitors system performance, design script files for utility functions, and ensures successful operation of asyncronous line communications. Job requires considerable knowledge of Unix systems, LAN configuration and maintenance utilizing Novell or Microsoft Windows NT. Maintenance experience expected on ATT systems platform 3500 or higher. Demonstrated ability to operate communication equipment (DSU/CSU routers with Cisco preferred, communications servers lattis hubs) in a wide area network using Internet protocol. Considerable experience on ATT systems, platform work experience with Unix, script file to include C-shell and Korn shell. May frequently work outside of normal business hours.

Database Analyst (2 positions*)
Position #08344 is responsible for maintaining the agency's physical database; determines space availability, and evaluates modification proposals. The successful candidate will demonstrate working knowledge of physical database maintenance to include performance monitoring, tuning assessment of space availability, core requirements and disk usage. Unix operating system experience, Unix shell programming language required. Experience with Oracle backup and recovery methodology.

Position #08347, as the logical Database Analyst, modifies the logical database to develop a truly integrated data system capable of sharing data across agencies, programs, and states. Demonstrated knowledge of relational design, working knowledge of SQL, forms, reports required. Experience with application and system design.
* Both positions require demonstrated knowledge of Oracle RDBMS version 6.0 or higher , with C programming language preferred.

Application Deadline: 2/16/96, Salary to upper $50K Interested applicants should submit a state application
Virginia Department of Health
1500 East Main Street
P.O. Box 2448

Date: Sat, 3 Feb 1996 11:22:52 +0000 From: Scott Mattes <smattes_at_INTERSERF.NET> Subject: Re: Valid Dates in Oracle

> Date: Fri, 2 Feb 1996 18:02:58 -0800
> Reply-to: "ORACLE database mailing list." <ORACLE-L_at_CCVM.SUNYSB.EDU>
> From: jfm <jfm_at_PA.MICROSERVE.COM>
> Subject: Valid Dates in Oracle
> X-To:
> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_CCVM.SUNYSB.EDU>

> Can I use the dates of 01-01-0001 or 12-31-9999 in an oracle date field?
> (These are common defaults we use in DB2).
> Thanks.

  I tried both and 0001 goes in, 9999 is out of range (-4731 to +4731 I think it said were valid). I tried selecting the 0001 and it displays in default dd-mon-yy format, but when I try to convert it to yyyy I get 'invalid' number.
> Database Analyst
> PA Blue Shield

Scott Mattes
I-Net, Inc.

We are free to choose what we will do, think, say, be, but we are not free to choose the consequences of those choices.

Date: Fri, 2 Feb 1996 10:50:00 PST
From: "Frees, Bill" <BFREES_at_FTCMPD4TH.FTCOLLINSCO.NCR.COM> Subject: Automating hot standby db

Is there a way to FULLY automate a hot standby database? (besides waiting for V7.3).

Surely, this has been successfully implemented by some of you out there.  The problem lies in the fact that when doing a RECOVER AUTOMATIC to automatically apply the archive logs to the standby database, it never stops to say media recovery complete (even though it is). I have to say CANCEL when it looks for the next log that hasn't even been created yet. Talking with Oracle analyst #2, she said that this was the way it worked, and there was no way to fully automate what I was trying to do. Their technical bulletin on standby databases is of no help either.

We're running V7.1.6 on ATT 3000.
Thanks for any suggestions.

Bill Frees
Database Administrator
Symbios Logic

Date: Fri, 2 Feb 1996 12:54:08 -0600 From: Bill Saxton <William.D.Saxton_at_CDC.COM> Subject: Re: sqldba segmentation fault (core dump) w/ Monitor


What is your TERM and DISPLAY environment var set to? I've seen this problem during the use of the monitor function with Server Manager when these were not set correctly.

Does the same thing occur when you use a CMD-Tool or Shell-Tool window? Does it dump as soon as you select 'monitor' or after the first poll? Does it occur if TERM is set to xterm, DISPLAY is set to <host>:0.0 and ORACLE_TERM is set to (sun, sun5, or xterm)? Are you trying to display onto a Sun box or an intel box? Is there an emulator involved?

>I Was wondering if anyone else has had experience with immediate
>core dumps when trying to use sqldba with one of the "Monitor"
>options such as "Session", "File I/O", "Rollback".
>Trying to run one of these monitor options in sqldba (full screen)
>always results in a segmenation fault (core dump).
>It's running on a Sparc 1000,
>and I'm using an Xterm window with the ORACLE_TERM set to "xsun5".
>Seems to work ok for everything except the monitor menu options.
>-Mark AuBuchon

---<End Snip>---

  William D. Saxton             | email:
  Oracle Products Consultant    | phone: 612-482-3555
  Worldwide Support Services    | fax:   612-482-3988
  Control Data Systems, Inc.    |



Date: Sun, 4 Feb 1996 15:05:43 +1100 From: Leng Kaing <leng_at_COUGAR.VUT.EDU.AU> Subject: Re: sqldba segmentation fault (core dump) w/ Monitor

This is a known bug. Call Oracle Support and ask them for the patch and everything should be ok.

> Hi everyone,
> I Was wondering if anyone else has had experience with immediate
> core dumps when trying to use sqldba with one of the "Monitor"
> options such as "Session", "File I/O", "Rollback".
> Trying to run one of these monitor options in sqldba (full screen)
> always results in a segmenation fault (core dump).
> It's running on a Sparc 1000,
> and I'm using an Xterm window with the ORACLE_TERM set to "xsun5".
> Seems to work ok for everything except the monitor menu options.
> Anyone have any experience with this?
> Oh yeah, the Oracle release is 7.1.3
> Thanks!
> -Mark AuBuchon

Leng Kaing
DBA - Directory Technology P/L
Ph: +61-3-9892-9081 Fax: +61-3-9892-9344

End of ORACLE-L Digest - 2 Feb 1996 to 3 Feb 1996

--Boundary-4957204-0-0-- Received on Sun Feb 04 1996 - 07:11:17 CST

Original text of this message