date:20010301

Last night on a game forum someone wrote that he was driving a truck
"between Microsoft buildings."  He was at a traffic light, and he thought
"Is it ever windy!  Look at those lights sway back and forth."  He noticed
that the truck in front of him was swaying too, he thought it must have been
some wicked wind tunnel effect between the buildings.

Then he noticed that the buildings were swaying too and people were running
out of them, he finally realized what was going on.

: )

He didn't mention anything about the Microsoft buildings collapsing.

I was thinking - a seismologist on CBC said that "the big one" would
probably be centered off-shore, so not to worry about the effects of this
one.  OK, if the "big one" is centered off-shore, all these measures
architects are taking in California to build quake-resistant buildings will
be for naught, it won't protect them from any tidal waves...

Patrice Boivin
Systems Analyst (Oracle Certified DBA)

Systems Admin & Operations | Admin. et Exploit. des systèmes
Technology Services| Services technologiques
Informatics Branch | Direction de l'informatique 
Maritimes Region, DFO  | Région des Maritimes, MPO

E-Mail: [EMAIL PROTECTED]  

-Original Message-
From:   Dennis Taylor [SMTP:[EMAIL PROTECTED]]
Sent:   Wednesday, February 28, 2001 3:58 PM
To: Multiple recipients of list ORACLE-L
Subject:RE: eek!

few miles south of Seattle, magnitude 6.2

Someone opined that it was cause by Windows crashing...

At 11:25 AM 2/28/01 -0800, Kevin Kostyszyn wrote:
>whoa, where?
>

Dennis Taylor

Niels is bohring.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Dennis Taylor
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing
Lists

To REMOVE yourself from 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.com
--
Author: Boivin, Patrice J
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from 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).

Offline - ORACLE ODBC Err.

2001-03-01 Thread Arul kumar


Hi,

One of our app. is  using ORACLE ODBC Driver for connecting to the db.
While using LONG columns in the Transactions, sometimes an error message
is shown as:

ORACLE ODBC DRIVER Error  ORA -010 ... INVALID ARGUMENTS..

Any idea ? Any suggestions??

Thank You.
Arul.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Arul kumar
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from 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).

Oracle's generosity

2001-03-01 Thread Steve Adams


Hi All,

I am curious about the generosity of Club Oracle. I signed up as a Club Oracle
Gold member for $50 prior to OpenWorld last year just to get the $135 discount
on the OpenWorld registration fee. There was also a gift certificate at
Amazon.com and a gift pack thrown in. I chose the "Kids pack" containing adult
and child size Club Oracle T-shirts.

I was a little surprised about a month after OpenWorld when a second such gift
pack arrived. I was even more surprised today when the third identical gift pack
arrived. I've now got 6 Club Oracle T-shirts! Anyone else?

@   Regards,
@   Steve Adams
@   http://www.ixora.com.au/
@   http://www.christianity.net.au/

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Steve Adams
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from 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).

OFF TOPIC: How to find lib search order for executable under Sun solaris

2001-03-01 Thread KC





Dear list,
 
In HP-UX, one can do a chatr to find out the lib 
search order of an executable, is there a corresponding command under Sun 
Solaris. Also, can someone tell me how nmliblist is used when relink Oracle 
under Sun?? Thanks
 
Kam

ORACLE_ON_NT !!!!

2001-03-01 Thread Jackson Dumas




I would like to find out how I can make a Oracle database running on
NT to start up automatically if there is a power failure or something
on the box without having to down that database. I read another
article about Oradim and how to include the startup file if it's not
there on Services running on NT. Actually I did check that there is no
startup service for database to be automatically started. Now my
problem is whether it's possible for me to incorporate this without
having to get down time, because this is a 24X7 system and it will
take a long time before getting approval and things like those
Please help me, I am new on these thangs.
Ya help please .. 
___
 http://www.webmail.co.za the South-African free email service
 WIN R10 000 by registering  for free online options for EasyMoney in
 http://www.easyinfo.co.za/easymoney/wmindex.asp - Easy Does it - Now!!!
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jackson Dumas
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from 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).

Confusion about what partition a record is stored using hash partitions

2001-03-01 Thread Cale, Rick T (Richard)


Using range partition you know exactly where the records are stored. I do
not understand how one knows
where the row is stored using hash partitioning. Can the optimizer still use
partitioning pruning with hash
partitions? Can someone explain how hash partitions work? My sources are
confusing.

Thanks
Rick Cale, Science Applications International Corp.
Phone:865-481-2198, fax:865-481-8555
e-mail: [EMAIL PROTECTED]

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Cale, Rick T (Richard)
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from 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: Confusion about what partition a record is stored using hash

2001-03-01 Thread Toepke, Kevin M


Rick:

Check out the DBMS_UTILITY.GET_HASH_VALUE() function. This function will
tell you what partition the data is stored in.

Partition pruning can still be used.

Kevin


-Original Message-
Sent: Thursday, March 01, 2001 8:05 AM
To: Multiple recipients of list ORACLE-L
partitions


Using range partition you know exactly where the records are stored. I do
not understand how one knows
where the row is stored using hash partitioning. Can the optimizer still use
partitioning pruning with hash
partitions? Can someone explain how hash partitions work? My sources are
confusing.

Thanks
Rick Cale, Science Applications International Corp.
Phone:865-481-2198, fax:865-481-8555
e-mail: [EMAIL PROTECTED]

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Cale, Rick T (Richard)
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from 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.com
-- 
Author: Toepke, Kevin M
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from 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: eek?

2001-03-01 Thread Vishak


Heard that a sequel is being made to the movie "Sleepless in Seattle"???

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Vishak
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from 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: ORACLE_ON_NT !!!!


What exactly are you asking?  What version of Oracle, What version of NT?
Who installed and created the DB?
Kev

-Original Message-
Dumas
Sent: Thursday, March 01, 2001 8:15 AM
To: Multiple recipients of list ORACLE-L




I would like to find out how I can make a Oracle database running on
NT to start up automatically if there is a power failure or something
on the box without having to down that database. I read another
article about Oradim and how to include the startup file if it's not
there on Services running on NT. Actually I did check that there is no
startup service for database to be automatically started. Now my
problem is whether it's possible for me to incorporate this without
having to get down time, because this is a 24X7 system and it will
take a long time before getting approval and things like those
Please help me, I am new on these thangs.
Ya help please .. 
___
 http://www.webmail.co.za the South-African free email service
 WIN R10 000 by registering  for free online options for EasyMoney in
 http://www.easyinfo.co.za/easymoney/wmindex.asp - Easy Does it - Now!!!
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jackson Dumas
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from 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.com
-- 
Author: Kevin Kostyszyn
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from 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: what do i suppose to do ?


I am confused, what don't you know how to do.  Install Oracle, make sure
before you start the installation you install the "Microsoft Loopback
Adapter" and networking other wise the installation will fail because Oracle
needs a protocol to communicate.
Kev

-Original Message-
Sent: Thursday, March 01, 2001 4:56 AM
To: Multiple recipients of list ORACLE-L


call oracle support

> --
> From: Rajiv Ranjan[SMTP:[EMAIL PROTECTED]]
> Reply To: [EMAIL PROTECTED]
> Sent: Thursday, March 01, 2001 4:35 PM
> To:   Multiple recipients of list ORACLE-L
> Subject:  what do i suppose to do ?
>
> Hi guys,
>
> I want to create a database with  oracle 8i in a standalone machine , what
> do i suppose to do ?
>
> Thnax in advance
> Rajiv
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Rajiv Ranjan
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from 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.com
--
Author: Rahul
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from 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.com
-- 
Author: Kevin Kostyszyn
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from 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: Oracle Author in People Magazine


remind me not to get interviewed by them... who wants everyone to know how 
old I am?  :)

Seeing-eye horses? that is cool -- gonna have to go find that issue.


>From: Ari D Kaplan <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: Oracle Author in People Magazine
>Date: Wed, 28 Feb 2001 15:05:23 -0800
>
>Has anyone seen the recent February 26th issue of People Magazine?
>
>There was a three-page article on Don Burleson's side-activity: his
>seeing-eye horses. Very cool ; they even wear shoes.
>
>If you do not know Don, he authored the "High-performance Oracle8
>Tuning" book.
>
>Now we know from the article that he is 44 years old ;)
>
>Take care,
>
>-Ari Kaplan
>
><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->
><-> For 400+ Oracle tips, visit:   <->
><-><->
><-> www.arikaplan.com  <->
><-><->
><-> email: [EMAIL PROTECTED]   <->
><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->
>
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Ari D Kaplan
>   INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>San Diego, California-- Public Internet access / Mailing Lists
>
>To REMOVE yourself from 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).

_
Get your FREE download of MSN Explorer at http://explorer.msn.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rachel Carmichael
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from 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: Can Oracle7 and Oracle8 co-exist?

2001-03-01 Thread manoharp


Absolutely no Problem. Two oracles of same or different versions
exist on AIX . In fact I have two oracles and two instances on
AIX ..Go ahead.with confidence

  Manoharan.



Ben Poels wrote:

> Hi,
>
> I want to install Oracle 8.1.7 on the same
> AIX 4.3.2 box which is already running
> Oracle 7.3.4.5. I will use a separate Oracle
> owner and Oracle home for the new 8.1.7 software.
>
> Has anybody had any problems with these two
> versions co-existing on the same platform?
> I have them both installed now but before
> I spend a lot of time trying to break it I
> thought I'd check to see whether or not this
> has worked out at other sites.
>
> Thanks,
>
> Ben Poels
> Queen's University
> Kingston, Ontario
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Ben Poels
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from 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.com
-- 
Author: manoharp
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from 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: eek!

2001-03-01 Thread Cherie_Machler

Dennis,

Hope all is well there today.  I was a little
freaked when I heard about it on the radio
on the way home.

Glad you checked in to tell us you were
o.k.

Chere Machler
Gelco Information Network
In Minnesota where they don't have earthquakes

Dennis Taylor <[EMAIL PROTECTED]> on 02/28/2001 01:32:07 PM

Please respond to [EMAIL PROTECTED]

To:   Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:(bcc: Cherie Machler/GELCO)

At 11:17 AM 2/28/01 -0800, you wrote:
>We just had an earthquake. I'm fairly freeked.
>

See how freaked I was? I mis-spelled 'freaked'.

Dennis Taylor

Niels is bohring.

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Dennis Taylor
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from 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.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from 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: eek!

2001-03-01 Thread Weaver, Walt


Nope, I was in the Air Force, flying KC135's out of Eielson AFB...

--Walt

-Original Message-
Sent: Wednesday, February 28, 2001 3:40 PM
To: Multiple recipients of list ORACLE-L


  True, nothing fell on my head with this one.  I will admit that I no
longer am calling this one fun.
I ran home at lunch and found quite a bit of damage to the brick entryway.
Of course, no earthquake
insurance, talk about needing diasaster recovery!  I need a bigger bank
balance!

  Walt, were you in Fairbanks to go to school?  I attending the university
there around that same time.

- Donna
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Weaver, Walt
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from 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).

OEM 2.2. installation blues


Hi,

Has anyone successfully installed OEM 2.2. on their machine?

My test server has 256M more RAM coming, but in the meantime I haven't given
up hope.  Although hope is dwindling... I only have 380M of RAM.

I started the installation process, then went to talk to someone.  When I
returned there was a Blue Screen of Death waiting for me.  

After powering off and powering on my machine, Peak Memory usage on my
machine is at 680M of memory!  Is this NT going crazy or does the Oracle
Universal Installer really need that much memory to install OEM 2.2.?  Could
there be a creeping memory leak in the Universal Installer? (make that a
galloping memory leak)

I allocated 1G of virtual memory, but I know from experience on this machine
at least that NT can't handle virtual memory very well, it keeps blue
screening when I exceed available physical memory by too much.

TIA
Patrice Boivin
Systems Analyst (Oracle Certified DBA)

Systems Admin & Operations | Admin. et Exploit. des systèmes
Technology Services| Services technologiques
Informatics Branch | Direction de l'informatique 
Maritimes Region, DFO  | Région des Maritimes, MPO

E-Mail: [EMAIL PROTECTED]  

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Boivin, Patrice J
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from 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: Revoke system privilege from user

2001-03-01 Thread Ron Rogers


In order to "revoke" a privilege you have to "grant" it. All you did was grant the 
role "DBA" and the inherent privileges that role has. To accomplish what you want to 
do, create a new role with the privileges you want to grant and grant the role to the 
user or grant only the privileges you want to the user.
ROR mª¿ªm

>>> [EMAIL PROTECTED] 03/01/01 12:25AM >>>
Hi, All,

I have granted DBA role to an user. But I don't want him  holding the
"Drop Any Table" system privilege.

I did as follows:

1. Connect as sysdba.
2. revoke drop any table from ABC-user;

And I got the error:" ORA-01952: system privileges not granted to
'ABC-user'".

Could anyone help me out?

Thanks,

Chuan


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com 
-- 
Author: Chuan Zhang
  INET: [EMAIL PROTECTED] 

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from 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.com
--
Author: Ron Rogers
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from 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).

Application Context

2001-03-01 Thread Andor Gyula


Hi Gurus !

Where can I find detailed information with examples about how to use application 
contexts?

Thanks in advance
Gyula

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Andor Gyula
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from 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: eek!


Sean,

I read about that crash this morning -- horrifying!  And they are saying 
there is something like $1 billion worth of damage from the quake. My 
friends in Gresham (Oregon) felt it as well.

You going to become a vegetarian based on the animal diseases raging over 
there?

Dennis -- you okay? Family/home okay? Databases?

Rachel

>From: "O'Neill, Sean" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: RE: eek!
>Date: Thu, 01 Mar 2001 01:50:19 -0800
>
>Dennis,
>
>So how are things post earth quake?.  Did you need to invoke any of your DR
>Plan?.  If so, sharing your experience on this would be useful after the
>dust settles =:-0
>
>It's a hell of a wake up call to remind one why DR plans are important.
>
>The earthquake made news here in Ireland along with the impending foot &
>mouth disease crisis and even mentioned ahead of bad rail crash in England
>across the Irish sea where lives were lost.
>
>"I see the bad moon a risin'.  I see trouble on the way."
>
>Sean :)
>
>Rookie Data Base Administrator
>[0%] OCP Oracle8i DBA
>[0%] OCP Oracle9i DBA
>
>Organon (Ireland) Ltd.
>http://www.organon.ie
>E-mail: [EMAIL PROTECTED]   [subscribed: Digest Mode]
>
>Visit: http://groups.yahoo.com/group/Oracle-OCP-DBA
>
>"They tell me nothing, but expect me to know everything!"
>
>
>--
>
>  From: Dennis Taylor <[EMAIL PROTECTED]>
>  Date: Wed, 28 Feb 2001 11:20:18 -0800
>  Subject: eek!
>
>We just had an earthquake. I'm fairly freeked.
>
>How's everyone's disaster recover strategy? I'll think I'll be reviewing
>ours today.
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: O'Neill, Sean
>   INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>San Diego, California-- Public Internet access / Mailing Lists
>
>To REMOVE yourself from 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).

