Tuesday, March 1, 2011

Configuring Oracle listener using netca

Here are the screen shots for configuring Oracle listener using netca.

As user oracle execute netca as shown below













 You can see that a new file called listener.ora has been created under the $ORACLE_HOME/network/admin directory

$ pwd
/u01/app/oracle/product/11.2.0/dbhome_1/network/admin
$ cat listener.ora
# listener.ora Network Configuration File: /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
# Generated by Oracle configuration tools.

TESTGM =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = isvp18.storage.tucson.ibm.com)(PORT = 1521))
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
    )
  )

ADR_BASE_TESTGM = /u01/app/oracle

$
$ lsnrctl status

LSNRCTL for IBM/AIX RISC System/6000: Version 11.2.0.1.0 - Production on 28-FEB-2011 00:45:44

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

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias                     TESTGM
Version                   TNSLSNR for IBM/AIX RISC System/6000: Version 11.2.0.1.0 - Production
Start Date                28-FEB-2011 00:38:47
Uptime                    0 days 0 hr. 6 min. 58 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      ON
Listener Parameter File   /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
Listener Log File         /u01/app/oracle/diag/tnslsnr/isvp18/testgm/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=isvp18.storage.tucson.ibm.com)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
Services Summary...
Service "testgm" has 1 instance(s).
  Instance "testgm", status READY, has 1 handler(s) for this service...
Service "testgmXDB" has 1 instance(s).
  Instance "testgm", status READY, has 1 handler(s) for this service...
The command completed successfully
$

No comments: