Oracle installation issue
Solved
Hello,
I had to install Oracle on a server, but apparently it still doesn’t work, I don’t know why.
From the Oracle 11g client installation program, I started it, clicked next, and installed all the components, and the installation was successful.
I copied my tsnames.ora from my local machine and placed it on the server in the correct location at app\users\product\11.2.0\client_1\network\admin.
When I run a batch with the sqlplus command, it says tns no listener.
I also checked in c:\program files\oracle\inventory\logs, everything is fine. I was told it might be the missing ODBC driver, so I downloaded "instant client odbc," but when I clicked on "odbc install," nothing happened. Then I downloaded the Microsoft SQL Server ODBC driver, the installation went well, but still nothing.
I don’t know why, however, in the services, it is running well and starts automatically.
Thank you for your help
Configuration: Windows / Firefox 70.0
I had to install Oracle on a server, but apparently it still doesn’t work, I don’t know why.
From the Oracle 11g client installation program, I started it, clicked next, and installed all the components, and the installation was successful.
I copied my tsnames.ora from my local machine and placed it on the server in the correct location at app\users\product\11.2.0\client_1\network\admin.
When I run a batch with the sqlplus command, it says tns no listener.
I also checked in c:\program files\oracle\inventory\logs, everything is fine. I was told it might be the missing ODBC driver, so I downloaded "instant client odbc," but when I clicked on "odbc install," nothing happened. Then I downloaded the Microsoft SQL Server ODBC driver, the installation went well, but still nothing.
I don’t know why, however, in the services, it is running well and starts automatically.
Thank you for your help
Configuration: Windows / Firefox 70.0
2 answers
-
ModeratorHello,
Your presentation is not clear because on the server, it is not a client that needs to be installed, but an Oracle server. On the server, the configuration file is primarily the listener.ora, and the tnsname.ora must be in sync with the listener.
So please explain thoroughly your startup process, on the server, on the client PC, ...
Oracle natively does not require the ODBC client between the client and the server. This driver is specifically used for software that cannot directly access Oracle.
-
-
Moderator@ptisephyYes, you do not have an Oracle database
the client is used to access an existing database
to have an Oracle database, you need to install Oracle, the RDBMS kernel, on a server machine
-
-
Thank you and sorry for the late reply.
I found what was wrong; I confused two things. Once the correct package was made available to me, it worked correctly.
