4 Replies Latest reply: May 8, 2012 3:45 AM by 875258 RSS

    Logon in TOAD as SYSDBA only

    RemcoGoris
      Hi,

      I have searched the forum for entries for this problem, but haven't found the answer.
      I try to logon to XE 11g
      sqlplus remco@xe
      
      SQL*Plus: Release 11.2.0.2.0 Beta on Thu Feb 9 17:20:47 2012
      
      Copyright (c) 1982, 2010, Oracle.  All rights reserved.
      
      Enter password:
      
      Connected to:
      Oracle Database 11g Express Edition Release 11.2.0.2.0 - Beta
      
      SQL>
      Then when I try logging on in TOAD (same user, same password, same database) I can only connect as SYSDBA. When I set the "Connect as" dropdown to 'Normal', I get the message that username/password is incorrect: ORA-01017: invalid username/password; logon denied.

      I thought I had found the problem, because Toad uses a different tnsnames.ora than the SQL*Plus session I use. But even after synchronizing the tnsnames entries in both files, the same error occurs when trying to connect with Toad.

      Anyone? Could the explanation be that Toad use a 9i client and a 9i oracle_home, whereas with SQL*Plus I set the oracle_home to the XE 11g home?
      Thanks in advance!
      Remco
        • 1. Re: Logon in TOAD as SYSDBA only
          jgarry
          A toad forum would likely give a better answer. But anyways, have you tried with the 9i sqlplus? There is a compatibility matrix on MOS Client / Server / Interoperability Support Between Different Oracle Versions [ID 207303.1] which says to go from 9i to 11g you must be on 9.2.0.4 or later. Anything below that not supported.

          Edit: Also, 11 has case sensitive passwords, maybe toad is sending all uppercase or the converse.
          Edit2: invalid username/password

          Edited by: jgarry on Feb 9, 2012 10:18 AM

          Edited by: jgarry on Feb 9, 2012 10:20 AM
          • 2. Re: Logon in TOAD as SYSDBA only
            orafad
            RemcoGoris wrote:
            the message that username/password is incorrect: ORA-01017: invalid username/password; logon denied.
            toadworld.com

            But I think I recall that Toad (older versions) has some password "feature" that does not work well with case sensitivity in passwords introduced in current release.

            Search at toadworld or get a current toad.
            • 3. Re: Logon in TOAD as SYSDBA only
              RemcoGoris
              Thanks guys! Iĺl check the toad forums. If I find the answer, I will post it here.
              • 4. Toad exports query result as UPDATE stmt or export the update stmt
                875258
                Hi,

                Can any one advise me how to export the Update statement from toad or any other tool.(Here having a big number of record that have export from instance and run as a script in the another instance so that the all records will update at once)

                Example:

                In toad, we can export the insert statement from export data option.
                similarly can we export the update query from toad or any other tool or have any procedure that generates the update statement.
                Thanks a lot,
                Sree