For testing I have been trying to install Oracle 11g on a test system with a single database several times with the aid of snapshots. This most recent iteration I have been having issues getting the database to register with the listener.
I am to understand that PMON, as long as the database is running, will attempt to register itself at regular intervals with a listener that is running locally on the same machine using port 1521. I have such a listener running but the service is not registered it seems.
lsnrctl status
.....
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.10.13.134)(PORT=1521)))
....
The listener supports no services
I can connect to the db using sqlplus / as sysdba
and running select name from v$database;
shows the DB in question. So between that tnsping and netstat -an
I know the listener is at least running. alter system register
does not appear to have an effect either. Not that it should matter since I should just have to wait a minute for it to work on its own.
I then went looking for any PMON related logs. It should have been in the trace folder ($ORACLE_BASE/diag/rdbms/database_name/SID/trace/SID_pmon_PID.trc) with other trc files but it was not there. I then used the following query to verify where it should be
select pid, program, tracefile from v$process where program like '%PMON%';
d:\app\administrator\diag\rdbms\prod\prod\trace\prod_pmon_1464.trc
Windows 2008R2 with firewall disabled for testing (not that it changed anything). Listener.log doesn't show anything of worry. Just evidence of me restarting the listener many times.
I am aware that I could configure a static listener with SID_LIST
but I would like to understand why this is not working. This is the 4th time around that I have been doing this and I have not run into this problem yet.
I am basically stuck since I am not sure where else I should be looking.