RE: BusinessObjects and Oracle - ora 1034 error

> If the Oracle database wasn't started then how could they
> connect through
> SQL Plus?
>

Easy, you can connect to the security domain server but that doesn't have to be the document domain server. Does it?

George.

> You say that the Document Agent Server can't process
> scheduled documents.
> Can anyone connect in Business Objects to do other things
> (such as create a
> new report?).
> Also is BO connecting directly through SQL Net or going through ODBC?
> Perhaps the problem is in the ODBC layer (easy enough to check with an
> Oracle ODBC test).
>
> Or maybe it's one of those weird NT service thingies that I
> read about on
> the list while I'm thanking God I'm on Unix :)
>
> -----Original Message-----
> [mailto:George.Brennan_at_warnermusic.com]
> Sent: Friday, May 12, 2000 8:31 AM
> To: Multiple recipients of list ORACLE-L
>
>
> Looks like the Oracle database isn't starting up.
>
> Look in the Oracle for NT for starting the database.
>
> regards
> George
>
> > -----Original Message-----
> > From: "Ed" <junior_peon_at_yahoo.com> [mailto:junior_peon_at_yahoo.com]
> > Sent: Thursday, May 11, 2000 11:17 PM
> > To: smtp_at_inl001@servers["Multiple recipients of list ORACLE-L"
> > <ORACLE-L_at_fatcity.com>]
> > Subject: BusinessObjects and Oracle - ora 1034 error
> >
> >
> > We have a BusinesObjects universe on an NT box and
> > linked to Oracle database. We ran into a problem that
> > stumped us.
> >
> > The BusinessObjects' Document Agent Server is not able
> > to process any documents scheduled. This was working
> > fine last week and since then, "something" changed.
> > What that "something" is we do not know. This is
> > what happened when we select a report to process:
> >
> > 1. BusinessObjects returned an error message,
> > "Document Domain not found", followed by
> >
> > 2. /home/commadm> oerr ora 1034
> > 01034, 00000, "ORACLE not available"
> > // *Cause: Oracle was not started up. Possible causes
> > include the following:
> > // - The SGA requires more space than was allocated
> > for it.
> > // - The operating-system variable pointing to the
> > instance is improperly defined.
> > // *Action: Refer to accompanying messages for
> > possible causes and correct
> > // the problem mentioned in the other messages.
> > // If Oracle has been initialized, then on some
> > operating systems, verify that Oracle was linked
> > correctly. See the platform specific Oracle
> > documentation.
> >
> > We were able to log to the database using sqlplus on
> > the NT box that houses the BO repository. We have
> > re-boot the server a few times, again without success.
> > (This has happened before and usually a re-boot of the
> > NT server will restore the document agent functions).
> >
> > I am hoping for divine intervention or from some of
> > you who had experience this or can provide some
> > suggestions from a dba perspective on what to do next.
> > HELP!
> >
> >
> > Look forward to your feedback. Thanks very much.
> >
> > Regards,
> > Ed
> >
> >
> >
> >
> >
> >
> > __________________________________________________
> > Do You Yahoo!?
> > Send instant messages & get email alerts with Yahoo! Messenger.
> > http://im.yahoo.com/
> > --
> > Author: Ed
> > INET: junior_peon_at_yahoo.com
> >
> > 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: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from). You may
> > also send the HELP command for other information (like subscribing).
> >
> >
>
>
> --
> Author:
> INET: George.Brennan_at_warnermusic.com
>
> 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: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
> --
> Author: Miller, Jay
> INET: JayMiller_at_TDWaterhouse.com
>
> 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: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
Received on Fri May 12 2000 - 10:03:44 CDT