4 Replies Latest reply on Mar 27, 2012 1:36 AM by 926456

    XE release 11.2.0.2.0 on Win 7 64

    926456
      I installed XE release 11.2.0.2.0 on a Win 7 64 machine. I have created a test environment and I was able to log into apex and start my training. I tried to log in using the 'connect' command within the 'Run SQL Command Line' window using first my SYSTEM username/password config and my test environment login credentials. All received the ORA-12154 error. After some research online, I think the tnsnames.ora file and an inability for oracle XE to handle parenthesis () within the file name may be the issue. Not sure, but I would like to run my test environment through both the browser GUI and the command line to practive. Any thoughts?

      My tnsnames.ora file was located here: C:\oraclexe\app\oracle\product\11.2.0\server\network\ADMIN

      The contents of the file is as follows:

      XE =
      (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = Office-PC)(PORT = 1521))
      (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = XE)
      )
      )

      EXTPROC_CONNECTION_DATA =
      (DESCRIPTION =
      (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
      )
      (CONNECT_DATA =
      (SID = PLSExtProc)
      (PRESENTATION = RO)
      )
      )

      ORACLR_CONNECTION_DATA =
      (DESCRIPTION =
      (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
      )
      (CONNECT_DATA =
      (SID = CLRExtProc)
      (PRESENTATION = RO)
      )
      )
        • 1. Re: XE release 11.2.0.2.0 on Win 7 64
          orafad
          user13254781 wrote:
          I tried to log in using the 'connect' command within the 'Run SQL Command Line' window using first my SYSTEM username/password config and my test environment login credentials. All received the ORA-12154 error.
          Please show us your attempt including results.

          Post a copy-paste of sql command line session when trying to connect.

          You don't happen to have a @ sign in the password?


          Example from successful 'connect':
          SQL*Plus: Release 11.2.0.2.0 Production on MÕ Mar 26 21:41:59 2012
          
          Copyright (c) 1982, 2010, Oracle.  All rights reserved.
          
          SQL> connect test
          Enter password:
          Connected.
          SQL>
          • 2. Re: XE release 11.2.0.2.0 on Win 7 64
            926456
            Hi orafad,

            I actually do have an '@' sign. Is this my error?

            http://screencast.com/t/tZ6lBpT2

            SQL> connect
            Enter user-name: J@son
            Enter password: <password with '@' symbol>
            • 3. Re: XE release 11.2.0.2.0 on Win 7 64
              orafad
              In Oracle, there are non-quoted and quoted identifers.
              SQL> conn / as sysdba
              Connected.
              SQL> alter user test2 identified by "x@x";
              
              User altered.
              
              SQL> conn test2/x@x
              ERROR:
              ORA-12154: TNS:could not resolve the connect identifier specified
              
              
              Warning: You are no longer connected to ORACLE.
              
              SQL> conn test2/"x@x"
              Connected.
              Same goes for username... I would remove the @ to avoid future problems.

              Edited by: orafad on Mar 27, 2012 1:15 AM
              • 4. Re: XE release 11.2.0.2.0 on Win 7 64
                926456
                Thank you orafad, removing the '@' worked great.