problem with windows and linux

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Chris
    #1

    problem with windows and linux

    A weird issue...though hopefully not for everyone...


    I am trying to connect to a 10g database on a Red Hat Linux server from my
    9i client on a XP pc.
    Both are on my local home network, behind a router.

    I can ping the linux server from my XP box successfully:
    C:\>ping 192.168.1.101

    Pinging 192.168.1.101 with 32 bytes of data:

    Reply from 192.168.1.101: bytes=32 time<1ms TTL=64
    ..
    ..
    ..

    On the linux server itself, I can sqlplus to the database no problem:
    oracle10@linuxb ox<1>:/db01/app/oracle10sqlplus system@red1

    SQL*Plus: Release 10.1.0.2.0 - Production on Wed Jul 7 16:30:13 2004

    Copyright (c) 1982, 2004, Oracle. All rights reserved.

    Enter password:

    Connected to:
    Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Production
    With the Partitioning and Data Mining options

    SQL>

    I can also VPN into work and connect to any database there successfully,
    from my XP box.

    My problem is connecting from my XP box to my Linux server via sqlplus.

    note: my vpn connection is disconnected, and I can ping the server when
    trying the below stuff

    examples:
    TNSPING EXAMPLE
    C:\>tnsping red1

    TNS Ping Utility for 32-bit Windows: Version 9.2.0.1.0 - Production on
    07-JUL-2004 16:26:32

    Copyright (c) 1997 Oracle Corporation. All rights reserved.

    Used parameter files:


    Used TNSNAMES adapter to resolve the alias
    Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST =
    192.168.1.101)( PORT = 1521)) (CONNECT_DATA = (SID = RED1)))
    TNS-12560: TNS:protocol adapter error

    C:\>


    SQLPLUS EXAMPLE
    C:\>sqlplus system@red1

    SQL*Plus: Release 9.2.0.1.0 - Production on Wed Jul 7 16:27:29 2004

    Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

    Enter password:
    ERROR:
    ORA-12560: TNS:protocol adapter error

    Enter user-name:
    ERROR:
    ORA-12560: TNS:protocol adapter error

    Enter user-name:
    ERROR:
    ORA-12560: TNS:protocol adapter error

    SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus

    C:\>



    FILES:

    sqlnet.ora:
    NAME.DEFAULT_ZO NE = world
    NAMES.DEFAULT_D OMAIN = world
    NAMES.DIRECTORY _PATH= (TNSNAMES)

    tnsnames.ora:
    RED1.WORLD =
    (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.101)( PORT = 1521))
    (CONNECT_DATA = (SID = RED1))
    )


    I belive the problem has something to do with my linux setup, but linux is
    pretty new to me.

    Any help would be great.





    Tags: None
    • s.kapitza
      #2
      Re: problem with windows and linux

      "Chris" <Chris@rogerss. comwrote in message news:<skZGc.181 $UJn1.120@news0 4.bloor.is.net. cable.rogers.co m>...
      A weird issue...though hopefully not for everyone...
      >
      >
      I am trying to connect to a 10g database on a Red Hat Linux server from my
      9i client on a XP pc.
      Both are on my local home network, behind a router.
      >
      I can ping the linux server from my XP box successfully:
      C:\>ping 192.168.1.101
      >
      Pinging 192.168.1.101 with 32 bytes of data:
      >
      Reply from 192.168.1.101: bytes=32 time<1ms TTL=64
      .
      .
      .
      >
      On the linux server itself, I can sqlplus to the database no problem:
      oracle10@linuxb ox<1>:/db01/app/oracle10sqlplus system@red1
      >
      SQL*Plus: Release 10.1.0.2.0 - Production on Wed Jul 7 16:30:13 2004
      >
      Copyright (c) 1982, 2004, Oracle. All rights reserved.
      >
      Enter password:
      >
      Connected to:
      Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Production
      With the Partitioning and Data Mining options
      >
      SQL>
      >
      I can also VPN into work and connect to any database there successfully,
      from my XP box.
      >
      My problem is connecting from my XP box to my Linux server via sqlplus.
      >
      note: my vpn connection is disconnected, and I can ping the server when
      trying the below stuff
      >
      examples:
      TNSPING EXAMPLE
      C:\>tnsping red1
      >
      TNS Ping Utility for 32-bit Windows: Version 9.2.0.1.0 - Production on
      07-JUL-2004 16:26:32
      >
      Copyright (c) 1997 Oracle Corporation. All rights reserved.
      >
      Used parameter files:
      >
      >
      Used TNSNAMES adapter to resolve the alias
      Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST =
      192.168.1.101)( PORT = 1521)) (CONNECT_DATA = (SID = RED1)))
      TNS-12560: TNS:protocol adapter error
      >
      C:\>
      >
      >
      SQLPLUS EXAMPLE
      C:\>sqlplus system@red1
      >
      SQL*Plus: Release 9.2.0.1.0 - Production on Wed Jul 7 16:27:29 2004
      >
      Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
      >
      Enter password:
      ERROR:
      ORA-12560: TNS:protocol adapter error
      >
      Enter user-name:
      ERROR:
      ORA-12560: TNS:protocol adapter error
      >
      Enter user-name:
      ERROR:
      ORA-12560: TNS:protocol adapter error
      >
      SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus
      >
      C:\>
      >
      >
      >
      FILES:
      >
      sqlnet.ora:
      NAME.DEFAULT_ZO NE = world
      NAMES.DEFAULT_D OMAIN = world
      NAMES.DIRECTORY _PATH= (TNSNAMES)
      >
      tnsnames.ora:
      RED1.WORLD =
      (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.101)( PORT = 1521))
      (CONNECT_DATA = (SID = RED1))
      )
      >
      >
      I belive the problem has something to do with my linux setup, but linux is
      pretty new to me.
      >
      Any help would be great.
      have you lookup ora-12560 ? possibly <ora-12560 trace sybrandwould
      be a sweet tripple to search for.

      other things to check :

      - is the listner realy up ? (to check with ps -ef )
      - you could telnet from xp to linux on port 1521 to check if the port
      is open
      - check the listner.log
      - you could use tcpdump on linux to check arriving packets
      - did you install firewalling ???

      regards

      s.kapitza

        Comment

        • Chris
          #3
          Re: problem with windows and linux

          skapitza@volcan omail.com (s.kapitza) wrote in message news:<26703915. 0407082038.4af7 83d7@posting.go ogle.com>...
          "Chris" <Chris@rogerss. comwrote in message news:<skZGc.181 $UJn1.120@news0 4.bloor.is.net. cable.rogers.co m>...
          A weird issue...though hopefully not for everyone...


          I am trying to connect to a 10g database on a Red Hat Linux server from my
          9i client on a XP pc.
          Both are on my local home network, behind a router.

          I can ping the linux server from my XP box successfully:
          C:\>ping 192.168.1.101

          Pinging 192.168.1.101 with 32 bytes of data:

          Reply from 192.168.1.101: bytes=32 time<1ms TTL=64
          .
          .
          .

          On the linux server itself, I can sqlplus to the database no problem:
          oracle10@linuxb ox<1>:/db01/app/oracle10sqlplus system@red1

          SQL*Plus: Release 10.1.0.2.0 - Production on Wed Jul 7 16:30:13 2004

          Copyright (c) 1982, 2004, Oracle. All rights reserved.

          Enter password:

          Connected to:
          Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Production
          With the Partitioning and Data Mining options

          SQL>

          I can also VPN into work and connect to any database there successfully,
          from my XP box.

          My problem is connecting from my XP box to my Linux server via sqlplus.

          note: my vpn connection is disconnected, and I can ping the server when
          trying the below stuff

          examples:
          TNSPING EXAMPLE
          C:\>tnsping red1

          TNS Ping Utility for 32-bit Windows: Version 9.2.0.1.0 - Production on
          07-JUL-2004 16:26:32

          Copyright (c) 1997 Oracle Corporation. All rights reserved.

          Used parameter files:


          Used TNSNAMES adapter to resolve the alias
          Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST =
          192.168.1.101)( PORT = 1521)) (CONNECT_DATA = (SID = RED1)))
          TNS-12560: TNS:protocol adapter error

          C:\>


          SQLPLUS EXAMPLE
          C:\>sqlplus system@red1

          SQL*Plus: Release 9.2.0.1.0 - Production on Wed Jul 7 16:27:29 2004

          Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

          Enter password:
          ERROR:
          ORA-12560: TNS:protocol adapter error

          Enter user-name:
          ERROR:
          ORA-12560: TNS:protocol adapter error

          Enter user-name:
          ERROR:
          ORA-12560: TNS:protocol adapter error

          SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus

          C:\>



          FILES:

          sqlnet.ora:
          NAME.DEFAULT_ZO NE = world
          NAMES.DEFAULT_D OMAIN = world
          NAMES.DIRECTORY _PATH= (TNSNAMES)

          tnsnames.ora:
          RED1.WORLD =
          (DESCRIPTION =
          (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.101)( PORT = 1521))
          (CONNECT_DATA = (SID = RED1))
          )


          I belive the problem has something to do with my linux setup, but linux is
          pretty new to me.

          Any help would be great.
          >
          have you lookup ora-12560 ? possibly <ora-12560 trace sybrandwould
          be a sweet tripple to search for.
          >
          other things to check :
          >
          - is the listner realy up ? (to check with ps -ef )
          - you could telnet from xp to linux on port 1521 to check if the port
          is open
          - check the listner.log
          - you could use tcpdump on linux to check arriving packets
          - did you install firewalling ???
          >
          regards
          >
          s.kapitza

          Thanks. I disabled the iptables service on the linux box and
          everything worked fine. I find out how to edit that file and then all
          will be fine.

          THank you s.kapitza.

            Comment

            Previous template Next
            Working...