role/priv. reqd to create/support a management server repository
guys, i am on 8.1.6/w2k. i tried to create a new server management repository using Enterprise Manager configuration assistant.this is first time i am going to use EM on this machine.but when i gave a usename/pwd during repository login informationi got the error : SELECTED USER LACKS ONE OR MORE OF THE PRIVILEGES OR ROLES REQUIRED TO CREATE AND SUPPORT A MANAGEMENT SERVER REPOSITORY. i have granted dba,sysdba,sysoper privs to that user. what priv/role should be granted to create/support a management server repository ? kindly let me know guys. TIA. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: oraora oraora INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Speeding up LIKE '%something%'
Carle, William T (Bill), ALCAS wrote: Howdy, I have a table that has almost 2 million rows called eventqueueentry. The layout looks like this: Name Null?Type - EVENTID NOT NULL NUMBER(10) VER NOT NULL NUMBER(10) QUEUETYPE NOT NULL CHAR(16) PUBLISHER NOT NULL CHAR(16) CREATETIMENOT NULL DATE LASTREADTIME DATE REMOVETIME DATE CONTENTS NOT NULL VARCHAR2(4000) The users do a query that looks like this: SELECT EventId, QueueType, Publisher, CreateTime, LastReadTime, RemoveTime, Contents, Ver from EventQueueEntry where QueueType = 'CodeUpdate' AND Contents LIKE '%TrackingEventId=27668677%' ORDER BY EventId The queuetype field has only 3 different values. The value in the contents field is close to being unique (high cardinality) but, as you can see, they are picking off a value somewhere in the middle of a varchar2(4000) field. Understandably, their query is slow. Is there anything I can do with an index to speed this up? Bill Carle ATT Database Administrator 816-995-3922 [EMAIL PROTECTED] I think that if it's 'TrackingEventId' which REALLY interests your users (as opposed to any random string of characters within CONTENTS) you should train your users into expressing their query as something similar to to_number(substr(CONTENTS, decode(instr(CONTENTS, 'TrackingEventId='), 0, length(CONTENTS), instr(CONTENTS, 'TrackingEventId=')+16), 8)) = 27668677 (I do *not* guarantee the number of parentheses :) and I assume that the number is always 8-digit long - adapt). This nice expression would allow you to create a function based index. In fact, you could then create a view above the table which would directly include a TRACKINGEVENTID column defined as above, and, assuming the FBI, your users could query : SELECT EventId, QueueType, Publisher, CreateTime, LastReadTime, RemoveTime, Contents, Ver from V_EventQueueEntry where QueueType = 'CodeUpdate' AND TrackingEventId=27668677 ORDER BY EventId Another solution would be to add a column, and extract the information as it is inserted (trigger) to fill the column - which you would of course index. If many different chunks of CONTENTS can be queried, I would consider Intermedia. -- Regards, Stephane Faroult Oriole Software - End Forwarded Message - Regards, Stephane Faroult Oriole -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroul INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Can I index this query?
You could always consider something like OracleText to assist with these kind of searches, but thats a big step.. hth connor --- Carle, William T (Bill), ALCAS [EMAIL PROTECTED] wrote: Howdy, I have a table that has almost 2 million rows called eventqueueentry. The layout looks like this: Name Null? Type - EVENTID NOT NULL NUMBER(10) VER NOT NULL NUMBER(10) QUEUETYPE NOT NULL CHAR(16) PUBLISHER NOT NULL CHAR(16) CREATETIMENOT NULL DATE LASTREADTIME DATE REMOVETIME DATE CONTENTS NOT NULL VARCHAR2(4000) The users do a query that looks like this: SELECT EventId, QueueType, Publisher, CreateTime, LastReadTime, RemoveTime, Contents, Ver from EventQueueEntry where QueueType = 'CodeUpdate' AND Contents LIKE '%TrackingEventId=27668677%' ORDER BY EventId The queuetype field has only 3 different values. The value in the contents field is close to being unique (high cardinality) but, as you can see, they are picking off a value somewhere in the middle of a varchar2(4000) field. Understandably, their query is slow. Is there anything I can do with an index to speed this up? Bill Carle ATT Database Administrator 816-995-3922 [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Carle, William T (Bill), ALCAS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Connor McDonald http://www.oracledba.co.uk http://www.oaktable.net Remember amateurs built the ark - Professionals built the Titanic __ 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 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Help on resolving block number and file number from 10046 trace to table or index
This is a known oversight...I haven't verified this, but I've read that you can use the 8.1.6+ one, or the 9.2 one if you've got it handy. In the 8.1 case, the timings may be a little off due to the change in precision hth connor --- Grant Allen [EMAIL PROTECTED] wrote: Hi all, For some reason my 9.0.1 windows install has no tkprof binary, so I'm trying to decipher some 10046 output. I've got a bunch of WAIT #1: nam='db file sequential read' ela= 6467 p1=7 p2=219340 p3=1 For this event, p1 is the file, and p2 is the block. Any ideas on how to track down what object this is (i.e. table, index or whatever)? thanks Fuzzy :-) -- Woo Hoo! - H. Simpson -- The contents of this post are my opinions only If swallowed seek medical advice (Apologies for the excess signature) This email message (and attachments) may contain information confidential to TOWER Software. If you are not the intended recipient you cannot use, distribute or copy the message or message attachments. If you are not the intended recipient, please notify the sender by return email immediately and delete all copies of the message and attachments. Opinions, conclusions and other information in this message and attachments that do not relate to the official business of TOWER Software, are not given or endorsed by it. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Grant Allen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Connor McDonald http://www.oracledba.co.uk http://www.oaktable.net Remember amateurs built the ark - Professionals built the Titanic __ 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 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Any way to see the currently running SQL in one session.
Hi, Please try the following script in SQL*Plus: select sql_text from v$sqltext where address = (select sql_address from v$session where sid = sid) order by piece; This will prompt you for the session_id for which you want to see the current running statement. Regards, CJ -Original Message- Sent: Wednesday, October 16, 2002 1:40 AM To: Multiple recipients of list ORACLE-L Dear ALL, Is there any way to see the currently running SQL in one session? I used v$open_cursor, but there might be many SQL statements, I don't know which one is currently running. And more, if I execute a stored procedure, which SQL statements could be seen in v$open_cursor? Any clues would be much appreciated. TIA Chuan * Disclaimer This message (including any attachments) contains confidential information intended for a specific individual and purpose, and is protected by law. If you are not the intended recipient, you should delete this message and are hereby notified that any disclosure, copying, or distribution of this message, or the taking of any action based on it, is strictly prohibited. * Visit us at http://www.mahindrabt.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Charu Joshi INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Connections with WebLogic (5.1) and Oracle 8.1.7 on Solaris
Hi all, we are facing strange problems with our environment. we are using weblogic and solaris8 with 8.1.7.3. It seems that somehow amount of cumulative connections is getting extremely high and it seems that WL is doing db connection each time user clicks the aplication. Is there any parameter on oracle side causing this. We have tested this with two similar environment and other seems to work ok and other does generate these connections but we do not find any reason for the different behaviour... Any ideas... Rgds, Joshua _ Gratis e-mail resten av livet på www.yahoo.se/mail Busenkelt! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Joshua=20Becker?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Speeding up LIKE '%something%'
Seems to me there may be a case for a little normalisation here - do I understand the field 'contents' to include aggregates of various data attributes? Oh dear... Although a functional index would probably help, it is simply masking a major design flaw. Get that corrected, and the basic integrity of the data improves straight away. peter edinburgh -Original Message- From: Stephane Faroult [mailto:[EMAIL PROTECTED]] Sent: 16 October 2002 09:29 To: Multiple recipients of list ORACLE-L Subject: Speeding up LIKE '%something%' Carle, William T (Bill), ALCAS wrote: Howdy, I have a table that has almost 2 million rows called eventqueueentry. The layout looks like this: Name Null?Type - EVENTID NOT NULL NUMBER(10) VER NOT NULL NUMBER(10) QUEUETYPE NOT NULL CHAR(16) PUBLISHER NOT NULL CHAR(16) CREATETIMENOT NULL DATE LASTREADTIME DATE REMOVETIME DATE CONTENTS NOT NULL VARCHAR2(4000) The users do a query that looks like this: SELECT EventId, QueueType, Publisher, CreateTime, LastReadTime, RemoveTime, Contents, Ver from EventQueueEntry where QueueType = 'CodeUpdate' AND Contents LIKE '%TrackingEventId=27668677%' ORDER BY EventId The queuetype field has only 3 different values. The value in the contents field is close to being unique (high cardinality) but, as you can see, they are picking off a value somewhere in the middle of a varchar2(4000) field. Understandably, their query is slow. Is there anything I can do with an index to speed this up? Bill Carle ATT Database Administrator 816-995-3922 [EMAIL PROTECTED] I think that if it's 'TrackingEventId' which REALLY interests your users (as opposed to any random string of characters within CONTENTS) you should train your users into expressing their query as something similar to to_number(substr(CONTENTS, decode(instr(CONTENTS, 'TrackingEventId='), 0, length(CONTENTS), instr(CONTENTS, 'TrackingEventId=')+16), 8)) = 27668677 (I do *not* guarantee the number of parentheses :) and I assume that the number is always 8-digit long - adapt). This nice expression would allow you to create a function based index. In fact, you could then create a view above the table which would directly include a TRACKINGEVENTID column defined as above, and, assuming the FBI, your users could query : SELECT EventId, QueueType, Publisher, CreateTime, LastReadTime, RemoveTime, Contents, Ver from V_EventQueueEntry where QueueType = 'CodeUpdate' AND TrackingEventId=27668677 ORDER BY EventId Another solution would be to add a column, and extract the information as it is inserted (trigger) to fill the column - which you would of course index. If many different chunks of CONTENTS can be queried, I would consider Intermedia. -- Regards, Stephane Faroult Oriole Software - End Forwarded Message - Regards, Stephane Faroult Oriole -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroul INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). * This e-mail message, and any files transmitted with it, are confidential and intended solely for the use of the addressee. If this message was not addressed to you, you have received it in error and any copying, distribution or other use of any part of it is strictly prohibited. Any views or opinions presented are solely those of the sender and do not necessarily represent those of the British Geological Survey. The security of e-mail communication cannot be guaranteed and the BGS accepts no liability for claims arising as a result of the use of this medium to transmit messages from or to the BGS. The BGS cannot accept any responsibility for viruses, so please scan all attachments.
Re: Can I index this query?
Hi, Atleast you can do one thing if you are having Oracle Pratitioning then just partition it on the QueueType field provided you are having almost same number of 3 different values. Place all partition on differnet harddisks and if possible put them on different controllers. In that case your query response time will reduce to 1/3. Or If you are having Bitmap index option and not much insertion or deletion going on in this table then u can create a bitmap index on QueueType Field. Bitmap index are used for low cardinality columns only. I hope this may help you. Thanks Regards Darshan Singh - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, October 16, 2002 11:23 AM You could always consider something like OracleText to assist with these kind of searches, but thats a big step.. hth connor --- Carle, William T (Bill), ALCAS [EMAIL PROTECTED] wrote: Howdy, I have a table that has almost 2 million rows called eventqueueentry. The layout looks like this: Name Null? Type - EVENTID NOT NULL NUMBER(10) VER NOT NULL NUMBER(10) QUEUETYPE NOT NULL CHAR(16) PUBLISHER NOT NULL CHAR(16) CREATETIMENOT NULL DATE LASTREADTIME DATE REMOVETIME DATE CONTENTS NOT NULL VARCHAR2(4000) The users do a query that looks like this: SELECT EventId, QueueType, Publisher, CreateTime, LastReadTime, RemoveTime, Contents, Ver from EventQueueEntry where QueueType = 'CodeUpdate' AND Contents LIKE '%TrackingEventId=27668677%' ORDER BY EventId The queuetype field has only 3 different values. The value in the contents field is close to being unique (high cardinality) but, as you can see, they are picking off a value somewhere in the middle of a varchar2(4000) field. Understandably, their query is slow. Is there anything I can do with an index to speed this up? Bill Carle ATT Database Administrator 816-995-3922 [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Carle, William T (Bill), ALCAS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Connor McDonald http://www.oracledba.co.uk http://www.oaktable.net Remember amateurs built the ark - Professionals built the Titanic __ 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 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Darshan Singh INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Difference - Rebuild and Analyze index
Hi,
Can anybody please tell me the difference between
-
SQL execute
DBMS_UTILITY.ANALYZE_SCHEMA('BLAH','COMPUTE',NULL,30,'FOR ALL
INDEXES');
and
SQL select 'ALTER INDEX ' || INDEX_NAME || '
REBUILD ONLINE;' from USER_INDEXES
If I execute any one the above do i need to execute
the other also?
After how many days/hour it should be
executed.
TIA,
Marul.
RE: Connections with WebLogic (5.1) and Oracle 8.1.7 on Solaris[Scanned]
Joshua, I too faced a similar problem last week! The problem was that the users, used 'Ctrl + C' to close the WL which resulted in the number of process to exceed the limit. This problem was solved when the developers started using the WL console to close the oracle sessions. K. -Original Message- Sent: Wednesday, October 16, 2002 3:58 PM To: Multiple recipients of list ORACLE-L Solaris[Scanned] Hi all, we are facing strange problems with our environment. we are using weblogic and solaris8 with 8.1.7.3. It seems that somehow amount of cumulative connections is getting extremely high and it seems that WL is doing db connection each time user clicks the aplication. Is there any parameter on oracle side causing this. We have tested this with two similar environment and other seems to work ok and other does generate these connections but we do not find any reason for the different behaviour... Any ideas... Rgds, Joshua -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Karthikeyan S INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: ## Keeping Skills Current
-what would you recommend? Beer! -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 15, 2002 5:34 PM To: Multiple recipients of list ORACLE-L I am looking for suggestions on how to brush up my skills and continue learning on a regular basis. Large blocks of free time are hard to come by, but if I had only 30 minutes (or an hour) a day, what would you recommend? Thanks to all. Stephen Warkentien ...OLE_Obj... Senior Database Administrator Northrop Grumman Information Technology 5500 Canoga Avenue M/S W91 Woodland Hills CA 91367-6698 818-715-2860 voice 818-715-2617 FAX mailto:[EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Warkentien, Stephen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Farnsworth, Dave INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Difference - Rebuild and Analyze index
Marul,
These are 2 different utilities with 2 different functions and end results
Analyze schema with compute looks at all the indexes in that schema , reads
every block and produces statistics which the cost based optimiser can use
to determine the best execution path
Rebuilding an index can be used for one of 2 purposes. Either to move an
index to another tablespace without dropping it first (or re-enabling the
index after the table itself has been moved) or to defragment the index.
Only you can now how your system is being used, whether a lot of
updates/inserts/deletes are taking place, what the growth rate is. From that
information you can determine when to rebuild an object.
However the analyze routine does need to be run at least once if you wish to
have Oracle select the best execution path. After that it needs to be run on
any objects (tables/indexes) where volume or content has changed
significantly from the last time the analyze was run.
John
-Original Message-
Sent: 16 October 2002 12:44
To: Multiple recipients of list ORACLE-L
Hi,
Can anybody please tell me the difference between -
SQL execute DBMS_UTILITY.ANALYZE_SCHEMA('BLAH','COMPUTE',NULL,30,'FOR ALL
INDEXES');
and
SQL select 'ALTER INDEX ' || INDEX_NAME || ' REBUILD ONLINE;' from
USER_INDEXES
If I execute any one the above do i need to execute the other also?
After how many days/hour it should be executed.
TIA,
Marul.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Re: Difference - Rebuild and Analyze index
Hi,
There is one major difference is that rebuilding
index removes the internal fragmentation and analyze just calculat the
statistics.
The frequency of analyzing schema depends on the
schema modification frequency.
One can do this on weekly basis, mostly done on
week end with cron jobs.
Regards
Darshan Singh
- Original Message -
From:
Marul Mehta
To: Multiple recipients of list ORACLE-L
Sent: Wednesday, October 16, 2002 1:43
PM
Subject: Difference - Rebuild and Analyze
index
Hi,
Can anybody please tell me the difference between
-
SQL execute
DBMS_UTILITY.ANALYZE_SCHEMA('BLAH','COMPUTE',NULL,30,'FOR ALL
INDEXES');
and
SQL select 'ALTER INDEX ' || INDEX_NAME || '
REBUILD ONLINE;' from USER_INDEXES
If I execute any one the above do i need to
execute the other also?
After how many days/hour it should be
executed.
TIA,
Marul.
Need help from anybody using veritas netbackup on Nt
Hi, We are facing problems during veritas net backup of oracle database on Nt, The database comes down crashing saying the log file is locked, How can we solve this probs, has anybody faced this probs and if so can you please let me know how to solve this issue. I cannot bring this down during backup cause this is a 24x7 database. So please let me know if any one of you have found a solution to this issue. Thanks in advance. arun
RE: SET ORACLE-L NOMAIL
Es war ein Witz -Original Message- Sent: Wednesday, October 16, 2002 12:34 AM To: Multiple recipients of list ORACLE-L Hilfe ?! Für oder gegen was ? Gruss sfl Stefan Lindenmeyer Pre-Sales Technical Support IBM e-Server x-Series 430 Phone: +49 (0)89 4504 3237 (Office) +49 (0)8166 675011(Home Office) Mobile:+49 (0)1726338992 Email: [EMAIL PROTECTED] Mail: Anzinger Strasse 29 D-81671 Munich Farnsworth, Dave DFarnsworth@AshleyfurTo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] niture.com cc: Sent by: Subject: RE: SET ORACLE-L NOMAIL [EMAIL PROTECTED] 15.10.2002 18:19 Please respond to ORACLE-L HILFE -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 15, 2002 10:34 AM To: Multiple recipients of list ORACLE-L Subject: SET ORACLE-L NOMAIL SET ORACLE-L NOMAIL Mit freundlichen Grüßen, Brigitte Türk KAUFHOF WARENHAUS AG IT-Controlling Datenbankadm. Leonhard-Tietz-Str. 1 D-50676 Köln Tel.:+49 (0)221 223-21 88 eMail: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stefan Lindenmeyer INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Farnsworth, Dave INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
How to configure MD5 data encription in Oracle 8i
Hi Everybody, Can anyone tell me how to use MD5 hashing algorithm in Oracle8I Or is there any built in package to encrypt the data in Oracle 8i. I have created the Application user table there I am keeping user_Id and Password for the application. How to hide the password column in the table ? Thanks Suman DISCLAIMER: Information contained and transmitted by this E-MAIL is proprietary to Mascot Systems Limited and is intended for use only by the individual or entity to which it is addressed, and may contain information that is privileged, confidential or exempt from disclosure under applicable law. If this is a forwarded message, the content of this E-MAIL may not have been sent with the authority of the Company. If you are not the intended recipient, an agent of the intended recipient or a person responsible for delivering the information to the named recipient, you are notified that any use, distribution, transmission, printing, copying or dissemination of this information in any way or in any manner is strictly prohibited. If you have received this communication in error, please delete this mail notify us immediately at [EMAIL PROTECTED] Before opening attachments, please scan for viruses. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Suman S K INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Need help from anybody using veritas netbackup on Nt
Are you using the Oracle Agent to backup the DB files or you are just using the open file option? Regards Naveen -Original Message-From: Arun Chakrapanirao [mailto:[EMAIL PROTECTED]]Sent: Wednesday, October 16, 2002 5:44 PMTo: Multiple recipients of list ORACLE-LSubject: Need help from anybody using veritas netbackup on Nt Hi, We are facing problems during veritas net backup of oracle database on Nt, The database comes down crashing saying the log file is locked, How can we solve this probs, has anybody faced this probs and if so can you please let me know how to solve this issue. I cannot bring this down during backup cause this is a 24x7 database. So please let me know if any one of you have found a solution to this issue. Thanks in advance. arun
RE: RE: Speeding up LIKE '%something%'
Seems to me there may be a case for a little normalisation here - do I understand the field 'contents' to include aggregates of various data attributes? Oh dear... Expect more of it in the next years with XML-enabled databases :-). Regards, Stephane Faroult Oriole -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroul INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Help on resolving block number and file number from 10046 trace to table or index
it's a bug in the install package, they forgot to include tkprof ... you can get a copy of it off Metalink I believe --- Grant Allen [EMAIL PROTECTED] wrote: Hi all, For some reason my 9.0.1 windows install has no tkprof binary, so I'm trying to decipher some 10046 output. I've got a bunch of WAIT #1: nam='db file sequential read' ela= 6467 p1=7 p2=219340 p3=1 For this event, p1 is the file, and p2 is the block. Any ideas on how to track down what object this is (i.e. table, index or whatever)? thanks Fuzzy :-) -- Woo Hoo! - H. Simpson -- The contents of this post are my opinions only If swallowed seek medical advice (Apologies for the excess signature) This email message (and attachments) may contain information confidential to TOWER Software. If you are not the intended recipient you cannot use, distribute or copy the message or message attachments. If you are not the intended recipient, please notify the sender by return email immediately and delete all copies of the message and attachments. Opinions, conclusions and other information in this message and attachments that do not relate to the official business of TOWER Software, are not given or endorsed by it. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Grant Allen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do you Yahoo!? Faith Hill - Exclusive Performances, Videos More http://faith.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: How to configure MD5 data encription in Oracle 8i
Procedures and functions to create MD5 hashes (from RAW or VARCHAR2 inputs) are available (undocumented) in the DBMS_OBFUSCATION_TOOLKIT package. Check online doc at $ORACLE_HOME/rdbms/admin/dbmsobtk.sql for what little usage info there is... - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, October 16, 2002 6:48 AM Hi Everybody, Can anyone tell me how to use MD5 hashing algorithm in Oracle8I Or is there any built in package to encrypt the data in Oracle 8i. I have created the Application user table there I am keeping user_Id and Password for the application. How to hide the password column in the table ? Thanks Suman DISCLAIMER: Information contained and transmitted by this E-MAIL is proprietary to Mascot Systems Limited and is intended for use only by the individual or entity to which it is addressed, and may contain information that is privileged, confidential or exempt from disclosure under applicable law. If this is a forwarded message, the content of this E-MAIL may not have been sent with the authority of the Company. If you are not the intended recipient, an agent of the intended recipient or a person responsible for delivering the information to the named recipient, you are notified that any use, distribution, transmission, printing, copying or dissemination of this information in any way or in any manner is strictly prohibited. If you have received this communication in error, please delete this mail notify us immediately at [EMAIL PROTECTED] Before opening attachments, please scan for viruses. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Suman S K INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tim Gorman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Speeding up LIKE '%something%'
Title: RE: Speeding up LIKE '%something%' Another solution is Intermedia Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! -Original Message- From: Stephane Faroult [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 16, 2002 4:29 AM To: Multiple recipients of list ORACLE-L Subject: Speeding up LIKE '%something%' Carle, William T (Bill), ALCAS wrote: Howdy, I have a table that has almost 2 million rows called eventqueueentry. The layout looks like this: Name Null? Type - EVENTID NOT NULL NUMBER(10) VER NOT NULL NUMBER(10) QUEUETYPE NOT NULL CHAR(16) PUBLISHER NOT NULL CHAR(16) CREATETIME NOT NULL DATE LASTREADTIME DATE REMOVETIME DATE CONTENTS NOT NULL VARCHAR2(4000) The users do a query that looks like this: SELECT EventId, QueueType, Publisher, CreateTime, LastReadTime, RemoveTime, Contents, Ver from EventQueueEntry where QueueType = 'CodeUpdate' AND Contents LIKE '%TrackingEventId=27668677%' ORDER BY EventId The queuetype field has only 3 different values. The value in the contents field is close to being unique (high cardinality) but, as you can see, they are picking off a value somewhere in the middle of a varchar2(4000) field. Understandably, their query is slow. Is there anything I can do with an index to speed this up? Bill Carle ATT Database Administrator 816-995-3922 [EMAIL PROTECTED] I think that if it's 'TrackingEventId' which REALLY interests your users (as opposed to any random string of characters within CONTENTS) you should train your users into expressing their query as something similar to to_number(substr(CONTENTS, decode(instr(CONTENTS, 'TrackingEventId='), 0, length(CONTENTS), instr(CONTENTS, 'TrackingEventId=')+16), 8)) = 27668677 (I do *not* guarantee the number of parentheses :) and I assume that the number is always 8-digit long - adapt). This nice expression would allow you to create a function based index. In fact, you could then create a view above the table which would directly include a TRACKINGEVENTID column defined as above, and, assuming the FBI, your users could query : SELECT EventId, QueueType, Publisher, CreateTime, LastReadTime, RemoveTime, Contents, Ver from V_EventQueueEntry where QueueType = 'CodeUpdate' AND TrackingEventId=27668677 ORDER BY EventId Another solution would be to add a column, and extract the information as it is inserted (trigger) to fill the column - which you would of course index. If many different chunks of CONTENTS can be queried, I would consider Intermedia. -- Regards, Stephane Faroult Oriole Software - End Forwarded Message - Regards, Stephane Faroult Oriole -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroul INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). *This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.*1
Re: role/priv. reqd to create/support a management server repository
You can use the default userid that OEM creates for repository ownership (SYSMAN) and call it a day. OR Look at the privileges that SYSMAN has and compare it to the userid you created. I would suspect that some system privileges would have to be granted directly to the userid instead of via a role. Try granting the simple privs first, like CREATE SESSION, ALTER USER, CREATE TABLE, etc. Remember, privileges inherited via a role are not active while executing a stored procedure. DBA is a role. RWB oraora oraora [EMAIL PROTECTED]@fatcity.com on 10/16/2002 03:14:01 AM Please respond to [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: guys, i am on 8.1.6/w2k. i tried to create a new server management repository using Enterprise Manager configuration assistant.this is first time i am going to use EM on this machine.but when i gave a usename/pwd during repository login informationi got the error : SELECTED USER LACKS ONE OR MORE OF THE PRIVILEGES OR ROLES REQUIRED TO CREATE AND SUPPORT A MANAGEMENT SERVER REPOSITORY. i have granted dba,sysdba,sysoper privs to that user. what priv/role should be granted to create/support a management server repository ? kindly let me know guys. TIA. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: oraora oraora INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Strange Date -- 00-JAN-00 !!!!!
We had a similar problem with aload program. I believe it had to do with the century setting for us. -Original Message-From: Sunny Verghese [mailto:[EMAIL PROTECTED]]Sent: Tuesday, October 15, 2002 8:58 PMTo: Multiple recipients of list ORACLE-LSubject: Strange Date -- 00-JAN-00 ! One of the DBAs I work with is trying to figure out how some of the records in a table with about 15 million records contains 00-Jan-00 in a specific date column. The table is populated using an application written in Power Builder. I don't know the history (if and when patches were applied / the database was upgraded). I saw a couple of notes on Metalink about upgrades causing something of this sort. Any ideas ??? Sunny Do you Yahoo!?Faith Hill - Exclusive Performances, Videos, morefaith.yahoo.com
RE: Need help from anybody using veritas netbackup on Nt
No they are just using the open file option is there any other oracle agent apart from the oracle intelligent agent which you are talking about, Please let me know Thanks -Original Message- From: Naveen Nahata [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 16, 2002 8:59 AM To: Multiple recipients of list ORACLE-L Subject: RE: Need help from anybody using veritas netbackup on Nt Are you using the Oracle Agent to backup the DB files or you are just using the open file option? Regards Naveen -Original Message- From: Arun Chakrapanirao [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 16, 2002 5:44 PM To: Multiple recipients of list ORACLE-L Subject: Need help from anybody using veritas netbackup on Nt Hi, We are facing problems during veritas net backup of oracle database on Nt, The database comes down crashing saying the log file is locked, How can we solve this probs, has anybody faced this probs and if so can you please let me know how to solve this issue. I cannot bring this down during backup cause this is a 24x7 database. So please let me know if any one of you have found a solution to this issue. Thanks in advance. arun
RE: Need help from anybody using veritas netbackup on Nt
netbackup has an Oracle agent that should be installed as part of the netbackup installation. I know they had installed it for the Unix servers when I was there. Rachel --- Arun Chakrapanirao [EMAIL PROTECTED] wrote: No they are just using the open file option is there any other oracle agent apart from the oracle intelligent agent which you are talking about, Please let me know Thanks -Original Message- Sent: Wednesday, October 16, 2002 8:59 AM To: Multiple recipients of list ORACLE-L Are you using the Oracle Agent to backup the DB files or you are just using the open file option? Regards Naveen -Original Message- Sent: Wednesday, October 16, 2002 5:44 PM To: Multiple recipients of list ORACLE-L Hi, We are facing problems during veritas net backup of oracle database on Nt, The database comes down crashing saying the log file is locked, How can we solve this probs, has anybody faced this probs and if so can you please let me know how to solve this issue. I cannot bring this down during backup cause this is a 24x7 database. So please let me know if any one of you have found a solution to this issue. Thanks in advance. arun __ Do you Yahoo!? Faith Hill - Exclusive Performances, Videos More http://faith.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Problem installing Oracle 8.1.7 on Windows 2000
Hi, I am installing Oracle 8.1.7 on a MS Windows 2000 SP 3 system. When I get to the Net8 Configuration assistant, process jrew.exe goes to 100% of the CPU. I have let it run for over 15 minutes before stopping it from the Oracle installer. The process stops using the CPU but the Oracle installer hangs. I have to cancel the installer. If I try to create a database, I get a TNS adapter error. I have installed 8.1.7 on Windows NT without a problem. I have opened a TAR. Anyone experience this problem? Any help will be greatly appreciated. Thanks. Larry Noble DBA Medrad Inc -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Noble, Larry H. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: SET ORACLE-L NOMAIL
You are so evil. But right. Gogala, Mladen To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] MGogala cc: @oxhp.com Subject: RE: SET ORACLE-L NOMAIL Sent by: root 10/15/2002 05:43 PM Please respond to ORACLE-L Brigitte, you need to send this command to [EMAIL PROTECTED] -Original Message- Sent: Tuesday, October 15, 2002 11:34 AM To: Multiple recipients of list ORACLE-L SET ORACLE-L NOMAIL Mit freundlichen Grüßen, Brigitte Türk KAUFHOF WARENHAUS AG IT-Controlling Datenbankadm. Leonhard-Tietz-Str. 1 D-50676 Köln Tel.:+49 (0)221 223-21 88 eMail: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thomas Day INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Help on resolving block number and file number from 10046 trace to table or index
Go to the $OH/rdbms/lib directory as the oracle user and run make -f ins_rdbms.mk itkprof... - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, October 16, 2002 7:39 AM to table or index it's a bug in the install package, they forgot to include tkprof .. you can get a copy of it off Metalink I believe --- Grant Allen [EMAIL PROTECTED] wrote: Hi all, For some reason my 9.0.1 windows install has no tkprof binary, so I'm trying to decipher some 10046 output. I've got a bunch of WAIT #1: nam='db file sequential read' ela= 6467 p1=7 p2=219340 p3=1 For this event, p1 is the file, and p2 is the block. Any ideas on how to track down what object this is (i.e. table, index or whatever)? thanks Fuzzy :-) -- Woo Hoo! - H. Simpson -- The contents of this post are my opinions only If swallowed seek medical advice (Apologies for the excess signature) This email message (and attachments) may contain information confidential to TOWER Software. If you are not the intended recipient you cannot use, distribute or copy the message or message attachments. If you are not the intended recipient, please notify the sender by return email immediately and delete all copies of the message and attachments. Opinions, conclusions and other information in this message and attachments that do not relate to the official business of TOWER Software, are not given or endorsed by it. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Grant Allen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do you Yahoo!? Faith Hill - Exclusive Performances, Videos More http://faith.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tim Gorman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Problem installing Oracle 8.1.7 on Windows 2000
the only problems i got was with 9i and 9ias release 2 -Original Message- Sent: quarta-feira, 16 de Outubro de 2002 15:34 To: Multiple recipients of list ORACLE-L Hi, I am installing Oracle 8.1.7 on a MS Windows 2000 SP 3 system. When I get to the Net8 Configuration assistant, process jrew.exe goes to 100% of the CPU. I have let it run for over 15 minutes before stopping it from the Oracle installer. The process stops using the CPU but the Oracle installer hangs. I have to cancel the installer. If I try to create a database, I get a TNS adapter error. I have installed 8.1.7 on Windows NT without a problem. I have opened a TAR. Anyone experience this problem? Any help will be greatly appreciated. Thanks. Larry Noble DBA Medrad Inc -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Noble, Larry H. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paulo Gomes INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Double Take and Oracle
Title: Double Take and Oracle Hello Dick and All who contributed to this thread. Amazingly this software Double-Take(DT) worked over night. Basically what the DT Technician did over the evening was to re-replicate the files and re-mirror the files. This morning we restarted the database and she came up as if nothing had occurred. I for one was impressed. The database that I left last night was a very unhappy little creature. Apparently the techie decided to re-replicate as he had not done that since the first day. That is his explanation. Once again thanks for your advice. Damagement are smiling again, Thank God it was not an Oracle problem. Regards Denham Eva -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 15, 2002 9:19 PM To: Denham Eva; Multiple recipients of list ORACLE-L Subject: Re:RE: RE: RE: Double Take and Oracle Eva, Your welcome. Please let all of us know how things work out for future reference. And don't be afraid to ask for more. Dick Goulet DISCLAIMER This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. TFMC, its holding company, and any of its subsidiaries each reserve the right to monitor and manage all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be views of any such entity. This e-mail message has been scanned for Viruses and Content and cleared by MailMarshal - For more information please visit www.marshalsoftware.com
RE: Problem installing Oracle 8.1.7 on Windows 2000
Are you installing from the console? Trying to install from a terminal server session can give those kinds of problems on 2000. HTH, Beth -Original Message- Sent: Wednesday, October 16, 2002 10:34 AM To: Multiple recipients of list ORACLE-L Hi, I am installing Oracle 8.1.7 on a MS Windows 2000 SP 3 system. When I get to the Net8 Configuration assistant, process jrew.exe goes to 100% of the CPU. I have let it run for over 15 minutes before stopping it from the Oracle installer. The process stops using the CPU but the Oracle installer hangs. I have to cancel the installer. If I try to create a database, I get a TNS adapter error. I have installed 8.1.7 on Windows NT without a problem. I have opened a TAR. Anyone experience this problem? Any help will be greatly appreciated. Thanks. Larry Noble DBA Medrad Inc -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Noble, Larry H. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seefelt, Beth INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Need help from anybody using veritas netbackup on Nt
We use backupexec and it has an oracle agent. Maybe need something similar for netbackup. Jeffrey BeckstromDatabase AdministratorGreater Cleveland Regional Transit Authority1240 W. 6th StreetCleveland, Ohio 44113(216) 781-4204 [EMAIL PROTECTED] 10/16/02 10:08:30 AM No they are just using the open file option is there any other oracle agent apart from the oracle intelligent agent which you are talking about, Please let me know Thanks -Original Message-From: Naveen Nahata [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 16, 2002 8:59 AMTo: Multiple recipients of list ORACLE-LSubject: RE: Need help from anybody using veritas netbackup on Nt Are you using the Oracle Agent to backup the DB files or you are just using the open file option? Regards Naveen -Original Message-From: Arun Chakrapanirao [mailto:[EMAIL PROTECTED]]Sent: Wednesday, October 16, 2002 5:44 PMTo: Multiple recipients of list ORACLE-LSubject: Need help from anybody using veritas netbackup on Nt Hi, We are facing problems during veritas net backup of oracle database on Nt, The database comes down crashing saying the log file is locked, How can we solve this probs, has anybody faced this probs and if so can you please let me know how to solve this issue. I cannot bring this down during backup cause this is a 24x7 database. So please let me know if any one of you have found a solution to this issue. Thanks in advance. arun
Kind of urgent database not autostarting after upgrade
All I apologise I haven't had time to thank those who responded to my question about passing a list of variables to a stored procedure. There have been many fires burning here... so I haven't had time to respond. The problem I'm experiencing is this Management decided to upgrade the OS on our one of our development servers. No one asked for any input from me... but guess who they are asking to fix it?? I assure you all I had absolutely nothing to do with upgrading the OS without checking compatibility issues. sigh... We have 30 instances 5 - 7.34 5 - 8.05 20 - 8.1.6 Running on NT 4.0 sp6a 4G ram, twin 500 processors. All these databases are *not* production but rather development databases. The physical server's resources seemed to be more than adequate and never were an issue The problem began when the OS was upgraded to WIN2K server, now all the 8.16 dbs will not start automatically (upon boot) If I look at the service it says starting rather than started. Trying to connect with sql plus as internal I get connected to an idle instance So the only way to start the db is to pass sql plus the startup pfile= Then I'm good to go. I have a tar with Oracle and did the following recommendations 1. Applied the highest patch to 8.16 + a special 1 off patch, made no difference At that point Oracle suggested to upgrade to 8.17 as 8.16 is not supported on WIN2K server 2. Installed Oracle 8.17, set the home to 8.17 migrated 1 db as a test; all other dbs were started via batch script The new (migrated db still exhibits the original symptoms after the upgrade) which were If you try to connect via sql+ I get Oracle not available The db is listed as starting rather than started I must physically start the db using SQL startup pfile=... Or e.g. [startup.bat] svrmgrl.exe command='@C:\db_startup\initdb8i.sql' C:\sleep 3 svrmgrl.exe command='@C:\db_startup\initdbdev.sql' ... [initdb8i.sql] connect internal/password@db8i startup pfile=T:\Admin\db8i\PFILE\initdb8i.ora exit Oracle is saying this is bug 1266248 which precisely describes the problem Does anyone have any info or a solution for this?? As always many thanks Bob -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Access with ACCESS
Unfortunately, not really. If your Oracle version is at least 8i (you don't say which you're using), you could create a LOGON trigger where you could glean the PROGRAM variable set by the client. The problem with this is that MS can sometimes have very long path names to get to MSACCESS.EXE, which will then be truncated by the PROGRAM size of 50 chars (or is it 64?). And different versions of Winders puts the forsaken tool in different locations. You could *mostly* prevent ACCESS from access, but it can never be 100%. Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- Sent: Tuesday, October 15, 2002 5:59 PM To: Multiple recipients of list ORACLE-L How do I stop users from accessing Oracle tables with Access? They have rights to the tables in Oracle and should have those rights, yet I do not want anyone to be able to pull the data off into an access database. Is it possible to stop this without taking their privileges to the Oracle tables away? Thank you, Laura -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Need help from anybody using veritas netbackup on Nt
Veritas comes with Oracle Agent, which you can use to take the backup of ur DB while it is running. Oracle agent puts each tablespace in hot backup mode and then copies the DataFiles. Configure the backup using Oracle Agent rather than open-file option which uses the O/S level backup. Regards Naveen -Original Message-From: Arun Chakrapanirao [mailto:[EMAIL PROTECTED]]Sent: Wednesday, October 16, 2002 7:39 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Need help from anybody using veritas netbackup on Nt No they are just using the open file option is there any other oracle agent apart from the oracle intelligent agent which you are talking about, Please let me know Thanks -Original Message-From: Naveen Nahata [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 16, 2002 8:59 AMTo: Multiple recipients of list ORACLE-LSubject: RE: Need help from anybody using veritas netbackup on Nt Are you using the Oracle Agent to backup the DB files or you are just using the open file option? Regards Naveen -Original Message-From: Arun Chakrapanirao [mailto:[EMAIL PROTECTED]]Sent: Wednesday, October 16, 2002 5:44 PMTo: Multiple recipients of list ORACLE-LSubject: Need help from anybody using veritas netbackup on Nt Hi, We are facing problems during veritas net backup of oracle database on Nt, The database comes down crashing saying the log file is locked, How can we solve this probs, has anybody faced this probs and if so can you please let me know how to solve this issue. I cannot bring this down during backup cause this is a 24x7 database. So please let me know if any one of you have found a solution to this issue. Thanks in advance. arun
RE: Kind of urgent database not autostarting after upgrade
I'm not sure about the upgrade from WinNT to Win2K, but the easiest remedy for the DB not auto-starting is to delete and re-create the service. You can use ORADIM, and then while re-creating the service, you can use option of autostart. Regards Naveen -Original Message- Sent: Wednesday, October 16, 2002 8:29 PM To: Multiple recipients of list ORACLE-L All I apologise I haven't had time to thank those who responded to my question about passing a list of variables to a stored procedure. There have been many fires burning here... so I haven't had time to respond. The problem I'm experiencing is this Management decided to upgrade the OS on our one of our development servers. No one asked for any input from me... but guess who they are asking to fix it?? I assure you all I had absolutely nothing to do with upgrading the OS without checking compatibility issues. sigh... We have 30 instances 5 - 7.34 5 - 8.05 20 - 8.1.6 Running on NT 4.0 sp6a 4G ram, twin 500 processors. All these databases are *not* production but rather development databases. The physical server's resources seemed to be more than adequate and never were an issue The problem began when the OS was upgraded to WIN2K server, now all the 8.16 dbs will not start automatically (upon boot) If I look at the service it says starting rather than started. Trying to connect with sql plus as internal I get connected to an idle instance So the only way to start the db is to pass sql plus the startup pfile= Then I'm good to go. I have a tar with Oracle and did the following recommendations 1. Applied the highest patch to 8.16 + a special 1 off patch, made no difference At that point Oracle suggested to upgrade to 8.17 as 8.16 is not supported on WIN2K server 2. Installed Oracle 8.17, set the home to 8.17 migrated 1 db as a test; all other dbs were started via batch script The new (migrated db still exhibits the original symptoms after the upgrade) which were If you try to connect via sql+ I get Oracle not available The db is listed as starting rather than started I must physically start the db using SQL startup pfile=... Or e.g. [startup.bat] svrmgrl.exe command='@C:\db_startup\initdb8i.sql' C:\sleep 3 svrmgrl.exe command='@C:\db_startup\initdbdev.sql' ... [initdb8i.sql] connect internal/password@db8i startup pfile=T:\Admin\db8i\PFILE\initdb8i.ora exit Oracle is saying this is bug 1266248 which precisely describes the problem Does anyone have any info or a solution for this?? As always many thanks Bob -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Naveen Nahata INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Need help from anybody using veritas netbackup on Nt
Arun Im using RMAN with NetBackup on Solaris without any issues. What is the exact error message that youre getting? Im assuming that its showing up in the Alert Log, and not the NetBackup logs. It might be best if you provide the scripts youre using to facilitate the backup. It honestly sounds like youre trying to do a cold backup while the database is still up, but thats just a guess. Brian -- | Brian McGraw /* DBA */ Infinity Insurance | | mailto:[EMAIL PROTECTED] | -- -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Arun Chakrapanirao Sent: Wednesday, October 16, 2002 7:14 AM To: Multiple recipients of list ORACLE-L Subject: Need help from anybody using veritas netbackup on Nt Hi, We are facing problems during veritas net backup of oracle database on Nt, The database comes down crashing saying the log file is locked, How can we solve this probs, has anybody faced this probs and if so can you please let me know how to solve this issue. I cannot bring this down during backup cause this is a 24x7 database. So please let me know if any one of you have found a solution to this issue. Thanks in advance. arun
RE: Kind of urgent database not autostarting after upgrade
Bob, I agree with Naveen. Have you tried re-creating the service using Oradim? You can do this anytime and it will not have any effect on the db. I vaguely remember this bug, but have not experienced it. I am running both NT and Win2k with 8.1.7.2 and both work just fine. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Wednesday, October 16, 2002 10:59 AM To: Multiple recipients of list ORACLE-L All I apologise I haven't had time to thank those who responded to my question about passing a list of variables to a stored procedure. There have been many fires burning here... so I haven't had time to respond. The problem I'm experiencing is this Management decided to upgrade the OS on our one of our development servers. No one asked for any input from me... but guess who they are asking to fix it?? I assure you all I had absolutely nothing to do with upgrading the OS without checking compatibility issues. sigh... We have 30 instances 5 - 7.34 5 - 8.05 20 - 8.1.6 Running on NT 4.0 sp6a 4G ram, twin 500 processors. All these databases are *not* production but rather development databases. The physical server's resources seemed to be more than adequate and never were an issue The problem began when the OS was upgraded to WIN2K server, now all the 8.16 dbs will not start automatically (upon boot) If I look at the service it says starting rather than started. Trying to connect with sql plus as internal I get connected to an idle instance So the only way to start the db is to pass sql plus the startup pfile= Then I'm good to go. I have a tar with Oracle and did the following recommendations 1. Applied the highest patch to 8.16 + a special 1 off patch, made no difference At that point Oracle suggested to upgrade to 8.17 as 8.16 is not supported on WIN2K server 2. Installed Oracle 8.17, set the home to 8.17 migrated 1 db as a test; all other dbs were started via batch script The new (migrated db still exhibits the original symptoms after the upgrade) which were If you try to connect via sql+ I get Oracle not available The db is listed as starting rather than started I must physically start the db using SQL startup pfile=... Or e.g. [startup.bat] svrmgrl.exe command='@C:\db_startup\initdb8i.sql' C:\sleep 3 svrmgrl.exe command='@C:\db_startup\initdbdev.sql' ... [initdb8i.sql] connect internal/password@db8i startup pfile=T:\Admin\db8i\PFILE\initdb8i.ora exit Oracle is saying this is bug 1266248 which precisely describes the problem Does anyone have any info or a solution for this?? As always many thanks Bob -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Connections with WebLogic (5.1) and Oracle 8.1.7 on Solaris
I though WL manages connection pool. Better look into WL configurations for connection pooling . Joshua Becker [EMAIL PROTECTED] wrote: Hi all,we are facing strange problems with our environment.we are using weblogic and solaris8 with 8.1.7.3. It seems that somehow amount of cumulative connectionsis getting extremely high and it seems that WL isdoing db connection each time user clicks theaplication. Is there any parameter on oracle sidecausing this.We have tested this with two similar environment andother seems to work ok and other does generate theseconnections but we do not find any reason for thedifferent behaviour...Any ideas...Rgds,Joshua_Gratis e-mail resten av livet på www.yahoo.se/mailBusenkelt!-- Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: =?iso-8859-1?q?Joshua=20Becker?=INET:: [EMAIL PROTECTED]Fat City Network Ser! vices -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services--To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).Do you Yahoo!? Faith Hill - Exclusive Performances, Videos, & more faith.yahoo.com
RE: Kind of urgent database not autostarting after upgrade
I'm not sure about the upgrade from WinNT to Win2K, but the easiest remedy for the DB not auto-starting is to delete and re-create the service. You can use ORADIM, and then while re-creating the service, you can use option of autostart. Regards Naveen Hi Yes, that's part of the problem/original bug where oradim could not recreate the service after deleting it. You need to reboot. Here is the bug 1266248 Problem is with the call that is made to ORADIM.EXE by the service when the registry entry ora_sid_autostart=true. Oradim hangs, the service is shown to be in status 'starting' and the service oracleservicesid cannot be stopped. ORACLE.EXE must be killed from Task Manager, and ORADIM.EXE cannot be killed.Setting reg entry ora_sid_autostart=false, and rebooting, resolves the issue, leaving us, of course, without an aotostart option. It is worth noting that dispite the status of the service, the database can be started and stopped manually from Server Manager. The error is only on the service attempting to autostart the database. We removed and rebuilt oracleservicesid using Oradim, and this fixed the problem temporarily. We were able to use the service to start/stop, until a reboot, after which the same problem occurs. I was just off the phone with Oracle, and was advised to start another tar... Thanks bob -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Drop snapshot ORA-03113
Good day to all 8.1.7.4 Ent. edition on Windows NT4/SP5 I have performed fromuser = X / touser = Y import and (at a first glance) everything is fine, as it is supposed to be. But... I have noticed that there are some snapshots and one refresh group in database now, that belong to the user X - but user X does not exit in db where import is performed. Since I don't need those snapshots, I try to drop (as sys user) those snapshots and group and then I get ORA-03113. What is going on? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vladimir Barac INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Difference - Rebuild and Analyze index
Yes Marul , I think there is a big differenece in them . When you are rebulding the index means you are re-organzing the entries in the index , may be removing the entries for the rows deleted in past and so forth so on. But this doesn't generate any statistics about index.
When you analyze index, you generate information ( statistics) about the data in index , like leaf blocks or depth of index etc.
None of these should require orther , but they have some effect .
Like if you rebuild index , after that you dont have latest statistics and queries may not perform upto mark .
-oramagic
Marul Mehta [EMAIL PROTECTED] wrote:
Hi,
Can anybody please tell me the difference between -
SQL execute DBMS_UTILITY.ANALYZE_SCHEMA('BLAH','COMPUTE',NULL,30,'FOR ALL INDEXES');
and
SQL select 'ALTER INDEX ' || INDEX_NAME || ' REBUILD ONLINE;' from USER_INDEXES
If I execute any one the above do i need to execute the other also?
After how many days/hour it should be executed.
TIA,
Marul.Do you Yahoo!?
Faith Hill - Exclusive Performances, Videos, & more
faith.yahoo.com
RE: Problem installing Oracle 8.1.7 on Windows 2000
I know you're getting loads of small tips and hints rather than solutions but here's another - I've only seen jrew go to 100% cpu when there was insufficient memory available... Lewis Bishop --- Barclays Enable - ISS - E-NTRUST/Bexleyheath NT Oracle Database Consultant Watling Street, Bexleyheath, Kent, DA6 7RR (Mail Van R) Phone : 020 8298 3418 Mobile: 07950 380857 Email : [EMAIL PROTECTED] Enabling Competitive Advantage for Barclays in IT and Business Processing -Original Message- Sent: 16 October 2002 16:19 To: Multiple recipients of list ORACLE-L This header confirms that this email message has been swept for the presence of computer viruses. Corporate IT THE WOOLWICH -- Are you installing from the console? Trying to install from a terminal server session can give those kinds of problems on 2000. HTH, Beth -Original Message- Sent: Wednesday, October 16, 2002 10:34 AM To: Multiple recipients of list ORACLE-L Hi, I am installing Oracle 8.1.7 on a MS Windows 2000 SP 3 system. When I get to the Net8 Configuration assistant, process jrew.exe goes to 100% of the CPU. I have let it run for over 15 minutes before stopping it from the Oracle installer. The process stops using the CPU but the Oracle installer hangs. I have to cancel the installer. If I try to create a database, I get a TNS adapter error. I have installed 8.1.7 on Windows NT without a problem. I have opened a TAR. Anyone experience this problem? Any help will be greatly appreciated. Thanks. Larry Noble DBA Medrad Inc -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Noble, Larry H. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seefelt, Beth INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bishop Lewis INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Need help from anybody using veritas netbackup on Nt
Do you have the Veritas Agent for Oracle installed? That lets you do Oracle backups while the database is up. 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-From: Arun Chakrapanirao [mailto:[EMAIL PROTECTED]]Sent: Wednesday, October 16, 2002 9:14 AMTo: Multiple recipients of list ORACLE-LSubject: Need help from anybody using veritas netbackup on Nt Hi, We are facing problems during veritas net backup of oracle database on Nt, The database comes down crashing saying the log file is locked, How can we solve this probs, has anybody faced this probs and if so can you please let me know how to solve this issue. I cannot bring this down during backup cause this is a 24x7 database. So please let me know if any one of you have found a solution to this issue. Thanks in advance. arun
RE: Can I index this query?
I don't think it's really that big of a step. Until a rewrite of our 3rd-party inventory system (i.e. we didn't write the damn thing), we have to rely on part description stored in two separate tables (don't ask!) in order to search for parts. By installing and adding a Context/Intermedia/Text/whateverthehell index, we've gone from a two-table FTS (200K total rows on moderately wide tables) to sub-second index access. The difficulties in getting to this point are: 1) Understanding Oracle Text concepts. Read the book! 2) Being able to change the SQL to use the OText special CONTAINS clause. 3) Understanding the data to be able to setup your thesaurus correctly. 4) Determining if/when to rebuild the index. It took me about a week of research and testing before installing and using it (of course that week's work was spread over three weeks!), and a day or two of tweaks afterwards. In my case, I needed to also create some replication-like triggers and tables to combine data from our two tables into a single, indexable, searchable table. Fire it up! We've been pretty happy with the results (except when a user wants to return every row with a Z in the string...sigh). GL! :) Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA Judge: ...and I'm no slouch myself. Ty: Don't sell yourself short, Judge. You're a tremendous slouch. -Original Message- From: Connor McDonald [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 16, 2002 4:24 AM To: Multiple recipients of list ORACLE-L Subject: Re: Can I index this query? You could always consider something like OracleText to assist with these kind of searches, but thats a big step.. hth connor --- Carle, William T (Bill), ALCAS [EMAIL PROTECTED] wrote: Howdy, I have a table that has almost 2 million rows called eventqueueentry. The layout looks like this: Name Null? Type - EVENTID NOT NULL NUMBER(10) VER NOT NULL NUMBER(10) QUEUETYPE NOT NULL CHAR(16) PUBLISHER NOT NULL CHAR(16) CREATETIMENOT NULL DATE LASTREADTIME DATE REMOVETIME DATE CONTENTS NOT NULL VARCHAR2(4000) The users do a query that looks like this: SELECT EventId, QueueType, Publisher, CreateTime, LastReadTime, RemoveTime, Contents, Ver from EventQueueEntry where QueueType = 'CodeUpdate' AND Contents LIKE '%TrackingEventId=27668677%' ORDER BY EventId The queuetype field has only 3 different values. The value in the contents field is close to being unique (high cardinality) but, as you can see, they are picking off a value somewhere in the middle of a varchar2(4000) field. Understandably, their query is slow. Is there anything I can do with an index to speed this up? Bill Carle -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Drop snapshot ORA-03113 - part 2
DBA_JOBS shows that there is job associated with phantom refresh group. Can't remove job because user that owns it does not exist (remember fromuser/touser). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vladimir Barac INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Any way to see the currently running SQL in one session.
there is a x$ table which can give u this info I am not able to recall that at the moment . oramagic Paulo Gomes [EMAIL PROTECTED] wrote: u could use top sessions-Original Message-Sent: quarta-feira, 16 de Outubro de 2002 2:28To: Multiple recipients of list ORACLE-LDear ALL,Is there any way to see the currently running SQL in one session? Iused v$open_cursor, but there might be many SQL statements, I don't knowwhich one is currently running. And more, if I execute a stored procedure,which SQL statements could be seen in v$open_cursor? Any clues would be much appreciated.TIAChuan-- Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: Paulo GomesINET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services-To REMOVE yourself from this mail! ! ing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).Do you Yahoo!? Faith Hill - Exclusive Performances, Videos, & more faith.yahoo.com
Re: How to configure MD5 data encription in Oracle 8i
why not use encryption outside the database and store encrypted string in database . We do it all the time , java application does the encrytion and authentication , db just stores the encrypted string . Just an idea . I dont the answer of your original question :) Oramagic Suman S K [EMAIL PROTECTED] wrote: Hi Everybody,Can anyone tell me how to use MD5 hashing algorithm in Oracle8IOr is there any built in package to encrypt the data in Oracle 8i.I have created the Application user table there I am keeping user_Idand Password for the application. How to hide the password column in the table ?ThanksSumanDISCLAIMER: Information contained and transmitted by this E-MAIL isproprietary to Mascot Systems Limited and is intended for use only by theindividual or entity to which it is addressed, and may contain informationthat is privileged, confidential or exempt from disclosure under applicablelaw. If this is a forwarded message, the content of this E-MAIL may not havebeen sent with the authority of the Company. If you are not the intendedrecipient, an agent of the intended recipient or a person! ! responsible fordelivering the information to the named recipient, you are notified that anyuse, distribution, transmission, printing, copying or dissemination of thisinformation in any way or in any manner is strictly prohibited. If you havereceived this communication in error, please delete this mail notify usimmediately at [EMAIL PROTECTED] Before opening attachments,please scan for viruses. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: Suman S KINET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-! ! L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).Do you Yahoo!? Faith Hill - Exclusive Performances, Videos, & more faith.yahoo.com
Urgent problem with query in CBO Vs RBO
Title: Urgent problem with query in CBO Vs RBO Okay ... so I have a query that works fine in RBO (8161). In CBO (9201) is returns wrong results (stats are recreated this AM). By adding a group by the CBO query returns the right data. Furthermore on CBO, the explain plan shows that Oracle is not even parsing the query completely. If drops off a huge EXISTS clause. Does anyone know what is going on? I have a sev 1 tar open and waiting for OWS to call me. Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! *This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.*1
RE: Access with ACCESS
Some options could be: - password protected roles - application roles (9i) - virtual private database each being enabled via the applications that *you* control and thus not from Access. Some/all of the above could possibly be subverted in time by a smart and malicious user, but it should suffice in most cases hth connor --- Jesse, Rich [EMAIL PROTECTED] wrote: Unfortunately, not really. If your Oracle version is at least 8i (you don't say which you're using), you could create a LOGON trigger where you could glean the PROGRAM variable set by the client. The problem with this is that MS can sometimes have very long path names to get to MSACCESS.EXE, which will then be truncated by the PROGRAM size of 50 chars (or is it 64?). And different versions of Winders puts the forsaken tool in different locations. You could *mostly* prevent ACCESS from access, but it can never be 100%. Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- Sent: Tuesday, October 15, 2002 5:59 PM To: Multiple recipients of list ORACLE-L How do I stop users from accessing Oracle tables with Access? They have rights to the tables in Oracle and should have those rights, yet I do not want anyone to be able to pull the data off into an access database. Is it possible to stop this without taking their privileges to the Oracle tables away? Thank you, Laura -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Connor McDonald http://www.oracledba.co.uk http://www.oaktable.net Remember amateurs built the ark - Professionals built the Titanic __ 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 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Kind of urgent database not autostarting after upgrade
Download the kill utility from www.sysinternals.com - that'll let you kill almost anything. I agree with previous posts in that you should try to kill off the services/shutdown the db, and remove them using ORADIM. If this doesn't remove the services then remove them using INSTSRV -REMOVE [1] from the resource kit (that will get rid of them), then recreate using ORADIM. Make sure you use the correct ORADIM binaries (right version) for the removal and recreation of the services. [1] Be aware though that once the services are gone, if you can't recreate them then you could be facing a more serious error than you currently have. Lewis Bishop --- Barclays Enable - ISS - E-NTRUST/Bexleyheath NT Oracle Database Consultant Watling Street, Bexleyheath, Kent, DA6 7RR (Mail Van R) Phone : 020 8298 3418 Mobile: 07950 380857 Email : [EMAIL PROTECTED] Enabling Competitive Advantage for Barclays in IT and Business Processing -Original Message- Sent: 16 October 2002 16:40 To: Multiple recipients of list ORACLE-L I'm not sure about the upgrade from WinNT to Win2K, but the easiest remedy for the DB not auto-starting is to delete and re-create the service. You can use ORADIM, and then while re-creating the service, you can use option of autostart. Regards Naveen Hi Yes, that's part of the problem/original bug where oradim could not recreate the service after deleting it. You need to reboot. Here is the bug 1266248 Problem is with the call that is made to ORADIM.EXE by the service when the registry entry ora_sid_autostart=true. Oradim hangs, the service is shown to be in status 'starting' and the service oracleservicesid cannot be stopped. ORACLE.EXE must be killed from Task Manager, and ORADIM.EXE cannot be killed.Setting reg entry ora_sid_autostart=false, and rebooting, resolves the issue, leaving us, of course, without an aotostart option. It is worth noting that dispite the status of the service, the database can be started and stopped manually from Server Manager. The error is only on the service attempting to autostart the database. We removed and rebuilt oracleservicesid using Oradim, and this fixed the problem temporarily. We were able to use the service to start/stop, until a reboot, after which the same problem occurs. I was just off the phone with Oracle, and was advised to start another tar... Thanks bob -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bishop Lewis INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: SET ORACLE-L NOMAIL
Ist hier die Geschichte einer reizenden Dame, die herauf drei sehr reizende Mädchen holte. Alle hatten Haar des Goldes, wie ihre Mutter, des jüngsten in den Wellungen. Ist hier der Speicher, eines Mannes, der Brady genannt wird, der mit drei Jungen von seinen Selbst beschäftigt war, sie waren vier Männer und zusammen lebt alle, dennoch waren sie ganz allein. Bis das eintägige, als die Dame diesen Gefährten traf und sie es waren viel mehr als ein hunch kannten, würde diese diese Gruppe irgendwie eine Familie bilden. Die ist die Weise wir, die alle das Brady Bündel wurden. Das Brady Bündel, das ist die Weise wir, die alle das Brady Bündel wurden. Rough translation, of course. I'm only 1/2 German. :) Rich -Original Message- From: Stefan Lindenmeyer [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 16, 2002 12:34 AM To: Multiple recipients of list ORACLE-L Subject: RE: SET ORACLE-L NOMAIL Hilfe ?! Für oder gegen was ? Gruss sfl Stefan Lindenmeyer -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
AW: Problem installing Oracle 8.1.7 on Windows 2000
Check if a Listener Service is installed and running, if not, try to create a Listener Service with the Net8 Configuration Assistant. This doesn't solve the jrew problem, but you get your database running. HTH Volker Schoen E-Mail: mailto:[EMAIL PROTECTED] http://www.inplan.de -Ursprüngliche Nachricht- Von: Bishop Lewis [mailto:[EMAIL PROTECTED]] Gesendet: Mittwoch, 16. Oktober 2002 17:55 An: Multiple recipients of list ORACLE-L Betreff: RE: Problem installing Oracle 8.1.7 on Windows 2000 I know you're getting loads of small tips and hints rather than solutions but here's another - I've only seen jrew go to 100% cpu when there was insufficient memory available... Lewis Bishop --- Barclays Enable - ISS - E-NTRUST/Bexleyheath NT Oracle Database Consultant Watling Street, Bexleyheath, Kent, DA6 7RR (Mail Van R) Phone : 020 8298 3418 Mobile: 07950 380857 Email : [EMAIL PROTECTED] Enabling Competitive Advantage for Barclays in IT and Business Processing -Original Message- Sent: 16 October 2002 16:19 To: Multiple recipients of list ORACLE-L This header confirms that this email message has been swept for the presence of computer viruses. Corporate IT THE WOOLWICH -- Are you installing from the console? Trying to install from a terminal server session can give those kinds of problems on 2000. HTH, Beth -Original Message- Sent: Wednesday, October 16, 2002 10:34 AM To: Multiple recipients of list ORACLE-L Hi, I am installing Oracle 8.1.7 on a MS Windows 2000 SP 3 system. When I get to the Net8 Configuration assistant, process jrew.exe goes to 100% of the CPU. I have let it run for over 15 minutes before stopping it from the Oracle installer. The process stops using the CPU but the Oracle installer hangs. I have to cancel the installer. If I try to create a database, I get a TNS adapter error. I have installed 8.1.7 on Windows NT without a problem. I have opened a TAR. Anyone experience this problem? Any help will be greatly appreciated. Thanks. Larry Noble DBA Medrad Inc -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Noble, Larry H. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seefelt, Beth INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bishop Lewis INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Any way to see the currently running SQL in one session.
select sql_text from v$sqltext t1, v$session t2 where t2.sid = sid and t1.address = t2.sql_address order by t1.piece / --- Chuan Zhang [EMAIL PROTECTED] wrote: Dear ALL, Is there any way to see the currently running SQL in one session? I used v$open_cursor, but there might be many SQL statements, I don't know which one is currently running. And more, if I execute a stored procedure, which SQL statements could be seen in v$open_cursor? Any clues would be much appreciated. TIA Chuan Unless otherwise stated, this e-mail does not represent the views of TransACT Communications Pty Limited. This text and any attachments of this e-mail are confidential and may be legally privileged. This email is for the use of the intended recipient only. If you are not the intended recipient do not take any action in relation to this email, other than to notify TransACT Communications by replying to this e-mail and destroying the original communication. Except as required by law, TransACT Communications does not represent that this transmission is free of errors, viruses or interference. __ Do you Yahoo!? Faith Hill - Exclusive Performances, Videos More http://faith.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Baumgartel INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
AW: Drop snapshot ORA-03113
Create user x, drop objects, drop user x Volker Schoen E-Mail: mailto:[EMAIL PROTECTED] http://www.inplan.de -Ursprüngliche Nachricht- Von: Vladimir Barac [mailto:[EMAIL PROTECTED]] Gesendet: Mittwoch, 16. Oktober 2002 17:49 An: Multiple recipients of list ORACLE-L Betreff: Drop snapshot ORA-03113 Good day to all 8.1.7.4 Ent. edition on Windows NT4/SP5 I have performed fromuser = X / touser = Y import and (at a first glance) everything is fine, as it is supposed to be. But... I have noticed that there are some snapshots and one refresh group in database now, that belong to the user X - but user X does not exit in db where import is performed. Since I don't need those snapshots, I try to drop (as sys user) those snapshots and group and then I get ORA-03113. What is going on? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vladimir Barac INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Drop snapshot ORA-03113 - part 2
Have you tried execute sys.dbms_ijob.remove(xx); An undocumented provedure that I picked up on from this list a few weeks ago John -Original Message- Sent: 16 October 2002 17:04 To: Multiple recipients of list ORACLE-L DBA_JOBS shows that there is job associated with phantom refresh group. Can't remove job because user that owns it does not exist (remember fromuser/touser). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vladimir Barac INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Access with ACCESS
Laura, How will you stop someone spooling the output as csv and then load them into access? If they have the access to the data, they'll always find a work-around, no matter what you try Regards Naveen -Original Message- Sent: Wednesday, October 16, 2002 9:10 PM To: Multiple recipients of list ORACLE-L Unfortunately, not really. If your Oracle version is at least 8i (you don't say which you're using), you could create a LOGON trigger where you could glean the PROGRAM variable set by the client. The problem with this is that MS can sometimes have very long path names to get to MSACCESS.EXE, which will then be truncated by the PROGRAM size of 50 chars (or is it 64?). And different versions of Winders puts the forsaken tool in different locations. You could *mostly* prevent ACCESS from access, but it can never be 100%. Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- Sent: Tuesday, October 15, 2002 5:59 PM To: Multiple recipients of list ORACLE-L How do I stop users from accessing Oracle tables with Access? They have rights to the tables in Oracle and should have those rights, yet I do not want anyone to be able to pull the data off into an access database. Is it possible to stop this without taking their privileges to the Oracle tables away? Thank you, Laura -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Naveen Nahata INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Need help from anybody using veritas netbackup on Nt
Arun, We use Veritas Netbackup to backup the database. IT LIES when is says that it is backing it up without a lock. Work with your vendor to get it straightened out if you can. The Oracle agent will effectivly perform the hot backups and work with netbackup to copy the datafiles that are in the hot backup mode. We perform cold backups each night but if the backup has not completed on the database server when it is restarted AND netbackup performs a backup of a datafile that the database wants to use the netbackup has it locked and the database will take it offline. Datafile recovery is then needed to get the database working again. There should have been an Oralce Agent purchased for the server to allow the hot backup the function. Read the manual and setup procedures completely. We could'nt get it to work on a hybrid NT, Novell network. Ron ROR mª¿ªm [EMAIL PROTECTED] 10/16/02 10:43AM netbackup has an Oracle agent that should be installed as part of the netbackup installation. I know they had installed it for the Unix servers when I was there. Rachel --- Arun Chakrapanirao [EMAIL PROTECTED] wrote: No they are just using the open file option is there any other oracle agent apart from the oracle intelligent agent which you are talking about, Please let me know Thanks -Original Message- Sent: Wednesday, October 16, 2002 8:59 AM To: Multiple recipients of list ORACLE-L Are you using the Oracle Agent to backup the DB files or you are just using the open file option? Regards Naveen -Original Message- Sent: Wednesday, October 16, 2002 5:44 PM To: Multiple recipients of list ORACLE-L Hi, We are facing problems during veritas net backup of oracle database on Nt, The database comes down crashing saying the log file is locked, How can we solve this probs, has anybody faced this probs and if so can you please let me know how to solve this issue. I cannot bring this down during backup cause this is a 24x7 database. So please let me know if any one of you have found a solution to this issue. Thanks in advance. arun __ Do you Yahoo!? Faith Hill - Exclusive Performances, Videos More http://faith.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Drop snapshot ORA-03113 - part 2
See if SYS.DBMS_IJOB.REMOVE(job_id) or
SYS.DBMS_IJOB.DROP_USER_JOBS('USERNAME') works
Regards
Naveen
-Original Message-
Sent: Wednesday, October 16, 2002 9:34 PM
To: Multiple recipients of list ORACLE-L
DBA_JOBS shows that there is job associated with phantom refresh group.
Can't remove job because user that owns it does not exist (remember
fromuser/touser).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Vladimir Barac
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Naveen Nahata
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
RE: Drop snapshot ORA-03113
We have logged a TAR with Oracle regarding this type of scenario except the client in NT and the server is Sun. They are in the process of reviewing the trace file we sent. Everyones hunch is that its a network issue. You should be able to reproduce it at with with various type of DDL. (eg. DROP USER blah;) -Original Message- Sent: Wednesday, October 16, 2002 8:49 AM To: Multiple recipients of list ORACLE-L Good day to all 8.1.7.4 Ent. edition on Windows NT4/SP5 I have performed fromuser = X / touser = Y import and (at a first glance) everything is fine, as it is supposed to be. But... I have noticed that there are some snapshots and one refresh group in database now, that belong to the user X - but user X does not exit in db where import is performed. Since I don't need those snapshots, I try to drop (as sys user) those snapshots and group and then I get ORA-03113. What is going on? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vladimir Barac INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Johnson, Michael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Need help from anybody using veritas netbackup on Nt
If the NT admins are backing up up your data files, there is a high probability that your files are getting locked by that. You must tell the admins not to backup any file system ... er "folder" ... that contains files used by the Oracle instance. In other words, your problem might have nothing to do with your backup stuff, but somebody else's backup stuff. You must understand that NT is still a single-user operating system. It doesn't understand the concept of having multiple users doing their own thing, in their own slice of turf,on the box. If it wants to lock a file, it will do so assuming that, since it wants to use the file, nobody else needs to use it. Which is why we moved all of our Oracle databases off NT. NT = Neanderthal Technology -Original Message-From: Arun Chakrapanirao [mailto:[EMAIL PROTECTED]]Sent: Wednesday, October 16, 2002 7:14 AMTo: Multiple recipients of list ORACLE-LSubject: Need help from anybody using veritas netbackup on Nt Hi, We are facing problems during veritas net backup of oracle database on Nt, The database comes down crashing saying the log file is locked, How can we solve this probs, has anybody faced this probs and if so can you please let me know how to solve this issue. I cannot bring this down during backup cause this is a 24x7 database. So please let me know if any one of you have found a solution to this issue. Thanks in advance. arun
[ST-GSPUSER.US@oracle.com: Updated Security Alert #42 patch]
These people are really irritating? Not only do they release bad patches, they don't provide a checksum on the patch files. I have to play a guessing game as to when a file was downloaded. I've seen better support from high school students (literally). What a bunch of amateurs! Those last two sentences would not be included if oracle would provide a checksum for the zip files. It is a fundamental aspect of internet file serving. It provides another level of security and in this case clarity. I can see making mistakes in the code, but to not provide this level of service when it is so easily done is not unforgivable. Anybody at oracle listening? geez, Louis! - Forwarded message from ST-GSPUSER.US [EMAIL PROTECTED] - Date: Wed, 16 Oct 2002 07:57:42 -0700 To: [EMAIL PROTECTED] X-Mailer: Microsoft Outlook IMO, Build 9.0.2416 (9.0.2911.0) According to our records, you have downloaded patch 2540219 for Security Alert #42. If you downloaded the patch for Security Alert #42 (Bug 2540219) prior to the reload date in the table below and have previously installed the patch for Security Alert 40 (bug 2395416), you must re-download and re-apply the patch for Security Alert 42. The updated patch resolves a conflict between the patches for Security Alerts #40 and #42. Platform Version Reload Date HP Alpha OpenVMS 8.1.7.3 09-OCT-2002 HP Alpha OpenVMS 9.0.1.3 09-OCT-2002 HP Tru64 UNIX 8.1.7.4 10-OCT-2002 HP Tru64 UNIX 9.2.0.1 09-OCT-2002 HP-UX 11.0/32 bit 8.1.7.4 10-OCT-2002 HP 9000 Series HP-UX 64bit 8.1.7.4 10-OCT-2002 HP 9000 Series HP-UX 64bit 9.2.0.1 09-OCT-2002 IBM RS/6000 AIX 8.1.7.4 10-OCT-2002 IBM RS/6000 AIX 64-bit 8.1.7.4 10-OCT-2002 IBM RS/6000 AIX 64-bit 9.2.0.1 09-OCT-2002 IBM AIX Based Systems (64-bit) 5L 9.2.0.1 09-OCT-2002 IBM OS/390 (MVS) 8.1.7.4 08-OCT-2002 IBM OS/390 (MVS) 9.0.1.2 08-OCT-2002 IBM OS/390 (MVS) 9.2.0.1 08-OCT-2002 LINUX Intel 8.1.7.4 10-OCT-2002 LINUX Intel 9.2.0.1 09-OCT-2002 Sun Solaris OS (SPARC) 8.1.7.4 10-OCT-2002 Sun Solaris OS (SPARC) 9.2.0.1 09-OCT-2002 Sun Solaris OS (SPARC) 64-bit 8.1.7.4 10-OCT-2002 Sun Solaris OS (SPARC) 64-bit 9.2.0.1 09-OCT-2002 No action is required if you meet at least one of the following conditions: ? You applied none, or only one of the patches. ? Your platforms or versions are not listed in the above table. ? You downloaded patch 2540219 after the dates listed in the table. On behalf of Oracle, we apologize for any inconvenience this may cause. Regards, Oracle Support Services - End forwarded message - -- === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: SET ORACLE-L NOMAIL
Now what does all of this mean? At 08:14 AM 10/16/02 -0800, you wrote: Ist hier die Geschichte einer reizenden Dame, die herauf drei sehr reizende Mädchen holte. Alle hatten Haar des Goldes, wie ihre Mutter, des jüngsten in den Wellungen. Ist hier der Speicher, eines Mannes, der Brady genannt wird, der mit drei Jungen von seinen Selbst beschäftigt war, sie waren vier Männer und zusammen lebt alle, dennoch waren sie ganz allein. Bis das eintägige, als die Dame diesen Gefährten traf und sie es waren viel mehr als ein hunch kannten, würde diese diese Gruppe irgendwie eine Familie bilden. Die ist die Weise wir, die alle das Brady Bündel wurden. Das Brady Bündel, das ist die Weise wir, die alle das Brady Bündel wurden. Rough translation, of course. I'm only 1/2 German. :) Rich -Original Message- From: Stefan Lindenmeyer [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 16, 2002 12:34 AM To: Multiple recipients of list ORACLE-L Subject: RE: SET ORACLE-L NOMAIL Hilfe ?! Für oder gegen was ? Gruss sfl Stefan Lindenmeyer -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). ** Scott Stefick UNIX Systems Administrator Oracle Certified Professional DBA Wm. Rainey Harper College 847.925.6130 ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Scott Stefick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: SET ORACLE-L NOMAIL
The Brady Bunch theme in german. LMAO -Original Message- Sent: Wednesday, October 16, 2002 11:14 AM To: Multiple recipients of list ORACLE-L Ist hier die Geschichte einer reizenden Dame, die herauf drei sehr reizende Mädchen holte. Alle hatten Haar des Goldes, wie ihre Mutter, des jüngsten in den Wellungen. Ist hier der Speicher, eines Mannes, der Brady genannt wird, der mit drei Jungen von seinen Selbst beschäftigt war, sie waren vier Männer und zusammen lebt alle, dennoch waren sie ganz allein. Bis das eintägige, als die Dame diesen Gefährten traf und sie es waren viel mehr als ein hunch kannten, würde diese diese Gruppe irgendwie eine Familie bilden. Die ist die Weise wir, die alle das Brady Bündel wurden. Das Brady Bündel, das ist die Weise wir, die alle das Brady Bündel wurden. Rough translation, of course. I'm only 1/2 German. :) Rich -Original Message- From: Stefan Lindenmeyer [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 16, 2002 12:34 AM To: Multiple recipients of list ORACLE-L Subject: RE: SET ORACLE-L NOMAIL Hilfe ?! Für oder gegen was ? Gruss sfl Stefan Lindenmeyer -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Farnsworth, Dave INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Any way to see the currently running SQL in one session.
This is what I use to see what sql they are running: select c.osuser unix_user, c.process, c.username ora_user, c.sid, c.program, c.terminal, a.sql_text fromv$session c, v$sqlarea a, v$process p where p.addr = c.paddr and c.process is not NULL and c.sql_address = a.address(+) and c.sql_hash_value = a.hash_value(+) and p.spid = 1 order by c.osuser, c.process / From: ora ak [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: Any way to see the currently running SQL in one session. Date: Wed, 16 Oct 2002 08:04:09 -0800 there is a x$ table which can give u this info I am not able to recall that at the moment . oramagic Paulo Gomes [EMAIL PROTECTED] wrote:u could use top sessions -Original Message- Sent: quarta-feira, 16 de Outubro de 2002 2:28 To: Multiple recipients of list ORACLE-L Dear ALL, Is there any way to see the currently running SQL in one session? I used v$open_cursor, but there might be many SQL statements, I don't know which one is currently running. And more, if I execute a stored procedure, which SQL statements could be seen in v$open_cursor? Any clues would be much appreciated. TIA Chuan -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paulo Gomes INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). - Do you Yahoo!? Faith Hill - Exclusive Performances, Videos, more faith.yahoo.com _ Internet access plans that fit your lifestyle -- join MSN. http://resourcecenter.msn.com/access/plans/default.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 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: How to configure MD5 data encription in Oracle 8i
I want to do it other way, generate the password in Database. Send the generated password to user and encrypt and store in table. Next time user will log in password will be encrypted on client side only and validated with database table. I heard MD5 hashing is supported by Oracle 8I but I don't know how to configure. Thanks Suman - Shailendra Kr. Suman Mascot System Limited No.1, Main Road, Jakkasandra Off Sarjapur Road Koramangala Extn Bangalore - 560034 Tel: 91-80-5521701/5521706 Ext-2065 Mobile: 9845045895 - -Original Message- From: ora ak [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, October 16, 2002 9:40 PM To: Multiple recipients of list ORACLE-L Subject:Re: How to configure MD5 data encription in Oracle 8i why not use encryption outside the database and store encrypted string in database . We do it all the time , java application does the encrytion and authentication , db just stores the encrypted string . Just an idea . I dont the answer of your original question :) Oramagic Suman S K [EMAIL PROTECTED] wrote: Hi Everybody, Can anyone tell me how to use MD5 hashing algorithm in Oracle8I Or is there any built in package to encrypt the data in Oracle 8i. I have created the Application user table there I am keeping user_Id and Password for the application. How to hide the password column in the table ? Thanks Suman DISCLAIMER: Information contained and transmitted by this E-MAIL is proprietary to Mascot Systems Limited and is intended for use only by the individual or entity to which it is addressed, and may contain information that is privileged, confidential or exempt from disclosure under applicable law. If this is a forwarded message, the content of this E-MAIL may not have been sent with the authority of the Company. If you are not the intended recipient, an agent of the intended recipient or a person! ! responsible for delivering the information to the named recipient, you are notified that any use, distribution, transmission, printing, copying or dissemination of this information in any way or in any manner is strictly prohibited. If you have received this communication in error, please delete this mail notify us immediately at [EMAIL PROTECTED] Before opening attachments, please scan for viruses. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Suman S K INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-! ! L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Do you Yahoo!? Faith Hill http://faith.yahoo.com - Exclusive Performances, Videos, more faith.yahoo.com http://faith.yahoo.com DISCLAIMER: Information contained and transmitted by this E-MAIL is proprietary to Mascot Systems Limited and is intended for use only by the individual or entity to which it is addressed, and may contain information that is privileged, confidential or exempt from disclosure under applicable law. If this is a forwarded message, the content of this E-MAIL may not have been sent with the authority of the Company. If you are not the intended recipient, an agent of the intended recipient or a person responsible for delivering the information to the named recipient, you are notified that any use, distribution, transmission, printing, copying or dissemination of this information in any way or in any manner is strictly prohibited. If you have received this communication in error, please delete this
RE: Problem installing Oracle 8.1.7 on Windows 2000
Problem solved. I was using terminal service to install remotely. Installing from the console worked. Thanks for all the suggestions. Larry -Original Message- Sent: Wednesday, October 16, 2002 12:14 PM To: Multiple recipients of list ORACLE-L Check if a Listener Service is installed and running, if not, try to create a Listener Service with the Net8 Configuration Assistant. This doesn't solve the jrew problem, but you get your database running. HTH Volker Schoen E-Mail: mailto:[EMAIL PROTECTED] http://www.inplan.de -Ursprüngliche Nachricht- Von: Bishop Lewis [mailto:[EMAIL PROTECTED]] Gesendet: Mittwoch, 16. Oktober 2002 17:55 An: Multiple recipients of list ORACLE-L Betreff: RE: Problem installing Oracle 8.1.7 on Windows 2000 I know you're getting loads of small tips and hints rather than solutions but here's another - I've only seen jrew go to 100% cpu when there was insufficient memory available... Lewis Bishop --- Barclays Enable - ISS - E-NTRUST/Bexleyheath NT Oracle Database Consultant Watling Street, Bexleyheath, Kent, DA6 7RR (Mail Van R) Phone : 020 8298 3418 Mobile: 07950 380857 Email : [EMAIL PROTECTED] Enabling Competitive Advantage for Barclays in IT and Business Processing -Original Message- Sent: 16 October 2002 16:19 To: Multiple recipients of list ORACLE-L This header confirms that this email message has been swept for the presence of computer viruses. Corporate IT THE WOOLWICH -- Are you installing from the console? Trying to install from a terminal server session can give those kinds of problems on 2000. HTH, Beth -Original Message- Sent: Wednesday, October 16, 2002 10:34 AM To: Multiple recipients of list ORACLE-L Hi, I am installing Oracle 8.1.7 on a MS Windows 2000 SP 3 system. When I get to the Net8 Configuration assistant, process jrew.exe goes to 100% of the CPU. I have let it run for over 15 minutes before stopping it from the Oracle installer. The process stops using the CPU but the Oracle installer hangs. I have to cancel the installer. If I try to create a database, I get a TNS adapter error. I have installed 8.1.7 on Windows NT without a problem. I have opened a TAR. Anyone experience this problem? Any help will be greatly appreciated. Thanks. Larry Noble DBA Medrad Inc -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Noble, Larry H. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seefelt, Beth INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bishop Lewis INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official
Re: Difference - Rebuild and Analyze index
At least on my DB's doing ALTER INDEX index_name REBUILD does in fact
populate the statistics.
I discovered this by accident on one RBO DB which started giving poor
performnce after doing some
REBUILDs (OPTOMIZER_MODE=CHOOSE).
ora ak
ora_magic@yahoo.To: Multiple recipients of list
ORACLE-L [EMAIL PROTECTED]
com cc:
Sent by: Subject: Re: Difference - Rebuild and
Analyze index
[EMAIL PROTECTED]
10/16/2002 08:49
AM
Please respond to
ORACLE-L
Yes Marul , I think there is a big differenece in them . When you are
rebulding the index means you are re-organzing the entries in the index ,
may be removing the entries for the rows deleted in past and so forth so
on. But this doesn't generate any statistics about index.
When you analyze index, you generate information ( statistics) about the
data in index , like leaf blocks or depth of index etc.
None of these should require orther , but they have some effect .
Like if you rebuild index , after that you dont have latest statistics and
queries may not perform upto mark .
-oramagic
Marul Mehta [EMAIL PROTECTED] wrote:
Hi,
Can anybody please tell me the difference between -
SQL execute DBMS_UTILITY.ANALYZE_SCHEMA('BLAH','COMPUTE',NULL,30,'FOR
ALL INDEXES');
and
SQL select 'ALTER INDEX ' || INDEX_NAME || ' REBUILD ONLINE;' from
USER_INDEXES
If I execute any one the above do i need to execute the other also?
After how many days/hour it should be executed.
TIA,
Marul.
Do you Yahoo!?
Faith Hill - Exclusive Performances, Videos, more
faith.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
RE: Can I index this query? slightly OT-just InterMedia Text option
Jesse, since you o have such a good experience, could you please comment on the following: I have installed InterMedia Text (8.1.7 on Win2K sp.2) and 400MB has grown to 4.5 GB. There are 4 required indices, two for each table - on English and French version of varchar2(2000). Number of data base objects (user + ctxsys schemas) is 4 times larger. Search is perfect, inserts are using 100% CPU and killing the server. What have I done wrong? Do you have any idea? By the way, I have read TFM. TIA inka -Original Message- Sent: Wednesday, October 16, 2002 12:04 PM To: Multiple recipients of list ORACLE-L I don't think it's really that big of a step. Until a rewrite of our 3rd-party inventory system (i.e. we didn't write the damn thing), we have to rely on part description stored in two separate tables (don't ask!) in order to search for parts. By installing and adding a Context/Intermedia/Text/whateverthehell index, we've gone from a two-table FTS (200K total rows on moderately wide tables) to sub-second index access. The difficulties in getting to this point are: 1) Understanding Oracle Text concepts. Read the book! 2) Being able to change the SQL to use the OText special CONTAINS clause. 3) Understanding the data to be able to setup your thesaurus correctly. 4) Determining if/when to rebuild the index. It took me about a week of research and testing before installing and using it (of course that week's work was spread over three weeks!), and a day or two of tweaks afterwards. In my case, I needed to also create some replication-like triggers and tables to combine data from our two tables into a single, indexable, searchable table. Fire it up! We've been pretty happy with the results (except when a user wants to return every row with a Z in the string...sigh). GL! :) Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA Judge: ...and I'm no slouch myself. Ty: Don't sell yourself short, Judge. You're a tremendous slouch. -Original Message- From: Connor McDonald [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 16, 2002 4:24 AM To: Multiple recipients of list ORACLE-L Subject: Re: Can I index this query? You could always consider something like OracleText to assist with these kind of searches, but thats a big step.. hth connor --- Carle, William T (Bill), ALCAS [EMAIL PROTECTED] wrote: Howdy, I have a table that has almost 2 million rows called eventqueueentry. The layout looks like this: Name Null? Type - EVENTID NOT NULL NUMBER(10) VER NOT NULL NUMBER(10) QUEUETYPE NOT NULL CHAR(16) PUBLISHER NOT NULL CHAR(16) CREATETIMENOT NULL DATE LASTREADTIME DATE REMOVETIME DATE CONTENTS NOT NULL VARCHAR2(4000) The users do a query that looks like this: SELECT EventId, QueueType, Publisher, CreateTime, LastReadTime, RemoveTime, Contents, Ver from EventQueueEntry where QueueType = 'CodeUpdate' AND Contents LIKE '%TrackingEventId=27668677%' ORDER BY EventId The queuetype field has only 3 different values. The value in the contents field is close to being unique (high cardinality) but, as you can see, they are picking off a value somewhere in the middle of a varchar2(4000) field. Understandably, their query is slow. Is there anything I can do with an index to speed this up? Bill Carle -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Inka Bezdziecka INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
Re: Difference - Rebuild and Analyze index
What version of database and OS? I never found this behaviour? on 7.3.4.5 on
HP 11...
Regards
Rafiq
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Date: Wed, 16 Oct 2002 09:43:51 -0800
At least on my DB's doing ALTER INDEX index_name REBUILD does in fact
populate the statistics.
I discovered this by accident on one RBO DB which started giving poor
performnce after doing some
REBUILDs (OPTOMIZER_MODE=CHOOSE).
ora ak
ora_magic@yahoo.To: Multiple
recipients of list ORACLE-L [EMAIL PROTECTED]
com cc:
Sent by: Subject: Re: Difference -
Rebuild and Analyze index
[EMAIL PROTECTED]
10/16/2002 08:49
AM
Please respond to
ORACLE-L
Yes Marul , I think there is a big differenece in them . When you are
rebulding the index means you are re-organzing the entries in the index ,
may be removing the entries for the rows deleted in past and so forth so
on. But this doesn't generate any statistics about index.
When you analyze index, you generate information ( statistics) about the
data in index , like leaf blocks or depth of index etc.
None of these should require orther , but they have some effect .
Like if you rebuild index , after that you dont have latest statistics and
queries may not perform upto mark .
-oramagic
Marul Mehta [EMAIL PROTECTED] wrote:
Hi,
Can anybody please tell me the difference between -
SQL execute DBMS_UTILITY.ANALYZE_SCHEMA('BLAH','COMPUTE',NULL,30,'FOR
ALL INDEXES');
and
SQL select 'ALTER INDEX ' || INDEX_NAME || ' REBUILD ONLINE;' from
USER_INDEXES
If I execute any one the above do i need to execute the other also?
After how many days/hour it should be executed.
TIA,
Marul.
Do you Yahoo!?
Faith Hill - Exclusive Performances, Videos, more
faith.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
_
Surf the Web without missing calls! Get MSN Broadband.
http://resourcecenter.msn.com/access/plans/freeactivation.asp
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Mohammad Rafiq
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Multiple Listeners
DBAs, Any quick start guides / scripts / notes for having multiple version listeners on same Solaris box? Scenario : I am in process of upgrading. There are two databases on a machine db6 and db7 db6 - 8.1.6 db7 - 8.1.6 db6 and db7 use the listener of version 8.1.6 Now, db7 migrated to 8.1.6 I am thinking of something like : db6 - listener of 8.1.6 (status quo) db7 - listener_817 of 8.1.7 (new version listener) Two separate listener.ora files lsnrctl status listener (for 8.1.6 listener) lsnrctl status listener_817 (for 8.1.7 listener) Thanks in advance, -Rachna -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachna Vaidya INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
ETL architecture
Hi, On all DW project I've been, the ETL tool was on the database server containing the DW database. On the current project, the architecture team has decided that the ETL tool (Data Junction) will be on its own server (Windows) to service all projects needing ETL processing. We are the first client of this approach. All sources will ftp their files on the unix box where the staging/data integration database is. So that means that the the ETL tool on server A will read the files and the reference tables from server B, process that on server A and insert the cleansed data on server B. Somewhere I'm not confortable with that approach. Any comments ? = Stéphane Paquette DBA Oracle, consultant entrepôt de données Oracle DBA, datawarehouse consultant [EMAIL PROTECTED] __ Lèche-vitrine ou lèche-écran ? magasinage.yahoo.ca -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?paquette=20stephane?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Multiple Listeners
1st thing i do when upgrading db's on a server is to start using the new listener. just have your 816 db's use the 817 listener. hth, gene [EMAIL PROTECTED] 10/16/02 02:12PM DBAs, Any quick start guides / scripts / notes for having multiple version listeners on same Solaris box? Scenario : I am in process of upgrading. There are two databases on a machine db6 and db7 db6 - 8.1.6 db7 - 8.1.6 db6 and db7 use the listener of version 8.1.6 Now, db7 migrated to 8.1.6 I am thinking of something like : db6 - listener of 8.1.6 (status quo) db7 - listener_817 of 8.1.7 (new version listener) Two separate listener.ora files lsnrctl status listener (for 8.1.6 listener) lsnrctl status listener_817 (for 8.1.7 listener) Thanks in advance, -Rachna -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachna Vaidya INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gene Sais INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Multiple Listeners
You can use the 'higher' version of the listener for all databases running on = higher version, unless you need multiple listeners for other reasons Net8 Admin Guide should have enough information. - Kirti -Original Message- Sent: Wednesday, October 16, 2002 1:13 PM To: Multiple recipients of list ORACLE-L DBAs, Any quick start guides / scripts / notes for having multiple version listeners on same Solaris box? Scenario : I am in process of upgrading. There are two databases on a machine db6 and db7 db6 - 8.1.6 db7 - 8.1.6 db6 and db7 use the listener of version 8.1.6 Now, db7 migrated to 8.1.6 I am thinking of something like : db6 - listener of 8.1.6 (status quo) db7 - listener_817 of 8.1.7 (new version listener) Two separate listener.ora files lsnrctl status listener (for 8.1.6 listener) lsnrctl status listener_817 (for 8.1.7 listener) Thanks in advance, -Rachna -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachna Vaidya INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Multiple Listeners
Rachna, Do yourself a favor - use the most recent listener for all databases. Have only one listener running on a machine and use that for all databases on that machine. In your case, use the 817 listener. In the long run, it will be much easier and less confusing. Hope this helps. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Wednesday, October 16, 2002 2:13 PM To: Multiple recipients of list ORACLE-L DBAs, Any quick start guides / scripts / notes for having multiple version listeners on same Solaris box? Scenario : I am in process of upgrading. There are two databases on a machine db6 and db7 db6 - 8.1.6 db7 - 8.1.6 db6 and db7 use the listener of version 8.1.6 Now, db7 migrated to 8.1.6 I am thinking of something like : db6 - listener of 8.1.6 (status quo) db7 - listener_817 of 8.1.7 (new version listener) Two separate listener.ora files lsnrctl status listener (for 8.1.6 listener) lsnrctl status listener_817 (for 8.1.7 listener) Thanks in advance, -Rachna -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachna Vaidya INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Multiple Listeners
-Original Message-
Any quick start guides / scripts / notes for having multiple version
listeners on same Solaris box?
It works fine. Here is an example of some commands to put into a general
Oracle startup script.
export ORACLE_BASE=/oracle/app/oracle
export LOGFILE=${ORACLE_BASE}/log/ora-startup.log
exec $LOGFILE 21
touch $LOGFILE
chmod a+r $LOGFILE
print \nStarting ora-startup
date
# Automatically export all variables
set -a
# Start the databases
$ORACLE_BASE/admin/dbascripts/init.d/dbstart
# Start the listeners
export ORACLE_HOME=$ORACLE_BASE/product/9.2.0
$ORACLE_HOME/bin/lsnrctl start LIST_V920
export ORACLE_HOME=$ORACLE_BASE/product/9.0.1
$ORACLE_HOME/bin/lsnrctl start LIST_V901
#Start the listeners
export ORACLE_HOME=$ORACLE_BASE/product/8.1.7
$ORACLE_HOME/bin/lsnrctl start LIST_DSNR4
$ORACLE_HOME/bin/lsnrctl start LIST_V817
$ORACLE_HOME/bin/lsnrctl start LIST_V817_2
export ORACLE_HOME=$ORACLE_BASE/product/8.1.7.4
$ORACLE_HOME/bin/lsnrctl start LIST_V8174
etc.
etc.
etc.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Stephen Lee
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Re:Access with ACCESS
Laura, I have to admit to having the Access virus here as well. Most of the end users of Access simply use pass through queries or attach the tables which is not too bad. Access provides an easy interface for end users to get at data, so that makes my life easier as well. What I really do not appreciate is when users create Access tables that are copies of Oracle data because sooner or later (sooner no doubt) these static tables become stale and then the real battles start. At least here the decision makers are smart enough to ask the question of where did the data come from in the case of the report/graph that does not pass the sniff test. Dick Goulet Reply Separator Author: Burton; Laura L. [EMAIL PROTECTED] Date: 10/15/2002 2:58 PM How do I stop users from accessing Oracle tables with Access? They have rights to the tables in Oracle and should have those rights, yet I do not want anyone to be able to pull the data off into an access database. Is it possible to stop this without taking their privileges to the Oracle tables away? Thank you, Laura !DOCTYPE HTML PUBLIC -//W3C//DTD HTML 3.2//EN HTML HEAD META HTTP-EQUIV=Content-Type CONTENT=text/html; charset=us-ascii META NAME=Generator CONTENT=MS Exchange Server version 5.5.2654.45 TITLEAccess with ACCESS/TITLE /HEAD BODY P ALIGN=LEFTA NAME=_MailAutoSigFONT SIZE=2 FACE=ArialHow do I stop users from accessing Oracle tables with Access/FONT/AFONT SIZE=2 FACE=Arial?/FONTFONT SIZE=2 FACE=Arialnbsp; They have rights to the tables in Oracle and should have those rights, yet I do not want anyone to be able to pull the data off into an access database./FONTFONT SIZE=2 FACE=Arialnbsp; Is it possible to stop this without taking their privileges to the Oracle tables away?/FONT/P P ALIGN=LEFTFONT SIZE=2 FACE=ArialThank you,/FONT/P P ALIGN=LEFTFONT SIZE=2 FACE=ArialLaura/FONTB/BB/B/P P ALIGN=LEFT/P /BODY /HTML -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: [ST-GSPUSER.US@oracle.com: Updated Security Alert #42 patch]
Let me get this straight, they know I downloaded the patch but they don't know when/which? Maybe they could use Microsoft SQL Server to keep track of this information. Maybe they could do something really advanced like put a version number in the readme. OK, I'm done. Thanks for listening ;) Get it, listening! I get no respect On Wed, Oct 16, 2002 at 09:14:39AM -0800, Ray Stell wrote: These people are really irritating? Not only do they release bad patches, they don't provide a checksum on the patch files. I have to play a guessing game as to when a file was downloaded. I've seen better support from high school students (literally). What a bunch of amateurs! Those last two sentences would not be included if oracle would provide a checksum for the zip files. It is a fundamental aspect of internet file serving. It provides another level of security and in this case clarity. I can see making mistakes in the code, but to not provide this level of service when it is so easily done is not unforgivable. Anybody at oracle listening? geez, Louis! - Forwarded message from ST-GSPUSER.US [EMAIL PROTECTED] - Date: Wed, 16 Oct 2002 07:57:42 -0700 To: [EMAIL PROTECTED] X-Mailer: Microsoft Outlook IMO, Build 9.0.2416 (9.0.2911.0) According to our records, you have downloaded patch 2540219 for Security Alert #42. If you downloaded the patch for Security Alert #42 (Bug 2540219) prior to the reload date in the table below and have previously installed the patch for Security Alert 40 (bug 2395416), you must re-download and re-apply the patch for Security Alert 42. The updated patch resolves a conflict between the patches for Security Alerts #40 and #42. Platform Version Reload Date HP Alpha OpenVMS 8.1.7.3 09-OCT-2002 HP Alpha OpenVMS 9.0.1.3 09-OCT-2002 HP Tru64 UNIX 8.1.7.4 10-OCT-2002 HP Tru64 UNIX 9.2.0.1 09-OCT-2002 HP-UX 11.0/32 bit 8.1.7.4 10-OCT-2002 HP 9000 Series HP-UX 64bit 8.1.7.4 10-OCT-2002 HP 9000 Series HP-UX 64bit 9.2.0.1 09-OCT-2002 IBM RS/6000 AIX 8.1.7.4 10-OCT-2002 IBM RS/6000 AIX 64-bit 8.1.7.4 10-OCT-2002 IBM RS/6000 AIX 64-bit 9.2.0.1 09-OCT-2002 IBM AIX Based Systems (64-bit) 5L 9.2.0.1 09-OCT-2002 IBM OS/390 (MVS) 8.1.7.4 08-OCT-2002 IBM OS/390 (MVS) 9.0.1.2 08-OCT-2002 IBM OS/390 (MVS) 9.2.0.1 08-OCT-2002 LINUX Intel 8.1.7.4 10-OCT-2002 LINUX Intel 9.2.0.1 09-OCT-2002 Sun Solaris OS (SPARC) 8.1.7.4 10-OCT-2002 Sun Solaris OS (SPARC) 9.2.0.1 09-OCT-2002 Sun Solaris OS (SPARC) 64-bit 8.1.7.4 10-OCT-2002 Sun Solaris OS (SPARC) 64-bit 9.2.0.1 09-OCT-2002 No action is required if you meet at least one of the following conditions: ? You applied none, or only one of the patches. ? Your platforms or versions are not listed in the above table. ? You downloaded patch 2540219 after the dates listed in the table. On behalf of Oracle, we apologize for any inconvenience this may cause. Regards, Oracle Support Services - End forwarded message - -- === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: How to configure MD5 data encription in Oracle 8i
Try DBMS_OBFUSCATION_TOOLKIT. See http://www.cybcon.com/~jkstill/util/encryption/encryption.html for an article on its use, and code samples. Jared Suman S K [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 10/16/2002 10:14 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: How to configure MD5 data encription in Oracle 8i I want to do it other way, generate the password in Database. Send the generated password to user and encrypt and store in table. Next time user will log in password will be encrypted on client side only and validated with database table. I heard MD5 hashing is supported by Oracle 8I but I don't know how to configure. Thanks Suman - Shailendra Kr. Suman Mascot System Limited No.1, Main Road, Jakkasandra Off Sarjapur Road Koramangala Extn Bangalore - 560034 Tel: 91-80-5521701/5521706 Ext-2065 Mobile: 9845045895 - -Original Message- From: ora ak [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, October 16, 2002 9:40 PM To: Multiple recipients of list ORACLE-L Subject:Re: How to configure MD5 data encription in Oracle 8i why not use encryption outside the database and store encrypted string in database . We do it all the time , java application does the encrytion and authentication , db just stores the encrypted string . Just an idea . I dont the answer of your original question :) Oramagic Suman S K [EMAIL PROTECTED] wrote: Hi Everybody, Can anyone tell me how to use MD5 hashing algorithm in Oracle8I Or is there any built in package to encrypt the data in Oracle 8i. I have created the Application user table there I am keeping user_Id and Password for the application. How to hide the password column in the table ? Thanks Suman DISCLAIMER: Information contained and transmitted by this E-MAIL is proprietary to Mascot Systems Limited and is intended for use only by the individual or entity to which it is addressed, and may contain information that is privileged, confidential or exempt from disclosure under applicable law. If this is a forwarded message, the content of this E-MAIL may not have been sent with the authority of the Company. If you are not the intended recipient, an agent of the intended recipient or a person! ! responsible for delivering the information to the named recipient, you are notified that any use, distribution, transmission, printing, copying or dissemination of this information in any way or in any manner is strictly prohibited. If you have received this communication in error, please delete this mail notify us immediately at [EMAIL PROTECTED] Before opening attachments, please scan for viruses. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Suman S K INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-! ! L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RMAN lost RECOVERY_CATALOG_OWNER after upgrade from 816 to 817
DBAs, It seems that RMAN user has lost the RECOVERY_CATALOG_OWNER role when I upgraded the catalog database from 816 to 817. I could not even connect to the database as rman user. It even lacked CREATE SESSION. I tried giving grant create session to rman; and I could connect. Later on, upon running upgrade catalog I got hundreds of error messages (mostly looked like permissions issue). After grant RECOVERY_CATALOG_OWNER to rman; upgrade catalog seemed to work fine. Has anyone experienced anything similar? Thanks, -Rachna -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachna Vaidya INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Can I index this query? slightly OT-just InterMedia Text opt
Unfortunately Inka, I don't know if I can help you. There are so many other people on this list that are much more adept at perf tuning than I, it ain't even funny. Our single OText index only takes up 70MB total, and the indexed column has very low maintenance with less than 50 inserts/updates per day (no deletes). This is fine for a 6-way HP K570, even though the CPUs are only 200Mhz PA-RISC. If I had to guess, though, I'd say most folks here would have you start with a thourough 10046 trace on the SQL. Sorry I can't be of more help! Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- From: Inka Bezdziecka [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 16, 2002 12:54 PM To: Multiple recipients of list ORACLE-L Subject: RE: Can I index this query? slightly OT-just InterMedia Text option Jesse, since you o have such a good experience, could you please comment on the following: I have installed InterMedia Text (8.1.7 on Win2K sp.2) and 400MB has grown to 4.5 GB. There are 4 required indices, two for each table - on English and French version of varchar2(2000). Number of data base objects (user + ctxsys schemas) is 4 times larger. Search is perfect, inserts are using 100% CPU and killing the server. What have I done wrong? Do you have any idea? By the way, I have read TFM. TIA inka -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Multiple Listeners
Thanks for the inputs.
This is how I did it.
1. There are two listener.ora files
/opt/app/oracle/product/816/listener.ora : FILE816
/opt/app/oracle/product/817/listener.ora : FILE817
FILE817 is a copy of FILE816
2. Entries for db7 are removed from FILE816
FILE816 listner name is left unchanged as LISTENER
FILE816 entry for IPC was left unchanged :
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
FILE816 entry for PORT was left unchanged :
(ADDRESS = (PROTOCOL = TCP)(HOST = lightening)(PORT = 1521))
3. Entries for db6 are removed from FILE817 and ORACLE_HOME path changes are
made
FILE817 listner name was changed to LISTENER_817
FILE817 entry for IPC was changed as :
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC_817))
ORACLE_HOME path changes were made to FILE817
FILE817 entry for PORT was changed as :
(ADDRESS = (PROTOCOL = TCP)(HOST = lightening)(PORT = 1526))
4. To use 816 listener
ORACLE_HOME=$/opt/app/oracle/product/816
cd $ORACLE_HOME/network/admin
$ORACLE_HOME/bin/lsnrctl stop listener
$ORACLE_HOME/bin/lsnrctl start listener
$ORACLE_HOME/bin/lsnrctl status listener
9. To use 817 listener
ORACLE_HOME=$/opt/app/oracle/product/817
cd $ORACLE_HOME/network/admin
$ORACLE_HOME/bin/lsnrctl stop listener_817
$ORACLE_HOME/bin/lsnrctl start listener_817
$ORACLE_HOME/bin/lsnrctl status listener_817
And I think I am having
a. two separate Listeners
b. for two different databases
c. in different version (having different ORACLE_HOME)
d. listening at different ports
Am I correct or there is some mistake / improvement?
Thanks for the inputs.
-Rachna
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, October 16, 2002 2:39 PM
-Original Message-
Any quick start guides / scripts / notes for having multiple version
listeners on same Solaris box?
It works fine. Here is an example of some commands to put into a general
Oracle startup script.
export ORACLE_BASE=/oracle/app/oracle
export LOGFILE=${ORACLE_BASE}/log/ora-startup.log
exec $LOGFILE 21
touch $LOGFILE
chmod a+r $LOGFILE
print \nStarting ora-startup
date
# Automatically export all variables
set -a
# Start the databases
$ORACLE_BASE/admin/dbascripts/init.d/dbstart
# Start the listeners
export ORACLE_HOME=$ORACLE_BASE/product/9.2.0
$ORACLE_HOME/bin/lsnrctl start LIST_V920
export ORACLE_HOME=$ORACLE_BASE/product/9.0.1
$ORACLE_HOME/bin/lsnrctl start LIST_V901
#Start the listeners
export ORACLE_HOME=$ORACLE_BASE/product/8.1.7
$ORACLE_HOME/bin/lsnrctl start LIST_DSNR4
$ORACLE_HOME/bin/lsnrctl start LIST_V817
$ORACLE_HOME/bin/lsnrctl start LIST_V817_2
export ORACLE_HOME=$ORACLE_BASE/product/8.1.7.4
$ORACLE_HOME/bin/lsnrctl start LIST_V8174
etc.
etc.
etc.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Stephen Lee
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Rachna Vaidya
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
RE: ETL architecture
and how are they going to connect to the database on server B? are they using odbc? millions of inserts using odbc over the network? -Original Message- From: paquette stephane [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 16, 2002 11:26 AM To: Multiple recipients of list ORACLE-L Subject: ETL architecture Hi, On all DW project I've been, the ETL tool was on the database server containing the DW database. On the current project, the architecture team has decided that the ETL tool (Data Junction) will be on its own server (Windows) to service all projects needing ETL processing. We are the first client of this approach. All sources will ftp their files on the unix box where the staging/data integration database is. So that means that the the ETL tool on server A will read the files and the reference tables from server B, process that on server A and insert the cleansed data on server B. Somewhere I'm not confortable with that approach. Any comments ? = Stéphane Paquette DBA Oracle, consultant entrepôt de données Oracle DBA, datawarehouse consultant [EMAIL PROTECTED] __ Lèche-vitrine ou lèche-écran ? magasinage.yahoo.ca -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?paquette=20stephane?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mandar A. Ghosalkar INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: ETL architecture
Stephane, We used this approach (albiet on Windows) back in 97-98. We processed ETL from about 300 different customers including several large ones with files 50MB weekly. We saw very good performance from the tool. If I had to pick a problem with this tool it would be the ability to detect errors and stop processing or use some type of exception handling. This was a few years ago, so it may have gotten better since then. Hope this helps, Frank -Original Message- stephane Sent: Wednesday, October 16, 2002 11:26 AM To: Multiple recipients of list ORACLE-L Hi, On all DW project I've been, the ETL tool was on the database server containing the DW database. On the current project, the architecture team has decided that the ETL tool (Data Junction) will be on its own server (Windows) to service all projects needing ETL processing. We are the first client of this approach. All sources will ftp their files on the unix box where the staging/data integration database is. So that means that the the ETL tool on server A will read the files and the reference tables from server B, process that on server A and insert the cleansed data on server B. Somewhere I'm not confortable with that approach. Any comments ? = Stéphane Paquette DBA Oracle, consultant entrepôt de données Oracle DBA, datawarehouse consultant [EMAIL PROTECTED] __ Lèche-vitrine ou lèche-écran ? magasinage.yahoo.ca -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?paquette=20stephane?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Frank Pettinato INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: SET ORACLE-L NOMAIL -- OT
Yes, sorry for the very small attempt at humor. At least the folks here can get a decent 'net link out of it: http://babelfish.altavista.com I'm sure I could work a Baconesque six degrees of separation between this link and Oracle. It at least helps me when I see a post in a language other than English or Pig Latin. :) Rich -Original Message- From: Fink, Dan [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 16, 2002 12:44 PM To: Multiple recipients of list ORACLE-L Subject: RE: SET ORACLE-L NOMAIL Put it to music...the theme song to a certain 1970s sitcom...Think Alice the maid... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Multiple Listeners
Hmm, The db7 (upgraded to 817) automatically registers itself to listener. Why? And, changing the PORT, wouldn't I need to change all tnsnames.ora ? Nabil, your and Kirti's suggestion for one listener has this particular benefit. Still thinking.I am. - Original Message - To: 'Rachna Vaidya' [EMAIL PROTECTED] Sent: Wednesday, October 16, 2002 2:33 PM again, I think its better to use one listener. Unless you have some reason for needed two of them. just me 2 cents :-) nabil -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachna Vaidya INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
oem 9.2.x - thin client
Anybody get the web client to work. I launch from ie 5.5 andget a window that "console applet has been launched" but nothing happens. In apache error log is:[Wed Oct 16 12:36:04 2002] [error] [client 10.4.2.1] File does not exist: d:/oracle/oem/oem_webstage/java-plugin/jinit11816.exe On the server we have jinit11818 not 16. Jeffrey BeckstromDatabase AdministratorGreater Cleveland Regional Transit Authority1240 W. 6th StreetCleveland, Ohio 44113(216) 781-4204
Re: Multiple Listeners
Hmm,
The db7 (upgraded to 817) automatically registers itself to listener.
Why?
And, changing the PORT, wouldn't I need to change all tnsnames.ora ?
Nabil, your and Kirti's suggestion for one listener has this
particular benefit.
Still thinking.I am.
-Rachna
- Original Message -
To: 'Rachna Vaidya' [EMAIL PROTECTED]
Sent: Wednesday, October 16, 2002 2:33 PM
again,
I think its better to use one listener. Unless you have some reason for
needed two of them.
just me 2 cents
:-)
nabil
-Original Message-
From: Rachna Vaidya [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, October 16, 2002 1:21 PM
To: LazyDBA.com Discussion
Subject: Re: Multiple Listeners
Thanks for the inputs.
This is how I did it.
1. There are two listener.ora files
/opt/app/oracle/product/816/listener.ora : FILE816
/opt/app/oracle/product/817/listener.ora : FILE817
FILE817 is a copy of FILE816
2. Entries for db7 are removed from FILE816
FILE816 listner name is left unchanged as LISTENER
FILE816 entry for IPC was left unchanged :
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
FILE816 entry for PORT was left unchanged :
(ADDRESS = (PROTOCOL = TCP)(HOST = lightening)(PORT = 1521))
3. Entries for db6 are removed from FILE817 and ORACLE_HOME path changes
are
made
FILE817 listner name was changed to LISTENER_817
FILE817 entry for IPC was changed as :
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC_817))
ORACLE_HOME path changes were made to FILE817
FILE817 entry for PORT was changed as :
(ADDRESS = (PROTOCOL = TCP)(HOST = lightening)(PORT = 1526))
4. To use 816 listener
ORACLE_HOME=$/opt/app/oracle/product/816
cd $ORACLE_HOME/network/admin
$ORACLE_HOME/bin/lsnrctl stop listener
$ORACLE_HOME/bin/lsnrctl start listener
$ORACLE_HOME/bin/lsnrctl status listener
9. To use 817 listener
ORACLE_HOME=$/opt/app/oracle/product/817
cd $ORACLE_HOME/network/admin
$ORACLE_HOME/bin/lsnrctl stop listener_817
$ORACLE_HOME/bin/lsnrctl start listener_817
$ORACLE_HOME/bin/lsnrctl status listener_817
And I think I am having
a. two separate Listeners
b. for two different databases
c. in different version (having different ORACLE_HOME)
d. listening at different ports
Am I correct or there is some mistake / improvement?
Thanks for the inputs.
-Rachna
- Original Message -
From: Stephen Lee [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, October 16, 2002 2:39 PM
Subject: RE: Multiple Listeners
-Original Message-
Any quick start guides / scripts / notes for having multiple version
listeners on same Solaris box?
It works fine. Here is an example of some commands to put into a
general
Oracle startup script.
export ORACLE_BASE=/oracle/app/oracle
export LOGFILE=${ORACLE_BASE}/log/ora-startup.log
exec $LOGFILE 21
touch $LOGFILE
chmod a+r $LOGFILE
print \nStarting ora-startup
date
# Automatically export all variables
set -a
# Start the databases
$ORACLE_BASE/admin/dbascripts/init.d/dbstart
# Start the listeners
export ORACLE_HOME=$ORACLE_BASE/product/9.2.0
$ORACLE_HOME/bin/lsnrctl start LIST_V920
export ORACLE_HOME=$ORACLE_BASE/product/9.0.1
$ORACLE_HOME/bin/lsnrctl start LIST_V901
#Start the listeners
export ORACLE_HOME=$ORACLE_BASE/product/8.1.7
$ORACLE_HOME/bin/lsnrctl start LIST_DSNR4
$ORACLE_HOME/bin/lsnrctl start LIST_V817
$ORACLE_HOME/bin/lsnrctl start LIST_V817_2
export ORACLE_HOME=$ORACLE_BASE/product/8.1.7.4
$ORACLE_HOME/bin/lsnrctl start LIST_V8174
etc.
etc.
etc.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Stephen Lee
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Oracle documentation is here:
http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
To unsubscribe: send a blank email to [EMAIL PROTECTED]
To subscribe: send a blank email to [EMAIL PROTECTED]
Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl
Tell yer mates about http://www.farAwayJobs.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Rachna Vaidya
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego,
RE: oem 9.2.x - thin client
it takes sometime to download the jinitiator -Original Message-From: Jeffrey Beckstrom [mailto:[EMAIL PROTECTED]]Sent: quarta-feira, 16 de Outubro de 2002 20:40To: Multiple recipients of list ORACLE-LSubject: oem 9.2.x - thin client Anybody get the web client to work. I launch from ie 5.5 andget a window that "console applet has been launched" but nothing happens. In apache error log is:[Wed Oct 16 12:36:04 2002] [error] [client 10.4.2.1] File does not exist: d:/oracle/oem/oem_webstage/java-plugin/jinit11816.exe On the server we have jinit11818 not 16. Jeffrey BeckstromDatabase AdministratorGreater Cleveland Regional Transit Authority1240 W. 6th StreetCleveland, Ohio 44113(216) 781-4204
RE: Multiple Listeners
I respectfully disagree. I am currently working on a Sun 4500 cluster with Veritas. The cluster services each maintain their own nic/ip, that's 1 per instance. Obviously, each instance also has its own listener. This has been very easy to implement and not at all confusing. It also avoids things like where you can't use a 8.0.5+ listener for 8.0.4- instances. Each SID has its own listener at its own version level. I would suggest coming up with a good standard for determining ports and such however. For instance, I use 15 concatenated with the last 2 digits of the assigned IP. Before walking into the cluster world, I would have agreed with Tom. Of course now I have seperate HOMEs for each instance too. John P Weatherman Database Administrator Replacements Ltd. -Original Message- Sent: Wednesday, October 16, 2002 2:40 PM To: Multiple recipients of list ORACLE-L Rachna, Do yourself a favor - use the most recent listener for all databases. Have only one listener running on a machine and use that for all databases on that machine. In your case, use the 817 listener. In the long run, it will be much easier and less confusing. Hope this helps. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Wednesday, October 16, 2002 2:13 PM To: Multiple recipients of list ORACLE-L DBAs, Any quick start guides / scripts / notes for having multiple version listeners on same Solaris box? Scenario : I am in process of upgrading. There are two databases on a machine db6 and db7 db6 - 8.1.6 db7 - 8.1.6 db6 and db7 use the listener of version 8.1.6 Now, db7 migrated to 8.1.6 I am thinking of something like : db6 - listener of 8.1.6 (status quo) db7 - listener_817 of 8.1.7 (new version listener) Two separate listener.ora files lsnrctl status listener (for 8.1.6 listener) lsnrctl status listener_817 (for 8.1.7 listener) Thanks in advance, -Rachna -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachna Vaidya INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Weatherman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Multiple Listeners
Not always. 8.0.5+ listeners can not be used with 8.0.4- databases... John P Weatherman Database Administrator Replacements Ltd. -Original Message- Sent: Wednesday, October 16, 2002 2:40 PM To: Multiple recipients of list ORACLE-L You can use the 'higher' version of the listener for all databases running on = higher version, unless you need multiple listeners for other reasons Net8 Admin Guide should have enough information. - Kirti -Original Message- Sent: Wednesday, October 16, 2002 1:13 PM To: Multiple recipients of list ORACLE-L DBAs, Any quick start guides / scripts / notes for having multiple version listeners on same Solaris box? Scenario : I am in process of upgrading. There are two databases on a machine db6 and db7 db6 - 8.1.6 db7 - 8.1.6 db6 and db7 use the listener of version 8.1.6 Now, db7 migrated to 8.1.6 I am thinking of something like : db6 - listener of 8.1.6 (status quo) db7 - listener_817 of 8.1.7 (new version listener) Two separate listener.ora files lsnrctl status listener (for 8.1.6 listener) lsnrctl status listener_817 (for 8.1.7 listener) Thanks in advance, -Rachna -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachna Vaidya INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Weatherman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Urgent problem with query in CBO Vs RBO
Title: RE: Urgent problem with query in CBO Vs RBO Thanks ... so far Oracle had completely understood the problem and looks like we may be hitting some bug in CBO. I am awaiting the bug#, I don't know that yet. The same query works fine if I do a 'alter session set optimizer_mode=rule'; though .. Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! -Original Message- From: Stephane Faroult [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 16, 2002 4:06 PM To: Multiple recipients of list ORACLE-L Subject: Re: Urgent problem with query in CBO Vs RBO Jamadagni, Rajendra wrote: Okay ... so I have a query that works fine in RBO (8161). In CBO (9201) is returns wrong results (stats are recreated this AM). By adding a group by the CBO query returns the right data. Furthermore on CBO, the explain plan shows that Oracle is not even parsing the query completely. If drops off a huge EXISTS clause. Does anyone know what is going on? I have a sev 1 tar open and waiting for OWS to call me. Raj Raj, I understand your concern about the disappearing EXISTS but I think that it would be sensible to try to get the plan using different tools (plain old EXPLAIN followed by a query on PLAN_TABLE, set autotrace, tkprof ...) to be sure that the bug really is in the parser, and not in the output of the plan. Your 'adding a GROUP BY' leaves me a little suspicious. Are you sure that your query was correct (in the absolute sense) initially? I am asking the question because I remember one day somebody coming to me triumphantly saying 'I have found a big bug in Oracle' because a query which used to give the good result (not exactly the same as 'which was correct') was suddenly (after I think the addition of hints) miserably failing with a mysterious data conversion error. On closer inquiry, it appeared that a VARCHAR2 column was compared to a number, which, as most people who once asked themselves 'Why is Oracle *NOT* using my index ?' know, forces an implicit to_number() of the VARCHAR2 column. What happened is that this column mostly contained numbers represented as strings, but for a '***' or similar somewhere. With one execution plan, other criteria caused this row to be filtered out before the comparison on this very column. Not with the other execution plan. The GROUP BY sounds a bit like a DISTINCT to me, a convenient way to fix a missing join, or perhaps some hazardous play on ROWNUM or similar. Just my gut feeling. HTH, Stephane Faroult Oriole Software -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). *This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.*1
RE: Multiple Listeners
-Original Message- The db7 (upgraded to 817) automatically registers itself to listener. Why? And, changing the PORT, wouldn't I need to change all tnsnames.ora ? Nabil, your and Kirti's suggestion for one listener has this particular benefit. I have seen later versions of the listener find instances on the box and automatically listen for them on port 1521. I don't remember the exact version that this start happening since I'm not good at remembering these kinds of facts. What appears to be happening is the spread of the Microsoft philosophy of Oh here. Let us HELP you with that ... whether you like or not. The reason we use a listener to match the version of the database is that, around here, Murphy has a B-I-G desk, in a corner office, and he works 24 hours per day, 7 days per week. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Urgent problem with query in CBO Vs RBO
Jamadagni, Rajendra wrote: Okay ... so I have a query that works fine in RBO (8161). In CBO (9201) is returns wrong results (stats are recreated this AM). By adding a group by the CBO query returns the right data. Furthermore on CBO, the explain plan shows that Oracle is not even parsing the query completely. If drops off a huge EXISTS clause. Does anyone know what is going on? I have a sev 1 tar open and waiting for OWS to call me. Raj Raj, I understand your concern about the disappearing EXISTS but I think that it would be sensible to try to get the plan using different tools (plain old EXPLAIN followed by a query on PLAN_TABLE, set autotrace, tkprof ...) to be sure that the bug really is in the parser, and not in the output of the plan. Your 'adding a GROUP BY' leaves me a little suspicious. Are you sure that your query was correct (in the absolute sense) initially? I am asking the question because I remember one day somebody coming to me triumphantly saying 'I have found a big bug in Oracle' because a query which used to give the good result (not exactly the same as 'which was correct') was suddenly (after I think the addition of hints) miserably failing with a mysterious data conversion error. On closer inquiry, it appeared that a VARCHAR2 column was compared to a number, which, as most people who once asked themselves 'Why is Oracle *NOT* using my index ?' know, forces an implicit to_number() of the VARCHAR2 column. What happened is that this column mostly contained numbers represented as strings, but for a '***' or similar somewhere. With one execution plan, other criteria caused this row to be filtered out before the comparison on this very column. Not with the other execution plan. The GROUP BY sounds a bit like a DISTINCT to me, a convenient way to fix a missing join, or perhaps some hazardous play on ROWNUM or similar. Just my gut feeling. HTH, Stephane Faroult Oriole Software -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Sql question : use of SUBSTR/INSTR functions
Help! Anybody have a quick and dirty to parse the 4 octets of a typical IP address into 4 separate values. I will insert these into a table where database checks may verify that the data is in fact a number and also part of a valid ip range (the second thru fourth octets cannot be higher than 255. The source data is very dirty and often fat-fingered, hence the painful solution): e.g.: 127.0.0.1 into 127 (val 1), 0 (val 2), 0 (val 3) and 1 (val 4). I have used various flavors of substr/instr to unravel this, but the varying length of the octets (up to 3 bytes) defeats my rudimentary sql coding skills. I probably have to attack the IP with decode, and any input will be very welcome. Running V 8.1.6. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Johan Muller INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Multiple Listeners
That's because of the new feature of Auto Registration with Listener... I guess, it's about time to review docs for changes in 8i Release 2 (8.1.7)... there could be more such surprises :) - Kirti -Original Message- Sent: Wednesday, October 16, 2002 2:50 PM To: Multiple recipients of list ORACLE-L Hmm, The db7 (upgraded to 817) automatically registers itself to listener. Why? And, changing the PORT, wouldn't I need to change all tnsnames.ora ? Nabil, your and Kirti's suggestion for one listener has this particular benefit. Still thinking.I am. - Original Message - To: 'Rachna Vaidya' [EMAIL PROTECTED] Sent: Wednesday, October 16, 2002 2:33 PM again, I think its better to use one listener. Unless you have some reason for needed two of them. just me 2 cents :-) nabil -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachna Vaidya INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Multiple Listeners
May be that was one of bugs in 8.0.5.. At present we have 9.0.1 listener for 7.3.4, 8.1.6, 8.1.7.2, 8.1.7.3, 8.1.7.4 and 9.0.1 databases on HP-UX. Not a problem. - Kirti -Original Message- Sent: Wednesday, October 16, 2002 3:00 PM To: Multiple recipients of list ORACLE-L Not always. 8.0.5+ listeners can not be used with 8.0.4- databases... John P Weatherman Database Administrator Replacements Ltd. -Original Message- Sent: Wednesday, October 16, 2002 2:40 PM To: Multiple recipients of list ORACLE-L You can use the 'higher' version of the listener for all databases running on = higher version, unless you need multiple listeners for other reasons Net8 Admin Guide should have enough information. - Kirti -Original Message- Sent: Wednesday, October 16, 2002 1:13 PM To: Multiple recipients of list ORACLE-L DBAs, Any quick start guides / scripts / notes for having multiple version listeners on same Solaris box? Scenario : I am in process of upgrading. There are two databases on a machine db6 and db7 db6 - 8.1.6 db7 - 8.1.6 db6 and db7 use the listener of version 8.1.6 Now, db7 migrated to 8.1.6 I am thinking of something like : db6 - listener of 8.1.6 (status quo) db7 - listener_817 of 8.1.7 (new version listener) Two separate listener.ora files lsnrctl status listener (for 8.1.6 listener) lsnrctl status listener_817 (for 8.1.7 listener) Thanks in advance, -Rachna -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachna Vaidya INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Weatherman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: ETL architecture
This is a common approach. Should be ok if: * transporting the ftp files is part of the ETL process * big fat pipe to the servers. Jared paquette stephane [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 10/16/2002 11:25 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:ETL architecture Hi, On all DW project I've been, the ETL tool was on the database server containing the DW database. On the current project, the architecture team has decided that the ETL tool (Data Junction) will be on its own server (Windows) to service all projects needing ETL processing. We are the first client of this approach. All sources will ftp their files on the unix box where the staging/data integration database is. So that means that the the ETL tool on server A will read the files and the reference tables from server B, process that on server A and insert the cleansed data on server B. Somewhere I'm not confortable with that approach. Any comments ? = Stéphane Paquette DBA Oracle, consultant entrepôt de données Oracle DBA, datawarehouse consultant [EMAIL PROTECTED] __ Lèche-vitrine ou lèche-écran ? magasinage.yahoo.ca -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?paquette=20stephane?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Multiple Listeners
It is better to have a single Listener per server, unless you have multiple
servers that use high availability fail over between the servers. The
single listener should be the most recent one on the server. It is
backwards compatible with Oracle8i versions and Oracle7 databases. There
is no need to run multiple listeners on the same server, especially when
the versions are just one release off from each other (e.g. 8.1.6 and
8.1.7). A single listener and a single Intelligent Agent should be all
that is needed. It may be clever to see if multiple listeners can run, but
even Oracle will tell you that running multiple listeners is worse than
foolish.:) In addition to changing the Oracle Home, the LD_LIBRARY_PATH or
LIBPATH would have to be changed as well to match the libraries to the
correct version of the listener.
Trust me, you only need one version of the Listener up. I have three
versions of Oracle on a server: Oracle7, Oracle8i v8.1.7 and Oracle9i
v9.2.0. I use the Oracle9i listener and agent on the servers. It allows
seamless connections to all the databases.
RWB
Rachna Vaidya [EMAIL PROTECTED]@fatcity.com on 10/16/2002
02:23:35 PM
Please respond to [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Thanks for the inputs.
This is how I did it.
1. There are two listener.ora files
/opt/app/oracle/product/816/listener.ora : FILE816
/opt/app/oracle/product/817/listener.ora : FILE817
FILE817 is a copy of FILE816
2. Entries for db7 are removed from FILE816
FILE816 listner name is left unchanged as LISTENER
FILE816 entry for IPC was left unchanged :
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
FILE816 entry for PORT was left unchanged :
(ADDRESS = (PROTOCOL = TCP)(HOST = lightening)(PORT = 1521))
3. Entries for db6 are removed from FILE817 and ORACLE_HOME path changes
are
made
FILE817 listner name was changed to LISTENER_817
FILE817 entry for IPC was changed as :
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC_817))
ORACLE_HOME path changes were made to FILE817
FILE817 entry for PORT was changed as :
(ADDRESS = (PROTOCOL = TCP)(HOST = lightening)(PORT = 1526))
4. To use 816 listener
ORACLE_HOME=$/opt/app/oracle/product/816
cd $ORACLE_HOME/network/admin
$ORACLE_HOME/bin/lsnrctl stop listener
$ORACLE_HOME/bin/lsnrctl start listener
$ORACLE_HOME/bin/lsnrctl status listener
9. To use 817 listener
ORACLE_HOME=$/opt/app/oracle/product/817
cd $ORACLE_HOME/network/admin
$ORACLE_HOME/bin/lsnrctl stop listener_817
$ORACLE_HOME/bin/lsnrctl start listener_817
$ORACLE_HOME/bin/lsnrctl status listener_817
And I think I am having
a. two separate Listeners
b. for two different databases
c. in different version (having different ORACLE_HOME)
d. listening at different ports
Am I correct or there is some mistake / improvement?
Thanks for the inputs.
-Rachna
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, October 16, 2002 2:39 PM
-Original Message-
Any quick start guides / scripts / notes for having multiple version
listeners on same Solaris box?
It works fine. Here is an example of some commands to put into a general
Oracle startup script.
export ORACLE_BASE=/oracle/app/oracle
export LOGFILE=${ORACLE_BASE}/log/ora-startup.log
exec $LOGFILE 21
touch $LOGFILE
chmod a+r $LOGFILE
print \nStarting ora-startup
date
# Automatically export all variables
set -a
# Start the databases
$ORACLE_BASE/admin/dbascripts/init.d/dbstart
# Start the listeners
export ORACLE_HOME=$ORACLE_BASE/product/9.2.0
$ORACLE_HOME/bin/lsnrctl start LIST_V920
export ORACLE_HOME=$ORACLE_BASE/product/9.0.1
$ORACLE_HOME/bin/lsnrctl start LIST_V901
#Start the listeners
export ORACLE_HOME=$ORACLE_BASE/product/8.1.7
$ORACLE_HOME/bin/lsnrctl start LIST_DSNR4
$ORACLE_HOME/bin/lsnrctl start LIST_V817
$ORACLE_HOME/bin/lsnrctl start LIST_V817_2
export ORACLE_HOME=$ORACLE_BASE/product/8.1.7.4
$ORACLE_HOME/bin/lsnrctl start LIST_V8174
etc.
etc.
etc.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Stephen Lee
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Rachna Vaidya
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051
RE: oem 9.2.x - thin client
But the one on the error log does not match the version on the server. [EMAIL PROTECTED] 10/16/02 4:09:59 PM it takes sometime to download the jinitiator -Original Message-From: Jeffrey Beckstrom [mailto:[EMAIL PROTECTED]]Sent: quarta-feira, 16 de Outubro de 2002 20:40To: Multiple recipients of list ORACLE-LSubject: oem 9.2.x - thin client Anybody get the web client to work. I launch from ie 5.5 andget a window that "console applet has been launched" but nothing happens. In apache error log is:[Wed Oct 16 12:36:04 2002] [error] [client 10.4.2.1] File does not exist: d:/oracle/oem/oem_webstage/java-plugin/jinit11816.exe On the server we have jinit11818 not 16. Jeffrey BeckstromDatabase AdministratorGreater Cleveland Regional Transit Authority1240 W. 6th StreetCleveland, Ohio 44113(216) 781-4204
