Re: cpu utilization on solaris

[Jared Still]

The advice on running 'top' still applies.

Run it to see what your CPU intensive processes are.

Jared


On Wednesday 23 May 2001 22:00, Nihar wrote:
> No jared it's not the case there are very few shadow process running and
> non of them is cpu intensive.Basically it's one dot come data base so in my
> script is design such a way that when user exit from the site session
> disconnects. Is there any other way around?
>
> thanks and regards
>
> -Nihar
>
> -Original Message-
> Sent: Thursday, May 24, 2001 8:05 AM
> To: Multiple recipients of list ORACLE-L
>
>
>
> Run 'top' and see what the CPU hogs are.  If they are
> Oracle shadow processes, check with the user that
> owns the session.  It may belong to someone whose
> PC crashed or the just shut it off, and you have a
> disconnected session consuming resources.
>
> If you discover a shadow process is consuming 100%
> of a CPU, it probably needs to be killed.  Just be sure
> to find out if it's OK to do so first.
>
> Jared
>
> On Wednesday 23 May 2001 13:56, Nihar wrote:
> > Hi gurus
> >
> >   I am running oracle 8.1.6 on solaris 2.7. All of a sudden my cpu
> > utilization reached 85-90%.
> > I am also having Sun A1000 hardware RAId attached to the box. Can any
> > body help me out in this.
> >  i am sending my report.txt file here after running utlbstat and
> > utlestat.
> >
> > thanks
> >
> > -Nihar
>
> 
> Content-Type: text/plain; charset="iso-8859-1"; name="report.txt"
> Content-Transfer-Encoding: quoted-printable
> Content-Description:
> 
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Jared Still
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jared Still
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: ULIMIT setting: Urgent Please Help

[Viraj Luthra]

Kirti,

I have used ULIMIT=unlimited, ULIMIT=500 and so on, with the same results. After 
doing this change, I reboot the machine and then I log in as the user, oracle8 under 
which I will be installing Oracle. But when I log in as user, oracle8, and type 
ulimit, it gives me 2097152. But oracle installer wants the ulimit to change to 
2113674 which is higher than the prev. figure. 

Therefore I do not know know how to raise the limit to unlimited.

I can do this under root prompt, but as soon as I exit out from this shell (means 
changes are not global), the ulimit reverts to a lower limit for the oracle8 user.

Can you please suggest some parameter(s) in kernel, using scoadmin, which will then 
prompt for the kernel re-build and hence make the ulimit as unlimit permanent.

Also may be there is some way I can raise the ulimit for a particular user (in my case 
oracle8) from root?

Thanks and Regards,

Raja
--

On Wed, 23 May 2001 21:20:20  
 Deshpande, Kirti wrote:
>Hi Viraj,
>Have you tried ULIMIT=500 in the /etc/default/login file? That would
>allow you to access files up to about 2.5GB in size with ulimit high enough
>to solve your current problem. It's been a while since I worked with
>Unixware, but I think it does support large file (over 2GB). 
>A korn shell is sometimes referred to as a posix shell as most newer
>versions of ksh conform to the POSIX standards. Some UNIX versions have
>'psh' linked to 'ksh' or just a copy of 'ksh' (IBM AIX for example). 
>
>HTH,
>
>Regards,
>
>- Kirti Deshpande 
>  Verizon Information Services
>   http://www.superpages.com
>
>> -Original Message-
>> From:Viraj Luthra [SMTP:[EMAIL PROTECTED]]
>> Sent:Wednesday, May 23, 2001 7:29 PM
>> To:  Multiple recipients of list ORACLE-L
>> Subject: Re: ULIMIT setting: Urgent Please Help
>> 
>>  Lisa,
>> 
>> What do you mean by changing to posix shell? How does one do that? I know
>> of tcsh, sh, ksh, etc shells, but did not know posix shell existed. well I
>> tried to execute posix any way and it said 
>> 
>> /bin/posix: Permission denied.
>> 
>> I only installed the SCO Unixware 7.1.1, so I can do any thing there, and
>> it is our test machine so no hassles, please help further, any one.
>> 
>> Thanks and Regards,
>> 
>> Raja
>> --
>> 
>> On Wed, 23 May 2001 09:26:00  
>>  Lisa Yates wrote:
>> >
>> >Raja,
>> >
>> >I had a similar problem, but when I changed my shell to the posix shell,
>> >then it would let me do the ulimit unlimited command. Hope this helps.
>> >
>> >Lisa
>> >
>> >
>> >
>> >
>> >On Wed, 23 May 2001, Viraj Luthra wrote:
>> >
>> >> Hello all,
>> >> 
>> >> I am trying to install oracle 8.0.5.0.0 on SCO Unix Ware 7.1.1. 
>> >> 
>> >> While trying to install Oracle, the Oracle Installer bombs out, because
>> it says that my ulimit is not high enough. It needs the ulimit to be
>> 2113674. But my hard limit of ulimit is 2097152. This figure is less than
>> what Oracel needs.
>> >> 
>> >> Now I have tried to put ULIMIT=unlimited in the /etc/default/login file
>> but this is of no use. Also I have tried to set 
>> >> 
>> >>ulimit unlimited
>> >> 
>> >> but at the unix prompt I get the error that, the value is exceeded and
>> I cannot set the value as unlimited.
>> >> 
>> >> Now can you please help me in trying to set the value as unlimited some
>> how so that the oracle installer does not get object, and I can install
>> the product.
>> >> 
>> >> Thanks and Regards,
>> >> 
>> >> Raja
>> >> 
>> >> 
>> >> 
>> >> Get 250 color business cards for FREE!
>> >>
>-- 
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>-- 
>Author: Deshpande, Kirti
>  INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>San Diego, California-- Public Internet access / Mailing Lists
>
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from).  You may
>also send the HELP command for other information (like subscribing).
>


Get 250 color business cards for FREE!
http://businesscards.lycos.com/vp/fastpath/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 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).

RE: ULIMIT setting: Urgent Please Help

[Deshpande, Kirti]

Hi Viraj,
Have you tried ULIMIT=500 in the /etc/default/login file? That would
allow you to access files up to about 2.5GB in size with ulimit high enough
to solve your current problem. It's been a while since I worked with
Unixware, but I think it does support large file (over 2GB). 
A korn shell is sometimes referred to as a posix shell as most newer
versions of ksh conform to the POSIX standards. Some UNIX versions have
'psh' linked to 'ksh' or just a copy of 'ksh' (IBM AIX for example). 

HTH,

Regards,

- Kirti Deshpande 
  Verizon Information Services
   http://www.superpages.com

> -Original Message-
> From: Viraj Luthra [SMTP:[EMAIL PROTECTED]]
> Sent: Wednesday, May 23, 2001 7:29 PM
> To:   Multiple recipients of list ORACLE-L
> Subject:  Re: ULIMIT setting: Urgent Please Help
> 
>  Lisa,
> 
> What do you mean by changing to posix shell? How does one do that? I know
> of tcsh, sh, ksh, etc shells, but did not know posix shell existed. well I
> tried to execute posix any way and it said 
> 
> /bin/posix: Permission denied.
> 
> I only installed the SCO Unixware 7.1.1, so I can do any thing there, and
> it is our test machine so no hassles, please help further, any one.
> 
> Thanks and Regards,
> 
> Raja
> --
> 
> On Wed, 23 May 2001 09:26:00  
>  Lisa Yates wrote:
> >
> >Raja,
> >
> >I had a similar problem, but when I changed my shell to the posix shell,
> >then it would let me do the ulimit unlimited command. Hope this helps.
> >
> >Lisa
> >
> >
> >
> >
> >On Wed, 23 May 2001, Viraj Luthra wrote:
> >
> >> Hello all,
> >> 
> >> I am trying to install oracle 8.0.5.0.0 on SCO Unix Ware 7.1.1. 
> >> 
> >> While trying to install Oracle, the Oracle Installer bombs out, because
> it says that my ulimit is not high enough. It needs the ulimit to be
> 2113674. But my hard limit of ulimit is 2097152. This figure is less than
> what Oracel needs.
> >> 
> >> Now I have tried to put ULIMIT=unlimited in the /etc/default/login file
> but this is of no use. Also I have tried to set 
> >> 
> >>ulimit unlimited
> >> 
> >> but at the unix prompt I get the error that, the value is exceeded and
> I cannot set the value as unlimited.
> >> 
> >> Now can you please help me in trying to set the value as unlimited some
> how so that the oracle installer does not get object, and I can install
> the product.
> >> 
> >> Thanks and Regards,
> >> 
> >> Raja
> >> 
> >> 
> >> 
> >> Get 250 color business cards for FREE!
> >>
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Deshpande, Kirti
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: cpu utilization on solaris

[Nihar]

No jared it's not the case there are very few shadow process running and non
of them is cpu intensive.Basically it's one dot come data base so in my
script is design such a way that when user exit from the site session
disconnects. Is there any other way around?

thanks and regards

-Nihar

-Original Message-
Sent: Thursday, May 24, 2001 8:05 AM
To: Multiple recipients of list ORACLE-L



Run 'top' and see what the CPU hogs are.  If they are
Oracle shadow processes, check with the user that
owns the session.  It may belong to someone whose
PC crashed or the just shut it off, and you have a
disconnected session consuming resources.

If you discover a shadow process is consuming 100%
of a CPU, it probably needs to be killed.  Just be sure
to find out if it's OK to do so first.

Jared



On Wednesday 23 May 2001 13:56, Nihar wrote:
> Hi gurus
>
>   I am running oracle 8.1.6 on solaris 2.7. All of a sudden my cpu
> utilization reached 85-90%.
> I am also having Sun A1000 hardware RAId attached to the box. Can any body
> help me out in this.
>  i am sending my report.txt file here after running utlbstat and utlestat.
>
> thanks
>
> -Nihar


Content-Type: text/plain; charset="iso-8859-1"; name="report.txt"
Content-Transfer-Encoding: quoted-printable
Content-Description:

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jared Still
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Nihar
  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: NT Scheduled Restart

[PHU,JULIA (HP-Sunnyvale,ex2)]

Same here, thanks.

 

-Original Message-
Sent: Wednesday, May 23, 2001 8:19 AM
To: Multiple recipients of list ORACLE-L


hi suhen,
 
for some reasons i did'nt recieved the mail with the attachment as exe file.
have u sent it.
pls confirm.
 
i'm also looking for such utilities.
 
thanks.
 
 

- Original Message - 
To: Multiple   recipients of list ORACLE-L 
Sent: Wednesday, May 23, 2001 2:15 PM

That's the best thing I like about this list...
You ask for something and you get it, with no delay at all
Thanks list and Thanks Suhen...
 
Rajesh

-Original Message-
 ]
Sent: Wednesday, May 23, 2001 11:11 AM
To: Rajesh Dayal


Rajesh, 
 
We use a exe called shutdown.exe.
It works quite well.  I think it is a freeware.
 
I have attached a copy of shutdown.exe.
Copy this file to C:/winnt.
We pass it arguments 
 
shutdown.exe /L /R /T:25 /C /Y
 
HTH
Suhen
 
 
 


 

Hi all,
I am looking for a utility (preferably freeware), which can perform a
scheduled shutdown of NT 4.0 server. This I need because of inconsistent
behavior of NT for Oracle Services. I want to do a scheduled restart after
every night backup(scheduled).
Appreciate your inputs and suggestions.
 
TIA,
Rajesh

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: PHU,JULIA (HP-Sunnyvale,ex2)
  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: MICROSOFTDTPROPERTIES

[Don Granaman]

Another fine example of vendor cluelessness in picking scale for number
datatypes.
NUMBER(7,0)  should be quite sufficient for CRASH_INTERVAL_SECONDS and
AUTO_DATA_CORRUPT_INTERVAL_SECONDS!

- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, May 23, 2001 4:35 PM


> 
>
> I think we've stumbled on to something...
>
> SQL>  desc MICROSOFTDPROPERTIES;
> NameNull?Type
> ---  
> PROPERTY_ID  NUMBER(38,0)
> FIRST_CRASH_DATE DATE
> NEXT_CRASH_DATE  DATE
> TOTAL_CRASH_NUMBER_SETTING   LONG
> NONSENSICAL_HEX_ERROR_CODE   VARCHAR2(38)
> CRASH_INTERVAL_SECONDS   NUMBER(38,0)
> SECURITY_LOOPHOLE_ID NUMBER(38,0)
> SECURITY_LOOPHOLE_DESC   VARCHAR2(250)
> AUTO_DATA_PURGE_INTERVAL_SECONDS NUMBER(38,0)
> AUTO_DATA_CORRUPT_INTERVAL_SECONDS   NUMBER(38,0)
>
> 
>
> > I have developers who have created this table. Now they've come to me to
> > find out what the table does. I think it is used by the Microsoft
> > Transaction Server software. Does anyone know for sure the purpose of
the
> > MICROSOFTDTPROPERTIES table?
> >
> > Michael Armstead
> > Application Database Administrator, OCP-Certified
> > US Pharmaceuticals IT
> > Glaxo SmithKline
> >
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Armstead, Michael A
> >   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).
> >
> >
>
>
> --
> Jim Hawkins
> Lead SAPR/3 Oracle Database Administrator
> MEMC Electronic Materials, Inc.
> 600 Pearl Drive
> St. Louis, MO  633376
> 9636) 474-7832
> [EMAIL PROTECTED] (work)
> [EMAIL PROTECTED] (home)
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Jim Hawkins
>   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: Don Granaman
  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: Reverse engineer tablespaces.

[Rachel Carmichael]

okay, I got asked this offline and it makes sense to answer here.

This does NOT work for tempfiles or LMTs. It was written when Oracle was at 
8.0.5 and neither of those constructs existed.

However, since the request was to convert 8.0.6 to 8.1.7, it should work 
properly.


