DNS Alias / Database name
Hi folks!
I have one question, is it possible to create alias name on DNS server for database (instance) name? I have test db on one machine and after migration i want to use alias name which is called test for second database server machine without changing host name locally or in application.
Is thios possible and what to put in tnsnames?
I have already tried but i fails.
I have done :
Created alias name TEST on DNS name and in its description put host name of server, and ping of it went ok
I wanted to test is this working in case of dblink createion and recevie error Error : ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
I have put in tnsnames this:
TEST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = TEST)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = test)
)
)
If this situation is specific please could you provide me correct entry for my case in tnsnames file?
Thanks!