Oracle Database Discussions

I just set up an Oracle 11.2 instance for the first time and, for some reason the instance would not register with the listener. Any idea for how I would debug this to isolate where the problem is?

For now I have worked around the problem by manaully editing the listener.ora to specify the SID of my instance - this works OK, so I suppose all I want to know is to learn what the problem was to avoid future frustration.

'nstrctl services'was just showing up an instance for the CLRExtProc service and not my new instance.

The relevant parameters are:

SQL> show parameter service

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
service_names                        string      PFS30
SQL> show parameter instance_name

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
instance_name                        string      pfs30
SQL> show parameter listener

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
listener_networks                    string
local_listener                       string
remote_listener                      string

The contents of my listener.ora was:

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = CLRExtProc)
      (ORACLE_HOME = D:\oracle\product\11.2.0\dbhome_1)
      (PROGRAM = extproc)
      (ENVS = "EXTPROC_DLLS=ONLY:D:\oracle\product\11.2.0\dbhome_1\bin\oraclr11.dll")
    )
  )

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.117)(PORT = 1521))
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
    )
  )

ADR_BASE_LISTENER = D:\oracle

The listener was created using netca, also at 11.2. According to the doc, I believe that since the listener port is 1521, the LOCAL_LISTENER parameter is correct in being NULL.
I tried alter system register, to make sure it wasnt a delay problem. I also tried bouncing the listener and database.

Thanks for any help.