Ed,
So if this was working before, what's changed on the
machine? ;)
I'm not familiar with BusinessObjects, but how does it
connect to the Oracle db (i.e. do you actually specify
a connect string?) How many Oracle homes are on this
NT box? It's possible that you can connect via
SQL*Plus because it's looking at the TNSNAMES.ORA in a
different location from the one BusinessObjects is
using.
If it doesn't use a connect string, or rather if
you're not prompted to enter one, then my gut feeling
is that a registry entry or environment variable has
been changed.
HTH,
- Anita
- Ed <junior_peon_at_yahoo.com> wrote:
> 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):
>
> 1. that SQL*NET connection is okay?,
> 2. the dblink is okay?
> 3. 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).
>
>
> __________________________________________________
> 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
Received on Fri May 12 2000 - 11:38:05 CDT