Re: Is there an Oracle 9i on 32-bit ??
On Tue, May 27, 2003 at 03:19:40PM -0800, Leyden, Joseph wrote: Is there an Oracle 9i on 32-bit ?? http://otn.oracle.com/software/products/oracle9i/content.html Oracle9i Release 2 (9.2.0.1) Oracle9i Database Release 2 Enterprise/Standard/Personal/Client Edition for Windows Server 2003 (32-bit) New Oracle9i Database Release 2 Enterprise/Standard Edition for Linux Oracle9i Database Release 2 Enterprise/Standard/Personal Edition for Windows NT/2000/XP Oracle9i Database Release 2 Enterprise/Standard Edition for Sun SPARC Solaris (32-bit) Oracle9i Database Release 2 Enterprise Edition for Sun SPARC Solaris (64-bit) Oracle9i Database Release 2 Enterprise/Standard Edition for HP-UX Oracle9i Database Release 2 Enterprise/Standard Edition for Compaq Tru64 Oracle9i Database Release 2 Enterprise/Standard Edition for AIX Oracle9i Database Release 2 Enterprise/Standard Edition for AIX-Based 5L Systems Oracle9i Database Release 2 Enterprise Edition for Linux/390 Oracle9i Database Release 2 Client for Windows 98/NT/2000/XP I assume you mean windows, the only true and righteous path...gag. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Leyden, Joseph INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ray Stell INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: dbshut script - why shutdown so much???
On Thu, Apr 03, 2003 at 06:58:37PM -0800, Connor McDonald wrote: All this discussion on shutdown does motivate me to ask why is everyone shutting down so frequently? -- Here are my reasons this past year: oracle security patches sun kernel patches power issues static configuration change 8i upgrade, no 9i upgrade, no wait 10i... === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ray Stell INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: linux intel support matrix
On Thu, Apr 03, 2003 at 06:33:53PM -0800, Ray Stell wrote: I went to look at the matrix today and found it dramatically changed. I found only 9.2.0 and Redhat AS. All the other free linux versions are gone as well as all 8i versions. Do you find the same, maybe the webmeister is messing we me? Stupid, fat Hobbitses! My bad. I chose Linux Intel Itanium thinking they had changed it to mean Intel + Itanium. They changed it from Linux Intel to Linux IA32. The free stuff is still there. Nice Hobbitses! === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ray Stell INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: How to Determine Oracle Session ID given UNIX PID?
I like this version posted here, not my doing. Can't vouch for v7 validity, however: set lines 600 set linesize 500 set verif off col username for a15 col osuser for a15 col terminal for a8 col program for a32 col machine for a15 col type for a4 trunc col logon_time hea 'LOGON-START-TIME' for a20 col module for a10 col sid for 999 col serial# for 99 select a.username, a.osuser, --a.terminal, a.machine, a.program, type, to_char(a.logon_time,'DD-MON- HH24:MI:SS') logon_time, substr(a.module,1,10) module, a.sid, a.serial# from v$session a, sys.audit_actions b where -- a.status = 'ACTIVE' and b.action = a.command order by a.username col username form a12 col osuser form a12 col machine form a15 col sid form select vs.username, vs.sid, vs.serial#, vs.osuser, vs.machine, vs.process, vp.spid from v$session vs, v$process vp where vs.paddr = vp.addr; On Fri, Apr 04, 2003 at 03:19:24PM -0800, Sam Bootsma wrote: Oracle 7.3.4 running on AIX 4.3.3 The ps command on our AIX box shows a UNIX process taking 50% of the CPU. The PID is 89510. When I try to find the corresponding session on the Oracle database it returns no rows. Is there a way I can map the given PID on UNIX to a session id on Oracle? See below for the query I ran. SQL l 1 select sid from v$session 2* where process like '%89510%' SQL / no rows selected Thanks for your information! Sam [EMAIL PROTECTED] -- === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ray Stell INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: uregnt help
No human should have to run 8.1.6. Maybe Note:29616.1. ORA-600 [17090] Empty error stack when signalling error Note: For additional ORA-600 related information please read [NOTE:146580.1] PURPOSE: This article discusses the internal error ORA-600 [17090], whatit means and possible actions. The information here is only applicableto the versions listed and is provided only for guidance. ERROR: ORA-600 [17090][a][b][c][d][e] VERSIONS: 7.3.X to 8.1.X DESCRIPTION: The internal error [17090] refers to the condition when the kernel error handling layer is called to pop and resignal the topmost error on the errorstack and it finds the stack empty.You may see this error while running sqlldr or import on an 8.0.X database and also run into space management issues such as ORA-1658 or ORA-1654 errors for example. Reference [NOTE:1015930.102] FUNCTIONALITY: GENERIC CODE LAYER IMPACT:PROCESS FAILURE NON CORRUPTIVE - No underlying data corruption. SUGGESTIONS: This is not a fatal error. Address the underlying space management error to correct. On Thu, Apr 03, 2003 at 11:29:04AM -0800, AK wrote: I am getting following in alert log file internal error code, arguments: [17090], [], [], [], [], [], [], [] . its a hp-ux 8.1.6 system . It happens only when two user does the same thing . any idea ? -ak === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ray Stell INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
linux intel support matrix
I went to look at the matrix today and found it dramatically changed. I found only 9.2.0 and Redhat AS. All the other free linux versions are gone as well as all 8i versions. Do you find the same, maybe the webmeister is messing we me? Stupid, fat Hobbitses! === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ray Stell INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: dbshut script - shutdown or shutdown immediate
On Wed, Apr 02, 2003 at 03:43:43PM -0800, Darrell Landrum wrote: - Drives to work on busy streets exclusively - successful trips to work: over 14,000 - accidents during trips to work: 0 - still, I drive carefully -- I've always taken Jeremiah's modivation on this to be functionality. You can wait for db tasks on shutdown immediate or you can wait for recovery later. It just depends on when you want to wait and the times are not always the same. Under some circumstances, immediate may cause a much very long wait and that can be unacceptable. If you need to bring it down, don't fear abort. There are times when abort is the tool you need, not some evil twin. Oracle, by design, has the db covered, less some early v7 releases. === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ray Stell INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: sort ip addresses
On Tue, Mar 25, 2003 at 04:58:53PM -0800, Jacques Kilchoer wrote: Every Dog Has His Day! And today's mine. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Jacques, this indeed an exquisite use of owa_pattern! -- Thanks everyone, for your suggestions, very helpful. === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ray Stell INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
historical note
Old enough to remember the Osborne? PC pioneer, Adam Osborne is dead. http://story.news.yahoo.com/news?tmpl=storyncid=581e=2cid=581u=/nm/20030324/tc_nm/tech_osborne_dc === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ray Stell INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
sort ip addresses
Need a trick to sort ip addresses into numerical order. I have them stored as varchar2. If I select without a sort I get rows in order of their character value: 10.0.112.1 10.0.113.1 10.0.113.2 10.0.12.1 10.0.78.1 I'd like to order them numerically within the octets: 10.0.12.1 10.0.78.1 10.0.112.1 10.0.113.1 10.0.113.2 === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ray Stell INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: AW: Problem with netasst dbastudio
services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kulev, Milen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Tired of spam? Get advanced junk mail protection with MSN 8. http://join.msn.com/?page=features/junkmail -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Milen Pankov INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ray Stell INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: can't create database
On Mon, Mar 17, 2003 at 07:03:43AM -0800, Joe Johnson wrote: Hi, This site has a good description of how to use the ipcs and ipcrm commands to clean up these left-over memory segments following the shutdown. I've found that using the technique shown on this site minimizes the need to reboot when this problem occurs. site unseen! Hope this helps, Joe Johnson, OCP Senior Database Administrator Greenbrier Russel, Inc. Madison, Wisconsin USA Let us linger here a while in the foolishness of things -Unknown -Original Message- From: Schwerdtfeger, Christoph [mailto:[EMAIL PROTECTED] Sent: Monday, March 17, 2003 2:59 AM To: Multiple recipients of list ORACLE-L Subject: Re: can't create database Am Mit, 2003-03-12 um 21.14 schrieb [EMAIL PROTECTED]: I've had this problem on linux. Best and fastest solution: reboot the server. There is a memory issue preventing you from starting oracle. I just had it happen about 2 minutes ago on an upgrade to 9i. Reboot, and now I can start the db. -Candi On Wed, 2003-03-12 at 12:07, Schwerdtfeger, Christoph wrote: Am Mit, 2003-03-12 um 17.20 schrieb Ray Stell: On Wed, Mar 12, 2003 at 07:19:53AM -0800, Schwerdtfeger, Christoph wrote: Am Mit, 2003-03-12 um 10.28 schrieb Christoph Schwerdtfeger: Am Die, 2003-03-11 um 19.47 schrieb Alan Davey: I had the same error message on NT with Oracle 9.2 recently. The first problem was that the init_sid.ora file was created a directory different from where the db create scripts were looking for it. The second problem was that one of the init parameters was for Enterprise Edition and I was installing Standard Edition. Both problems resulted in the message of 'not connected to oracle'. Come to think of it, I don't think I've ever had a version of the DB Creation wizard work without getting some error. -- Alan Davey [EMAIL PROTECTED] 718-482-4200 x106 On 3/11/2003 12:44 PM, Stahlke, Mark [EMAIL PROTECTED] wrote: RE: LMT monitoring Is this on Linux? If yes, then it sounds like you need to install the glibc stubs patch. If no, then I don't know what the problem might be. -Original Message- From: Milen Pankov [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 11, 2003 10:00 AM To: Multiple recipients of list ORACLE-L Subject: can't create database can't create a database with oracle 8.1.7. the installation went fine, but when i start dbassist on the 2% of the database creation it tels me: not connected to oracle. any ideas? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net Hi there. I have a similiar problem with Oracle 9.2.0.1.0 under Linux (Debian, Woody, Kernel 2.4.20-686-smp). The installation worked fine - at least no error message was shown, but when I start the dbca to create a database, I get an ORA-03113. I've searched over the internet (newsgroups and webpages), but I didn't find a solution for my problem. I searched for the libc-patch, but I think it's deprecated for Oracle 9i. Many ppl said, like you, I just should generate the scripts with the wizard and create the database manually, so I did - or at least I tried. So, I just wanted to test, if the login works, but it didn't. Is startet sqlplus /nolog and tried connect SYS/change_on_install as SYSDBA (conn / as SYSDBA has the same effect, ORACLE_SID set as said in the script) and I get: Connected to an idle instance. Ok, I think this is just normal and I tried to start the database using startup nomount pfile=Correct path to init.ora; And then, all I get is an ORA-03113: end-of-file on communication channel If I try to do a conn / afterwards, I get ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exist Linux Error: 2: No such file or directory Any suggestions, what could be wrong? I installed the Enterprise Version, so it can't be an Enterprise setting ... it has to be a problem in the init.ora, right? System specs if required: Pentium II, 800 (2x - multi processor) 1024MB RAM 4GB Swap 19GB diskspace free Debian Linux (woody) Kernel 2.4.20-686-smp Any help would be appreciated. -- Christoph Schwerdtfeger [EMAIL PROTECTED] SoftConcept
Re: File Restoration/Recovery
As with all backup and recovery plans, you should test, document, and perhaps automate the process, with particular emphasis on the recovery. What your associate describes sounds like an very expensive BR plan. On Fri, Mar 14, 2003 at 07:44:01AM -0800, Gary Chambers wrote: All... A developer working on a Solaris 2.6 server running Oracle 7.3.4 desires a nightly backup (by simply copying them to a backup directory) of the datafiles of an active instance. I explain that it will be a waste of tape because the files will be corrupt and useless. He counters, As long as these files are there, irrespective of their state, oracle [sic] provides the tools to restore the skeleton database based on these files. Will this be the case? I understand that there will [most likely] be some loss of data, but will Oracle fix itself to a point where it's useful again? TIA Gary Chambers //-- // Lucent Technologies ITO/Servers/Unix // Senior Unix System Administrator // 4 Robbins Road, Westford, MA 01886 // 978-399-0481 / 888-480-6924 (Pager) // Nothing fancy and nothing Microsoft //-- -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gary Chambers INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ray Stell INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
redhat as/es/ws
Is there any hint from oracle support on these new offerings: Raleigh, NC -- March 12, 2003 -- Red Hat, Inc. (Nasdaq:RHAT), the world's premier open source and Linux provider, announced the availability of two new enterprise offerings: Red Hat Enterprise Linux ES and Red Hat Enterprise Linux WS. Designed to be 100% compatible with successful Red Hat Enterprise Linux AS (Advanced Server), the new Red Hat solutions enable organizations to deploy complete company-wide Linux solutions, from the corporate workstations to the datacenter. === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ray Stell INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: TAR and Linux info
On Wed, Mar 12, 2003 at 04:48:42AM -0800, Ron Rogers wrote: List, OS RedHat 7.3 Oeacle 8.1.7 rel3 I have had a disk failure on my test box and a datafile needs to be recovered from my tape backup. The tape contains 6 large datafiles and I get errors after reading the first one. Does anyone know the linux FTP option to --ignore-read-errors? The man I assume you mean tar option? I use gnu tar: gtar --help | grep fail --ignore-failed-read do not exit with nonzero on unreadable files command does not list it. I feel that there might be a bad section of tape and I would like to skip it until the next file header. I am in the process of exporting the data by month from the production server to reload into a recreated datafile if I can't get the tape to work. I would prefer to use the tape restore because the data needed is 3 GIG and will take a long time to exp/imp. I guess this is what you get when you use scrounged equipment to make a test box to improve your knowledge. It also tests your backup/restore equipment. Thanks, Ron -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ray Stell INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: can't create database
On Wed, Mar 12, 2003 at 07:19:53AM -0800, Schwerdtfeger, Christoph wrote: Am Mit, 2003-03-12 um 10.28 schrieb Christoph Schwerdtfeger: Am Die, 2003-03-11 um 19.47 schrieb Alan Davey: I had the same error message on NT with Oracle 9.2 recently. The first problem was that the init_sid.ora file was created a directory different from where the db create scripts were looking for it. The second problem was that one of the init parameters was for Enterprise Edition and I was installing Standard Edition. Both problems resulted in the message of 'not connected to oracle'. Come to think of it, I don't think I've ever had a version of the DB Creation wizard work without getting some error. -- Alan Davey [EMAIL PROTECTED] 718-482-4200 x106 On 3/11/2003 12:44 PM, Stahlke, Mark [EMAIL PROTECTED] wrote: RE: LMT monitoring Is this on Linux? If yes, then it sounds like you need to install the glibc stubs patch. If no, then I don't know what the problem might be. -Original Message- From: Milen Pankov [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 11, 2003 10:00 AM To: Multiple recipients of list ORACLE-L Subject: can't create database can't create a database with oracle 8.1.7. the installation went fine, but when i start dbassist on the 2% of the database creation it tels me: not connected to oracle. any ideas? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net Hi there. I have a similiar problem with Oracle 9.2.0.1.0 under Linux (Debian, Woody, Kernel 2.4.20-686-smp). The installation worked fine - at least no error message was shown, but when I start the dbca to create a database, I get an ORA-03113. I've searched over the internet (newsgroups and webpages), but I didn't find a solution for my problem. I searched for the libc-patch, but I think it's deprecated for Oracle 9i. Many ppl said, like you, I just should generate the scripts with the wizard and create the database manually, so I did - or at least I tried. So, I just wanted to test, if the login works, but it didn't. Is startet sqlplus /nolog and tried connect SYS/change_on_install as SYSDBA (conn / as SYSDBA has the same effect, ORACLE_SID set as said in the script) and I get: Connected to an idle instance. Ok, I think this is just normal and I tried to start the database using startup nomount pfile=Correct path to init.ora; And then, all I get is an ORA-03113: end-of-file on communication channel If I try to do a conn / afterwards, I get ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exist Linux Error: 2: No such file or directory Any suggestions, what could be wrong? I installed the Enterprise Version, so it can't be an Enterprise setting ... it has to be a problem in the init.ora, right? System specs if required: Pentium II, 800 (2x - multi processor) 1024MB RAM 4GB Swap 19GB diskspace free Debian Linux (woody) Kernel 2.4.20-686-smp Any help would be appreciated. -- Christoph Schwerdtfeger [EMAIL PROTECTED] SoftConcept GmbH Borriesstrasse 35 D-32257 B?nde Tel:(05223) 4970-20 E-Mail: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net Ok, I just deinstalled Oracle 9i and installed 8.1.7 which ran - after applying the patch - without any problems ... dunno why. Maybe I should try to apply the 8.1.7-glibc patch to the 9i? Try Oracle 9.2.0. I have installed it on many linux platforms without any tricks. I think you said you were using 9.0.x. I never had any desire to go there, so I don't know what may be at issue. -- Christoph Schwerdtfeger [EMAIL PROTECTED] SoftConcept GmbH Borriesstrasse 35 D-32257 B?nde Tel:(05223) 4970-20 E-Mail: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Schwerdtfeger, Christop INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ray Stell INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California
Re: can't create database
On Wed, Mar 12, 2003 at 12:44:07PM -0800, [EMAIL PROTECTED] wrote: I run into this every time I stop 9.2 on Linux. No need to reboot. Just use ipcrm to remove the offending SHM segments. If you don't know which ones, use ORADEBUG to find the segments you shouldn't remove from other running databases. ipcs will tell you the id numbers to feed to ipcrm: $ ipcs -- Shared Memory Segments keyshmid owner perms bytes nattch status 0x1fa75ea8 2588672oracle64051687424 0 -- Semaphore Arrays keysemid owner perms nsems status -- Message Queues keymsqid owner perms used-bytes messages $ ipcrm shm 2588672 resource(s) deleted $ ipcs -- Shared Memory Segments keyshmid owner perms bytes nattch status -- Semaphore Arrays keysemid owner perms nsems status -- Message Queues keymsqid owner perms used-bytes messages Or just shutdown all instances and remove any SHM owned by Oracle. Probably a bug, but I haven't checked into it yet. Jared Boyle Candi [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 03/12/2003 09:44 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re: can't create database I've had this problem on linux. Best and fastest solution: reboot the server. There is a memory issue preventing you from starting oracle. I just had it happen about 2 minutes ago on an upgrade to 9i. Reboot, and now I can start the db. -Candi On Wed, 2003-03-12 at 12:07, Schwerdtfeger, Christoph wrote: Am Mit, 2003-03-12 um 17.20 schrieb Ray Stell: On Wed, Mar 12, 2003 at 07:19:53AM -0800, Schwerdtfeger, Christoph wrote: Am Mit, 2003-03-12 um 10.28 schrieb Christoph Schwerdtfeger: Am Die, 2003-03-11 um 19.47 schrieb Alan Davey: I had the same error message on NT with Oracle 9.2 recently. The first problem was that the init_sid.ora file was created a directory different from where the db create scripts were looking for it. The second problem was that one of the init parameters was for Enterprise Edition and I was installing Standard Edition. Both problems resulted in the message of 'not connected to oracle'. Come to think of it, I don't think I've ever had a version of the DB Creation wizard work without getting some error. -- Alan Davey [EMAIL PROTECTED] 718-482-4200 x106 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ray Stell INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Oracle Development Suite for Linux?
On Mon, Mar 10, 2003 at 08:28:50PM -0800, Charles Hart wrote: I installed 9.2 on redhat 8.0 with great luck. I installed on a 700 PC with 756 megs of memory. I was using forms 6i running on NT client and could not tell when I was pointed at this instance verus one running on a HP machine. The document I found that was helpful in the install was http://otn.oracle.com/tech/linux/pdf/installtips_final.pdf I believe the real problems where with 8i on a 2.4 kernel. There is a miss-match is the glibc versions used for the kernel and oracle. What a mess. This seemed to work on 8.1.7-rh7.1 combination. rh7.1 is the last free version in the support matrix if that matters. http://www.tldp.org/HOWTO/Oracle8-on-RH7X-HOWTO-3.html On an error with a 9.0 install: Error when invoking /9.0/plsql/lib/ins_plsql.mk Doc ID: 197301.995 From: Alex Andriyashchenko [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Oracle Development Suite for Linux? Date: Mon, 10 Mar 2003 12:24:01 -0800 Hello List, Has somebody had any luck or problems to install Oracle development suite v9.0.2 under RH Linux? How good it is there now? I found that previous versions run much better under Windows. Thank you for your help. -- Best regards, Alex mailto:[EMAIL PROTECTED] __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Alex Andriyashchenko INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ The new MSN 8: smart spam protection and 2 months FREE* http://join.msn.com/?page=features/junkmail -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Charles Hart INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ray Stell INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: can't create database
On Tue, Mar 11, 2003 at 09:00:09AM -0800, Milen Pankov wrote: RE: LMT monitoringcan't create a database with oracle 8.1.7. the installation went fine, but when i start dbassist on the 2% of the database creation it tels me: not connected to oracle. any ideas? -- look in the alert log === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ray Stell INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Statistics on SYS?
I remember it was noted here that dbms_stats.gather_database_stats was busted in 8i, it went about attacking system ts. Is that fixed in 9.2.0.2? On Fri, Feb 28, 2003 at 11:16:17AM -0800, DENNIS WILLIAMS wrote: Chuck - Don't do it man! People have had very bad problems due to this. Dennis Williams DBA, 40%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, February 28, 2003 11:09 AM To: Multiple recipients of list ORACLE-L What's the current recommendation for gathering statistics on system schema objects like SYS, and OUTLN? Are they still saying not to do it? I am on 8.1.7. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Chuck Hamilton INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ray Stell INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Oracle unauthenticated remote system compromise (
gain control. Any arbitrary code supplied by an attacker would execute with the same privileges as the user running the service; this account is typically Oracle on linux/unix based platforms and Local System on Windows based operating systems such as NT/2000/XP. As such this allows for a complete compromise of the data stored in the database and possibly a complete compromise of the operating system. Fix Information *** NGSSoftware alerted Oracle to this vulnerability on 30th September 2002. Oracle has developed a patch which is available from http://otn.oracle.com/deploy/security/pdf/2003alert50.pdf A check for these issues has been added to NGSSQuirreL for Oracle, a comprehensive automated vulnerability assessment tool for Oracle Database Servers of which more information is available from the NGSSite http://www.ngssoftware.com/software/squirrelfororacle.html Further Information *** For further information about the scope and effects of buffer overflows, please see http://www.ngssoftware.com/papers/non-stack-bo-windows.pdf http://www.ngssoftware.com/papers/ntbufferoverflow.html http://www.ngssoftware.com/papers/bufferoverflowpaper.rtf http://www.ngssoftware.com/papers/unicodebo.pdf About NGSSoftware * NGSSoftware design, research and develop intelligent, advanced application security assessment scanners. Based in the United Kingdom, NGSSoftware have offices in the South of London and the East Coast of Scotland. NGSSoftware's sister company NGSConsulting, offers best of breed security consulting services, specialising in application, host and network security assessments. http://www.ngssoftware.com/ http://www.ngsconsulting.com/ Telephone +44 208 401 0070 Fax +44 208 401 0076 [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joan Hsieh INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ray Stell INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: yapp_pack.zip
On Thu, Feb 20, 2003 at 09:33:52AM -0800, Bj?rn Engsig wrote: Try yappack:-) nope, yapppack works /Bj?rn. Ray Stell wrote: google can't find yapp_pack.zip, where did you find it? On Wed, Feb 19, 2003 at 12:50:20PM -0800, Chris Stephens wrote: List, I've recently run this EXTREMELY useful set of scripts from miracle A/S to chart various info from my statspack snapshots. They work without modification on 8.1.7 but not on 9.2. I was just wondering (before I attempt to modify myself) if anyone had updated these scripts to work against the 9.2 statspack tables. Thanks, Chris -- Bj?rn Engsig, Miracle A/S Member of Oak Table Network http://www.oaktable.net [EMAIL PROTECTED] - http://MiracleAS.dk -- === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ray Stell INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Programming languages that make DBA's lives easier
On Wed, Feb 19, 2003 at 06:08:53AM -0800, Stephen Lee wrote: Klingon. so you can speak to the sysadmins... -Original Message- If you had to choose a programming language in which to write a program or application in which you wished to conceal your intellectual property, which would you use? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ray Stell INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Service startup on Windows 2000 fails
On Wed, Feb 19, 2003 at 06:08:54AM -0800, Koivu, Lisa wrote: -- tell the sysadmin to look in the event log for system, apps, and security. Probably some hints in there. === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ray Stell INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Service startup on Windows 2000 fails
- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ray Stell INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: yapp_pack.zip
google can't find yapp_pack.zip, where did you find it? On Wed, Feb 19, 2003 at 12:50:20PM -0800, Chris Stephens wrote: List, I've recently run this EXTREMELY useful set of scripts from miracle A/S to chart various info from my statspack snapshots. They work without modification on 8.1.7 but not on 9.2. I was just wondering (before I attempt to modify myself) if anyone had updated these scripts to work against the 9.2 statspack tables. Thanks, Chris -- === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ray Stell INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Programming languages that make DBA's lives easier
On Tue, Feb 18, 2003 at 12:23:49PM -0800, [EMAIL PROTECTED] wrote: No offense By definition there must be an offense in a holy war! but I have noticed in the various Unix/Oracle shops I have worked that more sys. admins. and Unix types knew korn shell prog. and Java then Perl. -Original Message- Sent: Tuesday, February 18, 2003 12:20 PM To: Multiple recipients of list ORACLE-L Let the Holy Wars begin... My choice: korn shell perl pl/sql Ron Thomas Hypercom, Inc [EMAIL PROTECTED] Each new user of a new system uncovers a new class of bugs. -- Kernighan [EMAIL PROTECTED] Sent by: To: [EMAIL PROTECTED] [EMAIL PROTECTED] cc: Subject: Programming languages that make DBA's lives easier 02/18/2003 09:56 AM Please respond to ORACLE-L On top of learning Oracle, which programming languages would also benefit some1 learning Oracle? Perl? Java? How would these languages be used? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ron Thomas INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ray Stell INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
alert #51 more detail
- Forwarded message from NGSSoftware Insight Security Research [EMAIL PROTECTED] - Date: Mon, 17 Feb 2003 14:09:56 -0800 To: [EMAIL PROTECTED] X-Mailer: Microsoft Outlook Express 5.50.4807.1700 NGSSoftware Insight Security Research Advisory Name:Oracle unauthenticated remote system compromise Systems Affected: All platforms; Oracle9i Database Release 2, 9i Release 1, 8i, 8.1.7, 8.0.6 Severity: Critical Risk Category: Remote System Buffer Overrun Vendor URL: http://www.oracle.com Author: Mark Litchfield ([EMAIL PROTECTED]) Date: 16th February 2003 Advisory number: #NISR16022003a Description *** Oracle is the leader in the database market with a 54% market share lead under ERP (Enterprise Resource Planning). The database server is vulnerable to a remotely exploitable buffer overflow vulnerability. What exacerbates this problem is that no valid User ID or password is required by an attacker. Details *** There is a remotely exploitable buffer overflow vulnerability in the authentication process with the Oracle Database Server. By supplying an overly long username when attempting to log onto the database server an attacker can overflow a stack based buffer overwriting the saved return address. Any arbitrary code supplied by an attacker would execute with the same privileges as the user running the service; this account is typically Oracle on linux/unix based platforms and Local System on Windows based operating systems such as NT/2000/XP. As such this allows for a complete compromise of the data stored in the database and possibly a complete compromise of the operating system. As most client applications for Oracle will tuncate the length of the username that can be supplied to the database an attacker would need to write their own Oracle Authenticator to exploit this issue. That said, NGSSoftware has found one client application that will allow longer usernames so to test if you are vulnerable to this issue, use the LOADPSP utility usually found in bin directory found under the OracleHomeInstallDirectory. On Windows, for example, run: C:\ora9ias\BINloadpsp -name -user LONGUSERNAME/tiger@iasdb myfile Fix Information *** NGSSoftware alerted Oracle to this vulnerability on 30th September 2002. Oracle has reviewed the code and created a patch which is available from: http://otn.oracle.com/deploy/security/pdf/2003alert51.pdf NGSSoftware advise Oracle database customers to review and install the patch as a matter of urgency. A check for these issues has been added to NGSSQuirreL for Oracle, a comprehensive automated vulnerability assessment tool for Oracle Database Servers of which more information is available from the NGSSite http://www.ngssoftware.com/software/squirrelfororacle.html It is further recommend that Oracle DBAs have their network/firewall administrators ensure that the database server is protected from Internet sourced traffic. Further Information *** For further information about the scope and effects of buffer overflows, please see http://www.ngssoftware.com/papers/non-stack-bo-windows.pdf http://www.ngssoftware.com/papers/ntbufferoverflow.html http://www.ngssoftware.com/papers/bufferoverflowpaper.rtf http://www.ngssoftware.com/papers/unicodebo.pdf About NGSSoftware * NGSSoftware design, research and develop intelligent, advanced application security assessment scanners. Based in the United Kingdom, NGSSoftware have offices in the South of London and the East Coast of Scotland. NGSSoftware's sister company NGSConsulting, offers best of breed security consulting services, specialising in application, host and network security assessments. http://www.ngssoftware.com/ http://www.ngsconsulting.com/ Telephone +44 208 401 0070 Fax +44 208 401 0076 [EMAIL PROTECTED] - End forwarded message - -- === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ray Stell INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
[openb@customcommunications.com: Rethinking database strategies]
That's it, I'm mired in proprietary systems. I've never heard it called mired before. ;) - Forwarded message from Open [EMAIL PROTECTED] - Date: Sat, 15 Feb 2003 20:21:52 -0500 February 14, 2003 How do you hold on to your career in the present economy? Ditch Great Expectations and bring in Great Results. Championing this mantra is Marten Mickos, MySQL AB CEO, who this week presents his 10 good reasons to re-think your company's database strategy and move to Open Source. From database experts over to Linux audioscenti: We turn to Franco Vitaliano, who can show you what technology to use for sound immersion worthy of a cyberstadium death match. This week, Vitaliano lures you into his hardcore gaming world in a report on how his left-ear, right-ear experience carried a sound explosion of doom, gloom, and heart-stopping crescendos. And coming soon to a datacenter near you, get ready for benchmarks of the next generation of LTO and Super AIT tape drives later this month. Is a TB/hr in your future? Now, a reminder to our readers: COPY our articles provided you attribute the Open articles to us in their unaltered state. But don't try to sell something with them without asking us first. You'll now find that our copyright notice proclaims Some Rights Reserved with our recent adoption of a Creative Commons license for noncommercial use. Just click http://www.open-mag.com/6175365400.htm to go straight to the subscriber home page and story links. And remember to send a copy to your friends mired in proprietary systems. Regards, The editors of Open magazine To unsubscribe just click http://www.open-mag.com/unsubscribe.htm - End forwarded message - === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ray Stell INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: 02/11/2003 security alerts
I downloaded some of these interim patches. Fortunately for me, the software needed to apply the patch is not included in the distribution. The readme points to Oracle9i Data Server Interim Patch Installation (OPatch) Doc ID: 189489.1, which says: An Interim Patch is tested by itself but no system regression testing is done until it is included in the next Patch Set. Because of this, it is highly recommended that all customers needing bug fixes wait for a Patch Set or product release that includes the fix. and The fix in each Interim Patch is a separate and unique branch off the base code line and does not automatically include other fixes made since the last baseline. Oracle does this to minimize the risk that a patch will have unexpected side effects. Because of this it is possible that a particular Interim Patch could cancel out a previously installed Interim Patch. I find this approach to system security reprehensible. 1. I count 6 outstanding security related patches since the last patchset, 9.2.0.2. 2. I don't believe there will be a patchset beyond 8.1.7.4 and there are outstanding holes. That means I have to apply the one-off, untested patches to production services. 3. There is no point in releasing the advisory if there is no action that they suggest you take. 4. When do you know when you need to apply a interim security patch? Would that be before or after the system is hacked? Oracle Corp.: You take the blue pill and the story ends. You wake in your bed and you believe whatever you want to believe. Have a nice weekend. On Thu, Feb 13, 2003 at 02:11:48PM -0800, Ray Stell wrote: http://otn.oracle.com/deploy/security/alerts.htm === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ray Stell INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
02/11/2003 security alerts
http://otn.oracle.com/deploy/security/alerts.htm PDF Two Security Vulnerabilities in Oracle9i Application ServerAlert #52, Rev 1, 11 February 2003 Patches are available on Metalink. PDF Buffer Overflow in ORACLE.EXE binary of Oracle9i Database ServerAlert #51, Rev 1, 11 Feburary 2003 Patches are available on Metalink. PDF Buffer Overflow in TO_TIMESTAMP_TZ function of Oracle9i Database ServerAlert #50, Rev 1, 11 February 2003 Patches are available on Metalink. PDF Buffer Overflow in TZ_OFFSET function of Oracle9i Database ServerAlert #49, Rev 1, 11 February 2003 Patches are available on Metalink. PDF Buffer Overflow in DIRECTORY parameter of Oracle9i Database ServerAlert #48, Rev 1, 11 February 2003 Patches are available on Metalink. I feel unbreakable! === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ray Stell INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: multiple oracle homes
On Thu, Feb 06, 2003 at 05:08:55AM -0800, Ray Stell wrote: Where is it well documented how to install multiple server versions, 8i and 9i, on the same unix server? -- Thanks for you replies. I've never tried this before and it seems like there are two different approaches on the surface: 1. use two different userids, ora817 and ora920, to do the install. This seems stupid, since it replicates the product directory structure and oraInventory stuff under different ownership. This might be safer since it is like running one version in that everything is seperate, but maybe there are operational issues to not using the oracle userid. Seems like there may be a gotcha waiting in the wings. Like maybe you can't run the same listener for both, or worse. 2. use the same oracle userid for both installs and change the environment vars as needed. Seems like you could damage the first install if you made a mistake. Also, it seems like in a stressful failure situation you don't want to have to think about who's on first? I don't know, third base. Are both paths valid? === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ray Stell INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: multiple oracle homes
On Fri, Feb 07, 2003 at 07:54:24AM -0800, DENNIS WILLIAMS wrote: Ray - My 2 cents worth. Don't ever use another username besides Oracle. Had a bad experience :-) Would you mind expanding on that, other people say the multiple userid idea works for them. They may be surprised one day, I can imagine. I can imagine blowing one's foot off the other way, also. Thanks. === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ray Stell INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: multiple oracle homes
On Fri, Feb 07, 2003 at 11:36:36AM -0800, Scott Stefick wrote: I tend to agree also, just because of confusion. We are running on one server, 817 (1 instance), 9201 (1 instance), 9iASRel 2 (1 instance) and on the second server we have 817 (2 instances), 9201 (1 instance), 9iAS Ver 102 (1 instance). So at first we tried different user names: oracle8i (817 instances) oracle9i (9201 instances) oraias (9iAS Ver 102) ora9ias (9iAS Rel 2) Well, it seems like it could be confusing either way, you gotta remember one thing or the other and get it right. Could be fun at crunch time. I'm more concerned about the hidden gotchas of not using the oracle id. I suspect the Oracle Corp devel comment about assuming the oracle userid is a very strong one. I'll check the docs ;) This just got too confusing, OK, I'll go that way. However, if I don't get the env right, I'm pretty sure I can trash some of the software already installed. What are the critical vars: ORACLE_HOME ORACLE_BASE ORACLE_SID PATH LD_LIBRARY_PATH LD_RUN_PATH Please help me to not mess up my weekend! Thanks. === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ray Stell INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
multiple oracle homes
Where is it well documented how to install multiple server versions, 8i and 9i, on the same unix server? === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ray Stell INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: 10046 Tracing ...
On Wed, Jan 29, 2003 at 11:24:07AM -0800, Jamadagni, Rajendra wrote: Has anyone used ftp://oracle-ftp.oracle.com/apps/patchsets/AOL/SCRIPTS/PERFORMANCE/TRCA.zip yet? I found it today and seems to be a nice utility. Sweet ... and it works even if you are not running Oracle apps. nice metalike article on it: TRCANLZR.sql - Trace Analyzer Interpreting Raw SQL Traces generated by EVENT 10046 Carlos Sierra Apps Engineering Team Oracle Support January 2003 === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ray Stell INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: RE: RE: dumping microsoft desktop?
BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Oracle 9.2.0.1/2 on Mandrake 9 - solved
Oracle Corp. finds the checksum concept to be alien. They actually posted these words to me in a tar at metalink, We don't support servers that are installed via download from otn. I guess network computing really is dead. ;) On Thu, Nov 14, 2002 at 07:54:27AM -0800, Boris Dali wrote: Ray, right on target! After looking for disk errors in dmesg output, /var/log/messages to no avail, I finally uninstalled the whole 9.2 OH last night, re-downloaded/re-burned/re-... and this time installation of both 9.2.0.1 and a patch went with no glitches. Apparently Disk2 was corrupted/missing files/??? on downloading/burning/unpacking, but what surprised me the most is that I didn't get any errors at gunzip/cpio stage, which I always thought of as a good indication that software on CDs is valid. This assumption cost me week and a half of hopeless tries to make it work... On the bright side, some .o, .so etc. files I see in OUI during installation look painfully familiar... Thanks a lot for you help. --- Ray Stell [EMAIL PROTECTED] wrote: On Tue, Nov 12, 2002 at 01:50:52PM -0800 __ Post your free ad now! http://personals.yahoo.ca -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boris Dali INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Oracle 9.2.0.1/2 on Mandrake 9
On Tue, Nov 12, 2002 at 01:50:52PM -0800, Boris Dali wrote: I guess disk explanation is the most logical one to assume, but I've no idea how to confirm and overcome it. As I mentioned I re-installed it in different combinations multiple times. Would this file always go the same place on disk (say same bad sector)? not likely, and you would probably get i/o errors at other times on other files. One interesting thing I've noticed after comparing your ls -l output with mine is that all other 4 image files in this directory are dated way back to 2000 timeframe, whereas credits.gif has a time stamp of yestarday (day I tried the installation last time). I can view the file with the browser, however. What does it tell me? I'm not sure. I guess it is possible that the timestamp did not get copied yet and the failure interupted. I wonder if the cd is bad and the msg is deceiving. That would explain why it fails at the same file during each install. Maybe it isn't the write, but the associated read of the cd and OUI is being creative in the msg. Sounds like a long shot. Try to copy the cd files in some other fashion like dd. Maybe something will float to the surface. --- Ray Stell [EMAIL PROTECTED] wrote: On Tue, Nov 12, 2002 at 10:53:37AM -0800, Boris Dali wrote: Hope not everybody is off to OOW :( Did anybody get the above combo working? I know that I have installed Oracle 9.2.0.1 on Mandrake 9 twice on marginal machines without any such behavior. Could you have gotten an i/o error on the disk? # pwd /db03/app/oracle/product/9.2.0/wwg/admin/images [root@haglid images]# ls -l credits.gif -rw-r--r--1 oracle oinstall 181222 Jul 12 2000 credits.gif I was just about to patch them, so I am nervous about getting to 9.2.0.2, hope to do that today. === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Post your free ad now! http://personals.yahoo.ca -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boris Dali INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
oracle cluster file system
I was listening to a linux q and a session by Wim Coekaerts: http://www.oracle.com/oracleworld/online/sanfrancisco/index.html?chats.html He is questioned about the oracle cluster filesystem for linux. He said it was available as an rpm at otn. Has anyone had a chance to see this up front? I had never heard of the effort. === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
dumping microsoft desktop?
Has anyone ever gone with linux desktop support? I don't mean for geeks, I mean at an enterprise level? === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Oracle 9.2.0.1/2 on Mandrake 9
On Tue, Nov 12, 2002 at 10:53:37AM -0800, Boris Dali wrote: Hope not everybody is off to OOW :( Did anybody get the above combo working? I know that I have installed Oracle 9.2.0.1 on Mandrake 9 twice on marginal machines without any such behavior. Could you have gotten an i/o error on the disk? # pwd /db03/app/oracle/product/9.2.0/wwg/admin/images [root@haglid images]# ls -l credits.gif -rw-r--r--1 oracle oinstall 181222 Jul 12 2000 credits.gif I was just about to patch them, so I am nervous about getting to 9.2.0.2, hope to do that today. === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: NETWORK Performance how?
On Mon, Nov 11, 2002 at 10:48:57AM -0800, Seema Singh wrote: Hi I want to check network perforamce between app servers and DB servers. How to check ? Is netstat/tracert help or there is another command which could help to find out? ttcp http://ftp.arl.mil/~mike/ttcp.html http://www.pcausa.com/Utilities/pcattcp.htm cisco had it hidden on some of their gear, if you can get the ne guys to help: http://www.cisco.com/warp/public/471/ttcp.html Thx -Seema _ Add photos to your e-mail with MSN 8. Get 2 months FREE*. http://join.msn.com/?page=features/featuredemail -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seema Singh INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Oracle 10i
On Fri, Nov 08, 2002 at 01:14:21PM -0800, MacGregor, Ian A. wrote: It's not just the new releases, but the withdrawal of support for old releases which is the problem. bingo! I love the way otn has oracle 8i under archived. Like I'm running Oracle V2 released on DEC PDP-11. Good weekend, folks! === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Out of procee memory problem ..
version of oracle? On Thu, Nov 07, 2002 at 05:33:59AM -0800, Satyendra K Khare wrote: This is the error message come whenever a process run in which number of rows inserted into a big table (~1400 rows/min), and when this process (called from forms) inserted around 4,50,000 entries in the table it fails and flushes the following message: ORA-04030 Out of Process memory when trying to allocate 528 Bytes (call heap , user umc) ORA-06512 at OBJ.PS_MATCH, Line 1298 ORA-06512 at line 1 PS: Down the database and up it again solve the problem but the reason is unknown to me. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Satyendra K Khare INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: How can I tell if MTS is activated -- more problems
Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Shared_pool
On Wed, Nov 06, 2002 at 04:34:28PM -0800, Jos Someone wrote: List, How do I find out how full my shared_pool is? -- Diagnosing and Resolving Error ORA-04031 Type: Note Doc ID: 146599.1 Understanding and Tuning the Shared Pool in Oracle7, Oracle8, and Oracle8i Type: Note Doc ID: 62143.1 good reading! === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
ORA-02050
ORA-02050: transaction 8.82.26033 rolled back, some remote DBs may be in-doubt The transaction seems to have completely rolled back. My question is, is there any way to relate transaction id 8.82.26033 to an application or table row or something at a higher layer? Thanks. === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: ORA-02050
On Tue, Nov 05, 2002 at 06:33:44AM -0800, [EMAIL PROTECTED] wrote: Ray, I think you need to check DBA_2PC_PENDING on both the local and remote database to see if anything is still in there. That gives the osuser, terminal and host name so you may be able to get something from that. Of course if there is nothing in that table then the transaction has been rolled back already Right, nothing there, so I was wondering if there was a way to chase the transaction id to app, such as archivelog. 8.1.7.4 here. Thanks. John -Original Message- Sent: 05 November 2002 13:43 To: Multiple recipients of list ORACLE-L ORA-02050: transaction 8.82.26033 rolled back, some remote DBs may be in-doubt The transaction seems to have completely rolled back. My question is, is there any way to relate transaction id 8.82.26033 to an application or table row or something at a higher layer? Thanks. === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: ORA-02050
On Tue, Nov 05, 2002 at 09:24:04AM -0800, Yechiel Adar wrote: There is another view, DBA_2PC_NEIGHBORS. Maybe there is some info there. No, the transaction was rolled back completely, or perhaps it resynced when the remote db recovered and thus covered the tracks. This is a good thing. I am wondering if I can find the app that was hit. I'm just curious, not trying to recover. Otherwise, flames would be coming from my hair. ;) Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, November 05, 2002 5:58 PM On Tue, Nov 05, 2002 at 06:33:44AM -0800, [EMAIL PROTECTED] wrote: Ray, I think you need to check DBA_2PC_PENDING on both the local and remote database to see if anything is still in there. That gives the osuser, terminal and host name so you may be able to get something from that. Of course if there is nothing in that table then the transaction has been rolled back already Right, nothing there, so I was wondering if there was a way to chase the transaction id to app, such as archivelog. 8.1.7.4 here. Thanks. John -Original Message- Sent: 05 November 2002 13:43 To: Multiple recipients of list ORACLE-L ORA-02050: transaction 8.82.26033 rolled back, some remote DBs may be in-doubt The transaction seems to have completely rolled back. My question is, is there any way to relate transaction id 8.82.26033 to an application or table row or something at a higher layer? Thanks. === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services
Re: oracle client for linux
On Mon, Oct 28, 2002 at 08:58:32PM -0800, sonny e. supilanas wrote: hi, i'm totally new to oracle, we have a webserver running on mandrake and can make queries to mysql dbase using perl/cgi scripts on same unit which works fine for our sites. but now, we have to connect to a remote oracle dbase w/c is on a remote server. i'm trying to install DBD:oracle module for perl connect string to oracle dbase, but compilation of this module aborts cause it looks for ORACLE_HOME parameters, where can i get a free oracle clients for linux or sources of these oracle libraries for linux so i can rebuild the Makefile.pl of the DBD:oracle module and set the required parameters...i've been trying to download it from OTN site (technet.oracle.com) but to no avail...any suggestions, thank you -- I downloaded 9.2.0 for Linux from otn just a few weeks ago. I installs without a hitch on Mandrake 9.0. I am not sure why you can't download, it should work. What are the symptoms of the failure at download? I also installed 8.1.6 on Mandrake 8.2, but that was a year or so back. === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: sqlplus /nolog
On Tue, Oct 29, 2002 at 06:58:49AM -0800, Gogala, Mladen wrote: It originates from the wonderful OS that used to have commands like SET DEF, MONITOR MODES, BACKUP/IGNORE=INTERLOCK SYS$ORACLE:[]*.* MU: and alike. There is also an abomination of this OS created by David Cuttler. Cutler === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: net8 for linux
On Tue, Oct 29, 2002 at 01:48:38AM -0800, sonny e. supilanas wrote: hi, i learned that i need net8 for linux to rebuild the DBD-Oracle perl module. where can i download one for free otn.oracle.com, you have to download oracle for linux and install it. The installer gives you the option to install the client only. === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Stand-by database implementation ...
On Tue, Oct 29, 2002 at 07:23:33AM -0800, Lizz Pena wrote: Looks like I'm gonna implement a stand-by database on Windows 2000 using Oracle 8.1.7.4 Anyone have any good article, how-tos, caviots I need to consider or read up on? -- caveat, from Latin, let him beware. Ain't English great, never a dull moment. I think the oracle docs cover it well, amazingly. leave it to you to manage the archivelogs, so you need to write some scripts. === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: DB monitoring using SNMP MIBs
City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Oracle Real Application Clusters
On Wed, Oct 23, 2002 at 03:19:21PM -0800, Tim Gorman wrote: A couple of anecdotes to consider: a.. Some folks from the Oak Table forum (www.oaktable.net) recently (last July) constructed a 10-node cluster of Linux laptops right on the conference floor at Oracle Open World in Copenhagen, Denmark. Information is available at http://investor.cnet.com/investor/news/newsitem/0-9900-1028-20212349-0.html?tag=ats. So it can definitely be done on the cheap! hmm...first time I've ever seen NetApp and cheap used together. What is the real poor man's shared disk architecture? NFS? === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Oracle Server with Linux client
On Thu, Oct 24, 2002 at 04:49:28AM -0800, [EMAIL PROTECTED] wrote: Does Linux support Oracle Developer 2000. -- Look on metalink under Certify Avaiability. Linux is not listed. === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Oracle Real Application Clusters
On Thu, Oct 24, 2002 at 05:43:38AM -0800, Jamadagni, Rajendra wrote: If I remember right we had some problems with gsd and nfs ... could you elaborate? === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Oracle Real Application Clusters
On Thu, Oct 24, 2002 at 06:53:27AM -0800, Tim Gorman wrote: NetApp is NFS; so are all current NAS products... The phrases NetApp and cheap are *always* used together -- it is their most compelling feature. CFOs love NetApps. For database usage however, The netapp sales guy I talked with must have been trying to make his quota for that quarter in one stop. Their storage was off the charts when I talked to them, but it has been awhile. So, for testing of rac I could just use nfs disks mounted r/w from multiple linux boxes? I think I'll try it unless someone knows that dog won't hunt. === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
db_writer_processes/db_block_lru_latches
I read in Note:97291.1 that db_writer_processes/db_block_lru_latches could be set to match the number of cpus to try to impove db file parallel write waits. Are seperate controllers required for this to be effective? Any good refs on this topic. === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Opinions on BR scenarios
On Wed, Oct 23, 2002 at 08:14:07AM -0800, Fink, Dan wrote: Rick, I will assume that all logs are properly backed up. The only difference in the recoverability of the 2 scenarios is that an incomplete recovery cannot be done to a time while any tablespace in the database is in hot backup mode. So, there is a window of exposure in Scenario 1, that does not exist in 2. For this reason, it is recommended that each tablespace be placed in backup mode, the files copied, the tablespace taken out of backup mode and the process sleeps for 1 minute. 1 minute? What's that about? Repeat with the next tablespace, etc. === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Linux
Define Linux. Check the support matrix. I liked running on Redhat, but Oracle seemed to drop support for the free versions after 7.1 or so. Anyway, you may want support and so you may want to purchase some of the enterprise releases of linux, such as from RedHat or SuSE that are included in the support matrix. For an inexpensive test environment I moved to Mandrake 9.0 and Oracle 9.2.0 which went together like a glove. It does require .5GB or ram, however and is not supported. I don't care about that for this particular effort. Free at last! On Wed, Oct 23, 2002 at 08:43:51AM -0800, [EMAIL PROTECTED] wrote: Christine, Runs fine, but you'll have to use the export/import conversion route. OH, and get use to a different OS. Dick Goulet Reply Separator Author: Turner; Christine [EMAIL PROTECTED] Date: 10/23/2002 8:14 AM Greetings ALL! Have a question for anyone who has infoI'm researching what it would take to convert a NT database platform (Oracle 81730) to Linux. I have not approached Metalink yet, but will soon. Does anyone have any information on Linux? Whether or not Oracle can run on it? Info on the steps involved to do so? Thanks, Christine Turner Sr. Database Administrator Scottsdale, Arizona -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Turner, Christine INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: standby database question.
On Wed, Oct 23, 2002 at 08:49:49AM -0800, Tim Gorman wrote: Correct. ...though you can achieve the same thing in 8i by running the SQL*Plus or SvrMgr process in a backgrounded script. Stopping the backgrounded script is easy using the RECOVER CANCEL command from any other session... I accomplish this with the gnu screen command. It is a pretty nice addon that lets you detach/reattach/multiplex tty sessions. I use this alot for long running commands and what to go home and check on them later. http://www.gnu.org/software/screen/screen.html - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, October 23, 2002 10:14 AM I'm back on 8i for a different client who wants to implement standby database. other than the whole possibility of losing data during a failover, i've not been able to find anything about doing managed recovery with out having a dedicated session to put the database in managed recovery mode. SQL recover managed standby database; this does not fork into the background but is a foreground process, that ties that window up as it receives and applies logs, that is correct right? Its not until 9i where we get the luxury of managed recovery being a background proces, right? thanks, joe -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Testa INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tim Gorman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: DB monitoring using SNMP MIBs
On Wed, Oct 23, 2002 at 02:19:39PM -0800, Jamadagni, Rajendra wrote: Thanks Dennis, Gary I have tools at my disposal to monitor the db, and I have no problem with that. I was just reading through snmp and was intrigues by the idea that I could get some information without running scripts through sqlplus interface and if so how to accomplish that. I know it is doable because IA does that, just wondering if it would be feasible to do it be some scripting ... -- tcl has a great add on module that makes this real easy called scotty. http://wwwhome.cs.utwente.nl/~schoenw/scotty/ === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Fw: oraperf comment
for the apparent mis-naming of the wait-events db file sequential read and db file scattered read -- I'm sure that it is downloadable from http://www.hotsos.com. Even when asynchronous I/O is available and configured, indexed I/O operations are still essentially synchronous (and non-parallel)... There is a possibility of some form of parallelization in range-scan operations, but there is no evidence that this is happening. For example, while performing an indexed range-scan, if we wanted to read a batch of index entries from the index leaf blocks and submit a list of I/O requests for data blocks on the corresponding table, we could do so. However, when I've performed truss operations on an Oracle server process performing such a range-scan operation (at least through Oracle8i), I've not seen this happening. Purely generic read() operations, one at a time, sequentially... --- The only real advantages of separating tables from indexes into different tablespaces are: a.. different recoverability requirements a.. indexes can be rebuilt instead of restored b.. data (tables and clusters) must be restored -- cannot be rebuilt from anything b.. different types of I/O requests a.. indexes are predominantly accessed using single-block, random read I/O (i.e. UNIQUE scans, RANGE scans, FULL scans) a.. relatively seldom are accessed with multi-block sequentially-accessed read I/O (i.e. FAST FULL scans) b.. while tables are often accessed with a mix of the two types of I/O, depending on the application a.. OLTP usually has heavier single-block, random read I/O due to heavy use of indexes b.. DW usually has heavier multi-block, sequentially-accessed read I/O due to heavy use of FULL table scans c.. may be advantages from this in Oracle9i where different blocksizes are possible for different tablespaces These last points are related to performance, but not in the sense that the mythical conventional wisdom dictates... Hope this helps... -Tim - Original Message - From: Ray Stell [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, October 21, 2002 2:43 PM Subject: oraperf comment An recent oraperf report included the comment: Never split index and data files to different sets of disks. It goes on to state that striping is better. If the system in question does not have raid support, wouldn't it be better to split the index and data across spindles? That would make the word Never inappropriate here? Maybe this is their way of saying don't use old technology. Is there some other reason I am missing? === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Actual list of supported/desupported versions of Oracle
I found this list which is pretty good summary: Oracle Server (RDBMS) Releases Support Status Summary Type: Note Doc ID: 161818.1 http://metalink.oracle.com/metalink/plsql/ml2_documents.showNOT?p_id=161818.1p_showHeader=1p_showHelp=1 === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Installation
On Mon, Oct 21, 2002 at 02:38:22AM -0800, Santosh Varma wrote: I am going to install a product in a client's place where oracle is installed. I am new to oracle. I wanted to know what all needs to be installed .. i mean like tables,tablespace etc... Please give me a list of these and how to do in brief -- I smell Darwin award! http://www.darwinawards.com/ === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
oraperf comment
An recent oraperf report included the comment: Never split index and data files to different sets of disks. It goes on to state that striping is better. If the system in question does not have raid support, wouldn't it be better to split the index and data across spindles? That would make the word Never inappropriate here? Maybe this is their way of saying don't use old technology. Is there some other reason I am missing? === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
[ST-GSPUSER.US@oracle.com: Updated Security Alert #42 patch]
These people are really irritating? Not only do they release bad patches, they don't provide a checksum on the patch files. I have to play a guessing game as to when a file was downloaded. I've seen better support from high school students (literally). What a bunch of amateurs! Those last two sentences would not be included if oracle would provide a checksum for the zip files. It is a fundamental aspect of internet file serving. It provides another level of security and in this case clarity. I can see making mistakes in the code, but to not provide this level of service when it is so easily done is not unforgivable. Anybody at oracle listening? geez, Louis! - Forwarded message from ST-GSPUSER.US [EMAIL PROTECTED] - Date: Wed, 16 Oct 2002 07:57:42 -0700 To: [EMAIL PROTECTED] X-Mailer: Microsoft Outlook IMO, Build 9.0.2416 (9.0.2911.0) According to our records, you have downloaded patch 2540219 for Security Alert #42. If you downloaded the patch for Security Alert #42 (Bug 2540219) prior to the reload date in the table below and have previously installed the patch for Security Alert 40 (bug 2395416), you must re-download and re-apply the patch for Security Alert 42. The updated patch resolves a conflict between the patches for Security Alerts #40 and #42. Platform Version Reload Date HP Alpha OpenVMS 8.1.7.3 09-OCT-2002 HP Alpha OpenVMS 9.0.1.3 09-OCT-2002 HP Tru64 UNIX 8.1.7.4 10-OCT-2002 HP Tru64 UNIX 9.2.0.1 09-OCT-2002 HP-UX 11.0/32 bit 8.1.7.4 10-OCT-2002 HP 9000 Series HP-UX 64bit 8.1.7.4 10-OCT-2002 HP 9000 Series HP-UX 64bit 9.2.0.1 09-OCT-2002 IBM RS/6000 AIX 8.1.7.4 10-OCT-2002 IBM RS/6000 AIX 64-bit 8.1.7.4 10-OCT-2002 IBM RS/6000 AIX 64-bit 9.2.0.1 09-OCT-2002 IBM AIX Based Systems (64-bit) 5L 9.2.0.1 09-OCT-2002 IBM OS/390 (MVS) 8.1.7.4 08-OCT-2002 IBM OS/390 (MVS) 9.0.1.2 08-OCT-2002 IBM OS/390 (MVS) 9.2.0.1 08-OCT-2002 LINUX Intel 8.1.7.4 10-OCT-2002 LINUX Intel 9.2.0.1 09-OCT-2002 Sun Solaris OS (SPARC) 8.1.7.4 10-OCT-2002 Sun Solaris OS (SPARC) 9.2.0.1 09-OCT-2002 Sun Solaris OS (SPARC) 64-bit 8.1.7.4 10-OCT-2002 Sun Solaris OS (SPARC) 64-bit 9.2.0.1 09-OCT-2002 No action is required if you meet at least one of the following conditions: ? You applied none, or only one of the patches. ? Your platforms or versions are not listed in the above table. ? You downloaded patch 2540219 after the dates listed in the table. On behalf of Oracle, we apologize for any inconvenience this may cause. Regards, Oracle Support Services - End forwarded message - -- === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: [ST-GSPUSER.US@oracle.com: Updated Security Alert #42 patch]
Let me get this straight, they know I downloaded the patch but they don't know when/which? Maybe they could use Microsoft SQL Server to keep track of this information. Maybe they could do something really advanced like put a version number in the readme. OK, I'm done. Thanks for listening ;) Get it, listening! I get no respect On Wed, Oct 16, 2002 at 09:14:39AM -0800, Ray Stell wrote: These people are really irritating? Not only do they release bad patches, they don't provide a checksum on the patch files. I have to play a guessing game as to when a file was downloaded. I've seen better support from high school students (literally). What a bunch of amateurs! Those last two sentences would not be included if oracle would provide a checksum for the zip files. It is a fundamental aspect of internet file serving. It provides another level of security and in this case clarity. I can see making mistakes in the code, but to not provide this level of service when it is so easily done is not unforgivable. Anybody at oracle listening? geez, Louis! - Forwarded message from ST-GSPUSER.US [EMAIL PROTECTED] - Date: Wed, 16 Oct 2002 07:57:42 -0700 To: [EMAIL PROTECTED] X-Mailer: Microsoft Outlook IMO, Build 9.0.2416 (9.0.2911.0) According to our records, you have downloaded patch 2540219 for Security Alert #42. If you downloaded the patch for Security Alert #42 (Bug 2540219) prior to the reload date in the table below and have previously installed the patch for Security Alert 40 (bug 2395416), you must re-download and re-apply the patch for Security Alert 42. The updated patch resolves a conflict between the patches for Security Alerts #40 and #42. Platform Version Reload Date HP Alpha OpenVMS 8.1.7.3 09-OCT-2002 HP Alpha OpenVMS 9.0.1.3 09-OCT-2002 HP Tru64 UNIX 8.1.7.4 10-OCT-2002 HP Tru64 UNIX 9.2.0.1 09-OCT-2002 HP-UX 11.0/32 bit 8.1.7.4 10-OCT-2002 HP 9000 Series HP-UX 64bit 8.1.7.4 10-OCT-2002 HP 9000 Series HP-UX 64bit 9.2.0.1 09-OCT-2002 IBM RS/6000 AIX 8.1.7.4 10-OCT-2002 IBM RS/6000 AIX 64-bit 8.1.7.4 10-OCT-2002 IBM RS/6000 AIX 64-bit 9.2.0.1 09-OCT-2002 IBM AIX Based Systems (64-bit) 5L 9.2.0.1 09-OCT-2002 IBM OS/390 (MVS) 8.1.7.4 08-OCT-2002 IBM OS/390 (MVS) 9.0.1.2 08-OCT-2002 IBM OS/390 (MVS) 9.2.0.1 08-OCT-2002 LINUX Intel 8.1.7.4 10-OCT-2002 LINUX Intel 9.2.0.1 09-OCT-2002 Sun Solaris OS (SPARC) 8.1.7.4 10-OCT-2002 Sun Solaris OS (SPARC) 9.2.0.1 09-OCT-2002 Sun Solaris OS (SPARC) 64-bit 8.1.7.4 10-OCT-2002 Sun Solaris OS (SPARC) 64-bit 9.2.0.1 09-OCT-2002 No action is required if you meet at least one of the following conditions: ? You applied none, or only one of the patches. ? Your platforms or versions are not listed in the above table. ? You downloaded patch 2540219 after the dates listed in the table. On behalf of Oracle, we apologize for any inconvenience this may cause. Regards, Oracle Support Services - End forwarded message - -- === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: How to zip a file on From Unix shell script
On Wed, Oct 16, 2002 at 02:43:33PM -0800, WLSH wrote: Hello, list: We have a unix nightly job which will send an email to a user. However, the file size is very large, so we need to zip the file before we send it out. Does anyone know the syntax or command of zipping a file from UNIX ? man zip NAME zip, zipcloak, zipnote, zipsplit - package and compress (archive) files SYNOPSIS zip [-AcdDeEfFghjklLmoqrRSTuvVwXyz@$][-b path] [-n suffixes] [-t mmdd] [-tt mmdd] [ zipfile [ file1 file2 ...]] [-xi list] zipcloak [-dhL] [-b path] zipfile zipnote [-hwL] [-b path] zipfile zipsplit [-hiLpst] [-n size] [-b path] zipfile DESCRIPTION zip is a compression and file packaging utility for Unix, VMS, MSDOS, OS/2, Windows NT, Minix, Atari and Macintosh, Amiga and Acorn RISC OS. === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
security alert #45
http://metalink.oracle.com/metalink/plsql/showDoc?db=NEWid=215900.996 Oracle Security Alert #45 Dated: 04 October 2002 (Updated: 10 October 2002) Severity: 1 Security Release of Apache 1.3.27 Description Apache has released version 1.3.27 of its HTTP Server that contains fixes for the security vulnerabilities noted below and described at http://cve.mitre.org. The vulnerabilities that affect all of the supported versions of the Oracle HTTP Server (OHS) are: CAN-2002-0839: This is a security vulnerability involving System V shared memory based scoreboards. It can only occur on Oracle Linux and HP ports. Exploitation of this vulnerability requires that a malicious and knowledgeable user be able to run his programs on the server web site. As a few commercial web sites allow this, the vulnerability applies to few sites. If a malicious and knowledgeable user is able to run his own programs, the web site has more serious, unrelated security issues than the exploit of this vulnerability. CAN-2002-0840: This is a cross-site scripting vulnerability involving the default error 404 pages. It can occur on all Oracle database platforms. Exploitation of this vulnerability requires the use of wildcard DNS and the setting of UseCanonicalNames = OFF. CAN-2002-0843: There were potential buffer overflows in Apache Bench (ab) that could be exploited by a malicious server. Note that 'ab' is not in Apache itself but is an HTTP client utility used for generating load for performance testing. This vulnerability only occurs when the 'ab' load generating HTTP client, used for performance testing, is used against a malicious HTTP server. These security vulnerabilities are described in more detail at http://cve.mitre.org/ Product afftected OHS in Oracle Database Releases 8.1.7.x, 9.0.1.x and 9.2.x OHS in Oracle9i Application Server Releases 1.0.2.x and 9.0.2.x Platforms affected All except as noted in item #1 in the Description above. === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: If stupidity got you at the age of 7 it will stay with you until you die
On Sun, Oct 13, 2002 at 10:33:37AM -0800, Yechiel Adar wrote: He: NO need. the tnsnames and everything go by server name. I: OK. Trust, but verify - Ronald Reagan === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: 9.2 on Red Hat 8.0
On Wed, Oct 09, 2002 at 10:53:57AM -0800, Gogala, Mladen wrote: May I subscribe to the results of your undertaking? My home email is mailto:[EMAIL PROTECTED] May the force be with you. Went great! Well, sort of... I didn't even read the install guide (and the results will show below). I was amazed how it sailed past the link phase. I expected it to blow up there. It didn't, no glibc issues to be seen. I don't have enough memory to actually start the db, however. I get: Fri Oct 11 09:53:18 2002 WARNING: EINVAL creating segment of size 0x0f40 fix shm parameters in /etc/system or equivalent $ oerr ora 27123 27123, 0, unable to attach to shared memory segment // *Cause: shmat() call failed // *Action: check permissions on segment, contact Oracle support 0x0f40 = 256MB I don't even have that much real memory. This is a junker pc I resurrected from the dumpster with duct tape and prayer. On the upside the install was one of the smoothest I've ever seen. Mandrake 9.0 and Ora 9.2.0 seem to be a nice fit (as long as ora support is not an issue). Mandrake 9's installer is really slick, one of the best of any os I've ever seen. Alright, break times over! -Original Message- From: Ray Stell [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 09, 2002 12:19 PM To: Multiple recipients of list ORACLE-L Subject: Re: 9.2 on Red Hat 8.0 I'm going to try mandrake 9.0, which came out this week, with some 8i and 9i this week. I'll post a followup. Mandrake is basically rh with a better installer, actually one of the best installers I've seen ever! No ora support, just for fun. === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: 8.1.7.2 or 8.1.7.4
On Fri, Oct 11, 2002 at 11:12:10AM -0800, DENNIS WILLIAMS wrote: I'm investigating an 8.1.7 upgrade also. My impression is that the stability may vary by platform, so it might be helpful to specify the platform that is involved. I'm on HP/Compaq Tru64 myself. My dec unix 4.0f would not stay up more than a week due to a memory leak in 8.1.7.2. Been up for 6 months with a very busy 8.1.7.2 on a redhat 7.1 box. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, October 11, 2002 1:46 PM To: Multiple recipients of list ORACLE-L Vaidya I'm running 8.1.7.2 on all instances when I go to upgrade it will probably be 9iR2 starting with a test db, then from there, onto the least important db upwards. Of course I'm stalling to let all the venturous customers test thease new realeases (and abundantly advancing I might add) out for me =). I haven't had an issue where I couldn't get support because I wasn't at .3 or .4, nor has an issue arose in .2 that left me no choice to upgrade... -Original Message- mailto:[EMAIL PROTECTED] ] Sent: Friday, October 11, 2002 2:14 PM To: Multiple recipients of list ORACLE-L Which patch is recommended? Which is more stable? Obvious answer from Oracle Support was 8.1.7.4 for the reason that it was latest. But some of my friends have advised 8.1.7.2 Any opinions? Thanks, -Rachna -- Please see the official ORACLE-L FAQ: http://www.orafaq.com http://www.orafaq.com -- Author: Rachna Vaidya INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: 8.1.7.2 or 8.1.7.4
On Fri, Oct 11, 2002 at 12:09:21PM -0800, Rachna Vaidya wrote: We are running Solaris 6. Currently 8.1.6.3 Planning for 8.1.7 Management is pressing for the patch in the same go due to downtime issues. My solaris 5.8/8.1.7.4 is a dream. Up since 7/1/2002 without a burp. A little slow wrt i/o, but that is likely just old slow disk. Really cheap, though. Fast, cheap, good, pick two. -Rachna - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, October 11, 2002 3:12 PM I'm investigating an 8.1.7 upgrade also. My impression is that the stability may vary by platform, so it might be helpful to specify the platform that is involved. I'm on HP/Compaq Tru64 myself. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, October 11, 2002 1:46 PM To: Multiple recipients of list ORACLE-L Vaidya I'm running 8.1.7.2 on all instances when I go to upgrade it will probably be 9iR2 starting with a test db, then from there, onto the least important db upwards. Of course I'm stalling to let all the venturous customers test thease new realeases (and abundantly advancing I might add) out for me =). I haven't had an issue where I couldn't get support because I wasn't at .3 or .4, nor has an issue arose in .2 that left me no choice to upgrade... -Original Message- mailto:rachnavaidya;hotmail.com ] Sent: Friday, October 11, 2002 2:14 PM To: Multiple recipients of list ORACLE-L Which patch is recommended? Which is more stable? Obvious answer from Oracle Support was 8.1.7.4 for the reason that it was latest. But some of my friends have advised 8.1.7.2 Any opinions? Thanks, -Rachna -- Please see the official ORACLE-L FAQ: http://www.orafaq.com http://www.orafaq.com -- Author: Rachna Vaidya INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachna Vaidya INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Index Oracle-l
. This same file is sent automatically when you subscribe, however in case you lost it, this command sends it again. See Also: INFO WHICH Displays a list of all mailing lists AT THIS SITE for which you are a confirmed subscriber. See Also: CONFIRM WHO list Sends a list of all subscribers to the list specified. This list may be partially or completely blocked, depending on the configuration specified by the list administrator. Most subscriber lists are ONLY available to other list members, however. You will be told if the list is not public. By default, your address will be included in these results unless you have issued the SET list CONCEAL command to hide your address for privacy concerns. The STATUS command will indicate your profile settings. Synonyms: RECIPIENTS, REVIEW, SEND/LIST See Also: SET, STATUS Last updated: 18-Feb-99/bab _ Gratis e-mail resten av livet p? www.yahoo.se/mail Busenkelt! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Joshua=20Becker?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: 9.2 on Red Hat 8.0
I'm going to try mandrake 9.0, which came out this week, with some 8i and 9i this week. I'll post a followup. Mandrake is basically rh with a better installer, actually one of the best installers I've seen ever! No ora support, just for fun. On Wed, Oct 09, 2002 at 07:43:40AM -0800, Bruce wrote: Oracle seems to change their official mind from time to time, but the reality is that RedHat 7.1 and 7.3 are the best versions to run with Oracle. I've had absolutely no problems with either version of the OS, and the installation and setup are well documented (both by Oracle and third-party sites). AS2 appears to have been targetted to Oracle, and installs super clean (the least amount of effort yet required). Good deal if you're looking for the top of the line configuration. I've tried installing 8.1.7 (my usual testbed) on RedHat 8.0 this past weekend and encountered some problems. It doesn't like Apache 2.0 in the mix, even though it doesn't use it. It has some problems getting the IP address, but I can fix that afterwards. The tough issues are which JDK (seems like 1.1.8 is the answer) and which compat- libs. I'm plowing through the compat- libs issue right now. Hopefully it will be fully installed and I can give some feedback as to how it runs in a week or so. thanks, bruce -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bruce INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Backups
services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: your mail
you subscribe, however in case you lost it, this command sends it again. See Also: INFO WHICH Displays a list of all mailing lists AT THIS SITE for which you are a confirmed subscriber. See Also: CONFIRM WHO list Sends a list of all subscribers to the list specified. This list may be partially or completely blocked, depending on the configuration specified by the list administrator. Most subscriber lists are ONLY available to other list members, however. You will be told if the list is not public. By default, your address will be included in these results unless you have issued the SET list CONCEAL command to hide your address for privacy concerns. The STATUS command will indicate your profile settings. Synonyms: RECIPIENTS, REVIEW, SEND/LIST See Also: SET, STATUS Last updated: 18-Feb-99/bab -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tom Pal INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Backups
Yes, you can use dd to read a tape. from man dd: Example 3: Reading a Tape Into an ASCII File This example reads an EBCDIC tape blocked ten 80-byte EBCDIC card images per block into the ASCII file x: example% dd if=/dev/tape of=x ibs=800 cbs=80 conv=ascii,lcase Are you going to sleep well until you have tested and documented the recovery procedure? No. On Wed, Oct 02, 2002 at 04:08:27PM -0800, Robyn Anderson Sands wrote: Hello, I need some info about backups. I am working on a customer site, and have implemented both exports and hot backups. Both jobs copy to a separate mount point, and a job scripted by another individual then moves the files to tape. Here's the problem - he's using a dd command, primarily because it provides a succinct output he can email to non-technicals. The file system is built on a 12 disk A1000 array. We've provided him with a ufsdump script, but he's doesn't want to use it. Can the system be recovered from this tape? Has anyone ever relied on a dd for a daily backup method? The system is Oracle 9i on Solaris 8. Robyn -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robyn Anderson Sands INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: 8.1.6 to 8.1.7 upgrade
On Tue, Oct 01, 2002 at 07:48:33AM -0800, Rachna Vaidya wrote: Gurus! Any docs / URLs / do's don'ts / tips for 8.1.6 to 8.1.7 upgrade? -- 1. Don't be tempted to run below 8.1.7.4. 2. Do patch the listener vulnerability. === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re:
is sent automatically when you subscribe, however in case you lost it, this command sends it again. See Also: INFO WHICH Displays a list of all mailing lists AT THIS SITE for which you are a confirmed subscriber. See Also: CONFIRM WHO list Sends a list of all subscribers to the list specified. This list may be partially or completely blocked, depending on the configuration specified by the list administrator. Most subscriber lists are ONLY available to other list members, however. You will be told if the list is not public. By default, your address will be included in these results unless you have issued the SET list CONCEAL command to hide your address for privacy concerns. The STATUS command will indicate your profile settings. Synonyms: RECIPIENTS, REVIEW, SEND/LIST See Also: SET, STATUS Last updated: 18-Feb-99/bab -Original Message- Sent: Monday, September 30, 2002 6:33 AM To: Multiple recipients of list ORACLE-L Subject: HELP -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Farnsworth, Dave INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
role naming conventions
Oracle seems to be inconsistant in the way it names roles: SQL select role, GRANTED_ROLE from ROLE_ROLE_PRIVS; ROLE GRANTED_ROLE -- -- DBADELETE_CATALOG_ROLE DBAEXECUTE_CATALOG_ROLE DBAEXP_FULL_DATABASE DBAIMP_FULL_DATABASE DBASELECT_CATALOG_ROLE EXECUTE_CATALOG_ROLE HS_ADMIN_ROLE EXP_FULL_DATABASE EXECUTE_CATALOG_ROLE EXP_FULL_DATABASE SELECT_CATALOG_ROLE IMP_FULL_DATABASE EXECUTE_CATALOG_ROLE IMP_FULL_DATABASE SELECT_CATALOG_ROLE OEM_MONITORCONNECT Sometimes it's _ROLE and sometimes it not. Any strong recommendataion for local names of roles? Is there a good guide to naming in general? Thanks. === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: [Q] imp/exp error on 9iR2?
It would appear you don't know the pw of sys, or maybe the capslock is on ;) If you can sqlplus /nolog can connect and alter the sys pw. Then you will know the sys pw and can use it on imp cmd. $ sqlplus /nolog SQL*Plus: Release 8.1.7.0.0 - Production on Fri Sep 27 19:36:42 2002 (c) Copyright 2000 Oracle Corporation. All rights reserved. SQL connect / as sysdba Connected. SQL alter user sys identified by change_on_install User altered. SQL On Fri, Sep 27, 2002 at 02:51:37PM -0800, dist cash wrote: I tried to do full database import use sys ID and have error come out. for sqlplus I can use sqlplus /nolog to avoid it, but on import/export how to avoid it? RSS::/home/app/oracle/admin/db92/export[173]% imp Import: Release 9.2.0.1.0 - Production on Fri Sep 27 17:36:13 2002 Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved. Username: sys Password: change_on_install IMP-00058: ORACLE error 28009 encountered ORA-28009: connection to sys should be as sysdba or sysoperUsername: Password: IMP-00058: ORACLE error 1017 encountered ORA-01017: invalid username/password; logon deniedUsername: Thanks. _ Chat with friends online, try MSN Messenger: http://messenger.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: dist cash INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
dbms_job.remove
Oracle 8.1.7 docs state you have to own a job to remove it. I would like to remove another users job. Is the only way to do by doing the old swap user pw trick? === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: dbms_job.remove
On Mon, Sep 23, 2002 at 01:38:54PM -0800, MacGregor, Ian A. wrote: Try sys.dbms_ijob.remove Also, remember a job must be broken before it can be removed. Thanks for the pointer, maybe not must be broken , this is 8.1.7.4: SQL select job, what, broken from dba_jobs; JOB WHAT B -- - - 61 statspack.snap; N SQL execute dbms_ijob.remove(61); PL/SQL procedure successfully completed. SQL select job, what, broken from dba_jobs; no rows selected Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] -Original Message- Sent: Monday, September 23, 2002 2:16 PM To: Multiple recipients of list ORACLE-L Oracle 8.1.7 docs state you have to own a job to remove it. I would like to remove another users job. Is the only way to do by doing the old swap user pw trick? === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: MacGregor, Ian A. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
sercurity issue
I don't remember the recent SSL vulnerability being listed here: http://metalink.oracle.com/metalink/plsql/showdoc?db=NOTid=206034.1 Vulnerable: Oracle HTTP Server (OHS) shipped with the database up to and including version 9.2.0. Oracle9iAS versions earlier than 9.0.2, including all versions 1.0.2.x. === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Lost ofall redo logs
] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
from the business desk
Meanwhile, Oracle's disclosure Tuesday that it expects its next quarter to be weak (with no sure signs of a recovery)... Oracle dropped 71 cents, or 7.9%, to $8.32. === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: log_file_sync io wait question
What about Steve Adam's comments at: http://www.ixora.com.au/tips/tuning/log_buffer_size.htm What results have been achived by tweeking _log_io_size settings? I was about to poke around with this. Of course, it is not necessary to carefully balance log buffer space waits against log file sync waits. You can have both a large log_buffer setting to avoid log buffer space waits, and a relatively small _log_io_size setting to minimize log file sync waits and reduce their duration. On Wed, Sep 18, 2002 at 09:08:32AM -0800, Pat Howe wrote: We have a canned package that we use to insert approx 100 records/second into one table (oltp environment). Each record is just under 1K (datatypes = number and varchar). There are several indexes that are build on the table as the records are inserted. Each and every record is committed. Therefore we are flushing the 'redo log buffer' to disk (online redo logfiles) 100 times per second (once per commit). Not surprisingly we have noticed IO waits which we believe are associated with our 'Redo Log buffer'. Namely ; log_file_sync = 180 waits/sec log_file_parallel_write = 180 waits/sec We tried resizing the 'redo log buffer' from 16K to 256K - but we did not notice any improvements. Neither Log switching or archiving seem to be excessive. 100 records per second seems to be our maximum speed without the application queuing up and Oracle showing very high waits on log_file_sync and log_file_parallel_writes. Does anyone know how we might be able to minimize the IO waits? Thanks in advance. ENVIRONMENT oracle : Oracle 8.1.7.4 os : Sun Sparc Solaris 8 box: 8x8 E10K IO : Hitachi SANS unit through fiber and Brocade switch _ Patrick J. Howe -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Pat Howe INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: backup controlfile to trace
On Tue, Sep 17, 2002 at 09:03:18PM -0800, Rahul wrote: why not just simplay *name* it !!! SQL alter database backup controlfile to '/oracle/ctrl.trc'; This is what I've been doing in my backup set, but I wanted to add the flat version as a backup to the backup. I never would have thought it would be such painful experience. I think I have similar file redirection problems on my Apple I. Way to go, big o! Is the debug method bullet proof? In other words, is there any way for some other trc file to get in the middle? If so, then the grep for the commands is appropriate. === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Off Topic Question on XP Prof.
On Wed, Sep 18, 2002 at 09:13:31AM -0800, KENNETH JANUSZ wrote: Has anyone installed MS SP1 on XP Prof? If so, have you run into any problems? -- I did earlier this week via a v.90 modem. Took about 2.5 hours to download the files. Other than that it was uneventful. I did chose the backout option. === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
backup controlfile to trace
8.1.7 For scripting purposes, what is the logic for finding the trc file from alter database backup controlfile to trace cmd? This seems really stupid not being able to direct the output. === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: snapshot of a remote snapshot without pk
On Mon, Sep 09, 2002 at 09:53:26AM -0800, Ray Stell wrote: Since I can't make a snapshot of a remote partition (this is really what I wanted in the first place), I make a snapshot on the remote machine first and then snapshot the remote snapshot. -- snapshot of a snapshot is unsupported pre 9i, btw. All roads lead to 9i. === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Misinformation Ranting
On Tue, Sep 10, 2002 at 02:20:01PM -0800, Freeman, Robert wrote: ...best-selling but utterly reprehensible Oracle Performance Tuning Tips Techniques book. OUCH... Glad I didn't write that one! :-)) -- Richard J. Niemiec is chief executive officer and principal of TUSC. He is respected around the world as a master in database administration. Rich often consults with members of the media on technological trends and the impact they'll have on the industry at large. In 1999, Rich authored Oracle Performance Tuning Tips Techniques, the second in a series of books TUSC has written for Oracle Press and Osborne/McGraw-Hill. It's a compilation of almost 20 years of hands-on experience and real-life issues. The book has ranked as a top seller at Amazon.com. Rich currently is conducting research for his second title, which will be released in 2002. http://www.tusc.com/oracle/tusc/rich.html === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
snapshot of a remote snapshot without pk
short question, log demo: Since I can't make a snapshot of a remote partition (this is really what I wanted in the first place), I make a snapshot on the remote machine first and then snapshot the remote snapshot. This works if there is a PK on the remote original table, but not if I try to use rowid. Below is the demo, can anyone suggest a workaround? demo that it works with pk: === on remote machine: -- SQL CREATE TABLE EMP2 (EMPNO NUMBER(4) NOT NULL, ENAME VARCHAR2(10) ) PARTITION by range (empno) (partition e6 values less than (6), partition e12 values less than (12), partition e18 values less than (maxvalue)) / Table created. SQL alter table emp2 add constraint emp_pk primary key(empno); Table altered. (insert some data) create snapshot emp2_snap as select * from emp2 partition (e6); SQL create snapshot emp2_snap as select * from emp2 partition (e6); Materialized view created. SQL select * from emp2_snap; EMPNO ENAME -- -- 1 stellr on local machine: - SQL create snapshot emp2_local_snap as select * from [EMAIL PROTECTED]; Materialized view created. SQL select * from emp2_local_snap; EMPNO ENAME -- -- 1 stellr demo of failure without pk: === on remote machine: -- CREATE TABLE EMP3 (EMPNO NUMBER(4) NOT NULL, ENAME VARCHAR2(10) ) PARTITION by range (empno) (partition e6 values less than (6), partition e12 values less than (12), partition e18 values less than (maxvalue)) / (insert some data) SQL create snapshot log on emp3 with rowid; (can't create the snap without this log) Materialized view log created. create snapshot emp3_e6_snap refresh fast WITH ROWID as select * from emp3 partition (e6); SQL create snapshot emp3_e6_snap refresh fast WITH ROWID as select * from emp3 partition (e6); Materialized view created. SQL select * from emp3_e6_snap; EMPNO ENAME -- -- 1 stellr on local machine: - SQL select * from [EMAIL PROTECTED]; EMPNO ENAME -- -- 1 stellr SQL create snapshot emp3_e6_local_snap refresh fast WITH ROWID as select * from [EMAIL PROTECTED]; * ERROR at line 2: ORA-23413: table STELLR.EMP3_E6_SNAP does not have a snapshot log === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: No space left on device - but I have lots left.
Did I, I might have, if that's the case; you waltz divinely, almost Clintonesque ;) On Mon, Sep 09, 2002 at 10:48:21AM -0800, Gogala, Mladen wrote: Did I shoot from the hip too quickly? I was in a bad mood caused by some other issues. I've received a few emails telling me how grumpy I appeared to be, some of them through an anonymous remailer. There were also some interesting assumptions about my place on the tree of evolution as well as the species of my ancestry. From subtle hints like that, I conclude that I might have gone too far. If that's the case, I apologize. -Original Message- From: Jared Still [mailto:[EMAIL PROTECTED]] Sent: Sunday, September 08, 2002 3:48 PM To: Multiple recipients of list ORACLE-L Subject: Re: No space left on device - but I have lots left. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
materialized view of a remote partition
8.1.7.4 create snapshot TEMP as select * from [EMAIL PROTECTED] partition (020904) ERROR at line 1: ORA-14100: partition extended table name cannot refer to a remote object why not? === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: materialized view of a remote partition
On Fri, Sep 06, 2002 at 07:23:28AM -0800, Ray Stell wrote: 8.1.7.4 create snapshot TEMP as select * from [EMAIL PROTECTED] partition (020904) ERROR at line 1: ORA-14100: partition extended table name cannot refer to a remote object Well, it ain't pretty, but... on the remote db: SQL create snapshot eh_snap as select * from emp partition (e18); Materialized view created. on the local db: SQL create snapshot eh_snap as select * from [EMAIL PROTECTED]; Materialized view created. === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).