FW: Oracle Instances not starting up via services
Hi, I send this mail on friday, but it seems me not arrived to the list. Michal -Original Message- Sent: Friday, July 18, 2003 11:32 AM To: '[EMAIL PROTECTED]' Hi, my experience: 1. It is not possible to start instance through Terminal Services - svrmgrl produces ORA-12560 error. Terminal Services are not true terminal. I use Netmeeting - sharing desktop feature. 2. To start instance automaticaly after reboot I add local user NT Autority\system to the ORA_DBA user group 3. On Metalink is another recommendation - in SQLNET.ORA change QLNET.AUTHENTICATION_SERVICES= none - but than you have to type password when connecting as SYS. Michal -Original Message- Sent: Friday, July 18, 2003 2:59 AM To: Multiple recipients of list ORACLE-L So, how are you starting up instances via Terminal Services? I haven't tried to make that work yet. Though I do get highly annoyed with myself when I forget I'm in termserver and not pcanywhere, and can't start a database. Jared "Niall Litchfield" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 07/17/2003 04:14 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:RE: Oracle Instances not starting up via services I didn't see the original message, but I'll get cannot open '%oracle_home%/database/init%oracle_sid%.ora" everytime if using terminal services to start the instance. Is this via a ts session or actually at the console? Er, Obviously I never forget to type pfile=. Though. Me, I'm professional Niall > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf > Of Nuala Cullen > Sent: 17 July 2003 12:24 > To: Multiple recipients of list ORACLE-L > Subject: RE: Oracle Instances not starting up via services > > > Hi Jose, > > I've tried twice to send you the information but the mailing list has > decided that it contains a 'virus signature' and rejects the email. > > So can you let me know specially what you are looking for and I will > send you those values. > > Thanks, > N. > > :->-Original Message- > :->From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > :->Behalf Of :->Jose Luis Delgado > :->Sent: 16 July 2003 16:49 > :->To: Multiple recipients of list ORACLE-L > :->Subject: RE: Oracle Instances not starting up via services > :-> :-> :->Nuala... :-> > :->1.- can you send your environment variables? (my_pc -> > :->properties -> advanced -> environment variables) :-> > :->2.- can you send your Oracle registry values? > :-> > :->JL > :-> > :->--- Nuala Cullen <[EMAIL PROTECTED]> wrote: > :->> > :->> Hi Jared, > :->> > :->> Thanks for the advice, > :->> > :->> I checked out the registry settings > :->> ORA_WMS_PFILE is set to > :->> c:\oracle\ora81\database\initwms.ora. > :->> ORA_WMS_AUTOSTART is set to TRUE. > :->> > :->> I'm a bit confused what you mean by using variables. > :->> I think you mean not to use %oracle_home% etc but > :->> the error message: > :->> > :->> "LRM-00109 can not open parameter file > :->> '%oracle_home%/database/init%oracle_sid%.ora" > :->> is as it appeared on the screen. > :->> > :->> N. > :->> > :->> > :->> :->-Original Message- > :->> :->From: Jared Still [mailto:[EMAIL PROTECTED] > :->> :->Sent: 16 July 2003 14:31 > :->> :->To: [EMAIL PROTECTED]; Nuala Cullen > :->> :->Subject: Re: Oracle Instances not starting up via > :->> services > :->> :-> > :->> :-> > :->> :-> > :->> :->Check the registry entry ORA__PFILE. Try > :->> hardcoding > :->> :->the entire path rather than use variables. > :->> :-> > :->> :->ie. ORA_WMS_PFILE would be set to > :->> :->c:\oracle\ora81\database\initwms.ora. > :->> :-> > :->> :->Be sure ORA_WMS_AUTOSTART is set to TRUE. > :->> :-> > :->> :->Jared > :->> :-> > :->> :-> > :->> :->On Wednesday 16 July 2003 04:24, Nuala Cullen > :->> wrote: > :->> :->> Hi All, > :->> :->> > :->> :->> I have inherited a couple of databases on one > :->> of the > :->> :->servers here. The > :->> :->> server was taken down for hardware repairs > :->> during the week > :->> :->and when it came > :->> :->> back up the databases did not start. (They are > :->> set to > :->> :->start automatically > :->> :->> via the services) > :->> :->> > :->> :->> I have done some research via the internet and > :->> I deleted > :->> :->and recreated the > :->> :->> service via the ORADIM utility. > :->> :->> > :->> :->> But this has n't fixed it. I have to manually > :->> go into and start the > :->> :->> databases (explicitly stating where the > :->> init.ora file is) > :->> :->> > :->> :->> I am getting this error message when I go in > :->> via SQLPLUS > :->> :->/NOLOG (connected > :->> :->> as internal) > :->> :->> > :->> :->> Startup > :->> :->> error message LRM-00109 can not open parameter > :->> file > :->> :->> '%oracle_home%/database/init%oracle_sid%.ora > :->> :->> > :->> :->> If I do a startup > :->> :->pfile=c:\oracle\ora81\database\initwms
Re: Re: DB shift
Yes We will bedoing it thru exp/imp as downtime is there thanks On Mon, 21 Jul 2003 zhu chao wrote : >Hi, > I suggest you upgrade your old server from 8170 to 8174 and >then copy >the datafiles there. > Or if downtime is limited, you can use standby database to >switch your >database from old to new hardware. > >Regards >zhu chao >msn:[EMAIL PROTECTED] >www.cnoug.org >- Original Message - >To: "Multiple recipients of list ORACLE-L" ><[EMAIL PROTECTED]> >Sent: Monday, July 21, 2003 12:49 AM > > > > Hi All > > > > We are planning to Shift our Db to a new hardware(having >RAIDs). > > The OS is exactly same on both the servers. > > Presently Oracle Version is 8.1.7.0.0 > > In the new server Oracle 8.1.7.4 is installed. > > > > What I am planning is to Shift the DB by copying the data >files > > from old to new server. > > Renaming them in mount stage if required. > > > > For the Oracle version change (upgrade) will there be any > > problem? > > So that export/import will be the only option. > > > > Thanks for your valuable input. > > > > Regards > > > > > > ___ > > Download the hottest & happening ringtones here! > > OR SMS: Top tone to 7333 > > Click here now: > > http://sms.rediff.com/cgi-bin/ringtone/ringhome.pl > > > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.net > > -- > > Author: bhabani s pradhan > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- 858-538-5051 >http://www.fatcity.com > > San Diego, California-- Mailing list and web hosting >services > > >- > > To REMOVE yourself from this mailing list, send an E-Mail >message > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') >and in > > the message BODY, include a line containing: UNSUB ORACLE-L > > (or the name of mailing list you want to be removed from). >You may > > also send the HELP command for other information (like >subscribing). > > > > > >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.net >-- >Author: zhu chao > INET: [EMAIL PROTECTED] > >Fat City Network Services-- 858-538-5051 >http://www.fatcity.com >San Diego, California-- Mailing list and web hosting >services >- >To REMOVE yourself from this mailing list, send an E-Mail >message >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and >in >the message BODY, include a line containing: UNSUB ORACLE-L >(or the name of mailing list you want to be removed from). You >may >also send the HELP command for other information (like >subscribing). ___ Download the hottest & happening ringtones here! OR SMS: Top tone to 7333 Click here now: http://sms.rediff.com/cgi-bin/ringtone/ringhome.pl -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: bhabani s pradhan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: DB shift
thanks a lot On Sun, 20 Jul 2003 Tanel Poder wrote : >Hi! > >When moving to binary compatible platform, you can directly copy >over the >files (and software). > >It's even possible with different versions of OS - like from >SunOS 2.6 to >Solaris 8. > >For upgrading to 8.1.7.4 follow the patchset readme notes. > >Tanel. > >- Original Message - >To: "Multiple recipients of list ORACLE-L" ><[EMAIL PROTECTED]> >Sent: Sunday, July 20, 2003 7:49 PM > > > > Hi All > > > > We are planning to Shift our Db to a new hardware(having >RAIDs). > > The OS is exactly same on both the servers. > > Presently Oracle Version is 8.1.7.0.0 > > In the new server Oracle 8.1.7.4 is installed. > > > > What I am planning is to Shift the DB by copying the data >files > > from old to new server. > > Renaming them in mount stage if required. > > > > For the Oracle version change (upgrade) will there be any > > problem? > > So that export/import will be the only option. > > > > Thanks for your valuable input. > > > > Regards > > > > > > ___ > > Download the hottest & happening ringtones here! > > OR SMS: Top tone to 7333 > > Click here now: > > http://sms.rediff.com/cgi-bin/ringtone/ringhome.pl > > > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.net > > -- > > Author: bhabani s pradhan > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- 858-538-5051 >http://www.fatcity.com > > San Diego, California-- Mailing list and web hosting >services > > >- > > To REMOVE yourself from this mailing list, send an E-Mail >message > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') >and in > > the message BODY, include a line containing: UNSUB ORACLE-L > > (or the name of mailing list you want to be removed from). >You may > > also send the HELP command for other information (like >subscribing). > > > > >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.net >-- >Author: Tanel Poder > INET: [EMAIL PROTECTED] > >Fat City Network Services-- 858-538-5051 >http://www.fatcity.com >San Diego, California-- Mailing list and web hosting >services >- >To REMOVE yourself from this mailing list, send an E-Mail >message >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and >in >the message BODY, include a line containing: UNSUB ORACLE-L >(or the name of mailing list you want to be removed from). You >may >also send the HELP command for other information (like >subscribing). ___ Download the hottest & happening ringtones here! OR SMS: Top tone to 7333 Click here now: http://sms.rediff.com/cgi-bin/ringtone/ringhome.pl -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: bhabani s pradhan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Different Platform
FORTE compiler On Mon, 21 Jul 2003 Richard Ji wrote : >So which compiler will you standarize on? GCC? >On Solaris I believe the Sun C Compiler is supported but not gcc, >though >you can make it work. > >-Original Message- >Sent: Sunday, July 20, 2003 12:50 PM >To: Multiple recipients of list ORACLE-L > > >Hi All > >Our production environment is on Sun OS 5.8 sparc. >DB is > >Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production >PL/SQL Release 8.1.7.0.0 - Production >CORE 8.1.7.0.0 Production >TNS for Solaris: Version 8.1.7.0.0 - Production >NLSRTL Version 3.4.1.0.0 - Production > >The application has a lot of Pro*C programs. >-- > >We are planning to have the development/test DB on Linux 2.4 on >Intel platform. > >We will be doing modifications/upgrades to the application and >DB >and will be applying the changes to production. > > >Will there be ANY kind of compatibility problem (relating to >OCI, >or plsql procs etc) ? > >Thanks in Advance >Regards > >___ >Download the hottest & happening ringtones here! >OR SMS: Top tone to 7333 >Click here now: >http://sms.rediff.com/cgi-bin/ringtone/ringhome.pl > > >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.net >-- >Author: bhabani s pradhan > INET: [EMAIL PROTECTED] > >Fat City Network Services-- 858-538-5051 >http://www.fatcity.com >San Diego, California-- Mailing list and web hosting >services >- >To REMOVE yourself from this mailing list, send an E-Mail >message >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and >in >the message BODY, include a line containing: UNSUB ORACLE-L >(or the name of mailing list you want to be removed from). You >may >also send the HELP command for other information (like >subscribing). >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.net >-- >Author: Richard Ji > INET: [EMAIL PROTECTED] > >Fat City Network Services-- 858-538-5051 >http://www.fatcity.com >San Diego, California-- Mailing list and web hosting >services >- >To REMOVE yourself from this mailing list, send an E-Mail >message >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and >in >the message BODY, include a line containing: UNSUB ORACLE-L >(or the name of mailing list you want to be removed from). You >may >also send the HELP command for other information (like >subscribing). ___ Download the hottest & happening ringtones here! OR SMS: Top tone to 7333 Click here now: http://sms.rediff.com/cgi-bin/ringtone/ringhome.pl -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: bhabani s pradhan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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-29540: class oracle/plsql/net/TCPConnection does not exist
I have faced the same problem earlier. I had first deinsatalled the JVM and then tried to intalled. It had given succesfull installation status. But actully not installed. I have checked the metalink and finally come to conclusion that re-installation of JVM not work and only solution is reinstall the ORACLE. Check this with metalink. Manoj Kumar Jha - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Sunday, July 20, 2003 10:19 PM > Helo all, > > I have installed oracle JVM on oracle817, windows2000. > > Asper the doc from metalink, i installed it > sucessfully. When i'm using the utl_smtp package from > the client forms6i, the error "ORA-29540: class > oracle/plsql/net/TCPConnection does not exist" raised > out. > > How to proceed next?. > > > installation steps: > 1) resource configuration, rollback segment, shared > pool, java pool, system tablespace has been done. > > 2) connect internal, run script initjvm.sql > > i verified post installation steps, my results matched > with the document note from metalink "installing jvm > on oracle817". > > Thanks. > Nirmal, > > = > fsdfsdfsdfsdfs > > __ > Do you Yahoo!? > SBC Yahoo! DSL - Now only $29.95 per month! > http://sbc.yahoo.com > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Nirmal Kumar M > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Manoj Kumar Jha INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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-29540: class oracle/plsql/net/TCPConnection does not exist
Hi Nirmal, I believe there is a bug in the installer and the following two steps are missing cd $ORACLE_HOME/plsql/jlib loadjava -user sys/ plsql.jar Do them yourself manually and you should be fine. Hope this helps Garry Gillies Database Administrator Business Systems Weir Pumps Ltd 149 Newlands Road, Cathcart, Glasgow, G44 4EX T: +44 0141 308 3982 F: +44 0141 633 1147 E: [EMAIL PROTECTED] Nirmal Kumar M <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 20/07/03 17:49 Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:ORA-29540: class oracle/plsql/net/TCPConnection does not exist Helo all, I have installed oracle JVM on oracle817, windows2000. Asper the doc from metalink, i installed it sucessfully. When i'm using the utl_smtp package from the client forms6i, the error "ORA-29540: class oracle/plsql/net/TCPConnection does not exist" raised out. How to proceed next?. installation steps: 1) resource configuration, rollback segment, shared pool, java pool, system tablespace has been done. 2) connect internal, run script initjvm.sql i verified post installation steps, my results matched with the document note from metalink "installing jvm on oracle817". Thanks. Nirmal, = fsdfsdfsdfsdfs __ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nirmal Kumar M INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). CONFIDENTIAL: The information contained in this email (including any attachments) is confidential, subject to copyright and for the use of the intended recipient only. If you are not the intended recipient please delete this message after notifying the sender. Unauthorised retention, alteration or distribution of this email is forbidden and may be actionable. Attachments are opened at your own risk and you are advised to scan incoming email for viruses before opening any attached files. We give no guarantee that any communication is virus-free and accept no responsibility for virus contamination or other system loss or damage of any kind. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Garry Gillies INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: ODBC Patch 8.1.5.7 where to download
Title: ODBC Patch 8.1.5.7 where to download technet.oracle.com. Follow the download links. Ciao Fuzzy :-) -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of [EMAIL PROTECTED]Sent: Friday, July 18, 2003 15:49To: Multiple recipients of list ORACLE-LSubject: ODBC Patch 8.1.5.7 where to download Hi list, I need Oracle Patch 8.1.5.7 for ODBC Driver. I haven't found it on metalink. Could someone please send me a mail with this patch or direct me to a download location? TIA regards Volker Schoen E-Mail: [EMAIL PROTECTED] http://www.inplan.de
AW: Re: Object Types in PL/SQL
Hi Sorry for the late reply ... weekend ;). If I understand you correctly, you do the following: Use "normal" tables (a normalized data model ?), then create an additional Object Type for each table with methods to do DML on that table. From Java, only use stored procs/funcs to manipulate the data. The procs/funcs use the Object Types in return. Java only "knows" these Object Types, not the tables. Advantage: JDBC doesn't have to query for that much metadata, since Java Objects map quite well to Object Types. Is that correct so far ? Stefan -Ursprüngliche Nachricht- Von: Nuno Souto [mailto:[EMAIL PROTECTED] Gesendet: Donnerstag, 17. Juli 2003 14:05 An: Multiple recipients of list ORACLE-L Betreff: Re: Re: Object Types in PL/SQL - Original Message - > how does the object features improve performance of the jdbc? its fairly common now to have a java or .net(which we are using) and an Oracle backend. > When we started to use JDBC, one of the things I noticed was some very unusual network traffic. Certainly more than I was expecting given the level of statements being executed. A few traces showed a lot of traffic by JDBC driver itself trying to find information about the parameters involved in a ExecutableStatement. I believe this is specific to JDBC 2 and its new MetaData functionality, but I don't know for sure. A little bit of experimentation showed that if we created an object type definition for each table involved in our procedures and used the object type to pass the parameters (each parameter is a column) to the stored procedures, the network traffic dropped dramatically. Now we use a package for each table with an object type matching the table columns used as the single parameter to each function/procedure. Each package has as a minimum a MNG_ and a DEL_ procedure, with the first one handling both INSERT and UPDATE (depending if PK is set to NULL or not). We also write "getters" to access the data, returning a REF CURSOR typed on the same object type. This is not only blinding fast but the network traffic is negligeable. > your comments would be much appreciated. Not really comments, just the experience so far. It might change in the next version. So far it seems to work like a charm, so we're sticking with it. The next step is to get a few of the hierarchical accesses done via O-R views returning a single object with an array for the child object types. First trials seem very promising, but I have to wait for the 9i upgrade: 8i lets me do only one level of hierarchical object. After that, it's XML all the way through! If the customer doesn't kick us all out b4... ;) Cheers Nuno Souto [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nuno Souto INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stefan Jahnke INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Who Says Oracle does not listen
Title: RE: Who Says Oracle does not listen
That’s not good enough.
I don’t want to discard ANY
exception.
When dropping table, I don’t want to
see error messages only if there is nothing to drop. While if let’s
say there is a problem with privileges, it will go unnoticed.
Or, when adding a table, it’s fine
not be getting an error, if table already exists. But, if there is no
room to create a table, or to add a partition to the table, I want to see this
error message.
So, I still prefer my way of doing it (see
scripts in my original message) comparing to Oracle’s script, you refer
to.
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED]
Sent: Friday, July 18, 2003 6:10
PM
To: Multiple recipients of list
ORACLE-L
Subject: RE: Who Says Oracle does
not listen
From ORACLE own script:
Rem
Rem Drop tables without raising
errors if they do not exist
Rem
declare
PROCEDURE
drop_force(tab varchar2) IS
BEGIN
EXECUTE IMMEDIATE 'DROP TABLE ' || tab;
EXCEPTION WHEN OTHERS
THEN
NULL;
END;
begin
drop_force('utl_recomp_invalid');
drop_force('utl_recomp_sorted');
drop_force('utl_recomp_compiled');
drop_force('utl_recomp_backup_jobs');
drop_force('utl_recomp_log');
end;
/
Alex.
-Original Message-
From: Igor Neyman [mailto:[EMAIL PROTECTED]]
Sent: Friday, July 18, 2003 2:04 PM
To: Multiple recipients of list
ORACLE-L
Subject: RE: Who Says Oracle does
not listen
Sure, I would.
But I can't wait till Oracle
"turns around".
My scripts are executed by our
"field" engineers, who know next to nothing about Oracle, and the
only thing they can do is to check log files for error messages (and even this
is done automatically).
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
-Original Message-
Goulet, Dick
Sent: Friday, July 18, 2003 3:44 PM
To: Multiple recipients of list
ORACLE-L
Igor,
True enough, but wouldn't you like it as
part and parcel of the command?
Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
-Original Message-
Sent: Friday, July 18, 2003 4:35 PM
To: Multiple recipients of list
ORACLE-L
To avoid those errors in my scripts I'm checking data
dictionary for the "existence" of the object (fortunately, dynamic
sql helps here):
REM Dropping synonym
DECLARE lCounter integer;
begin
SELECT COUNT(*) INTO lSyn
FROM dba_synonyms WHERE synonym_name = 'PRCPV_REPORT_INFO' AND OWNER =
'PUBLIC'; IF (lSyn = 1) THEN
EXECUTE IMMEDIATE 'drop PUBLIC SYNONYM PRCPV_Report_Info'; END
IF; end; /
or:
REM Adding column
DECLARE lCounter integer;
begin
SELECT count(*) INTO lCounter
FROM DBA_TAB_COLUMNS
WHERE table_name = 'PRCP_MENU'
AND column_name = 'MENU_NAME'
AND owner = 'IPN_DBA';
IF (lCounter = 0) THEN
EXECUTE IMMEDIATE 'ALTER TABLE prcp_menu ADD menu_name
VARCHAR2(50) NULL';
END IF;
end;
/
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
-Original Message-
Goulet, Dick
Sent: Friday, July 18, 2003 3:04 PM
To: Multiple recipients of list
ORACLE-L
Update TAR Go to End
TAR Number 3169102.996
Open Date 17-JUL-03 19:18:03
Support Identifier
1208611 Name Richard Goul
Priority 4 Last Update
18-JUL-03 15:22:33
Product Oracle Server - Enterprise
Edition Product Version 9.2.0.1.0
Platform HP-UX PA-RISC
(64-bit) Detailed Status Soft Close
TAR Reference
n/a BUG Reference n/a
Abstract
DROP OBJECT NO_FAIL
Resolution History
17-JUL-03 19:18:03 GMT
### Selected Industry ###
Discrete Manufacturing
### Reason current product functionality is
insufficient. ### Today if you issue a "drop table ;"
command and the table does not exist you get an error back.
### Detailed description of the Enhancement Request.
###
It would be great if we had an
addition to the drop object command, something like "drop table
no_fail;" which would always return "Table
dropped" whether it existed or not.
### How
Re: RAID select
Assuming that you have 3 physical devices (NON-RAID, RAID-1, and RAID-0+1) my quick-and-dirty take on this is: NON-RAID redo logs - mirrored by Oracle control logs - mirrored by Oracle ORACLE_HOME RBS01 RBS02 TEMP STAT(For PERFSTAT) RAID-1 SYSTEM RWEBCONFIG(Less Accessed) RTRADE(Less Accessed) Archive destination - move to tape Backups - copy to tape RAID-0+1 USERS01(Heavily Accessd) INDEX01(Heavily Accessd) INDEX02(Heavily Accessd) I wouldn't worry about putting the indexes on the same device with the tables. It is a multi-platter device and each datafile will be stripped across multiple platters. You may want to look into the stripe size depending on the number of users who will be concurrently accessing the database. Basic rule-of-thumb, the more concurrent users the larger the stripe size. "bhabani s pradhan" To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Subject: RAID select Sent by: ml-errors 07/20/2003 12:49 PM Please respond to ORACLE-L Hi I have a DB server with RAID-1 and RAID-0+1 (There is no RAID-0). Also the NON-RAID diska are available. I have the tablespaces as: SYSTEM USERS01(Heavily Accessd) RWEBCONFIG(Less Accessed) RTRADE(Less Accessed) INDEX01(Heavily Accessd) INDEX02(Heavily Accessd) RBS01 RBS02 TEMP STAT(For PERFSTAT) What could be a suitable configuration for the datafiles under these tablespaces across the available RAIDs. Also where the backups and archive_dest should be. Can anybody give me some tips on this Thanks and Regards ___ Download the hottest & happening ringtones here! OR SMS: Top tone to 7333 Click here now: http://sms.rediff.com/cgi-bin/ringtone/ringhome.pl -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: bhabani s pradhan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Thomas Day INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Different Platform
NO, but don't transfer obj files from teh linus to sun boxex. Only move *.pc or *.c files & recompile. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Sunday, July 20, 2003 12:50 PM To: Multiple recipients of list ORACLE-L Hi All Our production environment is on Sun OS 5.8 sparc. DB is Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production PL/SQL Release 8.1.7.0.0 - Production CORE 8.1.7.0.0 Production TNS for Solaris: Version 8.1.7.0.0 - Production NLSRTL Version 3.4.1.0.0 - Production The application has a lot of Pro*C programs. -- We are planning to have the development/test DB on Linux 2.4 on Intel platform. We will be doing modifications/upgrades to the application and DB and will be applying the changes to production. Will there be ANY kind of compatibility problem (relating to OCI, or plsql procs etc) ? Thanks in Advance Regards ___ Download the hottest & happening ringtones here! OR SMS: Top tone to 7333 Click here now: http://sms.rediff.com/cgi-bin/ringtone/ringhome.pl -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: bhabani s pradhan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Goulet, Dick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: ORA-29540: class oracle/plsql/net/TCPConnection does not exist
Run initplsj.sql from $ORACLE_HOME/rdbms/admin. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Sunday, July 20, 2003 12:49 PM To: Multiple recipients of list ORACLE-L Helo all, I have installed oracle JVM on oracle817, windows2000. Asper the doc from metalink, i installed it sucessfully. When i'm using the utl_smtp package from the client forms6i, the error "ORA-29540: class oracle/plsql/net/TCPConnection does not exist" raised out. How to proceed next?. installation steps: 1) resource configuration, rollback segment, shared pool, java pool, system tablespace has been done. 2) connect internal, run script initjvm.sql i verified post installation steps, my results matched with the document note from metalink "installing jvm on oracle817". Thanks. Nirmal, = fsdfsdfsdfsdfs __ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nirmal Kumar M INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Goulet, Dick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Recent reports on outages caused by DB2 and 9iRAC issues
WOW! Those are some good stories to keep in mind... And some folks wonder why techies like working with computers more than working with people. ;-) Trying to be wise as a serpent and harmless as a dove... -Original Message- Sent: Friday, July 18, 2003 1:49 PM To: Multiple recipients of list ORACLE-L my 2¢ is it all depends on who you are. A few good ones I'm aware of. Confessors within the last 9 months, I know of one company where a DBA (unknown to mgt.) inadvertently dropped something and was able to fix it within a few minutes. I'm not sure if anyone other than operations noticed. Mgt. response: his mistake would be recognized on his yearly bonus. A couple months later at the same company, a well known DBA (one of the boys) brought down the web database for a couple of hours. Nothing was said. Mgt. response "We all make mistakes. Be more careful". Cowards A few years earlier at the same company, I remember a DBA who was doing maintenance and messed up. He never confessed to creating the problem, but did take credit for fixing it. Mgt. response: he was awarded a certificate for "Going the Extra Mile"... :) Steve - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Friday, July 18, 2003 1:34 PM > I've only made one mistake in my life and that was the time when I > thought I was wrong. ;-) > > OK, getting serious... I've found it's best to QUICKLY be 100% > truthful. If you get crucified for it then it may be that damagement > needs to lighten up. Unfortunately the fear of damagement causes wheel > spinning work-arounds to compromises of the facts. ;-) > > I once inadvertently brought a 24X7 production system down by shutting > down a test database that was "managed" by Veritas Cluster Server > junk. A hands on type director had added it to the cluster without > telling me so when I shut down the test database the cluster stuff > tried to fail over and everything came crashing down. I got the blame > so it was a real "cluster-f***" because the damager wouldn't accept > any responsibility for this episode. Later he decided to change some > Unix stuff all on his own and the result was that the system was down > quite some time. He as rather cavalier about the outage and danced > around the truth. Ultimately his prevarications caught up with him and > he was "dismissed" on the spot. "Justice" was served. > > > > -Original Message- > Sent: Friday, July 18, 2003 11:59 AM > To: Multiple recipients of list ORACLE-L > Importance: High > > > I always admit when I make a mistake. Gives me much more credibility > when I say "this time it ISN'T me" > > > --- "Goulet, Dick" <[EMAIL PROTECTED]> wrote: > > I prefer my bosses attitude on the subject of mistakes: > > > > Admit that you did it & then go fix it. We'll crucify you > later, if > > we have the time. > > > > For some reason, known only to the Devil himself, they never find > > the time. > > > > Dick Goulet > > Senior Oracle DBA > > Oracle Certified 8i DBA > > > > -Original Message- > > Sent: Friday, July 18, 2003 1:14 PM > > To: Multiple recipients of list ORACLE-L > > > > > > This reminds of watching the Indy 500 a couple of years ago. > > > > One of the drivers managed to spin in turn 4 of the first lap of the > > race, and subsequently was unable to finish the race. > > > > Before continuing, you need to know that when in a corner, one thing > > you should *never* do is take your foot off of the gas pedal. > > > > The resulting weight transfer will greatly reduce the amount of > > weight on the rear tires, and could easily cause you to spin. > > > > Back to the story: The driver was interviewed shortly afterward in > > the pits, and put the blame squarely on the car. "It was something > > with the car". > > > > Technology in the form of an onboard camera told another story. He > > let off the gas twice in turn 4. The first time the rear of the car > > squirmed a bit and he recovered. The second time it sounded like he > > completely released the accelerator, and the spin came shortly > > afterwards. > > > > He could have been a smart guy too, if he had remembered the camera. > > > > Too bad there wasn't a camera on the smart guys at Orbitz, maybe it > > would tell a different story. ;) > > > > None of us are immune to making mistakes, and about the time you > > start feeling invincible, watch out. > > > > Jared > > > > > > > > > > > > > > "Goulet, Dick" <[EMAIL PROTECTED]> > > Sent by: [EMAIL PROTECTED] > > 07/18/2003 09:44 AM > > Please respond to ORACLE-L > > > > > > To: Multiple recipients of list ORACLE-L > > <[EMAIL PROTECTED]> > > cc: > > Subject:RE: Recent reports on outages caused by DB2 > > and 9iRAC issues > > > > > > Interesting quote in eWeek. We may all be "smart guys", but how > > often > > > do we like to admit to causing a problem. > > > > Dick Goulet > > Senior Oracle DBA > > Oracle
RE: faq broke? -- Other options
Hey Bruce, Any possibility of making the bodies of the FatCity archived messages searchable, instead of just the subject? That's the only reason why I even bother with the orafaq search. Thanks, Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA > -Original Message- > From: Bruce A. Bergman [mailto:[EMAIL PROTECTED] > Sent: Saturday, July 19, 2003 2:49 PM > To: Multiple recipients of list ORACLE-L > Subject: Re: faq broke? -- Other options > > > Don't think that the only searchable archives are on orafaq. > Fat City has the definitive archives that date back to the > start of the list here. You should consider using the > archives here as well. > > You can find them here: http://www.listguru.com > > thanks, > bruce -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 shift
No, See the 8.1.7.4 patch set documentation and do it with a COLD database on the source side. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Sunday, July 20, 2003 12:50 PM To: Multiple recipients of list ORACLE-L Hi All We are planning to Shift our Db to a new hardware(having RAIDs). The OS is exactly same on both the servers. Presently Oracle Version is 8.1.7.0.0 In the new server Oracle 8.1.7.4 is installed. What I am planning is to Shift the DB by copying the data files from old to new server. Renaming them in mount stage if required. For the Oracle version change (upgrade) will there be any problem? So that export/import will be the only option. Thanks for your valuable input. Regards ___ Download the hottest & happening ringtones here! OR SMS: Top tone to 7333 Click here now: http://sms.rediff.com/cgi-bin/ringtone/ringhome.pl -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: bhabani s pradhan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Goulet, Dick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: oracle10g
What on earth does the g stand for? RBG -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Adams, Matthew (GECP, MABG, 088130)Sent: Thursday, July 17, 2003 3:45 PMTo: Multiple recipients of list ORACLE-LSubject: oracle10g Gotta love oracle. It won't be 10i, it'll be Oracle10g what on earth are they thinking? http://www.oracle.com/oracleworld/paris/conference/
RE: x server
There is a free downloadable package called Cygwin which gives you an X terminal. I don't have the URL handy but you can google it. Use the NASA download site, it is the fastest. Download the default version. HTH, Ruth -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of AKSent: Thursday, July 17, 2003 12:49 PMTo: Multiple recipients of list ORACLE-LSubject: x server is there any free x server (unlimited ) software for windows 2000 ? -ak
How to use SYS.DBMS_OUTPUT.PUT_LINE in ProC?
Hi,
I have a problem with using oracle built in stored procedures in embadded C.
It is impossible to compile my program by ProC. It says:
sys.dbms_alert.remove( 'prolan_alert' );
..1
PLS-S-00201, identifier 'SYS.DBMS_ALERT' must be declared
sys.dbms_alert.remove( 'prolan_alert' );
..1
PLS-S-0, Statement ignored
Semantic error at line 118, column 5, file reg_alert.pc:
BEGIN
1
PCC-S-02346, PL/SQL found semantic errors
SYS.DBMS_OUTPUT.PUT_LINE('Value of payroll: ');
..1
PLS-S-00201, identifier 'SYS.DBMS_OUTPUT' must be declared
SYS.DBMS_OUTPUT.PUT_LINE('Value of payroll: ');
..1
PLS-S-0, Statement ignored
I can use these functions in sqlplus, but ProC produces this error message.
Should I declare packages I want to use? How can I do it?
Thanks a lot,
Gyuri
--
--
Lendvary Gyorgy Prolan Rt.
tel: +36 26 543-136 Szentendrei ut 1-3.
fax: +36 26 543-101 H-2011 Budakalasz
email: [EMAIL PROTECTED] Hungary
--
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: gyurika
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: oracle10g
Oracle Grid Computing ... Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message-From: Ruth Gramolini [mailto:[EMAIL PROTECTED]Sent: Monday, July 21, 2003 10:59 AMTo: Multiple recipients of list ORACLE-LSubject: RE: oracle10g What on earth does the g stand for? RBG -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Adams, Matthew (GECP, MABG, 088130)Sent: Thursday, July 17, 2003 3:45 PMTo: Multiple recipients of list ORACLE-LSubject: oracle10g Gotta love oracle. It won't be 10i, it'll be Oracle10g what on earth are they thinking? http://www.oracle.com/oracleworld/paris/conference/ *This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.*1
RE: oracle10g
Title: Message Grid Computing?? If you click on the link, it says, "Oracle's introduces its new flagship database with Dynamic Grid Computing - Oracle10G". -Original Message-From: Ruth Gramolini [mailto:[EMAIL PROTECTED] Sent: Monday, July 21, 2003 9:59 AMTo: Multiple recipients of list ORACLE-LSubject: RE: oracle10g What on earth does the g stand for? RBG -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Adams, Matthew (GECP, MABG, 088130)Sent: Thursday, July 17, 2003 3:45 PMTo: Multiple recipients of list ORACLE-LSubject: oracle10g Gotta love oracle. It won't be 10i, it'll be Oracle10g what on earth are they thinking? http://www.oracle.com/oracleworld/paris/conference/
Re: oracle10g
gobs of money joe Ruth Gramolini wrote: What on earth does the g stand for? RBG -Original Message- *From:* [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of* Adams, Matthew (GECP, MABG, 088130) *Sent:* Thursday, July 17, 2003 3:45 PM *To:* Multiple recipients of list ORACLE-L *Subject:* oracle10g Gotta love oracle. It won't be 10i, it'll be Oracle10g what on earth are they thinking? http://www.oracle.com/oracleworld/paris/conference/ -- Joseph S Testa Chief Technology Officer Data Management Consulting p: 614-791-9000 f: 614-791-9001 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joe Testa INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: oracle10g
10G isn't as smart as Teradata (1000G). - Ping -Original Message-From: Ruth Gramolini [mailto:[EMAIL PROTECTED]Sent: Monday, July 21, 2003 10:59 AMTo: Multiple recipients of list ORACLE-LSubject: RE: oracle10g What on earth does the g stand for? RBG -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Adams, Matthew (GECP, MABG, 088130)Sent: Thursday, July 17, 2003 3:45 PMTo: Multiple recipients of list ORACLE-LSubject: oracle10g Gotta love oracle. It won't be 10i, it'll be Oracle10g what on earth are they thinking? http://www.oracle.com/oracleworld/paris/conference/
RE: Active Directory question
I did not receive any replies to this posting. Does that mean that nobody has connected Oracle to Active Directory? Has anyone tried and given up on this? -Original Message- Sent: Wednesday, July 16, 2003 1:42 PM To: '[EMAIL PROTECTED]' We are trying to configure an Oracle LDAP connection to Microsoft Active Directory. This is so a client machine can get the connection information (an alternative to tnsnames.ora or Oracle Names) and connect to an Oracle9i database on Sun Solaris. Does anyone know how you create the container called Oracle Context Structure in Active Directory? My Active Directory administrator tells me this is not like a normal AD container. We've read the documents and are confused on this point. Thanks. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: oracle10g
Title: Message Grid as in Grid computing, sounds like RAC to me -Original Message-From: Ruth Gramolini [mailto:[EMAIL PROTECTED] Sent: 21 July 2003 15:59To: Multiple recipients of list ORACLE-LSubject: RE: oracle10g What on earth does the g stand for? RBG -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Adams, Matthew (GECP, MABG, 088130)Sent: Thursday, July 17, 2003 3:45 PMTo: Multiple recipients of list ORACLE-LSubject: oracle10g Gotta love oracle. It won't be 10i, it'll be Oracle10g what on earth are they thinking? http://www.oracle.com/oracleworld/paris/conference/
RE: How to use SYS.DBMS_OUTPUT.PUT_LINE in ProC?
First off you need SQLCHECK=SEMANTICS and the login that you pass must have execute
priviledges.
Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
-Original Message-
Sent: Monday, July 21, 2003 11:04 AM
To: Multiple recipients of list ORACLE-L
Hi,
I have a problem with using oracle built in stored procedures in embadded C.
It is impossible to compile my program by ProC. It says:
sys.dbms_alert.remove( 'prolan_alert' );
.1
PLS-S-00201, identifier 'SYS.DBMS_ALERT' must be declared
sys.dbms_alert.remove( 'prolan_alert' );
.1
PLS-S-0, Statement ignored
Semantic error at line 118, column 5, file reg_alert.pc:
BEGIN
...1
PCC-S-02346, PL/SQL found semantic errors
SYS.DBMS_OUTPUT.PUT_LINE('Value of payroll: ');
.1
PLS-S-00201, identifier 'SYS.DBMS_OUTPUT' must be declared
SYS.DBMS_OUTPUT.PUT_LINE('Value of payroll: ');
.1
PLS-S-0, Statement ignored
I can use these functions in sqlplus, but ProC produces this error message.
Should I declare packages I want to use? How can I do it?
Thanks a lot,
Gyuri
--
--
Lendvary Gyorgy Prolan Rt.
tel: +36 26 543-136 Szentendrei ut 1-3.
fax: +36 26 543-101 H-2011 Budakalasz
email: [EMAIL PROTECTED] Hungary
--
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: gyurika
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Goulet, Dick
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
RE: oracle10g
I thought it was "gridlock", not "grid"? You know, something like I-84 at 8:30 A.M.? Mladen Gogala Oracle DBA Phone:(203) 459-6855 Email:[EMAIL PROTECTED] -Original Message-From: Jamadagni, Rajendra [mailto:[EMAIL PROTECTED]Sent: Monday, July 21, 2003 11:14 AMTo: Multiple recipients of list ORACLE-LSubject: RE: oracle10g Oracle Grid Computing ... Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message-From: Ruth Gramolini [mailto:[EMAIL PROTECTED]Sent: Monday, July 21, 2003 10:59 AMTo: Multiple recipients of list ORACLE-LSubject: RE: oracle10g What on earth does the g stand for? RBG -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Adams, Matthew (GECP, MABG, 088130)Sent: Thursday, July 17, 2003 3:45 PMTo: Multiple recipients of list ORACLE-LSubject: oracle10g Gotta love oracle. It won't be 10i, it'll be Oracle10g what on earth are they thinking? http://www.oracle.com/oracleworld/paris/conference/
RE: oracle10g
grid computing Shiva -Original Message-From: Ruth Gramolini [mailto:[EMAIL PROTECTED]Sent: Monday, July 21, 2003 9:59 AMTo: Multiple recipients of list ORACLE-LSubject: RE: oracle10g What on earth does the g stand for? RBG -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Adams, Matthew (GECP, MABG, 088130)Sent: Thursday, July 17, 2003 3:45 PMTo: Multiple recipients of list ORACLE-LSubject: oracle10g Gotta love oracle. It won't be 10i, it'll be Oracle10g what on earth are they thinking? http://www.oracle.com/oracleworld/paris/conference/
Re: oracle10g
performance drops off after 10g? joe Dong, Ping - Raleigh, NC wrote: 10G isn't as smart as Teradata (1000G). - Ping -Original Message- *From:* Ruth Gramolini [mailto:[EMAIL PROTECTED] *Sent:* Monday, July 21, 2003 10:59 AM *To:* Multiple recipients of list ORACLE-L *Subject:* RE: oracle10g What on earth does the g stand for? RBG -Original Message- *From:* [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of* Adams, Matthew (GECP, MABG, 088130) *Sent:* Thursday, July 17, 2003 3:45 PM *To:* Multiple recipients of list ORACLE-L *Subject:* oracle10g Gotta love oracle. It won't be 10i, it'll be Oracle10g what on earth are they thinking? http://www.oracle.com/oracleworld/paris/conference/ -- Joseph S Testa Chief Technology Officer Data Management Consulting p: 614-791-9000 f: 614-791-9001 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joe Testa INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: oracle10g
Title: Message Yes and no it is more like distributed RAC if you attended Hotsos/2003 you heard about this in the RAC presentation ... Oracle will find a node that has less work and ship your work over there and bring the results back to you ... This is not exactly how it is (much more complicated) but IIRC it is close. Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message-From: Nigel Bishop [mailto:[EMAIL PROTECTED]Sent: Monday, July 21, 2003 11:15 AMTo: Multiple recipients of list ORACLE-LSubject: RE: oracle10g Grid as in Grid computing, sounds like RAC to me -Original Message-From: Ruth Gramolini [mailto:[EMAIL PROTECTED] Sent: 21 July 2003 15:59To: Multiple recipients of list ORACLE-LSubject: RE: oracle10g What on earth does the g stand for? RBG -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Adams, Matthew (GECP, MABG, 088130)Sent: Thursday, July 17, 2003 3:45 PMTo: Multiple recipients of list ORACLE-LSubject: oracle10g Gotta love oracle. It won't be 10i, it'll be Oracle10g what on earth are they thinking? http://www.oracle.com/oracleworld/paris/conference/ This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.*2
RE: oracle10g
Title: Message 10 to the googol power. Pop Quiz... How many goose eggs is that?! -Original Message-From: Adams, Matthew (GECP, MABG, 088130) [mailto:[EMAIL PROTECTED] Sent: Thursday, July 17, 2003 1:45 PMTo: Multiple recipients of list ORACLE-LSubject: oracle10g Gotta love oracle. It won't be 10i, it'll be Oracle10g what on earth are they thinking? http://www.oracle.com/oracleworld/paris/conference/
RE: Active Directory question
Title: RE: Active Directory question I have _thought_ about it and given up on that .. seriously, next year we will look at it again ... really . Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message- From: DENNIS WILLIAMS [mailto:[EMAIL PROTECTED]] Sent: Monday, July 21, 2003 11:25 AM To: Multiple recipients of list ORACLE-L Subject: RE: Active Directory question I did not receive any replies to this posting. Does that mean that nobody has connected Oracle to Active Directory? Has anyone tried and given up on this? -Original Message- Sent: Wednesday, July 16, 2003 1:42 PM To: '[EMAIL PROTECTED]' We are trying to configure an Oracle LDAP connection to Microsoft Active Directory. This is so a client machine can get the connection information (an alternative to tnsnames.ora or Oracle Names) and connect to an Oracle9i database on Sun Solaris. Does anyone know how you create the container called Oracle Context Structure in Active Directory? My Active Directory administrator tells me this is not like a normal AD container. We've read the documents and are confused on this point. Thanks. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). *This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.*1
RE: faq broke? -- Other options
Good point Rich. I am sure I saw a post recently from Cary Millsap which shows how you could flush the buffers out with an alter system command (9i only) - to save restarting the database when running performance trials I have searched for it everywhere to no avail So if anybody recalls what it was please let me know (I assume it is undocumented as I cannot find anything in the manual) Thnaks John -Original Message- Sent: 21 July 2003 15:45 To: Multiple recipients of list ORACLE-L Hey Bruce, Any possibility of making the bodies of the FatCity archived messages searchable, instead of just the subject? That's the only reason why I even bother with the orafaq search. Thanks, Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA > -Original Message- > From: Bruce A. Bergman [mailto:[EMAIL PROTECTED] > Sent: Saturday, July 19, 2003 2:49 PM > To: Multiple recipients of list ORACLE-L > Subject: Re: faq broke? -- Other options > > > Don't think that the only searchable archives are on orafaq. > Fat City has the definitive archives that date back to the > start of the list here. You should consider using the > archives here as well. > > You can find them here: http://www.listguru.com > > thanks, > bruce -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hallas, John, Tech Dev INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: oracle10g
Title: Message Sounds promising actually... I think this is mostly for high-end applications though, I don't know if the medium-sized shops will use the "g" in 10G. Patrice. -Original Message-From: Jamadagni, Rajendra [mailto:[EMAIL PROTECTED]Sent: Monday, July 21, 2003 12:39 PMTo: Multiple recipients of list ORACLE-LSubject: RE: oracle10g Yes and no it is more like distributed RAC if you attended Hotsos/2003 you heard about this in the RAC presentation ... Oracle will find a node that has less work and ship your work over there and bring the results back to you ... This is not exactly how it is (much more complicated) but IIRC it is close. Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message-From: Nigel Bishop [mailto:[EMAIL PROTECTED]Sent: Monday, July 21, 2003 11:15 AMTo: Multiple recipients of list ORACLE-LSubject: RE: oracle10g Grid as in Grid computing, sounds like RAC to me -Original Message-From: Ruth Gramolini [mailto:[EMAIL PROTECTED] Sent: 21 July 2003 15:59To: Multiple recipients of list ORACLE-LSubject: RE: oracle10g What on earth does the g stand for? RBG -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Adams, Matthew (GECP, MABG, 088130)Sent: Thursday, July 17, 2003 3:45 PMTo: Multiple recipients of list ORACLE-LSubject: oracle10g Gotta love oracle. It won't be 10i, it'll be Oracle10g what on earth are they thinking? http://www.oracle.com/oracleworld/paris/conference/
SHOW ERRORS not working
I have a developer that has ALTER ANY PROCEDURE rights. He changes a procedure, then compiles it and it says there are errors. But when he does a SHOW ERRORS in SQPlus, it shows nothing. If I do the same thing I can see the errors from the compiled procedure. I assume this is a permissions thing but have not been able to figure this one out. Anyone have any ideas on this? Thanks, Dave -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Farnsworth, Dave INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: oracle10g
Title: Message Does anyone know if there's an archive of this presentation (slides, song and dance routine, etc.) available on the net somewhere? Thanks, Matt --Matthew ZitoGridApp SystemsEmail: [EMAIL PROTECTED]Cell: 646-220-3551Phone: 212-358-8211 x 359http://www.gridapp.com -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jamadagni, RajendraSent: Monday, July 21, 2003 10:39 AMTo: Multiple recipients of list ORACLE-LSubject: RE: oracle10g Yes and no it is more like distributed RAC if you attended Hotsos/2003 you heard about this in the RAC presentation ... Oracle will find a node that has less work and ship your work over there and bring the results back to you ... This is not exactly how it is (much more complicated) but IIRC it is close. Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message-From: Nigel Bishop [mailto:[EMAIL PROTECTED]Sent: Monday, July 21, 2003 11:15 AMTo: Multiple recipients of list ORACLE-LSubject: RE: oracle10g Grid as in Grid computing, sounds like RAC to me -Original Message-From: Ruth Gramolini [mailto:[EMAIL PROTECTED] Sent: 21 July 2003 15:59To: Multiple recipients of list ORACLE-LSubject: RE: oracle10g What on earth does the g stand for? RBG -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Adams, Matthew (GECP, MABG, 088130)Sent: Thursday, July 17, 2003 3:45 PMTo: Multiple recipients of list ORACLE-LSubject: oracle10g Gotta love oracle. It won't be 10i, it'll be Oracle10g what on earth are they thinking? http://www.oracle.com/oracleworld/paris/conference/
Re: DB shift
You can copy 8170 files to a new server via hot backup, create a new control file, open resetlogs and then upgrade to 8174. Try it first on a test server. I've done this from 8.0.4 -> 8.1.7.4 with no problems. Jared On Monday 21 July 2003 07:44, Goulet, Dick wrote: > No, See the 8.1.7.4 patch set documentation and do it with a COLD database > on the source side. > > Dick Goulet > Senior Oracle DBA > Oracle Certified 8i DBA > > -Original Message- > Sent: Sunday, July 20, 2003 12:50 PM > To: Multiple recipients of list ORACLE-L > > > Hi All > > We are planning to Shift our Db to a new hardware(having RAIDs). > The OS is exactly same on both the servers. > Presently Oracle Version is 8.1.7.0.0 > In the new server Oracle 8.1.7.4 is installed. > > What I am planning is to Shift the DB by copying the data files > from old to new server. > Renaming them in mount stage if required. > > For the Oracle version change (upgrade) will there be any > problem? > So that export/import will be the only option. > > Thanks for your valuable input. > > Regards > > > ___ > Download the hottest & happening ringtones here! > OR SMS: Top tone to 7333 > Click here now: > http://sms.rediff.com/cgi-bin/ringtone/ringhome.pl -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: SHOW ERRORS not working
Have him try "SHOW ERRORS PROCEDURE " Mladen Gogala Oracle DBA Phone:(203) 459-6855 Email:[EMAIL PROTECTED] -Original Message- Sent: Monday, July 21, 2003 11:45 AM To: Multiple recipients of list ORACLE-L I have a developer that has ALTER ANY PROCEDURE rights. He changes a procedure, then compiles it and it says there are errors. But when he does a SHOW ERRORS in SQPlus, it shows nothing. If I do the same thing I can see the errors from the compiled procedure. I assume this is a permissions thing but have not been able to figure this one out. Anyone have any ideas on this? Thanks, Dave -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Farnsworth, Dave INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: SHOW ERRORS not working
Title: RE: SHOW ERRORS not working select grant on all_errors ?? Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message- From: Farnsworth, Dave [mailto:[EMAIL PROTECTED]] Sent: Monday, July 21, 2003 11:45 AM To: Multiple recipients of list ORACLE-L Subject: SHOW ERRORS not working I have a developer that has ALTER ANY PROCEDURE rights. He changes a procedure, then compiles it and it says there are errors. But when he does a SHOW ERRORS in SQPlus, it shows nothing. If I do the same thing I can see the errors from the compiled procedure. I assume this is a permissions thing but have not been able to figure this one out. Anyone have any ideas on this? Thanks, Dave -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Farnsworth, Dave INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). *This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.*1
RE: SHOW ERRORS not working
Not sure, what causes the problem. But, probably a workaround is to grant him rights to select from dba_errors. Igor Neyman, OCP DBA [EMAIL PROTECTED] -Original Message- Farnsworth, Dave Sent: Monday, July 21, 2003 10:45 AM To: Multiple recipients of list ORACLE-L I have a developer that has ALTER ANY PROCEDURE rights. He changes a procedure, then compiles it and it says there are errors. But when he does a SHOW ERRORS in SQPlus, it shows nothing. If I do the same thing I can see the errors from the compiled procedure. I assume this is a permissions thing but have not been able to figure this one out. Anyone have any ideas on this? Thanks, Dave -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Farnsworth, Dave INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Igor Neyman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: oracle10g
Title: Message I don't think there was one ... no handouts ... Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message-From: Matthew Zito [mailto:[EMAIL PROTECTED]Sent: Monday, July 21, 2003 12:14 PMTo: Multiple recipients of list ORACLE-LSubject: RE: oracle10g Does anyone know if there's an archive of this presentation (slides, song and dance routine, etc.) available on the net somewhere? Thanks, Matt --Matthew ZitoGridApp SystemsEmail: [EMAIL PROTECTED]Cell: 646-220-3551Phone: 212-358-8211 x 359http://www.gridapp.com -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jamadagni, RajendraSent: Monday, July 21, 2003 10:39 AMTo: Multiple recipients of list ORACLE-LSubject: RE: oracle10g Yes and no it is more like distributed RAC if you attended Hotsos/2003 you heard about this in the RAC presentation ... Oracle will find a node that has less work and ship your work over there and bring the results back to you ... This is not exactly how it is (much more complicated) but IIRC it is close. Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message-From: Nigel Bishop [mailto:[EMAIL PROTECTED]Sent: Monday, July 21, 2003 11:15 AMTo: Multiple recipients of list ORACLE-LSubject: RE: oracle10g Grid as in Grid computing, sounds like RAC to me -Original Message-From: Ruth Gramolini [mailto:[EMAIL PROTECTED] Sent: 21 July 2003 15:59To: Multiple recipients of list ORACLE-LSubject: RE: oracle10g What on earth does the g stand for? RBG -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Adams, Matthew (GECP, MABG, 088130)Sent: Thursday, July 17, 2003 3:45 PMTo: Multiple recipients of list ORACLE-LSubject: oracle10g Gotta love oracle. It won't be 10i, it'll be Oracle10g what on earth are they thinking? http://www.oracle.com/oracleworld/paris/conference/ *This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.*1
RE: SHOW ERRORS not working
Not sure how SHOW ERRORS is implemented in SQLPlus, but it may only be looking at USER_ERRORS intead of ALL_ERRORS. So if your developer is altering another schema's procedure (via the alter ANY procedure privilege) those errors will not show up in his USER_ERRORS. BTW, this is just my guess on this; haven't tried it out myself. -Original Message- Sent: Monday, July 21, 2003 11:45 AM To: Multiple recipients of list ORACLE-L I have a developer that has ALTER ANY PROCEDURE rights. He changes a procedure, then compiles it and it says there are errors. But when he does a SHOW ERRORS in SQPlus, it shows nothing. If I do the same thing I can see the errors from the compiled procedure. I assume this is a permissions thing but have not been able to figure this one out. Anyone have any ideas on this? Thanks, Dave -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Farnsworth, Dave INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rudy Zung INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: SHOW ERRORS not working
This used to get me all the time. I'm pretty sure you need to issue SET SERVEROUTPUT ON; to see the output. Ciao Fuzzy :-) > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of > Farnsworth, Dave > Sent: Monday, July 21, 2003 16:45 > To: Multiple recipients of list ORACLE-L > Subject: SHOW ERRORS not working > > > I have a developer that has ALTER ANY PROCEDURE rights. He > changes a procedure, then compiles it and it says there are > errors. But when he does a SHOW ERRORS in SQPlus, it shows > nothing. If I do the same thing I can see the errors from > the compiled procedure. I assume this is a permissions thing > but have not been able to figure this one out. Anyone have > any ideas on this? > > Thanks, > > Dave > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Farnsworth, Dave > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Grant Allen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: SHOW ERRORS not working
Dave, Is the procedure owner the developer? If there are errors then they would show up in user_errors other wise the errors are owned by the owner of the procedure. Check the grants on the different xxx_error tables and grant accordingly. Ron >>> [EMAIL PROTECTED] 07/21/03 11:44AM >>> I have a developer that has ALTER ANY PROCEDURE rights. He changes a procedure, then compiles it and it says there are errors. But when he does a SHOW ERRORS in SQPlus, it shows nothing. If I do the same thing I can see the errors from the compiled procedure. I assume this is a permissions thing but have not been able to figure this one out. Anyone have any ideas on this? Thanks, Dave -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Farnsworth, Dave INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: SHOW ERRORS not working
ask him to try "select * from user_errors" if that works ? -ak - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Monday, July 21, 2003 8:44 AM > I have a developer that has ALTER ANY PROCEDURE rights. He changes a procedure, then compiles it and it says there are errors. But when he does a SHOW ERRORS in SQPlus, it shows nothing. If I do the same thing I can see the errors from the compiled procedure. I assume this is a permissions thing but have not been able to figure this one out. Anyone have any ideas on this? > > Thanks, > > Dave > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Farnsworth, Dave > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: AK INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: SHOW ERRORS not working
you sure? Ive noticed this before. SHOW ERRORS is a function. Do you know where its created? you can find the code and then just craete the show errors function? might be in sql.bsq > > From: "Grant Allen" <[EMAIL PROTECTED]> > Date: 2003/07/21 Mon PM 12:24:24 EDT > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > Subject: RE: SHOW ERRORS not working > > This used to get me all the time. I'm pretty sure you need to issue > > SET SERVEROUTPUT ON; > > to see the output. > > Ciao > Fuzzy > :-) > > > > -Original Message- > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of > > Farnsworth, Dave > > Sent: Monday, July 21, 2003 16:45 > > To: Multiple recipients of list ORACLE-L > > Subject: SHOW ERRORS not working > > > > > > I have a developer that has ALTER ANY PROCEDURE rights. He > > changes a procedure, then compiles it and it says there are > > errors. But when he does a SHOW ERRORS in SQPlus, it shows > > nothing. If I do the same thing I can see the errors from > > the compiled procedure. I assume this is a permissions thing > > but have not been able to figure this one out. Anyone have > > any ideas on this? > > > > Thanks, > > > > Dave > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.net > > -- > > Author: Farnsworth, Dave > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > > San Diego, California-- Mailing list and web hosting services > > - > > To REMOVE yourself from this mailing list, send an E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > > the message BODY, include a line containing: UNSUB ORACLE-L > > (or the name of mailing list you want to be removed from). You may > > also send the HELP command for other information (like subscribing). > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Grant Allen > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: <[EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: SHOW ERRORS not working
Have you tried 'show errors procedure blabla'? Gudmundur -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gudmundur Bjarni Josepsson INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: SHOW ERRORS not working
Nope, in fact this is a good example of my failure to "read the whole question before replying". I thought Dave said no output was showing ... but he really said no errors were showing after the response that there were errors. My bad. I blame the fact it's Monday :-) I think the other suggests on user_errors etc. are on the right track. Ciao Fuzzy :-) > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of > [EMAIL PROTECTED] > Sent: Monday, July 21, 2003 17:44 > To: Multiple recipients of list ORACLE-L > Subject: Re: RE: SHOW ERRORS not working > > > you sure? Ive noticed this before. SHOW ERRORS is a function. > Do you know where its created? you can find the code and then > just craete the show errors function? might be in sql.bsq > > > > From: "Grant Allen" <[EMAIL PROTECTED]> > > Date: 2003/07/21 Mon PM 12:24:24 EDT > > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > > Subject: RE: SHOW ERRORS not working > > > > This used to get me all the time. I'm pretty sure you need to issue > > > > SET SERVEROUTPUT ON; > > > > to see the output. > > > > Ciao > > Fuzzy > > :-) > > > > > > > -Original Message- > > > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of > > > Farnsworth, Dave > > > Sent: Monday, July 21, 2003 16:45 > > > To: Multiple recipients of list ORACLE-L > > > Subject: SHOW ERRORS not working > > > > > > > > > I have a developer that has ALTER ANY PROCEDURE rights. He > > > changes a procedure, then compiles it and it says there are > > > errors. But when he does a SHOW ERRORS in SQPlus, it shows > > > nothing. If I do the same thing I can see the errors from > > > the compiled procedure. I assume this is a permissions thing > > > but have not been able to figure this one out. Anyone have > > > any ideas on this? > > > > > > Thanks, > > > > > > Dave > > > -- > > > Please see the official ORACLE-L FAQ: http://www.orafaq.net > > > -- > > > Author: Farnsworth, Dave > > > INET: [EMAIL PROTECTED] > > > > > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > > San Diego, California-- Mailing list and web hosting services > > - > > To REMOVE yourself from this mailing list, send an E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > > the message BODY, include a line containing: UNSUB ORACLE-L > > (or the name of mailing list you want to be removed from). You may > > also send the HELP command for other information (like subscribing). > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Grant Allen > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: <[EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Grant Allen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Solaris/Veritas filesystem for Oracle
Hi, After I moved all my Oracle tablespace datafiles to ufs filesystems in Veritas Volume, the database performance suffers a whole lot. I think the problem is in the way I create the volume or the way I create the filesystem. vxassist -g lst1dg make odata1 55000m layout=stripe nstripe=3 newfs -i 2 -m 1 -b 8192 -f 8192 /dev/vx/rdsk/lst1dg/odata1 Anybody has any insights? Thanks, Roger Xu Database Administrator Dr Pepper Bottling Company of Texas (972)721-8337 This email has been scanned for all viruses by the MessageLabs Email Security System. For more information on a proactive email security service working around the clock, around the globe, visit http://www.messagelabs.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Roger Xu INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: SHOW ERRORS not working
I don't think SHOW is a function that you will find in any of the Oracle db creation scripts. It is most likely part of the sql*plus program. The keyword SHOW can be used for a lot of things (USER and PARAMETER come to mind). Obviously, it reads some data structures, but I am sure it is not a stored proc. [EMAIL PROTECTED] wrote: > > you sure? Ive noticed this before. SHOW ERRORS is a function. Do you know where its > created? you can find the code and then just craete the show errors function? might > be in sql.bsqbegin:vcard n:Fink;Daniel tel;cell:303.808.3282 tel;work:303.272.3225 x-mozilla-html:TRUE adr:;; version:2.1 email;internet:[EMAIL PROTECTED] title:DB Services Lead x-mozilla-cpt:;-4832 fn:Daniel Fink end:vcard
RE: Solaris/Veritas filesystem for Oracle
Hrrrmmhard to say from just that. Would you be comfortable sending a vxprint -g lst1dg -hrt so we can see how the volumes got created? Thanks, Matt -- Matthew Zito GridApp Systems Email: [EMAIL PROTECTED] Cell: 646-220-3551 Phone: 212-358-8211 x 359 http://www.gridapp.com > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On > Behalf Of Roger Xu > Sent: Monday, July 21, 2003 12:04 PM > To: Multiple recipients of list ORACLE-L > Subject: Solaris/Veritas filesystem for Oracle > > > Hi, > > After I moved all my Oracle tablespace datafiles to ufs > filesystems in Veritas Volume, the database performance > suffers a whole lot. > > I think the problem is in the way I create the volume or the > way I create the filesystem. > > vxassist -g lst1dg make odata1 55000m layout=stripe nstripe=3 > newfs -i 2 -m 1 -b 8192 -f 8192 /dev/vx/rdsk/lst1dg/odata1 > > Anybody has any insights? > > Thanks, > > Roger Xu > Database Administrator > Dr Pepper Bottling Company of Texas > (972)721-8337 > > > __ > __ > This email has been scanned for all viruses by the > MessageLabs Email Security System. For more information on a > proactive email security service working around the clock, > around the globe, visit http://www.messagelabs.com > __ > __ > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Roger Xu > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') > and in the message BODY, include a line containing: UNSUB > ORACLE-L (or the name of mailing list you want to be removed > from). You may also send the HELP command for other > information (like subscribing). > > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Matthew Zito INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Solaris/Veritas filesystem for Oracle
the following 6 volumes have all my datafiles, [lostdog]root:/tmp>df -k | grep sapdata | sort /dev/vx/dsk/lst1dg/odsd1 15260136 14811592 29594499%/oracle/DV2/sapdata1 /dev/vx/dsk/lst1dg/odsd2 86474632 80075904 553398494%/oracle/DV2/sapdata2 /dev/vx/dsk/lst1dg/odsd3 55954312 53925072 146970498%/oracle/DV2/sapdata3 /dev/vx/dsk/lst1dg/odsd4 14242376 13831056 26890499%/oracle/DV2/sapdata4 /dev/vx/dsk/lst1dg/odsd5 15260136 14271616 83592095%/oracle/DV2/sapdata5 /dev/vx/dsk/lst1dg/odsd6 17294408 16187536 93392895%/oracle/DV2/sapdata6 Thanks, Roger -Original Message- Sent: Monday, July 21, 2003 12:29 PM To: Multiple recipients of list ORACLE-L Hrrrmmhard to say from just that. Would you be comfortable sending a vxprint -g lst1dg -hrt so we can see how the volumes got created? Thanks, Matt -- Matthew Zito GridApp Systems Email: [EMAIL PROTECTED] Cell: 646-220-3551 Phone: 212-358-8211 x 359 http://www.gridapp.com > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On > Behalf Of Roger Xu > Sent: Monday, July 21, 2003 12:04 PM > To: Multiple recipients of list ORACLE-L > Subject: Solaris/Veritas filesystem for Oracle > > > Hi, > > After I moved all my Oracle tablespace datafiles to ufs > filesystems in Veritas Volume, the database performance > suffers a whole lot. > > I think the problem is in the way I create the volume or the > way I create the filesystem. > > vxassist -g lst1dg make odata1 55000m layout=stripe nstripe=3 > newfs -i 2 -m 1 -b 8192 -f 8192 /dev/vx/rdsk/lst1dg/odata1 > > Anybody has any insights? > > Thanks, > > Roger Xu > Database Administrator > Dr Pepper Bottling Company of Texas > (972)721-8337 > > > __ > __ > This email has been scanned for all viruses by the > MessageLabs Email Security System. For more information on a > proactive email security service working around the clock, > around the globe, visit http://www.messagelabs.com > __ > __ > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Roger Xu > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') > and in the message BODY, include a line containing: UNSUB > ORACLE-L (or the name of mailing list you want to be removed > from). You may also send the HELP command for other > information (like subscribing). > > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Matthew Zito INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 email has been scanned for all viruses by the MessageLabs Email Security System. For more information on a proactive email security service working around the clock, around the globe, visit http://www.messagelabs.com This email has been scanned for all viruses by the MessageLabs Email Security System. For more information on a proactive email security service working around the clock, around the globe, visit http://www.messagelabs.com
RAC
Is it possible to setup RAC in one box only. Just to play with it . Dont have more hardware . -ak
Oracle configuration on SAN
Dear Listers, I'm looking for advice on configuring Oracle under a SAN. We just got a new box, an HP UX, with an HP CASA that's connected to an HP MSA1000 with fourteen 72gb drives configured as RAID-5 with Advanced Data Guard, and two global hot spares on that drive shelf. All of this is connected to the HP through two-gb fiber channel host bus adapters. So far, four 75 gb LUNs have been created so that the primary path to the CASA is shared between the two HBAs, providing some load balance between the LUNs -- LUN1 & LUN3 on HBA, LUN2 & LUN4 on the other. Given, this, are there any recommendations for Oracle's configuration? Control file, redo placement? Maybe indexes and data placement don't mean as much any more, but files for recovery should be treated in a different manner. Any insights or experience would be helpful. Most of the information that I've found is marketing, and a description of what SANs are. I'm looking for recommendations for Oracle configuration. Everything I find on OTN sends me to the vendor, but the vendor doesn't have anything specific to Oracle. --- Sherrie Kubis Southwest Florida Water Management District 2379 Broad Street Brooksville FL 34604-6899 Phone: (352) 796-7211, Ext. 4033 Fax: (352) 754-6776 Email: Mailto:[EMAIL PROTECTED] http://WaterMatters.org -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Active Directory question
I've never tried it, but have questions for you anyway: 8^) So you want your clients to query AD for tns connect params a la' OID? Or do you have OID set up & you want to add oracle db info to it, so you can synch OID w/ AD without losing your database info? If the latter, I trust you've seen metalink note 233096.1? http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=233096.1 Have you tried the Active Directory Schema snap-in for MMC? See: http://support.microsoft.com/default.aspx?scid=kb;en-us;320337 for details on the latter. I *think* that should let you define new objects. I'd expect that to not be for the faint of heart tho... HTH, -Roy Roy Pardee Programmer/Analyst/DBA SWFPAC Lockheed Martin IT Extension 8487 -Original Message- Sent: Monday, July 21, 2003 8:25 AM To: Multiple recipients of list ORACLE-L I did not receive any replies to this posting. Does that mean that nobody has connected Oracle to Active Directory? Has anyone tried and given up on this? -Original Message- Sent: Wednesday, July 16, 2003 1:42 PM To: '[EMAIL PROTECTED]' We are trying to configure an Oracle LDAP connection to Microsoft Active Directory. This is so a client machine can get the connection information (an alternative to tnsnames.ora or Oracle Names) and connect to an Oracle9i database on Sun Solaris. Does anyone know how you create the container called Oracle Context Structure in Active Directory? My Active Directory administrator tells me this is not like a normal AD container. We've read the documents and are confused on this point. Thanks. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pardee, Roy E INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 configuration on SAN
You are probably not going to be too happy with the raid5 organization. Please tell us how the disks are organized inside the array. Are they on multiple internal controllers? Is the cache ram? Allan -Original Message- [mailto:[EMAIL PROTECTED] Sent: Monday, July 21, 2003 1:49 PM To: Multiple recipients of list ORACLE-L Dear Listers, I'm looking for advice on configuring Oracle under a SAN. We just got a new box, an HP UX, with an HP CASA that's connected to an HP MSA1000 with fourteen 72gb drives configured as RAID-5 with Advanced Data Guard, and two global hot spares on that drive shelf. All of this is connected to the HP through two-gb fiber channel host bus adapters. So far, four 75 gb LUNs have been created so that the primary path to the CASA is shared between the two HBAs, providing some load balance between the LUNs -- LUN1 & LUN3 on HBA, LUN2 & LUN4 on the other. Given, this, are there any recommendations for Oracle's configuration? Control file, redo placement? Maybe indexes and data placement don't mean as much any more, but files for recovery should be treated in a different manner. Any insights or experience would be helpful. Most of the information that I've found is marketing, and a description of what SANs are. I'm looking for recommendations for Oracle configuration. Everything I find on OTN sends me to the vendor, but the vendor doesn't have anything specific to Oracle. --- Sherrie Kubis Southwest Florida Water Management District 2379 Broad Street Brooksville FL 34604-6899 Phone: (352) 796-7211, Ext. 4033 Fax: (352) 754-6776 Email: Mailto:[EMAIL PROTECTED] http://WaterMatters.org -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ This email is intended solely for the person or entity to which it is addressed and may contain confidential and/or privileged information. Copying, forwarding or distributing this message by persons or entities other than the addressee is prohibited. If you have received this email in error, please contact the sender immediately and delete the material from any computer. This email may have been monitored for policy compliance. [021216] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nelson, Allan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: 10G
On more serious note: Here's are links to a couple Oracle grid computing documents. The first is a newsletter I receive from our local Oracle office. The second is an OTN document. http://www.cybcon.com/~jkstill/Jul2003.pdf http://otn.oracle.com/products/oracle9i/grid_computing/Oracle9iGridCookbook.html Jared Daniel Fink <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 07/18/2003 01:19 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:10G I just realized what the upgraded name for 9ias will be... daniel.fink.vcf Description: Binary data
iAS Apache name-based virtual hosting
Has anyone managed to make name-based virtual hosting work on Apache bundled into iAS for Win32? We configured Apache here, but strangely the original hostname still works. We see the same page whether we type in the virtual hostname or the actual host name. I would have thought that with a tag, the actual host name would not point to the virtual host's page. I must have forgotten to do something somewhere... Patrice.
RE: faq broke? -- Other options
Title: RE: faq broke? -- Other options There was an astTom article in the latest issue of Oracle magazine that went over how to do this (I don't think it was specific to 9i) and then went on to explain why you WOULDN"T want to do this. -Original Message- From: Hallas, John, Tech Dev [mailto:[EMAIL PROTECTED]] Sent: Monday, July 21, 2003 10:54 AM To: Multiple recipients of list ORACLE-L Subject: RE: faq broke? -- Other options Good point Rich. I am sure I saw a post recently from Cary Millsap which shows how you could flush the buffers out with an alter system command (9i only) - to save restarting the database when running performance trials I have searched for it everywhere to no avail So if anybody recalls what it was please let me know (I assume it is undocumented as I cannot find anything in the manual) Thnaks John -Original Message- Sent: 21 July 2003 15:45 To: Multiple recipients of list ORACLE-L Hey Bruce, Any possibility of making the bodies of the FatCity archived messages searchable, instead of just the subject? That's the only reason why I even bother with the orafaq search. Thanks, Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA > -Original Message- > From: Bruce A. Bergman [mailto:[EMAIL PROTECTED]] > Sent: Saturday, July 19, 2003 2:49 PM > To: Multiple recipients of list ORACLE-L > Subject: Re: faq broke? -- Other options > > > Don't think that the only searchable archives are on orafaq. > Fat City has the definitive archives that date back to the > start of the list here. You should consider using the > archives here as well. > > You can find them here: http://www.listguru.com > > thanks, > bruce -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hallas, John, Tech Dev INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: RAC
AK, I remember reading about just what you want to do. It is complicated to set up but it is do-able. see METALINK: Doc ID: Note:166830.1 - Single node Type: BULLETIN Status: PUBLISHED Ron >>> [EMAIL PROTECTED] 07/21/03 02:49PM >>> Is it possible to setup RAC in one box only. Just to play with it . Dont have more hardware . -ak -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
OT slashdot article: does .NET really scale
I found this last weekend while surfing the 'net. http://ask.slashdot.org/askslashdot/03/07/18/2056208.shtml?tid=109&tid=187 Reminds me of the "The Truth about .NET" article on Oracle's web site. Patrice. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: iAS Apache name-based virtual hosting
Title: Message Did you add a NameVirtualHost (ip address) entry to your config file? Otherwise it won't enable name-based vhosting for a particular IP. Matt --Matthew ZitoGridApp SystemsEmail: [EMAIL PROTECTED]Cell: 646-220-3551Phone: 212-358-8211 x 359http://www.gridapp.com -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Boivin, Patrice JSent: Monday, July 21, 2003 2:14 PMTo: Multiple recipients of list ORACLE-LSubject: iAS Apache name-based virtual hosting Has anyone managed to make name-based virtual hosting work on Apache bundled into iAS for Win32? We configured Apache here, but strangely the original hostname still works. We see the same page whether we type in the virtual hostname or the actual host name. I would have thought that with a tag, the actual host name would not point to the virtual host's page. I must have forgotten to do something somewhere... Patrice.
RE: Oracle configuration on SAN
A 14-drive RAID-5 set is very large. It's certainly functional, but the two problems you'll run into is problems with spindle contention and rebuild times. With a 14-drive set, your drive is getting cut into 14 columns, so that there's 14 different disk regions per drive it might have to seek to in order to service any given I/O. That can negatively impact performance on random writes. Have you tested failing out a drive under load? On a 14-drive set the rebuild time is going to be pretty horrendous, and your performance will likely be impacted unless your cache hit numbers are really great. The other problem is that by carving luns globally out of a single RAID-5 set, differing i/o patterns on the luns can create hot spots much more easily, since your small (comparatively, anyway) redo log volume (for exmaple) ends up on only four columns of the disks, and other volumes on other columns on those disks can be hurt by the constant writing. While I'm not necessarily as anti-RAID 5 as some (though I give all due respect and worship to our mighty BAARF leaders), you need to keep a very close eye on your array in this configuration. If you have a normal OLTP workload (whatever "normal" is), play with your cache allocations - the read v. write cache, and if you can do per-lun tweaking, weight the redo and archive log lun(s) very heavily towards write cache. If you're set on RAID-5, I would recommend taking two of the disks and making them a mirrored pair for redo and archive logs. Since the writes tend to be reasonably contiguous, the fact you're hitting just one set of spindles shouldn't hurt quite as bad, and cache should take the edge off a bit. This all being said, my knowledge of that particular HP array is limited at best, so I can't offer vendor-specific recommendations/thoughts that might invalidate some of these concerns. Good luck. Thanks, Matt -- Matthew Zito GridApp Systems Email: [EMAIL PROTECTED] Cell: 646-220-3551 Phone: 212-358-8211 x 359 http://www.gridapp.com > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On > Behalf Of [EMAIL PROTECTED] > Sent: Monday, July 21, 2003 1:49 PM > To: Multiple recipients of list ORACLE-L > Subject: Oracle configuration on SAN > > > Dear Listers, > > I'm looking for advice on configuring Oracle under a SAN. We > just got a new box, an HP UX, with an HP CASA that's > connected to an HP MSA1000 with fourteen 72gb drives > configured as RAID-5 with Advanced Data Guard, and two global > hot spares on that drive shelf. All of this is connected to > the HP through two-gb fiber channel host bus adapters. So > far, four 75 gb LUNs have been created so that the primary > path to the CASA is shared between the two HBAs, providing > some load balance between the LUNs -- LUN1 & LUN3 on HBA, > LUN2 & LUN4 on the other. > > Given, this, are there any recommendations for Oracle's > configuration? Control file, redo placement? Maybe indexes > and data placement don't mean as much any more, but files for > recovery should be treated in a different manner. > > Any insights or experience would be helpful. Most of the > information that I've found is marketing, and a description > of what SANs are. I'm looking for recommendations for Oracle > configuration. Everything I find on OTN sends me to the > vendor, but the vendor doesn't have anything specific to Oracle. > > > > > --- > Sherrie Kubis > Southwest Florida Water Management District > 2379 Broad Street > Brooksville FL 34604-6899 > > Phone: (352) 796-7211, Ext. 4033 > Fax: (352) 754-6776 > Email: Mailto:[EMAIL PROTECTED] > http://WaterMatters.org > > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') > and in the message BODY, include a line containing: UNSUB > ORACLE-L (or the name of mailing list you want to be removed > from). You may also send the HELP command for other > information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Matthew Zito INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for ot
Re: 10G
Jared, Thanks for the articles. It looks like to grid concept would require the idle computers in the office to be connected to a fiber net and available to pick up part of the load when demand increased. Or did I miss-understand the article and each computer has it's own area of expertice and answers the request for info only if the data resides on it's local disk? The grid fits in rather snuggly with the RAC from what I gathered from the articles. Ron >>> [EMAIL PROTECTED] 07/21/03 03:14PM >>> On more serious note: Here's are links to a couple Oracle grid computing documents. The first is a newsletter I receive from our local Oracle office. The second is an OTN document. http://www.cybcon.com/~jkstill/Jul2003.pdf http://otn.oracle.com/products/oracle9i/grid_computing/Oracle9iGridCookbook.html Jared Daniel Fink <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 07/18/2003 01:19 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:10G I just realized what the upgraded name for 9ias will be... -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Active Directory question
Title: Message I didn't see it, probably 10G overload I too have thought about it and decided, um no. My reasons. 1. Its a brand new naming method. Brand new tends to mean buggy. 2. It requires modifying the AD schema (so you need to be schema admin to do this) 3. It will increase AD replication traffic. 4. What does it give that ONAMES doesn't? FWIW we don't register MSSQL with AD either. Niall -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jamadagni, RajendraSent: 21 July 2003 16:35To: Multiple recipients of list ORACLE-LSubject: RE: Active Directory question I have _thought_ about it and given up on that .. seriously, next year we will look at it again ... really . Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message- From: DENNIS WILLIAMS [mailto:[EMAIL PROTECTED]] Sent: Monday, July 21, 2003 11:25 AM To: Multiple recipients of list ORACLE-L Subject: RE: Active Directory question I did not receive any replies to this posting. Does that mean that nobody has connected Oracle to Active Directory? Has anyone tried and given up on this? -Original Message- Sent: Wednesday, July 16, 2003 1:42 PM To: '[EMAIL PROTECTED]' We are trying to configure an Oracle LDAP connection to Microsoft Active Directory. This is so a client machine can get the connection information (an alternative to tnsnames.ora or Oracle Names) and connect to an Oracle9i database on Sun Solaris. Does anyone know how you create the container called Oracle Context Structure in Active Directory? My Active Directory administrator tells me this is not like a normal AD container. We've read the documents and are confused on this point. Thanks. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Solaris/Veritas filesystem for Oracle
Well, I don't know if this is the whole problem, but at least part of the problem is this: v odsd2-ENABLED ACTIVE 17408 SELECT odsd2-02 fsgen pl odsd2-01 odsd2ENABLED ACTIVE 174082473 CONCAT - RW sd lst1dg01-02 odsd2-01 lst1dg01 6144903 31833891 0 c5t32d0 ENA sd lst1dg03-01 odsd2-01 lst1dg03 071124291 31833891 c5t34d0 ENA sd lst1dg04-01 odsd2-01 lst1dg04 071124291 102958182 c5t35d0 ENA pl odsd2-02 odsd2ENABLED ACTIVE 174085542 STRIPE 3/128 RW sd lst1dg16-03 odsd2-02 lst1dg16 3007449 58028454 0/0 c5t54d0 ENA sd lst1dg17-03 odsd2-02 lst1dg17 3007449 58028454 1/0 c5t55d0 ENA sd lst1dg18-03 odsd2-02 lst1dg18 3007449 58028454 2/0 c5t56d0 ENA This volume (and most of the volumes - this is just an example), odsd2 is actually two plexes. My veritas is a wee bit rusty, but as I read this, the two plexes odsd2-01 and odsd-02 are mirrored. However, the first plex odsd2-01, is a concatenated plex, while the second plex is a striped. The implication of that is that if you're only using 20% of the total amount of space for actual data, all writes are going only to the first drive in the concatenated plex - basically, for writes, you're getting none of the advantages of striping. For reads, you're just taking a performance hit, since veritas uses some load-balancing to determine which side of the mirror to read from. S, I'd rework the whole setup such that it uses 0+1 the whole way through, no mixing plex types, and take it from there. Again, storage vendor, database i/o patterns, etc. all vary, and thus your mileage will too. But that's the first thing that jumps out at me as a performance problem. Thanks, Matt -- Matthew Zito GridApp Systems Email: [EMAIL PROTECTED] Cell: 646-220-3551 Phone: 212-358-8211 x 359 http://www.gridapp.com > -Original Message- > From: Roger Xu [mailto:[EMAIL PROTECTED] > Sent: Monday, July 21, 2003 11:53 AM > To: [EMAIL PROTECTED] > Cc: [EMAIL PROTECTED] > Subject: RE: Solaris/Veritas filesystem for Oracle > > > the following 6 volumes have all my datafiles, > > [lostdog]root:/tmp>df -k | grep sapdata | sort > /dev/vx/dsk/lst1dg/odsd1 15260136 14811592 29594499% > /oracle/DV2/sapdata1 > /dev/vx/dsk/lst1dg/odsd2 86474632 80075904 553398494% > /oracle/DV2/sapdata2 > /dev/vx/dsk/lst1dg/odsd3 55954312 53925072 146970498% > /oracle/DV2/sapdata3 > /dev/vx/dsk/lst1dg/odsd4 14242376 13831056 26890499% > /oracle/DV2/sapdata4 > /dev/vx/dsk/lst1dg/odsd5 15260136 14271616 83592095% > /oracle/DV2/sapdata5 > /dev/vx/dsk/lst1dg/odsd6 17294408 16187536 93392895% > /oracle/DV2/sapdata6 > > Thanks, > > Roger > > -Original Message- > From: Matthew Zito [mailto:[EMAIL PROTECTED] > Sent: Monday, July 21, 2003 12:29 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: Solaris/Veritas filesystem for Oracle > > > > Hrrrmmhard to say from just that. Would you be > comfortable sending a vxprint -g lst1dg -hrt so we can see > how the volumes got created? > > Thanks, > Matt > > -- > Matthew Zito > GridApp Systems > Email: [EMAIL PROTECTED] > Cell: 646-220-3551 > Phone: 212-358-8211 x 359 > http://www.gridapp.com > > > -Original Message- > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On > > Behalf Of Roger Xu > > Sent: Monday, July 21, 2003 12:04 PM > > To: Multiple recipients of list ORACLE-L > > Subject: Solaris/Veritas filesystem for Oracle > > > > > > Hi, > > > > After I moved all my Oracle tablespace datafiles to ufs > > filesystems in Veritas Volume, the database performance > > suffers a whole lot. > > > > I think the problem is in the way I create the volume or the > > way I create the filesystem. > > > > vxassist -g lst1dg make odata1 55000m layout=stripe nstripe=3 > > newfs -i 2 -m 1 -b 8192 -f 8192 /dev/vx/rdsk/lst1dg/odata1 > > > > Anybody has any insights? > > > > Thanks, > > > > Roger Xu > > Database Administrator > > Dr Pepper Bottling Company of Texas > > (972)721-8337 > > > > > > __ > > __ > > This email has been scanned for all viruses by the > > MessageLabs Email Security System. For more information on a > > proactive email security service working around the clock, > > around the globe, visit http://www.messagelabs.com > > __ > > __ > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.net > > -- > > Author: Roger Xu > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > > San Diego, California-- Mailing list and web > hosting services > > > - > > To REMOVE yourself from this mailing list, send an E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling
RE: 10G
Jared, Did you read the OTN document? I don't see any new technology here. In fact, it looks like a nightmare. They cited using Read-Only Tablespaces, Transportable Tablespace, database links and Oracle Streams for sharing data across the "blades" of the multi-server nodes. This is supposed to be better than what we do now? I can see myself being driven nuts to get this thing to work. Maybe I need to re-read this (slowly). I see myself explaining to damagers why this is not such a good thing in the coming months. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Monday, July 21, 2003 3:15 PM To: Multiple recipients of list ORACLE-L On more serious note: Here's are links to a couple Oracle grid computing documents. The first is a newsletter I receive from our local Oracle office. The second is an OTN document. http://www.cybcon.com/~jkstill/Jul2003.pdf http://otn.oracle.com/products/oracle9i/grid_computing/Oracle9iGridCookbook. html Jared Daniel Fink <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 07/18/2003 01:19 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:10G I just realized what the upgraded name for 9ias will be... -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: 10G
Ron, Still have read them. :) >From what I already know, this sounds correct. Fits right in with Sun's N1 technology. Jared "Ron Rogers" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 07/21/2003 12:49 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:Re: 10G Jared, Thanks for the articles. It looks like to grid concept would require the idle computers in the office to be connected to a fiber net and available to pick up part of the load when demand increased. Or did I miss-understand the article and each computer has it's own area of expertice and answers the request for info only if the data resides on it's local disk? The grid fits in rather snuggly with the RAC from what I gathered from the articles. Ron >>> [EMAIL PROTECTED] 07/21/03 03:14PM >>> On more serious note: Here's are links to a couple Oracle grid computing documents. The first is a newsletter I receive from our local Oracle office. The second is an OTN document. http://www.cybcon.com/~jkstill/Jul2003.pdf http://otn.oracle.com/products/oracle9i/grid_computing/Oracle9iGridCookbook.html Jared Daniel Fink <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 07/18/2003 01:19 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:10G I just realized what the upgraded name for 9ias will be... -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Fast!
FYI Hi Jared -- Yeah, I've been finally working on getting us closer to real-time speed. I put in the first of the changes about two weeks ago, but you probably didn't notice them until last weekend, when some significant changes were made. I've still got some more work to do, but it's headed the right direction, and I'm glad someone noticed. Actually, to date, you're the ONLY one who noticed. ;-) thanks, bruce - Original Message - To: <[EMAIL PROTECTED]> Sent: Thursday, July 17, 2003 14:18 > Bruce, > > Anything new at your end? > > My posts are showing up in about 2 minutes, which is most unusual. > > Jared > > > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: oracle10g
Title: Message 101 April Wells Oracle DBA/Oracle Apps DBA Corporate Systems Amarillo Texas You will recognize your own path when you come upon it, because you will suddenly have all the energy and imagination you will ever need. ~ Jerry Gillies ~ -Original Message-From: Orr, Steve [mailto:[EMAIL PROTECTED]Sent: Monday, July 21, 2003 10:45 AMTo: Multiple recipients of list ORACLE-LSubject: RE: oracle10g 10 to the googol power. Pop Quiz... How many goose eggs is that?! -Original Message-From: Adams, Matthew (GECP, MABG, 088130) [mailto:[EMAIL PROTECTED] Sent: Thursday, July 17, 2003 1:45 PMTo: Multiple recipients of list ORACLE-LSubject: oracle10g Gotta love oracle. It won't be 10i, it'll be Oracle10g what on earth are they thinking? http://www.oracle.com/oracleworld/paris/conference/ The information contained in this communication, including attachments, is strictly confidential and for the intended use of the addressee only; it may also contain proprietary, price sensitive, or legally privileged information. Notice is hereby given that any disclosure, distribution, dissemination, use, or copying of the information by anyone other than the intended recipient is strictly prohibited and may be illegal. If you have received this communication in error, please notify the sender immediately by reply e-mail, delete this communication, and destroy all copies. Corporate Systems, Inc. has taken reasonable precautions to ensure that any attachment to this e-mail has been swept for viruses. We specifically disclaim all liability and will accept no responsibility for any damage sustained as a result of software viruses and advise you to carry out your own virus checks before opening any attachment.
RE: Fast!
I've noticed! Good job Bruce! Tom Mercadante Oracle Certified Professional -Original Message- Sent: Monday, July 21, 2003 4:29 PM To: Multiple recipients of list ORACLE-L FYI Hi Jared -- Yeah, I've been finally working on getting us closer to real-time speed. I put in the first of the changes about two weeks ago, but you probably didn't notice them until last weekend, when some significant changes were made. I've still got some more work to do, but it's headed the right direction, and I'm glad someone noticed. Actually, to date, you're the ONLY one who noticed. ;-) thanks, bruce - Original Message - To: <[EMAIL PROTECTED]> Sent: Thursday, July 17, 2003 14:18 > Bruce, > > Anything new at your end? > > My posts are showing up in about 2 minutes, which is most unusual. > > Jared > > > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle configuration on SAN
In the same cache vein, make sure you know what type of caching is being done at each LUN (or how ever the HP's setup). Write-thru caching won't help your write speed at all, while write-back will. The trade off is that since write-back acknowledges the write from the cache (write-thru won't acknowledge the write until it physically hits the much slower disk), there is a small chance that it may not be flushed to disk in the event of failure (e.g. power). I don't know about HP's offering, but the FastT900 from IBM allows you to mirror your cache, plus they have a battery backup for them to flush the cache to disk in the case of power failure. So, for us, I imagine we'll head for the mirrored write-back cache option w/BBU. I think it's an acceptable risk for the gains for our particular situation. Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA > -Original Message- > From: Matthew Zito [mailto:[EMAIL PROTECTED] > Sent: Monday, July 21, 2003 3:04 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: Oracle configuration on SAN > > > > A 14-drive RAID-5 set is very large. It's certainly > functional, but the > two problems you'll run into is problems with spindle contention and > rebuild times. With a 14-drive set, your drive is getting cut into 14 > columns, so that there's 14 different disk regions per drive it might > have to seek to in order to service any given I/O. That can > negatively > impact performance on random writes. Have you tested failing > out a drive > under load? On a 14-drive set the rebuild time is going to be pretty > horrendous, and your performance will likely be impacted unless your > cache hit numbers are really great. > > The other problem is that by carving luns globally out of a single > RAID-5 set, differing i/o patterns on the luns can create hot > spots much > more easily, since your small (comparatively, anyway) redo log volume > (for exmaple) ends up on only four columns of the disks, and other > volumes on other columns on those disks can be hurt by the constant > writing. > > While I'm not necessarily as anti-RAID 5 as some (though I > give all due > respect and worship to our mighty BAARF leaders), you need to keep a > very close eye on your array in this configuration. If you have a > normal OLTP workload (whatever "normal" is), play with your cache > allocations - the read v. write cache, and if you can do per-lun > tweaking, weight the redo and archive log lun(s) very heavily towards > write cache. > > If you're set on RAID-5, I would recommend taking two of the disks and > making them a mirrored pair for redo and archive logs. Since > the writes > tend to be reasonably contiguous, the fact you're hitting just one set > of spindles shouldn't hurt quite as bad, and cache should > take the edge > off a bit. > > This all being said, my knowledge of that particular HP array > is limited > at best, so I can't offer vendor-specific > recommendations/thoughts that > might invalidate some of these concerns. Good luck. > > Thanks, > Matt > > -- > Matthew Zito -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Fast!
I don't keep my mail window on top. But when I check back in I have been noticing that the mail is already in the inbox. Very good work on your end. I will try not to expect it all of the time as we still have to contend with the internet, local gateways, mailservers, fire walls, and border managers and don't forget the network folks are at work too. Ron >>> [EMAIL PROTECTED] 07/21/03 04:39PM >>> I've noticed! Good job Bruce! Tom Mercadante Oracle Certified Professional -Original Message- Sent: Monday, July 21, 2003 4:29 PM To: Multiple recipients of list ORACLE-L FYI Hi Jared -- Yeah, I've been finally working on getting us closer to real-time speed. I put in the first of the changes about two weeks ago, but you probably didn't notice them until last weekend, when some significant changes were made. I've still got some more work to do, but it's headed the right direction, and I'm glad someone noticed. Actually, to date, you're the ONLY one who noticed. ;-) thanks, bruce - Original Message - To: <[EMAIL PROTECTED]> Sent: Thursday, July 17, 2003 14:18 > Bruce, > > Anything new at your end? > > My posts are showing up in about 2 minutes, which is most unusual. > > Jared > > > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
need execute immediate and script help
Im calling a script that uses dynamic sql. Im passing in a value as well. I keep getting SP2-0552: Bind variable "2" not declared. Here is a code snipped declare v_var1 Varchar2(30) := 'TEST'; v_var2 VARCHAR2(30) := '&1'; total number; begin execute immediate ' Select * ' || ' from user_objects '|| ' where object_name = :1 '|| ' or object_name = :2 '|| using v_var1,v_var2 into total; end; / I call it as follows: @script HELLO -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: <[EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
need help with execute immediate from a script
Im calling a script that uses dynamic sql. Im passing in a value as well. I keep getting SP2-0552: Bind variable "2" not declared. Here is a code snipped declare v_var1 Varchar2(30) := 'TEST'; v_var2 VARCHAR2(30) := '&1'; total number; begin execute immediate ' Select * ' || ' from user_objects '|| ' where object_name = :1 '|| ' or object_name = :2 '|| using v_var1,v_var2 into total; end; / I call it as follows: @script HELLO -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: <[EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: RAC
You need at least 2 servers. Dick GouletSenior Oracle DBAOracle Certified 8i DBA -Original Message-From: AK [mailto:[EMAIL PROTECTED]Sent: Monday, July 21, 2003 2:49 PMTo: Multiple recipients of list ORACLE-LSubject: RAC Is it possible to setup RAC in one box only. Just to play with it . Dont have more hardware . -ak
HP-UX 11i/9.2.0.3/Strange Executions
Hi Everyone! HELP! I upgraded my SAP *PRODUCTION* instance to 9.2.0.3 over the weekend. Everything up until now has been OK. However, I now have some SAP Transactions (read: data entry forms) that are abending unexpectedly. What's strange is that when we run the transaction on our Stage server the explain plan is different, and the query succeeds. In PRD, the query is a single-step, and in stage it gets broken out into sub-queries and executed there. I created a report of all the database parameters. There is no difference that cannot be explained by the difference in CPUs, database name, or application paths. They are fundamentally identical. But the query aborts on PRD. I am attaching the top few lines of a typical trace file. ANY help, RTFM references, suggestions, incantations, incense, or holy water will be appreciated. Thanks, Mike *** 2003-07-21 14:52:06.921 *** SESSION ID:(326.5957) 2003-07-21 14:52:06.886 Exception signal: 11 (SIGSEGV), code: 0 (unknown code), addr: 0x80016ede9f30, PC: [0x41331c0c, kghfrmrg()+596] Registers: r1: 8001d9e8 r22: 6e6178d8 sr4: 7df0c00 rp:0 arg3: 80016ede9f28 sr0: 67c9c00 r3: 413319b8 arg2: c0006e615fa0 sr1: d7db000 r4:0 arg1: 6e615fa0 sr2:0 r5:0 arg0: c0b38f001131 sr3:0 r6: 7ffcdp: 8001000ca608 sr5: 693 r7:0 ret0:0 sr6: a814c00 r8: 8001007d3798 ret1: 800 sr7: 67c9c00 r9: 8001007d3780sp: 83ffbfff6880 cr0:0 r10:0 r31:6 cr8: 77f6368 r11:0 sar: 38 cr9: 77f6378 r12:0 pcoqh: 41331c0f ccr:0 r13:1 pcsqh: 693 cr12: 494c008 r14: 83ffbfff48c0 pcoqt: 41331a93 cr13: 4a2b008 r15: 83ffbfff48c8 pcsqt: 693 cr24: 4a2c808 r16: 403f85d0 eiem: cr25: 4a2a808 r17: af0 iir: 72f50010 cr26: 4a2c808 r18:0 isr: a814c00 mpsfu_hi: 8001000e36c8 r19: 8001d9e8 ior: 80016ede9f30 mpsfu_lo:0 r20:0 ipsw: ff080cff1f mpsfu_ov: 41 r21: 8001007d2650 goto:97f68 pad:0 *** 2003-07-21 14:52:07.811 ksedmp: internal or fatal error ORA-07445: exception encountered: core dump [kghfrmrg()+596] [SIGSEGV] [unknown code] [0x80016EDE9F30] [] [] Current SQL statement for this session: SELECT T_00 . "MATNR" , T_00 . "PRDHA" , T_01 . "MAKTX" FROM "MARA" T_00 , "MAKT" T_01 WHERE ( T_01 . "MANDT" = :A0 AND T_01 . "MATNR" = T_00 . "MA TNR" ) AND T_00 . "MANDT" = :A1 AND ( ( T_00 . "MATNR" BETWEEN :A2 AND :A3 OR T_00 . "MATNR" BETWEEN :A4 AND :A5 OR T_00 . "MATNR" BETWEEN :A6 AND :A7 OR T_00 . "MATNR" BETWEEN :A8 AND :A9 OR T_00 . "MATNR" BETWEEN :A10 AND :A11 OR T_00 . "MATNR" BETWEEN :A12 AND :A13 OR T_00 . "MATNR" BETWEEN :A14 AND :A15 OR T_00 . "MATNR" BETWEEN :A16 AND :A17 OR T_00 . "MATNR" BETWEEN :A18 AND :A19 ) OR T_00 . "MATNR" IN ( :A20 , :A21 , :A22 , :A23 , :A24 , :A25 , :A26 , :A27 , :A28 , :A29 , :A30 , :A31 , :A32 , :A33 , :A34 , :A35 , :A36 , :A37 , :A38 , :A39 , :A40 , :A41 , :A42 , :A43 , :A44 , :A45 , :A46 , :A47 , :A48 , :A49 , :A50 , :A51 , :A52 , :A53 , :A54 , :A55 , :A56 , :A57 , :A58 , :A59 , :A60 , :A61 , :A62 , :A63 , :A64 , :A65 , :A66 , :A67 , :A68 , :A69 , :A70 , :A71 , :A72 , :A73 , :A74 , :A75 , :A76 , :A77 , :A78 , :A79 , :A80 , :A81 , :A82 , :A83 , :A84 , :A85 , :A86 , :A87 , :A88 , :A89 , :A90 , :A91 , :A92 , :A93 , :A94 , :A95 , :A96 , :A97 , :A98 , :A99 , :A100 , :A101 , :A102 , :A103 , :A104 , :A105 , :A106 , :A107 , :A108 , :A109 , :A110 , :A111 , :A112 , :A113 , :A114 , :A115 , :A116 , :A117 , :A118 , :A119 , :A120 , :A121 , :A122 , :A123 , :A124 , :A 125 , :A126 , :A127 , :A128 , :A129 , :A130 , :A131 , :A132 , :A133 , :A134 , :A135 , :A136 , :A137 , :A138 , :A139 , :A140 , :A141 , :A142 , :A143 , :A144 , :A145 , :A146 , :A147 , :A148 , :A149 , :A150 , :A151 , :A152 , :A153 , :A154 , :A155 , :A156 , :A157 , :A158 , :A159 , :A160 , :A161 , :A162 , :A163 , :A164 , :A165 , :A166 , :A167 , :A168 , :A169 , :A170 , :A171 , :A172 , :A173 , :A174 , :A175 , :A176 , :A177 , :A178 , :A179 , :A1 80 , :A181 , :A182 , :A183 , :A184 , :A185 , :A186 , :A187 , :A188 , :A189 , :A190 , :A191 , :A192 , :A193 , :A194 , :A195 , :A196 , :A197 , :A198 , :A199 , :A200 , :A201 , :A202 , :A203 , :A204 , :A205 , :A206 , :A207 , :A208 , :A209 , :A210 , :A211 , :A2
RE: 10G
We're already doing grid computing. My part is infinitesimal. We keep or MCAT database in Oracle See http://www.npaci.edu/DICE/SRB/, and I try to keep that database healthy. Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] -Original Message- Sent: Monday, July 21, 2003 1:30 PM To: Multiple recipients of list ORACLE-L Ron, Still have read them. :) >From what I already know, this sounds correct. Fits right in with Sun's N1 technology. Jared "Ron Rogers" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 07/21/2003 12:49 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:Re: 10G Jared, Thanks for the articles. It looks like to grid concept would require the idle computers in the office to be connected to a fiber net and available to pick up part of the load when demand increased. Or did I miss-understand the article and each computer has it's own area of expertice and answers the request for info only if the data resides on it's local disk? The grid fits in rather snuggly with the RAC from what I gathered from the articles. Ron >>> [EMAIL PROTECTED] 07/21/03 03:14PM >>> On more serious note: Here's are links to a couple Oracle grid computing documents. The first is a newsletter I receive from our local Oracle office. The second is an OTN document. http://www.cybcon.com/~jkstill/Jul2003.pdf http://otn.oracle.com/products/oracle9i/grid_computing/Oracle9iGridCookbook.html Jared Daniel Fink <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 07/18/2003 01:19 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:10G I just realized what the upgraded name for 9ias will be... -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: MacGregor, Ian A. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: need execute immediate and script help
Title: RE: need execute immediate and script help you want 'select count(*)' ... right? Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, July 21, 2003 5:00 PM To: Multiple recipients of list ORACLE-L Subject: need execute immediate and script help Im calling a script that uses dynamic sql. Im passing in a value as well. I keep getting SP2-0552: Bind variable "2" not declared. Here is a code snipped declare v_var1 Varchar2(30) := 'TEST'; v_var2 VARCHAR2(30) := '&1'; total number; begin execute immediate ' Select * ' || ' from user_objects '|| ' where object_name = :1 '|| ' or object_name = :2 '|| using v_var1,v_var2 into total; end; / I call it as follows: @script HELLO -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: <[EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.*2
RE: need execute immediate and script help
Your "using v_var1,v_var2" shouldn't be appended to the string that represents the dynamic SQL to execute; the "using..." is part of the syntac for execute immediate. An Oracle error message being what they are, they don't always highlight the correct cause of fault, but will identify some other error located close to where the real fault lies. For your solution, remove the "||" that occurs after ":2" It is also unlikely that you can select "*" into TOTAL, which has been declared as a NUMBER. Consider "count(*)" perhaps? -Original Message- Sent: Monday, July 21, 2003 5:00 PM To: Multiple recipients of list ORACLE-L Im calling a script that uses dynamic sql. Im passing in a value as well. I keep getting SP2-0552: Bind variable "2" not declared. Here is a code snipped declare v_var1 Varchar2(30) := 'TEST'; v_var2 VARCHAR2(30) := '&1'; total number; begin execute immediate ' Select * ' || ' from user_objects '|| ' where object_name = :1 '|| ' or object_name = :2 '|| using v_var1,v_var2 into total; end; / I call it as follows: @script HELLO -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: <[EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rudy Zung INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: RAC
Title: Message No, its definitely possible to do it with one - I know we've done it in the lab. It wasn't me hands-on-the-keyboard doing the work, but as it was explained to me, you basically trick the sole node into thinking that it used to have a friend, and that friend had died in a horrible horrible accident and that it should boldly carry on for the both of them. Matt --Matthew ZitoGridApp SystemsEmail: [EMAIL PROTECTED]Cell: 646-220-3551Phone: 212-358-8211 x 359http://www.gridapp.com -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Goulet, DickSent: Monday, July 21, 2003 4:04 PMTo: Multiple recipients of list ORACLE-LSubject: RE: RAC You need at least 2 servers. Dick GouletSenior Oracle DBAOracle Certified 8i DBA -Original Message-From: AK [mailto:[EMAIL PROTECTED]Sent: Monday, July 21, 2003 2:49 PMTo: Multiple recipients of list ORACLE-LSubject: RAC Is it possible to setup RAC in one box only. Just to play with it . Dont have more hardware . -ak
Re: HP-UX 11i/9.2.0.3/Strange Executions
SIGSEGV = Segment Violation = invalid address = bad code Sounds like you need to contact SAP and/or Oracle support. Jared "Vergara, Michael (TEM)" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 07/21/2003 02:04 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:HP-UX 11i/9.2.0.3/Strange Executions Hi Everyone! HELP! I upgraded my SAP *PRODUCTION* instance to 9.2.0.3 over the weekend. Everything up until now has been OK. However, I now have some SAP Transactions (read: data entry forms) that are abending unexpectedly. What's strange is that when we run the transaction on our Stage server the explain plan is different, and the query succeeds. In PRD, the query is a single-step, and in stage it gets broken out into sub-queries and executed there. I created a report of all the database parameters. There is no difference that cannot be explained by the difference in CPUs, database name, or application paths. They are fundamentally identical. But the query aborts on PRD. I am attaching the top few lines of a typical trace file. ANY help, RTFM references, suggestions, incantations, incense, or holy water will be appreciated. Thanks, Mike *** 2003-07-21 14:52:06.921 *** SESSION ID:(326.5957) 2003-07-21 14:52:06.886 Exception signal: 11 (SIGSEGV), code: 0 (unknown code), addr: 0x80016ede9f30, PC: [0x41331c0c, kghfrmrg()+596] Registers: r1: 8001d9e8 r22: 6e6178d8 sr4: 7df0c00 rp:0 arg3: 80016ede9f28 sr0: 67c9c00 r3: 413319b8 arg2: c0006e615fa0 sr1: d7db000 r4:0 arg1: 6e615fa0 sr2: 0 r5:0 arg0: c0b38f001131 sr3: 0 r6: 7ffcdp: 8001000ca608 sr5: 693 r7:0 ret0:0 sr6: a814c00 r8: 8001007d3798 ret1: 800 sr7: 67c9c00 r9: 8001007d3780sp: 83ffbfff6880 cr0: 0 r10:0 r31:6 cr8: 77f6368 r11:0 sar: 38 cr9: 77f6378 r12:0 pcoqh: 41331c0f ccr: 0 r13:1 pcsqh: 693 cr12: 494c008 r14: 83ffbfff48c0 pcoqt: 41331a93 cr13: 4a2b008 r15: 83ffbfff48c8 pcsqt: 693 cr24: 4a2c808 r16: 403f85d0 eiem: cr25: 4a2a808 r17: af0 iir: 72f50010 cr26: 4a2c808 r18:0 isr: a814c00 mpsfu_hi: 8001000e36c8 r19: 8001d9e8 ior: 80016ede9f30 mpsfu_lo: 0 r20:0 ipsw: ff080cff1f mpsfu_ov: 41 r21: 8001007d2650 goto:97f68 pad: 0 *** 2003-07-21 14:52:07.811 ksedmp: internal or fatal error ORA-07445: exception encountered: core dump [kghfrmrg()+596] [SIGSEGV] [unknown code] [0x80016EDE9F30] [] [] Current SQL statement for this session: SELECT T_00 . "MATNR" , T_00 . "PRDHA" , T_01 . "MAKTX" FROM "MARA" T_00 , "MAKT" T_01 WHERE ( T_01 . "MANDT" = :A0 AND T_01 . "MATNR" = T_00 . "MA TNR" ) AND T_00 . "MANDT" = :A1 AND ( ( T_00 . "MATNR" BETWEEN :A2 AND :A3 OR T_00 . "MATNR" BETWEEN :A4 AND :A5 OR T_00 . "MATNR" BETWEEN :A6 AND :A7 OR T_00 . "MATNR" BETWEEN :A8 AND :A9 OR T_00 . "MATNR" BETWEEN :A10 AND :A11 OR T_00 . "MATNR" BETWEEN :A12 AND :A13 OR T_00 . "MATNR" BETWEEN :A14 AND :A15 OR T_00 . "MATNR" BETWEEN :A16 AND :A17 OR T_00 . "MATNR" BETWEEN :A18 AND :A19 ) OR T_00 . "MATNR" IN ( :A20 , :A21 , :A22 , :A23 , :A24 , :A25 , :A26 , :A27 , :A28 , :A29 , :A30 , :A31 , :A32 , :A33 , :A34 , :A35 , :A36 , :A37 , :A38 , :A39 , :A40 , :A41 , :A42 , :A43 , :A44 , :A45 , :A46 , :A47 , :A48 , :A49 , :A50 , :A51 , :A52 , :A53 , :A54 , :A55 , :A56 , :A57 , :A58 , :A59 , :A60 , :A61 , :A62 , :A63 , :A64 , :A65 , :A66 , :A67 , :A68 , :A69 , :A70 , :A71 , :A72 , :A73 , :A74 , :A75 , :A76 , :A77 , :A78 , :A79 , :A80 , :A81 , :A82 , :A83 , :A84 , :A85 , :A86 , :A87 , :A88 , :A89 , :A90 , :A91 , :A92 , :A93 , :A94 , :A95 , :A96 , :A97 , :A98 , :A99 , :A100 , :A101 , :A102 , :A103 , :A104 , :A105 , :A106 , :A107 , :A108 , :A109 , :A110 , :A111 , :A112 , :A113 , :A114 , :A115 , :A116 , :A117 , :A118 , :A119 , :A120 , :A121 , :A122 , :A123 , :A124 , :A 125 , :A126 , :A127 , :A128 , :A129 , :A130 , :A131 , :A132 , :A133 , :A134 , :A135 , :A136 , :A137 , :A138 , :A139 , :A140 , :A141 , :A142 , :A143 , :A144 , :A145 , :A146 , :A147 , :A148 , :A149 , :A150 , :A151 , :A152 , :A153 , :A154 , :A155 , :A156 , :A157 , :A158 , :A159 , :A160 , :A161 , :A162 , :A163 , :A164 , :A165 , :A166 , :A167 , :A168 , :A169 , :A170 , :A171 , :A172 , :A173 , :A174 , :A175 , :A176 , :A177 , :A178 , :A179 , :A1 80 , :A181 , :A182 , :A183 , :A184 , :A185 , :A186 , :A187
RE: need help with execute immediate from a script
Your "using v_var1,v_var2" shouldn't be appended to the string that represents the dynamic SQL to execute; the "using..." is part of the syntac for execute immediate. An Oracle error message being what they are, they don't always highlight the correct cause of fault, but will identify some other error located close to where the real fault lies. For your solution, remove the "||" that occurs after ":2" It is also unlikely that you can select "*" into TOTAL, which has been declared as a NUMBER. Consider "count(*)" perhaps? -Original Message- Sent: Monday, July 21, 2003 4:59 PM To: Multiple recipients of list ORACLE-L Im calling a script that uses dynamic sql. Im passing in a value as well. I keep getting SP2-0552: Bind variable "2" not declared. Here is a code snipped declare v_var1 Varchar2(30) := 'TEST'; v_var2 VARCHAR2(30) := '&1'; total number; begin execute immediate ' Select * ' || ' from user_objects '|| ' where object_name = :1 '|| ' or object_name = :2 '|| using v_var1,v_var2 into total; end; / I call it as follows: @script HELLO -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: <[EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rudy Zung INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: HP-UX 11i/9.2.0.3/Strange Executions
Title: RE: HP-UX 11i/9.2.0.3/Strange Executions Most likely some thing to do with OS library. contact OWS. Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message- From: Vergara, Michael (TEM) [mailto:[EMAIL PROTECTED]] Sent: Monday, July 21, 2003 5:05 PM To: Multiple recipients of list ORACLE-L Subject: HP-UX 11i/9.2.0.3/Strange Executions Hi Everyone! HELP! I upgraded my SAP *PRODUCTION* instance to 9.2.0.3 over the weekend. Everything up until now has been OK. However, I now have some SAP Transactions (read: data entry forms) that are abending unexpectedly. What's strange is that when we run the transaction on our Stage server the explain plan is different, and the query succeeds. In PRD, the query is a single-step, and in stage it gets broken out into sub-queries and executed there. I created a report of all the database parameters. There is no difference that cannot be explained by the difference in CPUs, database name, or application paths. They are fundamentally identical. But the query aborts on PRD. I am attaching the top few lines of a typical trace file. ANY help, RTFM references, suggestions, incantations, incense, or holy water will be appreciated. Thanks, Mike *** 2003-07-21 14:52:06.921 *** SESSION ID:(326.5957) 2003-07-21 14:52:06.886 Exception signal: 11 (SIGSEGV), code: 0 (unknown code), addr: 0x80016ede9f30, PC: [0x41331c0c, kghfrmrg()+596] Registers: r1: 8001d9e8 r22: 6e6178d8 sr4: 7df0c00 rp: 0 arg3: 80016ede9f28 sr0: 67c9c00 r3: 413319b8 arg2: c0006e615fa0 sr1: d7db000 r4: 0 arg1: 6e615fa0 sr2: 0 r5: 0 arg0: c0b38f001131 sr3: 0 r6: 7ffc dp: 8001000ca608 sr5: 693 r7: 0 ret0: 0 sr6: a814c00 r8: 8001007d3798 ret1: 800 sr7: 67c9c00 r9: 8001007d3780 sp: 83ffbfff6880 cr0: 0 r10: 0 r31: 6 cr8: 77f6368 r11: 0 sar: 38 cr9: 77f6378 r12: 0 pcoqh: 41331c0f ccr: 0 r13: 1 pcsqh: 693 cr12: 494c008 r14: 83ffbfff48c0 pcoqt: 41331a93 cr13: 4a2b008 r15: 83ffbfff48c8 pcsqt: 693 cr24: 4a2c808 r16: 403f85d0 eiem: cr25: 4a2a808 r17: af0 iir: 72f50010 cr26: 4a2c808 r18: 0 isr: a814c00 mpsfu_hi: 8001000e36c8 r19: 8001d9e8 ior: 80016ede9f30 mpsfu_lo: 0 r20: 0 ipsw: ff080cff1f mpsfu_ov: 41 r21: 8001007d2650 goto: 97f68 pad: 0 *** 2003-07-21 14:52:07.811 ksedmp: internal or fatal error ORA-07445: exception encountered: core dump [kghfrmrg()+596] [SIGSEGV] [unknown code] [0x80016EDE9F30] [] [] Current SQL statement for this session: SELECT T_00 . "MATNR" , T_00 . "PRDHA" , T_01 . "MAKTX" FROM "MARA" T_00 , "MAKT" T_01 WHERE ( T_01 . "MANDT" = :A0 AND T_01 . "MATNR" = T_00 . "MA TNR" ) AND T_00 . "MANDT" = :A1 AND ( ( T_00 . "MATNR" BETWEEN :A2 AND :A3 OR T_00 . "MATNR" BETWEEN :A4 AND :A5 OR T_00 . "MATNR" BETWEEN :A6 AND :A7 OR T_00 . "MATNR" BETWEEN :A8 AND :A9 OR T_00 . "MATNR" BETWEEN :A10 AND :A11 OR T_00 . "MATNR" BETWEEN :A12 AND :A13 OR T_00 . "MATNR" BETWEEN :A14 AND :A15 OR T_00 . "MATNR" BETWEEN :A16 AND :A17 OR T_00 . "MATNR" BETWEEN :A18 AND :A19 ) OR T_00 . "MATNR" IN ( :A20 , :A21 , :A22 , :A23 , :A24 , :A25 , :A26 , :A27 , :A28 , :A29 , :A30 , :A31 , :A32 , :A33 , :A34 , :A35 , :A36 , :A37 , :A38 , :A39 , :A40 , :A41 , :A42 , :A43 , :A44 , :A45 , :A46 , :A47 , :A48 , :A49 , :A50 , :A51 , :A52 , :A53 , :A54 , :A55 , :A56 , :A57 , :A58 , :A59 , :A60 , :A61 , :A62 , :A63 , :A64 , :A65 , :A66 , :A67 , :A68 , :A69 , :A70 , :A71 , :A72 , :A73 , :A74 , :A75 , :A76 , :A77 , :A78 , :A79 , :A80 , :A81 , :A82 , :A83 , :A84 , :A85 , :A86 , :A87 , :A88 , :A89 , :A90 , :A91 , :A92 , :A93 , :A94 , :A95 , :A96 , :A97 , :A98 , :A99 , :A100 , :A101 , :A102 , :A103 , :A104 , :A105 , :A106 , :A107 , :A108 , :A109 , :A110 , :A111 , :A112 , :A113 , :A114 , :A115 , :A116 , :A117 , :A118 , :A119 , :A120 , :A121 , :A122 , :A123 , :A124 , :A 125 , :A126 , :A127 , :A128 , :A129 , :A130 , :A131 , :A132 , :A133 , :A134 , :A135 , :A136 , :A137 , :A138 , :A139 , :A140 ,
9i Grid "voodoo" cookbook
(Yeah Tom Mercadante...I agree) I remember a time when Microsoft was spouting Windows clustering and how great it was. People started with two boxes then kept adding until the whole mess fell apart. People and companies whet bust promoting cluster solutions. Rather than sizing a box appropriately and purchasing the hardware sized to handle five years of growth now we are looking at a cluster scenario again. Adding boxes as we go. Just how easy is that? What about future security issues? Patches...etc... Frankly I find it hard to believe that anyone is going to save any money with blades and 9i RAC right now. Once again the hardware people have found that giving people less for the same cost is better (for them). Seems like the burden of testing and proving these cluster solutions is going to fall on us (IS). I mean really! Who would set this solution up and roll it into production in a weekend?? I sure wouldn't expect that. I would expect to have to create a test lab, buy test hardware and prove that it actually works. Seems expensive to me. Somebody honestly tell me they would have no problem converting a 8 way HP-UX box to four dual blades and 9i RAC in a weekend. Different packaging is all we have here. RAC is like a "lunchable". Less product, more expensive, more marketing promises and leaves a bad taste in my mouth. Don't get me wrong I think the idea sounds cool. It's just that we've all heard of cool stuff turning into a hot steaming pile real fast... IT budgets are stretched pretty thin. Buying unproven technology is not a very wise choice right now unless you have a lot of disposable cash for in house testing. Why should IT have to prove this works? Brad O. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Odland, Brad INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 configuration on SAN
Yeah, write-back cache is better than write-through for performance. Mirrored cache is nice too, except that some implementations (and I have zero idea whether this applies to HP or IBM) used to do silly things like dispatch mirrored writes in serial rather than in parallel, and don't load-balance reads on mirrored objects. On the FastT900, are you sure the battery backup actually destages to disk upon power failure? If I remember correctly, the FastT line deals with power failure the same way most mid-range storage arrays do - the system loses power and a battery supplies power to the cache to keep it persistent. When the array is brought back online, before servicing any new I/O, the cache is destaged to the disk. The only problem with that is extended power failures or hardware problems can create data loss (though generally you can move the cache from the failed box to the new box without losing data). The other possible way they do it is the same way the Clariion does it, which is the first drive shelf has a glorified UPS attached to it, and when power goes, the cache is destaged to a "vault" drive, which is then spun down. Bigger arrays, like the HDS 9900 series, the Symmetrix, and the Shark all have big honking batteries in them (and I mean big - over a hundred pounds as I recall). When power is lost, they gracefully destage all cache to disk, carefully park the drive heads, spin the drives down, and then shut down. Much nicer than power suddenly being cut to drives spinning at 10 or 15 thousand rpms. Matt -- Matthew Zito GridApp Systems Email: [EMAIL PROTECTED] Cell: 646-220-3551 Phone: 212-358-8211 x 359 http://www.gridapp.com > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On > Behalf Of Jesse, Rich > Sent: Monday, July 21, 2003 3:49 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: Oracle configuration on SAN > > > In the same cache vein, make sure you know what type of > caching is being done at each LUN (or how ever the HP's > setup). Write-thru caching won't help your write speed at > all, while write-back will. The trade off is that since > write-back acknowledges the write from the cache (write-thru > won't acknowledge the write until it physically hits the much > slower disk), there is a small chance that it may not be > flushed to disk in the event of failure (e.g. power). > > I don't know about HP's offering, but the FastT900 from IBM > allows you to mirror your cache, plus they have a battery > backup for them to flush the cache to disk in the case of > power failure. So, for us, I imagine we'll head for the > mirrored write-back cache option w/BBU. I think it's an > acceptable risk for the gains for our particular situation. > > Rich > > Rich Jesse System/Database Administrator > [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA > > > -Original Message- > > From: Matthew Zito [mailto:[EMAIL PROTECTED] > > Sent: Monday, July 21, 2003 3:04 PM > > To: Multiple recipients of list ORACLE-L > > Subject: RE: Oracle configuration on SAN > > > > > > > > A 14-drive RAID-5 set is very large. It's certainly > > functional, but the > > two problems you'll run into is problems with spindle contention and > > rebuild times. With a 14-drive set, your drive is getting > cut into 14 > > columns, so that there's 14 different disk regions per > drive it might > > have to seek to in order to service any given I/O. That can > > negatively > > impact performance on random writes. Have you tested failing > > out a drive > > under load? On a 14-drive set the rebuild time is going to > be pretty > > horrendous, and your performance will likely be impacted unless your > > cache hit numbers are really great. > > > > The other problem is that by carving luns globally out of a single > > RAID-5 set, differing i/o patterns on the luns can create hot spots > > much more easily, since your small (comparatively, anyway) redo log > > volume (for exmaple) ends up on only four columns of the disks, and > > other volumes on other columns on those disks can be hurt by the > > constant writing. > > > > While I'm not necessarily as anti-RAID 5 as some (though I > > give all due > > respect and worship to our mighty BAARF leaders), you need to keep a > > very close eye on your array in this configuration. If you have a > > normal OLTP workload (whatever "normal" is), play with your cache > > allocations - the read v. write cache, and if you can do per-lun > > tweaking, weight the redo and archive log lun(s) very > heavily towards > > write cache. > > > > If you're set on RAID-5, I would recommend taking two of > the disks and > > making them a mirrored pair for redo and archive logs. Since the > > writes tend to be reasonably contiguous, the fact you're > hitting just > > one set of spindles shouldn't hurt quite as bad, and cache should > > take the edge > > off a bit.
RE: HP-UX 11i/9.2.0.3/Strange Executions
He needs to contact oracle support, because the dump came from the oracle server process. If he's lucky, the one-off patch is already published and he only needs to download it from Metalink and apply it. If not, then he has to wait for oracle 9BF (BF = Bug Free) Mladen Gogala Oracle DBA Phone:(203) 459-6855 Email:[EMAIL PROTECTED] -Original Message- Sent: Monday, July 21, 2003 5:20 PM To: Multiple recipients of list ORACLE-L SIGSEGV = Segment Violation = invalid address = bad code Sounds like you need to contact SAP and/or Oracle support. Jared "Vergara, Michael (TEM)" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 07/21/2003 02:04 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:HP-UX 11i/9.2.0.3/Strange Executions Hi Everyone! HELP! I upgraded my SAP *PRODUCTION* instance to 9.2.0.3 over the weekend. Everything up until now has been OK. However, I now have some SAP Transactions (read: data entry forms) that are abending unexpectedly. What's strange is that when we run the transaction on our Stage server the explain plan is different, and the query succeeds. In PRD, the query is a single-step, and in stage it gets broken out into sub-queries and executed there. I created a report of all the database parameters. There is no difference that cannot be explained by the difference in CPUs, database name, or application paths. They are fundamentally identical. But the query aborts on PRD. I am attaching the top few lines of a typical trace file. ANY help, RTFM references, suggestions, incantations, incense, or holy water will be appreciated. Thanks, Mike *** 2003-07-21 14:52:06.921 *** SESSION ID:(326.5957) 2003-07-21 14:52:06.886 Exception signal: 11 (SIGSEGV), code: 0 (unknown code), addr: 0x80016ede9f30, PC: [0x41331c0c, kghfrmrg()+596] Registers: r1: 8001d9e8 r22: 6e6178d8 sr4: 7df0c00 rp:0 arg3: 80016ede9f28 sr0: 67c9c00 r3: 413319b8 arg2: c0006e615fa0 sr1: d7db000 r4:0 arg1: 6e615fa0 sr2: 0 r5:0 arg0: c0b38f001131 sr3: 0 r6: 7ffcdp: 8001000ca608 sr5: 693 r7:0 ret0:0 sr6: a814c00 r8: 8001007d3798 ret1: 800 sr7: 67c9c00 r9: 8001007d3780sp: 83ffbfff6880 cr0: 0 r10:0 r31:6 cr8: 77f6368 r11:0 sar: 38 cr9: 77f6378 r12:0 pcoqh: 41331c0f ccr: 0 r13:1 pcsqh: 693 cr12: 494c008 r14: 83ffbfff48c0 pcoqt: 41331a93 cr13: 4a2b008 r15: 83ffbfff48c8 pcsqt: 693 cr24: 4a2c808 r16: 403f85d0 eiem: cr25: 4a2a808 r17: af0 iir: 72f50010 cr26: 4a2c808 r18:0 isr: a814c00 mpsfu_hi: 8001000e36c8 r19: 8001d9e8 ior: 80016ede9f30 mpsfu_lo: 0 r20:0 ipsw: ff080cff1f mpsfu_ov: 41 r21: 8001007d2650 goto:97f68 pad: 0 *** 2003-07-21 14:52:07.811 ksedmp: internal or fatal error ORA-07445: exception encountered: core dump [kghfrmrg()+596] [SIGSEGV] [unknown code] [0x80016EDE9F30] [] [] Current SQL statement for this session: SELECT T_00 . "MATNR" , T_00 . "PRDHA" , T_01 . "MAKTX" FROM "MARA" T_00 , "MAKT" T_01 WHERE ( T_01 . "MANDT" = :A0 AND T_01 . "MATNR" = T_00 . "MA TNR" ) AND T_00 . "MANDT" = :A1 AND ( ( T_00 . "MATNR" BETWEEN :A2 AND :A3 OR T_00 . "MATNR" BETWEEN :A4 AND :A5 OR T_00 . "MATNR" BETWEEN :A6 AND :A7 OR T_00 . "MATNR" BETWEEN :A8 AND :A9 OR T_00 . "MATNR" BETWEEN :A10 AND :A11 OR T_00 . "MATNR" BETWEEN :A12 AND :A13 OR T_00 . "MATNR" BETWEEN :A14 AND :A15 OR T_00 . "MATNR" BETWEEN :A16 AND :A17 OR T_00 . "MATNR" BETWEEN :A18 AND :A19 ) OR T_00 . "MATNR" IN ( :A20 , :A21 , :A22 , :A23 , :A24 , :A25 , :A26 , :A27 , :A28 , :A29 , :A30 , :A31 , :A32 , :A33 , :A34 , :A35 , :A36 , :A37 , :A38 , :A39 , :A40 , :A41 , :A42 , :A43 , :A44 , :A45 , :A46 , :A47 , :A48 , :A49 , :A50 , :A51 , :A52 , :A53 , :A54 , :A55 , :A56 , :A57 , :A58 , :A59 , :A60 , :A61 , :A62 , :A63 , :A64 , :A65 , :A66 , :A67 , :A68 , :A69 , :A70 , :A71 , :A72 , :A73 , :A74 , :A75 , :A76 , :A77 , :A78 , :A79 , :A80 , :A81 , :A82 , :A83 , :A84 , :A85 , :A86 , :A87 , :A88 , :A89 , :A90 , :A91 , :A92 , :A93 , :A94 , :A95 , :A96 , :A97 , :A98 , :A99 , :A100 , :A101 , :A102 , :A103 , :A104 , :A105 , :A106 , :A107 , :A108 , :A109 , :A110 , :A111 , :A112 , :A113 , :A114 , :A115 , :A116 , :A117 , :A118 , :A119 , :A120 , :A121 , :A122 , :A123 , :A124 , :A 125 , :A126 , :A127 , :A128 , :A129 , :A130 , :A131 , :A132 ,
Re: need help with execute immediate from a script
that was just a mock up of what I wrote. I dont have '||' in the real version. Its jut a typo here. Anyone know what is going on? - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Monday, July 21, 2003 5:24 PM > Your "using v_var1,v_var2" shouldn't be appended to the > string that represents the dynamic SQL to execute; > the "using..." is part of the syntac for execute immediate. > An Oracle error message being what they are, they don't > always highlight the correct cause of fault, but will > identify some other error located close to where the real > fault lies. > > For your solution, remove the "||" that occurs after > ":2" > > It is also unlikely that you can select "*" into > TOTAL, which has been declared as a NUMBER. Consider > "count(*)" perhaps? > > -Original Message- > Sent: Monday, July 21, 2003 4:59 PM > To: Multiple recipients of list ORACLE-L > > > Im calling a script that uses dynamic sql. Im passing in a value as well. I > keep getting > > SP2-0552: Bind variable "2" not declared. > > Here is a code snipped > > declare > v_var1 Varchar2(30) := 'TEST'; > v_var2 VARCHAR2(30) := '&1'; > total number; > begin > > execute immediate ' Select * ' || > ' from user_objects '|| > ' where object_name = :1 '|| > ' or object_name = :2 '|| > using v_var1,v_var2 > into total; > > end; > / > > I call it as follows: > > @script HELLO > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: <[EMAIL PROTECTED] > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Rudy Zung > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ryan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: RAC
Title: Message You must of taken the Oracle Advanced Comeback and Retort class Brad O. -Original Message-From: Matthew Zito [mailto:[EMAIL PROTECTED]Sent: Monday, July 21, 2003 4:19 PMTo: Multiple recipients of list ORACLE-LSubject: RE: RAC No, its definitely possible to do it with one - I know we've done it in the lab. It wasn't me hands-on-the-keyboard doing the work, but as it was explained to me, you basically trick the sole node into thinking that it used to have a friend, and that friend had died in a horrible horrible accident and that it should boldly carry on for the both of them. Matt --Matthew ZitoGridApp SystemsEmail: [EMAIL PROTECTED]Cell: 646-220-3551Phone: 212-358-8211 x 359http://www.gridapp.com -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Goulet, DickSent: Monday, July 21, 2003 4:04 PMTo: Multiple recipients of list ORACLE-LSubject: RE: RAC You need at least 2 servers. Dick GouletSenior Oracle DBAOracle Certified 8i DBA -Original Message-From: AK [mailto:[EMAIL PROTECTED]Sent: Monday, July 21, 2003 2:49 PMTo: Multiple recipients of list ORACLE-LSubject: RAC Is it possible to setup RAC in one box only. Just to play with it . Dont have more hardware . -ak
RE: HP-UX 11i/9.2.0.3/Strange Executions
Is or are ALL of the SAP form identical on both servers? It could be the SAP is different on the servers and be the cause of the problem. Ron >>> [EMAIL PROTECTED] 07/21/03 05:34PM >>> He needs to contact oracle support, because the dump came from the oracle server process. If he's lucky, the one-off patch is already published and he only needs to download it from Metalink and apply it. If not, then he has to wait for oracle 9BF (BF = Bug Free) Mladen Gogala Oracle DBA Phone:(203) 459-6855 Email:[EMAIL PROTECTED] -Original Message- Sent: Monday, July 21, 2003 5:20 PM To: Multiple recipients of list ORACLE-L SIGSEGV = Segment Violation = invalid address = bad code Sounds like you need to contact SAP and/or Oracle support. Jared "Vergara, Michael (TEM)" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 07/21/2003 02:04 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:HP-UX 11i/9.2.0.3/Strange Executions Hi Everyone! HELP! I upgraded my SAP *PRODUCTION* instance to 9.2.0.3 over the weekend. Everything up until now has been OK. However, I now have some SAP Transactions (read: data entry forms) that are abending unexpectedly. What's strange is that when we run the transaction on our Stage server the explain plan is different, and the query succeeds. In PRD, the query is a single-step, and in stage it gets broken out into sub-queries and executed there. I created a report of all the database parameters. There is no difference that cannot be explained by the difference in CPUs, database name, or application paths. They are fundamentally identical. But the query aborts on PRD. I am attaching the top few lines of a typical trace file. ANY help, RTFM references, suggestions, incantations, incense, or holy water will be appreciated. Thanks, Mike *** 2003-07-21 14:52:06.921 *** SESSION ID:(326.5957) 2003-07-21 14:52:06.886 Exception signal: 11 (SIGSEGV), code: 0 (unknown code), addr: 0x80016ede9f30, PC: [0x41331c0c, kghfrmrg()+596] Registers: r1: 8001d9e8 r22: 6e6178d8 sr4: 7df0c00 rp:0 arg3: 80016ede9f28 sr0: 67c9c00 r3: 413319b8 arg2: c0006e615fa0 sr1: d7db000 r4:0 arg1: 6e615fa0 sr2: 0 r5:0 arg0: c0b38f001131 sr3: 0 r6: 7ffcdp: 8001000ca608 sr5: 693 r7:0 ret0:0 sr6: a814c00 r8: 8001007d3798 ret1: 800 sr7: 67c9c00 r9: 8001007d3780sp: 83ffbfff6880 cr0: 0 r10:0 r31:6 cr8: 77f6368 r11:0 sar: 38 cr9: 77f6378 r12:0 pcoqh: 41331c0f ccr: 0 r13:1 pcsqh: 693 cr12: 494c008 r14: 83ffbfff48c0 pcoqt: 41331a93 cr13: 4a2b008 r15: 83ffbfff48c8 pcsqt: 693 cr24: 4a2c808 r16: 403f85d0 eiem: cr25: 4a2a808 r17: af0 iir: 72f50010 cr26: 4a2c808 r18:0 isr: a814c00 mpsfu_hi: 8001000e36c8 r19: 8001d9e8 ior: 80016ede9f30 mpsfu_lo: 0 r20:0 ipsw: ff080cff1f mpsfu_ov: 41 r21: 8001007d2650 goto:97f68 pad: 0 *** 2003-07-21 14:52:07.811 ksedmp: internal or fatal error ORA-07445: exception encountered: core dump [kghfrmrg()+596] [SIGSEGV] [unknown code] [0x80016EDE9F30] [] [] Current SQL statement for this session: SELECT T_00 . "MATNR" , T_00 . "PRDHA" , T_01 . "MAKTX" FROM "MARA" T_00 , "MAKT" T_01 WHERE ( T_01 . "MANDT" = :A0 AND T_01 . "MATNR" = T_00 . "MA TNR" ) AND T_00 . "MANDT" = :A1 AND ( ( T_00 . "MATNR" BETWEEN :A2 AND :A3 OR T_00 . "MATNR" BETWEEN :A4 AND :A5 OR T_00 . "MATNR" BETWEEN :A6 AND :A7 OR T_00 . "MATNR" BETWEEN :A8 AND :A9 OR T_00 . "MATNR" BETWEEN :A10 AND :A11 OR T_00 . "MATNR" BETWEEN :A12 AND :A13 OR T_00 . "MATNR" BETWEEN :A14 AND :A15 OR T_00 . "MATNR" BETWEEN :A16 AND :A17 OR T_00 . "MATNR" BETWEEN :A18 AND :A19 ) OR T_00 . "MATNR" IN ( :A20 , :A21 , :A22 , :A23 , :A24 , :A25 , :A26 , :A27 , :A28 , :A29 , :A30 , :A31 , :A32 , :A33 , :A34 , :A35 , :A36 , :A37 , :A38 , :A39 , :A40 , :A41 , :A42 , :A43 , :A44 , :A45 , :A46 , :A47 , :A48 , :A49 , :A50 , :A51 , :A52 , :A53 , :A54 , :A55 , :A56 , :A57 , :A58 , :A59 , :A60 , :A61 , :A62 , :A63 , :A64 , :A65 , :A66 , :A67 , :A68 , :A69 , :A70 , :A71 , :A72 , :A73 , :A74 , :A75 , :A76 , :A77 , :A78 , :A79 , :A80 , :A81 , :A82 , :A83 , :A84 , :A85 , :A86 , :A87 , :A88 , :A89 , :A90 , :A91 , :A92 , :A93 , :A94 , :A95 , :A96 , :A97 , :A98 , :A99 , :A100 , :A101 , :A102 , :A103 , :A104 , :A105 , :A106 , :A107 , :A108 , :A109
RE: 9i Grid "voodoo" cookbook
Microsoft is the world's largest provider of cluster f... solutions for the IT. Their OS has spawned $3G industry which has the sole purpose of trying to secure it. It is about time that they got some competition. Mladen Gogala Oracle DBA Phone:(203) 459-6855 Email:[EMAIL PROTECTED] -Original Message- Sent: Monday, July 21, 2003 5:25 PM To: Multiple recipients of list ORACLE-L (Yeah Tom Mercadante...I agree) I remember a time when Microsoft was spouting Windows clustering and how great it was. People started with two boxes then kept adding until the whole mess fell apart. People and companies whet bust promoting cluster solutions. Rather than sizing a box appropriately and purchasing the hardware sized to handle five years of growth now we are looking at a cluster scenario again. Adding boxes as we go. Just how easy is that? What about future security issues? Patches...etc... Frankly I find it hard to believe that anyone is going to save any money with blades and 9i RAC right now. Once again the hardware people have found that giving people less for the same cost is better (for them). Seems like the burden of testing and proving these cluster solutions is going to fall on us (IS). I mean really! Who would set this solution up and roll it into production in a weekend?? I sure wouldn't expect that. I would expect to have to create a test lab, buy test hardware and prove that it actually works. Seems expensive to me. Somebody honestly tell me they would have no problem converting a 8 way HP-UX box to four dual blades and 9i RAC in a weekend. Different packaging is all we have here. RAC is like a "lunchable". Less product, more expensive, more marketing promises and leaves a bad taste in my mouth. Don't get me wrong I think the idea sounds cool. It's just that we've all heard of cool stuff turning into a hot steaming pile real fast... IT budgets are stretched pretty thin. Buying unproven technology is not a very wise choice right now unless you have a lot of disposable cash for in house testing. Why should IT have to prove this works? Brad O. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Odland, Brad INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Fast!
Bruce, Regrettably I can't tell. There's a spam blocker that filters out messages where the person being sent to is the same as the person sending. So I don't see how fast the posts arrive. But on the plus side the inbox is filling up faster. Now if I could just find someone who knew anything about this SmartTime time accounting system? Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Monday, July 21, 2003 4:39 PM To: Multiple recipients of list ORACLE-L I've noticed! Good job Bruce! Tom Mercadante Oracle Certified Professional -Original Message- Sent: Monday, July 21, 2003 4:29 PM To: Multiple recipients of list ORACLE-L FYI Hi Jared -- Yeah, I've been finally working on getting us closer to real-time speed. I put in the first of the changes about two weeks ago, but you probably didn't notice them until last weekend, when some significant changes were made. I've still got some more work to do, but it's headed the right direction, and I'm glad someone noticed. Actually, to date, you're the ONLY one who noticed. ;-) thanks, bruce - Original Message - To: <[EMAIL PROTECTED]> Sent: Thursday, July 17, 2003 14:18 > Bruce, > > Anything new at your end? > > My posts are showing up in about 2 minutes, which is most unusual. > > Jared > > > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Goulet, Dick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: RAC
Title: Message try with cluster_database=true ... Oracle will immediately start all the GC traffic... Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message-From: Odland, Brad [mailto:[EMAIL PROTECTED]Sent: Monday, July 21, 2003 5:39 PMTo: Multiple recipients of list ORACLE-LSubject: RE: RAC You must of taken the Oracle Advanced Comeback and Retort class Brad O. -Original Message-From: Matthew Zito [mailto:[EMAIL PROTECTED]Sent: Monday, July 21, 2003 4:19 PMTo: Multiple recipients of list ORACLE-LSubject: RE: RAC No, its definitely possible to do it with one - I know we've done it in the lab. It wasn't me hands-on-the-keyboard doing the work, but as it was explained to me, you basically trick the sole node into thinking that it used to have a friend, and that friend had died in a horrible horrible accident and that it should boldly carry on for the both of them. Matt --Matthew ZitoGridApp SystemsEmail: [EMAIL PROTECTED]Cell: 646-220-3551Phone: 212-358-8211 x 359http://www.gridapp.com -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Goulet, DickSent: Monday, July 21, 2003 4:04 PMTo: Multiple recipients of list ORACLE-LSubject: RE: RAC You need at least 2 servers. Dick GouletSenior Oracle DBAOracle Certified 8i DBA -Original Message-From: AK [mailto:[EMAIL PROTECTED]Sent: Monday, July 21, 2003 2:49 PMTo: Multiple recipients of list ORACLE-LSubject: RAC Is it possible to setup RAC in one box only. Just to play with it . Dont have more hardware . -ak *This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.*1
RE: HP-UX 11i/9.2.0.3/Strange Executions
Jared: I am in contact with SAP support, but they're scratching their collective heads, too. I was hoping that maybe a SAP-savvy lister would be able to say "We had that...here's the fix". What's strange is that the report runs to completion on our Stage server. Thanks, Mike -Original Message- Sent: Monday, July 21, 2003 1:21 PM To: [EMAIL PROTECTED] Cc: Vergara, Michael (TEM) Importance: High SIGSEGV = Segment Violation = invalid address = bad code Sounds like you need to contact SAP and/or Oracle support. Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Vergara, Michael (TEM) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: HP-UX 11i/9.2.0.3/Strange Executions
Title: RE: HP-UX 11i/9.2.0.3/Strange Executions Raj: Is OWS 'Oracle Worldwide Support'? Our Oracle support comes directly from SAP, and they're on the case, but are as flummoxed as I am. Right now they're trying to convince me that the problem is in the NLS parameters. However, these values are identical on both machines, and the report *works* on Stage. Thanks, Mike -Original Message-From: Jamadagni, Rajendra [mailto:[EMAIL PROTECTED]Sent: Monday, July 21, 2003 2:25 PMTo: Multiple recipients of list ORACLE-LSubject: RE: HP-UX 11i/9.2.0.3/Strange Executions Most likely some thing to do with OS library. contact OWS. Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message- From: Vergara, Michael (TEM) [mailto:[EMAIL PROTECTED]] Sent: Monday, July 21, 2003 5:05 PM To: Multiple recipients of list ORACLE-L Subject: HP-UX 11i/9.2.0.3/Strange Executions
RE: HP-UX 11i/9.2.0.3/Strange Executions
Oh no! I have to wait for 9iBF? I'll be retired by then, and I'm only ... well ... never mind how old I am. I don't wanna wait that long. Cheers, Mike -Original Message- Sent: Monday, July 21, 2003 2:35 PM To: Multiple recipients of list ORACLE-L He needs to contact oracle support, because the dump came from the oracle server process. If he's lucky, the one-off patch is already published and he only needs to download it from Metalink and apply it. If not, then he has to wait for oracle 9BF (BF = Bug Free) Mladen Gogala Oracle DBA Phone:(203) 459-6855 Email:[EMAIL PROTECTED] -Original Message- Sent: Monday, July 21, 2003 5:20 PM To: Multiple recipients of list ORACLE-L SIGSEGV = Segment Violation = invalid address = bad code Sounds like you need to contact SAP and/or Oracle support. Jared "Vergara, Michael (TEM)" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 07/21/2003 02:04 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:HP-UX 11i/9.2.0.3/Strange Executions Hi Everyone! HELP! I upgraded my SAP *PRODUCTION* instance to 9.2.0.3 over the weekend. Everything up until now has been OK. However, I now have some SAP Transactions (read: data entry forms) that are abending unexpectedly. What's strange is that when we run the transaction on our Stage server the explain plan is different, and the query succeeds. In PRD, the query is a single-step, and in stage it gets broken out into sub-queries and executed there. I created a report of all the database parameters. There is no difference that cannot be explained by the difference in CPUs, database name, or application paths. They are fundamentally identical. But the query aborts on PRD. I am attaching the top few lines of a typical trace file. ANY help, RTFM references, suggestions, incantations, incense, or holy water will be appreciated. Thanks, Mike *** 2003-07-21 14:52:06.921 *** SESSION ID:(326.5957) 2003-07-21 14:52:06.886 Exception signal: 11 (SIGSEGV), code: 0 (unknown code), addr: 0x80016ede9f30, PC: [0x41331c0c, kghfrmrg()+596] Registers: r1: 8001d9e8 r22: 6e6178d8 sr4: 7df0c00 rp:0 arg3: 80016ede9f28 sr0: 67c9c00 r3: 413319b8 arg2: c0006e615fa0 sr1: d7db000 r4:0 arg1: 6e615fa0 sr2: 0 r5:0 arg0: c0b38f001131 sr3: 0 r6: 7ffcdp: 8001000ca608 sr5: 693 r7:0 ret0:0 sr6: a814c00 r8: 8001007d3798 ret1: 800 sr7: 67c9c00 r9: 8001007d3780sp: 83ffbfff6880 cr0: 0 r10:0 r31:6 cr8: 77f6368 r11:0 sar: 38 cr9: 77f6378 r12:0 pcoqh: 41331c0f ccr: 0 r13:1 pcsqh: 693 cr12: 494c008 r14: 83ffbfff48c0 pcoqt: 41331a93 cr13: 4a2b008 r15: 83ffbfff48c8 pcsqt: 693 cr24: 4a2c808 r16: 403f85d0 eiem: cr25: 4a2a808 r17: af0 iir: 72f50010 cr26: 4a2c808 r18:0 isr: a814c00 mpsfu_hi: 8001000e36c8 r19: 8001d9e8 ior: 80016ede9f30 mpsfu_lo: 0 r20:0 ipsw: ff080cff1f mpsfu_ov: 41 r21: 8001007d2650 goto:97f68 pad: 0 *** 2003-07-21 14:52:07.811 ksedmp: internal or fatal error ORA-07445: exception encountered: core dump [kghfrmrg()+596] [SIGSEGV] [unknown code] [0x80016EDE9F30] [] [] Current SQL statement for this session: SELECT T_00 . "MATNR" , T_00 . "PRDHA" , T_01 . "MAKTX" FROM "MARA" T_00 , "MAKT" T_01 WHERE ( T_01 . "MANDT" = :A0 AND T_01 . "MATNR" = T_00 . "MA TNR" ) AND T_00 . "MANDT" = :A1 AND ( ( T_00 . "MATNR" BETWEEN :A2 AND :A3 OR T_00 . "MATNR" BETWEEN :A4 AND :A5 OR T_00 . "MATNR" BETWEEN :A6 AND :A7 OR T_00 . "MATNR" BETWEEN :A8 AND :A9 OR T_00 . "MATNR" BETWEEN :A10 AND :A11 OR T_00 . "MATNR" BETWEEN :A12 AND :A13 OR T_00 . "MATNR" BETWEEN :A14 AND :A15 OR T_00 . "MATNR" BETWEEN :A16 AND :A17 OR T_00 . "MATNR" BETWEEN :A18 AND :A19 ) OR T_00 . "MATNR" IN ( :A20 , :A21 , :A22 , :A23 , :A24 , :A25 , :A26 , :A27 , :A28 , :A29 , :A30 , :A31 , :A32 , :A33 , :A34 , :A35 , :A36 , :A37 , :A38 , :A39 , :A40 , :A41 , :A42 , :A43 , :A44 , :A45 , :A46 , :A47 , :A48 , :A49 , :A50 , :A51 , :A52 , :A53 , :A54 , :A55 , :A56 , :A57 , :A58 , :A59 , :A60 , :A61 , :A62 , :A63 , :A64 , :A65 , :A66 , :A67 , :A68 , :A69 , :A70 , :A71 , :A72 , :A73 , :A74 , :A75 , :A76 , :A77 , :A78 , :A79 , :A80 , :A81 , :A82 , :A83 , :A84 , :A85 , :A86 , :A87 , :A88 , :A89 , :A90 , :A91 , :A92 , :A93 , :A94 , :A95 , :A96 , :A97 , :A98 , :A99 , :A100
RE: HP-UX 11i/9.2.0.3/Strange Executions
Ron: According to the ABAP programmers, the code 'variant' is identical. The generated SQL 'looks' the same, but the execution plans are radically different. Thanks, Mike -Original Message- Sent: Monday, July 21, 2003 2:44 PM To: Multiple recipients of list ORACLE-L Is or are ALL of the SAP form identical on both servers? It could be the SAP is different on the servers and be the cause of the problem. Ron >>> [EMAIL PROTECTED] 07/21/03 05:34PM >>> He needs to contact oracle support, because the dump came from the oracle server process. If he's lucky, the one-off patch is already published and he only needs to download it from Metalink and apply it. If not, then he has to wait for oracle 9BF (BF = Bug Free) Mladen Gogala Oracle DBA Phone:(203) 459-6855 Email:[EMAIL PROTECTED] -Original Message- Sent: Monday, July 21, 2003 5:20 PM To: Multiple recipients of list ORACLE-L SIGSEGV = Segment Violation = invalid address = bad code Sounds like you need to contact SAP and/or Oracle support. Jared "Vergara, Michael (TEM)" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 07/21/2003 02:04 PM Please respond to ORACLE-L -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Vergara, Michael (TEM) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: 9i Grid "voodoo" cookbook
Well, (and this is honestly not a marketing pitch, I SWEAR) that's where companies like mine are stepping in. All of these kind of technologies are fine and dandy, but they add complexity, new skills to train people on, etc. The ownership savings can be very questionable. So, vendors build products that try to automate and take the pain away from the IS departments. Sure, you still have to test whatever end-to-end solution you're looking at, but its much easier than trying to master the entire solution. This isn't just true of clustering/RAC - its true of storage, networking, infrastructure management, middleware, etc. Every new technology that is bigger/better/faster/cheaper (circle any three you like) is also a new learning curve and new set of pitfalls. The lifecycle is tech is proposed->tech is built->early adopters buy in->early adopters get burned (generally)->companies look at early adopters' experience and build products to mitigate pain->tech becomes (more) accepted, whether they use the vendors' products or not. Matt -- Matthew Zito GridApp Systems Email: [EMAIL PROTECTED] Cell: 646-220-3551 Phone: 212-358-8211 x 359 http://www.gridapp.com > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On > Behalf Of Odland, Brad > Sent: Monday, July 21, 2003 4:25 PM > To: Multiple recipients of list ORACLE-L > Subject: 9i Grid "voodoo" cookbook > > > (Yeah Tom Mercadante...I agree) > > I remember a time when Microsoft was spouting Windows > clustering and how great it was. People started with two > boxes then kept adding until the whole mess fell apart. > People and companies whet bust promoting cluster solutions. > Rather than sizing a box appropriately and purchasing the > hardware sized to handle five years of growth now we are > looking at a cluster scenario again. Adding boxes as we go. > Just how easy is that? What about future security issues? > Patches...etc... > > Frankly I find it hard to believe that anyone is going to > save any money with blades and 9i RAC right now. Once again > the hardware people have found that giving people less for > the same cost is better (for them). Seems like the burden of > testing and proving these cluster solutions is going to fall > on us (IS). I mean really! Who would set this solution up and > roll it into production in a weekend?? I sure wouldn't > expect that. I would expect to have to create a test lab, buy > test hardware and prove that it actually works. Seems > expensive to me. Somebody honestly tell me they would have no > problem converting a 8 way HP-UX box to four dual blades and > 9i RAC in a weekend. Different packaging is all we have here. > RAC is like a "lunchable". Less product, more expensive, more > marketing promises and leaves a bad taste in my mouth. > > Don't get me wrong I think the idea sounds cool. It's just > that we've all heard of cool stuff turning into a hot > steaming pile real fast... > > IT budgets are stretched pretty thin. Buying unproven > technology is not a very wise choice right now unless you > have a lot of disposable cash for in house testing. > > Why should IT have to prove this works? > > > Brad O. > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Odland, Brad > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') > and in the message BODY, include a line containing: UNSUB > ORACLE-L (or the name of mailing list you want to be removed > from). You may also send the HELP command for other > information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Matthew Zito INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Fast!
I think our Corporate Networks just upgraded because I'm now getting over 600K/s sustained downloads. I thought it was just something on our end. Thanks for the boost, Bruce! :) Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA > -Original Message- > From: Goulet, Dick [mailto:[EMAIL PROTECTED] > Sent: Monday, July 21, 2003 4:49 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: Fast! > > > Bruce, > > Regrettably I can't tell. There's a spam blocker that > filters out messages where the person being sent to is the > same as the person sending. So I don't see how fast the > posts arrive. But on the plus side the inbox is filling up > faster. Now if I could just find someone who knew anything > about this SmartTime time accounting system? > > Dick Goulet > Senior Oracle DBA > Oracle Certified 8i DBA > > -Original Message- > Sent: Monday, July 21, 2003 4:39 PM > To: Multiple recipients of list ORACLE-L > > > I've noticed! Good job Bruce! > > Tom Mercadante > Oracle Certified Professional > > > -Original Message- > Sent: Monday, July 21, 2003 4:29 PM > To: Multiple recipients of list ORACLE-L > > > FYI > > > > > > Hi Jared -- > > Yeah, I've been finally working on getting us closer to > real-time speed. I > put in the first of the changes about two weeks ago, but you probably > didn't > notice them until last weekend, when some significant changes > were made. > I've still got some more work to do, but it's headed the > right direction, > and I'm glad someone noticed. Actually, to date, you're the > ONLY one who > noticed. ;-) > > thanks, > bruce > > - Original Message - > To: <[EMAIL PROTECTED]> > Sent: Thursday, July 17, 2003 14:18 > > > > Bruce, > > > > Anything new at your end? > > > > My posts are showing up in about 2 minutes, which is most unusual. > > > > Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: HP-UX 11i/9.2.0.3/Strange Executions
Michael, When you say 'different execution plans', what are the differences? Is the choice in execution plans causing the ORA-07445? If so, why are the execution plans different (there has to be a reason)? Statistics, parameters, etc. will alter the execution plan choices. The 7445 definitely deserves a call to Oracle Support (through SAP if need be). 7445s are a royal pain to diagnose (like 600s). Daniel "Vergara, Michael (TEM)" wrote: > > Hi Everyone! > > HELP! > > I upgraded my SAP *PRODUCTION* instance to 9.2.0.3 over the weekend. > Everything up until now has been OK. However, I now have some > SAP Transactions (read: data entry forms) that are abending > unexpectedly. > > What's strange is that when we run the transaction on our Stage > server the explain plan is different, and the query succeeds. In > PRD, the query is a single-step, and in stage it gets broken out > into sub-queries and executed there. > > I created a report of all the database parameters. There is no > difference that cannot be explained by the difference in CPUs, > database name, or application paths. They are fundamentally > identical. > > But the query aborts on PRD. I am attaching the top few lines > of a typical trace file. ANY help, RTFM references, suggestions, > incantations, incense, or holy water will be appreciated. > > Thanks, > Mike > > *** 2003-07-21 14:52:06.921 > *** SESSION ID:(326.5957) 2003-07-21 14:52:06.886 > Exception signal: 11 (SIGSEGV), code: 0 (unknown code), addr: 0x80016ede9f30, > PC: [0x41331c0c, kghfrmrg()+596] > Registers: > r1: 8001d9e8 r22: 6e6178d8 sr4: 7df0c00 > rp:0 arg3: 80016ede9f28 sr0: 67c9c00 > r3: 413319b8 arg2: c0006e615fa0 sr1: d7db000 > r4:0 arg1: 6e615fa0 sr2:0 > r5:0 arg0: c0b38f001131 sr3:0 > r6: 7ffcdp: 8001000ca608 sr5: 693 > r7:0 ret0:0 sr6: a814c00 > r8: 8001007d3798 ret1: 800 sr7: 67c9c00 > r9: 8001007d3780sp: 83ffbfff6880 cr0:0 > r10:0 r31:6 cr8: 77f6368 > r11:0 sar: 38 cr9: 77f6378 > r12:0 pcoqh: 41331c0f ccr:0 > r13:1 pcsqh: 693 cr12: 494c008 > r14: 83ffbfff48c0 pcoqt: 41331a93 cr13: 4a2b008 > r15: 83ffbfff48c8 pcsqt: 693 cr24: 4a2c808 > r16: 403f85d0 eiem: cr25: 4a2a808 > r17: af0 iir: 72f50010 cr26: 4a2c808 > r18:0 isr: a814c00 mpsfu_hi: 8001000e36c8 > r19: 8001d9e8 ior: 80016ede9f30 mpsfu_lo:0 > r20:0 ipsw: ff080cff1f mpsfu_ov: 41 > r21: 8001007d2650 goto:97f68 pad:0 > *** 2003-07-21 14:52:07.811 > ksedmp: internal or fatal error > ORA-07445: exception encountered: core dump [kghfrmrg()+596] [SIGSEGV] [unknown > code] [0x80016EDE9F30] [] [] > Current SQL statement for this session: > SELECT T_00 . "MATNR" , T_00 . "PRDHA" , T_01 . "MAKTX" FROM "MARA" T_00 , "MAKT" > T_01 WHERE ( T_01 . "MANDT" = :A0 AND T_01 . "MATNR" = T_00 . "MA > TNR" ) AND T_00 . "MANDT" = :A1 AND ( ( T_00 . "MATNR" BETWEEN :A2 AND :A3 OR T_00 . > "MATNR" BETWEEN :A4 AND :A5 OR T_00 . "MATNR" BETWEEN :A6 AND > :A7 OR T_00 . "MATNR" BETWEEN :A8 AND :A9 OR T_00 . "MATNR" BETWEEN :A10 AND :A11 OR > T_00 . "MATNR" BETWEEN :A12 AND :A13 OR T_00 . "MATNR" BETWEEN > :A14 AND :A15 OR T_00 . "MATNR" BETWEEN :A16 AND :A17 OR T_00 . "MATNR" BETWEEN > :A18 AND :A19 ) OR T_00 . "MATNR" IN ( :A20 , :A21 , :A22 , :A23 , > :A24 , :A25 , :A26 , :A27 , :A28 , :A29 , :A30 , :A31 , :A32 , :A33 , :A34 , :A35 , > :A36 , :A37 , :A38 , :A39 , :A40 , :A41 , :A42 , :A43 , :A44 , > :A45 , :A46 , :A47 , :A48 , :A49 , :A50 , :A51 , :A52 , :A53 , :A54 , :A55 , :A56 , > :A57 , :A58 , :A59 , :A60 , :A61 , :A62 , :A63 , :A64 , :A65 , > :A66 , :A67 , :A68 , :A69 , :A70 , :A71 , :A72 , :A73 , :A74 , :A75 , :A76 , :A77 , > :A78 , :A79 , :A80 , :A81 , :A82 , :A83 , :A84 , :A85 , :A86 , > :A87 , :A88 , :A89 , :A90 , :A91 , :A92 , :A93 , :A94 , :A95 , :A96 , :A97 , :A98 , > :A99 , :A100 , :A101 , :A102 , :A103 , :A104 , :A105 , :A106 , > :A107 , :A108 , :A109 , :A110 , :A111 , :A112 , :A113 , :A114 , :A115 , :A116 , > :A117 , :A118 , :A119 , :A120 , :A121 , :A122 , :A123 , :A124 , :A > 125 , :A126 , :A127 , :A128 , :A129 , :A130 , :A131 , :A132 , :A133 , :A134 , :A135 > , :A
RE: HP-UX 11i/9.2.0.3/Strange Executions
I'm unable to open a TAR for you, but here is what a quick Metalink search has produced: Oracle Server-Enterprise and Standard Edition Technical Forum Displayed below are the messages of the selected thread. Thread Status: Active before applying patch RDBMS Version: 8.1.6 Operating System and Version: solaris 2.6 Error Number (if applicable): ora 7442 Product (i.e. SQL*Loader, Import, etc.): Product Version: 8.1.6 database crashing with ora 7445; would like input from other people before applying patch Hi there, We've had several db's crash periodically with one or the other of the following errors: ORA-07445: exception encountered: core dump[kghfrmrg()+88] [SIGSEGV] [Address not mapped to object] [2219483628] [][] ORA-07445: exception encountered: core dump [kghfrmrg()+488] [SIGSEGV][Address not mapped to object] [2216410208] [] [] I've posted a tar and the reponse has been to apply the Solaris patch 8.1.6.2 Before applying this patch I'd like some feedback from folks out there in the field. I've seen several other posts on Metalink reporting the same problem but have not seen any resolutions. (If I've overlooked one, I apologize and would appreciate someone pointing me to it). Some of the proposed resolutions were to upgrade to 8.1.6 (obviously it's not fixed in 8.1.6). If anyone out there has had this problem and has upgraded to a patch for 8.1.6 I would really appreciate some feedback. We cannot recreate the problem consistently but it's happening frequently enough to cause problems on our production db's. However, I have not gotten any indication that this patchset corrects the problem. I do not like to apply patches and see if it corrects a problem, especially when it's a problem that has been reported as often as this error. Thanks for any info you can provide. Richard. people before applying patch Hi. Was there a bug number referenced for your scenario which is fixed in the 8.1.6.2 patchset release? I would need to see the trace file associated with this error as well as an excerpt from the alert.log showing a timeframe from the last startup of the database through the time of the error and subsequent database crash. You can e-mail those to me at: [EMAIL PROTECTED] Please reference the subject and date of your thread in the e-mail. ORA-7445 is a generic error which signals that an unhandled exception occurred somewhere within the Oracle environment for some reason. The cause of one occurrence may or may not be related to another occurrence. Sometimes, the exception occurs due to previous errors. Do all occurrences of the ORA-7445 which initiates the crash look just like the one you list with [kghfrmrg] as the first arguement? Regards, Helen Oracle Support Services people before applying patch Richard We have encountered similar messages in our alert log. These were caused by the use of %rowtype in pl/sql. This is not fixed in the 8.1.6.2 patch, and is in fact still a problem in 8.1.7. So, if it is possible that this could be causing your problems, I would not advise applying the patch. However, we have applied the 8.1.6.2 patch for another 8.1.6 problem - a bug with degree of parallelism and unions. We have encountered many more problems with the patch than without. Oracle have said it is likely we would have encountered these problems with 8.1.6.0, we just hadn't got that far. They also said that the patch was the only option for our problem at that time. It also appears that most of the bugs we have encountered in 8.1.6.2 have been related to parallel query, so if you are not using parallel query, you may be OK with the patch. Have Fun with this one! Thanks Tracey Widdall people before applying patch Hi. Unfortunately, I am unable to confirm that this is fixed in the 8.1.6.2 as I am unable to pinpoint a bug that you are encountering. Both of the scenarios you provided show a session performing an 'alter database backup controlfile to trace' followed by a shutdown immediate.' The ORA-7445 error is signalled to the session upon the ALTER DATABASE CLOSE which is fatal. PMON then encounters the same error when attemping the cleanup. How is this backup of the controlfile and shutdown controlled? Do you have a script which executes this every night? Would it be possible to alter the sequence of events so that the session which performs the backup of the controlfile exits, then starts a new session to execute the shutdown immediate? Regards, Helen Oracle Support Services people before applying patch Hi Helen, Thanks for the feedback. There is a script that runs every night to do t
