In Oracle world – is it possible to have the same database name in a different server in the same domain? In our test environment the database server is cloned (VMWare) and then our DBA have to reconfigure and change the database name because he said insist it is not possible to have the same database name in a different server in the same domain.
I've experience in MS-SQL server and it's possible to have the same database name in different servers in the same domain so I just need clarification.
Best Answer
Depends on what you mean by Domain. Oracle neither knows nor cares about Windows domains. However there is a DB_DOMAIN database parameter used for networked databases
And there are various ways for clients to connect to Oracle databases (or at least finding out where the database is to connect to) which could also impact database naming.
It can also impact OEM/Grid Control, backing up etc.
And at the simplest level, it is good to be able to determine, from within the database, what database you are in. So most places will have separate names for Prod, Dev and test databases (even or especially if they have been copied from the same source).
So while it may be possible to have multiple, identically names databases on different servers, the DBA probably has good reasons not to do that.