9 Replies Latest reply: Feb 23, 2012 12:58 PM by sb92075 RSS

    EM Not able to connect to the isntance

    AAP
      Hi,

      After a long struggle Finally , I was able to install 10g on RHEL5 in Virtual Tool Box...
      It showed everything successful... but when I tried to open the EM from Browser...
      This is the first page content...

      Startup Recovery

      SQL Exception
      The network adapter could not establish the connection

      Enterprise Manager is not able to connect to the database instance. The state of the Components are listed below

      Listener
      Status Down
      Details : TNS-12541 : TNS : no listener

      Agent connection to Instance
      Status : Failed
      Details : ORA – 12541 : TNS : no Listener ( DBD Error : OCIServer Attach )

      Someone can suggest the solution
        • 1. Re: EM Not able to connect to the isntance
          sb92075
          issue following OS commands

          lsnrctl start
          lsnrctl status
          lsnrctl service

          COPY commands & results then PASTE all back here
          • 2. Re: EM Not able to connect to the isntance
            AAP
            all are giving the same error

            connectiong to ... TCP.........PORT=1521

            TNS -12541 TNS No listener
            TNS -12560 TNS : Protocol adapter error
            TNS 0051 : No Listener
            Linux Error : 111 : connection refused
            • 3. Re: EM Not able to connect to the isntance
              sb92075
              AAP wrote:
              all are giving the same error

              connectiong to ... TCP.........PORT=1521

              TNS -12541 TNS No listener
              TNS -12560 TNS : Protocol adapter error
              TNS 0051 : No Listener
              Linux Error : 111 : connection refused
              line above indicates that OS/Networking misconfiguration exists.

              post results from following OS commands

              uname -a
              cat /etc/hosts
              cat /etc/hostname
              • 4. Re: EM Not able to connect to the isntance
                AAP
                the result are

                uname -a
                linux rhel5.Azhar-PC 2.6.18-8.el5 #1 SMP Fri Jan......i386 GNU/Linux


                cat /etc/hosts
                ::1 localhost6.localdomain6 localhost6
                192.168.1.3 rhel5.Azhar-PC rhel.Azhar-PC

                cat /etc/hostname
                No Such File or Directory

                and sqlnet.ora contents are

                NAMES.DIRECTORY_PATH= ( TNSNAMES, EZCONNECT )
                THIS IS THE ONLY ONE LINE AND OTHER TWO LINES IN THIS FILE ARE REMAARK STARTING WITH #

                wHEN i GET INTO rhel5 BY USER : ORACLE AND PASSWORD : ORACLE

                THIS IS THE ERROR COMES
                User’s $HOME/.dmrc file is being ignored. This prevents the default session and language from saved. File should be owned by user and have 644 permissions. Users $HOME directory must be owned by user and not writable by other users.

                And one more thing... at the last stage while running root.sh script... it ask me to write the full path of local bin directory.... I mentioned

                /usr/bin

                Edited by: AAP on Feb 23, 2012 10:27 AM

                Edited by: AAP on Feb 23, 2012 10:28 AM
                • 5. Re: EM Not able to connect to the isntance
                  sb92075
                  post results like below
                  bcm@bcm-laptop:~$ ifconfig -a
                  eth0      Link encap:Ethernet  HWaddr 00:1e:68:a1:ad:67  
                            UP BROADCAST MULTICAST  MTU:1500  Metric:1
                            RX packets:0 errors:0 dropped:0 overruns:0 frame:0
                            TX packets:0 errors:0 dropped:0 overruns:0 carrier:0
                            collisions:0 txqueuelen:1000 
                            RX bytes:0 (0.0 B)  TX bytes:0 (0.0 B)
                            Interrupt:17 
                  
                  lo        Link encap:Local Loopback  
                            inet addr:127.0.0.1  Mask:255.0.0.0
                            inet6 addr: ::1/128 Scope:Host
                            UP LOOPBACK RUNNING  MTU:16436  Metric:1
                            RX packets:886 errors:0 dropped:0 overruns:0 frame:0
                            TX packets:886 errors:0 dropped:0 overruns:0 carrier:0
                            collisions:0 txqueuelen:0 
                            RX bytes:46688 (46.6 KB)  TX bytes:46688 (46.6 KB)
                  
                  wlan0     Link encap:Ethernet  HWaddr 00:21:63:2b:63:ac  
                            inet addr:192.168.1.103  Bcast:192.168.1.255  Mask:255.255.255.0
                            inet6 addr: fe80::221:63ff:fe2b:63ac/64 Scope:Link
                            UP BROADCAST RUNNING MULTICAST  MTU:1500  Metric:1
                            RX packets:74366 errors:0 dropped:0 overruns:0 frame:0
                            TX packets:67363 errors:0 dropped:0 overruns:0 carrier:0
                            collisions:0 txqueuelen:1000 
                            RX bytes:64222306 (64.2 MB)  TX bytes:15965231 (15.9 MB)
                  bcm@bcm-laptop:~$ ping bcm-laptop
                  PING localhost (127.0.0.1) 56(84) bytes of data.
                  64 bytes from localhost (127.0.0.1): icmp_seq=1 ttl=64 time=0.081 ms
                  64 bytes from localhost (127.0.0.1): icmp_seq=2 ttl=64 time=0.069 ms
                  ^C
                  --- localhost ping statistics ---
                  2 packets transmitted, 2 received, 0% packet loss, time 999ms
                  rtt min/avg/max/mdev = 0.069/0.075/0.081/0.006 ms
                  bcm@bcm-laptop:~$ ping 192.168.1.103
                  PING 192.168.1.103 (192.168.1.103) 56(84) bytes of data.
                  64 bytes from 192.168.1.103: icmp_seq=1 ttl=64 time=0.090 ms
                  64 bytes from 192.168.1.103: icmp_seq=2 ttl=64 time=0.067 ms
                  64 bytes from 192.168.1.103: icmp_seq=3 ttl=64 time=0.071 ms
                  ^C
                  --- 192.168.1.103 ping statistics ---
                  3 packets transmitted, 3 received, 0% packet loss, time 2000ms
                  rtt min/avg/max/mdev = 0.067/0.076/0.090/0.010 ms
                  bcm@bcm-laptop:~$ 
                  • 6. Re: EM Not able to connect to the isntance
                    AAP
                    [oracle@rhel5 ~]$ /sbin/ifconfig -a
                    eth0 Link encap:Ethernet HWaddr 08:00:27:1F:36:84
                    inet addr:192.168.1.3 Bcast:192.168.1.255 Mask:255.255.255.0
                    inet6 addr: fe80::a00:27ff:fe1f:3684/64 Scope:Link
                    UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1
                    RX packets:0 errors:0 dropped:0 overruns:0 frame:0
                    TX packets:102 errors:0 dropped:0 overruns:0 carrier:0
                    collisions:0 txqueuelen:1000
                    RX bytes:0 (0.0 b) TX bytes:17202 (16.7 KiB)
                    Base address:0xd010 Memory:f0000000-f0020000

                    lo Link encap:Local Loopback
                    inet addr:127.0.0.1 Mask:255.0.0.0
                    inet6 addr: ::1/128 Scope:Host
                    UP LOOPBACK RUNNING MTU:16436 Metric:1
                    RX packets:2096 errors:0 dropped:0 overruns:0 frame:0
                    TX packets:2096 errors:0 dropped:0 overruns:0 carrier:0
                    collisions:0 txqueuelen:0
                    RX bytes:5028624 (4.7 MiB) TX bytes:5028624 (4.7 MiB)

                    sit0 Link encap:IPv6-in-IPv4
                    NOARP MTU:1480 Metric:1
                    RX packets:0 errors:0 dropped:0 overruns:0 frame:0
                    TX packets:0 errors:0 dropped:0 overruns:0 carrier:0
                    collisions:0 txqueuelen:0
                    RX bytes:0 (0.0 b) TX bytes:0 (0.0 b)

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

                    [oracle@rhel5 ~]$ ping rhel5.Azhar-PC
                    PING rhel5.Azhar-PC (192.168.1.3) 56(84) bytes of data.
                    64 bytes from rhel5.Azhar-PC (192.168.1.3): icmp_seq=1 ttl=64 time=0.210 ms
                    64 bytes from rhel5.Azhar-PC (192.168.1.3): icmp_seq=2 ttl=64 time=0.080 ms
                    64 bytes from rhel5.Azhar-PC (192.168.1.3): icmp_seq=3 ttl=64 time=0.033 ms
                    64 bytes from rhel5.Azhar-PC (192.168.1.3): icmp_seq=4 ttl=64 time=0.125 ms
                    64 bytes from rhel5.Azhar-PC (192.168.1.3): icmp_seq=5 ttl=64 time=0.036 ms
                    64 bytes from rhel5.Azhar-PC (192.168.1.3): icmp_seq=6 ttl=64 time=0.041 ms
                    64 bytes from rhel5.Azhar-PC (192.168.1.3): icmp_seq=7 ttl=64 time=0.045 ms
                    64 bytes from rhel5.Azhar-PC (192.168.1.3): icmp_seq=8 ttl=64 time=0.123 ms
                    64 bytes from rhel5.Azhar-PC (192.168.1.3): icmp_seq=9 ttl=64 time=0.038 ms
                    64 bytes from rhel5.Azhar-PC (192.168.1.3): icmp_seq=10 ttl=64 time=0.113 ms
                    64 bytes from rhel5.Azhar-PC (192.168.1.3): icmp_seq=11 ttl=64 time=0.130 ms
                    64 bytes from rhel5.Azhar-PC (192.168.1.3): icmp_seq=12 ttl=64 time=0.107 ms

                    --- rhel5.Azhar-PC ping statistics ---
                    12 packets transmitted, 12 received, 0% packet loss, time 11004ms
                    rtt min/avg/max/mdev = 0.033/0.090/0.210/0.052 ms


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

                    PING 192.168.1.3 (192.168.1.3) 56(84) bytes of data.
                    64 bytes from 192.168.1.3: icmp_seq=1 ttl=64 time=0.048 ms
                    64 bytes from 192.168.1.3: icmp_seq=2 ttl=64 time=0.031 ms
                    64 bytes from 192.168.1.3: icmp_seq=3 ttl=64 time=0.131 ms

                    --- 192.168.1.3 ping statistics ---
                    3 packets transmitted, 3 received, 0% packet loss, time 2000ms
                    rtt min/avg/max/mdev = 0.031/0.070/0.131/0.043 ms

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

                    [oracle@rhel5 ~]$ ping 192.168.1.3
                    PING 192.168.1.3 (192.168.1.3) 56(84) bytes of data.
                    64 bytes from 192.168.1.3: icmp_seq=1 ttl=64 time=0.028 ms
                    64 bytes from 192.168.1.3: icmp_seq=2 ttl=64 time=0.034 ms
                    64 bytes from 192.168.1.3: icmp_seq=3 ttl=64 time=0.072 ms
                    64 bytes from 192.168.1.3: icmp_seq=4 ttl=64 time=0.087 ms
                    64 bytes from 192.168.1.3: icmp_seq=5 ttl=64 time=0.057 ms
                    64 bytes from 192.168.1.3: icmp_seq=6 ttl=64 time=0.138 ms

                    --- 192.168.1.3 ping statistics ---
                    6 packets transmitted, 6 received, 0% packet loss, time 5002ms
                    rtt min/avg/max/mdev = 0.028/0.069/0.138/0.037 ms
                    • 7. Re: EM Not able to connect to the isntance
                      sb92075
                      AAP wrote:
                      [oracle@rhel5 ~]$ /sbin/ifconfig -a
                      eth0 Link encap:Ethernet HWaddr 08:00:27:1F:36:84
                      inet addr:192.168.1.3 Bcast:192.168.1.255 Mask:255.255.255.0
                      inet6 addr: fe80::a00:27ff:fe1f:3684/64 Scope:Link
                      UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1
                      RX packets:0 errors:0 dropped:0 overruns:0 frame:0
                      TX packets:102 errors:0 dropped:0 overruns:0 carrier:0
                      The two lines immediately above bother me.
                      Why ZERO receive (RX) packets?

                      Also I can not reconcile this observation with other seemingly normal network activity
                      • 8. Re: EM Not able to connect to the isntance
                        AAP
                        Please check my post no 68 above .... can you get something from their.... because those were the only abnormal activity...
                        • 9. Re: EM Not able to connect to the isntance
                          sb92075
                          http://heliosguneserol.wordpress.com/2010/08/31/tns-12541-tns-12560-tns-00511-linux-error-111/