I cloned a new db 8174 and everything went fine but when i am trying to do tnsping the new db iam getting the following error.
Attempting to contact (address=(protocol=tcp)(host=abc.kk.xxx.com)(port=1150))TNS-12541: TNS:no listener
but the result of tnsping shows different host abc.kk.xxx.com which is different from where the database resides on def.kk.xxx.com.
(ADDRESS = (PROTOCOL = TCP)(HOST = def.kk.xxx.com)(PORT = 1131))
(SERVICE_NAME = amufsdv.kk.xxx.com)
# SQLNET.ORA Network Configuration File: /oracle/product/8.1.7ee/network/admin/s
# Generated by Oracle configuration tools.
NAME.DEFAULT_ZONE = world
(ADDRESS = (PROTOCOL = TCP)(HOST = ONSAM1.kk.xxx.com)(PORT = 15000))
(ADDRESS = (PROTOCOL = TCP)(HOST = ONSAM2.kk.xxx.com)(PORT = 15000))
(ADDRESS = (PROTOCOL = TCP)(HOST = ONSAM3.kk.xxx.com)(PORT = 15000))
NAMES.DEFAULT_DOMAIN = world
TRACE_LEVEL_CLIENT = OFF
NAMES.DIRECTORY_PATH= (ONAMES, TNSNAMES)
AUTOMATIC_IPC = off
ouput of Listener services
$ lsnrctl services listener_amufsqa1
LSNRCTL for HPUX: Version 184.108.40.206.0 - Production on 01-FEB-2008 17:13:54
(c) Copyright 1998 Oracle Corporation. All rights reserved.
Connecting to (ADDRESS=(COMMUNITY=TCP.world)(HOST=def.kk.xxx.com)(PROTOCOL=TCP)(PORT=1131))
amufsdv has 1 service handler(s)
DEDICATED SERVER established:0 refused:0
amufsqa1 has 1 service handler(s)
DEDICATED SERVER established:56 refused:0
The command completed successfully
db_name = amufsdv
db_domain = kk.xxx.com
global_names = TRUE
instance_name = amufsdv
service_names = amufsdv.kk.xxx.com
can anybody please let me know where i am going wrong with it.