_
Get your FREE download of MSN Explorer at http://explorer.msn.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rachel Carmichael
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from 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: Oracle's generosity


I only got two sets of the gift pack, both arriving within weeks of one 
another and when I signed up... hm, I feel so cheated :)

Rachel

>From: "Steve Adams" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: Oracle's generosity
>Date: Thu, 01 Mar 2001 05:05:24 -0800
>
>Hi All,
>
>I am curious about the generosity of Club Oracle. I signed up as a Club 
>Oracle
>Gold member for $50 prior to OpenWorld last year just to get the $135 
>discount
>on the OpenWorld registration fee. There was also a gift certificate at
>Amazon.com and a gift pack thrown in. I chose the "Kids pack" containing 
>adult
>and child size Club Oracle T-shirts.
>
>I was a little surprised about a month after OpenWorld when a second such 
>gift
>pack arrived. I was even more surprised today when the third identical gift 
>pack
>arrived. I've now got 6 Club Oracle T-shirts! Anyone else?
>
>@   Regards,
>@   Steve Adams
>@   http://www.ixora.com.au/
>@   http://www.christianity.net.au/
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Steve Adams
>   INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>San Diego, California-- Public Internet access / Mailing Lists
>
>To REMOVE yourself from 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).

_
Get your FREE download of MSN Explorer at http://explorer.msn.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rachel Carmichael
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from 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: Oracle Author in People Magazine

2001-03-01 Thread Carle, William T (Bill), NLCIO


Rachel, you're only 25. Why would you care?


Bill Carle
AT&T
Database Administrator
816-995-3922
[EMAIL PROTECTED]

 -Original Message-
Sent:   Thursday, March 01, 2001 8:22 AM
To: Multiple recipients of list ORACLE-L
Subject:Re: Oracle Author in People Magazine

remind me not to get interviewed by them... who wants everyone to know how 
old I am?  :)

Seeing-eye horses? that is cool -- gonna have to go find that issue.


>From: Ari D Kaplan <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: Oracle Author in People Magazine
>Date: Wed, 28 Feb 2001 15:05:23 -0800
>
>Has anyone seen the recent February 26th issue of People Magazine?
>
>There was a three-page article on Don Burleson's side-activity: his
>seeing-eye horses. Very cool ; they even wear shoes.
>
>If you do not know Don, he authored the "High-performance Oracle8
>Tuning" book.
>
>Now we know from the article that he is 44 years old ;)
>
>Take care,
>
>-Ari Kaplan
>
><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->
><-> For 400+ Oracle tips, visit:   <->
><-><->
><-> www.arikaplan.com  <->
><-><->
><-> email: [EMAIL PROTECTED]   <->
><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->
>
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Ari D Kaplan
>   INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>San Diego, California-- Public Internet access / Mailing Lists
>
>To REMOVE yourself from 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).

_
Get your FREE download of MSN Explorer at http://explorer.msn.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rachel Carmichael
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from 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.com
-- 
Author: Carle, William T (Bill), NLCIO
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from 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: Oracle's Updates Subscription Service


NO!
RBG
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, February 28, 2001 9:45 PM


> Does anyone know  - will I still have access to Metalink if I will not pay
for the support?
>
> TIA,
> Michael Netrusov,
> www.atelo.com
> (202) 262 8469
> (877) 528 0090
>
>
> - Original Message -
> To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> Sent: Wednesday, February 28, 2001 20:20
>
>
> > Cool, thanks for the info Sarah, I hadn't seen that split.  I'll check
it
> > when I get our next bill.  I will be glad to be able to only pay for
> > upgrades which I use, and not the support, which I have not used in over
5
> > years.
> >
> >
> >
> > -Original Message-
> > Sent: Wednesday, February 28, 2001 5:00 PM
> > To: Multiple recipients of list ORACLE-L
> >
> >
> > Walt,
> >
> > Last summer we noticed our support bill was split into two pieces--one
for
> > support and one for upgrades.  You can still buy both.  I didn't notice
that
> > it was a lot more in total than before, but it does give a cost cutter a
> > chance to say we only need one of those pieces!
> >
> > Sarah Satterthwaite
> > Case, Shiller, Weiss, Inc
> > Cambridge, MA
> >
> > "Weaver, Walt" wrote:
> > >
> > > Say, is it just me or has the cost of the Updates Subscription Service
> > gone
> > > up considerably in the past six months or so?
> > >
> > > We're currently pricing out what it'll cost us to purchase 8.1.7
Standard
> > > Edition and the numbers we're getting are a heck of a lot higher than
they
> > > were in November.
> > >
> > > Has the cost of CD-ROM's gone up that much? Is the economy now in an
> > > inflationary period? Where's Allen Greenspan when you need him?
> > >
> > > Whatever happened to those hazy, golden, halcyon days when upgrades
were
> > > included in product support?
> > >
> > > Sometimes, Oracle just sucks. I'm seriously considering getting on
track
> > for
> > > a MySQL certification.   :>)
> > >
> > > --Walt Weaver
> > >   Bozeman, Montana, USA
> > > --
> > > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > > --
> > > Author: Weaver, Walt
> > >   INET: [EMAIL PROTECTED]
> > >
> > > Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> > > San Diego, California-- Public Internet access / Mailing Lists
> > > 
> > > To REMOVE yourself from 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.com
> > --
> > Author: Sarah Satterthwaite
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> > San Diego, California-- Public Internet access / Mailing Lists
> > 
> > To REMOVE yourself from 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 email is intended for the
> > personal and confidential use of the addressee only. It may
> > also be privileged information. If you are not the intended
> > recipient then you are hereby notified that you have received
> > this document in error and that any review, distribution or
> > copying of this document is strictly prohibited. If you have
> > received  this communication in error, please notify Celltech
> > Group immediately on:
> >
> > +44 (0)1753 534655, or email '[EMAIL PROTECTED]'
> >
> > Celltech Group plc
> > 216 Bath Road, Slough, SL1 4EN, Berkshire, UK
> >
> > Registered Office as above. Registered in England No. 2159282
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Maser, Donna  (SEA)
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> > San Diego, California-- Public Internet access / Mailing Lists
> > 
> > To REMOVE yourself from 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.com
> --
> Author: Michael Netrusov
>

Re: Can Oracle7 and Oracle8 co-exist?


I have 7.3.4, 8.0.5 and 8.1.6 running on the same Sun box -- no problems

same oracle owner, different ORACLE_HOMEs

and shell scripts that are named for each of my database instances that set 
up my environment to point to the proper ORACLE_SID, ORACLE_HOME, etc etc so 
I can switch easily between databases

>From: manoharp <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: Re: Can Oracle7 and Oracle8 co-exist?
>Date: Thu, 01 Mar 2001 05:55:27 -0800
>
>Absolutely no Problem. Two oracles of same or different versions
>exist on AIX . In fact I have two oracles and two instances on
>AIX ..Go ahead.with confidence
>
>  Manoharan.
>
>
>
>Ben Poels wrote:
>
> > Hi,
> >
> > I want to install Oracle 8.1.7 on the same
> > AIX 4.3.2 box which is already running
> > Oracle 7.3.4.5. I will use a separate Oracle
> > owner and Oracle home for the new 8.1.7 software.
> >
> > Has anybody had any problems with these two
> > versions co-existing on the same platform?
> > I have them both installed now but before
> > I spend a lot of time trying to break it I
> > thought I'd check to see whether or not this
> > has worked out at other sites.
> >
> > Thanks,
> >
> > Ben Poels
> > Queen's University
> > Kingston, Ontario
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Ben Poels
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> > San Diego, California-- Public Internet access / Mailing Lists
> > 
> > To REMOVE yourself from 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.com
>--
>Author: manoharp
>   INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>San Diego, California-- Public Internet access / Mailing Lists
>
>To REMOVE yourself from 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).

_
Get your FREE download of MSN Explorer at http://explorer.msn.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rachel Carmichael
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from 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 for all the information Greg. One more question. What's an oracle names proxy? I thought names was going away entirely in 9i.
Chuck Hamilton
"Nelson, Greg" <[EMAIL PROTECTED]> wrote:
Failover information in Oracle Internet Directory (OID) is entered like Net8configuration information. You can import the exact information that is inyour TNSNAMES.ORA into OID, so if you can code failovers in TNSNAMES.ORA youcan put it in OID as well. So you would handle failovers using OID thru acombination of how you set up your databases and Net8.You will also want to make sure that you have a failover for the OIDdatabase if you decide to use it. If it is your connection server and itisn't up clients obviously can't connect. You can place failover options inSQLNET.ORA and/or the LDAP.ORA file that is used by OID, such as havingmultiple OID databases or Advanced Replication.I have learned the hard way (not on MetaSlop) that OID is not available onParallel Server yet so thats not an option.There is no concise or clear directions !
!
available that I know of to get OIDinstalled and working (at least from Oracle). The steps to install and getOID working are found not only in the OID manual. They involve installingOID from the Enterprise Edition CD under Management Infrastructure whichcreates an OID database or populates one of your choosing, starting OIDservices, using Oracle Directory Manager to create your particular LDAPcontext (i.e. banknorth.com), Net8 Configuration Assistant for adding OracleAdministration context under your context, and Net8 Assistant for addingentries from TNSNAMES.ORA under your context. Entries can also be bulkloaded by Oracle scripts which I haven't done yet. Piecing it all together the first time took me a week because of the lack ofclear directions. I documented it myself and then 2 months later did acomplete install on another server in an hour using my own documentation.Migrating from Oracle Names would undoubtedly i!
!
nvolve some different steps(probably at my TNSNAMES import). There will be an Oracle Names proxy in9i.After saying all this I believe it will all be worth it once it comes timeto cofigure hundreds of Oracle clients. Also, since OID is an LDAPdirectory it will have many other uses as well. Its too bad that Oraclecouldn't have put together clear documentation on installing and using itbut that's nothing new.Greg Nelson[EMAIL PROTECTED] -Original Message-Sent: Wednesday, February 28, 2001 12:01 PMTo: Multiple recipients of list ORACLE-LI'm considering the switch from Oracle Names to Oracle Internet Directory.One feature I liked about names was the dynamic discovery. Does dynamicdiscovery also work with OID? For example if one of my databases fails overto another machine in it's cluster, the names server is automaticall!
!
yupdated by the listener as soon as the database starts up on the newmachine. Will that also happen with OID? If not, can it easily be scripted(korn shell).Also, is there a consicise, easy to follow reference, that tells you how toadd a database to OID so you can use OIS to resolve a name to it? I've gonethrough the entire OID manual and found nothing on the subject._ Do You Yahoo!?Yahoo! Mail Personal Address - Get email at your own domain with Yahoo! Mail.-- Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: Nelson, GregINET: [EMAIL PROTECTED]Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spell!
!
ing of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).Do You Yahoo!?
Yahoo! Mail Personal Address -
Get email at your own domain with Yahoo! Mail.

RE: * Oracle DBAs Needed in the Virginia Beach VA Area..

2001-03-01 Thread Anne Yu


Hi List Friends, 

I have server A: Solaris 5.8, RDBMS 8.1.7.0.0 and server B: Solaris 5.8 &
the RDBMS was upgraded from 8.0.5 to 8.1.7. 

RDBMS 8.1.7 is my recovery manager target database and the other is my
catalog database. 
When I try to register this 8.1.7 target database to this upgraded 8.1.7
catalog database,  I am getting:


RMAN> connect target sys/password@target_db 
RMAN> connected to target database: CATALOG
RMAN> connected to recovery catalog database
RMAN-06186: PL/SQL package SYS.DBMS_RCVMAN version 08.00.05 in TARGET
database i 
s too old 
RMAN-00571: === 
RMAN-00569: === ERROR MESSAGE STACK FOLLOWS === 
RMAN-00571: === 
RMAN-0058: error encountered while parsing input commands
RMAN-01006: error signalled during parse
 

What can I do to correct this problem, IF ANY? 


many thanks,


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Anne Yu
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from 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: OEM 2.2. installation blues


I am thinking now that perhaps memory utilization peak was called by NT
itself, which dumps its memory contents when there is a crash.

De-installed OEM 2.2., will do Typical and then use Custom to add additional
pieces one by one, since using Custom to do the whole thing crashes my
machine.

Patrice Boivin
Systems Analyst (Oracle Certified DBA)



-Original Message-
From:   Boivin, Patrice J [SMTP:[EMAIL PROTECTED]]
Sent:   Thursday, March 01, 2001 9:55 AM
To: Multiple recipients of list ORACLE-L
Subject:OEM 2.2. installation blues

Hi,

Has anyone successfully installed OEM 2.2. on their machine?

My test server has 256M more RAM coming, but in the meantime I
haven't given
up hope.  Although hope is dwindling... I only have 380M of RAM.

I started the installation process, then went to talk to someone.
When I
returned there was a Blue Screen of Death waiting for me.  

After powering off and powering on my machine, Peak Memory usage on
my
machine is at 680M of memory!  Is this NT going crazy or does the
Oracle
Universal Installer really need that much memory to install OEM
2.2.?  Could
there be a creeping memory leak in the Universal Installer? (make
that a
galloping memory leak)

I allocated 1G of virtual memory, but I know from experience on this
machine
at least that NT can't handle virtual memory very well, it keeps
blue
screening when I exceed available physical memory by too much.

TIA
Patrice Boivin
Systems Analyst (Oracle Certified DBA)

Systems Admin & Operations | Admin. et Exploit. des systèmes
Technology Services| Services technologiques
Informatics Branch | Direction de l'informatique 
Maritimes Region, DFO  | Région des Maritimes, MPO

E-Mail: [EMAIL PROTECTED] 


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Boivin, Patrice J
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing
Lists

To REMOVE yourself from 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.com
--
Author: Boivin, Patrice J
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from 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: OFF TOPIC: How to find lib search order for executable under

2001-03-01 Thread Brian MacLean




