How do I resolve TNSNames.ora 01150 error on Oracle 11g?

Sorry that was a typo. It is listed at PORT=1521

How do I statically register the listener in 11g?

Typically, your with static registration, your listener.ora should look something like this:

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = TCP)(HOST = test-win.abcd.com)(PORT = 1521))
      )
    )
  )

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (GLOBAL_DBNAME = tester.abcd.com)
      (ORACLE_HOME = C:\app\admin\product\11.1.0\db_1)
      (SID_NAME = tester)
    )
  )


Double check those values, but they should be close.  If you are unsure on what the global name is, you can connect to the database and run:

SELECT * FROM GLOBAL_NAME;

I am looking at the Configuring and Administering Oracle Net Listener guide for 11g. They have a section that suggests using OEM to statically configure the listener. Does it matter which way the listener is configured?

Typically, people use dynamic registration at this point.  I only go to static registration if there is a problem with dynamic.

We have been having all kinds of issues with the Oracle 11g installation. It's on every install on different systems that we have problems with the listener that will not unregister. Then when we start up the database we recieve ORA12525 tns listener all appropriate instances are blocking new connections. The only way I get to resolve it is to bounce the listener. However, the users are not happy about the inconvienience. I thought statically registering the db would help solve this problem.
Are there other settings I should be looking at to fix the issue? It seems the db and listener stop communication.

To check if static registration works use

lsnrctl services

You register not the listener, you register the Oracle instances that work on the Server.

A important prereqiusite is not to have blocked by firewalls or antiviruses ports.


For STATIC registration of the Oracle service to the Listener:

Go to the remote 10g installation where the Oracle server resides.

Backup LISTENER.ORA file!!!!!!!

In ...\network\admin open listener.ora

see

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = D:\Ora10g)
      (PROGRAM = extproc)
    )
    (SID_DESC =
      (SID_NAME = test)
      (ORACLE_HOME = D:\Ora10g)
    )
  )

Add the entry
    (SID_DESC =
      (SID_NAME = test)
      (ORACLE_HOME = D:\Ora10g)
    )
with regard to the particular Oracle Home and SID Name.


In Oracle 11g you have to create from scratch in the listener.ora file the section

SID_LIST_LISTENER =
&..

mentioned above.

Restart the listener:
c:>lsnrctl stop
c:>lsnctl start

Thats all.

How can I verify that antivirus or a firewall are the ones causing the blocking? This problem seems to be intermittant.

Is there any way that I can see where the redirection to another port? Is this something netstat would show? I'm wondering if in our configuration we have another application interferring with an Oracle port.

Once the socket connection is established, how does the client know to go to the changed port? In the listener file the port is 1521.