RE: Transparent database objects after merging
Ave ! If it's so, that user_a like to use customer table and user_b customer_b table with same application, why You can't use synonyms? User_a synonyms points to customer table and user_b synonyms points customer_b table etc. Or is there some decision making before start using application: "Now I want use customer table and now I want user customer_b table"? If so, create two database users, whose synonyms points to different tables. When user logs in, he selects appropriate login username depends, which tables he wants to use. Too simple :) ? HTH Jorma -Original Message-From: ext [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]Sent: 16 July, 2003 07:29To: Multiple recipients of list ORACLE-LSubject: Re: Transparent database objects after mergingThank you for your idea, Mark, To explain more about the problem Before we have 2 databases which they both have same sturcture and same database objects names. We have 2 set of D2K forms and reports to access to each database. After merging, we looking for move data from database B to database A but still be able to access by using the different of forms and reports. However the tables which be move from database B to datbase A, will be rename to table_B. The developer just throw me a fire ball that what-if they don't modify the forms and reposts, is it possible to have one set of the forms access the table_B UK "Mark Richard" [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 07/16/2003 12:14 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject: Re: Transparent database objects after mergingAlso, depending on your requirements (which I don't fully understand)another approach may involve using views:The CUSTOMERS view could point to either CUSTOMERS_A, CUSTOMERS_B or eventhe merge of both tables (select * from customers_a union all select * fromcustomers_b) if required. Of course you may introduce primary and foreignkey problems, but like I said - I don't fully understand your requirementso I'm just throwing ideas up in the air.Regards, Mark. "Arup Nanda" [EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] om cc: Sent by: Subject: Re: Transparent database objects after merging [EMAIL PROTECTED] .com 16/07/2003 13:59 Please respond to ORACLE-L You can drop or rename CUSTOMERS to, say, CUSTOMERS_A, and then createsynonym CUSTOMERS pointing to CUSTOMERS_B. Or rename CUSTOMERS_B toCUSTOMERS.HTH.Arup Nanda- Original Message -From: [EMAIL PROTECTED]To: Multiple recipients of list ORACLE-LSent: Tuesday, July 15, 2003 11:29 PMSubject: Transparent database objects after mergingHello Gurus, I'm working merging 2 databases which have sane structure ofdatabase objects into one database. However, after merging, the businesspolicies and regulations force us to have 2 set of database objects; forexample :Database A has CUSTOMERS table.Database B has CUSTOMERS table.After merging database A will have CUSTOMERS and CUSTOMERS_B (data fromdatabase B). I just wonder that is there any way that we don't need tochange our script in forms and reports to point into a new table name butstill can access to the data in the new table ( CUSTOMERS_B) notCUSTOMERS.Thank you for any comment and suggestion.Ukrit K, Privileged/Confidential information may be contained in this message. If you are not the addressee indicated in this message (or responsible for delivery of the message to such person), you may not copy or deliver this message to anyone.In such case, you should destroy this message and kindly notify the sender by reply e-mail or by telephone on (61 3) 9612-6999. Please advise immediately if you or your employer does not consent to Internet e-mail for messages of this kind. Opinions, conclusions and other information in this message that do not relate to the official business of Transurban City Link Ltdshall be
RE: How to make SPFILE in sync with INIT.ORA ?
Hi, The java_pool_size can also be edited through sqlplus just use 'scope=spfile' (You'll need to bounce though). No need to open pfile edit and create spfile. Quite frankly I like to think that using SQL*Plus to edit the spfile directly gives me added benefit of a syntax check (Ran a very very tiny test once). Jack -Original Message- Sent: Wednesday, July 16, 2003 4:14 AM To: Multiple recipients of list ORACLE-L The ability to change the system parameters without bouncing the system is not provided by spfile, neither in RAC nor single instance databas. It depends upon the the parameter that can be changed dynamically or not. I guess you wanted to convey the impression that the using spfiles the parameters can be changed and the changes can be persistent across shutdowns. But that is not just in RAC; it's true for single instance DBs, too. Now, suppose you want to set a parameter that can't be changed using ALTER SYSTEM, such as, say, java_pool_size. How do you plan to make the change? You have to open up the old favorite init.ora file and start the database with pfile=init.ora option. At that stage the spfile is not active and your issuing Alter system set db_cache_size = 800m scope = [ memory | spfile | both ] sid = * has no effect. You must create the spfile from the pfile and then use the newly created spfile to use this dynamic parameter persistent. Note the complexity involved - spfile allowed you to make the changes to some parmeters using alter system persistent; but for all other parametrs you are forced to use pfile. What happens if you ommit the pfile=init.ora clause? The database will pickup the spfile, which will _not_ have your changes. To fully appreciate the value of the spfile parameter, Oracle should have allowed editing spfile directly and completely done away with pfile. Splitting functionality across two different implementations adds to difficulties, does not resolve them. I hope future versions of Oracle do offer that functionality. It's not that difficult or unheard of, either. Listener.ora, tnsnames.ora are all editable and also read by Net Assistant. just my .02 Arup Nanda - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, July 15, 2003 8:09 PM Spfile is shared and can be modified dynamically without bouncing the instances. Eg. Alter system set db_cache_size = 800m scope = [ memory | spfile | both ] sid = * Without spfile, you can still make this change dynamically in memory, but you would have to manually update init.ora file to reflect your change. Spfile allows you to automatically capture these dynamic changes. Gerardo -Original Message- Sent: Tuesday, July 15, 2003 4:45 PM To: Multiple recipients of list ORACLE-L And how, exactly? - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, July 15, 2003 7:29 PM You'll appreciate spfiles if you're using RAC. -Original Message- Sent: Tuesday, July 15, 2003 2:09 PM To: Multiple recipients of list ORACLE-L And create pfile from spfile; does a similar job. I'm rapidly beginning to think that spfiles are just not worth it. Now how to reverse the policy decision having mandated them for 9i installs :( Niall -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Arup Nanda Sent: 15 July 2003 04:44 To: Multiple recipients of list ORACLE-L Subject: Re: How to make SPFILE in sync with INIT.ORA ? As user sys, issue CREATE SPFILE FROM PFILE; This will create the spfile. You must have started the database using the pfile to use this command. HTH. Arup Nanda - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, July 14, 2003 10:59 PM Guys, i have a 9iR2/win2k test instance. i just renamed CONTROL01.CTL once and tried to start the instance. SQLstartup But it gave a ORA-00205 error. so i removed CONTROL01.CTL from INIT.ORA file and started the instance SQLstartup pfile='d:\oracle\admin\pe92\pfile\init.ora' Now it worked fine. BUT: SQLstartup This is not possible because the SPFILE still has CONTROL01.CTL in it. How do i make my SPFILE in sync with the INIT.ORA ? Regards, Jp. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Prem Khanna J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services -- -- - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the
AW: Object Types in PL/SQL
Thanks all. Looks like I'll have to go with the add-an-extra-parameter
method for now as a workaround.
I don't know yet wether we're going to raise a TAR right away. The manual is
a little bit unclear about overriding the default constructor. So I might
contact a friend at Oracle first. I'll post any results on that.
We actually don't use Object Types that much (who does anyway ;). But I have
to say, that I'm a little bit disappointed by Oracle's implementation (Ever
heard of information hiding and encapsulation, Larry ?). If every developer
using the type will be allowed to set the attributes (to whatever value),
what's the point ? How about private vs. public ?! Well, at least they
give you a way to initialize Object Types somehow.
Stefan
-Ursprüngliche Nachricht-
Von: Pardee, Roy E [mailto:[EMAIL PROTECTED]
Gesendet: Dienstag, 15. Juli 2003 16:59
An: Multiple recipients of list ORACLE-L
Betreff: RE: Object Types in PL/SQL
This doesn't answer your question directly, but if you aren't able to
override the constructor explicitly, you can probably create a static
function that creates, initializes returns a tVNR as you would like it.
HTH,
-Roy
Roy Pardee
Programmer/Analyst/DBA
SWFPAC Lockheed Martin IT
Extension 8487
-Original Message-
Sent: Tuesday, July 15, 2003 3:49 AM
To: Multiple recipients of list ORACLE-L
Hi list
I have a problem regardint PL/SQL Object Types. According to the fine
manual, it should be
possible to override the default constructor (I'm on 9.2.0.3.0 Win2k). I did
that, Object Type
compiles without complaints:
CREATE OR REPLACE TYPE tVNR AS OBJECT
(
vVNR VARCHAR2(14),
CONSTRUCTOR FUNCTION tVNR(piVNR VARCHAR2)
RETURN SELF AS RESULT,
MEMBER FUNCTION getVNR
RETURN VARCHAR2
) INSTANTIABLE FINAL;
CREATE OR REPLACE TYPE BODY tVNR AS
CONSTRUCTOR FUNCTION tVNR(piVNR VARCHAR2)
RETURN SELF AS RESULT IS
BEGIN
IF (LENGTH(piVNR)=11) THEN
SELF.vVNR := SUBSTR(piVNR,1,4) || '.' || SUBSTR(piVNR,5,4) || '.' ||
SUBSTR(piVNR,9,3);
ELSE
SELF.vVNR := 'invalid';
END IF;
RETURN;
END;
MEMBER FUNCTION getVNR RETURN VARCHAR2 IS
BEGIN
RETURN SELF.vVNR;
END;
END;
Now, everytime I want to create an object like this:
declare
vVNR tVNR;
begin
vVNR := new tVNR('12345678901');
dbms_output.put_line(vVNR.getVNR());
end;
I get the following error message:
ERROR at line 4:
ORA-06550: line 4, column 15:
PLS-00307: too many declarations of 'TVNR' match this call
ORA-06550: line 4, column 3:
PL/SQL: Statement ignored
Looks to me like the PL/SQL enginge isn't able to distinguish the default
constructor from the
overridden (my) version, since they have the same signature (of course).
Any input ? I couldn't find ANY descenct hints in the fine manual or the
Feuerstein book :(.
TIA,
Stefan
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Stefan Jahnke
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Pardee, Roy E
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Stefan Jahnke
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
RE: Rollback Segs
Which database version are you using? as long as I know, at least on Oracle 8.0.6 you can not specify which rollback segment a particular transaction should use. We disable all rollback segments and only enable those which we know won't make big updates / deletes crash. -Mensaje original-De: venkat Rama [mailto:[EMAIL PROTECTED]Enviado el: miércoles, 16 de julio de 2003 6:34Para: Multiple recipients of list ORACLE-LAsunto: Rollback Segs Hi Friends, I have 150Gb database with 30 rollback segs with optimal settings!! for normal operations no problems!! But we are doing massive updates for some ofbig tables!! So we are using vb programs and connecting to the database thru odbc dsn. My first question is how to set transaction use rollback segment rbs_big? I tried to set as first stmt, but its not using rbs_big segment, its using some other rollback segment. Is that good idea to make all my rollback segs maxextents unlimited to avoid maxextents reached error?? I have lot of rbs space nearly 10Gb. I saw one time, one of my rbs segment extented 2gb and failed transaction with maxextents reached with 5m initial and next, minextents 20 and optimal 100M. Any help will be appreciated Thanks venkat. Do you Yahoo!?SBC Yahoo! DSL - Now only $29.95 per month!
RE: Rollback Segs
set transaction use rollback segment only works if it's the first statement in your transaction, an easy way to make sure this is the case is to issue a commit directly before issuing this statement. I believe this has been a feature of Oracle since way back in version 7 (Correct me if I'm wrong). Hope this helps. Cheers Lee -Original Message-From: Fermin Bernaus [mailto:[EMAIL PROTECTED]Sent: 16 July 2003 09:09To: Multiple recipients of list ORACLE-LSubject: RE: Rollback Segs Which database version are you using? as long as I know, at least on Oracle 8.0.6 you can not specify which rollback segment a particular transaction should use. We disable all rollback segments and only enable those which we know won't make big updates / deletes crash. -Mensaje original-De: venkat Rama [mailto:[EMAIL PROTECTED]Enviado el: miércoles, 16 de julio de 2003 6:34Para: Multiple recipients of list ORACLE-LAsunto: Rollback Segs Hi Friends, I have 150Gb database with 30 rollback segs with optimal settings!! for normal operations no problems!! But we are doing massive updates for some ofbig tables!! So we are using vb programs and connecting to the database thru odbc dsn. My first question is how to set transaction use rollback segment rbs_big? I tried to set as first stmt, but its not using rbs_big segment, its using some other rollback segment. Is that good idea to make all my rollback segs maxextents unlimited to avoid maxextents reached error?? I have lot of rbs space nearly 10Gb. I saw one time, one of my rbs segment extented 2gb and failed transaction with maxextents reached with 5m initial and next, minextents 20 and optimal 100M. Any help will be appreciated Thanks venkat. Do you Yahoo!?SBC Yahoo! DSL - Now only $29.95 per month! This e-mail message (including any attachment) is intended only for the personal use of the recipient(s) named above. This message is confidential and may be legally privileged. If you are not an intended recipient, you may not review, copy or distribute this message. If you have received this communication in error, please notify us immediately by e-mail and delete the original message. Any views or opinions expressed in this message are those of the author only. Furthermore, this message (including any attachment) does not create any legally binding rights or obligations whatsoever, which may only be created by the exchange of hard copy documents signed by a duly authorised representative of Hutchison 3G UK Limited.
OT: BANN
Hi Group
Where I can get the details about BANN.
TIA
Senthil.
-Original Message-
Stefan Jahnke
Sent: Wednesday, July 16, 2003 1:34 PM
To: Multiple recipients of list ORACLE-L
Thanks all. Looks like I'll have to go with the add-an-extra-parameter
method for now as a workaround.
I don't know yet wether we're going to raise a TAR right away. The manual is
a little bit unclear about overriding the default constructor. So I might
contact a friend at Oracle first. I'll post any results on that.
We actually don't use Object Types that much (who does anyway ;). But I have
to say, that I'm a little bit disappointed by Oracle's implementation (Ever
heard of information hiding and encapsulation, Larry ?). If every developer
using the type will be allowed to set the attributes (to whatever value),
what's the point ? How about private vs. public ?! Well, at least they
give you a way to initialize Object Types somehow.
Stefan
-Ursprüngliche Nachricht-
Von: Pardee, Roy E [mailto:[EMAIL PROTECTED]
Gesendet: Dienstag, 15. Juli 2003 16:59
An: Multiple recipients of list ORACLE-L
Betreff: RE: Object Types in PL/SQL
This doesn't answer your question directly, but if you aren't able to
override the constructor explicitly, you can probably create a static
function that creates, initializes returns a tVNR as you would like it.
HTH,
-Roy
Roy Pardee
Programmer/Analyst/DBA
SWFPAC Lockheed Martin IT
Extension 8487
-Original Message-
Sent: Tuesday, July 15, 2003 3:49 AM
To: Multiple recipients of list ORACLE-L
Hi list
I have a problem regardint PL/SQL Object Types. According to the fine
manual, it should be
possible to override the default constructor (I'm on 9.2.0.3.0 Win2k). I did
that, Object Type
compiles without complaints:
CREATE OR REPLACE TYPE tVNR AS OBJECT
(
vVNR VARCHAR2(14),
CONSTRUCTOR FUNCTION tVNR(piVNR VARCHAR2)
RETURN SELF AS RESULT,
MEMBER FUNCTION getVNR
RETURN VARCHAR2
) INSTANTIABLE FINAL;
CREATE OR REPLACE TYPE BODY tVNR AS
CONSTRUCTOR FUNCTION tVNR(piVNR VARCHAR2)
RETURN SELF AS RESULT IS
BEGIN
IF (LENGTH(piVNR)=11) THEN
SELF.vVNR := SUBSTR(piVNR,1,4) || '.' || SUBSTR(piVNR,5,4) || '.' ||
SUBSTR(piVNR,9,3);
ELSE
SELF.vVNR := 'invalid';
END IF;
RETURN;
END;
MEMBER FUNCTION getVNR RETURN VARCHAR2 IS
BEGIN
RETURN SELF.vVNR;
END;
END;
Now, everytime I want to create an object like this:
declare
vVNR tVNR;
begin
vVNR := new tVNR('12345678901');
dbms_output.put_line(vVNR.getVNR());
end;
I get the following error message:
ERROR at line 4:
ORA-06550: line 4, column 15:
PLS-00307: too many declarations of 'TVNR' match this call
ORA-06550: line 4, column 3:
PL/SQL: Statement ignored
Looks to me like the PL/SQL enginge isn't able to distinguish the default
constructor from the
overridden (my) version, since they have the same signature (of course).
Any input ? I couldn't find ANY descenct hints in the fine manual or the
Feuerstein book :(.
TIA,
Stefan
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Stefan Jahnke
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Pardee, Roy E
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Stefan Jahnke
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official
Re: Online tech books - Not online anymore
Remember this one well it seems the publisher may have had some impact No books now with some bullshit apology about bandwidth issues HAHAHAHA Cheers -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238 Facsimile: +61 (0)7 3303 3048 = A great pleasure in life is doing what people say you cannot do. - Walter Bagehot (1826-1877 British Economist) = Mincom The People, The Experience, The Vision = This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please delete it and notify the sender. The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Group of companies unless expressly stated otherwise. Bob Metelsky [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 19-06-2003 02:04 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Online tech books This was just passed on to me and I'd like to share it wit the list... http://www.palaydium.net/tech/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: enterprise manager
Check (in Control Panel) if your OMS service is running. Gudmundur hi i run ora8 on w2000 server. my problem is i can ping my database mydb without problems i can login with sqlplus as sys and it works fine but if i start the enterprise manager console and try to login as sys a error occours and means please check the management server status and settings. as managementserver i select mydb. what ican be the problem? thx martin Þessi póstur var sendur með vefpósti mi, http://www.mi.is -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gudmundur Bjarni Josepsson INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Rollback Segs
Yes you are right, sorry but I made a mistake, since we are using Baan IVc4 which works against Oracle we have no means to interfere with its transactions when they are commited to Oracle and we can not modify them so that it uses a specific rollback segment, so the only way for us to do it is to disable all except the one we want it to use. -Mensaje original-De: Lee Cullip [mailto:[EMAIL PROTECTED]Enviado el: miércoles, 16 de julio de 2003 10:54Para: Multiple recipients of list ORACLE-LAsunto: RE: Rollback Segs set transaction use rollback segment only works if it's the first statement in your transaction, an easy way to make sure this is the case is to issue a commit directly before issuing this statement. I believe this has been a feature of Oracle since way back in version 7 (Correct me if I'm wrong). Hope this helps. Cheers Lee -Original Message-From: Fermin Bernaus [mailto:[EMAIL PROTECTED]Sent: 16 July 2003 09:09To: Multiple recipients of list ORACLE-LSubject: RE: Rollback Segs Which database version are you using? as long as I know, at least on Oracle 8.0.6 you can not specify which rollback segment a particular transaction should use. We disable all rollback segments and only enable those which we know won't make big updates / deletes crash. -Mensaje original-De: venkat Rama [mailto:[EMAIL PROTECTED]Enviado el: miércoles, 16 de julio de 2003 6:34Para: Multiple recipients of list ORACLE-LAsunto: Rollback Segs Hi Friends, I have 150Gb database with 30 rollback segs with optimal settings!! for normal operations no problems!! But we are doing massive updates for some ofbig tables!! So we are using vb programs and connecting to the database thru odbc dsn. My first question is how to set transaction use rollback segment rbs_big? I tried to set as first stmt, but its not using rbs_big segment, its using some other rollback segment. Is that good idea to make all my rollback segs maxextents unlimited to avoid maxextents reached error?? I have lot of rbs space nearly 10Gb. I saw one time, one of my rbs segment extented 2gb and failed transaction with maxextents reached with 5m initial and next, minextents 20 and optimal 100M. Any help will be appreciated Thanks venkat. Do you Yahoo!?SBC Yahoo! DSL - Now only $29.95 per month!This e-mail message (including any attachment) is intended only for the personal use of the recipient(s) named above. This message is confidential and may be legally privileged. If you are not an intended recipient, you may not review, copy or distribute this message. If you have received this communication in error, please notify us immediately by e-mail and delete the original message.Any views or opinions expressed in this message are those of the author only. Furthermore, this message (including any attachment) does not create any legally binding rights or obligations whatsoever, which may only be created by the exchange of hard copy documents signed by a duly authorised representative of Hutchison 3G UK Limited.
Oracle Instances not starting up via services
Hi All, I have inherited a couple of databases on one of the servers here. The server was taken down for hardware repairs during the week and when it came back up the databases did not start. (They are set to start automatically via the services) I have done some research via the internet and I deleted and recreated the service via the ORADIM utility. But this has n't fixed it. I have to manually go into and start the databases (explicitly stating where the init.ora file is) I am getting this error message when I go in via SQLPLUS /NOLOG (connected as internal) Startup error message LRM-00109 can not open parameter file '%oracle_home%/database/init%oracle_sid%.ora If I do a startup pfile=c:\oracle\ora81\database\initwms.ora it starts as normal. I've checked that the oracle home is defined as c:\oracle\ora81 so I am beginning to suspect it has something to do with the oracle sid. In registry the ora_wms_pfile location is set to c:\oracle\ora8\database\initwms.ora We have 4 different instances on this box and none of them will start automatically. Oracle version 8.1.7 running on a Windows Server 2000 box Any help appreciated, Thanks, N. winmail.dat
RE: inline views
Daniel, List Can you give more detail with an EXAMPLE please ? Thanks -Original Message- Sent: Friday, June 06, 2003 7:05 PM To: Multiple recipients of list ORACLE-L I have used an inline view to reduce network traffic when retrieiving data from a remote db. Instead of using a nested loop and making multiple trips, it made 1 trip and brought over all of the data. The query time was reduced from 30 minutes to 5 minutes. -- Daniel W. Fink http://www.optimaldba.com VIVEK_SHARMA wrote: Where are they advantageous to use where not ? Thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: VIVEK_SHARMA INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
re: how to keep SPFILE in Sync...
Group, I try to only use spfile if I HAVE TO, avoid it if possible. conservatism ? maybe. I agree with all arguments against spfile posted so far. RAC : use a CFS and keep a single, central db.ini somewhere, link your ORACLE_HOME/dbs/initINST.ora to it. If you have to use spfiles (RAC on RAW-dev, yuk), monitor gv$parameters for any modified parameters, and report those regularly as part of your daily monitoring. Also, re-create a pfile-from-sp as you would also spool a controlfile-2-trace, and include all of this in your backup. (am I making a dinosaur-fool out of myself ? comments welcome) Wishlist: Fully Editable spfile, but only if it does not add another utility to the toolbox. Any preview on how this will be done in 10i yet ? Regards, PdV -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Piet de Visser INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: RE: security without using different usernames
i know you can get the IP in a client-server mode and i think its with sys_context. Ill have to look it up. in web mode you have to use a client side script. I know there is a javabean you can write to do it(its actually in the forms 9i demo). dont know how to do it in .net(which is what we are using), but Im sure its doable. .net is just a clone of java anyway with a different framework. the IP sounds more scalable in case we go to the web in the future. Ill have to check with the client and see how they purchase IP addressse and if any of the users are logging in from home etc... when LANs are setup businesses typically buy IP addresses in batches. So you get something like 122.122.122.xxx for your building. what you have to go through to overcome a poor design :( From: Mark Brooks [EMAIL PROTECTED] Date: 2003/07/15 Tue PM 11:59:30 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: security without using different usernames Some time in the past year or so I was reading an article about a similar problem where they needed to change behavior based on where the connection originated. I remember something about using IP addresses to drive the different behaviors. Sorry I can't remember more. It didn't apply to anything I was doing at the time so I didn't really get into the details. Might be something to consider. -Original Message- Mark Richard Sent: Tuesday, July 15, 2003 6:29 PM To: Multiple recipients of list ORACLE-L I think the idea was always roles plus setting current schema - not just roles on their own. Heck, I'd be so paranoid that I'd make the default schema empty rather than belonging to a specific site so that if the executable isn't renamed then it connects to an empty database - it will make it much easier to track the chance. I was considering suggesting looking at the IP address to try and determine originating site but it carries too much risk - dynamic IP's, changing IP's, etc. It seems like renaming the executable might be the safest approach - as long as you make the default schema redundant. I guess you might have some impact on your ability to tune and debug the application and monitor usage when everyone is connecting as the same user but that will be something you'll have to live with. I guess you could shoe-horn some other parameters in with the set schema command if different sites have different performance demands (sort_area_size, etc) - just create a config table in the default schema and write a fancy logon trigger. Ryan [EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Sent by: Subject: Re: security without using different usernames [EMAIL PROTECTED] .com 16/07/2003 09:44 Please respond to ORACLE-L roles wont work. The tables in the different schemas all have the same names. The application is not coded to 'schemaA.table'. Its just set to the table. roles plus setting the schema is possible to be 'safe' with security. I like that idea. - Original Message - From: AK To: Multiple recipients of list ORACLE-L Sent: Tuesday, July 15, 2003 7:24 PM Subject: Re: security without using different usernames you can create multiple roles also . So if you have schema a,b,c and they use Z as userid to login then create role_a, role_b, role_c where role_a has permissions for object in schema a and role_b has permissions for schema b . Enable proper role at the time of startup ( embadded in client code ). -ak - Original Message - From: Ryan To: Multiple recipients of list ORACLE-L Sent: Tuesday, July 15, 2003 3:29 PM Subject: security without using different usernames I know this is terrible design, but the GUI was created by a software engineering group that is seperate from the database group. Its not scalable. So Im trying to come up with a more scalable method. I have no power to change their gui. It rides on the database. I have to live with it. This is not a high enough transaction database to warrant seperate instances. We have a variety of customers. Each of them has their own versions of data. However, the schema is exactly the same. These tables can get huge, so we dont want to throw them all into the same schema. Right now, due to the fact that the GUI has a series of logins that are the same across clients, each client has its own instance. This isnt very scalable as we get more business. We have to create another instance and ingest data to it. Id like to find a way to get all the clients in the same instance with just different schemas and
Re: Object Types in PL/SQL
- Original Message - We actually don't use Object Types that much (who does anyway ;). But I have to say, that I'm a little bit disappointed by Oracle's implementation (Ever I do. Only way to use some of the DMBS_* library items and one of the best ways of speeding up Java/JDBC interaction. Not a pure OO implementation, but then again I don't need one: just a way to get the work done efficiently. Plus the object-relational views are quite nice to return object hierarchies (in 9i...). Cheers Nuno Souto [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nuno Souto INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Re: Object Types in PL/SQL
how does the object features improve performance of the jdbc? its fairly common now to have a java or .net(which we are using) and an Oracle backend. your comments would be much appreciated. From: Nuno Souto [EMAIL PROTECTED] Date: 2003/07/16 Wed AM 07:54:32 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: Object Types in PL/SQL - Original Message - We actually don't use Object Types that much (who does anyway ;). But I have to say, that I'm a little bit disappointed by Oracle's implementation (Ever I do. Only way to use some of the DMBS_* library items and one of the best ways of speeding up Java/JDBC interaction. Not a pure OO implementation, but then again I don't need one: just a way to get the work done efficiently. Plus the object-relational views are quite nice to return object hierarchies (in 9i...). Cheers Nuno Souto [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nuno Souto INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: RE: inline views
you can get the same performance improvements by passing a REF Cursor out to the client also. basically he is saying that if you are over a network particularly in a web application where you cant always control the speed of the internet access that the client is using and you do: select column from table where column = 1; Oracle will do a series of 'fetches' across SQLNET. Which it will get some records, then go back and request some more and so on... this means you have alot of network trips. Since your not getting everything at once. So you increase network traffic with the additional 'requests' and you increase wait time just going back and forth. Its like a busdriver competing against a sports car driver to see who can get the most people to an end location. Bus is slow but can carry alot of people per trip and the sports car is faster but can only carry a few people per trip. So the inline view does more work up front on the database side: select col from (select col from table where x = 1) so you are 'shrinking' the size of the table you are selecting from. Now the way I have done it is to pass a REF Cursor, which I think(though I have not tested it) gives even better performance. Why? Well you are saying on the database side: Get everything from this query and put it in the REF Cursor, then in one pass send the whole REF Cursor to the client. Also you need inline views to solve some questions. Such as how to get records M through N from a resultset. From: VIVEK_SHARMA [EMAIL PROTECTED] Date: 2003/07/16 Wed AM 07:54:25 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: inline views Daniel, List Can you give more detail with an EXAMPLE please ? Thanks -Original Message- Sent: Friday, June 06, 2003 7:05 PM To: Multiple recipients of list ORACLE-L I have used an inline view to reduce network traffic when retrieiving data from a remote db. Instead of using a nested loop and making multiple trips, it made 1 trip and brought over all of the data. The query time was reduced from 30 minutes to 5 minutes. -- Daniel W. Fink http://www.optimaldba.com VIVEK_SHARMA wrote: Where are they advantageous to use where not ? Thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: VIVEK_SHARMA INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
AW: Re: Object Types in PL/SQL
Blind shot: I guess what's meant here is speed up the development because you safe your usual OR mapping problems. ??? Prost, Stefan -Ursprüngliche Nachricht- Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Gesendet: Mittwoch, 16. Juli 2003 14:20 An: Multiple recipients of list ORACLE-L Betreff: Re: Re: Object Types in PL/SQL how does the object features improve performance of the jdbc? its fairly common now to have a java or .net(which we are using) and an Oracle backend. your comments would be much appreciated. From: Nuno Souto [EMAIL PROTECTED] Date: 2003/07/16 Wed AM 07:54:32 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: Object Types in PL/SQL - Original Message - We actually don't use Object Types that much (who does anyway ;). But I have to say, that I'm a little bit disappointed by Oracle's implementation (Ever I do. Only way to use some of the DMBS_* library items and one of the best ways of speeding up Java/JDBC interaction. Not a pure OO implementation, but then again I don't need one: just a way to get the work done efficiently. Plus the object-relational views are quite nice to return object hierarchies (in 9i...). Cheers Nuno Souto [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nuno Souto INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stefan Jahnke INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Rollback Segs
I think that's probably the case with most third party applications, if developers haven't coded their apps to use a large rollback segment for certain transactions (which I find is the case with most developers ;-) ) then the only option is to turn off all but the large rollback seg. Cheers Lee -Original Message-From: Fermin Bernaus [mailto:[EMAIL PROTECTED]Sent: 16 July 2003 11:19To: Multiple recipients of list ORACLE-LSubject: RE: Rollback Segs Yes you are right, sorry but I made a mistake, since we are using Baan IVc4 which works against Oracle we have no means to interfere with its transactions when they are commited to Oracle and we can not modify them so that it uses a specific rollback segment, so the only way for us to do it is to disable all except the one we want it to use. -Mensaje original-De: Lee Cullip [mailto:[EMAIL PROTECTED]Enviado el: miércoles, 16 de julio de 2003 10:54Para: Multiple recipients of list ORACLE-LAsunto: RE: Rollback Segs set transaction use rollback segment only works if it's the first statement in your transaction, an easy way to make sure this is the case is to issue a commit directly before issuing this statement. I believe this has been a feature of Oracle since way back in version 7 (Correct me if I'm wrong). Hope this helps. Cheers Lee -Original Message-From: Fermin Bernaus [mailto:[EMAIL PROTECTED]Sent: 16 July 2003 09:09To: Multiple recipients of list ORACLE-LSubject: RE: Rollback Segs Which database version are you using? as long as I know, at least on Oracle 8.0.6 you can not specify which rollback segment a particular transaction should use. We disable all rollback segments and only enable those which we know won't make big updates / deletes crash. -Mensaje original-De: venkat Rama [mailto:[EMAIL PROTECTED]Enviado el: miércoles, 16 de julio de 2003 6:34Para: Multiple recipients of list ORACLE-LAsunto: Rollback Segs Hi Friends, I have 150Gb database with 30 rollback segs with optimal settings!! for normal operations no problems!! But we are doing massive updates for some ofbig tables!! So we are using vb programs and connecting to the database thru odbc dsn. My first question is how to set transaction use rollback segment rbs_big? I tried to set as first stmt, but its not using rbs_big segment, its using some other rollback segment. Is that good idea to make all my rollback segs maxextents unlimited to avoid maxextents reached error?? I have lot of rbs space nearly 10Gb. I saw one time, one of my rbs segment extented 2gb and failed transaction with maxextents reached with 5m initial and next, minextents 20 and optimal 100M. Any help will be appreciated Thanks venkat. Do you Yahoo!?SBC Yahoo! DSL - Now only $29.95 per month!This e-mail message (including any attachment) is intended only for the personal use of the recipient(s) named above. This message is confidential and may be legally privileged. If you are not an intended recipient, you may not review, copy or distribute this message. If you have received this communication in error, please notify us immediately by e-mail and delete the original message.Any views or opinions expressed in this message are those of the author only. Furthermore, this message (including any attachment) does not create any legally binding rights or obligations whatsoever, which may only be created by the exchange of hard copy documents signed by a duly authorised representative of Hutchison 3G UK Limited.
10i reg.
http://www.pro-dba.com/oracle_10i.html http://www.dbasupport.com/oracle/news/unixcluster.shtml __ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: kommareddy sreenivasa INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle Instances not starting up via services
Hi, Reading your mail, your registry setting for ora_wms_pfile is set to c:\oracle\ora8\database\initwms.ora, but your oracle home is c:\oracle\ora81, not sure if this is just a typo, but it may help you. Cheers Lee -Original Message- Sent: 16 July 2003 12:24 To: Multiple recipients of list ORACLE-L Hi All, I have inherited a couple of databases on one of the servers here. The server was taken down for hardware repairs during the week and when it came back up the databases did not start. (They are set to start automatically via the services) I have done some research via the internet and I deleted and recreated the service via the ORADIM utility. But this has n't fixed it. I have to manually go into and start the databases (explicitly stating where the init.ora file is) I am getting this error message when I go in via SQLPLUS /NOLOG (connected as internal) Startup error message LRM-00109 can not open parameter file '%oracle_home%/database/init%oracle_sid%.ora If I do a startup pfile=c:\oracle\ora81\database\initwms.ora it starts as normal. I've checked that the oracle home is defined as c:\oracle\ora81 so I am beginning to suspect it has something to do with the oracle sid. In registry the ora_wms_pfile location is set to c:\oracle\ora8\database\initwms.ora We have 4 different instances on this box and none of them will start automatically. Oracle version 8.1.7 running on a Windows Server 2000 box Any help appreciated, Thanks, N. This e-mail message (including any attachment) is intended only for the personal use of the recipient(s) named above. This message is confidential and may be legally privileged. If you are not an intended recipient, you may not review, copy or distribute this message. If you have received this communication in error, please notify us immediately by e-mail and delete the original message. Any views or opinions expressed in this message are those of the author only. Furthermore, this message (including any attachment) does not create any legally binding rights or obligations whatsoever, which may only be created by the exchange of hard copy documents signed by a duly authorised representative of Hutchison 3G UK Limited. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Lee Cullip INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re:unix shell script question
Hi Pete, Garry and Stephan, Thanx a lot for the solution. It is working for me. Thanx once again, Regards, ~Dilip Get Your Private, Free E-mail from Indiatimes at http://email.indiatimes.com Buy The Best In BOOKS at http://www.bestsellers.indiatimes.com Bid for for Air Tickets @ Re.1 on Air Sahara Flights. Just log on to http://airsahara.indiatimes.com and Bid Now ! -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Dilip INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
how to schedule a job every alternate sundays in unix cron
Hello All, OS: Solaris 2.8 I have to run a backup script in every alternate Sunday. I cant find a way to submit it in cron. Can somebody help me how to setup a job to run alternate Sundays in unix cron . Thanks and Regards, Srinivas __ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: kommareddy sreenivasa INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Rollback Segs
Well, the other option is to start developing apps and test them using larger data sets then available in EMP and DEPT tables. Even with full table scans, everything seems to work miraculously on those tables. On 2003.07.16 08:59, Lee Cullip wrote: I think that's probably the case with most third party applications, if developers haven't coded their apps to use a large rollback segment for certain transactions (which I find is the case with most developers ;-) ) then the only option is to turn off all but the large rollback seg. Cheers Lee -Original Message- Sent: 16 July 2003 11:19 To: Multiple recipients of list ORACLE-L Yes you are right, sorry but I made a mistake, since we are using Baan IVc4 which works against Oracle we have no means to interfere with its transactions when they are commited to Oracle and we can not modify them so that it uses a specific rollback segment, so the only way for us to do it is to disable all except the one we want it to use. -Mensaje original- De: Lee Cullip [mailto:[EMAIL PROTECTED] Enviado el: miércoles, 16 de julio de 2003 10:54 Para: Multiple recipients of list ORACLE-L Asunto: RE: Rollback Segs set transaction use rollback segment only works if it's the first statement in your transaction, an easy way to make sure this is the case is to issue a commit directly before issuing this statement. I believe this has been a feature of Oracle since way back in version 7 (Correct me if I'm wrong). Hope this helps. Cheers Lee -Original Message- Sent: 16 July 2003 09:09 To: Multiple recipients of list ORACLE-L Which database version are you using? as long as I know, at least on Oracle 8.0.6 you can not specify which rollback segment a particular transaction should use. We disable all rollback segments and only enable those which we know won't make big updates / deletes crash. -Mensaje original- De: venkat Rama [mailto:[EMAIL PROTECTED] Enviado el: miércoles, 16 de julio de 2003 6:34 Para: Multiple recipients of list ORACLE-L Asunto: Rollback Segs Hi Friends, I have 150Gb database with 30 rollback segs with optimal settings!! for normal operations no problems!! But we are doing massive updates for some of big tables!! So we are using vb programs and connecting to the database thru odbc dsn. My first question is how to set transaction use rollback segment rbs_big? I tried to set as first stmt, but its not using rbs_big segment, its using some other rollback segment. Is that good idea to make all my rollback segs maxextents unlimited to avoid maxextents reached error?? I have lot of rbs space nearly 10Gb. I saw one time, one of my rbs segment extented 2gb and failed transaction with maxextents reached with 5m initial and next, minextents 20 and optimal 100M. Any help will be appreciated Thanks venkat. _ Do you Yahoo!? SBC http://pa.yahoo.com/*http://rd.yahoo.com/evt=1207/*http://promo.yahoo.com/s bc/ Yahoo! DSL - Now only $29.95 per month! This e-mail message (including any attachment) is intended only for the personal use of the recipient(s) named above. This message is confidential and may be legally privileged. If you are not an intended recipient, you may not review, copy or distribute this message. If you have received this communication in error, please notify us immediately by e-mail and delete the original message. Any views or opinions expressed in this message are those of the author only. Furthermore, this message (including any attachment) does not create any legally binding rights or obligations whatsoever, which may only be created by the exchange of hard copy documents signed by a duly authorised representative of Hutchison 3G UK Limited. -- Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Oracle has out-smarted me again.
Yes, but that just re-installs the prior, 2.2.0.12.0, installer. The directions say to extract the zip to some file. How do you tell the install where some is? Paul Baumgartel treegarden To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] @yahoo.com cc: Sent by: Subject: Re: Oracle has out-smarted me again. ml-errors 07/15/2003 05:14 PM Please respond to ORACLE-L The products.jar file you need is in Disk1\install\stage. --- Thomas Day [EMAIL PROTECTED] wrote: Interim Patch: 2878462 DATE: May 7, 2003 Platform Patch for : Microsoft Windows NT Microsoft Windows 2000 Microsoft Windows XP Product Version # : 2.2.0.18.0 Product Patched: UNIVERSAL INSTALLER Patch Installation Instructions : ( this assumes that you have already unzipped the file you downloaded from metalink): 1. Extract the contents of the file oui220180_nt.jar into a newly created directory using C: jar -xvf oui220180_nt.jar or C: unzip oui220180_nt.jar or You can use the winzip graphical utility as well. 2. Change directory to Disk1\install\win32 as : cd Disk1\install\win32 1. Run setup.exe from Disk1\install\win32 directory as C: setup.exe:. This will launch the Install session for installing OUI 2.2.0.18.0 to the current Oracle environment. After the installation completes, you can verify that the OUI version is 2.2.0.18.0 by invoking Oracle Universal Installer from Windows Program Menu and clicking on the About Oracle Universal Installer button . * Having R'ed the old FM to a fare-thee-well, how is one supposed to make the above instructions work? Following them slavishly will re-install the current version of the OUI, since the products.jar hasn't changed. OUI doesn't recognize oui220180_nt.jar as a substitute for products.jar. Anyone who has had any success in installing OUI 2.2.0.18.0 on Win2K, could you share how that happened? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Thomas Day INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Paul Baumgartel INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list
Re: how to schedule a job every alternate sundays in unix cron
I'm not a Unix expert, but one thing you could do is schedule the script to run every Sunday, then within the script add some logic so that the script completes every other Sunday. For example, in ksh: # Check to see if this script ran last Sunday. if [[ -a ran_last_week.dat ]]; then rm ran_last_week.dat exit else # Create a file to signal that the script ran. touch ran_last_week.dat rest of script Jay [EMAIL PROTECTED] 07/16/03 09:09AM Hello All, OS: Solaris 2.8 I have to run a backup script in every alternate Sunday. I cant find a way to submit it in cron. Can somebody help me how to setup a job to run alternate Sundays in unix cron . Thanks and Regards, Srinivas __ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: kommareddy sreenivasa INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). **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.net -- Author: Jay Hostetter INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle Instances not starting up via services
Sorry Lee - it's a typo!! Thanks though for pointing it out to me. N. :--Original Message- :-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] :-Behalf Of :-Lee Cullip :-Sent: 16 July 2003 14:10 :-To: Multiple recipients of list ORACLE-L :-Subject: RE: Oracle Instances not starting up via services :- :- :-Hi, :-Reading your mail, your registry setting for ora_wms_pfile is set to :-c:\oracle\ora8\database\initwms.ora, but your oracle home is :-c:\oracle\ora81, not sure if this is just a typo, but it may :-help you. :- :-Cheers :-Lee :- :--Original Message- :-Sent: 16 July 2003 12:24 :-To: Multiple recipients of list ORACLE-L :- :- :- :-Hi All, :- :-I have inherited a couple of databases on one of the servers :-here. The :-server was taken down for hardware repairs during the week :-and when it came :-back up the databases did not start. (They are set to start :-automatically :-via the services) :- :-I have done some research via the internet and I deleted and :-recreated the :-service via the ORADIM utility. :- :-But this has n't fixed it. I have to manually go into and start the :-databases (explicitly stating where the init.ora file is) :- :-I am getting this error message when I go in via SQLPLUS :-/NOLOG (connected :-as internal) :- :-Startup :-error message LRM-00109 can not open parameter file :-'%oracle_home%/database/init%oracle_sid%.ora :- :-If I do a startup pfile=c:\oracle\ora81\database\initwms.ora :-it starts as :-normal. :- :-I've checked that the oracle home is defined as :-c:\oracle\ora81 so I am :-beginning to suspect it has something to do with the oracle sid. :-In registry the ora_wms_pfile location is set to :-c:\oracle\ora8\database\initwms.ora :- :-We have 4 different instances on this box and none of them will start :-automatically. :-Oracle version 8.1.7 running on a Windows Server 2000 box :- :-Any help appreciated, :- :-Thanks, :- :-N. :- :- :- :- :-_ :-___ :- :-This e-mail message (including any attachment) is intended :-only for the personal :-use of the recipient(s) named above. This message is :-confidential and may be :-legally privileged. If you are not an intended recipient, :-you may not review, copy or :-distribute this message. If you have received this :-communication in error, please notify :-us immediately by e-mail and delete the original message. :- :-Any views or opinions expressed in this message are those of :-the author only. :-Furthermore, this message (including any attachment) does :-not create any legally :-binding rights or obligations whatsoever, which may only be :-created by the exchange :-of hard copy documents signed by a duly authorised :-representative of Hutchison :-3G UK Limited. :-_ :-___ :- :--- :-Please see the official ORACLE-L FAQ: http://www.orafaq.net :--- :-Author: Lee Cullip :- INET: [EMAIL PROTECTED] :- :-Fat City Network Services-- 858-538-5051 http://www.fatcity.com :-San Diego, California-- Mailing list and web hosting services :-- :-To REMOVE yourself from this mailing list, send an E-Mail message :-to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in :-the message BODY, include a line containing: UNSUB ORACLE-L :-(or the name of mailing list you want to be removed from). You may :-also send the HELP command for other information (like subscribing). :- -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nuala Cullen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Insert 8000 Byte into LONG column
Hi dear list members, we run a database 8.1.6.2 I've run into a problem. I've got a table that contains a LONG column (I know, I know). I have to insert a string into it that has a length 8500 Byte. Whenever I issue the insert statement SQL/PLUS throws the error 'ORA-01704: string literal too long'. Does anyone have an idea how I can get the data into the table? Any help (except: change the datatype ;-)) is appreciated. Greetings, Guido -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Guido Konsolke INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: enterprise manager
Is it an 8.0.x or 8i database? What version of OEM are you running? We need more info to be able to help you. Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, July 16, 2003 6:19 AM hi i run ora8 on w2000 server. my problem is i can ping my database mydb without problems i can login with sqlplus as sys and it works fine but if i start the enterprise manager console and try to login as sys a error occours and means please check the management server status and settings. as managementserver i select mydb. what ican be the problem? thx martin -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: pfeffer INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Oracle Instances not starting up via services
Check the registry entry ORA_SID_PFILE. Try hardcoding the entire path rather than use variables. ie. ORA_WMS_PFILE would be set to c:\oracle\ora81\database\initwms.ora. Be sure ORA_WMS_AUTOSTART is set to TRUE. Jared On Wednesday 16 July 2003 04:24, Nuala Cullen wrote: Hi All, I have inherited a couple of databases on one of the servers here. The server was taken down for hardware repairs during the week and when it came back up the databases did not start. (They are set to start automatically via the services) I have done some research via the internet and I deleted and recreated the service via the ORADIM utility. But this has n't fixed it. I have to manually go into and start the databases (explicitly stating where the init.ora file is) I am getting this error message when I go in via SQLPLUS /NOLOG (connected as internal) Startup error message LRM-00109 can not open parameter file '%oracle_home%/database/init%oracle_sid%.ora If I do a startup pfile=c:\oracle\ora81\database\initwms.ora it starts as normal. I've checked that the oracle home is defined as c:\oracle\ora81 so I am beginning to suspect it has something to do with the oracle sid. In registry the ora_wms_pfile location is set to c:\oracle\ora8\database\initwms.ora We have 4 different instances on this box and none of them will start automatically. Oracle version 8.1.7 running on a Windows Server 2000 box Any help appreciated, Thanks, N. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: inline views
In one case, the statement's execution plan used a nested loop, where it read the local table then probed the index on the remote table. This caused several million trips across the network to retrieve less than 10,000 records (IIRC). select local.cola, local.colb, remote.colc, remote.cold from local, remote where local.cola = remote.cola; We rewrote the query to retrieve all of the data from the remote table then the nested loops was much more efficient. select local.cola, local.colb, remote_i.colc, remote_i.cold from local (select remote.cola, remote.colc, remote.cold from remote) remote_i where local.cola = remote_i.cola; VIVEK_SHARMA wrote: Daniel, List Can you give more detail with an EXAMPLE please ? Thanks -Original Message- Sent: Friday, June 06, 2003 7:05 PM To: Multiple recipients of list ORACLE-L I have used an inline view to reduce network traffic when retrieiving data from a remote db. Instead of using a nested loop and making multiple trips, it made 1 trip and brought over all of the data. The query time was reduced from 30 minutes to 5 minutes. -- Daniel W. Fink http://www.optimaldba.com VIVEK_SHARMA wrote: Where are they advantageous to use where not ? Thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: VIVEK_SHARMA INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).begin:vcard n:Fink;Daniel tel;cell:303.808.3282 tel;work:303.272.3225 x-mozilla-html:TRUE adr:;; version:2.1 email;internet:[EMAIL PROTECTED] title:DB Services Lead x-mozilla-cpt:;-4832 fn:Daniel Fink end:vcard
Re: enterprise manager
Check: drive:\ORACLE_HOME\sysman\log review the oms.log file... and send the details... HTH JL --- Ruth Gramolini [EMAIL PROTECTED] wrote: Is it an 8.0.x or 8i database? What version of OEM are you running? We need more info to be able to help you. Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, July 16, 2003 6:19 AM hi i run ora8 on w2000 server. my problem is i can ping my database mydb without problems i can login with sqlplus as sys and it works fine but if i start the enterprise manager console and try to login as sys a error occours and means please check the management server status and settings. as managementserver i select mydb. what ican be the problem? thx martin -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: pfeffer INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jose Luis Delgado INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Oracle has out-smarted me again.
It's been a month or two since I did this, but I did verify that the version was ...18.0, and I could swear that was the jar file I used. I'm going to install it on another machine and note my steps, then I'll post another reply. --- Thomas Day [EMAIL PROTECTED] wrote: Yes, but that just re-installs the prior, 2.2.0.12.0, installer. The directions say to extract the zip to some file. How do you tell the install where some is? Paul Baumgartel treegarden To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] @yahoo.com cc: Sent by: Subject: Re: Oracle has out-smarted me again. ml-errors 07/15/2003 05:14 PM Please respond to ORACLE-L The products.jar file you need is in Disk1\install\stage. --- Thomas Day [EMAIL PROTECTED] wrote: Interim Patch: 2878462 DATE: May 7, 2003 Platform Patch for : Microsoft Windows NT Microsoft Windows 2000 Microsoft Windows XP Product Version # : 2.2.0.18.0 Product Patched: UNIVERSAL INSTALLER Patch Installation Instructions : ( this assumes that you have already unzipped the file you downloaded from metalink): 1. Extract the contents of the file oui220180_nt.jar into a newly created directory using C: jar -xvf oui220180_nt.jar or C: unzip oui220180_nt.jar or You can use the winzip graphical utility as well. 2. Change directory to Disk1\install\win32 as : cd Disk1\install\win32 1. Run setup.exe from Disk1\install\win32 directory as C: setup.exe:. This will launch the Install session for installing OUI 2.2.0.18.0 to the current Oracle environment. After the installation completes, you can verify that the OUI version is 2.2.0.18.0 by invoking Oracle Universal Installer from Windows Program Menu and clicking on the About Oracle Universal Installer button . * Having R'ed the old FM to a fare-thee-well, how is one supposed to make the above instructions work? Following them slavishly will re-install the current version of the OUI, since the products.jar hasn't changed. OUI doesn't recognize oui220180_nt.jar as a substitute for products.jar. Anyone who has had any success in installing OUI 2.2.0.18.0 on Win2K, could you share how that happened? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Thomas Day INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other
Rauch report: Oracle vs DB2
Any Oracle/DB2 dual DBAs out there that can comment on the Rauch report (no doubt financed by Oracle Corp)? http://www.oracle.com/ip/deploy/database/theme_pages/index.html?ma_04252003. html Not that I'm particularly impressed on the ease of generating stats in Oracle vs. DB2, but I'm just curious how the DB2 side applies to real-world. I haven't used most of the Oracle GUI stuff as reported. Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
* Sr. Oracle DBA with 8i and 9i experience needed..
Minneapolis, Minnesota company has a great opportunity available for a Sr. level Oracle DBA to join their IT staff. The selected candidate must be highly skilled in solving extremely complex and very critical customer issues. With preferably over 10 years experience in a large-scale multi-network open-systems environment, the candidate anticipates and plans for reliability, availability, and serviceability in the design, development and implementation of Oracle 8i and 9i solutions. The candidate will be recognized as a technical authority in the design, analysis, implementation and integration of large-scale database management systems. Candidates local to the Minneapolis area are preferred, but any candidate who meets the qualifications for the position will be considered. Base Salary is in the 85-100K range plus bonus. PLEASE Do Not send your resume for this position UNLESS you have the skills outlined below for this position. Please Do Not send your resume unless you have a stable work history. Candidates whose work history includes frequent job changes connot be considered. This is a full time staff position so no sub-contractors or third parties please. NO H-1B candidates please. *MUST meet these requirements: -BS degree in CS or related field. -8-10 years experience in a large-scale multi-network open-systems environment. -Very solid Oracle DBA experience..including 8i and 9i. -Proficient at capacity monitoring and management capabilities, preferably an expert knowledge of Enterprise Manager 9i (OEM), and STATSPACK. -Experience performing Oracle installations, upgrades, and supporting Oracle utilities and services in a variety of operating systems (Solaris, NT, Linux) is required. -Migration and upgrade experience is essential. -Expert knowledge of on-line back-up/recovery procedures with snapshotting a plus. -Proficiency with RMAN is essential. -Ability to work with engineering staff to configure SAN storage for optimal Oracle performance. -Expert knowledge of UNIX scripting including CRON Jobs, Oracle Stored Procedures, Triggers, Packages, Real Application Clusters (RAC). -Performance Tuning and Performance management skills are required, SQL*Plus, PL/SQL, SQL*Loader, SQL, and UNIX. -The applicant must have in-depth experience with ER diagramming, data modeling tools, (erWIN preferred) normalization, de-normalization, database programming and design, query optimization, index optimization, use of hints. Optimal setup of dblink, views, and use of Oracle gateway is required. Must understand how to design and tune an Oracle database to optimize performance for potentially thousands of concurrent, browser-based users together with ETL processes. -Excellent written and verbal communications skills with the ability to effectively communicate technical and business problems/issues in a non-technical manner, strong problem resolution, analysis, and customer service skills are required. -Ability to manage multiple tasks with shifting priorities is a necessity. -Ability to work within a team environment and communicate effectively with other team members is required. -Proven mentoring skills to build the strength of the DBA staff. For immediate consideration, please email your resume as an attachment to: OraStaff, Inc. Email: [EMAIL PROTECTED] Please Use Job Code: Minn./DBA/MH Phone: 1-800-549-8502. I pay referral fees. So please contact me if you know of anyone who would be qualified/interested in the position described above- if it is not a match for your skills. Thanks. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: OraStaff INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RMAN SQL Backtrack
Title: Message We have been using SQL Backtrack for backup and recovery forabout 6 years now. We are being pressured to start using RMAN because it is free. Makes sense but I am wondering about reliability, complexity, learning curve, etc... Has anyone had experience with both products or anyone new to RMAN that can give me an idea of what to expect? Thanks! Ron If you are not the intended recipient of this e-mail message, any use, distribution or copying of the message is prohibited. Please let me know immediately by return e-mail if you have received this message by mistake, then delete the e-mail message. Thank you.
Re: MicroSlop DTC
You can also supply a filename to the dump_tnsnames command. ie. dump_tnsnames /tmp/tnsnames.tmp Jared On Tuesday 15 July 2003 11:14, John Kanagaraj wrote: Jesse, You could always get around this problem by obtaining an upto date TNSNAMES.ORA on any Names-aware client using the 'namesctl dump_tnsnames' command that will create/update the tnsnames.ora with the entries from Names servers. I would suggest renaming the original tnsnames.ora _just_ before doing this, and having some script check the sizes of the created file (just in case). John Kanagaraj Oracle Applications DBA DBSoft Inc (W): 408-970-7002 What would you see if you were allowed to look back at your life at the end of your journey in this earth? ** The opinions and statements above are entirely my own and not those of my employer or clients ** -Original Message- From: Jesse, Rich [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 15, 2003 9:25 AM To: Multiple recipients of list ORACLE-L Subject: RE: MicroSlop DTC Unfortunately, it's not just a problem with this product. Some Oracle products like OEM can incorrectly populate TNSNAMES.ORA for you because of course that's always the best thing to do (and isn't there another Oracle product that requires it or am I confusing that with the semi-Intelligent Agent's requirement of a LISTENER.ORA?). And Quest's QCO will largely not work correctly in v2.4 (and to some extent in 2.5) without a correctly populated TNSNAMES.ORA (sorry Jacques!). I went around and around with Quest Support as to why this is incorrect and why I refuse to manually populate a TNSNAMES.ORA on some or all clients. Supposedly, it'll be fixed in v3. Desperately trying to get rid of all TNSNAMES.ORAs on all non-DBA boxes... Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA -Original Message- From: Goulet, Dick [mailto:[EMAIL PROTECTED] Sent: Monday, July 14, 2003 2:15 PM To: Multiple recipients of list ORACLE-L Subject: RE: MicroSlop DTC Yes, as well as SQL*Plus and ODBCTST. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Monday, July 14, 2003 2:59 PM To: Multiple recipients of list ORACLE-L Hum, does tnsping resolve the service correctly? Ron Thomas 9.2.0.1.0 On Win 2K. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Monday, July 14, 2003 1:54 PM To: Multiple recipients of list ORACLE-L I've seen this happen with older versions of the sqlnet client (Different application, same symptom). What version of the client are you using? Ron Thomas Hypercom, Inc [EMAIL PROTECTED] Each new user of a new system uncovers a new class of bugs. -- Kernighan [EMAIL PROTECTED] To All, especially any WEB developers out there. We've a WEB based application that uses MS DTC. OK, so we turned on XA in the database, but the web servers do not want to play with our normal ONmase setup. Instead they only want to work with a TNSNAMES.ORA file in the appriopriate place. I've been all over MicroSlop Technet and Metalink as well as several other IIS sites with no results. Therefore anyone know why this is?? Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: * Sr. Oracle DBA with 8i and 9i experience needed..
Jared, can we get orastaff banned from the list? I know people need jobs but Orastaff is a notorious spammer. I get spammed from these guys through my home email. From: OraStaff [EMAIL PROTECTED] Date: 2003/07/16 Wed AM 10:54:27 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: * Sr. Oracle DBA with 8i and 9i experience needed.. Minneapolis, Minnesota company has a great opportunity available for a Sr. level Oracle DBA to join their IT staff. The selected candidate must be highly skilled in solving extremely complex and very critical customer issues. With preferably over 10 years experience in a large-scale multi-network open-systems environment, the candidate anticipates and plans for reliability, availability, and serviceability in the design, development and implementation of Oracle 8i and 9i solutions. The candidate will be recognized as a technical authority in the design, analysis, implementation and integration of large-scale database management systems. Candidates local to the Minneapolis area are preferred, but any candidate who meets the qualifications for the position will be considered. Base Salary is in the 85-100K range plus bonus. PLEASE Do Not send your resume for this position UNLESS you have the skills outlined below for this position. Please Do Not send your resume unless you have a stable work history. Candidates whose work history includes frequent job changes connot be considered. This is a full time staff position so no sub-contractors or third parties please. NO H-1B candidates please. *MUST meet these requirements: -BS degree in CS or related field. -8-10 years experience in a large-scale multi-network open-systems environment. -Very solid Oracle DBA experience..including 8i and 9i. -Proficient at capacity monitoring and management capabilities, preferably an expert knowledge of Enterprise Manager 9i (OEM), and STATSPACK. -Experience performing Oracle installations, upgrades, and supporting Oracle utilities and services in a variety of operating systems (Solaris, NT, Linux) is required. -Migration and upgrade experience is essential. -Expert knowledge of on-line back-up/recovery procedures with snapshotting a plus. -Proficiency with RMAN is essential. -Ability to work with engineering staff to configure SAN storage for optimal Oracle performance. -Expert knowledge of UNIX scripting including CRON Jobs, Oracle Stored Procedures, Triggers, Packages, Real Application Clusters (RAC). -Performance Tuning and Performance management skills are required, SQL*Plus, PL/SQL, SQL*Loader, SQL, and UNIX. -The applicant must have in-depth experience with ER diagramming, data modeling tools, (erWIN preferred) normalization, de-normalization, database programming and design, query optimization, index optimization, use of hints. Optimal setup of dblink, views, and use of Oracle gateway is required. Must understand how to design and tune an Oracle database to optimize performance for potentially thousands of concurrent, browser-based users together with ETL processes. -Excellent written and verbal communications skills with the ability to effectively communicate technical and business problems/issues in a non-technical manner, strong problem resolution, analysis, and customer service skills are required. -Ability to manage multiple tasks with shifting priorities is a necessity. -Ability to work within a team environment and communicate effectively with other team members is required. -Proven mentoring skills to build the strength of the DBA staff. For immediate consideration, please email your resume as an attachment to: OraStaff, Inc. Email: [EMAIL PROTECTED] Please Use Job Code: Minn./DBA/MH Phone: 1-800-549-8502. I pay referral fees. So please contact me if you know of anyone who would be qualified/interested in the position described above- if it is not a match for your skills. Thanks. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: OraStaff INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services
Re: Insert 8000 Byte into LONG column
Try using sql*loader. Put the input data string in a single file as the input file. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, July 16, 2003 9:54 AM Hi dear list members, we run a database 8.1.6.2 I've run into a problem. I've got a table that contains a LONG column (I know, I know). I have to insert a string into it that has a length 8500 Byte. Whenever I issue the insert statement SQL/PLUS throws the error 'ORA-01704: string literal too long'. Does anyone have an idea how I can get the data into the table? Any help (except: change the datatype ;-)) is appreciated. Greetings, Guido -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Guido Konsolke INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Arup Nanda INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: RMAN SQL Backtrack
Title: Message Ron: I don't know SQL Backtrack, but two things popped into my head as I read your message. One,RMAN does not have a media interface layer. It depends on a utility such as Legato (also currently included with Oracle) or Netbackup or OmniBack. Two,EMC just bought Legato. This tool may not be included in futurereleases. Cheers, Mike -Original Message-From: Smith, Ron L. [mailto:[EMAIL PROTECTED]Sent: Wednesday, July 16, 2003 7:59 AMTo: Multiple recipients of list ORACLE-LSubject: RMAN SQL Backtrack We have been using SQL Backtrack for backup and recovery forabout 6 years now. We are being pressured to start using RMAN because it is free. Makes sense but I am wondering about reliability, complexity, learning curve, etc... Has anyone had experience with both products or anyone new to RMAN that can give me an idea of what to expect? Thanks!
RE: RMAN SQL Backtrack
Title: Message HI, We are a backtrack shop also and we are happy with it. We have not yet pressure to go to rman. If you switch to rman, I'm interested in knowing the migration effort. Stephane Paquette Administrateur de bases de donnees Database Administrator Standard Life www.standardlife.ca Tel. (514) 499-7999 7470 and (514) 925-7187 [EMAIL PROTECTED] -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Smith, Ron L.Sent: Wednesday, July 16, 2003 10:59 AMTo: Multiple recipients of list ORACLE-LSubject: RMAN SQL Backtrack We have been using SQL Backtrack for backup and recovery forabout 6 years now. We are being pressured to start using RMAN because it is free. Makes sense but I am wondering about reliability, complexity, learning curve, etc... Has anyone had experience with both products or anyone new to RMAN that can give me an idea of what to expect? Thanks! Ron If you are not the intended recipient of this e-mail message, any use, distribution or copying of the message is prohibited. Please let me know immediately by return e-mail if you have received this message by mistake, then delete the e-mail message. Thank you.
RE: Rauch report: Oracle vs DB2
If you go on DB2 site, http://www-3.ibm.com/software/data/pubs/pdfs/dhbrown.pdf , you'll find a similar document that concludes that TCO of DB2 is below Oracle's one. Stephane Paquette Administrateur de bases de donnees Database Administrator Standard Life www.standardlife.ca Tel. (514) 499-7999 7470 and (514) 925-7187 [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -Original Message- Jesse, Rich Sent: Wednesday, July 16, 2003 10:50 AM To: Multiple recipients of list ORACLE-L Any Oracle/DB2 dual DBAs out there that can comment on the Rauch report (no doubt financed by Oracle Corp)? http://www.oracle.com/ip/deploy/database/theme_pages/index.html?ma_04252003. html Not that I'm particularly impressed on the ease of generating stats in Oracle vs. DB2, but I'm just curious how the DB2 side applies to real-world. I haven't used most of the Oracle GUI stuff as reported. Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Paquette INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Antw: Re: Insert 8000 Byte into LONG column
Thanks for the answer, but this no way for me. Ain't got sqlldr on my client pc and no telnet to the server 8-(( [EMAIL PROTECTED] 16.07.2003 16.59 Uhr Try using sql*loader. Put the input data string in a single file as the input file. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, July 16, 2003 9:54 AM Hi dear list members, we run a database 8.1.6.2 I've run into a problem. I've got a table that contains a LONG column (I know, I know). I have to insert a string into it that has a length 8500 Byte. Whenever I issue the insert statement SQL/PLUS throws the error 'ORA-01704: string literal too long'. Does anyone have an idea how I can get the data into the table? Any help (except: change the datatype ;-)) is appreciated. Greetings, Guido -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Guido Konsolke INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Arup Nanda INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Guido Konsolke INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Rauch report: Oracle vs DB2
Having seen the report previously I can say that IMHO it's an apples vs. oranges report. Given an experienced DBA on both systems I still believe that can do the same basic task in a similar amount of time effort. Why, because they 1) understand the process for their RDBMS, and 2) they've scripted it all out in the first place. Now if your talking about an in-experienced person using the GUI's, well maybe Oracle is easier. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Wednesday, July 16, 2003 10:50 AM To: Multiple recipients of list ORACLE-L Any Oracle/DB2 dual DBAs out there that can comment on the Rauch report (no doubt financed by Oracle Corp)? http://www.oracle.com/ip/deploy/database/theme_pages/index.html?ma_04252003. html Not that I'm particularly impressed on the ease of generating stats in Oracle vs. DB2, but I'm just curious how the DB2 side applies to real-world. I haven't used most of the Oracle GUI stuff as reported. Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Goulet, Dick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: * Sr. Oracle DBA with 8i and 9i experience needed..
Some of us like seeing the possibilities. The delete key is just to the right of the backslash. Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, July 16, 2003 11:04 AM Jared, can we get orastaff banned from the list? I know people need jobs but Orastaff is a notorious spammer. I get spammed from these guys through my home email. From: OraStaff [EMAIL PROTECTED] Date: 2003/07/16 Wed AM 10:54:27 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: * Sr. Oracle DBA with 8i and 9i experience needed.. Minneapolis, Minnesota company has a great opportunity available for a Sr. level Oracle DBA to join their IT staff. The selected candidate must be highly skilled in solving extremely complex and very critical customer issues. With preferably over 10 years experience in a large-scale multi-network open-systems environment, the candidate anticipates and plans for reliability, availability, and serviceability in the design, development and implementation of Oracle 8i and 9i solutions. The candidate will be recognized as a technical authority in the design, analysis, implementation and integration of large-scale database management systems. Candidates local to the Minneapolis area are preferred, but any candidate who meets the qualifications for the position will be considered. Base Salary is in the 85-100K range plus bonus. PLEASE Do Not send your resume for this position UNLESS you have the skills outlined below for this position. Please Do Not send your resume unless you have a stable work history. Candidates whose work history includes frequent job changes connot be considered. This is a full time staff position so no sub-contractors or third parties please. NO H-1B candidates please. *MUST meet these requirements: -BS degree in CS or related field. -8-10 years experience in a large-scale multi-network open-systems environment. -Very solid Oracle DBA experience..including 8i and 9i. -Proficient at capacity monitoring and management capabilities, preferably an expert knowledge of Enterprise Manager 9i (OEM), and STATSPACK. -Experience performing Oracle installations, upgrades, and supporting Oracle utilities and services in a variety of operating systems (Solaris, NT, Linux) is required. -Migration and upgrade experience is essential. -Expert knowledge of on-line back-up/recovery procedures with snapshotting a plus. -Proficiency with RMAN is essential. -Ability to work with engineering staff to configure SAN storage for optimal Oracle performance. -Expert knowledge of UNIX scripting including CRON Jobs, Oracle Stored Procedures, Triggers, Packages, Real Application Clusters (RAC). -Performance Tuning and Performance management skills are required, SQL*Plus, PL/SQL, SQL*Loader, SQL, and UNIX. -The applicant must have in-depth experience with ER diagramming, data modeling tools, (erWIN preferred) normalization, de-normalization, database programming and design, query optimization, index optimization, use of hints. Optimal setup of dblink, views, and use of Oracle gateway is required. Must understand how to design and tune an Oracle database to optimize performance for potentially thousands of concurrent, browser-based users together with ETL processes. -Excellent written and verbal communications skills with the ability to effectively communicate technical and business problems/issues in a non-technical manner, strong problem resolution, analysis, and customer service skills are required. -Ability to manage multiple tasks with shifting priorities is a necessity. -Ability to work within a team environment and communicate effectively with other team members is required. -Proven mentoring skills to build the strength of the DBA staff. For immediate consideration, please email your resume as an attachment to: OraStaff, Inc. Email: [EMAIL PROTECTED] Please Use Job Code: Minn./DBA/MH Phone: 1-800-549-8502. I pay referral fees. So please contact me if you know of anyone who would be qualified/interested in the position described above- if it is not a match for your skills. Thanks. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: OraStaff INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED]
RE: * Sr. Oracle DBA with 8i and 9i experience needed..
and they had NO H-1B candidates please. What a discrimination... -Original Message- Sent: Wednesday, July 16, 2003 4:04 PM To: Multiple recipients of list ORACLE-L Jared, can we get orastaff banned from the list? I know people need jobs but Orastaff is a notorious spammer. I get spammed from these guys through my home email. From: OraStaff [EMAIL PROTECTED] Date: 2003/07/16 Wed AM 10:54:27 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: * Sr. Oracle DBA with 8i and 9i experience needed.. Minneapolis, Minnesota company has a great opportunity available for a Sr. level Oracle DBA to join their IT staff. The selected candidate must be highly skilled in solving extremely complex and very critical customer issues. With preferably over 10 years experience in a large-scale multi-network open-systems environment, the candidate anticipates and plans for reliability, availability, and serviceability in the design, development and implementation of Oracle 8i and 9i solutions. The candidate will be recognized as a technical authority in the design, analysis, implementation and integration of large-scale database management systems. Candidates local to the Minneapolis area are preferred, but any candidate who meets the qualifications for the position will be considered. Base Salary is in the 85-100K range plus bonus. PLEASE Do Not send your resume for this position UNLESS you have the skills outlined below for this position. Please Do Not send your resume unless you have a stable work history. Candidates whose work history includes frequent job changes connot be considered. This is a full time staff position so no sub-contractors or third parties please. NO H-1B candidates please. *MUST meet these requirements: -BS degree in CS or related field. -8-10 years experience in a large-scale multi-network open-systems environment. -Very solid Oracle DBA experience..including 8i and 9i. -Proficient at capacity monitoring and management capabilities, preferably an expert knowledge of Enterprise Manager 9i (OEM), and STATSPACK. -Experience performing Oracle installations, upgrades, and supporting Oracle utilities and services in a variety of operating systems (Solaris, NT, Linux) is required. -Migration and upgrade experience is essential. -Expert knowledge of on-line back-up/recovery procedures with snapshotting a plus. -Proficiency with RMAN is essential. -Ability to work with engineering staff to configure SAN storage for optimal Oracle performance. -Expert knowledge of UNIX scripting including CRON Jobs, Oracle Stored Procedures, Triggers, Packages, Real Application Clusters (RAC). -Performance Tuning and Performance management skills are required, SQL*Plus, PL/SQL, SQL*Loader, SQL, and UNIX. -The applicant must have in-depth experience with ER diagramming, data modeling tools, (erWIN preferred) normalization, de-normalization, database programming and design, query optimization, index optimization, use of hints. Optimal setup of dblink, views, and use of Oracle gateway is required. Must understand how to design and tune an Oracle database to optimize performance for potentially thousands of concurrent, browser-based users together with ETL processes. -Excellent written and verbal communications skills with the ability to effectively communicate technical and business problems/issues in a non-technical manner, strong problem resolution, analysis, and customer service skills are required. -Ability to manage multiple tasks with shifting priorities is a necessity. -Ability to work within a team environment and communicate effectively with other team members is required. -Proven mentoring skills to build the strength of the DBA staff. For immediate consideration, please email your resume as an attachment to: OraStaff, Inc. Email: [EMAIL PROTECTED] Please Use Job Code: Minn./DBA/MH Phone: 1-800-549-8502. I pay referral fees. So please contact me if you know of anyone who would be qualified/interested in the position described above- if it is not a match for your skills. Thanks. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: OraStaff INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET:
Re: * Sr. Oracle DBA with 8i and 9i experience needed..
That, or use Block Sender. My $0.02 worth, Ken Janusz, CPIM - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, July 16, 2003 10:14 AM Some of us like seeing the possibilities. The delete key is just to the right of the backslash. Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, July 16, 2003 11:04 AM Jared, can we get orastaff banned from the list? I know people need jobs but Orastaff is a notorious spammer. I get spammed from these guys through my home email. From: OraStaff [EMAIL PROTECTED] Date: 2003/07/16 Wed AM 10:54:27 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: * Sr. Oracle DBA with 8i and 9i experience needed.. Minneapolis, Minnesota company has a great opportunity available for a Sr. level Oracle DBA to join their IT staff. The selected candidate must be highly skilled in solving extremely complex and very critical customer issues. With preferably over 10 years experience in a large-scale multi-network open-systems environment, the candidate anticipates and plans for reliability, availability, and serviceability in the design, development and implementation of Oracle 8i and 9i solutions. The candidate will be recognized as a technical authority in the design, analysis, implementation and integration of large-scale database management systems. Candidates local to the Minneapolis area are preferred, but any candidate who meets the qualifications for the position will be considered. Base Salary is in the 85-100K range plus bonus. PLEASE Do Not send your resume for this position UNLESS you have the skills outlined below for this position. Please Do Not send your resume unless you have a stable work history. Candidates whose work history includes frequent job changes connot be considered. This is a full time staff position so no sub-contractors or third parties please. NO H-1B candidates please. *MUST meet these requirements: -BS degree in CS or related field. -8-10 years experience in a large-scale multi-network open-systems environment. -Very solid Oracle DBA experience..including 8i and 9i. -Proficient at capacity monitoring and management capabilities, preferably an expert knowledge of Enterprise Manager 9i (OEM), and STATSPACK. -Experience performing Oracle installations, upgrades, and supporting Oracle utilities and services in a variety of operating systems (Solaris, NT, Linux) is required. -Migration and upgrade experience is essential. -Expert knowledge of on-line back-up/recovery procedures with snapshotting a plus. -Proficiency with RMAN is essential. -Ability to work with engineering staff to configure SAN storage for optimal Oracle performance. -Expert knowledge of UNIX scripting including CRON Jobs, Oracle Stored Procedures, Triggers, Packages, Real Application Clusters (RAC). -Performance Tuning and Performance management skills are required, SQL*Plus, PL/SQL, SQL*Loader, SQL, and UNIX. -The applicant must have in-depth experience with ER diagramming, data modeling tools, (erWIN preferred) normalization, de-normalization, database programming and design, query optimization, index optimization, use of hints. Optimal setup of dblink, views, and use of Oracle gateway is required. Must understand how to design and tune an Oracle database to optimize performance for potentially thousands of concurrent, browser-based users together with ETL processes. -Excellent written and verbal communications skills with the ability to effectively communicate technical and business problems/issues in a non-technical manner, strong problem resolution, analysis, and customer service skills are required. -Ability to manage multiple tasks with shifting priorities is a necessity. -Ability to work within a team environment and communicate effectively with other team members is required. -Proven mentoring skills to build the strength of the DBA staff. For immediate consideration, please email your resume as an attachment to: OraStaff, Inc. Email: [EMAIL PROTECTED] Please Use Job Code: Minn./DBA/MH Phone: 1-800-549-8502. I pay referral fees. So please contact me if you know of anyone who would be qualified/interested in the position described above- if it is not a match for your skills. Thanks. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: OraStaff INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT
RE: Oracle Instances not starting up via services
Hi Jared, Thanks for the advice, I checked out the registry settings ORA_WMS_PFILE is set to c:\oracle\ora81\database\initwms.ora. ORA_WMS_AUTOSTART is set to TRUE. I'm a bit confused what you mean by using variables. I think you mean not to use %oracle_home% etc but the error message: LRM-00109 can not open parameter file '%oracle_home%/database/init%oracle_sid%.ora is as it appeared on the screen. N. :--Original Message- :-From: Jared Still [mailto:[EMAIL PROTECTED] :-Sent: 16 July 2003 14:31 :-To: [EMAIL PROTECTED]; Nuala Cullen :-Subject: Re: Oracle Instances not starting up via services :- :- :- :-Check the registry entry ORA_SID_PFILE. Try hardcoding :-the entire path rather than use variables. :- :-ie. ORA_WMS_PFILE would be set to :-c:\oracle\ora81\database\initwms.ora. :- :-Be sure ORA_WMS_AUTOSTART is set to TRUE. :- :-Jared :- :- :-On Wednesday 16 July 2003 04:24, Nuala Cullen wrote: :- Hi All, :- :- I have inherited a couple of databases on one of the :-servers here. The :- server was taken down for hardware repairs during the week :-and when it came :- back up the databases did not start. (They are set to :-start automatically :- via the services) :- :- I have done some research via the internet and I deleted :-and recreated the :- service via the ORADIM utility. :- :- But this has n't fixed it. I have to manually go into and start the :- databases (explicitly stating where the init.ora file is) :- :- I am getting this error message when I go in via SQLPLUS :-/NOLOG (connected :- as internal) :- :- Startup :- error message LRM-00109 can not open parameter file :- '%oracle_home%/database/init%oracle_sid%.ora :- :- If I do a startup :-pfile=c:\oracle\ora81\database\initwms.ora it starts as :- normal. :- :- I've checked that the oracle home is defined as :-c:\oracle\ora81 so I am :- beginning to suspect it has something to do with the oracle sid. :- In registry the ora_wms_pfile location is set to :- c:\oracle\ora8\database\initwms.ora :- :- We have 4 different instances on this box and none of them :-will start :- automatically. :- Oracle version 8.1.7 running on a Windows Server 2000 box :- :- Any help appreciated, :- :- Thanks, :- :- N. :- :- -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nuala Cullen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Insert 8000 Byte into LONG column
Guido, Can you use utl_file for this within a PL/SQL block? Tom Mercadante Oracle Certified Professional -Original Message- [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 16, 2003 9:54 AM To: Multiple recipients of list ORACLE-L Hi dear list members, we run a database 8.1.6.2 I've run into a problem. I've got a table that contains a LONG column (I know, I know). I have to insert a string into it that has a length 8500 Byte. Whenever I issue the insert statement SQL/PLUS throws the error 'ORA-01704: string literal too long'. Does anyone have an idea how I can get the data into the table? Any help (except: change the datatype ;-)) is appreciated. Greetings, Guido -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Guido Konsolke INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: security without using different usernames
Hi
You can get the ip address as follows:
oracle:jupiter sqlplus system/[EMAIL PROTECTED]
SQL*Plus: Release 9.0.1.0.0 - Production on Wed Jun 25 20:45:54 2003
(c) Copyright 2001 Oracle Corporation. All rights reserved.
Connected to:
Oracle9i Enterprise Edition Release 9.0.1.0.0 - Production
With the Partitioning option
JServer Release 9.0.1.0.0 - Production
SQL select sys_context('userenv','ip_address') ip,username,machine
2 from v$session
3 where sys_context('userenv','sessionid')=audsid;
IP
USERNAME
--
MACHINE
172.16.240.11
SYSTEM
jupiter
SQL
you need to provide the service name when you log on otherwise the ip
address is not available using sys_context.
Also new with 9i as part of application contexts you can use the using
clause of create role that a pl/sql package can be used to verify the
user, for example something like this, typed in from memory so check the
syntax!:
create role some_role identified using sys.confirm_user;
create or replace procedure confirm_user
authid current user is
lv_ipaddress varchar2(30);
begin
select sys_context('userenv','ip_address')
into lv_ipaddress
from sys.dual;
if lv_ipaddress='172.16.140.1' then
dbms_session.set_role('some_role');
end if;
end;
/
hth
kind regards
Pete
--
Pete Finnigan
email:[EMAIL PROTECTED]
Web site: http://www.petefinnigan.com - Oracle security audit specialists
Book:Oracle security step-by-step Guide - see http://store.sans.org for details.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Pete Finnigan
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
RE: * Sr. Oracle DBA with 8i and 9i experience needed..
Title: RE: * Sr. Oracle DBA with 8i and 9i experience needed.. depends on the keyboard... I have one where it is right next to the enter key and backslash is next to the back space key. April Wells Oracle DBA/Oracle Apps DBA Corporate Systems Amarillo Texas You will recognize your own path when you come upon it, because you will suddenly have all the energy and imagination you will ever need. ~ Jerry Gillies ~ -Original Message- From: Ruth Gramolini [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 16, 2003 10:15 AM To: Multiple recipients of list ORACLE-L Subject: Re: * Sr. Oracle DBA with 8i and 9i experience needed.. Some of us like seeing the possibilities. The delete key is just to the right of the backslash. Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, July 16, 2003 11:04 AM Jared, can we get orastaff banned from the list? I know people need jobs but Orastaff is a notorious spammer. I get spammed from these guys through my home email. From: OraStaff [EMAIL PROTECTED] Date: 2003/07/16 Wed AM 10:54:27 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: * Sr. Oracle DBA with 8i and 9i experience needed.. Minneapolis, Minnesota company has a great opportunity available for a Sr. level Oracle DBA to join their IT staff. The selected candidate must be highly skilled in solving extremely complex and very critical customer issues. With preferably over 10 years experience in a large-scale multi-network open-systems environment, the candidate anticipates and plans for reliability, availability, and serviceability in the design, development and implementation of Oracle 8i and 9i solutions. The candidate will be recognized as a technical authority in the design, analysis, implementation and integration of large-scale database management systems. Candidates local to the Minneapolis area are preferred, but any candidate who meets the qualifications for the position will be considered. Base Salary is in the 85-100K range plus bonus. PLEASE Do Not send your resume for this position UNLESS you have the skills outlined below for this position. Please Do Not send your resume unless you have a stable work history. Candidates whose work history includes frequent job changes connot be considered. This is a full time staff position so no sub-contractors or third parties please. NO H-1B candidates please. *MUST meet these requirements: -BS degree in CS or related field. -8-10 years experience in a large-scale multi-network open-systems environment. -Very solid Oracle DBA experience..including 8i and 9i. -Proficient at capacity monitoring and management capabilities, preferably an expert knowledge of Enterprise Manager 9i (OEM), and STATSPACK. -Experience performing Oracle installations, upgrades, and supporting Oracle utilities and services in a variety of operating systems (Solaris, NT, Linux) is required. -Migration and upgrade experience is essential. -Expert knowledge of on-line back-up/recovery procedures with snapshotting a plus. -Proficiency with RMAN is essential. -Ability to work with engineering staff to configure SAN storage for optimal Oracle performance. -Expert knowledge of UNIX scripting including CRON Jobs, Oracle Stored Procedures, Triggers, Packages, Real Application Clusters (RAC). -Performance Tuning and Performance management skills are required, SQL*Plus, PL/SQL, SQL*Loader, SQL, and UNIX. -The applicant must have in-depth experience with ER diagramming, data modeling tools, (erWIN preferred) normalization, de-normalization, database programming and design, query optimization, index optimization, use of hints. Optimal setup of dblink, views, and use of Oracle gateway is required. Must understand how to design and tune an Oracle database to optimize performance for potentially thousands of concurrent, browser-based users together with ETL processes. -Excellent written and verbal communications skills with the ability to effectively communicate technical and business problems/issues in a non-technical manner, strong problem resolution, analysis, and customer service skills are required. -Ability to manage multiple tasks with shifting priorities is a necessity. -Ability to work within a team environment and communicate effectively with other team members is required. -Proven mentoring skills to build the strength of the DBA staff. For immediate consideration, please email your resume as an attachment to: OraStaff, Inc. Email: [EMAIL PROTECTED] Please Use Job Code: Minn./DBA/MH Phone: 1-800-549-8502. I pay referral fees. So please contact me if you know of anyone who would be qualified/interested in the position described above- if it is not a match for your skills. Thanks. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: OraStaff INET: [EMAIL PROTECTED] Fat
RE: RMAN SQL Backtrack
Title: Message
I
don't haveany experience with SQL*Backtrack and I do have some
experience
with
RMAN. Here are my comments:
a)
RMAN is reliable. Once you write the backup scripts, they are executed by
operations
and there no surprises. In order to
rely on those scripts, one needs to test them, especially
the recovery
part.
b)
RMAN needs a 3rd party backup software to run. Things like OmniBackup, Tivoli,
Legato or
SyncSort can be rather expensive.
RMAN doesn't write to tapes itself. RMAN delegates a
backup software contacted through
the routines from libobk.so (or libobk.dll or libobk.sl) to
do its writing. To get the
"libobk.so" from you backup software vendor of choice, you generally
have to write a check. That means
that RMAN is NOT free.
c)
Before version 9, RMAN was arcane and hard to learn. Thanks to Robert Freeman,
it is no
longer so. You can learn how to
configure and use RMAN and you can find a decent book
to learn RMAN from. It's not very
hard and it's fairly logical. One reading of the books suffices
for a good general
understanding.
d)
Quality of the software: RMAN leaves a lot to be desired. Its biggest drawback
is the fact that
it doesn't do any coordination with
the underlying backup catalog. In other words, you can
happily
declare backup obsolete in RMAN and
Legato will not know anything about it and vice versa.
You can even delete backup in Legato
and reuse the tape while RMAN knows nothing about it.
On the other hand, RMAN, in
contrast to all other methods, does not put tablespaces into
the
backup mode, thus generating
floods of redo archives. RMAN doesn't backup data blocks that
have never been used ("behind
the watermark blocks"), which is great if you have a fresh
new
datafile which was added to
the tablespace just in case something might run out of
space.
e) Personnel. Despite the certification process,
it is not always easy to find a trained personnel
which knows how to use it and
how to recover the database. I consider the ability to
recover
the database a basis for
someone to call himself/herself a DBA. You would be surprised
how
many people which claim that
title do not know how to recover the database. Even smaller number
knows how to use
RMAN.
f) I would suggest Jared Still, Cary
Millsap, Rachel Carmichael, Jonathan Lewis, Wolfgang Breitling,
Steve Adams, Gaja V., Arup Nanda,
Kirti Deshpandeand Anjo Kolk to start the Oracle List
certification
process. I would trust
that onemore then the OCP. I apologize to anyone who I
might have forgotten.
Mladen Gogala Oracle DBA Phone:(203) 459-6855
Email:[EMAIL PROTECTED]
-Original Message-From: Smith, Ron L.
[mailto:[EMAIL PROTECTED]Sent: Wednesday, July 16, 2003 10:59
AMTo: Multiple recipients of list ORACLE-LSubject: RMAN
SQL Backtrack
We have been using
SQL Backtrack for backup and recovery forabout 6 years now. We are
being pressured to start using RMAN because it is free. Makes sense but
I am wondering about reliability, complexity, learning curve,
etc...
Has anyone had
experience with both products or anyone new to RMAN that can give me an idea
of what to expect?
Thanks!
Ron
If you are not the intended recipient of this
e-mail message, any use, distribution or copying of the message is prohibited.
Please let me know immediately by return e-mail if you have received this
message by mistake, then delete the e-mail message. Thank
you.
Re: Oracle has out-smarted me again.
Here's what I did: 1. Started up Disk1\install\win32\setup.exe. 2. Chose Disk1\stage\products.jar in Path: field as location of product list. 3. Accepted defaults for installation. 4. After installation completed, returned to Next install screen and chose About; version showed as 2.2.0.18.0. = Paul Baumgartel Transcentive, Inc. www.transcentive.com __ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Paul Baumgartel INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
ORA-0600: [kzckini: nzdsi_i], [28750]
List... OS: SunOS 5.8 Oracle: 8.1.6.1.0 I'm getting the above error in the alert file... my db is up and running, and the trace file says that the error was generated without user session. I looked at metalink and it says that it can be a pga problem or virtual memory problem... but... my virtual memory is set to unlimited, and I'm not using a software called AutoSecure that Metalink claims to be the problem. Any of you have an idea? TIA Regards! JL __ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jose Luis Delgado INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Antw: Re: Insert 8000 Byte into LONG column
Guido... change the datatype! :-) Of course, you can't. Well, have you tried with a Pl-Sql anonymous block? or... Oracle says that using BIND variables you can get more than 4000 chars... have you tried with bind vars? HTH JL --- Guido Konsolke Hi dear list members, we run a database 8.1.6.2 I've run into a problem. I've got a table that contains a LONG column (I know, I know). I have to insert a string into it that has a length 8500 Byte. Whenever I issue the insert statement SQL/PLUS throws the error 'ORA-01704: string literal too long'. Does anyone have an idea how I can get the data into the table? Any help (except: change the datatype ;-)) is appreciated. Greetings, Guido -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Guido Konsolke INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Arup Nanda INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Guido Konsolke INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jose Luis Delgado INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: * Sr. Oracle DBA with 8i and 9i experience needed..
Regis, that's not discrimination as it is defined in the US. it is a business decision not to spend money to hire someone to work for you. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Wednesday, July 16, 2003 11:25 AM To: Multiple recipients of list ORACLE-L and they had NO H-1B candidates please. What a discrimination... -Original Message- Sent: Wednesday, July 16, 2003 4:04 PM To: Multiple recipients of list ORACLE-L Jared, can we get orastaff banned from the list? I know people need jobs but Orastaff is a notorious spammer. I get spammed from these guys through my home email. From: OraStaff [EMAIL PROTECTED] Date: 2003/07/16 Wed AM 10:54:27 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: * Sr. Oracle DBA with 8i and 9i experience needed.. Minneapolis, Minnesota company has a great opportunity available for a Sr. level Oracle DBA to join their IT staff. The selected candidate must be highly skilled in solving extremely complex and very critical customer issues. With preferably over 10 years experience in a large-scale multi-network open-systems environment, the candidate anticipates and plans for reliability, availability, and serviceability in the design, development and implementation of Oracle 8i and 9i solutions. The candidate will be recognized as a technical authority in the design, analysis, implementation and integration of large-scale database management systems. Candidates local to the Minneapolis area are preferred, but any candidate who meets the qualifications for the position will be considered. Base Salary is in the 85-100K range plus bonus. PLEASE Do Not send your resume for this position UNLESS you have the skills outlined below for this position. Please Do Not send your resume unless you have a stable work history. Candidates whose work history includes frequent job changes connot be considered. This is a full time staff position so no sub-contractors or third parties please. NO H-1B candidates please. *MUST meet these requirements: -BS degree in CS or related field. -8-10 years experience in a large-scale multi-network open-systems environment. -Very solid Oracle DBA experience..including 8i and 9i. -Proficient at capacity monitoring and management capabilities, preferably an expert knowledge of Enterprise Manager 9i (OEM), and STATSPACK. -Experience performing Oracle installations, upgrades, and supporting Oracle utilities and services in a variety of operating systems (Solaris, NT, Linux) is required. -Migration and upgrade experience is essential. -Expert knowledge of on-line back-up/recovery procedures with snapshotting a plus. -Proficiency with RMAN is essential. -Ability to work with engineering staff to configure SAN storage for optimal Oracle performance. -Expert knowledge of UNIX scripting including CRON Jobs, Oracle Stored Procedures, Triggers, Packages, Real Application Clusters (RAC). -Performance Tuning and Performance management skills are required, SQL*Plus, PL/SQL, SQL*Loader, SQL, and UNIX. -The applicant must have in-depth experience with ER diagramming, data modeling tools, (erWIN preferred) normalization, de-normalization, database programming and design, query optimization, index optimization, use of hints. Optimal setup of dblink, views, and use of Oracle gateway is required. Must understand how to design and tune an Oracle database to optimize performance for potentially thousands of concurrent, browser-based users together with ETL processes. -Excellent written and verbal communications skills with the ability to effectively communicate technical and business problems/issues in a non-technical manner, strong problem resolution, analysis, and customer service skills are required. -Ability to manage multiple tasks with shifting priorities is a necessity. -Ability to work within a team environment and communicate effectively with other team members is required. -Proven mentoring skills to build the strength of the DBA staff. For immediate consideration, please email your resume as an attachment to: OraStaff, Inc. Email: [EMAIL PROTECTED] Please Use Job Code: Minn./DBA/MH Phone: 1-800-549-8502. I pay referral fees. So please contact me if you know of anyone who would be qualified/interested in the position described above- if it is not a match for your skills. Thanks. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: OraStaff INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the
RE: * Sr. Oracle DBA with 8i and 9i experience needed..
Intersting... I get spammed at work, but never at home. I always access this list from work. Could be just a coincidence though. Patrice. -Original Message- Sent: Wednesday, July 16, 2003 12:04 PM To: Multiple recipients of list ORACLE-L Jared, can we get orastaff banned from the list? I know people need jobs but Orastaff is a notorious spammer. I get spammed from these guys through my home email. From: OraStaff [EMAIL PROTECTED] Date: 2003/07/16 Wed AM 10:54:27 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: * Sr. Oracle DBA with 8i and 9i experience needed.. Minneapolis, Minnesota company has a great opportunity available for a Sr. level Oracle DBA to join their IT staff. The selected candidate must be highly skilled in solving extremely complex and very critical customer issues. With preferably over 10 years experience in a large-scale multi-network open-systems environment, the candidate anticipates and plans for reliability, availability, and serviceability in the design, development and implementation of Oracle 8i and 9i solutions. The candidate will be recognized as a technical authority in the design, analysis, implementation and integration of large-scale database management systems. Candidates local to the Minneapolis area are preferred, but any candidate who meets the qualifications for the position will be considered. Base Salary is in the 85-100K range plus bonus. PLEASE Do Not send your resume for this position UNLESS you have the skills outlined below for this position. Please Do Not send your resume unless you have a stable work history. Candidates whose work history includes frequent job changes connot be considered. This is a full time staff position so no sub-contractors or third parties please. NO H-1B candidates please. *MUST meet these requirements: -BS degree in CS or related field. -8-10 years experience in a large-scale multi-network open-systems environment. -Very solid Oracle DBA experience..including 8i and 9i. -Proficient at capacity monitoring and management capabilities, preferably an expert knowledge of Enterprise Manager 9i (OEM), and STATSPACK. -Experience performing Oracle installations, upgrades, and supporting Oracle utilities and services in a variety of operating systems (Solaris, NT, Linux) is required. -Migration and upgrade experience is essential. -Expert knowledge of on-line back-up/recovery procedures with snapshotting a plus. -Proficiency with RMAN is essential. -Ability to work with engineering staff to configure SAN storage for optimal Oracle performance. -Expert knowledge of UNIX scripting including CRON Jobs, Oracle Stored Procedures, Triggers, Packages, Real Application Clusters (RAC). -Performance Tuning and Performance management skills are required, SQL*Plus, PL/SQL, SQL*Loader, SQL, and UNIX. -The applicant must have in-depth experience with ER diagramming, data modeling tools, (erWIN preferred) normalization, de-normalization, database programming and design, query optimization, index optimization, use of hints. Optimal setup of dblink, views, and use of Oracle gateway is required. Must understand how to design and tune an Oracle database to optimize performance for potentially thousands of concurrent, browser-based users together with ETL processes. -Excellent written and verbal communications skills with the ability to effectively communicate technical and business problems/issues in a non-technical manner, strong problem resolution, analysis, and customer service skills are required. -Ability to manage multiple tasks with shifting priorities is a necessity. -Ability to work within a team environment and communicate effectively with other team members is required. -Proven mentoring skills to build the strength of the DBA staff. For immediate consideration, please email your resume as an attachment to: OraStaff, Inc. Email: [EMAIL PROTECTED] Please Use Job Code: Minn./DBA/MH Phone: 1-800-549-8502. I pay referral fees. So please contact me if you know of anyone who would be qualified/interested in the position described above- if it is not a match for your skills. Thanks. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: OraStaff INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the
RE: * Sr. Oracle DBA with 8i and 9i experience needed..
Title: RE: * Sr. Oracle DBA with 8i and 9i experience needed.. Of the total SPAM I get each day, OraStaff is so far down in the noise to be unnoticeable. Heck I'll tolerate any spammer who only bothers me once or twice a month. Dammed those who bother me twice an hour! Dick GouletSenior Oracle DBAOracle Certified 8i DBA -Original Message-From: April Wells [mailto:[EMAIL PROTECTED]Sent: Wednesday, July 16, 2003 11:35 AMTo: Multiple recipients of list ORACLE-LSubject: RE: * Sr. Oracle DBA with 8i and 9i experience needed.. depends on the keyboard... I have one where it is right next to the enter key and backslash is next to the back space key. April Wells Oracle DBA/Oracle Apps DBA Corporate Systems Amarillo Texas You will recognize your own path when you come upon it, because you will suddenly have all the energy and imagination you will ever need. ~ Jerry Gillies ~ -Original Message- From: Ruth Gramolini [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 16, 2003 10:15 AM To: Multiple recipients of list ORACLE-L Subject: Re: * Sr. Oracle DBA with 8i and 9i experience needed.. Some of us like seeing the possibilities. The delete key is just to the right of the backslash. Ruth - Original Message - To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED] Sent: Wednesday, July 16, 2003 11:04 AM Jared, can we get orastaff banned from the list? I know people need jobs but Orastaff is a notorious spammer. I get spammed from these guys through my home email. From: OraStaff [EMAIL PROTECTED] Date: 2003/07/16 Wed AM 10:54:27 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sr. Oracle DBA with 8i and 9i experience needed.. Minneapolis, Minnesota company has a great opportunity available for a Sr. level Oracle DBA to join their IT staff. The selected candidate must be highly skilled in solving extremely complex and very critical customer issues. With preferably over 10 years experience in a large-scale multi-network open-systems environment, the candidate anticipates and plans for reliability, availability, and serviceability in the design, development and implementation of Oracle 8i and 9i solutions. The candidate will be recognized as a technical authority in the design, analysis, implementation and integration of large-scale database management systems. Candidates local to the Minneapolis area are preferred, but any candidate who meets the qualifications for the position will be considered. Base Salary is in the 85-100K range plus bonus. PLEASE Do Not send your resume for this position UNLESS you have the skills outlined below for this position. Please Do Not send your resume unless you have a stable work history. Candidates whose work history includes frequent job changes connot be considered. This is a full time staff position so no sub-contractors or third parties please. NO H-1B candidates please.*MUST meet these requirements: -BS degree in CS or related field. -8-10 years experience in a large-scale multi-network open-systems environment. -Very solid Oracle DBA experience..including 8i and 9i. -Proficient at capacity monitoring and management capabilities, preferably an expert knowledge of Enterprise Manager 9i (OEM), and STATSPACK. -Experience performing Oracle installations, upgrades, and supporting Oracle utilities and services in a variety of operating systems (Solaris, NT, Linux) is required. -Migration and upgrade experience is essential. -Expert knowledge of on-line back-up/recovery procedures with "snapshotting" a plus. -Proficiency with RMAN is essential. -Ability to work with engineering staff to configure SAN storage for optimal Oracle performance. -Expert knowledge of UNIX scripting including CRON Jobs, Oracle Stored Procedures, Triggers, Packages, Real Application Clusters (RAC). -Performance Tuning and Performance management skills are required, SQL*Plus, PL/SQL, SQL*Loader, SQL, and UNIX. -The applicant must have in-depth experience with ER diagramming, data modeling tools, (erWIN preferred) normalization, de-normalization, database programming and design, query optimization, index optimization, use of hints. Optimal setup of dblink, views, and use of Oracle gateway is required. Must understand how to design and tune an Oracle database to optimize performance for potentially thousands of concurrent, browser-based users together with ETL processes. -Excellent written and verbal communications skills with the ability to effectively communicate technical and business problems/issues in a non-technical manner, strong problem resolution, analysis, and customer service skills are required. -Ability to manage multiple tasks with shifting priorities is a necessity. -Ability to work within a team environment and communicate effectively with other team members is required. -Proven mentoring
RE: * Sr. Oracle DBA with 8i and 9i experience needed..
While the statement itself strikes me as blunt, I don't think it is discriminatory in this case. Because of the availability of a large number of qualified DBAs, companies don't want to go through the hassle of providing sponsorship these days. The 'No H-1B' clause is to filter out candidates with low marketability, just like the statments about job history and third parties. Its a reflection of current market condition, thats all. Dennis -Original Message- Sent: Wednesday, July 16, 2003 10:25 AM To: Multiple recipients of list ORACLE-L and they had NO H-1B candidates please. What a discrimination... -Original Message- Sent: Wednesday, July 16, 2003 4:04 PM To: Multiple recipients of list ORACLE-L Jared, can we get orastaff banned from the list? I know people need jobs but Orastaff is a notorious spammer. I get spammed from these guys through my home email. From: OraStaff [EMAIL PROTECTED] Date: 2003/07/16 Wed AM 10:54:27 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: * Sr. Oracle DBA with 8i and 9i experience needed.. Minneapolis, Minnesota company has a great opportunity available for a Sr. level Oracle DBA to join their IT staff. The selected candidate must be highly skilled in solving extremely complex and very critical customer issues. With preferably over 10 years experience in a large-scale multi-network open-systems environment, the candidate anticipates and plans for reliability, availability, and serviceability in the design, development and implementation of Oracle 8i and 9i solutions. The candidate will be recognized as a technical authority in the design, analysis, implementation and integration of large-scale database management systems. Candidates local to the Minneapolis area are preferred, but any candidate who meets the qualifications for the position will be considered. Base Salary is in the 85-100K range plus bonus. PLEASE Do Not send your resume for this position UNLESS you have the skills outlined below for this position. Please Do Not send your resume unless you have a stable work history. Candidates whose work history includes frequent job changes connot be considered. This is a full time staff position so no sub-contractors or third parties please. NO H-1B candidates please. *MUST meet these requirements: -BS degree in CS or related field. -8-10 years experience in a large-scale multi-network open-systems environment. -Very solid Oracle DBA experience..including 8i and 9i. -Proficient at capacity monitoring and management capabilities, preferably an expert knowledge of Enterprise Manager 9i (OEM), and STATSPACK. -Experience performing Oracle installations, upgrades, and supporting Oracle utilities and services in a variety of operating systems (Solaris, NT, Linux) is required. -Migration and upgrade experience is essential. -Expert knowledge of on-line back-up/recovery procedures with snapshotting a plus. -Proficiency with RMAN is essential. -Ability to work with engineering staff to configure SAN storage for optimal Oracle performance. -Expert knowledge of UNIX scripting including CRON Jobs, Oracle Stored Procedures, Triggers, Packages, Real Application Clusters (RAC). -Performance Tuning and Performance management skills are required, SQL*Plus, PL/SQL, SQL*Loader, SQL, and UNIX. -The applicant must have in-depth experience with ER diagramming, data modeling tools, (erWIN preferred) normalization, de-normalization, database programming and design, query optimization, index optimization, use of hints. Optimal setup of dblink, views, and use of Oracle gateway is required. Must understand how to design and tune an Oracle database to optimize performance for potentially thousands of concurrent, browser-based users together with ETL processes. -Excellent written and verbal communications skills with the ability to effectively communicate technical and business problems/issues in a non-technical manner, strong problem resolution, analysis, and customer service skills are required. -Ability to manage multiple tasks with shifting priorities is a necessity. -Ability to work within a team environment and communicate effectively with other team members is required. -Proven mentoring skills to build the strength of the DBA staff. For immediate consideration, please email your resume as an attachment to: OraStaff, Inc. Email: [EMAIL PROTECTED] Please Use Job Code: Minn./DBA/MH Phone: 1-800-549-8502. I pay referral fees. So please contact me if you know of anyone who would be qualified/interested in the position described above- if it is not a match for your skills. Thanks. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: OraStaff INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego,
RE: * Sr. Oracle DBA with 8i and 9i experience needed..
I find the opening from OraStaff to be very helpfull in the job search arena. The function that Bill offers has been helpfull in the past. Ron -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: * Sr. Oracle DBA with 8i and 9i experience needed..
Is it the key with a funny upper arrow marked Shift? Mladen Gogala Oracle DBA Phone:(203) 459-6855 Email:[EMAIL PROTECTED] -Original Message- Sent: Wednesday, July 16, 2003 11:15 AM To: Multiple recipients of list ORACLE-L Some of us like seeing the possibilities. The delete key is just to the right of the backslash. Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, July 16, 2003 11:04 AM Jared, can we get orastaff banned from the list? I know people need jobs but Orastaff is a notorious spammer. I get spammed from these guys through my home email. From: OraStaff [EMAIL PROTECTED] Date: 2003/07/16 Wed AM 10:54:27 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: * Sr. Oracle DBA with 8i and 9i experience needed.. Minneapolis, Minnesota company has a great opportunity available for a Sr. level Oracle DBA to join their IT staff. The selected candidate must be highly skilled in solving extremely complex and very critical customer issues. With preferably over 10 years experience in a large-scale multi-network open-systems environment, the candidate anticipates and plans for reliability, availability, and serviceability in the design, development and implementation of Oracle 8i and 9i solutions. The candidate will be recognized as a technical authority in the design, analysis, implementation and integration of large-scale database management systems. Candidates local to the Minneapolis area are preferred, but any candidate who meets the qualifications for the position will be considered. Base Salary is in the 85-100K range plus bonus. PLEASE Do Not send your resume for this position UNLESS you have the skills outlined below for this position. Please Do Not send your resume unless you have a stable work history. Candidates whose work history includes frequent job changes connot be considered. This is a full time staff position so no sub-contractors or third parties please. NO H-1B candidates please. *MUST meet these requirements: -BS degree in CS or related field. -8-10 years experience in a large-scale multi-network open-systems environment. -Very solid Oracle DBA experience..including 8i and 9i. -Proficient at capacity monitoring and management capabilities, preferably an expert knowledge of Enterprise Manager 9i (OEM), and STATSPACK. -Experience performing Oracle installations, upgrades, and supporting Oracle utilities and services in a variety of operating systems (Solaris, NT, Linux) is required. -Migration and upgrade experience is essential. -Expert knowledge of on-line back-up/recovery procedures with snapshotting a plus. -Proficiency with RMAN is essential. -Ability to work with engineering staff to configure SAN storage for optimal Oracle performance. -Expert knowledge of UNIX scripting including CRON Jobs, Oracle Stored Procedures, Triggers, Packages, Real Application Clusters (RAC). -Performance Tuning and Performance management skills are required, SQL*Plus, PL/SQL, SQL*Loader, SQL, and UNIX. -The applicant must have in-depth experience with ER diagramming, data modeling tools, (erWIN preferred) normalization, de-normalization, database programming and design, query optimization, index optimization, use of hints. Optimal setup of dblink, views, and use of Oracle gateway is required. Must understand how to design and tune an Oracle database to optimize performance for potentially thousands of concurrent, browser-based users together with ETL processes. -Excellent written and verbal communications skills with the ability to effectively communicate technical and business problems/issues in a non-technical manner, strong problem resolution, analysis, and customer service skills are required. -Ability to manage multiple tasks with shifting priorities is a necessity. -Ability to work within a team environment and communicate effectively with other team members is required. -Proven mentoring skills to build the strength of the DBA staff. For immediate consideration, please email your resume as an attachment to: OraStaff, Inc. Email: [EMAIL PROTECTED] Please Use Job Code: Minn./DBA/MH Phone: 1-800-549-8502. I pay referral fees. So please contact me if you know of anyone who would be qualified/interested in the position described above- if it is not a match for your skills. Thanks. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: OraStaff INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L
H1-B (was: * Sr. Oracle DBA with 8i and 9i experience needed..)
Why would the H1-B cost the employer money? Usually if you want to travel and get a visa you can pay a small fee at the local embassy or consultate and that's it. Work visas may be different, I don't know Do U.S. employers pay H1-B visa employees' health benefits? Just curious, I have never worked in the U.S.. I am enjoying the 32 degree Celcius (96 degree Farenheit) weather here in Canada (was 32 degrees a couple of weeks ago anyway). : ) I do see news items sometimes talking about H1-B VISA staff vs. American staff competing for jobs. Usually when there is a recession. During boom times employers lobby the Feds to increase the H1-B VISA quotas. Patrice. -Original Message- Sent: Wednesday, July 16, 2003 12:55 PM To: Multiple recipients of list ORACLE-L Regis, that's not discrimination as it is defined in the US. it is a business decision not to spend money to hire someone to work for you. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Wednesday, July 16, 2003 11:25 AM To: Multiple recipients of list ORACLE-L and they had NO H-1B candidates please. What a discrimination... -Original Message- Sent: Wednesday, July 16, 2003 4:04 PM To: Multiple recipients of list ORACLE-L Jared, can we get orastaff banned from the list? I know people need jobs but Orastaff is a notorious spammer. I get spammed from these guys through my home email. From: OraStaff [EMAIL PROTECTED] Date: 2003/07/16 Wed AM 10:54:27 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: * Sr. Oracle DBA with 8i and 9i experience needed.. Minneapolis, Minnesota company has a great opportunity available for a Sr. level Oracle DBA to join their IT staff. The selected candidate must be highly skilled in solving extremely complex and very critical customer issues. With preferably over 10 years experience in a large-scale multi-network open-systems environment, the candidate anticipates and plans for reliability, availability, and serviceability in the design, development and implementation of Oracle 8i and 9i solutions. The candidate will be recognized as a technical authority in the design, analysis, implementation and integration of large-scale database management systems. Candidates local to the Minneapolis area are preferred, but any candidate who meets the qualifications for the position will be considered. Base Salary is in the 85-100K range plus bonus. PLEASE Do Not send your resume for this position UNLESS you have the skills outlined below for this position. Please Do Not send your resume unless you have a stable work history. Candidates whose work history includes frequent job changes connot be considered. This is a full time staff position so no sub-contractors or third parties please. NO H-1B candidates please. *MUST meet these requirements: -BS degree in CS or related field. -8-10 years experience in a large-scale multi-network open-systems environment. -Very solid Oracle DBA experience..including 8i and 9i. -Proficient at capacity monitoring and management capabilities, preferably an expert knowledge of Enterprise Manager 9i (OEM), and STATSPACK. -Experience performing Oracle installations, upgrades, and supporting Oracle utilities and services in a variety of operating systems (Solaris, NT, Linux) is required. -Migration and upgrade experience is essential. -Expert knowledge of on-line back-up/recovery procedures with snapshotting a plus. -Proficiency with RMAN is essential. -Ability to work with engineering staff to configure SAN storage for optimal Oracle performance. -Expert knowledge of UNIX scripting including CRON Jobs, Oracle Stored Procedures, Triggers, Packages, Real Application Clusters (RAC). -Performance Tuning and Performance management skills are required, SQL*Plus, PL/SQL, SQL*Loader, SQL, and UNIX. -The applicant must have in-depth experience with ER diagramming, data modeling tools, (erWIN preferred) normalization, de-normalization, database programming and design, query optimization, index optimization, use of hints. Optimal setup of dblink, views, and use of Oracle gateway is required. Must understand how to design and tune an Oracle database to optimize performance for potentially thousands of concurrent, browser-based users together with ETL processes. -Excellent written and verbal communications skills with the ability to effectively communicate technical and business problems/issues in a non-technical manner, strong problem resolution, analysis, and customer service skills are required. -Ability to manage multiple tasks with shifting priorities is a necessity. -Ability to work within a team environment and communicate effectively with other team members is required. -Proven mentoring skills to build the strength of the DBA staff. For immediate consideration, please email your resume
Re: Oracle has out-smarted me again.
Thanks. The problem was with my inattention. Having unzipped the zip file, I failed to note that I had to unzip the jar file. Old age and assuming that zipped files would be .ZIP files were my problem. Paul Baumgartel treegarden To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] @yahoo.com cc: Sent by: Subject: Re: Oracle has out-smarted me again. ml-errors 07/16/2003 10:49 AM Please respond to ORACLE-L It's been a month or two since I did this, but I did verify that the version was ...18.0, and I could swear that was the jar file I used. I'm going to install it on another machine and note my steps, then I'll post another reply. --- Thomas Day [EMAIL PROTECTED] wrote: Yes, but that just re-installs the prior, 2.2.0.12.0, installer. The directions say to extract the zip to some file. How do you tell the install where some is? Paul Baumgartel treegarden To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] @yahoo.com cc: Sent by: Subject: Re: Oracle has out-smarted me again. ml-errors 07/15/2003 05:14 PM Please respond to ORACLE-L The products.jar file you need is in Disk1\install\stage. --- Thomas Day [EMAIL PROTECTED] wrote: Interim Patch: 2878462 DATE: May 7, 2003 Platform Patch for : Microsoft Windows NT Microsoft Windows 2000 Microsoft Windows XP Product Version # : 2.2.0.18.0 Product Patched: UNIVERSAL INSTALLER Patch Installation Instructions : ( this assumes that you have already unzipped the file you downloaded from metalink): 1. Extract the contents of the file oui220180_nt.jar into a newly created directory using C: jar -xvf oui220180_nt.jar or C: unzip oui220180_nt.jar or You can use the winzip graphical utility as well. 2. Change directory to Disk1\install\win32 as : cd Disk1\install\win32 1. Run setup.exe from Disk1\install\win32 directory as C: setup.exe:. This will launch the Install session for installing OUI 2.2.0.18.0 to the current Oracle environment. After the installation completes, you can verify that the OUI version is 2.2.0.18.0 by invoking Oracle Universal Installer from Windows Program Menu and clicking on the About Oracle Universal Installer button . * Having R'ed the old FM to a fare-thee-well, how is one supposed to make the above instructions work? Following them slavishly will re-install the current version of the OUI, since the products.jar hasn't changed. OUI doesn't recognize oui220180_nt.jar as a substitute for products.jar. Anyone who has had any success in installing OUI 2.2.0.18.0 on Win2K, could you
Re: should you separate indexes from tables in separate dataf
On a related note: We recently installed an app from a vendor and I noticed that the installer stored the indexes in the same tablespace as the data (even though I had a separate tablespace just for indexes). Should I take the time now to separate the two? My gut says yes. Sorry if this is a silly question. Thanks! Dwayne -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Dwayne Cox INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Oracle Instances not starting up via services
what about ora_wms_autostart ? -ak - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, July 16, 2003 4:24 AM Hi All, I have inherited a couple of databases on one of the servers here. The server was taken down for hardware repairs during the week and when it came back up the databases did not start. (They are set to start automatically via the services) I have done some research via the internet and I deleted and recreated the service via the ORADIM utility. But this has n't fixed it. I have to manually go into and start the databases (explicitly stating where the init.ora file is) I am getting this error message when I go in via SQLPLUS /NOLOG (connected as internal) Startup error message LRM-00109 can not open parameter file '%oracle_home%/database/init%oracle_sid%.ora If I do a startup pfile=c:\oracle\ora81\database\initwms.ora it starts as normal. I've checked that the oracle home is defined as c:\oracle\ora81 so I am beginning to suspect it has something to do with the oracle sid. In registry the ora_wms_pfile location is set to c:\oracle\ora8\database\initwms.ora We have 4 different instances on this box and none of them will start automatically. Oracle version 8.1.7 running on a Windows Server 2000 box Any help appreciated, Thanks, N. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: AK INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: * Sr. Oracle DBA with 8i and 9i experience needed..
Title: RE: * Sr. Oracle DBA with 8i and 9i experience needed.. Does TX have special keyboard layout? I know that everything is big in TX, but I didn't realize that was the case with the keyboards? Mladen Gogala Oracle DBA Phone:(203) 459-6855 Email:[EMAIL PROTECTED] -Original Message-From: April Wells [mailto:[EMAIL PROTECTED]Sent: Wednesday, July 16, 2003 11:35 AMTo: Multiple recipients of list ORACLE-LSubject: RE: * Sr. Oracle DBA with 8i and 9i experience needed.. depends on the keyboard... I have one where it is right next to the enter key and backslash is next to the back space key. April Wells Oracle DBA/Oracle Apps DBA Corporate Systems Amarillo Texas You will recognize your own path when you come upon it, because you will suddenly have all the energy and imagination you will ever need. ~ Jerry Gillies ~ -Original Message- From: Ruth Gramolini [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 16, 2003 10:15 AM To: Multiple recipients of list ORACLE-L Subject: Re: * Sr. Oracle DBA with 8i and 9i experience needed.. Some of us like seeing the possibilities. The delete key is just to the right of the backslash. Ruth - Original Message - To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED] Sent: Wednesday, July 16, 2003 11:04 AM Jared, can we get orastaff banned from the list? I know people need jobs but Orastaff is a notorious spammer. I get spammed from these guys through my home email. From: OraStaff [EMAIL PROTECTED] Date: 2003/07/16 Wed AM 10:54:27 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: * Sr. Oracle DBA with 8i and 9i experience needed.. Minneapolis, Minnesota company has a great opportunity available for a Sr. level Oracle DBA to join their IT staff. The selected candidate must be highly skilled in solving extremely complex and very critical customer issues. With preferably over 10 years experience in a large-scale multi-network open-systems environment, the candidate anticipates and plans for reliability, availability, and serviceability in the design, development and implementation of Oracle 8i and 9i solutions. The candidate will be recognized as a technical authority in the design, analysis, implementation and integration of large-scale database management systems. Candidates local to the Minneapolis area are preferred, but any candidate who meets the qualifications for the position will be considered. Base Salary is in the 85-100K range plus bonus. PLEASE Do Not send your resume for this position UNLESS you have the skills outlined below for this position. Please Do Not send your resume unless you have a stable work history. Candidates whose work history includes frequent job changes connot be considered. This is a full time staff position so no sub-contractors or third parties please. NO H-1B candidates please.*MUST meet these requirements: -BS degree in CS or related field. -8-10 years experience in a large-scale multi-network open-systems environment. -Very solid Oracle DBA experience..including 8i and 9i. -Proficient at capacity monitoring and management capabilities, preferably an expert knowledge of Enterprise Manager 9i (OEM), and STATSPACK. -Experience performing Oracle installations, upgrades, and supporting Oracle utilities and services in a variety of operating systems (Solaris, NT, Linux) is required. -Migration and upgrade experience is essential. -Expert knowledge of on-line back-up/recovery procedures with "snapshotting" a plus. -Proficiency with RMAN is essential. -Ability to work with engineering staff to configure SAN storage for optimal Oracle performance. -Expert knowledge of UNIX scripting including CRON Jobs, Oracle Stored Procedures, Triggers, Packages, Real Application Clusters (RAC). -Performance Tuning and Performance management skills are required, SQL*Plus, PL/SQL, SQL*Loader, SQL, and UNIX. -The applicant must have in-depth experience with ER diagramming, data modeling tools, (erWIN preferred) normalization, de-normalization, database programming and design, query optimization, index optimization, use of hints. Optimal setup of dblink, views, and use of Oracle gateway is required. Must understand how to design and tune an Oracle database to optimize performance for potentially thousands of concurrent, browser-based users together with ETL processes. -Excellent written and verbal communications skills with the ability to effectively communicate technical and business problems/issues in a non-technical manner, strong problem resolution, analysis, and customer service skills are required. -Ability to manage multiple tasks with shifting priorities is a
RAC or Oracle Fail Safe
Hello all, We have setup a Microsoft Cluster Server (MSCS) cluster, with two nodes, using W2K, and now are in the process of deploying Oracle 9i on it. For the purpose of high availability (HA), we are deliberating on setting up either RAC or Oracle Fail Safe. The confusion is over the fact that if we get HA with oracle Fail Safe, i.e. if one node is down due to any problem, then the other takes over, then can we do without RAC? Which of these two is more transparent to the user, i.e. which will take less time to shift the load from one node (server) to the other node? Can any one explain the benefits of using RAC over Oracle Fail Safe, or vice versa. Regards, Hussain DBA SKMCHRC -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hussain Ahmed Qadri INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: * Sr. Oracle DBA with 8i and 9i experience needed..
Tom, I see that...and I wish only if things were different... -Original Message- Sent: Wednesday, July 16, 2003 4:55 PM To: Multiple recipients of list ORACLE-L Regis, that's not discrimination as it is defined in the US. it is a business decision not to spend money to hire someone to work for you. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Wednesday, July 16, 2003 11:25 AM To: Multiple recipients of list ORACLE-L and they had NO H-1B candidates please. What a discrimination... -Original Message- Sent: Wednesday, July 16, 2003 4:04 PM To: Multiple recipients of list ORACLE-L Jared, can we get orastaff banned from the list? I know people need jobs but Orastaff is a notorious spammer. I get spammed from these guys through my home email. From: OraStaff [EMAIL PROTECTED] Date: 2003/07/16 Wed AM 10:54:27 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: * Sr. Oracle DBA with 8i and 9i experience needed.. Minneapolis, Minnesota company has a great opportunity available for a Sr. level Oracle DBA to join their IT staff. The selected candidate must be highly skilled in solving extremely complex and very critical customer issues. With preferably over 10 years experience in a large-scale multi-network open-systems environment, the candidate anticipates and plans for reliability, availability, and serviceability in the design, development and implementation of Oracle 8i and 9i solutions. The candidate will be recognized as a technical authority in the design, analysis, implementation and integration of large-scale database management systems. Candidates local to the Minneapolis area are preferred, but any candidate who meets the qualifications for the position will be considered. Base Salary is in the 85-100K range plus bonus. PLEASE Do Not send your resume for this position UNLESS you have the skills outlined below for this position. Please Do Not send your resume unless you have a stable work history. Candidates whose work history includes frequent job changes connot be considered. This is a full time staff position so no sub-contractors or third parties please. NO H-1B candidates please. *MUST meet these requirements: -BS degree in CS or related field. -8-10 years experience in a large-scale multi-network open-systems environment. -Very solid Oracle DBA experience..including 8i and 9i. -Proficient at capacity monitoring and management capabilities, preferably an expert knowledge of Enterprise Manager 9i (OEM), and STATSPACK. -Experience performing Oracle installations, upgrades, and supporting Oracle utilities and services in a variety of operating systems (Solaris, NT, Linux) is required. -Migration and upgrade experience is essential. -Expert knowledge of on-line back-up/recovery procedures with snapshotting a plus. -Proficiency with RMAN is essential. -Ability to work with engineering staff to configure SAN storage for optimal Oracle performance. -Expert knowledge of UNIX scripting including CRON Jobs, Oracle Stored Procedures, Triggers, Packages, Real Application Clusters (RAC). -Performance Tuning and Performance management skills are required, SQL*Plus, PL/SQL, SQL*Loader, SQL, and UNIX. -The applicant must have in-depth experience with ER diagramming, data modeling tools, (erWIN preferred) normalization, de-normalization, database programming and design, query optimization, index optimization, use of hints. Optimal setup of dblink, views, and use of Oracle gateway is required. Must understand how to design and tune an Oracle database to optimize performance for potentially thousands of concurrent, browser-based users together with ETL processes. -Excellent written and verbal communications skills with the ability to effectively communicate technical and business problems/issues in a non-technical manner, strong problem resolution, analysis, and customer service skills are required. -Ability to manage multiple tasks with shifting priorities is a necessity. -Ability to work within a team environment and communicate effectively with other team members is required. -Proven mentoring skills to build the strength of the DBA staff. For immediate consideration, please email your resume as an attachment to: OraStaff, Inc. Email: [EMAIL PROTECTED] Please Use Job Code: Minn./DBA/MH Phone: 1-800-549-8502. I pay referral fees. So please contact me if you know of anyone who would be qualified/interested in the position described above- if it is not a match for your skills. Thanks. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: OraStaff INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services
Re: security without using different usernames
Pete,
I follow your steps to enable audit_trail = db in init.ora located in
ORACLE_HOME/dbs
and restart my Oracle database on solaris. After my database is up, I do the exact
query in your paper and results as followings:
SQL select name,value from v$parameter
2 where name like 'audit%';
NAME
VALUE
audit_sys_operations
FALSE
audit_file_dest
?/rdbms/audit
audit_trail
NONE
Please tell me what is possible causes that I fail to enable audit on my database.
Any comments are appreciated!
Many thanks!
Don
Pete Finnigan wrote:
Hi
You can get the ip address as follows:
oracle:jupiter sqlplus system/[EMAIL PROTECTED]
SQL*Plus: Release 9.0.1.0.0 - Production on Wed Jun 25 20:45:54 2003
(c) Copyright 2001 Oracle Corporation. All rights reserved.
Connected to:
Oracle9i Enterprise Edition Release 9.0.1.0.0 - Production
With the Partitioning option
JServer Release 9.0.1.0.0 - Production
SQL select sys_context('userenv','ip_address') ip,username,machine
2 from v$session
3 where sys_context('userenv','sessionid')=audsid;
IP
USERNAME
--
MACHINE
172.16.240.11
SYSTEM
jupiter
SQL
you need to provide the service name when you log on otherwise the ip
address is not available using sys_context.
Also new with 9i as part of application contexts you can use the using
clause of create role that a pl/sql package can be used to verify the
user, for example something like this, typed in from memory so check the
syntax!:
create role some_role identified using sys.confirm_user;
create or replace procedure confirm_user
authid current user is
lv_ipaddress varchar2(30);
begin
select sys_context('userenv','ip_address')
into lv_ipaddress
from sys.dual;
if lv_ipaddress='172.16.140.1' then
dbms_session.set_role('some_role');
end if;
end;
/
hth
kind regards
Pete
--
Pete Finnigan
email:[EMAIL PROTECTED]
Web site: http://www.petefinnigan.com - Oracle security audit specialists
Book:Oracle security step-by-step Guide - see http://store.sans.org for details.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Pete Finnigan
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Don Yu
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
RE: Oracle Instances not starting up via services
Nice try but it is set to TRUE already. :-( N. :--Original Message- :-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] :-Behalf Of :-AK :-Sent: 16 July 2003 16:54 :-To: Multiple recipients of list ORACLE-L :-Subject: Re: Oracle Instances not starting up via services :- :- :-what about ora_wms_autostart ? :- :--ak :- :-- Original Message - :-To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] :-Sent: Wednesday, July 16, 2003 4:24 AM :- :- :- :- Hi All, :- :- I have inherited a couple of databases on one of the :-servers here. The :- server was taken down for hardware repairs during the week :-and when it :-came :- back up the databases did not start. (They are set to :-start automatically :- via the services) :- :- I have done some research via the internet and I deleted :-and recreated the :- service via the ORADIM utility. :- :- But this has n't fixed it. I have to manually go into and start the :- databases (explicitly stating where the init.ora file is) :- :- I am getting this error message when I go in via SQLPLUS :-/NOLOG (connected :- as internal) :- :- Startup :- error message LRM-00109 can not open parameter file :- '%oracle_home%/database/init%oracle_sid%.ora :- :- If I do a startup :-pfile=c:\oracle\ora81\database\initwms.ora it starts as :- normal. :- :- I've checked that the oracle home is defined as :-c:\oracle\ora81 so I am :- beginning to suspect it has something to do with the oracle sid. :- In registry the ora_wms_pfile location is set to :- c:\oracle\ora8\database\initwms.ora :- :- We have 4 different instances on this box and none of them :-will start :- automatically. :- Oracle version 8.1.7 running on a Windows Server 2000 box :- :- Any help appreciated, :- :- Thanks, :- :- N. :- :- :- :--- :-Please see the official ORACLE-L FAQ: http://www.orafaq.net :--- :-Author: AK :- INET: [EMAIL PROTECTED] :- :-Fat City Network Services-- 858-538-5051 http://www.fatcity.com :-San Diego, California-- Mailing list and web hosting services :-- :-To REMOVE yourself from this mailing list, send an E-Mail message :-to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in :-the message BODY, include a line containing: UNSUB ORACLE-L :-(or the name of mailing list you want to be removed from). You may :-also send the HELP command for other information (like subscribing). :- :- -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nuala Cullen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: * Sr. Oracle DBA with 8i and 9i experience needed..
Title: RE: * Sr. Oracle DBA with 8i and 9i experience needed.. Especially if he always uses his own, real address. I've put him in my "kill file" and I don't even have to pres "Delete" key or whatever it is they have in TX. Mladen Gogala Oracle DBA Phone:(203) 459-6855 Email:[EMAIL PROTECTED] -Original Message-From: Goulet, Dick [mailto:[EMAIL PROTECTED]Sent: Wednesday, July 16, 2003 12:00 PMTo: Multiple recipients of list ORACLE-LSubject: RE: * Sr. Oracle DBA with 8i and 9i experience needed.. Of the total SPAM I get each day, OraStaff is so far down in the noise to be unnoticeable. Heck I'll tolerate any spammer who only bothers me once or twice a month. Dammed those who bother me twice an hour! Dick GouletSenior Oracle DBAOracle Certified 8i DBA -Original Message-From: April Wells [mailto:[EMAIL PROTECTED]Sent: Wednesday, July 16, 2003 11:35 AMTo: Multiple recipients of list ORACLE-LSubject: RE: * Sr. Oracle DBA with 8i and 9i experience needed.. depends on the keyboard... I have one where it is right next to the enter key and backslash is next to the back space key. April Wells Oracle DBA/Oracle Apps DBA Corporate Systems Amarillo Texas You will recognize your own path when you come upon it, because you will suddenly have all the energy and imagination you will ever need. ~ Jerry Gillies ~ -Original Message- From: Ruth Gramolini [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 16, 2003 10:15 AM To: Multiple recipients of list ORACLE-L Subject: Re: * Sr. Oracle DBA with 8i and 9i experience needed.. Some of us like seeing the possibilities. The delete key is just to the right of the backslash. Ruth - Original Message - To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED] Sent: Wednesday, July 16, 2003 11:04 AM Jared, can we get orastaff banned from the list? I know people need jobs but Orastaff is a notorious spammer. I get spammed from these guys through my home email. From: OraStaff [EMAIL PROTECTED] Date: 2003/07/16 Wed AM 10:54:27 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sr. Oracle DBA with 8i and 9i experience needed.. Minneapolis, Minnesota company has a great opportunity available for a Sr. level Oracle DBA to join their IT staff. The selected candidate must be highly skilled in solving extremely complex and very critical customer issues. With preferably over 10 years experience in a large-scale multi-network open-systems environment, the candidate anticipates and plans for reliability, availability, and serviceability in the design, development and implementation of Oracle 8i and 9i solutions. The candidate will be recognized as a technical authority in the design, analysis, implementation and integration of large-scale database management systems. Candidates local to the Minneapolis area are preferred, but any candidate who meets the qualifications for the position will be considered. Base Salary is in the 85-100K range plus bonus. PLEASE Do Not send your resume for this position UNLESS you have the skills outlined below for this position. Please Do Not send your resume unless you have a stable work history. Candidates whose work history includes frequent job changes connot be considered. This is a full time staff position so no sub-contractors or third parties please. NO H-1B candidates please.*MUST meet these requirements: -BS degree in CS or related field. -8-10 years experience in a large-scale multi-network open-systems environment. -Very solid Oracle DBA experience..including 8i and 9i. -Proficient at capacity monitoring and management capabilities, preferably an expert knowledge of Enterprise Manager 9i (OEM), and STATSPACK. -Experience performing Oracle installations, upgrades, and supporting Oracle utilities and services in a variety of operating systems (Solaris, NT, Linux) is required. -Migration and upgrade experience is essential. -Expert knowledge of on-line back-up/recovery procedures with "snapshotting" a plus. -Proficiency with RMAN is essential. -Ability to work with engineering staff to configure SAN storage for optimal Oracle performance. -Expert knowledge of UNIX scripting including CRON Jobs, Oracle Stored Procedures, Triggers, Packages, Real Application Clusters (RAC). -Performance Tuning and Performance management skills are required, SQL*Plus, PL/SQL, SQL*Loader, SQL, and UNIX. -The applicant must have in-depth experience with ER diagramming, data modeling tools, (erWIN preferred) normalization, de-normalization, database programming and design, query optimization, index optimization, use of hints. Optimal setup of dblink, views, and use of Oracle gateway is
Re: RE: * Sr. Oracle DBA with 8i and 9i experience needed..
what country is 'ie'? is that india? its the same thing if Americans started flooding to your country on the Indian equivalent of an H1-B. If its easier and less expensive to hire Indians, why hire the Americans? US immigration laws are FAR less stringent than Europes btw. I tried getting a job in Europe just because I thought it might be fun to live there and go site seeing for a few years. Unless you get brought over by an American company its incredibly hard to get approval. From: Regis Biassala [EMAIL PROTECTED] Date: 2003/07/16 Wed PM 12:04:30 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: * Sr. Oracle DBA with 8i and 9i experience needed.. Tom, I see that...and I wish only if things were different... -Original Message- Sent: Wednesday, July 16, 2003 4:55 PM To: Multiple recipients of list ORACLE-L Regis, that's not discrimination as it is defined in the US. it is a business decision not to spend money to hire someone to work for you. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Wednesday, July 16, 2003 11:25 AM To: Multiple recipients of list ORACLE-L and they had NO H-1B candidates please. What a discrimination... -Original Message- Sent: Wednesday, July 16, 2003 4:04 PM To: Multiple recipients of list ORACLE-L Jared, can we get orastaff banned from the list? I know people need jobs but Orastaff is a notorious spammer. I get spammed from these guys through my home email. From: OraStaff [EMAIL PROTECTED] Date: 2003/07/16 Wed AM 10:54:27 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: * Sr. Oracle DBA with 8i and 9i experience needed.. Minneapolis, Minnesota company has a great opportunity available for a Sr. level Oracle DBA to join their IT staff. The selected candidate must be highly skilled in solving extremely complex and very critical customer issues. With preferably over 10 years experience in a large-scale multi-network open-systems environment, the candidate anticipates and plans for reliability, availability, and serviceability in the design, development and implementation of Oracle 8i and 9i solutions. The candidate will be recognized as a technical authority in the design, analysis, implementation and integration of large-scale database management systems. Candidates local to the Minneapolis area are preferred, but any candidate who meets the qualifications for the position will be considered. Base Salary is in the 85-100K range plus bonus. PLEASE Do Not send your resume for this position UNLESS you have the skills outlined below for this position. Please Do Not send your resume unless you have a stable work history. Candidates whose work history includes frequent job changes connot be considered. This is a full time staff position so no sub-contractors or third parties please. NO H-1B candidates please. *MUST meet these requirements: -BS degree in CS or related field. -8-10 years experience in a large-scale multi-network open-systems environment. -Very solid Oracle DBA experience..including 8i and 9i. -Proficient at capacity monitoring and management capabilities, preferably an expert knowledge of Enterprise Manager 9i (OEM), and STATSPACK. -Experience performing Oracle installations, upgrades, and supporting Oracle utilities and services in a variety of operating systems (Solaris, NT, Linux) is required. -Migration and upgrade experience is essential. -Expert knowledge of on-line back-up/recovery procedures with snapshotting a plus. -Proficiency with RMAN is essential. -Ability to work with engineering staff to configure SAN storage for optimal Oracle performance. -Expert knowledge of UNIX scripting including CRON Jobs, Oracle Stored Procedures, Triggers, Packages, Real Application Clusters (RAC). -Performance Tuning and Performance management skills are required, SQL*Plus, PL/SQL, SQL*Loader, SQL, and UNIX. -The applicant must have in-depth experience with ER diagramming, data modeling tools, (erWIN preferred) normalization, de-normalization, database programming and design, query optimization, index optimization, use of hints. Optimal setup of dblink, views, and use of Oracle gateway is required. Must understand how to design and tune an Oracle database to optimize performance for potentially thousands of concurrent, browser-based users together with ETL processes. -Excellent written and verbal communications skills with the ability to effectively communicate technical and business problems/issues in a non-technical manner, strong problem resolution, analysis, and customer service skills are required. -Ability to manage multiple tasks with shifting priorities is a necessity. -Ability to work
RE: enterprise manager
the problem is you're trying to use enterprise mangler :P -Original Message- Sent: Wednesday, July 16, 2003 10:50 AM To: Multiple recipients of list ORACLE-L Check: drive:\ORACLE_HOME\sysman\log review the oms.log file... and send the details... HTH JL --- Ruth Gramolini [EMAIL PROTECTED] wrote: Is it an 8.0.x or 8i database? What version of OEM are you running? We need more info to be able to help you. Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, July 16, 2003 6:19 AM hi i run ora8 on w2000 server. my problem is i can ping my database mydb without problems i can login with sqlplus as sys and it works fine but if i start the enterprise manager console and try to login as sys a error occours and means please check the management server status and settings. as managementserver i select mydb. what ican be the problem? thx martin -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: pfeffer INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jose Luis Delgado INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Cunningham, Gerald INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Antw: RE: Insert 8000 Byte into LONG column
Hi Tom, thanks for trying to help. Unfortunately I have no chance because I've no account with write permissions. So it seems impossible to put the data on the server through ftp. Oh: and (of course!) no UTL_FILE_DIR defined in the init...ora. Any other suggestions? tia, Guido [EMAIL PROTECTED] 16.07.2003 17.34 Uhr Guido, Can you use utl_file for this within a PL/SQL block? Tom Mercadante Oracle Certified Professional -Original Message- [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 16, 2003 9:54 AM To: Multiple recipients of list ORACLE-L Hi dear list members, we run a database 8.1.6.2 I've run into a problem. I've got a table that contains a LONG column (I know, I know). I have to insert a string into it that has a length 8500 Byte. Whenever I issue the insert statement SQL/PLUS throws the error 'ORA-01704: string literal too long'. Does anyone have an idea how I can get the data into the table? Any help (except: change the datatype ;-)) is appreciated. Greetings, Guido -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Guido Konsolke INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Guido Konsolke INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: security without using different usernames
What is your database version? 9i? If so you are probably using the SPFILE;
changing the init.ora file wouldn't help.
Shutdown trhe database and startup with the pfile option
startup pfile=init.ora
being in the same directory. You will be able to see the parameter being
set.
HTH.
Arup Nanda
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, July 16, 2003 12:09 PM
Pete,
I follow your steps to enable audit_trail = db in init.ora located in
ORACLE_HOME/dbs
and restart my Oracle database on solaris. After my database is up, I do
the exact
query in your paper and results as followings:
SQL select name,value from v$parameter
2 where name like 'audit%';
NAME
VALUE
--
--
audit_sys_operations
FALSE
audit_file_dest
?/rdbms/audit
audit_trail
NONE
Please tell me what is possible causes that I fail to enable audit on my
database.
Any comments are appreciated!
Many thanks!
Don
Pete Finnigan wrote:
Hi
You can get the ip address as follows:
oracle:jupiter sqlplus system/[EMAIL PROTECTED]
SQL*Plus: Release 9.0.1.0.0 - Production on Wed Jun 25 20:45:54 2003
(c) Copyright 2001 Oracle Corporation. All rights reserved.
Connected to:
Oracle9i Enterprise Edition Release 9.0.1.0.0 - Production
With the Partitioning option
JServer Release 9.0.1.0.0 - Production
SQL select sys_context('userenv','ip_address') ip,username,machine
2 from v$session
3 where sys_context('userenv','sessionid')=audsid;
IP
USERNAME
--
MACHINE
172.16.240.11
SYSTEM
jupiter
SQL
you need to provide the service name when you log on otherwise the ip
address is not available using sys_context.
Also new with 9i as part of application contexts you can use the using
clause of create role that a pl/sql package can be used to verify the
user, for example something like this, typed in from memory so check the
syntax!:
create role some_role identified using sys.confirm_user;
create or replace procedure confirm_user
authid current user is
lv_ipaddress varchar2(30);
begin
select sys_context('userenv','ip_address')
into lv_ipaddress
from sys.dual;
if lv_ipaddress='172.16.140.1' then
dbms_session.set_role('some_role');
end if;
end;
/
hth
kind regards
Pete
--
Pete Finnigan
email:[EMAIL PROTECTED]
Web site: http://www.petefinnigan.com - Oracle security audit
specialists
Book:Oracle security step-by-step Guide - see http://store.sans.org for
details.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Pete Finnigan
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Don Yu
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Arup Nanda
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also
Constraint creations limits.
List, Oracle 8.1.7.4 OpenVMS 7.3-1 I have to drop the current PK constraint on a partitioned table and recreate it with additional columns. The table and partitions are quite large 3GIG + and I was wondering if anyone has found a method if creation the PK constraint one partition at a time. The current method I use is to alter table drop constraint xxx-pk. Then I increase the temp tablespace to handle the new PK. Then I alter table add constraint xxx-pk with the new columns added and list the partitioning clauses and NOLOGGING. It takes about 12 hours to create the PK so it must be done overnight when I am not on-site. I would like to be able to create each partitions PK in a more manageable fashion. Is this possibly an Oracle wish list item? Thanks, Ron -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Interview Questions for a Unix Solaris System Admin
-Original Message- you forgot to list the answers :) Waleed Having been a past sys admin, it was difficult to resist the temptation to respond to the initial post. But, since at least one person appears to have taken it as an indication of what kind of sys admin a candidate will be, I could resist no longer. This kind of questioning is sort of like expecting an Oracle DBA to walk up to a box and type out a complete CREATE DATABASE command that is appropriate for whatever version of Oracle is installed on the box. It tests the ability to memorize trivia rather than what you might expect during normal daily operations. Knowing that most facts can be looked up, I would be much more interested in the person's general philosophy of how to manage things. Is the person a control oriented person or a service oriented person? Try to determine if the person tends to take the time to do things right, or if they tend to go for the quick and dirty solution. Even though automation through scripting involves talent that most people do not have (just like most people are not talented musicians even if they learn a lot about music), I would still try to get some idea of how much talent the candidate has. Somebody who is a skilled script writer can, in effect, work 24 hours per day in surrogate form via cron. In general, I would place much less emphasis on the ability to spout off academic facts and more emphasis on practical day to day technique. I think some probing of the candidate's knowledge of backup and recovery is appropriate -- which means you kind of have to learn some of that yourself. I took the liberty of providing what I think are good answers to some of the questions. -Original Message- 1) What is an inode? Bonus: What important piece of file information is NOT stored in the inode? Might be better to ask the pros and cons and having many inodes as opposed to few; circumstances when you would not want to go with the default number you get when you create a file system (never happened when I was a sys admin). Answer: If this file system is to be used for storing an outrageous number of little files, you might consider increasing the number. In the old days when disks were expensive, and you knew that only a few big files were going on the file system, you might get a little more storage by cutting back on the inodes. I think a more practical question would be to ask how to determine if two file names refer to the same file; that is, the names are hard links. Answer: They have the same inode number as displayed by ls -i You could ask for a discussion of soft links versus hard links. For example: - soft links can refer to something on another file system; hard links can't. - a file exists as long as it has at least one hard link; a soft link can point to a non-existent file. - you can rename a file by creating a hard link, then rm the original file name; can't do that with soft links. - a soft link is essentially a file; a hard link is not. You might ask the circumstances under which the admin would AND has used soft links. In the past, I had the unpleasant experience of inheriting servers where the previous admin(s) had made extensive use of soft links resulting in boxes rife with spaghetti file systems. This usually happens because, for one reason or another, a bunch of files need to be moved from one place to another; then instead of fixing whatever uses those files to tell it to go the new location, a soft link to the new location gets created as a quick and dirty solution. These things accumulate, and eventually you have a mess and booby traps ready to blow up. 2) What is priority paging and how does it work? (mildly dated, but useful if they claim to have been around for a while) Never heard of it. Sounds like a term for a type of swapping (lazy versus not lazy). 3) What does sr stand for in vmstat output? man vmstat. vmstat Virtual Memory Statistics: (pagesize = 8192) procs memorypagesintr cpu r w u act free wire fault cow zero react pin pout in sy cs us sy id 10 1K 49 914K 279K 90K 130G 500M 1G 363 615M2 389 44K 3K 17 13 70 Ummm . got no sr here 4) How would I configure the gigabit ethernet interface to force it to be full duplex? I guess if this were a common daily activity, you would want somebody to know how to do this. For most places, you might do this ... o ... maybe once per year ... maybe. 5) How does RAID-5 work? Bonus question: how does raid-4 work? Extra-extra bonus question: how does raid-3 work? Most people will know that it involves stripe with parity; but better, I think, to ask about pros and cons of RAID-5 versus 0+1 (or 1+0). 6) What's the difference between the passwd and the shadow files? This is OK. I think I would phrase it as: What is the purpose of a shadow file. Answer: It's where the encrypted password is
RE: * Sr. Oracle DBA with 8i and 9i experience needed..
If you use Outlook try SpamBayes. I recently implemented it and it works exceptionally well It uses derivatives of Bayesian algorithms and is extremely accurate considering the nature of spam-crap. If you have an existing spam folder it analyzes that and starts getting smart about what you think is spam. In other words, you train the software as to what is and what is not spam. It then applies this training to your inbox and if an email is questionable it puts it in a ham folder in which can reclassify the email a spam or not. It's easy and painless. After just a couple of days I've achieved VERY accurate spam filtering. After a long time of having to deal with spam it is no longer a problem because SpamBayes does the job. SpamBayes is free. It's written in Python. Give it a try and you too can free yourself from spam!!! http://spambayes.sourceforge.net/ For the mathematically inclined: http://spambayes.sourceforge.net/background.html Free at last... Free at last! Thank God Almighty I am free from spam at last! With apologies to Dr. King, Steve Orr Bozeman, Montana -Original Message- Sent: Wednesday, July 16, 2003 10:00 AM To: Multiple recipients of list ORACLE-L Of the total SPAM I get each day, OraStaff is so far down in the noise to be unnoticeable. Heck I'll tolerate any spammer who only bothers me once or twice a month. Dammed those who bother me twice an hour! Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Wednesday, July 16, 2003 11:35 AM To: Multiple recipients of list ORACLE-L depends on the keyboard... I have one where it is right next to the enter key and backslash is next to the back space key. April Wells Oracle DBA/Oracle Apps DBA Corporate Systems Amarillo Texas You will recognize your own path when you come upon it, because you will suddenly have all the energy and imagination you will ever need. ~ Jerry Gillies ~ -Original Message- Sent: Wednesday, July 16, 2003 10:15 AM To: Multiple recipients of list ORACLE-L Some of us like seeing the possibilities. The delete key is just to the right of the backslash. Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, July 16, 2003 11:04 AM Jared, can we get orastaff banned from the list? I know people need jobs but Orastaff is a notorious spammer. I get spammed from these guys through my home email. From: OraStaff [EMAIL PROTECTED] Date: 2003/07/16 Wed AM 10:54:27 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sr. Oracle DBA with 8i and 9i experience needed.. Minneapolis, Minnesota company has a great opportunity available for a Sr. level Oracle DBA to join their IT staff. The selected candidate must be highly skilled in solving extremely complex and very critical customer issues. With preferably over 10 years experience in a large-scale multi-network open-systems environment, the candidate anticipates and plans for reliability, availability, and serviceability in the design, development and implementation of Oracle 8i and 9i solutions. The candidate will be recognized as a technical authority in the design, analysis, implementation and integration of large-scale database management systems. Candidates local to the Minneapolis area are preferred, but any candidate who meets the qualifications for the position will be considered. Base Salary is in the 85-100K range plus bonus. PLEASE Do Not send your resume for this position UNLESS you have the skills outlined below for this position. Please Do Not send your resume unless you have a stable work history. Candidates whose work history includes frequent job changes connot be considered. This is a full time staff position so no sub-contractors or third parties please. NO H-1B candidates please. *MUST meet these requirements: -BS degree in CS or related field. -8-10 years experience in a large-scale multi-network open-systems environment. -Very solid Oracle DBA experience..including 8i and 9i. -Proficient at capacity monitoring and management capabilities, preferably an expert knowledge of Enterprise Manager 9i (OEM), and STATSPACK. -Experience performing Oracle installations, upgrades, and supporting Oracle utilities and services in a variety of operating systems (Solaris, NT, Linux) is required. -Migration and upgrade experience is essential. -Expert knowledge of on-line back-up/recovery procedures with snapshotting a plus. -Proficiency with RMAN is essential. -Ability to work with engineering staff to configure SAN storage for optimal Oracle performance. -Expert knowledge of UNIX scripting including CRON Jobs, Oracle Stored Procedures, Triggers, Packages, Real Application Clusters (RAC). -Performance Tuning and Performance management skills are required, SQL*Plus, PL/SQL, SQL*Loader, SQL,
RE: RE: * Sr. Oracle DBA with 8i and 9i experience needed..
Title: RE: RE: * Sr. Oracle DBA with 8i and 9i experience needed.. ie is probably Ireland ... IN is for India. Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 16, 2003 12:59 PM To: Multiple recipients of list ORACLE-L Subject: Re: RE: * Sr. Oracle DBA with 8i and 9i experience needed.. what country is 'ie'? is that india? its the same thing if Americans started flooding to your country on the Indian equivalent of an H1-B. If its easier and less expensive to hire Indians, why hire the Americans? US immigration laws are FAR less stringent than Europes btw. I tried getting a job in Europe just because I thought it might be fun to live there and go site seeing for a few years. Unless you get brought over by an American company its incredibly hard to get approval. From: Regis Biassala [EMAIL PROTECTED] Date: 2003/07/16 Wed PM 12:04:30 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: * Sr. Oracle DBA with 8i and 9i experience needed.. Tom, I see that...and I wish only if things were different... -Original Message- Sent: Wednesday, July 16, 2003 4:55 PM To: Multiple recipients of list ORACLE-L Regis, that's not discrimination as it is defined in the US. it is a business decision not to spend money to hire someone to work for you. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Wednesday, July 16, 2003 11:25 AM To: Multiple recipients of list ORACLE-L and they had NO H-1B candidates please. What a discrimination... -Original Message- Sent: Wednesday, July 16, 2003 4:04 PM To: Multiple recipients of list ORACLE-L Jared, can we get orastaff banned from the list? I know people need jobs but Orastaff is a notorious spammer. I get spammed from these guys through my home email. From: OraStaff [EMAIL PROTECTED] Date: 2003/07/16 Wed AM 10:54:27 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: * Sr. Oracle DBA with 8i and 9i experience needed.. Minneapolis, Minnesota company has a great opportunity available for a Sr. level Oracle DBA to join their IT staff. The selected candidate must be highly skilled in solving extremely complex and very critical customer issues. With preferably over 10 years experience in a large-scale multi-network open-systems environment, the candidate anticipates and plans for reliability, availability, and serviceability in the design, development and implementation of Oracle 8i and 9i solutions. The candidate will be recognized as a technical authority in the design, analysis, implementation and integration of large-scale database management systems. Candidates local to the Minneapolis area are preferred, but any candidate who meets the qualifications for the position will be considered. Base Salary is in the 85-100K range plus bonus. PLEASE Do Not send your resume for this position UNLESS you have the skills outlined below for this position. Please Do Not send your resume unless you have a stable work history. Candidates whose work history includes frequent job changes connot be considered. This is a full time staff position so no sub-contractors or third parties please. NO H-1B candidates please. *MUST meet these requirements: -BS degree in CS or related field. -8-10 years experience in a large-scale multi-network open-systems environment. -Very solid Oracle DBA experience..including 8i and 9i. -Proficient at capacity monitoring and management capabilities, preferably an expert knowledge of Enterprise Manager 9i (OEM), and STATSPACK. -Experience performing Oracle installations, upgrades, and supporting Oracle utilities and services in a variety of operating systems (Solaris, NT, Linux) is required. -Migration and upgrade experience is essential. -Expert knowledge of on-line back-up/recovery procedures with snapshotting a plus. -Proficiency with RMAN is essential. -Ability to work with engineering staff to configure SAN storage for optimal Oracle performance. -Expert knowledge of UNIX scripting including CRON Jobs, Oracle Stored Procedures, Triggers, Packages, Real Application Clusters (RAC). -Performance Tuning and Performance management skills are required, SQL*Plus, PL/SQL, SQL*Loader, SQL, and UNIX. -The applicant must have in-depth experience with ER diagramming, data modeling tools, (erWIN preferred) normalization, de-normalization, database programming and design, query optimization, index optimization, use of hints. Optimal setup of dblink,
are fast refreshes really fast?
I've been working with Materialized Views and fast refreshes lately. I
finally stopped to think about what is going on. Amazing what happens when I
stop to think. When I think of fast refreshes, I assume the materialized
view is refreshed from the MLOG$ tables associated with the base tables
(MLOG$ tables record changes, Insert/Update/Delete, made to the base
tables). I just realized that this isn't necessarily so. A fast refresh can
do a full table scan (or index scan, ...) on base tables. Pretty
straightforward, I just never stopped to think. I guess this means that some
fast refreshes can take quite a while (the pause that refreshes?).
Here is the deal. If the materialized view is based on a join there is no
choice but to access the base table(s). A simple example:
CREATE TABLE test1 (id1 number);
CREATE TABLE test2 (id2 number
id1 number);
CREATE MATERIALIZED VIEW LOG on test1
WITH ROWID;
this creates mlog$_test1
there are some problems with join fast refreshes using Primary Keys
CREATE MATERIALIZED VIEW LOG on test2
WITH ROWID;
this creates mlog$_test2
CREATE MATERIALIZED VIEW test1_test2
WITH ROWID
AS
SELECT test1.rowid t1_rowid, test2.rowid t2_rowid, test1.id1, test2.id2
FROM test1, test2
WHERE test1.id1=test2.id1
/
INSERT INTO test1 VALUES (1);
INSERT INTO test2 VALUES (2,1);
COMMIT;
mlog$_test1 and mlog$_test2 both have a single entry.
exec DBMS_SNAPSHOT.REFRESH('TEST1_TEST2','F');
do a fast refresh
So far this seems OK. All that is needed to populate the materialized view
are the mlogs. After the refresh completes successfully, the two mlog$
tables are empty, as expected.
Now try
INSERT INTO test2 VALUES (3,1);
COMMIT;
mlog$_test2 has one row, mlog$_test1 is empty.
When I refresh test1_test2, a row is added because of my entry into test2.
The test1 data, however, is no longer in mlog$_test1, but in the base table
test1. The fast refresh must access the base tables. How it does so is
dependent on available indexes, statistics, table size, ...
To confirm this, I ran my test with 10046 trace on, and did three sets of
inserts/fast refresh
case#1
INSERT INTO test1 VALUES (1);
INSERT INTO test2 VALUES (2,1);
exec DBMS_SNAPSHOT.REFRESH('TEST1_TEST2','F');
The trace file had two different INSERT INTO test1_test2 statements. It was
actually formed, by Oracle, with various hints and a nested subquery. The
main point is that one of the inserts was driven by MLOG$_TEST2 and accessed
test1 (by index unique scan in this case), while the other insert was driven
by MLOG$_TEST1 and accessed base table test2 (fts/hash join).
case#2
INSERT INTO test2 values (3,1);
exec DBMS_SNAPSHOT.REFRESH('TEST1_TEST2','F');
The trace file had a single INSERT INTO test1_test2. It was driven by
MLOG$_TEST2 and accessed test1 with index unique scan.
case#3
INSERT INTO test1 VALUES (2);
exec DBMS_SNAPSHOT.REFRESH('TEST1_TEST2','F');
The trace file had a single INSERT INTO test1_test2. It was driven by
MLOG$_TEST1 and accessed test2 with fts/hash join.
I am still looking through my trace files when I have free time (ha!) to see
if there is any other good stuff. For example, the explain plans for the
INSERT INTO test1_test2 inlude a view VW_NSO_1 which I can't find. No clue
what that is.
Hope this helps someone.
Henry
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Henry Poras
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Re: RE: * Sr. Oracle DBA with 8i and 9i experience needed..
noones hiring H1-Bs. there are so many DBAs out there who were H1-Bs in the past and are now permanent residents or US citizens that they dont need to anymore. there are typical multiple qualified applicants for every job these days. Many of which are over-qualified. From: Meng, Dennis [EMAIL PROTECTED] Date: 2003/07/16 Wed PM 12:04:36 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: * Sr. Oracle DBA with 8i and 9i experience needed.. While the statement itself strikes me as blunt, I don't think it is discriminatory in this case. Because of the availability of a large number of qualified DBAs, companies don't want to go through the hassle of providing sponsorship these days. The 'No H-1B' clause is to filter out candidates with low marketability, just like the statments about job history and third parties. Its a reflection of current market condition, thats all. Dennis -Original Message- Sent: Wednesday, July 16, 2003 10:25 AM To: Multiple recipients of list ORACLE-L and they had NO H-1B candidates please. What a discrimination... -Original Message- Sent: Wednesday, July 16, 2003 4:04 PM To: Multiple recipients of list ORACLE-L Jared, can we get orastaff banned from the list? I know people need jobs but Orastaff is a notorious spammer. I get spammed from these guys through my home email. From: OraStaff [EMAIL PROTECTED] Date: 2003/07/16 Wed AM 10:54:27 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: * Sr. Oracle DBA with 8i and 9i experience needed.. Minneapolis, Minnesota company has a great opportunity available for a Sr. level Oracle DBA to join their IT staff. The selected candidate must be highly skilled in solving extremely complex and very critical customer issues. With preferably over 10 years experience in a large-scale multi-network open-systems environment, the candidate anticipates and plans for reliability, availability, and serviceability in the design, development and implementation of Oracle 8i and 9i solutions. The candidate will be recognized as a technical authority in the design, analysis, implementation and integration of large-scale database management systems. Candidates local to the Minneapolis area are preferred, but any candidate who meets the qualifications for the position will be considered. Base Salary is in the 85-100K range plus bonus. PLEASE Do Not send your resume for this position UNLESS you have the skills outlined below for this position. Please Do Not send your resume unless you have a stable work history. Candidates whose work history includes frequent job changes connot be considered. This is a full time staff position so no sub-contractors or third parties please. NO H-1B candidates please. *MUST meet these requirements: -BS degree in CS or related field. -8-10 years experience in a large-scale multi-network open-systems environment. -Very solid Oracle DBA experience..including 8i and 9i. -Proficient at capacity monitoring and management capabilities, preferably an expert knowledge of Enterprise Manager 9i (OEM), and STATSPACK. -Experience performing Oracle installations, upgrades, and supporting Oracle utilities and services in a variety of operating systems (Solaris, NT, Linux) is required. -Migration and upgrade experience is essential. -Expert knowledge of on-line back-up/recovery procedures with snapshotting a plus. -Proficiency with RMAN is essential. -Ability to work with engineering staff to configure SAN storage for optimal Oracle performance. -Expert knowledge of UNIX scripting including CRON Jobs, Oracle Stored Procedures, Triggers, Packages, Real Application Clusters (RAC). -Performance Tuning and Performance management skills are required, SQL*Plus, PL/SQL, SQL*Loader, SQL, and UNIX. -The applicant must have in-depth experience with ER diagramming, data modeling tools, (erWIN preferred) normalization, de-normalization, database programming and design, query optimization, index optimization, use of hints. Optimal setup of dblink, views, and use of Oracle gateway is required. Must understand how to design and tune an Oracle database to optimize performance for potentially thousands of concurrent, browser-based users together with ETL processes. -Excellent written and verbal communications skills with the ability to effectively communicate technical and business problems/issues in a non-technical manner, strong problem resolution, analysis, and customer service skills are required. -Ability to manage multiple tasks with shifting priorities is a necessity. -Ability to work within a team environment and communicate effectively with other team members is required. -Proven mentoring skills to build the
RE: Interview Questions for a Unix Solaris System Admin
Yeah, wellummm...yeah, okay - that was dumb of me. Here they are: 1) What is an inode? Answer: An inode is an on-disk data structure that contains information about a file. Useful things it includes are size, modification time, and number of links that point to it (among other things) Bonus: What is not included in an inode? Answer: The file name. That comes from the referencing directory entry. 2) What is priority paging and how does it work? Answer (short version): Priority paging is a workaround for an irritating VM problem on Solaris 2.6 (and 7? memory escapes me at the moment) where buffered filesystem data was considered equally valued as application memory, and so large amounts of buffered filesystem i/o could actually cause applications to be swapped out. Priority paging, enabled in the /etc/system file, modifies the paging algorithm to reduce the effects of that. It doesn't come by default in solaris 2.6 - you need to install a later kernel patch for it (105181-21? maybe? bueller?) 3)What does sr stand for in vmstat output? Answer: Scan Rate - how often the kernel is sweeping through memory space looking for pages that can be marked inactive. It is not a problem necessarily, but rather an indication of memory pressure. 4) how would I configure the gigabit ethernet interface to force it to be full duplex? Answer: ndd /dev/ge and there's like four parameters you have to set, plus turning the autoneg_cap off. 5) How does raid-5 work? Answer: According to BAARF, poorly. Raid-4? Answer: dedicated parity disk Raid-3? Answer: dedicated parity disk w/ synchronized spindles 6) Difference between passwd and shadow files? Answer: the passwd has a x where the crypted password hash would be, while the hash goes in the shadow file. That's to prevent brute-force space searches for passwords by non-root users. The side effect, though, is that now applications that authenticate users need to be setuid, which opens up other secuity holes. The moral? You can't win. 7) What's the difference between rdsk and dsk? Answer: rdsk is raw, which has two implications - one, its a character device and two, it bypasses the system buffer cache. Bonus: difference between block and character? Answer: character devices take input one character at a time, while block devices take a quantity of data. The system calls for accessing said data also differ, but its too much to write now. 8) How do journaling filesystems work? Answer: by creating a journal, or intent log, about metadata changes that are going to occur to the filesystem. When a crash occurs, the journal is replayed. 9) What's the difference between ssh and telnet? Why is one preferable over the other? Answer: ssh is encrypted, which protects not just against people sniffing your traffic, but it prevents malicious session hijacking as well. There's no justification for telnet anymore - at the point when a cisco router can run ssh, so can your servers. 10) What's the difference between the e4000 and e4500, 6000 and 6500, etc.? Answer: the backplane (and hence, processor) speed. the eX500 series runs at a 100 MHz on the backplane, while the eX000 runs at 83? (not sure). The one exception is the e6500, which runs at 90 MHz normally due to its increased centerplane length. 11) What happens on an E6500 when I add boards in the bottom two slots? Answer: the centerplane steps down again from 90 MHz to 83, making it the same speed as an E6000 at that point. The problem is the length of the centerplane and electrical latencystupid speed of light. 12) On an Sbus e-class I/O tray, what performance considerations do I have to keep in mind when I'm installing Sbus cards? Answer: even though there are three sbus slots in a Sun I/O tray, there are only two controllers. Slot 0 is its own sbus controller, and then slots 1 and 2 share one. So, distribute your heavy vs. low i/o cards accordingly. 13) Why is NIS bad? Answer: no encryption, no strong authentication, no non-repudiation - basically completely devoid of any of the major AAA (Authorization, Authentication, and Accounting) principles of security systems. 14) What's the diff between TCP and UDP? Answer: tcp is connection-oriented, has all sorts of crafty algorithms to improve performance. UDP has none of those things. 15) How does DNS work? Answer: tree-based directory infrastructure, concepts of recursion and authoritative delegation. Too much to write in this email. Bonus: Is DNS TCP or UDP? Answer: Both. DNS requests and responses smaller than 512 bytes are UDP. If for some reason a request results in a 512 byte response, the server sends back a UDP packet with the TC (truncate) bit sent and the client retries using TCP. Also, zone transfers are always TCP. Bleh. There. My secrets are revealed. Good thing I don't have to deal with Solaris much anymore. Thanks, Matt -- Matthew Zito GridApp Systems Email: [EMAIL PROTECTED] Cell: 646-220-3551 Phone: 212-358-8211 x 359
Re: H1-B (was: * Sr. Oracle DBA with 8i and 9i experience needed..)
Boivin, Patrice J wrote: Why would the H1-B cost the employer money? Usually if you want to travel and get a visa you can pay a small fee at the local embassy or consultate and that's it. Work visas may be different, I don't know Do U.S. employers pay H1-B visa employees' health benefits? Just curious, I have never worked in the U.S.. I am enjoying the 32 degree Celcius (96 degree Farenheit) weather here in Canada (was 32 degrees a couple of weeks ago anyway). : ) I do see news items sometimes talking about H1-B VISA staff vs. American staff competing for jobs. Usually when there is a recession. During boom times employers lobby the Feds to increase the H1-B VISA quotas. Patrice. This is my take on it from experience I've had. There is a visa fee that the sponsor pays - for us, as a non-profit, it is $130 if we don't mind waiting for up to four months or $1130 with expedited processing - the fees are higher for profit-making enterprises.That's really insignificant for the most part. But, there is the process itself which involves a fair amount of time and paperwork - you need to be prepared for that and if you have no experience it will take significantly more of your time or you'll end up hiring an attorney to take care of the application. All this and the visa is not guaranteed to be issued; if it isn't, you'll likely end up paying more attorney fees if you want to appeal the decision. There is also a cap on the number of visa's that are issued annually, but I don't really know if that is ever reached. If all goes well, and the visa comes through, you also then need to keep work logs (not sure if you need to file them) and, from what I understand, if there are changes in employment status during the term of the visa - like assigning the person to another job, you have to get approval from the government. Glenn -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Glenn Stauffer INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: RAC or Oracle Fail Safe
Hi! RAC - One database, two (or more) instances servicing it concurrently. If one node crashes, second one starts recovering, your uncommitted transactions and session state variables (package variables) on failed instance are lost. FailSafe - One database, one instance servicing it at any time, in event of failure you can start up instance on another node that will mount, recover and open the database. With RAC you can have some kind of transparent failover which is able to reexecute your queries on survived instance, but AFAIK for uncommitted transaction survivability your app has to be coded to support it. Also, with RAC you may scale your system up to support more users in some cases. RAC is additional $20k per CPU, FailSafe comes with EE, I believe. Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, July 16, 2003 7:44 PM Hello all, We have setup a Microsoft Cluster Server (MSCS) cluster, with two nodes, using W2K, and now are in the process of deploying Oracle 9i on it. For the purpose of high availability (HA), we are deliberating on setting up either RAC or Oracle Fail Safe. The confusion is over the fact that if we get HA with oracle Fail Safe, i.e. if one node is down due to any problem, then the other takes over, then can we do without RAC? Which of these two is more transparent to the user, i.e. which will take less time to shift the load from one node (server) to the other node? Can any one explain the benefits of using RAC over Oracle Fail Safe, or vice versa. Regards, Hussain DBA SKMCHRC -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hussain Ahmed Qadri INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: H1-B (was: * Sr. Oracle DBA with 8i and 9i experience needed..)
you have to spend money to hire someone with an H1-B visa, as you are basically sponsoring them for citizenship. You have to prove that you cannot find an American citizen who can fill that job etc etc. --- Boivin, Patrice J [EMAIL PROTECTED] wrote: Why would the H1-B cost the employer money? Usually if you want to travel and get a visa you can pay a small fee at the local embassy or consultate and that's it. Work visas may be different, I don't know Do U.S. employers pay H1-B visa employees' health benefits? Just curious, I have never worked in the U.S.. I am enjoying the 32 degree Celcius (96 degree Farenheit) weather here in Canada (was 32 degrees a couple of weeks ago anyway). : ) I do see news items sometimes talking about H1-B VISA staff vs. American staff competing for jobs. Usually when there is a recession. During boom times employers lobby the Feds to increase the H1-B VISA quotas. Patrice. -Original Message- Sent: Wednesday, July 16, 2003 12:55 PM To: Multiple recipients of list ORACLE-L Regis, that's not discrimination as it is defined in the US. it is a business decision not to spend money to hire someone to work for you. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Wednesday, July 16, 2003 11:25 AM To: Multiple recipients of list ORACLE-L and they had NO H-1B candidates please. What a discrimination... -Original Message- Sent: Wednesday, July 16, 2003 4:04 PM To: Multiple recipients of list ORACLE-L Jared, can we get orastaff banned from the list? I know people need jobs but Orastaff is a notorious spammer. I get spammed from these guys through my home email. From: OraStaff [EMAIL PROTECTED] Date: 2003/07/16 Wed AM 10:54:27 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: * Sr. Oracle DBA with 8i and 9i experience needed.. Minneapolis, Minnesota company has a great opportunity available for a Sr. level Oracle DBA to join their IT staff. The selected candidate must be highly skilled in solving extremely complex and very critical customer issues. With preferably over 10 years experience in a large-scale multi-network open-systems environment, the candidate anticipates and plans for reliability, availability, and serviceability in the design, development and implementation of Oracle 8i and 9i solutions. The candidate will be recognized as a technical authority in the design, analysis, implementation and integration of large-scale database management systems. Candidates local to the Minneapolis area are preferred, but any candidate who meets the qualifications for the position will be considered. Base Salary is in the 85-100K range plus bonus. PLEASE Do Not send your resume for this position UNLESS you have the skills outlined below for this position. Please Do Not send your resume unless you have a stable work history. Candidates whose work history includes frequent job changes connot be considered. This is a full time staff position so no sub-contractors or third parties please. NO H-1B candidates please. *MUST meet these requirements: -BS degree in CS or related field. -8-10 years experience in a large-scale multi-network open-systems environment. -Very solid Oracle DBA experience..including 8i and 9i. -Proficient at capacity monitoring and management capabilities, preferably an expert knowledge of Enterprise Manager 9i (OEM), and STATSPACK. -Experience performing Oracle installations, upgrades, and supporting Oracle utilities and services in a variety of operating systems (Solaris, NT, Linux) is required. -Migration and upgrade experience is essential. -Expert knowledge of on-line back-up/recovery procedures with snapshotting a plus. -Proficiency with RMAN is essential. -Ability to work with engineering staff to configure SAN storage for optimal Oracle performance. -Expert knowledge of UNIX scripting including CRON Jobs, Oracle Stored Procedures, Triggers, Packages, Real Application Clusters (RAC). -Performance Tuning and Performance management skills are required, SQL*Plus, PL/SQL, SQL*Loader, SQL, and UNIX. -The applicant must have in-depth experience with ER diagramming, data modeling tools, (erWIN preferred) normalization, de-normalization, database programming and design, query optimization, index optimization, use of hints. Optimal setup of dblink, views, and use of Oracle gateway is required. Must understand how to design and tune an Oracle database to optimize performance for potentially thousands of concurrent, browser-based users together with ETL processes. -Excellent written and verbal communications skills with the ability to effectively communicate technical and business problems/issues
Re: RMAN SQL Backtrack
Title: Message
Wow! Heady!!
It's mighty nice of you to include my name in this
illustrious list, Mladen; but I don't considermyself tobe in the
same league :)Better yet, count yourselfin there.
Talking about the business at hand - you are
absolutely right; one of the "myths" (of the several) is that RMAN is free. It
is, as long as you don't put it on tape. Once you bring tape to the picture, you
are talking money, sometimes big money (as in Tivoli), sometimes small (as in
BrightStor). However, the solution to usedisk could still be relevant and
applicable in some cases, especially in small companies.
Besides the Freeman book, I would also suggest
another one - Oracle RMAN Pocket Reference by Darl Kuhn and Scott Schulze, ISBN
0-596-00233-5. It predates the Freeman book and I learned my ropes from it. It's
a pocket reference; but it's truly one of those things where size belies the
content.
Learning curve could be formidable. Remember you
need to learn a new "language", and it is arcane. When youventure into
territories of tuning the tape buffers, etc, the process could be quite
involved. I just finished setting up and tuning a RMAN setup for a 2 TB database
using IBM Tivoli Storage Manager agent and the details of the process using the
IBM Red Books was nightmarish!
Regards,
Arup Nanda
- Original Message -
From:
Gogala, Mladen
To: Multiple recipients of list ORACLE-L
Sent: Wednesday, July 16, 2003 11:39
AM
Subject: RE: RMAN SQL
Backtrack
I
don't haveany experience with SQL*Backtrack and I do have some
experience
with
RMAN. Here are my comments:
a)
RMAN is reliable. Once you write the backup scripts, they are executed by
operations
and there no surprises. In order
to rely on those scripts, one needs to test them,
especially
the recovery
part.
b)
RMAN needs a 3rd party backup software to run. Things like OmniBackup, Tivoli,
Legato or
SyncSort can be rather expensive.
RMAN doesn't write to tapes itself. RMAN delegates a
backup software contacted through
the routines from libobk.so (or libobk.dll or libobk.sl)
to
do its writing. To get the
"libobk.so" from you backup software vendor of choice, you generally
have to write a check. That means
that RMAN is NOT free.
c)
Before version 9, RMAN was arcane and hard to learn. Thanks to Robert Freeman,
it is no
longer so. You can learn how to
configure and use RMAN and you can find a decent book
to learn RMAN from. It's not very
hard and it's fairly logical. One reading of the books suffices
for a good general
understanding.
d)
Quality of the software: RMAN leaves a lot to be desired. Its biggest drawback
is the fact that
it doesn't do any coordination
with the underlying backup catalog. In other words, you can
happily
declare backup obsolete in RMAN
and Legato will not know anything about it and vice versa.
You can even delete backup in
Legato and reuse the tape while RMAN knows nothing about
it.
On the other hand, RMAN, in
contrast to all other methods, does not put tablespaces into
the
backup mode, thus generating
floods of redo archives. RMAN doesn't backup data blocks that
have never been used
("behind the watermark blocks"), which is great if you have a fresh
new
datafile which was added to
the tablespace just in case something might run out of
space.
e) Personnel. Despite the certification
process, it is not always easy to find a trained personnel
which knows how to use it
and how to recover the database. I consider the ability to
recover
the database a basis for
someone to call himself/herself a DBA. You would be surprised
how
many people which claim that
title do not know how to recover the database. Even smaller number
knows how to use
RMAN.
f) I would suggest Jared Still, Cary
Millsap, Rachel Carmichael, Jonathan Lewis, Wolfgang Breitling,
Steve Adams, Gaja V., Arup Nanda,
Kirti Deshpandeand Anjo Kolk to start the Oracle
List certification
process. I would trust
that onemore then the OCP. I apologize to anyone who I
might have forgotten.
Mladen Gogala Oracle DBA Phone:(203)
459-6855 Email:[EMAIL PROTECTED]
-Original Message-From: Smith, Ron L.
[mailto:[EMAIL PROTECTED]Sent: Wednesday, July 16, 2003 10:59
AMTo: Multiple recipients of list ORACLE-LSubject:
RMAN SQL Backtrack
We have been
using SQL Backtrack for backup and recovery forabout 6 years
now. We are being pressured to start using RMAN because it is
free. Makes sense but I am wondering about reliability, complexity,
learning curve, etc...
Has anyone had
experience with both products or anyone new to RMAN that can give me an idea
of what to expect?
Thanks!
Ron
If you are not the intended
Damagement
Does anyone here have the original Dilber comic page that introduced the term damagment? I'd appreciate if someone sent it to me. Mladen Gogala Oracle DBA Phone:(203) 459-6855 Email:[EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: H1-B (was: * Sr. Oracle DBA with 8i and 9i experience needed..)
Not true.. Rachel with due respect.. -Original Message- Rachel Carmichael Sent: Wednesday, July 16, 2003 12:15 PM To: Multiple recipients of list ORACLE-L you have to spend money to hire someone with an H1-B visa, as you are basically sponsoring them for citizenship. You have to prove that you cannot find an American citizen who can fill that job etc etc. --- Boivin, Patrice J [EMAIL PROTECTED] wrote: Why would the H1-B cost the employer money? Usually if you want to travel and get a visa you can pay a small fee at the local embassy or consultate and that's it. Work visas may be different, I don't know Do U.S. employers pay H1-B visa employees' health benefits? Just curious, I have never worked in the U.S.. I am enjoying the 32 degree Celcius (96 degree Farenheit) weather here in Canada (was 32 degrees a couple of weeks ago anyway). : ) I do see news items sometimes talking about H1-B VISA staff vs. American staff competing for jobs. Usually when there is a recession. During boom times employers lobby the Feds to increase the H1-B VISA quotas. Patrice. -Original Message- Sent: Wednesday, July 16, 2003 12:55 PM To: Multiple recipients of list ORACLE-L Regis, that's not discrimination as it is defined in the US. it is a business decision not to spend money to hire someone to work for you. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Wednesday, July 16, 2003 11:25 AM To: Multiple recipients of list ORACLE-L and they had NO H-1B candidates please. What a discrimination... -Original Message- Sent: Wednesday, July 16, 2003 4:04 PM To: Multiple recipients of list ORACLE-L Jared, can we get orastaff banned from the list? I know people need jobs but Orastaff is a notorious spammer. I get spammed from these guys through my home email. From: OraStaff [EMAIL PROTECTED] Date: 2003/07/16 Wed AM 10:54:27 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: * Sr. Oracle DBA with 8i and 9i experience needed.. Minneapolis, Minnesota company has a great opportunity available for a Sr. level Oracle DBA to join their IT staff. The selected candidate must be highly skilled in solving extremely complex and very critical customer issues. With preferably over 10 years experience in a large-scale multi-network open-systems environment, the candidate anticipates and plans for reliability, availability, and serviceability in the design, development and implementation of Oracle 8i and 9i solutions. The candidate will be recognized as a technical authority in the design, analysis, implementation and integration of large-scale database management systems. Candidates local to the Minneapolis area are preferred, but any candidate who meets the qualifications for the position will be considered. Base Salary is in the 85-100K range plus bonus. PLEASE Do Not send your resume for this position UNLESS you have the skills outlined below for this position. Please Do Not send your resume unless you have a stable work history. Candidates whose work history includes frequent job changes connot be considered. This is a full time staff position so no sub-contractors or third parties please. NO H-1B candidates please. *MUST meet these requirements: -BS degree in CS or related field. -8-10 years experience in a large-scale multi-network open-systems environment. -Very solid Oracle DBA experience..including 8i and 9i. -Proficient at capacity monitoring and management capabilities, preferably an expert knowledge of Enterprise Manager 9i (OEM), and STATSPACK. -Experience performing Oracle installations, upgrades, and supporting Oracle utilities and services in a variety of operating systems (Solaris, NT, Linux) is required. -Migration and upgrade experience is essential. -Expert knowledge of on-line back-up/recovery procedures with snapshotting a plus. -Proficiency with RMAN is essential. -Ability to work with engineering staff to configure SAN storage for optimal Oracle performance. -Expert knowledge of UNIX scripting including CRON Jobs, Oracle Stored Procedures, Triggers, Packages, Real Application Clusters (RAC). -Performance Tuning and Performance management skills are required, SQL*Plus, PL/SQL, SQL*Loader, SQL, and UNIX. -The applicant must have in-depth experience with ER diagramming, data modeling tools, (erWIN preferred) normalization, de-normalization, database programming and design, query optimization, index optimization, use of hints. Optimal setup of dblink, views, and use of Oracle gateway is required. Must understand how to design and tune an Oracle database to optimize performance for potentially thousands of concurrent, browser-based users together with ETL
RE: are fast refreshes really fast?
Title: RE: are fast refreshes really fast?
vw_nso_1 is probably an inline view look for statements in the trace file ... something that has inline views ..
Thanks for this analysis ...
Raj
Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email are strictly personal.
QOTD: Any clod can have facts, having an opinion is an art !
-Original Message-
From: Henry Poras [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 16, 2003 1:29 PM
To: Multiple recipients of list ORACLE-L
Subject: are fast refreshes really fast?
I've been working with Materialized Views and fast refreshes lately. I
finally stopped to think about what is going on. Amazing what happens when I
stop to think. When I think of fast refreshes, I assume the materialized
view is refreshed from the MLOG$ tables associated with the base tables
(MLOG$ tables record changes, Insert/Update/Delete, made to the base
tables). I just realized that this isn't necessarily so. A fast refresh can
do a full table scan (or index scan, ...) on base tables. Pretty
straightforward, I just never stopped to think. I guess this means that some
fast refreshes can take quite a while (the pause that refreshes?).
Here is the deal. If the materialized view is based on a join there is no
choice but to access the base table(s). A simple example:
CREATE TABLE test1 (id1 number);
CREATE TABLE test2 (id2 number
id1 number);
CREATE MATERIALIZED VIEW LOG on test1
WITH ROWID;
this creates mlog$_test1
there are some problems with join fast refreshes using Primary Keys
CREATE MATERIALIZED VIEW LOG on test2
WITH ROWID;
this creates mlog$_test2
CREATE MATERIALIZED VIEW test1_test2
WITH ROWID
AS
SELECT test1.rowid t1_rowid, test2.rowid t2_rowid, test1.id1, test2.id2
FROM test1, test2
WHERE test1.id1=test2.id1
/
INSERT INTO test1 VALUES (1);
INSERT INTO test2 VALUES (2,1);
COMMIT;
mlog$_test1 and mlog$_test2 both have a single entry.
exec DBMS_SNAPSHOT.REFRESH('TEST1_TEST2','F');
do a fast refresh
So far this seems OK. All that is needed to populate the materialized view
are the mlogs. After the refresh completes successfully, the two mlog$
tables are empty, as expected.
Now try
INSERT INTO test2 VALUES (3,1);
COMMIT;
mlog$_test2 has one row, mlog$_test1 is empty.
When I refresh test1_test2, a row is added because of my entry into test2.
The test1 data, however, is no longer in mlog$_test1, but in the base table
test1. The fast refresh must access the base tables. How it does so is
dependent on available indexes, statistics, table size, ...
To confirm this, I ran my test with 10046 trace on, and did three sets of
inserts/fast refresh
case#1
INSERT INTO test1 VALUES (1);
INSERT INTO test2 VALUES (2,1);
exec DBMS_SNAPSHOT.REFRESH('TEST1_TEST2','F');
The trace file had two different INSERT INTO test1_test2 statements. It was
actually formed, by Oracle, with various hints and a nested subquery. The
main point is that one of the inserts was driven by MLOG$_TEST2 and accessed
test1 (by index unique scan in this case), while the other insert was driven
by MLOG$_TEST1 and accessed base table test2 (fts/hash join).
case#2
INSERT INTO test2 values (3,1);
exec DBMS_SNAPSHOT.REFRESH('TEST1_TEST2','F');
The trace file had a single INSERT INTO test1_test2. It was driven by
MLOG$_TEST2 and accessed test1 with index unique scan.
case#3
INSERT INTO test1 VALUES (2);
exec DBMS_SNAPSHOT.REFRESH('TEST1_TEST2','F');
The trace file had a single INSERT INTO test1_test2. It was driven by
MLOG$_TEST1 and accessed test2 with fts/hash join.
I am still looking through my trace files when I have free time (ha!) to see
if there is any other good stuff. For example, the explain plans for the
INSERT INTO test1_test2 inlude a view VW_NSO_1 which I can't find. No clue
what that is.
Hope this helps someone.
Henry
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Henry Poras
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
This e-mail
message is confidential, intended only for the named recipient(s) above and may
contain information that is privileged, attorney work product or exempt from
disclosure under applicable law. If you have received this message in error, or are
not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000
RE: enterprise manager
Martin, I am wondering if the OMS is running at all... oemctl status oms on UNIX or check the services applet if you are in Windows. Patrice. -Original Message- Sent: Wednesday, July 16, 2003 1:20 PM To: Multiple recipients of list ORACLE-L the problem is you're trying to use enterprise mangler :P -Original Message- Sent: Wednesday, July 16, 2003 10:50 AM To: Multiple recipients of list ORACLE-L Check: drive:\ORACLE_HOME\sysman\log review the oms.log file... and send the details... HTH JL --- Ruth Gramolini [EMAIL PROTECTED] wrote: Is it an 8.0.x or 8i database? What version of OEM are you running? We need more info to be able to help you. Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, July 16, 2003 6:19 AM hi i run ora8 on w2000 server. my problem is i can ping my database mydb without problems i can login with sqlplus as sys and it works fine but if i start the enterprise manager console and try to login as sys a error occours and means please check the management server status and settings. as managementserver i select mydb. what ican be the problem? thx martin -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: RMAN SQL Backtrack
Title: Message
If you have to work on the cheap, you can put the
backups to tape and then copy them to tape using the OS backup software.
It isn't elegant, but it works!
Ruth
- Original Message -
From:
Arup Nanda
To: Multiple recipients of list ORACLE-L
Sent: Wednesday, July 16, 2003 1:24
PM
Subject: Re: RMAN SQL
Backtrack
Wow! Heady!!
It's mighty nice of you to include my name in
this illustrious list, Mladen; but I don't considermyself tobe in
the same league :)Better yet, count yourselfin there.
Talking about the business at hand - you are
absolutely right; one of the "myths" (of the several) is that RMAN is free. It
is, as long as you don't put it on tape. Once you bring tape to the picture,
you are talking money, sometimes big money (as in Tivoli), sometimes small (as
in BrightStor). However, the solution to usedisk could still be relevant and
applicable in some cases, especially in small companies.
Besides the Freeman book, I would also suggest
another one - Oracle RMAN Pocket Reference by Darl Kuhn and Scott Schulze,
ISBN 0-596-00233-5. It predates the Freeman book and I learned my ropes from
it. It's a pocket reference; but it's truly one of those things where size
belies the content.
Learning curve could be formidable. Remember you
need to learn a new "language", and it is arcane. When youventure into
territories of tuning the tape buffers, etc, the process could be quite
involved. I just finished setting up and tuning a RMAN setup for a 2 TB
database using IBM Tivoli Storage Manager agent and the details of the process
using the IBM Red Books was nightmarish!
Regards,
Arup Nanda
- Original Message -
From:
Gogala, Mladen
To: Multiple recipients of list ORACLE-L
Sent: Wednesday, July 16, 2003 11:39
AM
Subject: RE: RMAN SQL
Backtrack
I
don't haveany experience with SQL*Backtrack and I do have some
experience
with RMAN. Here are my
comments:
a)
RMAN is reliable. Once you write the backup scripts, they are executed by
operations
and there no surprises. In order
to rely on those scripts, one needs to test them,
especially
the recovery
part.
b)
RMAN needs a 3rd party backup software to run. Things like OmniBackup,
Tivoli, Legato or
SyncSort can be rather
expensive. RMAN doesn't write to tapes itself. RMAN delegates
a
backup software contacted
through the routines from libobk.so (or libobk.dll or libobk.sl)
to
do its writing. To get the
"libobk.so" from you backup software vendor of choice, you generally
have to write a check. That
means that RMAN is NOT free.
c)
Before version 9, RMAN was arcane and hard to learn. Thanks to Robert
Freeman, it is no
longer so. You can learn how to
configure and use RMAN and you can find a decent book
to learn RMAN from. It's not
very hard and it's fairly logical. One reading of the books suffices
for a good general
understanding.
d)
Quality of the software: RMAN leaves a lot to be desired. Its biggest
drawback is the fact that
it doesn't do any coordination
with the underlying backup catalog. In other words, you can
happily
declare backup obsolete in RMAN
and Legato will not know anything about it and vice
versa.
You can even delete backup in
Legato and reuse the tape while RMAN knows nothing about
it.
On the other hand, RMAN,
in contrast to all other methods, does not put tablespaces into
the
backup mode, thus
generating floods of redo archives. RMAN doesn't backup data blocks that
have never been used
("behind the watermark blocks"), which is great if you have a fresh
new
datafile which was added
to the tablespace just in case something might run out of
space.
e) Personnel. Despite the certification
process, it is not always easy to find a trained
personnel
which knows how to use it
and how to recover the database. I consider the ability to
recover
the database a basis for
someone to call himself/herself a DBA. You would be surprised
how
many people which claim
that title do not know how to recover the database. Even smaller number
knows how to use
RMAN.
f) I would suggest Jared Still, Cary
Millsap, Rachel Carmichael, Jonathan Lewis, Wolfgang Breitling,
Steve Adams, Gaja V., Arup
Nanda, Kirti Deshpandeand Anjo Kolk to start the Oracle
List certification
process. I would trust
that onemore then the OCP. I apologize to anyone who
I might have forgotten.
Mladen Gogala Oracle DBA Phone:(203)
459-6855 Email:[EMAIL PROTECTED]
-Original
RE: Interview Questions for a Unix Solaris System Admin
Well, the purpose of the original post was to list a set of questions that, while admittedly academic in that they involve facts, cross 1) a broad cross-section of what a sysadmin might be asked to do and 2) range from easy to difficult. The point is not to know the answer to every question, though if they do, bully for them. The point is for what they don't know, can they use related knowledge they do have to answer the question? I was always far happier when someone said something like, You know, I'm not sure what isn't stored in an inode, but because symbolic links can have their own modification time, I'm going to guess its the modification time rather than I don't know. That is a wrong answer, but the fact that he was able to logic out what is a reasonable conclusion, is the sort of thing I like in people that work for me. It's true, some of the questions are esoterica, but again, its how they answer the question. There's a post I sent that has yet to arrive (in my box anyway) where I answer the questions. For the question about full-duplex, I can't remember the flags you set either - and I'd be fine with anyone who said, You know, I'd man the ge driver and then use ndd to set what I had to. The point is they knew to look up the ge driver and use ndd. Further discussion inline 1) What is an inode? Bonus: What important piece of file information is NOT stored in the inode? Might be better to ask the pros and cons and having many inodes as opposed to few; circumstances when you would not want to go with the default number you get when you create a file system (never happened when I was a sys admin). Very pertinent info snipped You might ask the circumstances under which the admin would AND has used soft links. In the past, I had the unpleasant experience of inheriting servers where the previous admin(s) had made extensive use of soft links resulting in boxes rife with spaghetti file systems. This usually happens because, for one reason or another, a bunch of files need to be moved from one place to another; then instead of fixing whatever uses those files to tell it to go the new location, a soft link to the new location gets created as a quick and dirty solution. These things accumulate, and eventually you have a mess and booby traps ready to blow up. These are equally valid questions, but I have found that by and large, sysadmins might know from reading a book somewhere that you need one inode per file and that hard links and sym links are different, but knowing what an inode is indicates that not only are they aware of all of the above but they can in-depth explain what is happening to the system. 2) What is priority paging and how does it work? (mildly dated, but useful if they claim to have been around for a while) Never heard of it. Sounds like a term for a type of swapping (lazy versus not lazy). Solaris-ism with 2.6 (the original question was for a Solaris admin) 3) What does sr stand for in vmstat output? man vmstat. vmstat Virtual Memory Statistics: (pagesize = 8192) procs memorypages intr cpu r w u act free wire fault cow zero react pin pout in sy cs us sy id 10 1K 49 914K 279K 90K 130G 500M 1G 363 615M2 389 44K 3K 17 13 70 Ummm . got no sr here Apparently you're not on a Solaris system - count yourself lucky. ;) 4) How would I configure the gigabit ethernet interface to force it to be full duplex? I guess if this were a common daily activity, you would want somebody to know how to do this. For most places, you might do this ... o ... maybe once per year ... maybe. I concur - but knowing that you use ndd to get/set network device driver parameters is the real thrust of the question. Asking about gigabit specifically gets into the process. I found that if I asked: How do you get/set network driver parameters in Solaris? The answer I would inevitably get was either I don't know or ndd . Throwing the part in about gigabit makes them think through the whole process, and watching people talk through how they would do something they are unfamiliar with, even in general principles, is very valuable. 5) How does RAID-5 work? Bonus question: how does raid-4 work? Extra-extra bonus question: how does raid-3 work? Most people will know that it involves stripe with parity; but better, I think, to ask about pros and cons of RAID-5 versus 0+1 (or 1+0). Good point. I usually use that as a follow-up question. 6) What's the difference between the passwd and the shadow files? This is OK. I think I would phrase it as: What is the purpose of a shadow file. Answer: It's where the encrypted password is (or can be) stored and is readable only by root. passwd file is world readable. If the encrypted password is visible, it makes it easier to run a cracker against it to
Re: RMAN SQL Backtrack
I'll second what Ruth says about backup to disk then use the OS tape routine to archive off of the diaks. I would keep at least 2 disk backups available on disk. It is faster to perform a restore from a disk based backup than from a sequential tape. Restore on datafile from RMAN - 20 min. mount the OS tapes and search for the backed up datafile - all day. Now if I can get the sysadmin to only backup the RMAN files daily rather than a complete disk image each night. Ron [EMAIL PROTECTED] 07/16/03 02:19PM MessageIf you have to work on the cheap, you can put the backups to tape and then copy them to tape using the OS backup software. It isn't elegant, but it works! Ruth - Original Message - From: Arup Nanda To: Multiple recipients of list ORACLE-L Sent: Wednesday, July 16, 2003 1:24 PM Subject: Re: RMAN SQL Backtrack Wow! Heady!! It's mighty nice of you to include my name in this illustrious list, Mladen; but I don't consider myself to be in the same league :) Better yet, count yourself in there. Talking about the business at hand - you are absolutely right; one of the myths (of the several) is that RMAN is free. It is, as long as you don't put it on tape. Once you bring tape to the picture, you are talking money, sometimes big money (as in Tivoli), sometimes small (as in BrightStor). However, the solution to usedisk could still be relevant and applicable in some cases, especially in small companies. Besides the Freeman book, I would also suggest another one - Oracle RMAN Pocket Reference by Darl Kuhn and Scott Schulze, ISBN 0-596-00233-5. It predates the Freeman book and I learned my ropes from it. It's a pocket reference; but it's truly one of those things where size belies the content. Learning curve could be formidable. Remember you need to learn a new language, and it is arcane. When youventure into territories of tuning the tape buffers, etc, the process could be quite involved. I just finished setting up and tuning a RMAN setup for a 2 TB database using IBM Tivoli Storage Manager agent and the details of the process using the IBM Red Books was nightmarish! Regards, Arup Nanda - Original Message - From: Gogala, Mladen To: Multiple recipients of list ORACLE-L Sent: Wednesday, July 16, 2003 11:39 AM Subject: RE: RMAN SQL Backtrack I don't have any experience with SQL*Backtrack and I do have some experience with RMAN. Here are my comments: a) RMAN is reliable. Once you write the backup scripts, they are executed by operations and there no surprises. In order to rely on those scripts, one needs to test them, especially the recovery part. b) RMAN needs a 3rd party backup software to run. Things like OmniBackup, Tivoli, Legato or SyncSort can be rather expensive. RMAN doesn't write to tapes itself. RMAN delegates a backup software contacted through the routines from libobk.so (or libobk.dll or libobk.sl) to do its writing. To get the libobk.so from you backup software vendor of choice, you generally have to write a check. That means that RMAN is NOT free. c) Before version 9, RMAN was arcane and hard to learn. Thanks to Robert Freeman, it is no longer so. You can learn how to configure and use RMAN and you can find a decent book to learn RMAN from. It's not very hard and it's fairly logical. One reading of the books suffices for a good general understanding. d) Quality of the software: RMAN leaves a lot to be desired. Its biggest drawback is the fact that it doesn't do any coordination with the underlying backup catalog. In other words, you can happily declare backup obsolete in RMAN and Legato will not know anything about it and vice versa. You can even delete backup in Legato and reuse the tape while RMAN knows nothing about it. On the other hand, RMAN, in contrast to all other methods, does not put tablespaces into the backup mode, thus generating floods of redo archives. RMAN doesn't backup data blocks that have never been used (behind the watermark blocks), which is great if you have a fresh new datafile which was added to the tablespace just in case something might run out of space. e) Personnel. Despite the certification process, it is not always easy to find a trained personnel which knows how to use it and how to recover the database. I consider the ability to recover the database a basis for someone to call himself/herself a DBA. You would be surprised how many people which claim that title do not know how to recover the database. Even smaller number knows how to use RMAN. f) I would suggest Jared Still, Cary Millsap, Rachel Carmichael, Jonathan Lewis, Wolfgang Breitling, Steve Adams, Gaja V., Arup Nanda, Kirti Deshpande and Anjo Kolk to start the Oracle List certification process. I
RE: H1-B (was: * Sr. Oracle DBA with 8i and 9i experience needed. .)
Sounds rigid as a system. Thanks for the answer Glenn. Patrice. -Original Message- Sent: Wednesday, July 16, 2003 2:39 PM To: Multiple recipients of list ORACLE-L needed..) Boivin, Patrice J wrote: Why would the H1-B cost the employer money? Usually if you want to travel and get a visa you can pay a small fee at the local embassy or consultate and that's it. Work visas may be different, I don't know Do U.S. employers pay H1-B visa employees' health benefits? Just curious, I have never worked in the U.S.. I am enjoying the 32 degree Celcius (96 degree Farenheit) weather here in Canada (was 32 degrees a couple of weeks ago anyway). : ) I do see news items sometimes talking about H1-B VISA staff vs. American staff competing for jobs. Usually when there is a recession. During boom times employers lobby the Feds to increase the H1-B VISA quotas. Patrice. This is my take on it from experience I've had. There is a visa fee that the sponsor pays - for us, as a non-profit, it is $130 if we don't mind waiting for up to four months or $1130 with expedited processing - the fees are higher for profit-making enterprises.That's really insignificant for the most part. But, there is the process itself which involves a fair amount of time and paperwork - you need to be prepared for that and if you have no experience it will take significantly more of your time or you'll end up hiring an attorney to take care of the application. All this and the visa is not guaranteed to be issued; if it isn't, you'll likely end up paying more attorney fees if you want to appeal the decision. There is also a cap on the number of visa's that are issued annually, but I don't really know if that is ever reached. If all goes well, and the visa comes through, you also then need to keep work logs (not sure if you need to file them) and, from what I understand, if there are changes in employment status during the term of the visa - like assigning the person to another job, you have to get approval from the government. Glenn -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Glenn Stauffer INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: RMAN SQL Backtrack
Title: Message
why not backup to disk and then transfer to tape
.
-ak
- Original Message -
From:
Arup Nanda
To: Multiple recipients of list ORACLE-L
Sent: Wednesday, July 16, 2003 10:24
AM
Subject: Re: RMAN SQL
Backtrack
Wow! Heady!!
It's mighty nice of you to include my name in
this illustrious list, Mladen; but I don't considermyself tobe in
the same league :)Better yet, count yourselfin there.
Talking about the business at hand - you are
absolutely right; one of the "myths" (of the several) is that RMAN is free. It
is, as long as you don't put it on tape. Once you bring tape to the picture,
you are talking money, sometimes big money (as in Tivoli), sometimes small (as
in BrightStor). However, the solution to usedisk could still be relevant and
applicable in some cases, especially in small companies.
Besides the Freeman book, I would also suggest
another one - Oracle RMAN Pocket Reference by Darl Kuhn and Scott Schulze,
ISBN 0-596-00233-5. It predates the Freeman book and I learned my ropes from
it. It's a pocket reference; but it's truly one of those things where size
belies the content.
Learning curve could be formidable. Remember you
need to learn a new "language", and it is arcane. When youventure into
territories of tuning the tape buffers, etc, the process could be quite
involved. I just finished setting up and tuning a RMAN setup for a 2 TB
database using IBM Tivoli Storage Manager agent and the details of the process
using the IBM Red Books was nightmarish!
Regards,
Arup Nanda
- Original Message -
From:
Gogala, Mladen
To: Multiple recipients of list ORACLE-L
Sent: Wednesday, July 16, 2003 11:39
AM
Subject: RE: RMAN SQL
Backtrack
I
don't haveany experience with SQL*Backtrack and I do have some
experience
with RMAN. Here are my
comments:
a)
RMAN is reliable. Once you write the backup scripts, they are executed by
operations
and there no surprises. In order
to rely on those scripts, one needs to test them,
especially
the recovery
part.
b)
RMAN needs a 3rd party backup software to run. Things like OmniBackup,
Tivoli, Legato or
SyncSort can be rather
expensive. RMAN doesn't write to tapes itself. RMAN delegates
a
backup software contacted
through the routines from libobk.so (or libobk.dll or libobk.sl)
to
do its writing. To get the
"libobk.so" from you backup software vendor of choice, you generally
have to write a check. That
means that RMAN is NOT free.
c)
Before version 9, RMAN was arcane and hard to learn. Thanks to Robert
Freeman, it is no
longer so. You can learn how to
configure and use RMAN and you can find a decent book
to learn RMAN from. It's not
very hard and it's fairly logical. One reading of the books suffices
for a good general
understanding.
d)
Quality of the software: RMAN leaves a lot to be desired. Its biggest
drawback is the fact that
it doesn't do any coordination
with the underlying backup catalog. In other words, you can
happily
declare backup obsolete in RMAN
and Legato will not know anything about it and vice
versa.
You can even delete backup in
Legato and reuse the tape while RMAN knows nothing about
it.
On the other hand, RMAN,
in contrast to all other methods, does not put tablespaces into
the
backup mode, thus
generating floods of redo archives. RMAN doesn't backup data blocks that
have never been used
("behind the watermark blocks"), which is great if you have a fresh
new
datafile which was added
to the tablespace just in case something might run out of
space.
e) Personnel. Despite the certification
process, it is not always easy to find a trained
personnel
which knows how to use it
and how to recover the database. I consider the ability to
recover
the database a basis for
someone to call himself/herself a DBA. You would be surprised
how
many people which claim
that title do not know how to recover the database. Even smaller number
knows how to use
RMAN.
f) I would suggest Jared Still, Cary
Millsap, Rachel Carmichael, Jonathan Lewis, Wolfgang Breitling,
Steve Adams, Gaja V., Arup
Nanda, Kirti Deshpandeand Anjo Kolk to start the Oracle
List certification
process. I would trust
that onemore then the OCP. I apologize to anyone who
I might have forgotten.
Mladen Gogala Oracle DBA Phone:(203)
459-6855 Email:[EMAIL PROTECTED]
-Original Message-From: Smith, Ron L.
[mailto:[EMAIL PROTECTED]Sent: Wednesday, July 16, 2003 10:59
RE: H1-B (was: * Sr. Oracle DBA with 8i and 9i experience needed..)
Like most laws there is always a different way to look at it http://www.h1bvisalaw.com/ From: Anjan Thakuria [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: H1-B (was: * Sr. Oracle DBA with 8i and 9i experience needed..) Date: Wed, 16 Jul 2003 10:09:24 -0800 Not true.. Rachel with due respect.. -Original Message- Rachel Carmichael Sent: Wednesday, July 16, 2003 12:15 PM To: Multiple recipients of list ORACLE-L you have to spend money to hire someone with an H1-B visa, as you are basically sponsoring them for citizenship. You have to prove that you cannot find an American citizen who can fill that job etc etc. --- Boivin, Patrice J [EMAIL PROTECTED] wrote: Why would the H1-B cost the employer money? Usually if you want to travel and get a visa you can pay a small fee at the local embassy or consultate and that's it. Work visas may be different, I don't know Do U.S. employers pay H1-B visa employees' health benefits? Just curious, I have never worked in the U.S.. I am enjoying the 32 degree Celcius (96 degree Farenheit) weather here in Canada (was 32 degrees a couple of weeks ago anyway). : ) I do see news items sometimes talking about H1-B VISA staff vs. American staff competing for jobs. Usually when there is a recession. During boom times employers lobby the Feds to increase the H1-B VISA quotas. Patrice. -Original Message- Sent: Wednesday, July 16, 2003 12:55 PM To: Multiple recipients of list ORACLE-L Regis, that's not discrimination as it is defined in the US. it is a business decision not to spend money to hire someone to work for you. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Wednesday, July 16, 2003 11:25 AM To: Multiple recipients of list ORACLE-L and they had NO H-1B candidates please. What a discrimination... -Original Message- Sent: Wednesday, July 16, 2003 4:04 PM To: Multiple recipients of list ORACLE-L Jared, can we get orastaff banned from the list? I know people need jobs but Orastaff is a notorious spammer. I get spammed from these guys through my home email. From: OraStaff [EMAIL PROTECTED] Date: 2003/07/16 Wed AM 10:54:27 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: * Sr. Oracle DBA with 8i and 9i experience needed.. Minneapolis, Minnesota company has a great opportunity available for a Sr. level Oracle DBA to join their IT staff. The selected candidate must be highly skilled in solving extremely complex and very critical customer issues. With preferably over 10 years experience in a large-scale multi-network open-systems environment, the candidate anticipates and plans for reliability, availability, and serviceability in the design, development and implementation of Oracle 8i and 9i solutions. The candidate will be recognized as a technical authority in the design, analysis, implementation and integration of large-scale database management systems. Candidates local to the Minneapolis area are preferred, but any candidate who meets the qualifications for the position will be considered. Base Salary is in the 85-100K range plus bonus. PLEASE Do Not send your resume for this position UNLESS you have the skills outlined below for this position. Please Do Not send your resume unless you have a stable work history. Candidates whose work history includes frequent job changes connot be considered. This is a full time staff position so no sub-contractors or third parties please. NO H-1B candidates please. *MUST meet these requirements: -BS degree in CS or related field. -8-10 years experience in a large-scale multi-network open-systems environment. -Very solid Oracle DBA experience..including 8i and 9i. -Proficient at capacity monitoring and management capabilities, preferably an expert knowledge of Enterprise Manager 9i (OEM), and STATSPACK. -Experience performing Oracle installations, upgrades, and supporting Oracle utilities and services in a variety of operating systems (Solaris, NT, Linux) is required. -Migration and upgrade experience is essential. -Expert knowledge of on-line back-up/recovery procedures with snapshotting a plus. -Proficiency with RMAN is essential. -Ability to work with engineering staff to configure SAN storage for optimal Oracle performance. -Expert knowledge of UNIX scripting including CRON Jobs, Oracle Stored Procedures, Triggers, Packages, Real Application Clusters (RAC). -Performance Tuning and Performance management skills are required, SQL*Plus, PL/SQL, SQL*Loader, SQL, and UNIX. -The applicant must have in-depth experience with ER diagramming, data modeling tools, (erWIN preferred) normalization, de-normalization, database programming and design, query optimization, index
RE: Antw: RE: Insert 8000 Byte into LONG column
Guido, Where are getting the data from - other database tables? Because, you could build a PL/SQL block that contains PL/SQL variables that can hold up to 32k of data. You could build the string in the variable and insert it into the LONG column. Something like: declare str_var varchar2(8000); begin select big_string into str_var from dual; insert into table (long_col) values (str_var); end; / Good Luck! Tom Mercadante Oracle Certified Professional -Original Message- [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 16, 2003 12:25 PM To: Multiple recipients of list ORACLE-L Hi Tom, thanks for trying to help. Unfortunately I have no chance because I've no account with write permissions. So it seems impossible to put the data on the server through ftp. Oh: and (of course!) no UTL_FILE_DIR defined in the init...ora. Any other suggestions? tia, Guido [EMAIL PROTECTED] 16.07.2003 17.34 Uhr Guido, Can you use utl_file for this within a PL/SQL block? Tom Mercadante Oracle Certified Professional -Original Message- [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 16, 2003 9:54 AM To: Multiple recipients of list ORACLE-L Hi dear list members, we run a database 8.1.6.2 I've run into a problem. I've got a table that contains a LONG column (I know, I know). I have to insert a string into it that has a length 8500 Byte. Whenever I issue the insert statement SQL/PLUS throws the error 'ORA-01704: string literal too long'. Does anyone have an idea how I can get the data into the table? Any help (except: change the datatype ;-)) is appreciated. Greetings, Guido -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Guido Konsolke INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Guido Konsolke INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Cary/Others RE: should you seperate indexes from tables in
Based on Cary's paper regarding when to use an index, would there not be value in having index tablespaces with a smaller block size vs tables using a larger block size? American Express made the following annotations on 07/16/2003 10:11:40 AM -- ** This message and any attachments are solely for the intended recipient and may contain confidential or privileged information. If you are not the intended recipient, any disclosure, copying, use, or distribution of the information included in this message and any attachments is prohibited. If you have received this communication in error, please notify us by reply e-mail and immediately and permanently delete this message and any attachments. Thank you. ** == -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tracy Rahmlow INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Find the table's name that using sequences
Title: Message Hi All At first I thought it is easy to find those tables to use sequences but I failed. dba_sequence don't give too much info. Is there any idea? Thanks in advance Mitchell
RE: Damagement
Nope, but this one's pretty good: http://www.ftlcomm.com/ensign/img/DILBERT.gif And there's some here, too... http://www.cps.unizar.es/~spd/dilbert/ Or, try and find it at http://www.dilbert.com Exactly what you didn't ask for. I could be a s/w developer! :) Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA -Original Message- From: Gogala, Mladen [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 16, 2003 12:35 PM To: Multiple recipients of list ORACLE-L Subject: Damagement Does anyone here have the original Dilber comic page that introduced the term damagment? I'd appreciate if someone sent it to me. Mladen Gogala -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Find the table's name that using sequences
no table uses a sequence. And there is no reason (other than sanity checks) to have one sequence per table. SQL code will use the sequence, usually to retrieve a value from the sequence to then insert into or update a column in a table. --- Mitchell [EMAIL PROTECTED] wrote: Hi All At first I thought it is easy to find those tables to use sequences but I failed. dba_sequence don't give too much info. Is there any idea? Thanks in advance Mitchell __ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
