This content has been marked as final. Show 4 replies
If your listener is not running, please, start one. If it is, try changing the port from the default value of 1521 to something else.1 person found this helpful
I write the error in first message. I can connect to oracle via PL but can't connect via R from client and can connect on server.
Have you tried any of the suggestions? Can you connect on the client via <tt>sqlplus</tt> using <tt>sqlplus user/pass@db</tt>? If yes then <tt>ore.connect("user", password = "pass", conn_string = "db")</tt> should also work. If <tt>sqlplus</tt> works while <tt>ore.connect</tt> still does not, please, paste both the <tt>sqlplus</tt> and <tt>ore.connect</tt> sessions and I'll try to troubleshoot.
my error was been for host name. I had set it =localhost. I change it by IP number of server and I can connect