rename database [message #186386] |
Mon, 07 August 2006 14:58 |
sweet_angel
Messages: 4 Registered: July 2006
|
Junior Member |
|
|
once again
Hi all
i am a newbie to oracle database with an issue
i currently have a production database(LIVE) and a standby database to the production database (LIVEBY).
The production machine initSID.ora file has the database name, domain name etc as
db_name = "LIVE"
#
db_domain = gbti.com
#
instance_name = LIVE
#
service_names = LIVE.gbti.com
#
the standby machine has the initSID.ora file has the database name, domain name etc as
db_name = "LIVE"
#
db_domain = gbtibank.com
#
instance_name = LIVE
#
service_names = LIVEBY.gbtibank.com
#
my problem is when i do a database failover of the standby database i cannot access the new production database with out putting @LIVEBY
eg user/pwd@LIVEBY
what parameters or name do i need to change so that i can now access the standby database as 'LIVE'
Regards
|
|
|