Abhinav, 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: Hi 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 Rgds, Abhinav 91-22-28290019 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: http://groups.yahoo.com/group/dba_gurus/ To unsubscribe from this group, send an email to: dba_gurus-unsubscribe@xxxxxxxxxxxxxxx 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.