He spends his spare time updating this blog and likes to read books on self help and productivity. Thanks it worked like a charm. Wasted my half a day and finally got your blog and it solved the issue. Actually i am trying to connect both mysql and oracle. Can you help me plzz Thanks in Advance. I have this files on my Tnsnames. This file is actually generated by netca. As soon as I removed the leading spaces, my tnsping worked and some more sensitive applications than others started to connect fine.
I have spend hours trying to fix this issue, I follow your notes and fixed it in les than 2 minutes. Sometimes the little things count. I also struggle a lot to resolve this issue what i found it has been added space in tnsnames. Please log in again. The login page will open in a new tab. After logging in you can close it and return to this page. This is the most exhaustive table list.
Updated for PeopleTools 8. Never Again Google It! Complete List of PeopleTools now. I thought I needed a Loopback Adapter.
In this blog i tried to give all possible solution for this problem. All rights reserved. Cause: Possible reason for this error as: 1. Check the tnsnames. Check PDBs database is listed in Listener services command.
Service "pdb1" has 1 instance s. Create the tnsnames. You can also check Oracle Home you are using is correct. Check PDBs database is listed in Listener services 3. If entry in not listed in listener services then add service entry manually: 1. Tried to add dynamic entry with Alter system command. Reload the services and check the lsnrctl services command for new entry: lsnrctl services Just make sure that tnsnames.
Sometimes, you might not notice that your tnsnames. No need to say, the solution is either to get one tnsnames. Perhaps, reconfiguring the environment variable if necessary. Sometimes, users misspell the name of connect identifier to connect the database.
So that tools like sqlplus , tnsping or Oracle JDBC driver fails to match a correct entry in tnsnames. For example, we can reproduce TNS by tnsping a deliberately misspelled the connect identifier like this:. The utility can match no one named "comdb" in tnsnames. The correct name is "compdb", I missed one letter on purpose. How do we handle TNS? Just make sure the name you typed matches the connect identifier in tnsnames.
0コメント