>From: "Rachel Carmichael" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: Re: Reverse engineer tablespaces.
>Date: Wed, 23 May 2001 12:11:46 -0800
>
>from the Annotated Archives:  (enter % when asked for the name of the
>tablespace and it will generate all of them)
>
>
>set echo off term on verify off feedback off pagesize 0
>select 'Creating tablespace build script...' from DUAL;
>
>accept tablespace_name prompt "Enter the name of the tablespace: "
>set term off
>
>drop table TSPACE_TEMP;
>
>create table TSPACE_TEMP (
>Lineno  NUMBER,
>Tspace_Name VARCHAR2(30),
>TextVARCHAR2(500))
>/
>
>declare
>   cursor TSPACE_CURSOR is
> select Tablespace_Name,
>Initial_Extent,
>Next_Extent,
>Min_Extents,
>Max_Extents,
>Pct_Increase,
>Min_Extlen,
>Status,
>Contents,
>Logging
>   from DBA_TABLESPACES
>  where Tablespace_Name !='SYSTEM';
>
>   cursor DFILE_CURSOR (C_Tablespace_Name VARCHAR2) is
> select Maxbytes,
>Increment_By,
>File_Name,
>Bytes,
>Status,
>Autoextensible
>   from DBA_DATA_FILES
>  where Tablespace_Name = C_Tablespace_Name
>  order by File_ID;
>
>
>   Lv_TS_Tablespace_Name  DBA_TABLESPACES.Tablespace_Name%TYPE;
>   Lv_TS_Initial_Extent   DBA_TABLESPACES.Initial_Extent%TYPE;
>   Lv_TS_Next_Extent  DBA_TABLESPACES.Next_Extent%TYPE;
>   Lv_TS_Min_Extents  DBA_TABLESPACES.Min_Extents%TYPE;
>   Lv_TS_Max_Extents  DBA_TABLESPACES.Max_Extents%TYPE;
>   Lv_TS_Pct_Increase DBA_TABLESPACES.Pct_Increase%TYPE;
>   Lv_TS_Min_Extlen   DBA_TABLESPACES.Min_Extlen%TYPE;
>   Lv_TS_Status   DBA_TABLESPACES.Status%TYPE;
>   Lv_TS_Contents DBA_TABLESPACES.Contents%TYPE;
>   Lv_TS_Logging  DBA_TABLESPACES.Logging%TYPE;
>
>   Lv_DF_Maxbytes DBA_DATA_FILES.Maxbytes%TYPE;
>   Lv_DF_Increment_By DBA_DATA_FILES.Increment_By%TYPE;
>   Lv_DF_File_NameDBA_DATA_FILES.File_Name%TYPE;
>   Lv_DF_BytesDBA_DATA_FILES.Bytes%TYPE;
>   Lv_DF_Status   DBA_DATA_FILES.Status%TYPE;
>   Lv_DF_Autoextensible   DBA_DATA_FILES.Autoextensible%TYPE;
>
>   Lv_String  VARCHAR2(800);
>   Lv_Lineno  NUMBER  := 0;
>   Lv_DF_CountNUMBER;
>   Lv_Block_Size  NUMBER;
>
>   procedure WRITE_OUT(P_Line INTEGER,  P_Tablespace VARCHAR2,
>   P_String VARCHAR2)
>   is
>   begin
>  insert into TSPACE_TEMP (Lineno, Tspace_name, Text)
> values (P_Line,P_Tablespace,P_String);
>   end;
>
>begin
>
>   select Value
> into Lv_Block_size
> from SYS.V_$PARAMETER
>where upper(name) = 'DB_BLOCK_SIZE';
>
>   open TSPACE_CURSOR;
>   loop
>  fetch TSPACE_CURSOR into Lv_TS_Tablespace_Name,
>   Lv_TS_Initial_Extent,
>   Lv_TS_Next_Extent,
>   Lv_TS_Min_Extents,
>   Lv_TS_Max_Extents,
>   Lv_TS_Pct_Increase,
>   Lv_TS_Min_Extlen,
>   Lv_TS_Status,
>   Lv_TS_Contents,
>   Lv_TS_Logging;
>  exit when TSPACE_CURSOR%NOTFOUND;
>
>  Lv_Lineno := 1;
>  Lv_DF_Count := 0;
>  Lv_String := 'CREATE TABLESPACE ' || LOWER(Lv_TS_Tablespace_Name);
>  WRITE_OUT(Lv_Lineno, Lv_TS_Tablespace_Name, Lv_String);
>  Lv_Lineno := Lv_Lineno + 1;
>
>
>  open DFILE_CURSOR (Lv_TS_Tablespace_Name);
>
>  loop
> fetch DFILE_CURSOR intoLv_DF_Maxbytes,
>Lv_DF_Increment_By,
>Lv_DF_File_Name,
>Lv_DF_Bytes,
>Lv_DF_Status,
>Lv_DF_Autoextensible;
> exit when DFILE_CURSOR%NOTFOUND;
> Lv_DF_Count := Lv_DF_Count + 1;
>
> if (Lv_DF_Count > 1)
> then
>  Lv_String := ',''';
> else
>Lv_String := 'DATAFILE ''';
> end if;
>
> Lv_String := Lv_String || Lv_DF_File_Name
>|| ''' SIZE '
>|| (Lv_DF_Bytes)/1024 ||'K' ;
>
> Lv_String := Lv_String || ' REUSE ';
>
> WRITE_OUT(Lv_Lineno, Lv_TS

Re: Reverse engineer tablespaces.

[Rachel Carmichael]

again, this script fails if the tablespace has more than one datafile in it


>From: Rodd Holman <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: Re: Reverse engineer tablespaces.
>Date: Wed, 23 May 2001 13:15:30 -0800
>
>This mod grabs the current default storage parameters from
>dba_tablespaces
>
>spool db_structure.txt
>select 'create tablespace '||a.tablespace_name|| ' datafile
>'||||b.file_name||||' size '||b.bytes/(1024 * 1024)||'M'||
>' default storage ( initial '||a.initial_extent||' next
>'||a.next_extent||' pctincrease '||a.pct_increase||' maxextents
>'||a.max_extents||');'
>from dba_tablespaces a, dba_data_files b where a.tablespace_name =
>b.tablespace_name;
>spool off
>
>Rodd
> >> Original Message <<
>
>On 5/23/01, 3:30:29 PM, Roy Ferguson <[EMAIL PROTECTED]> wrote regarding
>Re: Reverse engineer tablespaces.:
>
>
> > I'm not sure if this is what your looking for but take a look:
>
>
> > spool db_structure.txt
> > select 'create tablespace ' || a.tablespace_name ||
> >  ' datafile ' ||  || b.file_name || ||' size ' || b.bytes/(1024 
>*
>1024) || 'M' || \
> > ' default storage ( initial ??k next ??k pctincrease ? maxextents ?);'
> > from dba_tablespaces a, dba_data_files b where a.tablespace_name =
>b.tablespace_name;
> > spool off;
> > exit;
>
>
> > Roy
>
>
>
> > >
> > >So, I need to re-create a database to prepare for migration.  The
>current DB
> > >is 8.0.6, and I need to create an 8.1.7 copy.  Does anyone have a 
>script
>to
> > >reverse engineer the CREATE TABLESPACE commands?  I started working on
>one,
> > >but surely I can't be the first to invent the wheel.
> > >
> > >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).
>
>
>
>
> > Roy E. Ferguson II
> > Intel Sacramento
> > 916-854-1123
>
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Roy Ferguson
> >   INET: [EMAIL PROTECTED]
>
> > Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> > San Diego, California-- Public Internet access / Mailing Lists
> > 
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from).  You may
> > also send the HELP command for other information (like subscribing).
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Rodd Holman
>   INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>San Diego, California-- Public Internet access / Mailing Lists
>
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from).  You may
>also send the HELP command for other information (like subscribing).

_
Get your FREE download of MSN Explorer at http://explorer.msn.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rachel Carmichael
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: SQLLDR Question

[Jared Still]

Instead of trying to do this in SQL Loader, why not just
try to clean up the data?

This can be done at least 2 methods:

1.  Get the sender to send it to you properly

2.  clean it up yourself.

The following Perl script will do it

Jared


#!/usr/bin/perl
 
my $file="data.txt";
open(DATA,$file) || die "cannot open $file - $!\n";
 
while(){
chomp;
my @data = split(/,/);
# append last field to penultimate field, remove last field
$data[ $#data -1] .= "-" . $data[ $#data ];
undef $data[ $#data ];
 
#print it all out
my $newData =  join(',',@data);
# remove trailing comma
chop $newData;
print "$newData\n";
}



On Wednesday 23 May 2001 14:41, Scott Canaan wrote:
> I am trying to load a file that has the fields comma-delimited,
> variable length.  A sample line from the file looks like this:
>
> 503,414081660,Success,Auth,AH9042,z,4555,-,-,-,0,05/01/01,14:21
>
> The problem I am having is putting the date and time together.  The
> control file looks like this:
>
> load data
> infile 'cyber_real.dat'
> append
> into table rit_cyber_hist
> when order_id <> 'Order ID' and order_id <> ''
> fields terminated by ','
> (order_id,
>  trans_nbr,
>  cyber_status,
>  trans_type,
>  auth_code,
>  avs_code,
>  trans_amt,
>  cic_resp,
>  po_nbr,
>  ship_to_zip,
>  tax_amt,
>  trans_date date(14) "mm/dd/yy,hh:mi")
>
> It ignores the time portion of the file, I presume because it has a
> comma before it and it assumes that it is a different field.  I can't
> figure out any way to get this loaded with the trans_date field
> containing both the date and time.
>
> This is on Oracle 8.1.6.0 on Sun Solaris.
>
> Any suggestions?  Thank you.
>
> --
> Scott Canaan ([EMAIL PROTECTED])
> (716) 475-7886
> "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: Jared Still
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Reverse engineer tablespaces.

[Rachel Carmichael]

am I missing something? If you have more than one datafile in any 
tablespace, you are going to generate incorrect SQL here. see below

you generate a new create tablespace command for EVERY datafile, even if 
it's the second one in the tablespace.

TABLESPACE_NAME   FILE_NAME
- 
COUPONS   /db09/oradata/testdb/COUPONS01.dbf
COUPONS   /db09/oradata/testdb/COUPONS02.dbf



SQL> select 'create tablespace '||a.tablespace_name||
  2  ' datafile '||||b.file_name||||' size '||b.bytes/(1024 
*
  3  1024)||'M'||
  4  ' default storage ( initial '||a.initial_extent||
  5' next '||a.next_extent||
  6' pctincrease '||a.pct_increase||
  7' maxextents '||a.max_extents||');'
  8  from   dba_tablespaces a,
  9  dba_data_files b
10  where  a.tablespace_name = b.tablespace_name
11  order by b.file_id;



create tablespace COUPONS datafile '/db09/oradata/testdb/coupons01.dbf' size 
501M default storage ( initial 52428800 next 52428800 pctincrease 0 
maxextents 2147483645);
create tablespace COUPONS datafile '/db09/oradata/testdb/coupons02.dbf' size 
501M default storage ( initial 52428800 next 52428800 pctincrease 0 
maxextents 2147483645);




>From: Rodd Holman <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: Re: Reverse engineer tablespaces.
>Date: Wed, 23 May 2001 13:22:55 -0800
>
>Actually this version will create your tablespaces with the same
>structure and file_id's as your current db.
>
>select 'create tablespace '||a.tablespace_name||
>' datafile '||||b.file_name||||' size '||b.bytes/(1024 *
>1024)||'M'||
>' default storage ( initial '||a.initial_extent||
>  ' next '||a.next_extent||
>  ' pctincrease '||a.pct_increase||
>  ' maxextents '||a.max_extents||');'
>from   dba_tablespaces a,
>dba_data_files b
>where  a.tablespace_name = b.tablespace_name
>order by b.file_id;
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Rodd Holman
>   INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>San Diego, California-- Public Internet access / Mailing Lists
>
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from).  You may
>also send the HELP command for other information (like subscribing).

_
Get your FREE download of MSN Explorer at http://explorer.msn.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rachel Carmichael
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: (Fwd) Wilber/Shambala interview ("transideological" social trends)

[Rachel Carmichael]

I used to own a two volume copy of the OED.. even with the magnifying glass 
they provide, it's almost impossible to read :)

I am constantly in awe of the breadth of your knowledge and interests.



>From: "Eric D. Pierce" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: RE: (Fwd) Wilber/Shambala interview ("transideological" social 
>trends)
>Date: Wed, 23 May 2001 11:36:42 -0800
>
>worship godesses that can create rifts in the space/time continuum. :) no,
>it is just an "addiction" caused by reading the Whole Earth Catalog when I
>was a little kid back in the 1960s.
>
>http://www.edge.org/documents/digerati/Brand.html
>-
>http://www.duhcentral.com/mis/curriculum.htm
>
>---excerpt---
>
>
>IDEAS:
>cybernetics, understanding whole systems, tool, ecology
>
>NOTES: Stewart Brand was running around in the mid-sixties (when NASA had
>taken its first satellite photos of the earth with the entire round profile
>in the frame but wouldn't release them to the public), handing out protest
>buttons which said, "WHY HAVEN'T WE SEEN THE WHOLE EARTH?" And sure enough,
>when detailed color pictures taken by the Apollo Eight crew of our home
>planet were published right after Christmas 1968, they galvanized the
>public and helped in the popularization of the ecology movement. As Joni
>Mitchell sang:
>
>"In a highway service station, over the month of June, Was a photograph
>of the Earth taken coming back from the Moon. And you couldn't see a city
>on that marble bowling ball, Or a forest or a highway, or me the least of
>all."
>
>It was this type of romanticization of the Whole Earth which lead me to the
>Whole Earth Catalog. Actually, the WEC (as it calls itself) began as a 
>mail-
>  order catalog for back-to-the-land communes, but it had an eccelctic,
>holistic view that quickly took it into cybernetcis and systems theory, and
>I followed. As I explained in the introduction, these "catalogs" edited by
>Stewart Brand first introduced me to most of the ideas and thinkers listed
>in this essay.
>
>QUOTE: The WHOLE EARTH CATALOG got started in a plane over Nebraska in
>March 1968. I was returning to California from my father's long dying and
>funeral that morning in Illinois. The sun had set ahead of the plane while
>I read Spaceship Earth by Barbara Ward. Between chapters I gazed out the
>window into dark nothing and slid into a reverie about my friends who were
>starting their own civilization hither and yon in the sticks and how could
>I help. The L. L. Bean catalog of outdoor stuff came to mind and I pondered
>upon Mr. Bean's service to humanity over the years. So many of the problems
>I could identify came down to a matter of access. Where to buy a windmill.
>Where to get good information about bee-keeping. Where to lay hands on a
>computer without forfeiting freedom... Shortly I was fantasizing access
>service. A Truck Store, maybe, travelling around with information and
>samples of what was worth getting and information where to get it. A
>Catalog too, continuously updated, in part by the users. A Catalog that
>owed nothing to the suppliers and everything to the users. It would be
>something I could put some years into. Amid the fever I was in by this
>time, I remembered Fuller's admonition that you have about 10 minutes to
>act on an idea before it recedes back into dreamland. I started writing on
>the end papers of Barbara Ward's book (never did finish reading it). ...
>Understanding whole systems is knowing how to fly. You can rise above local
>circumstances, travel with blurring speed, and set down in a place wholly
>distant, strange and wonderful. Or maybe not so wonderful, in which case
>you best know how to take off in a tight situation, and remember where home
>is. The price you pay for understanding is the grim knowledge of trade-offs
>in design. That you can have an airplane that goes fast or one that lands
>in 200 ft., but not both. That to save these people you may have to starve
>those people. By and by you dwell in a wilderness of conflicting
>considerations. If you survive your wishful solutions -- and there's
>usually margin -- you may become a wily and sky-hooked metaphysician. The
>solutions are always meta. The means always funky field expedient. ...
>Evolution and cybernetics are going to come together. This is the edge of
>knowledge right now, and it's right at the heart of education, and the
>schools don't know it.
>
>[-- all from The Last Whole Earth Catalog, 1971]
>{HYPERLINK "https://www.well.net/mwec/home.html"}
>
>---end---
>
>regards,
>ep
>
>ps, one day I *will* own the 2 volume OED!!!
>
>On 23 May 2001, at 7:19, Mark Leith wrote:
>
>
> > ... where do you get all the time from to collate this
> > extraordinarily extensive yet thoroughly interesting psycho babble? :)
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Eric D. Pierce
>   INET: [EMAIL PROTECTED]
>
>Fat City Network Servic

RE: Drop 'NOT NULL' Constraint

[Deshpande, Kirti]

Kevin,
I don't think so. Here is what happens with a 8.1.7 database. 
SQL> create table t (ca varchar2(2) not null, cb number);
Table created.
SQL> insert into t values ('AA', 1);
1 row created.
SQL> commit;
Commit complete.
SQL> desc t
 Name  Null?Type
 - 

 CANOT NULL VARCHAR2(2)
 CB NUMBER
SQL> select * from t;   
CA  CB
-- ---
AA   1
SQL> alter table t modify (ca null);
Table altered.
SQL> desc t
 Name  Null?Type
 - 

 CA VARCHAR2(2)
 CB NUMBER
SQL> select * from t;
CA  CB
-- ---
AA   1
SQL> 

If the column 'CA' were to have a primary key constraint, then the
constraint needs to be dropped to modify the column as a nullable column.

Regards,
 
- Kirti Deshpande 
  Verizon Information Services
   http://www.superpages.com

> -Original Message-
> From: Kevin Kostyszyn [SMTP:[EMAIL PROTECTED]]
> Sent: Wednesday, May 23, 2001 4:57 PM
> To:   Multiple recipients of list ORACLE-L
> Subject:  RE: Drop 'NOT NULL' Constraint
> 
> I think that if there is already data in the column you will not be able
> to
> do that.
> 
> -Original Message-
> Sent: Wednesday, May 23, 2001 5:15 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> I created a table with a 'NOT NULL' constraint on a VARCHAR2 column.  I
> would like to remove the NOT NULL constraint.  I've tried a couple of
> 'ALTER TABLE' commands but no luck.
> 
> How does one do this?
> 
> Also:
> 
> How does one figure out which generated constraints (from
> user_constraints) do what?
> 
> Chris Rezek
> Database Administrator
> DotClick
> http://www.dotclick.com
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Chris Rezek
>   INET: [EMAIL PROTECTED]
> 
> 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Deshpande, Kirti
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: cpu utilization on solaris

[Jared Still]

Run 'top' and see what the CPU hogs are.  If they are
Oracle shadow processes, check with the user that
owns the session.  It may belong to someone whose
PC crashed or the just shut it off, and you have a
disconnected session consuming resources.

If you discover a shadow process is consuming 100%
of a CPU, it probably needs to be killed.  Just be sure
to find out if it's OK to do so first.

Jared



On Wednesday 23 May 2001 13:56, Nihar wrote:
> Hi gurus
>
>   I am running oracle 8.1.6 on solaris 2.7. All of a sudden my cpu
> utilization reached 85-90%.
> I am also having Sun A1000 hardware RAId attached to the box. Can any body
> help me out in this.
>  i am sending my report.txt file here after running utlbstat and utlestat.
>
> thanks
>
> -Nihar


Content-Type: text/plain; charset="iso-8859-1"; name="report.txt"
Content-Transfer-Encoding: quoted-printable
Content-Description: 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jared Still
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Database Down

[Jared Still]

Rachel,

I was thinking of this as a current control file vs. backup control
file kind of discussion.

In any case, the current controlfile will let you do an incomplete
recovery.  It's been awhile since I actually worked through all
of these exercises, so I can't recall the details of the differences
between the 3 different types of controfiles.

The Oracle8i version of the Backup and Recovery Handbook says
that the order of preference is current, rebuild from trace file, and
backup.

Jared


On Wednesday 23 May 2001 14:50, Rachel Carmichael wrote:
> Jared,
>
> as I understand it, the original controlfile allows you to recover until
> the SCN's all match the one in the controlfile.  A backup controlfile
> assumes that you are not certain of what the final SCN is and so allows you
> to continue recovering past the backup time.
>
> I *think* this is the premise behind the standby controlfile. I know that
> you could mimic standby in earlier versions of 7 by doing this.. and just
> recovering until you decided to stop moving archive logs over.
>
> Warning though -- you WILL have to open with resetlogs if you use the
> backup controlfile because Oracle won't be able to tell when it should
> assume recovery is complete.
>
> Rachel
>
>
> From: Jared Still <[EMAIL PROTECTED]>
>
> >Reply-To: [EMAIL PROTECTED]
> >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> >Subject: Re: Database Down
> >Date: Wed, 23 May 2001 08:31:50 -0800
> >
> >On Wednesday 23 May 2001 01:00, Paul Drake wrote:
> > > 0. caffeine.
> >
> >Agreed.
> >
> > > 2. You *will* be performing incomplete recovery. Recover until cancel,
> > > preferably with a backup controlfile.
> > >Did you create a backup controlfile as part of the hot backup on May
> > > 11th? Restore with that controlfile.
> >
> >Is there a particular reason for recommending the backup controlfile?
> >
> >Shouldn't be needed unless the controlfile has been lost.
> >
> > > 3. After the recovery is completed (you've opened RESETLOGS) close the
> > > database and get a *full* cold backup. Fight the urge to *get the
> >
> >Some repetition for emphasis here.  As Paul says, a cold backup must be
> >completed before any work is done on the database.
> >
> >
> >Some add'l advice for Laura.  Read Rama Velpuri's book 'Oracle Backup
> >and Recovery Handbook' cover to cover, and do all of the exercises.  It
> >will make an immense difference in your understanding of recovery.
> >
> >Backup is easy, recovery is not always so.
> >
> >Jared
> >--
> >Please see the official ORACLE-L FAQ: http://www.orafaq.com
> >--
> >Author: Jared Still
> >   INET: [EMAIL PROTECTED]
> >
> >Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> >San Diego, California-- Public Internet access / Mailing Lists
> >
> >To REMOVE yourself from this mailing list, send an E-Mail message
> >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> >the message BODY, include a line containing: UNSUB ORACLE-L
> >(or the name of mailing list you want to be removed from).  You may
> >also send the HELP command for other information (like subscribing).
>
> _
> Get your FREE download of MSN Explorer at http://explorer.msn.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jared Still
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: size of Clob

[Biddell, Ian]

Hi Ravindra

You can do 

select dbms_lob.getlength(lob_column) from lob_table;

The returned value will be the number of bytes in your LOB column.
I have done this for a CLOB field in one of our databases.

HTH
Ian

-Original Message-
Sent: Thursday, 24 May 2001 11:20
To: Multiple recipients of list ORACLE-L


I have a column of Clob datatype in one table.How Can I find the size of the
data in a row for that Clob column alone.

Is this possible?

Thanks
Ravindra
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ravindra Basavaraja
  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: Biddell, Ian
  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).

size of Clob

[Ravindra Basavaraja]

I have a column of Clob datatype in one table.How Can I find the size of the
data in a row for that Clob column alone.

Is this possible?

Thanks
Ravindra
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ravindra Basavaraja
  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: Drop 'NOT NULL' Constraint

[Gregory Conron]

On Wed, 23 May 2001, Chris Rezek wrote:
> I created a table with a 'NOT NULL' constraint on a VARCHAR2 column.  I
> would like to remove the NOT NULL constraint.  I've tried a couple of
> 'ALTER TABLE' commands but no luck.
> 
> How does one do this?

alter table foo
modify (bar null);


Cheers,
GC
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Gregory Conron
  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: NT Scheduled Restart

[Suhen Pather]

Bruce,

What I tend to do is not shutdown the Oracle database using the
shutdown.exe.
I execute a script fortnightly that first shuts down
Oracle then calls the shutdown.exe to shutdown the box.

In this way the database is down before the shutdown.exe executes.

Similarly you can write a script to shutdown any application/db before 
kicking off shutdown.exe thus preventing any abnormal shutdown.

Luckily we use MKS Toolkit, I can write korn shell quite easily to do these
routine tasks.

Regards
Suhen


Hi,

I also use this to reboot a server (not our Oracle one though) but beware of
the "/C" switch - this may not do a clean shutdown of your applications /
Oracle.
>From the help on NT4:
C  Forces running applications to close.
   ATTENTION: If you use the /C parameter NT ignores the
  applications option to save data which may
  have changed. You will see no File-Save dialog
  box, because NT will force the application to
  close. This will result in a loss of all data.
  not previously saved !!!

This definitely results in SQL Server getting upset.

That said, why do you need to reboot - for example our NT Oracle server
(81511, NT 4 SP6a) has been up for 238 days?

Regards,
Bruce

-Original Message-
Sent: Wednesday, 23 May 2001 5:50 
To: Multiple recipients of list ORACLE-L


> Rajesh Dayal wrote:
> 
>  Hi all,
>  I am looking for a utility (preferably freeware), which
>  can perform a scheduled shutdown of NT 4.0 server. This I
>  need because of inconsistent behavior of NT for Oracle
>  Services. I want to do a scheduled restart after every night
>  backup(scheduled).
>  Appreciate your inputs and suggestions.
> 
>  TIA,
>  Rajesh


NT Resource Kit supports the shutdown command.
use it.

for W2K: (don't have any NT4 boxen here)

shutdown /L /R /C

is good.

/L - local
/R - reboot
/C - close apps.

hth,

Paul
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Paul Drake
  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: Reardon, Bruce (CALBBAY)
  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: Suhen Pather
  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: Another Database Down

[Shreter, Hilary]

Title: Another Database Down



No 
need to panic yet! Check out Metalink note 1034037.6 which has about 4 possible 
reasons for this -- all pretty simple. 

  -Original Message-From: Burton, Laura L. 
  [mailto:[EMAIL PROTECTED]]Sent: Wednesday, May 23, 2001 7:27 
  PMTo: Multiple recipients of list ORACLE-LSubject: 
  Another Database Down
  Well, I think the time for jubilation has been 
  short-lived for me.  The production database was recovered successfully 
  due to archiving and luck.  I also have a small, inhouse, remedy (help 
  desk) database that I haven't done anything with and now recovery is necessary 
  for it as well.  The bad news is I wasn't archiving, and although I do 
  have a physical backup, the database was not down.
  I restored the datafiles, control files, and redo 
  logs so that everything would be for the same time, but when I try to open the 
  database I get the error "cannot mount database in exclusive mode."  The 
  error states that an instance already has it open in exclusive or parallel 
  mode.  I am assuming this is because the database was not closed when the 
  backup was executed. 
  I have tried a few things to 'trick' it, but I 
  guess my magic tricks are not good enough to fool the crowd.  I am 
  already bracing myself for what I will probably read in response to this...but 
  I am hopeful that someone will find that rabbit in the hat.
  Thank you in advance, Laura 

RE: NT Scheduled Restart

[Reardon, Bruce (CALBBAY)]

Hi,

I also use this to reboot a server (not our Oracle one though) but beware of
the "/C" switch - this may not do a clean shutdown of your applications /
Oracle.
>From the help on NT4:
C  Forces running applications to close.
   ATTENTION: If you use the /C parameter NT ignores the
  applications option to save data which may
  have changed. You will see no File-Save dialog
  box, because NT will force the application to
  close. This will result in a loss of all data.
  not previously saved !!!

This definitely results in SQL Server getting upset.

That said, why do you need to reboot - for example our NT Oracle server
(81511, NT 4 SP6a) has been up for 238 days?

Regards,
Bruce

-Original Message-
Sent: Wednesday, 23 May 2001 5:50 
To: Multiple recipients of list ORACLE-L


> Rajesh Dayal wrote:
> 
>  Hi all,
>  I am looking for a utility (preferably freeware), which
>  can perform a scheduled shutdown of NT 4.0 server. This I
>  need because of inconsistent behavior of NT for Oracle
>  Services. I want to do a scheduled restart after every night
>  backup(scheduled).
>  Appreciate your inputs and suggestions.
> 
>  TIA,
>  Rajesh


NT Resource Kit supports the shutdown command.
use it.

for W2K: (don't have any NT4 boxen here)

shutdown /L /R /C

is good.

/L - local
/R - reboot
/C - close apps.

hth,

Paul
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Paul Drake
  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: Reardon, Bruce (CALBBAY)
  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: ULIMIT setting: Urgent Please Help

[Viraj Luthra]

 Lisa,

What do you mean by changing to posix shell? How does one do that? I know of tcsh, sh, 
ksh, etc shells, but did not know posix shell existed. well I tried to execute posix 
any way and it said 

/bin/posix: Permission denied.

I only installed the SCO Unixware 7.1.1, so I can do any thing there, and it is our 
test machine so no hassles, please help further, any one.

Thanks and Regards,

Raja
--

On Wed, 23 May 2001 09:26:00  
 Lisa Yates wrote:
>
>Raja,
>
>I had a similar problem, but when I changed my shell to the posix shell,
>then it would let me do the ulimit unlimited command. Hope this helps.
>
>Lisa
>
>
>
>
>On Wed, 23 May 2001, Viraj Luthra wrote:
>
>> Hello all,
>> 
>> I am trying to install oracle 8.0.5.0.0 on SCO Unix Ware 7.1.1. 
>> 
>> While trying to install Oracle, the Oracle Installer bombs out, because it says 
>that my ulimit is not high enough. It needs the ulimit to be 2113674. But my hard 
>limit of ulimit is 2097152. This figure is less than what Oracel needs.
>> 
>> Now I have tried to put ULIMIT=unlimited in the /etc/default/login file but this is 
>of no use. Also I have tried to set 
>> 
>>ulimit unlimited
>> 
>> but at the unix prompt I get the error that, the value is exceeded and I cannot set 
>the value as unlimited.
>> 
>> Now can you please help me in trying to set the value as unlimited some how so that 
>the oracle installer does not get object, and I can install the product.
>> 
>> Thanks and Regards,
>> 
>> Raja
>> 
>> 
>> 
>> Get 250 color business cards for FREE!
>> http://businesscards.lycos.com/vp/fastpath/
>> -- 
>> Please see the official ORACLE-L FAQ: http://www.orafaq.com
>> -- 
>> Author: 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).
>> 
>
>  
>
>*  Lisa Yates[EMAIL PROTECTED]  * 
>*  Creighton University*
>*  Omaha, Nebraska *
>*  (402) 280-2419fax: (402) 280-2573   *
>*  Define the Universe, give 2 examples.   *
>
>
>
>-- 
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>-- 
>Author: Lisa Yates
>  INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>San Diego, California-- Public Internet access / Mailing Lists
>
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from).  You may
>also send the HELP command for other information (like subscribing).
>


Get 250 color business cards for FREE!
http://businesscards.lycos.com/vp/fastpath/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 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).

RE: Components removal - W2K

[Reardon, Bruce (CALBBAY)]

Sean,

See below for some Oracle specific answers, but I would consider "Emergency
Undelete" by Executive Software.
See for example http://www.execsoft-europe.com/downloads/english/udfree.htm
It appears that Undelete is no longer offered as freeware, but Version 1.2
of Undelete was freeware and this might help you.

To help clarify what has been lost, you may have also lost the OUI itself
and the JRE.

Check your path to confirm where the JRE was installed - if you have lost
this then amongst other things the Configuration Assistants will no longer
work.
Was the OUI installed?  
Unless you have set the oracle_base environment variable or altered the
destination during the installation the default location for both the JRE
and the OUI is the c:\program file\oracle dir.

Also the Windows Config assistant might have been lost as well (if it was
installed).

As for replacing them, then only guessing here - I would imagine the OUI,
JRE and Win Config assistant could be copied from another server.
As for the inventory file - unsure.  
For future reference, note that if Oracle_base is set (or perhaps if you
follow the instructions in Note:71919.1 Debugging the Universal Installer)
you can alter where the inventory dir is created.

Regards,
Bruce Reardon

-Original Message-
Sent: Thursday, 24 May 2001 1:27 
To: Multiple recipients of list ORACLE-L


We have Oracle 8i Rel installed on a W2K server.  The Oracle Home is located
on the E: drive.  Yesterday an "accidental" deletion occured of files on the
C: drive which resulted in files being deleted in the C:\Program
Files\Oracle dirs and below.  No backup exists of these files :(

So I'm wondering 
[1] What implications this has for the Oracle install?  E.g. I suspect
records of installed components may have been deleted.  

[2] What can I do to replace these files from Oracle install CD?

Any advice would be much appreciated!


Rookie Data Base Administrator
[0%] OCP Oracle8i DBA
[0%] OCP Oracle9i DBA
  
Organon (Ireland) Ltd.   
http://www.organon.ie
E-mail: [EMAIL PROTECTED]   [subscribed: Digest Mode]

Visit: http://groups.yahoo.com/group/Oracle-OCP-DBA

"Nobody loves me but my mother. and she could be jivin' too." - BB King



-- 
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  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: Reardon, Bruce (CALBBAY)
  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: Database Down

[Burton, Laura L.]

Title: RE: Database Down




Whoopsby all means...LOL

-Original Message-From: Jacques Kilchoer 
[mailto:[EMAIL PROTECTED]]Sent: Wednesday, May 23, 2001 
6:31 PMTo: Multiple recipients of list 
ORACLE-LSubject: RE: Database Down


-Original Message-From: Burton, Laura L. 
[mailto:[EMAIL PROTECTED]]
Amen Sister!!  I am afraid you all will have to be my 
virtual party people, since I am the only one around here that got 
excited when the recovery was done...so have a great 
time!!
 
Laura :)

Thank you for admitting me to the sorority. But I'm 
not ready yet for the operation. Can I go on being a man a while 
longer?
 
Jacques R. Kilchoër
x8816

RE: Deleting Files in NT

[Reardon, Bruce (CALBBAY)]

Just to add to this

With forfiles, if your filename has spaces, you need to put quotes around
it.

Below is a wrapper bat file I wrote for forfiles to make it somewhat easier
to use (and shorter to call from elsewhere).
Also, this wrapper shows an example of only deleting if it is a file and not
a dir.

Have fun,
Bruce Reardon

---
@echo off

rem PURPOSE
remdelete_oldfiles.bat
remdeletes files greater than or equal to x days old
rem Note - directories are not deleted.

rem does not delete read only, hidden or system files

rem  18-Apr-2000 , Bruce Reardon : Creation.

rem USEAGE
rem Parameters - %1 = path , %2 = file mask , 
rem %3 = how many days old , %4 (optional) - recurse



rem ASSUMPTIONS
rem none.


rem REQUIRES
rem forfiles.exe - distributed with NT Resource kit
rem that forfiles.exe be located at c:\nt4reskit

rem SIDE EFFECTS
rem envdelold env variable will be overwritten and deleted if it exists.

rem MODIFICATIONS

::

rem Parameter validation.

IF "%3"=="" goto param_problem   :: not enough params

IF NOT "%5"=="" goto param_problem  :: too many params

rem check parameter 3 is a valid number
set envdelold=
IF "%3"=="0" goto param3_ok 

   set /a envdelold = 1*%3  2> nul:
   IF "%envdelold%"=="0" goto param3_problem 
   IF "%envdelold%"=="" goto param3_problem 

:param3_ok


IF NOT "%4"=="" IF NOT "%4"=="-s" goto param4_problem  :: invalid param 4

IF NOT EXIST %1. goto param1_problem



rem we now have 3 (possibly 4) parameters and they have been
validated.

echo %1 %2 %3 %4


rem the actual command - put quotes around to allow for names with
spaces.

c:\nt4reskit\forfiles -p%1 -m%2 %4 -d-%3 -c"cmd /c if @ISDIR==FALSE  del
0x22@FILE0x22"


goto end



:param_problem
   echo %0
   echo ERROR - Must pass in 3 parameters (4 max)
   echo Param 1 is the path
   echo Param 2 is file mask
   echo Param 3 is number of days
   echo Param 4 (optional) : if "-s" then recurse subdir's.
   echo.
   echo eg "%0 c:\temp *.* 5" would delete ALL files in c:\temp directory 5
or more days old
   goto end


:param1_problem
   echo "%0 [-->[%1]<--] %2 %3 %4"
   echo ERROR - 1st parameter invalid
   echo Param 1 is the path and it must exist.
   echo.
   echo   eg "%0 c:\temp *.* 5" would delete ALL files 
   echo in c:\temp directory 5 or more days old
   goto end

:param3_problem
   echo "%0 %1 %2 [-->[%3]<--] %4"
   echo ERROR - 3rd parameter invalid
   echo Param 3 is the number of days and it must be a valid number
   echo.
   echo   eg "%0 c:\temp *.* 5" would delete ALL files 
   echo in c:\temp directory 5 or more days old
   goto end


:param4_problem
   echo "%0 %1 %2 %3 [-->[%4]<--]"
   echo ERROR - 4th parameter invalid
   echo Param 4 (optional) : must be "-s" (to recurse subdir's) or be
blank.
   echo.
   echo   eg "%0 c:\temp *.* 5 -s" would delete ALL files 
   echo in c:\temp directory (incl subdirs) 5 or more days old
   goto end


:end
   rem - batch file finished
   set envdelold=
--

-Original Message-
Sent: Thursday, 24 May 2001 8:31 

Raj,
If you have the resource kit installed you can use forfiles.

forfiles -pp:\zipfiles\hot\ -s -m*.* -d-20052001 -c"CMD /C DEL /Q @FILE";

Forfiles is helpful for ton's of DB Maintenance, you can pipe the results to
any dos command you want.

We use a statement like the one below in our spool_Hot_Backup script

to prune the backup directories before we put all the tablespaces in hot
backup mode and ocopy them, We then compress them in a staging directory
using pacomp and move them to a drive so that last nights datafiles are
around for a speedy recovery (If Necessary).  

 /* Clean Out ZIP Files older than two days: Uses Forfiles Resource
Kit*/
  select to_char(sysdate-2,'ddmm') into datestr from dual;
 dbms_output.put_line('host forfiles -p'||backupdir||' -s -m*.*
-d-'||datestr||
' -c'||chr(34)||'CMD /C DEL /Q @FILE'||chr(34)||';');

HTH, (hazardous terminal halitosis)
Scott Crabtree

-Original Message-
Sent: Wednesday, May 23, 2001 11:45 AM

DBAs

How do I delete files from NT which are older than a week. I need this to
organise my backup dump files.

Cheers
Raj
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Reardon, Bruce (CALBBAY)
  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

RE: MICROSOFTDTPROPERTIES

[Shreter, Hilary]

Is this table residing in an Oracle database ??  
This is the special table that MS Access sets up in order to hold 2-3 little
properties that it wanted.

I don't want to cause Microsoft to drag me to court so I'm not clipping...
Please get to www.microsoft.com, see explanation to Q247828 which describes
this table and OTHER stuff that gets added!!

-Original Message-
[mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 23, 2001 5:16 PM
To: Multiple recipients of list ORACLE-L


The developer created the table and now doesn't know what is does???  
As penance, said developer(s) must write "I will document all changes fully"
and "RTFM" in their own blood, 10,000 times on the floor without using their
hands.

Then:
1)  export tables=MICROSOFTDTPROPERTIES ...
2)  DROP TABLE MICROSOFTDTPROPERTIES;
3)  see who/what/if anything breaks, whines, or snivels...

All assuming this is a development instance.  You WERE NOT letting them poke
around in a production instance, correct?

Your Friend in Evil,

Scott Shafer
San Antonio, TX
210-581-6217

"And no amount of training or preparedness can eliminate the almost
certainty that in the middle of your Angry Crane stance, as you transition
to your Combative Monkey to administer the Coup de Gras via your Ninja Death
Touch, you step on a beer bottle and fall backwards into the juke box and
get your head stove in by a drunk with a pool cue."  --Jay Trigg


> -Original Message-
> From: Armstead, Michael A [SMTP:[EMAIL PROTECTED]]
> Sent: Wednesday, May 23, 2001 10:39 AM
> To:   Multiple recipients of list ORACLE-L
> Subject:  MICROSOFTDTPROPERTIES
> 
> I have developers who have created this table. Now they've come to me to
> find out what the table does. I think it is used by the Microsoft
> Transaction Server software. Does anyone know for sure the purpose of the
> MICROSOFTDTPROPERTIES table?
> 
> Michael Armstead  
> Application Database Administrator, OCP-Certified
> US Pharmaceuticals IT
> Glaxo SmithKline
> 
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Armstead, Michael A
>   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: Shreter, Hilary
  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: Database Down

[Jacques Kilchoer]

Title: RE: Database Down





  -Original Message-From: Burton, Laura L. 
  [mailto:[EMAIL PROTECTED]]
  Amen 
  Sister!!  I am afraid you all will have to be my virtual party people, 
  since I am the only one around here that got excited when the recovery was 
  done...so have a great time!!
   
  Laura :)
Thank 
you for admitting me to the sorority. But I'm not ready yet for the operation. 
Can I go on being a man a while longer?
 
Jacques R. Kilchoër
x8816

RE: Sun Solaris 8 - Listener failed to start a dedicated server p

[John Kanagaraj]

$ sar 
sar: can't open /var/adm/sa/sa23 
No such file or directory 

I do see a /var/adm/sa/sa16 directory. What does this mean?   

Jacques,

This is the file (not directory?!) that records the system activity
information (in binary) via the sadc program. The file is named by
day-of-the-month (it is 23rd today). You don't seem to have access to this
file - not sure why since you normally should Or maybe you ran out of
space in the '/var' filesystem?

>From your answer re the solution - i.e. reduction of SGA - it looks like a
combination of values in SHM and SEM parameters did create the problem...
Another issue that occurs in my mind is that some filesystem - either
$ORACLE_HOME or $TNS_ADMIN or whereever sqlnet logs are kept became full..

John Kanagaraj

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: John Kanagaraj
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: MICROSOFTDTPROPERTIES

[Scott . Shafer]

The developer created the table and now doesn't know what is does???  
As penance, said developer(s) must write "I will document all changes fully"
and "RTFM" in their own blood, 10,000 times on the floor without using their
hands.

Then:
1)  export tables=MICROSOFTDTPROPERTIES ...
2)  DROP TABLE MICROSOFTDTPROPERTIES;
3)  see who/what/if anything breaks, whines, or snivels...

All assuming this is a development instance.  You WERE NOT letting them poke
around in a production instance, correct?

Your Friend in Evil,

Scott Shafer
San Antonio, TX
210-581-6217

"And no amount of training or preparedness can eliminate the almost
certainty that in the middle of your Angry Crane stance, as you transition
to your Combative Monkey to administer the Coup de Gras via your Ninja Death
Touch, you step on a beer bottle and fall backwards into the juke box and
get your head stove in by a drunk with a pool cue."  --Jay Trigg


> -Original Message-
> From: Armstead, Michael A [SMTP:[EMAIL PROTECTED]]
> Sent: Wednesday, May 23, 2001 10:39 AM
> To:   Multiple recipients of list ORACLE-L
> Subject:  MICROSOFTDTPROPERTIES
> 
> I have developers who have created this table. Now they've come to me to
> find out what the table does. I think it is used by the Microsoft
> Transaction Server software. Does anyone know for sure the purpose of the
> MICROSOFTDTPROPERTIES table?
> 
> Michael Armstead  
> Application Database Administrator, OCP-Certified
> US Pharmaceuticals IT
> Glaxo SmithKline
> 
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Armstead, Michael A
>   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).

Re: OT RE: Mailing lists hosted by fatcity

[Eric D. Pierce]

(putting down dust mop momentarily...)

well, that sounds just little bit unpleasant 
(david letterman imitation)

http://www.aeroseal.com/

   "If your duct system needs to be sealed, a patented
computer-controlled injection machine sends small dry
adhesive particles into the duct system and deposits
these particles directly on the edges of holes in your
ducts-bridging the cracks to create seals."

but at least it doesn't sound like you are going to be doing
any of your speedo impressions at the virtual party. :)

ep



On 23 May 2001, at 11:31, Mohan, Ross wrote:

Date sent:  Wed, 23 May 2001 11:31:30 -0800
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>

> Charlie Brown and Lucy are heading down to you
> right now in a Mir launch vehicle financed by
> Dennis Tito, carrying a scalpel and duct tape.
> 
> Hang in there, Snoopy!
> 
> || -Original Message-
> || From: Eric D. Pierce [mailto:[EMAIL PROTECTED]]
> || Sent: Wednesday, May 23, 2001 2:16 PM
> || To: Multiple recipients of list ORACLE-L
> || Subject: RE: Mailing lists hosted by fatcity
> || 
> || 
> || yes, but i was sad that i didn't see a list for beagle 
> || owning transgendered rocket launch console operators 
> || from antarctica.


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Eric D. Pierce
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Oracle DBA vs. Oracle Apps DBA - Different? and how?

[Scott . Shafer]

And managing the concurrent managers is an art in itself...

Scott Shafer
San Antonio, TX
210-581-6217

"And no amount of training or preparedness can eliminate the almost
certainty that in the middle of your Angry Crane stance, as you transition
to your Combative Monkey to administer the Coup de Gras via your Ninja Death
Touch, you step on a beer bottle and fall backwards into the juke box and
get your head stove in by a drunk with a pool cue."  --Jay Trigg

> -Original Message-
> From: Gary Weber [SMTP:[EMAIL PROTECTED]]
> Sent: Wednesday, May 23, 2001 5:16 PM
> To:   Multiple recipients of list ORACLE-L
> Subject:  RE: Oracle DBA vs. Oracle Apps DBA - Different? and how?
> 
> >>Sometimes I think Apps DBA is shorthand for senior developer.
> 
> I'd like to wholeheartedly disagree. Administering Financials fell onto my
> lap as "just another Oracle-based product". There is much more to knowing
> this package than meets the eye from DBA prospective. The technology stack
> alone, with database, forms, web server, code...arr
> 
> In my humble opinion, a good Apps DBA is not only proficient in database
> administration, but is also aware of large ERP packages and their
> implications.
> 
> Gary
> 
-- 
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).

Re: Oracle DBA vs. Oracle Apps DBA - Different? and how?

[Glen Mitchell]

I had the opportunity to meet the architect of Quest Software's "Spotlight
for Oracle Apps" product in a recent demo.  His opinion was that a
good Oracle Apps Administrator has a good understanding (and experience)
of the business/functional side of the Apps system.  That knowledge/experience
needs to be combined with experience in pure database administration and
operations.  The bits in between, forms and webserver etc..., can
be picked up along the way where proficiency is proportional to exposure
to the product.
From my limited experience with Oracle Apps I agreed with him due
to some of the differculties I experienced.  I was fortunate that
I could remove myself from the management of the apps system (which
was an auxilliary system to our main product development) and concentrate
on our core product which is based on the Oracle Server!  I'm lucky
I guess!!
Glen
Gary Weber wrote:
>>Sometimes I think Apps DBA is shorthand for senior
developer.
I'd like to wholeheartedly disagree. Administering Financials fell onto
my
lap as "just another Oracle-based product". There is much more to knowing
this package than meets the eye from DBA prospective. The technology
stack
alone, with database, forms, web server, code...arr
In my humble opinion, a good Apps DBA is not only proficient in database
administration, but is also aware of large ERP packages and their
implications.
Gary
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Gary Weber
  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).

-- 
Glen Mitchell   NZ Phone: +64 9 3730400
Energy Research Lab URL: http://www.peace.com
Peace Software  Email: [EMAIL PROTECTED]
 

Another Database Down

[Burton, Laura L.]

Title: Another Database Down





Well, I think the time for jubilation has been short-lived for me.  The production database was recovered successfully due to archiving and luck.  I also have a small, inhouse, remedy (help desk) database that I haven't done anything with and now recovery is necessary for it as well.  The bad news is I wasn't archiving, and although I do have a physical backup, the database was not down.

I restored the datafiles, control files, and redo logs so that everything would be for the same time, but when I try to open the database I get the error "cannot mount database in exclusive mode."  The error states that an instance already has it open in exclusive or parallel mode.  I am assuming this is because the database was not closed when the backup was executed. 

I have tried a few things to 'trick' it, but I guess my magic tricks are not good enough to fool the crowd.  I am already bracing myself for what I will probably read in response to this...but I am hopeful that someone will find that rabbit in the hat.

Thank you in advance,
Laura

NT-RE: Database Down-Dump and Mail Event Logs

[Scott Crabtree]

Title: RE: Database Down




Here some help from Paul Drake on NT 
diagnostics tools you can put in place to send yourself event 
logs.
Sample code to email event logs
C:\>blat -install mail.mydomain.com 
[EMAIL PROTECTED]
Failed to open registry key for Blat profile , using 
default.
SMTP server set to mail.mydomain.com on port 25 with user 
[EMAIL PROTECTED], retry
1 time(s)
C:\>dumpel -F my_app_log.txt -L Application -c
Dump successfully completed.
C:\>blat C:\my_app_log.txt -to 
[EMAIL PROTECTED]
Sending C:\my_app_log.txt to [EMAIL PROTECTED]
Login name is [EMAIL PROTECTED]

 
dumpel.exe - NT command to dump the event logs to file - NT 
Resource Kit.
The book Windows Admin Scripting describes this on pg 279. ISBN 
1-57610-881-3
D:\>dumpel /?
DumpEl usage:
-e nn Filters for event id nn (up to 10 may be 
specified)
-f  Output filename (default stdout)
-l  Dumps the specified log (system, application, 
security)
-b Dumps a backup file (use -l to specify file name)
-m  Filters for events logged by name
-r Filters out events logged by name (must use -m 
too)
-s  Remote to servername
-t Use tab to separate strings (default is space)
-c Use comma to separate fields
-ns Do not output strings
-format  Specify output format. Default format 
is
dtTCISucs
where
t - time
d - date
T - event type
C - event category
I - event ID
S - event source
u - user
c - computer
s - strings
blat.exe - NT freeware utility for sending mail with 
attachments
The book Windows Admin Scripting includes a routine to generate 
a spreadsheet of Backup Exec jobs using the Windows Scripting Host shell - but I 
haven't used WSH yet.
hth,
Paul

  -Original Message-From: Burton, Laura L. 
  [mailto:[EMAIL PROTECTED]]Sent: Wednesday, May 23, 2001 5:36 
  PMTo: Multiple recipients of list ORACLE-LSubject: RE: 
  Database Down
  Amen 
  Sister!!  I am afraid you all will have to be my virtual party people, 
  since I am the only one around here that got excited when the recovery was 
  done...so have a great time!!
   
  Laura :)
  
-Original Message-From: Jacques Kilchoer 
[mailto:[EMAIL PROTECTED]]Sent: Wednesday, May 23, 2001 
3:12 PMTo: Multiple recipients of list 
ORACLE-LSubject: RE: Database Down
>-Original Message- >From: Burton, Laura L. [mailto:[EMAIL PROTECTED]] 
> >My database is up and with 
no data loss!!! 
Congratulations! I've done the exercises in Rama Velpuri's 
book, but when it comes to a live situation, it's a little more 
scary.
So where's the party? 

Re: 8.1.7. and OAS / iAS versions confusion

[Diana_Duncan]

Oracle HAD to rename it -- they have consistently changed the name with
each release, so they couldn't stop now!

A brief history, from what I remember:

Oracle Webserver 1.x
Oracle Web Application Server 2.x
Oracle Web Application Server 3.x? (whoops, I guess they kept it once,
anyway I can't really remember what that one was called, it crashed pretty
much constantly)
Oracle Application Server 4.x
WebDB (really built on OAS 4, an addon of sorts)
8i Oracle Application Server (from 4 to 8 :)
9i Application Server
Oracle Portal (built on 9iAS, was it also built on 8iOAS?)

These are all mostly the same in their foundation technology, and are
really dot-releases of the same product.  Funny.

Diana Duncan
TITAN Technology Partners
One Copley Parkway, Ste 540
Morrisville, NC  27560
VM: 919.466.7337 x 316
F: 919.466.7427
E: [EMAIL PROTECTED]


   
   
"Marc Perkowitz"   
   
   
lting.com>  cc:
   
Sent by:Fax to:
   
[EMAIL PROTECTED]Subject: Re: 8.1.7. and OAS / iAS 
versions confusion  
   
   
   
   
05/23/2001 04:30 PM
   
Please respond to  
   
ORACLE-L   
   
   
   
   
   




9i iAS == 8i OAS.  Oracle renamed 8i 1.0 to 9i 1.0.  Version numbers are
consistent.

Marc Perkowitz
Senior Consultant
TWJ Consulting, LLP

847-256-8866 x15
www.twjconsulting.com

- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, May 23, 2001 10:27 AM


OK, now I'm puzzled.

About 3 weeks ago Oracle mailed me a copy of 8.1.7. at home, along with the
9i iAS.

The iAS documentation refers to 8i OAS (version 1.0.1), it says we can
"migrate" from 8i OAS to iAS.

Does this mean if I had installed 8i OAS (v. 1.0.1), I could apply a patch
to bring it up to v.1.02 (9i iAS?)

Is iAS iAS, or is it OAS??  If iAS is not OAS, why do they have the same
version numbers?

Does iAS go with 8.1.7, or 9i?

If 8i OAS goes with 8.1.7, how come Oracle never sent me a copy of 8i OAS?
Weren't they excited about that product as well?

When we receive the media for 8.1.7 here, will we receive from Oracle 8i
OAS
to go with it, or 9i iAS?

When Oracle 9i is released, will there be another version of iAS to go
along
with it?

I wish the versions matched, but I guess when you're a big company it's
hard
to release the different packages in synch.

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] 

Ph: (902) 426-4774



-Original Message-
Sent: Wednesday, May 23, 2001 5:26 AM
To: Multiple recipients of list ORACLE-L

I wish that I could be like some of U where your job is to solely
tune/backup database etc. Although I am a "DBA", I feel that I am a
5% DBA
and 95% developer.  I've just migrated our in-house customized
System to the
newly acquired Oracle HR System (oracle workflow).  In top of that,
I am
also maintaining certain in-house Oracle systems. 95% of my time is
spent on
development.

I think that it's great to learn so many tools, Oracle Workflow,
Forms,
Reports, Graphics etc but I wish that I have more time to tune the
database.
Besides, cloning database, backup database, applying oracle patches
to the
HR System, all of my time is spent in development.

Regds,
New DBA
-Original Message-
[mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 22, 2001 10:06 PM
To: Multiple recipients of list ORACLE-L
them!)

I don't know about this development business.  I
think about
this a lot (I
don't have a life).

I keep an eye on Developer, Jdeveloper, Cherokee

RE: Deleting Files in NT

[Guidry, Chris]

Hello,
You can use FORFILES from the NT Resource kit or you can
download it from Dave Sisk's Web site
http://www.ipass.net/~davesisk/oont_download.htm

Your command will look like:
FOREFILES -p -m*.* -c"CMD /C del @FILE -d-7 -v



C:\>forfiles
FORFILES v 1.1 - [EMAIL PROTECTED] - 4/98


Syntax : FORFILES [-pPath] [-mSearch Mask] [-ccommand]
[-d<+|->] [-s]

 -pPath   Path where to start searching
 -mSearch MaskSearch files according to 
 -cCommandCommand to execute on each file(s)
 -d<+|-> Select files with date >= or <=DDMM (UTC)
  or files having date >= or <= (current date - DD days)
 -s   Recurse directories
 -v   Verbose mode

The following variables can be used in Command :
 @FILE, @FNAME_WITHOUT_EXT, @EXT, @PATH, @RELPATH, @ISDIR, @FSIZE, @FDATE,
 @FTIME

To include special hexa characters in the command line : use 0xHH

Default :
Examples :
FORFILES -pc:\ -s -m*.BAT -c"CMD /C Echo @FILE is a batch file"
FORFILES -pc:\ -s -m*.* -c"CMD /C if @ISDIR==TRUE echo @FILE is a directory"
FORFILES -pc:\ -s -m*.* -d-100 -c"CMD /C Echo @FILE : date >= 100 days"
FORFILES -pc:\ -s -m*.* -d-01011993 -c"CMD /C Echo @FILE is quite old!"
FORFILES -pc:\ -s -m*.* -c"CMD /c echo extension of @FILE is 0x22@EXT0x22"

--
Chris J. Guidry  P.Eng.
ATCO Electric, Metering Services
Phone: (780) 420-4142
Fax: (780) 420-3854
Email: [EMAIL PROTECTED]

> -Original Message-
> From: Raj Gopalan [SMTP:[EMAIL PROTECTED]]
> Sent: Wednesday, May 23, 2001 09:45 AM
> To:   Multiple recipients of list ORACLE-L
> Subject:  Deleting Files in NT
> 
> DBAs
> 
> How do I delete files from NT which are older than a week. I need this to
> organise my backup dump files.
> 
> Cheers
> 
> Raj
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Raj Gopalan
>   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: 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).

RE:Deleting Files in NT

[Scott Crabtree]

Raj,
If you have the resource kit installed you can use forfiles.

forfiles -pp:\zipfiles\hot\ -s -m*.* -d-20052001 -c"CMD /C DEL /Q @FILE";

Forfiles is helpful for ton's of DB Maintenance, you can pipe the results to
any dos command you want.

We use a statement like the one below in our spool_Hot_Backup script

to prune the backup directories before we put all the tablespaces in hot
backup mode and ocopy them, We then compress them in a staging directory
using pacomp and move them to a drive so that last nights datafiles are
around for a speedy recovery (If Necessary).  

 /* Clean Out ZIP Files older than two days: Uses Forfiles Resource
Kit*/
  select to_char(sysdate-2,'ddmm') into datestr from dual;
 dbms_output.put_line('host forfiles -p'||backupdir||' -s -m*.*
-d-'||datestr||
' -c'||chr(34)||'CMD /C DEL /Q @FILE'||chr(34)||';');

HTH, (hazardous terminal halitosis)

Scott Crabtree



-Original Message-
Sent: Wednesday, May 23, 2001 11:45 AM
To: Multiple recipients of list ORACLE-L


DBAs

How do I delete files from NT which are older than a week. I need this to
organise my backup dump files.

Cheers

Raj
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Raj Gopalan
  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: Scott Crabtree
  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: MICROSOFTDTPROPERTIES

[Jim Hawkins]

I think we've stumbled on to something...

SQL>  desc MICROSOFTDPROPERTIES;
NameNull?Type
---  
PROPERTY_ID  NUMBER(38,0)
FIRST_CRASH_DATE DATE
NEXT_CRASH_DATE  DATE
TOTAL_CRASH_NUMBER_SETTING   LONG
NONSENSICAL_HEX_ERROR_CODE   VARCHAR2(38)
CRASH_INTERVAL_SECONDS   NUMBER(38,0)
SECURITY_LOOPHOLE_ID NUMBER(38,0)
SECURITY_LOOPHOLE_DESC   VARCHAR2(250)
AUTO_DATA_PURGE_INTERVAL_SECONDS NUMBER(38,0)
AUTO_DATA_CORRUPT_INTERVAL_SECONDS   NUMBER(38,0)



> I have developers who have created this table. Now they've come to me to
> find out what the table does. I think it is used by the Microsoft
> Transaction Server software. Does anyone know for sure the purpose of the
> MICROSOFTDTPROPERTIES table?
> 
> Michael Armstead  
> Application Database Administrator, OCP-Certified
> US Pharmaceuticals IT
> Glaxo SmithKline
> 
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Armstead, Michael A
>   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).
> 
> 


-- 
Jim Hawkins
Lead SAPR/3 Oracle Database Administrator
MEMC Electronic Materials, Inc.
600 Pearl Drive
St. Louis, MO  633376
9636) 474-7832
[EMAIL PROTECTED] (work)
[EMAIL PROTECTED] (home)

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jim Hawkins
  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: Drop 'NOT NULL' Constraint

[Kevin Kostyszyn]

I think that if there is already data in the column you will not be able to
do that.

-Original Message-
Sent: Wednesday, May 23, 2001 5:15 PM
To: Multiple recipients of list ORACLE-L


I created a table with a 'NOT NULL' constraint on a VARCHAR2 column.  I
would like to remove the NOT NULL constraint.  I've tried a couple of
'ALTER TABLE' commands but no luck.

How does one do this?

Also:

How does one figure out which generated constraints (from
user_constraints) do what?

Chris Rezek
Database Administrator
DotClick
http://www.dotclick.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Chris Rezek
  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: Kevin Kostyszyn
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Oracle DBA vs. Oracle Apps DBA - Different? and how?

[Dasko, Dan]

Sometimes I think Apps DBA is shorthand for senior developer.

-Original Message-
Sent: Wednesday, May 23, 2001 11:28 AM
To: Multiple recipients of list ORACLE-L


I would be interested in hearing your opinions on the differences between an
Oracle DBA and an Oracle Apps DBA.  Are they different?  And how?  Are they
so different that one could not perform the duties of another?  Learning
curve for each?

My interest was sparked when I interviewed with a company that had
advertised for a senior Oracle DBA.  It become known in the interview that
they were moving legacy apps to Oracle Apps (Financial, HR) and were in need
of an Apps DBA.  I have no experience using these products.  But I did tell
them I have over 10 years experience as a DBA, using all 4 major DBMS
engines on 4 different unix platofrms.  Should that be taken into account?
I feel I could easily learn Apps DBA duties as I have learned other DBMS's.
They still wanted an experienced Apps DBA and said they have a current DBA
who is 'learning on the fly'.

Caught in a catch-22.  Can't get experience with Apps because can't get
hired, BUT can't get hired without experience...

Opinions?

-- 
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).

_
This e-mail message has been scanned for the presence of all known computer
viruses by the MessageLabs Virus Control Center.  However, it is still
recommended that you use local virus scanning software to monitor for the
presence of viruses.  
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Dasko, Dan
  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).

troubleshoot broken pipe

[Francis, Rick]

Title: troubleshoot broken pipe





hi,


OS=sol8
ora_ver=8i
model=420r


what can i do to troubleshoot this problem?


Wed May 23 10:40:17 CDT 2001:  java.sql.SQLException: Io exception: Broken pipe
    at java.lang.Throwable.fillInStackTrace(Native Method)
    at java.lang.Throwable.fillInStackTrace(Compiled Code)
    at java.lang.Throwable.(Compiled Code)
    at java.lang.Exception.(Compiled Code)
    at java.sql.SQLException.(Compiled Code)
    at oracle.jdbc.dbaccess.DBError.throwSqlException(Compiled Code)
    at oracle.jdbc.dbaccess.DBError.throwSqlException(Compiled Code)
    at oracle.jdbc.driver.OracleStatement.(Compiled Code)
    at oracle.jdbc.driver.OracleConnection.privateCreateStatement(Compiled Code)
    at oracle.jdbc.driver.OracleConnection.createStatement(Compiled Code)
    at weblogic.jdbc.pool.Connection.createStatement(Compiled Code)
    at weblogic.jms.server.JDBCStore.purgeMessages(Compiled Code)
    at weblogic.jms.server.JDBCStore.trigger(Compiled Code)
    at weblogic.time.common.internal.ScheduledTrigger.executeLocally(Compiled Code)
    at weblogic.time.common.internal.ScheduledTrigger.execute(Compiled Code)
    at weblogic.time.server.ScheduledTrigger.execute(Compiled Code)
    at weblogic.kernel.ExecuteThread.run(Compiled Code)


to fix it, i had to restart the instance; major causes...hints!


rf




The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material.  Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited.  If you received this in error, please contact the sender and delete the material from any computer.

Re: Reverse engineer tablespaces.

[Rachel Carmichael]

from the Annotated Archives:  (enter % when asked for the name of the 
tablespace and it will generate all of them)


set echo off term on verify off feedback off pagesize 0
select 'Creating tablespace build script...' from DUAL;

accept tablespace_name prompt "Enter the name of the tablespace: "
set term off

drop table TSPACE_TEMP;

create table TSPACE_TEMP (
Lineno  NUMBER,
Tspace_Name VARCHAR2(30),
TextVARCHAR2(500))
/

declare
   cursor TSPACE_CURSOR is
 select Tablespace_Name,
Initial_Extent,
Next_Extent,
Min_Extents,
Max_Extents,
Pct_Increase,
Min_Extlen,
Status,
Contents,
Logging
   from DBA_TABLESPACES
  where Tablespace_Name !='SYSTEM';

   cursor DFILE_CURSOR (C_Tablespace_Name VARCHAR2) is
 select Maxbytes,
Increment_By,
File_Name,
Bytes,
Status,
Autoextensible
   from DBA_DATA_FILES
  where Tablespace_Name = C_Tablespace_Name
  order by File_ID;


   Lv_TS_Tablespace_Name  DBA_TABLESPACES.Tablespace_Name%TYPE;
   Lv_TS_Initial_Extent   DBA_TABLESPACES.Initial_Extent%TYPE;
   Lv_TS_Next_Extent  DBA_TABLESPACES.Next_Extent%TYPE;
   Lv_TS_Min_Extents  DBA_TABLESPACES.Min_Extents%TYPE;
   Lv_TS_Max_Extents  DBA_TABLESPACES.Max_Extents%TYPE;
   Lv_TS_Pct_Increase DBA_TABLESPACES.Pct_Increase%TYPE;
   Lv_TS_Min_Extlen   DBA_TABLESPACES.Min_Extlen%TYPE;
   Lv_TS_Status   DBA_TABLESPACES.Status%TYPE;
   Lv_TS_Contents DBA_TABLESPACES.Contents%TYPE;
   Lv_TS_Logging  DBA_TABLESPACES.Logging%TYPE;

   Lv_DF_Maxbytes DBA_DATA_FILES.Maxbytes%TYPE;
   Lv_DF_Increment_By DBA_DATA_FILES.Increment_By%TYPE;
   Lv_DF_File_NameDBA_DATA_FILES.File_Name%TYPE;
   Lv_DF_BytesDBA_DATA_FILES.Bytes%TYPE;
   Lv_DF_Status   DBA_DATA_FILES.Status%TYPE;
   Lv_DF_Autoextensible   DBA_DATA_FILES.Autoextensible%TYPE;

   Lv_String  VARCHAR2(800);
   Lv_Lineno  NUMBER  := 0;
   Lv_DF_CountNUMBER;
   Lv_Block_Size  NUMBER;

   procedure WRITE_OUT(P_Line INTEGER,  P_Tablespace VARCHAR2,
   P_String VARCHAR2)
   is
   begin
  insert into TSPACE_TEMP (Lineno, Tspace_name, Text)
 values (P_Line,P_Tablespace,P_String);
   end;

begin

   select Value
 into Lv_Block_size
 from SYS.V_$PARAMETER
where upper(name) = 'DB_BLOCK_SIZE';

   open TSPACE_CURSOR;
   loop
  fetch TSPACE_CURSOR into Lv_TS_Tablespace_Name,
   Lv_TS_Initial_Extent,
   Lv_TS_Next_Extent,
   Lv_TS_Min_Extents,
   Lv_TS_Max_Extents,
   Lv_TS_Pct_Increase,
   Lv_TS_Min_Extlen,
   Lv_TS_Status,
   Lv_TS_Contents,
   Lv_TS_Logging;
  exit when TSPACE_CURSOR%NOTFOUND;

  Lv_Lineno := 1;
  Lv_DF_Count := 0;
  Lv_String := 'CREATE TABLESPACE ' || LOWER(Lv_TS_Tablespace_Name);
  WRITE_OUT(Lv_Lineno, Lv_TS_Tablespace_Name, Lv_String);
  Lv_Lineno := Lv_Lineno + 1;


  open DFILE_CURSOR (Lv_TS_Tablespace_Name);

  loop
 fetch DFILE_CURSOR intoLv_DF_Maxbytes,
Lv_DF_Increment_By,
Lv_DF_File_Name,
Lv_DF_Bytes,
Lv_DF_Status,
Lv_DF_Autoextensible;
 exit when DFILE_CURSOR%NOTFOUND;
 Lv_DF_Count := Lv_DF_Count + 1;

 if (Lv_DF_Count > 1)
 then
  Lv_String := ',''';
 else
