Create and configure a listener

[oracle@collabn1 client]  netca

[oracle@collabn1 client]$

[oracle@collabn1 admin]$

[oracle@collabn1 admin]$cat listener.ora

CMAN =

 (DESCRIPTION_LIST =

    (DESCRIPTION =

     (ADDRESS = (PROTOCOL = TCP)(HOST = collabn1.shaiksameer)(PORT = 1523))

    )

 )

SID_LIST_CMAN =
  (SID_LIST =
    (SID_DESC =
      (GLOBAL_DBNAME = SHAIKDB.shaiksameer)
      (SID_NAME = SHAIKDB)
      (ORACLE_HOME = /u01/app/oracle/product/11.2.0.2/SHAIKPROD)
    )
  )

ADR_BASE_CMAN = /u01/app/oracle

[oracle@collabn1 admin]$ lsnrctl status cman

LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 13-SEP-2015 20:18:07

Copyright (c) 1991, 2009, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=collabn1.shaiksameer)(PORT=1523)))

STATUS of the LISTENER

------------------------

Alias                     cman

Version                   TNSLSNR for Linux: Version 11.2.0.1.0 - Production

Start Date                13-SEP-2015 20:18:02

Uptime                    0 days 0 hr. 0 min. 5 sec

Trace Level               off

Security                  ON: Local OS Authentication

SNMP                      OFF

Listener Parameter File   /u01/app/oracle/product/11.2.0.2/CLIENT/network/admin/listener.ora

Listener Log File         /u01/app/oracle/diag/tnslsnr/collabn1/cman/alert/log.xml

Listening Endpoints Summary...

 (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=collabn1.shaiksameer)(PORT=1523)))

Services Summary...
Service "SHAIKDB.shaiksameer" has 1 instance(s).
  Instance "SHAIKDB", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully

[oracle@collabn1 sf_stage]$ vi $TNS_ADMIN/tnsnames.ora
cman =
  (DESCRIPTION =
  (ADDRESS = (PROTOCOL = TCP)(HOST = collabn1.shaiksameer)(PORT = 1523))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = SHAIKDB.shaikmeer)
    )
  )


[oracle@collabn1 sf_stage]$ tnsping cman

TNS Ping Utility for Linux: Version 11.2.0.1.0 - Production on 13-SEP-2015 23:16:07

Copyright (c) 1997, 2009, Oracle.  All rights reserved.

Used parameter files:
/u01/app/oracle/product/11.2.0.2/SHAIKPROD/network/admin/sqlnet.ora


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = collabn1.shaiksameer)(PORT = 1523)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = SHAIKDB.shaiksameer)))
OK (0 msec)


Test the listener:


[oracle@collabn1 sf_stage]$ sqlplus system@cman

SQL*Plus: Release 11.2.0.1.0 Production on Sun Sep 13 22:26:56 2015

Copyright (c) 1982, 2009, Oracle.  All rights reserved.

Enter password:

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options

SHAIKDB>select name from v$database;

NAME
---------
SHAIKDB

SHAIKDB>exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options

Stop the Traditional Listener:

[oracle@collabn1 admin]$ lsnrctl stop cman

LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 13-SEP-2015 20:27:11

Copyright (c) 1991, 2009, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=collabn1.shaiksameer)(PORT=1523)))

The command completed successfully

Delete Listener Configuration: