RE: Multimaster replication as alternative backup
Simple,Clear and Superb explanation. Thanks Arup. -Original Message- Nanda Sent: Wednesday, November 19, 2003 1:10 AM To: Multiple recipients of list ORACLE-L VirVit, You haven't specified Oracle version and your tolerance for data loss. If you can afford to lose the data in the most current redo log file, then I would suggest 9i Data Guard in maximum performance mode (or Standby in 8i) solution over the MM replication. The DG solution does not affect the primary database performance. You can backup the standby database and use it for recovery of the primary, too. If you can't afford to lose any data, then you can still use the DG Maximum Protection (in 9i) mode, but it will affect the performance to some extent. However, in this case (no data loss) you have to enable MM Synchronous Replication as opposed to the default Asynchronous mode. In the Synch mode, the performance is worse compared to the Max Protection DG solution. Here is a summary of the options: Oracle 8i | +- Last redo data loss ok = Standby Database ~~ Performance=BEST +- LAst redo data los NOT ok = MM Synchronous Replication ~~ Performance=VERY BAD Oracle 9i | +- Last redo data loss ok = Data Guard Max Performance Mode ~~ Performance=BEST +- LAst redo data los NOT ok = | +- Option 1: MM Synchronous Replication ~~ Performance=VERY BAD +- Option 2: Data Guard Max Protection Mode ~~ Performance=BAD Therefore, you are better off using DG (or standby in 8i). Pros: (1) You can use standby datafiles to recover primary database (2) You can take RMAN backups from the standby, reducing the CPU cycle requirements in primary Cons: (1) In Max Protection Mode, the primary also halts if the standby has a problem; not truly a HA solution. Ideally you need three or more servers - one primary and two standbys to work perfectly = high cost Summary: If your management can live with the loss of the last redo, your best option is DG Max Performance (or Standby, in 8i), IMHO. HTH. Arup Nanda www.proligence.com - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, November 18, 2003 11:54 PM Hello! What do you think of additional backup method as multimaster replication? Isn't it a way to continue working normal, if main database crash and I move all connections to another master site? -- Oracle 9i DBA beginner -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: VirVit 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: Arup Nanda 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: Sami 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: Who are certified Oracle Masters?
Honi soit qui mal y pense At 04:34 PM 12/13/2003, you wrote: This is a family oriented mailing list folks. :) Jared On Fri, 2003-12-12 at 15:19, Richard Foote wrote: Hi Jeremiah, I find the mental image of the six of you holding up your shafts for a publicity shot profoundly disturbing... Wolfgang Breitling Oracle7, 8, 8i, 9i OCP DBA Centrex Consulting Corporation http://www.centrexcc.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Wolfgang Breitling 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: Fedora (pink hat)
I agree. I installed Fedora from scratch and Oracle 9.2.0.4 as promised. It took the same time as RH9, just under 3 hours. I definately used puschitz.com tips and Fedora required the rhel3_pre_install patch to get the installer working. Some tips about Fedora: 1) I was unable to run Fedora under 2.5.1 VMWare server. 2) The iso download resulted in corrupted CDROM burns many times, appx 10 coasters. 1st time I had this many problems. -- Fedora1 Linux CDROM sources (fast dload) ftp://ftp.dulug.duke.edu/pub/fedora/core/linux/1/en/iso/i386/ yarrow-i386-disc1.iso yarrow-i386-disc2.iso yarrow-i386-disc3.iso Note: I got many corrupt downloads. I totally recommend you burn CDROM from these iso and check _ALL_ _THREE_ disks during the Fedora1 install. I made at least 10 coasters. 3) The Fedora firewall rules were different (better) and I updated my personal notes/instructions for lokkit: -- Firewall Configuration -- (lokkit, /etc/sysconfig/iptables, /etc/init.d/xinetd restart) Customize: Trusted Devices: [ ] eth1, [ ] eth0 Allow incoming: [ ] DHCP, [*] SSH, [ ] Telnet, [*] WWW (HTTP), [ ] Mail (SMTP), [ ] FTP Ports: 4443:tcp,:tcp,1521:tcp (Note: Trusted devices disables the firewall, so I don't do it. Fedora1 implements different firewall jumping rules that break Apache and Oracle TNS/OCI, so Fedora must use the ports shown). 4) The Fedora package list is slightly different. Here is what I started with: -- Package Group Selection (server) [*] Administration Tools(default) [*] DNS Name Server [*] Development Tools [*] Editors [*] FTP Server [*] GNOME Desktop Environment [*] KDE Desktop Environment [*] Printing Support(default) [*] SQL Database Server [*] Server Configuration Tools (default) [*] System Tools [*] Text-based Internet (default) [*] Web Server (default) [*] Windows File Server (default) [*] X Window System -- (Note: Fedora - I did not select [ ] Network Servers) -- 5) FYI: Some info on versions: -- Test LINUX install rpm -qa | grep kernel results: kernel-2.4.20-8 (RH93) kernel-2.4.22-1.2115.nptl (Fedora13) -- rpm -qa | grep release results: redhat-release-9-3 (RH93) fedora-release-1-3 (Fedora13) -- 6) Additional libraries I installed after packages above (sorry I'm mixing my RH9 and Fedora notes here): -- glibc patch rpm (RH9 RPMS directory, CD1/2) (just use the Fedora version from its CD1/2/3 whenever different from RH9) compat-gcc-7.3-2.96.118.i386.rpm compat-libgcj-7.3-2.96.118.i386.rpm compat-libgcj-devel-7.3-2.96.118.i386.rpm compat-libstdc++-7.3-2.96.118.i386.rpm compat-libstdc++-devel-7.3-2.96.118.i386.rpm libpng10-1.0.13-8.i386.rpm (1st of 2) gnome-libs-1.4.1.2.90-32.i386.rpm (2nd of 2) ncurses4-5.0-11.i386.rpm pdksh-5.2.14-21.i386.rpm nss_db-compat-2.2-20.i386.rpm perl-CGI-2.81-88.i386.rpm (1st of 2, rh9 only) indexhtml-1-2.noarch.rpm (1st of 2, fedora13 only) lynx-2.8.5-11.i386.rpm(2nd of 2) -- fedora13 (Fedora1 RPMS directory, CD1/2/3) tcl-8.3.5-93.i386.rpm compat-db-4.0.14-2.i386.rpm compat-gcc-c++-7.3-2.96.118.i386.rpm openmotif21-2.1.30-8.i386.rpm setarch-1.0-1.i386.rpm Note: You don't need the perl-CGI on Fedora. 7) Extra patch (than RH9) required for Fedora: -- patch bug 3006854 (fedora only) ftp://metalinkuid:[EMAIL PROTECTED]/3006854/p3006854_9204_LINUX.zip 8) JVM installer patch from Werner's notes: -- jvm patch for fedora v1.3 (only) -- relink gcc so the older gcc will be used during the Oracle installation -- (See Oracle Note:252217.1 for more information) su - root mv /usr/bin/gcc /usr/bin/gcc323 ln -s /usr/bin/gcc296 /usr/bin/gcc mv /usr/bin/g++ /usr/bin/g++323 ln -s /usr/bin/g++296 /usr/bin/g++ -- apply patch 3006854 cp /home/oracle/oracle_9204_patches/metalink/p3006854_9204_LINUX.zip /tmp cd /tmp unzip p3006854_9204_LINUX.zip cd 3006854 sh rhel3_pre_install.sh 9) The workaround for ins_ctx error during install, remember that you can 'tail make.log' and attempt to modify the compiler command with suffix '-ldl', does not work on Fedora. Therefore, you sneaky guys, just follow Warner's notes and ignore until later when you fix it with a patch. 10) Warner fixed a 'chown' error on the O'Reilly notes. I think this is wrong on O'Reilly' instructions (at least for RH9 and Fedora installations): chown -R oracle.dba /opt/ora9/* No worries, Warner gets it correct. I have my entire (constantly changing) notes available if needed. That's a summary of the major differences (from RH9) needed for Fedora and Oracle 9.2.0.4. Good Luck. Regards, Mike Thomas --- David Hau [EMAIL PROTECTED] wrote: I had installed 9.2 on Fedora and created a new DB. Everything has been working fine so far. oemapp console, sqlplus and dbca all work fine. Haven't tried other tools. As Joe
RE: ORA-21779: duration not active
I think you may hitting a bug as per following details from metalink...You may open a tar for a workaround... Doc ID: 49397.1 As per above another oracle note you are setting any duration for this sesion which may be avoided...meaning have you assigned any profile to that user running export for certain session time limt... Regards Rafiq Bug 2556295 SDO_INTERSECTION fails with large GEOMETRIES (ORA-21779) This note gives a brief overview of bug 2556295. Affects: Product (Component) Oracle Spatial (SDO) Range of versions believed to be affected Versions 10G Versions confirmed as being affected 9.2.0.3 9.2.0.4 Platforms affected Generic (all / most platforms affected) Fixed: This issue is fixed in 10G Production Base Release Symptoms: Error may occur ORA-21779 Related To: Spatial Data Description SDO_INTERSECTION fails with ORA-21779 with large GEOMETRIES The full bug text (if published) can be seen at Bug:2556295 This link will not work for UNPUBLISHED bugs.
RE: ORA-21779: duration not active
Thanks Rafiq. BTW I am not setting any duration limit directly or thru profile. -Original Message- Rafiq Sent: Sunday, December 14, 2003 5:19 PM To: Multiple recipients of list ORACLE-L I think you may hitting a bug as per following details from metalink...You may open a tar for a workaround... Doc ID: 49397.1 As per above another oracle note you are setting any duration for this sesion which may be avoided...meaning have you assigned any profile to that user running export for certain session time limt... Regards Rafiq Bug 2556295 SDO_INTERSECTION fails with large GEOMETRIES (ORA-21779) This note gives a brief overview of bug 2556295. Affects: Product (Component) Oracle Spatial (SDO) Range of versions believed to be affected Versions 10G Versions confirmed as being affected 9.2.0.3 9.2.0.4 Platforms affected Generic (all / most platforms affected) Fixed: This issue is fixed in 10G Production Base Release Symptoms: Error may occur ORA-21779 Related To: Spatial Data Description SDO_INTERSECTION fails with ORA-21779 with large GEOMETRIES The full bug text (if published) can be seen at Bug:2556295 This link will not work for UNPUBLISHED bugs. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Sami INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: ORA-21779: duration not active
Sami, I think it is better to open an itar to resolve this issue... Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Sun, 14 Dec 2003 14:34:25 -0800 Thanks Rafiq. BTW I am not setting any duration limit directly or thru profile. -Original Message- Rafiq Sent: Sunday, December 14, 2003 5:19 PM To: Multiple recipients of list ORACLE-L I think you may hitting a bug as per following details from metalink...You may open a tar for a workaround... Doc ID: 49397.1 As per above another oracle note you are setting any duration for this sesion which may be avoided...meaning have you assigned any profile to that user running export for certain session time limt... Regards Rafiq Bug 2556295 SDO_INTERSECTION fails with large GEOMETRIES (ORA-21779) This note gives a brief overview of bug 2556295. Affects: Product (Component) Oracle Spatial (SDO) Range of versions believed to be affected Versions 10G Versions confirmed as being affected 9.2.0.3 9.2.0.4 Platforms affected Generic (all / most platforms affected) Fixed: This issue is fixed in 10G Production Base Release Symptoms: Error may occur ORA-21779 Related To: Spatial Data Description SDO_INTERSECTION fails with ORA-21779 with large GEOMETRIES The full bug text (if published) can be seen at Bug:2556295 This link will not work for UNPUBLISHED bugs. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Sami 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). _ Shop online for kidsÂ’ toys by age group, price range, and toy category at MSN Shopping. No waiting for a clerk to help you! http://shopping.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: M Rafiq INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Oracle E-Business Suite ERP Applications Mailing Lists
You are cordially invited to subscribe to the following Oracle E-Business Suite ERP Applications Mailing Lists: OraHRMS-L OraHRMS-L is a professional forum for the discussion of the Oracle HRMS (Human Resource Management Systems) application suite of software. This list was launched in 1998 and consists of approximately 1500 Oracle HRMS customers, third party consultants and Oracle employees. Oracle HRMS Development monitors and contributed to this mailing list. http://peopleapps.com/mailman/listinfo/orahrms-l_peopleapps.com OraFinApps OraFinApps is a professional forum for the discussion of the Oracle Financial application suite of software. This list was recently launched in December 2003. http://peopleapps.com/mailman/listinfo/orafinapps_peopleapps.com OraMFG-L OraMFG-L is a professional forum for the discussion of the Oracle Manufacturing application suite of software. This list was recently launched in December 2003. http://peopleapps.com/mailman/listinfo/oramfg-l_peopleapps.com NOTE: All lists are moderated and focused in discussion. They are not owned or endorsed by Oracle Corporation. Recruiting ads and situations wanted messages are not tolerated, although a new list for those topics will be launched shortly. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: gac 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: Oracle's jdbc driver
Yes Thanks a lot regards b s pradhan On Sat, 13 Dec 2003 David Hau wrote : The method you need is: OracleDatabaseMetaData.getDriverVersion() Write a small Java program to call this method, or take a look at Metalink note 94091.1 or 73629.1 for sample code to get JDBC driver version. Regards, Dave [EMAIL PROTECTED] wrote: Hi All How can I findout what is the version of the jdbc driver installed with oracle client install. Thanks and Regards B S Pradhan -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: David Hau 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).