Re: Replicating a user across DBs
Hi Jesse In 8.1.7, is there a way to easily replicate a user from one DB (e.g. development) to another (e.g. production)? I can export all the objects in the schema, but export/import won't recreate the schema in the import DB. I've been using OEM to create a script (reverse engineered from Create like...), but the resulting script requires editing and the assignment of a resource plan doesn't always play nice, either. There has got to be a better way... The freeware DBATool will do this. It reads an export file created ROWS=N and will generate the schema DDL from it (including grants TO and FROM, public synonyms dblinks, profiles, etc etc). The DBATool can also adjust or remove the tablespace and storage clauses on the output scripts and has nifty DDL to HTML converter. DBATool: http://www.DataBee.com Regards Dale Edgar Net 2000 Ltd. [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: order by in subquery workaround
Hi I have in the past seen a download for a backported statspack on I believe OTN. This would work on Oracle 8.0.5 Maybe still there Jack Baker, Barbara bbaker@denvernewspaperTo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] agency.comcc: (bcc: Jack van Zanen/nlzanen1/External/MEY/NL) Sent by: Subject: order by in subquery workaround [EMAIL PROTECTED] 11-07-2002 19:38 Please respond to ORACLE-L Solaris 2.6 Oracle RDBMS v8.0.5.2.1 List: I'm trying to run a retrofit of statspack on an 8.0.5 database. (ya, I know. upgrading would actually be easier) The statspack stuff came from an 8.1.7 install I have on the same box. The spreport.sql report encounters errors in the order by clause. The problem is that you can't do an order by on a subquery before version 8.1.something-or-other I know there's some kind of work around for this. I had something to do with a hint. Even after 3 cups of coffee, I can't remember what it is. Can anyone help? Thanks! Barb here are the errors: Shared Pool StatisticsBegin End -- -- Memory Usage %: 75.99 70.05 % SQL with executions1: 21.95 48.60 % Memory for SQL w/exec1: 11.28 21.84 order by time desc, waits desc * ERROR at line 24: ORA-00907: missing right parenthesis pmon timer 1,184 1,177 355,304 3001 0.2 - order by (e.buffer_gets - nvl(b.buffer_gets,0)) desc, e.hash_value, st.piece * ERROR at line 41: ORA-00907: missing right parenthesis -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Baker, Barbara INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). === De informatie verzonden in dit e-mailbericht is vertrouwelijk en is uitsluitend bestemd voor de geadresseerde. Openbaarmaking, vermenigvuldiging, verspreiding en/of verstrekking van deze informatie aan derden is, behoudens voorafgaande schriftelijke toestemming van Ernst Young, niet toegestaan. Ernst Young staat niet in voor de juiste en volledige overbrenging van de inhoud van een verzonden e-mailbericht, noch voor tijdige ontvangst daarvan. Ernst Young kan niet garanderen dat een verzonden e-mailbericht vrij is van virussen, noch dat e-mailberichten worden overgebracht zonder inbreuk of tussenkomst van onbevoegde derden. Indien bovenstaand e-mailbericht niet aan u is gericht, verzoeken wij u vriendelijk doch dringend het e-mailbericht te retourneren aan de verzender en het origineel en eventuele kopieën te verwijderen en te vernietigen. Ernst Young hanteert bij de uitoefening van haar werkzaamheden algemene voorwaarden, waarin een beperking van aansprakelijkheid is opgenomen. De algemene voorwaarden worden u op verzoek
RE: Function based indexes
Hi, I've seen oracle application 11i(11.5.3) setting one parameter _OR_EXPAND_NVL_PREDICATE for queries using nvl(:bind_var, col_name) syntax. Have a look at this parameter on metalink. It is published hidden parameter. It may help you. Regards, Sandeep. -Original Message- Sent: Friday, July 12, 2002 9:18 AM To: Multiple recipients of list ORACLE-L Subject:Re: Function based indexes I don't think that will work. If you need this to work in a SQL statement in SQL*Plus, what you can do is something like this: create or replace package types as type cursorType is ref cursor; end; / create or replace function sp_ListEmp ( col_value_in my_table.my_column.%type default 'My Default Value') return types.cursortype as l_cursortypes.cursorType; begin open l_cursor for select 'x' from my_table where my_column = col_value_in; return l_cursor; end; / REM SQL*Plus commands to use a cursor variable variable c refcursor variable my_bind='testdata' exec :c := sp_ListEmp(:my_bind) print c HTH Jared On Thursday 11 July 2002 15:24, Imma C. Rocco wrote: Hi, I have read that on Oracle 8.1.7 it is possible to create a function based index like the one: Create index ind1 on table (substr(column_name)) tabelspace etc And if Oracle optimizer is in CBO mode and query_rewrite_enabled = true query_rewrite_integrity = trusted compatible = 8.1.0 or greater A statement which has a where clause that involve a substr(colum_name) should use the index. (*)I would like to know if it is also possible to create a function based index on a NVL function that involve a bind variable, because a have a statement like the one that follow: select 'x' from table where col_name = nvl(:p_aa, col_name) This statement perform a full table scan on table ps: if (*) is possible could you please give an sintax example? Thanks Imma _ Supercharge your e-mail with a 25MB Inbox, POP3 Access, No Ads and NoTaglines -- LYCOS MAIL PLUS. http://www.mail.lycos.com/brandPage.shtml?pageId=plus -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sandeep Kurliye INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Why DDL is not allowed in PL/SQL
Yes, But why then we can issue DLL in PL/SQL using DBMS_SQL package. -Original Message- From: Alroy Mascranghe [SMTP:[EMAIL PROTECTED]] Sent: Friday, July 12, 2002 12:33 PM To: Multiple recipients of list ORACLE-L Subject:RE: Why DDL is not allowed in PL/SQL Maybe it is to maintain transaction consistency, bcos the DDLs issue a commit implicitly. So if u do in the middle of DML-transaction it might mess up the transaction as a whole. -Original Message- Sent: Friday, July 12, 2002 10:58 AM To: Multiple recipients of list ORACLE-L Hi List, Why it is not allowed to write DDL(e.g. create table) in PL/SQL directly, but same can be done using DBMS_SQL package. Curious Sam __ Do You Yahoo!? Sign up for SBC Yahoo! Dial - First Month Free http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: sam d INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: PL/Sql Error Handling Package
I sent such code some 2-3 months ago to this list, cannot find it quickly now. That used autonomous transactions and stored errors in a table. I'm not posting much, therefore You may search in archives using my name ... Gints Plivna IT Sistçmas, Meríeïa 13, LV1050 Rîga http://www.itsystems.lv/gints/ johanna.doran@sun gard.com To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: PL/Sql Error Handling Package 2002.07.11 23:52 Please respond to ORACLE-L Amy one have any decent stanard error handling packages or link to advice on creating such a package? Thanks, Hannah -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: larry want to take over your e-mai
I'm currently doing CBTs at my desk as we speak. We have a consultant in at the moment getting things moving, in a months time we will be doing skills transfers from him but I am stealing a march on that. I have DB2 installed on my PC here in the office and will be starting on the lab exercises in a couple of weeks when I get back from holiday. Thats INGRES, ORACLE, INFORMIX and DB2 up to now. Not sure that all of this will help me very much when I eventually get my thumb out my arse and start studying to do Sports Physiotherapy which is where I fancy taking my career. Lee -Original Message- Sent: 11 July 2002 18:19 To: Multiple recipients of list ORACLE-L THAT DOES IT. I am starting training on DB2 right away (Yeah - I can actually AFFORD to no $2000 requirements!!). I want a DB that KNOWS its a DB and not an all-purpose quagmire of inter-related but not really related junk just because Larry has a Bill complex! Oracle and CHEAP cannot be used in the same sentence! Must have been a misquote...surpised they dont need a 5000 named user license! Argh.. mental meltdown in process. One... two deep breath Is it Friday yet? Hannah -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). * The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution, or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. Thank You. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robertson Lee - lerobe INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: killing sessions
I had a similar problem a while ago now and the users in question could see
their session from toad but didn't have permissions to kill them. This is
what I did (see procedure below).
It allows a user to kill a session of theirs but not the current one. Here
is the code. All the user needs to know is his sid and serial number (gets
this form Toad).
I'm sure you could manipulate this code to suit your needs.
HTH
Lee
create or replace procedure killsession
(v_sid IN number, v_serial IN number, v_puser IN varchar2)
as
v_statement varchar2(200);
v_user varchar2(10);
v_cursor_name integer;
v_rows_processed integer;
BEGIN
dbms_output.enable(1); -- Set up output buffer
-- get the details to kill
select username into v_user from v$session where v_sid = sid and v_serial =
serial# and v_puser = user;
-- format the statement to run
v_statement := 'alter system kill session '''||v_sid||','||v_serial||;
-- set up cursor and run the staement
v_cursor_name := dbms_sql.open_cursor;
dbms_sql.parse(v_cursor_name, v_statement, dbms_sql.v7);
-- Return value from dbms_sql.execute on DDL is undefined, don't check
v_rows_processed := dbms_sql.execute(v_cursor_name);
dbms_sql.close_cursor(v_cursor_name);
-- exception section where details entered are incorrect
exception
when no_data_found
then
dbms_output.put_line('One or more of your parameters
is wrong. Please Check again');
when others
then
raise;
-- end of procedure
end;
/
Original Message-
Sent: 11 July 2002 19:51
To: Multiple recipients of list ORACLE-L
We have developers who occassionally want to be able to kill their
sessions in a dev instance. We are concerned about giving them alter
system priviledge and were wondering what people do about this. Is there
any other way they can do this? Do some shops allow certain users to do
this with some training?
Thanks.
Joe
[EMAIL PROTECTED]
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Joe Armstrong-Champ
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
*
The information contained in this communication is
confidential, is intended only for the use of the recipient
named above, and may be legally privileged.
If the reader of this message is not the intended
recipient, you are hereby notified that any dissemination,
distribution, or copying of this communication is strictly
prohibited.
If you have received this communication in error,
please re-send this communication to the sender and
delete the original message or any copy of it from your
computer system. Thank You.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Robertson Lee - lerobe
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
RE: More on the OCP priceing
Utter bollocks. All that means is it will be cash rich companies (or well to do individuals) who can afford to put their employees/themselves through this training. I was attempting to persuade (unsuccessfully) my company to put me through the certification process before all of this. I am sure I could get through it and pass but I have absolutely no chance of doing this now what with budgetary constraints being what they are in the present climate GR -Original Message- Sent: 11 July 2002 19:39 To: Multiple recipients of list ORACLE-L List, Received this from the searchdatabase.com site about Oracle defending the OCP pricing. =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= LEAD STORY ORACLE U. DEFENDS OCP TITLE | SearchDatabase Defending their new DBA certification requirement against critics who say it's costly and unnecessary, Oracle described the move as part of a new strategy to ensure that only top-shelf candidates receive the company's stamp of approval. For the full details, click: http://www.searchdatabase.com/originalContent/0,289142,sid13_gci837964,00.ht ml FOR MORE INFORMATION: Check out our Featured Topic on database certifications: http://searchdatabase.techtarget.com/featuredTopic/0,290042,sid13_gci754839, 00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Interesting read ROR mª¿ªm -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). * The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution, or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. Thank You. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robertson Lee - lerobe INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Help me tuning the log file sync wait event
Hi ,
You encounter log file sync and log file parallel write events .
This can be because of a slow device on which redo log files are on . OR
your redo log sizing is bad.
Bunyamin Karadeniz
Oracle DBA
Havelsan A.S. Eskisehir yolu 7.km
Ankara / Turkey
Tel : +90 535 3357729
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Friday, July 12, 2002 6:33 AM
hi, dbas:
One of the database i manage face a serious wait event, log file sync.
This is a big and busy oltp system, and using disk array of Sun T3 with
raid-5. We are using Veritas QuickIO for datafile and redo log files.
The pressure on the database is growing fast, and more and more the redo
log becomes the bottleneck of the database.
Here is some data showing the fact:
2002/05/03
Top 5 Wait Events
~ Wait %
Total
Event Waits Time (cs) Wt
Time
---
log file sync 82,244 92,442
33.68
db file sequential read 298,301 80,719
29.41
log file parallel write81,849 36,989
13.48
db file parallel write 5,427 33,615
12.25
control file parallel write 4,6736,104
2.22
2002/05/07
Top 5 Wait Events
~ Wait %
Total
Event Waits Time (cs) Wt
Time
---
log file sync 6,352,383 15,785,313
40.09
db file sequential read26,862,699 12,538,922
31.85
log file parallel write 5,971,2293,990,066
10.13
db file parallel write290,4793,164,391
8.04
db file scattered read 1,749,137 814,981
2.07
2002/05/21
Top 5 Wait Events
~ Wait %
Total
Event Waits Time (cs) Wt
Time
---
log file sync 2,207,6096,688,751
59.47
log file parallel write 2,044,9771,385,379
12.32
db file parallel write103,1551,203,077
10.70
db file sequential read 8,772,9081,088,922
9.68
log buffer space3,284 222,604
1.98
2002/05/28
Top 5 Wait Events
~ Wait %
Total
Event Waits Time (cs) Wt
Time
---
log file sync 2,247,585 20,529,779
63.71
db file parallel write441,0524,377,899
13.59
log file parallel write 1,724,0893,806,535
11.81
db file sequential read 8,854,5252,044,020
6.34
enqueue78,759 592,411
1.84
2002/07/04
Top 5 Wait Events
~ Wait %
Total
Event Waits Time (cs) Wt
Time
---
log file sync 3,838,694 13,158,371
63.28
db file sequential read 2,189,8632,401,275
11.55
log file parallel write 3,401,0352,098,018
10.09
db file parallel write 97,0861,503,608
7.23
enqueue71,251 432,706
2.08
2002/07/11
Top 5 Wait Events
~ Wait %
Total
Event Waits Time (cs) Wt
Time
---
log file sync 453,8629,679,513
68.11
db file sequential read 500,1571,660,982
11.69
db file parallel write 67,2351,137,017
8.00
log file parallel write 163,1801,075,201
7.57
log file sequential read 32,012 254,327
1.79
As you can see, log file sync is a big bottleneck, and i have to solve
this problem.
I think the best solution maybe convert to dedicated raid1 or single disk
with oracle multiplex, but this need to rebuild the whole disk array , need
Re: Help me tuning the log file sync wait event
Some suggestions a) Check your commit frequency - if you're committing like mad then this is a great way to over stress redo logging operations. b) Check the size of the average redo write. If they're small, you might get some benefit by allocation write cache in the T3 to the redo logs (if thats possible) to batch up the writes c) Look at means at reducing the amount of redo log your're generating eg transaction auditing etc hth connor --- chaos [EMAIL PROTECTED] wrote: hi, dbas: One of the database i manage face a serious wait event, log file sync. This is a big and busy oltp system, and using disk array of Sun T3 with raid-5. We are using Veritas QuickIO for datafile and redo log files. The pressure on the database is growing fast, and more and more the redo log becomes the bottleneck of the database. Here is some data showing the fact: 2002/05/03 Top 5 Wait Events ~ Wait % Total Event Waits Time (cs) Wt Time --- log file sync 82,244 92,442 33.68 db file sequential read 298,301 80,719 29.41 log file parallel write 81,849 36,989 13.48 db file parallel write 5,427 33,615 12.25 control file parallel write 4,6736,1042.22 2002/05/07 Top 5 Wait Events ~ Wait % Total Event Waits Time (cs) Wt Time --- log file sync 6,352,383 15,785,313 40.09 db file sequential read 26,862,699 12,538,922 31.85 log file parallel write 5,971,2293,990,066 10.13 db file parallel write 290,4793,164,3918.04 db file scattered read 1,749,137 814,9812.07 2002/05/21 Top 5 Wait Events ~ Wait % Total Event Waits Time (cs) Wt Time --- log file sync 2,207,6096,688,751 59.47 log file parallel write 2,044,9771,385,379 12.32 db file parallel write 103,1551,203,077 10.70 db file sequential read 8,772,9081,088,9229.68 log buffer space 3,284 222,6041.98 2002/05/28 Top 5 Wait Events ~ Wait % Total Event Waits Time (cs) Wt Time --- log file sync 2,247,585 20,529,779 63.71 db file parallel write 441,0524,377,899 13.59 log file parallel write 1,724,0893,806,535 11.81 db file sequential read 8,854,5252,044,0206.34 enqueue 78,759 592,4111.84 2002/07/04 Top 5 Wait Events ~ Wait % Total Event Waits Time (cs) Wt Time --- log file sync 3,838,694 13,158,371 63.28 db file sequential read 2,189,8632,401,275 11.55 log file parallel write 3,401,0352,098,018 10.09 db file parallel write 97,0861,503,6087.23 enqueue 71,251 432,7062.08 2002/07/11 Top 5 Wait Events ~ Wait % Total Event Waits Time (cs) Wt Time --- log file sync 453,8629,679,513 68.11 db file sequential read 500,1571,660,982 11.69 db file parallel write 67,2351,137,0178.00 log file parallel write 163,1801,075,2017.57 log file sequential read 32,012 254,3271.79 As you
Re: connect as internal
Hello Kavi Connect system/manager as sysdba, do: select user from dual. reply: SYS Your system user become sys when connect as sysdba. The default schema is also sys so be careful when creating objects while connected as sysdba. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, July 11, 2002 11:14 PM Hi Mitchell, what is different between those 3 login 1. sqlplus system login, connect as internal Answer: when you are doing this you are user 'sys' because you have changed from system to being 'internal' connect internal - technically is user 'sys', and is the way of authenticating to the database 2. sqlplus system/manager login Answer: when you are doing this you are user 'system' 3. sqlplus system login , connect system as sysdba Answer: when you are doing this you are user 'system' you have given 'system' sysdba privilege ( which 'system' can perform everything which is allowed for sysdba privilege + on-top of the privileges that it already has) importantly by logging this way 'system' can never be equal to 'connect internal' Thanks, Kavi mitchell wrote: Hi I just view readme about installing Oracle Patch on Oralce 8.1.6 One thing mentioned as Invoke sqlplus, connect as internal and run catalog catproc etc .. I wonder why Connect as internal. what is different between those 3 login 1. sqlplus system login, connect as internal 2. sqlplus system/manager login 3. sqlplus system login , connect system as sysdba Thanks in advance Mitchell -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: mitchell INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: 1 Volume of Software RAID 1+0 versus Multiple Volumes of Software Raid 1 ?
I would go with the second option. Better yet, get also three controllers, one for each logical drive. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, July 11, 2002 3:43 PM Raid 1 ? For performance , Which Option is better :- Given 6 Internal FCAL Hard Disks ? 1) Creating 1 Volume with Software RAID 1+0 OR 2) Creating 3 Volumes of Software RAID 1 , Each Volume Containing 2 Disks Manually Spreading the Database across the 3 Volumes ? Solaris 8 Machine V880 model -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: VIVEK_SHARMA INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: larry want to take over your e-mai
It is Friday here already. You do not need 5000 named users license. They will license for all the e-mail address that CAN send you mail. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, July 11, 2002 7:18 PM THAT DOES IT. I am starting training on DB2 right away (Yeah - I can actually AFFORD to no $2000 requirements!!). I want a DB that KNOWS its a DB and not an all-purpose quagmire of inter-related but not really related junk just because Larry has a Bill complex! Oracle and CHEAP cannot be used in the same sentence! Must have been a misquote...surpised they dont need a 5000 named user license! Argh.. mental meltdown in process. One... two deep breath Is it Friday yet? Hannah -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: PL/Sql Error Handling Package
Thanks! -Original Message- From: [EMAIL PROTECTED]@SUNGARD On Behalf Of [EMAIL PROTECTED] Sent: Thursday, July 11, 2002 5:34 PM To: Multiple recipients of list ORACLE-L Subject: Re:PL/Sql Error Handling Package Hanah, This is one procedure out of an entire package, but it works for us. procedure oracle_err(message in varchar2, status out number, mailing_list in varchar2 default 'NONE' ) is file_hndl utl_file.file_type; luser varchar2(40); sname varchar2(40); sn varchar2(7); fname varchar2(40); err_date varchar2(20); begin status := sqlcode; if(status 0) then select user, name, to_char(err_file_sqnc.nextval), to_char(sysdate,'DD-MON- HH24:MI') into luser, sname, sn, err_date from oracle_server; fname := 'oracle'||sn||'.err'; file_hndl := utl_file.fopen(utl_home,fname,'a'); utl_file.putf(file_hndl, 'Oracle Error Report from %s\n%s\n', sname, err_date); utl_file.putf(file_hndl, 'Error: %s\nLocation: %s', sqlerrm, message); utl_file.fflush(file_hndl); utl_file.fclose(file_hndl); rollback; if(mailing_list != 'NONE') then cron_mail_list(mailing_list, fname, 'Oracle Procedure Error'); end if; end if; end; Dick Goulet -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Fwd: [Builder.com] Create an SPFILE in 9i
List, Just by coincidence this came in the mail today. Ron ROR mª¿ªm Oracle Tips at Builder.com Online#[EMAIL PROTECTED] 07/12/02 03:05AM Builder http://builder.com.com Presents your ORACLE E-NEWSLETTER for July 12, 2002 ---Advertisement--- THE DATA STORAGE INFO YOU NEED BEFORE YOU BUY Selecting the appropriate data storage solution is vital to your organization's future. When the choice rests on your shoulders, you need the unbiased expert advice you can only get from TechRepublic - so make an informed decision with IT Professional's Guide to Enterprise Storage book and CD-ROM. Don't wait to hit critical mass! Get the insights and articles to help you through the maze of features, benefits, and limitations of a wide range of data storage solutions. http://clickthru.online.com/Click?q=ec-MHyXQVy2A7t5Hez1D55FiEbDabZR --- CREATE AN SPFILE IN ORACLE9i An exciting new feature of Oracle9i is the removal of the init.ora file. Oracle has replaced the init.ora file because you can now change all parameters dynamically with the ALTER SYSTEM commands. With Oracle9 i, you can manage initialization parameters using a binary server parameter file (SPFILE). By default, a new Oracle9i database will be working on a PFILE, so you must create the SPFILE from the PFILE at the SQL prompt. You can create the SPFILE using the CREATE SPFILE statement, which requires connecting as SYSDBA. Connect system/manager as sysdba; CREATE SPFILE FROM PFILE; This command creates an SPFILE in a nondefault location ($ORACLE_HOME/database). However, you can fully qualify the path name in the CREATE SPFILE statement. CREATE SPFILE='/u01/admin/prod/pfile/file_mydb.ora' FROM PFILE=/u01/admin/prod/pfile/initprod.ora'; After creating an SPFILE, you may encounter an error when you bounce the database. To work around this, you have to reconnect as SYSDBA and use the STARTUP command. The addition of the SPFILE has changed the search path for the Oracle startup deck. In Oracle9i, follow these steps to search for the SPFILE: 1. Search for the spfile$ORACLE_SID.ora file in the default location. 2. Look for the spfile.ora. 3. Search for the PFILE by name: init$ORACLE_SID.ora. SPECIFYING SCOPE Once you have an SPFILE, you can change any initialization parameter with the ALTER SYSTEM command. However, there's an important SCOPE parameter that you need to understand. The SCOPE parameter has three values: SPFILE, MEMORY, and BOTH. Let's look at an example of each. Alter system set db_2k_cache_size=100m SCOPE=SPFILE; If you want to make a change to a parameter in the SPFILE without affecting the current instance, you can do so using the SCOPE=SPFILE option of the ALTER SYSTEM statement. This is useful when you want to make a change starting from the next startup and not for the current instance. Alter system set db_2k_cache_size=100m SCOPE=MEMORY; In the example above, the SCOPE=MEMORY option tells Oracle9i to make the change for the life of the instance and to change it back to the default value the next time the database is bounced. Alter system set db_2k_cache_size=100m SCOPE=BOTH; When you specify SCOPE=BOTH, Oracle makes the change immediately, and Oracle will also make the change permanent, even after the database is bounced. Donald Burleson has been a database administrator for 23 years and has written 14 database books and over 100 articles. He is editor in chief of Oracle Internals and runs Burleson Oracle Consulting. READ MORE ABOUT DEVELOPMENT AN INSIDER'S GUIDE TO ORACLE CERTIFICATION Is an OCP certification your ticket to becoming an Oracle DBA, or is it just one of several important criteria? Check out this article for one expert's opinion. http://clickthru.online.com/Click?q=01-9oXDI2jHgIU_QeWv hPwP4lpp69RR WRITING READABLE CODE Following these simple naming conventions and documentation standards simplifies team code maintenance. Try these techniques on your next project and see if they work for you. http://clickthru.online.com/Click?q=16-T_cjI4cFVqlgbfmDYe9uS3KuRhcR CLIMBING TO THE TOP OF THE CORPORATE TECHNOLOGY LADDER Do your technical skills qualify you for an executive role? Before you fire off that resume to a headhunter, you need to consider a number of critical success factors. Here are some practical suggestions for breaking into the VP club. http://clickthru.online.com/Click?q=2b-2FVYINzsBDSyMkgwISVxZQsc8f9R -- NEW AT BUILDER.COM WHERE WILL THE VISUAL BASIC 6.0 DEVELOPERS GO? You love Visual Basic 6.0, but .NET is breathing down your neck. Should you make the move to Visual Basic .NET or C#? Before you make the choice, check out these three dispelled post-VB6 myths. http://clickthru.online.com/Click?q=41-qqJ1IEKImb3rPLMUvMWCV-BU0ciR COUNTING LINES OF CODE CAN HELP MEASURE PROGRESS One developer believes that counting a developer's lines of code
RE: listener configuration on HP serviceguard clusters
Title: RE: listener configuration on HP serviceguard clusters Do you have a listener.ora file? Which ip address is in it? Matt Adams - GE Appliances - [EMAIL PROTECTED]Enter any 11 digit prime number to continue. -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]Sent: Thursday, July 11, 2002 10:38 PMTo: Multiple recipients of list ORACLE-LSubject: RE: listener configuration on HP serviceguard clusters Matt, We have two nodes cluster with three packages; two of them have more than one database. Oracle software installed on each node. Each listener belongs to node, not to package. When packaged started on the node it will startup instance(s) and each instance will automatically registered with listener. In client's TNSNAMES.ORA we use package name, which resolved to proper IP address. Alex. -Original Message- From: Adams, Matthew (GEA, MABG, 088130) [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 11, 2002 2:15 PM To: Multiple recipients of list ORACLE-L Subject: listener configuration on HP serviceguard clusters If anybody out there is using HP ServiceGuard for non-OPS/RAC, I would be interested to know how you configure the listeners. Do you use the machine IP address or the package address in the listener.ora (or do you not have a listener.ora and use dynamic registration) One of the sys admins here instists that the following scenerio will not work. three nodes - two with one package each (containing Oracle) and one standby node. When the first package fails over to the standby node, it starts a listener using no listener.ora file, allowing the instances to dynamically register. When the second package fails over to the standby node, it does not start a listener. All client tnsnames.ora files use package names for HOST. Do the instances in the second package register successfully with the listener and can clients connect to them? Matt Adams - GE Appliances - [EMAIL PROTECTED] Enter any 11 digit prime number to continue.
RE: Oracle 9.2 spfile catch 22
Just a FYI. You can use _any_ 9i instance to recreate the init.ora for the instance from a spfile. It does not need to be the instance that the spfile is for! -Original Message- Sent: Thursday, July 11, 2002 5:54 PM To: Multiple recipients of list ORACLE-L I was migrating a V7.3.4.5 to V9.2 and the wizard does NOT create a new initSID.ora which is R2 compliant; only a spfileSID.ora file. My solution was to write a simple SQL query which generated a spool file, initSID.ora, which contained the parameter name and values where the value was not the default value. This certainly saved my bacon. Deshpande, Kirti wrote: I would get the DB to function the way I want first using init.ora. Then switch to SPFILE from init.ora, while preserving a copy of working init.ora file. Also, when a parameter is changed dynamically with SCOPE=both or spfile, I recreate my init.ora file as the backup. SPFILE concept is good and it is required for reaching the goal of 'no dba required', but it is still far from being 'ready for prime time'. I stopped using SPFILE with a couple of my databases when I was able to add db_cache_size to an spfile that already had db_block_buffers (two mutually exclusive parameters). The next restart of the DB failed. It was good that I had kept the init.ora file. I have not installed 9.2 yet, so I do now know if such things are verified beforehand and prevented. HTH, - Kirti -Original Message- From: DENNIS WILLIAMS [SMTP:[EMAIL PROTECTED]] Sent: Thursday, July 11, 2002 12:49 PM To: Multiple recipients of list ORACLE-L Subject: Oracle 9.2 spfile catch 22 Thanks to everyone for the ideas on the init.ora. You were correct that the answer is indeed with spfile. Now I have discovered a catch-22. Oracle 9.2, Solaris 1. If spfile is created with LOG_ARCHIVE_START = true, database will not start. Receive the error ORA-00439 feature not enabled: Managed Standby 2. Creating the spfile with LOG_ARCHIVE_START = false works and the database starts. Issuing ALTER SYSTEM ARCHIVE LOG START works, but it isn't changed in the spfile, so the next time Oracle is bounced, the archiver doesn't start. This is starting to smell like a bug, but I thought I'd run it past the list on the off-chance someone else has gotten archiving turned on for 9.2. Thanks. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Charlie Mengler Maintenance Warehouse [EMAIL PROTECTED] 10641 Scripps Summit Ct. 858-831-2229 San Diego, CA 92131 Lack of planning on your part doesn't constitute an emergency on my part! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Charlie Mengler INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Toepke, Kevin M INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists
Re: order by in subquery workaround
I downloaded it from metalink a while back. It was pretty straight forward to install. The report name was something different like statsrep.sql or statsrep80.sql. Also, there was a view that had to be created. All the information/instructions were in the tar file that I downloaded. If you can't find it on metalink, let me know, and I will round up my old notes and the tar file and send it to you. Rob Pegram Oracle Certified DBA --- Jack van Zanen [EMAIL PROTECTED] wrote: Hi I have in the past seen a download for a backported statspack on I believe OTN. This would work on Oracle 8.0.5 Maybe still there Jack Baker, Barbara bbaker@denvernewspaper To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] agency.com cc: (bcc: Jack van Zanen/nlzanen1/External/MEY/NL) Sent by: Subject: order by in subquery workaround [EMAIL PROTECTED] 11-07-2002 19:38 Please respond to ORACLE-L Solaris 2.6 Oracle RDBMS v8.0.5.2.1 List: I'm trying to run a retrofit of statspack on an 8.0.5 database. (ya, I know. upgrading would actually be easier) The statspack stuff came from an 8.1.7 install I have on the same box. The spreport.sql report encounters errors in the order by clause. The problem is that you can't do an order by on a subquery before version 8.1.something-or-other I know there's some kind of work around for this. I had something to do with a hint. Even after 3 cups of coffee, I can't remember what it is. Can anyone help? Thanks! Barb here are the errors: Shared Pool StatisticsBegin End -- -- Memory Usage %: 75.99 70.05 % SQL with executions1: 21.95 48.60 % Memory for SQL w/exec1: 11.28 21.84 order by time desc, waits desc * ERROR at line 24: ORA-00907: missing right parenthesis pmon timer 1,184 1,177 355,304 3001 0.2 - order by (e.buffer_gets - nvl(b.buffer_gets,0)) desc, e.hash_value, st.piece * ERROR at line 41: ORA-00907: missing right parenthesis -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Baker, Barbara INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). === De informatie verzonden in dit e-mailbericht is vertrouwelijk en is uitsluitend bestemd voor de geadresseerde. Openbaarmaking, vermenigvuldiging, verspreiding en/of verstrekking van deze informatie aan derden is, behoudens voorafgaande schriftelijke toestemming van Ernst Young, niet toegestaan. Ernst Young staat niet in voor de juiste en volledige overbrenging van de inhoud van een verzonden e-mailbericht, noch voor tijdige
RE: Re[2]:killing sessions
Dick, Sooo, you created a little Napolean? :) -Original Message- Sent: Thursday, July 11, 2002 4:53 PM To: Multiple recipients of list ORACLE-L Well, without getting into specifics. We had an individual who had a problem with others in the department. Now you I know that many times in development we create monsters. That's what the environment is for after all, create what you think the user wanted see how badly it behaves. Well this person's solution to the problem was to kill off other sessions that were viewed as resource hogs. Nuf Said?? Dick Goulet Reply Separator Author: Jack Silvey [EMAIL PROTECTED] Date: 7/11/2002 11:46 AM Dick, interesting. tell us why it was such a mess. regards, jack --- [EMAIL PROTECTED] wrote: NO, they want their session killed, then they can call. I did allow this a few years ago. It turned into a real mess, PERIOD. Dick Goulet Reply Separator Author: Joe Armstrong-Champ [EMAIL PROTECTED] Date: 7/11/2002 10:51 AM We have developers who occassionally want to be able to kill their sessions in a dev instance. We are concerned about giving them alter system priviledge and were wondering what people do about this. Is there any other way they can do this? Do some shops allow certain users to do this with some training? Thanks. Joe [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Armstrong-Champ INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Sign up for SBC Yahoo! Dial - First Month Free http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jack Silvey INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: RE: larry want to take over your e-mai
I have mixed feelings about this - I think this is pervasive within the high-tech industry, and my gut feeling is that it may help explain why tech stocks are so low. Do you think they (the industry leaders) will get the message? I seriously doubt it. Right now the focus seems to be on cutting staff and costs rather than improving products to build loyal customers and increase revenues. It's been like this for as long as I can remember. But the industry leaders are probably in a bind: Many high quality products disappeared because a cheaper alternative came on the market. Part of the problem is that people think short term, if they see a half-finished product at lower cost that markets itself as being the cheaper alternative for an expensive solution, purchasers tend to pick the cheaper option if they think they can live with it. In some cases if a well-known company says wait 6 months, we are working on this too and our product will amaze you, customers actually decide to postpone projects based on vaporware promises. Overall costs may actually be higher when cheaper alternatives are selected, but in many places no one is focused enough, wise enough or around long enough to do long-term assessments. In many cases it's because everyone is too busy to cross the t's and dot all the i's. It doesn't encourage vendors to build top-quality, long-lasting products. In my opinion. I also don't believe there is a real solution to this, most people are happy with the status quo. My CDN$0.02. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) -Original Message- Sent: Thursday, July 11, 2002 6:15 PM To: Multiple recipients of list ORACLE-L Subject:Re:RE: larry want to take over your e-mai Hannah, Friday is tomorrow, settle down everything will be all right. It's just his Bill complex showing through, you know that MicroSoft mantra, We will be everything to everyone. I'm still waiting for that piece of Windows software that insures my coffee cup remains full. At least the Oracle based one I developed warns me when it's half full and does not GPF in the process. :-) Dick Goulet Reply Separator Author: [EMAIL PROTECTED] Date: 7/11/2002 9:18 AM THAT DOES IT. I am starting training on DB2 right away (Yeah - I can actually AFFORD to no $2000 requirements!!). I want a DB that KNOWS its a DB and not an all-purpose quagmire of inter-related but not really related junk just because Larry has a Bill complex! Oracle and CHEAP cannot be used in the same sentence! Must have been a misquote...surpised they dont need a 5000 named user license! Argh.. mental meltdown in process. One... two deep breath Is it Friday yet? Hannah -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Oracle Licensing to be Transparent?
Evidently Oracle is going to build some web pages to spell out licensing issues and definitions. Wonder how often that web site will need to be updated. And of course everything will be crystal clear when it's done. ;-) Check it out... http://www.eweek.com/article2/0,3959,361471,00.asp Not sure if you need to subscribe to eWeek to see the above. Steve Orr -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Orr, Steve INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Buffer busy waits are 10.96% of non-idle waits
Hi, Your major problems with buffer busy waits are in the Data blocks class: (1), undo block(2), segment header (3) For Data block Class: Solution: 1. Reduce no of rows by changing pctfree/pctused 2. check when the last time your indexes were re-built and rebuild them often (indexes causing inserts into the same block will be reduced) For undo block class : Solution: 1. Increase the size of the rollbacksegment For segment header : Solution: 1. Add more freelists and or freelist group 2. Check your extent sizes (may be it is too small) - Hope this helps, Thanks, Kavi oraora oraora wrote: Hi Kavitha, querying v$waitstat gives me the o/p below. CLASS COUNT TIME -- -- -- data block 131525173 225446798 sort block 0 0 save undo block 0 0 segment header 4968 16264 save undo header0 0 free list 0 0 extent map 0 0 bitmap block0 0 bitmap index block 0 0 unused 0 0 system undo header 0 0 system undo block 0 0 undo header 1582 14 undo block 45965 3008 the data block above belongs to a datafile USERS01.DAT which has all the tables and indexes the application uses. the top 25 SQL statements are always SELECT statements. they get executed repeatedly. is it b'coz all SQLs are with literals and no bind variables ? it's a highly read OLTP system. will not -- using bind variables instead of literals -- seperating tables and indexes to diferent tabelspace solve my problem ? Regards, prem. On Fri, 12 Jul 2002 Kavitha Muthukumaren wrote : Hi , TOAD gives this alarm often. what does it mean ? which view will give me the wait statistics ? Answer : == Please run STATSPACK to if this is one of the top waitevents to check if the percentage of wait - can be treated as problematic one SELECT p1 File, p2 Block, p3 Reason FROM v$session_wait WHERE event='buffer busy waits' Repeatedly run the above statement and collect the output. After a period of time sort the results to see which file blocks are showing contention: it occurs when a session cannot access a block because it is in use by another session. The two most common causes are insufficient free lists for a table or insufficient rollback segments. --- IS THIS THE REASON ? Answer: == Yes on top of the wait event could also occur could also occur if a. if the application is going against a set of same blocks (hot blocks) Thanks, Kavi _ There is always a better job for you at Monsterindia.com. Go now http://monsterindia.rediff.com/jobs -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: oraora oraora INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). begin:vcard n:;Kavitha x-mozilla-html:FALSE adr:;; version:2.1 email;internet:[EMAIL PROTECTED] fn:Kavitha Muthukumaren end:vcard
Re: DOS Script for pop up question ?
Thanks for the Oracle list members who responded very promptly for my question. At the moment, I am very satisfied with pause command. I have one more question for the DOS Gurus. Is there a way to change the fond size from the DOS Script ? Thanks, Bob --- James J. Morrow [EMAIL PROTECTED] wrote: Bob Robert wrote: All, I have a DOS batch file. In between this script, I would like to add user interactive question. Ex: Do you want to Continue [Y/N]? Once they hit Y, it will continue rest of the batch file. Could someone able to help me out as per the above requirement? Thanks, Bob Well, the simplest answer would be to use the Pause command. This assumes, of course, that you don't really care what key they press... simply: echo Hit Control-C to abort or... pause Will return: Hit Control-C to abort or... Press any key to continue I'm pretty sure that the DOS batch language doesn't have any get keystroke functionality built-in. However, the CMD language might. A search on google for dos cmd batch get (http://www.google.com/search?sourceid=navclientq=dos+cmd+batch+get) yields this link: http://www.simtel.iif.hu/pub/msdos/batchutl/ Which has a whole slew of MS-DOS based utilities. I'm sure one of them would have a little *.exe that would read a line or a character from stdin. Additionally, you could consider Cygnus for Windows (aka Cygwin) available through redhat.com. Cygwin is a Windows tool that gives you Unix functionality. Including some of the popular unix shells for scripting (Bash, Tcsh). This product (free, as in beer) provides the same functionality as the (much more expensive) MKS Toolkit (available from MKS Software... http://www.mks.com). The MKS toolkit is required for Oracle Applications 11i on MS Windows NT/2000. http://freshmeat.net/projects/cygwin/?topic_id=45%2C74 or http://cygwin.com -- James James J. Morrow E-Mail: [EMAIL PROTECTED] Senior Principal Consultant Tenure Systems, Inc. McKinney, TX, USA The reasonable man adapts himself to the world: the unreasonable man persists in trying to adapt the world to himself. Therefore all progress depends on the unreasonable man. -- George Bernard Shaw -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: James J. Morrow INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Sign up for SBC Yahoo! Dial - First Month Free http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bob Robert INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: DOS Script for pop up question ?
I'm not a windows guy but I think you should quit writing DOS batch files and use VBScript instead. I think if you look in any windows magazine you will see VBScript listings instead of batch file listings. VBScript is powerful like Perl and handles pop up windows well. VBScript doesn't seem to email very well, however, because an earlier post I sent contained a simple VBScript demo in the body of the email and it got bounced from ORACLE-L because it contained a virus signature. So here's a link to some simple code you can try: http://www.devguru.com/Technologies/wsh/quickref/wshshell_Popup.html Save the code to a file with a .vbs extension and click the resulting icon. You can get a book or search the web for code snippets like I do. Have fun! Ed - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, July 11, 2002 4:37 PM All, I have a DOS batch file. In between this script, I would like to add user interactive question. Ex: Do you want to Continue [Y/N]? Once they hit Y, it will continue rest of the batch file. Could someone able to help me out as per the above requirement? Thanks, Bob __ Do You Yahoo!? Sign up for SBC Yahoo! Dial - First Month Free http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bob Robert INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Igor Neyman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sherman, Edward INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: order by in subquery workaround
Rob and Jack: Found it. (165420.1) Thanks for your help. Barb -- From: Robert Pegram[SMTP:[EMAIL PROTECTED]] Reply To: [EMAIL PROTECTED] Sent: Friday, July 12, 2002 6:48 AM To: Multiple recipients of list ORACLE-L Subject: Re: order by in subquery workaround I downloaded it from metalink a while back. It was pretty straight forward to install. The report name was something different like statsrep.sql or statsrep80.sql. Also, there was a view that had to be created. All the information/instructions were in the tar file that I downloaded. If you can't find it on metalink, let me know, and I will round up my old notes and the tar file and send it to you. Rob Pegram Oracle Certified DBA --- Jack van Zanen [EMAIL PROTECTED] wrote: Hi I have in the past seen a download for a backported statspack on I believe OTN. This would work on Oracle 8.0.5 Maybe still there Jack Baker, Barbara bbaker@denvernewspaper To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] agency.com cc: (bcc: Jack van Zanen/nlzanen1/External/MEY/NL) Sent by: Subject: order by in subquery workaround [EMAIL PROTECTED] 11-07-2002 19:38 Please respond to ORACLE-L Solaris 2.6 Oracle RDBMS v8.0.5.2.1 List: I'm trying to run a retrofit of statspack on an 8.0.5 database. (ya, I know. upgrading would actually be easier) The statspack stuff came from an 8.1.7 install I have on the same box. The spreport.sql report encounters errors in the order by clause. The problem is that you can't do an order by on a subquery before version 8.1.something-or-other I know there's some kind of work around for this. I had something to do with a hint. Even after 3 cups of coffee, I can't remember what it is. Can anyone help? Thanks! Barb here are the errors: Shared Pool StatisticsBegin End -- -- Memory Usage %: 75.99 70.05 % SQL with executions1: 21.95 48.60 % Memory for SQL w/exec1: 11.28 21.84 order by time desc, waits desc * ERROR at line 24: ORA-00907: missing right parenthesis pmon timer 1,184 1,177 355,304 3001 0.2 - order by (e.buffer_gets - nvl(b.buffer_gets,0)) desc, e.hash_value, st.piece * ERROR at line 41: ORA-00907: missing right parenthesis -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Baker, Barbara INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Triggers are getting disabled
We have a DW that gets refreshed each night. Many of the tables are truncated. Several times during the nightly processing dozens of triggers are becoming disabled. Can anyone tell me what causes a trigger to become disabled? Ron Smith -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Buffer busy waits are 10.96% of non-idle waits
Fro my clarity .. What does the extent size has to do with segment header contention. And about index rebuilds.. Why do u say that this will cause a Problem for the waits he is Experencing. Hope to get some clarity on this... Thanks Best Regards, Ganesh R Tel : +971 (4) 397 3337 Ext 420 Fax : +971 (4) 397 6262 HP : +971 (50) 745 6019 == Live to learn... forget... and learn again. == -Original Message- Muthukumaren Sent: Friday, July 12, 2002 6:13 PM To: Multiple recipients of list ORACLE-L Hi, Your major problems with buffer busy waits are in the Data blocks class: (1), undo block(2), segment header (3) For Data block Class: Solution: 1. Reduce no of rows by changing pctfree/pctused 2. check when the last time your indexes were re-built and rebuild them often (indexes causing inserts into the same block will be reduced) For undo block class : Solution: 1. Increase the size of the rollbacksegment For segment header : Solution: 1. Add more freelists and or freelist group 2. Check your extent sizes (may be it is too small) - Hope this helps, Thanks, Kavi oraora oraora wrote: Hi Kavitha, querying v$waitstat gives me the o/p below. CLASS COUNT TIME -- -- -- data block 131525173 225446798 sort block 0 0 save undo block 0 0 segment header 4968 16264 save undo header0 0 free list 0 0 extent map 0 0 bitmap block0 0 bitmap index block 0 0 unused 0 0 system undo header 0 0 system undo block 0 0 undo header 1582 14 undo block 45965 3008 the data block above belongs to a datafile USERS01.DAT which has all the tables and indexes the application uses. the top 25 SQL statements are always SELECT statements. they get executed repeatedly. is it b'coz all SQLs are with literals and no bind variables ? it's a highly read OLTP system. will not -- using bind variables instead of literals -- seperating tables and indexes to diferent tabelspace solve my problem ? Regards, prem. On Fri, 12 Jul 2002 Kavitha Muthukumaren wrote : Hi , TOAD gives this alarm often. what does it mean ? which view will give me the wait statistics ? Answer : == Please run STATSPACK to if this is one of the top waitevents to check if the percentage of wait - can be treated as problematic one SELECT p1 File, p2 Block, p3 Reason FROM v$session_wait WHERE event='buffer busy waits' Repeatedly run the above statement and collect the output. After a period of time sort the results to see which file blocks are showing contention: it occurs when a session cannot access a block because it is in use by another session. The two most common causes are insufficient free lists for a table or insufficient rollback segments. --- IS THIS THE REASON ? Answer: == Yes on top of the wait event could also occur could also occur if a. if the application is going against a set of same blocks (hot blocks) Thanks, Kavi _ There is always a better job for you at Monsterindia.com. Go now http://monsterindia.rediff.com/jobs -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: oraora oraora INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ganesh Raja INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Triggers are getting disabled
Triggers are disabled via ALTER TABLE...DISABLE TRIGGER... or ...DISABLE ALL TRIGGERS. It may well be that the refresh process issues such statements; reasons to do so might be to speed up the load process or if data populated by a trigger is already included in the data being loaded. If this is the case, any errors in the refresh process might cause the corresponding ENABLE statements not to be executed. Even if a trigger's PL/SQL code becomes invalid due to change to an object on which it depends, AFAIK that wouldn't set it to disabled. --- Smith, Ron L. [EMAIL PROTECTED] wrote: We have a DW that gets refreshed each night. Many of the tables are truncated. Several times during the nightly processing dozens of triggers are becoming disabled. Can anyone tell me what causes a trigger to become disabled? Ron Smith -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Sign up for SBC Yahoo! Dial - First Month Free http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Baumgartel INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Oracle Licensing to be Transparent?
Kimberly Floss, database administrator team leader at Quaker Oats Co., in Chicago, said she hopes the guide helps resolve Oracle's issues. Floss, who manages Oracle databases, has not had licensing problems herself ... She obviously has never been involved in any Oracle licensing discussions. Ever try to get more than 1 Oracle employee to give you the same answer on this topic? Especially when it comes to clusters and web servers. Sometimes, even the simple definition of a user elicits hours of debate. These web pages will certainly provide fodder for this list! [EMAIL PROTECTED] 07/12/02 10:43AM Evidently Oracle is going to build some web pages to spell out licensing issues and definitions. Wonder how often that web site will need to be updated. And of course everything will be crystal clear when it's done. ;-) Check it out... http://www.eweek.com/article2/0,3959,361471,00.asp Not sure if you need to subscribe to eWeek to see the above. Steve Orr -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Orr, Steve INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). **DISCLAIMER This e-mail message and any files transmitted with it are intended for the use of the individual or entity to which they are addressed and may contain information that is privileged, proprietary and confidential. If you are not the intended recipient, you may not use, copy or disclose to anyone the message or any information contained in the message. If you have received this communication in error, please notify the sender and delete this e-mail message. The contents do not represent the opinion of DE except to the extent that it relates to their official business. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jay Hostetter INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: order by in subquery workaround
For databases 8i you need to run statsrep80.sql Babu Jack van Zanen [EMAIL PROTECTED]@fatcity.com on 07/12/2002 02:53:21 AM Please respond to [EMAIL PROTECTED] Sent by:[EMAIL PROTECTED] To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Hi I have in the past seen a download for a backported statspack on I believe OTN. This would work on Oracle 8.0.5 Maybe still there Jack Baker, Barbara bbaker@denvernewspaperTo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] agency.comcc: (bcc: Jack van Zanen/nlzanen1/External/MEY/NL) Sent by: Subject: order by in subquery workaround [EMAIL PROTECTED] 11-07-2002 19:38 Please respond to ORACLE-L Solaris 2.6 Oracle RDBMS v8.0.5.2.1 List: I'm trying to run a retrofit of statspack on an 8.0.5 database. (ya, I know. upgrading would actually be easier) The statspack stuff came from an 8.1.7 install I have on the same box. The spreport.sql report encounters errors in the order by clause. The problem is that you can't do an order by on a subquery before version 8.1.something-or-other I know there's some kind of work around for this. I had something to do with a hint. Even after 3 cups of coffee, I can't remember what it is. Can anyone help? Thanks! Barb here are the errors: Shared Pool StatisticsBegin End -- -- Memory Usage %: 75.99 70.05 % SQL with executions1: 21.95 48.60 % Memory for SQL w/exec1: 11.28 21.84 order by time desc, waits desc * ERROR at line 24: ORA-00907: missing right parenthesis pmon timer 1,184 1,177 355,304 3001 0.2 - order by (e.buffer_gets - nvl(b.buffer_gets,0)) desc, e.hash_value, st.piece * ERROR at line 41: ORA-00907: missing right parenthesis -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Baker, Barbara INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). === De informatie verzonden in dit e-mailbericht is vertrouwelijk en is uitsluitend bestemd voor de geadresseerde. Openbaarmaking, vermenigvuldiging, verspreiding en/of verstrekking van deze informatie aan derden is, behoudens voorafgaande schriftelijke toestemming van Ernst Young, niet toegestaan. Ernst Young staat niet in voor de juiste en volledige overbrenging van de inhoud van een verzonden e-mailbericht, noch voor tijdige ontvangst daarvan. Ernst Young kan niet garanderen dat een verzonden e-mailbericht vrij is van virussen, noch dat e-mailberichten worden overgebracht zonder inbreuk of tussenkomst van onbevoegde derden. Indien bovenstaand e-mailbericht niet aan u is gericht, verzoeken wij u vriendelijk doch dringend het e-mailbericht te retourneren aan de verzender en het origineel en eventuele kopieën te verwijderen en te vernietigen. Ernst Young hanteert bij de uitoefening van haar werkzaamheden algemene voorwaarden, waarin een beperking van aansprakelijkheid is opgenomen. De algemene voorwaarden worden u op verzoek kosteloos toegezonden. = The information contained in this communication is confidential and is intended solely for the use of the individual or entity to whom it is addressed. You should not copy, disclose or distribute this communication without the authority of Ernst Young. Ernst Young is neither liable for the proper and complete transmission of the information contained in this communication nor for any delay in its receipt. Ernst Young does not guarantee that the integrity of this communication has been maintained nor that the communication is free of viruses, interceptions or interference. If you are not the intended recipient of this communication please return the communication to the sender and delete and destroy all copies. In carrying out its engagements, Ernst Young applies general terms and conditions, which contain a clause that limits its liability. A copy of these terms and conditions is available on request free of charge.
Re[2]: Oracle Licensing to be Transparent?
I leave licensing discussions to the company CIO Lawyers. Way too complicated for me. Reply Separator Author: Jay Hostetter [EMAIL PROTECTED] Date: 7/12/2002 8:23 AM Kimberly Floss, database administrator team leader at Quaker Oats Co., in Chicago, said she hopes the guide helps resolve Oracle's issues. Floss, who manages Oracle databases, has not had licensing problems herself ... She obviously has never been involved in any Oracle licensing discussions. Ever try to get more than 1 Oracle employee to give you the same answer on this topic? Especially when it comes to clusters and web servers. Sometimes, even the simple definition of a user elicits hours of debate. These web pages will certainly provide fodder for this list! [EMAIL PROTECTED] 07/12/02 10:43AM Evidently Oracle is going to build some web pages to spell out licensing issues and definitions. Wonder how often that web site will need to be updated. And of course everything will be crystal clear when it's done. ;-) Check it out... http://www.eweek.com/article2/0,3959,361471,00.asp Not sure if you need to subscribe to eWeek to see the above. Steve Orr -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Orr, Steve INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). **DISCLAIMER This e-mail message and any files transmitted with it are intended for the use of the individual or entity to which they are addressed and may contain information that is privileged, proprietary and confidential. If you are not the intended recipient, you may not use, copy or disclose to anyone the message or any information contained in the message. If you have received this communication in error, please notify the sender and delete this e-mail message. The contents do not represent the opinion of DE except to the extent that it relates to their official business. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jay Hostetter INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: RE: larry want to take over your e-mai
Patrice - I especially agree with your last statement don't believe there is a real solution to this. Remember a technology vendor has 3 constituents, all of whom think they are the most important: stockholders, employees, customers. I have noticed that previous slumps in technology sales have tended to correlate with periods where there aren't compelling new products to be purchased. We could all run our current products for years to come, but then that wouldn't produce any new sales would it? In the short term about all a vendor can do to show its stockholders is cut employees in response to falling revenues. Eventually new products will appear, but that takes much longer and if the company goes out of business before then, it is rather moot. Dennis Williams DBA, 20% OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, July 12, 2002 8:58 AM To: Multiple recipients of list ORACLE-L I have mixed feelings about this - I think this is pervasive within the high-tech industry, and my gut feeling is that it may help explain why tech stocks are so low. Do you think they (the industry leaders) will get the message? I seriously doubt it. Right now the focus seems to be on cutting staff and costs rather than improving products to build loyal customers and increase revenues. It's been like this for as long as I can remember. But the industry leaders are probably in a bind: Many high quality products disappeared because a cheaper alternative came on the market. Part of the problem is that people think short term, if they see a half-finished product at lower cost that markets itself as being the cheaper alternative for an expensive solution, purchasers tend to pick the cheaper option if they think they can live with it. In some cases if a well-known company says wait 6 months, we are working on this too and our product will amaze you, customers actually decide to postpone projects based on vaporware promises. Overall costs may actually be higher when cheaper alternatives are selected, but in many places no one is focused enough, wise enough or around long enough to do long-term assessments. In many cases it's because everyone is too busy to cross the t's and dot all the i's. It doesn't encourage vendors to build top-quality, long-lasting products. In my opinion. I also don't believe there is a real solution to this, most people are happy with the status quo. My CDN$0.02. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) -Original Message- Sent: Thursday, July 11, 2002 6:15 PM To: Multiple recipients of list ORACLE-L Subject:Re:RE: larry want to take over your e-mai Hannah, Friday is tomorrow, settle down everything will be all right. It's just his Bill complex showing through, you know that MicroSoft mantra, We will be everything to everyone. I'm still waiting for that piece of Windows software that insures my coffee cup remains full. At least the Oracle based one I developed warns me when it's half full and does not GPF in the process. :-) Dick Goulet Reply Separator Author: [EMAIL PROTECTED] Date: 7/11/2002 9:18 AM THAT DOES IT. I am starting training on DB2 right away (Yeah - I can actually AFFORD to no $2000 requirements!!). I want a DB that KNOWS its a DB and not an all-purpose quagmire of inter-related but not really related junk just because Larry has a Bill complex! Oracle and CHEAP cannot be used in the same sentence! Must have been a misquote...surpised they dont need a 5000 named user license! Argh.. mental meltdown in process. One... two deep breath Is it Friday yet? Hannah -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). --
RE: Triggers are getting disabled
Do triggers fire when using direct load? -Original Message- Sent: Friday, July 12, 2002 11:13 AM To: Multiple recipients of list ORACLE-L Triggers are disabled via ALTER TABLE...DISABLE TRIGGER... or ...DISABLE ALL TRIGGERS. It may well be that the refresh process issues such statements; reasons to do so might be to speed up the load process or if data populated by a trigger is already included in the data being loaded. If this is the case, any errors in the refresh process might cause the corresponding ENABLE statements not to be executed. Even if a trigger's PL/SQL code becomes invalid due to change to an object on which it depends, AFAIK that wouldn't set it to disabled. --- Smith, Ron L. [EMAIL PROTECTED] wrote: We have a DW that gets refreshed each night. Many of the tables are truncated. Several times during the nightly processing dozens of triggers are becoming disabled. Can anyone tell me what causes a trigger to become disabled? Ron Smith -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Sign up for SBC Yahoo! Dial - First Month Free http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Baumgartel INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
My TAR button disappeared from MetaLink
I clicked on a URL link in an e-mail from Oracle support, and got an error message telling me I have no privs to view the document. I logged into Metalink, and noticed that there is no TAR section in the right pane, as I usually have. There also is no TAR button in the left pane, I remember there being one there but my memory may be wrong... ??? I submitted MetaLink feedback. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Re[2]: Oracle Licensing to be Transparent?
License,,, license We don't need no stinkin license. -Original Message- Sent: Friday, July 12, 2002 11:59 AM To: Multiple recipients of list ORACLE-L I leave licensing discussions to the company CIO Lawyers. Way too complicated for me. Reply Separator Author: Jay Hostetter [EMAIL PROTECTED] Date: 7/12/2002 8:23 AM Kimberly Floss, database administrator team leader at Quaker Oats Co., in Chicago, said she hopes the guide helps resolve Oracle's issues. Floss, who manages Oracle databases, has not had licensing problems herself ... She obviously has never been involved in any Oracle licensing discussions. Ever try to get more than 1 Oracle employee to give you the same answer on this topic? Especially when it comes to clusters and web servers. Sometimes, even the simple definition of a user elicits hours of debate. These web pages will certainly provide fodder for this list! [EMAIL PROTECTED] 07/12/02 10:43AM Evidently Oracle is going to build some web pages to spell out licensing issues and definitions. Wonder how often that web site will need to be updated. And of course everything will be crystal clear when it's done. ;-) Check it out... http://www.eweek.com/article2/0,3959,361471,00.asp Not sure if you need to subscribe to eWeek to see the above. Steve Orr -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Orr, Steve INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). **DISCLAIMER This e-mail message and any files transmitted with it are intended for the use of the individual or entity to which they are addressed and may contain information that is privileged, proprietary and confidential. If you are not the intended recipient, you may not use, copy or disclose to anyone the message or any information contained in the message. If you have received this communication in error, please notify the sender and delete this e-mail message. The contents do not represent the opinion of DE except to the extent that it relates to their official business. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jay Hostetter INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Farnsworth, Dave INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: My TAR button disappeared from MetaLink
This usually happens if you have not paid your support bill. Srini Chavali Oracle DBA Cummins Inc Boivin, Patrice J [EMAIL PROTECTED]@fatcity.com on 07/12/2002 12:24:21 PM Please respond to [EMAIL PROTECTED] Sent by:[EMAIL PROTECTED] To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: I clicked on a URL link in an e-mail from Oracle support, and got an error message telling me I have no privs to view the document. I logged into Metalink, and noticed that there is no TAR section in the right pane, as I usually have. There also is no TAR button in the left pane, I remember there being one there but my memory may be wrong... ??? I submitted MetaLink feedback. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: RE: larry want to take over your e-mai
Yes, but once you become dependent on the M$ keep the coffee cup full software, then they force you to upgrade at a significant cost and cause your blood pressure to soar with the new feature that refuses to fill your cup because your blood pressure has gotten too high (damn product liability lawyers anyway)... Kevin Kennedy First Point Energy Corporation -Original Message- Sent: Thursday, July 11, 2002 2:15 PM To: Multiple recipients of list ORACLE-L Hannah, Friday is tomorrow, settle down everything will be all right. It's just his Bill complex showing through, you know that MicroSoft mantra, We will be everything to everyone. I'm still waiting for that piece of Windows software that insures my coffee cup remains full. At least the Oracle based one I developed warns me when it's half full and does not GPF in the process. :-) Dick Goulet Reply Separator Author: [EMAIL PROTECTED] Date: 7/11/2002 9:18 AM THAT DOES IT. I am starting training on DB2 right away (Yeah - I can actually AFFORD to no $2000 requirements!!). I want a DB that KNOWS its a DB and not an all-purpose quagmire of inter-related but not really related junk just because Larry has a Bill complex! Oracle and CHEAP cannot be used in the same sentence! Must have been a misquote...surpised they dont need a 5000 named user license! Argh.. mental meltdown in process. One... two deep breath Is it Friday yet? Hannah -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: kkennedy INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Oracle Trace Collection Services
I have a third party app that runs on Oracle 7.3.4 on Windoze. The app is getting some error and the vendor recommends that we uninstall the Oracle Trace Collection services from each client. If this is removed from the client will I lose my ability to run traces on a clients session?? Dave -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Farnsworth, Dave INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Why DDL is not allowed in PL/SQL
You can also use execute immediate in PL/SQL, depending on the version of Oracle you are running. RF Robert G. Freeman - Oracle8i OCP Oracle Database Architect CSX Midtier Database Administration Author: Oracle9i RMAN Backup and Recovery (NEW! Oracle Press - Due Oct 2002!!) Oracle9i New Features Mastering Oracle8i Clark Griswold: Eddie, has anyone ever told you that you're bad luck? Cousin Eddie: Those were my mother's dying words. But I guess if your body's covered in third degree burns, and your foot's caught in a bear trap, you tend to start talkin' crazy. -Original Message- Sent: Friday, July 12, 2002 3:03 AM To: Multiple recipients of list ORACLE-L Maybe it is to maintain transaction consistency, bcos the DDLs issue a commit implicitly. So if u do in the middle of DML-transaction it might mess up the transaction as a whole. -Original Message- Sent: Friday, July 12, 2002 10:58 AM To: Multiple recipients of list ORACLE-L Hi List, Why it is not allowed to write DDL(e.g. create table) in PL/SQL directly, but same can be done using DBMS_SQL package. Curious Sam __ Do You Yahoo!? Sign up for SBC Yahoo! Dial - First Month Free http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: sam d INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alroy Mascranghe INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Freeman, Robert INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Buffer busy waits are 10.96% of non-idle waits
Hi Ganesh, First of all the problem here is Buffer busy waits When you have determined the Buffer busy waits is one of the top wait events causing problems then 1. You could query v$waitstat to see the breakdown of waits according to 'class' 2. You could query x$KCBFWAIT to find the hottest file 3. Combine the results and you cuold find out the 'objects' involved 4. In oraora oraora (prem) case Top ' classes' were Data blocks(1), undo header (2) segment header(3) Question : === What does the extent size has to do with segment header contention. There is no segment header contention , this is Buffer Busy waits problem Answer: == Segment header class being one of the top class == to avoid this wait in the future the following needs to be performed a. Adding more free lists (since you did not have enough freelists to keep with the insert) b. Extent sizes of the involved objects were small (tables keeps growing) therefore increasing the extent sixes would also help Question : === And about index rebuilds.. Why do u say that this will cause a Problem for the waits he is Experencing. Data block Class: was one of the top waits Solution: == 1. Technically it is called right-hand indexes because of which above wait of the data block class occurs to avoid this rebuild indexes or choose some other type of indexes like reverse key indexes - Hope it is clear now Thanks, Kavi Ganesh Raja wrote: Fro my clarity .. What does the extent size has to do with segment header contention. And about index rebuilds.. Why do u say that this will cause a Problem for the waits he is Experencing. Hope to get some clarity on this... Thanks Best Regards, Ganesh R Tel : +971 (4) 397 3337 Ext 420 Fax : +971 (4) 397 6262 HP : +971 (50) 745 6019 == Live to learn... forget... and learn again. == -Original Message- Muthukumaren Sent: Friday, July 12, 2002 6:13 PM To: Multiple recipients of list ORACLE-L Hi, Your major problems with buffer busy waits are in the Data blocks class: (1), undo block(2), segment header (3) For Data block Class: Solution: 1. Reduce no of rows by changing pctfree/pctused 2. check when the last time your indexes were re-built and rebuild them often (indexes causing inserts into the same block will be reduced) For undo block class : Solution: 1. Increase the size of the rollbacksegment For segment header : Solution: 1. Add more freelists and or freelist group 2. Check your extent sizes (may be it is too small) - Hope this helps, Thanks, Kavi oraora oraora wrote: Hi Kavitha, querying v$waitstat gives me the o/p below. CLASS COUNT TIME -- -- -- data block 131525173 225446798 sort block 0 0 save undo block 0 0 segment header 4968 16264 save undo header0 0 free list 0 0 extent map 0 0 bitmap block0 0 bitmap index block 0 0 unused 0 0 system undo header 0 0 system undo block 0 0 undo header 1582 14 undo block 45965 3008 the data block above belongs to a datafile USERS01.DAT which has all the tables and indexes the application uses. the top 25 SQL statements are always SELECT statements. they get executed repeatedly. is it b'coz all SQLs are with literals and no bind variables ? it's a highly read OLTP system. will not -- using bind variables instead of literals -- seperating tables and indexes to diferent tabelspace solve my problem ? Regards, prem. On Fri, 12 Jul 2002 Kavitha Muthukumaren wrote : Hi , TOAD gives this alarm often. what does it mean ? which view will give me the wait statistics ? Answer : == Please run STATSPACK to if this is one of the top waitevents to check if the percentage of wait - can be treated as problematic one SELECT p1 File, p2 Block, p3 Reason FROM v$session_wait WHERE event='buffer busy waits' Repeatedly run the above statement and collect the output. After a period of time sort the results to see which file blocks are showing contention: it occurs when a session cannot access a block because it is in use by another session. The two most common causes are insufficient free lists for a table or insufficient rollback segments. --- IS THIS THE REASON ? Answer: == Yes on top of the wait event could also occur could also occur if a. if the application is going
RE: Plagiarism?
Not many things in this life are certain, but I'll guarantee you one thing: if there's a script at Ixora with Steve Adams' name on it, then that script was written by Steve Adams. Yea, and Steve is such a nice guy I'm fairly certain all they would have to do is ask and he'd give them permission to use it. RF Robert G. Freeman - Oracle8i OCP Oracle Database Architect CSX Midtier Database Administration Author: Oracle9i New Features Mastering Oracle8i Clark Griswold: Eddie, has anyone ever told you that you're bad luck? Cousin Eddie: Those were my mother's dying words. But I guess if your body's covered in third degree burns, and your foot's caught in a bear trap, you tend to start talkin' crazy. -Original Message- Sent: Thursday, July 11, 2002 4:11 PM To: Multiple recipients of list ORACLE-L Looks like the searchdatabase copy has disappeared already. Not many things in this life are certain, but I'll guarantee you one thing: if there's a script at Ixora with Steve Adams' name on it, then that script was written by Steve Adams. Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com Upcoming events: - Hotsos Clinic, Jul 23-25 Chicago - Miracle Database Forum, Sep 20-22 Middlefart Denmark - 2003 Hotsos Symposium on OracleR System Performance, Feb 9-12 Dallas -Original Message- Ethan Sent: Thursday, July 11, 2002 2:25 PM To: Multiple recipients of list ORACLE-L http://searchdatabase.techtarget.com/tip/0,289483,sid13_gci832443,00.htm l http://ixora.com.au/scripts/sql/dd_cluster_sizes.sql Humm...my money is on Steve as the original author. - Ethan -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Post, Ethan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cary Millsap INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Freeman, Robert INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle 9.2 spfile catch 22
I've created SPFiles withe 9.2 on NT with log_archive_start=TRUE and not had this problem. If you have log_archive_start=FALSE and you want to change your spfile, then use alter system log_archive_start=TRUE scope=spfile; Robert G. Freeman - Oracle8i OCP Oracle Database Architect CSX Midtier Database Administration Author Oracle9i RMAN Backup and Recovery (Oracle Press - Oct 2002) Oracle9i New Features (Oracle Press) Mastering Oracle8i (Sybex) Clark Griswold: Eddie, has anyone ever told you that you're bad luck? Cousin Eddie: Those were my mother's dying words. But I guess if your body's covered in third degree burns, and your foot's caught in a bear trap, you tend to start talkin' crazy. -Original Message- Sent: Thursday, July 11, 2002 1:49 PM To: Multiple recipients of list ORACLE-L Thanks to everyone for the ideas on the init.ora. You were correct that the answer is indeed with spfile. Now I have discovered a catch-22. Oracle 9.2, Solaris 1. If spfile is created with LOG_ARCHIVE_START = true, database will not start. Receive the error ORA-00439 feature not enabled: Managed Standby 2. Creating the spfile with LOG_ARCHIVE_START = false works and the database starts. Issuing ALTER SYSTEM ARCHIVE LOG START works, but it isn't changed in the spfile, so the next time Oracle is bounced, the archiver doesn't start. This is starting to smell like a bug, but I thought I'd run it past the list on the off-chance someone else has gotten archiving turned on for 9.2. Thanks. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Freeman, Robert INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Where is Oracle 9.2 init.ora?
Oracle will use the spfile by default, only if there is one. If there isn't and there is an initsid.ora, Oracle will use it. In many cases, you can even start Oracle without an init file at all (for example in a disaster recovery and you want to recover your spfile from an RMAN control file backup), if your system can handle the parameter default settings. RF Robert G. Freeman - Oracle OCP Oracle Database Architect CSX Midtier Database Administration Author Oracle9i RMAN Backup and Recovery (Oracle Press - Oct 2002) Oracle9i New Features (Oracle Press) Mastering Oracle8i (Sybex) Clark Griswold: Eddie, has anyone ever told you that you're bad luck? Cousin Eddie: Those were my mother's dying words. But I guess if your body's covered in third degree burns, and your foot's caught in a bear trap, you tend to start talkin' crazy. -Original Message- Sent: Thursday, July 11, 2002 12:40 PM To: Multiple recipients of list ORACLE-L On Thu, 11 Jul 2002 07:43:27 -0800, you wrote: For Oracle 9.2 (Solaris), can anyone tell me where Oracle is expecting the init.ora file? By default, Oracle reads init parms from the new SPFILE. You need to use new ALTER DATABASE (or is it ALTER SYSTEM?) syntax now in order to change parameter settings. Jonathan Gennick --- Brighten the corner where you are mailto:[EMAIL PROTECTED] * 906.387.1698 http://Gennick.com * http://MichiganWaterfalls.com * http://ValleySpur.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jonathan Gennick INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Freeman, Robert INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re:RE: RE: larry want to take over your e-mai
Kevin, I don't think M$ cares about product liability. If they did Uncle Bill would not be so rich the lawyers would be camped out on his door step. Actually if you look at your license agreement with M$ you've already waived your rights there. Dick Goulet Reply Separator Author: kkennedy [EMAIL PROTECTED] Date: 7/12/2002 10:03 AM Yes, but once you become dependent on the M$ keep the coffee cup full software, then they force you to upgrade at a significant cost and cause your blood pressure to soar with the new feature that refuses to fill your cup because your blood pressure has gotten too high (damn product liability lawyers anyway)... Kevin Kennedy First Point Energy Corporation -Original Message- Sent: Thursday, July 11, 2002 2:15 PM To: Multiple recipients of list ORACLE-L Hannah, Friday is tomorrow, settle down everything will be all right. It's just his Bill complex showing through, you know that MicroSoft mantra, We will be everything to everyone. I'm still waiting for that piece of Windows software that insures my coffee cup remains full. At least the Oracle based one I developed warns me when it's half full and does not GPF in the process. :-) Dick Goulet Reply Separator Author: [EMAIL PROTECTED] Date: 7/11/2002 9:18 AM THAT DOES IT. I am starting training on DB2 right away (Yeah - I can actually AFFORD to no $2000 requirements!!). I want a DB that KNOWS its a DB and not an all-purpose quagmire of inter-related but not really related junk just because Larry has a Bill complex! Oracle and CHEAP cannot be used in the same sentence! Must have been a misquote...surpised they dont need a 5000 named user license! Argh.. mental meltdown in process. One... two deep breath Is it Friday yet? Hannah -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: kkennedy INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: What you've always wanted to know about Oracle DBAing
When will my Oracle stock go above 40 again? Robert G. Freeman - Oracle OCP Oracle Database Architect CSX Midtier Database Administration Author Oracle9i RMAN Backup and Recovery (Oracle Press - Oct 2002) Oracle9i New Features (Oracle Press) Mastering Oracle8i (Sybex) Clark Griswold: Eddie, has anyone ever told you that you're bad luck? Cousin Eddie: Those were my mother's dying words. But I guess if your body's covered in third degree burns, and your foot's caught in a bear trap, you tend to start talkin' crazy. -Original Message- Sent: Thursday, July 11, 2002 9:53 AM To: Multiple recipients of list ORACLE-L I'm doing some research into questions Oracle DBAs would like to find answers/solutions to but for some reason, no time, bumped to a lower priority etc. they have not had time to find out. If you have a list of such (Oracle DBA related!) questions, restrict to your top 10 where necessary, I'd appreciate folk sending them directly to me. So whether you be a newbie or go back as far as Oracle 6 (or earlier!) dredge your memory banks and send 'em on. - Seán O' Neill Organon (Ireland) Ltd. [subscribed: digest mode] This message, including attached files, may contain confidential information and is intended only for the use by the individual and/or the entity to which it is addressed. Any unauthorized use, dissemination of, or copying of the information contained herein is not allowed and may lead to irreparable harm and damage for which you may be held liable. If you receive this message in error or if it is intended for someone else please notify the sender by returning this e-mail immediately and delete the message. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: O'Neill, Sean INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Freeman, Robert INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Where is Oracle 9.2 init.ora?
The creation of the spfile by the DBCA is optional, BTW, in 9iR1 and 9iR2.
There is a checkbox where you can disable the use of the SPFILE.
Robert G. Freeman - Oracle OCP
Oracle Database Architect
CSX Midtier Database Administration
Author
Oracle9i RMAN Backup and Recovery (Oracle Press - Oct 2002)
Oracle9i New Features (Oracle Press)
Mastering Oracle8i (Sybex)
Clark Griswold: Eddie, has anyone ever told you that you're bad luck?
Cousin Eddie: Those were my mother's dying words. But I
guess if your body's covered in third degree burns, and
your foot's caught in a bear trap, you tend to start talkin'
crazy.
-Original Message-
Sent: Thursday, July 11, 2002 12:40 PM
To: Multiple recipients of list ORACLE-L
Dennis,
the info you are looking for can be found in the IOUG Select Nov
2001 magazine.
Spfile is a new form of the INIT.ORA file, which is a binary file.
the default location is in $ORACLE_HOME/dbs/spfileSID.ora. The spfile
contains all of the initialization parameters that are currently set in
the online database. When setting a dynamic initialization parameter,
you have the option of setting it's scope, i.e. Memory memory only,
spfile only, or both.
The spfile can be recreated from the pfile and vice versa.
=== ALTER SYSTEM SET parameter
===COMMENT='This is the reason for setting it'
===SCOPE=[MEMORY,SPFILE,BOTH];
The default behavior is to use the SPFILE instead of the pfile.
===CREATE SPFILE[=''] FROM PFILE[='...']
===CREATE PFILE[='...'] FROM SPFILE[='']
additional information can be found in
V$SPFILE
V$SPPARAMETER
V$PARAMETER
V$PARAMETER2
From what I have read and understand you have to activate the
changes in the pfile by creating the spfile and then bouonce the DB to
activate it.
HTH
ROR mª¿ªm
[EMAIL PROTECTED] 07/11/02 12:09PM
GOTCHA!
The dbca also created an SP file for you.
I was stumped by it too after doing my initial V9.2 install.
I forget the actual name, but this should give you enough of
a clue so you can get moving again.
HTH YMV!
DENNIS WILLIAMS wrote:
For Oracle 9.2 (Solaris), can anyone tell me where Oracle is
expecting the
init.ora file?
I created the database using dbca. It created an init.ora in
admin/{db_name}/pfile. I moved this to $ORACLE_HOME/dbs and renamed
the
original init.ora file. Then I discovered that Oracle is not reading
the new
init.ora. The database starts fine, with no errors. I tried moving
the
init.ora file back to the original pfile location, but it is still
not
reading it. Specifically, I am trying to set LOG_ARCHIVE_START =
true, but I
have made other changes and they are not taking effect either.
I have searched the documentation, and while there is the new SPFILE,
there
is no indication how this might affect my problem.
Any insights from someone that has turned archiving on with 9.2 would
be
appreciated.
Dennis Williams
DBA, 20% OCP
Lifetouch, Inc.
[EMAIL PROTECTED]
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: DENNIS WILLIAMS
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing
Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Charlie Mengler Maintenance Warehouse
[EMAIL PROTECTED] 10641 Scripps Summit
Ct.
858-831-2229 San Diego, CA 92131
Lack of planning on your part doesn't constitute an emergency on my
part!
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Charlie Mengler
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Ron Rogers
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of
RE: Plagiarism?
It was obviously written by Steve, I just couldn't believe that the guy posting the script literally removed the copywriter, replaced Steve's name with his own then submitted it to a web site, which then went out in their newsletter. Pretty brash I thought and I wonder what could possibly be the motivation for such a thing. Ethan Post perotdba (AIM), epost1 (Yahoo) -Original Message- Sent: Friday, July 12, 2002 1:49 PM To: Multiple recipients of list ORACLE-L Not many things in this life are certain, but I'll guarantee you one thing: if there's a script at Ixora with Steve Adams' name on it, then that script was written by Steve Adams. Yea, and Steve is such a nice guy I'm fairly certain all they would have to do is ask and he'd give them permission to use it. RF Robert G. Freeman - Oracle8i OCP Oracle Database Architect CSX Midtier Database Administration Author: Oracle9i New Features Mastering Oracle8i Clark Griswold: Eddie, has anyone ever told you that you're bad luck? Cousin Eddie: Those were my mother's dying words. But I guess if your body's covered in third degree burns, and your foot's caught in a bear trap, you tend to start talkin' crazy. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Post, Ethan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Where is Oracle 9.2 init.ora?
Oracle created the SPFILE which is not humanly readable.
Mine is pretty easy to read! Maybe you need to check your character set???
:-))
RF
Robert G. Freeman - Oracle OCP
Oracle Database Architect
CSX Midtier Database Administration
Author
Oracle9i RMAN Backup and Recovery (Oracle Press - Oct 2002)
Oracle9i New Features (Oracle Press)
Mastering Oracle8i (Sybex)
Clark Griswold: Eddie, has anyone ever told you that you're bad luck?
Cousin Eddie: Those were my mother's dying words. But I
guess if your body's covered in third degree burns, and
your foot's caught in a bear trap, you tend to start talkin'
crazy.
-Original Message-
Sent: Thursday, July 11, 2002 12:09 PM
To: Multiple recipients of list ORACLE-L
Dennis,
Oracle created the SPFILE which is not humanly readable. There should
be an
alter database/system command that does the change for you. According to
what I
heard at Oratechs 2000 editing the init.ora file is now longer effective.
Dick Goulet
Reply Separator
Author: DENNIS WILLIAMS [EMAIL PROTECTED]
Date: 7/11/2002 7:43 AM
For Oracle 9.2 (Solaris), can anyone tell me where Oracle is expecting the
init.ora file?
I created the database using dbca. It created an init.ora in
admin/{db_name}/pfile. I moved this to $ORACLE_HOME/dbs and renamed the
original init.ora file. Then I discovered that Oracle is not reading the new
init.ora. The database starts fine, with no errors. I tried moving the
init.ora file back to the original pfile location, but it is still not
reading it. Specifically, I am trying to set LOG_ARCHIVE_START = true, but I
have made other changes and they are not taking effect either.
I have searched the documentation, and while there is the new SPFILE, there
is no indication how this might affect my problem.
Any insights from someone that has turned archiving on with 9.2 would be
appreciated.
Dennis Williams
DBA, 20% OCP
Lifetouch, Inc.
[EMAIL PROTECTED]
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: DENNIS WILLIAMS
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Freeman, Robert
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
RE: Oracle 9i Release 2 RAC on Linux Cluster RH7.3
I know a certain 9i New Features book that could have helped you with that... :-)) Have a nice chapter on 9i and RAC. RF Robert G. Freeman - Oracle OCP Oracle Database Architect CSX Midtier Database Administration Author Oracle9i RMAN Backup and Recovery (Oracle Press - Oct 2002) Oracle9i New Features (Oracle Press) Mastering Oracle8i (Sybex) Clark Griswold: Eddie, has anyone ever told you that you're bad luck? Cousin Eddie: Those were my mother's dying words. But I guess if your body's covered in third degree burns, and your foot's caught in a bear trap, you tend to start talkin' crazy. -Original Message- Sent: Wednesday, July 10, 2002 9:13 AM To: Multiple recipients of list ORACLE-L Hi Bill I RTFM'd (dig through all sorts of readme, whitepapers and forums) and found the command alter system...yadayaya scope=spfile sid='SID'; TIA Jack Jack van Zanen [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent by: cc: (bcc: Jack van Zanen/nlzanen1/External/MEY/NL) [EMAIL PROTECTED] Subject: Re: Oracle 9i Release 2 RAC on Linux Cluster RH7.3 10-07-2002 10:33 Please respond to ORACLE-L Hi Bill, we use a shared SPFILE for these two instances. How can we specify local_listener for each specific instance TIA Jack Bill Pass [EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: (bcc: Jack van Zanen/nlzanen1/External/MEY/NL) Sent by: Subject: Re: Oracle 9i Release 2 RAC on Linux Cluster RH7.3 [EMAIL PROTECTED] 09-07-2002 17:28 Please respond to ORACLE-L Had same problem on 9.0.1.3. Ended up being that you had to specify a LOCAL_LISTENER parameter even though it defaults to a reasonable value. The value must be one that is resolvable by all parties (clients and servers)via /etc/hosts or DNS. This is due to the manner in which redirects are done. Bill --- Jack van Zanen [EMAIL PROTECTED] wrote: Hi All, I have a question regarding setup of above. We have the above database setup working except for connecting from the clientfails every now and then. We have load balancing turned on on the client so that it alternates connection between the two servers. We think we have load balancing turned on on the servers (but documentation is somewhat confusing on the proper setup) If we connect from the client it sometimes succeeds and sometimes fails with different messages on diefferent clients(but always the same message on the same client) - No listener or - No connect_data received the succesfull connections are not just to one instance but both instances have succesfull logons. If we specify one server in the tnsnames.ora (no load balancing) and use the service_name i.s.o sid it show the same succesfull/unsuccesfull logon behaviour. if we then shut down the remote listener and instance all connections go fine This all looks like the load balancing on the server seems to be not working correctly Does anybody have experience with setting this up correctly, have good clear documents about it or know any gotcha's that might help solve this.. Any help appreciated This is for testing purpose only and we do not pay support for RAC (yet, you never know if we can turn the sql*server march around) so Creating a TAR may be difficult TIA Jack === De informatie verzonden in dit e-mailbericht is vertrouwelijk en is uitsluitend bestemd voor de geadresseerde. Openbaarmaking, vermenigvuldiging, verspreiding en/of verstrekking van deze informatie aan derden is, behoudens voorafgaande schriftelijke toestemming van Ernst Young, niet toegestaan. Ernst Young staat niet in voor de juiste en volledige overbrenging van de inhoud van een verzonden e-mailbericht, noch voor tijdige ontvangst daarvan. Ernst Young kan niet garanderen dat een verzonden e-mailbericht vrij is van virussen, noch dat e-mailberichten worden overgebracht zonder inbreuk of tussenkomst van onbevoegde derden. Indien bovenstaand e-mailbericht niet aan u is gericht, verzoeken wij u vriendelijk doch dringend het e-mailbericht te retourneren aan de verzender en het origineel en eventuele kopieën te verwijderen en te vernietigen. Ernst Young hanteert bij de uitoefening van haar werkzaamheden algemene voorwaarden, waarin een beperking van aansprakelijkheid is opgenomen. De algemene
RE: What you've always wanted to know about Oracle DBAing
How to keep track of everything related to Oracle. Where to find hardware to try new updates, software like the Applications Suite or this Collaboration Suite, whatever that is. : ) Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) -Original Message- Sent: Friday, July 12, 2002 4:09 PM To: Multiple recipients of list ORACLE-L Subject:RE: What you've always wanted to know about Oracle DBAing When will my Oracle stock go above 40 again? Robert G. Freeman - Oracle OCP Oracle Database Architect CSX Midtier Database Administration Author Oracle9i RMAN Backup and Recovery (Oracle Press - Oct 2002) Oracle9i New Features (Oracle Press) Mastering Oracle8i (Sybex) Clark Griswold: Eddie, has anyone ever told you that you're bad luck? Cousin Eddie: Those were my mother's dying words. But I guess if your body's covered in third degree burns, and your foot's caught in a bear trap, you tend to start talkin' crazy. -Original Message- Sent: Thursday, July 11, 2002 9:53 AM To: Multiple recipients of list ORACLE-L I'm doing some research into questions Oracle DBAs would like to find answers/solutions to but for some reason, no time, bumped to a lower priority etc. they have not had time to find out. If you have a list of such (Oracle DBA related!) questions, restrict to your top 10 where necessary, I'd appreciate folk sending them directly to me. So whether you be a newbie or go back as far as Oracle 6 (or earlier!) dredge your memory banks and send 'em on. - Seán O' Neill Organon (Ireland) Ltd. [subscribed: digest mode] This message, including attached files, may contain confidential information and is intended only for the use by the individual and/or the entity to which it is addressed. Any unauthorized use, dissemination of, or copying of the information contained herein is not allowed and may lead to irreparable harm and damage for which you may be held liable. If you receive this message in error or if it is intended for someone else please notify the sender by returning this e-mail immediately and delete the message. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: O'Neill, Sean INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Freeman, Robert INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: More on the OCP priceing
Am I missing something about the OCP program? The new required class is only required for the new 'Oracle Certified Master' Certification. You can still obtain OCP certification without taking any classes direct from Oracle, right? Steve McClure -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steve McClure INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Where is Oracle 9.2 init.ora?
It should NOT however, be edited!
--- Freeman, Robert [EMAIL PROTECTED] wrote:
Oracle created the SPFILE which is not humanly readable.
Mine is pretty easy to read! Maybe you need to check your character
set???
:-))
RF
Robert G. Freeman - Oracle OCP
Oracle Database Architect
CSX Midtier Database Administration
Author
Oracle9i RMAN Backup and Recovery (Oracle Press - Oct 2002)
Oracle9i New Features (Oracle Press)
Mastering Oracle8i (Sybex)
Clark Griswold: Eddie, has anyone ever told you that you're bad luck?
Cousin Eddie: Those were my mother's dying words. But I
guess if your body's covered in third degree burns, and
your foot's caught in a bear trap, you tend to start talkin'
crazy.
-Original Message-
Sent: Thursday, July 11, 2002 12:09 PM
To: Multiple recipients of list ORACLE-L
Dennis,
Oracle created the SPFILE which is not humanly readable. There
should
be an
alter database/system command that does the change for you.
According to
what I
heard at Oratechs 2000 editing the init.ora file is now longer
effective.
Dick Goulet
Reply Separator
Author: DENNIS WILLIAMS [EMAIL PROTECTED]
Date: 7/11/2002 7:43 AM
For Oracle 9.2 (Solaris), can anyone tell me where Oracle is
expecting the
init.ora file?
I created the database using dbca. It created an init.ora in
admin/{db_name}/pfile. I moved this to $ORACLE_HOME/dbs and renamed
the
original init.ora file. Then I discovered that Oracle is not reading
the new
init.ora. The database starts fine, with no errors. I tried moving
the
init.ora file back to the original pfile location, but it is still
not
reading it. Specifically, I am trying to set LOG_ARCHIVE_START =
true, but I
have made other changes and they are not taking effect either.
I have searched the documentation, and while there is the new SPFILE,
there
is no indication how this might affect my problem.
Any insights from someone that has turned archiving on with 9.2 would
be
appreciated.
Dennis Williams
DBA, 20% OCP
Lifetouch, Inc.
[EMAIL PROTECTED]
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: DENNIS WILLIAMS
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing
Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing
Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Freeman, Robert
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing
Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
__
Do You Yahoo!?
Sign up for SBC Yahoo! Dial - First Month Free
http://sbc.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Rachel Carmichael
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
guid related ( repeat)
hi everybody , oracle provides guid function to generate unique ids . My question is should one use that guid for synthetic primary key .So you no longer need a sequence for generating unique values . Is it faster to do a search on number comapred to varchar2 if it is indexed . My just debating if i should use guid to for primary key . -Bp
RE: RMAN Restore problem
Hi Robert, Thanks for your note on the RMAN restore. I finally analyzed(compute statistics) the catalog schema and was able to restore within 10 mts instead of 6 hours. Ashoke -Original Message- Sent: Friday, July 12, 2002 2:13 PM To: Multiple recipients of list ORACLE-L If you are using a MML, check the settings there. They can have significant impacts on performance. We just got done chasing a restore problem where our database was taking about 15 hours to restore (if at all). Finally discovered that the tapes we were using were vaulted tapes. These were tapes created after our backup for off-site purposes. When they created these tapes, the program that created them would interleave several tapes into the vault set. So, out 2 tape backup set becomes a 7 tape backup set That 7 tape backupset would have the backup pieces segmented all over the place, and the way the MMManager was working, it would read one backup piece, and then have to rewind the entire tape before it could read the next. We redid the recovery with non-interleaved tapes in 5 hours. RF Robert G. Freeman - Oracle OCP Oracle Database Architect CSX Midtier Database Administration Author Oracle9i RMAN Backup and Recovery (Oracle Press - Oct 2002) Oracle9i New Features (Oracle Press) Mastering Oracle8i (Sybex) Clark Griswold: Eddie, has anyone ever told you that you're bad luck? Cousin Eddie: Those were my mother's dying words. But I guess if your body's covered in third degree burns, and your foot's caught in a bear trap, you tend to start talkin' crazy. -Original Message- Sent: Wednesday, July 10, 2002 3:35 PM To: Multiple recipients of list ORACLE-L Ashoke - I received something like that when attempting a similar RMAN restore. This was the only thing on the target server and the server usage went to zero. Bruce Reardon was nice enough to offer the following suggestions: - What does v$session_wait say for the RMAN sessions (on each database) - Can you connect to the catalog yourself? - Can you connect nomount to the target? - Anything in cdump, bdump, udump directories? - Check the o.s. processes. -Original Message- Sent: Wednesday, July 10, 2002 1:24 PM To: Multiple recipients of list ORACLE-L Greetings, I am trying to restore a database into a new host. The database called dsdn is originally located on dndev, catalog database is located on catserver1. I have copied the catalog to a database called trmanrfd, which is also located on the new host server2. Now I am trying to restore this database into a new host called server2. It is taking 6-7 hours to restore. Ideally it should take few mintes(may be 30 mts.). Do you have any idea, what could be the problem for slowness. Thanks, Ashoke -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Freeman, Robert INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mandal, Ashoke INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: My TAR button disappeared from MetaLink
And your license is all paid up, yes? Boivin, Patrice J To: Multiple recipients of list ORACLE-L BoivinP [EMAIL PROTECTED] @mar.dfo-mpo.cc: gc.ca Subject: My TAR button disappeared from Sent by: rootMetaLink 07/12/2002 01:24 PM Please respond to ORACLE-L I clicked on a URL link in an e-mail from Oracle support, and got an error message telling me I have no privs to view the document. I logged into Metalink, and noticed that there is no TAR section in the right pane, as I usually have. There also is no TAR button in the left pane, I remember there being one there but my memory may be wrong... ??? I submitted MetaLink feedback. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thomas Day INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: RE: larry want to take over your e-mai
The model for running a technology based company into the ground is to promote the Director (or VP) of Sales and Marketing to CEO. This sort of makes sense because it is sales and marketing that generates the revenue and all of these companies are in business to make money. The Sales and Marketing person knows how to sell. They could sell iceboxes to Eskimoes. From their point of view Research and Development is an expense (not an investment). So no new products are developed, sales falter and, in order to keep profits up, the CEO lays off even more developers. Ultimately you're trying to sell buggy whips to automobile drivers. When I worked at Boeing they countered this by insisting that all managers have a BS as their undergraduate degree. It didn't matter if it was from Holbokien Institute of Technology, that BS was the magic key into management. Of course you needed more than just an undergraduate degree but every manager did have some understanding of how the technology worked and the necessity of RD. Take a look at the top tiers of your company. If it consists of just MBAs who have Finance, Sales and Marketing backgrounds and who have never actually developed anything in the technology that they are managing then the company will eventually go under. In most cases the collapse of the dot-coms and tel-coms are perfect examples. They couldn't deliver the technology. All sizzle and no steak. DENNIS WILLIAMS To: Multiple recipients of list ORACLE-L DWILLIAMS [EMAIL PROTECTED] @LIFETOUCH.COcc: M Subject: RE: RE: larry want to take over your Sent by: roote-mai 07/12/2002 01:04 PM Please respond to ORACLE-L Patrice - I especially agree with your last statement don't believe there is a real solution to this. Remember a technology vendor has 3 constituents, all of whom think they are the most important: stockholders, employees, customers. I have noticed that previous slumps in technology sales have tended to correlate with periods where there aren't compelling new products to be purchased. We could all run our current products for years to come, but then that wouldn't produce any new sales would it? In the short term about all a vendor can do to show its stockholders is cut employees in response to falling revenues. Eventually new products will appear, but that takes much longer and if the company goes out of business before then, it is rather moot. Dennis Williams DBA, 20% OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, July 12, 2002 8:58 AM To: Multiple recipients of list ORACLE-L I have mixed feelings about this - I think this is pervasive within the high-tech industry, and my gut feeling is that it may help explain why tech stocks are so low. Do you think they (the industry leaders) will get the message? I seriously doubt it. Right now the focus seems to be on cutting staff and costs rather than improving products to build loyal customers and increase revenues. It's been like this for as long as I can remember. But the industry leaders are probably in a bind: Many high quality products disappeared because a cheaper alternative came on the market. Part of the problem is that people think short term, if they see a half-finished product at lower cost that markets itself as being the cheaper alternative for an expensive solution, purchasers tend to pick the cheaper option if they think they can live with it. In some cases if a well-known company says wait 6 months, we are working on this too and our product will amaze you, customers actually decide to postpone projects based on vaporware promises. Overall costs may actually be higher when cheaper alternatives are selected, but in many places no one
Location of tnsnames.ora on client
On a Windows client installation, does anyone know what controls the location of tnsnames.ora? Is it some registry variable? We have a Windows install that can't seem to find its tnsnames.ora. Thanks. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle 9.2 spfile catch 22
SPFILE concept is good and it is required for reaching the goal of 'no dba required', but it is still far from being 'ready for prime time'. I really don't think the DBA will ever be eliminated. This kind of thing just gives us more time to spend on other aspects of the database. Just consider how much database/computer savvy is needed to make runInstaller work. :) Jared Deshpande, Kirti [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 07/11/2002 01:37 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Oracle 9.2 spfile catch 22 I would get the DB to function the way I want first using init.ora. Then switch to SPFILE from init.ora, while preserving a copy of working init.ora file. Also, when a parameter is changed dynamically with SCOPE=both or spfile, I recreate my init.ora file as the backup. SPFILE concept is good and it is required for reaching the goal of 'no dba required', but it is still far from being 'ready for prime time'. I stopped using SPFILE with a couple of my databases when I was able to add db_cache_size to an spfile that already had db_block_buffers (two mutually exclusive parameters). The next restart of the DB failed. It was good that I had kept the init.ora file. I have not installed 9.2 yet, so I do now know if such things are verified beforehand and prevented. HTH, - Kirti -Original Message- From: DENNIS WILLIAMS [SMTP:[EMAIL PROTECTED]] Sent: Thursday, July 11, 2002 12:49 PM To:Multiple recipients of list ORACLE-L Subject: Oracle 9.2 spfile catch 22 Thanks to everyone for the ideas on the init.ora. You were correct that the answer is indeed with spfile. Now I have discovered a catch-22. Oracle 9.2, Solaris 1. If spfile is created with LOG_ARCHIVE_START = true, database will not start. Receive the error ORA-00439 feature not enabled: Managed Standby 2. Creating the spfile with LOG_ARCHIVE_START = false works and the database starts. Issuing ALTER SYSTEM ARCHIVE LOG START works, but it isn't changed in the spfile, so the next time Oracle is bounced, the archiver doesn't start. This is starting to smell like a bug, but I thought I'd run it past the list on the off-chance someone else has gotten archiving turned on for 9.2. Thanks. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Plagiarism?
Some people lack a little thing called ethics. Robert G. Freeman - Oracle OCP Oracle Database Architect CSX Midtier Database Administration Author Oracle9i RMAN Backup and Recovery (Oracle Press - Oct 2002) Oracle9i New Features (Oracle Press) Mastering Oracle8i (Sybex) Clark Griswold: Eddie, has anyone ever told you that you're bad luck? Cousin Eddie: Those were my mother's dying words. But I guess if your body's covered in third degree burns, and your foot's caught in a bear trap, you tend to start talkin' crazy. -Original Message- Sent: Friday, July 12, 2002 3:18 PM To: Multiple recipients of list ORACLE-L It was obviously written by Steve, I just couldn't believe that the guy posting the script literally removed the copywriter, replaced Steve's name with his own then submitted it to a web site, which then went out in their newsletter. Pretty brash I thought and I wonder what could possibly be the motivation for such a thing. Ethan Post perotdba (AIM), epost1 (Yahoo) -Original Message- Sent: Friday, July 12, 2002 1:49 PM To: Multiple recipients of list ORACLE-L Not many things in this life are certain, but I'll guarantee you one thing: if there's a script at Ixora with Steve Adams' name on it, then that script was written by Steve Adams. Yea, and Steve is such a nice guy I'm fairly certain all they would have to do is ask and he'd give them permission to use it. RF Robert G. Freeman - Oracle8i OCP Oracle Database Architect CSX Midtier Database Administration Author: Oracle9i New Features Mastering Oracle8i Clark Griswold: Eddie, has anyone ever told you that you're bad luck? Cousin Eddie: Those were my mother's dying words. But I guess if your body's covered in third degree burns, and your foot's caught in a bear trap, you tend to start talkin' crazy. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Post, Ethan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Freeman, Robert INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Plagiarism?
...what could possibly be the motivation... A) Stupidity B) Incompetence C) Clueless D) Certain students from Piper High School... E) A parent of one those Piper High School students... Please choose one, all or add your own... I was going to add F) A Manager... -Original Message- Sent: Friday, July 12, 2002 3:18 PM To: Multiple recipients of list ORACLE-L It was obviously written by Steve, I just couldn't believe that the guy posting the script literally removed the copywriter, replaced Steve's name with his own then submitted it to a web site, which then went out in their newsletter. Pretty brash I thought and I wonder what could possibly be the motivation for such a thing. Ethan Post perotdba (AIM), epost1 (Yahoo) -Original Message- Sent: Friday, July 12, 2002 1:49 PM To: Multiple recipients of list ORACLE-L Not many things in this life are certain, but I'll guarantee you one thing: if there's a script at Ixora with Steve Adams' name on it, then that script was written by Steve Adams. Yea, and Steve is such a nice guy I'm fairly certain all they would have to do is ask and he'd give them permission to use it. RF Robert G. Freeman - Oracle8i OCP Oracle Database Architect CSX Midtier Database Administration Author: Oracle9i New Features Mastering Oracle8i Clark Griswold: Eddie, has anyone ever told you that you're bad luck? Cousin Eddie: Those were my mother's dying words. But I guess if your body's covered in third degree burns, and your foot's caught in a bear trap, you tend to start talkin' crazy. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Post, Ethan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Grabowy, Chris INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Where is Oracle 9.2 init.ora?
always someone to spoil the fun!
-Original Message-
Sent: Friday, July 12, 2002 4:18 PM
To: Multiple recipients of list ORACLE-L
It should NOT however, be edited!
--- Freeman, Robert [EMAIL PROTECTED] wrote:
Oracle created the SPFILE which is not humanly readable.
Mine is pretty easy to read! Maybe you need to check your character
set???
:-))
RF
Robert G. Freeman - Oracle OCP
Oracle Database Architect
CSX Midtier Database Administration
Author
Oracle9i RMAN Backup and Recovery (Oracle Press - Oct 2002)
Oracle9i New Features (Oracle Press)
Mastering Oracle8i (Sybex)
Clark Griswold: Eddie, has anyone ever told you that you're bad luck?
Cousin Eddie: Those were my mother's dying words. But I
guess if your body's covered in third degree burns, and
your foot's caught in a bear trap, you tend to start talkin'
crazy.
-Original Message-
Sent: Thursday, July 11, 2002 12:09 PM
To: Multiple recipients of list ORACLE-L
Dennis,
Oracle created the SPFILE which is not humanly readable. There
should
be an
alter database/system command that does the change for you.
According to
what I
heard at Oratechs 2000 editing the init.ora file is now longer
effective.
Dick Goulet
Reply Separator
Author: DENNIS WILLIAMS [EMAIL PROTECTED]
Date: 7/11/2002 7:43 AM
For Oracle 9.2 (Solaris), can anyone tell me where Oracle is
expecting the
init.ora file?
I created the database using dbca. It created an init.ora in
admin/{db_name}/pfile. I moved this to $ORACLE_HOME/dbs and renamed
the
original init.ora file. Then I discovered that Oracle is not reading
the new
init.ora. The database starts fine, with no errors. I tried moving
the
init.ora file back to the original pfile location, but it is still
not
reading it. Specifically, I am trying to set LOG_ARCHIVE_START =
true, but I
have made other changes and they are not taking effect either.
I have searched the documentation, and while there is the new SPFILE,
there
is no indication how this might affect my problem.
Any insights from someone that has turned archiving on with 9.2 would
be
appreciated.
Dennis Williams
DBA, 20% OCP
Lifetouch, Inc.
[EMAIL PROTECTED]
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: DENNIS WILLIAMS
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing
Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing
Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Freeman, Robert
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing
Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
__
Do You Yahoo!?
Sign up for SBC Yahoo! Dial - First Month Free
http://sbc.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Rachel Carmichael
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You
Re: Location of tnsnames.ora on client
%ORAHOME\Network\Admin Igor Neyman, OCP DBA [EMAIL PROTECTED] The degree of normality in a database is inversely proportional to that of its DBA. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, July 12, 2002 4:28 PM On a Windows client installation, does anyone know what controls the location of tnsnames.ora? Is it some registry variable? We have a Windows install that can't seem to find its tnsnames.ora. Thanks. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Igor Neyman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
WHICH TABLE NEED TO INCREASE FREELISTS
Hi Is any way which tables need to increase more freelists? Thx -Seema _ Send and receive Hotmail on your mobile device: http://mobile.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seema Singh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: guid related ( repeat)
Just based on the length of the field, I'd prefer sequence generated unique values. Igor Neyman, OCP DBA[EMAIL PROTECTED] - Original Message - From: BigP To: Multiple recipients of list ORACLE-L Sent: Friday, July 12, 2002 4:08 PM Subject: guid related ( repeat) hi everybody , oracle provides guid function to generate unique ids . My question is should one use that guid for synthetic primary key ..So you no longer need a sequence for generating unique values . Is it faster to do a search on number comapred to varchar2 if it is indexed .. My just debating if i should use guid to for primary key . -Bp
RE: RE: larry want to take over your e-mai
That's interesting, because I personally know of two people with sales backgrounds that griped about cluesless technical people at various companies. My worse half worked at a software company that made point-of-sales systems. The DOS version has been out for a while and stable. The windows version is barely finished and bugging. And yet she was expected to sell it to the DOS customers and find new ones. She was forced to put together her own demo disk, because the techies couldnt be bothered with that nonsense. Along with handouts, glossies, etc. The demo disks were bugging, of course. The DOS customers that upgraded to Windows had to down grade because it wasn't stable, etc. DOS sales = 0, everyone does Windows. Windows sales = 0, bugging version. What's wrong with the company? Sales, there are none. Yeah, right. My point is that every part of the organization has to work together. Like a well oiled engine... -Original Message- Sent: Friday, July 12, 2002 4:08 PM To: Multiple recipients of list ORACLE-L The model for running a technology based company into the ground is to promote the Director (or VP) of Sales and Marketing to CEO. This sort of makes sense because it is sales and marketing that generates the revenue and all of these companies are in business to make money. The Sales and Marketing person knows how to sell. They could sell iceboxes to Eskimoes. From their point of view Research and Development is an expense (not an investment). So no new products are developed, sales falter and, in order to keep profits up, the CEO lays off even more developers. Ultimately you're trying to sell buggy whips to automobile drivers. When I worked at Boeing they countered this by insisting that all managers have a BS as their undergraduate degree. It didn't matter if it was from Holbokien Institute of Technology, that BS was the magic key into management. Of course you needed more than just an undergraduate degree but every manager did have some understanding of how the technology worked and the necessity of RD. Take a look at the top tiers of your company. If it consists of just MBAs who have Finance, Sales and Marketing backgrounds and who have never actually developed anything in the technology that they are managing then the company will eventually go under. In most cases the collapse of the dot-coms and tel-coms are perfect examples. They couldn't deliver the technology. All sizzle and no steak. DENNIS WILLIAMS To: Multiple recipients of list ORACLE-L DWILLIAMS [EMAIL PROTECTED] @LIFETOUCH.COcc: M Subject: RE: RE: larry want to take over your Sent by: roote-mai 07/12/2002 01:04 PM Please respond to ORACLE-L Patrice - I especially agree with your last statement don't believe there is a real solution to this. Remember a technology vendor has 3 constituents, all of whom think they are the most important: stockholders, employees, customers. I have noticed that previous slumps in technology sales have tended to correlate with periods where there aren't compelling new products to be purchased. We could all run our current products for years to come, but then that wouldn't produce any new sales would it? In the short term about all a vendor can do to show its stockholders is cut employees in response to falling revenues. Eventually new products will appear, but that takes much longer and if the company goes out of business before then, it is rather moot. Dennis Williams DBA, 20% OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, July 12, 2002 8:58 AM To: Multiple recipients of list ORACLE-L I have mixed feelings about this - I think this is pervasive within the high-tech industry, and my gut feeling is that it may help explain why tech stocks are so low. Do you think they (the industry leaders) will get the message? I seriously doubt it. Right now the focus seems to be on cutting staff and costs rather than improving products to build loyal customers and increase revenues. It's been like this for as long as I can remember. But the industry leaders are probably in a bind: Many high quality products disappeared because a cheaper alternative came on the market. Part of the problem is that people think short term, if they see a half-finished product at lower cost that markets itself as being the cheaper alternative for an expensive solution, purchasers tend to pick the cheaper option if they think they can live with it. In some cases if a well-known company says wait 6 months, we are working on this too and our product will amaze you, customers actually decide to postpone projects based on vaporware promises. Overall
RE: Plagiarism?
Title: RE: Plagiarism? I COMPLETELY missed this WHOLE thing. They pulled the article before I got there even though I went up right away. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Where is Oracle 9.2 init.ora?
I suppose that depends on how you look at it. If you needed to for some
reason,
you could pull the header and footer records out and make it into just a
plain
init.ora But you are correct, of course that the SPFILE itself should
not
be edited if you wish it to remain a usable SPFILE.
RF
Robert G. Freeman - Oracle OCP
Oracle Database Architect
CSX Midtier Database Administration
Author
Oracle9i RMAN Backup and Recovery (Oracle Press - Oct 2002)
Oracle9i New Features (Oracle Press)
Mastering Oracle8i (Sybex)
Clark Griswold: Eddie, has anyone ever told you that you're bad luck?
Cousin Eddie: Those were my mother's dying words. But I
guess if your body's covered in third degree burns, and
your foot's caught in a bear trap, you tend to start talkin'
crazy.
-Original Message-
Sent: Friday, July 12, 2002 4:18 PM
To: Multiple recipients of list ORACLE-L
It should NOT however, be edited!
--- Freeman, Robert [EMAIL PROTECTED] wrote:
Oracle created the SPFILE which is not humanly readable.
Mine is pretty easy to read! Maybe you need to check your character
set???
:-))
RF
Robert G. Freeman - Oracle OCP
Oracle Database Architect
CSX Midtier Database Administration
Author
Oracle9i RMAN Backup and Recovery (Oracle Press - Oct 2002)
Oracle9i New Features (Oracle Press)
Mastering Oracle8i (Sybex)
Clark Griswold: Eddie, has anyone ever told you that you're bad luck?
Cousin Eddie: Those were my mother's dying words. But I
guess if your body's covered in third degree burns, and
your foot's caught in a bear trap, you tend to start talkin'
crazy.
-Original Message-
Sent: Thursday, July 11, 2002 12:09 PM
To: Multiple recipients of list ORACLE-L
Dennis,
Oracle created the SPFILE which is not humanly readable. There
should
be an
alter database/system command that does the change for you.
According to
what I
heard at Oratechs 2000 editing the init.ora file is now longer
effective.
Dick Goulet
Reply Separator
Author: DENNIS WILLIAMS [EMAIL PROTECTED]
Date: 7/11/2002 7:43 AM
For Oracle 9.2 (Solaris), can anyone tell me where Oracle is
expecting the
init.ora file?
I created the database using dbca. It created an init.ora in
admin/{db_name}/pfile. I moved this to $ORACLE_HOME/dbs and renamed
the
original init.ora file. Then I discovered that Oracle is not reading
the new
init.ora. The database starts fine, with no errors. I tried moving
the
init.ora file back to the original pfile location, but it is still
not
reading it. Specifically, I am trying to set LOG_ARCHIVE_START =
true, but I
have made other changes and they are not taking effect either.
I have searched the documentation, and while there is the new SPFILE,
there
is no indication how this might affect my problem.
Any insights from someone that has turned archiving on with 9.2 would
be
appreciated.
Dennis Williams
DBA, 20% OCP
Lifetouch, Inc.
[EMAIL PROTECTED]
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: DENNIS WILLIAMS
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing
Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing
Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Freeman, Robert
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing
Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information
RE: RE: larry want to take over your e-mai
Can you imagine the (additional) beating that Oracle would take if it's accounting practices showed up inflated revenues such as some of the other companies out there that are having problems I shutter to think... RF Robert G. Freeman - Oracle OCP Oracle Database Architect CSX Midtier Database Administration Author Oracle9i RMAN Backup and Recovery (Oracle Press - Oct 2002) Oracle9i New Features (Oracle Press) Mastering Oracle8i (Sybex) Clark Griswold: Eddie, has anyone ever told you that you're bad luck? Cousin Eddie: Those were my mother's dying words. But I guess if your body's covered in third degree burns, and your foot's caught in a bear trap, you tend to start talkin' crazy. -Original Message- Sent: Friday, July 12, 2002 4:08 PM To: Multiple recipients of list ORACLE-L The model for running a technology based company into the ground is to promote the Director (or VP) of Sales and Marketing to CEO. This sort of makes sense because it is sales and marketing that generates the revenue and all of these companies are in business to make money. The Sales and Marketing person knows how to sell. They could sell iceboxes to Eskimoes. From their point of view Research and Development is an expense (not an investment). So no new products are developed, sales falter and, in order to keep profits up, the CEO lays off even more developers. Ultimately you're trying to sell buggy whips to automobile drivers. When I worked at Boeing they countered this by insisting that all managers have a BS as their undergraduate degree. It didn't matter if it was from Holbokien Institute of Technology, that BS was the magic key into management. Of course you needed more than just an undergraduate degree but every manager did have some understanding of how the technology worked and the necessity of RD. Take a look at the top tiers of your company. If it consists of just MBAs who have Finance, Sales and Marketing backgrounds and who have never actually developed anything in the technology that they are managing then the company will eventually go under. In most cases the collapse of the dot-coms and tel-coms are perfect examples. They couldn't deliver the technology. All sizzle and no steak. DENNIS WILLIAMS To: Multiple recipients of list ORACLE-L DWILLIAMS [EMAIL PROTECTED] @LIFETOUCH.COcc: M Subject: RE: RE: larry want to take over your Sent by: roote-mai 07/12/2002 01:04 PM Please respond to ORACLE-L Patrice - I especially agree with your last statement don't believe there is a real solution to this. Remember a technology vendor has 3 constituents, all of whom think they are the most important: stockholders, employees, customers. I have noticed that previous slumps in technology sales have tended to correlate with periods where there aren't compelling new products to be purchased. We could all run our current products for years to come, but then that wouldn't produce any new sales would it? In the short term about all a vendor can do to show its stockholders is cut employees in response to falling revenues. Eventually new products will appear, but that takes much longer and if the company goes out of business before then, it is rather moot. Dennis Williams DBA, 20% OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, July 12, 2002 8:58 AM To: Multiple recipients of list ORACLE-L I have mixed feelings about this - I think this is pervasive within the high-tech industry, and my gut feeling is that it may help explain why tech stocks are so low. Do you think they (the industry leaders) will get the message? I seriously doubt it. Right now the focus seems to be on cutting staff and costs rather than improving products to build loyal customers and increase revenues. It's been like this for as long as I can remember. But the industry leaders are probably in a bind: Many high quality products disappeared because a cheaper alternative came on the market. Part of the problem is that people think short term, if they see a half-finished product at lower cost that markets itself as being the cheaper alternative for an expensive solution, purchasers tend to pick the cheaper option if they think they can live with it. In some cases if a well-known company says wait 6 months, we are working on this too and our product will amaze you, customers actually decide to postpone projects based on vaporware promises. Overall costs may actually be higher when cheaper alternatives are selected, but in many places no one is focused enough, wise enough or around long enough to do long-term assessments. In many cases it's because everyone is too busy to cross
Re: Location of tnsnames.ora on client - SOLVED
I think it depends on default_domain parameter in client's sqlnet.ora. Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, July 12, 2002 5:03 PM Okay, it turns out that if a tnsnames.ora file has entries like mysystem.lifetouch.com, On a Win95 system you can enter mysystem and it works. On a W2K system, if you enter mysystem you receive ORA-12154 could not resolve service name. Instead you must enter mysystem.lifetouch.com. Very irritating on Friday afternoon. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, July 12, 2002 3:29 PM To: Multiple recipients of list ORACLE-L On a Windows client installation, does anyone know what controls the location of tnsnames.ora? Is it some registry variable? We have a Windows install that can't seem to find its tnsnames.ora. Thanks. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Igor Neyman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Plagiarism?
It depends on what your definition of is is. BTW a question to all the ethics guru's... A lot of people have put out lots of papers, articles on their website, which can be downloaded for personal use. Would there be a ethics violation if I were to make a HTML page on my file system and access these articles through that (sort of a pseudo INTRAnet). This would make it easy for me to click on the link and access the information rather than search through the directories? Is this ethics violation? Remember that the whole article is as is i.e. all copyright info etc is still intact. Let me repeat it is INTRANET, not available to anyone unless you have privs to the directory. Please enlighten me. Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! -Original Message- Sent: Friday, July 12, 2002 4:57 PM To: Multiple recipients of list ORACLE-L Once you lose your ethics, the rest is easy. :( *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: Plagiarism?
Probably for a chance to win a lousy T-shirt or a BaseBall Cap to submit the best voted Tip of the Month !! :-) - Kirti -Original Message- From: Post, Ethan [SMTP:[EMAIL PROTECTED]] Sent: Friday, July 12, 2002 2:18 PM To: Multiple recipients of list ORACLE-L Subject: RE: Plagiarism? It was obviously written by Steve, I just couldn't believe that the guy posting the script literally removed the copywriter, replaced Steve's name with his own then submitted it to a web site, which then went out in their newsletter. Pretty brash I thought and I wonder what could possibly be the motivation for such a thing. Ethan Post perotdba (AIM), epost1 (Yahoo) -Original Message- Sent: Friday, July 12, 2002 1:49 PM To: Multiple recipients of list ORACLE-L Not many things in this life are certain, but I'll guarantee you one thing: if there's a script at Ixora with Steve Adams' name on it, then that script was written by Steve Adams. Yea, and Steve is such a nice guy I'm fairly certain all they would have to do is ask and he'd give them permission to use it. RF Robert G. Freeman - Oracle8i OCP Oracle Database Architect CSX Midtier Database Administration Author: Oracle9i New Features Mastering Oracle8i Clark Griswold: Eddie, has anyone ever told you that you're bad luck? Cousin Eddie: Those were my mother's dying words. But I guess if your body's covered in third degree burns, and your foot's caught in a bear trap, you tend to start talkin' crazy. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Post, Ethan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle 9.2 spfile catch 22
I just like that 'dream' of 'no dba required' ;) 'cause I have heard enough presenters mention it... the new self tuning 9i, the new 'everything dynamic' 9i and such.. - Kirti -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: Friday, July 12, 2002 3:14 PM To: Multiple recipients of list ORACLE-L Subject: RE: Oracle 9.2 spfile catch 22 SPFILE concept is good and it is required for reaching the goal of 'no dba required', but it is still far from being 'ready for prime time'. I really don't think the DBA will ever be eliminated. This kind of thing just gives us more time to spend on other aspects of the database. Just consider how much database/computer savvy is needed to make runInstaller work. :) Jared Deshpande, Kirti [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 07/11/2002 01:37 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Oracle 9.2 spfile catch 22 I would get the DB to function the way I want first using init.ora. Then switch to SPFILE from init.ora, while preserving a copy of working init.ora file. Also, when a parameter is changed dynamically with SCOPE=both or spfile, I recreate my init.ora file as the backup. SPFILE concept is good and it is required for reaching the goal of 'no dba required', but it is still far from being 'ready for prime time'. I stopped using SPFILE with a couple of my databases when I was able to add db_cache_size to an spfile that already had db_block_buffers (two mutually exclusive parameters). The next restart of the DB failed. It was good that I had kept the init.ora file. I have not installed 9.2 yet, so I do now know if such things are verified beforehand and prevented. HTH, - Kirti -Original Message- From: DENNIS WILLIAMS [SMTP:[EMAIL PROTECTED]] Sent: Thursday, July 11, 2002 12:49 PM To:Multiple recipients of list ORACLE-L Subject: Oracle 9.2 spfile catch 22 Thanks to everyone for the ideas on the init.ora. You were correct that the answer is indeed with spfile. Now I have discovered a catch-22. Oracle 9.2, Solaris 1. If spfile is created with LOG_ARCHIVE_START = true, database will not start. Receive the error ORA-00439 feature not enabled: Managed Standby 2. Creating the spfile with LOG_ARCHIVE_START = false works and the database starts. Issuing ALTER SYSTEM ARCHIVE LOG START works, but it isn't changed in the spfile, so the next time Oracle is bounced, the archiver doesn't start. This is starting to smell like a bug, but I thought I'd run it past the list on the off-chance someone else has gotten archiving turned on for 9.2. Thanks. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Where is Oracle 9.2 init.ora?
I did edit it and had no problems while teting my 9i R1 on HP-UX 11.0 :)
- Kirti
-Original Message-
From: Rachel Carmichael [SMTP:[EMAIL PROTECTED]]
Sent: Friday, July 12, 2002 3:18 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Where is Oracle 9.2 init.ora?
It should NOT however, be edited!
--- Freeman, Robert [EMAIL PROTECTED] wrote:
Oracle created the SPFILE which is not humanly readable.
Mine is pretty easy to read! Maybe you need to check your character
set???
:-))
RF
Robert G. Freeman - Oracle OCP
Oracle Database Architect
CSX Midtier Database Administration
Author
Oracle9i RMAN Backup and Recovery (Oracle Press - Oct 2002)
Oracle9i New Features (Oracle Press)
Mastering Oracle8i (Sybex)
Clark Griswold: Eddie, has anyone ever told you that you're bad luck?
Cousin Eddie: Those were my mother's dying words. But I
guess if your body's covered in third degree burns, and
your foot's caught in a bear trap, you tend to start talkin'
crazy.
-Original Message-
Sent: Thursday, July 11, 2002 12:09 PM
To: Multiple recipients of list ORACLE-L
Dennis,
Oracle created the SPFILE which is not humanly readable. There
should
be an
alter database/system command that does the change for you.
According to
what I
heard at Oratechs 2000 editing the init.ora file is now longer
effective.
Dick Goulet
Reply Separator
Author: DENNIS WILLIAMS [EMAIL PROTECTED]
Date: 7/11/2002 7:43 AM
For Oracle 9.2 (Solaris), can anyone tell me where Oracle is
expecting the
init.ora file?
I created the database using dbca. It created an init.ora in
admin/{db_name}/pfile. I moved this to $ORACLE_HOME/dbs and renamed
the
original init.ora file. Then I discovered that Oracle is not reading
the new
init.ora. The database starts fine, with no errors. I tried moving
the
init.ora file back to the original pfile location, but it is still
not
reading it. Specifically, I am trying to set LOG_ARCHIVE_START =
true, but I
have made other changes and they are not taking effect either.
I have searched the documentation, and while there is the new SPFILE,
there
is no indication how this might affect my problem.
Any insights from someone that has turned archiving on with 9.2 would
be
appreciated.
Dennis Williams
DBA, 20% OCP
Lifetouch, Inc.
[EMAIL PROTECTED]
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: DENNIS WILLIAMS
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing
Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing
Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Freeman, Robert
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing
Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
__
Do You Yahoo!?
Sign up for SBC Yahoo! Dial - First Month Free
http://sbc.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Rachel Carmichael
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
RE: RE: larry want to take over your e-mai
Well, if you've got clueless techies then the company's doomed no matter who is in charge. Though I guess that you can always blame upper management for hiring people that are just certified but have no real experience. Grabowy, Chris To: Multiple recipients of list ORACLE-L cgrabowy[EMAIL PROTECTED] @fcg.comcc: Sent by: rootSubject: RE: RE: larry want to take over your e-mai 07/12/2002 04:48 PM Please respond to ORACLE-L That's interesting, because I personally know of two people with sales backgrounds that griped about cluesless technical people at various companies. My worse half worked at a software company that made point-of-sales systems. The DOS version has been out for a while and stable. The windows version is barely finished and bugging. And yet she was expected to sell it to the DOS customers and find new ones. She was forced to put together her own demo disk, because the techies couldnt be bothered with that nonsense. Along with handouts, glossies, etc. The demo disks were bugging, of course. The DOS customers that upgraded to Windows had to down grade because it wasn't stable, etc. DOS sales = 0, everyone does Windows. Windows sales = 0, bugging version. What's wrong with the company? Sales, there are none. Yeah, right. My point is that every part of the organization has to work together. Like a well oiled engine... -Original Message- Sent: Friday, July 12, 2002 4:08 PM To: Multiple recipients of list ORACLE-L The model for running a technology based company into the ground is to promote the Director (or VP) of Sales and Marketing to CEO. This sort of makes sense because it is sales and marketing that generates the revenue and all of these companies are in business to make money. The Sales and Marketing person knows how to sell. They could sell iceboxes to Eskimoes. From their point of view Research and Development is an expense (not an investment). So no new products are developed, sales falter and, in order to keep profits up, the CEO lays off even more developers. Ultimately you're trying to sell buggy whips to automobile drivers. When I worked at Boeing they countered this by insisting that all managers have a BS as their undergraduate degree. It didn't matter if it was from Holbokien Institute of Technology, that BS was the magic key into management. Of course you needed more than just an undergraduate degree but every manager did have some understanding of how the technology worked and the necessity of RD. Take a look at the top tiers of your company. If it consists of just MBAs who have Finance, Sales and Marketing backgrounds and who have never actually developed anything in the technology that they are managing then the company will eventually go under. In most cases the collapse of the dot-coms and tel-coms are perfect examples. They couldn't deliver the technology. All sizzle and no steak. DENNIS WILLIAMS To: Multiple recipients of list ORACLE-L DWILLIAMS [EMAIL PROTECTED] @LIFETOUCH.COcc: M Subject: RE: RE: larry want to take over your Sent by: roote-mai 07/12/2002 01:04 PM Please respond to ORACLE-L Patrice - I especially agree with your last statement don't believe there is a real solution to this. Remember a technology vendor has 3 constituents, all of whom think they are the most important: stockholders, employees, customers. I have noticed that previous slumps in technology sales have tended to correlate with periods where there aren't compelling new products to be
RE: Oracle 9.2 spfile catch 22
Everything self tuning yeah it works. I have two identical tables (with different number of rows of course) and separately analyzed. They have identical index. When I run select on both tables after supplying a value for the PK, the query on main table uses the PK index and works fine. The query on second table (identical, except for different table name), uses a concat index with 'index skip scan' instead of pk. I have no explanation, does anyone have any? I have the 10053 dump available if you need it. I am trying to understand WHY it isn't using the pk and resorting to skip scanning? The db is 9012. Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! -Original Message- Sent: Friday, July 12, 2002 5:43 PM To: Multiple recipients of list ORACLE-L I just like that 'dream' of 'no dba required' ;) 'cause I have heard enough presenters mention it... the new self tuning 9i, the new 'everything dynamic' 9i and such.. - Kirti *This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.*2
Re: WHICH TABLE NEED TO INCREASE FREELISTS
You want to do something before you know if it would make sense. If you know the object you know it makes sense. Anjo. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, July 12, 2002 10:38 PM Hi Is any way which tables need to increase more freelists? Thx -Seema _ Send and receive Hotmail on your mobile device: http://mobile.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seema Singh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Anjo Kolk INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Plagiarism?
Quick answer: If you make it clear that you are not the author of the papers and indicate who the real authors are then you are not guilty of plagarism. What the copywrite issues are is a much longer answer. I'm not sure that a definative answer exists but if there is a copywrite notice attached it should not be removed, that's for sure. Jamadagni, RajendraTo: Multiple recipients of list ORACLE-L Rajendra.Jam[EMAIL PROTECTED] adagni cc: @espn.com Subject: RE: Plagiarism? Sent by: root 07/12/2002 05:08 PM Please respond to ORACLE-L It depends on what your definition of is is. BTW a question to all the ethics guru's... A lot of people have put out lots of papers, articles on their website, which can be downloaded for personal use. Would there be a ethics violation if I were to make a HTML page on my file system and access these articles through that (sort of a pseudo INTRAnet). This would make it easy for me to click on the link and access the information rather than search through the directories? Is this ethics violation? Remember that the whole article is as is i.e. all copyright info etc is still intact. Let me repeat it is INTRANET, not available to anyone unless you have privs to the directory. Please enlighten me. Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! -Original Message- Sent: Friday, July 12, 2002 4:57 PM To: Multiple recipients of list ORACLE-L Once you lose your ethics, the rest is easy. :( Attachment Removed : InterScan_Disclaimer.txt -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thomas Day INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Where is Oracle 9.2 init.ora?
I've also heard that it should not be edited. It can be more'd to see
contents. No need to edit it directly since SCOPE can be used.
Gerardo
-Original Message-
Sent: Friday, July 12, 2002 2:54 PM
To: Multiple recipients of list ORACLE-L
I did edit it and had no problems while teting my 9i R1 on HP-UX 11.0 :)
- Kirti
-Original Message-
From: Rachel Carmichael [SMTP:[EMAIL PROTECTED]]
Sent: Friday, July 12, 2002 3:18 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Where is Oracle 9.2 init.ora?
It should NOT however, be edited!
--- Freeman, Robert [EMAIL PROTECTED] wrote:
Oracle created the SPFILE which is not humanly readable.
Mine is pretty easy to read! Maybe you need to check your character
set???
:-))
RF
Robert G. Freeman - Oracle OCP
Oracle Database Architect
CSX Midtier Database Administration
Author
Oracle9i RMAN Backup and Recovery (Oracle Press - Oct 2002)
Oracle9i New Features (Oracle Press)
Mastering Oracle8i (Sybex)
Clark Griswold: Eddie, has anyone ever told you that you're bad luck?
Cousin Eddie: Those were my mother's dying words. But I
guess if your body's covered in third degree burns, and
your foot's caught in a bear trap, you tend to start talkin'
crazy.
-Original Message-
Sent: Thursday, July 11, 2002 12:09 PM
To: Multiple recipients of list ORACLE-L
Dennis,
Oracle created the SPFILE which is not humanly readable. There
should
be an
alter database/system command that does the change for you.
According to
what I
heard at Oratechs 2000 editing the init.ora file is now longer
effective.
Dick Goulet
Reply Separator
Author: DENNIS WILLIAMS [EMAIL PROTECTED]
Date: 7/11/2002 7:43 AM
For Oracle 9.2 (Solaris), can anyone tell me where Oracle is
expecting the
init.ora file?
I created the database using dbca. It created an init.ora in
admin/{db_name}/pfile. I moved this to $ORACLE_HOME/dbs and renamed
the
original init.ora file. Then I discovered that Oracle is not reading
the new
init.ora. The database starts fine, with no errors. I tried moving
the
init.ora file back to the original pfile location, but it is still
not
reading it. Specifically, I am trying to set LOG_ARCHIVE_START =
true, but I
have made other changes and they are not taking effect either.
I have searched the documentation, and while there is the new SPFILE,
there
is no indication how this might affect my problem.
Any insights from someone that has turned archiving on with 9.2 would
be
appreciated.
Dennis Williams
DBA, 20% OCP
Lifetouch, Inc.
[EMAIL PROTECTED]
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: DENNIS WILLIAMS
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing
Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing
Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Freeman, Robert
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing
Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
__
Do You Yahoo!?
Sign up for SBC Yahoo! Dial - First Month Free
http://sbc.yahoo.com
--
Please see the official ORACLE-L FAQ:
Oracle on Linux ... Production Strength ???
Need Input: I would like to solicit real life experiences, educated opinions, accolades and criticisms from those of you who have implemented or are considering implementing Oracle on Linux in a business critical production environment. We are considering both Red Hat and Suse distributions. We have discovered that regardless of the Linux distribution support is generally expensive. That is not a particularly 'deal breaker' determining factor .. BUT .. I question the quality of support, the expediency of response and the 'sense of urgency' experienced in the event of a critical application being down. I am familiar with limited Oracle-Linux implementations but not to the 'industrial strength' degree that has been proposed (but already implemented) by our requesting user community. Is there a preferred distribution We already have Red Hat and Suse implementations and will choose one of them as the standard 'should we chose to accept this mission'. I believe that both claim to be the preferred distribution by Oracle and that they are 'tier one ports' My initial implementation is Suse 7.2 Enterprise on an IBM NetFinity, 4 cpu, 2 Gbyte (memory) server using a Net Appliance Filer. There are six instances currently up and running. Thus far there have been no occurrences of swapping or i/o bottlenecks but then the system has yet to be fully 'stressed' and there are scalability concerns. The USER also wants to put Oracle 9iAS on the same box - I have managed to delay that for now, pending further research. I have had a couple of worrying episodes where a file system 'filled up' (on the Filer) that completely 'hung' the system requiring a full system re-boot. Incidentally the aforementioned NetFinity implementation is 'a given' as the six instances have already been migrated from an aged and de-commissioned HP system. I have inherited the results and there is no going back at this juncture. Your knowledge, thoughts and wisdom greatly appreciated. Thnx OK Bye The world has arrived at an age of cheap complex devices of great reliability, and something is bound to come of it. -- Vannevar Bush (1945) Chris Royce [EMAIL PROTECTED] [EMAIL PROTECTED] winmail.dat
RE: Where is Oracle 9.2 init.ora?
You DBA's must be drunk.
Spfiles are in binary format and if you open it in a text editor, all you see
are weird characters.
Man. You guys are actually doing Oracle? Scares me.
ltiu
Quoting Deshpande, Kirti [EMAIL PROTECTED]:
I did edit it and had no problems while teting my 9i R1 on HP-UX 11.0 :)
- Kirti
-Original Message-
From: Rachel Carmichael [SMTP:[EMAIL PROTECTED]]
Sent: Friday, July 12, 2002 3:18 PM
To: Multiple recipients of list ORACLE-L
Subject:RE: Where is Oracle 9.2 init.ora?
It should NOT however, be edited!
--- Freeman, Robert [EMAIL PROTECTED] wrote:
Oracle created the SPFILE which is not humanly readable.
Mine is pretty easy to read! Maybe you need to check your character
set???
:-))
RF
Robert G. Freeman - Oracle OCP
Oracle Database Architect
CSX Midtier Database Administration
Author
Oracle9i RMAN Backup and Recovery (Oracle Press - Oct 2002)
Oracle9i New Features (Oracle Press)
Mastering Oracle8i (Sybex)
Clark Griswold: Eddie, has anyone ever told you that you're bad luck?
Cousin Eddie: Those were my mother's dying words. But I
guess if your body's covered in third degree burns, and
your foot's caught in a bear trap, you tend to start talkin'
crazy.
-Original Message-
Sent: Thursday, July 11, 2002 12:09 PM
To: Multiple recipients of list ORACLE-L
Dennis,
Oracle created the SPFILE which is not humanly readable. There
should
be an
alter database/system command that does the change for you.
According to
what I
heard at Oratechs 2000 editing the init.ora file is now longer
effective.
Dick Goulet
Reply Separator
Author: DENNIS WILLIAMS [EMAIL PROTECTED]
Date: 7/11/2002 7:43 AM
For Oracle 9.2 (Solaris), can anyone tell me where Oracle is
expecting the
init.ora file?
I created the database using dbca. It created an init.ora in
admin/{db_name}/pfile. I moved this to $ORACLE_HOME/dbs and renamed
the
original init.ora file. Then I discovered that Oracle is not reading
the new
init.ora. The database starts fine, with no errors. I tried moving
the
init.ora file back to the original pfile location, but it is still
not
reading it. Specifically, I am trying to set LOG_ARCHIVE_START =
true, but I
have made other changes and they are not taking effect either.
I have searched the documentation, and while there is the new SPFILE,
there
is no indication how this might affect my problem.
Any insights from someone that has turned archiving on with 9.2 would
be
appreciated.
Dennis Williams
DBA, 20% OCP
Lifetouch, Inc.
[EMAIL PROTECTED]
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: DENNIS WILLIAMS
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing
Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing
Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Freeman, Robert
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing
Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
__
Do
RE: Where is Oracle 9.2 init.ora?
Yes I usually do Oracle after I'm done driving my cab :)
I did edit the spfile in 9iR1 on Solaris using vi and had no problem!
The header and tail were binaries but all the rest is text.
Regards,
Waleed
-Original Message-
Sent: Friday, July 12, 2002 7:28 PM
To: Multiple recipients of list ORACLE-L
You DBA's must be drunk.
Spfiles are in binary format and if you open it in a text editor, all you
see
are weird characters.
Man. You guys are actually doing Oracle? Scares me.
ltiu
Quoting Deshpande, Kirti [EMAIL PROTECTED]:
I did edit it and had no problems while teting my 9i R1 on HP-UX 11.0 :)
- Kirti
-Original Message-
From: Rachel Carmichael [SMTP:[EMAIL PROTECTED]]
Sent: Friday, July 12, 2002 3:18 PM
To: Multiple recipients of list ORACLE-L
Subject:RE: Where is Oracle 9.2 init.ora?
It should NOT however, be edited!
--- Freeman, Robert [EMAIL PROTECTED] wrote:
Oracle created the SPFILE which is not humanly readable.
Mine is pretty easy to read! Maybe you need to check your character
set???
:-))
RF
Robert G. Freeman - Oracle OCP
Oracle Database Architect
CSX Midtier Database Administration
Author
Oracle9i RMAN Backup and Recovery (Oracle Press - Oct 2002)
Oracle9i New Features (Oracle Press)
Mastering Oracle8i (Sybex)
Clark Griswold: Eddie, has anyone ever told you that you're bad luck?
Cousin Eddie: Those were my mother's dying words. But I
guess if your body's covered in third degree burns, and
your foot's caught in a bear trap, you tend to start talkin'
crazy.
-Original Message-
Sent: Thursday, July 11, 2002 12:09 PM
To: Multiple recipients of list ORACLE-L
Dennis,
Oracle created the SPFILE which is not humanly readable. There
should
be an
alter database/system command that does the change for you.
According to
what I
heard at Oratechs 2000 editing the init.ora file is now longer
effective.
Dick Goulet
Reply Separator
Author: DENNIS WILLIAMS [EMAIL PROTECTED]
Date: 7/11/2002 7:43 AM
For Oracle 9.2 (Solaris), can anyone tell me where Oracle is
expecting the
init.ora file?
I created the database using dbca. It created an init.ora in
admin/{db_name}/pfile. I moved this to $ORACLE_HOME/dbs and renamed
the
original init.ora file. Then I discovered that Oracle is not reading
the new
init.ora. The database starts fine, with no errors. I tried moving
the
init.ora file back to the original pfile location, but it is still
not
reading it. Specifically, I am trying to set LOG_ARCHIVE_START =
true, but I
have made other changes and they are not taking effect either.
I have searched the documentation, and while there is the new SPFILE,
there
is no indication how this might affect my problem.
Any insights from someone that has turned archiving on with 9.2 would
be
appreciated.
Dennis Williams
DBA, 20% OCP
Lifetouch, Inc.
[EMAIL PROTECTED]
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: DENNIS WILLIAMS
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing
Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing
Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Freeman, Robert
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing
Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED]
Re: listener configuration on HP serviceguard clusters
Title: RE: listener configuration on HP serviceguard clusters Yes, I do. IP of the node on which listener is running. Like I sad, listener belongs to the none, not package. Alex. - Original Message - From: Adams, Matthew (GEA, MABG, 088130) To: Multiple recipients of list ORACLE-L Sent: Friday, July 12, 2002 5:43 AM Subject: RE: listener configuration on HP serviceguard clusters Do you have a listener.ora file? Which ip address is in it? Matt Adams - GE Appliances - [EMAIL PROTECTED]Enter any 11 digit prime number to continue. -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]Sent: Thursday, July 11, 2002 10:38 PMTo: Multiple recipients of list ORACLE-LSubject: RE: listener configuration on HP serviceguard clusters Matt, We have two nodes cluster with three packages; two of them have more than one database. Oracle software installed on each node. Each listener belongs to node, not to package. When packaged started on the node it will startup instance(s) and each instance will automatically registered with listener. In client's TNSNAMES.ORA we use package name, which resolved to proper IP address. Alex. -Original Message- From: Adams, Matthew (GEA, MABG, 088130) [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 11, 2002 2:15 PM To: Multiple recipients of list ORACLE-L Subject: listener configuration on HP serviceguard clusters If anybody out there is using HP ServiceGuard for non-OPS/RAC, I would be interested to know how you configure the listeners. Do you use the machine IP address or the package address in the listener.ora (or do you not have a listener.ora and use dynamic registration) One of the sys admins here instists that the following scenerio will not work. three nodes - two with one package each (containing Oracle) and one standby node. When the first package fails over to the standby node, it starts a listener using no listener.ora file, allowing the instances to dynamically register. When the second package fails over to the standby node, it does not start a listener. All client tnsnames.ora files use package names for HOST. Do the instances in the second package register successfully with the listener and can clients connect to them? Matt Adams - GE Appliances - [EMAIL PROTECTED] Enter any 11 digit prime number to continue.
RE: Where is Oracle 9.2 init.ora?
I guess your are right.. I am sincerely sorry about my earlier post. I must be drunk at that time as I could not replicate my test. I was mistaken (happens as I get old... ;) However, let me state the following: SPFILE is in ASCII format (on AIX and HP that I checked) And can be edited via 'the Six Editor' (that is the other name for VI editor per Dave Ensor ;) There is some hashed information maintained in the 1st line based on the contents of the file when it was originally created. I edited the file for a few parameters and bounced the DB. It started fine without any warnings, BUT it silently used the available init.ora file. My changes did not take effect. There was no ORA error or warning. Nothing in alert.log either. When I renamed the init.ora file, and tried to bounce the database, it did not start. But now, following ORA errors were reported... SQL startup ORA-01078: failure in processing system parameters LRM-00109: could not open parameter file '/u01/home/oracle/product/9.0.1/dbs/initKED9.ora' So, the lesson learned is not to edit the SPFILE. And if there is an init.ora file, Oracle will simply use it, if it the SPFILE does not pass the checks based in the hashed information in the 1st line of SPFILE. And hence, there is still some work to be done by Oracle with how SPFILE is implemented. I would like to see an error telling me that available SPFILE is useless before using the available init.ora file. Then I used the corrupted SPFILE to build a new init.ora file and started the database without any problems. I like to 'play' around with throw away databases to see how these new features work and how we can break them, there is nothing wrong in doing so. This is how I 'do oracle' :) Cheers! - Kirti -Original Message- From: ltiu [SMTP:[EMAIL PROTECTED]] Sent: Friday, July 12, 2002 5:27 PM To: [EMAIL PROTECTED]; Deshpande, Kirti Cc: Multiple recipients of list ORACLE-L Subject: RE: Where is Oracle 9.2 init.ora? You DBA's must be drunk. Spfiles are in binary format and if you open it in a text editor, all you see are weird characters. Man. You guys are actually doing Oracle? Scares me. ltiu Quoting Deshpande, Kirti [EMAIL PROTECTED]: I did edit it and had no problems while teting my 9i R1 on HP-UX 11.0 :) - Kirti -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Where is Oracle 9.2 init.ora?
Some of us have been around the block a few times. :)
Editing binary files is no big deal.
You neophytes are all the same.
Jared
ltiu [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
07/12/2002 04:28 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:RE: Where is Oracle 9.2 init.ora?
You DBA's must be drunk.
Spfiles are in binary format and if you open it in a text editor, all you
see
are weird characters.
Man. You guys are actually doing Oracle? Scares me.
ltiu
Quoting Deshpande, Kirti [EMAIL PROTECTED]:
I did edit it and had no problems while teting my 9i R1 on HP-UX 11.0 :)
- Kirti
-Original Message-
From:Rachel Carmichael [SMTP:[EMAIL PROTECTED]]
Sent:Friday, July 12, 2002 3:18 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Where is Oracle 9.2 init.ora?
It should NOT however, be edited!
--- Freeman, Robert [EMAIL PROTECTED] wrote:
Oracle created the SPFILE which is not humanly readable.
Mine is pretty easy to read! Maybe you need to check your character
set???
:-))
RF
Robert G. Freeman - Oracle OCP
Oracle Database Architect
CSX Midtier Database Administration
Author
Oracle9i RMAN Backup and Recovery (Oracle Press - Oct 2002)
Oracle9i New Features (Oracle Press)
Mastering Oracle8i (Sybex)
Clark Griswold: Eddie, has anyone ever told you that you're bad
luck?
Cousin Eddie: Those were my mother's dying words. But I
guess if your body's covered in third degree burns, and
your foot's caught in a bear trap, you tend to start talkin'
crazy.
-Original Message-
Sent: Thursday, July 11, 2002 12:09 PM
To: Multiple recipients of list ORACLE-L
Dennis,
Oracle created the SPFILE which is not humanly readable. There
should
be an
alter database/system command that does the change for you.
According to
what I
heard at Oratechs 2000 editing the init.ora file is now longer
effective.
Dick Goulet
Reply Separator
Author: DENNIS WILLIAMS [EMAIL PROTECTED]
Date: 7/11/2002 7:43 AM
For Oracle 9.2 (Solaris), can anyone tell me where Oracle is
expecting the
init.ora file?
I created the database using dbca. It created an init.ora in
admin/{db_name}/pfile. I moved this to $ORACLE_HOME/dbs and renamed
the
original init.ora file. Then I discovered that Oracle is not reading
the new
init.ora. The database starts fine, with no errors. I tried moving
the
init.ora file back to the original pfile location, but it is still
not
reading it. Specifically, I am trying to set LOG_ARCHIVE_START =
true, but I
have made other changes and they are not taking effect either.
I have searched the documentation, and while there is the new
SPFILE,
there
is no indication how this might affect my problem.
Any insights from someone that has turned archiving on with 9.2
would
be
appreciated.
Dennis Williams
DBA, 20% OCP
Lifetouch, Inc.
[EMAIL PROTECTED]
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: DENNIS WILLIAMS
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing
Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing
Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Freeman, Robert
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing
Lists
Re: PL/Sql Error Handling Package
We have package for logging diferent errors like 1. user error -- for user defined exception 2. system error -- for system exception 3. other error -- for other error 4. debug -- for debug logging every time an exception is caught , based on type a satus is returned to calling program at the same time error is logged calling proc in above package . program generates some bedug string which is logged along with error which helps in debugging . Is it what ur looking for ? -Bp - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, July 11, 2002 1:53 PM Amy one have any decent stanard error handling packages or link to advice on creating such a package? Thanks, Hannah -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: BigP INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Why DDL is not allowed in PL/SQL
I would guess because it's not part of PL/SQL. The DBMS_SQL package and 'EXECUTE IMMEDIATE' both send your SQL to the database engine. You may recall the the engine running PL/SQL is separate from the DBMS engine, at least through 8i. Jared sam d [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 07/11/2002 09:58 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Why DDL is not allowed in PL/SQL Hi List, Why it is not allowed to write DDL(e.g. create table) in PL/SQL directly, but same can be done using DBMS_SQL package. Curious Sam __ Do You Yahoo!? Sign up for SBC Yahoo! Dial - First Month Free http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: sam d INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Where is Oracle 9.2 init.ora?
Man, it scares the heck out of me too that Jared and Kirti are actually doing Oracle -- I can't believe companies actually pay them ;-) And you two guys, and I'm talking to you Kirti and Jared, probably dig in and do things you shouldn't on test boxes just to see how things work and to learn. FWIW, I've heard rumors about other people doing similar things. You've probably even intentionally crashed a DB or pulled the plug just to see if you could recover. Shame on you two. You should both be banished from the list for doing such unconventional things ;-) And neither of you will ever be allowed close to a DB I deal with -- I'll call ltiu from now on ;-) Larry -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of [EMAIL PROTECTED] Sent: Friday, July 12, 2002 8:08 PM To: Multiple recipients of list ORACLE-L Subject: RE: Where is Oracle 9.2 init.ora? Some of us have been around the block a few times. :) Editing binary files is no big deal. You neophytes are all the same. Jared ltiu [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 07/12/2002 04:28 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Where is Oracle 9.2 init.ora? You DBA's must be drunk. Spfiles are in binary format and if you open it in a text editor, all you see are weird characters. Man. You guys are actually doing Oracle? Scares me. ltiu -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Larry Elkins INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: WHICH TABLE NEED TO INCREASE FREELISTS
One suggestion to suggest which table(s) might need increased FREELISTS is to run the following query against V$SQLAREA: select substr(upper(sql_text),1,30), sum(executions) from v$sqlarea where command_type = 2 /* insert */ group by substr(upper(sql_text),1,30) order by 2 desc; The basic idea is that it is only INSERTs that are affected by freelists. The query will display the most frequently executed INSERT statements. Of course, there are many ways this query can provide the wrong picture (i.e. lack of bind-variable use causing unshareable SQL) but that is mitigated somewhat by the SUBSTR() of SQL_TEXT. Anyway, as Anjo says, I wouldn't use the results from this query as proof positive of a need to increase the number of freelists, but I think further cogitation upon the results of this query might lead to an ah ha! situation. As he said, if you know the object, you know it makes sense... - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, July 12, 2002 4:08 PM You want to do something before you know if it would make sense. If you know the object you know it makes sense. Anjo. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, July 12, 2002 10:38 PM Hi Is any way which tables need to increase more freelists? Thx -Seema _ Send and receive Hotmail on your mobile device: http://mobile.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seema Singh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Anjo Kolk INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tim Gorman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Where is Oracle 9.2 init.ora?
I could have SWORN there were problems when manually editing the spfile
file.. if not, why bother creating it when you can just as easily use
the init.ora file?
--- Deshpande, Kirti [EMAIL PROTECTED] wrote:
I did edit it and had no problems while teting my 9i R1 on HP-UX 11.0
:)
- Kirti
-Original Message-
From: Rachel Carmichael [SMTP:[EMAIL PROTECTED]]
Sent: Friday, July 12, 2002 3:18 PM
To: Multiple recipients of list ORACLE-L
Subject:RE: Where is Oracle 9.2 init.ora?
It should NOT however, be edited!
--- Freeman, Robert [EMAIL PROTECTED] wrote:
Oracle created the SPFILE which is not humanly readable.
Mine is pretty easy to read! Maybe you need to check your
character
set???
:-))
RF
Robert G. Freeman - Oracle OCP
Oracle Database Architect
CSX Midtier Database Administration
Author
Oracle9i RMAN Backup and Recovery (Oracle Press - Oct 2002)
Oracle9i New Features (Oracle Press)
Mastering Oracle8i (Sybex)
Clark Griswold: Eddie, has anyone ever told you that you're bad
luck?
Cousin Eddie: Those were my mother's dying words. But I
guess if your body's covered in third degree burns, and
your foot's caught in a bear trap, you tend to start talkin'
crazy.
-Original Message-
Sent: Thursday, July 11, 2002 12:09 PM
To: Multiple recipients of list ORACLE-L
Dennis,
Oracle created the SPFILE which is not humanly readable.
There
should
be an
alter database/system command that does the change for you.
According to
what I
heard at Oratechs 2000 editing the init.ora file is now longer
effective.
Dick Goulet
Reply Separator
Author: DENNIS WILLIAMS [EMAIL PROTECTED]
Date: 7/11/2002 7:43 AM
For Oracle 9.2 (Solaris), can anyone tell me where Oracle is
expecting the
init.ora file?
I created the database using dbca. It created an init.ora in
admin/{db_name}/pfile. I moved this to $ORACLE_HOME/dbs and
renamed
the
original init.ora file. Then I discovered that Oracle is not
reading
the new
init.ora. The database starts fine, with no errors. I tried
moving
the
init.ora file back to the original pfile location, but it is
still
not
reading it. Specifically, I am trying to set LOG_ARCHIVE_START =
true, but I
have made other changes and they are not taking effect either.
I have searched the documentation, and while there is the new
SPFILE,
there
is no indication how this might affect my problem.
Any insights from someone that has turned archiving on with 9.2
would
be
appreciated.
Dennis Williams
DBA, 20% OCP
Lifetouch, Inc.
[EMAIL PROTECTED]
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: DENNIS WILLIAMS
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858)
538-5051
San Diego, California-- Public Internet access / Mailing
Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and
in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You
may
also send the HELP command for other information (like
subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858)
538-5051
San Diego, California-- Public Internet access / Mailing
Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and
in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You
may
also send the HELP command for other information (like
subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Freeman, Robert
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858)
538-5051
San Diego, California-- Public Internet access / Mailing
Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and
in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You
may
also send the HELP command for other information (like
subscribing).
__
Do
RE: Oracle 9.2 spfile catch 22
I want no DBA required so I can retire and relax for a while :) --- Deshpande, Kirti [EMAIL PROTECTED] wrote: I just like that 'dream' of 'no dba required' ;) 'cause I have heard enough presenters mention it... the new self tuning 9i, the new 'everything dynamic' 9i and such.. - Kirti -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: Friday, July 12, 2002 3:14 PM To: Multiple recipients of list ORACLE-L Subject:RE: Oracle 9.2 spfile catch 22 SPFILE concept is good and it is required for reaching the goal of 'no dba required', but it is still far from being 'ready for prime time'. I really don't think the DBA will ever be eliminated. This kind of thing just gives us more time to spend on other aspects of the database. Just consider how much database/computer savvy is needed to make runInstaller work. :) Jared Deshpande, Kirti [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 07/11/2002 01:37 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Oracle 9.2 spfile catch 22 I would get the DB to function the way I want first using init.ora. Then switch to SPFILE from init.ora, while preserving a copy of working init.ora file. Also, when a parameter is changed dynamically with SCOPE=both or spfile, I recreate my init.ora file as the backup. SPFILE concept is good and it is required for reaching the goal of 'no dba required', but it is still far from being 'ready for prime time'. I stopped using SPFILE with a couple of my databases when I was able to add db_cache_size to an spfile that already had db_block_buffers (two mutually exclusive parameters). The next restart of the DB failed. It was good that I had kept the init.ora file. I have not installed 9.2 yet, so I do now know if such things are verified beforehand and prevented. HTH, - Kirti -Original Message- From: DENNIS WILLIAMS [SMTP:[EMAIL PROTECTED]] Sent: Thursday, July 11, 2002 12:49 PM To:Multiple recipients of list ORACLE-L Subject: Oracle 9.2 spfile catch 22 Thanks to everyone for the ideas on the init.ora. You were correct that the answer is indeed with spfile. Now I have discovered a catch-22. Oracle 9.2, Solaris 1. If spfile is created with LOG_ARCHIVE_START = true, database will not start. Receive the error ORA-00439 feature not enabled: Managed Standby 2. Creating the spfile with LOG_ARCHIVE_START = false works and the database starts. Issuing ALTER SYSTEM ARCHIVE LOG START works, but it isn't changed in the spfile, so the next time Oracle is bounced, the archiver doesn't start. This is starting to smell like a bug, but I thought I'd run it past the list on the off-chance someone else has gotten archiving turned on for 9.2. Thanks. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Sign up for SBC Yahoo! Dial - First Month Free http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists
Re: More on the OCP priceing
Steve, yes, now a/o sep 15, if you wait to start down the OCP path, you must take a ILT(instructor led training) before you can get OCP. You can still get OCA w/o it. http://education.oracle.com joe Steve McClure wrote: Am I missing something about the OCP program? The new required class is only required for the new 'Oracle Certified Master' Certification. You can still obtain OCP certification without taking any classes direct from Oracle, right? Steve McClure -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Where is Oracle 9.2 init.ora?
After reading this, I ran to verify what happens when I edited the spfile. Surprisingly I had the same situation (9.0.1 Solaris). Edited the file and started the database without a single error and nothing reported in the alert or bdump. But Oracle used init.ora since non of the settings in spfile were in effect. I can not believe that Oracle starts without any complaints or errors. Probably it's a punishment for editing the holy file! Regards, Waleed -Original Message- Sent: Friday, July 12, 2002 8:53 PM To: Multiple recipients of list ORACLE-L I guess your are right.. I am sincerely sorry about my earlier post. I must be drunk at that time as I could not replicate my test. I was mistaken (happens as I get old... ;) However, let me state the following: SPFILE is in ASCII format (on AIX and HP that I checked) And can be edited via 'the Six Editor' (that is the other name for VI editor per Dave Ensor ;) There is some hashed information maintained in the 1st line based on the contents of the file when it was originally created. I edited the file for a few parameters and bounced the DB. It started fine without any warnings, BUT it silently used the available init.ora file. My changes did not take effect. There was no ORA error or warning. Nothing in alert.log either. When I renamed the init.ora file, and tried to bounce the database, it did not start. But now, following ORA errors were reported... SQL startup ORA-01078: failure in processing system parameters LRM-00109: could not open parameter file '/u01/home/oracle/product/9.0.1/dbs/initKED9.ora' So, the lesson learned is not to edit the SPFILE. And if there is an init.ora file, Oracle will simply use it, if it the SPFILE does not pass the checks based in the hashed information in the 1st line of SPFILE. And hence, there is still some work to be done by Oracle with how SPFILE is implemented. I would like to see an error telling me that available SPFILE is useless before using the available init.ora file. Then I used the corrupted SPFILE to build a new init.ora file and started the database without any problems. I like to 'play' around with throw away databases to see how these new features work and how we can break them, there is nothing wrong in doing so. This is how I 'do oracle' :) Cheers! - Kirti -Original Message- From: ltiu [SMTP:[EMAIL PROTECTED]] Sent: Friday, July 12, 2002 5:27 PM To: [EMAIL PROTECTED]; Deshpande, Kirti Cc: Multiple recipients of list ORACLE-L Subject: RE: Where is Oracle 9.2 init.ora? You DBA's must be drunk. Spfiles are in binary format and if you open it in a text editor, all you see are weird characters. Man. You guys are actually doing Oracle? Scares me. ltiu Quoting Deshpande, Kirti [EMAIL PROTECTED]: I did edit it and had no problems while teting my 9i R1 on HP-UX 11.0 :) - Kirti -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Khedr, Waleed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Plagiarism?
Asking the author to publish it on your website should also be part of it. That has some CYA function also ;-) - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Saturday, July 13, 2002 12:08 AM Quick answer: If you make it clear that you are not the author of the papers and indicate who the real authors are then you are not guilty of plagarism. What the copywrite issues are is a much longer answer. I'm not sure that a definative answer exists but if there is a copywrite notice attached it should not be removed, that's for sure. Jamadagni, RajendraTo: Multiple recipients of list ORACLE-L Rajendra.Jam[EMAIL PROTECTED] adagni cc: @espn.com Subject: RE: Plagiarism? Sent by: root 07/12/2002 05:08 PM Please respond to ORACLE-L It depends on what your definition of is is. BTW a question to all the ethics guru's... A lot of people have put out lots of papers, articles on their website, which can be downloaded for personal use. Would there be a ethics violation if I were to make a HTML page on my file system and access these articles through that (sort of a pseudo INTRAnet). This would make it easy for me to click on the link and access the information rather than search through the directories? Is this ethics violation? Remember that the whole article is as is i.e. all copyright info etc is still intact. Let me repeat it is INTRANET, not available to anyone unless you have privs to the directory. Please enlighten me. Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! -Original Message- Sent: Friday, July 12, 2002 4:57 PM To: Multiple recipients of list ORACLE-L Once you lose your ethics, the rest is easy. :( Attachment Removed : InterScan_Disclaimer.txt -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thomas Day INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Anjo Kolk INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
SQL query
I am using an Oracle database running in Linux. I would like to view the description of a table. For ex., if there is a table called 'person'. I would like to see the names of the columns in this table, their datatypes and such other details. In other dbmss like mysql a command 'describe tablename' gives the information. What is the equivalent in Oracle? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vandana INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
