RE: tnsnames.ora not working ?
Are you using Oracle Services? I've seen this happen before and we change SERVICE_NAME to SID and everything works fine. Scott Canaan ([EMAIL PROTECTED]) (585) 475-7886 Life is like a sewer, what you get out of it depends on what you put into it. - Tom Lehrer. -Original Message- Reuben D. Budiardja Sent: Tuesday, January 20, 2004 10:49 AM To: Multiple recipients of list ORACLE-L Hello, I'm trying to add description in my $ORACLE_HOME/network/admin/tnsnames.ora, but it seems that the client (ie. sqlplus) wont use it. Whenever I try to connect to the service using sqlplus, I got : $ sqlplus Enter user-name: [EMAIL PROTECTED] Enter password: * ORA-12154: TNS:could not resolve service name I tried to add the description to my ~/.tnsnames.ora too with no luck. The entry in the tnsnames.ora is: DEV_DB = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = hostname)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = dev_db) ) ) (note: I removed the real hostname for privacy/security reason of course) However, when I use sqlplus using the following way: $ sqlplus Enter user-name: developer@(description=(address=(protocol=tcp)(host=hostname)(PORT = 1521))(CONNECT_DATA =(SERVICE_NAME = dev_db))) Enter password: * It would work, where all the information from the description is just a copy-paste from the tnsnames.ora file. Is there anything I overlook? Sorry if this is kinda a newbie question. I'm still learning my way around this. I'm using Oracle9i on Redhat Linux. Thanks for any help. Reuben D. Budiardja -- Reuben D. Budiardja Department of Physics and Astronomy The University of Tennessee, Knoxville, TN - To be a nemesis, you have to actively try to destroy something, don't you? Really, I'm not out to destroy Microsoft. That will just be a completely unintentional side effect. - Linus Torvalds - -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Reuben D. Budiardja INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Scott Canaan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Cold Fusion and Bind Variables
Jared, Try this link. It still worked for me this morning. http://www.macromedia.com/devnet/server_archive/articles/cfqueryparam_oracle_databases.html Scott [EMAIL PROTECTED] 1/12/04 8:49:25 PM Dear List, We have a developer here that is pretty good with the web stuff, but his strong suit is not databases, or at least not Oracle. He develops primarily in Cold Fusion, which I know little about. I'm trying to teach him the difference between literal and bind variables, and the importance of knowing the difference. While it is easy to demonstrate this in PL/SQL or Perl, I have no idea how to do so in CF. A few minutes of googling didn't really turn up anything useful. I'm looking for some examples of using bind variables in SQL as used in Cold Fusion that connects to Oracle 8i. If you have one, the virtual beer is on me. :) Jared
RE: Risk of knowing password hash value (Was: OEM permissions)
This is what I got, Oracle 8.1.7.4 on Sun Solaris (I dropped the user): Connected to: Oracle8i Enterprise Edition Release 8.1.7.4.0 - Production With the Partitioning option JServer Release 8.1.7.4.0 - Production SQL create user scott identified by tiger; User created. SQL select password 2 from dba_users 3 where username = 'SCOTT'; PASSWORD -- F894844C34402B67 SQL Scott Canaan ([EMAIL PROTECTED]) (585) 475-7886 Life is like a sewer, what you get out of it depends on what you put into it. - Tom Lehrer. -Original Message- rahul sharma Sent: Tuesday, December 23, 2003 1:14 AM To: Multiple recipients of list ORACLE-L 8.1.7 on win2000 SQL select password 2 from dba_users 3 where username = 'SCOTT'; PASSWORD -- F894844C34402B67 - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, December 23, 2003 11:44 AM Hi, Okay. I'm almost a believer of this as a problem. How about 9.2.0.4 on RH9.3. 1) What does anyone/everyone get for my this query (my results shown): connect system/[EMAIL PROTECTED]; alter user scott identified by tiger; -- select password from dba_users where username = 'SCOTT'; PASSWORD F894844C34402B67 2) If you all get the same, then I'm concerned. Regards, Mike Thomas --- Yong Huang [EMAIL PROTECTED] wrote: Jared, I see you log out and log back in as SYSTEM to DB2. But how do you know the password for SYSTEM to log back in with after you change it? What if you don't log out? When I tried that (i.e. not logging out), I got ORA-1017. Yong Huang --- Jared Still [EMAIL PROTECTED] wrote: Environment: DB1: RH 8.0 with Oracle EE 9.2.0.4 DB2: Win2k SP3 with Oracle EE 9.2.0.1 SYSTEM user on each database initially have different passwords. __ Do you Yahoo!? Protect your identity with Yahoo! Mail AddressGuard http://antispam.yahoo.com/whatsnewfree -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Michael Thomas INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: rahul sharma INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Scott Canaan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Re: Little competition
Hey Richard, One of my desktop treasures is an autographed copy of Jonathan Lewis' book, Practical Oracle8i. The humorous, self-deprecating caption in the author's own hand: 'Never believe all you read.' Scott [EMAIL PROTECTED] 12/12/03 7:24:24 AM Hi Jonathan,SQL create tablespace bowie_test 2 datafile 'c:/bowie/bowie_test01.dbf' size 100m 3 extent management local uniform size 1m 4 segment space management auto;Tablespace created.SQL create table bowie_assm (ziggy number) 2 tablespace bowie_test 3 storage (initial 1m next 2m pctincrease 100 minextents 3);Table created.SQL select owner, segment_name, blocks from dba_extents 2 where segment_name = 'BOWIE_ASSM';OWNER SEGMENT_NAME BLOCKS-- --BOWIE BOWIE_ASSM 128BOWIE BOWIE_ASSM 128BOWIE BOWIE_ASSM 128BOWIE BOWIE_ASSM 128BOWIE BOWIE_ASSM 128BOWIE BOWIE_ASSM 128BOWIE BOWIE_ASSM 1287 rows selected.3 minextents = 1 initial + 2 next + (2 next + (2 * 1.0 pctincrease) = 7 * 1MextentsIt's actually quite a common misconception that NEXT, PCTINCREASE andMINEXTENTS are ignored for locally managed tablespaces when in fact they'reused to determine the initial size of the object and hence the number ofextents initially allocated.This was all a bit of fun but I think it did prove my little (mischievous)point. That it's really quite easy to base ones belief and certainty on a"fact" that turns out to be totally false because the basis on why youbelieve something also turns out to be false. On the surface it appeared tobe quite a reasonable conclusion, that pctfree is not permitted with ASSMobjects because the "evidence" strongly supported such a claim.Unfortunately the evidence was somewhat erroneous in that it stupidly reliedon incorrect syntax and so an incorrect conclusion resulted. This incorrectconclusion can then result in inappropriate behaviour and curses from DBAsas they experience all these "unavoidable" migrated rows. Before you knowit, other Oracle myth is born ...Of course everyone makes mistakes but to publish them does come with it'sown set of responsibilities. I can't stress enough that one be careful of"what" you read and be careful of "who" you read.The truth IS out there ;)CheersRichard quote This could be a serious issue for the Oracle professional unless they remember that locally-managed tablespaces with automatic space management ignore any specified values for NEXT and FREELISTS. end quote There is another error here. For a bonus 10 points can anyone spot it ? Hint - try the following in a tablespace which is locallally managed, with automatic space management, and either system managed or uniform sized extents of no more than 1 M. create table test2(n1 number) storage (initial 1M next 2M pctincrease 100 minextents 3); Regards Jonathan Lewis-- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: Richard Foote 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).
RE: Misbehaving query
That's what I was thinking, too. I tried it on 8.1.7.4 and it works the same way, as I expected. You would need an outer join to get something back. Scott Canaan ([EMAIL PROTECTED]) (585) 475-7886 Life is like a sewer, what you get out of it depends on what you put into it. - Tom Lehrer. -Original Message- Carol Bristow Sent: Friday, December 12, 2003 3:44 PM To: Multiple recipients of list ORACLE-L Junk minus junk2 results in no rows, and when you do the implied cartesian join between view a and view b, joining no rows with one row gives no rows. Makes sense to me. Carol Bristow DPRA Inc. 1300 N 17th St Suite 950 Rosslyn, VA 22209 Work: 703-841-8025 Fax: 703-524-9415 -Original Message- Sent: Friday, December 12, 2003 3:05 PM To: Multiple recipients of list ORACLE-L Hi! I have a query that I think is behaving oddly; and, it may just be that I'm blind and am doing something silly (*there's* a first!), or it may be environment specific, but, I'm thinkin it may just be a bug. I have filed a TAR with Oracle, and they keep sending workarounds, when I told them from the start that I've got one, this is only a question of why this query isn't working. So, two parts, really... is this query really not working, and if so, does anyone have a clue as to why? We're on 9.2.0.2 on SunOS. The overall issue is easy. I have two tables. I want to find the difference in the contents. This is easily accomplished by doing A MINUS B UNION B MINUS A *That's* not the issue. The issue is that if I do this through inlines, the query fails. I'll put everything out there so you can just cut and paste iffen you wanna... SQL create table junk (test char(1)); Table created. SQL insert into junk values ('A'); 1 row created. SQL insert into junk values ('B'); 1 row created. SQL insert into junk values ('C'); 1 row created. SQL create table junk2 as select * from junk; Table created. SQL insert into junk2 values ('X'); 1 row created. SQL select * from junk; T - A B C SQL select * from junk2; T - A B C X SQL select * from junk minus select * from junk2 2 union 3 select * from junk2 minus select * from junk; T - X SQL select a.* 2 from 3 ( select * from junk2 minus select * from junk ) a; T - X SQL select a.*, b.* 2 from 3 ( select * from junk2 minus select * from junk ) a, 4 ( select * from junk2 minus select * from junk ) b; T T - - X X SQL select a.*, b.* 2 from 3 ( select * from junk minus select * from junk2 ) a, 4 ( select * from junk2 minus select * from junk ) b; no rows selected Anyone? Bambi. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bellow, Bambi INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Carol Bristow INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Scott Canaan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 oracle rdb?
list lurker off Same opinion here, my company is in the process of migrating our software to run on Oracle 9iR2. Currently, we have over 325 production sites that have RDB databases running. RDB is a single schema database so each customer site has multiple databases running. Very easy to manage, backup and yes recover. RDB has always had the cost based optimizer. Logminer has been around for a long time and the backup utility (RMU) supposedly has links to RMAN. As with everything Digital, great technology, crappy marketing, sold to someone who wants the technologies. If it weren't limited to the VMS platform (no flames, I love VMS) it would have a much bigger installation base. Back to the grind...(What was that Unix/Oracle command to...) /list lurker on Scott Graves Sr. Systems Programmer NISC RDQ-STP Email: [EMAIL PROTECTED] Phone: 636-922-9122 x7616 Fax: 636-922-2080 -Original Message- Jonathan Gennick Sent: Monday, November 24, 2003 6:59 PM To: Multiple recipients of list ORACLE-L Monday, November 24, 2003, 3:49:26 PM, [EMAIL PROTECTED] ([EMAIL PROTECTED]) wrote: rcn I see it referred to on metalink alot. I know its seperate from the rdbms. Rdb was the database I cut my teeth on. So easy to use. As I recall, you could create a database with just the following: CREATE DATABASE; Everything, including the database name, would default. It was great, especially for learning on. Digital's online help was unsurpassed too. I learned a lot from that, and from their Rdb manual set. All Rdb's commands worked consistently and logically, and everything was so orthogonal. Heck, if you wanted to see what a table looked like, you just issued commands such as: SHOW TABLE SHOW TABLE /CONSTRAINTS (to see constraints too) SHOW TABLE /INDEXES /CONSTRAINTS SHOW TABLE /ALL (to see everything) I recall beginning my database education by tying HELP RDB at the operating system, and then progressing from there. Typing HELP from within RDB's interactive-SQL utility was sheer joy. One of the first things I did when I made the move to Oracle was to fire up SQL*Plus and issue the SHOW TABLE command to see the structure of a table I was trying to insert into. I was baffled that there was no such command. HELP SHOW didn't help much either, because I discovered that SHOW seemed to show a whole bunch of things I didn't care about and nothing that I did care about. I was even more astounded when I discovered DISPLAY, which didn't, and still doesn't, even begin to give you the information you needed in order to be able to get work done with a table. It took me over a day, as I recall, before I managed to find someone who could show me how to look at constraints on a table. I'd heard all these great and wonderful things about Oracle, that it was *the* database to learn. Well, from a career standpoint that's probably true, Oracle was the database to learn, but certainly not from a usability standpoint. Best regards, Jonathan Gennick --- Brighten the corner where you are http://Gennick.com * 906.387.1698 * mailto:[EMAIL PROTECTED] Join the Oracle-article list and receive one article on Oracle technologies per month by email. To join, visit http://four.pairlist.net/mailman/listinfo/oracle-article, or send email to [EMAIL PROTECTED] and include the word subscribe in either the subject or body. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jonathan Gennick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Scott Graves INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 10g Migration
According to the presentation by Dave Foster of Oracle at the last UNYOUG meeting, there will be a direct upgrade from 8.1.7 and 9.2. Also, the new dbassistant has an undo feature, to rollback the upgrade. Scott Canaan ([EMAIL PROTECTED]) (585) 475-7886 Life is like a sewer, what you get out of it depends on what you put into it. - Tom Lehrer. -Original Message- Sent: Friday, November 21, 2003 9:49 AM To: Multiple recipients of list ORACLE-L Mladen, Direct 8i(as in 8.1.7.4) to 10 or do you HAVE to go through 9.x first? Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Friday, November 21, 2003 9:39 AM To: Multiple recipients of list ORACLE-L Yes. On 11/21/2003 09:29:31 AM, Tracy Rahmlow wrote: Does anybody know whether or not Oracle will support and upgrade of an 8i database to 10? Thanks American Express made the following annotations on 11/21/2003 07:28:27 AM -- ** This message and any attachments are solely for the intended recipient and may contain confidential or privileged information. If you are not the intended recipient, any disclosure, copying, use, or distribution of the information included in this message and any attachments is prohibited. If you have received this communication in error, please notify us by reply e-mail and immediately and permanently delete this message and any attachments. Thank you. ** == Mladen Gogala Oracle DBA Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Goulet, Dick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Scott Canaan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: New Virus alert from paypal
Since, I believe, Paypal is owned by eBay, has any that's received this sent a message to safeharbor? I would think they should be made aware of it. Scott Canaan ([EMAIL PROTECTED]) (585) 475-7886 Life is like a sewer, what you get out of it depends on what you put into it. - Tom Lehrer. -Original Message- Sent: Wednesday, November 19, 2003 10:40 AM To: Multiple recipients of list ORACLE-L List, Any one else get word of this new virus? Ron Mar-D Greer 11/19/2003 9:34:44 AM There is a new virus that has surfaced since last week. This virus reports that users need to update their PayPal accounts. Do not open this, delete the e-mail as PayPal has not issued this e-mail and the e-mail itself contains a virus. The actual e-mail reads as follows: (Found virus WORM_MIMAIL.J in file www.paypal.com.pif) ** Dear PayPal member, We regret to inform you that your account is about to be expired in next five business days. To avoid suspension of your account you have to reactivate it by providing us with your personal information. To update your personal profile and continue using PayPal services you have to run the attached application to this email. Just run it and follow the instructions. IMPORTANT! If you ignore this alert, your account will be suspended in next five business days and you will not be able to use PayPal anymore. Thank you for using PayPal. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Scott Canaan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Point-In-Time recovery question, Non-RMAN solution
Have you looked into using logminer? Even if it can't restore your table, it can give you the exact time that it was dropped. Scott Canaan ([EMAIL PROTECTED]) (585) 475-7886 Life is like a sewer, what you get out of it depends on what you put into it. - Tom Lehrer. -Original Message- Sent: Thursday, November 06, 2003 8:45 AM To: Multiple recipients of list ORACLE-L Hi DBAs, Oracle 8i, ArchiveLog, No RMAN Testing Point-In-Time Recovery I am confused on what time to substitute in the RECOVER DATABASE UNTIL TIME 'timestamp'; For example 2 days ago 11/04/2003 approximately 17:00 I drop a table. Today I decide I want that table back. I want to do an incomplete recovery to get the table back. How do I know what timestamp to use? I have an idea the I dropped the table but not exact. 1. SHUTDOWN Normal 2. BACKUP current database 3. Restore datafile that has the table in it. 4. connect internal 5. startup mount 6. recover database until time 'timestamp??'; 7. Alter database open resetlogs; 8. BACKUP current database Step 5 is my confusion. Also I assume all data is now lost since last archive restored to the present. The only way I know to get that data back is to 1. Export the table that was dropped. 2. Restore database from step2 3. Import table from step1 Is there better ways. Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Scott Canaan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: RE: dba interview questions
What do you need the stmt for? Just do: begin for a in (select username from dba_users where username not in ('SYS','SYSTEM',...)) loop execute immediate 'alter user '||a.username||' account lock'; end loop; end; / Scott Canaan ([EMAIL PROTECTED]) (585) 475-7886 Life is like a sewer, what you get out of it depends on what you put into it. - Tom Lehrer. -Original Message- Sent: Friday, October 24, 2003 2:00 PM To: Multiple recipients of list ORACLE-L Sure do, here's my favorite: You have a database with 3000 registered users, you need to lock all accounts except for a list of 20. How would you do it? Obviously there's several correct answers. But the one I'm looking for is the anonymous PL/SQL block defined like: declare stmt varchar2(200); begin for a in (select username from dba_users where username not in ('SYS','SYSTEM',...)) loop stmt := 'alter user '||a.username||' account lock'; execute immediate stmt; end loop; end; / Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Friday, October 24, 2003 12:00 PM To: Multiple recipients of list ORACLE-L do any of you ask dbas pl/sql questions? I think its important for DBAs to be good developers as well. especially if they are part of a development team. I dont think the skill sets should be seperate. they overlap. From: Jamadagni, Rajendra [EMAIL PROTECTED] Date: 2003/10/24 Fri AM 11:39:33 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: dba interview questions We prefer to ask their experiences and then throw a curve ball and ask them to defend it. Small issues like Why would/wouldn't an index help? etc ... Another question that I *always* ask is what do you or have you read in last 3 months outside of Oracle manuals? or Do you know any other sites that give you lot of oracle related information? I expect to hear at-least couple form following list ... ixora, hotsos, jlcomp, oracle-dba, oraperf, orapub. If they mention that they have read YAPP, that's a bonus too. But if someone says they haven't read anything other than manuals questions become a little steep. Raj -Original Message- Sent: Friday, October 24, 2003 9:49 AM To: Multiple recipients of list ORACLE-L The problem with such lists is that the prospects also have those... A few years ago Mike Ault published one. We used it to screen candidates via phone interviews. Two out of four I talked to gave me perfect answers: word to word from Mike's list. Use Conner's approach: Give the candidate a white/black board, and ask him/her to draw the SGA with all it interal structures, all background processes, and explain how all this works together. - Kirti ** This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you. **4 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jamadagni, Rajendra INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Goulet, Dick INET: [EMAIL
RE: Question about sql
How about: insert into table3(company_id,lev_id,vare_id) (select table2.company_id,lev_id,vare_id from table1, table2 where table1.company_id = table2.company_id); Scott Canaan ([EMAIL PROTECTED]) (585) 475-7886 Life is like a sewer, what you get out of it depends on what you put into it. - Tom Lehrer. -Original Message- Sent: Thursday, October 16, 2003 10:20 AM To: Multiple recipients of list ORACLE-L Hallo, Anyone whom could gíve me some good help on this. I have a table with one field, called Company_id Like this Company_id 16 45 50 In table 2 I have this field and values: Company_id Lev_idVare_id 16 45 56 34 10 20 67 10 20 45 15 30 50 12 12 I would like to from table 2 do a select and find the Company_ids from table1 and find out the responding lev_id and vare_id in table2and then insert them into a new table(table3) so it would look like this: Company_idLev_idVare_id 1645 56 Anyone whom could give me some help on this how to write the sql- query. I have tried with this sql query. What is wrong? insert into table3(company_id,lev_id,vare_id) select company_id,lev_id,vare_id from table2 where vare_id = 56 (where exists select company_id from table1) Thanks in advance Roland -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Scott Canaan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Basic question about controlfile recovery
Thankz Mladen Govindan. I do have Velpuri's book besides me. let me go thro' it once again. Regards, Scott. __ Do you Yahoo!? The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: scott INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: FIRST_ROWS hints
Did you remember to cut the db_file_multiblock_read_count in half, since you doubled the blocksize? I would assume that you also started seeing more full table scans, as well. Scott Canaan ([EMAIL PROTECTED]) (585) 475-7886 Life is like a sewer, what you get out of it depends on what you put into it. - Tom Lehrer. -Original Message- From: Sai Selvaganesan [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 08, 2003 2:54 PM To: Multiple recipients of list ORACLE-L Subject: FIRST_ROWS hints hi i had a migration from 9.2.0.3 to 9.2.0.4 of a database and here are a couple of observations. please help me inunderstanding this. i changed the db block size from 8k to 16k and all sql queires which were using nested loops earlier moved to sort merge joins. i ran 10053 and form whatever i could understand the 9204 db has fewer number of blocks compared to the existing 9203 (db size changed to 16k) and sort merge join turned out to be less costlier than nested loops (i couldntunderstand the sort statistics). no parameter other than db block size was changed. after breaking my head i changed the optimizer mode from choose to first rows and the query is back to the old explain plans. please clarify 1. whether this is a expected behaviour 2. what is first_rows hint and whether it is good move to go to first_rows to fix this problem. thanks sai
Basic question about controlfile recovery
Listers, sorry for this basic questionnare. ..was reading the RMAN BR docs (9iR2).got these doubts and thought of claryfying it with u experts. Q1.after a controlfile recovery from backup,is open resetlogs always necessary ? Q2.is there any scenario,where open resetlogs is not necessary after controlfile recovery ? Q3.i have backup ( one day old ) of all my datafiles/archivelogs/controlfile.now,when all my controlfiles are lost with online redologs intact, is complete recovery possible ? if so, is open resetlogs reqd. why ? Please enlighten me. i'll continue RTF(ine)M. Regards, Scott. __ Do you Yahoo!? The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: scott scott INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Using dimensions
Title: Using dimensions Dimensions are data warehouse constructs. They are implemented as tables in the database, but have the characteristic of a hierarchy that can be traversed. For example: a time dimension can have the hierarchy of date, day, week, month, quarter, year, decade, century. This is used for rollup reporting within the data mart. I dont see any good use of it in an OLTP environment, but I may be wrong. Scott Canaan ([EMAIL PROTECTED]) (585) 475-7886 Life is like a sewer, what you get out of it depends on what you put into it. - Tom Lehrer. -Original Message- From: Jamadagni, Rajendra [mailto:[EMAIL PROTECTED] Sent: Monday, September 29, 2003 10:55 AM To: Multiple recipients of list ORACLE-L Subject: Using dimensions I have tried, but haven't found a good example of how to _use_ a dimension in 9ir2. I defined one, but then sat clueless on what to do with it. Is it any good in an OLTP environment? (I smell the answer is a NO, but still) ... Any notes from your experience? TIA Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art !
RE: Sqlloader question
Roland, There are 2 techniques you can use. The first is what I call a 'dynamic control file' - other posters have given you examples of that one, using sed. The next is create a 'loop loader'; essentially a script file that fires off sqlldr for each loadable file. Here's an overly simple example: export FILESPEC=/d31/datafiler/sema/incoming/konkurrenter.* for FILENAME in $( ls ${FILESPEC} ) do sqlldr ${USER-PW} control=${CTL} data=${FILENAME} log=${LOGPATH}/${FILENAME}.log done Both techniques are explained in my IOUG paper SQL*Loader CAN Do That!. A Windows example is also given. If you can't get to the IOUG web site and would like a copy of the paper, send me an email. David Scott [EMAIL PROTECTED] From: [EMAIL PROTECTED] Date: Thu, 11 Sep 2003 14:12:49 +0200 Subject: Sqlloader question Hallo, Anyone whom could tell me if it is in an sqlloader possible to write for instance this if you dont know the exactly name of file. infile '/d31/datafiler/sema/incoming/konkurrenter.*' If there are going to be files with different extensions fo rinstance the first time a file is going to be inserted will be konkurrenter.txt.1 and the next time the file will have the name konkurrenter.txt.2 etc. How should I handle this? Thanksin advance Roland -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: David Scott INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Sqlloader question
The way I handled a similar situation was to create a default SQL*Loader file with something recognizable in the place that you want to do the substitution (in your case, the infile filename). Then, I wrote a shell script that created the correct filename and copied the default SQL*Loader file to the one that was going to be run, substituting the created name for the default name. In my case, I used it to determine which partition should be loaded, but the concept should still work. I used sed to do that: sed 6s/partition()/partition(`echo $IN_DATE_FMT`)/g em_contact_hist_ld.orig em_contact_hist_ld.ctl In the script, this was followed by a call to sqlldr with the control file em_contact_hist_ld.ctl. Scott Canaan ([EMAIL PROTECTED]) (585) 475-7886 Life is like a sewer, what you get out of it depends on what you put into it. - Tom Lehrer. -Original Message- Sent: Thursday, September 11, 2003 9:14 AM To: Multiple recipients of list ORACLE-L Hallo, Anyone whom could tell me if it is in an sqlloader possible to write for instance this if you dont know the exactly name of file. infile '/d31/datafiler/sema/incoming/konkurrenter.*' If there are going to be files with different extensions fo rinstance the first time a file is going to be inserted will be konkurrenter.txt.1 and the next time the file will have the name konkurrenter.txt.2 etc. How should I handle this? Thanksin advance Roland -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Scott Canaan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: How to send an email from unix command line?
Have you tried mailx? That's what we use here. Scott Canaan ([EMAIL PROTECTED]) -Original Message- Sent: Tuesday, September 09, 2003 10:04 AM To: Multiple recipients of list ORACLE-L Hi List I tried the following stuff but it says Service Unavailable. $mail -s Test Subject [EMAIL PROTECTED] body line1 body line2 Ctrl-D What should i do to make email stuff work? Thanks in advance Sami __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Oracle DBA INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Scott Canaan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Forms - as sysdba
Robo wrote: Hi all, I have a 9.2.0.3 DB and I need to connect to Forms 6i as user sys. There are 3 boxes for username, password and database. Does anyone know if/how is it possible? Yes, you could do this by creating an ON-LOGON trigger. But this is a really, really bad idea. Scott Lamb -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Scott Lamb INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: ADMIN: Warning about virus threats this week
Bruce A. Bergman wrote: Hello everyone -- As you undoubtedly know, the Internet has been slammed this week and last week with mass mailings, intrusions, worms and viruses. More are on their way. Fat City has seen a huge increase in the number of spoofed messages coming into our systems. In fact, more than three times the normal load, and this could potentially cause some problems for all of our mailing lists. In order to mitigate this potential problem, I have decided to turn off many of the auto-repsonses that ListGuru sends. Because of the way viruses like SoBig and Klez spoof addresses, and because there are so many fatcity.com addresses in your address books and inboxes, this results in a large number of spoofed messages that ListGuru tries to reply to. Not only is that useless, but it's also annoying for those whose addresses have been spoofed. By shutting off those responses which aren't considered valid, this will reduce the amount of back and forth traffic between our servers and you. This is very much appreciated. I can filter the actual worms out, but I'm getting walloped by responses to spoofed worm emails. It's nice to know there's at least one place deliberately not sending them. Thanks, Scott Lamb -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Scott Lamb INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: select strings with '_' in it
Tanel Poder wrote: Hi! I think translate is overkill here. Use: select col from tab where col like 'v\_lan' escape '\'; vs Select col1 from table where translate(col1,'_','#') like 'v#lan%' / Not only is the escape method cleaner, it's much more efficient. Unless you have an index on translate(col1,'_','#') (unlikely), that query will always result in a sequential scan. Ugh. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Scott Lamb INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Tracing a user session with multiple database connections
Schauss, Peter wrote: Is there any way to trace all of the connections for a given sid without setting sql_trace for the entire instance? You could try creating a trigger to do it. create trigger foo after login on database ... -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Scott Lamb INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Auth via Active Directory
Is there any way to get Oracle 8i (or 9i; we're planning to upgrade) Enterprise Edition to authenticate against Active Directory, short of buying Oracle Advanced Security? My goal is to remove the need to maintain a separate database of passwords. Ideally, we could do also do away with having the database users enter passwords by handling Kerberos tickets, but I'd be happy with them just entering the same password they enter to login to Windows. And if we still need to manually add/remove users, that's okay, too. (We'd probably want to, anyway; not everyone in the domain should have an Oracle account.) In my fantasy world, authentication would all be done through a function that I could modify. Then I could just create my users with something like: create user DOMAIN\USER identified externally; as you would for OS$ authentication and then do something vaguely like: create or replace function system.my_authenticate_user ( p_username in varchar, p_password in varchar ) return boolean as v_usertype varchar2(30); v_session dbms_ldap.session; begin selectauthtype from dba_users where username = p_username; if authtype = 'EXTERNAL' then v_session := dbms_ldap.init('my-domain-controller', 389); return dbms_ldap.simple_bind_s(v_session, p_username, p_password); end if; return standard_authenticate_user(p_username, p_password); exception when no_data_found return false; end; / show errors but I'm not aware of any such hook. There are logon triggers, but just of the after type, not instead of. (create trigger ... after logon on database or something, for audit trails, I think.) Does anything like this exist? Or is there another way, however convoluted? Thanks, Scott Lamb -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Scott Lamb INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 happens if a remove a job that is running?
Yes. If you really want to kill the job, the graceful way is to break it first (dbms_job.broken) and then remove it (dbms_job.remove). Scott Shafer San Antonio, TX 210.581.6217 -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED] Sent: Thursday, August 14, 2003 10:00 AM To: Multiple recipients of list ORACLE-L Subject: what happens if a remove a job that is running? If I run dbms_job.remove on a job that is in dba_jobs_running it remains in that table. it runs to completion correct? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle SCN Question
I thought Bass and Rap were synonymous? Or am I out of touch with the current music scene? Scott Shafer San Antonio, TX 210.581.6217 -Original Message- From: Nick Wagner [SMTP:[EMAIL PROTECTED] Sent: Thursday, July 31, 2003 4:24 PM To: Multiple recipients of list ORACLE-L Subject: RE: Oracle SCN Question Thanks... I think... except I'm not sure how to calculate that? Nick -Original Message- Sent: Thursday, July 31, 2003 2:00 PM To: Multiple recipients of list ORACLE-L Hi, It is just combination of Base and Wrap. So your number will be 8589934593 KG -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: STATSPACK in Oracle 8.1.6.0
Metalink, Technet, Google, or at the scripts themselves (which all have explanatory headers). Scott Shafer San Antonio, TX 210.581.6217 -Original Message- From: Richard Foote [SMTP:[EMAIL PROTECTED] Sent: Friday, July 18, 2003 5:34 AM To: Multiple recipients of list ORACLE-L Subject: Re: STATSPACK in Oracle 8.1.6.0 Hi Scott, Although the recommendation of RTFM often has it's merits, where precisely do you suggest Seema should look for the above mentioned FM within the *8.1.6* doco set for the sp* statspack scripts ? Cheers Richard Foote - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, July 18, 2003 5:59 AM RTFM, which will point you to the sp*.sql scripts in the ?/rdbms/admin directory. Scott Shafer San Antonio, TX 210.581.6217 -Original Message- From: Seema Singh [SMTP:[EMAIL PROTECTED] Sent: Thursday, July 17, 2003 2:49 PM To: Multiple recipients of list ORACLE-L Subject: STATSPACK in Oracle 8.1.6.0 Hi, I want to delete all old records of statspack from perfstat schema. What would be best way to do this either by truncating all tables or remove and recreate ? Pl advice. thx -Seema _ Add photos to your e-mail with MSN 8. Get 2 months FREE*. http://join.msn.com/?page=features/featuredemail -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- 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.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Richard Foote INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Recent reports on outages caused by DB2 and 9iRAC issues
That's funny, I thought SAC's motto was SAC eats it's young. Scott Shafer San Antonio, TX 210.581.6217 -Original Message- From: Goulet, Dick [SMTP:[EMAIL PROTECTED] Sent: Friday, July 18, 2003 1:35 PM To: Multiple recipients of list ORACLE-L Subject: RE: Recent reports on outages caused by DB2 and 9iRAC issues Raj, My previous boss's attitude was: To error is Human. To forgive is not SAC policy. SAC= Starategic Air Command. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- From: Jamadagni, Rajendra [mailto:[EMAIL PROTECTED] Sent: Friday, July 18, 2003 2:00 PM To: Multiple recipients of list ORACLE-L Subject: RE: Recent reports on outages caused by DB2 and 9iRAC issues Dick, we don't share the same boss ... do we? Raj -- -- Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message- From: Goulet, Dick [ mailto:[EMAIL PROTECTED]] Sent: Friday, July 18, 2003 1:39 PM To: Multiple recipients of list ORACLE-L Subject: RE: Recent reports on outages caused by DB2 and 9iRAC issues I prefer my bosses attitude on the subject of mistakes: Admit that you did it then go fix it. We'll crucify you later, if we have the time. For some reason, known only to the Devil himself, they never find the time. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Interview Questions for a Unix Solaris System Admin
question #1: Do you realize that your DBA is a God, and you will obey his/her edicts without question? question #2: Are you aware of the daily offering of food/beer required to keep in your God's (DBA's) good graces? etc... Scott Shafer San Antonio, TX 210.581.6217 -Original Message- From: M.Godlewski [SMTP:[EMAIL PROTECTED] Sent: Tuesday, July 15, 2003 1:30 PM To: Multiple recipients of list ORACLE-L Subject: Interview Questions for a Unix Solaris System Admin I've been asked to interview a system admin candidate for our Solaris shop. I've search Google and altavista, but haven't come up with any after 1999 interview questions. Does anyone have a list of interview question or a link to some? tia M _ Do you Yahoo!? The New Yahoo! Search http://us.rd.yahoo.com/search/mailsig/*http://search.yahoo.com - Faster. Easier. Bingo. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Interview Questions for a Unix Solaris System Admin
You only spend time on the technical stuff if they pass this round. Scott Shafer San Antonio, TX 210.581.6217 -Original Message- From: M.Godlewski [SMTP:[EMAIL PROTECTED] Sent: Tuesday, July 15, 2003 2:20 PM To: Multiple recipients of list ORACLE-L Subject: RE: Interview Questions for a Unix Solaris System Admin These are nice questions. I'm not sure how I would identify if they are technical enough to handle the job though. [EMAIL PROTECTED] wrote: question #1: Do you realize that your DBA is a God, and you will obey his/her edicts without question? question #2: Are you aware of the daily offering of food/beer required to keep in your God's (DBA's) good graces? etc... Scott Shafer San Antonio, TX 210.581.6217 -Original Message- From: M.Godlewski [SMTP:[EMAIL PROTECTED] Sent: Tuesday, July 15, 2003 1:30 PM To: Multiple recipients of list ORACLE-L Subject: Interview Questions for a Unix Solaris System Admin I've been asked to interview a system admin candidate for our Solaris shop. I've search Google and altavista, but haven't come up with any after 1999 interview questions. Does anyone have a list of interview question or a link to some? tia ! M _ Do you Yahoo!? The New Yahoo! Search - Faster. Easier. Bingo. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Do you Yahoo!? The New Yahoo! Search http://us.rd.yahoo.com/search/mailsig/*http://search.yahoo.com - Faster. Easier. Bingo. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: log for transaction
We use a similiar method which involves inserting periodic rows into a log table, which is dumped to a file at end-of-job. Scott Shafer San Antonio, TX 210.581.6217 -Original Message- From: Kirtikumar Deshpande [SMTP:[EMAIL PROTECTED] Sent: Tuesday, June 24, 2003 2:05 PM To: Multiple recipients of list ORACLE-L Subject: Re: log for transaction Oracle does not have any ready-made logging process to assist you. Some of our developers have utilized 'utl_file' to track the progress of their long running jobs. Entries are made to the job log file at proper intervals to tell them what happened in case the job aborted. - Kirti --- [EMAIL PROTECTED] wrote: Hi there, I got a question on log. If my program crashes, can I check some log to see what recent transaction is? It will give me a big help on trouble shooting. Thanks, Jin -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Re: Passwords and authentication
HIPAA Auditing for Oracle Database Security Nice. Well, Arup, Get to publishing! ;-) --Scott -Original Message- To: Multiple recipients of list ORACLE-L Sent: 6/19/03 3:19 PM http://www.dba-oracle.com/bp/bp_titles.htm Look about in the middle of the page. -Original Message- what will be the name of your book? when will it be out? you have an extract of what it will cover yet? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: copy a datafile to a raw device
You left out, ...and why is there a goat in the corner? Sounds like a fun way to have at my duhvelopers (not the good ones). -Original Message- To: Multiple recipients of list ORACLE-L Sent: 6/19/03 4:49 PM Concerning my speculation about error messages in the Oracle kernel, the following is an actual error message in an app here. Of course, the error is never supposed to occur -- so says the programmer when I asked about it. SERROR_MESSAGE := 'How did I Get Here? Where is my car? Who is that laying next to me? Oh my God is that a marriage license?!'; Just in case you developers out there have any creative urges. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: World premier performance of the BAARF party logo
And the satanic redeye is a nice effect for a dba. Could this be the start of oracle pr0n? -Original Message- To: Multiple recipients of list ORACLE-L Sent: 6/12/03 6:19 PM Hey, Who cares about that RAID thing. Whose the cutie in the pictures - hehe. -Original Message- mailto:[EMAIL PROTECTED] ] Sent: Thursday, June 12, 2003 2:50 PM To: Multiple recipients of list ORACLE-L Here are pics if interested. http://www.cybcon.com/~jkstill/no_raid_5/no_raid5_1.jpg http://www.cybcon.com/~jkstill/no_raid_5/no_raid5_1.jpg http://www.cybcon.com/~jkstill/no_raid_5/no_raid5_2.jpg http://www.cybcon.com/~jkstill/no_raid_5/no_raid5_2.jpg I too do not understand why vendors push RAID 5 when RAID 10 is clearly more profitable. I speculate that they may be afraid of being accused of overselling when PHB's discover the RAID 10's they just purchased could have been RAID 5's for less money. Jared Niall Litchfield [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 06/12/2003 10:04 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: World premier performance of the BAARF party logo Jared writes At the meeting last week I wore my 'No RAID 5' hat. Those of you at IOUG 99 in Denver may have seen it, I wore it every day there. ;) I'm curious now. Pictures required. Meanwhile I have never understood why storage vendors would prefer selling RAID5 over RAID10. More disks=more profit surely? Also 10 5 therefore self evidently twice as good for all applications. Meanwhile we have this strange situation where performance consultants are publicising the fact that you have less need for performance consultants with RAID10 than with RAID5. Niall -- Please see the official ORACLE-L FAQ: http://www.orafaq.net http://www.orafaq.net -- Author: Niall Litchfield 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.net http://www.orafaq.net -- Author: 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.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Anyone installed Oracle 9.2 RAC on solaris 9
Lizz, Here are a couple of things you will need if you want to implement RAC on Solaris 9 with Veritas DBE/AC 3.5. Veritas only certifies Storage arrays that support SCSI-III persistent reservations so that leaves XIOtech out as the storage array using Veritas DBE/AC 3.5. If you use Solaris 9 and Veritas DBE/AC 3.5 you will have to use update 3 or apply a patch (which I am not sure of at this time) to fix a problem with the /dev/sd driver and SCSI-III persistent reservations. Hope this helps, Scott --- laura pena [EMAIL PROTECTED] wrote: We have been given the funding to install a production Oracle RAC environment. I am wondering if Solaris 9 has any bugs we should know about. Looks like we will be installing the following: Oracle 9.2 (64-bit)RAC Solaris 9 (64-bit) Veritas DBE/AC version 3.5 - Veritas has a advanced cluster for Oracle9i Real Application software. Our storag media is on a SAN solution using XIOtech and we will need to order an HBA. Any information on bad ideas/gotchas would be most welcomed. Many Thanks, -Lizz - Do you Yahoo!? Free online calendar with sync to Outlook(TM). __ Do you Yahoo!? Yahoo! Calendar - Free online calendar with sync to Outlook(TM). http://calendar.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Scott INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Anyone installed Oracle 9.2 RAC on solaris 9
Matt, Actually the Oracle note is correct and Veritas's note is incorrect. Veritas is aware of that the note you mention is incorrect. I believe the problem is the 4 nodes where not supported until Veritas released Maintenance Pack 1 (MP1) last December. Veritas has also indicated to me that they have successrully tested a 8 and 16 node Veritas cluster with 9i RAC and they are working with Oracle to get this certified. So, yes Veritas DBE/AC 3.5 is currently supported up to 4 nodes with MP1 installed. Scott --- Matthew Zito [EMAIL PROTECTED] wrote: Pete's absolutely right - I didn't mean to give the impression that it was entirely Oracle's nefarious doings to conspire to prevent people from running RAC on their lovely Sun enterprise servers. It's just the combination of factors that are involved in these type of configurations where you have multiple vendors, each with highly critical components they're responsible for having to agree on something they're all happy with. So, in this particular example, its Veritas that dictates the use of EMC or HDS storage, not Oracle. I bet you could run Veritas AC on any storage that supports SCSI-3 persistent reservation and it would work at least reasonably well. The problem is, what happens when you have a problem and call Veritas? This sort of comes back to the classic question: is the supported or certified configuration always the right and only configuration? It varies wildly by company. In the storage space, it runs from one extreme - Netapp, which I have never ever heard say that a config was unsupported when there was a problem to be solved, to the other extreme - EMC (who I used to work for), who has a multi-meg PDF describing every single supported config down to things like patchlevels of cluster software. The flip side, of course, is that there's a certain confidence you're supposed to be able to have when you're running a certified configuration. With regards to RAC on Sun, there's a Metalink doc that lays out the compatible technologies (and as I look at it now, I see that the oracle docs claim 4 nodes on veritas AC 3.5 and the veritas release notes say 2 - interesting), and they're pretty explicit about the technologies that are certified. There's actually more options for Sun than for Linux - two cluster products instead of one on Linux. It's just that the cost and complexity of the Sun clustering options, coupled with the higher cost for Sun servers, seems to outweight the benefits. Like Pete said, RAC is mostly not about HA - I would argue its about getting cost-effective scalability and performance out of databases traditionally run on more expensive/larger monolithic SMP machines. Pete's also right about raw - its really not _that_ bad. I just prefer, as it seems most people do, filesystem semantics for management. My full preference is actually for NAS, but that's just the stingy person in me not wanting to shell out the money for fibre channel ports. Thanks, Matt -- Matthew Zito GridApp Systems Email: [EMAIL PROTECTED] Cell: 646-220-3551 Phone: 212-358-8211 x 359 -Original Message- Pete Sharman Sent: Thursday, June 05, 2003 3:01 PM To: Multiple recipients of list ORACLE-L From an Oracle perspective, we're fairly agnostic about the cluster RAC runs on. There was a major change in the certification some time back where we no longer certify the hardware. If it's a cluster that's supported by the OS vendor, then RAC should work on it (and if it doesn't then a bug needs to be logged). Here's a couple of comments from my personal perspective though (SELECT standard_disclaimer FROM company_requirements;) - none specifically aimed at you personally: 1.I always find it difficult to see why people have so much difficulty with raw. I mean, really, come on guys. If raw is too hard, then how are you gonna cope with all the other requirements of HA (not just the Oracle ones but all the other things like solid change management and so on)? 2. The problems with the Sun CFS aren't so much with the support of it as they are with the fact that the performance of the Sun CFS isn't good enough yet. CFS's are fine if they're implemented properly. Given my druthers, I'd go for a Compaq system using their CFS any time. After all, Digital / Compaq / HP / whatever the next merger is have been in the cluster game forever. Give me my VAX back again! :-) 3. As an aside, raw is NOT a requirement for RAC. Raw is a requirement for those crappy OS's that can't share open files. Before the days of CFS's on Compaq, IIRC the only OS that could do this without raw was VAX/VMS. So don't blame RAC for raw devices, blame the crappy OS's it runs on. :-) 4. Strange as it may seem to have to mention it, you do need more than
RE: cannot allocate new log
Nuala, It looks like the DB is waiting for you to manually archive the logs. Like Lisa suggested, could you do an archive log list from the sqlplus prompt and post the results? There are two steps in setting up archiving. You have to set the proper parameters in the init.ora file, and then bring the db up in mount mode to start the archiver before you open the database. -Scott At 08:24 AM 6/2/03 -0800, you wrote: Hi Denis, Thanks for the quick reply, We're not getting an oracle error no: This is the message in the alert log Mon Jun 02 08:19:19 2003 Thread 1 cannot allocate new log, sequence 711 All online logs needed archiving Current log# 2 seq# 710 mem# 0: D:\ORACLE\ORADATA\GDA\GDA_21.LOG Current log# 2 seq# 710 mem# 1: E:\ORACLE\ORADATA\GDA\GDA_22.LOG The event log has a similar message. Our database is in archivelogmode log_archive_start = True Space is not an issue on the drive - there's at least 10 gigs free. Disk access and write permissions are ok as it seems to write some of the logs but then stops! I checked this by doing an alter system switch logfile - to force a write - which was successful. Any other suggestions are appreciated, N. :--Original Message- :-From: DENNIS WILLIAMS [mailto:[EMAIL PROTECTED]] :-Sent: 02 June 2003 15:37 :-To: '[EMAIL PROTECTED]' :-Cc: '[EMAIL PROTECTED]' :-Subject: RE: cannot allocate new log :- :- :-Nuala - You didn't include your error number, so the :-following are some :-guesses: Is your database in archivelogmode? Check the path :-to the archive :-logs and make sure that drive hasn't filled. For the logs :-themselves, check :-the paths and permissions. :- :-Dennis Williams :-DBA, 80%OCP, 100% DBA :-Lifetouch, Inc. :-[EMAIL PROTECTED] :- :- :--Original Message- :-From: Nuala Cullen [mailto:[EMAIL PROTECTED]] :-Sent: Monday, June 02, 2003 9:20 AM :-To: Multiple recipients of list ORACLE-L :-Subject: cannot allocate new log :- :- :- :-Hi All, :- :-I keep getting a cannot allocate new log in the alert log. :-This freezes the :-entire application and I am unable to connect to oracle in :-order to do a :-statspack snap shot. :- :-This is an upgrade to Version 8.1.7.4 set up on a WK2000 :-(NEW) Server with 2 :-gigs of memory. :- :-We are writing to 3 separate disks :- :-Our DE drives are RAID 0+1. The log files (including :-application logs) are :-written to these drives :-The F drive is raid 5 - this is where our data resides. (No :-logs are written :-to the F drive) :- :-Currently we have 4 groups of redo log files :- :- group 1 ('d:\oracle\oradata\gda\gda_11.log', :- 'e:\oracle\oradata\gda\gda_12.log') :-size 20M reuse, :- group 2 ('d:\oracle\oradata\gda\gda_21.log', :- 'e:\oracle\oradata\gda\gda_22.log') :-size 20M reuse, :- group 3 ('d:\oracle\oradata\gda\gda_31.log', :- 'e:\oracle\oradata\gda\gda_32.log') :-size 20M reuse, :- group 4 ('d:\oracle\oradata\gda\gda_41.log', :- 'e:\oracle\oradata\gda\gda_42.log') :-size 20M reuse :- :-and we archive to e:\oracle\arc\gda :- :-These are our log settings from the init.ora :-log_buffer = 131072 :-log_checkpoint_interval = 1 :-log_checkpoint_timeout = 0 :- :-I have the performance monitor running the whole time and :-when this happens :-the CPU, DISK QUE LENGTH all look normal. :-I have read the archive files regarding this error but :-thought that the :-above set-up was sufficient. :-Can anybody *please* give me some idea of what other areas I :-should be :-looking at in order to prevent the error from occurring. :-Would writing smaller files help? Disk space is not an issue. :- :-Thanks - all advice appreciated, :- :-N. :-(developer/part-time DBA) :- :-___ :-Nuala Cullen :-Catlogic :-30 Park Gate :-Milton Park :-Abingdon :-Oxfordshire :-OX14 4SH :- :-Phone: +44 (0) 1235 838151 :-Fax: +44 (0) 1235 838160 :-Direct Line: +44 (0) 1235 838147 :-___ :- :- :- ** Scott Stefick Systems / Oracle Certified DBA Wm. Rainey Harper College [EMAIL PROTECTED] 847.925.6130 **
Re: SunCluster 3. 0 Veritas File system RAC
Vladimir, You can either use Sun Cluster 3.0 using raw devices only with Veritas's Cluster Volume manager to manage the devices. or You can use Veritas's DBE/AC 3.5 edition and use the Veritas Cluster manager and Cluster File Systems (includes Cluster Volume Manager by Default) or raw devices. You can't Veritas's CFS on SC3.0. Hope this helps, Scott --- Vladimir Barac [EMAIL PROTECTED] wrote: Anyone using this configuration? Since I would like to avoid raw partitions, I was thinking of recomending Veritas File system... Is it certified / working? Anyone working with such combo? I will fire metalink page soon, but would like to have some input from listers! Thanks, Vladimir Barac __ Do you Yahoo!? Yahoo! Tax Center - File online, calculators, forms, and more http://tax.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Scott INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Importing Schema getting compilation errors on some triggers
Hello, Oracle 8.1.7.4 HPUX 11.11 App is Famis Maintenance Management System I have 3 instances TEST, TRAIN, PROD and I am trying to refresh the whole famis schema on TRAIN with the famis schema on TEST. Every time I try to do the import, I get compilation errors for 4 triggers (out of 75). I tried to re-compile them in the TRAIN instance after the import and get the same compilation errors. I try to re-compile them in TEST which is where they came from and they compile without a problem. I don't understand why this would happen when I exported the whole schema from TEST and imported the whole .dmp file into TRAIN. Any Thoughts? -Scott ** Scott Stefick Systems / Oracle Certified DBA Wm. Rainey Harper College 847.925.6130 ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Scott Stefick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Importing Schema getting compilation errors on some
Here is the output of the show errors command (which I didn't know about... Thanks). == SQL show errors trigger famis_pr_status_insert Errors for TRIGGER FAMIS_PR_STATUS_INSERT: LINE/COL ERROR - 106/32 PLS-00201: identifier 'MAILER.DBMS_OFFICE' must be declared 106/32 PL/SQL: Statement ignored 180/32 PLS-00201: identifier 'MAILER.DBMS_OFFICE' must be declared 180/32 PL/SQL: Statement ignored SQL SQL show errors trigger famis_req_insert Errors for TRIGGER FAMIS_REQ_INSERT: LINE/COL ERROR - 187/21 PLS-00201: identifier 'MAILER.DBMS_OFFICE' must be declared 187/21 PL/SQL: Statement ignored 264/25 PLS-00201: identifier 'MAILER.DBMS_OFFICE' must be declared 264/25 PL/SQL: Statement ignored 339/25 PLS-00201: identifier 'MAILER.DBMS_OFFICE' must be declared 339/25 PL/SQL: Statement ignored 416/24 PLS-00201: identifier 'MAILER.DBMS_OFFICE' must be declared 416/24 PL/SQL: Statement ignored SQL = I'm guessing it's a problem with DBMS_OFFICE and not with the trigger after seeing this. -Scott At 01:43 PM 4/4/03 -0800, you wrote: Scott, can you run this command in sqlplus and e-mail the results out to us... show errors trigger triggername [EMAIL PROTECTED] 04/04/03 02:14PM Hello, Oracle 8.1.7.4 HPUX 11.11 App is Famis Maintenance Management System I have 3 instances TEST, TRAIN, PROD and I am trying to refresh the whole famis schema on TRAIN with the famis schema on TEST. Every time I try to do the import, I get compilation errors for 4 triggers (out of 75). I tried to re-compile them in the TRAIN instance after the import and get the same compilation errors. I try to re-compile them in TEST which is where they came from and they compile without a problem. I don't understand why this would happen when I exported the whole schema from TEST and imported the whole .dmp file into TRAIN. Any Thoughts? -Scott ** Scott Stefick Systems / Oracle Certified DBA Wm. Rainey Harper College 847.925.6130 ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Scott Stefick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Darrell Landrum INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). ** Scott Stefick Systems / Oracle Certified DBA Wm. Rainey Harper College 847.925.6130 ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Scott Stefick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Importing Schema getting compilation errors on some
No, both instances were built the same way and they both worked before this. I noticed that when I did a show errors trigger trigger_name I saw: = 106/32 PLS-00201: identifier 'MAILER.DBMS_OFFICE' must be declared 106/32 PL/SQL: Statement ignored = I'm checking why this would have happened. So far I've checked the synonyms and the dba_objects view and they look ok. -Scott At 01:59 PM 4/4/03 -0800, you wrote: Scott: My first thought is to ask if there are any external references (other schemas, SYS packages, etc.) in the triggers that may not exist in TRAIN that do exist in TEST Rick Weiss -Original Message- Sent: Friday, April 04, 2003 13:14 To: Multiple recipients of list ORACLE-L Hello, Oracle 8.1.7.4 HPUX 11.11 App is Famis Maintenance Management System I have 3 instances TEST, TRAIN, PROD and I am trying to refresh the whole famis schema on TRAIN with the famis schema on TEST. Every time I try to do the import, I get compilation errors for 4 triggers (out of 75). I tried to re-compile them in the TRAIN instance after the import and get the same compilation errors. I try to re-compile them in TEST which is where they came from and they compile without a problem. I don't understand why this would happen when I exported the whole schema from TEST and imported the whole .dmp file into TRAIN. Any Thoughts? -Scott ** Scott Stefick Systems / Oracle Certified DBA Wm. Rainey Harper College 847.925.6130 ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Scott Stefick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Weiss, Rick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). ** Scott Stefick Systems / Oracle Certified DBA Wm. Rainey Harper College 847.925.6130 ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Scott Stefick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Importing Schema getting compilation errors on some
To answer the previous questions: 1. No (That was the problem) 2. Yes 3. Yes Thanks so much. It's working now. granted execute on dbms_office to famis and that did it. Maybe it's the fact that I'm a newbie, but I assumed the grants would come over with the import. I think I understand what happened now. The grants on the objects that famis owns come over with the import, not any of the grants for objects outside of that schema. I think about it now and I'm like Damn that makes total sense! I don't know why I assumed that famis would get the grants from all of the other objects, that doesn't make sense to me now. Rick, if you're ever in the Chicago area, I'll have to buy you a beer (or whatever you prefer). Also, thanks to everyone who helped me. Rick Weiss Darrell Landrum Stephane Faroult Gary Kirsh Charlie Mengler Thanks! -Scott At 02:53 PM 4/4/03 -0800, you wrote: Do you have execute privs set for MAILER.DBMS_OFFICE?? Does it exist on the second database?? Is the MAILER schema on the database? (I'm climbing my ladder of thoughts as I'd check them) Just a thought Rick Weiss Helena, MT USA -Original Message- Sent: Friday, April 04, 2003 15:24 To: Multiple recipients of list ORACLE-L Here is the output of the show errors command (which I didn't know about... Thanks). == SQL show errors trigger famis_pr_status_insert Errors for TRIGGER FAMIS_PR_STATUS_INSERT: LINE/COL ERROR - 106/32 PLS-00201: identifier 'MAILER.DBMS_OFFICE' must be declared 106/32 PL/SQL: Statement ignored 180/32 PLS-00201: identifier 'MAILER.DBMS_OFFICE' must be declared 180/32 PL/SQL: Statement ignored SQL SQL show errors trigger famis_req_insert Errors for TRIGGER FAMIS_REQ_INSERT: LINE/COL ERROR - 187/21 PLS-00201: identifier 'MAILER.DBMS_OFFICE' must be declared 187/21 PL/SQL: Statement ignored 264/25 PLS-00201: identifier 'MAILER.DBMS_OFFICE' must be declared 264/25 PL/SQL: Statement ignored 339/25 PLS-00201: identifier 'MAILER.DBMS_OFFICE' must be declared 339/25 PL/SQL: Statement ignored 416/24 PLS-00201: identifier 'MAILER.DBMS_OFFICE' must be declared 416/24 PL/SQL: Statement ignored SQL = I'm guessing it's a problem with DBMS_OFFICE and not with the trigger after seeing this. -Scott At 01:43 PM 4/4/03 -0800, you wrote: Scott, can you run this command in sqlplus and e-mail the results out to us... show errors trigger triggername [EMAIL PROTECTED] 04/04/03 02:14PM Hello, Oracle 8.1.7.4 HPUX 11.11 App is Famis Maintenance Management System I have 3 instances TEST, TRAIN, PROD and I am trying to refresh the whole famis schema on TRAIN with the famis schema on TEST. Every time I try to do the import, I get compilation errors for 4 triggers (out of 75). I tried to re-compile them in the TRAIN instance after the import and get the same compilation errors. I try to re-compile them in TEST which is where they came from and they compile without a problem. I don't understand why this would happen when I exported the whole schema from TEST and imported the whole .dmp file into TRAIN. Any Thoughts? -Scott ** Scott Stefick Systems / Oracle Certified DBA Wm. Rainey Harper College 847.925.6130 ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Scott Stefick INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Darrell Landrum INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). ** Scott Stefick Systems / Oracle Certified DBA Wm. Rainey Harper College 847.925.6130 ** -- Please see
RE: Importing Schema getting compilation errors on some
Rick, I agree with having to celebrate, since I was able to accomplish my task before I left for the weekend. That's always a good thing. Have a good weekend as well and good luck with the weather and the fishing. -Scott At 03:43 PM 4/4/03 -0800, you wrote: Scott- Wow - what a way to finish a week, I actually got something right. I may have to celebrate - looks like it's time to pull out my fly rod and attack some trout - if it doesn't snow again tonight. ( The challenges of living in MT ) Here's a picture for the rest of the world to see - I love it here. http://www.nps.gov/glac/whatsnew/cam2_mcdonald.htm Have an excellent weekend folks Rick Weiss Helena, MT -Original Message- From: Scott Stefick [mailto:[EMAIL PROTECTED]] Sent: Friday, April 04, 2003 16:26 To: Multiple recipients of list ORACLE-L Subject: RE: Importing Schema getting compilation errors on some To answer the previous questions: 1. No (That was the problem) 2. Yes 3. Yes Thanks so much. It's working now. granted execute on dbms_office to famis and that did it. Maybe it's the fact that I'm a newbie, but I assumed the grants would come over with the import. I think I understand what happened now. The grants on the objects that famis owns come over with the import, not any of the grants for objects outside of that schema. I think about it now and I'm like Damn that makes total sense! I don't know why I assumed that famis would get the grants from all of the other objects, that doesn't make sense to me now. Rick, if you're ever in the Chicago area, I'll have to buy you a beer (or whatever you prefer). Also, thanks to everyone who helped me. Rick Weiss Darrell Landrum Stephane Faroult Gary Kirsh Charlie Mengler Thanks! -Scott At 02:53 PM 4/4/03 -0800, you wrote: Do you have execute privs set for MAILER.DBMS_OFFICE?? Does it exist on the second database?? Is the MAILER schema on the database? (I'm climbing my ladder of thoughts as I'd check them) Just a thought Rick Weiss Helena, MT USA -Original Message- Sent: Friday, April 04, 2003 15:24 To: Multiple recipients of list ORACLE-L Here is the output of the show errors command (which I didn't know about... Thanks). == SQL show errors trigger famis_pr_status_insert Errors for TRIGGER FAMIS_PR_STATUS_INSERT: LINE/COL ERROR - 106/32 PLS-00201: identifier 'MAILER.DBMS_OFFICE' must be declared 106/32 PL/SQL: Statement ignored 180/32 PLS-00201: identifier 'MAILER.DBMS_OFFICE' must be declared 180/32 PL/SQL: Statement ignored SQL SQL show errors trigger famis_req_insert Errors for TRIGGER FAMIS_REQ_INSERT: LINE/COL ERROR - 187/21 PLS-00201: identifier 'MAILER.DBMS_OFFICE' must be declared 187/21 PL/SQL: Statement ignored 264/25 PLS-00201: identifier 'MAILER.DBMS_OFFICE' must be declared 264/25 PL/SQL: Statement ignored 339/25 PLS-00201: identifier 'MAILER.DBMS_OFFICE' must be declared 339/25 PL/SQL: Statement ignored 416/24 PLS-00201: identifier 'MAILER.DBMS_OFFICE' must be declared 416/24 PL/SQL: Statement ignored SQL = I'm guessing it's a problem with DBMS_OFFICE and not with the trigger after seeing this. -Scott At 01:43 PM 4/4/03 -0800, you wrote: Scott, can you run this command in sqlplus and e-mail the results out to us... show errors trigger triggername [EMAIL PROTECTED] 04/04/03 02:14PM Hello, Oracle 8.1.7.4 HPUX 11.11 App is Famis Maintenance Management System I have 3 instances TEST, TRAIN, PROD and I am trying to refresh the whole famis schema on TRAIN with the famis schema on TEST. Every time I try to do the import, I get compilation errors for 4 triggers (out of 75). I tried to re-compile them in the TRAIN instance after the import and get the same compilation errors. I try to re-compile them in TEST which is where they came from and they compile without a problem. I don't understand why this would happen when I exported the whole schema from TEST and imported the whole .dmp file into TRAIN. Any Thoughts? -Scott ** Scott Stefick Systems / Oracle Certified DBA Wm. Rainey Harper College 847.925.6130 ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Scott Stefick INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want
Where to set LD_LIBRARY_PATH in Database for 3rd Party Utilities
I hope someone on the list can help. Environment: Oracle 9.2.0.1 Red Hat Linux Im in the process of trying to connect to a Progress database via Java Stored Procedures in Oracle 9.2.0.1. The Progress JDBC driver is a type 2 driver, which means that it has shared libraries that it must access. The java test code works outside of the database. The connection to the Progress database is successful. The library path for the Progress JDBC driver was added to the LD_LIBRARY_PATH variable. The Progress JDBC driver was loaded into the database via the loadjava utility. When I run the test program though the database, I get an error indicating that the library files could not be found. The Oracle users profile has the additions to the LD_LIBRARY_PATH for the Progress JDBC driver, but this didnt help. I was able to find one forum note on Metalink where someone got this to work, but no details. Where should I set the LD_LIBRARY_PATH variable for the database to be able to find this 3rd party library files? Any ideas would be appreciated. As you can probably tell, Im new to Unix/Linux. Thanks in Advance, Scott Graves Sr. Systems Programmer NISC RDQ-STP Email: [EMAIL PROTECTED] Phone: 636-922-9122 x7616 Fax: 636-922-2080
Re: Sun HA Monitoring and Oracle 9
Barb, This isn't an Oracle limitation. It's a Sun HA limitation. Oracle 9i will run on Sun Solaris HA 2.2, with no problem. We've installed it and built an instance and run it. The problem comes in when you want to HA monitor the database. HA 2.2 won't even run when it gets to the Oracle 9i instance. The problem is so bad that the program just exits as soon as it hits that instance, so it ends up not monitoring anything, not even the 8i instances. Our SA called Sun and was told that HA 2.2 only works with Oracle through 8i. If we want to use it with Oracle 9i, then we have to buy HA 3.0 (it's not an upgrade, they consider it a new product). They did say that HA 3.0 will support Oracle 8i and 9i, but nothing before Oracle 8i. Unfortunately, the changeover means that we would have to do a complete rebuild of the Sun Cluster, which is not possible. We can't have that much downtime (about 1 week). If we get the funding, our plan is to buy 2 more Sun machines, build a 2-node cluster with HA 3.0, migrate the applications to that cluster, then bring 2 of the original Sun machines into that cluster, making it a 4-node cluster again. Barbara Baker wrote: Scott (or anyone runing HA 2.2 wishing to upgrade to 9i): I noticed you did not receive a response from this message a couple of months back. We're in same situation (Sun Cluster 2.2, wishing to upgrade to Oracle 9i). It's not clear from the Oracle certification matrix if this is supported. (Clearly not supported if you're running RAC, but we're not) We're not convinced we want to upgrade to Sun cluster 3.0 (and certainly not clear we want to pay for it.) I'm wondering if there are others with this configuration, and if so what you decided to do. Thanks in advance for any information. Barb -Original Message- Sent: Monday, January 06, 2003 10:14 AM To: Multiple recipients of list ORACLE-L Here's a little background. We are currently running Oracle 8.1.6.0, 8.1.7.0, and 8.1.7.4 on a Sun cluster. We use HA monitoring for failover, in case there is a problem with any of the nodes. The version of HA is 2.2. We installed Oracle 9.2.0.1 on the cluster and created a new database using it. When the SA tried to start the HA monitoring, it wouldn't run. We ended up recreating the database in 8.1.7.4. When the SA contacted Sun, he was told that HA version 2.2 only supports up to Oracle 8.1.7. In order to monitor Oracle 9, we had to buy (not upgrade to) HA 3.0, which would require a rebuild of the entire cluster. Has anyone else run into this problem? If so, what have you done to get around it? Let me know if I forgot any important piece of information. Thank you. -- Scott Canaan ([EMAIL PROTECTED]) (585) 475-7886 "Life is like a sewer, what you get out of it depends on what you put into it." - Tom Lehrer. __ Do you Yahoo!? Yahoo! Tax Center - File online, calculators, forms, and more http://platinum.yahoo.com -- Scott Canaan ([EMAIL PROTECTED]) (585) 475-7886 "Life is like a sewer, what you get out of it depends on what you put into it." - Tom Lehrer.
RE: Oracle Job Task Analysis
John, That is a good question. What is the purpose of this task Analysis? I am trying to see what most DBA's perceive as what is the most important things to learn so you can manage an Oracle Database. An example would be Learning Oracle Architecture. If you are a small, medium or large company, Architecture is probably the most important. Within the Oracle Architecture what is the most important for me to learn to job. Learning the SGA structures and how to size them. Learning the physical structures of the database and how to manage them. So if you wanted to be a DBA with Oracle what major Oracle components do think you need know to accomplish that job and what sub-components are important? If I was a DBA in a company that does a lot of interne t activity what do I need to know? If I run a 7X24 shop what do I need to know and so on. Small, medium and Large companies will require a base knowledge and as you get more niche you will need to understand other components of Oracle. We also need to look at what is niche. RAC is niche but becoming more mainstream. What do I need to know to run a HA shop, however Context, XML and Spatial are in the database, while these are niche they are as common as RAC. So what I am looking for is what people perceive to be the most common components needed to do their Job. Another interesting question is do I need to learn how to create the database and other database objects using manual methods or do I use DBCA and EM to do my job. Is knowing the GUI sufficient for me to be a DBA? These are why I am asking these questions. I really want to know what you really need to know right down to you only need to know it if you implement the option. Does this help? Scott --- Hallas, John, Tech Dev [EMAIL PROTECTED] wrote: Scott, Is this job task analysis menat to be specific to what you do/ will do at your current site or to cover general activities thta a DBA may come across. If it is the first option it appears that you are covering almost every Oracle feature available so you must be very busy. If it is the second option then I suspect very few DBAs could honestly say that they have worked and know well every task on the list and indeed would not get chance to use them all at any one site. However a key word in the list is *understand*. That means different things to different people. These could be grouped by 1) Deeply understand , have used extensively, raised bugs on the product etc 2) Have read up on and not all about in principle and would expect to implement with no great difficulty 3) Have heard of and not much else 4) Those who can talk bulls* and are at stage 3 but are at level 1 at the CV stage. Overall I think I am asking 'what is the purpose of this task list' John -Original Message- Sent: 01 April 2003 22:14 To: Multiple recipients of list ORACLE-L I am putting together a prelimanary job task analysis for Oracle DBA's and would like some input from you hardworking DBA's on this list. Here is what I have so far for core competencies and I would like to add or subtract from this list based on your input. A. Oracle Architecture And Options B. Security and Network Access C. Application Design and Modelling D. Backup And Recovery E. Software Maintenance And Operation F. SEGMENT and DATA MANAGEMENT G. Tuning And Troubleshooting My Recommendations for slightly more advanced competencies that are still quite important For many installations. H. Scalability I. High Availability J. Business Intelligence Here is what I have as sub-components for the core competencies. A. ORACLE ARCHITECTURE AND OPTIONS 1. Demonstrate an understanding of memory structures and processes which make up an Oracle instance 2. Demonstrate an understanding of the logical and physical structures associated with an Oracle database 3. Demonstrate an understanding of PL/SQL constructs (triggers, functions, packages, procedures) and their processing 4. Demonstrate an understanding of distributed architecture and client server and 3 tier architectures 5. Demonstrate an understanding of Oracle Globalisation B. SECURITY and NETWORK ACCESS 1. Create, alter, and drop database users 2. Develop and implement a strategy for managing security using roles, privileges, authentication, 3. Demonstrate an Appreciation of implementing row level security using Application Contexts and Fine Grain access control 4. Demonstrate an Appreciation of implementing Network security using Oracle Internet Directory (OID) ,LDAP and Single Sign On (SSO) 5. Demonstrate an Appreciation of implementing firewalls in Oracle using Standard Oracle Net features 6. Use Database and Fine grain auditing 7.Demonstrate an understanding of the implications of distributed processing on the security model C. Appication Design and Modelling 1
Oracle Job Task Analysis
an appreciation of parallel execution (Parallel Query,DML, DDL, and Recovery) 4. Understand Scaleup using Oracle Net Connection Pooling, Connecton Multiplexing I. HIGH AVAILABILITY 1. Demonstrate an appreciation of Real Application Clusters Architecture High availability capabilities Including RAC Guard 2. Understand Connect time Failover and Load Balancing 3. Understand Transparent Application Failover 4. Understand Data Guard Architecture and Physical and Logical Standby Databases 5. Understand Replication using Advanced Replication and Oracle Streams J. BUSINESS INTELLIGENCE 1. Understand and Use Oracles Extranction, Transformation, and Load facilities including External Tables, and Incremental Change Data Capture 2. Understand the use of Star Schemas, Bitmap Indexes and Bitmap Join Indexes 3. Understand Summary Management using Materialised Views, and Oracle Dimensions for Realtional OLAP processing 4. Understand Oracles implementation of Analytic Workspaces for Multidimensional OLAP processing Thanks in advance for your help, Scott __ Do you Yahoo!? Yahoo! Tax Center - File online, calculators, forms, and more http://platinum.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Scott INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: alert log file
If you move the alert log to another directory, Oracle will create a new one in its place. There is no need to bounce the DB. -Scott At 07:54 AM 3/31/03 -0800, you wrote: for one of the db over here alert log is biggg .Looks like its never been truncated or backup . Is it a problem if i just move this alert log file to another directory , will oracle create a new alert log file ? Do I need to bounce db ? btw its 8.1.6 ( hp-ux ) -ak ** Scott Stefick Systems / Oracle Certified DBA Wm. Rainey Harper College 847.925.6130 **
Re: Hotsos Clinic 101 Feedback
I haven't taken it yet, but I am signed up for the Chicago Clinic on April 8-10Can't Wait! I've heard really good things about it. At 08:04 AM 3/26/03 -0800, you wrote: Anybody take this course before. Any comments, good or bad. Thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tracy Rahmlow INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). ** Scott Stefick Oracle Certified DBA Wm. Rainey Harper College 847.925.6130 ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Scott Stefick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Test
This is a test, I have not received any messages in the last couple of days. -Scott ** Scott Stefick Oracle Certified DBA Wm. Rainey Harper College 847.925.6130 ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Scott Stefick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Urgent - ORA-03001 Error While creating BLOB in 9.0.1 ?!
Guys, CREATE TABLE NAO.MSG ( MEMNO NUMBER(10, 0), PROFNO NUMBER(10, 0), NAME VARCHAR2(20), AGE VARCHAR2(10), SEX NUMBER(1, 0), JANLNO NUMBER(5, 0), SUBJECT VARCHAR2(50), CONTENT VARCHAR2(500), DELFLAG NUMBER(1, 0) DEFAULT 0, POSTDATE DATE DEFAULT SYSDATE, EXPDATE DATE, POSTNO NUMBER(10, 0), REFCNT NUMBER(5, 0) DEFAULT 0, PREF VARCHAR2(10), AREA NUMBER(2, 0), SBSTCNT NUMBER(5, 0) DEFAULT 0, SENDFLG NUMBER(1, 0) DEFAULT 0, REPLYCNT NUMBER(5, 0) DEFAULT 0, CHKFLG NUMBER(1, 0) DEFAULT 0, ENTPC VARCHAR2(10), STOPFLG NUMBER(5, 0) DEFAULT 0, PARENT NUMBER(10, 0), PIC BLOB, PICUPFLG NUMBER(1, 0) DEFAULT 0 ) TABLESPACE CANDY03 When i create this table on machine A,i get the error below: ORA-03001: unimplemented feature if i remove the BLOB column from the SQL , it works fine on machine A. whereas, this works on another machine B with the same o/s and oracle set up. i wonder why ? Can you let me know the reason ? _ Get 25MB, POP3, Spam Filtering with LYCOS MAIL PLUS for $19.95/year. http://login.mail.lycos.com/brandPage.shtml?pageId=plusref=lmtplus -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Scott Nealy INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Thanx: how to get metalink user name
Thanx guys. my next call is to Oracle Customer Support. _ Get 25MB, POP3, Spam Filtering with LYCOS MAIL PLUS for $19.95/year. http://login.mail.lycos.com/brandPage.shtml?pageId=plusref=lmtplus -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Scott Nealy INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Thanx: how to get metalink user name
Thanx guys. my next call is to Oracle Customer Support. _ Get 25MB, POP3, Spam Filtering with LYCOS MAIL PLUS for $19.95/year. http://login.mail.lycos.com/brandPage.shtml?pageId=plusref=lmtplus -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Scott Nealy INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: why SAN ? why not external storage ?
Oh, Gods forbid the sysadmins would have to gulp do their job... HAHAHAHAHA!!! Scott Shafer San Antonio, TX 210.581.6217 -Original Message- From: Mogens Nørgaard [SMTP:[EMAIL PROTECTED] Sent: Thursday, March 13, 2003 5:25 PM To: Multiple recipients of list ORACLE-L Subject: Re: why SAN ? why not external storage ? There are many things I don't get in this life. One of them is the statements about disk storage being an admin nightmare and way too expensive. Aren't disks very cheap these days?! Mogens [EMAIL PROTECTED] wrote: Rahul, This is personal opinion, but it looks to me like your concerned about the database your creating for the client and may not have the total or corporate wide view your client has. We're heading down the SAN road not because of any specific database requirements but because disk storage has become an administrative nightmare as well as way too expensive. Dick Goulet Reply Separator Author: Arun Annamalai [EMAIL PROTECTED] Date: 3/13/2003 12:24 PM Usaually SAN and NAS is used for several good reasons...the two main are... 1) High availability - When you have your database files on SAN/NAS then you can bring ur database on another server when the primary goes down. Obviously you have to use a cluster or Big IP (F5) on the front. 2) reduce redundancy -A unix userid with home directory attached to a paticular NFS drive on NAS/SAN, will able to see all his files when he logs into other servers. so far I heard Net App is low cost including with Raid 5. -Arun. Sr oracle dba - Original Message - From: Rahul To: Multiple recipients of list ORACLE-L Sent: Wednesday, March 12, 2003 9:38 PM Subject: Re: why SAN ? why not external storage ? my reasons to recommend an external storage was.. 1) the database size is 36GB, and according to many documents i have read, SAN is not cost effevtive unless populated by a large numbers of drives !!, now for the client the cost is not the factor.. given the situation.. wouldnt a SAN be an overkill ? 2) NO DBA or SYS ADMIN skills to manage the SAN !! - Original Message - From: Tim Gorman To: Multiple recipients of list ORACLE-L Sent: Wednesday, March 12, 2003 8:33 PM Subject: Re: why SAN ? why not external storage ? Can you share some of the reasons related to your decision in choosing a direct-attach storage (DAS) instead of a SAN? In general, a SAN is a much smarter choice than DAS. - Original Message - From: Rahul To: Multiple recipients of list ORACLE-L Sent: Wednesday, March 12, 2003 1:33 AM Subject: why SAN ? why not external storage ? list, one of our clietns are going to by SAN, the current oracle databases take around 36GB of storage i dnt understand there reason to go for SAN, i sugguested to buy an external storage box instead. How can i justify my desicion ? (cost of not the factor) TIA rahul !DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.0 Transitional//EN HTMLHEAD META http-equiv=Content-Type content=text/html; charset=iso-8859-1 META content=MSHTML 6.00.2800.1106 name=GENERATOR STYLE/STYLE /HEAD BODY bgColor=#ff DIVFONT face=Arial size=2Usaually SAN and NAS is used for several good reasons...the two main are.../FONT/DIV DIVFONT face=Arial size=21) High availability - When you have your database files on SAN/NAS then you can bring ur database on another server when the primary goes down. Obviously you have to use a cluster or Big IP (F5) on the front./FONT/DIV DIVFONT face=Arial size=22) reduce redundancy -/FONTFONT face=Arial size=2Anbsp;unix useridnbsp;with home directory attached to a paticular NFSnbsp;drive on NAS/SAN,nbsp;willnbsp; able to see allnbsp;his files when he logs into othernbsp;servers./FONT/DIV DIVFONT face=Arial size=2/FONTnbsp;/DIV DIVFONT face=Arial size=2so far I heard Net App is low cost including with Raid 5./FONT/DIV DIVFONT face=Arial size=2/FONTnbsp;/DIV DIVFONT face=Arial size=2-Arun./FONT/DIV DIVFONT face=Arial size=2Sr oracle dba/FONT/DIV BLOCKQUOTE dir=ltr style=PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #00 2px solid; MARGIN-RIGHT: 0px DIV style=FONT: 10pt arial- Original Message - /DIV DIV style=BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: blackBFrom:/B A [EMAIL PROTECTED] href=mailto:[EMAIL PROTECTED]Rahul/A /DIV DIV style=FONT: 10pt arialBTo:/B A [EMAIL PROTECTED] href=mailto:[EMAIL PROTECTED]Multiple recipients of list ORACLE-L/A /DIV DIV style=FONT: 10pt arialBSent:/B Wednesday, March 12, 2003 9:38 PM/DIV DIV style=FONT: 10pt arialBSubject:/B Re: why SAN ? why not external storage ?/DIV DIVBR/DIV DIVFONT face=Arial size=2my reasons
RE: RE: why SAN ? why not external storage ?
All of the places I've worked its been sysadmins fat-fingering that has hosed or cross mounted disks. Then again, we've never had EMC... HP arrays are enough trouble. Scott Shafer San Antonio, TX 210.581.6217 -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED] Sent: Friday, March 14, 2003 12:36 PM To: [EMAIL PROTECTED]; Multiple recipients of list ORACLE-L Subject: Re:RE: why SAN ? why not external storage ? Humm, must of missed this one on the rebound. Anyway, here Disk space is an admin nightmare. Each time we want to reassign disks from one server to another here comes EMC to re-program the Symmetrix array otherwise the SA has the possibility of assigning 2 servers to the same disk. OOPS I really did not wnat to do a newfs on that disk!!!?!??! And at $4000 per disk (72GB) I would not say that their cheap. IDE drives have gotten real cheap, when will SCSI follow suit?? Dick Goulet Reply Separator Subject:RE: why SAN ? why not external storage ? Author: [EMAIL PROTECTED] Date: 3/14/2003 10:03 AM Oh, Gods forbid the sysadmins would have to gulp do their job... HAHAHAHAHA!!! Scott Shafer San Antonio, TX 210.581.6217 -Original Message- From: Mogens Norgaard [SMTP:[EMAIL PROTECTED] Sent: Thursday, March 13, 2003 5:25 PM To: Multiple recipients of list ORACLE-L Subject: Re: why SAN ? why not external storage ? There are many things I don't get in this life. One of them is the statements about disk storage being an admin nightmare and way too expensive. Aren't disks very cheap these days?! Mogens [EMAIL PROTECTED] wrote: Rahul, This is personal opinion, but it looks to me like your concerned about the database your creating for the client and may not have the total or corporate wide view your client has. We're heading down the SAN road not because of any specific database requirements but because disk storage has become an administrative nightmare as well as way too expensive. Dick Goulet Reply Separator Author: Arun Annamalai [EMAIL PROTECTED] Date: 3/13/2003 12:24 PM Usaually SAN and NAS is used for several good reasons...the two main are... 1) High availability - When you have your database files on SAN/NAS then you can bring ur database on another server when the primary goes down. Obviously you have to use a cluster or Big IP (F5) on the front. 2) reduce redundancy -A unix userid with home directory attached to a paticular NFS drive on NAS/SAN, will able to see all his files when he logs into other servers. so far I heard Net App is low cost including with Raid 5. -Arun. Sr oracle dba - Original Message - From: Rahul To: Multiple recipients of list ORACLE-L Sent: Wednesday, March 12, 2003 9:38 PM Subject: Re: why SAN ? why not external storage ? my reasons to recommend an external storage was.. 1) the database size is 36GB, and according to many documents i have read, SAN is not cost effevtive unless populated by a large numbers of drives !!, now for the client the cost is not the factor.. given the situation.. wouldnt a SAN be an overkill ? 2) NO DBA or SYS ADMIN skills to manage the SAN !! - Original Message - From: Tim Gorman To: Multiple recipients of list ORACLE-L Sent: Wednesday, March 12, 2003 8:33 PM Subject: Re: why SAN ? why not external storage ? Can you share some of the reasons related to your decision in choosing a direct-attach storage (DAS) instead of a SAN? In general, a SAN is a much smarter choice than DAS. - Original Message - From: Rahul To: Multiple recipients of list ORACLE-L Sent: Wednesday, March 12, 2003 1:33 AM Subject: why SAN ? why not external storage ? list, one of our clietns are going to by SAN, the current oracle databases take around 36GB of storage i dnt understand there reason to go for SAN, i sugguested to buy an external storage box instead. How can i justify my desicion ? (cost of not the factor) TIA rahul !DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.0 Transitional//EN HTMLHEAD META http-equiv=Content-Type content=text/html; charset=iso-8859-1 META content=MSHTML 6.00.2800.1106 name=GENERATOR STYLE/STYLE /HEAD BODY bgColor=#ff DIVFONT face=Arial size=2Usaually SAN and NAS is used for several good reasons...the two main are.../FONT/DIV DIVFONT face=Arial size=21) High availability - When you have your database files on SAN/NAS then you can bring ur database on another server when the primary goes down. Obviously you have to use a cluster or Big IP (F5) on the front./FONT
RE: DBV Cannot Load Module LIBDCE.A
Sam, I've never worked in a DCE environment, but here's a couple of things toverify: 1. If libdce.a is not installed in the first place, is your environment using DCE? I think this is an LPP (a separately licensed product) from IBM for AIX. Try the following from a unix prompt: $ lslpp -L |grep -i dce I think you should get hits like dce.client.rte.pthreads If you don't, then I wonder why dbv thinks it needs it... Try the following just to make sure you're running the dbv you think you are: $ which dbv It should return $ORACLE_HOME/bin/dbv, for example: $which dbv /u01/app/oracle/product/8.1.7/bin/dbv If it returns the Oracle 'dbv', then you might check the $ORACLE_HOME/rdbms/lib/sysliblist to see if it has an entry for libdce. If so, the product was linked at some point with the DCE Advanced Networking Option (see MetaLink Note 1043700.6 This docnotes the following: NOTE: You may have to manually remove the library reference from "sysliblist". In Oracle 7.3.4, the Installer did not remove the library referenceduring a deinstallation.) In any case, I would be slow to add PTFs or relink or make other changes in a production environment just for the sake of dbv(if the rest of the environment is stable) until I had a better understanding of the opsys environment and the Oracle installation history. HTH, Scott [EMAIL PROTECTED] 3/12/03 5:15:58 PM Hi all,First, thanks Jared for the info.The libdce.a file does not exist on any of our AIX servers. It justAINT there!I typed libdce.a into google and from there downloaded PTF2,3, and 4that are supposed contain DCE fixes to this file. Instructions say torename the old file and replace it with this new file. After the download, I was not able to uncompress the files on my XPworkstation. So I ftp'd the file (in binary mode) to our AIX server andused uncompress to expand the files to libdce2.exe, libdce3.exe,libdce4.exe (originally the files were named libdce2.exe.Z, etc.). The.exe extension confused me (I am told .exe is Windows only, not UNIX). I ftp'd the files back to my workstation, and tried running it from DOS.I get an error message "Program too big to fit in memory". However, theexe is only 217,856 bytes (not kilobytes). My next step was to ask myneighbour if he could unzip the original libdce2.exe.Z on his W2Kworkstation - he was successful! However, he received the same messagewhen he attempted to run the resultant .exe on his workstation. I am relatively new to UNIX (took a course, and did some reading, butnot much hands-on). I am told by a more experience colleague that.exe's do not run on UNIX. So now I am at a loss on what to try next. Any ideas?Thanks,Sam BootsmaGeorge Brown College[EMAIL PROTECTED]416-415-5000 x4933-Original Message-Sent: March 11, 2003 7:14 PMTo: Multiple recipients of list ORACLE-LJust found it: on AIX ( 4.3 at least ) it's LIBPATH[EMAIL PROTECTED]Sent by: [EMAIL PROTECTED]03/11/2003 03:23 PMPlease respond to ORACLE-L To: Multiple recipients of list ORACLE-L[EMAIL PROTECTED] cc: Subject: Re: DBV Cannot Load Module LIBDCE.AMake sure LD_LIBRARY_PATH includes /usr/lib.At least, I think it's LD_LIBRARY_PATH, been awhilesince doing anything on AIX. In any case, libdce.ashould be in /usr/lib.JaredPS. Google is your friend"Sam Bootsma" [EMAIL PROTECTED]Sent by: [EMAIL PROTECTED]03/11/2003 01:44 PMPlease respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject: DBV Cannot Load Module LIBDCE.AWe are running Oracle 7.3.4.5.0 on an IBM/AIX RISC System/6000: Version 2.3.4.0.0. When I attempt to run DBV I get the following error messages$ dbv help=yexec(): 0509-036 Cannot load program dbv because of the followingerrors: 0509-150 Dependent module libdce.a(shr.o) could not be loaded. 0509-022 Cannot load module libdce.a(shr.o). 0509-026 System error: A file or directory in the path name doesnot exist.$I do not want to play around with a custom installation to try toinstall missing components because this is a production database and because Iam new here. The regular DBA is on holidays and not available. I did a search for file "libdce" on the original CD for "Oracle7.3.4.0.0 for AIX based systems", but did not find it there. I considered installing Oracle 7.3.4 on my workstation and ftp'ing the files over thenetwork to my workstation. Then doing the database verify. But total size of the data files is 25 GB, and this would unnecessarily clog upour network (even at night).Any ideas on how I can resolve the DBV problem not loading problem? Theshort answer is to find the module libdce.a file and any modulesdependent on this, but how do I do this?Thanks,Sam [EMAIL PROTECTED]
RE: POLL: Database to DBA ratio
139 remote production servers/instances (30 are large to VLDB, the rest small), 5 development instances, 1 9iAS test instance, 3 dba's. Mostly reporting with batch ETL jobs run nightly. Scott Shafer San Antonio, TX 210.581.6217 -Original Message- From: Robin Ilardi [SMTP:[EMAIL PROTECTED] Sent: Tuesday, March 11, 2003 12:10 PM To: Multiple recipients of list ORACLE-L Subject: RE: POLL: Database to DBA ratio I currently have 5 development databases and 1 beta production database that I administer, so that's 6:1, but I'm also the Sys Admin for these servers as well. These are also very small databases. robin -Original Message- Sent: Tuesday, March 11, 2003 11:44 AM To: Multiple recipients of list ORACLE-L We have 10 development databases that I support directly plus 5 implementation/testing databases that I support as second level and one production snapshot datamart. 16:1 However, there are also DBAs who support each project. That would make the ratio closer to 4:1 or 3:1. Chuck Hamilton chuckh To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] @softhome.net cc: Sent by: rootSubject: POLL: Database to DBA ratio 03/11/2003 09:59 AM Please respond to ORACLE-L I'm trying to build a case for management that we need additional DBAs so I'd like to take a quick poll if I may. What is the ratio of Oracle databases to DBAs in your shop? This includes development and production databases. At our shop it's 33:1. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Chuck Hamilton INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Thomas Day INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Robin Ilardi INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Oracle on a SAN.... Good, Bad or Proceed with caution?
Darrell, Could I have a copy of that white paper if you still have it? Thanks, Scott At 08:19 AM 3/7/03 -0800, you wrote: Amen! For several years we heard from EMC reps, don't worry about it, don't worry about it, then recently we we're given a white paper from EMC on striping for Oracle. [EMAIL PROTECTED] 03/07/03 09:43AM SAN is fine as long as you keep track of what's mapping to what physical disks. I for one don't believe the SAN vendors that say their caching takes care of performance for you and you don't need to worry about where data is stored physically. Place datafiles the same way you would for local storage and you will do well - striped, with data, indexes, temp, and rollback physically separated. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, March 06, 2003 4:39 PM Hello, We are currently spec'ing out hardware for our new ERP system. It is either going to be Peoplesoft or Oracle. We are also debating on using a SAN rather than attached storage. I'm just looking for any positives/negatives/rules of thumb I should be aware of when running Oracle on a SAN architecture provided that management goes that way. The SAN box we are looking at right now is the EVA3000 from HP (although this isn't a definite) not sure if this matters. TIA, -Scott Stefick ** Scott Stefick UNIX Systems Administrator Oracle Certified Professional DBA Wm. Rainey Harper College 847.925.6130 ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Scott Stefick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Chuck Hamilton INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Darrell Landrum INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). ** Scott Stefick UNIX Systems Administrator Oracle Certified Professional DBA Wm. Rainey Harper College 847.925.6130 ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Scott Stefick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 on a SAN.... Good, Bad or Proceed with caution?
That's great! Thanks a ton. -Scott At 10:44 AM 3/7/03 -0800, you wrote: I'm pretty sure I only recieved a hard copy (I'm not in the office to check), but they publish a lot of pdf documents on their site. I'll see if I can locate it there and send a URL. [EMAIL PROTECTED] 03/07/03 10:55AM Darrell, Could I have a copy of that white paper if you still have it? Thanks, Scott At 08:19 AM 3/7/03 -0800, you wrote: Amen! For several years we heard from EMC reps, don't worry about it, don't worry about it, then recently we we're given a white paper from EMC on striping for Oracle. [EMAIL PROTECTED] 03/07/03 09:43AM SAN is fine as long as you keep track of what's mapping to what physical disks. I for one don't believe the SAN vendors that say their caching takes care of performance for you and you don't need to worry about where data is stored physically. Place datafiles the same way you would for local storage and you will do well - striped, with data, indexes, temp, and rollback physically separated. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, March 06, 2003 4:39 PM Hello, We are currently spec'ing out hardware for our new ERP system. It is either going to be Peoplesoft or Oracle. We are also debating on using a SAN rather than attached storage. I'm just looking for any positives/negatives/rules of thumb I should be aware of when running Oracle on a SAN architecture provided that management goes that way. The SAN box we are looking at right now is the EVA3000 from HP (although this isn't a definite) not sure if this matters. TIA, -Scott Stefick ** Scott Stefick UNIX Systems Administrator Oracle Certified Professional DBA Wm. Rainey Harper College 847.925.6130 ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Scott Stefick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Chuck Hamilton INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Darrell Landrum INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). ** Scott Stefick UNIX Systems Administrator Oracle Certified Professional DBA Wm. Rainey Harper College 847.925.6130 ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Scott Stefick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Darrell Landrum INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services
RE: Anyone looking fora Developer/DBA in Wash DC area?
containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). ** Scott Stefick UNIX Systems Administrator Oracle Certified Professional DBA Wm. Rainey Harper College 847.925.6130 ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Scott Stefick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 on a SAN.... Good, Bad or Proceed with caution?
Hello, We are currently spec'ing out hardware for our new ERP system. It is either going to be Peoplesoft or Oracle. We are also debating on using a SAN rather than attached storage. I'm just looking for any positives/negatives/rules of thumb I should be aware of when running Oracle on a SAN architecture provided that management goes that way. The SAN box we are looking at right now is the EVA3000 from HP (although this isn't a definite) not sure if this matters. TIA, -Scott Stefick ** Scott Stefick UNIX Systems Administrator Oracle Certified Professional DBA Wm. Rainey Harper College 847.925.6130 ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Scott Stefick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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:
Anyone? ... Anyone? At 11:50 AM 3/4/03 -0800, you wrote: HELP ** Scott Stefick UNIX Systems Administrator Oracle Certified Professional DBA Wm. Rainey Harper College 847.925.6130 **
Import Problem
I ran into a problem yesterday afternoon. I had exported a production database, via a full database export, and ftp'd it to another machine to import it there and make that the new production machine. It was a long import (about 8 hours) and about 2/3 through it, my network connection was dropped. I was running it in a ssh shell. When the connection disappeared, the import died. Since I had to get the job done by morning, I chose to drop the database, rebuild it, then re-import. That worked. What I am wondering is: Is there a way to resume an import, once it has been interrupted? I have been looking in metalink and on the net and haven't found anything that says how to do it. I tried technet, but it was way too slow. Any thoughts would be greatly appreciated. Thank you, -- Scott Canaan ([EMAIL PROTECTED]) (585) 475-7886 Life is like a sewer, what you get out of it depends on what you put into it. - Tom Lehrer. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Scott Canaan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Purely for your amusement
Thanks! I especially liked: TABLE...FULL OF 'WOE' That seems to be how the day is going for several of us. Scott [EMAIL PROTECTED] 2/27/03 1:23:55 PM And you thought your job was bad . . .(Yes, this IS a production job)-- snipped 22 21 TABLE ACCESS (FULL) OF 'WOE'
Re: UPDATE...REPLACE...#39;...apostrophe...
chr(44) "Gorden-Ozgul, Patricia E" wrote: I'm running Oracle on Solaris 2.6.I successfully inserted data from a composite file by replacing apostrophes with #39; by way of sed...s/'/\#39;/g...beforehand.Now I need to perform an UPDATE, REPLACE...UPDATE tbl SET col = REPLACE(col, '#39;', ...with what?)Please advise.Pat -Original Message- From: Saira Somani [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 25, 2003 3:24 PM To: Multiple recipients of list ORACLE-L Subject: RE: SQL struggle Thank you for your assistance - it works-and I have one more question: How can I also get the SELECT to show me the original item number -i.e with the '-OR'? Thanks, Saira -Original Message- From: Jacques Kilchoer [mailto:[EMAIL PROTECTED]] Sent: February 25, 2003 1:57 PM To: '[EMAIL PROTECTED]' Cc: '[EMAIL PROTECTED]' Subject: RE: SQL struggle (see answer below) > -Original Message- > From: Saira Somani [mailto:[EMAIL PROTECTED]] > > Oracle 8.1.7 on AIX 4.3 > > Here is what my data looks like in a table called item_w: > > WHSE_CODE ITEM_NUM LAST_COST > -- -- > HL1 111230 1.12 > CPD-TWH 111230-OR 0 > CPD-TGH 111230-OR 0 > HL1 50034 .91 > MSH-CDS 50034 0 > CPD-TGH 50034-OR 0 > HL1 650300 4.789 > TWH-STAT 650300 0 > CPD-TWH 650300-OR 0 > CPD-TGH 650300-OR 0 > > If you'll notice, only the items with WHSE_CODE='HL1' have a cost > associated with them. > > What I need to is: > > Parse ITEM_NUM for those items which have a suffix of -OR in order to > compare with an ITEM_NUM without -OR so that I can take the last cost > from there and display it beside the one that has -OR. Also > note, there > are some $0 cost items that don't have a suffix of -OR; I > would need to > match those up with a cost as well. > > So in the end, I suppose, this is the result I'm looking for: > > WHSE_CODE ITEM_NUM LAST_COST LAST_COST_REV > - - - > HL1 111230 1.12 1.12 > CPD-TWH 111230-OR 0 1.12 > CPD-TGH 111230-OR 0 1.12 > HL1 50034 0.91 0.91 > MSH-CDS 50034 0 0.91 > CPD-TGH 50034-OR 0 0.91 > HL1 650300 4.789 4.789 > TWH-STAT 650300 0 4.789 > CPD-TWH 650300-OR 0 4.789 > CPD-TGH 650300-OR 0 > 4.789 > > And if any of you out there use Cognos Impromptu, perhaps you > could tell > me how I can achieve these results in a report. Would this work? select a.whse_code, a.item_num, a.last_cost, b.last_cost as last_cost_rev from item_w a, item_w b where a.last_cost = 0 and replace (a.item_num, '-OR') = b.item_num and b.last_cost > 0 union select c.whse_code, c.item_num, c.last_cost, c.last_cost as last_cost_rev from item_w c where c.last_cost > 0 ; -- Scott Canaan ([EMAIL PROTECTED]) (585) 475-7886 "Life is like a sewer, what you get out of it depends on what you put into it." - Tom Lehrer.
Re: [Q] ORACLE 9iR2 RAC on SUN server no need for SUN Cluster??
Your Oracle sales person is incorrect. I would ask him to see if he can actually prove it. Oracle provides clustering components for Linux and NT only at this time. Oracle does provide a RACpatch for SC2.2 and 3.0 with 9iR2 and that patch needs to be installed after you install SC and before install RAC. Hope this helps, Scott --- dist cash [EMAIL PROTECTED] wrote: I heard from ORACLe sales person the ORACLE 9ir2 RAC come with ORACLE cluster and we don't need SUN cluster. I don't know is it true or NOT? anyone implement that? Thanks. _ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: dist cash INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do you Yahoo!? Yahoo! Tax Center - forms, calculators, tips, more http://taxes.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Scott INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: [Q] ORACLE 9iR2 RAC on SUN server no need for SUN Cluster??
Greg, Sorry to be picky but you can still use raw Devices with Veritas DBE/AC 3.5 if you don't want to use thier CFS. If you use SC then your only choice is raw and you probably will need Veritas to manage you LVM's anyway. Scott --- Loughmiller, Greg [EMAIL PROTECTED] wrote: news to me... Just had a conversation with several folks yesterday.. The requirements that we have been told are: 1. File systems-use veritas Cluster manager 2. Raw Devices - Gotta use the SUN Cluster 3.x So I assume these guys would be on top of it since the mtg we had was this past week.. Our POC was with Veritas; and the options for implementation are listed above... Hope this helps-and please, if you have confirmation otherwise-it would be very interesting info to obtain. Thanks! Greg -Original Message- Sent: Friday, February 21, 2003 11:16 AM To: Multiple recipients of list ORACLE-L I heard from ORACLe sales person the ORACLE 9ir2 RAC come with ORACLE cluster and we don't need SUN cluster. I don't know is it true or NOT? anyone implement that? Thanks. _ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: dist cash INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do you Yahoo!? Yahoo! Tax Center - forms, calculators, tips, more http://taxes.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Scott INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
lsnrctl status
Hello all, HPUX 11.11 Oracle 8174, 9201 and 9iAS 90201 I have all three versions in their own homes and I have a login script that asks what I want the environment to be set as upon login (ORACLE_HOME, ORACLE_SID, etc) but I always set TNS_ADMIN=/u01/app/oracle/product/9201/network/admin for all three environments. When I do a $lsnrctl status while in the 9201 or 90201 environments, I see all of the services. But when I'm using the 8174 environment setup and do the same, for the services, I get: /* Message 1411 not found; product=network; facility=TNS Message 1408 not found; product=network; facility=TNS Message 1411 not found; product=network; facility=TNS Message 1408 not found; product=network; facility=TNS Message 1411 not found; product=network; facility=TNS Message 1408 not found; product=network; facility=TNS */ Does anyone have any ideas why this could be happening? I want to be able to be in any one of the environments and see the services. TIA, -Scott ** Scott Stefick UNIX Systems Administrator Oracle Certified Professional DBA Wm. Rainey Harper College 847.925.6130 ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Scott Stefick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: lsnrctl status
The ORACLE_HOME is being exported. Here is the contents of the script that I call to set the 8174 environment upon login: /* ORACLE_BASE=/u01/app/oracle ORACLE_HOME=/u01/app/oracle/product/817 ORACLE_SID=FPRD LD_LIBRARY_PATH=$ORACLE_HOME/lib TNS_ADMIN=/u01/app/oracle/product/9201/network/admin export ORACLE_BASE ORACLE_HOME ORACLE_SID LD_LIBRARY_PATH TNS_ADMIN PATH=$ORACL_HOME/bin:$PATH export PATH */ The 9i login environment script look the same except for: ORACLE_HOME=u01/app/oracle/product/9201 ORACLE_SID=REGENTDB Thanks, Scott At 11:24 AM 2/19/03 -0800, you wrote: You forgot to export new ORACLE_HOME. -Original Message- From: Scott Stefick [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 19, 2003 12:04 PM To: Multiple recipients of list ORACLE-L Subject: lsnrctl status Hello all, HPUX 11.11 Oracle 8174, 9201 and 9iAS 90201 I have all three versions in their own homes and I have a login script that asks what I want the environment to be set as upon login (ORACLE_HOME, ORACLE_SID, etc) but I always set TNS_ADMIN=/u01/app/oracle/product/9201/network/admin for all three environments. When I do a $lsnrctl status while in the 9201 or 90201 environments, I see all of the services. But when I'm using the 8174 environment setup and do the same, for the services, I get: /* Message 1411 not found; product=network; facility=TNS Message 1408 not found; product=network; facility=TNS Message 1411 not found; product=network; facility=TNS Message 1408 not found; product=network; facility=TNS Message 1411 not found; product=network; facility=TNS Message 1408 not found; product=network; facility=TNS */ Does anyone have any ideas why this could be happening? I want to be able to be in any one of the environments and see the services. TIA, -Scott ** Scott Stefick UNIX Systems Administrator Oracle Certified Professional DBA Wm. Rainey Harper College 847.925.6130 ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Scott Stefick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). ** Scott Stefick UNIX Systems Administrator Oracle Certified Professional DBA Wm. Rainey Harper College 847.925.6130 ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Scott Stefick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: lsnrctl status
I do set the ORACLE_HOME and export the variable upon login. What is the ORACLE_HOME_SELECTOR? At 10:44 AM 2/19/03 -0800, you wrote: You need to change your ORACLE_HOME for the 8.1.7.4 environment. Look for the ORACLE_HOME_SELECTOR. Mine is under ORACLE_INSTALLED_PRODUCTS. Scott Stefick sstefickTo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] @harpercollege.e cc: du Subject: lsnrctl status Sent by: root 02/19/2003 12:04 PM Please respond to ORACLE-L Hello all, HPUX 11.11 Oracle 8174, 9201 and 9iAS 90201 I have all three versions in their own homes and I have a login script that asks what I want the environment to be set as upon login (ORACLE_HOME, ORACLE_SID, etc) but I always set TNS_ADMIN=/u01/app/oracle/product/9201/network/admin for all three environments. When I do a $lsnrctl status while in the 9201 or 90201 environments, I see all of the services. But when I'm using the 8174 environment setup and do the same, for the services, I get: /* Message 1411 not found; product=network; facility=TNS Message 1408 not found; product=network; facility=TNS Message 1411 not found; product=network; facility=TNS Message 1408 not found; product=network; facility=TNS Message 1411 not found; product=network; facility=TNS Message 1408 not found; product=network; facility=TNS */ Does anyone have any ideas why this could be happening? I want to be able to be in any one of the environments and see the services. TIA, -Scott ** Scott Stefick UNIX Systems Administrator Oracle Certified Professional DBA Wm. Rainey Harper College 847.925.6130 ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Scott Stefick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Thomas Day INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). ** Scott Stefick UNIX Systems Administrator Oracle Certified Professional DBA Wm. Rainey Harper College 847.925.6130 ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Scott Stefick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Teradata baned from IOUG???
Soon you too will be assimilated. The TUSC Collective will add your distinctiveness to its own. --Seven of Nine-Hundred Ninety-Nine -Original Message- From: Daniel W. Fink [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, February 18, 2003 12:59 PM To: Multiple recipients of list ORACLE-L Subject: Re: Teradata baned from IOUG??? I know Stan Yellott is not a TUSC employee. He is the President of RMOUG and a great guy who has worked behind the scenes at many IOUG conferences. He is a tremendous calming influence (as many of us recall from San Diego). I don't think Ian, Mark, Bill, Stephen or Steve are TUSC Employees, unless they have changed jobs recently. Henry Poras wrote: Anyone know if any of the 10 people running for the Board of Directors for IOUG is a TUSC employee? Noone claims it in their statements. Henry -Original Message- Sent: Tuesday, February 18, 2003 12:24 PM To: Multiple recipients of list ORACLE-L me too... Igor Neyman, OCP DBA [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Sent: Tuesday, February 18, 2003 11:11 AM evidently i'm not the only one who thinks that, interesting. joe It seems to me that IOUG has become a wholly owned subsidiary of TUSC. TUSC in turn has an incestuous relationship with Oracle. All very cozy. No real complaint about the arrangements. Someone has to step up to the plate if IOUG is going to continue to be a viable organization and in this economic climate few can afford to do it. Should IOUG be able to survive without Oracle? Probably. Will it be able to survive without Oracle? I doubt it. --- Jonathan Lewis [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] wrote: It should be possible for the IOUG to live without Oracle's support. Obviously it would be better for all concerned if there is some measure of co-operation, and there's clearly no need for bloody-minded conflict. But if the IOUG just keeps doing things that the users want, then the users should be able to support it in the complete absence of any input from Oracle. Regards Jonathan Lewis http://www.jlcomp.demon.co.uk Coming soon one-day tutorials: Cost Based Optimisation Trouble-shooting and Tuning Indexing Strategies (see http://www.jlcomp.demon.co.uk/tutorial.html ) UK___March 19th USA_(FL)_May 2nd Next Seminar dates: (see http://www.jlcomp.demon.co.uk/seminar.html ) USA_(CA, TX)_August The Co-operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html MacGregor, Ian A. wrote: The IOUG cannot live without Oracle's support, but Oracle can survive without the IOUG. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jonathan Lewis INET: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services
Re: Programming languages that make DBA's lives easier
I tend to agree here. I would say: 1. PL/SQL 2. korn shell (or sh, bash, whatever you choose). 3. Perl These are 3 necessities. -Scott At 09:59 AM 2/18/03 -0800, you wrote: You need to know PL/SQL if you're going to be effective with Oracle. Java is interesting, but not nearly as useful to a DBA as Perl. Jared On Tuesday 18 February 2003 08:56, Les Ayudo wrote: On top of learning Oracle, which programming languages would also benefit some1 learning Oracle? Perl? Java? How would these languages be used? Content-Type: text/html; charset=iso-8859-1; name=Attachment: 1 Content-Transfer-Encoding: quoted-printable Content-Description: -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). ** Scott Stefick UNIX Systems Administrator Oracle Certified Professional DBA Wm. Rainey Harper College 847.925.6130 ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Scott Stefick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Oracle 8i or 9i ?
). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Les Ayudo INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Add photos to your messages with MSN 8. Get 2 months FREE*. http://join.msn.com/?page=features/featuredemail -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: david davis INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Markus Reger INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Les Ayudo INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). ** Scott Stefick UNIX Systems Administrator Oracle Certified Professional DBA Wm. Rainey Harper College 847.925.6130 ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Scott Stefick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Oracle 8i or 9i ?
Les, It depends on what version of Oracle Databases you will be working with. You won't miss out on information going through the 9i Class because they will go over features from 8i as well. They are conclusive of features that have been available before 9i (as long as they are still in 9i). The only way you would miss out on 8i features is if you took the 9i New Features class, because that is strictly 9i. If you are doing it for a career change and you have not worked with Oracle at all before, I suggest that you not only take the classes, but download a version of Oracle at home and run through all kinds of examples from your classes, including backup and recovery scenerios, putting a load on your database and tuning performance, creating and deleting users, objects, stored procedures, sql and pl/sql scripts and Oracle networking. So back to your question. I would probably suggest taking the 9i courses. I took the 8i courses because they were the New Version when I started. This helped me a lot in my learning process and I would recommend it to anyone. So far I think it's a great field and I think its the best career decision I've made to this point. Good luck, -Scott At 07:23 AM 2/14/03 -0800, you wrote: Hello, I'm thinking of going to school to get Oracle certified. There are 2 schools in my area that are offering Oracle certs but one offers Oracle 8i courses w/ an upgrade to 9i, while the other offers all 9i courses. If i go to the schools who offers 9i courses, would I miss out on valuable 8i knowledge? Which school should I attend? The courses will last about 7 or 8 months. Also, is this a good in demand field to get into? What chances am I looking at to getting hired as a newbie DBA once I graduate? I want to get into the Ecommerce side of Oracle (connecting DBs to websites/portals?). Which certification/path should I be following? Thanks in advance!! ** Scott Stefick UNIX Systems Administrator Oracle Certified Professional DBA Wm. Rainey Harper College 847.925.6130 **
Re: URL for Oracle 9i entry level email lists
Les, I definitely think its worth sticking around here. I'm still considered a newbie here and I've learned tons from everyones posts. It's a great group of people who really know their stuff and as long as you do your basic research on your own (RTFM), most questions are answered very sufficiently. I've been extremely happy with this list. Not to mention you will get some really good tips on books and websites to check out. Oh yeah, and there are several authors of some really good books on the list as well. I've seen questions from all levels of DBA's on this list, so don't give up if you really want to work with Oracle. -Scott At 08:44 AM 2/14/03 -0800, you wrote: This list seems at like it's a little too advanced for a beginner. Do you think I should just stick with it for a while to get familiar w/ some of the Oracle stuff? - Original Message - From: Jamadagni, Rajendra To: Multiple recipients of list ORACLE-L Sent: Friday, February 14, 2003 7:34 AM Subject: RE: URL for Oracle 9i entry level email lists This list deals with ALL oracle related issues ... so why you want another one? 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: Les Ayudo [mailto:[EMAIL PROTECTED]] Sent: Friday, February 14, 2003 10:19 AM To: Multiple recipients of list ORACLE-L Subject: URL for Oracle 9i entry level email lists I want to subscribe to an entry level Oracle mailing list. Do any of you know any good ones? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Les Ayudo INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). ** Scott Stefick UNIX Systems Administrator Oracle Certified Professional DBA Wm. Rainey Harper College 847.925.6130 **
RE: AIX Oracle 9.2
How about relink all from the $OH/bin directory? Or is this utility gone in 9i? Scott Shafer San Antonio, TX 210.581.6217 -Original Message- From: Tim Gorman [SMTP:[EMAIL PROTECTED]] Sent: Thursday, February 13, 2003 10:14 AM To: Multiple recipients of list ORACLE-L Subject: Re: AIX Oracle 9.2 At least you're going to want to relink everything in Oracle on the server. Go to $OH/rdbms/lib and make -f ins_rdbms.mk install. Also go to $OH/network/lib and make -f ins_netserver.mk install. In fact, do a find for all files named ins_*.mk and consider whether to do similar steps... - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, February 13, 2003 8:03 AM If I have Oracle 9.2 on AIX 4.3.3 and we upgrade to AIX 5.1, do I need to re-install the Oracle 9.2 software or will it all just work after the upgrade? Anybody know? Keith H. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Henry, Keith INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tim Gorman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: No redo or archived log files
The last cold backup. At 12:09 PM 2/13/03 -0800, you wrote: Hi All, One of my friends has a database crash. He has no backup of online redo and archived log files. His question is How do you recover the database if all the online redologfiles and all archived files are lost ? Don't ask me why he did not have any backups or mirror online redo. Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). ** Scott Stefick UNIX Systems Administrator Oracle Certified Professional DBA Wm. Rainey Harper College 847.925.6130 ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Scott Stefick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: rootpre.sh
David, I haven't installed Oracle 8.1.7 or 9.2 to AIX 5.1 yet, but thanks to a data storage interrupt kernel panic on a 5.1 box, I do know that 'crash' has been replaced by 'kdb' for examining crash dumps. So, rootpre.sh is going to break on the line 'PKEXT_PATH='echo le | crash | blah blah blah...' I think the question is - do you need the post-wait kernel extension at AIX 5.1? I don't know about Oracle 8.1.7, but the 9.2 Installation Guide (p. 2-35) says: "For Oracle9i 9.2.0.1.0 on AIX 5L, the functon and performance benefits of the Oracle post-wait kernel extension are incorporated into the AIX kernel. Oracle 9i 9.2.0.1.0 on AIX 5L does not require the Oracle post-wait kernel extension to be loaded." (This begs the question as to whether I still wouldneed to run rootpre.sh for asyncronous I/O configuration. Presumably, I could use smit to configure async I/O.) It seems to me I read somewhere that 8.1.7 still requires a 32-bit kernel extension and therefore, you may not be able to run a 64-bit AIX kernel with 8.1.7. Scott [EMAIL PROTECTED] 2/11/03 12:59:53 PM I am trying to run rootpre.sh. My admin just upgrade the kernel to 64-bit.We were running 32-bit on this box and everything was fine. No Oraclesoftware is running. I am going to install 64-bit 8.1.7 Ent Ed for AIX 5.1Lwhen I got this trying to run rootpre.sh.This is what I get when I run:#./rootpre.sh Installing kernel extension... Oracle Kernel Ext... Copyright Kernel Extension Version: 3 nkext ver: 3 ./rootpre.sh[199]: crash: not found. is not loaded : 1 No post-wait kernel is loaded on the machine. Copying new kernel extension. Oracle Kernel Extension Loader for AIX Copyright. Kernel Extension Version: 3 SYS_SINGLELOAD: Exec format error kmid: 0 (0x0) path '/etc/pw-syscall' libpath:'' Configuring Asynchronous I/O... Asynchronous I/O is already defined thanks,David Ehresmann -- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: Ehresmann, David 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).
RE: multiple oracle homes
I tend to agree also, just because of confusion. We are running on one server, 817 (1 instance), 9201 (1 instance), 9iASRel 2 (1 instance) and on the second server we have 817 (2 instances), 9201 (1 instance), 9iAS Ver 102 (1 instance). So at first we tried different user names: oracle8i (817 instances) oracle9i (9201 instances) oraias (9iAS Ver 102) ora9ias (9iAS Rel 2) This just got too confusing, so I wrote a script and placed it in the oracle .profile which creates a menu for the Admin logging in to choose (by number) which instances environment variables they want set. Then it calls another script depending on the choice to set those variables and echo them to verify by using: env | grep ORA env | grep TNS This has been working ok so far, but if anyone has any better suggestions, let me know. -Scott At 10:34 AM 2/7/03 -0800, you wrote: I agree with Dennis. We tried this several years ago and decided it was best to stick with one username. I forget what the exact issues were - it might have been file privileges when you are upgrading a database. Jay [EMAIL PROTECTED] 02/07/03 10:54AM Ray - My 2 cents worth. Don't ever use another username besides Oracle. Had a bad experience :-) Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, February 07, 2003 8:24 AM To: Multiple recipients of list ORACLE-L On Thu, Feb 06, 2003 at 05:08:55AM -0800, Ray Stell wrote: Where is it well documented how to install multiple server versions, 8i and 9i, on the same unix server? -- Thanks for you replies. I've never tried this before and it seems like there are two different approaches on the surface: 1. use two different userids, ora817 and ora920, to do the install. This seems stupid, since it replicates the product directory structure and oraInventory stuff under different ownership. This might be safer since it is like running one version in that everything is seperate, but maybe there are operational issues to not using the oracle userid. Seems like there may be a gotcha waiting in the wings. Like maybe you can't run the same listener for both, or worse. 2. use the same oracle userid for both installs and change the environment vars as needed. Seems like you could damage the first install if you made a mistake. Also, it seems like in a stressful failure situation you don't want to have to think about who's on first? I don't know, third base. Are both paths valid? **DISCLAIMER This e-mail message and any files transmitted with it are intended for the use of the individual or entity to which they are addressed and may contain information that is privileged, proprietary and confidential. If you are not the intended recipient, you may not use, copy or disclose to anyone the message or any information contained in the message. If you have received this communication in error, please notify the sender and delete this e-mail message. The contents do not represent the opinion of DE except to the extent that it relates to their official business. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jay Hostetter INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). ** Scott Stefick UNIX Systems Administrator Oracle Certified Professional DBA Wm. Rainey Harper College 847.925.6130 ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Scott Stefick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: AIX 4.3.3 / 8.1.7 Timed Statistics Tuning Question
Lisa, I have had TIMED_STATISTICS set to true on 5 different 8.1.7 databases (4 at 8.1.7.4 (64-bit), one at 8.1.7.0 (32-bit)) on 3 different servers for some timewith no perceived problems. These servers are either at AIX maintenance level 9 or 10. I have struggled with swap space consistently growinguntil memory is exhausted on one of these servers. It is at AIX 4.3.3 maintenance level 9. There is a memory leak in fclose() at this level that I think is causing the problem. Refer to APAR IY22308. You don't mention whether the databases are on jfs file systems or not. If so, be aware that the 'fre' column of the 'vmstat' command will typically be small, since some real memory is used as acache for file system data. (And thevirtual memory management page stealer takes a lazy approach, only stealing tokeep the free list above the 'minfree' value.) IBM has a white paper on paging space that may help: http://www-1.ibm.com/servers/aix/products/aixos/whitepapers/pagingspace.pdf Also, the following commands with give the top 5 users of memory and paging space, respectively: svmon -Put 5 svmon -Pgt 5 Haven't worked with PeopleSoft, so I can't speak to its effect. Hope this was relevant, Scott [EMAIL PROTECTED] 2/6/03 9:23:58 AM Good morning everyone - Quick poll for those of you on 8.1.7 and AIX 4.3.3: Do you have TIMED_STATISTICS = true? Have you encountered any problems with it? The databases I inherited have this set false all over the place, hence my tuning efforts are really limited. However I don't want to change it without checking around first. And a tuning question: This environment (peoplesoft) is very very low on memory. When the app servers and databases are up there's less than 50MB of memory free. Adding hardware is not a choice here. The databases have 100MB set for the SGA. It really looks like not much thought went into some of the parm settings. What I've read about tuning says that you must have a goal in mind. Well, afaik nothing is "broken", nothing is suffering - then again, no one really paid much attention to Oracle. It was up, fine, move on. Am I on the wrong path if my goal for tuning is to figure out if I can reduce the size of the SGA and redo logs without adversely affecting performance? Any comments are appreciated. Thanks everyone
RE: Update NT to 2000 Server
First off I am an NT/Win2k admin and I fully agree with you Jared. Blow the partition and start from zero, you'll be happy you did. Scott First off, I am not an NT/Win2k admin, and don't even play one on TV. The advice from every SA I've asked about this, and from searching the web, is don't do it. Rebuild the box. There are remnants of NT left if you do an upgrade, and you don't really want that, do you? Jared Breno A. K. Magnago [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 02/06/2003 08:54 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Update NT to 2000 Server Hello, I'd like to update my server (Windows NT) to Windows 2000 Server. I have a Oracle Database 9i in this machine. Does anyone know any kind of problem in this operation (database compatible) ? Thank. -- Breno A. K. Magnago mailto:[EMAIL PROTECTED] Mercantil de Alimentos Soares -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Breno A. K. Magnago INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hayes, Scott INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: AIX 4.3.3 / 8.1.7 Timed Statistics Tuning Question
Lisa, Try oslevel -r at the command promt. It should tell you. -Scott At 09:49 AM 2/6/03 -0800, you wrote: Hi Ethan, Thanks so much for your reply. I'll have to check which patch level we are on. Have a great day! Lisa -Original Message- From: Post, Ethan [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 06, 2003 11:05 AM To: Multiple recipients of list ORACLE-L Subject: RE: AIX 4.3.3 / 8.1.7 Timed Statistics Tuning Question No problems here AIX 4.3.3 ML9 Oracle 8.1.7 64 bit. Lisa, Be aware that there are some issues with ML9 as I am finding out with swap. We are planning on going to ML10 which should fix the problem as well as using vmtune command to change the system to use less OS Cache for files, I forgot the exact syntax. Happily the problem on these boxes is rare and no one complains so I am not rushing to make the changes but if you are running app servers on the same host you could see this a lot possibly. Search the AIX group on google for vmtune oracle and also check out the new Database Tuning book at IBM Redbooks, it was released in the past couple of weeks so it should be easy to find. It talks about all the vmtune settings. Also we are seeing issues with some of the psoft processes (Solaris app server) using up all the memory on the box when one of the jobs is run (not sure which one), appears to be a memory leak of some sort, we are working on it (just a note, the peoplesoft environment is not the AIX environment I spoke about). - Ethan -Original Message- From: Koivu, Lisa [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 06, 2003 8:24 AM To: Multiple recipients of list ORACLE-L Subject: AIX 4.3.3 / 8.1.7 Timed Statistics Tuning Question Good morning everyone - Quick poll for those of you on 8.1.7 and AIX 4.3.3: Do you have TIMED_STATISTICS = true? Have you encountered any problems with it? The databases I inherited have this set false all over the place, hence my tuning efforts are really limited. However I don't want to change it without checking around first. And a tuning question: This environment (peoplesoft) is very very low on memory. When the app servers and databases are up there's less than 50MB of memory free. Adding hardware is not a choice here. The databases have 100MB set for the SGA. It really looks like not much thought went into some of the parm settings. What I've read about tuning says that you must have a goal in mind. Well, afaik nothing is broken, nothing is suffering - then again, no one really paid much attention to Oracle. It was up, fine, move on. Am I on the wrong path if my goal for tuning is to figure out if I can reduce the size of the SGA and redo logs without adversely affecting performance? Any comments are appreciated. Thanks everyone Lisa Koivu Oracle Dingbat Administrator Fairfield Resorts, Inc. 5259 Coconut Creek Parkway Ft. Lauderdale, FL, USA 33063 Office: 954-935-4117 Fax: 954-935-3639 Cell: 954-683-4459 ** Scott Stefick UNIX Systems Administrator Oracle Certified Professional DBA Wm. Rainey Harper College 847.925.6130 **
Export / Import
Hello, OS Version: HP-UX 11i DB Version: Oracle 8.1.7.4 and 9.2.0.1 I've been looking around and I cannot seem to find a difinitive guide online about Oracle's Export and Import. I'm looking for all of the parameters and what they do. Could anyone point me in the right direction. Thanks, -Scott ** Scott Stefick UNIX Systems Administrator Oracle Certified Professional DBA Wm. Rainey Harper College 847.925.6130 ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Scott Stefick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
export/import
Never mind. After I posted, I found a good website that included all of what I was looking for. Just incase anyone else wants that kind of info, here is the link: http://www.csis.gvsu.edu/GeneralInfo/Oracle/server.920/a96652/part1.htm Thanks, -Scott ** Scott Stefick UNIX Systems Administrator Oracle Certified Professional DBA Wm. Rainey Harper College 847.925.6130 ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Scott Stefick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: STATSPACK
See: http://www.oracle.com/oramag/oracle/00-Mar/index.html?statspack-other.html and related articles. Scott Shafer San Antonio, TX 210.581.6217 -Original Message- From: Stephen Andert [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, January 29, 2003 3:49 PM To: Multiple recipients of list ORACLE-L Subject: RE: STATSPACK Ruth, I've heard people talk about downgrading the statspack scripts to earlier versions, but I've never done it. Try searching downgrade STATSPACK on Metalink and OTN for starters. Good luck Stephen [EMAIL PROTECTED] 01/29/03 12:59PM I believe that an 8.1.7 statspack can run on an Oracle8 or higher database. Dave -Original Message- Sent: Wednesday, January 29, 2003 12:54 PM To: Multiple recipients of list ORACLE-L Hello everyone, I hope this is a quick question. Can you run 8.1.7 Statspack on an 8.0.6.3 instance? Thanks in advance, Ruth -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Farnsworth, Dave INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Andert INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Perl - Was Unix time conversion function
What's the title of Jared's book? -Scott At 05:03 AM 1/28/03 -0800, you wrote: I used to be, but I finally bit the bullet ... I ordered my copy of Jared's book from Amazon.com yesterday !! 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: Robert Freeman [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 28, 2003 1:40 AM To: Multiple recipients of list ORACLE-L Subject: Perl - Was Unix time conversion function Cary I once thought I wanted to do some Perl coding... So I bought a book and started to play with it. It made my head bleed... literally I had little droplets of blood emerging from my head They rushed me to the hospital and put me in the Perl ward where I languished for days on IV's of Mountain Dew and pulverized Ritz crackers. it was close. In my mind there is nothing obvious about Perl, this coming from and old C coder who did pointers and linked lists in his sleep years ago. I don't know, maybe I was having a bad day and it's time to get my learning Perl book out again Anyone else feel that way about Perl or am I a lone wolf in a Perl world? RF ** Scott Stefick UNIX Systems Administrator Oracle Certified Professional DBA Wm. Rainey Harper College 847.925.6130 **
RE: AUTORAID and VA7100 disk arrays for rp7400
We are using the VA7100's and VA7400's. They are several orders of magnitude faster than the old 12H AutoRAID arrays if configured properly. I'm no expert, but I know the VA7X00's combine some caching technology with faster IO channels. Scott Shafer San Antonio, TX 210.581.6217 -Original Message- From: david hill [SMTP:[EMAIL PROTECTED]] Sent: Thursday, January 23, 2003 4:56 PM To: Multiple recipients of list ORACLE-L Subject: RE: AUTORAID and VA7100 disk arrays for rp7400 Yep I have same thing to say We have a HP N class with 3 HP AutoRaid's I recently did a test to import our 50 gig database On the HP it took 4 hours to do a Full export of DB and 12+ hours to import I then proceeded to import the exact same dump file on a little Linux Xeon test box with IDE HD's just 2 120 Gig mirrored yes that right IDE. And to import the full DB took 4 Hours!!! Those IDE HD's cost $300 each And those AutoRaids are costing us $1000 a month in support alone. So we will soon changing out IO subsystem that cost's a lot less, has more storage, and better performance. -Original Message- From: Vergara, Michael (TEM) [ mailto:[EMAIL PROTECTED]] Sent: Thursday, January 23, 2003 4:40 PM To: Multiple recipients of list ORACLE-L Subject: RE: AUTORAID and VA7100 disk arrays for rp7400 I'm not sure what a VA7100 is, so I don't want to tell you to avoid it. The AutoRaid I used just said AutoRaid on the front. It had 12 disks...I think they were 9G or 18G each. It had only 96M of cache, not expandable. Only 2 SCSI channels - not expandable. What happened was that our whole database was on this array. Yes, even on-line and archived redo logs. The array did so much internal thrashing that the disk response times were abysmal. RANT The boss got it cause he didn't want to pay the extra $$$ for a 'real' array from EMC, Hitachi, or IBM. It had the magic word 'Raid' in the name so he went for it, and then was all over me because the system was so slow. I should'a known what was up when a JBOD D-370 2-way did stuff faster than our K570 6-way and the AutoRaid. /RANT Take my advice - don't go with an AutoRaid. Cheers, Mike -Original Message- Sent: Thursday, January 23, 2003 12:45 PM To: Multiple recipients of list ORACLE-L Michael, a dumb question. does this stops me from using VA7100 with 0+1 or are u talking about going some other disk array product? Thanks Mandar -Original Message- From: Vergara, Michael (TEM) [ mailto:[EMAIL PROTECTED]] Sent: Thursday, January 23, 2003 12:00 PM To: Multiple recipients of list ORACLE-L Subject: RE: AUTORAID and VA7100 disk arrays for rp7400 Apologies to all for shouting, but ... DO NOT USE AUTORAID! ** *** *** * I used an AutoRaid system when I was at Petco. Performance was el-sucko. There was more I/Os happening in the disk array (by observing the disk lights) than was being caused by the application and database. Plus, when the AR system Raid 0+1/5 mode, where some blocks are kept in a RAID 0+1 area and some are kept in a RAID 5 area, the array got so busy swapping one for another that it was virtually useless. Fiber channel (FC-10) works ok, Clariion (by EMC) works Ok, heck, even JBOD works better than AutoRaid. Just my 2¢ worth. Cheers, Mike -Original Message- Sent: Thursday, January 23, 2003 11:35 AM To: Multiple recipients of list ORACLE-L Hi, i am in the process of defining the specs for a rp7400. a lil overwhelmed by the storage offerings from HP. i wanted to know if any of ull hv any inputs regarding a disk array. we currently hv a Model 30/FC disk array with 9gig drives. I am looking for a similar or the next higher configuration disk array from HP. Any inputs regarding VA7100 disk array or corresponding competetive disk aray from HP/competitor? cache size 256/512/1024 MB? dont know which to go. thinking of going for 18GB 15k rpm rather than 36GB 15K rpm. faster smaller drives. the va7100 product specs on HP site mention more about AutoRAID (which is dynamic 0+1 or 5 configuration on the fly). any inputs on AutoRAID for Oracle database files. hv ull used 0+1 h/w configuration on VA7100? am i talking sense? a good article to read, especially page 4 http://www.hp.com/products1/storage/products/disk_arrays/infol ibrary/hp_va_and_san_virtualization.pdf any inputs related to configuring a rp7400 are invited. my initial specs based on my current k570 is below. current k570 (7.3.4) 4 * 200Mhz 2 gn ram specs for rp7400 (8i/9i) 4 * 550MHz 6 Gb ram and i thought it was easy. take a few procs add ram add few disks, (Baaam!) make sound and license and u hv a server. but look into a detailed partlist
Re: ORA-29702: error occurred in Cluster Group Service operation
Sean, Have you installed the hang-check-timer RPM? If you have installed hangcheck are you loading the hangcheck module? insmod hangcheck-timer hangcheck_tick=TICK hangcheck_margin=MARGIN Scott --- From [EMAIL PROTECTED] wrote: Hello all... I'm running 9iRAC 9.2.0.2 on Linux 2.4.20 kernel. This is based on the Oracle Linux+Firewire project: http://otn.oracle.com/tech/linux/open_source.html I'm getting the ORA-29702 during database create. Any ideas? Sean -- sqlplus, create database -- SQL onnect / as sysdba; Connected to an idle instance. SQL startup nomount; ORACLE instance started. Total System Global Area 135336428 bytes Fixed Size 451052 bytes Variable Size 96468992 bytes Database Buffers 37748736 bytes Redo Buffers 667648 bytes SQL create database EASTWEST maxinstances 5 maxlogfiles 10 character set we8iso8859p1 datafile '/ocfs/oradata/EASTWEST/sysEASTWEST01.dbf' size 500m reuse default temporary tablespace tempts tempfile '/ocfs/oradata/EASTWEST/tmpEASTWEST01.dbf' size 50m reuse undo tablespace UNDO_WEST datafile '/ocfs/oradata/EASTWEST/undEASTWEST01.dbf' size 50m reuse logfile '/ocfs/oradata/EASTWEST/logEASTWEST01a.dbf' size 25m reuse, '/ocfs/oradata/EASTWEST/logEASTWEST01b.dbf' size 25m reuse; 23456789 10 11 create database EASTWEST * ERROR at line 1: ORA-01501: CREATE DATABASE failed ORA-29702: error occurred in Cluster Group Service operation -- cm.log output -- oracm, version[ 9.2.0.2.0.41 ] started {Wed Jan 8 02:39:05 2003 } OemNodeConfig(): Network Address of node0: 192.168.0.9 (port 9998) {Wed Jan 8 02:39:05 2003 } OemNodeConfig(): Network Address of node1: 192.168.0.8 (port 9998) {Wed Jan 8 02:39:05 2003 } WARNING: OemInit2: Opened file(/ocfs/oradata/foo 8), tid = main:8192 file = oem.c, line = 491 {Wed Jan 8 02:39:05 2003 } InitializeCM: ModuleName = iofence-timer {Wed Jan 8 02:39:05 2003 } InitializeCM: Kernel module iofence-timer is not loaded, try to load(/sbin/insmod iofence-timer) {Wed Jan 8 02:39:05 2003 } ClusterListener (pid=13717, tid=24580): Registered with watchdog daemon. {Wed Jan 8 02:39:05 2003 } WARNING: InitializeCM: Kernel module iofence-timer cannot be loaded, please check if the module is in system lib path., tid = main:8192 file = cmstartup.c, line = 311 {Wed Jan 8 02:39:08 2003 } CreateLocalEndpoint(): Network Address: 192.168.0.9 {Wed Jan 8 02:39:08 2003 } NMEVENT_SUSPEND [00][00][00][00][00][00][00][01] {Wed Jan 8 02:39:13 2003 } HandleUpdate(): SYNC(0) from node(0) completed {Wed Jan 8 02:39:15 2003 } HandleUpdate(): NODE(0) IS ACTIVE MEMBER OF CLUSTER {Wed Jan 8 02:39:15 2003 } NMEVENT_RECONFIG [00][00][00][00][00][00][00][01] {Wed Jan 8 02:39:15 2003 } Successful reconfiguration, 1 active node(s) node 0 is the master, my node num is 0 (reconfig 1) {Wed Jan 8 02:39:15 2003 } oracm, version[ 9.2.0.2.0.41 ] started {Wed Jan 8 02:44:00 2003 } OemNodeConfig(): Network Address of node0: 192.168.0.9 (port 9998) {Wed Jan 8 02:44:00 2003 } OemNodeConfig(): Network Address of node1: 192.168.0.8 (port 9998) {Wed Jan 8 02:44:00 2003 } WARNING: OemInit2: Opened file(/ocfs/oradata/foo 8), tid = main:8192 file = oem.c, line = 491 {Wed Jan 8 02:44:00 2003 } InitializeCM: ModuleName = iofence-timer {Wed Jan 8 02:44:00 2003 } InitializeCM: Kernel module iofence-timer is not loaded, try to load(/sbin/insmod iofence-timer) {Wed Jan 8 02:44:00 2003 } ClusterListener (pid=13800, tid=24580): Registered with watchdog daemon. {Wed Jan 8 02:44:00 2003 } WARNING: InitializeCM: Kernel module iofence-timer cannot be loaded, please check if the module is in system lib path., tid = main:8192 file = cmstartup.c, line = 311 {Wed Jan 8 02:44:00 2003 } CreateLocalEndpoint(): Network Address: 192.168.0.9 {Wed Jan 8 02:44:00 2003 } NMEVENT_SUSPEND [00][00][00][00][00][00][00][01] {Wed Jan 8 02:44:05 2003 } HandleUpdate(): SYNC(0) from node(0) completed {Wed Jan 8 02:44:07 2003 } HandleUpdate(): NODE(0) IS ACTIVE MEMBER OF CLUSTER {Wed Jan 8 02:44:07 2003 } NMEVENT_RECONFIG [00][00][00][00][00][00][00][01] {Wed Jan 8 02:44:07 2003 } Successful reconfiguration, 1 active node(s) node 0 is the master, my node num is 0 (reconfig 1) {Wed Jan 8 02:44:07 2003 } WARNING: ReadCommPort: received error=104 on recv()., tid = ClientProcListener:81929 file = unixinc.c, line = 762 {Wed Jan 8 02:45:16 2003 } WARNING: ReadCommPort: socket closed by peer on recv()., tid = ClientProcListener:90121 file = unixinc.c, line = 754 {Wed Jan 8 02:45:16 2003 } WARNING: ReadCommPort: socket closed by peer on recv()., tid = ClientProcListener:98313 file = unixinc.c, line = 754 {Wed Jan 8 02:45:16 2003
Sun HA Monitoring and Oracle 9
Here's a little background. We are currently running Oracle 8.1.6.0, 8.1.7.0, and 8.1.7.4 on a Sun cluster. We use HA monitoring for failover, in case there is a problem with any of the nodes. The version of HA is 2.2. We installed Oracle 9.2.0.1 on the cluster and created a new database using it. When the SA tried to start the HA monitoring, it wouldn't run. We ended up recreating the database in 8.1.7.4. When the SA contacted Sun, he was told that HA version 2.2 only supports up to Oracle 8.1.7. In order to monitor Oracle 9, we had to buy (not upgrade to) HA 3.0, which would require a rebuild of the entire cluster. Has anyone else run into this problem? If so, what have you done to get around it? Let me know if I forgot any important piece of information. Thank you. -- Scott Canaan ([EMAIL PROTECTED]) (585) 475-7886 Life is like a sewer, what you get out of it depends on what you put into it. - Tom Lehrer. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Scott Canaan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Hotsos Clinic
Keith, I had the great good fortune to be able to attend the Hotsos Clinic in March, 2002 and then, in November, to attend Jonathan Lewis' seminar. Best investments in Oracle I ever made. Scott Behrens [EMAIL PROTECTED] 1/2/03 1:41:45 PM I have an opportunity to attend a Hotsos Clinic. It seems I have heard good things about them on this list, but I thought I might double-check. Is this 3-day class worthwhile or is it an expensive way to sell their product? Will this class be beneficial, even if we don't buy their product?Keith--
Re: warehouse builder's dependance on oem job system.
I run the jobs via cron, without any parameters and we don't have any problems. If you look at the parameter list, you'll find that most (if not all) have default values anyway. I have been running them via cron for months without any issues, other than the fact that we can't multitask. Mandar A. Ghosalkar wrote: Chris, the parameters 3,2,50,1000,50,wb,10 are used inside the oem-owb job tcl script as set p_oper_mode [lindex $parList [incr parList_i]] set p_audit_level [lindex $parList [incr parList_i]] set p_num_errors [lindex $parList [incr parList_i]] set p_commit_frequency [lindex $parList [incr parList_i]] set p_bulk_size [lindex $parList [incr parList_i]] set p_purge_group [lindex $parList [incr parList_i]] set p_percentage [lindex $parList [incr parList_i]] and then the package.main is called try the following. i would recommend testing this on the test server before putting it on prod :-) sqlexec C40_ADMIN_CUSTOMER_MAP.Main(p_operating_mode = 3, p_audit_level = 2, p_max_errors = 50, p_commit_frequency = 1000, p_bulk_size = 50, p_job = 'wb'); -Mandar Original Message- Sent: Thursday, December 12, 2002 1:09 PM To: Multiple recipients of list ORACLE-L here is the tcl that was generated: -r 3,2,50,1000,50,wb,10 -c WE8MSWIN1252 the package that is generated is quite long. i have absolutely no idea how to read the tcl. if you could point me somewhere, i could try and figure it out myself. any help is appreciated. attached is the package code if you are willing to take a look... (for some reason my computer associates .pls extensions with real audio) -Original Message- Sent: Tuesday, December 10, 2002 1:11 PM To: Multiple recipients of list ORACLE-L Chris, All the owb etl jobs are packages and if you have configured it right, then you could the execute the package_name.main procedure to run the etl process. your best best would be to read the tcl script and the associated parameters for the owb-oem job. You could paste the tcl and the parameters here to help u more. -Mandar -Original Message- Sent: Tuesday, December 10, 2002 9:31 AM To: Multiple recipients of list ORACLE-L ok, here's the situation: we are loading our warehouse via etl processes generated by warehouse builder (owb). we went live with this a little over a week ago. up to this point we have been running the jobs manually through owb. for obvious reasons we need to be able to schedule these jobs. the only way (that i know of) to schedule the owb jobs is to deploy them to entreprise manager. the problem is that our oem is VERY unreliable and seems to be related to bugs. we are running oem v9.2 and oracle ee v9.2. when jobs are scheduled through oem, they run sometimes and hang others. this is unexceptable. so my question is: does anyone know of a way to trap the commands that oem sends to the database? the obvious solution would be to just cron execution of the packages owb generates inside the database. this doesn't work though because owb generates funky code that takes parameters, whose values i don't know, for logging purposes. hopefully i explained the situation well enough. any ideas??i'd like to get rid of the dependance on oem. oem sucks -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mandar A. Ghosalkar INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Scott Canaan ([EMAIL PROTECTED]) (585) 475-7886 Life is like a sewer, what you get out of it depends on what you put into it. - Tom Lehrer. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Scott Canaan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: ORA-00600: internal error code, arguments: [ttcgcshnd-1], [0],
Satish, list lurker off Use the JDBC driver from the 9.0.1 database. The 8i JDBC driver causes this error. /list lurker on Scott -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of SATISH P Sent: Thursday, December 12, 2002 8:34 AM To: Multiple recipients of list ORACLE-L Subject: ORA-00600: internal error code, arguments: [ttcgcshnd-1], [0], Hi , we are getting the error ORA-00600: internal error code, arguments: [ttcgcshnd-1], [0], [], [], [], [], [], [] when trying to retrieve a result set from Java EJB. Searched metalink giving arguments for ORA-00600 but couldn't get any solution. I am being told that Weblogic 6.1 with oracle 9i is giving some problems. Any info on this ? Setup is mentioned Below: Oracle database 9.0.1.1.0 on sunsolaris Weblogic Applications Server 6.1 on Sunsolaris (different Unix box). JDBC driver thin - Classes12.jar In fact , If an Insert from the Application is working fine. But when we try a query it is displaying the above mentioned error. From udump trace file of oracle below is the error message : /usr/gsci/OraHome1/admin/GMODC/udump/gmodc_ora_1182.trc Oracle9i Enterprise Edition Release 9.0.1.1.0 - 64bit Production With the Partitioning option JServer Release 9.0.1.1.0 - Production ORACLE_HOME = /usr/gsci/OraHome1 System name: SunOS Node name:lotus Release: 5.8 Version: Generic Machine: sun4u Redo thread mounted by this instance: 1 Oracle process number: 19 Unix process pid: 1182, image: oracle@lotus (TNS V1-V3) *** SESSION ID:(19.2868) 2002-12-11 10:41:43.563 *** 2002-12-11 10:41:43.563 ksedmp: internal or fatal error ORA-00600: internal error code, arguments: [ttcgcshnd-1], [0], [], [], [], [], [], [] Current SQL statement for this session: SELECT VALUE FROM NLS_INSTANCE_PARAMETERS WHERE PARAMETER ='NLS_DATE_FORMAT' - Call Stack Trace - Is there any solution for this problem? TIA Satish -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Scott Graves INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: hmm...
You can update the global_name by using sqlplus or svrmgrl (internal or / as sysdba or sys): update global_name set global_name = newname; commit; I do this every time I clone a database. If you don't change it, then the database links won't work. DENNIS WILLIAMS wrote: Adam - Someone posted a better hidden? parameter awhile back. Jared, was that you? Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, December 06, 2002 11:29 AM To: Multiple recipients of list ORACLE-L I was afraid that'd be the only way. Thanks. Adam -Original Message- Sent: Friday, December 06, 2002 12:05 PM To: Multiple recipients of list ORACLE-L Hi Set global_names = false in init.ora file and try again -Original Message- Sent: vrijdag 6 december 2002 17:41 To: Multiple recipients of list ORACLE-L Don't ask how we got into this situation, but I have two instances with the same global_name and need to be able to create a link between them. Is this doable? Adam -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Donahue, Adam INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Jack van Zanen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Donahue, Adam INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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). -- Scott Canaan ([EMAIL PROTECTED]) (585) 475-7886 Life is like a sewer, what you get out of it depends on what you put into it. - Tom Lehrer. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Scott Canaan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: hmm...
Adam, If you need keep the global_name the Create the database link with @ symbol. The online documentation http://download-west.oracle.com/docs/cd/A97630_01/server.920/a96521/ds_admin.htm#13803 gives you some examples. I am not sure if this is what you are looking for but it may help. Scott --- Donahue, Adam [EMAIL PROTECTED] wrote: Thanks for the suggestions, all. I knew about these workarounds, but apparently the answer to my original question is no. Adam -Original Message- Sent: Friday, December 06, 2002 5:39 PM To: Multiple recipients of list ORACLE-L There is: Alter database rename global_name Waleed -Original Message- Sent: Friday, December 06, 2002 5:14 PM To: Multiple recipients of list ORACLE-L You can update the global_name by using sqlplus or svrmgrl (internal or / as sysdba or sys): update global_name set global_name = newname; commit; I do this every time I clone a database. If you don't change it, then the database links won't work. DENNIS WILLIAMS wrote: Adam - Someone posted a better hidden? parameter awhile back. Jared, was that you? Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, December 06, 2002 11:29 AM To: Multiple recipients of list ORACLE-L I was afraid that'd be the only way. Thanks. Adam -Original Message- Sent: Friday, December 06, 2002 12:05 PM To: Multiple recipients of list ORACLE-L Hi Set global_names = false in init.ora file and try again -Original Message- Sent: vrijdag 6 december 2002 17:41 To: Multiple recipients of list ORACLE-L Don't ask how we got into this situation, but I have two instances with the same global_name and need to be able to create a link between them. Is this doable? Adam -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Donahue, Adam INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Jack van Zanen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Donahue, Adam INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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). -- Scott Canaan ([EMAIL PROTECTED]) (585) 475-7886 Life is like a sewer, what you get out of it depends on what you put into it. - Tom Lehrer. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Scott Canaan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego
RE: Are Oracle courses required for Oracle Certification now?
Are you getting a sheet after each exam showing how many you got correct for each section and your overall score? I received that sheet at the testing center after each exam. Other than that, you won't get anything from Oracle until you finish your final exam. It took me about a month to get my packet. At 01:13 PM 12/4/02 -0800, you wrote: Lyndon - I have completed 2 of the 5 Oracle8i exams. Hey - when I took each exam, the testing organization says that I should receive something from Oracle within a couple of weeks. Got nothing. Should I be worried? Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, December 04, 2002 1:10 PM To: Multiple recipients of list ORACLE-L Hey William, Why are you 40% OCP - does this mean you are an OCA? When did you take your very first 9i certification exam? If you took it before Sept. 1, 2002, the you're a 50% OCP. -- Lyndon Tiu Quoting DENNIS WILLIAMS [EMAIL PROTECTED]: My instructor in a recent Oracle Education class said that there were a couple of smart alecs that caused quite a stir within Oracle. After receiving their OCP, they couldn't log into a database, and claimed it was because they had never actually used Oracle. The instructor indicated that the new requirement (9i I believe) would require you to take at least one class. I asked do you mean everyone that takes a class from you will be logging on. He just grinned. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, December 04, 2002 11:25 AM To: Multiple recipients of list ORACLE-L Hey people! A friend of mine was just asking me about getting Oracle certified (I completed the Oracle 8i cerfication exams last year), he told me that to his knowledge Oracle requires that you've done Oracle courses before you can be certified now. I knew nothing about this, but can't believe Oracle would so blatantly make you take their over-priced courses. But maybe I'm just naive. Cheers, Kieran Murray CardBASE Technologies Limited® BIM House Crofton Road Dun Laoghaire Co Dublin -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kieran Murray INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Lyndon Tiu INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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). ** Scott Stefick UNIX Systems Administrator Oracle Certified Professional DBA Wm. Rainey Harper College 847.925.6130
RE: Recipe for application design to run on RAC
Dennis, I hate to see do all this jumping up and down but the dynamic re-mastering feature was not implemented in 9i. There is a view called V$GCSPFMASTER_INFO that is supposed to show which node was the master, which node is currently the master and how many times the resource has been re-mastered, but the view is never populated. This is one those if it's in the Doc. it may have been true in the past, It may be true now or it may true in the future. This one of those in the future features. Scott --- DENNIS WILLIAMS [EMAIL PROTECTED] wrote: I know I know (he says jumping up and down) Just did the 9i New Features class. The answer is lazy dynamic remastering. Over time, resources are gradually moved to the instance that is using them. More quotes from the manual: Should an instance leave the group, the background processes only remaster resources from the departing instance. Similarly, when a new instance joins the group, the resources are gradually remastered, adapting to the cluster workload. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -Original Message- Sent: Wednesday, December 04, 2002 2:30 PM To: Multiple recipients of list ORACLE-L So when I access the fantasy football league on the espn web site-I go to schema2 because my team(s) are losing :-) I guess thats what I get when I picked a group of guys that are all on the injured reserve Seriously though--What if 50% of the blocks of data for schema1 are owned by db2? do you eventually see where ownership is transferred to the active node, reduced cache fusion activity and then transfer of blocks? Do the users on schema1 have to use the data on schema2 at all? I'm trying to see if not only are the users logically partitioned-but if your schemas offer any data partitioning to align with the schema1 and schema2 thanks! Greg -Original Message- Sent: Wednesday, December 04, 2002 2:05 PM To: Multiple recipients of list ORACLE-L H... it is probably not an good example but we too have a (couple of) mission critical app (affects on air production) running on 9i RAC. One of which has two major schema. We logically partitioned the application such that, for two groups of people 9accessing one schema each) we gave them a preference. Schema1 users have tns entry for db1 and fail over to db2 Schema2 users have a preference for db2 with a fail over to db1 This effectively allows us to do load balance, they don't share too much data, so traffic through interconnect is manageable. If need be, we just shutoff listener on one side, and everyone fails over to the other side while we can perform maintenance. All their applications are written in VB, JAVA so they handle fail over from within application. None of the people involved in the design worried about which side of RAC they will be on and how the DML activity affects etc etc. They designed a plain application with a good design and it is working fine. Like I mentioned this is not a good example ... but this is how we did it in one of our major application. 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 -- 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!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Scott INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Best practice for backing out of Application Patches
Sorry, I forgot a Subject title! Gurus, I was just given a project to maintain a Computerized Maintenance Management System. When I asked the companies support staff how to roll back patches in the backend Oracle Database (Ver. 8174), they said that there was no way to do this. I'm guessing I could use logminer just incase a patch doesn't work. Would this be a good solution, or are there other (better) ways of safeguarding myself when it comes to patching? Obviously, I will be applying the patches to a test instance first, but I don't want to have to go back to restore from a backup if the patch causes unexpected issues. TIA! -Scott Stefick ** Scott Stefick UNIX Systems Administrator Oracle Certified Professional DBA Wm. Rainey Harper College 847.925.6130 ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Scott Stefick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
[no subject]
Gurus, I was just given a project to maintain a Computerized Maintenance Management System. When I asked the companies support staff how to roll back patches in the backend Oracle Database (Ver. 8174), they said that there was no way to do this. I'm guessing I could use logminer just incase a patch doesn't work. Would this be a good solution, or are there other (better) ways of safeguarding myself when it comes to patching? Obviously, I will be applying the patches to a test instance first, but I don't want to have to go back to restore from a backup if the patch causes unexpected issues. TIA! ** Scott Stefick UNIX Systems Administrator Oracle Certified Professional DBA Wm. Rainey Harper College 847.925.6130 ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Scott Stefick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Best practice for backing out of Application Patches
Thanks to Thomas Mercadante, Stephen Lee and Rick Cale for their responses. I think it's pretty unanimous that if this needs to be done, I would just restore to the point in time taken right before the patches were installed. Either I could do an export/restore/import or refresh from the production Database (As long as the problem was caught before getting put on the production Database). I just want to be covered from all angles before this application goes into production. Thanks again! -Scott Stefick At 12:14 PM 12/3/02 -0800, you wrote: Scott, Of course, the answer is It depends. It all depends on the kind of software patches that are being applied. Are you talking about adding a column to a table that allows nulls? There might not be a need to back this patch out - the column might be able to stay depending on how it is used during an insert or select statment. If the application does not use the column, then removing it from the table might need to be done. On the other hand, if you are using version 8.1.7, you can always drop the column from the table. If your patches are just updates to schema views, you can always simply e-apply the prior version of the views to back the updates out of the database. see, it all depends on the kind of schema update that was performed. and it can get very complicated when you are talking about foreign keys - literally hundreds of tables could be involved - and you probably do not want to be trying to figure out what got touched by an update. probably the best answer is - to back all database changes out of a schema, perform a database point-in-time restore back to before you applied the patches. if I had your job, and this was a purchased application, this is what I would do. hope this helps. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Tuesday, December 03, 2002 2:25 PM To: Multiple recipients of list ORACLE-L Sorry, I forgot a Subject title! Gurus, I was just given a project to maintain a Computerized Maintenance Management System. When I asked the companies support staff how to roll back patches in the backend Oracle Database (Ver. 8174), they said that there was no way to do this. I'm guessing I could use logminer just incase a patch doesn't work. Would this be a good solution, or are there other (better) ways of safeguarding myself when it comes to patching? Obviously, I will be applying the patches to a test instance first, but I don't want to have to go back to restore from a backup if the patch causes unexpected issues. TIA! -Scott Stefick ** Scott Stefick UNIX Systems Administrator Oracle Certified Professional DBA Wm. Rainey Harper College 847.925.6130 ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Scott Stefick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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). ** Scott Stefick UNIX Systems Administrator Oracle Certified Professional DBA Wm. Rainey Harper College 847.925.6130 ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Scott Stefick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: [Q] ORACLE 9.2 SGA_MAX_size cause SUN server crash ????
I have not used this feature but there is a note on metalink that you may find useful regarding dynamic SGA issues on Solaris 8. It is note 151222.1 Scott --- dist cash [EMAIL PROTECTED] wrote: We are doing ORACLE 9.2.0.2 Enterprise Edition testing on SUN server (Solaris 8). Currently one problem happen. If I put SGA_MAX_size entry on init.ora file and restart database, the SUN server will crash and following messages on /var/adm/message file: Dec 3 13:34:59 ISS unix: [ID 253085 kern.notice] NOTICE: hat_memload: unsupported flags 256 Dec 3 13:35:00 ISS unix: [ID 253085 kern.notice] NOTICE: hat_memload: unsupported flags 256 Dec 3 13:35:02 ISS last message repeated 9618 times Dec 3 13:35:03 ISS unix: [ID 836849 kern.notice] Dec 3 13:35:03 ISS ^Mpanic[cpu3]/thread=ffba0ac0: Dec 3 13:35:03 ISS unix: [ID 977504 kern.notice] invalid shared memory l1 ptp Dec 3 13:35:03 ISS unix: [ID 10 kern.notice] Dec 3 13:35:03 ISS genunix: [ID 872817 kern.notice] e166ba40 unix:srmmu_share+130 (0, 0, ff61af38, 0, 8, ff619c20) Dec 3 13:35:03 ISS genunix: [ID 645206 kern.notice] %l0-7: 0800 ff61a998 2100 0001 ffc77004 ff0982c0 ffc77484 01629b 31 Dec 3 13:35:03 ISS genunix: [ID 872817 kern.notice] e166bab0 genunix:as_dup+dc (0, ffba14a0, ff61a9b4, ffbe2c28, ffbe2c44, ff61a99 8) Dec 3 13:35:03 ISS genunix: [ID 645206 kern.notice] %l0-7: e00e94f0 ffc8f760 f0a2981c ff385908 e166bb7c ff385908 df13a0 00 Dec 3 13:35:03 ISS genunix: [ID 872817 kern.notice] e166bb10 genunix:cfork+10c (0, 0, ff876768, 1e, 0, 0) Dec 3 13:35:03 ISS genunix: [ID 645206 kern.notice] %l0-7: 40401085 df119740 df119744 e006 ffba0ac0 ff577c10 e166bb 80 Dec 3 13:35:03 ISS unix: [ID 10 kern.notice] Dec 3 13:35:03 ISS genunix: [ID 672855 kern.notice] syncing file systems... Dec 3 13:35:03 ISS genunix: [ID 733762 kern.notice] 2 Dec 3 13:35:03 ISS genunix: [ID 733762 kern.notice] 1 Dec 3 13:35:03 ISS last message repeated 19 times Dec 3 13:35:03 ISS genunix: [ID 616637 kern.notice] cannot sync -- giving up Dec 3 13:35:03 ISS genunix: [ID 353387 kern.notice] dumping to /dev/dsk/c0t0d0s1, offset 83886080 Dec 3 13:35:03 ISS genunix: [ID 409368 kern.notice] ^M100% done: 10698 pages dumped, compression ratio 2.95, Dec 3 13:35:03 ISS genunix: [ID 851671 kern.notice] dump succeeded If I take out SGA_MAX_size entry from init.ora, the database run correctly. Does anyone knoe why SUN server crash? Thanks. _ Add photos to your e-mail with MSN 8. Get 2 months FREE*. http://join.msn.com/?page=features/featuredemail -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: dist cash INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Scott INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: a PL/SQL design question.
here is my answer. -Original Message-From: Andrey Bronfin [mailto:[EMAIL PROTECTED]]Sent: Thursday, November 28, 2002 12:34 PMTo: Multiple recipients of list ORACLE-LSubject: a PL/SQL design question.