CODEWITHSUNDEEP
oracle-databaseoracle-sqldevelopersqlplusubuntu-18.04ora-12545
Методи Владимиров
Методи Владимиров

Reputation: 31

ERROR: ORA-12545: Connect failed because target host or object does not exist

I followed this steps to install Oracle 19.6.0 for Ubuntu 18.04:

https://medium.com/@TechExpertise/installing-oracle-sql-developer-on-ubuntu-16-04-lts-bfa4af959deb

Then for some reason I was not able to open sqlplus, so I followed this steps as solution:

https://gist.github.com/tcnksm/7316877

And now I want to log in sqlplus by typing sqlplus / as sysdba, but I am getting:

ERROR: ORA-12545: Connect failed because target host or object does not exist

So I think I have to make the appropriate settings in listener.ora and tnsnames.ora, but I am missing this files.

Upvotes: 0

Views: 6126

Answers (1)

pifor
pifor

Reputation: 7892

SQL Developer and SQL*Plus are client only tools that connect to a database that must be running somewhere: either on the same host or on another host.

If this database exists you should have its connect string to connect to it with SQL Developer or SQL*Plus

If this database does not exist, you must first create it: there are several ways to do this in addition to install Oracle Database (server - not client) and to create a database:

  1. install Oracle XE 18c on Oracle Linux or Windows: installation will install database software and create a database at the same time (easier for non database specialist)
  2. use a pre-installed VM such as: https://www.oracle.com/database/technologies/databaseappdev-vm.html.

Upvotes: 0

Related Questions