Re: Any Oracle 9i Data Guard limitations specific to Linux implementations?
I've done sync physical DG on linux (over direct gigabit ethernet). Didn't encounter any serious problems. With physical standby you can forget about nologging operations -> use alter database force logging or at least on tablespace level for important tablespaces. Also I set LGWR running on higher priority on primary in order to transfer log records to standby with smallest latency. Go with async if your business requirements allow you to lose few bits of data in case of disaster on primary (especially when servers aren't connected via low-latency high-throughput network). And logical standby is only a prototype yet. Tanel. - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Thursday, January 08, 2004 9:34 PM implementations? > Does anyone here know of any Oracle 9i (9.2.0.4) Data Guard limitations and/or needed workarounds? > > In the process of planning a near-terabyte size data warehouse utilizing both Real Application Clusters (RAC) and Data Guard (primary/standby) technologies on a Linux (Red Hat v 2.1) environment (using raw partitions). > > As part of my active research on the matter (manuals, release notes, OTN, etc.), I am wondering if anybody on the list knows (from experience) of any specific limitations (e.g., bugs, etc.) that may be encountered while using the Data Guard (logical or physical standby databases and synchronous or asynchronous modes) implementation on Linux? In other words, looking for any information about possible limitations (or special workarounds needed) using Data Guard on a Linux implementation. > > Regards, > > William > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: William R. Jones > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Any Oracle 9i Data Guard limitations specific to Linux
Hi William, During the past 2,5 years I've been responsible for appr 20 DG installations, varying form 9.0.1 to 9.2.0.4, most Physical Standby. Logical Standby is not ready for High Availability purposes yet, but Physical Standby definitely is. The biggest production systems I've worked on were severel hundreds of Megabytes, most of them on Solaris. The biggest Linux site I've worked with was around 100 MB. Today I configured a Linux RH installation for one of my customers. No experience with DG in combination with raw partitions. I'll send you the materials I created for several classed I tought on DG, and would like to stay in touch with you about your experiences. Regards, Carel-Jan === If you think education is expensive, try ignorance. (Derek Bok) === At 11:34 8-1-04 -0800, you wrote: Does anyone here know of any Oracle 9i (9.2.0.4) Data Guard limitations and/or needed workarounds? In the process of planning a near-terabyte size data warehouse utilizing both Real Application Clusters (RAC) and Data Guard (primary/standby) technologies on a Linux (Red Hat v 2.1) environment (using raw partitions). As part of my active research on the matter (manuals, release notes, OTN, etc.), I am wondering if anybody on the list knows (from experience) of any specific limitations (e.g., bugs, etc.) that may be encountered while using the Data Guard (logical or physical standby databases and synchronous or asynchronous modes) implementation on Linux? In other words, looking for any information about possible limitations (or special workarounds needed) using Data Guard on a Linux implementation. Regards, William -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: William R. Jones INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Carel-Jan Engel INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Any Oracle 9i Data Guard limitations specific to Linux implementations?
Does anyone here know of any Oracle 9i (9.2.0.4) Data Guard limitations and/or needed workarounds? In the process of planning a near-terabyte size data warehouse utilizing both Real Application Clusters (RAC) and Data Guard (primary/standby) technologies on a Linux (Red Hat v 2.1) environment (using raw partitions). As part of my active research on the matter (manuals, release notes, OTN, etc.), I am wondering if anybody on the list knows (from experience) of any specific limitations (e.g., bugs, etc.) that may be encountered while using the Data Guard (logical or physical standby databases and synchronous or asynchronous modes) implementation on Linux? In other words, looking for any information about possible limitations (or special workarounds needed) using Data Guard on a Linux implementation. Regards, William -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: William R. Jones INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Oracle 9i on AIX 5L(JSF2)
Jerome - I have heard that there is a problem with performance but... if you get to 5.2 with ML01, that is supposed to resolve the issue. If anyone knows differently... I would appreciate the knowledge too. Dave - Original Message - > Anybody having problems with Oracle DB hanging up on AIX 5L using JSF2? > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: <[EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Oracle 9i on AIX 5L(JSF2)
Anybody having problems with Oracle DB hanging up on AIX 5L using JSF2? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jerome Roa INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Oracle 9i reports
This was true even for 6i after about patchset 6, IIRC. Many notes on metalink concerning this. In a nutshell.. 1. install VNC 2. start a vnc server at a specific screen address, such as 11 3. add a "export DISPLAY=host:11" to the .profile of the reports server. 4. go have a beer. Ron Thomas Hypercom, Inc [EMAIL PROTECTED] Each new user of a new system uncovers a new class of bugs. -- Kernighan [EMAIL PROTECTED] o.uk To: [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED]Subject: Oracle 9i reports .com 12/17/2003 02:24 PM Please respond to ORACLE-L Hi All, Can you please clarify me the following. We have been using reports 6i on Solaries, Now We would like to migrate to Reports 9i, We are told that (As Character set was depricated in 9i ) we need to keep one xterm console open and ruuning every time we execute rwrun. is this true? are there any work-around? thanks for your help, Ravi. BT Yahoo! Broadband - Save £80 when you order online today. Hurry! Offer ends 21st December 2003. The way the internet was meant to be. http://uk.rd.yahoo.com/evt=21064/*http://btyahoo.yahoo.co.uk -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: =?iso-8859-1?q?Nalla=20Ravi?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: 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).
Oracle 9i reports
Hi All, Can you please clarify me the following. We have been using reports 6i on Solaries, Now We would like to migrate to Reports 9i, We are told that (As Character set was depricated in 9i ) we need to keep one xterm console open and ruuning every time we execute rwrun. is this true? are there any work-around? thanks for your help, Ravi. BT Yahoo! Broadband - Save £80 when you order online today. Hurry! Offer ends 21st December 2003. The way the internet was meant to be. http://uk.rd.yahoo.com/evt=21064/*http://btyahoo.yahoo.co.uk -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: =?iso-8859-1?q?Nalla=20Ravi?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 9i OCP Upgrade
Hi all, I'm going to give up the exam for oracle 9i OCP upgrade path. Is anybody recently attended the exam 1z0-30?, I would like to hear up some tips about the exams.. How hard it's. I'm preparing with OTN notes, oracle9i new features student guide and other resources. Can anyboday share there ideas about RAC, Global support, Datagaurd related questions. Since i feel that these topics are little complicate to understand. Looking fwd your reply. Nirmal. = fsdfsdfsdfsdfs __ Do you Yahoo!? New Yahoo! Photos - easier uploading and sharing. http://photos.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nirmal Kumar M INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Oracle 9i on Fedora
Thanks to all who replied. I thought I had installed compat-libstdc++-7.3-2.96.118, but I missed it and it didn't trigger right away in my brain when the error popped out :) Thanks, Joe -- Joe Frohne Rawson Oaks Consulting, Remote Oracle Admins http://www.rawsonoaks.com [EMAIL PROTECTED] or [EMAIL PROTECTED] Oak Creek, WI, USA > I haven't tried with Fedora and I don't intend until core 2 is out, > but what you need is standard C++ rel 6.1. On RH-9, the required > RPM > is compat-libstdc++-7.3-2.96.118 > > On 12/03/2003 11:34:24 AM, Joe Frohne wrote: >> Hi, >> >> I am running into a problem installing Oracle 9i on Fedora. I get >> the following error when starting the Oracle installer. >> >> error while loading shared libraries: libstdc++-libc6.1-1.so.2: >> cannot open shared object file: No such file or directory >> >> I figured I would ask if anybody has worked through a solution >> before I start pounding away on the same wheel. >> >> Thanks much, >> >> -- >> Joe Frohne >> Rawson Oaks Consulting, Remote Oracle Admins >> http://www.rawsonoaks.com >> [EMAIL PROTECTED] or [EMAIL PROTECTED] >> Oak Creek, WI, USA >> >> -- >> Please see the official ORACLE-L FAQ: http://www.orafaq.net >> -- >> Author: Joe Frohne >> INET: [EMAIL PROTECTED] >> >> Fat City Network Services-- 858-538-5051 >> http://www.fatcity.com >> San Diego, California-- Mailing list and web hosting >> services >> - >> To REMOVE yourself from this mailing list, send an E-Mail message >> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and >> in >> the message BODY, include a line containing: UNSUB ORACLE-L >> (or the name of mailing list you want to be removed from). You >> may >> also send the HELP command for other information (like >> subscribing). >> > > Mladen Gogala > Oracle DBA > > > > Note: > This message is for the named person's use only. It may contain > confidential, proprietary or legally privileged information. No > confidentiality or privilege is waived or lost by any > mistransmission. If you receive this message in error, please > immediately delete it and all copies of it from your system, destroy > any hard copies of it and notify the sender. You must not, directly > or indirectly, use, disclose, distribute, print, or copy any part of > this message if you are not the intended recipient. Wang Trading LLC > and any of its subsidiaries each reserve the right to monitor all > e-mail communications through its networks. > Any views expressed in this message are those of the individual > sender, except where the message states otherwise and the sender is > authorized to state them to be the views of any such entity. > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Mladen Gogala > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting > services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > > > -- Joe Frohne Rawson Oaks Consulting, Remote Oracle Admins http://www.rawsonoaks.com [EMAIL PROTECTED] or [EMAIL PROTECTED] Oak Creek, WI, USA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joe Frohne INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Oracle 9i on Fedora
Thanks to all who replied. I thought I had installed compat-libstdc++-7.3-2.96.118, but I missed it and it didn't trigger right away in my brain when the error popped out :) Thanks, Joe -- Joe Frohne Rawson Oaks Consulting, Remote Oracle Admins http://www.rawsonoaks.com [EMAIL PROTECTED] or [EMAIL PROTECTED] Oak Creek, WI, USA > I haven't tried with Fedora and I don't intend until core 2 is out, > but what you need is standard C++ rel 6.1. On RH-9, the required > RPM > is compat-libstdc++-7.3-2.96.118 > > On 12/03/2003 11:34:24 AM, Joe Frohne wrote: >> Hi, >> >> I am running into a problem installing Oracle 9i on Fedora. I get >> the following error when starting the Oracle installer. >> >> error while loading shared libraries: libstdc++-libc6.1-1.so.2: >> cannot open shared object file: No such file or directory >> >> I figured I would ask if anybody has worked through a solution >> before I start pounding away on the same wheel. >> >> Thanks much, >> >> -- >> Joe Frohne >> Rawson Oaks Consulting, Remote Oracle Admins >> http://www.rawsonoaks.com >> [EMAIL PROTECTED] or [EMAIL PROTECTED] >> Oak Creek, WI, USA >> >> -- >> Please see the official ORACLE-L FAQ: http://www.orafaq.net >> -- >> Author: Joe Frohne >> INET: [EMAIL PROTECTED] >> >> Fat City Network Services-- 858-538-5051 >> http://www.fatcity.com >> San Diego, California-- Mailing list and web hosting >> services >> - >> To REMOVE yourself from this mailing list, send an E-Mail message >> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and >> in >> the message BODY, include a line containing: UNSUB ORACLE-L >> (or the name of mailing list you want to be removed from). You >> may >> also send the HELP command for other information (like >> subscribing). >> > > Mladen Gogala > Oracle DBA > > > > Note: > This message is for the named person's use only. It may contain > confidential, proprietary or legally privileged information. No > confidentiality or privilege is waived or lost by any > mistransmission. If you receive this message in error, please > immediately delete it and all copies of it from your system, destroy > any hard copies of it and notify the sender. You must not, directly > or indirectly, use, disclose, distribute, print, or copy any part of > this message if you are not the intended recipient. Wang Trading LLC > and any of its subsidiaries each reserve the right to monitor all > e-mail communications through its networks. > Any views expressed in this message are those of the individual > sender, except where the message states otherwise and the sender is > authorized to state them to be the views of any such entity. > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Mladen Gogala > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting > services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > > > -- Joe Frohne Rawson Oaks Consulting, Remote Oracle Admins http://www.rawsonoaks.com [EMAIL PROTECTED] or [EMAIL PROTECTED] Oak Creek, WI, USA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joe Frohne INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Oracle 9i on Fedora
On Wed, 3 Dec 2003, Joe Frohne wrote: > Hi, > > I am running into a problem installing Oracle 9i on Fedora. I get > the following error when starting the Oracle installer. > > error while loading shared libraries: libstdc++-libc6.1-1.so.2: > cannot open shared object file: No such file or directory > > I figured I would ask if anybody has worked through a solution > before I start pounding away on the same wheel. I haven't installed Oracle 9i on Fedora, but it appears the installer can't find the shared library indicated. Perhaps this will help: On my Fedora Core Release 1 laptop, /usr/lib/libstdc++-libc6.1-1.so.2 is a symlink that points to /usr/lib/libstdc++-2-libc6.1-1-2.9.0.so, which is installed by the compat-libstdc++-7.3-2.96.118 package. Make sure you have that installed (should come with Fedora) and see if that fixes the problem. rpm -q compat-libstdc++-7.3-2.96.118 should tell you whether it's installed or not. -- Dan > > Thanks much, > > -- > Joe Frohne > Rawson Oaks Consulting, Remote Oracle Admins > http://www.rawsonoaks.com > [EMAIL PROTECTED] or [EMAIL PROTECTED] > Oak Creek, WI, USA > > -- Daniel Hanks - Systems/Database Administrator About Inc., Web Services Division -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Daniel Hanks INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Oracle 9i on Fedora
I haven't tried with Fedora and I don't intend until core 2 is out, but what you need is standard C++ rel 6.1. On RH-9, the required RPM is compat-libstdc++-7.3-2.96.118 On 12/03/2003 11:34:24 AM, Joe Frohne wrote: > Hi, > > I am running into a problem installing Oracle 9i on Fedora. I get > the following error when starting the Oracle installer. > > error while loading shared libraries: libstdc++-libc6.1-1.so.2: > cannot open shared object file: No such file or directory > > I figured I would ask if anybody has worked through a solution > before I start pounding away on the same wheel. > > Thanks much, > > -- > Joe Frohne > Rawson Oaks Consulting, Remote Oracle Admins > http://www.rawsonoaks.com > [EMAIL PROTECTED] or [EMAIL PROTECTED] > Oak Creek, WI, USA > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Joe Frohne > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > Mladen Gogala Oracle DBA Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle 9i on Fedora
Dear fellow Cheesehead, If anyone has figured out 9i on Fedora, Werner Puschitz has: http://www.puschitz.com GL! Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA -Original Message- Sent: Wednesday, December 03, 2003 10:34 AM To: Multiple recipients of list ORACLE-L Hi, I am running into a problem installing Oracle 9i on Fedora. I get the following error when starting the Oracle installer. error while loading shared libraries: libstdc++-libc6.1-1.so.2: cannot open shared object file: No such file or directory I figured I would ask if anybody has worked through a solution before I start pounding away on the same wheel. Thanks much, -- Joe Frohne Rawson Oaks Consulting, Remote Oracle Admins http://www.rawsonoaks.com [EMAIL PROTECTED] or [EMAIL PROTECTED] Oak Creek, WI, USA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Oracle 9i on Fedora
Hi, I am running into a problem installing Oracle 9i on Fedora. I get the following error when starting the Oracle installer. error while loading shared libraries: libstdc++-libc6.1-1.so.2: cannot open shared object file: No such file or directory I figured I would ask if anybody has worked through a solution before I start pounding away on the same wheel. Thanks much, -- Joe Frohne Rawson Oaks Consulting, Remote Oracle Admins http://www.rawsonoaks.com [EMAIL PROTECTED] or [EMAIL PROTECTED] Oak Creek, WI, USA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joe Frohne INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle 9i physical IO - why only one block reads
--_=_NextPart_001_01C3B825.DE0C531A Content-Type: text/plain you may want to raise a call with Oracle support about this. We have an call open with them at present and they have raised a bug for us. We were noticing the same thing as you experienced on AIX 5L 9i RAC 9.2.0.3. Apparently Oracle is interpreting exectly the same statements that ran in minutes on 8i, differently to the way it reads them in 9i (where execution times went up to something like 22 hours !!!) HTH Lee -Original Message- Biddell, Ian Sent: 01 December 2003 10:34 To: Multiple recipients of list ORACLE-L Hi All, I am running a big batch reporting program that does way too much SQL (but that's another story) and when I profile the trace file apart from one pice of SQL all the others are only doing 1 block reads. As you can see from the example below it did 63,209 physical IO calls and they were all for one block only Even though it's via Primary Key why doesn't Oracle get even more than one block per read if the index range scan is long? This is just an example from about 45 SQL statements that have the one block reads only. My multi block read count is 64 on an 8K blocksize, oracle 9.2 - Duration Per Call --- --- Detail of Max -- Blocks per Read Duration# Calls AvgMin Max Data Block Address - -- -- --- -- 1 469s 100.0% 63,209 0.007423s 0.000544s 0.140338s 5:61755 I would have thought I would get more like one of the rare statements that gets 75% at 64 blocks per read. ie. 620s0.1% 4 0.037230s 0.034101s 0.044109s 5:681746 630s0.4% 18 0.039499s 0.034724s 0.062682s 9:706507 64 129s 75.8% 3,451 0.037441s 0.015427s 0.189772s 9:705852 Explain plan of staement SELECT STATEMENT Cost = 510 0-0-510 ...SORT AGGREGATE 1-0-1 ...TABLE ACCESS BY INDEX ROWID ALLOCATION_TRANSACTION_B 2-1-1 34 ...INDEXRANGE SCAN ALLOCATION_TRANSACTION_PK 3-2-1 680 Thanks for any direction to the answer I can be given, just so I can understand more about what's happening Thanks :-) ** The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution, or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. Thank You. --_=_NextPart_001_01C3B825.DE0C531A Content-Type: text/html Content-Transfer-Encoding: quoted-printable you=20 may want to raise a call with Oracle support about this. We have an call op= en=20 with them at present and they have raised a bug for us. We were noticing th= e=20 same thing as you experienced on AIX 5L 9i RAC 9.2.0.3. Apparently Or= acle=20 is interpreting exectly the same statements that ran in minutes on 8i,=20 differently to the way it reads them in 9i (where execution times went up= to something like 22 hours !!!) HTH Lee -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Biddell, IanSen= t:=20 01 December 2003 10:34To: Multiple recipients of list=20 ORACLE-LSubject: Oracle 9i physical IO - why only one block=20 reads Hi All, I am running a big batch reporting program that = does way=20 too much SQL (but that's another story) and when I profile the trace file apart from one= pice of=20 SQL all the others are only doing 1 block reads. As you can see from the example below it did 63,= 209=20 physical IO calls and they were all for one block only Even though it's via Primary Key why doesn't Ora= cle get=20 even more than one block per read if the index range scan is=20 long? This is just an example from about 45 SQL statem= ents that=20 have the one block reads only. My multi block read count is 64 on an 8K blocksi= ze,=20 oracle 9.2 &nbs= p;&= nbsp; &nbs= p; =20 - Duration Per Call --- --- Detail of Max --Blocks pe= r=20 Read=20 Duration #=20 Calls=20 Avg =20 Min Max = Data=20 Block Address- -- -- ---= -- =20 ---
Re: Oracle 9i physical IO - why only one block reads
Ian, Index Range Scans are single block i/o (fast full scans use multiblock i/o). This is why you are seeing the high number of single block reads. If you want to use multiblock reads, use full table scans or fast full index scans. Be warned, response time could drop dramatically (along with your employee rating and salary...). The real question is "Does this have any negative impact on response time for the businesses most important processes?" Daniel Fink "Biddell, Ian" wrote: Hi All, I am running a big batch reporting program that does way too much SQL (but that's another story) and when I profile the trace file apart from one pice of SQL all the others are only doing 1 block reads. As you can see from the example below it did 63,209 physical IO calls and they were all for one block only Even though it's via Primary Key why doesn't Oracle get even more than one block per read if the index range scan is long? This is just an example from about 45 SQL statements that have the one block reads only. My multi block read count is 64 on an 8K blocksize, oracle 9.2 - Duration Per Call --- --- Detail of Max -- Blocks per Read Duration # Calls Avg Min Max Data Block Address - -- -- --- -- 1 469s 100.0% 63,209 0.007423s 0.000544s 0.140338s 5:61755 I would have thought I would get more like one of the rare statements that gets 75% at 64 blocks per read. ie. 62 0s 0.1% 4 0.037230s 0.034101s 0.044109s 5:681746 63 0s 0.4% 18 0.039499s 0.034724s 0.062682s 9:706507 64 129s 75.8% 3,451 0.037441s 0.015427s 0.189772s 9:705852 Explain plan of staement SELECT STATEMENT Cost = 510 0-0-510 SORT AGGREGATE 1-0-1 TABLE ACCESS BY INDEX ROWID ALLOCATION_TRANSACTION_B 2-1-1 34 INDEX RANGE SCAN ALLOCATION_TRANSACTION_PK 3-2-1 680 Thanks for any direction to the answer I can be given, just so I can understand more about what's happening Thanks :-)
Oracle 9i physical IO - why only one block reads
Hi All, I am running a big batch reporting program that does way too much SQL (but that's another story) and when I profile the trace file apart from one pice of SQL all the others are only doing 1 block reads. As you can see from the example below it did 63,209 physical IO calls and they were all for one block only Even though it's via Primary Key why doesn't Oracle get even more than one block per read if the index range scan is long? This is just an example from about 45 SQL statements that have the one block reads only. My multi block read count is 64 on an 8K blocksize, oracle 9.2 - Duration Per Call --- --- Detail of Max --Blocks per Read Duration # Calls Avg Min Max Data Block Address- -- -- --- -- 1 469s 100.0% 63,209 0.007423s 0.000544s 0.140338s 5:61755 I would have thought I would get more like one of the rare statements that gets 75% at 64 blocks per read. ie. 62 0s 0.1% 4 0.037230s 0.034101s 0.044109s 5:68174663 0s 0.4% 18 0.039499s 0.034724s 0.062682s 9:70650764 129s 75.8% 3,451 0.037441s 0.015427s 0.189772s 9:705852 Explain plan of staement SELECT STATEMENT Cost = 510 0-0-510 SORT AGGREGATE 1-0-1 TABLE ACCESS BY INDEX ROWID ALLOCATION_TRANSACTION_B 2-1-1 34 INDEX RANGE SCAN ALLOCATION_TRANSACTION_PK 3-2-1 680 Thanks for any direction to the answer I can be given, just so I can understand more about what's happening Thanks :-)
RE: Client-server Forms6i against Oracle 9i (9.2.0.4) database?
The previous attachment was filtered out by the ListGuru mailing software at fatcity.com because binary attachments are not appropriate for mailing lists. If you want a copy of the attachment which was removed, contact the sender directly and ask for it to be sent to you by private E-mail. This warning is inserted into all messages containing binary attachments which have been removed by ListGuru. If you have questions about this message, contact [EMAIL PROTECTED] for clarification. <>
RE: Client-server Forms6i against Oracle 9i (9.2.0.4) database?
Your developer is wrong ... dead wrong. We use 6i in C/S mode against 9012/9202 since about Sept'02. Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message- Sent: Monday, November 17, 2003 11:45 PM To: Multiple recipients of list ORACLE-L Is it possible to run Forms6i in client-server mode against an Oracle 9.2.0.4 database? One of the developers where I work flatly states that Forms 6i (in any mode) doesn't work against (any) Oracle 9i and I cannot find any specific information either confirming or denying this assertion. Searches on Metalink and Google both came up with nothing of relevance. I would assume that with an Oracle8i client it shouldn't be a problem, but I haven't worked with Forms at all since v3.0 and she is adamant that it is simply impossible - with no explanation of why. Don Granaman - OraSaurus ** This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you. **4 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jamadagni, Rajendra INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Client-server Forms6i against Oracle 9i (9.2.0.4) database?
Don We have successfully used forms 6i against Oracle 9i databases (9iR1 and 9iR2). Just a note that 9iAS Rel1 comes with forms6i. Only in 9iAS rel 2 and above are forms 9i used. Just make sure the correct forms 6i patchset has been applied that fixes the relevant forms bugs. Kind Regards Suhen Pather -Original Message- Sent: Tuesday, November 18, 2003 6:45 AM To: Multiple recipients of list ORACLE-L Is it possible to run Forms6i in client-server mode against an Oracle 9.2.0.4 database? One of the developers where I work flatly states that Forms 6i (in any mode) doesn't work against (any) Oracle 9i and I cannot find any specific information either confirming or denying this assertion. Searches on Metalink and Google both came up with nothing of relevance. I would assume that with an Oracle8i client it shouldn't be a problem, but I haven't worked with Forms at all since v3.0 and she is adamant that it is simply impossible - with no explanation of why. Don Granaman - OraSaurus -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Don Granaman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Suhen Pather (S) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Client-server Forms6i against Oracle 9i (9.2.0.4) database?
Hi Don We have moved to oracle 9i (9.2.0.3) and are running Forms6i without any problem. According to the Metalink certification matrix Forms 6i patch set 13 and above are certified with Oracle 9.2 (or 9i). The matrix does not distinguish between minor releases of Oracle (i.e. 9.2.0.3 and 9.2.0.4). HTH Richard Jones Aramco -Original Message- Don Granaman Sent: Tuesday, November 18, 2003 7:45 AM To: Multiple recipients of list ORACLE-L Is it possible to run Forms6i in client-server mode against an Oracle 9.2.0.4 database? One of the developers where I work flatly states that Forms 6i (in any mode) doesn't work against (any) Oracle 9i and I cannot find any specific information either confirming or denying this assertion. Searches on Metalink and Google both came up with nothing of relevance. I would assume that with an Oracle8i client it shouldn't be a problem, but I haven't worked with Forms at all since v3.0 and she is adamant that it is simply impossible - with no explanation of why. Don Granaman - OraSaurus -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Don Granaman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Richard Oliver Jones INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Client-server Forms6i against Oracle 9i (9.2.0.4) database?
Is it possible to run Forms6i in client-server mode against an Oracle 9.2.0.4 database? One of the developers where I work flatly states that Forms 6i (in any mode) doesn't work against (any) Oracle 9i and I cannot find any specific information either confirming or denying this assertion. Searches on Metalink and Google both came up with nothing of relevance. I would assume that with an Oracle8i client it shouldn't be a problem, but I haven't worked with Forms at all since v3.0 and she is adamant that it is simply impossible - with no explanation of why. Don Granaman - OraSaurus -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Don Granaman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or 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 8i DB with Oracle 9i client
I used the 9i client on WinNT and Win2K against 8.1.7.0 on HP-UX 11i for 4 months without a problem. - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Sunday, November 16, 2003 11:09 AM > Dear Gurus, > > Current versions: > DB : 8.1.7.3 > Client : 8.1.7.0 > > We are in the process of upgrading ONLY the clients from 8.1.7.0 to 9i to address few bugs. Are there any known issues for 8i database with 9i client? > > TIA > Jay > > -- > 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: vze1vwnd INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 8i DB with Oracle 9i client
Dear Gurus, Current versions: DB : 8.1.7.3 Client : 8.1.7.0 We are in the process of upgrading ONLY the clients from 8.1.7.0 to 9i to address few bugs. Are there any known issues for 8i database with 9i client? TIA Jay -- 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).
Anyone downloaded Oracle 9i for Solaris64 lately (Technet)
Title: Anyone downloaded Oracle 9i for Solaris64 lately (Technet) Hi All, I'm trying to download Oracle 9i for Solaris64 and have done so from two locations both yesterday and the day before and keep getting "cpio: Can't read input: end of file encountered prior to expected end of archive." error while cpio file number 1(disk1). File 2 & 3 work fine. It is not finished because at the end I miss files (like runInstaller). So it looks like a corrupt file on technet. Anybody been succesful doing the same lately?? TIA Jack
oracle 9i client and OO4O
Which install option is required to install OO40. I do not really want to install all the database admin stuff on my users PCs John -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: John Dunn INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle 9i client download from web?
http://otn.oracle.com/software/products/oracle9i/index.html -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of M.GodlewskiSent: 15 October 2003 18:54To: Multiple recipients of list ORACLE-LSubject: Oracle 9i client download from web? List, I looked on technet.oracle.com for the 9i release 2 client to download. I didn't see it. Is there a place I can pull the Oracle client for 9.2 from the web? TIA M. Do you Yahoo!?The New Yahoo! Shopping - with improved product search
Oracle 9i client download from web?
List, I looked on technet.oracle.com for the 9i release 2 client to download. I didn't see it. Is there a place I can pull the Oracle client for 9.2 from the web? TIA M. Do you Yahoo!? The New Yahoo! Shopping - with improved product search
Re: Reboot Solaris and Oracle 9i install
Thanks Everyone for there answers! Mujeeb Chowdhry <[EMAIL PROTECTED]> wrote: try init 6>>> [EMAIL PROTECTED] 10/13/03 11:04AM >>>Use 'shutdown now'Then 'reboot -r'>>> [EMAIL PROTECTED] 10/13/03 7:34:24 AM >>>List,Does anyone know the correct Solaris commands to reboot a UNIX Solaris64 bit os system. Is it init, shutdown or reboot?I'm attempting to install Oracle 9i Release 2 on a Solaris machine. Ireceived a memory error when attempting to create an Oracle database, soI need the system rebooted to load the kernel with the correct sharedmemory and semaphore settings. The system admin is only part time, andcurrently not available. The system is in single user mode at thistime. With all the knowledge on this list, I thought this may be a goodplace to ask the question or maybe to point me to a document that wouldhave the reboot information.Thanks,M.Do you Yahoo!?The New Yahoo! Shopping - with improved product search-- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: Mujeeb ChowdhryINET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing). Do you Yahoo!? The New Yahoo! Shopping - with improved product search
RE: Reboot Solaris and Oracle 9i install
init 3 is useful for updating a system, as it eliminates a lot of extraneous stuff that you may not want running. Or even init 1 (single user mode ) if necessary. Jared Brian Dunbar <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 10/13/2003 05:54 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject: RE: Reboot Solaris and Oracle 9i install [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] on Monday, October 13, 2003 11:44 said; > Solaris, I believe, uses the System V shutdown command. Although you > could use init to switch to the appropriate reboot runlevel, the typical > way to reboot a Solaris system is: > # /etc/shutdown -i 6 -g 0 -y > I'll assume you haven't mucked with your inittab. > (This provides no grace period for users to log off. Adjust -g > appropriately.) For some reason, my habit is to use the init commands (init 6 for example) to restart workstations, and /etc/shutdown for workstations. Is there any reason the list is aware of to prefer one over the other? ~brian -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Brian Dunbar INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Reboot Solaris and Oracle 9i install
Basically the main difference is: init can change you among levels... while shutdown no! and... shutdown cannot take you into levels 2 and 3. check the -i option for the shutdown command. HTH JL --- Brian Dunbar <[EMAIL PROTECTED]> wrote: > > For some reason, my habit is to use the init > commands (init 6 for example) > to restart workstations, and /etc/shutdown for > workstations. > > Is there any reason the list is aware of to prefer > one over the other? > > ~brian > -- __ Do you Yahoo!? The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jose Luis Delgado INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Reboot Solaris and Oracle 9i install
[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] on Monday, October 13, 2003 11:44 said; > Solaris, I believe, uses the System V shutdown command. Although you > could use init to switch to the appropriate reboot runlevel, the typical > way to reboot a Solaris system is: > # /etc/shutdown -i 6 -g 0 -y > I'll assume you haven't mucked with your inittab. > (This provides no grace period for users to log off. Adjust -g > appropriately.) For some reason, my habit is to use the init commands (init 6 for example) to restart workstations, and /etc/shutdown for workstations. Is there any reason the list is aware of to prefer one over the other? ~brian -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Brian Dunbar INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Reboot Solaris and Oracle 9i install
Solaris, I believe, uses the System V shutdown command. Although you could use init to switch to the appropriate reboot runlevel, the typical way to reboot a Solaris system is: # /etc/shutdown -i 6 -g 0 -y I'll assume you haven't mucked with your inittab. (This provides no grace period for users to log off. Adjust -g appropriately.) Adam "Robert Jenkins" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 10/13/2003 09:04 AM Please respond to [EMAIL PROTECTED] To Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc Subject Re: Reboot Solaris and Oracle 9i install Use 'shutdown now' Then 'reboot -r' >>> [EMAIL PROTECTED] 10/13/03 7:3 4:24 AM >>> List, Does anyone know the correct Solaris commands to reboot a UNIX Solaris 64 bit os system. Is it init, shutdown or reboot? I'm attempting to install Oracle 9i Release 2 on a Solaris machine. I received a memory error when attempting to create an Oracle database, so I n eed the system rebooted to load the kernel with the correct shared memory and semaphore settings. The system admin is only part time, and currently not available. The system is in single user mode at this time. With all the knowledge on this list, I thought this may be a good place to ask the question or maybe to point me to a document that would have the reboot information. Thanks, M. Do you Yahoo!? The New Yahoo! Shopping - with improved product search -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Reboot Solaris and Oracle 9i install
try init 6 >>> [EMAIL PROTECTED] 10/13/03 11:04AM >>> Use 'shutdown now' Then 'reboot -r' >>> [EMAIL PROTECTED] 10/13/03 7:34:24 AM >>> List, Does anyone know the correct Solaris commands to reboot a UNIX Solaris 64 bit os system. Is it init, shutdown or reboot? I'm attempting to install Oracle 9i Release 2 on a Solaris machine. I received a memory error when attempting to create an Oracle database, so I need the system rebooted to load the kernel with the correct shared memory and semaphore settings. The system admin is only part time, and currently not available. The system is in single user mode at this time. With all the knowledge on this list, I thought this may be a good place to ask the question or maybe to point me to a document that would have the reboot information. Thanks, M. Do you Yahoo!? The New Yahoo! Shopping - with improved product search -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mujeeb Chowdhry INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Reboot Solaris and Oracle 9i install
Use 'shutdown now' Then 'reboot -r'>>> [EMAIL PROTECTED] 10/13/03 7:3 4:24 AM >>> List, Does anyone know the correct Solaris commands to reboot a UNIX Solaris 64 bit os system. Is it init, shutdown or reboot? I'm attempting to install Oracle 9i Release 2 on a Solaris machine. I received a memory error when attempting to create an Oracle database, so I n eed the system rebooted to load the kernel with the correct shared memory and semaphore settings. The system admin is only part time, and currently not available. The system is in single user mode at this time. With all the knowledge on this list, I thought this may be a good place to ask the question or maybe to point me to a document that would have the reboot information. Thanks, M. Do you Yahoo!?The New Yahoo! Shopping - with improved product search
Reboot Solaris and Oracle 9i install
List, Does anyone know the correct Solaris commands to reboot a UNIX Solaris 64 bit os system. Is it init, shutdown or reboot? I'm attempting to install Oracle 9i Release 2 on a Solaris machine. I received a memory error when attempting to create an Oracle database, so I need the system rebooted to load the kernel with the correct shared memory and semaphore settings. The system admin is only part time, and currently not available. The system is in single user mode at this time. With all the knowledge on this list, I thought this may be a good place to ask the question or maybe to point me to a document that would have the reboot information. Thanks, M. Do you Yahoo!? The New Yahoo! Shopping - with improved product search
RE: Import/Export file is limited to 2,147,483,647 Bytes for Oracle 9i on Sun Solaris (32-bit)?
Another option is to list multiple *dmp files in the FILE parameter; ie FILE=(file1.dmp, file2.dmp, ...) along with the FILESIZE parameter. When the file1.dmp reaches the size specified in FILESIZE, then file2.dmp is created, and so on. The trick is to list enough files in the FILE parameter to complete the export. GWP -Original Message- Pena, Carol A Sent: Monday, October 06, 2003 5:24 PM To: Multiple recipients of list ORACLE-L Oracle 9i on Sun Solaris (32-bit)? Yes, I have a 4.5G export file on a Solaris box. Have your System Admininstrator check to ensure the filesystem you are writing the export file to is configured for "large files". Once you've verified that, then you can export (or import) via a named pipe. See Note #30528.1 or one of many other Metalink notes. If named pipes are not sufficient for your export you may also use the combination of named pipe and "file= & filesize=" parameters. Carol -Original Message- Guang Mei Sent: Monday, October 06, 2003 4:04 PM To: Multiple recipients of list ORACLE-L 9i on Sun Solaris (32-bit)? Hi, I am reading the following doc: Oracle9i Release Notes Release 2 (9.2.0.1.0) for Sun Solaris (32-bit) April 2003 Part No. A97348-04 and I found that it says the Import/Export file is limited to 2,147,483,647 Bytes (see below). Does this mean the max dump file size. I don't have 9i to try now, but has anyone have dump file size bigger than 2G in this situation? Guang The following table lists the Oracle file size limits. Block size is defined in the db_block_size parameter of the $ORACLE_HOME/dbs/initsid.ora file. File Type Maximum Size in Bytes data file with block size 2048 8,589,932,544 data file with block size 4096 17,179,865,088 data file with block size 8196 34,359,730,176 data file with block size 16,384 68,719,460,352 data file with block size 32,768 137,438,920,704 Import/Export file 2,147,483,647 SQL*Loader file 2,147,483,647 File Type Maximum Size in Bytes -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Guang Mei INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pena, Carol 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gary W. Parker INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Import/Export file is limited to 2,147,483,647 Bytes for Oracle 9i on Sun Solaris (32-bit)?
Yes, I have a 4.5G export file on a Solaris box. Have your System Admininstrator check to ensure the filesystem you are writing the export file to is configured for "large files". Once you've verified that, then you can export (or import) via a named pipe. See Note #30528.1 or one of many other Metalink notes. If named pipes are not sufficient for your export you may also use the combination of named pipe and "file= & filesize=" parameters. Carol -Original Message- Guang Mei Sent: Monday, October 06, 2003 4:04 PM To: Multiple recipients of list ORACLE-L 9i on Sun Solaris (32-bit)? Hi, I am reading the following doc: Oracle9i Release Notes Release 2 (9.2.0.1.0) for Sun Solaris (32-bit) April 2003 Part No. A97348-04 and I found that it says the Import/Export file is limited to 2,147,483,647 Bytes (see below). Does this mean the max dump file size. I don't have 9i to try now, but has anyone have dump file size bigger than 2G in this situation? Guang The following table lists the Oracle file size limits. Block size is defined in the db_block_size parameter of the $ORACLE_HOME/dbs/initsid.ora file. File Type Maximum Size in Bytes data file with block size 2048 8,589,932,544 data file with block size 4096 17,179,865,088 data file with block size 8196 34,359,730,176 data file with block size 16,384 68,719,460,352 data file with block size 32,768 137,438,920,704 Import/Export file 2,147,483,647 SQL*Loader file 2,147,483,647 File Type Maximum Size in Bytes -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Guang Mei INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pena, Carol 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).
Import/Export file is limited to 2,147,483,647 Bytes for Oracle 9i on Sun Solaris (32-bit)?
Hi, I am reading the following doc: Oracle9i Release Notes Release 2 (9.2.0.1.0) for Sun Solaris (32-bit) April 2003 Part No. A97348-04 and I found that it says the Import/Export file is limited to 2,147,483,647 Bytes (see below). Does this mean the max dump file size. I don't have 9i to try now, but has anyone have dump file size bigger than 2G in this situation? Guang The following table lists the Oracle file size limits. Block size is defined in the db_block_size parameter of the $ORACLE_HOME/dbs/initsid.ora file. File Type Maximum Size in Bytes data file with block size 2048 8,589,932,544 data file with block size 4096 17,179,865,088 data file with block size 8196 34,359,730,176 data file with block size 16,384 68,719,460,352 data file with block size 32,768 137,438,920,704 Import/Export file 2,147,483,647 SQL*Loader file 2,147,483,647 File Type Maximum Size in Bytes -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Guang Mei INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Oracle 9i Rac scripts
Hi All Since I'm new to 9iRAC (as are a lot of people I guess) I need some help. I'm working my way through the (tuning) docs and have compiled this set of sql's for monitoring the Cluster. Could the people that have experience with the 9i RAC cluster look at it and tell me what is missing or what is absolute garbage. TIA Jack 9iRAC.sql Description: Binary data
Cursed Oracle 9i installation on windoze
Hi, I can't believe I'm loosing that much time installing Oracle 9i on my pc at home. PC is AMD Athlon/windows 2000 I've downloaded Oracle 9i release 2 from technet. When running setup.exe I have the following message The Java RunTime Environment was nout found at: C:\DOCUME~\ADMINI~\LOCALS~1\Temp\OraInstall\jre\bin\jawaw.exe. Hence the Oracle Universal Installer cannot be run. Please visit Then, I've removed all Oracle stuff (OWB, Oracle 8i,..) that I had following metalink note. I've cleaned the path, the registry, the environment variables,... It still doesn't install, even if I run from ../install/win32/setup.exe Any ideas ? Stephane Paquette Administrateur de bases de donnees Database Administrator Standard Life www.standardlife.ca Tel. (514) 499-7999 7470 and (514) 925-7187 [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Paquette INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle 9i new features - by Connor McDonald
Thanks for the feedback - nothing like trying to cover three thousand slides in 60 mins. My speaker evaluations tended run along the lines of... "Man, that guy just never shuts up!" Although my favourite piece of feedback was: "Take a breath, man" :-) Cheers Connor --- "Jesse, Rich" <[EMAIL PROTECTED]> wrote: > Looks like an excellent presentation, both > content-wise and visually. Maybe > the latter's due to it being Acrobat and not a > PowerlessPoint... :) > > Rich > > Rich Jesse System/Database > Administrator > [EMAIL PROTECTED] Quad/Tech Inc, > Sussex, WI USA > > > -Original Message- > > From: Prem Khanna J [mailto:[EMAIL PROTECTED] > > Sent: Monday, September 22, 2003 12:45 AM > > To: Multiple recipients of list ORACLE-L > > Subject: Oracle 9i new features - by Connor > McDonald > > > > > > ..a paper presented by Connor at OracleWorld 2003 > is here. > > > > http://tinyurl.com/o6hp > > > > ..thought it may be of interest for many on this > list. > > > > Jp. > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.net > -- > Author: Jesse, Rich > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 > http://www.fatcity.com > San Diego, California-- Mailing list and web > hosting services > - > To REMOVE yourself from this mailing list, send an > E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') and in > the message BODY, include a line containing: UNSUB > ORACLE-L > (or the name of mailing list you want to be removed > from). You may > also send the HELP command for other information > (like subscribing). = Connor McDonald web: http://www.oracledba.co.uk web: http://www.oaktable.net email: [EMAIL PROTECTED] "GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will sit in a boat and drink beer all day" Want to chat instantly with your online friends? Get the FREE Yahoo! Messenger http://mail.messenger.yahoo.co.uk -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: =?iso-8859-1?q?Connor=20McDonald?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle 9i new features - by Connor McDonald
Looks like an excellent presentation, both content-wise and visually. Maybe the latter's due to it being Acrobat and not a PowerlessPoint... :) Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA > -Original Message- > From: Prem Khanna J [mailto:[EMAIL PROTECTED] > Sent: Monday, September 22, 2003 12:45 AM > To: Multiple recipients of list ORACLE-L > Subject: Oracle 9i new features - by Connor McDonald > > > ..a paper presented by Connor at OracleWorld 2003 is here. > > http://tinyurl.com/o6hp > > ..thought it may be of interest for many on this list. > > Jp. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Oracle 9i new features - by Connor McDonald
..a paper presented by Connor at OracleWorld 2003 is here. http://tinyurl.com/o6hp ..thought it may be of interest for many on this list. Jp. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Prem Khanna J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle 9i and DB2 8.1 comparison article
Title: Message Let me quote the conclusion of the article: ConclusionIt is not true that Oracle 9i Database is better than DB2 Universal Database v8.1or vice versa. Both products can be used to build stable and efficient systemsand the stability and effectiveness of your applications and databases depend rather upon the experience of the database developers and database administratorthan the database's provider. This is feature by feature comparison, made by using marketing materials from both companies as the main source. The purpose of this comparison is quite unclear to me. It underlines the differences in the approach between marketing teams from IBM and Oracle and will not be helpful to magazine reading damagement in deciding what database to buy. Marketing materials are, as expected, grossly inaccurate, so in comparison with SQL Server there is statement that maximum row size for SQL Server is 8036 characters, which would render it completely useless, while the maximum row size for Oracle9i was set to 255000 which would directly contradict to the existence of LONG columns, which as we all know, can go to 2GB. Author, nevertheless, puts this information in the "comparison". The conclusion is the same at the bottom of all 3 comparisons and that is that it's not true that one database is better then another, which is obviously not true. What is more, open source alternatives like Postgres and MySQL were left out of the comparison and they are rapidly gaining ground, especially Postgres, which supports transactions and can use perl as it's internal scripting language. --Mladen GogalaOracle DBA> -Original Message-> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On> Behalf Of Boivin, Patrice J> Sent: Wednesday, September 10, 2003 12:05 PM> To: Multiple recipients of list ORACLE-L> Subject: Oracle 9i and DB2 8.1 comparison article>>> http://www.databasejournal.com/features/oracle/article.php/3075071>> Patrice.> --> Please see the official ORACLE-L FAQ: http://www.orafaq.net> --> Author: Boivin, Patrice J> INET: [EMAIL PROTECTED]>> Fat City Network Services -- 858-538-5051 http://www.fatcity.com> San Diego, California -- Mailing list and web hosting services> -> To REMOVE yourself from this mailing list, send an E-Mail message> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru')> and in the message BODY, include a line containing: UNSUB> ORACLE-L (or the name of mailing list you want to be removed> from). You may also send the HELP command for other> information (like subscribing).> Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity.
Oracle 9i and DB2 8.1 comparison article
http://www.databasejournal.com/features/oracle/article.php/3075071 Patrice. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle 9i Rel. 2 on Red Hat Advanced Server 2.1
Title: RE: Oracle 9i Rel. 2 on Red Hat Advanced Server 2.1 1 Important Difference RHAS 2.1 is the only certified version if you are using 9.2 -Original Message- From: Kulev, Milen [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 04, 2003 4:59 AM To: Multiple recipients of list ORACLE-L Subject: AW: Oracle 9i Rel. 2 on Red Hat Advanced Server 2.1 Hi Helmut , I think the papers below should give you "fast start" about what is so special in RHAS 2.1. http://otn.oracle.com/tech/linux/pdf/1_linuxVM_v2_accepted.pdf http://otn.oracle.com/tech/linux/pdf/9iR2-on-Linux-Tech-WP-Final.PDF HTH. Milen -Ursprüngliche Nachricht- Von: Jack van Zanen [mailto:[EMAIL PROTECTED]] Gesendet: Donnerstag, 4. September 2003 10:19 An: Multiple recipients of list ORACLE-L Betreff: RE: Oracle 9i Rel. 2 on Red Hat Advanced Server 2.1 I have been led to believe that AS2.1 has been optimized on for instance I/O and is therefore a lot faster on the I/O side (I believe it is async I/O that was worked on) Probably some other issues as well but this one stuck. I have no experience with it though. -Original Message- Sent: Thursday, September 04, 2003 10:04 AM To: Multiple recipients of list ORACLE-L Hi! Is anybody using Oracle 9i on Red Hat Advanced Server? I just installed RAS 2.1 and did not notice much difference to a regular Red Hat Installation... What is the beig difference between Advanced Server and "regular" Red Har Linux? Thanks, Helmut -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jack van Zanen INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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).
AW: Oracle 9i Rel. 2 on Red Hat Advanced Server 2.1
Hi Helmut , I think the papers below should give you "fast start" about what is so special in RHAS 2.1. http://otn.oracle.com/tech/linux/pdf/1_linuxVM_v2_accepted.pdf http://otn.oracle.com/tech/linux/pdf/9iR2-on-Linux-Tech-WP-Final.PDF HTH. Milen -Ursprüngliche Nachricht- Von: Jack van Zanen [mailto:[EMAIL PROTECTED] Gesendet: Donnerstag, 4. September 2003 10:19 An: Multiple recipients of list ORACLE-L Betreff: RE: Oracle 9i Rel. 2 on Red Hat Advanced Server 2.1 I have been led to believe that AS2.1 has been optimized on for instance I/O and is therefore a lot faster on the I/O side (I believe it is async I/O that was worked on) Probably some other issues as well but this one stuck. I have no experience with it though. -Original Message- Sent: Thursday, September 04, 2003 10:04 AM To: Multiple recipients of list ORACLE-L Hi! Is anybody using Oracle 9i on Red Hat Advanced Server? I just installed RAS 2.1 and did not notice much difference to a regular Red Hat Installation... What is the beig difference between Advanced Server and "regular" Red Har Linux? Thanks, Helmut -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jack van Zanen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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).
RE: Oracle 9i Rel. 2 on Red Hat Advanced Server 2.1
I have been led to believe that AS2.1 has been optimized on for instance I/O and is therefore a lot faster on the I/O side (I believe it is async I/O that was worked on) Probably some other issues as well but this one stuck. I have no experience with it though. -Original Message- Sent: Thursday, September 04, 2003 10:04 AM To: Multiple recipients of list ORACLE-L Hi! Is anybody using Oracle 9i on Red Hat Advanced Server? I just installed RAS 2.1 and did not notice much difference to a regular Red Hat Installation... What is the beig difference between Advanced Server and "regular" Red Har Linux? Thanks, Helmut -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jack van Zanen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 9i Rel. 2 on Red Hat Advanced Server 2.1
Title: Oracle 9i Rel. 2 on Red Hat Advanced Server 2.1 Hi! Is anybody using Oracle 9i on Red Hat Advanced Server? I just installed RAS 2.1 and did not notice much difference to a regular Red Hat Installation... What is the beig difference between Advanced Server and "regular" Red Har Linux? Thanks, Helmut
RE: Oracle 9i memory Leaks and other errors
Title: RE: Oracle 9i memory Leaks and other errors Bhavesh, you have already sent 5 similar emails, so this is time for some conclusions 1. Some have no interest in such emails 2. Those who might have, don't have any such information. Your best bet is to contact Oracle support in your country first. Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message- From: Bhavesh Lala [mailto:[EMAIL PROTECTED]] Sent: Saturday, August 23, 2003 11:55 AM To: Multiple recipients of list ORACLE-L Subject: Oracle 9i memory Leaks and other errors Hi Can anyone help me with Oracle 9i database - ie 9.2.0.3 where there are issues such as memory leaks and other issues or bugs. Has anyone doing data warehousing or transaction processing encountered any issues with this version of Oracle and what have you done to fix it. I have found errors with using FOR CURSOR loops - encountered problems with it where it took extremely long to run due to a memory leak in Oracle. We had to apply a patch to fix this. HAs anyone encountered any other problems as DBAs or Developers? Regards Bhavesh -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bhavesh Lala INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). *This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.*1
Oracle 9i memory Leaks and other errors
Hi Can anyone help me with Oracle 9i database - ie 9.2.0.3 where there are issues such as memory leaks and other issues or bugs. Has anyone doing data warehousing or transaction processing encountered any issues with this version of Oracle and what have you done to fix it. I have found errors with using FOR CURSOR loops - encountered problems with it where it took extremely long to run due to a memory leak in Oracle. We had to apply a patch to fix this. HAs anyone encountered any other problems as DBAs or Developers? Regards Bhavesh -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bhavesh Lala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle 9i versus MS SQL 2K w.r.t. Performance
Vivek - This subject has been discussed on this list from time to time. You can go to Google and search for Oracle-L "SQL Server" and variations to pull up previous discussions. Awhile back eWeek magazine did an extensive benchmark. It is a little date, but make sure you re-read that for insights. They also had a recent article discussing the shortcomings of their benchmark. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, August 22, 2003 8:05 AM To: Multiple recipients of list ORACLE-L Need to give a presentation on Oracle 9i versus MS SQL Server 2K with respect to Performance primarily . Any Docs , Links ? Thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle 9i memory Leaks and other errors
Are you sure it is a memory leak or is it problem with program design? What are the error messeges? Bit tough to provide any feedback with the minimal information you have provided. Brad O. -Original Message- Sent: Friday, August 22, 2003 9:09 AM To: Multiple recipients of list ORACLE-L anyone helppp -Original Message- Sent: Thursday 21 August 2003 07:59 To: Multiple recipients of list ORACLE-L -Original Message- Sent: Monday 18 August 2003 06:36 To: '[EMAIL PROTECTED]' Hi Can anyone help me with Oracle 9i database - ie 9.2.0.3 where there are issues such as memory leaks and other issues or bugs. Has anyone doing data warehousing or transaction processing encountered any issues with this version of Oracle and what have you done to fix it. I have found errors with using FOR CURSOR loops - encountered problems with it where it took extremely long to run due to a memory leak in Oracle. We had to apply a patch to fix this. HAs anyone encountered any other problems as DBAs or Developers? Regards Bhavesh -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bhavesh Lala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Bhavesh Lala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Odland, Brad INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Oracle 9i versus MS SQL 2K w.r.t. Performance
The Yukon Database Try this link http://www.oracle.com/features/insider/index.html?1101_db_yukonlate.html and http://www.oracle.com/ip/deploy/database/oracle9i/db_sqlpartners.html Alessandro Guimarães - Original Message - From: VIVEK_SHARMA To: Multiple recipients of list ORACLE-L Sent: Friday, August 22, 2003 6:04 AM Subject: Oracle 9i versus MS SQL 2K w.r.t. Performance Need to give a presentation on Oracle 9i versus MS SQL Server 2K with respect to Performance primarily . Any Docs , Links ? Thanks
RE: Oracle 9i memory Leaks and other errors
I have tried there and they just have a patch but not much other info which can help -Original Message- Sent: Friday 22 August 2003 04:20 To: Multiple recipients of list ORACLE-L You can find the interesting information on http://www.metalink.com -- Mladen Gogala Oracle DBA -Original Message- Bhavesh Lala Sent: Friday, August 22, 2003 10:09 AM To: Multiple recipients of list ORACLE-L anyone helppp -Original Message- Sent: Thursday 21 August 2003 07:59 To: Multiple recipients of list ORACLE-L -Original Message- Sent: Monday 18 August 2003 06:36 To: '[EMAIL PROTECTED]' Hi Can anyone help me with Oracle 9i database - ie 9.2.0.3 where there are issues such as memory leaks and other issues or bugs. Has anyone doing data warehousing or transaction processing encountered any issues with this version of Oracle and what have you done to fix it. I have found errors with using FOR CURSOR loops - encountered problems with it where it took extremely long to run due to a memory leak in Oracle. We had to apply a patch to fix this. HAs anyone encountered any other problems as DBAs or Developers? Regards Bhavesh -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bhavesh Lala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Bhavesh Lala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bhavesh Lala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle 9i memory Leaks and other errors
You can find the interesting information on http://www.metalink.com -- Mladen Gogala Oracle DBA -Original Message- Bhavesh Lala Sent: Friday, August 22, 2003 10:09 AM To: Multiple recipients of list ORACLE-L anyone helppp -Original Message- Sent: Thursday 21 August 2003 07:59 To: Multiple recipients of list ORACLE-L -Original Message- Sent: Monday 18 August 2003 06:36 To: '[EMAIL PROTECTED]' Hi Can anyone help me with Oracle 9i database - ie 9.2.0.3 where there are issues such as memory leaks and other issues or bugs. Has anyone doing data warehousing or transaction processing encountered any issues with this version of Oracle and what have you done to fix it. I have found errors with using FOR CURSOR loops - encountered problems with it where it took extremely long to run due to a memory leak in Oracle. We had to apply a patch to fix this. HAs anyone encountered any other problems as DBAs or Developers? Regards Bhavesh -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bhavesh Lala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Bhavesh Lala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle 9i memory Leaks and other errors
anyone helppp -Original Message- Sent: Thursday 21 August 2003 07:59 To: Multiple recipients of list ORACLE-L -Original Message- Sent: Monday 18 August 2003 06:36 To: '[EMAIL PROTECTED]' Hi Can anyone help me with Oracle 9i database - ie 9.2.0.3 where there are issues such as memory leaks and other issues or bugs. Has anyone doing data warehousing or transaction processing encountered any issues with this version of Oracle and what have you done to fix it. I have found errors with using FOR CURSOR loops - encountered problems with it where it took extremely long to run due to a memory leak in Oracle. We had to apply a patch to fix this. HAs anyone encountered any other problems as DBAs or Developers? Regards Bhavesh -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bhavesh Lala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Bhavesh Lala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 9i versus MS SQL 2K w.r.t. Performance
Need to give a presentation on Oracle 9i versus MS SQL Server 2K with respect to Performance primarily . Any Docs , Links ? Thanks
RE: Oracle 9i memory Leaks and other errors
-Original Message- Sent: Monday 18 August 2003 06:36 To: '[EMAIL PROTECTED]' Hi Can anyone help me with Oracle 9i database - ie 9.2.0.3 where there are issues such as memory leaks and other issues or bugs. Has anyone doing data warehousing or transaction processing encountered any issues with this version of Oracle and what have you done to fix it. I have found errors with using FOR CURSOR loops - encountered problems with it where it took extremely long to run due to a memory leak in Oracle. We had to apply a patch to fix this. HAs anyone encountered any other problems as DBAs or Developers? Regards Bhavesh -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bhavesh Lala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle 9i and connect as sys
It's the new way, the INN thing. -Original Message- Sent: Saturday, August 16, 2003 10:29 PM To: Multiple recipients of list ORACLE-L I have created my first 9i database on OS/390 v2.10. On my Oracle 8i instance, I can connect to the database using: sys/[EMAIL PROTECTED] HOWEVER, In Oracle 9i, I cannot do this. I am FORCED to connect using: sys/[EMAIL PROTECTED] as sysdba I was wondering if this was a new 9i "feature" or if it was configurable? Or just a weird thing because of the mainframe environment. Comments please. Thanks in Advance - Babette -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Babette Turner-Underwood INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Luis deUrioste INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle 9i and connect as sys
The security is not as bad as it sounds. The patch is to release major software and the user gets prompted to enter the password. It is not stored any place (just UNIX variables during the running of the release). The software upgrades are released once every six months to year. Not all patches require SYS access. Only in earlier releases that granted access to SYS. However, when I build a new environment, I needed to run through the entire set of patches. Even if I use SYSTEM to grant access to SYS objects, I would need to go back and change the scripts to refer to SYS objects instead of currently connected users. And we are not supposed to go back and change scripts that have been released already :-( But we are migrating all of the application to the mainframe and none of the original release scripts will work soon any way :-( At least as part of the move, we have been going through getting rid of the public synonyms and public grants the previous DBA put in place :-) I will have to try that GRANT ANY OBJECT PRIVILEGE and let you know how it goes. - BAbette -Original Message- Tim Gorman Sent: Sunday, August 17, 2003 11:39 PM To: Multiple recipients of list ORACLE-L Babette, This is how database security unravels. Pretty soon, the password to SYS is embedded everywhere, used everywhere, and everyone knows it. Thus, the DBA ends up with the pager and responsibility for fixing stuff, but everyone else can cause that pager to go off with a stupid goof at 3:00am where they shouldn't have been able to goof up. It sounds like the patching utility only needs a couple privileges, but instead all of the goddess-like privileges of SYS are provided. Pretty soon, it seems normal for people and programs to connect as SYS on a regular basis. And so it goes... A couple alternatives: * use 9i "GRANT ANY OBJECT PRIVILEGE" to let another account have an incredible amount of authority, which is OK if you don't know exactly what permissions will be needed ahead of time... * grant specific permissions WITH GRANT OPTION to another user, a more focused approach than the shotgun "GRANT ANY OBJECT PRIVILEGE" approach, provided you know what permissions will be needed ahead of time. This has been around forever... * encapsulate such actions within a stored procedure owed by SYS, which may seem cumbersome but allows all kinds of control. Not just "who can do what" (which is basically what permissions and roles provide), but also "during what time", "from where", "from what program", "from what location", etc... Just this Friday, I was wrapping up an installation engagement and one of the last things we did was change all the passwords. Standard practice. Immediately, one of the development managers comes boiling out of his office screaming "Who changed the passwords to SYS and SYSTEM?". I 'fessed up and asked him why he thought he needed it. He turned red and snarled that he just needed it and never you mind, turned on his heel and went in the CIO's office, then came boiling back with approval. We turned it over, and within 5 minutes I logged back onto the system and saw SQL*Plus running with the SYS/SYSTEM password visible to anyone and everyone who can run the UNIX "ps" command. I looked at the scripts he was running, noticed that all he wanted SYS/SYSTEM for was to create PUBLIC SYNONYMs. I left to catch my plane... Hope this helps... -Tim on 8/17/03 6:09 PM, Babette Turner-Underwood at [EMAIL PROTECTED] wrote: > Tim / Peter / Michael > > Thanks for the information. I was afraid of that. > We have a patching mechanism and need to logon as > sys to grant access to sys objects for part of > the process. (to grant select on sys.dba_free_space > and execute on sys.dbms_util). > > However, the patching mechanism only does a regular > connect and not "as sysdba"--- DARN! - Will have to > change automation scripts if we upgrade ... and I was > hoping this would be easy to slide in :-( > > - Babette > > -Original Message- > Tim Gorman > Sent: Sunday, August 17, 2003 1:09 AM > To: Multiple recipients of list ORACLE-L > > > It's a 9i thing, across all platforms. > > > > on 8/16/03 9:29 PM, Babette Turner-Underwood at [EMAIL PROTECTED] wrote: > >> >> I have created my first 9i database on OS/390 v2.10. >> >> On my Oracle 8i instance, I can connect to the database >> using: >> >> sys/[EMAIL PROTECTED] >> >> HOWEVER, In Oracle 9i, I cannot do this. I am FORCED >> >> to connect using: >> sys/[EMAIL PROTECTED] as sysdba >> >> I was wondering if this was a new 9i "feature" >> or if it was configurable? Or just a weird thi
Re: Oracle 9i and connect as sys
Hi! Note that if you set your init.ora parameter o7_dictionary_accessibility to true, then you can connect as sys *without* sysdba or sysoper. But setting this parameter to true (old behaviour) isn't a good idea anymore, but might work for patching & maintenance type of work. Tanel. - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Sunday, August 17, 2003 7:29 AM > > I have created my first 9i database on OS/390 v2.10. > > On my Oracle 8i instance, I can connect to the database > using: > > sys/[EMAIL PROTECTED] > > HOWEVER, In Oracle 9i, I cannot do this. I am FORCED > > to connect using: > sys/[EMAIL PROTECTED] as sysdba > > I was wondering if this was a new 9i "feature" > or if it was configurable? Or just a weird thing > because of the mainframe environment. > > Comments please. > > Thanks in Advance > - Babette > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Babette Turner-Underwood > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle 9i and connect as sys
First off, you should not be connecting as sys on a regular basis, so making it harder is a good thing. Makes us think about what we're doing. Anyway, my experience is that whenever you want to connect as SYS you have to do so AS SYSDBA. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Sunday, August 17, 2003 12:29 AM To: Multiple recipients of list ORACLE-L I have created my first 9i database on OS/390 v2.10. On my Oracle 8i instance, I can connect to the database using: sys/[EMAIL PROTECTED] HOWEVER, In Oracle 9i, I cannot do this. I am FORCED to connect using: sys/[EMAIL PROTECTED] as sysdba I was wondering if this was a new 9i "feature" or if it was configurable? Or just a weird thing because of the mainframe environment. Comments please. Thanks in Advance - Babette -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Babette Turner-Underwood INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Goulet, Dick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Oracle 9i and connect as sys
CREATE PUBLIC SYNONYM is a permission I'll give away freely, even to a PHB. It's DROP PUBLIC SYNONYM that really needs some thought... Installing Oracle in a shop that has never used UNIX or Oracle before is never cheap, whether I do it or not. This particular shop was OpenVMS/Ingres coming into Solaris/Oracle, so the real expense will come after their current staff is fully retrained and discovers Monster.com... on 8/17/03 9:19 PM, Mladen Gogala at [EMAIL PROTECTED] wrote: > > On 2003.08.17 23:39, Tim Gorman wrote: >> Babette, > >> >> Just this Friday, I was wrapping up an installation engagement and one of >> the last things we did was change all the passwords. Standard practice. >> Immediately, one of the development managers comes boiling out of his office >> screaming "Who changed the passwords to SYS and SYSTEM?". I 'fessed up and >> asked him why he thought he needed it. He turned red and snarled that he >> just needed it and never you mind, turned on his heel and went in the CIO's >> office, then came boiling back with approval. We turned it over, and within >> 5 minutes I logged back onto the system and saw SQL*Plus running with the >> SYS/SYSTEM password visible to anyone and everyone who can run the UNIX "ps" >> command. I looked at the scripts he was running, noticed that all he wanted >> SYS/SYSTEM for was to create PUBLIC SYNONYMs. I left to catch my plane... > > I have a myriad of similar war stories. The best reaction is to collect them > and share with this email list. The company name should, of course, be kept > confidential, but we all know the PHB type of manager. Of course, having a > manager create public synonyms on your database is, in itslef, a recipy for > disaster. Next time something goes wrong, they'll have to buy you a 1st class > ticket to your plane. I don't imagine that having Tim Gorman himself install > your database comes in cheap > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tim Gorman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Oracle 9i and connect as sys
A manager who has to create public synonyms himself! Ordinarily I would have had nothing but pure respect for the man who is obviously such a grease monkey; but he proved to be just a monkey. Damagement title with sys password; boy how I hate to be DBA there! No, to be _anything_ there. Arup Nanda - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Sunday, August 17, 2003 11:39 PM > Babette, > > This is how database security unravels. Pretty soon, the password to SYS is > embedded everywhere, used everywhere, and everyone knows it. Thus, the DBA > ends up with the pager and responsibility for fixing stuff, but everyone > else can cause that pager to go off with a stupid goof at 3:00am where they > shouldn't have been able to goof up. > > It sounds like the patching utility only needs a couple privileges, but > instead all of the goddess-like privileges of SYS are provided. Pretty > soon, it seems normal for people and programs to connect as SYS on a regular > basis. And so it goes... > > A couple alternatives: > > * use 9i "GRANT ANY OBJECT PRIVILEGE" to let another account have > an incredible amount of authority, which is OK if you don't know > exactly what permissions will be needed ahead of time... > * grant specific permissions WITH GRANT OPTION to another user, a > more focused approach than the shotgun "GRANT ANY OBJECT PRIVILEGE" > approach, provided you know what permissions will be needed ahead > of time. This has been around forever... > * encapsulate such actions within a stored procedure owed by SYS, > which may seem cumbersome but allows all kinds of control. Not just > "who can do what" (which is basically what permissions and roles > provide), but also "during what time", "from where", "from what > program", "from what location", etc... > > Just this Friday, I was wrapping up an installation engagement and one of > the last things we did was change all the passwords. Standard practice. > Immediately, one of the development managers comes boiling out of his office > screaming "Who changed the passwords to SYS and SYSTEM?". I 'fessed up and > asked him why he thought he needed it. He turned red and snarled that he > just needed it and never you mind, turned on his heel and went in the CIO's > office, then came boiling back with approval. We turned it over, and within > 5 minutes I logged back onto the system and saw SQL*Plus running with the > SYS/SYSTEM password visible to anyone and everyone who can run the UNIX "ps" > command. I looked at the scripts he was running, noticed that all he wanted > SYS/SYSTEM for was to create PUBLIC SYNONYMs. I left to catch my plane... > > Hope this helps... > > -Tim > > > > on 8/17/03 6:09 PM, Babette Turner-Underwood at [EMAIL PROTECTED] wrote: > > > Tim / Peter / Michael > > > > Thanks for the information. I was afraid of that. > > We have a patching mechanism and need to logon as > > sys to grant access to sys objects for part of > > the process. (to grant select on sys.dba_free_space > > and execute on sys.dbms_util). > > > > However, the patching mechanism only does a regular > > connect and not "as sysdba"--- DARN! - Will have to > > change automation scripts if we upgrade ... and I was > > hoping this would be easy to slide in :-( > > > > - Babette > > > > -Original Message- > > Tim Gorman > > Sent: Sunday, August 17, 2003 1:09 AM > > To: Multiple recipients of list ORACLE-L > > > > > > It's a 9i thing, across all platforms. > > > > > > > > on 8/16/03 9:29 PM, Babette Turner-Underwood at [EMAIL PROTECTED] wrote: > > > >> > >> I have created my first 9i database on OS/390 v2.10. > >> > >> On my Oracle 8i instance, I can connect to the database > >> using: > >> > >> sys/[EMAIL PROTECTED] > >> > >> HOWEVER, In Oracle 9i, I cannot do this. I am FORCED > >> > >> to connect using: > >> sys/[EMAIL PROTECTED] as sysdba > >> > >> I was wondering if this was a new 9i "feature" > >> or if it was configurable? Or just a weird thing > >> because of the mainframe environment. > >> > >> Comments please. > >> > >> Thanks in Advance > >> - Babette > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Tim Gorman > INET: [EMAIL PROTECTED] > >
Re: Oracle 9i and connect as sys
On 2003.08.17 23:39, Tim Gorman wrote: Babette, Just this Friday, I was wrapping up an installation engagement and one of the last things we did was change all the passwords. Standard practice. Immediately, one of the development managers comes boiling out of his office screaming "Who changed the passwords to SYS and SYSTEM?". I 'fessed up and asked him why he thought he needed it. He turned red and snarled that he just needed it and never you mind, turned on his heel and went in the CIO's office, then came boiling back with approval. We turned it over, and within 5 minutes I logged back onto the system and saw SQL*Plus running with the SYS/SYSTEM password visible to anyone and everyone who can run the UNIX "ps" command. I looked at the scripts he was running, noticed that all he wanted SYS/SYSTEM for was to create PUBLIC SYNONYMs. I left to catch my plane... I have a myriad of similar war stories. The best reaction is to collect them and share with this email list. The company name should, of course, be kept confidential, but we all know the PHB type of manager. Of course, having a manager create public synonyms on your database is, in itslef, a recipy for disaster. Next time something goes wrong, they'll have to buy you a 1st class ticket to your plane. I don't imagine that having Tim Gorman himself install your database comes in cheap -- Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Oracle 9i and connect as sys
Babette, This is how database security unravels. Pretty soon, the password to SYS is embedded everywhere, used everywhere, and everyone knows it. Thus, the DBA ends up with the pager and responsibility for fixing stuff, but everyone else can cause that pager to go off with a stupid goof at 3:00am where they shouldn't have been able to goof up. It sounds like the patching utility only needs a couple privileges, but instead all of the goddess-like privileges of SYS are provided. Pretty soon, it seems normal for people and programs to connect as SYS on a regular basis. And so it goes... A couple alternatives: * use 9i "GRANT ANY OBJECT PRIVILEGE" to let another account have an incredible amount of authority, which is OK if you don't know exactly what permissions will be needed ahead of time... * grant specific permissions WITH GRANT OPTION to another user, a more focused approach than the shotgun "GRANT ANY OBJECT PRIVILEGE" approach, provided you know what permissions will be needed ahead of time. This has been around forever... * encapsulate such actions within a stored procedure owed by SYS, which may seem cumbersome but allows all kinds of control. Not just "who can do what" (which is basically what permissions and roles provide), but also "during what time", "from where", "from what program", "from what location", etc... Just this Friday, I was wrapping up an installation engagement and one of the last things we did was change all the passwords. Standard practice. Immediately, one of the development managers comes boiling out of his office screaming "Who changed the passwords to SYS and SYSTEM?". I 'fessed up and asked him why he thought he needed it. He turned red and snarled that he just needed it and never you mind, turned on his heel and went in the CIO's office, then came boiling back with approval. We turned it over, and within 5 minutes I logged back onto the system and saw SQL*Plus running with the SYS/SYSTEM password visible to anyone and everyone who can run the UNIX "ps" command. I looked at the scripts he was running, noticed that all he wanted SYS/SYSTEM for was to create PUBLIC SYNONYMs. I left to catch my plane... Hope this helps... -Tim on 8/17/03 6:09 PM, Babette Turner-Underwood at [EMAIL PROTECTED] wrote: > Tim / Peter / Michael > > Thanks for the information. I was afraid of that. > We have a patching mechanism and need to logon as > sys to grant access to sys objects for part of > the process. (to grant select on sys.dba_free_space > and execute on sys.dbms_util). > > However, the patching mechanism only does a regular > connect and not "as sysdba"--- DARN! - Will have to > change automation scripts if we upgrade ... and I was > hoping this would be easy to slide in :-( > > - Babette > > -Original Message- > Tim Gorman > Sent: Sunday, August 17, 2003 1:09 AM > To: Multiple recipients of list ORACLE-L > > > It's a 9i thing, across all platforms. > > > > on 8/16/03 9:29 PM, Babette Turner-Underwood at [EMAIL PROTECTED] wrote: > >> >> I have created my first 9i database on OS/390 v2.10. >> >> On my Oracle 8i instance, I can connect to the database >> using: >> >> sys/[EMAIL PROTECTED] >> >> HOWEVER, In Oracle 9i, I cannot do this. I am FORCED >> >> to connect using: >> sys/[EMAIL PROTECTED] as sysdba >> >> I was wondering if this was a new 9i "feature" >> or if it was configurable? Or just a weird thing >> because of the mainframe environment. >> >> Comments please. >> >> Thanks in Advance >> - Babette -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tim Gorman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Oracle 9i and connect as sys
Babette, You can still achieve the objective using SYSTEM, which does not require a SYSDBA connection. Or for that matter any user with DBA role. The trick is a new privilege named "grant any object privilege"; any user with that privilege can grant anything on objects owned by other schema. If you don't want to use SYSTEM for this, you could create a special user and grant only that system privilege directly to it. Hope this helps. Arup Nanda - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Sunday, August 17, 2003 9:09 PM > Tim / Peter / Michael > > Thanks for the information. I was afraid of that. > We have a patching mechanism and need to logon as > sys to grant access to sys objects for part of > the process. (to grant select on sys.dba_free_space > and execute on sys.dbms_util). > > However, the patching mechanism only does a regular > connect and not "as sysdba"--- DARN! - Will have to > change automation scripts if we upgrade ... and I was > hoping this would be easy to slide in :-( > > - Babette > > -Original Message- > Tim Gorman > Sent: Sunday, August 17, 2003 1:09 AM > To: Multiple recipients of list ORACLE-L > > > It's a 9i thing, across all platforms. > > > > on 8/16/03 9:29 PM, Babette Turner-Underwood at [EMAIL PROTECTED] wrote: > > > > > I have created my first 9i database on OS/390 v2.10. > > > > On my Oracle 8i instance, I can connect to the database > > using: > > > > sys/[EMAIL PROTECTED] > > > > HOWEVER, In Oracle 9i, I cannot do this. I am FORCED > > > > to connect using: > > sys/[EMAIL PROTECTED] as sysdba > > > > I was wondering if this was a new 9i "feature" > > or if it was configurable? Or just a weird thing > > because of the mainframe environment. > > > > Comments please. > > > > Thanks in Advance > > - Babette > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Tim Gorman > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Babette Turner-Underwood > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (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: Arup Nanda INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Oracle 9i and connect as sys
Well, you don't need to log on as sys to do that. There is a new privilege in 9i (granted to DBA role, of course) called "GRANT ANY OBJECT PRIVILEGE", which enables the DBA to grant object privileges on objects belonging to other user. You can easily log in as "system" and grant select on sys.dba_views or whatever other table you need to grant. On 2003.08.17 21:09, Babette Turner-Underwood wrote: Tim / Peter / Michael Thanks for the information. I was afraid of that. We have a patching mechanism and need to logon as sys to grant access to sys objects for part of the process. (to grant select on sys.dba_free_space and execute on sys.dbms_util). However, the patching mechanism only does a regular connect and not "as sysdba"--- DARN! - Will have to change automation scripts if we upgrade ... and I was hoping this would be easy to slide in :-( - Babette -Original Message- Tim Gorman Sent: Sunday, August 17, 2003 1:09 AM To: Multiple recipients of list ORACLE-L It's a 9i thing, across all platforms. on 8/16/03 9:29 PM, Babette Turner-Underwood at [EMAIL PROTECTED] wrote: > > I have created my first 9i database on OS/390 v2.10. > > On my Oracle 8i instance, I can connect to the database > using: > > sys/[EMAIL PROTECTED] > > HOWEVER, In Oracle 9i, I cannot do this. I am FORCED > > to connect using: > sys/[EMAIL PROTECTED] as sysdba > > I was wondering if this was a new 9i "feature" > or if it was configurable? Or just a weird thing > because of the mainframe environment. > > Comments please. > > Thanks in Advance > - Babette -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tim Gorman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Babette Turner-Underwood INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle 9i and connect as sys
Tim / Peter / Michael Thanks for the information. I was afraid of that. We have a patching mechanism and need to logon as sys to grant access to sys objects for part of the process. (to grant select on sys.dba_free_space and execute on sys.dbms_util). However, the patching mechanism only does a regular connect and not "as sysdba"--- DARN! - Will have to change automation scripts if we upgrade ... and I was hoping this would be easy to slide in :-( - Babette -Original Message- Tim Gorman Sent: Sunday, August 17, 2003 1:09 AM To: Multiple recipients of list ORACLE-L It's a 9i thing, across all platforms. on 8/16/03 9:29 PM, Babette Turner-Underwood at [EMAIL PROTECTED] wrote: > > I have created my first 9i database on OS/390 v2.10. > > On my Oracle 8i instance, I can connect to the database > using: > > sys/[EMAIL PROTECTED] > > HOWEVER, In Oracle 9i, I cannot do this. I am FORCED > > to connect using: > sys/[EMAIL PROTECTED] as sysdba > > I was wondering if this was a new 9i "feature" > or if it was configurable? Or just a weird thing > because of the mainframe environment. > > Comments please. > > Thanks in Advance > - Babette -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tim Gorman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Babette Turner-Underwood INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle 9i and connect as sys
In Oracle9i, SYS requires connecting as a privileged user using the sysdba parameter. This is equivalent to "connect internal" in Oracle8i which is now obsolete in Oracle9i. -Original Message- Sent: Sunday, August 17, 2003 12:29 AM To: Multiple recipients of list ORACLE-L I have created my first 9i database on OS/390 v2.10. On my Oracle 8i instance, I can connect to the database using: sys/[EMAIL PROTECTED] HOWEVER, In Oracle 9i, I cannot do this. I am FORCED to connect using: sys/[EMAIL PROTECTED] as sysdba I was wondering if this was a new 9i "feature" or if it was configurable? Or just a weird thing because of the mainframe environment. Comments please. Thanks in Advance - Babette -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Babette Turner-Underwood INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Rothouse, Michael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Oracle 9i and connect as sys
Hi Babette This is a feature of 9i. using SYS you have to always use "as sysdba " same thing on Windows and Solaris at least and I am sure it is all other OS's Cheers -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238 Facsimile: +61 (0)7 3303 3048 = "If people did not sometimes do silly things, nothing intelligent would ever get done." - Ludwig Wittgenstein = Mincom "The People, The Experience, The Vision" = This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please delete it and notify the sender. The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Group of companies unless expressly stated otherwise. "Babette Turner-Underwood" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 17-08-2003 02:29 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:Oracle 9i and connect as sys I have created my first 9i database on OS/390 v2.10. On my Oracle 8i instance, I can connect to the database using: sys/[EMAIL PROTECTED] HOWEVER, In Oracle 9i, I cannot do this. I am FORCED to connect using: sys/[EMAIL PROTECTED] as sysdba I was wondering if this was a new 9i "feature" or if it was configurable? Or just a weird thing because of the mainframe environment. Comments please. Thanks in Advance - Babette -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Babette Turner-Underwood INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Oracle 9i and connect as sys
It's a 9i thing, across all platforms. on 8/16/03 9:29 PM, Babette Turner-Underwood at [EMAIL PROTECTED] wrote: > > I have created my first 9i database on OS/390 v2.10. > > On my Oracle 8i instance, I can connect to the database > using: > > sys/[EMAIL PROTECTED] > > HOWEVER, In Oracle 9i, I cannot do this. I am FORCED > > to connect using: > sys/[EMAIL PROTECTED] as sysdba > > I was wondering if this was a new 9i "feature" > or if it was configurable? Or just a weird thing > because of the mainframe environment. > > Comments please. > > Thanks in Advance > - Babette -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tim Gorman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Oracle 9i and connect as sys
I have created my first 9i database on OS/390 v2.10. On my Oracle 8i instance, I can connect to the database using: sys/[EMAIL PROTECTED] HOWEVER, In Oracle 9i, I cannot do this. I am FORCED to connect using: sys/[EMAIL PROTECTED] as sysdba I was wondering if this was a new 9i "feature" or if it was configurable? Or just a weird thing because of the mainframe environment. Comments please. Thanks in Advance - Babette -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Babette Turner-Underwood INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Object programming with Oracle 9i
hi object/relational developers Please bear with me if I am not using the right terminology. Am intending on using java to access to the underlying relational tables. Was thinking of exposing the database to java using Object views over the relational views. Trying to isolate the complexity of data access in the DB from the developers. The questions I have are 1. Updating DB using a java obj I know it is possible to do the following: UPDATE Addr set street = JObj.street, city = JObj.city But can you do something like UPDATE Addr set Addr value = JObj 2. Updating only dirty data Given an object , is it possible to update the database with only dirty data without comparing every attribute/column and traversing thru the object? Any comments or help is appreciated. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Comparison between Oracle 9i SE & SqlServer 2000 SE
Arif What are you trying to compare? Features? My guess is what you'll have to do is find an Oracle9i vs. SQL Server 2K comparison, then carefully study each company's documents on what is removed from their enterprise version. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, August 08, 2003 4:40 PM To: Multiple recipients of list ORACLE-L Hello fellow Oraclers, Has any of you done a comparison study on Oracle 9i SE & Sql Server 2000 SE??? If yes, will it be possible for you to share your findings with me. In case any of you know of a web link that provides an unbiased comparison study that too would be wonderful if you could send me the link. Thanks Arif -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Arif Khan (GWL) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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).
Comparison between Oracle 9i SE & SqlServer 2000 SE
Hello fellow Oraclers, Has any of you done a comparison study on Oracle 9i SE & Sql Server 2000 SE??? If yes, will it be possible for you to share your findings with me. In case any of you know of a web link that provides an unbiased comparison study that too would be wonderful if you could send me the link. Thanks Arif -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Arif Khan (GWL) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle 9i refuses to allow client connection -- I need
Stephen Technet (aka. otn) is good, but sometimes it helps to have a book help you get started. Consider picking up a copy of Oracle9i DBA 101. http://www.amazon.com/exec/obidos/tg/detail/-/0072224746/qid=1059408389/sr=8 -1/ref=sr_8_1/002-8977984-5541669?v=glance&s=books&n=507846 Don't worry too much about Windows vs. Unix. There is very little with Oracle that is Windows or Unix specific. Most of the differences relate to file naming and starting/stopping the instance. Pretty much any of the books give you the syntax for each system where there is a difference. Actually, you are probably fortunate with your training being delayed for a few months. The class covers so much in a few days that if you are really new to Oracle it is hard to comprehend everything. By messing with it for a few months, the class will make a lot more sense. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- [mailto:[EMAIL PROTECTED] Sent: Monday, July 28, 2003 7:12 AM To: Multiple recipients of list ORACLE-L v/r Thanks for the encouragement and yes I would like to know some of the good Oracle 101 under a windows environment books. I'm pretty certain that my approved training will be funded with year-end money, but that means the earliest I'll get to class is in late October or early November. Hope you don't mind me bugging you all a while until I get squared away. Stephen S. Wolfe, GS-11, DAFC Data Services Manager [EMAIL PROTECTED] (813) 827-9974 DSN 651-9974 > -Original Message- > From: Ron Rogers [mailto:[EMAIL PROTECTED] > Sent: Friday, July 25, 2003 10:59 AM > To: Multiple recipients of list ORACLE-L > Subject: Re: Oracle 9i refuses to allow client connection -- I need > > > Stephen, > I also would like to extend a warm welcome to the world of > Oracle. I hope that you find it interesting and challenging > and rewarding. > I would suggest that you get a head start on your training > so you won't be overwhelmed when you attend, by acquiring > some of the "Oracle 101" books that are available on the > market. They are a valuable resource that I refer to > constantly as I can't remember as much as I use to. > I don't mean to slight any of the excellent authors that > are on this list by not listing their works here. I am sure > that if you asked for references you will be supplied with a > list that will be quite complete and up to date. Again, > Welcome. Ron mª¿ªm > > >>> [EMAIL PROTECTED] 07/25/03 08:59AM >>> > there are a number of logs that could help: > > first, does the application itself generate a log? If so, > does that log reflect the actual error returned? It might > look something like "ORA-nn" > > Second, on the Windows Box itself, look for a file name > "alert.log" (I'm not that familiar with Oracle's > configuration on Windows as I run Unix but it should look > something like that). Look to see if there are any error > messages in that file at the time the connections are refused. > > If increasing memory on the box itself helped, it's likely > that what's happening is that users are connecting to the > box, never dropping or closing the connections so that memory > stays allocated. The box runs out of memory, you reboot > (closing the connections and releasing the > memory) and you are good for another week or so. > > if that's what's happening -- you either have to get the > users to LOG OFF (yeah, right) or find a way of > closing/killing the connections after x amount of time (look > into the online docs -- technet.oracle.com, specifically look > at the network manuals). > > and welcome! It's always nice to see a new face here, > especially one who is willing to LEARN > > --- Wolfe Stephen S GS-11 6 MDSS/SGSI <[EMAIL PROTECTED]> > wrote: > > I'm an Oracle administrator-To-Be, I'm awaiting funding for the > basic > > Oracle DBA courses, the > > training has been approved, just hasn't been funded. > > > > Anyway, the only things I do are add, modify, and reset application > > users' password via EM and run patching scripts via SQL-Plus. The > > application I have running on this > > particular 9i server is TPOCS, > > Third Party Outpatient Collection System -- a billing system for the > > DoD's Military Health System (MHS). > > Oracle 9i is running on a Windows 2000 server. > > > > Anyway, the TPOCS client is a PowerBuilder client and connects via > > SQL-Net -- I'm still learning about that mechanism. Here's my > > problem. Occasionally, Oracle refuse
RE: RE: Oracle 9i refuses to allow client connection -- I need
Thanks! I'll start perusing the sites right away. v/r Stephen S. Wolfe, GS-11, DAFC Data Services Manager [EMAIL PROTECTED] (813) 827-9974 DSN 651-9974 > -Original Message- > From: Ron Rogers [mailto:[EMAIL PROTECTED] > Sent: Monday, July 28, 2003 10:39 AM > To: Multiple recipients of list ORACLE-L > Subject: RE: RE: Oracle 9i refuses to allow client connection > -- I need > > > Stephen. > OTN is the abbreviation for Oracle Technology Network > http://otn.oracle.com/. It is a source and startup point for > documentation, software , news, and other Oracle related > "stuff". I would surf the site to see what is available for > the Oracle applications you have and to locate the > documentation that you might need. I would also suggest that > you get a MetaLink account http://metalink.oracle.com. > Metalink is the Oracle site where an Oracle answered forums > exist, patches reside, certifications is listed, ITAR's are > created, etc. If you have an Oracle support contract you > should have access to the MetaLink site without any problems. Ron > > >>> [EMAIL PROTECTED] 07/28/03 10:09AM >>> > Please excuse the ignorance but what is an otn document? I > have three Oracle based applications here and each one was > delivered without any documentation. > > v/r > > Stephen S. Wolfe, GS-11, DAFC > Data Services Manager > [EMAIL PROTECTED] > (813) 827-9974 DSN 651-9974 > > > > > -Original Message- > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > > Sent: Monday, July 28, 2003 9:24 AM > > To: Multiple recipients of list ORACLE-L > > Subject: Re: RE: Oracle 9i refuses to allow client connection > > -- I need > > > > > > the otn document for administering oracle on windows is > > pretty solid. the book includes most of that stuff plus some > > fo the gui tools. > > > > > > From: "Wolfe Stephen S GS-11 6 MDSS/SGSI" > > > <[EMAIL PROTECTED]> > > > Date: 2003/07/28 Mon AM 08:11:32 EDT > > > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > > > Subject: RE: Oracle 9i refuses to allow client connection -- I > need > > > > > > > > > > > > v/r > > > Thanks for the encouragement and yes I would like to know > > some of the > > > good Oracle 101 under a windows environment books. I'm > > pretty certain > > > that my approved training will be funded with year-end > > money, but that > > > means the earliest I'll get to class is in late October or early > > > November. > > > > > > Hope you don't mind me bugging you all a while until I get squared > > > > away. > > > > > > Stephen S. Wolfe, GS-11, DAFC > > > Data Services Manager > > > [EMAIL PROTECTED] > > > (813) 827-9974 DSN 651-9974 > > > > > > > > > > > > > -Original Message- > > > > From: Ron Rogers [mailto:[EMAIL PROTECTED] > > > > Sent: Friday, July 25, 2003 10:59 AM > > > > To: Multiple recipients of list ORACLE-L > > > > Subject: Re: Oracle 9i refuses to allow client connection > > -- I need > > > > > > > > > > > > Stephen, > > > > I also would like to extend a warm welcome to the world of > > > > Oracle. I hope that you find it interesting and challenging and > > > > rewarding. > > > > I would suggest that you get a head start on your training > > > > so you won't be overwhelmed when you attend, by acquiring > > > > some of the "Oracle 101" books that are available on the > > > > market. They are a valuable resource that I refer to > > > > constantly as I can't remember as much as I use to. > > > > I don't mean to slight any of the excellent authors that > > > > are on this list by not listing their works here. I am sure > > > > that if you asked for references you will be supplied with a > > > > list that will be quite complete and up to date. Again, > > > > Welcome. Ron mª¿ªm > > > > > > > > >>> [EMAIL PROTECTED] 07/25/03 08:59AM >>> > > > > there are a number of logs that could help: > > > > > > > > first, does the application itself generate a log? If so, does > > > > that log reflect the actual error returned? It might look > > > > something like "ORA-nn" > >
RE: RE: Oracle 9i refuses to allow client connection -- I need
Stephen. OTN is the abreviation for Oracle Technology Network http://otn.oracle.com/. It is a source and startup point for documentation, softrare , news, and other Oracle related "stuff". I would surf the site to see what is available for the Oracle applications you have and to locate the documentation that you might need. I would also suggest that you get a MetaLink account http://metalink.oracle.com. Metalink is the Oracle site where an Oracle answered forums exist, patches reside, cetrification is listed, ITAR's are created, etc. If you have an Oracle support contract you should have access to the MetaLink site without any problems. Ron >>> [EMAIL PROTECTED] 07/28/03 10:09AM >>> Please excuse the ignorance but what is an otn document? I have three Oracle based applications here and each one was delivered without any documentation. v/r Stephen S. Wolfe, GS-11, DAFC Data Services Manager [EMAIL PROTECTED] (813) 827-9974 DSN 651-9974 > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: Monday, July 28, 2003 9:24 AM > To: Multiple recipients of list ORACLE-L > Subject: Re: RE: Oracle 9i refuses to allow client connection > -- I need > > > the otn document for administering oracle on windows is > pretty solid. the book includes most of that stuff plus some > fo the gui tools. > > > > From: "Wolfe Stephen S GS-11 6 MDSS/SGSI" > > <[EMAIL PROTECTED]> > > Date: 2003/07/28 Mon AM 08:11:32 EDT > > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > > Subject: RE: Oracle 9i refuses to allow client connection -- I need > > > > > > > > v/r > > Thanks for the encouragement and yes I would like to know > some of the > > good Oracle 101 under a windows environment books. I'm > pretty certain > > that my approved training will be funded with year-end > money, but that > > means the earliest I'll get to class is in late October or early > > November. > > > > Hope you don't mind me bugging you all a while until I get squared > > away. > > > > Stephen S. Wolfe, GS-11, DAFC > > Data Services Manager > > [EMAIL PROTECTED] > > (813) 827-9974 DSN 651-9974 > > > > > > > > > -Original Message- > > > From: Ron Rogers [mailto:[EMAIL PROTECTED] > > > Sent: Friday, July 25, 2003 10:59 AM > > > To: Multiple recipients of list ORACLE-L > > > Subject: Re: Oracle 9i refuses to allow client connection > -- I need > > > > > > > > > Stephen, > > > I also would like to extend a warm welcome to the world of > > > Oracle. I hope that you find it interesting and challenging > > > and rewarding. > > > I would suggest that you get a head start on your training > > > so you won't be overwhelmed when you attend, by acquiring > > > some of the "Oracle 101" books that are available on the > > > market. They are a valuable resource that I refer to > > > constantly as I can't remember as much as I use to. > > > I don't mean to slight any of the excellent authors that > > > are on this list by not listing their works here. I am sure > > > that if you asked for references you will be supplied with a > > > list that will be quite complete and up to date. Again, > > > Welcome. Ron mª¿ªm > > > > > > >>> [EMAIL PROTECTED] 07/25/03 08:59AM >>> > > > there are a number of logs that could help: > > > > > > first, does the application itself generate a log? If so, > > > does that log reflect the actual error returned? It might > > > look something like "ORA-nn" > > > > > > Second, on the Windows Box itself, look for a file name > > > "alert.log" (I'm not that familiar with Oracle's > > > configuration on Windows as I run Unix but it should look > > > something like that). Look to see if there are any error > > > messages in that file at the time the connections are refused. > > > > > > If increasing memory on the box itself helped, it's likely > > > that what's happening is that users are connecting to the > > > box, never dropping or closing the connections so that memory > > > stays allocated. The box runs out of memory, you reboot > > > (closing the connections and releasing the > > > memory) and you are good for another week or so. > > > > > > if that's what's happening -- you eith
RE: RE: Oracle 9i refuses to allow client connection -- I need
OTN is shorthand for Oracle Technical Network technet.oracle.com --- Wolfe Stephen S GS-11 6 MDSS/SGSI <[EMAIL PROTECTED]> wrote: > Please excuse the ignorance but what is an otn document? I have > three Oracle based applications here and each one was delivered > without any documentation. > > v/r > > Stephen S. Wolfe, GS-11, DAFC > Data Services Manager > [EMAIL PROTECTED] > (813) 827-9974 DSN 651-9974 > > > > > -Original Message- > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > > Sent: Monday, July 28, 2003 9:24 AM > > To: Multiple recipients of list ORACLE-L > > Subject: Re: RE: Oracle 9i refuses to allow client connection > > -- I need > > > > > > the otn document for administering oracle on windows is > > pretty solid. the book includes most of that stuff plus some > > fo the gui tools. > > > > > > From: "Wolfe Stephen S GS-11 6 MDSS/SGSI" > > > <[EMAIL PROTECTED]> > > > Date: 2003/07/28 Mon AM 08:11:32 EDT > > > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > > > Subject: RE: Oracle 9i refuses to allow client connection -- I > need > > > > > > > > > > > > v/r > > > Thanks for the encouragement and yes I would like to know > > some of the > > > good Oracle 101 under a windows environment books. I'm > > pretty certain > > > that my approved training will be funded with year-end > > money, but that > > > means the earliest I'll get to class is in late October or early > > > November. > > > > > > Hope you don't mind me bugging you all a while until I get > squared > > > away. > > > > > > Stephen S. Wolfe, GS-11, DAFC > > > Data Services Manager > > > [EMAIL PROTECTED] > > > (813) 827-9974 DSN 651-9974 > > > > > > > > > > > > > -Original Message- > > > > From: Ron Rogers [mailto:[EMAIL PROTECTED] > > > > Sent: Friday, July 25, 2003 10:59 AM > > > > To: Multiple recipients of list ORACLE-L > > > > Subject: Re: Oracle 9i refuses to allow client connection > > -- I need > > > > > > > > > > > > Stephen, > > > > I also would like to extend a warm welcome to the world of > > > > Oracle. I hope that you find it interesting and challenging > > > > and rewarding. > > > > I would suggest that you get a head start on your training > > > > so you won't be overwhelmed when you attend, by acquiring > > > > some of the "Oracle 101" books that are available on the > > > > market. They are a valuable resource that I refer to > > > > constantly as I can't remember as much as I use to. > > > > I don't mean to slight any of the excellent authors that > > > > are on this list by not listing their works here. I am sure > > > > that if you asked for references you will be supplied with a > > > > list that will be quite complete and up to date. Again, > > > > Welcome. Ron mª¿ªm > > > > > > > > >>> [EMAIL PROTECTED] 07/25/03 08:59AM >>> > > > > there are a number of logs that could help: > > > > > > > > first, does the application itself generate a log? If so, > > > > does that log reflect the actual error returned? It might > > > > look something like "ORA-nn" > > > > > > > > Second, on the Windows Box itself, look for a file name > > > > "alert.log" (I'm not that familiar with Oracle's > > > > configuration on Windows as I run Unix but it should look > > > > something like that). Look to see if there are any error > > > > messages in that file at the time the connections are refused. > > > > > > > > If increasing memory on the box itself helped, it's likely > > > > that what's happening is that users are connecting to the > > > > box, never dropping or closing the connections so that memory > > > > stays allocated. The box runs out of memory, you reboot > > > > (closing the connections and releasing the > > > > memory) and you are good for another week or so. > > > > > > > > if that's what's happening -- you either have to get the > > > > users to LOG OFF (yeah, right) or find a way
RE: RE: Oracle 9i refuses to allow client connection -- I need
Stephen Go to http://technet.oracle.com and register -- it's free. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- [mailto:[EMAIL PROTECTED] Sent: Monday, July 28, 2003 9:09 AM To: Multiple recipients of list ORACLE-L Please excuse the ignorance but what is an otn document? I have three Oracle based applications here and each one was delivered without any documentation. v/r Stephen S. Wolfe, GS-11, DAFC Data Services Manager [EMAIL PROTECTED] (813) 827-9974 DSN 651-9974 > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: Monday, July 28, 2003 9:24 AM > To: Multiple recipients of list ORACLE-L > Subject: Re: RE: Oracle 9i refuses to allow client connection > -- I need > > > the otn document for administering oracle on windows is > pretty solid. the book includes most of that stuff plus some > fo the gui tools. > > > > From: "Wolfe Stephen S GS-11 6 MDSS/SGSI" > > <[EMAIL PROTECTED]> > > Date: 2003/07/28 Mon AM 08:11:32 EDT > > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > > Subject: RE: Oracle 9i refuses to allow client connection -- I need > > > > > > > > v/r > > Thanks for the encouragement and yes I would like to know > some of the > > good Oracle 101 under a windows environment books. I'm > pretty certain > > that my approved training will be funded with year-end > money, but that > > means the earliest I'll get to class is in late October or early > > November. > > > > Hope you don't mind me bugging you all a while until I get squared > > away. > > > > Stephen S. Wolfe, GS-11, DAFC > > Data Services Manager > > [EMAIL PROTECTED] > > (813) 827-9974 DSN 651-9974 > > > > > > > > > -Original Message- > > > From: Ron Rogers [mailto:[EMAIL PROTECTED] > > > Sent: Friday, July 25, 2003 10:59 AM > > > To: Multiple recipients of list ORACLE-L > > > Subject: Re: Oracle 9i refuses to allow client connection > -- I need > > > > > > > > > Stephen, > > > I also would like to extend a warm welcome to the world of > > > Oracle. I hope that you find it interesting and challenging > > > and rewarding. > > > I would suggest that you get a head start on your training > > > so you won't be overwhelmed when you attend, by acquiring > > > some of the "Oracle 101" books that are available on the > > > market. They are a valuable resource that I refer to > > > constantly as I can't remember as much as I use to. > > > I don't mean to slight any of the excellent authors that > > > are on this list by not listing their works here. I am sure > > > that if you asked for references you will be supplied with a > > > list that will be quite complete and up to date. Again, > > > Welcome. Ron mª¿ªm > > > > > > >>> [EMAIL PROTECTED] 07/25/03 08:59AM >>> > > > there are a number of logs that could help: > > > > > > first, does the application itself generate a log? If so, > > > does that log reflect the actual error returned? It might > > > look something like "ORA-nn" > > > > > > Second, on the Windows Box itself, look for a file name > > > "alert.log" (I'm not that familiar with Oracle's > > > configuration on Windows as I run Unix but it should look > > > something like that). Look to see if there are any error > > > messages in that file at the time the connections are refused. > > > > > > If increasing memory on the box itself helped, it's likely > > > that what's happening is that users are connecting to the > > > box, never dropping or closing the connections so that memory > > > stays allocated. The box runs out of memory, you reboot > > > (closing the connections and releasing the > > > memory) and you are good for another week or so. > > > > > > if that's what's happening -- you either have to get the > > > users to LOG OFF (yeah, right) or find a way of > > > closing/killing the connections after x amount of time (look > > > into the online docs -- technet.oracle.com, specifically look > > > at the network manuals). > > > > > > and welcome! It's always nice to see a new face here, > > > especially one who is willing to LEARN > > > > > > --
RE: RE: Oracle 9i refuses to allow client connection -- I need
otn.oracle.com its where oracle keeps all its documents and downloads etc. www.oracle.com is the marketing. you have to register but its free. go to that site. On the left will be a link for documentation. Go to the 'database' documentaiton. Both 8i and 9i are there. Click books. There is a 'book' on ORacle for Windows'. > > From: "Wolfe Stephen S GS-11 6 MDSS/SGSI" <[EMAIL PROTECTED]> > Date: 2003/07/28 Mon AM 10:09:25 EDT > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > Subject: RE: RE: Oracle 9i refuses to allow client connection -- I need > > Please excuse the ignorance but what is an otn document? I have three Oracle based > applications here and each one was delivered without any documentation. > > v/r > > Stephen S. Wolfe, GS-11, DAFC > Data Services Manager > [EMAIL PROTECTED] > (813) 827-9974 DSN 651-9974 > > > > > -Original Message- > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > > Sent: Monday, July 28, 2003 9:24 AM > > To: Multiple recipients of list ORACLE-L > > Subject: Re: RE: Oracle 9i refuses to allow client connection > > -- I need > > > > > > the otn document for administering oracle on windows is > > pretty solid. the book includes most of that stuff plus some > > fo the gui tools. > > > > > > From: "Wolfe Stephen S GS-11 6 MDSS/SGSI" > > > <[EMAIL PROTECTED]> > > > Date: 2003/07/28 Mon AM 08:11:32 EDT > > > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > > > Subject: RE: Oracle 9i refuses to allow client connection -- I need > > > > > > > > > > > > v/r > > > Thanks for the encouragement and yes I would like to know > > some of the > > > good Oracle 101 under a windows environment books. I'm > > pretty certain > > > that my approved training will be funded with year-end > > money, but that > > > means the earliest I'll get to class is in late October or early > > > November. > > > > > > Hope you don't mind me bugging you all a while until I get squared > > > away. > > > > > > Stephen S. Wolfe, GS-11, DAFC > > > Data Services Manager > > > [EMAIL PROTECTED] > > > (813) 827-9974 DSN 651-9974 > > > > > > > > > > > > > -Original Message- > > > > From: Ron Rogers [mailto:[EMAIL PROTECTED] > > > > Sent: Friday, July 25, 2003 10:59 AM > > > > To: Multiple recipients of list ORACLE-L > > > > Subject: Re: Oracle 9i refuses to allow client connection > > -- I need > > > > > > > > > > > > Stephen, > > > > I also would like to extend a warm welcome to the world of > > > > Oracle. I hope that you find it interesting and challenging > > > > and rewarding. > > > > I would suggest that you get a head start on your training > > > > so you won't be overwhelmed when you attend, by acquiring > > > > some of the "Oracle 101" books that are available on the > > > > market. They are a valuable resource that I refer to > > > > constantly as I can't remember as much as I use to. > > > > I don't mean to slight any of the excellent authors that > > > > are on this list by not listing their works here. I am sure > > > > that if you asked for references you will be supplied with a > > > > list that will be quite complete and up to date. Again, > > > > Welcome. Ron mª¿ªm > > > > > > > > >>> [EMAIL PROTECTED] 07/25/03 08:59AM >>> > > > > there are a number of logs that could help: > > > > > > > > first, does the application itself generate a log? If so, > > > > does that log reflect the actual error returned? It might > > > > look something like "ORA-nn" > > > > > > > > Second, on the Windows Box itself, look for a file name > > > > "alert.log" (I'm not that familiar with Oracle's > > > > configuration on Windows as I run Unix but it should look > > > > something like that). Look to see if there are any error > > > > messages in that file at the time the connections are refused. > > > > > > > > If increasing memory on the box itself helped, it's likely > > > > that what's happening is that users are connecting to t
RE: RE: Oracle 9i refuses to allow client connection -- I need
Please excuse the ignorance but what is an otn document? I have three Oracle based applications here and each one was delivered without any documentation. v/r Stephen S. Wolfe, GS-11, DAFC Data Services Manager [EMAIL PROTECTED] (813) 827-9974 DSN 651-9974 > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: Monday, July 28, 2003 9:24 AM > To: Multiple recipients of list ORACLE-L > Subject: Re: RE: Oracle 9i refuses to allow client connection > -- I need > > > the otn document for administering oracle on windows is > pretty solid. the book includes most of that stuff plus some > fo the gui tools. > > > > From: "Wolfe Stephen S GS-11 6 MDSS/SGSI" > > <[EMAIL PROTECTED]> > > Date: 2003/07/28 Mon AM 08:11:32 EDT > > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > > Subject: RE: Oracle 9i refuses to allow client connection -- I need > > > > > > > > v/r > > Thanks for the encouragement and yes I would like to know > some of the > > good Oracle 101 under a windows environment books. I'm > pretty certain > > that my approved training will be funded with year-end > money, but that > > means the earliest I'll get to class is in late October or early > > November. > > > > Hope you don't mind me bugging you all a while until I get squared > > away. > > > > Stephen S. Wolfe, GS-11, DAFC > > Data Services Manager > > [EMAIL PROTECTED] > > (813) 827-9974 DSN 651-9974 > > > > > > > > > -Original Message- > > > From: Ron Rogers [mailto:[EMAIL PROTECTED] > > > Sent: Friday, July 25, 2003 10:59 AM > > > To: Multiple recipients of list ORACLE-L > > > Subject: Re: Oracle 9i refuses to allow client connection > -- I need > > > > > > > > > Stephen, > > > I also would like to extend a warm welcome to the world of > > > Oracle. I hope that you find it interesting and challenging > > > and rewarding. > > > I would suggest that you get a head start on your training > > > so you won't be overwhelmed when you attend, by acquiring > > > some of the "Oracle 101" books that are available on the > > > market. They are a valuable resource that I refer to > > > constantly as I can't remember as much as I use to. > > > I don't mean to slight any of the excellent authors that > > > are on this list by not listing their works here. I am sure > > > that if you asked for references you will be supplied with a > > > list that will be quite complete and up to date. Again, > > > Welcome. Ron mª¿ªm > > > > > > >>> [EMAIL PROTECTED] 07/25/03 08:59AM >>> > > > there are a number of logs that could help: > > > > > > first, does the application itself generate a log? If so, > > > does that log reflect the actual error returned? It might > > > look something like "ORA-nn" > > > > > > Second, on the Windows Box itself, look for a file name > > > "alert.log" (I'm not that familiar with Oracle's > > > configuration on Windows as I run Unix but it should look > > > something like that). Look to see if there are any error > > > messages in that file at the time the connections are refused. > > > > > > If increasing memory on the box itself helped, it's likely > > > that what's happening is that users are connecting to the > > > box, never dropping or closing the connections so that memory > > > stays allocated. The box runs out of memory, you reboot > > > (closing the connections and releasing the > > > memory) and you are good for another week or so. > > > > > > if that's what's happening -- you either have to get the > > > users to LOG OFF (yeah, right) or find a way of > > > closing/killing the connections after x amount of time (look > > > into the online docs -- technet.oracle.com, specifically look > > > at the network manuals). > > > > > > and welcome! It's always nice to see a new face here, > > > especially one who is willing to LEARN > > > > > > --- Wolfe Stephen S GS-11 6 MDSS/SGSI > <[EMAIL PROTECTED]> > > > wrote: > > > > I'm an Oracle administrator-To-Be, I'm awaiting funding for the > > > basic > > > > Oracle DBA courses, the > > > > training ha
Re: RE: Oracle 9i refuses to allow client connection -- I need
the otn document for administering oracle on windows is pretty solid. the book includes most of that stuff plus some fo the gui tools. > > From: "Wolfe Stephen S GS-11 6 MDSS/SGSI" <[EMAIL PROTECTED]> > Date: 2003/07/28 Mon AM 08:11:32 EDT > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > Subject: RE: Oracle 9i refuses to allow client connection -- I need > > > > v/r > Thanks for the encouragement and yes I would like to know some of the good Oracle > 101 under a windows environment books. I'm pretty certain that my approved training > will be funded with year-end money, but that means the earliest I'll get to class is > in late October or early November. > > Hope you don't mind me bugging you all a while until I get squared away. > > Stephen S. Wolfe, GS-11, DAFC > Data Services Manager > [EMAIL PROTECTED] > (813) 827-9974 DSN 651-9974 > > > > > -Original Message- > > From: Ron Rogers [mailto:[EMAIL PROTECTED] > > Sent: Friday, July 25, 2003 10:59 AM > > To: Multiple recipients of list ORACLE-L > > Subject: Re: Oracle 9i refuses to allow client connection -- I need > > > > > > Stephen, > > I also would like to extend a warm welcome to the world of > > Oracle. I hope that you find it interesting and challenging > > and rewarding. > > I would suggest that you get a head start on your training > > so you won't be overwhelmed when you attend, by acquiring > > some of the "Oracle 101" books that are available on the > > market. They are a valuable resource that I refer to > > constantly as I can't remember as much as I use to. > > I don't mean to slight any of the excellent authors that > > are on this list by not listing their works here. I am sure > > that if you asked for references you will be supplied with a > > list that will be quite complete and up to date. Again, > > Welcome. Ron mª¿ªm > > > > >>> [EMAIL PROTECTED] 07/25/03 08:59AM >>> > > there are a number of logs that could help: > > > > first, does the application itself generate a log? If so, > > does that log reflect the actual error returned? It might > > look something like "ORA-nn" > > > > Second, on the Windows Box itself, look for a file name > > "alert.log" (I'm not that familiar with Oracle's > > configuration on Windows as I run Unix but it should look > > something like that). Look to see if there are any error > > messages in that file at the time the connections are refused. > > > > If increasing memory on the box itself helped, it's likely > > that what's happening is that users are connecting to the > > box, never dropping or closing the connections so that memory > > stays allocated. The box runs out of memory, you reboot > > (closing the connections and releasing the > > memory) and you are good for another week or so. > > > > if that's what's happening -- you either have to get the > > users to LOG OFF (yeah, right) or find a way of > > closing/killing the connections after x amount of time (look > > into the online docs -- technet.oracle.com, specifically look > > at the network manuals). > > > > and welcome! It's always nice to see a new face here, > > especially one who is willing to LEARN > > > > --- Wolfe Stephen S GS-11 6 MDSS/SGSI <[EMAIL PROTECTED]> > > wrote: > > > I'm an Oracle administrator-To-Be, I'm awaiting funding for the > > basic > > > Oracle DBA courses, the > > > training has been approved, just hasn't been funded. > > > > > > Anyway, the only things I do are add, modify, and reset application > > > users' password via EM and run patching scripts via SQL-Plus. The > > > application I have running on this > > > particular 9i server is TPOCS, > > > Third Party Outpatient Collection System -- a billing system for the > > > DoD's Military Health System (MHS). > > > Oracle 9i is running on a Windows 2000 server. > > > > > > Anyway, the TPOCS client is a PowerBuilder client and connects via > > > SQL-Net -- I'm still learning about that mechanism. Here's my > > > problem. Occasionally, Oracle refuses to let any > > > client connect to it -- it does this about > > > every 7 to 8 days. It use to do it every 2 days, but the Tier 3 > > > TPOCS > > > helpdesk recommended we increase the > >
RE: Oracle 9i refuses to allow client connection -- I need
v/r Thanks for the encouragement and yes I would like to know some of the good Oracle 101 under a windows environment books. I'm pretty certain that my approved training will be funded with year-end money, but that means the earliest I'll get to class is in late October or early November. Hope you don't mind me bugging you all a while until I get squared away. Stephen S. Wolfe, GS-11, DAFC Data Services Manager [EMAIL PROTECTED] (813) 827-9974 DSN 651-9974 > -Original Message- > From: Ron Rogers [mailto:[EMAIL PROTECTED] > Sent: Friday, July 25, 2003 10:59 AM > To: Multiple recipients of list ORACLE-L > Subject: Re: Oracle 9i refuses to allow client connection -- I need > > > Stephen, > I also would like to extend a warm welcome to the world of > Oracle. I hope that you find it interesting and challenging > and rewarding. > I would suggest that you get a head start on your training > so you won't be overwhelmed when you attend, by acquiring > some of the "Oracle 101" books that are available on the > market. They are a valuable resource that I refer to > constantly as I can't remember as much as I use to. > I don't mean to slight any of the excellent authors that > are on this list by not listing their works here. I am sure > that if you asked for references you will be supplied with a > list that will be quite complete and up to date. Again, > Welcome. Ron mª¿ªm > > >>> [EMAIL PROTECTED] 07/25/03 08:59AM >>> > there are a number of logs that could help: > > first, does the application itself generate a log? If so, > does that log reflect the actual error returned? It might > look something like "ORA-nn" > > Second, on the Windows Box itself, look for a file name > "alert.log" (I'm not that familiar with Oracle's > configuration on Windows as I run Unix but it should look > something like that). Look to see if there are any error > messages in that file at the time the connections are refused. > > If increasing memory on the box itself helped, it's likely > that what's happening is that users are connecting to the > box, never dropping or closing the connections so that memory > stays allocated. The box runs out of memory, you reboot > (closing the connections and releasing the > memory) and you are good for another week or so. > > if that's what's happening -- you either have to get the > users to LOG OFF (yeah, right) or find a way of > closing/killing the connections after x amount of time (look > into the online docs -- technet.oracle.com, specifically look > at the network manuals). > > and welcome! It's always nice to see a new face here, > especially one who is willing to LEARN > > --- Wolfe Stephen S GS-11 6 MDSS/SGSI <[EMAIL PROTECTED]> > wrote: > > I'm an Oracle administrator-To-Be, I'm awaiting funding for the > basic > > Oracle DBA courses, the > > training has been approved, just hasn't been funded. > > > > Anyway, the only things I do are add, modify, and reset application > > users' password via EM and run patching scripts via SQL-Plus. The > > application I have running on this > > particular 9i server is TPOCS, > > Third Party Outpatient Collection System -- a billing system for the > > DoD's Military Health System (MHS). > > Oracle 9i is running on a Windows 2000 server. > > > > Anyway, the TPOCS client is a PowerBuilder client and connects via > > SQL-Net -- I'm still learning about that mechanism. Here's my > > problem. Occasionally, Oracle refuses to let any > > client connect to it -- it does this about > > every 7 to 8 days. It use to do it every 2 days, but the Tier 3 > > TPOCS > > helpdesk recommended we increase the > > ram on the server from 512MB to 1GB. Then the problem started > > occurring > > every 7 to 8 days. To make the problem > > go away I reboot the server -- it only takes 10 minutes, however, I > > feel > > this a very poor work-around. > > > > Which logs could I look in that would give you guys more > information > > (like an error code) on why Oracle refuses client > connections and then > > how would we make this problem go away. it > > is becoming a PITA. > > > > > > > > > > > > v/r > > > > Stephen S. Wolfe, GS-11, DAFC > > Data Services Manager > > [EMAIL PROTECTED] > > (813) 827-9974 DSN 651-9974 > > > > > > > __ > Do you Yahoo!? > Yahoo!
Re: Oracle 9i refuses to allow client connection -- I need
Stephen, I also would like to extend a warm welcome to the world of Oracle. I hope that you find it interesting and challenging and rewarding. I would suggest that you get a head start on your training so you won't be overwhelmed when you attend, by acquiring some of the "Oracle 101" books that are available on the market. They are a valuable resource that I refer to constantly as I can't remember as much as I use to. I don't mean to slight any of the excellent authors that are on this list by not listing their works here. I am sure that if you asked for references you will be supplied with a list that will be quite complete and up to date. Again, Welcome. Ron mª¿ªm >>> [EMAIL PROTECTED] 07/25/03 08:59AM >>> there are a number of logs that could help: first, does the application itself generate a log? If so, does that log reflect the actual error returned? It might look something like "ORA-nn" Second, on the Windows Box itself, look for a file name "alert.log" (I'm not that familiar with Oracle's configuration on Windows as I run Unix but it should look something like that). Look to see if there are any error messages in that file at the time the connections are refused. If increasing memory on the box itself helped, it's likely that what's happening is that users are connecting to the box, never dropping or closing the connections so that memory stays allocated. The box runs out of memory, you reboot (closing the connections and releasing the memory) and you are good for another week or so. if that's what's happening -- you either have to get the users to LOG OFF (yeah, right) or find a way of closing/killing the connections after x amount of time (look into the online docs -- technet.oracle.com, specifically look at the network manuals). and welcome! It's always nice to see a new face here, especially one who is willing to LEARN --- Wolfe Stephen S GS-11 6 MDSS/SGSI <[EMAIL PROTECTED]> wrote: > I'm an Oracle administrator-To-Be, I'm awaiting funding for the basic > Oracle DBA courses, the > training has been approved, just hasn't been funded. > > Anyway, the only things I do are add, modify, and reset application > users' password via EM and run > patching scripts via SQL-Plus. The application I have running on > this > particular 9i server is TPOCS, > Third Party Outpatient Collection System -- a billing system for the > DoD's Military Health System (MHS). > Oracle 9i is running on a Windows 2000 server. > > Anyway, the TPOCS client is a PowerBuilder client and connects via > SQL-Net -- I'm still learning about that > mechanism. Here's my problem. Occasionally, Oracle refuses to let > any > client connect to it -- it does this about > every 7 to 8 days. It use to do it every 2 days, but the Tier 3 > TPOCS > helpdesk recommended we increase the > ram on the server from 512MB to 1GB. Then the problem started > occurring > every 7 to 8 days. To make the problem > go away I reboot the server -- it only takes 10 minutes, however, I > feel > this a very poor work-around. > > Which logs could I look in that would give you guys more information > (like an error code) on why Oracle refuses > client connections and then how would we make this problem go away. > it > is becoming a PITA. > > > > > > v/r > > Stephen S. Wolfe, GS-11, DAFC > Data Services Manager > [EMAIL PROTECTED] > (813) 827-9974 DSN 651-9974 > > __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle 9i refuses to allow client connection -- I need some h elp.
Title: Message Check Task Manager, Physical Memory, and Peak Memory Used. If Peak Memory Used is getting close to half of Physical Memory, your server is running out of memory resources for user sessions because in Windows2000 the OS splits memory half and half between user and kernel processes, and Oracle runs as a user process. We had a 4G Windows2000 server that stopped accepting user connections for about 5 minutes because its memory usage had reached 1.4G of memory. We had a problem on an iAS server when it hit 1.6G or memory used. The workarounds are either add more memory or shrink the size of your SGA(s) to allow for the memory allocation limitations. Solution? Windows2000 Advanced Server lets you put a /3G switch in the boot.ini file, but that would only give you access to 75% of your server's memory. (I also read on the 'net that W2K AS comes with SQL Server built-in, I don't know if that's true). Needless to say, Windows Advanced Server costs more than Windows2000 Server. I'd be curious to know if you were at or near half your physical memory used. Patrice. -Original Message-From: Farnsworth, Dave [mailto:[EMAIL PROTECTED]Sent: Friday, July 25, 2003 9:49 AMTo: Multiple recipients of list ORACLE-LSubject: RE: Oracle 9i refuses to allow client connection -- I need some help. Might find something in your SID.log. This is in your Oracle_home\admin\bdump directory. Might also find something in your Oracle_home\network\log\listener.log depending on if any tracing is enabled. I used to have this problem. Found that stopping and restarting my listener service a few times a week took care of it. Also adding more memory helped. I had a TAR with Oracle on this and they recommended the stopping and restarting the listener service. I am on windoze though so it may be a platform dependent thing, not like M$ has any issues with their OS. ;o) Dave -Original Message-From: Wolfe Stephen S GS-11 6 MDSS/SGSI [mailto:[EMAIL PROTECTED]Sent: Friday, July 25, 2003 6:35 AMTo: Multiple recipients of list ORACLE-LSubject: Oracle 9i refuses to allow client connection -- I need some help. I'm an Oracle administrator-To-Be, I'm awaiting funding for the basic Oracle DBA courses, the training has been approved, just hasn't been funded. Anyway, the only things I do are add, modify, and reset application users' password via EM and run patching scripts via SQL-Plus. The application I have running on this particular 9i server is TPOCS, Third Party Outpatient Collection System -- a billing system for the DoD's Military Health System (MHS). Oracle 9i is running on a Windows 2000 server. Anyway, the TPOCS client is a PowerBuilder client and connects via SQL-Net -- I'm still learning about that mechanism. Here's my problem. Occasionally, Oracle refuses to let any client connect to it -- it does this about every 7 to 8 days. It use to do it every 2 days, but the Tier 3 TPOCS helpdesk recommended we increase the ram on the server from 512MB to 1GB. Then the problem started occurring every 7 to 8 days. To make the problem go away I reboot the server -- it only takes 10 minutes, however, I feel this a very poor work-around. Which logs could I look in that would give you guys more information (like an error code) on why Oracle refuses client connections and then how would we make this problem go away. it is becoming a PITA. v/r Stephen S. Wolfe, GS-11, DAFC Data Services Manager [EMAIL PROTECTED] (813) 827-9974 DSN 651-9974
Re: Oracle 9i refuses to allow client connection -- I need some help.
there are a number of logs that could help: first, does the application itself generate a log? If so, does that log reflect the actual error returned? It might look something like "ORA-nn" Second, on the Windows Box itself, look for a file name "alert.log" (I'm not that familiar with Oracle's configuration on Windows as I run Unix but it should look something like that). Look to see if there are any error messages in that file at the time the connections are refused. If increasing memory on the box itself helped, it's likely that what's happening is that users are connecting to the box, never dropping or closing the connections so that memory stays allocated. The box runs out of memory, you reboot (closing the connections and releasing the memory) and you are good for another week or so. if that's what's happening -- you either have to get the users to LOG OFF (yeah, right) or find a way of closing/killing the connections after x amount of time (look into the online docs -- technet.oracle.com, specifically look at the network manuals). and welcome! It's always nice to see a new face here, especially one who is willing to LEARN --- Wolfe Stephen S GS-11 6 MDSS/SGSI <[EMAIL PROTECTED]> wrote: > I'm an Oracle administrator-To-Be, I'm awaiting funding for the basic > Oracle DBA courses, the > training has been approved, just hasn't been funded. > > Anyway, the only things I do are add, modify, and reset application > users' password via EM and run > patching scripts via SQL-Plus. The application I have running on > this > particular 9i server is TPOCS, > Third Party Outpatient Collection System -- a billing system for the > DoD's Military Health System (MHS). > Oracle 9i is running on a Windows 2000 server. > > Anyway, the TPOCS client is a PowerBuilder client and connects via > SQL-Net -- I'm still learning about that > mechanism. Here's my problem. Occasionally, Oracle refuses to let > any > client connect to it -- it does this about > every 7 to 8 days. It use to do it every 2 days, but the Tier 3 > TPOCS > helpdesk recommended we increase the > ram on the server from 512MB to 1GB. Then the problem started > occurring > every 7 to 8 days. To make the problem > go away I reboot the server -- it only takes 10 minutes, however, I > feel > this a very poor work-around. > > Which logs could I look in that would give you guys more information > (like an error code) on why Oracle refuses > client connections and then how would we make this problem go away. > it > is becoming a PITA. > > > > > > v/r > > Stephen S. Wolfe, GS-11, DAFC > Data Services Manager > [EMAIL PROTECTED] > (813) 827-9974 DSN 651-9974 > > __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle 9i refuses to allow client connection -- I need some help.
Title: Message Might find something in your SID.log. This is in your Oracle_home\admin\bdump directory. Might also find something in your Oracle_home\network\log\listener.log depending on if any tracing is enabled. I used to have this problem. Found that stopping and restarting my listener service a few times a week took care of it. Also adding more memory helped. I had a TAR with Oracle on this and they recommended the stopping and restarting the listener service. I am on windoze though so it may be a platform dependent thing, not like M$ has any issues with their OS. ;o) Dave -Original Message-From: Wolfe Stephen S GS-11 6 MDSS/SGSI [mailto:[EMAIL PROTECTED]Sent: Friday, July 25, 2003 6:35 AMTo: Multiple recipients of list ORACLE-LSubject: Oracle 9i refuses to allow client connection -- I need some help. I'm an Oracle administrator-To-Be, I'm awaiting funding for the basic Oracle DBA courses, the training has been approved, just hasn't been funded. Anyway, the only things I do are add, modify, and reset application users' password via EM and run patching scripts via SQL-Plus. The application I have running on this particular 9i server is TPOCS, Third Party Outpatient Collection System -- a billing system for the DoD's Military Health System (MHS). Oracle 9i is running on a Windows 2000 server. Anyway, the TPOCS client is a PowerBuilder client and connects via SQL-Net -- I'm still learning about that mechanism. Here's my problem. Occasionally, Oracle refuses to let any client connect to it -- it does this about every 7 to 8 days. It use to do it every 2 days, but the Tier 3 TPOCS helpdesk recommended we increase the ram on the server from 512MB to 1GB. Then the problem started occurring every 7 to 8 days. To make the problem go away I reboot the server -- it only takes 10 minutes, however, I feel this a very poor work-around. Which logs could I look in that would give you guys more information (like an error code) on why Oracle refuses client connections and then how would we make this problem go away. it is becoming a PITA. v/r Stephen S. Wolfe, GS-11, DAFC Data Services Manager [EMAIL PROTECTED] (813) 827-9974 DSN 651-9974
RE: Oracle 9i refuses to allow client connection -- I need some h
Title: Message What is the error message (if any) Can you connect thru SQL*Plus (/ as sysdba) -Original Message-From: Wolfe Stephen S GS-11 6 MDSS/SGSI [mailto:[EMAIL PROTECTED] Sent: Friday, July 25, 2003 1:35 PMTo: Multiple recipients of list ORACLE-LSubject: Oracle 9i refuses to allow client connection -- I need some help. I'm an Oracle administrator-To-Be, I'm awaiting funding for the basic Oracle DBA courses, the training has been approved, just hasn't been funded. Anyway, the only things I do are add, modify, and reset application users' password via EM and run patching scripts via SQL-Plus. The application I have running on this particular 9i server is TPOCS, Third Party Outpatient Collection System -- a billing system for the DoD's Military Health System (MHS). Oracle 9i is running on a Windows 2000 server. Anyway, the TPOCS client is a PowerBuilder client and connects via SQL-Net -- I'm still learning about that mechanism. Here's my problem. Occasionally, Oracle refuses to let any client connect to it -- it does this about every 7 to 8 days. It use to do it every 2 days, but the Tier 3 TPOCS helpdesk recommended we increase the ram on the server from 512MB to 1GB. Then the problem started occurring every 7 to 8 days. To make the problem go away I reboot the server -- it only takes 10 minutes, however, I feel this a very poor work-around. Which logs could I look in that would give you guys more information (like an error code) on why Oracle refuses client connections and then how would we make this problem go away. it is becoming a PITA. v/r Stephen S. Wolfe, GS-11, DAFC Data Services Manager [EMAIL PROTECTED] (813) 827-9974 DSN 651-9974
Oracle 9i refuses to allow client connection -- I need some help.
Title: Message I'm an Oracle administrator-To-Be, I'm awaiting funding for the basic Oracle DBA courses, the training has been approved, just hasn't been funded. Anyway, the only things I do are add, modify, and reset application users' password via EM and run patching scripts via SQL-Plus. The application I have running on this particular 9i server is TPOCS, Third Party Outpatient Collection System -- a billing system for the DoD's Military Health System (MHS). Oracle 9i is running on a Windows 2000 server. Anyway, the TPOCS client is a PowerBuilder client and connects via SQL-Net -- I'm still learning about that mechanism. Here's my problem. Occasionally, Oracle refuses to let any client connect to it -- it does this about every 7 to 8 days. It use to do it every 2 days, but the Tier 3 TPOCS helpdesk recommended we increase the ram on the server from 512MB to 1GB. Then the problem started occurring every 7 to 8 days. To make the problem go away I reboot the server -- it only takes 10 minutes, however, I feel this a very poor work-around. Which logs could I look in that would give you guys more information (like an error code) on why Oracle refuses client connections and then how would we make this problem go away. it is becoming a PITA. v/r Stephen S. Wolfe, GS-11, DAFC Data Services Manager [EMAIL PROTECTED] (813) 827-9974 DSN 651-9974
Re: Oracle 9i (9.2.0.4)- RH AS 2.1 HP Itanium
Anyone know when will patchset 9.2.0.4 be out? Regards zhu chao msn:[EMAIL PROTECTED] www.cnoug.org - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Thursday, July 24, 2003 11:49 PM > Oracle RDBMS 9.2.0.4??? I thought that the latest version was 9.2.0.3? > Where did you get 9.2.0.4? > > Mladen Gogala > Oracle DBA > Phone:(203) 459-6855 > Email:[EMAIL PROTECTED] > > > -Original Message- > Sent: Thursday, July 24, 2003 11:39 AM > To: Multiple recipients of list ORACLE-L > > > Hi there > > Who is running this. > > Would like to hear opinion and experiences. > > George > > George Leonard > Oracle Database Administrator > Dimension Data (Pty) Ltd > (Reg. No. 1987/006597/07) > Cell: (+27) 82 655 2466 > Tel: (+27 11) 575 0573 > Fax: (+27 11) 576 0573 > E-mail:[EMAIL PROTECTED] > Web: http://www.didata.co.za > > You Have The Obligation to Inform One Honestly of the risk, And As a > Person > You Are Committed to Educate Yourself to the Total Risk In Any Activity! > Once Informed & Totally Aware of the Risk, Every Fool Has the Right to > Kill or Injure Themselves as They See Fit! > > > > > This email and all contents are subject to the following disclaimer: > > "http://www.didata.com/disclaimer.asp"; > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: George Leonard (ZA) > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (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: Gogala, Mladen > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (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: zhu chao INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle 9i (9.2.0.4)- RH AS 2.1 HP Itanium
Oracle RDBMS 9.2.0.4??? I thought that the latest version was 9.2.0.3? Where did you get 9.2.0.4? Mladen Gogala Oracle DBA Phone:(203) 459-6855 Email:[EMAIL PROTECTED] -Original Message- Sent: Thursday, July 24, 2003 11:39 AM To: Multiple recipients of list ORACLE-L Hi there Who is running this. Would like to hear opinion and experiences. George George Leonard Oracle Database Administrator Dimension Data (Pty) Ltd (Reg. No. 1987/006597/07) Cell: (+27) 82 655 2466 Tel: (+27 11) 575 0573 Fax: (+27 11) 576 0573 E-mail:[EMAIL PROTECTED] Web: http://www.didata.co.za You Have The Obligation to Inform One Honestly of the risk, And As a Person You Are Committed to Educate Yourself to the Total Risk In Any Activity! Once Informed & Totally Aware of the Risk, Every Fool Has the Right to Kill or Injure Themselves as They See Fit! This email and all contents are subject to the following disclaimer: "http://www.didata.com/disclaimer.asp"; -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: George Leonard (ZA) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 9i (9.2.0.4)- RH AS 2.1 HP Itanium
Hi there Who is running this. Would like to hear opinion and experiences. George George Leonard Oracle Database Administrator Dimension Data (Pty) Ltd (Reg. No. 1987/006597/07) Cell: (+27) 82 655 2466 Tel: (+27 11) 575 0573 Fax: (+27 11) 576 0573 E-mail:[EMAIL PROTECTED] Web: http://www.didata.co.za You Have The Obligation to Inform One Honestly of the risk, And As a Person You Are Committed to Educate Yourself to the Total Risk In Any Activity! Once Informed & Totally Aware of the Risk, Every Fool Has the Right to Kill or Injure Themselves as They See Fit! This email and all contents are subject to the following disclaimer: "http://www.didata.com/disclaimer.asp"; -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: George Leonard (ZA) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle 9i Release 2 and Oracle 8i
Title: RE: Oracle 9i Release 2 and Oracle 8i We experience not many problems on 9202 database we have had very good uptime. Touch wood ... Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message-From: April Wells [mailto:[EMAIL PROTECTED]Sent: Thursday, July 24, 2003 9:34 AMTo: Multiple recipients of list ORACLE-LSubject: RE: Oracle 9i Release 2 and Oracle 8i We have had some... opportunities... but so far the worst one was connected to APPS and depreciation. It was fixed in 9.2.0.3 April Wells Oracle DBA/Oracle Apps DBA Corporate Systems Amarillo Texas You will recognize your own path when you come upon it, because you will suddenly have all the energy and imagination you will ever need. ~ Jerry Gillies ~ -Original Message- From: Boivin, Patrice J [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 24, 2003 8:19 AM To: Multiple recipients of list ORACLE-L Subject: Oracle 9i Release 2 and Oracle 8i There is a rumour going around here that 9i Release 2 is not as "finished" as 8i Release 3 is. i.e. that there are still problems with 9i Release 2. I have been running it on Tru64 for months now for our OEM repository, no problems. I have been running it on my WinXP Pro workstation for months for testing and iDS9iR2... no problems there either. Did you encounter any problems with 9i Release 2 so far that haven't been fixed in 9i Release 2? How do you find 9i Release2 performing? Patrice. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). The information contained in this communication, including attachments, is strictly confidential and for the intended use of the addressee only; it may also contain proprietary, price sensitive, or legally privileged information. Notice is hereby given that any disclosure, distribution, dissemination, use, or copying of the information by anyone other than the intended recipient is strictly prohibited and may be illegal. If you have received this communication in error, please notify the sender immediately by reply e-mail, delete this communication, and destroy all copies. Corporate Systems, Inc. has taken reasonable precautions to ensure that any attachment to this e-mail has been swept for viruses. We specifically disclaim all liability and will accept no responsibility for any damage sustained as a result of software viruses and advise you to carry out your own virus checks before opening any attachment. *This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.*1
RE: Oracle 9i Release 2 and Oracle 8i
Title: RE: Oracle 9i Release 2 and Oracle 8i We have had some... opportunities... but so far the worst one was connected to APPS and depreciation. It was fixed in 9.2.0.3 April Wells Oracle DBA/Oracle Apps DBA Corporate Systems Amarillo Texas You will recognize your own path when you come upon it, because you will suddenly have all the energy and imagination you will ever need. ~ Jerry Gillies ~ -Original Message- From: Boivin, Patrice J [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 24, 2003 8:19 AM To: Multiple recipients of list ORACLE-L Subject: Oracle 9i Release 2 and Oracle 8i There is a rumour going around here that 9i Release 2 is not as "finished" as 8i Release 3 is. i.e. that there are still problems with 9i Release 2. I have been running it on Tru64 for months now for our OEM repository, no problems. I have been running it on my WinXP Pro workstation for months for testing and iDS9iR2... no problems there either. Did you encounter any problems with 9i Release 2 so far that haven't been fixed in 9i Release 2? How do you find 9i Release2 performing? Patrice. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). The information contained in this communication, including attachments, is strictly confidential and for the intended use of the addressee only; it may also contain proprietary, price sensitive, or legally privileged information. Notice is hereby given that any disclosure, distribution, dissemination, use, or copying of the information by anyone other than the intended recipient is strictly prohibited and may be illegal. If you have received this communication in error, please notify the sender immediately by reply e-mail, delete this communication, and destroy all copies. Corporate Systems, Inc. has taken reasonable precautions to ensure that any attachment to this e-mail has been swept for viruses. We specifically disclaim all liability and will accept no responsibility for any damage sustained as a result of software viruses and advise you to carry out your own virus checks before opening any attachment.
Oracle 9i Release 2 and Oracle 8i
There is a rumour going around here that 9i Release 2 is not as "finished" as 8i Release 3 is. i.e. that there are still problems with 9i Release 2. I have been running it on Tru64 for months now for our OEM repository, no problems. I have been running it on my WinXP Pro workstation for months for testing and iDS9iR2... no problems there either. Did you encounter any problems with 9i Release 2 so far that haven't been fixed in 9i Release 2? How do you find 9i Release2 performing? Patrice. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: How can I turn Oracle listener on for Oracle 9i on solaris - FYI
lsnrctl start Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Friday, July 18, 2003 2:09 PM To: Multiple recipients of list ORACLE-L FYI Hi, My servers are power off. Now I get the power and start them up. I would like to know how to start Oracle 9.2 listener on Solaris platform so that my program can talk to it. Any suggestions are appreciated! Thanks in advance! Don -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Don Yu INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Goulet, Dick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).