RE: BusinessObjects and Oracle - ora 1034 error

Anita,

We did not do anything to change the config/setup values, with exception of the weekend backups.

I concurred with you on the tnsnames. We checked the other possible tnsnames BusObj may be using. It is using the one with Protocol=Beq, not the one with the correct sid.

However, before I can confirm this theory, we ran into another issue, a BusObj problem...."..document domain not available".

In the meantime, we are waiting for BusObj tech support to respond to this issue.

Thanks very much for your feedback. I'll update the list when we resolved this.

Regards,
Ed

• "A. Bardeen" <abardeen1_at_yahoo.com> wrote:
  > 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).