OraFAQ Forum: Server Administration » No of Instances on Oracle 9i

Home » RDBMS Server » Server Administration » No of Instances on Oracle 9i

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

No of Instances on Oracle 9i [message #180052]

Fri, 30 June 2006 00:21

amit_nanote
Messages: 56
Registered: July 2005
Location: Indore

Member

Hi,

I want to know the maximum number of instances can opened on Oracle server, simultanously.
Is there any limit specified, or can increased. Please mention the factors also.

regds
Amit

Report message to a moderator

Re: No of Instances on Oracle 9i [message #180055 is a reply to message #180052]

Fri, 30 June 2006 00:43

Frank Naude
Messages: 4580
Registered: April 1998

Senior Member

Backup your controlfile to trace.

SQL> ALTER DATABASE BACKUP CONTROLFILE TO TRACE;

Database altered.

Look at the MAXINSTANCES parameter in the resulting trace file (udump directory):

CREATE CONTROLFILE REUSE DATABASE "O10GR2" NORESETLOGS  NOARCHIVELOG
    MAXLOGFILES 16
    MAXLOGMEMBERS 3
    MAXDATAFILES 100
    MAXINSTANCES 8
    MAXLOGHISTORY 292
LOGFILE
...

Report message to a moderator

Previous Topic:	Unable to install oracle 9i database (R2)
Next Topic:	my ram memory missing

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 10:45:17 CDT 2024