44598

How to connect to Oracle 10g from remote client?

Question:

Using the standard Delphi dbexpress dbexpora.dll + oci.dll (10g) (the oracle instantclient is installed).

When directly on the Oracle Database box we can run dbexpress apps just fine. The local dbxconnections.ini alias used in that case simply specifies our DB service name ORCL as the "database" parameter.

We are trying to connect to this same database from client machines and receiving a series of errors.

Naturally, we are trying all manner of strings in the database parameter. Using a string like, MOHAWK2:1521:ORCL we are at the point where we can at least get a listener error:

Failure to Connect: ORA-12514 TNS:listener does not currently know of service requested in connect descripter.

I imagine there are some tools to test the naming availability...

Answer1:

Use TNSPING on the server to see how it's resolving the service name. Various configuration options and files can map a simple designation to a full server/port/service.

C:>TNSPING ORCL

Used TNSNAMES adapter to resolve the alias Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = XE))) OK (0 msec)

Extract out the server/port/service and construct the connect string in whatever format the component or connection method your using needs.

Answer2:

Is the listener setup and running on the oracle server? Is it accepting connection for the instance/service of the database you are connecting to? Have you checked with lsnrctl status? Have you try turning on sqlnet logging and listener logging to see if you are even making a connection to the database from the remote site and what error is recorded in the listner log as to why its refusing service? Is the listener accepting tcp connection or is the listener only accepting IPC connection? without listening for tcp connection, it won't accept remote connections.

Answer3:

Check connectivity using tnsping first. If OK, try connecting with sqlplus. If tnsping fails you are using incorrect service name, or you haven't configured your client properly. If you are relying on local configurations, the file to edit is tnsnames.ora in ORAHOME\NETWORK\ADMIN which will need configuration settings in order to locate the server, and this includes host, port and service name.

Answer4:

Sorry, about the CAPS, this is all new to me. I don't have any reputation, what i did have has now been lowered do to this question title being in caps. I dont know how to comment to you all who have answered........casue it wont let me.....i dont have enough reputation. I guess i need to move onto another forum....

anyway,

Solved!

I setup a new vmware clone - installed the oracle client and our couple of dlls and exes in a dir and it worked.

So I removed everything extraneous on the box I was working with and bingo.

I think it was Interference from the delphi 2007 that was already on that machine...despite trying to path everything right around it.

Recommend

  • Oracle TNS - can't connect through ODBC Administrator
  • upickle read from scalaJS - upickle.Invalid$Data: String (data: 1)
  • CakePHP file upload errors
  • Renaming an element with name Standard into Product using xslt
  • Django ModelForm not saving data
  • set and get value using Session storage for html drop down with jquery
  • process-local override of name resolution?
  • defproject Compiler Exception
  • Bigcommerce Python API, how do I create a product with an image?
  • Overriding createToolTip() in a custom CellRenderer
  • Change storage class of (existing) objects in Google Cloud Storage
  • ERROR in Metadata version mismatch for module
  • error C2099: initializer is not a constant
  • How to define log4j2 path by application.properties?
  • IE10 strips out hashtag from the URL
  • Is there some graphical way to create my own configuration file on SonarLint?
  • Image map in Flex
  • Function calls are not supported. Consider replacing the function or lambda with a reference to an e
  • Updating both a ConcurrentHashMap and an AtomicInteger safely
  • Entity Framework Code First TPC Inheritance Self-Referencing Child Class
  • Spring Cloud Microservice Architecture Confusion
  • Django simple Captcha “No module named fields” error
  • How to write order and limit within cakephp joins array
  • Could not find rake using whenever rails
  • D3 nodes and links from JSON with nested arrays of children
  • How can I send an e-mail from a vbs script
  • Is there any way to access browser form field suggestions from JavaScript?
  • Jenkins: How To Build multiple projects from a TFS repository?
  • How to make a tree having multiple type of nodes and each node can have multiple child nodes in java
  • Resize panoramic image to fixed size
  • Volusion's generic SQL folder, functionality
  • How to add a column to a Pandas dataframe made of arrays of the n-preceding values of another column
  • script to move all files from one location to another location
  • Is there a mandatory requirement to switch app.yaml?
  • How do you join a server to an Active Directory (domain)?
  • coudnt use logback because of log4j
  • Can Visual Studio XAML designer handle font family names with spaces as a resource?
  • Running Map reduces the dimensions of the matrices
  • UserPrincipal.Current returns apppool on IIS
  • Android Heatmap on canvas or ImageView