This content has been marked as final. Show 2 replies
Can you try connecting to the database using sqlplus not sql developer. and try to use tnsping orcl to verify the entries are in the tnsnames.ora.
Another check is to search how many tnsnames.ora files are on the system and find out which one is active to add the tns entries.
Hope this helps.
The problem resolved. Issue fixed after giving the database string "orcl" instead of "orcl.world". In most of the docs/steps I saw people are using "sid.world". Still I don't understand the need of ".world". I am thinking it is not full domain name.