Wednesday, September 19, 2012

Oracle not starting on EC2

If you can not start your Oracle database on EC2 and get the following errors:
ORA-00119: invalid specification for system parameter LOCAL_LISTENER
ORA-00132: syntax error or unresolved network name 'wcs'

Chances are you created this database on a port  (i.e. port 1522) other than  the default 1521 port. 
You just need to add one entry to the tnsnames.ora file:
wcs = (ADDRESS = (PROTOCOL = TCP) (HOST= (PORT = 1522))
(Note: wcs is the DB listener name) 

Then start up your database:

No comments:

Post a Comment