RE: Datatype conversions
This should be helpful,
SQL create table tt1 (c1 varchar2 (30));
Table created.
SQL insert into tt1 values ('123,50');
1 row created.
SQL insert into tt1 values ('44567,9');
1 row created.
SQL insert into tt1 values ('1,23456');
1 row created.
SQL commit ;
SQL select * from tt1 ;
C1
--
123,50
44567,9
1,23456
SQL l
1 select to_number ( substr(c1,1,(instr(c1,',')-1))||'.'||
2 substr(c1,(instr(c1,',')+1),length(c1))
3 ) converted_number
4* from tt1
SQL /
CONVERTED_NUMBER
123.5
44567.9
1.23456
SQL create table tt2 (c1 number (15,5));
Table created.
SQL insert into tt2 value (select to_number ( substr(c1,1,(instr(c1,',')-1))||'.'||
2 substr(c1,(instr(c1,',')+1),length(c1))
3 ) converted_number
4 from tt1)
5 /
3 rows created.
SQL commit;
Commit complete.
SQL select * from tt2 ;
C1
--
123.5
44567.9
1.23456
SQL
HTH,
Rajesh
Rajesh Dayal
Senior Oracle DBA (OCP 8,8i,9i)
International Information Technology Company LLC
-Original Message-
Sent: Monday, November 03, 2003 4:30 PM
To: Multiple recipients of list ORACLE-L
Subject:Datatype conversions
Hallo,
Maybe this sounds simple for all of you, but I have a table with the field
PRICE and that is with datatype varchar2 I want the data in that field to be
inserted in another table with field PRICE, but that field has the datatype
NUMBER. How can I
easiest do this sql statement?
In the varchar2(30) field PRICE , table1 it looks like this
PRICE
12,50
37,50
The datype in table 2 is for that field NUMBER(7,2)
Roland
--
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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Rajesh Dayal
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: [ORA-000060: Deadlock detected] Finding BOTH pieces of code that
Hi Branimir, Two Suggestions: 1. This looks like having an issue with foreign key indexes. You can check for foreign keys and their indexes for tables having objects-id 17786 (457a)and 17775 (4571). If any of the columns of these two tables have foreign key relationship with other tables then probably you need to create one index on that column. 2. Another suggestion is to check initrans/maxtrans and PCTFREE parameter. If these are very low and number of concurrent updates are higher then you need to increase these values. I know you are not considering this as an option, but this might help in this case. In fact you can't change these parameter for existing data blocks. So you can re-load your data with these parameters in effect. Of course we have Gurus here who can add more inputs to this and correct me as well if found to be wrong. HTH Rajesh Dayal Senior Oracle DBA (OCP 8,8i,9i) International Information Technology Company LLC -Original Message- Sent: Tuesday, November 04, 2003 1:39 AM To: Multiple recipients of list ORACLE-L Subject:Fwd: [ORA-60: Deadlock detected] Finding BOTH pieces of code that I realize ORACLE-L could not be the best place to ask this question but (googling/metalink-ing did not help overly)... ORA-60 happens in our own application in the worst of possible places - at the customer's site. It happens intermittently. All I can do is look at the alert log for errors and follow the trail to the extremely verbose trace dumps and wonder. Clearly - I am over my head here as I have very little clue of what am I actually looking at. The question is how to interpret what trace dumps tries to tell (should I be scratching my head with it or is there some kind of magic behind TAR that would save the day)? For instance - what is the meaning of this trace snippet (coming from 8.1.7.x): Deadlock graph: -Blocker(s) -Waiter(s)- Resource Name process session holds waits process session holds waits TM-457a-24 37SX 17 14 SSX TM-4571-17 14 SSX 24 37 SX session 37: DID 0001-0018-0002 session 14: DID 0001-0011-0002 session 14: DID 0001-0011-0002 session 37: DID 0001-0018-0002 Rows waited on: Session 14: no row Session 37: no row On the assumption that the source of the above problem has nothing to do with INITTRANS/PCTFREE combo (as per metalink thread # 247579.999) but the culprit really is the broken app - what would be the 'proper' way to find which two pieces of code deadlocked each other? What comes to my mind ain't a pretty sight - turning on sql tracing on the database level (and suffering worsened performance), then once error happens finding out exact time from alert log, converting it to matching TIC number in 3 sec range (if I understand correctly Oracle will detect and break deadlock after 3 seconds). Once this range is known for 3 sec. window, digging through session traces would reveal what were other sessions doing at the time may be narrowing down the search to few possible sources of contention. Problem with this approach is way too much work to set up then 'dig' through all (tons of) trace files without any real guarantees source of deadlocking would be obvious after all this effort. So the question is - how to help duhveloper(s) by pointing closer to the 'root' of deadlocking? Branimir -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Branimir Petrovic 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: Rajesh Dayal 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: char(1) VS varchar2(1)
Extremely precious info. Thanks a lot for sharing this !!! Rajesh Dayal Senior Oracle DBA (OCP 8,8i,9i) International Information Technology Company LLC -Original Message- Sent: Monday, November 03, 2003 7:14 AM To: Multiple recipients of list ORACLE-L Subject:Fwd: Re: char(1) VS varchar2(1) Trailing columns with NULL values do not occupy any space, not even a length byte. Non-trailing columns with NULL values have a constant value of 0xFF (255) in the length byte consuming just the one byte. Column values with a length of 0-254 bytes have one length byte, and values with a length greater than 254 bytes have 3 bytes, where the first byte is the constant 0xFE (254) and the remaining 2 bytes actually have the length. For example: = SQL create table xyz 2 ( 3 c1 number, 4 c2 number, 5 c3 number, 6 c4 number, 7 c5 number 8 ) tablespace tools; Table created. SQL insert into xyz values (1, null, 1, null, 99); 1 row created. SQL insert into xyz values (2, null, 2, null, 99); 1 row created. SQL select dump(c1) c1, dump(c2) c2, dump(c3) c3, 2 dump(c4) c4, dump(c5) c5 from xyz; C1 C2C3 C4C5 --- - --- - - Typ=2 Len=2: 193,2 NULL Typ=2 Len=2: 193,2 NULL Typ=2 Len=4: 195,100,100,100 Typ=2 Len=2: 193,3 NULL Typ=2 Len=2: 193,3 NULL Typ=2 Len=4: 195,100,100,100 SQL select file_id,block_id,blocks from dba_extents where 2 segment_name='XYZ'; FILE_ID BLOCK_ID BLOCKS -- -- -- 2 5857 8 SQL commit; Commit complete. SQL alter system checkpoint; System altered. = OK, the checkpoint made sure that everything was flushed to the datafile. Now, we can look at things using the UNIX od command: $ dd if=/u01/oradata/PRD/tools_02.dbf bs=8192 skip=5858 count=1 | \ = od -x 000 0602008016e2002f5a390104 020 08090100217b002f5a03 040 90e4000203000008002f 060 048b01000040056416000002 100 120 00010002 140 00161f801f6a1f6a00021f90 160 1f80 200 * 0017720 2c010502 0017740 c103ff02c103ff04c36464642c010502 0017760 c102ff02c102ff04c36464645a390601 002 OK, now remember that data rows fill from the end of the block, working backwards, not from the beginning. So, at the end of the block, we see the 4-byte block tailer (5a39 0601). Just before that, we see the first row: 2c 01 05 02 c1 02 ff 02 c1 02 ff 04 c3 64 64 64 +++--++--+--+ row hdr c1 c2 c3 c4 c5 Then, just prior to that, we see the second row: 2c 01 05 02 c1 03 ff 02 c1 03 ff 04 c3 64 64 64 +++--++--+--+ row hdr c1 c2 c3 c4 c5 The third byte (0x05) of each row indicates that five columns comprise the row. The numbers are represented in 100s-complement which is a form of base-100 arithmetic. For column C1, the first byte (hex 0x02) is the length byte. The next byte (hex 0xC1 or decimal 193) is both the sign and the exponent, while the next byte (hex 02 again) is the mantissa or significant digits in 100s-complement. To avoid a value of 0x0, they add one to the value, so the value of 1 is represented as 0x02. So in the first row, the value of 1 in column C1 is shown by the three bytes 0x02c102. The null value in column C2 is shown by the one byte 0xff. The value of 1 in column C3 is shown by the three bytes 0x02c102. The null value in column C4 is shown by the one byte 0xff. The value of 99 in column C5 is shown by the five bytes 0x04c3646464. -Tim on 11/2/03 4:44 PM, Tanel Poder at [EMAIL PROTECTED] wrote: Hi! Just for the record, every column in a table has a length byte (or three, depending on column size). This works so even in clusters, where rows are split vertically, but column structures remain the same. Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, October 31, 2003 7:04 PM I have believed for a while that a varchar2(1) would have included a 'length byte', making it more wasteful of storage than a char(1) but in fact the two are strictly identical storage-wise : SQL create table t(c1 char(1), 2
RE: Oracle Press OCP exam guide frustrations
Try out self study materials from http://www.selftestsoftware.com they are simply outstanding. I have always found them helpful for all my exams. But at same time I never totally rely on them, I first complete my ground work with standard syllabus (available on Oracle OCP site) and Oracle Documentation then only I Open them ;-). HTH, Rajesh Dayal Senior Oracle DBA (OCP 8,8i,9i) International Information Technology Company LLC -Original Message- Sent: Tuesday, September 16, 2003 2:14 PM To: Multiple recipients of list ORACLE-L Subject:Fwd: Oracle Press OCP exam guide frustrations All, I just purchased a Oracle9i Fundamentals I exam guide published by Oracle Press and am very disappointed with the quality of the publication. There seems to be quite a few mistakes, misleading sentences and typos (not in the Errata) which is very frustrating. Also, there is a question in the Managing Tablespaces and Datafiles chapter that replies on the order of the multiple-choices, however the quiz software randomises the choices so the question no longer makes sense - and is impossible to answer as presented. For those that have completed the OCP exam, is this what I am to expect? Does anyone know of any other resources I might be able to use? How are the OCP exam guides published by Sybex? Any help would be greatly appreciated. Regards, Craig. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Craig Munday 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: Rajesh Dayal 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: SQLPLUS on UNIX
Hi Rajuveera, Put these two lines in your .profile EDITOR=vi export EDITOR HTH, Rajesh Rajesh Dayal Senior Oracle DBA (OCP 8,8i,9i) International Information Technology Company LLC -Original Message- Sent: Saturday, September 13, 2003 11:09 AM To: Multiple recipients of list ORACLE-L Subject:Fwd: SQLPLUS on UNIX Dear Friends, ed command in SQLPLUS( on UNIX ports )not working. I hope there is some EDITOR setting to use VI editor, but forgot where to do that. Can somebody give a thought. Thanks Rajuveera ** This email (including any attachments) is intended for the sole use of the intended recipient/s and may contain material that is CONFIDENTIAL AND PRIVATE COMPANY INFORMATION. Any review or reliance by others or copying or distribution or forwarding of any or all of the contents in this message is STRICTLY PROHIBITED. If you are not the intended recipient, please contact the sender by email and delete all copies; your cooperation in this regard is appreciated. ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Veeraraju_Mareddi 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: Rajesh Dayal 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: _cpu_count vs cpu_count
_cpu_count As per metalink, meant for those exceptional Operating Systems, where OS does not support a system call so that Oracle can get the number itself. So normally this value is not required to be set by DBAs. You have to set this when cpu_count is not showing the actual number of CPUs. HTH, Rajesh Rajesh Dayal Senior Oracle DBA (OCP 8,8i,9i) International Information Technology Company LLC -Original Message- Sent: Friday, September 12, 2003 8:34 PM To: Multiple recipients of list ORACLE-L Subject:Fwd: _cpu_count vs cpu_count Hi! I just noticed that there's two parameters in 9.2, cpu_count (which defaults to number of CPUs OS says), but what is _cpu_count? It seems to be independent from cpu_count defaults to zero on my machine... Tanel. -- 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: Rajesh Dayal 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: test
I am really happy to see such responses for my test !! BTW, I was just checking whether I have successfully been un-subscribed for my old mail-id and subscribed with new one. But disappointed to see that un-subscription mail reached much later than test Mail (which actually I sent before). And yes, will silently be watching the testG launch through net. My Damagement Doesn't think it's worth attending these launches. ;-(( Regards, Rajesh Dayal Senior Oracle DBA (OCP 8,8i,9i) International Information Technology Company LLC -Original Message- Sent: Sunday, September 07, 2003 11:14 AM To: Multiple recipients of list ORACLE-L Subject:Fwd: Re: test No, no, no, no. You just live on the wrong side of the world, these days. TestG is old, gone, dead. It's Test/g/ now. Has been for a couple of weeks. Notice the italics. Don't make users more ten'se than neccessary. The first one who sees a production version of Tense/g /will forever be known as the g-spotter. Connor McDonald wrote: I would not bother to use Test, because TestG is coming out very shortly. A lot of the Test programs have not been Test'd on version TestG which tends to make users a little testy :-) --- Mogens_Nørgaard [EMAIL PROTECTED] wrote: I also need to test. Mogens [EMAIL PROTECTED] wrote: Search the web by email! mailto:[EMAIL PROTECTED] adding your search to the subject line like this: search summer vacations test -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: =?ISO-8859-1?Q?Mogens_N=F8rgaard?= 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). = Connor McDonald web: http://www.oracledba.co.uk web: http://www.oaktable.net email: [EMAIL PROTECTED] GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will sit in a boat and drink beer all day Want to chat instantly with your online friends? Get the FREE Yahoo! Messenger http://uk.messenger.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: =?ISO-8859-1?Q?Mogens_N=F8rgaard?= 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: Rajesh Dayal 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).
test
Test
test
RE: Redo Logs Problem
Thats right, probably my question was not that accurate/meaningful. What I meant was that, Are these DMTs capable of generating so Much of Redo Logs? So far I havent seen such a genuine case at Least ( May be some-one would have experienced it). Most of the cases (of excessive redo logs) have come out to be Oracle Bugs, memory leaks, and improper user action etc. Rajesh -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Naveen Nahata Sent: Monday, August 04, 2003 11:04 AM To: Multiple recipients of list ORACLE-L Subject: RE: Redo Logs Problem This will reduce the updates and inserts to the Data-Dictionary tables since in LMTs extent information is stored locally and not in Data-Dictionary Regards Naveen -Original Message- From: RAJESH DAYAL [mailto:[EMAIL PROTECTED] Sent: Monday, August 04, 2003 11:59 AM To: Multiple recipients of list ORACLE-L Subject: RE: Redo Logs Problem Just Out of curiosity. How come changing the TS to LMT would reduce the excessive Redo generation. Regards, Rajesh -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of VIVEK_SHARMA Sent: Monday, August 04, 2003 9:49 AM To: Multiple recipients of list ORACLE-L Subject: RE: Redo Logs Problem Convert Tablespaces to LMT (Locally Managed) if in 8i , to reduce excessive Redo generation -Original Message- From: Munish Bajaj [mailto:[EMAIL PROTECTED] Sent: Friday, August 01, 2003 4:04 PM To: Multiple recipients of list ORACLE-L Subject: Redo Logs Problem Hi Listers, One of my remote Clients is facing a problem with Redo Logs. The Redo Logs and the Archive logs in turn have suddenly started to generate at an alarming Rate. This has suddenly started from the last 1 week without any changes to Database Configuration or any other system settings (as per client). Can anyone please help me and let me know all the reasons that could be responsible for this behavior. Any Help from u will be appreciated. Regards Munish Bajaj 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 Logs Problem
Just Out of curiosity. How come changing the TS to LMT would reduce the excessive Redo generation. Regards, Rajesh -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of VIVEK_SHARMA Sent: Monday, August 04, 2003 9:49 AM To: Multiple recipients of list ORACLE-L Subject: RE: Redo Logs Problem Convert Tablespaces to LMT (Locally Managed) if in 8i , to reduce excessive Redo generation -Original Message- From: Munish Bajaj [mailto:[EMAIL PROTECTED] Sent: Friday, August 01, 2003 4:04 PM To: Multiple recipients of list ORACLE-L Subject: Redo Logs Problem Hi Listers, One of my remote Clients is facing a problem with Redo Logs. The Redo Logs and the Archive logs in turn have suddenly started to generate at an alarming Rate. This has suddenly started from the last 1 week without any changes to Database Configuration or any other system settings (as per client). Can anyone please help me and let me know all the reasons that could be responsible for this behavior. Any Help from u will be appreciated. Regards Munish Bajaj
RE: iAS Apache name-based virtual hosting
Title: Message I think with name based virtual hosting you have to have a different virtual server name and diff IP Address (In port based virtual hosting you can have same host names but can listen on different ports). The server has to be able to listen on this new address (probably this name/IP resolution can be done at DNS level). Also the apache is supposed to listen on both the server names, so your old server-name will keep working. In my case I used MS Cluster administrator to create another virtual IP address and corresponding virtual host name. So suppose the original server was configured with name say server11 with IP address 176.80.0.60, and additional virtual server name server12 with IP 176.80.0.65 was configured. Then the newly created virtual hostname server12 will have following entry in httpd.conf : # NameVirtualHost 176.80.0.65 VirtualHost 176.80.0.65 DocumentRoot /usr/local/apache/htdocs1 ServerName server12 ErrorLog logs/error_server12_log CustomLog logs/access_ server12_log common /VirtualHost ## you should be able to do http to both the servers i.e. http://server11 http://server12 both should be working. HTH, Rajesh -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Boivin, Patrice J Sent: Tuesday, July 22, 2003 5:24 PM To: Multiple recipients of list ORACLE-L Subject: RE: iAS Apache name-based virtual hosting I have that in place, except that since we are only doing virtual hosting by name, I used an asterisk instead of an IP address in the tags. i.e. NameVirtualHost * VirtualHost * ... /VirtualHost Patrice. -Original Message- From: RAJESH DAYAL [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 22, 2003 2:59 AM To: Multiple recipients of list ORACLE-L Subject: RE: iAS Apache name-based virtual hosting Hi, Did you specify the documentroot in the new virtual-host definition.? From documentation the full specs for name based Virtual-Hosting is NameVirtualHost 144.25.187.172 VirtualHost 144.25.187.172 DocumentRoot /usr/local/apache/htdocs1 ServerName hostname1 ErrorLog logs/error_log CustomLog logs/access_log common /VirtualHost HTH, Rajesh http://www.gridapp.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Boivin, Patrice J Sent: Monday, July 21, 2003 2:14 PM To: Multiple recipients of list ORACLE-L Subject: iAS Apache name-based virtual hosting Has anyone managed to make name-based virtual hosting work on Apache bundled into iAS for Win32? We configured Apache here, but strangely the original hostname still works. We seethe same page whether we type in the virtual hostname or the actual host name. I would have thought that with a VirtualHost tag, the actual host name would not point to the virtual host's page. I must have forgotten to do something somewhere... Patrice.
RE: iAS Apache name-based virtual hosting
Title: Message This section is not same across diff releases. Check this note 167194.1 for complete examples of these methods. HTH, Rajesh -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Boivin, Patrice J Sent: Tuesday, July 22, 2003 6:30 PM To: Multiple recipients of list ORACLE-L Subject: RE: iAS Apache name-based virtual hosting From the httpd.conf file... ### Section 3: Virtual Hosts # # VirtualHost: If you want to maintain multiple domains/hostnames on your # machine you can setup VirtualHost containers for them. Most configurations # use only name-based virtual hosts so the server doesn't need to worry about # IP addresses. This is indicated by the asterisks in the directives below. # Patrice. -Original Message- From: RAJESH DAYAL [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 22, 2003 11:09 AM To: Multiple recipients of list ORACLE-L Subject: RE: iAS Apache name-based virtual hosting I think with name based virtual hosting you have to have a different virtual server name and diff IP Address (In port based virtual hosting you can have same host names but can listen on different ports). The server has to be able to listen on this new address (probably this name/IP resolution can be done at DNS level). Also the apache is supposed to listen on both the server names, so your old server-name will keep working. In my case I used MS Cluster administrator to create another virtual IP address and corresponding virtual host name. So suppose the original server was configured with name say server11 with IP address 176.80.0.60, and additional virtual server name server12 with IP 176.80.0.65 was configured. Then the newly created virtual hostname server12 will have following entry in httpd.conf : # NameVirtualHost 176.80.0.65 VirtualHost 176.80.0.65 DocumentRoot /usr/local/apache/htdocs1 ServerName server12 ErrorLog logs/error_server12_log CustomLog logs/access_ server12_log common /VirtualHost ## you should be able to do http to both the servers i.e. http://server11 http://server12 both should be working. HTH, Rajesh -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Boivin, Patrice J Sent: Tuesday, July 22, 2003 5:24 PM To: Multiple recipients of list ORACLE-L Subject: RE: iAS Apache name-based virtual hosting I have that in place, except that since we are only doing virtual hosting by name, I used an asterisk instead of an IP address in the tags. i.e. NameVirtualHost * VirtualHost * ... /VirtualHost Patrice. -Original Message- From: RAJESH DAYAL [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 22, 2003 2:59 AM To: Multiple recipients of list ORACLE-L Subject: RE: iAS Apache name-based virtual hosting Hi, Did you specify the documentroot in the new virtual-host definition.? From documentation the full specs for name based Virtual-Hosting is NameVirtualHost 144.25.187.172 VirtualHost 144.25.187.172 DocumentRoot /usr/local/apache/htdocs1 ServerName hostname1 ErrorLog logs/error_log CustomLog logs/access_log common /VirtualHost HTH, Rajesh http://www.gridapp.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Boivin, Patrice J Sent: Monday, July 21, 2003 2:14 PM To: Multiple recipients of list ORACLE-L Subject: iAS Apache name-based virtual hosting Has anyone managed to make name-based virtual hosting work on Apache bundled into iAS for Win32? We configured Apache here, but strangely the original hostname still works. We seethe same page whether we type in the virtual hostname or the actual host name. I would have thought that with a VirtualHost tag, the actual host name would not point to the virtual host's page. I must have forgotten to do something somewhere... Patrice.
RE: iAS Apache name-based virtual hosting
Title: Message Hi, Did you specify the documentroot in the new virtual-host definition.? From documentation the full specs for name based Virtual-Hosting is NameVirtualHost 144.25.187.172 VirtualHost 144.25.187.172 DocumentRoot /usr/local/apache/htdocs1 ServerName hostname1 ErrorLog logs/error_log CustomLog logs/access_log common /VirtualHost HTH, Rajesh http://www.gridapp.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Boivin, Patrice J Sent: Monday, July 21, 2003 2:14 PM To: Multiple recipients of list ORACLE-L Subject: iAS Apache name-based virtual hosting Has anyone managed to make name-based virtual hosting work on Apache bundled into iAS for Win32? We configured Apache here, but strangely the original hostname still works. We seethe same page whether we type in the virtual hostname or the actual host name. I would have thought that with a VirtualHost tag, the actual host name would not point to the virtual host's page. I must have forgotten to do something somewhere... Patrice.
RE: RAC or Oracle Fail Safe
Title: RE: RAC or Oracle Fail Safe Hi Hussain, Replies are inline . 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 Yes you can do that. You can very well make use of other node, in above ways. Advantage of running some standard services would be that they will also fail-over to the surviving node. So _effectively_ you are using both the nodes at any point of time. Here we have 2 node cluster where one node is running Database and another node is running 9ias Server. and they failover to each other automatically if one of them them goes down. In fact you can decide your failback policies also so that the nodes know when (may be off-peak hour) to fail-back once the failed node is back. Incase of OFS, the database service fails over from one node to the other, and then it starts, but it is automatic, right? Yes, it is a configurable parameter and can be set to automatic mode. When you talk about Resources and that they cant 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. I think you got me wrong here. They cant be shared at the same point of time. Actually the shared storage would be physically connected to both the nodes. And they can/will have multiple drives defined on them ( say U,V,W,X).So at one point of time say UV would be owned by node1 and WX would be owned by node2. If node1 fails then node2 will own all the 4 drives U,V,W and X. RAC costs roughly 20k$ per CPU and it doesnt come bundled with Oracle 9i License? (For confirmation purposes) Absolutely right. 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. Here I would beg to differ. RAC is more safe. _Almost_ half of your online user (who are on surviving node) wont even notice the node failure when one node in a RAC environment goes down. And those who were unlucky users (connected to failed node), can connect immediately to the surviving node, without any delay. Of course you need to configure these parameters manually. While in OFS environment your users have to wait till the time surviving node brings up the database and all related services (listener etc) completely. The price you may for these features is more money and more complex database environment to manage. 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. I think users will have a hung screen with/without some ORA error message. Hope this helps you decide, Regards, Rajesh -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Hussain Ahmed Qadri Sent: Saturday, July 19, 2003 11:44 AM To: Multiple recipients of list ORACLE-L Subject: 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 cant 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 doesnt 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
RE: RAC or Oracle Fail Safe
Title: RE: RAC or Oracle Fail Safe Hi Hussain ! RAC can have Active-Active or Active-Passive combination for two nodes. While OFS can't give you Active-Active combination of two nodes. Basically a resource sharing is not possible in Oracle Fail safe so one resource can be used by only one 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="">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 SKMCHRC -- 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 Answers in line... -- I also believe that setting up RAC is more complex, That's not totally true, For a DBA it shouldn't matter much, whether he is setting up RAC or OFS. But yes relatively RAC is a bit complex to manage. -- and any change in node shifting (when active is down, passive becomes active) is transparent to the user Not true really, user's session will flash error message and he will have to re login. This is true in both the cases(unless you implement TAF Transparent Application Failover logics in your application for RAC. One major difference would be that in RAC user can re-login immediately, while in OFS he has to wait till the other node bring the database up. -- Doesn't the second node automatically take over? Yes other node can be configured to take over automatically base on some simple in-built logic. But a DB recovery might be required depending on specific cases. -- And this means that the user has to log in again, do I get it right? Yes you are right here. HTH, Rajesh -Original Message- HREF="">mailto:[EMAIL PROTECTED]] On Behalf Of Hussain Ahmed Qadri Sent: Thursday, July 17, 2003 11:04 AM To: Multiple recipients of list ORACLE-L Subject: 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 SKMCHRC -- 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
RE: ORA-00600: internal error code, arguments: [19944], [], [], [
Title: RE: ORA-00600: internal error code, arguments: [19944], [], [], [], [], [], [], [] Good solution ;-) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Jamadagni, Rajendra Sent: Monday, July 07, 2003 10:30 PM To: Multiple recipients of list ORACLE-L Subject: RE: ORA-00600: internal error code, arguments: [19944], [], [], [ Your solution is described in details here ... http://tinyurl.com/g8eu HTH Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message- From: Nirmal Kumar M [mailto:[EMAIL PROTECTED]] Sent: Monday, July 07, 2003 11:59 AM To: Multiple recipients of list ORACLE-L Subject: ORA-00600: internal error code, arguments: [19944], [], [], [], [], [], [], [] Hei all, My database is Oracle 801 running on windowsNT with NOARCHIVELOG mode. I got the memory problem and it has been end with one of RBS datafile currption. The DB does not allowed me either drop the datafile or tablespace. So what i have done the following steps. 1)created control file using alter database backup to trace command. 2) removed the datafiles for the tablespace( here its rollback segment tablespace), which has been currupted from the trace file. 3)created the new control by running the modified create controlfile command. 4) database mounted 5) At the end alter database open command results the following error. ORA-00600: internal error code, arguments: [19944], [], [], [], [], [], [], []. What could be done next to open the database sucessfully. Please give the earliest solution. I had full cold back which has been taken last week and having daily database export dump. thanks. nirmal.
RE: Need Help for 9i OCP
Hi All, They are at the moment offering 50% discount... Here is an excerpt from one recent promotion.. SAVE 50% on all individually packaged Self Test Software test prep products from 12:01 am, May 28, 2003 to midnight EDT on May 31, 2003. There will be no backdating or extensions on this offer. Simply go to http://testprep.selftestsoftware.com/W4RT052EB6F8A396076E3EEF0024 and your discount will automatically show on all individually packaged products on the site. You got to hurry up. Cheers, Rajesh -Original Message- Sent: Saturday, May 31, 2003 1:11 AM To: Multiple recipients of list ORACLE-L Dennis, You are right. Nothing is free if t has a quality. Best option is to buy sts question which cosr normally $99 but they also offer sometimes at 25-30% discount. Alternately buy Daniels 9i new features comes with test question CD. I rather suggest Senthil to buy sts eaxm questions and they worth it. Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Fri, 30 May 2003 07:54:52 -0800 Senthil I hope you get a reply. But I have searched for the same and I don't think anyone will go to the trouble of creating a really good exam, then giving it away for free. As we discussed yesterday on this list, Couchman is a good author to use, and even he has a few glitches. But when you are to the point of arguing with the author, you are ready to pass the exam. Trying Jared's tiny url suggestion, otherwise go to Amazon and search for Couchman Oracle9i. http://tinyurl.com/d1wt Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, May 30, 2003 10:10 AM To: Multiple recipients of list ORACLE-L Hi Group, I wanted to do 9i OCP. Any good sites are there to give free sample exam questions. (I want a full set not that 12 Question exams). Expecting ur help. Thanx For All, Senthil. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Senthil Kumar D 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: 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). _ MSN 8 with e-mail virus protection service: 2 months FREE* http://join.msn.com/?page=features/virus -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: M Rafiq 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: Rajesh Dayal 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: Parallel Query Server died
After long time .. LOL . ;-) -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Vladimir BaracSent: Friday, May 30, 2003 2:35 PMTo: Multiple recipients of list ORACLE-LSubject: Re: Parallel Query Server died Kool, now some cyber funeral will take place... - Original Message - From: shuan.tay(PCI¾G¸R³Ô) To: Multiple recipients of list ORACLE-L Sent: Friday, May 30, 2003 11:19 Subject: Parallel Query Server died Dear all DBAs, What should i check for this error? "ORA-12805: parallel query server died unexpectedly" The SQL statement was runningwell before. There's nothing in the alert log about this error. I'm using Oracle 8.1.6 on Redhat 7.2. Thanks and have a nice day.
RE: log buffer space
Dear AK, So far we don't know your log buffer size. Can we have a glimpse of this parameter, log_buffer ? Rajesh -Original Message- Sent: Friday, March 14, 2003 8:14 PM To: Multiple recipients of list ORACLE-L Do you guys think , adding more log file can help ? I think it should not , cuz any way logwriter is going to write in one datafile at a time , correct ? -ak - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, March 14, 2003 4:32 AM Arup: NO FLAMES The second condition is not quite true. It is 2/3 full in the current versions. /NO FLAMES It is very easy to test with the event 10046^8. KG --- Arup Nanda [EMAIL PROTECTED] wrote: AK, If the log buffer is at least 4MB, then increasing it will not help, rather it may hurt. The log buffer is flushed when any of the the follwoing occur (i) 1 MB is filled up (2) 1/3rd is filled up (3) every 3 seconds (4) when a checkpoint occurs (5) when a commit occurs. Therefore, see if any of these could be the problem. It's easy to check #s 4 and 3. As Kirti suggested, the problem could be due to the redo logs being on a busy disk, or even a slow one. HTH. Arup - Original Message - From: Deshpande, Kirti To: Multiple recipients of list ORACLE-L Sent: Thursday, March 13, 2003 8:13 PM Subject: RE: log buffer space Increasing log_buffer size is an option, if it is really small. I would also check if the redo logs are on a busy disk. If so, try moving those (or other busy data files on the same disk) to other not-so-busy disks. - Kirti = Have a nice day !! Best Regards, K Gopalakrishnan, Bangalore, INDIA. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: K Gopalakrishnan 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: AK 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: Rajesh Dayal 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).
Threat to Fast exports
Please have a look at following note: 223399.1 having title ALERT: EXPORT with large BUFFER can silently produce a dump file with corrupted data. Looks like all major versions on all platforms are affected. Really scary one.. Rajesh -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rajesh Dayal 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: Oracle version??
Hi Chip, I am talking of log directory(N:\Oracle\Inventory\logs and not N:\Oracle\Inventory\components), where every Installer action is logged and not . This doesn't matter whether your Oracle.exe is replaced or not. All of your OUI actions will be logged with all the relevant information and typically the file names are of following format. installActions2003-01-21_12-01-02PM.log So if you put little extra effort digging these files (depending on size, timestamp etc.) you can find out what is last activity you performed on what ORACLE_HOME and so the precise patch level is also available there... And that YP-ZP I mean XP, I would really hate to see a Oracle Database on that ;-)... Cheers, Rajesh -Original Message- Sent: Thursday, February 27, 2003 11:59 AM To: Multiple recipients of list ORACLE-L In the registry My Computer\HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\inst_loc specifies the location of the inventory folder (defaults to C:\Program Files\Oracle\Inventory). Note: some Oracle patches do replace oracle.exe without using the Oracle Universal Installer (OUI) so the inventory would have no record of the patch (e.g. 8.1.7.4.6). Inside the inventory folder, Components and Patches have folders for components installed by OUI. For example, my inventory folder contains these folders: N:\Oracle\Inventory\Components\oracle.server\8.1.7.0.0\1\resources N:\Oracle\Inventory\Components\oracle.server\9.0.1.1.1\1\resources N:\Oracle\Inventory\Components\oracle.server\9.2.0.1.0\1\resources N:\Oracle\Inventory\Patches\oracle.rdbms\8.1.7.4.1\1\resources N:\Oracle\Inventory\Patches\oracle.rdbms\9.0.1.4.0\1\resources N:\Oracle\Inventory\Patches\oracle.rdbms\9.2.0.2.1\1\resources Note: the version numbers (folder names) do match my OUI installation of Oracle servers and patches. When using Windows XP Pro, the properties of oracle.exe is interesting - the version displayed near the top is 0.0.0.0, yet the File Version near the bottom of the dialog box does display the correct version. Wonder how Windows XP Pro finds the correct version, while Windows 2000 Pro can't see it. Have Fun :) Rajesh Dayal wrote: Hi Sunil, The tragedy is that even if you logon to database, you may not find the precise patch level from database. The best location is orainventory/log directory. OK on MS machines C:\Program Files\Oracle\Inventory\logs. Go to this directory and check the latest log file from this location. HTH, Rajesh -Original Message- Sent: Thursday, February 27, 2003 7:09 AM To: Multiple recipients of list ORACLE-L List, Can Oracle version be determined based on size of Oracle.EXE file on Windows? I am looking for a valid way of determining the patch level without having to log onto the database and check v$instance. appreciate any feedback. Sunil Nookala Dell Corp. Austin, TX. -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Chip 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: Rajesh Dayal 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: Oracle version??
Hi Sunil, The tragedy is that even if you logon to database, you may not find the precise patch level from database. The best location is orainventory/log directory. OK on MS machines C:\Program Files\Oracle\Inventory\logs. Go to this directory and check the latest log file from this location. HTH, Rajesh -Original Message- Sent: Thursday, February 27, 2003 7:09 AM To: Multiple recipients of list ORACLE-L List, Can Oracle version be determined based on size of Oracle.EXE file on Windows? I am looking for a valid way of determining the patch level without having to log onto the database and check v$instance. appreciate any feedback. Sunil Nookala Dell Corp. Austin, TX. -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rajesh Dayal 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: Urgent - Help ....
Hi Harsha, You can modify column length as done in second step below: SYSTEM@OHIL create table test121 (col1 number (5)) tablespace users ; Table created. SYSTEM@OHILalter table test121 modify col1 number(8) ; Table altered. SYSTEM@OHILdrop table test121 ; Table dropped. Cheers, Rajesh -Original Message- Sent: Thursday, February 20, 2003 12:59 PM To: Multiple recipients of list ORACLE-L Hi Gurus, I need a urgent help. I have a table e.g. USER_DETAILS with a column NUMBER(9), populated by a sequence. [ The column name is USERNO ] This table is quite heavy and the current situation is USERNO have reached it's maximum value i.e. 9. No more records can be inserted Problem !!! Can any one suggest a solution with NO change is the software and minor change in the software. TIA Regards, Harsh Agrawal -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rajesh Dayal 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: DBMS_JOB : Can submit but does not execute
You have to run the job after you submit it.
SQL exec dbms_job.run(24);
Also make sure all init.ora parameters are set eg (job_queue_interval ,
job_queue_processes )
HTH,
Rajesh
-Original Message-
Ling Catherine (CSC)
Sent: Tuesday, February 18, 2003 8:14 PM
To: Multiple recipients of list ORACLE-L
Hi Gurus,
I have submitted a job but it does not execute. Why? Does the owner
require any privileges ? However, I can use DBMS_JOB.CHANGE command to
execute immediately. I would like the job to execute on a daily basis.
Any advice ? TIA
--
-- Submit a job
--
1 DECLARE
2job BINARY_INTEGER;
3 BEGIN
4DBMS_JOB.SUBMIT(job,'PROCEDURE_NAME;',SYSDATE,'SYSDATE+1');
5DBMS_OUTPUT.PUT_LINE(TO_CHAR(JOB));
6* END;
SQL /
1
PL/SQL procedure successfully completed.
SQL COMMIT;
Commit complete.
--
-- Execute the job
--
1 begin
2 DBMS_JOB.CHANGE(1,
3 '
PROCEDURE_NAME;',to_date('1802200308:00:00','ddmmhh24:mi:ss'),'SYSDA
TE+1');
4* END;
SQL /
PL/SQL procedure successfully completed.
SQL COMMIT;
Commit complete.
--
-- Check whether the job is submitted
--
SQL SELECT * FROM DBA_JOBS
JOB LOG_USER PRIV_USER
- -- --
SCHEMA_USERLAST_DATE LAST_SEC THIS_DATE THIS_SEC
NEXT_DATE NEXT_SEC TOTAL_TIME B
-- - -
- -- - INTERVAL
FAILURES
-
WHAT
NLS_ENV
MISC_ENV
INSTANCE
-
1 USER1 USER1
USER1 17-FEB-03 20:01:20
18-FEB-03 08:00:00 16 N
SYSDATE+1
0
PROCEDURE_NAME;
NLS_LANGUAGE='AMERICAN' NLS_TERRITORY='AMERICA' NLS_CURRENCY='$'
NLS_ISO_CURRENCY='AMERICA' NLS_NUME RIC_CHARACTERS='.,'
NLS_DATE_FORMAT='DD-MON-YY' NLS_DATE_LANGUAGE='AMERICAN'
NLS_SORT='BINARY'
01020002
0
Regds,
Catherine
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: CHAN Chor Ling Catherine (CSC)
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: Ramon E. Estevez
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: Rajesh Dayal
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: how to make sql prompt like USER@DATABASE ?
Sorry, I
missed your question earlier (too busy to check all the mails everyday)..
In the last line of my last mail I had mentioned that
Alternatively you can create a file with above lines, put that file
in bin and call it anytime to make your prompt...
So
you can create a file say con1.sql (in your bin directory) with following
content
ACCEPT USER CHAR PROMPT 'User: '
ACCEPT PSWD CHAR PROMPT 'Password: ' HIDE
ACCEPT DBNAME CHAR PROMPT 'Database: '
CONNECT USER@DBNAME/PSWD
set heading off
set term off
set feedback off
spool myprompt.lst
select 'set sqlprompt ' || SYS_CONTEXT
('USERENV', 'session_user') || '@' || SYS_CONTEXT ('USERENV', 'DB_NAME') ||
''
from dual
/
spool off
@myprompt.lst
set heading on
set term on
set feedback on
While reconnecting from existing sql session you
can call con1.sql and have your prompt set.
Cheers,
Rajesh
mm...
what if i logged in with SYSTEM first then conn sys/pswd@db?
it's still show SYSTEM @db.
-
Original Message -
From: Rajesh Dayal
To: Multiple recipients of list ORACLE-L
Sent: Saturday,
February 15, 2003 6:53 PM
Subject: RE: how to make sql prompt like USER@DATABASE ?
You can
add following lines to your glogin.sql ($ORACLE_HOME/sqlplus/admin directory)
file.
set heading off
set term off
set feedback off
spool myprompt.sql
select 'set sqlprompt ' || SYS_CONTEXT ('USERENV',
'session_user') || '@' || SYS_CONTEXT ('USERENV',
'DB_NAME') || ''
from dual
/
spool off
@myprompt.sql
set heading on
set term on
set feedback on
Alternatively
you can create a file with above lines, put that file in bin and call it
anytime to make your prompt...
Cheers,
Rajesh
Original
Message-
From:
[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
Behalf Of Salaheldin Aboali
Sent:
Saturday, February 15, 2003 2:14 PM
To:
Multiple recipients of list ORACLE-L
Subject:
how to make sql prompt like USER@DATABASE ?
hi
how to make
sql prompt like USER@DATABASE ?
where USER:
connected user
DATABASE:
database global name, or database local alias
Regards,
Salaheldin
Aboali
---
Senior
Software Developer
Management
Information Systems
http://www.mis-kuwait.com
Phone:
+965.240.64.25
+965.240.67.98
+965.240.80.92
Ext.
235
Fax.
+965.240.81.53
Cell.
+965.790.31.65
RE: Reconfiguring datafiles
Good point H ;-) -Original Message- Carmichael Sent: Tuesday, February 18, 2003 3:44 PM To: Multiple recipients of list ORACLE-L first, you listed only two datafiles second, why on earth would you want to move the data? just add datafile x2 to the tablespace and let Oracle keep going --- Sony kristanto [EMAIL PROTECTED] wrote: Dear Listers, Would someone on this list help me to solve these problems, 1. I've three datafiles x1 and x2 2. If datafile x1 is full, I want it is automaticaly move to datafile x2 including all data in datafile x1. 3. If it is possible how to do it. Many thanks for respons and all comments would be appreciated. Kind rgrds, Sony -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Sony kristanto 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). __ Do you Yahoo!? Yahoo! Shopping - Send Flowers for Valentine's Day http://shopping.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rachel Carmichael 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: Rajesh Dayal 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: how to make sql prompt like USER@DATABASE ?
You can
add following lines to your glogin.sql ($ORACLE_HOME/sqlplus/admin directory) file.
set heading off
set term off
set feedback off
spool myprompt.sql
select 'set sqlprompt ' || SYS_CONTEXT
('USERENV', 'session_user') || '@' || SYS_CONTEXT ('USERENV', 'DB_NAME') ||
''
from dual
/
spool off
@myprompt.sql
set heading on
set term on
set feedback on
Alternatively
you can create a file with above lines, put that file in bin and call it
anytime to make your prompt
Cheers,
Rajesh
Original
Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Salaheldin Aboali
Sent: Saturday, February 15, 2003
2:14 PM
To: Multiple recipients of list
ORACLE-L
Subject: how to make sql prompt
like USER@DATABASE ?
hi
how to make
sql prompt like USER@DATABASE ?
where USER:
connected user
DATABASE:database
global name, or database local alias
Regards,
Salaheldin Aboali
---
Senior Software Developer
Management Information Systems
http://www.mis-kuwait.com
Phone:
+965.240.64.25
+965.240.67.98
+965.240.80.92
Ext. 235
Fax. +965.240.81.53
Cell. +965.790.31.65
RE: hw info on Tru64 system
vmstat PP for RAM size. psrinfo For processor related info. swapon s To check swap info. To determine which operating system subsets are installed, enter the following command: $ setld -i | grep installed To determine which operating system version is installed, enter one of the following commands: $ uname -a HTH, Rajesh -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Vladimir Barac Sent: Thursday, February 06, 2003 2:57 PM To: Multiple recipients of list ORACLE-L Subject: OT: hw info on Tru64 system Good day to everyone How do I find hardware info on Tru64 machine? Available RAM, number of CPUs...? Thanks in advance, Vladimir Barac
RE: re SHUTDOWN ABORT -- was RE: Debate on rc commands Solaris and
I totally agree I am witness of one of these untested combination resulting in true disaster . And the combination was shutdown immediate to an extremely busy database (with no response), followed by shutdown abort and all the data files got corrupted. We could not recover that big production database from that corruption of all the datafiles and we had to go back to Old and valid set of backup. That was Oracle 7.3.4 running telecom database around a year back. Sine then I am too shaky on using shutdown abort, I avoid it unless it is as extreme urgency and if at all I have to use it, I never do it after shutdown immediate Just my 2 cents, Rajesh -Original Message- Sent: Monday, February 03, 2003 12:49 PM To: Multiple recipients of list ORACLE-L I have to say that I still have an emotional response to 'shutdown abort', despite knowing that logically it ought to be perfectly safe. The reason for this is the lack of stress testing that goes on at Oracle Corp. In most (if not all) cases, the only blanket stress test that the software gets is from production end-users. How many millions of times per day is the message passing mechanism for parallel query tested ? And it still has bugs. How many times per day is shutdown abort tested - how many possible combinations of events coinciding with a shutdown abort have not yet received a single test ? I find it very hard to shake the feeling that somewhere there is a code path that will eventually result in a big problem for someone once they switch to a regular shutdown abort. Regards Jonathan Lewis http://www.jlcomp.demon.co.uk Coming soon a new one-day tutorial: Cost Based Optimisation (see http://www.jlcomp.demon.co.uk/tutorial.html ) UK___March 19th USA_(FL)_May 2nd Next Seminar dates: (see http://www.jlcomp.demon.co.uk/seminar.html ) USA_(CA, TX)_August The Co-operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html -Original Message- To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: 02 February 2003 10:09 Solaris and Alter system checkpoint... You don't say... Hey, this is the first time this thread has concluded without the usual you guys better watch out b/c yer gonna break your database! post. I'd say this universal support for ABORT over IMMEDIATE represents a dramatic change in the prevailing DBA attitude over, say, two years ago. How do you suppose that happened? :-) The only dissenter was Dan. Dan, what's the difference between a kernel transaction and a regular transaction? Are you talking about the O/S kernel or Oracle? Can you explain in more detail what the kernel transaction does to make Oracle unrecoverable after ABORT? I'm still mulling over that 'alter system checkpoint.' Sounds familiar. -- Jeremiah Wilton http://www.speakeasy.net/~jwilton -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jonathan Lewis 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: Rajesh Dayal 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: Windows 2000 Cluster on oracle
Yes you can go for Active-Active cluster configuration of RAC or else Active-Passive configuration of Oracle Fail Safe on Windows Cluster. Both of these are available on Windows 2000 cluster. Let me know, if you want more info. HTH, Rajesh -Original Message- Sent: Tuesday, January 28, 2003 9:40 PM To: Multiple recipients of list ORACLE-L Hi I wanted to migrate my database from SUN solaris to WINDOWS 2000 platform.Curetly I am having sun cluster as failover with shared disk. I wanted to setup similar kind of setup with windows 2000. Is any failover option available in Windows2000? Let me know if anyone does such kind of setup earlier ? Thx -Seema _ The new MSN 8: smart spam protection and 2 months FREE* http://join.msn.com/?page=features/junkmail -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Seema Singh 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: Rajesh Dayal 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: Oracle doesn't start up with domain user
Check the file and folder permissions of installation files as well as database files. Give full permissions to local administrator on all the files (from root level) , things should work fine after that. HTH, Rajesh -Original Message- Csillag Sent: Tuesday, January 28, 2003 4:19 PM To: Multiple recipients of list ORACLE-L Hi, I installed Oracle 9i under Windows 2000 professional with a domain user who has admin rights. After installing I couldn't use it: - If I log in with Administrator/Local Computer then the message of Net Manager (when testing the service) I got the error message Oracle not available After that if I start Oracle Database Configuration Assistant then modify database, go ahead with next, next etc. and finish it then the Oracle becomes available in Net Manager. After restarting the computer the same problem occurs. -- If I log in with Domain user /Domain then the message of Net Manager (when testing the service) I got the error message Initializing first test to use userid: scott, password: tiger Attempting to connect using userid: scott The test did not succeed. ORA-03113: end-of-file on communication channel After that if I start Oracle Database Configuration Assistant to modify database the error message is: ORA-01041: internal error.hostdef extension doesn't exist Both the Administrator and the Domain User are member of : administrators, oradba. I checked the services, they seem to start. Thank you in advance Zsolt Csillag, Hungary -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Zsolt Csillag 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: Rajesh Dayal 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).
Portal installation and sqlplus
Hallo All, I am bugged up with portal installation. Firstly I got a message at the end of Portal Installation that that WWSEC_ENABLER_CONFIG_INFO$ contains no entries To troubleshoot this problem I tried running portal diagnostic utility diag.cmd ( Metalink Note 134188.1). When I run this then it says You must set ORACLE_HOME . When I set ORACLE_HOME it says SQL*Plus not available. This Looks like during installation also portal installer could not access SQLPlus resulting these errors. 9iAS Version 1.2.2.1 on WIN2000 Platform. In fact, I can access SQL*Plus from command prompt only till my ORACLE_HOME is not set. The moment I Set ORACLE_HOME on my command prompt it simply doesn't execute SQLPLUS and simply gives the prompt back without any error. I would really appreciate any help... Thanks in advance, Rajesh Dayal -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rajesh Dayal 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: Disable Database Startup While COLD Backup is in Progress ?
Just move one of the controlfiles to another directory before startup of your cold backup and after cold backup finishes, you can put it back in the original directory. But why you need this, at least the people who are managing the databases, should know that it's backup time and they should not try to start. And those who don't know the backup timings shouldn't be having privileges to startup database isn't it ;-) HTH, Rajesh Dayal -Original Message- Sent: Friday, December 20, 2002 5:19 PM To: Multiple recipients of list ORACLE-L Is here a way to Disable Database Startup While COLD Backup is in Progress ? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: VIVEK_SHARMA 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: Rajesh Dayal 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: Disable Database Startup While COLD Backup is in Progress ?
Just move one of the controlfiles to another directory before startup of your cold backup and after cold backup finishes, you can put it back in the original directory. But why you need this, at least the people who are managing the databases, should know that it's backup time and they should not try to start. And those who don't know the backup timings shouldn't be having privileges to startup database isn't it ;-) HTH, Rajesh Dayal -Original Message- Sent: Friday, December 20, 2002 5:19 PM To: Multiple recipients of list ORACLE-L Is here a way to Disable Database Startup While COLD Backup is in Progress ? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: VIVEK_SHARMA 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: Rajesh Dayal 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).
Performance on TRU64 Cluster
Hi Guys, We are in the process of configuring Oracle 9i Release 2 on TRU64 Cluster (2 ES40s with RA3000, with SCSI cluster N/W no FC Channel ). So far we have done just the installation( No database creation). The problem is that System looks very slow. Perform is perfectly OK when you perform some activity on single node, but the moment you try to do same thing on both the nodes, it is having problems and takes hell lot of time. For example while starting gsd domain, from one nodes it takes fraction of second, while from other it takes atleast 10-15 seconds. Even while running root.sh this was damn slow on both the nodes, and took at least 10 good minutes. Is IT Normal??? I can't imagine this to be a normal behavior. Well, here are my Kernal Parameters, that I tried to change before installation... proc: max_per_proc_address_space = 2 gig per_proc_address_space = 2gig per_proc_stack_size = 33554432 max_per_proc_stack_size = 500m per_proc_data_size = 201326592 vm: new_wire_method = 0 vm_swap_eager = 1 Earlier this was set as vm-swap-eager = 1 and not vm_swap_eager =1 ubc_maxpercent = 70 gh_chunks = 518 I tried setting this to 518 but after booting this comes out to be 0 vfs fifo_do_adaptive defaults = 0 ipc: shm_max = 2139095040 shm_mni = 256 shm_min = 1 shm_seg = 1024 ssm_threshold = 0 I tried setting this to be 0 but after booting this has become a very large value (atleast 20 digit value) rdg: msg_size = 32768 max_objs = 5120 max_async_req = 256 max_sessions = 200 rdg_max_auto_msg_wires = 0 rdg_auto_msg_wires = 0 rt: aio_task_max_num = 300 I tried setting this to be 300 but after booting this has become 307 Hope someone would provide me their Kernal Parameter values and help trouble-shooting me. Could this performance problem be related to some hardware problem?? So far Hardware is also not fully tested, and this is a brand new setup. While bringing the system up we see some errors messages related to Eager Swap mode and Asynch I/O. Appreciate your help, Rajesh -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rajesh Dayal 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).
FW: OSF11 in TRU64 Unix
Hi again, After some more combined effort we came to know that this is a documentation bug where OSF11 should be spelled as OSFX11. However Oracle has not admitted this so far... JDK version is still a mystery to me ... Cheers, Rajesh -Original Message- Dayal Sent: Wednesday, November 27, 2002 10:51 AM To: '[EMAIL PROTECTED]' Hi everybody, I am about to install Oracle 9i release 2 on TRU64 Unix. In one of the pre-requisites, Oracle suggests to have OSF11 installed on the Operating System. Some how our System Admin is not able to locate where from this component/package would come. Any-body having any idea, how to install and where from to download this component/package. Also please clarify what minimum version of JDK is required? At some place they say minimum required is 1.3.1 while in some other document (Doc ID: 169706.1) they say minimum version of JDK required is 1.1.8. Some body help please, Best Regards, Rajesh -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rajesh Dayal 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).
OSF11 in TRU64 Unix
Hi everybody, I am about to install Oracle 9i release 2 on TRU64 Unix. In one of the pre-requisites, Oracle suggests to have OSF11 installed on the Operating System. Some how our System Admin is not able to locate where from this component/package would come. Any-body having any idea, how to install and where from to download this component/package. Also please clarify what minimum version of JDK is required? At some place they say minimum required is 1.3.1 while in some other document (Doc ID: 169706.1) they say minimum version of JDK required is 1.1.8. Some body help please, Best Regards, Rajesh -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rajesh Dayal 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: Oracle 8i R3, and 9i R2 on Same NT Box
Yes I am here running 8.1.7 and 9i Release 1 ( not release 2) on the same Windows 2000 Server Box. So far so good, this is my test machine. Rajesh - Original Message - Date: Mon, 30 Sep 2002 09:13:30 -0800 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] This is interesting. I have installed and run multiple Oracle versions on the same Unix box but not NT. Sam Bootsma wrote: Hello, Does anybody out there run Oracle 8.1.7 and Oracle 9.2 on the same NT (or Windows 2000) box? Is it running smoothly. Any difficulties installing or running both versions on the same box? I ask because one of my colleagues has encountered difficulties installing and running Oracle 8.1.7 and Oracle 9.2 on the same NT box. Thanks for any input. Sam Bootsma, OCP Technical Support Analyst CPAS Systems Inc. 416-422-0563 x237 [EMAIL PROTECTED] http://www.cpas.com -- ltiu 3/4 OCP 9i Eh? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ltiu 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). -- __ Sign-up for your own FREE Personalized E-mail at Mail.com http://www.mail.com/?sr=signup -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rajesh Dayal 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: doubt in INDEX
Dear Guess Who, I don't think so. BTW, who are the people and why do they think so, we would love to see their explanation/theory. There could be several possibilities for having the rowids changed, like Exporting and Importing the tables, Moving the tables to diff T.S etc. Other ideas are welcome ... HTH, Rajesh - Original Message - Date: Sun, 01 Sep 2002 20:13:21 -0800 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] 1.) People are saying that if a table is indexed then the all the rowids will be changed , whether it is trueIf so , then how it is done , give example please. 2.)What are all the ways for the rowids to be changed Explain. Regards, Prakash. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: guess who INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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). -- __ Sign-up for your own FREE Personalized E-mail at Mail.com http://www.mail.com/?sr=signup -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rajesh Dayal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
TEST
Title: TEST TEST
test
Title: test Testing .
TEST
Title: TEST TESTING ...
RE: stop sharon
Title: RE: stop sharon Why not current one ? ;-) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Mark Leith Sent: Wednesday, March 27, 2002 2:33 PM To: Multiple recipients of list ORACLE-L Subject: RE: stop sharon EH? Virus? Joke? Wrong list? ex girlfriend? ;P -Original Message- Bahar Sent: 27 March 2002 09:38 To: Multiple recipients of list ORACLE-L -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists 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: problem in creating control file?
USE COMMAND LIKE . CREATE CONTROLFILE SET DATABASE TEST2 RESETLOGS ARCHIVELOG .. HTH, Rajesh -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Bunyamin K. Karadeniz Sent: Tuesday, March 12, 2002 3:48 PM To: Multiple recipients of list ORACLE-L Subject: problem in creating control file? I try to clone my database . I have the datafiles on D:\yedek123 and want to create the control files . What I do is: set oracle_sid=new_sid svrmgrl internal/ startup nomount pfile=new_pfile CREATE CONTROLFILE DATABASE TEST2 RESETLOGS ARCHIVELOG MAXLOGFILES 32 MAXLOGMEMBERS 2 MAXDATAFILES 254 MAXINSTANCES 1 MAXLOGHISTORY 1815 LOGFILE GROUP 1 'D:\yedek123\REDO01.LOG' SIZE 1M, GROUP 2 'D:\yedek123\REDO02.LOG' SIZE 1M, GROUP 3 'D:\yedek123\REDO03.LOG' SIZE 1M DATAFILE 'D:\yedek123\SYSTEM01.DBF', 'D:\yedek123\RBS01.DBF', 'D:\yedek123\USERS01.DBF', 'D:\yedek123\TEMP01.DBF', 'D:\yedek123\TOOLS01.DBF', 'D:\yedek123\INDX01.DBF', 'D:\yedek123\DR01.DBF' CHARACTER SET WE8ISO8859P9; But When I run the create control file script , I am encountering the error below. CREATE CONTROLFILE DATABASE TEST2 RESETLOGS ARCHIVELOG * ORA-01503: CREATE CONTROLFILE failed ORA-01161: database name TESTDB in file header does not match given name of TE ST2 ORA-01110: data file 1: 'D:\yedek123\SYSTEM01.DBF' TESTDB is the original database . TEST2 is new DB. What is the problem ? Thank you. Bunyamin K. Karadeniz Oracle DBA / Developer Civilian IT Department Havelsan A.S. Eskisehir yolu 7.km Ankara Turkey Phone: +90 312 2873565 / 1217 Mobile : +90 535 3357729 The degree of normality in a database is inversely proportional to that of its DBA.
RE: View for Procedure/Function SQL Code
Hi Aleem, You can view this info in DBA_SOURCE view. Best way is to query like this . SET PAGES 100 select text from dba_source where name = 'EUL$GET_FOLDER_NAME' and OWNER = 'TEST ; why Try selecting all columns and see the diff ;-) HTH, Rajesh -Original Message- Sent: Thursday, February 14, 2002 11:13 AM To: Multiple recipients of list ORACLE-L Hi! Is there a view to see the code written in the procedure/function code, the parameters, return types etc. TIA! Aleem -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Abdul Aleem INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Rajesh Dayal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Changing dump destinations in init.ora
That's true only for Oracle 8i onwards. For Oracle 8.0.x still you would need to bounce the DB. Here is an output from Oracle 8.0.5 NUM NAME -- TYPE -- VALUE ISDEFAULT ISSES ISSYS_MOD ISMODIFIED ISADJ - - - -- - DESCRIPTION 339 background_dump_dest 2 E:\ohil\BDUMP FALSE FALSE FALSE FALSE FALSE Detached process dump directory -Original Message- Gopalakrishnan Sent: Thursday, February 14, 2002 1:15 AM To: Multiple recipients of list ORACLE-L No need to bounce the instance. You can dynamically chance the location using ALTER SYSTEM command. Best Regards, K Gopalakrishnan Bangalore, INDIA -Original Message- Thomas F Sent: Wednesday, February 13, 2002 12:49 PM To: Multiple recipients of list ORACLE-L Nope. Create the new directory, change them in the file and bounce the instance. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Wednesday, February 13, 2002 3:19 PM To: Multiple recipients of list ORACLE-L Do I have to rebuild the controlfiles if I change any of the dump destinations in my oracle init.ora files. Thanks Darren -- Darren Browett P.EngThis message was transmitted Data Administrator using 100% recycled electrons Information and Communication Technology City of Coquitlam P:(604)927 - 3614 E:[EMAIL PROTECTED] --- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Browett, Darren INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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). _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: K Gopalakrishnan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Rajesh Dayal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Download a database
I had read somewhere on metalink that no supported Oracle database is available for W2K Millennium Edition. HTH, Rajesh -Original Message- [EMAIL PROTECTED] Sent: Sunday, February 10, 2002 10:38 AM To: Multiple recipients of list ORACLE-L Anyone who knows ifthere is a possibility to download some edition of oracle database to your harddrive? I am running Windows 2000 Millenium Edition. Thanks in advance Roland -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Rajesh Dayal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: How to find out what caused job to fail?
LOL ( in silence) -Original Message- Kevin Sent: Monday, February 04, 2002 3:30 PM To: Multiple recipients of list ORACLE-L (silence) -Original Message- Sent: 04 February 2002 10:05 To: Multiple recipients of list ORACLE-L Here we go again !!! -Original Message- Sent: 04 February 2002 09:36 To: Multiple recipients of list ORACLE-L But how do I use the alert log and where canI find the trace file? Roland [EMAIL PROTECTED]@fatcity.com den 2002-02-04 01:05 PST Sänd svar till [EMAIL PROTECTED] Sänt av: [EMAIL PROTECTED] Till: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Kopia: Hi, you can find the reason in alert log or trace files. -Original Message- From: Daiminger, Helmut [mailto:[EMAIL PROTECTED]] Sent: Monday, February 04, 2002 4:40 PM To: Multiple recipients of list ORACLE-L Subject: How to find out what caused job to fail? Hi! Is there a way to find out, why a database job failed? in dba_jobs (or user_jobs), I can only see that it failed, but no indication of the reason why it failed. Any ideas? This is 8.1.7 on Solaris. Thanks, Helmut -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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). The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robertson Lee - lerobe INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Thomas, Kevin INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Rajesh Dayal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Tkprof.
Just type tkprof on command line (DOS) or on shell prompt (UNIX), You would find the help and all your doubts would be cleared. HTH, Rajesh -Original Message- Sent: Tuesday, February 05, 2002 9:15 AM To: Multiple recipients of list ORACLE-L Hi all I am having a doubt in how to use Tkprof. This communication contains information, which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s), please note that any distribution, printing, copying or use of this communication or the information in it is strictly prohibited. If you have received this communication in error, please notify the sender immediately and then destroy any copies of it. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ayyappan S INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Rajesh Dayal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: sqlplus question
I was also trying to put some script on Oracle scheduler and successful too. But on Oracle 8 I failed. It was successful on Oracle 8i (8 doesn't support execute immediate). Would appreciate, if someone can give equivalent code for Oracle 8. Here is the code for Oracle 8i, create or replace PROCEDURE SWITCH IS 2 BEGIN 3 execute immediate 'alter system switch logfile '; 4 commit ; 5 END; 6 / Thanks in Advance, Rajesh NOTE: It would be executed with any user having sysdba privilege. -Original Message- Faroult Sent: Tuesday, January 29, 2002 11:40 AM To: Multiple recipients of list ORACLE-L And if you are running an unavowable OS, you can probably turn your SQL*Plus script into a jPL/SQL procedure and schedule it using dbms_job. Weaver, Walt wrote: Cron? At? -Original Message- Sent: Monday, January 28, 2002 3:21 PM To: Multiple recipients of list ORACLE-L Hello, I need to run some script using Oracle Sqlplus. The script is only suppose to run certain days of week. Does anyone have a suggestion how to do that. Thank you. -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Rajesh Dayal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: sqlplus question
Thanks Stephan, Your suggestion had motivated me and I wrote the code, after RTFM. Sameer, I didn't scheduled the job on OS because this should an Oracle Job, log switching has nothing to do with OS (you don't trouble a company GM when the work should be done by a Normal Manager right??). And you need to handle the error conditions of OS when your DB is down, which is eliminated in this case. Any-way thanks to all, Rajesh And-yes, the code is like this: create or replace PROCEDURE SWITCH1 IS c number; d number; begin c := dbms_sql.open_cursor; dbms_sql.parse(c, 'alter system switch logfile', 1); d := dbms_sql.execute(c); dbms_sql.close_cursor(c); commit ; END; -Original Message- Faroult Sent: Tuesday, January 29, 2002 1:36 PM To: Multiple recipients of list ORACLE-L Rajesh Dayal wrote: I was also trying to put some script on Oracle scheduler and successful too. But on Oracle 8 I failed. It was successful on Oracle 8i (8 doesn't support execute immediate). Would appreciate, if someone can give equivalent code for Oracle 8. Here is the code for Oracle 8i, create or replace PROCEDURE SWITCH IS 2 BEGIN 3 execute immediate 'alter system switch logfile '; 4 commit ; 5 END; 6 / Thanks in Advance, Rajesh NOTE: It would be executed with any user having sysdba privilege. Look in the doc for the dbms_sql package. Hardly more complicated than 'execute immediate' for DDL (you declare a handler for the cursor, then it's done in two calls, parse and execute). -- Regards, Stephane Faroult Oriole Ltd -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Rajesh Dayal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: OT : howto RTFM
Cant' believe that !!! -Original Message- Sent: Tuesday, January 29, 2002 4:35 PM To: Multiple recipients of list ORACLE-L http://www.microsoft.com[EMAIL PROTECTED]/nyheter/feb01/Q209354%20-% 20HOWTO.htm have fun, Marin ...what you brought from your past, is of no use in your present. When you must choose a new path, do not bring old experiences with you. Those who strike out afresh, but who attempt to retain a little of the old life, end up torn apart by their own memories. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Marin Dimitrov INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Rajesh Dayal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Maximum number of redo log members
One sure way I know is ALTER DATABASE BACKUP CONTROLFILE TO TRACE ; May be someone can point out other methods.. HTH, Rajesh -Original Message- Sent: Wednesday, January 16, 2002 9:50 AM To: Multiple recipients of list ORACLE-L Hi all, Where to find information about my MAXLOGMEMBERS, MAXLOGFILES ? I mean which views or tables (DD) to query from. Note: Oracle doc said see your operating system-specific Oracle documentation, which is I don't have any : ( Thank you Sinardy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinard Xing INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Rajesh Dayal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Oracle 9i Real Application Cluster Concepts manual.
It's http://technet.oracle.com/docs/products/oracle9i/content.html HTH, Rajesh -Original Message- Tatikonda Sent: Wednesday, January 09, 2002 10:25 AM To: Multiple recipients of list ORACLE-L hi all, if any of you has Oracle 9i Real Application Cluster Concepts manual softcopy could you please pass it on to me. Alternately if any of you could provide pointers from where i can download this manual will also be of great help. thanks in advance, Sathish. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sathish Tatikonda INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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). Oracle9i Database - Documentation.url Description: Binary data
RE: Installing Oracle on W2k
Hi Robert, Yea, you got the right point. I was using a server, which had a P4 processor. After lots of searches on metalink, I found the problem and The workarounds ;-)) Great Bug for Great architecture ;-) Thanks for your response, Rajesh -Original Message- Sent: Sunday, December 09, 2001 12:05 PM To: Multiple recipients of list ORACLE-L Any-body had any similar experience? Oh yeahand how. Yours is a Pentium 4 box ? then read on... It's a well-known problem... The reason for this is that the P4 architecture has problems with the Java Just In Time installer. I'm not going to repeat it here. The detailed answers are on orafaq.com, just search on installation windows 2000 Robert - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Sunday, December 09, 2001 12:30 AM Hi All, I am trying to install oracle 8.1.7 on W2k Server. OUI doesn't start at all. What could be wrong? Any-body had any similar experience? TIA, Rajesh -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: RAJESH DAYAL INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Robert Chin INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: RAJESH DAYAL INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
Installing Oracle on W2k
Hi All, I am trying to install oracle 8.1.7 on W2k Server. OUI doesn't start at all. What could be wrong? Any-body had any similar experience? TIA, Rajesh -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: RAJESH DAYAL INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Oracle 7.1 Listener question
If you find listener files in oracle installation then it is there otherwise not ;-)) I think it was there. I had worked with 7.2.3 and even now I can see some of them around. Listener is there. So I think even with 7.1 it would be there. Juck check the following dir, $ORACLE_HOME/network/admin if you can see listener.ora and tnsnames.ora directory it means it is there. HTH, Rajesh -Original Message- Subramanian Sent: Monday, November 19, 2001 10:20 AM To: Multiple recipients of list ORACLE-L Dear List, Pl excuse me for asking a very old question. In one of our client Site are running Oracle 7.1 in SCO Unix. The Appln is unix based and they connect to Oracle via Dumb terminals using I/O card and not network card. We have to migrate the application to Client Server Mode. So we have to install a network card and make listner up and running to accept the connections. The person who installed Oracle 7.1 says that in 7.1 there is no listener and from 7.3 only Oracle came out with the concept of listner. So Gurus some of you might worked in 7.1 in any platform. Could you recollect and tell me whether listener was there in 7.1. I had browsed technet documentation, but there are only 7.3 and upwards documentation and no 7.1 documentation. Thanks in Advance venkat -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: C.S.Venkata Subramanian INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Rajesh Dayal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: listener failed to start a dedicated server process
Hi, check following issues as well, If you are referring ORACLE_HOME in your tnsnames.ora Value of parameter PROCESSES is too low. HTH, Rajesh -Original Message- Kurth Sent: Sunday, November 18, 2001 7:30 PM To: Multiple recipients of list ORACLE-L Assuming you are unix... If you are on 7.3.4 it may be caused by not disabling Oracle trace. Otherwise you have probably exceeded a unix limit, like maxuprc. AM PST Please respond to [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Hi, When I tried to start one more session of oracle SQLPLUS I got this error: ERROR: ORA-12500: TNS:listener failed to start a dedicated server process But the other session which was already open is working properly.Could you please tell me what could be the problem and how to make this not occur again? Thanks, E. __ Do You Yahoo!? Find the one for you at Yahoo! Personals http://personals.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ehsan sinavalda INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Mike J Kurth INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Rajesh Dayal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Import Help
Hi Sujatha, First you import the definitions into a logfile and then create the tablespaces by editing the datafile locations. Imp userid=system/manager full=y file=fulldump.dmp log=fulldump.log show=y When you execute above command, the logfile fulldump.log would have all the tablespace definition in the beginning. You can edit the definitions and execute them separately to create the tablespaces. HTH, Rajesh -Original Message- Madan Sent: Thursday, November 15, 2001 3:38 AM To: Multiple recipients of list ORACLE-L Subject:Import Help Hi, I have an export file from an 8.0.6 database which I need to import into an 8.1.7 db. However, the locations of the tablespaces are different in the 8.1.7 db. How can do the import? Any help will be appreciated. Thanks Sujatha -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sujatha Madan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Rajesh Dayal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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 Archiving insanely
H All, I am facing a very typical problem. One of my client's database has suddenly started archiving like mad. There is no change ( claimed by users) made to the database. I checked Alert log, but could not find anything. Many times it generates up to 50 Mb of Archives per minute( Earlier max upto 2-3 Mb/Min). I did shutdown immediate, which took around 15 min ( acceptable), but immediately after next startup (with no user logged on), in next 3 minutes, it generated 100 Mb of Archives ( how'z that possible) ??? How can I find out what is the thing that's causing such a massive load on database. There is no hotbackup going on. There is no Oracle scheduled job running. On OS side also there is no scheduled job in cron. Please suggest how to get down to the problem. How can I find out which session/user is generating so much of Redo? What possible preventive measures can I take??? We are on Oracle 8.1.6.0.0 on TRU64 Unix. Appreciate your suggestions and immediate help, Rajesh -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rajesh Dayal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Materialized View over 2 tables
Title: Materialized View over 2 tables Thats not a problem. That is well-documented feature and you can check it with standard documents. Fast Refreshes are meant only for simple MVs/Snapshots and not for complex ones. You are supposed to do a complete refresh for complex ones. HTH, Rajesh -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Daiminger, Helmut Sent: Tuesday, October 30, 2001 11:40 AM To: Multiple recipients of list ORACLE-L Subject: Materialized View over 2 tables Hi! Can I have a materialized view to be refreshed fast, when it is created over 2 base tables? Fast refreshes work fine as long as the materialized view is based on 1 base table. But if the view is based on more base tables, it only seems to work with a complete refresh. Does anybody have any experience with that problem? This is 8.1.7 on Sun Solaris. Thanks, Helmut
RE: stop listener remotely
I would cut N Paste one of my previous mails in response to this ( too lazy to type again ;-)) Hi All !! Today I came across a typical Hole in Listener Security. If you have lsnrctl utility (or Database installation) at one Box, then you can stop the listener on another Box. Just change the parameter file (listener.ora) to have hostname of another (may be production server) box. Now goto lsnrctl and fire stop command. you would notice that the local listener is running but the remote listener is down... This is more serious issue on platforms like Unix and VMS where you can control listener (locally) only if you are a member of DBA group. This means that Listener doesn't have any cross OS check in it Is this a known issue/bug. Any-ideas, any patches? Oracle Corp guys, what you say? Waiting for you views.. Rajesh OC DBA 88i One of the good responses was to put a password in listener.ora file. HTH, Rajesh -Original Message- Sairlao, Chark Sent: Wednesday, October 31, 2001 8:45 AM To: Multiple recipients of list ORACLE-L Subject:stop listener remotely all, how can one stop the listener remotely, by using lsnrctl tools? what is advantage of setting listener's password on NT?, if only domain admin will log on the system. Regardless password has set or not, domain admin can always stop any service at will any way. Thanks And Regards Chark -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sairlao, Chark INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Rajesh Dayal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
Corruption in SYSTEM Tablespace
Hi All, Fortunately this is there only in my TEST database. But I am wondering, how to resolve if this happens in Production Database. I can't export Full database with zero errors. Although I can export most of the schemas individually. Dbverify shows some 3 blocks to be corrupted, that's too only in SYSTEM TS. Any ideas would be appreciated. TIA, Rajesh -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rajesh Dayal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Problem - V$BUFFER_POOL_STATISTICS
Wasnt statspack started with 8.1.6? Check the docs.. Rajesh -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Saurabh Sharma Sent: Saturday, October 20, 2001 3:05 PM To: Multiple recipients of list ORACLE-L Subject: Problem - V$BUFFER_POOL_STATISTICS Hi all, Is anyone using Oracle Statspack for performance monitoring. I want to use it, i ran the required scripts for creating the PERFSTAT schema, tables, synonyms and STATSPACK package. but the package creation is giving problem with Dictionary table V$BUFFER_POOL_STATISTICS( as it is not found in the database dictionary) The schema script created the stat$buffer_pool_statistics table to use data from above dict table but package could not be compiled successfully as dictionary table is not found. can anybody explain me why it happened. I'm using Oracle 8.1.5 on NT. thanks in adv Saurabh Sharma Mail to : [EMAIL PROTECTED] : [EMAIL PROTECTED] Contact : saurabh00pc @ MSN / Yahoo
RE: Hot Backup Issue
I think, I need to answer this original post( late, because our time zone is different ;-)) I was doing this in the test environment ( which I mentioned in my original post too) with total database size of 250 Mb. To make the testing easier I had adopted some random method. At that point of time I didn't care whether I choose method 1 or method 2 ( described below). My motive was to design and document a full proof method for recovery from Hotbackup in case of any kind of failure. Somehow I was missing the clue in one of the test cases and I posted the query describing my original steps honestly BTW I am aware of consequences of putting all the TS ( of Production environment) in backup mode in one stretch for hot backup purpose. Any-way, I thank everybody for contributing. Thanks again everybody, Rajesh -Original Message- Sent: Tuesday, October 02, 2001 3:15 PM To: Multiple recipients of list ORACLE-L Hello, Slightly unrelated question... is it better to (in pseudo code) : 1) for each tablespace loop put tablespace in backup mode end loop for each datafile in the database loop copy data file end loop for each tablespace loop put tablespace in normal mode end loop or 2) for each tablespace loop put tablespace in backup mode for each datafile in this tablespace loop copy data file end loop put tablespace in normal mode end loop What I'm doing is (2), but I notice that Rajesh is doing (1). What are the pros and cons of each approach? (I'll probably use RMAN at some point, anyway :0) ). Cheers, g -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Guy Hammond INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Rajesh Dayal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
site-down www.unal-bilisim.com
Hi All, I have been noticing this site down for quite some time. Any idea when this would be up?? TIA, Rajesh -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rajesh Dayal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
Hot Backup Issue
Hi All, I am trying for hot backup restore/recovery. Oracle 8.1.7.0.0 on WIN 2K Server. I am performing the operations in following order: 1. Put all the tablespaces in backup mode. 2. Copy all the datafiles to backup location. 3. Do end backup for all the tablespaces. Also switch logfile after every end backup ( some more switch logfile at the end). 4. Shutdown the database ( after all its test instance). When I try to completely recover the database using backed up datafile the recovery goes upto last archived logfile and even after applying last archived logfile it asks for the next archived logfile. This is a very awkward situation, how can I provide next archived logfile if there is no activity and I had shutdown the database immediately after last switch logfile. If I try to open the database, then I get following error: ORA-01113: file 1 needs media recovery ORA-01110: data file 1: 'D:\ORACLE\ORADATA\OHIR\SYSTEM01.DBF' Upon checking the metalink, some guys suggest, using _allow_resetlogs_corruption = true. But I am afraid of using this, because I have to implement this into production environment too (where same problem is happening). After lots of testing I have found that incomplete recovery (cancel based) goes fine with the same backup and I can open the database without any error. But keeping the needs of production database in mind, it would be very difficult to do an incomplete recovery every time. Why can't I perform complete recovery? Am I missing something? I hope someone on this list would have experienced the problem and would have got the solution as well. Please share your experience... Thanks in Advnace, Rajesh -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rajesh Dayal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Hot Backup Issue
Rachel, You are absolutely right!! Just after dropping the mail I continued with the tests, and discovered the same theory. Thanks a lot for reply. Best Regards, Rajesh -Original Message- Carmichael Sent: Monday, October 01, 2001 4:45 PM To: Multiple recipients of list ORACLE-L I am making the assumption here that you are doing recover database using backup controlfile when you do the backup In this case, what is happening to you is normal. The controlfile doesn't know what the last scn is supposed to be, so all you have to do is cancel the recovery once the last logfile has been applied and open the database resetlogs and you will be fine --- Rajesh Dayal [EMAIL PROTECTED] wrote: Hi All, I am trying for hot backup restore/recovery. Oracle 8.1.7.0.0 on WIN 2K Server. I am performing the operations in following order: 1. Put all the tablespaces in backup mode. 2. Copy all the datafiles to backup location. 3. Do end backup for all the tablespaces. Also switch logfile after every end backup ( some more switch logfile at the end). 4. Shutdown the database ( after all its test instance). When I try to completely recover the database using backed up datafile the recovery goes upto last archived logfile and even after applying last archived logfile it asks for the next archived logfile. This is a very awkward situation, how can I provide next archived logfile if there is no activity and I had shutdown the database immediately after last switch logfile. If I try to open the database, then I get following error: ORA-01113: file 1 needs media recovery ORA-01110: data file 1: 'D:\ORACLE\ORADATA\OHIR\SYSTEM01.DBF' Upon checking the metalink, some guys suggest, using _allow_resetlogs_corruption = true. But I am afraid of using this, because I have to implement this into production environment too (where same problem is happening). After lots of testing I have found that incomplete recovery (cancel based) goes fine with the same backup and I can open the database without any error. But keeping the needs of production database in mind, it would be very difficult to do an incomplete recovery every time. Why can't I perform complete recovery? Am I missing something? I hope someone on this list would have experienced the problem and would have got the solution as well. Please share your experience... Thanks in Advnace, Rajesh -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rajesh Dayal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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). __ Do You Yahoo!? Listen to your Yahoo! Mail messages from any phone. http://phone.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Rajesh Dayal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: cached tables
Just by executing the command alter table xxx cache ; Table won't come in cache. You have to select rows from the table to get itinto cache. Another point is that kept field is meant for pl/sql packages and functionsand not for objects like tables/indexes etc. Below is full details of objectsand their codes that can be kept on database startup. -- Value Kind of Object to keep -- - -- -- P package/procedure/function -- Q sequence -- R trigger -- T type --JS java source --JC java class -- JR java resource -- JD java shared data -- C cursor So just run the command , select * from xxx ; and select * from yyy, and finally check after long timeto verify that only xxx is in cache and yyy is flushed out from cache. Of course for verifying you can use, select name, owner from v$db_object_cache where name in ( 'xxx', 'yyy') ; HTH, Rajesh -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Bunyamin K. KaradenizSent: Saturday, September 29, 2001 10:55 PMTo: Multiple recipients of list ORACLE-LSubject: cached tables I execute alter table xxx cache ; But can not see this cached table on the query below. Why ? Do you have any idea.? SELECT name, type, kept FROM v$db_object_cache WHERE kept='YES';
RE: Block Dump Interpretation
/ Mailing Lists 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). _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: K Gopalakrishnan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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). __ Do You Yahoo!? Get email alerts NEW webcam video instant messaging with Yahoo! Messenger. http://im.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: mohammed bhatti INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Rajesh Dayal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: DB Restore
Hi Paul, Thanks for your reply. Here the scenario is different. I am doing it for the sake of testing, will put in production after testing. Sometimes due to involved complexities and available skills at location you have to be dependent on third party tools. I mean, the client has too many servers ( plus too much of data to be backed up) and they want to centralize this backup issue, which looks great isn't it? Any more (more positive) replies are welcome. Rajesh -Original Message- Sent: Monday, September 24, 2001 10:06 AM To: [EMAIL PROTECTED]; Rajesh Dayal Rajesh, I haven't used this combination. I'm assuming that you're attempting to perform the restore now out of necessity, not out of testing. Restore the files to some other directory and manually copy them to local storage of the Oracle Server. Recover the effected files manually. Call ARCServe support in the morning. This is why dependency on third party tools for backup and recovery is less than optimal. Paul Rajesh Dayal wrote: Hi All, Environment is Oracle 8.0.6 on MS NT. The backup is supposed to be performed using Arcserve. We are going for a Hot Backup using Arcserve Agent. We can perform hot backups without any problem. But when we try to restore, it continuously throws E3201 Unable to connect to network drive. (DRIVE=\\MEMBER\ADMIN$, EC=LOGON FAILURE) Restore Operation Failed. We have checked that ArcServe Administrator is NT Domain Administrator. Once we click the run button, we tried out every user/pass but still the problem is same. I know this is a bit Off topic, but I am sure one of list members must be using this combination. I would highly appreciate, if someone could help us in getting out of this problem. Please let me know what username, password is required to be entered at different stages. Please note that we are not entering any session password for backup sessions. Many TIA, Rajesh -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rajesh Dayal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Rajesh Dayal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
DB Restore
Hi All, Environment is Oracle 8.0.6 on MS NT. The backup is supposed to be performed using Arcserve. We are going for a Hot Backup using Arcserve Agent. We can perform hot backups without any problem. But when we try to restore, it continuously throws E3201 Unable to connect to network drive. (DRIVE=\\MEMBER\ADMIN$, EC=LOGON FAILURE) Restore Operation Failed. We have checked that ArcServe Administrator is NT Domain Administrator. Once we click the run button, we tried out every user/pass but still the problem is same. I know this is a bit Off topic, but I am sure one of list members must be using this combination. I would highly appreciate, if someone could help us in getting out of this problem. Please let me know what username, password is required to be entered at different stages. Please note that we are not entering any session password for backup sessions. Many TIA, Rajesh -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rajesh Dayal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
test
test -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rajesh Dayal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Required Help on Analyzing dmp File
!! Please do not post Off Topic to this List !!Same as my previous mail import using indexfile option. Sorry, I mean use show=y logfile=filename option .. Right Kirty? ;-)) Rajesh -Original Message- Sent: Thursday, September 13, 2001 12:05 PM To: Multiple recipients of list ORACLE-L !! Please do not post Off Topic to this List !!Hi list, Is there any utility provided by oracle through we can extract only table definitions , procedures in another file? -Ketan _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ketan Patel INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Rajesh Dayal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Downloading from Oracle
I am too in the same shoes. Any help from others?? Rajesh -Original Message- Patrice J Sent: Tuesday, September 11, 2001 4:35 PM To: Multiple recipients of list ORACLE-L Sometimes when I download files from the Oracle web sites, I can't use Download Accelerator Plus. I like that utility, it downloads files in parallel. When I try to download using IE, 90% of the time the large .zip file is corrupt and unusable. Has anyone found a way to download the Applications service pack from Oracle successfully? TIA Patrice Boivin Systems Analyst (Oracle Certified DBA) Acting Head Systems Admin Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Rajesh Dayal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: export user definitions
Do a full export ( without data, rows=n ) and import with indexfile option. You can see all the information including users. HTH, Rajesh -Original Message- Sent: Monday, September 10, 2001 1:45 PM To: Multiple recipients of list ORACLE-L hi everyone can anybody help me with a script that recreates user definitions and the granted roles ? thanks g.g. kor rdw ict groningen -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Rajesh Dayal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: export user definitions
Thanks a lot for correcting me,I just remembered the basic idea and missed the real stuff ( SHOW=Y AND LOG=filename) Too Busy with some bugsNpatches of 8.1.7 ;-)) Rajesh -Original Message- Sent: Monday, September 10, 2001 4:10 PM To: [EMAIL PROTECTED]; Rajesh Dayal Rajesh, I am afraid indexfile option will not show such information. If using exported dump file is opted for such information, then it has to be extracted using either 'strings' command (UNIX) or by importing using the show=y log=logfile option. The logfile will then have to be edited to fish out the required information, which may need quite a bit of editing to get a working SQL. I like the 'strings' better for such tasks. HTH, Regards, - Kirti Deshpande Verizon Information Services http://www.superpages.com -Original Message- From: Rajesh Dayal [SMTP:[EMAIL PROTECTED]] Sent: Monday, September 10, 2001 7:10 AM To: Multiple recipients of list ORACLE-L Subject: RE: export user definitions Do a full export ( without data, rows=n ) and import with indexfile option. You can see all the information including users. HTH, Rajesh -Original Message- Sent: Monday, September 10, 2001 1:45 PM To: Multiple recipients of list ORACLE-L hi everyone can anybody help me with a script that recreates user definitions and the granted roles ? thanks g.g. kor rdw ict groningen -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rajesh Dayal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Create Database ORA-907 need help
You don't need to put any Bracket after keyword 'LOGFILE' See following lines... CREATE DATABASE OHIR LOGFILE 'D:\Oracle\oradata\OHIR\redo01.log' SIZE 1024K, 'D:\Oracle\oradata\OHIR\redo02.log' SIZE 1024K, 'D:\Oracle\oradata\OHIR\redo03.log' SIZE 1024K MAXLOGFILES 12 MAXLOGMEMBERS 2 MAXLOGHISTORY 1 DATAFILE 'D:\Oracle\oradata\OHIR\system01.dbf' SIZE 58M REUSE AUTOEXTEND ON NEXT 640K MAXDATAFILES 50 MAXINSTANCES 1 CHARACTER SET WE8ISO8859P1 NATIONAL CHARACTER SET WE8ISO8859P1; HTH, Rajesh -Original Message- Sent: Wednesday, September 05, 2001 11:56 AM To: Multiple recipients of list ORACLE-L Hi all, Can someone tell me whats wrong with my script ? CREATE DATABASE TEST LOGFILE ( '/test/redo01.log' SIZE 10K, '/test/redo02.log' SIZE 10K, '/test/redo03.log' SIZE 10K ) MAXL0GFILES 6 MAXINSTANCES 4 NOARCHIVELOG CHARACTER SET US7ASCII DATAFILE '/test/system01.dbf' SIZE 50M AUTOEXTEND ON ; When I try this script, I recieve this SVRMGRL @CreateDB '/test/redo01.rdo' SIZE 10K, ORA-00907: missing right paranthesis Thank You Sinardy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinardy INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Rajesh Dayal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: sqlldr80- error
Check whether you can tnsping your server. Check your tnsnames.ora file or use Net8 Configuration Assistant for configuring your server to use TCP/IP protocol for local connection HTH, Rajesh -Original Message- Kumar Muthu Kumaran Sent: Sunday, September 02, 2001 11:35 AM To: Multiple recipients of list ORACLE-L Hi gurus, Greetings. c:\ sqlldr80 userid=msalah/msalah@qtel control=c:\test.ctl ORA-12203: TNS:unable to connect destination SQL*Loader-704: Internal error: ulconnect : OCIServerAttach [-1] But am able to connect with SQL*Plus with the same username/password. Why it's showing this error, then?. Am using oracle 8.0.4, on Win NT. Rgds, Nirmal. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nirmal Kumar Muthu Kumaran INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Rajesh Dayal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Datawarehouse suggestions?
Joe, This is just a humble suggestion We would be obliged if you could remove all LLL's from your mail. With so many of these, your mail doesn't fit into preview pane and not to mention, wastage of bandwidth, space etc. Hope you won't disappoint Rajesh -Original Message- Sent: Sunday, September 02, 2001 4:30 PM To: Multiple recipients of list ORACLE-L LLL X-Declude-Sender: [EMAIL PROTECTED] [63.26.83.125] X-Declude-Spoolname: D182f228.SMD X-Note: This E-mail was sent from 1cust125.tnt1.circleville.oh.da.uu.net. ([63.26.83.125]). X-Note: Please send abuse reports to [EMAIL PROTECTED] How about this as a concept: having your datawarehouse sit on top on the oltp(which is think is what you're trying to do, on a side note, i've always wanted to do something like that and write a paper on it, but i'm back now) using materialized views(aka as snapshots), refreshed nightly via materialized view logs. Since you also wont bepruging data , i'd hash partition the materialized view(s). how's that for a start :) joe Rachel Carmichael wrote: Okay, first the rant they want me to build a new database to hold logs of every time someone hits a page on our website or uses one of the functions on the site. Without a new server or disk, on a box that currently holds the OLTP database, on a disk array that is RAID 5 and that EMC wants to take BACK disks from. In other words, they want magic. Where did I leave that rabbit and hat? end rant, here's the setup: Conservative estimate says that one of the two main tables (at least for now) will grow to a GB in a year or two, the other will hit 500M in that timeframe. Rough estimates of # of rows is 273M for the first table, 70M for the second over 2 years. Rows are 200 bytes at max. There will be several small lookup tables and the number of logging tables will increase over time. They are NOT talking about purging data, ever. And we are hoping that the volume INCREASES, not decreases or remains the same, which means the space estimates are no more realistic than throwing a dart at a board and picking a number. Oh yeah, did I mention that they want this to be a reporting database for external customers (read revenue stream) and want these external people to be able to query on any combination of columns -- so they want indexes on EVERY column. I will have a nightly maintenance window for loads of prior day's data. I'm thinking to do a shutdown, change the init.ora to tune for heavy batch, startup, drop indexes, load data, recreate indexes, shutdown, backup, startup with init.ora tuned for querying. question: I've always worked on either batch reporting databases or OLTP, this will be the first semi, sort of data warehouse for me. Advice please on how to build this, as I am doing this one from scratch and can plan it. I'm thinking: database will be 8.1.7, Solaris 2.7 rbs and temp tablespaces as LMTs, remaining tablespaces dictionary-managed db_block_size 16K a large table tablespace with initial/next at 10M a large index tablespace as above a small table tablespace with initial/next at 16K a small index tablespace as above possibly partitioning (I have to check our licenses) on the timestamp field. Any suggestions, gotchas, this is WRONG, here's how to do it comments? Thanks Rachel _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Joe Testa Performing Remote DBA Services, need some backup DBA support? For Sale: Oracle-dba.com domain, its not going cheap but feel free to ask :) IM: n8xcthome or joen8xct -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Rajesh Dayal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list
RE: PERL PROGRAMMING
Hoe about www.perl.com http://www.perl.com/pub/q/documentation Rajesh -Original Message- Sent: Thursday, August 09, 2001 1:25 AM To: Multiple recipients of list ORACLE-L Hi gurus, We have Lot of PERL scripts. (Previous DBA). I am newby to perl . please suggest sites , to start. TIA naren -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Narender Akula INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Rao, UmaSankara S (CAP) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Rajesh Dayal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Is Oracle8.1.7 certified for NT4.0 ?
Yes it is.. Why do you have doubt BTW ;-) Rajesh -Original Message- Bronfin Sent: Wednesday, August 08, 2001 3:26 PM To: Multiple recipients of list ORACLE-L dear list ! Is Oracle8.1.7 certified for NT4.0 ? Thanks a lot in advance. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andrey Bronfin INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Rajesh Dayal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Is Oracle8.1.7 certified for NT4.0 ?
Now with all the answers, you know that it is not the case... In fact with W2K only 8.1.6 and 8.1.7 are certified, rest are too old ;-)) HTH, Rajesh -Original Message- Bronfin Sent: Wednesday, August 08, 2001 5:26 PM To: Multiple recipients of list ORACLE-L i thought may be NT4 is too old for 8.1.7 -Original Message- Sent: Wednesday, August 08, 2001 2:01 PM To: Multiple recipients of list ORACLE-L Yes it is.. Why do you have doubt BTW ;-) Rajesh -Original Message- Bronfin Sent: Wednesday, August 08, 2001 3:26 PM To: Multiple recipients of list ORACLE-L dear list ! Is Oracle8.1.7 certified for NT4.0 ? Thanks a lot in advance. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andrey Bronfin INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Rajesh Dayal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Andrey Bronfin INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Rajesh Dayal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: upgrade
Did you run all the scripts suggested as post-upgrade operation.(like utlrp) HTH, Rajesh -Original Message- Fawzia Sent: Wednesday, August 01, 2001 5:51 PM To: Multiple recipients of list ORACLE-L Hi, I have just upgraded 8.0.5.2 to 8.1.6 and some of my objects are invalid. I have tried to recompile them to no avail. I did the upgrade manually running the script :u0800050. Is there anything else I needed to run??? Rgds Fawzia -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rajesh Dayal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Unix date ??
You can try following .. typeset -i this_mon this_mon=`date +%0m` echo $this_mon typeset -i prev_mon prev_mon=$this_mon-1 echo $prev_mon HTH, Rajesh -Original Message- Sent: Monday, July 30, 2001 3:16 PM To: Multiple recipients of list ORACLE-L Hi all, Unix... My boss ask me to write script for house keeping last month files what is the parameter to get system last month ? for example: thismonth=`date thismonth = thismonth - 1 is not working... regards, Sinardy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinardy INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Rajesh Dayal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Help ! ORA-00600 : internal error code
Earlier it used to mean Goto Oracle Support But now you have a choice. http://www.unal-bilisim.com/products/iorabugfinder/iorabugfinder.html And it works . most of the cases... HTH, Rajesh -Original Message- Sent: Thursday, July 26, 2001 10:31 AM To: Multiple recipients of list ORACLE-L Help ! What does this mean? ORA-00600: internal error cod, arguments : [733], [33719116], [pga heap], [], [], [], [], [] John -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Dunn INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Rajesh Dayal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Securing passwords in scripts
I hv a workaround Change platform to Unix and set permission as 700 ;-)) -Original Message- Sean Sent: Thursday, July 26, 2001 12:55 PM To: Multiple recipients of list ORACLE-L I have some scripts, O.S. command and SQL, which I use to perform COLD backups of DBs and other tasks. I'm not particularily happy about having username/password information in the scripts. Has anyone come up with a way to avoid same allowing for the fact the scripts should require no user input to execute. Sean :) Rookie Data Base Administrator Oracle 7.3.3, 8.0.5, 8.1.7 - NT, W2K [0%] OCP Oracle8i DBA [0%] OCP Oracle9i DBA Organon (Ireland) Ltd. E-mail: [EMAIL PROTECTED] [subscribed: Digest Mode] Visit: http://groups.yahoo.com/group/Oracle-OCP-DBA Nobody loves me but my mother... and she could be jivin' too. - BB King -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: O'Neill, Sean INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Rajesh Dayal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: how do i explain this ?
You can use CURSOR_SHARING = FORCE but be careful, it's initial implementation were quite buggy and it starts with 8.1.6 (don't remember exactly). HTH, Rajesh -Original Message- Sent: Thursday, July 26, 2001 1:37 PM To: Multiple recipients of list ORACLE-L list, this application heavyly make use of literals , NO BIND VARIABLES and was running without any lib cache latch or shared pool latch problems on 7.3.2 We ported the DB to 8.1.5 and v$session_wait is full of latch free event !! all the latch waits are on lib cache and shapred pool (as expected from any app NOT using bind vars) and the app is running terribly slow !! my question is... how 7.3.2 was able to handle this ?? how i explain this to my management ? i was able to convince then on porting to 8i to get better perfornace !! note: i cannot change the app. all changes must be from the back end. TIA Rahul -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rahul INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Rajesh Dayal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Micsoft Technically Correct
A helicopter was flying around above Seattle when an electrical malfunction disabled all of the aircraft's electronic navigation and communications equipment. Due to the clouds and haze, the pilot could not determine the helicopter's position. The pilot saw a tall building, flew toward it, circled, and held up a handwritten sign that said 'WHERE AM I?' in large letters. People in the tall building quickly responded to the aircraft, drew a large sign, and held it in a building window. Their sign said 'YOU ARE IN A HELICOPTER.' The pilot smiled, waved, looked at his map, determined the course to steer to SEATAC airport, and landed safely. After they were on the ground, the copilot asked the pilot how he had done it. I knew it had to be the Microsoft Building, because they gave me a technically correct but completely useless answer. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rajesh Dayal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
Listener Security !!
Hi All !! Today I came across a typical Hole in Listener Security. If you have lsnrctl utility (or Database installation) at one Box, then you can stop the listener on another Box. Just change the parameter file (listener.ora) to have hostname of another (may be production server) box. Now goto lsnrctl and fire stop command. you would notice that the local listener is running but the remote listener is down... This is more serious issue on platforms like Unix and VMS where you can control listener (locally) only if you are a member of DBA group. This means that Listener doesn't have any cross OS check in it Is this a known issue/bug. Any-ideas, any patches? Oracle Corp guys, what you say? Waiting for you views.. Rajesh OC DBA 88i -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rajesh Dayal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Backup script giving error when run by cron
How are you running the .profile?? Try to give full path of .profile file e.g. . /u03/app/oracle/816/.profile Here make sure that your .profile file doesn't call another shell (like ksh -o emacs). Another alternative is to give the full path alongwith command name e.g. /u03/app/oracle/816/bin/svrmgrl ! connect internal shutdown immediate startup shutdown normal ! HTH, Rajesh -Original Message- [EMAIL PROTECTED] Sent: Friday, July 20, 2001 10:25 AM To: Multiple recipients of list ORACLE-L Hi Gurus, Posting again.. Actually the .profile runs thro okay.. But the svrmgrl command given in the shutdown script doesn't run.. It says svrmgrl - not found. I'm running the cron from the dba user. But still the environment is not set. What should I do?? thanks in advance, Manivannan.M Begin Included Message Sent: Wed, 18 Jul 2001 23:40:30 -0800 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Hi gurus, Our database is running on Dynix in a Sequent machine. I tried to put the startup/shutdown script we use in crontab and schedule it. I call a script shut.sh which in turn will call the shutdown.sh script. But it gives me an error saying svrmgrl- not found. I've given here those scripts.. What am I missing?? This shut.sh is called by the cron shut.sh /data23/tbms/.profile /data21/app/oracle/admin/TBMS/dba/shutdown.sh /data21/app/oracle/admin/TBMS/db a/shut.log 2/data21/app/oracle/admin/TBMS/dba/shut.err - shutdown.sh --- ORACLE_SID=TBMS export ORACLE_SID INITIAL_STATUS=`ps -ef|grep ora_[a-z]*_TBMS|wc -l` echo $INITIAL_STATUS if [ $INITIAL_STATUS != 0 ]; then svrmgrl EOF connect internal alter system switch logfile; shutdown immediate; exit EOF DB_STATUS=`ps -ef|grep oracleTBMS` if [ -n $DB_STATUS ]; then echo Starting up the database in restrict mode svrmgrl EOF connect internal startup restrict; shutdown ; exit EOF echo Database TBMS shutdown else echo Error in shutting down database exit fi else echo Database is already shutdown..exiting exit fi - regards, Manivannan.M Enjoy being an Indyan at http://www.indya.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists 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). End Included Message Enjoy being an Indyan at http://www.indya.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Rajesh Dayal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: RULE versus CHOOSE - sorry it's long
. CBO has several features built into it that exploit a proper star schema design and deliver plans more suited to the volume of data (index combining, etc.) I have yet to see an OLTP or hybrid-type system running successfully on CBO, but then again I have only been looking at this closely over the last three years. Maybe the list can shed mroe light on this question. Qs. What do you Folks Advice ? Should I Given in to the 80-20 Rule Or Still Endeavour to persist for optimizer_mode=CHOOSE ? [Lisa Koivu] I can tell you that just analyzing everything, setting optimizer_goal = CHOOSE and restarting the app most likely will not work. Moving to CBO will involve a certain amount of trial and error, with you and the support team learning why CBO does what it does, what can be done differently in the schemas/sql statements, etc. In short, it can be viewed as a sort of migration. Another comment: I believe the 9i doc states that RBO is desupported. Gosh, I highly doubt it, I think Oracle Apps run RBO. But Oracle has been saying for a long time that RBO is going away. Be absolutely sure to read up on this on Metalink/Technet and present your findings to this damager. If this is truly going to happen, this migration will need to happen sooner or later. Sorry to be so long winded. I hope this helps you. Lisa Koivu Data BORED Administrator Ft. Lauderdale, FL, USA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: VIVEK_SHARMA INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Rajesh Dayal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
9i New Features
I thought this would help all in becoming familiar with 9i DB ... http://technet.oracle.com/products/oracle9i/daily/content.html Here you can see one new feature of Oracle 9i on daily basis.. HTH, Rajesh -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rajesh Dayal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: urgent..! how to combining 2 querries...
-Original Message- Sent: Wednesday, July 04, 2001 2:53 PM To: '[EMAIL PROTECTED]' I think you need this comp sum of nfrags totsiz avasiz on report break on report col tsname format a16 justify c heading 'Tablespace' col nfrags format 999,990 justify c heading 'Free|Frags' col mxfrag format 999,999,990 justify c heading 'Largest|Frag (KB)' col totsiz format 999,999,990 justify c heading 'Total|(KB)' col avasiz format 999,999,990 justify c heading 'Available|(KB)' col pctusd format 990 justify c heading 'Pct|Used' select total.tablespace_name tsname, count(free.bytes) nfrags, nvl(max(free.bytes)/1024,0) mxfrag, total.bytes/1024 totsiz, nvl(sum(free.bytes)/1024,0) avasiz, (1-nvl(sum(free.bytes),0)/total.bytes)*100 pctusd from dba_data_files total, dba_free_space free where total.tablespace_name = free.tablespace_name(+) group by total.tablespace_name, total.bytes / PS: Don't remember the source of this script . HTH, Rajesh -Original Message- Sharma Sent: Wednesday, July 04, 2001 11:46 AM To: Multiple recipients of list ORACLE-L ya i checked this too.. it's not working. Saurabh Sharma [EMAIL PROTECTED] http://www.geocities.com/saurabh00pc/stride.html - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, July 03, 2001 7:00 PM sorry. I checked it and turned out that this is wrong solution Hi! Try this. select a.tablespace_name,sum(a.bytes),sum(b.bytes) from dba_data_files a, dba_free_space b where b.tablespace_name=a.tablespace_name group by a.tablespace_name Gyula -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Saurabh Sharma INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Rajesh Dayal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
test
test. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rajesh Dayal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: OT RE: 24 x 7 on NT?
everything fits into the whole. Because I know what everything is doing, and how it behaves I can walk up to a windows machine and fix the problem. Windows is easy to use, easy to set up, and IS useful for the day to day things of the average end user. When I walk into a data center at sun, or TI, or nokia, or ericson, or eds, or any fab plant I see rows and rows of sun / hp boxes doing a whole range of high availability services. When I walk into broadwing or aperian or some other co-loc place that hosts a bunch of .com's and see rows of way over priced/powered dell servers hosting the 50 hits a day that averagestartup.com is getting then I think fine... what has the world lost if that machine goes down? Do you think that this place really was bright enough to hire a knowledgeable person to make the decisions in the first place. I mean come on they're whole company plan is based around insert crappy idea here. Its not a coincidence that there are rows of 6500/5500's and e10k's doing the important work and slews of relatively cheap windows machines doing the grunt labor that isnt what fuels the business... and its not cause sun has a great marketing/sales department either (most of those guys dont know their head from their ass). The world is full of generalizations so here's mine: Windows is good for what it does. The average person doesnt have to learn much/anything to use it. It sucks at what it doesnt do, and it doesnt do high availability. As for the quote, its not mine, I just found it amusing. I dont constantly complain about windows because I dont use it, but then again, I dont like to sit on my ass as others pass 3rd rate information about a 3rd rate os on to others... all that breeds is some more 3rd rate people ;) All I'm doing is protecting my sanity/nerves by having a few less morons out there, but as I can see its already too late for some :) Thanks, jon The idea that Bill Gates has appeared like a knight in shining armor to lead all customers out of a mire of technological chaos neatly ignores the fact that it was he who, by peddling second- rate technology, led them into it in the first place. -- Douglas Adams If you have trouble sounding condescending, find a Unix user to show you how it's done. -- Scott Adams ---trim--- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Rajesh Dayal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Upgrade 8.0.4 to 8.1.6
These are the reasons I don't tend to rely on these GUI tools Last month-end I did some migration (of four databases) 8.0.4 to 8.1.7 manually and pretty successfully on NT. Check Note 133920.1 on Metalink . You might need this... All the best, Rajesh OC DBA 88i -Original Message- Sent: Monday, June 25, 2001 2:06 PM To: Multiple recipients of list ORACLE-L Hello I am in the process of upgrading from 8.0.4 to 8.1.6.. it asked if I wanted to migrate my 8.0.4 datafiles to 8.1.6. I said yes to this and it started migrating, this was on friday. Today it still seems to be going , its a 8 gig database..; If I click on Finish it says that the upgrade hasn't finished.. If I click on the cancel it says that if u cancel the database won't be in the original state. The status bar has only moved a fraction. Should it take this long ? Should I cancel ? TIA -- Sajid Iqbal -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sajid Iqbal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Rajesh Dayal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Yahoo!
From subject line, I thought it's some ad from yahoo.com ;-)) Any-way... Happy SCO+Oracle Learning Cheers, Rajesh -Original Message- Luthra Sent: Wednesday, June 20, 2001 11:10 AM To: Multiple recipients of list ORACLE-L Hello every one, Hey you know what after a long battle, finally installed SCO 7.1.0 and on top of that Oracle 8. Thanks to a lot of people, but Kirti Deshpande ( I think ) stands out, you helped me with some good things. Actually the whole problem was with the swap, it was too small, so be careful guys when you get Out of Memory problems you need to add in swap. Doing a man swap will pull you out. Okay now I can practse some more Oracle, I think I will start with building some databases. May the fun begin. Thanks again raja Get 250 color business cards for FREE! http://businesscards.lycos.com/vp/fastpath/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Viraj Luthra INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Rajesh Dayal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
