View original (French)

Oracle installation issue

Solved
ptisephy Posted messages 78 Status Member -  
ptisephy Posted messages 78 Status Member -
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

2 answers

  1.
    jee pee Posted messages 9439 Registration date   Status Moderator Last intervention   9 977
     
    Hello,

    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.

    0
    1. ptisephy Posted messages 78 Status Member
       
      Thank you for your feedback. If I understand correctly, I need to install the Oracle server. I only installed the client, which is why it's not working?
      0
      1. jee pee Posted messages 9439 Registration date   Status Moderator Last intervention   9 977 > ptisephy Posted messages 78 Status Member
         
        Yes, 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
        0
  2. ptisephy Posted messages 78 Status Member
     
    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.
    0