I will be having several database in several servers. One instance(DB) per machine.
I am wondering, is there any benefit of having different DB_NAME for each of these databases? Does having different DB name will make any differenece? Is it mandatory for any implementation, such as MTS, distributed DB etc.?
Please explain me, the benefits of having different DB_NAME for every instance. I am not using GLOBAL DB NAME now.
note: Currently I have a few Instance with the same DB name on different servers. I am trying to determine whether I will keep the same throuhout the organization or change atleat the new ones?
If you run OEM, you might run into an issue. While doing Y2K testing on a bunch of apps, I had copied the production database to another host and kept the db_name. However, the OEM GUI had issues managing both "prod" databases.
Personally, I opt for different db names in case I ever have to host two databases on the same box. What if your organization gets bought out and has to move all their dbs to one massive box?
Originally posted by gsprince But, OEM connects to the DB based on the TNS name and if they are on different servers, it wouldn't be a problem. correct?
Kind of yes, kind of no. True, the GUI connects via the tnsnames.ora alias. However, the "Intelligent" Agent resides on the server side and gets its configuration from the files on server (listener.ora, snmp_r*, etc.).