Experience: is what you get soon after you need it.

Experience: is what you get soon after you need it.

Rasul Allah (sal Allahu alaihi wa sallam) said: "Restore the trusts of those who trust you, and deal not falsely with him who deals falsely with you." [Abu Dawud, Tirmidhi]

Search This Blog

Sunday, September 13, 2015

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:









 

No comments: