Hello:
I just installed Oracle 11.2.0.1 on Windows Server 2008 R2 and Oracle seems to be running ok. I can connect to sqlplus with the command
sqlplus system@orcl
My Tnsnames.ora file has
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
When I change localhost in tnsnames.ora, to the IP address of the machine which is 10.100.8.65, I get an error: ORA-12541: TNS:no listener.
I also get the same error when I try to do the following command from another machine: tnsping repo where repo is the tns service name pointing to 10.100.8.65.
Any ideas on how to fix this?
Thanks much for the help.