| 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 #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)
)
)
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
