| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> 8.1.5 to 8.1.6
This is a multi-part message in MIME format.
------=_NextPart_000_002A_01BFCB08.963F2200 Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
Hello all,
Can anyone please list the steps reqd to upgrade from release 8.1.5 to 8.1.6 ?
Thanks to all in advance,
Geeta Iyer
Sprint Enterprise Network Services
Work: (303)220-4788
Pager: 800-724-3508
E-Mail: Geeta.Iyer_at_SprintParanet.com
------=_NextPart_000_002A_01BFCB08.963F2200 Content-Type: application/ms-tnef;
name="winmail.dat"
Content-Transfer-Encoding: base64
Content-Disposition: attachment;
filename="winmail.dat"
eJ8+IiAUAQaQCAAEAAAAAAABAAEAAQeQBgAIAAAA5AQAAAAAAADoAAEIgAcAGAAAAElQTS5NaWNy b3NvZnQgTWFpbC5Ob3RlADEIAQ2ABAACAAAAAgACAAEGgAMADgAAANAHBQAfAA4AAAAAAAMADAEB A5AGANgFAAAlAAAACwACAAEAAAALACMAAAAAAAMAJgAAAAAACwApAAAAAAADADYAAAAAAB4AcAAB AAAADwAAADguMS41IHRvIDguMS42AAACAXEAAQAAABYAAAABv8s64HBzsxqGh4tIJqfWxors0J5E AAACAR0MAQAAACIAAABTTVRQOkdFRVRBLklZRVJAU1BSSU5UUEFSQU5FVC5DT00AAAALAAEOAAAA AEAABg4AoCXNOsu/AQIBCg4BAAAAGAAAAAAAAABOLJVgDvfxTrl36L7BYlNvwoAAAAsAHw4BAAAA AgEJEAEAAABmAQAAYgEAAOoBAABMWkZ1uVUv1gMACgByY3BnMTI1FjIA+Atgbg4QMDMzTwH3AqQD 4wIAY2gKwHPwZXQwIAcTAoMAUANUVxDJB20CgH0KgXYIkHfSawuAZDQMYGMAUAsDRwu2CrEKgEhl bAkAINkHQGwsFjQWNEMDkQBwknkCIGUgC1BlYREgzCBsBAAFQHRoGIAZMMxlcAQgCXBxZBlQFtDS dQ4AcmEBACADUhnxwRi0OC4xLjUaQhvSWDYgPxc6FjRUEPBubmsEIBpRFvEgC4AW4GTydgBwY2UX KRWhEhEL8BgyIEcJ4AGQIEl5MwSQFjRTcAUQAjAgRZ8CMASQIdEY4QfAdHcFsL5rBlIUkB9QELAW Q1cjIaA6ICAoMw9QKSCQQDAtNDc4OBY0UMxhZwSQJIE4MCUgAcAgNC0zNTAldUUtWk0LcGwkgCDD LiEiQE8hxCXgGrAYcHQuBaBtFx+LFdoUUQArkAAACwABgAggBgAAAAAAwAAAAAAAAEYAAAAAA4UA AAAAAAADABCACCAGAAAAAADAAAAAAAAARgAAAABShQAAJ2oBAB4AEoAIIAYAAAAAAMAAAAAAAABG AAAAAFSFAAABAAAABAAAADkuMAAeABOACCAGAAAAAADAAAAAAAAARgAAAAA2hQAAAQAAAAEAAAAA AAAAHgAUgAggBgAAAAAAwAAAAAAAAEYAAAAAN4UAAAEAAAABAAAAAAAAAB4AFYAIIAYAAAAAAMAA AAAAAABGAAAAADiFAAABAAAAAQAAAAAAAAALABaACCAGAAAAAADAAAAAAAAARgAAAACChQAAAQAA AAsAQ4AIIAYAAAAAAMAAAAAAAABGAAAAAA6FAAAAAAAAAwBFgAggBgAAAAAAwAAAAAAAAEYAAAAA EIUAAAAAAAADAEaACCAGAAAAAADAAAAAAAAARgAAAAARhQAAAAAAAAMAR4AIIAYAAAAAAMAAAAAA AABGAAAAABiFAAAAAAAACwBggAggBgAAAAAAwAAAAAAAAEYAAAAABoUAAAAAAAADAGGACCAGAAAA AADAAAAAAAAARgAAAAABhQAAAAAAAAIB+A8BAAAAEAAAAE4slWAO9/FOuXfovsFiU28CAfoPAQAA ABAAAABOLJVgDvfxTrl36L7BYlNvAgH7DwEAAACXAAAAAAAAADihuxAF5RAaobsIACsqVsIAAFBT VFBSWC5ETEwAAAAAAAAAAE5JVEH5v7gBAKoAN9luAAAAQzpcRG9jdW1lbnRzIGFuZCBTZXR0aW5n c1xnaXllclxMb2NhbCBTZXR0aW5nc1xBcHBsaWNhdGlvbiBEYXRhXE1pY3Jvc29mdFxPdXRsb29r XG91dGxvb2sucHN0AAADAP4PBQAAAAMADTT9NwAAAgF/AAEAAAA8AAAAPFBCRU9MSkhIS0dKQ0ZF QUNGTkpJQUVQRkNDQUEuZ2VldGEuaXllckBzcHJpbnRwYXJhbmV0LmNvbT4AAwAGECzpoP8DAAcQ xwAAAAMAEBAAAAAAAwAREAAAAAAeAAgQAQAAAGUAAABIRUxMT0FMTCxDQU5BTllPTkVQTEVBU0VM SVNUVEhFU1RFUFNSRVFEVE9VUEdSQURFRlJPTVJFTEVBU0U4MTVUTzgxNj9USEFOS1NUT0FMTElO QURWQU5DRSxHRUVUQUlZRVJTAAAAAFEy
------=_NextPart_000_002A_01BFCB08.963F2200--
From: "Weaver, Walt" <wweaver_at_rightnowtech.com>
Date: Wed, 31 May 2000 14:14:21 -0600
Subject: RE: 8.1.5 to 8.1.6
I believe it's not an upgrade, but a new install. At least that's the way I treated it.
As far as moving data and apps, I have been moving them around with impunity, and not having problems.
--Walt Weaver
Bozeman, Montana, USA
> -----Original Message-----
> From: Geeta Iyer [mailto:geeta.iyer_at_sprintparanet.com]
> Sent: Wednesday, May 31, 2000 2:01 PM
> To: oracle-l_at_fatcity.com; oracledba_at_quickdoc.co.uk
> Subject: 8.1.5 to 8.1.6
>
>
> Hello all,
>
> Can anyone please list the steps reqd to upgrade from release 8.1.5 to
> 8.1.6 ?
>
>
> Thanks to all in advance,
> Geeta Iyer
> Sprint Enterprise Network Services
> Work: (303)220-4788
> Pager: 800-724-3508
> E-Mail: Geeta.Iyer_at_SprintParanet.com
> << File: ATT30026.txt >>
From: Suzy Vordos <lvordos_at_uswest.com>
Date: Wed, 31 May 2000 14:13:20 -0600
Subject: open cursors...
Is there a way to identify which users(s) have an open cursor? We are frequently seeing "max open cursors exceeded", open_cursors is set to 400. Sure, we can increase open_cursors, but I think the source is bad application code, just not sure which user is executing it. The only user_name I've found in v$open_cursor is SYS.
Thanks,
Suzy
From: "Thomas L. Harleman" <tharleman_at_iquest.net>
Date: Wed, 31 May 2000 15:18:20 -0500
Subject: RE: Packages passing REF CURSOR between procedures:
In the parent() procedure you reference ret_csr but you never declared it.
Tom Harleman
11080 Willowmere Dr.
Indianapolis, IN 46280
317-844-2884 Home
317-843-9122 Home Office
ThinkFast CONSULTING, Inc. (formerly Pinnacle Solutions)
Technical Consultant
3500 DePauw Blvd. Suite 2071
Indianapolis, IN 46268
tharleman_at_thinkfast.com
317-334-1317 Office
317-334-1301 Fax
-----Original Message-----
From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of Shawn
Ferris
Sent: Wednesday, May 31, 2000 1:40 PM
To: Multiple recipients of list ORACLE-L
Subject: Packages passing REF CURSOR between procedures:
I have a package. (sample code to follow) This package has several procedures.
One is the parent procedure and calls the rest. The "child" procedures need to return a cursor reference to the top level procedure.
When I try to compile this package it complains: PLS-00201: identifier 'RET_CSR' must be declared
Now I've passed REF CURSORS via OCI, but never between procedures. What am I missing? Obviously I need to declare it but where and how?
Oracle 8.1.5, Solaris 2.6+(?)
TIA
Shawn M Ferris
Oracle DBA - Time Warner Telecom
Sample code:
CREATE OR REPLACE PACKAGE test
AS
TYPE my_cursor IS REF CURSOR;
procedure parent(value number); procedure child1(ret_csr IN OUT my_cursor); procedure child2(ret_csr IN OUT my_cursor);
END test;
/
CREATE OR REPLACE PACKAGE test
AS
TYPE my_cursor IS REF CURSOR;
procedure parent(value number); procedure child1(ret_csr IN OUT my_cursor); procedure child2(ret_csr IN OUT my_cursor);
END test;
/
CREATE OR REPLACE PACKAGE BODY test
AS
PROCEDURE parent (value number)
IS
BEGIN
IF value = 1
THEN
child1(ret_csr);
ELSE
child2(ret_csr);
END IF;
FOR record IN ret_csr LOOP
dbms_output.put_line('Procedure: '||record.proc);
END LOOP;
END parent;
PROCEDURE child1(ret_csr IN OUT my_cursor)
IS
BEGIN
OPEN ret_csr FOR
select 'child1' proc from dual;
END child1;
PROCEDURE child2(ret_csr IN OUT my_cursor)
IS
BEGIN
OPEN ret_csr FOR
select 'child2' proc from dual;
END child2;
END test;
/
-- Author: Shawn Ferris INET: Shawn.Ferris_at_twtelecom.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). ------------------------------ From: Mohammad Shuja <shuja_at_technologist.com> Date: Fri, 02 Jun 2000 01:36:41 +0500 Subject: Re: web development (seeking opinion) Thanks Sean, Perhaps, even after so much time, there is no definite popular internet programming language (standard), like which is the case with database (oracle). I got all mixed responses, you suggested Perl + DBI & Apache, and another told ASP & IIS and there is java widely supported by oracle. I tend to go towards reliable combination, so i chose Perl. But, I've seen quite hype about JAVA. And some times i think that there are things that get popular, even when they don't provide the benefit which they originally aclaimed. I remember about CD's, during its introduction, it was promoted as 99% fool proof. Now you have to save it even from tiny dust particles. But, still, some of its benefits were so immense it is a standard now. I try to lean towards the direction where the market is heading. I want to learn somthing that is (or will be) WIDELY popular. I will be starting with java and after some footing on JAVA, i'll move towards perl. Based on your suggestions, i think, Perl DBI & Apache would be more robust and scalable for e-commerce at the moment. Shuja OCP - Application Developer Release 1 & 2 sean.hull_at_pobox.com wrote:Received on Wed May 31 2000 - 15:00:32 CDT
> On Sun, 28 May 2000, Mohammad Shuja wrote:
>
> > as there are software companies. I want to know, which is by far the
> > most popular and scalable web-database combination these days, specially
> > with the oracle database as the backend, in your OPINION. I don't wanna
> > start with something that won't last in the future.
>
> I'm not a big fan of Java for web development efforts because development
> is somewhat slow, and performance can be disappointing.
>
> In my opinion, Apache/mod_php/php is a *VERY* powerful combination which
> works very well with Oracle. There are many production internet sites fed
> off of this combination. Also, Apache/mod_perl/DBI is very powerful.
>
> http://www.apache.org/
> http://www.php.net/
> http://perl.apache.org/
> http://www.symbolstone.org/technology/perl/DBI/index.html
>
> Some other very powerful technologies are:
>
> http://www.masonhq.com/
> http://perl.apache.org/embperl/
> http://photo.net/doc/
> http://www.firstworks.com/site/pages/html/frames.html
>
> HTH,
> Sean
>
> --
> Author:
> INET: sean.hull_at_pobox.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
------------------------------ From: Christine Turner <christine.turner_at_ips-sendero.com> Date: Wed, 31 May 2000 14:00:05 -0000 Subject: RE: SQL - Deleteing rows from a table-- Help!!! To make it easy consider this......... select * from accts where acct_id in (select acct_id from dup_accts) and cust_id in (select cust_id from dup_accts); Hope this helps! take care, Christine Turner DBA IPS Sendero Scottsdale, Arizona ---------- From: DeSouza, Shaun[SMTP:Shaun.DeSouza_at_CIBC.com] Reply To: ORACLE-L_at_fatcity.com Sent: Wednesday, May 31, 2000 7:39 AM To: Multiple recipients of list ORACLE-L Subject: SQL - Deleteing rows from a table-- Help!!! I need to delete certain rows from a Table. To delete the rows I need to join to another table which contains the rows I need to delete. It is based upon the following SQL select: select * from accts t1, dup_accts t2 where t1.acct_id=t2.acct_id and t1.cust_id=t2.cust_id; I need to delete all the rows from the accts table which match to this join. I am really confused!!!! Can anyone help!!!!!! Shaun de Souza mailto:shaun.desouza_at_cibc.com Phone: 416.780.3295 Fax: 416.784.7581 -- Author: DeSouza, Shaun INET: Shaun.DeSouza_at_CIBC.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). ------------------------------ From: dgoulet_at_vicr.com Date: Wed, 31 May 2000 17:16:21 -0400 Subject: Re:RE: Work vs marriage If all of you guys & gals are so into only 40 hour weeks, there's a certain financial firm up here in Merrimac NH that you may well want to steer clear of. Talk about a sweat shop!?!?!?! I almost took a job there, but I really wasn't into 6 days a week 10 hour days as a norm. Some of the folks I know who have worked there lasted only about 18 months. One took a year break flipping burgers at McD's to get his head and marriage back on track. ____________________Reply Separator____________________ Subject: RE: Work vs marriage Author: "Shockey; David" <DShockey_at_jwrinc.com> Date: 5/31/00 1:14 PM I'm with you Walt! If they ever tell me that I have to start putting in more than an eight-hour day or work weekends then I'll tell them they can keep their $200K and hand them the keys to the company Lexus. Just kidding of course. I've paid my dues on more than one big project. I keep it around forty hours a week now. The wife and kids are better for it and when they are happy I am happy. -----Original Message----- Sent: Wednesday, May 31, 2000 11:23 AM To: Multiple recipients of list ORACLE-L I purposely seek out employment that lets me spend more time with my family and my fun pursuits, i.e. soaring, fly fishing, etc. I enjoy DBA work, but I enjoy my off time more. I live where I want to live, and while my salary is probably half of what most people make on this list, I spend most of my evenings and weekends where I want to be: with my family, or in the sky, or on the river. I'll leave the 80-hour weeks to you workaholics. Life's too short for that crap, IMHO. --Walt Weaver Bozeman, Montana, USA -----Original Message----- Sent: Wednesday, May 31, 2000 6:18 AM To: Multiple recipients of list ORACLE-L I have a story like this to tell; Some time ago I had to work during the weekend for some ^#$&* hacked our computers. On Wednesday I took the wife and kids to the circus and some hamburger-restaurant. They asked me 'when's the next weekend you have to work?' The guy next to me didn't do this, and his family tells him 'not to work that much' I think we all know that if everything ok at home, work goes well too.... (and v.v.) Eric Lansu ----- Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Tuesday, 30 May 2000 22:47
> Dick,
> I want to work for you...
>
> Tom Harleman
> 11080 Willowmere Dr.
> Indianapolis, IN 46280
> 317-844-2884 Home
> 317-843-9122 Home Office
>
> -----Original Message-----
> dgoulet_at_vicr.com
> Sent: Tuesday, May 30, 2000 10:38 AM
> To: Multiple recipients of list ORACLE-L
> >
> Tony,
>
> Many a year ago I too came home to a similar situation, after 48 hours
> on
> the flight line, coaxing a number of KC-135's & an SR-71 into the air.
> After
> getting some sleep, listening to the wife complain about "how much of a
> work-aholic" I was & reading a book to my three daughters before they went
> to
> bed, I found what I was missing. Since then, work is whatever time I
spend
> at
> work or if I wake up early in the morning (of my own volition, not the
alarm
> clock). And I take my wife out at least once a week. Marriage has never
> been
> better. This weekend we collectively spend the entire three days out on
the
> yard getting her flowers all planted, trimmed, etc... Boy does my back
> ache!!
>
> In short and in my opinion, If you aren't spending at least as much
time
> working on your marriage as you spend at work, you really can't complain
at
> the
> results!! That goes for ALL of us, guys & gals.
>
> Dick Goulet, MSgt, USAF (retired)
> Senior Oracle DBA
> Vicor Corporation
>
> ____________________Reply Separator____________________
> Author: Sherwin Anthony Sequeira <sherwin_at_sequeira.ezesurf.co.uk>
> Date: 5/26/00 8:04 PM
>
> > i hear u both, i'm supposed to leave at 3P on friday, at 2:50P,
developer
> > emails me about out of space on a PK index(partitioned), so i think no
> > biggie, i dont have DBA privs(its a production db and i dont do
> production),
> > so i start digging and realize its a range partitioned index and the
> ranges
> > are WAY OFF. so i spend this evening, figuring out the correct ranges
and
> > rebuild the index.
> >
> > bahhhhh
> >
> >
> > joe
>
> Joe,
>
> Please accept my commiserations. Users, don't you love them?
>
> I spent this evening driving 3 hours (70 miles) through pelting
rain
> and
> Bank holiday traffic, coming home to a loving daughter and a not so loving
> wife.
>
> I spent the day demonstrating Oracle's point in time recovery to a
> customer. Unfortunately the redo logs were screwed, with no backups! So
> much
> for the demo.
>
> But, I spent the evening playing snooker and drinking Honey Dew.
> Now
> catching up with the list.
>
> I bet you still enjoy it though eh!
>
> Regards.
>
> Tony
> --
> S. A. Sequeira
>
> --
> Author: Sherwin Anthony Sequeira
> INET: sherwin_at_sequeira.ezesurf.co.uk
> -- Author: Eric Lansu INET: eric.lansu_at_quicknet.nl Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Author: Walt Weaver INET: wweaver_at_rightnowtech.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <HEAD> <META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1"> <META NAME="Generator" CONTENT="MS Exchange Server version 5.5.2650.12"> <TITLE>RE: Work vs marriage</TITLE> </HEAD> <BODY> <P><FONT SIZE=2>I'm with you Walt! If they ever tell me that I have to start putting in more than an eight-hour day or work weekends then I'll tell them they can keep their $200K and hand them the keys to the company Lexus. </FONT></P> <P><FONT SIZE=2>Just kidding of course. I've paid my dues on more than one big project. I keep it around forty hours a week now. The wife and kids are better for it and when they are happy I am happy.</FONT></P> <P><FONT SIZE=2>-----Original Message-----</FONT> <BR><FONT SIZE=2>From: Walt Weaver [<A HREF="mailto:wweaver_at_rightnowtech.com">mailto:wweaver_at_rightnowtech.com</A>]</FON T> <BR><FONT SIZE=2>Sent: Wednesday, May 31, 2000 11:23 AM</FONT> ------------------------------ From: Steve Adams <steve.adams_at_ixora.com.au> Date: Thu, 1 Jun 2000 14:31:44 +1000 Subject: RE: CBO parameters Hi Gary, I suggest that you leave the cost adjustment parameter alone (it should really be hidden along with the other fudge factor parameters). However, setting optimizer_index_caching is helpful in some cases where the
 |
 |