Re: Odd core dump - possibly listener related

2001-05-25 Thread rupali belsare

--core dump ended up in $ORACLE_HOME/dbs

i think there is no space in the destination where u r storing the dumps... just
one point to have a look atmay or may not be correct

RB

"Deshpande, Kirti" wrote:

> Hi Lisa,
> Yes, we have seen this occasional core dump in the ?/dbs dir. Tried to chase
> it down, gave up on OWS and TAR got closed. The last time it happened was a
> month or so ago on HP-UX 11.0 and 8.1.6.2.  As you said, there are many
> other things to worry about.
>  If your 'mini-me' chases this down, I would like to know. BTW... How does
> he like Oracle's new music selection?
>
>  Congratulations for getting another job !!
>  Going further South or back to North?
>
>  Regards,
>
> - Kirti Deshpande
>   Verizon Information Services
>http://www.superpages.com
>
> > -Original Message-
> > From: Koivu, Lisa [SMTP:[EMAIL PROTECTED]]
> > Sent: Thursday, May 24, 2001 10:57 AM
> > To:   Multiple recipients of list ORACLE-L
> > Subject:  Odd core dump - possibly listener related
> >
> > Hello all,
> >
> > My mini-me (aka Junior DBA) noticed a core dump this morning.  Good,
> > attention to detail.  However, there's no unusual errors in the alert log
> > for either databases on this host and there's no errors in the listener
> > log at all.  The core dump says something about pseudo cursor and
> > references a port that isn't dedicated to the listener.
> >
> > Here's my take on it:  The database is fine.  The listener is fine.  The
> > app is fine.  With nothing in the logs I have no idea where to look.  I
> > don't even know how this core dump ended up in $ORACLE_HOME/dbs (the
> > default), my core_dump_dest is set to a different directory.  Searching on
> > metalink returns nothing.
> >
> > Mini-me (mini?  6'4") wants to chase this down.  I think it works, don't
> > fix it.  The occasional core dump is normal and there are a ton of other
> > things to attend to.  Does anyone disagree?
> >
> > So my question is, has anyone seen this before?  we are hp/ux 11.0,
> > 8.1.6.2
> >
> > Thanks everyone, and au revoir.  I start a new job on Tuesday.
> >
> > Lisa Rutland Koivu
> > Oracle Database Administrator > "urn:schemas-microsoft-com:office:office" />
> >
> > Certified Self-Important Database Deity
> >
> > Slayer of Unix Administrators
> >
> > Wanton Kickboxing Goddess
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> --
> 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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: rupali belsare
  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: MS access

2001-05-24 Thread rupali belsare

As far as my knowledge is 2GB.  And I dont think u can cross this limit.

Rups

"Li, Xiangli" wrote:

>
>
> Hi, List
> Is there anyone happen to know what's the database size limitation for
> MS access97? I heard it's 1 gigabytes, how to overcome it if that's
> true?
>
> thanks
> Li

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: rupali belsare
  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: File created by failed Add Datafile command

2001-05-24 Thread rupali belsare

Whatever Jim has said is exactly right procedure... as I have experianced this
type of problem before and cured it in the same way Jim said..

Rupali

Hawkins Family wrote:

> I would take a look at my controlfile first.  Issue a "alter database backup
> controlfile to trace;".
>
> Take a look at two things:
> 1.  What is your maxdatafiles set to?
> 2.  Does this new datafile appear in the datafile list?
>
> If it doesn't, I would not delete this datafile, but just rename it so you
> could always go back to it.  Reissue your add datafile command and see what
> happens.  If anything gets screwed up, you can always rename your renamed
> datafile back.
>
> HTH,
> Jim
>
> ^
> Jim Hawkins
> Lead SAPR/3 Oracle Database Administrator
> MEMC Electronic Materials, Inc.
> 501 Pearl Drive
> St. Louis, MO  63376
> (636) 474-7832
> [EMAIL PROTECTED] (work)
> [EMAIL PROTECTED] (personal)
> ^
>
> -Original Message-
> Sent: Thursday, May 24, 2001 9:15 AM
> To: Multiple recipients of list ORACLE-L
>
> Yesterday I went to add a new datafile and the command failed because I
> already had datafiles = db_files value.  No problem, I increased the
> parameter and waited until this morning since this database is shut down
> every night.
> I ran the command this morning and discovered that the file was in in fact
> created on the OS even though it didn't appear in dba_data_files.  The time
> stamp on the file was the time I created it yesterday (all other files have
> a timestamp of this morning).
> I assume I can just either delete this file and reissue the command or issue
> the command with the REUSE option?  I was about to do that and decided to
> double check with the experts :) since I've never encountered the specific
> situation before and I still have a week before I really have to worry about
> space on this tablespace.
>
> Thanks in advance,
> Jay Miller
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Miller, Jay
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Hawkins Family
>   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: rupali belsare
  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).