RE:..not importing previous export!!!!!!!!
hi winnie, it got me errors like..* IMP-00015: following statement failed because the object already exists:* IMP-00017: following statement failed with ORACLE error 1119:"CREATE TABLESPACE "ROLLBACK_DATA" DATAFILE'G:\ORANT\DATABASE\RBS1ORCL.ORA" ..* IMP-3: ORACLE error 1536 encountered* ORA-01536: space quota exceeded for tablespace 'USER_DATA'these are corrected when i increased the quota granted to users. andmodified the path of datafile creation as according to new locations.any more suggestions in this regard are highly welcomed.thanks.saurabh
RE: question: create schema ?
How about using export and import... Looks like easiest way -Original Message- Sent: Thursday, May 03, 2001 9:55 AM To: Multiple recipients of list ORACLE-L Hi all, Do you have a handy way or some scripts to create a schema which is identical to an existing schema (has the same objects, data, grants, etc)? Thank you. Leslie -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rajesh Dayal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
PL/SQL and Java list
Is there a list dedicated to using PL/SQL and/or Java with Oracle? John -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Dunn INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
data encryption
Hi Gurus ! Is there any standard method to encrypt data? We are making an application that uses application-level privilege system, so we should store passwords for users. Of course we want to store encrypted passwords, but we don't know if is there an existing way for this or try develop own encryption. What do you suggest? Thanks in advance Gyula -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andor, Gyula INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
No Subject
Hello Does anybody know what the following ora 600 relates to, ORA-00600: internal error code, arguments: [15212], [1], [], [], [], [], [], [] Wed May 2 20:51:16 2001 Errors in file /opt/oracle/CRMVAN01/admin/udump/crmvan01_ora_29802.trc: ORA-00600: internal error code, arguments: [17090], [], [], [], [], [], [], [] Wed May 2 20:51:21 2001 Errors in file /opt/oracle/CRMVAN01/admin/udump/crmvan01_ora_29802.trc: ORA-00600: internal error code, arguments: [15212], [1], [], [], [], [], [], [] Wed May 2 20:51:26 2001 Errors in file /opt/oracle/CRMVAN01/admin/udump/crmvan01_ora_29802.trc: ORA-00600: internal error code, arguments: [15212], [1], [], [], [], [], [], [] I got loads of these in the alert log last night when we had a long running query. Everything seems to be ok now but i'm curious what this is. 8.1.7 on Solaris 2.6 Thanks Zabair _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: zabair ahmed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: RE:..not importing previous export!!!!!!!!
I think you have taken a full database export from 8.0.4 and you have created the database and other necessary datafiles. when importing a full database export, u need to only have the database created with system tablespace and when u import the same,it will create the datafiles and also the data will be imported. HTH. -- On Wed, 02 May 2001 22:50:22 Saurabh Sharma wrote: hi winnie, it got me errors like.. * IMP-00015: following statement failed because the object already exists: * IMP-00017: following statement failed with ORACLE error 1119: CREATE TABLESPACE ROLLBACK_DATA DATAFILE 'G:\ORANT\DATABASE\RBS1ORCL.ORA .. * IMP-3: ORACLE error 1536 encountered * ORA-01536: space quota exceeded for tablespace 'USER_DATA' these are corrected when i increased the quota granted to users. and modified the path of datafile creation as according to new locations. any more suggestions in this regard are highly welcomed. thanks. saurabh Get 250 color business cards for FREE! http://businesscards.lycos.com/vp/fastpath/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: C.S.Venkata Subramanian INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: data encryption
Andor, Gyula schrieb: Hi Gurus ! Is there any standard method to encrypt data? We are making an application that uses application-level privilege system, so we should store passwords for users. Of course we want to store encrypted passwords, but we don't know if is there an existing way for this or try develop own encryption. What do you suggest? Thanks in advance Gyula -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andor, Gyula INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). --- This Mail has been checked for Viruses Attention: Encrypted Mails can NOT be checked ! *** Diese Mail wurde auf Viren ueberprueft Hinweis: Verschluesselte Mails koennen NICHT geprueft werden! Hi, you can always go with the UNIX crypt() function. That works pretty well ;). Things get more complicated if you want to be able to decrypt the password again. There is a clear distinction when it comes two one-way or two-way encryption. But usually, one-way does it. Actually, Oracle does the same. -- Regards, Stefan Jahnke BOV AG @:D2 Vodafone, Abt.: FIBM AMS-Gebäude: E6 R08 Tel.: 0211/533-4893 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stefan Jahnke INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Anybody getting ORA-00600 [729] [space leak] on a regular bas
Interesting. Thanks a lot. 80Mb. Cheers Nuno Souto [EMAIL PROTECTED] http://www.users.bigpond.net.au/the_Den - Original Message - We found out that if we flush the shared pool once a week , we don't get this error. What is size of your shared_pool ? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nuno Souto INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: data encryption
I was wondering if Oracle ever considered incorporating PGP into their databases. I don't know much about the different types of security (e.g. Kerberos etc.), though, so maybe that idea doesn't make any sense. : ) Is it not possible for people to write password encryption procedures in 8.1? You can write your own procedure to verify the complexity of passwords, I am surprised they wouldn't let a site develop their own password encryption scheme. Patrice Boivin Systems Analyst (Oracle Certified DBA) -Original Message- From: Stefan Jahnke [SMTP:[EMAIL PROTECTED]] Sent: Thursday, May 03, 2001 8:30 AM To: Multiple recipients of list ORACLE-L Subject:Re: data encryption Andor, Gyula schrieb: Hi Gurus ! Is there any standard method to encrypt data? We are making an application that uses application-level privilege system, so we should store passwords for users. Of course we want to store encrypted passwords, but we don't know if is there an existing way for this or try develop own encryption. What do you suggest? Thanks in advance Gyula -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andor, Gyula INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). --- This Mail has been checked for Viruses Attention: Encrypted Mails can NOT be checked ! *** Diese Mail wurde auf Viren ueberprueft Hinweis: Verschluesselte Mails koennen NICHT geprueft werden! Hi, you can always go with the UNIX crypt() function. That works pretty well ;). Things get more complicated if you want to be able to decrypt the password again. There is a clear distinction when it comes two one-way or two-way encryption. But usually, one-way does it. Actually, Oracle does the same. -- Regards, Stefan Jahnke BOV AG @:D2 Vodafone, Abt.: FIBM AMS-Gebäude: E6 R08 Tel.: 0211/533-4893 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stefan Jahnke INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Anybody getting ORA-00600 [729] [space leak] on a regular base?`
I'm a bit suss on ignoring them. The mem in use from glance doesn't increase. Might be a side effect of something else? Dunno, it's got me stumped. Been happening since we moved from 8.0.5.2 to 8.0.6.0. Maybe I should just slap on the 8.0.6.2 patch? Going back to 8.0.5 is no option, not supported. (not that I feel a lot of support right now...) Thanx for the info, BTW. Cheers Nuno Souto [EMAIL PROTECTED] http://www.users.bigpond.net.au/the_Den - Original Message - -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nuno Souto INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Anybody getting ORA-00600 [729] [space leak] on a regular base?`
We do daily exports, but our largest table is not that large. And they all complete, no errors. Heaps of tables, though. Also, this is 8.0.6. I'd expect the darn thing to be fixed by now! Thanks for the info. Cheers Nuno Souto [EMAIL PROTECTED] http://www.users.bigpond.net.au/the_Den - Original Message - It is relating to incomplete/terminated export of database or any large table. You may check this happening to your systemOracle patch 7.3.4.5 claims that it is fixed but it is still the problem... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nuno Souto INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Windows vs. UNIX (you are so ready for B*LLSH*T marketing,
It doesn't surprise me that they are focusing on Windows2000 as a platform. Even while one part of IBM was trying to market OS/2, other parts of IBM only wanted to support Windows95... and the CEO couldn't make up his mind. Finally OS/2 became largely irrelevant, it is still fighting to stay alive but it is in its death throws it seems to me, unless they can get their hands on the Win9X/ME/NT/2000 API code and integrate it within the OS. IBM is a services company now - they have been transformed. They bundle deals together that match what people (managers, CIOs) request... It's the only way they can survive, when you think about it. It's a jungle out there. It seems to be working too, since the new President from [Nabisco? Kellogg? A cigarette company?] took the helm, they went from red ink to black. : ) Patrice Boivin Systems Analyst (Oracle Certified DBA) -Original Message- From: Jared Still [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, May 02, 2001 10:01 PM To: Multiple recipients of list ORACLE-L Subject:Re: Windows vs. UNIX (you are so ready for B*LLSH*T marketing, *!NOT!*) On Wednesday 02 May 2001 12:51, Eric D. Pierce wrote: Jared, Apparently there are super geniuses at IBM may have invented a time machine (along with free underground golf planners) that explains the 90 days business. The fact that these 'super geniuses' have hitched their carts to Win2K makes them suspect. Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: 9iAS Forms Server Stability
I would like to hear about this as well, we will be migrating to the new version this Summer. Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, May 02, 2001 9:05 PM To: Multiple recipients of list ORACLE-L Subject:9iAS Forms Server Stability Listers, 6i Forms Server in a test environment is crashing quite frequently, 3 to 4 times a day. I'm relaying this question, and I'm not real familiar with the back end configuration details, so I might be off on some things. They have an 8.1.7 test environment with 9iAS 1.0.2. Platform is HP-UX 11. 9iAS 1.0.2, I believe that would be using Forms 6i patch 2. They are using JInitiator. Access is via NT (sp4) clients using IE 5.5. The servlet, not CGI, approach is being used. They are specifying connectmode as HTTP. In the test environment, DB and 9iAS are on the same box. In production, they will be using 4 dedicated HP D class boxes for the forms servers just as they currently do. Anyway, the Forms Server is going down quite a bit in the test environment, 3 or 4 times a day. They currently use Forms 5.0 in a production web deployed environment. While there are some things that are a bit of a pain when web deploying forms, the 5.0 Forms Server has been very stable for them. So, there is some concern about the stability when using 9iAS with the included Apache server along with the Forms Server for 6i. Anyone have success or horror stories they would like to relay? Their current thinking is to wipe everything clean, do a clean re-install (they ran into a few road bumps during the install and wonder if a clean install would help), and see what happens from there. Regards, Larry G. Elkins [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
E-mail from Alert Logs
Hi List Is there any way of receiving an e-mail or sms , whenever a ORA- error appears in the Oracle Alert Log, or when something unexpected happens to the Oracle Instance ? TIA Saj -- Sajid Iqbal Database Team Leader -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sajid Iqbal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: data encryption
you can always go with the UNIX crypt() function. That works pretty well ;). And what colud we use on WinNT? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andor, Gyula INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Performance of views
Helmut When you tune views you have to keep in mind how you select from the view - you may tune perfectly the select statement that builds the view but when you select from the view the query may be very slow. When you run select * from myview the performance may be much different than select * from myview where mycolumn = somevalue Whenever I had to tune a view I used the view select statement but added the condition that was going to be used later and tuned all together. If the view was going to be used with two different conditions, we ended up with two different views hinted in different ways. IN the final result the view select statement may be slow but the select statement from the view has to be fast. If you need more details, let me know HTH Witold === Witold Iwaniec IT Consultant [EMAIL PROTECTED] Hi! Some of our developers are having concerns about using views in the application. So they approached me and wanted to clarify some of their issues. When I issues a select * from viewname, Oracle executes the underlying select statement of the view. This underlying statement should be optimized (using availabale indexes on tables etc.) If I issue a select * from viewname where condition 3 or the like, will the indexes still be used. Or how is this statement executed? Does Oracle first run the underlying select statement and then apply the where condition 3 to the returned result set? Or is the statement being rewritten internally? The Oracle documentation is not very clear on this. Any ideas would be appreciated. This is 8.1.6 on Win2k. Thanks, Helmut -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Fwd: please help
Nechama, I do a level 0 or level 1 and then do archivelog current and then backup my archivelogs. I have been able to do point-in-time and ordinary recovery using this plan. This makes a complete set of backups. Further, we put them on tape each day and store a complete set for recovery. Regards, Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, May 02, 2001 5:00 PM would it be reasonable, then to alter system archive log current, and then back up all archived logs ... are there any pitfalls? ... thanks you Nechama Glasrot Oracle DBA Seisint, Inc. 6601 Park of Commerce Blvd. Boca Raton, Florida 33487 nglasrot @seisint.com mailto:[EMAIL PROTECTED] Direct 561.999.3977 Main 561.999.4400 Fax 561.999.4695 -Original Message- Sent: Wednesday, May 02, 2001 10:25 AM To: Multiple recipients of list ORACLE-L Jonathan, It would appear that your friend has hit upon one of the problems of hot backups that everyone misses and actually Oracle recommends against. That is backing up your online redo log files and doing that LAST. The reason is that there are more than likely active transactions that were recorded therein and those logs are not available. Can he complete the recovery, maybe if he has the remaining logs from the active system, I'm assuming he is recovering to somewhere other than his production system. Otherwise his only recourse is OTS. Dick Goulet Oracle Certified 8i DBA Reply Separator Author: Jonathan Gennick [EMAIL PROTECTED] Date: 5/1/2001 8:55 PM Fellow list members, I received the following email from a reader a few minutes ago. If you skip down to where he talks about backup, you'll see that he's in trouble with a database that won't recover. I've already suggested that he open a TAR, and that he supply more specifics as to error messages and the like, but maybe someone on this list can draw some conclusions from what he's told me so far. If you're good at recovery, have a look at what he says. I'll post his email address later if he says its ok, and I'll pass on any advice/suggestions I receive in the meantime. -- Best regards, Jonathan Gennick mailto:[EMAIL PROTECTED] * 906.387.1698 http://Gennick.com * http://MichiganWaterfalls.com * http://MetalDrums.org Tuesday, May 01, 2001, 10:27:51 PM, X wrote: BC Hi Jonathan, BC I always read and like your articles in the Oracle BC Magazine. BC Could you please give me a moment of your time .. BC I have some couple of pressing problems and questions BC if you don't mind as i am under fire at work .. BC I have trouble with some of the Oracle databases that BC i manage on Sun Solaris platform, sometimes i have my BC shutdowns hanging and this takes a very long time to BC complete. Also, hanging problems with some of the sql BC statements. Could you lend a hand about any possible BC clues as to what i should do or where i should look BC for answers. BC My last question is about hotback. BC I ran a hot backup yesterday and tried recovering BC today. I was faced with an Oracle error saying system BC tablespace needs more recovery and that open resetlogs BC will get an error after automatically applying the BC redo logs. BC My backup strategy went this way, BC i created a backup shell script and BC i put all tablespaces in hotbackup mode at the same BC time with this syntax.. BC select 'alter tablespace' || tablespace_name ||'begin BC backup;' BC from dba_tablespaces BC where status 'INVALID'; BC I copied my datafiles to backup using the syntax below BC ... BC !cp /u02/oradata/prod/system01.dbf/backup/prod BC !cp BC !cp BC !cp BC !cp BC then ended backup the same way as i began backup BC with the ||'end backup;' BC I backed up my controlfile BC and everything went well. Today, I restored my BC datafiles from backup and i was greeted with the BC problem i just expalined to you. BC I am the only dba DBA at this location BC and i need some advise on what to do as this is a BC serious issue with my supervisor. BC Thanks, BC Bill BC __ BC Do You Yahoo!? BC Yahoo! Auctions - buy the things you want at great prices BC http://auctions.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jonathan Gennick INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send
Re: data encryption
drop table emp;
create table emp(
EMPNO number primary key,
FIRSTNAME VARCHAR2(30),
SURNAME VARCHAR2(30),
PASSWORD CHAR(32),
PHONE VARCHAR2(32)
);
create or replace trigger emp_encryptpassword
before insert or update of password on emp
for each row
declare
b_in raw(16) := UTL_RAW.CAST_TO_RAW(substr(:new.password, 1, 16));
b_key raw(8) := UTL_RAW.CAST_TO_RAW('EeTe32!!');
b_out raw(32);
begin
dbms_obfuscation_toolkit.DESEncrypt(input =b_in, key =b_key,
encrypted_data =b_out);
:new.password :=rawtohex(b_out);
end;
/
insert into emp values(1,'BOB','SCOTT','Tiger',NULL);
Hi,
Play with that. Add error checking and decrypt with a function or encrypt the
given password and compare the protected strings.
oli
--
Oliver Artelt
Oracle Certified DBA
cubeoffice GmbH Co.KG # jordanstrasse 7 # 39112 magdeburg
telefon: +49 (0)391 6 11 28 10 # telefax: +49 (0)391 6 11 28 19
email: [EMAIL PROTECTED] # web: http://www.cubeoffice.de
[EMAIL PROTECTED] wrote
Hi Gurus !
Is there any standard method to encrypt data? We are making an application
that uses application-level privilege system, so we should store passwords
for users. Of course we want to store encrypted passwords, but we don't
know if is there an existing way for this or try develop own encryption.
What do you suggest?
Thanks in advance
Gyula
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Oliver Artelt
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
RE: Performance of multi datafile tablespaces
Depending on your application you can actually create your own partitioning. For example, we have a database here where we create a new tablespace and tables every month to deal with that months data. We have some set views that combine certain months together. I would say that if you can partition using Oracles method then you could probably do it manually. We also have a database where we manually stripped some tables and to me its more then a pain in the butt for what benefit we got out of it. I did not do the stripping but basically its just 1 extent can only fit in one datafile and as you already found out you have the extents sized to something smaller then what would fit in one extent. -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 02, 2001 10:55 PM To: Multiple recipients of list ORACLE-L Hi, We have a number of large tables that we want to increase the performance of queries against. This will be using 8171 on NT utilising the Parallel query option (PQO) on a server with 4 CPUs. Ideally we would like to partition the tables but due to the cost of the partitioning option (hundreds of thousands of dollars across our 3 sites) we have all but ruled this out for the moment. So, what is being considered is manual striping of datafiles within tablespaces. That is, each tablespace will consist of multiple datafiles (4 is being considered) with each datafile on separate hardware mirror sets. Locally Managed Tablespaces (LMTs) will also be used. I am interested in feedback on this option - eg past experiences, comments, other alternatives etc. Also, do you know of any references / whitepapers on this topic? So far I have found the following: http://www.revealnet.com/newsletter/disk_io_distribution.doc which suggests Physically stripe the temporary tablespace across multiple disks by allocating multiple datafiles with sizes mapped to the tablespace's extent size (so each datafile contains exactly one extent). Metalink articles suggesting using minextent clause on tables / indexes and the need to ensure that the objects don't fit into just 1 extent - or in our case that the objects will require at least 4 extents. Chapter 20 of the Oracle8i Designing and Tuning for Performance manual (8.1.7) under Striping Disks Manually. and such commands as ALTER TABLE ... ALLOCATE EXTENT DATAFILE '...' but the manual reference only refers to when the datafiles are filled by 1 object. Thanks, Bruce Reardon mailto:[EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Reardon, Bruce (CALBBAY) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kimberly Smith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
ORA-0313
ORACLE-L, In SQL PLUS, I had this problem when I tried delele a table, delete linha_prodt; delete linha_prodt * ERROR at line 1: ORA-03113: end-of-file on communication channel for solve this, I droped the table, but the problem ocurred again. I had this problem only in this table at the database.Why ? -- Thanks, Breno A. K. Magnago mailto:[EMAIL PROTECTED] Mercantil de Alimentos Soares -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Breno A. K. Magnago INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: DB link for nonoracle databases
Deepender Kr Gupta schrieb: Hi All !! I have a DBA question. Can we make a DB link for nonoracle databases ! The answer is 'YES' , I know. But How. The documentation says you will have to use Oracle hetrogeneous services. There is no explaination any further. I want my Oracle database to gather data from a SQL server . Both are on NT. Thanks in Advance. Deepender -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deepender Kr Gupta INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). --- This Mail has been checked for Viruses Attention: Encrypted Mails can NOT be checked ! *** Diese Mail wurde auf Viren ueberprueft Hinweis: Verschluesselte Mails koennen NICHT geprueft werden! Hi, check the following documentation set: Oracle8i Distributed Database Systems Part III Heterogeneous Services Concepts and Administration You have to distinguish 2 kinds of Heterogenous Services: Transparent Gateway and Generic Connectivity. Transparent Gateway has to be purchased seperately and offers 2 services: SQL access to non-Oracle data sources (like DB2 e.g.) and transaction services, meaning that e.g. DB2 tables might be included in Oracle transactions. Generic Connectivity comes with Oracle Server (at least the EE). It allows you to connect to ODBC and OLE DB data sources (like Excel Sheets or e.g. DB2 through ODBC). Oracle has to be run on NT/2000. Connecting to other databases via the ODBC/OLE DB gateway gives you the ability of accessing external data like tables. We tried it, it works fine and is in my opinion a good and cheap solution for data transfers (unless you have any high volume / online needs). -- Regards, Stefan Jahnke BOV AG @:D2 Vodafone, Abt.: FIBM AMS-Gebäude: E6 R08 Tel.: 0211/533-4893 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stefan Jahnke INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Fwd: please help
thank you ruth Nechama Glasrot Oracle DBA Seisint, Inc. 6601 Park of Commerce Blvd. Boca Raton, Florida 33487 nglasrot @seisint.com mailto:[EMAIL PROTECTED] Direct 561.999.3977 Main 561.999.4400 Fax 561.999.4695 -Original Message- Sent: Thursday, May 03, 2001 8:31 AM To: Multiple recipients of list ORACLE-L Nechama, I do a level 0 or level 1 and then do archivelog current and then backup my archivelogs. I have been able to do point-in-time and ordinary recovery using this plan. This makes a complete set of backups. Further, we put them on tape each day and store a complete set for recovery. Regards, Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, May 02, 2001 5:00 PM would it be reasonable, then to alter system archive log current, and then back up all archived logs ... are there any pitfalls? ... thanks you Nechama Glasrot Oracle DBA Seisint, Inc. 6601 Park of Commerce Blvd. Boca Raton, Florida 33487 nglasrot @seisint.com mailto:[EMAIL PROTECTED] Direct 561.999.3977 Main 561.999.4400 Fax 561.999.4695 -Original Message- Sent: Wednesday, May 02, 2001 10:25 AM To: Multiple recipients of list ORACLE-L Jonathan, It would appear that your friend has hit upon one of the problems of hot backups that everyone misses and actually Oracle recommends against. That is backing up your online redo log files and doing that LAST. The reason is that there are more than likely active transactions that were recorded therein and those logs are not available. Can he complete the recovery, maybe if he has the remaining logs from the active system, I'm assuming he is recovering to somewhere other than his production system. Otherwise his only recourse is OTS. Dick Goulet Oracle Certified 8i DBA Reply Separator Author: Jonathan Gennick [EMAIL PROTECTED] Date: 5/1/2001 8:55 PM Fellow list members, I received the following email from a reader a few minutes ago. If you skip down to where he talks about backup, you'll see that he's in trouble with a database that won't recover. I've already suggested that he open a TAR, and that he supply more specifics as to error messages and the like, but maybe someone on this list can draw some conclusions from what he's told me so far. If you're good at recovery, have a look at what he says. I'll post his email address later if he says its ok, and I'll pass on any advice/suggestions I receive in the meantime. -- Best regards, Jonathan Gennick mailto:[EMAIL PROTECTED] * 906.387.1698 http://Gennick.com * http://MichiganWaterfalls.com * http://MetalDrums.org Tuesday, May 01, 2001, 10:27:51 PM, X wrote: BC Hi Jonathan, BC I always read and like your articles in the Oracle BC Magazine. BC Could you please give me a moment of your time .. BC I have some couple of pressing problems and questions BC if you don't mind as i am under fire at work .. BC I have trouble with some of the Oracle databases that BC i manage on Sun Solaris platform, sometimes i have my BC shutdowns hanging and this takes a very long time to BC complete. Also, hanging problems with some of the sql BC statements. Could you lend a hand about any possible BC clues as to what i should do or where i should look BC for answers. BC My last question is about hotback. BC I ran a hot backup yesterday and tried recovering BC today. I was faced with an Oracle error saying system BC tablespace needs more recovery and that open resetlogs BC will get an error after automatically applying the BC redo logs. BC My backup strategy went this way, BC i created a backup shell script and BC i put all tablespaces in hotbackup mode at the same BC time with this syntax.. BC select 'alter tablespace' || tablespace_name ||'begin BC backup;' BC from dba_tablespaces BC where status 'INVALID'; BC I copied my datafiles to backup using the syntax below BC ... BC !cp /u02/oradata/prod/system01.dbf/backup/prod BC !cp BC !cp BC !cp BC !cp BC then ended backup the same way as i began backup BC with the ||'end backup;' BC I backed up my controlfile BC and everything went well. Today, I restored my BC datafiles from backup and i was greeted with the BC problem i just expalined to you. BC I am the only dba DBA at this location BC and i need some advise on what to do as this is a BC serious issue with my supervisor. BC Thanks, BC Bill BC __ BC Do You Yahoo!? BC Yahoo! Auctions - buy the things you want at great prices BC http://auctions.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jonathan Gennick INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists
Re: E-mail from Alert Logs
There is a program (AUTOMAIL) which sends an email to anyone you idntify when there is a change in a file. Look at it . It is attached . - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, May 03, 2001 3:00 PM Hi List Is there any way of receiving an e-mail or sms , whenever a ORA- error appears in the Oracle Alert Log, or when something unexpected happens to the Oracle Instance ? TIA Saj -- Sajid Iqbal Database Team Leader -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sajid Iqbal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). automailer_free.zip
Formula to calculate physical memory
Hi Can anyone please tell me the formula to calculate physical memory required for the system if size of the database is known. The size of database I am going for is 1 terabytes. The number of users are 70 it is a dataware house server. I am going for 8 CPU's . Now i want to know the physical memory for this setup. The response I need is 3 seconds for two-dimensional query and the record size is 10 GB. Can anyone suggest physical memory required for this configuration. Thanks Brijesh __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Brijesh Lal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re[2]:Fwd: please help
Jared, I agree, The online redo logs should never be restored back onto a system that is otherwise running. But the intent is to make a hot backup that could be restored to a completely blank system, which I believe was being done here. In that case you need the online logs if for nothing else so that they are there. Dick Goulet Reply Separator Author: Jared Still [EMAIL PROTECTED] Date: 5/2/2001 4:55 PM Dick, Backing up the redo logs can have some serious consequences. Let's say you are restoring the database files, and a number of archived logs to roll forward through. Following that, you are going to roll forward through all archived logs that are still online, and then through your current redo logs for a complete recovery. Restoring old redo logs would render this strategy ineffective. Backing them up can be a good thing, but it would be very easy to inadvertently wipe out the current ones when restoring from tape. Best practice of course is to make a backup of your database in it's current condition prior to restoring it. It would also be prudent to make copies of the redo logs locally so you don't have to restore them from tape. Jared On Wednesday 02 May 2001 07:24, [EMAIL PROTECTED] wrote: Jonathan, It would appear that your friend has hit upon one of the problems of hot backups that everyone misses and actually Oracle recommends against. That is backing up your online redo log files and doing that LAST. The reason is that there are more than likely active transactions that were recorded therein and those logs are not available. Can he complete the recovery, maybe if he has the remaining logs from the active system, I'm assuming he is recovering to somewhere other than his production system. Otherwise his only recourse is OTS. Dick Goulet Oracle Certified 8i DBA Reply Separator Author: Jonathan Gennick [EMAIL PROTECTED] Date: 5/1/2001 8:55 PM Fellow list members, I received the following email from a reader a few minutes ago. If you skip down to where he talks about backup, you'll see that he's in trouble with a database that won't recover. I've already suggested that he open a TAR, and that he supply more specifics as to error messages and the like, but maybe someone on this list can draw some conclusions from what he's told me so far. If you're good at recovery, have a look at what he says. I'll post his email address later if he says its ok, and I'll pass on any advice/suggestions I receive in the meantime. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Formula to calculate physical memory
Hi Can anyone please tell me the formula to calculate physical memory required for the system if size of the database is known. The size of database I am going for is 1 terabytes. The number of users are 70 it is a dataware house server. I am going for 8 CPU's . Now i want to know the physical memory for this setup. The response I need is 3 seconds for two-dimensional query and the record size is 10 GB. Can anyone suggest physical memory required for this configuration. Thanks Brijesh __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Brijesh Lal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re:data encryption
Gyula, Assuming your not on a version or Oracle that supports DBMS_OBFUSCATION you can try the following package. It's actually been copied from a Metalink doc. create or replace package encrypt as function code(inp_data varchar2, key varchar2 default 'your desired value') return varchar2; pragma restrict_references(code, RNDS, WNDS, WNPS); end; / create or replace package body encrypt is function convbin(c1 varchar2) return varchar2 is loop1 number; value number; divis number; r1 varchar2(30); begin r1 := ''; divis := 128; value := ascii(c1); for loop1 in 0..7 loop if(trunc(value/divis) = 1) then r1 := r1||'1'; else r1 := r1||'0'; end if; value := mod(value, divis); divis := divis/2; end loop; return r1; end; function code(inp_data varchar2, key varchar2 default 'your desired value') return varchar2 is loop1 number; loop11 number; r1 varchar2(8); r2 varchar2(8); key1 varchar2(4000); r3 number; result varchar2(40); divis number; begin key1 := key; while (length(inp_data) length(key1)) loop key1 := key1||key1; end loop; result := ''; for loop1 in 1..length(inp_data) loop r1 := convbin(substr(inp_data,loop1,1)); r2 := convbin(substr(key1,loop1,1)); divis := 128; r3 := 0; for loop11 in 1..8 loop if(to_number(substr(r1,loop11,1))+to_number(substr(r2,loop11,1)) = 1) then r3 := r3+divis; end if; divis := divis/2; end loop; result := result||chr(r3); end loop; return result; end; end; / grant execute on encrypt to public; create public synonym encrypt for system.encrypt; Reply Separator Author: Andor; Gyula [EMAIL PROTECTED] Date: 5/3/2001 1:35 AM Hi Gurus ! Is there any standard method to encrypt data? We are making an application that uses application-level privilege system, so we should store passwords for users. Of course we want to store encrypted passwords, but we don't know if is there an existing way for this or try develop own encryption. What do you suggest? Thanks in advance Gyula -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andor, Gyula INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
HOW TO CACHE THE TABLE??
I wonder how can I cache a table other than creating it with the cache option.?? Bunyamin K.Karadeniz Database Group / Information Systems Department HAVELSAN Ankara /TURKEY Tel : +903122873565 / 1681 Mobile Tel : +90 535 3357729
RE: OCI drivers
The OCI stuff used to be part of the programmer option in the client installation. I don't recall which of the client installation choices include this, though I know that the full installation does. Ron Morton Database Architect / Administrator Union Switch Signal Inc [EMAIL PROTECTED] -Original Message- From: Ravindra Basavaraja [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, May 02, 2001 5:26 PM To: Multiple recipients of list ORACLE-L Subject: OCI drivers Where can I download the OCI drivers from ?I need the drivers for Unix and NT. Should I install the Oracle client to install the oci drivers.? I was told that OCI drivers with JDBC connection pooling helps to improve the performance. Can pls anyone comment or contirubute their experience on this topic. thanks Ravindra -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ravindra Basavaraja INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Morton, Ronald D INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
MTS
I am configuring multithreaded server configuration of an WIN2000 Advanced server with Oracle 8i Rel3 EE. All the parameter are set accurately and checked the MTS configuration through loopback and see connection entries in v$circuit accordinglybut when we connect through some other PC it does'nt worked.infact the other client get 'could not resolve service name' error. when i checked the listener.log file at the server it has the entries for those bad connection request as 'connection established'. socan any body tell me what's the problem going on. Regards, Adnan. __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Muhammed Adnan Ansari INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
MTS Proble
I am configuring multithreaded server configuration of an WIN2000 Advanced server with Oracle 8i Rel3 EE. All the parameter are set accurately and checked the MTS configuration through loopback and see connection entries in v$circuit accordinglybut when we connect through some other PC it does'nt worked.infact the other client get 'could not resolve service name' error. when i checked the listener.log file at the server it has the entries for those bad connection request as 'connection established'. socan any body tell me what's the problem going on. Regards, Adnan. __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Muhammed Adnan Ansari INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: HOW TO CACHE THE TABLE??
alter table table_name cache; HTH Mark -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Bunyamin K.KaradenizSent: Thursday, May 03, 2001 03:31To: Multiple recipients of list ORACLE-LSubject: HOW TO CACHE THE TABLE?? I wonder how can I cache a table other than creating it with the cache option.?? Bunyamin K.Karadeniz Database Group / Information Systems Department HAVELSAN Ankara /TURKEY Tel : +903122873565 / 1681 Mobile Tel : +90 535 3357729
Re: Formula to calculate physical memory
The best way for you to see Oracle Installation Guide specific to your platform where they have guidelines to calculate memory requirment. However you may go for between 2 to 4GB depending whether your application is using parallel querries which requires a lot of memory... Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Thu, 03 May 2001 06:06:24 -0800 Hi Can anyone please tell me the formula to calculate physical memory required for the system if size of the database is known. The size of database I am going for is 1 terabytes. The number of users are 70 it is a dataware house server. I am going for 8 CPU's . Now i want to know the physical memory for this setup. The response I need is 3 seconds for two-dimensional query and the record size is 10 GB. Can anyone suggest physical memory required for this configuration. Thanks Brijesh __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Brijesh Lal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohammad Rafiq INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
ORA-6508 using Citrix/NT2000, Forms 6.0.8
Hi, (I apologise for cross-posting, but we are totally stuck ...) Our Environment: Oracle 7.3.4 database (on Solaris) Forms 6.0.8 Citrix 1.8 Metaframe (on Win NT/2000 sp1) We get 'ORA-06508 PL/SQL: could not find program unit being called' errors on a regular basis recently. We are trying very hard to isolate the cause, without much luck. We cannot re-produce the error consistently, and cannot cause it to happen on demand - it seems to happen at random. We have checked - all stored program units (in the database) are valid and accessible. It has only been happening (or at least, it has only been noticed), since we upgraded to Developer/6 and Citrix 1.8. (At least the upgrade to Oracle 8 hasn't happened yet, so IT can't be blamed ...) We THINK that it only seems to happen when in a Citrix session - nobody can recall it occurring using a 'direct' connection. It happens in various forms, and other users can use those forms simultaneously, without an error occurring. We have been investigating things like the timeouts, memory leaks (in Citrix) but without luck. We logged a TAR, but as we can't give them a reproducible case, they have closed it. Citrix say it's an Oracle problem. Microsoft say 'change to SQL Server' (just joking ...) Anybody got any ideas / had a similar experience? Regards Oweson Flynn -- Certifiable - Oracle DBA Developer The Flynn Consultancy Tel: 082-600-7-006 Fax: (011) 782-9313 EMail: [EMAIL PROTECTED] *** This message may contain information which is confidential and subject to legal privilege. If you are not the intended recipient, you may not peruse, use, disseminate, distribute or copy this message. If you have received this message in error, please notify the sender immediately by email, facsimile or telephone and return and/or destroy the original message. *** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Oweson Flynn INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
ANSI SQL Compliance (Oracle vs. SQL Server)
Which RDBMS is more ANSI SQL compliant, Oracle or MS SQL Server? I have some frustrated SQL Server developers that only understand how to write inner and outer joins using SQL Server's syntax. Don't DB2, Informix and Sybase use the same method of defining joins as predicates? Just curious. Maybe I'm crazy. -w __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Walter K INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: call stored procedure from a stored procedure
Let say you have my_procedure1 (param1 IN VARCHAR, param2 OUT VARCHAR); In procedure2 code you could write: PROCEDURE my_procedure2 AS par_1 VARCHAR2(10) := My Test; par_2 VARCHAR2(5); BEGIN my_procedure1(par_1, par_2); DBMS_OUTPUT.PUT_LINE(par_2); -- etc END; HTH Witold Woody Mckay [EMAIL PROTECTED] on 05/03/2001 12:25:49 Please respond to [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc:(bcc: Witold Iwaniec/ATL_BLUECROSS_CA) Please help, Sorry if this sounds like a dumb question but I'm having a hard time finding examples of how to call a stored procedure with IN and OUT parameters from another stored procedure. Any resources or examples. TIA, Woody -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Woody Mckay INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: monitoring listener.log
Title: monitoring listener.log Hi and thanks to" Danisment Gazi Unal (what does it mean ?)" Here is the script : #!/bin/sh # This script make 2 things : # 1- archive alert files # 2- search "ORA-" in alert.log file # if error is found , send an email to adresses passed in parameters # # Entry parameters : # 1- SID # 2- list of emails separated by a space # Ex : % ALTERTCHECK ORCL [EMAIL PROTECTED] [EMAIL PROTECTED] # --- SCRIPT_DIR=/home/ORCL/script ORACLE_SID=$1 shift EMAIL=$* # Set ALERT_DIR and ALERT_FILE # -- ALERT_DIR=/app/oracle/admin/$ORACLE_SID/bdump ALERT_FILE=alert_$ORACLE_SID.log ALERT_LOG=$ALERT_DIR/$ALERT_FILE ERRFILE=$SCRIPT_DIR/ALERT_ERRORS.TXT SUBJECT="Error in alert file of $ORACLE_SID" # Remove the alert file #30 # if [ -f $ALERT_LOG.30 ] then /bin/rm $ALERT_LOG.30 fi # Renanme the alert file, ex: 29 to 30, 28 to 29, .., 01 to 02, etc. # -- i=29 while [ $i -ge 1 ] ; do j=`expr $i + 1` if [ -f $ALERT_LOG.$i ] then mv $ALERT_LOG.$i $ALERT_LOG.$j fi i=`expr $i - 1` done # Rename the current alert log file to #1 # - if [ -f $ALERT_LOG ] then mv $ALERT_LOG $ALERT_LOG.1 fi # Create a new alert file, not mandotory (Oracle will do this) # touch $ALERT_LOG chmod 777 $ALERT_LOG # Remove the error file # --- if [ -f $ERRFILE ] then /bin/rm $ERRFILE fi # Searching for ORA- in the alert log #1 # if error, send mail to adresses in parameters # --- cat $ALERT_LOG.1 |grep '\ORA-' $ERRFILE if [ -s $ERRFILE ] then cat $ERRFILE | mailx -s "$SUBJECT" $EMAIL fi -Message d'origine-De: Saurabh Sharma [mailto:[EMAIL PROTECTED]]Date: vendredi 27 avril 2001 12:12À: Multiple recipients of list ORACLE-LObjet: Re: monitoring listener.log hey can u elaborate how do u scan each log file, and convert it in email msg. how do u do this.. saurabh sharma dba - Original Message - From: NGUYEN Philippe (Cetelem) To: Multiple recipients of list ORACLE-L Sent: Wednesday, April 25, 2001 9:10 PM Subject: monitoring listener.log Hi list, We have a script wich monitor the alert.log for each database. This script scan the alert.log file and send an email if an ORA-xxx error occured Now, we want to write a script monitoring the listener.log file : wich kind of message or variable indicate a network problem (ORA-xxx, ...) ? ...then we 'll have the same question for the log file made by OEM ! TIA
Re: E-mail from Alert Logs
Bunyamin, Would you please send a copy of the attachment directly to me, since the list does not allow binary attachments. Or if there is a URL where I can download or get more info, please e-mail that URL to the list. Thanks, Sivaram Bunyamin K.Karadeniz [EMAIL PROTECTED] 05/03/01 09:51AM There is a program (AUTOMAIL) which sends an email to anyone you idntify when there is a change in a file. Look at it . It is attached . - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, May 03, 2001 3:00 PM Hi List Is there any way of receiving an e-mail or sms , whenever a ORA- error appears in the Oracle Alert Log, or when something unexpected happens to the Oracle Instance ? TIA Saj -- Sajid Iqbal Database Team Leader -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sajid Iqbal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Siv Chelakkara INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: ORA-600
Zabair I have no idea of argument 17090 but 15212 appeared on our database last week. We have HP-UNIX 11.0.32 with 8.1.6.2. If you check on metalink it says something wrong with PL/SQL code with undetermined reason. You may check on metalink with your complete error code. Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Thu, 03 May 2001 02:16:06 -0800 Hello Does anybody know what the following ora 600 relates to, ORA-00600: internal error code, arguments: [15212], [1], [], [], [], [], [], [] Wed May 2 20:51:16 2001 Errors in file /opt/oracle/CRMVAN01/admin/udump/crmvan01_ora_29802.trc: ORA-00600: internal error code, arguments: [17090], [], [], [], [], [], [], [] Wed May 2 20:51:21 2001 Errors in file /opt/oracle/CRMVAN01/admin/udump/crmvan01_ora_29802.trc: ORA-00600: internal error code, arguments: [15212], [1], [], [], [], [], [], [] Wed May 2 20:51:26 2001 Errors in file /opt/oracle/CRMVAN01/admin/udump/crmvan01_ora_29802.trc: ORA-00600: internal error code, arguments: [15212], [1], [], [], [], [], [], [] I got loads of these in the alert log last night when we had a long running query. Everything seems to be ok now but i'm curious what this is. 8.1.7 on Solaris 2.6 Thanks Zabair _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: zabair ahmed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohammad Rafiq INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
After Update on TABLE_NAME For Each Row... Triggers and R.I.
A developer has an after update on table_name for each row ... trigger which sends mail via the UTL_SMTP package. If the triggering statement is something like, update saltab set dba_salary = dba_salary * 1000, and the resultant value is too large. The mail is not sent. However, if the statement is something like, update saltab set foreign_key_column = 'QWERTY' where foreign_key column = 'ASDFGH', and an R.I. constraint violation occurs because there is no parent key, ASDFGH, the mail is sent anyway. I had thought that R.I. checking was done in the following manner for such a trigger: 1. execute triggering event; 2. check for R.I. violations resulting from step 1; 3. execute trigger logic; 4. check for R.I. violations caused by the trigger; 5. Repeat for each row. (In this case the trigger just sends mail so step 4 can be removed). If this sequence of events is correct why is the mail sent? Is the R.I. violation not placed on the error stack immediately? That seems unlikely. Is the error stack not read until after the mail is sent? It was read for a non-R.I. violation. Is Oracle programmed to defer reporting R.I. violations on the error stack until after he trigger logic is processed? I could be wrong in my understanding of the trigger logic; step 2 is performed after step 3? How does one stop the mail from being sent when an R.I. violation occurs. One way would be to do the RI checking in trigger via a cursor which queries the parent table, and then raises an exception if no parent key is found. Is there another way? Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: MacGregor, Ian A. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re:images question
Claudia, They don't cause any more fragmentation than any other data type, but then today I would not store them inside the DB, I'd be more tempted to use the BFILE way. Dick Goulet Reply Separator Author: Casas; Claudia [EMAIL PROTECTED] Date: 5/3/2001 8:15 AM Do you recommend storing images in an oracle database or just storing the directory path to them instead. Somebody told me it would cause database fragmentation if I store images or binary data in databases?? --Claudia Casas- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Casas, Claudia INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Input truncated to 1 characters
I get the exact same message every time and the procedures always work and there are no invalid objects in dba_objects. I think you can safely ignore the message. I have no idea why it comes out, hopefully someone else can spread some light on that. [EMAIL PROTECTED] 05/03/01 11:56AM I noticed when I install procedures, i get this message: Input truncated to 1 characters can someone help explain this to me? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Leyden, Joseph INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: William Beilstein INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: ORA-6508 using Citrix/NT2000, Forms 6.0.8
Oweson, Check MetaLink for Doc # 1626.997. It might help ! Srini Chavali Oracle DBA Cummins Inc Oweson Flynn [EMAIL PROTECTED]@fatcity.com on 05/03/2001 10:51:12 AM Please respond to [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Hi, (I apologise for cross-posting, but we are totally stuck ...) Our Environment: Oracle 7.3.4 database (on Solaris) Forms 6.0.8 Citrix 1.8 Metaframe (on Win NT/2000 sp1) We get 'ORA-06508 PL/SQL: could not find program unit being called' errors on a regular basis recently. We are trying very hard to isolate the cause, without much luck. We cannot re-produce the error consistently, and cannot cause it to happen on demand - it seems to happen at random. We have checked - all stored program units (in the database) are valid and accessible. It has only been happening (or at least, it has only been noticed), since we upgraded to Developer/6 and Citrix 1.8. (At least the upgrade to Oracle 8 hasn't happened yet, so IT can't be blamed ...) We THINK that it only seems to happen when in a Citrix session - nobody can recall it occurring using a 'direct' connection. It happens in various forms, and other users can use those forms simultaneously, without an error occurring. We have been investigating things like the timeouts, memory leaks (in Citrix) but without luck. We logged a TAR, but as we can't give them a reproducible case, they have closed it. Citrix say it's an Oracle problem. Microsoft say 'change to SQL Server' (just joking ...) Anybody got any ideas / had a similar experience? Regards Oweson Flynn -- Certifiable - Oracle DBA Developer The Flynn Consultancy Tel: 082-600-7-006 Fax: (011) 782-9313 EMail: [EMAIL PROTECTED] *** This message may contain information which is confidential and subject to legal privilege. If you are not the intended recipient, you may not peruse, use, disseminate, distribute or copy this message. If you have received this message in error, please notify the sender immediately by email, facsimile or telephone and return and/or destroy the original message. *** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Oweson Flynn INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Input truncated to 1 characters
You are missing a newline after the / at the end of the procedure. Pat -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Pat Hildebrand INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Metalink Praise
something amazing just happened. I logged an iTar without delay. It was easy. An analyst picked it up within 15 minutes and sent me a i've got it mail. If this keeps up on a consistent basis, I am in grave danger of developing a positive opinion of OWS. figured i'd share the good news, as I often share the bad - Ross p.s. boy, I'd really like some good fresh steak for lunch without any additives, corn-fed, etc. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohan, Ross INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Q: might be really old topic, but please take a look
Probably this has been posed million times, but I really like to know. We'll have a meeting about this in our company, and I'd love to contribute someting. Any idea on the following issue, any link, paper, etc, will be greatly appreciated. pros and cons of 1. Oracle vs Sybase 2. Unix vs NT Leslie __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Leslie Lu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
FW: standby database in managed recovery mode
Suggestions anyone?? I'm attempting to get a standby database to run in managed recovery mode, so that the archived logs are automatically applied, however, when running the command 'recover managed standby database' I receive the following error message: SVRMGR recover managed standby database; ORA-00308: cannot open archived log '/u03/apps/oracle/admin/db/arch/1_194.arc' ORA-27037: unable to obtain file status SVR4 Error: 2: No such file or directory Additional information: 3 This is after I've brought the primary and standby up to the same max recid number in the v$log_history. I have attempted to rebuild the standby database and also to execute the command 'recover standby database until cancel' after confirming that all archived log files were in the proper location, however I'm always prompted for the next archive log which doesn't exist yet and I can't get into managed recovery mode. I've also went to the primary database, forced a log switch and then applied the newest archived log file, but that hasn't worked either. Richard Huntley Software Developer Phone: (800) 223-3732 (614) 880-1817 E-mail: [EMAIL PROTECTED] MindLeaders (www.mindleaders.com) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Richard Huntley INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: ANSI SQL Compliance (Oracle vs. SQL Server)
Walt, RTF SQL Reference M. I recall seeing a pretty good section in there about ANSI SQL92, and Oracle's superset of it. Also the Concepts Manual hth Ross || -Original Message- || From: Walter K [mailto:[EMAIL PROTECTED]] || Sent: Thursday, May 03, 2001 12:41 PM || To: Multiple recipients of list ORACLE-L || Subject: ANSI SQL Compliance (Oracle vs. SQL Server) || || || Which RDBMS is more ANSI SQL compliant, Oracle or MS || SQL Server? || || I have some frustrated SQL Server developers that only || understand how to write inner and outer joins using || SQL Server's syntax. Don't DB2, Informix and Sybase || use the same method of defining joins as predicates? || || Just curious. Maybe I'm crazy. || -w || || __ || Do You Yahoo!? || Yahoo! Auctions - buy the things you want at great prices || http://auctions.yahoo.com/ || -- || Please see the official ORACLE-L FAQ: http://www.orafaq.com || -- || Author: Walter K || INET: [EMAIL PROTECTED] || || Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 || San Diego, California-- Public Internet access / || Mailing Lists || || To REMOVE yourself from this mailing list, send an E-Mail message || to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in || the message BODY, include a line containing: UNSUB ORACLE-L || (or the name of mailing list you want to be removed from). You may || also send the HELP command for other information (like subscribing). || -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohan, Ross INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: images question
Check out BLOBs. They're stored externally. Can be tough to work with but also can be very worthwhile. Regards, David A. Barbour Oracle DBA,OCP Casas, Claudia wrote: Do you recommend storing images in an oracle database or just storing the directory path to them instead. Somebody told me it would cause database fragmentation if I store images or binary data in databases?? --Claudia Casas- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Casas, Claudia INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: David A. Barbour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Input truncated to 1 characters
I think it's as simple as no carriage return on the end of the last line (I'm assuming it's the ';' character). Cheers Iain Nicoll -Original Message- Sent: 03 May 2001 17:27 To: Multiple recipients of list ORACLE-L I get the exact same message every time and the procedures always work and there are no invalid objects in dba_objects. I think you can safely ignore the message. I have no idea why it comes out, hopefully someone else can spread some light on that. [EMAIL PROTECTED] 05/03/01 11:56AM I noticed when I install procedures, i get this message: Input truncated to 1 characters can someone help explain this to me? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Leyden, Joseph INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: William Beilstein INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nicoll, Iain (Calanais) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: E-mail from Alert Logs
Siv, Check out all the email tools available at: http://www.freedownloadscenter.com/Email_Tools/ Regards, David A. Barbour Oracle DBA, OCP Siv Chelakkara wrote: Bunyamin, Would you please send a copy of the attachment directly to me, since the list does not allow binary attachments. Or if there is a URL where I can download or get more info, please e-mail that URL to the list. Thanks, Sivaram Bunyamin K.Karadeniz [EMAIL PROTECTED] 05/03/01 09:51AM There is a program (AUTOMAIL) which sends an email to anyone you idntify when there is a change in a file. Look at it . It is attached . - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, May 03, 2001 3:00 PM Hi List Is there any way of receiving an e-mail or sms , whenever a ORA- error appears in the Oracle Alert Log, or when something unexpected happens to the Oracle Instance ? TIA Saj -- Sajid Iqbal Database Team Leader -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sajid Iqbal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Siv Chelakkara INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: David A. Barbour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: After Update on TABLE_NAME For Each Row... Triggers and
Sounds strange. I'd be curious at what values the a similar trigger would show if you captured :old and :new. Henry -Original Message- Sent: Thursday, May 03, 2001 12:35 PM To: Multiple recipients of list ORACLE-L R.I. A developer has an after update on table_name for each row ... trigger which sends mail via the UTL_SMTP package. If the triggering statement is something like, update saltab set dba_salary = dba_salary * 1000, and the resultant value is too large. The mail is not sent. However, if the statement is something like, update saltab set foreign_key_column = 'QWERTY' where foreign_key column = 'ASDFGH', and an R.I. constraint violation occurs because there is no parent key, ASDFGH, the mail is sent anyway. I had thought that R.I. checking was done in the following manner for such a trigger: 1. execute triggering event; 2. check for R.I. violations resulting from step 1; 3. execute trigger logic; 4. check for R.I. violations caused by the trigger; 5. Repeat for each row. (In this case the trigger just sends mail so step 4 can be removed). If this sequence of events is correct why is the mail sent? Is the R.I. violation not placed on the error stack immediately? That seems unlikely. Is the error stack not read until after the mail is sent? It was read for a non-R.I. violation. Is Oracle programmed to defer reporting R.I. violations on the error stack until after he trigger logic is processed? I could be wrong in my understanding of the trigger logic; step 2 is performed after step 3? How does one stop the mail from being sent when an R.I. violation occurs. One way would be to do the RI checking in trigger via a cursor which queries the parent table, and then raises an exception if no parent key is found. Is there another way? Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: MacGregor, Ian A. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Henry Poras INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Cursor statistics request
Hey DBAs for big databases, Would you mind running this simple query? I am building a case that we have an extremely unheathly application, and would like to (a) do a reality check, and (b) anonymously cite evidence from other sites. col name format a35 col min format 999 col max format 999 col avg format 9 col var format 9 select name, min(value) min, avg(value) avg, sqrt(stddev(value)) var, max(value) max from v$sesstat ss, v$statname sn where sn.statistic#=ss.statistic# and sn.statistic# in (2,3) group by name / When I run this on my troubled system, I get: NAME minavgvar max --- -- -- - opened cursors cumulative 0 46325561 3748748 opened cursors current 0 54 9 345 And this for a instance only up for about a week. Oh, speaking of which, please tell me how long your instance has been up, and a rough idea of average user load, during the core processing hours. Thanks! - Ross || -Original Message- || From: Steve Adams [mailto:[EMAIL PROTECTED]] || Sent: Tuesday, May 01, 2001 11:00 AM || To: Multiple recipients of list ORACLE-L || Subject: RE: Oracle What savepoints are active for a given session? || || || Hi Venkata, || || There is no V$ view or X$ table that contains this || information. The only || solution that occurs to me is to dump the savepoints to the || process trace file || with || || alter session set events 'immediate trace name savepoints'; || || and then use UTL_FILE to read and parse the trace file || information. Here is an || example of what you might get: || || SAVEPOINT FOR CURRENT PROCESS || -- ||flag: 0x3 ||name: S3 ||dba: 0x831408, sequence #: 964, record #: 12, savepoint #: 19082 ||status: VALID, next: 3822f60 ||name: S2 ||dba: 0x831408, sequence #: 964, record #: 11, savepoint #: 19046 ||status: VALID, next: 37f63ec ||name: S1 ||dba: 0x831408, sequence #: 964, record #: 10, savepoint #: 18602 ||status: VALID, next: 0 || || This process has three savepoints named S1, S2 and S3 respectively. || || @ Regards, || @ Steve Adams || @ http://www.ixora.com.au/ || @ http://www.christianity.net.au/ || || || -Original Message- || Sent: Tuesday, 1 May 2001 18:20 || To: Multiple recipients of list ORACLE-L || || || HI PLEASE SEND ME ANSWER || Question Title: Oracle What savepoints are active for a || given session? || || Detailed Question: Does anybody know IF and HOW can I get a list of || active savepoints for the current session? I need a native way, not || solutions based on additional application-level || housekeeping. Some query || on the V$ tables/views would be the kind of answer I'm looking for. || Details: Within one stored proc I'd like to obtain a list || (in any form) || of the savepoints issued currently in the current || transaction. Example: || Proc A issues savepoint svA; then proc B issues savepoint || svB; and then || proc C builds and uses a cursor having 'svA' and 'svB' as rows, or || something like that. Of course, there are no intervening commits or || rollbacks. || || -- || Please see the official ORACLE-L FAQ: http://www.orafaq.com || -- || Author: Steve Adams || INET: [EMAIL PROTECTED] || || Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 || San Diego, California-- Public Internet access / || Mailing Lists || || To REMOVE yourself from this mailing list, send an E-Mail message || to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in || the message BODY, include a line containing: UNSUB ORACLE-L || (or the name of mailing list you want to be removed from). You may || also send the HELP command for other information (like subscribing). || -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohan, Ross INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Fwd: please help
Jared, I think you hit the nail on the head when you said Best practice of course is to make a backup of your database in it's current condition prior to restoring it. Too many recoveries are failures because DBAs tend to forget basics when confronted with the pressures from management, users, and the constraints of time (primary key). I made this mistake once early on. Now if I have a possible recovery scenario, the first thing I do is take a deep breath, get a cup of coffee, and THINK about what I'm going to do before I ever touch the keyboard. Absent all that, I still make a copy of the redo logs whenever I do a backup. Yeah, you could mess up and apply them inadvertently, but hopefully you will have practiced recovery scenarios (see Training a DBA by Kimberly Smith) and be comfortable with your tapes, disks, commands, systems administrator, etc. At least if you've got them, and everything goes to h*%$ in a handbasket, you can always give 'them' back something. David A. Barbour Jared Still wrote: Dick, Backing up the redo logs can have some serious consequences. Let's say you are restoring the database files, and a number of archived logs to roll forward through. Following that, you are going to roll forward through all archived logs that are still online, and then through your current redo logs for a complete recovery. Restoring old redo logs would render this strategy ineffective. Backing them up can be a good thing, but it would be very easy to inadvertently wipe out the current ones when restoring from tape. Best practice of course is to make a backup of your database in it's current condition prior to restoring it. It would also be prudent to make copies of the redo logs locally so you don't have to restore them from tape. Jared On Wednesday 02 May 2001 07:24, [EMAIL PROTECTED] wrote: Jonathan, It would appear that your friend has hit upon one of the problems of hot backups that everyone misses and actually Oracle recommends against. That is backing up your online redo log files and doing that LAST. The reason is that there are more than likely active transactions that were recorded therein and those logs are not available. Can he complete the recovery, maybe if he has the remaining logs from the active system, I'm assuming he is recovering to somewhere other than his production system. Otherwise his only recourse is OTS. Dick Goulet Oracle Certified 8i DBA Reply Separator Author: Jonathan Gennick [EMAIL PROTECTED] Date: 5/1/2001 8:55 PM Fellow list members, I received the following email from a reader a few minutes ago. If you skip down to where he talks about backup, you'll see that he's in trouble with a database that won't recover. I've already suggested that he open a TAR, and that he supply more specifics as to error messages and the like, but maybe someone on this list can draw some conclusions from what he's told me so far. If you're good at recovery, have a look at what he says. I'll post his email address later if he says its ok, and I'll pass on any advice/suggestions I receive in the meantime. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: David A. Barbour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Q: might be really old topic, but please take a look
In each case, it's good versus evil... [EMAIL PROTECTED] 05/03/01 01:36PM Probably this has been posed million times, but I really like to know. We'll have a meeting about this in our company, and I'd love to contribute someting. Any idea on the following issue, any link, paper, etc, will be greatly appreciated. pros and cons of 1. Oracle vs Sybase 2. Unix vs NT Leslie __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Leslie Lu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tim Sawmiller INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: might be really old topic, but please take a look
briefly: our choice was oracle/NT, based mainly on division/corporate direction which was based on the strengths of oracle. widely installed, industry leader, robust platform. NT was a no-brainer; the majority of our knowledge is NT. price and complexity were considered also, even though you have more control over *nix, the price of boxii to run it on as well as the cost of training and associated learning curve made *nix an unattractive option. our user base is small-to-medium so an NT solution should suffice, if we were larger or more widely dispersed or web based; we'd look harder at *nix. remember i said brief. === Lerone Streeter System Analyst Abbott LBG [EMAIL PROTECTED] === -Original Message- Sent: Thursday, May 03, 2001 1:51 PM To: Multiple recipients of list ORACLE-L Oh, ha! that is an old one: Oracle on Unix is the only choice. No need to research at all! Just go out and buy one! :) Ross p.s. give us more info, and you'll get a higher quality answer. GIGO || -Original Message- || From: Leslie Lu [mailto:[EMAIL PROTECTED]] || Sent: Thursday, May 03, 2001 1:37 PM || To: Multiple recipients of list ORACLE-L || Subject: Q: might be really old topic, but please take a look || || || Probably this has been posed million times, but I || really like to know. We'll have a meeting about this || in our company, and I'd love to contribute someting. || Any idea on the following issue, any link, paper, etc, || will be greatly appreciated. || || pros and cons of || || 1. Oracle vs Sybase || || 2. Unix vs NT || || || Leslie || || __ || Do You Yahoo!? || Yahoo! Auctions - buy the things you want at great prices || http://auctions.yahoo.com/ || -- || Please see the official ORACLE-L FAQ: http://www.orafaq.com || -- || Author: Leslie Lu || INET: [EMAIL PROTECTED] || || Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 || San Diego, California-- Public Internet access / || Mailing Lists || || To REMOVE yourself from this mailing list, send an E-Mail message || to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in || the message BODY, include a line containing: UNSUB ORACLE-L || (or the name of mailing list you want to be removed from). You may || also send the HELP command for other information (like subscribing). || -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Streeter, Lerone A LBX INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re[2]: Re[2]:Fwd: please help
Jared, Amen to that. Wonder how many of them have even taken the wrapping off the book?? :-) Dick Goulet Reply Separator Author: Jared Still [EMAIL PROTECTED] Date: 5/3/2001 10:17 AM DIck, Totally agree. I just wanted to make sure that the newbies out there understand the implications. Of course, they should read 'Oracle Backup Recovery Handbook' cover to cover and do all the exercises. Jared On Thursday 03 May 2001 05:57, [EMAIL PROTECTED] wrote: Jared, I agree, The online redo logs should never be restored back onto a system that is otherwise running. But the intent is to make a hot backup that could be restored to a completely blank system, which I believe was being done here. In that case you need the online logs if for nothing else so that they are there. Dick Goulet Reply Separator Subject:Re:Fwd: please help Author: Jared Still [EMAIL PROTECTED] Date: 5/2/2001 4:55 PM Dick, Backing up the redo logs can have some serious consequences. Let's say you are restoring the database files, and a number of archived logs to roll forward through. Following that, you are going to roll forward through all archived logs that are still online, and then through your current redo logs for a complete recovery. Restoring old redo logs would render this strategy ineffective. Backing them up can be a good thing, but it would be very easy to inadvertently wipe out the current ones when restoring from tape. Best practice of course is to make a backup of your database in it's current condition prior to restoring it. It would also be prudent to make copies of the redo logs locally so you don't have to restore them from tape. Jared On Wednesday 02 May 2001 07:24, [EMAIL PROTECTED] wrote: Jonathan, It would appear that your friend has hit upon one of the problems of hot backups that everyone misses and actually Oracle recommends against. That is backing up your online redo log files and doing that LAST. The reason is that there are more than likely active transactions that were recorded therein and those logs are not available. Can he complete the recovery, maybe if he has the remaining logs from the active system, I'm assuming he is recovering to somewhere other than his production system. Otherwise his only recourse is OTS. Dick Goulet Oracle Certified 8i DBA Reply Separator Author: Jonathan Gennick [EMAIL PROTECTED] Date: 5/1/2001 8:55 PM Fellow list members, I received the following email from a reader a few minutes ago. If you skip down to where he talks about backup, you'll see that he's in trouble with a database that won't recover. I've already suggested that he open a TAR, and that he supply more specifics as to error messages and the like, but maybe someone on this list can draw some conclusions from what he's told me so far. If you're good at recovery, have a look at what he says. I'll post his email address later if he says its ok, and I'll pass on any advice/suggestions I receive in the meantime. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Fwd: please help
Man, I had to laugh with this one. And I really need it because I have been in the middle of a downtime. Got paged at 3:30am. I only went to bed at midnight so I am a little punchy right now -Original Message- Sent: Thursday, May 03, 2001 10:46 AM To: Multiple recipients of list ORACLE-L Jared, I think you hit the nail on the head when you said Best practice of course is to make a backup of your database in it's current condition prior to restoring it. Too many recoveries are failures because DBAs tend to forget basics when confronted with the pressures from management, users, and the constraints of time (primary key). I made this mistake once early on. Now if I have a possible recovery scenario, the first thing I do is take a deep breath, get a cup of coffee, and THINK about what I'm going to do before I ever touch the keyboard. Absent all that, I still make a copy of the redo logs whenever I do a backup. Yeah, you could mess up and apply them inadvertently, but hopefully you will have practiced recovery scenarios (see Training a DBA by Kimberly Smith) and be comfortable with your tapes, disks, commands, systems administrator, etc. At least if you've got them, and everything goes to h*%$ in a handbasket, you can always give 'them' back something. David A. Barbour Jared Still wrote: Dick, Backing up the redo logs can have some serious consequences. Let's say you are restoring the database files, and a number of archived logs to roll forward through. Following that, you are going to roll forward through all archived logs that are still online, and then through your current redo logs for a complete recovery. Restoring old redo logs would render this strategy ineffective. Backing them up can be a good thing, but it would be very easy to inadvertently wipe out the current ones when restoring from tape. Best practice of course is to make a backup of your database in it's current condition prior to restoring it. It would also be prudent to make copies of the redo logs locally so you don't have to restore them from tape. Jared On Wednesday 02 May 2001 07:24, [EMAIL PROTECTED] wrote: Jonathan, It would appear that your friend has hit upon one of the problems of hot backups that everyone misses and actually Oracle recommends against. That is backing up your online redo log files and doing that LAST. The reason is that there are more than likely active transactions that were recorded therein and those logs are not available. Can he complete the recovery, maybe if he has the remaining logs from the active system, I'm assuming he is recovering to somewhere other than his production system. Otherwise his only recourse is OTS. Dick Goulet Oracle Certified 8i DBA Reply Separator Author: Jonathan Gennick [EMAIL PROTECTED] Date: 5/1/2001 8:55 PM Fellow list members, I received the following email from a reader a few minutes ago. If you skip down to where he talks about backup, you'll see that he's in trouble with a database that won't recover. I've already suggested that he open a TAR, and that he supply more specifics as to error messages and the like, but maybe someone on this list can draw some conclusions from what he's told me so far. If you're good at recovery, have a look at what he says. I'll post his email address later if he says its ok, and I'll pass on any advice/suggestions I receive in the meantime. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: David A. Barbour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kimberly Smith INET: [EMAIL PROTECTED] Fat City Network Services
Re: Cursor statistics request
Under Oracle Financials: NAME minavgvar max --- -- -- opened cursors cumulative 0201 3222968 opened cursors current 0 31 6 335 Order entry system:NAME minavgvar max --- -- -- opened cursors cumulative 0302 4836013 opened cursors current 0 20 4 65 Datawarehouse:NAME minavgvar max --- -- -- opened cursors cumulative 0 27 7 597 opened cursors current 0 7 2 22 Info: Database up time 20 Hours(database bounced everyday for snapshot) Load : user sessions between 300 to 500 HTH, Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Thu, 03 May 2001 10:05:35 -0800 Hey DBAs for big databases, Would you mind running this simple query? I am building a case that we have an extremely unheathly application, and would like to (a) do a reality check, and (b) anonymously cite evidence from other sites. col name format a35 col min format 999 col max format 999 col avg format 9 col var format 9 select name, min(value) min, avg(value) avg, sqrt(stddev(value)) var, max(value) max from v$sesstat ss, v$statname sn where sn.statistic#=ss.statistic# and sn.statistic# in (2,3) group by name / When I run this on my troubled system, I get: NAME minavgvar max --- -- -- - opened cursors cumulative 0 46325561 3748748 opened cursors current 0 54 9 345 And this for a instance only up for about a week. Oh, speaking of which, please tell me how long your instance has been up, and a rough idea of average user load, during the core processing hours. Thanks! - Ross || -Original Message- || From: Steve Adams [mailto:[EMAIL PROTECTED]] || Sent: Tuesday, May 01, 2001 11:00 AM || To: Multiple recipients of list ORACLE-L || Subject: RE: Oracle What savepoints are active for a given session? || || || Hi Venkata, || || There is no V$ view or X$ table that contains this || information. The only || solution that occurs to me is to dump the savepoints to the || process trace file || with || || alter session set events 'immediate trace name savepoints'; || || and then use UTL_FILE to read and parse the trace file || information. Here is an || example of what you might get: || || SAVEPOINT FOR CURRENT PROCESS || -- ||flag: 0x3 ||name: S3 ||dba: 0x831408, sequence #: 964, record #: 12, savepoint #: 19082 ||status: VALID, next: 3822f60 ||name: S2 ||dba: 0x831408, sequence #: 964, record #: 11, savepoint #: 19046 ||status: VALID, next: 37f63ec ||name: S1 ||dba: 0x831408, sequence #: 964, record #: 10, savepoint #: 18602 ||status: VALID, next: 0 || || This process has three savepoints named S1, S2 and S3 respectively. || || @ Regards, || @ Steve Adams || @ http://www.ixora.com.au/ || @ http://www.christianity.net.au/ || || || -Original Message- || Sent: Tuesday, 1 May 2001 18:20 || To: Multiple recipients of list ORACLE-L || || || HI PLEASE SEND ME ANSWER || Question Title: Oracle What savepoints are active for a || given session? || || Detailed Question: Does anybody know IF and HOW can I get a list of || active savepoints for the current session? I need a native way, not || solutions based on additional application-level || housekeeping. Some query || on the V$ tables/views would be the kind of answer I'm looking for. || Details: Within one stored proc I'd like to obtain a list || (in any form) || of the savepoints issued currently in the current || transaction. Example: || Proc A issues savepoint svA; then proc B issues savepoint || svB; and then || proc C builds and uses a cursor having 'svA' and 'svB' as rows, or || something like that. Of course, there are no intervening commits or || rollbacks. || || -- || Please see the official ORACLE-L FAQ: http://www.orafaq.com || -- || Author: Steve Adams || INET: [EMAIL PROTECTED] || || Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 || San Diego, California-- Public Internet access / || Mailing Lists || || To REMOVE yourself from this mailing list, send an E-Mail message || to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in || the message BODY, include a line containing: UNSUB ORACLE-L || (or the name of mailing list you want to be removed from). You may || also send the HELP command for other information
Re: data encryption
I wrote an article on this that may be of use to you. www.cybcon.com/~jkstill/util Jared On Thursday 03 May 2001 02:35, Andor, Gyula wrote: Hi Gurus ! Is there any standard method to encrypt data? We are making an application that uses application-level privilege system, so we should store passwords for users. Of course we want to store encrypted passwords, but we don't know if is there an existing way for this or try develop own encryption. What do you suggest? Thanks in advance Gyula -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Metalink Praise
No, he just sent the ACK so far. || -Original Message- || From: Bill Wagman [mailto:[EMAIL PROTECTED]] || Sent: Thursday, May 03, 2001 2:27 PM || To: Multiple recipients of list ORACLE-L || Subject: Re: Metalink Praise || || || Well that's fine but did the support person give you the correct || information? I have an open TAR re ORA-3113 when starting an || 8.1.7 database || on Solaris via sqlplus. I was told I should use svrmgrl as I || might not have || proper privileges when connected internal using sqlplus. || SInce 8.1.6 hasn't || oracle been telling us svrmgrl will be desupported? Perhaps || they just || forgot to tell the support people g. || || At 08:51 AM 5/3/01 -0800, Mohan, Ross wrote: || something amazing just happened. || || I logged an iTar without delay. It was easy. || || An analyst picked it up within 15 minutes and || sent me a i've got it mail. || || If this keeps up on a consistent basis, I am || in grave danger of developing a positive opinion || of OWS. || || figured i'd share the good news, as I often share || the bad || || - Ross || || p.s. boy, I'd really like some good fresh steak || for lunch without any additives, corn-fed, etc. || || || Bill Wagman || Univ. of California at Davis || Information Resources || [EMAIL PROTECTED] || (530) 754-6208 || || - || || I like to pick up hitchhikers. When they get in the car I || say, 'Put on your || seat belt. I want to try something. I saw it once in a || cartoon, but I think || I can do it.' || - Steven Wright || || -- || Please see the official ORACLE-L FAQ: http://www.orafaq.com || -- || Author: Bill Wagman || INET: [EMAIL PROTECTED] || || Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 || San Diego, California-- Public Internet access / || Mailing Lists || || To REMOVE yourself from this mailing list, send an E-Mail message || to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in || the message BODY, include a line containing: UNSUB ORACLE-L || (or the name of mailing list you want to be removed from). You may || also send the HELP command for other information (like subscribing). || -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohan, Ross INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re[2]: Q: might be really old topic, but please take a look
Oracle VS Sybase Oracle, wide install base, plenty of developers/dba's although they can get pricey. Large market share makes for a stable company. Has abundant development and management tools available + a healthy third party market. Sybase, shrinking install base, trained people appear to be in short supply consequently their hard to find and very pricey. Small market share makes for an somewhat unstable company that may become an acquisition target. Native third party tools do not appear to be plentiful. Unix vs. NT Unix, widely used, multiple vendors, lots of training available, platforms can be expensive (HP's) to very modestly priced (Intel running Linux). Trained people available. Very long history so it's stable. NT, somewhat widely used though not as much as Unix. One vendor (MicroSoft), inexpensive platforms (Intel based). It's instability is well documented all over the WEB. Training and trained people are plentiful. Now which way do you go, depends on what da'management wants to do. Sybase I'd shy away from. Their profits are down and have been falling for some time. I just looked on the WEB their stock is down again for the day so far, so are the analysts expectations. This puts them into a fine position to become the target of an acquisition sometime in the future which could have a very negative impact on your project(s). On the other hand that may be a good thing as well, depends on your point of view. So that leaves Oracle. At least you don't have to worry about them going away anytime in the foreseeable future. As for operating systems, Believe it or not, I'll recommend you start out on NT. Why, because it's simple that's why. It also does not preclude your moving upwards onto a Linux (reuse that NT hardware) or full blown Sun, HP-UX, or other Unix box as your needs and budget allow. If you've got the time and a small budget, take a real hard look at Linux. This OS has really knocked my socks off. It's inexpensive to acquire, easy to install you'll probably do that 10 times before you get it the way you want, and remarkably reliable and robust and scalable. Dick Goulet Reply Separator Author: Tim Sawmiller [EMAIL PROTECTED] Date: 5/3/2001 9:51 AM In each case, it's good versus evil... [EMAIL PROTECTED] 05/03/01 01:36PM Probably this has been posed million times, but I really like to know. We'll have a meeting about this in our company, and I'd love to contribute someting. Any idea on the following issue, any link, paper, etc, will be greatly appreciated. pros and cons of 1. Oracle vs Sybase 2. Unix vs NT Leslie __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Leslie Lu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tim Sawmiller INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: might be really old topic, but please take a look
Leslie, Sybase is what SQL Server is built from, I think. I don't know much about Sybase, but I Know that SQL Server 7 only has one transaction log file (redo log file), that you have to back up regularly and truncate otherwise your database will freeze. In SQL server there is no such thing as an archived log, you have to back up the transaction log's datafile to get your backup of transactions. This is just one example. Does Sybase support multiple log files? What about multiple archiving processes? That was a bit of a bottleneck in Oracle7 for us, and I had created the max number of redo log files. I can't imagine what it would be like with only one transaction log file... I am looking forward to our upgrade to 8.1.6., I am curious to see what multiple archiving processes can do. Re. NT and UNIX, does Microsoft still sell NT? Here we could only by Windows2000 licenses. : ) NT is good for small to medium databases that are not too mission critical, in my opinion, but from experience I much prefer UNIX. I know you probably want numbers to compare, maybe you could ask DBAs how long their NT and UNIX servers have been running without interruption, and why they were brought down the last time... Last I read on the 'net the new Windows versions will have new names. The personal software (read Win9x/ME stream plus NT Workstation) will be called WindowsXP, while the corporate operating systems (read: NT Server 4 and NT Dataserver) will be called Windows2002. I don't know when these new versions will be released, I think that for Windows2002 MS is aiming for 4th quarter of 2001 at this point. That is... this coming Autumn! Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -Original Message- From: Streeter, Lerone A LBX [SMTP:[EMAIL PROTECTED]] Sent: Thursday, May 03, 2001 3:27 PM To: Multiple recipients of list ORACLE-L Subject:RE: might be really old topic, but please take a look briefly: our choice was oracle/NT, based mainly on division/corporate direction which was based on the strengths of oracle. widely installed, industry leader, robust platform. NT was a no-brainer; the majority of our knowledge is NT. price and complexity were considered also, even though you have more control over *nix, the price of boxii to run it on as well as the cost of training and associated learning curve made *nix an unattractive option. our user base is small-to-medium so an NT solution should suffice, if we were larger or more widely dispersed or web based; we'd look harder at *nix. remember i said brief. === Lerone Streeter System Analyst Abbott LBG [EMAIL PROTECTED] === -Original Message- Sent: Thursday, May 03, 2001 1:51 PM To: Multiple recipients of list ORACLE-L Oh, ha! that is an old one: Oracle on Unix is the only choice. No need to research at all! Just go out and buy one! :) Ross p.s. give us more info, and you'll get a higher quality answer. GIGO || -Original Message- || From: Leslie Lu [mailto:[EMAIL PROTECTED]] || Sent: Thursday, May 03, 2001 1:37 PM || To: Multiple recipients of list ORACLE-L || Subject: Q: might be really old topic, but please take a look || || || Probably this has been posed million times, but I || really like to know. We'll have a meeting about this || in our company, and I'd love to contribute someting. || Any idea on the following issue, any link, paper, etc, || will be greatly appreciated. || || pros and cons of || || 1. Oracle vs Sybase || || 2. Unix vs NT || || || Leslie || || __ || Do You Yahoo!? || Yahoo! Auctions - buy the things you want at great prices || http://auctions.yahoo.com/ || -- || Please see the official ORACLE-L FAQ: http://www.orafaq.com || -- || Author: Leslie Lu || INET: [EMAIL PROTECTED] || || Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 || San Diego, California-- Public Internet access / || Mailing Lists ||
Removing Oracle products from NT
Hey all, I know that this has been addressed on the list before, so if there's an archive yet (I've been away for a bit) just point me to it. I made the terrible, heinous mistake of 1) installing Personal Oracle 8.1.6 on my laptop, which went well, then 2) installing Oracle Developer 6i on the same laptop. I was unaware that Dev does not play with 8.1, as I have been fortunate enough not to deal with bloody GUI's for many years now. Now, when I try to uninstall 6i, the installer crashes. I can't uninstall the DB, because of registry variables that point to the wrong Oracle home, and when I try to manually change them, nothing works at all. Can I just trash the directories, search for all registry variables and remove them? Or do I need to format the disk? :) Diana Duncan TITAN Technology Partners One Copley Parkway, Ste 540 Morrisville, NC 27560 VM: 919.466.7337 x 316 F: 919.466.7427 E: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
EXPORT vs. Hot Physical Backup
Which is a better way to back up a database - use EXPORT/IMPORT or physical datafile backups? Chris -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Chris Rezek INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: where's the NT pfile?
Actually that seems to be a file that points to the file in the pfile directory, the password file is also located here. If you want to know what pfile is associated with what db you can just open it up, not to mention that it will be uder the directory with the same name as the DB. Kev -Original Message- Pettinato Sent: Thursday, May 03, 2001 2:51 PM To: Multiple recipients of list ORACLE-L 8.1.7 should be in the \oracle\ora81\database directory 8.0.X should be in the \orant\database directory HTH, Frank Pettinato Oracle DBA -Original Message- Sent: Thursday, May 03, 2001 11:21 AM To: Multiple recipients of list ORACLE-L I've got an easy one. I'm getting back to NT and I am trying to find what parameter file was used when creating the Oracle service with oradim. I know I can edit the setting to any init.ora I want, but isn't there some way to see which one is currently used? Henry -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Henry Poras INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Frank N. Pettinato INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Kostyszyn INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Removing Oracle products from NT
Diana, Actually 8i does work with Dev 6i, but you have to install Developer first and into the default home then you create a new home for 8i and install it there. To remove Oracle from the machine you do not need to format the drives, just shut down all services and delete the directories..All of the directory's. Then run regedit go to HKEY_LOCAL_MACHINE--SOFWARE and delete the Oracle key, look for anything oracle in the ODBC key and delete it, under HKEY_LOCAL_MACHINE--SYSTEM--Current Control Set delete all oracle and under SYSTEM--Current Control--eventlog--application remove all oracle. You may also right click on MyComputer icon go to properties and remove all oracle from the Path key, if Oracle is the only software in there I usually just delete the path key all together. This will give you a clean machine. I believe there is actually a document for this on Metastink. Kev -Original Message- [EMAIL PROTECTED] Sent: Thursday, May 03, 2001 3:16 PM To: Multiple recipients of list ORACLE-L Hey all, I know that this has been addressed on the list before, so if there's an archive yet (I've been away for a bit) just point me to it. I made the terrible, heinous mistake of 1) installing Personal Oracle 8.1.6 on my laptop, which went well, then 2) installing Oracle Developer 6i on the same laptop. I was unaware that Dev does not play with 8.1, as I have been fortunate enough not to deal with bloody GUI's for many years now. Now, when I try to uninstall 6i, the installer crashes. I can't uninstall the DB, because of registry variables that point to the wrong Oracle home, and when I try to manually change them, nothing works at all. Can I just trash the directories, search for all registry variables and remove them? Or do I need to format the disk? :) Diana Duncan TITAN Technology Partners One Copley Parkway, Ste 540 Morrisville, NC 27560 VM: 919.466.7337 x 316 F: 919.466.7427 E: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Kostyszyn INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Removing Oracle products from NT
Trash the directories, kill the registry entries and you're golden. I kill Oracle on windoze all the time this way. Dan -Original Message- Sent: Thursday, May 03, 2001 3:16 PM To: Multiple recipients of list ORACLE-L Hey all, I know that this has been addressed on the list before, so if there's an archive yet (I've been away for a bit) just point me to it. I made the terrible, heinous mistake of 1) installing Personal Oracle 8.1.6 on my laptop, which went well, then 2) installing Oracle Developer 6i on the same laptop. I was unaware that Dev does not play with 8.1, as I have been fortunate enough not to deal with bloody GUI's for many years now. Now, when I try to uninstall 6i, the installer crashes. I can't uninstall the DB, because of registry variables that point to the wrong Oracle home, and when I try to manually change them, nothing works at all. Can I just trash the directories, search for all registry variables and remove them? Or do I need to format the disk? :) Diana Duncan TITAN Technology Partners One Copley Parkway, Ste 540 Morrisville, NC 27560 VM: 919.466.7337 x 316 F: 919.466.7427 E: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ This e-mail message has been scanned for the presence of all known computer viruses by the MessageLabs Virus Control Center. However, it is still recommended that you use local virus scanning software to monitor for the presence of viruses. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dasko, Dan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Cursor statistics request
Ross, Around 500 users, uptime 26days; OLTP system NAME minavgvar max --- -- -- opened cursors cumulative 0 10611282 1107346 opened cursors current 0161 11 250 -Original Message- SNIP When I run this on my troubled system, I get: NAME minavgvar max --- -- -- - opened cursors cumulative 0 46325561 3748748 opened cursors current 0 54 9 345 And this for a instance only up for about a week. Oh, speaking of which, please tell me how long your instance has been up, and a rough idea of average user load, during the core processing hours. Thanks! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hand, Michael T INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
OT: Metalink rant
I know Ross was a bit overwhelmed with Metalink earlier today but I'm going to hold off on my applause until they can figure out their shared pool problems. I think this will be fixed in V9.1.4 of the database. I've received this at least once every day this week when visiting Metalink. Thu, 3 May 2001 18:44:11 GMT ORA-04031: unable to allocate 2550012 bytes of shared memory (large pool,unknown object,session heap,bind var buf) DAD name: plsql PROCEDURE : per_hom.startup USER : bwisniewski URL: http://metalink.oracle.com:80/metalink/plsql/per_hom.startup PARAMETERS : - Brian __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Brian Wisniewski INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
wrong setting of sort_area_size
we had a customer of the sort_area_size=1000 in their database, the temp table space is 256MB, the db_block_size is 8k. They have some performance problem, I think it's probably related to the setting of sort_area_size(we have only one user). So what's the benefits/disadvantage of too big sort_area_size? Thanks, Chris __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: CC Harvest INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Oracle/Sybase NT/Unix
I deleted the message from the person wanting to know about Oracle V Sybase and NT V Unix. It appears the answer is Linux on the mainframe (running Oracle of course) http://dailynews.yahoo.com/h/cn/20010503/tc/venezuela_banks_on_ibm_linux_mainframe_1.html - Brian __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Brian Wisniewski INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Removing Oracle products from NT
Doc ID: Note:74790.1 Subject: Cleanly Deinstalling RDBMS Software from 95/98/NT Type: BULLETIN Status: PUBLISHED Content Type: TEXT/PLAIN Creation Date: 08-OCT-1999 Last Revision Date: 05-SEP-2000 Language: USAENG Cleanly Deinstalling Oracle RDBMS Software from Windows 95/98/NT Machines Purpose This bulletin explains how to remove Oracle software from a Windows 95, 98, or NT system. Scope Application --- This bulletin assumes the reader has a thorough understanding of the operating system and the Windows registry. Related Documents - [NOTE:61621.1] Recreating Oracle7 / Oracle8 services and instances from the command line Introduction Removing or deinstalling Oracle software from an 95/98/NT operating system requires several steps to completely creating a 'clean' machine. This document explains what must be done to remove all Oracle software from the system. Warning --- 1) Backup Be careful, because these steps remove all Oracle software, Oracle services, and Oracle registry entries from the system. So it is advisable that you first perform a backup, if required, of certain files like: SQL*Nnet configuration files Database files Self-written scripts that are stored under the oracle home directory, etc. 2) The following procedures require the editing of Windows registry, which is a potentially dangerous operation. There is no undo option in the Registry Editor. Content --- A. 32-bit on Windows NT B. 32-bit on Win95/Win98 C. 16-bit A. 32-bit on Windows NT --- 1. Ensure that you are logged in as a user with Administrator privileges. 2. Stop all Oracle-related services and all Oracle programs. 3. Remove the database services via the oradim command. This can be done via ORADIMXX -DELETE -SID SID or via the 'SC' tool of the resource kit. For a full explanation on using the ORADIM command, see [NOTE:61621.1]. As from 8.1.6, the method for deinstalling is to first run Net8CA in Deinstall mode, then run DBCA to delete a database, then run OUI to deinstall the products. At this point, all services should be removed. 4. Start the ODBC administrator applet, if installed, and remove any Oracle DSN definitions. 5. Remove the Oracle software via the Oracle installer or the Universal Installer (8.1.5 and onwards). Make sure that all services related to Oracle are stopped first. Note that you cannot remove the installer itself. If Legato Storage Manager is installed on the system, then remove it via the uninstaller executable that is shipped with Legato. Start-Programs-Networker-Uninstall Networker Caution: If Legato Storage Manager was installed independently of Oracle, DO NOT REMOVE LSM, because your system's backup environment may be adversely affected. 6. Start the Event Viewer, Log-Application, and clean up the application logs for Oracle. 7. Start the registry editor. This can be done via regedit or regedt32. a) If the Oracle Universal Installer (OUI) was used, go to HKEY_LOCAL_MACHINE\Software\Oracle and write down the value of the INST_LOC variable. This shows you where the OUI software is installed. This can then be used to remove the OUI from the machine afterwards. b) Go to HKEY_LOCAL_MACHINE\Software and remove the ORACLE key, look into the ODBC key for any 'leftovers' of Oracle. If they exist, then remove them as well. c) Go to HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services and verify that all services that start with 'Oracle' are removed. If this is not the case, then remove the services starting with 'Oracle' (database related) and the ones that start with 'OraWeb' (Oracle Application Server related). No entries will not be removed from the services dialog box until you reboot. d) Go to HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\EventLog\ Application and look for keys that start with 'Oracle'.
Re: Removing Oracle products from NT
Diana, SMILE ON Get RedHat 7 CD-ROM Insert into CD-ROM drive Reboot and answer promts SMILE OFF In reality. To gut the machine of all Oracle stuff. 1. Delete all the stuff in the Oracle directories. 2. Remove all the Oracle stuff from the start menu. 3. BACKUP YOUR REGISTRY!! 4. If you skipped step 3 go back and do step 3. 5. In regedit, remove the HKEY_LOCAL_MACHINE/software/ORACLE key. Then start at the top of the registry and search for oracle, oradac, and orant (if that was the tree your Oracle was installed in). Delete the keys you come to that are associated with these things. 6. Reboot your machine. Oracle is gone now. Start your reinstall. I have found the best way to install the Oracle products is in order of installer version. If you put the Designer/Developer stuff on first and then add the 8i stuff you should be able to get it to work. Seriously if you want to stay away from Windows, Developer 6i is available for Linux (download from technet). You need to have OpenMotif www.opengroup.org/openmotif/ loaded before running the installer. The installer is text mode, but it looks for Motif libs during the install. HTH Rodd Holman Original Message On 5/3/01, 2:16:24 PM, [EMAIL PROTECTED] wrote regarding Removing Oracle products from NT: Hey all, I know that this has been addressed on the list before, so if there's an archive yet (I've been away for a bit) just point me to it. I made the terrible, heinous mistake of 1) installing Personal Oracle 8.1.6 on my laptop, which went well, then 2) installing Oracle Developer 6i on the same laptop. I was unaware that Dev does not play with 8.1, as I have been fortunate enough not to deal with bloody GUI's for many years now. Now, when I try to uninstall 6i, the installer crashes. I can't uninstall the DB, because of registry variables that point to the wrong Oracle home, and when I try to manually change them, nothing works at all. Can I just trash the directories, search for all registry variables and remove them? Or do I need to format the disk? :) Diana Duncan TITAN Technology Partners One Copley Parkway, Ste 540 Morrisville, NC 27560 VM: 919.466.7337 x 316 F: 919.466.7427 E: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rodd Holman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
distributed_lock_timeout
Hello I need help on this. We have a Oracle 7.3.4 database and Oracle 8.1.6 database The application is as follows package in Oracle 8.1.6 calls package in Oracle 7.3.4 using Database link Package in Oracle 7.3.4 does a lot of processing but now sometimes Oracle 7.3.4 package gives distributed lock timeout error and sometimes Oracle 8.1.6 packages gives this error. This has made us wonder 'what is happeneing'! Can someone help me with a. understaning this phenomenon b. in oracle 8.1.6 the parameter distributed_lock_timeout is obsolete and the users want to run this package is there someway of 'running' this c. Is this type of processing ie calling package executing a lot of statements called package also executing a lot of statements and the final commit being back in the calling package the 'suggested' (recommended) way? isn't there a better way of doing this? Thanks _ Chat with your friends as soon as they come online. Get Rediff Bol at http://bol.rediff.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cyril Thankappan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Metalink Praise
LoL!!!Sorry! Guess the single analyst they have working on MetaLink is bringing the system to it's knees once he started work on my tar. -Original Message- Sent: Thursday, May 03, 2001 3:22 PM To: Multiple recipients of list ORACLE-L I'd put out that smoke. Am getting pl/sql errors again from metalstink...Ross, dude, you jinxed it! -Original Message- mailto:[EMAIL PROTECTED] ] Sent: Thursday, May 03, 2001 11:52 AM To: Multiple recipients of list ORACLE-L LoLI am still feeling the afterglow...having a smokeG || -Original Message- || From: Kevin Kostyszyn [ mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] ] || Sent: Thursday, May 03, 2001 2:21 PM || To: Multiple recipients of list ORACLE-L || Subject: RE: Metalink Praise || || || Ross, now relax, it's probably not possible for you to form || a positive || opinion about anything that has to do with Metaslack. || || -Original Message- || Sent: Thursday, May 03, 2001 12:51 PM || To: Multiple recipients of list ORACLE-L || || || something amazing just happened. || || I logged an iTar without delay. It was easy. || || An analyst picked it up within 15 minutes and || sent me a i've got it mail. || || If this keeps up on a consistent basis, I am || in grave danger of developing a positive opinion || of OWS. || || figured i'd share the good news, as I often share || the bad || || - Ross || || p.s. boy, I'd really like some good fresh steak || for lunch without any additives, corn-fed, etc. || -- || Please see the official ORACLE-L FAQ: http://www.orafaq.com http://www.orafaq.com || -- || Author: Mohan, Ross || INET: [EMAIL PROTECTED] || || Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 || San Diego, California-- Public Internet access / || Mailing Lists || || To REMOVE yourself from this mailing list, send an E-Mail message || to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in || the message BODY, include a line containing: UNSUB ORACLE-L || (or the name of mailing list you want to be removed from). You may || also send the HELP command for other information (like subscribing). || || -- || Please see the official ORACLE-L FAQ: http://www.orafaq.com http://www.orafaq.com || -- || Author: Kevin Kostyszyn || INET: [EMAIL PROTECTED] || || Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 || San Diego, California-- Public Internet access / || Mailing Lists || || To REMOVE yourself from this mailing list, send an E-Mail message || to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in || the message BODY, include a line containing: UNSUB ORACLE-L || (or the name of mailing list you want to be removed from). You may || also send the HELP command for other information (like subscribing). || -- Please see the official ORACLE-L FAQ: http://www.orafaq.com http://www.orafaq.com -- Author: Mohan, Ross INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohan, Ross INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
OT -- history of Sybase spawning MS SQL Server
More info since this is s-u-c-h a fascinating topic. In case you're wondering, it's past the end of the work day here for me, so I'm not wasting time... ironically I'm staying late to study for a SQL Server 7 Administration exam! Here goes, mind you this is from the lead developer for MS SQL Server, so keep that in mind. Inside SQL Server 6.5, p. 5 Ashton-Tate, Microsoft and Sybase would work together to debut SQL Server on OS/2. (This was the first use of the name SQL Server. Sybase later renamed its DataServer product for UNIX and VMS Sybase SQL Server, the name by which it is known today.) Continuing with the quotes on the history: p.8 loosely summarized, MS and Sybase dropped Ashton-Tate because that company was focusing on their dBase IV Server Edition product, and SQL Server 1.0 was not much of a priority for them. At the time though Microsoft still saw SQL Server primarily as a way to push LAN Manager. So Sybase appears to have been the key developer for this project, the ones with the most stake in it. p.9. in 1991 SQL Server 1.1. was released to work with Windows 3.0.. Here the shift begins. p.10 - exact quote: It was a great day in the SQL Server group at Microsoft when in early 1991 Microsoft's agreement with Sybase was amended to give Microsoft read-only access to the source code, for the purpose of customer support. [...] As a small group of developers at Microsoft became adept with the SQL Server source code and internal workings, Microsoft began to do virtual bug fixes. Although we were still not permitted to alter the source code, we could identify line-by-line the specific modules that needed to be changed to fix a bug. Obviously, when we handed the fix directly to Sybase, high-priority bugs identified by Microsoft got resolved much quicker. Continuing, still p.10: After a few months of working in this way, the extra step was eliminated. By mid-1991, Microsoft could finally fix bugs directly. They still had to let Sybase review the fixes before applying them, because Sybase at that time was still nominally the owner of the base code for the database engine. p.11 on the purpose of SQL Server at that time: No hard limit was established, but in general, SQL Server for OS/2 was used for workgroups of 50 users or less. For larger groups, customers would buy a version of Sybase SQL Server for higher performance UNIX-based or VMS-based systems. Then IBM and Microsoft divorced, and OS/2 was left floundering. At the time Microsoft was planning to develop something similar called NT, but that would not be ready for another 2 years. During those two years, the Microsoft SQL Server group continued developing SQL Server for OS/2, at the same time as the rest of Microsoft was actively pushing Windows 3.0 instead of OS/2. P. 12 Microsoft worked on SQL Server 4.2. for OS/2 version 2.0, the version anticipated from IBM. This was the first 32-bit version of OS/2. Microsoft decided to just port the UNIX version of SQL Server to OS/2, because that was already 32-bit. Then IBM delayed the release of OS/2 2.0 from 1991 to late 1992, and Microsoft doubted that IBM would manage to release it at all. (quote from p.13). p.13 SQL Server v.4.2 entered beta testing in the fall of 1991, announced in January 1992, and shipped in March 1992. Version 4.2 truly had been a joint development between Microsoft and Sybase. The database engine was ported from the UNIX version 4.2 source code, with both Microsoft and Sybase engineers working on the port and fixing bugs. [...] ... for the first time it included a Windows GUI tool to make administration easier. p.14 In early 1992, however, we faced some uncertainty and external pressures. On one hand, our entire customer base was by definition using OS/2. Those customers made it clear that they wanted, indeed expected, a 32-bit version of SQL Server for OS/2 2.0 as soon as IBM shipped 2.0, and they intended to remain on OS/2 for the foreseeable future. But when OS/2 2.0 might be available was unclear. IBM claimed that OS/2 2.0 would ship by the fall of 1992. Steve Ballmer, Microsoft VP, made a well-known pledge to eat a floppy disk if IBM shipped the product in 1992. I was not one to doubt Steve. (I don't know if Steve ate a floppy disk or not.) At the same time senior management at MS were putting pressure on them to release a SQL Server version for NT as soon as possible, to be ready in time for the NT beta release. So they stopped developing it for OS/2. They continued producing minor patches, but that was the end of it. p. 16 At this time, Sybase was working on a new version of its product, to be named System 10. Eventually the two diverged, because of course for the MS developers SQL Server for NT was the priority, and System 10 was the priority for Sybase developers. We decided to compromise and specialize. Microsoft would port SQL Server version 4.2 for OS/2 to Windows NT, beginning immediately. Sybase would bring
RE: After Update on TABLE_NAME For Each Row... Triggers and
Here's an example.
create or replace trigger donuttin
after update on ian.test2
for each row
Declare
fhandle UTL_FILE.FILE_TYPE;
file_text varchar2(50);
Begin
fhandle :=
UTL_FILE.FOPEN('/tmp', 'utlfile.txt', 'A');
UTL_FILE.PUT_LINE(fhandle, 'old is '||:old.isint ||' new is ' ||:new.isint);
utl_file.fclose(fhandle);
end;
The triggering statement
update test2 set isint = 4 where isint = 3
*
ERROR at line 1:
ORA-02291: integrity constraint (IAN.TEST2_FK) violated - parent key not found
The isint name is not significant. No testing for integers is being done.
What's written to the file
SQL host cat /tmp/utlfile.txt
old is 3 new is 4
---
The problem doesn't only occur on a foreing key constraint violation, but also
violations ofcheck constraints and unique constraints, and I imagine primary
constraints as well for insert operations. Coding for all this would be very very
ugly. The code needs to be dynamic enough so it reflects the present contraints, and
mutating table problemn workarounds would need to be implemented.
Ian MacGregor
Stanford Linear Accelerator Center
[EMAIL PROTECTED]
Ian MacGregor
Stanford Linear Accelerator Center
[EMAIL PROTECTED]
-Original Message-
Sent: Thursday, May 03, 2001 10:42 AM
To: Multiple recipients of list ORACLE-L
Sounds strange. I'd be curious at what values the a similar trigger would
show if you captured :old and :new.
Henry
-Original Message-
Sent: Thursday, May 03, 2001 12:35 PM
To: Multiple recipients of list ORACLE-L
R.I.
A developer has an after update on table_name for each row ... trigger
which sends mail via the UTL_SMTP package. If the triggering statement is
something like, update saltab set dba_salary = dba_salary * 1000, and the
resultant value is too large. The mail is not sent. However, if the
statement is something like, update saltab set foreign_key_column =
'QWERTY' where
foreign_key column = 'ASDFGH', and an R.I. constraint violation occurs
because there is no parent key, ASDFGH, the mail is sent anyway.
I had thought that R.I. checking was done in the following manner for such a
trigger:
1. execute triggering event; 2. check for R.I. violations resulting from
step 1; 3. execute trigger logic; 4. check for R.I. violations caused by
the trigger; 5. Repeat for each row.
(In this case the trigger just sends mail so step 4 can be removed).
If this sequence of events is correct why is the mail sent? Is the R.I.
violation not placed on the error stack immediately? That seems unlikely.
Is the error stack not read until after the mail is sent? It was read for a
non-R.I. violation. Is Oracle programmed to defer reporting R.I.
violations on the error stack until after he trigger logic is processed?
I could be wrong in my understanding of the trigger logic; step 2 is
performed after step 3?
How does one stop the mail from being sent when an R.I. violation occurs.
One way would be to do the RI checking in trigger via a cursor which
queries the parent table, and then raises an exception if no parent key is
found. Is there another way?
Ian MacGregor
Stanford Linear Accelerator Center
[EMAIL PROTECTED]
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: MacGregor, Ian A.
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Henry Poras
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: MacGregor, Ian A.
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an
Getting ORA-01732 trying to insert into table (NOT view)
Why do I keep getting this error even though this object is not a view??? I am in as
the owner of the table, which has the DBA role to boot.
SQL show user
USER is FARS_OWNER
SQL select owner, object_name, object_type from dba_objects where object_name like
'%ALIASTYPE%';
OWNER OBJECT_NAME OBJECT_TYPE
--- -- --
PUBLIC MFGALIASTYPE SYNONYM
FARS_OWNER MFGALIASTYPE TABLE
FARS_OWNER MFGALIASTYPE_VALUE_PK INDEX
SQL select * from MFGALIASTYPE;
VA I ATTRIBUTE PROMPTNAME SORTORDER
-- - -- --- -
T F SN Temic Accelerometer SN 30
T SN Actual Serial Number 10
A F SN Accelerometer SN 40
C F SN Customer SN 20
D F SN Daughter Board SN 60
S F SN Sensor SN 50
6 rows selected.
SQL insert into MFGALIASTYPE values ('X', 'F', 'SN', 'Test', 80);
insert into MFGALIASTYPE values ('X', 'F', 'SN', 'Test', 80)
*
ERROR at line 1:
ORA-01732: data manipulation operation not legal on this view
BTW, the synonym is for the table so other users can access it without adding the
owner's name. I had already tried insert into FARS_OWNER.MFGALIASTYPE ... as well,
but didn't include that here.
Here's the table definition:
CREATE TABLE FARS_OWNER.MFGALIASTYPE (VALUE VARCHAR2(2),
ISDEFAULT VARCHAR2(1), ATTRIBUTE VARCHAR2(45), PROMPTNAME
VARCHAR2(45) NOT NULL ENABLE, SORTORDER NUMBER(2, 0)) PCTFREE 10
PCTUSED 40 INITRANS 1 MAXTRANS 255 LOGGING TABLESPACE TBL_TINY ;
ALTER TABLE FARS_OWNER.MFGALIASTYPE ADD CONSTRAINT
MFGALIASTYPE_VALUE_PK PRIMARY KEY (PROMPTNAME) USING INDEX
PCTFREE 10 INITRANS 2 MAXTRANS 255 TABLESPACE USER_DATA ENABLE
NOVALIDATE ;
This is using 8.1.5 EE on NT 4 SP6a.
Michael Ray
Oracle DBA
TRW, Marshall, IL
217-826-3011 x2438
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Michael Ray
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
RESOLVED: Removing Oracle products from NT
Thanks so much to everyone who replied! It seems to be working now. And, I agree completely with the RedHat idea, but this is my consulting laptop, and Windoze is very much the name of the game. Actually, at home I have RedHat, but I don't have Oracle -- it's running Postgres, which I must say I am LOVING!!! I'm working on a cool little site using Postgres and PHP on Apache and Linux. Open Source Rules! Back to expensive Oracle-land... Diana Duncan TITAN Technology Partners One Copley Parkway, Ste 540 Morrisville, NC 27560 VM: 919.466.7337 x 316 F: 919.466.7427 E: [EMAIL PROTECTED] Rodd Holman rodney.holman@lodTo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] genet.comcc: Sent by: Fax to: [EMAIL PROTECTED] Subject: Re: Removing Oracle products from NT 05/03/2001 04:18 PM Please respond to ORACLE-L Diana, SMILE ON Get RedHat 7 CD-ROM Insert into CD-ROM drive Reboot and answer promts SMILE OFF In reality. To gut the machine of all Oracle stuff. 1. Delete all the stuff in the Oracle directories. 2. Remove all the Oracle stuff from the start menu. 3. BACKUP YOUR REGISTRY!! 4. If you skipped step 3 go back and do step 3. 5. In regedit, remove the HKEY_LOCAL_MACHINE/software/ORACLE key. Then start at the top of the registry and search for oracle, oradac, and orant (if that was the tree your Oracle was installed in). Delete the keys you come to that are associated with these things. 6. Reboot your machine. Oracle is gone now. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: OT -- MS makes a statement about open-source software movemen t
http://dailynews.yahoo.com/h/nm/20010503/tc/microsoft_linux_dc_2.html http://dailynews.yahoo.com/h/nm/20010503/tc/microsoft_linux_dc_2.html Let me know what you think. : ) Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re:OT -- history of Sybase spawning MS SQL Server
Patrice. Hey thanks a lot. That's a pile of history that I had no idea of. I always believed that MS came up with SQL*Server on their own as a follow on to access. Well, Well what do you know, good old Bill is a real thief after all!!! Dick Goulet Reply Separator Author: Boivin; Patrice J [EMAIL PROTECTED] Date: 5/3/2001 12:49 PM More info since this is s-u-c-h a fascinating topic. In case you're wondering, it's past the end of the work day here for me, so I'm not wasting time... ironically I'm staying late to study for a SQL Server 7 Administration exam! Here goes, mind you this is from the lead developer for MS SQL Server, so keep that in mind. Inside SQL Server 6.5, p. 5 Ashton-Tate, Microsoft and Sybase would work together to debut SQL Server on OS/2. (This was the first use of the name SQL Server. Sybase later renamed its DataServer product for UNIX and VMS Sybase SQL Server, the name by which it is known today.) Continuing with the quotes on the history: p.8 loosely summarized, MS and Sybase dropped Ashton-Tate because that company was focusing on their dBase IV Server Edition product, and SQL Server 1.0 was not much of a priority for them. At the time though Microsoft still saw SQL Server primarily as a way to push LAN Manager. So Sybase appears to have been the key developer for this project, the ones with the most stake in it. p.9. in 1991 SQL Server 1.1. was released to work with Windows 3.0.. Here the shift begins. p.10 - exact quote: It was a great day in the SQL Server group at Microsoft when in early 1991 Microsoft's agreement with Sybase was amended to give Microsoft read-only access to the source code, for the purpose of customer support. [...] As a small group of developers at Microsoft became adept with the SQL Server source code and internal workings, Microsoft began to do virtual bug fixes. Although we were still not permitted to alter the source code, we could identify line-by-line the specific modules that needed to be changed to fix a bug. Obviously, when we handed the fix directly to Sybase, high-priority bugs identified by Microsoft got resolved much quicker. Continuing, still p.10: After a few months of working in this way, the extra step was eliminated. By mid-1991, Microsoft could finally fix bugs directly. They still had to let Sybase review the fixes before applying them, because Sybase at that time was still nominally the owner of the base code for the database engine. p.11 on the purpose of SQL Server at that time: No hard limit was established, but in general, SQL Server for OS/2 was used for workgroups of 50 users or less. For larger groups, customers would buy a version of Sybase SQL Server for higher performance UNIX-based or VMS-based systems. Then IBM and Microsoft divorced, and OS/2 was left floundering. At the time Microsoft was planning to develop something similar called NT, but that would not be ready for another 2 years. During those two years, the Microsoft SQL Server group continued developing SQL Server for OS/2, at the same time as the rest of Microsoft was actively pushing Windows 3.0 instead of OS/2. P. 12 Microsoft worked on SQL Server 4.2. for OS/2 version 2.0, the version anticipated from IBM. This was the first 32-bit version of OS/2. Microsoft decided to just port the UNIX version of SQL Server to OS/2, because that was already 32-bit. Then IBM delayed the release of OS/2 2.0 from 1991 to late 1992, and Microsoft doubted that IBM would manage to release it at all. (quote from p.13). p.13 SQL Server v.4.2 entered beta testing in the fall of 1991, announced in January 1992, and shipped in March 1992. Version 4.2 truly had been a joint development between Microsoft and Sybase. The database engine was ported from the UNIX version 4.2 source code, with both Microsoft and Sybase engineers working on the port and fixing bugs. [...] ... for the first time it included a Windows GUI tool to make administration easier. p.14 In early 1992, however, we faced some uncertainty and external pressures. On one hand, our entire customer base was by definition using OS/2. Those customers made it clear that they wanted, indeed expected, a 32-bit version of SQL Server for OS/2 2.0 as soon as IBM shipped 2.0, and they intended to remain on OS/2 for the foreseeable future. But when OS/2 2.0 might be available was unclear. IBM claimed that OS/2 2.0 would ship by the fall of 1992. Steve Ballmer, Microsoft VP, made a well-known pledge to eat a floppy disk if IBM shipped the product in 1992. I was not one to doubt Steve. (I don't know if Steve ate a floppy disk or not.) At the same time senior management at MS were putting pressure on them to release a SQL Server version for NT as soon as possible, to be ready in time for the NT beta release. So they stopped developing it for OS/2. They continued producing minor patches, but that was the end of it. p. 16 At this time, Sybase
RE: OT -- history of Sybase spawning MS SQL Server
Does anyone know which products M$ created *on their own* ?? Any ideas anyone? I know one BSOD .. yeah, they have the patent on it, what else? ??? Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art ! -Original Message- Sent: Thursday, May 03, 2001 5:22 PM To: Multiple recipients of list ORACLE-L Patrice. Hey thanks a lot. That's a pile of history that I had no idea of. I always believed that MS came up with SQL*Server on their own as a follow on to access. Well, Well what do you know, good old Bill is a real thief after all!!! [stuff deleted] * 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 ESPN at (860) 766-2000 and delete this e-mail message from your computer, Thank you. * -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jamadagni, Rajendra INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Anybody heard of LECCO?
Has anyone heard about a company called LECCO Technology and their products which supposedly use artificial intelligence to re-write and optimize SQL statements? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
ORA-7445 ERROR AND CORE DUMP
hi I am databse on sun solaris 2.7 and oracle8.1.6.I am getting the following error in alert log frequently.IS this error cause the database crash.Please help to come out from this problem. ORA-07445: exception encountered: core dump [dredseek()+388] [SIGSEGV] [Address not mapped to object] [174652931] [] [] Errors in file /u01/app/oracle/admin/sam/udump/sam_ora_1508.trc Thanks in advance. -Seema _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seema Singh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Anybody heard of LECCO?
Found this on Dogpile, looks like they have an evaluation download. LECCOTECH: Where the Experts go for Performance * LECCOTECH is a worldwide company delivering leading edge Relational Database Management System performance enhancement tools designed specifically for development teams and DBAs. Our award-winning flagship product, LECCO SQL Expert , automates t www.leccotech.com HTH, DM -Original Message- [EMAIL PROTECTED] Sent: Thursday, May 03, 2001 3:22 PM To: Multiple recipients of list ORACLE-L Has anyone heard about a company called LECCO Technology and their products which supposedly use artificial intelligence to re-write and optimize SQL statements? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: David Messer INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Book
Practical Oracle 8i:building efficient databases by Jonathan Lewis visit http://www.jlcomp.demon.co.uk/ Regards Suhen Can anyone suggest me a good book on database design and sizing and also on performance tuning,backup recovery. Thanks Ravindra -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ravindra Basavaraja INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Suhen Pather INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Security, Password policy
Hi all, Do you guys have any password policy knowledge to share? For Solaris 7, and Oracle 8i 8.1.6, Can anyone introduce me some good URL sites for those white paper ? Thank You Sinardy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinardy Xing INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Fwd: please help
Jonathan Gennick wrote: Fellow list members, I received the following email from a reader a few minutes ago. If you skip down to where he talks about backup, you'll see that he's in trouble with a database that won't recover. I've already suggested that he open a TAR, and that he supply more specifics as to error messages and the like, but maybe someone on this list can draw some conclusions from what he's told me so far. If you're good at recovery, have a look at what he says. I'll post his email address later if he says its ok, and I'll pass on any advice/suggestions I receive in the meantime. -- Best regards, Jonathan Gennick mailto:[EMAIL PROTECTED] * 906.387.1698 http://Gennick.com * http://MichiganWaterfalls.com * http://MetalDrums.org I have seen this error before - when the batch script that ran the hot backup job did not take the SYSTEM tablespace *OUT* of BACKUP mode. He should have selected file# from v$backup where status='ACTIVE'. I wasn't checking email while at IOUG. Sorry that I didn't see it sooner. with the database mounted, exec: ALTER DATABASE DATAFILE 'file_name' END BACKUP; ALTER DATABASE OPEN; and you're up. Paul Tuesday, May 01, 2001, 10:27:51 PM, X wrote: BC? Hi Jonathan, BC? I always read and like your articles in the Oracle BC? Magazine. BC? Could you please give me a moment of your time .. BC? I have some couple of pressing problems and questions BC? if you don't mind as i am under fire at work .. BC? I have trouble with some of the Oracle databases that BC? i manage on Sun Solaris platform, sometimes i have my BC? shutdowns hanging and this takes a very long time to BC? complete. Also, hanging problems with some of the sql BC? statements. Could you lend a hand about any possible BC? clues as to what i should do or where i should look BC? for answers. BC? My last question is about hotback. BC? I ran a hot backup yesterday and tried recovering BC? today. I was faced with an Oracle error saying system BC? tablespace needs more recovery and that open resetlogs BC? will get an error after automatically applying the BC? redo logs. BC? My backup strategy went this way, BC? i created a backup shell script and BC? i put all tablespaces in hotbackup mode at the same BC? time with this syntax.. BC? select 'alter tablespace' || tablespace_name ||'begin BC? backup;' BC? from dba_tablespaces BC? where status ?? 'INVALID'; BC? I copied my datafiles to backup using the syntax below BC? ... BC? !cp /u02/oradata/prod/system01.dbf/backup/prod BC? !cp BC? !cp BC? !cp BC? !cp BC? then ended backup the same way as i began backup BC? with the ||'end backup;' BC? I backed up my controlfile BC? and everything went well. Today, I restored my BC? datafiles from backup and i was greeted with the BC? problem i just expalined to you. BC? I am the only dba DBA at this location BC? and i need some advise on what to do as this is a BC? serious issue with my supervisor. BC? Thanks, BC? Bill -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Drake INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
