RE: RAC or Oracle Fail Safe

2003-07-17 Thread Hussain Ahmed Qadri
Thank you to all those who replied and who intend to reply to this one :) We are using Dell PE4600 servers. My concern was that I read it somewhere that if one of the node goes down, then the clients have to restart the application to log in again to the database, is that true? And is it any

RE: RAC or Oracle Fail Safe

2003-07-17 Thread RAJESH DAYAL
Title: RE: RAC or Oracle Fail Safe Hi Hussain ! RAC can have Active-Active or Active-Passive combination for two nodes. While OFS can't give you Active-Active combination of two nodes. Basically a resource sharing is not possible in Oracle Fail safe so one resource can be used by only one

Using the 9i version of UTL_HTTP in 8i

2003-07-17 Thread Charu Joshi
Dear all, Database: Oracle 8.1.7.4 Enterprise OS: HP-UX 11 We want to implement a stored proc that would send data to an http:// url using 'POST' method. The UTL_HTTP package in 8i doesn't support the POST method, while that in 9i does. We are now considering two options: 1. Install the 9i

RE: Why are SPFILEs binary anyway? (was RE: How to make SPFILE in sync with INIT.ORA ?)

2003-07-17 Thread Turner, Adrian A SITI-ITPSIE
Roy, I imagine its so that it can only be changed by someone who is validated against the database with the correct permissions. Kind Regards, Adrian -Original Message- Sent: 16 July 2003 23:40 To: Multiple recipients of list ORACLE-L sync with INIT.ORA ?) I can definitely appreciate

RE: Using the 9i version of UTL_HTTP in 8i

