I have checked the status by using "lsnrctl status" and its running now and the next step when i tried to connect to the database the below error is displaying over there. Or youcheck the manual docs. I'll bet your database hasn't started and registered itself with the listener.
How did you create your listener. Your listener. Randolph West 3, 7 7 silver badges 25 25 bronze badges. Nischal Sepahiya Nischal Sepahiya 1. For different listeners on a server you have to use different strings, but it does not matter which string you use. Sign up or log in Sign up using Google. Sign up using Facebook. Sign up using Email and Password.
Post as a guest Name. Email Required, but never shown. The Overflow Blog. Podcast Making Agile work for data science. Here is a example from my testing VM. Sign up or log in Sign up using Google.
Sign up using Facebook. Sign up using Email and Password. Post as a guest Name. Email Required, but never shown. The Overflow Blog. Podcast Making Agile work for data science.
Stack Gives Back Featured on Meta. New post summary designs on greatest hits now, everywhere else eventually. Linked 0. Related Hot Network Questions. Question feed. Lots of answers here, but here comes a working example with code that you can copy and paste and test immediately:. You find that on the server in the file tnsnames. You can also leave it away. In my case the database had ran out of disk space. Which caused it to not respond. Once I cleared up that issue everything worked again.
For me this was caused by using a dynamic ipadress using installation. I reinstalled Oracle using a static ipadress and then everything was fine. In my case i failed to startup but got another error message and found the source of a problem - i had to change host name and then database auto startup was functional again.
Select Database Services from dropdown. Set Oracle Home Directory. Oracle Net Manager window example from oracle documentation:. The problem was that my connection string url contained database name instead of SID.
Replacing database name with oracle database connection SID solved this problem. The correct URL can be found in the tnsnames. For example for Oracle in the VirtualBox the command to see this file is:. Then after this change, I checked the status of listener using lsnrctl status.
Here, I can see the db instances loaded successfully. So, this can a quick workaround to use sqldeveloper. Stack Overflow for Teams — Collaborate and share knowledge with a private group. Create a free Team What is Teams? Collectives on Stack Overflow. Learn more. Asked 9 years, 7 months ago. Active 4 months ago. Viewed 1.
We have an application running locally where we're experiencing the following error: ORA TNS:listener does not currently know of service requested in connect descriptor I've tested the connection using TNSPing which resolved correctly and I tried SQLPlus to try connecting, which failed with the same error as above.
Oracle itself on the server is running. We don't know of any changes that were made to this environment. Anything else we can test?
Improve this question. Jacques Jacques 6, 7 7 gold badges 41 41 silver badges 96 96 bronze badges. Also, what are the contents of your sqlnet.
Since they supposed to inform the Listener about their existence on startup this might fix your problem. After researching enough found the right solution here shekhargulati. Show 1 more comment. Active Oldest Votes. Improve this answer. Brad Rippe Brad Rippe 3, 1 1 gold badge 17 17 silver badges 18 18 bronze badges.
How am I supposed to query the DB if I'm not able to even connect to it?? Can you ssh to the DB server directly and run sqlplus from there? ORA table or view does not exist — Tommy Holman. Show 5 more comments. For example, your listener. And to make it recognize a service name of orcl , you might change it to: listener. Kevin Joseph Argenio Joseph Argenio 5 5 silver badges 4 4 bronze badges. Need to update this answer with the syntax of how listener.
I don't even have a listener. I don't have an Oracle Listener service to restart. After following Sepideh's instructions involving the Net Manager, I noticed that my listeners. I have edited this answer to include a before-and-after example of the syntax, for the benefit of readers that can't use the Net Manager, for whatever reason.
0コメント