O R A C L E 9i References
Hello everyone, We are looking for high availabilty database solution for a product which is under initial development. We have suggested Oracle RAC as the database option. Can we go for IBM DB2 ESE as another database option ? Can anybody give good references of organisations having production databases running in Oracle9i RAC ? Informations on the same would be truely appreciated. Thanks & Regards, Pradeep -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pradeep Kumar G 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).
killing Oracle user sessions after a specified idle time
Dear All, There is requirement in our project that all idle sessions needs to be killed after the specified time interval. I tried modifying the SQLNET.ORA in the database server by having the parameter sqlnet.expire_time = 20. Still it doesn't seem to be working. Can I use the logon_time from v$session and explicity kill the session ? Is there any other work around? Regards, Pradeep -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pradeep Kumar G 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).
Column level security
Dear All, Is there any way to implement column level security in Oracle 9i database ? Information on having row level security through VPD is available. But is it possible to have column level security ? I have seen in some sites,like (http://www.ftt.co.uk/C520_outline.html, http://www.actisit.com/outlines/forms/Or202_Or9i%20DBA%20I%20outline.pdf) mentioned about column level security. Can someone help me in this regard? Pradeep -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pradeep Kumar G 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: SQL Loader
When I queried the table to which SQL Loader loaded data from the .dat file, the first record in the table was the 5th record and 4,49998... Kirtikumar Deshpande yahoo.com>cc: Sent by: Subject: Re: SQL Loader [EMAIL PROTECTED] 06/02/03 11:02 PM Please respond to ORACLE-L I think the query is displaying data from the table in the order in which rows were inserted by SQL*Loader. Whereas, the query to read the same data from the external table is reading the file from the first physical record. So it appears reversed.. - Kirti Stephen Andert <[EMAIL PROTECTED]> wrote: Pradeep, I don't know what you mean when you say SQL*Loader is "starting from the 50,000th record and going up". If there are 50k records, are you saying it is not loading them? Or is it reading them from 50,000 then 49,999 (i.e. in revers order)? How are you determining what order they are being read? Regarding external tables, the way they work is by reading the file from the first block to either the end or till it finds what it needs. Thus, external tables will read in the order the records are in the file. I stand ready for my ramblings to be corrected by anyone who can explain better :) Stephen >>> [EMAIL PROTECTED] 06/01/03 10:35PM >>> Dear All, I don't know whether SQL Loader behaves like this always or for me only. I am loading a .dat file which has 5 records. I noticed that S! QL loader is starting from the 50,000th record and going upwards, while external tables is starting from the 1st record and going downwards. Could somebody help me confirming this? Regards, Pradeep Do you Yahoo!? Free online calendar with sync to Outlook(TM). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pradeep Kumar G 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).
SQL Loader
Dear All, I don't know whether SQL Loader behaves like this always or for me only. I am loading a .dat file which has 5 records. I noticed that SQL loader is starting from the 50,000th record and going upwards, while external tables is starting from the 1st record and going downwards. Could somebody help me confirming this? Regards, Pradeep -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pradeep Kumar G 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).
help
Hi, I have loaded a class to the database using loadjava. I have written a server which listens to a particular port(say 3000). The client class loaded to the database gathers infromation from the database and sends it to the server which needs to accept at port 3000. Database is showing some information that grant needs to be given. I have loogedin Sys and given the grant also. Still not working. SQL> exec SPR_DATETEST; the Permission (java.net.SocketPermission 129.168.9.128:3000 connect,resolve) has not been granted to PRADEEP. The PL/SQL to grant this is dbms_java.grant_permission( 'PRADEEP', 'SYS:java.net.SocketPermission', '129.168.9.128:3000', 'connect,resolve' ) PL/SQL procedure successfully completed. What will be problem. Can somebody help me ? When I tested the class outside the database, it is working fine. Regards, Pradeep -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Calculate the disk capacity
Hi All, Is there any way to find out the total disk capacity available, from the PL/SQL program ? Regards, Pradeep -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
HELP
HELP -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
UTL_HTTPS in Oracle 8.1.7
Hi, How can I use utl_http.request for https pages with Oracle 8.1.7. ? Presently we are using utl_http for calling up the application server's service from an oracle procedure, the default lookup to the server is using http. Now we want to change the lookup using SSL to https. Please advise on how to implement the same. Thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
utl_http.request
Hi All, How can I use utl_http.request for https pages with Oracle 8.1.7 ? Any ideas !! It is very urgent. Thanks & Regards, Pradeep -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pradeep Kumar Gopalakrishnan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
DCMCTL Utility
Hi, Oracle 9iAS Enterprise Manager(EM) tool will return details like Cluster Name/Instance name and the Corresponding Port number along with the oracle 9ias Home directory name. The above mentioned (OEM) is a GUI tool. What My problem is i want to grep all the details (which Oracle 9iAS Enterprise Manager(OEM) returns) from the Command Prompt. 9iAS provides a tool named Distributed Configuration Management(DCMCTL) which comes under oracle 9ias/dcm/bin/dcmctl.bat. Using the various options of DCMCTL,it will return the certain parameters which i want.But its not returning the port number of the instances and the home directory name. My Question is, Is it possible to grep the Details Which i Want(Oracle 9iAS Instance Name,Corresponding Port Number and the Home directory) using the DCMCTL tool or oracle provides any other tool to meet the above mentioned problem. Remember all these details are available if I am Using the GUI tool,Oracle 9iAS Enterprise Manager(OEM).I want all these from the Command Prompt. Regards, Pradeep -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle 9.2 installation on Pentium 4, Windows 2000 machine
I just renamed the file and installation didn't start. So i downloaded a new version and copied to the concerned folder and installed it. no change. "Thomas Day" <[EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> m> cc: Sent by: Subject: RE: Oracle 9.2 installation on Pentium 4, Windows 2000 root@fatcity.machine com 01/31/03 09:44 PM Please respond to ORACLE-L I thought that this problem was fixed with Oracle 9. Did you just rename the symcjit.dll file or did you also then copy over a good version? "Naveen Nahata" @mindtree.com> cc: Sent by: rootSubject: RE: Oracle 9.2 installation on Pentium 4, Windows 2000 machine 01/31/2003 07:43 AM Please respond to ORACLE-L Don't start it from install/setup.exe in the disk1 directory... go to install/win32 and use install/setup.exe there -Original Message- Sent: Friday, January 31, 2003 12:39 PM To: Multiple recipients of list ORACLE-L Hi, I had run the Oracle 9.2 installation on Pentium 4, Windows 2000 machine, after renaming the symcjit.dll file. Still the installation is not starting. Can someone help me in this? Regards, Pradeep Disclaimer: "The information in this e-mail is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. It should not be used by anyone who is not the original intended recipient. If you have erroneously received this message, please delete it immediately and notify the sender. The recipient acknowledges that IBS or IBS Group like any other large global corporation, are unable to exercise total control or ensure or guarantee the integrity of contents of the information contained in individual e-mail transmissions and the recipient acknowledges that any views expressed in this message may be those of the individual sender and no binding nature of the message shall be implied or assumed unless the sender does so expressly with due authority of IBS Group. Before opening any attachments please check them for viruses and defects." -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). DISCLAIMER: This message (including attachment if any) is confidential and may be privileged. Before opening attachments please check them for viruses and defects. MindTree Consulting Private Limited (MindTree) will not be responsible for any viruses or defects or any forwarded attachments emanating either from within MindTree or outside. If you have re
RE: Oracle 9.2 installation on Pentium 4, Windows 2000 machine
I didn't apply any service packs to W2K. Let me see with applying the SP3 also. "Jesse, Rich" world.com> cc: Sent by: Subject: RE: Oracle 9.2 installation on Pentium 4, Windows 2000 [EMAIL PROTECTED]machine m 01/31/03 10:09 PM Please respond to ORACLE-L Have you applied any Winders Service Packs? I just installed 9.2.0.1.0 on a 2.4Ghz Intel running 2K with SP3 without a hitch. No renaming of .dlls and I used the default "disk1/setup.exe" to install. The only issues I had were some sqlnet.ora parameter problems and the Oracle Names service setup, but completely unrelated to the installation. Perhaps the fix for this is in the Service Packs? Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- Sent: Friday, January 31, 2003 6:44 AM To: Multiple recipients of list ORACLE-L Don't start it from install/setup.exe in the disk1 directory... go to install/win32 and use install/setup.exe there -Original Message- Sent: Friday, January 31, 2003 12:39 PM To: Multiple recipients of list ORACLE-L Hi, I had run the Oracle 9.2 installation on Pentium 4, Windows 2000 machine, after renaming the symcjit.dll file. Still the installation is not starting. Can someone help me in this? Regards, Pradeep -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich 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: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Oracle 9.2 installation on Pentium 4, Windows 2000 machine
Hi, I had run the Oracle 9.2 installation on Pentium 4, Windows 2000 machine, after renaming the symcjit.dll file. Still the installation is not starting. Can someone help me in this? Regards, Pradeep Disclaimer: "The information in this e-mail is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. It should not be used by anyone who is not the original intended recipient. If you have erroneously received this message, please delete it immediately and notify the sender. The recipient acknowledges that IBS or IBS Group like any other large global corporation, are unable to exercise total control or ensure or guarantee the integrity of contents of the information contained in individual e-mail transmissions and the recipient acknowledges that any views expressed in this message may be those of the individual sender and no binding nature of the message shall be implied or assumed unless the sender does so expressly with due authority of IBS Group. Before opening any attachments please check them for viruses and defects." -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Help on DBMS_PROFILER required
Hi, Please ask the DBA to check whether the self checking by dbms_profiler was completed. The package upon completion should give "SYS.DBMS_PROFILER successfully loaded." Also please grant execute privilege on DBMS_PROFILER to the user . Pradeep "Satya V Prakash" fmail.com> cc: Sent by: Subject: Help on DBMS_PROFILER required [EMAIL PROTECTED] 01/23/03 05:29 PM Please respond to ORACLE-L Hi, I need to use the DBMS_PROFILER package for PL/SQL in between the procedures. I used the corresponding script located in Oracle_home\rdbms\admin\PROFLOAD.sql . I ran this script, it ran without any problems. But I am still unable to invoke the DBMS_PROFILER package, The error is Identifier DBMS_PROFILER.START_PROFILER must be declared ORA-06550 PLS-00201 Any help in this regard would be highly appreciated. Thanks and Regards, Satya Prakash -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Satya V Prakash 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: 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).
Physical reads
Hi All in list, I have taken the report.txt using utlbstat and utlestat. Can I assume that the physical reads value as number of physical I/Os to the disk happened? Regards, Pradeep -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
SET ORACLE-L NOMAIL
SET ORACLE-L NOMAIL Disclaimer: "The information in this e-mail is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. It should not be used by anyone who is not the original intended recipient. If you have erroneously received this message, please delete it immediately and notify the sender. The recipient acknowledges that IBS or IBS Group like any other large global corporation, are unable to exercise total control or ensure or guarantee the integrity of contents of the information contained in individual e-mail transmissions and the recipient acknowledges that any views expressed in this message may be those of the individual sender and no binding nature of the message shall be implied or assumed unless the sender does so expressly with due authority of IBS Group. Before opening any attachments please check them for viruses and defects." -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Defragmentation of tablespace
Dear Friends, Does anybody help me to defrag / reorganise the user tablespaces which is large in size. Is there any script for that ? If available can somebody send it to me ? Regards, Pradeep Disclaimer: "The information in this e-mail is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. It should not be used by anyone who is not the original intended recipient. If you have erroneously received this message, please delete it immediately and notify the sender. The recipient acknowledges that IBS or IBS Group like any other large global corporation, are unable to exercise total control or ensure or guarantee the integrity of contents of the information contained in individual e-mail transmissions and the recipient acknowledges that any views expressed in this message may be those of the individual sender and no binding nature of the message shall be implied or assumed unless the sender does so expressly with due authority of IBS Group. Before opening any attachments please check them for viruses and defects." -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Efficiency testing
Hi, Could somebody tell me what all to be considered for testing the efficiency of an Oracle database application ? Thanks and Regards Pradeep -- 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).
