Which server do u use for 9ias ?
At our university, we are planning to use 9iasR2 in production in a near future. What type of server do you people use for it? Does it need a lot of memory, more than 1 cpu ? It will mostly be used with modplsql procedure and we hope to deploy Discoverer. We are thinking about a X series IBM server with 4 Gig of memory. Would it be better to have 2 2.4Gh cpu or 1 3Gh cpu ? Any thought will be appreciated. Louis Brouillette Analyste en informatique (DBA) Universite du Quebec a Trois-Rivieres Tel: (819) 376-5011 ext. 2435 Email: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Louis BROUILLETTE INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Redo Logs Problem
I had a similar problem once. The problem was me. I activated some auditing and forgot about it. It was generating a lot of redo. hth. -Original Message- From: Munish Bajaj [mailto:[EMAIL PROTECTED] Sent: Friday, August 01, 2003 4:04 PM To: Multiple recipients of list ORACLE-L Subject: Redo Logs Problem Hi Listers, One of my remote Clients is facing a problem with Redo Logs. The Redo Logs and the Archive logs in turn have suddenly started to generate at an alarming Rate. This has suddenly started from the last 1 week without any changes to Database Configuration or any other system settings (as per client). Can anyone please help me and let me know all the reasons that could be responsible for this behavior. Any Help from u will be appreciated. Regards Munish Bajaj 1de09da7.jpg Louis Brouillette Analyste en informatique (DBA) Universite du Quebec a Trois-Rivieres Tel: (819) 376-5011 ext. 2435 Email: [EMAIL PROTECTED] <<1de09da7.jpg>>
RE: Compare Schema with data
Rich, I meant that I would compare the 2 "insert statements" files with the "files compare" of TOAD instead of comparing with sdiff. It's a lot easier to see the differences between the files. At 13:55 2003-06-17 -0800, you wrote: Hi Louis, That sounds cool, but where can you compare table data in TOAD? The only options I see (TOAD 7.5 registered and TOAD 7.5.3.28 BETA w/DBA module) are for the object definitions of schemas and not the data itself. Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA > -Original Message----- > From: Louis BROUILLETTE [mailto:[EMAIL PROTECTED] > Sent: Tuesday, June 17, 2003 2:55 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: Compare Schema with data > > > I think that's a good way to do it but I would use the > "Compare files" of > TOAD which is much nicer to look at than sdiff. > At 11:04 2003-06-17 -0800, you wrote: > >TOAD v7.5 will allow you to "export" INSERT statements of > all the data in a > >table. I've FTP'd these INSERT statements to a Unix box to > run "sdiff -s" > >between the files in order to get the differences. Yes, it's a bit > >"manual", but the price is right (ours was <$350/copy back > in the 1900s). > >You can evaluate TOAD by filling out the contact form at: > > > >http://www.quest.com/toad/ > > > >...and click on the "Download Trial" link on the left. > > > > > >HTH! > > > >Rich > > > >Rich Jesse System/Database Administrator > >[EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA > > > > > -Original Message- > > > From: Stephen Lee [mailto:[EMAIL PROTECTED] > > > Sent: Tuesday, June 17, 2003 1:20 PM > > > To: Multiple recipients of list ORACLE-L > > > Subject: RE: Compare Schema with data > > > > > > > > > > > > I think DB Artisan Change Manager will do it. > > > > > > > -Original Message- > > > > Is any body know any tools for comparing two schema for only > > > > data comparison > > > > & create script for the result -- 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). Louis Brouillette Analyste en informatique (DBA) Universite du Quebec a Trois-Rivieres Tel: (819) 376-5011 ext. 2435 Email: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Louis BROUILLETTE INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Compare Schema with data
I think that's a good way to do it but I would use the "Compare files" of TOAD which is much nicer to look at than sdiff. At 11:04 2003-06-17 -0800, you wrote: TOAD v7.5 will allow you to "export" INSERT statements of all the data in a table. I've FTP'd these INSERT statements to a Unix box to run "sdiff -s" between the files in order to get the differences. Yes, it's a bit "manual", but the price is right (ours was <$350/copy back in the 1900s). You can evaluate TOAD by filling out the contact form at: http://www.quest.com/toad/ ...and click on the "Download Trial" link on the left. HTH! Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA > -Original Message- > From: Stephen Lee [mailto:[EMAIL PROTECTED] > Sent: Tuesday, June 17, 2003 1:20 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: Compare Schema with data > > > > I think DB Artisan Change Manager will do it. > > > -Original Message- > > Is any body know any tools for comparing two schema for only > > data comparison > > & create script for the result > -- -- 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). Louis Brouillette Analyste en informatique (DBA) Universite du Quebec a Trois-Rivieres Tel: (819) 376-5011 ext. 2435 Email: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Louis BROUILLETTE INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Anyone successfully installed 9ias on AIX 4.3.3 ?
Hi list, Is there someone out there who successfully installed 9ias (9.0.2.0.1) on AIX 4.3.3 ? If yes, were you able to meet all the pre-requisites (OS patches, java version, ...) ? My installation fails in the configuration tools (dbca). I always get a "Lost contact" message. My sys admin could not get his hands on some OS patches (vacpp.dax.adt, vacpp.vb.adt) and our java version is newer than the one listed in the pre-requisites (we have build ca131-20021102 instead of cal131-20020821). Any ideas ??? Louis Brouillette Analyste en informatique (DBA) Universite du Quebec a Trois-Rivieres Tel: (819) 376-5011 ext. 2435 Email: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Louis BROUILLETTE INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Follow-up: It's NOT possible to set role in db's logon
Hi Roy, I don't know if you solved your problem yet but I have a similar situation here. I have an Oracle account used by PHP programs (third party programs) to access some tables. I don't want anyone to log in to the database with this account unless the connection comes from apache and from our web server machine. So what I did is that I created a logon trigger on that schema and if the conditions are not met, then I raise an application error and the connection dies. As you know, these informations (program, machine, etc...) can be found in v$session and the SID of the current session can be found with "select sid from v$mystat where rownum = 1". HTH. Louis At 15:13 2003-01-27 -0800, you wrote: In case anyone cares--it looks like it is *not* possible to set a role in an after logon trigger. Had I only looked at metalink: AFTER LOGON Triggers Don't Allow DBMS_SESSION.SET_ROLE to Keep Roles Enabled http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_datab ase_id=NOT&p_id=106140.1 Bummer, that. Thanks again to all who responded. Cheers, -Roy Roy Pardee Programmer/Analyst SWFPAC Lockheed Martin IT Extension 8487 -Original Message- Sent: Monday, January 13, 2003 7:42 AM To: 'ORACLE-L' Greetings all, I'm trying to support a COTS application that is back-end agnostic & makes only minimal use of security on the db. In particular, it requires that users be granted a default role that has *very* heavy permissions--enough to do some major mischief should they ever figure out how to use odbc or sql*plus. My collegues & I have devised a kludgy method for getting around this problem, involving a shill startup program that turns the default-ness of the role on & off in conjunction with users opening & closing the client program. This works, but is a pain to maintain. I've recently discovered the v$session.program field & am now wondering whether it would be possible to use the new-fangled logon system trigger to set the role only for cases where v$session.program = the COTS client. Can anybody comment as to whether this is a viable approach on an 8.1.6 database & if not, on a 9i db? In particular, there are two things I don't know--first, how to select just the one row in v$session that corresponds to the current connection. If a user was to start up the COTS client & then connect to the same db via sql*plus, I would want the role set *only* for the COTS client session. My best thought so far here is to use the most recently started connection based on v$session.logon_time. Second, whether the SET ROLE statement is legal in a logon trigger. All help will be most welcome. Thanks! -Roy Roy Pardee Programmer/Analyst SWFPAC Lockheed Martin IT Extension 8487 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pardee, Roy E INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Louis Brouillette Analyste en informatique (DBA) Universite du Quebec a Trois-Rivieres Tel: (819) 376-5011 ext. 2435 Email: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Louis BROUILLETTE INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or 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 is a time machine!!
For what I can recall, there was an "adjustment" in 1582 in the calendar to make it fit with the reality. They introduced the leap years and the cut 10 days in october 1582. I think they went from october 4 to october 15. At 10:19 2002-11-22 -0800, you wrote: It must have converted the date to metric. -Original Message- Sent: Friday, November 22, 2002 12:55 PM To: Multiple recipients of list ORACLE-L Don't believe me?? Try this: create table test(the_date date); insert into test values (to_date('10-05-1582','mm-dd-') ); select to_char(the_date, 'mm/dd/') from test; What do you get? :-)) Robert G. Freeman - Oracle OCP Oracle Database Architect CSX Midtier Database Administration Author of several Oracle books you can find on Amazon.com! Londo Mollari: Ah, arrogance and stupidity all in the same package. How efficient of you. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Freeman, Robert INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Hayes, Scott INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Louis Brouillette Analyste en informatique (DBA) Universite du Quebec a Trois-Rivieres Tel: (819) 376-5011 ext. 2435 Email: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Louis BROUILLETTE INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: How to get rid of a column default value ?
Thanks Dale, Michael and Ron. The "default null" is what I thought about first and it almost does the job. It's just that it appears like there is a default value which is null. If I don't include the DEFAULT clause, it does nothing. I think I'll have to live with the "default null". At 08:29 2002-10-04 -0800, you wrote: >Louis, > I believe it is the ALTER TABLE command. >ALTER TABLE name >MODIFY ( column datatype); >match the column name and the datatype but do not include the DEFAULT >clause . >Ron >ROR mª¿ªm > > >>> [EMAIL PROTECTED] 10/04/02 11:28AM >>> >Anyone knows how to get rid of a column default value ? I rtfm and >search >metalink with no luck. Louis Brouillette Analyste en informatique (DBA) Universite du Quebec a Trois-Rivieres Tel: (819) 376-5011 ext. 2435 Email: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Louis BROUILLETTE INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
How to get rid of a column default value ?
Anyone knows how to get rid of a column default value ? I rtfm and search metalink with no luck. Louis Brouillette Analyste en informatique (DBA) Universite du Quebec a Trois-Rivieres Tel: (819) 376-5011 ext. 2435 Email: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Louis BROUILLETTE INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Problems putting on 8.1.7.4 patchset
Hi Scott, I think I had that problem on AIX. As far as I can remember, when the installer stops, I just delete the original file, ask the installer to try again and then it works. HTH At 13:21 2002-08-23 -0800, you wrote: >Hello list, > >I just installed an Oracle 8.1.7.0.0 database and I am trying to put the >8.1.7.4.0 patchset on it. I get to the Install part on the Installer and >when it gets to the $ORACLE_HOME/lib/libwtc8.sl file, I get: "Error in >writing to file $ORACLE_HOME/lib/libwtc8.sl" I have tried to cancel this >and start it over, I've tried to remove the whole patcheset and ftp it >down again, and still no luck. It stops here every time. > >Could someone please help. > >TIA > >** >Scott Stefick >UNIX Systems Administrator >Oracle Certified Professional DBA >Wm. Rainey Harper College >847.925.6130 >** >-- Louis Brouillette Analyste en informatique (DBA) Universite du Quebec a Trois-Rivieres Tel: (819) 376-5011 ext. 2435 Email: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Louis BROUILLETTE INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).