YES, minus SYS, SYSTEM, OUTLN, etc...
Dick Goulet
Reply Separator
Author: O'Neill; Sean [EMAIL PROTECTED]
Date: 10/21/2002 4:58 AM
Not a particularily technical query but a rather practical one. With a
named user licence is one user taken per each
Hi
I have data guard setup.When I run
select file#,status,enabled,checkpoint_change#,checkpoint_time,name from
v$datafile
on primary site its looks ok.But on standby site some of datafiles are
showing status RECOVER.
Log shipping and dataguard log is showing ok.Nothing on alert log either of
Bob - I don't feel Oracle makes it easy. They keep changing
the location and format. On Metalink, have you clicked on the
tab on the left side labeled Certify Availability? Once
you are in that section, there are tabs at the top for
Product Availability and Desupport Notices. I don't
I sure have! :(
Dick Goulet
Reply Separator
Author: DENNIS WILLIAMS [EMAIL PROTECTED]
Date: 10/21/2002 10:48 AM
I have heard rumors that Oracle has tried out this interpretation on some
clients. I have also heard some people were a bit outraged.
Yes, I do. This ploy worked on some of the large corporations in the U.S.
And I happen to know this worked on at least one large financial
institution.
RWB
DENNIS WILLIAMS [EMAIL PROTECTED]@fatcity.com on 10/21/2002
01:48:54 PM
Please respond to [EMAIL PROTECTED]
Sent by: [EMAIL
I am here... where is there?
Regards,
Pat.
--
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 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting
Previous mail, sent by me, was a mistake...
Should have replied to someone else...
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, October 21, 2002 18:38
I haven't recieved anything from this list since friday evening. I know
there
I have heard rumors that Oracle has tried out this interpretation on some
clients. I have also heard some people were a bit outraged. Have you known
anyone that paid up based on this interpretation?
Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Pa napisi adresu ondfa na koju da posaljem!
:)
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, October 21, 2002 18:38
I haven't recieved anything from this list since friday evening. I know
there usually isn't as much traffic on the
Not exactly.
Someone else has already pointed out that registry entries can
be created to gracefully shutdown the database: Doc ID 136214.1
If these are not setup properly, then stopping the services without
first shutting down the database is actually harsher than a shutdown
abort.
This is
MetaLink document 40689.1 contains a very nice
description of delayed block cleanout, and walks
the reader through an example.
Jared
Deshpande, Kirti [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
10/19/2002 08:18 AM
Please respond to ORACLE-L
To: Multiple recipients of list
Hi
We have 9iAS Rel.1 running 40-bit and 128-bit encryption. We
are migrating to Release2 and I am wondering if it will still
allow 40-bit. The security guide says:
Clients can only connect with one of the specified protocols:
SSLv3 - SSL version 3.0
or
All - SSL version 3.0 and any other
Some may not be all there :-)
Go Giants!
-Original Message-
Sent: Monday, October 21, 2002 11:03 AM
To: Multiple recipients of list ORACLE-L
We're still here.
-Original Message-
Sent: Monday, October 21, 2002 11:38 AM
To: Multiple recipients of list ORACLE-L
I haven't
List,
In the 4th Qtr 2002 Select Journal magazine there is an interesting
article by
Robert G.Freeman of this list.
Congratulations on being published again and helping the DBA's of the
world increase their knowledge.
The article talks about 9i external tables and it also creates a few
If the database is 8i+, you can try 'EXECUTE IMMEDIATE' command. Does make
life somewhat simpler.
Regards,
Charu
-Original Message-
Ling Catherine (CSC)
Sent: Thursday, October 17, 2002 3:25 PM
To: Multiple recipients of list ORACLE-L
Hi,
I've found the answer.
DECLARE
countval
Title: RE: 9i external tables question
I implemented this a couple of months ago. One part of db is we send out a 'heartbeat' to our external customers. To see when the 'heartbeat' goes out, I made available the external log file as a table and wrote code that measures the time between to
We're still here.
-Original Message-
Sent: Monday, October 21, 2002 11:38 AM
To: Multiple recipients of list ORACLE-L
I haven't recieved anything from this list since friday evening. I know
there usually isn't as much traffic on the weekend, but there is some. And
there has been
James and list:
You can backup the database without stopping the services. Just shut it
down. If you are going to attempt a restore and blow away the control
files, etc., then
by all means stop the services first. The services would need the control
files to be present if it is to be restarted
I haven't recieved anything from this list since friday evening. I know
there usually isn't as much traffic on the weekend, but there is some. And
there has been nothing at all this morning either.
Terry Ball, DBA
Birch Telecom
Work: 816-300-1335
FAX: 816-300-1800
--
Please see the official
No,
Even under Oracle8 it's enough to shutdown the database to do cold backup.
Services themselves, when the database is shutdown, do not hold on to the
database files.
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL
Not necessarily, shutdown mode (when you stop
services)depends on registry setting:
ORA_SID_SHUTDOWNTYPE
I - for immediate
a - for abort
Igor Neyman, OCP DBA[EMAIL PROTECTED]
- Original Message -
From:
Yechiel
Adar
To: Multiple recipients of list ORACLE-L
On Mon, Oct 21, 2002 at 02:38:22AM -0800, Santosh Varma wrote:
I am going to install a product in a client's place where oracle is
installed.
I am new to oracle. I wanted to know what all needs to be installed .. i
mean like tables,tablespace etc... Please give me a list of these and how
Not sure, but here we do net stop service_name_goes_here_without_brackets
and net start xxx.
Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)
Systems Admin Operations | Admin. et Exploit. des systèmes
Technology Services| Services technologiques
Informatics Branch
Santosh - Let me understand . . . Oracle is already installed and in
production at this site? Are you installing a commercial product? Then you
should probably follow the instructions that come with the product. If it is
a quality product with quality instructions, then tablespaces, etc. will be
Dear List,
I had a situation on a lone Windows/NT system a couple of years ago, where I
had installed 8i and was testing a number of facilities prior to going
online with an application. Since I wasn't familiar with NT, I played
around a bit, the final step of which was to test recovery with a
Seán,
I don't believe that is the situation. We have named users license
for the development server where there are 3 developers and 2 testers,
But the dba_users lists all 250 users that are on the production system.
Each user can have a different role or table access allowed and must be
tested
I use Oracle 7.3.4, 8.0.5 and 8.1.7 on windoze and none of them require that the
windoze service to be stopped. You can but it is not necessary.
Dave
-Original Message-
Sent: Monday, October 21, 2002 9:44 AM
To: Multiple recipients of list ORACLE-L
It seems I was completely wrong, is
It seems I was completely wrong, is it the same as for
Oracle 8 and 8i?
Last time I've worked with Windows it was on Oracle 8
and I thought that you had to stop the services
because Windows was not letting you copy the database
files.
--- Igor Neyman [EMAIL PROTECTED] a écrit :
Joe,
You can
Bob - I don't feel Oracle makes it easy. They keep changing the location and
format. On Metalink, have you clicked on the tab on the left side labeled
Certify Availability? Once you are in that section, there are tabs at
the top for Product Availability and Desupport Notices. I don't think
the
I got it!!! V$datafile and dba_extents will get what I need.
Rick_Cale@team
Sean - I think you are recalling the old Concurrent Users.
A named user is defined as follows:
Named User: is defined as an individual authorized by you to use the
programs which are installed on a single server or multiple servers,
regardless of whether the individual is actively using the
Hi,
I am not sure if it is a definitive list but on the left side of MetaLink
is a button Certify and Availability. It should provide you with all info
you need.
An recent oraperf report included the comment: Never split index
and data files to different sets of disks. It goes on to state that
striping is better. If the system in question does not have
raid support, wouldn't it be better to split the index and data across
spindles? That would make the
Rahul:
If you're working under Oracle 7.3 and
delayed_logging_block_cleanouts=TRUE (default), the block cleanouts will be
delayed until another transaction modifies the blocks (when the block is
required in current mode again). A simple select will not force the
cleanout.
If you set
When we compile this package body, we are getting the error - PLS -
00323. Please help.
Platform: Solaris 7. Oracle 8.1.6.
Package is getting created without any errors.
When we try to compile package body we are getting the error
3/12 PLS-00323: subprogram or cursor 'CHECK_OK' is
Within an update or load procedure, is there any way to return the
transaction count for the number
of rows affected? Kind of like the Feedback / NoFeedback option of
SQL*PLUS?
Thanks!
R. Smith
If you are not the intended recipient of this e-mail message, any use,
distribution or copying of the
I have an odd question about these on-line books. Can I
copy-and-paste the text?
Like many of you, I seem to end up with long commutes (why
are the best jobs never in your neighborhood?). I find
listening to books on CD to be a better use of time than
reading bumper stickers. Nobody
Hello,
We are on 8.1.7.4.0 (on Solaris), and are having a problem with a logoff
trigger and ORA-00164: autonomous transaction disallowed
within distributed transaction. The logoff trigger is defined as:
CREATE OR REPLACE TRIGGER get_logoff_stats_trg
BEFORE LOGOFF ON DATABASE
BEGIN
Easy one. The function declaration does not match between the spec and the body.
function check_OK (n1 in number)
function check_ok (nn in number)
Argument names must be the same.
Ron Thomas
Hypercom, Inc
[EMAIL PROTECTED]
Each new user of a new system uncovers a new class of bugs. --
Rao,
You've defined the package to use n1 as a parameter to CHECK_OK, but
nn in the body. Make them match and all should be well.
HTH! :)
Rich
Rich Jesse System/Database Administrator
[EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA
[EMAIL PROTECTED] wrote:
When we compile this package body, we are getting the error - PLS -
00323. Please help.
Platform: Solaris 7. Oracle 8.1.6.
Package is getting created without any errors.
When we try to compile package body we are getting the error
3/12 PLS-00323:
When detail_comments in the testable is inserted or updated too then I want it
to update the various_comments column which is in the same table (testtable).
What would be the most efficient way to write the trigger to do this?
CREATE OR REPLACE TRIGGER ADD_TO_TESTTABLE
AFTER INSERT OR UPDATE
Please read MetaLink document # 40689.1
Jared
dcutrone [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
10/21/2002 02:08 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:RE: is this block cleanout ?
Ray,
I don't know exactly what was intended with the
comment, but I agree with your interpretation.
---
As far as any other reasons for the
comment...
RANT
In terms ofmyths that have persisted with
Oracle over the years, the ideathat some performance benefitexists
from I/Oparallelism
Bob
Thanks for asking. No, most of the replies were along the lines that I'd
be less of a road hazard were I drunk with a cell phone in each ear.
But knowing someone else is interested is encouraging. Given the easy
access to broadband, maybe we could arrange some audio file swaps. Shouldn't
Ray,
In addition, there are apps that expect to find indexes and data in
separate locations. SAP is one of those.
Jared
Ray Stell [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
10/21/2002 01:43 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL
Dear list,
Though I won't be attending OOW, I will be in San Francisco during
those same dates ( 11/10 - 11/15), just a couple miles from the
Moscone Center where OOW is held.
Are there any plans yet among list members to get together one
evening? I think Monday is spoken for myself, but it
Jared, you're going to SF and not OOW?, what you there for(although i
wont be, i dont care for the large crowds at OOW).
joe
[EMAIL PROTECTED] wrote:
Dear list,
Though I won't be attending OOW, I will be in San Francisco during
those same dates ( 11/10 - 11/15), just a couple miles from the
No plans yet. I will probably not be attending OOW but would look forward
to getting together with list members also. Last time we met at Chevy's
(corner of Howard and 3rd Street). How about Tuesday Nov. 12th? I can make
a reservation for, say 15 people at 7pm. Sound good?
Gerardo
Jared,
Count me in as I live in San Jose, and will drop in on any agreed date.
Gerardo Molina (of SF, still on this list?) and self pulled together a group
of illustrious personalities that even included Steve Adams (and the Goddess
of course!)
It would be a pleasure to meet you after all these
Not this year... we have several highly visible apps going live
anywhere from 10/31 through 11/8 (well, they were all scheduled for
10/31, all the database group's work is done but the developers..) and
while I am not the production DBA (a refreshing change), I still don't
think be away the first
I will be in SFO for the OW.
Please let me know if we decide on the date and the place.
I would appreciate it if someone sent an e-mail to my hotmail address. I
will be out of the country till Nov 10th, but will be in SFO on Nov 11th.
Thanks.
- Kirti
-Original Message-
Sent: Monday,
it is a telecom product.
i am asking about any oracle specific installations..
like tables,indexes,tablespaces etc.
i hope i am clear
santosh
-Original Message-
WILLIAMS
Sent: Monday, October 21, 2002 8:49 PM
To: Multiple recipients of list ORACLE-L
Santosh - Let me understand . . .
Santosh,
Your problem is still not clear. Are you going to install the product which
will also install tables etc. in an oracle database? Or it is an independent
product and you just want to be sure that it can co-exist with oracle?
Regards
Naveen
--
Please see the official ORACLE-L FAQ:
Santosh,
I don't mean to be rude here, and there are lots of people, including
myself, who try to be helpful. But, it's simply not possible to give a
list of what all needs to be installed.
It's like showing up in a room full of construction workers and saying,
Hi, I'm about to start building my
ok.
i will make it clear.
i am going to install the product which will also install
tables/indexes/table space etc.
can i have some scripts to do it or should i manually create the tables one
by one ??
-Original Message-
Nahata
Sent: Tuesday, October 22, 2002 11:28 AM
To: Multiple
u r right Mark.
as regards version, i am using 8.1.5
I will come down to asking how to create the tablespace...
santosh
-Original Message-
Bobak
Sent: Tuesday, October 22, 2002 11:48 AM
To: Multiple recipients of list ORACLE-L
Santosh,
I don't mean to be rude here, and there are
57 matches
Mail list logo