I have created a new database and it's TNSnames looks like below:
ETDEV =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = corpext.corp.idt.com)(PORT = 1526))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = etdev.corp.idt.com)
)
)
LISTENER_CGDEV =
(ADDRESS = (PROTOCOL = TCP)(HOST = corpext.corp.idt.com)(PORT = 1526))
I have added above to TNSnames.ora. When I look for listener status, new db doesn't show. It contains the dynamic registration parameters. But, When I do tnsping etdev - it was successful. Not sure, what am i missing here.
DB version: 10.2.0.4
Thank you. Please let me know if you need any information.