Re: Shared Pool Utilization
So it was the MTS. Hadn't thought of that.
Jared
Tanel Poder [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
08/27/2003 03:49 PM
Please respond to ORACLE-L
To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:Re: Shared Pool Utilization
You're welcome!
Tanel.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, August 28, 2003 1:34 AM
Tanel
You were on target
SQL show parameter shared_serv
NAME TYPEVALUE
---
--
max_shared_servers integer 20
shared_server_sessionsinteger 0
shared_serversinteger 0
SQL show parameter dispatch
NAME TYPEVALUE
---
--
dispatchers string
max_dispatchers integer 5
mts_dispatchers string
mts_max_dispatchers integer 5
SQL
I corrected the script for non-MTS/DTS and got the result.
SQL @swt02a
Object mem : 67.73 Mb
Cursors : 3.02 Mb
MTS session/UGA memory max: 433.93 Mb
Free memory: 105.98 Mb (105.98MB)
Shared pool utilization (total): 96440007 bytes (91.97MB)
Shared pool allocation (actual): 201326592bytes (192MB)
Percentage Utilized: 48%
PL/SQL procedure successfully completed.
Thanks
Hi!
I wonder whether you are running in dedicated server mode? That way UGA
isn't allocated from SGA and the calculation used_pool/shared_pool_size
is
gives wrong results.
Tanel.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, August 27, 2003 10:44 PM
I have two databases, one in which the shared_pool utilization is not
exceeded (development) and the other one in which it appears that the
shared_pool utilization is exceeded.
The queries i am using are
1. COL Free_Mem FORMAT 99.99 heading 'Free|Mem|(Mb)'
SELECT pool, name, bytes/(1024*1024) Free_Mem FROM V$SGASTAT
WHERE NAME = 'free memory'
AND POOL = 'shared pool'
/
2. Metalink note
SGA/Shared Pool Utilization - Metalink Note : 105004.1 (modified for
bytes-- Mb and nvl clauses)
set serveroutput on size 100;
DECLARE
object_mem NUMBER;
shared_sql NUMBER;
cursor_mem NUMBER;
mts_memNUMBER;
used_pool_size NUMBER;
free_memNUMBER;
pool_size VARCHAR2(512); -- same AS V$PARAMETER.VALUE
BEGIN
-- Stored objects (PACKAGEs, views)
--V$DB_OBJECT_CACHE
--This view displays database objects that are cached in the
library cache. Objects include
--tables, indexes, clusters, synonym definitions, PL/SQL
procedures and packages, and triggers.
--http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96
536/ch346.htm#1113348
SELECT SUM(NVL(sharable_mem,0)) INTO object_mem FROM
v$db_object_cache;
--
--
-- User Cursor Usage -- run this during peak usage.
-- assumes 250 bytes per open cursor, FOR each concurrent user.
-- V$SQLAREA lists statistics on shared SQL area and contains
one
row per SQL string.
-- It provides statistics on SQL statements that are in memory,
parsed, and ready for execution.
SELECT SUM(250*users_opening) INTO cursor_mem FROM v$sqlarea;
-- For a test system -- get usage FOR one user, multiply by # users
-- SELECT (250 * value) bytes_per_user
-- FROM v$sesstat s, v$statname n
-- WHERE s.statistic# = n.statistic#
-- AND n.name = 'opened cursors current'
-- AND s.sid = 25; -- WHERE 25 is the sid of the process
-- MTS memory needed to hold session inFORmation FOR shared server
users
-- This query computes a total FOR all currently logged on users
(run
-- during peak period). Alternatively calculate FOR a single user
and
-- multiply by # users.
SELECT SUM(NVL(value,0)) INTO mts_mem FROM v$sesstat s, v$statname n
WHERE s.statistic#=n.statistic#
AND n.name='session uga memory max';
-- Free (unused) memory IN the SGA: gives an indication of how much
memory
-- is being wasted OUT of the total allocated.
SELECT NVL(bytes,0) INTO free_mem FROM v$sgastat
WHERE name = 'free memory' AND pool='shared pool';
-- For non-MTS add up object, shared sql, cursors AND 30% overhead.
--used_pool_size := ROUND(1.3*(object_mem+cursor_mem));
-- For MTS mts contribution needs to be included (comment OUT
previous
line)
used_pool_size :=
ROUND(1.3*(object_mem+NVL(shared_sql,0)+cursor_mem+mts_mem));
SELECT NVL(value,0) INTO pool_size FROM v$parameter WHERE
name='shared_pool_size';
-- Display results
DBMS_OUTPUT.PUT_LINE ('Object mem :
'||TO_CHAR(ROUND(object_mem/(1024*1024),2)) || ' Mb');
DBMS_OUTPUT.PUT_LINE ('Cursors :
'||TO_CHAR(ROUND(cursor_mem/(1024*1024),2)) || ' Mb');
RE: Alert log....
Re the annoying leading whitespace: If you're doing this with shell, run it through this filter: sed -e 's/^ *//g' -e 's/^ *//g' ( those blanks are a tab and a space, respectively ) If you are doing it in perl simply use s/^\s+// eg. $line =~ s/^\s+//; HTH Jared Post, Ethan [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 08/27/2003 03:44 PM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Alert log Be careful of grepping for ^ORA-, I occasionally getORA- (spaces) when I use this. Anjo gave me a call to make to attempt to get the line to start at the beginning but I don't think it works. Hard to test since this situation is not recreatable. AIX 64 bit 4.3 Oracle 8.1.4. - E -Original Message- Sent: Wednesday, August 27, 2003 3:04 PM To: Multiple recipients of list ORACLE-L Roger Xu [EMAIL PROTECTED] for the guy that asked for writing the the alert.log file: dbms_system.ksdwrt(2,'Test line...'); Will write the text to the alert log. Use 1 instead of 2 to write to the trace file Use 3 to write to both. HTH JL __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jose Luis Delgado INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Post, Ethan INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
alter system does not work as advertised
Maybe somebody can enlighten me on this, if I do a alter system set session_cached_cursors=100 scope=spfile I get the following message back ERROR at line 1: ORA-02096: specified initialization parameter is not modifiable with this option According to the documentation, by specifying scope=spfile, then The change is made in the server parameter file (SPFILE) only and will be set on the next startup Going by that statement, even though the variable is not-modifiable when the instance is up, I should still be able to change the parameter, then when I shutdown/startup the database during the night, the NEW value should take. If I can't modify the parameter in the spfile only, whats the point of the command ?? Is this a bug or a feature ?? Thanks Darren -- Darren Browett P.EngThis message was transmitted Data Administrator using 100% recycled electrons Information and Communication Technology City of Coquitlam P:(604)927 - 3614 E:[EMAIL PROTECTED] --- -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Browett, Darren INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Grid
no not over the atlantic. its from DC to Boston. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, August 27, 2003 7:39 PM 10GB over Atlantic? This does cost a lot. At least I assume so, why the heck am I sticking to 512kb in my home then? Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, August 28, 2003 1:54 AM i havent seen much about internet 2. i didnt realize there was anything in production yet. do you know where i can find more info on it? 2.3 GBs isnt really that much for a connect anymore. its not that expensive to get 10GB connections or more. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, August 27, 2003 5:44 PM We've been talking of Grid computing here since either late 1999 or early 2000. The computing for our main experiment was designed before the Grid was contemplated. Still we have implemented some of the middleware needed, and build methods of authentication and authorization, and participated in Grid experiments. We have also been pushing the ability to transfer large amounts of data. The latest effort: 2.3 GB per second between the local internet hub and Geneva Switzerland over Internet 2. This is vital to make the Grid work. Yep, you'll probably have huge amounts of data coming in when CERN gets their large hadron collider online in 2007 ;) Btw, AFAIK, they're using Oracle... Tanel. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ryan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ryan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Need help with an error ORA-12640
Guru: I need help with an error ORA-12640. I have a Oracle 8.1.7 database with 8.1.7.4 patch running on Windows 2000. The sqlnet.authentication_services=(NTS) parameter is enabled and we do not want to change the sqlnet.authentication_services=(NONE). The custom SQL application is launched by a Domain User on the Oracle Server machine. If the Domain user has local administrative privileges, it works with no error. If the Domain user does not have local adminstrative privileges, it fails with the above error. I am at a lost to explain this. Does anyone has any idea? Thank you in advance. Pete -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Lee, Peter (AZ15) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Moving Data from Oracle to SQL Server
Hi I am going to be migrating data from Oracle to a SQL server and wanted to know what is the likely variation in database size when its done that is if I had a 10GB Oracle DB, should I expect the SQL server to be a lot bigger, a lot smaller or about the same -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238 Facsimile: +61 (0)7 3303 3048 = If people did not sometimes do silly things, nothing intelligent would ever get done. - Ludwig Wittgenstein = Mincom The People, The Experience, The Vision = This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please delete it and notify the sender. The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Group of companies unless expressly stated otherwise. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- 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: alter system does not work as advertised
Hi! It works in 9.2.0.4 on W2k, so it might be a bug. I've seen other problematic parametrs as well in previous patch levels. Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, August 28, 2003 3:24 AM Maybe somebody can enlighten me on this, if I do a alter system set session_cached_cursors=100 scope=spfile I get the following message back ERROR at line 1: ORA-02096: specified initialization parameter is not modifiable with this option According to the documentation, by specifying scope=spfile, then The change is made in the server parameter file (SPFILE) only and will be set on the next startup Going by that statement, even though the variable is not-modifiable when the instance is up, I should still be able to change the parameter, then when I shutdown/startup the database during the night, the NEW value should take. If I can't modify the parameter in the spfile only, whats the point of the command ?? Is this a bug or a feature ?? Thanks Darren -- Darren Browett P.Eng This message was transmitted Data Administrator using 100% recycled electrons Information and Communication Technology City of Coquitlam P:(604)927 - 3614 E:[EMAIL PROTECTED] --- -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Browett, Darren INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: oracle sessions from term server
The TCP connection to Oracle server process (or dispatcher) port probably remains alive for some reason. When TCP connection is dropped from OS, the session dies immediately.So you should check why are sessions TCP connections maintained or set sqlnet.expire_time to one hour or smth, to kill sessions after an hour even if TCP connection for given sessionis still open. Tanel. - Original Message - From: AK To: Multiple recipients of list ORACLE-L Sent: Wednesday, August 27, 2003 9:09 PM Subject: oracle sessions from term server Hi Guys , we have forms/report application installed on windows terminal servers and user access application from these terminal servers . When some session hangs on these term server adminstrator resets those sessions . But the corresponding database session remains alive . Is it s problem with some sql*net setting ?? Any help in this regard is highly appreciated . thanks, -ak
Re: Grid
Hi! It's still quite hard to believe, that it could be anywhere near cheap. Even building 10Gbit locatl Ethernet is currently expensive. You would need 16*655Mb ATM connections for that to do over long range... Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, August 28, 2003 6:44 AM no not over the atlantic. its from DC to Boston. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, August 27, 2003 7:39 PM 10GB over Atlantic? This does cost a lot. At least I assume so, why the heck am I sticking to 512kb in my home then? Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, August 28, 2003 1:54 AM i havent seen much about internet 2. i didnt realize there was anything in production yet. do you know where i can find more info on it? 2.3 GBs isnt really that much for a connect anymore. its not that expensive to get 10GB connections or more. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, August 27, 2003 5:44 PM We've been talking of Grid computing here since either late 1999 or early 2000. The computing for our main experiment was designed before the Grid was contemplated. Still we have implemented some of the middleware needed, and build methods of authentication and authorization, and participated in Grid experiments. We have also been pushing the ability to transfer large amounts of data. The latest effort: 2.3 GB per second between the local internet hub and Geneva Switzerland over Internet 2. This is vital to make the Grid work. Yep, you'll probably have huge amounts of data coming in when CERN gets their large hadron collider online in 2007 ;) Btw, AFAIK, they're using Oracle... Tanel. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ryan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ryan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services
Templates
Title: Templates Hello I've a little question about templates. Is it possible to design a template table and reuse this table for other (new) tables? If it is, when you change something on the template, will it also change on the other tables? Regards Tim encoded content removed -- binaries not allowed by ListGuru
RE: OCI wrapper library
Not sure that I understand quite well what you want to do (catching statements? Some la Sybase 'Open Server' ?) but it is possible that what is defined in the OCI FM as 'user defined callbacks' is, partly, what you are looking for (I have never used them); I *think* I have read something once in the Oracle docs about functions allowing to write a mock Oracle server but I can't remember where. Don't think it was in the OCI manual. Concerning tcp/ip, an idea which I have toyed with (but not carried very far, like so many ideas) was to use the 'netcat' program which you should find on the web (or anything derived from it) as a frontal to tnslsnr; I have no idea though about how to plug into the dialogue between a client and a dedicated or shared server. HTH SF - --- Original Message --- - From: Tanel Poder [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wed, 27 Aug 2003 14:14:26 I'm sending this post here, because got no response in c.d.o.s. Does anyone have an example how to write an OCI wrapper library, that I could replace the Oracle OCI library with my own (renaming original = one). Then whatever OCI call is made, it ends up to my library where from I = can pass it on, or modify it before that? Also, any information on doing the same thing using TCP sockets = (mediating between client server sql*net connection), is welcome as well. Any pointers are welcome, or otherwise... I'll have to figure it out = myself... Tanel. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: OT: Hey Jared!! -90 degree OT Joke
Hi, This is my own theory, you can't find this information from Oracle Document. Well... talking about women and men. I believe most women use their left brain more than right brain and most men use their right brain more than left brain. Function of left brain - remember things, - small thing but detail (this is the reason why women take 1/2 a day to buy a pair of shoe, and not that easy fall in love) - person names - history - words (perhaps this is the reason why women like to read novels) Function of right brain - response to things (quick decision maker) - this is the reason why so many 2 minute men in the world - everything in general (see thing in big picture) - person faces - math, 1 + 3 / 7 ^ 53 = X - pictures Well Friends train both side of your brain, and for male DBA use your left brain when talk to women, then she is yours. RF tell me if I am wrong PS: Just kidding., going to see Mars tonight I miss my home town. :) Sinardy -Original Message- Sent: 28 August 2003 06:25 To: Multiple recipients of list ORACLE-L Women are also particularily good at remembering small nasty things from past which you've already forgotten long time ago. Especially during fights... :) Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, August 28, 2003 12:59 AM Not being sexist in any way, but it's my experience that Women are much better generalists than men, but that men are much better specialists. Thats why I think women do better in school early on, but once we men get into the University level and pick our speciality, we kick butt. My soon to be ex-wife was frequently much better remembering overall things than I was RF -Original Message- To: Multiple recipients of list ORACLE-L Sent: 8/27/2003 6:44 AM c'mon... any virus named SoBig has to have been written by a man :) (yes, sexist, I know) --- Tanel Poder [EMAIL PROTECTED] wrote: I've seen only one female in my life who would be capable of writing such virus. But that is not the issue (no offence, really). Women just don't waste their time on stuff like this. Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, August 27, 2003 4:54 AM Guy? You've eliminated 50% of all possible suspects... on 8/26/03 1:44 PM, Tanel Poder at [EMAIL PROTECTED] wrote: I doubt they will ever find the real guy behind this. Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, August 26, 2003 10:19 PM For all you virus/worm lovers out there, justice do come: FBI Subpoenas Arizona ISP In Sobig Probe Easynews says it's cooperating with the bureau to find the person who uploaded the virus to a Usenet group it hosts. informationweek.com/story/showArticle.jhtml?articleID=13800091 Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Goulet, Dick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing
RE: Templates
What do you have in mind? Data or structure? If it's a matter of data if you replace 'template' by 'table' and 'table' by 'view' in your question, the answer is yes. If it's a matter of structure (enlarging a column, for instance), the answer is no. You have templates of a sort in PL/SQL, when you define a parameter to be of table.column%type - if the definition change, the procedure will be automatically invalidated and recompiled. But this is not a syntax supported by 'CREATE TABLE' as far as I know. Dependencies are tracked by Oracle for stored objects only (procedures, functions, packages, views) - I mean structural dependencies, not data dependencies (foreign keys). The best you can do is write some procedure which follows the FK to PK links and duly alter tables when say a PK column has been altered, and perhaps have it fired by a DDL trigger on the 'master' or 'template' table. HTH SF Hello I've a little question about templates. Is it possible to design a template table and reuse this table for other = (new) tables? If it is, when you change something on the template, will it also change = on the other tables? Regards Tim -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Need help with an error ORA-12640
Hi Peter, I think you have to make sure that non - admin user have proper access right to sqlnet.ora(what is the last modified time) tnsnames.ora s.a.b. names.oras.a.b. *.oras.a.b. And of course make sure your listener is started, then check all those *.ora files -IP address, hostname, port (if you are using TCP) then try use tnsping [service_name] to hit the listener. Perhaps you can do a little bit RE to read the patch what kind of changes oracle made to your system, I am not sure about this one, but I think you install that patch with administrator account. You said you install patch then you cannot connect, if this is not Oracle Names Server then I think you can connect from client station because their parameter files are the working version. If this is Oracle Names Server, you client will get the latest changes too most likely cannot connect too. If is not ONS then you can reference your client machine setting. hope this can help you, good luck Sinardy -Original Message- Sent: 28 August 2003 14:19 To: Multiple recipients of list ORACLE-L Guru: I need help with an error ORA-12640. I have a Oracle 8.1.7 database with 8.1.7.4 patch running on Windows 2000. The sqlnet.authentication_services=(NTS) parameter is enabled and we do not want to change the sqlnet.authentication_services=(NONE). The custom SQL application is launched by a Domain User on the Oracle Server machine. If the Domain user has local administrative privileges, it works with no error. If the Domain user does not have local adminstrative privileges, it fails with the above error. I am at a lost to explain this. Does anyone has any idea? Thank you in advance. Pete -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Lee, Peter (AZ15) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Sinardy Xing INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
V$cache
Hello list, I am using Oracle9i Enterprise Edition Release 9.2.0.1.0 on windows. I get 'object does not exist' error when I try to query the V$cache. The docs say that this is an Oracle9i Real Application Clusters view. But so is V$BH and I am able to query that when connected as sys . . -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: RE: OT: Hey Jared!! -90 degree OT Joke
My own theory is that either male or female don't use their brain much. In fact it's pretty equivalent to the load of a Java-free machine. And perhaps it is just as well as it is. - --- Original Message --- - From: Sinardy Xing [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thu, 28 Aug 2003 00:59:27 Hi, This is my own theory, you can't find this information from Oracle Document. Well... talking about women and men. I believe most women use their left brain more than right brain and most men use their right brain more than left brain. Function of left brain - remember things, - small thing but detail (this is the reason why women take 1/2 a day to buy a pair of shoe, and not that easy fall in love) - person names - history - words (perhaps this is the reason why women like to read novels) Function of right brain - response to things (quick decision maker) - this is the reason why so many 2 minute men in the world - everything in general (see thing in big picture) - person faces - math, 1 + 3 / 7 ^ 53 = X - pictures Well Friends train both side of your brain, and for male DBA use your left brain when talk to women, then she is yours. RF tell me if I am wrong PS: Just kidding., going to see Mars tonight I miss my home town. :) Sinardy -Original Message- Sent: 28 August 2003 06:25 To: Multiple recipients of list ORACLE-L Women are also particularily good at remembering small nasty things from past which you've already forgotten long time ago. Especially during fights... :) Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, August 28, 2003 12:59 AM Not being sexist in any way, but it's my experience that Women are much better generalists than men, but that men are much better specialists. Thats why I think women do better in school early on, but once we men get into the University level and pick our speciality, we kick butt. My soon to be ex-wife was frequently much better remembering overall things than I was RF -Original Message- To: Multiple recipients of list ORACLE-L Sent: 8/27/2003 6:44 AM c'mon... any virus named SoBig has to have been written by a man :) (yes, sexist, I know) --- Tanel Poder [EMAIL PROTECTED] wrote: I've seen only one female in my life who would be capable of writing such virus. But that is not the issue (no offence, really). Women just don't waste their time on stuff like this. Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, August 27, 2003 4:54 AM Guy? You've eliminated 50% of all possible suspects... on 8/26/03 1:44 PM, Tanel Poder at [EMAIL PROTECTED] wrote: I doubt they will ever find the real guy behind this. Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, August 26, 2003 10:19 PM For all you virus/worm lovers out there, justice do come: FBI Subpoenas Arizona ISP In Sobig Probe Easynews says it's cooperating with the bureau to find the person who uploaded the virus to a Usenet group it hosts. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
SQL HELP.....
I have a table with the following columns: - item - carton_number -(min) - carton_number -(max) - qty -(sum) - weight -(sum) Item A has qty of 4515 and present in cartons 1 to 1129 Item B has qty of 7255 and present in cartons 1 to 1129 Item C has qty of 400 and present in cartons 1 to 600 (???) I want to find which cartons from 1 to 600 does not contain Item C. Can you give me a sql/plsql script to do this. Thanks a lot, Yoyong Cabansay Email: [EMAIL PROTECTED]
Fw: V$cache
Sorry for the trouble list. found out need to run ?\rdbms\admin\catclust.sql thanks - Original Message - To: [EMAIL PROTECTED] Sent: Thursday, August 28, 2003 13:46 Hello list, I am using Oracle9i Enterprise Edition Release 9.2.0.1.0 on windows. I get 'object does not exist' error when I try to query the V$cache. The docs say that this is an Oracle9i Real Application Clusters view. But so is V$BH and I am able to query that when connected as sys . .. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
How to invoke stored procedures from another instance?
Hi listers, Assume that there are two instances in Oracle. Both instances are on different machines and different Oracle versions. There is a table on first instance. Any update on this table should invoke stored procedures on the second instance. This should be real time based. Options we looked at are 1. Trigger on the table invoking the procedures of the other instance 2. Using dbms_alert 3. Some kind of polling mechanism Triggers we would like to avoid. Options we are left with are dbms_alert and polling mechanism. Is it possible to use dbms_alert in this case? If yes how? Can you think of some kind of polling mechanism which will satisfy the need of real time communication? Updates on the table is done at a very fast rate, hence processing should also be at a fast rate. Any help in this regard is very much appreciated. Thanks and Regards, Ranganath MailFiler [RK-FM8B9B3]
RE: V$cache
You don't have enough privilages -Original Message- Sent: 28 August 2003 17:34 To: Multiple recipients of list ORACLE-L Hello list, I am using Oracle9i Enterprise Edition Release 9.2.0.1.0 on windows. I get 'object does not exist' error when I try to query the V$cache. The docs say that this is an Oracle9i Real Application Clusters view. But so is V$BH and I am able to query that when connected as sys . . -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Sinardy Xing INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: OT: Hey Jared!!
As Robert stirs the pot. ;o) -Original Message- Sent: Wednesday, August 27, 2003 4:59 PM To: Multiple recipients of list ORACLE-L Not being sexist in any way, but it's my experience that Women are much better generalists than men, but that men are much better specialists. Thats why I think women do better in school early on, but once we men get into the University level and pick our speciality, we kick butt. My soon to be ex-wife was frequently much better remembering overall things than I was RF -Original Message- To: Multiple recipients of list ORACLE-L Sent: 8/27/2003 6:44 AM c'mon... any virus named SoBig has to have been written by a man :) (yes, sexist, I know) --- Tanel Poder [EMAIL PROTECTED] wrote: I've seen only one female in my life who would be capable of writing such virus. But that is not the issue (no offence, really). Women just don't waste their time on stuff like this. Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, August 27, 2003 4:54 AM Guy? You've eliminated 50% of all possible suspects... on 8/26/03 1:44 PM, Tanel Poder at [EMAIL PROTECTED] wrote: I doubt they will ever find the real guy behind this. Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, August 26, 2003 10:19 PM For all you virus/worm lovers out there, justice do come: FBI Subpoenas Arizona ISP In Sobig Probe Easynews says it's cooperating with the bureau to find the person who uploaded the virus to a Usenet group it hosts. informationweek.com/story/showArticle.jhtml?articleID=13800091 Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Goulet, Dick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- 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.net -- Author: Freeman Robert - IL INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services
RE: OT: Hey Jared!! -90 degree OT Joke
sorry -- I read novels, respond visually to things, do math, remember faces but not names, see details AND the big picture so either I am more highly evolved and use both sides of my brain (not hardly) or the theory needs some modification --- Sinardy Xing [EMAIL PROTECTED] wrote: Hi, This is my own theory, you can't find this information from Oracle Document. Well... talking about women and men. I believe most women use their left brain more than right brain and most men use their right brain more than left brain. Function of left brain - remember things, - small thing but detail (this is the reason why women take 1/2 a day to buy a pair of shoe, and not that easy fall in love) - person names - history - words (perhaps this is the reason why women like to read novels) Function of right brain - response to things (quick decision maker) - this is the reason why so many 2 minute men in the world - everything in general (see thing in big picture) - person faces - math, 1 + 3 / 7 ^ 53 = X - pictures Well Friends train both side of your brain, and for male DBA use your left brain when talk to women, then she is yours. RF tell me if I am wrong PS: Just kidding., going to see Mars tonight I miss my home town. :) Sinardy -Original Message- Sent: 28 August 2003 06:25 To: Multiple recipients of list ORACLE-L Women are also particularily good at remembering small nasty things from past which you've already forgotten long time ago. Especially during fights... :) Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, August 28, 2003 12:59 AM Not being sexist in any way, but it's my experience that Women are much better generalists than men, but that men are much better specialists. Thats why I think women do better in school early on, but once we men get into the University level and pick our speciality, we kick butt. My soon to be ex-wife was frequently much better remembering overall things than I was RF -Original Message- To: Multiple recipients of list ORACLE-L Sent: 8/27/2003 6:44 AM c'mon... any virus named SoBig has to have been written by a man :) (yes, sexist, I know) --- Tanel Poder [EMAIL PROTECTED] wrote: I've seen only one female in my life who would be capable of writing such virus. But that is not the issue (no offence, really). Women just don't waste their time on stuff like this. Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, August 27, 2003 4:54 AM Guy? You've eliminated 50% of all possible suspects... on 8/26/03 1:44 PM, Tanel Poder at [EMAIL PROTECTED] wrote: I doubt they will ever find the real guy behind this. Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, August 26, 2003 10:19 PM For all you virus/worm lovers out there, justice do come: FBI Subpoenas Arizona ISP In Sobig Probe Easynews says it's cooperating with the bureau to find the person who uploaded the virus to a Usenet group it hosts. informationweek.com/story/showArticle.jhtml?articleID=13800091 Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Goulet, Dick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: 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
RE: SQL HELP.....
De-aggregating aggregated values is an endeavour comparable to putting the toothpaste back into the tube. You can't. If you have the detail somewhere, read about MINUS and INTERSECT, or possibly NOT EXISTS. - --- Original Message --- - From: Cabansay, Yoyong [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thu, 28 Aug 2003 02:15:02 I have a table with the following columns: - item - carton_number---(min) - carton_number---(max) - qty---(sum) - weight ---(sum) =20 Item A has qty of 4515 and present in cartons 1 to 1129 Item B has qty of 7255 and present in cartons 1 to 1129 Item C has qty of 400 and present in cartons 1 to 600 (???) =20 I want to find which cartons from 1 to 600 does not contain Item C. =20 Can you give me a sql/plsql script to do this.=20 =20 Thanks a lot, =20 Yoyong Cabansay Email: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: oracle sessions from term server
Hello, We have a similar situation with our Win2K terminal server-based sessions and our Win2K database server (8.1.7.4.1) although we have not introduced the use of SQLNET.EXPIRE_TIME in this case. As detailed in Metalink Doc ID 151972.1 (Dead Connection Detection (DCD) Explained), there are limitations in a Windows environment. These limitations are not restircted to a Windows-only environment however, as I have seen the same behaviour with NT4 terminal servers connecting to an AIX database server (8.1.7.2.1). The use of DCD is worth investigating. Other Metalink documents that may be useful are 1018160.6 (Common Questions About Dead Connection Detection (DCD)) and in particular, check out bug 2167389 (THREAD LEAK WITH DCD SET CAUSES NT TO HANG) If you discover that that DCD introduces more problems than it solves, then it is trivial to disable - simple hash out the SQLNET.EXPIRE_TIME parameter in the SQLNET.ORA file - no reboot required. HTH --- nigel. Hi Guys , we have forms/report application installed on windows terminal servers and user access application from these terminal servers . When some session hangs on these term server adminstrator resets those sessions . But the corresponding database session remains alive . Is it s problem with some sql*net setting ?? Any help in this regard is highly appreciated . -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: nigel cemm INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: SQL HELP.....
"Open the cartons and see!" ;-) By the way can you reframe your question? Do you mean that you table stores data as follows: item carton_no qty weight - --- -- A1 410 A 2 4 10 B 1 5 12 B 3 5 12 C 1 35 and so on? RegardsNaveen -Original Message-From: Cabansay, Yoyong [mailto:[EMAIL PROTECTED]Sent: Thursday, August 28, 2003 3:45 PMTo: Multiple recipients of list ORACLE-LSubject: SQL HELP. I have a table with the following columns: - item - carton_number -à(min) - carton_number -à(max) - qty -à(sum) - weight -à(sum) Item A has qty of 4515 and present in cartons 1 to 1129 Item B has qty of 7255 and present in cartons 1 to 1129 Item C has qty of 400 and present in cartons 1 to 600 (???) I want to find which cartons from 1 to 600 does not contain Item C. Can you give me a sql/plsql script to do this. Thanks a lot, Yoyong Cabansay Email: [EMAIL PROTECTED]DISCLAIMER:This message (including attachment if any) is confidential and may be privileged. Before opening attachments please check them for viruses and defects. MindTree Consulting Private Limited (MindTree) will not be responsible for any viruses or defects or any forwarded attachments emanating either from within MindTree or outside. If you have received this message by mistake please notify the sender by return e-mail and delete this message from your system. Any unauthorized use or dissemination of this message in whole or in part is strictly prohibited. Please note that e-mails are susceptible to change and MindTree shall not be liable for any improper, untimely or incomplete transmission.
RE: How to invoke stored procedures from another instance?
Hi listers, =20 Assume that there are two instances in Oracle. Both instances are on = different machines and different Oracle versions. There is a table on = first instance. Any update on this table should invoke stored procedures = on the second instance. This should be real time based. Options we = looked at are =20 1. Trigger on the table invoking the procedures of the other instance 2. Using dbms_alert 3. Some kind of polling mechanism =20 Triggers we would like to avoid. Options we are left with are dbms_alert = and polling mechanism.=20 =20 Is it possible to use dbms_alert in this case? If yes how? =20 Can you think of some kind of polling mechanism which will satisfy the = need of real time communication? Updates on the table is done at a very = fast rate, hence processing should also be at a fast rate. =20 Any help in this regard is very much appreciated. =20 Thanks and Regards, =20 Ranganath =20 I agree with your reluctance to use triggers; the problem is that whenever the second instance is down, then you couldn't do anything on the first. Basically, what you want to implement are near real-time although not quite synchronous snapshots. I have never used DBMS_ALERT in this way, but I think that it would be possible to have a database link on the second instance referencing the first one and invoking DBMS_ALERT through it. Beware with DBMS_ALERT though, my memories are not very fresh but there are some problems with COMMITs (which you can workaround with autonomous transactions, but then the alertee can be woken up by a rolled back transaction, a case which has to be handled by your code); DBMS_PIPE is another solution, which also has its flaws. Avanced queuing seems to me to be a fine mess, but perhaps it's worth a look too. Regards, Stephane Faroult Oriole -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: alter system does not work as advertised
Some parameters just never make it to the data dictionary... In 8i there supposedly is an init.ora parameter called create_stored_outlines = true ... can't find it referenced anywhere though in the data dictionary. use_stored_outlines doesn't show up in the OEM parameter listings either. Oh well. Win some, lose some. Patrice. -Original Message- Sent: Thursday, August 28, 2003 3:59 AM To: Multiple recipients of list ORACLE-L Hi! It works in 9.2.0.4 on W2k, so it might be a bug. I've seen other problematic parametrs as well in previous patch levels. Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, August 28, 2003 3:24 AM Maybe somebody can enlighten me on this, if I do a alter system set session_cached_cursors=100 scope=spfile I get the following message back ERROR at line 1: ORA-02096: specified initialization parameter is not modifiable with this option According to the documentation, by specifying scope=spfile, then The change is made in the server parameter file (SPFILE) only and will be set on the next startup Going by that statement, even though the variable is not-modifiable when the instance is up, I should still be able to change the parameter, then when I shutdown/startup the database during the night, the NEW value should take. If I can't modify the parameter in the spfile only, whats the point of the command ?? Is this a bug or a feature ?? Thanks Darren -- Darren Browett P.Eng This message was transmitted Data Administrator using 100% recycled electrons Information and Communication Technology City of Coquitlam P:(604)927 - 3614 E:[EMAIL PROTECTED] --- -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Browett, Darren INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Re: Grid
atm is obsolete. cheap is relative. i didnt mean its $20/month or comparable to getting AOL. alot of mid-large businesses have them. From: Tanel Poder [EMAIL PROTECTED] Date: 2003/08/28 Thu AM 03:14:26 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: Grid Hi! It's still quite hard to believe, that it could be anywhere near cheap. Even building 10Gbit locatl Ethernet is currently expensive. You would need 16*655Mb ATM connections for that to do over long range... Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, August 28, 2003 6:44 AM no not over the atlantic. its from DC to Boston. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, August 27, 2003 7:39 PM 10GB over Atlantic? This does cost a lot. At least I assume so, why the heck am I sticking to 512kb in my home then? Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, August 28, 2003 1:54 AM i havent seen much about internet 2. i didnt realize there was anything in production yet. do you know where i can find more info on it? 2.3 GBs isnt really that much for a connect anymore. its not that expensive to get 10GB connections or more. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, August 27, 2003 5:44 PM We've been talking of Grid computing here since either late 1999 or early 2000. The computing for our main experiment was designed before the Grid was contemplated. Still we have implemented some of the middleware needed, and build methods of authentication and authorization, and participated in Grid experiments. We have also been pushing the ability to transfer large amounts of data. The latest effort: 2.3 GB per second between the local internet hub and Geneva Switzerland over Internet 2. This is vital to make the Grid work. Yep, you'll probably have huge amounts of data coming in when CERN gets their large hadron collider online in 2007 ;) Btw, AFAIK, they're using Oracle... Tanel. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ryan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ryan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line
RE: Virtual Circuit Status
Hi Erik, MTS uses a common queue for incoming requests (calls) to shared servers, and other queues for responses going back via a dispatcher. These queues and their clients constitute the virtual circuit. When a process is ready to take a request or response from its queue, but finds that there is nothing there, then it waits for 'virtual circuit status' to change. So, if you're using MTS and you're not spending a lot of time in this wait event, then that indicates that your requests and responses are being delayed by queue time (which incidentally is not yet picked up by StatsPack, although it is in the V$ views, nor is it visible in the trace files because the waiting session does not have a corresponding process that is waiting). @ Regards, @ Steve Adams @ http://www.ixora.com.au/ - For DBAs @ http://www.christianity.net.au/ - For all -Original Message- Williams Sent: Thursday, 28 August 2003 4:49 AM To: Multiple recipients of list ORACLE-L Has anyone run into excessive waits on this event? After running my statspack through oraperf.com, I see that I am waiting ~80% of response time on this event. I have read on metalink that this is NOT an idle event, and on asktom.oracle.com that it IS an idle event. We have MTS configured, but all the clients are set to use dedicated server. Should I try reduce this event by tuning MTS or is it truely an idle event? Thanks Erik -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Steve Adams INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 invoke stored procedures from another instance?
RE: OT: Hey Jared!! -90 degree OT Joke
Rachel Carmichael scribbled on the wall in glitter crayon: sorry -- I read novels, respond visually to things, do math, remember faces but not names, see details AND the big picture so either I am more highly evolved and use both sides of my brain (not hardly) or the theory needs some modification i'm going for you being a more highly evolved life form meself.;-) -- Bill Shrek Thater ORACLE DBA BAARF Party member #25 [EMAIL PROTECTED] Unless Americans come to realize that they are not stronger in the world because they have the bomb but weaker because of their vulnerability to atomic attack, they are not likely to conduct their policy at Lake Success [the United Nations] or in their relations with Russia in a spirit that furthers the arrival at an understanding. - Albert Einstein -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Thater, William INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 invoke stored procedures from another instance?
For this AQ or possibly streams in 9i would be the best, but there is a bit of work to get either set up and functioning the way you want. The big benefit is done right you cant lose a message from one system to the other. This is fundamentally EAI integration without the messaging server. You could effectively though have an EAI adaptor for your application with a bit of additional thought Cheers -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238 Facsimile: +61 (0)7 3303 3048 = If people did not sometimes do silly things, nothing intelligent would ever get done. - Ludwig Wittgenstein = Mincom The People, The Experience, The Vision = This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please delete it and notify the sender. The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Group of companies unless expressly stated otherwise. Ranganath K [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 28/08/2003 08:15 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:How to invoke stored procedures from another instance? Hi listers, Assume that there are two instances in Oracle. Both instances are on different machines and different Oracle versions. There is a table on first instance. Any update on this table should invoke stored procedures on the second instance. This should be real time based. Options we looked at are 1. Trigger on the table invoking the procedures of the other instance 2. Using dbms_alert 3. Some kind of polling mechanism Triggers we would like to avoid. Options we are left with are dbms_alert and polling mechanism. Is it possible to use dbms_alert in this case? If yes how? Can you think of some kind of polling mechanism which will satisfy the need of real time communication? Updates on the table is done at a very fast rate, hence processing should also be at a fast rate. Any help in this regard is very much appreciated. Thanks and Regards, Ranganath MailFiler [RK-FM8B9B3] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- 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[2]: International Language Support Experiences?
Tanel wrote: IIRC, you can't store LOBs in UTF8 since it's a variable width charset? and then Richard wrote: You are correct except it is supported with 8i, make sure compatible parameter is set to 8.1.x. I bumped into this issue very recently. Oracle's direction seems to be to always use UTF-16 (or some other non-variable-width Unicode character set, depending on the release of Oracle you are running) for CLOB columns when the database character set is a Unicode character set such as UTF-8. I don't think I'd want to set COMPATIBLE to 8.1.x just to allow the use of UTF-8 in CLOBs, unless I had to do that to support legacy applications. To do that for a new app practically guarantees that you'll be doing a conversion at some point in the future, because eventually you'll want to be compatible with some release that is newer than 8.1. Best regards, Jonathan Gennick --- Brighten the corner where you are http://Gennick.com * 906.387.1698 * mailto:[EMAIL PROTECTED] Join the Oracle-article list and receive one article on Oracle technologies per month by email. To join, visit http://four.pairlist.net/mailman/listinfo/oracle-article, or send email to [EMAIL PROTECTED] and include the word subscribe in either the subject or body. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jonathan Gennick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: OT: Hey Jared!! -90 degree OT Joke
Hmmm... So you're saying that women aren't in their right mind? Taking it to the off topic list. -Original Message- Sent: Thursday, August 28, 2003 2:59 AM To: Multiple recipients of list ORACLE-L Hi, This is my own theory, you can't find this information from Oracle Document. Well... talking about women and men. I believe most women use their left brain more than right brain and most men use their right brain more than left brain. Function of left brain - remember things, - small thing but detail (this is the reason why women take 1/2 a day to buy a pair of shoe, and not that easy fall in love) - person names - history - words (perhaps this is the reason why women like to read novels) Function of right brain - response to things (quick decision maker) - this is the reason why so many 2 minute men in the world - everything in general (see thing in big picture) - person faces - math, 1 + 3 / 7 ^ 53 = X - pictures Well Friends train both side of your brain, and for male DBA use your left brain when talk to women, then she is yours. RF tell me if I am wrong PS: Just kidding., going to see Mars tonight I miss my home town. :) Sinardy -Original Message- Sent: 28 August 2003 06:25 To: Multiple recipients of list ORACLE-L Women are also particularily good at remembering small nasty things from past which you've already forgotten long time ago. Especially during fights... :) Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, August 28, 2003 12:59 AM Not being sexist in any way, but it's my experience that Women are much better generalists than men, but that men are much better specialists. Thats why I think women do better in school early on, but once we men get into the University level and pick our speciality, we kick butt. My soon to be ex-wife was frequently much better remembering overall things than I was RF -Original Message- To: Multiple recipients of list ORACLE-L Sent: 8/27/2003 6:44 AM c'mon... any virus named SoBig has to have been written by a man :) (yes, sexist, I know) --- Tanel Poder [EMAIL PROTECTED] wrote: I've seen only one female in my life who would be capable of writing such virus. But that is not the issue (no offence, really). Women just don't waste their time on stuff like this. Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, August 27, 2003 4:54 AM Guy? You've eliminated 50% of all possible suspects... on 8/26/03 1:44 PM, Tanel Poder at [EMAIL PROTECTED] wrote: I doubt they will ever find the real guy behind this. Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, August 26, 2003 10:19 PM For all you virus/worm lovers out there, justice do come: FBI Subpoenas Arizona ISP In Sobig Probe Easynews says it's cooperating with the bureau to find the person who uploaded the virus to a Usenet group it hosts. informationweek.com/story/showArticle.jhtml?articleID=13800091 Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Goulet, Dick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services
Re: perl/shell script for alert log
check http://www.dba-village.com/dba/village/dvp_scripts.ScriptDetails?ScrId=993 - Original Message - From: AK To: Multiple recipients of list ORACLE-L Sent: Wednesday, August 27, 2003 10:44 PM Subject: perl/shell script for alert log I am sure you guys might have some nice perl/shell script to analyze alert log for errors or potential problem . Can you share it with me /list . Ohh thanks in advance guys . -ak
Congratulations Arup (DBA of the Year)
Just came to know from CTOUG news that Oracle has chosen Arup Nanda(our List member) as DBA of the Year. Congratulations Arup. thought I will share this news with the group. CTOUG Board Member, Arup Nanda, Chosen as DBA of the Year Oracle has chosen our very own CTOUG board member, Arup Nanda, as the DBA of the Year, out of some quarter million DBAs worldwide. There will be a felicitation ceremony at OracleWorld and the award recipients will be featured in Nov-Dec issue of Oracle Magazine. Thought you would like to know, as a part of the CTOUG community. In his interview, he has mentioned CTOUG, so watch for it. Arup is President of Proligence (http://www.proligence.com/). Thanks. Best Regards, Prasad -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- 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).
Results of OCS mailing list survey
Hi folks -- Response to my survey was dismal at best. Am I on that many kill lists? ;-) Anyhow, here are the counts: For: 3 Against: 1 Even though the response was 3:1 for the list, four people will not be able to carry a mailing list, so I will not be adding one at this time. Perhaps as OCS matures, there will be more demand. thanks, bruce -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bruce A. Bergman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Congratulations Arup (DBA of the Year)
Title: RE: Congratulations Arup (DBA of the Year) Congratulations Arup !! Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 28, 2003 10:54 AM To: Multiple recipients of list ORACLE-L Subject: Congratulations Arup (DBA of the Year) Just came to know from CTOUG news that Oracle has chosen Arup Nanda(our List member) as DBA of the Year. Congratulations Arup. thought I will share this news with the group. CTOUG Board Member, Arup Nanda, Chosen as DBA of the Year Oracle has chosen our very own CTOUG board member, Arup Nanda, as the DBA of the Year, out of some quarter million DBAs worldwide. There will be a felicitation ceremony at OracleWorld and the award recipients will be featured in Nov-Dec issue of Oracle Magazine. Thought you would like to know, as a part of the CTOUG community. In his interview, he has mentioned CTOUG, so watch for it. Arup is President of Proligence (http://www.proligence.com/). Thanks. Best Regards, Prasad *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: How to invoke stored procedures from another instance?
It could be a combination of trigger/pooling. Trigger writes changes locally into some kind queue table. The second instance is pooling this queue table (using db link) at it's own rate without affecting transactions against original table. Also, in this case when network is down, original instance is not affected, and when network restored the second instance picks up where it stopped before network was down. I have this mechanism implemented here, and it works pretty smoothly. Igor Neyman, OCP DBA [EMAIL PROTECTED] -Original Message- Stephane Faroult Sent: Thursday, August 28, 2003 6:00 AM To: Multiple recipients of list ORACLE-L Hi listers, =20 Assume that there are two instances in Oracle. Both instances are on = different machines and different Oracle versions. There is a table on = first instance. Any update on this table should invoke stored procedures = on the second instance. This should be real time based. Options we = looked at are =20 1. Trigger on the table invoking the procedures of the other instance 2. Using dbms_alert 3. Some kind of polling mechanism =20 Triggers we would like to avoid. Options we are left with are dbms_alert = and polling mechanism.=20 =20 Is it possible to use dbms_alert in this case? If yes how? =20 Can you think of some kind of polling mechanism which will satisfy the = need of real time communication? Updates on the table is done at a very = fast rate, hence processing should also be at a fast rate. =20 Any help in this regard is very much appreciated. =20 Thanks and Regards, =20 Ranganath =20 I agree with your reluctance to use triggers; the problem is that whenever the second instance is down, then you couldn't do anything on the first. Basically, what you want to implement are near real-time although not quite synchronous snapshots. I have never used DBMS_ALERT in this way, but I think that it would be possible to have a database link on the second instance referencing the first one and invoking DBMS_ALERT through it. Beware with DBMS_ALERT though, my memories are not very fresh but there are some problems with COMMITs (which you can workaround with autonomous transactions, but then the alertee can be woken up by a rolled back transaction, a case which has to be handled by your code); DBMS_PIPE is another solution, which also has its flaws. Avanced queuing seems to me to be a fine mess, but perhaps it's worth a look too. Regards, Stephane Faroult Oriole -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Igor Neyman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: VPN access to 9ias instance behind firewall
Title: Message Mladen/Jared - please send. I would be really grateful. Thanks, Paula -Original Message-From: Mladen Gogala [mailto:[EMAIL PROTECTED]Sent: Wednesday, August 27, 2003 5:45 PMTo: Multiple recipients of list ORACLE-LSubject: RE: VPN access to 9ias instance behind firewall Yes, there is a way of doing that through a SSH tunnel. I have the bookmark at home, I'll send it to you as soon as I get there (~7 P.M. EST, it is 4:41 EST now). Jared also has it, so he may be so nice to send it to you. --Mladen GogalaOracle DBA -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED]Sent: Wednesday, August 27, 2003 5:34 PMTo: Multiple recipients of list ORACLE-LSubject: RE: VPN access to 9ias instance behind firewall Any suggestions? -Original Message-From: Dong, Ping - Raleigh, NC [mailto:[EMAIL PROTECTED]Sent: Wednesday, August 27, 2003 4:54 PMTo: Multiple recipients of list ORACLE-LSubject: RE: VPN access to 9ias instance behind firewall -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]Sent: Wednesday, August 27, 2003 4:30 PMTo: Multiple recipients of list ORACLE-LSubject: RE: VPN access to 9ias instance behind firewall Guys, When user trys to run our application through a VPN behind the firewall in a url they get an error. They can use ssh to get to host where I installed the application server but not run the application through their browser. Anyone deal with this issue before? Thanks, Paula Note: 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.Wang Trading LLCand any of its subsidiaries each reserve the right to monitor 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 the views of any such entity.
Re: Need help with an error ORA-12640
How does the application connect to the database? username/password or '/'? Jared On Wed, 2003-08-27 at 23:19, Lee, Peter (AZ15) wrote: Guru: I need help with an error ORA-12640. I have a Oracle 8.1.7 database with 8.1.7.4 patch running on Windows 2000. The sqlnet.authentication_services=(NTS) parameter is enabled and we do not want to change the sqlnet.authentication_services=(NONE). The custom SQL application is launched by a Domain User on the Oracle Server machine. If the Domain user has local administrative privileges, it works with no error. If the Domain user does not have local adminstrative privileges, it fails with the above error. I am at a lost to explain this. Does anyone has any idea? Thank you in advance. Pete -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Lee, Peter (AZ15) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 with an error ORA-12640
Jarad: username/password Thank in advance, Pete -Original Message- Sent: Thursday, August 28, 2003 8:15 AM To: Multiple recipients of list ORACLE-L How does the application connect to the database? username/password or '/'? Jared On Wed, 2003-08-27 at 23:19, Lee, Peter (AZ15) wrote: Guru: I need help with an error ORA-12640. I have a Oracle 8.1.7 database with 8.1.7.4 patch running on Windows 2000. The sqlnet.authentication_services=(NTS) parameter is enabled and we do not want to change the sqlnet.authentication_services=(NONE). The custom SQL application is launched by a Domain User on the Oracle Server machine. If the Domain user has local administrative privileges, it works with no error. If the Domain user does not have local adminstrative privileges, it fails with the above error. I am at a lost to explain this. Does anyone has any idea? Thank you in advance. Pete -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Lee, Peter (AZ15) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Lee, Peter (AZ15) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
alter system dump logfile
Title: alter system dump logfile Hi all, as mentioned in Metalink article, one can use ALTER SYSTEM DUMP LOGFILE ... LAYER 11 OPCODE 3 to dump deleted rows from archived logs. does anyone know 1. what others layers are and what they correspond to? 2. what other opcodes are and what they relate to? TIA Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! *This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.*1
RE: How to keep root out?
-Original Message-From: Walter K [mailto:[EMAIL PROTECTED]Sent: Thursday, August 28, 2003 11:34 AMTo: Multiple recipients of list ORACLE-LSubject: How to keep "root" out? So, I'm curious,is there any way to prevent access via "connect internal" or "/ as sysdba"?[Shrek] well maybe there is, but then they could just do a "su - oracle" and get right back in. -- Bill "Shrek" Thater ORACLE DBA BAARF Party member #25 [EMAIL PROTECTED] Capital letters were always the best way of dealing with things you didn't have a good answer to. - Douglas Adams
Building dynamic sql that will do CSV
I'm trying to build
something like this:
select 'select
'''||TABLE_NAME||','||COLUMN_NAME||''', ''',''',
min('||COLUMN_NAME||'),max('||COLUMN_NAME||') from
' ||OWNER||'.'||TABLE_NAME||'
where '||COLUMN_NAME||' is not
null;' FROM
dba_tab_columns WHERE table_name
in
('PAYMENTS_RECEIVED','ADDRESS_VAL','BATCH_CONTROL',
'CUSTOMER','CUSTOMER_DEFAULT','EXPLODED_PRODUCT','EXPLODED_PUBLICATION',
'EXPLOSION','ORDERS_MERCH','INVOICE','INVOICE_MERCH','CLIENT_SAMPLES','INVENTORY')
AND OWNER = 'HIST'order by owner, table_name,
column_id;
which gives me
select
'CLIENT_SAMPLES,SAMPLE_DATE5', '',
min(SAMPLE_DATE5),
max(SAMPLE_DATE5) from HIST.CLIENT_SAMPLES where SAMPLE_DATE5 is not
null;
and an output
of:
CLIENT_SAMPLES,SAMPLE_DATE5
0
11/09/2002 09:38
What I want is a
"comma" between everything and perhaps ", but building this dynamically has got
my brain all fuddled. Trying to figure out what to build in the dynamic to get
the executed sql to look right... I just can't seem to get the right
combination...
I'd like something
like:
CLIENT_SAMPLES,SAMPLE_DATE5,
0
,11/09/2002 09:38
or
"CLIENT_SAMPLES","SAMPLE_DATE5","0
","11/09/2002 09:38"
Michael Alan Kline, Sr.PrincipalConsultantBusiness to Business
Solutions, LLCPhone: 804-744-1545 Cell: 804-314-6262ICQ: 1009605,
975313Email: [EMAIL PROTECTED] Web: www.b2bsol.com
Re: oracle sessions from term server
Thanks Tanel , for the reply . Does it mean that windows term server is keeping that tcp connection alive although user session is dropped from OS(windows terminal server ) . Is there a way i can trace this tcp session . Thanks, Ajay - Original Message - From: Tanel Poder To: Multiple recipients of list ORACLE-L Sent: Thursday, August 28, 2003 12:09 AM Subject: Re: oracle sessions from term server The TCP connection to Oracle server process (or dispatcher) port probably remains alive for some reason. When TCP connection is dropped from OS, the session dies immediately.So you should check why are sessions TCP connections maintained or set sqlnet.expire_time to one hour or smth, to kill sessions after an hour even if TCP connection for given sessionis still open. Tanel. - Original Message - From: AK To: Multiple recipients of list ORACLE-L Sent: Wednesday, August 27, 2003 9:09 PM Subject: oracle sessions from term server Hi Guys , we have forms/report application installed on windows terminal servers and user access application from these terminal servers . When some session hangs on these term server adminstrator resets those sessions . But the corresponding database session remains alive . Is it s problem with some sql*net setting ?? Any help in this regard is highly appreciated . thanks, -ak
RE: Congratulations Arup (DBA of the Year)
Not being a party pooper but what does DBA of the Year actually mean. What criteria was used. How can Oracle know about a quarter of a million DBA's unless it monitors tars raised. John -Original Message- [mailto:[EMAIL PROTECTED] Sent: 28 August 2003 15:54 To: Multiple recipients of list ORACLE-L Just came to know from CTOUG news that Oracle has chosen Arup Nanda(our List member) as DBA of the Year. Congratulations Arup. thought I will share this news with the group. CTOUG Board Member, Arup Nanda, Chosen as DBA of the Year Oracle has chosen our very own CTOUG board member, Arup Nanda, as the DBA of the Year, out of some quarter million DBAs worldwide. There will be a felicitation ceremony at OracleWorld and the award recipients will be featured in Nov-Dec issue of Oracle Magazine. Thought you would like to know, as a part of the CTOUG community. In his interview, he has mentioned CTOUG, so watch for it. Arup is President of Proligence (http://www.proligence.com/). Thanks. Best Regards, Prasad -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- 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 ORACLE-L FAQ: http://www.orafaq.net -- Author: Hallas, John, Tech Dev INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: optimizer_max_permutations
This makes me think of a stat that would be nice to see...it would be nice if I could see how many permutations the database was going through for each sql statement that it parsed. I might have a database that rarely uses more than 1000 permutations and I might have one that typically uses 10,000. By determining how often the statement is parsed and how many average permutations are used I might be able to more effectively judge the impact of lowering or raising this value. -Original Message- Sent: Tuesday, August 26, 2003 11:00 AM To: Multiple recipients of list ORACLE-L Yes, it is required in one of our COTS applications. Inserts into complex views with instead-f triggers. The views are quite complex, ridiculously so, one might say. Before setting optimizer_max_permutations=1000, it took a very long time to parse those views. Jared On Tue, 2003-08-26 at 05:44, Boivin, Patrice J wrote: Has anyone worked with this one? http://download-west.oracle.com/docs/cd/A87860_01/doc/server.817/a76961/ch11 23.htm#81357 http://download-west.oracle.com/docs/cd/A87860_01/doc/server.817/a76961/ch1 123.htm#81357 Patrice. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Post, Ethan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Building dynamic sql that will do CSV
set colsep ','
might help too.
Raj
Rajendra dot Jamadagni at nospamespn dot
com All Views expressed in this email
are strictly personal. QOTD: Any clod
can have facts, having an opinion is an art !
-Original Message-From: Michael Kline
[mailto:[EMAIL PROTECTED]Sent: Thursday, August 28, 2003 11:50
AMTo: Multiple recipients of list ORACLE-LSubject:
Building dynamic sql that will do CSV
I'm trying to
build something like this:
select 'select
'''||TABLE_NAME||','||COLUMN_NAME||''', ''',''',
min('||COLUMN_NAME||'),max('||COLUMN_NAME||') from
' ||OWNER||'.'||TABLE_NAME||'
where '||COLUMN_NAME||' is not
null;' FROM
dba_tab_columns WHERE table_name
in
('PAYMENTS_RECEIVED','ADDRESS_VAL','BATCH_CONTROL',
'CUSTOMER','CUSTOMER_DEFAULT','EXPLODED_PRODUCT','EXPLODED_PUBLICATION',
'EXPLOSION','ORDERS_MERCH','INVOICE','INVOICE_MERCH','CLIENT_SAMPLES','INVENTORY')
AND OWNER = 'HIST'order by owner, table_name,
column_id;
which gives me
select
'CLIENT_SAMPLES,SAMPLE_DATE5', '',
min(SAMPLE_DATE5),
max(SAMPLE_DATE5) from HIST.CLIENT_SAMPLES where SAMPLE_DATE5 is not
null;
and an output
of:
CLIENT_SAMPLES,SAMPLE_DATE5
0
11/09/2002 09:38
What I want is a
"comma" between everything and perhaps ", but building this dynamically has
got my brain all fuddled. Trying to figure out what to build in the dynamic to
get the executed sql to look right... I just can't seem to get the right
combination...
I'd like
something like:
CLIENT_SAMPLES,SAMPLE_DATE5,
0
,11/09/2002 09:38
or
"CLIENT_SAMPLES","SAMPLE_DATE5","0
","11/09/2002 09:38"
Michael Alan Kline, Sr.PrincipalConsultantBusiness to Business
Solutions, LLCPhone: 804-744-1545 Cell: 804-314-6262ICQ:
1009605, 975313Email: [EMAIL PROTECTED] Web: www.b2bsol.com
This e-mail
message is confidential, intended only for the named recipient(s) above and may
contain information that is privileged, attorney work product or exempt from
disclosure under applicable law. If you have received this message in error, or are
not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000
and delete this e-mail message from your computer, Thank
you.*2
RE: optimizer_max_permutations
turns out the parameter only governs how much time the optimizer can spend looking for the best execution plan... 8 means no limit, OK for small SQL queries but for complex ones parsing can take too long. So this has nothing to do with TEMP space usage after all. sort_area_size is probably the one for TEMP. Patrice. -Original Message- Sent: Tuesday, August 26, 2003 11:58 AM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Yes, it is required in one of our COTS applications. Inserts into complex views with instead-f triggers. The views are quite complex, ridiculously so, one might say. Before setting optimizer_max_permutations=1000, it took a very long time to parse those views. Jared On Tue, 2003-08-26 at 05:44, Boivin, Patrice J wrote: Has anyone worked with this one? http://download-west.oracle.com/docs/cd/A87860_01/doc/server.817/a76961/ch11 23.htm#81357 http://download-west.oracle.com/docs/cd/A87860_01/doc/server.817/a76961/ch1 123.htm#81357 Patrice. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 keep root out?
Well, you can tell them "NOT" to do that. Theycan write scripts to monitor OS performance, but DBA is the one to monitor DB performance. You can aslo tell them you will be writing scripts to monitor Unix performance and probably make some changes in files in /etc directory.If they insist on doing that, write a message to them and cc to their manager so that they are responsible if something bad happens to the DB. Guang -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Walter KSent: Thursday, August 28, 2003 11:34 AMTo: Multiple recipients of list ORACLE-LSubject: How to keep "root" out? Just for grins, I'll ask this question... Is there any way to keep the Unix "root" user from logging into the database (i.e. connect internal or / as sysdba)? Currently using 8.1.7.4 on Solaris 8 here. We have a couple people in our Unix admin group that feel the need to "help" by writing their own DB monitoring scripts. Of course, they don't know what they're talking about. They do not have formal logins for the database, but since they are root users they are connecting via "connect internal". This is not only counterproductive but actually a potential security issue--just because someone has root doesn't necessarily entitle them to see the data in the database. What if it is a payroll database? So, I'm curious,is there any way to prevent access via "connect internal" or "/ as sysdba"? Thanks in advance. W
Re: Congratulations Arup (DBA of the Year)
Congrates Arup !!! You doing a great job . -ak - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, August 28, 2003 7:54 AM Just came to know from CTOUG news that Oracle has chosen Arup Nanda(our List member) as DBA of the Year. Congratulations Arup. thought I will share this news with the group. CTOUG Board Member, Arup Nanda, Chosen as DBA of the Year Oracle has chosen our very own CTOUG board member, Arup Nanda, as the DBA of the Year, out of some quarter million DBAs worldwide. There will be a felicitation ceremony at OracleWorld and the award recipients will be featured in Nov-Dec issue of Oracle Magazine. Thought you would like to know, as a part of the CTOUG community. In his interview, he has mentioned CTOUG, so watch for it. Arup is President of Proligence (http://www.proligence.com/). Thanks. Best Regards, Prasad -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- 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 ORACLE-L FAQ: http://www.orafaq.net -- Author: AK INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Virtual Circuit Status/wecome back
Steve, Welcome back, we all were missing your participation for long time... Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Thu, 28 Aug 2003 04:39:47 -0800 Hi Erik, MTS uses a common queue for incoming requests (calls) to shared servers, and other queues for responses going back via a dispatcher. These queues and their clients constitute the virtual circuit. When a process is ready to take a request or response from its queue, but finds that there is nothing there, then it waits for 'virtual circuit status' to change. So, if you're using MTS and you're not spending a lot of time in this wait event, then that indicates that your requests and responses are being delayed by queue time (which incidentally is not yet picked up by StatsPack, although it is in the V$ views, nor is it visible in the trace files because the waiting session does not have a corresponding process that is waiting). @ Regards, @ Steve Adams @ http://www.ixora.com.au/ - For DBAs @ http://www.christianity.net.au/ - For all -Original Message- Williams Sent: Thursday, 28 August 2003 4:49 AM To: Multiple recipients of list ORACLE-L Has anyone run into excessive waits on this event? After running my statspack through oraperf.com, I see that I am waiting ~80% of response time on this event. I have read on metalink that this is NOT an idle event, and on asktom.oracle.com that it IS an idle event. We have MTS configured, but all the clients are set to use dedicated server. Should I try reduce this event by tuning MTS or is it truely an idle event? Thanks Erik -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Steve Adams INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Get MSN 8 and help protect your children with advanced parental controls. http://join.msn.com/?page=features/parental -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: M 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).
Antw: Building dynamic sql that will do CSV
Hi Michael,
are you looking for something like:
SET COLSEP ','?
Greetings,
Guido
[EMAIL PROTECTED] 28.08.2003 17.49 Uhr
I'm trying to build something like this:
select 'select '''||TABLE_NAME||','||COLUMN_NAME||''', ''',''',
min('||COLUMN_NAME||'),
max('||COLUMN_NAME||') from '
||OWNER||'.'||TABLE_NAME||' where '||COLUMN_NAME||' is not null;'
FROM dba_tab_columns
WHERE table_name in
('PAYMENTS_RECEIVED','ADDRESS_VAL','BATCH_CONTROL',
'CUSTOMER','CUSTOMER_DEFAULT','EXPLODED_PRODUCT','EXPLODED_PUBLICATION',
'EXPLOSION','ORDERS_MERCH','INVOICE','INVOICE_MERCH','CLIENT_SAMPLES','INVEN
TORY')
AND OWNER = 'HIST'
order by owner, table_name, column_id;
which gives me
select 'CLIENT_SAMPLES,SAMPLE_DATE5', '
', min(SAMPLE_DATE5),
max(SAMPLE_DATE5) from HIST.CLIENT_SAMPLES where SAMPLE_DATE5 is
not null;
and an output of:
CLIENT_SAMPLES,SAMPLE_DATE5 011/09/2002 09:38
What I want is a comma between everything and perhaps , but building this
dynamically has got my brain all fuddled. Trying to figure out what to build
in the dynamic to get the executed sql to look right... I just can't seem to
get the right combination...
I'd like something like:
CLIENT_SAMPLES,SAMPLE_DATE5, 0,11/09/2002 09:38
or
CLIENT_SAMPLES,SAMPLE_DATE5,0,11/09/2002 09:38
Michael Alan Kline, Sr.
Principal Consultant
Business to Business Solutions, LLC
Phone: 804-744-1545 Cell: 804-314-6262
ICQ: 1009605, 975313
Email: [EMAIL PROTECTED] Web: www.b2bsol.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Guido Konsolke
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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 keep root out?
Sadly for you there is no way to stop them using it, you could check and see of root is part of the dba group and have a sysadmin remove it. and if you succeed then they need only to su - oracle and they can still do it, this may then if configured show up in a su log. I think you need to firstly discuss it with them and then if the response is unsuitable you need to document the facts and present it to your manager for him to determine what is acceptable. Tough one to call Cheers -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238 Facsimile: +61 (0)7 3303 3048 = If people did not sometimes do silly things, nothing intelligent would ever get done. - Ludwig Wittgenstein = Mincom The People, The Experience, The Vision = This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please delete it and notify the sender. The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Group of companies unless expressly stated otherwise. Walter K [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 29/08/2003 01:34 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:How to keep root out? Just for grins, I'll ask this question... Is there any way to keep the Unix root user from logging into the database (i.e. connect internal or / as sysdba)? Currently using 8.1.7.4 on Solaris 8 here. We have a couple people in our Unix admin group that feel the need to help by writing their own DB monitoring scripts. Of course, they don't know what they're talking about. They do not have formal logins for the database, but since they are root users they are connecting via connect internal. This is not only counterproductive but actually a potential security issue--just because someone has root doesn't necessarily entitle them to see the data in the database. What if it is a payroll database? So, I'm curious, is there any way to prevent access via connect internal or / as sysdba? Thanks in advance. W -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- 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: How to keep root out?
Well, first of all, root should not be in your dba group... -Original Message-From: Walter K [mailto:[EMAIL PROTECTED]Sent: Thursday, August 28, 2003 8:34 AMTo: Multiple recipients of list ORACLE-LSubject: How to keep "root" out? Just for grins, I'll ask this question... Is there any way to keep the Unix "root" user from logging into the database (i.e. connect internal or / as sysdba)? Currently using 8.1.7.4 on Solaris 8 here. We have a couple people in our Unix admin group that feel the need to "help" by writing their own DB monitoring scripts. Of course, they don't know what they're talking about. They do not have formal logins for the database, but since they are root users they are connecting via "connect internal". This is not only counterproductive but actually a potential security issue--just because someone has root doesn't necessarily entitle them to see the data in the database. What if it is a payroll database? So, I'm curious,is there any way to prevent access via "connect internal" or "/ as sysdba"? Thanks in advance. W
How to keep root out?
Just for grins, I'll ask this question... Is there any way to keep the Unix "root" user from logging into the database (i.e. connect internal or / as sysdba)? Currently using 8.1.7.4 on Solaris 8 here. We have a couple people in our Unix admin group that feel the need to "help" by writing their own DB monitoring scripts. Of course, they don't know what they're talking about. They do not have formal logins for the database, but since they are root users they are connecting via "connect internal". This is not only counterproductive but actually a potential security issue--just because someone has root doesn't necessarily entitle them to see the data in the database. What if it is a payroll database? So, I'm curious,is there any way to prevent access via "connect internal" or "/ as sysdba"? Thanks in advance. W
Re: Congratulations Arup (DBA of the Year)
Oracle has chosen our very own CTOUG board member, Arup Nanda, as the DBA of the Year, out of some quarter million DBAs worldwide. There will be a Not taking anything from Arup, but .out of some quarter million DBAs worldwide??? Are you trying to be Comical Ali, the second? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Binley Lim INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: How to keep root out?
Walter, First question, why are they logging on as "root" in the first place. That is akin to logging into the database as sys all the time, namely something to be avoided at all cost. Dick GouletSenior Oracle DBAOracle Certified 8i DBA -Original Message-From: Walter K [mailto:[EMAIL PROTECTED]Sent: Thursday, August 28, 2003 11:34 AMTo: Multiple recipients of list ORACLE-LSubject: How to keep "root" out? Just for grins, I'll ask this question... Is there any way to keep the Unix "root" user from logging into the database (i.e. connect internal or / as sysdba)? Currently using 8.1.7.4 on Solaris 8 here. We have a couple people in our Unix admin group that feel the need to "help" by writing their own DB monitoring scripts. Of course, they don't know what they're talking about. They do not have formal logins for the database, but since they are root users they are connecting via "connect internal". This is not only counterproductive but actually a potential security issue--just because someone has root doesn't necessarily entitle them to see the data in the database. What if it is a payroll database? So, I'm curious,is there any way to prevent access via "connect internal" or "/ as sysdba"? Thanks in advance. W
RE: Congratulations Arup (DBA of the Year)
Oh no! Somebody's jealous. My guess is CTOUG is the Connecticut Oracle Users's Group. You probably weren't in the running, if your email address indicates you aren't a member. John, we're all very appreciative of you as well. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, August 28, 2003 11:00 AM To: Multiple recipients of list ORACLE-L Not being a party pooper but what does DBA of the Year actually mean. What criteria was used. How can Oracle know about a quarter of a million DBA's unless it monitors tars raised. John -Original Message- [mailto:[EMAIL PROTECTED] Sent: 28 August 2003 15:54 To: Multiple recipients of list ORACLE-L Just came to know from CTOUG news that Oracle has chosen Arup Nanda(our List member) as DBA of the Year. Congratulations Arup. thought I will share this news with the group. CTOUG Board Member, Arup Nanda, Chosen as DBA of the Year Oracle has chosen our very own CTOUG board member, Arup Nanda, as the DBA of the Year, out of some quarter million DBAs worldwide. There will be a felicitation ceremony at OracleWorld and the award recipients will be featured in Nov-Dec issue of Oracle Magazine. Thought you would like to know, as a part of the CTOUG community. In his interview, he has mentioned CTOUG, so watch for it. Arup is President of Proligence (http://www.proligence.com/). Thanks. Best Regards, Prasad -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- 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 ORACLE-L FAQ: http://www.orafaq.net -- Author: Hallas, John, Tech Dev INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: How to keep root out?
rm -r * at root. : -Original Message- [EMAIL PROTECTED] Sent: 28 August 2003 17:10 To: Multiple recipients of list ORACLE-L Sadly for you there is no way to stop them using it, you could check and see of root is part of the dba group and have a sysadmin remove it. and if you succeed then they need only to su - oracle and they can still do it, this may then if configured show up in a su log. I think you need to firstly discuss it with them and then if the response is unsuitable you need to document the facts and present it to your manager for him to determine what is acceptable. Tough one to call Cheers -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238 Facsimile: +61 (0)7 3303 3048 = If people did not sometimes do silly things, nothing intelligent would ever get done. - Ludwig Wittgenstein = Mincom The People, The Experience, The Vision = This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please delete it and notify the sender. The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Group of companies unless expressly stated otherwise. Walter K [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 29/08/2003 01:34 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:How to keep root out? Just for grins, I'll ask this question... Is there any way to keep the Unix root user from logging into the database (i.e. connect internal or / as sysdba)? Currently using 8.1.7.4 on Solaris 8 here. We have a couple people in our Unix admin group that feel the need to help by writing their own DB monitoring scripts. Of course, they don't know what they're talking about. They do not have formal logins for the database, but since they are root users they are connecting via connect internal. This is not only counterproductive but actually a potential security issue--just because someone has root doesn't necessarily entitle them to see the data in the database. What if it is a payroll database? So, I'm curious, is there any way to prevent access via connect internal or / as sysdba? Thanks in advance. W -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- 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). --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.512 / Virus Database: 309 - Release Date: 19/08/2003 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.512 / Virus Database: 309 - Release Date: 19/08/2003 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
sanity check time...
Ok, i'm a unix guy i don't usually work with windows. well, the Keane office just called and some of the people over there are having trouble connecting to a windows 9i database. when i asked them if the services were running i got a basic huh? so what do i have to run to set up the services? and no i can't RTFM because i don't got the FM to R for windows nor access to technet since the worm attacks. [don't go there, i'm trying to explain that i kind of need to get to there and metalink to do my job.] -- Bill Shrek Thater ORACLE DBA BAARF Party member #25 [EMAIL PROTECTED] Sooner of later that which is now life shall be poetry, and every fair and manly trait shall add a richer strain to the song. - Ralph Waldo Emerson -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Thater, William INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 keep root out?
Walter You may be able to approach this from a security aspect. You could discuss with your management whether it is a good idea for the system administrators to be in a database. Depending on the security or SLA requirements of the database, you may have some leverage there. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, August 28, 2003 11:10 AM To: Multiple recipients of list ORACLE-L Well, first of all, root should not be in your dba group... -Original Message- Sent: Thursday, August 28, 2003 8:34 AM To: Multiple recipients of list ORACLE-L Just for grins, I'll ask this question... Is there any way to keep the Unix root user from logging into the database (i.e. connect internal or / as sysdba)? Currently using 8.1.7.4 on Solaris 8 here. We have a couple people in our Unix admin group that feel the need to help by writing their own DB monitoring scripts. Of course, they don't know what they're talking about. They do not have formal logins for the database, but since they are root users they are connecting via connect internal. This is not only counterproductive but actually a potential security issue--just because someone has root doesn't necessarily entitle them to see the data in the database. What if it is a payroll database? So, I'm curious, is there any way to prevent access via connect internal or / as sysdba? Thanks in advance. W -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: How to keep root out?
Help... my database isn't coming up anymore!! ;) Brian -Original Message- Mark Leith Sent: Thursday, August 28, 2003 11:24 AM To: Multiple recipients of list ORACLE-L rm -r * at root. : -Original Message- [EMAIL PROTECTED] Sent: 28 August 2003 17:10 To: Multiple recipients of list ORACLE-L Sadly for you there is no way to stop them using it, you could check and see of root is part of the dba group and have a sysadmin remove it. and if you succeed then they need only to su - oracle and they can still do it, this may then if configured show up in a su log. I think you need to firstly discuss it with them and then if the response is unsuitable you need to document the facts and present it to your manager for him to determine what is acceptable. Tough one to call Cheers -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238 Facsimile: +61 (0)7 3303 3048 = If people did not sometimes do silly things, nothing intelligent would ever get done. - Ludwig Wittgenstein = Mincom The People, The Experience, The Vision = This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please delete it and notify the sender. The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Group of companies unless expressly stated otherwise. Walter K [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 29/08/2003 01:34 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:How to keep root out? Just for grins, I'll ask this question... Is there any way to keep the Unix root user from logging into the database (i.e. connect internal or / as sysdba)? Currently using 8.1.7.4 on Solaris 8 here. We have a couple people in our Unix admin group that feel the need to help by writing their own DB monitoring scripts. Of course, they don't know what they're talking about. They do not have formal logins for the database, but since they are root users they are connecting via connect internal. This is not only counterproductive but actually a potential security issue--just because someone has root doesn't necessarily entitle them to see the data in the database. What if it is a payroll database? So, I'm curious, is there any way to prevent access via connect internal or / as sysdba? Thanks in advance. W -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- 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). --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.512 / Virus Database: 309 - Release Date: 19/08/2003 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.512 / Virus Database: 309 - Release Date: 19/08/2003 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Brian McGraw INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB
RE: sql optimization question
Dave: Thanks! That works great. Guang -Original Message- Dave Hau Sent: Wednesday, August 27, 2003 4:29 PM To: Multiple recipients of list ORACLE-L select distinct n.cognateid, m.isirefid,4, linkdate from mt.externallink l, refidmatch m, nametag n where l.objectid = n.geneid and m.pubmedid = l.identifier and externaldbid = 9 and l.identifier in (select identifier from mt.externallink where externaldbid = 9 group by identifier having count(distinct objectid) 6); HTH, Dave [EMAIL PROTECTED] wrote: Hi, This query took a few minues to return 126K rows (fast): select distinct n.cognateid, m.isirefid,4, linkdate from mt.externallink l, refidmatch m, nametag n where l.objectid = n.geneid and m.pubmedid = l.identifier and externaldbid = 9; But this query took hours and still no result, I had to kill it: select distinct n.cognateid, m.isirefid,4, linkdate from mt.externallink l, refidmatch m, nametag n where l.objectid = n.geneid and m.pubmedid = l.identifier and externaldbid = 9 and (select count(distinct objectid) from mt.externallink k where k.identifier = l.identifier and externaldbid = 9 and l.objectid !=k.objectid)5; All the related columns are indexed and table are analyzed. Is there a way to re-write the part select count(distinct objectid) from mt.externallink k where k.identifier = l.identifier and externaldbid = 9 and l.objectid !=k.objectid)5 to make the whole thing faster? TIA. Guang -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Guang Mei INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: sanity check time...
Bill, all services should be starting automatically, but you can check the following: From the NT prompt, type NET START. You should see a list of what services are running. All Oracle services start with ORACLE. If things are not running, you can do the obvious - run lsnrctl to get the listener running. If you do not see and database services running, you need to determine what services have been created. You can go to the NT Services panel and start them. I hope you don't need to create a new database - I'm assuming that it is alredy installed. Good Luck! Tom Mercadante Oracle Certified Professional -Original Message- Sent: Thursday, August 28, 2003 12:25 PM To: Multiple recipients of list ORACLE-L Ok, i'm a unix guy i don't usually work with windows. well, the Keane office just called and some of the people over there are having trouble connecting to a windows 9i database. when i asked them if the services were running i got a basic huh? so what do i have to run to set up the services? and no i can't RTFM because i don't got the FM to R for windows nor access to technet since the worm attacks. [don't go there, i'm trying to explain that i kind of need to get to there and metalink to do my job.] -- Bill Shrek Thater ORACLE DBA BAARF Party member #25 [EMAIL PROTECTED] Sooner of later that which is now life shall be poetry, and every fair and manly trait shall add a richer strain to the song. - Ralph Waldo Emerson -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Thater, William INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: How to keep root out?
Should keep the Unix weenies from bugging your database for at least a short time, if all else fails! ;) -Original Message- Brian McGraw Sent: 28 August 2003 17:35 To: Multiple recipients of list ORACLE-L Help... my database isn't coming up anymore!! ;) Brian -Original Message- Mark Leith Sent: Thursday, August 28, 2003 11:24 AM To: Multiple recipients of list ORACLE-L rm -r * at root. : -Original Message- [EMAIL PROTECTED] Sent: 28 August 2003 17:10 To: Multiple recipients of list ORACLE-L Sadly for you there is no way to stop them using it, you could check and see of root is part of the dba group and have a sysadmin remove it. and if you succeed then they need only to su - oracle and they can still do it, this may then if configured show up in a su log. I think you need to firstly discuss it with them and then if the response is unsuitable you need to document the facts and present it to your manager for him to determine what is acceptable. Tough one to call Cheers -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238 Facsimile: +61 (0)7 3303 3048 = If people did not sometimes do silly things, nothing intelligent would ever get done. - Ludwig Wittgenstein = Mincom The People, The Experience, The Vision = This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please delete it and notify the sender. The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Group of companies unless expressly stated otherwise. Walter K [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 29/08/2003 01:34 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:How to keep root out? Just for grins, I'll ask this question... Is there any way to keep the Unix root user from logging into the database (i.e. connect internal or / as sysdba)? Currently using 8.1.7.4 on Solaris 8 here. We have a couple people in our Unix admin group that feel the need to help by writing their own DB monitoring scripts. Of course, they don't know what they're talking about. They do not have formal logins for the database, but since they are root users they are connecting via connect internal. This is not only counterproductive but actually a potential security issue--just because someone has root doesn't necessarily entitle them to see the data in the database. What if it is a payroll database? So, I'm curious, is there any way to prevent access via connect internal or / as sysdba? Thanks in advance. W -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- 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). --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.512 / Virus Database: 309 - Release Date: 19/08/2003 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.512 / Virus Database: 309 - Release Date: 19/08/2003 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Brian McGraw INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services
Re: oracle sessions from term server
I used to deal with this on a regular basis. Sun servers, PC clients. User reboots PC, session persists. It does not require that the TCP session still exists. We didn't use DCD at the time, as it was kind of buggy. You may want to give that a try now. Jared On Thu, 2003-08-28 at 08:54, AK wrote: Thanks Tanel , for the reply . Does it mean that windows term server is keeping that tcp connection alive although user session is dropped from OS(windows terminal server ) . Is there a way i can trace this tcp session . Thanks, Ajay - Original Message - From: Tanel Poder To: Multiple recipients of list ORACLE-L Sent: Thursday, August 28, 2003 12:09 AM Subject: Re: oracle sessions from term server The TCP connection to Oracle server process (or dispatcher) port probably remains alive for some reason. When TCP connection is dropped from OS, the session dies immediately. So you should check why are sessions TCP connections maintained or set sqlnet.expire_time to one hour or smth, to kill sessions after an hour even if TCP connection for given session is still open. Tanel. - Original Message - From: AK To: Multiple recipients of list ORACLE-L Sent: Wednesday, August 27, 2003 9:09 PM Subject: oracle sessions from term server Hi Guys , we have forms/report application installed on windows terminal servers and user access application from these terminal servers . When some session hangs on these term server adminstrator resets those sessions . But the corresponding database session remains alive . Is it s problem with some sql*net setting ?? Any help in this regard is highly appreciated . thanks, -ak -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 keep root out?
Thursday, August 28, 2003, 11:34:27 AM, Walter wrote: WK We have a couple people in our Unix admin group that feel the need to help by WK writing their own DB monitoring scripts. Of course, they don't know what they're WK talking about. Why, the dasterdly do-gooders! How dare they!grin You know, one approach, and some might see this as heretical, is to simply give them a safer login that lets them query the V$ views. I'd probably let a sys admin look at those if he/she really wanted to, though I've been fortunate to always work with admins I trust not to go off the deep end and actually change anything without talking to me first. I've given developers access to V$ views on development and test instances. That never caused me any problems or grief. So you give your sys admins access, and you make it very clear that *you* are the DBA, and that if they find something significant, they should come to you about it; they should not make changes themselves. A good sys admin ought to understand that. After all, they are in much the same boat. They don't want you mucking about too much with the o/s. I wouldn't try to fight this battle by attempting to lock them out of your database in a technical manner, such as via a password protection. After all, they are the sys admins, and they can pretty much do anything. I'd approach this as a management issue. It is a management issue. Go to your management and point out that *you* are the DBA, that *you* have bottom-line responsibility for the databases, and make a case that your sys admins are abusing their privileges, and thereby compromising your ability to maintain a stable database environment. A good manager will understand that. But first I'd try to work with my sys admin in a more friendly manner. If he just wants to monitor, and is willing to commit to not making a *change*, then why not let him have at it? He might learn something about Oracle and become a useful ally. Or he might lose interest after awhile. Best regards, Jonathan Gennick --- Brighten the corner where you are http://Gennick.com * 906.387.1698 * mailto:[EMAIL PROTECTED] Join the Oracle-article list and receive one article on Oracle technologies per month by email. To join, visit http://four.pairlist.net/mailman/listinfo/oracle-article, or send email to [EMAIL PROTECTED] and include the word subscribe in either the subject or body. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jonathan Gennick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Building dynamic sql that will do CSV
see http://www.cybcon.com/~jkstill/util/dump/dump.html
On Thu, 2003-08-28 at 08:49, Michael Kline wrote:
I'm trying to build something like this:
select 'select '''||TABLE_NAME||','||COLUMN_NAME||''', ''',''',
min('||COLUMN_NAME||'),
max('||COLUMN_NAME||') from '
||OWNER||'.'||TABLE_NAME||' where '||COLUMN_NAME||' is not null;'
FROM dba_tab_columns
WHERE table_name in
('PAYMENTS_RECEIVED','ADDRESS_VAL','BATCH_CONTROL',
'CUSTOMER','CUSTOMER_DEFAULT','EXPLODED_PRODUCT','EXPLODED_PUBLICATION',
'EXPLOSION','ORDERS_MERCH','INVOICE','INVOICE_MERCH','CLIENT_SAMPLES','INVEN
TORY')
AND OWNER = 'HIST'
order by owner, table_name, column_id;
which gives me
select 'CLIENT_SAMPLES,SAMPLE_DATE5', '
', min(SAMPLE_DATE5),
max(SAMPLE_DATE5) from HIST.CLIENT_SAMPLES where SAMPLE_DATE5 is
not null;
and an output of:
CLIENT_SAMPLES,SAMPLE_DATE5 011/09/2002 09:38
What I want is a comma between everything and perhaps , but building this
dynamically has got my brain all fuddled. Trying to figure out what to build
in the dynamic to get the executed sql to look right... I just can't seem to
get the right combination...
I'd like something like:
CLIENT_SAMPLES,SAMPLE_DATE5, 0,11/09/2002 09:38
or
CLIENT_SAMPLES,SAMPLE_DATE5,0,11/09/2002 09:38
Michael Alan Kline, Sr.
Principal Consultant
Business to Business Solutions, LLC
Phone: 804-744-1545 Cell: 804-314-6262
ICQ: 1009605, 975313
Email: [EMAIL PROTECTED] Web: www.b2bsol.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Jared Still
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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 keep root out?
Walter, Unfortunately, there is no way. You can prevent root from connecting as sysdba by removing the dba group from root userid; but hey, root can "root" it again; he is root, remember, omnipotent. Even if that is successful, he can connect toany dba account, such as "oracle" using "su -" and then connect as sysdba. Worse, they can connect to _any_ dba user, not necessarily "oracle", and your audit logs will show as if coming from that user. Therefore the issue is serious than it sounds like and you should approachat from the manegerial level. Take dba group out if the root userid and establish ground rules that dba group is never allowed to any user without the DBA's request. If they continue to do "su - oracle", make them aware that this operation is imporsonation, and may be deemed illegal. They will listen to that word! HTH. Arup - Original Message - From: Walter K To: Multiple recipients of list ORACLE-L Sent: Thursday, August 28, 2003 11:34 AM Subject: How to keep "root" out? Just for grins, I'll ask this question... Is there any way to keep the Unix "root" user from logging into the database (i.e. connect internal or / as sysdba)? Currently using 8.1.7.4 on Solaris 8 here. We have a couple people in our Unix admin group that feel the need to "help" by writing their own DB monitoring scripts. Of course, they don't know what they're talking about. They do not have formal logins for the database, but since they are root users they are connecting via "connect internal". This is not only counterproductive but actually a potential security issue--just because someone has root doesn't necessarily entitle them to see the data in the database. What if it is a payroll database? So, I'm curious,is there any way to prevent access via "connect internal" or "/ as sysdba"? Thanks in advance. W
RE: sanity check time...
Mercadante, Thomas F scribbled on the wall in glitter crayon: If things are not running, you can do the obvious - run lsnrctl to get the listener running. If you do not see and database services running, you need to determine what services have been created. You can go to the NT Services panel and start them. I hope you don't need to create a new database - I'm assuming that it is alredy installed. oh it's installed. now if it's installed correctly is another matter altogether.;-) what? ask someone who knows Oracle for help? nah, we'll just get him to come in on his own time and fix our mess.;-) -- Bill Shrek Thater ORACLE DBA BAARF Party member #25 [EMAIL PROTECTED] Sometimes one pays most for the things one gets for nothing. - Albert Einstein -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Thater, William INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Congratulations Arup (DBA of the Year)
Oops, looks like the egg is on my face. Mea culpa, didn't read the messages carefully enough, made assumptions. Apologies all around. Now he slinks back to his cube. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, August 28, 2003 10:08 AM To: '[EMAIL PROTECTED]' Oh no! Somebody's jealous. My guess is CTOUG is the Connecticut Oracle Users's Group. You probably weren't in the running, if your email address indicates you aren't a member. John, we're all very appreciative of you as well. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, August 28, 2003 11:00 AM To: Multiple recipients of list ORACLE-L Not being a party pooper but what does DBA of the Year actually mean. What criteria was used. How can Oracle know about a quarter of a million DBA's unless it monitors tars raised. John -Original Message- [mailto:[EMAIL PROTECTED] Sent: 28 August 2003 15:54 To: Multiple recipients of list ORACLE-L Just came to know from CTOUG news that Oracle has chosen Arup Nanda(our List member) as DBA of the Year. Congratulations Arup. thought I will share this news with the group. CTOUG Board Member, Arup Nanda, Chosen as DBA of the Year Oracle has chosen our very own CTOUG board member, Arup Nanda, as the DBA of the Year, out of some quarter million DBAs worldwide. There will be a felicitation ceremony at OracleWorld and the award recipients will be featured in Nov-Dec issue of Oracle Magazine. Thought you would like to know, as a part of the CTOUG community. In his interview, he has mentioned CTOUG, so watch for it. Arup is President of Proligence (http://www.proligence.com/). Thanks. Best Regards, Prasad -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- 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 ORACLE-L FAQ: http://www.orafaq.net -- Author: Hallas, John, Tech Dev INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Grid
10-gig ethernet IS hideously expensive, but its the switching that's expensive. The actual bearer circuit is standard dark fiber. 10-gig ethernet is actually kind of a cheat - it uses 4 2.5 gig wavelengths to create the 10-gig throughput. So each port has to be a DWDM or use 4 different strands of fiber (hence the cost). There's no distance problems running 10gigE. Be that as it may, though, the circuit we're talking about here is almost certainly going to be an OC-192 SONET loop. These have been around for a while - large-scale ISPs use them for core cross-country connectivity. You can bear ATM (though why you'd want to), IP, MPLS, etc. over it. Thanks, Matt -- Matthew Zito GridApp Systems Email: [EMAIL PROTECTED] Cell: 646-220-3551 Phone: 212-358-8211 x 359 http://www.gridapp.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tanel Poder Sent: Thursday, August 28, 2003 3:14 AM To: Multiple recipients of list ORACLE-L Subject: Re: Grid Hi! It's still quite hard to believe, that it could be anywhere near cheap. Even building 10Gbit locatl Ethernet is currently expensive. You would need 16*655Mb ATM connections for that to do over long range... Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, August 28, 2003 6:44 AM no not over the atlantic. its from DC to Boston. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, August 27, 2003 7:39 PM 10GB over Atlantic? This does cost a lot. At least I assume so, why the heck am I sticking to 512kb in my home then? Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, August 28, 2003 1:54 AM i havent seen much about internet 2. i didnt realize there was anything in production yet. do you know where i can find more info on it? 2.3 GBs isnt really that much for a connect anymore. its not that expensive to get 10GB connections or more. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, August 27, 2003 5:44 PM We've been talking of Grid computing here since either late 1999 or early 2000. The computing for our main experiment was designed before the Grid was contemplated. Still we have implemented some of the middleware needed, and build methods of authentication and authorization, and participated in Grid experiments. We have also been pushing the ability to transfer large amounts of data. The latest effort: 2.3 GB per second between the local internet hub and Geneva Switzerland over Internet 2. This is vital to make the Grid work. Yep, you'll probably have huge amounts of data coming in when CERN gets their large hadron collider online in 2007 ;) Btw, AFAIK, they're using Oracle... Tanel. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ryan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services -- --- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself
RE: Congratulations Arup (DBA of the Year)
Well, as a person who has survived with Arup one minor and non-exacting project (moving 1TB OPS database from Siemens--HP, from V7--8i, simultaneously, over a single weekend, with rather simple twists, like finding the right patch for Dev 2000 to continue working, utilizing listener load balancing and properly configuring GC_FILES_TO_LOCKS, migrating all the backup scripts and all the database copying scripts and testing all the applications) and who is reviewing a chapter of his incoming book,I must say that this title is more then deserved. Title of the DBA of the year means that guys like me have recognized Arup as the best among us. -- Mladen Gogala Oracle DBA -Original Message- Hallas, John, Tech Dev Sent: Thursday, August 28, 2003 12:00 PM To: Multiple recipients of list ORACLE-L Not being a party pooper but what does DBA of the Year actually mean. What criteria was used. How can Oracle know about a quarter of a million DBA's unless it monitors tars raised. John -Original Message- [mailto:[EMAIL PROTECTED] Sent: 28 August 2003 15:54 To: Multiple recipients of list ORACLE-L Just came to know from CTOUG news that Oracle has chosen Arup Nanda(our List member) as DBA of the Year. Congratulations Arup. thought I will share this news with the group. CTOUG Board Member, Arup Nanda, Chosen as DBA of the Year Oracle has chosen our very own CTOUG board member, Arup Nanda, as the DBA of the Year, out of some quarter million DBAs worldwide. There will be a felicitation ceremony at OracleWorld and the award recipients will be featured in Nov-Dec issue of Oracle Magazine. Thought you would like to know, as a part of the CTOUG community. In his interview, he has mentioned CTOUG, so watch for it. Arup is President of Proligence (http://www.proligence.com/). Thanks. Best Regards, Prasad -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- 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 ORACLE-L FAQ: http://www.orafaq.net -- Author: Hallas, John, Tech Dev INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Note: 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. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor 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 the views of any such entity. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 keep root out?
Title: Message Put the following code snippet "if [ "$LOGNAME" = "root" ]; then init 0 fi; in your oraenv. I guarantee you that the SA will no longer be connecting as SYSDBA. --Mladen GogalaOracle DBA -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Walter KSent: Thursday, August 28, 2003 11:34 AMTo: Multiple recipients of list ORACLE-LSubject: How to keep "root" out? Just for grins, I'll ask this question... Is there any way to keep the Unix "root" user from logging into the database (i.e. connect internal or / as sysdba)? Currently using 8.1.7.4 on Solaris 8 here. We have a couple people in our Unix admin group that feel the need to "help" by writing their own DB monitoring scripts. Of course, they don't know what they're talking about. They do not have formal logins for the database, but since they are root users they are connecting via "connect internal". This is not only counterproductive but actually a potential security issue--just because someone has root doesn't necessarily entitle them to see the data in the database. What if it is a payroll database? So, I'm curious,is there any way to prevent access via "connect internal" or "/ as sysdba"? Thanks in advance. W Note: 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.Wang Trading LLCand any of its subsidiaries each reserve the right to monitor 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 the views of any such entity.
RE: sanity check time...
Bill, Services should be there. Listener service is created, when Oracle is installed. And database service is created when database is created, using oradim, and has database name as part of the service name: OracleServicedatabase_name. Tell them to check if services are running, check listener, sqlnet, and tnsnames config files, check alert file (service could be running, but database is not open). HTH Igor Neyman, OCP DBA [EMAIL PROTECTED] -Original Message- Thater, William Sent: Thursday, August 28, 2003 11:25 AM To: Multiple recipients of list ORACLE-L Ok, i'm a unix guy i don't usually work with windows. well, the Keane office just called and some of the people over there are having trouble connecting to a windows 9i database. when i asked them if the services were running i got a basic huh? so what do i have to run to set up the services? and no i can't RTFM because i don't got the FM to R for windows nor access to technet since the worm attacks. [don't go there, i'm trying to explain that i kind of need to get to there and metalink to do my job.] -- Bill Shrek Thater ORACLE DBA BAARF Party member #25 [EMAIL PROTECTED] Sooner of later that which is now life shall be poetry, and every fair and manly trait shall add a richer strain to the song. - Ralph Waldo Emerson -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Thater, William INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Igor Neyman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 keep root out?
Title: Message but this assumes that oracle owner has privs to run init ... am not sure any root worth hir salt would let this happen. Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message-From: Mladen Gogala [mailto:[EMAIL PROTECTED]Sent: Thursday, August 28, 2003 1:04 PMTo: Multiple recipients of list ORACLE-LSubject: RE: How to keep "root" out? Put the following code snippet "if [ "$LOGNAME" = "root" ]; then init 0 fi; in your oraenv. I guarantee you that the SA will no longer be connecting as SYSDBA. --Mladen GogalaOracle DBA -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Walter KSent: Thursday, August 28, 2003 11:34 AMTo: Multiple recipients of list ORACLE-LSubject: How to keep "root" out? Just for grins, I'll ask this question... Is there any way to keep the Unix "root" user from logging into the database (i.e. connect internal or / as sysdba)? Currently using 8.1.7.4 on Solaris 8 here. We have a couple people in our Unix admin group that feel the need to "help" by writing their own DB monitoring scripts. Of course, they don't know what they're talking about. They do not have formal logins for the database, but since they are root users they are connecting via "connect internal". This is not only counterproductive but actually a potential security issue--just because someone has root doesn't necessarily entitle them to see the data in the database. What if it is a payroll database? So, I'm curious,is there any way to prevent access via "connect internal" or "/ as sysdba"? Thanks in advance. W Note: 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.Wang Trading LLCand any of its subsidiaries each reserve the right to monitor 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 the views of any such entity. This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.*2
RE: How to keep root out?
LOL ROTFLMAO. That is something to try!! RF -Original Message- To: Multiple recipients of list ORACLE-L Sent: 8/28/2003 12:04 PM Put the following code snippet if [ $LOGNAME = root ]; then init 0 fi; in your oraenv. I guarantee you that the SA will no longer be connecting as SYSDBA. -- Mladen Gogala Oracle DBA -Original Message- Walter K Sent: Thursday, August 28, 2003 11:34 AM To: Multiple recipients of list ORACLE-L Just for grins, I'll ask this question... Is there any way to keep the Unix root user from logging into the database (i.e. connect internal or / as sysdba)? Currently using 8.1.7.4 on Solaris 8 here. We have a couple people in our Unix admin group that feel the need to help by writing their own DB monitoring scripts. Of course, they don't know what they're talking about. They do not have formal logins for the database, but since they are root users they are connecting via connect internal. This is not only counterproductive but actually a potential security issue--just because someone has root doesn't necessarily entitle them to see the data in the database. What if it is a payroll database? So, I'm curious, is there any way to prevent access via connect internal or / as sysdba? Thanks in advance. W Note: 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. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor 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 the views of any such entity. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Freeman Robert - IL INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 keep root out?
Title: Message Cant root user change any file on the system regardless of the file owner? If the SA doesnt know about this line of code or about oraenv, then it will work for a while. I think Saira -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mladen Gogala Sent: August 28, 2003 1:04 PM To: Multiple recipients of list ORACLE-L Subject: RE: How to keep root out? Put the following code snippet if [ $LOGNAME = root ]; then init 0 fi; in your oraenv. I guarantee you that the SA will no longer be connecting as SYSDBA. -- Mladen Gogala Oracle DBA -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Walter K Sent: Thursday, August 28, 2003 11:34 AM To: Multiple recipients of list ORACLE-L Subject: How to keep root out? Just for grins, I'll ask this question... Is there any way to keep the Unix root user from logging into the database (i.e. connect internal or / as sysdba)? Currently using 8.1.7.4 on Solaris 8 here. We have a couple people in our Unix admin group that feel the need to help by writing their own DB monitoring scripts. Of course, they don't know what they're talking about. They do not have formal logins for the database, but since they are root users they are connecting via connect internal. This is not only counterproductive but actually a potential security issue--just because someone has root doesn't necessarily entitle them to see the data in the database. What if it is a payroll database? So, I'm curious,is there any way to prevent access via connect internal or / as sysdba? Thanks in advance. W
Re: How to keep root out?
Hi! Put sqlnet.authentication_services = none in your server's sqlnet.ora. Then everyone has to use a password. Tanel. - Original Message - From: Walter K To: Multiple recipients of list ORACLE-L Sent: Thursday, August 28, 2003 6:34 PM Subject: How to keep "root" out? Just for grins, I'll ask this question... Is there any way to keep the Unix "root" user from logging into the database (i.e. connect internal or / as sysdba)? Currently using 8.1.7.4 on Solaris 8 here. We have a couple people in our Unix admin group that feel the need to "help" by writing their own DB monitoring scripts. Of course, they don't know what they're talking about. They do not have formal logins for the database, but since they are root users they are connecting via "connect internal". This is not only counterproductive but actually a potential security issue--just because someone has root doesn't necessarily entitle them to see the data in the database. What if it is a payroll database? So, I'm curious,is there any way to prevent access via "connect internal" or "/ as sysdba"? Thanks in advance. W
RE: OT: Hey Jared!! -90 degree OT Joke
Ivaguely remember hearing :
* right handed people use left side of brain
*that left handed people use right side of brain
Correct???
I think right or left just use it. I mean use something.
"Orr, Steve" [EMAIL PROTECTED] wrote:
Hmmm... So you're saying that women aren't in their right mind? Takingit to the off topic list.-Original Message-Sent: Thursday, August 28, 2003 2:59 AMTo: Multiple recipients of list ORACLE-LHi,This is my own theory, you can't find this information from OracleDocument.Well... talking about women and men.I believe most women use their left brain more than right brain and mostmen use their right brain more than left brain.Function of left brain - remember things, - small thing but detail (this is the reason why women take 1/2a day to buy a pair of shoe, and not that easy fall in love)- person names- history - words (perhaps this is the reason why women like to readnovels)Function of right brain- response to things (quick decision maker) - this is the reasonwh!
y so many
2 minute men in the world- everything in general (see thing in big picture)- person faces- math, 1 + 3 / 7 ^ 53 = X- picturesWell Friends train both side of your brain, and for male DBA use yourleft brain when talk to women, then she is yours.RF tell me if I am wrongPS: Just kidding., going to see Mars tonight I miss my home town. :)Sinardy-Original Message-Sent: 28 August 2003 06:25To: Multiple recipients of list ORACLE-LWomen are also particularily good at remembering small nasty things frompast which you've already forgotten long time ago. Especially duringfights...:)Tanel.- Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>Sent: Thursday, August 28, 2003 12:59 AM Not being sexist in any way, but it's my experience that Women are much better "generalists" !
than men,
but that men are much better specialists. Thats why I think women do better in school early on, but once we men get into the University level and pick our speciality, we kick butt. My soon to be ex-wife was frequently much better remembering overallthings than I was RF -Original Message- To: Multiple recipients of list ORACLE-L Sent: 8/27/2003 6:44 AM c'mon... any virus named "SoBig" has to have been written by a man :) (yes, sexist, I know) --- Tanel Poder <[EMAIL PROTECTED]>wrote: I've seen only one female in my life who would be capable of writing such virus. But that is not the issue (no offence, really). Women just don't waste their time on stuff like this. Tanel. - Original Message
- To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Wednesday, August 27, 2003 4:54 AM "Guy"? You've eliminated 50% of all possible suspects... on 8/26/03 1:44 PM, Tanel Poder at [EMAIL PROTECTED] wrote: I doubt they will ever find the real guy behind this. Tanel. - Original Message -To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>Sent: Tuesday, August 26, 2003 10:19 PM For all you virus/worm lovers out there, justice do come: FBI Subpoenas Arizona ISP !
In Sobig
ProbeEasynews says it's cooperating with the bureau to find the personwho uploaded the virus to a Usenet group it hosts. informationweek.com/story/showArticle.jhtml?articleID=13800091 Dick GouletSenior Oracle DBAOracle Certified 8i DBA--Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: Goulet, DickINET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services !
t;
-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 (orthe name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).-- Please see the official ORACLE-L FAQ: http://www.orafaq.net --Author: Tim Gorman INET: [EMAIL PROTECTED] Fat City Network Services --
858-538-5051http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') andin the 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051
http://www.fatcity.com San Diego,
Inactive Sessions/Java
Hi All, I have a problem with inactive sessions (despite having set the sqlnet.expire parameter) Some of the users connect to the database via a java process - when I stop this process from running the number of sessions just shots right down. Short of scheduling a start and restart of this process can anybody else come up with a solution?? I am reluctant to touch the java process as this is part of the production box. (plus my knowledge of java is hovering over zero percent) Any ideas appreciated, thanks, N. winmail.dat
Re: How to keep root out?
Title: Message Hm, why not rm -rf / following by reboot instead? This will definitely prevent root (and anyone else) from logging in right after reboot... Tanel. - Original Message - From: Saira Somani-Mendelin To: Multiple recipients of list ORACLE-L Sent: Thursday, August 28, 2003 8:19 PM Subject: RE: How to keep "root" out? Cant root user change any file on the system regardless of the file owner? If the SA doesnt know about this line of code or about oraenv, then it will work for a while. I think Saira -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mladen GogalaSent: August 28, 2003 1:04 PMTo: Multiple recipients of list ORACLE-LSubject: RE: How to keep "root" out? Put the following code snippet "if [ "$LOGNAME" = "root" ]; then init 0 fi; in your oraenv. I guarantee you that the SA will no longer be connecting as SYSDBA. --Mladen GogalaOracle DBA -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Walter KSent: Thursday, August 28, 2003 11:34 AMTo: Multiple recipients of list ORACLE-LSubject: How to keep "root" out? Just for grins, I'll ask this question... Is there any way to keep the Unix "root" user from logging into the database (i.e. connect internal or / as sysdba)? Currently using 8.1.7.4 on Solaris 8 here. We have a couple people in our Unix admin group that feel the need to "help" by writing their own DB monitoring scripts. Of course, they don't know what they're talking about. They do not have formal logins for the database, but since they are root users they are connecting via "connect internal". This is not only counterproductive but actually a potential security issue--just because someone has root doesn't necessarily entitle them to see the data in the database. What if it is a payroll database? So, I'm curious,is there any way to prevent access via "connect internal" or "/ as sysdba"? Thanks in advance. W
RE: How to keep root out?
Wouldn't work if oraenv is run after an su to oracle. ;) Quoting Freeman Robert - IL [EMAIL PROTECTED]: Read the code again. It checks that the person running .oraenv is root, and if so, it does the init. RF -Original Message- To: Multiple recipients of list ORACLE-L Sent: 8/28/2003 12:14 PM but this assumes that oracle owner has privs to run init ... am not sure any root worth hir salt would let this happen. Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message- Sent: Thursday, August 28, 2003 1:04 PM To: Multiple recipients of list ORACLE-L Put the following code snippet if [ $LOGNAME = root ]; then init 0 fi; in your oraenv. I guarantee you that the SA will no longer be connecting as SYSDBA. -- Mladen Gogala Oracle DBA -Original Message- Walter K Sent: Thursday, August 28, 2003 11:34 AM To: Multiple recipients of list ORACLE-L Just for grins, I'll ask this question... Is there any way to keep the Unix root user from logging into the database (i.e. connect internal or / as sysdba)? Currently using 8.1.7.4 on Solaris 8 here. We have a couple people in our Unix admin group that feel the need to help by writing their own DB monitoring scripts. Of course, they don't know what they're talking about. They do not have formal logins for the database, but since they are root users they are connecting via connect internal. This is not only counterproductive but actually a potential security issue--just because someone has root doesn't necessarily entitle them to see the data in the database. What if it is a payroll database? So, I'm curious, is there any way to prevent access via connect internal or / as sysdba? Thanks in advance. W Note: 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. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor 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 the views of any such entity. ESPN_Disclaimer.txt -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Freeman Robert - IL INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 mail sent through IMP: http://horde.org/imp/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Denny Koovakattu INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 keep root out?
Just a thought. Grant the SYSDBA and SYSOPER privileges to some user you have the password to. Then change the dba group in the file $ORACLE_HOME/rdbms/lib/config.c (config.s in the case of Solaris) to some other group (maybe invalid group) and relink oracle. You could use the password protected user with SYSOPER and SYSDBA privilege to startup and shutdown the database. connect internal or any form of OS authentication should fail. I haven't tested this or used this. So try at your own risk. And I don't think Oracle support would like this. ;) Regards, Denny -- Denny Koovakattu Quoting Mark Leith [EMAIL PROTECTED]: Should keep the Unix weenies from bugging your database for at least a short time, if all else fails! ;) -Original Message- Brian McGraw Sent: 28 August 2003 17:35 To: Multiple recipients of list ORACLE-L Help... my database isn't coming up anymore!! ;) Brian -Original Message- Mark Leith Sent: Thursday, August 28, 2003 11:24 AM To: Multiple recipients of list ORACLE-L rm -r * at root. : -Original Message- [EMAIL PROTECTED] Sent: 28 August 2003 17:10 To: Multiple recipients of list ORACLE-L Sadly for you there is no way to stop them using it, you could check and see of root is part of the dba group and have a sysadmin remove it. and if you succeed then they need only to su - oracle and they can still do it, this may then if configured show up in a su log. I think you need to firstly discuss it with them and then if the response is unsuitable you need to document the facts and present it to your manager for him to determine what is acceptable. Tough one to call Cheers -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238 Facsimile: +61 (0)7 3303 3048 = If people did not sometimes do silly things, nothing intelligent would ever get done. - Ludwig Wittgenstein = Mincom The People, The Experience, The Vision = This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please delete it and notify the sender. The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Group of companies unless expressly stated otherwise. Walter K [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 29/08/2003 01:34 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:How to keep root out? Just for grins, I'll ask this question... Is there any way to keep the Unix root user from logging into the database (i.e. connect internal or / as sysdba)? Currently using 8.1.7.4 on Solaris 8 here. We have a couple people in our Unix admin group that feel the need to help by writing their own DB monitoring scripts. Of course, they don't know what they're talking about. They do not have formal logins for the database, but since they are root users they are connecting via connect internal. This is not only counterproductive but actually a potential security issue--just because someone has root doesn't necessarily entitle them to see the data in the database. What if it is a payroll database? So, I'm curious, is there any way to prevent access via connect internal or / as sysdba? Thanks in advance. W -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- 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). --- Incoming
RE: Grid
2.3 GB from California to Switzerland is fast, damned fast. http://www.cenic.org/CENIC2003/NGIAwards/winners/slac.htm We are part of several test beds having to do with future networking capabilities. Ian MacGregor -Original Message- Sent: Wednesday, August 27, 2003 3:54 PM To: Multiple recipients of list ORACLE-L i havent seen much about internet 2. i didnt realize there was anything in production yet. do you know where i can find more info on it? 2.3 GBs isnt really that much for a connect anymore. its not that expensive to get 10GB connections or more. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, August 27, 2003 5:44 PM We've been talking of Grid computing here since either late 1999 or early 2000. The computing for our main experiment was designed before the Grid was contemplated. Still we have implemented some of the middleware needed, and build methods of authentication and authorization, and participated in Grid experiments. We have also been pushing the ability to transfer large amounts of data. The latest effort: 2.3 GB per second between the local internet hub and Geneva Switzerland over Internet 2. This is vital to make the Grid work. Yep, you'll probably have huge amounts of data coming in when CERN gets their large hadron collider online in 2007 ;) Btw, AFAIK, they're using Oracle... Tanel. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ryan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: MacGregor, Ian A. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 keep root out?
Read the code again. It checks that the person running .oraenv is root, and if so, it does the init. RF -Original Message- To: Multiple recipients of list ORACLE-L Sent: 8/28/2003 12:14 PM but this assumes that oracle owner has privs to run init ... am not sure any root worth hir salt would let this happen. Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message- Sent: Thursday, August 28, 2003 1:04 PM To: Multiple recipients of list ORACLE-L Put the following code snippet if [ $LOGNAME = root ]; then init 0 fi; in your oraenv. I guarantee you that the SA will no longer be connecting as SYSDBA. -- Mladen Gogala Oracle DBA -Original Message- Walter K Sent: Thursday, August 28, 2003 11:34 AM To: Multiple recipients of list ORACLE-L Just for grins, I'll ask this question... Is there any way to keep the Unix root user from logging into the database (i.e. connect internal or / as sysdba)? Currently using 8.1.7.4 on Solaris 8 here. We have a couple people in our Unix admin group that feel the need to help by writing their own DB monitoring scripts. Of course, they don't know what they're talking about. They do not have formal logins for the database, but since they are root users they are connecting via connect internal. This is not only counterproductive but actually a potential security issue--just because someone has root doesn't necessarily entitle them to see the data in the database. What if it is a payroll database? So, I'm curious, is there any way to prevent access via connect internal or / as sysdba? Thanks in advance. W Note: 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. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor 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 the views of any such entity. ESPN_Disclaimer.txt -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Freeman Robert - IL INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 keep root out?
Now, I use to know a Unix admin who did exactly that thinking he was in a private subdirectory. He spent the following 36 hours rebuilding the server restoring the database, after that he tried to explain what happen for another 3 hours to the powers that be, and the remainder of the day cleaning out his desk. Moral: Do not login as root unless you absolutely have to. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Thursday, August 28, 2003 12:24 PM To: Multiple recipients of list ORACLE-L rm -r * at root. : -Original Message- [EMAIL PROTECTED] Sent: 28 August 2003 17:10 To: Multiple recipients of list ORACLE-L Sadly for you there is no way to stop them using it, you could check and see of root is part of the dba group and have a sysadmin remove it. and if you succeed then they need only to su - oracle and they can still do it, this may then if configured show up in a su log. I think you need to firstly discuss it with them and then if the response is unsuitable you need to document the facts and present it to your manager for him to determine what is acceptable. Tough one to call Cheers -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238 Facsimile: +61 (0)7 3303 3048 = If people did not sometimes do silly things, nothing intelligent would ever get done. - Ludwig Wittgenstein = Mincom The People, The Experience, The Vision = This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please delete it and notify the sender. The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Group of companies unless expressly stated otherwise. Walter K [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 29/08/2003 01:34 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:How to keep root out? Just for grins, I'll ask this question... Is there any way to keep the Unix root user from logging into the database (i.e. connect internal or / as sysdba)? Currently using 8.1.7.4 on Solaris 8 here. We have a couple people in our Unix admin group that feel the need to help by writing their own DB monitoring scripts. Of course, they don't know what they're talking about. They do not have formal logins for the database, but since they are root users they are connecting via connect internal. This is not only counterproductive but actually a potential security issue--just because someone has root doesn't necessarily entitle them to see the data in the database. What if it is a payroll database? So, I'm curious, is there any way to prevent access via connect internal or / as sysdba? Thanks in advance. W -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- 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). --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.512 / Virus Database: 309 - Release Date: 19/08/2003 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.512 / Virus Database: 309 - Release Date: 19/08/2003 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Goulet, Dick INET: [EMAIL PROTECTED] Fat City Network Services
RE: How to keep root out?
Having been there, I'll agree with Jonathan Gennick on this issue. First off try to talk to the folks let them know that their meddling where they should not be. That worked with one sys admin I have. Failing that, which I have, follow Jonathan's advice give them a "safe" login that they can then use. In my case the sys admin found that he really did not know what he was doing stopped snooping. In another sys admin's case he did make changes, only to have the DB cease functioning at which time management was more then willing to "take care of it". I love having someone else be the "bad guy". Dick GouletSenior Oracle DBAOracle Certified 8i DBA -Original Message-From: Arup Nanda [mailto:[EMAIL PROTECTED]Sent: Thursday, August 28, 2003 12:50 PMTo: Multiple recipients of list ORACLE-LSubject: Re: How to keep "root" out? Walter, Unfortunately, there is no way. You can prevent root from connecting as sysdba by removing the dba group from root userid; but hey, root can "root" it again; he is root, remember, omnipotent. Even if that is successful, he can connect toany dba account, such as "oracle" using "su -" and then connect as sysdba. Worse, they can connect to _any_ dba user, not necessarily "oracle", and your audit logs will show as if coming from that user. Therefore the issue is serious than it sounds like and you should approachat from the manegerial level. Take dba group out if the root userid and establish ground rules that dba group is never allowed to any user without the DBA's request. If they continue to do "su - oracle", make them aware that this operation is imporsonation, and may be deemed illegal. They will listen to that word! HTH. Arup - Original Message - From: Walter K To: Multiple recipients of list ORACLE-L Sent: Thursday, August 28, 2003 11:34 AM Subject: How to keep "root" out? Just for grins, I'll ask this question... Is there any way to keep the Unix "root" user from logging into the database (i.e. connect internal or / as sysdba)? Currently using 8.1.7.4 on Solaris 8 here. We have a couple people in our Unix admin group that feel the need to "help" by writing their own DB monitoring scripts. Of course, they don't know what they're talking about. They do not have formal logins for the database, but since they are root users they are connecting via "connect internal". This is not only counterproductive but actually a potential security issue--just because someone has root doesn't necessarily entitle them to see the data in the database. What if it is a payroll database? So, I'm curious,is there any way to prevent access via "connect internal" or "/ as sysdba"? Thanks in advance. W
RE: How to keep root out?
Almost, Mladen...you forgot to: echo rm -rf //etc/rc0.d/K00aaa_startup chmod 770 /etc/rc0.d/K00aaa_startup before the init. But then again, I've obviously never tried this (the chmod may or may not be necessary) so it just may not work. Shouldn't SAs know that root is a dangerous thing??? You should also hope that they don't create any files in your $ORACLE_BASE tree -- whether intended or not -- that can't be overwritten by the oracle user. No root in Oracle DBs. It's even in the docs. Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA -Original Message- Sent: Thursday, August 28, 2003 12:04 PM To: Multiple recipients of list ORACLE-L Put the following code snippet if [ $LOGNAME = root ]; then init 0 fi; in your oraenv. I guarantee you that the SA will no longer be connecting as SYSDBA. -- Mladen Gogala -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: How to keep root out?
Moral: Do not login as root unless you absolutely have to. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA I also function as our sysadm, and I barely remember the root password to our solaris boxes. I used to log in as root, but heard enough horror stories to figure out a way around it. Thank goodness I found the sudo utility. You still have to be careful, but you can't execute a command without KNOWING you are acting as root. Also in regards to rm -r *. I once typed rm * while in the root directory. This was like two months into my first sysadm duties, I had just gotten over being extra paranioid. I certainly wasn't aware my current directory was /, but it was. Luckilly the previous ,always crafty, sysadm had the foresight to place a file named -i in the directory. Really saved my bacon when I was prompted for confirmation. Steve McClure -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Steve McClure INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Hey Jared!!
Hey, I got a couple emails saying I'm sending the worm to people I never heard of. Does that make me as famous as Jared?? I guess not. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, August 27, 2003 8:50 AM To: Multiple recipients of list ORACLE-L Steve, Well if you REALLY want to know how I feel about these types of idiots, I'd much prefer them to be publicly hanged, drawn quartered. Webcasting it would be very appriopriate too. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Tuesday, August 26, 2003 6:44 PM To: Multiple recipients of list ORACLE-L You're MUCH too merciful! We should start by infecting him or her with worms and viruses of the biologic type. :-) -Original Message- Sent: Tuesday, August 26, 2003 4:09 PM To: Multiple recipients of list ORACLE-L I sure hope so. Then he/she should be publicly tarred Feathered. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Tuesday, August 26, 2003 4:45 PM To: Multiple recipients of list ORACLE-L I doubt they will ever find the real guy behind this. Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, August 26, 2003 10:19 PM For all you virus/worm lovers out there, justice do come: FBI Subpoenas Arizona ISP In Sobig Probe Easynews says it's cooperating with the bureau to find the person who uploaded the virus to a Usenet group it hosts. informationweek.com/story/showArticle.jhtml?articleID=13800091 Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Goulet, Dick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Goulet, Dick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Orr, Steve INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Goulet, Dick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L
Re: Inactive Sessions/Java
What is Java process? Is it a java class running in some kind of application server? If yes, then your application server is keeping your connections open and using connection pooling to share them between your processes, somewhat reducing the overhead to create drop a connection for every interaction with database. This is generally a good thing. Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, August 28, 2003 8:29 PM Hi All, I have a problem with inactive sessions (despite having set the sqlnet.expire parameter) Some of the users connect to the database via a java process - when I stop this process from running the number of sessions just shots right down. Short of scheduling a start and restart of this process can anybody else come up with a solution?? I am reluctant to touch the java process as this is part of the production box. (plus my knowledge of java is hovering over zero percent) Any ideas appreciated, thanks, N. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 keep root out?
Title: Message Better yet, put the following lines echo ORA-600 [kgfdjjks] [scdcsc] [dssdcdcsdc] [45] [999] Unauthorized root access then print some garbage into a file named like the regular trace files in user_dump_dest directory. Open up a iTARand show this "trace" file to your SA's manager, along with the TAR number. Let the fun begin. - Original Message - From: Mladen Gogala To: Multiple recipients of list ORACLE-L Sent: Thursday, August 28, 2003 1:04 PM Subject: RE: How to keep "root" out? Put the following code snippet "if [ "$LOGNAME" = "root" ]; then init 0 fi; in your oraenv. I guarantee you that the SA will no longer be connecting as SYSDBA. --Mladen GogalaOracle DBA -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Walter KSent: Thursday, August 28, 2003 11:34 AMTo: Multiple recipients of list ORACLE-LSubject: How to keep "root" out? Just for grins, I'll ask this question... Is there any way to keep the Unix "root" user from logging into the database (i.e. connect internal or / as sysdba)? Currently using 8.1.7.4 on Solaris 8 here. We have a couple people in our Unix admin group that feel the need to "help" by writing their own DB monitoring scripts. Of course, they don't know what they're talking about. They do not have formal logins for the database, but since they are root users they are connecting via "connect internal". This is not only counterproductive but actually a potential security issue--just because someone has root doesn't necessarily entitle them to see the data in the database. What if it is a payroll database? So, I'm curious,is there any way to prevent access via "connect internal" or "/ as sysdba"? Thanks in advance. W Note: 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.Wang Trading LLCand any of its subsidiaries each reserve the right to monitor 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 the views of any such entity.
How to find the session holding the library cache pin.
Gurus: One of the developers has changed his java code and wants to load the class into the db. He did this on production db while users are accessing the application...and then complained that his session is just sitting in idle state I queried the v$session_wait and found that his session is waiting for the library cache pinquestion is how to tell which session is holding the enqueue? Thanks in advance for your help. Murali. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: Murali_Pavuloori/[EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 find the session holding the library cache pin.
dba_blockers this doesnt install by default. i cant remember which script runs it. check metalink. warning... its a VERY slow view. From: Murali_Pavuloori/[EMAIL PROTECTED] Date: 2003/08/28 Thu PM 04:14:26 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: How to find the session holding the library cache pin. Gurus: One of the developers has changed his java code and wants to load the class into the db. He did this on production db while users are accessing the application...and then complained that his session is just sitting in idle state I queried the v$session_wait and found that his session is waiting for the library cache pinquestion is how to tell which session is holding the enqueue? Thanks in advance for your help. Murali. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: Murali_Pavuloori/[EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: OT: Hey Jared!! -90 degree OT Joke
That's true--each hemisphere of the brain handles I/O for the opposite side of the body. If I remember my neuropsych classes correctly, even the optic nerves from each eye cross over... Roy Pardee Programmer/Analyst/DBA SWFPAC Lockheed Martin IT Extension 8487 -Original Message- Sent: Thursday, August 28, 2003 10:30 AM To: Multiple recipients of list ORACLE-L I vaguely remember hearing : * right handed people use left side of brain * that left handed people use right side of brain Correct??? I think right or left just use it. I mean use something. Orr, Steve [EMAIL PROTECTED] wrote: Hmmm... So you're saying that women aren't in their right mind? Taking it to the off topic list. -Original Message- Sent: Thursday, August 28, 2003 2:59 AM To: Multiple recipients of list ORACLE-L Hi, This is my own theory, you can't find this information from Oracle Document. Well... talking about women and men. I believe most women use their left brain more than right brain and most men use their right brain more than left brain. Function of left brain - remember things, - small thing but detail (this is the reason why women take 1/2 a day to buy a pair of shoe, and not that easy fall in love) - person names - history - words (perhaps this is the reason why women like to read novels) Function of right brain - response to things (quick decision maker) - this is the reason wh! y so many 2 minute men in the world - everything in general (see thing in big picture) - person faces - math, 1 + 3 / 7 ^ 53 = X - pictures Well Friends train both side of your brain, and for male DBA use your left brain when talk to women, then she is yours. RF tell me if I am wrong PS: Just kidding., going to see Mars tonight I miss my home town. :) Sinardy -Original Message- Sent: 28 August 2003 06:25 To: Multiple recipients of list ORACLE-L Women are also particularily good at remembering small nasty things from past which you've already forgotten long time ago. Especially during fights... :) Tanel. - Original Message - To: Multiple recipients of list ORACLE-L Sent: Thursday, August 28, 2003 12:59 AM Not being sexist in any way, but it's my experience that Women are much better generalists ! than men, but that men are much better specialists. Thats why I think women do better in school early on, but once we men get into the University level and pick our speciality, we kick butt. My soon to be ex-wife was frequently much better remembering overall things than I was RF -Original Message- To: Multiple recipients of list ORACLE-L Sent: 8/27/2003 6:44 AM c'mon... any virus named SoBig has to have been written by a man :) (yes, sexist, I know) --- Tanel Poder wrote: I've seen only one female in my life who would be capable of writing such virus. But that is not the issue (no offence, really). Women just don't waste their time on stuff like this. Tanel. - Original Message - To: Multiple recipients of list ORACLE-L Sent: Wednesday, August 27, 2003 4:54 AM Guy? You've eliminated 50% of all possible suspects... on 8/26/03 1:44 PM, Tanel Poder at [EMAIL PROTECTED] wrote: I doubt they will ever find the real guy behind this. Tanel. - Original Message - To: Multiple recipients of list ORACLE-L Sent: Tuesday, August 26, 2003 10:19 PM For all you virus/worm lovers out there, justice do come: FBI Subpoenas Arizona ISP ! In Sobig Probe Easynews says it's cooperating with the bureau to find the person who uploaded the virus to a Usenet group it hosts. informationweek.com/story/showArticle.jhtml?articleID=13800091 Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Goulet, Dick INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services g! t; - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: 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
RE: How to find the session holding the library cache pin.
Murali, Running this should help in identifying the object being locked and the SID holding that pin. John Kanagaraj DB Soft Inc Phone: 408-970-7002 (W) Grace - Getting something we do NOT deserve Mercy - NOT getting something we DO deserve Click on 'http://www.needhim.org' for Grace and Mercy that is freely available! ** The opinions and facts contained in this message are entirely mine and do not reflect those of my employer or customers ** column waiter format a15 column holder format a15 column held_object format a47 column lock_or_pin format a15 column address format a15 column mode_requested format a15 set feedback off set echo off select /*+ ORDERED */ w1.sid || '/' || w1.username waiter, h1.sid || '/' || h1.username holder, o.to_owner || '.' || o.to_name held_object, w.kgllktype lock_or_pin, w.kgllkhdl address, decode(h.kgllkmod, 0, 'None', 1, 'Null', 2, 'Share', 3, 'Exclusive', 'Unknown') mode_held, decode(w.kgllkreq, 0, 'None', 1, 'Null', 2, 'Share', 3, 'Exclusive', 'Unknown') mode_requested from dba_kgllock w, dba_kgllock h, v$session w1, v$session h1, v$object_dependen cy o where (((h.kgllkmod != 0) and (h.kgllkmod != 1) and ((h.kgllkreq = 0) or (h.kgllkreq = 1))) and (((w.kgllkmod = 0) or (w.kgllkmod= 1)) and ((w.kgllkreq != 0) and (w.kgllkreq != 1 and w.kgllktype= h.kgllktype and w.kgllkhdl = h.kgllkhdl and w.kgllkuse = w1.saddr and h.kgllkuse = h1.saddr and w.kgllkhdl = o.to_address ; -Original Message- [mailto:Murali_Pavuloori/[EMAIL PROTECTED] Sent: Thursday, August 28, 2003 1:14 PM To: Multiple recipients of list ORACLE-L Gurus: One of the developers has changed his java code and wants to load the class into the db. He did this on production db while users are accessing the application...and then complained that his session is just sitting in idle state I queried the v$session_wait and found that his session is waiting for the library cache pinquestion is how to tell which session is holding the enqueue? Thanks in advance for your help. Murali. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: Murali_Pavuloori/[EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: John Kanagaraj INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 find the session holding the library cache pin.
$ORACLE_HOME/rdbms/admin/catblock.sql -- Mladen Gogala Oracle DBA -Original Message- [EMAIL PROTECTED] Sent: Thursday, August 28, 2003 4:24 PM To: Multiple recipients of list ORACLE-L dba_blockers this doesnt install by default. i cant remember which script runs it. check metalink. warning... its a VERY slow view. From: Murali_Pavuloori/[EMAIL PROTECTED] Date: 2003/08/28 Thu PM 04:14:26 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: How to find the session holding the library cache pin. Gurus: One of the developers has changed his java code and wants to load the class into the db. He did this on production db while users are accessing the application...and then complained that his session is just sitting in idle state I queried the v$session_wait and found that his session is waiting for the library cache pinquestion is how to tell which session is holding the enqueue? Thanks in advance for your help. Murali. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: Murali_Pavuloori/[EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Note: 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. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor 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 the views of any such entity. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
