Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA 12514: TNS: Listener does not currently know of service.

7a5e4fdb-d9be-4222-a982-13df22814bb5Jun 10 2020 — edited Jun 10 2020

Hi Team,

I am using Oracle 12C.

I set the username in SQL Plus . And then when i logged in with the same username and ran below command

select value from v$parameter where name like '%service_name%';

The value returned is orc1.

When i am trying to connect with the same servicename in SQL Developer, it is throwing the ORA 12514 error.

Please help.

Thanks

Added on Jun 10 2020

#general-database-discussions

3 comments

1,882 views