RE: BusinessObjects and Oracle - ora 1034 error

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

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-----
From: George.Brennan_at_warnermusic.com
[mailto:George.Brennan_at_warnermusic.com]
Sent: Friday, May 12, 2000 8:31 AM
To: Multiple recipients of list ORACLE-L Subject: RE: BusinessObjects and Oracle - ora 1034 error

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