RE: Oracle 10i new releases

2002-11-09 Thread Michael Kline
information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Michael Kline INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: Install Oracle 8i on Windows XP?

2002-07-28 Thread Michael Kline
database server and tries to add something to it, that's when you really start having problems. Keep it plain and it will do much better. I just found 99% cpu for 3 months very impressive. Maks. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Michael Kline INET: [EMAIL

RE: Dba tools on NT

2002-08-14 Thread Michael Kline
subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Michael Kline INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

RE: * Certified Oracle DBAs Needed in the Dallas area..

2002-05-31 Thread Michael Kline
list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Michael Kline INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051

RE: but will it run windows?

2001-08-17 Thread Michael Kline
: http://www.orafaq.com -- Author: Ray Stell INET: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Michael Kline INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public

RE: Duhvelopers and DB-ehs?

2001-09-04 Thread Michael Kline
to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Michael Kline INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California

RE: Remote or Not? Was: Production Oracle DBA Needed in Rochester

2002-03-26 Thread Michael Kline
normally only see a database emergency about once a year. Everything else is planned in advance. Michael Kline ThinkSpark Richmond, VA 804-744-1545 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Paul Vallee Sent: Tuesday, March 26, 2002 1:09 PM

Sql Server to Oracle

2002-04-02 Thread Michael Kline
into a visual basic program, but if this get a copy of the whole table could be stopped, then this opportunity would be over. It's been too long since I've looked at Sql Server 7, and I can't think of anything off hand. Maybe one of you have been there, done that... Thanks. Michael Kline ThinkSpark

RE: Microsoft plans to bundle iFS copycat into it operating syste

2002-01-29 Thread Michael Kline
to bundle iFS copycat into it operating syste I think they wrote edlin, but that was years ago. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Michael Kline INET: [EMAIL PROTECTED] Fat City

RE: Re[2]: Linux taking over at Oracle

2002-02-01 Thread Michael Kline
://www.orafaq.com -- Author: Michael Kline INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from

RE: Rollback Segments

2002-02-19 Thread Michael Kline
, before Sql*Net. Yea, them were the days... Michael Kline ThinkSpark Richmond, VA 804-744-1545 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of bill thater Sent: Tuesday, February 19, 2002 2:54 PM To: Multiple recipients of list ORACLE-L Subject: Re

VMS, large database

2002-03-08 Thread Michael Kline
://www.orafaq.com -- Author: Michael Kline INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from

VMS, large database

2002-03-13 Thread Michael Kline
://www.orafaq.com -- Author: Michael Kline INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from

RE: Griping about auditing (not the Oracle Kind)

2001-06-26 Thread Michael Kline
failure to comply and lack of the teamwork spirit on this insanity was duly noted. It was like Dilbert's worst nightmare.) (...) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Michael Kline INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX

Warmstart objects

2001-07-03 Thread Michael Kline
This seems new to me. Is there a work around? sqlr 1* alter index sys.I_obj2 storage(next 1m) *ERROR at line 1:ORA-00701: object necessary for warmstarting database cannot be altered Michael Kline ThinkSpark Richmond, VA 804-744-1545 -- Please see the official ORACLE-L FAQ: http

RE: OT -- suggestions to ensure nerdiness in potential IT staff

2001-08-02 Thread Michael Kline
FAQ: http://www.orafaq.com -- Author: Michael Kline INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE

RE: Rachel - RE: 2nd DBA or ?

2001-09-21 Thread Michael Kline
Bozeman, Montana, USA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Michael Kline INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

RE: Another Oracle DBA gets The Bullet in the UK - Seeking an O

2001-11-08 Thread Michael Kline
and I'm sure it would help interpersonal communications some. Cherie Machler Oracle DBA Gelco Information Network -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Michael Kline INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858

RE: 9i / 9iRAC : Segment_Space_Management AUTO, with LOB

2002-12-19 Thread Michael Kline
Title: RE: 9i / 9iRAC : Segment_Space_Management AUTO, with LOB Oh the good old days when at the state government they decided to call us Bureau of Application Development And System Software Yep, until the initials became apparent.. I think it lasted about 2-4 weeks, and they changed it.

Distributed Option

2002-12-27 Thread Michael Kline
-- Author: Michael Kline INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send

RE: Distributed Option

