2 Replies Latest reply: Jan 28, 2013 8:19 AM by Srini Chavali-Oracle RSS

    Not able to Connect Oracle XE using Sid .  username/<pwd>@xe  on Windows7

    user153642
      Hi I have Installed Oracle 11g XE on WIndows 7.

      I am able to connect from Sql*Plus using command
      > system/<pwd>

      But If I try to connect by using following command then Its not connecting

      > system/<pwd>@xe

      Also I am not getting any Error.

      I tried Connecting from Sql*Developer using connection Type as Oracle JDBC and Driver as thin,
      But not able to connect.

      My machine has more than one Oracle Homes, and in each tnsnames.ora, I have added the entry for XE.

      Can any one please help resolving this issue?

      Thanks in advance.

      Krish
        • 1. Re: Not able to Connect Oracle XE using Sid .  username/<pwd>@xe  on Windows7
          EdStevens
          user4865318 wrote:
          Hi I have Installed Oracle 11g XE on WIndows 7.

          I am able to connect from Sql*Plus using command
          system/<pwd>
          But If I try to connect by using following command then Its not connecting
          system/<pwd>@xe
          Also I am not getting any Error.

          I tried Connecting from Sql*Developer using connection Type as Oracle JDBC and Driver as thin,
          But not able to connect.

          My machine has more than one Oracle Homes, and in each tnsnames.ora, I have added the entry for XE.

          Can any one please help resolving this issue?

          Thanks in advance.

          Krish
          read these:
          [url http://edstevensdba.wordpress.com/2011/02/09/sqlnet_overview/] Help! I can’t connect to my database
          [url http://edstevensdba.wordpress.com/2011/02/16/sqlnet_client_cfg/] Help! I can’t connect to my database (part duex) 
          • 2. Re: Not able to Connect Oracle XE using Sid .  username/<pwd>@xe  on Windows7
            Srini Chavali-Oracle
            Pl identify which exact version of Win 7 and whether it is 32-bit or 64-bit

            http://docs.oracle.com/cd/E17781_01/install.112/e18803/toc.htm#BABGGAJA

            What does "not able to connect" mean ? Pl post error codes and error messages you get

            HTH
            Srini