| Re: running 2 databases with the same name on on 1 host [message #99390] |
Mon, 15 October 2001 10:13  |
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
----------------------------------------------------------------------
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
