George,
Thanks for the feedback. Oracle db sits in a HP box
and it is up since I am able to log in thru' sqlplus
on the NT box.
Am I right in saying that if I can logged in thru
sqlplus from the NT box (BusinessObjects) to a HP box
(Oracle):
- that SQL*NET connection is okay?,
- the dblink is okay?
- the TNSnames is okay.
If these are true, then what gives.....I am stumped.
Any suggestion is most appreciated.
Thanks very much,
Ed
- George.Brennan_at_warnermusic.com wrote:
> 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).
Received on Fri May 12 2000 - 08:24:05 CDT
