| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| 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
--Boundary-4957204-0-0
unsubscribe ORACLE-L Chris Brown
--Boundary-4957204-0-0
Content-Type: message/rfc822
Date: 04 Feb 96 00:00:55
From:"Automatic digest processor " <LISTSERV_at_ccvm.sunysb.edu>
To: Recipients,of,ORACLE-L,digests,ORACLE-L_at_ccvm.sunysb.edu
Subject: ORACLE-L Digest - 2 Feb 1996 to 3 Feb 1996
Reply-to: ORACLE-L_at_ccvm.sunysb.edu
X-Orcl-Application: Return-Path: <owner-ORACLE-L_at_ccvm.sunysb.edu>
X-Orcl-Application: Sender: "ORACLE database mailing list."
<ORACLE-L_at_ccvm.sunysb.edu>
There are 7 messages totalling 256 lines in this issue.
Topics of the day:
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
>1995
Very Thanks for this information.
Pisano Fiore
e-mail address <pisano_at_solaria.bsav.bull.it>
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.
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
to:cfirster_at_vdh.state.va.us
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: ORACLE-L_at_ccvm.sunysb.edu
> 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.
Jim,
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
> JFM_at_pa.microserve.com
>
>
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
Mark,
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?
---<Snip>---
>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: w.d.saxton_at_cdc.com Oracle Products Consultant | phone: 612-482-3555 Worldwide Support Services | fax: 612-482-3988 Control Data Systems, Inc. | http://www.cdc.com/support __________________________________________________________________ ------------------------------
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.
HTH,
Leng.
>
> 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
Email: lkaing_at_ventnds1.telecom.com.au
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
 |
 |