OraFAQ Forum: Networking and Gateways » target host or object does not exist

Home » RDBMS Server » Networking and Gateways » target host or object does not exist

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

target host or object does not exist [message #166475]

Thu, 06 April 2006 09:16

venkatraghavan
Messages: 83
Registered: October 2005
Location: chennai

Member

i try to clone the database .
.i create instance in the name of clone..then i run the service using oradim ..

then i make changes in pfile.. then using pfile , i startup the DB in nomount stage.

i add entries in tnsnames.ora and listener.ora

then...

SQL> connect admin/admin@clone as sysdba
ERROR:
ORA-12545: Connect failed because target host or object does not exist

but i got above error..what is this error ?? how can i solve it ??

MY LISTERER SERVICES

Quote:

C:\>lsnrctl services

LSNRCTL for 32-bit Windows: Version 9.2.0.1.0 - Production on 06-APR-2006 19:36:
36

Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=CHNBSLWS414)(PORT=1521))
)
Services Summary...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0
LOCAL SERVER
Service "TESTDB1" has 1 instance(s).
Instance "TESTDB1", status UNKNOWN, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:1 refused:0
LOCAL SERVER
Service "clone" has 1 instance(s).
Instance "clone", status BLOCKED, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0 state:ready
LOCAL SERVERThe command completed successfully

C:\>

Quote:

LSNRCTL> services clone
TNS-01101: Could not find service name
NNC-00405: network failure

[Updated on: Thu, 06 April 2006 09:56]

Report message to a moderator

Re: target host or object does not exist [message #166513 is a reply to message #166475]

Thu, 06 April 2006 15:11

madhusunkara
Messages: 59
Registered: March 2006
Location: hyderabad,india

Member

what is the status of clone instance , can you post tnsnames.ora and listner.ora

Thanks
Madhu

Report message to a moderator

Re: target host or object does not exist [message #166625 is a reply to message #166513]

Fri, 07 April 2006 05:15

venkatraghavan
Messages: 83
Registered: October 2005
Location: chennai

Member

Quote:

# TNSNAMES.ORA Network Configuration File: C:\oracle\ora92\NETWORK\ADMIN\tnsnames.ora
# Generated by Oracle configuration tools.

TESTDB1.CHENNAI.BIRLASOFT.COM =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = CHNBSLWS414)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = TESTDB1)
)
)

CLONE.CHENNAI.BIRLASOFT.COM =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = CHNBSLWS414)(PORT = 1523))
)
(CONNECT_DATA =
(SERVICE_NAME = clone)
)
)

NEWDB.CHENNAI.BIRLASOFT.COM =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = CHNBSLWS414)(PORT = 1522))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = NEWDB)
)
)

INST1_HTTP =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = CHNBSLWS414)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = SHARED)
(SERVICE_NAME = MODOSE)
(PRESENTATION = http://HRService)
)
)

INST_HTTP.CHENNAI.BIRLASOFT.COM =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = CHNBSLWS414)(PORT = 1521))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = CHNBSLWS414)(PORT = 1522))
)
)
(CONNECT_DATA =
(SERVER = SHARED)
(SERVICE_NAME = MODOSE)
(PRESENTATION = http://HRService)
)
)

EXTPROC_CONNECTION_DATA.CHENNAI.BIRLASOFT.COM =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)

Quote:

# LISTENER.ORA Network Configuration File: C:\oracle\ora92\NETWORK\ADMIN\listener.ora
# Generated by Oracle configuration tools.

LISTENER2 =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = CHNBSLWS414)(PORT = 1523))
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC2))
)
)

LISTENER1 =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = CHNBSLWS414)(PORT = 1522))
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
)

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = CHNBSLWS414)(PORT = 1521))
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
)

SID_LIST_LISTENER1 =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = NEWDB)
(ORACLE_HOME = C:\ORACLE\ORA92)
(SID_NAME = NEWDB)
)
)

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:\oracle\ora92)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = TESTDB1)
(ORACLE_HOME = C:\oracle\ora92)
(SID_NAME = TESTDB1)
)
)

SID_LIST_LISTENER2 =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = clone)
(ORACLE_HOME = c:\oracle\ora92)
(SID_NAME = clone)
)
)

Report message to a moderator

Re: target host or object does not exist [message #175831 is a reply to message #166475]

Mon, 05 June 2006 11:13

loryma
Messages: 1
Registered: June 2006
Location: Madrid

Junior Member

I've the same problem than you.

Do you know some solution?

Thanks.

Report message to a moderator

Previous Topic:	connectivity
Next Topic:	Connections problems

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jan 09 10:28:28 CST 2025