RE: A RMAN question
Hi Dennis, Thanks for replying. I guess I have not been able to make my question clear. You see, I need to backup only the cloned database on server B and NOT the database on server A. My scenario is as follows : The main db on server A is a partitioned data warehouse system and we r planning to copy over the data files and the control files every night to the cloned db on server B. Thereafter, we will b taking a RMAN backup of the cloned db on server B only. As I said, RMAN writes the backup info on the target database's control files when it takes the backup. I also said that we plan to take a full backup on Sundays and incremental backup on the other days. My confusion was : Say, RMAN takes a backup of the database on the cloned db on server B on a Monday. On MOnday night as per procedure, the control files and the database files from the main db on server A are copied over to server B. On Tuesday, will RMAN b happy taking the incremental backup again of the cloned db on server B even though it finds that the control files r different than the ones it wrote the backup info to the previous day ?? Or will it get confused and prompt for a FULL backup ?? Any ideas from anybody would b appreciated a lot. Regards, Samir Samir Sarkar Oracle DBA SchlumbergerSema Email : [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : +44 (0) 115 - 957 6028 EPABX : +44 (0) 115 - 957 6418 Ext. 76028 Fax : +44 (0) 115 - 957 6018 -Original Message- Sent: 20 March 2002 19:16 To: Multiple recipients of list ORACLE-L Samir - We have found that each Oracle database has an internal ID. This ID doesn't change when you clone it as you describe. RMAN uses this ID, and will become confused if it sees two databases that are identical. One way around this is to run two RMAN catalogs. I have not considered it an advantage to use RMAN with the control file (non-catalog) option, so I haven't considered all the ramifications there. Have you looked at the RMAN DUPLICATE command to clone the database? Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, March 20, 2002 10:14 AM To: Multiple recipients of list ORACLE-L Hi All, Though I have been using RMAN for quite a while now, I would like to ask for a clarification here. We have a production database with partitioning options on server A. We copy over the files (including the control files) of the prod database each night to a server B. We will then be using RMAN to backup the database on server. We intend to take a Full backup on Sundays and Incrementals on all weekdays. I know that when we take a RMAN backup, it writes information about that task to the target database's control files which is precisely why we need not have a catalog database necessarily. My question is when RMAN takes a backup once, will it return an error when tries to take an incremental backup a second time since we have replaced the control files overnight ?? I mean, will RMAN be happy with taking an INCREMENTAL backup of the database even if it finds that the control files on which it had written the backup info the previous night have been replaced with a new set of control files ?? Will it prompt for a full backup ??? Any help will be greatly appreciated. Regards, Samir Samir Sarkar Oracle DBA SchlumbergerSema Email : [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : +44 (0) 115 - 957 6028 EPABX : +44 (0) 115 - 957 6418 Ext. 76028 Fax : +44 (0) 115 - 957 6018 ___ This email is confidential and intended solely for the use of the individual to whom it is addressed. Any views or opinions presented are solely those of the author and do not necessarily represent those of SchlumbergerSema. If you are not the intended recipient, be advised that you have received this email in error and that any use, dissemination, forwarding, printing, or copying of this email is strictly prohibited. If you have received this email in error please notify the SchlumbergerSema Helpdesk by telephone on +44 (0) 121 627 5600. ___ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: SARKAR, Samir 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:
RE: ways to speed up import
Bill, Paul Baumgartel (also on this list) wrote a good paper some time ago on this topic. You may find it a http://www.oriole.com in the 'Library' section. The paper was written a couple of years ago but most if not all of the advice is still perfectly valid. - Original Message - From: Magaliff, Bill [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wed, 20 Mar 2002 19:48:18 i'm getting larger and larger db dumps from clients that i need to import into local db's . . . dump appoaching 3Gb (only the one schem I need). Looking for ways to speed up import . . . tried playing with buffer size and commit=y, but not much luck. Also tried delaying index creation, which helps some . . . running 8.1.7.2 on solaris 8 - single cpu, depending on the box anywhere from 2 - 4 Gb RAM Thanks, all Bill Magaliff Framework, Inc. 914-631-2322 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Magaliff, Bill 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). --- - Stephane Faroult Oriole Corporation Performance Tools Free Scripts -- http://www.oriole.com, designed by Oracle DBAs for Oracle DBAs -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroul 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 TUNING
Why not post the query and the two plans ? Jonathan Lewis http://www.jlcomp.demon.co.uk Next Seminar - UK, April 3rd - 5th http://www.jlcomp.demon.co.uk/seminar.html Host to The Co-Operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html Author of: Practical Oracle 8i: Building Efficient Databases -Original Message- To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: 19 March 2002 19:33 |Hello: | |I have an identical query that has similar explain plan on both Prod and Dev |environment, only difference being that certain indexes are performing |unique scan on Prod and Range scan on Dev. |Can you cast some light on how this can be matched and under what conditions |this discrepancy might occur. | -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jonathan Lewis 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: is Oracle really planning to desupport RBO?
Is that the one that comes out the Thursday after Oracle 10i, or the Friday ? Jonathan Lewis http://www.jlcomp.demon.co.uk Next Seminar - UK, April 3rd - 5th http://www.jlcomp.demon.co.uk/seminar.html Host to The Co-Operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html Author of: Practical Oracle 8i: Building Efficient Databases -Original Message- To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: 19 March 2002 16:27 |Confidential sources have revealed me that Oracle will stop supporting RBO |as |of Oracle 18i. | -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jonathan Lewis 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: Another partitioning question
If your requirement is very strictly limited, so that
a) you want to have the flag column ('X') as the first
column of the partition
b) the flag is strictly a single character
c) you are using a character set where 'W' sorts immediately before
'X'
then the best you can do to meet the requirements
you describe has two partitions for the not-X values
and as many as you like for the X values using:
partition Pre_X values less than ('W',maxvalue),
partition PX_100 values less than ('X', 100),
partition PX_200 values less than ('X', 200),
...
partition PX_max values less than ('X', maxvalue),
partition post_X values less than (maxvalue, maxvalue)
There are several drawbacks to using this strategy
though, and I would start by questioning what you
hopes to achieve through partitioning and investigate
whether this notionally correct solution is going to
do what he hopes it would anyway.
Jonathan Lewis
http://www.jlcomp.demon.co.uk
Next Seminar - UK, April 3rd - 5th
http://www.jlcomp.demon.co.uk/seminar.html
Host to The Co-Operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html
Author of:
Practical Oracle 8i: Building Efficient Databases
-Original Message-
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Date: 15 March 2002 17:32
|I think what my boss is asking me to do is not possible, but since I
don't
|have much experience with partitioning I thought I'd ask here (I did
read
|some of manuals but didn't find an answer that suited my conditions).
My
|boss wants a table partitioned by 2 columns - seq_no and type. If the
type =
|'X' then it's just a range partition, but then he wants another
partition
|that contains all data that type!='X' but is inclusive of the entire
range.
|Is this possible?
|Something like (I know this syntax isn't correct )
|create table test_part(
|id number(11) unique,
|owner_id number(11) not null,
|type varchar2(30) not null,
|name varchar2(40))
|partition by range(owner_id,type)
|(partition p1 values less than (2000) and type ='X' tablespace
test,
|partition p2 values less than (5000) and owner_table ='X'
tablespace
|test,
|partition p3 values less than (1) and owner_table ='X'
tablespace
|test,
|partition p4 values less than (5) and owner_table ='X'
tablespace
|test,
|partition p5 values less than (10) and owner_table ='X'
tablespace
|test)
|partition p6 values less that (10) and owner_table !='X'
tablespace
|test;
|--
|Please see the official ORACLE-L FAQ: http://www.orafaq.com
|--
|Author: Shaw John-P55297
| 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: Jonathan Lewis
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: ways to speed up import
Something similar on my site (also getting out of date) hth connor --- Stephane Faroult [EMAIL PROTECTED] wrote: Bill, Paul Baumgartel (also on this list) wrote a good paper some time ago on this topic. You may find it a http://www.oriole.com in the 'Library' section. The paper was written a couple of years ago but most if not all of the advice is still perfectly valid. - Original Message - From: Magaliff, Bill [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wed, 20 Mar 2002 19:48:18 i'm getting larger and larger db dumps from clients that i need to import into local db's . . . dump appoaching 3Gb (only the one schem I need). Looking for ways to speed up import . . . tried playing with buffer size and commit=y, but not much luck. Also tried delaying index creation, which helps some . . . running 8.1.7.2 on solaris 8 - single cpu, depending on the box anywhere from 2 - 4 Gb RAM Thanks, all Bill Magaliff Framework, Inc. 914-631-2322 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Magaliff, Bill 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). --- - Stephane Faroult Oriole Corporation Performance Tools Free Scripts -- http://www.oriole.com, designed by Oracle DBAs for Oracle DBAs -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroul 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). = Connor McDonald http://www.oracledba.co.uk (mirrored at http://www.oradba.freeserve.co.uk) Some days you're the pigeon, some days you're the statue __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= 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).
Workaround for using NTILE function in Oracle8i
Hi Everyone,
I'm writing PL/SQL code which utilizes the NTILE function but have just
found out that due to a bug in Oracle8i the function
works from Sqlplus but not when called from PL/SQL.
I've run the following code in Oracle 8i and 9i and the results are given
below.
Unfortunately the database I need to run this on is Oracle 8i. Does anyone
know of
a workaround I could use to get this to work.
Cheers,
Kieran Murray
Database Administrator,
Norkom Technologies,
Dublin 2, Ireland
Tel:- +3531 2403221
declare
cursor cr_main is
select customer_id,
work_tn_extno,
ntile(4) over (order by work_tn_extno desc ) as quartile
from customer;
begin
for r1 in cr_main loop
dbms_output.put_line('customer_id = ' || r1.customer_id);
dbms_output.put_line('work_tn_extno = ' || r1.work_tn_extno);
dbms_output.put_line('quartile = ' || r1.quartile);
end loop;
exception
WHEN OTHERS THEN
dbms_output.put_line('SQLERRM = ' || SQLERRM);
END ;
/
Oracle8i
*
ERROR at line 6:
ORA-06550: line 6, column 53:
PLS-00103: Encountered the symbol ( when expecting one of the following:
, from into bulk
Oracle9i
customer_id = 1
work_tn_extno =
quartile = 1
PL/SQL procedure successfully completed.
The information contained in this e-mail transmission is confidential
and may be privileged. It is intended only for the addressee(s) stated
above. If you are not an addressee, any use, dissemination, distribution,
publication, or copying of the information contained in this e-mail is
strictly prohibited. If you have received this e-mail in error, please
immediately notify our IT Department by telephone at 353-1-6769333
or e-mail [EMAIL PROTECTED] and delete the e-mail from your
system.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Kieran Murray
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: Workaround for using NTILE function in Oracle8i
Look into native dynamic sql -
the standard trick with SQL that pl/sql cannot
handle is to do something like:
declare
cursor variable declaration
begin
open cursor_variable for
'your sql string as a text string'
;
loop
fetch cursor variable into local variables
exit when NOT FOUND
end loop;
close cursor variable
end;
Jonathan Lewis
http://www.jlcomp.demon.co.uk
Next Seminar - UK, April 3rd - 5th
http://www.jlcomp.demon.co.uk/seminar.html
Host to The Co-Operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html
Author of:
Practical Oracle 8i: Building Efficient Databases
-Original Message-
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Date: 21 March 2002 10:58
|Hi Everyone,
|I'm writing PL/SQL code which utilizes the NTILE function but have
just
|found out that due to a bug in Oracle8i the function
|works from Sqlplus but not when called from PL/SQL.
|I've run the following code in Oracle 8i and 9i and the results are
given
|below.
|Unfortunately the database I need to run this on is Oracle 8i. Does
anyone
|know of
|a workaround I could use to get this to work.
|
|Cheers,
|Kieran Murray
|Database Administrator,
|Norkom Technologies,
|Dublin 2, Ireland
|Tel:- +3531 2403221
|
|
| declare
| cursor cr_main is
| select customer_id,
|work_tn_extno,
|ntile(4) over (order by work_tn_extno desc ) as quartile
| from customer;
| begin
| for r1 in cr_main loop
| dbms_output.put_line('customer_id = ' || r1.customer_id);
| dbms_output.put_line('work_tn_extno = ' || r1.work_tn_extno);
| dbms_output.put_line('quartile = ' || r1.quartile);
| end loop;
| exception
| WHEN OTHERS THEN
| dbms_output.put_line('SQLERRM = ' || SQLERRM);
| END ;
| /
|
|Oracle8i
|*
|ERROR at line 6:
|ORA-06550: line 6, column 53:
|PLS-00103: Encountered the symbol ( when expecting one of the
following:
|, from into bulk
|
|
|Oracle9i
|
|customer_id = 1
|work_tn_extno =
|quartile = 1
|
|PL/SQL procedure successfully completed.
|
|
|The information contained in this e-mail transmission is confidential
|and may be privileged. It is intended only for the addressee(s)
stated
|above. If you are not an addressee, any use, dissemination,
distribution,
|publication, or copying of the information contained in this e-mail
is
|strictly prohibited. If you have received this e-mail in error,
please
|immediately notify our IT Department by telephone at 353-1-6769333
|or e-mail [EMAIL PROTECTED] and delete the e-mail from your
|system.
|
|--
|Please see the official ORACLE-L FAQ: http://www.orafaq.com
|--
|Author: Kieran Murray
| 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: Jonathan Lewis
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: Workaround for using NTILE function in Oracle8i
Just wrap it within 'execute immediate' and it will
run fine.
hth
connor
--- Kieran Murray [EMAIL PROTECTED] wrote:
Hi Everyone,
I'm writing PL/SQL code which utilizes the NTILE
function but have just
found out that due to a bug in Oracle8i the function
works from Sqlplus but not when called from PL/SQL.
I've run the following code in Oracle 8i and 9i and
the results are given
below.
Unfortunately the database I need to run this on is
Oracle 8i. Does anyone
know of
a workaround I could use to get this to work.
Cheers,
Kieran Murray
Database Administrator,
Norkom Technologies,
Dublin 2, Ireland
Tel:- +3531 2403221
declare
cursor cr_main is
select customer_id,
work_tn_extno,
ntile(4) over (order by work_tn_extno desc ) as
quartile
from customer;
begin
for r1 in cr_main loop
dbms_output.put_line('customer_id = ' ||
r1.customer_id);
dbms_output.put_line('work_tn_extno = ' ||
r1.work_tn_extno);
dbms_output.put_line('quartile = ' || r1.quartile);
end loop;
exception
WHEN OTHERS THEN
dbms_output.put_line('SQLERRM = ' || SQLERRM);
END ;
/
Oracle8i
*
ERROR at line 6:
ORA-06550: line 6, column 53:
PLS-00103: Encountered the symbol ( when expecting
one of the following:
, from into bulk
Oracle9i
customer_id = 1
work_tn_extno =
quartile = 1
PL/SQL procedure successfully completed.
The information contained in this e-mail
transmission is confidential
and may be privileged. It is intended only for the
addressee(s) stated
above. If you are not an addressee, any use,
dissemination, distribution,
publication, or copying of the information contained
in this e-mail is
strictly prohibited. If you have received this
e-mail in error, please
immediately notify our IT Department by telephone at
353-1-6769333
or e-mail [EMAIL PROTECTED] and delete the
e-mail from your
system.
--
Please see the official ORACLE-L FAQ:
http://www.orafaq.com
--
Author: Kieran Murray
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).
=
Connor McDonald
http://www.oracledba.co.uk (mirrored at
http://www.oradba.freeserve.co.uk)
Some days you're the pigeon, some days you're the statue
__
Do You Yahoo!?
Everything you'll ever need on one web page
from News and Sport to Email and Music Charts
http://uk.my.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: =?iso-8859-1?q?Connor=20McDonald?=
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).
Failed login attempts
Hi all, Which is the best way to keep audit of failed login attempts to the oracle server -without turning on full audit? Thanking you, --- +---+ C.S Waibale Simon MTN-Uganda, Cell: +256 77-212655,http://mtn.co.ug +---+ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Simon Waibale 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: Use of Orastaff
Go to this site to sign up for some enlightening discussions!! http://groups.yahoo.com/group/oracle-l-ot/ Dave -Original Message- Sent: Wednesday, March 20, 2002 3:01 PM To: Multiple recipients of list ORACLE-L Ruth, What is the procedure to subscribe to the OT list, please? TIA, Scott Lockhart -- 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: Farnsworth, Dave 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: A RMAN question
Hello Samir I do not work with RMAN but I THINK that you have a conceptual error in your logic. Since you do not have a catalog RMAN use the control files as catalog. When you want to restore RMAN will not find the data on the full backup in the control files. You will have only the data on the last incremental backup. How can you restore? Yechiel Adar, Mehish Computer Services [EMAIL PROTECTED] -Original Message- From: SARKAR, Samir [SMTP:[EMAIL PROTECTED]] Sent: Thu, March 21, 2002 10:38 AM To: Multiple recipients of list ORACLE-L Subject: RE: A RMAN question Hi Dennis, Thanks for replying. I guess I have not been able to make my question clear. You see, I need to backup only the cloned database on server B and NOT the database on server A. My scenario is as follows : The main db on server A is a partitioned data warehouse system and we r planning to copy over the data files and the control files every night to the cloned db on server B. Thereafter, we will b taking a RMAN backup of the cloned db on server B only. As I said, RMAN writes the backup info on the target database's control files when it takes the backup. I also said that we plan to take a full backup on Sundays and incremental backup on the other days. My confusion was : Say, RMAN takes a backup of the database on the cloned db on server B on a Monday. On MOnday night as per procedure, the control files and the database files from the main db on server A are copied over to server B. On Tuesday, will RMAN b happy taking the incremental backup again of the cloned db on server B even though it finds that the control files r different than the ones it wrote the backup info to the previous day ?? Or will it get confused and prompt for a FULL backup ?? Any ideas from anybody would b appreciated a lot. Regards, Samir Samir Sarkar Oracle DBA SchlumbergerSema Email : [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : +44 (0) 115 - 957 6028 EPABX : +44 (0) 115 - 957 6418 Ext. 76028 Fax : +44 (0) 115 - 957 6018 -Original Message- Sent: 20 March 2002 19:16 To: Multiple recipients of list ORACLE-L Samir - We have found that each Oracle database has an internal ID. This ID doesn't change when you clone it as you describe. RMAN uses this ID, and will become confused if it sees two databases that are identical. One way around this is to run two RMAN catalogs. I have not considered it an advantage to use RMAN with the control file (non-catalog) option, so I haven't considered all the ramifications there. Have you looked at the RMAN DUPLICATE command to clone the database? Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, March 20, 2002 10:14 AM To: Multiple recipients of list ORACLE-L Hi All, Though I have been using RMAN for quite a while now, I would like to ask for a clarification here. We have a production database with partitioning options on server A. We copy over the files (including the control files) of the prod database each night to a server B. We will then be using RMAN to backup the database on server. We intend to take a Full backup on Sundays and Incrementals on all weekdays. I know that when we take a RMAN backup, it writes information about that task to the target database's control files which is precisely why we need not have a catalog database necessarily. My question is when RMAN takes a backup once, will it return an error when tries to take an incremental backup a second time since we have replaced the control files overnight ?? I mean, will RMAN be happy with taking an INCREMENTAL backup of the database even if it finds that the control files on which it had written the backup info the previous night have been replaced with a new set of control files ?? Will it prompt for a full backup ??? Any help will be greatly appreciated. Regards, Samir Samir Sarkar Oracle DBA SchlumbergerSema Email : [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : +44 (0) 115 - 957 6028 EPABX : +44 (0) 115 - 957 6418 Ext. 76028 Fax : +44 (0) 115 - 957 6018 __ _ This email is confidential and intended solely for the use of the individual to whom it is addressed. Any views or opinions presented are solely those of the author and do not necessarily represent those of SchlumbergerSema. If you are not the intended recipient, be advised that you have received this email in error and that any use, dissemination, forwarding, printing, or copying of this email is strictly prohibited. If you have received this email in error please notify the SchlumbergerSema Helpdesk by telephone on +44 (0) 121 627 5600. __ _ --
RE: ORACLE TUNING
Thanks -Original Message- Sent: Wednesday, March 20, 2002 11:23 PM To: Multiple recipients of list ORACLE-L Are the sizes of the tables same on both development and production machines? In our case, we used histograms on indexed columns and that brought execution plans same on both the database. Look for analyze command syntax to build histograms. --- [EMAIL PROTECTED] wrote: Both have current statistics. Data distribution is smaller on DEV. Both are using CBO. -Original Message- Sent: Tuesday, March 19, 2002 4:53 PM To: Multiple recipients of list ORACLE-L What about current statistics on both DBs? Is the distribution of the data reasonably the same? Are they both using the same optimizer? I would state that obiviously something is different between the two instances; otherwise you'd get exactly the same results. [EMAIL PROTECTED] wrote: Hello: I have an identical query that has similar explain plan on both Prod and Dev environment, only difference being that certain indexes are performing unique scan on Prod and Range scan on Dev. Can you cast some light on how this can be matched and under what conditions this discrepancy might occur. Thank you, Srini -- 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). -- Charlie Mengler Maintenance Warehouse [EMAIL PROTECTED] 10641 Scripps Summit Ct. 858-831-2229 San Diego, CA 92131 Lead, follow, or at least have the courtesy to get out of my way! -- 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). -- 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). = Mohammed Shakir CompuSoft, Inc. 11 Heather Way East Brunswick, NJ 08816-2825 (732) 672-0464 (Cell) (732) 257-6001 (Home) __ Do You Yahoo!? Yahoo! Movies - coverage of the 74th Academy Awards(r) http://movies.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohammed Shakir 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
Re: Failed login attempts
1. change the initializaion parameter audit_trail to be: audit_trail=db shutdown and restart database 2. connect to the database as a user that has the privilege AUDIT SYSTEM and enter audit session whenever not successful at this point you can see these unsuccessful logins by monitoring the dba_audit_trail view. John [EMAIL PROTECTED] wrote: Hi all, Which is the best way to keep audit of failed login attempts to the oracle server -without turning on full audit? Thanking you, --- +---+ C.S Waibale Simon MTN-Uganda, Cell: +256 77-212655,http://mtn.co.ug +---+ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ora NT DBA 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: Use of Orastaff
I got an email from them asking to fill out a skills matrix. Never heard anything further. Koivu, Lisa lisa.koivu To: Multiple recipients of list ORACLE-L @efairfield.c[EMAIL PROTECTED] om cc: Sent by: rootSubject: RE: Use of Orastaff 03/20/2002 02:25 PM Please respond to ORACLE-L I got a response from them once, when I first moved down here. The market was frantic at that point and I had already accepted a position. I even spoke to Bill Law himself for a brief moment. I think what really got his attention was No relocation reimbursement required, we are moving to Florida Not my skills, whatever those are. I still don't know... Lisa Koivu Oracle Database Monkey Mama (Almost...) Fairfield Resorts, Inc. 954-935-4117 -Original Message- From: Joe Raube [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, March 20, 2002 1:21 PM To: Multiple recipients of list ORACLE-L Subject: Re: Use of Orastaff I have sent my resume to them, and called them on the phone - no one ever responded to me. -Joe --- bill thater [EMAIL PROTECTED] wrote: [EMAIL PROTECTED] wrote: I am assuming that since Orastaff continues to post positions on to this list that they are reputable. Is there anyone out there that is willing to share their experiences with this company. Did you get interviews? Did you obtain a position? etc i have sent my resume to them on a couple of occasions. i have not received any interviews from them. -- -- Bill Shrek Thater ORACLE DBA [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. Performance is easier to add than clarity. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: bill thater 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). __ Do You Yahoo!? Yahoo! Sports - live college hoops coverage http://sports.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Raube 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: Koivu, Lisa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To
RE: system packages status is invalid Oracle 8.1.7 on red hat 7.2
And you can't compile them? Lisa Koivu Oracle Database Administrator Fairfield Resorts, Inc. 954-935-4117 -Original Message- From: Praveen Sahni [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, March 20, 2002 5:33 PM To: Multiple recipients of list ORACLE-L Subject: system packages status is invalid Oracle 8.1.7 on red hat 7.2 Hi All, I have installed Oracle 8.1.7 on red hat linux 7.2. Every thing has gone fine. I even gone and installed the application on that. My problem is I saw now that there are some system packages listed below having status as 'INVALID'. Can anyone please let me know why and if we have any solution now. Is there any script I missed that's need to run and can I run it now after creating the application. Thanks in Advance Praveen PACKAGE DBMS_AQADM PACKAGE DBMS_AQADM_SYS PACKAGE DBMS_AQIN PACKAGE DBMS_AQIN PACKAGE DBMS_AQ_EXP_HISTORY_TABLES PACKAGE DBMS_AQ_EXP_INDEX_TABLES PACKAGE DBMS_AQ_EXP_QUEUES PACKAGE DBMS_AQ_EXP_QUEUE_TABLES PACKAGE DBMS_AQ_EXP_SUBSCRIBER_TABLES PACKAGE DBMS_AQ_EXP_TIMEMGR_TABLES PACKAGE DBMS_AQ_IMPORT_INTERNAL PACKAGE DBMS_AQ_IMP_INTERNAL PACKAGE DBMS_AQ_SYS_EXP_INTERNAL PACKAGE DBMS_AQ_SYS_IMP_INTERNAL PACKAGE DBMS_DDL PACKAGE DBMS_HS PACKAGE DBMS_HS_ALT PACKAGE DBMS_HS_UTL PACKAGE DBMS_IAS_CONFIGURE PACKAGE DBMS_IAS_QUERY PACKAGE DBMS_IAS_SESSION PACKAGE DBMS_IREFRESH PACKAGE DBMS_ISNAPSHOT PACKAGE DBMS_PRVTAQIM PACKAGE DBMS_PRVTAQIP PACKAGE DBMS_RULE_ADM PACKAGE DBMS_SNAPSHOT PACKAGE DBMS_SNAPSHOT_UTL PACKAGE DBMS_SNAP_REPAPI PACKAGE DBMS_SNAP_REPAPI PACKAGE DBMS_STATS PACKAGE DBMS_SUMADV PACKAGE DBMS_SUMMARY PACKAGE DBMS_SUMREF_CHILD PACKAGE DBMS_SUMREF_PARENT PACKAGE DBMS_UTILITY PACKAGE HTP PACKAGE OWA PACKAGE OWA_COOKIE PACKAGE OWA_CUSTOM PACKAGE OWA_TEXT PACKAGE OWA_UTIL PACKAGE PRVT_EGUTL PACKAGE PRVT_EPGC -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Praveen Sahni 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: Koivu, Lisa 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 Licensing Mess
Someone posted the original on this topic, which I sort of stayed away from, I too often on those types of topics put my foot into the mouth. Anyway, the following came across the wires this morning from Information Week. Some of you may be interested, me I'm off to do some more with PostGres MySql!! Dick Goulet -- ** Oracle's Pricing Dispute Oracle just can't get away from pricing controversies. The software vendor is reportedly seeking extra license fees from customers in a dispute over just what constitutes a user in a batched multiplex computing environment. The consulting firm Meta Group, saying it has received a flurry of calls (from) angry Oracle customers, is urging customers to refuse to pay the fees. Industry observers say Oracle is aggressively enforcing its software license contracts. I hear Oracle is being mean to its customers, Wells Fargo Securities analyst Rob Tholemeier said last week before Oracle reported its third-quarter results. They are reviewing database agreements, being very tough, and trying to get more dollars out of them. Oracle CFO Jeff Henley, when asked about the issue during a conference call with Wall Street analysts, said the company has an ongoing license-compliance program, but that there's no new enforcement initiative under way. Multiplexing involves a shared pool of connections to a back-end database that makes it difficult to determine the actual number of users accessing the database. Under such circumstances, companies generally purchase database licenses on a per-CPU model or pay for all users at the front of the system. But Oracle, according to Meta Group, is trying to expand the definition of multiplexing to include batch feeds from non-Oracle applications into Oracle databases, and that user licenses must be purchased for all users of those source systems. One Meta Group client was told that it would have to pay $2.2 million in additional license fees to remain in compliance. It appears pretty clear to us that they have redefined what multiplexing is to an absurd degree, says Meta Group analyst Charlie Garry. Oracle says this definition has always been its policy. But Meta Group questions Oracle's move on both legal and ethical grounds. - Rick Whiting More on Oracle Oracle 3Q Earnings Drop http://update.informationweek.com/cgi-bin4/flo?y=eGTT0BdFGA0V20BaCt0Ae -- 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: Re[2]: Fav. Urban Legend...Mem vs Disk
A most enjoyable book Venus on the Half Shell, written by Philip Jose Farmer under the pseudonym Kilgore Trout, who was a character in many novels - particularly Breakfast of Champions - by Kurt Vonnegut, who was a good friend of Mr. Farmer - also the author of the Riverworld trilogy (quadrilogy) and others. Oh, the connections! But the REAL purpose of this post (to keep it On Topic) is to report that my problem with excessive SNPx memory use turned out to be an artifact of upgrading from 8.1.6.0.0 - in which the interMedia Text indexing functions were handled by ExtProc - to 8.1.7.2.5 - in which the iM Text functions are incorporated into the RDBMS kernel. In 8.1.6 the 200MB used during index resyncs was released by ExtProc when the process finished. In 8.1.7 the SNP job runs the resync process and the 200MB used is not released. Periodically stopping and restarting the SNPx processes releases that memory and is an OK workaround. Jack Jack C. Applewhite Database Administrator/Developer OCP Oracle8 DBA iNetProfit, Inc. Austin, Texas www.iNetProfit.com [EMAIL PROTECTED] (512)327-9068 -Original Message- Eskridge Sent: Wednesday, March 20, 2002 9:33 PM To: Multiple recipients of list ORACLE-L ... Hmmph. More kowtowing to Douglas Adam's cheap rip off on Kilgore Trout's epic, Venus on the Half Shell. Check the name of the FTL drive in the latter and compare it to The Question. Curious though, how the answer is just one more than the maximum ITL slots with 2k blocks... (he says in a desperate attempt to get back on topic) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jack C. Applewhite 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 TUNING
Thanks, I'll post. -Original Message- Sent: Thursday, March 21, 2002 3:58 AM To: Multiple recipients of list ORACLE-L Why not post the query and the two plans ? Jonathan Lewis http://www.jlcomp.demon.co.uk Next Seminar - UK, April 3rd - 5th http://www.jlcomp.demon.co.uk/seminar.html Host to The Co-Operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html Author of: Practical Oracle 8i: Building Efficient Databases -Original Message- To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: 19 March 2002 19:33 |Hello: | |I have an identical query that has similar explain plan on both Prod and Dev |environment, only difference being that certain indexes are performing |unique scan on Prod and Range scan on Dev. |Can you cast some light on how this can be matched and under what conditions |this discrepancy might occur. | -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jonathan Lewis 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: Oracle CERT Advisory
Thanks Patrice for sharing this info. So much for Can't break it. Can't break in. Unbreakable marketing jingle. Lisa Koivu Oracle Database Something. Fairfield Resorts, Inc. 954-935-4117 -Original Message- From: Boivin, Patrice J [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, March 20, 2002 10:08 PM To: Multiple recipients of list ORACLE-L Subject: RE: Oracle CERT Advisory CERT is working on a how to fix your Oracle DB paper, you can ask for a copy at [EMAIL PROTECTED] Oracle security problems may be more prevalent than previously reported. Pete Finnegan, with the help of many of the other Oracle security gurus around the world, has completed a first draft of SANS new Oracle Security: Step-by-Step guide. We are distributing the list of Oracle security problems to be sure we have addressed all the known issues. We'll share the solutions sections with those people who provide substantive feedback on the problems. If you know a lot about Oracle security and *will* provide feedback, please email [EMAIL PROTECTED] with the subject Oracle security problems and we will email you a copy. Include your name, organization, city, state, and country. Alan Regards, 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- [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 20, 2002 9:43 PM To: Multiple recipients of list ORACLE-L Subject: RE: Oracle CERT Advisory Check http://otn.oracle.com/deploy/security/alerts.htm Hemant K Chitale Principal DBA Chartered Semiconductor Manufacturing Ltd [This e-mail is confidential and may also be privileged. If you are not the intended recipient, please delete it and notify us immediately; you should not copy or use it for any purpose, nor disclose its contents to any other person. Thank you.] -- 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: 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: Koivu, Lisa 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).
Direct Import of XML file
Title: Direct Import of XML file Hi list, Is there any tool in Oracle to import a xml-file direct to a database table? TIA Volker Schoen E-Mail: [EMAIL PROTECTED] http://www.inplan.de
RE: system packages status is invalid Oracle 8.1.7 on red hat 7.2
Run rdbms/admin/utlrp.sql or utlrep.sql. Then query again for invalid packages. If there are still many, then not enough room to hold them all in your shared pool. Packages are invalid when the db starts up, because no one has accessed them yet. Utlrp.sql forces Oracle to do the work up front. Regards, 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- Sent: Thursday, March 21, 2002 10:38 AM To: Multiple recipients of list ORACLE-L Subject:RE: system packages status is invalid Oracle 8.1.7 on red hat 7.2 And you can't compile them? Lisa Koivu Oracle Database Administrator Fairfield Resorts, Inc. 954-935-4117 -Original Message- From: Praveen Sahni [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, March 20, 2002 5:33 PM To: Multiple recipients of list ORACLE-L Subject: system packages status is invalid Oracle 8.1.7 on red hat 7.2 Hi All, I have installed Oracle 8.1.7 on red hat linux 7.2. Every thing has gone fine. I even gone and installed the application on that. My problem is I saw now that there are some system packages listed below having status as 'INVALID'. Can anyone please let me know why and if we have any solution now. Is there any script I missed that's need to run and can I run it now after creating the application. Thanks in Advance Praveen PACKAGE DBMS_AQADM PACKAGE DBMS_AQADM_SYS PACKAGE DBMS_AQIN PACKAGE DBMS_AQIN PACKAGE DBMS_AQ_EXP_HISTORY_TABLES PACKAGE DBMS_AQ_EXP_INDEX_TABLES PACKAGE DBMS_AQ_EXP_QUEUES PACKAGE DBMS_AQ_EXP_QUEUE_TABLES PACKAGE DBMS_AQ_EXP_SUBSCRIBER_TABLES PACKAGE DBMS_AQ_EXP_TIMEMGR_TABLES PACKAGE DBMS_AQ_IMPORT_INTERNAL PACKAGE DBMS_AQ_IMP_INTERNAL PACKAGE DBMS_AQ_SYS_EXP_INTERNAL PACKAGE DBMS_AQ_SYS_IMP_INTERNAL PACKAGE DBMS_DDL PACKAGE DBMS_HS PACKAGE DBMS_HS_ALT PACKAGE DBMS_HS_UTL PACKAGE DBMS_IAS_CONFIGURE PACKAGE DBMS_IAS_QUERY PACKAGE DBMS_IAS_SESSION PACKAGE DBMS_IREFRESH PACKAGE DBMS_ISNAPSHOT PACKAGE DBMS_PRVTAQIM PACKAGE DBMS_PRVTAQIP PACKAGE DBMS_RULE_ADM PACKAGE DBMS_SNAPSHOT PACKAGE DBMS_SNAPSHOT_UTL PACKAGE DBMS_SNAP_REPAPI PACKAGE DBMS_SNAP_REPAPI PACKAGE DBMS_STATS PACKAGE DBMS_SUMADV PACKAGE DBMS_SUMMARY PACKAGE DBMS_SUMREF_CHILD PACKAGE DBMS_SUMREF_PARENT PACKAGE DBMS_UTILITY PACKAGE HTP PACKAGE OWA PACKAGE OWA_COOKIE PACKAGE OWA_CUSTOM PACKAGE OWA_TEXT PACKAGE OWA_UTIL PACKAGE PRVT_EGUTL PACKAGE PRVT_EPGC -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Praveen Sahni 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: Koivu, Lisa 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).
Revoke alter password frm user
Title: Revoke alter password frm user Hi list, Is it possible to revoke a oracle user the right to alter his password? TIA Volker Schoen E-Mail: [EMAIL PROTECTED] http://www.inplan.de
Re: Oracle hangs...Oracle 8.1.7.3 and Solaris 2.7
I am sure that you don't have any invalid objects after the patch application. I had a lot of problem with that after a patch application two years ago. Sharon -- Xiaohong Yang (Sharon) certified Oracle DBA Center for Bioinfomatics, CB#7100 School of Medicine UNC-CH --- Grabowy, Chris [EMAIL PROTECTED] wrote: We have a particular database that hangs on a regular basis. Here are the stats and symptoms. Oracle stats -- 8.1.7.3 (highest patch level applied) Solaris 2.7 UTF8 character set Symptoms -- Random hanging. Hanging meaning SQL processing stops. New connections hang. No traces files. No messages in the alert log. Killing the Oracle processes is the only way to recover from the problem. This problem has been reported to Oracle Support, they are now escalating it up. I just wanted to PING the list to see if anyone else has encountered this. TIA!!! Chris -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Xiaohong Yang (Sharon) 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: system packages status is invalid Oracle 8.1.7 on red hat 7.2
You might want to run UTLRP.SQL on your database. Do this as SYS or INTERNAL. Also remember to do a SET ORACLE_SID=your_sid first. Dave -Original Message- Sent: Thursday, March 21, 2002 8:38 AM To: Multiple recipients of list ORACLE-L 7.2 And you can't compile them? Lisa Koivu Oracle Database Administrator Fairfield Resorts, Inc. 954-935-4117 -Original Message- From: Praveen Sahni [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, March 20, 2002 5:33 PM To: Multiple recipients of list ORACLE-L Subject: system packages status is invalid Oracle 8.1.7 on red hat 7.2 Hi All, I have installed Oracle 8.1.7 on red hat linux 7.2. Every thing has gone fine. I even gone and installed the application on that. My problem is I saw now that there are some system packages listed below having status as 'INVALID'. Can anyone please let me know why and if we have any solution now. Is there any script I missed that's need to run and can I run it now after creating the application. Thanks in Advance Praveen PACKAGE DBMS_AQADM PACKAGE DBMS_AQADM_SYS PACKAGE DBMS_AQIN PACKAGE DBMS_AQIN PACKAGE DBMS_AQ_EXP_HISTORY_TABLES PACKAGE DBMS_AQ_EXP_INDEX_TABLES PACKAGE DBMS_AQ_EXP_QUEUES PACKAGE DBMS_AQ_EXP_QUEUE_TABLES PACKAGE DBMS_AQ_EXP_SUBSCRIBER_TABLES PACKAGE DBMS_AQ_EXP_TIMEMGR_TABLES PACKAGE DBMS_AQ_IMPORT_INTERNAL PACKAGE DBMS_AQ_IMP_INTERNAL PACKAGE DBMS_AQ_SYS_EXP_INTERNAL PACKAGE DBMS_AQ_SYS_IMP_INTERNAL PACKAGE DBMS_DDL PACKAGE DBMS_HS PACKAGE DBMS_HS_ALT PACKAGE DBMS_HS_UTL PACKAGE DBMS_IAS_CONFIGURE PACKAGE DBMS_IAS_QUERY PACKAGE DBMS_IAS_SESSION PACKAGE DBMS_IREFRESH PACKAGE DBMS_ISNAPSHOT PACKAGE DBMS_PRVTAQIM PACKAGE DBMS_PRVTAQIP PACKAGE DBMS_RULE_ADM PACKAGE DBMS_SNAPSHOT PACKAGE DBMS_SNAPSHOT_UTL PACKAGE DBMS_SNAP_REPAPI PACKAGE DBMS_SNAP_REPAPI PACKAGE DBMS_STATS PACKAGE DBMS_SUMADV PACKAGE DBMS_SUMMARY PACKAGE DBMS_SUMREF_CHILD PACKAGE DBMS_SUMREF_PARENT PACKAGE DBMS_UTILITY PACKAGE HTP PACKAGE OWA PACKAGE OWA_COOKIE PACKAGE OWA_CUSTOM PACKAGE OWA_TEXT PACKAGE OWA_UTIL PACKAGE PRVT_EGUTL PACKAGE PRVT_EPGC -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Praveen Sahni 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: Koivu, Lisa 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: Farnsworth, Dave 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: Use of Orastaff
I sent a resume to them once. It fell into a black hole. If you are looking for a head hunter, Jim Wilson with Triad Group in Seattle is the quintessential professional. Always honest even if you do not always like what he has to say. About a year ago I talked to him, his advice 'sit tight'. It makes even more sense now then it did at the time. Not too many recruiters will tell you to not change jobs. For me, that's a big thumbs up. --- Ron Rogers [EMAIL PROTECTED] wrote: Lisa. Welcome back. Ron ROR mô¿ôm [EMAIL PROTECTED] 03/20/02 02:25PM I got a response from them once, when I first moved down here. The market was frantic at that point and I had already accepted a position. I even spoke to Bill Law himself for a brief moment. I think what really got his attention was No relocation reimbursement required, we are moving to Florida Not my skills, whatever those are. I still don't know... Lisa Koivu Oracle Database Monkey Mama (Almost...) Fairfield Resorts, Inc. 954-935-4117 -Original Message- From: Joe Raube [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, March 20, 2002 1:21 PM To: Multiple recipients of list ORACLE-L Subject:Re: Use of Orastaff I have sent my resume to them, and called them on the phone - no one ever responded to me. -Joe --- bill thater [EMAIL PROTECTED] wrote: [EMAIL PROTECTED] wrote: I am assuming that since Orastaff continues to post positions on to this list that they are reputable. Is there anyone out there that is willing to share their experiences with this company. Did you get interviews? Did you obtain a position? etc i have sent my resume to them on a couple of occasions. i have not received any interviews from them. -- -- Bill Shrek Thater ORACLE DBA [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. Performance is easier to add than clarity. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: bill thater 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). __ Do You Yahoo!? Yahoo! Sports - live college hoops coverage http://sports.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Raube 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: Koivu, Lisa 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
Error in procedure with dba_users
Hi list,
I have this procedure under the system user, and when try to create it
I get an error
CREATE OR REPLACE PROCEDURE GENERAR_ESTADISTICAS AS
CURSOR ESQUEMAS IS
SELECT USERNAME ESQUEMA
FROM SYS.DBA_USERS
WHERE
USERNAME IN ('RAMON', 'SCOTT');
BEGIN
FOR E IN ESQUEMAS
LOOP
DBMS_UTILITY.ANALYZE_SCHEMA(E.ESQUEMA, 'COMPUTE');
END LOOP;
END;
3/8 PL/SQL: SQL Statement ignored
4/16 PLS-00201: identifier 'SYS.DBA_USERS' must be declared
11/4 PL/SQL: Statement ignored
11/32PLS-00364: loop index variable 'E' use is invalid
SQL
Any help .
TIA
Ramon E. Estevez
--
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: Rebuilding Index Organised Tables (IOTs)
Many thanks to all of those people who advised. Unfortunately we are running on 8.1.6.3, so cannot do alter table move.. as well :( If you get any info, please let me know. Meanwhile, here are few bits that I gathered in IOTs. Cheers Kumanan Why use Index-Organized Tables * Fast key-based access to table data for queries involving exact match and range searches. * Changes to the table data (such as adding new rows, updating rows, or deleting rows) result only in updating the index structure (because there is no separate table storage area). i.e. fast. * Also, storage requirements are reduced because key columns are not duplicated in the table and index. The remaining non-key columns are stored in the index structure. * Index-organized tables are particularly useful when you are using applications that must retrieve data based on a primary key. * Index-organized tables are also suitable for modeling application-specific index structures. For example, content-based information retrieval applications containing text, image and audio data require inverted indexes that can be effectively modeled using index-organized tables. * If all your columns contain numbers only, I would say your benefit from this usage is minimized. However you will still benefit from the storage reduction : * Index-organized tables are like regular tables with a primary key index on one or more of its columns. However, instead of maintaining two separate storage spaces for the table and B*tree index, an index-organized table only maintains a single B*tree index containing the primary key of the table and other column values. * Bad for updates as entire rows may have to be moved - as per the index tree structure. * Not good for frequent deletes/updates/ inserts. * Cannot be rebuilt like an index. NB: Except for 8i and above, no other indexes can be created on IOT. For an index-organized table, use the index_organized_table_clause of the syntax. The move_table_clause rebuilds the index-organized table's primary key index B*-tree. The overflow data segment is not rebuilt unless the OVERFLOW keyword is explicitly stated, with two exceptions: * If you alter the values of PCTTHRESHOLD or the INCLUDING column as part of this ALTER TABLE statement, the overflow data segment is rebuilt. * If any of out-of-line columns (LOBs, varrays, nested table columns) in the index-organized table are moved explicitly, then the overflow data segment is also rebuilt. The index and data segments of LOB columns are not rebuilt unless you specify the LOB columns explicitly as part of this ALTER TABLE statement. 117168.1: TS for IOT won't be visible as data can go into TWO different TS's: CREATE TABLE DOCINDEX (token CHAR(20), doc_oid INTEGER, token_frequency SMALLINT, token_occurrence_data VARCHAR2(512), CONSTRAINT pk_docindex PRIMARY KEY (token, doc_oid) ) ORGANIZATION INDEX TABLESPACE text_collection PCTTHRESHOLD 20 INCLUDING token_frequency OVERFLOW TABLESPACE text_collection_overflow; Generate the DDL for the table again with property Index Organised = Yes for full table IOT? 126392.996 create table EASY ( ..., constraint PK_EASY_IDPRIMARY KEY(EASY_ID)) ORAGANIZATION INDEX [STORAGE CLAUSE]; 116899.996 One more thing is if you are going to have lot of manipulations like update, delete on Index organised table, it will increase the burden since it has to reorganise the entire table. It is advisable to have Index orgnised table with less number of manipulations. -- 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: A RMAN question
Hi Yechiel, Of course I do use a RMAN catalog on server B to backup the cloned database. The scenario I described was because I am wondering whether RMAN will be happy taking a second incremental backup the next day after the controlfiles of the target database were overwritten overnight. Please read my earlier mail keeping in mind that a RMAN catalog database is being used. I would b thankful for any advice on this. Regards, Samir Samir Sarkar Oracle DBA SchlumbergerSema Email : [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : +44 (0) 115 - 957 6028 EPABX : +44 (0) 115 - 957 6418 Ext. 76028 Fax : +44 (0) 115 - 957 6018 -Original Message- Sent: 21 March 2002 13:38 To: Multiple recipients of list ORACLE-L Hello Samir I do not work with RMAN but I THINK that you have a conceptual error in your logic. Since you do not have a catalog RMAN use the control files as catalog. When you want to restore RMAN will not find the data on the full backup in the control files. You will have only the data on the last incremental backup. How can you restore? Yechiel Adar, Mehish Computer Services [EMAIL PROTECTED] -Original Message- From: SARKAR, Samir [SMTP:[EMAIL PROTECTED]] Sent: Thu, March 21, 2002 10:38 AM To: Multiple recipients of list ORACLE-L Subject: RE: A RMAN question Hi Dennis, Thanks for replying. I guess I have not been able to make my question clear. You see, I need to backup only the cloned database on server B and NOT the database on server A. My scenario is as follows : The main db on server A is a partitioned data warehouse system and we r planning to copy over the data files and the control files every night to the cloned db on server B. Thereafter, we will b taking a RMAN backup of the cloned db on server B only. As I said, RMAN writes the backup info on the target database's control files when it takes the backup. I also said that we plan to take a full backup on Sundays and incremental backup on the other days. My confusion was : Say, RMAN takes a backup of the database on the cloned db on server B on a Monday. On MOnday night as per procedure, the control files and the database files from the main db on server A are copied over to server B. On Tuesday, will RMAN b happy taking the incremental backup again of the cloned db on server B even though it finds that the control files r different than the ones it wrote the backup info to the previous day ?? Or will it get confused and prompt for a FULL backup ?? Any ideas from anybody would b appreciated a lot. Regards, Samir Samir Sarkar Oracle DBA SchlumbergerSema Email : [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : +44 (0) 115 - 957 6028 EPABX : +44 (0) 115 - 957 6418 Ext. 76028 Fax : +44 (0) 115 - 957 6018 -Original Message- Sent: 20 March 2002 19:16 To: Multiple recipients of list ORACLE-L Samir - We have found that each Oracle database has an internal ID. This ID doesn't change when you clone it as you describe. RMAN uses this ID, and will become confused if it sees two databases that are identical. One way around this is to run two RMAN catalogs. I have not considered it an advantage to use RMAN with the control file (non-catalog) option, so I haven't considered all the ramifications there. Have you looked at the RMAN DUPLICATE command to clone the database? Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, March 20, 2002 10:14 AM To: Multiple recipients of list ORACLE-L Hi All, Though I have been using RMAN for quite a while now, I would like to ask for a clarification here. We have a production database with partitioning options on server A. We copy over the files (including the control files) of the prod database each night to a server B. We will then be using RMAN to backup the database on server. We intend to take a Full backup on Sundays and Incrementals on all weekdays. I know that when we take a RMAN backup, it writes information about that task to the target database's control files which is precisely why we need not have a catalog database necessarily. My question is when RMAN takes a backup once, will it return an error when tries to take an incremental backup a second time since we have replaced the control files overnight ?? I mean, will RMAN be happy with taking an INCREMENTAL backup of the database even if it finds that the control files on which it had written the backup info the previous night have been replaced with a new set of control files ?? Will it prompt for a full backup ??? Any help will be greatly appreciated. Regards, Samir Samir Sarkar Oracle DBA SchlumbergerSema Email : [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : +44 (0) 115 - 957 6028 EPABX : +44 (0) 115 - 957 6418 Ext. 76028 Fax : +44 (0) 115
9i install
We are going to 9i on our NT4.0 SP6 prod box. I will test the 9i install on a test box first. My question is: Do I need to install a patchset with 9.0.1.0.0 or can I run as is? If I run the catexp from 9i into 8i (as SYS) and export I will be able to import into 9i, correct? Any advice is highly appreciated. thanks, David Ehresmann Oracle DBA 8i OCP MCI Worldcom [EMAIL PROTECTED] 972.656.1015 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: David Ehresmann 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 9i anyone?
Greetings, We are contemplating a purchase of Oracle Application Server 9i. Anyone using it? Mind sharing your experience? What prompted you to purchase an Application Server? Why was Oracle App Server chosen, as opposed to Weblogic, etc? J2EE considerations? Ease of configuration/maintenance? Who's in charge of OAS (DBA, SysAdmin, Developer)? Stability? We've had numerous issues with Weblogic recently, hence the question. Do you feel the ROI has justified the purchase? How many developers are involved in writing apps and/or supporting your installation? Thanks in advance for any and all responses. Gary Weber Senior DBA Charles Jones, LLC||Superior Information Services, LLC 609-538-1000, ext 5529 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gary Weber 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: kill the procedure Call
If you are using unix, you have to play with tcp kernel parameters.
We have tuned these parameters:
tcp_ip_abort_interval the time it takes for an existing connection to be closed
tcp_ip_abort_cinterval the expiration time for establishing a new connection
tcp_time_wait_interval the length of time the server holds a connection in a
TIME-WAIT state after the end of the connection
tcp_keepalive_interval the time period in which the server will continue sending
probes to determine whether a connection is still active
tcp_conn_req_max_q the maximum number of completed connections
tcp_conn_req_max_q0 the maximum number of connections with handshake incomplete
Default values
Parameter Default Recommended
tcp_ip_abort_interval 480 (8 minutes) 6 (1 minute)
tcp_ip_abort_cinterval 18 (3 minutes) 6 (1 minute)
tcp_time_wait_interval 24 (8 minutes) 6 (1 minute)
tcp_keepalive_interval 720 (2 hours) 90 (15 minutes)
tcp_conn_req_max_q 128 256
tcp_conn_req_max_q0 10242048
The best way to determine whether or not a system is having connection problems is to
look at the output of the netstat -an command. The netstat -a command displays the
current status of connections. With the addtional n option, the command does not
attempt to resolve IP addresses as host names, both speeding up the output and making
it more predictable. The following netstat command gives a quick summary of the
number of TCP connections in each state.
bash-2.01# netstat -anP tcp | tail +5 | awk '{print $7}' | sort | uniq -c
27 ESTABLISHED
6 IDLE
36 LISTEN
1 Remote - ignore this line
1 SYN_SENT
24 TIME_WAIT
For example, if you see a large number of connections in the TIME_WAIT state, this may
indicate that you need to reduce your time wait interval (tcp_ip_time_wait_interval)
to a smaller value. If you find many sockets in the FIN_WAIT_2 state, your server is
probably waiting for the final ACK from the client before moving to close these
connections.
Let me know if you need any more help and I will send you our document which describes
the procedures to set these parameters.
Thanks
Rakesh
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Rakesh Gupta
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).
PO 9i and Windows Me
Hi everyone Has anyone installed Personal Oracle 9i on Windows Me? You could run PO 8.1.7 for Windows 98 on Windows Me. Friend of mine just installed PO 9i for Windows 98 on his Windows Me computer and run into problems. I wonder whether it doesn't run on Windows Me or it is his computer issue Thanks Witold == Witold Iwaniec Sr 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).
Embarcadero DBArtisan Trial Version
All, Six months back I installed DBArtisan trial version. I didn't get a chance to play much with DBArtisan. Now I un-installed DBArtisan and reinstalled again on same desktop. It is prompting me to enter license key. Is there a way to get trial version without rebuilding my desktop. I think you got my point. Thanks, Bob __ Do You Yahoo!? Yahoo! Movies - coverage of the 74th Academy Awards® http://movies.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bob Robert 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: Direct Import of XML file
Search otn.oracle.com for the XML Developers toolkit, XDK. --- [EMAIL PROTECTED] wrote: Hi list, Is there any tool in Oracle to import a xml-file direct to a database table? TIA Volker Schoen E-Mail: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] http://www.inplan.de http://www.inplan.de __ Do You Yahoo!? Yahoo! Movies - coverage of the 74th Academy Awards® http://movies.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Raube 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: Use of Orastaff
Good point Peter. There may be a lot of slimy ones, but I've also found one or two I would gladly work with again that call me from time to time to check in on me. If anyone wants a good recruiter's name in Florida, email me directly. Lisa Koivu Oracle Database Barrel Belly Fairfield Resorts, Inc. 954-935-4117 -Original Message- From: Peter Barnett [SMTP:[EMAIL PROTECTED]] Sent: Thursday, March 21, 2002 9:53 AM To: Multiple recipients of list ORACLE-L Subject: RE: Use of Orastaff I sent a resume to them once. It fell into a black hole. If you are looking for a head hunter, Jim Wilson with Triad Group in Seattle is the quintessential professional. Always honest even if you do not always like what he has to say. About a year ago I talked to him, his advice 'sit tight'. It makes even more sense now then it did at the time. Not too many recruiters will tell you to not change jobs. For me, that's a big thumbs up. --- Ron Rogers [EMAIL PROTECTED] wrote: Lisa. Welcome back. Ron ROR mô¿ôm [EMAIL PROTECTED] 03/20/02 02:25PM I got a response from them once, when I first moved down here. The market was frantic at that point and I had already accepted a position. I even spoke to Bill Law himself for a brief moment. I think what really got his attention was No relocation reimbursement required, we are moving to Florida Not my skills, whatever those are. I still don't know... Lisa Koivu Oracle Database Monkey Mama (Almost...) Fairfield Resorts, Inc. 954-935-4117 -Original Message- From: Joe Raube [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, March 20, 2002 1:21 PM To: Multiple recipients of list ORACLE-L Subject: Re: Use of Orastaff I have sent my resume to them, and called them on the phone - no one ever responded to me. -Joe --- bill thater [EMAIL PROTECTED] wrote: [EMAIL PROTECTED] wrote: I am assuming that since Orastaff continues to post positions on to this list that they are reputable. Is there anyone out there that is willing to share their experiences with this company. Did you get interviews? Did you obtain a position? etc i have sent my resume to them on a couple of occasions. i have not received any interviews from them. -- -- Bill Shrek Thater ORACLE DBA [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. Performance is easier to add than clarity. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: bill thater 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). __ Do You Yahoo!? Yahoo! Sports - live college hoops coverage http://sports.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Raube 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: Koivu, Lisa 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
Re: Error in procedure with dba_users
You must grant select on DBA_USERS *directly* to the
user creating the procedure - not via a role.
hth
connor
--- [EMAIL PROTECTED] wrote: Hi list,
I have this procedure under the system user, and
when try to create it
I get an error
CREATE OR REPLACE PROCEDURE GENERAR_ESTADISTICAS AS
CURSOR ESQUEMAS IS
SELECT USERNAME ESQUEMA
FROM SYS.DBA_USERS
WHERE
USERNAME IN ('RAMON', 'SCOTT');
BEGIN
FOR E IN ESQUEMAS
LOOP
DBMS_UTILITY.ANALYZE_SCHEMA(E.ESQUEMA,
'COMPUTE');
END LOOP;
END;
3/8 PL/SQL: SQL Statement ignored
4/16 PLS-00201: identifier 'SYS.DBA_USERS' must
be declared
11/4 PL/SQL: Statement ignored
11/32PLS-00364: loop index variable 'E' use is
invalid
SQL
Any help .
TIA
Ramon E. Estevez
--
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).
=
Connor McDonald
http://www.oracledba.co.uk (mirrored at
http://www.oradba.freeserve.co.uk)
Some days you're the pigeon, some days you're the statue
__
Do You Yahoo!?
Everything you'll ever need on one web page
from News and Sport to Email and Music Charts
http://uk.my.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: =?iso-8859-1?q?Connor=20McDonald?=
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 CERT Advisory
I think that Oracle's bravado has translated into lower share prices recently... : ( Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) -Original Message- Sent: Thursday, March 21, 2002 10:48 AM To: Multiple recipients of list ORACLE-L Subject:RE: Oracle CERT Advisory Thanks Patrice for sharing this info. So much for Can't break it. Can't break in. Unbreakable marketing jingle. Lisa Koivu Oracle Database Something. Fairfield Resorts, Inc. 954-935-4117 -Original Message- From: Boivin, Patrice J [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, March 20, 2002 10:08 PM To: Multiple recipients of list ORACLE-L Subject: RE: Oracle CERT Advisory CERT is working on a how to fix your Oracle DB paper, you can ask for a copy at [EMAIL PROTECTED] Oracle security problems may be more prevalent than previously reported. Pete Finnegan, with the help of many of the other Oracle security gurus around the world, has completed a first draft of SANS new Oracle Security: Step-by-Step guide. We are distributing the list of Oracle security problems to be sure we have addressed all the known issues. We'll share the solutions sections with those people who provide substantive feedback on the problems. If you know a lot about Oracle security and *will* provide feedback, please email [EMAIL PROTECTED] with the subject Oracle security problems and we will email you a copy. Include your name, organization, city, state, and country. Alan Regards, 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- [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 20, 2002 9:43 PM To: Multiple recipients of list ORACLE-L Subject: RE: Oracle CERT Advisory Check http://otn.oracle.com/deploy/security/alerts.htm Hemant K Chitale Principal DBA Chartered Semiconductor Manufacturing Ltd [This e-mail is confidential and may also be privileged. If you are not the intended recipient, please delete it and notify us immediately; you should not copy or use it for any purpose, nor disclose its contents to any other person. Thank you.] -- 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: 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: Koivu, Lisa 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
Automatically startup database
How to make database instance on Win2K automatically startup when the PC up? for now I have to run C: sqlplus internal sqlstartup ...every time myserver is powered on. TIA, Ferry Situmorang: Using Oracle 8.1.7 Designer 6i R4 PT Perkebunan Nusantara XIII (Persero) Pontianak-Indonesia http://www.ptpn13.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ferry Situmorang 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 alter password frm user
revoke ALTER ANY USER or ALTER USER privilege from this user. -Message d'origine- De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Date: jeudi 21 mars 2002 16:13 À: Multiple recipients of list ORACLE-L Objet: Revoke alter password frm user Hi list, Is it possible to revoke a oracle user the right to alter his password? TIA Volker Schoen E-Mail: mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] http://www.inplan.de http://www.inplan.de -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bernard, Gilbert 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: Error in procedure with dba_users
Tested it.
You do not have permission for dba_users.
You need to have role select_catalog_role.
On 8.1.6.3.4 on NT.
Yechiel Adar, Mehish Computer Services
[EMAIL PROTECTED]
-Original Message-
From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
Sent: Thu, March 21, 2002 5:33 PM
To: Multiple recipients of list ORACLE-L
Subject: Error in procedure with dba_users
Hi list,
I have this procedure under the system user, and when try to create it
I get an error
CREATE OR REPLACE PROCEDURE GENERAR_ESTADISTICAS AS
CURSOR ESQUEMAS IS
SELECT USERNAME ESQUEMA
FROM SYS.DBA_USERS
WHERE
USERNAME IN ('RAMON', 'SCOTT');
BEGIN
FOR E IN ESQUEMAS
LOOP
DBMS_UTILITY.ANALYZE_SCHEMA(E.ESQUEMA, 'COMPUTE');
END LOOP;
END;
3/8 PL/SQL: SQL Statement ignored
4/16 PLS-00201: identifier 'SYS.DBA_USERS' must be declared
11/4 PL/SQL: Statement ignored
11/32PLS-00364: loop index variable 'E' use is invalid
SQL
Any help .
TIA
Ramon E. Estevez
--
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: =?iso-8859-8?Q?=E0=E3=F8_=E9=E7=E9=E0=EC?=
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 9i anyone?
Gary Weber wrote: Greetings, We are contemplating a purchase of Oracle Application Server 9i. Anyone using it? We are. (TIMW). Mind sharing your experience? No What prompted you to purchase an Application Server? Why was Oracle App Server chosen, as opposed to Weblogic, etc? 9iAS is a marketing conglomeration consisting of Apache Orion (a freeware JSP, Java servlet Server) Reports60 Forms60 Developer WebCache Portal plus a few others We got it primarily for Reports60 Forms60 J2EE considerations? Ease of configuration/maintenance? The Forms60 Reports60 were a MAJOR pain to configure on *nix (Solaris). These two products appear to have been developed on Windoze and ported to Unix. Both do funky stuff with filenames involving upper/lower case issues. Windoze is case insensitive; while *nix is case sensitive; which requires soft links between BASE.pll, base.pll, Base.pll! Who's in charge of OAS (DBA, SysAdmin, Developer)? In my case DBA, because I'm an ex-SysAdmin the only person who had a fighting chance to make this POS s/w operational. Stability? We've had numerous issues with Weblogic recently, hence the question. Apache is rock solid. The Reports60 server dies and/or hangs frequently repeatedly. Do you feel the ROI has justified the purchase? Who knows? I'm just a geek techie. How many developers are involved in writing apps and/or supporting your installation? Two developers, plus me. Feel free to contact me off the list if you so desire. HTH YMMV HAND! -- 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: ways to speed up import
All the suggestions I have seen are focused on improving import, which is great. But how about stepping back, and talking with the client about using transportable tablespaces? -Original Message- Sent: Wednesday, March 20, 2002 10:48 PM To: Multiple recipients of list ORACLE-L i'm getting larger and larger db dumps from clients that i need to import into local db's . . . dump appoaching 3Gb (only the one schem I need). Looking for ways to speed up import . . . tried playing with buffer size and commit=y, but not much luck. Also tried delaying index creation, which helps some . . . running 8.1.7.2 on solaris 8 - single cpu, depending on the box anywhere from 2 - 4 Gb RAM Thanks, all Bill Magaliff Framework, Inc. 914-631-2322 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Magaliff, Bill 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: Grabowy, Chris 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).
iFS - storing XML via Windows Explorer
Hi, we have a iFS instance. iFS lets you update an attribute of a file by copying a proper XML file into a directory and iFS interprets it as a command. If something is not O.K. with the file, it spits out an error file into the same directory. Now my problem is that I would like to store an XML file in an iFS direcotry by draging the XML file into the iFS directory in Windows Explorer. The result is that I get a error file. Does someone know of a way to override this feature? TIA, Tamas Szecsy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Szecsy Tamas 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: Embarcadero DBArtisan Trial Version
Phone up Embarcadero, and ask them for an extended trial key? This is pretty much the norm for these types of tools.. Embarcadero should just give you a key that will last for another month. Tools like this keep track of if a product was installed previously, and store some obscure key in the registry, so even an un-install cannot get around the license issue. Failing that set your system date back a year : Disclaimer: This is a joke, I do *not* know whether this will work with Embarcadero tools, and recommend that you get in touch with Embarcadero for an extended license key. HTH Mark -Original Message- Sent: 21 March 2002 15:59 To: Multiple recipients of list ORACLE-L All, Six months back I installed DBArtisan trial version. I didn't get a chance to play much with DBArtisan. Now I un-installed DBArtisan and reinstalled again on same desktop. It is prompting me to enter license key. Is there a way to get trial version without rebuilding my desktop. I think you got my point. Thanks, Bob __ Do You Yahoo!? Yahoo! Movies - coverage of the 74th Academy Awards. http://movies.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bob Robert 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: A RMAN question
Thanks Jay.actually our clients want it that way that the cloned DB is backed up instead of the production DB. I think u r right about RMAN getting confused when it reads the controlfiles the next day for taking an incremental backup since they will have been replaced overnight. But I am using a recovery catalog database, so I dont understand why won't RMAN just go and take an incremental backup of only the changed blocks anyway instead of bothering about whats there in the control files of the target database. Does this also mean that in case I have to recreate the controlfile of the target database, I can never do an incremental backup during the first go ?? Regards, Samir Samir Sarkar Oracle DBA SchlumbergerSema Email : [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : +44 (0) 115 - 957 6028 EPABX : +44 (0) 115 - 957 6418 Ext. 76028 Fax : +44 (0) 115 - 957 6018 -Original Message- Sent: 21 March 2002 14:58 To: Multiple recipients of list ORACLE-L I think RMAN will have problems with the incremental backup. When it looks at the control files for the cloned db, they will have no record of a previous backup. What you are doing is a bit unusual in that the database on server A (which would be considered production) should be backed up. And if you are backing up the database on server A, why bother to backup the datbase on Server B? Especially if you are refreshing it each night. It sounds like you should really be setting up a standby database. Jay -Original Message- From: SARKAR, Samir [SMTP:[EMAIL PROTECTED]] Sent: Thu, March 21, 2002 10:38 AM To: Multiple recipients of list ORACLE-L Subject: RE: A RMAN question Hi Dennis, Thanks for replying. I guess I have not been able to make my question clear. You see, I need to backup only the cloned database on server B and NOT the database on server A. My scenario is as follows : The main db on server A is a partitioned data warehouse system and we r planning to copy over the data files and the control files every night to the cloned db on server B. Thereafter, we will b taking a RMAN backup of the cloned db on server B only. As I said, RMAN writes the backup info on the target database's control files when it takes the backup. I also said that we plan to take a full backup on Sundays and incremental backup on the other days. My confusion was : Say, RMAN takes a backup of the database on the cloned db on server B on a Monday. On MOnday night as per procedure, the control files and the database files from the main db on server A are copied over to server B. On Tuesday, will RMAN b happy taking the incremental backup again of the cloned db on server B even though it finds that the control files r different than the ones it wrote the backup info to the previous day ?? Or will it get confused and prompt for a FULL backup ?? Any ideas from anybody would b appreciated a lot. Regards, Samir Samir Sarkar Oracle DBA SchlumbergerSema Email : [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : +44 (0) 115 - 957 6028 EPABX : +44 (0) 115 - 957 6418 Ext. 76028 Fax : +44 (0) 115 - 957 6018 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jay Hostetter 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 email is confidential and intended solely for the use of the individual to whom it is addressed. Any views or opinions presented are solely those of the author and do not necessarily represent those of SchlumbergerSema. If you are not the intended recipient, be advised that you have received this email in error and that any use, dissemination, forwarding, printing, or copying of this email is strictly prohibited. If you have received this email in error please notify the SchlumbergerSema Helpdesk by telephone on +44 (0) 121 627 5600. ___ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: SARKAR, Samir 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:
RE: Use of Orastaff
You want to OT don't you. The power of the OT list is strong in you young Koivu. -Original Message- Sent: Thursday, March 21, 2002 10:08 AM To: Multiple recipients of list ORACLE-L Good point Peter. There may be a lot of slimy ones, but I've also found one or two I would gladly work with again that call me from time to time to check in on me. If anyone wants a good recruiter's name in Florida, email me directly. Lisa Koivu Oracle Database Barrel Belly Fairfield Resorts, Inc. 954-935-4117 -Original Message- From: Peter Barnett [SMTP:[EMAIL PROTECTED]] Sent: Thursday, March 21, 2002 9:53 AM To: Multiple recipients of list ORACLE-L Subject: RE: Use of Orastaff I sent a resume to them once. It fell into a black hole. If you are looking for a head hunter, Jim Wilson with Triad Group in Seattle is the quintessential professional. Always honest even if you do not always like what he has to say. About a year ago I talked to him, his advice 'sit tight'. It makes even more sense now then it did at the time. Not too many recruiters will tell you to not change jobs. For me, that's a big thumbs up. --- Ron Rogers [EMAIL PROTECTED] wrote: Lisa. Welcome back. Ron ROR mô¿ôm [EMAIL PROTECTED] 03/20/02 02:25PM I got a response from them once, when I first moved down here. The market was frantic at that point and I had already accepted a position. I even spoke to Bill Law himself for a brief moment. I think what really got his attention was No relocation reimbursement required, we are moving to Florida Not my skills, whatever those are. I still don't know... Lisa Koivu Oracle Database Monkey Mama (Almost...) Fairfield Resorts, Inc. 954-935-4117 -Original Message- From: Joe Raube [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, March 20, 2002 1:21 PM To: Multiple recipients of list ORACLE-L Subject: Re: Use of Orastaff I have sent my resume to them, and called them on the phone - no one ever responded to me. -Joe --- bill thater [EMAIL PROTECTED] wrote: [EMAIL PROTECTED] wrote: I am assuming that since Orastaff continues to post positions on to this list that they are reputable. Is there anyone out there that is willing to share their experiences with this company. Did you get interviews? Did you obtain a position? etc i have sent my resume to them on a couple of occasions. i have not received any interviews from them. -- -- Bill Shrek Thater ORACLE DBA [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. Performance is easier to add than clarity. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: bill thater 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). __ Do You Yahoo!? Yahoo! Sports - live college hoops coverage http://sports.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Raube 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: Koivu, Lisa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858)
RE: Embarcadero DBArtisan Trial Version
The download of the evaluation copy of dbartisan states clearly that it is good only for 15 days. I think that you need to download another evaluation copy. If you need you can contact [EMAIL PROTECTED] and I am sure they will be happy to assist you. Yechiel Adar, Mehish Computer Services [EMAIL PROTECTED] -Original Message- From: Bob Robert [SMTP:[EMAIL PROTECTED]] Sent: Thu, March 21, 2002 5:59 PM To: Multiple recipients of list ORACLE-L Subject: Embarcadero DBArtisan Trial Version All, Six months back I installed DBArtisan trial version. I didn't get a chance to play much with DBArtisan. Now I un-installed DBArtisan and reinstalled again on same desktop. It is prompting me to enter license key. Is there a way to get trial version without rebuilding my desktop. I think you got my point. Thanks, Bob __ Do You Yahoo!? Yahoo! Movies - coverage of the 74th Academy Awards http://movies.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bob Robert 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: =?iso-8859-8?Q?_? 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: Embarcadero DBArtisan Trial Version
Uninstall the trial version and reinstall it? I don't know if that will work but it is worth a try. Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, March 21, 2002 10:58 AM All, Six months back I installed DBArtisan trial version. I didn't get a chance to play much with DBArtisan. Now I un-installed DBArtisan and reinstalled again on same desktop. It is prompting me to enter license key. Is there a way to get trial version without rebuilding my desktop. I think you got my point. Thanks, Bob __ Do You Yahoo!? Yahoo! Movies - coverage of the 74th Academy Awards® http://movies.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bob Robert 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: Automatically startup database
You need to make sure that the oraclesSIDservice is set to automatically start in the Services panel. Dave -Original Message- Sent: Thursday, March 21, 2002 10:38 AM To: Multiple recipients of list ORACLE-L How to make database instance on Win2K automatically startup when the PC up? for now I have to run C: sqlplus internal sqlstartup ...every time myserver is powered on. TIA, Ferry Situmorang: Using Oracle 8.1.7 Designer 6i R4 PT Perkebunan Nusantara XIII (Persero) Pontianak-Indonesia http://www.ptpn13.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ferry Situmorang 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: Farnsworth, Dave 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: Rebuilding Index Organised Tables (IOTs)
Correct, and apologies, it's too easy to give the quick and simple answer. If you want to rebuild the whole thing, without changing tablespaces, then: alter table iot_tab move overflow; You can't move the overflow with an online move, of course (except in Oracle 9, I expect). If you also have LOB columns you may have to add further details to make those move too, such as alter table iot_lob_tab move lob(my_lob) store as my_lob_seg; which would rebuild the index layer, overflow layer, and lobsegment layers. Jonathan Lewis http://www.jlcomp.demon.co.uk Next Seminar - UK, April 3rd - 5th http://www.jlcomp.demon.co.uk/seminar.html Host to The Co-Operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html Author of: Practical Oracle 8i: Building Efficient Databases -Original Message- To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: 20 March 2002 22:41 |It seems to me that alter table iot_table move -- just rebuilds the the |branching part of the index. |So if this is the case--- export import or create table iot as ... are |the best way to do the real job. | |Corrections and feedback are welcomed. | |Waleed | -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jonathan Lewis 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: Rebuilding Index Organised Tables (IOTs)
8.1.5 and 8.1.7 both support alter table iot_tab move for IOTs - is there a special bug in 8.1.6 ? Your own notes even describe this: |The move_table_clause rebuilds the index-organized table's primary |key index B*-tree. The overflow data segment is not rebuilt unless the |OVERFLOW keyword is explicitly stated, with two exceptions: Jonathan Lewis http://www.jlcomp.demon.co.uk Next Seminar - UK, April 3rd - 5th http://www.jlcomp.demon.co.uk/seminar.html Host to The Co-Operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html Author of: Practical Oracle 8i: Building Efficient Databases -Original Message- To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: 21 March 2002 16:17 |Many thanks to all of those people who advised. | |Unfortunately we are running on 8.1.6.3, so cannot do alter table move.. |as well :( |If you get any info, please let me know. | |Meanwhile, here are few bits that I gathered in IOTs. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jonathan Lewis 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: Automatically startup database
- Original Message - How to make database instance on Win2K automatically startup when the PC up? it is specified in the windows registry check HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\HOME0 there should be entries named ORA_sid_AUTOSTART for each instance in this ORACLE_HOME (where *sid* is the SID of the instance) if u set the value for some ORA_sid_AUTOSTART to TRUE the respective instance should be started automatically note that this is the default behaviour of the Oracle installation (set autostart to true), so most probably the reason for your instance not being autostarted is different hth, Marin ...what you brought from your past, is of no use in your present. When you must choose a new path, do not bring old experiences with you. Those who strike out afresh, but who attempt to retain a little of the old life, end up torn apart by their own memories. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Marin Dimitrov 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: Rebuilding Index Organised Tables (IOTs)
Thanks Jonathan. I'm just going o test it out. Will let you guys know if there are any positive outcomes. Thanks Kumanan -Original Message- From: Jonathan Lewis [SMTP:[EMAIL PROTECTED]] Sent: 21 March 2002 17:08 To: Multiple recipients of list ORACLE-L Subject: Re: Rebuilding Index Organised Tables (IOTs) Correct, and apologies, it's too easy to give the quick and simple answer. If you want to rebuild the whole thing, without changing tablespaces, then: alter table iot_tab move overflow; You can't move the overflow with an online move, of course (except in Oracle 9, I expect). If you also have LOB columns you may have to add further details to make those move too, such as alter table iot_lob_tab move lob(my_lob) store as my_lob_seg; which would rebuild the index layer, overflow layer, and lobsegment layers. Jonathan Lewis http://www.jlcomp.demon.co.uk Next Seminar - UK, April 3rd - 5th http://www.jlcomp.demon.co.uk/seminar.html Host to The Co-Operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html Author of: Practical Oracle 8i: Building Efficient Databases -Original Message- To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: 20 March 2002 22:41 |It seems to me that alter table iot_table move -- just rebuilds the the |branching part of the index. |So if this is the case--- export import or create table iot as ... are |the best way to do the real job. | |Corrections and feedback are welcomed. | |Waleed | -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jonathan Lewis 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: Oracle hangs...Oracle 8.1.7.3 and Solaris 2.7
Well, unfortunately we haven't solved the problem yet, so I don't have any solutions to share with everyone. We are using Sun hardware, and we have not run diagnostics on the memory. I don't want to dismiss that idea out of hand, but I don't understand how bad memory could be affecting only one of the three instances. There are two other 8.1.7.3 instances that run fine, never even a hiccup. The server has 2GB of memory. The application that uses this database (when its up) is connecting over the network, but when it hangs, you are unable to connect from a remote client or from on the server. I suggested to the support person handling our case that maybe we could try using some of the various oradebug options suggested by people on the list and suggested on Metalink, but he suggested looking at the following things first: This may be caused by a system resource problem. Was this DB relinked after the upgrade? It might help to get the initsid.ora's for all the instances What is the total size of each SGA? What is the value of the PROCESSES for each instance How much physical memory on the system? How much swap space? Type sysdef -i |grep SHMMAX Type sysdef -i |grep SEMMNS Still waiting for his reply to my answers... Thanks for all ideas you guys have shared. -Original Message- Sent: Wednesday, March 20, 2002 11:58 PM To: Multiple recipients of list ORACLE-L Please let us know how you fixed the problem. Are you using Sun Hardware? can you run diagnostics for the memory? Are you connecting using IPC(meaning direct) or through TCP(network)? Is it the network that is causing problem? --- Grabowy, Chris [EMAIL PROTECTED] wrote: We have a particular database that hangs on a regular basis. Here are the stats and symptoms. Oracle stats -- 8.1.7.3 (highest patch level applied) Solaris 2.7 UTF8 character set Symptoms -- Random hanging. Hanging meaning SQL processing stops. New connections hang. No traces files. No messages in the alert log. Killing the Oracle processes is the only way to recover from the problem. This problem has been reported to Oracle Support, they are now escalating it up. I just wanted to PING the list to see if anyone else has encountered this. TIA!!! Chris -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Grabowy, Chris 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). = Mohammed Shakir CompuSoft, Inc. 11 Heather Way East Brunswick, NJ 08816-2825 (732) 672-0464 (Cell) (732) 257-6001 (Home) __ Do You Yahoo!? Yahoo! Movies - coverage of the 74th Academy Awards® http://movies.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohammed Shakir 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: Sutton, Reed 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: Rebuilding Index Organised Tables (IOTs)
Well, you mentioned that there were bugs: but there are still some nasty bugs with online index rebuilds (which is what this actually does) so it might be safer not do use the option for an IOT. Thanks Kumanan -Original Message- From: Jonathan Lewis [SMTP:[EMAIL PROTECTED]] Sent: 21 March 2002 17:08 To: Multiple recipients of list ORACLE-L Subject: Re: Rebuilding Index Organised Tables (IOTs) 8.1.5 and 8.1.7 both support alter table iot_tab move for IOTs - is there a special bug in 8.1.6 ? Your own notes even describe this: |The move_table_clause rebuilds the index-organized table's primary |key index B*-tree. The overflow data segment is not rebuilt unless the |OVERFLOW keyword is explicitly stated, with two exceptions: Jonathan Lewis http://www.jlcomp.demon.co.uk Next Seminar - UK, April 3rd - 5th http://www.jlcomp.demon.co.uk/seminar.html Host to The Co-Operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html Author of: Practical Oracle 8i: Building Efficient Databases -Original Message- To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: 21 March 2002 16:17 |Many thanks to all of those people who advised. | |Unfortunately we are running on 8.1.6.3, so cannot do alter table move.. |as well :( |If you get any info, please let me know. | |Meanwhile, here are few bits that I gathered in IOTs. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jonathan Lewis 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: Automatically startup database
In fact, you need both: 1) set your oracleSID service to startup automatically; you need this in order to start Oracle process on NT automatically, but this is not enough to startup the database automatically, when oracle process starts. In order to do this, you need to: 2) set registry key ORA_sid_AUTOSTART to TRUE Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, March 21, 2002 12:18 PM - Original Message - How to make database instance on Win2K automatically startup when the PC up? it is specified in the windows registry check HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\HOME0 there should be entries named ORA_sid_AUTOSTART for each instance in this ORACLE_HOME (where *sid* is the SID of the instance) if u set the value for some ORA_sid_AUTOSTART to TRUE the respective instance should be started automatically note that this is the default behaviour of the Oracle installation (set autostart to true), so most probably the reason for your instance not being autostarted is different hth, Marin ...what you brought from your past, is of no use in your present. When you must choose a new path, do not bring old experiences with you. Those who strike out afresh, but who attempt to retain a little of the old life, end up torn apart by their own memories. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Marin Dimitrov 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: Igor Neyman 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: Rebuilding Index Organised Tables (IOTs)
Hi Jonathan, Even this may not be the case (in my opinion I could be mistaken, my respects for every one). As you know any index is made of branching blocks and leaf blocks. When we build an index, it's mainly to get rid of deleted rows/entries in the leaf blocks and reclaim that space. Also reorganize the branching blocks (index tree). The way I understand IOT it's made of PK index (ONLY THE BRANCHING BLOCKS PART) plugged into the table segment which could be considered as the leaf blocks. Moving the IOT will rebuild only the branching blocks or the tree part of the index. But the table segment or the leaf blocks will not be changed and will be moved as it's (including deleted entries) to the new place. Overflow is a different issue. Again any feedback and corrections will be appreciated. Unfortunately do not have time now to test what I said. Regards, Waleed -Original Message- Sent: Thursday, March 21, 2002 12:08 PM To: Multiple recipients of list ORACLE-L Correct, and apologies, it's too easy to give the quick and simple answer. If you want to rebuild the whole thing, without changing tablespaces, then: alter table iot_tab move overflow; You can't move the overflow with an online move, of course (except in Oracle 9, I expect). If you also have LOB columns you may have to add further details to make those move too, such as alter table iot_lob_tab move lob(my_lob) store as my_lob_seg; which would rebuild the index layer, overflow layer, and lobsegment layers. Jonathan Lewis http://www.jlcomp.demon.co.uk Next Seminar - UK, April 3rd - 5th http://www.jlcomp.demon.co.uk/seminar.html Host to The Co-Operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html Author of: Practical Oracle 8i: Building Efficient Databases -Original Message- To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: 20 March 2002 22:41 |It seems to me that alter table iot_table move -- just rebuilds the the |branching part of the index. |So if this is the case--- export import or create table iot as ... are |the best way to do the real job. | |Corrections and feedback are welcomed. | |Waleed | -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jonathan Lewis 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: Khedr, Waleed 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).
Accessing databases with different character sets
We are installing an engineering design application which has its own database and, in addition, needs to access the database of another application. Both are commercial applications where we do not have access to source code. Application A runs on NT and uses a character set of American.America.UTF8. Application B runs on AIX and uses a character set of American.America.US7ASCII. What character set should I specify in the registries of the client systems (NT) which run Application A? thanks, Peter Schauss Northrop Grumman Corporation 516-346-3148 [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Schauss, Peter 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: kill the procedure Call
Hi Rakesh,
Nice notes. However, you haven't mentioned the platform: The 'netstat'
command, the tcp parameters mentioned and their configuation vary quite
drastically across platforms. Was the original from a HP platform?
John Kanagaraj
-Original Message-
From: Rakesh Gupta [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 21, 2002 7:59 AM
To: Multiple recipients of list ORACLE-L
Subject: Re: kill the procedure Call
If you are using unix, you have to play with tcp kernel parameters.
We have tuned these parameters:
tcp_ip_abort_interval the time it takes for an existing
connection to be closed
tcp_ip_abort_cintervalthe expiration time for
establishing a new connection
tcp_time_wait_intervalthe length of time the server
holds a connection in a TIME-WAIT state after the end of the
connection
tcp_keepalive_intervalthe time period in which the
server will continue sending probes to determine whether a
connection is still active
tcp_conn_req_max_qthe maximum number of completed connections
tcp_conn_req_max_q0 the maximum number of connections with
handshake incomplete
Default values
Parameter Default Recommended
tcp_ip_abort_interval 480 (8 minutes) 6 (1 minute)
tcp_ip_abort_cinterval18 (3 minutes) 6 (1 minute)
tcp_time_wait_interval24 (8 minutes) 6 (1 minute)
tcp_keepalive_interval720 (2 hours) 90
(15 minutes)
tcp_conn_req_max_q128 256
tcp_conn_req_max_q0 10242048
The best way to determine whether or not a system is having
connection problems is to look at the output of the netstat
-an command. The netstat -a command displays the current
status of connections. With the addtional n option, the
command does not attempt to resolve IP addresses as host
names, both speeding up the output and making it more
predictable. The following netstat command gives a quick
summary of the number of TCP connections in each state.
bash-2.01# netstat -anP tcp | tail +5 | awk '{print $7}' |
sort | uniq -c
27 ESTABLISHED
6 IDLE
36 LISTEN
1 Remote - ignore this line
1 SYN_SENT
24 TIME_WAIT
For example, if you see a large number of connections in the
TIME_WAIT state, this may indicate that you need to reduce
your time wait interval (tcp_ip_time_wait_interval) to a
smaller value. If you find many sockets in the FIN_WAIT_2
state, your server is probably waiting for the final ACK from
the client before moving to close these connections.
Let me know if you need any more help and I will send you our
document which describes the procedures to set these parameters.
Thanks
Rakesh
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Rakesh Gupta
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: John Kanagaraj
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).
Sightly OT: Unix scripting
Environment: Oracle 8.1.6.3 on Solaris 5.8 I am not a Unix Guru by any strech of the imagination, so I can use all the help I can get. I am trying to write a shell script to execute sqlldr of a file whose name includes yesterday's 2 digit year and julian day in the format: file_yyjjj.csv. I can get today's date fine by setting a variable to be DATE=`date '+%y%j'` But when I try to get DATE -1 it strips the leading 0 (since it is currently 02). Does anyone have any suggestions as to how I can retain the leading 0 and still get yesterday's date? TIA, Terry Terry Ball, DBA Birch Telecom Work: 816-300-1335 FAX: 816-300-1801 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ball, Terry 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: strange tkprof output for SQLs - II
Hello Mogens, I saw this problem whether or not shared pool was flushed for PL/SQLs. Here are my observations for SQLs!!! and PL/SQLs: - Enabling sql trace from current session: When a cursor is closed after their child recursive statements, their recursive statistics parsed after the statement are included in parent's statistics. Recursive statements parsed before the statement are not included. - Enabling sql trace from other session after a while(after the parenet statement is parsed): Recursive statistics are not included in parent statement. But tkprof doesn't use exac values in raw trace file. If they are not included, why doesn't tkprof return exac values in raw trace files ? I'll debug tkprof if it calls Oracle's kernel function to see if tkprof is just a simple formatter or calculates something that I'm missing. I did not understand this is expected behavior or not. I would like to know statistics in raw trace files are inclusive or exclusive. I'm facing diffierent behaviors for this problem. I've opened an iTAR. thanks in advance... Mogens Nrgaard wrote: Danisment - isn't it always "alter system flush shard_pool"? I thought so... Danisment Gazi Unal (Unal Bilisim) wrote: >Hello, > >I did 2 tests for PL/SQL and SQL statements. This is the test for >SQL. > >Here are the steps: > >SQL > alter session flush shared_pool; >SQL > alter session set sql_trace=true; >SQL > insert into test select * from test; >SQL > alter session set sql_trace=false; > > >FROM DICTIONARY: > >SVRMGR> select >SQL_TEXT,DISK_READS,BUFFER_GETS,ROWS_PROCESSED,COMMAND_TYPE from v$sql >where sql_text like 'insert into test select * from test%'; > >SQL_TEXT DISK_READS BUFFER_GET ROWS_PROCE >COMMAND_TY >- -- -- -- >-- >insert into test select * from test 345 1014 >8192 2 >1 row selected. > > >FROM RAW TRACE FILE: > >PARSING IN CURSOR #1 len=36 dep=0 uid=5 oct=2 lid=5 tim=2795932206 >hv=895761708 ad='5083d50c' >insert into test select * from test >END OF STMT >PARSE #1:c=7,e=28,p=17,cr=42,cu=2,mis=1,r=0,dep=0,og=4,tim=2795932206 >. >other recursive statements. >. >. near end of file >EXEC >#1:c=28,e=258,p=328,cr=597,cu=373,mis=0,r=8192,dep=0,og=4,tim=2795932464 > > > >BUFFER GETS IN RAW TRACE FILE: >cr: 597 + 42 = 639 >cu: 373 + 2 = 375 > >Buffer gets = 639 + 375 = 1014, which is same as v$sql.BUFFER_GETS > > >DISK_READS IN RAW TRACE FILE: > >p: 17 + 328 = 345, which is same as v$sql.DISK_READS. > >According to these test, results in dictionary and raw trace files are >same. But tkprof formats as below: > > >insert into test select * from test > > >call count cpu elapsed disk query >current rows >--- -- -- -- -- -- >-- >Parse 1 0.00 0.02 17 42 >1 0 >Execute 1 0.12 1.86 91 126 >356 8192 >Fetch 0 0.00 0.00 0 0 >0 0 >--- -- -- -- -- -- >-- >total 2 0.12 1.88 108 168 >357 8192 > > >DISK_READS = 108 >BUFFER GETS = 168 + 357 = 525 > >Question: > >Which one is correct ? Dictionary/raw trace file or tkprof results ? > >My comment: > >I guess, tkprof substructs child recursive statements from parent user >statement ? Why ? This is not a PL/SQL statement ? So, statistics are >already not included in parent statement ? I guess statistics in raw >trace files are inclusive statistics which include statistics of their >child statements according to call orders of kernel calls. But is this >expected behavior. > >Thanks in advance... > >-- >Danisment Gazi Unal >http://www.unal-bilisim.com > > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mogens =?ISO-8859-1?Q?N=F8rgaard?= 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). -- Danisment Gazi Unal http://www.unal-bilisim.com
Re: More info on sql query running slow
I agree with /*+ORDERED */ hint suggestion (in combination with inline view). I've seen cases, when inline view itself didn't do the job, but along with /*+ORDERED */ hint proved to be a huge performance benefit. So, try: SELECT /*+ORDERED */ COUNT(a.phy_contract_id) FROM accrued_and_paid a, (select phy_contract_id from phy_contracts where company_id = 16 and contract_type = 'IC') b WHERE a.hold_payment_flag = 'Y' AND b.phy_contract_id = a.phy_contract_id; or, may be changing order of a and b. Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, March 20, 2002 2:50 PM [EMAIL PROTECTED] wrote: Steve, That query took about 52 seconds to run. Thanks Rick Stephane Faroult To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] sfaroult@oriolcc: ecorp.com Subject: RE: More info on sql query running slow Sent by: [EMAIL PROTECTED] m 03/20/2002 10:53 AM Please respond to ORACLE-L Rick, Curious to know how this would perform : SELECT COUNT(a.phy_contract_id) FROM accrued_and_paid a, (select phy_contract_id from phy_contracts where company_id = 16 and contract_type = 'IC') b WHERE a.hold_payment_flag = 'Y' AND b.phy_contract_id = a.phy_contract_id; - Original Message - From: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wed, 20 Mar 2002 05:58:25 Hi All, Oracle 8.1.6 I have 2 tables which have been analyzed. The query takes about 30+ seconds to run. If I run it many times it is faster as data gets loaded into buffer cache. I want to optimize when that is not the case. All the fields in the query have a separate index created EXCEPT for ACCRUED_AND_PAID.hold_payment_flag. Phy_Contracts has 10,466 rows. Accrued_and_Paid has 820,919 rows. Here is output from explain plan SELECT STATEMENT Cost = 1382 SORT AGGREGATE NESTED LOOPS TABLE ACCESS BY INDEX ROWID PHY_CONTRACTS INDEX RANGE SCAN PCON_CMPY_FK TABLE ACCESS BY INDEX ROWID ACCRUED_AND_PAID INDEX RANGE SCAN ADPD_PCON_FK Any ideas what I can do to speed this query. SELECT COUNT(a.phy_contract_id) FROM accrued_and_paid a, phy_contracts b WHEREa.hold_payment_flag = 'Y' AND b.phy_contract_id = a.phy_contract_id AND b.company_id = 16 AND b.contract_type = 'IC'; List of single column index on PHY_CONTRACTS INDEX_NAME COLUMN_NAME -- - PCON_CONTRACT_TYPE_IDXCONTRACT_TYPE PCON_CMPY_FK COMPANY_ID PCON_PKPHY_CONTRACT_ID List of single column index on ACCRUED_AND_PAID INDEX_NAME COLUMN_NAME -- -- ADPD_PCON_FK PHY_CONTRACT_ID Thanks Rick Yek. You should check the plan, there must be a full scan somewhere. I was hoping that the in-line view would be run first (assuming indices are efficient) and the the result used to pull the results from the other table. Two more things to try : 1) /*+ ORDERED */ and the in-line view first in the FROM clause 2) Not using an in-line view but a a.phy_contract_id in (select ..). In theory it shouldn't make any difference but the CBO has its mysterious ways sometimes. -- Regards, Stephane Faroult Oriole Ltd -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult 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: Igor Neyman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing
8.1.6
Hi, We are on 8.1.6.0.0 on NT 4.0 and want to apply patches which were fixed in 8.1.6.3.0. We just want to confirm which is the most stable patchset for 8.1.6 . We have feedback that 8.1.6.3.4 is stable and other group recommended 8.1.6.3.8. It will be great to have ur feedback with ur experience. Thanks --Harvinder -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Harvinder Singh 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: Sightly OT: Unix scripting
(all examples are using /usr/bin/ksh shell)
You could do it this way:
DATE=$(date '+%y%j')
DATE=$((${DATE} - 1))
[ ${#DATE} -eq 4 ] DATE=0${DATE}
But you have bigger problems my friend. What happens if the date is 02001
and you subtract 1. The result is 02000 which is invalid. Since you are
in a script that is using the db anyway why not do something like this:
{
sqlplus -s /nolog EOF
connect /
set pagesize 0
select to_char(sysdate - 1, 'YYDDD') from dual;
exit;
EOF
} | grep -iv connected | read DATE
Brian P. MacLean
Oracle DBA, OCP8i
Ball, Terry
[EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L
[EMAIL PROTECTED]
om cc:
Sent by: Subject: Sightly OT: Unix scripting
[EMAIL PROTECTED]
om
03/21/02 12:08
PM
Please respond
to ORACLE-L
Environment: Oracle 8.1.6.3 on Solaris 5.8
I am not a Unix Guru by any strech of the imagination, so I can use all the
help I can get. I am trying to write a shell script to execute sqlldr of a
file whose name includes yesterday's 2 digit year and julian day in the
format: file_yyjjj.csv. I can get today's date fine by setting a variable
to be DATE=`date '+%y%j'`
But when I try to get DATE -1 it strips the leading 0 (since it is
currently
02). Does anyone have any suggestions as to how I can retain the leading 0
and still get yesterday's date?
TIA,
Terry
Terry Ball, DBA
Birch Telecom
Work: 816-300-1335
FAX: 816-300-1801
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Ball, Terry
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: Sightly OT: Unix scripting
I'll show you one way to do it, if you quit calling that a Julian date. :)
( YYDDD is not a Julian date )
$ echo $DATE
2079
$ DATE=$(echo $DATE | awk '{ print substr($1,length($1)-4)
}')
$ echo $DATE
02079
Jared
Ball, Terry [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
03/21/02 11:08 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:Sightly OT: Unix scripting
Environment: Oracle 8.1.6.3 on Solaris 5.8
I am not a Unix Guru by any strech of the imagination, so I can use all
the
help I can get. I am trying to write a shell script to execute sqlldr of
a
file whose name includes yesterday's 2 digit year and julian day in the
format: file_yyjjj.csv. I can get today's date fine by setting a variable
to be DATE=`date '+%y%j'`
But when I try to get DATE -1 it strips the leading 0 (since it is
currently
02). Does anyone have any suggestions as to how I can retain the leading
0
and still get yesterday's date?
TIA,
Terry
Terry Ball, DBA
Birch Telecom
Work: 816-300-1335
FAX: 816-300-1801
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Ball, Terry
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: Error in procedure with dba_users
tKS David, that worked.
-Original Message-
From: [EMAIL PROTECTED] [EMAIL PROTECTED] on behalf of
[EMAIL PROTECTED] [EMAIL PROTECTED]
Sent: Thursday, March 21, 2002 12:14 PM
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject:Re: Error in procedure with dba_users
As SYS, grant select on DBA_USERS to SYSTEM. You're running a stored
procedure which requires explict grants, the DBA Role that SYSTEM has is
not sufficient.
David A. Barbour
Oracle DBA, OCP
AISD
512-414-1002
com.banilejas@code
tel.net.do To: Multiple recipients of list
ORACLE-L [EMAIL PROTECTED]
Sent by: cc:
[EMAIL PROTECTED] Subject: Error in procedure with
dba_users
03/21/2002 09:33
AM
Please respond to
ORACLE-L
Hi list,
I have this procedure under the system user, and when try to create it
I get an error
CREATE OR REPLACE PROCEDURE GENERAR_ESTADISTICAS AS
CURSOR ESQUEMAS IS
SELECT USERNAME ESQUEMA
FROM SYS.DBA_USERS
WHERE
USERNAME IN ('RAMON', 'SCOTT');
BEGIN
FOR E IN ESQUEMAS
LOOP
DBMS_UTILITY.ANALYZE_SCHEMA(E.ESQUEMA, 'COMPUTE');
END LOOP;
END;
3/8 PL/SQL: SQL Statement ignored
4/16 PLS-00201: identifier 'SYS.DBA_USERS' must be declared
11/4 PL/SQL: Statement ignored
11/32PLS-00364: loop index variable 'E' use is invalid
SQL
Any help .
TIA
Ramon E. Estevez
--
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:
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: Sightly OT: Unix scripting
Terry, I don't see a format like that in the unix date command formats, unfortunately. You may have to test the value and pad the number yourself. I have to do that in a number of my perl scripts. You are lucky you have Unix... Lisa Koivu Oracle Database Monkey. Fairfield Resorts, Inc. 954-935-4117 -Original Message- From: Ball, Terry [SMTP:[EMAIL PROTECTED]] Sent: Thursday, March 21, 2002 2:08 PM To: Multiple recipients of list ORACLE-L Subject: Sightly OT: Unix scripting Environment: Oracle 8.1.6.3 on Solaris 5.8 I am not a Unix Guru by any strech of the imagination, so I can use all the help I can get. I am trying to write a shell script to execute sqlldr of a file whose name includes yesterday's 2 digit year and julian day in the format: file_yyjjj.csv. I can get today's date fine by setting a variable to be DATE=`date '+%y%j'` But when I try to get DATE -1 it strips the leading 0 (since it is currently 02). Does anyone have any suggestions as to how I can retain the leading 0 and still get yesterday's date? TIA, Terry Terry Ball, DBA Birch Telecom Work: 816-300-1335 FAX: 816-300-1801 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ball, Terry 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: Koivu, Lisa 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).
refer to SYSDATE function in a CHECK constraint--doable?
Greetings all, I've got a table with a date field on a 8.1.6.0 db. I'd like to constrain the values entered into this field to be less than or equal to the date on which the record was entered. I figured a table-level check constraint would serve so I ran: ALTER TABLE TLB_COPIES ADD (CONSTRAINT TLBCPY_DATE_LAST_LABEL_CK CHECK (DATE_LAST_LABEL = SYSDATE) EXCEPTIONS INTO COMN_EXCEPTIONS) And Oracle complained thus: ADD (CONSTRAINT TLBCPY_DATE_LAST_LABEL_CK CHECK (DATE_LAST_LABEL = SYSDATE) * ERROR at line 2: ORA-02436: date or system variable wrongly specified in CHECK constraint I've also tried using TO_DATE(SYSDATE) after running accross that expression in some code examples in the docs (does SYSDATE not return a date type?), but get the same error. I've searched through metalink for this error, but everything I've found deals with how you've got to to_date() a date literal (e.g., no implicit conversions) and be sure to use a full four-digit year (as of 8.x I think). But I'm not seeing anything that refers to the sysdate function--is it just not allowed? I'm pretty sure you can use it as a DEFAULT... Thanks! -Roy Roy Pardee Programmer/Analyst SWFPAC Lockheed Martin IT Extension 8487 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Pardee, Roy E 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: Error in procedure with dba_users
Adary,
I am creating the procedure as system. I can select the table without no problem.
I changed to all_users and worked fine, but the dbms_utility doesn't work.
Below is an example.
TIA
Ramon.
CREATE OR REPLACE PROCEDURE GENERAR_ESTADISTICAS AS
CURSOR ESQUEMAS IS
SELECT USERNAME ESQUEMA
FROM ALL_USERS
WHERE
LENGTH(USERNAME = 3 AND
USERNAME != 'SYS';
BEGIN
FOR E IN ESQUEMAS
LOOP
INSERT INTO EJECUCION_PROCEDIMIENTOS
(PROCEDIMIENTO, FECHA_INICIO, FECHA_FIN, ESTATUS)
VALUES
('Generacion Estadisticas '||E.ESQUEMA,
TO_CHAR(SYSDATE, 'DD/MM/'),
NULL,
'Inicio');
--
EXECUTE (DBMS_UTILITY.ANALYZE_SCHEMA(E.ESQUEMA, 'COMPUTE'));
--
INSERT INTO EJECUCION_PROCEDIMIENTOS
(PROCEDIMIENTO, FECHA_INICIO, FECHA_FIN, ESTATUS)
VALUES
('Generacion Estadisticas '||E.ESQUEMA,
NULL,
TO_CHAR(SYSDATE, 'DD/MM/'),
'Finalizo');
END LOOP;
END;
/
SQL EXECUTE GENERAR_ESTADISTICAS
BEGIN GENERAR_ESTADISTICAS; END;
*
ERROR at line 1:
ORA-2: You have insufficient privileges for an object in this schema.
ORA-06512: at SYS.DBMS_UTILITY, line 258
ORA-06512: at SYSTEM.GENERAR_ESTADISTICAS, line 19
ORA-06512: at line 1
SQL EXECUTE DBMS_UTILITY.ANALYZE_SCHEMA('SCOTT', 'COMPUTE');
PL/SQL procedure successfully completed.
SQL sho user
USER is SYSTEM
-Original Message-
From: [EMAIL PROTECTED] [EMAIL PROTECTED] on behalf of ??? ?
[EMAIL PROTECTED]
Sent: Thursday, March 21, 2002 12:53 PM
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject:RE: Error in procedure with dba_users
Tested it.
You do not have permission for dba_users.
You need to have role select_catalog_role.
On 8.1.6.3.4 on NT.
Yechiel Adar, Mehish Computer Services
[EMAIL PROTECTED]
-Original Message-
From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
Sent: Thu, March 21, 2002 5:33 PM
To: Multiple recipients of list ORACLE-L
Subject: Error in procedure with dba_users
Hi list,
I have this procedure under the system user, and when try to create it
I get an error
CREATE OR REPLACE PROCEDURE GENERAR_ESTADISTICAS AS
CURSOR ESQUEMAS IS
SELECT USERNAME ESQUEMA
FROM SYS.DBA_USERS
WHERE
USERNAME IN ('RAMON', 'SCOTT');
BEGIN
FOR E IN ESQUEMAS
LOOP
DBMS_UTILITY.ANALYZE_SCHEMA(E.ESQUEMA, 'COMPUTE');
END LOOP;
END;
3/8 PL/SQL: SQL Statement ignored
4/16 PLS-00201: identifier 'SYS.DBA_USERS' must be declared
11/4 PL/SQL: Statement ignored
11/32PLS-00364: loop index variable 'E' use is invalid
SQL
Any help .
TIA
Ramon E. Estevez
--
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: =?iso-8859-8?Q?=E0=E3=F8_=E9=E7=E9=E0=EC?=
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: OT : Unix script to monitor log file size/disk space
Hi, What version of unix do you use ? I use this script on HP. If you want I can send it to you. Radim -Original Message- Ling Catherine (CSC) Sent: Wednesday, March 13, 2002 6:08 AM To: Multiple recipients of list ORACLE-L Hi Gurus, Does anyone have the unix script to monitor disk space or a certain file ? For example, if the disk space is more than 80%, send an email to the administrator or if the log file is too huge, email the log file to the administrator and truncate the file etc . Please help. Thanks. Regds, New Bee in Unix -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: CHAN Chor Ling Catherine (CSC) 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: Radim 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).
Java permissions
Could someone please tell me how to see the java permissions granted in the data dictionary from dbms_java.grant_permission, something similiar to dba_sys_privs, dba_role_privs, dba_tab_privs? Mike _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp. -- 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 hangs...Oracle 8.1.7.3 and Solaris 2.7
Oracle supports response to my answers was to increase SHMMAX from 128M to 4G and SEMMNS to 2000. Upping the semaphores seems like a good idea, but when I questioned why we should increase SHMMAX to more than 2x the real memory on the machine, the answer was I had my Unix Guru look at these and he recommended the parameters. A little less than what I was hoping for... At this point I am going to start launching my own investigation, from tips from you guys and research on Metalink, to try to find out what these processes are doing when the server is hung. Thanks again for all the help. Reed -Original Message- Sent: Thursday, March 21, 2002 12:51 PM To: Multiple recipients of list ORACLE-L Well, unfortunately we haven't solved the problem yet, so I don't have any solutions to share with everyone. We are using Sun hardware, and we have not run diagnostics on the memory. I don't want to dismiss that idea out of hand, but I don't understand how bad memory could be affecting only one of the three instances. There are two other 8.1.7.3 instances that run fine, never even a hiccup. The server has 2GB of memory. The application that uses this database (when its up) is connecting over the network, but when it hangs, you are unable to connect from a remote client or from on the server. I suggested to the support person handling our case that maybe we could try using some of the various oradebug options suggested by people on the list and suggested on Metalink, but he suggested looking at the following things first: This may be caused by a system resource problem. Was this DB relinked after the upgrade? It might help to get the initsid.ora's for all the instances What is the total size of each SGA? What is the value of the PROCESSES for each instance How much physical memory on the system? How much swap space? Type sysdef -i |grep SHMMAX Type sysdef -i |grep SEMMNS Still waiting for his reply to my answers... Thanks for all ideas you guys have shared. -Original Message- Sent: Wednesday, March 20, 2002 11:58 PM To: Multiple recipients of list ORACLE-L Please let us know how you fixed the problem. Are you using Sun Hardware? can you run diagnostics for the memory? Are you connecting using IPC(meaning direct) or through TCP(network)? Is it the network that is causing problem? --- Grabowy, Chris [EMAIL PROTECTED] wrote: We have a particular database that hangs on a regular basis. Here are the stats and symptoms. Oracle stats -- 8.1.7.3 (highest patch level applied) Solaris 2.7 UTF8 character set Symptoms -- Random hanging. Hanging meaning SQL processing stops. New connections hang. No traces files. No messages in the alert log. Killing the Oracle processes is the only way to recover from the problem. This problem has been reported to Oracle Support, they are now escalating it up. I just wanted to PING the list to see if anyone else has encountered this. TIA!!! Chris -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Grabowy, Chris 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). = Mohammed Shakir CompuSoft, Inc. 11 Heather Way East Brunswick, NJ 08816-2825 (732) 672-0464 (Cell) (732) 257-6001 (Home) __ Do You Yahoo!? Yahoo! Movies - coverage of the 74th Academy Awards® http://movies.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohammed Shakir 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: Sutton, Reed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To
Re: Error in procedure with dba_users
Well, I guess, it means exactly what it says in the error message:
user SYSTEM does not have sufficient privileges to analyze some schema
(selected in ESQUEMAS cursor).
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, March 21, 2002 4:13 PM
Adary,
I am creating the procedure as system. I can select the table without no
problem.
I changed to all_users and worked fine, but the dbms_utility doesn't work.
Below is an example.
TIA
Ramon.
CREATE OR REPLACE PROCEDURE GENERAR_ESTADISTICAS AS
CURSOR ESQUEMAS IS
SELECT USERNAME ESQUEMA
FROM ALL_USERS
WHERE
LENGTH(USERNAME = 3 AND
USERNAME != 'SYS';
BEGIN
FOR E IN ESQUEMAS
LOOP
INSERT INTO EJECUCION_PROCEDIMIENTOS
(PROCEDIMIENTO, FECHA_INICIO, FECHA_FIN, ESTATUS)
VALUES
('Generacion Estadisticas '||E.ESQUEMA,
TO_CHAR(SYSDATE, 'DD/MM/'),
NULL,
'Inicio');
--
EXECUTE (DBMS_UTILITY.ANALYZE_SCHEMA(E.ESQUEMA, 'COMPUTE'));
--
INSERT INTO EJECUCION_PROCEDIMIENTOS
(PROCEDIMIENTO, FECHA_INICIO, FECHA_FIN, ESTATUS)
VALUES
('Generacion Estadisticas '||E.ESQUEMA,
NULL,
TO_CHAR(SYSDATE, 'DD/MM/'),
'Finalizo');
END LOOP;
END;
/
SQL EXECUTE GENERAR_ESTADISTICAS
BEGIN GENERAR_ESTADISTICAS; END;
*
ERROR at line 1:
ORA-2: You have insufficient privileges for an object in this schema.
ORA-06512: at SYS.DBMS_UTILITY, line 258
ORA-06512: at SYSTEM.GENERAR_ESTADISTICAS, line 19
ORA-06512: at line 1
SQL EXECUTE DBMS_UTILITY.ANALYZE_SCHEMA('SCOTT', 'COMPUTE');
PL/SQL procedure successfully completed.
SQL sho user
USER is SYSTEM
-Original Message-
[EMAIL PROTECTED]
Sent: Thursday, March 21, 2002 12:53 PM
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Tested it.
You do not have permission for dba_users.
You need to have role select_catalog_role.
On 8.1.6.3.4 on NT.
Yechiel Adar, Mehish Computer Services
[EMAIL PROTECTED]
-Original Message-
From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
Sent: Thu, March 21, 2002 5:33 PM
To: Multiple recipients of list ORACLE-L
Subject: Error in procedure with dba_users
Hi list,
I have this procedure under the system user, and when try to create it
I get an error
CREATE OR REPLACE PROCEDURE GENERAR_ESTADISTICAS AS
CURSOR ESQUEMAS IS
SELECT USERNAME ESQUEMA
FROM SYS.DBA_USERS
WHERE
USERNAME IN ('RAMON', 'SCOTT');
BEGIN
FOR E IN ESQUEMAS
LOOP
DBMS_UTILITY.ANALYZE_SCHEMA(E.ESQUEMA, 'COMPUTE');
END LOOP;
END;
3/8 PL/SQL: SQL Statement ignored
4/16 PLS-00201: identifier 'SYS.DBA_USERS' must be declared
11/4 PL/SQL: Statement ignored
11/32PLS-00364: loop index variable 'E' use is invalid
SQL
Any help .
TIA
Ramon E. Estevez
--
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: =?iso-8859-8?Q?=E0=E3=F8_=E9=E7=E9=E0=EC?=
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: Igor Neyman
INET: [EMAIL PROTECTED]
Fat City
ORACLE 9i Database and Oracle9ias application
Hi If I want to install oracle 9i Database and oracle 9iAS on same box. Is it necessary to have diffrent home for both or same? If I use oracle as unix loginname for oracle9i database then can I use same unix loginname for Oracle 9iAS or not? Thx -Seema _ Chat with friends online, try MSN Messenger: http://messenger.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seema Singh 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: Intersystems Cache database
Yeah, like that ain't a plug from someone acting like an Oracle DBA. 1) No signature. 2) Generic e-mail account from a generic mail domain. 3) No recent posts to this list. Probably just a Cache salesman... Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- Sent: Thursday, March 21, 2002 3:23 PM To: Multiple recipients of list ORACLE-L Hi, Does anyone know about the Cache database? Is it REALLY that robust as they claim to be? http://cache.intersys.com/cache/fb/fb_03.html Thanks. -- 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: Error in procedure with dba_users
You could try GRANT ANALYZE ANY TO SYSTEM
I didn't want to do that, in case we upgraded via export/import, in which
case I might overlook that when SYSTEM got recreated, so I created a new DBA
user and granted it the same privs as SYSTEM, plus the one above. We use
this new account to do our DBMS_STATS work.
HTH! :)
Rich Jesse System/Database Administrator
[EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA
-Original Message-
Sent: Thursday, March 21, 2002 3:49 PM
To: Multiple recipients of list ORACLE-L
Well, I guess, it means exactly what it says in the error message:
user SYSTEM does not have sufficient privileges to analyze some schema
(selected in ESQUEMAS cursor).
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, March 21, 2002 4:13 PM
Adary,
I am creating the procedure as system. I can select the table without no
problem.
I changed to all_users and worked fine, but the dbms_utility doesn't work.
Below is an example.
TIA
Ramon.
CREATE OR REPLACE PROCEDURE GENERAR_ESTADISTICAS AS
CURSOR ESQUEMAS IS
SELECT USERNAME ESQUEMA
FROM ALL_USERS
WHERE
LENGTH(USERNAME = 3 AND
USERNAME != 'SYS';
BEGIN
FOR E IN ESQUEMAS
LOOP
INSERT INTO EJECUCION_PROCEDIMIENTOS
(PROCEDIMIENTO, FECHA_INICIO, FECHA_FIN, ESTATUS)
VALUES
('Generacion Estadisticas '||E.ESQUEMA,
TO_CHAR(SYSDATE, 'DD/MM/'),
NULL,
'Inicio');
--
EXECUTE (DBMS_UTILITY.ANALYZE_SCHEMA(E.ESQUEMA, 'COMPUTE'));
--
INSERT INTO EJECUCION_PROCEDIMIENTOS
(PROCEDIMIENTO, FECHA_INICIO, FECHA_FIN, ESTATUS)
VALUES
('Generacion Estadisticas '||E.ESQUEMA,
NULL,
TO_CHAR(SYSDATE, 'DD/MM/'),
'Finalizo');
END LOOP;
END;
/
SQL EXECUTE GENERAR_ESTADISTICAS
BEGIN GENERAR_ESTADISTICAS; END;
*
ERROR at line 1:
ORA-2: You have insufficient privileges for an object in this schema.
ORA-06512: at SYS.DBMS_UTILITY, line 258
ORA-06512: at SYSTEM.GENERAR_ESTADISTICAS, line 19
ORA-06512: at line 1
SQL EXECUTE DBMS_UTILITY.ANALYZE_SCHEMA('SCOTT', 'COMPUTE');
PL/SQL procedure successfully completed.
SQL sho user
USER is SYSTEM
-Original Message-
[EMAIL PROTECTED]
Sent: Thursday, March 21, 2002 12:53 PM
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Tested it.
You do not have permission for dba_users.
You need to have role select_catalog_role.
On 8.1.6.3.4 on NT.
Yechiel Adar, Mehish Computer Services
[EMAIL PROTECTED]
-Original Message-
From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
Sent: Thu, March 21, 2002 5:33 PM
To: Multiple recipients of list ORACLE-L
Subject: Error in procedure with dba_users
Hi list,
I have this procedure under the system user, and when try to create it
I get an error
CREATE OR REPLACE PROCEDURE GENERAR_ESTADISTICAS AS
CURSOR ESQUEMAS IS
SELECT USERNAME ESQUEMA
FROM SYS.DBA_USERS
WHERE
USERNAME IN ('RAMON', 'SCOTT');
BEGIN
FOR E IN ESQUEMAS
LOOP
DBMS_UTILITY.ANALYZE_SCHEMA(E.ESQUEMA, 'COMPUTE');
END LOOP;
END;
3/8 PL/SQL: SQL Statement ignored
4/16 PLS-00201: identifier 'SYS.DBA_USERS' must be declared
11/4 PL/SQL: Statement ignored
11/32PLS-00364: loop index variable 'E' use is invalid
SQL
Any help .
TIA
Ramon E. Estevez
--
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:RE: Intersystems Cache database
Anyone else ever hear about them? According to the web site that have '4 million users'. Seems that would have left a mark somewhere at that level. Dick Goulet Reply Separator Author: Jesse; Rich [EMAIL PROTECTED] Date: 3/21/2002 1:58 PM Yeah, like that ain't a plug from someone acting like an Oracle DBA. 1) No signature. 2) Generic e-mail account from a generic mail domain. 3) No recent posts to this list. Probably just a Cache salesman... Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- Sent: Thursday, March 21, 2002 3:23 PM To: Multiple recipients of list ORACLE-L Hi, Does anyone know about the Cache database? Is it REALLY that robust as they claim to be? http://cache.intersys.com/cache/fb/fb_03.html Thanks. -- 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: 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: Intersystems Cache database
Experience says that nothing is as robust as the marketing trolls would like you to believe. It is impressive add copy, though. Scott Shafer San Antonio, TX 210-581-6217 Common sense will not accomplish great things. Simply become insane and desperate. -Original Message- From: oracle dba [SMTP:[EMAIL PROTECTED]] Sent: Thursday, March 21, 2002 3:23 PM To: Multiple recipients of list ORACLE-L Subject: OT: Intersystems Cache database Hi, Does anyone know about the Cache database? Is it REALLY that robust as they claim to be? http://cache.intersys.com/cache/fb/fb_03.html Thanks. _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: oracle dba 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: Sightly OT: Unix scripting
Yes it's day-of-year. Some Unix doc's list it as Julian day-of-year.
Same difference...
Brian
Jared.Still@ra
disys.comTo: Multiple recipients of list ORACLE-L
[EMAIL PROTECTED]
Sent by: cc:
[EMAIL PROTECTED] Subject: Re: Sightly OT: Unix scripting
om
03/21/02 01:33
PM
Please respond
to ORACLE-L
I'll show you one way to do it, if you quit calling that a Julian date. :)
( YYDDD is not a Julian date )
$ echo $DATE
2079
$ DATE=$(echo $DATE | awk '{ print substr($1,length($1)-4)
}')
$ echo $DATE
02079
Jared
Ball, Terry [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
03/21/02 11:08 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:Sightly OT: Unix scripting
Environment: Oracle 8.1.6.3 on Solaris 5.8
I am not a Unix Guru by any strech of the imagination, so I can use all
the
help I can get. I am trying to write a shell script to execute sqlldr of
a
file whose name includes yesterday's 2 digit year and julian day in the
format: file_yyjjj.csv. I can get today's date fine by setting a variable
to be DATE=`date '+%y%j'`
But when I try to get DATE -1 it strips the leading 0 (since it is
currently
02). Does anyone have any suggestions as to how I can retain the leading
0
and still get yesterday's date?
TIA,
Terry
Terry Ball, DBA
Birch Telecom
Work: 816-300-1335
FAX: 816-300-1801
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Ball, Terry
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:
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 9i Database and Oracle9ias application
Seema Singh wrote: Hi If I want to install oracle 9i Database and oracle 9iAS on same box. Is it necessary to have diffrent home for both or same? use DIFFERENT home directories If I use oracle as unix loginname for oracle9i database then can I use same unix loginname for Oracle 9iAS or not? Yes, you can use oracle for both, but will need a way to change ORACLE_HOME. FWIW - I don't believe that all pieces of 9iAS are actually certified to run with 9i DB. -- 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: Oracle hangs...Oracle 8.1.7.3 and Solaris 2.7
Hello all, I think problem solving is an art. No one can know every solutions for every problems. If we don't use a methodical way, in other words if we use TEST-AND-SEE way, we waste our time. We should not jump into problem immediately. For your case: A- Problem: session/db hangs We don't know the problem yet. So, we can not talk about memory, IO, network etc. yet. We should not TEST the components one by one and SEE the results. If we don't know how to diagnose memory, what will happen ? or if problem is not related to memory what will happen ? wasting time. B- Identifiying the problem: Now, how will we identify the problem ? In your case, your session is hanging while connecting to db. Which phase: 1- Before handhaking with listener, Take sql*net client trace in level 16 and see 'err' postfix in the trace file. If there is no error message in trace, ignore this phase. 2- After handshaking is completed but before server process is created, Take listener trace in level 16. If there is no error ignore this phase. 3-after server process is created Take sql*net server trace for server process. If there is no error here, ignore this phase. sql*net trace files include OS specific errors too. So, They can give you some directions. Note: Trace files may not include any errors. Check if trace file includes wait-calls from next layer. I mean client requested a server port, but listener may not have returned a server port to client. If you don't see any problems in above steps, you should see that a server process is created. Now, debug this process by a debugger such as adb, dbx. You will see which Oracle's kernel functions are called. If debugger continues to write forever, that means process doesn't hang. If it repeats same kernel funcitons, most probably, it's endless loop. Also, you can dump process states. This can help what is happening there. According to Oracle's last kernel function, we can identify in which function Oracle hangs. You can also take truss,strace,trace output to see last OS call. Of course we can not write the fix, but at least we have an opportunity to identify the problem. regards... Sutton, Reed wrote: Oracle supports response to my answers was to increase SHMMAX from 128M to 4G and SEMMNS to 2000. Upping the semaphores seems like a good idea, but when I questioned why we should increase SHMMAX to more than 2x the real memory on the machine, the answer was I had my Unix Guru look at these and he recommended the parameters. A little less than what I was hoping for... At this point I am going to start launching my own investigation, from tips from you guys and research on Metalink, to try to find out what these processes are doing when the server is hung. Thanks again for all the help. Reed -Original Message- Sent: Thursday, March 21, 2002 12:51 PM To: Multiple recipients of list ORACLE-L Well, unfortunately we haven't solved the problem yet, so I don't have any solutions to share with everyone. We are using Sun hardware, and we have not run diagnostics on the memory. I don't want to dismiss that idea out of hand, but I don't understand how bad memory could be affecting only one of the three instances. There are two other 8.1.7.3 instances that run fine, never even a hiccup. The server has 2GB of memory. The application that uses this database (when its up) is connecting over the network, but when it hangs, you are unable to connect from a remote client or from on the server. I suggested to the support person handling our case that maybe we could try using some of the various oradebug options suggested by people on the list and suggested on Metalink, but he suggested looking at the following things first: This may be caused by a system resource problem. Was this DB relinked after the upgrade? It might help to get the initsid.ora's for all the instances What is the total size of each SGA? What is the value of the PROCESSES for each instance How much physical memory on the system? How much swap space? Type sysdef -i |grep SHMMAX Type sysdef -i |grep SEMMNS Still waiting for his reply to my answers... Thanks for all ideas you guys have shared. -Original Message- Sent: Wednesday, March 20, 2002 11:58 PM To: Multiple recipients of list ORACLE-L Please let us know how you fixed the problem. Are you using Sun Hardware? can you run diagnostics for the memory? Are you connecting using IPC(meaning direct) or through TCP(network)? Is it the network that is causing problem? --- Grabowy, Chris [EMAIL PROTECTED] wrote: We have a particular database that hangs on a regular basis. Here are the stats and symptoms. Oracle stats -- 8.1.7.3 (highest patch level applied) Solaris 2.7 UTF8 character set Symptoms -- Random hanging. Hanging meaning SQL processing stops. New connections hang. No traces
Oracle/SQL Server DBA Needed in Louisana
Fast Growing Company in the Lafayette, Louisana area (southern part of the state) needs an Oracle /SQL Server DBA. PLEASE DO NOT send your resume for this position UNLESS you already live in Louisana or a surrounding state and have the skills outlined below for this position. DO NOT send your resume unless you have a stable work history. Candidates whose work history includes frequent job changes connot be considered. If you are employed by a consulting company you must have a long term project history. This is a full time staff position so no sub-contractors or third parties please. No H-1B candidates please. Description: This database administrator will administer, develop and implement policies and procedures for for ensuring the integrity of the company database. He/she will implement data models, database designs, data access and table maintenance codes, resolve database performance issues, replication and other distributed data issues. Requirements: -3-5 years of Microsoft SQL and Oracle DBA experience. -Bachelor's Degree required . -Team player sought, team builder and adaptable person. -Will have to mentor others and assist as needed. -Will work with systems, marketing, and other departments. This comapny offers a Good salary and fantastic Benefits: Medical, Dental, paid time off, tuition reimbursement, 401K. *U.S. citizenship or green card holders only For immediate consideration, please send your resume as an attachment to: Email: [EMAIL PROTECTED] Please use job code: One/LaFayette/Oracle-SQL Server DBA/Leslie Phone: 800-549-8502 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: OraStaff 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: Intersystems Cache database
Haha very funny. From: Jesse, Rich [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: Intersystems Cache database Date: Thu, 21 Mar 2002 13:58:23 -0800 Yeah, like that ain't a plug from someone acting like an Oracle DBA. 1) No signature. 2) Generic e-mail account from a generic mail domain. 3) No recent posts to this list. Probably just a Cache salesman... Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- Sent: Thursday, March 21, 2002 3:23 PM To: Multiple recipients of list ORACLE-L Hi, Does anyone know about the Cache database? Is it REALLY that robust as they claim to be? http://cache.intersys.com/cache/fb/fb_03.html Thanks. -- 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). _ MSN Photos is the easiest way to share and print your photos: http://photos.msn.com/support/worldwide.aspx -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: oracle dba 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).
could not open the forms/reports on the web
I could not open the forms/reports on the web. When I try to run on the web, it asks me to 'open from current location/save to the disk'. Again when I select ''open from current location' it is not opening. Any suggestion is appreciable. I am using Form6i/Report6i against oracle 817 database and web 2.2 Installed in the order oradb817,forms6i/rep6i,web 2.2 on Win2000 prof. Thanks Ravi -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ravi R 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).
Raw device
Can anyone point me to a FM or explain me what is a raw device, and why not use simple file system instead. -- 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: RE: Intersystems Cache database
I've heard of them... Some guys at the last place I was at had used it as the back end for a lab results viewer at a hospital in the Boston area... They loved it... They kept telling me how great it was but I never saw it in action... I took most of it with a grain of salt since they were developers... As far as the 4 million users go... If you consider each hospital employee a user... Of better yet, each patient a user... :-) -Original Message- Sent: Thursday, March 21, 2002 5:19 PM To: Multiple recipients of list ORACLE-L Anyone else ever hear about them? According to the web site that have '4 million users'. Seems that would have left a mark somewhere at that level. Dick Goulet Reply Separator Author: Jesse; Rich [EMAIL PROTECTED] Date: 3/21/2002 1:58 PM Yeah, like that ain't a plug from someone acting like an Oracle DBA. 1) No signature. 2) Generic e-mail account from a generic mail domain. 3) No recent posts to this list. Probably just a Cache salesman... Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- Sent: Thursday, March 21, 2002 3:23 PM To: Multiple recipients of list ORACLE-L Hi, Does anyone know about the Cache database? Is it REALLY that robust as they claim to be? http://cache.intersys.com/cache/fb/fb_03.html Thanks. -- 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: 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: Johnston, Tim 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: Error in procedure with dba_users
Tks Jesse,
I like that solution, more than I worked it out.
tks
-Original Message-
From: [EMAIL PROTECTED] [EMAIL PROTECTED] on behalf of Jesse, Rich
[EMAIL PROTECTED]
Sent: Thursday, March 21, 2002 6:13 PM
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject:RE: Error in procedure with dba_users
You could try GRANT ANALYZE ANY TO SYSTEM
I didn't want to do that, in case we upgraded via export/import, in which
case I might overlook that when SYSTEM got recreated, so I created a new DBA
user and granted it the same privs as SYSTEM, plus the one above. We use
this new account to do our DBMS_STATS work.
HTH! :)
Rich Jesse System/Database Administrator
[EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA
-Original Message-
Sent: Thursday, March 21, 2002 3:49 PM
To: Multiple recipients of list ORACLE-L
Well, I guess, it means exactly what it says in the error message:
user SYSTEM does not have sufficient privileges to analyze some schema
(selected in ESQUEMAS cursor).
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, March 21, 2002 4:13 PM
Adary,
I am creating the procedure as system. I can select the table without no
problem.
I changed to all_users and worked fine, but the dbms_utility doesn't work.
Below is an example.
TIA
Ramon.
CREATE OR REPLACE PROCEDURE GENERAR_ESTADISTICAS AS
CURSOR ESQUEMAS IS
SELECT USERNAME ESQUEMA
FROM ALL_USERS
WHERE
LENGTH(USERNAME = 3 AND
USERNAME != 'SYS';
BEGIN
FOR E IN ESQUEMAS
LOOP
INSERT INTO EJECUCION_PROCEDIMIENTOS
(PROCEDIMIENTO, FECHA_INICIO, FECHA_FIN, ESTATUS)
VALUES
('Generacion Estadisticas '||E.ESQUEMA,
TO_CHAR(SYSDATE, 'DD/MM/'),
NULL,
'Inicio');
--
EXECUTE (DBMS_UTILITY.ANALYZE_SCHEMA(E.ESQUEMA, 'COMPUTE'));
--
INSERT INTO EJECUCION_PROCEDIMIENTOS
(PROCEDIMIENTO, FECHA_INICIO, FECHA_FIN, ESTATUS)
VALUES
('Generacion Estadisticas '||E.ESQUEMA,
NULL,
TO_CHAR(SYSDATE, 'DD/MM/'),
'Finalizo');
END LOOP;
END;
/
SQL EXECUTE GENERAR_ESTADISTICAS
BEGIN GENERAR_ESTADISTICAS; END;
*
ERROR at line 1:
ORA-2: You have insufficient privileges for an object in this schema.
ORA-06512: at SYS.DBMS_UTILITY, line 258
ORA-06512: at SYSTEM.GENERAR_ESTADISTICAS, line 19
ORA-06512: at line 1
SQL EXECUTE DBMS_UTILITY.ANALYZE_SCHEMA('SCOTT', 'COMPUTE');
PL/SQL procedure successfully completed.
SQL sho user
USER is SYSTEM
-Original Message-
[EMAIL PROTECTED]
Sent: Thursday, March 21, 2002 12:53 PM
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Tested it.
You do not have permission for dba_users.
You need to have role select_catalog_role.
On 8.1.6.3.4 on NT.
Yechiel Adar, Mehish Computer Services
[EMAIL PROTECTED]
-Original Message-
From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
Sent: Thu, March 21, 2002 5:33 PM
To: Multiple recipients of list ORACLE-L
Subject: Error in procedure with dba_users
Hi list,
I have this procedure under the system user, and when try to create it
I get an error
CREATE OR REPLACE PROCEDURE GENERAR_ESTADISTICAS AS
CURSOR ESQUEMAS IS
SELECT USERNAME ESQUEMA
FROM SYS.DBA_USERS
WHERE
USERNAME IN ('RAMON', 'SCOTT');
BEGIN
FOR E IN ESQUEMAS
LOOP
DBMS_UTILITY.ANALYZE_SCHEMA(E.ESQUEMA, 'COMPUTE');
END LOOP;
END;
3/8 PL/SQL: SQL Statement ignored
4/16 PLS-00201: identifier 'SYS.DBA_USERS' must be declared
11/4 PL/SQL: Statement ignored
11/32PLS-00364: loop index variable 'E' use is invalid
SQL
Any help .
TIA
Ramon E. Estevez
--
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:
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
Re: Error in procedure with dba_users
I also created a user for this, but with privs: create session,
select_catalog_role, and analyze any. Haven't found a reason (yet) to
grant DBA or any other privs. However I'm not yet using DBMS_STATS,
maybe that requires more(?)
Jesse, Rich wrote:
You could try GRANT ANALYZE ANY TO SYSTEM
I didn't want to do that, in case we upgraded via export/import, in which
case I might overlook that when SYSTEM got recreated, so I created a new DBA
user and granted it the same privs as SYSTEM, plus the one above. We use
this new account to do our DBMS_STATS work.
HTH! :)
Rich Jesse System/Database Administrator
[EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA
-Original Message-
Sent: Thursday, March 21, 2002 3:49 PM
To: Multiple recipients of list ORACLE-L
Well, I guess, it means exactly what it says in the error message:
user SYSTEM does not have sufficient privileges to analyze some schema
(selected in ESQUEMAS cursor).
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, March 21, 2002 4:13 PM
Adary,
I am creating the procedure as system. I can select the table without no
problem.
I changed to all_users and worked fine, but the dbms_utility doesn't work.
Below is an example.
TIA
Ramon.
CREATE OR REPLACE PROCEDURE GENERAR_ESTADISTICAS AS
CURSOR ESQUEMAS IS
SELECT USERNAME ESQUEMA
FROM ALL_USERS
WHERE
LENGTH(USERNAME = 3 AND
USERNAME != 'SYS';
BEGIN
FOR E IN ESQUEMAS
LOOP
INSERT INTO EJECUCION_PROCEDIMIENTOS
(PROCEDIMIENTO, FECHA_INICIO, FECHA_FIN, ESTATUS)
VALUES
('Generacion Estadisticas '||E.ESQUEMA,
TO_CHAR(SYSDATE, 'DD/MM/'),
NULL,
'Inicio');
--
EXECUTE (DBMS_UTILITY.ANALYZE_SCHEMA(E.ESQUEMA, 'COMPUTE'));
--
INSERT INTO EJECUCION_PROCEDIMIENTOS
(PROCEDIMIENTO, FECHA_INICIO, FECHA_FIN, ESTATUS)
VALUES
('Generacion Estadisticas '||E.ESQUEMA,
NULL,
TO_CHAR(SYSDATE, 'DD/MM/'),
'Finalizo');
END LOOP;
END;
/
SQL EXECUTE GENERAR_ESTADISTICAS
BEGIN GENERAR_ESTADISTICAS; END;
*
ERROR at line 1:
ORA-2: You have insufficient privileges for an object in this schema.
ORA-06512: at SYS.DBMS_UTILITY, line 258
ORA-06512: at SYSTEM.GENERAR_ESTADISTICAS, line 19
ORA-06512: at line 1
SQL EXECUTE DBMS_UTILITY.ANALYZE_SCHEMA('SCOTT', 'COMPUTE');
PL/SQL procedure successfully completed.
SQL sho user
USER is SYSTEM
-Original Message-
[EMAIL PROTECTED]
Sent: Thursday, March 21, 2002 12:53 PM
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Tested it.
You do not have permission for dba_users.
You need to have role select_catalog_role.
On 8.1.6.3.4 on NT.
Yechiel Adar, Mehish Computer Services
[EMAIL PROTECTED]
-Original Message-
From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
Sent: Thu, March 21, 2002 5:33 PM
To: Multiple recipients of list ORACLE-L
Subject: Error in procedure with dba_users
Hi list,
I have this procedure under the system user, and when try to create it
I get an error
CREATE OR REPLACE PROCEDURE GENERAR_ESTADISTICAS AS
CURSOR ESQUEMAS IS
SELECT USERNAME ESQUEMA
FROM SYS.DBA_USERS
WHERE
USERNAME IN ('RAMON', 'SCOTT');
BEGIN
FOR E IN ESQUEMAS
LOOP
DBMS_UTILITY.ANALYZE_SCHEMA(E.ESQUEMA, 'COMPUTE');
END LOOP;
END;
3/8 PL/SQL: SQL Statement ignored
4/16 PLS-00201: identifier 'SYS.DBA_USERS' must be declared
11/4 PL/SQL: Statement ignored
11/32PLS-00364: loop index variable 'E' use is invalid
SQL
Any help .
TIA
Ramon E. Estevez
--
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: Suzy Vordos
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
RE: OT : Unix script to monitor log file size/disk space
Hi Radim, We are using Sun Solaris Version 2.6 right now. By this weekend, we'll be upgrading our OS to Version 2.8. I am very interested in your script. Could U send your scripts to me? Thank you so much. Regds, New Bee -Original Message- From: Radim J. [mailto:[EMAIL PROTECTED]] Sent: Friday, March 22, 2002 5:13 AM To: Multiple recipients of list ORACLE-L Subject:RE: OT : Unix script to monitor log file size/disk space Hi, What version of unix do you use ? I use this script on HP. If you want I can send it to you. Radim -Original Message- Ling Catherine (CSC) Sent: Wednesday, March 13, 2002 6:08 AM To: Multiple recipients of list ORACLE-L Hi Gurus, Does anyone have the unix script to monitor disk space or a certain file ? For example, if the disk space is more than 80%, send an email to the administrator or if the log file is too huge, email the log file to the administrator and truncate the file etc . Please help. Thanks. Regds, New Bee in Unix -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: CHAN Chor Ling Catherine (CSC) 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: Radim 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: CHAN Chor Ling Catherine (CSC) 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: Intersystems Cache database
Hospital is the key. Cache was originally developed in the '70 for use in medical applications, of course, back then it was known as MUMPS before the PR guys got a hold of it. The UNIX types will tell you that any app that has been around for three decades has to have something going for it. Some of the DBAs around hear played with it, and were not impressed. Apparently recovery in the event of any failure was a nightmare. -Original Message- Sent: Thursday, March 21, 2002 5:14 PM To: Multiple recipients of list ORACLE-L I've heard of them... Some guys at the last place I was at had used it as the back end for a lab results viewer at a hospital in the Boston area... They loved it... They kept telling me how great it was but I never saw it in action... I took most of it with a grain of salt since they were developers... As far as the 4 million users go... If you consider each hospital employee a user... Of better yet, each patient a user... :-) -Original Message- Sent: Thursday, March 21, 2002 5:19 PM To: Multiple recipients of list ORACLE-L Anyone else ever hear about them? According to the web site that have '4 million users'. Seems that would have left a mark somewhere at that level. Dick Goulet Reply Separator Author: Jesse; Rich [EMAIL PROTECTED] Date: 3/21/2002 1:58 PM Yeah, like that ain't a plug from someone acting like an Oracle DBA. 1) No signature. 2) Generic e-mail account from a generic mail domain. 3) No recent posts to this list. Probably just a Cache salesman... Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- Sent: Thursday, March 21, 2002 3:23 PM To: Multiple recipients of list ORACLE-L Hi, Does anyone know about the Cache database? Is it REALLY that robust as they claim to be? http://cache.intersys.com/cache/fb/fb_03.html Thanks. -- 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: 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: Johnston, Tim 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: Norrell, Brian 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).
diag.cmd script
Something strange has happened. This utility, supplied with iAS to test portals, tells me there may be something wrong with my portal. In fact, it can't find the server name for the portal. Meanwhile we can access the portal no problem from a Web browser. I logged a TAR with Oracle to ask them about this little utility that tests portals... Regards, 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).
Remote DB Installation
I have a possible opportunity to install an Oracle DB (8i or 9i) for a companylocated in Central America. I am located in the Minneapolis / St. Paul, MN area. What tools would I need to install this remotely from MN? The server would probably be Sun or HP unix. Thanks, Ken Janusz, CPIM
Re: diag.cmd script
Patrice,
That you're running diag.cmd and not diag.csh, I assume you are on NT.
What version of iAS and Portal are you using.
I have used diag.csh (on Solaris, iAS 1.0.2.2, Portal 3.0.9) when we had
issues
cloning a portal environment some months ago and had learnt to ignore some
messages. Could you post the output that you're getting when running the
diag
command ?
Hemant K Chitale
Principal DBA
Chartered Semiconductor Manufacturing Ltd
Boivin, Patrice J [EMAIL PROTECTED]22/03/2002 10:18 AM
Sent by: [EMAIL PROTECTED]
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc: (bcc: CHITALE Hemant Krishnarao/IT/CHRT/ST Group)
Subject: diag.cmd script
Something strange has happened.
This utility, supplied with iAS to test portals, tells me there may be
something wrong with my portal.
In fact, it can't find the server name for the portal.
Meanwhile we can access the portal no problem from a Web browser. I logged
a TAR with Oracle to ask them about this little utility that tests
portals...
Regards,
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).
[This e-mail is confidential and may also be privileged. If you are not the
intended recipient, please delete it and notify us immediately; you should
not copy or use it for any purpose, nor disclose its contents to any other
person. Thank you.]åy« ±ç
ê ~'jS Ä,PÛiÿü0ÂÚ}ª¢`.¶+ Ñ
é×!Ö¥yÈZ®×«yÛ '(V
+r5ëp¢¹z»âqëçÎwó9ÔPó9ßÎtçT8'è®xæåÂ'µêçzÖqë,üÆ¢)à.+-±:Ã*.®Ç¥}úèØb²f¢)à+-±éÝjq
+ j)fzËëh.+-êî}«\Ü¢ièµá $ì¥éex(|¸¬´k«¹©Ý{azg¬±¨ àØw%¹×)Þríj)â
+I@ND º+¶§jg¨~f¢)à+-Ê°j{m¡·«zj/y×ë¢f(ºf²j[(±éݶ³Ü¢i×è®az¸§~æjبX¤z˱Êân)à
Re: ORACLE 9i Database and Oracle9ias application
Actually, there are a number of InterOperability patches for 9iAS 1.0.2.2 with the 9iDB. I'm only running 9iAS 1.0.2.2 against 8.1.7 yet. BTW, if you check the Certification Matrix on Metalink, do not select the product Application Server (9iAS) This contains incomplete certification for 9iAS 9.0.2 on Solaris. Select Internet Products and then Oracle9i Application Server Enterprise Edition Quoting the certification : Oracle9iAS Rel1 (V1.0.2.2.x) is certified to run against a Oracle9i Database 9.0.1 (on all supported platforms) in RAC configuration. 9iAS 1.0.2.2 can run against any certified 9.0.1 (9i) backend database, with exceptions and limitations: Oracle9iAS Database Cache and Oracle Enterprise Manager functionality are NOT supported in this configuration. In order to run in this configuration, Oracle9iAS Forms Services users should apply Oracle Forms Patch 5. Oracle9iAS Portal - Apply patches for bugs1794996 and 1806057. Apply workaround (07_DICTIONARY_ACCESSIBILITY =true) for bug 1554423 Users connecting from Oracle9iAS v1022 to Oracle9i database through jdbc thin drivers - Apply patch for bug 1725012 9iAS Wireless, J2EE (OC4J), iFS, Unified Messaging and eMail Server are, surpringly, listed seperately in the certification. Hemant K Chitale Principal DBA Chartered Semiconductor Manufacturing Ltd Charlie Mengler [EMAIL PROTECTED] 22/03/2002 06:23 AM Sent by: [EMAIL PROTECTED] Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: (bcc: CHITALE Hemant Krishnarao/IT/CHRT/ST Group) Subject: Re: ORACLE 9i Database and Oracle9ias application Seema Singh wrote: Hi If I want to install oracle 9i Database and oracle 9iAS on same box. Is it necessary to have diffrent home for both or same? use DIFFERENT home directories If I use oracle as unix loginname for oracle9i database then can I use same unix loginname for Oracle 9iAS or not? Yes, you can use oracle for both, but will need a way to change ORACLE_HOME. FWIW - I don't believe that all pieces of 9iAS are actually certified to run with 9i DB. -- 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). [This e-mail is confidential and may also be privileged. If you are not the intended recipient, please delete it and notify us immediately; you should not copy or use it for any purpose, nor disclose its contents to any other person. Thank you.] -- 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: Accessing databases with different character sets
Hi use should use American.America.UTF8. in the client configuration Ayyapps This communication contains information, which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s), please note that any distribution, printing, copying or use of this communication or the information in it is strictly prohibited. If you have received this communication in error, please notify the sender immediately and then destroy any copies of it. Visit us @ www.ssiworldwide.com -- 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: refer to SYSDATE function in a CHECK constraint--doable?
HI Roy, As you have already figured out sysdate cannot be used in a constraint. John [EMAIL PROTECTED] wrote: Greetings all, I've got a table with a date field on a 8.1.6.0 db. I'd like to constrain the values entered into this field to be less than or equal to the date on which the record was entered. I figured a table-level check constraint would serve so I ran: ALTER TABLE TLB_COPIES ADD (CONSTRAINT TLBCPY_DATE_LAST_LABEL_CK CHECK (DATE_LAST_LABEL = SYSDATE) EXCEPTIONS INTO COMN_EXCEPTIONS) And Oracle complained thus: ADD (CONSTRAINT TLBCPY_DATE_LAST_LABEL_CK CHECK (DATE_LAST_LABEL = SYSDATE) * ERROR at line 2: ORA-02436: date or system variable wrongly specified in CHECK constraint I've also tried using TO_DATE(SYSDATE) after running accross that expression in some code examples in the docs (does SYSDATE not return a date type?), but get the same error. I've searched through metalink for this error, but everything I've found deals with how you've got to to_date() a date literal (e.g., no implicit conversions) and be sure to use a full four-digit year (as of 8.x I think). But I'm not seeing anything that refers to the sysdate function--is it just not allowed? I'm pretty sure you can use it as a DEFAULT... Thanks! -Roy Roy Pardee Programmer/Analyst SWFPAC Lockheed Martin IT Extension 8487 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ora NT DBA 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: Remote DB Installation
You need to establish a telnet or ssh connection to the remote server. That's all you need. -Original Message-From: KENNETH JANUSZ [mailto:[EMAIL PROTECTED]]Sent: Friday, 22 March 2002 2:33 PMTo: Multiple recipients of list ORACLE-LSubject: Remote DB Installation I have a possible opportunity to install an Oracle DB (8i or 9i) for a companylocated in Central America. I am located in the Minneapolis / St. Paul, MN area. What tools would I need to install this remotely from MN? The server would probably be Sun or HP unix. Thanks, Ken Janusz, CPIM
Re: Remote DB Installation
Just a few options - I'm sure there are others that I haven't listed: 1) VNC from ATT Labs http://www.uk.research.att.com/vnc/ VNC needs to be installed on client and server. 2) (method I use for Unix/Linux remote installs) SSH w/ X11 tunneling You'll need a local X Server - either buy one that runs on Windows (not sure if any free ones still exist), or I use my Linux machine with XFree86. See ssh docs for details on ssh tunneling. -Joe --- KENNETH JANUSZ [EMAIL PROTECTED] wrote: I have a possible opportunity to install an Oracle DB (8i or 9i) for a company located in Central America. I am located in the Minneapolis / St. Paul, MN area. What tools would I need to install this remotely from MN? The server would probably be Sun or HP unix. Thanks, Ken Janusz, CPIM __ Do You Yahoo!? Yahoo! Movies - coverage of the 74th Academy Awards® http://movies.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Raube 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: Remote DB Installation
Sorry I was too quick in sending. With the telnet, you need some sort of X windows application - liek Reflection X or XWin or something like that. The Oracle Installator will work via this. -Original Message-From: Sujatha Madan [mailto:[EMAIL PROTECTED]]Sent: Friday, 22 March 2002 3:08 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Remote DB Installation You need to establish a telnet or ssh connection to the remote server. That's all you need. -Original Message-From: KENNETH JANUSZ [mailto:[EMAIL PROTECTED]]Sent: Friday, 22 March 2002 2:33 PMTo: Multiple recipients of list ORACLE-LSubject: Remote DB Installation I have a possible opportunity to install an Oracle DB (8i or 9i) for a companylocated in Central America. I am located in the Minneapolis / St. Paul, MN area. What tools would I need to install this remotely from MN? The server would probably be Sun or HP unix. Thanks, Ken Janusz, CPIM
