how to find out what port number asm listener was listening

how to find out what port number asm listener was listening

oracle 11g, sun solaris
Dba_OracledbAsked:
Who is Participating?
 
slightwv (䄆 Netminder)Connect With a Mentor Commented:
I think we are confusing each other and we are starting to talk in circles.

If you do not have the local_listener specified for a database instance, it will default to port 1521 on the database where the instance is running.

Refer to the docs:
http://download.oracle.com/docs/cd/E11882_01/server.112/e17110/initparams116.htm#REFRN10082

The docs do not state this but I also believe it is smart enough to look for a listener names 'LISTENER' that is not on a default port.  My production databases to not use a standard port and I do not have that parameter set and everything registers fine.

Now, if for are nor running a standard listener either by PORT of by NAME you set the local_listener parameter in your ASM database.  You should then be able to register ASM with the listener by issuing "alter system register" from a SQL prompt.

If everything is configured properly you shoulc be able to see your ASM instance when you run "lsnrctl status".
0
 
Aaron ShiloChief Database ArchitectCommented:
try the port specified in the local_listener parameter for the asm instance. if that is blank, try 1521

0
 
slightwv (䄆 Netminder) Commented:
On the database server form a command prompt: lsnrctl status

or check the listener.ora file on the database server.
0
Cloud Class® Course: Microsoft Windows 7 Basic

This introductory course to Windows 7 environment will teach you about working with the Windows operating system. You will learn about basic functions including start menu; the desktop; managing files, folders, and libraries.

 
slightwv (䄆 Netminder) Commented:
ashilo,

The local_listener does not have to have the port.  It could just be the name.
0
 
Dba_OracledbAuthor Commented:
when i check lsnrctl status, i see listeners of various db's running, how to figure the asm listener one ?
0
 
Aaron ShiloChief Database ArchitectCommented:
you could check the default 1521 start there its the easy aproach.
0
 
slightwv (䄆 Netminder) Commented:
>>you could check the default 1521 start there its the easy aproach.

That is the question here:  How to check.  I know of two ways: check the listener.ora file or status the listener itself.  

If you know of another way, please post it.
0
 
slightwv (䄆 Netminder) Commented:
>>i see listeners of various db's running

Not really.  You see the various database instances that single listener is listening on.

You can have multiple listeners running.

I've never set up ASM but know it takes it's own databae.  What name did you give that database and from what oracle_home is that instance running?
0
 
Dba_OracledbAuthor Commented:

and 5 ports in another server - 4 db's
and 1 port in anothe server - 2 db's...

0
 
Dba_OracledbAuthor Commented:
i checked listner.ora file in each server

and 5 ports in another server - 4 db's
and 1 port in anothe server - 2 db's...
0
 
slightwv (䄆 Netminder) Commented:
On those database servers, what is the instance name for your ASM instance?

You then look for that instance for the listeners in question.

It's possible someone created a separate listener for the ASM instance.

Check out this thread:
http://forums.oracle.com/forums/thread.jspa?threadID=529902
0
 
Dba_OracledbAuthor Commented:
i dont see asm instance on services list, when i do lsnrctl status,

so then asm would be default port 1521 ?
how do i confirm ?
0
 
slightwv (䄆 Netminder) Commented:
The listener status should display the port or ports it is listening on.  If you see the ASM instance, you have the right one.
0
 
Aaron ShiloChief Database ArchitectCommented:
hi
use

lsnrctl services

to retrive list of services for listener and port.
find your asm instrance and connect to it.

as i saied before its probably using the default of 1521
0
 
Dba_OracledbAuthor Commented:
when i did lsnrctl services , i didnot see the asm service

{servername:oracle:}: /home/oracle =>lsnrctl status LISTENER_name

LSNRCTL for Solaris: Version 11.1.0.7.0 - Production on 01-MAR-2011 16:35:46

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=servername-vip)(PORT=1522)(IP=FIRST)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER_servername
Version                   TNSLSNR for Solaris: Version 11.1.0.7.0 - Production
Start Date                01-MAR-2011 14:08:02
Uptime                    0 days 2 hr. 27 min. 43 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/app/oracle/product/asm/network/admin/listener.ora
Listener Log File         /u01/app/oracle/diag/tnslsnr/servername/listener_servername/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ip10.50)(PORT=1522)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ip10.50)(PORT=1523)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ip10.49)(PORT=1523)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ip10.49)(PORT=1522)))
Services Summary...
Service " DEV" has 2 instance(s).
  Instance " DEV1", status READY, has 2 handler(s) for this service...
  Instance " DEV2", status READY, has 1 handler(s) for this service...
