Results 1 to 8 of 8
  1. #1
    Join Date
    Apr 2004
    Posts
    11

    Question Unanswered: No IP address found !

    While installing Oracle 10g on my standalone machine with windows 2003 message comes no IP address not found as the settings are automatically detect one. I ignore the message and continue installing. After installation when I go to SQL* and try to connect system/manager the error mesage ORA-12560 TNSrotocol adapter error. I am newbie and want to practice pl/sql. What and were am I going wrong.

  2. #2
    Join Date
    Nov 2002
    Location
    Desk, slightly south of keyboard
    Posts
    697
    Hi,

    This sounds like a Win IP issue rather than an Oracle one. If your machine is standalone then no IP address would be bound to your 'non existant' network card.

    You might try specifying 127.0.0.1 as the IP for your machine - manually specifying this as a static IP under your Windows Networking settings. As a valid and bound IP, the Oracle installer should see it.

    Hth
    Bill
    Please don't email me directly with questions. I've probably just got home from the pub and cannot guarantee the sanity of my answers. In fact, I can't believe I actually made it home.

  3. #3
    Join Date
    Apr 2004
    Posts
    11

    IP address of the host not determined

    I am trying to install oracle 10g on Windows2003, my machine is standalone, the network setting were "obtain an IP automatically " so while installation error was "IP address of host cannot be determined".
    Then I manually specified IP addtress to 128.0.0.1 but still the initail problem persists and the same error mesage is thrown.

  4. #4
    Join Date
    Nov 2002
    Location
    Desk, slightly south of keyboard
    Posts
    697
    If you run a cmd prompt and type
    ipconfig
    what do you get?

    Cheers
    Bill
    Please don't email me directly with questions. I've probably just got home from the pub and cannot guarantee the sanity of my answers. In fact, I can't believe I actually made it home.

  5. #5
    Join Date
    Apr 2004
    Posts
    11
    Ethernet adapter Local Area Connection
    Media State. . . . . . . . . : Media disconnected

    PPP adapter {E2E57A19-CDOD-860D-83FD0B99BO3C}:

    connection-specific DNS Suffix . :
    IP Address. . . . . . . . . . . . : 172.188.163.212
    Subnet Mask . . . . . . . . . . .: 255.255.255.255
    Default Gateway . . . . . . . : 172.188.163.212

  6. #6
    Join Date
    Nov 2002
    Location
    Desk, slightly south of keyboard
    Posts
    697
    Hi,

    The IP address being returned is a public IP which you shouldn't have - particularly as you've specified a different static IP address in your network config (from previous post).

    Windows looks at that public IP (172.188.163.212) and asumes your machine is part of the big wide world and acts accordingly, when your machine is in fact stand alone and isolated.

    I think I probably gave you a bum steer to enter 127.0.0.1 - this is used as a kind of loopback address - it means whatever the local IP is. I doubt whether that can be used as a static IP. Ie, everyone in the world should be able to ping 127.0.0.1 and get a reply... from themselves.

    Anyway, regardless of that, you need to convince Windows that you are part of a privately managed network. 192.168.0.x is a always a class C, non publicly routable address. So try the following...

    Specify a fixed IP address: 192.168.0.1
    Subnet Mask: 255.255.255.0
    Default Gateway: (none specified, ie blank)

    Code:
    C:\Documents and Settings\Administrator>ipconfig
    
    Windows 2000 IP Configuration
    
    Ethernet adapter Local INTERNAL:
    
            Connection-specific DNS Suffix  . :
            IP Address. . . . . . . . . . . . : 192.168.0.1
            Subnet Mask . . . . . . . . . . . : 255.255.255.0
            Default Gateway . . . . . . . . . :
    
    C:\Documents and Settings\Administrator>ping 127.0.0.1
    
    Pinging 127.0.0.1 with 32 bytes of data:
    
    Reply from 127.0.0.1: bytes=32 time<10ms TTL=128
    Reply from 127.0.0.1: bytes=32 time<10ms TTL=128
    Reply from 127.0.0.1: bytes=32 time<10ms TTL=128
    Reply from 127.0.0.1: bytes=32 time<10ms TTL=128
    
    Ping statistics for 127.0.0.1:
        Packets: Sent = 4, Received = 4, Lost = 0 (0% loss),
    Approximate round trip times in milli-seconds:
        Minimum = 0ms, Maximum =  0ms, Average =  0ms
    
    C:\Documents and Settings\Administrator>ping 192.168.0.1
    
    Pinging 192.168.0.1 with 32 bytes of data:
    
    Reply from 192.168.0.1: bytes=32 time<10ms TTL=128
    Reply from 192.168.0.1: bytes=32 time<10ms TTL=128
    Reply from 192.168.0.1: bytes=32 time<10ms TTL=128
    Reply from 192.168.0.1: bytes=32 time<10ms TTL=128
    
    Ping statistics for 192.168.0.1:
        Packets: Sent = 4, Received = 4, Lost = 0 (0% loss),
    Approximate round trip times in milli-seconds:
        Minimum = 0ms, Maximum =  0ms, Average =  0ms
    
    C:\Documents and Settings\Administrator>tnsping dev.asd
    
    TNS Ping Utility for 32-bit Windows: Version 8.1.7.0.0 - Production on 26-MAY-2004 00:22:37
    
    (c) Copyright 1997 Oracle Corporation.  All rights reserved.
    
    Attempting to contact ADDRESS=(PROTOCOL=TCP)(HOST=192.168.0.1)(PORT=1521))
    OK (160 msec)
    Hth
    Bill
    Please don't email me directly with questions. I've probably just got home from the pub and cannot guarantee the sanity of my answers. In fact, I can't believe I actually made it home.

  7. #7
    Join Date
    Apr 2004
    Posts
    11
    I did as u explained but the problem persists.

    If I am connected Internet the ipconfig returns following -



    Microsoft Windows [Version 5.2.3790]
    (C) Copyright 1985-2003 Microsoft Corp.

    D:\Documents and Settings\Administrator.SS>ipconfig

    Windows IP Configuration


    Ethernet adapter Local Area Connection:

    Media State . . . . . . . . . . . : Media disconnected

    PPP adapter {E2E57A19-CB71-4D0D-860D-83FD0B99B03C}:

    Connection-specific DNS Suffix . :
    IP Address. . . . . . . . . . . . : 172.186.128.169
    Subnet Mask . . . . . . . . . . . : 255.255.255.255
    Default Gateway . . . . . . . . . : 172.186.128.169

    D:\Documents and Settings\Administrator.SS>

    Microsoft Windows [Version 5.2.3790]
    (C) Copyright 1985-2003 Microsoft Corp.

    D:\Documents and Settings\Administrator.SS>ipconfig

    Windows IP Configuration


    Ethernet adapter Local Area Connection:

    Media State . . . . . . . . . . . : Media disconnected

    PPP adapter {E2E57A19-CB71-4D0D-860D-83FD0B99B03C}:

    Connection-specific DNS Suffix . :
    IP Address. . . . . . . . . . . . : 172.186.128.169
    Subnet Mask . . . . . . . . . . . : 255.255.255.255
    Default Gateway . . . . . . . . . : 172.186.128.169



    and when I am not returns following -



    Microsoft Windows [Version 5.2.3790]
    (C) Copyright 1985-2003 Microsoft Corp.

    D:\Documents and Settings\Administrator.SS>ipconfig

    Windows IP Configuration


    Ethernet adapter Local Area Connection:

    Media State . . . . . . . . . . . : Media disconnected

    D:\Documents and Settings\Administrator.SS>


    and I am not able to ping 192.168.0.1
    pls tell whats happening....

  8. #8
    Join Date
    Nov 2002
    Location
    Desk, slightly south of keyboard
    Posts
    697
    Hi,

    The problem is that TCP/IP is not being bound to your network adapter as it is unplugged. I guess that your static entered IP is being ignored aswell. Are you sure you are entering the static IP 192.168.0.1 against the correct adapter ("Ethernet adapter Local Area Connection") and not your modem.

    The PPP connector is your modem/broadband etc.

    You might be better off to get the static IP configured first by asking in one of the windows networking newsgroups, then coming back here for the Oracle install if it is still problematic.

    Found this as a starting point....

    http://groups.google.com/groups?q=co...att.com&rnum=9

    Hth
    Bill
    Please don't email me directly with questions. I've probably just got home from the pub and cannot guarantee the sanity of my answers. In fact, I can't believe I actually made it home.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •