ServiceAliasException: Could not initialize Service Alias: TNS-04404

Problem:

After installing Oracle Database 10g (10.2.0.1) and upgrading it to 10.2.0.2, the listener service was not created. When attempting to create using netca (from the Command Prompt), the following error appears:

ServiceAliasException: Could not initialize Service Alias: TNS-04404

Solution:

In the C:oracleproduct10.2.0db_1networkADMIN directory, rename the listener.ora, sqlnet.ora and tnsnames.ora to listener.ora.bak, sqlnet.ora.bak and tnsnames.ora.bak.

Then rerun netca (Net Configuration Assistant) to recreate the sqlnet.ora (second option on the menu), listener.ora (first option) and tnsnames.ora (third option).

After exiting netca, start the listener by issuing the command ‘lsnrctl start’.

Leave a Comment


NOTE - You can use these HTML tags and attributes:
<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>


This site uses Akismet to reduce spam. Learn how your comment data is processed.