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=10.0.1.185) (PORT = 1522))
(Note: wcs is the DB listener name) 

Then start up your database:
$ SQLPlus /  AS SYSDBA
>startup
 
 
 



No comments:

Post a Comment