1 2 Previous Next 19 Replies Latest reply on Feb 18, 2014 5:12 PM by cleavitt Go to original post
      • 15. Re: Network Adapter Could Not Establish The Connection
        Prithwish Adhikari

        I have changed the HOST. I will post the results in a while. My VM ware got restarted. Meanwhile I also need to change the host tnsnames.ora file??

        • 16. Re: Network Adapter Could Not Establish The Connection
          Prithwish Adhikari

          Here is all the outputs. The connection is still not working

           

          [root@redhat6 oracle]#  cat  /app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora

          # listener.ora Network Configuration File: /app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora

          # Generated by Oracle configuration tools.

           

           

          LISTENER =

            (DESCRIPTION_LIST =

              (DESCRIPTION =

                (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))

                (ADDRESS = (PROTOCOL = TCP)(HOST = redhat6)(PORT = 1521))

              )

            )

           

           

          ADR_BASE_LISTENER = /app/oracle

           

           

           

           

          [root@redhat6 oracle]# lsnrctl status

           

           

          LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 18-FEB-2014 01:49:47

           

           

          Copyright (c) 1991, 2009, Oracle.  All rights reserved.

           

           

          Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))

          STATUS of the LISTENER

          ------------------------

          Alias                     LISTENER

          Version                   TNSLSNR for Linux: Version 11.2.0.1.0 - Production

          Start Date                18-FEB-2014 01:48:44

          Uptime                    0 days 0 hr. 1 min. 2 sec

          Trace Level               off

          Security                  ON: Local OS Authentication

          SNMP                      OFF

          Listener Parameter File   /app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora

          Listener Log File         /app/oracle/diag/tnslsnr/redhat6/listener/alert/log.xml

          Listening Endpoints Summary...

            (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))

            (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=redhat6)(PORT=1521)))

          Services Summary...

          Service "orcl.localdomain" has 1 instance(s).

            Instance "ocl", status READY, has 1 handler(s) for this service...

          Service "orclXDB.localdomain" has 1 instance(s).

            Instance "ocl", status READY, has 1 handler(s) for this service...

          The command completed successfully

           

           

          [root@redhat6 oracle]# lsnrctl service

           

           

          LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 18-FEB-2014 01:51:02

           

           

          Copyright (c) 1991, 2009, Oracle.  All rights reserved.

           

           

          Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))

          Services Summary...

          Service "orcl.localdomain" has 1 instance(s).

            Instance "ocl", status READY, has 1 handler(s) for this service...

              Handler(s):

                "DEDICATED" established:0 refused:0 state:ready

                   LOCAL SERVER

          Service "orclXDB.localdomain" has 1 instance(s).

            Instance "ocl", status READY, has 1 handler(s) for this service...

              Handler(s):

                "D000" established:0 refused:0 current:0 max:1022 state:ready

                   DISPATCHER <machine: redhat6, pid: 2443>

                   (ADDRESS=(PROTOCOL=tcp)(HOST=redhat6)(PORT=56641))

          The command completed successfully

           

           

          [root@redhat6 oracle]#  cat  /app/oracle/product/11.2.0/dbhome_1/network/admin/tnsnames.ora

          # tnsnames.ora Network Configuration File: /app/oracle/product/11.2.0/dbhome_1/network/admin/tnsnames.ora

          # Generated by Oracle configuration tools.

           

           

          ORCL =

            (DESCRIPTION =

              (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))

              (CONNECT_DATA =

                (SERVER = DEDICATED)

                (SERVICE_NAME = orcl.localdomain)

              )

            )

           

           

          [root@redhat6 oracle]# tnsping orcl

           

           

          TNS Ping Utility for Linux: Version 11.2.0.1.0 - Production on 18-FEB-2014 01:52:08

           

           

          Copyright (c) 1997, 2009, Oracle.  All rights reserved.

           

           

          Used parameter files:

          /app/oracle/product/11.2.0/dbhome_1/network/admin/sqlnet.ora

           

           

           

           

          Used TNSNAMES adapter to resolve the alias

          Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl.localdomain)))

          OK (0 msec)

          • 17. Re: Network Adapter Could Not Establish The Connection
            sb92075

            we have met the enemy & they is US.

             

            when localhost is used then can not connect to any remote system.

            when localhost is used then can not connect to any remote system.

            when localhost is used then can not connect to any remote system.

            when localhost is used then can not connect to any remote system.

             

            how many times do you need to be told about using localhost is a problem when trying to access any remote system?

            • 18. Re: Network Adapter Could Not Establish The Connection
              Prithwish Adhikari

              Yes . I know that. What I wanted to know is that whether I can change that localhost. As you can see I have already changed  the hostname.

              All I asked for was that can I change the localhost to any other hostname. That's it!!!!!!

              • 19. Re: Network Adapter Could Not Establish The Connection
                cleavitt

                The TNSNames.ora file on the "redhat6" system can be changed from localhost to redhat6, but that won't solve your problem of not being able to connect from a remote computer.

                 

                Can you ping redhat6 from the Windows PC?

                Can you ping 192.168.101.130 from the Windows PC?

                The server configuration has changed.  What error are you getting now when attempting to connect to Oracle from the Windows PC?

                1 2 Previous Next