Prices of the Oracle internet Developer Suite components
Listers, 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).
Instance allocated more memory to the shared pool than set by the parameters
Hi, Instance has allocated more memory to the shared pool(~ 20M) than set by parameters (13M). Any ideas why? : SYSTEM@PROD select name, value from v$parameter where name like 'shared_pool%'; Object Name VALUE -- shared_pool_size 1300 shared_pool_reserved_size 100 shared_pool_reserved_min_alloc 4K SYSTEM@PROD select sum(bytes) from v$sgastat where pool='shared pool'; SUM(BYTES) -- 20689724 SYSTEM@PROD select * from v$sga; NAME VALUE - Fixed Size 47304 Variable Size 20709376 Database Buffers 5120 Redo Buffers 1064960 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).
Re: v$buffer_pool_statistics
emoved 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: 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).
Re: changing db_block_size
To change the block size you have to recreate the database. How you are going to copy the data that's another issue. You can use full database export/import (pretty long downtime, or problems with data consistency) or you can do a live copy. More on a live copy you can see in: Venkat S. Devraj, Oracle 24x7 Tips Techniques, Osborne Press, 2000. I am currently working on a similar project (live database migration). I will present some results at IOUG if you are there. Djordje - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, March 27, 2001 6:40 PM all, I would like to change the db_block_size (currently 2048) of our production database and would be interested in hearing from those that have done this on a not so small database. This is our oracle financials/manufacturing server and is about 30GB in size. Did you recreate the database using imp/exp or another method? Running Oracle 8.0.5 on Sun Solaris 7. thanks in advance...roy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Roy Ferguson 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: 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).
Execute priv to an isolated procedure inside a package
Hi friends, One cannot grant execute privilege to a specific procedure/function inside a package, but only for all or nothing that is in that package. Anybody has an idea how this limitation can be overcomed. One idea is to create a separate stand-alone procedure that will just be a wrapper around the packaged procedure and call it. Any other ideas. 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).
Re: URGENT Oracle ERROR!!!
Here is the document from Metalink regading this error: HTH. Djordje * Doc ID: Note:49946.1 Subject: OERR: ORA 27072 skgfdisp: I/O error Type: REFERENCE Status: PUBLISHED Content Type: TEXT/PLAIN Creation Date: 21-NOV-1997 Last Revision Date: 08-JUN-1999 Language: USAENG Error: ORA-27072 Text: skgfdisp: I/O error --- Cause: read/write/readv/writev system call returned error, additional information indicates starting block number of I/O Action: check errno *** Important: The notes below are for experienced users - See [NOTE:22080.1] Explanation: This error was introduced in Oracle8. The error is raised in port specific code so the exact system calls preceeding the error can vary between platforms. The error indicates that a read or write call either: a) returned an error or b) returned a value indicating that the number of bytes read/written does not match the number of bytes we asked to read/write Hence the error number reported may or may not be meaningful. If the read/write returned an error then the ERRNO reported corresponds to the actual read/write call used. If the read/write returned a different number of bytes to that expected then ERRNO is just the left over error from some previous system call and should be ignored. Additional information is the first BLOCK NUMBER being read/written in the named file. Diagnosis: 1. 2Gb limits (or other limits) can cause this sort of error so check if the filename reported in the corresponding error is a large file. The block number in the additional information can help show if you are close to this limit. 2. It is helpful to know the system call which caused the error so exact version information is important. If the error is repeatable at will then TRUSS or similar may help identify the call raising the error. 3. Determine if the file/s are on raw devices / logical raw volumes or file system files. References / Known Bugs etc.. ~ There are several known issues that can cause this error, plus it can be a non-Oracle problem so it is important to collect all the information: 2Gb or not 2Gb - file limits in Oracle [NOTE:62427.1] See the above article as an anchor point for 2Gb issues on various platforms. Eg: Solaris 2Gb issue [BUG:774252] Backup of RAW controlfile[NOTE:60953.1] Sequent AIO issue[NOTE:64632.1] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, March 19, 2001 3:05 AM Hello All, J ust now i got a error select count(*) from s_org_ext. SQLWKS select count(*) from s_org_ext; where S_org_ext is Name of the Table. COUNT(*) -- ORA-01115: ORA-01110: 4: /db/oracle/oradata/tlisuser/data03.dbf ORA-27072: skgfdisp: SVR4 Error: 25: Inappropriate ioctl for device Additional information: 262132 But When I do select x,y,z,t,. from s_org_ext then No error occured. The size of that Table is 2.4GB. Its Initial extent is 1Gb and Next is 1mb. Vesion of Orcale 8.0.5 and OS is Sun solaris 5.6 Developped got this error while executing a procedure. I think that procedurte will be insert into data into s_org_ext. PLease tell me what i will do. I think datafile will be damagaed. can not coiped on OS prompt when last time I took backup. Please help me., Regards, Saroj. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dash, Saroj (CAP,CEF) 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: djordjej INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists
Re: Re:Alert Log
Dick, Seems you haven't called OTS recently. They come up nowadays with a lot of "interesting" ideas. Djordje - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, February 06, 2001 5:43 PM How did OTS come up with the idea that your using Pro*C? This part of the alert log tells me that there is a problem with a parallel query process namely either p000 or p001. My first stem would be to look in the trace file(s) specified and see what SQL statements are being processed. There may be a corrupt block running around somewhere. Also did you send these files to OTS when you created the tar? They exist primarily for OTS's purposes. Dick Goulet Reply Separator Author: Shakeel Qureshi [EMAIL PROTECTED] Date: 2/6/2001 11:00 AM Hi gurus! I am receiving the following bug in my Alert Log. Oracle says it may be because of using PRO*C which we are not using all. Please review the contents and if someone has any idea about it, the input will be appreciated. Thu Jan 25 06:56:15 2001 Errors in file /u01/app/oracle/admin/BPNEXT/bdump/bpnext_p001_10057.trc: ORA-00600: internal error code, arguments: [KGHALO2], [0], [], [], [], [], [], [] Thu Jan 25 06:56:15 2001 Errors in file /u01/app/oracle/admin/BPNEXT/bdump/bpnext_p000_10055.trc: ORA-00600: internal error code, arguments: [KGHALO2], [0], [], [], [], [], [], [] Thu Jan 25 06:56:37 2001 Errors in file /u01/app/oracle/admin/BPNEXT/bdump/bpnext_p000_10055.trc: ORA-00600: internal error code, arguments: [KGHALO2], [0], [], [], [], [], [], [] Thu Jan 25 06:56:37 2001 Errors in file /u01/app/oracle/admin/BPNEXT/bdump/bpnext_p001_10057.trc: ORA-00600: internal error code, arguments: [KGHALO2], [0], [], [], [], [], [], [] Thu Jan 25 10:05:05 2001 Errors in file /u01/app/oracle/admin/BPNEXT/bdump/bpnext_p000_10351.trc: ORA-00600: internal error code, arguments: [KGHALO2], [0], [], [], [], [], [], [] Thu Jan 25 10:05:05 2001 Errors in file /u01/app/oracle/admin/BPNEXT/bdump/bpnext_p001_10353.trc: ORA-00600: internal error code, arguments: [KGHALO2], [0], [], [], [], [], [], [] Thu Jan 25 10:06:39 2001 Errors in file /u01/app/oracle/admin/BPNEXT/bdump/bpnext_p000_10351.trc: ORA-00600: internal error code, arguments: [KGHALO2], [0], [], [], [], [], [], [] Thu Jan 25 10:06:39 2001 Errors in file /u01/app/oracle/admin/BPNEXT/bdump/bpnext_p001_10353.trc: ORA-00600: internal error code, arguments: [KGHALO2], [0], [], [], [], [], [], [] Thu Jan 25 10:06:59 2001 Errors in file /u01/app/oracle/admin/BPNEXT/bdump/bpnext_p000_10351.trc: ORA-00600: internal error code, arguments: [KGHALO2], [0], [], [], [], [], [], [] Thu Jan 25 10:06:59 2001 Errors in file /u01/app/oracle/admin/BPNEXT/bdump/bpnext_p001_10353.trc: ORA-00600: internal error code, arguments: [KGHALO2], [0], [], [], [], [], [], [] Fri Jan 26 04:43:13 2001 alter database backup controlfile to trace Fri Jan 26 04:43:13 2001 __ Do You Yahoo!? Yahoo! Auctions - Buy the things you want at great prices. http://auctions.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shakeel Qureshi 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: 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, incl
Re: ora 704 --- URGENT!!!!!
Try to see whether the ROLLBACK_SEGMENTS list in the database init.ora file contains the name of a rollback segment that does not exist. HTH Djordje - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, February 06, 2001 4:22 PM hi, os : hp ux 10.2 RDBMS : oracle 7.3.4 ora 600[4146] if i apply logs and after that am getting media recovery complete. But if i try to open the db, i am getting the following errors. ora 704 - bootstrap failure. Please help tia venki __ Do You Yahoo!? Yahoo! Auctions - Buy the things you want at great prices. http://auctions.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Srinivasan Venkat Raman 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: 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).
Re: ora 704 --- URGENT!!!!!
If you have support you should probably call them. This is what I found on Metalink as well: Explanation: This is a general error reported at startup when there is some problem during processing of bootstrap information. There should be an accompanying error/s. Diagnosis: - See the accompanying error/s for more information. - Shutdown abort the instance and clean up any OS structures used by the instance. Eg: Ensure there is no shared memory, semaphores etc.. left lying around - Retry the startup. - If the error persists follow up on the accompanying errors (Eg: block corruption etc.. could cause this.) - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, February 06, 2001 4:22 PM hi, os : hp ux 10.2 RDBMS : oracle 7.3.4 ora 600[4146] if i apply logs and after that am getting media recovery complete. But if i try to open the db, i am getting the following errors. ora 704 - bootstrap failure. Please help tia venki __ Do You Yahoo!? Yahoo! Auctions - Buy the things you want at great prices. http://auctions.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Srinivasan Venkat Raman 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: 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).
Re: steve adams' site
http://www.ixora.com.au/home.htm Oracle8i Internal Services, O'Reilly - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, February 07, 2001 8:35 PM Hello, Can any one tell me steve adams web site and also his book name? rgds, raja Get your small business started at Lycos Small Business at http://www.lycos.com/business/mail.html -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Viraj Luthra INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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).
Re: Patchset installation
When I am installing the patchset I am giving oracle the new home. For example: 1. My home is /u01/app/oracle/product/8.0.4 2. I copy all the tree under the home to the new home: /u01/app/oracle/product/8.0.4.4 3. For the patch installation session I set: ORACLE_HOME=/u01/app/oracle/product/8.0.4.4, and install the patch, relink, ... . All the linked libreries are with respect to the new home. In the meantime the running instance has no idea of the new home, but uses /u01/app/oracle/product/8.0.4. 4. When I am done with 3, I shutdown the instance change ORACLE_HOME==/u01/app/oracle/product/8.0.4.4 and start the instance. This is very similar to installing a new database version distribution parallel to the existing one, which is a standard procedure, and one of the features of the OFA standard. Djordje - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, February 05, 2001 8:05 PM Not a good idea. Oracle links some libs in with a direcory that is in Oracle Home. - Original Message - To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED] Sent: Monday, February 05, 2001 3:42 PM Hi, I am looking into installing a patchset with minimum downtime. Standard Oracle procedure for installing a patchset is: 1. Shutdown the database 2. Install the patch binaries, relink. 3. Startup database (restrict ?), run the cat* scripts. I wanted to change the procedure so that instead of having the database down during the patch install and relinking, prior to the procedure I copy the binaries to a newly created home, install the patch on the new home, relink the binaries under the new home, and than just restart the database from the new home. To make sure that everything is OK, I would postpone the cat* scripts run, for a later time, once I am sure that everything is OK. If something goes wrong I haven't changed anything in the database, and I can just go back to the old home. Has anybody tried this ? What is the significance of cat* scripts. As far as I understand them, oracle does not use them and do not care about them, only some apps might break (most of all DBA type of scripts). Thanks. Djordje -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Djordje Jankovic 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: Allan Nelson 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: 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).