2002-12-27 Thread Michael Kline
., Owner 13308 Thornridge Court; Midlothian, VA 23112, USA. Work: 804-744-1545 Cell: 804-314-6262 Pager: 877-705-1155 ICQ: 1009605, 975313 [EMAIL PROTECTED]; [EMAIL PROTECTED]; -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Michael Kline INET: [EMAIL PROTECTED

RE: Distributed Option

2002-12-28 Thread Michael Kline
-- Author: Michael Kline INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing

RE: Distributed Option

2002-12-29 Thread Michael Kline
ORACLE-L FAQ: http://www.orafaq.net -- Author: Michael Kline INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

FW: Error During Oracle Export Bkup

2003-01-16 Thread Michael Kline
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Michael Kline INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

Slow database, too MANY buffers???

2003-01-23 Thread Michael Kline
I've got a cust that is showing some signs that one would think is having a horrible problem onI/O... I suspect it is the "error" of having a **HUGE** value in db_block_buffers and it's constantly crunching memory trying to figure out which ones to free up. It's only 256 meg, but

Listening on specific ports

2003-02-03 Thread Michael Kline
Is there an "Easy" way to assign specific tnslistener ports to a specific database? Let's say I wanted: 1521 to be prod1 1522 to be devl1 1523 to be web1 1524 to be test1 Right now ports are basically assigned to servers which may well be adequate. But I was asked, and it seems

RE: RMAN or SQLBacktrack?

2003-02-13 Thread Michael Kline
PM To: Multiple recipients of list ORACLE-L Hi Robert, Can you suggest a good RMAN book to start out. We're also in the process of looking at RMAN to replace in-house scripts. TIA Tom P. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Michael Kline INET

Fixed Assets maybe?

2003-03-18 Thread Michael Kline
My Financials person is out, what might the following imply? "I am currently working on a new tax book to the current Oracle fixed assets and I would like to copy the data from production to the test environment. I would like to add some major changes to these assets in the test region

Script to check for errors

2003-03-21 Thread Michael Kline
Anyone have a "simple" script to scan an alert log for errors and email a report if found? Customer wants something to run "often", but only email when an error is found. I've got something that does a bit of that and runs twice a day, but always sends out. Thanks. Maks.

Sun to Linux on Dell

2003-06-09 Thread Michael Kline
I have a cust pounding a Sun E450 I believe they said it was with a large RAID with fiber channels. They pound this thing at 2,037 I/O per seconds and end up having about 3,868 I/O per data block wait. This is averaged over 3-5 days, 24 hr/day, so there are times it's way over that.

Oracle 9i and streaming technology

2003-06-19 Thread Michael Kline
Have a client that is using Linux and Oracle 9i. They are attempting to do live inventory on 5 branches using streaming technology, but when it kicks it, it literally shuts the network down... If you are not in before it starts you can't get on. It appears to do this to all 5 branches.

FW: Oracle 9i and streaming technology

2003-06-20 Thread Michael Kline
Got a bit more on what they were doing. One really gets "scared" when Oracle wants to know what you're doing. Maks. -Original Message-From: GregSubject: RE: Oracle 9i and streaming technology Actually streams is a hybrid of several Oracle technologies: Log miner (used to hot

RE: salary question

2003-06-27 Thread Michael Kline
want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Michael Kline INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San

RE: Do Not Call

2003-07-01 Thread Michael Kline
Punched cards and a sorter. Then COBOL with indexed files once loaded sequentially. Michael KlineBusiness to Business SolutionsRichmond, VA804-744-1545 -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of TOMPKINS, MARGARETSent: Tuesday, July

Veritas and Oracle 9i with failsafe

2003-07-17 Thread Michael Kline
Got a cust who went Oracle 9i with failsafe... Now Veritas is broke and they evidently know it. Anyone else bit by this, and what was the solution if any? I guess the 9i is supposed to work, but when you add failsafe it's broke.. Hearing this 2nd hand you know.. Michael Alan Kline,

Distributed Oracle

2003-07-17 Thread Michael Kline
I have a customer whose long term goal is to have what would probably be close to RAS, but with the servers on a FAST backbone and about 500-800 feet apart... Is there a way to put that together with hardware software? In some ways they may even want to force a splitting of the load

RMAN used?

2003-07-22 Thread Michael Kline
Can RMAN backup a database and leave any traces? I have a client site that was maintained with no documentation and now evaluating for how bad things may be. We found an export taking place, but no evidence of anything else. The alert.log shows NOTHING as far as shutdown, start up,

Veritas like RMAN?

2003-07-23 Thread Michael Kline
I found no signs of RMAN being used in any way shape or form... I've been told they are doing "hot" backups using Veritas... HOWEVER, the alert log shows no signs what so ever of "alter tablespace xyz begin/end backup"... Can it do a good backup backing up live DB files and leaving

RE: Veritas like RMAN?

2003-07-23 Thread Michael Kline
then, recovery is still not supported. --- Michael Kline [EMAIL PROTECTED] wrote: I found no signs of RMAN being used in any way shape or form... I've been told they are doing hot backups using Veritas... HOWEVER, the alert log shows no signs what so ever of alter tablespace xyz begin/end

RE: Veritas like RMAN?

2003-07-23 Thread Michael Kline
seems a bit like belt and suspenders to me (how can you get a split block if the database is quiesced?) but that's what we do. I'd guess Veritas mirroring would require at least one of the two steps, both of which should show up in the alert log. From: Michael Kline [mailto:[EMAIL PROTECTED] Sent

RE: dba age

2003-07-23 Thread Michael Kline
Let's see... I remember dirt.. I remember UFI. I remember version 4.1.0 that ran on DOS... PC, PC-XT.. Oracle since 1983... Good loaded question. Maks. -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Goulet, DickSent: Wednesday, July 23,

RE: Veritas like RMAN?

2003-07-23 Thread Michael Kline
if there is absolutely NO activity whatsoever in the database from the time the backup starts until when it finishes. Even then, recovery is still not supported. --- Michael Kline [EMAIL PROTECTED] wrote: I found no signs of RMAN being used in any way shape or form... I've been told they are doing hot

RE: dba age

2003-07-23 Thread Michael Kline
: Michael Kline INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E

Is it Veritas or is it smoke and mirrors? again

2003-07-30 Thread Michael Kline
There seems to be some big confusion if Veritas is working or not... Based on Previous discussions this customer has the Oracle Veritas agent running, and they do nightly backups. How ever, I find absolutely NONE of the RMAN tables updated so they are not using RMAN. I also find that

RE: Is it Veritas or is it smoke and mirrors? again

2003-07-30 Thread Michael Kline
. -Original Message- Daniel Fink Sent: Wednesday, July 30, 2003 11:44 AM To: Multiple recipients of list ORACLE-L Michael Kline wrote: There seems to be some big confusion if Veritas is working or not... snip... Recovery has NEVER been tested. Michael Alan Kline, Sr. Principal

That Veritas thing

2003-07-30 Thread Michael Kline
The database backup is only export. Once in a while they are supposed to be doing a cold backup. Finally found someone that said they can't use the Oracle Veritas agent with Oracle 9.0.2 and Failsafe and/or clustering. They have given them a case number and are working on it. When he

Downsized a bit

2003-08-25 Thread Michael Kline
It's happening to a lot of us, but I had one happen to me. One of my larger clients decided to go no DBA to save money. On the average they were 10-12 hours a week. I could use something or a couple of small something to replace them one of these days soon. I work for a small company,

Building dynamic sql that will do CSV

2003-08-28 Thread Michael Kline
I'm trying to build something like this: select 'select '''||TABLE_NAME||','||COLUMN_NAME||''', ''',''', min('||COLUMN_NAME||'),max('||COLUMN_NAME||') from ' ||OWNER||'.'||TABLE_NAME||' where '||COLUMN_NAME||' is not null;' FROM dba_tab_columns WHERE table_name in

Transportable Tablespaces

2003-10-10 Thread Michael Kline
Anyone got a "1, 2, 3" for using transportable tablespaces? Got a client that thinks this might be a good solution to transfer large amounts of data. This is HP/UX and should be 8.1.7.4... Any gotchas that may kill this idea? Thanks. Michael Kline, Principal Consulta

Linking DataGuard to Management Server

2003-10-16 Thread Michael Kline
I'm at a new site right now and they have set up Standby environment on 9i Rel 2. The agent also is running on both the servers. They want to use the GUI frontend of DataGuard and have OEM installed, but have not taken the final steps of setting up the Management Server to tie it all

RMAN Incremental

2003-10-24 Thread Michael Kline
? What solutions have some doing this found to be "best practice"? Thanks. Michael Kline, Principal ConsultantBusiness To Business Solutions, LLCRichmond, VA804-744-1545

Partitions, loading and moving at the same time?

2004-01-15 Thread Michael Kline
0310, x_200311, etc. Thanks. Michael Kline, Principal ConsultantBusiness To Business Solutions, LLCRichmond, VA804-744-1545