RE: BusinessObjects and Oracle - ora 1034 error SOLVED!

Hello all,

First, thanks to all who have replied and provided some valuable suggestions. Apparently, the culprit was the Bus Obj's itself. Using the Supervisor's Scan and Repair Domain functionality, we were able to fixed the problem, taking care of the Document Domain and the connection to Oracle.

Once again, thanks to all who have taken the time to help out. Much appreciated.

Cheers,
Ed

• George.Brennan_at_warnermusic.com wrote:
  > Yep that looks fine,
  >
  > hmmm, Business Objects looks like it can find the
  > security domain on an Oracle server but it can't
  > find a server for the document domain.
  >
  > 1. Check the BO connection to Oracle from the NT
  > box, the connection IN the BO DocAgent not the
  > sqlnet one.
  >
  > George.
  >
  >
  > > -----Original Message-----
  > > From: "Ed" <junior_peon_at_yahoo.com>
  > [mailto:junior_peon_at_yahoo.com]
  > > Sent: Friday, May 12, 2000 2:24 PM
  > > To: George Brennan_at_IT@WMINTL19
  > > Cc: smtp_at_inl001@servers[<ORACLE-L_at_fatcity.com>]
  > > Subject: RE: BusinessObjects and Oracle - ora 1034
  > error
  > >
  > >
  > > 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