Re: Tracing a sql statement also to include bind variables
Dear List, I couldn't find this dbms_support.start_trace_in_session(sid,serial#,TRUE,TRUE) Platform WinNT Oracle 8.1.7 Pl let me know venkat -- On Mon, 24 Sep 2001 03:05:19 Christian Trassens wrote: Execute as sys or dba user the package dbms_system.set_ev(sid,serial#,10046,12,''); Or with oradebug: oradebug setospid OSPID of the session and then oradebug event 10046 trace name context forever level 12 Or from the user: alter session set events '10046 trace name context forever, level 12'; Or with the package dbms_support: dbms_support.start_trace_in_session(sid,serial#,TRUE,TRUE) Regards. --- [EMAIL PROTECTED] wrote: Hi All, I have to trace a sql that a user generates. I also need the bind variables. Can somebody please enlighten me??? TIA Jack = De informatie verzonden in dit e-mailbericht is vertrouwelijk en is uitsluitend bestemd voor de geadresseerde. Openbaarmaking, vermenigvuldiging, verspreiding en/of verstrekking van deze informatie aan derden is, behoudens voorafgaande schriftelijke toestemming van Ernst Young, niet toegestaan. Ernst Young staat niet in voor de juiste en volledige overbrenging van de inhoud van een verzonden e-mailbericht, noch voor tijdige ontvangst daarvan. Ernst Young kan niet garanderen dat een verzonden e-mailbericht vrij is van virussen, noch dat e-mailberichten worden overgebracht zonder inbreuk of tussenkomst van onbevoegde derden. Indien bovenstaand e-mailbericht niet aan u is gericht, verzoeken wij u vriendelijk doch dringend het e-mailbericht te retourneren aan de verzender en het origineel en eventuele kopieën te verwijderen en te vernietigen. Ernst Young hanteert bij de uitoefening van haar werkzaamheden algemene voorwaarden, waarin een beperking van aansprakelijkheid is opgenomen. De algemene voorwaarden worden u op verzoek kosteloos toegezonden. = The information contained in this communication is confidential and is intended solely for the use of the individual or entity to whom it is addressed. You should not copy, disclose or distribute this communication without the authority of Ernst Young. Ernst Young is neither liable for the proper and complete transmission of the information contained in this communication nor for any delay in its receipt. Ernst Young does not guarantee that the integrity of this communication has been maintained nor that the communication is free of viruses, interceptions or interference. If you are not the intended recipient of this communication please return the communication to the sender and delete and destroy all copies. In carrying out its engagements, Ernst Young applies general terms and conditions, which contain a clause that limits its liability. A copy of these terms and conditions is available on request free of charge. = -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Eng. Christian Trassens Senior DBA Systems Engineer [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : 541149816062 __ Do You Yahoo!? Get email alerts NEW webcam video instant messaging with Yahoo! Messenger. http://im.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christian Trassens INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Make a difference, help support the relief efforts in the U.S. http://clubs.lycos.com/live/events/september11.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: C.S.Venkata Subramanian INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San
Re: select * from dual;
Oracle has implemented an X$DUAL 'table' in recent versions of Oracle, which is the target for 'DUAL' when the database is not open. Like (all) X$ table, this mapping into the SGA contains an address, index, and instance id as well as the data column(s). It's just unfortunate that Orale hasn't yet replaced all calls to dual with a redirect to x$dual when the database is open. Jonathan Lewis http://www.jlcomp.demon.co.uk Host to The Co-Operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html Author of: Practical Oracle 8i: Building Efficient Databases Screen saver or Life saver: http://www.ud.com Use spare CPU to assist in cancer research. -Original Message- To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: 25 September 2001 19:23 Gurus, I get the following on select * from dual; when the database is in the unmounted and the mounted state... ADDR INDXINST_ID D -- -- - 01653D38 01X and the normal D - X when it is open. What does the other columns stand for .. I am sure a lot of you know.. thanks in advance.. Anjan -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Anjan Thakuria INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jonathan Lewis INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
A range function ??
Hi, I would like to exclude an arrange of characters. there is for instance: not in ('A','B','C','D','E'...); Is there not perhaps something easier? ie: not in ( A-Z, a-z) ; Does anyone know of a function or some other more economical way of doing this? Many Regards Denham -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Denham Eva INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Number of locked rows or how many locks when update a bitmap inde
Hi, Is it possible to find out the actual number of locked rows? For example: SQL desc test Name Null?Type - F NUMBER(38) SQL select * from test; F -- 1 1 1 2 3 5 rows selected. SQL update test set f=f where f=2 or f=3; 2 rows updated. SQL Is there a view I can query to find out that 2 rows are locked? v$locked_object will let me see that there is 1 table locked and find out which table it is. v$lock will show 1 * TM lock and 1 * TX lock. Putting this another way, if I use bitmap indexes and update a field in the index, I may lock more than 1 row (Oracle will use bitmap-segment-level locking). How can I find out how many rows are locked in this case. For a specific case I guess I should find out how many rows are in a single bitmap-segment but I haven't yet investigated how to do this. Thanks, Bruce Reardon -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Reardon, Bruce (CALBBAY) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: A range function ??
try using not between 'a' and 'z' and not between 'A' and 'Z' ; -Original Message- Sent: Wednesday, September 26, 2001 8:45 AM To: Multiple recipients of list ORACLE-L Hi, I would like to exclude an arrange of characters. there is for instance: not in ('A','B','C','D','E'...); Is there not perhaps something easier? ie: not in ( A-Z, a-z) ; Does anyone know of a function or some other more economical way of doing this? Many Regards Denham -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Denham Eva INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Szecsy Tamas INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: A range function ??
Try this ASCII(your_char) NOT BETWEEN ASCII('A') AND ASCII('Z') ASCII('A')-ASCII('Z') is an interval and ASCII('a')-ASCII('z') is another so be careful _ Iulian Ilies mailto: [EMAIL PROTECTED] mailto: [EMAIL PROTECTED] -Original Message- Sent: Wednesday, September 26, 2001 9:45 AM To: Multiple recipients of list ORACLE-L ** This email has been tested for viruses by F-Secure Antivirus administered by IT Network Department. ** Hi, I would like to exclude an arrange of characters. there is for instance: not in ('A','B','C','D','E'...); Is there not perhaps something easier? ie: not in ( A-Z, a-z) ; Does anyone know of a function or some other more economical way of doing this? Many Regards Denham -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Denham Eva INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). ** The information contained in this communication is confidential and may be legally privileged. It is intended solely for the use of the individual or entity to whom it is addressed and others authorised to receive it. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking action in reliance of the contents of this information is strictly prohibited and may be unlawful. Mobil Rom is neither liable for the proper, complete transmission of the information contained in this communication nor any delay in its receipt. ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: A range function ??
Thanks Folks, So far all the examples have worked wonderfully. Thank You all Denham Eva -Original Message- Sent: Wednesday, September 26, 2001 8:45 AM To: Multiple recipients of list ORACLE-L Hi, I would like to exclude an arrange of characters. there is for instance: not in ('A','B','C','D','E'...); Is there not perhaps something easier? ie: not in ( A-Z, a-z) ; Does anyone know of a function or some other more economical way of doing this? Many Regards Denham -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Denham Eva INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Denham Eva INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
external authentication issue
Hi everyone We introduced external authentication on windows 2000. I had the following init.ora parameter set REMOTE_LOGIN_PASSWORDFILE = EXCLUSIVE OS_AUTHENT_PREFIX= and i forgot to set REMOTE_OS_AUTHENT = true. connect with a / didn't work (of course). I searched on Metalink and found 2 possible causes the REMOTE_OS_AUTHENT = true parameter was not set in init.ora and the SQLNET.AUTHENTICATION_SERVICES = (NTS) was not set in sqlnet.ora (server and cliënt) I set both parameters and stopped/started the database, but connect / did still not work (invalid username/password was the message). When i change SQLNET.AUTHENTICATION_SERVICES in (NONE) (the default value) it WORKED!! Can anyone explain to me why SQLNET.AUTHENTICATION_SERVICES = (NTS) doesn't work as described by Metalink. Thanks in Advance vr. gr. g.g. kor rdw ict groningen -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: ORACLE VS. SYBASE
Ooops, I meant to say that a the article I was responding to was factually incorrect, not my own post :0) g -Original Message- Sent: Tuesday, September 25, 2001 12:30 PM To: Multiple recipients of list ORACLE-L Hmm, quite a bit of this is factually incorrect, and may be based on a comparison between the latest Sybase and an older Oracle -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Guy Hammond INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
stored outlines + remote db access
Dear All, We have an application that was performing very bad when we migrated a remote database from 7.3.4.40 to 8.1.6.3.0. SInce we do not have time to tune all queries issued by the application we thought that stored outlines is the way to go. The application connect tos the remote side throught database links. We have created a trigger upon login of a specific user on remote site that actually alters the session to use the outlines. However nothing happens (i.e the trigger executes correctly but stored outlines are not used). Your insight views will be greatly appreciated. Thanks, Hatzistavrou Yannis Telco Analyst -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hatzistavrou Giannis INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Tracing a sql statement also to include bind variables
That is beacuase it is not DBMS_SUPPORT, it is DBMS_SYSTEM: exec sys.dbms_system.set_sql_trace_in_session(sid,serial#,TRUE|FALSE); HTH Mark -Original Message- Subramanian Sent: Wednesday, September 26, 2001 07:45 To: Multiple recipients of list ORACLE-L Dear List, I couldn't find this dbms_support.start_trace_in_session(sid,serial#,TRUE,TRUE) Platform WinNT Oracle 8.1.7 Pl let me know venkat -- On Mon, 24 Sep 2001 03:05:19 Christian Trassens wrote: Execute as sys or dba user the package dbms_system.set_ev(sid,serial#,10046,12,''); Or with oradebug: oradebug setospid OSPID of the session and then oradebug event 10046 trace name context forever level 12 Or from the user: alter session set events '10046 trace name context forever, level 12'; Or with the package dbms_support: dbms_support.start_trace_in_session(sid,serial#,TRUE,TRUE) Regards. --- [EMAIL PROTECTED] wrote: Hi All, I have to trace a sql that a user generates. I also need the bind variables. Can somebody please enlighten me??? TIA Jack = De informatie verzonden in dit e-mailbericht is vertrouwelijk en is uitsluitend bestemd voor de geadresseerde. Openbaarmaking, vermenigvuldiging, verspreiding en/of verstrekking van deze informatie aan derden is, behoudens voorafgaande schriftelijke toestemming van Ernst Young, niet toegestaan. Ernst Young staat niet in voor de juiste en volledige overbrenging van de inhoud van een verzonden e-mailbericht, noch voor tijdige ontvangst daarvan. Ernst Young kan niet garanderen dat een verzonden e-mailbericht vrij is van virussen, noch dat e-mailberichten worden overgebracht zonder inbreuk of tussenkomst van onbevoegde derden. Indien bovenstaand e-mailbericht niet aan u is gericht, verzoeken wij u vriendelijk doch dringend het e-mailbericht te retourneren aan de verzender en het origineel en eventuele kopiekn te verwijderen en te vernietigen. Ernst Young hanteert bij de uitoefening van haar werkzaamheden algemene voorwaarden, waarin een beperking van aansprakelijkheid is opgenomen. De algemene voorwaarden worden u op verzoek kosteloos toegezonden. = The information contained in this communication is confidential and is intended solely for the use of the individual or entity to whom it is addressed. You should not copy, disclose or distribute this communication without the authority of Ernst Young. Ernst Young is neither liable for the proper and complete transmission of the information contained in this communication nor for any delay in its receipt. Ernst Young does not guarantee that the integrity of this communication has been maintained nor that the communication is free of viruses, interceptions or interference. If you are not the intended recipient of this communication please return the communication to the sender and delete and destroy all copies. In carrying out its engagements, Ernst Young applies general terms and conditions, which contain a clause that limits its liability. A copy of these terms and conditions is available on request free of charge. = -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Eng. Christian Trassens Senior DBA Systems Engineer [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : 541149816062 __ Do You Yahoo!? Get email alerts NEW webcam video instant messaging with Yahoo! Messenger. http://im.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christian Trassens INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Make a difference, help support the relief efforts in the U.S.
RE: Alert log from Remote client
Nirmal, Perhaps the replies re AlertView have answered your question. AFAICR it requires FTP service to be running. You did not specify your Operating System. Do you simply want to view the Alert logs and Trace files for the various databases or be alerted if an error appears in Alert Log or a new trace file is created?. Sean :) Data Base Administrator Oracle 7.3.3, 8.0.5, 8.1.7 - NT, W2K [0%] OCP Oracle8i DBA --- End 2002 deadline =:-O [0%] OCP Oracle9i DBA Organon (Ireland) Ltd. E-mail: [EMAIL PROTECTED] [subscribed: Digest Mode] Visit: http://groups.yahoo.com/group/Oracle-OCP-DBA Nobody loves me but my mother... and she could be jivin' too. - BB King From: Nirmal Kumar Muthu Kumaran [EMAIL PROTECTED] Date: Tue, 25 Sep 2001 12:19:57 +0300 Subject: Alert log from Remote client Hi guru's Suppose that, i'm managing serveral database from a single client. In that case, how can i find out the alert log/trace files from the client. Any ideas pls. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: O'Neill, Sean INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Tracing a sql statement also to include bind variables
WOW!! What a typo!! That should of course be *because*.. LOL.. Mark -Original Message- Sent: Wednesday, September 26, 2001 10:45 To: Multiple recipients of list ORACLE-L That is beacuase it is not DBMS_SUPPORT, it is DBMS_SYSTEM: exec sys.dbms_system.set_sql_trace_in_session(sid,serial#,TRUE|FALSE); HTH Mark -Original Message- Subramanian Sent: Wednesday, September 26, 2001 07:45 To: Multiple recipients of list ORACLE-L Dear List, I couldn't find this dbms_support.start_trace_in_session(sid,serial#,TRUE,TRUE) Platform WinNT Oracle 8.1.7 Pl let me know venkat -- On Mon, 24 Sep 2001 03:05:19 Christian Trassens wrote: Execute as sys or dba user the package dbms_system.set_ev(sid,serial#,10046,12,''); Or with oradebug: oradebug setospid OSPID of the session and then oradebug event 10046 trace name context forever level 12 Or from the user: alter session set events '10046 trace name context forever, level 12'; Or with the package dbms_support: dbms_support.start_trace_in_session(sid,serial#,TRUE,TRUE) Regards. --- [EMAIL PROTECTED] wrote: Hi All, I have to trace a sql that a user generates. I also need the bind variables. Can somebody please enlighten me??? TIA Jack = De informatie verzonden in dit e-mailbericht is vertrouwelijk en is uitsluitend bestemd voor de geadresseerde. Openbaarmaking, vermenigvuldiging, verspreiding en/of verstrekking van deze informatie aan derden is, behoudens voorafgaande schriftelijke toestemming van Ernst Young, niet toegestaan. Ernst Young staat niet in voor de juiste en volledige overbrenging van de inhoud van een verzonden e-mailbericht, noch voor tijdige ontvangst daarvan. Ernst Young kan niet garanderen dat een verzonden e-mailbericht vrij is van virussen, noch dat e-mailberichten worden overgebracht zonder inbreuk of tussenkomst van onbevoegde derden. Indien bovenstaand e-mailbericht niet aan u is gericht, verzoeken wij u vriendelijk doch dringend het e-mailbericht te retourneren aan de verzender en het origineel en eventuele kopiekn te verwijderen en te vernietigen. Ernst Young hanteert bij de uitoefening van haar werkzaamheden algemene voorwaarden, waarin een beperking van aansprakelijkheid is opgenomen. De algemene voorwaarden worden u op verzoek kosteloos toegezonden. = The information contained in this communication is confidential and is intended solely for the use of the individual or entity to whom it is addressed. You should not copy, disclose or distribute this communication without the authority of Ernst Young. Ernst Young is neither liable for the proper and complete transmission of the information contained in this communication nor for any delay in its receipt. Ernst Young does not guarantee that the integrity of this communication has been maintained nor that the communication is free of viruses, interceptions or interference. If you are not the intended recipient of this communication please return the communication to the sender and delete and destroy all copies. In carrying out its engagements, Ernst Young applies general terms and conditions, which contain a clause that limits its liability. A copy of these terms and conditions is available on request free of charge. = -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Eng. Christian Trassens Senior DBA Systems Engineer [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : 541149816062 __ Do You Yahoo!? Get email alerts NEW webcam video instant messaging with Yahoo! Messenger. http://im.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christian Trassens INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list
How to tune treewalk sql statement
Dear List, I have an Sql statement use start with and connect by clause. How can I tune this sql statement? So it will take less time Regards, Ashraf Salaymeh __ Do You Yahoo!? Get email alerts NEW webcam video instant messaging with Yahoo! Messenger. http://im.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ASHRAF SALAYMEH INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Physical access to servers for maintenance
Some comments and queries interspersed below. From: Steven Lembark [EMAIL PROTECTED] Date: Tue, 25 Sep 2001 09:18:05 -0500 Subject: Re: Physical access to servers for maintenance Begin Snip Simplest method would be to say no we don't need it now, what is the pager number of someone we can use if we do need things done? Make a point of paging them every time you need something from the shell, day or night. That person will, I'm sure, be happy to compile a list of the trivial things they've been forced to do that the DBA should have done for themselves at 3am... End Snip Like your thinking on this Steven :) From: Thater, William [EMAIL PROTECTED] Date: Tue, 25 Sep 2001 10:20:42 -0400 Subject: Re: Physical access to servers for maintenance Begin snip if the server crashes and you have to restart the DB without VNC or PC Anywhere running, how do you do that? End Snip William, I would expect the Sys Admins to restart the server. The DB(s) should subsequently come up. Am I missing something in what you wish to convey? My conclusion based upon what I've read on this thread was that installs were raised as the primary flag for local physical access but that even this can be worked around if necessary. So what tools are people using for remote administration?. Perhaps to be more specific if you're on LAN but have no phyisical access to server and then same for WAN and then over PSTN. Do you use different tools for remote admin in these different scenarios, i.e. distance and bandwidth limitations force use of different tools?. Anyone any feedback on experiences of PocketDBA product?. Anyone any bad press or gotchas about VNC? Sean :) Data Base Administrator Oracle 7.3.3, 8.0.5, 8.1.7 - NT, W2K [0%] OCP Oracle8i DBA --- End 2002 deadline =:-O [0%] OCP Oracle9i DBA Organon (Ireland) Ltd. E-mail: [EMAIL PROTECTED] [subscribed: Digest Mode] Visit: http://groups.yahoo.com/group/Oracle-OCP-DBA Nobody loves me but my mother... and she could be jivin' too. - BB King -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: O'Neill, Sean INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle DBA Team Leader Needed in Arkansas-4 Day Work Week..
Do they mean the Capitol, or the capital city? Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) -Original Message- From: OraStaff [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, September 25, 2001 6:45 PM To: Multiple recipients of list ORACLE-L Subject:Oracle DBA Team Leader Needed in Arkansas-4 Day Work Week.. Great company in Central Arkansas (45 minutes outside of Little Rock-the capitol) needs an Oracle DBA team leader to join its' I.T. staff. Selected candidate must have leadership skills to lead a team of 4 or 5 developers and junior DBAs'. This company is currently running Oracle 7.3 and 8.0 on VMS and 8.1.5 on NT.. migrating to 8.1.7 on UNIX platforms. Since most of their employees live in Little Rock and make the commute, this company offers a 4 day/9 hr a day work week. This is a full time staff position so no sub-contractors or third parties please. Please do not call or send a resume if you are not in the U.S. and/or need sponsorship. * Requirements: - 3+ Years Oracle DBA experience - Leadership skills and/or experience - B.S. in Computer Science or related technical discipline. - Oracle DBA certification - U.S. citizenship or Permanent residency is also required These positions offer: * Stability * The opportunity to become a key member of the team. * Base salary-D.O.E., but in the 80K range. PLEASE do not send your resume if you are not in the United States. For immediate consideration, please send your resume as a Word attachment to: OraStaff, Inc. Email: [EMAIL PROTECTED] ph: 1-800 -549-8502 Please use job code One/Little Rock/DBA Leader/Kari All Submissions are handled in confidence. *We pay referral fees. So please contact me if you know of anyone who would be qualified/interested in the posiition described above- if it is not a match for your skills. Thanks, Bill Law -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: OraStaff INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: coalesce tablespace
Thanks for reply, especialy to Barbara and Bruce. I made some experiments: I think, fragmentation plays no role (PERCENT_BLOCKS_COALESCED is mostly 100). Execution plan is the same on Win NT and Open VMS. Optimizer methods choose and rule gives almost the same results. Select from table FET$ ( on this table the views dba_free_space_coalesced_tmp1, ...tmp2 are defined) is almost instantaneous. Then I created XXX view with the same definition as dba_free_space_coalesced_tmp1 view. create or replace view XXX as select ts#, count(*) extents_coalesced, sum(length) blocks_coalesced from sys.fet$ a where not exists ( select * from sys.fet$ b where b.ts#=a.ts# and b.file#=a.file# and a.block#=b.block#+b.length) group by ts# ; Select * from xxx takes 17 minutes on OpenVMS. The problem is perhaps lack of physical memory ?. Can you give me any suggestion how to verify this assumption? Thanks Michal -Pùvodní zpráva- Od: Reardon, Bruce (CALBBAY) [mailto:[EMAIL PROTECTED]] Odesláno: 26. záøí 2001 5:55 Komu: Multiple recipients of list ORACLE-L Pøedmìt: RE: coalesce tablespace Michal, It might not be related, but there have been a number of known bugs when selecting against data dictionary tables whilst using the CBO. So, if you are using the CBO on VMS, then try doing alter session set optimizer_goal=rule; and then repeating the dba_free_space_coalesced query. You could also try doing the query as sys with autotrace on, to compare the execution plan on the 2 systems. Regards, Bruce Reardon -Original Message- Sent: Tuesday, 25 September 2001 10:40 Thanks for your suggestion. Timing in my case is (for select * from dba_free_space_coalesced) 8 seconds for Win NT 2x400MHz PII 512 MB RAM, testing database 8.0.5 with 7 tablespaces each about 500 MB. 10 minutes 24 seconds for Open VMS 7.1 Alpha 2100 275 MHz, 512 MB RAM, testing database 8.0.5 with 17 tablespaces each about 100 MB. SQLPlus process which executes this select is consuming nearly 100% of cpu all the time. I am just wondering about the reason for such a big difference. Could it be caused by fragmentation? Is there useful script for determine fragmentation? I can exclude the bug while on production database (VMS on rather stronger machine) this select statement takes several seconds as on Win NT. Michal -Puvodní zpráva- Od: Baker, Barbara [mailto:[EMAIL PROTECTED]] Odesláno: 25. zárí 2001 1:17 Michal: You mention the select for the view dba_free_space_coalesced. I'm not sure what you're actually doing. However, if I set time on and issue the command select * from dba_free_space_coalesced here's elapsed time on my VMS system start: 16:07:44 end:16:07:59 here's elapsed time on my Solaris system start: 16:05:21 end 16:05:29 The 2 databases are sized comparably. (The Solaris box has more power) Just selecting from the view should be almost instantaneous. Sounds like something else is going on on the VMS box. HTH. Barb -- From: Mohammad Rafiq[SMTP:[EMAIL PROTECTED]] Sent: Monday, September 24, 2001 4:07 PM Is it working or not? Have you done coalesing or not? As regard timings, it depends on system and number of objects on a database? Regards MOHAMMAD RAFIQ Date: Mon, 24 Sep 2001 06:35:26 -0800 Hi, how is defined view dba_free_space_coalesced? What reason can be, that SELECT response on this view takes me in databese on Win NT several seconds while in database on OpenVMS it takes several minutes (databases are similar). Thanks for suggestions Michal -Puvodní zpráva- Od: Mohammad Rafiq [mailto:[EMAIL PROTECTED]] Odesláno: 20. zárí 2001 22:51 Following script may be used to check whether coalesing is required or not. If lasr column not 100% then coalesce that tbs select substr(tablespace_name,1,10)TS_NAME,total_extents Total_Extnts,extents_coalesced,round(percent_extents_coalesced,0) from dba_free_space_coalesced / MOHAMMAD RAFIQ To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Thu, 20 Sep 2001 12:21:21 -0800 It would take contiguous free extents and make them larger extents, which would be more likely to reuse. Especially if there are many smaller ones, this moot if using LMT. It is a very quick procedure and good to do occasional, you can check in dba_data_files_coalesced to see if the number is far from 100%, if it is less than 75% or so, just throw a coalesce on the tablespace. Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes. Christopher R. Spence Oracle DBA Phone: (978) 322-5744 Fax:(707) 885-2275 Fuelspot 73 Princeton Street North, Chelmsford 01863 -Original Message- Sent: Thursday, September 20, 2001 3:40 PM We have tablespaces in acceptance and production that are being resized for
RE: How to tune treewalk sql statement
Can you post the query so we can have a nosey at it?? Kev... hit any user to continue -Original Message- Sent: 26 September 2001 12:20 To: Multiple recipients of list ORACLE-L Dear List, I have an Sql statement use start with and connect by clause. How can I tune this sql statement? So it will take less time Regards, Ashraf Salaymeh __ Do You Yahoo!? Get email alerts NEW webcam video instant messaging with Yahoo! Messenger. http://im.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ASHRAF SALAYMEH INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thomas, Kevin INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Physical access to servers for maintenance
Title: RE: Physical access to servers for maintenance This doesn't work for NT machines, and it with Unix you cannot install 8.1.6 without X access. Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes. Christopher R. Spence Oracle DBA Phone: (978) 322-5744 Fax: (707) 885-2275 Fuelspot 73 Princeton Street North, Chelmsford 01863 -Original Message- From: Koivu, Lisa [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 25, 2001 11:45 AM To: Multiple recipients of list ORACLE-L Subject: RE: Physical access to servers for maintenance What's wrong with telnetting in? -Original Message- From: Steven Lembark [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, September 25, 2001 11:20 AM To: Multiple recipients of list ORACLE-L Subject: Re: Physical access to servers for maintenance -- Smith, Ron L. [EMAIL PROTECTED] Our hardware people are cracking sown on access to the computer room. They have decided the DBA group can do all their work without going to the server itself. This includes Unix and NT server running both Oracle and SQL Server. We would have to use VNC Viewer and PC Anywhere. I am trying to put together a list of things we might need to do that would make remote admin difficult as well as taking longer. If you have any ideas I would appreciate it. How about Your Work? Last time I looked it's rather hard to run svrmgrl without access to the command line. So long as you don't want to start or stop the database this probably won't have any effect. Checking free disk space is also simpler with df. You can, perhaps, memorize the nubmber of blocks on every device and compare them to the free space reported by Oracle each morning. Simplest method would be to say no we don't need it now, what is the pager number of someone we can use if we do need things done? Make a point of paging them every time you need something from the shell, day or night. That person will, I'm sure, be happy to compile a list of the trivial things they've been forced to do that the DBA should have done for themselves at 3am... -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647 +1 800 762 1582 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steven Lembark INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Physical access to servers for maintenance
I do 99% of what I need from SSH as well, the only exception is hardware and installs, which I have someone in the data center do. Of course, under NT this is completely different. Although Win2000 does have a funky Telnet. Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes. Christopher R. Spence Oracle DBA Phone: (978) 322-5744 Fax:(707) 885-2275 Fuelspot 73 Princeton Street North, Chelmsford 01863 -Original Message- Sent: Tuesday, September 25, 2001 1:20 PM To: Multiple recipients of list ORACLE-L At 12:25 PM 9/25/2001, Kimberly Smith wrote: Steven, although you need all that you say we need you sure don't need access to the server room for that. At the very least there is telnet, which is what I use from home. Then there are things like Exceed and Xterms, which is what I use at work. By no means do you need access to the server itself to do the day to day stuff. OK so i can do 95-98% of what i need to do without access to the servers. [i use SSH myself.] but those few time i need access it's because something is badly wrong with either the server or the network, and those time i really need the access. so i prefer to keep my access rather tan give it up. they are after all , *my* databases, and i'm the one responsible. -- Bill Shrek Thater ORACLE DBA Telergy,Inc. [EMAIL PROTECTED] You gotta program like you don't need the money, You gotta compile like you'll never get hurt, You gotta run like there's nobody watching, It's gotta come from the heart if you want it to work. The attention span of a computer is only as long as its power cord. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thater, William INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christopher Spence INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Tracing a sql statement also to include bind variables
I think it comes with 8.0.4. I don't know exactly. However I enclose it one copy. Regards. --- Mark Leith [EMAIL PROTECTED] wrote: WOW!! What a typo!! That should of course be *because*.. LOL.. Mark -Original Message- Sent: Wednesday, September 26, 2001 10:45 To: Multiple recipients of list ORACLE-L That is beacuase it is not DBMS_SUPPORT, it is DBMS_SYSTEM: exec sys.dbms_system.set_sql_trace_in_session(sid,serial#,TRUE|FALSE); HTH Mark -Original Message- Subramanian Sent: Wednesday, September 26, 2001 07:45 To: Multiple recipients of list ORACLE-L Dear List, I couldn't find this dbms_support.start_trace_in_session(sid,serial#,TRUE,TRUE) Platform WinNT Oracle 8.1.7 Pl let me know venkat -- On Mon, 24 Sep 2001 03:05:19 Christian Trassens wrote: Execute as sys or dba user the package dbms_system.set_ev(sid,serial#,10046,12,''); Or with oradebug: oradebug setospid OSPID of the session and then oradebug event 10046 trace name context forever level 12 Or from the user: alter session set events '10046 trace name context forever, level 12'; Or with the package dbms_support: dbms_support.start_trace_in_session(sid,serial#,TRUE,TRUE) Regards. --- [EMAIL PROTECTED] wrote: Hi All, I have to trace a sql that a user generates. I also need the bind variables. Can somebody please enlighten me??? TIA Jack = De informatie verzonden in dit e-mailbericht is vertrouwelijk en is uitsluitend bestemd voor de geadresseerde. Openbaarmaking, vermenigvuldiging, verspreiding en/of verstrekking van deze informatie aan derden is, behoudens voorafgaande schriftelijke toestemming van Ernst Young, niet toegestaan. Ernst Young staat niet in voor de juiste en volledige overbrenging van de inhoud van een verzonden e-mailbericht, noch voor tijdige ontvangst daarvan. Ernst Young kan niet garanderen dat een verzonden e-mailbericht vrij is van virussen, noch dat e-mailberichten worden overgebracht zonder inbreuk of tussenkomst van onbevoegde derden. Indien bovenstaand e-mailbericht niet aan u is gericht, verzoeken wij u vriendelijk doch dringend het e-mailbericht te retourneren aan de verzender en het origineel en eventuele kopiekn te verwijderen en te vernietigen. Ernst Young hanteert bij de uitoefening van haar werkzaamheden algemene voorwaarden, waarin een beperking van aansprakelijkheid is opgenomen. De algemene voorwaarden worden u op verzoek kosteloos toegezonden. = The information contained in this communication is confidential and is intended solely for the use of the individual or entity to whom it is addressed. You should not copy, disclose or distribute this communication without the authority of Ernst Young. Ernst Young is neither liable for the proper and complete transmission of the information contained in this communication nor for any delay in its receipt. Ernst Young does not guarantee that the integrity of this communication has been maintained nor that the communication is free of viruses, interceptions or interference. If you are not the intended recipient of this communication please return the communication to the sender and delete and destroy all copies. In carrying out its engagements, Ernst Young applies general terms and conditions, which contain a clause that limits its liability. A copy of these terms and conditions is available on request free of charge. = -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Eng. Christian Trassens Senior DBA Systems Engineer [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : 541149816062 __ Do You Yahoo!? Get email alerts NEW webcam video instant messaging with Yahoo! Messenger. http://im.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christian Trassens INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego,
Re: Physical access to servers for maintenance
Ohhh, it works! All you need is ... ??? (Telnet server alias telnetd) :-))) JP On Wed 26. September 2001 14:45, you wrote: This doesn't work for NT machines, and it with Unix you cannot install 8.1.6 without X access. Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes. Christopher R. Spence Oracle DBA Phone: (978) 322-5744 Fax:(707) 885-2275 Fuelspot 73 Princeton Street North, Chelmsford 01863 -Original Message- Sent: Tuesday, September 25, 2001 11:45 AM To: Multiple recipients of list ORACLE-L What's wrong with telnetting in? -Original Message- Sent: Tuesday, September 25, 2001 11:20 AM To: Multiple recipients of list ORACLE-L -- Smith, Ron L. [EMAIL PROTECTED] Our hardware people are cracking sown on access to the computer room. They have decided the DBA group can do all their work without going to the server itself. This includes Unix and NT server running both Oracle and SQL Server. We would have to use VNC Viewer and PC Anywhere. I am trying to put together a list of things we might need to do that would make remote admin difficult as well as taking longer. If you have any ideas I would appreciate it. How about Your Work? Last time I looked it's rather hard to run svrmgrl without access to the command line. So long as you don't want to start or stop the database this probably won't have any effect. Checking free disk space is also simpler with df. You can, perhaps, memorize the nubmber of blocks on every device and compare them to the free space reported by Oracle each morning. Simplest method would be to say no we don't need it now, what is the pager number of someone we can use if we do need things done? Make a point of paging them every time you need something from the shell, day or night. That person will, I'm sure, be happy to compile a list of the trivial things they've been forced to do that the DBA should have done for themselves at 3am... Content-Type: text/html; name=Pøíloha: 1 Content-Transfer-Encoding: quoted-printable Content-Description: -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jan Pruner INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Physical access to servers for maintenance
Title: RE: Physical access to servers for maintenance OK, terminal services? I agree that install is an exception. It's nearly impossible if you aren't sitting in front of the host. -Original Message- From: Christopher Spence [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, September 26, 2001 8:45 AM To: Multiple recipients of list ORACLE-L Subject: RE: Physical access to servers for maintenance This doesn't work for NT machines, and it with Unix you cannot install 8.1.6 without X access. Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes. Christopher R. Spence Oracle DBA Phone: (978) 322-5744 Fax: (707) 885-2275 Fuelspot 73 Princeton Street North, Chelmsford 01863 -Original Message- From: Koivu, Lisa [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 25, 2001 11:45 AM To: Multiple recipients of list ORACLE-L Subject: RE: Physical access to servers for maintenance What's wrong with telnetting in? -Original Message- From: Steven Lembark [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, September 25, 2001 11:20 AM To: Multiple recipients of list ORACLE-L Subject: Re: Physical access to servers for maintenance -- Smith, Ron L. [EMAIL PROTECTED] Our hardware people are cracking sown on access to the computer room. They have decided the DBA group can do all their work without going to the server itself. This includes Unix and NT server running both Oracle and SQL Server. We would have to use VNC Viewer and PC Anywhere. I am trying to put together a list of things we might need to do that would make remote admin difficult as well as taking longer. If you have any ideas I would appreciate it. How about Your Work? Last time I looked it's rather hard to run svrmgrl without access to the command line. So long as you don't want to start or stop the database this probably won't have any effect. Checking free disk space is also simpler with df. You can, perhaps, memorize the nubmber of blocks on every device and compare them to the free space reported by Oracle each morning. Simplest method would be to say no we don't need it now, what is the pager number of someone we can use if we do need things done? Make a point of paging them every time you need something from the shell, day or night. That person will, I'm sure, be happy to compile a list of the trivial things they've been forced to do that the DBA should have done for themselves at 3am... -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647 +1 800 762 1582 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steven Lembark INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: coalesce tablespace
Do you have the same parameters in init.ora file? Parameters like sort_are_size might be important for performace of such a query. What are waits during processing? Ivo -Original Message- Sent: Wednesday, September 26, 2001 02:30 PM To: Multiple recipients of list ORACLE-L Thanks for reply, especialy to Barbara and Bruce. I made some experiments: I think, fragmentation plays no role (PERCENT_BLOCKS_COALESCED is mostly 100). Execution plan is the same on Win NT and Open VMS. Optimizer methods choose and rule gives almost the same results. Select from table FET$ ( on this table the views dba_free_space_coalesced_tmp1, ...tmp2 are defined) is almost instantaneous. Then I created XXX view with the same definition as dba_free_space_coalesced_tmp1 view. create or replace view XXX as select ts#, count(*) extents_coalesced, sum(length) blocks_coalesced from sys.fet$ a where not exists ( select * from sys.fet$ b where b.ts#=a.ts# and b.file#=a.file# and a.block#=b.block#+b.length) group by ts# ; Select * from xxx takes 17 minutes on OpenVMS. The problem is perhaps lack of physical memory ?. Can you give me any suggestion how to verify this assumption? Thanks Michal -Pùvodní zpráva- Od: Reardon, Bruce (CALBBAY) [mailto:[EMAIL PROTECTED]] Odesláno: 26. záøí 2001 5:55 Komu: Multiple recipients of list ORACLE-L Pøedmìt: RE: coalesce tablespace Michal, It might not be related, but there have been a number of known bugs when selecting against data dictionary tables whilst using the CBO. So, if you are using the CBO on VMS, then try doing alter session set optimizer_goal=rule; and then repeating the dba_free_space_coalesced query. You could also try doing the query as sys with autotrace on, to compare the execution plan on the 2 systems. Regards, Bruce Reardon -Original Message- Sent: Tuesday, 25 September 2001 10:40 Thanks for your suggestion. Timing in my case is (for select * from dba_free_space_coalesced) 8 seconds for Win NT 2x400MHz PII 512 MB RAM, testing database 8.0.5 with 7 tablespaces each about 500 MB. 10 minutes 24 seconds for Open VMS 7.1 Alpha 2100 275 MHz, 512 MB RAM, testing database 8.0.5 with 17 tablespaces each about 100 MB. SQLPlus process which executes this select is consuming nearly 100% of cpu all the time. I am just wondering about the reason for such a big difference. Could it be caused by fragmentation? Is there useful script for determine fragmentation? I can exclude the bug while on production database (VMS on rather stronger machine) this select statement takes several seconds as on Win NT. Michal -Puvodní zpráva- Od: Baker, Barbara [mailto:[EMAIL PROTECTED]] Odesláno: 25. zárí 2001 1:17 Michal: You mention the select for the view dba_free_space_coalesced. I'm not sure what you're actually doing. However, if I set time on and issue the command select * from dba_free_space_coalesced here's elapsed time on my VMS system start: 16:07:44 end:16:07:59 here's elapsed time on my Solaris system start: 16:05:21 end 16:05:29 The 2 databases are sized comparably. (The Solaris box has more power) Just selecting from the view should be almost instantaneous. Sounds like something else is going on on the VMS box. HTH. Barb -- From: Mohammad Rafiq[SMTP:[EMAIL PROTECTED]] Sent: Monday, September 24, 2001 4:07 PM Is it working or not? Have you done coalesing or not? As regard timings, it depends on system and number of objects on a database? Regards MOHAMMAD RAFIQ Date: Mon, 24 Sep 2001 06:35:26 -0800 Hi, how is defined view dba_free_space_coalesced? What reason can be, that SELECT response on this view takes me in databese on Win NT several seconds while in database on OpenVMS it takes several minutes (databases are similar). Thanks for suggestions Michal -Puvodní zpráva- Od: Mohammad Rafiq [mailto:[EMAIL PROTECTED]] Odesláno: 20. zárí 2001 22:51 Following script may be used to check whether coalesing is required or not. If lasr column not 100% then coalesce that tbs select substr(tablespace_name,1,10)TS_NAME,total_extents Total_Extnts,extents_coalesced,round(percent_extents_coalesced,0) from dba_free_space_coalesced / MOHAMMAD RAFIQ To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Thu, 20 Sep 2001 12:21:21 -0800 It would take contiguous free extents and make them larger extents, which would be more likely to reuse. Especially if there are many smaller ones, this moot if using LMT. It is a very quick procedure and good to do occasional, you can check in dba_data_files_coalesced to see if the number is far from 100%, if it is less than 75% or so, just throw a coalesce on the tablespace. Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes. Christopher
RE: Physical access to servers for maintenance
Title: RE: Physical access to servers for maintenance Are you talking NT only or install in general? On unix all you need is a decent X-windows package for your PC (Exceed, ChameleonX, Reflection X?, etc). I've been here 3 years, installed at least 30 new systems and have never been in any of our computer rooms. -Original Message-From: Koivu, Lisa [mailto:[EMAIL PROTECTED]]Sent: Wednesday, September 26, 2001 9:05 AMTo: Multiple recipients of list ORACLE-LSubject: RE: Physical access to servers for maintenance OK, terminal services? I agree that install is an exception. It's nearly impossible if you aren't sitting in front of the host. -Original Message- From: Christopher Spence [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, September 26, 2001 8:45 AM To: Multiple recipients of list ORACLE-L Subject: RE: Physical access to servers for maintenance This doesn't work for NT machines, and it with Unix you cannot install 8.1.6 without X access. "Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes." Christopher R. SpenceOracle DBAPhone: (978) 322-5744Fax: (707) 885-2275 Fuelspot73 Princeton StreetNorth, Chelmsford 01863 -Original Message-From: Koivu, Lisa [mailto:[EMAIL PROTECTED]]Sent: Tuesday, September 25, 2001 11:45 AMTo: Multiple recipients of list ORACLE-LSubject: RE: Physical access to servers for maintenance What's wrong with telnetting in? -Original Message-From: Steven Lembark [SMTP:[EMAIL PROTECTED]]Sent: Tuesday, September 25, 2001 11:20 AMTo: Multiple recipients of list ORACLE-LSubject: Re: Physical access to servers for maintenance -- "Smith, Ron L." [EMAIL PROTECTED] Our hardware people are cracking sown on access to the computer room. They have decided the DBA group can do all their work without going to the server itself. This includes Unix and NT server running both Oracle and SQL Server. We would have to use VNC Viewer and PC Anywhere. I am trying to put together a list of things we might need to do that would make remote admin difficult as well as taking longer. If you have any ideas I would appreciate it. How about "Your Work"? Last time I looked it's rather hard to run svrmgrl without access tothe command line. So long as you don't want to start or stop thedatabase this probably won't have any effect. Checking free disk space is also simpler with "df". You can, perhaps,memorize the nubmber of blocks on every device and compare them to thefree space reported by Oracle each morning. Simplest method would be to say "no we don't need it now, what is thepager number of someone we can use if we do need things done?" Makea point of paging them every time you need something from the shell,day or night. That person will, I'm sure, be happy to compile a listof the trivial things they've been forced to do that the DBA should havedone for themselves at 3am... --Steven Lembark 2930 W. PalmerWorkhorse Computing Chicago, IL 60647 +1 800 762 1582--Please see the official ORACLE-L FAQ: http://www.orafaq.com--Author: Steven Lembark INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
RE: How TSPITR?
The controlfiles have to be a backup controlfile from the source database, as the one you create with: alter database backup controlfile to '.' Regards. --- Seema Singh [EMAIL PROTECTED] wrote: I did. in initCLONE.ora file control_files = Name of control file would be new name or what? Thanks -Seema From: Christian Trassens [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: How TSPITR? Date: Tue, 25 Sep 2001 00:30:20 -0800 Before recover, you must put all the datafiles online. You can see it yourself, just take a look of the status of the datafiles. Regards. --- Seema Singh [EMAIL PROTECTED] wrote: Yes.I have gone thru documents. I am facing problem to open clone db ON Win2000. 1)Created oracle service. 2)Startup nomount 3)ALter database mount CLONE database; 4)recover database using backup controlfile until time ''; The message I am getting ORA-01547 :warning:RECOVER suceeded but open resetlogs would be get error below ORA-01248: file 1 was created in the future of complete recovery ORA-01110:data file 1:'c:path\system01.dbf' I am unable to open the clone database. Please suggest what I can do. Thanks -Seema From: Koivu, Lisa [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: How TSPITR? Date: Mon, 24 Sep 2001 13:43:04 -0800 Seema this is a very involved topic and your question is very broad. Have you read the documentation? -Original Message- From: Seema Singh [SMTP:[EMAIL PROTECTED]] Sent: Monday, September 24, 2001 5:18 PM To: Multiple recipients of list ORACLE-L Subject: How TSPITR? Hi Is it possible TSPITR if I have hotbackup? I am using Oracle8.1.7 on WIN2000. I want to test TSPITR procedure on our DB. Let us consider I have hotbackup at night.At 10am in morning user drop the table. The database os running in archived mode. Let me know how to recover DB as TSPITR. Thanks -Seema _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seema Singh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seema Singh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Eng. Christian Trassens Senior DBA Systems Engineer [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : 541149816062 __ Do You Yahoo!? Get email alerts NEW webcam video instant messaging with Yahoo! Messenger. http://im.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christian Trassens INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Physical access to servers for maintenance
8.1.6 and higher you must use the interactive installer, it will not work through telnet. As far as I have seen, it is the same for 9i as well, unless I missed the documents on a new character based installer. Unless something has changed recently. Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes. Christopher R. Spence Oracle DBA Phone: (978) 322-5744 Fax:(707) 885-2275 Fuelspot 73 Princeton Street North, Chelmsford 01863 -Original Message- Sent: Wednesday, September 26, 2001 9:10 AM To: Multiple recipients of list ORACLE-L Ohhh, it works! All you need is ... ??? (Telnet server alias telnetd) :-))) JP On Wed 26. September 2001 14:45, you wrote: This doesn't work for NT machines, and it with Unix you cannot install 8.1.6 without X access. Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes. Christopher R. Spence Oracle DBA Phone: (978) 322-5744 Fax:(707) 885-2275 Fuelspot 73 Princeton Street North, Chelmsford 01863 -Original Message- Sent: Tuesday, September 25, 2001 11:45 AM To: Multiple recipients of list ORACLE-L What's wrong with telnetting in? -Original Message- Sent: Tuesday, September 25, 2001 11:20 AM To: Multiple recipients of list ORACLE-L -- Smith, Ron L. [EMAIL PROTECTED] Our hardware people are cracking sown on access to the computer room. They have decided the DBA group can do all their work without going to the server itself. This includes Unix and NT server running both Oracle and SQL Server. We would have to use VNC Viewer and PC Anywhere. I am trying to put together a list of things we might need to do that would make remote admin difficult as well as taking longer. If you have any ideas I would appreciate it. How about Your Work? Last time I looked it's rather hard to run svrmgrl without access to the command line. So long as you don't want to start or stop the database this probably won't have any effect. Checking free disk space is also simpler with df. You can, perhaps, memorize the nubmber of blocks on every device and compare them to the free space reported by Oracle each morning. Simplest method would be to say no we don't need it now, what is the pager number of someone we can use if we do need things done? Make a point of paging them every time you need something from the shell, day or night. That person will, I'm sure, be happy to compile a list of the trivial things they've been forced to do that the DBA should have done for themselves at 3am... Content-Type: text/html; name=Pøíloha: 1 Content-Transfer-Encoding: quoted-printable Content-Description: -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jan Pruner INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christopher Spence INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
FW: Platform
If you are interested I found the answer on metalink: select dbms_utility.port_string from dual; Ivo -Original Message- Sent: Wednesday, September 26, 2001 02:09 PM To: '[EMAIL PROTECTED]' Hello how is it possible in PLSQL to decide on which operating system (NT/LINUX)is server running? I would like to automatically specify directory where output from dbms_file will go. On nt I need something like c:\log and on unix I would like to have something like /log . Is there any view where I can find this information about OS? Thank you for responce Ivo -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Libal, Ivo INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: SQLNet.ora file
It was probably configured not to permit remote access. You don't need sqlnet.ora, but it's useful if you want to use authentication (for example, on an NT network). Cheers, g -Original Message- Sent: Tuesday, September 25, 2001 8:30 PM To: Multiple recipients of list ORACLE-L I am new to Oracle and have been trying to connect to the database remotely. I finally am able to connect; however, I had to delete SQLNet.ora. Does anybody know if this will hurt anything? Thanks, Brian King Software Developer Starn Technical Services mailto:[EMAIL PROTECTED] 800-478-5744 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Brian King INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Guy Hammond INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Forms Developer - Conversion Trouble
... w number; ... x := get_window_property(my_win, width); ... What's wrong with this code. I get the message '...ORA-06502...' I check the return value of get_window_property and it's a varchar2 value like '400,000' Oracle itself has in help an example like this a number variable is assigned with the varchar2 value returned by get_window_property(..., width) Is it about formating that sort of values '999,999' _ Iulian Ilies mailto: [EMAIL PROTECTED] mailto: [EMAIL PROTECTED] ** The information contained in this communication is confidential and may be legally privileged. It is intended solely for the use of the individual or entity to whom it is addressed and others authorised to receive it. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking action in reliance of the contents of this information is strictly prohibited and may be unlawful. Mobil Rom is neither liable for the proper, complete transmission of the information contained in this communication nor any delay in its receipt. ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Preventing user access
If I wish to do work on a database logging in to server itself and want to prevent users from accessing the system via network is there another way to do this if I don't want to use the enable restricted session functionality. I'm thinking there's probably a neat way to utiltise the listener process but have not figured it out. Also what If I need to work on DB over network but don't want any other users using DB what can I do to prevent their connecting? Sean :) Data Base Administrator Oracle 7.3.3, 8.0.5, 8.1.7 - NT, W2K [0%] OCP Oracle8i DBA --- End 2002 deadline =:-O [0%] OCP Oracle9i DBA Organon (Ireland) Ltd. E-mail: [EMAIL PROTECTED] [subscribed: Digest Mode] Visit: http://groups.yahoo.com/group/Oracle-OCP-DBA Nobody loves me but my mother... and she could be jivin' too. - BB King -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: O'Neill, Sean INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
DBA assessment - slightly OT
If you were to choose 10 questions to evaluate the competency of a DBA what would they be given that the result would be their competence would be rated as of the following: - TERRIBLE (I would not let them within 100 miles of a database) - FAIR (I'd show them some basic admin, but do it myself, they've a lot to learn yet) - GOOD (I'd let them do some basic admin stuff by themselves but monitor their performance regularly) - VERY GOOD (I'd let them handle practically all admin type work and mentor them as required) - EXCELLENT (Hell, they could teach me a trick or too!) Sean :) Data Base Administrator Oracle 7.3.3, 8.0.5, 8.1.7 - NT, W2K [0%] OCP Oracle8i DBA --- End 2002 deadline =:-O [0%] OCP Oracle9i DBA Organon (Ireland) Ltd. E-mail: [EMAIL PROTECTED] [subscribed: Digest Mode] Visit: http://groups.yahoo.com/group/Oracle-OCP-DBA Nobody loves me but my mother... and she could be jivin' too. - BB King -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: O'Neill, Sean INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: How to tune treewalk sql statement
Does anyone else keep getting this message? K. --- [EMAIL PROTECTED] - no such user here. Hi, No such user found.Please check the Mail ID. Regards Sys Admin Team : Message contains [1] file attachments DISCLAIMER: This email is bound by the terms and conditions described at http://www.subexgroup.com/mail-disclaimer.htm -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thomas, Kevin INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: [Q] privilege allow user kill session???
Thank you for the answer. Do you have sample program? From: Jacques Kilchoer <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Subject: RE: [Q] privilege allow user kill session??? Date: Tue, 25 Sep 2001 14:55:34 -0800 Write a procedure that kills the relevant session(s) and grant the user execute access to that procedure. -Original Message- Sent: mardi, 25. septembre 2001 15:30 To: Multiple recipients of list ORACLE-L We have ORACLE 8.1.6 on UNIX server. My users asked me grant him the right to "kill the run away session." I don't want grant "alter system," alter system kill ..., to him; Because it is too high privilege. Does their has any other privilege which allow user kill session? Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ef 8454 INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Controlling disk space usage
Wondering what folk out there do to manage disk space usage by tablespaces. Is it common/bad practice to have MAXSIZE unlimited and/or MAX_EXENTS set to a value which if reached would be larger than disk capacity and therefore regular observation of space is required, or is there a better way to do this? Sean :) Data Base Administrator Oracle 7.3.3, 8.0.5, 8.1.7 - NT, W2K [0%] OCP Oracle8i DBA --- End 2002 deadline =:-O [0%] OCP Oracle9i DBA Organon (Ireland) Ltd. E-mail: [EMAIL PROTECTED] [subscribed: Digest Mode] Visit: http://groups.yahoo.com/group/Oracle-OCP-DBA Nobody loves me but my mother... and she could be jivin' too. - BB King -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: O'Neill, Sean INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Preventing user access
Sean, How about creating an admin listener (admin_listener for example) that is only defined in your own listner.ora file on your desktop PC, and not in the users listener.ora files. When you want to restrict them from access, simply shut down their listener, whilst keeping your own open? This way - If you want to do it across the network or not, you will still be able to connect.. Mark -Original Message- Sean Sent: Wednesday, September 26, 2001 15:25 To: Multiple recipients of list ORACLE-L If I wish to do work on a database logging in to server itself and want to prevent users from accessing the system via network is there another way to do this if I don't want to use the enable restricted session functionality. I'm thinking there's probably a neat way to utiltise the listener process but have not figured it out. Also what If I need to work on DB over network but don't want any other users using DB what can I do to prevent their connecting? Sean :) Data Base Administrator Oracle 7.3.3, 8.0.5, 8.1.7 - NT, W2K [0%] OCP Oracle8i DBA --- End 2002 deadline =:-O [0%] OCP Oracle9i DBA Organon (Ireland) Ltd. E-mail: [EMAIL PROTECTED] [subscribed: Digest Mode] Visit: http://groups.yahoo.com/group/Oracle-OCP-DBA Nobody loves me but my mother... and she could be jivin' too. - BB King -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: O'Neill, Sean INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Platform
Hi, You can always check for the location of the datafiles. Their location on nt should start with {A-Z}:\ and can be evaluated through a substring command or something Jack Libal, Ivo [EMAIL PROTECTED]@fatcity.com on 26-09-2001 15:10:23 Please respond to [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc:(bcc: Jack van Zanen/nlzanen1/External/MEY/NL) Hello how is it possible in PLSQL to decide on which operating system (NT/LINUX)is server running? I would like to automatically specify directory where output from dbms_file will go. On nt I need something like c:\log and on unix I would like to have something like /log . Is there any view where I can find this information about OS? Thank you for responce Ivo -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Libal, Ivo INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = De informatie verzonden in dit e-mailbericht is vertrouwelijk en is uitsluitend bestemd voor de geadresseerde. Openbaarmaking, vermenigvuldiging, verspreiding en/of verstrekking van deze informatie aan derden is, behoudens voorafgaande schriftelijke toestemming van Ernst Young, niet toegestaan. Ernst Young staat niet in voor de juiste en volledige overbrenging van de inhoud van een verzonden e-mailbericht, noch voor tijdige ontvangst daarvan. Ernst Young kan niet garanderen dat een verzonden e-mailbericht vrij is van virussen, noch dat e-mailberichten worden overgebracht zonder inbreuk of tussenkomst van onbevoegde derden. Indien bovenstaand e-mailbericht niet aan u is gericht, verzoeken wij u vriendelijk doch dringend het e-mailbericht te retourneren aan de verzender en het origineel en eventuele kopieën te verwijderen en te vernietigen. Ernst Young hanteert bij de uitoefening van haar werkzaamheden algemene voorwaarden, waarin een beperking van aansprakelijkheid is opgenomen. De algemene voorwaarden worden u op verzoek kosteloos toegezonden. = The information contained in this communication is confidential and is intended solely for the use of the individual or entity to whom it is addressed. You should not copy, disclose or distribute this communication without the authority of Ernst Young. Ernst Young is neither liable for the proper and complete transmission of the information contained in this communication nor for any delay in its receipt. Ernst Young does not guarantee that the integrity of this communication has been maintained nor that the communication is free of viruses, interceptions or interference. If you are not the intended recipient of this communication please return the communication to the sender and delete and destroy all copies. In carrying out its engagements, Ernst Young applies general terms and conditions, which contain a clause that limits its liability. A copy of these terms and conditions is available on request free of charge. = -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Platform
How about trying one, build an exception, and on exception try the other ? HTH, Remco -Oorspronkelijk bericht- Van: Libal, Ivo [mailto:[EMAIL PROTECTED]] Verzonden: woensdag 26 september 2001 15:10 Aan: Multiple recipients of list ORACLE-L Onderwerp: Platform Hello how is it possible in PLSQL to decide on which operating system (NT/LINUX)is server running? I would like to automatically specify directory where output from dbms_file will go. On nt I need something like c:\log and on unix I would like to have something like /log . Is there any view where I can find this information about OS? Thank you for responce Ivo -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Libal, Ivo INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Daemen, Remco INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: the OT list
Joe, I spoke to an Oracle employee about this recently (in past month). Since we utilize Names servers extensively,I would hate to redo entire infrastructure any time soon. Basically, I was told that Names will NOT go away any time soon, if at all. The idea to move to LDAP is great, but I haven't heard of a working solution yet, and apparently, neither has Oracle. Gary WeberSenior DBACharles Jones, LLC||Superior Information Services, LLC609-530-1144, ext 5529 -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of JOE TESTASent: Wednesday, September 26, 2001 9:50 AMTo: Multiple recipients of list ORACLE-LSubject: the OT list Don't forget this list is now to be used for oracle topics only. If you want to post OT stuff, feel free to join the [EMAIL PROTECTED] list. Although I've not seen the jokes/recipes on their yet, where are you posters at? Obligatory oracle msg :) I see in the 9i docs, ONAMES will be desupported in a future release, any insider know when? thanks, joe
RE: Alert log from Remote client
Hi sean, My db is oracle816 on WinNT4. Acutally, i want to know how to access alert/trace files from the remote oracle server. Is the DBA should share access to the directory(background_dump_dest) for the remote adminstrator? In other way, i simply want to view the alert logs and trace files for the various databases, as you said. How can i? Nirmal -Original Message- From: O'Neill, Sean [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, September 26, 2001 2:10 PM To: Multiple recipients of list ORACLE-L Subject: RE: Alert log from Remote client Nirmal, Perhaps the replies re AlertView have answered your question. AFAICR it requires FTP service to be running. You did not specify your Operating System. Do you simply want to view the Alert logs and Trace files for the various databases or be alerted if an error appears in Alert Log or a new trace file is created?. Sean :) Data Base Administrator Oracle 7.3.3, 8.0.5, 8.1.7 - NT, W2K [0%] OCP Oracle8i DBA --- End 2002 deadline =:-O [0%] OCP Oracle9i DBA Organon (Ireland) Ltd. E-mail: [EMAIL PROTECTED] [subscribed: Digest Mode] Visit: http://groups.yahoo.com/group/Oracle-OCP-DBA Nobody loves me but my mother... and she could be jivin' too. - BB King From: Nirmal Kumar Muthu Kumaran [EMAIL PROTECTED] Date: Tue, 25 Sep 2001 12:19:57 +0300 Subject: Alert log from Remote client Hi guru's Suppose that, i'm managing serveral database from a single client. In that case, how can i find out the alert log/trace files from the client. Any ideas pls. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: O'Neill, Sean INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nirmal Kumar Muthu Kumaran INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Preventing user access
Hi, If U logon to the database server itself you can just stop the listener and nobody can logon through the tns connection. You can than set the oracle sid and logon using sqlplus username/password. If you want to use tns connection yourself you can set different temporary portnumbers and restart the listener. This will at least make it a bit more difficult to connect using tnsnames But you are right there is probably a more sophisticated/secure way. Jack O'Neill, Sean [EMAIL PROTECTED]@fatcity.com on 26-09-2001 16:25:18 Please respond to [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc:(bcc: Jack van Zanen/nlzanen1/External/MEY/NL) If I wish to do work on a database logging in to server itself and want to prevent users from accessing the system via network is there another way to do this if I don't want to use the enable restricted session functionality. I'm thinking there's probably a neat way to utiltise the listener process but have not figured it out. Also what If I need to work on DB over network but don't want any other users using DB what can I do to prevent their connecting? Sean :) Data Base Administrator Oracle 7.3.3, 8.0.5, 8.1.7 - NT, W2K [0%] OCP Oracle8i DBA --- End 2002 deadline =:-O [0%] OCP Oracle9i DBA Organon (Ireland) Ltd. E-mail: [EMAIL PROTECTED] [subscribed: Digest Mode] Visit: http://groups.yahoo.com/group/Oracle-OCP-DBA Nobody loves me but my mother... and she could be jivin' too. - BB King -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: O'Neill, Sean INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = De informatie verzonden in dit e-mailbericht is vertrouwelijk en is uitsluitend bestemd voor de geadresseerde. Openbaarmaking, vermenigvuldiging, verspreiding en/of verstrekking van deze informatie aan derden is, behoudens voorafgaande schriftelijke toestemming van Ernst Young, niet toegestaan. Ernst Young staat niet in voor de juiste en volledige overbrenging van de inhoud van een verzonden e-mailbericht, noch voor tijdige ontvangst daarvan. Ernst Young kan niet garanderen dat een verzonden e-mailbericht vrij is van virussen, noch dat e-mailberichten worden overgebracht zonder inbreuk of tussenkomst van onbevoegde derden. Indien bovenstaand e-mailbericht niet aan u is gericht, verzoeken wij u vriendelijk doch dringend het e-mailbericht te retourneren aan de verzender en het origineel en eventuele kopieën te verwijderen en te vernietigen. Ernst Young hanteert bij de uitoefening van haar werkzaamheden algemene voorwaarden, waarin een beperking van aansprakelijkheid is opgenomen. De algemene voorwaarden worden u op verzoek kosteloos toegezonden. = The information contained in this communication is confidential and is intended solely for the use of the individual or entity to whom it is addressed. You should not copy, disclose or distribute this communication without the authority of Ernst Young. Ernst Young is neither liable for the proper and complete transmission of the information contained in this communication nor for any delay in its receipt. Ernst Young does not guarantee that the integrity of this communication has been maintained nor that the communication is free of viruses, interceptions or interference. If you are not the intended recipient of this communication please return the communication to the sender and delete and destroy all copies. In carrying out its engagements, Ernst Young applies general terms and conditions, which contain a clause that limits its liability. A copy of these terms and conditions is available on request free of charge. = -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be
RE: Physical access to servers for maintenance
Not so. I have never installed using the host. We only have text console terminals attached to our host boxes, so we can't do an X install on the host. Have your SA or data center person copy the cd's to a place on the server and run it exporting your display using ssh or telnet to your local X display (I run Linux, but works with X-Win, and other emulators as mentioned in other posts). As for NT, I administered servers at remote buildings using pcAnywhere or VNC at my last employer. As for physical access to the servers. Do you (as a DBA) absolutely need it? Not want, not feel slighted at not having access, not being inconvenienced, I'm meaning REALLY NEED the access. Considering other options (telnet, ssh, VNC, pcAnywhere, etc.), possibly not. On the other hand does your data center staff want to be called in for every midnight implementation to be ready to handle hardware access should it be necessary? Do they want to be brought in on every pager call you get just in case it requires some sort of physical access? You as DBA having hardware access is more for convenience so you don't need to wait on them to get an emergency restart done ... and they don't have to be called in every time you are. Why bring in two when one will do? This all goes back to the earlier comment about watching how strongly you protest. It may have negative impacts in later requests for telecommuting opportunities. Rodd Holman Original Message dated 9/26/01, 8:05:17 AM Author: Koivu, Lisa [EMAIL PROTECTED] Re: RE: Physical access to servers for maintenance: OK, terminal services? I agree that install is an exception. It's nearly impossible if you aren't sitting in front of the host. -Original Message- Sent: Wednesday, September 26, 2001 8:45 AM To: Multiple recipients of list ORACLE-L This doesn't work for NT machines, and it with Unix you cannot install 8.1.6 without X access. Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes. Christopher R. Spence Oracle DBA Phone: (978) 322-5744 Fax: (707) 885-2275 Fuelspot 73 Princeton Street North, Chelmsford 01863 --=_4D480082C68408A38488 Content-Description: filename=text1.html Content-Type: text/html Content-Transfer-Encoding: quoted-printable !DOCTYPE HTML PUBLIC -//W3C//DTD HTML 3.2//EN HTML HEAD META HTTP-EQUIV=CONTENT-TYPE CONTENT=text/html; charset=iso-8859-1 TITLERE: Physical access to servers for maintenance/TITLE META NAME=GENERATOR CONTENT=StarOffice/5.2 (Linux) META NAME=CREATED CONTENT=20010926;8305000 META NAME=CHANGEDBY CONTENT=Rodd Holman META NAME=CHANGED CONTENT=20010926;8570500 /HEAD BODY PNot so. I have never installed using the host. We only have text console terminals attached to our host boxes, so we can't do an X install on the host. Have your SA or data center person copy the cd's to a place on the server and run it exporting your display using ssh or telnet to your local X display (I run Linux, but works with X-Win, and other emulators as mentioned in other posts). As for NT, I administered servers at remote buildings using pcAnywhere or VNC at my last employer./P PAs for physical access to the servers. Do you (as a DBA) absolutely need it? Not want, not feel slighted at not having access, not being inconvenienced, I'm meaning REALLY NEED the access. Considering other options (telnet, ssh, VNC, pcAnywhere, etc.), possibly not. On the other hand does your data center staff want to be called in for every midnight implementation to be ready to handle hardware access should it be necessary? Do they want to be brought in on every pager call you get just in case it requires some sort of physical access? You as DBA having hardware access is more for convenience so you don't need to wait on them to get an emergency restart done ... and they don't have to be called in every time you are. Why bring in two when one will do?/P PThis all goes back to the earlier comment about watching how strongly you protest. It may have negative impacts in later requests for telecommuting opportunities./P PRodd Holman/P HR P STYLE=margin-bottom: 0inOriginal Message dated 9/26/01, 8:05:17 AM/P P STYLE=margin-bottom: 0inAuthor: quot;Koivu,quot; Lisa lt;[EMAIL PROTECTED]gt;/P P STYLE=margin-bottom: 0inRe: RE: Physical access to servers for maintenance:/P HR PBRBR /P PFONT COLOR=#ffFONT FACE=GeorgiaOK, terminal services? /FONT/FONT /P PFONT COLOR=#ffFONT FACE=GeorgiaI agree that install is an exception.nbsp; It's nearly impossible if you aren't sitting in front of the host. /FONT/FONT /P UL PFONT SIZE=1FONT FACE=Arial-Original Message-/FONT/FONT BRBFONT SIZE=1FONT FACE=ArialFrom:nbsp;nbsp;/FONT/FONT/B FONT SIZE=1FONT FACE=ArialChristopher Spence [SMTP:[EMAIL PROTECTED]]/FONT/FONT BRBFONT SIZE=1FONT
RE: Physical access to servers for maintenance
Title: RE: Physical access to servers for maintenance I meant install in general. It took forever to do it over a fairly weak network. Never went in the computer room? Really?? Cool :) But did someone physically load the cd on the host for you? Or did you run it from your pc? -Original Message- From: Adams, Matthew (GEA, 088130) [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, September 26, 2001 9:45 AM To: Multiple recipients of list ORACLE-L Subject: RE: Physical access to servers for maintenance Are you talking NT only or install in general? On unix all you need is a decent X-windows package for your PC (Exceed, ChameleonX, Reflection X?, etc). I've been here 3 years, installed at least 30 new systems and have never been in any of our computer rooms. -Original Message- From: Koivu, Lisa [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 26, 2001 9:05 AM To: Multiple recipients of list ORACLE-L Subject: RE: Physical access to servers for maintenance OK, terminal services? I agree that install is an exception. It's nearly impossible if you aren't sitting in front of the host. -Original Message- From: Christopher Spence [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, September 26, 2001 8:45 AM To: Multiple recipients of list ORACLE-L Subject: RE: Physical access to servers for maintenance This doesn't work for NT machines, and it with Unix you cannot install 8.1.6 without X access. Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes. Christopher R. Spence Oracle DBA Phone: (978) 322-5744 Fax: (707) 885-2275 Fuelspot 73 Princeton Street North, Chelmsford 01863 -Original Message- From: Koivu, Lisa [ mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 25, 2001 11:45 AM To: Multiple recipients of list ORACLE-L Subject: RE: Physical access to servers for maintenance What's wrong with telnetting in? -Original Message- From: Steven Lembark [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, September 25, 2001 11:20 AM To: Multiple recipients of list ORACLE-L Subject: Re: Physical access to servers for maintenance -- Smith, Ron L. [EMAIL PROTECTED] Our hardware people are cracking sown on access to the computer room. They have decided the DBA group can do all their work without going to the server itself. This includes Unix and NT server running both Oracle and SQL Server. We would have to use VNC Viewer and PC Anywhere. I am trying to put together a list of things we might need to do that would make remote admin difficult as well as taking longer. If you have any ideas I would appreciate it. How about Your Work? Last time I looked it's rather hard to run svrmgrl without access to the command line. So long as you don't want to start or stop the database this probably won't have any effect. Checking free disk space is also simpler with df. You can, perhaps, memorize the nubmber of blocks on every device and compare them to the free space reported by Oracle each morning. Simplest method would be to say no we don't need it now, what is the pager number of someone we can use if we do need things done? Make a point of paging them every time you need something from the shell, day or night. That person will, I'm sure, be happy to compile a list of the trivial things they've been forced to do that the DBA should have done for themselves at 3am... -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647 +1 800 762 1582 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steven Lembark INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Physical access to servers for maintenance
It's been a while but as I remember, for WinNT 4.0, I used to use the windows network to log in to the server, put the CD-ROM in my workstation, mount that on the server as a network drive, and do the GUI install. This worked with 8.1.4. Adams, Matthew (GEA,To: Multiple recipients of list ORACLE-L 088130) [EMAIL PROTECTED] MATT.ADAMS cc: @APPL.GE.COMSubject: RE: Physical access to servers for Sent by: rootmaintenance 09/26/2001 09:45 AM Please respond to ORACLE-L Are you talking NT only or install in general? On unix all you need is a decent X-windows package for your PC (Exceed, ChameleonX, Reflection X?, etc). I've been here 3 years, installed at least 30 new systems and have never been in any of our computer rooms. -Original Message- Sent: Wednesday, September 26, 2001 9:05 AM To: Multiple recipients of list ORACLE-L OK, terminal services? I agree that install is an exception. It's nearly impossible if you aren't sitting in front of the host. -Original Message- From: Christopher Spence [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, September 26, 2001 8:45 AM To: Multiple recipients of list ORACLE-L Subject: RE: Physical access to servers for maintenance This doesn't work for NT machines, and it with Unix you cannot install 8.1.6 without X access. Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes. Christopher R. Spence Oracle DBA Phone: (978) 322-5744 Fax: (707) 885-2275 Fuelspot 73 Princeton Street North, Chelmsford 01863 -Original Message- From: Koivu, Lisa [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 25, 2001 11:45 AM To: Multiple recipients of list ORACLE-L Subject: RE: Physical access to servers for maintenance What's wrong with telnetting in? -Original Message- From: Steven Lembark [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, September 25, 2001 11:20 AM To: Multiple recipients of list ORACLE-L Subject: Re: Physical access to servers for maintenance -- Smith, Ron L. [EMAIL PROTECTED] Our hardware people are cracking sown on access to the computer room. They have decided the DBA group can do all their work without going to the server itself. This includes Unix and NT server running both Oracle and SQL Server. We would have to use VNC Viewer and PC Anywhere. I am trying to put together a list of things we might need to do that would make remote admin difficult as well as taking longer. If you have any ideas I would appreciate it. How about Your Work? Last time I looked it's rather hard to run svrmgrl without access to the command line. So long as you don't want to start or stop the database this probably won't have any effect. Checking free disk space is also simpler with df. You can, perhaps, memorize the nubmber of blocks on every device and compare them to the free space reported by Oracle each morning. Simplest method would be to say no we don't need it now, what is the pager number of someone we can use if we do need things done? Make a point of paging them every time you need something from the shell, day or night. That person will, I'm sure, be happy to compile a list of the trivial things they've been forced to do that the DBA should have done for themselves at 3am... -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647
Re: Preventing user access
You can restrict access to db by IP address. JP On Wed 26. September 2001 16:25, you wrote: If I wish to do work on a database logging in to server itself and want to prevent users from accessing the system via network is there another way to do this if I don't want to use the enable restricted session functionality. I'm thinking there's probably a neat way to utiltise the listener process but have not figured it out. Also what If I need to work on DB over network but don't want any other users using DB what can I do to prevent their connecting? Sean :) Data Base Administrator Oracle 7.3.3, 8.0.5, 8.1.7 - NT, W2K [0%] OCP Oracle8i DBA --- End 2002 deadline =:-O [0%] OCP Oracle9i DBA Organon (Ireland) Ltd. E-mail: [EMAIL PROTECTED] [subscribed: Digest Mode] Visit: http://groups.yahoo.com/group/Oracle-OCP-DBA Nobody loves me but my mother... and she could be jivin' too. - BB King -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jan Pruner INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Preventing user access
Title: RE: Preventing user access Hi Sean, someone on the list, his or her name escapes me, suggested two listeners. One for the general users and one for dba's only. You want to kick your users out, bring down the general use listener. Clever and slick! Lisa Koivu Oracle Database Administrator Fairfield Resorts, Inc. 954-935-4117 -Original Message- From: O'Neill, Sean [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, September 26, 2001 10:25 AM To: Multiple recipients of list ORACLE-L Subject: Preventing user access If I wish to do work on a database logging in to server itself and want to prevent users from accessing the system via network is there another way to do this if I don't want to use the enable restricted session functionality. I'm thinking there's probably a neat way to utiltise the listener process but have not figured it out. Also what If I need to work on DB over network but don't want any other users using DB what can I do to prevent their connecting? Sean :) Data Base Administrator Oracle 7.3.3, 8.0.5, 8.1.7 - NT, W2K [0%] OCP Oracle8i DBA --- End 2002 deadline =:-O [0%] OCP Oracle9i DBA Organon (Ireland) Ltd. E-mail: [EMAIL PROTECTED] [subscribed: Digest Mode] Visit: http://groups.yahoo.com/group/Oracle-OCP-DBA Nobody loves me but my mother... and she could be jivin' too. - BB King -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: O'Neill, Sean INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Preventing user access
You can use Connection Manager and define rules. Although you will need to change the net services entries of the tnsnames.ora or from the names or from LDAP, just to source the client to the Connection Manager before the server itself. Or if you use TCP/IP as the protocol for Net8, you can use the file protocol.ora. In order to restrict the access you must include these two lines: tcp.validnode_checking=TRUE tcp.excluded_nodes=(ip or name,.) .or better if there two many: tcp.included_nodes (ip or name) Regards. --- O'Neill, Sean [EMAIL PROTECTED] wrote: If I wish to do work on a database logging in to server itself and want to prevent users from accessing the system via network is there another way to do this if I don't want to use the enable restricted session functionality. I'm thinking there's probably a neat way to utiltise the listener process but have not figured it out. Also what If I need to work on DB over network but don't want any other users using DB what can I do to prevent their connecting? Sean :) Data Base Administrator Oracle 7.3.3, 8.0.5, 8.1.7 - NT, W2K [0%] OCP Oracle8i DBA --- End 2002 deadline =:-O [0%] OCP Oracle9i DBA Organon (Ireland) Ltd. E-mail: [EMAIL PROTECTED] [subscribed: Digest Mode] Visit: http://groups.yahoo.com/group/Oracle-OCP-DBA Nobody loves me but my mother... and she could be jivin' too. - BB King -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: O'Neill, Sean INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Eng. Christian Trassens Senior DBA Systems Engineer [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : 541149816062 __ Do You Yahoo!? Get email alerts NEW webcam video instant messaging with Yahoo! Messenger. http://im.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christian Trassens INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Platform
I presume you mean utl_file, not dbms_file. Doesn't this need the utl_file parameter set up with the available directories - could you just check to see if this parameter includes c:\log or /log - Bill. At 05:10 26/09/01 -0800, you wrote: Hello how is it possible in PLSQL to decide on which operating system (NT/LINUX)is server running? I would like to automatically specify directory where output from dbms_file will go. On nt I need something like c:\log and on unix I would like to have something like /log . Is there any view where I can find this information about OS? Thank you for responce Ivo -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Libal, Ivo INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Intasys Billing Technologies Ltd. www.intasysbilling.com 74 Commercial Street, Commercial Quay, Leith, Edinburgh EH6 6LX tel (0)131 625 8200 fax (0)131 625 8201 email [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bill Buchan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: ANYONE OWN The Art of Computer Systems Performance Analysis
Yes...it's quite impressive looking REAL metrics -- on top of sensible heuristics -- are hard to find. -Original Message- Sent: Tuesday, September 25, 2001 8:40 PM To: Multiple recipients of list ORACLE-L Analysis Wow, I just went to read a few reviews on line and it does sound good. I wonder if being 10 years old would make a difference. There is also lots of stuff on the author's (Raj Jain) web site (http://www.cis.ohio-state.edu/~jain/). He has papers, class lectures, ... Henry -Original Message- Sent: Tuesday, September 25, 2001 7:45 PM To: Multiple recipients of list ORACLE-L Analysis LOL...ok...it's the subject-named bookit *looks* just great...and adult tuning/performance book butwanted to see if anyone on the list read it. -Original Message- Sent: Tuesday, September 25, 2001 6:25 PM To: Multiple recipients of list ORACLE-L Analysis Tec IF no_idea_what_hannibal_is_on_about() THEN please_explain(); FI Your Friend, Beavis - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, September 25, 2001 2:15 PM andIF SO do you like it? ...andIF SO.why? ELSE why not?/ end if; thanks! Ross _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Scott Shafer INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohan, Ross INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Henry Poras INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohan, Ross INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Physical access to servers for maintenance
Last time we tried an install from a remote CD it took about 4 times longer to complete. Ron -Original Message- Sent: Wednesday, September 26, 2001 9:55 AM To: Multiple recipients of list ORACLE-L It's been a while but as I remember, for WinNT 4.0, I used to use the windows network to log in to the server, put the CD-ROM in my workstation, mount that on the server as a network drive, and do the GUI install. This worked with 8.1.4. Adams, Matthew (GEA,To: Multiple recipients of list ORACLE-L 088130) [EMAIL PROTECTED] MATT.ADAMS cc: @APPL.GE.COMSubject: RE: Physical access to servers for Sent by: rootmaintenance 09/26/2001 09:45 AM Please respond to ORACLE-L Are you talking NT only or install in general? On unix all you need is a decent X-windows package for your PC (Exceed, ChameleonX, Reflection X?, etc). I've been here 3 years, installed at least 30 new systems and have never been in any of our computer rooms. -Original Message- Sent: Wednesday, September 26, 2001 9:05 AM To: Multiple recipients of list ORACLE-L OK, terminal services? I agree that install is an exception. It's nearly impossible if you aren't sitting in front of the host. -Original Message- From: Christopher Spence [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, September 26, 2001 8:45 AM To: Multiple recipients of list ORACLE-L Subject: RE: Physical access to servers for maintenance This doesn't work for NT machines, and it with Unix you cannot install 8.1.6 without X access. Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes. Christopher R. Spence Oracle DBA Phone: (978) 322-5744 Fax: (707) 885-2275 Fuelspot 73 Princeton Street North, Chelmsford 01863 -Original Message- From: Koivu, Lisa [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 25, 2001 11:45 AM To: Multiple recipients of list ORACLE-L Subject: RE: Physical access to servers for maintenance What's wrong with telnetting in? -Original Message- From: Steven Lembark [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, September 25, 2001 11:20 AM To: Multiple recipients of list ORACLE-L Subject: Re: Physical access to servers for maintenance -- Smith, Ron L. [EMAIL PROTECTED] Our hardware people are cracking sown on access to the computer room. They have decided the DBA group can do all their work without going to the server itself. This includes Unix and NT server running both Oracle and SQL Server. We would have to use VNC Viewer and PC Anywhere. I am trying to put together a list of things we might need to do that would make remote admin difficult as well as taking longer. If you have any ideas I would appreciate it. How about Your Work? Last time I looked it's rather hard to run svrmgrl without access to the command line. So long as you don't want to start or stop the database this probably won't have any effect. Checking free disk space is also simpler with df. You can, perhaps, memorize the nubmber of blocks on every device and compare them to the free space reported by Oracle each morning. Simplest method would be to say no we don't need it now, what is the pager number of someone we can use if we do need things done? Make a point of paging them every time you need something from the shell, day or night. That person will, I'm sure, be happy to compile a list of the trivial things they've been forced to do that the DBA should have done for themselves at 3am... -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647 +1 800 762 1582 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steven Lembark INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like
Re: the OT list
Hi, I think it's because they try to move more into the LDAP direction. Stefan JOE TESTA schrieb: Don't forget this list is now to be used for oracle topics only. If you want to post OT stuff, feel free to join the [EMAIL PROTECTED] ist. Although I've not seen the jokes/recipes on their yet, where are youp osters at? Obligatory oracle msg :) I see in the 9i docs, ONAMES will be desupported in a future release, any insider know when? thanks, joe - This Mail has been checked for Viruses Attention: Encrypted mails can NOT be checked! ** Diese Mail wurde auf Viren geprueft Hinweis: Verschluesselte mails koennen NICHT auf Viren geprueft werden! - -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stefan Jahnke INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: DBA assessment - slightly OT
1. What is the difference between a lock and a latch? 2. Explain what spinning is and why is it necessary? 3. What is the PL/SQL catch all exception called? 4. Where would you read about a deadlock that occurred? 5. How would you verify your data files you just backed up are not corrupt? 6. Explain what two significant things that occur when you do a BEGIN BACKUP on a tablespace. 7. Explain the use of DECODE function. 8. What is a correlated sub query? 9. Explain the snapshot too old error, and when does it commonly occur. 10. What three powerful Oracle tuning tools require timed_statistics? These are off the top of my head, I had a nice drawn up list I spent more time on, but it is at home I think. HTH, Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes. Christopher R. Spence Oracle DBA Phone: (978) 322-5744 Fax:(707) 885-2275 Fuelspot 73 Princeton Street North, Chelmsford 01863 -Original Message- Sent: Wednesday, September 26, 2001 10:30 AM To: Multiple recipients of list ORACLE-L If you were to choose 10 questions to evaluate the competency of a DBA what would they be given that the result would be their competence would be rated as of the following: - TERRIBLE (I would not let them within 100 miles of a database) - FAIR (I'd show them some basic admin, but do it myself, they've a lot to learn yet) - GOOD (I'd let them do some basic admin stuff by themselves but monitor their performance regularly) - VERY GOOD (I'd let them handle practically all admin type work and mentor them as required) - EXCELLENT (Hell, they could teach me a trick or too!) Sean :) Data Base Administrator Oracle 7.3.3, 8.0.5, 8.1.7 - NT, W2K [0%] OCP Oracle8i DBA --- End 2002 deadline =:-O [0%] OCP Oracle9i DBA Organon (Ireland) Ltd. E-mail: [EMAIL PROTECTED] [subscribed: Digest Mode] Visit: http://groups.yahoo.com/group/Oracle-OCP-DBA Nobody loves me but my mother... and she could be jivin' too. - BB King -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: O'Neill, Sean INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christopher Spence INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 tune treewalk sql statement
me too -- Jared? please get rid of him? --- Thomas, Kevin [EMAIL PROTECTED] wrote: Does anyone else keep getting this message? K. --- [EMAIL PROTECTED] - no such user here. Hi, No such user found.Please check the Mail ID. Regards Sys Admin Team : Message contains [1] file attachments DISCLAIMER: This email is bound by the terms and conditions described at http://www.subexgroup.com/mail-disclaimer.htm -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thomas, Kevin INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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!? Get email alerts NEW webcam video instant messaging with Yahoo! Messenger. http://im.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Tracing a sql statement also to include bind variables
You are right - DBMS_SUPPORT is for 7.something 8.0.5. 8i uses DBMS_SYSTEM AFAIK. List, please correct me if I'm wrong.. Mark -Original Message- Trassens Sent: Wednesday, September 26, 2001 13:55 To: Multiple recipients of list ORACLE-L I think it comes with 8.0.4. I don't know exactly. However I enclose it one copy. Regards. --- Mark Leith [EMAIL PROTECTED] wrote: WOW!! What a typo!! That should of course be *because*.. LOL.. Mark -Original Message- Sent: Wednesday, September 26, 2001 10:45 To: Multiple recipients of list ORACLE-L That is beacuase it is not DBMS_SUPPORT, it is DBMS_SYSTEM: exec sys.dbms_system.set_sql_trace_in_session(sid,serial#,TRUE|FALSE); HTH Mark -Original Message- Subramanian Sent: Wednesday, September 26, 2001 07:45 To: Multiple recipients of list ORACLE-L Dear List, I couldn't find this dbms_support.start_trace_in_session(sid,serial#,TRUE,TRUE) Platform WinNT Oracle 8.1.7 Pl let me know venkat -- On Mon, 24 Sep 2001 03:05:19 Christian Trassens wrote: Execute as sys or dba user the package dbms_system.set_ev(sid,serial#,10046,12,''); Or with oradebug: oradebug setospid OSPID of the session and then oradebug event 10046 trace name context forever level 12 Or from the user: alter session set events '10046 trace name context forever, level 12'; Or with the package dbms_support: dbms_support.start_trace_in_session(sid,serial#,TRUE,TRUE) Regards. --- [EMAIL PROTECTED] wrote: Hi All, I have to trace a sql that a user generates. I also need the bind variables. Can somebody please enlighten me??? TIA Jack = De informatie verzonden in dit e-mailbericht is vertrouwelijk en is uitsluitend bestemd voor de geadresseerde. Openbaarmaking, vermenigvuldiging, verspreiding en/of verstrekking van deze informatie aan derden is, behoudens voorafgaande schriftelijke toestemming van Ernst Young, niet toegestaan. Ernst Young staat niet in voor de juiste en volledige overbrenging van de inhoud van een verzonden e-mailbericht, noch voor tijdige ontvangst daarvan. Ernst Young kan niet garanderen dat een verzonden e-mailbericht vrij is van virussen, noch dat e-mailberichten worden overgebracht zonder inbreuk of tussenkomst van onbevoegde derden. Indien bovenstaand e-mailbericht niet aan u is gericht, verzoeken wij u vriendelijk doch dringend het e-mailbericht te retourneren aan de verzender en het origineel en eventuele kopiekn te verwijderen en te vernietigen. Ernst Young hanteert bij de uitoefening van haar werkzaamheden algemene voorwaarden, waarin een beperking van aansprakelijkheid is opgenomen. De algemene voorwaarden worden u op verzoek kosteloos toegezonden. = The information contained in this communication is confidential and is intended solely for the use of the individual or entity to whom it is addressed. You should not copy, disclose or distribute this communication without the authority of Ernst Young. Ernst Young is neither liable for the proper and complete transmission of the information contained in this communication nor for any delay in its receipt. Ernst Young does not guarantee that the integrity of this communication has been maintained nor that the communication is free of viruses, interceptions or interference. If you are not the intended recipient of this communication please return the communication to the sender and delete and destroy all copies. In carrying out its engagements, Ernst Young applies general terms and conditions, which contain a clause that limits its liability. A copy of these terms and conditions is available on request free of charge. = -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Eng. Christian Trassens Senior DBA Systems Engineer [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : 541149816062 __ Do You Yahoo!? Get email alerts NEW webcam video instant messaging with Yahoo!
RE: Performance problem with connect string (2nd attempt)
unable to open the zip files. -Original Message- From: Dharani Ravi [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, September 26, 2001 10:05 AM To: Multiple recipients of list ORACLE-L Subject: Performance problem with connect string (2nd attempt) Hi, Last week I had posted the same the question. As there are no replies, I am trying my luck once again. Pl help. Oracle Version 8.1.6 OS Solaris 8 Whenever we telnet and execute a job without connect string, the job runs within 15 minutes. However if the same job is executed with connect string (@dbname), then the same job takes 2 hours. I am enclosing a zip file which contains listener.ora and tnsnames.ora. How to solve this problem ? Thanks in advance. Dharan __ Do You Yahoo!? Get email alerts NEW webcam video instant messaging with Yahoo! Messenger. http://im.yahoo.com File: Listener.zip -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nirmal Kumar Muthu Kumaran INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 tune treewalk sql statement
I am getting it too. I thought it was only me... Thomas, Kevin wrote: Does anyone else keep getting this message? K. --- [EMAIL PROTECTED] - no such user here. Hi, No such user found.Please check the Mail ID. Regards Sys Admin Team : Message contains [1] file attachments DISCLAIMER: This email is bound by the terms and conditions described at http://www.subexgroup.com/mail-disclaimer.htm -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thomas, Kevin INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Anjan Thakuria INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Physical access to servers for maintenance
Title: RE: Physical access to servers for maintenance We keep images of the cd-roms for all current (and past) versions on a 'software depot' (unix tar files) so I only need to have CDs loaded once for any given version. We only support Oracle on Unix, no NT systems. For most versions I give the CD-s to unix admin, ask them the mount them. For 8.1.7, I was able to ZIP the image of the cd on my PC, ftp it to a sun box, unzip it, then TAR it and move it into the software depot. (and the file names all came out correctly!, suprised the %$^%$#%^ out of me!) Did the same thing with 9i. I have a PC and a dedicated HP X-Terminal (very VERY OLD) on my desk. I pretty much use PC for e-mail and other office work stuff. My X-term is my LIFE. But, I have used just about every PC X-Term emulation software on the planet at one time or another. All have worked for installing Oracle so far. But your caveat is well taken. The speed of the network would bea major factor here. My X-term is 10 Mbs ethernet to the hub and 100 mbs ethernet between hubs. Not screamingly fast, but performance is still OK. Matt [EMAIL PROTECTED] - GE Appliances The thrill is gone. -- B. B. King If the thrill is gone, then it's time to take it back. -- Meatloaf -Original Message-From: Koivu, Lisa [mailto:[EMAIL PROTECTED]]Sent: Wednesday, September 26, 2001 10:55 AMTo: Multiple recipients of list ORACLE-LSubject: RE: Physical access to servers for maintenance I meant install in general. It took forever to do it over a fairly weak network. Never went in the computer room? Really?? Cool :) But did someone physically load the cd on the host for you? Or did you run it from your pc? -Original Message- From: Adams, Matthew (GEA, 088130) [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, September 26, 2001 9:45 AM To: Multiple recipients of list ORACLE-L Subject: RE: Physical access to servers for maintenance Are you talking NT only or install in general? On unix all you need is a decent X-windows package for your PC (Exceed, ChameleonX, Reflection X?, etc). I've been here 3 years, installed at least 30 new systems and have never been in any of our computer rooms. -Original Message-From: Koivu, Lisa [mailto:[EMAIL PROTECTED]]Sent: Wednesday, September 26, 2001 9:05 AMTo: Multiple recipients of list ORACLE-LSubject: RE: Physical access to servers for maintenance OK, terminal services? I agree that install is an exception. It's nearly impossible if you aren't sitting in front of the host.
VB/Oracle question
If I was going to distribute a client VB application connecting to Oracle, would I need to also distribute the Oracle Client tools or is there a small driver package to install without all the tools? Thanks, Brian King mailto:[EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Brian King INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Controlling disk space usage
Title: RE: Controlling disk space usage Sean, I assume from your question that you are already using autoextend on your tablespaces. I personally do not use that option and therefore the chance of a tablespace expanding above available disk space never occurs. However in the event of my running a massive insert or import when I was not sure how much space would be used I might use autoextend until the creation was over and then turn autoextend off John -Original Message- From: O'Neill, Sean [mailto:[EMAIL PROTECTED]] Sent: 26 September 01 15:15 To: Multiple recipients of list ORACLE-L Subject: Controlling disk space usage Wondering what folk out there do to manage disk space usage by tablespaces. Is it common/bad practice to have MAXSIZE unlimited and/or MAX_EXENTS set to a value which if reached would be larger than disk capacity and therefore regular observation of space is required, or is there a better way to do this? Sean :) Data Base Administrator Oracle 7.3.3, 8.0.5, 8.1.7 - NT, W2K [0%] OCP Oracle8i DBA --- End 2002 deadline =:-O [0%] OCP Oracle9i DBA Organon (Ireland) Ltd. E-mail: [EMAIL PROTECTED] [subscribed: Digest Mode] Visit: http://groups.yahoo.com/group/Oracle-OCP-DBA Nobody loves me but my mother... and she could be jivin' too. - BB King -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: O'Neill, Sean INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). ** This email and any attachments may be confidential and the subject of legal professional privilege. Any disclosure, use, storage or copying of this email without the consent of the sender is strictly prohibited. Please notify the sender immediately if you are not the intended recipient and then delete the email from your inbox and do not disclose the contents to another person, use, copy or store the information in any medium. **
enabling foreign key constraints
Hi, When we do alter table table_name disable primary key cascade;..it also disable all the foreign key constraints but when we after do alter table table_name enable primary key..it does not enable foreign keys is there any syntax that we can enable all th foreign keys referencing particular table.. Thanks -Harvinder -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Harvinder Singh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: ANYONE OWN The Art of Computer Systems Performance Analysis
I *did* miss you! Obligatory Oracle Message: Anyone hear about Oracle 10i yet? -Original Message- Sent: Tuesday, September 25, 2001 10:35 PM To: Multiple recipients of list ORACLE-L Analysis Hehehe. I'll look at it. Just got back from vacation. I know you missed me... Scott SATX - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, September 25, 2001 6:45 PM LOL...ok...it's the subject-named bookit *looks* just great...and adult tuning/performance book butwanted to see if anyone on the list read it. -Original Message- Sent: Tuesday, September 25, 2001 6:25 PM To: Multiple recipients of list ORACLE-L Analysis Tec IF no_idea_what_hannibal_is_on_about() THEN please_explain(); FI Your Friend, Beavis - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, September 25, 2001 2:15 PM andIF SO do you like it? ...andIF SO.why? ELSE why not?/ end if; thanks! Ross _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Scott Shafer INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohan, Ross INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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!? Get your free @yahoo.com address at http://mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Scott Shafer INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohan, Ross INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Physical access to servers for maintenance
Title: RE: Physical access to servers for maintenance Come to think about it, access to my server room for Unix installs would be a waste of my time. We have consoles on the servers with command line interface only. Works for maintaince during downtimes when the network is out (planned downtimes) but other then that I don't use them. And even then, I usually let the Unix guys do their stuff first (since they are usually doing stuff for me:-) and by then the network is backup so I go back to my Xterm or my PC. -Original Message-From: Adams, Matthew (GEA, 088130) [mailto:[EMAIL PROTECTED]]Sent: Wednesday, September 26, 2001 9:05 AMTo: Multiple recipients of list ORACLE-LSubject: RE: Physical access to servers for maintenance We keep images of the cd-roms for all current (and past) versions on a 'software depot' (unix tar files) so I only need to have CDs loaded once for any given version. We only support Oracle on Unix, no NT systems. For most versions I give the CD-s to unix admin, ask them the mount them. For 8.1.7, I was able to ZIP the image of the cd on my PC, ftp it to a sun box, unzip it, then TAR it and move it into the software depot. (and the file names all came out correctly!, suprised the %$^%$#%^ out of me!) Did the same thing with 9i. I have a PC and a dedicated HP X-Terminal (very VERY OLD) on my desk. I pretty much use PC for e-mail and other office work stuff. My X-term is my LIFE. But, I have used just about every PC X-Term emulation software on the planet at one time or another. All have worked for installing Oracle so far. But your caveat is well taken. The speed of the network would bea major factor here. My X-term is 10 Mbs ethernet to the hub and 100 mbs ethernet between hubs. Not screamingly fast, but performance is still OK. Matt [EMAIL PROTECTED] - GE Appliances The thrill is gone. -- B. B. King If the thrill is gone, then it's time to take it back. -- Meatloaf -Original Message-From: Koivu, Lisa [mailto:[EMAIL PROTECTED]]Sent: Wednesday, September 26, 2001 10:55 AMTo: Multiple recipients of list ORACLE-LSubject: RE: Physical access to servers for maintenance I meant install in general. It took forever to do it over a fairly weak network. Never went in the computer room? Really?? Cool :) But did someone physically load the cd on the host for you? Or did you run it from your pc? -Original Message- From: Adams, Matthew (GEA, 088130) [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, September 26, 2001 9:45 AM To: Multiple recipients of list ORACLE-L Subject: RE: Physical access to servers for maintenance Are you talking NT only or install in general? On unix all you need is a decent X-windows package for your PC (Exceed, ChameleonX, Reflection X?, etc). I've been here 3 years, installed at least 30 new systems and have never been in any of our computer rooms. -Original Message-From: Koivu, Lisa [mailto:[EMAIL PROTECTED]]Sent: Wednesday, September 26, 2001 9:05 AMTo: Multiple recipients of list ORACLE-LSubject: RE: Physical access to servers for maintenance OK, terminal services? I agree that install is an exception. It's nearly impossible if you aren't sitting in front of the host.
RE: ORACLE VS. SYBASE
No guarantees as to accuracy, but I heard this story about 7 years ago from someone who said he was there. Apparently when the major Wall St. firms were deciding whether to go with Oracle or Sybase they arranged to have both companies come in and do presentations and say what special arrangements they'd be willing to offer. Sybase sent high level management who came with a list of features, explained their policies and offered a substantial discount. Oracle sent Larry Ellison who told them Oracle didn't have to offer discounts because it was obviously superior and anyone who bought Sybase was an idiot. They bought Sybase. Jay Miller -Original Message- Sent: Tuesday, September 25, 2001 9:40 AM To: Multiple recipients of list ORACLE-L -- Guy Hammond [EMAIL PROTECTED] That's about all I can be bothered to type for now. In summary, I would like to say that Sybase is a fine product for your grandmother to store her recipes in :0) Interesting to note that a good number of financial companies -- who make a living off of fast, stable databases -- use Sybase. They tend to prefer it for its combination of speed and cost of operation. None of them store recipies on it that I know of, nor do they allow their grandmothers access to the systems. -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647 +1 800 762 1582 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steven Lembark INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
dbsnmpc.log
We have one server which is generating 4+ MB daily on the dbsnmpc.log and dbsnmpw.log. This is not generated on any of our other servers which are all supposedly set up with the same standards. The alert logs look fine, but the dbsnmpc.log, dbsnmpw.log, and nmiconf.log all show errors for TNS-12545 and TNS-00515 starting at 2:31 (when cold backup on the server restarts the database) and continuing until we remove these three logs. The nmiconf.log shows warnings stating that the global dbname of the listener is already used to name the database. We have tried inserting the ip address rather than the hostname on listener.ora and on tnsnames.ora to no avail. Any suggestions would be appreciated. Sandi -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Preventing user access
Title: RE: Preventing user access -Original Message- From: O'Neill, Sean [mailto:[EMAIL PROTECTED]] If I wish to do work on a database logging in to server itself and want to prevent users from accessing the system via network is there another way to do this if I don't want to use the enable restricted session functionality. I'm thinking there's probably a neat way to utiltise the listener process but have not figured it out. Also what If I need to work on DB over network but don't want any other users using DB what can I do to prevent their connecting? As someone has said, you can restrict by IP address. Look in Net8 Administrator's Guide For Release 8.1.5, the parameters are described in Appendix C Configuration Parameters ... Protocol-Specific Parameters (PROTOCOL.ORA) protocol.EXCLUDED_NODES protocol.INVITED_NODES protocol.VALIDNODE_CHECKING
RE: How to tune treewalk sql statement
Can we block/filter whatever this message or user?? K. -Original Message- Sent: 26 September 2001 16:50 To: Multiple recipients of list ORACLE-L I am getting it too. I thought it was only me... Thomas, Kevin wrote: Does anyone else keep getting this message? K. --- [EMAIL PROTECTED] - no such user here. Hi, No such user found.Please check the Mail ID. Regards Sys Admin Team : Message contains [1] file attachments DISCLAIMER: This email is bound by the terms and conditions described at http://www.subexgroup.com/mail-disclaimer.htm -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thomas, Kevin INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Anjan Thakuria INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thomas, Kevin INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Platform
Title: RE: Platform I've also used this query: select substr (banner, 9, instr (banner, ':') - 9) as os from v$version where banner like 'TNS for %' ; Because port_string is sometimes cryptic. For example, on my 7.3.4 database on Sun Solaris, here's what I get: SQL select dbms_utility.port_string from dual ; PORT_STRING SVR4-be-7.0.0 -Original Message- From: Libal, Ivo [mailto:[EMAIL PROTECTED]] If you are interested I found the answer on metalink: select dbms_utility.port_string from dual; -Original Message- Sent: Wednesday, September 26, 2001 02:09 PM how is it possible in PLSQL to decide on which operating system (NT/LINUX)is server running? I would like to automatically specify directory where output from dbms_file will go. On nt I need something like c:\log and on unix I would like to have something like /log . Is there any view where I can find this information about OS?
Re:VB/Oracle question
Brian, You need the SQL*Net/Net80 stuff to make the connection to Oracle. Regrettably the only way I know to get that to work is to install the Oracle Client. Otherwise there is bound to be something missing. OH, BTW: you'll also need to tell the end user how to configure their ODBC connection. Dick Goulet Reply Separator Author: Brian King [EMAIL PROTECTED] Date: 9/26/2001 7:50 AM If I was going to distribute a client VB application connecting to Oracle, would I need to also distribute the Oracle Client tools or is there a small driver package to install without all the tools? Thanks, Brian King mailto:[EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Brian King INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Preventing user access
protocol.ora file is no longer supported in 9i. joe [EMAIL PROTECTED] 09/26/01 11:25AM You can use Connection Manager and define rules.Although you will need to change the net servicesentries of the tnsnames.ora or from the names or fromLDAP, just to source the client to the ConnectionManager before the server itself.Or if you use TCP/IP as the protocol for Net8, you canuse the file protocol.ora. In order to restrict theaccess you must include these two lines:tcp.validnode_checking=TRUEtcp.excluded_nodes=(ip or name,.).or better if there two many:tcp.included_nodes (ip or name)Regards.--- "O'Neill, Sean" [EMAIL PROTECTED] wrote: If I wish to do work on a database logging in to server itself and want to prevent users from accessing the system via network is there another way to do this if I don't want to use the "enable restricted session" functionality. I'm thinking there's probably a neat way to utiltise the listener process but have not figured it out. Also what If I need to work on DB over network but don't want any other users using DB what can I do to prevent their connecting? Sean :) Data Base Administrator Oracle 7.3.3, 8.0.5, 8.1.7 - NT, W2K [0%] OCP Oracle8i DBA --- End 2002 deadline =:-O [0%] OCP Oracle9i DBA Organon (Ireland) Ltd. E-mail: [EMAIL PROTECTED] [subscribed: Digest Mode] Visit: http://groups.yahoo.com/group/Oracle-OCP-DBA "Nobody loves me but my mother... and she could be jivin' too." - BB King -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: O'Neill, Sean INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).=Eng. Christian TrassensSenior DBASystems Engineer[EMAIL PROTECTED][EMAIL PROTECTED]Phone : 541149816062__Do You Yahoo!?Get email alerts NEW webcam video instant messaging with Yahoo! Messenger. http://im.yahoo.com-- Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: Christian Trassens INET: [EMAIL PROTECTED]Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
RE: VB/Oracle question
How are you connecting - if you are using odbc you will need the Oracle client software. -Original Message- Sent: Wednesday, September 26, 2001 10:50 AM To: Multiple recipients of list ORACLE-L If I was going to distribute a client VB application connecting to Oracle, would I need to also distribute the Oracle Client tools or is there a small driver package to install without all the tools? Thanks, Brian King mailto:[EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Brian King INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shaw, John B INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 resolve Dr. Watson errors on Oracle clients when printing from forms...
Hi DBA's I have been visiting a client user site that is reporting frequent Dr. Watson Application Errors when submitting report generation request from Oracle Developer 6.0 forms on Oracle 8.0.5.0.0 client machines. I observed that the same user can logon to another NT workstation and generate/print the same report successfully. I don't know if it is a Windows problem or an Oracle forms problem. The Oracle RDBMS is 8.0.5.0.0 on NT 4.0. The forms were created using Oracle Developer 6.0. The clients (NT Workstations with SP6) have the Oracle client installed. Perhaps, some of you may have addressed this problem before. I would appreciate any feedback on this problem. Thanks in advance for your time. Regards, Denmark Weatherburne Knowledge is power, but it is only useful if it is shared! _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Denmark Weatherburne INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: database link questions
This is what I eventually did and this fixed my database link problem. I could have done it like another list member suggested to use the whole edi.belkin.com in the database link name, but then I would have had to remember to do this for any future database links, so the one time alter of the global names fixed the problem. I did open a tar with Metalink and they don't seem to know the answer to why I would see us.oracle.com in the global name when service_name, db_domain, etc are all set in the init.ora. The us.oracle.com I assume was probably typed in the domain area during installation. Where it is stored for the global name to use, no one seems to know. Now onto more fun... ODBC driver connection problem with Interdev, 8.1.7 Oracle to an IIS server. Will the fun never end? Kathy -Original Message- Sent: Tuesday, September 25, 2001 6:30 PM To: Multiple recipients of list ORACLE-L Try updating directly to the global_name table: update global_name set global_name='MY_DB_NAME'; commit; Mario Alberto Ramos [EMAIL PROTECTED] 24/09/01 13:55 Can you be more specific? I am curious also. When I create a link to a database on 'xxx' it comes out 'xxx.cj.com' which is correct but I began looking around and I don't see how it is working. In our initxxx.ora file we have 'db_domain = WORLD'. In the sqlnet.ora file we have #NAMES.DEFAULT_DOMAIN = world # NAMES.DEFAULT_DOMAIN = cj.com As you can see, both are commented out. We are on Sun Solaris and I did find /etc/resolve.conf with: domain cj.com. search cj.com. Is that where it is coming from or is there some other place to look. Also, if I change the global name like: alter database rename global_name to test; Then is comes out as 'TEST.CJ.COM'. Since it is clearly ignoring my oracle parameters, it must be an OS level thing. And, since it has always worked for me, I never really questioned it. Now that Kathy has asked about it, I am sure there are many of us who are curious about it. One more thing, I couldn't find any reference to it in the installation guide. TIA, John [EMAIL PROTECTED] 09/24/01 06:30AM The extension on a database link is always the domain of the database it is created in. HTH, Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, September 21, 2001 6:16 PM I try to create a database link named Custom, it ends up as: Custom.us.oracle.com when I query the dba_db_links table. I don't want the .us.oracle.com extension. What can I do, where does this extension come from? Global Names? I see that my global name is TEST.US.ORACLE.COM Do I need to alter global names so I don't get this extension? Is there something else I can do? Thanks, Kathy Confidential This e-mail and any files transmitted with it are the property of Belkin Components and/or its affiliates, are confidential, and are intended solely for the use of the individual or entity to whom this e-mail is addressed. If you are not one of the named recipients or otherwise have reason to believe that you have received this e-mail in error, please notify the sender and delete this message immediately from your computer. Any other use, retention, dissemination, forwarding, printing or copying of this e-mail is strictly prohibited. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kathy Duret INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mario Alberto Ramos Arellano INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To
Re: Preventing user access
That's why I said Net8. On 9i the new name is Oracle Net and Oracle Net Services. Regards. --- JOE TESTA [EMAIL PROTECTED] wrote: protocol.ora file is no longer supported in 9i. joe [EMAIL PROTECTED] 09/26/01 11:25AM You can use Connection Manager and define rules. Although you will need to change the net services entries of the tnsnames.ora or from the names or from LDAP, just to source the client to the Connection Manager before the server itself. Or if you use TCP/IP as the protocol for Net8, you can use the file protocol.ora. In order to restrict the access you must include these two lines: tcp.validnode_checking=TRUE tcp.excluded_nodes=(ip or name,.) .or better if there two many: tcp.included_nodes (ip or name) Regards. --- O'Neill, Sean [EMAIL PROTECTED] wrote: If I wish to do work on a database logging in to server itself and want to prevent users from accessing the system via network is there another way to do this if I don't want to use the enable restricted session functionality. I'm thinking there's probably a neat way to utiltise the listener process but have not figured it out. Also what If I need to work on DB over network but don't want any other users using DB what can I do to prevent their connecting? Sean :) Data Base Administrator Oracle 7.3.3, 8.0.5, 8.1.7 - NT, W2K [0%] OCP Oracle8i DBA --- End 2002 deadline =:-O [0%] OCP Oracle9i DBA Organon (Ireland) Ltd. E-mail: [EMAIL PROTECTED] [subscribed: Digest Mode] Visit: http://groups.yahoo.com/group/Oracle-OCP-DBA Nobody loves me but my mother... and she could be jivin' too. - BB King -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: O'Neill, Sean INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Eng. Christian Trassens Senior DBA Systems Engineer [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : 541149816062 __ Do You Yahoo!? Get email alerts NEW webcam video instant messaging with Yahoo! Messenger. http://im.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christian Trassens INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Eng. Christian Trassens Senior DBA Systems Engineer [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : 541149816062 __ Do You Yahoo!? Get email alerts NEW webcam video instant messaging with Yahoo! Messenger. http://im.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christian Trassens INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Physical access to servers for maintenance
VNC is fantastic, it's probably better for this sort of thing that a combination of X11 and PC Anywhere. Just for fun, I was running vncserver on a Sun, and vncclient on my Win2K machine, then I started up vncserver on Win2K and fired up the vncclient for Solaris (already running in a vncserver) and looped back again onto Win2K. I have two monitors here, and I got them to both show the content of the left hand one by this technique, rather than one large desktop. Which was kinda useless, but it did adequately demonstrate to management (who were about to spend $$$ on eXceed) just how useful VNC is... Plus, it does things that X can't do, for example you can be working on a Sun, disconnect from your running session, then reconnect from another workstation, totally seamlessly (like 'screen' does on the cmd line, but with graphical apps). And you can have a dozen users doing this on the same machine, for that thin client style. Very nice indeed. g -Original Message- Sent: Wednesday, September 26, 2001 12:40 PM To: Multiple recipients of list ORACLE-L Some comments and queries interspersed below. From: Steven Lembark [EMAIL PROTECTED] Date: Tue, 25 Sep 2001 09:18:05 -0500 Subject: Re: Physical access to servers for maintenance Begin Snip Simplest method would be to say no we don't need it now, what is the pager number of someone we can use if we do need things done? Make a point of paging them every time you need something from the shell, day or night. That person will, I'm sure, be happy to compile a list of the trivial things they've been forced to do that the DBA should have done for themselves at 3am... End Snip Like your thinking on this Steven :) From: Thater, William [EMAIL PROTECTED] Date: Tue, 25 Sep 2001 10:20:42 -0400 Subject: Re: Physical access to servers for maintenance Begin snip if the server crashes and you have to restart the DB without VNC or PC Anywhere running, how do you do that? End Snip William, I would expect the Sys Admins to restart the server. The DB(s) should subsequently come up. Am I missing something in what you wish to convey? My conclusion based upon what I've read on this thread was that installs were raised as the primary flag for local physical access but that even this can be worked around if necessary. So what tools are people using for remote administration?. Perhaps to be more specific if you're on LAN but have no phyisical access to server and then same for WAN and then over PSTN. Do you use different tools for remote admin in these different scenarios, i.e. distance and bandwidth limitations force use of different tools?. Anyone any feedback on experiences of PocketDBA product?. Anyone any bad press or gotchas about VNC? Sean :) Data Base Administrator Oracle 7.3.3, 8.0.5, 8.1.7 - NT, W2K [0%] OCP Oracle8i DBA --- End 2002 deadline =:-O [0%] OCP Oracle9i DBA Organon (Ireland) Ltd. E-mail: [EMAIL PROTECTED] [subscribed: Digest Mode] Visit: http://groups.yahoo.com/group/Oracle-OCP-DBA Nobody loves me but my mother... and she could be jivin' too. - BB King -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: O'Neill, Sean INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Guy Hammond INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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*Loader Book
I will be using the book Oracle SQL*Loader The Definitive Guide to load flat files into an Oracle 8.1.5 DB. Would like to know if there are any errors / gotchas or missing information in this book that I need to be aware of? Thanks, Ken Janusz, CPIM Database Conversion Lead Sufficient Systems, Inc. Minneapolis, MN -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ken Janusz INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Tablespace fragmentation
Hi How to remove tablespace fragmentation? Export/drop/import? If I export the db and import user wise then is it solve the problem? What are the precausion should taken care when we do such activities. Thanks -Seema _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seema Singh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: How to tune treewalk sql statement
He has been dispatched with alacrity, but not necessarily sanguinarily. Jared This electronic message contains information which may be confidential, privileged or otherwise protected from disclosure. The information is intended to be used solely by the named recipient(s). If you are not a named recipient, any review, disclosure, copying, distribution or use of this transmission or its contents is prohibited. If you have received this transmission in error, please notify me immediately. Rachel Carmichael To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] wisernet100@Y cc: AHOO.COMSubject: RE: How to tune treewalk sql statement Sent by: [EMAIL PROTECTED] om 09/26/01 08:35 AM Please respond to ORACLE-L me too -- Jared? please get rid of him? --- Thomas, Kevin [EMAIL PROTECTED] wrote: Does anyone else keep getting this message? K. --- [EMAIL PROTECTED] - no such user here. Hi, No such user found.Please check the Mail ID. Regards Sys Admin Team : Message contains [1] file attachments DISCLAIMER: This email is bound by the terms and conditions described at http://www.subexgroup.com/mail-disclaimer.htm -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thomas, Kevin INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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!? Get email alerts NEW webcam video instant messaging with Yahoo! Messenger. http://im.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Physical access to servers for maintenance
Title: RE: Physical access to servers for maintenance You can use a tool such as ControlIT to connect to NT machines. Its how I do it, both from the office, and from home. How do all these people who claim you need access to the server room to do the day to day stuff provide remote support? I will be damned if I come in during the middle of the night for a database issue. -Original Message-From: Christopher Spence [mailto:[EMAIL PROTECTED]]Sent: Wednesday, September 26, 2001 5:45 AMTo: Multiple recipients of list ORACLE-LSubject: RE: Physical access to servers for maintenance This doesn't work for NT machines, and it with Unix you cannot install 8.1.6 without X access. "Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes." Christopher R. Spence Oracle DBA Phone: (978) 322-5744 Fax: (707) 885-2275 Fuelspot 73 Princeton Street North, Chelmsford 01863 -Original Message-From: Koivu, Lisa [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 25, 2001 11:45 AMTo: Multiple recipients of list ORACLE-LSubject: RE: Physical access to servers for maintenance What's wrong with telnetting in? -Original Message- From: Steven Lembark [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, September 25, 2001 11:20 AM To: Multiple recipients of list ORACLE-L Subject: Re: Physical access to servers for maintenance -- "Smith, Ron L." [EMAIL PROTECTED] Our hardware people are cracking sown on access to the computer room. They have decided the DBA group can do all their work without going to the server itself. This includes Unix and NT server running both Oracle and SQL Server. We would have to use VNC Viewer and PC Anywhere. I am trying to put together a list of things we might need to do that would make remote admin difficult as well as taking longer. If you have any ideas I would appreciate it. How about "Your Work"? Last time I looked it's rather hard to run svrmgrl without access to the command line. So long as you don't want to start or stop the database this probably won't have any effect. Checking free disk space is also simpler with "df". You can, perhaps, memorize the nubmber of blocks on every device and compare them to the free space reported by Oracle each morning. Simplest method would be to say "no we don't need it now, what is the pager number of someone we can use if we do need things done?" Make a point of paging them every time you need something from the shell, day or night. That person will, I'm sure, be happy to compile a list of the trivial things they've been forced to do that the DBA should have done for themselves at 3am... -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647 +1 800 762 1582 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steven Lembark INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 VS. SYBASE
Thanks to everyone that participated in this very informative, spirited and amusing discussion of these products, I'm wondering if we should go with MS server instead... Miriam -Original Message- Sent: Wednesday, September 26, 2001 1:01 PM To: Multiple recipients of list ORACLE-L No guarantees as to accuracy, but I heard this story about 7 years ago from someone who said he was there. Apparently when the major Wall St. firms were deciding whether to go with Oracle or Sybase they arranged to have both companies come in and do presentations and say what special arrangements they'd be willing to offer. Sybase sent high level management who came with a list of features, explained their policies and offered a substantial discount. Oracle sent Larry Ellison who told them Oracle didn't have to offer discounts because it was obviously superior and anyone who bought Sybase was an idiot. They bought Sybase. Jay Miller -Original Message- Sent: Tuesday, September 25, 2001 9:40 AM To: Multiple recipients of list ORACLE-L -- Guy Hammond [EMAIL PROTECTED] That's about all I can be bothered to type for now. In summary, I would like to say that Sybase is a fine product for your grandmother to store her recipes in :0) Interesting to note that a good number of financial companies -- who make a living off of fast, stable databases -- use Sybase. They tend to prefer it for its combination of speed and cost of operation. None of them store recipies on it that I know of, nor do they allow their grandmothers access to the systems. -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647 +1 800 762 1582 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steven Lembark INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bryan, Miriam INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Physical access to servers for maintenance
I didn't say it was perfect. I just said that it worked. (grin) If they insist on no physical contact then there are certain consequences, including network traffic being hosed during installs. This is also how I would install the client on users' workstations. Smith, Ron L. rlsmith To: Multiple recipients of list ORACLE-L @kmg.com[EMAIL PROTECTED] Sent by: rootcc: Subject: RE: Physical access to servers for maintenance 09/26/2001 11:20 AM Please respond to ORACLE-L Last time we tried an install from a remote CD it took about 4 times longer to complete. Ron -Original Message- Sent: Wednesday, September 26, 2001 9:55 AM To: Multiple recipients of list ORACLE-L It's been a while but as I remember, for WinNT 4.0, I used to use the windows network to log in to the server, put the CD-ROM in my workstation, mount that on the server as a network drive, and do the GUI install. This worked with 8.1.4. Adams, Matthew (GEA,To: Multiple recipients of list ORACLE-L 088130) [EMAIL PROTECTED] MATT.ADAMS cc: @APPL.GE.COMSubject: RE: Physical access to servers for Sent by: rootmaintenance 09/26/2001 09:45 AM Please respond to ORACLE-L Are you talking NT only or install in general? On unix all you need is a decent X-windows package for your PC (Exceed, ChameleonX, Reflection X?, etc). I've been here 3 years, installed at least 30 new systems and have never been in any of our computer rooms. -Original Message- Sent: Wednesday, September 26, 2001 9:05 AM To: Multiple recipients of list ORACLE-L OK, terminal services? I agree that install is an exception. It's nearly impossible if you aren't sitting in front of the host. -Original Message- From: Christopher Spence [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, September 26, 2001 8:45 AM To: Multiple recipients of list ORACLE-L Subject: RE: Physical access to servers for maintenance This doesn't work for NT machines, and it with Unix you cannot install 8.1.6 without X access. Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes. Christopher R. Spence Oracle DBA Phone: (978) 322-5744 Fax: (707) 885-2275 Fuelspot 73 Princeton Street North, Chelmsford 01863 -Original Message- From: Koivu, Lisa [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 25, 2001 11:45 AM To: Multiple recipients of list ORACLE-L Subject: RE: Physical access to servers for maintenance What's wrong with telnetting in? -Original Message- From: Steven Lembark [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, September 25, 2001 11:20 AM To: Multiple recipients of list ORACLE-L Subject: Re: Physical access to servers for maintenance -- Smith, Ron L. [EMAIL PROTECTED] Our hardware people are cracking sown on access to the computer room. They have decided the DBA group can do all their work without going to the server itself. This includes Unix and NT server running both Oracle and SQL Server. We would have to use VNC Viewer and PC Anywhere. I am trying to put together a list of things we might need to do that would make remote admin difficult as well as taking longer. If you have any ideas I would appreciate it. How about Your Work? Last time I looked it's rather hard to run svrmgrl without access to the command line. So long as you don't want to start or stop the database this probably won't have any effect.
ENABLING FOREIGN KEY CONSTRAINTS
Hi, When we do alter table table_name disable primary key cascade;..it also disable all the foreign key constraints but when we after do alter table table_name enable primary key..it does not enable foreign keys is there any syntax that we can enable all th foreign keys referencing particular table.. Thanks -Harvinder -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Harvinder Singh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: ANYONE OWN The Art of Computer Systems Performance
it will be installable thru the net and only run on dos 10i, which can be installed also. joe [EMAIL PROTECTED] 09/26/01 11:56AM I *did* miss you!Obligatory Oracle Message:Anyone hear about Oracle 10i yet?-Original Message-Sent: Tuesday, September 25, 2001 10:35 PMTo: Multiple recipients of list ORACLE-LAnalysisHehehe. I'll look at it. Just got back from vacation. I know you missedme...ScottSATX- Original Message -To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED]Sent: Tuesday, September 25, 2001 6:45 PM LOL...ok...it's the subject-named bookit *looks* just great...and "adult" tuning/performance book butwanted to see if anyone on the list read it. -Original Message- Sent: Tuesday, September 25, 2001 6:25 PM To: Multiple recipients of list ORACLE-L Analysis Tec IF no_idea_what_hannibal_is_on_about() THEN please_explain(); FI Your Friend, Beavis - Original Message - To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED] Sent: Tuesday, September 25, 2001 2:15 PM andIF SO do you like it? ...andIF SO."why?" ELSE "why not?"/ end if; thanks! Ross _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Scott Shafer INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohan, Ross INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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!?Get your free @yahoo.com address at http://mail.yahoo.com-- Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: Scott Shafer INET: [EMAIL PROTECTED]Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).-- Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: Mohan, Ross INET: [EMAIL PROTECTED]Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
RE: the OT list
interesting since the 9i docs basically say it wont be supported in the future, but look how long it took for server manager and connect internal to go away :) joe [EMAIL PROTECTED] 09/26/01 11:00AM Joe, I spoke to an Oracle employee about this recently (in past month). Since we utilize Names servers extensively,I would hate to redo entire infrastructure any time soon. Basically, I was told that Names will NOT go away any time soon, if at all. The idea to move to LDAP is great, but I haven't heard of a working solution yet, and apparently, neither has Oracle. Gary WeberSenior DBACharles Jones, LLC||Superior Information Services, LLC609-530-1144, ext 5529 -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of JOE TESTASent: Wednesday, September 26, 2001 9:50 AMTo: Multiple recipients of list ORACLE-LSubject: the OT list Don't forget this list is now to be used for oracle topics only. If you want to post OT stuff, feel free to join the [EMAIL PROTECTED] list. Although I've not seen the jokes/recipes on their yet, where are you posters at? Obligatory oracle msg :) I see in the 9i docs, ONAMES will be desupported in a future release, any insider know when? thanks, joe
RE: Physical access to servers for maintenance
Title: RE: Physical access to servers for maintenance Thanks Mark. Lisa -Original Message- From: Mark Leith [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, September 26, 2001 11:56 AM To: Multiple recipients of list ORACLE-L Subject: RE: Physical access to servers for maintenance Lisa, As long as there is space on the file system to upload the install files from the CDs to a temp directory on the destination server - just the same as you would if you downloaded the files from OTN- and you tar and ftp, or simply transfer for windows to the Disk1, Disk2 etc. directories, there is no need to actually mount the CD. Once you have installed - simply trash the temp directory with the set-up files in it. I do this all the time, installing from CD images stored on a networked PC that are also used to burn the CDs.. The transfer of the files may take a while, but the install will run fine as it will be running locally to the server. HTH Mark -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Koivu, Lisa Sent: Wednesday, September 26, 2001 15:55 To: Multiple recipients of list ORACLE-L Subject: RE: Physical access to servers for maintenance I meant install in general. It took forever to do it over a fairly weak network. Never went in the computer room? Really?? Cool :) But did someone physically load the cd on the host for you? Or did you run it from your pc? -Original Message- From: Adams, Matthew (GEA, 088130) [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, September 26, 2001 9:45 AM To: Multiple recipients of list ORACLE-L Subject: RE: Physical access to servers for maintenance Are you talking NT only or install in general? On unix all you need is a decent X-windows package for your PC (Exceed, ChameleonX, Reflection X?, etc). I've been here 3 years, installed at least 30 new systems and have never been in any of our computer rooms. -Original Message- From: Koivu, Lisa [ mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 26, 2001 9:05 AM To: Multiple recipients of list ORACLE-L Subject: RE: Physical access to servers for maintenance OK, terminal services? I agree that install is an exception. It's nearly impossible if you aren't sitting in front of the host. -Original Message- From: Christopher Spence [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, September 26, 2001 8:45 AM To: Multiple recipients of list ORACLE-L Subject: RE: Physical access to servers for maintenance This doesn't work for NT machines, and it with Unix you cannot install 8.1.6 without X access. Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes. Christopher R. Spence Oracle DBA Phone: (978) 322-5744 Fax: (707) 885-2275 Fuelspot 73 Princeton Street North, Chelmsford 01863 -Original Message- From: Koivu, Lisa [ mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 25, 2001 11:45 AM To: Multiple recipients of list ORACLE-L Subject: RE: Physical access to servers for maintenance What's wrong with telnetting in? -Original Message- From: Steven Lembark [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, September 25, 2001 11:20 AM To: Multiple recipients of list ORACLE-L Subject: Re: Physical access to servers for maintenance -- Smith, Ron L. [EMAIL PROTECTED] Our hardware people are cracking sown on access to the computer room. They have decided the DBA group can do all their work without going to the server itself. This includes Unix and NT server running both Oracle and SQL Server. We would have to use VNC Viewer and PC Anywhere. I am trying to put together a list of things we might need to do that would make remote admin difficult as well as taking longer. If you have any ideas I would appreciate it. How about Your Work? Last time I looked it's rather hard to run svrmgrl without access to the command line. So long as you don't want to start or stop the database this probably won't have any effect. Checking free disk space is also simpler with df. You can, perhaps, memorize the nubmber of blocks on every device and compare them to the free space reported by Oracle each morning. Simplest method would be to say no we don't need it now, what is the pager number of someone we can use if we do need things done? Make a point of paging them every time you need something from the shell, day or night. That person will, I'm sure, be happy to compile a list of the trivial things they've been forced to do that the DBA should have done for themselves at 3am... -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647 +1 800 762 1582 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steven Lembark INET:
Re:RE: Alert log from Remote client
Tony, Kindof a neat package, but I'd be looking for something that does not need a client to use it. I actually monitor my DB's from a program that then sends me the exceptions to it's capabilities. Oh, well, back to the drawing board!! Dick Goulet Reply Separator Author: Aponte; Tony [EMAIL PROTECTED] Date: 9/25/2001 8:15 AM Check out AlertView from http://www.zephyrus.com/html/products.html. It's a java utility that provides a GUI interface to remote alert.log files. I think it's still free. Tony -Original Message- Sent: Tuesday, September 25, 2001 6:15 AM To: Multiple recipients of list ORACLE-L Hi guru's Suppose that, i'm managing serveral database from a single client. In that case, how can i find out the alert log/trace files from the client. Any ideas pls. Regards, Nirmal. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nirmal Kumar Muthu Kumaran INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). !DOCTYPE HTML PUBLIC -//W3C//DTD HTML 3.2//EN HTML HEAD META HTTP-EQUIV=Content-Type CONTENT=text/html; charset=iso-8859-1 META NAME=Generator CONTENT=MS Exchange Server version 6.0.4712.0 TITLERE: Alert log from Remote client/TITLE /HEAD BODY !-- Converted from text/plain format -- PFONT SIZE=2Check out AlertView from A HREF=http://www.zephyrus.com/html/products.html;http://www.zephyrus.com/html/p roducts.html/A.nbsp; It's a java utility that provides a GUI interface to remote alert.log files.nbsp; I think it's still free./FONT/P PFONT SIZE=2Tony/FONT /P PFONT SIZE=2-Original Message-/FONT BRFONT SIZE=2From: Nirmal Kumar Muthu Kumaran [A HREF=mailto:[EMAIL PROTECTED];mailto:[EMAIL PROTECTED]/A]/FONT BRFONT SIZE=2Sent: Tuesday, September 25, 2001 6:15 AM/FONT BRFONT SIZE=2To: Multiple recipients of list ORACLE-L/FONT BRFONT SIZE=2Subject: Alert log from Remote client/FONT /P BR PFONT SIZE=2Hi guru's/FONT /P PFONT SIZE=2Suppose that, i'm managing serveral database from a single client. /FONT /P PFONT SIZE=2In that case, how can i find out the alert log/trace files from the client./FONT /P PFONT SIZE=2Any ideas pls./FONT /P PFONT SIZE=2Regards,/FONT BRFONT SIZE=2Nirmal./FONT /P BR PFONT SIZE=2-- /FONT BRFONT SIZE=2Please see the official ORACLE-L FAQ: A HREF=http://www.orafaq.com;http://www.orafaq.com/A/FONT BRFONT SIZE=2-- /FONT BRFONT SIZE=2Author: Nirmal Kumarnbsp; Muthu Kumaran/FONT BRFONT SIZE=2nbsp; INET: [EMAIL PROTECTED]/FONT /P PFONT SIZE=2Fat City Network Servicesnbsp;nbsp;nbsp; -- (858) 538-5051nbsp; FAX: (858) 538-5051/FONT BRFONT SIZE=2San Diego, Californianbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp; -- Public Internet access / Mailing Lists/FONT BRFONT SIZE=2/FON T BRFONT SIZE=2To REMOVE yourself from this mailing list, send an E-Mail message/FONT BRFONT SIZE=2to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in/FONT BRFONT SIZE=2the message BODY, include a line containing: UNSUB ORACLE-L/FONT BRFONT SIZE=2(or the name of mailing list you want to be removed from).nbsp; You may/FONT BRFONT SIZE=2also send the HELP command for other information (like subscribing)./FONT /P /BODY /HTML -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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]: Preventing user access
--- O'Neill, Sean [EMAIL PROTECTED] wrote: If I wish to do work on a database logging in to server itself and want to prevent users from accessing the system via network Wednesday, September 26, 2001, 11:25:29 AM, Christian Trassens wrote: CT You can use Connection Manager and define rules. I used CMAN for a similar purpose recently to give a coauthor access to my Oracle database via the Internet. It worked. Anyone who's interested can read all the gory details at: http://gennick.com/lock_the_door.html. Best regards, Jonathan Gennick mailto:[EMAIL PROTECTED] * 906.387.1698 http://Gennick.com * http://MichiganWaterfalls.com * http://MetalDrums.org -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jonathan Gennick INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Physical access to servers for maintenance
I use VNC a lot on Win32 platform, and it is unbearably slow. On Unix platform it is much better. Although I must say VNC uses almost no resources and it tunnel able through SSH. Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes. Christopher R. Spence Oracle DBA Phone: (978) 322-5744 Fax:(707) 885-2275 Fuelspot 73 Princeton Street North, Chelmsford 01863 -Original Message- Sent: Wednesday, September 26, 2001 12:10 PM To: Multiple recipients of list ORACLE-L VNC is fantastic, it's probably better for this sort of thing that a combination of X11 and PC Anywhere. Just for fun, I was running vncserver on a Sun, and vncclient on my Win2K machine, then I started up vncserver on Win2K and fired up the vncclient for Solaris (already running in a vncserver) and looped back again onto Win2K. I have two monitors here, and I got them to both show the content of the left hand one by this technique, rather than one large desktop. Which was kinda useless, but it did adequately demonstrate to management (who were about to spend $$$ on eXceed) just how useful VNC is... Plus, it does things that X can't do, for example you can be working on a Sun, disconnect from your running session, then reconnect from another workstation, totally seamlessly (like 'screen' does on the cmd line, but with graphical apps). And you can have a dozen users doing this on the same machine, for that thin client style. Very nice indeed. g -Original Message- Sent: Wednesday, September 26, 2001 12:40 PM To: Multiple recipients of list ORACLE-L Some comments and queries interspersed below. From: Steven Lembark [EMAIL PROTECTED] Date: Tue, 25 Sep 2001 09:18:05 -0500 Subject: Re: Physical access to servers for maintenance Begin Snip Simplest method would be to say no we don't need it now, what is the pager number of someone we can use if we do need things done? Make a point of paging them every time you need something from the shell, day or night. That person will, I'm sure, be happy to compile a list of the trivial things they've been forced to do that the DBA should have done for themselves at 3am... End Snip Like your thinking on this Steven :) From: Thater, William [EMAIL PROTECTED] Date: Tue, 25 Sep 2001 10:20:42 -0400 Subject: Re: Physical access to servers for maintenance Begin snip if the server crashes and you have to restart the DB without VNC or PC Anywhere running, how do you do that? End Snip William, I would expect the Sys Admins to restart the server. The DB(s) should subsequently come up. Am I missing something in what you wish to convey? My conclusion based upon what I've read on this thread was that installs were raised as the primary flag for local physical access but that even this can be worked around if necessary. So what tools are people using for remote administration?. Perhaps to be more specific if you're on LAN but have no phyisical access to server and then same for WAN and then over PSTN. Do you use different tools for remote admin in these different scenarios, i.e. distance and bandwidth limitations force use of different tools?. Anyone any feedback on experiences of PocketDBA product?. Anyone any bad press or gotchas about VNC? Sean :) Data Base Administrator Oracle 7.3.3, 8.0.5, 8.1.7 - NT, W2K [0%] OCP Oracle8i DBA --- End 2002 deadline =:-O [0%] OCP Oracle9i DBA Organon (Ireland) Ltd. E-mail: [EMAIL PROTECTED] [subscribed: Digest Mode] Visit: http://groups.yahoo.com/group/Oracle-OCP-DBA Nobody loves me but my mother... and she could be jivin' too. - BB King -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: O'Neill, Sean INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Guy Hammond INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other
RE: Does start with/connect by uses full table scan?
You want to make sure there is an index on the start with and connect by clauses. Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes. Christopher R. Spence Oracle DBA Phone: (978) 322-5744 Fax:(707) 885-2275 Fuelspot 73 Princeton Street North, Chelmsford 01863 -Original Message- Sent: Monday, September 24, 2001 2:36 PM To: Multiple recipients of list ORACLE-L List, Does Oracle go for full table scan or does it use indexes when we use start with/connect by clause? Thanks, Rao -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rao, Maheswara INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christopher Spence INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: ORACLE VS. SYBASE
Humm, IMHO Larry was right. Reply Separator Author: Miller; Jay [EMAIL PROTECTED] Date: 9/26/2001 9:00 AM No guarantees as to accuracy, but I heard this story about 7 years ago from someone who said he was there. Apparently when the major Wall St. firms were deciding whether to go with Oracle or Sybase they arranged to have both companies come in and do presentations and say what special arrangements they'd be willing to offer. Sybase sent high level management who came with a list of features, explained their policies and offered a substantial discount. Oracle sent Larry Ellison who told them Oracle didn't have to offer discounts because it was obviously superior and anyone who bought Sybase was an idiot. They bought Sybase. Jay Miller -Original Message- Sent: Tuesday, September 25, 2001 9:40 AM To: Multiple recipients of list ORACLE-L -- Guy Hammond [EMAIL PROTECTED] That's about all I can be bothered to type for now. In summary, I would like to say that Sybase is a fine product for your grandmother to store her recipes in :0) Interesting to note that a good number of financial companies -- who make a living off of fast, stable databases -- use Sybase. They tend to prefer it for its combination of speed and cost of operation. None of them store recipies on it that I know of, nor do they allow their grandmothers access to the systems. -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647 +1 800 762 1582 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steven Lembark INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: [Q] privilege allow user kill session???
Title: RE: [Q] privilege allow user kill session??? From: Jacques Kilchoer Write a procedure that kills the relevant session(s) and grant the user execute access to that procedure. -Original Message- From: ef 8454 [mailto:[EMAIL PROTECTED]] Thank you for the answer. Do you have sample program? The OWNER of the procedure will need the following privileges granted DIRECTLY, NOT via a role. select on sys.v_$session or select any table alter system This procedure will allow you to kill any session that has the same username as your current username. The user EXECUTING the procedure will need some way to find sid and serial# for their various sessions, to know which one to kill. (For Oracle versions that don't support execute immediate, change the procedure to use dbms_sql) create procedure kill_your_session (in_sid in sys.v_$session.sid%type, in_serial# in sys.v_$session.serial#%type) as row_count pls_integer ; begin select count (*) into row_count from v$session where username = user and sid = in_sid and serial# = in_serial# ; if row_count 0 then execute immediate 'alter system kill session ''' || to_char (in_sid) || ', ' || to_char (in_serial#) || ; end if ; end ; /
Recall: ORACLE VS. SYBASE
YTTRI Lisa would like to recall the message, ORACLE VS. SYBASE. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: YTTRI Lisa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: VB/Oracle question
You will need to distribute the drivers as well, of course, it depends on the type of interface, ADO, DAO, OLE. Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes. Christopher R. Spence Oracle DBA Phone: (978) 322-5744 Fax:(707) 885-2275 Fuelspot 73 Princeton Street North, Chelmsford 01863 -Original Message- Sent: Wednesday, September 26, 2001 11:50 AM To: Multiple recipients of list ORACLE-L If I was going to distribute a client VB application connecting to Oracle, would I need to also distribute the Oracle Client tools or is there a small driver package to install without all the tools? Thanks, Brian King mailto:[EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Brian King INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christopher Spence INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Help tuning the SGA...
Hi DBA's/Developers, I've been monitoring our production Oracle database (8.0.5.0.0) on NT with Spotlight on Oracle. I've also read some documents relating to Oracle database tuning. I have identified some components that need to be tuned. One of them is the SGA. This is the current configuration: SVRMGR show sga Total System Global Area 26808320 bytes Fixed Size 49152 bytes Variable Size18493440 bytes Database Buffers 8192000 bytes Redo Buffers73728 bytes SVRMGR The buffer hit ratio is very poor (around 70%). I've already increased the value of DB_BLOCK_BUFFERS from 1000 to 4000, but I still have not observed any significant improvement. Of course I'll try increasing the value again to see if it has an impact. However, I believe there are other related parameters that might have to be tuned as well in order to achieve the desired results. Could you experts and Gurus please give me some advice on approaching the SGA tuning process. Our client/server application might be categorized as OLTP with some batch processing near the end of the workday. These are actually summary reports of cash collections during the day which are used for reconciling the bank deposits and for internal accounting control. However, it uses some full table scans and it reads lots of rows as a result the hit ratio drops to (4%) in some cases. This is a learning process for me, so I would appreciate some helpful advice. Thanks for your time. Regards! Denmark Weatherburne Knowledge is power, but it is only useful if it is shared! This is after increasing _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Denmark Weatherburne INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: dbsnmpc.log
Try restarting the agent process on this server. If you are using scheduled jobs from OEM you will have to start these again. Remove the node from OEM. On the server stop the agent. Remove all of the .q files from ORACLE_HOME/network/agent. Then restart the agent and rediscover the node. This may help, it always helps when my agent loses his mind and does weird things. Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, September 26, 2001 12:30 PM We have one server which is generating 4+ MB daily on the dbsnmpc.log and dbsnmpw.log. This is not generated on any of our other servers which are all supposedly set up with the same standards. The alert logs look fine, but the dbsnmpc.log, dbsnmpw.log, and nmiconf.log all show errors for TNS-12545 and TNS-00515 starting at 2:31 (when cold backup on the server restarts the database) and continuing until we remove these three logs. The nmiconf.log shows warnings stating that the global dbname of the listener is already used to name the database. We have tried inserting the ip address rather than the hostname on listener.ora and on tnsnames.ora to no avail. Any suggestions would be appreciated. Sandi -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Physical access to servers for maintenance
Title: RE: Physical access to servers for maintenance Me too. We've got our 4 Production Win2k servers (2 Oracle8i servers, 2 Webservers) at a colocation facility and have used either PCAnywhere or Terminal Services to access them over the Internet for the last 9 months. The developers have never needed to have access to the servers except to put in the Cold Fusion CD to install CF Server. I've only needed access once, to load some big files that I later imported into a test db on one of the servers (actually, that's when I put in the CF CD, to save the developers a trip). Even then, I really didn't need to be there, I could have transferredmy files via PCAnywhere. If I were the SysAdmin I would have needed access a couple of times to replace failed drives, but the colocation guys took care of that. I recovered our Production db remotely after they replaced the drives. It's very nice to be able to PCAnywhere in to those boxes from home. Jack Jack C. ApplewhiteDatabase Administrator/DeveloperOCP Oracle8 DBAiNetProfit, Inc.Austin, Texaswww.iNetProfit.com[EMAIL PROTECTED](512)327-9068 -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Kimberly SmithSent: Wednesday, September 26, 2001 11:15 AMTo: Multiple recipients of list ORACLE-LSubject: RE: Physical access to servers for maintenance You can use a tool such as ControlIT to connect to NT machines. Its how I do it, both from the office, and from home. How do all these people who claim you need access to the server room to do the day to day stuff provide remote support? I will be damned if I come in during the middle of the night for a database issue.
RE: DBA assessment - slightly OT
Look them up. Its the best way to learn. -Original Message- Sent: Wednesday, September 26, 2001 11:26 AM To: Multiple recipients of list ORACLE-L Hi Christopher, So, are you going to tell the list what the answers are so that those that don't know can benefit. Martin -Original Message- Sent: 26 September 2001 16:46 To: Multiple recipients of list ORACLE-L 1. What is the difference between a lock and a latch? 2. Explain what spinning is and why is it necessary? 3. What is the PL/SQL catch all exception called? 4. Where would you read about a deadlock that occurred? 5. How would you verify your data files you just backed up are not corrupt? 6. Explain what two significant things that occur when you do a BEGIN BACKUP on a tablespace. 7. Explain the use of DECODE function. 8. What is a correlated sub query? 9. Explain the snapshot too old error, and when does it commonly occur. 10. What three powerful Oracle tuning tools require timed_statistics? These are off the top of my head, I had a nice drawn up list I spent more time on, but it is at home I think. HTH, Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes. Christopher R. Spence Oracle DBA Phone: (978) 322-5744 Fax:(707) 885-2275 Fuelspot 73 Princeton Street North, Chelmsford 01863 -Original Message- Sent: Wednesday, September 26, 2001 10:30 AM To: Multiple recipients of list ORACLE-L If you were to choose 10 questions to evaluate the competency of a DBA what would they be given that the result would be their competence would be rated as of the following: - TERRIBLE (I would not let them within 100 miles of a database) - FAIR (I'd show them some basic admin, but do it myself, they've a lot to learn yet) - GOOD (I'd let them do some basic admin stuff by themselves but monitor their performance regularly) - VERY GOOD (I'd let them handle practically all admin type work and mentor them as required) - EXCELLENT (Hell, they could teach me a trick or too!) Sean :) Data Base Administrator Oracle 7.3.3, 8.0.5, 8.1.7 - NT, W2K [0%] OCP Oracle8i DBA --- End 2002 deadline =:-O [0%] OCP Oracle9i DBA Organon (Ireland) Ltd. E-mail: [EMAIL PROTECTED] [subscribed: Digest Mode] Visit: http://groups.yahoo.com/group/Oracle-OCP-DBA Nobody loves me but my mother... and she could be jivin' too. - BB King -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: O'Neill, Sean INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christopher Spence INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Martin Kendall INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kimberly Smith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name
Re: SQL*Loader Book
You can find the information here: http://www.oreilly.com/catalog/orsqlloader/errata/ I have the same book, and think that it is a great one. Brian Ken Janusz wrote: I will be using the book Oracle SQL*Loader The Definitive Guide to load flat files into an Oracle 8.1.5 DB. Would like to know if there are any errors / gotchas or missing information in this book that I need to be aware of? Thanks, Ken Janusz, CPIM Database Conversion Lead Sufficient Systems, Inc. Minneapolis, MN -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ken Janusz INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- -- | Brian McGraw -- Oracle DBA | | Central Alabama Oracle Users Group | || | mailto:[EMAIL PROTECTED] | | http://bmcgraw.home.mindspring.com | -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Brian McGraw INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 VS. SYBASE
Stick to delimited text files and you'll be fine. Gary Weber Senior DBA Charles Jones, LLC||Superior Information Services, LLC 609-530-1144, ext 5529 -Original Message- Miriam Sent: Wednesday, September 26, 2001 1:26 PM To: Multiple recipients of list ORACLE-L Thanks to everyone that participated in this very informative, spirited and amusing discussion of these products, I'm wondering if we should go with MS server instead... Miriam -Original Message- Sent: Wednesday, September 26, 2001 1:01 PM To: Multiple recipients of list ORACLE-L No guarantees as to accuracy, but I heard this story about 7 years ago from someone who said he was there. Apparently when the major Wall St. firms were deciding whether to go with Oracle or Sybase they arranged to have both companies come in and do presentations and say what special arrangements they'd be willing to offer. Sybase sent high level management who came with a list of features, explained their policies and offered a substantial discount. Oracle sent Larry Ellison who told them Oracle didn't have to offer discounts because it was obviously superior and anyone who bought Sybase was an idiot. They bought Sybase. Jay Miller -Original Message- Sent: Tuesday, September 25, 2001 9:40 AM To: Multiple recipients of list ORACLE-L -- Guy Hammond [EMAIL PROTECTED] That's about all I can be bothered to type for now. In summary, I would like to say that Sybase is a fine product for your grandmother to store her recipes in :0) Interesting to note that a good number of financial companies -- who make a living off of fast, stable databases -- use Sybase. They tend to prefer it for its combination of speed and cost of operation. None of them store recipies on it that I know of, nor do they allow their grandmothers access to the systems. -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647 +1 800 762 1582 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steven Lembark INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bryan, Miriam INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gary Weber INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: VB/Oracle question
We will be connecting OLEDB... -Original Message- B Sent: Wednesday, September 26, 2001 12:55 PM To: Multiple recipients of list ORACLE-L How are you connecting - if you are using odbc you will need the Oracle client software. -Original Message- Sent: Wednesday, September 26, 2001 10:50 AM To: Multiple recipients of list ORACLE-L If I was going to distribute a client VB application connecting to Oracle, would I need to also distribute the Oracle Client tools or is there a small driver package to install without all the tools? Thanks, Brian King mailto:[EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Brian King INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shaw, John B INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Brian King INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Physical access to servers for maintenance
If you use Citrix on top of NT/2000 Terminal Services etc, your local drives can be mapped. I have used this to install printer drivers etc on a CD in my laptop onto the server. Local printers can be mapped too ! Steve Parker Technical Consultant LIS -- Logistics Internet Systems Ltd. E Mail: [EMAIL PROTECTED] -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).