You should have your SERVICE_NAMES and INSTANCE_NAME initialization parameters defined.
After you start the instance, it may take a minute or two from PMON to register the instance with the Listener. By default, PMON will attempt to contact your Listener on the default port (1521). If you are using a non-default port, then you will have to let PMON know where your Listener is listening. To do that, add an entry in your parameter file similar to the following:
Then bounce the database. The value for the LOCAL_LISTENER parameter should be found in your TNSNAMES.ORA file and the entry should look like the following:
listener1= (DESCRIPTION= (ADDRESS=(PROTOCOL=tcp)(HOST=sales-server)(PORT=1421)) )You may have to restart your database for all settings to take affect.
This was first published in March 2005