Re: Oracle Real Application Clusters
Is it possible to download the ORAC software from some site, if so where from..?
Re: Port usage?
Don Oracle is doing the normal ting : it is using port 1521 for calls to find the listener and then calling back on another port to spread the load over multiple port's. This is done a port has a limited queue to hold in- and out- coming messages. If you what to use Oracle listener and database behind a firewall by a sql*net proxy for the firewall and the firewall is then able to handle sql*net without problems. Don wrote: Environment: Oracle 8.1.6 AIX server behind a firewall db is accessed by a Windows application running on a IIS web server sitting outside the firewall db uses port 1521 After a flurry of email between the Unix admin and the 4 software vendors concerned, all the fingers are now pointing at that damn oracle database. The Unix admin is asking two questions: 1) what Oracle is doing with the four ports 20,000 - 20,003 2) can he shut them down? Any ideas are appreciated. -- Peter Gram, Miracle A/S Phone : +45 2527 7107, Fax : +45 4466 8856 mailto:peter.gram;MiracleAS.dk - http://MiracleAS.dk smime.p7s Description: application/pkcs7-signature
RE: oracle or mssql
goodmorning everybody who responded to my basic question : thanks summary professional : use oracle enterprise edition semi professional : use oracle standard edition / mssql enterprise edition in all other cases mssql standard edition -Oorspronkelijk bericht- Van: Mohammad Rafiq [SMTP:[EMAIL PROTECTED]] Verzonden:woensdag 23 oktober 2002 20:51 Aan: Multiple recipients of list ORACLE-L Onderwerp:RE: oracle or mssql Xenix is history now...SCO itself stopped it sometime in 1990 Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Wed, 23 Oct 2002 09:02:19 -0800 XENIX maybe. : ) 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] -Original Message- Sent: Wednesday, October 23, 2002 12:59 PM To: Multiple recipients of list ORACLE-L Is MSSQL server available on UNIX? -Rachna -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Get faster connections -- switch to MSN Internet Access! http://resourcecenter.msn.com/access/plans/default.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohammad Rafiq INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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).
how many async_io processes to invoke? - AIX ora 7.3
list, to give async_io a boost, i increased the minimum server parameter in AIX to 15 (from 2) .. now while doing a ps -Al i see only 4 kproc which are busy !! rest has ZERO excution time infront of them.. !! how do i determine the optimum number of minimum async_io servers for a db which has 1) all files (17 of them) on raw volumes, spread over 4 disks 2) two files are hot.. both on separate hdisks 3) process inserts 20million+ records in two big tables TIA -rahul -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rahul INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Port usage?
we had the same problem and we found that oracle use the standard port only to make the initial connection. All the traffic after that is done on different ports. So you need to open the range that oracle use in the firewall. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, October 24, 2002 8:13 AM Environment: Oracle 8.1.6 AIX server behind a firewall db is accessed by a Windows application running on a IIS web server sitting outside the firewall db uses port 1521 After a flurry of email between the Unix admin and the 4 software vendors concerned, all the fingers are now pointing at that damn oracle database. The Unix admin is asking two questions: 1) what Oracle is doing with the four ports 20,000 - 20,003 2) can he shut them down? Any ideas are appreciated. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Don INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Download Oracle 7.3.4
Although, you should *apparently* be able to load the 7.3.4 version of SCO on Linux - or maybe that's just an urban myth! Yes, i remember installing the first version of 8 on Linux (hey I had some time on my hands) and it was a bit of a nightmare - back to the days when Oracle had 2 hits on metalink for Linux! ;-) Lewis Bishop --- Barclays Enable - ISS - E-NTRUST/Bexleyheath NT Oracle Database Consultant Watling Street, Bexleyheath, Kent, DA6 7RR (Mail Van R) Phone : 020 8298 3418 Mobile: 07950 380857 Email : [EMAIL PROTECTED] Enabling Competitive Advantage for Barclays in IT and Business Processing -Original Message- Sent: 23 October 2002 22:29 To: Multiple recipients of list ORACLE-L The first version of Oracle that ran on Linux was the early adoptor pre-release of 8.0.5 in 1998 -Original Message- Sent: Wednesday, October 23, 2002 4:39 PM To: Multiple recipients of list ORACLE-L Hi list, I need to do some testing in an Oracle 7.3.4 for linux (redhat), where can I download this Oracle version from? it doesn't appear to be online in OTN. thanks for your help. Greetings Diego Cutrone -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: dcutrone INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Sherman, Edward INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Bishop Lewis INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Port usage?
the firewall should use sqlnet proxy. most firewalls support it and if this one doesn't scrap it! only the initial connection is made on port 1521. [EMAIL PROTECTED] 10/24/02 05:44AM we had the same problem and we found that oracle use the standard port only to make the initial connection. All the traffic after that is done on different ports. So you need to open the range that oracle use in the firewall. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, October 24, 2002 8:13 AM Environment: Oracle 8.1.6 AIX server behind a firewall db is accessed by a Windows application running on a IIS web server sitting outside the firewall db uses port 1521 After a flurry of email between the Unix admin and the 4 software vendors concerned, all the fingers are now pointing at that damn oracle database. The Unix admin is asking two questions: 1) what Oracle is doing with the four ports 20,000 - 20,003 2) can he shut them down? Any ideas are appreciated. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Don INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gene Sais INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Suse 7.1 Oracle 8.1.7
Good day to everyone * After installing 8.1.7 on Suse 7.1 there is glibc patch from technet that has to be applied... No problems here... But, after applying 8.1.7.4 patch do I have to run glibc patch once again? * Does Suse 7.1 (and it's utilities tar, gzip...) together with ext3 file system support files over 2GB in size? Thanks, Vladimir Barac
secure connection
Hi, how can I be sure that the connection between our web server and Oracle Server to be secure. What's the best method to accomplish this? Any good links for Oracle Nwtwork Security. Any help would be greatly appreciated. Murat -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: MURAT BALKAS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Deploying a 6i Form to the web
There are a number of technical articles on Metalink re. this. 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] -Original Message- Sent: Wednesday, October 23, 2002 8:09 PM To: Multiple recipients of list ORACLE-L Dan, Oracle Apps 11i uses Dev 6i to deploy Forms on the Web. I vaguely remember some presentations at IOUG 2002! on this very same subject - you could search the IOUG Technical repository... John Kanagaraj Oracle Applications DBA DBSoft Inc (W): 408-970-7002 What would you see if you were allowed to look back at your life at the end of your journey in this earth? ** The opinions and statements above are entirely my own and not those of my employer or clients ** -Original Message- Sent: Wednesday, October 23, 2002 3:29 PM To: Multiple recipients of list ORACLE-L is Forms 6i Server not an option? -Original Message- Sent: Wednesday, October 23, 2002 6:14 PM To: Multiple recipients of list ORACLE-L One of our developers (not a duhveloper) has asked if I know how (step by step instructions) to deploy a 6i form to the web. He has only found theoretical info and needs more hands on info. I have no clue (unless it can be done using UNDO internal structures...) Any websites, books, presentations, etc. are greatly appreciated... Dan Fink -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Kanagaraj INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Oracle Server with Linux client
We are having a client machine with Linux as OS. Our Oracle server is installed on Windows NT. Does Linux support Oracle Developer 2000. If so how do we connect our linux client with oracle server ? Is there any difference in configuration of Net 8 (tnsnames.ora) If yes then pls give the configuration Thank you, Deepa -- 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).
what is purify
ORA-01008:not all variables bound
While executing the following database trigger (update) we are getting the following error message ORA-01008:not all variables bound. We are working on Oracle 8.0.3 We have written this trigger to get the column name,old and new values of fields of a table (locmast) while updating. We do not want to hard code the field names ,so that in future if a new field is added we need not have to alter the trigger. declare v_rowid varchar2(50); cursor cur_loc is select column_name from all_tab_columns where table_name='LOCMAST'; v_val varchar2(120); cur_id number; v_rec_id number; begin cur_id:=dbms_sql.open_cursor; for rec_loc in cur_loc loop dbms_sql.parse(cur_id, 'select :old.'||rec_loc.column_name||' from dual' ,dbms_sql.native); dbms_sql.define_column_char(cur_id,1,v_val,120); v_rec_id := dbms_sql.execute_and_fetch(cur_id); dbms_sql.column_value_char(cur_id,1,v_val); end loop; end; Thanks Deepa -- 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 Server with Linux client
On Thursday 24 October 2002 14:49, you wrote: We are having a client machine with Linux as OS. Our Oracle server is installed on Windows NT. Does Linux support Oracle Developer 2000. I don't know. If so how do we connect our linux client with oracle server ? Download Oracle for Linux and select to install only client software in installation GUI. Is there any difference in configuration of Net 8 (tnsnames.ora) No. JP -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jan Pruner INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: what is purify
Now in a dump, Oracle see's something called purify and want us to disable it to see if that makes a difference. Never heard of purify - what is this?? A product which checks memory allocation - that you are not writing at an address location you have freed or that you have no memory leak. They somewhat intercept calls to malloc(), free() and the like before forwarding them to the memory. May have some impact on performance but I doubt the Oracle explanation. I think that Oracle uses this product (not enough), the reference to it may well be in their code. Regards, Stephane Faroult Oriole -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroul INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: DB monitoring using SNMP MIBs
Oracle SNMP Support Reference Guide has the MIBs documented. That can be found under the Oracle Enterprise Manager docs. On Wed, Oct 23, 2002 at 03:19:22PM -0800, John Kanagaraj wrote: Kevin, This is great! Can we get a list of all the OIDs that Oracle uses? Can you also let the group know if any additional plug-ins are required for Perl to work with SNMP? John Kanagaraj Oracle Applications DBA DBSoft Inc (W): 408-970-7002 What would you see if you were allowed to look back at your life at the end of your journey in this earth? ** The opinions and statements above are entirely my own and not those of my employer or clients ** -Original Message- Sent: Wednesday, October 23, 2002 3:54 PM To: Multiple recipients of list ORACLE-L Yes. You can use PERL to do such things such as getting the database state, name, consistent gets, system block gets, etc from SNMP: #!/usr/local/bin/perl use BER; use SNMP_Session; use SNMP_util; use Getopt::Std; getopts(h:i:); my($host, $community, $response, $bindings, $binding, $value, @oid, @retvals); my $session; $host = $opt_h; $community = public; $db_index = $opt_i; # Database State $oid[0] = '.1.3.6.1.2.1.39.1.9.1.1.2.2'; #Database Name $oid[1] = '.1.3.6.1.2.1.39.1.7.1.4.' . $db_index . '.7.100.98.95.110.97.109.101.1'; # Consistent Block Gets $oid[2] = 'enterprises.111.4.1.1.1.2.' . $db_index; # System Block Gets $oid[3] = 'enterprises.111.4.1.1.1.4.' . $db_index; my @retvals = SNMP_util::snmpget ( $host, @oid ); -Original Message- Sent: Wednesday, October 23, 2002 5:20 PM To: Multiple recipients of list ORACLE-L Thanks Dennis, Gary I have tools at my disposal to monitor the db, and I have no problem with that. I was just reading through snmp and was intrigues by the idea that I could get some information without running scripts through sqlplus interface and if so how to accomplish that. I know it is doable because IA does that, just wondering if it would be feasible to do it be some scripting ... Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! -Original Message- mailto:DWILLIAMS;LIFETOUCH.COM ] Sent: Wednesday, October 23, 2002 6:04 PM To: Multiple recipients of list ORACLE-L Raj - I'm no expert on SNMP, so maybe someone that is more knowledgeable will reply. I believe that SNMP underlies most of the monitoring tools on the market today. OEM may even use SNMP. I can see two approaches for you. 1. You write your own tool that will issue SNMP alerts. Perhaps this would be a Unix daemon process that executes database queries, and then based on what it finds, issues SNMP alerts. 2. Use an existing tool to accomplish what you want. If your desire is to create a database monitoring tool that you can give away for free, then sell to CA for a lot of money, take path #1. If your goal is to become a better DBA, then I would go with #2. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] mailto:dwilliams;lifetouch.com mailto:dwilliams;lifetouch.com -Original Message- Sent: Wednesday, October 23, 2002 4:39 PM To: Multiple recipients of list ORACLE-L Has anyone implemented basic DB monitoring using snmp MIB information rather than running queries against the db? I am looking into this and have no clue or available docs on how to do this (esp on AIX). If someone can point me to the right direction, I would really appreciate that. TIA Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Kanagaraj INET: [EMAIL PROTECTED] Fat
Re: Oracle Real Application Clusters
On Wed, Oct 23, 2002 at 03:19:21PM -0800, Tim Gorman wrote: A couple of anecdotes to consider: a.. Some folks from the Oak Table forum (www.oaktable.net) recently (last July) constructed a 10-node cluster of Linux laptops right on the conference floor at Oracle Open World in Copenhagen, Denmark. Information is available at http://investor.cnet.com/investor/news/newsitem/0-9900-1028-20212349-0.html?tag=ats. So it can definitely be done on the cheap! hmm...first time I've ever seen NetApp and cheap used together. What is the real poor man's shared disk architecture? NFS? === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
SGA larger than 4GB
This is a multi-part message in MIME format. --=002_Dragon320551784160_= Content-Type: text/plain; charset=GB2312 Content-Transfer-Encoding: quoted-printable hi, list friends: About SGA , shmmax, ISM on solaris Sun Solaris 7 64bit oracle Unix Kernel Parameter: /etc/system set shmsys:shminfo_shmmax=3D4294967295 Unix kernel statistics; oracle@main-db1$ipcs -ma IPC status from as of Thu Oct 24 20:23:25 CST 2002 T ID KEY MODE OWNER GROUP CREATOR CGROUP NATTCH SEGSZ CPID LPID= ATIME DTIME CTIME Shared Memory: m 0 0x500483d0 --rw-r--r-- root root root root 1 68 305 305= 6:31:42 6:31:42 6:31:42 m 101 0x41180c94 --rw-r- oracle oinstall oracle oinstall 398= 4711727104 1732 8979 20:20:00 20:20:00 8:30:38 Current database sga: 19:57:31 SQL show sga Total System Global Area 4711026364 bytes Fixed Size 102076 bytes Variable Size 415678464 bytes Database Buffers 4294967296 bytes Redo Buffers 278528 bytes As the document said, if the sga is larger than shmmax, oracle= will allocate more than one shared memory segment,right? But in my case, as you can see,SGA =3D 4.7Gb, shmmax =3D4GB As the document said, oracle should allocate two shared memory= segment. but from the ipcs result we can see that there is just one shared= memory segment. How can i understand it? And, can i enlarger the parameter shmmax larger than 4GB? I have= 12Gb physical memory.I never see parameter shmmax larger than= 4GB in any document so not sure. Thanks. =A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1chao_ping [EMAIL PROTECTED] =A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A12002-10-24 --=002_Dragon320551784160_= Content-Type: text/html; charset=GB2312 Content-Transfer-Encoding: quoted-printable !DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.0 Transitional//EN HTMLHEAD META content=3Dtext/html; charset=3Dgb2312= http-equiv=3DContent-Type META content=3DMSHTML 5.00.3315.2870 name=3DGENERATOR/HEAD BODY bgColor=3D#eaeaea PFONT size=3D2FONT face=3D=CB=CE=CC=E5hi, list= friends:/FONT/FONT/P PFONT size=3D2FONT face=3D=CB=CE=CC=E5FONT= face=3Dverdana,arial,helvetica size=3D1BAbout SGA , shmmax, ISM on solaris/B/FONT /P PFONT face=3Dverdana, arial, helvetica size=3D2Sun Solaris 7= 64bit oracleBRBRUnix Kernel Parameter:BR/etc/systemBRset shmsys:shminfo_shmmax=3D4294967295BRBRUnix kernel statistics;BRoracle@main-db1$ipcs -maBRIPC status from= RUNNING systemas of Thu Oct 24 20:23:25 CST 2002BRT ID KEY MODE OWNER GROUP CREATOR= CGROUP NATTCH SEGSZ CPID LPID ATIME DTIME CTIME BRShared Memory:BRm 0= 0x500483d0 --rw-r--r-- root root root root 1 68 305 305 6:31:42 6:31:42= 6:31:42BRm 101 0x41180c94 --rw-r- oracle oinstall oracle oinstall 398= 4711727104 1732 8979 20:20:00 20:20:00 8:30:38BRBRCurrent database= sga:BR19:57:31 SQLgt; show sgaBRBRTotal System Global Area 4711026364 bytesBRFixed= Size 102076 bytesBRVariable Size 415678464 bytesBRDatabase Buffers= 4294967296 bytesBRRedo Buffers 278528 bytesBRAs the document said, if= the sga is larger than shmmax, oracle will allocate more than one shared memory segment,right?BRBRBRBut in my case, as you can see,SGA =3D= 4.7Gb, shmmax =3D4GBBRBRAs the document said, oracle should allocate two= shared memory segment.BRbut from the ipcs result we can see that there is= just one shared memory segment.BRHow can i understand it?/FONT/P PFONT face=3DVerdanaAnd, can i enlarger the parameter shmmax= larger than 4GB? I have 12Gb physical memory.I never see parameter shmmax larger= than 4GB in any document so not sure./FONT/P PFONT face=3DVerdanaThanks./FONT/P/FONT/FONT DIV DIVFONT face=3D=CB=CE=CC=E5= size=3D2=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1chao_ping/FONT/DIV DIVFONT face=3D=CB=CE=CC=E5 size=3D2FONT face=3D=CB=CE=CC=E5= size=3D2=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1/FONTA href=3Dmailto:chao_ping;vip.163.com[EMAIL PROTECTED]/A/FO= NT/DIV DIVFONT face=3D=CB=CE=CC=E5= size=3D2=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A12002-10-24/FONT/DIV= DIVnbsp;/DIV/DIV/BODY/HTML --=002_Dragon320551784160_=-- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: chao_ping INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle Real Application Clusters
Title: RE: Oracle Real Application Clusters If I remember right we had some problems with gsd and nfs ... Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! -Original Message- From: Ray Stell [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 24, 2002 9:34 AM To: Multiple recipients of list ORACLE-L Subject: Re: Oracle Real Application Clusters On Wed, Oct 23, 2002 at 03:19:21PM -0800, Tim Gorman wrote: A couple of anecdotes to consider: a.. Some folks from the Oak Table forum (www.oaktable.net) recently (last July) constructed a 10-node cluster of Linux laptops right on the conference floor at Oracle Open World in Copenhagen, Denmark. Information is available at http://investor.cnet.com/investor/news/newsitem/0-9900-1028-20212349-0.html?tag=ats. So it can definitely be done on the cheap! hmm...first time I've ever seen NetApp and cheap used together. What is the real poor man's shared disk architecture? NFS? === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC 28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). *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 Server with Linux client
On Thu, Oct 24, 2002 at 04:49:28AM -0800, [EMAIL PROTECTED] wrote: Does Linux support Oracle Developer 2000. -- Look on metalink under Certify Avaiability. Linux is not listed. === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Theory v Practice
Thanks for all your comments (especially the ones that made me laugh). Now at least I have some input from experienced people to put before my boss. Craig -Original Message- From: Craig Healey Sent: 23 October 2002 18:45 To: Multiple recipients of list ORACLE-L Subject: Theory v Practice The developers working on our new VB app are also responsible for setting up the Oracle DB behind it. The app is for an order entry/despatch/warehouse system with 5 million customers and 1000 orders per day. We have nearly 400 tables. They are not planning on using primary keys/secondary keys, as they say they will handle all the constraints via VB. I only have a theoretical knowledge of database design, which says this is very wrong. Is the Oracle system being used as anything more than an expensive file system? In real world scenarios, is this a common practice? Regards Craig Healey ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. Statements and opinions expressed in this e-mail may not represent those of the company. If you have received this email in error please notify [EMAIL PROTECTED] This footnote also confirms that this email message has been swept by MIMEsweeper for the presence of computer viruses (www.mimesweeper.com) *** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Craig Healey INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: DB monitoring using SNMP MIBs
MIB, hey I saw that movie too. ;o) -Original Message- Sent: Thursday, October 24, 2002 8:14 AM To: Multiple recipients of list ORACLE-L Oracle SNMP Support Reference Guide has the MIBs documented. That can be found under the Oracle Enterprise Manager docs. On Wed, Oct 23, 2002 at 03:19:22PM -0800, John Kanagaraj wrote: Kevin, This is great! Can we get a list of all the OIDs that Oracle uses? Can you also let the group know if any additional plug-ins are required for Perl to work with SNMP? John Kanagaraj Oracle Applications DBA DBSoft Inc (W): 408-970-7002 What would you see if you were allowed to look back at your life at the end of your journey in this earth? ** The opinions and statements above are entirely my own and not those of my employer or clients ** -Original Message- Sent: Wednesday, October 23, 2002 3:54 PM To: Multiple recipients of list ORACLE-L Yes. You can use PERL to do such things such as getting the database state, name, consistent gets, system block gets, etc from SNMP: #!/usr/local/bin/perl use BER; use SNMP_Session; use SNMP_util; use Getopt::Std; getopts(h:i:); my($host, $community, $response, $bindings, $binding, $value, @oid, @retvals); my $session; $host = $opt_h; $community = public; $db_index = $opt_i; # Database State $oid[0] = '.1.3.6.1.2.1.39.1.9.1.1.2.2'; #Database Name $oid[1] = '.1.3.6.1.2.1.39.1.7.1.4.' . $db_index . '.7.100.98.95.110.97.109.101.1'; # Consistent Block Gets $oid[2] = 'enterprises.111.4.1.1.1.2.' . $db_index; # System Block Gets $oid[3] = 'enterprises.111.4.1.1.1.4.' . $db_index; my @retvals = SNMP_util::snmpget ( $host, @oid ); -Original Message- Sent: Wednesday, October 23, 2002 5:20 PM To: Multiple recipients of list ORACLE-L Thanks Dennis, Gary I have tools at my disposal to monitor the db, and I have no problem with that. I was just reading through snmp and was intrigues by the idea that I could get some information without running scripts through sqlplus interface and if so how to accomplish that. I know it is doable because IA does that, just wondering if it would be feasible to do it be some scripting ... Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! -Original Message- mailto:DWILLIAMS;LIFETOUCH.COM ] Sent: Wednesday, October 23, 2002 6:04 PM To: Multiple recipients of list ORACLE-L Raj - I'm no expert on SNMP, so maybe someone that is more knowledgeable will reply. I believe that SNMP underlies most of the monitoring tools on the market today. OEM may even use SNMP. I can see two approaches for you. 1. You write your own tool that will issue SNMP alerts. Perhaps this would be a Unix daemon process that executes database queries, and then based on what it finds, issues SNMP alerts. 2. Use an existing tool to accomplish what you want. If your desire is to create a database monitoring tool that you can give away for free, then sell to CA for a lot of money, take path #1. If your goal is to become a better DBA, then I would go with #2. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] mailto:dwilliams;lifetouch.com mailto:dwilliams;lifetouch.com -Original Message- Sent: Wednesday, October 23, 2002 4:39 PM To: Multiple recipients of list ORACLE-L Has anyone implemented basic DB monitoring using snmp MIB information rather than running queries against the db? I am looking into this and have no clue or available docs on how to do this (esp on AIX). If someone can point me to the right direction, I would really appreciate that. TIA Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like
RE: Download Oracle 7.3.4
Oooo! I forgot about the SCO. I never tried it but I had read about it. Those were the days eh? -Original Message- Sent: Thursday, October 24, 2002 5:39 AM To: Multiple recipients of list ORACLE-L Although, you should *apparently* be able to load the 7.3.4 version of SCO on Linux - or maybe that's just an urban myth! Yes, i remember installing the first version of 8 on Linux (hey I had some time on my hands) and it was a bit of a nightmare - back to the days when Oracle had 2 hits on metalink for Linux! ;-) Lewis Bishop --- Barclays Enable - ISS - E-NTRUST/Bexleyheath NT Oracle Database Consultant Watling Street, Bexleyheath, Kent, DA6 7RR (Mail Van R) Phone : 020 8298 3418 Mobile: 07950 380857 Email : [EMAIL PROTECTED] Enabling Competitive Advantage for Barclays in IT and Business Processing -Original Message- Sent: 23 October 2002 22:29 To: Multiple recipients of list ORACLE-L The first version of Oracle that ran on Linux was the early adoptor pre-release of 8.0.5 in 1998 -Original Message- Sent: Wednesday, October 23, 2002 4:39 PM To: Multiple recipients of list ORACLE-L Hi list, I need to do some testing in an Oracle 7.3.4 for linux (redhat), where can I download this Oracle version from? it doesn't appear to be online in OTN. thanks for your help. Greetings Diego Cutrone -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: dcutrone INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Sherman, Edward INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Bishop Lewis INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Sherman, Edward INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle Real Application Clusters
Here are the papers I found. A word of caution: these are written by sales critters so as a hard-core techie if you read more than 3 papers your head will explode. http://technet.oracle.com/deploy/availability/techlisting.html http://technet.oracle.com/deploy/availability/techlisting.html Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, October 24, 2002 12:23 AM To: Multiple recipients of list ORACLE-L Hi, Could you please give me the links to these white papers...? DENNIS WILLIAMS [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 10/23/02 09:53 PM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Oracle Real Application Clusters Tim - Gee, during the original presentation I attended, RAC was presented as a cost-saving feature. Something about being able to use a lot of cheap Linux servers. This stuck me as a little odd at the time. Just now, I looked at the white papers that Oracle posts on the subject, and I didn't see the cost-saving aspect mentioned. Or maybe Oracle is still getting the Linux ball rolling. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, October 23, 2002 9:05 AM To: Multiple recipients of list ORACLE-L Aye to that, but you'll need at least two, possibly three, identical clusters, not just one. One cluster for production and an identical cluster for QA/Test, and possibly one for development (though that last is often regarded as unnecessary). Skimping on the QA/Test environment is the leading edge of failure... RAC itself requires additional DBA expertise as well as additional OS SysAdmin expertise for cluster hardware/OS, each of which costs more to obtain/maintain (either by hiring experienced/talented or training to build or both). Clustering is not a low-cost solution from any perspective... RAC is a solution for certain specific high-availability and high-scaleability requirements (not including data-center failure, a.k.a. disaster-recovery), so it's a good idea to be certain that you are planning a solution that meets your own specific requirements before proceeding. RAC should not be a high-level management decision -- it is a specific technical solution to meet specific technical requirements, which themselves should have been derived from the requirements of the business. There are several other possible H/A solutions in Oracle9i (i.e. physical standby, logical standby, advanced replication, OS failover solutions, RAC, etc), each of which addresses the same H/A problems in different ways with differing levels of complexity and cost. - Original Message - To: Multiple mailto:ORACLE-L;fatcity.com recipients of list ORACLE-L Sent: Wednesday, October 23, 2002 6:43 AM IMHO, the main requirement is that you have to have a system that needs to be up 24x7 on a cluster and your ability to fork enough money to Oracle and your server vendor (to get two identical machines) and your networking vendor (for redundant network connections). Rest everything is easy ... Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! -Original Message- Sent: Wednesday, October 23, 2002 3:04 AM To: Multiple recipients of list ORACLE-L Dear All, We are planning to implement ORAC for our application, can anybody tell me where to get good information on the system requirements for implementing the same. Regards Prem -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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
Re: Oracle Real Application Clusters
NetApp is NFS; so are all current NAS products... The phrases NetApp and cheap are *always* used together -- it is their most compelling feature. CFOs love NetApps. For database usage however, they are best used in non-demanding situations (i.e. low I/O volumes). The phrase filer is very apt -- their very best application is simple file-serving; Windows network drive or UNIX file-system. But not underneath any I/O-intensive application such as a busy database-based application. Any I/O subsystem (such as NAS) that relies on a cache for performance is simply pure trouble for busy databases -- DEC knew it in the 80s and EMC discovered it in the 90s. Now NetApp knows in the 00s (does that rhyme?)... - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, October 24, 2002 7:34 AM On Wed, Oct 23, 2002 at 03:19:21PM -0800, Tim Gorman wrote: A couple of anecdotes to consider: a.. Some folks from the Oak Table forum (www.oaktable.net) recently (last July) constructed a 10-node cluster of Linux laptops right on the conference floor at Oracle Open World in Copenhagen, Denmark. Information is available at http://investor.cnet.com/investor/news/newsitem/0-9900-1028-20212349-0.html? tag=ats. So it can definitely be done on the cheap! hmm...first time I've ever seen NetApp and cheap used together. What is the real poor man's shared disk architecture? NFS? === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tim Gorman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Theory v Practice - and business logic...
As this topic just hits my hot button, I'm going to chime in my 2 cents worth in as well. This in spite of the fact that you have already gotten some great responses. I come from an environment where we have distributed data all over creation. IMS, DB2, Oracle, you name it we have it popping up everywhere. When a new project pops up, guess what the first question is: Does the source of record that we need for this application already exist somewhere? Now, if it does, I've got a HUGE problem if I am not enforcing the RI on this source data, particularly if this new application is going to be manipulating it somehow. Then, as others have mentioned, there are the power users who figure out ODBC and access or Excel.. God help you when they get busy. Another issue with regards to FK/PK's is the use of some Oracle features, such as query rewrite and MViews, which require these structures to be used. While you may not plan on using those features now, there is no telling what the future may hold. Simply put, using defined Pk/FK is a best practice. If you have issues with the validation of FK's (for example in a warehouse environment) then enable them without validation. This leads me to another related hot button topic, thats business logic. In my mind (though I'm having a hard time selling it to apps) the business logic belongs in the database. This for the very same reasons that FK/PK's need to be in place, scalability. That way, when I have new applications coming on line that need to interface with the data, the same business rules are consistently followed. Bottom line, one has to think about tomorrow when one designs, not just today. More to churn on, Robert 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. -Original Message- Sent: Wednesday, October 23, 2002 1:45 PM To: Multiple recipients of list ORACLE-L The developers working on our new VB app are also responsible for setting up the Oracle DB behind it. The app is for an order entry/despatch/warehouse system with 5 million customers and 1000 orders per day. We have nearly 400 tables. They are not planning on using primary keys/secondary keys, as they say they will handle all the constraints via VB. I only have a theoretical knowledge of database design, which says this is very wrong. Is the Oracle system being used as anything more than an expensive file system? In real world scenarios, is this a common practice? Regards Craig Healey ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. Statements and opinions expressed in this e-mail may not represent those of the company. If you have received this email in error please notify [EMAIL PROTECTED] This footnote also confirms that this email message has been swept by MIMEsweeper for the presence of computer viruses (www.mimesweeper.com) *** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Craig Healey INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: 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).
RE: what is purify
See: http://www.rational.com/products/purify_nt/index.jsp I think this is what they are talking about. RF 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. -Original Message- Sent: Thursday, October 24, 2002 8:54 AM To: Multiple recipients of list ORACLE-L Have we had several cases where oracle.exe on NT during patching of Oracle Apps 11i gets a runaway thread. This thread is not known to Oracle - not in v$session. Even if shutdown database, still at 100%. Must halt the service for it to resolved. Oracle is theorizing backupexec from Veritas might be a problem - but doesn't make sense since that service is always running. Now in a dump, Oracle see's something called purify and want us to disable it to see if that makes a difference. Never heard of purify - what is this?? Jeffrey Beckstrom Database Administrator Greater Cleveland Regional Transit Authority 1240 W. 6th Street Cleveland, Ohio 44113 (216) 781-4204 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeffrey Beckstrom INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: 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).
RE: DB monitoring using SNMP MIBs
The list could be hard for me to get . unless someone else knows where they are. I will see what I can get. -Original Message- Sent: Wednesday, October 23, 2002 6:19 PM To: Multiple recipients of list ORACLE-L Kevin, This is great! Can we get a list of all the OIDs that Oracle uses? Can you also let the group know if any additional plug-ins are required for Perl to work with SNMP? John Kanagaraj Oracle Applications DBA DBSoft Inc (W): 408-970-7002 What would you see if you were allowed to look back at your life at the end of your journey in this earth? ** The opinions and statements above are entirely my own and not those of my employer or clients ** -Original Message- Sent: Wednesday, October 23, 2002 3:54 PM To: Multiple recipients of list ORACLE-L Yes. You can use PERL to do such things such as getting the database state, name, consistent gets, system block gets, etc from SNMP: #!/usr/local/bin/perl use BER; use SNMP_Session; use SNMP_util; use Getopt::Std; getopts(h:i:); my($host, $community, $response, $bindings, $binding, $value, @oid, @retvals); my $session; $host = $opt_h; $community = public; $db_index = $opt_i; # Database State $oid[0] = '.1.3.6.1.2.1.39.1.9.1.1.2.2'; #Database Name $oid[1] = '.1.3.6.1.2.1.39.1.7.1.4.' . $db_index . '.7.100.98.95.110.97.109.101.1'; # Consistent Block Gets $oid[2] = 'enterprises.111.4.1.1.1.2.' . $db_index; # System Block Gets $oid[3] = 'enterprises.111.4.1.1.1.4.' . $db_index; my @retvals = SNMP_util::snmpget ( $host, @oid ); -Original Message- Sent: Wednesday, October 23, 2002 5:20 PM To: Multiple recipients of list ORACLE-L Thanks Dennis, Gary I have tools at my disposal to monitor the db, and I have no problem with that. I was just reading through snmp and was intrigues by the idea that I could get some information without running scripts through sqlplus interface and if so how to accomplish that. I know it is doable because IA does that, just wondering if it would be feasible to do it be some scripting ... Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! -Original Message- mailto:DWILLIAMS;LIFETOUCH.COM ] Sent: Wednesday, October 23, 2002 6:04 PM To: Multiple recipients of list ORACLE-L Raj - I'm no expert on SNMP, so maybe someone that is more knowledgeable will reply. I believe that SNMP underlies most of the monitoring tools on the market today. OEM may even use SNMP. I can see two approaches for you. 1. You write your own tool that will issue SNMP alerts. Perhaps this would be a Unix daemon process that executes database queries, and then based on what it finds, issues SNMP alerts. 2. Use an existing tool to accomplish what you want. If your desire is to create a database monitoring tool that you can give away for free, then sell to CA for a lot of money, take path #1. If your goal is to become a better DBA, then I would go with #2. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] mailto:dwilliams;lifetouch.com mailto:dwilliams;lifetouch.com -Original Message- Sent: Wednesday, October 23, 2002 4:39 PM To: Multiple recipients of list ORACLE-L Has anyone implemented basic DB monitoring using snmp MIB information rather than running queries against the db? I am looking into this and have no clue or available docs on how to do this (esp on AIX). If someone can point me to the right direction, I would really appreciate that. TIA Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Kanagaraj INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web
Re: secure connection
Hire a special company that handle this. We are doing it to see how unbreakable are our servers. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, October 24, 2002 2:08 PM Hi, how can I be sure that the connection between our web server and Oracle Server to be secure. What's the best method to accomplish this? Any good links for Oracle Nwtwork Security. Any help would be greatly appreciated. Murat -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: MURAT BALKAS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Oracle Real Application Clusters
On Thu, Oct 24, 2002 at 05:43:38AM -0800, Jamadagni, Rajendra wrote: If I remember right we had some problems with gsd and nfs ... could you elaborate? === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Suggestions solicited - Change Column Datatype from Number to
Could you preserve the constraints and indices if you do somthing similar like create table temp as select * from table1 nologging TRUNCATE table table1 ALTER TABLE table1 NOLOGGING; ALTER TABLE table1 MODIFY(column...); Do a direct load insert ALTER TABLE table1 LOGGING; DROP TABLE temp I have not done direct load insert but read it can be done for NOLOGGING Rick DENNIS WILLIAMS DWILLIAMS@LIFE To: Multiple recipients of list ORACLE-L TOUCH.COM [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: RE: Suggestions solicited - Change Column m Datatype from Number to 10/24/2002 04:35 PM Please respond to ORACLE-L Deepak, If there are many columns on these tables, your method may be best. However, this will generate a lot of redo. You can usually accomplish this with a CTAS nologging, which won't generate redo. If you really don't want to change the location, you can: create table temp as select * from table1 nologging drop table table1 create table table1 (column, column . . . ) as select * from temp nologging drop table temp Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, October 24, 2002 3:15 PM To: Multiple recipients of list ORACLE-L We have a need to change the datatype of several columns in a table from number to varchar2. Most of the rows have data in these columns hence a direct 'alter table ...' will not work. We plan to create a temp table, move the data from these colums to that table, modify the column datatype from number to varchar2 and then update the colums with the data that was moved to the temp table. Any suggestions/comments or a better way to do this ? Oh, and we are on 8.1.7.1 thanx deepak -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other
RE: Suggestions solicited - Change Column Datatype from Number to
Dennis, That's a good thought, and it works if you don't have grants, constraints or dependencies on the original table. If you drop table1, you lose them all Rachel --- DENNIS WILLIAMS [EMAIL PROTECTED] wrote: Deepak, If there are many columns on these tables, your method may be best. However, this will generate a lot of redo. You can usually accomplish this with a CTAS nologging, which won't generate redo. If you really don't want to change the location, you can: create table temp as select * from table1 nologging drop table table1 create table table1 (column, column . . . ) as select * from temp nologging drop table temp Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, October 24, 2002 3:15 PM To: Multiple recipients of list ORACLE-L We have a need to change the datatype of several columns in a table from number to varchar2. Most of the rows have data in these columns hence a direct 'alter table ...' will not work. We plan to create a temp table, move the data from these colums to that table, modify the column datatype from number to varchar2 and then update the colums with the data that was moved to the temp table. Any suggestions/comments or a better way to do this ? Oh, and we are on 8.1.7.1 thanx deepak -- 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). __ Do you Yahoo!? Y! Web Hosting - Let the expert host your web site http://webhosting.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: RMAN - It's Here
I buy lots of books from Bookpool!! :-) I buy from Amazon too but those are normally non technical books. RF 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. -Original Message- Sent: Thursday, October 24, 2002 4:50 PM To: Multiple recipients of list ORACLE-L Rafiq, I was teasing... I buy books from discount places as well. Including bookpool Rachel --- Mohammad Rafiq [EMAIL PROTECTED] wrote: Rachel, Interesting, I never thought of it. I feel sorry for that if it is reducing royalty of Roberts, but my intention was different and to help others to reduce their cost of this book. Besides I am very much satisfied with the services/prices of bookpool.com Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Thu, 24 Oct 2002 11:43:09 -0800 because the author's royalties are based in part on what the book sells for? just doing my part to keep Robert's kids fed :) --- Mohammad Rafiq [EMAIL PROTECTED] wrote: Why pay more, Try www.bookpool.com Oracle9i RMAN Backup Recovery Freeman, et al / McGraw Hill / 2002 / 0072226625 Our Price $30.95 ~ You Save $19.04 (38% Off) Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Thu, 24 Oct 2002 09:48:55 -0800 Amazon.com, Oraclepressbooks.com, etc... 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. -Original Message- Sent: Thursday, October 24, 2002 11:09 AM To: Multiple recipients of list ORACLE-L Where? Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, October 24, 2002 4:44 PM Just a note that my new book Oracle9i RMAN Backup and Recovery (with co-author Matthew Hart) is out now! Enjoy! And remember, if you like it, I wrote it. If you don't like it.. hm let's see then Tim Gorman wrote it. RF 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. -Original Message- Sent: Thursday, October 24, 2002 9:55 AM To: Multiple recipients of list ORACLE-L MIB, hey I saw that movie too. ;o) -Original Message- Sent: Thursday, October 24, 2002 8:14 AM To: Multiple recipients of list ORACLE-L Oracle SNMP Support Reference Guide has the MIBs documented. That can be found under the Oracle Enterprise Manager docs. On Wed, Oct 23, 2002 at 03:19:22PM -0800, John Kanagaraj wrote: Kevin, This is great! Can we get a list of all the OIDs that Oracle uses? Can you also let the group know if any additional plug-ins are required for Perl to work with SNMP? John Kanagaraj Oracle Applications DBA DBSoft Inc (W): 408-970-7002 What would you see if you were allowed to look back at your life at the end of your journey in this earth? ** The opinions and statements above are entirely my own and not those of my employer or clients ** -Original Message- Sent: Wednesday, October 23, 2002 3:54 PM To: Multiple recipients of list ORACLE-L Yes. You can use PERL to do such things such as getting the database state, name, consistent gets, system block gets, etc from SNMP: #!/usr/local/bin/perl use BER; use SNMP_Session; use SNMP_util; use Getopt::Std; getopts(h:i:); my($host, $community, $response, $bindings, $binding, $value, @oid, @retvals); my $session; $host = $opt_h; $community = public; $db_index = $opt_i; # Database State $oid[0] = '.1.3.6.1.2.1.39.1.9.1.1.2.2'; #Database Name $oid[1] = '.1.3.6.1.2.1.39.1.7.1.4.' . $db_index . '.7.100.98.95.110.97.109.101.1'; # Consistent Block Gets $oid[2] = 'enterprises.111.4.1.1.1.2.' . $db_index; # System Block Gets $oid[3] = 'enterprises.111.4.1.1.1.4.' . $db_index; my @retvals = SNMP_util::snmpget ( $host, @oid ); === message truncated === __ Do
RE: [Q] wield create view error, need help?
Grant privileges on v_$sysstat dist cash mccdba@hotmaTo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] il.com cc: Sent by: Subject: RE: [Q] wield create view error, need help? root@fatcity. com October 24, 2002 04:14 PM Please respond to ORACLE-L Thank you for your help. I follow your instruction and granr privilege. It fixed me a lot of errors. Currently, I have another problem still create view problem. SQL CREATE OR REPLACE VIEW WWV_DBA_SGA ( COMPONENT_GROUP, 2 MEMORY_SIZE_IN_BYTES ) AS select name component_group, bytes memory_size_in_bytes from v$sgastat 3 . SQL / MEMORY_SIZE_IN_BYTES ) AS select name component_group, bytes memory_size_in_bytes from v$sgastat * ERROR at line 2: ORA-00942: table or view does not exist I tried to grant privilege and got error: SQL grant select on sys.v$sgastat to portal30; grant select on sys.v$sgastat to portal30 * ERROR at line 1: ORA-02030: can only select from fixed tables/views Do you have ideal how to fix this problem? Thanks -- 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: Table Index sizing utility
Rick - I'm sure there are a lot of good sizing programs around. And hey, awhile back I was just as anal as everyone else, struggling to estimate everything to the last K. I've got another idea for you to consider. If you switch to LMTs and autoextend, then you don't need to spend nearly as much time fussing with this. As to data sizes, the SQL manual mentions this with each data type. If you are uncertain about a specific datatype, reply. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, October 24, 2002 3:36 PM To: Multiple recipients of list ORACLE-L Hi DBAs, Does anyone have a table index sizing utility program/script they can share? Also where can I find out exactly how much storage Oracle allocates for every datatype? I checked the concepts manual but could not find it. Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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: RMAN - It's Here
Rachel, Thanks. Basically I don't like Amazon because of various reasons and my bad experience with them. Besides , we normally buy technical books at our own so everybody try to reduce their cost, Right Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Thu, 24 Oct 2002 12:50:19 -0800 Rafiq, I was teasing... I buy books from discount places as well. Including bookpool Rachel --- Mohammad Rafiq [EMAIL PROTECTED] wrote: Rachel, Interesting, I never thought of it. I feel sorry for that if it is reducing royalty of Roberts, but my intention was different and to help others to reduce their cost of this book. Besides I am very much satisfied with the services/prices of bookpool.com Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Thu, 24 Oct 2002 11:43:09 -0800 because the author's royalties are based in part on what the book sells for? just doing my part to keep Robert's kids fed :) --- Mohammad Rafiq [EMAIL PROTECTED] wrote: Why pay more, Try www.bookpool.com Oracle9i RMAN Backup Recovery Freeman, et al / McGraw Hill / 2002 / 0072226625 Our Price $30.95 ~ You Save $19.04 (38% Off) Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Thu, 24 Oct 2002 09:48:55 -0800 Amazon.com, Oraclepressbooks.com, etc... 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. -Original Message- Sent: Thursday, October 24, 2002 11:09 AM To: Multiple recipients of list ORACLE-L Where? Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, October 24, 2002 4:44 PM Just a note that my new book Oracle9i RMAN Backup and Recovery (with co-author Matthew Hart) is out now! Enjoy! And remember, if you like it, I wrote it. If you don't like it.. hm let's see then Tim Gorman wrote it. RF 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. -Original Message- Sent: Thursday, October 24, 2002 9:55 AM To: Multiple recipients of list ORACLE-L MIB, hey I saw that movie too. ;o) -Original Message- Sent: Thursday, October 24, 2002 8:14 AM To: Multiple recipients of list ORACLE-L Oracle SNMP Support Reference Guide has the MIBs documented. That can be found under the Oracle Enterprise Manager docs. On Wed, Oct 23, 2002 at 03:19:22PM -0800, John Kanagaraj wrote: Kevin, This is great! Can we get a list of all the OIDs that Oracle uses? Can you also let the group know if any additional plug-ins are required for Perl to work with SNMP? John Kanagaraj Oracle Applications DBA DBSoft Inc (W): 408-970-7002 What would you see if you were allowed to look back at your life at the end of your journey in this earth? ** The opinions and statements above are entirely my own and not those of my employer or clients ** -Original Message- Sent: Wednesday, October 23, 2002 3:54 PM To: Multiple recipients of list ORACLE-L Yes. You can use PERL to do such things such as getting the database state, name, consistent gets, system block gets, etc from SNMP: #!/usr/local/bin/perl use BER; use SNMP_Session; use SNMP_util; use Getopt::Std; getopts(h:i:); my($host, $community, $response, $bindings, $binding, $value, @oid, @retvals); my $session; $host = $opt_h; $community = public; $db_index = $opt_i; # Database State $oid[0] = '.1.3.6.1.2.1.39.1.9.1.1.2.2'; #Database Name $oid[1] = '.1.3.6.1.2.1.39.1.7.1.4.' . $db_index . '.7.100.98.95.110.97.109.101.1'; # Consistent Block Gets $oid[2] = 'enterprises.111.4.1.1.1.2.' . $db_index; # System Block Gets $oid[3] = 'enterprises.111.4.1.1.1.4.' . $db_index; my @retvals = SNMP_util::snmpget ( $host, @oid ); === message truncated === __ Do you Yahoo!? Y! Web Hosting - Let the expert host your web site http://webhosting.yahoo.com/ -- Please see the official ORACLE-L
RE: RMAN - It's Here
Rafiq, I was teasing... I buy books from discount places as well. Including bookpool Rachel --- Mohammad Rafiq [EMAIL PROTECTED] wrote: Rachel, Interesting, I never thought of it. I feel sorry for that if it is reducing royalty of Roberts, but my intention was different and to help others to reduce their cost of this book. Besides I am very much satisfied with the services/prices of bookpool.com Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Thu, 24 Oct 2002 11:43:09 -0800 because the author's royalties are based in part on what the book sells for? just doing my part to keep Robert's kids fed :) --- Mohammad Rafiq [EMAIL PROTECTED] wrote: Why pay more, Try www.bookpool.com Oracle9i RMAN Backup Recovery Freeman, et al / McGraw Hill / 2002 / 0072226625 Our Price $30.95 ~ You Save $19.04 (38% Off) Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Thu, 24 Oct 2002 09:48:55 -0800 Amazon.com, Oraclepressbooks.com, etc... 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. -Original Message- Sent: Thursday, October 24, 2002 11:09 AM To: Multiple recipients of list ORACLE-L Where? Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, October 24, 2002 4:44 PM Just a note that my new book Oracle9i RMAN Backup and Recovery (with co-author Matthew Hart) is out now! Enjoy! And remember, if you like it, I wrote it. If you don't like it.. hm let's see then Tim Gorman wrote it. RF 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. -Original Message- Sent: Thursday, October 24, 2002 9:55 AM To: Multiple recipients of list ORACLE-L MIB, hey I saw that movie too. ;o) -Original Message- Sent: Thursday, October 24, 2002 8:14 AM To: Multiple recipients of list ORACLE-L Oracle SNMP Support Reference Guide has the MIBs documented. That can be found under the Oracle Enterprise Manager docs. On Wed, Oct 23, 2002 at 03:19:22PM -0800, John Kanagaraj wrote: Kevin, This is great! Can we get a list of all the OIDs that Oracle uses? Can you also let the group know if any additional plug-ins are required for Perl to work with SNMP? John Kanagaraj Oracle Applications DBA DBSoft Inc (W): 408-970-7002 What would you see if you were allowed to look back at your life at the end of your journey in this earth? ** The opinions and statements above are entirely my own and not those of my employer or clients ** -Original Message- Sent: Wednesday, October 23, 2002 3:54 PM To: Multiple recipients of list ORACLE-L Yes. You can use PERL to do such things such as getting the database state, name, consistent gets, system block gets, etc from SNMP: #!/usr/local/bin/perl use BER; use SNMP_Session; use SNMP_util; use Getopt::Std; getopts(h:i:); my($host, $community, $response, $bindings, $binding, $value, @oid, @retvals); my $session; $host = $opt_h; $community = public; $db_index = $opt_i; # Database State $oid[0] = '.1.3.6.1.2.1.39.1.9.1.1.2.2'; #Database Name $oid[1] = '.1.3.6.1.2.1.39.1.7.1.4.' . $db_index . '.7.100.98.95.110.97.109.101.1'; # Consistent Block Gets $oid[2] = 'enterprises.111.4.1.1.1.2.' . $db_index; # System Block Gets $oid[3] = 'enterprises.111.4.1.1.1.4.' . $db_index; my @retvals = SNMP_util::snmpget ( $host, @oid ); === message truncated === __ Do you Yahoo!? Y! Web Hosting - Let the expert host your web site http://webhosting.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an
Find Queries by a group of users
Hi all, We were trying to find a way to get all queries by a group of users of the database. Auditing the users lets us know whether they ran a 'select' 'update' etc. but not the full text of the query. This is in 8i. 9i seems to have a view called DBA_FGA_AUDIT_TRAIL which has a SQL_TEXT column. Please advice. __ Do you Yahoo!? Y! Web Hosting - Let the expert host your web site http://webhosting.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Johnson Poovathummoottil INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Suggestions solicited - Change Column Datatype from Number to
Deepak, If there are many columns on these tables, your method may be best. However, this will generate a lot of redo. You can usually accomplish this with a CTAS nologging, which won't generate redo. If you really don't want to change the location, you can: create table temp as select * from table1 nologging drop table table1 create table table1 (column, column . . . ) as select * from temp nologging drop table temp Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, October 24, 2002 3:15 PM To: Multiple recipients of list ORACLE-L We have a need to change the datatype of several columns in a table from number to varchar2. Most of the rows have data in these columns hence a direct 'alter table ...' will not work. We plan to create a temp table, move the data from these colums to that table, modify the column datatype from number to varchar2 and then update the colums with the data that was moved to the temp table. Any suggestions/comments or a better way to do this ? Oh, and we are on 8.1.7.1 thanx deepak -- 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: LOCALLY MANAGED TABLESPACE
Seema, Our production Student Information database (8.1.7 under Win2k) has 40,000 tables and 60,000 indexes. It's a third party app designed for dBaseIV - go ahead and laugh, we do all the time (when we're not crying). Anyhow, we have to regularly clone out the data to a couple of other databases, both on HPUX. The different OS means we have to use export/import, not restore from hot backup or transportable tablespaces, to move the data. Both of the recipient databases (with dictionary-managed tablespaces) started out needing about 2 hours to drop all the tables and indexes (tables change, so we can't truncate) and about 6 hours to import the full dataset. After several refreshes the time requirement grew to almost 30 hours for each DB. I think the data dictionary tables that record info. about tables, indexes, and extents (someone else on this list could probably name the very ones) got totally mucked up (a techical term) after so many massive drops and creates. After I recreated the recipient tablespaces as locally-managed, drop and import times returned to 2 and 6 hours, respectively, and have remained there through numerous subsequent refreshes. Needless to say, we are *very* happy with LMTs. BTW, our Student Info. system is clunky (we're going to redesign it into a couple hundred partitioned tables with 40,000 views and 120,000 Instead-Of Triggers, but that's another story) but several thousand teachers and administrators basically like the way it manages our 80,000 students. How's that for a client base? Jack C. Applewhite Database Administrator Austin Independent School District Austin, Texas 512.414.9715 [EMAIL PROTECTED] Seema Singh oracledbam@ho To: Multiple recipients of list ORACLE-L tmail.com[EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: LOCALLY MANAGED TABLESPACE om 10/24/2002 01:49 PM Please respond to ORACLE-L Hi I am thinking to change our few dictinary manages tablespace to locally managed tablespace.Can any one experienced any issues with locally managed tablespace? Do any one experience what gain after changing to locally managed tablespace? Thx -Seema -- Author: Seema Singh INET: [EMAIL PROTECTED] -- 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: System Tablespace and Autoextend
Sam - I haven't made the system tablespace autoextend because I can't easily recover the space if it overextends. I would rather take the risk that something hits an error from a lack of space in the system tablespace. With other tablespaces you can always rebuild the tablespace if you need to. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, October 24, 2002 1:27 PM To: Multiple recipients of list ORACLE-L Hello All, I have heard several times that if the SYSTEM tablespace runs out of space and needs to autoextend (assuming autoextend is turned on for the data file), then you run the risk of the database crashing and of data dictionary corruption. I have never personally encountered this problem, so I have no experience on what actually does happen. I looked in metalink for documents on this, but turned up nothing. Does anybody have experience on the dangers of allowing the SYSTEM tablespace to autoextend and also any documents on Metalink or OTN that describe this problem? We are running Oracle versions 7.3.4, 8.0.5, 8.1.7, and 9.2. All our Oracle versions are running on Windows NT (or Windows 2000). Thanks for any feedback. Sam Bootsma, OCP [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sam Bootsma INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Table Index sizing utility
Hi DBAs, Does anyone have a table index sizing utility program/script they can share? Also where can I find out exactly how much storage Oracle allocates for every datatype? I checked the concepts manual but could not find it. Thanks Rick -- 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: RMAN - It's Here
Rachel, Interesting, I never thought of it. I feel sorry for that if it is reducing royalty of Roberts, but my intention was different and to help others to reduce their cost of this book. Besides I am very much satisfied with the services/prices of bookpool.com Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Thu, 24 Oct 2002 11:43:09 -0800 because the author's royalties are based in part on what the book sells for? just doing my part to keep Robert's kids fed :) --- Mohammad Rafiq [EMAIL PROTECTED] wrote: Why pay more, Try www.bookpool.com Oracle9i RMAN Backup Recovery Freeman, et al / McGraw Hill / 2002 / 0072226625 Our Price $30.95 ~ You Save $19.04 (38% Off) Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Thu, 24 Oct 2002 09:48:55 -0800 Amazon.com, Oraclepressbooks.com, etc... 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. -Original Message- Sent: Thursday, October 24, 2002 11:09 AM To: Multiple recipients of list ORACLE-L Where? Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, October 24, 2002 4:44 PM Just a note that my new book Oracle9i RMAN Backup and Recovery (with co-author Matthew Hart) is out now! Enjoy! And remember, if you like it, I wrote it. If you don't like it.. hm let's see then Tim Gorman wrote it. RF 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. -Original Message- Sent: Thursday, October 24, 2002 9:55 AM To: Multiple recipients of list ORACLE-L MIB, hey I saw that movie too. ;o) -Original Message- Sent: Thursday, October 24, 2002 8:14 AM To: Multiple recipients of list ORACLE-L Oracle SNMP Support Reference Guide has the MIBs documented. That can be found under the Oracle Enterprise Manager docs. On Wed, Oct 23, 2002 at 03:19:22PM -0800, John Kanagaraj wrote: Kevin, This is great! Can we get a list of all the OIDs that Oracle uses? Can you also let the group know if any additional plug-ins are required for Perl to work with SNMP? John Kanagaraj Oracle Applications DBA DBSoft Inc (W): 408-970-7002 What would you see if you were allowed to look back at your life at the end of your journey in this earth? ** The opinions and statements above are entirely my own and not those of my employer or clients ** -Original Message- Sent: Wednesday, October 23, 2002 3:54 PM To: Multiple recipients of list ORACLE-L Yes. You can use PERL to do such things such as getting the database state, name, consistent gets, system block gets, etc from SNMP: #!/usr/local/bin/perl use BER; use SNMP_Session; use SNMP_util; use Getopt::Std; getopts(h:i:); my($host, $community, $response, $bindings, $binding, $value, @oid, @retvals); my $session; $host = $opt_h; $community = public; $db_index = $opt_i; # Database State $oid[0] = '.1.3.6.1.2.1.39.1.9.1.1.2.2'; #Database Name $oid[1] = '.1.3.6.1.2.1.39.1.7.1.4.' . $db_index . '.7.100.98.95.110.97.109.101.1'; # Consistent Block Gets $oid[2] = 'enterprises.111.4.1.1.1.2.' . $db_index; # System Block Gets $oid[3] = 'enterprises.111.4.1.1.1.4.' . $db_index; my @retvals = SNMP_util::snmpget ( $host, @oid ); -Original Message- Sent: Wednesday, October 23, 2002 5:20 PM To: Multiple recipients of list ORACLE-L Thanks Dennis, Gary I have tools at my disposal to monitor the db, and I have no problem with that. I was just reading through snmp and was intrigues by the idea that I could get some information without running scripts through sqlplus interface and if so how to accomplish that. I know it is doable because IA does that, just wondering if it would be feasible to do it be some scripting ... Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! -Original Message- mailto:DWILLIAMS;LIFETOUCH.COM ] Sent: Wednesday, October 23, 2002 6:04 PM To: Multiple recipients of list ORACLE-L Raj - I'm no
Re: Full Import/tablespace sizes
Mike, While not necessary, it would be a good idea to precreate the tablespaces. Else, for a clean import the first time, you would need to ensure that the directory structure for the datafiles exists, you have the permissions to create files at the OS level, ensure that files dont already exist (avoid Destroy=Y), et all. Else, you might find yourself running the import, shouting crap, fixing and re-running the import. Raj Mike Sardina cemail2@sprinTo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] tmail.comcc: Sent by: Subject: Full Import/tablespace sizes [EMAIL PROTECTED] om October 24, 2002 03:25 PM Please respond to ORACLE-L To do an import from a full export of a database, do the tablespaces already need to be set up before the import? How can you query the database to get the tablespace name and the total space needed for each tablespace? -- 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: System Tablespace and Autoextend
Sam, Autoextend caused tablespace corruption for me once, but it was over 5 years ago with Personal Oracle 7.3.2.3 on Win95 - not the most reliable OS that Oracle has ever ported to. ;-) We have several 8.1.7 databases here, on both Win2k and HPUX. Autoextend, even on System, has caused no problems that I'm aware of. Jack C. Applewhite Database Administrator Austin Independent School District Austin, Texas 512.414.9715 [EMAIL PROTECTED] Sam Bootsma [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: System Tablespace and Autoextend om 10/24/2002 01:26 PM Please respond to ORACLE-L Hello All, I have heard several times that if the SYSTEM tablespace runs out of space and needs to autoextend (assuming autoextend is turned on for the data file), then you run the risk of the database crashing and of data dictionary corruption. I have never personally encountered this problem, so I have no experience on what actually does happen. I looked in metalink for documents on this, but turned up nothing. Does anybody have experience on the dangers of allowing the SYSTEM tablespace to autoextend and also any documents on Metalink or OTN that describe this problem? We are running Oracle versions 7.3.4, 8.0.5, 8.1.7, and 9.2. All our Oracle versions are running on Windows NT (or Windows 2000). Thanks for any feedback. Sam Bootsma, OCP [EMAIL PROTECTED] -- Author: Sam Bootsma INET: [EMAIL PROTECTED] -- 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: Flat file generation integrity ideas...
Title: Flat file generation integrity ideas... I do not see how the file can get "scrambled". You write it out ok. The ftp is guaranteed. So what is the problem. I will go along with the suggestion to zip it. It saves on the ftp time and also gives you some protection. Yechiel AdarMehish - Original Message - From: Grabowy, Chris To: Multiple recipients of list ORACLE-L Sent: Thursday, October 24, 2002 7:34 PM Subject: Flat file generation integrity ideas... I have to create packages that will generate several flat files of data from tables that will be sent to other systems to be processed. I am looking for ideas on how to ensure data integrity in the flat files. For example, the expected record count is stored on the first line of the file to ensure that the correct amount of records was received. The systems group is chartered to ensure the flat files are correctly FTPed between systems, so that's covered. I just worry that if "somehow" a flat file is scrambled then the scrambled data is loaded into the database, therefore corrupting it. At this phase, XML is not an option I keep thinking that some sort of CRC should be stored with each line in the flat file. And then before the line is loaded into the database, the CRC is compared against the generated CRC of the just read line. Has anyone done anything like this? Any examples out there? Many TIA!!
Suggestions solicited - Change Column Datatype from Number to Var
We have a need to change the datatype ofseveral columns in a table from number to varchar2.Most of the rows have data in these columns hence a direct 'alter table...' will not work. We plan to create a temp table, move the data from these colums to that table,modify the column datatype from number to varchar2 and then update the colums with the data that was moved to the temp table. Any suggestions/comments or a better way to do this ? Oh, and we are on 8.1.7.1 thanx deepak
RE: Full Import/tablespace sizes
Mike - Yes, you need to create those tablespaces first. If the tablespace isn't there, import will default to the default tablespace of the username that is running the import. Select bytes from dba_data_files to find the tablespace sizes. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, October 24, 2002 2:26 PM To: Multiple recipients of list ORACLE-L To do an import from a full export of a database, do the tablespaces already need to be set up before the import? How can you query the database to get the tablespace name and the total space needed for each tablespace? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mike Sardin INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: LOCALLY MANAGED TABLESPACE
Seema - While you are planning your conversion, be sure to carefully read the paper: How to stop defragmenting and start living: The definitive word on fragmentation by Himatsingka and Loaiza so you really understand how to receive the benefits of LMTs. It is available on http://www.hotsos.com and on http://otn.oracle.com/deploy/availability/pdf/defrag.pdf Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, October 24, 2002 1:49 PM To: Multiple recipients of list ORACLE-L Hi I am thinking to change our few dictinary manages tablespace to locally managed tablespace.Can any one experienced any issues with locally managed tablespace? Do any one experience what gain after changing to locally managed tablespace? Thx -Seema _ Unlimited Internet access for only $21.95/month. Try MSN! http://resourcecenter.msn.com/access/plans/2monthsfree.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seema Singh INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: System Tablespace and Autoextend
Hello Sam I do not know specifically about SYSTEM tablespace but from a bitter experience beware of the 4GB limit. if a datafile on NT/2000 autoextend beyond a multiple of 4GB (8,12...) then that datafile is GONE. We had a production database crashing on this problem and had to call in Oracle with the DUL utility to help get the data out and rebuild the database. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, October 24, 2002 8:26 PM Hello All, I have heard several times that if the SYSTEM tablespace runs out of space and needs to autoextend (assuming autoextend is turned on for the data file), then you run the risk of the database crashing and of data dictionary corruption. I have never personally encountered this problem, so I have no experience on what actually does happen. I looked in metalink for documents on this, but turned up nothing. Does anybody have experience on the dangers of allowing the SYSTEM tablespace to autoextend and also any documents on Metalink or OTN that describe this problem? We are running Oracle versions 7.3.4, 8.0.5, 8.1.7, and 9.2. All our Oracle versions are running on Windows NT (or Windows 2000). Thanks for any feedback. Sam Bootsma, OCP [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sam Bootsma INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Full Import/tablespace sizes
Full import will rebuild the tablespaces. browse the export file and you will see the commands inside. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, October 24, 2002 9:25 PM To do an import from a full export of a database, do the tablespaces already need to be set up before the import? How can you query the database to get the tablespace name and the total space needed for each tablespace? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mike Sardin INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Flat file generation integrity ideas...
Chris - If Tom's idea provides you the protection you require, with convenience to boot, then it sounds like you have a winner. I think all the suggestions provide some variety of checksum, a standard computer science technique. What are your requirements? Mainly to make sure the file doesn't get truncated? To make sure some of the records don't get changed? Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, October 24, 2002 2:02 PM To: Multiple recipients of list ORACLE-L I will have to keep those in mind, if I ever get back onto a UNIX platform. Right now, I'm sticking to Tom's suggestion because I religiously follow KISS. Thanks!! -Original Message- Sent: Thursday, October 24, 2002 2:19 PM To: Multiple recipients of list ORACLE-L Chris - I would consider checksums. Many systems have built-in checksum functions. On Unix these are cksum and sum. You could probably write a simple one that would work on your various systems. Search for checksum and somewhere on the Internet is probably sample code for one in a language that will work for you. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, October 24, 2002 12:35 PM To: Multiple recipients of list ORACLE-L I have to create packages that will generate several flat files of data from tables that will be sent to other systems to be processed. I am looking for ideas on how to ensure data integrity in the flat files. For example, the expected record count is stored on the first line of the file to ensure that the correct amount of records was received. The systems group is chartered to ensure the flat files are correctly FTPed between systems, so that's covered. I just worry that if somehow a flat file is scrambled then the scrambled data is loaded into the database, therefore corrupting it. At this phase, XML is not an option I keep thinking that some sort of CRC should be stored with each line in the flat file. And then before the line is loaded into the database, the CRC is compared against the generated CRC of the just read line. Has anyone done anything like this? Any examples out there? Many TIA!! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Grabowy, Chris INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Flat file generation integrity ideas...
Title: Message Trouble with this is that there is a possibility that a change in the number in the file could result in the same sum. Then you have different data but your checks says everything is ok. Checksums are far more accurate. -Original Message-From: Grabowy, Chris [mailto:[EMAIL PROTECTED]]Sent: Thursday, October 24, 2002 1:49 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Flat file generation integrity ideas... (slapping my forehead) Duh. Nice. I like it. Simple but effective. Minimal impact on performance. And easy for the other systems to implement. You da man, Tom, I don't care what Jared and Rachel said about you... Thanks. -Original Message-From: Mercadante, Thomas F [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 24, 2002 2:14 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Flat file generation integrity ideas... Chris, have you thought aboutsumming a number column in the record and placing this sum in a trailer record? this way, you have a header and trailer record which helps you be confident that the whole file made it to the target system. and by comparing the sum of the imported records with the trailer record, it gives you a better level of confidence that things didn't get scrambled. I used to do all sorts of these things when file transfer was not as good as it is now. the above method is pretty simple, easy to do, and pretty accurate. hope this helps. Tom Mercadante Oracle Certified Professional -Original Message-From: Grabowy, Chris [mailto:[EMAIL PROTECTED]]Sent: Thursday, October 24, 2002 1:35 PMTo: Multiple recipients of list ORACLE-LSubject: Flat file generation integrity ideas... I have to create packages that will generate several flat files of data from tables that will be sent to other systems to be processed. I am looking for ideas on how to ensure data integrity in the flat files. For example, the expected record count is stored on the first line of the file to ensure that the correct amount of records was received. The systems group is chartered to ensure the flat files are correctly FTPed between systems, so that's covered. I just worry that if "somehow" a flat file is scrambled then the scrambled data is loaded into the database, therefore corrupting it. At this phase, XML is not an option I keep thinking that some sort of CRC should be stored with each line in the flat file. And then before the line is loaded into the database, the CRC is compared against the generated CRC of the just read line. Has anyone done anything like this? Any examples out there? Many TIA!!
RE: LOCALLY MANAGED TABLESPACE
Title: RE: LOCALLY MANAGED TABLESPACE Metalink Note: 93771.1 -Original Message- From: Seema Singh [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 24, 2002 2:49 PM To: Multiple recipients of list ORACLE-L Subject: LOCALLY MANAGED TABLESPACE Hi I am thinking to change our few dictinary manages tablespace to locally managed tablespace.Can any one experienced any issues with locally managed tablespace? Do any one experience what gain after changing to locally managed tablespace? Thx -Seema _ Unlimited Internet access for only $21.95/month. Try MSN! http://resourcecenter.msn.com/access/plans/2monthsfree.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seema Singh INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Full Import/tablespace sizes
To do an import from a full export of a database, do the tablespaces already need to be set up before the import? How can you query the database to get the tablespace name and the total space needed for each tablespace? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mike Sardin INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RV: Nuestra Profesión Ing. Sistemas
Ups colegas ! @lex Lic. Alexander Ordóñez Arroyo Soporte Tru64Unix BD Oracle Caja Costarricense del Seguro Social Telefono: 295-2004, San José, Costa Rica [EMAIL PROTECTED] Celular 397-0532 The truth is out there in WWW Tomado de Un amigo Estoy pensando seriamente dejar de ser ingeniero en sistemas 1.- Trabajas en horas extrañas. !Como las putas! 2.- Te pagan para mantener al cliente feliz. !Como las putas! 3.- El cliente paga mucho mas pero tu jefe se queda con casi todo el dinero. !Como las putas! 4.- Cobras por hora pero tu tiempo se extiende hasta que termines. ! Como las putas! 5.- Si eres bueno, nunca estas orgulloso de lo que haces. !Como las putas! 6.- Te recompensan por satisfacer las fantasías de tus clientes. !Como las putas! 7.- Es difícil tener y mantener una familia. !Como las putas! 8.- Cuando te preguntan en que trabajas no lo puedes explicar. !Como las putas! 9.- Tus amigos se distancian de ti y tu solo andas con otros igual que tu. !Como las putas! 10.- El cliente paga tu cuenta del hotel y por horas trabajadas. !Como las putas! 11.- Tu jefe tiene un buen coche. !Como las putas! 12.- Cuando vas a hacer una asistencia al cliente estas óptimo. !Como las putas!. 13.- Pero cuando vuelves pareces haber salido del infierno. !Como las putas! 14.- Evalúan tu capacidad con horribles pruebas. !Como las putas! 15.- El cliente siempre quiere pagar menos y encima quiere que hagas maravillas. !Como las putas! 16.- Cada día al levantarte dices !!!NO VOY A HACER ESTO TODA MI VIDA!!!. !Como las putas! 17.- Sin conocer nada de su problema los clientes esperan que les des el consejo que necesitan. !Como las putas! 18.- Si las cosas salen mal es siempre culpa tuya. !Como las putas! 19.- Tienes que brindarle servicios gratis a tu jefe, amigos y familiares. !Como las putas! !Puta! ¿¿Hasta cuándo?? application/ms-tnef
RE: Flat file generation integrity ideas...
I will have to keep those in mind, if I ever get back onto a UNIX platform. Right now, I'm sticking to Tom's suggestion because I religiously follow KISS. Thanks!! -Original Message- Sent: Thursday, October 24, 2002 2:19 PM To: Multiple recipients of list ORACLE-L Chris - I would consider checksums. Many systems have built-in checksum functions. On Unix these are cksum and sum. You could probably write a simple one that would work on your various systems. Search for checksum and somewhere on the Internet is probably sample code for one in a language that will work for you. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, October 24, 2002 12:35 PM To: Multiple recipients of list ORACLE-L I have to create packages that will generate several flat files of data from tables that will be sent to other systems to be processed. I am looking for ideas on how to ensure data integrity in the flat files. For example, the expected record count is stored on the first line of the file to ensure that the correct amount of records was received. The systems group is chartered to ensure the flat files are correctly FTPed between systems, so that's covered. I just worry that if somehow a flat file is scrambled then the scrambled data is loaded into the database, therefore corrupting it. At this phase, XML is not an option I keep thinking that some sort of CRC should be stored with each line in the flat file. And then before the line is loaded into the database, the CRC is compared against the generated CRC of the just read line. Has anyone done anything like this? Any examples out there? Many TIA!! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Grabowy, Chris INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Flat file generation integrity ideas...
Title: Flat file generation integrity ideas... Chris; I would suggest the following: 1. Generating Check Sums of the files before they are sent. 2.Send the files. 3. Generating an after Check Sum and compare. Here are the steps I go thru to make sure our Oracle Archive Logs are correctly transfered to our Standby Server: 1. Zip the Archive Logs into 1 Zip. 2. Check Sum the Zip. 3. Use the TEST option to make sure the Zip is good. 4. RCP the zip file to the standby location. 5. RSH a test of the Zip. 6. RSH a Check Sum of the Transfered Zip and compare to original value. 7. Unzip the file With this method you have 2 independent checks the Check Sum and the Zip Integrity Check. -Original Message-From: Grabowy, Chris [mailto:[EMAIL PROTECTED]]Sent: Thursday, October 24, 2002 12:35 PMTo: Multiple recipients of list ORACLE-LSubject: Flat file generation integrity ideas... I have to create packages that will generate several flat files of data from tables that will be sent to other systems to be processed. I am looking for ideas on how to ensure data integrity in the flat files. For example, the expected record count is stored on the first line of the file to ensure that the correct amount of records was received. The systems group is chartered to ensure the flat files are correctly FTPed between systems, so that's covered. I just worry that if "somehow" a flat file is scrambled then the scrambled data is loaded into the database, therefore corrupting it. At this phase, XML is not an option I keep thinking that some sort of CRC should be stored with each line in the flat file. And then before the line is loaded into the database, the CRC is compared against the generated CRC of the just read line. Has anyone done anything like this? Any examples out there? Many TIA!!
RE: Flat file generation integrity ideas...
Title: Message (slapping my forehead) Duh. Nice. I like it. Simple but effective. Minimal impact on performance. And easy for the other systems to implement. You da man, Tom, I don't care what Jared and Rachel said about you... Thanks. -Original Message-From: Mercadante, Thomas F [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 24, 2002 2:14 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Flat file generation integrity ideas... Chris, have you thought aboutsumming a number column in the record and placing this sum in a trailer record? this way, you have a header and trailer record which helps you be confident that the whole file made it to the target system. and by comparing the sum of the imported records with the trailer record, it gives you a better level of confidence that things didn't get scrambled. I used to do all sorts of these things when file transfer was not as good as it is now. the above method is pretty simple, easy to do, and pretty accurate. hope this helps. Tom Mercadante Oracle Certified Professional -Original Message-From: Grabowy, Chris [mailto:[EMAIL PROTECTED]]Sent: Thursday, October 24, 2002 1:35 PMTo: Multiple recipients of list ORACLE-LSubject: Flat file generation integrity ideas... I have to create packages that will generate several flat files of data from tables that will be sent to other systems to be processed. I am looking for ideas on how to ensure data integrity in the flat files. For example, the expected record count is stored on the first line of the file to ensure that the correct amount of records was received. The systems group is chartered to ensure the flat files are correctly FTPed between systems, so that's covered. I just worry that if "somehow" a flat file is scrambled then the scrambled data is loaded into the database, therefore corrupting it. At this phase, XML is not an option I keep thinking that some sort of CRC should be stored with each line in the flat file. And then before the line is loaded into the database, the CRC is compared against the generated CRC of the just read line. Has anyone done anything like this? Any examples out there? Many TIA!!
RE: RMAN - It's Here
Why pay more, Try www.bookpool.com Oracle9i RMAN Backup Recovery Freeman, et al / McGraw Hill / 2002 / 0072226625 Our Price $30.95 ~ You Save $19.04 (38% Off) Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Thu, 24 Oct 2002 09:48:55 -0800 Amazon.com, Oraclepressbooks.com, etc... 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. -Original Message- Sent: Thursday, October 24, 2002 11:09 AM To: Multiple recipients of list ORACLE-L Where? Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, October 24, 2002 4:44 PM Just a note that my new book Oracle9i RMAN Backup and Recovery (with co-author Matthew Hart) is out now! Enjoy! And remember, if you like it, I wrote it. If you don't like it.. hm let's see then Tim Gorman wrote it. RF 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. -Original Message- Sent: Thursday, October 24, 2002 9:55 AM To: Multiple recipients of list ORACLE-L MIB, hey I saw that movie too. ;o) -Original Message- Sent: Thursday, October 24, 2002 8:14 AM To: Multiple recipients of list ORACLE-L Oracle SNMP Support Reference Guide has the MIBs documented. That can be found under the Oracle Enterprise Manager docs. On Wed, Oct 23, 2002 at 03:19:22PM -0800, John Kanagaraj wrote: Kevin, This is great! Can we get a list of all the OIDs that Oracle uses? Can you also let the group know if any additional plug-ins are required for Perl to work with SNMP? John Kanagaraj Oracle Applications DBA DBSoft Inc (W): 408-970-7002 What would you see if you were allowed to look back at your life at the end of your journey in this earth? ** The opinions and statements above are entirely my own and not those of my employer or clients ** -Original Message- Sent: Wednesday, October 23, 2002 3:54 PM To: Multiple recipients of list ORACLE-L Yes. You can use PERL to do such things such as getting the database state, name, consistent gets, system block gets, etc from SNMP: #!/usr/local/bin/perl use BER; use SNMP_Session; use SNMP_util; use Getopt::Std; getopts(h:i:); my($host, $community, $response, $bindings, $binding, $value, @oid, @retvals); my $session; $host = $opt_h; $community = public; $db_index = $opt_i; # Database State $oid[0] = '.1.3.6.1.2.1.39.1.9.1.1.2.2'; #Database Name $oid[1] = '.1.3.6.1.2.1.39.1.7.1.4.' . $db_index . '.7.100.98.95.110.97.109.101.1'; # Consistent Block Gets $oid[2] = 'enterprises.111.4.1.1.1.2.' . $db_index; # System Block Gets $oid[3] = 'enterprises.111.4.1.1.1.4.' . $db_index; my @retvals = SNMP_util::snmpget ( $host, @oid ); -Original Message- Sent: Wednesday, October 23, 2002 5:20 PM To: Multiple recipients of list ORACLE-L Thanks Dennis, Gary I have tools at my disposal to monitor the db, and I have no problem with that. I was just reading through snmp and was intrigues by the idea that I could get some information without running scripts through sqlplus interface and if so how to accomplish that. I know it is doable because IA does that, just wondering if it would be feasible to do it be some scripting ... Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! -Original Message- mailto:DWILLIAMS;LIFETOUCH.COM ] Sent: Wednesday, October 23, 2002 6:04 PM To: Multiple recipients of list ORACLE-L Raj - I'm no expert on SNMP, so maybe someone that is more knowledgeable will reply. I believe that SNMP underlies most of the monitoring tools on the market today. OEM may even use SNMP. I can see two approaches for you. 1. You write your own tool that will issue SNMP alerts. Perhaps this would be a Unix daemon process that executes database queries, and then based on what it finds, issues SNMP alerts. 2. Use an existing tool to accomplish what you want. If your desire is to create a database monitoring tool that you can give away for free, then sell to CA for a lot of money, take path #1. If your goal is to become a better DBA, then I would go with #2. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] mailto:dwilliams;lifetouch.com mailto:dwilliams;lifetouch.com -Original Message- Sent:
RE: QUERY?
Title: RE: QUERY? Without a clearer description of what it isn't doing, my WAG is missing permissions on the views or tables. Jerry Whittle ACIFICS DBA NCI Information Systems Inc. [EMAIL PROTECTED] 618-622-4145 -Original Message- From: Seema Singh [SMTP:[EMAIL PROTECTED]] Hi Can some one suggest whats wrong in this query?The same query run fine on development db but not running on production? select count(a.xxx_id) from gorp_cats_stats_view a , static_pages b where b.xxx_id = a.xxx_id and b.words like '%test%' and a.main not like '%test%' and a.url not like '%test%' order by a.url Thx -Seema
RE: Flat file generation integrity ideas...
Title: Flat file generation integrity ideas... Chris, have you thought aboutsumming a number column in the record and placing this sum in a trailer record? this way, you have a header and trailer record which helps you be confident that the whole file made it to the target system. and by comparing the sum of the imported records with the trailer record, it gives you a better level of confidence that things didn't get scrambled. I used to do all sorts of these things when file transfer was not as good as it is now. the above method is pretty simple, easy to do, and pretty accurate. hope this helps. Tom Mercadante Oracle Certified Professional -Original Message-From: Grabowy, Chris [mailto:[EMAIL PROTECTED]]Sent: Thursday, October 24, 2002 1:35 PMTo: Multiple recipients of list ORACLE-LSubject: Flat file generation integrity ideas... I have to create packages that will generate several flat files of data from tables that will be sent to other systems to be processed. I am looking for ideas on how to ensure data integrity in the flat files. For example, the expected record count is stored on the first line of the file to ensure that the correct amount of records was received. The systems group is chartered to ensure the flat files are correctly FTPed between systems, so that's covered. I just worry that if "somehow" a flat file is scrambled then the scrambled data is loaded into the database, therefore corrupting it. At this phase, XML is not an option I keep thinking that some sort of CRC should be stored with each line in the flat file. And then before the line is loaded into the database, the CRC is compared against the generated CRC of the just read line. Has anyone done anything like this? Any examples out there? Many TIA!!
RE: Flat file generation integrity ideas...
Chris - I would consider checksums. Many systems have built-in checksum functions. On Unix these are cksum and sum. You could probably write a simple one that would work on your various systems. Search for checksum and somewhere on the Internet is probably sample code for one in a language that will work for you. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, October 24, 2002 12:35 PM To: Multiple recipients of list ORACLE-L I have to create packages that will generate several flat files of data from tables that will be sent to other systems to be processed. I am looking for ideas on how to ensure data integrity in the flat files. For example, the expected record count is stored on the first line of the file to ensure that the correct amount of records was received. The systems group is chartered to ensure the flat files are correctly FTPed between systems, so that's covered. I just worry that if somehow a flat file is scrambled then the scrambled data is loaded into the database, therefore corrupting it. At this phase, XML is not an option I keep thinking that some sort of CRC should be stored with each line in the flat file. And then before the line is loaded into the database, the CRC is compared against the generated CRC of the just read line. Has anyone done anything like this? Any examples out there? Many TIA!! -- 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: QUERY?
Seema Have you run an explain plan? Your query will likely do a full-table scan of both tables. Are they large? Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, October 24, 2002 11:40 AM To: Multiple recipients of list ORACLE-L Hi Can some one suggest whats wrong in this query?The same query run fine on development db but not running on production? select count(a.xxx_id) from gorp_cats_stats_view a , static_pages b where b.xxx_id = a.xxx_id andb.words like '%test%' anda.main not like '%test%' anda.url not like '%test%' order by a.url Thx -Seema _ 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.com -- Author: Seema Singh INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- 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).
Streams
Has anyone started using the Oracle streams feature? I'm wondering how this compares to Advanced Rep. I am guessing this approach will provide better performance but thought I'd check with the list to see if someone can confirm this. Thanks, Dave -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: David Turner INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: QUERY?
Man, I can't think of a thing that would cause this. I'd suggest running tkprof or somesuch on the query in both environments but it probably wouldn't do any good. Comparing indexes? Nah, forget it. Not worth the time. What else, what else??? --Walt Weaver Bozeman, Montana -Original Message- Sent: Thursday, October 24, 2002 10:40 AM To: Multiple recipients of list ORACLE-L Hi Can some one suggest whats wrong in this query?The same query run fine on development db but not running on production? select count(a.xxx_id) from gorp_cats_stats_view a , static_pages b where b.xxx_id = a.xxx_id andb.words like '%test%' anda.main not like '%test%' anda.url not like '%test%' order by a.url Thx -Seema _ 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.com -- Author: Seema Singh INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Weaver, Walt INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: RMAN - It's Here
Title: RE: RMAN - It's Here do list members get a I post where you post discount? =) -Original Message- From: Freeman, Robert [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 24, 2002 10:44 AM To: Multiple recipients of list ORACLE-L Subject: RMAN - It's Here Just a note that my new book Oracle9i RMAN Backup and Recovery (with co-author Matthew Hart) is out now! Enjoy! And remember, if you like it, I wrote it. If you don't like it.. hm let's see then Tim Gorman wrote it. RF 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. -Original Message- Sent: Thursday, October 24, 2002 9:55 AM To: Multiple recipients of list ORACLE-L MIB, hey I saw that movie too. ;o) -Original Message- Sent: Thursday, October 24, 2002 8:14 AM To: Multiple recipients of list ORACLE-L Oracle SNMP Support Reference Guide has the MIBs documented. That can be found under the Oracle Enterprise Manager docs. On Wed, Oct 23, 2002 at 03:19:22PM -0800, John Kanagaraj wrote: Kevin, This is great! Can we get a list of all the OIDs that Oracle uses? Can you also let the group know if any additional plug-ins are required for Perl to work with SNMP? John Kanagaraj Oracle Applications DBA DBSoft Inc (W): 408-970-7002 What would you see if you were allowed to look back at your life at the end of your journey in this earth? ** The opinions and statements above are entirely my own and not those of my employer or clients ** -Original Message- Sent: Wednesday, October 23, 2002 3:54 PM To: Multiple recipients of list ORACLE-L Yes. You can use PERL to do such things such as getting the database state, name, consistent gets, system block gets, etc from SNMP: #!/usr/local/bin/perl use BER; use SNMP_Session; use SNMP_util; use Getopt::Std; getopts(h:i:); my($host, $community, $response, $bindings, $binding, $value, @oid, @retvals); my $session; $host = $opt_h; $community = public; $db_index = $opt_i; # Database State $oid[0] = '.1.3.6.1.2.1.39.1.9.1.1.2.2'; #Database Name $oid[1] = '.1.3.6.1.2.1.39.1.7.1.4.' . $db_index . '.7.100.98.95.110.97.109.101.1'; # Consistent Block Gets $oid[2] = 'enterprises.111.4.1.1.1.2.' . $db_index; # System Block Gets $oid[3] = 'enterprises.111.4.1.1.1.4.' . $db_index; my @retvals = SNMP_util::snmpget ( $host, @oid ); -Original Message- Sent: Wednesday, October 23, 2002 5:20 PM To: Multiple recipients of list ORACLE-L Thanks Dennis, Gary I have tools at my disposal to monitor the db, and I have no problem with that. I was just reading through snmp and was intrigues by the idea that I could get some information without running scripts through sqlplus interface and if so how to accomplish that. I know it is doable because IA does that, just wondering if it would be feasible to do it be some scripting ... Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! -Original Message- mailto:[EMAIL PROTECTED] ] Sent: Wednesday, October 23, 2002 6:04 PM To: Multiple recipients of list ORACLE-L Raj - I'm no expert on SNMP, so maybe someone that is more knowledgeable will reply. I believe that SNMP underlies most of the monitoring tools on the market today. OEM may even use SNMP. I can see two approaches for you. 1. You write your own tool that will issue SNMP alerts. Perhaps this would be a Unix daemon process that executes database queries, and then based on what it finds, issues SNMP alerts. 2. Use an existing tool to accomplish what you want. If your desire is to create a database monitoring tool that you can give away for free, then sell to CA for a lot of money, take path #1. If your goal is to become a better DBA, then I would go with #2. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -Original Message- Sent: Wednesday, October 23, 2002 4:39 PM To: Multiple recipients of list ORACLE-L Has anyone implemented basic DB monitoring using snmp MIB information rather than running queries against the db? I am looking into this and have no clue or available docs on how to do this (esp on AIX). If someone can point me to the right direction, I would really appreciate that. TIA Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and
Re: Oracle Real Application Clusters
On Thu, Oct 24, 2002 at 06:53:27AM -0800, Tim Gorman wrote: NetApp is NFS; so are all current NAS products... The phrases NetApp and cheap are *always* used together -- it is their most compelling feature. CFOs love NetApps. For database usage however, The netapp sales guy I talked with must have been trying to make his quota for that quarter in one stop. Their storage was off the charts when I talked to them, but it has been awhile. So, for testing of rac I could just use nfs disks mounted r/w from multiple linux boxes? I think I'll try it unless someone knows that dog won't hunt. === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Trivia question - not of any practical use.
The easiest solution I can think of is to set spool off within the script. Dennis Charu Joshi wrote: Dear Listers, Given below is a script that I execute from within SQL*Plus for WinNT: temp.sql: - set echo off set pagesize 0 set feedback off SELECT * FROM tab WHERE ROWNUM 10; set pagesize 1000 set feedback on set echo on - While running it always displays 'SQLset echo off' before muffling the echo. Is there any way to stop this line from appearing? I vaguely remember that in some language you could put @ in front of the 'set echo off' command to suppress it. Is there something similar possible. TIA. Regards, Charu. -Original Message- Sent: Thursday, October 24, 2002 12:26 PM To: Multiple recipients of list ORACLE-L the firewall should use sqlnet proxy. most firewalls support it and if this one doesn't scrap it! only the initial connection is made on port 1521. [EMAIL PROTECTED] 10/24/02 05:44AM we had the same problem and we found that oracle use the standard port only to make the initial connection. All the traffic after that is done on different ports. So you need to open the range that oracle use in the firewall. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, October 24, 2002 8:13 AM Environment: Oracle 8.1.6 AIX server behind a firewall db is accessed by a Windows application running on a IIS web server sitting outside the firewall db uses port 1521 After a flurry of email between the Unix admin and the 4 software vendors concerned, all the fingers are now pointing at that damn oracle database. The Unix admin is asking two questions: 1) what Oracle is doing with the four ports 20,000 - 20,003 2) can he shut them down? Any ideas are appreciated. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Don INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gene Sais INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). * Disclaimer This message (including any attachments) contains confidential information intended for a specific individual and purpose, and is protected by law. If you are not the intended recipient, you should delete this message and are hereby notified that any disclosure, copying, or distribution of this message, or the taking of any action based on it, is strictly prohibited. * Visit us at http://www.mahindrabt.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Charu Joshi INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing
Trivia question - not of any practical use.
Dear Listers, Given below is a script that I execute from within SQL*Plus for WinNT: temp.sql: - set echo off set pagesize 0 set feedback off SELECT * FROM tab WHERE ROWNUM 10; set pagesize 1000 set feedback on set echo on - While running it always displays 'SQLset echo off' before muffling the echo. Is there any way to stop this line from appearing? I vaguely remember that in some language you could put @ in front of the 'set echo off' command to suppress it. Is there something similar possible. TIA. Regards, Charu. -Original Message- Sent: Thursday, October 24, 2002 12:26 PM To: Multiple recipients of list ORACLE-L the firewall should use sqlnet proxy. most firewalls support it and if this one doesn't scrap it! only the initial connection is made on port 1521. [EMAIL PROTECTED] 10/24/02 05:44AM we had the same problem and we found that oracle use the standard port only to make the initial connection. All the traffic after that is done on different ports. So you need to open the range that oracle use in the firewall. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, October 24, 2002 8:13 AM Environment: Oracle 8.1.6 AIX server behind a firewall db is accessed by a Windows application running on a IIS web server sitting outside the firewall db uses port 1521 After a flurry of email between the Unix admin and the 4 software vendors concerned, all the fingers are now pointing at that damn oracle database. The Unix admin is asking two questions: 1) what Oracle is doing with the four ports 20,000 - 20,003 2) can he shut them down? Any ideas are appreciated. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Don INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gene Sais INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). * Disclaimer This message (including any attachments) contains confidential information intended for a specific individual and purpose, and is protected by law. If you are not the intended recipient, you should delete this message and are hereby notified that any disclosure, copying, or distribution of this message, or the taking of any action based on it, is strictly prohibited. * Visit us at http://www.mahindrabt.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Charu Joshi INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Oracle Performance Tuning (Book)
Any follks have reviews on the book Oracle Performance Tuning written by Edward Whalen Mitchell Schroter and published by Addison-Wesley? Saw a blurb in the recent issue of Ora Mag. Thanks mkb __ Do you Yahoo!? Y! Web Hosting - Let the expert host your web site http://webhosting.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: mkb INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle Real Application Clusters
Title: RE: Oracle Real Application Clusters We had the user which owns oracle was nfs mounted across two machines using nfs. i.e. user oraclei home directory was nfs mounted across tow machines. When we used srvctl to start instances occasionally it used to hang when bringing up the 'other side'. Also when nfs had the problem, it would crash. Our Unix guys fixed the problem (I don't know how) and ORacle is looking into the problem. Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! -Original Message- From: Ray Stell [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 24, 2002 10:39 AM To: Multiple recipients of list ORACLE-L Subject: Re: Oracle Real Application Clusters On Thu, Oct 24, 2002 at 05:43:38AM -0800, Jamadagni, Rajendra wrote: If I remember right we had some problems with gsd and nfs ... could you elaborate? === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC 28^D 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.*2
RE: Activating batch file from a trigger on nt
Could you use an external procedure or java call? Metalink Tom Kyte's book have good examples. -Original Message- Sent: Thursday, October 24, 2002 9:29 AM To: Multiple recipients of list ORACLE-L Hello all How can I run startup.bat file when database is up. I tried using the HOST command in trigger but it does not work. Something like: 'host d:\oracle\scripts\startup.bat' in the trigger. Win2000, Oracle 8.1.7 or 9.2.0. Yechiel Adar Mehish -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Fink, Dan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Theory v Practice - and business logic...
To me this comes under the heading of common sense. My $0.02 worth, Ken Janusz, CPIM - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, October 24, 2002 9:33 AM As this topic just hits my hot button, I'm going to chime in my 2 cents worth in as well. This in spite of the fact that you have already gotten some great responses. I come from an environment where we have distributed data all over creation. IMS, DB2, Oracle, you name it we have it popping up everywhere. When a new project pops up, guess what the first question is: Does the source of record that we need for this application already exist somewhere? Now, if it does, I've got a HUGE problem if I am not enforcing the RI on this source data, particularly if this new application is going to be manipulating it somehow. Then, as others have mentioned, there are the power users who figure out ODBC and access or Excel.. God help you when they get busy. Another issue with regards to FK/PK's is the use of some Oracle features, such as query rewrite and MViews, which require these structures to be used. While you may not plan on using those features now, there is no telling what the future may hold. Simply put, using defined Pk/FK is a best practice. If you have issues with the validation of FK's (for example in a warehouse environment) then enable them without validation. This leads me to another related hot button topic, thats business logic. In my mind (though I'm having a hard time selling it to apps) the business logic belongs in the database. This for the very same reasons that FK/PK's need to be in place, scalability. That way, when I have new applications coming on line that need to interface with the data, the same business rules are consistently followed. Bottom line, one has to think about tomorrow when one designs, not just today. More to churn on, Robert 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. -Original Message- Sent: Wednesday, October 23, 2002 1:45 PM To: Multiple recipients of list ORACLE-L The developers working on our new VB app are also responsible for setting up the Oracle DB behind it. The app is for an order entry/despatch/warehouse system with 5 million customers and 1000 orders per day. We have nearly 400 tables. They are not planning on using primary keys/secondary keys, as they say they will handle all the constraints via VB. I only have a theoretical knowledge of database design, which says this is very wrong. Is the Oracle system being used as anything more than an expensive file system? In real world scenarios, is this a common practice? Regards Craig Healey ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. Statements and opinions expressed in this e-mail may not represent those of the company. If you have received this email in error please notify [EMAIL PROTECTED] This footnote also confirms that this email message has been swept by MIMEsweeper for the presence of computer viruses (www.mimesweeper.com) *** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Craig Healey INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: 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
Re: RMAN - It's Here
now now, play nice! --- Freeman, Robert [EMAIL PROTECTED] wrote: Just a note that my new book Oracle9i RMAN Backup and Recovery (with co-author Matthew Hart) is out now! Enjoy! And remember, if you like it, I wrote it. If you don't like it.. hm let's see then Tim Gorman wrote it. RF 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. -Original Message- Sent: Thursday, October 24, 2002 9:55 AM To: Multiple recipients of list ORACLE-L MIB, hey I saw that movie too. ;o) -Original Message- Sent: Thursday, October 24, 2002 8:14 AM To: Multiple recipients of list ORACLE-L Oracle SNMP Support Reference Guide has the MIBs documented. That can be found under the Oracle Enterprise Manager docs. On Wed, Oct 23, 2002 at 03:19:22PM -0800, John Kanagaraj wrote: Kevin, This is great! Can we get a list of all the OIDs that Oracle uses? Can you also let the group know if any additional plug-ins are required for Perl to work with SNMP? John Kanagaraj Oracle Applications DBA DBSoft Inc (W): 408-970-7002 What would you see if you were allowed to look back at your life at the end of your journey in this earth? ** The opinions and statements above are entirely my own and not those of my employer or clients ** -Original Message- Sent: Wednesday, October 23, 2002 3:54 PM To: Multiple recipients of list ORACLE-L Yes. You can use PERL to do such things such as getting the database state, name, consistent gets, system block gets, etc from SNMP: #!/usr/local/bin/perl use BER; use SNMP_Session; use SNMP_util; use Getopt::Std; getopts(h:i:); my($host, $community, $response, $bindings, $binding, $value, @oid, @retvals); my $session; $host = $opt_h; $community = public; $db_index = $opt_i; # Database State $oid[0] = '.1.3.6.1.2.1.39.1.9.1.1.2.2'; #Database Name $oid[1] = '.1.3.6.1.2.1.39.1.7.1.4.' . $db_index . '.7.100.98.95.110.97.109.101.1'; # Consistent Block Gets $oid[2] = 'enterprises.111.4.1.1.1.2.' . $db_index; # System Block Gets $oid[3] = 'enterprises.111.4.1.1.1.4.' . $db_index; my @retvals = SNMP_util::snmpget ( $host, @oid ); -Original Message- Sent: Wednesday, October 23, 2002 5:20 PM To: Multiple recipients of list ORACLE-L Thanks Dennis, Gary I have tools at my disposal to monitor the db, and I have no problem with that. I was just reading through snmp and was intrigues by the idea that I could get some information without running scripts through sqlplus interface and if so how to accomplish that. I know it is doable because IA does that, just wondering if it would be feasible to do it be some scripting ... Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! -Original Message- mailto:DWILLIAMS;LIFETOUCH.COM ] Sent: Wednesday, October 23, 2002 6:04 PM To: Multiple recipients of list ORACLE-L Raj - I'm no expert on SNMP, so maybe someone that is more knowledgeable will reply. I believe that SNMP underlies most of the monitoring tools on the market today. OEM may even use SNMP. I can see two approaches for you. 1. You write your own tool that will issue SNMP alerts. Perhaps this would be a Unix daemon process that executes database queries, and then based on what it finds, issues SNMP alerts. 2. Use an existing tool to accomplish what you want. If your desire is to create a database monitoring tool that you can give away for free, then sell to CA for a lot of money, take path #1. If your goal is to become a better DBA, then I would go with #2. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] mailto:dwilliams;lifetouch.com mailto:dwilliams;lifetouch.com -Original Message- Sent: Wednesday, October 23, 2002 4:39 PM To: Multiple recipients of list ORACLE-L Has anyone implemented basic DB monitoring using snmp MIB information rather than running queries against the db? I am looking into this and have no clue or available docs on how to do this (esp on AIX). If someone can point me to the right direction, I would really appreciate that. TIA Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot
Re: RMAN - It's Here
Where? Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, October 24, 2002 4:44 PM Just a note that my new book Oracle9i RMAN Backup and Recovery (with co-author Matthew Hart) is out now! Enjoy! And remember, if you like it, I wrote it. If you don't like it.. hm let's see then Tim Gorman wrote it. RF 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. -Original Message- Sent: Thursday, October 24, 2002 9:55 AM To: Multiple recipients of list ORACLE-L MIB, hey I saw that movie too. ;o) -Original Message- Sent: Thursday, October 24, 2002 8:14 AM To: Multiple recipients of list ORACLE-L Oracle SNMP Support Reference Guide has the MIBs documented. That can be found under the Oracle Enterprise Manager docs. On Wed, Oct 23, 2002 at 03:19:22PM -0800, John Kanagaraj wrote: Kevin, This is great! Can we get a list of all the OIDs that Oracle uses? Can you also let the group know if any additional plug-ins are required for Perl to work with SNMP? John Kanagaraj Oracle Applications DBA DBSoft Inc (W): 408-970-7002 What would you see if you were allowed to look back at your life at the end of your journey in this earth? ** The opinions and statements above are entirely my own and not those of my employer or clients ** -Original Message- Sent: Wednesday, October 23, 2002 3:54 PM To: Multiple recipients of list ORACLE-L Yes. You can use PERL to do such things such as getting the database state, name, consistent gets, system block gets, etc from SNMP: #!/usr/local/bin/perl use BER; use SNMP_Session; use SNMP_util; use Getopt::Std; getopts(h:i:); my($host, $community, $response, $bindings, $binding, $value, @oid, @retvals); my $session; $host = $opt_h; $community = public; $db_index = $opt_i; # Database State $oid[0] = '.1.3.6.1.2.1.39.1.9.1.1.2.2'; #Database Name $oid[1] = '.1.3.6.1.2.1.39.1.7.1.4.' . $db_index . '.7.100.98.95.110.97.109.101.1'; # Consistent Block Gets $oid[2] = 'enterprises.111.4.1.1.1.2.' . $db_index; # System Block Gets $oid[3] = 'enterprises.111.4.1.1.1.4.' . $db_index; my @retvals = SNMP_util::snmpget ( $host, @oid ); -Original Message- Sent: Wednesday, October 23, 2002 5:20 PM To: Multiple recipients of list ORACLE-L Thanks Dennis, Gary I have tools at my disposal to monitor the db, and I have no problem with that. I was just reading through snmp and was intrigues by the idea that I could get some information without running scripts through sqlplus interface and if so how to accomplish that. I know it is doable because IA does that, just wondering if it would be feasible to do it be some scripting ... Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! -Original Message- mailto:DWILLIAMS;LIFETOUCH.COM ] Sent: Wednesday, October 23, 2002 6:04 PM To: Multiple recipients of list ORACLE-L Raj - I'm no expert on SNMP, so maybe someone that is more knowledgeable will reply. I believe that SNMP underlies most of the monitoring tools on the market today. OEM may even use SNMP. I can see two approaches for you. 1. You write your own tool that will issue SNMP alerts. Perhaps this would be a Unix daemon process that executes database queries, and then based on what it finds, issues SNMP alerts. 2. Use an existing tool to accomplish what you want. If your desire is to create a database monitoring tool that you can give away for free, then sell to CA for a lot of money, take path #1. If your goal is to become a better DBA, then I would go with #2. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] mailto:dwilliams;lifetouch.com mailto:dwilliams;lifetouch.com -Original Message- Sent: Wednesday, October 23, 2002 4:39 PM To: Multiple recipients of list ORACLE-L Has anyone implemented basic DB monitoring using snmp MIB information rather than running queries against the db? I am looking into this and have no clue or available docs on how to do this (esp on AIX). If someone can point me to the right direction, I would really appreciate that. TIA Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! -- Please see the official ORACLE-L FAQ:
RE: DB monitoring using SNMP MIBs
Raj; Here is a link to the SNMP Support Reference Guide that Ray talked about for 8.1.7. I am sure its probably somewhere on your Documentation CD for your version. http://www.cosc.canterbury.ac.nz/docs/oracle/server.817/em.817/a85249.pdf All I did was search the web for Oracle SNMP Support Reference Guide Release 8.1.7 and I found a ton of links. Kevin Thanks Ray. -Original Message- Sent: Thursday, October 24, 2002 8:14 AM To: Multiple recipients of list ORACLE-L Oracle SNMP Support Reference Guide has the MIBs documented. That can be found under the Oracle Enterprise Manager docs. On Wed, Oct 23, 2002 at 03:19:22PM -0800, John Kanagaraj wrote: Kevin, This is great! Can we get a list of all the OIDs that Oracle uses? Can you also let the group know if any additional plug-ins are required for Perl to work with SNMP? John Kanagaraj Oracle Applications DBA DBSoft Inc (W): 408-970-7002 What would you see if you were allowed to look back at your life at the end of your journey in this earth? ** The opinions and statements above are entirely my own and not those of my employer or clients ** -Original Message- Sent: Wednesday, October 23, 2002 3:54 PM To: Multiple recipients of list ORACLE-L Yes. You can use PERL to do such things such as getting the database state, name, consistent gets, system block gets, etc from SNMP: #!/usr/local/bin/perl use BER; use SNMP_Session; use SNMP_util; use Getopt::Std; getopts(h:i:); my($host, $community, $response, $bindings, $binding, $value, @oid, @retvals); my $session; $host = $opt_h; $community = public; $db_index = $opt_i; # Database State $oid[0] = '.1.3.6.1.2.1.39.1.9.1.1.2.2'; #Database Name $oid[1] = '.1.3.6.1.2.1.39.1.7.1.4.' . $db_index . '.7.100.98.95.110.97.109.101.1'; # Consistent Block Gets $oid[2] = 'enterprises.111.4.1.1.1.2.' . $db_index; # System Block Gets $oid[3] = 'enterprises.111.4.1.1.1.4.' . $db_index; my @retvals = SNMP_util::snmpget ( $host, @oid ); -Original Message- Sent: Wednesday, October 23, 2002 5:20 PM To: Multiple recipients of list ORACLE-L Thanks Dennis, Gary I have tools at my disposal to monitor the db, and I have no problem with that. I was just reading through snmp and was intrigues by the idea that I could get some information without running scripts through sqlplus interface and if so how to accomplish that. I know it is doable because IA does that, just wondering if it would be feasible to do it be some scripting ... Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! -Original Message- mailto:DWILLIAMS;LIFETOUCH.COM ] Sent: Wednesday, October 23, 2002 6:04 PM To: Multiple recipients of list ORACLE-L Raj - I'm no expert on SNMP, so maybe someone that is more knowledgeable will reply. I believe that SNMP underlies most of the monitoring tools on the market today. OEM may even use SNMP. I can see two approaches for you. 1. You write your own tool that will issue SNMP alerts. Perhaps this would be a Unix daemon process that executes database queries, and then based on what it finds, issues SNMP alerts. 2. Use an existing tool to accomplish what you want. If your desire is to create a database monitoring tool that you can give away for free, then sell to CA for a lot of money, take path #1. If your goal is to become a better DBA, then I would go with #2. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] mailto:dwilliams;lifetouch.com mailto:dwilliams;lifetouch.com -Original Message- Sent: Wednesday, October 23, 2002 4:39 PM To: Multiple recipients of list ORACLE-L Has anyone implemented basic DB monitoring using snmp MIB information rather than running queries against the db? I am looking into this and have no clue or available docs on how to do this (esp on AIX). If someone can point me to the right direction, I would really appreciate that. TIA Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com http://www.fatcity.com San Diego, California-- Mailing list and web hosting services
RE: what is purify
but we did not download or install it. [EMAIL PROTECTED] 10/24/02 10:39:07 AM See:http://www.rational.com/products/purify_nt/index.jspI think this is what they are talking about.RFRobert G. Freeman - Oracle OCPOracle Database ArchitectCSX Midtier Database AdministrationAuthor of several Oracle books you can find on Amazon.com!Londo Mollari: Ah, arrogance and stupidity all in the same package. Howefficient of you. -Original Message-Sent: Thursday, October 24, 2002 8:54 AMTo: Multiple recipients of list ORACLE-LHave we had several cases where oracle.exe on NT during patching of OracleApps 11i gets a runaway thread. This thread is not known to Oracle - not inv$session. Even if shutdown database, still at 100%. Must halt the servicefor it to resolved.Oracle is theorizing backupexec from Veritas might be a problem - butdoesn't make sense since that service is always running.Now in a dump, Oracle see's something called purify and want us to disableit to see if that makes a difference.Never heard of purify - what is this??Jeffrey BeckstromDatabase AdministratorGreater Cleveland Regional Transit Authority1240 W. 6th StreetCleveland, Ohio 44113(216) 781-4204-- Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: Jeffrey Beckstrom INET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).--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.comSan Diego, California -- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
Activating batch file from a trigger on nt
Hello all How can I run startup.bat file when database is up. I tried using the HOST command in trigger but it does not work. Something like: 'host d:\oracle\scripts\startup.bat' in the trigger. Win2000, Oracle 8.1.7 or 9.2.0. Yechiel Adar Mehish -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: RMAN - It's Here
Even more interesting is that I never saw the original comment from Rachel... my email to/from Oracle-L seems to really be slow! Thanks Rachel. 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. -Original Message- Sent: Thursday, October 24, 2002 4:26 PM To: Multiple recipients of list ORACLE-L Rachel, Interesting, I never thought of it. I feel sorry for that if it is reducing royalty of Roberts, but my intention was different and to help others to reduce their cost of this book. Besides I am very much satisfied with the services/prices of bookpool.com Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Thu, 24 Oct 2002 11:43:09 -0800 because the author's royalties are based in part on what the book sells for? just doing my part to keep Robert's kids fed :) --- Mohammad Rafiq [EMAIL PROTECTED] wrote: Why pay more, Try www.bookpool.com Oracle9i RMAN Backup Recovery Freeman, et al / McGraw Hill / 2002 / 0072226625 Our Price $30.95 ~ You Save $19.04 (38% Off) Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Thu, 24 Oct 2002 09:48:55 -0800 Amazon.com, Oraclepressbooks.com, etc... 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. -Original Message- Sent: Thursday, October 24, 2002 11:09 AM To: Multiple recipients of list ORACLE-L Where? Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, October 24, 2002 4:44 PM Just a note that my new book Oracle9i RMAN Backup and Recovery (with co-author Matthew Hart) is out now! Enjoy! And remember, if you like it, I wrote it. If you don't like it.. hm let's see then Tim Gorman wrote it. RF 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. -Original Message- Sent: Thursday, October 24, 2002 9:55 AM To: Multiple recipients of list ORACLE-L MIB, hey I saw that movie too. ;o) -Original Message- Sent: Thursday, October 24, 2002 8:14 AM To: Multiple recipients of list ORACLE-L Oracle SNMP Support Reference Guide has the MIBs documented. That can be found under the Oracle Enterprise Manager docs. On Wed, Oct 23, 2002 at 03:19:22PM -0800, John Kanagaraj wrote: Kevin, This is great! Can we get a list of all the OIDs that Oracle uses? Can you also let the group know if any additional plug-ins are required for Perl to work with SNMP? John Kanagaraj Oracle Applications DBA DBSoft Inc (W): 408-970-7002 What would you see if you were allowed to look back at your life at the end of your journey in this earth? ** The opinions and statements above are entirely my own and not those of my employer or clients ** -Original Message- Sent: Wednesday, October 23, 2002 3:54 PM To: Multiple recipients of list ORACLE-L Yes. You can use PERL to do such things such as getting the database state, name, consistent gets, system block gets, etc from SNMP: #!/usr/local/bin/perl use BER; use SNMP_Session; use SNMP_util; use Getopt::Std; getopts(h:i:); my($host, $community, $response, $bindings, $binding, $value, @oid, @retvals); my $session; $host = $opt_h; $community = public; $db_index = $opt_i; # Database State $oid[0] = '.1.3.6.1.2.1.39.1.9.1.1.2.2'; #Database Name $oid[1] = '.1.3.6.1.2.1.39.1.7.1.4.' . $db_index . '.7.100.98.95.110.97.109.101.1'; # Consistent Block Gets $oid[2] = 'enterprises.111.4.1.1.1.2.' . $db_index; # System Block Gets $oid[3] = 'enterprises.111.4.1.1.1.4.' . $db_index; my @retvals = SNMP_util::snmpget ( $host, @oid ); -Original Message- Sent: Wednesday, October 23, 2002 5:20 PM To: Multiple recipients of list ORACLE-L Thanks Dennis, Gary I have tools at my disposal to monitor the db, and I have no problem with that. I was just reading through snmp and was intrigues by the idea that I could get some information without running scripts
simple ? question
Hi Listers, I am trying to find a way to know the schema name. Say, if I logged in as jjin01@ngd. When I run a program, how can I get the schema name which should be ngd? If I logged in as bkrasnof@pr, in this case, the schema name will be pr. Thanks in advance, Joan -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joan Hsieh INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Find Queries by a group of users
Johnson, Auditing, atleast in 8i, wont help. Maybe, if its not an overhead, you could have a logon trigger that enables tracing for those users. Raj Johnson PoovathummootTo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] til cc: joni_65@yahoSubject: Find Queries by a group of users o.com Sent by: root@fatcity. com October 24, 2002 04:57 PM Please respond to ORACLE-L Hi all, We were trying to find a way to get all queries by a group of users of the database. Auditing the users lets us know whether they ran a 'select' 'update' etc. but not the full text of the query. This is in 8i. 9i seems to have a view called DBA_FGA_AUDIT_TRAIL which has a SQL_TEXT column. Please advice. __ Do you Yahoo!? Y! Web Hosting - Let the expert host your web site http://webhosting.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Johnson Poovathummoottil INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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).
RMAN - It's Here
Just a note that my new book Oracle9i RMAN Backup and Recovery (with co-author Matthew Hart) is out now! Enjoy! And remember, if you like it, I wrote it. If you don't like it.. hm let's see then Tim Gorman wrote it. RF 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. -Original Message- Sent: Thursday, October 24, 2002 9:55 AM To: Multiple recipients of list ORACLE-L MIB, hey I saw that movie too. ;o) -Original Message- Sent: Thursday, October 24, 2002 8:14 AM To: Multiple recipients of list ORACLE-L Oracle SNMP Support Reference Guide has the MIBs documented. That can be found under the Oracle Enterprise Manager docs. On Wed, Oct 23, 2002 at 03:19:22PM -0800, John Kanagaraj wrote: Kevin, This is great! Can we get a list of all the OIDs that Oracle uses? Can you also let the group know if any additional plug-ins are required for Perl to work with SNMP? John Kanagaraj Oracle Applications DBA DBSoft Inc (W): 408-970-7002 What would you see if you were allowed to look back at your life at the end of your journey in this earth? ** The opinions and statements above are entirely my own and not those of my employer or clients ** -Original Message- Sent: Wednesday, October 23, 2002 3:54 PM To: Multiple recipients of list ORACLE-L Yes. You can use PERL to do such things such as getting the database state, name, consistent gets, system block gets, etc from SNMP: #!/usr/local/bin/perl use BER; use SNMP_Session; use SNMP_util; use Getopt::Std; getopts(h:i:); my($host, $community, $response, $bindings, $binding, $value, @oid, @retvals); my $session; $host = $opt_h; $community = public; $db_index = $opt_i; # Database State $oid[0] = '.1.3.6.1.2.1.39.1.9.1.1.2.2'; #Database Name $oid[1] = '.1.3.6.1.2.1.39.1.7.1.4.' . $db_index . '.7.100.98.95.110.97.109.101.1'; # Consistent Block Gets $oid[2] = 'enterprises.111.4.1.1.1.2.' . $db_index; # System Block Gets $oid[3] = 'enterprises.111.4.1.1.1.4.' . $db_index; my @retvals = SNMP_util::snmpget ( $host, @oid ); -Original Message- Sent: Wednesday, October 23, 2002 5:20 PM To: Multiple recipients of list ORACLE-L Thanks Dennis, Gary I have tools at my disposal to monitor the db, and I have no problem with that. I was just reading through snmp and was intrigues by the idea that I could get some information without running scripts through sqlplus interface and if so how to accomplish that. I know it is doable because IA does that, just wondering if it would be feasible to do it be some scripting ... Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! -Original Message- mailto:DWILLIAMS;LIFETOUCH.COM ] Sent: Wednesday, October 23, 2002 6:04 PM To: Multiple recipients of list ORACLE-L Raj - I'm no expert on SNMP, so maybe someone that is more knowledgeable will reply. I believe that SNMP underlies most of the monitoring tools on the market today. OEM may even use SNMP. I can see two approaches for you. 1. You write your own tool that will issue SNMP alerts. Perhaps this would be a Unix daemon process that executes database queries, and then based on what it finds, issues SNMP alerts. 2. Use an existing tool to accomplish what you want. If your desire is to create a database monitoring tool that you can give away for free, then sell to CA for a lot of money, take path #1. If your goal is to become a better DBA, then I would go with #2. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] mailto:dwilliams;lifetouch.com mailto:dwilliams;lifetouch.com -Original Message- Sent: Wednesday, October 23, 2002 4:39 PM To: Multiple recipients of list ORACLE-L Has anyone implemented basic DB monitoring using snmp MIB information rather than running queries against the db? I am looking into this and have no clue or available docs on how to do this (esp on AIX). If someone can point me to the right direction, I would really appreciate that. TIA Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com http://www.orafaq.com -- Author: DENNIS
Flat file generation integrity ideas...
Title: Flat file generation integrity ideas... I have to create packages that will generate several flat files of data from tables that will be sent to other systems to be processed. I am looking for ideas on how to ensure data integrity in the flat files. For example, the expected record count is stored on the first line of the file to ensure that the correct amount of records was received. The systems group is chartered to ensure the flat files are correctly FTPed between systems, so that's covered. I just worry that if somehow a flat file is scrambled then the scrambled data is loaded into the database, therefore corrupting it. At this phase, XML is not an option I keep thinking that some sort of CRC should be stored with each line in the flat file. And then before the line is loaded into the database, the CRC is compared against the generated CRC of the just read line. Has anyone done anything like this? Any examples out there? Many TIA!!
Re: Activating batch file from a trigger on nt
I solved the problem by: Call a Java function that sends the command to a service that activate the command as a process in NT. This was written by another of my team and can send the command to any computer on the NT network. I think that Joe asked about open window when applying archive logs to a standby database. Maybe this method can work for you. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, October 24, 2002 6:58 PM Could you use an external procedure or java call? Metalink Tom Kyte's book have good examples. -Original Message- Sent: Thursday, October 24, 2002 9:29 AM To: Multiple recipients of list ORACLE-L Hello all How can I run startup.bat file when database is up. I tried using the HOST command in trigger but it does not work. Something like: 'host d:\oracle\scripts\startup.bat' in the trigger. Win2000, Oracle 8.1.7 or 9.2.0. Yechiel Adar Mehish -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Fink, Dan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
db_writer_processes/db_block_lru_latches
I read in Note:97291.1 that db_writer_processes/db_block_lru_latches could be set to match the number of cpus to try to impove db file parallel write waits. Are seperate controllers required for this to be effective? Any good refs on this topic. === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Trivia question - not of any practical use.
I don't get that when running on W2K. Are you executing a login.sql or glogin.sql script first? How are you invoking your temp.sql? Using the @ on the command line or redirecting input or typing it in directly? What version of sqlplus? I tried it with 8.1.6. Marc Perkowitz - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, October 24, 2002 11:24 AM Dear Listers, Given below is a script that I execute from within SQL*Plus for WinNT: temp.sql: - set echo off set pagesize 0 set feedback off SELECT * FROM tab WHERE ROWNUM 10; set pagesize 1000 set feedback on set echo on - While running it always displays 'SQLset echo off' before muffling the echo. Is there any way to stop this line from appearing? I vaguely remember that in some language you could put @ in front of the 'set echo off' command to suppress it. Is there something similar possible. TIA. Regards, Charu. -Original Message- Sent: Thursday, October 24, 2002 12:26 PM To: Multiple recipients of list ORACLE-L the firewall should use sqlnet proxy. most firewalls support it and if this one doesn't scrap it! only the initial connection is made on port 1521. [EMAIL PROTECTED] 10/24/02 05:44AM we had the same problem and we found that oracle use the standard port only to make the initial connection. All the traffic after that is done on different ports. So you need to open the range that oracle use in the firewall. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, October 24, 2002 8:13 AM Environment: Oracle 8.1.6 AIX server behind a firewall db is accessed by a Windows application running on a IIS web server sitting outside the firewall db uses port 1521 After a flurry of email between the Unix admin and the 4 software vendors concerned, all the fingers are now pointing at that damn oracle database. The Unix admin is asking two questions: 1) what Oracle is doing with the four ports 20,000 - 20,003 2) can he shut them down? Any ideas are appreciated. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Don INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gene Sais INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). * Disclaimer This message (including any attachments) contains confidential information intended for a specific individual and purpose, and is protected by law. If you are not the intended recipient, you should delete this message and are hereby notified that any disclosure, copying, or distribution of this message, or the taking of any action based on it, is strictly prohibited. * Visit us at http://www.mahindrabt.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Charu Joshi INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services
PDBA toolkit (from Perl for Oracle DBAs) question
Maybe someone beside the author can answer this question: I'm confused about how to connect to a database using Jared's PDBA toolkit. The various utilities specify command-line options -machine and -database. There's a PDBA::CM connection manager module that can be used to specify environment variables such as ORACLE_HOME. But nowhere do I see how to use a SQL*Net connect string: I have PDBA installed on my PC, and I want to connect to databases on Unix servers; the service name resolution is provided by Oracle Names. What am I missing? Thanks, Paul Baumgartel __ Do you Yahoo!? Y! Web Hosting - Let the expert host your web site http://webhosting.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Baumgartel INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: RMAN - It's Here
because the author's royalties are based in part on what the book sells for? just doing my part to keep Robert's kids fed :) --- Mohammad Rafiq [EMAIL PROTECTED] wrote: Why pay more, Try www.bookpool.com Oracle9i RMAN Backup Recovery Freeman, et al / McGraw Hill / 2002 / 0072226625 Our Price $30.95 ~ You Save $19.04 (38% Off) Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Thu, 24 Oct 2002 09:48:55 -0800 Amazon.com, Oraclepressbooks.com, etc... 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. -Original Message- Sent: Thursday, October 24, 2002 11:09 AM To: Multiple recipients of list ORACLE-L Where? Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, October 24, 2002 4:44 PM Just a note that my new book Oracle9i RMAN Backup and Recovery (with co-author Matthew Hart) is out now! Enjoy! And remember, if you like it, I wrote it. If you don't like it.. hm let's see then Tim Gorman wrote it. RF 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. -Original Message- Sent: Thursday, October 24, 2002 9:55 AM To: Multiple recipients of list ORACLE-L MIB, hey I saw that movie too. ;o) -Original Message- Sent: Thursday, October 24, 2002 8:14 AM To: Multiple recipients of list ORACLE-L Oracle SNMP Support Reference Guide has the MIBs documented. That can be found under the Oracle Enterprise Manager docs. On Wed, Oct 23, 2002 at 03:19:22PM -0800, John Kanagaraj wrote: Kevin, This is great! Can we get a list of all the OIDs that Oracle uses? Can you also let the group know if any additional plug-ins are required for Perl to work with SNMP? John Kanagaraj Oracle Applications DBA DBSoft Inc (W): 408-970-7002 What would you see if you were allowed to look back at your life at the end of your journey in this earth? ** The opinions and statements above are entirely my own and not those of my employer or clients ** -Original Message- Sent: Wednesday, October 23, 2002 3:54 PM To: Multiple recipients of list ORACLE-L Yes. You can use PERL to do such things such as getting the database state, name, consistent gets, system block gets, etc from SNMP: #!/usr/local/bin/perl use BER; use SNMP_Session; use SNMP_util; use Getopt::Std; getopts(h:i:); my($host, $community, $response, $bindings, $binding, $value, @oid, @retvals); my $session; $host = $opt_h; $community = public; $db_index = $opt_i; # Database State $oid[0] = '.1.3.6.1.2.1.39.1.9.1.1.2.2'; #Database Name $oid[1] = '.1.3.6.1.2.1.39.1.7.1.4.' . $db_index . '.7.100.98.95.110.97.109.101.1'; # Consistent Block Gets $oid[2] = 'enterprises.111.4.1.1.1.2.' . $db_index; # System Block Gets $oid[3] = 'enterprises.111.4.1.1.1.4.' . $db_index; my @retvals = SNMP_util::snmpget ( $host, @oid ); -Original Message- Sent: Wednesday, October 23, 2002 5:20 PM To: Multiple recipients of list ORACLE-L Thanks Dennis, Gary I have tools at my disposal to monitor the db, and I have no problem with that. I was just reading through snmp and was intrigues by the idea that I could get some information without running scripts through sqlplus interface and if so how to accomplish that. I know it is doable because IA does that, just wondering if it would be feasible to do it be some scripting ... Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! -Original Message- mailto:DWILLIAMS;LIFETOUCH.COM ] Sent: Wednesday, October 23, 2002 6:04 PM To: Multiple recipients of list ORACLE-L Raj - I'm no expert on SNMP, so maybe someone that is more knowledgeable will reply. I believe that SNMP underlies most of the monitoring tools === message truncated === __ Do you Yahoo!? Y! Web Hosting - Let the expert host your web site http://webhosting.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com --
Re: LOCALLY MANAGED TABLESPACE LOCALLY MANAGED TABLESPACE LOCALLY MANAGED TABLESPACE LOCALLY MANAGED TABLESPACE
Why do you always SHOUT in your subject line? Or are you not aware of simple net-etiquettes? - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, October 24, 2002 2:49 PM Hi I am thinking to change our few dictinary manages tablespace to locally managed tablespace.Can any one experienced any issues with locally managed tablespace? Do any one experience what gain after changing to locally managed tablespace? Thx -Seema _ Unlimited Internet access for only $21.95/month. Try MSN! http://resourcecenter.msn.com/access/plans/2monthsfree.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seema Singh INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachna Vaidya INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Flat file generation integrity ideas...
Title: Message Yes, Melissa also mentioned this to me. I will have to look into that function...along withthe million other procedures and functions that Oracle has. At this point, Tom's suggestion seems to be the simpliest/effective/fastest. Any other suggestions? -Original Message-From: Jamadagni, Rajendra [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 24, 2002 2:46 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Flat file generation integrity ideas... you could also use dbms_utility.get_hash_value ... to compute hash value for the whole row and store that as an additional column. Be syre to use the same parameters on both sides to compute and test, else it will fail the check. Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art!
RE: System Tablespace and Autoextend
I run my SYSTEM tablesaces in autoextend, and have for some time. I run them that way from the point of database creation and have never had a problem. There were some problems with autoextend in earlier versions of 8 (and I think they managed to migrate to early 8i versions as well) with 2GB boundaries, but those have all been corrected. RF 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. -Original Message- Sent: Thursday, October 24, 2002 4:46 PM To: Multiple recipients of list ORACLE-L Sam - I haven't made the system tablespace autoextend because I can't easily recover the space if it overextends. I would rather take the risk that something hits an error from a lack of space in the system tablespace. With other tablespaces you can always rebuild the tablespace if you need to. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, October 24, 2002 1:27 PM To: Multiple recipients of list ORACLE-L Hello All, I have heard several times that if the SYSTEM tablespace runs out of space and needs to autoextend (assuming autoextend is turned on for the data file), then you run the risk of the database crashing and of data dictionary corruption. I have never personally encountered this problem, so I have no experience on what actually does happen. I looked in metalink for documents on this, but turned up nothing. Does anybody have experience on the dangers of allowing the SYSTEM tablespace to autoextend and also any documents on Metalink or OTN that describe this problem? We are running Oracle versions 7.3.4, 8.0.5, 8.1.7, and 9.2. All our Oracle versions are running on Windows NT (or Windows 2000). Thanks for any feedback. Sam Bootsma, OCP [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sam Bootsma INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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).
System Tablespace and Autoextend
Hello All, I have heard several times that if the SYSTEM tablespace runs out of space and needs to autoextend (assuming autoextend is turned on for the data file), then you run the risk of the database crashing and of data dictionary corruption. I have never personally encountered this problem, so I have no experience on what actually does happen. I looked in metalink for documents on this, but turned up nothing. Does anybody have experience on the dangers of allowing the SYSTEM tablespace to autoextend and also any documents on Metalink or OTN that describe this problem? We are running Oracle versions 7.3.4, 8.0.5, 8.1.7, and 9.2. All our Oracle versions are running on Windows NT (or Windows 2000). Thanks for any feedback. Sam Bootsma, OCP [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sam Bootsma INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Flat file generation integrity ideas...
Title: RE: Flat file generation integrity ideas... you could also use dbms_utility.get_hash_value ... to compute hash value for the whole row and store that as an additional column. Be syre to use the same parameters on both sides to compute and test, else it will fail the check. Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! *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: QUERY?
Hi, What error are you getting? Just saying 'not running in production' doesn't give any clue to answer. Regards, Sandeep -Original Message- Sent: Thursday, October 24, 2002 12:40 PM To: Multiple recipients of list ORACLE-L Hi Can some one suggest whats wrong in this query?The same query run fine on development db but not running on production? select count(a.xxx_id) from gorp_cats_stats_view a , static_pages b where b.xxx_id = a.xxx_id andb.words like '%test%' anda.main not like '%test%' anda.url not like '%test%' order by a.url Thx -Seema _ 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.com -- Author: Seema Singh INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sandeep Dubey INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: QUERY?
Different data? Missing indexes? What do you mean Something's Wrong? Tom Mercadante Oracle Certified Professional -Original Message- Sent: Thursday, October 24, 2002 12:40 PM To: Multiple recipients of list ORACLE-L Hi Can some one suggest whats wrong in this query?The same query run fine on development db but not running on production? select count(a.xxx_id) from gorp_cats_stats_view a , static_pages b where b.xxx_id = a.xxx_id andb.words like '%test%' anda.main not like '%test%' anda.url not like '%test%' order by a.url Thx -Seema _ 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.com -- Author: Seema Singh INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: RMAN - It's Here
Amazon.com, Oraclepressbooks.com, etc... 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. -Original Message- Sent: Thursday, October 24, 2002 11:09 AM To: Multiple recipients of list ORACLE-L Where? Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, October 24, 2002 4:44 PM Just a note that my new book Oracle9i RMAN Backup and Recovery (with co-author Matthew Hart) is out now! Enjoy! And remember, if you like it, I wrote it. If you don't like it.. hm let's see then Tim Gorman wrote it. RF 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. -Original Message- Sent: Thursday, October 24, 2002 9:55 AM To: Multiple recipients of list ORACLE-L MIB, hey I saw that movie too. ;o) -Original Message- Sent: Thursday, October 24, 2002 8:14 AM To: Multiple recipients of list ORACLE-L Oracle SNMP Support Reference Guide has the MIBs documented. That can be found under the Oracle Enterprise Manager docs. On Wed, Oct 23, 2002 at 03:19:22PM -0800, John Kanagaraj wrote: Kevin, This is great! Can we get a list of all the OIDs that Oracle uses? Can you also let the group know if any additional plug-ins are required for Perl to work with SNMP? John Kanagaraj Oracle Applications DBA DBSoft Inc (W): 408-970-7002 What would you see if you were allowed to look back at your life at the end of your journey in this earth? ** The opinions and statements above are entirely my own and not those of my employer or clients ** -Original Message- Sent: Wednesday, October 23, 2002 3:54 PM To: Multiple recipients of list ORACLE-L Yes. You can use PERL to do such things such as getting the database state, name, consistent gets, system block gets, etc from SNMP: #!/usr/local/bin/perl use BER; use SNMP_Session; use SNMP_util; use Getopt::Std; getopts(h:i:); my($host, $community, $response, $bindings, $binding, $value, @oid, @retvals); my $session; $host = $opt_h; $community = public; $db_index = $opt_i; # Database State $oid[0] = '.1.3.6.1.2.1.39.1.9.1.1.2.2'; #Database Name $oid[1] = '.1.3.6.1.2.1.39.1.7.1.4.' . $db_index . '.7.100.98.95.110.97.109.101.1'; # Consistent Block Gets $oid[2] = 'enterprises.111.4.1.1.1.2.' . $db_index; # System Block Gets $oid[3] = 'enterprises.111.4.1.1.1.4.' . $db_index; my @retvals = SNMP_util::snmpget ( $host, @oid ); -Original Message- Sent: Wednesday, October 23, 2002 5:20 PM To: Multiple recipients of list ORACLE-L Thanks Dennis, Gary I have tools at my disposal to monitor the db, and I have no problem with that. I was just reading through snmp and was intrigues by the idea that I could get some information without running scripts through sqlplus interface and if so how to accomplish that. I know it is doable because IA does that, just wondering if it would be feasible to do it be some scripting ... Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! -Original Message- mailto:DWILLIAMS;LIFETOUCH.COM ] Sent: Wednesday, October 23, 2002 6:04 PM To: Multiple recipients of list ORACLE-L Raj - I'm no expert on SNMP, so maybe someone that is more knowledgeable will reply. I believe that SNMP underlies most of the monitoring tools on the market today. OEM may even use SNMP. I can see two approaches for you. 1. You write your own tool that will issue SNMP alerts. Perhaps this would be a Unix daemon process that executes database queries, and then based on what it finds, issues SNMP alerts. 2. Use an existing tool to accomplish what you want. If your desire is to create a database monitoring tool that you can give away for free, then sell to CA for a lot of money, take path #1. If your goal is to become a better DBA, then I would go with #2. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] mailto:dwilliams;lifetouch.com mailto:dwilliams;lifetouch.com -Original Message- Sent: Wednesday, October 23, 2002 4:39 PM To: Multiple recipients of list ORACLE-L Has anyone implemented basic DB monitoring using snmp MIB information rather than running queries against the db? I am looking into this and have no clue or available docs on how to do this (esp on AIX). If someone can point me to the
Re:RE: oracle or mssql
As I said, use mssql ONLY if your boss is willing to be strapped into a MicroSlop only platform. If he's even remotely thinking of using a different OS then you can't use mssql. Dick Goulet Reply Separator Author: [EMAIL PROTECTED] Date: 10/23/2002 11:48 PM goodmorning everybody who responded to my basic question : thanks summary professional : use oracle enterprise edition semi professional : use oracle standard edition / mssql enterprise edition in all other cases mssql standard edition -Oorspronkelijk bericht- Van: Mohammad Rafiq [SMTP:[EMAIL PROTECTED]] Verzonden:woensdag 23 oktober 2002 20:51 Aan: Multiple recipients of list ORACLE-L Onderwerp:RE: oracle or mssql Xenix is history now...SCO itself stopped it sometime in 1990 Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Wed, 23 Oct 2002 09:02:19 -0800 XENIX maybe. : ) 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] -Original Message- Sent: Wednesday, October 23, 2002 12:59 PM To: Multiple recipients of list ORACLE-L Is MSSQL server available on UNIX? -Rachna -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Get faster connections -- switch to MSN Internet Access! http://resourcecenter.msn.com/access/plans/default.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohammad Rafiq INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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). -- 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: secure connection
Sorry for the mistake. the question was wrong. :( The right question should be : How can I secure the connection between our web server and Oracle Server? Is there any chance to solve this issue with Oracle related solutions or should I use IPsec or smth like that about network security. Murat Kevin Lange [EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: RE: secure connection 10/24/2002 06:53 PM Please respond to ORACLE-L These days . just hire a 15 year old kid with a computer at home He might do beter than an expensive 'security firm' ... -Original Message- Sent: Thursday, October 24, 2002 10:09 AM To: Multiple recipients of list ORACLE-L Hire a special company that handle this. We are doing it to see how unbreakable are our servers. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, October 24, 2002 2:08 PM Hi, how can I be sure that the connection between our web server and Oracle Server to be secure. What's the best method to accomplish this? Any good links for Oracle Nwtwork Security. Any help would be greatly appreciated. Murat -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: MURAT BALKAS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Lange INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: MURAT BALKAS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego,
RE: secure connection
These days . just hire a 15 year old kid with a computer at home He might do beter than an expensive 'security firm' ... -Original Message- Sent: Thursday, October 24, 2002 10:09 AM To: Multiple recipients of list ORACLE-L Hire a special company that handle this. We are doing it to see how unbreakable are our servers. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, October 24, 2002 2:08 PM Hi, how can I be sure that the connection between our web server and Oracle Server to be secure. What's the best method to accomplish this? Any good links for Oracle Nwtwork Security. Any help would be greatly appreciated. Murat -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: MURAT BALKAS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Lange INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).