Database Software

Error:

=====

TNS-12514: TNS:listener does not currently know of service requested in connect descriptor

Envornment:

==========================

Oracle 11gR2 on HP Unix.

Listener Log Entry:

===============================

25-MAY-2016 00:27:44 * (CONNECT_DATA=(SERVICE_NAME=cs501h.Everwin)(UR=A)(CID=(PROGRAM=rman)(HOST=dbsrvr)(USER=oracle))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.3.3.248)(PORT=6538

5)) * establish * cs501h.Everwin * 0

25-MAY-2016 00:27:49 * service_died * cs501h * 12537

Wed May 25 00:27:55 2016

25-MAY-2016 00:27:55 * (CONNECT_DATA=(SERVICE_NAME=cs501h.Everwin)(UR=A)(CID=(PROGRAM=rman)(HOST=dbsrvr)(USER=oracle))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.3.3.248)(PORT=3323

0)) * establish * cs501h.Everwin * 12514

TNS-12514: TNS:listener does not currently know of service requested in connect descriptor

Wed May 25 00:31:33 2016

---------------------------------------------------------++++++++++++++++++++++++++++++++++++++++++++
tnsnames.ora only at the DB_HOME
---------------------------------------------------------++++++++++++++++++++++++++++++++++++++++++++

cs501h.Everwin =
  (DESCRIPTION =
      (ADDRESS_LIST =
         (ADDRESS = (PROTOCOL = TCP)(HOST = dbsrvr.london.Everwin.ids.com)(PORT = 60005))
       )
       (CONNECT_DATA =
            (SERVICE_NAME = cs501h.Everwin)
              (UR = A)
       )
   )

---------------------------------------------------------++++++++++++++++++++++++++++++++++++++++++++
Listenr only at the GI_HOME
---------------------------------------------------------++++++++++++++++++++++++++++++++++++++++++++

LISTENER=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER))))            # line added by Agent
LISTENER_SCAN3=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN3))))                # line added by Agent
LISTENER_SCAN2=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN2))))                # line added by Agent
LISTENER_SCAN1=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN1))))                # line added by Agent
ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER_SCAN1=ON                # line added by Agent
ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER_SCAN2=ON                # line added by Agent
ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER_SCAN3=ON                # line added by Agent
ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER=ON              # line added by Agent

SID_LIST_LISTENER_cs501h_dbsrvr =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = cs501h
      (GLOBAL_DBNAME = cs501h.Everwin)
      (ORACLE_HOME = /app/oracle/product/11.2.0.3/db)
    )
  )
LISTENER_cs501h_dbsrvr =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = dbsrvr.london.Everwin.ids.com)(PORT = 60005)(IP = FIRST))
    )
  )

---------------------------------------------------------++++++++++++++++++++++++++++++++++++++++++++
RMAN DUPLICATE COMMAND
---------------------------------------------------------++++++++++++++++++++++++++++++++++++++++++++
#!/bin/ksh
#######################################################################
# Bring up dup_database_name to NOMOUNT
#######################################################################
#### updated for css01h and sma01dd both exists in /etc/oratab ########
. setdb cs501h
#######################################################################

start_dt=`date +%Y%m%d_%H%M`
job=`basename $0 ".sh"`
rman  >> ${job}_${start_dt}.log  2>&1 <<eof
set echo on;
connect target sys/Kita2009@css01h
connect auxiliary sys/Kita2009@cs501h
run
{
allocate channel prmy1 type disk;
allocate auxiliary channel stby1 type disk;
duplicate target database to cs501h from active database pfile=/app/oracle/product/11.2.0.3/db/dbs/initcs501h.ora;
release channel prmy1;
release channel stby1;
}
show all;
exit
eof
end_dt=`date +%Y%m%d_%H%M`
mailx -s "DR RMAN Job: $job done" "dba@Everwin.org" <<eof
started: ${start_dt}
finish: ${end_dt}
eof

========================================