Home » Infrastructure » Windows » Re: running 2 databases with the same name on on 1 host
Re: running 2 databases with the same name on on 1 host [message #99390] Mon, 15 October 2001 10:13 Go to next message
Ivan Beletsky
Messages: 1
Registered: October 2001
Junior Member
What version of Oracle are you running? If this is Oracle8, you cannot run two instances with the same name on one host. Oracle documentation (http://www.csee.umbc.edu/help/oracle8.bak/server803/A54894_01/ch9.htm) says:

Naming Conventions for Oracle8 Databases

Before creating a database, it is important to understand that starting with Oracle8, all mounted Oracle databases on a given computer must have unique database names. A database name is associated with a database at `CREATE DATABASE' time and stored in the control file(s) of the database. If the database keyword is provided in the CREATE DATABASE statement, then that value becomes the database name for that database. If not, then the value of the DB_NAME parameter in the INITSID.ORA file is used. If the DB_NAME parameter is not specified, then the default DB_NAME value is ORACLE.

If you attempt to mount two Oracle8 databases with the same database name, you receive the following error during the second mount:

ORA-01102: cannot mount database in EXCLUSIVE mode

To change the name of an existing database, you must use the CREATE CONTROLFILE statement to recreate your control file(s) and specify a new database name. This restriction is imposed only on Oracle8 instances. Any Oracle7 instances running simultaneously with an Oracle8 instance are not subject to this restriction.

Greetings,

Ivan Beletsky
OCP DBA, SCSA

----------------------------------------------------------------------
Re: running 2 databases with the same name on on 1 host [message #198137 is a reply to message #99390] Sun, 15 October 2006 13:58 Go to previous message
nabeelkhan
Messages: 73
Registered: May 2005
Location: Kuwait
Member

yes you can have 2 oracle instances with same name on ONLY A UNIX box, not on WIN BOX reason is that in windows the services name have to be unique but in Unix they are seprate and dun know each other.

Previous Topic: UPDATE does not work in VB6
Next Topic: OLE2 doubt
Goto Forum:
  


Current Time: Thu Dec 08 16:03:15 CST 2016

Total time taken to generate the page: 0.05359 seconds