DataGuard Remote Process startup Failed- Error

2002-11-04 Thread Shibu MB
Hi friends.. I am trying to create a stand by database using dataguard and i am getting the error ' DataGuard remote process startup failed' . In primary and secondary database oracle agent is running . I have management server installed in the primary node itself . i have set

Re: Re Raid 5+

2002-11-04 Thread Jared . Still
I cannot fathom Raid 5 being faster than Raid 1 for writes. Well in sequential writes like redo log, copy redo log to archive log and many other cases raid 5 will be faster. Care to explain how RAID5 will be faster for a redo log write, because I don't have that understanding of it. If I'm

RE: Moving datafiles, controlfiles, and redos.

2002-11-04 Thread Scott Stefick
(T)hanks (I)n (A)dvance At 09:48 AM 11/4/02 -0800, you wrote: sorry what is that TIA thing on the ned of the message -Original Message- From: Gabriel Aragon [mailto:[EMAIL PROTECTED]] Sent: segunda-feira, 4 de Novembro de 2002 17:04 To: Multiple recipients of list ORACLE-L

RE: Moving datafiles, controlfiles, and redos.

2002-11-04 Thread Fink, Dan
TIA - Thanks In Advance... What is the 'ned of the message' -Original Message-From: Paulo Gomes [mailto:[EMAIL PROTECTED]]Sent: Monday, November 04, 2002 10:49 AMTo: Multiple recipients of list ORACLE-LSubject: RE: Moving datafiles, controlfiles, and redos. sorry

MTS process HIGH CPU

2002-11-04 Thread Seema Singh
Hi I am using MTS in 8.1.6.I am wondering one of MTS process is locked 2 table since morning and this process is taking more CPU.Can I kill that process like ora_s000_prod by using alter system and then unix kill command? Thx -Seema

Re: Partition Question

2002-11-04 Thread Don Jerman
It depends on your reason for partitioning -- if you mean to drop a partition in the future (to roll off the 1999 data or whatever) then the ID range is potentially a valid approach, as long as ID is serial. If you just want to put chunks on different disk volumes, you could use the type or even

RE: Re Raid 5+

2002-11-04 Thread Markham, Richard
Title: RE: Re Raid 5+ Jared raid 5 is good over a single disk for the read speed and the fact you can rebuild if a disk is lost. A raid 5 write includes the additional overhead of calculating parity, no question about it. My raid 1+0 spindles are faster than my raid 5 when it comes to

Oracle 817 on Solaris 2.6 moving to Solaris 8

2002-11-04 Thread Godlewski, Melissa
Title: Oracle 817 on Solaris 2.6 moving to Solaris 8 OS upgrade relink all? We are actually moving from one physical machine to another, but in reality we are just doing and OS upgrade from Sun Solaris 2.6 to Sun Solaris 8. My idea is to just backup the database and restore to the new

RE: Re: Reporting - Casting about for ideas

2002-11-04 Thread DENNIS WILLIAMS
Jared - My company has had good luck with Actuate. http://www.actuate.com/products/server/index.asp It is reasonably flexible in serving HTML or text reports to users via a Web interface. It can also create the reports via SQL queries. You can manage which users can access which reports, and can

RE: Red Hat or Suse

2002-11-04 Thread Gogala, Mladen
so, now you want to date Mr. Gates? I think he's married. -Original Message- From: Mike Killough [mailto:mwkillough;hotmail.com] Sent: Monday, November 04, 2002 12:33 PM To: Multiple recipients of list ORACLE-L Subject: RE: Red Hat or Suse Me too. She was unstable.

Re: Re: Reporting - Casting about for ideas

