Re: Temporarily Renaming the sgadefSID.dbf File
Hi Steve I have actually done exactly what you are thinking of trying several times over i.e. renamed the sgadefSID.dbf file when trying to clone a database. Once the clone was created I just renamed it to its original name with no problems. Regards Natasha - Original Message - To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED] Sent: Tuesday, April 10, 2001 4:35 PM Hi All, Trying to clone our PROD to a test database on the same machine for testing our 734--8i upgrade, and of course we're encountering the "can't-start-the-new-without-shutting-down-the-old" database problem (ie, ORA-9782 on the CREATE CONTROLFILE command). We've worked around this in the past by scheduling a time to bring down PROD. I know that this is the safest, most reliable way (besides NOT doing this on a production box...but I have no choice), but believe it or not, I actually saw a reference on a Metalink forum to rename the sgadefSID.dbf file, start up the new database, then rename the file to its original name. Obviously sgadef gets created at instance startup as a memory map, but it doesn't look like it's used for anything after that (it's certainly doesn't seem to be written to). I do know that you can get an octal dump of the file to determine the shared memory ID for whatever reason. Everything else I've heard/seen about this file has pretty much said DON'T TOUCH IT!!! But if the instance only uses it at instance startup, is there any harm in renaming it temporarily to get the other database up? If so...why? And have any of you tried renaming or deleting the file in your cloning (or other) efforts? Did it blow up, or work? TIA, Steve _ Steve Morrow IT/Tech Support University of South Florida phone: 813-974-5519 [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Morrow, Steve 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: Natasha Batson 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:RE: Database / OS monitoring tool
How about Precise Diagnostic Center? I like the fact that it shows everything on one screen so you know immediately if and where you have a problem and its interface is out of this world! - Original Message - To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED] Sent: Tuesday, April 10, 2001 11:13 AM We use TeamQuest. They're very low impact do some nice current as well as historical charts. They also don't do anything "funny" like try to attach to the SGA. I believe they have flavors for all OS's (we use the HP-UX variant). You can set alerts as you like. Dick Goulet Reply Separator Author: "Mark Leith" [EMAIL PROTECTED] Date: 4/10/2001 3:10 AM Athene from Metron will also do both O/S, and database monitoring. www.metron.co.uk -Original Message- Kirti Sent: Tuesday, April 10, 2001 05:06 To: Multiple recipients of list ORACLE-L Check BMC Software's PATROL http://www.bmc.com We use it on UNIX / Compaq (Alpha) platforms and I know they have a version for MS Windows as well. HTH - Kirti Deshpande Verizon Information Services http://www.superpages.com -Original Message- From: Helmut Daiminger [SMTP:[EMAIL PROTECTED]] Sent: Monday, April 09, 2001 6:20 PM To: Multiple recipients of list ORACLE-L Subject: Database / OS monitoring tool Hi! What software is available that can be used for database and operating system (NT/2000) monitoring? It should be capable to email/page administrators in case a Windows service fails or Oracle crashes or the like. Is anybody out there using software like that? This is 8.1.6 on Win2k. Thanks, Helmut -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Helmut Daiminger 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: Deshpande, Kirti 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: Mark Leith 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: Natasha Batson 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: RMAN-06004 Error
Raj This might be related to bug# 1311017 where there is a limit of 99 backup pieces. How many backup pieces do you have? Have you placed an iTAR with OTS? Regards Natasha - Original Message - To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED] Sent: Monday, April 09, 2001 11:46 AM DBAs, I have taken DB backup using RMAN. The backup completed successfully. When I execute list backupset, I am getting the following error RMAN list backupset; RMAN-03022: compiling command: list RMAN-03026: error recovery releasing channel resources RMAN-00571: === RMAN-00569: === ERROR MESSAGE STACK FOLLOWS === RMAN-00571: === RMAN-03002: failure during compilation of command RMAN-03013: command type: list RMAN-06004: ORACLE error from recovery catalog database: ORA-06502: PL/SQL: nume ric or value error: number precision too large ORA-06512: at "RMAN.DBMS_RCVMAN", line 7052 ORA-06512: at "RMAN.DBMS_RCVMAN", line 4729 ORA-06512: at line 1 This is the first time I am using RMAN and I could not find anything to sort out this issue in metalink. Any Idea what could be the cause? 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: Natasha Batson 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-07446
I'll agree with Kevin on that one. Check if you have a parameter listed in the init.ora with no value assigned. Natasha - Original Message - To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED] Sent: Monday, April 09, 2001 12:54 PM Open up and double check your pfile, there may be an error in it. At least that's my feeling. Kevin -Original Message- Sent: Monday, April 09, 2001 11:55 AM To: Multiple recipients of list ORACLE-L Oracle 8.1.7 Trying to do a startup pfile=whatever nomount and get error ORA-07466 sdnfy : bad value ' ' for parameter Any ideas what is wrong? 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). -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Natasha Batson 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).
Strange command coming up when running sqlplus from Unix server...
A customer of mine, whenever he logs into sqlplus on his Unix server he gets the following: " oracle817 sqlplus inst emulated pid=28337 sqlplus va=0x14005b9b8 pc=0x1200fda40 inst=0x3be6 SQL*Plus: Release 8.1.7.0.0 - Production on Thu Feb 8 09:25:04 2001 (c) Copyright 2000 Oracle Corporation. All rights reserved. Enter user-name: BUT why does this line come up? inst emulated pid=28337 sqlplus va=0x14005b9b8 pc=0x1200fda40 inst=0x3be6 Is it because of a problem with the installation? This problem, however does not occur when I logging to SQL from a PC. " Hope someone can give me some feedback! Regards Natasha BEGIN:VCARD VERSION:2.1 N:Batson;Natasha FN:Natasha Batson EMAIL;PREF;INTERNET:[EMAIL PROTECTED] REV:20010208T133151Z END:VCARD
Re: Strange command coming up when running sqlplus from Unix server...
Don't worry guys! Found the following off of Metalink: Doc ID: Note:124568.1 Subject: Tru64 Unix Svrmgrl or Sqlplus Returns Inst Emulated Before the Standard Banner Type: PROBLEM Status: PUBLISHED Problem Description --- Invocation of 8.1.7.0.0 SVRMGRL or SQLPLUS under Compaq Tru64 Unix returns the following error: # svrmgrl inst emulated pid=7831 svrmgrl va=0x11fffde88 pc=0x12054ca98 inst=0x327e0028 Oracle Server Manager Release 3.1.7.0.0 - Production Copyright (c) 1997, 1999, Oracle Corporation. All Rights Reserved. Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production With the Partitioning option JServer Release 8.1.7.0.0 - Production SVRMGR Solution Description The above error message is issued on ALPHA chip prior EV56. To verify your Alpha chip generation with : # ./usr/sbin/psrinfo -v The output look similar to: Status of processor 0 as of: 11/15/00 10:02:24 Processor has been on-line since 08/14/2000 11:14:10 The alpha EV5 (21164) processor operates at 250 MHz, and has an alpha internal floating point processor. or Status of processor 0 as of: 11/15/00 08:59:01 Processor has been on-line since11/15/2000 06:54:32 The alpha EV5 (21164) processor operates at 267MHz, and has an alpha internal floating point processor. Explanation --- Beginning with Oracle8i Release 3, (8.1.7) and associated Oracle8i Release 3-based products will be supported on Compaq Tru64 UNIX AlphaServers with EV56 or greater generation CPUs only. Therefore, Oracle Error Correction formally announces the end of Error Correction Support for Oracle products on Compaq Tru64 UNIX AlphaServers containing pre-EV56 generation Alpha CPUs. References -- Note:87.1 Note:118593.1 Additional Search Words --- Compaq Tru64 UNIX AlphaServers AlphaStation (formerly Digital Unix 8.1.7 8.1.7.0.0) xterm, term . Copyright (c) 1995,2000 Oracle Corporation. All Rights Reserved. Legal Notices and Terms of Use. - Original Message - To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED] Sent: Thursday, February 08, 2001 9:31 AM A customer of mine, whenever he logs into sqlplus on his Unix server he gets the following: " oracle817 sqlplus inst emulated pid=28337 sqlplus va=0x14005b9b8 pc=0x1200fda40 inst=0x3be6 SQL*Plus: Release 8.1.7.0.0 - Production on Thu Feb 8 09:25:04 2001 (c) Copyright 2000 Oracle Corporation. All rights reserved. Enter user-name: BUT why does this line come up? inst emulated pid=28337 sqlplus va=0x14005b9b8 pc=0x1200fda40 inst=0x3be6 Is it because of a problem with the installation? This problem, however does not occur when I logging to SQL from a PC. " Hope someone can give me some feedback! Regards Natasha -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Natasha Batson 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).