Securing the Database Structure
Hi all, When you develop a software and you intend to sell it, are there any ways of saving your database structure. Because obviously we don't give the fmb's, we only give the executable. But to run the software we need to have the database and there are ways by which the database structure can be seen, imp/exp is an example for one. I know by getting the database structure it would be very difficult to interpret the system, but structure is the core of the whole thing. So I wanted to ask what are the steps that are followed when you are packaging your software to sell and what are the security measures to protect your application, forms, database structures, etc. Plus any good method/utility to encrypt the contents of a batch file but at the same time allowing it to be executed. Thanks and regards, Hussain -- 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: RAC or Oracle Fail Safe
Title: RE: RAC or Oracle Fail Safe Hi Rajesh, Thanks for the detailed reply and I really appreciate that. Certain clarifications. 1. With reference to what you said about using both the nodes, you meant that we can install another database (lets say for reporting purpose) or/and also 9iAS on one node and our main production database on the other 2. Incase of OFS, the database service fails over from one node to the other, and then it starts, but it is automatic, right? 3. When you talk about Resources and that they can’t be shared, you are not referring to the shared storage vault (we are using DAS – Direct Attached Storage) because that has to be at least available to both the servers. And when the database fails over from one server to the other, and it starts its services on the other server, then the obviously that other server will make use of the DAS on which reside our datafiles. 4. RAC costs roughly 20k$ per CPU and it doesn’t come bundled with Oracle 9i License? (For confirmation purposes) 5. From various mails I gather that OFS is basically a safe bet, if the hardware supporting is good. And if, God-forbid, one server goes down then the only time lapse is the time it takes to start the services on the other server. 6. The transactions taking place at the time when main server goes down will be lost, I mean it will give a feeling of hung database or some other error. Thanks in advance, and waiting for your reply. Regards, Hussain -Original Message- From: RAJESH DAYAL [mailto:[EMAIL PROTECTED] Sent: Thursday, July 17, 2003 12:30 PM To: Multiple recipients of list ORACLE-L Subject: 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 node at one point of time. ( Resource means Hard Disk Space, Oracle Service, Listener etc). RAC can give "Transparent Application Failover" TAF which is out of consideration in OFS. In case of node failure on RAC System, the user will just need to attempt relogin and he will be connected _immediately_ to another surviving instance ( If tnsnames.ora is configured properly). While there is a significant amount of delay in case of OFS, the Database service has to failover from one node to another node and this may take it's own _sweet_ amount of time based on amount and type of activity being performed on the database. Of course both the systems are screwed when your (shared) storage system is down ;-) Lastly why would someone want to use only 1 out of 2 nodes when it is possible to use both the nodes? One possible answer is that, on one node you configure One server (say 9iAS) and on another node you configure database. Then under normal condition they will run on their respective nodes and when one fails they would switch-over to the surviving node. So your performance may suffer for the time during which any node is down. So you are the best judge to decide now ;-) Just my .2 c Regards, Rajesh -Original Message- HREF="" PROTECTED]">mailto:[EMAIL PROTECTED] On Behalf Of Hussain Ahmed Qadri Sent: Wednesday, July 16, 2003 8:44 PM To: Multiple recipients of list ORACLE-L Subject: 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 SKMCH&RC -- 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: RAC or Oracle Fail Safe
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 different on RAC? We have the licensed RAC and Oracle Fail Safe CDs, so that is not an issue. I also believe that setting up RAC is more complex, so we wanted to confirm that if Fail Safe gives us HA, 24x7, and any change in node shifting (when active is down, passive becomes active) is transparent to the user then we should go for Fail safe. By the way, we intend to keep cluster settings of ACTIVE and PASSIVE, is there any issue regarding this? Tanel Poder: you said that, " in event of failure you can start up instance on another node that will mount, recover and open the database." Doesn't the second node automatically take over? And this means that the user has to log in again, do I get it right? Best Regards, Hussain -Original Message- Sent: Wednesday, July 16, 2003 10:44 PM To: Multiple recipients of list ORACLE-L 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 SKMCH&RC > > -- > 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). -- 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).
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 SKMCH&RC -- 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: Undo Analyze Table
Title: RE: Undo Analyze Table Thank you all, I'll test and see what helps, Regards, Hussain -Original Message- From: Mladen Gogala [mailto:[EMAIL PROTECTED]] Sent: Monday, June 16, 2003 5:37 PM To: Multiple recipients of list ORACLE-L Subject: Re: Undo Analyze Table The answer is found in the Jonathan Lewis book "Building Efficient Databases". You should set OPTIMIZER_INDEX_COST_ADJ and OPTIMIZER_INDEX_CACHING. Explanation: It is realistic to expect a part of an index to be cached and it is also realistic to expect the index access to be somewhat cheaper then the table access. These two parameters give the same slant toward the index access path and nested loops path as RBO. For the rest, buy Jonathan's book. On 2003.06.16 02:54, Hussain Ahmed Qadri wrote: > Hi, > We have two DBs, a production and a development, identical query was running > very quickly on the Development and very slowly on the Production. Both have > the similar structures, same number of indexes and everything. When I > checked the explain plan, I found out that on the Production DB, it was > doing a FTS on a couple of tables and was doing an Index scan on the > Development server. The only difference was that the tables on the > Production were ANALYZED. > To confirm my theory, I analyzed the tables on Development and it started > doing a FTS there as well hence slowing the query down. I know the > optimizer, after analyzing, would have chosen the better path in its own > sense but its not producing the desired result and it is taking ages now. > is there any way to undo that? > > Regards, > > Hussain Ahmed Qadri > DBA > SKMCH&RC > -- 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).
Undo Analyze Table
Title: Undo Analyze Table Hi, We have two DBs, a production and a development, identical query was running very quickly on the Development and very slowly on the Production. Both have the similar structures, same number of indexes and everything. When I checked the explain plan, I found out that on the Production DB, it was doing a FTS on a couple of tables and was doing an Index scan on the Development server. The only difference was that the tables on the Production were ANALYZED. To confirm my theory, I analyzed the tables on Development and it started doing a FTS there as well hence slowing the query down. I know the optimizer, after analyzing, would have chosen the better path in its own sense but its not producing the desired result and it is taking ages now. is there any way to undo that? Regards, Hussain Ahmed Qadri DBA SKMCH&RC
DB Link in forms6
Title: DB Link in forms6 Hi all, Does anyone know of any bug of Oracle, which doesn't allow Database link to work properly in side a Developer 6 form? The problem is that we have a form in which we are connected with one database and on pressing a button, want to insert data in another database. The form worked fine in the start, but then it started getting hung up and now when I compile the form, it simply disappears, i.e. it exits! Same DB link does the same insertions from the backend without any problem. Can anyone suggest what could be happening? DB version is 8.1.7.4.1 of both the databases. Regards, Hussain Ahmed Qadri DBA SKMCH&RC
RE: Memory taken by s session
Title: RE: Memory taken by s session Hi, I explored the view v$sesstat. What I wanted to ask was whether the column VALUE in this shows bytes or what? Because if it is bytes then I can make out from combining the two views, i.e. v$sesstat and v$statname as to how much memory (pga, uga) is taken by every session. What I forgot to mention earlier was that we are using MTS. The PGA memory and maximum PGA memory remains more or less the same for every session opened, but UGA memory changes with some work. But even that is not consistent, I mean UGA memory doesn't always change with every query I run from that session. Any explanation as to why? Regards, Hussain -Original Message- From: chao_ping [mailto:[EMAIL PROTECTED]] Sent: Saturday, March 22, 2003 2:15 PM To: Multiple recipients of list ORACLE-L Subject: Re: Memory taken by s session Hussain Ahmed Qadri, hi, from oracle, you can get it from v$sesstat, in oracle9i ,you can even get the more detailed data from v$process. From Unix os, for solaris, you can use pmap, on linux, you can use /proc//status. FOr other os, I hope others can share there experience. Good luck Regards zhu chao msn:[EMAIL PROTECTED] www.cnoug.org(China Oracle User Group) === 2003-03-22 00:13:00 ,you wrote£º=== >Hi all, > >Can anyone tell me what is the memory any session takes when it logs on to >the database? That's is, when a person opens a SQL plus window, how much >memory is allocated to that session (just opening it and then the session is >idle). And when he performs certain query, which returns over a few thousand >records or more, what is the effect on the memory usage of that session. Any >guidelines perhaps? > >Regards, > >DBA >SKMCH&RC = = = = = = = = = = = = = = = = = = = = -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: chao_ping 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).
Memory taken by s session
Title: Memory taken by s session Hi all, Can anyone tell me what is the memory any session takes when it logs on to the database? That's is, when a person opens a SQL plus window, how much memory is allocated to that session (just opening it and then the session is idle). And when he performs certain query, which returns over a few thousand records or more, what is the effect on the memory usage of that session. Any guidelines perhaps? Regards, DBA SKMCH&RC
Buffer_Pool KEEP
Title: Buffer_Pool KEEP Hi all, Is there any way / script to find whether the tables kept in KEEP Buffer pool performing fine i.e. do they really need to be in the KEEP buffer pool or should they be removed. Tables that I want to check are in the buffer pool for over 6 months and I want to know if I should let them be there or be removed from there. Regards, Hussain DBA SKMCH&RC
RE: Trace file size...
Title: RE: Trace file size... Hi Jeremiah, When ever I run a certain Automation script file, I get an error pointing it to a trace file S000.trc or S001.trc, when I check these files they both point out that they are full, *** TRACE FILE FULL *** What should I do to get rid of this error, why does the error keep coming in this file when it is full? The error in alert is ORA-0600 [17182](pointing to S000.trc and S001.trc files) which is a memory area, I found from a few notes on Metalink that if I set the CURSOR_SHARED=EXACT instead of FORCE, I should be able to get rid of this problem as it is a bug in 8.1.7. I did just that and the problem subsided but today it appeared again, but surprisingly in only some of the scripts, and some scripts run just fine (initially none were functioning but some do now and some don't). I had changed this parameter for the session level, but didn't bounce the instance, should I bounce the instance? -Original Message- From: Jeremiah Wilton [mailto:[EMAIL PROTECTED]] Sent: Monday, January 13, 2003 4:19 PM To: Multiple recipients of list ORACLE-L Subject: Re: Trace file size... On Mon, 13 Jan 2003, BanarasiBabu Tippa wrote: > My SQL_TRACE is on for instance. For the whole instance? Usually, we only run SQL tracing for one or a few sessions at a time. Turning it on for the whole instance makes for a whole lot of tracing and greatly decreased performance. What are you trying to find out? > What will happen to trace file if it reaches MAX_DUMP_FILE_SIZE. > wether it is truncated? or it will start writing into another file? It will end the tracing to the file, and no new file will be started. There will be a message at the end of the file indicating it has reached the max file size. > Is there a way to recognize, which trace file belongs to which session? Unless you are running MTS/Shared Server, the trace output begins with something like: *** SESSION ID:(134.58553) 2003-01-13 09:11:02.501 That's SID.SERIAL# inside the parentheses. -- Jeremiah Wilton http://www.speakeasy.net/~jwilton -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jeremiah Wilton 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).
Trace File Full
Title: Trace File Full Hi all, We run an automated script for taking database backups. A third party tool is used to call the script which runs the export commands. The problem that we are facing is that when ever the script runs, it fails with the following error ORA-00600: internal error code, arguments: [17182], [1126948216], [], [], [], [], [], [] When i checked the alert logfile, it pointed out an error in a trace file, S000 and S001, along with the same Internal error code message. When I checked the Trace files they both bore the message several times, * TRACE FILE FULL * I truncated the trace files, but I am not sure if thats the right way. And still that command doesn't run. Are these two things related? and what is the way out of this Regards, Hussain
Database Load & Server Specs
Title: Database Load & Server Specs Hi all, I have three questions, would appreciate if any of you can help me on that, its important because I need these answers to support my claim of our server being over loaded. First is; is there query to find out the number of transactions at any time? V$transaction tells about the time the query has been running for, but how many transactions are running at peak time? Does the number of transaction have any bearing on what the server specification should be like? Second; what should be the specifications of a server, based on the size of the database or load? Are there any norms for this, or a matrix, which would help me see the specs based on load, or if any of you can share your experience? (Our environment is OLTP, round the clock, 24x7, size of the physical database is 15GB, and growing and the actual dump size is less though, around 5GB. We are using only one server, single processor 933MHz, 896MB ram, and 2 SCSI hard drives. Our application is module based, and since we made part of our last module online, the load has increased tremendously as it involves constant entry, reporting, and on screen viewing. I mean on WinNT, the CPU usage touches (for a few seconds thankfully) 100% every minute or two, which does make the system go a little slow every now and then. If the configuration seems ok, which parameters can I consider revising/increasing to enhance performance?) Third; since our is a critical hospital application, 24x7 environment, running on one server, with periodic Tape backups and one standby database, as our means to fall back on. Does that sound Ok? Or do we need a couple of servers, same specs, go for operating system clustering, with a storage unit housing a few Hard disks? I know it's a very long query, but would really appreciate if I can have some guidelines. Thanks and regards, Hussain DBA SKMCH&RC
RE: 100% CPU utilization, urgent
Title: RE: 100% CPU utilization, urgent Thanks for the script, I would like to know how would I interpret the VALUES column, I mean what does it stand for. If the value of CPU used for a particular SID is 2000, what does that mean? Is it the time, in 1/100 th of seconds of the total CPU time? Can you please help me understand this? Thanks and regards Hussain -Original Message- From: Thomas Day [mailto:[EMAIL PROTECTED]] Sent: Monday, January 20, 2003 7:00 PM To: Multiple recipients of list ORACLE-L Subject: Re: 100% CPU utilization, urgent Create the view dba_nt_threads and query it, then run the monitor CPU per session. These are not my scripts --- I'm pretty sure that they were posted here by others --- but I did not capture the information on who originally wrote them. My apologies. HTH --cr_dba_nt_threads.sql -- run as sys create or replace view dba_NT_threads as select p.spid "ID_THREAD", p.background "BACKGROUND", b.name "NAME", s.sid "SID", s.serial# "SERIAL#", s.username "USERNAME", s.status "STATUS", s.osuser "OSUSER", s.program "PROGRAM" from v$process p, v$bgprocess b, v$session s where s.paddr = p.addr and b.paddr(+) = p.addr; create public synonym dba_nt_threads for dba_nt_threads; create public synonym threads for dba_nt_threads; -- monitor CPU per session -- requires timed statistics on col sid format SELECT v.SID, SUBSTR(s.NAME,1,30) "Statistic", v.VALUE FROM V$STATNAME s, V$SESSTAT v WHERE s.NAME = 'CPU used by this session' AND v.STATISTIC# = s.STATISTIC# Hussain Ahmed Qadri @skm.org.pk> cc: Sent by: root urgent 01/20/2003 12:44 AM Please respond to ORACLE-L HI all We have a consistent problem of CPU utilization 100%. We have had this problem since Saturday, but it automatically subsided, I mean went back to normal after a few hours, and remained normal on Sunday as well. But its back to 100% since morning, that is when the load on the server has gone up again to 100% and over all work is non-existent. Our machine is Compaq Proliant ML350, 900 MB ram, 933 single Processor, Database size of roughly 5 GB. WINNT4.0, Oracle 8.1.7. I have checked the temporary tablespaces, they are normal. We have a 24x7 environment, a hospital, so please can you suggest the areas to look in to, its really very urgent. Regards, Hussain -- 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).
RE: Re: 100% CPU utilization, urgent
Title: RE: Re: 100% CPU utilization, urgent Hi, It's the Oracle.exe which is taking 100%. V$session tells me about the users connected to the database, but no the info about which user is taking what percentage of CPU. How can I identify which Oracle process (like DBSNMP or anyother) it is that is taking so much CPU? By the way, I have been able to solve the problem, by increasing the Large_pool_size and sort_area_size parameters, and thank to Allah, its working fine since then. Anything else that I should do in light of this? Regards, Hussain -Original Message- From: Stephane Faroult [mailto:[EMAIL PROTECTED]] Sent: Monday, January 20, 2003 1:29 PM To: Multiple recipients of list ORACLE-L Subject: RE: Re: 100% CPU utilization, urgent Hussain, Good advice. First thing to do is to identify WHICH process or thread is using CPU. Once you have an OS identifier, check V$SESSION to see what it is exactly. I would not have as dark a vision as Pankaj - I mean it is not necessarily a virus or Trojan horse. I have seen quite a number of Oracle processes (DBSNMP springs to mind, but it's not the only one) causing this type of behaviour, and there is most often an easy workaround. >- Original Message - >From: Pankaj Agarwal <[EMAIL PROTECTED]> >To: Multiple recipients of list ORACLE-L ><[EMAIL PROTECTED]> >Sent: Sun, 19 Jan 2003 22:48:53 > >Hi, > >Check the processes runnning and identify the >process >which i resulting in 100% CPU utilization. > >you can check it by pressing ctrl+shift+esc. There >will be a tab Processes. Under thi tab it will how >each process that i running on your machine. > >My own experience says it will a trojan or >something >like that which is cauing problem. > >Hope thi resolves your problem, Goodluck > >Pankaj > >--- Hussain Ahmed Qadri <[EMAIL PROTECTED]> wrote: > >> HI all >> We have a consistent problem of CPU utilization >> 100%. We have had this >> problem since Saturday, but it automatically >> subsided, I mean went back to >> normal after a few hours, and remained normal on >> Sunday as well. But its >> back to 100% since morning, that is when the load >on >> the server has gone up >> again to 100% and over all work is non-existent. > >> Our machine is Compaq Proliant ML350, 900 MB ram, > >> 933 single Processor, >> Database size of roughly 5 GB. WINNT4.0, Oracle >> 8.1.7. >> I have checked the temporary tablespaces, they >are >> normal. >> We have a 24x7 environment, a hospital, so please > >> can you suggest the areas >> to look in to, its really very urgent. >> >> Regards, >> >> Hussain >> -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Faroul 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: 100% CPU utilization, urgent
Title: RE: Re: 100% CPU utilization, urgent When it happens, it happens consistently, for hours, non-stop. I hope there is a way to find out this information about the operating system process. Thanks and regards Hussain -Original Message- From: Naveen Nahata [mailto:[EMAIL PROTECTED]] Sent: Monday, January 20, 2003 1:54 PM To: Multiple recipients of list ORACLE-L Subject: RE: Re: 100% CPU utilization, urgent In windows NT you cannot map the OS proces with v$session information. I hope there is a way to get the thread information and map it to V$SESSION, but in Task Manager it will only show as Oracle.exe for all the processes. If you find out how to get the thread information and map it to v$session, please let me know. But the question is, are you having a problem with 100 CPU utilization? Is it for short periods or it happens for long duration without much corresponding DB activity? Regards Naveen -Original Message- Sent: Monday, January 20, 2003 1:59 PM To: Multiple recipients of list ORACLE-L Hussain, Good advice. First thing to do is to identify WHICH process or thread is using CPU. Once you have an OS identifier, check V$SESSION to see what it is exactly. I would not have as dark a vision as Pankaj - I mean it is not necessarily a virus or Trojan horse. I have seen quite a number of Oracle processes (DBSNMP springs to mind, but it's not the only one) causing this type of behaviour, and there is most often an easy workaround. >- Original Message - >From: Pankaj Agarwal <[EMAIL PROTECTED]> >To: Multiple recipients of list ORACLE-L ><[EMAIL PROTECTED]> >Sent: Sun, 19 Jan 2003 22:48:53 > >Hi, > >Check the processes runnning and identify the >process >which i resulting in 100% CPU utilization. > >you can check it by pressing ctrl+shift+esc. There >will be a tab Processes. Under thi tab it will how >each process that i running on your machine. > >My own experience says it will a trojan or >something >like that which is cauing problem. > >Hope thi resolves your problem, Goodluck > >Pankaj > >--- Hussain Ahmed Qadri <[EMAIL PROTECTED]> wrote: > >> HI all >> We have a consistent problem of CPU utilization >> 100%. We have had this >> problem since Saturday, but it automatically >> subsided, I mean went back to >> normal after a few hours, and remained normal on >> Sunday as well. But its >> back to 100% since morning, that is when the load >on >> the server has gone up >> again to 100% and over all work is non-existent. > >> Our machine is Compaq Proliant ML350, 900 MB ram, > >> 933 single Processor, >> Database size of roughly 5 GB. WINNT4.0, Oracle >> 8.1.7. >> I have checked the temporary tablespaces, they >are >> normal. >> We have a 24x7 environment, a hospital, so please > >> can you suggest the areas >> to look in to, its really very urgent. >> >> Regards, >> >> Hussain >> -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Faroul 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: Naveen Nahata 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).
Server specifications
Title: Server specifications Hi all, Can anyone tell me if there is any general guide line or benchmark, which tells us that for running a certain number of transactions in a specified time, or for a certain size of DB, the Server Configuration should be like what? And what is the way of finding (through a query or any tool for it) the number of transactions on a system in a specified time. I have to convince my management that we need to upgrade our servers and I need such facts to back me up Any help would be appreciated. Regards, Hussain
100% CPU utilization, urgent
Title: 100% CPU utilization, urgent HI all We have a consistent problem of CPU utilization 100%. We have had this problem since Saturday, but it automatically subsided, I mean went back to normal after a few hours, and remained normal on Sunday as well. But its back to 100% since morning, that is when the load on the server has gone up again to 100% and over all work is non-existent. Our machine is Compaq Proliant ML350, 900 MB ram, 933 single Processor, Database size of roughly 5 GB. WINNT4.0, Oracle 8.1.7. I have checked the temporary tablespaces, they are normal. We have a 24x7 environment, a hospital, so please can you suggest the areas to look in to, its really very urgent. Regards, Hussain
Safe Database Environment
Title: Safe Database Environment Hi all, Can any of you suggest the configuration for a safe, fault proof, and minimum downtime Database environment? (In terms of how many servers, RAID or disk ARRAY or any combination. A minimum configuration is what I am looking for). Right now we have one main server (Compaq proliant) and one standby database. But since the log switch takes place after about 10-15 minutes in the peak time and 30-40 minutes in not so peak time, plus our environment is 24x7, so if anything goes wrong with the production DB, it will take sometime to get back live and then some further time to catch up or redoing those entries which were lost because of no log witch. Hence even a downtime of few minutes brings the work to a halt plus any loss of data in between the archiving time is costly too. So I want to suggest to our management a solution, which is as close to being fool-proof, if one server is down the other system can take its place in matters of minutes or seconds, and better if it is transparent to the user, or close. Thanks & regards, Hussain
RE: Import from FoxPro to Oracle
Title: RE: Import from FoxPro to Oracle
Well at least this means that it can be done. But aren't there any tools like "Oracle Migration Work bench" or the "Oracle Migration Assistant for Access" . The odbc of WIn2000 doesn't support .dbf files, it goes to .DBC for visual foxpro. So is there any possibility of simplifying the import procedure?
-Original Message-
From: Stephane Faroult [mailto:[EMAIL PROTECTED]]
Sent: Friday, November 15, 2002 5:33 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: Import from FoxPro to Oracle
> Hussain Ahmed Qadri wrote:
>
> Hi ALL,
>
> Can WE IMPORT DATA from DBF files of Fox Pro into Oracle 8.1.7.
> If yes how.
>
> TIA
>
> Hussain
I have done something of the kind in the past by writing a program
taking a .dbf file on its standard input and writing a control file
including the data to its standard output, which was then awfully easy
to load. I no longer have the program but it took about half a day to
write, including the search on the internet to find out what the
structure of a .dbf file is, because I had no idea about it. The only
tricky thing I remember is that I wrote it to run on both Solaris and
Tru64 and in one case (Solaris, I think) some bytes had to be swapped
('man swab').
--
HTH,
Stephane Faroult
Oriole Software
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Stephane Faroult
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).
Import from FoxPro to Oracle
Title: Import from FoxPro to Oracle Hi ALL, Can WE IMPORT DATA from DBF files of Fox Pro into Oracle 8.1.7. If yes how. TIA Hussain
RE: Oracle taking 100% CPU
Title: RE: Oracle taking 100% CPU The CPU becomes normal after the database is shutdown. So it's Oracle that is causing problems. I thought that it would be some rollbacking and roll-forwarding going on but, since morning, I don't think so. So I have some clues that it has something to do with Temporary tablespace as it had gone up to 10GB and all of it was being used. Although now temporary TS is down to 50% usage but smon is taking hell of a long time to clean up, don't you think. So that's why, as per my discussion with Regis, I have created another temporary tablespace and assigned it to all the users and trying to drop the old temporary tablespace, but haven't had much luck with it. Any ideas -Original Message- From: DENNIS WILLIAMS [mailto:[EMAIL PROTECTED]] Sent: Tuesday, November 12, 2002 5:29 PM To: Multiple recipients of list ORACLE-L Subject: RE: Oracle taking 100% CPU Hussain - Once you clear up some archive space, Oracle will resume immediately. You don't need to bounce the database. What is the system doing besides taking 100% cpu? W2K Task Manager offers much more information, like I/O activity and CPU by process. This may provide more clues. Normally Oracle will take care of itself without intervention. My first thought is that you had a lot of pending work since it couldn't archive. Then you killed sessions which means Oracle must roll back transactions. Offhand it sounds like Oracle is still recovering. Look for heavy disk activity. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, November 12, 2002 4:19 AM To: Multiple recipients of list ORACLE-L HI all, We have a development server, a replica of the production. Some process produced a lot of archives and it ran out of archiving space. Now it was the only location specified for the archives and it was mandatory. So when no space was left on it to store the newly produced archives, it should have stopped working. But it didn't. I deleted the archives and closed every session and shut down the database and restarted it. But eversince I restarted it, (and I have done it 3-4 times already) Oracle is using 100%CPU. I have left the server on, without any body connecting to it, (users can connect as the database is OPEN without any problem, its just some transaction-cleaning or background process which is going on) but the server remains unchanged i.e. using 100% for over an hour (after an hour I shut it down and restarted and it still is the same) There is no unusual entry in the alert lofile or any trace files. I can't do any query to find out anything, as the system is so slow. There is no problem of space either. "Event viewer" of Win2000 also shows nothing unusual or new. Any ideas, its somewhat urgent. Hussain -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- 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).
Oracle taking 100% CPU
Title: Oracle taking 100% CPU HI all, We have a development server, a replica of the production. Some process produced a lot of archives and it ran out of archiving space. Now it was the only location specified for the archives and it was mandatory. So when no space was left on it to store the newly produced archives, it should have stopped working. But it didn't. I deleted the archives and closed every session and shut down the database and restarted it. But eversince I restarted it, (and I have done it 3-4 times already) Oracle is using 100%CPU. I have left the server on, without any body connecting to it, (users can connect as the database is OPEN without any problem, its just some transaction-cleaning or background process which is going on) but the server remains unchanged i.e. using 100% for over an hour (after an hour I shut it down and restarted and it still is the same) There is no unusual entry in the alert lofile or any trace files. I can't do any query to find out anything, as the system is so slow. There is no problem of space either. "Event viewer" of Win2000 also shows nothing unusual or new. Any ideas, its somewhat urgent. Hussain
RE: OT- Improving server performance
Title: RE: OT- Improving server performance Hi Stephane, I'll double-check the stats from the queries you mentioned and then decide about the location of datafiles. Thanks for the useful info. Regards, Hussain -Original Message- From: Stephane Faroult [mailto:[EMAIL PROTECTED]] Sent: Sunday, November 10, 2002 3:43 PM To: Multiple recipients of list ORACLE-L Subject: Re: OT- Improving server performance > Hussain Ahmed Qadri wrote: > > Hi > > Would moving the temporary tablespace, rollback tablespace and Archive > files location to a hard drive other than the hard drive which > contains the datafiles, improve performance of the server? > > Index and Datafiles are already placed on different hard drives. So > was wondering if I move these to different controllers as well, will > that be of any help in performance upgrade? > > What is the best combination? > > Thanks and regards, > > Hussain Hussain, As has already been discussed on this list, what improves performance is not moving such or such thing elsewhere - it's spreading I/Os. What is usually advised (typically, having a dedicated drive for log files or such things) are general guidelines. What you aim for is not having one drive working like mad while all others are idle, which would be a poor allocation of resources. Start with OS monitoring to determine how much is written to each disk per unit of time. Then check V$LOG, V$LOG_HISTORY and V$SYSSTAT to gather information about how much redo log files (and their archiving) contributes to this. Then check V$FILESTAT for data, index, rollback and temporary tablespaces. Once you have a good idea of where I/Os come from, it's like a Tetris game. And you are perfectly right about controllers, there is no real point in having many disks if a single controller is a bottleneck. -- Regards, Stephane Faroult Oriole Software -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult 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).
OT- Improving server performance
Title: OT- Improving server performance Hi Would moving the temporary tablespace, rollback tablespace and Archive files location to a hard drive other than the hard drive which contains the datafiles, improve performance of the server? Index and Datafiles are already placed on different hard drives. So was wondering if I move these to different controllers as well, will that be of any help in performance upgrade? What is the best combination? Thanks and regards, Hussain
Adding more space to server
Title: Adding more space to server Hi all, We are running out of space on our server and I was going to add another hard disk to it. I had thought about somewhat crude but easy way to go about it. Since I can afford to shutdown my database for a couple of hours tomorrow, I thought that I would shutdown the database, move some datafiles to other partitions, redefine the partitions as to increase their size (WinNT 4 and Oracle 8i) and then move back the datafiles and then start the database. This way I would have more space to accommodate any increase in size of the datafiles and not worry about changing any of the database complexities (plus more space for the archives generated, as the database is in archive mode). Neither the control file nor any of the parameters would have to be changed as no change in location took place. Is there anything wrong in this method? What could be the other options, if any? Anything else that I need to keep in mind? Thanks and regards, Hussain Ahmed Qadri DBA SKMCH&RC
RE: Relation Between Oracle Sessions
Title: RE: Relation Between Oracle Sessions Hi Justin, We have our application in the form of a menu, with all the different modules written on top in the form of menus. Now with call-form property (which we use now in our application), only one form can be opened as the menu is disappeared from the top and is only made visible when that particular form is closed and this results in only one initial session. (Although by passing a parameter to call-form property of form, we can still tell Oracle to open this form in another session, other than the initial session). But when we use the Open-form property in forms, then every form that is opened from with in the application is opened in another session. Menu is there at the top and even if one form is open, you can use the menu and open another form or module. So in my opinion that's not a bug but an Oracle property. And it's this newly opened session (if we use the open-form property) from with in the main application, whose relation to the session of the main application I wanted to know. You might be absolutely right that Oracle doesn't keep track of the so-called parent-child relation ship of sessions, so I wanted to know if there was any indirect method, like from some views or something that can help me track that relationship. If there is something that is confusing, please let me know. Thank you for your time. Regards, Hussain Ahmed Qadri DBA SKMCH&RC -Original Message- From: Justin Cave [mailto:[EMAIL PROTECTED]] Sent: Tuesday, November 05, 2002 11:03 AM To: Multiple recipients of list ORACLE-L Subject: Re: Relation Between Oracle Sessions 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 called from within it as its >child form, then, IS there a way to know, from some view or else, that >session of this newly opened form is the child of which parent session, >their relationship basically? I believe the simple answer here is "no". If your application is opening multiple sessions, each session is logically independent of the other-- Oracle has no concept of "parent" or "child" sessions. I would generally take this sort of behavior to indicate a bug in your application-- generally one wants to reuse connections across multiple forms so that each form doesn't have the overhead of opening a new connection to the database. Justin Cave Distributed Database Consulting -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Justin Cave 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).
Relation Between Oracle Sessions
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 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 called from within it as its child form, then, IS there a way to know, from some view or else, that session of this newly opened form is the child of which parent session, their relationship basically? Thanks in advance Hussain Ahmed Qadri DBA SKMCH&RC Pakistan
Standby DB - confusion
Title: Standby DB - confusion Hi all, Can anyone shed some light on the following entries of the Alert log file? This appears when an archive is copied to the standby database and although archiving is complete, this message still appears. The alert log file of the standby database doesn't show any unusual entry. Error 12571 is ora-12571 I think which is the "TNS:packet writer failure" , it is something I didn't understand, otherwise Standby's alert should have shown something or some error. Plus the same archiver process completes archiving too in the same time span. Any thing I need to know here. ARC1: Beginning to archive log# 1 seq# 53632 ARC1: Error 12571 detaching RFS from standby instance at host 'STBY' ARC1: Completed archiving log# 1 seq# 53632 Sometimes the following entry appears as well. ARC0: Beginning to archive log# 4 seq# 53574 ARC0: RFS network connection lost at host 'STBY' ARC0: Error 3113 detaching RFS from standby instance at host 'STBY' ARC0: Error 16009 attaching RFS server to standby instance at host 'STBY' ARC0: Error 16009 creating archivelog file 'STBY' ARC0: Completed archiving log# 4 seq# 53574 And again archiving is completed. Would appreciate your input Thanks and regards, Hussain
Failed to archive log....
Title: Failed to archive log Hi all, I just wanted a little insight on the following entries of my alert log file; --- ARC0: Beginning to archive log# 3 seq# 51809 ARC0: Failed to archive log# 3 seq# 51809 Tue Oct 01 09:32:37 2002 ARC4: Beginning to archive log# 3 seq# 51809 ARC4: Failed to archive log# 3 seq# 51809 ARC4: Beginning to archive log# 4 seq# 51810 Tue Oct 01 09:32:37 2002 ARC0: Beginning to archive log# 4 seq# 51810 ARC0: Failed to archive log# 4 seq# 51810 Tue Oct 01 09:32:40 2002 Completed checkpoint up to RBA [0xca62.2.10], SCN: 0x.02bfbd05 Tue Oct 01 09:32:41 2002 ARC3: Completed archiving log# 3 seq# 51809 --- ARC0 failed to archive log seq#51809 at first, then ARC4 tried to archive the same log seq# and it failed again but then the same archiver process (ARC4) started archiving next seq# and failed again. After a few seconds ARC0 successfully archives 51809. Similarly rest of the seq# get archived to after a few tries by one archiver or the other. This behavior is not regular, it appears off and on, most of the times there is no failing, and everything proceeds normally. I was wondering if any of you can explain the following points to help improve my concepts, * Is FAILING temporarily any threat? * What could be the reason for it? * If the first archiver fails (ARC0) and then the second (ARC4) fails too, why does it try to archive the next seq# rather than finishing the previous one? * Any reason for this inconsistency? Thanks & Regards, Hussain Ahmed Qadri DBA SKMCH&RC
9iAS - Error WTE-03503
Title: 9iAS - Error WTE-03503 During the installation of 9iAS on my system, with Origin DB residing on the same machine as the APP Server (as this is a trial installation, will shift to the appropriate arrangement once its all ok&tested), I am facing a problem in installing the Database cache. It got stuck at 96% with the error that Can't import users. I found this document on Metalink which said the workaround for this is to "use DBA studio and import users/sync users option". Can anyone explain this in more detail. I tried to launch DBA studio (the one which comes with Isuite and not the DBA studio of Oracle 8i-Origin DB- installed on the same machine) and for import it required Management server to be configured, which I did. But now when I try to launch DBA studio with the Management server option, it requires a username & password with the newly added management server name written in the management server field. Which username would it be. What can be the problems with wte-03503, and possible solutions for that. Regards, Hussain Ahmed Qadri DBA Shaukat Khanum Memorial Cancer Hospital And Research center
Oracle and Character formatting
Title: Oracle and Character formatting Hello All, We want some text to be stored in our database, entered through a Dev6 Form. Is it possible that formatted data can be stored in the database in the form it is written, i.e. with different fonts or special characters or numeric values with power ( 5x102 - where 2 is the superscript of 10, as in MS Word terminologies). If we give MS word as the editor for the Forms entry screen and save the data in any of the above formats, Will the data, when retrieved, be in the same format as it was entered. Or would it convert in ASCII and later display a simple value rather than the formatted one. Is there any way to do such a thing. Would appreciate any advice on it. Oracle 8.1.7, WINNT4 Hussain Ahmed Qadri DBA Shaukat Khanum Memorial Cancer Hospital and Research Center Lahore Pakistan
Standby Database-No space on Disk
Title: Standby Database-No space on Disk Hello All Oracle 8.1.7, WINNT4. On our standby Database box, we have run out of space on the partition which was holding the Temporary tablespace. Now the problem is that when ever I try to start the recovery, it gives the message that there is no space on the disk. How would I add another datafile to the temporary tablespace? Database is a standby databse with the controlfile for the standby database. Is there a simple way to add a datafile to the tablespaces on a standby database. Or should I shutdown the database, move the datafile to another partition, repartition this old-temporary partition by adding more space to it. And then copy that temporary-datafile back to this old partition and startup the database for the Standby mode. Would appreciate any prompt suggestions. Regards, Hussain Ahmed Qadri Database Administrator Shaukat Khanum Memorial Cancer Hospital & Research Centre [EMAIL PROTECTED] www.shaukatkhanum.org.pk
Stanby Database- Archive Transfer Problem
Title: Stanby Database- Archive Transfer Problem Oracle 8.1.7 and WINNT4 Our Standby database was running smoothly but due to some reasons we had to reconfigure it. We have used the same init parameter file which we used earlier(to have the exact parameters). The standby database was configured alright but this time logs are not properly getting transfered to the standby database, I mean every 3rd or 4th archived log file doesn;t get transfered and is missed. Our 4 redo logs are 1mb and block size is 8192, Log_checkpoint_interval = 1 (the default) and log_checkpoit_timeout = 600 Archive processes are 10(this we had increased to 5 the last time to counter the missin files on our standby database,and it worked fine,but this time we have increased from 5 to 10 and its not) and the view v$Archive_dest shows that both primary and standby database locations are valid. Average time for log switch, under normal conditions, is roughly 12-15 mins, but for some reasons it starts getting missed after a regular transfer of 3-4 archive files. Our network is 10Mbps and is sllow off and on. What could be the reason for the delay. Hussain Ahmed Qadri Database Administrator Shaukat Khanum Memorial Cancer Hospital & Research Centre [EMAIL PROTECTED] www.shaukatkhanum.org.pk
MTS Question
Title: MTS Question MTS configuration, 8.1.7, NT4 Is there anything wrong when we have a negative value, exponential in nature(e.g. -1.838E+09), in the BYTES column of V$SHARED_SERVER. The bytes column shows the total number of bytes in all messages that have been processed by a particular server. Just to give an idea, given below is an example row NAME STATUS MESSAGES BYTES -- -- S001 EXEC 6903137 -1.838E+09 The value of status column is switching between Exec(meaning this server is executing a SQL) or WAIT (common)(meaning its idle)... Does any of this help in explaining the effect of -ve value. Regards, Hussain Ahmed Qadri Database Administrator Shaukat Khanum Memorial Cancer Hospital & Research Centre [EMAIL PROTECTED] www.shaukatkhanum.org.pk
Standby Database Problem
Title: Standby Database Problem Hi While trying to install developer6 on our standby database test server (OS NT4, Oracle 8.1.7), I have some how corrupted the 8i, and hence the standby database is not working. Its actually the Oracle Suite tools which are not working. I am going to configure it again, that is install the Oracle8i again. But what I want to know is that do I have to copy the datafiles from the main server again and recreate the control file. Or just reinstall the oracle database, copy the archive redologs, which are missing, apply them and then mount the standby database in recover managed mode with the existing Datafile copies? The reason I am asking this is that the configuration of database is not changed nor the database has been brought from standby to active mode, just registry entries have been changed/deleted becuase of selecting a different home for Developer6 (Thats another problem that after installing Oracle 8i, when u want to install Dev6,it doesn't allow installation in the same Oracle home and neither in a separate home, but if you try it again in a separate home, like I did, it removes the entries of first Oracle home, so no Oracle 8i! ) So in such case WHAT happens to the STAND BY Database??? Looking forward to your replies Regards, Hussain Ahmed Qadri Database Administrator Shaukat Khanum Memorial Cancer Hospital & Research Centre [EMAIL PROTECTED] www.shaukatkhanum.org.pk
Updating a non-Oracle DB using Oracle
Title: Updating a non-Oracle DB using Oracle Hi, We want to update/insert a table made in foxpro/Clipper using Oracle SQL. We can select from such a table using heterogeneous services of Oracle8i, but we were not able to update them. Is there a way we can do that, using ODBC, heterogeneous services or any better way ? Regards, Hussain Ahmed Qadri Database Administrator Shaukat Khanum Memorial Cancer Hospital & Research Centre [EMAIL PROTECTED] www.shaukatkhanum.org.pk
RE: Table Lock
Try creating indexes on the foreign key columns, in the child tables. Hussain Ahmed Qadri Database Administrator Shaukat Khanum Memorial Cancer Hospital & Research Centre [EMAIL PROTECTED] www.shaukatkhanum.org.pkHussain Ahmed Qadri Database Administrator Shaukat Khanum Memorial Cancer Hospital & Research Centre [EMAIL PROTECTED] www.shaukatkhanum.org.pk -Original Message-From: Arvind Kumar [mailto:[EMAIL PROTECTED]]Sent: Wednesday, February 13, 2002 3:29 PMTo: Multiple recipients of list ORACLE-LSubject: Table Lock Hi, i am running Oracle 8.1.6 on RedHat 6.1 , the problem is one of my Table is getting locked and not getting unlocked until i kill the session. the users r reporting that they r not using anything which may lock this table , Regards Arvind
Standby Databse Problem
Title: Standby Databse Problem Hi, --Winnt 4.0, Oracle 8.1.7.--- We have slight problem with our Standby Database Configuration. All the archives from our Primary Database are not being copied to the Standby Database. When the archives are generated at a normal time, i.e after after a gap of 15-20 minutes ( which is normal, as our logfile size is 500K and it works fine with our normal database behaviour) , the archives get copied completely to the standby site. But due to a few jobs that run over night, the log switch happens very fast,a few times per minute. This kind of fast switching also happens incase of bulk insert or delete. Its in such cases that some of the archive logs are not copied to the standby site. To counter that, we increased the number of archiver processes from 1 to 4 on the Primary site, and when it didn't entirely solve our problem, we increased it to the maximum, i.e is 10. Even now all the archives are not being copied because of the quick switching of logs. Keeping the archiver processes to 10 is also a burden on the resources. Moreover, the second destination for writing archives(standby DB) is optional, and the value for log_archive_min_succeed_dest is set to 0. I am not sure increasing this or changing the site from optional to mandatory would solve the problem. Or would that have any effect? The other thing is that since the problem lies with the files not being copied from one site to the other, so it should not directly have anything to do with the Archiver processes, as server is generating archives properly. But on increasing the number of archiver processes, less number of files were not copied to the standby site, so it did help. Is there something we are missing here. Any help would be appreciated. Regards, Hussain Ahmed Qadri Database Administrator Shaukat Khanum Memorial Cancer Hospital & Research Centre [EMAIL PROTECTED] www.shaukatkhanum.org.pk
IFRUN60_dump_*
Title: IFRUN60_dump_* Hi all, We have been experiencing this error "IFRUN60_dump_somenumber" for quite some time now. This occurs when we try to open a form through a menu that we have locally developed to support our application. MOst of the times this file doesn't even exist in the directory where the error shows, infact its nowhere in the server. But this file then develops in the server in a day or two. And once we delete them, the error disappears. But this is a constant problem as they appear on different forms, and often creates problems for our front end users. We are using Developer6 on WINNT4, along with Oracle8i. Is it an error related to Forms Runtime, or the Menu. Any ideas and solutions? Regards Hussain Ahmed Qadri DBA SKMCH & RC
Oralce 8i/9i with Pentium4
Title: Oralce 8i/9i with Pentium4 Hi all, AOA A colleague of mine spent days getting Oracle 8i/9i installed on Pentium 4. It never opened the universal installer initially, but then through some work arounds (dumping the un-installed Oracle8i on the hard drive and running the setup from there) he was able to do that. But now once he has the Oracle installed, he can't create a Database, no matter what he tried, he couldn't do it. Operating system he is using is Linux. I remember some discussion about this in the LIST, but what I want to know is whether P4 really has some problems with Oracle 8i, especially on Windows NT4 platform, becuase this is what we are using in our organization and we have ordered 60 new PCs (all P4s )to be setup in our hospital. All these systems will be using Oracle 8i (9i in future) on NT4, so I wanted to be sure before we go on with this. Representatives from the Intel company said that this is an Oracle problem and "dumping the un-installed Oracle8i on the hard drive and running the setup from there" is a solution given by the Oracle Company. Any body with a complete knowledge??? Thanks and Regards, Hussain Ahmed Qadri DBA SKMCH & RC
Temporary Tablespace Logging Problem
Title: Temporary Tablespace Logging Problem Hi all, Is there a way to alter a TEMPORARY table space to Logging from NoLogging. I issue the command, ALTER TABLESPACE TEMPORARY LOGGING; The same command holds good for every other tablespace except for Temporary. I need to this because I wanted to setup the Standby database and was trying to copy the datafiles from the primary site to the Standby site, Online. For that I had put every tablespace in BEGIN BACKUP mode but Temporary couldn't be taken to the Backup Mode becuase of its Nologging attribute. The work around is to create another temporary tablespace and change every users default temporary tablespace to the new one and then drop this one and create a new Temporary file withthe same name. (or shutdown the database and then copy this file tothe other system) THis I will do becuase of the entry in the control file with the name for the Temporary tablespace. But if there is a way the tablespace can be altered to logging, it will save quite some time. The tablespace is Locally Managed, and with Uniform Storage allocation. (Oracle 8.1.7 on WINNT4) Regards Hussain DBA SKMCH & RC