2003-07-17 Thread Charu Joshi
Okay, I got the answer to the question - I tried compiling the 9i utl_http package in an 8i test database, and it failed conclusively. Any other options for using the HTTP 'POST' method in 8i? Thanks regards, -Original Message- Sent: Thursday, July 17, 2003 12:04 PM To: [EMAIL

RE: RAC or Oracle Fail Safe

2003-07-17 Thread RAJESH DAYAL
Title: RE: RAC or Oracle Fail Safe Answers in line... -- I also believe that setting up RAC is more complex, That's not totally true, For a DBA it shouldn't matter much, whether he is setting up RAC or OFS. But yes relatively RAC is a bit complex to manage. -- and any change in node

sqlldr questions

2003-07-17 Thread John Dunn
I'm a sqlldr newbie. Platform is Oracle 9.2. My question is...can I prevent sqlldr loading any data if there is even a single bad record, even if it is, for example, the last record? I am using conventional path load. John -- Please see the official ORACLE-L FAQ: http://www.orafaq.net --

How to put both OID and Microsoft Active directory working????

2003-07-17 Thread Paulo Gomes
HI PEOPLE thanks in advance. I finnally got 9ias release 2 installed and working fine in IBM AIX 4.3.3 but now i have one big problem i'm hopping that you can help: How do i put both OID and Microsoft Active directory working I hope there is way of integrating both so that changes

unlocking objects

2003-07-17 Thread Siddharth Haldankar
Title: RE: are fast refreshes really fast? Hi Gurus, One of my object is locked. How do I unlock that object explicitly ? The session is already killed, but still the object appears in locked status. Thanks in advance With Warm Regards Siddharth Haldankar Cisco

RE: Why are SPFILEs binary anyway? (was RE: How to make SPFILE in

2003-07-17 Thread Rachel Carmichael
it's a fake sort of binary -- try editing it with vi and then try opening your database with the spfile... but first make an init.ora copy of it. There is some sort of checksum going on, even though it looks like ASCII --- Jamadagni, Rajendra [EMAIL PROTECTED] wrote: it isn't binary on solaris

Another OCP slant...

2003-07-17 Thread Denham Eva
Hello Folks, I have discovered something *very* disturbing. We have a person(x2) who has earned their MCDBA - Microsoft DBA certifiction. These two don't have any clue, about database issues, when pressed to how they did it, it came out that they used the threads on a website called

RE: Oracle Instances not starting up via services

2003-07-17 Thread Nuala Cullen
Hi Jose, I've tried twice to send you the information but the mailing list has decided that it contains a 'virus signature' and rejects the email. So can you let me know specially what you are looking for and I will send you those values. Thanks, N. :--Original Message- :-From: [EMAIL

RE: enterprise manager

2003-07-17 Thread Boivin, Patrice J
If this is a new installation... Try in the login dialog box: sysman oem_temp (or the pwd you specified for OEM when you installed it, if it prompted you to change the default) [put the fqdn of your OMS Host here] Patrice. -Original Message- [mailto:[EMAIL PROTECTED] Sent: Wednesday,

Re:

2003-07-17 Thread Nuno Souto
- Original Message - help aren't you beyond help? :D 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,

Re: Re: Object Types in PL/SQL

2003-07-17 Thread Nuno Souto
- Original Message - how does the object features improve performance of the jdbc? its fairly common now to have a java or .net(which we are using) and an Oracle backend. When we started to use JDBC, one of the things I noticed was some very unusual network traffic. Certainly more

RE: RAC or Oracle Fail Safe

2003-07-17 Thread Mercadante, Thomas F
One other note is that we have not had to failover due to a Win2K of Oracle problem in 18 months of running failsafe. We have found it to be extremely stable just not scalable froma CPU standpoint. I totally agree with this. I am running FailSafe here also. The *only* failover's I experience is

Re: unlocking objects

2003-07-17 Thread rgaffuri
if the session is in 'KILLED' status it is rolling back the transaction. you have to wait for this to finish. it can take a while. From: Siddharth Haldankar [EMAIL PROTECTED] Date: 2003/07/17 Thu AM 06:24:25 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: unlocking

RE: Another OCP slant...

2003-07-17 Thread Stefick Ronald S Contr ESC/HRIDD
Title: RE: Another OCP slant... No, I sat through thte Oracle Education Classes and studied from the books given in the class. They make for great reference books now as well. -Original Message- From: Denham Eva [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 17, 2003 5:34 AM To:

RE: Another OCP slant...

2003-07-17 Thread April Wells
Title: RE: Another OCP slant... for 8 and 8i, I used the Exam cram books and the Osborne book for 8i.Took all of the 8 OCP tests and the upgradetest in 8 weeks. April Wells Oracle DBA/Oracle Apps DBA Corporate Systems Amarillo Texas You will recognize your own path when you come upon it,

DBMS_REPAIR Package

2003-07-17 Thread Stefick Ronald S Contr ESC/HRIDD
Title: Message Hasanyone ever used DBMS_REPAIR? If so, what do you think of it, does the DB have to be shutdown to run it. Does it really fix any corrupt blocks in the datafiles? We ran DBVerify andfoundseveral corrupt DB files in one of our DB's. TIA, Scott Stefick MILPDS OCP Oracle

Re: sqlldr questions

2003-07-17 Thread Kirtikumar Deshpande
An excellent book for SQL Loader new comers, and experienced users as well, is one by Jonathan Gennick and Sanjay Mishra : Oracle SQL Loader, The definitive Guide, by O'Reilly. Stenphen Andert will agree with me ;) - Kirti --- John Dunn [EMAIL PROTECTED] wrote: I'm a sqlldr newbie.

Re: Re: sqlldr questions

2003-07-17 Thread rgaffuri
i read this last year. correct me if im wrong, but it didnt seem to have much more than was on otn? just explained slightly differently with a slightly more depth. From: Kirtikumar Deshpande [EMAIL PROTECTED] Date: 2003/07/17 Thu AM 09:54:29 EDT To: Multiple recipients of list ORACLE-L

OUI download

2003-07-17 Thread Boivin, Patrice J
Is there another location for downloads? (I don't think there is...) I am looking for a simple package that installs the Oracle Universal Installer, nothing fancy. begin rant I don't understand why they don't have that under Software Downloads, they have one page that lists all the ODBC

faq broke?

2003-07-17 Thread Barbara Baker
Is it just me, or . . . I have not been able to search the faq archives all week (www.orfaq.net). When I find a match and try to open it, I get a message Our apologies. The page you are looking for might have been removed, had its name changed, or is temporarily unavailable Is it just me, or

Re: sqlldr questions

2003-07-17 Thread Don Yu
Please look the following text, which works fine everyday for loading my data into oracle 9.2 database. $ORACLE_HOME/bin/sqlldr USERID=your_username/[EMAIL PROTECTED] control=link-summary.ctl log=link-summary.log $ more link-summary.ctl options (rows=9297500, errors=2, bindsize=100,

RE: DBMS_REPAIR Package

2003-07-17 Thread Stefick Ronald S Contr ESC/HRIDD
Title: Message I dug a little more and found my answer.I found that Oracle uses DBMS_REPAIR just to put a band-aid on the corrupt blocks. It basically identifies the corrupt block and marks it so oracle skips over it like it's not even there. -Original Message-From: Stefick

RE: Why are SPFILEs binary anyway? (was RE: How to make SPFILE in

2003-07-17 Thread Stephen Lee
I wonder if it is something built into the file or something that vi (or whatever editor you are using) does to the file when you save it. I say that because, if you edit the text part of an export file with vi, you get an unusable file. But the text part of an export file can be edited by

RE: Why are SPFILEs binary anyway? (was RE: How to make SPFILE in

2003-07-17 Thread Thomas Day
My experience also on Win2K. 9.2.0.1.0 the file is editable. On 9.2.0.3.0 results are unpredictable if you edit the file. I guess that they really don't want us editing it.

Re: RE: DBMS_REPAIR Package

2003-07-17 Thread rgaffuri
are there any practical uses for dbms_repair? or is it just a stop gap measure to use if your not able to do a recovery at that time? From: Stefick Ronald S Contr ESC/HRIDD [EMAIL PROTECTED] Date: 2003/07/17 Thu AM 10:39:24 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]

Re: DBMS_REPAIR Package

2003-07-17 Thread Richard Foote
Title: Message Hi Stefick, Running stored procedures/packages is somewhat difficult with a shutdown database, so the database needs to be opened. Depending on the type of corrupted block in question answers whether or not the block is actually repaired (eg. bitmap block in ASSM segments,

RE: faq broke?

2003-07-17 Thread Luis deUrioste
Seems to be Broke -Original Message- Sent: Thursday, July 17, 2003 9:20 AM To: Multiple recipients of list ORACLE-L Is it just me, or . . . I have not been able to search the faq archives all week (www.orfaq.net). When I find a match and try to open it, I get a message Our

Re: How to make SPFILE in sync with INIT.ORA ?

2003-07-17 Thread Don Yu
Hi, I really need some helps to configure my database with audit_trail option. I have tried some but fail so far. My database is Oracle 9.2. I have read all email related to spfile. Can somebody provides simple steps for me to update my specified initialization parameter in init.ora? (1) Manually

RE: faq broke?

2003-07-17 Thread Craig Healey
Worked fine for me just now. What are you searching on? Craig Healey -Original Message- From: Barbara Baker [mailto:[EMAIL PROTECTED] Sent: 17 July 2003 15:20 To: Multiple recipients of list ORACLE-L Subject: faq broke? Is it just me, or . . . I have not been able to search

RE: Oracle Instances not starting up via services

2003-07-17 Thread Jose Luis Delgado
Hi Nuala...! I'm almost sure that your problem is with environment variables... they usually are taken from the registry or defined on my_pc's properties... That's why I would like to know that values... can you send them to the list? HTH JL --- Nuala Cullen [EMAIL PROTECTED] wrote: Hi Jose,

RE:

2003-07-17 Thread Gogala, Mladen
Correction: Blessed are the cheesemakers, for they shall be called the sons of God. Blessed are the Greek, for they shall inherit the Earth. Comment: It's obviously deeper then just the cheese makers, it is referring to all manufacturers of the dairy products. Mladen Gogala Oracle DBA

RE: Why are SPFILEs binary anyway? (was RE: How to make SPFILE in

2003-07-17 Thread Jamadagni, Rajendra
Title: RE: Why are SPFILEs binary anyway? (was RE: How to make SPFILE in Hey, don't blame oracle for that ... did you complain to Microsoft when they created that Registry hive cr*p ?? Oracle is stepping on the same line ... Lemmings ... g Raj

RE: Why are SPFILEs binary anyway? (was RE: How to make SPFILE in

2003-07-17 Thread Richard Ji
That's a good point. Someone should try a binary editor instead, like bvi and see what happens. -Original Message- Sent: Thursday, July 17, 2003 10:45 AM To: Multiple recipients of list ORACLE-L in I wonder if it is something built into the file or something that vi (or whatever

Re: How to make SPFILE in sync with INIT.ORA ?

2003-07-17 Thread Arup Nanda
Well, I thought I answered your question earlier. Here are the steps, in more detail. I assume your database instance name is ORCL; replace with the actual. (1) With your database open, issue a command as sys SQL create pfile from spfile. (2) Go to the directory $ORACLE_HOME/dbs and make sue the

RE: Why are SPFILEs binary anyway? (was RE: How to make SPFILE in

2003-07-17 Thread Jamadagni, Rajendra
Title: RE: Why are SPFILEs binary anyway? (was RE: How to make SPFILE in Questin is why do you want to mess with it? That's not exactly my idea of fun ... I'd still use alter system, alter database commands to change whatever. Raj

RE: Why are SPFILEs binary anyway? (was RE: How to make SPFILE in

2003-07-17 Thread Gogala, Mladen
Why would you want to do that? You can always re-create the file from your PFILE. Oracle should have encrypted it. Mladen Gogala Oracle DBA Phone:(203) 459-6855 Email:[EMAIL PROTECTED] -Original Message- Sent: Thursday, July 17, 2003 12:10 PM To: Multiple recipients of list ORACLE-L in

RE: faq broke?

2003-07-17 Thread Barbara Baker
Happens on every query I give it. I'm looking for oraus.msb oci calls translate oci messages lseek error seems to be specific to oracle-l messages; others come up. I've forwarded a message to the webmaster Barb --- Craig Healey [EMAIL PROTECTED] wrote: Worked fine for me just

Re: OUI download

2003-07-17 Thread Simon . Anderson
I think it's patch 2878462 for the OUI placeholder for the latest version - Metalink patch search, by patch number. They don't make it easy to find... Cheers Simon Anderson Is there another location for downloads? (I don't think there is...) I am looking for a simple package that

RE:

2003-07-17 Thread Jesse, Rich
Oh it's the *Meek*...blessed are the Meek! That's nice, I'm gladthey're getting something, 'cause they have a hell of a time. -Original Message-From: Gogala, Mladen [mailto:[EMAIL PROTECTED]Sent: Thursday, July 17, 2003 10:44 AMTo: Multiple recipients of list ORACLE-LSubject:

RE: faq broke?

2003-07-17 Thread Craig Healey
Worked fine for me just now. OK, now it's stopped working! At least I know I didn't break it :-) Craig Healey ** This email and any files transmitted with it are confidential and intended solely for the use

IOT

2003-07-17 Thread Gurelei
Hi all: I'm condsidering creating an IO table in Oracle9. It is a small table with 2 columns and has a composite index so I thought that an IO table would make sence. Do they have any disadvantages I should be aware of? What I read on OTN site didn't mention any. thanks Gene

x server

2003-07-17 Thread AK
is there any free x server (unlimited ) software for windows 2000? -ak

RE: [PMX:#] RE: Find the table's name that using sequences

2003-07-17 Thread Jamadagni, Rajendra
Title: RE: [PMX:#] RE: Find the table's name that using sequences Very True ... Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have

Log oracle error to Apache log instead of web page

2003-07-17 Thread Liu, Jack
Hi,How can I make those error messages display in the Apache error log instead of displaying them in the end user web. Which config file should I change?Thanks, Jack

RE: x server

2003-07-17 Thread Richard Ji
check out cygwin. -Original Message-From: AK [mailto:[EMAIL PROTECTED]Sent: Thursday, July 17, 2003 12:49 PMTo: Multiple recipients of list ORACLE-LSubject: x server is there any free x server (unlimited ) software for windows 2000? -ak

RE:

2003-07-17 Thread Odland, Brad
How do you catch a humble individual? You meek up on them... -Original Message-From: Jesse, Rich Sent: Thursday, July 17, 2003 11:44 AMTo: Multiple recipients of list ORACLE-LSubject: RE: Oh it's the *Meek*...blessed are the Meek! That's nice, I'm gladthey're getting

Re: Another OCP slant...

2003-07-17 Thread Jonathan Gennick
Thursday, July 17, 2003, 6:34:26 AM, you wrote: DE Beyond the ethical implications and all the other issues. DE Has anyone on this list used the tips/suggestions to study for their OCP DE exams? Are they any good as an aid? I've never used any of the braindum.com type web sites, nor have I

Re: Security re: default and non-default roles

2003-07-17 Thread Arup Nanda
Leslie, First make sure they are indeed the default roles. select * from dba_role_privs where grantee = 'SCOTT' See the DEFAULT_ROLE column; it should be NO. Next, after logging in, before SET ROLE, issue select * from session_roles; to see the roles that are active now. Should be only the

Orbitz issue

2003-07-17 Thread rgaffuri
There are some vague and brief news articles on the web stating that Orbitz is down and they are blaming Oracle. Anyone with some inside info on what went wrong? just curious. i know its probably due to someone at Orbitz making a mistake. -- Please see the official ORACLE-L FAQ:

Re: How to make SPFILE in sync with INIT.ORA ?

2003-07-17 Thread Don Yu
Arup, Thank you very much. It works fine now. But my Oracle database instance name is bluejayt not ORCL. See the following message: $ ps -ef | grep bluejayt oracle 5796 1 0 13:01:08 ?0:00 ora_s000_bluejayt oracle 5790 1 0 13:01:08 ?0:00 ora_reco_bluejayt oracle

RE: Why are SPFILEs binary anyway? (was RE: How to make SPFILE in

2003-07-17 Thread Kirtikumar Deshpande
Editing spfile is not supported by Oracle. And I think it is documented as such. You can just view it, copy it and play with the copied version what whatever... One thing to remeber is to always hold on to the init.ora version. No matter what. Or at least until Oracle completely removes

RE: Why are SPFILEs binary anyway? (was RE: How to make SPFILE in

2003-07-17 Thread Richard Ji
Title: RE: Why are SPFILEs binary anyway? (was RE: How to make SPFILE in Of course you are right that no one should use it as the right way to change parameters. I will admit playing with binary file some times is my idea of fun. Hey, you never know, you might learn something from it. To

alert_sid.log file: Performance statistics empty: data overflow

2003-07-17 Thread Liu, Jack
Hi, I often see this in my alert_sid.log file: Performance statistics empty: data overflow What does this mean, is there anything wrong with the Oracle DB? Thanks, Jack -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Liu, Jack INET: [EMAIL PROTECTED] Fat City

Re: Re: Another OCP slant...

2003-07-17 Thread rgaffuri
i just hope they dont add a requirement to take one of their $2000 classes just to upgrade your certification. though it sure looks like they are heading that way... talk about a scam to get money. The classes are not rigorous, many instructors have little to no experience, and they go right

RE: alert_sid.log file: Performance statistics empty: data overfl

2003-07-17 Thread Josh Collier
It doesn't mean a thing. This is simply a benign warning message indicating that V$DISPATCHER_RATE performance statistics may no longer be accurate. fix: Ignore the error message. This message is no longer seen with Oracle9i. -Original Message- Sent: Thursday, July 17, 2003 10:29

RE: Orbitz issue

2003-07-17 Thread Jamadagni, Rajendra
Title: RE: Orbitz issue Nah ... it is just that ORacle is Unbreakable ... that's all. Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can

RE: DBMS_REPAIR Package

2003-07-17 Thread Jared . Still
If you ran dbverify with the database up, it's very likely that there is nothing wrong with the datafiles. If dbv reads a block in transition, it will appear corrupt. Run it again, and there will either be no errors, or they will appear to be in different blocks. Personally, I think it a

Re: how to schedule a job every alternate sundays in unix cron

2003-07-17 Thread Jared . Still
Brilliant. :) [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 07/16/2003 11:29 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re: how to schedule a job every alternate sundays in unix cron 0 1 * *

RE: faq broke?

2003-07-17 Thread Jared . Still
Perhaps you should try orafaq.org? ( notice the spelling ) Or was that just a typo in your original post? Jared Barbara Baker [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 07/17/2003 08:44 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL

RE: how to schedule a job every alternate sundays in unix cron

2003-07-17 Thread Mercadante, Thomas F
what a freekin nightmare! I'd hate to be the next poor bloke who has to decifer this... Tom Mercadante Oracle Certified Professional -Original Message- Sent: Thursday, July 17, 2003 2:35 PM To: Multiple recipients of list ORACLE-L Brilliant. :) [EMAIL PROTECTED] Sent by: [EMAIL

RE: how to schedule a job every alternate sundays in unix cron

2003-07-17 Thread Gene Sais
lol, actually makes sense :). wondering how the perl version would look like?Gene [EMAIL PROTECTED] 07/17/03 02:49PM what a freekin nightmare! I'd hate to be the next poor bloke who has todecifer this...Tom MercadanteOracle Certified Professional-Original Message-Sent: Thursday,

Physical Design Question

2003-07-17 Thread David Wagoner
Title: Physical Design Question Here's my situation: Damagement wants us to move 4 small production DBs to one server to save on licensing costs. Server is a Sun E4500, 4 CPUs, 8 GB RAM. There is a pair of internal disks that are mirrored with enough room for Solaris, swap, and 1 Oracle

Re: DBMS_REPAIR Package

2003-07-17 Thread Daniel Fink
There's a good argument for separating tables/indexes. [EMAIL PROTECTED] wrote: If you ran dbverify with the database up, it's very likely that there is nothing wrong with the datafiles. If dbv reads a block in transition, it will appear corrupt. Run it again, and there will either be

shell question

2003-07-17 Thread A.Bahar
hi all , how can I read a text file and print line by line. Rgds. Arslan. -- 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

RE: Another OCP slant...

2003-07-17 Thread Jesse, Rich
Yipe! Not having taken the OCP route (yet -- or, if ever), how much does the fail-retake-retake method cost in $$$? Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA -Original Message- From:

RE: Physical Design Question

2003-07-17 Thread Mercadante, Thomas F
Title: Physical Design Question David, You don't say but, I am assuming that all your databases are at the same Oracle Release level. If this is the case, I would create one Oracle home for now - you can always create a new Oracle Home when you start considering migrating each individual

oracle10g

2003-07-17 Thread Adams, Matthew (GECP, MABG, 088130)
Gotta love oracle. It won't be 10i, it'll be Oracle10g what on earth are they thinking? http://www.oracle.com/oracleworld/paris/conference/

STATSPACK in Oracle 8.1.6.0

2003-07-17 Thread Seema Singh
Hi, I want to delete all old records of statspack from perfstat schema. What would be best way to do this either by truncating all tables or remove and recreate ? Pl advice. thx -Seema _ Add photos to your e-mail with MSN 8. Get 2

RE: Here comes Oracle10G

2003-07-17 Thread Mercadante, Thomas F
gotta love it. the marketing people get to spend a whole new set of money to re-brand everything. I'm glad they are doing so well that they got money to burn. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Thursday, July 17, 2003 3:44 PM To: Multiple recipients

Re: Another OCP slant...

2003-07-17 Thread Tanel Poder
Title: RE: Another OCP slant... Hi! Why did you take 8 + 1 tests for 8 and 8i DBA? 5 + 1 should have been enough? Back in summer of 1999 when I wen't to EOUG yearly conference, Oracle promoted their OCP exams there and let people take their exams free. I thouht, what the heck, let's give

RE: shell question

2003-07-17 Thread Rudy Zung
cat(1) -Original Message- Sent: Thursday, July 17, 2003 3:09 PM To: Multiple recipients of list ORACLE-L hi all , how can I read a text file and print line by line. Rgds. Arslan. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rudy Zung INET: [EMAIL

RE: shell question

2003-07-17 Thread Stephen Lee
cat file sed '' file awk '{print}' file while read LINE; do echo $LINE; done file -Original Message- hi all , how can I read a text file and print line by line. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL

Re: Here comes Oracle10G

2003-07-17 Thread Daniel Fink
Kirtikumar Deshpande wrote: OracleWorld web sites SFO/PARIS revealing the new name as: Oracle10G Gee, it's not 'i' anymore ? Nope!! It's Capital G. G for God? No. It's Grid :) Enjoy.. - Kirti The first thing that comes to mind (as a commuter) is Grid...lock! I can see it now...New

Re: shell question

2003-07-17 Thread Brian_P_MacLean
Sounds to simple so I must be missing a few of the requirements (... cat myfile or #!/bin/ksh cat myfile | while read LINE do print ${LINE} done

RE: Another OCP slant...

2003-07-17 Thread April Wells
Title: RE: Another OCP slant... I scheduled mine over lunch... without the luxury of being able to take all the time off I need to take tests all day. It is why it took me 2.33 years for my undergrad degree and 4 years to finish my masters... it is all a matter of my setting my priorities,

Re: STATSPACK in Oracle 8.1.6.0

2003-07-17 Thread Kirtikumar Deshpande
The latter. Scripts are already supplied. - Kirti --- Seema Singh [EMAIL PROTECTED] wrote: Hi, I want to delete all old records of statspack from perfstat schema. What would be best way to do this either by truncating all tables or remove and recreate ? Pl advice. thx -Seema

Re: shell question

2003-07-17 Thread Don Yu
Please see the following text, which comes from my shell script: for arg_each_line in `cat $WORKING_DIR/log_file_parsing_temp02.temp | awk '{ pri nt $1===$2===$3 }'` do one_line=`echo $arg_each_line | sed 's/===/ /g'` # debug one line below if enabled #echo $one_line

Re: DBMS_REPAIR Package

2003-07-17 Thread Tanel Poder
Hi! If dbv reads a block in transition, it will appear corrupt. In 9i, I believe dbv reads a block multiple times, if it doesn't get a consistent (non-corrupted) image first time. If it gets the block ok during next attempts, block isn't reported corrupt. But if several subsequent attempts

RE: Here comes Oracle10G

2003-07-17 Thread Henry Poras
10G I think that's $/user Henry -Original Message- Kirtikumar Deshpande Sent: Thursday, July 17, 2003 3:44 PM To: Multiple recipients of list ORACLE-L OracleWorld web sites SFO/PARIS revealing the new name as: Oracle10G Gee, it's not 'i' anymore ? Nope!! It's Capital G. G for

Re: Here comes Oracle10G

2003-07-17 Thread Arup Nanda
How about G for Greedy! - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, July 17, 2003 3:44 PM OracleWorld web sites SFO/PARIS revealing the new name as: Oracle10G Gee, it's not 'i' anymore ? Nope!! It's Capital G. G for God?

RE:

2003-07-17 Thread Nelson, Allan
Title: Message Are you perhaps of Greek descent and living in Wisconsin? :-) Allan -Original Message-From: Gogala, Mladen [mailto:[EMAIL PROTECTED] Sent: Thursday, July 17, 2003 10:44 AMTo: Multiple recipients of list ORACLE-LSubject: RE: Correction: Blessed are the

RE: oracle10g

2003-07-17 Thread Boivin, Patrice J
Think "G" for globally. They are thinking globally. The grid computing page on otn says grid computing is available now for 9i release 2... Patrice. -Original Message-From: Adams, Matthew (GECP, MABG, 088130) [mailto:[EMAIL PROTECTED]Sent: Thursday, July 17, 2003 4:45

RE: Physical Design Question

2003-07-17 Thread David Wagoner
Title: Physical Design Question Thomas, Thanks for the comments. The databases are all different versions (8.1.7.3 to 9.2.0.2.0), at least for the time-being. In your suggestion to use 1 Oracle Home for multiple databases, then maybe later split into multiple Oracle Homes, do you have to

RE: oracle10g

2003-07-17 Thread Jesse, Rich
10G -- amount of force needed to be applied to one's head to get thru install. 10GI -- special military-strength version. 10BG -- allows instant archiving/retrieval of 70s disco music 10Gee--Wow. That's really neat. 10GB -- new installation on 16 CDs or 3 convenient DVDs. 10G4 --

RE: Here comes Oracle10G

2003-07-17 Thread Odland, Brad
(G for gazillion) 10G - Easy to remember pricing now, 10G (gazillion) per processor! 10G - ID10T The Enterprise Capable Value-Added Synergies With Paradigm Shift Detection and Resource balanced touch points. The database that powers the grid??!! lol crackin' myself up again... -Original

Re: Here comes Oracle10G

2003-07-17 Thread Tanel Poder
Hi! And the booth where they'll be giving away 10G installation CDs at OracleWorld San Francisco, will be named G-spot?! ;) Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, July 17, 2003 10:44 PM OracleWorld web sites SFO/PARIS

Re: Here comes Oracle10G

2003-07-17 Thread Jeremiah Wilton
No, it's G... another ORA-600. Or G... it's down again. JW - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, July 17, 2003 8:59 PM Kirtikumar Deshpande wrote: OracleWorld web sites SFO/PARIS revealing the new name as: Oracle10G

RE: oracle10g

2003-07-17 Thread Gogala, Mladen
Gridlock computing is available since the dawn of computing, all that is needed is a proper application design. I've seen quite a few applications using oracle RDBMS to implement gridlock computing,producing look and feel quite similar to LIE (I-495 in NY) on Monday 08:15 A.M.. Mladen

RE:

2003-07-17 Thread Gogala, Mladen
Title: Message Nope, I am a Croatian and I live in Connecticut. I was just referring to an old movie called "The Life of Brian". Mladen Gogala Oracle DBA Phone:(203) 459-6855 Email:[EMAIL PROTECTED] -Original Message-From: Nelson, Allan [mailto:[EMAIL PROTECTED]Sent:

Re: x server

2003-07-17 Thread Brian_P_MacLean
Are you looking for something like Exceed? If so try WinaXe - From http://www.tucows.com http://www.jcraft.com/weirdx AK

RE: Another OCP slant...

2003-07-17 Thread Niall Litchfield
I'm fortunate in having a public sector employer that believes in education (but not so fortunate because education only comes with a company stamp, so the like of the Miracle db forum are out :( ) so I did the classes apart from the network stuff cause I was bored by then. What I did find useful

install delete_commit procedure

2003-07-17 Thread Anna Li
Hi All, I would like to create DELETE_COMMIT procedure (developed and distributed by Oracle support). Does anyone know where I can get the script? Thanks in advance for your help. Anna _ MSN 8 with e-mail virus protection

NNC-00425: meta-data violation -- need sanity check!

2003-07-17 Thread Bob Metelsky
All Im setting up a name server on Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production On windows 2000 server Im doing eerything within the namesctl utility as typically I find the gui to be too buggy for my tastes. So I have the service running C:\ namesctl Currently managing

RE: How to make SPFILE in sync with INIT.ORA ?

2003-07-17 Thread Niall Litchfield
Kirti wrote The other parameters that will get you in the same trouble are related to the special buffer pools.. I ran into this issue with 9iR1 and decided to stay away from SPFILE stuff... The failure of Oracle (programmers) checking for such exclusiveness (?) tells their background.

Veritas and Oracle 9i with failsafe

2003-07-17 Thread Michael Kline
Got a cust who went Oracle 9i with failsafe... Now Veritas is broke and they evidently know it. Anyone else bit by this, and what was the solution if any? I guess the 9i is supposed to work, but when you add failsafe it's broke.. Hearing this 2nd hand you know.. Michael Alan Kline,

Distributed Oracle

2003-07-17 Thread Michael Kline
I have a customer whose long term goal is to have what would probably be close to RAS, but with the servers on a FAST backbone and about 500-800 feet apart... Is there a way to put that together with hardware software? In some ways they may even want to force a splitting of the load

  1   2   >