3 Replies Latest reply: Mar 17, 2014 1:55 PM by BloodyElf RSS

    listener error while making database duplication

    BloodyElf

      Hi Dears,

       

      I've a problem while making database duplication using active database. I created new instance using oradim -new -sid neworcl

      I configured the listener as below

      LISTENER1 = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.230.148)(PORT = 1526)) )  SID_LIST_LISTENER1 = (SID_LIST = (SID_DESC = (GLOBAL_DBNAME = neworcl) (ORACLE_HOME = C:\app\Administrator\product\11.2.0\dbhome_1) (SID_NAME = neworcl) ) )  ADR_BASE_LISTENER1 = C:\app\Administrator

      and tnsname as below

      NEWORCL = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.230.148)(PORT = 1526)) ) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = neworcl) ) )

      but still I get error "ORA-12541: TNS:no listener"

      after I tried "lsnrctl start listener1" I got

      Starting tnslsnr: please wait...  Service OracleOraDb11g_home1TNSListenerlistener1 already running. TNS-12560: TNS:protocol adapter error

      ًWhen I got

      Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.230.148)(PORT=15 26))) TNS-12541: TNS:no listener TNS-12560: TNS:protocol adapter error TNS-00511: No listener 64-bit Windows Error: 61: Unknown error

       

      Waiting your feedback