Jay,
We were able to navigate around in BusObj. Ruled out
ODBC connection. Don't think it has to do with NT
although we suspect it is using the wrong TNSnames
(multiple tnsnames on the NT drive).
We deleted the suspect tnsnames but could not test the
connections - ran into a BusObj issue.
Thanks very much for your input.
Regards,
Ed
- "Miller, Jay" <JayMiller_at_TDWaterhouse.com> wrote:
> 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-----
> [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
> also send the HELP command for other information
Received on Fri May 12 2000 - 12:08:22 CDT