This content has been marked as final. Show 5 replies
Hello,1 person found this helpful
your post is a little bit confusing me.
A listener.ora is located on the database server. The tnsnames.ora is a part of the client machine (and also the database server).
If you are configure a tnsnames.ora your should use service_name or sid not both. In case of RAC you use SERVICE_NAME and maybe INSTANCE_NAME.
Also you should use the service_name which is configure on the listener, so your next step should be a lsnrctl status on the database machine to get the correct service_name and use them in your tnsnames.ora
Thank you for reply, phaeus
I used tutorial http://sphinxsearch.com/docs/current.html
May be I didn't understand correctly somthing.
I move listener.ora and tnsnames.ora into /opt/oracle/product/188.8.131.52/db_1/network/admin and change TNS_ADMIN
Now tnsping returns: http://imageshack.us/a/img820/5251/screenhunter10sep171454.jpg
Segmentation fault (core dumped)
I guess this error occured in odbc driver (libsqora). Probably, I have to try another driver (
I think you mix up some things:1 person found this helpful
- You do not need to install Instant Client to connect to a server on the same machine.
- listener.ora belongs to the server, while tnsnames.ora belongs to the client.
- You do not connect to 'localhost', but to a database.
- "tnsping" has nothing to do with "ping".
I assume that you have no sqlnet.ora file.
So, what I would do:
- Remove Instant Client from the machine.
- Put both listener.ora and tnsnames.ora in $ORACLE_HOME/network/admin.
- Undefine the environment variable TNS_ADMIN.
- Try to connect with sqlplus -L user/password@mydb
If that fails, solve that problem first.
- Fix your odbc.ini file.
"ServerName" should by "MYDB", and I don't know what "Database" is. There may by other problems.
How did you come up with this file?
Oh! Thank you very much, Laurenz Albe!
I select to sophisticated way :)
Your solution help me
Laurenz Albe gives helpful answer