Re: Host concurrent program whom call ar60runb
Hi Hemant,
Many thanks. You are right. It's all about the
variable environments. Now it works fine.
Have nice day.
Ben
--- Hemant K Chitale <[EMAIL PROTECTED]> wrote:
>
> Does your TEST.prog include the environment for
> ar60runb ?
> If it runs as a shell script, does it have
> $ORACLE_HOME, and $PATH
> setup correctly ?
> Hemant
> At 07:09 AM 21-01-04 -0800, you wrote:
> >Hi Listers,
> >
> >I'have registered host concurrent program on Oracle
> >11.5.9 as TEST.prog which include one line to
> execute
> >the ar60runb on command line. Unfortunately this is
> >does not work for me. The problem is the TEST.prog
> can
> >execute any other command or script (shell,
> Perl,...)
> >but not ar60runb which I can execute independently.
> >
> >Could you please help to resolve this problem?
> >
> >Thanks,
> >
> >Ben
> >
> >
> >__
> >Do you Yahoo!?
> >Yahoo! Hotjobs: Enter the "Signing Bonus"
> Sweepstakes
> >http://hotjobs.sweepstakes.yahoo.com/signingbonus
> >--
> >Please see the official ORACLE-L FAQ:
> http://www.orafaq.net
> >--
> >Author: Kader Ben
> > 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
> Oracle 9i Database Administrator Certified
> Professional
> http://hkchital.tripod.com {last updated 05-Jan-04}
>
>
> --
> 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).
__
Do you Yahoo!?
Yahoo! Hotjobs: Enter the "Signing Bonus" Sweepstakes
http://hotjobs.sweepstakes.yahoo.com/signingbonus
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Kader Ben
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).
Host concurrent program whom call ar60runb
Hi Listers, I'have registered host concurrent program on Oracle 11.5.9 as TEST.prog which include one line to execute the ar60runb on command line. Unfortunately this is does not work for me. The problem is the TEST.prog can execute any other command or script (shell, Perl,...) but not ar60runb which I can execute independently. Could you please help to resolve this problem? Thanks, Ben __ Do you Yahoo!? Yahoo! Hotjobs: Enter the "Signing Bonus" Sweepstakes http://hotjobs.sweepstakes.yahoo.com/signingbonus -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kader Ben 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: 9iAS - SSL certificate renewal and wallet manager
Hi I answered my own question. The wallet manager allows you to import the renewal certificate and then remove the old certificate and the ssl connections just keep on working. Ben -Original Message- Ben Sent: December 16, 2003 9:19 AM To: Multiple recipients of list ORACLE-L Hi My SSL certificate is going to expire and I need to renew it. I am running 9iAS 9.0.3 on Solaris8. All the documentation seems to be about setting up the original certificate and I can't find anything on renewals. Has anyone done this? I have requested a new certificate from Entrust using the wallet manager. Do I just import the new certificate? Will the wallet manager overwrite the old one or do I have to remove it first? Thanks in advance, Ben Queen's University -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ben 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: Ben 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).
9iAS - SSL certificate renewal and wallet manager
Hi My SSL certificate is going to expire and I need to renew it. I am running 9iAS 9.0.3 on Solaris8. All the documentation seems to be about setting up the original certificate and I can't find anything on renewals. Has anyone done this? I have requested a new certificate from Entrust using the wallet manager. Do I just import the new certificate? Will the wallet manager overwrite the old one or do I have to remove it first? Thanks in advance, Ben Queen's University -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ben 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: Reporting database
Hi Faan, Thanks Faan for this effectively critical point. Like you I have faced this problem after applying some patch (FND patches on 11.5.7) and since I have standby database as emergency environment. It was big problem. I wrote a scripts to detect such events and I read some metalink docs that said Oracle will leave these unrecoverable options on their future patches. Have nice day, Kader --- Faan DeSwardt <[EMAIL PROTECTED]> wrote: > Kader, > > Just a word of caution when considering options. > Keep an eye on all the Apps objects that have > NOLOGGING set. Last time I checked there were over > a thousand of those which were mostly indexes but > there are some tables among them. These are a real > pain when using redo log refreshing/updating > techniques like Quest's SharePlex and Dataguard. > > Definitely check out Metalink notes 216212.1 and > 216211.1 when considering and implementing this > refreshing technique. > > Good Luck and may the Force be with you! > > -f > > -Original Message- > Sent: Wednesday, December 03, 2003 1:45 PM > To: Multiple recipients of list ORACLE-L > > > At 06:24 3-12-03 -0800, you wrote: > >Hi Listers, > > > >I'm about producing document to my boss about > >different strategies to build Informational > database > >(reporting database) and ETL. Our production > database > >is 9i supporting Oracle Financials 11i. > > > >I'm concerned about the strategies that have a > minimum > >impact on the overload of production database. > > > >Could you please give me your advise and > experience. > >Any input well be very appreciated. > > Hi Kader, > > What do you mean with ETL? Is your reporting > database a DWH, and are you > considering unload from production and ETL into it? > Or do you just need an > exact copy of your production database? What > frequency should it be > updated? Daily, Weekly, real-time? > > For some of these options Data Guard might be a > solution, for others not. > For a daily update you can create a (physical) > standby database and put it > in read-only mode. You can query along, transactions > get forwarded but not > processed in the meantime. Every midnight, for > instance, you switch the > standby from R/O to Managed Recovery mode, and it > will 'synchronise' using > the redologs received since the last > synchronisation. After synchronisation > put it back into R/O mode, and you can query all day > long. During > synchronisation the database isn't available for > reporting. Data Guard > comes for free with your Oracle Licence. However, as > discussed in an > earlier thread on this list, you have to pay for the > standby server, unless > , AFAIK, you're paying according to the > named-user-plus model. > > It will give you the lowest possible overhead on > your production database, > except from using non-oracle storage level options > like mirroring disks and > detach them every n hours. > > > Regards, Carel-Jan > > -- There will allwasy be another 10 last bugs -- > > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.net > -- > Author: Carel-Jan Engel > 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: Faan DeSwardt > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 > http://www.fatcity.com > San Diego, California-- Mailing list and web > hosting services > - > To REMOVE yourself from this mailing list, send an > E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') and in > the message BODY, include a line containing: UNSUB > ORACLE-L > (or the name of mailing list you want to be removed > from). You may > also send the HELP command for other information > (like subscribing). __ Do you Yahoo!? Protect your identity with Yahoo! Ma
Reporting database
Hi Listers, I'm about producing document to my boss about different strategies to build Informational database (reporting database) and ETL. Our production database is 9i supporting Oracle Financials 11i. I'm concerned about the strategies that have a minimum impact on the overload of production database. Could you please give me your advise and experience. Any input well be very appreciated. Have nice day, Kader __ Do you Yahoo!? Free Pop-Up Blocker - Get it now http://companion.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kader Ben 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: OWS-05566 caused by ORA-12202
Is anyone else getting messages like this, just the footer added by Fat City? Thanks. Ben Schilling Wis Insurance Commission 608-266-1615 [EMAIL PROTECTED] -Original Message- Sent: Tuesday, November 18, 2003 12:34 AM To: Multiple recipients of list ORACLE-L -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Schilling, Ben 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: dba interview questions
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: Tim Gorman 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: Schilling, Ben 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: Noarchivelog ==> archivelog
Hi The database must be mounted and in exclusive mode in order to turn archiving on. You need to do a: startup mount exclusive then: alter database archivelog then: alter database open Ben -Original Message- [EMAIL PROTECTED] Sent: October 28, 2003 2:34 PM To: Multiple recipients of list ORACLE-L Hi List, Could someone help me to figure out what is going on here? I am trying to change db from NOARCHIVELOG --> ARCHIVELOG. SQL> archive log list Database log mode No Archive Mode Automatic archival Enabled Archive destination/u02/arch Oldest online log sequence 966 Current log sequence 968 SQL> shutdown Database closed. Database dismounted. ORACLE instance shut down. SQL> startup mount ORACLE instance started. Total System Global Area 1409298592 bytes Fixed Size73888 bytes Variable Size 374722560 bytes Database Buffers 102400 bytes Redo Buffers 10502144 bytes Database mounted. SQL> alter database archivelog; alter database archivelog * ERROR at line 1: ORA-01126: database must be mounted EXCLUSIVE and not open for this operation Thanks Sami -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ben INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: how to specify tablespace in Designer
Hats off and thanks to all for the great responses. I am well on my way now. This Designer beast is quite amazing. Ben -Original Message- Sent: October 23, 2003 2:02 PM To: '[EMAIL PROTECTED]' Cc: '[EMAIL PROTECTED]' Ben, You need to implement the table to assign storage attributes to it. This can be done either in the Ron or Db Designer where you are at. In Db Designer/DbAdmin tab, expand the database|Users|spcific User|Schema|Table Implementations entry. Click the green plus to implement a table in this area, and you should see the properties attribute pop up. Optionally right click on the Table Implementations selection and select "Create Table Implementations". Good Luck! Tom Mercadante Oracle Certified Professional -Original Message- Sent: Thursday, October 23, 2003 2:45 PM To: Multiple recipients of list ORACLE-L Hi Can someone who has used Designer to generate DDL let me know how you specify which tablespace a table or index is to be created in. I am using the Design Editor and the DBAdmin tab and can't seem to find it. Thanks in advance. Ben -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ben 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: Ben 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).
how to specify tablespace in Designer
Hi Can someone who has used Designer to generate DDL let me know how you specify which tablespace a table or index is to be created in. I am using the Design Editor and the DBAdmin tab and can't seem to find it. Thanks in advance. Ben -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ben 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: Embedded transactions
Thanks guys for your inputs, I just want include a procedure (which include commit) into my package testing. Have nice a day, Kader --- [EMAIL PROTECTED] wrote: > if you need to 'rollback' everything, then you > should make it one transaction. You can add > savepoints and rollback to: if you want to limit it > that way. > > commit means complete. You should not commit unless > you are sure you may not want to rollback. > > why are you committing in the inner transaction? > > > > From: "Jamadagni, Rajendra" > <[EMAIL PROTECTED]> > > Date: 2003/09/16 Tue PM 12:29:39 EDT > > To: Multiple recipients of list ORACLE-L > <[EMAIL PROTECTED]> > > Subject: RE: Embedded transactions > > > > no. > > > > Raj > > > > > > > Rajendra dot Jamadagni at nospamespn dot com > > All Views expressed in this email are strictly > personal. > > QOTD: Any clod can have facts, having an opinion > is an art ! > > > > > > -Original Message- > > Sent: Tuesday, September 16, 2003 12:20 PM > > To: Multiple recipients of list ORACLE-L > > > > > > Hi Listers, > > > > I have two transactions one embedded into > another. > > The inner transaction have commit. Is it possible > to > > rollback all (the inner and the outer) transaction > if > > the outer one fail? > > > > Thank you for your help, > > > > > > Kader > > > > __ > > Do you Yahoo!? > > Yahoo! SiteBuilder - Free, easy-to-use web site > design software > > http://sitebuilder.yahoo.com > > -- > > Please see the official ORACLE-L FAQ: > http://www.orafaq.net > > -- > > Author: Kader Ben > > 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). > > > > > This > e-mail message is confidential, intended only for > the named recipient(s) above and may contain > information that is privileged, attorney work > product or exempt from disclosure under applicable > law. If you have received this message in error, or > are not the named recipient(s), please immediately > notify corporate MIS at (860) 766-2000 and delete > this e-mail message from your computer, Thank > you.*2 > > > > > - RE: Embedded transactions no. Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message- Sent: Tuesday, September 16, 2003 12:20 PM To: Multiple recipients of list ORACLE-L Hi Listers, I have two transactions one embedded into another. The inner transaction have commit. Is it possible to rollback all (the inner and the outer) transaction if the outer one fail? Thank you for your help, Kader __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kader Ben INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- Please see the official ORA
Embaded transactions
Hi Listers, I have two transactions one embedded into another. The inner transaction have commit. Is it possible to rollback all (the inner and the outer) transaction if the outer one fail? Thank you for your help, Kader __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kader Ben 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: rename data file on standby database
Many thanks Louis for your input, Have nice day, Kader --- Jose Luis Delgado <[EMAIL PROTECTED]> wrote: > Hi Kader... > > you do not need to do the same on the standby > database... > > That logical changes are reflected automatically... > The only thing is that your physical datafile remain > as initially, but your controlfile has the changes. > > Was I clear? > > note that the only changes that you need to do at > your > standby database is when you add > tablespaces/datafiles > to your primary database, then you need to add them > to > your standby database. > > HTH > JL > > > --- Kader Ben <[EMAIL PROTECTED]> wrote: > > Hi Listers, > > > > I have standby database working fine (until now!). > I > > have renamed one datafile on the primary database > > and > > I'm wondering if I have to do the same thing on > the > > standby database to reflect the structure change. > > I have renamed the file yesterday and the standby > > database stil recovering incoming archives without > > any > > error but the data file renamed on the primary > > database is on the its original location on the > > standby database. > > > > Many thanks for your help, > > > > Kader > > > > > > > > __ > > Do you Yahoo!? > > Yahoo! SiteBuilder - Free, easy-to-use web site > > design software > > http://sitebuilder.yahoo.com > > -- > > Please see the official ORACLE-L FAQ: > > http://www.orafaq.net > > -- > > Author: Kader Ben > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- 858-538-5051 > > http://www.fatcity.com > > San Diego, California-- Mailing list and > web > > hosting services > > > - > > To REMOVE yourself from this mailing list, send an > > E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of > > 'ListGuru') and in > > the message BODY, include a line containing: UNSUB > > ORACLE-L > > (or the name of mailing list you want to be > removed > > from). You may > > also send the HELP command for other information > > (like subscribing). > > > __ > Do you Yahoo!? > Yahoo! SiteBuilder - Free, easy-to-use web site > design software > http://sitebuilder.yahoo.com > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.net > -- > Author: Jose Luis Delgado > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 > http://www.fatcity.com > San Diego, California-- Mailing list and web > hosting services > - > To REMOVE yourself from this mailing list, send an > E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') and in > the message BODY, include a line containing: UNSUB > ORACLE-L > (or the name of mailing list you want to be removed > from). You may > also send the HELP command for other information > (like subscribing). __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kader Ben 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).
rename data file on standby database
Hi Listers, I have standby database working fine (until now!). I have renamed one datafile on the primary database and I'm wondering if I have to do the same thing on the standby database to reflect the structure change. I have renamed the file yesterday and the standby database stil recovering incoming archives without any error but the data file renamed on the primary database is on the its original location on the standby database. Many thanks for your help, Kader __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kader Ben 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).
Gather stats on 11i
Hi Listers, I'm using concurrent program of 11i (Oracle financials) on 9i RAC to gather schemas stats but the program never finished because generates deadlock on several tables. I have to kill many sessions to allow program to finish. Did same one experienced this problem? Thank you for your input. Ben __ Do you Yahoo!? Yahoo! Calendar - Free online calendar with sync to Outlook(TM). http://calendar.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kader Ben 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: median function
Title: median function here is a note from the list from awhile aback: Since this subject was brought back up, I thought maybe some would be interested in the following. I've never had a need to calculate a median, but, I knew Celko's SQL for Smarties had a few variations and examples from various people, each with caveats. And then there were differences between what he termed statistical and financial mean, and some other things as well. Anyway, a google search turned up another Celko solution. And this one also brings up the concept of weighted median. Here is his example, http://www.intelligententerprise.com/db_area/archives/1999/992004/celko.shtml , modified by me to use the standard EMP table's SAL column: SQL> SELECT AVG(DISTINCT x.sal) 2 FROM (SELECT F1.sal 3 FROM emp F1, emp F2 4 GROUP BY F1.empno, F1.sal 5 HAVING SUM(CASE WHEN F2.sal = F1.sal 6 THEN 1 ELSE 0 END) 7 >= ABS(SUM(CASE WHEN F2.sal < F1.sal THEN 1 8 WHEN F2.sal > F1.sal THEN -1 9 ELSE 0 END))) 10 X 11 / AVG(DISTINCTX.SAL) -- 1550 The link above goes into some detail regarding the logic behind the query and how his query finally reached the form above. I may never need to do a median, but, this subject has been a good opportunity for learning. I've tested the above with even, odd, multiple occurences of SAL, null,s etc. It seems to work, but, everyone have a whack at it if you like. Regards, Larry G. Elkins [EMAIL PROTECTED] -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Adams, Matthew (GECP, MABG, 088130)Sent: June 10, 2003 12:40 PMTo: Multiple recipients of list ORACLE-LSubject: median function I'm attempting to write a query to calculate the median of a column of numbers. The first solution I came across was Select avg(col1) MEDIAN from ( select rownum row1, col1 from a where col1 in (select col1 from a )) a where a.row1 in ( select floor(count(*)/2 +.5) from a ) or a.row1 in ( select ceil(count(*)/2+.5) from a ) This does too many FT scans (4) of table a, so I tried to write a simpler version using the analytical functions. I have gotten as far as SELECT col1 FROM ( SELECT col1 , row_number() OVER (ORDER BY col1) AS r , CEIL(COUNT(col1) OVER () /2) m FROM a ) WHERE r = m However, this only works for an odd number of values. IIRC, if an even number of values is present, the median is defined as the average of the two middle-most numbers. Before I spend much more time on this, has anybody already written one ? Matt Adams - GE Appliances - [EMAIL PROTECTED] If carpenters built buildings the way programmers write programs, the first woodpecker to come along would destroy civilization. - author unknown
RE: Oracle DB Upgrade TO DO LIST
Ken, Jared is probably right as far as a checklist for the actual upgrade. A test run through will probably highlight any problem areas. After the upgrade there are a number of things that usually need to be checked/modified/recompiled (of course it depends on how you upgrade). Here is a list that I found useful. Please add to it if you wish. - ODBC connections - applications - DBA scripts in SQL, PERL, etc. - SQL*LDR jobs - regular imports, exports, snapshots - FTP's of data to be loaded/imported/exported - database links - backups - scheduled jobs - scripts that mail logs or reports - alert log check scripts - parameter files (*.ora) - metadata for third party query tools Ben -Original Message- [EMAIL PROTECTED] Sent: June 3, 2003 1:10 PM To: Multiple recipients of list ORACLE-L Ken, The best to do list will be the one you create yourself. You can do this by reviewing the migration manual, and determining which steps are appropriate for your environment. Jare "KENNETH JANUSZ" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 06/02/2003 08:49 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:Oracle DB Upgrade TO DO LIST I am looking at a project to upgrade a number of Oracle development, test and production DB's to newer releases. I have reviewed Oracle's list of tasks from OTN. I would like your feedback on other tasks, etc. that should be included. Is there a list somewhere on the web that gives a comprehensive list of tasks that need to be accomplished and "gotchas"? TIA, Ken Janusz, CPIM -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ben 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).
How do you document your databases
Hi How do you document your databases? The only DBA tool that I have at my disposal is Designer but I have not used it yet. Is it adequate to completely document the life cycle of a database design? I am sure it can create and retain pretty straight forward DDL. Does it allow build levels? What do you do with the DBA tinkering - things like which tablespace a table goes into, storage clauses, parameters like PCTFREE, PCTUSED,etc? Where do you document your pfile? What about when you have to alter a table after the database is in production? Do you document the alter script itself or do you go back and change the original DDL? Then there are things like SQL*LDR control files, security (all the grants) and all the auditing that has been turned on. Where do you keep all this stuff? Thanks in advance for any advice. Ben -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ben 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: Fixed_date and dbms_job
Many thanks Jared, Definitely I think this is only one away to resolve my problem. Have nice week end, Ben --- [EMAIL PROTECTED] wrote: > You can't call a job every second via DBMS_JOB. > > I believe that at best the resolution is 1 minute. > > You could just open another session and run > something like this: > > declare >fd varchar2(50) := '01/01/2010 00:00:00'; >v_sql varchar2(200); > begin >loop > v_sql := 'alter system set fixed_date = "' || > fd || '"'; > execute immediate v_sql; > dbms_lock.sleep(1); > fd := to_char(to_date(fd,'mm/dd/ > hh24:mi:ss') + 1/86400, > 'mm/dd/ hh24:mi:ss'); > end loop; > end; > / > > Jared > > > > > > > Kader Ben <[EMAIL PROTECTED]> > Sent by: [EMAIL PROTECTED] > 03/13/2003 03:18 PM > Please respond to ORACLE-L > > > To: Multiple recipients of list ORACLE-L > <[EMAIL PROTECTED]> > cc: > Subject:Fixed_date and dbms_job > > > Hi Listers, > > I'm simulating the date in future with fixed_date. > I wrote procedure to be called every seconde through > dbms_job to increment the fixed_date. > > I did that dbms_job.submit(:job_num, 'myprocedure;', > sysdate, 'sysdate'); > > the dba_jobs table show me the right interval un > next_date: > > > BROKEN ST_DATE LAST_SEC NEXT_DATE NEXT_SEC > INTERVAL > N 13-JUN-03 00:00:00 13-JUN-03 17:50:06 sysdate > > And the sysdate is: > 13-JUN-2003 17:50:06 > > But the job never execute. > > Could you please give me hint how to resolve this > problem? > > Thanks you, > > Ben > > > __ > Do you Yahoo!? > Yahoo! Web Hosting - establish your business online > http://webhosting.yahoo.com > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.net > -- > Author: Kader Ben > 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). > __ Do you Yahoo!? Yahoo! Web Hosting - establish your business online http://webhosting.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kader Ben 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: Fixed_date and dbms_job
Thanks Jacques, Yes I did: VARIABLE jobno number; BEGIN DBMS_JOB.SUBMIT(:jobno, 'fixed_date_proc.getSystemDate;',sysdate, 'sysdate', true); commit; end; / Ben --- Jacques Kilchoer <[EMAIL PROTECTED]> wrote: > After calling dbms_job.submit, did you issue a > commit? > > > -----Original Message- > > From: Kader Ben [mailto:[EMAIL PROTECTED] > > > > I'm simulating the date in future with > fixed_date. > > I wrote procedure to be called every seconde > through > > dbms_job to increment the fixed_date. > > > > I did that dbms_job.submit(:job_num, > 'myprocedure;', > > sysdate, 'sysdate'); > > > > the dba_jobs table show me the right interval un > > next_date: > > > > > > BROKEN ST_DATE LAST_SEC NEXT_DATE NEXT_SEC > INTERVAL > > N 13-JUN-03 00:00:00 13-JUN-03 17:50:06 > sysdate > > > > And the sysdate is: > > 13-JUN-2003 17:50:06 > > > > But the job never execute. > ______ Do you Yahoo!? Yahoo! Web Hosting - establish your business online http://webhosting.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kader Ben 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: Fixed_date and dbms_job
Thnks Michal for your input, All seems right for me: SQL> show parameter job NAME TYPEVALUE --- -- job_queue_interval integer 90 job_queue_processes integer 2 Michal I cannot put next_date to 'sysdate+1/86400' because this date will never be reached since I use ALTER SYSTEM SET FIXED_DATE = sysdate+deta Where the delta is the incremental time to simulate pseudo-time in the future. And the main objective of the procedure to do. Ben --- Michal Zaschke <[EMAIL PROTECTED]> wrote: > Hi, > > 1) check job_queue_processes and job_queue_interval > parameters in your > init.ora file > 2) have a commit after dbms_job.submit > 3) if you want the procedure to be executed every > second, then the next > date should be 'sysdate+1/86400' => > dbms_job.submit(:job_num, 'myprocedure;',sysdate, > 'sysdate+1/86400'); > > Mike > > Kader Ben wrote: > > Hi Listers, > > > > I'm simulating the date in future with > fixed_date. > > I wrote procedure to be called every seconde > through > > dbms_job to increment the fixed_date. > > > > I did that dbms_job.submit(:job_num, > 'myprocedure;', > > sysdate, 'sysdate'); > > > > the dba_jobs table show me the right interval un > > next_date: > > > > > > BROKEN ST_DATE LAST_SEC NEXT_DATE NEXT_SEC > INTERVAL > > N 13-JUN-03 00:00:00 13-JUN-03 17:50:06 > sysdate > > > > And the sysdate is: > > 13-JUN-2003 17:50:06 > > > > But the job never execute. > > > > Could you please give me hint how to resolve this > > problem? > > > > Thanks you, > > > > Ben > > > > > > __ > > Do you Yahoo!? > > Yahoo! Web Hosting - establish your business > online > > http://webhosting.yahoo.com > > > -- > Ing. Michal Zaschke > DB Administrator > Sokolovska uhelna, a.s. > tel.: +420 352 465417 > e-mail: [EMAIL PROTECTED] > > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.net > -- > Author: Michal Zaschke > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 > http://www.fatcity.com > San Diego, California-- Mailing list and web > hosting services > - > To REMOVE yourself from this mailing list, send an > E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') and in > the message BODY, include a line containing: UNSUB > ORACLE-L > (or the name of mailing list you want to be removed > from). You may > also send the HELP command for other information > (like subscribing). > __ Do you Yahoo!? Yahoo! Web Hosting - establish your business online http://webhosting.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kader Ben 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).
Fixed_date and dbms_job
Hi Listers, I'm simulating the date in future with fixed_date. I wrote procedure to be called every seconde through dbms_job to increment the fixed_date. I did that dbms_job.submit(:job_num, 'myprocedure;', sysdate, 'sysdate'); the dba_jobs table show me the right interval un next_date: BROKEN ST_DATE LAST_SEC NEXT_DATE NEXT_SEC INTERVAL N 13-JUN-03 00:00:00 13-JUN-03 17:50:06 sysdate And the sysdate is: 13-JUN-2003 17:50:06 But the job never execute. Could you please give me hint how to resolve this problem? Thanks you, Ben __ Do you Yahoo!? Yahoo! Web Hosting - establish your business online http://webhosting.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kader Ben INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Performance issue
Hi Lisetrs, I have enough free memory from shared_pool_size and I run stats every week but the BD still shows up the low hit ratio and some times the later full down to 15%! Here is some informations: Obj mem: 79503437 bytes Shared sql: 23852410 bytes Cursors: 244875 bytes Free memory: 204512816 bytes (195.04MB) Shared pool utilization (total): 124320866 bytes (118.56MB) Shared pool allocation (actual): 3 bytes (286.1MB) Percentage Utilized: 41% Hit Ratio : 74.2249062 I appreciate to give me some guidelines. Thanks, Ben __ Do you Yahoo!? Yahoo! Tax Center - forms, calculators, tips, more http://taxes.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kader Ben 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 License for Training
The Madison (Wisconsin) Area Technical College has several Oracle classes available. Some of them are in their CIS-Certificate in Oracle Database Administration Associate Curriculum. -Original Message- Sent: Tuesday, February 11, 2003 2:44 PM To: Multiple recipients of list ORACLE-L All I can speak for are the schools in my area (Dallas, TX). A few of the community colleges teach Oracle and SMU teaches it, but in each case, it is continuing education, not part of a Computer science degree. It's the same class as at Oracle education, i.e. no grades, not tests, everyone passes that shows up. But then, I'm not sure a degree in Computer science should target a particular vendors product. Keith - Original Message - To: Multiple recipients of list ORACLE-L <mailto:[EMAIL PROTECTED]> Sent: Tuesday, February 11, 2003 1:55 PM You are WRONG! The Oracle Academic Initiative has 100's of members. In California there are more than 200. John [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> wrote: Quoting Markus Reger "> <mailto:[EMAIL PROTECTED]> <[EMAIL PROTECTED]>: I have to manage MySQL and ORACLE for the web likewise. There seems to be a strong tendency towards MySQL if people newly enter the area of webpresence, students or profs doesn't make a difference. For web work. MySQL is very popular (Together with PHP). For everything else, Access is usually the intro if developing dektop apps. MS SQL if the intro is a bit higher end (non-desktop applications). DB2 is also an intro in some schools. You never see Oracle as the intro DB in any school (a real school as in University, College, High School not those $$$ making diploma mills). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Schilling, Ben 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-directing database connection requests
Hi Is there a way to re-direct incoming database connection requests to another server? I believe Oracle Connection Manager can do this but it requires the database to be running in MTS mode. Is there another way? Thanks, Ben -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ben 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 9i release 3 coming?
Title: Internet file system Hi I think you are seeing notes on the latest release of 9iAS which is 9.0.3. Ben -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Boivin, Patrice JSent: January 13, 2003 9:24 PMTo: Multiple recipients of list ORACLE-LSubject: Oracle 9i release 3 coming? Oracle started posting items with the 9.0.3. number, does this imply they plan to release a 9i Release 3? regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin & Operations | Admin. et Exploit. des systèmes Technology Services | Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED]
fnd_global user_id
Hi Listers, I'm running concurrent program to create user (that's call fnd_user_pkg.CreateUser procedure) on 11i but the program fails because the fnd_global.user_id return -1! Can someone help me how resolve this problem? Thanks you so much, Ben __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kader Ben 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: Monitoring Tool Evaluation methodology
Hi Sean, Me too I'm interested into your evaluation methodology. Thanks, Kader --- [EMAIL PROTECTED] wrote: > > > Hello Sean, > > Would you mind sending me your evaluation? I'm in > the process of performing > a tool evaluation also, and this material would be > invaluable. > > > Thanks, > > Todd > > > > > > "O'Neill, Sean" <[EMAIL PROTECTED]> on > 11/29/2002 05:34:00 AM > > Please respond to [EMAIL PROTECTED] > > To: Multiple recipients of list ORACLE-L > <[EMAIL PROTECTED]> > cc: > > > > > > Hi there, > > If you are interested I can send you a word > document which I used to select > and evaluate an Oracle monitoring tool solution > which might be useful for > adapting to your needs. We're an NT/W2K site. > > BTW, we choose Quest I/Watch as our solution. Did > not come across eHurkha > product during our evaluation. > > HTH, > - > Seán O' Neill > Organon (Ireland) Ltd. > [subscribed: digest mode] > > > > >>From: VIVEK_SHARMA > [SMTP:[EMAIL PROTECTED]] > >>Sent: Thursday, November 28, 2002 5:44 PM > >>To: Multiple recipients of list ORACLE-L > >>Subject: Monitoring Tool Evaluation > methodology > >> > >> > >>We are evaluating a monitoring Tool (eGurkha) for > Unix/NT/Oracle > monitoring > >> > >>What features should be Looked into while > Evaluating ? > >>Are there any Best practices for doing this kind > of Evaluation ? > >>Any Comments on this tool in particular by any who > might have used this > >>tool ? > >> > >>etc.. > > This message, including attached files, may contain > confidential > information and is intended only for the use by the > individual > and/or the entity to which it is addressed. Any > unauthorized use, > dissemination of, or copying of the information > contained herein is > not allowed and may lead to irreparable harm and > damage for which > you may be held liable. If you receive this message > in error or if > it is intended for someone else please notify the > sender by > returning this e-mail immediately and delete the > message. > > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: O'Neill, Sean > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 > http://www.fatcity.com > San Diego, California-- Mailing list and web > hosting services > - > To REMOVE yourself from this mailing list, send an > E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') and in > the message BODY, include a line containing: UNSUB > ORACLE-L > (or the name of mailing list you want to be removed > from). You may > also send the HELP command for other information > (like subscribing). > > > > > > > __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kader Ben 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).
Cursor column name
Hi listers, Can someone tell me how to get column's name using cursor. Thanks in advance, Kader __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kader Ben INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: how to download all the openworld documents?
Does anyone have a copy of "Locking down your OAS" by Aaron Newman? It is not posted to the open world docs page yet. Thanks Ben [EMAIL PROTECTED] -Original Message- WILLIAMS Sent: November 18, 2002 3:49 PM To: Multiple recipients of list ORACLE-L Well, for myself, I'm glad to have ANY access. So thank you, Gillian, and no buts about it. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, November 18, 2002 1:38 PM To: Multiple recipients of list ORACLE-L Thank you, but what I want is download 'ALL' docuemnts NOT one by one. >From: Gillian <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >Subject: Re: how to download all the openworld documents? >Date: Mon, 18 Nov 2002 10:18:30 -0800 > > >Try this link: >http://www.oracle.com/oracleworld/sanfrancisco/conference/ems_search.html >I went to openworld.oracle.com , and click my way through to get to the >above link. >Gillian > [EMAIL PROTECTED] wrote: > > Does their has way that can download (or purchase CD) all the ORACLE > > Openworld documents? > >Some of the presenters alluded to them being uploaded somewhere, but I >haven't found it. The presentations I saw, I simply emailed the presenter >to get a copy. You might try this. > >HTH, >Sean > >-- >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). > > >- >Do you Yahoo!? >Yahoo! Web Hosting - Let the expert host your site _ Help STOP SPAM with the new MSN 8 and get 2 months FREE* http://join.msn.com/?page=features/junkmail -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: dist cash 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: 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ben INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Parallel Server Option = TRUE
Hi Pablo, There is no known problem if you have installed OPS even thought actually you don't use it, there is also no impact on DML_LOCK if your data are accessed by only one instance. Comment out PARALLEL_SERVER if is in your parameter file. HTH Kader --- Pablo Rodriguez <[EMAIL PROTECTED]> wrote: > Hope someone can help me with this one. > > I have just realized that PARALLEL SERVER = TRUE in > v$option and I don't have an OPS instalation. > > I've installed this Oracle code in a Unix Cluster > that's why Oracle has installed this option > automatically, I assume. > > Can anyone tell me if there can be any problems in > the > instance because of the PARALLEL SERVER = TRUE and > using a single instance database? > > I don't know may be a problem with the DML_LOCKS or > a > problem with cursors or with the shared pool, etc... > > > thanks > > > > ___ > Yahoo! Messenger > Nueva versión: Webcam, voz, y mucho más ¡Gratis! > Descárgalo ya desde http://messenger.yahoo.es > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: =?iso-8859-1?q?Pablo=20Rodriguez?= > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 > http://www.fatcity.com > San Diego, California-- Mailing list and web > hosting services > - > To REMOVE yourself from this mailing list, send an > E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') and in > the message BODY, include a line containing: UNSUB > ORACLE-L > (or the name of mailing list you want to be removed > from). You may > also send the HELP command for other information > (like subscribing). ______ Do you Yahoo!? HotJobs - Search new jobs daily now http://hotjobs.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kader Ben 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: Installing iAS 9.0.2.0.1
If you only want it to do web apps it's not a problem. We installed the OC4J and web cache portion on Solaris in an hour. Very easy. Needed it for version 1.3 of Java. Next we will tackle the full install with the infrastructure which will allow the use of Portal, Reports and Discoverer. Expecting big time headaches based on the documentation and the fact that we want to use iPlanet not the OID for our LDAP. Ben -Original Message- [EMAIL PROTECTED] Sent: October 25, 2002 3:56 PM To: Multiple recipients of list ORACLE-L Gene, We tried it on HPUX and it was not pretty. We ended up going back to 9iAS 1.0.2.2 for various reasons. Good luck. Scott Shafer San Antonio, TX 210.581.6217 > -Original Message- > From: Gene Sais [SMTP:[EMAIL PROTECTED]] > Sent: Friday, October 25, 2002 2:34 PM > To: Multiple recipients of list ORACLE-L > Subject: Installing iAS 9.0.2.0.1 > > Has anyone installed iAS 9.0.2.0.1 on Intel Linux? I have downloaded the > reams of documentation and this is a beast, much different than OAS 4.0.8. > It requires a 9i db, Oracle Single SignOn, OID, OEM Server, 9i Listener w/ > port 1521 free for iAS, etc. So many dependencies for iAS and I haven't > even looked at deploying forms yet :). I can't wait til 10i when DBA's > are no longer required, *HA!* > > Gene > -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ben 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).
Can 9iAS Rel2 still do SSLv2 40bit encryption?
Hi We have 9iAS Rel.1 running 40-bit and 128-bit encryption. We are migrating to Release2 and I am wondering if it will still allow 40-bit. The security guide says: Clients can only connect with one of the specified protocols: SSLv3 - SSL version 3.0 or All - SSL version 3.0 and any other version supported by Oracle products. What do they mean by any other version supported? Are they just leaving the door open for SSLv4? Ben -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ben 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: copying all schemas except sys
Hi Well my import choked on SYS.DBMS_REPCAT_UTL so I just assumed that there was SYS schema stuff in the full export. I see now that the import must execute this package. This package was having a problem with the fact that the exported global name did not match that of the instance I was importing into. How do I avoid this problem? I don't want to have to delete the replications stuff out of the instance before I export. Ben -Original Message- Gopalakrishnan Sent: September 19, 2002 3:43 PM To: Multiple recipients of list ORACLE-L Export program **never** exports the contents of SYS. WHy do you need a parameter IGNORE_SYS when it is ignored already? KG -Original Message- Sent: Thursday, September 19, 2002 12:18 PM To: Multiple recipients of list ORACLE-L Hi Starting with Oracle8i there is a problem with using full export and full import to re-create a database. The import coughs up a lot of errors due to the SYS schema (replication and help objects). How do people go about moving all the schemas from one instance to another without manually creating all the schema owners in the new instance and then exporting/importing every schema by name. What I want is an "ignore sys schema" parameter in the export utility. Thanks, Ben -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ben 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: K Gopalakrishnan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ben 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: copying all schemas except sys
Hi Well my import choked on the package SYS.DBMS_REPCAT_UTL so I assumed that there was SYS stuff in the full export. -Original Message- Gopalakrishnan Sent: September 19, 2002 3:43 PM To: Multiple recipients of list ORACLE-L Export program **never** exports the contents of SYS. WHy do you need a parameter IGNORE_SYS when it is ignored already? KG -Original Message- Sent: Thursday, September 19, 2002 12:18 PM To: Multiple recipients of list ORACLE-L Hi Starting with Oracle8i there is a problem with using full export and full import to re-create a database. The import coughs up a lot of errors due to the SYS schema (replication and help objects). How do people go about moving all the schemas from one instance to another without manually creating all the schema owners in the new instance and then exporting/importing every schema by name. What I want is an "ignore sys schema" parameter in the export utility. Thanks, Ben -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ben 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: K Gopalakrishnan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ben 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: copying all schemas except sys
Maybe I answered my own question. If I do the full export as another dba user (not sys,system) then hopefully I will not get the sys schema in the export. Ben -Original Message- Sent: September 19, 2002 2:14 PM To: Oracle List New Hi Starting with Oracle8i there is a problem with using full export and full import to re-create a database. The import coughs up a lot of errors due to the SYS schema (replication and help objects). How do people go about moving all the schemas from one instance to another without manually creating all the schema owners in the new instance and then exporting/importing every schema by name. What I want is an "ignore sys schema" parameter in the export utility. Thanks, Ben -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ben 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).
copying all schemas except sys
Hi Starting with Oracle8i there is a problem with using full export and full import to re-create a database. The import coughs up a lot of errors due to the SYS schema (replication and help objects). How do people go about moving all the schemas from one instance to another without manually creating all the schema owners in the new instance and then exporting/importing every schema by name. What I want is an "ignore sys schema" parameter in the export utility. Thanks, Ben -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ben 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 9iAS Rel.1 upgrade to 9iAS Rel.2
Hi Has anyone upgraded from 9iAS 1.0.2.2.2 to the new Release 2? Is there a migration path or should you start from scratch with Rel.2 as it is significantly different (what with the infrastructure stuff and all). I have heard that migrating any Portal stuff is nigh on impossible. Any other comments. Thanks, Ben -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ben 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: What's STATSPACK
-Original Message- Sent: Wednesday, August 14, 2002 9:24 PM To: Multiple recipients of list ORACLE-L Thanks Chaos for your invaluable information. Chuan -Original Message- Sent: Thursday, 8 August 2002 7:34 PM To: Multiple recipients of list ORACLE-L Chuan Zhang£¬ hi, go to $ORACLE_HOME/rdbms/admin, ls sp*, you will find the sqls that needed by statspack. and vi spdoc.txt, you will know what statspack is. There is some paper on statspack performance tuning on otn. and donald burleson also wrote a book on statspack: oracle statspack high performance tuning, your can get it and take a look. Good luck. If you are in china, there is chinese translation already. 2002-08-07 23:43:00 You wrote: >Hi, > > I saw lots of discussion related to STATSPACK. What's STATSPACK? Is it Oracle build-in function or third party product? Where can I download those scripts? > >Thanks in advance, > >Chuan Good luck! chaos [EMAIL PROTECTED] zhu chao DBA of Eachnet.com 86-021-32174588-667 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: chaos 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: Schilling, Ben 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).
Failover
Hi All, I have 11i running on OPS database with two instances. I assigned each instance to group of responsibilities but I have no idea how to configure the FAILOVER. If one instance goes down I want the user who has assigned this instance can transparently connect to the other instance. I'll appreciate any suggestion. Thank you, Kader __ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kader Ben 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).
creating 9i database and port 2481 conflict
Hi I have a data server which is running several 8i instances (8.1.7) with Jservers on Solaris8. I installed 9i version 9.0.1 and created a 9i database instance. All instances and listeners were shut down when I did this. So far all went well. Then I used the database config assistant to clone the 9i database by creating it's template and changing the dbname and file names. When I try to create this new 9i database using the template I get the following error: ORA-29532: Java call terminated by uncaught Java exception: java.net.BindException: Unable to bind endpoint, status = 12542<0.0.0.0,2481> during the java install. Oracle support says I should just shut down my listener and run the create and it will work as it is a conflict over the GIOP port 2481. Has anyone managed to do this without shutting the listener down? Thanks, Ben -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ben INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Oracle 9iAS Rel.2 requires OID
Hi Just browsing through the documentation for 9iAS 9.0.2 and I am a bit surprised. It looks as though you have to install the so called Infrastructure (SingleSignOn, Oracle Internet Directory and a metadata repository) if you want to use Portal or Discoverer. If you are just running web apps then you don't need the Infrastructure. We are using 9iAS R1 for web apps and taking a look at Portal and Discoverer. But if they require the OID then I doubt we will use them. Oracle appears to be forcing you to become an all-Oracle shop. Why am I surprised? Ben -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ben 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: Moving Autit Tables
Hi Chris, go to the following link you'll find a paper about that: http://www.oracle.com/oramag/oracle/99-Nov/index.html?69dbajj.html kader --- "Guidry, Chris" <[EMAIL PROTECTED]> wrote: > Hi All, > There has been some discussion in the past regarding > moving > the audit tables out of the SYSTEM table space to > avoid fragmentation. > Is this a good idea and if so does any have a > procedure for doing so? > Are there any problems to watch out for? > > O7345 - WinNT - RAID 0+1 > > -- > Chris J. Guidry P.Eng. EE > ATCO Electric, Metering Services > Phone: (780) 420-4142 > Fax: (780) 420-3854 > Email: [EMAIL PROTECTED] > > > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: Guidry, Chris > 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!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kader Ben 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 8.1.7.3 or 8.1.7.4
Hi Are these patch sets cumulative? If I am at 8.1.7.0 can I just apply the 8.1.7.4 patch set or do I have to apply them all in order. Thanks. -Original Message- Travis Sent: May 22, 2002 2:39 PM To: Multiple recipients of list ORACLE-L http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_datab ase_id=NOT&p_id=120607.1 http://ap103aru.us.oracle.com/ARULink/PatchSearch/get_form > -Original Message- > From: Ruth Gramolini [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, May 22, 2002 1:06 PM > To: Multiple recipients of list ORACLE-L > Subject: patchset 8.1.7.3 or 8.1.7.4 > > > Dear List, > > What is the number of the patch for 8.1.7.3 or 8.1.7.4 and where can I > download them? I looking on the FTP site and on Metalink > but I couldn't > tell which was which. > > Thanks, > Ruth > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Ruth Gramolini > 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: Glenn Travis 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 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: TEST
Your shift key is not working correctly -Original Message- Sent: Monday, May 20, 2002 1:18 AM To: Multiple recipients of list ORACLE-L TESTING ... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Schilling, Ben INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: SQLPlus was Oracle - "can you imagine" ;-)
One of our users called UFI "User Surly Interface." -Original Message- Sent: Friday, May 17, 2002 12:38 PM To: Multiple recipients of list ORACLE-L ufi, user friendly interface. Boy I feel old now [EMAIL PROTECTED] wrote: >OK Keith, do you remember what the prompt was that SQL*Plus came up with back >them & what it stood for?? > >Dick Goulet > >Reply Separator >Author: Jan Pruner <[EMAIL PROTECTED]> >Date: 5/17/2002 8:03 AM > >Yes, I can. >4 years ago I was porting our product to MS SQL 6.5 platform. > >JP > >On Fri 17. May 2002 16:53, you wrote: > >>ever wonder why SQLPlus is so damn robost? It can do >>just about anything... in a messy and time consuming >>way sometimes, but it is rock solid. >> >>"About 15 years ago, Sqlplus WAS Oracle". Nothing >>else. Hard to imagine. An Oracle engine with nothing >>inside (just tables and indexes): >>no procedures, >>no packages, package body, functions >>no triggers >>no sequences (can you imagine... this came with V6) >>no ref constraints >>no 2-phase commit >>no snapshots, no snapshot logs >>no parallel server >>... >> >>can you imagine! and it was already the most powerful >>database server growing at >100% year over year (100% >>growth for 13 years in a row) >> >>I mean "can you imagine" SQLPLUS "was" ORACLEcan >>you in your wildest dreams imagine what this group >>would be like?... just SQLPLUS related issues "can >>you imagine";-) >> >>Keith >> >> >> >>__ >>Do You Yahoo!? >>LAUNCH - Your Yahoo! Music Experience >>http://launch.yahoo.com >> -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ora NT DBA 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: Schilling, Ben 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: 9i Release 2 features/fixes
Try this link: http://otn.oracle.com/products/ias/pdf/9iasr2newfeature.pdf Ben -Original Message- Robert Sent: Monday, May 06, 2002 3:14 PM To: Multiple recipients of list ORACLE-L I have been trying, like you wouldn't believe, to get a list of new features in 9iR2. I have run into stone wall after stone wall. I think there has been some internal confusion and debate over what to include in 9iR2, based on some of what I've heard. I've even heard that Logical Stand-by will not be in 9iR2, but I can not verify this. Looking hard, will report if I find anything. RF -Original Message- Sent: Monday, May 06, 2002 11:14 AM To: Multiple recipients of list ORACLE-L The big thing that I'm looking forward to is the logical standby database. This will allow you to apply logs between different versions of Oracle. Should allow us to drastically reduce downtime during upgrades. -Original Message- Sent: Friday, May 03, 2002 6:18 PM To: Multiple recipients of list ORACLE-L You can sure that Oid will be better - because lets face it - it couldn't have got any worse :-) --- "Jesse, Rich" <[EMAIL PROTECTED]> wrote: > Does anyone know of or have a list of new > features/fixes for Release 2 of > 9i? I can't find anything on oracle.com except XML > XML XML. > > Just wondering if OiD gets any better, I guess. :) > > TIA, > Rich Jesse System/Database > Administrator > [EMAIL PROTECTED] Quad/Tech > International, Sussex, WI USA > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: Jesse, Rich > 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). = Connor McDonald http://www.oracledba.co.uk http://www.oaktable.net "Some days you're the pigeon, some days you're the statue" __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= 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: Miller, Jay 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: Freeman, Robert 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 --
RE: Oracle IFS
Hi Patrice Document 182850.1 QuickStart Guide to installing 9iFS 9.0.1 recommends 1gig of RAM on a dual pentium 500mhz to support 50 users using all protocols "moderately". This document is dated Apr 5 of this year. So either they fixed it or they are stretching the truth. Can you expand on your experience? Ben -Original Message- Patrice J Sent: Monday, May 06, 2002 8:08 AM To: Multiple recipients of list ORACLE-L I don't know if Oracle fixed the iFS memory requirements, it used to be brutal. 2G per two protocols with two concurrent sessions, if I remember correctly. That adds up quickly. I asked during the Oracle Technology Day here, and was told that it still requires a massive amount of memory server-side. Less than before, but still requires much memory. I like the idea very much, indexing information like e-mails would prove invaluable in some organizations. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin & Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED] -Original Message- Sent: Friday, May 03, 2002 9:09 AM To: Multiple recipients of list ORACLE-L Hi All, Oracle iFS is, of course, much slower in standard operations, such as file copying, saving and retrieving, but... It has really great features for searching as well as more protocols to access files (smb, nfs, http, webdav, and more). Another nice feature is customized "smart" file system, where you can program it's behaviors such as presenting the same data in different formats as needed (dxf as bmp or jpg when user don't have dxf viewer, for example). It may be integrated well with Oracle Workflow. iFS implements "out of the box" file versioning and chek-in, check-out. All backup problems go to database backup. However, it is not so flexible as regular file backups - it's questionable to restore only one file from the past and so on. Samba is free. iFS is included free of charge in Oracle Server (both EE and SE). Samba works on *NIX. iFS works on both Windows NT and UNIX/LINUX. In other words, need a regular file system - go with Samba. ;) Regards. Alexandre Gorbatchev Oracle DBA/Developer, OCP Avermann Maschinenfabrik GmbH & Co. KG [EMAIL PROTECTED] +49 (0) 540 / 550 5177 - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Thursday, May 02, 2002 6:01 PM > > Samba on Linux has been a life saver. > > Users can map a network drive, that's nfs mounted on UNIX that's accessible > from the web. > > David A. Barbour > Oracle DBA, OCP > AISD > 512-414-1002 > > > > "Jack van > Zanen" To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > <[EMAIL PROTECTED] cc: > L> Subject: Oracle IFS > Sent by: > [EMAIL PROTECTED] > om > > > 05/02/2002 > 03:48 AM > Please respond > to ORACLE-L > > > > > > > Hi All, > > > We are looking for possible solutions to share files between Windows & > Unix. > And also store millions of little files that are now a backup nightmare. > > Does anybody have any experience with IFS (performance, possibilities, > pitfalls ) > > TIA > > Jack > > === > De informatie verzonden in dit e-mailbericht is vertrouwelijk en is > uitsluitend bestemd voor de geadresseerde. Openbaarmaking, > vermenigvuldiging, verspreiding en/of verstrekking van deze informatie aan > derden is, behoudens voorafgaande schriftelijke toestemming van Ernst & > Young, niet toegestaan. Ernst & Young staat niet in voor de juiste en > volledige overbrenging van de inhoud van een verzonden e-mailbericht, noch > voor tijdige ontvangst daarvan. Ernst & Young kan niet garanderen dat een > verzonden e-mailbericht vrij is van virussen, noch dat e-mailberichten > worden overgebracht zonder inbreuk of tussenkomst van onbevoegde derden. > > Indien bovenstaand e-mailbericht niet aan u is gericht, verzoeken wij u > vriendelijk doch dringend het e-mailbericht te retourneren aan de verzender > en het origineel en eventuele kopieën te verwijderen en te vernietigen. > > Ernst & Young hanteert bij de uitoefening van haar werkzaamheden algemene > voorwaarden, waarin een beperking van aansprakelijkheid is opgenomen. De > algemene voorw
RE: Two instances with same name on the same Server
Hi This could happen if you have Oracle installed twice on the box. The same SID could be started up from each of the binaries. Ben -Original Message- [EMAIL PROTECTED] Sent: Tuesday, April 30, 2002 5:48 PM To: Multiple recipients of list ORACLE-L Hello Folks, I was teaching DBA stuff to a newbie, and I had him play with an Oracle 7.3.4 instance on an old HP box. I was teaching him about oradebug, ipcs and how to associate shared memory segments with an Oracle Instance. After some time, he came back and said there were 2 Oracle instances with the same name running. I did a ps -ef|grep pmon and was indeed surprised to find two process with the same SID running. An ipcs showed two Oracle Id's. I connected to the instance, and shut it down. It now showed only one pmon process, which I was not able to connect to, and had to kill all the background process. He does not remember the exact sequence of steps that he did. I tried to retrace the steps from whatever he said, but to no avail. I brought up the instance, did an ipcsrm, and tried to bring up another instance, all to nothing. 7.3.4 is the only Oracle version installed on this box. Any thoughts on this? I am curious to know. Raj -- 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: 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).
export tables from sql Server to Oracle
Hi listers, Can someone tell me how import tables from SQLServer to Oracle. Thanks for your help, Ben __ Do You Yahoo!? Yahoo! Health - your guide to health and wellness http://health.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kader Ben 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).
Serious import problem (help!)
Title: Serious import problem (help!) Folks, I've been exporting data from the production db's every night for over a year. We use these exports to import into the test db's that we have setup in the office. Well, starting yesterday I am no longer able to import successfully into any of our 8.1.6 instances. The exp/imp are being done with the same version (Export file created by EXPORT:V08.01.06 via conventional path, Import: Release 8.1.6.0.0 - Production on Thu Apr 25 14:19:59 2000) and we have not upgraded Oracle (production or test) ever since it's been installed. Our exp files are around 5GB (on NTFS filesystem) when exported, I then gzip (switching to bzip2 soon) the files and ftp them off for unzipping and importing into another 8.1.6 w2k server. The thing that dazzles me is that nothing has changed except that we moved into a new office (new IP address space) this week. Were using WINS to resolve machine names (eg oradb2) and that's working fine (always has). 75% of the tables in Schema A load up fine, the other 25% in Schema A are random but seem to be breaking on the largest tables. These are the import errors I get on multiple instances and different DB machines, very strange. imp.exe system/%pass%@%dbname% FILE=%dmpfile% BUFFER=2000 COMMIT=Y LOG=import.log IGNORE=Y FROMUSER=%owners% TOUSER=%owners% . . importing table "CUSTOMER" IMP-00058: ORACLE error 3125 encountered ORA-03125: client-server protocol violation IMP-00018: partial import of previous table completed: 3718 rows imported . . importing table "ACCOUNT" IMP-00058: ORACLE error 1461 encountered ORA-01461: can bind a LONG value only for insert into a LONG column IMP-00018: partial import of previous table completed: 212793 rows imported . . importing table "AGING_LDC_TMP" IMP-00058: ORACLE error 3106 encountered ORA-03106: fatal two-task communication protocol error IMP-00018: partial import of previous table completed: 264180 rows imported . . importing table "BATCH_LOG" IMP-00058: ORACLE error 1461 encountered ORA-01461: can bind a LONG value only for insert into a LONG column IMP-00018: partial import of previous table completed: 723328 rows imported Any help would be appreciated! Ben. This e-mail communication and any attachments are confidential and intended only for the use of the designated recipients named above. If you are not the intended recipient, you are hereby notified that you have received this communication in error and that any review, disclosure, dissemination, or distribution of it or its contents is prohibited. If you have received this communication in error, please notify USPowerSolutions Corporation immediately by telephone at (617)547-3800 or via e-mail at [EMAIL PROTECTED] and destroy all copies of this communication and any attachments.
RE: Saving down time on Install
Jack, I asked this question last week. I got one reply saying that it was okay to install and build new databases with another version running in a different Oracle home (from Rachel I think). I assume she had tried it out but I don't know for sure. Ben -- 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).
SQLLDR core dumping
Hi I installed 9iAS 1.0.2.2.2 on Solaris 8. All went well except the Portal component failed. When I tried to re-run the opca (portal configuration assistant) it failed on a segmentation fault in SQLLDR. Oracle support seems to be stumped by this. Has anyone else run into this? Thanks, Ben Poels Queen's University -- 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).
Close instances while installing new versions or creating new databases
Hi The install guides that I have seen specify that you shut down all instances before any installations. Is it really necessary to close all instances and listeners on a server when you are: a)Installing a new version of Oracle in a new $ORACLE_HOME OR b)Creating a new database under the new $ORACLE_HOME What about when creating a new database under an existing $ORACLE_HOME which has open instances. Thanks. Ben -- 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).
Installing Discoverer4i with Oracle9iAS
Hi, I am having trouble with this install. First a warning. If you are installing this on Solaris get the 9iAS 1.0.2.2.2 version as the 1.0.2.2.1 version would not even start up the Discoverer install for me (and I did have PsuedoColor set on my emulator as it uses the old installer in motif mode). Anyway the Disco install says it worked but I cannot get it going. My locator.log is complaining about being unable to bind a preference object. I noticed one error in the pref.txt file - the IP address did not get set. After looking on Metalink it seems that the install makes a lot of mistakes in setting up parameter files. Has anyone successfully installed this who would like to share their pref.txt, jserv.properties, discoviewer.properties, etc. Thanks in advance, Ben == Ben Poels - Senior Technical Analyst - Queen's University at Kingston Phone: 613.533.2449 Fax: 613.533.2168 Email: [EMAIL PROTECTED] == -- 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).
Re: migrate from 8i to 9i
Thanks I'm thinking about this idea, Ben --- [EMAIL PROTECTED] wrote: > > I'm assuming that you're creating a 9i database on > the new machine when you > install Oracle. > > I find it useful to pre-create the tablespaces (and > users) on the new > database, rather than let the import do that. This > gives you more control > over where datafiles end up and do some clearup on > unneeded users, etc. > > > > > > Kader Ben > > Multiple recipients of list ORACLE-L > @yahoo.com> > <[EMAIL PROTECTED]> > Sent by: rootcc: > > Subject: > migrate from 8i to 9i > > > 04/09/2002 > > 03:18 PM > > Please > > respond to > > ORACLE-L > > > > > > > > > > Hi friends, > > I need your advise on the following question. I > have DB on 8i and I want create new one on another > machine with 9i. > I thought do the following steps: > > 1 - Install oracle 9i on a new machine > 2 - make full export of the 8i DB > 3 - import it on the new one (9i) > > So before I proceed I need your input. Am I correct > with these steps? There is something wrong? > > Many thanks for you, > > Kader > > ______ > Do You Yahoo!? > Yahoo! Tax Center - online filing with TurboTax > http://taxes.yahoo.com/ > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: Kader Ben > 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). __ Do You Yahoo!? Yahoo! Tax Center - online filing with TurboTax http://taxes.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kader Ben 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: Differences between Oracle JDBC thin and thick drivers
Hi I believe the difference is that the OCI drivers use SQL*Net or NET8 or whatever they call it now, whereas the thin driver does not require SQL*Net on the client machine. Ben Poels Sr. Technical Analyst Queen's University -Original Message- Avrami Sent: Tuesday, April 09, 2002 4:29 PM To: Multiple recipients of list ORACLE-L Hello all, I have a question concerning the Oracle JDBC thin vs. thick drivers and how they might affect operations from an application perspective. We're in a Solais 8/Oracle 8.1.7.2 environment. We have several applications on several servers connecting to the Oracle database. For redundancy, we're looking into setting up TAF (transparent application failover). Currently, some of our apps use the Oracle JDBC thin drivers to talk to the database, with a connection string that like this: jdbc:oracle:thin:@host:port:ORACLE_SID In a disaster recovery mode, where we would switch the database from one server to another, the host name in the above string would become invalid. That means we have to shut down our application servers and restart them with an updated string. Using the Oracle OCI (thick) driver though, allows us to connect to a Net8 service instead of a specific server: jdbc:oracle:oci8:@NET8_SERVICE_NAME Coupled with the FAILOVER=ON option configured in Net8, it is then possible to direct a connection from the first server to the failover database on another server. This is exactly what we would like to do. My question is, from an application perspective, how is the Oracle thick driver different from the thin driver? If everything else is "equal" (i.e. the thick driver is compatible with the app servers) would there be something within the the thick/OCI driver that could limit functionality vs. the thin driver? My understand, which obviously is sketchy, is that the thick driver is a superset of the thin driver. If this is the case, and for example if all database connections were handled through a configuration file with the above OCI connection string, then theoretically the thick driver should work. If anyone has any info on this that they can share, it would be greatly appreciated. Thanks, Lou Avrami -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Louis Avrami 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).
RE: migrate from 8i to 9i
Thanks guys for your replies' My DB is no big about 2.5Gb. Robert, both DB's (8i and 9i ) are on windows 2000. Ben --- "Freeman, Robert " <[EMAIL PROTECTED]> wrote: > I (perhaps improperly) assumed that by "another > machine" he meant another > platform. In retrospect, this might not have been > the case > > RF > > -Original Message- > Sent: Tuesday, April 09, 2002 3:44 PM > To: Multiple recipients of list ORACLE-L > > > Ben - How large is your database and how long can > you have it unavailable to > production? If your database isn't large and your > users can be off, for > example, a weekend, then the export/import method is > simple and easy. > Dennis Williams > DBA > Lifetouch, Inc. > [EMAIL PROTECTED] > > > -Original Message- > Sent: Tuesday, April 09, 2002 2:19 PM > To: Multiple recipients of list ORACLE-L > > > Hi friends, > > I need your advise on the following question. I > have DB on 8i and I want create new one on another > machine with 9i. > I thought do the following steps: > > 1 - Install oracle 9i on a new machine > 2 - make full export of the 8i DB > 3 - import it on the new one (9i) > > So before I proceed I need your input. Am I correct > with these steps? There is something wrong? > > Many thanks for you, > > Kader > > __ > Do You Yahoo!? > Yahoo! Tax Center - online filing with TurboTax > http://taxes.yahoo.com/ > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: Kader Ben > 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: DENNIS WILLIAMS > 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: Freeman, Robert > 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!? Yahoo! Tax Center - online filing with TurboTax http://taxes.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kader Ben 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).
migrate from 8i to 9i
Hi friends, I need your advise on the following question. I have DB on 8i and I want create new one on another machine with 9i. I thought do the following steps: 1 - Install oracle 9i on a new machine 2 - make full export of the 8i DB 3 - import it on the new one (9i) So before I proceed I need your input. Am I correct with these steps? There is something wrong? Many thanks for you, Kader __ Do You Yahoo!? Yahoo! Tax Center - online filing with TurboTax http://taxes.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kader Ben INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: How to use Email server in 9iAS.
Hi What couldn't you download from OTN and why. OTN has the following manuals which I downloaded - Planning Guide, Installation Guide, Administration Guide and Developers Guide. I toyed with the idea of setting up the Email Server for mass mailings (not spam!) with personalized text from an Oracle database. However I have not had a chance to pursue it yet and it does not seem to be very widely used. Right now I am just using SendMail and utl_smtp to solve my problem. Ben -Original Message- [EMAIL PROTECTED] Sent: Wednesday, April 03, 2002 11:53 PM To: Multiple recipients of list ORACLE-L Hi I wish to install Email server in 9iAS. but i don't know how to do that. i try to download the same from OTN but unable to get it. so let me know how to do and configure the same Rgds Ayyappan.S This communication contains information, which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s), please note that any distribution, printing, copying or use of this communication or the information in it is strictly prohibited. If you have received this communication in error, please notify the sender immediately and then destroy any copies of it. Visit us @ www.ssiworldwide.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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).
RE: Production Oracle DBA Needed in Rochester, Minnesota
e environment. > *Strong analytical and problem solving skills. > *Demonstrated proficiency with the HP or SUN Unix operating system. > *Replication is not required but a big plus. > * Must be a U.S. citizen or perm. resident with excellent English. > > For immediate consideration, please email your resume as an attachment > to: > > OraStaff, Inc. > Email: [EMAIL PROTECTED] > Phone: 1-800-549-8502. (*Please do not call if you need sponsorship) > Please Use Job Code: One/DBA/Rochester/Diane > > I pay referral fees. > So please contact me if you know of anyone who would be > qualified/interested > in the > posiition described above- if it is not a match for your skills. > Thanks, > Bill Law > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: OraStaff > 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: Johnston, Tim > 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: Koivu, Lisa 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: Schilling, Ben 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: Hundreds of schemas in one instance?
Hi The assumption is that every user of this system will have totally unique requirements. There will be no data sharing and no commonality of purpose. As far as alternatives I am not even thinking about multiple instances. Other alternatives include - many schemas and one tablespace, or many schemas and an arbitrary number of tablespaces, or an arbitrary number of schemas matched to an arbitrary number of tablespaces, or one schema for all users using fine grained access control (thanks for the idea Jack it sounds quite useful). Peter: All users would be equal and no critical systems will be housed on this instance, but backup and recovery is definitely complicated by having so many data files and tablespaces. By the "opposite direction" do you mean only one tablespace. Jared: The benefit is isolation. As much as possible keep the users from affecting each other. Performance effects are unavoidable but separate tablespaces would keep one user from gobbling up all the available disk space. Will definitely have to watch out for the data dictionary filling up the SYSTEM tablespace and bringing everything to a screeching halt. Ben -Original Message- Sent: Wednesday, March 06, 2002 1:29 PM To: Multiple recipients of list ORACLE-L Hi Our university wants to set up a server that will provide groups on campus with a standard set of services for web hosting, data collection or whatever they want to do. As much as possible each user should have their own isolated chunk of the server. An Oracle database will sit in the background to provide whatever database services they need. My thought is to go with one instance with a unique schema, including separate tablespaces/datafiles, for each user. Some of the pros for this are: - easy set up for new users - easy software upgrades - simplified tuning, backups, monitoring, auditing - user isolation, especially disk space usage - multiple instances would use far more memory Some cons are: - everyone must use the same release of the software - database down time affects everyone - might run into system maximums, for example max. number of datafiles - an enormous SYSTEM tablespace Has anyone had to this kind of thing? Any comments or suggestions? TIA, Ben ====== Ben Poels - Senior Technical Analyst - Queen's University at Kingston Phone: 613.533.2449 Fax: 613.533.2168 Email: [EMAIL PROTECTED] == -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS 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). <>
RE: Hundreds of schemas in one instance?
Hi The assumption is that every user of this system will have totally unique requirements. There will be no data sharing and no commonality of purpose. As far as alternatives I am not even thinking about multiple instances. Other alternatives include - many schemas and one tablespace, or many schemas and an arbitrary number of tablespaces, or an arbitrary number of schemas matched to an arbitrary number of tablespaces, or one schema for all users using fine grained access control (thanks for the idea Jack it sounds quite useful). Peter: All users would be equal and no critical systems will be housed on this instance, but backup and recovery is definitely complicated by having so many data files and tablespaces. By the "opposite direction" do you mean only one tablespace. Jared: The benefit is isolation. As much as possible keep the users from affecting each other. Performance effects are unavoidable but separate tablespaces would keep one user from gobbling up all the available disk space. Will definitely have to watch out for the data dictionary filling up the SYSTEM tablespace and bringing everything to a screeching halt. Ben -Original Message- Sent: Wednesday, March 06, 2002 1:29 PM To: Multiple recipients of list ORACLE-L Hi Our university wants to set up a server that will provide groups on campus with a standard set of services for web hosting, data collection or whatever they want to do. As much as possible each user should have their own isolated chunk of the server. An Oracle database will sit in the background to provide whatever database services they need. My thought is to go with one instance with a unique schema, including separate tablespaces/datafiles, for each user. Some of the pros for this are: - easy set up for new users - easy software upgrades - simplified tuning, backups, monitoring, auditing - user isolation, especially disk space usage - multiple instances would use far more memory Some cons are: - everyone must use the same release of the software - database down time affects everyone - might run into system maximums, for example max. number of datafiles - an enormous SYSTEM tablespace Has anyone had to this kind of thing? Any comments or suggestions? TIA, Ben ====== Ben Poels - Senior Technical Analyst - Queen's University at Kingston Phone: 613.533.2449 Fax: 613.533.2168 Email: [EMAIL PROTECTED] == -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS 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).
Hundreds of schemas in one instance?
Hi Our university wants to set up a server that will provide groups on campus with a standard set of services for web hosting, data collection or whatever they want to do. As much as possible each user should have their own isolated chunk of the server. An Oracle database will sit in the background to provide whatever database services they need. My thought is to go with one instance with a unique schema, including separate tablespaces/datafiles, for each user. Some of the pros for this are: - easy set up for new users - easy software upgrades - simplified tuning, backups, monitoring, auditing - user isolation, especially disk space usage - multiple instances would use far more memory Some cons are: - everyone must use the same release of the software - database down time affects everyone - might run into system maximums, for example max. number of datafiles - an enormous SYSTEM tablespace Has anyone had to this kind of thing? Any comments or suggestions? TIA, Ben == Ben Poels - Senior Technical Analyst - Queen's University at Kingston Phone: 613.533.2449 Fax: 613.533.2168 Email: [EMAIL PROTECTED] == -- 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).
SSL and non-SSL requests on same Apache server in 9iAS?
Hi, I want to host SSL and non-SSL requests on one physical server running one 9iAS. After installing 9iAS the httpd.conf file specifies by default that it is listening on port . Later on in httpd.conf it has an SSL directive that says it's listening on port 80 and 443. Does this mean that this one Apache server can service non-SSL requests on and SSL requests on 443 at the same time? There is a document on Metalink(135231.1) that describes how to run two Apache servers in one 9iAS home. Again what is not clear to me is whether or not one could be handling SSL and the other non-SSL. Anyone have any recommendations on how to do this? I may also be asked to host 40-bit and 128-bit encryption on the same web site. Again any recommendations? Thanks. ====== Ben Poels - Senior Technical Analyst - Queen's University at Kingston Phone: 613.533.2449 Fax: 613.533.2168 Email: [EMAIL PROTECTED] == -- 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).
RE: FW: Expiration of your subscription to the ORACLE-L list
There is another oracle list which is still running out of SUNYSB.EDU . -Original Message- Sent: Friday, March 01, 2002 3:18 PM To: Multiple recipients of list ORACLE-L Nope, and since the list is supported out of Fatcity it would appear to be a hoax. Reply Separator Author: Hamid Alavi <[EMAIL PROTECTED]> Date: 3/1/2002 10:48 AM List, I want to know if any of you received a message like this for re-subscribe??? -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Friday, March 01, 2002 3:00 AM To: Hamid Alavi Fri, 1 Mar 2002 06:00:01 Your subscription to the ORACLE-L list has expired and you have failed to confirm it in the 7 day delay that you had been granted. You have therefore been automatically removed from the list. You can re-subscribe to the list, if you want to, by sending the following command to [EMAIL PROTECTED]: SUBscribe ORACLE-L The information contained in this message and any attachments is intended only for the use of the individual or entity to which it is addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from disclosure under applicable law. If you have received this message in error, you are prohibited from copying, distributing, or using the information. Please contact the sender immediately by return e-mail and delete the original message from your system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hamid Alavi 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: Schilling, Ben 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).
command history in SQLPLUS not working on Solaris
Title: command history in SQLPLUS not working on Solaris Does anybody know how to get the up-arrow command history working in sqlplus running on Solaris? I've tried running sqlplus under /bin/ksh and /user/local/bin/tcsh and the results are the same as shown below. SQL> select sysdate from dual; SYSDATE - 01-MAR-02 SQL> ^[[A I'm used to sqlplus under the W2K command prompt, it just works perfectly in that environment. Thanks, Ben Benjamin Conrad Sr. Network Administrator USPowerSolutions mailto:[EMAIL PROTECTED] 617.547.3800 x195 This e-mail communication and any attachments are confidential and intended only for the use of the designated recipients named above. If you are not the intended recipient, you are hereby notified that you have received this communication in error and that any review, disclosure, dissemination, or distribution of it or its contents is prohibited. If you have received this communication in error, please notify USPowerSolutions Corporation immediately by telephone at (617)547-3800 or via e-mail at [EMAIL PROTECTED] and destroy all copies of this communication and any attachments.
RE: Rollback Segments
Bjørn - I remember the joys of Version 3. There was also the fun screen generator program where you had to decide where everything was going by using its character position and you had to enter that by hand. The first pass at most screens was interesting. One of the users referred to UFI as "User Surly Interface" Ben Schilling -Original Message- Sent: Tuesday, February 19, 2002 1:19 PM To: Multiple recipients of list ORACLE-L Bjorn, you old coot, you've got me beat. I do remember the UFI prompt though... User Friendly Interface... and the "real geeks" would program their own SQL*Plus environment using HLI (now OCI) with the OROL option which would allow the rollback of a single statement rather than a whole transaction. Now, in my day, we had fire but we had to make our own coal and we kept warm on the hides of old terminals that used to roam the plains. What were things like in your day? Bambi. -Original Message- Sent: Tuesday, February 19, 2002 5:23 AM To: Multiple recipients of list ORACLE-L There must be somebody beside myself remembering version 3, which did not have read consistency - the great new feature of version 4. In 3, doing UFI> insert into emp select * from emp; would cause anything from having 28 rows in emp till having and endless loop in the kernel only finishing when your database file ran full... Yep - we are some old bitter men around here... /Bjørn. On Tuesday 19 February 2002 06:43, you wrote: > I remember the BI.ORA (Before-Image) file, IOR and ODS in Oracle 5. > > Hemant K Chitale > Principal DBA > Chartered Semiconductor Manufacturing Ltd > > > Rachel Carmichael <[EMAIL PROTECTED]> 19/02/2002 06:18 AM > Sent by: [EMAIL PROTECTED] > > Please respond to ORACLE-L > > To: Multiple recipients of list ORACLE-L > <[EMAIL PROTECTED]> cc: (bcc: CHITALE Hemant Krishnarao/IT/CHRT/ST > Group) Subject: RE: Rollback Segments > > > > > > > > > UFI no, but the rest... that's where I started in Oracle -- version 5 > > --- "Conboy, Jim" <[EMAIL PROTECTED]> wrote: > > Holy cow Mladen, what a memory! > > > > Does anybody else remember (or admit to) using UFI? > > > > Jim > > > > ** > > > > ...does anybody still remember VAX/VMS, ORACLE$BI, IOR and ODT?... > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: Conboy, Jim > > 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!? > Yahoo! Sports - Coverage of the 2002 Olympic Games > http://sports.yahoo.com > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Rachel Carmichael > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Bj=F8rn=20Engsig?= 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: Bellows, Bambi
RE: Oracle 9i installation Java RunTime Environment was not found.
Hi The history for this question is incomplete but I will add this thought anyway. When installing on AIX boxes Oracle will not install java due to license restrictions. I am not sure if your error is during installation or after. The HTTP server may not work because there was no jre or jdk in $ORACLE_HOME/Apache/. I had to put a soft link in to my /usr/jdk where I had installed java. Then everything worked. Hope this helps. Ben -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Neil KhotSent: Thursday, January 24, 2002 2:49 PMTo: Multiple recipients of list ORACLE-LSubject: Re: Oracle 9i installation Java RunTime Environment was not found. Hello Onder, I have JRE Installed here is what I get $: java -versionjava version "1.3.0_02"Java(TM) 2 Runtime Environment, Standard Edition (build 1.3.0_02)Java HotSpot(TM) Client VM (build 1.3.0_02, mixed mode) There fore Java is installed. I think this might have something to do with Oracle not able to create /tmp/Orainstall/jre/bin/jre on its own even thought there are enough permission and disk space. Any help is appreciated Neil Khot - Original Message - From: E.Onder Kokturk To: Multiple recipients of list ORACLE-L Sent: Thursday, January 24, 2002 1:10 AM Subject: Re: Oracle 9i installation Java RunTime Environment was not found. >Dear Friends, I am trying to install Oracle 9i on Sun Solaris 5.8.But while installting i get the following error hi, you need JRE for installation. I think your system didn't installed or have a problem. You can download , install and try to install Oracle again. -Onder Kokturk
RE: SCOTT/TIGER
Ed Scott was one of the founders of Oracle and that was a sign on he liked to use. -Original Message- Sent: Wednesday, January 23, 2002 11:45 AM To: Multiple recipients of list ORACLE-L Anyone out there know the history of this? -- 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: 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).
Import taking up too much room with local managed tablespace
Title: Import taking up too much room with local managed tablespace Hi, I created a tablespaces in a test database to be locally managed with an extent size of 20544K. A normal database import usually will fill a datafile with 5.8GB of data (on a dictionary managed tblspace) but with the local it has run out of space with the (2) 6GB files that I allocated to it. I noticed that during the import the datafiles were filling up quite fast (too fast). Data file 1 was filling up about 4x as fast as data file 2 during the import. Why did this happen? FYI, I have the compress=y set on the export if that makes any difference. Thanks, Ben. Benjamin Conrad Sr. Network Administrator USPowerSolutions mailto:[EMAIL PROTECTED] 617.547.3800 x195 This e-mail communication and any attachments are confidential and intended only for the use of the designated recipients named above. If you are not the intended recipient, you are hereby notified that you have received this communication in error and that any review, disclosure, dissemination, or distribution of it or its contents is prohibited. If you have received this communication in error, please notify USPowerSolutions Corporation immediately by telephone at (617)547-3800 or via e-mail at [EMAIL PROTECTED] and destroy all copies of this communication and any attachments.
Oracle8i and the Jserv demos
Hi I have installed Oracle 8.1.7.0 on an AIX 4.3 box and the Jserv demos do not work. I looked at the jserv.log and it seems to not be finding the java executables. I downloaded Java.rte for AIX from IBM and put it in the $ORACLE_HOME/Apache/jdk/bin directory but it still doesn't work. I am not too familiar with AIX so can anyone explain to me how and where to install java on an AIX box. I would open a tar but we renewed our licenses and ever since I have been unable to get registered properly with MetaLink. Thanks, Ben -- 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).
RE: Oracle8i and LDAP
Hi Well I have partially answered my own question. I see in the Net8 manual that it can use an LDAP server to replace Oracle Names and lookup connect strings for service names. However I am still not sure if Oracle8i can authenticate a username and password in an LDAP. If it can, does anyone know how it queries the LDAP. What I really want to know is whether Oracle has any specific requirements that an LDAP server would need to be able to handle. This will help us choose an Oracle compatible LDAP. I have found a chart indicating that OID is included with Oracle9iAS EE. -Original Message- Sent: Tuesday, January 15, 2002 4:02 PM To: Multiple recipients of list ORACLE-L Hi Does Oracle8i come with any built in LDAP functions or do you have to write your own functions to search and update an LDAP directory? Does the Oracle Internet Directory come with Oracle8i or is purchased separately? Thanks. Ben -- 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). -- 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).
Oracle8i and LDAP
Hi Does Oracle8i come with any built in LDAP functions or do you have to write your own functions to search and update an LDAP directory? Does the Oracle Internet Directory come with Oracle8i or is purchased separately? Thanks. Ben -- 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).
Oracle and LDAP servers
Hi In reading MetaLink I have come up with the following list of LDAP servers that are certified for use with Oracle. in 8.1.7 - OID, NDS, Active Directories and iPlanet in 9i - OID, Active Directories Can anyone update this? When they say an LDAP is certified for use with Oracle does this mean that the Oracle Internet Directory C API and PL/SQL API(dbms_ldap) will work against them? Or does it just mean that the OID can sync to it. My real question is if I want to use iPlanet or some such beast how do I identify, and authorize Oracle database users? Thanks, Ben == Ben Poels - Senior Technical Analyst - Queen's University at Kingston Phone: 613.533.2449 Fax: 613.533.2168 Email: [EMAIL PROTECTED] == -- 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).
Oracle9iAS and proxy servers
Hi I have used Oracle8i but I am new to the Oracle9iAS world. I would like to set up a proxy server outside a firewall which routes to an Oracle9iAS server inside the firewall. Can the proxy server just be a basic Apache install, or are their benefits/requirements to using 9iAS (maybe the core or minimal edition) as the proxy? Can anyone point me at some documentation on this topic, as nothing came up on my MetaLink search except numerous references to the "Proxy log on failed" problem. Thanks, Ben ====== Ben Poels - Senior Technical Analyst - Queen's University at Kingston Phone: 613.533.2449 Fax: 613.533.2168 Email: [EMAIL PROTECTED] == -- 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).
RE: Mabye OT: Was Re: Different clocks for different instances.
Oracle uses the original start date of the Gregorian calendar in October
1582:
1* select to_date('04-OCT-1582'), to_date('04-OCT-1582')+1 from dual
devp> /
TO_DATE('04-OCT-1582 TO_DATE('04-OCT-1582
04-OCT-1582 00:00:00 15-OCT-1582 00:00:00
Ben Schilling
Telecomm Manager
Office of the Commissioner of Insurance
608-266-1615 [EMAIL PROTECTED]
-Original Message-
Sent: Wednesday, December 19, 2001 11:09 AM
To: Multiple recipients of list ORACLE-L
Well I say,
that is also the case on Tru64 as well.
How pedantic is UNIX ??
-Original Message-
Sent: 19 December 2001 16:16
To: Multiple recipients of list ORACLE-L
Speaking of the system clock, here's something interesting that I stumbled
across a few years back...
Background: For those of you who may not know, the Julian calendar was
abandoned by England, in favor of the Gregorian calendar, in 1752 because of
date discrepancies. To facilitate this, September 3 - 13 were eliminated.
This is actually reflected in UNIX (well, Solaris anyway) by issuing the
'cal 1752' command and looking at the month of September:
JulAugSep
S M Tu W Th F SS M Tu W Th F SS M Tu W Th F S
1 2 3 4 1 1 2 14 15 16
5 6 7 8 9 10 112 3 4 5 6 7 8 17 18 19 20 21 22 23
12 13 14 15 16 17 189 10 11 12 13 14 15 24 25 26 27 28 29 30
19 20 21 22 23 24 25 16 17 18 19 20 21 22
26 27 28 29 30 31 23 24 25 26 27 28 29
More info. on why the switch over occurred is available at
http://www.bicknell.net/books/pc1981/p_calender.htm
<http://www.bicknell.net/books/pc1981/p_calender.htm> , for those of you
with morbid curiosity.
Anyway - I was doing some Y2K testing a few years back, and playing with
NLS_DATE_FORMAT queries when I learned this little tidbit. I decided to
test the Oracle date formats because - hey - they'll be okay because they're
based on Unix, right?
Wrong: Issue the following query:
select sysdate
,add_months(sysdate,-2988)
,add_months(sysdate,-2988) - 10
from dual;
And see the following results:
SYSDATE ADD_MONTHS(SYSDATE,- ADD_MONTHS(SYSDATE,-
19-DEC-2001 10:07:02 19-DEC-1752 10:07:02 09-DEC-1752 10:07:02
The third column represents a date which, technically, does not exist. : )
Brian
Kimberly Smith wrote:
Oracle uses the system clock. So I would have to say no.
-Original Message-
Pollard
Sent: Tuesday, December 18, 2001 6:50 PM
To: Multiple recipients of list ORACLE-L
Gooday Oraclers,
is it possible to have different instances, on the same dB server,
operating with different clocks - ie different date/times?
Environment: Compaq-Digital Tru64 Unix, Oracle 8.0.6, DS20
---
Kevin Pollard | PODBA (Pretend Oracle DBA)
mailto:[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> |
Administrative Systems Unit
Phone:+61 (02) 6620 3969 | Southern Cross University
FAX:+61 (02) 6626 9122 | P.O. Box 157
Room: R1-40a | Lismore NSW 2480, Australia
http://staff.scu.edu.au/asu/index.html
<http://staff.scu.edu.au/asu/index.html>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
<http://www.orafaq.com>
--
Author: Kevin Pollard
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
<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).
--
--
| Brian McGraw -- Oracle DBA |
| Central Alabama Oracle Users Group |
|
Oracle client compatibility with Windows XP
Hi According to Metalink note 161546.1 you need at least the 9.0.1 Oracle client for Windows XP. We are currently using the 8.1.7 client to go against 8.1.7 databases and 7.3.4 databases. Does anyone know of any issues when you use the 9 client against 7.3.4 databases? Thanks, Ben -- 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).
No Subject
Hi List, I have a question regarding server requirements(computer) If any of you have any Idea or experience It would be nice to respond, Thanks in advance all of you. My question is, I have a very large database that have more than 300 tables part of them have more than 50,000,000 records. Can someone of you give me a specification of a server for that? Thanks in advance again, Alon -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alon Ben-Zvi 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).
import problem
hi list, I have a problem when I try to do import, sometimes the tables that have p.k. using index are created only with the index and not with the p.k. Do you have any suggestion? thanks in advance Alon -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alon Ben-Zvi 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).
Session marked for kill
** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Arn Klammer 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: Jenkins, Michael 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: Jenkins, Michael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jenkins, Michael 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: Alon Ben-Zvi 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, sen
Java
Hi Do you know what is mean: ORA-29547 Java system class not available: oracle/aurora/rdbms/Compiler Thanks
Java
Hi Do you know what is meen: ORA-29547 Java system class not available: oracle/aurora/rdbms/Compiler Thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alon Ben-Zvi 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: Latch 'parallel query qref latch'
Jon, Thanks for the email. My next question is fairly obvious...I'm getting a "lot" of waits on this latch (up to 5% of all waits) - how do I tune it ? (We've got a pretty typical environment here, a few big tables with parallel degree 4, on a 2 cpu box with 2G of RAM, and only a couple of end users doing big queries)... Any guidelines (from anybody) would be much appreciated... TIA Ben >From: "Jon Walthour" <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >Subject: RE: Latch 'parallel query qref latch' >Date: Thu, 14 Jun 2001 13:01:56 -0800 > > > >Ben: > >The qref latch is obtained for each Parallel Query process. It >is acquired before the queue buffers can be manipulated so that >communication can take place between the various slave processes. >The latch is acquired for putting messages into the buffer. You >will generally see lots of misses for this latch since it is >acquired with a nowait option. > >Jon Walthour, OCDBA >Oracle DBA >Computer Horizons >Cincinnati, Ohio > > >--- Original Message --- > >From: "Ben Jones" <[EMAIL PROTECTED]> > >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > >Date: 6/14/01 1:56:36 PM > > > > >Does anyone know what causes waits on this latch ? > > > >Thanks > >Ben > >_____ > >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: Ben Jones > > 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: Jon Walthour > 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 Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ben Jones 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).
Latch 'parallel query qref latch'
Does anyone know what causes waits on this latch ? Thanks Ben _ 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: Ben Jones 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).
skipping the java.sh step in database create
Hi, If you are not using anything to do with Java is it then safe to skip running the java.sh script that dbassist creates during database creation in Oracle 8.1.7? This step takes forever and uses a lot of System tablespace. 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).
RE: OT : Sinclair was RE: Metalink Again
There is still have at least one Sinclair gas station left. It's near the intersection of Interstate 90 and U.S. Highway 151 in Madison Wisconsin. -Original Message- Sent: Wednesday, April 04, 2001 5:27 PM To: Multiple recipients of list ORACLE-L I thought it was a green dinosaur on their signs, maybe they were just faded. Brian L. Anderson Flunky/SA/DBA/DERT Darton College [EMAIL PROTECTED] > And I thought it was an old oil company. Their gas station > symbol was a > dinosaur (not to be confused with "put a tiger in your > tank"). I vaguely > recall the Sinclair exhibit at the 1967 World's Fair, and I > still have a > blue plastic model of one of their dinosaurs. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Anderson, Brian 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: Schilling, Ben INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: OT -- Friday recipe
Very rough Metric equivalents: 1 pound = 0.5 kilogram (a bit high) 1.5 cup = 360 milliliters (also a bit high) 325 degrees F = 163 degrees C -Original Message- Sent: Friday, March 30, 2001 7:26 AM To: Multiple recipients of list ORACLE-L You are truly a goddess. Thanks!!! Rachel Carmichael wrote: > > Here goes.. > > Shortbread cookies > > Ingredients: > > 1 pound sweet butter > 1.5 cups sugar > 2 egg yolks > 5 cups flour > > 1. Cream butter until soft and smooth. Gradually beat in sugar until light > and fluffy. beat in egg yolks. > > 2. Gradually add flour until thoroughly blended. > > 3. Knead in bowl for 1 minute. > > 4. Pat dough into a 9x13" pan, making it 1/2" thick > > 5. Score into squares with a fork. > > 6. Bake 20-30 minutes in a preheated 325 oven. > > I've found that I have to split the cookies and bake them again until they > are golden brown... yummy > > Rachel > __ Dwayne Cox DBA, Development Dept. Info Tech, Inc. [EMAIL PROTECTED] http://www.infotech.com ___ The opinions expressed are the author's own unless otherwise stated -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dwayne Cox 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: Schilling, Ben 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: New born DBA.....
Here is a quick list: Daily checks - Oracle Alert file logs - system resources - backups - archive logs - error logs Weekly checks - free space in Tablespaces, Tables, Indexes and Clusters Monthly checks - fragmentation in Tables, Indexes and Clusters Ben Poels Queen's University -Original Message- Xing Sent: Tuesday, March 27, 2001 7:46 PM To: Multiple recipients of list ORACLE-L Hi guys, I am a new DBA, can you please tell me what are the common task list as DBA for Oracle8i on Solaris 7. I mean things that I should do and check regularly. I know backup is one of them. Thank you Sinardy Soon be OCP certified -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinardy Xing INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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).
RE: Svrmgrl "connect internal" asks for password??
If you want to search for that document you need to enter 69642.1 for the document no. search on the advanced search page. Ben Poels Queen's University -Original Message- Sent: Thursday, March 08, 2001 9:01 AM To: Multiple recipients of list ORACLE-L If you have access to Metalink there is a good article there (Doc. 69642 or just put your subject in search), which lists all different causes why this might happen audit dir being full is one of them, ORACLE_HOME and/or SID set inapropriatelly, and a number of others. Djordje - Original Message - To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent: Wednesday, March 07, 2001 1:06 PM > Try looking in $ORACLE_HOME/rdbms/audit directory. If this directory is > full, it can not create the .aud file to log that someone is using svrmgrl and > will > ask for password. > > Terry > > "Fowler, Kenneth R" wrote: > > > List, > > > > I have an installation of Oracle 8.1.6 on a DBA test server where svrmgrl > > "connect internal" seems to want a password... > > > > Sun Microsystems Inc. SunOS 5.8 Generic February 2000 > > > > Configured oracle environment aliases... > > > > Alias SID Oracle Home > > - --- --- > > dba816dba816/Volumes/app/oracle/product/8.1.6 > > dba817dba817/Volumes/app/oracle/product/8.1.7 > > > > $ id > > uid=301(oracle) gid=300(dba) > > $ groups > > dba > > $ env | grep ORACLE > > ORACLE_BASE=/Volumes/app/oracle > > $ dba816 > > dba816 $ env | grep ORACLE > > ORACLE_BASE=/Volumes/app/oracle > > ORACLE_SID=dba816 > > ORACLE_HOME=/Volumes/app/oracle/product/8.1.6 > > dba816 $ cdcreate > > /Volumes/app/oracle/admin/dba816/create > > dba816 $ svrmgrl > > > > Oracle Server Manager Release 3.1.6.0.0 - Production > > > > Copyright (c) 1997, 1999, Oracle Corporation. All Rights Reserved. > > > > Oracle8i Enterprise Edition Release 8.1.6.2.0 - Production > > With the Partitioning option > > JServer Release 8.1.6.2.0 - Production > > > > SVRMGR> connect internal; > > Password: > > Password: > > ORA-01031: insufficient privileges > > SVRMGR> ^D > > Server Manager complete. > > dba816 $ dba817 > > dba817 $ env | grep ORACLE > > ORACLE_BASE=/Volumes/app/oracle > > ORACLE_SID=dba817 > > ORACLE_HOME=/Volumes/app/oracle/product/8.1.7 > > dba817 $ cdcreate > > /Volumes/app/oracle/admin/dba817/create > > dba817 $ svrmgrl > > > > Oracle Server Manager Release 3.1.7.0.0 - Production > > > > Copyright (c) 1997, 1999, Oracle Corporation. All Rights Reserved. > > > > Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production > > With the Partitioning option > > JServer Release 8.1.7.0.0 - Production > > > > SVRMGR> connect internal; > > Connected. > > SVRMGR> ^D > > Server Manager complete. > > > > I know that the usual reason for this is that the account running svrmgrl is > > not a member of the appropriate unix group (usually "dba" or as specified at > > installation time) but this is not the case here. On this server I have > > Oracle 8.1.6 (Home = /Volumes/app/oracle/product/8.1.6) and Oracle 8.1.7 > > (Home = /Volumes/app/oracle/product/8.1.7). My login script sets up aliases > > for each SID listed in /var/opt/oracle/oratab. These aliases use the oraenv > > script with environment variable ORAENV_ASK=NO to set appropriate values for > > ORACLE_SID, ORACLE_HOME and PATH etc. Other than that, the environment is > > exactly the same regardless of what SID I switch to (see log above). > > However "connect internal" asks for a password for Oracle 8.1.6 but does not > > ask for one for Oracle 8.1.7. I am pretty sure that I specified that the > > group name be "dba" for 8.1.6 and 8.1.7 so that should not be the issue. > > > > Can anybody give me some pointers of other things to look at to try and > > resolve the problem??? > > > > Thanks, > > Ken > > _ > > Clinical and Regulatory Informatics - Groton/New London > > Coordinator, Business and Technical Services > > Tel: (860) 732-0026Fax: (860) 715-8346 > > Email: [EMAIL PROTECTED] > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: Fowler, Kenneth R > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > > San Diego,
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).
Can Oracle7 and Oracle8 co-exist?
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).
final word on 8.1.7 install and java?
Hi, I did not really see a comprehensive answer on the java questions involving 8.1.7 installs. I installed 8.1.7 on AIX 4.3.2 and the 1.1.8 jre was installed. The install asked for a location for the JDK. I just created an empty /opt/java directory with another telnet session, hit continue and it happily carried on. I think I just have to install JDK in this directory now and all will be well. Is this true? Ben -- 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).
RE: Off Topic: How to set up a unix job in cron?
Hi, Wouldn't: 0 * * * * yourjobpath/yourjobscript be simpler Ben -Original Message- Sent: Monday, February 12, 2001 12:00 AM To: Multiple recipients of list ORACLE-L 0 0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23 * * * YourJobPath/YourJobScript Djordje - Original Message - To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent: Sunday, February 11, 2001 10:10 PM > Hello fellas, > > Could any one please tell me how to set up a job (a unix shell script) as a cron job, so that it runs every 1 hour every day? The platforms is aix 4.33 and also Solaris 8 and also HP 11. > > Thanks and Regards, > > 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). -- 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).
