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).
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).
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).
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 1= =20 469s 100.0%
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 :-)
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
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).
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.
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).
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).
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
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).
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 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--
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] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (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
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).
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
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).
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.
RE: Oracle 9i Lite and cellular technology
Thank you. As per your suggestion, I have been able to locate some pertinent information and terminology starting with CDPD. Thanks! Saira -Original Message- Goulet, Dick Sent: July 15, 2003 4:04 PM To: Multiple recipients of list ORACLE-L Saira, If you have a Metalink Account do a search on "CDPD". There is a forum discussion on what your asking. May create more questions than answers, but that's what the forums are for. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Tuesday, July 15, 2003 3:44 PM To: Multiple recipients of list ORACLE-L I have been asked to explore the possibility of migrating our current mobile application on 9i Lite to cellular technology. I don't know where to begin. What are the hardware requirements (other than the handheld units)? I probably need a subscription to a provider that can facilitate this for us but who would that be? What about changes to the application? If anyone else has explored this possibility or has implemented it, sharing your experiences would be greatly appreciated. Thanks, Saira -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Saira Somani-Mendelin INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Goulet, Dick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Saira Somani-Mendelin INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or 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 Lite and cellular technology
Saira, If you have a Metalink Account do a search on "CDPD". There is a forum discussion on what your asking. May create more questions than answers, but that's what the forums are for. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Tuesday, July 15, 2003 3:44 PM To: Multiple recipients of list ORACLE-L I have been asked to explore the possibility of migrating our current mobile application on 9i Lite to cellular technology. I don't know where to begin. What are the hardware requirements (other than the handheld units)? I probably need a subscription to a provider that can facilitate this for us but who would that be? What about changes to the application? If anyone else has explored this possibility or has implemented it, sharing your experiences would be greatly appreciated. Thanks, Saira -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Saira Somani-Mendelin INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 vs SQL Server
The bitter person in me suggests the answer will depend on which list you ask. Asking an Oracle list may provide a resounding "No - it will choke and die", whilst asking a SQL Server list may be slightly more positive. I don't work with SQL Server myself but from what I've heard lately the product is getting better and better with each release and may well be up to the task. Obviously hardware will play a big part as well - although 50 client connections doesn't sound like a lot. I suspect it will depend a bit on how often your 20,000 objects post their status to the database and how much historical data you expect to maintain within the pimary database. "Dave Phillips" <[EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> -corp.com> cc: Sent by: Subject: Oracle 9i vs SQL Server [EMAIL PROTECTED] .com 11/06/2003 07:45 Please respond to ORACLE-L I know this topic has come up before on the list, so I hesitate to kick it again.(I hesitated?I didn't say I wouldn't :) I know there are cost issues, as well as skill set questions (do you have Oracle skills/MS skills) in house. My company has an App that runs on Ms2000 OS. (Dbase connections through ADO/OCI). It is capable of using Oracle 8i/9i or SQL Server 2000 on the backend for the database. Clients have the option, though we 'recommend' for the higher volume clients. The app receives status information from objects. There can be anywhere from 50 objects with 3 clients stations active all the way to 20,000 plus objects with 50+ client stations active. It's mainly OLTP in nature, with daily batch reporting. I'm and Oracle DBA who is learning MS SQL Server 2000 (because I'll have to support customer issues with our app.) I have confidence that Oracle will handle the load, but what about Sql Server 2000? I remember reading about read write contention issues with SQL Server, is that still a problem? What are the weakness/problem issues with SQL Server? Any opinions/comments would be welcome. TIA David P. Oracle 8i DBA SQL Server DBA in training (yuck) <<>> Privileged/Confidential information may be contained in this message. If you are not the addressee indicated in this message (or responsible for delivery of the message to such person), you may not copy or deliver this message to anyone. In such case, you should destroy this message and kindly notify the sender by reply e-mail or by telephone on (61 3) 9612-6999. Please advise immediately if you or your employer does not consent to Internet e-mail for messages of this kind. Opinions, conclusions and other information in this message that do not relate to the official business of Transurban City Link Ltd shall be understood as neither given nor endorsed by it. <<<> -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mark Richard INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services -
RE: Oracle 9i RAC on Windows using firewire
Hi Mark, Yes They did not have the expertise for firewire at the time (and still don't). I'll figue it out somehow and inform him when it works. Cheers Jack -Original Message- Sent: woensdag 5 maart 2003 15:51 To: Multiple recipients of list ORACLE-L Jack, Have you had a chat with Tom to see if they have upgraded the current $1000 RAC paper for windows? I think it was mentioned in the paper that they planned to.. Mark -Original Message- Sent: 05 March 2003 14:06 To: Multiple recipients of list ORACLE-L Jack, www.tusc.com has a white paper that created a RAC with firewire and RedHat8.0 /w kernell upgrade for under $1500.00. Authored by M.Ault and presented at the SEOUG Conference last month. Ron >>> [EMAIL PROTECTED] 03/05/03 06:34AM >>> Hi We are not a Unix shop and would like to build a test setup of 9iRAC on windows at the cheapest price. I have a document that explains how to do it using SCSI disks but the parts here are very expensive. I have heard that it is also possible to use firewire disks to achieve the same. Does anybody have a document detailing this setup? Technet mentions this only for LINUX and not for Windowz TIA Jacob A. van Zanen Oracle DBA -- 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: 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: 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).
Re: Oracle 9i RAC on Windows using firewire
Hi, It is true that the firewire stuff IS linux only. It was written by Wim Coekaerts (who I used to work together with in Oracle Dev.), who also wrote (together with his group) the cluster file system for linux. I haven't personally tried it yet, but an old collegue(sp?) of mine has tried it. Speedwise it still has some more ground to cover, but for a demo/test setup it's excellent and cheap. Regards, Morten Jack van Zanen wrote: Hi We are not a Unix shop and would like to build a test setup of 9iRAC on windows at the cheapest price. I have a document that explains how to do it using SCSI disks but the parts here are very expensive. I have heard that it is also possible to use firewire disks to achieve the same. Does anybody have a document detailing this setup? Technet mentions this only for LINUX and not for Windowz TIA Jacob A. van Zanen Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Morten Egan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or 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 RAC on Windows using firewire
Jack, Have you had a chat with Tom to see if they have upgraded the current $1000 RAC paper for windows? I think it was mentioned in the paper that they planned to.. Mark -Original Message- Sent: 05 March 2003 14:06 To: Multiple recipients of list ORACLE-L Jack, www.tusc.com has a white paper that created a RAC with firewire and RedHat8.0 /w kernell upgrade for under $1500.00. Authored by M.Ault and presented at the SEOUG Conference last month. Ron >>> [EMAIL PROTECTED] 03/05/03 06:34AM >>> Hi We are not a Unix shop and would like to build a test setup of 9iRAC on windows at the cheapest price. I have a document that explains how to do it using SCSI disks but the parts here are very expensive. I have heard that it is also possible to use firewire disks to achieve the same. Does anybody have a document detailing this setup? Technet mentions this only for LINUX and not for Windowz TIA Jacob A. van Zanen Oracle DBA -- 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: 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Oracle 9i RAC on Windows using firewire
Try OakTable Network. They have a paper on Windows RAC setup details. http://www.oaktable.net/userFiles.jsp. Arup Nanda - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Wednesday, March 05, 2003 6:34 AM > Hi > > > We are not a Unix shop and would like to build a test setup of 9iRAC on > windows at the cheapest price. > > I have a document that explains how to do it using SCSI disks but the parts > here are very expensive. I have heard that it is also possible to use > firewire disks to achieve the same. Does anybody have a document detailing > this setup? Technet mentions this only for LINUX and not for Windowz > > TIA > > Jacob A. van Zanen > Oracle DBA > > > -- > 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: 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 RAC on Windows using firewire
Jack, www.tusc.com has a white paper that created a RAC with firewire and RedHat8.0 /w kernell upgrade for under $1500.00. Authored by M.Ault and presented at the SEOUG Conference last month. Ron >>> [EMAIL PROTECTED] 03/05/03 06:34AM >>> Hi We are not a Unix shop and would like to build a test setup of 9iRAC on windows at the cheapest price. I have a document that explains how to do it using SCSI disks but the parts here are very expensive. I have heard that it is also possible to use firewire disks to achieve the same. Does anybody have a document detailing this setup? Technet mentions this only for LINUX and not for Windowz TIA Jacob A. van Zanen Oracle DBA -- 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: 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 hanging when linking during install !!!
Jackson, I can't say it for HP-UX, but in Tru64 Unix, a cousin-in-law of HP-UX, the error can occur if the ulimit is set too low. Check MetaLink Note 166350.1 for information on how to check and set the ulimit. HTH. Arup Nanda - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Friday, February 21, 2003 6:58 AM > Hi All > > We are having this major problem when we are trying to install Oracle > 9i software on HP-Unix 11. It just hangs when it's linking, please > help as we need to upgrade our production databases to 9i. > > Check here : > > Installing oracle 920. On linking getting the ff error : > Error in invoking ioracle of makefile > /$ORACLE_HOME/rdbms/lib/ins_rdbms.mk. > > I have checked on > metalink and seen a suggestion of increasing swap space.My swap space > is currently 6Gb. Pls assist. > > > $ make -f $ORACLE_HOME/rdbms/lib/ins_rdbms.mk ioracle > > - Linking Oracle > rm -f /opt/oracle/920/rdbms/lib/oracle > cc -Wl,+s -Wl,+n +DA2.0W +DS2.0 -o > /opt/oracle/920/rdbms/lib/oracle -L/opt/oracle/920/rdbms/lib/ > -L/opt/oracle/92 > 0/lib/ `if /usr/bin/getconf KERNEL_BITS | grep "64" > /dev/null ; \ > then echo "-Wl,+pi 64M -Wl,+pd L -Wl,+padtext 16M -Wl,+paddata > 1M" ; \ > else echo "" ; fi` -Wl,-PF,linkorderfile > -Wl,+Ostaticprediction +O2 +Omultiprocessor +Oentrysched +Onolimit > +ESlit + > Olibcalls /opt/oracle/920/rdbms/lib/opimai.o > /opt/oracle/920/rdbms/lib/ssoraed.o /opt/oracle/920/rdbms/lib/ttcsoi.o > /opt/or > acle/920/lib/nautab.o /opt/oracle/920/lib/naeet.o > /opt/oracle/920/lib/naect.o /opt/oracle/920/lib/naedhs.o > /opt/oracle/920/r > dbms/lib/config.o -lserver9 -lodm9 -lskgxp9 -lskgxn9 -lclient9 > -lvsn9 -lwtcserver9 -lcommon9 -lgeneric9 /opt/oracle/920/ > rdbms/lib/defopt.o -lknlopt `if ar tv > /opt/oracle/920/rdbms/lib/libknlopt.a | grep xsyeolap.o > /dev/null > 2>&1 ; then echo > "-loraolap9" ; fi` -lslax9 -lpls9 -lplp9 -ljox9 -lwwg9 `cat > /opt/oracle/920/lib/ldflags`-lnsslb9 -lncrypt9 -lnsgr9 > -lnzjs9 -ln9 -lnl9 -lnro9 -lmm -lnls9 -lcore9 -lxml9 -lunls9 > -ltrace9 `if ar tv /opt/oracle/920/rdbms/lib/libknlopt.a > | grep "kxmnsd.o" > /dev/null 2>&1 ; then echo " " ; else echo > "-lordsdo9"; fi` -lctxc9 -lctx9 -lzx9 -lgx9 -lordimt9 -lsnls > 9 `cat /opt/oracle/920/lib/sysliblist` -lm `if ar t > /opt/oracle/920/lib/libskgxp9.a | grep '^'skcsi.o > /dev/null 2>&1 > ; then echo "/opt/clic/lib/pa20_64/libclic_csi.a";fi` > /opt/oracle/920/lib/libocijdbc9.a -lxsd9 -lcres > Out of Memory. > *** Error exit code 12 > > Stop. > > Total VM : 735.2mb Sys Mem : 354.9mb User Mem: 1.99gb Phys > Mem: 6.00gb > Active VM: 301.1mb Buf Cache: 3.00gb Free Mem: 674.4mb > > ld: (Warning) Can't open the fdp output file linkorderfile > > Pid 27501 received a SIGSEGV for stack growth failure. > Possible causes: insufficient memory or swap space, > or stack size exceeded maxssiz. > cc: error 1405: "/usr/ccs/bin/ld" terminated abnormally with signal > 11. > *** Error exit code 11 > > Stop. > ___ > http://www.webmail.co.za the South-African free email service > > NetWiseGurus.Com Portal - Your Own Internet Business Today! > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Jackson Dumas > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (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 hanging when linking during install !!!
There's a note on metalink that covers some of the relevant parameters: 68105.1 'Commonly Misconfigured HP-UX Kernel Parameters'. 9i is a lot more resource hungry than 8i, and you need to make sure you have the right HP-UX patchsets. Cheers Simon Anderson "Deshpande, Kirti" <[EMAIL PROTECTED]>@fatcity.com on 21/02/2003 13:58:49 Please respond to [EMAIL PROTECTED] Sent by:[EMAIL PROTECTED] To:Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Review and increase kernel parameters maxtsiz, maxdsiz, maxssiz (maxtsiz_64bit, maxdsiz_64bit, maxssiz_64bit). It is possible that maxssiz (process stack space) is too low, and hence 'Out of Memory'. Refer to HP-UX Oracle Installation Guide for some guidelines to select proper values for these parameters. Kernel rebuilding and rebooting of the server will be needed :( - Kirti -Original Message- Sent: Friday, February 21, 2003 5:59 AM To: Multiple recipients of list ORACLE-L Hi All We are having this major problem when we are trying to install Oracle 9i software on HP-Unix 11. It just hangs when it's linking, please help as we need to upgrade our production databases to 9i. Check here : Installing oracle 920. On linking getting the ff error : Error in invoking ioracle of makefile /$ORACLE_HOME/rdbms/lib/ins_rdbms.mk. I have checked on metalink and seen a suggestion of increasing swap space.My swap space is currently 6Gb. Pls assist. $ make -f $ORACLE_HOME/rdbms/lib/ins_rdbms.mk ioracle - Linking Oracle rm -f /opt/oracle/920/rdbms/lib/oracle cc -Wl,+s -Wl,+n +DA2.0W +DS2.0 -o /opt/oracle/920/rdbms/lib/oracle -L/opt/oracle/920/rdbms/lib/ -L/opt/oracle/92 0/lib/ `if /usr/bin/getconf KERNEL_BITS | grep "64" > /dev/null ; \ then echo "-Wl,+pi 64M -Wl,+pd L -Wl,+padtext 16M -Wl,+paddata 1M" ; \ else echo "" ; fi` -Wl,-PF,linkorderfile -Wl,+Ostaticprediction +O2 +Omultiprocessor +Oentrysched +Onolimit +ESlit + Olibcalls /opt/oracle/920/rdbms/lib/opimai.o /opt/oracle/920/rdbms/lib/ssoraed.o /opt/oracle/920/rdbms/lib/ttcsoi.o /opt/or acle/920/lib/nautab.o /opt/oracle/920/lib/naeet.o /opt/oracle/920/lib/naect.o /opt/oracle/920/lib/naedhs.o /opt/oracle/920/r dbms/lib/config.o -lserver9 -lodm9 -lskgxp9 -lskgxn9 -lclient9 -lvsn9 -lwtcserver9 -lcommon9 -lgeneric9 /opt/oracle/920/ rdbms/lib/defopt.o -lknlopt `if ar tv /opt/oracle/920/rdbms/lib/libknlopt.a | grep xsyeolap.o > /dev/null 2>&1 ; then echo "-loraolap9" ; fi` -lslax9 -lpls9 -lplp9 -ljox9 -lwwg9 `cat /opt/oracle/920/lib/ldflags`-lnsslb9 -lncrypt9 -lnsgr9 -lnzjs9 -ln9 -lnl9 -lnro9 -lmm -lnls9 -lcore9 -lxml9 -lunls9 -ltrace9 `if ar tv /opt/oracle/920/rdbms/lib/libknlopt.a | grep "kxmnsd.o" > /dev/null 2>&1 ; then echo " " ; else echo "-lordsdo9"; fi` -lctxc9 -lctx9 -lzx9 -lgx9 -lordimt9 -lsnls 9 `cat /opt/oracle/920/lib/sysliblist` -lm `if ar t /opt/oracle/920/lib/libskgxp9.a | grep '^'skcsi.o > /dev/null 2>&1 ; then echo "/opt/clic/lib/pa20_64/libclic_csi.a";fi` /opt/oracle/920/lib/libocijdbc9.a -lxsd9 -lcres Out of Memory. *** Error exit code 12 Stop. Total VM : 735.2mb Sys Mem : 354.9mb User Mem: 1.99gb Phys Mem: 6.00gb Active VM: 301.1mb Buf Cache: 3.00gb Free Mem: 674.4mb ld: (Warning) Can't open the fdp output file linkorderfile Pid 27501 received a SIGSEGV for stack growth failure. Possible causes: insufficient memory or swap space, or stack size exceeded maxssiz. cc: error 1405: "/usr/ccs/bin/ld" terminated abnormally with signal 11. *** Error exit code 11 Stop. _ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or 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 hanging when linking during install !!!
It is likely that you will have to rebuild your kernel. If you start sam as root and go to kernel confiuration -> configurable parameters you will find parameters named maxssiz and maxssiz_64bit. Adjust them to allow the stack enough space to perform your link. Note that you will only need to adjust one of them depending on whether you are 32 or 64 bit. We are on HP-UX 11i and maxssiz is set to about 8M. Caveat: We have not installed 9i on this box. On another 11i box where 9i has been installed (not by me) I find maxssize set to about 134M and maxssiz_64Bit set to about 1G. Hope this helps. Allan -Original Message- Sent: Friday, February 21, 2003 5:59 AM To: Multiple recipients of list ORACLE-L Hi All We are having this major problem when we are trying to install Oracle 9i software on HP-Unix 11. It just hangs when it's linking, please help as we need to upgrade our production databases to 9i. Check here : Installing oracle 920. On linking getting the ff error : Error in invoking ioracle of makefile /$ORACLE_HOME/rdbms/lib/ins_rdbms.mk. I have checked on metalink and seen a suggestion of increasing swap space.My swap space is currently 6Gb. Pls assist. $ make -f $ORACLE_HOME/rdbms/lib/ins_rdbms.mk ioracle - Linking Oracle rm -f /opt/oracle/920/rdbms/lib/oracle cc -Wl,+s -Wl,+n +DA2.0W +DS2.0 -o /opt/oracle/920/rdbms/lib/oracle -L/opt/oracle/920/rdbms/lib/ -L/opt/oracle/92 0/lib/ `if /usr/bin/getconf KERNEL_BITS | grep "64" > /dev/null ; \ then echo "-Wl,+pi 64M -Wl,+pd L -Wl,+padtext 16M -Wl,+paddata 1M" ; \ else echo "" ; fi` -Wl,-PF,linkorderfile -Wl,+Ostaticprediction +O2 +Omultiprocessor +Oentrysched +Onolimit +ESlit + Olibcalls /opt/oracle/920/rdbms/lib/opimai.o /opt/oracle/920/rdbms/lib/ssoraed.o /opt/oracle/920/rdbms/lib/ttcsoi.o /opt/or acle/920/lib/nautab.o /opt/oracle/920/lib/naeet.o /opt/oracle/920/lib/naect.o /opt/oracle/920/lib/naedhs.o /opt/oracle/920/r dbms/lib/config.o -lserver9 -lodm9 -lskgxp9 -lskgxn9 -lclient9 -lvsn9 -lwtcserver9 -lcommon9 -lgeneric9 /opt/oracle/920/ rdbms/lib/defopt.o -lknlopt `if ar tv /opt/oracle/920/rdbms/lib/libknlopt.a | grep xsyeolap.o > /dev/null 2>&1 ; then echo "-loraolap9" ; fi` -lslax9 -lpls9 -lplp9 -ljox9 -lwwg9 `cat /opt/oracle/920/lib/ldflags`-lnsslb9 -lncrypt9 -lnsgr9 -lnzjs9 -ln9 -lnl9 -lnro9 -lmm -lnls9 -lcore9 -lxml9 -lunls9 -ltrace9 `if ar tv /opt/oracle/920/rdbms/lib/libknlopt.a | grep "kxmnsd.o" > /dev/null 2>&1 ; then echo " " ; else echo "-lordsdo9"; fi` -lctxc9 -lctx9 -lzx9 -lgx9 -lordimt9 -lsnls 9 `cat /opt/oracle/920/lib/sysliblist` -lm `if ar t /opt/oracle/920/lib/libskgxp9.a | grep '^'skcsi.o > /dev/null 2>&1 ; then echo "/opt/clic/lib/pa20_64/libclic_csi.a";fi` /opt/oracle/920/lib/libocijdbc9.a -lxsd9 -lcres Out of Memory. *** Error exit code 12 Stop. Total VM : 735.2mb Sys Mem : 354.9mb User Mem: 1.99gb Phys Mem: 6.00gb Active VM: 301.1mb Buf Cache: 3.00gb Free Mem: 674.4mb ld: (Warning) Can't open the fdp output file linkorderfile Pid 27501 received a SIGSEGV for stack growth failure. Possible causes: insufficient memory or swap space, or stack size exceeded maxssiz. cc: error 1405: "/usr/ccs/bin/ld" terminated abnormally with signal 11. *** Error exit code 11 Stop. ___ http://www.webmail.co.za the South-African free email service NetWiseGurus.Com Portal - Your Own Internet Business Today! -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jackson Dumas INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ This email is intended solely for the person or entity to which it is addressed and may contain confidential and/or privileged information. Copying, forwarding or distributing this message by persons or entities other than the addressee is prohibited. If you have received this email in error, please contact the sender immediately and delete the material from any computer. This email may have been monitored for policy compliance. [021216] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nelson, Allan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services ---
RE: Oracle 9i hanging when linking during install !!!
Review and increase kernel parameters maxtsiz, maxdsiz, maxssiz (maxtsiz_64bit, maxdsiz_64bit, maxssiz_64bit). It is possible that maxssiz (process stack space) is too low, and hence 'Out of Memory'. Refer to HP-UX Oracle Installation Guide for some guidelines to select proper values for these parameters. Kernel rebuilding and rebooting of the server will be needed :( - Kirti -Original Message- Sent: Friday, February 21, 2003 5:59 AM To: Multiple recipients of list ORACLE-L Hi All We are having this major problem when we are trying to install Oracle 9i software on HP-Unix 11. It just hangs when it's linking, please help as we need to upgrade our production databases to 9i. Check here : Installing oracle 920. On linking getting the ff error : Error in invoking ioracle of makefile /$ORACLE_HOME/rdbms/lib/ins_rdbms.mk. I have checked on metalink and seen a suggestion of increasing swap space.My swap space is currently 6Gb. Pls assist. $ make -f $ORACLE_HOME/rdbms/lib/ins_rdbms.mk ioracle - Linking Oracle rm -f /opt/oracle/920/rdbms/lib/oracle cc -Wl,+s -Wl,+n +DA2.0W +DS2.0 -o /opt/oracle/920/rdbms/lib/oracle -L/opt/oracle/920/rdbms/lib/ -L/opt/oracle/92 0/lib/ `if /usr/bin/getconf KERNEL_BITS | grep "64" > /dev/null ; \ then echo "-Wl,+pi 64M -Wl,+pd L -Wl,+padtext 16M -Wl,+paddata 1M" ; \ else echo "" ; fi` -Wl,-PF,linkorderfile -Wl,+Ostaticprediction +O2 +Omultiprocessor +Oentrysched +Onolimit +ESlit + Olibcalls /opt/oracle/920/rdbms/lib/opimai.o /opt/oracle/920/rdbms/lib/ssoraed.o /opt/oracle/920/rdbms/lib/ttcsoi.o /opt/or acle/920/lib/nautab.o /opt/oracle/920/lib/naeet.o /opt/oracle/920/lib/naect.o /opt/oracle/920/lib/naedhs.o /opt/oracle/920/r dbms/lib/config.o -lserver9 -lodm9 -lskgxp9 -lskgxn9 -lclient9 -lvsn9 -lwtcserver9 -lcommon9 -lgeneric9 /opt/oracle/920/ rdbms/lib/defopt.o -lknlopt `if ar tv /opt/oracle/920/rdbms/lib/libknlopt.a | grep xsyeolap.o > /dev/null 2>&1 ; then echo "-loraolap9" ; fi` -lslax9 -lpls9 -lplp9 -ljox9 -lwwg9 `cat /opt/oracle/920/lib/ldflags`-lnsslb9 -lncrypt9 -lnsgr9 -lnzjs9 -ln9 -lnl9 -lnro9 -lmm -lnls9 -lcore9 -lxml9 -lunls9 -ltrace9 `if ar tv /opt/oracle/920/rdbms/lib/libknlopt.a | grep "kxmnsd.o" > /dev/null 2>&1 ; then echo " " ; else echo "-lordsdo9"; fi` -lctxc9 -lctx9 -lzx9 -lgx9 -lordimt9 -lsnls 9 `cat /opt/oracle/920/lib/sysliblist` -lm `if ar t /opt/oracle/920/lib/libskgxp9.a | grep '^'skcsi.o > /dev/null 2>&1 ; then echo "/opt/clic/lib/pa20_64/libclic_csi.a";fi` /opt/oracle/920/lib/libocijdbc9.a -lxsd9 -lcres Out of Memory. *** Error exit code 12 Stop. Total VM : 735.2mb Sys Mem : 354.9mb User Mem: 1.99gb Phys Mem: 6.00gb Active VM: 301.1mb Buf Cache: 3.00gb Free Mem: 674.4mb ld: (Warning) Can't open the fdp output file linkorderfile Pid 27501 received a SIGSEGV for stack growth failure. Possible causes: insufficient memory or swap space, or stack size exceeded maxssiz. cc: error 1405: "/usr/ccs/bin/ld" terminated abnormally with signal 11. *** Error exit code 11 Stop. _ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle 9i hanging when linking during install !!!
I logged a TAR on Tuesday for the 9.2.0.2.0 patch on Tru64, same error -- turns out there is a shell memory allocation limit being reached. 161328.1 Relinking Oracle 9i on True64/HP-UX/Sun Fails With Out of Memory Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin & Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED] -Original Message- Sent: Friday, February 21, 2003 7:59 AM To: Multiple recipients of list ORACLE-L Hi All We are having this major problem when we are trying to install Oracle 9i software on HP-Unix 11. It just hangs when it's linking, please help as we need to upgrade our production databases to 9i. Check here : Installing oracle 920. On linking getting the ff error : Error in invoking ioracle of makefile /$ORACLE_HOME/rdbms/lib/ins_rdbms.mk. I have checked on metalink and seen a suggestion of increasing swap space.My swap space is currently 6Gb. Pls assist. $ make -f $ORACLE_HOME/rdbms/lib/ins_rdbms.mk ioracle - Linking Oracle rm -f /opt/oracle/920/rdbms/lib/oracle cc -Wl,+s -Wl,+n +DA2.0W +DS2.0 -o /opt/oracle/920/rdbms/lib/oracle -L/opt/oracle/920/rdbms/lib/ -L/opt/oracle/92 0/lib/ `if /usr/bin/getconf KERNEL_BITS | grep "64" > /dev/null ; \ then echo "-Wl,+pi 64M -Wl,+pd L -Wl,+padtext 16M -Wl,+paddata 1M" ; \ else echo "" ; fi` -Wl,-PF,linkorderfile -Wl,+Ostaticprediction +O2 +Omultiprocessor +Oentrysched +Onolimit +ESlit + Olibcalls /opt/oracle/920/rdbms/lib/opimai.o /opt/oracle/920/rdbms/lib/ssoraed.o /opt/oracle/920/rdbms/lib/ttcsoi.o /opt/or acle/920/lib/nautab.o /opt/oracle/920/lib/naeet.o /opt/oracle/920/lib/naect.o /opt/oracle/920/lib/naedhs.o /opt/oracle/920/r dbms/lib/config.o -lserver9 -lodm9 -lskgxp9 -lskgxn9 -lclient9 -lvsn9 -lwtcserver9 -lcommon9 -lgeneric9 /opt/oracle/920/ rdbms/lib/defopt.o -lknlopt `if ar tv /opt/oracle/920/rdbms/lib/libknlopt.a | grep xsyeolap.o > /dev/null 2>&1 ; then echo "-loraolap9" ; fi` -lslax9 -lpls9 -lplp9 -ljox9 -lwwg9 `cat /opt/oracle/920/lib/ldflags`-lnsslb9 -lncrypt9 -lnsgr9 -lnzjs9 -ln9 -lnl9 -lnro9 -lmm -lnls9 -lcore9 -lxml9 -lunls9 -ltrace9 `if ar tv /opt/oracle/920/rdbms/lib/libknlopt.a | grep "kxmnsd.o" > /dev/null 2>&1 ; then echo " " ; else echo "-lordsdo9"; fi` -lctxc9 -lctx9 -lzx9 -lgx9 -lordimt9 -lsnls 9 `cat /opt/oracle/920/lib/sysliblist` -lm `if ar t /opt/oracle/920/lib/libskgxp9.a | grep '^'skcsi.o > /dev/null 2>&1 ; then echo "/opt/clic/lib/pa20_64/libclic_csi.a";fi` /opt/oracle/920/lib/libocijdbc9.a -lxsd9 -lcres Out of Memory. *** Error exit code 12 Stop. Total VM : 735.2mb Sys Mem : 354.9mb User Mem: 1.99gb Phys Mem: 6.00gb Active VM: 301.1mb Buf Cache: 3.00gb Free Mem: 674.4mb ld: (Warning) Can't open the fdp output file linkorderfile Pid 27501 received a SIGSEGV for stack growth failure. Possible causes: insufficient memory or swap space, or stack size exceeded maxssiz. cc: error 1405: "/usr/ccs/bin/ld" terminated abnormally with signal 11. *** Error exit code 11 Stop. ___ http://www.webmail.co.za the South-African free email service NetWiseGurus.Com Portal - Your Own Internet Business Today! -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jackson Dumas INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle 9i Lite - any help please?
Oracle has recommended patchset 2697758 Oracle9i Lite 5.0.1.6.0 patch for base version 5.0.1.0.0 - perhaps that will help. I will keep you informed. Thanks again, Saira -Original Message- Somani Sent: February 17, 2003 9:54 AM To: Multiple recipients of list ORACLE-L Mogens, We did exactly as indicated in the e-mail from Martin and were encountering the same problems as before. Any helpful hints from your colleagues would be much appreciated. Thanks, Saira -Original Message- Nørgaard Sent: February 7, 2003 4:59 PM To: Multiple recipients of list ORACLE-L Saira, Excellent feedback. I'll forward it to Jacob Christfort and Martin Graf. Martin, by the way, sent me a response to your posting (Jacob forwarded my message to Martin). See below. Best regards, Mogens Mogens, In deed, Oracle9i Lite has over 10'000 posted messages on OTN, which makes it #3 of all Oracle Products. This outstanding number of messages produces a lot of work for us, which is why you might experience slower than expected turn around for certain postings. We apologize for the delay but you can rest assured that we do everything in our power to resolve your issues. It looks like data does not get applied to the Oracle Lite (PROCESSING) database. Client changes are sent to the Mobile Server (SENDING). The client also received data from the server (RECEIVING). It might be that replication never finishes (commits) the transaction (since it hangs), which is why MGP might not pick up the changes and apply them to the Oracle database. COMPOSING client data SENDING client data to the Mobile Server RECEIVING data from the server PROCESSING (apply) data to the client database The PK change in one of your application table might actually be the culprit. Please follow the procedure below and let me know if you have further questions. 1. Drop the application from Control Center 2. Drop the client database(s) 3. Publish the application into Mobile Server 4. Provision the application 5. Execute sync We recommend to use Oracle9i Lite 5.0.2 release with 5.0.2.3.0 Windows patch (the latest on Windows). -- martin -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Saira Somani INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or 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 Lite - any help please?
Mogens, We did exactly as indicated in the e-mail from Martin and we’re encountering the same problems as before. Any helpful hints from your colleagues would be much appreciated. Thanks, Saira -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Mogens Nørgaard Sent: February 7, 2003 4:59 PM To: Multiple recipients of list ORACLE-L Subject: Re: Oracle 9i Lite - any help please? Saira, Excellent feedback. I'll forward it to Jacob Christfort and Martin Graf. Martin, by the way, sent me a response to your posting (Jacob forwarded my message to Martin). See below. Best regards, Mogens Mogens, In deed, Oracle9i Lite has over 10'000 posted messages on OTN, which makes it #3 of all Oracle Products. This outstanding number of messages produces a lot of work for us, which is why you might experience slower than expected turn around for certain postings. We apologize for the delay but you can rest assured that we do everything in our power to resolve your issues. It looks like data does not get applied to the Oracle Lite (PROCESSING) database. Client changes are sent to the Mobile Server (SENDING). The client also received data from the server (RECEIVING). It might be that replication never finishes (commits) the transaction (since it hangs), which is why MGP might not pick up the changes and apply them to the Oracle database. COMPOSING client data SENDING client data to the Mobile Server RECEIVING data from the server PROCESSING (apply) data to the client database The PK change in one of your application table might actually be the culprit. Please follow the procedure below and let me know if you have further questions. 1. Drop the application from Control Center 2. Drop the client database(s) 3. Publish the application into Mobile Server 4. Provision the application 5. Execute sync We recommend to use Oracle9i Lite 5.0.2 release with 5.0.2.3.0 Windows patch (the latest on Windows). -- martin
Re: Oracle 9i Lite - any help please?
Saira, Excellent feedback. I'll forward it to Jacob Christfort and Martin Graf. Martin, by the way, sent me a response to your posting (Jacob forwarded my message to Martin). See below. Best regards, Mogens Mogens, In deed, Oracle9i Lite has over 10'000 posted messages on OTN, which makes it #3 of all Oracle Products. This outstanding number of messages produces a lot of work for us, which is why you might experience slower than expected turn around for certain postings. We apologize for the delay but you can rest assured that we do everything in our power to resolve your issues. It looks like data does not get applied to the Oracle Lite (PROCESSING) database. Client changes are sent to the Mobile Server (SENDING). The client also received data from the server (RECEIVING). It might be that replication never finishes (commits) the transaction (since it hangs), which is why MGP might not pick up the changes and apply them to the Oracle database. COMPOSING client data SENDING client data to the Mobile Server RECEIVING data from the server PROCESSING (apply) data to the client database The PK change in one of your application table might actually be the culprit. Please follow the procedure below and let me know if you have further questions. 1. Drop the application from Control Center 2. Drop the client database(s) 3. Publish the application into Mobile Server 4. Provision the application 5. Execute sync We recommend to use Oracle9i Lite 5.0.2 release with 5.0.2.3.0 Windows patch (the latest on Windows). -- martin Saira Somani wrote: Mogens, Thank you kindly for forwarding my questions to the head honcho. I would be extremely pleased if he responded but not offended if he didn't. Funny enough, we are currently using Lite with Intermec 700 handhelds (StrongARM chipset) running Pocket PC (Windows CE) in hospitals to manage supply carts. Interesting business. So since I have inherited administration of this software, I not an expert yet, but quickly finding out where documentation and logging is sparse. I find that it is quite difficult to figure out where a problem has occurred. Take for example the MSYNC process on the client which synchronizes with the repository on the 8i server. Every time the client syncs, the client tells me it is successful, even though it isn't. Secondly, there is processing that is performed on synchronization - I know for a fact that there is data to be "processed", yet this client never fulfills that request to "process" the data and as a result, changes are not reflected in the repository. Then take migration. I wanted to upgrade from 5.0.1.X.0 to 5.0.2.X.0 - and I found out that I cannot even log into the administrative console. And that would be fine, if there was documentation that told me this is possible (maybe I missed that PDF, I don't know - too much information, too little time). And how about documentation on the tracing. Especially interpretation of the log/trace files - there is no guideline to explain to me what I can expect from the logging/tracing (again, maybe it's me for missing that PDF but I have searched for many months with little success). I think it is a good product with many bugs and I think it can be used very effectively if administered/configured optimally. I just think that there isn't enough expertise out there yet to assist those who have decided to go with this product. From an administrative standpoint, I find it difficult to grasp how and where errors are occurring. Even more difficult is trying to figure out a pattern to the errors. They are sporadic, inconsistent, and show no symptoms. Alerts for MGP failing are non-existent - don't know when it will go down and when it does, I can't explain why. Overall, I can see it having success in the right environment and with a stable release. Hope this helped but didn't offend any. Thanks again, Saira -Original Message- Nørgaard Sent: February 6, 2003 1:00 PM To: Multiple recipients of list ORACLE-L Saira, I've forwarded your message to the CTO of Oracle Lite, my old friend Jacob Christfort, whom I know from our days at the National Hospital Dormitory in Copenhagen, where we had lots of fun, and where many nurses lived. Those were the days, but sadly we both ended up working with IT. If Jacob responds (he's a rather busy guy) I'll forward the responses to the list. Can I ask you what you think of Lite in general? I don't see many sites using it, but it looks like a cool thing for the right purpose... Best regards, Mogens Saira Somani wrote: Posted 2 messages in Oracle 9i Lite Forum on Metalink. No responses yet. I'm looking to this list for help on either of these issues. Thanks in advance for your time. Please e-mail me privately ([EMAIL PROTECTED]) if this is not the proper forum for these issues. Someone out there has to be using this product :-
RE: Oracle 9i Lite - any help please?
Mogens, Thank you kindly for forwarding my questions to the head honcho. I would be extremely pleased if he responded but not offended if he didn't. Funny enough, we are currently using Lite with Intermec 700 handhelds (StrongARM chipset) running Pocket PC (Windows CE) in hospitals to manage supply carts. Interesting business. So since I have inherited administration of this software, I not an expert yet, but quickly finding out where documentation and logging is sparse. I find that it is quite difficult to figure out where a problem has occurred. Take for example the MSYNC process on the client which synchronizes with the repository on the 8i server. Every time the client syncs, the client tells me it is successful, even though it isn't. Secondly, there is processing that is performed on synchronization - I know for a fact that there is data to be "processed", yet this client never fulfills that request to "process" the data and as a result, changes are not reflected in the repository. Then take migration. I wanted to upgrade from 5.0.1.X.0 to 5.0.2.X.0 - and I found out that I cannot even log into the administrative console. And that would be fine, if there was documentation that told me this is possible (maybe I missed that PDF, I don't know - too much information, too little time). And how about documentation on the tracing. Especially interpretation of the log/trace files - there is no guideline to explain to me what I can expect from the logging/tracing (again, maybe it's me for missing that PDF but I have searched for many months with little success). I think it is a good product with many bugs and I think it can be used very effectively if administered/configured optimally. I just think that there isn't enough expertise out there yet to assist those who have decided to go with this product. From an administrative standpoint, I find it difficult to grasp how and where errors are occurring. Even more difficult is trying to figure out a pattern to the errors. They are sporadic, inconsistent, and show no symptoms. Alerts for MGP failing are non-existent - don't know when it will go down and when it does, I can't explain why. Overall, I can see it having success in the right environment and with a stable release. Hope this helped but didn't offend any. Thanks again, Saira -Original Message- Nørgaard Sent: February 6, 2003 1:00 PM To: Multiple recipients of list ORACLE-L Saira, I've forwarded your message to the CTO of Oracle Lite, my old friend Jacob Christfort, whom I know from our days at the National Hospital Dormitory in Copenhagen, where we had lots of fun, and where many nurses lived. Those were the days, but sadly we both ended up working with IT. If Jacob responds (he's a rather busy guy) I'll forward the responses to the list. Can I ask you what you think of Lite in general? I don't see many sites using it, but it looks like a cool thing for the right purpose... Best regards, Mogens Saira Somani wrote: >Posted 2 messages in Oracle 9i Lite Forum on Metalink. No responses yet. >I'm looking to this list for help on either of these issues. Thanks in >advance for your time. Please e-mail me privately >([EMAIL PROTECTED]) if this is not the proper forum for these >issues. Someone out there has to be using this product :-) > >--- - > > > >RDBMS Version: 8.1.7.0.0 >Operating System and Version: Windows 2000 Server SP3 >Error Number (if applicable): >Product (i.e. SQL*Loader, Import, etc.): Oracle 9i Lite >Product Version: 5.0.1.1 > >MSYNC - records to process yet PROCESSING does not occur > >We have changed records on the client in offline mode and now want to >syncronize with the server. There are records to be processed - yet, in >MSYNC, it goes through COMPOSING, SENDING, RECEIVING but no PROCESSING. >As a result, our records on the server are not updated. MGP is running, >and when we retry, we allow for complete cycles to occur before our next >attempt. > >After trying about 20 times (no kidding), the PROCCESSING bar on the >MSYNC screen works. > >This is unacceptable and not to mention unreliable. Please help. Please >also see my previous message on a related issue. Perhaps you can see a >connection, I can't as yet. > >Thanks, >Saira > >--- - > > > > >RDBMS Version: 8.1.7.0.0 >Operating System and Version: Windows 2000 Server SP3 >Error Number (if applicable): >Product (i.e. SQL*Loader, Import, etc.): Oracle 9i Lite >Product Version: 5.0.1.1 > >MSYNC sticks on PROCESSING bar > >Recently we made a change to a table in our repository in 8i - changed a >primary key. After this, the application was republished in Oracle 9i >Lite and all client databases (Pocket PC Strong ARM) were refreshed >(i.e. database was removed from the client and sync'd 3 times before >usage). > >We have noticed that now, after the change, during
Re: Oracle 9i Lite - any help please?
Saira, I've forwarded your message to the CTO of Oracle Lite, my old friend Jacob Christfort, whom I know from our days at the National Hospital Dormitory in Copenhagen, where we had lots of fun, and where many nurses lived. Those were the days, but sadly we both ended up working with IT. If Jacob responds (he's a rather busy guy) I'll forward the responses to the list. Can I ask you what you think of Lite in general? I don't see many sites using it, but it looks like a cool thing for the right purpose... Best regards, Mogens Saira Somani wrote: Posted 2 messages in Oracle 9i Lite Forum on Metalink. No responses yet. I'm looking to this list for help on either of these issues. Thanks in advance for your time. Please e-mail me privately ([EMAIL PROTECTED]) if this is not the proper forum for these issues. Someone out there has to be using this product :-) RDBMS Version: 8.1.7.0.0 Operating System and Version: Windows 2000 Server SP3 Error Number (if applicable): Product (i.e. SQL*Loader, Import, etc.): Oracle 9i Lite Product Version: 5.0.1.1 MSYNC - records to process yet PROCESSING does not occur We have changed records on the client in offline mode and now want to syncronize with the server. There are records to be processed - yet, in MSYNC, it goes through COMPOSING, SENDING, RECEIVING but no PROCESSING. As a result, our records on the server are not updated. MGP is running, and when we retry, we allow for complete cycles to occur before our next attempt. After trying about 20 times (no kidding), the PROCCESSING bar on the MSYNC screen works. This is unacceptable and not to mention unreliable. Please help. Please also see my previous message on a related issue. Perhaps you can see a connection, I can't as yet. Thanks, Saira RDBMS Version: 8.1.7.0.0 Operating System and Version: Windows 2000 Server SP3 Error Number (if applicable): Product (i.e. SQL*Loader, Import, etc.): Oracle 9i Lite Product Version: 5.0.1.1 MSYNC sticks on PROCESSING bar Recently we made a change to a table in our repository in 8i - changed a primary key. After this, the application was republished in Oracle 9i Lite and all client databases (Pocket PC Strong ARM) were refreshed (i.e. database was removed from the client and sync'd 3 times before usage). We have noticed that now, after the change, during the MSYNC process, that status bar hangs on the PROCESSING phase of MSYNC. The only way to rid this is by warm booting the PDA and trying it multiple times until it is successful (which sometimes it is and sometimes isn't). However, even when the PROCESSING bar has not completed until the end, the data from the PDA is sent but this is unreliable as all the MSYNC processes are not complete. This is inefficient. Any suggestions? Saira Somani IT Support/Analyst Hospital Logistics Inc. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: =?ISO-8859-1?Q?Mogens_N=F8rgaard?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or 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 32bit and 64bit on the same server
As far as having the 32blt client, just create a new home for it. You can use another SID for the /etc/oratab file so that oraenv/coraenv works as it should. Now as far as this application owner having to shutdown & restart the instance, well that is just a pile of BULL. I haven't found the application that needs that level of access. I'd tell the duhveloper to go fly a kite. Dick Goulet =?iso-8859-1?q?Joshua=20Becker?= <[EMAIL PROTECTED]> wrote on 1/25/03 8:49 pm: Hi all, I have a following problem I hope you could help me: I have an UNIX box (Solaris8) where I have installed 9iRel2 64 bit software, also I have created two instances using that 64 bit version. Now we are also having an application which needs 32 bit 9i client software on the same server. The user who owns this application also needs every now and then shutdown and start the instances. How I should configure the profile of this application user. I have an oracle -account who "owns" the instances and the application user is also in dba -group. Thank you in advance, Joshua Gratis e-mail resten av livet på: www.yahoo.se/mail Busenkelt! Hi all, I have a following problem I hope you could help me: I have an UNIX box (Solaris8) where I have installed 9iRel2 64 bit software, also I have created two instances using that 64 bit version. Now we are also having an application which needs 32 bit 9i client software on the same server. The user who owns this application also needs every now and then shutdown and start the instances. How I should configure the profile of this application user. I have an oracle -account who "owns" the instances and the application user is also in dba -group. Thank you in advance, JoshuaGratis e-mail resten av livet på: www.yahoo.se/mail Busenkelt! -- 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 32bit and 64bit on the same server
Joshua, You can have two users named "oracle" (the oracle 64-bit software owner) and "app1" (the app owner). You will create 2 ORACLE_HOMEs, say /u01/oracle/product/9.2/64bit and /u01/oracle/product/9.2/32bit. In the .profile of the app1 owner, the ORACLE_HOME=/u01/oracle/product/9.2/32bit. When the time comes to start or shutdown the instance, you would excute ORACLE_HOME=/u01/oracle/product/9.2/64bit ORACLE_SID=... PATH=$ORACLE_HOME/bin LD_LIBRARY_PATH=$ORACLE_HOME/lib sqlplus -s "/ as sysdba" << EOF shutdown immediate (or startup) EOF That's it. HTH Arup - Original Message - From: Joshua Becker To: Multiple recipients of list ORACLE-L Sent: Saturday, January 25, 2003 11:49 PM Subject: Oracle 9i 32bit and 64bit on the same server Hi all, I have a following problem I hope you could help me: I have an UNIX box (Solaris8) where I have installed 9iRel2 64 bit software, also I have created two instances using that 64 bit version. Now we are also having an application which needs 32 bit 9i client software on the same server. The user who owns this application also needs every now and then shutdown and start the instances. How I should configure the profile of this application user. I have an oracle -account who "owns" the instances and the application user is also in dba -group. Thank you in advance, Joshua Gratis e-mail resten av livet på: www.yahoo.se/mailBusenkelt!
Re: Oracle 9i 32bit and 64bit on the same server
I'm using "sudo" to accomplish something similar; to allow the "operators" to startup & shutdown Oracle. Joshua Becker ahoo.se> cc: Sent by: Subject: Oracle 9i 32bit and 64bit on the same server [EMAIL PROTECTED] 01/25/2003 08:49 PM Please respond to ORACLE-L Hi all, I have a following problem I hope you could help me: I have an UNIX box (Solaris8) where I have installed 9iRel2 64 bit software, also I have created two instances using that 64 bit version. Now we are also having an application which needs 32 bit 9i client software on the same server. The user who owns this application also needs every now and then shutdown and start the instances. How I should configure the profile of this application user. I have an oracle -account who "owns" the instances and the application user is also in dba -group. Thank you in advance, Joshua Gratis e-mail resten av livet på: www.yahoo.se/mail Busenkelt! -- 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 32bit and 64bit on the same server
If your 32-bit install of 9i is only a client install, it need not be in the "dba" group. Of course, the unix owner would be different from that of the 64-bit server install and with a different ORACLE_HOME. Use the 64-bit server install to startup and shutdown the database instance. Hemant At 08:49 PM 25-01-03 -0800, you wrote: Hi all, I have a following problem I hope you could help me: I have an UNIX box (Solaris8) where I have installed 9iRel2 64 bit software, also I have created two instances using that 64 bit version. Now we are also having an application which needs 32 bit 9i client software on the same server. The user who owns this application also needs every now and then shutdown and start the instances. How I should configure the profile of this application user. I have an oracle -account who "owns" the instances and the application user is also in dba -group. Thank you in advance, Joshua Gratis e-mail resten av livet på: www.yahoo.se/mail Busenkelt! Hemant K Chitale My web site page is : http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hemant K Chitale INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or 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 windows
Joe, I wrote Oracle9i RMAN Backup and Recovery using 9iR2. I pounded the database pretty hard. It seemed to be a very solid release and I would recommend it over 9iR1. Robert -Original Message- Armstrong-Champ Sent: Friday, January 17, 2003 10:00 AM To: Multiple recipients of list ORACLE-L We are thinking of upgrading some of our windows databases (NT 4) to 9i. We may be upgrading the OS to w2k also. The databases are small applications and don't require much maintenance. What are people's experience with 9i (9.0.1 and 9.2) on windows? We are mostly concerned with the stability of the releases. I have heard that 9.0.1 has lots of bugs. Does anyone know if this is true? What about 9.2? Thanks. Joe Armstrong-Champ DBA Tufts University [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joe Armstrong-Champ INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Robert Freeman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or 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 survey
We use the automated PGA space management, automated MTTR managemsnt, segment level stats, ausotmatic undo, automatic segment space management and list partitioning features predominantly; and they work like a charm. Arup - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Thursday, January 16, 2003 5:44 PM > Hi lister: > > Just want to know how well you adopt those 9i new features. > (if you are already 9i) > and what's your recommendations about those new features. > (any pros and cons) > > TIA > > --DJ > ITResource > > == > > Oracle9i Database Release 1: New Features > > ANSI ISO SQL Support In Oracle9i > Automatic Segment Free Space Management > Automatic Undo Management > Bitmap Join Indexes > Data Guard > Export And Import Enhancements In Oracle9i > Flashback Query > High Availability Enhancements in Oracle9i > Index Organized Table (IOT) Enhancements in Oracle9i > Index Skip Scanning > LOB Enhancements In Oracle9i > Logminer Enhancements In Oracle9i > Memory Management In Oracle9i > Metadata API > Multiple Block Sizes > Oracle Managed Files > Partitioning Enhancements In Oracle9i > Performance Enhancements In Oracle9i > Persistent Initialization Parameters > Real Application Clusters > Recovery Enhancements In Oracle9i > Recovery Manager (RMAN) Enhancements In Oracle9i > Resource Manager Enhancements In Oracle9i > Resumable Space Allocation > Scalable Session Management > Security Enhancements In Oracle9i > SQL New Features In Oracle9i > Workspace Management In Oracle9i > Advanced Queuing In Oracle9i > External Tables > Heterogeneous Services > > Oracle9i Database Release 2: New Features > Export BLOB Contents Using UTL_FILE > DBMS_XPLAN > Parse XML Documents > Renaming Columns And Constraints > UTL_FILE Enhancements > > > > > > > > > _ > Protect your PC - get McAfee.com VirusScan Online > http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963 > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: David 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: 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 new features survey
We are using automatic undo management and automatic memory management (pga aggregate target) both with much success. -Original Message- Sent: Thursday, January 16, 2003 5:45 PM To: Multiple recipients of list ORACLE-L Hi lister: Just want to know how well you adopt those 9i new features. (if you are already 9i) and what's your recommendations about those new features. (any pros and cons) TIA --DJ ITResource == Oracle9i Database Release 1: New Features ANSI ISO SQL Support In Oracle9i Automatic Segment Free Space Management Automatic Undo Management Bitmap Join Indexes Data Guard Export And Import Enhancements In Oracle9i Flashback Query High Availability Enhancements in Oracle9i Index Organized Table (IOT) Enhancements in Oracle9i Index Skip Scanning LOB Enhancements In Oracle9i Logminer Enhancements In Oracle9i Memory Management In Oracle9i Metadata API Multiple Block Sizes Oracle Managed Files Partitioning Enhancements In Oracle9i Performance Enhancements In Oracle9i Persistent Initialization Parameters Real Application Clusters Recovery Enhancements In Oracle9i Recovery Manager (RMAN) Enhancements In Oracle9i Resource Manager Enhancements In Oracle9i Resumable Space Allocation Scalable Session Management Security Enhancements In Oracle9i SQL New Features In Oracle9i Workspace Management In Oracle9i Advanced Queuing In Oracle9i External Tables Heterogeneous Services Oracle9i Database Release 2: New Features Export BLOB Contents Using UTL_FILE DBMS_XPLAN Parse XML Documents Renaming Columns And Constraints UTL_FILE Enhancements _ Protect your PC - get McAfee.com VirusScan Online http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: David 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: Toepke, Kevin 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 release 3 coming?
9i release 2 is the terminal release. There will not be any release 3 from Oracle. The next major release will be 10i. Got this info from Tom Kyte of Oracle Corp. Shaibal Talukder Sr.Oracle DBA Database Engineering Discover Financial Services From: Jared Still <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Subject: Re: Oracle 9i release 3 coming? Date: Mon, 13 Jan 2003 19:39:04 -0800 Since 9iR2 is 9.2.0, I don't think that 9.0.3 will be Release 3. Jared On Monday 13 January 2003 18:23, Boivin, Patrice J wrote: > Oracle started posting items with the 9.0.3. number, does this imply they > plan to release a 9i Release 3? > > regards, > Patrice Boivin > Systems Analyst (Oracle Certified DBA) > > Systems Admin & Operations | Admin. et Exploit. des systèmes > Technology Services| Services technologiques > Informatics Branch | Direction de l'informatique > Maritimes Region, DFO | Région des Maritimes, MPO > > E-Mail: [EMAIL PROTECTED] Content-Type: text/html; charset="iso-8859-1"; name="Attachment: 1" Content-Transfer-Encoding: quoted-printable Content-Description: -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing _ Add photos to your e-mail with MSN 8. Get 2 months FREE*. http://join.msn.com/?page=features/featuredemail -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Shaibal Talukder INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or 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 3 coming?
> Maybe the version numbers don't mean anything to > them anymore... > > Pat. bingo! Oracle 9iAS 9.0.3 is still Release 2 __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Barbara Baker INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or 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 3 coming?
Actually, I see references to iAS 9.0.3 and 9.0.4 in various places on Metalink. I think the real difference will be when iAS 9.0.6 is released, which at one time was supposed to be this quarter. A lot of things are supposedly fixed/enhanced in 9.0.5 which won't be released to the public. It'll be interesting to see what gooberish name they come up with for 9.0.6. Jim -Original Message- Sent: Tuesday, January 14, 2003 8:59 AM To: Multiple recipients of list ORACLE-L If they release 9.0.3. items for iAS, will they call that iAS 9i Release 3 or iAS 10i? Maybe the version numbers don't mean anything to them anymore... Pat. -Original Message- Sent: Monday, January 13, 2003 11:49 PM To: Multiple recipients of list ORACLE-L doubtful, they've said that release 2 is the final release for 9i --- "Boivin, Patrice J" <[EMAIL PROTECTED]> wrote: > Oracle started posting items with the 9.0.3. number, does this imply > they > plan to release a 9i Release 3? > > regards, > Patrice Boivin > Systems Analyst (Oracle Certified DBA) > > Systems Admin & Operations | Admin. et Exploit. des systèmes > Technology Services| Services technologiques > Informatics Branch | Direction de l'informatique > Maritimes Region, DFO | Région des Maritimes, MPO > > E-Mail: [EMAIL PROTECTED] > > > __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.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: 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: <[EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle 9i release 3 coming?
If they release 9.0.3. items for iAS, will they call that iAS 9i Release 3 or iAS 10i? Maybe the version numbers don't mean anything to them anymore... Pat. -Original Message- Sent: Monday, January 13, 2003 11:49 PM To: Multiple recipients of list ORACLE-L doubtful, they've said that release 2 is the final release for 9i --- "Boivin, Patrice J" <[EMAIL PROTECTED]> wrote: > Oracle started posting items with the 9.0.3. number, does this imply > they > plan to release a 9i Release 3? > > regards, > Patrice Boivin > Systems Analyst (Oracle Certified DBA) > > Systems Admin & Operations | Admin. et Exploit. des systèmes > Technology Services| Services technologiques > Informatics Branch | Direction de l'informatique > Maritimes Region, DFO | Région des Maritimes, MPO > > E-Mail: [EMAIL PROTECTED] > > > __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.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: 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 release 3 coming?
Title: Internet file system Hi I think you are seeing notes on the latest release of 9iAS which is 9.0.3. Ben -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Boivin, Patrice JSent: January 13, 2003 9:24 PMTo: Multiple recipients of list ORACLE-LSubject: Oracle 9i release 3 coming? Oracle started posting items with the 9.0.3. number, does this imply they plan to release a 9i Release 3? regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin & Operations | Admin. et Exploit. des systèmes Technology Services | Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED]
Re: Oracle 9i release 3 coming?
Since 9iR2 is 9.2.0, I don't think that 9.0.3 will be Release 3. Jared On Monday 13 January 2003 18:23, Boivin, Patrice J wrote: > Oracle started posting items with the 9.0.3. number, does this imply they > plan to release a 9i Release 3? > > regards, > Patrice Boivin > Systems Analyst (Oracle Certified DBA) > > Systems Admin & Operations | Admin. et Exploit. des systèmes > Technology Services| Services technologiques > Informatics Branch | Direction de l'informatique > Maritimes Region, DFO | Région des Maritimes, MPO > > E-Mail: [EMAIL PROTECTED] Content-Type: text/html; charset="iso-8859-1"; name="Attachment: 1" Content-Transfer-Encoding: quoted-printable Content-Description: -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Oracle 9i release 3 coming?
doubtful, they've said that release 2 is the final release for 9i --- "Boivin, Patrice J" <[EMAIL PROTECTED]> wrote: > Oracle started posting items with the 9.0.3. number, does this imply > they > plan to release a 9i Release 3? > > regards, > Patrice Boivin > Systems Analyst (Oracle Certified DBA) > > Systems Admin & Operations | Admin. et Exploit. des systèmes > Technology Services| Services technologiques > Informatics Branch | Direction de l'informatique > Maritimes Region, DFO | Région des Maritimes, MPO > > E-Mail: [EMAIL PROTECTED] > > > __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.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 installation - Basic Qs - HELP!
I had problems running Exceed XWindows and the 9i V2 installer - turned out the TCP/IP stack on my W2K system was fubar'd - uninstalled, reinstalled TCP/IP then I could run the installer and X-Window. ~brian -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]Sent: Wednesday, December 11, 2002 9:34 AMTo: Multiple recipients of list ORACLE-LSubject: RE: Oracle 9i installation - Basic Qs - HELP! Apparently there are some problems running eXceed and Oracle 9i V2 Oracle installer. I went back to using a Xwindows from a Unix console to do the install. Now I am trying to find a way to run dbca from Windows for Unix database - must be a way - huh. -Original Message-From: Hemant K Chitale [mailto:[EMAIL PROTECTED]]Sent: Wednesday, December 11, 2002 9:54 AMTo: Multiple recipients of list ORACLE-LSubject: RE: Oracle 9i installation - Basic Qs - HELP!Is "clientip" the Unix server or or [Windows] client ?If it is the Unix server, you need to run "xhost +"e.g. if you have logged in to the Unix server through atelnet session and set DISPLAY=client:0.0, prior todo so, you must run "xhost +clientip" from your Unix server X console.If "clientip" is your Windows client, you must be runningReflection X [or eXceed ?] on your PC --- I am talking ofthe X-server program, not the telnet client.HemantAt 11:01 AM 10-12-02 -0800, you wrote: Guys, I followed the instructions but still got: Xlib: connection to "clientip:0.0" refused by server Xlib: Client is not authorized to connect to Server xhost: unable to open display "clientip:0.0" I think I am missing one of the e-mails. Tried running to root, changing exceed configuration (xfile). Do I need to just do this at console?-Original Message- From: Hately, Mike (NESL-IT) [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 27, 2002 4:24 AM To: Multiple recipients of list ORACLE-L Subject: RE: Oracle 9i installation - Basic Qs Agreed Jared. I was playing the percentages for the sake of a quick, clear answer. In my experience most of the time it's going to be root. Cheers, Mike -Original Message- Sent: 26 November 2002 17:44 To: Multiple recipients of list ORACLE-L Mike, Not necessarily. It depends on who started the Xsession. I regularly run 'xhost' on my workstation as a non-root user. Root is unable to do so on the same machine. Jared "Hately, Mike (NESL-IT)" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 11/26/2002 07:54 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject: RE: Oracle 9i installation - Basic Qs Hi, you'll need to be signed in as root in order to run the "xhost +" command. The rest of that looks fine so : as root : xhost + as oracle_user : export DISPLAY=:0.0 xclock (to test yopur X config) NB Exceed has its own array of bugs when used with the Oracle installer. Good luck and I hope the 9i instaler handles Exceed better. regards, Mike Hately -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hately, Mike (NESL-IT) INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Hemant K ChitaleMy web site page is : http://hkchital.tripod.com-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hemant K Chitale INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or 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 installation - Basic Qs - HELP!
Apparently there are some problems running eXceed and Oracle 9i V2 Oracle installer. I went back to using a Xwindows from a Unix console to do the install. Now I am trying to find a way to run dbca from Windows for Unix database - must be a way - huh. -Original Message-From: Hemant K Chitale [mailto:[EMAIL PROTECTED]]Sent: Wednesday, December 11, 2002 9:54 AMTo: Multiple recipients of list ORACLE-LSubject: RE: Oracle 9i installation - Basic Qs - HELP!Is "clientip" the Unix server or or [Windows] client ?If it is the Unix server, you need to run "xhost +"e.g. if you have logged in to the Unix server through atelnet session and set DISPLAY=client:0.0, prior todo so, you must run "xhost +clientip" from your Unix server X console.If "clientip" is your Windows client, you must be runningReflection X [or eXceed ?] on your PC --- I am talking ofthe X-server program, not the telnet client.HemantAt 11:01 AM 10-12-02 -0800, you wrote: Guys, I followed the instructions but still got: Xlib: connection to "clientip:0.0" refused by server Xlib: Client is not authorized to connect to Server xhost: unable to open display "clientip:0.0" I think I am missing one of the e-mails. Tried running to root, changing exceed configuration (xfile). Do I need to just do this at console?-Original Message- From: Hately, Mike (NESL-IT) [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 27, 2002 4:24 AM To: Multiple recipients of list ORACLE-L Subject: RE: Oracle 9i installation - Basic Qs Agreed Jared. I was playing the percentages for the sake of a quick, clear answer. In my experience most of the time it's going to be root. Cheers, Mike -Original Message- Sent: 26 November 2002 17:44 To: Multiple recipients of list ORACLE-L Mike, Not necessarily. It depends on who started the Xsession. I regularly run 'xhost' on my workstation as a non-root user. Root is unable to do so on the same machine. Jared "Hately, Mike (NESL-IT)" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 11/26/2002 07:54 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject: RE: Oracle 9i installation - Basic Qs Hi, you'll need to be signed in as root in order to run the "xhost +" command. The rest of that looks fine so : as root : xhost + as oracle_user : export DISPLAY=:0.0 xclock (to test yopur X config) NB Exceed has its own array of bugs when used with the Oracle installer. Good luck and I hope the 9i instaler handles Exceed better. regards, Mike Hately -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hately, Mike (NESL-IT) INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Hemant K ChitaleMy web site page is : http://hkchital.tripod.com-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hemant K Chitale INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or 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 installation - Basic Qs - HELP!
Is "clientip" the Unix server or or [Windows] client ? If it is the Unix server, you need to run "xhost +" e.g. if you have logged in to the Unix server through a telnet session and set DISPLAY=client:0.0, prior to do so, you must run "xhost +clientip" from your Unix server X console. If "clientip" is your Windows client, you must be running Reflection X [or eXceed ?] on your PC --- I am talking of the X-server program, not the telnet client. Hemant At 11:01 AM 10-12-02 -0800, you wrote: Guys, I followed the instructions but still got: Xlib: connection to "clientip:0.0" refused by server Xlib: Client is not authorized to connect to Server xhost: unable to open display "clientip:0.0" I think I am missing one of the e-mails. Tried running to root, changing exceed configuration (xfile). Do I need to just do this at console? -Original Message- From: Hately, Mike (NESL-IT) [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 27, 2002 4:24 AM To: Multiple recipients of list ORACLE-L Subject: RE: Oracle 9i installation - Basic Qs Agreed Jared. I was playing the percentages for the sake of a quick, clear answer. In my experience most of the time it's going to be root. Cheers, Mike -Original Message- Sent: 26 November 2002 17:44 To: Multiple recipients of list ORACLE-L Mike, Not necessarily. It depends on who started the Xsession. I regularly run 'xhost' on my workstation as a non-root user. Root is unable to do so on the same machine. Jared "Hately, Mike (NESL-IT)" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 11/26/2002 07:54 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject: RE: Oracle 9i installation - Basic Qs Hi, you'll need to be signed in as root in order to run the "xhost +" command. The rest of that looks fine so : as root : xhost + as oracle_user : export DISPLAY=:0.0 xclock (to test yopur X config) NB Exceed has its own array of bugs when used with the Oracle installer. Good luck and I hope the 9i instaler handles Exceed better. regards, Mike Hately -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hately, Mike (NESL-IT) INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Hemant K Chitale My web site page is : http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hemant K Chitale INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or 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 installation - Basic Qs - HELP!
Title: RE: Oracle 9i installation - Basic Qs - HELP! Guys, I followed the instructions but still got: Xlib: connection to "clientip:0.0" refused by server Xlib: Client is not authorized to connect to Server xhost: unable to open display "clientip:0.0" I think I am missing one of the e-mails. Tried running to root, changing exceed configuration (xfile). Do I need to just do this at console? -Original Message- From: Hately, Mike (NESL-IT) [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 27, 2002 4:24 AM To: Multiple recipients of list ORACLE-L Subject: RE: Oracle 9i installation - Basic Qs Agreed Jared. I was playing the percentages for the sake of a quick, clear answer. In my experience most of the time it's going to be root. Cheers, Mike -Original Message- Sent: 26 November 2002 17:44 To: Multiple recipients of list ORACLE-L Mike, Not necessarily. It depends on who started the Xsession. I regularly run 'xhost' on my workstation as a non-root user. Root is unable to do so on the same machine. Jared "Hately, Mike (NESL-IT)" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 11/26/2002 07:54 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject: RE: Oracle 9i installation - Basic Qs Hi, you'll need to be signed in as root in order to run the "xhost +" command. The rest of that looks fine so : as root : xhost + as oracle_user : export DISPLAY=:0.0 xclock (to test yopur X config) NB Exceed has its own array of bugs when used with the Oracle installer. Good luck and I hope the 9i instaler handles Exceed better. regards, Mike Hately -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hately, Mike (NESL-IT) INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or 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 Version Statistics
Jacques - I wonder if he was referring to STATSPACK in Oracle Version 9i? OpenWorld has a presentation on that. The other idea is that 9i has schema versioning, where users can check out a table, make changes to it, and then you can merge the changes back together.. Look under Database Workspace Management. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, December 09, 2002 1:14 PM To: Multiple recipients of list ORACLE-L I had a colleague ask me about "Oracle 9i Version Statistics". I couldn't see anything about that on Metalink, 9.2 / 9.0 new features guide, or through a Google search. Is there such a thing or did the colleague misread the name of a new feature? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle 9i installation - Basic Qs
On Switching Off the BROADCAST IP Address within Exceed Application , thereafter # xhost+ succeeded HTH -Original Message- Sent: Wednesday, November 27, 2002 2:54 PM To: Multiple recipients of list ORACLE-L Agreed Jared. I was playing the percentages for the sake of a quick, clear answer. In my experience most of the time it's going to be root. Cheers, Mike -Original Message- Sent: 26 November 2002 17:44 To: Multiple recipients of list ORACLE-L Mike, Not necessarily. It depends on who started the Xsession. I regularly run 'xhost' on my workstation as a non-root user. Root is unable to do so on the same machine. Jared "Hately, Mike (NESL-IT)" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 11/26/2002 07:54 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:RE: Oracle 9i installation - Basic Qs Hi, you'll need to be signed in as root in order to run the "xhost +" command. The rest of that looks fine so : as root : xhost + as oracle_user : export DISPLAY=:0.0 xclock(to test yopur X config) NB Exceed has its own array of bugs when used with the Oracle installer. Good luck and I hope the 9i instaler handles Exceed better. regards, Mike Hately -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hately, Mike (NESL-IT) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: VIVEK_SHARMA INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or 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 installation - Basic Qs
Agreed Jared. I was playing the percentages for the sake of a quick, clear answer. In my experience most of the time it's going to be root. Cheers, Mike -Original Message- Sent: 26 November 2002 17:44 To: Multiple recipients of list ORACLE-L Mike, Not necessarily. It depends on who started the Xsession. I regularly run 'xhost' on my workstation as a non-root user. Root is unable to do so on the same machine. Jared "Hately, Mike (NESL-IT)" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 11/26/2002 07:54 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:RE: Oracle 9i installation - Basic Qs Hi, you'll need to be signed in as root in order to run the "xhost +" command. The rest of that looks fine so : as root : xhost + as oracle_user : export DISPLAY=:0.0 xclock(to test yopur X config) NB Exceed has its own array of bugs when used with the Oracle installer. Good luck and I hope the 9i instaler handles Exceed better. regards, Mike Hately -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hately, Mike (NESL-IT) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or 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 installation - Basic Qs
'xhost +' is terribly insecure. 'xhost ' would be better. Jared "Nancy McCormick" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 11/26/2002 07:59 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:RE: Oracle 9i installation - Basic Qs Try executing the xhost command as root first. Then you should be able to execute xhost + command. Nancy -Original Message- VIVEK_SHARMA Sent: Tuesday, November 26, 2002 8:39 AM To: Multiple recipients of list ORACLE-L Oracle 9i installation on Solaris being attempted # xhost + Message - unable to open display : " " export DISPLAY=:0.0 # xhost + Xlib : connection to client refused "" Xlib : cannot set display to "" NOTE - Installation being initiated from a laptop using Exceed Hummingbird software to simulate Xwindows Console Any Solutions ? Thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: VIVEK_SHARMA INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nancy McCormick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle 9i installation - Basic Qs
Mike, Not necessarily. It depends on who started the Xsession. I regularly run 'xhost' on my workstation as a non-root user. Root is unable to do so on the same machine. Jared "Hately, Mike (NESL-IT)" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 11/26/2002 07:54 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:RE: Oracle 9i installation - Basic Qs Hi, you'll need to be signed in as root in order to run the "xhost +" command. The rest of that looks fine so : as root : xhost + as oracle_user : export DISPLAY=:0.0 xclock(to test yopur X config) NB Exceed has its own array of bugs when used with the Oracle installer. Good luck and I hope the 9i instaler handles Exceed better. regards, Mike Hately -Original Message- Sent: 26 November 2002 14:39 To: Multiple recipients of list ORACLE-L Oracle 9i installation on Solaris being attempted # xhost + Message - unable to open display : " " export DISPLAY=:0.0 # xhost + Xlib : connection to client refused "" Xlib : cannot set display to "" NOTE - Installation being initiated from a laptop using Exceed Hummingbird software to simulate Xwindows Console Any Solutions ? Thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: VIVEK_SHARMA INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hately, Mike (NESL-IT) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle 9i installation - Basic Qs
I think the problem is the client. Does it have an xauth setting somewhere? > -Original Message- > Oracle 9i installation on Solaris being attempted > # xhost + > Message - unable to open display : " " > export DISPLAY=:0.0 > # xhost + > Xlib : connection to client refused "" > Xlib : cannot set display to "" > NOTE - Installation being initiated from a laptop using > Exceed Hummingbird > software to simulate Xwindows Console -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle 9i installation - Basic Qs
on the client pc: Right click exceed - tools - configuration - security - host access control list I use file: click edit and add the ip address to let the db server connect to the x-server on your pc. > -Original Message- > From: VIVEK_SHARMA [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, November 26, 2002 9:39 AM > To: Multiple recipients of list ORACLE-L > Subject: Oracle 9i installation - Basic Qs > > > > Oracle 9i installation on Solaris being attempted > # xhost + > Message - unable to open display : " " > export DISPLAY=:0.0 > # xhost + > Xlib : connection to client refused "" > Xlib : cannot set display to "" > NOTE - Installation being initiated from a laptop using > Exceed Hummingbird software to simulate Xwindows Console > > Any Solutions ? > > Thanks > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: VIVEK_SHARMA > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Anderson, Brian INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or 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 installation - Basic Qs
Hi, you'll need to be signed in as root in order to run the "xhost +" command. The rest of that looks fine so : as root : xhost + as oracle_user : export DISPLAY=:0.0 xclock(to test yopur X config) NB Exceed has its own array of bugs when used with the Oracle installer. Good luck and I hope the 9i instaler handles Exceed better. regards, Mike Hately -Original Message- Sent: 26 November 2002 14:39 To: Multiple recipients of list ORACLE-L Oracle 9i installation on Solaris being attempted # xhost + Message - unable to open display : " " export DISPLAY=:0.0 # xhost + Xlib : connection to client refused "" Xlib : cannot set display to "" NOTE - Installation being initiated from a laptop using Exceed Hummingbird software to simulate Xwindows Console Any Solutions ? Thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: VIVEK_SHARMA INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hately, Mike (NESL-IT) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or 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 installation - Basic Qs
Try executing the xhost command as root first. Then you should be able to execute xhost + command. Nancy -Original Message- VIVEK_SHARMA Sent: Tuesday, November 26, 2002 8:39 AM To: Multiple recipients of list ORACLE-L Oracle 9i installation on Solaris being attempted # xhost + Message - unable to open display : " " export DISPLAY=:0.0 # xhost + Xlib : connection to client refused "" Xlib : cannot set display to "" NOTE - Installation being initiated from a laptop using Exceed Hummingbird software to simulate Xwindows Console Any Solutions ? Thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: VIVEK_SHARMA INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nancy McCormick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).