Defragmenting a RAID 5 volume?

2004-01-21 Thread Rhojel_Echano
Hello people, We recently experienced a hang in our database server, WIN2k Advanced server with raid 5 for Oracle 817 database files. Examining the perf logs showed that Event 2022 caused the hang: Event ID: 2022 Source: Srv Description: Server was unable to find a free connection 144

Re: Oracle8i on Linux

2004-01-13 Thread Rhojel_Echano
Hi, I experienced that same problem before. I found an article that suggested downgrading your gcc to a previous version. I lost the link to the article, sorry. You may try downgrading your gcc to a version before what is included in the RH7.3 distro. Good luck, Seema Singh [EMAIL

Re: Disk capacity planning

2004-01-13 Thread Rhojel_Echano
Thanks for the time answering my question guys... :-) Tanel, I've just inherited the database that I'm handling right now and I was not part of the real capacity planning. I really lack experience on this part of the job and I would appreciate your thoughts on any good documentation regarding

Disk capacity planning

2004-01-12 Thread Rhojel_Echano
Hi everyone! Can anybody point me to any good documentation regarding disk capacity planning? Sharing your experience or approach will also give me so much help. I'd like to know other people's approach on forecasting the growth of their databases particularly on determining the (growth) rate of

more on block corruption

2003-12-05 Thread Rhojel_Echano
short question: if i fix a corrupted block using dbms_repair to mark block software corrupt, will I be able to access data contained in that block? thanks in advance... Regards, Rhojel

RE: Export table to determine extent of block corruption

2003-12-04 Thread Rhojel_Echano
Thanks Dennis! I've read a couple of docs on getting enough information on the corruption. I'd like to use DBMS_REPAIR.CHECK_OBJECT, but I'd like to know first if this would be safe to run on an online production database. Could anyone comment on this? Oh Dennis, sorry for the nightmares ;-)

Re: Trace versus Statspack data

2003-11-17 Thread Rhojel_Echano
Hi. Execute in sqltrace is for that particular session only whereas in statspack, it's system wide. A lot of sessions might have executed the same query. Best regards VIVEK_SHARMA [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 11/17/2003 02:19 PM Please respond to ORACLE-L To:

OWS-05566 caused by ORA-12202

2003-11-17 Thread Rhojel_Echano
I would like to make an application in OAS 408 to connect to an 817 database. When I try to create a DAD to establish this connection, I get this error: OWS-05566 caused by ORA-12202: TNS internal navigation error. Can anyone enlighten me on what these errors mean and how to work around it? DB

Re: OWS-05566 caused by ORA-12202

2003-11-17 Thread Rhojel_Echano
Hi Melanie, This was how the application was implemented in my new company, they used OAS 408. Still gettingfamiliar with their application.. this is what happened: I transferred the dev DB to another host for maintenance purposes and when I tried to configure a DAD for that DB in OAS, I got

Re: OWS-05566 caused by ORA-12202

2003-11-17 Thread Rhojel_Echano
Hi Melanie, Yup, I've checked all that. I guess that's the only option I have right now (Oracle support). There's not much documentation for this error in Metalink, I guess they want us to go to them directly on this one..=) But I'll do some double checking on those points that you've