RAM usage
Hi, I am sorry if I missed out the reply to this or amy 'repeating' the question But can someone help me please? I am trying to find the 'exact' amount of memory consumed out of the RAM by each Oracle process. The Oracle manual says that , "NOT ALL of the memory displayed by ps command is due to PGA" some of it is Oracle code (is it Oracle executable?) Can someone please tell how to estimate the amount of memory required? ie how much PGA? how much Oracle code? how much overhead etc? Thanks a lot PS: Please note that the above exercise is not academic and is urgently required by me to order for RAM _ Chat with your friends as soon as they come online. Get Rediff Bol at http://bol.rediff.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cyril Thankappan 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: EM 2.2 installation crashes my database
Hi! is OMS/ORACLE/OEM installed on same Oracle HOME? I've not used Oracle 8.1.7 but it is supposed to be the 1st and only version where 'everything can be done' in one Oracle HOME... Kindly reply PS: I had the following Client (Windows 98)OEM 2.1 OMS (solaris Sparc 2.6) OMS 2.1 Repository (Solaris Sparc 2.6) Oracle 8.1.6 However the moment I moved to Client (Windows 98)OEM 2.1.0.2 (available with IAS CD) OMS (solaris Sparc 2.6) OMS 2.1 Repository (Solaris Sparc 2.6) Oracle 8.1.6 Everthing stopped, with VT-1001 Can someone help? As of now we r awaiting CD for Oracle 8.1.7 on Solaris to install OEM 2.2 from it. !! Thanks - Original Message -- Schoen Volker [EMAIL PROTECTED] wrote: To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] From:Schoen Volker [EMAIL PROTECTED] Date:Fri, 23 Feb 2001 01:50:22 -0800 Subject:EM 2.2 installation crashes my database Hi list, I had a curious with Oracle Enterprise Manager 2.2 (Management Server = 2.2). I have a Oracle 8.1.6.3 installation on W2K Server. Running one = database, one listener and Oracle Management Server 2.1 and Enterprise Manager = 2.1. Installation of database and management server ist located in the same oracle home. Yesterday I downloaded Oracle Enterprise Manager 2.2. So I updated my Oracle Management Server 2.1 to 2.2 include EM 2.1 to 2.2. = After installation my listener and my database didn't start. W2K event log = says that there are some dll's missing. So I had to reinstall my comlete = oracle installation. My luck was, that I had a cold backup of database. Did I something wrong. Has Oracle management server be located in a different oracle home? Mit freundlichen Gr=FC=DFen i. V. Volker Sch=F6n INPLAN RUHR Informationstechnik GmbH Tel.: +49 208 / 65 91 - 950 Fax: +49 208 / 65 91 - 980 E-Mail: mailto:[EMAIL PROTECTED] http://www.inplan.de -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Schoen Volker 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). _ Chat with your friends as soon as they come online. Get Rediff Bol at http://bol.rediff.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cyril Thankappan 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: Oracle 8i On solaris
but hey!!! is an ICG available for Oracle 8i on Solaris 10??? " am about to install Oracle 8i Enterprise on Sun Solaris version 10." Please let me know more about Solaris 10! - Original Message -- Diana Duncan [EMAIL PROTECTED] wrote: To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] From:Diana Duncan [EMAIL PROTECTED] Date:Fri, 23 Feb 2001 15:11:06 -0800 Subject:RE: Oracle 8i On solaris Follow the installation guide VERY CAREFULLY. Most people fail to install Oracle on Unix because they don't read the instructions. You must modify kernal parameters and do other Unix admin steps prior to installation. One thing to ignore (at least in my opinion) -- the instruction to create an "oinstall" user. I've found this causes more trouble than it's worth when it comes to patching. Just use the "oracle" user in the "dba" group. Go to technet.oracle.com for the installation guide. Regards, Diana -Original Message- Sent: Friday, February 23, 2001 11:06 AM To: Multiple recipients of list ORACLE-L Hi everyone: I am about to install Oracle 8i Enterprise on Sun Solaris version 10. Any Practical documentation or site which could help me on installing and configuring this system will be appreciated. I was away from Unix for a while. I have already checked the Oracle.com. I appreciate your help in advance. Majid -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Majid Kazemi 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: Diana Duncan 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). _ Chat with your friends as soon as they come online. Get Rediff Bol at http://bol.rediff.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cyril Thankappan 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: Can Oracle7 and Oracle8 co-exist?
Hi! can you please ( I beg) tell me which platform supports (in the sense of Oracle having certified it) both Oracle 7.3.4 and Oracle 8.1.7? - Original Message -- "Ben Poels" [EMAIL PROTECTED] wrote: To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] From:"Ben Poels" [EMAIL PROTECTED] Date:Mon, 26 Feb 2001 10:11:18 -0800 Subject:RE: Can Oracle7 and Oracle8 co-exist? Hi Scott, Nice to hear from you again. I am migrating several warehouses on the same server from 734 to 817. If I use a separate owner then I won't have to worry about running different profiles when I sign on. (heh I'm getting older with some gray hairs and I am liable to forget which set of databases I'm working on). I also can set up separate cron jobs under the different owner sign-ins and easily migrate one warehouse at a time. I don't really see any drawbacks to using different owners even if it isn't a requirement. Ben Poels Queen's University Kingston, Ontario (613)533-2449 -Original Message- Canaan Sent: Friday, February 23, 2001 4:47 PM To: Multiple recipients of list ORACLE-L Ben, This is no problem. They don't need to have different owners. If you are running Oracle Applications 10.7, and you want to use an Oracle 8i instance to house it, then you must do this type of install. You will have 2 Oracle homes, each with it's own database listener and all associated files. They will be installed in separate directories, by default. You will need to have a way to setup your environment when you login to pick the Oracle home you want to use and setup all of the environment variables correctly. Ben Poels wrote: Hi, I want to install Oracle 8.1.7 on the same AIX 4.3.2 box which is already running Oracle 7.3.4.5. I will use a separate Oracle owner and Oracle home for the new 8.1.7 software. Has anybody had any problems with these two versions co-existing on the same platform? I have them both installed now but before I spend a lot of time trying to break it I thought I'd check to see whether or not this has worked out at other sites. Thanks, Ben Poels Queen's University Kingston, Ontario -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ben Poels 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). -- Scott Canaan ([EMAIL PROTECTED]) "Life is like a sewer, what you get out of it depends on what you put into it" - Tom Lehrer -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Scott Canaan 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: Ben Poels 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). _ Chat with your friends as soon as they come online. Get Rediff Bol at http://bol.rediff.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cyril Thankappan 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 li
Re: OPS on AIX/rs600
Hi! This is our precise condition! For the last month IBM guys have been 'trying to give' us the planned hardware solution!! Please let me know about ur 'journey'! For starter a. Find out how IBM plans to provide u with 'shared disks' Please let me know their response!!! b. Oracle requires HACMP (provided) by IBM to be installed. c. A high speed interconnect between nodes will be required. again Please let me know ur IBM response. cos I have it from Oracle that tho'IBM may insist on ethernet nothing short of Gigabit Card or Fibre would do WE are stuck cos IBM has not delievered on what it intends to Can you please tell me what IBM is providing u with? As far as OPS is considered I feel it becomes more a O/S vendor problem than Oracle Problem! Thanks - Original Message -- "Alex Hillman" [EMAIL PROTECTED] wrote: To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] From:"Alex Hillman" [EMAIL PROTECTED] Date:Mon, 05 Mar 2001 15:01:53 -0800 Subject:OPS on AIX/rs600 Hi, guys. I may need to implement OPS 8.1.7 on AIX/RS-6000 . I do not have much experience with AIX. Most of my unix experience is on Solaris and I have good understanding about OPS issues on Sun and Veritas clusters. Could somebody give me some pointers - specics for AIX and RS-6000 implementation of OPS, please. Alex Hillman -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alex Hillman 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). _ Chat with your friends as soon as they come online. Get Rediff Bol at http://bol.rediff.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cyril Thankappan 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: guidance for career in US as D.B.A.
Hi! Maybe this is off topic, but nevertheless it is relevant to our lives! With economies 'slowing down' globally can each of you please tell what is the 'general IT scene'and Oracle scene in particular, in your country? Thanks - Original Message -- Mandar Ghosalkar [EMAIL PROTECTED] wrote: To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] From:Mandar Ghosalkar [EMAIL PROTECTED] Date:Wed, 07 Mar 2001 18:20:28 -0800 Subject:RE: guidance for career in US as D.B.A. Hi neena Hi All , I am in India . I am an OCP DBA (8i) having three years IT experience ( Oracle( 7.3, 8 ) and Developer2000 , OS - windows NT).Three months back I have joined one of the known company of India. The role of mine in the present job is of DBA. I have to handle two Oracle 7.3 databases on AIX of an application which is stable since last five years. As the application is stable I am not getting good / challenging exposure to DBA activities. First imp thing is that u always be in this situation. once the app becomes stable u will always find urself idle. 1. Design a Disaster Recovery plan doc for ur db 2. Write db health check routines 3. research and find out how fatal bugs in 7.3 can stop ur production site 4. find out what wld stop (techincally) from migrating to 8i 5. learn AIX My aim is to go to US . Can you guide me : Well the green paper is always yummy... 1.. How to get the list of good firms in US , to apply for a DBA post ? www.dbajobs.com www.dice.com 2. Shall I change my present job , just because the database is of older version ( which I was not knowing while joining ) ? change ur job if u dont hv work. not the question of version. its the question of what u know in that version. remember versions will keep on coming. by the time u come to US and settle here, it may be 9i, who knows. there r many gurus on this list who r masters in 7.x, cos that what their job demanded. i met a guy in LA who had worked for NASA and had been working on almost all types of unixes and oracle 7, was a dba, but hardly knew any features of 8i. well he didnt found a need to keep up to date. 3. Will certification of Sun Solaris System Administration be helpful to me? learning an OS never harms. it wld certainly add to ur resume. 4. Will an Advanced DBA course ( Oracle parallel server, Replication, distributed DB) be helpful to me ? where will u apply that? well u can always learn everything, but try to balance it against ur job requirements and in which sector of Oracle admin u want to excel. For a start why dont u try getting ur OCP in 8i. -- neena -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mandar Ghosalkar 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). _ Chat with your friends as soon as they come online. Get Rediff Bol at http://bol.rediff.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cyril Thankappan 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: guidance for career in US as D.B.A.
Hi! Maybe this is off topic, but nevertheless it is relevant to our lives! With economies 'slowing down' globally can each of you please tell what is the 'general IT scene'and Oracle scene in particular, in your country? Thanks - Original Message -- Mandar Ghosalkar [EMAIL PROTECTED] wrote: To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] From:Mandar Ghosalkar [EMAIL PROTECTED] Date:Wed, 07 Mar 2001 18:20:28 -0800 Subject:RE: guidance for career in US as D.B.A. Hi neena Hi All , I am in India . I am an OCP DBA (8i) having three years IT experience ( Oracle( 7.3, 8 ) and Developer2000 , OS - windows NT).Three months back I have joined one of the known company of India. The role of mine in the present job is of DBA. I have to handle two Oracle 7.3 databases on AIX of an application which is stable since last five years. As the application is stable I am not getting good / challenging exposure to DBA activities. First imp thing is that u always be in this situation. once the app becomes stable u will always find urself idle. 1. Design a Disaster Recovery plan doc for ur db 2. Write db health check routines 3. research and find out how fatal bugs in 7.3 can stop ur production site 4. find out what wld stop (techincally) from migrating to 8i 5. learn AIX My aim is to go to US . Can you guide me : Well the green paper is always yummy... 1.. How to get the list of good firms in US , to apply for a DBA post ? www.dbajobs.com www.dice.com 2. Shall I change my present job , just because the database is of older version ( which I was not knowing while joining ) ? change ur job if u dont hv work. not the question of version. its the question of what u know in that version. remember versions will keep on coming. by the time u come to US and settle here, it may be 9i, who knows. there r many gurus on this list who r masters in 7.x, cos that what their job demanded. i met a guy in LA who had worked for NASA and had been working on almost all types of unixes and oracle 7, was a dba, but hardly knew any features of 8i. well he didnt found a need to keep up to date. 3. Will certification of Sun Solaris System Administration be helpful to me? learning an OS never harms. it wld certainly add to ur resume. 4. Will an Advanced DBA course ( Oracle parallel server, Replication, distributed DB) be helpful to me ? where will u apply that? well u can always learn everything, but try to balance it against ur job requirements and in which sector of Oracle admin u want to excel. For a start why dont u try getting ur OCP in 8i. -- neena -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mandar Ghosalkar 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). _ Chat with your friends as soon as they come online. Get Rediff Bol at http://bol.rediff.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cyril Thankappan 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).
fast_start_io_target and log_checkpoint_interval
Hi! is there any difference in the way oracle processes FAST_START_IO_TARGET and LOG_CHECKPOINT_INTERVAL apart from the fact that fast_start_io_target gives us a measure of no:of i/os required for instance recovery and log_checkpoint_interval gives us the number of o/s blocks required for instance recovery. My question is, if both r 'MORE OR LESS' doing the same thing, why the 'redundancy'??? surely am I missing something here... Kindly correct me.. Thanks _ Chat with your friends as soon as they come online. Get Rediff Bol at http://bol.rediff.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cyril Thankappan 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: Conversion of man (unix) into Txt file
sorry if it is answered already try man ls|col -b ls.txt - Original Message -- chandan [EMAIL PROTECTED] wrote: To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] From:chandan [EMAIL PROTECTED] Date:Sun, 18 Mar 2001 10:25:40 -0800 Subject:Conversion of man (unix) into Txt file Hi All, Does anyone know how to convert unix MAN into a text file ? -- neena -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: chandan 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). _ Chat with your friends as soon as they come online. Get Rediff Bol at http://bol.rediff.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cyril Thankappan 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: SUN vs. HP
HI.. can someone please tell me a 'bit more' about HP does it follow the 'basic tenets' of UNIX or is it a 'freak deviant' version of UNIX (like AIX!!!).. For starters what is service guard please? is it a cluster software? or RAID software to handle disk boxes? How 'different' is HP unix from Solaris? (both from a DBA's point of view and sys admin's point of view)! Thanks - Original Message -- "C.S.Venkata Subramanian" [EMAIL PROTECTED] wrote: To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] From:"C.S.Venkata Subramanian" [EMAIL PROTECTED] Date:Tue, 20 Mar 2001 20:16:34 -0800 Subject:Re: SUN vs. HP I have been working with Oracle under HP, I find HP server with high fault toulerence and reliable. If we tune the OS and DB then we can get maximum performance. One word of caution is that, if u use Mc Servicegaurd then u shud go for OPS. Which works for only on RAW partitions. Administration will not be a easy job. Instead go for AutoRAID box which HP has got. It converts itself bet RAID5 and RAID1/0. My recomendation will be for RAID10, where u have disk mirroring,stripping and protection for Data and better performance. I have not worked with SUN. But i have heard that the native code,compilation and testing of oracle is in the SUN OS. But HP is also a good OS. H/w is slightly costlier in HP. -- On Tue, 20 Mar 2001 10:31:59 Alex Apostolopoulos wrote: Hi, we are currently in the process of evaluating a high availiability cluster for our production database. The final two solutions are: SunCluster 2x420R 2Gig 2x450Mhz Storage 100Gig Hewlett Packard MC ServiceGuard 2xL-Class 2x440Mhz 2Gig Storage VA 7100 100Gig Based on our criterias (scalability, performance, TCO, price, reliability, support, in house experience ...) it looks like a dead race... Any suggestions or thoughts would be help full cheers alex -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alex Apostolopoulos 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). Get 250 color business cards for FREE! at Lycos Mail http://mail.lycos.com/freemail/vistaprint_index.html -- 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). _ Chat with your friends as soon as they come online. Get Rediff Bol at http://bol.rediff.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cyril Thankappan 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:RE: 32bit vs 64bit (was: Just like Christmas)
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). _ Chat with your friends as soon as they come online. Get Rediff Bol at http://bol.rediff.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cyril Thankappan 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).
NOT A SINGLE MAIL!
Hi! I haven't received a single mail from the LiST.. Is there a problem? Please tell Thanks - Original Message -- "Rachel Carmichael" [EMAIL PROTECTED] wrote: To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] From:"Rachel Carmichael" [EMAIL PROTECTED] Date:Thu, 22 Mar 2001 05:36:05 -0800 Subject:RE: EMC TimeFinder, and EMC TimeFinder vs Hot Standby Tim, That sounds about right. SRDF is something like Symmetrix Remote Data Facility and is basically mirrored disks at a remote site. Rachel From: "Tim Sawmiller" [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: EMC TimeFinder, and EMC TimeFinder vs Hot Standby Date: Thu, 22 Mar 2001 04:30:26 -0800 So, Jared, are you auditioning for Louis Rukeyser's job? 8-) Lisa can probably explain better, but as I recall, BCV is something Backup Control Volumes. It's a third mirror that can be split off from the other two and used for a cold backup (e.g. shutdown Oracle database, split BCVs from the mirror set, restart Oracle (this takes like 5 minutes or less); run cold backup at your leisure). Then they can be re-attached to the mirrored disks at any time and the BCVs are synchronized with the mirrored disks automagically. Right Lisa? [EMAIL PROTECTED] 03/21/01 11:17PM Ok, does someone one to define SRDF and BCV for those of us that don't have any idea what you're talking about? Jared On Wed, 21 Mar 2001, Koivu, Lisa wrote: Hi Yosi, how are you? I can't exactly clarify your fish vs. potatoes, er, timefinder vs. SRDF question but I can tell you that we have BCV's implemented here. We use them for backup and recovery (and it's extremely slick and fast, let me tell you! Worth every penny we paid) However you can also mount the BCV's and access the data. Honestly I don't see any reason why I wouldn't be able to install Oracle on this server and open up a read-only database on the BCV's. Except for maybe the fact that my employer practically chokes when Oracle quotes pricing. We are running HP/UX. If you want more specific info, email me directly and I'll be glad to answer questions. Have a great day... Lisa Rutland Koivu Oracle Database Administrator -- 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: Tim Sawmiller 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). _ Get your FREE download of MSN Explorer at http://explorer.msn.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). _ Chat with your friends as soon as they come online. Get Rediff Bol at http://bol.rediff.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cyril Thankappan 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] (no
Re: Re: In Praise of Metalink
Hi.. can someone please let me know who is eligible for access to Metalink? (ie can someone please explain the bronze and silver thing!!) (again!! if i've missed it!) thanx - Original Message -- "James Howerton" [EMAIL PROTECTED] wrote: To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] From:"James Howerton" [EMAIL PROTECTED] Date:Fri, 30 Mar 2001 14:00:24 -0800 Subject:Re: In Praise of Metalink It appears to be working fairly well today. ...JIM... [EMAIL PROTECTED] 3/30/01 3:35:22 PM Since I've complained loudly when Metalink stinks I feel obligated to give = them a pat on the back when it works. And today on three separate = occasions it was downright snappy. Anybody else have a similar experience = or have I just been inhaling controlled substances again? Jim=20 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com=20 -- Author: Jim Conboy INET: [EMAIL PROTECTED]=20 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: James Howerton 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). _ Chat with your friends as soon as they come online. Get Rediff Bol at http://bol.rediff.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cyril Thankappan 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).
PPRC and Oracle
HI list! IBM has relased a product (software) called Peer-to-Peer Remote copy. IBM claims that this product is like 'hardware-mirroring' does anyone know of this product and how it works (if it works at all!) with Oracle. Can someone please tell me where to find this info? Thanx a lot _ Chat with your friends as soon as they come online. Get Rediff Bol at http://bol.rediff.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cyril Thankappan 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: bFILES Recovery Manager
Hello! Does recovery MANAGER support bfiles? if so any idea when Oracle plans to support them? THanx - Original Message -- [EMAIL PROTECTED] wrote: To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] From:[EMAIL PROTECTED] Date:Wed, 04 Apr 2001 10:20:29 -0800 Subject:Re: Recovery Manager vs. SQL Back Track SQL-Backtrack was a good product at one time. In theory it still is. Here's the problem though. When Data Tools sold SQL-Backtrack to BMC, it seems that anyone that knew anything about the product left. There is no one in tech support that can help you beyond the menu items. There is no one there that knows how to run their product from the command line. Some recovery scenarios require command line operation, and wouldn't you know, we lost a database at a former employer for that very reason. Jared On Tue, 3 Apr 2001, Yttri, Lisa wrote: Hi everyone - Currently we are doing backups manually, periodic cold backups, and hot backups in between - we are running in archivelog mode. We are running 8.1.5 and 8.1.6 (soon to be 8.1.7) on Sun Solaris. Today there are only a few small production servers (2 - 5 GB), but we are anticipating a couple large ones (~200GB), and a data warehouse (anticipated to be around 500GB). We have started playing around with Recovery Manager. Our Sybase DBAs are telling us we should look at SQL BackTrack instead. For those of you who are using either one, I'd appreciate your comments on how well you like / don't like it and any "gotcha's" that you have run into. Other than the cost factor, what would you recommend? Thanks very much - Lisa Jared Still [EMAIL PROTECTED] -- 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). _ Chat with your friends as soon as they come online. Get Rediff Bol at http://bol.rediff.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cyril Thankappan 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: Re: bFILES Recovery Manager
hi thanx - Original Message -- [EMAIL PROTECTED] wrote: To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] From:[EMAIL PROTECTED] Date:Wed, 04 Apr 2001 13:24:12 -0800 Subject:Re: Re: bFILES Recovery Manager On 4 Apr 2001, Cyril Thankappan wrote: Hello! Does recovery MANAGER support bfiles? if so any idea when Oracle plans to support them? THanx I don't know, but I doubt it. Jared -- 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). _ Chat with your friends as soon as they come online. Get Rediff Bol at http://bol.rediff.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cyril Thankappan 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:Driving table
hi Firstly, can we please keep this online? My opinion (observation!).. in RBO the driving table is the rightmost in CBO it need not be so..cos the optimizer decides the order. can someone confirm the observation regarding CBO? Thanx PS: sorry If i missed this...in some earlier post. But can someope please explain to me how Oracle processes EXISTS/NOT EXISTS and IN/NOT IN I have read (been told and also observed) that EXISTS/NOT EXISTS performs better than IN/NOT IN, but have always wondered HOW - Original Message -- [EMAIL PROTECTED] wrote: To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] From:[EMAIL PROTECTED] Date:Fri, 06 Apr 2001 10:18:00 -0800 Subject:Re:Driving table Anup, This can get into a lengthy discussion, but I'll try to keep it short. In general you can use this in both CBO and RBO, since in my experience doing things well for RBO has no ill affect on CBO. The table order in the 'from' clause should match the order in the 'where' clause. Since Oracle reads a statement backwards, bottom to top, left to right, the last table listed in the 'from' clause should have the most restrictive and therefore the last condition in the 'where' clause. The reason for caring about the driving table is that the rows returned from that table drive the remainder of the query. So if you can return the least number of rows from that table you then have less work to do thereafter. If you want a more detailed discussion, can we take it off-line. Dick Goulet Reply Separator Author: [EMAIL PROTECTED] Date: 4/6/2001 2:45 AM Hi friends , I have got some query regarding , how the query is exactly executed ?? We always take joins and if we see the plan of the query , there is always one main driving table . Some times I get feeling that , in the join the right most table is the driving table . But that is not always true , this is my observation from several plans . In Oracle documentation alos ita mentioned that ( Server Concepts, 815 or 816 : Optimisation of Joins ), "one driving table is selected" , but at least I cannot makeout which of the several tables will be selected as driving table . What can be the potential criterions of selecting a driving table ? Please , if you all can throw some light on the same or can redirect to some document , that would be great . Cheers , Anup Saxena --- The contents of this e-mail are confidential to the ordinary user of the e-mail address to which it was addressed and may also be privileged. If you are not the addressee of this e-mail you should not copy, forward, disclose or otherwise use it or any part of it in any form whatsoever. If you have received this e-mail in error please notify us by telephone or e-mail the sender by replying to this message, and then delete this e-mail and other copies of it from your computer system. Thank you. We reserve the right to monitor all e-mail communications through our network. -- 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: 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). _ Chat with your friends as soon as they come online. Get Rediff Bol at http://bol.rediff.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cyril Thankappan 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] (
Re: SECRET
Hi! Man , I should say that I am 'surprised'.. cos we were on WAS 3.0.2 and had 'severe problems' (the webserver used to hang during business hours) and Oracle suggested we upgrade to IAS how come u are able to 'run' WAS without Oracle 'support' can u please let me into the secret! - Original Message -- "Boivin, Patrice J" [EMAIL PROTECTED] wrote: To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] From:"Boivin, Patrice J" [EMAIL PROTECTED] Date:Mon, 09 Apr 2001 10:26:29 -0800 Subject:OWS / OAS / iAS cartridge limit We have an old Oracle Web Server 3.0.1.1 here, with now nine cartridges, and CPU remains consistently above 95%. This is a dual 350MHz CPU Dell PowerEdge 2400. I am curious now, is there a practical limit to the number of cartridges an Oracle Web Server can support without some part of it becoming a CPU hog. Out of curiosity, are there people out there running Oracle web server setups with eight or more cartridges concurrently? Regards, Patrice Boivin Systems Analyst (Oracle DBA) Bedford Institute of Oceanography -- 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). _ Chat with your friends as soon as they come online. Get Rediff Bol at http://bol.rediff.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cyril Thankappan 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:32bit v. 64bit Oracle
Hi! can u pls tell me the errros u encountered in opening 64-bit database using 32-bit Oracle or vice versa? Thanx - Original Message -- [EMAIL PROTECTED] wrote: To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] From:[EMAIL PROTECTED] Date:Fri, 13 Apr 2001 06:05:25 -0800 Subject:Re:32bit v. 64bit Oracle Connie, 1st, can you have a 32 and 64 bit database on the same machine: Yes we've got two machines working that way with no problems. 2nd, Can you migrate from 32 to 64 bit: Yes via exp/imp. I've tried just mounting the database files with the 64 bit executables the errors are not pretty. It would appear that Oracle does not like the control file the database file headers. Dick Goulet Reply Separator Author: Connie Milliken [EMAIL PROTECTED] Date: 4/12/2001 7:00 PM Can you upgrade an Oracle 8.0.5 32bit database on HPUX11 to Oracle 8.1.6 64bit? Is is possible to have 8.0.5 32 bit and 8.1.6 64 bit on the same box if the box is 64 bit? If you wanted to restore a copy of production to dev and production was 64 bit and dev was 32bit, would you still be able to do the restore (using Veritas Netbackup)? What are the advantages of being 64 bit versus 32 bit? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Connie Milliken 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: 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). _ Chat with your friends as soon as they come online. Get Rediff Bol at http://bol.rediff.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cyril Thankappan 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).
TNS-12500
Hi.. can someone throw some 'more' light on TNS-12500 (apart from RAM,resources problem) Thanks _ Chat with your friends as soon as they come online. Get Rediff Bol at http://bol.rediff.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cyril Thankappan 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: TNS-12500
Hi! True, but finally how was it solved at ur end? cos at my end , I have tried everything including adding RAM.. still it won't go.. - Original Message -- "Deshpande, Kirti" [EMAIL PROTECTED] wrote: To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] From:"Deshpande, Kirti" [EMAIL PROTECTED] Date:Sat, 14 Apr 2001 12:50:18 -0800 Subject:RE: TNS-12500 I think Note:2064862.102 on Metalink has 'enough' light on this topic. I had to deal with it a few months ago. HTH - Kirti Deshpande Verizon Information Services http://www.superpages.com -Original Message- From: Cyril Thankappan [SMTP:[EMAIL PROTECTED]] Sent: Saturday, April 14, 2001 2:25 PM To: Multiple recipients of list ORACLE-L Subject: TNS-12500 Hi.. can someone throw some 'more' light on TNS-12500 (apart from RAM,resources problem) Thanks _ Chat with your friends as soon as they come online. Get Rediff Bol at http://bol.rediff.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cyril Thankappan 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: Deshpande, Kirti 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). _ Chat with your friends as soon as they come online. Get Rediff Bol at http://bol.rediff.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cyril Thankappan 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).
Cold Fusion and Oracle
Hi!.. DOes any one here have any information of where I could possibly find some information on Cold fusion and Oracle Thanks _ Chat with your friends as soon as they come online. Get Rediff Bol at http://bol.rediff.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cyril Thankappan 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).
Licensing! Again!!
Hi! really sorry if I am 'dragging u back'! But can someone help me with Oracle's licensing policy (policies!) for servers and particularly the terms CONCURRENT USERS Does 'concurrent users' mean that if 1 user has 3 concurrent sessions , is he counted once or thrice? LICENSE_HIGH_WATER_MARK what does this term 'actually' mean in the alert.log Does it mean concurrent users as defined above? or Thanks a lot - Original Message -- Eric D. Pierce [EMAIL PROTECTED] wrote: To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] From:Eric D. Pierce [EMAIL PROTECTED] Date:Mon, 23 Apr 2001 09:40:25 -0800 Subject:Re: Prices of the Oracle internet Developer Suite components I don't know about the other stuff, but Developer/2000 r.2x was priced by Oracle sales people at about USA $4,000 per seat. I think they went up to USA $5,000 or more since I last asked for a precise price quote. I have a vague recollection that Designer was more than that, but that higher price may have included Developer. regards, ep On 20 Apr 2001, at 19:00, djordjej wrote: Date sent: Fri, 20 Apr 2001 19:00:28 -0800 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Oracle Designer can now be bought as a part of the Oracle internet Developer Suite which has Developper (FormReports) and JDevelopper as weel. I would like to know what is the relative relation of the prices of those three parts. Does anyone has an older PO with Developper and Designer, where could be seen what was the relative price of the two. As far as I know JDevelopper was always sold bundled. Thanks. Djordje -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: djordjej 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: Eric D. Pierce 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). _ Chat with your friends as soon as they come online. Get Rediff Bol at http://bol.rediff.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cyril Thankappan 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).
distributed_lock_timeout
Hello I need help on this. We have a Oracle 7.3.4 database and Oracle 8.1.6 database The application is as follows package in Oracle 8.1.6 calls package in Oracle 7.3.4 using Database link Package in Oracle 7.3.4 does a lot of processing but now sometimes Oracle 7.3.4 package gives distributed lock timeout error and sometimes Oracle 8.1.6 packages gives this error. This has made us wonder 'what is happeneing'! Can someone help me with a. understaning this phenomenon b. in oracle 8.1.6 the parameter distributed_lock_timeout is obsolete and the users want to run this package is there someway of 'running' this c. Is this type of processing ie calling package executing a lot of statements called package also executing a lot of statements and the final commit being back in the calling package the 'suggested' (recommended) way? isn't there a better way of doing this? Thanks _ Chat with your friends as soon as they come online. Get Rediff Bol at http://bol.rediff.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cyril Thankappan 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: Silver vs. Gold support
Hi Is metalink available under 'bronze' support? How do u live 'with bugs' without metalink support? Thanks - Original Message -- Cale, Rick T (Richard) [EMAIL PROTECTED] wrote: To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] From:Cale, Rick T (Richard) [EMAIL PROTECTED] Date:Thu, 10 May 2001 11:35:31 -0800 Subject:RE: Silver vs. Gold support We still have Bronze support which you can no longer get but we would not even consider upgrading to Gold because their phone support is not very good at all. There are too many resources available where you can actually get a correct answer much sooner. Rick -Original Message- Sent: Thursday, May 10, 2001 2:39 PM To: Multiple recipients of list ORACLE-L Kim, I have not seen a reason to get GOLD support from Oracle. Unless you've got a boss who doubts your capabilities. Sounds like time to brush off the resume!! Dick Goulet Reply Separator Author: Kimberly Smith [EMAIL PROTECTED] Date: 5/10/2001 9:16 AM My manager is thinking of moving us up to Gold support. Does anyone out there have it and if so could you give me you general impression on having that over Silver. She says that at sites she used to work at it means having a dedicated resource on site. Their phone support for SEV1 calls is basically sucks unless you hit the day shift. Kimberly Smith Database Administrator EDS - Fujitsu/GMD Phone: (503) 669-6050 Fax: (503) 669-5705 Email : [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kimberly Smith 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: 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: Cale, Rick T (Richard) 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). _ Chat with your friends as soon as they come online. Get Rediff Bol at http://bol.rediff.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cyril Thankappan 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).
mod_plsql and PL/SQL pages
Hello! Does anyone here have ANY information on the following: with the advent of PL/SQL pages is Oracle continuing development of MOD_PLSQL or is MOD_PLSQL merely provided for backward compatibility? Can someone give me some idea on this please? Thanks _ Chat with your friends as soon as they come online. Get Rediff Bol at http://bol.rediff.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cyril Thankappan 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).
v$temp_space_header and v$temp_extent_pool
Hello, it is acknowledged that v$temp_space_header.blocks_free mean ONLY that the blocks have 'never ever been used' Can someone confirm if v$temp_extent_pool.blocks_cached is the 'real number of blocks available for sorting'? How do we confirm this? Observations v$temp_space_header.blocks_used + v$temp_space_header.blocks_free = v$tempfile.blocks However, v$temp_extent_pool.blocks_cached != v$temp_space_header.blocks_used Waiting for your responses on this -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cyril Thankappan 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).
Shell scripting
Hi I wanted to select a column from a v$ table struggled with it and finally came with a workaround as follows archived_log='$archived_log' begin_seq=`sqlplus -s /nolog EOF connect / as sysdba set head off set echo off set feedback off set verify off select max(sequence#)-1 from v$archived_log ; exit EOF` echo $begin_seq --- However, the question is how to 'directly' take the output into a shell variable? there 'shud be' a better workaround than this ! Thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cyril Thankappan 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: Shell scripting
Sure
THanks Omar
But I was looking for a
'non-file based' solution :)
Thanks anyway
On Mon, 07 Oct 2002 Omar Khalid wrote :
hi
well i think i did this once, you can read
the output of the SQL query into shell variables by
first redirecting the output of the SQL query to an
OS file and then reading the file and loading
the data in the file into shell variables.
/* here is sample code to redirect the output of sql query to OS
file */
#!/bin/sh
CMD_FILE=sql_input.sql
LOC_FILE=output.log
SQLCMD=connect internal ;
select * from sys.dba_users ;
echo $SQLCMD ${CMD_FILE}
svrmgrl ${CMD_FILE} ${LOC_FILE} /* redirecting the
out of
svrmgrl to OS file */
regards
'_-_'_-_'_-_'_-_'_-_'_-_'_-_'_-_'_-_'
Omar Khalid
Software Engineer
LMK Resources
Voice: 111-101-101*780
Mobile: 0333-510-4465
Web: www.lmkr.com
'_-_'_-_'_-_'_-_'_-_'_-_'_-_'_-_'_-_'
Cyril
Thankappan To: Multiple
recipients of list ORACLE-L [EMAIL PROTECTED]
cyril_thank@redif cc:
fmail.com Subject: Shell
scripting
Sent by:
[EMAIL PROTECTED]
10/04/2002 09:18
PM
Please respond to
ORACLE-L
Hi
I wanted to select a column from a v$ table
struggled with it
and finally came with a workaround as follows
archived_log='$archived_log'
begin_seq=`sqlplus -s /nolog EOF
connect / as sysdba
set head off
set echo off
set feedback off
set verify off
select max(sequence#)-1 from v$archived_log ;
exit
EOF`
echo $begin_seq
---
However, the question is how to
'directly' take the output into a shell variable?
there 'shud be' a better workaround than this !
Thanks
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Cyril Thankappan
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.com
--
Author: Omar Khalid
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.com
--
Author: Cyril Thankappan
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: raw devices
Hi! With support for different file systems apart from 'ufs' like jfs and vxfs Much of the perfomance issues have been covered. In fact apart from Oracle Parallel Server having datafiles,redo log files and controlfiles on raw devices does NOT make much sense. Particularly with 'features' like 'Oracle Managed files' not making ANY SENSE at all in raw devices! Thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cyril Thankappan 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 DBA with ERP experience needed in Maine..
Hi Listers I don't intend to start off some sort of 'flame' here... But I really would like to know 'how' important is an ERP DBA and 'how much' does he NEED to know..? I personally feel that with ERP products giving an interface to the ERP DBA..there is NOT much that an ERP DBA can do Can someone please tell 'what is the scope' of an ERP DBA's activities? Sorry if I sound negative..but I really want to know what is the career path for an ERP DBA, particularly if 'the interface' he/she is using is gone! Kindly respond.. Kindly note that I have nothing but respect for ALL humans and all professions (including the oldest one!).. but I still am struggling to understand the role of ERP DBA.. Kindly help me understand better.. If the moderator feels that this mail 'has potential' to start a flame, kindly feel free to 'filter'this mail! Thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cyril Thankappan 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 training
I personally have not attended any training class But I've seen people come back with a lot of what I learnt thro' 'hard work' from the OCP DBA class offered by Oracle. Regards -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cyril Thankappan 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: OT - File System to Disk Mapping
Hello, Oops..its alright..I was 'able to retrieve' it!!! However, if you want to 'add any details' to it..please feel free.. Thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cyril Thankappan 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: OT RE: database consistency tools ?
- 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: Mohan, Ross 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: Cyril Thankappan 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).
OORDBMS?
Hi listers Can someone please tell me 'under what circumstances' do people 'actually' use the OBJECT option of the 8+ RDBMS? Thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cyril Thankappan 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: Unix Oracle Processes
Hi I am not sure if I have understood ur problem but can u please try this 1. cd $ORACLE_HOME/dbs 2. ls -alt lk*.ora 3. if there is any file by the name lkdb_name.ora where db_name is the database name and NOT SID then try removing this file and starting up the database again. do this ONLY if this database is NOT a. standby or b. Oracle parallel sever ( init.ora does NOT have any parallel server parameters!) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cyril Thankappan 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: ACM SIGMOD-papers of interest #1
Hi! Where can I get a copy of Scaling Oracle 8i please Cyril On Tue, 27 Nov 2001 Jared Still wrote : On Monday 26 November 2001 19:15, Rachel Carmichael wrote: For those of you techheads that don't yet have a copy of 'Scaling Oracle 8i', it's full of architectural info that will help you understand this stuff. Good bedtime reading. :) gotta get you a life Jared :) Huh? What's that? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still 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: Cyril Thankappan 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: Re: ACM SIGMOD-papers of interest #1
Hi! can you please let me know the Publisher and Author's name Thanx On Wed, 28 Nov 2001 Greg Moore wrote : Where can I get a copy of Scaling Oracle 8i please It's a book. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Greg Moore 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: Cyril Thankappan 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).
OOW at 'lesser'
Hi Is there 'some way' whereby 'some goodies' (presentations/papers) presented in OOW can be made available to 'lesser mortals' in 'lesser stations'? Can 'someone' please oblige? Perhaps you could IFS!!! Thanks Cyril On Tue, 27 Nov 2001 Rachel Carmichael wrote : This is a cross post folks... so...unfortunately, Susan McClain will not be able to attend OOW, and it now seems I AM presenting (where the heck did I put that skirt?)... I will be giving her presentation for her Statspack on Monday (I think at 11) Be kind folks, I haven't even SEEN the paper or presentation yet, and I haven't really worked with statspack much. This means it will be a short presentation :) I think they call this a challenge. Rachel __ Do You Yahoo!? Yahoo! GeoCities - quick and easy web site hosting, just $8.95/month. http://geocities.yahoo.com/ps/info1 -- 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: Cyril Thankappan 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: OT : Listers met at OOW
Hi Thanks a lot for the dispatches.. On Thu, 06 Dec 2001 K Gopalakrishnan wrote : John, Here is the update from Jonathan Gennick ... http://oracle.oreilly.com/news/openworld_day3_1201.html Best Regards, K Gopalakrishnan -Original Message- Sent: Wednesday, December 05, 2001 1:45 PM To: Multiple recipients of list ORACLE-L Dear all, I had promised a few people on the list that I would send an update about Listers meeting at OOW, so here goes! A few of us got together at a Chevy's restaurant near Moscone for a chance to say hello and put a face to a name. This included Steve 'Guru' Adams (yes - *the* Steve A all the way from Downunder), Rachel 'DBA Godess' Carmichael, Gaja 'Tuning 101' Vaidyanatha, Kirti 'Tuning 101' Deshpande, Ari 'Pocket DBA' Kaplan, Steve 'now in Montana' Orr, Jeremiah '[EMAIL PROTECTED]' Wilton, Kevin 'Tap-key' Toepke, Gopala 'X$' Krishnan, Jonathan 'OReilly' Gennick, Gerardo 'local@Schwab' Molina and John 'sleepless@SanJose' Kanagaraj. We did miss Eric 'Google-gunner' Pierce though! Starting off with a first round of free drinks from Ari (c/o Expand Beyond - thanks Ari!), everyone settled in to talk and listen and order and eat, amidst swapping stories of glory and honor and sleepless nights recovering the Db as well as horror stories of layoffs and interviewing clueless candidates. Also swapped were details of X$ tables and other UNIX internal structures (who can do without those!) as well as hunting and other adventure trips. Ari showed us some cool toys (were there more than two Pocket PCs on you, Ari?) and we all 'Oohed' and 'Aahed' over them.. Steve A's birthday was celebrated in usual Chevy's style with the gift of a straw hat and special birthday-boy dessert (although he claimed that his birthday was actually today as per Australian time!). That was the signal for us to start splitting - we would have continued through the night if the restaurant didn't have to close up Cheers! John Kanagaraj Oracle Applications DBA DBSoft Inc (W): 408-970-7002 Kill your killer-commute! Listen to great commercial-free christian music 24x7 (details at www.klove.com) ** The opinions and statements above are entirely my own and not those of my employer or clients ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Kanagaraj 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: Cyril Thankappan 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).
Due apologies for DDLs
Hi With due apologies to Perl fans and shell script fans, I have failed to understand why to obtain these DDLs the import option of show=Y indexfile=ddl_script.sql is NOT used after a export with rows=N Of course, 9i OCPs will swear by dbms_metadata! where will that leave our 'perl expertise'? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cyril Thankappan 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: Due apologies for DDLs
U r right ..I still dunno 'much' about perl.. as for dbms_metadata it is a built in pl/sql package saying 'select dbms_metadata.get_ddl(object_type,object_name,schema_name) from dual; gives the entire ddl creation script. However, 'interestingly' execute dbms_metadata.get_ddl does not work as well! More interestingly metalink does not have much on it either.. I guess it works too well Thanks Cyril -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cyril Thankappan 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).
Questions
Hello Listers, I have a couple of questions. 1. Is there 'some way' (from the catalog views) to obtain the 'function' used in a function based index. PS: the only work around I have found is 'my personal favorite'.. (exp rows=N and imp show=Y indexfile=cyril.sql) my honest and sincere apologies to those who don't like it. 2. Is there 'some way' to find out 'by how much' the datafile size has 'auto-extended'! Thanks a lot Cyril -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cyril Thankappan 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: kernel Sun Solaris 8 - Listener failed to start a dedicated server p
Hi Sorry if I sound naive! But do we have to boot the server in Solaris 8 TOO (!!) in order to change the kernel? What is the procedure for changing the kernel Thanks - Original Message -- John Kanagaraj [EMAIL PROTECTED] wrote: To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] From:John Kanagaraj [EMAIL PROTECTED] Date:Wed, 23 May 2001 15:05:26 -0800 $ sar sar: can't open /var/adm/sa/sa23 No such file or directory I do see a /var/adm/sa/sa16 directory. What does this mean? Jacques, This is the file (not directory?!) that records the system activity information (in binary) via the sadc program. The file is named by day-of-the-month (it is 23rd today). You don't seem to have access to this file - not sure why since you normally should Or maybe you ran out of space in the '/var' filesystem? From your answer re the solution - i.e. reduction of SGA - it looks like a combination of values in SHM and SEM parameters did create the problem... Another issue that occurs in my mind is that some filesystem - either $ORACLE_HOME or $TNS_ADMIN or whereever sqlnet logs are kept became full.. John Kanagaraj -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Kanagaraj 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). _ Chat with your friends as soon as they come online. Get Rediff Bol at http://bol.rediff.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cyril Thankappan 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: Tivoli??
Hi! Has anybody used it? It sure promises a lot... and I guess would also be a good product to use. however, we had problems 'integrating' it with the backup device ! Thanks - Original Message -- C.S.Venkata Subramanian [EMAIL PROTECTED] wrote: To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] From:C.S.Venkata Subramanian [EMAIL PROTECTED] Date:Sun, 20 May 2001 21:15:21 -0800 Subject:Re: Tivoli?? Tivoli is a backup software supplied by IBM. -- On Fri, 18 May 2001 08:45:47 Raghu Kota wrote: Hi Friends Could you people shed some light on tool Tivoli, Like what is functionality,purpose and more. Thanks Raghu. _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raghu Kota 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). 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: 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). _ Chat with your friends as soon as they come online. Get Rediff Bol at http://bol.rediff.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cyril Thankappan 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: OT: STOP THE PRESS!!
Hi.. This may sound like a 'sick' question. But are we all 'safe' .. I mean are all our listers 'back' in safe health? Regards -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cyril Thankappan 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: OPS instalation - pretty urgent
!! Please do not post Off Topic to this List !! Hi SOrry about this.. But I have actually seen the Net8 (shipped with Oracle 8.1.7 client CD) using Oracle 8.1.6 Enterprise Edition Database Server, where the failover works WITHOUT mts. However, Gopal, can you please clarify whether IBM insists on implementing OPS ONLY WITHIN a frame? Kindly note, my question is WHETHER we can implement OPS (Real Application Clusters) across two IBM frames. Thanks a lot -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cyril Thankappan 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: OPS: Where's the installer
The 8.1.6 and above Enterprise Edition comes with the Parallel Server Option (along with the advanced replication etc.. in the same 'page'!) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cyril Thankappan 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: OPS instalation - pretty urgent
Hi I am sorry if someone has replied this But can someone PLEASE tell me if IBM supports OPS across their SP frames. or only support OPS WITHIN SINGLE SP frame? Thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cyril Thankappan 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: HP-UX 11.0/8.1.7.1/DBV Question
Hi! sorry ..this may not be 'directly' related to your problem.. But, I am curious to know how you are 'managing' 8.1.7.1 with its bug of '566 session limit'. Cyril -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cyril Thankappan 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: Meaning of V$WAITSTAT statistics
Hello Can you please clarify the relation between 'save undo headers' and Billy Graham. If making a joke out of what is 'unplatable' or 'inconvenient' to believe is comforting you by all means go ahead. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cyril Thankappan 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: dbv Output - Pages Failing (Data)
Hello, I believe you are using the dbv on Solaris 8 on the datafile of Solaris 6 My experience has been that dbv acts 'very funny' in these type of scenarios in fact what you are encountering is 'expected behaviour' However, don't be surprised if dbv runs 'successfully' for ALL datafiles except system ,rollback and temp tablespaces' datafiles Thanks Cyril On Fri, 16 Nov 2001 VIVEK_SHARMA wrote : The Problem Occured upon Extracting on Solaris 2.8 the Cold Backup of a Database existing in Solaris 2.6 for Oracle ver 7.3.4.5 $ uname -a SunOS SF2A 5.8 Generic_108528-10 sun4u sparc SUNW, Sun-Fire Qs. Are there Any O.S./Oracle Patches which Should be Applied when Doing Such an Extract ? - Running dbv Utility for SOME of the Datafiles Giving the Following Error :- $ dbv file=/mis/data3/ACCT_MASTER_bby01_13.dbf blocksize=8192 DBVERIFY: Release 7.3.4.5.0 - Production on Thu Nov 15 13:46:03 2001 Copyright (c) Oracle Corporation 1979, 1996. All rights reserved. DBVERIFY - Verification starting : FILE = /mis/data3/ACCT_MASTER_bby01_13.dbf kdbchk: row locked by non-existent transaction table=0 slot=20 lockid=56 ktbbhitc=5 Page 55366 failed with check code 1 kdbchk: row locked by non-existent transaction table=0 slot=68 lockid=56 ktbbhitc=1 Page 104550 failed with check code 1 DBVERIFY - Verification complete Total Pages Examined : 115200 Total Pages Processed (Data) : 114430 Total Pages Failing (Data) : 2 Total Pages Processed (Index): 0 Total Pages Failing (Index): 0 Total Pages Empty: 769 Total Pages Marked Corrupt : 0 Total Pages Influx : 0 $ Qs. What can be Done About the Total Pages Failing (Data) : 2 Pages ? -- 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: Cyril Thankappan 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: Upgrade from 7.3.4 to 8.0.6
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: Cyril Thankappan 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: RE: Upgrade from 7.3.4 to 8.0.6
://www.orafaq.net -- Author: Hemant K Chitale 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). Hemant K Chitale http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hemant K Chitale 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: Cyril Thankappan 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: Cyril Thankappan 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).
7.3.4 upgrade
Hi Listers, I've prepared a small list of steps to follow for an upgrade of 7.3.4 database to 9.2 However unfortunately I do not have access to a 7.3.4 database Can one of you who has access to 7.3.4 database, try these steps out and give me your 'honest' feedback? Thanks a lot Cyril encoded content removed -- binaries not allowed by ListGuru
Ot: Budding dba
Hello, are there any list of 5-10 questions which we can 'generally' ask to judge the 'potential' of a person to be an Oracle dba. These questions may include questions on attitude also. Cyril PS: I am seriously looking at hiring some 6months to 1 year experienced Oracle apps dba. So if someone knows anyone (!!!) please forward their cvs to [EMAIL PROTECTED] The positions are based in Bangalore, and of course I won't ask them the same 5-10 questions (!!) __ Great Travel Deals, Airfares, Hotels on http://r.rediff.com/r?www.journeymart.com/rediff/travel.aspsignjmart -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Cyril Thankappan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Ot: Budding dba
Hello, are there any list of 5-10 questions which we can 'generally' ask to judge the 'potential' of a person to be an Oracle dba. These questions may include questions on attitude also. Cyril PS: I am seriously looking at hiring some 6months to 1 year experienced Oracle apps dba for my organisation. So if someone knows anyone (!!!) please forward their cvs to [EMAIL PROTECTED] The positions are based in Bangalore, and of course I won't ask them the same 5-10 questions (!!) __ Great Travel Deals, Airfares, Hotels on http://r.rediff.com/r?www.journeymart.com/rediff/travel.aspsignjmart -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Cyril Thankappan 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: thanks all/OCP
Hi, I am sorry if I sounded discouraging. That wasnt the idea. anyway if the idea or point was missed I guess it is not anyway worth labouring on it :) Best Regards Cyril On Wed, 28 May 2003 Joan Hsieh wrote : Cyril, we need some encouragements on those who has the experiences and also has ocp. As Rafig said, if I don't continue updated my ocp, I just know something I have done, limited to my experiences. With ocp, I know WHAT, then I know HOW Joan M Rafiq wrote: Cyril, One positive point... It force you to study all upgrade material and read through different aspect of oracle which we normally not read that thoroughly. It always helped me to do ocp upgrade exam to read more of new features else I was not reading it. however, it is not a replacement of my experience of 15 years with oracle(since ver 4 DOS and ver 5(unix) Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Sun, 25 May 2003 19:16:19 -0800 Hello, I do hope the ocp 'looks well' on ur resume! and 'goes down well' with interviewers ! I personally think OCP has lost credibility for the following reasons a. People are known to get through using the 'jack pot method' (ie close ur eyes and pray and click the option!) b. People are known to sms the answers!!! c. Finally everyone in the industry seems to know that if not the 1st attempt atleast by the 3rd attempt people 'have to get through' Stuff like the above have made interviewers all over wary of OCP candidates who mouth a lot of jargon without the necessary experience. This creates a unique problem where a candidate is likely to have a 'false sense of confidence' just because he 'read something somewhere' and this makes it difficult for the interviewer to 'imagine the candidate in his team working on workarounds ;)' and difficult for the candidate to 'learn' So the interviewer is likely to take the 'safe option' of hiring a guy who has 'genuinely worked 10%' at 10% pay rather than hire a guy who has 'genuinely worked 10%' done OCP (10i!hahaha) and expects to be paid 100% and has airs :( All the best Cyril PS: By the way Oracle claims that OCPs get paid more... I have not seen such a thing...if 'someone around here' has 'seen such a thing' wellgood...:) IMHO OCP is one good money making idea Oracle Education developed...why didnt I think of it earlier :( On Mon, 26 May 2003 DENNIS WILLIAMS wrote : Congratulations! Well, was it as hard as you thought it was going to be? Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, May 23, 2003 5:37 PM To: Multiple recipients of list ORACLE-L Hello list thanks to you all and with the almighty's blessings i passed my 1ZO-031 9i dba fundamentals 1 today. Thanks for all the help and advice ... -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- 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). ___ Impress your clients! Send mail from me @ mycompany.com . Just Rs.1499/year. Click http://www.rediffmailpro.com to know more. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Cyril Thankappan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting
Re: RE: Oracle 11i new features
Better still!! Maybe they will call everything (database/iAS/JDeveloper/IDS) 11i :) Cyril On Sat, 31 May 2003 John Kanagaraj wrote : Nope! - Oracle 10i will be the end of the world (as Oracle knows it at least :) since we already have an Oracle 11i (aka Oracle Applications 11i - but generally known in the ERP world as Oracle 11i or Apps 11i). Fyi - it mutated from Apps 10.7 to Apps 11.0.x and now to Apps 11.5.x - the 'i' replacing the 5 here. So when 11.5.9 is released later this year and they run out of numbers there, I believe it will mutate to Oracle 12i or Apps 12i The life of the person who is in charge of numbering at Oracle is gonna become quite complicated for sure. John Kanagaraj Oracle Applications DBA DB Soft Inc Work : (408) 970 7002 Listen to great, commercial-free christian music 24x7x365 at http://www.klove.com http://www.klove.com/ ** The opinions and facts contained in this message are entirely mine and do not reflect those of my employer or customers ** -Original Message- Sent: Friday, May 30, 2003 9:20 PM To: Multiple recipients of list ORACLE-L UNLESS Oracle decides to skip Oracle 10i and go directly to Oracle 11i. They did something similar to bring the numbers for Oracle Database and Oracle Designer and Oracle Application Servers all up to 9i (9iDB, 9iAS, Designer 9i. . . .) After all, they must have introduced enough new features and bugs to skip a number or two?!?! - Babette -Original Message- Sent: Wednesday, May 28, 2003 8:05 AM To: Multiple recipients of list ORACLE-L Oracle 11/11i: http://www.vapourware.com http://www.vapourware.com Oracle Apps 11/11i http://www.oracle.com/appsnet/content.html http://www.oracle.com/appsnet/content.html http://www.oaug.org/ http://www.oaug.org/ http://www.appsdba.com http://www.appsdba.com HTH Mark -Original Message- Sent: 28 May 2003 11:08 To: Multiple recipients of list ORACLE-L Hi Can anybody tell me a website where I can know about new features in Oracle 11/11i? Thanks in Advance Ajay K. Garg -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: John Kanagaraj 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). ___ Impress your clients! Send mail from me @ mycompany.com . Just Rs.1499/year. Click http://www.rediffmailpro.com to know more. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Cyril Thankappan 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: J2EE for the DBA
Hi Thanks a lot. I myself have been for too long an 'upgrade /backup recovery' type of dba and have been 'struggling' to figure the java thing. will read this one :) Thanks Cyril On Tue, 03 Jun 2003 DENNIS WILLIAMS wrote : I just ran into this article, and it seems pretty good, aside from being oriented toward Oracle9iAS and Oracle9iAS TopLink. If you support Java, take a look at it. If anyone has found any issues with the statements it makes, I would be interested in hearing them. http://otn.oracle.com/oramag/oracle/03-may/o33j2ee.html Not long ago my Java developers wanted a primary key on each table. I posted to this list and received very helpful replies. This article explains why J2EE needs that. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -- 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). ___ Impress your clients! Send mail from me @ mycompany.com . Just Rs.1499/year. Click http://www.rediffmailpro.com to know more. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Cyril Thankappan 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).