ldd -s 
$ORACLE_HOME/bin/oracle

  -Original Message-From: KC 
  [mailto:[EMAIL PROTECTED]]Sent: Thursday, March 01, 2001 5:50 
  AMTo: Multiple recipients of list ORACLE-LSubject: OFF 
  TOPIC: How to find lib search order for executable under Sun 
  solaris
  Dear list,
   
  In HP-UX, one can do a chatr to find out the lib 
  search order of an executable, is there a corresponding command under Sun 
  Solaris. Also, can someone tell me how nmliblist is used when relink Oracle 
  under Sun?? Thanks
   
  Kam

DBVerify showing corruption on every block with 8,.1.7

2001-03-01 Thread Murali Vallath



Hello Everyone,

Recently we installed Oracle Enterprise Edition 8.1.7 on all our database 
servers.
We have created new databases, as well as upgraded existing databases
from 8.1.5 to 8.1.7.  While implementing RMAN on databases,
RMAN detected block corruption. Initially, it was related to a database
conversion from an older version 8.1.5 to 8.1.7 issue. This was due to the 
fact
that the corruption was first detected on the converted databases.

However, the same behaviour has been noted on other databases consistently.
Since other databases are now showing the same symptons, we have used the
(dbv) database verify utility to look at various files within each of our 
databases.
The output indicates block corruption in all files.  Please note that this 
utility
also indicates the same corruption on all Oracle database files on other 
Tru64 servers.

Operations on these databases appear to be normal other than RMAN performing 
checksum
verifications.  Databases can be shutdown and restarted.

Meta link document states that this is an operating system corruption 
problem
when running the 5.0a, or 5.1 o/s versions of Tru64.  Our SA has confirmed 
the following:
advfs.mod checksum/byte count is 44646/1168.  He advises based on Oracle 
documentation:
apply the new advfs.mod and move an odbflchk to the /sys/BINARY area and 
recompile the kernel with changes.


Can you confirm this?

Also, what actions do we need to take to ensure the integrity of our 
databases?



The following are errors produced in the alert logs:
Corrupt block seq: 12 blocknum=12097.
Bad header found during backing up archived log
Data in bad block - seq:12. bno:12100. time:421846304
beg:336 cks:0
calculated check value: 10158
Reread of seq=12, blocknum=12097, 
file=/u03/oraarchive/dbname/dbname_0001_12.arc, found same
corrupt data

The following are errors reported by doing a dbv on Oracle files:
Page 76305 is marked corrupt
***
Corrupt block relative dba: 0x00012a11 (file 0, block 76305)
Bad header found during dbv:
Data in bad block -
type: 0 format: 0 rdba: 0x1c1c19c3
last change scn: 0x0005.47000106 seq: 0x16 flg: 0x00
consistency value in tail: 0x1c1c19c3
check value in block header: 0xff00, block checksum disabled
spare1: 0xff, spare2: 0x4, spare3: 0xc304
***

***

TAR#  13320267.600 Oracle Consultant Advised:

Corrective Actions Taken:

DBA - changed /etc/oratab file - DO NOT START DB's on server reboot

DBA - All DB's - Terminiate all user sessions
DBA - alter db's enable restricted mode
DBA - alter system switch logfile
DBA - alter system checkpoint
DBA - alter database backup controlfile to trace;

SA - Installed patch set QAR84601_v50a_b116.tar.Z

DBA - Relink 8.1.5 dbv utility:
  $ORACLE_HOME/rdbms/lib
  make -f ins_rdbms.mk idv

  Error "Don't know how to make idv" STOP.

DBA - Performed dbv on 8.1.7 database files:  errors messages as follows:

Page 1321 is marked corrupt
***
Corrupt block relative dba: 0x0529 (file 0, block 1321)
Completely zero block found during dbv:

Page 1322 is influx - most likely media corrupt
***
Corrupt block relative dba: 0x052a (file 0, block 1322)
Fractured block found during dbv:
Data in bad block -
type: 0 format: 0 rdba: 0x
last change scn: 0x. seq: 0x0 flg: 0x00
consistency value in tail: 0x
check value in block header: 0x0, block checksum disabled
spare1: 0x0, spare2: 0x0, spare3: 0x0
***


DBA - Performed sys/BINARY/odbflchk on several DB control files and redo 
logs

server.???.com:/u03/oradata/> /sys/BINARY/odbflchk 
/u03/oradata/dbname/redo_g1r2.log

Oracle Database File Checker - V1.4

Copyright (c) 2001, Oracle Corporation.  All Rights Reserved.

Checking file: /u03/oradata//redo_g1r2.log
Blocksize: 1024
Oracle filesize: 20971520 bytes, 20480 Oracle blocks
Oracle file header processed successfully.


.???.com:/u04/oradata/> /sys/BINARY/odbflchk 
/u03/oradata//control_02.ctl

Oracle Database File Checker - V1.4

Copyright (c) 2001, Oracle Corporation.  All Rights Reserved.

Checking file: /u03/oradata//control_02.ctl
Blocksize: 8192
Oracle filesize: 7438336 bytes, 908 Oracle blocks
Oracle file header processed successfully.
Scanning blocks: 100% Completed.

Done: Processed  908 blocks; no blocks are affected
  for file /u03/oradata//control_02.ctl


DBA - Peformed sys/BINARY/odbflchk on datafiles and returned the following:

Checking file: /u03/oradata/???/???_tools01_001.dbf
Oracle File #: 2
Blocksize: 4096
Oracle filesize: 52428800 bytes, 12800 Oracle blocks
Oracle file header processed successfully.
Scanning blocks: 100% Completed.

Done: Processed12800 blocks; no blocks are affected
  for file /u03/oradata/???/???_tools01_001.dbf


Question:  The dbverify and odbflchk utilities return conflicting results:
   How should we proceed?
   What is the integrity state of the d

ORU-10288 error, line length overflow.

2001-03-01 Thread Manasa Rao


All,
I am getting this following error, when I execute a procedure.  And I made 
sure my linesize is 2000, and all variables are of good size. But still 
don't understand the source of this error. Appreciate any help.
Thanks
Radhika.


ORA-2: ORU-10028: line length overflow, limit of 255 bytes per line
ORA-06512: at "SYS.DBMS_OUTPUT", line 99
ORA-06512: at "SYS.DBMS_OUTPUT", line 65
ORA-06512: at "SECADMIN.ICPASSECSELECT", line 27
ORA-06512: at line 1


_
Get your FREE download of MSN Explorer at http://explorer.msn.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Manasa Rao
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from 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).

DBWR slaves in NT???

2001-03-01 Thread Raghu Kota


Hi Friends

I have toad tool for my NT database

DBWR Average Scan Depth 1024  **Number of DB_Files too high??

I got doubt due to from v$waitstat I got data block waits some time 8000 and 
some times higher number. How can I increase the DBWR slaves on NT?? 
although I set in development box, How can I see as background process 
really working for me??

I have my datafile and indexes same on E disk drive, My hit ratios are okay, 
My import is killing me.

Any help appreciated.

Thanks
Raghu.
_
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Raghu Kota
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from 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: Application Context

2001-03-01 Thread Manasa Rao


Check this document:
http://osi.oracle.com/~tkyte/article2/index.htm
Good overall example of Application contexts and Fine Grain Access Control.


>From: "Andor Gyula" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: Application Context
>Date: Thu, 01 Mar 2001 06:15:48 -0800
>
>Hi Gurus !
>
>Where can I find detailed information with examples about how to use 
>application contexts?
>
>Thanks in advance
>Gyula
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Andor Gyula
>   INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>San Diego, California-- Public Internet access / Mailing Lists
>
>To REMOVE yourself from 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).

_
Get your FREE download of MSN Explorer at http://explorer.msn.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Manasa Rao
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from 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: ORU-10288 error, line length overflow.

2001-03-01 Thread Dasko, Dan


I'd guess that dbms_output has a 255 byte line limit regardless of other
parameters.

Dan

-Original Message-
Sent: Thursday, March 01, 2001 10:36 AM
To: Multiple recipients of list ORACLE-L


All,
I am getting this following error, when I execute a procedure.  And I made 
sure my linesize is 2000, and all variables are of good size. But still 
don't understand the source of this error. Appreciate any help.
Thanks
Radhika.


ORA-2: ORU-10028: line length overflow, limit of 255 bytes per line
ORA-06512: at "SYS.DBMS_OUTPUT", line 99
ORA-06512: at "SYS.DBMS_OUTPUT", line 65
ORA-06512: at "SECADMIN.ICPASSECSELECT", line 27
ORA-06512: at line 1


_
Get your FREE download of MSN Explorer at http://explorer.msn.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Manasa Rao
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from 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 e-mail message has been scanned for the presence of all known computer
viruses by the MessageLabs Virus Control Center.  However, it is still
recommended that you use local virus scanning software to monitor for the
presence of viruses.  
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Dasko, Dan
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from 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).

BFILE vs. BLOB

2001-03-01 Thread Koivu, Lisa

Title: BFILE vs. BLOB





Good morning all, 


I have to start storing binary files in our database somehow.  I'm reading up on BFILES and BLOBs. 


Seems like one of the differences is that BLOBs are manipulated within the database, and BFILEs are not.  Can anyone comment on how fast (or not fast) the DBMS_LOB. routines are when operating in fairly large BLOBs?  I'm leaning toward BFILEs to avoid having the database do anything other than just keep a pointer to the file and keep the transaction length as short as possible.  FWIW, I'll only need to accept a file and store it, and return it back to the app when requested.  

Another question:  Anyone using temporary BLOBs (8i)? 


Any comments, gotchas, boogie men are appreciated.


Thanks


Lisa Rutland Koivu
Oracle Database Administrator
Qode.com
4850 North State Road 7
Suite G104
Fort Lauderdale, FL  33319


V: 954.484.3191, x174
F: 954.484.2933 
C: 954.658.5849
http://www.qode.com


"The information contained herein does not express the opinion or position of Qode.com and cannot be attributed to or made binding upon Qode.com."

reset control, redo, logs etc

2001-03-01 Thread Leyden, Joseph


If my database was not shutdown before a cold
backup was made, how do I bring it back up
skipping (or resetting) ctl, headers etc.
Is this possible?

TIA
joe
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Leyden, Joseph
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from 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: AIX volume group backup?


It must be something about system managers, it makes them feel useful to do
this.  However, unless your databases are down when they are done, these
backups will be useless for recovery,  You need to have online or cold
backups of your databases when you are sure the databases are in the proper
state.

Ruth
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, February 28, 2001 9:55 PM


we have 2 AIX servers at a remote hosting location.  The host managers
insist on doing volume group backups once a month, for all volumes on each
server.

Why would they insist on doing this?

What purpose would these volume backups serve in a recovery situation?



Thx.

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Don Dealy II
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from 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.com
-- 
Author: Ruth Gramolini
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from 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:Invoking svrmgrl

2001-03-01 Thread GANTI . SIVA


svrmgrl

RE: eek!

Minnesota RULES!!  I love minnesota

-Original Message-
[EMAIL PROTECTED]
Sent: Thursday, March 01, 2001 9:16 AM
To: Multiple recipients of list ORACLE-L

Dennis,

Hope all is well there today.  I was a little
freaked when I heard about it on the radio
on the way home.

Glad you checked in to tell us you were
o.k.

Chere Machler
Gelco Information Network
In Minnesota where they don't have earthquakes

Dennis Taylor <[EMAIL PROTECTED]> on 02/28/2001 01:32:07 PM

Please respond to [EMAIL PROTECTED]

To:   Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:(bcc: Cherie Machler/GELCO)

At 11:17 AM 2/28/01 -0800, you wrote:
>We just had an earthquake. I'm fairly freeked.
>

See how freaked I was? I mis-spelled 'freaked'.

Dennis Taylor

Niels is bohring.

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Dennis Taylor
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from 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.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from 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.com
-- 
Author: Kevin Kostyszyn
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from 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: eek!

2001-03-01 Thread Dennis Taylor

At 10:46 AM 3/1/01 +0100, O'Neill, Sean wrote:
>So how are things post earth quake?.  Did you need to invoke any of your DR
>Plan?.  If so, sharing your experience on this would be useful after the
>dust settles =:-0

Nah. not enough damage here, except to my nerves. Seattle and Olympia
Washington got the real effects.

Dennis Taylor

let not the sands of time get in your lunch.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Dennis Taylor
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from 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).

OAS and iAS file size comparisons


OAS 4.0.8.2 for NT was 121M in size, zipped.

iAS for NT is two CDs in size, 569,609K + 403,131K.

What did they put in this new version that is so HUGE?

Unbelievable.

How big will Oracle 9i be, I wonder.

Patrice Boivin
Systems Analyst (Oracle Certified DBA)

Systems Admin & Operations | Admin. et Exploit. des systèmes
Technology Services| Services technologiques
Informatics Branch | Direction de l'informatique 
Maritimes Region, DFO  | Région des Maritimes, MPO

E-Mail: [EMAIL PROTECTED]  

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Boivin, Patrice J
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from 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: Oracle Author in People Magazine

2001-03-01 Thread Rocky Welch


The latter is possible, Rachel. As a matter of fact I'm gearing up for the
best 25th birthday I've had yet on Saturday. ;o)

--- Rachel Carmichael <[EMAIL PROTECTED]> wrote:
> I must be the oldest 25 around then... or else I've been 25 for more
> years 
> than I care to remember :)
> 
> but I do thank you for the compliment
> 
> 
> >From: "Carle, William T (Bill), NLCIO" <[EMAIL PROTECTED]>
> >Reply-To: [EMAIL PROTECTED]
> >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> >Subject: RE: Oracle Author in People Magazine
> >Date: Thu, 01 Mar 2001 07:00:58 -0800
> >
> >Rachel, you're only 25. Why would you care?
> >
> >
> >Bill Carle
> >AT&T
> >Database Administrator
> >816-995-3922
> >[EMAIL PROTECTED]
> >
> >  -Original Message-
> >Sent:Thursday, March 01, 2001 8:22 AM
> >To:  Multiple recipients of list ORACLE-L
> >Subject: Re: Oracle Author in People Magazine
> >
> >remind me not to get interviewed by them... who wants everyone to know
> how
> >old I am?  :)
> >
> >Seeing-eye horses? that is cool -- gonna have to go find that issue.
> >
> >
> > >From: Ari D Kaplan <[EMAIL PROTECTED]>
> > >Reply-To: [EMAIL PROTECTED]
> > >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> > >Subject: Oracle Author in People Magazine
> > >Date: Wed, 28 Feb 2001 15:05:23 -0800
> > >
> > >Has anyone seen the recent February 26th issue of People Magazine?
> > >
> > >There was a three-page article on Don Burleson's side-activity: his
> > >seeing-eye horses. Very cool ; they even wear shoes.
> > >
> > >If you do not know Don, he authored the "High-performance Oracle8
> > >Tuning" book.
> > >
> > >Now we know from the article that he is 44 years old ;)
> > >
> > >Take care,
> > >
> > >-Ari Kaplan
> > >
> > ><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->
> > ><-> For 400+ Oracle tips, visit:   <->
> > ><-><->
> > ><-> www.arikaplan.com  <->
> > ><-><->
> > ><-> email: [EMAIL PROTECTED]   <->
> > ><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->
> > >
> > >
> > >--
> > >Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > >--
> > >Author: Ari D Kaplan
> > >   INET: [EMAIL PROTECTED]
> > >
> > >Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> > >San Diego, California-- Public Internet access / Mailing
> Lists
> > >
> > >To REMOVE yourself from 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).
> >
> >_
> >Get your FREE download of MSN Explorer at http://explorer.msn.com
> >
> >--
> >Please see the official ORACLE-L FAQ: http://www.orafaq.com
> >--
> >Author: Rachel Carmichael
> >   INET: [EMAIL PROTECTED]
> >
> >Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> >San Diego, California-- Public Internet access / Mailing Lists
> >
> >To REMOVE yourself from 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.com
> >--
> >Author: Carle, William T (Bill), NLCIO
> >   INET: [EMAIL PROTECTED]
> >
> >Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> >San Diego, California-- Public Internet access / Mailing Lists
> >
> >To REMOVE yourself from 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).
> 
> _
> Get your FREE download of MSN Explorer at http://explorer.msn.com
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Rachel Carmichael
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, s

