13 Replies Latest reply on Jun 13, 2013 9:46 PM by Teddd

IO Error: The network adapter could not establish the connection

Teddd Jun 5, 2013 5:28 PM

I am configuring 11.1.2.3 on Windows 2008, using Oracle database and when I Try to set up shared services and registry database connection associated with the instance home I get the error "+IO Error: The network adapter could not establish the connection+" while filling in the database details. Windows firewall is turned off, database is running am able to connect through SQL Plus, listener service for the database is running and the SID and server name have been provided correctly. I have even used localhost, apart from the server name while providing the servename and ORCL is the SID. ANy suggestions please?

1. Re: IO Error: The network adapter could not establish the connection

_RahulS_ Jun 5, 2013 6:00 PM (in response to Teddd)

Have you checked is the host name in listner.ora?
1 person found this helpful
Like Show 1 Likes(1)

Actions
2. Re: IO Error: The network adapter could not establish the connection

Teddd Jun 5, 2013 7:01 PM (in response to _RahulS_)

Rahul, Yes the listner.ora in C:\app\Ted\product\11.2.0\dbhome_1\NETWORK\ADMIN has the following

LISTENER =
(DESCRIPTION_LIST=(DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521))
(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521))
))

ANd I have tried with localhost and it still gives me the same error.

Any other ideas anyone please?

Thanks,
Ted.
Like Show 0 Likes(0)

Actions
3. Re: IO Error: The network adapter could not establish the connection

JohnGoodwin Jun 5, 2013 7:13 PM (in response to Teddd)

It shows that the Oracle db has been configured against localhost which does sometimes cause problems and it would definitely be no good in a distributed environment, am I understanding correctly that you tried to use localhost in the EPM configurator.

Cheers

John
http://john-goodwin.blogspot.com/
1 person found this helpful
Like Show 1 Likes(1)

Actions
4. Re: IO Error: The network adapter could not establish the connection

Teddd Jun 5, 2013 7:23 PM (in response to JohnGoodwin)

Yes John I tried using localhost in the EPM configurator. So if that's the case, will changing the host in the listener.ora to my computer name allow me to go ahead with my configuration?
Like Show 0 Likes(0)

Actions
5. Re: IO Error: The network adapter could not establish the connection

Celvin Kattookaran Jun 5, 2013 7:58 PM (in response to Teddd)

Use the hostname in both places.

Regards

Celvin
http://www.orahyplabs.com
1 person found this helpful
Like Show 1 Likes(1)

Actions
6. Re: IO Error: The network adapter could not establish the connection

Teddd Jun 5, 2013 9:39 PM (in response to Celvin Kattookaran)

I did am yet unable to go ahead with the configuration. Everything seems to be right. Has anyone seen this with 11.1.2.3?

Thanks,
Ted.
Like Show 0 Likes(0)

Actions
7. Re: IO Error: The network adapter could not establish the connection

Celvin Kattookaran Jun 5, 2013 9:50 PM (in response to Teddd)

Try adding the hostname and IP address in the hosts file and see if that works.

Regards

Celvin
http://www.orahyplabs.com
Like Show 0 Likes(0)

Actions
8. Re: IO Error: The network adapter could not establish the connection

Teddd Jun 5, 2013 9:54 PM (in response to Celvin Kattookaran)

I have already done that as an installation prerequisite. No. Still not able to.
Like Show 0 Likes(0)

Actions
9. Re: IO Error: The network adapter could not establish the connection

Celvin Kattookaran Jun 5, 2013 10:41 PM (in response to Teddd)

Do you have any other error in the configtool.log?

Regards

Celvin
http://www.orahyplabs.com
Like Show 0 Likes(0)

Actions
10. Re: IO Error: The network adapter could not establish the connection

JohnGoodwin Jun 6, 2013 7:15 AM (in response to Celvin Kattookaran)

Usually if I am installing on a Windows VM/laptop which is not going to have a fixed IP or dns entry I install the loopback adaptor before installing Oracle and have never had any issues, it is documented at http://docs.oracle.com/cd/E11882_01/install.112/e24186/reqs.htm#BABFHCJG

Cheers

John
http://john-goodwin.blogspot.com/
Like Show 0 Likes(0)

Actions
11. Re: IO Error: The network adapter could not establish the connection

dwhpc Jun 6, 2013 7:34 AM (in response to Teddd)

Hi Teddd,

Can you please check the value of "TNS_ADMIN" environment variable.

I have faced similar kind of issue during Hyperion 11.1.2.3 installation, and my variable pointed to different location. After changed the right path, everything went smooth without any issues.

Thanks
Like Show 1 Likes(1)

Actions
12. Re: IO Error: The network adapter could not establish the connection

JohnGoodwin Jun 6, 2013 9:51 AM (in response to dwhpc)

If the Oracle clients have been installed with 11.1.2.3 the TNS_ADMIN will be point to <MIDDLEWARE_HOME>\user_projects\config\dbclient
In that folder there should be a tnsnames.ora, if the Oracle DB is on the same machine you may want to copy the contents of database tnsnames folder to the TNS_ADMIN folder or as suggested change the environment variable.

Cheers

John
http://john-goodwin.blogspot.com/
Like Show 2 Likes(2)

Actions
13. Re: IO Error: The network adapter could not establish the connection

Teddd Jun 13, 2013 9:46 PM (in response to JohnGoodwin)

I have overcome this error by following Johns Below Comment and also by not installing the database clients that came with the installation. So am guessing it had something to do with the Database clients as indicated by John and dwhpc. Thanks to both of you.
Usually if I am installing on a Windows VM/laptop which is not going to have a fixed IP or dns entry I install the loopback adaptor before installing Oracle and have never had any issues, it is documented at http://docs.oracle.com/cd/E11882_01/install.112/e24186/reqs.htm#BABFHCJG
Like Show 0 Likes(0)

Actions