RE: Installation in Unix
go to http://technet.oracle.com/docs/products/oracle8i/content.html and chose the flavor of Unix you like. -Original Message-From: Ramon E. Estevez [mailto:[EMAIL PROTECTED]]Sent: Wednesday, March 06, 2002 1:50 PMTo: Multiple recipients of list ORACLE-LSubject: Installation in Unix Come on list, need your help, never deal with oracle in unix before. Any link, document or something to help me to install Oracle 8.1.7 in unix. Ramon
RE: Duplicate rows
Title: RE: Duplicate rows Delete duplicate records Sanjay Raj 06 Dec 2001, Rating 4.42 (out of 5) Here is a short Oracle script that deletes duplicate records from a table based on the unique columns selected: Rem del_dup.sql Rem Rem Script to delete duplicate rows from a table Rem Rem Enter Table_Name as MY_TABLE Rem And Column_List as COLUMN_1,COLUMN_2,COLUMN_3 ... Column_N Rem (i.e. no spaces) Rem Rem Accept table_name Prompt 'Enter Table Name: ' Accept column_list Prompt 'Enter Column List (no spaces): ' BEGIN LOOP DELETE FROM &table_name WHERE ROWID IN (SELECT MIN (ROWID) FROM &table_name GROUP BY &column_list HAVING COUNT (*) > 1); EXIT WHEN SQL%NOTFOUND; END LOOP; COMMIT; END; / -Original Message- From: Alexander Ordonez [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 06, 2002 10:33 AM To: Multiple recipients of list ORACLE-L Subject: Duplicate rows Hi gurus, I need detect and delete duplicate rows in any table, somebody helpme thanks!!! @lex Lic. Alexander Ordóñez Arroyo Caja Costarricense del Seguro Social Soporte Técnico - División de Informática Telefono: 295-2004, San José, Costa Rica [EMAIL PROTECTED] Icq# 30173325 The true is out there in WWW -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alexander Ordonez 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 Club ?
I have found www.bookpool.com to have the best prices and they generally are well stocked on the O'Reilly and Oracle Press books. Van -Original Message- Sent: Thursday, December 13, 2001 4:55 PM To: Multiple recipients of list ORACLE-L Hi, I want to join a book club to get benefit from the memebership deal. Does any one know a book club which has most Oracle, Jave books? Thanks for the info. Steven __ Do You Yahoo!? Check out Yahoo! Shopping and Yahoo! Auctions for all of your unique holiday gifts! Buy at http://shopping.yahoo.com or bid at http://auctions.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: steven wndy 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: Van M. Etheridge 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: SYS vs SYSTEM
Hi Ken, My guess is that you need to set up sys.dba_all_tables with a public synonym. HTH Van -Original Message- Sent: Thursday, November 29, 2001 11:50 AM To: Multiple recipients of list ORACLE-L 8.1.7 on W2000 select owner, table_name, tablespace_name from dba_all_tables; When I log into sqlplus as SYS is runs. When I log into sqlplus as SYSTEM I get the error table or view does not exit. What is happening here and how do I fix it? Thanks, Ken -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ken Janusz 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: Van M. Etheridge 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: Which index need rebuilding?
Try this one, I have found it useful: -- validate_idx.sql -- by Brian Peasland -- Database Administrator -- Raytheon / EROS Data Center -- 3 February 2000 -- -- This script will check indexes to find candidates for rebuilding. -- Run this script in SQL*Plus as a user with SELECT ANY TABLE -- privileges. -- -- This script can be used and modified without permission. Run this -- script at your own risk! The script author is not responsible for -- any problems that may arise from running this script. set serveroutput on size 10 DECLARE vOwner dba_indexes.owner%TYPE;/* Index Owner*/ vIdxName dba_indexes.index_name%TYPE; /* Index Name */ vAnalyze VARCHAR2(100); /* String of Analyze Stmt */ vCursor NUMBER;/* DBMS_SQL cursor*/ vNumRows INTEGER; /* DBMS_SQL return rows */ vHeight index_stats.height%TYPE; /* Height of index tree */ vLfRows index_stats.lf_rows%TYPE; /* Index Leaf Rows*/ vDLfRows index_stats.del_lf_rows%TYPE; /* Deleted Leaf Rows */ vDLfPerc NUMBER; /* Del lf Percentage */ vMaxHeight NUMBER; /* Max tree height*/ vMaxDelNUMBER; /* Max del lf percentage */ CURSOR cGetIdx IS SELECT owner,index_name FROM dba_indexes WHERE OWNER NOT LIKE 'SYS%'; BEGIN /* Define maximums. This section can be customized. */ vMaxHeight := 3; vMaxDel:= 20; /* For every index, validate structure */ OPEN cGetIdx; LOOP FETCH cGetIdx INTO vOwner,vIdxName; EXIT WHEN cGetIdx%NOTFOUND; /* Open DBMS_SQL cursor */ vCursor := DBMS_SQL.OPEN_CURSOR; /* Set up dynamic string to validate structure */ vAnalyze := 'ANALYZE INDEX ' || vOwner || '.' || vIdxName || ' VALIDATE STRUCTURE'; DBMS_SQL.PARSE(vCursor,vAnalyze,DBMS_SQL.V7); vNumRows := DBMS_SQL.EXECUTE(vCursor); /* Close DBMS_SQL cursor */ DBMS_SQL.CLOSE_CURSOR(vCursor); /* Does index need rebuilding? */ /* If so, then generate command */ SELECT height,lf_rows,del_lf_rows INTO vHeight,vLfRows,vDLfRows FROM INDEX_STATS; IF vDLfRows = 0 THEN /* handle case where div by zero */ vDLfPerc := 0; ELSE vDLfPerc := (vDLfRows / vLfRows) * 100; END IF; IF (vHeight > vMaxHeight) OR (vDLfPerc > vMaxDel) THEN DBMS_OUTPUT.PUT_LINE('ALTER INDEX ' || vOwner || '.' || vIdxName || ' REBUILD;'); END IF; END LOOP; CLOSE cGetIdx; END; / -Original Message- Sent: Friday, September 28, 2001 4:06 PM To: Multiple recipients of list ORACLE-L Hi How I can know which indexex need to rebuild? If someone has scripts please send it. Thanks -Seema _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seema Singh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 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: Van M. Etheridge 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: coalesce tablespace
Sandi It is my understanding that you can use the coalesce option of the alter tablespace command to force neighboring free extents to be coalesced regardless of the default pctincrease setting for the tablespace. Van -Original Message- Sent: Thursday, September 20, 2001 3:40 PM To: Multiple recipients of list ORACLE-L We have tablespaces in acceptance and production that are being resized for growth. Pctincrease is set at 0. Would it also help to coalesce the tablespace? What are the benefits of this command? Thanks, Sandi -- 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: Van M. Etheridge 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
Title: OT Hey List I'm at work in downtown DC and its really weird. Most public building are evacuating. The subways are closed so the streets are very busy with cars and pedestrians. I could see the smoke from the Pentagon fire from my office and heard the sonic boom from the military fighter planes being scrambled. It's like being in a black and white science fiction movie. You know the one where the flying saucer hits the Washington Monument. -Original Message-From: Koivu, Lisa [mailto:[EMAIL PROTECTED]]Sent: Tuesday, September 11, 2001 11:15 AMTo: Multiple recipients of list ORACLE-LSubject: OT I hope everyone on this list in the New York area is safe I am so scared. Lisa Koivu Oracle Database Administrator Fairfield Resorts, Inc. 954-935-4117
RE: Install oracle 7.3.4 in Solaris.
Go to Oracle Technology Network. You'll find it under the documentation section (http://technet.oracle.com/docs/products/oracle7/doc_index.htm) they have the following: Oracle7 Server for Sun SPARC Solaris 2.x, Release 7.3.4 Administrator's Reference for UNIX Installation Guide I have used this documentaion before and it's good information. It should get you through the install. BTW membership to OTN is free. Good luck! -Original Message- Sent: Wednesday, August 29, 2001 7:19 PM To: Multiple recipients of list ORACLE-L Hello listers, I have to install a server Oracle (7.3.4) on Sun Solaris but i've never done that before. Could some one show me the steps to follow or give me some address where i can find the informations please ? Thank you very much. Thanh-truc Nguyen -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nguyen Thanh-truc 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: Van M. Etheridge 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 RE: Burning game CD's
Tom. A number of things, at least in my experience, can cause the problems you are having. The media(the blank CD's) depending on what you are recording certain types of CD's are better than others and the play back device may not be able to properly read the CD recording. I have recorded music CD's that play fine on my CD player at work but do not work in my car CD player. Check the manual or online help that came with your system for more information specific to your hardware. I do not use my burner for games so I do not have any experience in that regard. My guess is that you burned the cd correctly, so to speak, just some of these or similar factors came into play. Have fun with your cd burner, I love mine even with these limitaions. So far I have been able to get around most of them to suit my needs. -Original Message- Sent: Monday, August 27, 2001 10:55 AM To: Multiple recipients of list ORACLE-L Off Topic: I bought a PC this weekend that had my first every CDROM burner. I couldn't wait to use it. I burned several game CD's (Age of Empires, Return Fire II, Roller coaster Tycoon) and none of them worked. The games just hung when I ran them. Bummer. Is it not possible to make copies of my CD's or am I doing something wrong? Tom Tom Terrian Oracle DBA WPAFB - DAASC [EMAIL PROTECTED] 937-656-3844 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Terrian, Tom 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: Van M. Etheridge 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: DBA tasks
check out the following site: http://www.revealnet.com/Pipelines/DBA/archives.htm#code28 and The Oracle DBA Checklists Pocket Reference (DBA Tasks and Procedures) published by O'Reilly You should find both useful. -Original Message- Sent: Friday, August 17, 2001 2:56 PM To: Multiple recipients of list ORACLE-L Hi... I'am searching for a oracle dba task guide. A doc that especifi all the task of a oracle dba. javs -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jairo Villalobos 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: Van M. Etheridge 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: Oracle pricing
Title: Oracle pricing Yes I have. On the last set of quotes I got from Orance the price ranged from $175,000 to $70,000 for the same set of products. It just depended on who I spoke with. I also think timing has something to do with it. Salesmen meeting quotas and the company reporting profit/loss. -Original Message-From: Koivu, Lisa [mailto:[EMAIL PROTECTED]]Sent: Thursday, July 26, 2001 11:47 AMTo: Multiple recipients of list ORACLE-LSubject: Oracle pricing Has anyone experienced Oracle sales people gouging each other? Seems like they are getting pretty cut throat. I got one quote for $400,000, and a second quote for less than 25% of that, from two different people. WOW. They are beginning to sound like the company I work for - different story from different people. Lisa Koivu Oracle Database Administrator 954-935-4117 The information in the electronic mail message is Cendant confidential and may be legally privileged, it is intended solely for the addressee(s) access to this internet electronic mail message by anyone else is unauthorized. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it is prohibited and may be unlawful. The sender believes that this E-mail and any attachments were free of any virus, worm, Trojan horse, and/or malicious code when sent. This message and its attachments could have been infected during transmission. By reading the message and opening any attachments, the recipient accepts full responsibility for taking protective and remedial action about viruses and other defects. Cendant Corporation or Affiliates are not liable for any loss or damage arising in any way from this message or its attachments.
RE: setting DbName in SQL*PLUS
I just tried it and it worked for me. Maybe there is a typo in the changes you made to gloing.sql -Original Message- Sent: Monday, July 23, 2001 1:57 PM To: Multiple recipients of list ORACLE-L I changed my glogin.sql logged out, logged back on to sqlplus and nothing happened... Is there anything else I need to do? -Original Message- Sent: Monday, July 23, 2001 12:26 PM To: Multiple recipients of list ORACLE-L Try this link: http://www.iherve.com/oracle/prompt_sqlplus.htm Script and explaination included. - Original Message - To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent: Friday, July 20, 2001 1:27 PM > Has anyone ever worked on setting the DbName as the sqlprompt in SQL*PLUS > thru glogin.sql? > > Shailesh > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Yadav, Shailesh > 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). _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andrew Lieu 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Van M. Etheridge 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: 7.3.4 Support
It is my understanding that error correction support ended 31-DEC-2000 and that extended assistance support ends on 31-DEC-2003. HTH Van -Original Message- Sent: Monday, July 16, 2001 2:21 PM To: Multiple recipients of list ORACLE-L 12/31/00 -Original Message- Sent: Monday, July 16, 2001 2:00 PM To: Multiple recipients of list ORACLE-L Can anyone tell me when Oracle officially ceased providing support for 7.3.4? Thanks, Jeff T [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Page, Bruce 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: Van M. Etheridge 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: License high water mark
This is what the manual says: Oracle Product Document Library(C) Oracle Corporation Manual: ORACLE 8.1.5 SERVER CODES Reference: A67785-01 ORA-12540 TNS:internal limit restriction exceeded Cause: Too many TNS connections open simultaneously. Action: Wait for connections to close and retry. -Original Message- Sent: Monday, June 25, 2001 10:01 AM To: Multiple recipients of list ORACLE-L My database is down!! In my Alert file is the following entries Fri Jun 22 19:00:00 2001 Restarting dead background process EMN0 EMN0 started with pid=18 Fri Jun 22 19:00:00 2001 Shutting down instance (immediate) License high water mark = 9 Fri Jun 22 19:00:04 2001 ALTER DATABASE CLOSE NORMAL Fri Jun 22 19:00:04 2001 SMON: disabling tx recovery SMON: disabling cache recovery Fri Jun 22 19:00:04 2001 Thread 1 closed at log sequence 438 Fri Jun 22 19:00:05 2001 Completed: ALTER DATABASE CLOSE NORMAL Fri Jun 22 19:00:05 2001 ALTER DATABASE DISMOUNT Completed: ALTER DATABASE DISMOUNT archiving is disabled I would think that the high water mark is the culprit. What exactly is the high water mark?? When I type in svrmgrl I get the following error ORA-12540 TNS: internal limit restriction exceeded. Any help or hints would be greatly appreciated. Thanks, Dave -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Farnsworth, Dave 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: Van M. Etheridge 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 : Internal error code.. Help!!!
Oracle Product Document Library(C) Oracle Corporation Manual: ORACLE 8.1.5 SERVER CODES Reference: A67785-01 ORA-00600 internal error code, arguments: [string], [string], [string], [string], [string], [string], [string], [string] Cause: This is the generic internal error number for Oracle program exceptions. It indicates that a process has encountered a low-level, unexpected condition. Causes of this message include: timeouts file corruption failed data checks in memory hardware, memory, or I/O errors incorrectly restored files The first argument is the internal message number. Other arguments are various numbers, names, and character strings. The numbers may change meanings between different versions of Oracle. Action: Report this error to Oracle Customer Support after gathering the following information: events that led up to the error the operations that were attempted that led to the error the conditions of the operating system and databases at the time of the error any unusual circumstances that occurred before receiving the ORA-00600 message contents of any trace files generated by the error the relevant portions of the Alter files Note: The cause of this message may manifest itself as different errors at different times. Be aware of the history of errors that occurred before this internal error. -Original Message- Sent: Tuesday, June 12, 2001 2:07 PM To: Multiple recipients of list ORACLE-L DBA's I am getting following error in alert.log once in two days. on Jun 11 09:26:11 2001 Errors in file /export/home/u01/app/oracle/admin/orcl/udump/orcl_ora_6342.trc: ORA-00600: internal error code, arguments: [12333], [111], [108], [44], [], [], [], [] Mon Jun 11 09:49:04 2001 LGWR: prodding the archiver The DB is 8.1.5 on Solaris 7. When I referered to metalink, it says there could be some problem with the network in OS level. I am not sure how to track the error or where to look for this in the OS. Could some one help me in finding the cause of this problem? Thanks Raj -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raj Gopalan 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: Van M. Etheridge 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-07445: exception encountered: core dump [kxsdmp()+188] [S
Oracle Product Document Library(C) Oracle Corporation Manual: ORACLE 8.1.5 SERVER CODES Reference: A67785-01 ORA-07445 exception encountered: core dump [string] [string] [string] [string] [string] [string] Cause: An operating system exception occurred which should result in the creation of a core file. This is an internal error. Action: Contact Oracle Customer Support. -Original Message- Sent: Monday, April 30, 2001 1:41 PM To: Multiple recipients of list ORACLE-L [SIGBU Hi, One of our databases has just started producing the following errors over the weekend... Errors in file /Volumes/app/oracle/admin/dmps_tst/udump/dmps_tst_ora_16040.trc: ORA-07445: exception encountered: core dump [kxsdmp()+188] [SIGBUS] [Invalid address alignment] [1679844977] [] [] ORA-07445: exception encountered: core dump [kxsdmp()+188] [SIGBUS] [Invalid address alignment] [1679844977] [] [] ORA-07445: exception encountered: core dump [kxsdmp()+188] [SIGBUS] [Invalid address alignment] [1679844977] [] [] ORA-00600: internal error code, arguments: [17182], [2205248016], [], [], [], [], [], [] Another DBA I work with opened a TAR (1535656.999) but I was wondering if anyone else has seen this also? The database is at version 8.1.6.2 on Solaris 2.6. Thanks, Ken _ Clinical and Regulatory Informatics - Groton/New London Coordinator, Business and Technical Services Tel: (860) 732-0026Fax: (860) 715-8346 Email: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Fowler, Kenneth R 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: Van M. Etheridge 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).
automatic startup and shutdown of LISTENER
I would like to be able tostartup and shutdown the listener when my SA shutsdown and brings the Unix box back up. What happens when my SA brings up the OS is that he gets the lsnrctl prompt rather than listener starting. He can then type the start command and listerner starts. But it should start without him having to key in the command. I have the following in both the /etc/init.d/dbstart and /etc/rc2.d/s99dbstart files: su - oracle -c $ORACLE_HOME/bin/ lsnrctl start (I use the default listener name "LISTENER") Sun SPARC Solaris OS 2.4 Oracle7 ServerRelease 7.3.4.0.1 - Production With thedistributed, parallel query and Spatial Data options PL/SQL Release 2.3.4.0.0 - Production -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Van M. Etheridge 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).