Recently I need to create some Schema’s using RCU but It was giving error “Invalid Service Name”. However DB was connecting fine using SQLDeveloper using ORCL sid. But when i used the same in RCU window it threw above error. Then I checked my tnsnames.ora file and it was having different Service Name like below.
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1523))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl.add.com)
)
)
So Instead of ORCL, I used orcl.add.com and it worked fine.