2002-11-04 Thread Jared . Still
For those that may be curious, I found the BMC software that Yechial referred to. Price for 250 users: $60k US. Plus consulting $$$. Fairly expensive, I would say. Jared Yechiel Adar [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 11/04/2002 12:23 AM Please respond to ORACLE-L

RE: Moving datafiles, controlfiles, and redos.

2002-11-04 Thread Stephen Lee
If you are, in fact, moving the files to different file systems: Change the location of the control files in the init.ora. Startup mount. alter database rename file '/from/where/it/was' to '/where/it/is/now'; etc. etc. alter database open; -- Please see the official ORACLE-L FAQ:

RE: What's your opinion: ALL_ROWS vs. FIRST_ROWS

2002-11-04 Thread Jesse, Rich
H. I had no such message using Opera 6.05 with Java/JS/Cookies off. Although, by default, IP logging is on for many webservers, so just about anywhere you surf to has captured your IP. Probably one reason more why we have a proxy server here at work. Rich Rich Jesse

RE: Database Design: unique PK across all tables

2002-11-04 Thread MacGregor, Ian A.
If the application were to use a table-driven sequence; i.e., select max(keynum) +1 from sequence_table; then it would indeed be database neutral; however, as you stated, that technique does not scale. Oracle sequences; i.e., those employing sequence.nextval, are an Oracle construct and are

RE: What's your opinion: ALL_ROWS vs. FIRST_ROWS

2002-11-04 Thread DENNIS WILLIAMS
Michael - In Oracle9i it goes even further. Now there is FIRST_ROWS_1, FIRST_ROWS_10, and on up to _1000. Just thought you might want to take that in consideration. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, November 04, 2002 1:04 PM

RE: What's your opinion: ALL_ROWS vs. FIRST_ROWS

2002-11-04 Thread John Kanagaraj
Hi Mike, Your article was very good in describing RBO vs. CBO. I hope you don't mind me using it to help better describe why we're switching from RBO to CBO to my team. I forgot to mention this before, but you should also look at Tim Gorman's excellent paper on the CBO at

RE: Re: Reporting - Casting about for ideas

2002-11-04 Thread DENNIS WILLIAMS
Jared - I think I steered you wrong. Apparently Actuate is even costlier. Gee, maybe you could whip something up in Perl. Do it on your own time so you can marked it later. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, November 04, 2002

RE: Re: Reporting - Casting about for ideas

2002-11-04 Thread DENNIS WILLIAMS
Oops, I meant so you could MARKET it later. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, November 04, 2002 4:24 PM To: Multiple recipients of list ORACLE-L Jared - I think I steered you wrong. Apparently Actuate is even costlier. Gee, maybe

RE: Re: Reporting - Casting about for ideas

2002-11-04 Thread Jared . Still
Well, yes, I am seriously considering that. Not that I mind doing it, just not sure I have the time. Jared DENNIS WILLIAMS [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 11/04/2002 02:23 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]

RE: Re Raid 5+

2002-11-04 Thread John Kanagaraj
Yechiel, Just to add to Jared's note, RAID5 does a _lot_ more during a write. It has to perform what is known as the 'read-modify-write' cycle, where it has to first read the existing parity for the data that is being written. This is an I/O to _all_ the disks involved. It then has to calculate

Re: Question on in-doubt transaction

2002-11-04 Thread David Davis
Check out the documentation for the dbms_transaction package. I have used it previously (dbms_transaction.purge_lost_db_entry). In my case, the cause was due to a problem in SQL Server (DTS process). See Docids on Metalink: 67590.1 - PROCEDURE:DBMS_TRANSACTION.PURGE_LOST_DB_ENTRY 100664.1 -

Relation Between Oracle Sessions

2002-11-04 Thread Hussain Ahmed Qadri
Title: Relation Between Oracle Sessions Hi all, A question related to Developer but involves forming sessions at the backend, so would appreciate any help or ideas. Whenever a form is opened, it opens an Oracle session (can be seen from v$session). Now when we call another form from this

Re: Relation Between Oracle Sessions

2002-11-04 Thread Justin Cave
At 10:08 PM 11/4/2002, you wrote: Whenever a form is opened, it opens an Oracle session (can be seen from v$session). Now when we call another form from this opened form, (call form property of forms), it will open another session. If we consider the main form as the parent form and the form

Can any one tell me how can i read parameter info from RDF(Reports definition file)

2002-11-04 Thread Muhammad Tariq
Can any one tell me how can i read parameter info from RDF(Reports definition file)