A
A
Akalit2022-03-20 12:26:03
Oracle
Akalit, 2022-03-20 12:26:03

Error connecting to Oracle database on VM ORA-12560?

can't solve problem ORA-12560: TNS:protocol adapter error
Base installed on VM linux / Client on Win10.

  • Ping from client IP VM
  • In odbc data source administrator - test connection succeeded.
  • PL/SQL and Excel - are connected to basis.

And in SQL*Plus - after entering credentials - ORA-12560: TNS:protocol adapter error.
Similar error when connecting in RStudio.

Server
listner.ora

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.32.106)(PORT = 1521))
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
    )
  )


tnsnames.ora

XE =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.32.106)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = XE)
    )
  )

LISTENER_XE =
  (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.32.106)(PORT = 1521))


Customer
tnsnames.ora

XE =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.32.106)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = XE)
    )
  )

Answer the question

In order to leave comments, you need to log in

1 answer(s)
A
Akalit, 2022-03-20
@Akalit

Understood.
When entering a password, you need to specify sid through '@'.
Example.
Name: user (which is specified in dns)
Pass: [email protected]

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question