By submitting your email address, you agree to receive emails regarding relevant topic offers from TechTarget and its partners. You can withdraw your consent at any time. Contact TechTarget at 275 Grove Street, Newton, MA.
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.
Dig Deeper on Oracle database backup and recovery
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.