RE: Oracle's Updates Subscription Service

2001-03-01 Thread Mohan, Ross

Title: RE: Oracle's Updates Subscription Service



Interesting stuff. (Especially about the ruminants.)   When you 
say mysql does not scale, 
have 
you run into hard walls? if so, what is the data size, or is it the 
transaction/activity rate
that 
tanksi'd be interested in hearing where, if at all, you are "hitting the 
knee".
 
I'd 
love to get out there someday. Absolutely beautiful 
country.
 
thanks 
for the snapshot!

  -Original Message-From: Weaver, Walt 
  [mailto:[EMAIL PROTECTED]]Sent: Wednesday, February 28, 2001 
  1:01 PMTo: Multiple recipients of list ORACLE-LSubject: 
  RE: Oracle's Updates Subscription Service
  Well 
  Ross, Our campus is out in the country (just about everywhere in Montana is 
  out in the country) and we are, indeed, surrounded by docile ruminants. I'd 
  like to say that during our off-time we go out and gaze lovingly at their 
  udders, but there are other things we prefer to gaze at 
  lovingly.
   
  Of 
  course, we have no problems doing online dairy backups around here. 
  :>)
   
  We 
  use MySQL here and yes it's tunable. There's even word out on the street that 
  soon MySQL may support the concept of a transaction. What a 
  concept.
   
  MySQL has its place, but it's causing us no end of 
  pain here. It doesn't scale well enough to support what we're doing. That's 
  why we're painfully biting the bullet and paying the big bucks for 
  Oracle.
   
  --Walt Weaver
    Bozeman, Montana, USA
   
   
  
-Original Message-From: Mohan, Ross 
[mailto:[EMAIL PROTECTED]]Sent: Wednesday, February 28, 2001 
8:51 AMTo: Multiple recipients of list 
ORACLE-LSubject: RE: Oracle's Updates Subscription 
Service
Walt, you have just shattered my picture of you as a gentle 
man surrounded by docile ruminants, never uddering a 
discouraging word. 
Yes, it's amazing, the price of the software. My line to 
folks is: "For your money, Oracle is the best 
database...if it were my money, it would be almost 
anything but.." 
MySQL *is* tunable.could be fun 
-Original Message- From: 
Weaver, Walt [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, February 28, 2001 10:21 AM 
To: Multiple recipients of list ORACLE-L Subject: Oracle's Updates Subscription Service 
Say, is it just me or has the cost of the Updates 
Subscription Service gone up considerably in the 
past six months or so? 
We're currently pricing out what it'll cost us to purchase 
8.1.7 Standard Edition and the numbers we're getting 
are a heck of a lot higher than they were in 
November. 
Has the cost of CD-ROM's gone up that much? Is the economy 
now in an inflationary period? Where's Allen 
Greenspan when you need him? 
Whatever happened to those hazy, golden, halcyon days when 
upgrades were included in product support? 

Sometimes, Oracle just sucks. I'm seriously considering 
getting on track for a MySQL 
certification.   :>) 
--Walt Weaver   Bozeman, 
Montana, USA -- Please see 
the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Weaver, Walt   INET: [EMAIL PROTECTED] 
Fat City Network Services    -- (858) 
538-5051  FAX: (858) 538-5051 San Diego, 
California    -- Public Internet 
access / Mailing Lists  
To REMOVE yourself from 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).

MTS questions

2001-03-01 Thread Steff Gonos


For MTS experienced users;

I am installing 8.1.7 on Digital Unix (compaq).
Received the following error when I tried to create
an instance.  ORA-600 ( 16305).  Metalink says that
its a failure from the init.ora parameters but nothing 
more. 

Appreciate any help.
Steff Gonos

=
***
I don't suffer from insanity, I enjoy every minute of it. 
***

Steff Gonos  
[EMAIL PROTECTED]

__
Do You Yahoo!?
Get email at your own domain with Yahoo! Mail. 
http://personal.mail.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Steff Gonos
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from 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: Oracle Author in People Magazine


I must be the oldest 25 around then... or else I've been 25 for more years 
than I care to remember :)

but I do thank you for the compliment


>From: "Carle, William T (Bill), NLCIO" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: RE: Oracle Author in People Magazine
>Date: Thu, 01 Mar 2001 07:00:58 -0800
>
>Rachel, you're only 25. Why would you care?
>
>
>Bill Carle
>AT&T
>Database Administrator
>816-995-3922
>[EMAIL PROTECTED]
>
>  -Original Message-
>Sent:  Thursday, March 01, 2001 8:22 AM
>To:Multiple recipients of list ORACLE-L
>Subject:   Re: Oracle Author in People Magazine
>
>remind me not to get interviewed by them... who wants everyone to know how
>old I am?  :)
>
>Seeing-eye horses? that is cool -- gonna have to go find that issue.
>
>
> >From: Ari D Kaplan <[EMAIL PROTECTED]>
> >Reply-To: [EMAIL PROTECTED]
> >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> >Subject: Oracle Author in People Magazine
> >Date: Wed, 28 Feb 2001 15:05:23 -0800
> >
> >Has anyone seen the recent February 26th issue of People Magazine?
> >
> >There was a three-page article on Don Burleson's side-activity: his
> >seeing-eye horses. Very cool ; they even wear shoes.
> >
> >If you do not know Don, he authored the "High-performance Oracle8
> >Tuning" book.
> >
> >Now we know from the article that he is 44 years old ;)
> >
> >Take care,
> >
> >-Ari Kaplan
> >
> ><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->
> ><-> For 400+ Oracle tips, visit:   <->
> ><-><->
> ><-> www.arikaplan.com  <->
> ><-><->
> ><-> email: [EMAIL PROTECTED]   <->
> ><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->
> >
> >
> >--
> >Please see the official ORACLE-L FAQ: http://www.orafaq.com
> >--
> >Author: Ari D Kaplan
> >   INET: [EMAIL PROTECTED]
> >
> >Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> >San Diego, California-- Public Internet access / Mailing Lists
> >
> >To REMOVE yourself from 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).
>
>_
>Get your FREE download of MSN Explorer at http://explorer.msn.com
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Rachel Carmichael
>   INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>San Diego, California-- Public Internet access / Mailing Lists
>
>To REMOVE yourself from 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.com
>--
>Author: Carle, William T (Bill), NLCIO
>   INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>San Diego, California-- Public Internet access / Mailing Lists
>
>To REMOVE yourself from 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).

_
Get your FREE download of MSN Explorer at http://explorer.msn.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rachel Carmichael
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from 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: eek!

2001-03-01 Thread Mark Leith


As a part of my daily calls yesterday - imagine my shock when I phoned for a
regular contact of mine - to find that he was IN the train crash!!! He came
out OK though according to the receptionist, although he did lose his mobile
phone :( I just feel for the families of the ones that didn't make it.

I'm also about 25 miles away from a case of Foot & Mouth!

Sean, you can see the bad moon rising? I got a full one looming over head:)

-Original Message-
Carmichael
Sent: Thursday, March 01, 2001 02:22
To: Multiple recipients of list ORACLE-L


Sean,

I read about that crash this morning -- horrifying!  And they are saying
there is something like $1 billion worth of damage from the quake. My
friends in Gresham (Oregon) felt it as well.

You going to become a vegetarian based on the animal diseases raging over
there?

Dennis -- you okay? Family/home okay? Databases?

Rachel

>From: "O'Neill, Sean" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: RE: eek!
>Date: Thu, 01 Mar 2001 01:50:19 -0800
>
>Dennis,
>
>So how are things post earth quake?.  Did you need to invoke any of your DR
>Plan?.  If so, sharing your experience on this would be useful after the
>dust settles =:-0
>
>It's a hell of a wake up call to remind one why DR plans are important.
>
>The earthquake made news here in Ireland along with the impending foot &
>mouth disease crisis and even mentioned ahead of bad rail crash in England
>across the Irish sea where lives were lost.
>
>"I see the bad moon a risin'.  I see trouble on the way."
>
>Sean :)
>
>Rookie Data Base Administrator
>[0%] OCP Oracle8i DBA
>[0%] OCP Oracle9i DBA
>
>Organon (Ireland) Ltd.
>http://www.organon.ie
>E-mail: [EMAIL PROTECTED]   [subscribed: Digest Mode]
>
>Visit: http://groups.yahoo.com/group/Oracle-OCP-DBA
>
>"They tell me nothing, but expect me to know everything!"
>
>
>--
>
>  From: Dennis Taylor <[EMAIL PROTECTED]>
>  Date: Wed, 28 Feb 2001 11:20:18 -0800
>  Subject: eek!
>
>We just had an earthquake. I'm fairly freeked.
>
>How's everyone's disaster recover strategy? I'll think I'll be reviewing
>ours today.
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: O'Neill, Sean
>   INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>San Diego, California-- Public Internet access / Mailing Lists
>
>To REMOVE yourself from 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).

_
Get your FREE download of MSN Explorer at http://explorer.msn.com

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Rachel Carmichael
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from 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.com
-- 
Author: Mark Leith
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from 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: eek!

2001-03-01 Thread Dennis Taylor

At 06:21 AM 3/1/01 -0800, you wrote:
>Dennis -- you okay? Family/home okay? Databases?
>

People are a little shaken (yuk yuk), but that's all. We're considering
adequate punishment for our "singer".

Dennis Taylor

let not the sands of time get in your lunch.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Dennis Taylor
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from 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: Oracle's Updates Subscription Service

2001-03-01 Thread Henry Poras

I heard one reason that was done is because one of those costs is tax
deductable, but not the other (don't remember which).

Henry

-Original Message-
Sent: Wednesday, February 28, 2001 8:20 PM
To: Multiple recipients of list ORACLE-L

Cool, thanks for the info Sarah, I hadn't seen that split.  I'll check it
when I get our next bill.  I will be glad to be able to only pay for
upgrades which I use, and not the support, which I have not used in over 5
years.

-Original Message-
Sent: Wednesday, February 28, 2001 5:00 PM
To: Multiple recipients of list ORACLE-L

Walt,

Last summer we noticed our support bill was split into two pieces--one for
support and one for upgrades.  You can still buy both.  I didn't notice that
it was a lot more in total than before, but it does give a cost cutter a
chance to say we only need one of those pieces!

Sarah Satterthwaite
Case, Shiller, Weiss, Inc
Cambridge, MA

"Weaver, Walt" wrote:
> 
> Say, is it just me or has the cost of the Updates Subscription Service
gone
> up considerably in the past six months or so?
> 
> We're currently pricing out what it'll cost us to purchase 8.1.7 Standard
> Edition and the numbers we're getting are a heck of a lot higher than they
> were in November.
> 
> Has the cost of CD-ROM's gone up that much? Is the economy now in an
> inflationary period? Where's Allen Greenspan when you need him?
> 
> Whatever happened to those hazy, golden, halcyon days when upgrades were
> included in product support?
> 
> Sometimes, Oracle just sucks. I'm seriously considering getting on track
for
> a MySQL certification.   :>)
> 
> --Walt Weaver
>   Bozeman, Montana, USA
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Weaver, Walt
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from 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.com
-- 
Author: Sarah Satterthwaite
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from 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 email is intended for the
personal and confidential use of the addressee only. It may
also be privileged information. If you are not the intended
recipient then you are hereby notified that you have received
this document in error and that any review, distribution or
copying of this document is strictly prohibited. If you have
received  this communication in error, please notify Celltech
Group immediately on:

+44 (0)1753 534655, or email '[EMAIL PROTECTED]'

Celltech Group plc
216 Bath Road, Slough, SL1 4EN, Berkshire, UK

Registered Office as above. Registered in England No. 2159282
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Maser, Donna  (SEA)
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from 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.com
-- 
Author: Henry Poras
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from 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: ORU-10288 error, line length overflow.

2001-03-01 Thread Trassens, Christian


Increase your buffer output. Like this:

set serverout on size 

or 

dbms_output.enable();



> -Mensaje original-
> De:   Manasa Rao [SMTP:[EMAIL PROTECTED]]
> Enviado el:   jueves 1 de marzo de 2001 16:36
> Para: Multiple recipients of list ORACLE-L
> Asunto:   ORU-10288 error, line length overflow.
> 
> All,
> I am getting this following error, when I execute a procedure.  And I made
> 
> sure my linesize is 2000, and all variables are of good size. But still 
> don't understand the source of this error. Appreciate any help.
> Thanks
> Radhika.
> 
> 
> ORA-2: ORU-10028: line length overflow, limit of 255 bytes per line
> ORA-06512: at "SYS.DBMS_OUTPUT", line 99
> ORA-06512: at "SYS.DBMS_OUTPUT", line 65
> ORA-06512: at "SECADMIN.ICPASSECSELECT", line 27
> ORA-06512: at line 1
> 
> 
> _
> Get your FREE download of MSN Explorer at http://explorer.msn.com
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Manasa Rao
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from 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.com
-- 
Author: Trassens, Christian
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from 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).

Invoking svrmgrl

2001-03-01 Thread Witold Iwaniec


Hi

In one of my applications, that connects to Oracle database, I 
generate a package and have to compile it. The platform of the 
application - Windows while database can be on a remote machine.

