Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Urgent..DB creation problem..

Re: Urgent..DB creation problem..

From: Jon Walthour <jonw_at_fuse.net>
Date: Sat, 28 Jul 2001 04:44:20 -0700
Message-ID: <F001.0035842E.20010728042547@fatcity.com>

There's not a database on the server yet, that's true. Oracle is just trying to start the instance with the initSID.ora file it has. Are you using MTS? If not, the way to fix the problem is to remove the MTS_DISPATCHERS parameter from your initSID.ora file. To make this work, when the db assistant gets done with all the setup and offers to either create the db or save off the scripts for running later, save the scripts then edit the initSID.ora to make sure the MTS_DISPATCHERS parameter isn't there. Then run the scripts yourself and you shouldn't have that problem.  
Jon Walthour
<BLOCKQUOTE dir=ltr
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">

  Sent: Saturday, July 28, 2001 2:50
  AM
  Subject: Urgent..DB creation
  problem..   

  Hi all,
 

  i'm having a problem in creating
  new database through database config assistant. after giving all information   (both in typical and custom mode) it starts creating DB, but soon shows the   msg "invalid specification for mts_dispatcher in initSID.ora   file.."
 

  while there is no DB on the server,
  how is it reading the init.ora file. i've not specified any new mts_dispatcher   parameter value.
  why it is showing me the error msg.
  how to counter this.
  other errors are oracle not
  available.
 

  error code ORA-00101
  invalid specification for system parameter   MTS_DISPATCHERS
 

  Saurabh Sharma
 

  <A
  href="mailto:saurabh00pc_at_yahoo.com">saurabh00pc_at_yahoo.com<A   href="http://www.geocities.com/saurabh00pc/stride.html">http://www.geocities.com/saurabh00pc/stride.html Received on Sat Jul 28 2001 - 06:44:20 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US