Service " DEV_XPT" has 2 instance(s).
  Instance " DEV1", status READY, has 2 handler(s) for this service...
  Instance " DEV2", status READY, has 1 handler(s) for this service...
Service " UAT" has 3 instance(s).
  Instance " UAT1", status UNKNOWN, has 1 handler(s) for this service...
  Instance " UAT1", status READY, has 2 handler(s) for this service...
  Instance " UAT2", status READY, has 1 handler(s) for this service...
Service " UAT_XPT" has 2 instance(s).
  Instance " UAT1", status READY, has 2 handler(s) for this service...
  Instance "UAT2", status READY, has 1 handler(s) for this service...
The command completed successfully
0
 
slightwv (䄆 Netminder) Commented:
What is the ASM instance name?  I don't see anything resembling an ASM in that list.
0
 
Dba_OracledbAuthor Commented:
yes thats my problem but asm instance is running on the node, its +ASM1
0
 
slightwv (䄆 Netminder) Commented:
I thought you said earlier you saw the asm instance listed in a lsnrctl status.

On the server running the asm instance look for a listner.ora file in the ORACLE_HOME/network/admin where the home is the one running the instance.

That file will have the port.
0
 
Dba_OracledbAuthor Commented:
here is the listener file contents

servername
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = servername-vip)(PORT = 1522)(IP = FIRST))
      (ADDRESS = (PROTOCOL = TCP)(HOST = servername-vip)(PORT = 1523)(IP = FIRST))
      (ADDRESS = (PROTOCOL = TCP)(HOST = ip)(PORT = 1523)(IP = FIRST))
      (ADDRESS = (PROTOCOL = TCP)(HOST = ip)(PORT = 1522)(IP = FIRST))
    )
  )

SID_LIST_servername
  (SID_LIST =
    (SID_DESC =
      (GLOBAL_DBNAME = DEV)
      (ORACLE_HOME = /u01/app/oracle/product/11.0.1)
      (SID_NAME = DEV1)
    )
  )


SID_LIST_servername
  (SID_LIST =
    (SID_DESC =
      (GLOBAL_DBNAME = UAT)
      (ORACLE_HOME = /u01/app/oracle/product/11.0.1_erpuat)
      (SID_NAME = UAT1)
    )
  )


the two ports are for the two dbs's....where is asm port info.
0
 
slightwv (䄆 Netminder) Commented:
Did you check the local_listener parameter suggested above in the ASM instance?  If it is not set, the default listener should be LISTENER.

I'll need to look it up tomorow when I get off mobile but the listener.ora you posted doesn't paaear to set up a default listener.

Arew you sure you don't have any other listener.ora filesp possibly in a different oracle home?
0
 
Dba_OracledbAuthor Commented:
i am sure i dont have any other listeners running , in ps -ef|grep tns, except this listener.
0
 
slightwv (䄆 Netminder) Commented:
You didn't answer: Did you check the local_listener parameter suggested above in the ASM instance?  
0
 
slightwv (䄆 Netminder) Commented:
Here's a visual of what I've been aiming for.

From the link below:
Did you check the local_listener parameter suggested above in the ASM instance?  


http://www.oracle-base.com/articles/10g/ASMUsingASMLibAndRawDevices.php
0
 
Dba_OracledbAuthor Commented:
i checked local listener, its not running..
0
 
slightwv (䄆 Netminder) Commented:
local_listener is not a process that runs.  It is an spfile/init parameter set for the specific database instance.  If it is not set for that database, I believe it defaults to a listener named 'LISTENER'.

Back in your post http:#a35012162 when you did "lsnrctl status LISTENER_name", you specified a non-standard listener name.

This could be why you cannot find your ASM instance registered anywhere.  Because it cannot find a listener to register with.
0
 
Dba_OracledbAuthor Commented:
i checked, asm listener.ora file, init file, every where, i can only see two port number , corresponding to two dbs's, the default listener is not running, and its not using port 1521...

i think db and asm were using same port number....
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.