I know that from my application I can call sqlplus to compile the 
package. For example:

sqlplus user/password@my_db @c:\temp\my_script.sql

but I think in some minimal installations you may not have sqlplus 
installed. 

I thought about calling svrmgrl but I don't think it accepts command 
line parameters. I tried to write small batch file:

svrmgrl
connect user/password@my_db
@c:\temp\my_script.sql

But it is not going to work -  the problem is that the commands are 
executed as three separate commands while I need to write the 
batch file so that the connect... and @c:\tmp\... commands are 
executed by server manager. Can anyone show me the correct 
way to write the batch file?

Or maybe there is another way - in my application I am already 
connected to the database using ODBC API. 

Thanks

Witold





==
Witold Iwaniec
Senior Software Developer
NovaLIS Technologies
[EMAIL PROTECTED] 
http://www.novalistech.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Witold Iwaniec
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from 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: Application Context

2001-03-01 Thread Dennis Taylor

At 07:31 AM 3/1/01 -0800, you wrote:
>Check this document:
>http://osi.oracle.com/~tkyte/article2/index.htm

page cannot be found.

Dennis Taylor

let not the sands of time get in your lunch.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Dennis Taylor
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from 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: Oracle Author in People Magazine


Happy "25th" in advance!


>From: Rocky Welch <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: RE: Oracle Author in People Magazine
>Date: Thu, 01 Mar 2001 08:10:55 -0800
>
>The latter is possible, Rachel. As a matter of fact I'm gearing up for the
>best 25th birthday I've had yet on Saturday. ;o)
>
>--- Rachel Carmichael <[EMAIL PROTECTED]> wrote:
> > I must be the oldest 25 around then... or else I've been 25 for more
> > years
> > than I care to remember :)
> >
> > but I do thank you for the compliment
> >
> >
> > >From: "Carle, William T (Bill), NLCIO" <[EMAIL PROTECTED]>
> > >Reply-To: [EMAIL PROTECTED]
> > >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> > >Subject: RE: Oracle Author in People Magazine
> > >Date: Thu, 01 Mar 2001 07:00:58 -0800
> > >
> > >Rachel, you're only 25. Why would you care?
> > >
> > >
> > >Bill Carle
> > >AT&T
> > >Database Administrator
> > >816-995-3922
> > >[EMAIL PROTECTED]
> > >
> > >  -Original Message-
> > >Sent:  Thursday, March 01, 2001 8:22 AM
> > >To:Multiple recipients of list ORACLE-L
> > >Subject:   Re: Oracle Author in People Magazine
> > >
> > >remind me not to get interviewed by them... who wants everyone to know
> > how
> > >old I am?  :)
> > >
> > >Seeing-eye horses? that is cool -- gonna have to go find that issue.
> > >
> > >
> > > >From: Ari D Kaplan <[EMAIL PROTECTED]>
> > > >Reply-To: [EMAIL PROTECTED]
> > > >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> > > >Subject: Oracle Author in People Magazine
> > > >Date: Wed, 28 Feb 2001 15:05:23 -0800
> > > >
> > > >Has anyone seen the recent February 26th issue of People Magazine?
> > > >
> > > >There was a three-page article on Don Burleson's side-activity: his
> > > >seeing-eye horses. Very cool ; they even wear shoes.
> > > >
> > > >If you do not know Don, he authored the "High-performance Oracle8
> > > >Tuning" book.
> > > >
> > > >Now we know from the article that he is 44 years old ;)
> > > >
> > > >Take care,
> > > >
> > > >-Ari Kaplan
> > > >
> > > ><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->
> > > ><-> For 400+ Oracle tips, visit:   <->
> > > ><-><->
> > > ><-> www.arikaplan.com  <->
> > > ><-><->
> > > ><-> email: [EMAIL PROTECTED]   <->
> > > ><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->
> > > >
> > > >
> > > >--
> > > >Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > > >--
> > > >Author: Ari D Kaplan
> > > >   INET: [EMAIL PROTECTED]
> > > >
> > > >Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> > > >San Diego, California-- Public Internet access / Mailing
> > Lists
> > > >
> > > >To REMOVE yourself from 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).
> > >
> > >_
> > >Get your FREE download of MSN Explorer at http://explorer.msn.com
> > >
> > >--
> > >Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > >--
> > >Author: Rachel Carmichael
> > >   INET: [EMAIL PROTECTED]
> > >
> > >Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> > >San Diego, California-- Public Internet access / Mailing Lists
> > >
> > >To REMOVE yourself from 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.com
> > >--
> > >Author: Carle, William T (Bill), NLCIO
> > >   INET: [EMAIL PROTECTED]
> > >
> > >Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> > >San Diego, California-- Public Internet access / Mailing Lists
> > >
> > >To REMOVE yourself from 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:RE: eek!

2001-03-01 Thread dgoulet


Hummm!!  Must be a week for disasters.  We've had a multi DB development box
crashing for the first 3 days of this week.  Right now the HP rep is in there
with his head inside the chassis & parts all over the place outside!!  Sure that
earthquake was in the NorthWest?  Looks like splattered quite a bit over here
too!!  Thank God tomorrow's Friday! :-)

Dick Goulet

Reply Separator
Author: "Mark Leith" <[EMAIL PROTECTED]>
Date:   3/1/2001 7:45 AM

As a part of my daily calls yesterday - imagine my shock when I phoned for a
regular contact of mine - to find that he was IN the train crash!!! He came
out OK though according to the receptionist, although he did lose his mobile
phone :( I just feel for the families of the ones that didn't make it.

I'm also about 25 miles away from a case of Foot & Mouth!

Sean, you can see the bad moon rising? I got a full one looming over head:)

-Original Message-
Carmichael
Sent: Thursday, March 01, 2001 02:22
To: Multiple recipients of list ORACLE-L


Sean,

I read about that crash this morning -- horrifying!  And they are saying
there is something like $1 billion worth of damage from the quake. My
friends in Gresham (Oregon) felt it as well.

You going to become a vegetarian based on the animal diseases raging over
there?

Dennis -- you okay? Family/home okay? Databases?

Rachel

>From: "O'Neill, Sean" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: RE: eek!
>Date: Thu, 01 Mar 2001 01:50:19 -0800
>
>Dennis,
>
>So how are things post earth quake?.  Did you need to invoke any of your DR
>Plan?.  If so, sharing your experience on this would be useful after the
>dust settles =:-0
>
>It's a hell of a wake up call to remind one why DR plans are important.
>
>The earthquake made news here in Ireland along with the impending foot &
>mouth disease crisis and even mentioned ahead of bad rail crash in England
>across the Irish sea where lives were lost.
>
>"I see the bad moon a risin'.  I see trouble on the way."
>
>Sean :)
>
>Rookie Data Base Administrator
>[0%] OCP Oracle8i DBA
>[0%] OCP Oracle9i DBA
>
>Organon (Ireland) Ltd.
>http://www.organon.ie
>E-mail: [EMAIL PROTECTED]   [subscribed: Digest Mode]
>
>Visit: http://groups.yahoo.com/group/Oracle-OCP-DBA
>
>"They tell me nothing, but expect me to know everything!"
>
>
>--
>
>  From: Dennis Taylor <[EMAIL PROTECTED]>
>  Date: Wed, 28 Feb 2001 11:20:18 -0800
>  Subject: eek!
>
>We just had an earthquake. I'm fairly freeked.
>
>How's everyone's disaster recover strategy? I'll think I'll be reviewing
>ours today.
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: O'Neill, Sean
>   INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>San Diego, California-- Public Internet access / Mailing Lists
>
>To REMOVE yourself from 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).

_
Get your FREE download of MSN Explorer at http://explorer.msn.com

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Rachel Carmichael
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from 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.com
-- 
Author: Mark Leith
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from 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.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San

RE: Invoking svrmgrl

2001-03-01 Thread Witold Iwaniec



Thanks for the reply. It does the job.

I didn't try to invoke svrmgrl with script on the command line.
I tried:
svrmgrl connect system/manager@my_db

and the command failed with Server Manager Command Line error...

Thanks

Witold


On 1 Mar 2001, at 19:45, âÅÌÏ× éÇÏÒØ éÏÓÉÆÏ×É   Þ wrote:

> s1.bat
> 
> svrmgrl @s2.sql
> 
>
> s2.sql
> =
> connect system/manager
> @my_sql.sql
> 
>
> my_sql.sql
> 
> select * from scott.emp
> /
> exit
> /
> 
>
> >  -Original Message-
> > From:   Witold Iwaniec [mailto:[EMAIL PROTECTED]]
> > Sent:   Thursday, March 01, 2001 7:16 PM
> > To: Multiple recipients of list ORACLE-L
> > Subject:Invoking svrmgrl
> >
> > Hi
> >
> > In one of my applications, that connects to Oracle database, I
> > generate a package and have to compile it. The platform of the
> > application - Windows while database can be on a remote machine.
> >
> > I know that from my application I can call sqlplus to compile the
> > package. For example:
> >
> > sqlplus user/password@my_db @c:\temp\my_script.sql
> >
> > but I think in some minimal installations you may not have sqlplus
> > installed.
> >
> > I thought about calling svrmgrl but I don't think it accepts command
> > line parameters. I tried to write small batch file:
> >
> > svrmgrl
> > connect user/password@my_db
> > @c:\temp\my_script.sql
> >
> > But it is not going to work -  the problem is that the commands are
> > executed as three separate commands while I need to write the
> > batch file so that the connect... and @c:\tmp\... commands are
> > executed by server manager. Can anyone show me the correct
> > way to write the batch file?
> >
> > Or maybe there is another way - in my application I am already
> > connected to the database using ODBC API.
> >
> > Thanks
> >
> > Witold
> >
> >
> >
> >
> >
> > ==
> > Witold Iwaniec
> > Senior Software Developer
> > NovaLIS Technologies
> > [EMAIL PROTECTED]
> > http://www.novalistech.com
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Witold Iwaniec
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> > San Diego, California-- Public Internet access / Mailing Lists
> > 
> > To REMOVE yourself from 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).
> > ÷ÉÒÕÓÙ ÎÅ ÏÂÎÁÒÕÖÅÎÙ. ðÒÏ×ÅÒÉÌ AVP for MS Exchange.


--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Witold Iwaniec
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from 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: * Oracle DBAs Needed in the Virginia Beach VA Area..

2001-03-01 Thread Janardhana Babu


Issue Upgrade Catalog command in your recovery catalog database.

-Original Message-
Sent: Thursday, March 01, 2001 7:07 AM
To: Multiple recipients of list ORACLE-L


Hi List Friends, 

I have server A: Solaris 5.8, RDBMS 8.1.7.0.0 and server B: Solaris 5.8 &
the RDBMS was upgraded from 8.0.5 to 8.1.7. 

RDBMS 8.1.7 is my recovery manager target database and the other is my
catalog database. 
When I try to register this 8.1.7 target database to this upgraded 8.1.7
catalog database,  I am getting:


RMAN> connect target sys/password@target_db 
RMAN> connected to target database: CATALOG
RMAN> connected to recovery catalog database
RMAN-06186: PL/SQL package SYS.DBMS_RCVMAN version 08.00.05 in TARGET
database i 
s too old 
RMAN-00571: === 
RMAN-00569: === ERROR MESSAGE STACK FOLLOWS === 
RMAN-00571: === 
RMAN-0058: error encountered while parsing input commands
RMAN-01006: error signalled during parse
 

What can I do to correct this problem, IF ANY? 


many thanks,


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Anne Yu
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from 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.com
-- 
Author: Janardhana Babu
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from 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: eek!

Don't shake her up too much...

; )

Patrice Boivin
Systems Analyst (Oracle Certified DBA)

-Original Message-
From:   Dennis Taylor [SMTP:[EMAIL PROTECTED]]
Sent:   Thursday, March 01, 2001 11:26 AM
To: Multiple recipients of list ORACLE-L
Subject:RE: eek!

At 06:21 AM 3/1/01 -0800, you wrote:
>Dennis -- you okay? Family/home okay? Databases?
>

People are a little shaken (yuk yuk), but that's all. We're
considering
adequate punishment for our "singer".

Dennis Taylor

let not the sands of time get in your lunch.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Dennis Taylor
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing
Lists

To REMOVE yourself from 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.com
-- 
Author: Boivin, Patrice J
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from 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: OAS and iAS file size comparisons

2001-03-01 Thread Seley, Linda


Everything but the kitchen sink..  9iAS includes Apache, Forms Server,
Reports Server, Portal, DB Cache, Discoverer Server, Queue Manager, Wireless
if you want it, and possibly others I've left out.  Consider yourself lucky
if you only had 2 CDs, we (Solaris) had 3.

Linda
(installed but not working)

-Original Message-
Sent: Thursday, March 01, 2001 8:32 AM
To: Multiple recipients of list ORACLE-L


OAS 4.0.8.2 for NT was 121M in size, zipped.

iAS for NT is two CDs in size, 569,609K + 403,131K.

What did they put in this new version that is so HUGE?

Unbelievable.

How big will Oracle 9i be, I wonder.

Patrice Boivin
Systems Analyst (Oracle Certified DBA)

Systems Admin & Operations | Admin. et Exploit. des systèmes
Technology Services| Services technologiques
Informatics Branch | Direction de l'informatique 
Maritimes Region, DFO  | Région des Maritimes, MPO

E-Mail: [EMAIL PROTECTED]  

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Boivin, Patrice J
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from 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.com
--
Author: Seley, Linda
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from 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: eek!


thank goodness your friend is alright.

that wreck was a horror from what I read. Those poor families.

>From: "Mark Leith" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: RE: eek!
>Date: Thu, 01 Mar 2001 07:45:27 -0800
>
>As a part of my daily calls yesterday - imagine my shock when I phoned for 
>a
>regular contact of mine - to find that he was IN the train crash!!! He came
>out OK though according to the receptionist, although he did lose his 
>mobile
>phone :( I just feel for the families of the ones that didn't make it.
>
>I'm also about 25 miles away from a case of Foot & Mouth!
>
>Sean, you can see the bad moon rising? I got a full one looming over head:)
>
>-Original Message-
>Carmichael
>Sent: Thursday, March 01, 2001 02:22
>To: Multiple recipients of list ORACLE-L
>
>
>Sean,
>
>I read about that crash this morning -- horrifying!  And they are saying
>there is something like $1 billion worth of damage from the quake. My
>friends in Gresham (Oregon) felt it as well.
>
>You going to become a vegetarian based on the animal diseases raging over
>there?
>
>Dennis -- you okay? Family/home okay? Databases?
>
>Rachel
>
> >From: "O'Neill, Sean" <[EMAIL PROTECTED]>
> >Reply-To: [EMAIL PROTECTED]
> >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> >Subject: RE: eek!
> >Date: Thu, 01 Mar 2001 01:50:19 -0800
> >
> >Dennis,
> >
> >So how are things post earth quake?.  Did you need to invoke any of your 
>DR
> >Plan?.  If so, sharing your experience on this would be useful after the
> >dust settles =:-0
> >
> >It's a hell of a wake up call to remind one why DR plans are important.
> >
> >The earthquake made news here in Ireland along with the impending foot &
> >mouth disease crisis and even mentioned ahead of bad rail crash in 
>England
> >across the Irish sea where lives were lost.
> >
> >"I see the bad moon a risin'.  I see trouble on the way."
> >
> >Sean :)
> >
> >Rookie Data Base Administrator
> >[0%] OCP Oracle8i DBA
> >[0%] OCP Oracle9i DBA
> >
> >Organon (Ireland) Ltd.
> >http://www.organon.ie
> >E-mail: [EMAIL PROTECTED]   [subscribed: Digest Mode]
> >
> >Visit: http://groups.yahoo.com/group/Oracle-OCP-DBA
> >
> >"They tell me nothing, but expect me to know everything!"
> >
> >
> >--
> >
> >  From: Dennis Taylor <[EMAIL PROTECTED]>
> >  Date: Wed, 28 Feb 2001 11:20:18 -0800
> >  Subject: eek!
> >
> >We just had an earthquake. I'm fairly freeked.
> >
> >How's everyone's disaster recover strategy? I'll think I'll be reviewing
> >ours today.
> >--
> >Please see the official ORACLE-L FAQ: http://www.orafaq.com
> >--
> >Author: O'Neill, Sean
> >   INET: [EMAIL PROTECTED]
> >
> >Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> >San Diego, California-- Public Internet access / Mailing Lists
> >
> >To REMOVE yourself from 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).
>
>_
>Get your FREE download of MSN Explorer at http://explorer.msn.com
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Rachel Carmichael
>   INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>San Diego, California-- Public Internet access / Mailing Lists
>
>To REMOVE yourself from 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.com
>--
>Author: Mark Leith
>   INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>San Diego, California-- Public Internet access / Mailing Lists
>
>To REMOVE yourself from 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).

_
Get your FREE download of MSN Explorer at http://explorer.msn.com

-- 
Please see the official ORACLE-L FAQ: http://www.or

RE: ORU-10288 error, line length overflow.

2001-03-01 Thread Vadim Gorbounov


Nope,
This will not work. Line length is limited to 255 and couldnt be increased.
Buffer size is something different.
Consider splitting your output into several dbms_output.put_line's
Vadim Gorbounov
Oracle DBA


-Original Message-
Sent: Thursday, March 01, 2001 11:32 AM
To: Multiple recipients of list ORACLE-L


Increase your buffer output. Like this:

set serverout on size 

or 

dbms_output.enable();



> -Mensaje original-
> De:   Manasa Rao [SMTP:[EMAIL PROTECTED]]
> Enviado el:   jueves 1 de marzo de 2001 16:36
> Para: Multiple recipients of list ORACLE-L
> Asunto:   ORU-10288 error, line length overflow.
> 
> All,
> I am getting this following error, when I execute a procedure.  And I made
> 
> sure my linesize is 2000, and all variables are of good size. But still 
> don't understand the source of this error. Appreciate any help.
> Thanks
> Radhika.
> 
> 
> ORA-2: ORU-10028: line length overflow, limit of 255 bytes per line
> ORA-06512: at "SYS.DBMS_OUTPUT", line 99
> ORA-06512: at "SYS.DBMS_OUTPUT", line 65
> ORA-06512: at "SECADMIN.ICPASSECSELECT", line 27
> ORA-06512: at line 1
> 
> 
> _
> Get your FREE download of MSN Explorer at http://explorer.msn.com
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Manasa Rao
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from 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.com
-- 
Author: Trassens, Christian
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from 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.com
-- 
Author: Vadim Gorbounov
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from 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: reset control, redo, logs etc

2001-03-01 Thread Koivu, Lisa

Title: RE: reset control, redo, logs etc





If your database was not shut down, it was not a cold backup. 
If your tablespaces were not in backup mode, good luck.  Everything will be out of sync.  


I suggest taking a true cold backup before doing anything else if you want to save this database. Start with SHUTTING IT DOWN.

Lisa Rutland Koivu
Oracle Database Administrator
Qode.com
4850 North State Road 7
Suite G104
Fort Lauderdale, FL  33319


V: 954.484.3191, x174
F: 954.484.2933 
C: 954.658.5849
http://www.qode.com


"The information contained herein does not express the opinion or position of Qode.com and cannot be attributed to or made binding upon Qode.com."


-Original Message-
From: Leyden, Joseph [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 01, 2001 11:45 AM
To: Multiple recipients of list ORACLE-L
Subject: reset control, redo, logs etc



If my database was not shutdown before a cold
backup was made, how do I bring it back up
skipping (or resetting) ctl, headers etc.
Is this possible?


TIA
joe
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Leyden, Joseph
  INET: [EMAIL PROTECTED]


Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California    -- Public Internet access / Mailing Lists

To REMOVE yourself from 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: Invoking svrmgrl

2001-03-01 Thread Mike Killough


Try putting the connect in the script:

shut.sql =
connect internal
shutdown immediate;
exit;

svrmgrl @shut



>From: "Witold Iwaniec" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: Invoking svrmgrl
>Date: Thu, 01 Mar 2001 08:16:02 -0800
>
>Hi
>
>In one of my applications, that connects to Oracle database, I
>generate a package and have to compile it. The platform of the
>application - Windows while database can be on a remote machine.
>
>I know that from my application I can call sqlplus to compile the
>package. For example:
>
>sqlplus user/password@my_db @c:\temp\my_script.sql
>
>but I think in some minimal installations you may not have sqlplus
>installed.
>
>I thought about calling svrmgrl but I don't think it accepts command
>line parameters. I tried to write small batch file:
>
>svrmgrl
>connect user/password@my_db
>@c:\temp\my_script.sql
>
>But it is not going to work -  the problem is that the commands are
>executed as three separate commands while I need to write the
>batch file so that the connect... and @c:\tmp\... commands are
>executed by server manager. Can anyone show me the correct
>way to write the batch file?
>
>Or maybe there is another way - in my application I am already
>connected to the database using ODBC API.
>
>Thanks
>
>Witold
>
>
>
>
>
>==
>Witold Iwaniec
>Senior Software Developer
>NovaLIS Technologies
>[EMAIL PROTECTED]
>http://www.novalistech.com
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Witold Iwaniec
>   INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>San Diego, California-- Public Internet access / Mailing Lists
>
>To REMOVE yourself from 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).

_
Get your FREE download of MSN Explorer at http://explorer.msn.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mike Killough
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from 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: * Oracle DBAs Needed in the Virginia Beach VA Area..

2001-03-01 Thread Janardhana Babu



Connect to target and catalog databases and issue upgrade catalog command at
RMAN prompt.
You may be asked to enter the command twice, just like password
confirmation.

-- Babu

-Original Message-
Sent: Thursday, March 01, 2001 10:03 AM
To: 'Janardhana Babu'
Cc: Anne Yu



Thanks for replying to my email.   I don't know where to issue that command.



-Original Message-
Sent: Thursday, March 01, 2001 11:07 AM
To: '[EMAIL PROTECTED]'
Cc: 'Anne Yu'


Issue Upgrade Catalog command in your recovery catalog database.

-Original Message-
Sent: Thursday, March 01, 2001 7:07 AM
To: Multiple recipients of list ORACLE-L


Hi List Friends, 

I have server A: Solaris 5.8, RDBMS 8.1.7.0.0 and server B: Solaris 5.8 &
the RDBMS was upgraded from 8.0.5 to 8.1.7. 

RDBMS 8.1.7 is my recovery manager target database and the other is my
catalog database. 
When I try to register this 8.1.7 target database to this upgraded 8.1.7
catalog database,  I am getting:


RMAN> connect target sys/password@target_db 
RMAN> connected to target database: CATALOG
RMAN> connected to recovery catalog database
RMAN-06186: PL/SQL package SYS.DBMS_RCVMAN version 08.00.05 in TARGET
database i 
s too old 
RMAN-00571: === 
RMAN-00569: === ERROR MESSAGE STACK FOLLOWS === 
RMAN-00571: === 
RMAN-0058: error encountered while parsing input commands
RMAN-01006: error signalled during parse
 

What can I do to correct this problem, IF ANY? 


many thanks,


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Anne Yu
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from 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.com
-- 
Author: Janardhana Babu
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from 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).

OAS Installation problem

2001-03-01 Thread Vinod Nagaraj


hi guys,

I installed OAS 4.0 on a NT server successfully.Then as per the post
installation tasks in the installation guide i followed the following
1) Rebooted the machine
2) connecting to the welcome page using
http://hostname.domain:port_number
3) Entered the node manager username and password to get the welcome
page

In the next step he says to bring up the OAS manager page and once
connected to the welcome page,click on the OAS manager icon

My problem is, i am not able to find OAS manager page or OAS manager
icon
pls can anyone guide me how to get this as i am new to this technology

vinod


begin:vcard 
n:Nagaraj;Vinod
tel;cell:303-332-7223
tel;work:720-962-4355
x-mozilla-html:FALSE
adr:;;
version:2.1
email;internet:[EMAIL PROTECTED]
fn:Vinod Kumar Nagaraj
end:vcard

ora 27146 error ?

2001-03-01 Thread Leslie Lu


Hi all,

When I try to startup an instance, I got this:
ORA-27146: post/wait initialization failed

And this is what the document suggests:
27146, , "post/wait initialization failed"
// *Cause:  OS system call failed
// *Action: check errno and contact Oracle Support

Anybody has any solution?  Thank you.


Leslie

__
Do You Yahoo!?
Get email at your own domain with Yahoo! Mail. 
http://personal.mail.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Leslie Lu
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from 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: reset control, redo, logs etc


The best thing you can do is shut the database down.  Do a cold back and
through the other one away.  Just because you did a backup doesn't mean that
you database is in a strange state.  Just start over.


Just my $0.02,
Ruth

- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, March 01, 2001 11:45 AM


> If my database was not shutdown before a cold
> backup was made, how do I bring it back up
> skipping (or resetting) ctl, headers etc.
> Is this possible?
>
> TIA
> joe
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Leyden, Joseph
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from 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.com
-- 
Author: Ruth Gramolini
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from 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: * Oracle DBAs Needed in the Virginia Beach VA Area..

2001-03-01 Thread Kimberly Smith


Hum... The subject seems to be a little off here...

-Original Message-
Sent: Thursday, March 01, 2001 10:36 AM
To: Multiple recipients of list ORACLE-L



Connect to target and catalog databases and issue upgrade catalog command at
RMAN prompt.
You may be asked to enter the command twice, just like password
confirmation.

-- Babu

-Original Message-
Sent: Thursday, March 01, 2001 10:03 AM
To: 'Janardhana Babu'
Cc: Anne Yu



Thanks for replying to my email.   I don't know where to issue that command.



-Original Message-
Sent: Thursday, March 01, 2001 11:07 AM
To: '[EMAIL PROTECTED]'
Cc: 'Anne Yu'


Issue Upgrade Catalog command in your recovery catalog database.

-Original Message-
Sent: Thursday, March 01, 2001 7:07 AM
To: Multiple recipients of list ORACLE-L


Hi List Friends, 

I have server A: Solaris 5.8, RDBMS 8.1.7.0.0 and server B: Solaris 5.8 &
the RDBMS was upgraded from 8.0.5 to 8.1.7. 

RDBMS 8.1.7 is my recovery manager target database and the other is my
catalog database. 
When I try to register this 8.1.7 target database to this upgraded 8.1.7
catalog database,  I am getting:


RMAN> connect target sys/password@target_db 
RMAN> connected to target database: CATALOG
RMAN> connected to recovery catalog database
RMAN-06186: PL/SQL package SYS.DBMS_RCVMAN version 08.00.05 in TARGET
database i 
s too old 
RMAN-00571: === 
RMAN-00569: === ERROR MESSAGE STACK FOLLOWS === 
RMAN-00571: === 
RMAN-0058: error encountered while parsing input commands
RMAN-01006: error signalled during parse
 

What can I do to correct this problem, IF ANY? 


many thanks,


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Anne Yu
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from 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.com
-- 
Author: Janardhana Babu
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from 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.com
-- 
Author: Kimberly Smith
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from 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: Oracle Author in People Magazine


A quarter of a century old.

I can't believe I passed that landmark already!

Ugh.

Patrice Boivin
Systems Analyst (Oracle Certified DBA)



-Original Message-
From:   Carle, William T (Bill), NLCIO [SMTP:[EMAIL PROTECTED]]
Sent:   Thursday, March 01, 2001 11:01 AM
To: Multiple recipients of list ORACLE-L
Subject:RE: Oracle Author in People Magazine

Rachel, you're only 25. Why would you care?


Bill Carle
AT&T
Database Administrator
816-995-3922
[EMAIL PROTECTED]

 -Original Message-
Sent:   Thursday, March 01, 2001 8:22 AM
To: Multiple recipients of list ORACLE-L
Subject:Re: Oracle Author in People Magazine

remind me not to get interviewed by them... who wants everyone to
know how 
old I am?  :)

Seeing-eye horses? that is cool -- gonna have to go find that issue.


>From: Ari D Kaplan <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: Oracle Author in People Magazine
>Date: Wed, 28 Feb 2001 15:05:23 -0800
>
>Has anyone seen the recent February 26th issue of People Magazine?
>
>There was a three-page article on Don Burleson's side-activity: his
>seeing-eye horses. Very cool ; they even wear shoes.
>
>If you do not know Don, he authored the "High-performance Oracle8
>Tuning" book.
>
>Now we know from the article that he is 44 years old ;)
>
>Take care,
>
>-Ari Kaplan
>
><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->
><-> For 400+ Oracle tips, visit:   <->
><-><->
><-> www.arikaplan.com  <->
><-><->
><-> email: [EMAIL PROTECTED]   <->
><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->
>
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Ari D Kaplan
>   INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>San Diego, California-- Public Internet access / Mailing
Lists

>
>To REMOVE yourself from 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).

_
Get your FREE download of MSN Explorer at http://explorer.msn.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rachel Carmichael
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing
Lists

To REMOVE yourself from 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.com
-- 
Author: Carle, William T (Bill), NLCIO
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing
Lists

To REMOVE yourself from 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.com
-- 
Author: Boivin, Patrice J
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mai

RE: hsodbc/Merant connection to MSSQL

2001-03-01 Thread Ed Maurer

Title: export / import 8.1.5 to 8.0 ?



Anyone 
succeeded in getting hsodbc working (8.1.x);
I need 
to get this up (Oracle to MSSQL 2K on Win2K);
 
TG4MSQL is not viable as it isn't 
supported
on 
W2K; can't wait for 'promised' upgrades. Merant seemed
to be 
the way to go; but I've been unable to get that
connection working either through hsodbc; 
I've
been 
over my listener configs about 200 times 
already and all appears in order.
 
Success / Failure stories much 
welcome.
 
 
TIA
 
Ed Maurer
AcquireX

RE: OAS and iAS file size comparisons

2001-03-01 Thread Thater, William


On Thu, 1 Mar 2001,Seley, Linda scribbled on the wall in glitter crayon:

->Everything but the kitchen sink..  9iAS includes Apache, Forms Server,
->Reports Server, Portal, DB Cache, Discoverer Server, Queue Manager, Wireless
->if you want it, and possibly others I've left out.  Consider yourself lucky
->if you only had 2 CDs, we (Solaris) had 3.
->
->Linda
->(installed but not working)

here it's installed [well mostly anyway.;-)] and working.  but let's say the
installation guide and configuration information was... um less than
optimal.

--
Bill Thater Certified ORACLE DBA
Telergy, Inc.[EMAIL PROTECTED]
~
You gotta program like you don't need the money,
You gotta compile like you'll never get hurt,
You gotta run like there's nobody watching,
It's gotta come from the heart if you want it to work.
~
You never finish a program, you just stop working on it.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Thater, William
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from 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: reset control, redo, logs etc


I would think that it is definately in a strange state.  I know that if you
did this with NT, meaning the database was running and you copied the files
to another location.  I am pretty sure you wouldn't be able to get it to
run, I am not even sure that it would copy all of the files.
Kev

-Original Message-
Gramolini
Sent: Thursday, March 01, 2001 1:01 PM
To: Multiple recipients of list ORACLE-L


The best thing you can do is shut the database down.  Do a cold back and
through the other one away.  Just because you did a backup doesn't mean that
you database is in a strange state.  Just start over.


Just my $0.02,
Ruth

- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, March 01, 2001 11:45 AM


> If my database was not shutdown before a cold
> backup was made, how do I bring it back up
> skipping (or resetting) ctl, headers etc.
> Is this possible?
>
> TIA
> joe
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Leyden, Joseph
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from 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.com
--
Author: Ruth Gramolini
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from 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.com
-- 
Author: Kevin Kostyszyn
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from 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: DBWR slaves in NT???

2001-03-01 Thread Mohan, Ross

Title: RE: DBWR slaves in NT???





not a dbwriter problem.


on a "single-disk wonder", your best
bet is to DUMP all indexes on loadable
tables, then load your data, then rebuild
the indexes.


of course, that might take just as long. 


any possiblity of getting more disk?
like, several? a raid controller?


mit gluck!




-Original Message-
From: Raghu Kota [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 01, 2001 11:26 AM
To: Multiple recipients of list ORACLE-L
Subject: DBWR slaves in NT???



Hi Friends


I have toad tool for my NT database


DBWR Average Scan Depth 1024  **Number of DB_Files too high??


I got doubt due to from v$waitstat I got data block waits some time 8000 and 
some times higher number. How can I increase the DBWR slaves on NT?? 
although I set in development box, How can I see as background process 
really working for me??


I have my datafile and indexes same on E disk drive, My hit ratios are okay, 
My import is killing me.


Any help appreciated.


Thanks
Raghu.
_
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Raghu Kota
  INET: [EMAIL PROTECTED]


Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California    -- Public Internet access / Mailing Lists

To REMOVE yourself from 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).

ORA-20000: Unable to compile TRIGGER "MWH"."CDH_AFT_UPD_ROW"

2001-03-01 Thread Charlie Mengler


Oracle V7.3.4.3 on V2.6 Solaris
For all practical purposes "MWH" owns all objects in this application.
AFAIK The object does exist as shown below and as the owner and with
CREATE ANY PROCEDURE priv MWH should be able to compile it.

So why do I keep getting these ORA-2 errors?



SQL> exec dbms_ddl.alter_compile('TRIGGER',user,'CDH_AFT_UPD_ROW');
begin dbms_ddl.alter_compile('TRIGGER',user,'CDH_AFT_UPD_ROW'); end;

*
ERROR at line 1:
ORA-2: Unable to compile TRIGGER "MWH"."CDH_AFT_UPD_ROW", insufficient
privileges or does not exist
ORA-06512: at "SYS.DBMS_DDL", line 47
ORA-06512: at line 1


SQL> sho user
user is "MWH"
SQL> exec dbms_ddl.alter_compile('TRIGGER','MWH','CDH_AFT_UPD_ROW');
begin dbms_ddl.alter_compile('TRIGGER','MWH','CDH_AFT_UPD_ROW'); end;

*
ERROR at line 1:
ORA-2: Unable to compile TRIGGER "MWH"."CDH_AFT_UPD_ROW", insufficient
privileges or does not exist
ORA-06512: at "SYS.DBMS_DDL", line 47
ORA-06512: at line 1


SQL> select * from user_objects where object_name = 'CDH_AFT_UPD_ROW'; 
#:-)

OBJECT_NAME

 OBJECT_ID OBJECT_TYPE   CREATED   LAST_DDL_
-- - - -
TIMESTAMP
---
STATUS
---
CDH_AFT_UPD_ROW
 49325 TRIGGER   14-MAR-99 01-MAR-01
2001-03-01:10:19:34
VALID

SQL> connect sys/pass
Connected.
SQL> grant execute on dbms_ddl to MWH;

Grant succeeded.

SQL> connect mwh/pass
Connected.
SQL> exec dbms_ddl.alter_compile('TRIGGER','MWH','CDH_AFT_UPD_ROW');
begin dbms_ddl.alter_compile('TRIGGER','MWH','CDH_AFT_UPD_ROW'); end;

*
ERROR at line 1:
ORA-2: Unable to compile TRIGGER "MWH"."CDH_AFT_UPD_ROW", insufficient
privileges or does not exist
ORA-06512: at "SYS.DBMS_DDL", line 47
ORA-06512: at line 1


SQL> connect sys/pass
Connected.
SQL> grant create any procedure to MWH;

Grant succeeded.

SQL> connect mwh/pass
Connected.
SQL> exec dbms_ddl.alter_compile('TRIGGER','MWH','CDH_AFT_UPD_ROW');
begin dbms_ddl.alter_compile('TRIGGER','MWH','CDH_AFT_UPD_ROW'); end;

*
ERROR at line 1:
ORA-2: Unable to compile TRIGGER "MWH"."CDH_AFT_UPD_ROW", insufficient
privileges or does not exist
ORA-06512: at "SYS.DBMS_DDL", line 47
ORA-06512: at line 1
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Charlie Mengler
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from 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: Application Context

2001-03-01 Thread Scott . Shafer


Use:  http://osi.oracle.com/~tkyte and click on the link for the article.

> -Original Message-
> From: Dennis Taylor [SMTP:[EMAIL PROTECTED]]
> Sent: Thursday, March 01, 2001 10:56 AM
> To:   Multiple recipients of list ORACLE-L
> Subject:  Re: Application Context
> 
> At 07:31 AM 3/1/01 -0800, you wrote:
> >Check this document:
> >http://osi.oracle.com/~tkyte/article2/index.htm
> 
> page cannot be found.
> 
> 
> Dennis Taylor
> 
> let not the sands of time get in your lunch.
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Dennis Taylor
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from 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.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from 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: ora 27146 error ?

2001-03-01 Thread Trassens, Christian


Is the error on Solaris that appears on 8.x releases when there is a lack of
semaphores. Therefore, increase the number of them in /etc/system.

Regards.

> -Mensaje original-
> De:   Leslie Lu [SMTP:[EMAIL PROTECTED]]
> Enviado el:   jueves 1 de marzo de 2001 19:07
> Para: Multiple recipients of list ORACLE-L
> Asunto:   ora 27146 error ?
> 
> Hi all,
> 
> When I try to startup an instance, I got this:
> ORA-27146: post/wait initialization failed
> 
> And this is what the document suggests:
> 27146, , "post/wait initialization failed"
> // *Cause:  OS system call failed
> // *Action: check errno and contact Oracle Support
> 
> Anybody has any solution?  Thank you.
> 
> 
> Leslie
> 
> __
> Do You Yahoo!?
> Get email at your own domain with Yahoo! Mail. 
> http://personal.mail.yahoo.com/
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Leslie Lu
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from 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.com
-- 
Author: Trassens, Christian
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from 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: Application Context

2001-03-01 Thread Chaim . Katz

Its http://osi.oracle.com/~tkyte/article2/index.html

(note the trailing l)

Dennis Taylor <[EMAIL PROTECTED]> on 03/01/2001 11:55:40 AM

Please respond to [EMAIL PROTECTED]

To:   Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:(bcc: Chaim Katz/Completions/Bombardier)

At 07:31 AM 3/1/01 -0800, you wrote:
>Check this document:
>http://osi.oracle.com/~tkyte/article2/index.htm

page cannot be found.

Dennis Taylor

let not the sands of time get in your lunch.

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Dennis Taylor
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from 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.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from 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: ora 27146 error ?

2001-03-01 Thread Shaw, Glen


Also, if you can't reboot the server and need to get the database up
quickly, reduce the processes parameter in the init.ora file to a minimal
level (i.e. 20) until you can reboot the server.

Glen

-Original Message-
Sent: Thursday, March 01, 2001 1:51 PM
To: Multiple recipients of list ORACLE-L


Is the error on Solaris that appears on 8.x releases when there is a lack of
semaphores. Therefore, increase the number of them in /etc/system.

Regards.

> -Mensaje original-
> De:   Leslie Lu [SMTP:[EMAIL PROTECTED]]
> Enviado el:   jueves 1 de marzo de 2001 19:07
> Para: Multiple recipients of list ORACLE-L
> Asunto:   ora 27146 error ?
> 
> Hi all,
> 
> When I try to startup an instance, I got this:
> ORA-27146: post/wait initialization failed
> 
> And this is what the document suggests:
> 27146, , "post/wait initialization failed"
> // *Cause:  OS system call failed
> // *Action: check errno and contact Oracle Support
> 
> Anybody has any solution?  Thank you.
> 
> 
> Leslie
> 
> __
> Do You Yahoo!?
> Get email at your own domain with Yahoo! Mail. 
> http://personal.mail.yahoo.com/
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Leslie Lu
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from 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.com
-- 
Author: Trassens, Christian
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from 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.com
-- 
Author: Shaw, Glen
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from 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: DBWR slaves in NT???

2001-03-01 Thread Jesse, Rich


Actually, that message is invalid for Oracle8 DBs.  From what I can gather,
the DB_FILES init.ora parameter only
potentially affected DBWR performance in Oracle7.  In Oracle8, it ain't
true.

Remember, the DBWRs write dirty buffers (data in memory that has been
modified from it's counterpart in a datafile) from the buffer cache (memory)
to the datafiles (disk).  In O7, the DBWR I/O clump size, or how many dirty
blocks could be written at once (also sometimes referred to as the DBWR's
"internal write batch size"), was calculated as:

DB_FILE_SIMULTANEOUS_WRITES*DB_FILES/2.

In O8, the DBWR I/O clump size is static, and is different from platform to
platform.  Thus, for Oracle8, the advise to change DB_FILES is bogus.

HTH!

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

Disclaimer:  After taking the Oracle8 Perf Tuning class, I think I know more
than I do.  Don't blame me for your (in)actions based on my opinion!

-Original Message-
Sent: Thursday, March 01, 2001 12:27
To: Multiple recipients of list ORACLE-L


not a dbwriter problem. 
on a "single-disk wonder", your best 
bet is to DUMP all indexes on loadable 
tables, then load your data, then rebuild 
the indexes. 
of course, that might take just as long. 
any possiblity of getting more disk? 
like, several? a raid controller? 
mit gluck! 



-Original Message- 
Sent: Thursday, March 01, 2001 11:26 AM 
To: Multiple recipients of list ORACLE-L 


Hi Friends 
I have toad tool for my NT database 
DBWR Average Scan Depth 1024  **Number of DB_Files too high?? 
I got doubt due to from v$waitstat I got data block waits some time 8000 and

some times higher number. How can I increase the DBWR slaves on NT?? 
although I set in development box, How can I see as background process 
really working for me?? 
I have my datafile and indexes same on E disk drive, My hit ratios are okay,

My import is killing me. 
Any help appreciated. 
Thanks 
Raghu. 
_ 
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com 
-- 
Author: Raghu Kota 
  INET: [EMAIL PROTECTED] 
Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051 
San Diego, California-- Public Internet access / Mailing Lists 
 
To REMOVE yourself from 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 has been scanned for viruses with Trend Micro's Interscan VirusWall.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jesse, Rich
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from 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: ora 27146 error ?

2001-03-01 Thread Rocky Welch


Hi Leslie,
I just ran into this about a month ago. I bet you're on Unix. The
/etc/system settings are too low. It's the same situation as when you get
a semephore no space left on device error. Raise them and reboot the
machine then yu should be ok. (The values you use will depend on machine
memory, etc.)

HTH,

-Rocky

--- Leslie Lu <[EMAIL PROTECTED]> wrote:
> Hi all,
> 
> When I try to startup an instance, I got this:
> ORA-27146: post/wait initialization failed
> 
> And this is what the document suggests:
> 27146, , "post/wait initialization failed"
> // *Cause:  OS system call failed
> // *Action: check errno and contact Oracle Support
> 
> Anybody has any solution?  Thank you.
> 
> 
> Leslie
> 
> __
> Do You Yahoo!?
> Get email at your own domain with Yahoo! Mail. 
> http://personal.mail.yahoo.com/
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Leslie Lu
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from 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).


=
Rocky Welch
Senior Consultant - Internet Services Group
Arthur Andersen

__
Do You Yahoo!?
Get email at your own domain with Yahoo! Mail. 
http://personal.mail.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rocky Welch
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from 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: RE: eek!

2001-03-01 Thread Kimberly Smith


Actually we had our HP cluster crash today as well.  First
one side went.  Got that all back up and then the other side
went.  Since I am in Gresham, OR we are blaming it on the earthquake.
Couldn't find a reason not to.  So far management seems to
be buying it.

-Original Message-
Sent: Thursday, March 01, 2001 9:46 AM
To: Multiple recipients of list ORACLE-L


Hummm!!  Must be a week for disasters.  We've had a multi DB development box
crashing for the first 3 days of this week.  Right now the HP rep is in
there
with his head inside the chassis & parts all over the place outside!!  Sure
that
earthquake was in the NorthWest?  Looks like splattered quite a bit over
here
too!!  Thank God tomorrow's Friday! :-)

Dick Goulet

Reply Separator
Author: "Mark Leith" <[EMAIL PROTECTED]>
Date:   3/1/2001 7:45 AM

As a part of my daily calls yesterday - imagine my shock when I phoned for a
regular contact of mine - to find that he was IN the train crash!!! He came
out OK though according to the receptionist, although he did lose his mobile
phone :( I just feel for the families of the ones that didn't make it.

I'm also about 25 miles away from a case of Foot & Mouth!

Sean, you can see the bad moon rising? I got a full one looming over head:)

-Original Message-
Carmichael
Sent: Thursday, March 01, 2001 02:22
To: Multiple recipients of list ORACLE-L


Sean,

I read about that crash this morning -- horrifying!  And they are saying
there is something like $1 billion worth of damage from the quake. My
friends in Gresham (Oregon) felt it as well.

You going to become a vegetarian based on the animal diseases raging over
there?

Dennis -- you okay? Family/home okay? Databases?

Rachel

>From: "O'Neill, Sean" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: RE: eek!
>Date: Thu, 01 Mar 2001 01:50:19 -0800
>
>Dennis,
>
>So how are things post earth quake?.  Did you need to invoke any of your DR
>Plan?.  If so, sharing your experience on this would be useful after the
>dust settles =:-0
>
>It's a hell of a wake up call to remind one why DR plans are important.
>
>The earthquake made news here in Ireland along with the impending foot &
>mouth disease crisis and even mentioned ahead of bad rail crash in England
>across the Irish sea where lives were lost.
>
>"I see the bad moon a risin'.  I see trouble on the way."
>
>Sean :)
>
>Rookie Data Base Administrator
>[0%] OCP Oracle8i DBA
>[0%] OCP Oracle9i DBA
>
>Organon (Ireland) Ltd.
>http://www.organon.ie
>E-mail: [EMAIL PROTECTED]   [subscribed: Digest Mode]
>
>Visit: http://groups.yahoo.com/group/Oracle-OCP-DBA
>
>"They tell me nothing, but expect me to know everything!"
>
>
>--
>
>  From: Dennis Taylor <[EMAIL PROTECTED]>
>  Date: Wed, 28 Feb 2001 11:20:18 -0800
>  Subject: eek!
>
>We just had an earthquake. I'm fairly freeked.
>
>How's everyone's disaster recover strategy? I'll think I'll be reviewing
>ours today.
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: O'Neill, Sean
>   INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>San Diego, California-- Public Internet access / Mailing Lists
>
>To REMOVE yourself from 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).

_
Get your FREE download of MSN Explorer at http://explorer.msn.com

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Rachel Carmichael
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from 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.com
-- 
Author: Mark Leith
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in

RE: OAS and iAS file size comparisons

2001-03-01 Thread Yexley Robert D SSgt AFIT/SCA


Another thing to keep in mind with 9iAS (in relation to its size) is it's
caching capabilities.  How do you think it keeps all that information
cached??  Replication.  9iAS also comes with and installs the Oracle
database engine in addition to everything else.  When you select certain
options for caching, it automatically performs data replication from the
database server for you.  That's probably a huge part of the size of 9iAS in
and of itself.

-::YEX::-
<)))><

-Original Message-
Sent: Thursday, 01 March, 2001 13:01 PM
To: Multiple recipients of list ORACLE-L


Everything but the kitchen sink..  9iAS includes Apache, Forms Server,
Reports Server, Portal, DB Cache, Discoverer Server, Queue Manager, Wireless
if you want it, and possibly others I've left out.  Consider yourself lucky
if you only had 2 CDs, we (Solaris) had 3.

Linda
(installed but not working)

-Original Message-
Sent: Thursday, March 01, 2001 8:32 AM
To: Multiple recipients of list ORACLE-L


OAS 4.0.8.2 for NT was 121M in size, zipped.

iAS for NT is two CDs in size, 569,609K + 403,131K.

What did they put in this new version that is so HUGE?

Unbelievable.

How big will Oracle 9i be, I wonder.

Patrice Boivin
Systems Analyst (Oracle Certified DBA)

Systems Admin & Operations | Admin. et Exploit. des systèmes
Technology Services| Services technologiques
Informatics Branch | Direction de l'informatique 
Maritimes Region, DFO  | Région des Maritimes, MPO

E-Mail: [EMAIL PROTECTED]  

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Boivin, Patrice J
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from 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.com
-- 
Author: Seley, Linda
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from 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.com
--
Author: Yexley Robert D SSgt AFIT/SCA
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from 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: DBWR slaves in NT???


If I am completely off the wall here just slap me around a little bit.  But
couldn't you play with the init parameteres DBWR_IO_SLAVES or
DB_WRITER_PROCESSES to help improve write performance?  I mean, I agree with
Ross, there is only one disk, but maybe it could help a little to help
simulate asynchronous I/O?
Kev
Just thinkin out loud again!

-Original Message-
Sent: Thursday, March 01, 2001 2:31 PM
To: Multiple recipients of list ORACLE-L


Actually, that message is invalid for Oracle8 DBs.  From what I can gather,
the DB_FILES init.ora parameter only
potentially affected DBWR performance in Oracle7.  In Oracle8, it ain't
true.

Remember, the DBWRs write dirty buffers (data in memory that has been
modified from it's counterpart in a datafile) from the buffer cache (memory)
to the datafiles (disk).  In O7, the DBWR I/O clump size, or how many dirty
blocks could be written at once (also sometimes referred to as the DBWR's
"internal write batch size"), was calculated as:

DB_FILE_SIMULTANEOUS_WRITES*DB_FILES/2.

In O8, the DBWR I/O clump size is static, and is different from platform to
platform.  Thus, for Oracle8, the advise to change DB_FILES is bogus.

HTH!

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

Disclaimer:  After taking the Oracle8 Perf Tuning class, I think I know more
than I do.  Don't blame me for your (in)actions based on my opinion!

-Original Message-
Sent: Thursday, March 01, 2001 12:27
To: Multiple recipients of list ORACLE-L


not a dbwriter problem.
on a "single-disk wonder", your best
bet is to DUMP all indexes on loadable
tables, then load your data, then rebuild
the indexes.
of course, that might take just as long.
any possiblity of getting more disk?
like, several? a raid controller?
mit gluck!



-Original Message-
Sent: Thursday, March 01, 2001 11:26 AM
To: Multiple recipients of list ORACLE-L


Hi Friends
I have toad tool for my NT database
DBWR Average Scan Depth 1024  **Number of DB_Files too high??
I got doubt due to from v$waitstat I got data block waits some time 8000 and

some times higher number. How can I increase the DBWR slaves on NT??
although I set in development box, How can I see as background process
really working for me??
I have my datafile and indexes same on E disk drive, My hit ratios are okay,

My import is killing me.
Any help appreciated.
Thanks
Raghu.
_
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Raghu Kota
  INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from 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 has been scanned for viruses with Trend Micro's Interscan
VirusWall.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jesse, Rich
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from 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.com
-- 
Author: Kevin Kostyszyn
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from 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: Help - Tuning SQL - ISSUE CLOSED

2001-03-01 Thread Armstead, Michael A


Thanks for the help guys.

Michael Armstead
Database Administrator, OCP-Certified
Corporate & Finance Information Systems
Glaxo SmithKline


> -Original Message-
> From: Armstead, Michael A [SMTP:[EMAIL PROTECTED]]
> Sent: Wednesday, February 28, 2001 2:51 PM
> To:   Multiple recipients of list ORACLE-L
> Subject:  Help - Tuning SQL
> 
> I've got some simple questions on tuning SQL. Please reply with
> references,
> I'm not looking for guesses.
> 
> * If you have a SELECT statement with a WHERE clause and 2 AND
> clauses, which one is processed first, the WHERE clause, the first AND
> clause, or the second AND clause?
> * Is there any performance loss in using "<>" over "!="?
> 
> Michael Armstead  
> Database Administrator, OCP-Certified
> Corporate & Finance Information Systems
> Glaxo SmithKline
> 
> 
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Armstead, Michael A
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from 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.com
-- 
Author: Armstead, Michael A
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from 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: reset control, redo, logs etc


He didn't try to restore from the backup, he just backed up the database
when it was open. unless I misunderstood everything.

Very possible,
Ruth
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, March 01, 2001 2:16 PM


> I would think that it is definately in a strange state.  I know that if
you
> did this with NT, meaning the database was running and you copied the
files
> to another location.  I am pretty sure you wouldn't be able to get it to
> run, I am not even sure that it would copy all of the files.
> Kev
>
> -Original Message-
> Gramolini
> Sent: Thursday, March 01, 2001 1:01 PM
> To: Multiple recipients of list ORACLE-L
>
>
> The best thing you can do is shut the database down.  Do a cold back and
> through the other one away.  Just because you did a backup doesn't mean
that
> you database is in a strange state.  Just start over.
>
>
> Just my $0.02,
> Ruth
>
> - Original Message -
> To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> Sent: Thursday, March 01, 2001 11:45 AM
>
>
> > If my database was not shutdown before a cold
> > backup was made, how do I bring it back up
> > skipping (or resetting) ctl, headers etc.
> > Is this possible?
> >
> > TIA
> > joe
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Leyden, Joseph
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> > San Diego, California-- Public Internet access / Mailing Lists
> > 
> > To REMOVE yourself from 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.com
> --
> Author: Ruth Gramolini
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from 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.com
> --
> Author: Kevin Kostyszyn
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from 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.com
-- 
Author: Ruth Gramolini
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from 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: BFILE vs. BLOB

2001-03-01 Thread Don Jerman




Last time I danced with this topic (8.1.5), BFILE required the file to
exist somewhere accessable to the data server (like on a mounted file system)
that you create an alias for with CREATE DIRECTORY.  But the data
server could not create or write the file.  So you have to let the
application write to a directory mounted by your Oracle server, without
overwriting any old BFILE data and without deleting any files that are
still referenced by the database.  Sounded complicated to me.
If you must modify the data BFILEs are out, unless you let the app do
it, and then you might as well just store the file names.  Sounds
good for static content that must be streamed back with the query, though.
Of course, 8.1.7 may have fixed this...
"Koivu, Lisa" wrote:
 
Good morning all,
I have to start storing binary files
in our database somehow.  I'm reading up on BFILES and BLOBs.
Seems like one of the differences is
that BLOBs are manipulated within the database, and BFILEs are not. 
Can anyone comment on how fast (or not fast) the DBMS_LOB. routines are
when operating in fairly large BLOBs?  I'm leaning toward BFILEs to
avoid having the database do anything other than just keep a pointer to
the file and keep the transaction length as short as possible.  FWIW,
I'll only need to accept a file and store it, and return it back to the
app when requested.
Another question:  Anyone using
temporary BLOBs (8i)?
Any comments, gotchas, boogie men are
appreciated.
Thanks
Lisa Rutland Koivu
Oracle Database Administrator
Qode.com
4850 North State Road 7
Suite G104
Fort Lauderdale, FL  33319
V: 954.484.3191, x174
F: 954.484.2933
C: 954.658.5849
http://www.qode.com
"The information
contained herein does not express the opinion or position of Qode.com and
cannot be attributed to or made binding upon Qode.com."




begin:vcard 
n:Jerman;Don
tel;work:919.508.1886
x-mozilla-html:TRUE
org:Database Management Service,Information Technology
version:2.1
email;internet:[EMAIL PROTECTED]
title:Database Administrator
adr;quoted-printable:;;Database Management Service,Information Technology=0D=0A104 Fayetteville Street Mall;Raleigh;NC;27699-1521;USA
x-mozilla-cpt:;-9536
fn:Don Jerman
end:vcard

RE: * Oracle DBAs Needed in the Virginia Beach VA Area..

2001-03-01 Thread Anne Yu


It works.   Thank you very very much.

-Original Message-
Sent: Thursday, March 01, 2001 11:06 AM
To: Multiple recipients of list ORACLE-L


Issue Upgrade Catalog command in your recovery catalog database.

-Original Message-
Sent: Thursday, March 01, 2001 7:07 AM
To: Multiple recipients of list ORACLE-L


Hi List Friends, 

I have server A: Solaris 5.8, RDBMS 8.1.7.0.0 and server B: Solaris 5.8 &
the RDBMS was upgraded from 8.0.5 to 8.1.7. 

RDBMS 8.1.7 is my recovery manager target database and the other is my
catalog database. 
When I try to register this 8.1.7 target database to this upgraded 8.1.7
catalog database,  I am getting:


RMAN> connect target sys/password@target_db 
RMAN> connected to target database: CATALOG
RMAN> connected to recovery catalog database
RMAN-06186: PL/SQL package SYS.DBMS_RCVMAN version 08.00.05 in TARGET
database i 
s too old 
RMAN-00571: === 
RMAN-00569: === ERROR MESSAGE STACK FOLLOWS === 
RMAN-00571: === 
RMAN-0058: error encountered while parsing input commands
RMAN-01006: error signalled during parse
 

What can I do to correct this problem, IF ANY? 


many thanks,


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Anne Yu
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from 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.com
-- 
Author: Janardhana Babu
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from 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.com
-- 
Author: Anne Yu
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from 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).

Newbie question on Packages

2001-03-01 Thread Rakesh Dinger


Hi, I a newbie in Oracle and am trying to create a package body in PL/SQL, so please 
bear with me.

The statements are:
SQL> create or replace package body RA_GET_TX_INFO_
  2  as
  3  begin
  4  select SID from V$SESSION;
  5  end RA_GET_TX_INFO_;
 /
Warning: Package Body created with compilation errors.
SQL> show errors package body RA_GET_TX_INFO_;
Errors for PACKAGE BODY RA_GET_TX_INFO_:
 
LINE/COL ERROR
 -
3/10 PL/SQL: SQL Statement ignored
3/26 PLS-00201: identifier 'SYS.V_$SESSION' must be declared


How can I select from V_$SESSION inside the body? The user account has dba role 
granted and I can select from V_$SESSION from a normal PL/SQL session.

Any help greatly appreciated.

Thanks
Rakesh
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rakesh Dinger
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from 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: reset control, redo, logs etc