date:20030605




Good 
question. I see it very intermittently with sessions (robot cells) that 
stay connected for days on end. Just had an occurrence this week. 
The DB has been up for 96 days before all heck broke loose. Thankfully we 
only need to reconnect/restart the robots.

Dick GouletSenior Oracle DBAOracle Certified 8i DBA 

-Original Message-From: Sam Bootsma 
[mailto:[EMAIL PROTECTED]Sent: Thursday, June 05, 2003 4:50 
PMTo: Multiple recipients of list ORACLE-LSubject: RE: 
Limiting Concurrent Sessions Not Working

Hi Dick, Thanks for the 
tip. Metalink says the bug applies to RDBMS 8.0.4. I tested it as 
well, using a modified version of their test case. I did not encounter 
this bug at all. 

Perhaps it is OK on 
Oracle 7.3.4?


Sam 
Bootsma
George Brown 
College
[EMAIL PROTECTED]
416-415-5000 
x4933

-Original 
Message-From: Goulet, Dick 
[mailto:[EMAIL PROTECTED] Sent: June 4, 2003 4:15 PMTo: Multiple recipients of list 
ORACLE-LSubject: RE: Limiting 
Concurrent Sessions Not Working


OK, now 
watch out for Oracle bug 643709 which can send your users a pile of "ORA-02394: 
exceeded session limit on IO usage, you are being logged off" even though 
you don't have any IO limits set. It's fixed in 
8.1.x.


Dick GouletSenior Oracle DBAOracle Certified 8i 
DBA 
-Original 
Message-From: Sam Bootsma 
[mailto:[EMAIL PROTECTED]Sent: Wednesday, June 04, 2003 3:30 
PMTo: Multiple recipients of 
list ORACLE-LSubject: RE: 
Limiting Concurrent Sessions Not Working
Bingo!

Thanks 
Dick, it is working now.


Sam
GBC

-Original 
Message-From: Goulet, Dick 
[mailto:[EMAIL PROTECTED] Sent: June 4, 2003 2:30 PMTo: Multiple recipients of list 
ORACLE-LSubject: RE: Limiting 
Concurrent Sessions Not Working


Do you 
have "resource_limit = true" in init.ora? If you don't it defaults to 
FALSE  the profile has no effect.


Dick GouletSenior Oracle DBAOracle Certified 8i 
DBA 
-Original 
Message-From: Sam Bootsma 
[mailto:[EMAIL PROTECTED]Sent: Wednesday, June 04, 2003 2:10 
PMTo: Multiple recipients of 
list ORACLE-LSubject: Limiting 
Concurrent Sessions Not Working
Oracle7 Server Release 7.3.4.5.0 
(yes, I know, old); AIX 4.3.3 

Hello All,

I am trying to limit concurrent 
sessions on my database. The Oracle documentation says I can do it. 
However, when I follow the steps (create profile with sessions per user set to 
one, then assign Oracle user to this profile) the user is not stopped from 
exceeding the number of concurrent sessions. I tested this by connecting 
using Sql Plus. I even tried bouncing the database, to see if that makes a 
difference, but to no avail. 

Any ideas what is happening? 
Am I missing something? Is this a problem/bug with Oracle 7.3.4? The 
output below shows the steps I followed to create the profile and user. It 
also shows multiple connections to the database after bouncing the 
instance.

Thanks for any 
suggestions!

Sam.



SQL create profile sam limit 
sessions_per_user 1;

Profile created.

SQL create user sam identified 
by sam;

User created.

SQL alter user sam profile 
sam;

User altered.

SQL grant create session to 
sam;

Grant succeeded.

SQL 

SQL l
 1 select 
limit
 2 from 
dba_profiles
 3 where 
profile=''
 4* and resource_name = 
'SESSIONS_PER_USER'
SQL /

LIMIT

1

SQL 

SQL select 
profile
 2 from 
dba_users
 3 where username = 
'SAM';

PROFILE
--
SAM

SQL

SVRMGR shutdown 
normal
Database closed.
Database 
dismounted.
ORACLE instance shut 
down.

SVRMGR connect 
internal
Connected to an idle 
instance.
SVRMGR startup
ORACLE instance 
started.
Total System Global 
Area 34122296 bytes
Fixed 
Size 
38992 bytes
Variable 
Size 
31797736 bytes
Database 
Buffers 
2252800 bytes
Redo 
Buffers 
32768 bytes
Database mounted.
Database opened.
SVRMGR select osuser, 
username
 2 from 
v$session; 
OSUSER 
USERNAME 

--- 
--
oracle 

oracle 

oracle 

oracle 

oracle 

oracle 

oracle 

oracle 

oracle 

oracle 

oracle 

oracle 
SYS 

12 rows selected.
SVRMGR select osuser, username 
from v$session;
OSUSER 
USERNAME 

--- 
--
oracle 

oracle 

oracle 

oracle 

oracle 

oracle 

oracle 

oracle 

oracle 

oracle 

oracle 

oracle 
SYS 

sam 
SAM 

sam 
SAM 

14 rows selected.
SVRMGR

Sam 
GBC

RE: FW: ora 1017 -solved

2003-06-05 Thread Richard Ji

Doh, I replied to Jared only.  Here it is:

-Original Message-
I knew that was coming. :) Should of explained in the last e-mail.
Sorry, was busy with many things.

The error ora 1017 says logon denied.  That got me chasing all
the connection stuff.  Turns out the package uses a remote sequence
that I forgot to create a synonym for.  If the PL/SQL stack trace
didn't bomb with ora-600 [17090], I would probably found it sooner.

Richard Ji

-Original Message-
Sent: Thursday, June 05, 2003 5:26 PM
To: [EMAIL PROTECTED]
Cc: Richard Ji
Importance: High


and what did you do to solve it?






Richard Ji [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
 06/05/2003 03:04 PM
 Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc: 
Subject:FW: ora 1017 -solved


Never mind, I solved.  Man, that error message is misleading. :)

  -Original Message-
 From:  Richard Ji 
 Sent:  Thursday, June 05, 2003 4:46 PM
 To:Multiple recipients of list ORACLE-L (E-mail)
 Subject:   ora 1017
 
 Hi,
 
 I am accessing a table over database link, which I am able
 to select, insert, delete from etc.
 
 Now I have a package locally that does insert, delete on that
 remote table but when I run the package, I get ora 1017. But
 from SQL*Plus I can do my select, insert, delete just fine.
 
 If I drop the synonym and create a real table locally, everything
 works.
 
 I also tried to do a PL/SQL stack trace and got an ora-600.
 
 Any ideas?
 
 Thanks
 
 Richard 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Richard Ji
  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-Mail message
to: [EMAIL PROTECTED] (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).



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Richard Ji
  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-Mail message
to: [EMAIL PROTECTED] (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).

Thanks -- Re: example to use bind variables with OO4O/VB

2003-06-05 Thread Prem Khanna J

Thanx Ganesh,Jared,Jay,Roy and Chajol.
Thanks for the info'.

Jp.


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Prem Khanna J
  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-Mail message
to: [EMAIL PROTECTED] (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).

Mailing List

2003-06-05 Thread Sameer Ghadge


 Untitled 
ODTUG-DEV2K-L - [EMAIL PROTECTED]
[EMAIL PROTECTED]



---BeginMessage---
SUBSCRIBE ORACLE-L
---End Message---

Re: Oracle Data Backup




Have a look at rman which is part of the 
Oracle installation. You should be able to do any kind of backup you want 
with this product.

Regards,
Ruth

  - Original Message - 
  From: 
  Santosh 
  Varma 
  To: Multiple recipients of list ORACLE-L 
  
  Sent: Friday, May 30, 2003 8:25 AM
  Subject: Oracle Data Backup
  
  Hellolist,
  
   I am 
  using Oracle 8.1.6 I want to take Back-Up of Application Data at the end of 
  the Day. 
  Which is the 
  best suitable option for backup? any directory (for eg: c:\oracle\ora81\rdbms) 
  where from i can take it directly ? like in unix we have directory where all 
  the tables/indexes are located and we need to give that path for backup and 
  the tables/indexes/data are backed Up.
  
  Ideas are 
  welcome URGENTLY
  
  Thanks and 
  regards,
  Santosh

Re: Re: question about large pool (now NetApp)

2003-06-05 Thread rgaffuri

thanks for your excellent responses. I guess striping doesnt help with netapps. 

I was finding alot of waits for redo logs, full table scans, and index reads. However, 
I guess I have to live with it with the netapps. I believe we have a 1GB pipe. Does it 
matter if I put my indexes in seperate datafiles from my tables with a netapp 
configuration? 

 From: Binley Lim [EMAIL PROTECTED]
 Date: 2003/06/04 Wed AM 07:49:39 EDT
 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
 Subject: Re: question about large pool (now NetApp)

 For NetApp, the key thing is the number, and speed (100Mbit or 1Gbit?), of
 network I/O cards connecting to the NFS server. Mount points are irrelevant
 as they could all be going over the same I/O channel.

 There is a NetApp performance paper that recommends a number of things to
 tweak for performance, including using multiple IO slaves/DBWRs, rather than
 asynch_io. Check with your vendor. However, it comes with a disclaimer - do
 your own tests as it may not apply. I ended up using asynch_io as there was
 a 10-15% improvement over multiple slaves. In the scheme of things, this is
 a minor issue.

 Things that you normally spend a lot of time on like striping and
 distributing IO are no longer meaningful. After all, you bought a storage
 server to take care of such things for you. What will kill you are the
 things you never have to worry about in a DAS configuration. Like:

 - CPU utilisation will increase significantly, used for shuffling blocks
 over the network.
 - test your NFS mount options, especially rsize and wsize.
 - adjust your OS kernel parameters, including NFS parameters
 - make sure your OS and especially NFS, patches are up to date
 - tweak the network interface (ndd command)

 Some other things that cannot be changed in a hurry:

 - mount as UDP rather than TCP if you have a dedicated segment for NFS
 traffic. Trying to share the company-wide network for this is a particularly
 bad idea. Chances are you will back it out in a hurry.
 - a later version of OS is much better than an earlier version, eg Solaris
 2.8/9 over 2.6. Apparently significant improvements have been made in the
 TCP/NFS components of the OS.
 - if you have later version of OS, look at configuring for Ethernet Jumbo
 Frames.
 - if the hardware/software is capable, and you have more than 1 network
 card, look at IP trunking.
 - if you have older hardware in the DB server, you will run into limits like
 Sun's SBUS max IO of ~40MB/s. If your requirements are below this, great.

 Sounds like sysadm type of issues? Yes, it does. If your sysadm  (or boss)
 is good enough to take care of all of these for you, great. In practise, I
 find that seldom happens.

 - Original Message -
 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
 Sent: Wednesday, June 04, 2003 1:01 AM

  you only want DBWR_IO_SLAVES or multiple DBWRn if you have datafiles
 spread over multiple I/O points correct? We are using 'Network Appliance'
 hard disk array that Im not all that familiar with. It looks like we have 3
 I/O points and 5 mount points.

  my boss told me that striping data files and redo log files across the I/O
 points wotn help because there is only 1-2 I/O cards(forget the exact, I
 hope it isnt hard for anyone to figure out what Im referring to) on the
 server itself.

  This does not sound accurate. Since Ive read several books and all say to
 stripe the files?

  btw, thanks for the info on the large pool. I can free up about 300MB of
 memory we aer wasting on that and the java pool for other areas.

 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 -- 
 Author: Binley Lim
   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-Mail message
 to: [EMAIL PROTECTED] (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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: [EMAIL PROTECTED]
  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-Mail message
to: [EMAIL PROTECTED] (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).

RE: Chris: Thank you!

2003-06-05 Thread Jeremiah Wilton

I have a bit of Oracle memorabilia but I probably won't be willing to
part with it.  Maybe the Oracle Museum should be virtual, with a
registry of who has what archaic Oracle stuff.

I have all the version 5 for DOS diskettes, which it sounds like you
have as well.  I tried running the installer in the DOS window on my
Windows NT PC a couple years ago, and it only balked because I didn't
have one of the designated PC brands.  Not sure where I'm going to
find a Leading Edge brand PC these days.

I also have the Oracle: The Complete Reference for v.5 and v.6 by
George Koch, which includes a variety of v.5 administration syntax
(IOR WARM, etc.), and a wall-mountable full color picture of the
author on the back looking very spiffy with the exception of needing a
neck shave.

--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton

On Wed, 4 Jun 2003, Jamadagni, Rajendra wrote:

 Dang ...
 
 last Friday we threw away Oracle 6/7/8 disks and printed manuals ... Let me
 see still ...
 
 Raj
 
 
 Rajendra dot Jamadagni at nospamespn dot com
 All Views expressed in this email are strictly personal.
 QOTD: Any clod can have facts, having an opinion is an art !
 
 
 Reply-To: [EMAIL PROTECTED]
 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
 Date: Tue, 03 Jun 2003 14:19:44 -0800
 
 
 I have to tell you this, my friends:
 
 Today, a package arrived here in Maaloev on the oak table. It contained 
 Oracle version 5.1.C and 6.0 on 5.25'' diskettes.
 
 The sender was Chris G. from Nokesville, VA.
 
 This will go right into the Oracle Museum, and I hope to be able to let you 
 guys one day try to install version 5 on a DOS PC at some future conference.
 
 Chris - I owe you a case of beer or two. And your name will be forever saved
 
 in the Oracle Museum.
 
 Thank you.
 
 Mogens
 
 PS. Version 5 and 6 docs are most welcome, if anyone can live without them.
 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jeremiah Wilton
  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-Mail message
to: [EMAIL PROTECTED] (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).

RE: Chris: Thank you!

2003-06-05 Thread Loughmiller, Greg

Title: RE: Chris: Thank you!



got 
some 6.0.36 diskettesfor those interested:-)

  -Original Message-From: Jamadagni, Rajendra 
  [mailto:[EMAIL PROTECTED]Sent: Wednesday, June 04, 2003 
  8:31 AMTo: Multiple recipients of list ORACLE-LSubject: 
  RE: Chris: Thank you!
  Dang ... 
  last Friday we threw away Oracle 6/7/8 disks and printed 
  manuals ... Let me see still ... 
  Raj  
  Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. 
  QOTD: Any clod can have facts, having an opinion is an art 
  ! 
  Reply-To: [EMAIL PROTECTED] To: 
  Multiple recipients of list ORACLE-L [EMAIL PROTECTED] 
  Date: Tue, 03 Jun 2003 14:19:44 -0800 
  I have to tell you this, my friends: 
  Today, a package arrived here in Maaloev on the oak table. It 
  contained Oracle version 5.1.C and 6.0 on 5.25'' 
  diskettes. 
  The sender was Chris G. from Nokesville, VA. 
  This will go right into the Oracle Museum, and I hope to be 
  able to let you guys one day try to install version 5 
  on a DOS PC at some future conference. 
  Chris - I owe you a case of beer or two. And your name will be 
  forever saved in the Oracle Museum. 
  Thank you. 
  Mogens 
  PS. Version 5 and 6 docs are most welcome, if anyone can live 
  without them.

Sum of Previous Record

2003-06-05 Thread Walid Alkaakati



Hi list ,

Can you help me please .

I have  a report  that show   data as follows :

debit credit   balance
30-3
 0   -1 2
 1  0  3

Is their a way to get   balance  without using  a separet   query in a
formula column,i .e i need  the value  of the previous
record   in the same repeating frame.

Thanks


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Walid Alkaakati
  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-Mail message
to: [EMAIL PROTECTED] (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).

Re: Migrating from Informix to Oracle 9.2 ( with O.S. Change from AIX to Linux )

 But then Larry's yacht appeared racing in the America's Cup ;) 
May be a bug? ;) 

- Kirti

--- Binley Lim [EMAIL PROTECTED] wrote:
 Big Blue button that ships with the new OEM. Hold down the shift key and
 triple click on the middle mouse button.
 
 - Original Message -
 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
 Sent: Wednesday, June 04, 2003 8:59 PM
 to Linux )
 
 
 
  What may be Easier ways of doing the same ?
 
  Thanks
 
  --
  Please see the official ORACLE-L FAQ: http://www.orafaq.net
 

__
Do you Yahoo!?
Yahoo! Calendar - Free online calendar with sync to Outlook(TM).
http://calendar.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Kirtikumar Deshpande
  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-Mail message
to: [EMAIL PROTECTED] (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).

RE: Chris: Thank you!

Hey, I've got an old Leading Edge 486DLC in my basement.  Needs a new set of drives.

Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA 

-Original Message-
Sent: Wednesday, June 04, 2003 9:35 AM
To: Multiple recipients of list ORACLE-L


I have a bit of Oracle memorabilia but I probably won't be willing to
part with it.  Maybe the Oracle Museum should be virtual, with a
registry of who has what archaic Oracle stuff.

I have all the version 5 for DOS diskettes, which it sounds like you
have as well.  I tried running the installer in the DOS window on my
Windows NT PC a couple years ago, and it only balked because I didn't
have one of the designated PC brands.  Not sure where I'm going to
find a Leading Edge brand PC these days.

I also have the Oracle: The Complete Reference for v.5 and v.6 by
George Koch, which includes a variety of v.5 administration syntax
(IOR WARM, etc.), and a wall-mountable full color picture of the
author on the back looking very spiffy with the exception of needing a
neck shave.

--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton

On Wed, 4 Jun 2003, Jamadagni, Rajendra wrote:

 Dang ...
 
 last Friday we threw away Oracle 6/7/8 disks and printed manuals ... Let me
 see still ...
 
 Raj
 
 
 Rajendra dot Jamadagni at nospamespn dot com
 All Views expressed in this email are strictly personal.
 QOTD: Any clod can have facts, having an opinion is an art !
 
 
 Reply-To: [EMAIL PROTECTED]
 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
 Date: Tue, 03 Jun 2003 14:19:44 -0800
 
 
 I have to tell you this, my friends:
 
 Today, a package arrived here in Maaloev on the oak table. It contained 
 Oracle version 5.1.C and 6.0 on 5.25'' diskettes.
 
 The sender was Chris G. from Nokesville, VA.
 
 This will go right into the Oracle Museum, and I hope to be able to let you 
 guys one day try to install version 5 on a DOS PC at some future conference.
 
 Chris - I owe you a case of beer or two. And your name will be forever saved
 
 in the Oracle Museum.
 
 Thank you.
 
 Mogens
 
 PS. Version 5 and 6 docs are most welcome, if anyone can live without them.
 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jeremiah Wilton
  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-Mail message
to: [EMAIL PROTECTED] (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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Goulet, Dick
  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-Mail message
to: [EMAIL PROTECTED] (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).

RE: Good technical documents/references on tuning restores

2003-06-05 Thread Henry Poras

Title: RE: Good technical documents/references on tuning restores



Paula,

IIRC 
'MISSING' means it is in the data dictionary, but not the control file. I've 
gotten that before, but haven't played that game in a while. You might be able 
to 'DROP' them, but I'm not sure. Check that first on a mini-test 
system.

Henry


  -Original Message-From: [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]On Behalf Of 
  [EMAIL PROTECTED]Sent: Tuesday, June 03, 2003 11:05 
  PMTo: Multiple recipients of list ORACLE-LSubject: RE: 
  Good technical documents/references on tuning restores
  Okay, 
  
  Database open and I wanted to not restore and not reference certain 
  index and materia. view datafiles. Now the datafiles show up with weird 
  MISSING.. names. How do I clean this up?
  
  Thanks,
  paula
  
-Original Message-From: 
[EMAIL PROTECTED] 
[mailto:[EMAIL PROTECTED]Sent: Tuesday, June 03, 
2003 10:20 PMTo: Multiple recipients of list 
ORACLE-LSubject: RE: Good technical documents/references on 
tuning restores
Strange: 
looking at v$backup_async_io found some datafiles 
where  active bytes per sec 
 long-waits  
2154608  
 
 297 
 
7489829 
 
 
 297 
How can I start finding the disparity? 
-Original Message- From: 
Stankus, Paula G Sent: Tuesday, June 03, 2003 9:05 
PM To: Stankus, Paula G; 
'[EMAIL PROTECTED]' Subject: RE: Good technical 
documents/references on tuning restores 
Did I say that throughout this restore/recovery process my 
tapes being mounted and unmounted while other database backups and cloning 
was occurring. Big duh - this has got to be slowing down the 
process. Any ideas on how to handle this? Perhaps more than one 
tape subsystem would be better or while doing restores other backup utility 
is halted - hmmm - but that risks those other systems? How can I sell 
that? H. Maybe I will first backup to disk. Yep, one 
backup to disk. Yep.
-Original Message- From: 
Stankus, Paula G Sent: Tuesday, June 03, 2003 9:00 
PM To: Stankus, Paula G; 
'[EMAIL PROTECTED]' Subject: RE: Good technical 
documents/references on tuning restores 
See nwadmin shows parellism = 32. I am not the tape 
person - that is my sys admin. I don't believe they actually have 32 
tapes involved only 4. Can this impact performance by setting this too 
high? I also notice one backup server for networker with nwadmin 
messages like "clone sets being created...", "other databases being backed 
up". What is the usual policy on concurrently running backups, cloning 
at the same time recovery is taking place. It appears to show a lot of 
media waiting events: waiting for dlt7000 tape ... of the tapes that I 
specifically need for this restore. Did I say: I love my 
admin...I love my adminI love my admin...
-Original Message- From: 
Stankus, Paula G Sent: Tuesday, June 03, 2003 8:53 
PM To: Stankus, Paula G; 
'[EMAIL PROTECTED]' Subject: RE: Good technical 
documents/references on tuning restores 
Okay, almost 4 minutes for a datafile that was 78168 blocks 
- how do I know if this is reasonable? 
Also, seems to write these files out (restore sychron.) why 
can't it restore different datafiles in parallel? - stupid question 
huh?
-Original Message- From: 
Stankus, Paula G Sent: Tuesday, June 03, 2003 8:46 
PM To: Stankus, Paula G; 
'[EMAIL PROTECTED]' Subject: RE: Good technical 
documents/references on tuning restores 
SELECT SID, SERIAL#, 
CONTEXT, 
ROUND(SOFAR/TOTALWORK*100,2) "% 
complete", 
SUBSTR(TO_CHAR(SYSDATE,'HH24:MI:SS'),1,15) "Time 
now" FROM 
V$SESSION_LONGOPS 
WHERE OPNAME like 
'%restore%'; 
. 
showed all 100% complete but msglog from RMAN shows 
it is truly still running. 
-Original Message- From: 
Stankus, Paula G Sent: Tuesday, June 03, 2003 8:40 
PM To: Stankus, Paula G; 
'[EMAIL PROTECTED]' Subject: RE: Good technical 
documents/references on tuning restores 
Also found on monitoring performance of RMAN jobs: 
Note:144640.1 on Metalink 
-Original Message- From: 
Stankus, Paula G Sent: Tuesday, June 03, 2003 8:36 
PM To: Stankus, Paula G; 
'[EMAIL PROTECTED]' Subject: RE: Good technical 
documents/references on tuning restores 
Found this white paper: 
http://otn.oracle.com/deploy/availability/pdf/rman_performance_wp.pdf 

Anything better? 
-Original Message- From: 
Stankus, Paula G Sent: Tuesday, June 03, 2003 8:33 
PM To: Stankus, Paula G; 
'[EMAIL PROTECTED]' Subject: RE: Good technical 
documents/references on tuning restores 
This is what I have set on my target database: 
--- ---

RE: passing ref cursor on a procedure

Title: passing ref cursor on a procedure









If
in SQL*Plus:



Just declare variable of REFCURSOR type
and pass it to stored procedure:



DECLARE lCursor REFCURSOR;

Begin

procedure_name(par1, par2, ,
:lCursor);

end;

/





Igor Neyman, OCP DBA

[EMAIL PROTECTED]







-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Hatzistavrou
John
Sent: Wednesday, June 04, 2003
8:40 AM
To: Multiple recipients of list
ORACLE-L
Subject: passing ref cursor on a
procedure



Dear All,

I have a vendor procedure which I wish to run .
This
procedure takes as input variables a varchar and a ref_cursor.

I know the query that is related to the ref_cursor
and I wish to implicitly pass it to the procedure . How can this be
done?

Kind Regards,



Hatzistavrou Yannis

FW: Shite of the day

Oh-My-Gosh.  

Worry free?  I just upgraded another 8.1.7.4 database to 9.2.  When I set the 
COMPATIBLE parm to 9.0.2 (or 9.2, which would make sense) I get really messy errors:

ORA-00402: database changes by release 9.0.1.3.0 cannot be used by release
135294976

ORA-01571: redo version 9.0.2.0.0 incompatible with ORACLE version 8.1.7.0.0

So then I tried to set it back to 8.1.7, or comment out COMPATIBLE altogether, and I 
get the same type of error.  It won't open at all. 

I tried initiating recovery.  This database is in noarc mode.  It starts looking for 
arclogs that *do not* exist.  I also tried to drop the redo log groups and recreate 
them.  Still, no dice. 

Again, unbreakable my FUNDAMENT.

So has anyone seen this before?  I opened a tar yesterday and promptly confused 
support. 

Lisa



-Original Message-
Sent: Wednesday, June 04, 2003 7:45 AM
To: Multiple recipients of list ORACLE-L


Trade SQL Server for Oracle9i Database and get up to 100% license credit 
and peace of mind.

Tired of applying patches? Frustrated with managing mulitple database servers? 
In the time it takes you to apply all Microsoft's patches to your servers, 
you can successfully migrate your database to Oracle9i Database and be 
worry-free. 


From 
http://www.oracle.com/start/linuxsqlserver/intro.html?src=1764462Act=16


I don't understand PR of Oracle. The RDBMS has so much properties which are 
much more better implemented in Oracle than in MS SQL and they choose 
'patching' which *** on both servers.

JP

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jan Pruner
  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-Mail message
to: [EMAIL PROTECTED] (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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Koivu, Lisa
  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-Mail message
to: [EMAIL PROTECTED] (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).

RE: Sum of Previous Record

2003-06-05 Thread Stephane Faroult

Have a look at analytical functions (LAG() and the like)

- --- Original Message --- -
From: Walid Alkaakati
[EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L
[EMAIL PROTECTED]
Sent: Wed, 04 Jun 2003 05:10:14

Hi list ,

Can you help me please .

I have  a report  that show   data as follows :

debit credit   balance
30-3
 0   -1 2
 1  0  3

Is their a way to get   balance  without using  a
separet   query in a
formula column,i .e i need  the value  of the
previous
record   in the same repeating frame.

Thanks

-- 
Please see the official ORACLE-L FAQ:
http://www.orafaq.net
-- 
Author: Walid Alkaakati
  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-Mail message
to: [EMAIL PROTECTED] (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).
---
--

Regards,

Stephane Faroult
Oriole
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Stephane Faroult
  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-Mail message
to: [EMAIL PROTECTED] (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).

RE: Quick Question of APPS DBA

2003-06-05 Thread Nelson, Allan

If this is a regular CONCSUB job and your stuff is in default spots then
look at $APPL_TOP/admin/your instance/log

Allan

-Original Message-
Sent: Tuesday, June 03, 2003 10:00 PM
To: Multiple recipients of list ORACLE-L


Any APPS DBAs out there?

I need to know where to find the argltp log file. (AR to GL transfer
process log file)

Thanks.

=)

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Maria Aurora de la Vega
  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-Mail message
to: [EMAIL PROTECTED] (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).



__
This email is intended solely for the person or entity to which it is addressed and 
may contain confidential and/or privileged information.  Copying, forwarding or 
distributing this message by persons or entities other than the addressee is 
prohibited. If you have received this email in error, please contact the sender 
immediately and delete the material from any computer.  This email may have been 
monitored for policy compliance.  [021216]

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Nelson, Allan
  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-Mail message
to: [EMAIL PROTECTED] (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).

RE: Interesting!

2003-06-05 Thread Khedr, Waleed

I think it's good to have (forgive me Jared :)). 
It reminds me with Pascal language.

Waleed

-Original Message-
Sent: Tuesday, June 03, 2003 9:40 PM
To: Multiple recipients of list ORACLE-L


My first real PL/SQL program used this technique.  Of course since it was my
first program I ran into a very annoying variable scope issue.  Of course
after spending hours debugging the code, I realized I should have taken the
advice of our DBA, the infamous Jared Still, and just used a package.  I
have since looked askew at the nesting of procedures.  I can't remember the
actual error I encountered.  It probably had nothing or very little to do
with my nested procedures, but in my mind I can't consider this to be a good
practice.  A package does the same job, and so much cleaner.

P.S.  I think this was the first time I noted Jared's annoying habit of
being right


Steve McClure

-Original Message-
Waleed
Sent: Tuesday, June 03, 2003 4:10 PM
To: Multiple recipients of list ORACLE-L


I've just discovered this, never thought if it was possible or not.
Just wanted to share it with you, so forgive me if you know it already.
Procedure can contain other procedures:

create or replace procedure test_test1 as
procedure test_test2 as
begin
 dbms_output.put_line('hello2');
 end;
function c1 ( p1 in number) return number as
begin
 return(p1 * 2);
end;
begin
  dbms_output.put_line('hello1');
  test_test2;
  dbms_output.put_line( c1(10));
end;

Regards,

Waleed

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Khedr, Waleed
  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-Mail message
to: [EMAIL PROTECTED] (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).


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Steve McClure
  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-Mail message
to: [EMAIL PROTECTED] (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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Khedr, Waleed
  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-Mail message
to: [EMAIL PROTECTED] (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).

RE: Sum of Previous Record

2003-06-05 Thread Lord, David - CSG

Walid

You can use SUM as an analytic function like this: -

SQL select credit, debit, sum(credit + debit) over (order by rowid) from
foo;

CREDIT  DEBIT SUM(CREDIT+DEBIT)OVER(ORDERBYROWID)
-- -- ---
 3  0   3
 0 -1   2
 1  0   3

Obviously, you will need to order by something more sensible than the rowid
(perhaps a timestamp).

 -Original Message-
 From: Walid Alkaakati [mailto:[EMAIL PROTECTED]
 Sent: 04 June 2003 14:10
 To: Multiple recipients of list ORACLE-L
 Subject: Sum of Previous Record
 
 
 
 
 Hi list ,
 
 Can you help me please .
 
 I have  a report  that show   data as follows :
 
 debit credit   balance
 30-3
  0   -1 2
  1  0  3
 
 Is their a way to get   balance  without using  a separet   query in a
 formula column,i .e i need  the value  of the previous
 record   in the same repeating frame.
 
 Thanks
 
 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 -- 
 Author: Walid Alkaakati
   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-Mail message
 to: [EMAIL PROTECTED] (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).
 


**
This message (including any attachments) is confidential and may be 
legally privileged.  If you are not the intended recipient, you should 
not disclose, copy or use any part of it - please delete all copies 
immediately and notify the Hays Group Email Helpdesk at
[EMAIL PROTECTED]
Any information, statements or opinions contained in this message
(including any attachments) are given by the author.  They are not 
given on behalf of Hays unless subsequently confirmed by an individual
other than the author who is duly authorised to represent Hays.
 
A member of the Hays plc group of companies.
Hays plc is registered in England and Wales number 2150950.
Registered Office Hays House Millmead Guildford Surrey GU2 4HJ.
**

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Lord, David - CSG
  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-Mail message
to: [EMAIL PROTECTED] (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).

RE: Good technical documents/references on tuning restores

Title: RE: Good technical documents/references on tuning restores









Paula,



It was very entertaining to read this
thread -J

Did you answer all your questions?-J





Igor Neyman, OCP DBA

[EMAIL PROTECTED]







-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED]
Sent: Tuesday, June 03, 2003 9:05
PM
To: Multiple recipients of list
ORACLE-L
Subject: RE: Good technical
documents/references on tuning restores



Did I say that throughout this restore/recovery
process my tapes being mounted and unmounted while other database backups and
cloning was occurring. Big duh - this has got to be slowing down the
process. Any ideas on how to handle this? Perhaps more than one
tape subsystem would be better or while doing restores other backup utility is
halted - hmmm - but that risks those other systems? How can I sell
that? H. Maybe I will first backup to disk. Yep, one
backup to disk. Yep.

-Original Message- 
From: Stankus, Paula G 
Sent: Tuesday, June 03, 2003 9:00
PM 
To: Stankus, Paula G;
'[EMAIL PROTECTED]' 
Subject: RE: Good technical
documents/references on tuning restores 



See nwadmin shows parellism = 32. I am not the
tape person - that is my sys admin. I don't believe they actually have 32
tapes involved only 4. Can this impact performance by setting this too
high? I also notice one backup server for networker with nwadmin messages
like clone sets being created..., other databases being
backed up. What is the usual policy on concurrently running
backups, cloning at the same time recovery is taking place. It appears to
show a lot of media waiting events: waiting for dlt7000 tape ... of the
tapes that I specifically need for this restore. Did I say: I love
my admin...I love my adminI love my admin...

-Original Message- 
From: Stankus, Paula G 
Sent: Tuesday, June 03, 2003 8:53
PM 
To: Stankus, Paula G;
'[EMAIL PROTECTED]' 
Subject: RE: Good technical
documents/references on tuning restores 



Okay, almost 4 minutes for a datafile that was 78168
blocks - how do I know if this is reasonable? 

Also, seems to write these files out (restore
sychron.) why can't it restore different datafiles in parallel? - stupid
question huh?

-Original Message- 
From: Stankus, Paula G 
Sent: Tuesday, June 03, 2003 8:46
PM 
To: Stankus, Paula G;
'[EMAIL PROTECTED]' 
Subject: RE: Good technical
documents/references on tuning restores 



SELECT SID, SERIAL#,
CONTEXT,

ROUND(SOFAR/TOTALWORK*100,2)
%
complete,

SUBSTR(TO_CHAR(SYSDATE,'HH24:MI:SS'),1,15)
Time now 
FROM
V$SESSION_LONGOPS

WHERE OPNAME like
'%restore%';

.

showed all 100% complete but msglog
from RMAN shows it is truly still running. 

-Original Message- 
From: Stankus, Paula G 
Sent: Tuesday, June 03, 2003 8:40
PM 
To: Stankus, Paula G;
'[EMAIL PROTECTED]' 
Subject: RE: Good technical
documents/references on tuning restores 



Also found on monitoring performance of RMAN jobs:

Note:144640.1 on Metalink


-Original Message- 
From: Stankus, Paula G 
Sent: Tuesday, June 03, 2003 8:36
PM 
To: Stankus, Paula G;
'[EMAIL PROTECTED]' 
Subject: RE: Good technical
documents/references on tuning restores 



Found this white paper: 

http://otn.oracle.com/deploy/availability/pdf/rman_performance_wp.pdf


Anything better? 

-Original Message- 
From: Stankus, Paula G 
Sent: Tuesday, June 03, 2003 8:33
PM 
To: Stankus, Paula G;
'[EMAIL PROTECTED]' 
Subject: RE: Good technical
documents/references on tuning restores 



This is what I have set on my target database:


--- ---
--- 
backup_tape_io_slaves
boolean
FALSE

tape_asynch_io
boolean
TRUE


Version 8.1.7.4 database and RMAN catalog - 32 bit

Networker MML 
Using RAID 1+0 
Solaris 2.8 

-Original Message- 
From: Stankus, Paula G 
Sent: Tuesday, June 03, 2003 8:28
PM 
To: Stankus, Paula G;
'[EMAIL PROTECTED]' 
Subject: RE: Good technical
documents/references on tuning restores 



Okay - from my reading you don't need to have multiple
tape io slaves if you are using asynch. I/O. Again, best document for
perf. tuning database restores using RMAN would make mucho difference.
Read old note about someone doing an analyze on the RMAN catalog tables to
improve performance of restore. I think it has something to do with how
quickly it finds the file on tape and writes to disk. 

-Original Message- 
From: Stankus, Paula G 
Sent: Tuesday, June 03, 2003 8:25
PM 
To: '[EMAIL PROTECTED]'

Subject: RE: Good technical
documents/references on tuning restores 



Seems to be taking awfully long to read files from
tape and write to disk. I allocate multiple tape channels like I do for
the backup which only takes about 45 minutes. Does not seem to be
spawning multiple sessions. Do I need to change parameters on my init.ora
file to use multiple tape io slaves to see this. Anyway, would like
notes/docs., references if you all have some.

Thanks,

Re: Snapshot too old during stress test... how to avoid

2003-06-05 Thread Garry Gillies

From memory (of a course attended looong ago),
Oracle recommends one rollback segment for every
three to four users.
Four rollback segments between thirty six processes
does seem a little mean.

Garry 





[EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
04/06/03 13:59
Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc: 
Subject:Snapshot too old during stress test... how to avoid


Im testing worst case scenarios right now. So Im doing batch 
updates,inserts,deletes and 'create table as' from a staging tablespace of 
approximately 5GBs to a master tablespace of approximately 11GBs.

Ive got my job queue processes set to 36 and Im running 36 at a time in 
the background in order to gather statistics and timing under worst case 
scenarios. 

Im in 8.1.7.3 and I have increased the size of my RBS tablespace to 11GB 
for this test. I have 4 standard RBS with optimal size set to 1GB. Why 
would I get a snapshot too old? I would think that 11GBs of rollback would 
be big enough. Would increasing the number of Rollback segments avoid this 
even though I have the same amount of space in the tablespace? 

In reality Im going to seriallize the process to avoid this and to improve 
performance, however, I want to stress the system.

any advice? 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: [EMAIL PROTECTED]
  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-Mail message
to: [EMAIL PROTECTED] (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).




-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Garry Gillies
  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-Mail message
to: [EMAIL PROTECTED] (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).

RE: Shite of the day

Lisa,

Did you do the upgrade manually or via the GUI?  I'm interested because I'm 
looking forward to 20 upgrades several of which will have to be done in place as their 
too big otherwise.

Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA 

-Original Message-
Sent: Wednesday, June 04, 2003 10:40 AM
To: Multiple recipients of list ORACLE-L


Oh-My-Gosh.  

Worry free?  I just upgraded another 8.1.7.4 database to 9.2.  When I set the 
COMPATIBLE parm to 9.0.2 (or 9.2, which would make sense) I get really messy errors:

ORA-00402: database changes by release 9.0.1.3.0 cannot be used by release
135294976

ORA-01571: redo version 9.0.2.0.0 incompatible with ORACLE version 8.1.7.0.0

So then I tried to set it back to 8.1.7, or comment out COMPATIBLE altogether, and I 
get the same type of error.  It won't open at all. 

I tried initiating recovery.  This database is in noarc mode.  It starts looking for 
arclogs that *do not* exist.  I also tried to drop the redo log groups and recreate 
them.  Still, no dice. 

Again, unbreakable my FUNDAMENT.

So has anyone seen this before?  I opened a tar yesterday and promptly confused 
support. 

Lisa



-Original Message-
Sent: Wednesday, June 04, 2003 7:45 AM
To: Multiple recipients of list ORACLE-L


Trade SQL Server for Oracle9i Database and get up to 100% license credit 
and peace of mind.

Tired of applying patches? Frustrated with managing mulitple database servers? 
In the time it takes you to apply all Microsoft's patches to your servers, 
you can successfully migrate your database to Oracle9i Database and be 
worry-free. 


From 
http://www.oracle.com/start/linuxsqlserver/intro.html?src=1764462Act=16


I don't understand PR of Oracle. The RDBMS has so much properties which are 
much more better implemented in Oracle than in MS SQL and they choose 
'patching' which *** on both servers.

JP

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jan Pruner
  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-Mail message
to: [EMAIL PROTECTED] (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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Koivu, Lisa
  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-Mail message
to: [EMAIL PROTECTED] (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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Goulet, Dick
  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-Mail message
to: [EMAIL PROTECTED] (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).

RE: passing ref cursor on a procedure

Title: passing ref cursor on a procedure









Oops



Its supposed to be:



Variable lCursor REFCURSOR;



Not: declare lCursor REFCURSOR;





Igor Neyman, OCP DBA

[EMAIL PROTECTED]







-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Igor
Neyman
Sent: Wednesday, June 04, 2003
9:40 AM
To: Multiple recipients of list
ORACLE-L
Subject: RE: passing ref cursor on
a procedure



If in SQL*Plus:



Just declare variable of
REFCURSOR type and pass it to stored procedure:



DECLARE lCursor
REFCURSOR;

Begin

procedure_name(par1,
par2, , :lCursor);

end;

/





Igor Neyman, OCP
DBA

[EMAIL PROTECTED]







-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Hatzistavrou
John
Sent: Wednesday, June 04, 2003
8:40 AM
To: Multiple recipients of list
ORACLE-L
Subject: passing ref cursor on a
procedure



Dear All,

I have a vendor procedure which I wish to run .
This
procedure takes as input variables a varchar and a ref_cursor.

I know the query that is related to the ref_cursor
and I wish to implicitly pass it to the procedure . How can this be
done?

Kind Regards,



Hatzistavrou Yannis

RE: Sum of Previous Record

2003-06-05 Thread Walid Alkaakati


 Hi ,

Iam looking on how to solve this in a report  ,,,



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Walid Alkaakati
  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-Mail message
to: [EMAIL PROTECTED] (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).

RE: Good technical documents/references on tuning restores

2003-06-05 Thread Clarkson, Timothy T SEOP-OEIRH/1

Title: RE: Good technical documents/references on tuning restores



I had 
this problem yesterday. not sure if what I did is correct but it seemed to 
work for me.

1) 
Create another tablespace (TEST)
2) 
move the objects from the tablespace that has the missing files into TEST 
tablespace
 select DISTINCT 
TABLESPACE_NAME from dba_extents where file_id 
in 

 
(select File# from v$datafile where status 
= 'RECOVER')

you 
might have some problems with items that resided on the missing datafile, in my 
case it was only indexes so I recreated them from the schema on the new 
tablespace.

 select DISTINCT SEGMENT_NAME, SEGMENT_TYPE, 
TABLESPACE_NAME from dba_extents where file_id 
in 
 
(select File# from v$datafile where status 
= 'RECOVER')
3) 
drop the tablespace with missing datafiles
4) 
move back the objects to the original tablespace

This 
cleared up the mess in the v$datafile. I did this because I was under the 
impression that you cannot delete a datafile once it has been assigned to 
tablespace.


Have 
not got around to missing the missing file in the TEMP space yet, as it is a 
test database will do that later.

Hope 
this helps, I am sure someone will post a better answer soon 
:-)

Tim 
Clarkson

  -Original MessageFrom: Henry Poras 
  [mailto:[EMAIL PROTECTED]Sent: Wednesday, June 04, 2003 3:10 
  PMTo: Multiple recipients of list ORACLE-LSubject: RE: 
  Good technical documents/references on tuning restores
  Paula,
  
  IIRC 
  'MISSING' means it is in the data dictionary, but not the control file. I've 
  gotten that before, but haven't played that game in a while. You might be able 
  to 'DROP' them, but I'm not sure. Check that first on a mini-test 
  system.
  
  Henry
  
  
-Original Message-From: [EMAIL PROTECTED] 
[mailto:[EMAIL PROTECTED]On Behalf Of 
[EMAIL PROTECTED]Sent: Tuesday, June 03, 2003 
11:05 PMTo: Multiple recipients of list 
ORACLE-LSubject: RE: Good technical documents/references on 
tuning restores
Okay, 

Database open and I wanted to not restore and not reference certain 
index and materia. view datafiles. Now the datafiles show up with 
weird MISSING.. names. How do I clean this up?

Thanks,
paula

  -Original Message-From: 
  [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]Sent: Tuesday, June 03, 
  2003 10:20 PMTo: Multiple recipients of list 
  ORACLE-LSubject: RE: Good technical documents/references on 
  tuning restores
  Strange: 
  looking at v$backup_async_io found some datafiles 
  where  active bytes per sec 
   long-waits  
  2154608  
   
   297 
   
  7489829 
   
   
   297 
  How can I start finding the disparity? 
  -Original Message- From: 
  Stankus, Paula G Sent: Tuesday, June 03, 2003 9:05 
  PM To: Stankus, Paula G; 
  '[EMAIL PROTECTED]' Subject: RE: Good technical 
  documents/references on tuning restores 
  Did I say that throughout this restore/recovery process my 
  tapes being mounted and unmounted while other database backups and cloning 
  was occurring. Big duh - this has got to be slowing down the 
  process. Any ideas on how to handle this? Perhaps more than 
  one tape subsystem would be better or while doing restores other backup 
  utility is halted - hmmm - but that risks those other systems? How 
  can I sell that? H. Maybe I will first backup to 
  disk. Yep, one backup to disk. Yep.
  -Original Message- From: 
  Stankus, Paula G Sent: Tuesday, June 03, 2003 9:00 
  PM To: Stankus, Paula G; 
  '[EMAIL PROTECTED]' Subject: RE: Good technical 
  documents/references on tuning restores 
  See nwadmin shows parellism = 32. I am not the tape 
  person - that is my sys admin. I don't believe they actually have 32 
  tapes involved only 4. Can this impact performance by setting this 
  too high? I also notice one backup server for networker with nwadmin 
  messages like "clone sets being created...", "other databases being backed 
  up". What is the usual policy on concurrently running backups, 
  cloning at the same time recovery is taking place. It appears to 
  show a lot of media waiting events: waiting for dlt7000 tape ... of 
  the tapes that I specifically need for this restore. Did I 
  say: I love my admin...I love my adminI love my 
  admin...
  -Original Message- From: 
  Stankus, Paula G Sent: Tuesday, June 03, 2003 8:53 
  PM To: Stankus, Paula G; 
  '[EMAIL PROTECTED]' Subject: RE: Good technical 
  documents/references on tuning restores 
  Okay, almost 4 minutes for a datafile that was 78168 
  blocks - how do I know if this is reasonable? 
  Also, seems to write these files out (restore sychron.) 
  why can't it restore different datafiles in parallel? - stupid

RE: Shite of the day

2003-06-05 Thread Wolfe Stephen S GS-11 6 MDSS/SGSI

I agree with you Lisa ... g,

I don't understand the PR ...

v/r

Stephen S. Wolfe, GS-11, DAFC
Data Services Manager
[EMAIL PROTECTED]
(813) 827-9974  DSN 651-9974



 -Original Message-
 From: Koivu, Lisa [mailto:[EMAIL PROTECTED] 
 Sent: Wednesday, June 04, 2003 10:40 AM
 To: Multiple recipients of list ORACLE-L
 Subject: FW: Shite of the day
 
 
 Oh-My-Gosh.  
 
 Worry free?  I just upgraded another 8.1.7.4 database to 9.2. 
  When I set the COMPATIBLE parm to 9.0.2 (or 9.2, which would 
 make sense) I get really messy errors:
 
 ORA-00402: database changes by release 9.0.1.3.0 cannot be 
 used by release 135294976
 
 ORA-01571: redo version 9.0.2.0.0 incompatible with ORACLE 
 version 8.1.7.0.0
 
 So then I tried to set it back to 8.1.7, or comment out 
 COMPATIBLE altogether, and I get the same type of error.  It 
 won't open at all. 
 
 I tried initiating recovery.  This database is in noarc mode. 
  It starts looking for arclogs that *do not* exist.  I also 
 tried to drop the redo log groups and recreate them.  Still, no dice. 
 
 Again, unbreakable my FUNDAMENT.
 
 So has anyone seen this before?  I opened a tar yesterday and 
 promptly confused support. 
 
 Lisa
 
 
 
 -Original Message-
 Sent: Wednesday, June 04, 2003 7:45 AM
 To: Multiple recipients of list ORACLE-L
 
 
 Trade SQL Server for Oracle9i Database and get up to 100% 
 license credit 
 and peace of mind.
 
 Tired of applying patches? Frustrated with managing mulitple 
 database servers? 
 In the time it takes you to apply all Microsoft's patches to 
 your servers, 
 you can successfully migrate your database to Oracle9i 
 Database and be 
 worry-free. 
 
 
 From 
 http://www.oracle.com/start/linuxsqlserver/intro.html?src=1764
 462Act=16
 
 
 I don't understand PR of Oracle. The RDBMS has so much 
 properties which are 
 much more better implemented in Oracle than in MS SQL and they choose 
 'patching' which *** on both servers.
 
 JP
 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 -- 
 Author: Jan Pruner
   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-Mail message
 to: [EMAIL PROTECTED] (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).
 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 -- 
 Author: Koivu, Lisa
   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-Mail message
 to: [EMAIL PROTECTED] (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).
 
 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Wolfe Stephen S GS-11 6 MDSS/SGSI
  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-Mail message
to: [EMAIL PROTECTED] (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).

RE: Sum of Previous Record

2003-06-05 Thread Gogala, Mladen

How about 
SELECT DEBIT,CREDIT,CREDIT-DEBIT 
FROM WHATEVER_THE_TABLE
WHERE CREDIT*CREDIT=-1;

Mladen Gogala
Oracle DBA
Phone:(203) 459-6855
Email:[EMAIL PROTECTED]


-Original Message-
Sent: Wednesday, June 04, 2003 9:10 AM
To: Multiple recipients of list ORACLE-L




Hi list ,

Can you help me please .

I have  a report  that show   data as follows :

debit credit   balance
30-3
 0   -1 2
 1  0  3

Is their a way to get   balance  without using  a separet   query in a
formula column,i .e i need  the value  of the previous
record   in the same repeating frame.

Thanks


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Walid Alkaakati
  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-Mail message
to: [EMAIL PROTECTED] (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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Gogala, Mladen
  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-Mail message
to: [EMAIL PROTECTED] (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).

RE: Good technical documents/references on tuning restores

Title: RE: Good technical documents/references on tuning restores



Sometimes it just helps to "talk" it all out. Virtually or 
otherwise. 

April Wells Oracle DBA/Oracle Apps DBA Corporate Systems Amarillo Texas 
You will recognize your own path when you 
come upon it, because you will suddenly have all the energy and imagination you 
will ever need.
~ Jerry Gillies ~ 

  -Original Message-From: Igor Neyman 
  [mailto:[EMAIL PROTECTED]Sent: Wednesday, June 04, 2003 9:30 
  AMTo: Multiple recipients of list ORACLE-LSubject: RE: 
  Good technical documents/references on tuning restores
  
  Paula,
  
  It was very 
  entertaining to read this thread -J
  Did you answer all 
  your questions?-J
  
  
  Igor Neyman, OCP DBA
  [EMAIL PROTECTED]
  
  
  -Original 
  Message-From: 
  [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of 
  [EMAIL PROTECTED]Sent: Tuesday, June 03, 2003 9:05 
  PMTo: Multiple recipients of 
  list ORACLE-LSubject: RE: 
  Good technical documents/references on tuning restores
  
  Did I say that throughout this restore/recovery 
  process my tapes being mounted and unmounted while other database backups and 
  cloning was occurring. Big duh - this has got to be slowing down the 
  process. Any ideas on how to handle this? Perhaps more than one 
  tape subsystem would be better or while doing restores other backup utility is 
  halted - hmmm - but that risks those other systems? How can I sell 
  that? H. Maybe I will first backup to disk. Yep, one 
  backup to disk. Yep.
  -Original Message- From: Stankus, Paula G 
  Sent: Tuesday, 
  June 03, 2003 9:00 PM To: Stankus, Paula G; 
  '[EMAIL PROTECTED]' Subject: RE: Good technical documents/references on 
  tuning restores 
  
  See nwadmin shows parellism = 32. I am not the 
  tape person - that is my sys admin. I don't believe they actually have 
  32 tapes involved only 4. Can this impact performance by setting this 
  too high? I also notice one backup server for networker with nwadmin 
  messages like "clone sets being created...", "other databases being backed 
  up". What is the usual policy on concurrently running backups, cloning 
  at the same time recovery is taking place. It appears to show a lot of 
  media waiting events: waiting for dlt7000 tape ... of the tapes that I 
  specifically need for this restore. Did I say: I love my admin...I 
  love my adminI love my admin...
  -Original Message- From: Stankus, Paula G 
  Sent: Tuesday, 
  June 03, 2003 8:53 PM To: Stankus, Paula G; 
  '[EMAIL PROTECTED]' Subject: RE: Good technical documents/references on 
  tuning restores 
  
  Okay, almost 4 minutes for a datafile that was 78168 
  blocks - how do I know if this is reasonable? 
  Also, seems to write these files out (restore 
  sychron.) why can't it restore different datafiles in parallel? - stupid 
  question huh?
  -Original Message- From: Stankus, Paula G 
  Sent: Tuesday, 
  June 03, 2003 8:46 PM To: Stankus, Paula G; 
  '[EMAIL PROTECTED]' Subject: RE: Good technical documents/references on 
  tuning restores 
  
  SELECT SID, SERIAL#, 
  CONTEXT, 
  ROUND(SOFAR/TOTALWORK*100,2) "% 
  complete", 
  SUBSTR(TO_CHAR(SYSDATE,'HH24:MI:SS'),1,15) "Time 
  now" FROM 
  V$SESSION_LONGOPS 
  WHERE OPNAME like 
  '%restore%'; 
  . 
  showed all 100% 
  complete but msglog from RMAN shows it is truly still running. 
  
  -Original Message- From: Stankus, Paula G 
  Sent: Tuesday, 
  June 03, 2003 8:40 PM To: Stankus, Paula G; 
  '[EMAIL PROTECTED]' Subject: RE: Good technical documents/references on 
  tuning restores 
  
  Also found on monitoring performance of RMAN 
  jobs: Note:144640.1 on Metalink 
  -Original Message- From: Stankus, Paula G 
  Sent: Tuesday, 
  June 03, 2003 8:36 PM To: Stankus, Paula G; 
  '[EMAIL PROTECTED]' Subject: RE: Good technical documents/references on 
  tuning restores 
  
  Found this white paper: 
  http://otn.oracle.com/deploy/availability/pdf/rman_performance_wp.pdf 
  
  Anything better? 
  -Original Message- From: Stankus, Paula G 
  Sent: Tuesday, 
  June 03, 2003 8:33 PM To: Stankus, Paula G; 
  '[EMAIL PROTECTED]' Subject: RE: Good technical documents/references on 
  tuning restores 
  
  This is what I have set on my target 
  database: 
  --- --- 
  --- backup_tape_io_slaves 
  boolean 
  FALSE 
  tape_asynch_io 
  boolean 
  TRUE 
  
  Version 8.1.7.4 database and RMAN catalog - 32 
  bit Networker 
  MML Using RAID 
  1+0 Solaris 
  2.8 
  -Original Message- From: Stankus, Paula G 
  Sent: Tuesday, 
  June 03, 2003 8:28 PM To: Stankus, Paula G; 
  '[EMAIL PROTECTED]' Subject: RE: Good technical documents/references on 
  tuning restores 
  
  Okay - from my reading you don't need to have multiple 
  tape io slaves if you are using asynch. I/O. Again, best document for 
  perf. tuning database restores using RMAN would make mucho

??? Linux/Oracle 8.1.7 2GB file size limit ???

I've just been informed that there is a 2GB datafile size limit with Oracle 8.1.7 on 
Linux... PERIOD. This despite the fact that we've had files in excess of this for some 
time and they work just fine. The problem occurs when the autoextend feature reaches 
the 2GB threshhold. Of course, Oracle didn't tell me this until after about 4 days of 
back and forth testing for them. (There is no such O/S file size limit.) I've reviewed 
the Linux release notes, the Linux install guide, the Linux admin guide and the 
contents of $ORACLE_HOME/relnotes and I don't find any such limitation in the 
documentation. Did I miss it? Can anyone find any such published limitation in the 
docs? Is this a secret? 


Peeved at Oracle... AGAIN,
Steve Orr
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Orr, Steve
  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-Mail message
to: [EMAIL PROTECTED] (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).

Re: Good technical documents/references on tuning restores

Title: RE: Good technical documents/references on tuning restores



Paula,
Have you tried backing up your controlfile to 
trace, editing the trace file to get rid of the unwanted datafiles, and 
reopening the database with the new edited controlfile? That should get 
rid of them. Of course, to a backup immediately after this.

Good luck,
Ruth

  - Original Message - 
  From: 
  Henry Poras 
  
  To: Multiple recipients of list ORACLE-L 
  
  Sent: Wednesday, June 04, 2003 10:09 
  AM
  Subject: RE: Good technical 
  documents/references on tuning restores
  
  Paula,
  
  IIRC 
  'MISSING' means it is in the data dictionary, but not the control file. I've 
  gotten that before, but haven't played that game in a while. You might be able 
  to 'DROP' them, but I'm not sure. Check that first on a mini-test 
  system.
  
  Henry
  
  
-Original Message-From: [EMAIL PROTECTED] 
[mailto:[EMAIL PROTECTED]On Behalf Of 
[EMAIL PROTECTED]Sent: Tuesday, June 03, 2003 
11:05 PMTo: Multiple recipients of list 
ORACLE-LSubject: RE: Good technical documents/references on 
tuning restores
Okay, 

Database open and I wanted to not restore and not reference certain 
index and materia. view datafiles. Now the datafiles show up with 
weird MISSING.. names. How do I clean this up?

Thanks,
paula

  -Original Message-From: 
  [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]Sent: Tuesday, June 03, 
  2003 10:20 PMTo: Multiple recipients of list 
  ORACLE-LSubject: RE: Good technical documents/references on 
  tuning restores
  Strange: 
  looking at v$backup_async_io found some datafiles 
  where  active bytes per sec 
   long-waits  
  2154608  
   
   297 
   
  7489829 
   
   
   297 
  How can I start finding the disparity? 
  -Original Message- From: 
  Stankus, Paula G Sent: Tuesday, June 03, 2003 9:05 
  PM To: Stankus, Paula G; 
  '[EMAIL PROTECTED]' Subject: RE: Good technical 
  documents/references on tuning restores 
  Did I say that throughout this restore/recovery process my 
  tapes being mounted and unmounted while other database backups and cloning 
  was occurring. Big duh - this has got to be slowing down the 
  process. Any ideas on how to handle this? Perhaps more than 
  one tape subsystem would be better or while doing restores other backup 
  utility is halted - hmmm - but that risks those other systems? How 
  can I sell that? H. Maybe I will first backup to 
  disk. Yep, one backup to disk. Yep.
  -Original Message- From: 
  Stankus, Paula G Sent: Tuesday, June 03, 2003 9:00 
  PM To: Stankus, Paula G; 
  '[EMAIL PROTECTED]' Subject: RE: Good technical 
  documents/references on tuning restores 
  See nwadmin shows parellism = 32. I am not the tape 
  person - that is my sys admin. I don't believe they actually have 32 
  tapes involved only 4. Can this impact performance by setting this 
  too high? I also notice one backup server for networker with nwadmin 
  messages like "clone sets being created...", "other databases being backed 
  up". What is the usual policy on concurrently running backups, 
  cloning at the same time recovery is taking place. It appears to 
  show a lot of media waiting events: waiting for dlt7000 tape ... of 
  the tapes that I specifically need for this restore. Did I 
  say: I love my admin...I love my adminI love my 
  admin...
  -Original Message- From: 
  Stankus, Paula G Sent: Tuesday, June 03, 2003 8:53 
  PM To: Stankus, Paula G; 
  '[EMAIL PROTECTED]' Subject: RE: Good technical 
  documents/references on tuning restores 
  Okay, almost 4 minutes for a datafile that was 78168 
  blocks - how do I know if this is reasonable? 
  Also, seems to write these files out (restore sychron.) 
  why can't it restore different datafiles in parallel? - stupid 
  question huh?
  -Original Message- From: 
  Stankus, Paula G Sent: Tuesday, June 03, 2003 8:46 
  PM To: Stankus, Paula G; 
  '[EMAIL PROTECTED]' Subject: RE: Good technical 
  documents/references on tuning restores 
  SELECT SID, SERIAL#, 
  CONTEXT, 
  ROUND(SOFAR/TOTALWORK*100,2) "% 
  complete", 
  SUBSTR(TO_CHAR(SYSDATE,'HH24:MI:SS'),1,15) "Time 
  now" FROM 
  V$SESSION_LONGOPS 
  WHERE OPNAME like 
  '%restore%'; 
  . 
  showed all 100% complete but msglog from RMAN 
  shows it is truly still running. 
  -Original Message- From: 
  Stankus, Paula G Sent: Tuesday, June 03, 2003 8:40 
  PM To: Stankus, Paula G; 
  '[EMAIL PROTECTED]' Subject: RE: Good technical 
  documents/references on tuning restores 
  Also found on monitoring performance of RMAN jobs:

RE: passing ref cursor on a procedure

2003-06-05 Thread Regis Biassala

Title: passing ref cursor on a procedure



example

  -Original Message-From: Hatzistavrou John 
  [mailto:[EMAIL PROTECTED]Sent: Wednesday, June 
  04, 2003 2:40 PMTo: Multiple recipients of list 
  ORACLE-LSubject: passing ref cursor on a 
  procedure
  Dear All,
  I have a vendor 
  procedure which I wish to run . This procedure takes as input variables a varchar and a 
  ref_cursor.
  I know the query that 
  is related to the ref_cursor and I wish to implicitly pass it to the procedure 
  . How can this 
  be done?
  Kind Regards,
  Hatzistavrou Yannis
  

*

This electronic transmission is strictly confidential and intended solely

for the addressee. It may contain information which is covered by legal,

professional or other privilege. If you are not the intended addressee,

you must not disclose, copy or take any action in reliance of this

transmission. If you have received this transmission in error, 

please notify the sender as soon as possible.


This footnote also confirms that this message has been swept

for computer viruses.

**

RE: Quick Question of APPS DBA

2003-06-05 Thread John Clarke

Or $AR_TOP/$APPLLOG, if $APPLCSF is unset.  If $APPLCSF is set, $APPLCSF/$APPLLOG.

- John

-Original Message- 
From: Nelson, Allan [mailto:[EMAIL PROTECTED] 
Sent: Wed 6/4/2003 10:50 AM 
To: Multiple recipients of list ORACLE-L 
Cc: 
Subject: RE: Quick Question of APPS DBA

If this is a regular CONCSUB job and your stuff is in default spots then
look at $APPL_TOP/admin/your instance/log

Allan

-Original Message-
Sent: Tuesday, June 03, 2003 10:00 PM
To: Multiple recipients of list ORACLE-L

Any APPS DBAs out there?

I need to know where to find the argltp log file. (AR to GL transfer
process log file)

Thanks.

=)

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Maria Aurora de la Vega
  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-Mail message
to: [EMAIL PROTECTED] (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).

__
This email is intended solely for the person or entity to which it is 
addressed and may contain confidential and/or privileged information.  Copying, 
forwarding or distributing this message by persons or entities other than the 
addressee is prohibited. If you have received this email in error, please contact the 
sender immediately and delete the material from any computer.  This email may have 
been monitored for policy compliance.  [021216]

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Nelson, Allan
  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-Mail message
to: [EMAIL PROTECTED] (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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: John Clarke
  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-Mail message
to: [EMAIL PROTECTED] (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).

RE: Sum of Previous Record

2003-06-05 Thread Pardee, Roy E

Depending on the structure of your table, you can also use plain SQL with a
self-join, similar to:

  select v1.cust_id
, v1.order_date
, v1.order_total
, sum(v2.order_total) cumulative_total
  from orders v1
 , orders v2
  where v1.cust_id = v2.cust_id AND
v2.order_date = v1.order_date
  group by v1.cust_id, v1.order_date, v1.order_total ;

Cheers,

-Roy

Roy Pardee
Programmer/Analyst/DBA
SWFPAC Lockheed Martin IT
Extension 8487

-Original Message-
Sent: Wednesday, June 04, 2003 8:05 AM
To: Multiple recipients of list ORACLE-L


Walid

You can use SUM as an analytic function like this: -

SQL select credit, debit, sum(credit + debit) over (order by rowid) from
foo;

CREDIT  DEBIT SUM(CREDIT+DEBIT)OVER(ORDERBYROWID)
-- -- ---
 3  0   3
 0 -1   2
 1  0   3

Obviously, you will need to order by something more sensible than the rowid
(perhaps a timestamp).

 -Original Message-
 From: Walid Alkaakati [mailto:[EMAIL PROTECTED]
 Sent: 04 June 2003 14:10
 To: Multiple recipients of list ORACLE-L
 Subject: Sum of Previous Record
 
 
 
 
 Hi list ,
 
 Can you help me please .
 
 I have  a report  that show   data as follows :
 
 debit credit   balance
 30-3
  0   -1 2
  1  0  3
 
 Is their a way to get   balance  without using  a separet   query in a
 formula column,i .e i need  the value  of the previous
 record   in the same repeating frame.
 
 Thanks
 
 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 -- 
 Author: Walid Alkaakati
   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-Mail message
 to: [EMAIL PROTECTED] (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).
 


**
This message (including any attachments) is confidential and may be 
legally privileged.  If you are not the intended recipient, you should 
not disclose, copy or use any part of it - please delete all copies 
immediately and notify the Hays Group Email Helpdesk at
[EMAIL PROTECTED]
Any information, statements or opinions contained in this message
(including any attachments) are given by the author.  They are not 
given on behalf of Hays unless subsequently confirmed by an individual
other than the author who is duly authorised to represent Hays.
 
A member of the Hays plc group of companies.
Hays plc is registered in England and Wales number 2150950.
Registered Office Hays House Millmead Guildford Surrey GU2 4HJ.
**

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Lord, David - CSG
  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-Mail message
to: [EMAIL PROTECTED] (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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Pardee, Roy E
  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-Mail message
to: [EMAIL PROTECTED] (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).

RE: Good technical documents/references on tuning restores

Paula,
Was the tablespace read-only? 
Those weired MISSING... names refer to data files in those tablspaces. 
Do you have a controlfile trace? Look in there to see what is what.. 
Here is what I see in the CF trace for my read-only tablespace:

# Files in read-only tablespaces are now named.
ALTER DATABASE RENAME FILE 'MISSING2'
  TO '/u07/oradata/DBCT/test_01.dbf';
# Online the files in read-only tablespaces.
ALTER TABLESPACE TEST ONLINE;
# No tempfile entries found to add.
#

HTH,

- Kirti 

--- Henry Poras [EMAIL PROTECTED] wrote:
 RE: Good technical documents/references on tuning restoresPaula,
 
 IIRC 'MISSING' means it is in the data dictionary, but not the control file.
 I've gotten that before, but haven't played that game in a while. You might
 be able to 'DROP' them, but I'm not sure. Check that first on a mini-test
 system.
 
 Henry
 
   -Original Message-
   From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of
 [EMAIL PROTECTED]
   Sent: Tuesday, June 03, 2003 11:05 PM
   To: Multiple recipients of list ORACLE-L
   Subject: RE: Good technical documents/references on tuning restores
 
 
   Okay,
 
   Database open and I wanted to not restore and not reference certain index
 and materia. view datafiles.  Now the datafiles show up with weird
 MISSING.. names.  How do I clean this up?
 
   Thanks,
   paula


__
Do you Yahoo!?
Yahoo! Calendar - Free online calendar with sync to Outlook(TM).
http://calendar.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Kirtikumar Deshpande
  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-Mail message
to: [EMAIL PROTECTED] (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).

RE: passing ref cursor on a procedure

2003-06-05 Thread Hatzistavrou John

Title: passing ref cursor on a procedure









Example



Package ll is

Type lrec is record(

? A ?integer,

? B? varchar2(72));



Type lrectype is REF CURSOR return lrec;



Procedure getl( par1 in varchar2,

?? Xcursor IN OUT lrectype);



End;



Now ,



HOW do I execute procedure getl from sqlplus? 





Kind Regards, 



Hatzistavrou Yannis 
?



-Original
Message-
From: Regis Biassala
[mailto:[EMAIL PROTECTED] 
Sent: Wednesday,
 June 04, 2003 6:05
 PM
To: Multiple recipients of list
ORACLE-L
Subject: RE: passing ref cursor on
a procedure





example





-Original Message-
From: Hatzistavrou John
[mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 04, 2003
2:40 PM
To: Multiple recipients of list
ORACLE-L
Subject: passing ref cursor on a
procedure

Dear
All,

I have a vendor procedure which I
wish to run . This procedure
takes as input variables a varchar and a ref_cursor.

I know the query that is related to
the ref_cursor and I wish to implicitly pass it to the procedure . How can this be done?

Kind Regards,



Hatzistavrou Yannis








*

This electronic transmission is strictly confidential and intended solely

for the addressee. It may contain information which is covered by legal,

professional or other privilege. If you are not the intended addressee,

you must not disclose, copy or take any action in reliance of this

transmission. If you have received this transmission in error, 

please notify the sender as soon as possible.


This footnote also confirms that this message has been swept

for computer viruses.

**

Re: Snapshot too old during stress test... how to avoid

Try removing optimal setting, and shrinking RBS to the min extents (or even below) 
before running
your tests. 

- Kirti 


--- Garry Gillies [EMAIL PROTECTED] wrote:
 From memory (of a course attended looong ago),
 Oracle recommends one rollback segment for every
 three to four users.
 Four rollback segments between thirty six processes
 does seem a little mean.
 
 Garry 
 
 
 
 
 
 [EMAIL PROTECTED]
 Sent by: [EMAIL PROTECTED]
 04/06/03 13:59
 Please respond to ORACLE-L
 
  
 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
 cc: 
 Subject:Snapshot too old during stress test... how to avoid
 
 
 Im testing worst case scenarios right now. So Im doing batch 
 updates,inserts,deletes and 'create table as' from a staging tablespace of 
 approximately 5GBs to a master tablespace of approximately 11GBs.
 
 Ive got my job queue processes set to 36 and Im running 36 at a time in 
 the background in order to gather statistics and timing under worst case 
 scenarios. 
 
 Im in 8.1.7.3 and I have increased the size of my RBS tablespace to 11GB 
 for this test. I have 4 standard RBS with optimal size set to 1GB. Why 
 would I get a snapshot too old? I would think that 11GBs of rollback would 
 be big enough. Would increasing the number of Rollback segments avoid this 
 even though I have the same amount of space in the tablespace? 
 
 In reality Im going to seriallize the process to avoid this and to improve 
 performance, however, I want to stress the system.
 
 any advice? 
 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 -- 
 Author: [EMAIL PROTECTED]
   INET: [EMAIL PROTECTED]
 
 


__
Do you Yahoo!?
Yahoo! Calendar - Free online calendar with sync to Outlook(TM).
http://calendar.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Kirtikumar Deshpande
  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-Mail message
to: [EMAIL PROTECTED] (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).

RE: Good technical documents/references on tuning restores

2003-06-05 Thread Jose Luis Delgado

--- Igor Neyman [EMAIL PROTECTED] wrote:
 Paula,
 
 It was very entertaining to read this thread -:-)
 
 Did you answer all your questions?-:-)
 

I agree with Igor! ;-)

well, Paula...

you have MISSING datafiles because they are registered
on your data dictionary and they were not included in
your backup controlfile file at the moment of
recreating the control file.

You can, re-attempt:
alter database backup controlfile to trace

include ALL you datafiles (name and path)...
and then... you can drop, rename or whatever you want!

HTH
JL


 Igor Neyman, OCP DBA
 
 [EMAIL PROTECTED]
 
  
 
  
 
 -Original Message-
 [EMAIL PROTECTED]
 Sent: Tuesday, June 03, 2003 9:05 PM
 To: Multiple recipients of list ORACLE-L
 
  
 
 Did I say that throughout this restore/recovery
 process my tapes being
 mounted and unmounted while other database backups
 and cloning was
 occurring.  Big duh - this has got to be slowing
 down the process.  Any
 ideas on how to handle this?  Perhaps more than one
 tape subsystem would
 be better or while doing restores other backup
 utility is halted - hmmm
 - but that risks those other systems?  How can I
 sell that?  H.
 Maybe I will first backup to disk.  Yep, one backup
 to disk.  Yep.
 
 -Original Message- 
 Sent: Tuesday, June 03, 2003 9:00 PM 
 To: Stankus, Paula G; '[EMAIL PROTECTED]' 
 
  
 
 See nwadmin shows parellism = 32.  I am not the tape
 person - that is my
 sys admin.  I don't believe they actually have 32
 tapes involved only 4.
 Can this impact performance by setting this too
 high?  I also notice one
 backup server for networker with nwadmin messages
 like clone sets being
 created..., other databases being backed up. 
 What is the usual
 policy on concurrently running backups, cloning at
 the same time
 recovery is taking place.  It appears to show a lot
 of media waiting
 events:  waiting for dlt7000 tape ... of the tapes
 that I specifically
 need for this restore.  Did I say:  I love my
 admin...I love my
 adminI love my admin...
 
 -Original Message- 
 Sent: Tuesday, June 03, 2003 8:53 PM 
 To: Stankus, Paula G; '[EMAIL PROTECTED]' 
 
  
 
 Okay, almost 4 minutes for a datafile that was 78168
 blocks - how do I
 know if this is reasonable? 
 
 Also, seems to write these files out (restore
 sychron.) why can't it
 restore different datafiles in parallel?  - stupid
 question huh?
 
 -Original Message- 
 Sent: Tuesday, June 03, 2003 8:46 PM 
 To: Stankus, Paula G; '[EMAIL PROTECTED]' 
 
  
 
 SELECT SID, SERIAL#, CONTEXT,   
 
  ROUND(SOFAR/TOTALWORK*100,2) % complete, 
 
 SUBSTR(TO_CHAR(SYSDATE,'HH24:MI:SS'),1,15) Time
 now
 FROM V$SESSION_LONGOPS  
 
 WHERE OPNAME like '%restore%';  
 
 .   
 
 showed all 100% complete but msglog from RMAN shows
 it is truly still
 running.  
 
 -Original Message- 
 Sent: Tuesday, June 03, 2003 8:40 PM 
 To: Stankus, Paula G; '[EMAIL PROTECTED]' 
 
  
 
 Also found on monitoring performance of RMAN jobs: 
 Note:144640.1 on Metalink 
 
 -Original Message- 
 Sent: Tuesday, June 03, 2003 8:36 PM 
 To: Stankus, Paula G; '[EMAIL PROTECTED]' 
 
  
 
 Found this white paper: 
 

http://otn.oracle.com/deploy/availability/pdf/rman_performance_wp.pdf
 
 
 Anything better? 
 
 -Original Message- 
 Sent: Tuesday, June 03, 2003 8:33 PM 
 To: Stankus, Paula G; '[EMAIL PROTECTED]' 
 
  
 
 This is what I have set on my target database: 
 
 --- ---
 --- 
 backup_tape_io_slaves   boolean FALSE   
   
 tape_asynch_io  boolean TRUE
   
 
 Version 8.1.7.4 database and RMAN catalog - 32 bit 
 Networker MML 
 Using RAID 1+0 
 Solaris 2.8 
 
 -Original Message- 
 Sent: Tuesday, June 03, 2003 8:28 PM 
 To: Stankus, Paula G; '[EMAIL PROTECTED]' 
 
  
 
 Okay - from my reading you don't need to have
 multiple tape io slaves if
 you are using asynch. I/O.  Again, best document for
 perf. tuning
 database restores using RMAN would make mucho
 difference.  Read old note
 about someone doing an analyze on the RMAN catalog
 tables to improve
 performance of restore.  I think it has something to
 do with how quickly
 it finds the file on tape and writes to disk.  
 
 -Original Message- 
 Sent: Tuesday, June 03, 2003 8:25 PM 
 To: '[EMAIL PROTECTED]' 
 
  
 
 Seems to be taking awfully long to read files from
 tape and write to
 disk.  I allocate multiple tape channels like I do
 for the backup which
 only takes about 45 minutes.  Does not seem to be
 spawning multiple
 sessions.  Do I need to change parameters on my
 init.ora file to use
 multiple tape io slaves to see this. Anyway, would
 like notes/docs.,
 references if you all have some.
 
 Thanks, 
 Paula 
 
 


__
Do you Yahoo!?
Yahoo! Calendar

RE: Shite of the day

Hi Dick, 

This was a manual upgrade.  I sure hope your upgrades go better than mine have. 

Lisa

-Original Message-
Sent: Wednesday, June 04, 2003 11:35 AM
To: Multiple recipients of list ORACLE-L


Lisa,

Did you do the upgrade manually or via the GUI?  I'm interested because I'm 
looking forward to 20 upgrades several of which will have to be done in place as their 
too big otherwise.

Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA 

-Original Message-
Sent: Wednesday, June 04, 2003 10:40 AM
To: Multiple recipients of list ORACLE-L


Oh-My-Gosh.  

Worry free?  I just upgraded another 8.1.7.4 database to 9.2.  When I set the 
COMPATIBLE parm to 9.0.2 (or 9.2, which would make sense) I get really messy errors:

ORA-00402: database changes by release 9.0.1.3.0 cannot be used by release
135294976

ORA-01571: redo version 9.0.2.0.0 incompatible with ORACLE version 8.1.7.0.0

So then I tried to set it back to 8.1.7, or comment out COMPATIBLE altogether, and I 
get the same type of error.  It won't open at all. 

I tried initiating recovery.  This database is in noarc mode.  It starts looking for 
arclogs that *do not* exist.  I also tried to drop the redo log groups and recreate 
them.  Still, no dice. 

Again, unbreakable my FUNDAMENT.

So has anyone seen this before?  I opened a tar yesterday and promptly confused 
support. 

Lisa



-Original Message-
Sent: Wednesday, June 04, 2003 7:45 AM
To: Multiple recipients of list ORACLE-L


Trade SQL Server for Oracle9i Database and get up to 100% license credit 
and peace of mind.

Tired of applying patches? Frustrated with managing mulitple database servers? 
In the time it takes you to apply all Microsoft's patches to your servers, 
you can successfully migrate your database to Oracle9i Database and be 
worry-free. 


From 
http://www.oracle.com/start/linuxsqlserver/intro.html?src=1764462Act=16


I don't understand PR of Oracle. The RDBMS has so much properties which are 
much more better implemented in Oracle than in MS SQL and they choose 
'patching' which *** on both servers.

JP

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jan Pruner
  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-Mail message
to: [EMAIL PROTECTED] (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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Koivu, Lisa
  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-Mail message
to: [EMAIL PROTECTED] (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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Goulet, Dick
  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-Mail message
to: [EMAIL PROTECTED] (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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Koivu, Lisa
  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-Mail message
to: [EMAIL PROTECTED] (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).

AW: Interesting!

2003-06-05 Thread Stefan Jahnke

Hi

Possible scenario where it might make sense:

You want to hide some implementation from people that use your package.
Since, AFAIK PL/SQL doesn't have information hiding (private, protected,
public etc.),
this might be a way of not showing your private helper method's signature 
in your package declaration. 
And yes, I am aware of the fact that it only makes sense with procs, funcs
that 
you only want to use from within the scope of the proc/func you define them
in.
Otherwise you would end up with duplicate code.

Did I miss anything ?
Stefan

-Ursprüngliche Nachricht-
Von: Khedr, Waleed [mailto:[EMAIL PROTECTED]
Gesendet: Mittwoch, 4. Juni 2003 16:20
An: Multiple recipients of list ORACLE-L
Betreff: RE: Interesting!


I think it's good to have (forgive me Jared :)). 
It reminds me with Pascal language.

Waleed

-Original Message-
Sent: Tuesday, June 03, 2003 9:40 PM
To: Multiple recipients of list ORACLE-L


My first real PL/SQL program used this technique.  Of course since it was my
first program I ran into a very annoying variable scope issue.  Of course
after spending hours debugging the code, I realized I should have taken the
advice of our DBA, the infamous Jared Still, and just used a package.  I
have since looked askew at the nesting of procedures.  I can't remember the
actual error I encountered.  It probably had nothing or very little to do
with my nested procedures, but in my mind I can't consider this to be a good
practice.  A package does the same job, and so much cleaner.

P.S.  I think this was the first time I noted Jared's annoying habit of
being right


Steve McClure

-Original Message-
Waleed
Sent: Tuesday, June 03, 2003 4:10 PM
To: Multiple recipients of list ORACLE-L


I've just discovered this, never thought if it was possible or not.
Just wanted to share it with you, so forgive me if you know it already.
Procedure can contain other procedures:

create or replace procedure test_test1 as
procedure test_test2 as
begin
 dbms_output.put_line('hello2');
 end;
function c1 ( p1 in number) return number as
begin
 return(p1 * 2);
end;
begin
  dbms_output.put_line('hello1');
  test_test2;
  dbms_output.put_line( c1(10));
end;

Regards,

Waleed

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Khedr, Waleed
  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-Mail message
to: [EMAIL PROTECTED] (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).


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Steve McClure
  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-Mail message
to: [EMAIL PROTECTED] (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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Khedr, Waleed
  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-Mail message
to: [EMAIL PROTECTED] (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).


 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Stefan Jahnke
  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-Mail message
to: [EMAIL PROTECTED] (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).

Re: ??? Linux/Oracle 8.1.7 2GB file size limit ???

2003-06-05 Thread Jan Pruner

I think it is the limitation of Linux, not Oracle.
Use LVM and don't worry about file size limit. :-)

JP
- Original Message - 
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, June 04, 2003 5:40 PM


 I've just been informed that there is a 2GB datafile size limit with
Oracle 8.1.7 on Linux... PERIOD. This despite the fact that we've had files
in excess of this for some time and they work just fine. The problem occurs
when the autoextend feature reaches the 2GB threshhold. Of course, Oracle
didn't tell me this until after about 4 days of back and forth testing for
them. (There is no such O/S file size limit.) I've reviewed the Linux
release notes, the Linux install guide, the Linux admin guide and the
contents of $ORACLE_HOME/relnotes and I don't find any such limitation in
the documentation. Did I miss it? Can anyone find any such published
limitation in the docs? Is this a secret?


 Peeved at Oracle... AGAIN,
 Steve Orr
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 -- 
 Author: Orr, Steve
   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-Mail message
 to: [EMAIL PROTECTED] (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).


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jan Pruner
  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-Mail message
to: [EMAIL PROTECTED] (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).

RE: Good technical documents/references on tuning restores

Title: RE: Good technical documents/references on tuning restores



I had that problem in a 9.2.0.3 AIX4.3.3 to AIX 5L upgrade... missing 
with really weird names... if you look at your tablespace sizes, the ones that 
are 0 bytes are the ones that have the missing files. If you can figure 
out what files go with those tablespaces, shutdown the database, "fix" the 
create control file script so those files are in it (if those tablespaces and 
files are still valid in the database)... and startup nomount and run the script 
again... it will tell you that you have those datafiles needing media 
recovery. 

recover datafile 'fully qualified datafile 
name'

If the tablespaces and files aren't valid anymore, you can offline drop 
them and they won't be in the data dictionary OR in the control file... 



April Wells Oracle DBA/Oracle Apps DBA Corporate Systems Amarillo Texas 
You will recognize your own path when you 
come upon it, because you will suddenly have all the energy and imagination you 
will ever need.
~ Jerry Gillies ~ 

  -Original Message-From: Ruth Gramolini 
  [mailto:[EMAIL PROTECTED]Sent: Wednesday, June 04, 2003 
  11:05 AMTo: Multiple recipients of list ORACLE-LSubject: 
  Re: Good technical documents/references on tuning 
restores
  Paula,
  Have you tried backing up your controlfile to 
  trace, editing the trace file to get rid of the unwanted datafiles, and 
  reopening the database with the new edited controlfile? That should get 
  rid of them. Of course, to a backup immediately after this.
  
  Good luck,
  Ruth
  
- Original Message - 
From: 
Henry 
Poras 
To: Multiple recipients of list ORACLE-L 

Sent: Wednesday, June 04, 2003 10:09 
AM
Subject: RE: Good technical 
documents/references on tuning restores

Paula,

IIRC 'MISSING' means it is in the data dictionary, but not the 
control file. I've gotten that before, but haven't played that game in a 
while. You might be able to 'DROP' them, but I'm not sure. Check that first 
on a mini-test system.

Henry


  -Original Message-From: [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]On Behalf Of 
  [EMAIL PROTECTED]Sent: Tuesday, June 03, 2003 
  11:05 PMTo: Multiple recipients of list 
  ORACLE-LSubject: RE: Good technical documents/references on 
  tuning restores
  Okay, 
  
  Database open and I wanted to not restore and not reference certain 
  index and materia. view datafiles. Now the datafiles show up with 
  weird MISSING.. names. How do I clean this 
  up?
  
  Thanks,
  paula
  
-Original Message-From: 
[EMAIL PROTECTED] 
[mailto:[EMAIL PROTECTED]Sent: Tuesday, June 03, 
2003 10:20 PMTo: Multiple recipients of list 
ORACLE-LSubject: RE: Good technical documents/references on 
tuning restores
Strange: 
looking at v$backup_async_io found some datafiles 
where  active bytes per sec 
 long-waits  
2154608  
 
 297 
 
7489829 
 
 
 297 
How can I start finding the disparity? 
-Original Message- From: 
Stankus, Paula G Sent: Tuesday, June 03, 2003 
9:05 PM To: Stankus, Paula G; 
'[EMAIL PROTECTED]' Subject: RE: Good 
technical documents/references on tuning restores 
Did I say that throughout this restore/recovery process 
my tapes being mounted and unmounted while other database backups and 
cloning was occurring. Big duh - this has got to be slowing down 
the process. Any ideas on how to handle this? Perhaps more 
than one tape subsystem would be better or while doing restores other 
backup utility is halted - hmmm - but that risks those other 
systems? How can I sell that? H. Maybe I will 
first backup to disk. Yep, one backup to disk. 
Yep.
-Original Message- From: 
Stankus, Paula G Sent: Tuesday, June 03, 2003 
9:00 PM To: Stankus, Paula G; 
'[EMAIL PROTECTED]' Subject: RE: Good 
technical documents/references on tuning restores 
See nwadmin shows parellism = 32. I am not the 
tape person - that is my sys admin. I don't believe they actually 
have 32 tapes involved only 4. Can this impact performance by 
setting this too high? I also notice one backup server for 
networker with nwadmin messages like "clone sets being created...", 
"other databases being backed up". What is the usual policy on 
concurrently running backups, cloning at the same time recovery is 
taking place. It appears to show a lot of media waiting 
events: waiting for dlt7000 tape ... of the tapes that I 
specifically need for this restore. Did I say: I love my

RE: ??? Linux/Oracle 8.1.7 2GB file size limit ???

2003-06-05 Thread Branimir Petrovic

I'd say file size limit/autoextend feature has been Oracle's
dirty little secret for quite a while. For a very long period
of time there was similar 4GB 'magic' barrier on Windows, that 
was allegedly fixed. Workaround for the problem was to create
datafile 1 MB larger than the 'magic' number, and ether resize 
it using this trick or add another datafile to tablespace when 
the time comes (whenever MagicNumber or N x MagicNumber is close).

Despite rumours (of having fixed autoextend feature on Windows)
I recently witnessed failed imports into Oracle 9.2.0.1.0 
caused by too small tablespaces that just wouldn't autoextend.
Interestingly, import died beautifully cuz silently in the
middle of job without _any_ errors, traces etc. Just gone.

There is also interesting myth here at the place where I work
that systems tablespace autoextend feature ain't to be trusted
as it is known to have caused intermittent data dictionary 
corruptions while code recompilation takes place under space 
crunch conditions... 
 
On slightly cynical side note: autoextend that doesn't - maps
nicely into job safety ;-)

Branimir

 -Original Message-
 From: Orr, Steve [mailto:[EMAIL PROTECTED]
 Sent: June 4, 2003 11:40 AM
 To: Multiple recipients of list ORACLE-L
 Subject: ??? Linux/Oracle 8.1.7 2GB file size limit ???
 
 
 I've just been informed that there is a 2GB datafile size 
 limit with Oracle 8.1.7 on Linux... PERIOD. This despite the 
 fact that we've had files in excess of this for some time and 
 they work just fine. The problem occurs when the autoextend 
 feature reaches the 2GB threshhold. Of course, Oracle 
 didn't tell me this until after about 4 days of back and 
 forth testing for them. (There is no such O/S file size 
 limit.) I've reviewed the Linux release notes, the Linux 
 install guide, the Linux admin guide and the contents of 
 $ORACLE_HOME/relnotes and I don't find any such limitation in 
 the documentation. Did I miss it? Can anyone find any such 
 published limitation in the docs? Is this a secret? 
 
 
 Peeved at Oracle... AGAIN,
 Steve Orr
 -- 
 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Branimir Petrovic
  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-Mail message
to: [EMAIL PROTECTED] (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).

RE: ??? Linux/Oracle 8.1.7 2GB file size limit ???

See my note: There is no such O/S file size limit.

We have datafiles  2GB which work just fine. The problem is with autoextending 
datafiles that extend from 2GB to 2GB. It's not a Linux limitation but a limitation 
imposed by Oracle's implementation on Linux. Oracle 9i on Linux doesn't have this 
problem. And my peeve is that it took OWS 4 days to discover this limit.


Still peeved,  :-)
Steve



-Original Message-
Sent: Wednesday, June 04, 2003 10:55 AM
To: Multiple recipients of list ORACLE-L


I think it is the limitation of Linux, not Oracle.
Use LVM and don't worry about file size limit. :-)

JP
- Original Message - 
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, June 04, 2003 5:40 PM


 I've just been informed that there is a 2GB datafile size limit with
Oracle 8.1.7 on Linux... PERIOD. This despite the fact that we've had files
in excess of this for some time and they work just fine. The problem occurs
when the autoextend feature reaches the 2GB threshhold. Of course, Oracle
didn't tell me this until after about 4 days of back and forth testing for
them. (There is no such O/S file size limit.) I've reviewed the Linux
release notes, the Linux install guide, the Linux admin guide and the
contents of $ORACLE_HOME/relnotes and I don't find any such limitation in
the documentation. Did I miss it? Can anyone find any such published
limitation in the docs? Is this a secret?


 Peeved at Oracle... AGAIN,
 Steve Orr
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 -- 
 Author: Orr, Steve
   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-Mail message
 to: [EMAIL PROTECTED] (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).


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jan Pruner
  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-Mail message
to: [EMAIL PROTECTED] (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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Orr, Steve
  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-Mail message
to: [EMAIL PROTECTED] (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).

RE: Interesting!

I think, you did.

Using packages you still can hide procedures/functions.
Just have them in package body, and don't declare them in package
header/declaration.  Thus, describe package_name will not show
private procedures/functions.

Igor Neyman, OCP DBA
[EMAIL PROTECTED]



-Original Message-
Jahnke
Sent: Wednesday, June 04, 2003 11:10 AM
To: Multiple recipients of list ORACLE-L

Hi

Possible scenario where it might make sense:

You want to hide some implementation from people that use your
package.
Since, AFAIK PL/SQL doesn't have information hiding (private, protected,
public etc.),
this might be a way of not showing your private helper method's
signature 
in your package declaration. 
And yes, I am aware of the fact that it only makes sense with procs,
funcs
that 
you only want to use from within the scope of the proc/func you define
them
in.
Otherwise you would end up with duplicate code.

Did I miss anything ?
Stefan

-Ursprüngliche Nachricht-
Von: Khedr, Waleed [mailto:[EMAIL PROTECTED]
Gesendet: Mittwoch, 4. Juni 2003 16:20
An: Multiple recipients of list ORACLE-L
Betreff: RE: Interesting!


I think it's good to have (forgive me Jared :)). 
It reminds me with Pascal language.

Waleed

-Original Message-
Sent: Tuesday, June 03, 2003 9:40 PM
To: Multiple recipients of list ORACLE-L


My first real PL/SQL program used this technique.  Of course since it
was my
first program I ran into a very annoying variable scope issue.  Of
course
after spending hours debugging the code, I realized I should have taken
the
advice of our DBA, the infamous Jared Still, and just used a package.  I
have since looked askew at the nesting of procedures.  I can't remember
the
actual error I encountered.  It probably had nothing or very little to
do
with my nested procedures, but in my mind I can't consider this to be a
good
practice.  A package does the same job, and so much cleaner.

P.S.  I think this was the first time I noted Jared's annoying habit of
being right


Steve McClure

-Original Message-
Waleed
Sent: Tuesday, June 03, 2003 4:10 PM
To: Multiple recipients of list ORACLE-L


I've just discovered this, never thought if it was possible or not.
Just wanted to share it with you, so forgive me if you know it already.
Procedure can contain other procedures:

create or replace procedure test_test1 as
procedure test_test2 as
begin
 dbms_output.put_line('hello2');
 end;
function c1 ( p1 in number) return number as
begin
 return(p1 * 2);
end;
begin
  dbms_output.put_line('hello1');
  test_test2;
  dbms_output.put_line( c1(10));
end;

Regards,

Waleed

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Khedr, Waleed
  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-Mail message
to: [EMAIL PROTECTED] (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).


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Steve McClure
  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-Mail message
to: [EMAIL PROTECTED] (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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Khedr, Waleed
  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-Mail message
to: [EMAIL PROTECTED] (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).


 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Stefan Jahnke
  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-Mail message
to: [EMAIL PROTECTED] (note

RE: RE: Schedule Analyze using DBMS_STATS ???

2003-06-05 Thread Ganesh Raja

There are a Lot of options to DBMS_STATS .. And be Judicious in using
the same. Read the docs before attempting it.

BTW .. What is the session waiting for .. Just Check v$session_wait.

HTH

Best Regards,
Ganesh R
DID : +65-6215-8413
HP  : +65-9067-8474
===
Live to learn... forget... and learn again.
===


-Original Message-
Keshava Murthy (Cognizant)
Sent: Wednesday, June 04, 2003 8:55 PM
To: Multiple recipients of list ORACLE-L




 Hi all,
Everyone is recommending DBMS_STATS to be used for
computing the statistics.  But even after specifying the parallel option
, DBMS_STATS is taking lots of time ! in comparison to Analyze...

 In case of tables with a million  records the query just hangs when i
use the stats package...

 Can anybody tell me whts happening ?

 Regards
 kesh



-Original Message-
Sent: Tuesday, June 03, 2003 8:55 PM
To: Multiple recipients of list ORACLE-L


Sorry JP, I should have clarified that DBMS_STATS is the way to go, when
on a 9i or above release. One of the simple factors being that ANALYZE
is being deprecated.. There seemed to be a number of bugs/quirks,
whatever you want to call them, in certain 8.1.x versions, which are now
fixed within 9i..

There's a number of threads about the issues, available in the list
archives (you can find them at http://www.faqchest.com), which I dug
around - as I remembered seeing a post by Connor McDonald, where he gave
away an alternate script to gather stats, here's the mail:

http://www.faqchest.com/prgm/oracle-l/ora-02/ora-0210/ora-021011/ora0210
0802
_06150.html

I think the general consensus is that DBMS_STATS is quicker. I've never
personally done any comparative benchmarks to corroborate this sheep
following attitude though.. ;)

Regards

Mark

-Original Message-
Sent: 03 June 2003 14:55
To: Mark Leith
Cc: [EMAIL PROTECTED]


Thanx a lot Mark.
Sure , your code has given me a starting point.
let me change accordingly to use DBMS_STATSe and give a try :-)

So,can i conclude that DBMS_STATS is better than ANALYZE ?!

Someone over the list mentioned that DBMS_STATS is slower.
is it so ? What is your opinion regarding this ?!
just curious to know !

Regards,
Jp.


3-6-2003 22:01:32, Mark Leith [EMAIL PROTECTED] wrote:

Prem,

Use DBMS_JOBS to run the analyze:

===

undef username
undef password
grant analyze any to username
/

connect username/password

CREATE or REPLACE PROCEDURE analyze_tables (
  v_stat_type IN VARCHAR2 := 'COMPUTE') AS
  CURSOR c IS
  SELECT DISTINCT owner
  FROM   all_tables
  WHERE  owner not in ('SYS','SYSTEM');
  BEGIN
  FOR any_row IN c LOOP
dbms_utility.analyze_schema(
  any_row.owner,v_stat_type);
  END LOOP;
  END;
/

===

variable jobno number
declare jobno number;
  BEGIN
  dbms_job.submit(:jobno,
'begin username.analyze_tables; end;',
to_date('03jun0304:00','DDMONYYHH24:MI'),
'trunc(sysdate)+(1+(4/24))');
  END;

===

The above will run a COMPUTE analyze on all schemas, except SYS and
SYSTEM,
at 4:00am every day. Modify it to your own needs, but it should give
you a
starting point..

I would also recommend using DBMS_STATS to generate your statistics.

Have fun! ;0)

Mark



---
Incoming mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.484 / Virus Database: 282 - Release Date: 27/05/2003

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.484 / Virus Database: 282 - Release Date: 27/05/2003

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Mark Leith
  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-Mail message
to: [EMAIL PROTECTED] (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).


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Ganesh Raja
  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-Mail message
to: [EMAIL PROTECTED] (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

RE: Shite of the day

2003-06-05 Thread Ganesh Raja

Set the Compatiable Parameter to the Actual Version you Upgraded and not
to any patch rel that was rel later on.

HTH

Best Regards,
Ganesh R
DID : +65-6215-8413
HP  : +65-9067-8474
===
Live to learn... forget... and learn again.
===


-Original Message-
Lisa
Sent: Wednesday, June 04, 2003 10:40 PM
To: Multiple recipients of list ORACLE-L


Oh-My-Gosh.  

Worry free?  I just upgraded another 8.1.7.4 database to 9.2.  When I
set the COMPATIBLE parm to 9.0.2 (or 9.2, which would make sense) I get
really messy errors:

ORA-00402: database changes by release 9.0.1.3.0 cannot be used by
release 135294976

ORA-01571: redo version 9.0.2.0.0 incompatible with ORACLE version
8.1.7.0.0

So then I tried to set it back to 8.1.7, or comment out COMPATIBLE
altogether, and I get the same type of error.  It won't open at all. 

I tried initiating recovery.  This database is in noarc mode.  It starts
looking for arclogs that *do not* exist.  I also tried to drop the redo
log groups and recreate them.  Still, no dice. 

Again, unbreakable my FUNDAMENT.

So has anyone seen this before?  I opened a tar yesterday and promptly
confused support. 

Lisa



-Original Message-
Sent: Wednesday, June 04, 2003 7:45 AM
To: Multiple recipients of list ORACLE-L


Trade SQL Server for Oracle9i Database and get up to 100% license
credit 
and peace of mind.

Tired of applying patches? Frustrated with managing mulitple database
servers? 
In the time it takes you to apply all Microsoft's patches to your
servers, 
you can successfully migrate your database to Oracle9i Database and be 
worry-free. 


From 
http://www.oracle.com/start/linuxsqlserver/intro.html?src=1764462Act=16


I don't understand PR of Oracle. The RDBMS has so much properties which
are 
much more better implemented in Oracle than in MS SQL and they choose 
'patching' which *** on both servers.

JP

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jan Pruner
  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-Mail message
to: [EMAIL PROTECTED] (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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Koivu, Lisa
  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-Mail message
to: [EMAIL PROTECTED] (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).


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Ganesh Raja
  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-Mail message
to: [EMAIL PROTECTED] (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).

RE: Interesting!

2003-06-05 Thread Pardee, Roy E

I believe PL/SQL packages let you do a fair bit of information hiding--any
signature you leave out of the package spec is essentially private to the
package.  You can also decare package-wide variables in the package body to
keep them private to the package.  For instance:

create or replace package my_package is
  v_my_public_var VARCHAR2(30) ;

  procedure my_public_procedure ;
end my_package ;

create or replace package body my_package is
  v_my_private_var VARCHAR2(30) ;
  procedure my_private_procedure is
  begin
v_my_private_var := 'Hello!' ;
  end my_private_procedure ;
  procedure my_public_procedure is
  begin
my_private_procedure ;
  end my_public_procedure ;
end my_package ;

Cheers,

-Roy

Roy Pardee
Programmer/Analyst/DBA
SWFPAC Lockheed Martin IT
Extension 8487

-Original Message-
Sent: Wednesday, June 04, 2003 9:10 AM
To: Multiple recipients of list ORACLE-L


Hi

Possible scenario where it might make sense:

You want to hide some implementation from people that use your package.
Since, AFAIK PL/SQL doesn't have information hiding (private, protected,
public etc.),
this might be a way of not showing your private helper method's signature 
in your package declaration. 
And yes, I am aware of the fact that it only makes sense with procs, funcs
that 
you only want to use from within the scope of the proc/func you define them
in.
Otherwise you would end up with duplicate code.

Did I miss anything ?
Stefan

-Ursprüngliche Nachricht-
Von: Khedr, Waleed [mailto:[EMAIL PROTECTED]
Gesendet: Mittwoch, 4. Juni 2003 16:20
An: Multiple recipients of list ORACLE-L
Betreff: RE: Interesting!


I think it's good to have (forgive me Jared :)). 
It reminds me with Pascal language.

Waleed

-Original Message-
Sent: Tuesday, June 03, 2003 9:40 PM
To: Multiple recipients of list ORACLE-L


My first real PL/SQL program used this technique.  Of course since it was my
first program I ran into a very annoying variable scope issue.  Of course
after spending hours debugging the code, I realized I should have taken the
advice of our DBA, the infamous Jared Still, and just used a package.  I
have since looked askew at the nesting of procedures.  I can't remember the
actual error I encountered.  It probably had nothing or very little to do
with my nested procedures, but in my mind I can't consider this to be a good
practice.  A package does the same job, and so much cleaner.

P.S.  I think this was the first time I noted Jared's annoying habit of
being right


Steve McClure

-Original Message-
Waleed
Sent: Tuesday, June 03, 2003 4:10 PM
To: Multiple recipients of list ORACLE-L


I've just discovered this, never thought if it was possible or not.
Just wanted to share it with you, so forgive me if you know it already.
Procedure can contain other procedures:

create or replace procedure test_test1 as
procedure test_test2 as
begin
 dbms_output.put_line('hello2');
 end;
function c1 ( p1 in number) return number as
begin
 return(p1 * 2);
end;
begin
  dbms_output.put_line('hello1');
  test_test2;
  dbms_output.put_line( c1(10));
end;

Regards,

Waleed

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Khedr, Waleed
  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-Mail message
to: [EMAIL PROTECTED] (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).


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Steve McClure
  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-Mail message
to: [EMAIL PROTECTED] (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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Khedr, Waleed
  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-Mail message
to: [EMAIL PROTECTED] (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

ORA-12547: TNS:lost contact

2003-06-05 Thread Zabair Ahmed

Any Oracle Apps DBA out there..

Am getting the following error when am trying to install 11.5.8 on Redhat 8. The error messgae in the adcrdb_PROD.txt is as follows:-

ORA-12547:TNS:lost contact
SP2-0640 Not connected.

Am getting the error when rapwiz is running adcrdb.sh - creating the database controlfile. I know this is a connectivity issue to the instance. but how do I resolve it.

Thanks
Yahoo! Plus - For a better Internet experience

oraInst.loc question

2003-06-05 Thread Rich Holland

I have two Oracle installations on the same host.  Between installs I
updated /etc/oraInst.loc and /var/opt/oracle/oraInst.loc accordingly so
that I have two inventory directoies, one per installation.

My question is that /etc/oratab has a facility for multiple
installations via 'SID:$ORACLE_HOME path:N' entries, but the
oraInst.loc appears to be for a single installation.

Now in order to apply patches and such, I have to modify
/etc/oraInst.loc every time (it appears Opatch is ignoring the
/var/opt/oracle version).

Has anyone found an easy way to use multiple oraInst.loc files or to use
a single oraInst.loc file for multiple inventories?  I'm strongly
considering hiding opatch and replacing it with a wrapper script that
rewrites the oraInst.loc files prior to calling the 'real' opatch
executable, but thought I'd see if there's an easier way first.  :-)

Thanks!
Rich Holland
SAP Technical Consultant
Guidance Technologies, Inc.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Rich Holland
  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-Mail message
to: [EMAIL PROTECTED] (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).

RE: Shite of the day

Hi Ganesh, 

Thanks for your reply.  Still, no dice.  Now it thinks it's in recovery and I can't 
force it to do an incomplete recovery with OPEN RESETLOGS.  The brilliant response I 
got from support is Restore from backup and try again

Lovely.  This is the second upgrade I have tried to complete and failed miserably at.  
This is NOT giving me a warm fuzzy about upgrading production. 

Lisa 
(Can one more thing go wrong today?  Please?)

-Original Message-
Sent: Wednesday, June 04, 2003 1:38 PM
To: Multiple recipients of list ORACLE-L


Set the Compatiable Parameter to the Actual Version you Upgraded and not
to any patch rel that was rel later on.

HTH

Best Regards,
Ganesh R
DID : +65-6215-8413
HP  : +65-9067-8474
===
Live to learn... forget... and learn again.
===


-Original Message-
Lisa
Sent: Wednesday, June 04, 2003 10:40 PM
To: Multiple recipients of list ORACLE-L


Oh-My-Gosh.  

Worry free?  I just upgraded another 8.1.7.4 database to 9.2.  When I
set the COMPATIBLE parm to 9.0.2 (or 9.2, which would make sense) I get
really messy errors:

ORA-00402: database changes by release 9.0.1.3.0 cannot be used by
release 135294976

ORA-01571: redo version 9.0.2.0.0 incompatible with ORACLE version
8.1.7.0.0

So then I tried to set it back to 8.1.7, or comment out COMPATIBLE
altogether, and I get the same type of error.  It won't open at all. 

I tried initiating recovery.  This database is in noarc mode.  It starts
looking for arclogs that *do not* exist.  I also tried to drop the redo
log groups and recreate them.  Still, no dice. 

Again, unbreakable my FUNDAMENT.

So has anyone seen this before?  I opened a tar yesterday and promptly
confused support. 

Lisa



-Original Message-
Sent: Wednesday, June 04, 2003 7:45 AM
To: Multiple recipients of list ORACLE-L


Trade SQL Server for Oracle9i Database and get up to 100% license
credit 
and peace of mind.

Tired of applying patches? Frustrated with managing mulitple database
servers? 
In the time it takes you to apply all Microsoft's patches to your
servers, 
you can successfully migrate your database to Oracle9i Database and be 
worry-free. 


From 
http://www.oracle.com/start/linuxsqlserver/intro.html?src=1764462Act=16


I don't understand PR of Oracle. The RDBMS has so much properties which
are 
much more better implemented in Oracle than in MS SQL and they choose 
'patching' which *** on both servers.

JP

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jan Pruner
  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-Mail message
to: [EMAIL PROTECTED] (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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Koivu, Lisa
  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-Mail message
to: [EMAIL PROTECTED] (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).


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Ganesh Raja
  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-Mail message
to: [EMAIL PROTECTED] (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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Koivu, Lisa
  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-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of

RE: library cache pin wait

2003-06-05 Thread Johnson, Michael

real quick thought from mostly a lurker 



Your soft parsing % probably indicates what you suspected
in string literals.The % of your physical reads is way
to high versus logical reads.Check you SQL area and see 
if their are any obvious dogs in there.   Your second wait 
latch free could be indicative of string literal problems.  

Your memory usage should be lower than what it is on the shared
pool side say down around 75% is ideal, but this may be indicative of
the problem above as you have to load up all those diffent SQL statements
into the pool.If that percentage gets to high then you may be
aging out good SQL requiring you to hard parse SQL all over again if
it is needed.  

Gotta clean up those applications.   If Cursor_sharing=Force works
well in 9+, it will just make folks more lazy as you will bail them out.
Gotta get tough like a parent and force them to rewrite their
software.  You will win no friends, but Oh well.

Also,  ask the applications developers or users if they have noticed
any kind of a slowdown during this 60 minute session you are looking at.
Consider setting a 10046 trace on a users session and you should see the 
wait in there and the competing problem.  Also, see www.hotsos.com 
for some information on 10046 data.

Also, use Gaja and Kirti's most excellent book Oracle Performance 
tuning 101 to drill down on those library cache pin and latch free waits.   

Also,  Tom Kyte's most excellent book has a pretty good explanation in
Chapter 10 I believe on using Statspack and what to look for in
the report.

Focus on the Soft Parsing % first by tracking down bad SQL, then revisit
this report again after some time and see if that helped.  Talk with
Millsap, Kyte, Gaja, Anjo and Kirti on this stuff.  

They are all studs.
Good Luck with it.

Mike



-Original Message-
Sent: Wednesday, June 04, 2003 12:40 AM
To: Multiple recipients of list ORACLE-L



For a Hybrid Banking Application , following waits are Observed :-
Oracle ver 9.2 (Dedicated Server connections)
Solaris 8
M/c SF15K
Application mostly uses Static Queries (i.e. with Bind variables) , 
though there may be some amount of Literal SQLs too 
DB Size = 250 GB

Qs How may the following waits be approached ?
Qs Since we have just moved to 9.2 , any advisable standard init.ora
parameters with 9.2 ?
Qs Should CURSOR_SHARING = FORCE or SIMILAR be considered ? Which is better 
 what may be the Overhead of these on production ?

Shall answer any Clarifications .

Thanks


--
STATSPACK report for

DB Name DB IdInstance Inst Num Release Cluster Host
 ---   --- ---

TBASUN1820705732 tbasun  1 9.2.0.3.0   NO  IB15KDB

Snap Id Snap Time  Sessions Curs/Sess Comment
--- --  -
---
Begin Snap:  71 03-Jun-03 12:00:052,953  53.2
  End Snap:  91 03-Jun-03 13:00:053,030  55.2
   Elapsed:   60.00 (mins)

Cache Sizes (end)
~
   Buffer Cache:   703M  Std Block Size: 8K
   Shared Pool Size:   400M  Log Buffer: 6,144K

Load Profile
Per Second   Per Transaction
   ---   ---
  Redo size:251,510.31  1,682.23
  Logical reads: 35,458.62237.17
  Block changes:  1,226.80  8.21
 Physical reads:  2,391.08 15.99
Physical writes:155.51  1.04
 User calls:  8,556.91 57.23
 Parses:495.46  3.31
Hard parses: 71.17  0.48
  Sorts:201.79  1.35
 Logons:  8.80  0.06
   Executes:  5,949.80 39.80
   Transactions:149.51

  % Blocks changed per Read:3.46Recursive Call %:43.86
 Rollback per transaction %:   55.51   Rows per Sort:45.29

Instance Efficiency Percentages (Target 100%)
~
Buffer Nowait %:   99.98   Redo NoWait %:   99.99
Buffer  Hit   %:   93.35In-memory Sort %:   99.94
Library Hit   %:   98.14Soft Parse %:   85.64
 Execute to Parse %:   91.67 Latch Hit %:   98.81
Parse CPU to Parse Elapsd %:3.56 % Non-Parse CPU:   90.92

 Shared Pool StatisticsBegin   End
   --  --

RE: ??? Linux/Oracle 8.1.7 2GB file size limit ???

2003-06-05 Thread Mercadante, Thomas F

Steve - are you saying that there is a workaround by increasing the size of
the file manually to something larger than 4G?

Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Wednesday, June 04, 2003 1:25 PM
To: Multiple recipients of list ORACLE-L


See my note: There is no such O/S file size limit.

We have datafiles  2GB which work just fine. The problem is with
autoextending datafiles that extend from 2GB to 2GB. It's not a Linux
limitation but a limitation imposed by Oracle's implementation on Linux.
Oracle 9i on Linux doesn't have this problem. And my peeve is that it took
OWS 4 days to discover this limit.


Still peeved,  :-)
Steve



-Original Message-
Sent: Wednesday, June 04, 2003 10:55 AM
To: Multiple recipients of list ORACLE-L


I think it is the limitation of Linux, not Oracle.
Use LVM and don't worry about file size limit. :-)

JP
- Original Message - 
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, June 04, 2003 5:40 PM


 I've just been informed that there is a 2GB datafile size limit with
Oracle 8.1.7 on Linux... PERIOD. This despite the fact that we've had files
in excess of this for some time and they work just fine. The problem occurs
when the autoextend feature reaches the 2GB threshhold. Of course, Oracle
didn't tell me this until after about 4 days of back and forth testing for
them. (There is no such O/S file size limit.) I've reviewed the Linux
release notes, the Linux install guide, the Linux admin guide and the
contents of $ORACLE_HOME/relnotes and I don't find any such limitation in
the documentation. Did I miss it? Can anyone find any such published
limitation in the docs? Is this a secret?


 Peeved at Oracle... AGAIN,
 Steve Orr
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 -- 
 Author: Orr, Steve
   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-Mail message
 to: [EMAIL PROTECTED] (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).


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jan Pruner
  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-Mail message
to: [EMAIL PROTECTED] (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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Orr, Steve
  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-Mail message
to: [EMAIL PROTECTED] (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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Mercadante, Thomas F
  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-Mail message
to: [EMAIL PROTECTED] (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).

RE: ??? Linux/Oracle 8.1.7 2GB file size limit ???

NICE! Thanks.

-Original Message-
Sent: Wednesday, June 04, 2003 11:57 AM
To: Multiple recipients of list ORACLE-L




It's a combo problem between oracle and linux.  When Linux first
implemented largefile support, many of the traditional linux apps were
not aware of the concept of 2GB files and were using 32-bit offsets for
file pointer storage.  So, as a workaround, 32- and 64-bit versions of
the various file operation calls were made to specify whether a 32-bit
or 64-bit offset should be returned, as well as specifying a flag
O_LARGEFILE that could be sent to the traditional open() that indicated
the application was largefile aware.  When an application is compiled,
you can specify to the compiler that you want it to be 64-bit aware and
the 64-bit versions of things like open and seek will be used, or the
code can use the O_LARGEFILE flag in open().  The end result of this is
that while linux is 2GB aware, oracle 8.1.7 is not quite entirely.  I
bet that the chunk of code that opens a datafile for traditional access
in 8.1.7 is 64-bit aware, while the code that grows the file is not.  

Thanks,
Matt

--
Matthew Zito
GridApp Systems
Email: [EMAIL PROTECTED]
Cell: 646-220-3551
Phone: 212-358-8211 x 359 

 -Original Message-
 From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of 
 Jan Pruner
 Sent: Wednesday, June 04, 2003 11:55 AM
 To: Multiple recipients of list ORACLE-L
 Subject: Re: ??? Linux/Oracle 8.1.7 2GB file size limit ???
 
 
 I think it is the limitation of Linux, not Oracle.
 Use LVM and don't worry about file size limit. :-)
 
 JP
 - Original Message - 
 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
 Sent: Wednesday, June 04, 2003 5:40 PM
 
 
  I've just been informed that there is a 2GB datafile size limit with
 Oracle 8.1.7 on Linux... PERIOD. This despite the fact that 
 we've had files in excess of this for some time and they work 
 just fine. The problem occurs when the autoextend feature 
 reaches the 2GB threshhold. Of course, Oracle didn't tell me 
 this until after about 4 days of back and forth testing for 
 them. (There is no such O/S file size limit.) I've reviewed 
 the Linux release notes, the Linux install guide, the Linux 
 admin guide and the contents of $ORACLE_HOME/relnotes and I 
 don't find any such limitation in the documentation. Did I 
 miss it? Can anyone find any such published limitation in the 
 docs? Is this a secret?
 
 
  Peeved at Oracle... AGAIN,
  Steve Orr
  --
  Please see the official ORACLE-L FAQ: http://www.orafaq.net
  -- 
  Author: Orr, Steve
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-Mail message
  to: [EMAIL PROTECTED] (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).
 
 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 -- 
 Author: Jan Pruner
   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-Mail message
 to: [EMAIL PROTECTED] (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).
 
 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Matthew Zito
  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-Mail message
to: [EMAIL PROTECTED] (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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Orr, Steve
  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-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line

RE: ??? Linux/Oracle 8.1.7 2GB file size limit ???

2003-06-05 Thread Matthew Zito



It's a combo problem between oracle and linux.  When Linux first
implemented largefile support, many of the traditional linux apps were
not aware of the concept of 2GB files and were using 32-bit offsets for
file pointer storage.  So, as a workaround, 32- and 64-bit versions of
the various file operation calls were made to specify whether a 32-bit
or 64-bit offset should be returned, as well as specifying a flag
O_LARGEFILE that could be sent to the traditional open() that indicated
the application was largefile aware.  When an application is compiled,
you can specify to the compiler that you want it to be 64-bit aware and
the 64-bit versions of things like open and seek will be used, or the
code can use the O_LARGEFILE flag in open().  The end result of this is
that while linux is 2GB aware, oracle 8.1.7 is not quite entirely.  I
bet that the chunk of code that opens a datafile for traditional access
in 8.1.7 is 64-bit aware, while the code that grows the file is not.  

Thanks,
Matt

--
Matthew Zito
GridApp Systems
Email: [EMAIL PROTECTED]
Cell: 646-220-3551
Phone: 212-358-8211 x 359 

 -Original Message-
 From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of 
 Jan Pruner
 Sent: Wednesday, June 04, 2003 11:55 AM
 To: Multiple recipients of list ORACLE-L
 Subject: Re: ??? Linux/Oracle 8.1.7 2GB file size limit ???
 
 
 I think it is the limitation of Linux, not Oracle.
 Use LVM and don't worry about file size limit. :-)
 
 JP
 - Original Message - 
 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
 Sent: Wednesday, June 04, 2003 5:40 PM
 
 
  I've just been informed that there is a 2GB datafile size limit with
 Oracle 8.1.7 on Linux... PERIOD. This despite the fact that 
 we've had files in excess of this for some time and they work 
 just fine. The problem occurs when the autoextend feature 
 reaches the 2GB threshhold. Of course, Oracle didn't tell me 
 this until after about 4 days of back and forth testing for 
 them. (There is no such O/S file size limit.) I've reviewed 
 the Linux release notes, the Linux install guide, the Linux 
 admin guide and the contents of $ORACLE_HOME/relnotes and I 
 don't find any such limitation in the documentation. Did I 
 miss it? Can anyone find any such published limitation in the 
 docs? Is this a secret?
 
 
  Peeved at Oracle... AGAIN,
  Steve Orr
  --
  Please see the official ORACLE-L FAQ: http://www.orafaq.net
  -- 
  Author: Orr, Steve
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-Mail message
  to: [EMAIL PROTECTED] (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).
 
 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 -- 
 Author: Jan Pruner
   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-Mail message
 to: [EMAIL PROTECTED] (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).
 
 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Matthew Zito
  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-Mail message
to: [EMAIL PROTECTED] (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).

RE: ??? Linux/Oracle 8.1.7 2GB file size limit ???

Thanks Branimir for confirming my right to be peeved. :-)

I never liked the autoextend feature but we use it because:
1) We have this nifty end user driven feature where they can clone their data via a 
nice web GUI interface. (This is for web site upgrades scheduled by the end user.)
2) We don't want the user to decide how much disk storage to allocate so we let the 
datafiles autoextend. 
3) As the DBA/DUHveloper (Python/CGI) who bequeathed certain DBA functions to the 
GUI interface, I depended on autoextend working and was too lazy to algorithm-ize 
the number of datafiles based on current storage needs.
4) Upon self-chastizement I'm undoing the autoextend feature and am now going to 
dba_segments to develop a capacity planning algorithm.

Developing DBA automation tools driven via events and end user input is a fun and wild 
ride on the margin of DBA fiefdom. 

Commiserating with my DBA buddy Walt, Help... we're losing control and we hate giving 
up 'power.' :-)


Staring out the window at the mountains in Big Sky Country,
Steve



-Original Message-
Sent: Wednesday, June 04, 2003 11:25 AM
To: Multiple recipients of list ORACLE-L


I'd say file size limit/autoextend feature has been Oracle's
dirty little secret for quite a while. For a very long period
of time there was similar 4GB 'magic' barrier on Windows, that 
was allegedly fixed. Workaround for the problem was to create
datafile 1 MB larger than the 'magic' number, and ether resize 
it using this trick or add another datafile to tablespace when 
the time comes (whenever MagicNumber or N x MagicNumber is close).

Despite rumours (of having fixed autoextend feature on Windows)
I recently witnessed failed imports into Oracle 9.2.0.1.0 
caused by too small tablespaces that just wouldn't autoextend.
Interestingly, import died beautifully cuz silently in the
middle of job without _any_ errors, traces etc. Just gone.

There is also interesting myth here at the place where I work
that systems tablespace autoextend feature ain't to be trusted
as it is known to have caused intermittent data dictionary 
corruptions while code recompilation takes place under space 
crunch conditions... 
 
On slightly cynical side note: autoextend that doesn't - maps
nicely into job safety ;-)

Branimir

 -Original Message-
 From: Orr, Steve [mailto:[EMAIL PROTECTED]
 Sent: June 4, 2003 11:40 AM
 To: Multiple recipients of list ORACLE-L
 Subject: ??? Linux/Oracle 8.1.7 2GB file size limit ???
 
 
 I've just been informed that there is a 2GB datafile size 
 limit with Oracle 8.1.7 on Linux... PERIOD. This despite the 
 fact that we've had files in excess of this for some time and 
 they work just fine. The problem occurs when the autoextend 
 feature reaches the 2GB threshhold. Of course, Oracle 
 didn't tell me this until after about 4 days of back and 
 forth testing for them. (There is no such O/S file size 
 limit.) I've reviewed the Linux release notes, the Linux 
 install guide, the Linux admin guide and the contents of 
 $ORACLE_HOME/relnotes and I don't find any such limitation in 
 the documentation. Did I miss it? Can anyone find any such 
 published limitation in the docs? Is this a secret? 
 
 
 Peeved at Oracle... AGAIN,
 Steve Orr
 -- 
 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Branimir Petrovic
  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-Mail message
to: [EMAIL PROTECTED] (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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Orr, Steve
  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-Mail message
to: [EMAIL PROTECTED] (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).

RE: oraInst.loc question

Title: RE: oraInst.loc question





We have one oraInst.loc file for each individual set of binaries (two on production, three in development/test) and every time we patch/upgrade/install we rename the oraInst.loc file to whatever we are working on.

Not an optimal solution, but the only one I really have found so far.


April Wells
Oracle DBA/Oracle Apps DBA
Corporate Systems
Amarillo Texas


You will recognize your own path when you come upon it, because you will suddenly have all the energy and imagination you will ever need.

~ Jerry Gillies ~




-Original Message-
From: Rich Holland [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, June 04, 2003 1:01 PM
To: Multiple recipients of list ORACLE-L
Subject: oraInst.loc question



I have two Oracle installations on the same host. Between installs I
updated /etc/oraInst.loc and /var/opt/oracle/oraInst.loc accordingly so
that I have two inventory directoies, one per installation.


My question is that /etc/oratab has a facility for multiple
installations via 'SID:$ORACLE_HOME path:N' entries, but the
oraInst.loc appears to be for a single installation.


Now in order to apply patches and such, I have to modify
/etc/oraInst.loc every time (it appears Opatch is ignoring the
/var/opt/oracle version).


Has anyone found an easy way to use multiple oraInst.loc files or to use
a single oraInst.loc file for multiple inventories? I'm strongly
considering hiding opatch and replacing it with a wrapper script that
rewrites the oraInst.loc files prior to calling the 'real' opatch
executable, but thought I'd see if there's an easier way first. :-)


Thanks!
Rich Holland
SAP Technical Consultant
Guidance Technologies, Inc.


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Rich Holland
 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-Mail message
to: [EMAIL PROTECTED] (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).



The information contained in this communication, including attachments, is strictly 
confidential and for the intended use of the addressee only; it may also contain 
proprietary, price sensitive, or legally privileged information. Notice is hereby given that 
any disclosure, distribution, dissemination, use, or copying of the information by anyone 
other than the intended recipient is strictly prohibited and may be illegal. If you have 
received this communication in error, please notify the sender immediately by reply e-mail, 
delete this communication, and destroy all copies.
 

Corporate Systems, Inc. has taken reasonable precautions to ensure that any attachment to 
this e-mail has been swept for viruses. We specifically disclaim all liability and will 
accept no responsibility for any damage sustained as a result of software viruses and advise 
you to carry out your own virus checks before opening any attachment.

Limiting Concurrent Sessions Not Working

2003-06-05 Thread Sam Bootsma









Oracle7 Server Release 7.3.4.5.0 (yes, I know, old); AIX
4.3.3 



Hello All,



I am trying to limit concurrent sessions on my
database. The Oracle documentation says I can do it. However, when
I follow the steps (create profile with sessions per user set to one, then assign
Oracle user to this profile) the user is not stopped from exceeding the number
of concurrent sessions. I tested this by connecting using Sql Plus.
I even tried bouncing the database, to see if that makes a difference, but to
no avail. 



Any ideas what is happening? Am I missing
something? Is this a problem/bug with Oracle 7.3.4? The output
below shows the steps I followed to create the profile and user. It also
shows multiple connections to the database after bouncing the instance.



Thanks for any suggestions!



Sam.









SQL create profile sam limit sessions_per_user 1;



Profile created.



SQL create user sam identified by sam;



User created.



SQL alter user sam profile sam;



User altered.



SQL grant create session to sam;



Grant succeeded.



SQL 



SQL l

 1 select limit

 2 from dba_profiles

 3 where profile=''

 4* and resource_name = 'SESSIONS_PER_USER'

SQL /



LIMIT



1



SQL 



SQL select profile

 2 from dba_users

 3 where username = 'SAM';



PROFILE

--

SAM



SQL



SVRMGR shutdown normal

Database closed.

Database dismounted.

ORACLE instance shut down.



SVRMGR connect internal

Connected to an idle instance.

SVRMGR startup

ORACLE instance started.

Total System Global Area
34122296 bytes

Fixed
Size
38992 bytes

Variable
Size
31797736 bytes

Database
Buffers
2252800 bytes

Redo
Buffers
32768 bytes

Database mounted.

Database opened.

SVRMGR select osuser, username

 2 from v$session; 

OSUSER
USERNAME


--- --

oracle


oracle


oracle


oracle


oracle


oracle


oracle


oracle


oracle


oracle


oracle


oracle
SYS


12 rows selected.

SVRMGR select osuser, username from v$session;

OSUSER
USERNAME


--- --

oracle


oracle


oracle


oracle


oracle


oracle


oracle


oracle


oracle


oracle


oracle


oracle
SYS


sam SAM


sam SAM


14 rows selected.

SVRMGR



Sam Bootsma

George Brown College

[EMAIL PROTECTED]

416-415-5000 x4933

Re: Those installing Oracle 9i on AIX 5.2L

Title: Those installing Oracle 9i on AIX 5.2L



Raj,

Here was what my SA (Claus)sent me when I 
asked him what we did special to AIX that Oracle required:


Standard 5.2 installation with 64-bit support and the basic JFS 
filesystem.Graphics were included (Oracle needs X windows).Only 
extra thing to install was bos.adt.libm.Oracle needs libm.a but the Base 
Application Development Math Library(bos.adt.libm) is not installed by 
default.-Claus

Hope this helps! 
Ruth

  - Original Message - 
  From: 
  Jamadagni, Rajendra 
  To: Multiple recipients of list ORACLE-L 
  
  Sent: Monday, June 02, 2003 8:39 AM
  Subject: Those installing Oracle 9i on 
  AIX 5.2L
  
  Hi all, 
  If you are installing or upgrading 
  9202/9203 on AIX 5.2L (64Bit), do you have a list of APARS that _must_ be 
  installed? 
  I am talking about regatta (p690) servers 
  if that matters ... 
  Thanks in advance Raj  
  Rajendra dot Jamadagni at nospamespn dot 
  com All Views expressed in this 
  email are strictly personal. QOTD: 
  Any clod can have facts, having an opinion is an art !

Re: Those installing Oracle 9i on AIX 5.2L

Title: Those installing Oracle 9i on AIX 5.2L



Raj,

On more thing to remember. If you are going 
to apply the 9.2.0.3 patchset, be sure to pick the 5L version, not the RS6000 
version of the patchset to download. If you pick the wrong one, it will be 
full of errors. If you pick the 5L version, it installed for me without 
error.

Ruth

  - Original Message - 
  From: 
  Jamadagni, Rajendra 
  To: Multiple recipients of list ORACLE-L 
  
  Sent: Monday, June 02, 2003 8:39 AM
  Subject: Those installing Oracle 9i on 
  AIX 5.2L
  
  Hi all, 
  If you are installing or upgrading 
  9202/9203 on AIX 5.2L (64Bit), do you have a list of APARS that _must_ be 
  installed? 
  I am talking about regatta (p690) servers 
  if that matters ... 
  Thanks in advance Raj  
  Rajendra dot Jamadagni at nospamespn dot 
  com All Views expressed in this 
  email are strictly personal. QOTD: 
  Any clod can have facts, having an opinion is an art !

RE: ??? Linux/Oracle 8.1.7 2GB file size limit ???

2003-06-05 Thread Boivin, Patrice J

This almost sounds like the problem that existed for Oracle 7.3 and the 2G
threshold a couple of years ago...

J'ai une impression d'avoir déjà vu ceci.

: )

Patrice.

-Original Message-
Sent: Wednesday, June 04, 2003 3:10 PM
To: Multiple recipients of list ORACLE-L


Steve - are you saying that there is a workaround by increasing the size of
the file manually to something larger than 4G?

Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Wednesday, June 04, 2003 1:25 PM
To: Multiple recipients of list ORACLE-L


See my note: There is no such O/S file size limit.

We have datafiles  2GB which work just fine. The problem is with
autoextending datafiles that extend from 2GB to 2GB. It's not a Linux
limitation but a limitation imposed by Oracle's implementation on Linux.
Oracle 9i on Linux doesn't have this problem. And my peeve is that it took
OWS 4 days to discover this limit.


Still peeved,  :-)
Steve



-Original Message-
Sent: Wednesday, June 04, 2003 10:55 AM
To: Multiple recipients of list ORACLE-L


I think it is the limitation of Linux, not Oracle.
Use LVM and don't worry about file size limit. :-)

JP
- Original Message - 
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, June 04, 2003 5:40 PM


 I've just been informed that there is a 2GB datafile size limit with
Oracle 8.1.7 on Linux... PERIOD. This despite the fact that we've had files
in excess of this for some time and they work just fine. The problem occurs
when the autoextend feature reaches the 2GB threshhold. Of course, Oracle
didn't tell me this until after about 4 days of back and forth testing for
them. (There is no such O/S file size limit.) I've reviewed the Linux
release notes, the Linux install guide, the Linux admin guide and the
contents of $ORACLE_HOME/relnotes and I don't find any such limitation in
the documentation. Did I miss it? Can anyone find any such published
limitation in the docs? Is this a secret?


 Peeved at Oracle... AGAIN,
 Steve Orr
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 -- 
 Author: Orr, Steve
   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-Mail message
 to: [EMAIL PROTECTED] (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).


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jan Pruner
  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-Mail message
to: [EMAIL PROTECTED] (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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Orr, Steve
  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-Mail message
to: [EMAIL PROTECTED] (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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Mercadante, Thomas F
  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-Mail message
to: [EMAIL PROTECTED] (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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Boivin, Patrice J
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To

RE: Shite of the day

2003-06-05 Thread Jesse, Rich

Lisa, when you say you manually migrated, did you use exp/imp after a
fresh CREATE DATABASE in 9i?  Also, what platform?  32-bit?

Thx!
Rich

Rich Jesse   System/Database Administrator
[EMAIL PROTECTED]  Quad/Tech Inc, Sussex, WI USA


 -Original Message-
 From: Koivu, Lisa [mailto:[EMAIL PROTECTED]
 Sent: Wednesday, June 04, 2003 1:05 PM
 To: Multiple recipients of list ORACLE-L
 Subject: RE: Shite of the day
 
 
 Hi Ganesh, 
 
 Thanks for your reply.  Still, no dice.  Now it thinks it's 
 in recovery and I can't force it to do an incomplete recovery 
 with OPEN RESETLOGS.  The brilliant response I got from 
 support is Restore from backup and try again
 
 Lovely.  This is the second upgrade I have tried to complete 
 and failed miserably at.  This is NOT giving me a warm fuzzy 
 about upgrading production. 
 
 Lisa 
 (Can one more thing go wrong today?  Please?)
 
 -Original Message-
 Sent: Wednesday, June 04, 2003 1:38 PM
 To: Multiple recipients of list ORACLE-L
 
 
 Set the Compatiable Parameter to the Actual Version you 
 Upgraded and not
 to any patch rel that was rel later on.
 
 HTH
 
 Best Regards,
 Ganesh R
 DID : +65-6215-8413
 HP  : +65-9067-8474
 ===
 Live to learn... forget... and learn again.
 ===
 
 
 -Original Message-
 Lisa
 Sent: Wednesday, June 04, 2003 10:40 PM
 To: Multiple recipients of list ORACLE-L
 
 
 Oh-My-Gosh.  
 
 Worry free?  I just upgraded another 8.1.7.4 database to 9.2.  When I
 set the COMPATIBLE parm to 9.0.2 (or 9.2, which would make 
 sense) I get
 really messy errors:
 
 ORA-00402: database changes by release 9.0.1.3.0 cannot be used by
 release 135294976
 
 ORA-01571: redo version 9.0.2.0.0 incompatible with ORACLE version
 8.1.7.0.0
 
 So then I tried to set it back to 8.1.7, or comment out COMPATIBLE
 altogether, and I get the same type of error.  It won't open at all. 
 
 I tried initiating recovery.  This database is in noarc mode. 
  It starts
 looking for arclogs that *do not* exist.  I also tried to 
 drop the redo
 log groups and recreate them.  Still, no dice. 
 
 Again, unbreakable my FUNDAMENT.
 
 So has anyone seen this before?  I opened a tar yesterday and promptly
 confused support. 
 
 Lisa
 
 
 
 -Original Message-
 Sent: Wednesday, June 04, 2003 7:45 AM
 To: Multiple recipients of list ORACLE-L
 
 
 Trade SQL Server for Oracle9i Database and get up to 100% license
 credit 
 and peace of mind.
 
 Tired of applying patches? Frustrated with managing mulitple database
 servers? 
 In the time it takes you to apply all Microsoft's patches to your
 servers, 
 you can successfully migrate your database to Oracle9i 
 Database and be 
 worry-free. 
 
 
 From 
 http://www.oracle.com/start/linuxsqlserver/intro.html?src=1764
 462Act=16
 
 
 I don't understand PR of Oracle. The RDBMS has so much 
 properties which
 are 
 much more better implemented in Oracle than in MS SQL and they choose 
 'patching' which *** on both servers.
 
 JP
 
 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jesse, Rich
  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-Mail message
to: [EMAIL PROTECTED] (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).

RE: Those installing Oracle 9i on AIX 5.2L

2003-06-05 Thread Jamadagni, Rajendra

Title: Those installing Oracle 9i on AIX 5.2L



Thanks Ruth ...

I'll pass this to my SA.

Raj
 
Rajendra dot Jamadagni at nospamespn dot 
com All Views expressed in this email 
are strictly personal. QOTD: Any clod 
can have facts, having an opinion is an art ! 

  -Original Message-From: Ruth Gramolini 
  [mailto:[EMAIL PROTECTED]Sent: Wednesday, June 04, 2003 
  2:42 PMTo: Multiple recipients of list ORACLE-LSubject: 
  Re: Those installing Oracle 9i on AIX 5.2L
  Raj,
  
  Here was what my SA (Claus)sent me when I 
  asked him what we did special to AIX that Oracle required:
  
  
  Standard 5.2 installation with 64-bit support and the basic JFS 
  filesystem.Graphics were included (Oracle needs X windows).Only 
  extra thing to install was bos.adt.libm.Oracle needs libm.a but the Base 
  Application Development Math Library(bos.adt.libm) is not installed by 
  default.-Claus
  
  Hope this helps! 
  Ruth
This e-mail 
message is confidential, intended only for the named recipient(s) above and may 
contain information that is privileged, attorney work product or exempt from 
disclosure under applicable law. If you have received this message in error, or are 
not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 
and delete this e-mail message from your computer, Thank 
you.*2

RE: ??? Linux/Oracle 8.1.7 2GB file size limit ???

Well... datafiles  2GB seem to work okay but since Oracle is being a weenie about 
supporting them altogether I'm choosing not to. One of the first hoops OWS had me jump 
thru in the wild goose chase was to manually extend datafiles via maxsize without 
using unlimited. Eventually the only workarounds suggested by Oracle were: 1) turn 
off autoextend and manually add datafiles; 2) upgrade to 9i.



-Original Message-
Sent: Wednesday, June 04, 2003 12:10 PM
To: Multiple recipients of list ORACLE-L


Steve - are you saying that there is a workaround by increasing the size of
the file manually to something larger than 4G?

Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Wednesday, June 04, 2003 1:25 PM
To: Multiple recipients of list ORACLE-L


See my note: There is no such O/S file size limit.

We have datafiles  2GB which work just fine. The problem is with
autoextending datafiles that extend from 2GB to 2GB. It's not a Linux
limitation but a limitation imposed by Oracle's implementation on Linux.
Oracle 9i on Linux doesn't have this problem. And my peeve is that it took
OWS 4 days to discover this limit.


Still peeved,  :-)
Steve



-Original Message-
Sent: Wednesday, June 04, 2003 10:55 AM
To: Multiple recipients of list ORACLE-L


I think it is the limitation of Linux, not Oracle.
Use LVM and don't worry about file size limit. :-)

JP
- Original Message - 
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, June 04, 2003 5:40 PM


 I've just been informed that there is a 2GB datafile size limit with
Oracle 8.1.7 on Linux... PERIOD. This despite the fact that we've had files
in excess of this for some time and they work just fine. The problem occurs
when the autoextend feature reaches the 2GB threshhold. Of course, Oracle
didn't tell me this until after about 4 days of back and forth testing for
them. (There is no such O/S file size limit.) I've reviewed the Linux
release notes, the Linux install guide, the Linux admin guide and the
contents of $ORACLE_HOME/relnotes and I don't find any such limitation in
the documentation. Did I miss it? Can anyone find any such published
limitation in the docs? Is this a secret?


 Peeved at Oracle... AGAIN,
 Steve Orr
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 -- 
 Author: Orr, Steve
   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-Mail message
 to: [EMAIL PROTECTED] (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).


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jan Pruner
  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-Mail message
to: [EMAIL PROTECTED] (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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Orr, Steve
  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-Mail message
to: [EMAIL PROTECTED] (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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Mercadante, Thomas F
  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-Mail message
to: [EMAIL PROTECTED] (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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Orr, Steve
  INET:

RE: Those installing Oracle 9i on AIX 5.2L

Title: Those installing Oracle 9i on AIX 5.2L



But it is on disk 1 of the installation set for 5L!

April Wells Oracle DBA/Oracle Apps DBA Corporate Systems Amarillo Texas 
You will recognize your own path when you 
come upon it, because you will suddenly have all the energy and imagination you 
will ever need.
~ Jerry Gillies ~ 

  -Original Message-From: Ruth Gramolini 
  [mailto:[EMAIL PROTECTED]Sent: Wednesday, June 04, 2003 
  1:42 PMTo: Multiple recipients of list ORACLE-LSubject: 
  Re: Those installing Oracle 9i on AIX 5.2L
  Raj,
  
  Here was what my SA (Claus)sent me when I 
  asked him what we did special to AIX that Oracle required:
  
  
  Standard 5.2 installation with 64-bit support and the basic JFS 
  filesystem.Graphics were included (Oracle needs X windows).Only 
  extra thing to install was bos.adt.libm.Oracle needs libm.a but the Base 
  Application Development Math Library(bos.adt.libm) is not installed by 
  default.-Claus
  
  Hope this helps! 
  Ruth
  
- Original Message - 
From: 
Jamadagni, Rajendra 
To: Multiple recipients of list ORACLE-L 

Sent: Monday, June 02, 2003 8:39 
AM
Subject: Those installing Oracle 9i on 
AIX 5.2L

Hi all, 
If you are installing or upgrading 
9202/9203 on AIX 5.2L (64Bit), do you have a list of APARS that _must_ be 
installed? 
I am talking about regatta (p690) servers 
if that matters ... 
Thanks in advance Raj  
Rajendra dot Jamadagni at nospamespn dot 
com All Views expressed in this 
email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! 

The information contained in this communication, including attachments, is strictly 
confidential and for the intended use of the addressee only; it may also contain 
proprietary, price sensitive, or legally privileged information. Notice is hereby given that 
any disclosure, distribution, dissemination, use, or copying of the information by anyone 
other than the intended recipient is strictly prohibited and may be illegal. If you have 
received this communication in error, please notify the sender immediately by reply e-mail, 
delete this communication, and destroy all copies.
 

Corporate Systems, Inc. has taken reasonable precautions to ensure that any attachment to 
this e-mail has been swept for viruses. We specifically disclaim all liability and will 
accept no responsibility for any damage sustained as a result of software viruses and advise 
you to carry out your own virus checks before opening any attachment.

RE: Those installing Oracle 9i on AIX 5.2L

2003-06-05 Thread Jamadagni, Rajendra

Title: Those installing Oracle 9i on AIX 5.2L



Thanks for reminding ... we have been through this about 4 times ... once 
it almost brought down the system, but luckily we shut down the affected site 
and the other side supported the users while we screamed at 
Oracle.

Raj
 
Rajendra dot Jamadagni at nospamespn dot 
com All Views expressed in this email 
are strictly personal. QOTD: Any clod 
can have facts, having an opinion is an art ! 

  -Original Message-From: Ruth Gramolini 
  [mailto:[EMAIL PROTECTED]Sent: Wednesday, June 04, 2003 
  2:51 PMTo: Multiple recipients of list ORACLE-LSubject: 
  Re: Those installing Oracle 9i on AIX 5.2L
  Raj,
  
  On more thing to remember. If you are going 
  to apply the 9.2.0.3 patchset, be sure to pick the 5L version, not the RS6000 
  version of the patchset to download. If you pick the wrong one, it will 
  be full of errors. If you pick the 5L version, it installed for me 
  without error.
  
  Ruth
  
- Original Message - 
From: 
Jamadagni, Rajendra 
To: Multiple recipients of list ORACLE-L 

Sent: Monday, June 02, 2003 8:39 
AM
Subject: Those installing Oracle 9i on 
AIX 5.2L

Hi all, 
If you are installing or upgrading 
9202/9203 on AIX 5.2L (64Bit), do you have a list of APARS that _must_ be 
installed? 
I am talking about regatta (p690) servers 
if that matters ... 
Thanks in advance Raj  
Rajendra dot Jamadagni at nospamespn dot 
com All Views expressed in this 
email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! 

*This e-mail 
message is confidential, intended only for the named recipient(s) above and may 
contain information that is privileged, attorney work product or exempt from 
disclosure under applicable law. If you have received this message in error, or are 
not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 
and delete this e-mail message from your computer, Thank 
you.*1

RE: Those installing Oracle 9i on AIX 5.2L

Title: Those installing Oracle 9i on AIX 5.2L



I got several "can't write to insert string.so" errors... but 
renaming those files allowed it to finish... and I always get those 
errors.

April Wells Oracle DBA/Oracle Apps DBA Corporate Systems Amarillo Texas 
You will recognize your own path when you 
come upon it, because you will suddenly have all the energy and imagination you 
will ever need.
~ Jerry Gillies ~ 

  -Original Message-From: Ruth Gramolini 
  [mailto:[EMAIL PROTECTED]Sent: Wednesday, June 04, 2003 
  1:51 PMTo: Multiple recipients of list ORACLE-LSubject: 
  Re: Those installing Oracle 9i on AIX 5.2L
  Raj,
  
  On more thing to remember. If you are going 
  to apply the 9.2.0.3 patchset, be sure to pick the 5L version, not the RS6000 
  version of the patchset to download. If you pick the wrong one, it will 
  be full of errors. If you pick the 5L version, it installed for me 
  without error.
  
  Ruth
  
- Original Message - 
From: 
Jamadagni, Rajendra 
To: Multiple recipients of list ORACLE-L 

Sent: Monday, June 02, 2003 8:39 
AM
Subject: Those installing Oracle 9i on 
AIX 5.2L

Hi all, 
If you are installing or upgrading 
9202/9203 on AIX 5.2L (64Bit), do you have a list of APARS that _must_ be 
installed? 
I am talking about regatta (p690) servers 
if that matters ... 
Thanks in advance Raj  
Rajendra dot Jamadagni at nospamespn dot 
com All Views expressed in this 
email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! 

The information contained in this communication, including attachments, is strictly 
confidential and for the intended use of the addressee only; it may also contain 
proprietary, price sensitive, or legally privileged information. Notice is hereby given that 
any disclosure, distribution, dissemination, use, or copying of the information by anyone 
other than the intended recipient is strictly prohibited and may be illegal. If you have 
received this communication in error, please notify the sender immediately by reply e-mail, 
delete this communication, and destroy all copies.
 

Corporate Systems, Inc. has taken reasonable precautions to ensure that any attachment to 
this e-mail has been swept for viruses. We specifically disclaim all liability and will 
accept no responsibility for any damage sustained as a result of software viruses and advise 
you to carry out your own virus checks before opening any attachment.

RE: ??? Linux/Oracle 8.1.7 2GB file size limit ???

Steve - Is there a Metalink note on this? What would a person search for?

Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED] 


-Original Message-
Sent: Wednesday, June 04, 2003 12:25 PM
To: Multiple recipients of list ORACLE-L


See my note: There is no such O/S file size limit.

We have datafiles  2GB which work just fine. The problem is with
autoextending datafiles that extend from 2GB to 2GB. It's not a Linux
limitation but a limitation imposed by Oracle's implementation on Linux.
Oracle 9i on Linux doesn't have this problem. And my peeve is that it took
OWS 4 days to discover this limit.


Still peeved,  :-)
Steve



-Original Message-
Sent: Wednesday, June 04, 2003 10:55 AM
To: Multiple recipients of list ORACLE-L


I think it is the limitation of Linux, not Oracle.
Use LVM and don't worry about file size limit. :-)

JP
- Original Message - 
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, June 04, 2003 5:40 PM


 I've just been informed that there is a 2GB datafile size limit with
Oracle 8.1.7 on Linux... PERIOD. This despite the fact that we've had files
in excess of this for some time and they work just fine. The problem occurs
when the autoextend feature reaches the 2GB threshhold. Of course, Oracle
didn't tell me this until after about 4 days of back and forth testing for
them. (There is no such O/S file size limit.) I've reviewed the Linux
release notes, the Linux install guide, the Linux admin guide and the
contents of $ORACLE_HOME/relnotes and I don't find any such limitation in
the documentation. Did I miss it? Can anyone find any such published
limitation in the docs? Is this a secret?


 Peeved at Oracle... AGAIN,
 Steve Orr
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 -- 
 Author: Orr, Steve
   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-Mail message
 to: [EMAIL PROTECTED] (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).


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jan Pruner
  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-Mail message
to: [EMAIL PROTECTED] (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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Orr, Steve
  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-Mail message
to: [EMAIL PROTECTED] (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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: DENNIS WILLIAMS
  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-Mail message
to: [EMAIL PROTECTED] (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).

RE: ??? Linux/Oracle 8.1.7 2GB file size limit ???

2003-06-05 Thread Mercadante, Thomas F

nice.  either way, you're screwed into doing more work than you had planned.

Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Wednesday, June 04, 2003 3:05 PM
To: Multiple recipients of list ORACLE-L


Well... datafiles  2GB seem to work okay but since Oracle is being a weenie
about supporting them altogether I'm choosing not to. One of the first hoops
OWS had me jump thru in the wild goose chase was to manually extend
datafiles via maxsize without using unlimited. Eventually the only
workarounds suggested by Oracle were: 1) turn off autoextend and manually
add datafiles; 2) upgrade to 9i.



-Original Message-
Sent: Wednesday, June 04, 2003 12:10 PM
To: Multiple recipients of list ORACLE-L


Steve - are you saying that there is a workaround by increasing the size of
the file manually to something larger than 4G?

Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Wednesday, June 04, 2003 1:25 PM
To: Multiple recipients of list ORACLE-L


See my note: There is no such O/S file size limit.

We have datafiles  2GB which work just fine. The problem is with
autoextending datafiles that extend from 2GB to 2GB. It's not a Linux
limitation but a limitation imposed by Oracle's implementation on Linux.
Oracle 9i on Linux doesn't have this problem. And my peeve is that it took
OWS 4 days to discover this limit.


Still peeved,  :-)
Steve



-Original Message-
Sent: Wednesday, June 04, 2003 10:55 AM
To: Multiple recipients of list ORACLE-L


I think it is the limitation of Linux, not Oracle.
Use LVM and don't worry about file size limit. :-)

JP
- Original Message - 
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, June 04, 2003 5:40 PM


 I've just been informed that there is a 2GB datafile size limit with
Oracle 8.1.7 on Linux... PERIOD. This despite the fact that we've had files
in excess of this for some time and they work just fine. The problem occurs
when the autoextend feature reaches the 2GB threshhold. Of course, Oracle
didn't tell me this until after about 4 days of back and forth testing for
them. (There is no such O/S file size limit.) I've reviewed the Linux
release notes, the Linux install guide, the Linux admin guide and the
contents of $ORACLE_HOME/relnotes and I don't find any such limitation in
the documentation. Did I miss it? Can anyone find any such published
limitation in the docs? Is this a secret?


 Peeved at Oracle... AGAIN,
 Steve Orr
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 -- 
 Author: Orr, Steve
   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-Mail message
 to: [EMAIL PROTECTED] (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).


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jan Pruner
  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-Mail message
to: [EMAIL PROTECTED] (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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Orr, Steve
  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-Mail message
to: [EMAIL PROTECTED] (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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Mercadante, Thomas F
  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-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or

Re[2]: performance questions

2003-06-05 Thread Jonathan Gennick

Tuesday, June 3, 2003, 10:59:42 PM, you wrote:
MR 3)  If the company has done something which makes it impossible for the
MR service provider to maintain the SLA then re-negotiation is required.

This is probably harder than it sounds. How does the
service-provider prove that the client has done something
that makes it impossible for the service-provider to
maintain the SLA?

Best regards,

Jonathan Gennick --- Brighten the corner where you are
http://Gennick.com * 906.387.1698 * mailto:[EMAIL PROTECTED]

Join the Oracle-article list and receive one
article on Oracle technologies per month by 
email. To join, visit http://four.pairlist.net/mailman/listinfo/oracle-article, 
or send email to [EMAIL PROTECTED] and 
include the word subscribe in either the subject or body.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jonathan Gennick
  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-Mail message
to: [EMAIL PROTECTED] (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).

RE: ??? Linux/Oracle 8.1.7 2GB file size limit ???

Yeah, now I call it the outta-extend feature.  :-)

-Original Message-
Sent: Wednesday, June 04, 2003 12:28 PM
To: '[EMAIL PROTECTED]'
Cc: Orr, Steve

nice.  either way, you're screwed into doing more work than you had planned.

Tom Mercadante
Oracle Certified Professional

-Original Message-
Sent: Wednesday, June 04, 2003 3:05 PM
To: Multiple recipients of list ORACLE-L

Well... datafiles  2GB seem to work okay but since Oracle is being a weenie
about supporting them altogether I'm choosing not to. One of the first hoops
OWS had me jump thru in the wild goose chase was to manually extend
datafiles via maxsize without using unlimited. Eventually the only
workarounds suggested by Oracle were: 1) turn off autoextend and manually
add datafiles; 2) upgrade to 9i.

-Original Message-
Sent: Wednesday, June 04, 2003 12:10 PM
To: Multiple recipients of list ORACLE-L

Steve - are you saying that there is a workaround by increasing the size of
the file manually to something larger than 4G?

Tom Mercadante
Oracle Certified Professional

-Original Message-
Sent: Wednesday, June 04, 2003 1:25 PM
To: Multiple recipients of list ORACLE-L

See my note: There is no such O/S file size limit.

We have datafiles  2GB which work just fine. The problem is with
autoextending datafiles that extend from 2GB to 2GB. It's not a Linux
limitation but a limitation imposed by Oracle's implementation on Linux.
Oracle 9i on Linux doesn't have this problem. And my peeve is that it took
OWS 4 days to discover this limit.

Still peeved,  :-)
Steve

-Original Message-
Sent: Wednesday, June 04, 2003 10:55 AM
To: Multiple recipients of list ORACLE-L

I think it is the limitation of Linux, not Oracle.
Use LVM and don't worry about file size limit. :-)

JP
- Original Message - 
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, June 04, 2003 5:40 PM

 I've just been informed that there is a 2GB datafile size limit with
Oracle 8.1.7 on Linux... PERIOD. This despite the fact that we've had files
in excess of this for some time and they work just fine. The problem occurs
when the autoextend feature reaches the 2GB threshhold. Of course, Oracle
didn't tell me this until after about 4 days of back and forth testing for
them. (There is no such O/S file size limit.) I've reviewed the Linux
release notes, the Linux install guide, the Linux admin guide and the
contents of $ORACLE_HOME/relnotes and I don't find any such limitation in
the documentation. Did I miss it? Can anyone find any such published
limitation in the docs? Is this a secret?

 Peeved at Oracle... AGAIN,
 Steve Orr
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 -- 
 Author: Orr, Steve
   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-Mail message
 to: [EMAIL PROTECTED] (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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jan Pruner
  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-Mail message
to: [EMAIL PROTECTED] (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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Orr, Steve
  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-Mail message
to: [EMAIL PROTECTED] (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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Mercadante, Thomas F
  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

RE: Limiting Concurrent Sessions Not Working

2003-06-05 Thread Sam Bootsma










Bingo!



Thanks Dick, it is working now.





Sam

GBC





-Original Message-
From: Goulet, Dick
[mailto:[EMAIL PROTECTED] 
Sent: June 4, 2003 2:30 PM
To: Multiple recipients of list
ORACLE-L
Subject: RE: Limiting Concurrent
Sessions Not Working





Do you
have resource_limit = true in init.ora? If you don't it
defaults to FALSE  the profile has no effect.









Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA 

-Original Message-
From: Sam Bootsma
[mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 04, 2003
2:10 PM
To: Multiple recipients of list
ORACLE-L
Subject: Limiting Concurrent
Sessions Not Working

Oracle7 Server Release 7.3.4.5.0
(yes, I know, old); AIX 4.3.3 



Hello All,



I am trying to limit concurrent sessions
on my database. The Oracle documentation says I can do it. However,
when I follow the steps (create profile with sessions per user set to one, then
assign Oracle user to this profile) the user is not stopped from exceeding the
number of concurrent sessions. I tested this by connecting using Sql
Plus. I even tried bouncing the database, to see if that makes a
difference, but to no avail. 



Any ideas what is happening?
Am I missing something? Is this a problem/bug with Oracle 7.3.4?
The output below shows the steps I followed to create the profile and
user. It also shows multiple connections to the database after bouncing
the instance.



Thanks for any suggestions!



Sam.









SQL create profile sam limit
sessions_per_user 1;



Profile created.



SQL create user sam identified
by sam;



User created.



SQL alter user sam profile sam;



User altered.



SQL grant create session to sam;



Grant succeeded.



SQL 



SQL l

 1 select limit

 2 from dba_profiles

 3 where profile=''

 4* and resource_name =
'SESSIONS_PER_USER'

SQL /



LIMIT



1



SQL 



SQL select profile

 2 from dba_users

 3 where username =
'SAM';



PROFILE

--

SAM



SQL



SVRMGR shutdown normal

Database closed.

Database dismounted.

ORACLE instance shut down.



SVRMGR connect internal

Connected to an idle instance.

SVRMGR startup

ORACLE instance started.

Total System Global
Area 34122296 bytes

Fixed
Size
38992 bytes

Variable
Size
31797736 bytes

Database
Buffers
2252800 bytes

Redo
Buffers
32768 bytes

Database mounted.

Database opened.

SVRMGR select osuser, username

 2 from
v$session; 

OSUSER
USERNAME


---
--

oracle


oracle


oracle


oracle


oracle


oracle


oracle


oracle


oracle


oracle


oracle


oracle
SYS


12 rows selected.

SVRMGR select osuser, username
from v$session;

OSUSER
USERNAME


---
--

oracle


oracle


oracle


oracle


oracle


oracle


oracle


oracle


oracle


oracle


oracle


oracle
SYS


sam
SAM


sam
SAM


14 rows selected.

SVRMGR



Sam 

GBC

RE: ??? Linux/Oracle 8.1.7 2GB file size limit ???

Nevermind, a search on 2gb yielded Note 112011.1, which seems to explain
it all. Oh well, one more item for my to do list.

Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED] 


-Original Message-
Sent: Wednesday, June 04, 2003 2:30 PM
To: Multiple recipients of list ORACLE-L


Steve - Is there a Metalink note on this? What would a person search for?

Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED] 


-Original Message-
Sent: Wednesday, June 04, 2003 12:25 PM
To: Multiple recipients of list ORACLE-L


See my note: There is no such O/S file size limit.

We have datafiles  2GB which work just fine. The problem is with
autoextending datafiles that extend from 2GB to 2GB. It's not a Linux
limitation but a limitation imposed by Oracle's implementation on Linux.
Oracle 9i on Linux doesn't have this problem. And my peeve is that it took
OWS 4 days to discover this limit.


Still peeved,  :-)
Steve



-Original Message-
Sent: Wednesday, June 04, 2003 10:55 AM
To: Multiple recipients of list ORACLE-L


I think it is the limitation of Linux, not Oracle.
Use LVM and don't worry about file size limit. :-)

JP
- Original Message - 
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, June 04, 2003 5:40 PM


 I've just been informed that there is a 2GB datafile size limit with
Oracle 8.1.7 on Linux... PERIOD. This despite the fact that we've had files
in excess of this for some time and they work just fine. The problem occurs
when the autoextend feature reaches the 2GB threshhold. Of course, Oracle
didn't tell me this until after about 4 days of back and forth testing for
them. (There is no such O/S file size limit.) I've reviewed the Linux
release notes, the Linux install guide, the Linux admin guide and the
contents of $ORACLE_HOME/relnotes and I don't find any such limitation in
the documentation. Did I miss it? Can anyone find any such published
limitation in the docs? Is this a secret?


 Peeved at Oracle... AGAIN,
 Steve Orr
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 -- 
 Author: Orr, Steve
   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-Mail message
 to: [EMAIL PROTECTED] (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).


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jan Pruner
  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-Mail message
to: [EMAIL PROTECTED] (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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Orr, Steve
  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-Mail message
to: [EMAIL PROTECTED] (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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: DENNIS WILLIAMS
  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-Mail message
to: [EMAIL PROTECTED] (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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: DENNIS WILLIAMS
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-

RE: ??? Linux/Oracle 8.1.7 2GB file size limit ???

Title: RE: ??? Linux/Oracle 8.1.7 2GB file size limit ???





Upgrading was number 2?


NO way!?! I am (genuinely) surprised that it wasn't number 1 suggestion... 


April Wells
Oracle DBA/Oracle Apps DBA
Corporate Systems
Amarillo Texas


You will recognize your own path when you come upon it, because you will suddenly have all the energy and imagination you will ever need.

~ Jerry Gillies ~




-Original Message-
From: Orr, Steve [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, June 04, 2003 2:05 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: ??? Linux/Oracle 8.1.7 2GB file size limit ???



Well... datafiles  2GB seem to work okay but since Oracle is being a weenie about supporting them altogether I'm choosing not to. One of the first hoops OWS had me jump thru in the wild goose chase was to manually extend datafiles via maxsize without using unlimited. Eventually the only workarounds suggested by Oracle were: 1) turn off autoextend and manually add datafiles; 2) upgrade to 9i.



-Original Message-
Sent: Wednesday, June 04, 2003 12:10 PM
To: Multiple recipients of list ORACLE-L



Steve - are you saying that there is a workaround by increasing the size of
the file manually to something larger than 4G?


Tom Mercadante
Oracle Certified Professional



-Original Message-
Sent: Wednesday, June 04, 2003 1:25 PM
To: Multiple recipients of list ORACLE-L



See my note: There is no such O/S file size limit.


We have datafiles  2GB which work just fine. The problem is with
autoextending datafiles that extend from 2GB to 2GB. It's not a Linux
limitation but a limitation imposed by Oracle's implementation on Linux.
Oracle 9i on Linux doesn't have this problem. And my peeve is that it took
OWS 4 days to discover this limit.



Still peeved, :-)
Steve




-Original Message-
Sent: Wednesday, June 04, 2003 10:55 AM
To: Multiple recipients of list ORACLE-L



I think it is the limitation of Linux, not Oracle.
Use LVM and don't worry about file size limit. :-)


JP
- Original Message - 
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, June 04, 2003 5:40 PM



 I've just been informed that there is a 2GB datafile size limit with
Oracle 8.1.7 on Linux... PERIOD. This despite the fact that we've had files
in excess of this for some time and they work just fine. The problem occurs
when the autoextend feature reaches the 2GB threshhold. Of course, Oracle
didn't tell me this until after about 4 days of back and forth testing for
them. (There is no such O/S file size limit.) I've reviewed the Linux
release notes, the Linux install guide, the Linux admin guide and the
contents of $ORACLE_HOME/relnotes and I don't find any such limitation in
the documentation. Did I miss it? Can anyone find any such published
limitation in the docs? Is this a secret?


 Peeved at Oracle... AGAIN,
 Steve Orr
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 -- 
 Author: Orr, Steve
 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-Mail message
 to: [EMAIL PROTECTED] (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).



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jan Pruner
 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-Mail message
to: [EMAIL PROTECTED] (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).


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Orr, Steve
 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-Mail message
to: [EMAIL PROTECTED] (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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Mercadante, Thomas F
 INET: [EMAIL PROTECTED]


Fat City Network Services -- 858-538-5051

RE: ??? Linux/Oracle 8.1.7 2GB file size limit ???

As per Branimer's previous post, try searching under dirty little secrets. :-)


-Original Message-
Sent: Wednesday, June 04, 2003 1:30 PM
To: Multiple recipients of list ORACLE-L


Steve - Is there a Metalink note on this? What would a person search for?

Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED] 


-Original Message-
Sent: Wednesday, June 04, 2003 12:25 PM
To: Multiple recipients of list ORACLE-L


See my note: There is no such O/S file size limit.

We have datafiles  2GB which work just fine. The problem is with
autoextending datafiles that extend from 2GB to 2GB. It's not a Linux
limitation but a limitation imposed by Oracle's implementation on Linux.
Oracle 9i on Linux doesn't have this problem. And my peeve is that it took
OWS 4 days to discover this limit.


Still peeved,  :-)
Steve



-Original Message-
Sent: Wednesday, June 04, 2003 10:55 AM
To: Multiple recipients of list ORACLE-L


I think it is the limitation of Linux, not Oracle.
Use LVM and don't worry about file size limit. :-)

JP
- Original Message - 
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, June 04, 2003 5:40 PM


 I've just been informed that there is a 2GB datafile size limit with
Oracle 8.1.7 on Linux... PERIOD. This despite the fact that we've had files
in excess of this for some time and they work just fine. The problem occurs
when the autoextend feature reaches the 2GB threshhold. Of course, Oracle
didn't tell me this until after about 4 days of back and forth testing for
them. (There is no such O/S file size limit.) I've reviewed the Linux
release notes, the Linux install guide, the Linux admin guide and the
contents of $ORACLE_HOME/relnotes and I don't find any such limitation in
the documentation. Did I miss it? Can anyone find any such published
limitation in the docs? Is this a secret?


 Peeved at Oracle... AGAIN,
 Steve Orr
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 -- 
 Author: Orr, Steve
   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-Mail message
 to: [EMAIL PROTECTED] (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).


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jan Pruner
  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-Mail message
to: [EMAIL PROTECTED] (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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Orr, Steve
  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-Mail message
to: [EMAIL PROTECTED] (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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: DENNIS WILLIAMS
  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-Mail message
to: [EMAIL PROTECTED] (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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Orr, Steve
  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-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of

RE: ??? Linux/Oracle 8.1.7 2GB file size limit ???

It doesn't seem to be a problem on other platforms... Just when I stopped feeling like 
a neglected step child for running on Linux. Don't worry... Be happy... There's a 
workaround... Upgrade and buy more software...

D'ai jobu desu... er, eh, Ca ne fais rien.


-Original Message-
Sent: Wednesday, June 04, 2003 12:46 PM
To: Multiple recipients of list ORACLE-L


This almost sounds like the problem that existed for Oracle 7.3 and the 2G
threshold a couple of years ago...

J'ai une impression d'avoir déjà vu ceci.

: )

Patrice.

-Original Message-
Sent: Wednesday, June 04, 2003 3:10 PM
To: Multiple recipients of list ORACLE-L


Steve - are you saying that there is a workaround by increasing the size of
the file manually to something larger than 4G?

Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Wednesday, June 04, 2003 1:25 PM
To: Multiple recipients of list ORACLE-L


See my note: There is no such O/S file size limit.

We have datafiles  2GB which work just fine. The problem is with
autoextending datafiles that extend from 2GB to 2GB. It's not a Linux
limitation but a limitation imposed by Oracle's implementation on Linux.
Oracle 9i on Linux doesn't have this problem. And my peeve is that it took
OWS 4 days to discover this limit.


Still peeved,  :-)
Steve



-Original Message-
Sent: Wednesday, June 04, 2003 10:55 AM
To: Multiple recipients of list ORACLE-L


I think it is the limitation of Linux, not Oracle.
Use LVM and don't worry about file size limit. :-)

JP
- Original Message - 
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, June 04, 2003 5:40 PM


 I've just been informed that there is a 2GB datafile size limit with
Oracle 8.1.7 on Linux... PERIOD. This despite the fact that we've had files
in excess of this for some time and they work just fine. The problem occurs
when the autoextend feature reaches the 2GB threshhold. Of course, Oracle
didn't tell me this until after about 4 days of back and forth testing for
them. (There is no such O/S file size limit.) I've reviewed the Linux
release notes, the Linux install guide, the Linux admin guide and the
contents of $ORACLE_HOME/relnotes and I don't find any such limitation in
the documentation. Did I miss it? Can anyone find any such published
limitation in the docs? Is this a secret?


 Peeved at Oracle... AGAIN,
 Steve Orr
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 -- 
 Author: Orr, Steve
   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-Mail message
 to: [EMAIL PROTECTED] (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).


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jan Pruner
  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-Mail message
to: [EMAIL PROTECTED] (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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Orr, Steve
  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-Mail message
to: [EMAIL PROTECTED] (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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Mercadante, Thomas F
  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-Mail message
to: [EMAIL PROTECTED] (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

RE: ??? Linux/Oracle 8.1.7 2GB file size limit ???

2003-06-05 Thread Matthew Zito

Title: Message

Oracle
8i on linux, while functional, definitely had/has a whole boatload of
problems. 9i is much better all around, and I'm not surprised that Oracle
support is pushing it heavily. We're getting a lot of customers that are
trying to get off 8i because of problems like this one, plus that 8.1.7 is the
terminal release for 8i and they're tired of getting flack from Oracle
support.

Thanks,
Matt
--Matthew ZitoGridApp SystemsEmail:
[EMAIL PROTECTED]Cell: 646-220-3551Phone: 212-358-8211 x 359

-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of April WellsSent:
Wednesday, June 04, 2003 2:30 PMTo: Multiple recipients of list
ORACLE-LSubject: RE: ??? Linux/Oracle 8.1.7 2GB file size limit
???
Upgrading was number 2?
NO way!?! I am (genuinely) surprised that it wasn't
number 1 suggestion...
April Wells Oracle DBA/Oracle Apps
DBA Corporate Systems Amarillo
Texas
You will recognize your own path when you come upon it,
because you will suddenly have all the energy and imagination you will ever
need.
~ Jerry Gillies ~
-Original Message- From: Orr,
Steve [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, June 04, 2003 2:05 PM To: Multiple recipients of list ORACLE-L Subject: RE: ??? Linux/Oracle 8.1.7 2GB file size limit ???

Well... datafiles 2GB seem to work okay but since Oracle
is being a weenie about supporting them altogether I'm choosing not to. One of
the first hoops OWS had me jump thru in the wild goose chase was to manually
extend datafiles via maxsize without using "unlimited." Eventually the only
workarounds suggested by Oracle were: 1) turn off autoextend and manually add
datafiles; 2) upgrade to 9i.
-Original Message- Sent:
Wednesday, June 04, 2003 12:10 PM To: Multiple
recipients of list ORACLE-L
Steve - are you saying that there is a workaround by
increasing the size of the file manually to something
larger than 4G?
Tom Mercadante Oracle Certified
Professional
-Original Message- Sent:
Wednesday, June 04, 2003 1:25 PM To: Multiple
recipients of list ORACLE-L
See my note: "There is no such O/S file size limit."

We have datafiles 2GB which work just fine. The problem
is with autoextending datafiles that extend from
2GB to 2GB. It's not a Linux limitation but a
limitation imposed by Oracle's implementation on Linux. Oracle 9i on Linux doesn't have this problem. And my peeve is that it
took OWS 4 days to "discover" this "limit."

Still peeved, :-) Steve

-Original Message- Sent:
Wednesday, June 04, 2003 10:55 AM To: Multiple
recipients of list ORACLE-L
I think it is the limitation of Linux, not Oracle.
Use LVM and don't worry about file size limit. :-)

JP - Original Message -
To: "Multiple recipients of list ORACLE-L"
[EMAIL PROTECTED] Sent: Wednesday, June 04,
2003 5:40 PM
I've just been informed that there is a 2GB datafile size
limit with Oracle 8.1.7 on Linux... PERIOD. This
despite the fact that we've had files in excess of
this for some time and they work just fine. The problem occurs
when the autoextend "feature" reaches the 2GB threshhold. Of
course, Oracle didn't tell me this until after about 4
days of back and forth testing for them. (There is no
such O/S file size limit.) I've reviewed the Linux release notes, the Linux install guide, the Linux admin guide and
the contents of $ORACLE_HOME/relnotes and I don't find
any such limitation in the documentation. Did I miss
it? Can anyone find any such published limitation in
the docs? Is this a secret?Peeved at Oracle... AGAIN,
Steve Orr --
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- Author: Orr,
Steve 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-Mail message to: [EMAIL PROTECTED] (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).
-- Please see the official ORACLE-L
FAQ: http://www.orafaq.net --
Author: Jan Pruner
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-Mail
message to: [EMAIL PROTECTED] (note EXACT spelling
of 'ListGuru') and in the message BODY, include a line
containing: UNSUB ORACLE-L (or

RE: Those installing Oracle 9i on AIX 5.2L

As root, from other session, you can run 'slibclean' (check the man pages for more 
info).  
Then there is no need to rename/remove so *.so library files. 

- Kirti 


--- April Wells [EMAIL PROTECTED] wrote:
 
 I got several can't write to insert string.so errors... but renaming
 those files allowed it to finish... and I always get those errors.
  
 
 April Wells 
 Oracle DBA/Oracle Apps DBA 
 Corporate Systems 
 Amarillo Texas 
 
 You will recognize your own path when you come upon it, because you will
 suddenly have all the energy and imagination you will ever need.
 
 ~ Jerry Gillies ~ 
 
 -Original Message-
 Sent: Wednesday, June 04, 2003 1:51 PM
 To: Multiple recipients of list ORACLE-L
 
 
 Raj,
  
 On more thing to remember.  If you are going to apply the 9.2.0.3 patchset,
 be sure to pick the 5L version, not the RS6000 version of the patchset to
 download.  If you pick the wrong one, it will be full of errors.  If you
 pick the 5L version, it installed for me without error.
  
 Ruth
 
 - Original Message - 
 To: Multiple recipients of list ORACLE-L mailto:[EMAIL PROTECTED]  
 Sent: Monday, June 02, 2003 8:39 AM
 
 
 Hi all, 
 
 If you are installing or upgrading 9202/9203 on AIX 5.2L (64Bit), do you
 have a list of APARS that _must_ be installed? 
 
 I am talking about regatta (p690) servers if that matters ... 
 
 Thanks in advance 
 Raj 
 


__
Do you Yahoo!?
Yahoo! Calendar - Free online calendar with sync to Outlook(TM).
http://calendar.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Kirtikumar Deshpande
  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-Mail message
to: [EMAIL PROTECTED] (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).

RE: Limiting Concurrent Sessions Not Working




OK, 
now watch out for Oracle bug 643709 which can send your users a 
pile of "ORA-02394: exceeded session limit on IO usage, you are 
being logged off" even though you don't have any IO limits set. It's 
fixed in 8.1.x.

Dick GouletSenior Oracle DBAOracle Certified 8i DBA 

-Original Message-From: Sam Bootsma 
[mailto:[EMAIL PROTECTED]Sent: Wednesday, June 04, 2003 3:30 
PMTo: Multiple recipients of list ORACLE-LSubject: RE: 
Limiting Concurrent Sessions Not Working

Bingo!

Thanks Dick, it is 
working now.


Sam
GBC

-Original 
Message-From: Goulet, Dick 
[mailto:[EMAIL PROTECTED] Sent: June 4, 
2003 2:30 
PMTo: Multiple recipients of list 
ORACLE-LSubject: RE: Limiting 
Concurrent Sessions Not Working


Do you 
have "resource_limit = true" in init.ora? If you don't it defaults to 
FALSE  the profile has no effect.


Dick GouletSenior Oracle DBAOracle Certified 8i 
DBA 
-Original 
Message-From: Sam Bootsma 
[mailto:[EMAIL PROTECTED]Sent: Wednesday, June 04, 2003 2:10 
PMTo: Multiple recipients of 
list ORACLE-LSubject: Limiting 
Concurrent Sessions Not Working
Oracle7 Server Release 7.3.4.5.0 
(yes, I know, old); AIX 4.3.3 

Hello All,

I am trying to limit concurrent 
sessions on my database. The Oracle documentation says I can do it. 
However, when I follow the steps (create profile with sessions per user set to 
one, then assign Oracle user to this profile) the user is not stopped from 
exceeding the number of concurrent sessions. I tested this by connecting 
using Sql Plus. I even tried bouncing the database, to see if that makes a 
difference, but to no avail. 

Any ideas what is happening? 
Am I missing something? Is this a problem/bug with Oracle 7.3.4? The 
output below shows the steps I followed to create the profile and user. It 
also shows multiple connections to the database after bouncing the 
instance.

Thanks for any 
suggestions!

Sam.



SQL create profile sam limit 
sessions_per_user 1;

Profile created.

SQL create user sam identified 
by sam;

User created.

SQL alter user sam profile 
sam;

User altered.

SQL grant create session to 
sam;

Grant succeeded.

SQL 

SQL l
 1 select 
limit
 2 from 
dba_profiles
 3 where 
profile=''
 4* and resource_name = 
'SESSIONS_PER_USER'
SQL /

LIMIT

1

SQL 

SQL select 
profile
 2 from 
dba_users
 3 where username = 
'SAM';

PROFILE
--
SAM

SQL

SVRMGR shutdown 
normal
Database closed.
Database 
dismounted.
ORACLE instance shut 
down.

SVRMGR connect 
internal
Connected to an idle 
instance.
SVRMGR startup
ORACLE instance 
started.
Total System Global 
Area 34122296 bytes
Fixed 
Size 
38992 bytes
Variable 
Size 
31797736 bytes
Database 
Buffers 
2252800 bytes
Redo 
Buffers 
32768 bytes
Database mounted.
Database opened.
SVRMGR select osuser, 
username
 2 from 
v$session; 
OSUSER 
USERNAME 

--- 
--
oracle 

oracle 

oracle 

oracle 

oracle 

oracle 

oracle 

oracle 

oracle 

oracle 

oracle 

oracle 
SYS 

12 rows selected.
SVRMGR select osuser, username 
from v$session;
OSUSER 
USERNAME 

--- 
--
oracle 

oracle 

oracle 

oracle 

oracle 

oracle 

oracle 

oracle 

oracle 

oracle 

oracle 

oracle 
SYS 

sam 
SAM 

sam 
SAM 

14 rows selected.
SVRMGR

Sam 
GBC

RE: ??? Linux/Oracle 8.1.7 2GB file size limit ???

Ahem . . . according to Note 112011.1, these problems can affect all
platforms except OS/390 which does NOT support datafile resizing
(fiendishly clever those mainframe types). 
It looks like 8.1.7.4 and above is not affected. I would highly recommend
that all Oracle DBAs take a look at this note.

Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED] 


-Original Message-
Sent: Wednesday, June 04, 2003 3:00 PM
To: Multiple recipients of list ORACLE-L


It doesn't seem to be a problem on other platforms... Just when I stopped
feeling like a neglected step child for running on Linux. Don't worry... Be
happy... There's a workaround... Upgrade and buy more software...

D'ai jobu desu... er, eh, Ca ne fais rien.


-Original Message-
Sent: Wednesday, June 04, 2003 12:46 PM
To: Multiple recipients of list ORACLE-L


This almost sounds like the problem that existed for Oracle 7.3 and the 2G
threshold a couple of years ago...

J'ai une impression d'avoir déjà vu ceci.

: )

Patrice.

-Original Message-
Sent: Wednesday, June 04, 2003 3:10 PM
To: Multiple recipients of list ORACLE-L


Steve - are you saying that there is a workaround by increasing the size of
the file manually to something larger than 4G?

Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Wednesday, June 04, 2003 1:25 PM
To: Multiple recipients of list ORACLE-L


See my note: There is no such O/S file size limit.

We have datafiles  2GB which work just fine. The problem is with
autoextending datafiles that extend from 2GB to 2GB. It's not a Linux
limitation but a limitation imposed by Oracle's implementation on Linux.
Oracle 9i on Linux doesn't have this problem. And my peeve is that it took
OWS 4 days to discover this limit.


Still peeved,  :-)
Steve



-Original Message-
Sent: Wednesday, June 04, 2003 10:55 AM
To: Multiple recipients of list ORACLE-L


I think it is the limitation of Linux, not Oracle.
Use LVM and don't worry about file size limit. :-)

JP
- Original Message - 
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, June 04, 2003 5:40 PM


 I've just been informed that there is a 2GB datafile size limit with
Oracle 8.1.7 on Linux... PERIOD. This despite the fact that we've had files
in excess of this for some time and they work just fine. The problem occurs
when the autoextend feature reaches the 2GB threshhold. Of course, Oracle
didn't tell me this until after about 4 days of back and forth testing for
them. (There is no such O/S file size limit.) I've reviewed the Linux
release notes, the Linux install guide, the Linux admin guide and the
contents of $ORACLE_HOME/relnotes and I don't find any such limitation in
the documentation. Did I miss it? Can anyone find any such published
limitation in the docs? Is this a secret?


 Peeved at Oracle... AGAIN,
 Steve Orr
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 -- 
 Author: Orr, Steve
   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-Mail message
 to: [EMAIL PROTECTED] (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).


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jan Pruner
  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-Mail message
to: [EMAIL PROTECTED] (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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Orr, Steve
  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-Mail message
to: [EMAIL PROTECTED] (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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Mercadante, Thomas F
  INET: [EMAIL PROTECTED]

Fat City

Problem using CLOB with ADO

2003-06-05 Thread Yadav, Shailesh

Hello List,

  We are developing an application using Visual Basic and Microsoft ADO. We
are also using Oracle Provider for OLE DB and the database is Oracle 8.1.7.
We were using client side cursors in application and had some problems. We
switched to server side cursors and explicit Begin and End transactions as
per Oracle documentation and noticed that triggers were firing each time the
clob was updated. The problem seems to be that Oracle submits the changes to
clob(when using serverside cursors in application) immediately and also
fires the trigger on that row if the. 
The work around was to initialize clobs when the record was inserted and
thus the trigger fired only once. 
However the problem now is that if an error is raised by a trigger with a
CLOB. the application get the error ROW-00060: Internal error:
[daputchunk,2]. Has anyone ever come across this problem. Any insight would
be highy appreciated.

thanks,
Shailesh
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Yadav, Shailesh
  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-Mail message
to: [EMAIL PROTECTED] (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).

RE: ??? Linux/Oracle 8.1.7 2GB file size limit ???

We are on 8.1.7.4 and it aflicted us anyway. Maybe I'll just wait a couple of years 
and let other customers QA this Oracle feature until they get it right.


Steve


-Original Message-
Sent: Wednesday, June 04, 2003 2:35 PM
To: Multiple recipients of list ORACLE-L


Ahem . . . according to Note 112011.1, these problems can affect all
platforms except OS/390 which does NOT support datafile resizing
(fiendishly clever those mainframe types). 
It looks like 8.1.7.4 and above is not affected. I would highly recommend
that all Oracle DBAs take a look at this note.

Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED] 


-Original Message-
Sent: Wednesday, June 04, 2003 3:00 PM
To: Multiple recipients of list ORACLE-L


It doesn't seem to be a problem on other platforms... Just when I stopped
feeling like a neglected step child for running on Linux. Don't worry... Be
happy... There's a workaround... Upgrade and buy more software...

D'ai jobu desu... er, eh, Ca ne fais rien.


-Original Message-
Sent: Wednesday, June 04, 2003 12:46 PM
To: Multiple recipients of list ORACLE-L


This almost sounds like the problem that existed for Oracle 7.3 and the 2G
threshold a couple of years ago...

J'ai une impression d'avoir déjà vu ceci.

: )

Patrice.

-Original Message-
Sent: Wednesday, June 04, 2003 3:10 PM
To: Multiple recipients of list ORACLE-L


Steve - are you saying that there is a workaround by increasing the size of
the file manually to something larger than 4G?

Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Wednesday, June 04, 2003 1:25 PM
To: Multiple recipients of list ORACLE-L


See my note: There is no such O/S file size limit.

We have datafiles  2GB which work just fine. The problem is with
autoextending datafiles that extend from 2GB to 2GB. It's not a Linux
limitation but a limitation imposed by Oracle's implementation on Linux.
Oracle 9i on Linux doesn't have this problem. And my peeve is that it took
OWS 4 days to discover this limit.


Still peeved,  :-)
Steve



-Original Message-
Sent: Wednesday, June 04, 2003 10:55 AM
To: Multiple recipients of list ORACLE-L


I think it is the limitation of Linux, not Oracle.
Use LVM and don't worry about file size limit. :-)

JP
- Original Message - 
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, June 04, 2003 5:40 PM


 I've just been informed that there is a 2GB datafile size limit with
Oracle 8.1.7 on Linux... PERIOD. This despite the fact that we've had files
in excess of this for some time and they work just fine. The problem occurs
when the autoextend feature reaches the 2GB threshhold. Of course, Oracle
didn't tell me this until after about 4 days of back and forth testing for
them. (There is no such O/S file size limit.) I've reviewed the Linux
release notes, the Linux install guide, the Linux admin guide and the
contents of $ORACLE_HOME/relnotes and I don't find any such limitation in
the documentation. Did I miss it? Can anyone find any such published
limitation in the docs? Is this a secret?


 Peeved at Oracle... AGAIN,
 Steve Orr
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 -- 
 Author: Orr, Steve
   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-Mail message
 to: [EMAIL PROTECTED] (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).


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jan Pruner
  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-Mail message
to: [EMAIL PROTECTED] (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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Orr, Steve
  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-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB

RE: get hit ration

Title: Message



A 
library cache hitmeans that when parsing a statement the object definition 
is already found in the cached data dictionary (likely it has been recently 
used). A library cache miss means that it aint there. 

Now if 
you can explain to your line of business boss why you would wish to improve the 
ratio of one to the other by allocating some memory that could be used for 
something else to the library cache (located in the shared pool), then go right 
ahead. 

On the 
other hand you might have a real performance problem (my report runs for 1.5 
hours and it only used to run for 3 minutes), these sorts of problems 
generally have a different underlying cause than finding objects in memory 
rather than on disk, 80 % of the time or thereabouts its the sql, 10% or there 
abouts its the data. 


Niall 

  
  -Original Message-From: [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED] On Behalf Of AKSent: 03 June 2003 
  17:35To: Multiple recipients of list ORACLE-LSubject: 
  get hit ration
  found that gethitratio in v$librarycahce is very 
  low for indexes. what does it mean ? is there any way to improve this 
  .
  
  thanks,
  -ak

RE: Chris: Thank you!

I understand why you wouldn't wish to part with it, but a virtual museum
will never work. The 'where to find a leading edge PC' problem has
already been mentioned, where to find an industry standard floppy disk
will become an issue as well. For my money the best route for a museum
would be a source code library and a set of emulators of each
architecture that is preserved. 

Niall

Who can't believe that he used the word architecture, despite despising
it it deeply and
Who moved the last 6.0.36 db we have to MS Access earlier this year :( 

 -Original Message-
 From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of 
 Jeremiah Wilton
 Sent: 04 June 2003 14:35
 To: Multiple recipients of list ORACLE-L
 Subject: RE: Chris: Thank you!
 
 
 I have a bit of Oracle memorabilia but I probably won't be 
 willing to part with it.  Maybe the Oracle Museum should be 
 virtual, with a registry of who has what archaic Oracle stuff.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Niall Litchfield
  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-Mail message
to: [EMAIL PROTECTED] (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).

RE: Shit of the day

That would be next to Oracle is half the cost of sqlserver for packaged
apps, which would apeear to me to be a lie, in the sense that it is a
statement which would be untrue for any given customer migrating. 

Niall 

 -Original Message-
 From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of 
 Jan Pruner
 Sent: 04 June 2003 12:45
 To: Multiple recipients of list ORACLE-L
 Subject: Shit of the day
 
 
 Trade SQL Server for Oracle9i Database and get up to 100% 
 license credit 
 and peace of mind.
 
 Tired of applying patches? Frustrated with managing mulitple 
 database servers? 
 In the time it takes you to apply all Microsoft's patches to 
 your servers, 
 you can successfully migrate your database to Oracle9i 
 Database and be 
 worry-free. 
 
 
 From 
 http://www.oracle.com/start/linuxsqlserver/intro.html?src=1764
462Act=16


I don't understand PR of Oracle. The RDBMS has so much properties which
are 
much more better implemented in Oracle than in MS SQL and they choose 
'patching' which *** on both servers.

JP

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jan Pruner
  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-Mail message
to: [EMAIL PROTECTED] (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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Niall Litchfield
  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-Mail message
to: [EMAIL PROTECTED] (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).

RE: Shite of the day

Hi Rich, 

No.  I guess by manual I mean I didn't use the gui. I ran the appropriate upgrade 
script. 

Gosh I hope it doesn't come to exp/imp... I can't even export my database. 

Lisa

-Original Message-
Sent: Wednesday, June 04, 2003 2:46 PM
To: Multiple recipients of list ORACLE-L


Lisa, when you say you manually migrated, did you use exp/imp after a
fresh CREATE DATABASE in 9i?  Also, what platform?  32-bit?

Thx!
Rich

Rich Jesse   System/Database Administrator
[EMAIL PROTECTED]  Quad/Tech Inc, Sussex, WI USA


 -Original Message-
 From: Koivu, Lisa [mailto:[EMAIL PROTECTED]
 Sent: Wednesday, June 04, 2003 1:05 PM
 To: Multiple recipients of list ORACLE-L
 Subject: RE: Shite of the day
 
 
 Hi Ganesh, 
 
 Thanks for your reply.  Still, no dice.  Now it thinks it's 
 in recovery and I can't force it to do an incomplete recovery 
 with OPEN RESETLOGS.  The brilliant response I got from 
 support is Restore from backup and try again
 
 Lovely.  This is the second upgrade I have tried to complete 
 and failed miserably at.  This is NOT giving me a warm fuzzy 
 about upgrading production. 
 
 Lisa 
 (Can one more thing go wrong today?  Please?)
 
 -Original Message-
 Sent: Wednesday, June 04, 2003 1:38 PM
 To: Multiple recipients of list ORACLE-L
 
 
 Set the Compatiable Parameter to the Actual Version you 
 Upgraded and not
 to any patch rel that was rel later on.
 
 HTH
 
 Best Regards,
 Ganesh R
 DID : +65-6215-8413
 HP  : +65-9067-8474
 ===
 Live to learn... forget... and learn again.
 ===
 
 
 -Original Message-
 Lisa
 Sent: Wednesday, June 04, 2003 10:40 PM
 To: Multiple recipients of list ORACLE-L
 
 
 Oh-My-Gosh.  
 
 Worry free?  I just upgraded another 8.1.7.4 database to 9.2.  When I
 set the COMPATIBLE parm to 9.0.2 (or 9.2, which would make 
 sense) I get
 really messy errors:
 
 ORA-00402: database changes by release 9.0.1.3.0 cannot be used by
 release 135294976
 
 ORA-01571: redo version 9.0.2.0.0 incompatible with ORACLE version
 8.1.7.0.0
 
 So then I tried to set it back to 8.1.7, or comment out COMPATIBLE
 altogether, and I get the same type of error.  It won't open at all. 
 
 I tried initiating recovery.  This database is in noarc mode. 
  It starts
 looking for arclogs that *do not* exist.  I also tried to 
 drop the redo
 log groups and recreate them.  Still, no dice. 
 
 Again, unbreakable my FUNDAMENT.
 
 So has anyone seen this before?  I opened a tar yesterday and promptly
 confused support. 
 
 Lisa
 
 
 
 -Original Message-
 Sent: Wednesday, June 04, 2003 7:45 AM
 To: Multiple recipients of list ORACLE-L
 
 
 Trade SQL Server for Oracle9i Database and get up to 100% license
 credit 
 and peace of mind.
 
 Tired of applying patches? Frustrated with managing mulitple database
 servers? 
 In the time it takes you to apply all Microsoft's patches to your
 servers, 
 you can successfully migrate your database to Oracle9i 
 Database and be 
 worry-free. 
 
 
 From 
 http://www.oracle.com/start/linuxsqlserver/intro.html?src=1764
 462Act=16
 
 
 I don't understand PR of Oracle. The RDBMS has so much 
 properties which
 are 
 much more better implemented in Oracle than in MS SQL and they choose 
 'patching' which *** on both servers.
 
 JP
 
 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jesse, Rich
  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-Mail message
to: [EMAIL PROTECTED] (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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Koivu, Lisa
  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-Mail message
to: [EMAIL PROTECTED] (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).

RE: ??? Linux/Oracle 8.1.7 2GB file size limit ???

Dennis,

Thanks a lot, the diamond of the day from the list.

Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA 

-Original Message-
Sent: Wednesday, June 04, 2003 4:35 PM
To: Multiple recipients of list ORACLE-L


Ahem . . . according to Note 112011.1, these problems can affect all
platforms except OS/390 which does NOT support datafile resizing
(fiendishly clever those mainframe types). 
It looks like 8.1.7.4 and above is not affected. I would highly recommend
that all Oracle DBAs take a look at this note.

Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED] 


-Original Message-
Sent: Wednesday, June 04, 2003 3:00 PM
To: Multiple recipients of list ORACLE-L


It doesn't seem to be a problem on other platforms... Just when I stopped
feeling like a neglected step child for running on Linux. Don't worry... Be
happy... There's a workaround... Upgrade and buy more software...

D'ai jobu desu... er, eh, Ca ne fais rien.


-Original Message-
Sent: Wednesday, June 04, 2003 12:46 PM
To: Multiple recipients of list ORACLE-L


This almost sounds like the problem that existed for Oracle 7.3 and the 2G
threshold a couple of years ago...

J'ai une impression d'avoir déjà vu ceci.

: )

Patrice.

-Original Message-
Sent: Wednesday, June 04, 2003 3:10 PM
To: Multiple recipients of list ORACLE-L


Steve - are you saying that there is a workaround by increasing the size of
the file manually to something larger than 4G?

Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Wednesday, June 04, 2003 1:25 PM
To: Multiple recipients of list ORACLE-L


See my note: There is no such O/S file size limit.

We have datafiles  2GB which work just fine. The problem is with
autoextending datafiles that extend from 2GB to 2GB. It's not a Linux
limitation but a limitation imposed by Oracle's implementation on Linux.
Oracle 9i on Linux doesn't have this problem. And my peeve is that it took
OWS 4 days to discover this limit.


Still peeved,  :-)
Steve



-Original Message-
Sent: Wednesday, June 04, 2003 10:55 AM
To: Multiple recipients of list ORACLE-L


I think it is the limitation of Linux, not Oracle.
Use LVM and don't worry about file size limit. :-)

JP
- Original Message - 
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, June 04, 2003 5:40 PM


 I've just been informed that there is a 2GB datafile size limit with
Oracle 8.1.7 on Linux... PERIOD. This despite the fact that we've had files
in excess of this for some time and they work just fine. The problem occurs
when the autoextend feature reaches the 2GB threshhold. Of course, Oracle
didn't tell me this until after about 4 days of back and forth testing for
them. (There is no such O/S file size limit.) I've reviewed the Linux
release notes, the Linux install guide, the Linux admin guide and the
contents of $ORACLE_HOME/relnotes and I don't find any such limitation in
the documentation. Did I miss it? Can anyone find any such published
limitation in the docs? Is this a secret?


 Peeved at Oracle... AGAIN,
 Steve Orr
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 -- 
 Author: Orr, Steve
   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-Mail message
 to: [EMAIL PROTECTED] (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).


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jan Pruner
  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-Mail message
to: [EMAIL PROTECTED] (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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Orr, Steve
  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-Mail message
to: [EMAIL PROTECTED] (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

RE: Those installing Oracle 9i on AIX 5.2L

Title: RE: Those installing Oracle 9i on AIX 5.2L





We don't GET access to man pages here... they take up too much space... so does the C compiler.


April Wells
Oracle DBA/Oracle Apps DBA
Corporate Systems
Amarillo Texas


You will recognize your own path when you come upon it, because you will suddenly have all the energy and imagination you will ever need.

~ Jerry Gillies ~




-Original Message-
From: Kirtikumar Deshpande [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, June 04, 2003 2:55 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Those installing Oracle 9i on AIX 5.2L



As root, from other session, you can run 'slibclean' (check the man pages for more info). 
Then there is no need to rename/remove so *.so library files. 


- Kirti 



--- April Wells [EMAIL PROTECTED] wrote:
 
 I got several can't write to insert string.so errors... but renaming
 those files allowed it to finish... and I always get those errors.
 
 
 April Wells 
 Oracle DBA/Oracle Apps DBA 
 Corporate Systems 
 Amarillo Texas 
 
 You will recognize your own path when you come upon it, because you will
 suddenly have all the energy and imagination you will ever need.
 
 ~ Jerry Gillies ~ 
 
 -Original Message-
 Sent: Wednesday, June 04, 2003 1:51 PM
 To: Multiple recipients of list ORACLE-L
 
 
 Raj,
 
 On more thing to remember. If you are going to apply the 9.2.0.3 patchset,
 be sure to pick the 5L version, not the RS6000 version of the patchset to
 download. If you pick the wrong one, it will be full of errors. If you
 pick the 5L version, it installed for me without error.
 
 Ruth
 
 - Original Message - 
 To: Multiple recipients of list ORACLE-L mailto:[EMAIL PROTECTED] 
 Sent: Monday, June 02, 2003 8:39 AM
 
 
 Hi all, 
 
 If you are installing or upgrading 9202/9203 on AIX 5.2L (64Bit), do you
 have a list of APARS that _must_ be installed? 
 
 I am talking about regatta (p690) servers if that matters ... 
 
 Thanks in advance 
 Raj 
 



__
Do you Yahoo!?
Yahoo! Calendar - Free online calendar with sync to Outlook(TM).
http://calendar.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Kirtikumar Deshpande
 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-Mail message
to: [EMAIL PROTECTED] (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).



The information contained in this communication, including attachments, is strictly 
confidential and for the intended use of the addressee only; it may also contain 
proprietary, price sensitive, or legally privileged information. Notice is hereby given that 
any disclosure, distribution, dissemination, use, or copying of the information by anyone 
other than the intended recipient is strictly prohibited and may be illegal. If you have 
received this communication in error, please notify the sender immediately by reply e-mail, 
delete this communication, and destroy all copies.
 

Corporate Systems, Inc. has taken reasonable precautions to ensure that any attachment to 
this e-mail has been swept for viruses. We specifically disclaim all liability and will 
accept no responsibility for any damage sustained as a result of software viruses and advise 
you to carry out your own virus checks before opening any attachment.

RE: Benchmarking of ASP.NET with Oracle v/s MSSQL

What do you wish to discover? 

 -Original Message-
 From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of 
 Satya Prakash Viswanath
 Sent: 03 June 2003 05:40
 To: Multiple recipients of list ORACLE-L
 Subject: Benchmarking of ASP.NET with Oracle v/s MSSQL

 Hi List,

 Anybody done performance benchmarking of a typical ASP.NET 
 application with IIS(or any web server) with Oracle 
 database(9.2) v/s MS SQL Server.(Latest version)  
 Any pointers for the same is most appreciated. If there is 
 any document on which POC has been done, plz mail to my id. 
 FYI: 80% of the transactions are DB intensive. So, any 
 guidelines for the same will be useful to me. 

 Thanks !

 Regards,
 Satya Prakash

 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 -- 
 Author: Satya Prakash Viswanath
   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-Mail message
 to: [EMAIL PROTECTED] (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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Niall Litchfield
  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-Mail message
to: [EMAIL PROTECTED] (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).

RE: ??? Linux/Oracle 8.1.7 2GB file size limit ???

Steve
   Personally I am VERY glad you mentioned this today. Since I run 64-bit
Unix, I didn't think this applied to me, but after reading the note, I ran
their formula and found a file on one of my databases that was very close to
the limit. Plenty happy to dodge that bullet.

Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED] 


-Original Message-
Sent: Wednesday, June 04, 2003 4:15 PM
To: Multiple recipients of list ORACLE-L


We are on 8.1.7.4 and it aflicted us anyway. Maybe I'll just wait a couple
of years and let other customers QA this Oracle feature until they get it
right.


Steve


-Original Message-
Sent: Wednesday, June 04, 2003 2:35 PM
To: Multiple recipients of list ORACLE-L


Ahem . . . according to Note 112011.1, these problems can affect all
platforms except OS/390 which does NOT support datafile resizing
(fiendishly clever those mainframe types). 
It looks like 8.1.7.4 and above is not affected. I would highly recommend
that all Oracle DBAs take a look at this note.

Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED] 


-Original Message-
Sent: Wednesday, June 04, 2003 3:00 PM
To: Multiple recipients of list ORACLE-L


It doesn't seem to be a problem on other platforms... Just when I stopped
feeling like a neglected step child for running on Linux. Don't worry... Be
happy... There's a workaround... Upgrade and buy more software...

D'ai jobu desu... er, eh, Ca ne fais rien.


-Original Message-
Sent: Wednesday, June 04, 2003 12:46 PM
To: Multiple recipients of list ORACLE-L


This almost sounds like the problem that existed for Oracle 7.3 and the 2G
threshold a couple of years ago...

J'ai une impression d'avoir déjà vu ceci.

: )

Patrice.

-Original Message-
Sent: Wednesday, June 04, 2003 3:10 PM
To: Multiple recipients of list ORACLE-L


Steve - are you saying that there is a workaround by increasing the size of
the file manually to something larger than 4G?

Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Wednesday, June 04, 2003 1:25 PM
To: Multiple recipients of list ORACLE-L


See my note: There is no such O/S file size limit.

We have datafiles  2GB which work just fine. The problem is with
autoextending datafiles that extend from 2GB to 2GB. It's not a Linux
limitation but a limitation imposed by Oracle's implementation on Linux.
Oracle 9i on Linux doesn't have this problem. And my peeve is that it took
OWS 4 days to discover this limit.


Still peeved,  :-)
Steve



-Original Message-
Sent: Wednesday, June 04, 2003 10:55 AM
To: Multiple recipients of list ORACLE-L


I think it is the limitation of Linux, not Oracle.
Use LVM and don't worry about file size limit. :-)

JP
- Original Message - 
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, June 04, 2003 5:40 PM


 I've just been informed that there is a 2GB datafile size limit with
Oracle 8.1.7 on Linux... PERIOD. This despite the fact that we've had files
in excess of this for some time and they work just fine. The problem occurs
when the autoextend feature reaches the 2GB threshhold. Of course, Oracle
didn't tell me this until after about 4 days of back and forth testing for
them. (There is no such O/S file size limit.) I've reviewed the Linux
release notes, the Linux install guide, the Linux admin guide and the
contents of $ORACLE_HOME/relnotes and I don't find any such limitation in
the documentation. Did I miss it? Can anyone find any such published
limitation in the docs? Is this a secret?


 Peeved at Oracle... AGAIN,
 Steve Orr
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 -- 
 Author: Orr, Steve
   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-Mail message
 to: [EMAIL PROTECTED] (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).


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jan Pruner
  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-Mail message
to: [EMAIL PROTECTED] (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).

-- 
Please see the official ORACLE-L FAQ:

RE: Interesting!