Yesterday, I started installing Oracle. I decided to download the newest version: version 11g R. I used windows xp as a platform with DHCP switched off. It really looked simple: the screens look simple and the questions asked were straight forward. I let it go for about 2 hours and after this time I returned to the machine and I looked if everything was successfull. It certainly was: an encooraging “successfull” looked at me.
\nI checked the installation by a command “tnsping”. This command was issued at the same machine where Oracle was installed.
\nI then issued the command “sqlplus uid\/psw” that also gave access to the Oracle database.
\nFinally, I installed TOAD on the same machine as Oracle installed and also TOAD gave access to the database.
\nMuch to my surprise, I could not get access from another machine as the machine on which I had installed Oracle. I got an error saying “TNS-12541: TNS: geen listener”. I really did not understand as to why this happened. If you google this error, you get ideas on network problems, but this was not the case. I checked every possible typo but this did not happen either.
\nThe clue as to why the error happened came as I compared the outcomes form the tnsping command. From the server, it looked like: <\/p>\n
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl)))
\nOK (20 msec)<\/p>\n
look at the host! It reads localhost where I expected to see the serveraddress.<\/p>\n
The outcome from the remote computer was:<\/p>\n
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.1.9)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = ORCL)))
\nTNS-12541: TNS: geen listener<\/p>\n
the host is 192.168.1.9 which in itsself is ok.<\/p>\n
Apparently the listener on the server listens to the localhost whereas it had to listen to the server address 192.168.1.9.<\/p>\n
The solution was twofold.
\nFirst I changed the hosts file on the server in \\windows\\system32\\drivers\\etc. I commented out the localhost and I introduced the serveraddress.
\nSecondly, I changed the tnsnames.ora, listener.ora that can be found in \\network\\Administrator on the server. Every “localhost” reference was replaced by the serveraddress 192.168.1.9. <\/p>\n
This seemed to help: the listener started to listen to the network address and it was possible to access the database from outside.<\/p>\n
Oops – took a few hours but Oracle was up and running.<\/p>\n","protected":false},"excerpt":{"rendered":"
Yesterday, I started installing Oracle. I decided to download the newest version: version 11g R. I used windows xp as a platform with DHCP switched off. It really looked simple: the screens look simple and the questions asked were straight forward. I let it go for about 2 hours and after this time I returned […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5],"tags":[],"class_list":["post-127","post","type-post","status-publish","format-standard","hentry","category-nice-to-know"],"_links":{"self":[{"href":"http:\/\/archief.van-maanen.com\/index.php?rest_route=\/wp\/v2\/posts\/127","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/archief.van-maanen.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/archief.van-maanen.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/archief.van-maanen.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/archief.van-maanen.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=127"}],"version-history":[{"count":0,"href":"http:\/\/archief.van-maanen.com\/index.php?rest_route=\/wp\/v2\/posts\/127\/revisions"}],"wp:attachment":[{"href":"http:\/\/archief.van-maanen.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=127"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/archief.van-maanen.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=127"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/archief.van-maanen.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=127"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}