Rollback segments size calculation
Hi all I am getting ORA-01555 in my database and the solution is to create huge rollback segments but my doubt is how to calculate the size of this huge rollback segments . Now I have 24 G of space in rollback segment tablespace .But still i am getting the error.The environment is datawarehouse and loading happens almost every time except at night . and while loading data loading updataion and deletion happens frequently .Please help me in calculating the size of huge rollback segment . Happy Christmas and New year to all Regards, Shibu DISCLAIMER: This message (including attachment if any) is confidential and may be privileged. Before opening attachments please check them for viruses and defects. MindTree Consulting Private Limited (MindTree) will not be responsible for any viruses or defects or any forwarded attachments emanating either from within MindTree or outside. If you have received this message by mistake please notify the sender by return e-mail and delete this message from your system. Any unauthorized use or dissemination of this message in whole or in part is strictly prohibited. Please note that e-mails are susceptible to change and MindTree shall not be liable for any improper, untimely or incomplete transmission. <>
RE: Database Health Template-OT
Hi , . I was sending him thestatspack report ..but ..u know .. he don't understand that .. and is asking for more reports he wants even the export dump file size ...:).. so i thought i will get a detail template from someone else who is alreading have such a "detail" report ... Shibu -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wed 11/19/2003 7:35 PM To: Multiple recipients of list ORACLE-L Cc: Subject: Re: Database Health Template-OT these are bogus. its just about giving your boss some BS, so he goes away. Been there, done that. the only useful stuff to send him would be polling the alert log for 'ORA' errors, checking for chained rows as a percentage of total rows, and check to see how much free space is in each datafile. you can also send him statspack stuff, but he wont be able to read it. might want to send him a max users count and stuff like that. but that really isnt a 'health' check. what are you sending him now? hit ratios? Those are garbage. Even though the damn OCP test says to use them(im still annoyed by that).. its garbage. > > From: "Shibu MB" <[EMAIL PROTECTED]> > Date: 2003/11/19 Wed AM 08:50:07 EST > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > Subject: Database Health Template-OT > > > > Hi all, > I am looking for a template where i can fill the health > of the databases daily and send it to my boss .Though i have prepared one > i still doubt i have missed some thing :). If anybody has any format for > such a report please share it . > > > Thanks in advance > Shibu > > > > DISCLAIMER: > This message (including attachment if any) is confidential and may be privileged. Before opening attachments please check them for viruses and defects. MindTree Consulting Private Limited (MindTree) will not be responsible for any viruses or defects or any forwarded attachments emanating either from within MindTree or outside. If you have received this message by mistake please notify the sender by return e-mail and delete this message from your system. Any unauthorized use or dissemination of this message in whole or in part is strictly prohibited. Please note that e-mails are susceptible to change and MindTree shall not be liable for any improper, untimely or incomplete transmission. > > DISCLAIMER: This message (including attachment if any) is confidential and may be privileged. Before opening attachments please check them for viruses and defects. MindTree Consulting Private Limited (MindTree) will not be responsible for any viruses or defects or any forwarded attachments emanating either from within MindTree or outside. If you have received this message by mistake please notify the sender by return e-mail and delete this message from your system. Any unauthorized use or dissemination of this message in whole or in part is strictly prohibited. Please note that e-mails are susceptible to change and MindTree shall not be liable for any improper, untimely or incomplete transmission. <>
RE: Database Health Template-OT
Hi ,
I was sending statspack report ..but there is request for more and more ..
.. That's how i started searching for a generalised report ...
Regards,
Shibu
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Thu 11/20/2003 6:59 PM
To: Multiple recipients of list ORACLE-L
Cc:
Subject: RE: Database Health Template-OT
Hi Shibu-
Can we share your template so as to be able to fill in the gaps, and
also get
an idea of what you think a healthy DB should be like?
CSW Simon.
-Original Message-
Shibu MB
Sent: Wednesday, November 19, 2003 4:50 PM
To: Multiple recipients of list ORACLE-L
Hi all,
I am looking for a template where i can fill the
health
of the databases daily and send it to my boss .Though i have
prepared one
i still doubt i have missed some thing :). If anybody has any
format for
such a report please share it .
Thanks in advance
Shibu
DISCLAIMER:
This message (including attachment if any) is confidential and may be
privileged. Before opening attachments please check them for viruses
and
defects. MindTree Consulting Private Limited (MindTree) will not be
responsible for any viruses or defects or any forwarded attachments
emanating
either from within MindTree or outside. If you have received this
message by
mistake please notify the sender by return e-mail and delete this
message
from your system. Any unauthorized use or dissemination of this
message in
whole or in part is strictly prohibited. Please note that e-mails
are
susceptible to change and MindTree shall not be liable for any
improper,
untimely or incomplete transmission.
--
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).
DISCLAIMER:
This message (including attachment if any) is confidential and may be privileged.
Before opening attachments please check them for viruses and defects. MindTree
Consulting Private Limited (MindTree) will not be responsible for any viruses or
defects or any forwarded attachments emanating either from within MindTree or outside.
If you have received this message by mistake please notify the sender by return
e-mail and delete this message from your system. Any unauthorized use or dissemination
of this message in whole or in part is strictly prohibited. Please note that e-mails
are susceptible to change and MindTree shall not be liable for any improper, untimely
or incomplete transmission.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Shibu MB
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: Database Health Template-OT
Dennis .. You are right ...but what can we do if someone demands for such a report .. They want to analyze and track every info . Shibu -Original Message- From: DENNIS WILLIAMS [mailto:[EMAIL PROTECTED] Sent: Thu 11/20/2003 12:34 AM To: Multiple recipients of list ORACLE-L Cc: Subject: RE: Database Health Template-OT Shibu I agree with Ryan, that in a technical sense this is bogus. But I also feel there is a grain of truth in it. Often at its core the question has to do with comfort, and if recent incidents have caused a loss of comfort, then you get some sharp questions to answer. My strategy would be to increase the level of comfort, but don't commit yourself to wasting a lot of time once the sense of comfort returns. Here is what I would consider legitimate: 1. Install an alert log scanner that will email you when an error occurs. There are several free ones available on-line. 2. If you've experienced a recent crash, demonstrate you are taking serious actions to ensure this problem doesn't recur. Actions like monitoring. Here is what I consider bogus: 1. Constantly monitoring the buffer cache hit ratio. Marginal - run STATSPACK at regular intervals. I have had situations where the database would suddenly "hang" or "freeze" or "slow-down". I found that a couple of STATSPACK snapshots could provide a wealth of information about what was going on at the time of the incident. Now, my strong preference is to be notified so I can manually trigger these snapshots, but if it makes someone feel better and get off my case if I have them run at regular intervals, then I'm okay with that. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, November 19, 2003 7:50 AM To: Multiple recipients of list ORACLE-L Hi all, I am looking for a template where i can fill the health of the databases daily and send it to my boss .Though i have prepared one i still doubt i have missed some thing :). If anybody has any format for such a report please share it . Thanks in advance Shibu DISCLAIMER: This message (including attachment if any) is confidential and may be privileged. Before opening attachments please check them for viruses and defects. MindTree Consulting Private Limited (MindTree) will not be responsible for any viruses or defects or any forwarded attachments emanating either from within MindTree or outside. If you have received this message by mistake please notify the sender by return e-mail and delete this message from your system. Any unauthorized use or dissemination of this message in whole or in part is strictly prohibited. Please note that e-mails are susceptible to change and MindTree shall not be liable for any improper, untimely or incomplete transmission. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). DISCLAIMER: This message (including attachment if any) is confidential and may be privileged. Before opening attachments please check them for viruses and defects. MindTree Consulting Private Limited (MindTree) will not be responsible for any viruses or defects or any forwarded attachments emanating either from within MindTree or outside. If you have received this message by mistake please notify the sender by return e-mail and delete this message from your system. Any unauthorized use or dissemination of this message in whole or in part is strictly prohibited. Please note that e-mails are susceptible to change and MindTree shall not be liable for any improper, untimely or incomplete transmission. <>
Database Health Template-OT
Hi all, I am looking for a template where i can fill the health of the databases daily and send it to my boss .Though i have prepared one i still doubt i have missed some thing :). If anybody has any format for such a report please share it . Thanks in advance Shibu DISCLAIMER: This message (including attachment if any) is confidential and may be privileged. Before opening attachments please check them for viruses and defects. MindTree Consulting Private Limited (MindTree) will not be responsible for any viruses or defects or any forwarded attachments emanating either from within MindTree or outside. If you have received this message by mistake please notify the sender by return e-mail and delete this message from your system. Any unauthorized use or dissemination of this message in whole or in part is strictly prohibited. Please note that e-mails are susceptible to change and MindTree shall not be liable for any improper, untimely or incomplete transmission. <>
ORA-27102: out of memory in Tru64
Hi friends , I am getting the following error when trying to take the database to nomount state . I am trying to create a new database . $ svrmgrl Oracle Server Manager Release 3.1.7.0.0 - Production Copyright (c) 1997, 1999, Oracle Corporation. All Rights Reserved. Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production With the Partitioning option JServer Release 8.1.7.0.0 - Production SVRMGR> connect internal Connected. SVRMGR> startup pfile ='/app/oracle/admin/devbcm/pfile/initdevbcm.ora' nomount ORA-27102: out of memory Compaq Tru64 UNIX Error: 12: Not enough space Additional information: 1 Additional information: 98307 My Shm parameters are as given below . $ /sbin/sysconfig -q ipc ipc: msg-max = 8192 msg-mnb = 16384 msg-mni = 64 msg-tql = 40 shm-max = 1073741824 shm-min = 1024 shm-mni = 256 shm-seg = 128 sem-mni = 4096 sem-msl = 1000 sem-opm = 100 sem-ume = 1000 sem-vmx = 32767 sem-aem = 16384 num-of-sems = 1000 max-kernel-ports = 32351 port-hash-max-num = 1617550 port-reserved-max-num = 32351 set-max-num = 4338 ssm-threshold = 0 ssm-enable-core-dump = 1 Please help me to solve this error . Thanks Shibu DISCLAIMER: This message (including attachment if any) is confidential and may be privileged. Before opening attachments please check them for viruses and defects. MindTree Consulting Private Limited (MindTree) will not be responsible for any viruses or defects or any forwarded attachments emanating either from within MindTree or outside. If you have received this message by mistake please notify the sender by return e-mail and delete this message from your system. Any unauthorized use or dissemination of this message in whole or in part is strictly prohibited. Please note that e-mails are susceptible to change and MindTree shall not be liable for any improper, untimely or incomplete transmission. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Shibu MB INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Who is using temp tablespace?
Rick , This query will help you to find who is using the space SELECT a.username, a.osuser, a.sid||','||a.serial# SID_SERIAL, c.spid Process, b.tablespace tablespace, a.status, sum(b.extents)* 1024*1024 space FROM v$session a,v$sort_usage b, v$process c, dba_tablespaces d WHEREa.saddr = b.session_addr AND a.paddr = c.addr AND b.tablespace=d.tablespace_name --ORDER BY b.tablespace, b.segfile#, b.segblk#, b.blocks group by a.username, a.osuser, a.sid||','||a.serial#,c.spid, b.tablespace, a.status Thanks Shibu -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tue 11/4/2003 6:49 PM To: Multiple recipients of list ORACLE-L Cc: Subject: Who is using temp tablespace? Hi All, How can I determine who is using temp tablespace? I have a 1 gb tablespace and it is almost full. I want to know who and what sql is using most of it. Thanks Rick -- 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). DISCLAIMER: This message (including attachment if any) is confidential and may be privileged. Before opening attachments please check them for viruses and defects. MindTree Consulting Private Limited (MindTree) will not be responsible for any viruses or defects or any forwarded attachments emanating either from within MindTree or outside. If you have received this message by mistake please notify the sender by return e-mail and delete this message from your system. Any unauthorized use or dissemination of this message in whole or in part is strictly prohibited. Please note that e-mails are susceptible to change and MindTree shall not be liable for any improper, untimely or incomplete transmission. <>
RE: Redo log corruption
Dan ,
The problem was only in one log file .Now I took a cold backup and is
trying to bring my standby up. After bringing the standby ..i am
planning to monitor it closely for somedays ...to see if any corrupted
files are getting generated or not .
Thanks a lot
Shibu
-Original Message-
From: Daniel Fink [mailto:[EMAIL PROTECTED]
Sent: Mon 11/3/2003 8:09 PM
To: Multiple recipients of list ORACLE-L
Cc:
Subject: Re: Redo log corruption
Shibu,
I'd go ahead and check your system according to the bug (it may or
may not be present, my memory is a little foggy on the issue). If it is only
1 log, I would look to some other cause (disk), but if you find the
corruption in several logs, it points to something inside the db (not always,
but a good place to start).
Daniel
Shibu MB wrote:
> Dan ,
>
> My oracle version is as given below
>
> BANNER
>
> Oracle8i Enterprise Edition Release 8.1.7.3.0 - 64bit Production
> PL/SQL Release 8.1.7.3.0 - Production
> CORE8.1.7.0.0 Production
> TNS for IBM/AIX RISC System/6000: Version 8.1.7.3.0 - Production
> NLSRTL Version 3.4.1.0.0 - Production
>
> I saw one document in metalink which says about bug in
7.3 but i
> did not see anything for 8i .
>
>
> Thanks
> Shibu
>
> -Original Message-
> From: Daniel W. FInk [mailto:[EMAIL PROTECTED]
> Sent: Fri 10/31/2003 10:09 PM
> To: Multiple recipients of list ORACLE-L
> Cc:
> Subject: Re: Redo log corruption
>
>
>
> Shibu,
>
> What version of Oracle? There is a 7.x bug where mismatches
in asynch
> i/o read/write corrupted the logs. I don't recall if I encountered
it in 8i
> as well, but there is something in the back of my mind saying it
may still
> exist in later releases.
>
> Daniel Fink
>
> Shibu MB wrote:
>
> > Hi all ,
> >
> > While applying archive logs to my standby database i got
theerror
> >
> > ORA-00353: log corruption near block 207725 change
111482169731153
> time
> > 10/25/2003 12:14:01
> >
> > Can anybody tell me how archive logs can get corrupted ??
How can i
> avoid
> > oracle from generating corrupted archive logs ??How can i
check the
> "health"
> > of archive logs ??
> >
> >
> > Please help !.
> >
> > TIA
> >
> > Shibu
> > Alphawest Disclaimer
> >
> >
>
---
> > If this communication is not intended for you and you are
not an
> authorised
> > recipient of this email you are prohibited by law from
dealing with
> or
> > relying on the email or any file attachments. This
prohibition
> includes
> > reading, printing, copying, re-transmitting,
disseminating, storing
> or in
> > any other way dealing or acting in reliance on the
information.
> > If you have received this email in error, we request you
contact
> Alphawest
> >
> > immediately by returning the email to
[EMAIL PROTECTED]
> and
> > destroy the original. This email is confidential and may
contain
> privileged
> > client information. Alphawest has taken reasonable steps
to ensure
> the
> > accuracy and integrity of all its communications,
including
> electronic
> > communications, but accepts no liability for materials
transmitted.
> >
>
---
> >
> > DISCLAIMER:
> > This message (including attachment
RE: Redo log corruption
Dan ,
My oracle version is as given below
BANNER
Oracle8i Enterprise Edition Release 8.1.7.3.0 - 64bit Production
PL/SQL Release 8.1.7.3.0 - Production
CORE8.1.7.0.0 Production
TNS for IBM/AIX RISC System/6000: Version 8.1.7.3.0 - Production
NLSRTL Version 3.4.1.0.0 - Production
I saw one document in metalink which says about bug in 7.3 but i
did not see anything for 8i .
Thanks
Shibu
-Original Message-
From: Daniel W. FInk [mailto:[EMAIL PROTECTED]
Sent: Fri 10/31/2003 10:09 PM
To: Multiple recipients of list ORACLE-L
Cc:
Subject: Re: Redo log corruption
Shibu,
What version of Oracle? There is a 7.x bug where mismatches in asynch
i/o read/write corrupted the logs. I don't recall if I encountered it in 8i
as well, but there is something in the back of my mind saying it may still
exist in later releases.
Daniel Fink
Shibu MB wrote:
> Hi all ,
>
> While applying archive logs to my standby database i got theerror
>
> ORA-00353: log corruption near block 207725 change 111482169731153
time
> 10/25/2003 12:14:01
>
> Can anybody tell me how archive logs can get corrupted ?? How can i
avoid
> oracle from generating corrupted archive logs ??How can i check the
"health"
> of archive logs ??
>
>
> Please help !.
>
> TIA
>
> Shibu
> Alphawest Disclaimer
>
>
---
> If this communication is not intended for you and you are not an
authorised
> recipient of this email you are prohibited by law from dealing with
or
> relying on the email or any file attachments. This prohibition
includes
> reading, printing, copying, re-transmitting, disseminating, storing
or in
> any other way dealing or acting in reliance on the information.
> If you have received this email in error, we request you contact
Alphawest
>
> immediately by returning the email to [EMAIL PROTECTED]
and
> destroy the original. This email is confidential and may contain
privileged
> client information. Alphawest has taken reasonable steps to ensure
the
> accuracy and integrity of all its communications, including
electronic
> communications, but accepts no liability for materials transmitted.
>
---
>
> DISCLAIMER:
> This message (including attachment if any) is confidential and may
be privileged. Before opening attachments please check them for viruses and
defects. MindTree Consulting Private Limited (MindTree) will not be
responsible for any viruses or defects or any forwarded attachments emanating
either from within MindTree or outside. If you have received this message by
mistake please notify the sender by return e-mail and delete this message
from your system. Any unauthorized use or dissemination of this message in
whole or in part is strictly prohibited. Please note that e-mails are
susceptible to change and MindTree shall not be liable for any improper,
untimely or incomplete transmission.
>
>
> Name: winmail.dat
>winmail.datType: application/ms-tnef
> Encoding: 7bit
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Daniel W. FInk
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 message (including attachment if any) is confidential and may be privileged.
Before opening attachments please check them for viruses and defects. MindTree
Consulting Private Limited (MindTree) will not be responsible for any viruses or
defects or any forwarded attachments emanating either from wit
Redo log corruption
Hi all , While applying archive logs to my standby database i got theerror ORA-00353: log corruption near block 207725 change 111482169731153 time 10/25/2003 12:14:01 Can anybody tell me how archive logs can get corrupted ?? How can i avoid oracle from generating corrupted archive logs ??How can i check the "health" of archive logs ?? Please help !. TIA Shibu Alphawest Disclaimer --- If this communication is not intended for you and you are not an authorised recipient of this email you are prohibited by law from dealing with or relying on the email or any file attachments. This prohibition includes reading, printing, copying, re-transmitting, disseminating, storing or in any other way dealing or acting in reliance on the information. If you have received this email in error, we request you contact Alphawest immediately by returning the email to [EMAIL PROTECTED] and destroy the original. This email is confidential and may contain privileged client information. Alphawest has taken reasonable steps to ensure the accuracy and integrity of all its communications, including electronic communications, but accepts no liability for materials transmitted. --- DISCLAIMER: This message (including attachment if any) is confidential and may be privileged. Before opening attachments please check them for viruses and defects. MindTree Consulting Private Limited (MindTree) will not be responsible for any viruses or defects or any forwarded attachments emanating either from within MindTree or outside. If you have received this message by mistake please notify the sender by return e-mail and delete this message from your system. Any unauthorized use or dissemination of this message in whole or in part is strictly prohibited. Please note that e-mails are susceptible to change and MindTree shall not be liable for any improper, untimely or incomplete transmission. <>
RE: standby creation-solved
I got the solution ... these are the basics of standby .. i am going to read the docs once more ..:) Shibu -Original Message- From: [EMAIL PROTECTED] on behalf of Shibu MB Sent: Fri 10/31/2003 12:14 PM To: Multiple recipients of list ORACLE-L Cc: Subject: standby creation Hi all , I have a doubt in creating standby databases . I took one cold backup from primary database last week and restored the backup in standby database .After taking the cold backup i have added one more tablespace to primary database .Now my doubt is to bring my standby database up if i have to take one more cold backup or is there any way to add only the new datafiles to the standby . I have all the logs generated from last week and also i created a new controlfile using the command 'alter datbase create stand by controlfile to '< path > ' My primary and standby datbases are in two remote locations so again to take cold backup and bring it to the other location will take time. That's why i am finding some way to bring it up using the coldbackup which i have . Regards, Shibu DISCLAIMER: This message (including attachment if any) is confidential and may be privileged. Before opening attachments please check them for viruses and defects. MindTree Consulting Private Limited (MindTree) will not be responsible for any viruses or defects or any forwarded attachments emanating either from within MindTree or outside. If you have received this message by mistake please notify the sender by return e-mail and delete this message from your system. Any unauthorized use or dissemination of this message in whole or in part is strictly prohibited. Please note that e-mails are susceptible to change and MindTree shall not be liable for any improper, untimely or incomplete transmission. DISCLAIMER: This message (including attachment if any) is confidential and may be privileged. Before opening attachments please check them for viruses and defects. MindTree Consulting Private Limited (MindTree) will not be responsible for any viruses or defects or any forwarded attachments emanating either from within MindTree or outside. If you have received this message by mistake please notify the sender by return e-mail and delete this message from your system. Any unauthorized use or dissemination of this message in whole or in part is strictly prohibited. Please note that e-mails are susceptible to change and MindTree shall not be liable for any improper, untimely or incomplete transmission. <>
standby creation
Hi all , I have a doubt in creating standby databases . I took one cold backup from primary database last week and restored the backup in standby database .After taking the cold backup i have added one more tablespace to primary database .Now my doubt is to bring my standby database up if i have to take one more cold backup or is there any way to add only the new datafiles to the standby . I have all the logs generated from last week and also i created a new controlfile using the command 'alter datbase create stand by controlfile to '< path > ' My primary and standby datbases are in two remote locations so again to take cold backup and bring it to the other location will take time. That's why i am finding some way to bring it up using the coldbackup which i have . Regards, Shibu DISCLAIMER: This message (including attachment if any) is confidential and may be privileged. Before opening attachments please check them for viruses and defects. MindTree Consulting Private Limited (MindTree) will not be responsible for any viruses or defects or any forwarded attachments emanating either from within MindTree or outside. If you have received this message by mistake please notify the sender by return e-mail and delete this message from your system. Any unauthorized use or dissemination of this message in whole or in part is strictly prohibited. Please note that e-mails are susceptible to change and MindTree shall not be liable for any improper, untimely or incomplete transmission. <>
RE: hrs to run catpatch.sql
Hi , For me it took approximately 2 hrs to run catpatch.sql and don't have any probs yet Thanks to kirti and brad for the info ... Shibu -Original Message- From: Kirtikumar Deshpande [mailto:[EMAIL PROTECTED] Sent: Wed 10/15/2003 7:54 PM To: Multiple recipients of list ORACLE-L Cc: Subject: RE: hrs to run catpatch.sql Thanks for this info about your problem. I will keep it hande for future reference. May be I got lucky, because I did not encounter major issues when I upgraded 9.2.0.3 to 9.2.0.4 on HP-UX 11i. Just one lib had to be renamed so Oracle could create it afresh. Other than that, it was pretty smooth on 3 servers. - Kirti --- "Odland, Brad" <[EMAIL PROTECTED]> wrote: > I have been testing the Oracle 9.2.0.4 patch on HP/UX dev box and have a > open TAR. > > I ran into a bunch of problems relinking after applying the 9.2.0.4 patch on > HP/UX. > > > Oracle had me run RDA and gave me a list of missing OS patches, I still had > the same errors they had me run RDA again and gave me another list of OS > patches...finally escalated the issue and got some help getting the relink > done but now... > The catpatch.sql exits sqlplus or the connection would get broken. And the > script would continue running saying, NOT CONNECTED TO ORACLE.a > gazillion times...So its a mess right now. > And SMON generates ORA-600's every five minutes until it shuts the intance > down. With Arguemt [51] that is unpublished at this time and the stack trace > offers zero infoand Oracle is suddenly very quiet in my TAR... > > Make sure you test that patch COMPLETELY before doing anything to a > production server > > I am probably going to unistall the whole mess and start over > > This has been the most problematic patch that I have seen(I suppose I > was due) > > > > -Original Message- > Sent: Tuesday, October 14, 2003 7:59 AM > To: Multiple recipients of list ORACLE-L > > > Hi all .. > Can anybody tell me how many hours it will take to run the patch > catpatch.sql . I am planning to upgrade the server. > > My server info is given below > > BANNER > > Oracle9i Enterprise Edition Release 9.2.0.3.0 - 64bit Production > PL/SQL Release 9.2.0.3.0 - Production > CORE9.2.0.3.0 Production > TNS for IBM/AIX RISC System/6000: Version 9.2.0.3.0 - Production > NLSRTL Version 9.2.0.3.0 - Production > > Thanks > Shibu > > __ Do you Yahoo!? The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kirtikumar Deshpande 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 message (including attachment if any) is confidential and may be privileged. Before opening attachments please check them for viruses and defects. MindTree Consulting Private Limited (MindTree) will not be responsible for any viruses or defects or any forwarded attachments emanating either from within MindTree or outside. If you have received this message by mistake please notify the sender by return e-mail and delete this message from your system. Any unauthorized use or dissemination of this message in whole or in part is strictly prohibited. Please note that e-mails are susceptible to change and MindTree shall not be liable for any improper, untimely or incomplete transmission. <>
hrs to run catpatch.sql
Hi all .. Can anybody tell me how many hours it will take to run the patch catpatch.sql . I am planning to upgrade the server. My server info is given below BANNER Oracle9i Enterprise Edition Release 9.2.0.3.0 - 64bit Production PL/SQL Release 9.2.0.3.0 - Production CORE9.2.0.3.0 Production TNS for IBM/AIX RISC System/6000: Version 9.2.0.3.0 - Production NLSRTL Version 9.2.0.3.0 - Production Thanks Shibu DISCLAIMER: This message (including attachment if any) is confidential and may be privileged. Before opening attachments please check them for viruses and defects. MindTree Consulting Private Limited (MindTree) will not be responsible for any viruses or defects or any forwarded attachments emanating either from within MindTree or outside. If you have received this message by mistake please notify the sender by return e-mail and delete this message from your system. Any unauthorized use or dissemination of this message in whole or in part is strictly prohibited. Please note that e-mails are susceptible to change and MindTree shall not be liable for any improper, untimely or incomplete transmission. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Shibu MB 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).
Oracle Express and transaction mode
Hi all... I am working on a Datawarehouse, the OLAP engine is ORACLE EXPRESS. Whenever ORACLE EXPRESS fires a 'select' query to the oracle database, it sets the transaction in read only mode. This is done by first setting the session in READ ONLY mode. set transaction read only; and then firing the query... Select.. Now the problem I am facing is that oracle optimizer goes in for a suboptimal execution plan, because the session is set in READ ONLY mode. So, is there any way to capture 'set transaction read only' statement fired by an oracle session and set it to 'set transaction read write'? Thanx in Advance, Shibu DISCLAIMER: This message (including attachment if any) is confidential and may be privileged. Before opening attachments please check them for viruses and defects. MindTree Consulting Private Limited (MindTree) will not be responsible for any viruses or defects or any forwarded attachments emanating either from within MindTree or outside. If you have received this message by mistake please notify the sender by return e-mail and delete this message from your system. Any unauthorized use or dissemination of this message in whole or in part is strictly prohibited. Please note that e-mails are susceptible to change and MindTree shall not be liable for any improper, untimely or incomplete transmission. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Shibu MB 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).
Oracle Express help
Hi all, Can anyone give me info about oracle express list ? Is there any oracle express gurus here ?? I need some help for oracle express. Thanks Shibu DISCLAIMER: This message (including attachment if any) is confidential and may be privileged. Before opening attachments please check them for viruses and defects. MindTree Consulting Private Limited (MindTree) will not be responsible for any viruses or defects or any forwarded attachments emanating either from within MindTree or outside. If you have received this message by mistake please notify the sender by return e-mail and delete this message from your system. Any unauthorized use or dissemination of this message in whole or in part is strictly prohibited. Please note that e-mails are susceptible to change and MindTree shall not be liable for any improper, untimely or incomplete transmission. <>
few questions on 9i
Hi all Can any body help in answering these questions 1. What features of Oracle 9i do you recommend to use? Why? 2. What are the features of Oracle 9i you do not recommend? Why? 3. Have you had any problems with any of the Oracle 9i features? Please elaborate. If any, how did you solve or get around those problems? Thanks shibuDISCLAIMER:This message (including attachment if any) is confidential and may be privileged. Before opening attachments please check them for viruses and defects. MindTree Consulting Private Limited (MindTree) will not be responsible for any viruses or defects or any forwarded attachments emanating either from within MindTree or outside. If you have received this message by mistake please notify the sender by return e-mail and delete this message from your system. Any unauthorized use or dissemination of this message in whole or in part is strictly prohibited. Please note that e-mails are susceptible to change and MindTree shall not be liable for any improper, untimely or incomplete transmission.
Naming Conventions....
Hi all... What are the naming conventions u guys follow when designing a database ???.Can anybody send me a general document on this. I am trying to make the attribute name unique in my database but i dunno what naming convention i have to follow for this .. I have tried all kinda combinations but some how the names are not coming unique and because of this the developers may get confused know ... so please tell me what naming convention are followed by u DBA s Thanks Shibu
DataGuard Remote Process startup Failed- Error
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 dg_broker_start = TRUE in the primary node. But still i am getting the error . I did not find any documentation for this .Can anyone help me to solve this error ?? Oracle version is 9i release 2 and O/S is win2k . Thanks Shibu
