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’.
0 Comments.