set321go wrote:A couple of important points.
i have 11.2 installed i can log into my database
when i run lsnrctl status it tells me my database is running and it can see it
if i try and connect from an external ip i cant
if i run tnsping for my ip i get TNS-03505: Failed to resolve name
but if i do it as localhost ip i get success
if i run nestat -a |grep 1521 i get
unix 2 [ ACC ] STREAM LISTENING 4280 /var/tmp/.oracle/sEXTPROC1521
i appreciate this proably is more of a network problem than an oracel problem but
a) have i got the right things listenning?
b) where does oracle get the ip from?
c) why would my public ip and my localhost address not resolve to the same thing
Now, when you issue a connect, say like this:
larry = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = myhost)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = curley) ) )
tns will look in your tnsnames.ora for an entry called 'larry'. Next, tns sends a request to (PORT = 1521) on (HOST = myhost) using (PROTOCOL = TCP), asking for a connection to (SERVICE_NAME = curley).
$> sqlplus scott/tiger@larry