ORA-12514 On Startup/Shutdown Remote with EM

[BattleDroid42]

Problem: Receiving "ORA-12514 :TNS:listener could not resolve SERVICE_NAME given in connect descriptor" when attempting to use Enterprise Manager console to startup/shutdown a remote database.

Version: Oracle 9i (9.2.0)

Recommendations: Don't use Net Configuration Assistant to configure server's listener. In general, it doesn't give you enough configuration choices. Specifically, it misses allowing configuration of database services. Use Oracle Net Manager instead and be sure to populate all applicable configuration items.

 

[DaPi]

This is true for 8i as well - best to use "Net8 Assistant" instead of "Net8 Configuration Assistant" (it's like driving blindfold!)
DaPi - no silver bullet

 

[Turkbear]

Hi,
A listener that is started first will self-register and configure any database instance started after it..No manual configuration is needed.