oracle ora-12545 target host or object does not exist

while trying to login into the oracle account , i was unable to login into the system resulting the message “oracle ora-12545 target host or object does not exist” .And i finally solved orac 12545 target host or object not found .

How i solved this issue:

Actually , orac 12545 target host or object not found problem was encountered when i tried to login into the database server from the client machine where client oracle was installed. I don’t think  which files are created during the client oracle installation .But  let me tell you that the listener.ora file will not be created during the client installation because listener.ora file contains the information to listen the request send by the client which clearly indicates that this file will be created in the oracle database server.

oLets move towards the solution,

Windows Based Solution:

GO TO  Oracle/product/102.0/admin/db_1/network/ADMIN/

In the above location you will find two files : sqlnet.ora and tnsnames.ora

If these two files i.e. sqlnet.ora and tnsnames.ora are not present this is the error. Please Make Sure this file exsists.

If Exsists then check the configuration

# tnsnames.ora Network Configuration File: c:\oracle\product\10.2.0\db_2\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = Lenovo-PC)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)

EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)

In the above configuration make sure that host name can be pinged from your PC. .i.e ping Lenovo-PC must work.

if it successfully pings then the  host is configured properly.

Note: better use the ip of the host machine. I have the same issue which i solved by replacing hostname value with its ip i..e

ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = Lenovo-PC 192.1689.0.100)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
LInux/Unix Based Solution:The solution is same as above mentioned . You just need to check the host machine ip or name in tnsnames.ora file. But you must know where this file resides in oracle database.Location of tnsnames.ora , sqlnet.ora in Linux Oracle is : /u01/app/oracle/oradata/ After you find the required file the solution is same as i mentioned above.NOTE: Make Sure that Host machine is in running condition and listener status is in start mode.
Hope You understand and this article is helpful to you,

Visit Us On FacebookVisit Us On Google PlusVisit Us On Youtube