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