Lv_String := 'DATAFILE ''';
 end if;

 Lv_String := Lv_String || Lv_DF_File_Name
|| ''' SIZE '
|| (Lv_DF_Bytes)/1024 ||'K' ;

 Lv_String := Lv_String || ' REUSE ';

 WRITE_OUT(Lv_Lineno, Lv_TS_Tablespace_Name, Lv_String);
 Lv_Lineno := Lv_Lineno + 1;

 if (Lv_DF_Autoextensible = 'YES')
 then
  Lv_String := 'AUTOEXTEND ON NEXT '
|| (Lv_DF_Increment_By * Lv_Block_Size)/1024
 || 'K MAXSIZE '
 || (Lv_DF_Maxbytes/1024)
 || 'K';

 WRITE_OUT(Lv_Lineno, Lv_TS_Tablespace_Name, Lv_String);
 Lv_Lineno := Lv_Lineno + 1;
 end if;
  end loop;
  close DFILE_CURSOR;

  Lv_String := 'DEFAULT STORAGE ';
  WRITE_O

Re: Reverse engineer tablespaces.

[Rodd Holman]

Actually this version will create your tablespaces with the same 
structure and file_id's as your current db.

select 'create tablespace '||a.tablespace_name||
   ' datafile '||||b.file_name||||' size '||b.bytes/(1024 * 
1024)||'M'||
   ' default storage ( initial '||a.initial_extent||
 ' next '||a.next_extent||
 ' pctincrease '||a.pct_increase||
 ' maxextents '||a.max_extents||');'
from   dba_tablespaces a,
   dba_data_files b
where  a.tablespace_name = b.tablespace_name
order by b.file_id;

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Rodd Holman
  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: disk information alert

[Glenn Travis]

Here is mine;
NOTE: This is for solaris and reference the /etc/vfstab file for
verification, but you can take that out.
NOTE2: Change email address.

HTH!
__

#!/bin/ksh
#
#-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+
#   Purpose:
#   To monitor filesystem usage.
#
#   If the filesystem is over the specified
#   threshold, an email will be sent.
#
#   Parameters:
#   $1 - email to send notification to.
#   $2 - filesystem to check:%full threshold.
#   $x - filesystem to check:%full threshold.
#-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+

if [ $# -lt 2 ]
thenecho "Syntax: $0  ."
echo "Example: $ chkfilesystem.ksh [EMAIL PROTECTED] /tmp:95
/export/home:80 /export/tools:90 ..."
exit 1
fi

TMPFIL=/tmp/chkfilesystem.tmp.$$
HST=`hostname`

EMAIL=$1
shift

while [ "$1" != "" ]
do
FILESYS=`echo $1 | cut -f1 -d':'`
THRESHOLD=`echo $1 |cut -f2 -d':'`

grep "$FILESYS" /etc/vfstab > /dev/null 2>&1
if [ $? -ne 0 ]
thenecho "Filesystem $FILESYS does not exist on $HST."
exit 1
fi

echo "Checking $FILESYS > ${THRESHOLD}%..."  | tee $TMPFIL

pctg=`df -k | grep -i $FILESYS | awk '{print $5}' | tr -d %`

if [ $pctg -gt $THRESHOLD ]
thenecho "$FILESYS filesystem on $HST is ${pctg}% full."
df -k $FILESYS | tee -a $TMPFIL
mailx -s "$FILESYS on $HST ${pctg}% full!!  Please
investigate." $EMAIL < $TMPFIL
rm $TMPFIL
fi

shift
done


-Original Message-
Sent: Wednesday, May 23, 2001 9:36 AM
To: Multiple recipients of list ORACLE-L


Hi Gurus
Does any one having scripts to know disk space once particular partion =>75%
let assume the below is not exact output of df -k command
$df -k

/u0168
/u0240
/u0353
/u0476
As the disk partition reach to 75% or more.We need to get email alert.
If some have such kind of script let me know.

Thanks
-seema

_
Get your FREE download of MSN Explorer at http://explorer.msn.com

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Seema Singh
  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).

RE: ULIMIT setting: Urgent Please Help

[Shantanu Talukder]

In IBM-AIX you can set ulimit unlimited. If I remember
correctly, go to /etc/security/ and open 'limit' file
then you can make an entry like :

# -1 is for unlimited.

ulimit = -1 



Shantanu Talukder
Lead DBA,
Tririga.
Las Vegas,NV 89103










--- "Mohan, Ross" <[EMAIL PROTECTED]> wrote:
> get yer SA to de-shackle you.
> 
> || -Original Message-
> || From: Viraj Luthra [mailto:[EMAIL PROTECTED]]
> || Sent: Wednesday, May 23, 2001 11:19 AM
> || To: Multiple recipients of list ORACLE-L
> || Subject: ULIMIT setting: Urgent Please Help
> || 
> || 
> || Hello all,
> || 
> || I am trying to install oracle 8.0.5.0.0 on SCO
> Unix Ware 7.1.1. 
> || 
> || While trying to install Oracle, the Oracle
> Installer bombs 
> || out, because it says that my ulimit is not high
> enough. It 
> || needs the ulimit to be 2113674. But my hard limit
> of ulimit 
> || is 2097152. This figure is less than what Oracel
> needs.
> || 
> || Now I have tried to put ULIMIT=unlimited in the 
> || /etc/default/login file but this is of no use.
> Also I have 
> || tried to set 
> || 
> ||ulimit unlimited
> || 
> || but at the unix prompt I get the error that, the
> value is 
> || exceeded and I cannot set the value as unlimited.
> || 
> || Now can you please help me in trying to set the
> value as 
> || unlimited some how so that the oracle installer
> does not get 
> || object, and I can install the product.
> || 
> || Thanks and Regards,
> || 
> || Raja
> || 
> || 
> || 
> || Get 250 color business cards for FREE!
> || http://businesscards.lycos.com/vp/fastpath/
> || -- 
> || Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> || -- 
> || Author: 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: 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).


__
Do You Yahoo!?
Yahoo! Auctions - buy the things you want at great prices
http://auctions.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Shantanu Talukder
  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: MICROSOFTDTPROPERTIES

[Kevin Kostyszyn]

that was great


-Original Message-
Sent: Wednesday, May 23, 2001 5:36 PM
To: Multiple recipients of list ORACLE-L




I think we've stumbled on to something...

SQL>  desc MICROSOFTDPROPERTIES;
NameNull?Type
---  
PROPERTY_ID  NUMBER(38,0)
FIRST_CRASH_DATE DATE
NEXT_CRASH_DATE  DATE
TOTAL_CRASH_NUMBER_SETTING   LONG
NONSENSICAL_HEX_ERROR_CODE   VARCHAR2(38)
CRASH_INTERVAL_SECONDS   NUMBER(38,0)
SECURITY_LOOPHOLE_ID NUMBER(38,0)
SECURITY_LOOPHOLE_DESC   VARCHAR2(250)
AUTO_DATA_PURGE_INTERVAL_SECONDS NUMBER(38,0)
AUTO_DATA_CORRUPT_INTERVAL_SECONDS   NUMBER(38,0)



> I have developers who have created this table. Now they've come to me to
> find out what the table does. I think it is used by the Microsoft
> Transaction Server software. Does anyone know for sure the purpose of the
> MICROSOFTDTPROPERTIES table?
> 
> Michael Armstead  
> Application Database Administrator, OCP-Certified
> US Pharmaceuticals IT
> Glaxo SmithKline
> 
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Armstead, Michael A
>   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).
> 
> 


-- 
Jim Hawkins
Lead SAPR/3 Oracle Database Administrator
MEMC Electronic Materials, Inc.
600 Pearl Drive
St. Louis, MO  633376
9636) 474-7832
[EMAIL PROTECTED] (work)
[EMAIL PROTECTED] (home)

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jim Hawkins
  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: Kevin Kostyszyn
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Oracle DBA vs. Oracle Apps DBA - Different? and how?

[Gary Weber]

>>Sometimes I think Apps DBA is shorthand for senior developer.

I'd like to wholeheartedly disagree. Administering Financials fell onto my
lap as "just another Oracle-based product". There is much more to knowing
this package than meets the eye from DBA prospective. The technology stack
alone, with database, forms, web server, code...arr

In my humble opinion, a good Apps DBA is not only proficient in database
administration, but is also aware of large ERP packages and their
implications.

Gary

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Gary Weber
  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: Database Down

[Rachel Carmichael]

Jared,

as I understand it, the original controlfile allows you to recover until the 
SCN's all match the one in the controlfile.  A backup controlfile assumes 
that you are not certain of what the final SCN is and so allows you to 
continue recovering past the backup time.

I *think* this is the premise behind the standby controlfile. I know that 
you could mimic standby in earlier versions of 7 by doing this.. and just 
recovering until you decided to stop moving archive logs over.

Warning though -- you WILL have to open with resetlogs if you use the backup 
controlfile because Oracle won't be able to tell when it should assume 
recovery is complete.

Rachel


>From: Jared Still <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: Re: Database Down
>Date: Wed, 23 May 2001 08:31:50 -0800
>
>On Wednesday 23 May 2001 01:00, Paul Drake wrote:
> >
> > 0. caffeine.
>
>Agreed.
>
> > 2. You *will* be performing incomplete recovery. Recover until cancel,
> > preferably with a backup controlfile.
> >Did you create a backup controlfile as part of the hot backup on May
> > 11th? Restore with that controlfile.
>
>Is there a particular reason for recommending the backup controlfile?
>
>Shouldn't be needed unless the controlfile has been lost.
>
> > 3. After the recovery is completed (you've opened RESETLOGS) close the
> > database and get a *full* cold backup. Fight the urge to *get the
>
>Some repetition for emphasis here.  As Paul says, a cold backup must be
>completed before any work is done on the database.
>
>
>Some add'l advice for Laura.  Read Rama Velpuri's book 'Oracle Backup
>and Recovery Handbook' cover to cover, and do all of the exercises.  It
>will make an immense difference in your understanding of recovery.
>
>Backup is easy, recovery is not always so.
>
>Jared
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Jared Still
>   INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>San Diego, California-- Public Internet access / Mailing Lists
>
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from).  You may
>also send the HELP command for other information (like subscribing).

_
Get your FREE download of MSN Explorer at http://explorer.msn.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rachel Carmichael
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Oracle Reports coredump

[Dasko, Dan]

Well, I can't comment specifically on that hardware.  I've got 6.? but not
6i server running on a WinNT server and no problems, then I've had both 2.?
and 6.? tools running on a WinNT workstation with no problems.  If you have
a workstation that you can use, isn't the windows version available at
technet?

Dan

-Original Message-
Sent: Wednesday, May 23, 2001 11:27 AM
To: Multiple recipients of list ORACLE-L


Dan,

I have the 6i version on HP-UX 11.0. It's all on one machine. I'm just
trying to create some sample reports to familiarize myself with the product.
It seems to coredump from time to time for no apparent reason.


Bill Carle
AT&T
Database Administrator
816-995-3922
[EMAIL PROTECTED]

 -Original Message-
Sent:   Tuesday, May 22, 2001 5:21 PM
To: Multiple recipients of list ORACLE-L
Subject:RE: Oracle Reports coredump

No, I've been using reports for a couple of years and never had that
behavior.  Which version which part?  Is it the client side or the server
side?

Dan

-Original Message-
Sent: Tuesday, May 22, 2001 5:16 PM
To: Multiple recipients of list ORACLE-L


Hi,

I recently installed Oracle Reports and I'll work fine for a while. Then
I'll get a coredump. Has anyone else had a problem with that and know what
might be wrong?


Bill Carle
AT&T
Database Administrator
816-995-3922
[EMAIL PROTECTED]

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Carle, William T (Bill), NLCIO
  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).

_
This e-mail message has been scanned for the presence of all known computer
viruses by the MessageLabs Virus Control Center.  However, it is still
recommended that you use local virus scanning software to monitor for the
presence of viruses.  
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Dasko, Dan
  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: Carle, William T (Bill), NLCIO
  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).

_
This e-mail message has been scanned for the presence of all known computer
viruses by the MessageLabs Virus Control Center.  However, it is still
recommended that you use local virus scanning software to monitor for the
presence of viruses.  
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Dasko, Dan
  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: Database Down

[Burton, Laura L.]

Title: RE: Database Down




Amen 
Sister!!  I am afraid you all will have to be my virtual party people, 
since I am the only one around here that got excited when the recovery was 
done...so have a great time!!
 
Laura 
:)

-Original Message-From: Jacques Kilchoer 
[mailto:[EMAIL PROTECTED]]Sent: Wednesday, May 23, 2001 
3:12 PMTo: Multiple recipients of list 
ORACLE-LSubject: RE: Database Down
>-Original Message- >From: Burton, Laura L. [mailto:[EMAIL PROTECTED]] 
> >My database is up and with 
no data loss!!! 
Congratulations! I've done the exercises in Rama Velpuri's 
book, but when it comes to a live situation, it's a little more 
scary.
So where's the party? 

RE: help me : error on import

[Shantanu Talukder]

Go to metalink and look for 
Doc ID: Note:60134.1
Note:48644.1 Note:15095.1

Those documents have answers to your question and lot
more.



-Shantanu Talukder
Lead DBA,
TRIRIGA,
Las Vegas,NV 89103

--- "Daemen, Remco" <[EMAIL PROTECTED]> wrote:
> It has to do with your NLS environment settings. If
> you're on unix, make
> sure the NLS_LANG variable is set to the same value
> as it was during the
> export.
> 
> HTH,  Remco
> 
> -Oorspronkelijk bericht-
> Van: benajam lhoussain [mailto:[EMAIL PROTECTED]]
> Verzonden: dinsdag 22 mei 2001 19:00
> Aan: Multiple recipients of list ORACLE-L
> Onderwerp: help me : error on import 
> 
> 
> 
> Export file created by EXPORT:V08.01.07 via
> conventional path
> import done in WE8ISO8859P1 character set and
> WE8ISO8859P1 NCHAR character
> set
> IMP-00069: Could not convert to environment national
> character set's handle
> IMP-0: Import terminated unsuccessfully
> 
> thanks
> 
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> -- 
> Author: benajam lhoussain
>   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: Daemen, Remco
>   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! Auctions - buy the things you want at great prices
http://auctions.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Shantanu Talukder
  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: (Fwd) Wilber/Shambala interview ("transideological" social trends)

[Eric D. Pierce]

worship godesses that can create rifts in the space/time continuum. :) no, 
it is just an "addiction" caused by reading the Whole Earth Catalog when I 
was a little kid back in the 1960s. 

http://www.edge.org/documents/digerati/Brand.html
-
http://www.duhcentral.com/mis/curriculum.htm

---excerpt---


IDEAS: 
cybernetics, understanding whole systems, tool, ecology 

NOTES: Stewart Brand was running around in the mid-sixties (when NASA had 
taken its first satellite photos of the earth with the entire round profile 
in the frame but wouldn't release them to the public), handing out protest 
buttons which said, "WHY HAVEN'T WE SEEN THE WHOLE EARTH?" And sure enough, 
when detailed color pictures taken by the Apollo Eight crew of our home 
planet were published right after Christmas 1968, they galvanized the 
public and helped in the popularization of the ecology movement. As Joni 
Mitchell sang: 

   "In a highway service station, over the month of June, Was a photograph 
of the Earth taken coming back from the Moon. And you couldn't see a city 
on that marble bowling ball, Or a forest or a highway, or me the least of 
all." 

It was this type of romanticization of the Whole Earth which lead me to the 
Whole Earth Catalog. Actually, the WEC (as it calls itself) began as a mail-
 order catalog for back-to-the-land communes, but it had an eccelctic, 
holistic view that quickly took it into cybernetcis and systems theory, and 
I followed. As I explained in the introduction, these "catalogs" edited by 
Stewart Brand first introduced me to most of the ideas and thinkers listed 
in this essay. 

QUOTE: The WHOLE EARTH CATALOG got started in a plane over Nebraska in 
March 1968. I was returning to California from my father's long dying and 
funeral that morning in Illinois. The sun had set ahead of the plane while 
I read Spaceship Earth by Barbara Ward. Between chapters I gazed out the 
window into dark nothing and slid into a reverie about my friends who were 
starting their own civilization hither and yon in the sticks and how could 
I help. The L. L. Bean catalog of outdoor stuff came to mind and I pondered 
upon Mr. Bean's service to humanity over the years. So many of the problems 
I could identify came down to a matter of access. Where to buy a windmill. 
Where to get good information about bee-keeping. Where to lay hands on a 
computer without forfeiting freedom... Shortly I was fantasizing access 
service. A Truck Store, maybe, travelling around with information and 
samples of what was worth getting and information where to get it. A 
Catalog too, continuously updated, in part by the users. A Catalog that 
owed nothing to the suppliers and everything to the users. It would be 
something I could put some years into. Amid the fever I was in by this 
time, I remembered Fuller's admonition that you have about 10 minutes to 
act on an idea before it recedes back into dreamland. I started writing on 
the end papers of Barbara Ward's book (never did finish reading it). ... 
Understanding whole systems is knowing how to fly. You can rise above local 
circumstances, travel with blurring speed, and set down in a place wholly 
distant, strange and wonderful. Or maybe not so wonderful, in which case 
you best know how to take off in a tight situation, and remember where home 
is. The price you pay for understanding is the grim knowledge of trade-offs 
in design. That you can have an airplane that goes fast or one that lands 
in 200 ft., but not both. That to save these people you may have to starve 
those people. By and by you dwell in a wilderness of conflicting 
considerations. If you survive your wishful solutions -- and there's 
usually margin -- you may become a wily and sky-hooked metaphysician. The 
solutions are always meta. The means always funky field expedient. ... 
Evolution and cybernetics are going to come together. This is the edge of 
knowledge right now, and it's right at the heart of education, and the 
schools don't know it. 

[-- all from The Last Whole Earth Catalog, 1971]  
{HYPERLINK "https://www.well.net/mwec/home.html"}

---end---

regards,
ep  

ps, one day I *will* own the 2 volume OED!!!

On 23 May 2001, at 7:19, Mark Leith wrote:


> ... where do you get all the time from to collate this
> extraordinarily extensive yet thoroughly interesting psycho babble? :)

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Eric D. Pierce
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (lik

how to export two full schemas and one partial schema into one dump file?

[Guang Mei]

Oracle : 8.1.5
Platform : Sun

Hi:

I have three schemas say A, B and C in one instance. I want to export full 
schema A and B, and also only some tables (say T1 and T2) in schema C into 
ONE dump file, and using only ONE par file. By the way, since the dump file 
is large (>2GB), I am using compress script.

I tried a par file

snip...
OWNER = ( A, B, C)
TABLES = (T1, T2)
...


But I got error

EXP-00026: conflicting mode specified.


Any work around?

Thanks.
_
Get your FREE download of MSN Explorer at http://explorer.msn.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Guang Mei
  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: Automatic password locking

[Connor McDonald]

You can audit logons to get to logon/logoff time, or
create an on-logon trigger on the database (8i+) to
store the logon time once you have unlocked the
account

hth
connor

--- "Yttri, Lisa" <[EMAIL PROTECTED]> wrote: > Hi
everyone -
> 
> I am trying to implement a process on our production
> servers.  If requested
> for emergencies, an id is automatically unlocked. 
> This id was previously
> defined with all access (select, insert, update,
> delete) to all objects in a
> schema.   I want this id to be active for only 4
> hours, then I would like it
> to automatically get locked.
> 
> Is there any information maintained in oracle as to
> the length of time a
> user id has been unlocked (or active)?  I could then
> query that column and
> once it was over 4 hours, I could terminate any
> active sessions using that
> id and lock it.
> 
> If I audit this id, would there be useful
> information in the audit tables
> regarding length of use?
> 
> Any help - or other ideas to accomplish this - would
> be greatly appreciated.
> 
> Thanks -
> lisa
> 


=
Connor McDonald
http://www.oracledba.co.uk (mirrored at 
http://www.oradba.freeserve.co.uk)

"Some days you're the pigeon, some days you're the statue"


Do You Yahoo!?
Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk
or your free @yahoo.ie address at http://mail.yahoo.ie
-- 
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).

RE: Create Table performance problem

[Jack C. Applewhite]

AFAIK the Select in a Create Table statement is treated exactly the same as
if it were issued by itself.  The Optimizer will decide whether or not
indexes on the Selected tables are used.

Is the Table being created in a tablespace on the same drive as the source
table(s) or, worse, on the drive with the temp tablespace or rollback
segment(s)?  You could be experiencing disk contention.

Jack


Jack C. Applewhite
Database Administrator/Developer
OCP Oracle8 DBA
iNetProfit, Inc.
Austin, Texas
www.iNetProfit.com
[EMAIL PROTECTED]
(512)327-9068


-Original Message-
[EMAIL PROTECTED]
Sent: Wednesday, May 23, 2001 1:05 PM
To: Multiple recipients of list ORACLE-L



Does CREATE TABLE AS SELECT .  still use indexes or are the
indexes disregarded if the select is issued in combination with
a create table?

Oracle 8.0.5, optimizer is CHOOSE.

We are having a performance problem when trying to use create
table as select.



-
Sent using MailStart.com ( http://MailStart.Com/welcome.html )
The FREE way to access your mailbox via any web browser, anywhere!

--
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: Jack C. Applewhite
  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 Question

[Scott Canaan]

I am trying to load a file that has the fields comma-delimited,
variable length.  A sample line from the file looks like this:

503,414081660,Success,Auth,AH9042,z,4555,-,-,-,0,05/01/01,14:21

The problem I am having is putting the date and time together.  The
control file looks like this:

load data
infile 'cyber_real.dat'
append
into table rit_cyber_hist
when order_id <> 'Order ID' and order_id <> ''
fields terminated by ','
(order_id,
 trans_nbr,
 cyber_status,
 trans_type,
 auth_code,
 avs_code,
 trans_amt,
 cic_resp,
 po_nbr,
 ship_to_zip,
 tax_amt,
 trans_date date(14) "mm/dd/yy,hh:mi")

It ignores the time portion of the file, I presume because it has a
comma before it and it assumes that it is a different field.  I can't
figure out any way to get this loaded with the trans_date field
containing both the date and time.

This is on Oracle 8.1.6.0 on Sun Solaris.

Any suggestions?  Thank you.

--
Scott Canaan ([EMAIL PROTECTED])
(716) 475-7886
"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).

Re: Reverse engineer tablespaces.

[Rodd Holman]

This mod grabs the current default storage parameters from 
dba_tablespaces

spool db_structure.txt
select 'create tablespace '||a.tablespace_name|| ' datafile 
'||||b.file_name||||' size '||b.bytes/(1024 * 1024)||'M'||
' default storage ( initial '||a.initial_extent||' next 
'||a.next_extent||' pctincrease '||a.pct_increase||' maxextents 
'||a.max_extents||');'
from dba_tablespaces a, dba_data_files b where a.tablespace_name = 
b.tablespace_name;
spool off

Rodd
>> Original Message <<

On 5/23/01, 3:30:29 PM, Roy Ferguson <[EMAIL PROTECTED]> wrote regarding 
Re: Reverse engineer tablespaces.:


> I'm not sure if this is what your looking for but take a look:


> spool db_structure.txt
> select 'create tablespace ' || a.tablespace_name ||
>  ' datafile ' ||  || b.file_name || ||' size ' || b.bytes/(1024 * 
1024) || 'M' || \
> ' default storage ( initial ??k next ??k pctincrease ? maxextents ?);'
> from dba_tablespaces a, dba_data_files b where a.tablespace_name = 
b.tablespace_name;
> spool off;
> exit;


> Roy



> >
> >So, I need to re-create a database to prepare for migration.  The 
current DB
> >is 8.0.6, and I need to create an 8.1.7 copy.  Does anyone have a script 
to
> >reverse engineer the CREATE TABLESPACE commands?  I started working on 
one,
> >but surely I can't be the first to invent the wheel.
> >
> >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).




> Roy E. Ferguson II
> Intel Sacramento
> 916-854-1123

> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Roy Ferguson
>   INET: [EMAIL PROTECTED]

> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Rodd Holman
  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).

Drop 'NOT NULL' Constraint

[Chris Rezek]

I created a table with a 'NOT NULL' constraint on a VARCHAR2 column.  I
would like to remove the NOT NULL constraint.  I've tried a couple of
'ALTER TABLE' commands but no luck.

How does one do this?

Also:

How does one figure out which generated constraints (from
user_constraints) do what?

Chris Rezek
Database Administrator
DotClick
http://www.dotclick.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Chris Rezek
  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: Sun Solaris 8 - Listener failed to start a dedicated server p

[Nihar]

Title: RE: Sun Solaris 8 - Listener failed to start a dedicated server p



i 
think you should check large pool size parameter in your init.ora file. You can 
actullay reduce the size and restart the instance.
 
 
-Nihar

  -Original Message-From: [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]]On Behalf Of Jacques KilchoerSent: 
  Thursday, May 24, 2001 12:51 AMTo: Multiple recipients of list 
  ORACLE-LSubject: RE: Sun Solaris 8 - Listener failed to start a 
  dedicated server p
  >-Original Message- >From: Jyoti N [mailto:[EMAIL PROTECTED]] 
  > >Your problem is actually 
  highlighted on the error message "Solaris Error: 12: Not enough space" 
  >It is more of an Operating system resource issue. 
  
  Yes, but which one?! Is it lack of physical memory? 

  >I gather that you are running about 8 instances on this 
  machine ,right? 
  After having made a few of the SGAs smaller, I went back to 12 
  instances. :) 
  How can I tell if I am running out of physical memory? Any of 
  the statistics I looked at seemed to indicate that there was plenty of memory 
  available.
  P.S. When I try to run sar I get the following message: 
  $ sar sar: can't open 
  /var/adm/sa/sa23 No such file or directory 
  I do see a /var/adm/sa/sa16 directory. What does this 
  mean? 

Re: 8.1.7. and OAS / iAS versions confusion

[Marc Perkowitz]

9i iAS == 8i OAS.  Oracle renamed 8i 1.0 to 9i 1.0.  Version numbers are
consistent.

Marc Perkowitz
Senior Consultant
TWJ Consulting, LLP

847-256-8866 x15
www.twjconsulting.com

- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, May 23, 2001 10:27 AM


OK, now I'm puzzled.

About 3 weeks ago Oracle mailed me a copy of 8.1.7. at home, along with the
9i iAS.

The iAS documentation refers to 8i OAS (version 1.0.1), it says we can
"migrate" from 8i OAS to iAS.

Does this mean if I had installed 8i OAS (v. 1.0.1), I could apply a patch
to bring it up to v.1.02 (9i iAS?)

Is iAS iAS, or is it OAS??  If iAS is not OAS, why do they have the same
version numbers?

Does iAS go with 8.1.7, or 9i?

If 8i OAS goes with 8.1.7, how come Oracle never sent me a copy of 8i OAS?
Weren't they excited about that product as well?

When we receive the media for 8.1.7 here, will we receive from Oracle 8i OAS
to go with it, or 9i iAS?

When Oracle 9i is released, will there be another version of iAS to go along
with it?

I wish the versions matched, but I guess when you're a big company it's hard
to release the different packages in synch.

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] 

Ph: (902) 426-4774



-Original Message-
Sent: Wednesday, May 23, 2001 5:26 AM
To: Multiple recipients of list ORACLE-L

I wish that I could be like some of U where your job is to solely
tune/backup database etc. Although I am a "DBA", I feel that I am a
5% DBA
and 95% developer.  I've just migrated our in-house customized
System to the
newly acquired Oracle HR System (oracle workflow).  In top of that,
I am
also maintaining certain in-house Oracle systems. 95% of my time is
spent on
development.

I think that it's great to learn so many tools, Oracle Workflow,
Forms,
Reports, Graphics etc but I wish that I have more time to tune the
database.
Besides, cloning database, backup database, applying oracle patches
to the
HR System, all of my time is spent in development.

Regds,
New DBA
-Original Message-
[mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 22, 2001 10:06 PM
To: Multiple recipients of list ORACLE-L
them!)

I don't know about this development business.  I
think about
this a lot (I
don't have a life).

I keep an eye on Developer, Jdeveloper, Cherokee
(which is
dead I hear),
Visual C++, etc. etc.  but I am not great at any of
them.

There is just too much for one person to learn and
be good
at both sides, in
my opinion.

If I had a project to handle I would prefer hiring a
team of
people which is
composed of outstanding DBAs and outstanding
developers,
each good in their
own field, rather than hire a bunch of people who
can do a
little of
everything.

When you put specialists together with clear areas
of
expertise, in a team,
you may end up with something greater than the sum
of its
parts (gestalt).

If you put a bunch of OK generalists together, you
will end
up with... a
workgroup and OK result.  Probably.

As a DBA I am more interested in learning about SQL
Server,
DB2, and others,
and in OSes than in doing development.

That's just my personal preference.

Maybe if I was a great developer I could do
contracts and
drive a Porsche
like my NT instructor did, I don't know.  Maybe once
I am
confident I know
enough about the foundation my development work
would run
on...

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-
[SMTP:[EMAIL PROTECTED]]
Sent: Sunday, May 20, 2001 5:45 PM
To: Multiple recipients of list ORACLE-L
on
them!)

As a dba you don't have to do designing and
development.  You will
find
though 2 years is tough.
Here is my assessment.

1-3 years experience Very tough to find
a job
but everyone wants
to
waste your times in interviews
3-5 years experience Alot of
opportunities but
will fall short
for
"senior" positions
6+  years of experience  Tons of jobs, alot
of them
want you for
midlevel
positions (based on offered salary).

To be honest, there isn't much difference in
salary
between a 5 year
dba and
20 years.
Once you make 5 year mark, your pretty much
home
free (I am yet to
hit it as
I been doing Oracle for 3.5 years, and about
2 of
very solid work).
The
first 5 years are tough in my opinion unless
you
have something
special
someone wants.  For me, it has been my
dedication
and tenacity not
my length
of service.

I have talked to alot of

Job lists -- offtopic

[Pablo ksksksk]

First of all

I apologize for contributing to this list with another
"off topic".

I'd like to know if someone would share with me
some addresses of websites or mail lists where 
dba jobs are offered (in USA preferredly).

thanks

___
Do You Yahoo!?
Yahoo! Messenger: Comunicación instantánea gratis con tu gente -
http://messenger.yahoo.es
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-1?q?Pablo=20ksksksk?=
  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 Development Tool

[Suri, Deepak]

I have a feeling that this is not the most appropriate list for this
question, but then I swear by the postings of folks on this list, which
means I value their opinions very much, so here goes ...

Our organization is evaluating several tools to help us with our Oracle
application development (excluding that done using Developer/2000). The
front runners are TOAD and SQL Navigator both sold by Quest Software. The
prices are comparable, the functionality is similar, support is the same,
integration with PVCS is available etc.

Would any of you gurus out there care to comment on which one and why one
tool might be better than the other ?

thanx !
deepak
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Suri, Deepak
  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).

Forms5 D2KWUTIL under Forms6i

[Magrogan Michael A]

Hello--
We've got a client/server app which currently runs under Forms5, that we're
in the process of converting to 6i.
We have the existing d2kwutil.dll in our bin directories.  Is there any
problems staying with this, provided we don't recompile the d2kwutil.pll
libraries?  Just trying to avoid any additional changes on the client.

Thanks
Mike
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Magrogan Michael A
  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: Database Down

[Thater, William]

On Wed, 23 May 2001,Jared Still scribbled on the wall in glitter crayon:
->Backup is easy, recovery is not always so.
->
->Jared
->
Now there's a quote that should go into "Zen and the Art of ORACLE Database 
Administration"... now who's writing that again?;-)

--
Bill Thater Certifiable ORACLE DBA
Telergy, Inc.[EMAIL PROTECTED]
~~
You gotta program like you don't need the money,
You gotta compile like you'll never get hurt,
You gotta run like there's nobody watching,
It's gotta come from the heart if you want it to work.
~~
If you live to be a hundred, I want to live to be a hundred minus one day,so I never 
have to live without you. -- Winnie the Pooh

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Thater, William
  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: Live Free or Die! / Re: OT: Editorial on Corporate use of Open Source Software

[Eric D. Pierce]

yes, the bliss (with the exception of constantly having to dealing 
with silly political correctness) of life in inefficient academia. 
and, data janitoriaton is easier (but more dull and less remunerated) 
than db administration. but really, as I said previously, most of the 
blah blah is just cut and pasted from other non-work-time related 
conversation with people I know in private life that are interested 
in science, mysticism, social theory/etc.
ep

On 22 May 2001, at 17:31, Rachel Carmichael wrote:

Date sent:  Tue, 22 May 2001 17:31:02 -0800
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>

> I'm more interested in WHEN he has the time to be a DBA  :)


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Eric D. Pierce
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

disk information alert

[Seema Singh]

Hi Gurus
Does any one having scripts to know disk space once particular partion =>75%
let assume the below is not exact output of df -k command
$df -k

/u0168
/u0240
/u0353
/u0476
As the disk partition reach to 75% or more.We need to get email alert.
If some have such kind of script let me know.

Thanks
-seema

_
Get your FREE download of MSN Explorer at http://explorer.msn.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Seema Singh
  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).

OT Wilber/Shambala interview ("transideological" social trends)

[Mohan, Ross]

It's actually a pretty cool interviewa lot there

|| -Original Message-
|| From: Mark Leith [mailto:[EMAIL PROTECTED]]
|| Sent: Wednesday, May 23, 2001 11:19 AM
|| To: Multiple recipients of list ORACLE-L
|| Subject: RE: (Fwd) Wilber/Shambala interview 
|| ("transideological" social
|| trends)
|| 
|| 
|| antidisestablishmentarianism - I know big words too!! :)
|| 
|| http://www.straightdope.com/mailbag/mantidis.html
|| 
|| Really Eric - where do you get all the time from to collate this
|| extraordinarily extensive yet thoroughly interesting psycho 
|| babble? :)
|| 
|| Mark (Eric wannabe)
|| 
|| -Original Message-
|| Pierce
|| Sent: Tuesday, May 22, 2001 07:51
|| To: Multiple recipients of list ORACLE-L
|| trends)
|| 
|| 
|| 
|| (repost for list newcomers)
|| 
|| --- Forwarded message follows ---
|| 
|| http://wilber.shambhala.com/html/interviews/Shambhala_intervi
|| ew.cfm/xid,2676
|| /yid,5800264
|| -
|| http://www.scottlondon.com/
|| -
|| http://www.rkey.com/thetazone/
|| -
|| http://www.rkey.com/thetazone/#constructivism
|| 
|| -
|| excerpt:
|| 
|| ...
||  Among its many insights, constructivism adds perspective to the
||  unfortunate historical propensity of humans to objectify the
||  mind as an entity subject to environmental factors.
||  Constructivism is best known as a critique of international
||  relations theories which assert that rational behaviors of
||  nation-states must necessarily conform to the exigencies of an
||  anarchic world system. The framework can be extended to reveal
||  similar patterns in superstitious eschatologies, statements like
||  "The devil made me do it," and a wide range of modern
||  materialist and historicist philosophies, notably extremist
||  forms of Marxism and Social Darwinism.
|| 
||  The propensity to "blame" environmental factors as an excuse for
||  human behavior has become increasingly sophisticated in recent
||  years, leading to a philosophy of mind that proclaims
||  computerized telecommunication as destiny. Not only are such
||  concepts being promoted with fanatical energy, they are being
||  used to justify social transformations that are increasingly
||  rapid and disruptive. The rising interest in "memes," which
||  holds that ideas acquire people (rather than people acquiring
||  ideas) is an important part of this distressing trend.
|| 
|| ...
|| 
|| (by the same guy, an explortion of the struggle between progressive
|| proponents of a model of internet governance based on participatory
|| democracy  vs commerical interests :
|| 
||http://www.rkey.com/dns/overview.html )
|| 
|| -
|| 
|| http://www.context.org
|| -
|| http://216.122.74.136//ICLIB/IC03/TOC03.htm
|| -
|| http://216.122.74.136//ICLIB/IC03/CoriGord.htm
|| 
|| -
|| http://www.wholeearthmag.com/ArticleBin/FeaturesIssue.html
|| -
|| http://www.wholeearthmag.com/ArticleBin/373.html
|| -
|| 
|| Sustainable culture:
|| 
||http://www.resilientcommunities.org
|| 
|| -
|| excerpt:
|| 
|| What's Behind Resilient Communities?
|| 
||   Something's afoot in the United States, and
||   Canada, and Australia, and Europe, and Asia and
||   Africa -- all over the world. Increasing numbers of
||   people are saying they want a different life than
||   that being offered by industrial-era society. Paul
||   Ray, in his 1997 Integral Culture Survey: A Study
||   of the Emergence of Transformational Values in
||   America says that as much as 25% of
||   populations in industrial countries are looking for
||   a better way of life.
|| 
||   Why?
|| 
||   Forces are coming together to shift dynamics in
||   very dramatic ways. There is a growing split
||   between the rich and the poor not only within
||   countries both developed and undeveloped but
||   also, of course, between them. There is a huge
||   increase in population over the last century, which
||   when coupled with production increases, has led
||   to shortages of land, water and clean air. There
||   is growing evidence that global warming and
||   climatic instability, evidenced this year by the
||   number of severe fire and flood problems around
||   the world, threaten current human habitation
||   patterns in significant ways. New forms of
||   nuclear, biological and chemical weaponry are
||   threatening humanity and both nation state
||   rivalries and terrorism create continuing anxieties
|| 
||   There is an economic crisis as our reliance on
||   economic growth and affluence collides with
||   changing personal commitment and ecological
||   realities. There is a social crisis as growing
||   poverty and growing wealth co-exist on the same
||   planet. There is a moral crisis as our ability to
||   feel outrage about the state of the world is buried
||   by our busyness and statements from economists
||   and politicians that "we have no choice." There is
||   an ecological crisis a

Re: ORA-12571: TNS:packet writer failure

[Jared Still]

On Wednesday 23 May 2001 00:00, Hendra Darmawan wrote:
> Dear all,
> Anyone can help me about this error (ORA-12571)?
> Thanks!


In addition to Pauls comments, I am guessing that you are
on NT.  This error is informational only, you have a network
error of some type.  

Go talk to the network admin about it.

Jared
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jared Still
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: sum of file size ????

[Seema Singh]

Please use du -s directory name.
-Seema


>From: "Morton, Ronald D" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: RE: sum of file size 
>Date: Wed, 23 May 2001 07:19:09 -0800
>
>Andrea,
>
>You could try: wc *
>
>Ron
>
>-Original Message-
>Sent: Tuesday, May 22, 2001 2:39 PM
>To: Multiple recipients of list ORACLE-L
>
>
>Hi,
>
>OK, as you know, I don't know too much about Unix:
>
>When you do a ls -l and see the individual file size,
>is there a command to show the sum of all the file
>size?  Thank you!
>
>Andrea
>
>__
>Do You Yahoo!?
>Yahoo! Auctions - buy the things you want at great prices
>http://auctions.yahoo.com/
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Andrea Oracle
>   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: Morton, Ronald D
>   INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>San Diego, California-- Public Internet access / Mailing Lists
>
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from).  You may
>also send the HELP command for other information (like subscribing).

_
Get your FREE download of MSN Explorer at http://explorer.msn.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Seema Singh
  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).

OT RE: Mailing lists hosted by fatcity

[Mohan, Ross]

Charlie Brown and Lucy are heading down to you
right now in a Mir launch vehicle financed by
Dennis Tito, carrying a scalpel and duct tape.

Hang in there, Snoopy!

|| -Original Message-
|| From: Eric D. Pierce [mailto:[EMAIL PROTECTED]]
|| Sent: Wednesday, May 23, 2001 2:16 PM
|| To: Multiple recipients of list ORACLE-L
|| Subject: RE: Mailing lists hosted by fatcity
|| 
|| 
|| yes, but i was sad that i didn't see a list for beagle 
|| owning transgendered rocket launch console operators 
|| from antarctica.
|| 
|| On 23 May 2001, at 9:20, Robertson Lee wrote:
|| 
|| > Knowing that I can get to the 
|| > 
|| > "Flight Attendants Association of Australia" list will 
|| help me sleep at
|| > night !!
|| 
|| 
|| -- 
|| Please see the official ORACLE-L FAQ: http://www.orafaq.com
|| -- 
|| Author: Eric D. Pierce
||   INET: [EMAIL PROTECTED]
|| 
|| Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
|| San Diego, California-- Public Internet access / 
|| Mailing Lists
|| 
|| To REMOVE yourself from this mailing list, send an E-Mail message
|| to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
|| the message BODY, include a line containing: UNSUB ORACLE-L
|| (or the name of mailing list you want to be removed from).  You may
|| also send the HELP command for other information (like subscribing).
|| 
-- 
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).

(Fwd) Re: Open Source and Capitalism

[Eric D. Pierce]

--- Forwarded message follows ---

Date sent:  Sun, 20 May 2001 11:20:46 -0400

> Seeing the recent interest in discussing the connection (or lack) between 
> open source and capitalism, I thought people might enjoy reading an article 
> that appeared in a special Linux issue of the peer-reviewed industry 
> magazine IEEE Software:
> "Culture Clash and the Road to World Domination".
> http://members.home.net/ecosmos/writings/clash.pdf
> 
> This article presents an analysis of the open source community's character, 
> incentives, and systemic interactions. What emerges is precisely the 
> opposite of the fairly widespread, intuitive understanding: rather than an 
> assumed hostility or incompatibility between open source and 
> individualism/capitalism, there are in fact deep parallels that flow from a 
> common foundation.
> http://linuxtoday.com/news_story.php3?ltsn=2001-05-19-010-20-OS-CY

--- End of forwarded message ---

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Eric D. Pierce
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Oracle Development Tool

[Jared Still]

Deepak,

Not off topic at all.

Personally, I much prefer TOAD, as it has a *much* better 
interface than SQL Navigator, which translate into less
time spent navigating the tool and more time getting 
work done, leaving more time to answer questions on
this list.  :)


Jared

On Wednesday 23 May 2001 11:05, Suri, Deepak wrote:
> I have a feeling that this is not the most appropriate list for this
> question, but then I swear by the postings of folks on this list, which
> means I value their opinions very much, so here goes ...
>
> Our organization is evaluating several tools to help us with our Oracle
> application development (excluding that done using Developer/2000). The
> front runners are TOAD and SQL Navigator both sold by Quest Software. The
> prices are comparable, the functionality is similar, support is the same,
> integration with PVCS is available etc.
>
> Would any of you gurus out there care to comment on which one and why one
> tool might be better than the other ?
>
> thanx !
> deepak
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jared Still
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Reverse engineer tablespaces.

[Roy Ferguson]

I'm not sure if this is what your looking for but take a look:


spool db_structure.txt
select 'create tablespace ' || a.tablespace_name ||
 ' datafile ' ||  || b.file_name || ||' size ' || b.bytes/(1024 * 1024) || 'M' 
|| \
' default storage ( initial ??k next ??k pctincrease ? maxextents ?);'
from dba_tablespaces a, dba_data_files b where a.tablespace_name = b.tablespace_name;
spool off;
exit;


Roy



>
>So, I need to re-create a database to prepare for migration.  The current DB
>is 8.0.6, and I need to create an 8.1.7 copy.  Does anyone have a script to
>reverse engineer the CREATE TABLESPACE commands?  I started working on one,
>but surely I can't be the first to invent the wheel.
>
>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).




Roy E. Ferguson II
Intel Sacramento
916-854-1123

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Roy Ferguson
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Database Down

[Jacques Kilchoer]

Title: RE: Database Down





>-Original Message-
>From: Burton, Laura L. [mailto:[EMAIL PROTECTED]]
>
>My database is up and with no data loss!!!


Congratulations! I've done the exercises in Rama Velpuri's book, but when it comes to a live situation, it's a little more scary.

So where's the party?

Automatic password locking

[Yttri, Lisa]

Title: Automatic password locking





Hi everyone -


I am trying to implement a process on our production servers.  If requested for emergencies, an id is automatically unlocked.  This id was previously defined with all access (select, insert, update, delete) to all objects in a schema.   I want this id to be active for only 4 hours, then I would like it to automatically get locked.

Is there any information maintained in oracle as to the length of time a user id has been unlocked (or active)?  I could then query that column and once it was over 4 hours, I could terminate any active sessions using that id and lock it.

If I audit this id, would there be useful information in the audit tables regarding length of use?


Any help - or other ideas to accomplish this - would be greatly appreciated.


Thanks -
lisa

RE: Sun Solaris 8 - Listener failed to start a dedicated server p

[Jacques Kilchoer]

Title: RE: Sun Solaris 8 - Listener failed to start a dedicated server p





>-Original Message-
>From: Jyoti N [mailto:[EMAIL PROTECTED]]
>
>Your problem is actually highlighted on the error message "Solaris Error: 12: Not enough space"
>It is more of an Operating system resource issue.


Yes, but which one?! Is it lack of physical memory?


>I gather that you are running about 8 instances on this machine ,right?


After having made a few of the SGAs smaller, I went back to 12 instances. :)


How can I tell if I am running out of physical memory? Any of the statistics I looked at seemed to indicate that there was plenty of memory available.

P.S. When I try to run sar I get the following message:
$ sar 
sar: can't open /var/adm/sa/sa23
No such file or directory


I do see a /var/adm/sa/sa16 directory. What does this mean?

RE: Database Down

[April Wells]

Laura

Document it to even those you CAN'T think of... just to try to CYA!  I speak
from experience!

April Wells
Oracle DBA
Corporate Systems
Amarillo Tx

-Original Message-
Sent: Wednesday, May 23, 2001 10:27 AM
To: Multiple recipients of list ORACLE-L


Paul you leave me NOTHING to add to this.  :)

Laura. I would do exactly what Paul said, and include what you thought 
to do (which is backup the good disks before you do anything else).

First rule of recovery: ALWAYS have a way to start all over again if you 
mess up.

After that, follow Paul's list :)

Once that is done, take a deep breath, then go find out who you have to 
stomp on to get the backup logs reviewed AS SOON AS THEY COMPLETE. (You 
might want to automate something that checks for errors and pages you). Find

out why no one knew there was a problem with the backup and why it waited 
until you came in.

Yell. Scream. And DOCUMENT what went wrong... to everyone you can think of.

Rachel

>From: Paul Drake <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: Re: Database Down
>Date: Wed, 23 May 2001 00:00:23 -0800
>
> > "Burton, Laura L." wrote:
> >
> > I have an Oracle 8.0.5 database residing on a Windows NT operating
> > system which uses Raid5.  The 'almost never' has happened; two disks
> > have gone bad at the same time.  As fate would have it the 'complete'
> > physical backup performed the day before the disks crashed (Friday,
> > May 18) cancelled.  Of course this happened on Saturday on a weekend
> > in which I was out of town and did not get back in until late this
> > afternoon.
> >
> > My system admin said he restored the drives on the bad disks from a
> > physical backup created the previous Friday (May 11) and then restored
> > the differential backup from this past Thursday (May 17).  The Archive
> > files were also on one of the disk that went bad.  I have looked at
> > the alert log and the hot backup executed on the Thursday prior to the
> > Saturday crash completed successfully.  Something that does not seem
> > right, and I'll talk with my system admin tomorrow, is that when I
> > looked at the datafiles and archive logs he restored they were all
> > dated May 11, the date of the complete backup.  If he applied the
> > differential as he said, does this not add the archive logs written
> > from May 11 through the May 17 differential backup?  According to the
> > alert log it looks like I am missing approximately 438 logs.
> >
> > I thought I would have to restore all datafiles and archive logs from
> > the physical backup so that they would be in sync, and then 'recover'
> > the database using the hot backup.  This would only incur minimum data
> > loss since Saturday is a non-work day for most employees.  After
> > reading the Backup and Recovery manual it looks like all I have to do
> > is 'recover' the database using the hot backup.  Wouldn't it matter
> > that the datafiles would not currently be in sync since the datafiles
> > on the disk which did not crash were ok and not restored?  Since the
> > hot backup would restore all the datafiles I would think it wouldn't
> > matter.  Correct??
> >
> > I would appreciate some second and third opinions.  This is my first
> > 'live' recovery and I want to make sure as much as possible that I do
> > what will have the least impact on data loss.  It goes without saying,
> > but I will have a complete backup of the 'good' disks before I tackle
> > this beast.
> >
> > Thank you in advance,
> > Laura
>
>0. caffeine.
>
>1. (you already know this) your latest archived redo log is what you
>will be able to recover the database to  - nothing further. I assume
>that a budget for duplexed archived redo logs will be forthcoming.
>Network Attached Storage is possibly an even better solution - with
>scheduled jobs to propagate archived logs to the NAS box.
>
>2. You *will* be performing incomplete recovery. Recover until cancel,
>preferably with a backup controlfile.
>Did you create a backup controlfile as part of the hot backup on May
>11th? Restore with that controlfile.
>
>3. After the recovery is completed (you've opened RESETLOGS) close the
>database and get a *full* cold backup. Fight the urge to *get the
>database open* when you don't have anything to intiate your next
>recovery from. You don't want to have to repeat this entire processes
>*ever* again.
>
>4. Possibly, you want to have the SysAdmin restore the thursday night
>archived redo logs (17th) to a different folder than the previous backup
>set (11th). This may be the reason why the later set of archived
>redologs is not appearing.
>
>5. If you have more recent copies of datafiles than the May 11th backup
>set - move them to a different directory - and restore the entire hot
>backup set. Recovery will attempt to recover all datafiles to be in-sync
>at a specific SCN#. To have some datafiles ahead of that SCN could cause
>more problems. If y

MICROSOFTDTPROPERTIES

[Armstead, Michael A]

I have developers who have created this table. Now they've come to me to
find out what the table does. I think it is used by the Microsoft
Transaction Server software. Does anyone know for sure the purpose of the
MICROSOFTDTPROPERTIES table?

Michael Armstead
Application Database Administrator, OCP-Certified
US Pharmaceuticals IT
Glaxo SmithKline


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Armstead, Michael A
  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: Sun Solaris 8 - Listener failed to start a dedicated server p

[Jacques Kilchoer]

Title: RE: Sun Solaris 8 - Listener failed to start a dedicated server p





Thank you everybody for your suggestions. To recap, I had the following suggestions:
- purge listener.log (Shahid Nasir)
- check max number of processes vs. max number of processes per user (John Kanagaraj)
- swap space being filled (Hagedorn, Linda)
- Use the "truss" command to trace the system calls when you get the ORA-12500. Example: truss -f -o error.log sqlplus (Narender Akula)

- increasing number of semaphores (eric harrington)


Narender Akula had also asked if we have Oracle 32-bit and Oracle 64-bit versions both running on the same server. Yes we do.

I tried all of the above except using truss. I will experiment with that later. What I did for now to fix the problem: I made the SGA smaller on several of the test databases and the problem went away (it looks like some of the init files were copied over from a production system with no changes. No, I didn't do it, so don't start throwing tomatoes at me.) I'm still not sure why this fixed the problem since ipcs -pmb showed a total of approx. 800MB being used and the machine has 4GB of physical memory. Any further comments are appreciated (except, of course, comments of the type 'Jacques, you're an idiot, don't you know anything about UNIX?')

--
Jacques R. Kilchoer
(949) 754-8816
Quest Software, Inc.
8001 Irvine Center Drive
Irvine, California 92618
U.S.A.
http://www.quest.com

Oracle DBA vs. Oracle Apps DBA - Different? and how?

[Glenn Travis]

I would be interested in hearing your opinions on the differences between an
Oracle DBA and an Oracle Apps DBA.  Are they different?  And how?  Are they
so different that one could not perform the duties of another?  Learning
curve for each?

My interest was sparked when I interviewed with a company that had
advertised for a senior Oracle DBA.  It become known in the interview that
they were moving legacy apps to Oracle Apps (Financial, HR) and were in need
of an Apps DBA.  I have no experience using these products.  But I did tell
them I have over 10 years experience as a DBA, using all 4 major DBMS
engines on 4 different unix platofrms.  Should that be taken into account?
I feel I could easily learn Apps DBA duties as I have learned other DBMS's.
They still wanted an experienced Apps DBA and said they have a current DBA
who is 'learning on the fly'.

Caught in a catch-22.  Can't get experience with Apps because can't get
hired, BUT can't get hired without experience...

Opinions?

-- 
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).

Re: RV: vni-2015 authentication error

[TCarlson]

OS or database job? If OS, we just solved this issue. Assuming your target
node is not a PDC or BDC, the NT user must be local and the preferred
credentials of the node in OEM must be set to the same user. Hope it helps.

Todd Carlson
Oracle 8i Certified DBA
Bunge Corporation


  
Mari  
Susperregi   To: Multiple recipients of list ORACLE-L 
   
.com>cc:  
Sent by: Subject: RV: vni-2015 authentication 
root@fatcity.error
com   
  
  
05/23/2001
10:19 AM  
Please
respond to
ORACLE-L  
  
  





> hello
> I'm running oracle 8.1.7 on WNT. I've set system/manager as the preferred
> credentials of the DB, and an administrator OS account (with 'run as
batch
> job' priv) as the credentials of the node. I'm getting the vni-2015
> authentication failed error while running any job.
> can anybody help me?
> thanks
> mari
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Mari Susperregi
  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).

RE: Mailing lists hosted by fatcity

[Thater, William]

On Wed, 23 May 2001,Eric D. Pierce scribbled on the wall in glitter crayon:

->yes, but i was sad that i didn't see a list for beagle
->owning transgendered rocket launch console operators
->from antarctica.

I believe that one is hosted over a lycos.;-)
--
Bill Thater Certifiable ORACLE DBA
Telergy, Inc.[EMAIL PROTECTED]
~~
You gotta program like you don't need the money,
You gotta compile like you'll never get hurt,
You gotta run like there's nobody watching,
It's gotta come from the heart if you want it to work.
~~
Abstraction is achieved by data hiding and enforced by encapsulation.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Thater, William
  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: Binding a process to a CPU .

[Shreepad Vaidya]

Hi Steve ,

Your  article was very informative . Thanks a lot.

I will have to definitely rethink on these issues.


   shreepad.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Shreepad Vaidya
  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: Variabel declaration

[Jack C. Applewhite]

Roland,

Yes and for exactly the right reason.

In fact, I've found over the years that most of my PL/SQL variables end up
being records of Table%RowType, since I nearly always need to use more than
just one column of a table.  Table%RowType records are particularly useful
for input arguments to public cursors and return values for functions.

I'm sure someone will call using only a few of the fields in a Table%RowType
record "inefficient", but I've not seen any kind of downside to it.

Jack


Jack C. Applewhite
Database Administrator/Developer
OCP Oracle8 DBA
iNetProfit, Inc.
Austin, Texas
www.iNetProfit.com
[EMAIL PROTECTED]
(512)327-9068


-Original Message-
[EMAIL PROTECTED]
Sent: Wednesday, May 23, 2001 10:19 AM
To: Multiple recipients of list ORACLE-L


Hallo you DBAs

Is it good to use this form when you declare variables in pl/sql? Then you
dont have to be afraid of declaring variabloes  into wrong datatype and
size.

vOWNER_NO OWNER_INFO.OWNER_NO%TYPE;

Sincerely

Roland Sköldblom



--
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: Jack C. Applewhite
  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: Database Down

[Thater, William]

On Wed, 23 May 2001,Rachel Carmichael scribbled on the wall in glitter crayon:

->Yell. Scream. And DOCUMENT what went wrong... to everyone you can think of.
->
->Rachel

Including sending copies to yourself at an account off site, then save it there.  BCC 
is your friend.;-)

--
Bill Thater Certifiable ORACLE DBA
Telergy, Inc.[EMAIL PROTECTED]
~~
You gotta program like you don't need the money,
You gotta compile like you'll never get hurt,
You gotta run like there's nobody watching,
It's gotta come from the heart if you want it to work.
~~
Abstraction is achieved by data hiding and enforced by encapsulation.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Thater, William
  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: Maximo

[Bowes, Chris]

Title: RE: Maximo





ON all the maximo installations I have done, the biggest problems have been with maxencrypt a table that holds the encrypted key that allows everyone in the base.  There is a script that will reset this if the users cannot get into the system.   Make sure that the character set in the client is set to the same as the base.  If users cannot get into the base due to bad password and you *know* the user/password are correct, then something happened to the maxencrypt and/or the character sets are not the same.  I am hoping that 4i eliminates that table, but since I haven't seen it, I don't know if it does.

I don't know about the current version, but when I worked with it about a year ago, the indexes were terrible.  We dropped and created a number of indexes to improve things.  We used cost base optimization (oracle v7 at the time) and and a job that analyzed every couple weeks on the big tables and every month on the others.

If you have to do an import of the base, you will need to run the maxora??.sql script that creates a couple views under sys.  I am sorry that I cannot remember the script at this moment.   I'll check with some of my old comrades and see if they can remember it.  

If you're moving to production, you probably have all the columns defined and sized.  If not, sometimes the column changes do not get registered in the maxsyscols table and you'll need to update it.

Otherwise, the system really does quite well once it is running.  If I can think of anything else I'll re-reply.


--Chris
[EMAIL PROTECTED]



-Original Message-
From: James Xing [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 22, 2001 6:15 PM
To: Multiple recipients of list ORACLE-L
Subject: Maximo



Hi Group,


I have a Maximo system moving into production, using Oracle 816/Sun solaris
If anyone has experience, from DBA point of view, what I should be care of?
anything to change/check? any particular table?


Thanks
James


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: James 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).

Re: Binding a process to a CPU .

[Bill Gentry]

I thought it meant "Hope This Helps"
---Bill

Bill Gentry
DBA
Allina Health System
Minneapolis, MN 55403
612-775-1190
[EMAIL PROTECTED]
- Original Message - 
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, May 22, 2001 4:33 PM


> 
> it means "happy to help" Christopher
> 
> Brian.
> 
> 
> 
> 
> 
> Christopher Spence <[EMAIL PROTECTED]>@fatcity.com on 05/22/2001
> 04:21:12 PM
> 
> Please respond to [EMAIL PROTECTED]
> 
> Sent by:  [EMAIL PROTECTED]
> 
> 
> To:   Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> cc:
> 
> 
> 
> What does
> 
> hth,
> 
> Mean?
> 
> -Original Message-
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Christopher Spence
>   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: Bill Gentry
  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: Multiple schema's or multiple databases

[Richard Ji]

If each schema has it's own tablespace, then you can do Point In Time Tablespace 
Recovery.  If all schemas share tablespaces then that would be a problem.

Richard Ji

>>> [EMAIL PROTECTED] 05/23/01 02:45AM >>>
Off the top of my head I can see this problem also. Is there anyone who is expert at 
recovery has a view.
Dick - how can you consolidate 8 companies into one schema - they probably all have 
different inventories,equipmet etc.. + all have their own interface to Oracle 
Financials.

Sam 
  - Original Message - 
  From: John Lewis 
  To: Multiple recipients of list ORACLE-L 
  Sent: Wednesday, May 23, 2001 3:36 AM
  Subject: RE: Multiple schema's or multiple databases


  Something to ponder. The archive logs are tied to the system. Thus, if you want to 
recover to a point in time for a multi-schema /one instance system, if one schema gets 
rolled back - everything gets rolled back.
   
  We had this same issue.  Perhaps someone knows a way around this.
-Original Message-
From: Christopher Spence [mailto:[EMAIL PROTECTED]] 
Sent: Tuesday, May 22, 2001 2:26 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Multiple schema's or multiple databases


1.  Is that performance gain absolutely necessary?
 
What happens if one company goes down and takes down them all.
 
 
On another note, I tend to agree on lesser instances against more instances.  
Easier to tune, better perforamance due to what I call instance wastage and much 
easier to maintain.  But if one system changes alot, has significiantly different 
access methods, or goes up and down more than anyone, I would evaluate seperate 
instances.
 
  -Original Message-
  From: Sam Roberts [mailto:[EMAIL PROTECTED]] 
  Sent: Tuesday, May 22, 2001 1:41 PM
  To: Multiple recipients of list ORACLE-L
  Subject: Multiple schema's or multiple databases


  Oracle 8.1.6 and Solaris
  I'm going to inherit production databases when I start my new job next week. I 
gather that the production database consists of 8 schema's (8 companies) that are all 
in one database. Its an ERP package called Maximo and it interfaces to Financials 11i 
databases (don't know if this is multiple databases or schema's yet).
  Apparently there is some data passing between companies and multiple schema's 
perform better than using database links with multiple databases, and this is the 
reason for multiple schema's.
  Does anyone have an opinion on this. If I'd have done it I would have done 
multiple databases as they are separate companies, but I'm open to comments as not 
quite got my head round it yet, plus I've been vacationing (partying) for 3 weeks.

  Thanx

  Sam





   

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Richard Ji
  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: Nothing to do with Oracle : But is is very important : Yo

[blair]

I agree that the link is off topic.  I also like the link and intend to send it
to many of my American friends.  

I'd like to see less off-topic discussion here.  Funny though - most list
members seem to enjoy off-topic discussion - except for this one.

..tom

> -Original Message-
> From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
> Sent: Monday, May 21, 2001 5:51 PM
> To:   Multiple recipients of list ORACLE-L
> Subject:  Re:Nothing to do with Oracle : But is is very important : Yo
> 
> This one is SOO far off topic.  I believe this is a multi national mailing
> list & as much as I like to keep "freedom of speech" alive & well I really
> don't
> want to get mired down in a strictly political discussion.  At least the Saudi
> posts had to do with working there as an Oracle professional (though I will
> concede the last few days have been way to far off base).  Consequently I
> respectfully request that you refrain for future posts of this purely non
> Oracle
> nature.
> 
> Dick Goulet
> 
> Reply Separator
> Author: palestine Qods <[EMAIL PROTECTED]>
> Date:   5/21/2001 12:40 PM
> 
> Hello,
> 
> Please take a look at this and give your reaction :
> 
> http://www.humanityonhold.com/intifada.html
> 
> YOUR REACTION PLEASE
> 
> THANKS A LOT
> 
> 
> 
> 
> Get free email and a permanent address at http://www.netaddress.com/?N=1
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: palestine Qods
>   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: 
  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).

8.1.7. and OAS / iAS versions confusion

[Boivin, Patrice J]

OK, now I'm puzzled.

About 3 weeks ago Oracle mailed me a copy of 8.1.7. at home, along with the
9i iAS.

The iAS documentation refers to 8i OAS (version 1.0.1), it says we can
"migrate" from 8i OAS to iAS.

Does this mean if I had installed 8i OAS (v. 1.0.1), I could apply a patch
to bring it up to v.1.02 (9i iAS?)

Is iAS iAS, or is it OAS??  If iAS is not OAS, why do they have the same
version numbers?

Does iAS go with 8.1.7, or 9i?

If 8i OAS goes with 8.1.7, how come Oracle never sent me a copy of 8i OAS?
Weren't they excited about that product as well?

When we receive the media for 8.1.7 here, will we receive from Oracle 8i OAS
to go with it, or 9i iAS?

When Oracle 9i is released, will there be another version of iAS to go along
with it?

I wish the versions matched, but I guess when you're a big company it's hard
to release the different packages in synch.

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]  

Ph: (902) 426-4774



-Original Message-
From:   CHAN Chor Ling Catherine (CSC) [SMTP:[EMAIL PROTECTED]]
Sent:   Wednesday, May 23, 2001 5:26 AM
To: Multiple recipients of list ORACLE-L
Subject:RE: recruiters. Aargh. (More on them!)

I wish that I could be like some of U where your job is to solely
tune/backup database etc. Although I am a "DBA", I feel that I am a
5% DBA
and 95% developer.  I've just migrated our in-house customized
System to the
newly acquired Oracle HR System (oracle workflow).  In top of that,
I am
also maintaining certain in-house Oracle systems. 95% of my time is
spent on
development.

I think that it's great to learn so many tools, Oracle Workflow,
Forms,
Reports, Graphics etc but I wish that I have more time to tune the
database.
Besides, cloning database, backup database, applying oracle patches
to the
HR System, all of my time is spent in development.

Regds,
New DBA
-Original Message-
From:   Boivin, Patrice J
[mailto:[EMAIL PROTECTED]]
Sent:   Tuesday, May 22, 2001 10:06 PM
To: Multiple recipients of list ORACLE-L
Subject:RE: recruiters. Aargh. (More on
them!)

I don't know about this development business.  I
think about
this a lot (I
don't have a life).

I keep an eye on Developer, Jdeveloper, Cherokee
(which is
dead I hear),
Visual C++, etc. etc.  but I am not great at any of
them.

There is just too much for one person to learn and
be good
at both sides, in
my opinion.

If I had a project to handle I would prefer hiring a
team of
people which is
composed of outstanding DBAs and outstanding
developers,
each good in their
own field, rather than hire a bunch of people who
can do a
little of
everything.

When you put specialists together with clear areas
of
expertise, in a team,
you may end up with something greater than the sum
of its
parts (gestalt).

If you put a bunch of OK generalists together, you
will end
up with... a
workgroup and OK result.  Probably.

As a DBA I am more interested in learning about SQL
Server,
DB2, and others,
and in OSes than in doing development.

That's just my personal preference.

Maybe if I was a great developer I could do
contracts and
drive a Porsche
like my NT instructor did, I don't know.  Maybe once
I am
confident I know
enough about the foundation my development work
would run
on...

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 Messa

RE: Oracle Reports coredump

[Carle, William T (Bill), NLCIO]

Dan,

I have the 6i version on HP-UX 11.0. It's all on one machine. I'm just
trying to create some sample reports to familiarize myself with the product.
It seems to coredump from time to time for no apparent reason.


Bill Carle
AT&T
Database Administrator
816-995-3922
[EMAIL PROTECTED]

 -Original Message-
Sent:   Tuesday, May 22, 2001 5:21 PM
To: Multiple recipients of list ORACLE-L
Subject:RE: Oracle Reports coredump

No, I've been using reports for a couple of years and never had that
behavior.  Which version which part?  Is it the client side or the server
side?

Dan

-Original Message-
Sent: Tuesday, May 22, 2001 5:16 PM
To: Multiple recipients of list ORACLE-L


Hi,

I recently installed Oracle Reports and I'll work fine for a while. Then
I'll get a coredump. Has anyone else had a problem with that and know what
might be wrong?


Bill Carle
AT&T
Database Administrator
816-995-3922
[EMAIL PROTECTED]

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Carle, William T (Bill), NLCIO
  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).

_
This e-mail message has been scanned for the presence of all known computer
viruses by the MessageLabs Virus Control Center.  However, it is still
recommended that you use local virus scanning software to monitor for the
presence of viruses.  
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Dasko, Dan
  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: Carle, William T (Bill), NLCIO
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Oracle Reports coredump

[Magrogan Michael A]

We've had similar problems with the 6i runtime, using patchset3a.  Metalink
says it's fixed in patchset 4.

-Original Message-
Sent: Tuesday, May 22, 2001 5:16 PM
To: Multiple recipients of list ORACLE-L


Hi,

I recently installed Oracle Reports and I'll work fine for a while. Then
I'll get a coredump. Has anyone else had a problem with that and know what
might be wrong?


Bill Carle
AT&T
Database Administrator
816-995-3922
[EMAIL PROTECTED]

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Carle, William T (Bill), NLCIO
  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: Magrogan Michael A
  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: Database Down

[Rachel Carmichael]

Paul you leave me NOTHING to add to this.  :)

Laura. I would do exactly what Paul said, and include what you thought 
to do (which is backup the good disks before you do anything else).

First rule of recovery: ALWAYS have a way to start all over again if you 
mess up.

After that, follow Paul's list :)

Once that is done, take a deep breath, then go find out who you have to 
stomp on to get the backup logs reviewed AS SOON AS THEY COMPLETE. (You 
might want to automate something that checks for errors and pages you). Find 
out why no one knew there was a problem with the backup and why it waited 
until you came in.

Yell. Scream. And DOCUMENT what went wrong... to everyone you can think of.

Rachel

>From: Paul Drake <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: Re: Database Down
>Date: Wed, 23 May 2001 00:00:23 -0800
>
> > "Burton, Laura L." wrote:
> >
> > I have an Oracle 8.0.5 database residing on a Windows NT operating
> > system which uses Raid5.  The 'almost never' has happened; two disks
> > have gone bad at the same time.  As fate would have it the 'complete'
> > physical backup performed the day before the disks crashed (Friday,
> > May 18) cancelled.  Of course this happened on Saturday on a weekend
> > in which I was out of town and did not get back in until late this
> > afternoon.
> >
> > My system admin said he restored the drives on the bad disks from a
> > physical backup created the previous Friday (May 11) and then restored
> > the differential backup from this past Thursday (May 17).  The Archive
> > files were also on one of the disk that went bad.  I have looked at
> > the alert log and the hot backup executed on the Thursday prior to the
> > Saturday crash completed successfully.  Something that does not seem
> > right, and I'll talk with my system admin tomorrow, is that when I
> > looked at the datafiles and archive logs he restored they were all
> > dated May 11, the date of the complete backup.  If he applied the
> > differential as he said, does this not add the archive logs written
> > from May 11 through the May 17 differential backup?  According to the
> > alert log it looks like I am missing approximately 438 logs.
> >
> > I thought I would have to restore all datafiles and archive logs from
> > the physical backup so that they would be in sync, and then 'recover'
> > the database using the hot backup.  This would only incur minimum data
> > loss since Saturday is a non-work day for most employees.  After
> > reading the Backup and Recovery manual it looks like all I have to do
> > is 'recover' the database using the hot backup.  Wouldn't it matter
> > that the datafiles would not currently be in sync since the datafiles
> > on the disk which did not crash were ok and not restored?  Since the
> > hot backup would restore all the datafiles I would think it wouldn't
> > matter.  Correct??
> >
> > I would appreciate some second and third opinions.  This is my first
> > 'live' recovery and I want to make sure as much as possible that I do
> > what will have the least impact on data loss.  It goes without saying,
> > but I will have a complete backup of the 'good' disks before I tackle
> > this beast.
> >
> > Thank you in advance,
> > Laura
>
>0. caffeine.
>
>1. (you already know this) your latest archived redo log is what you
>will be able to recover the database to  - nothing further. I assume
>that a budget for duplexed archived redo logs will be forthcoming.
>Network Attached Storage is possibly an even better solution - with
>scheduled jobs to propagate archived logs to the NAS box.
>
>2. You *will* be performing incomplete recovery. Recover until cancel,
>preferably with a backup controlfile.
>Did you create a backup controlfile as part of the hot backup on May
>11th? Restore with that controlfile.
>
>3. After the recovery is completed (you've opened RESETLOGS) close the
>database and get a *full* cold backup. Fight the urge to *get the
>database open* when you don't have anything to intiate your next
>recovery from. You don't want to have to repeat this entire processes
>*ever* again.
>
>4. Possibly, you want to have the SysAdmin restore the thursday night
>archived redo logs (17th) to a different folder than the previous backup
>set (11th). This may be the reason why the later set of archived
>redologs is not appearing.
>
>5. If you have more recent copies of datafiles than the May 11th backup
>set - move them to a different directory - and restore the entire hot
>backup set. Recovery will attempt to recover all datafiles to be in-sync
>at a specific SCN#. To have some datafiles ahead of that SCN could cause
>more problems. If you were attempting complete recovery - I would
>recommend otherwise.
>If you force the database open in an inconsistent manner, you'll have to
>export and rebuild (your last option - next to the data unloader).
>
>From the Oracle 8i Backup and Recovery Handbook
>pg

Reverse engineer tablespaces.

[Jesse, Rich]

So, I need to re-create a database to prepare for migration.  The current DB
is 8.0.6, and I need to create an 8.1.7 copy.  Does anyone have a script to
reverse engineer the CREATE TABLESPACE commands?  I started working on one,
but surely I can't be the first to invent the wheel.

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).

RE: Mailing lists hosted by fatcity

[Eric D. Pierce]

yes, but i was sad that i didn't see a list for beagle 
owning transgendered rocket launch console operators 
from antarctica.

On 23 May 2001, at 9:20, Robertson Lee wrote:

> Knowing that I can get to the 
> 
> "Flight Attendants Association of Australia" list will help me sleep at
> night !!


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Eric D. Pierce
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Reinstall query - NT

[O'Neill, Sean]

We had to install a EE version of 8i Rel 3 onto a server with Win NT because
the Standard
edition CD had not been shipped to us and a deadline had to be met.  I now
want to 
install the Standard Edition of the software on the server for licence
compliance 
reasons.  Can I remove the Oracle EE software completely form my machine,
i.e. as per 
MetaLink Doc ID 75061.1, "Cleaning all Oracle products from a Machine" and
install 
the Standard Edtion without implications for my existing databases assuming
I have 
off line backups of same and disk structure remains same?.  The exisitng
DB's don't use any EE
specific cartridges etc.

Are there some files I would NOT want to delete?.  

Is there a simpler way to go about above?

Sean :)

Rookie Data Base Administrator
[0%] OCP Oracle8i DBA
[0%] OCP Oracle9i DBA
  
Organon (Ireland) Ltd.   
http://www.organon.ie
E-mail: [EMAIL PROTECTED]   [subscribed: Digest Mode]

Visit: http://groups.yahoo.com/group/Oracle-OCP-DBA

"Nobody loves me but my mother. and she could be jivin' too." - BB King

-- 
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  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: Multiple schema's or multiple databases

[Diana_Duncan]

In 8.1.x, as long as your schemas have their own tablespaces, you could to
TSPITR (Tablespace Point in Time Recovery).

Diana Duncan
TITAN Technology Partners
One Copley Parkway, Ste 540
Morrisville, NC  27560
VM: 919.466.7337 x 316
F: 919.466.7427
E: [EMAIL PROTECTED]


   
   
John Lewis 
   
   
works.com>  cc:
   
Sent by:Fax to:
   
[EMAIL PROTECTED]Subject: RE: Multiple schema's or 
multiple databases  
   
   
   
   
05/22/2001 07:36   
   
PM 
   
Please respond 
   
to ORACLE-L
   
   
   
   
   




Something to ponder. The archive logs are tied to the system. Thus, if you
want to recover to a point in time for a multi-schema /one instance system,
if one schema gets rolled back - everything gets rolled back.

We had this same issue.  Perhaps someone knows a way around this.
 -Original Message-
 From: Christopher Spence [mailto:[EMAIL PROTECTED]]
 Sent: Tuesday, May 22, 2001 2:26 PM
 To: Multiple recipients of list ORACLE-L
 Subject: RE: Multiple schema's or multiple databases

 1.  Is that performance gain absolutely necessary?

 What happens if one company goes down and takes down them all.


 On another note, I tend to agree on lesser instances against more
 instances.  Easier to tune, better perforamance due to what I call
 instance wastage and much easier to maintain.  But if one system
 changes alot, has significiantly different access methods, or goes up
 and down more than anyone, I would evaluate seperate instances.

  -Original Message-
  From: Sam Roberts [mailto:[EMAIL PROTECTED]]
  Sent: Tuesday, May 22, 2001 1:41 PM
  To: Multiple recipients of list ORACLE-L
  Subject: Multiple schema's or multiple databases

  Oracle 8.1.6 and Solaris
  I'm going to inherit production databases when I start my new job
  next week. I gather that the production database consists of 8
  schema's (8 companies) that are all in one database. Its an ERP
  package called Maximo and it interfaces to Financials 11i
  databases (don't know if this is multiple databases or schema's
  yet).
  Apparently there is some data passing between companies and
  multiple schema's perform better than using database links with
  multiple databases, and this is the reason for multiple schema's.
  Does anyone have an opinion on this. If I'd have done it I would
  have done multiple databases as they are separate companies, but
  I'm open to comments as not quite got my head round it yet, plus
  I've been vacationing (partying) for 3 weeks.

  Thanx

  Sam









-- 
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).

Components removal - W2K

[O'Neill, Sean]

We have Oracle 8i Rel installed on a W2K server.  The Oracle Home is located
on the E: drive.  Yesterday an "accidental" deletion occured of files on the
C: drive which resulted in files being deleted in the C:\Program
Files\Oracle dirs and below.  No backup exists of these files :(

So I'm wondering 
[1] What implications this has for the Oracle install?  E.g. I suspect
records of installed components may have been deleted.  

[2] What can I do to replace these files from Oracle install CD?

Any advice would be much appreciated!


Rookie Data Base Administrator
[0%] OCP Oracle8i DBA
[0%] OCP Oracle9i DBA
  
Organon (Ireland) Ltd.   
http://www.organon.ie
E-mail: [EMAIL PROTECTED]   [subscribed: Digest Mode]

Visit: http://groups.yahoo.com/group/Oracle-OCP-DBA

"Nobody loves me but my mother. and she could be jivin' too." - BB King



-- 
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  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: Database Down

[Burton, Laura L.]

Title: RE: Database Down





My database is up and with no data loss!!!  I was able to do a complete recovery, not incomplete.


After the coca-cola (for caffeine) to calm my nerves I had the sysadmin restore the datafiles and archive logs from the hot backup from Friday.  The control files 1 and 2 were restored because they were on the corrupted disks, but I had a 3rd copy which I used to recover the database.  It worked just like Case 4 and all is well.

Just a note, I am glad I had another copy of the control file.  When I tried to use the file that had been restored I received an 'old controlfile' error.  

I do have the Backup and Recovery book by Rama Velpuri (v7.3) and it helped.  This is one of those things I have wanted to do but have never had time to do...  It has been about 3 years since I took the class and the 'use it or lose it' scenario has taken over.

Thanks to all who replied!!


Laura


-Original Message-
From: Jared Still [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 23, 2001 11:32 AM
To: Multiple recipients of list ORACLE-L
Subject: Re: Database Down



On Wednesday 23 May 2001 01:00, Paul Drake wrote:
>
> 0. caffeine.


Agreed.


> 2. You *will* be performing incomplete recovery. Recover until cancel,
> preferably with a backup controlfile.
>    Did you create a backup controlfile as part of the hot backup on May
> 11th? Restore with that controlfile.


Is there a particular reason for recommending the backup controlfile?


Shouldn't be needed unless the controlfile has been lost.


> 3. After the recovery is completed (you've opened RESETLOGS) close the
> database and get a *full* cold backup. Fight the urge to *get the


Some repetition for emphasis here.  As Paul says, a cold backup must be
completed before any work is done on the database.  



Some add'l advice for Laura.  Read Rama Velpuri's book 'Oracle Backup
and Recovery Handbook' cover to cover, and do all of the exercises.  It
will make an immense difference in your understanding of recovery.


Backup is easy, recovery is not always so.


Jared
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jared Still
  INET: [EMAIL PROTECTED]


Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California    -- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: help me : error on import

[Daemen, Remco]

It has to do with your NLS environment settings. If you're on unix, make
sure the NLS_LANG variable is set to the same value as it was during the
export.

HTH,  Remco

-Oorspronkelijk bericht-
Van: benajam lhoussain [mailto:[EMAIL PROTECTED]]
Verzonden: dinsdag 22 mei 2001 19:00
Aan: Multiple recipients of list ORACLE-L
Onderwerp: help me : error on import 



Export file created by EXPORT:V08.01.07 via conventional path
import done in WE8ISO8859P1 character set and WE8ISO8859P1 NCHAR character
set
IMP-00069: Could not convert to environment national character set's handle
IMP-0: Import terminated unsuccessfully

thanks

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: benajam lhoussain
  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: Daemen, Remco
  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: Sun Solaris 8 - Listener failed to start a dedicated server p

[Jyoti N]

Hi ,
Your problem is actually highlighted on the error message "Solaris Error: 12: Not enough space"
It is more of an Operating system resource issue. I gather that you are running about 8 instances on this machine ,right? 
Shutdown couple of unused or low priority instances and see whether you can connect.
If it does not happen, try rebooting the unix box and do a clean start . 
HTH,
Click to add Jyoti R's LiveCard to your address book. 
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: Jyoti N
  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).