[askdba] Re: [dba_gurus] Max Instances Error

  • From: Nisar Tareen <ntareen@xxxxxxxxx>
  • To: abhinav.saxena@xxxxxxxxxxxxx
  • Date: Mon, 10 Jan 2005 15:46:12 -0800 (PST)

You did not mentioned which env. your database was running , Windows/ Unix. 
Somehow, The database is running and you tried to start the new database that's 
why the problem occurs. 
Just reboot and the problem should be solved for you. 
Nisar Tareen 

abhinav.saxena@xxxxxxxxxxxxx wrote:

The following error has been occured in database:

00306, 00000, "limit of %s instances in this database"
*Cause:  Starting this instance would exceed the maximum number
       of instances allowed for this database.  This message occurs
       only with STARTUP shared and multiple instances.
*Action: You cannot start more than the lower of
          a) port-specific limit as to the number of instances
          b) the number of instances specified at create-database time

Where can i see what is the max_instances parameter defined  and currently
how many instances are open, and how to solve this prob.

what i think is i'll have to change this parameter and then change pfile
and start d/b again. pls help


x :1538


This e-Mail may contain proprietary and confidential information and is sent 
for the intended recipient(s) only. 
If by an addressing or transmission error this mail has been misdirected to 
you, you are requested to delete this mail immediately.
You are also hereby notified that any use, any form of reproduction, 
dissemination, copying, disclosure, modification,
distribution and/or publication of this e-mail message, contents or its 
attachment other than by its intended recipient/s is strictly prohibited.

Visit Us at http://www.polaris.co.in

[Non-text portions of this message have been removed]

Yahoo! Groups Links

   To visit your group on the web, go to:
   To unsubscribe from this group, send an email to:
   Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. 

Do you Yahoo!?
 Yahoo! Mail - now with 250MB free storage. Learn more.

Other related posts:

  • » [askdba] Re: [dba_gurus] Max Instances Error