3 Replies Latest reply: Apr 27, 2012 9:30 AM by Alex Schroeder RSS

    invalid username/password; logon denied

    Alex Schroeder
      We are migrating from Oracle 8 to Oracle 11g. Amongst the various tools the client uses is an application written in C++ that uses ODBC. This application is giving us a peculiar problem: From the laptop of one of the main developers, it can connect to the Oracle 11g database just fine. From every other machine (including my own desktop) we cannot connect to the Oracle 11g database using this application.

      On my desktop, I can connect to the database using SQL*Plus. I can use the ODBC connection I created for Excel and import data from the Oracle 11g database into a sheet of mine. Thus, for all intents and purposes it seems to work.

      Ordinarily I'd say that the C++ application is simply broken. The only problem with this explanation is that it apparently works from the main developer's laptop. Does this strange behavior ring a bell? Did he not correctly deinstall his Oracle 8 libraries? Are there configuration options we could have forgotten somewhere? A client setting regarding case-sensitivity of usernames?

      The error message comes with "COM info" and says:

      HRESULT value = -2147217843
      HRESULT message = IDispatch error #3149
      IErrorInfo source = Microsoft OLE DB Provider for ODBC Drivers
      IErrorInfo description = [Oracle][ODBC][Ora]ORA-01017: invalid username/password; logon denied

      I was hoping I could trace the connection somewhere and figure out what username and password was being sent over the wire. Unfortunately the listener.log file only list the OS username, eg. (CONNECT_DATA=(SID=xxx)(CID=(PROGRAM=xxx.exe)(HOST=xxx)(USER=asc))) with asc being my OS username but not the username used to log into the database.

      Any other ideas?
        • 1. Re: invalid username/password; logon denied
          clcarter
          A client setting regarding case-sensitivity of usernames?
          That's one possibility, since the 11g default does use case sensitive passwords.
          works from the main developer's laptop
          So someone does have the exact and correct username/password values.
          Unfortunately the listener.log file only list the OS username
          That is correct. But there are ways to grab login info (i.e. username, client IP address, etc.) and maybe save it to a table or log it some place if figuring out the correct username is part of the issue.
          • 2. Re: invalid username/password; logon denied
            Alex Schroeder
            someone does have the exact and correct username/password values
            Apparently username and password are hard-coded into the application, so if I'm using the same application, I should not have to worry about username/password (both of them lower-case and both of them ASCII-only, no fancy encoding issues). I can use this username/password to connect to the database using SQL*Plus.

            What I'm missing, I think, is proof that the application is in fact always sending the correct username/password to the server, or that the application is triggering an error (except for the developers laptop) which is somehow masked by the "invalid username/password" error message.
            But there are ways to grab login info (i.e. username, client IP address, etc.) and maybe save it to a table or log it some place if figuring out the correct username is part of the issue.
            How could I grab the login info used by the application as it tries to connect to the Oracle 11g server? Below I have added some (too much?) Tracing info. Can I extract the login info used by the application from it?

            One thing that surprised my is that I see a ns=12630 in the Trace file (ORA-12630: Native service operation not supported) -- I wonder whether that is the real culprit.

            I've set my sqlnet.ora on the client side as follows:

            SQLNET.AUTHENTICATION_SERVICES= (NONE)
            NAMES.DIRECTORY_PATH= (TNSNAMES)
            TRACE_LEVEL_CLIENT = SUPPORT
            TRACE_LEVEL_SERVER = SUPPORT
            ADR_BASE = \app\asc

            I've used trcasst to convert the Trace file into a summary, but didn't find anything to tell me what the problem is. The last function apparently involves TTIOER. That indicates an error somewhere, I think.

            <--- Received 128 bytes - Data packet timestamp=012-04-25 10:42:58.595706
            ORACLE function complete (TTIOER)

            ---> Send 10 bytes - Data packet timestamp=012-04-25 10:42:58.597280
                 Data Packet flags:
                      End of file

            Looking at the Trace file itself, my main problem is that I don't know what the important parts are. Here is a selection that caught my eye:

            2012-04-25 10:42:58.093417 : nioqrc:entry
            2012-04-25 10:42:58.093440 : nsbasic_bsd:entry
            2012-04-25 10:42:58.093461 : nsbasic_bsd:tot=0, plen=1318.
            2012-04-25 10:42:58.093482 : nttfpwr:entry
            2012-04-25 10:42:58.093567 : nttfpwr:socket 1012 had bytes written=1318
            2012-04-25 10:42:58.093591 : nttfpwr:exit
            2012-04-25 10:42:58.093612 : nsbasic_bsd:packet dump
            2012-04-25 10:42:58.093634 : nsbasic_bsd:05 26 00 00 06 00 00 00 |.&......|
            2012-04-25 10:42:58.093657 : nsbasic_bsd:00 00 03 73 03 01 04 00 |...s....|
            2012-04-25 10:42:58.093679 : nsbasic_bsd:00 00 01 01 00 00 01 12 |........|
            2012-04-25 10:42:58.093701 : nsbasic_bsd:00 00 00 01 01 04 44 65 |......De|
            2012-04-25 10:42:58.093724 : nsbasic_bsd:6D 6F 0C 00 00 00 0C 41 |mo.....A|
            2012-04-25 10:42:58.093746 : nsbasic_bsd:55 54 48 5F 53 45 53 53 |UTH_SESS|
            2012-04-25 10:42:58.093768 : nsbasic_bsd:4B 45 59 60 00 00 00 FE |KEY`... |
            2012-04-25 10:42:58.093790 : nsbasic_bsd:40 43 41 30 34 30 38 36 |@CA04086|
            2012-04-25 10:42:58.093812 : nsbasic_bsd:34 32 34 41 37 38 43 30 |424A78C0|
            2012-04-25 10:42:58.093834 : nsbasic_bsd:38 43 30 38 30 36 30 35 |8C080605|
            2012-04-25 10:42:58.093856 : nsbasic_bsd:37 37 44 43 35 43 45 36 |77DC5CE6|
            2012-04-25 10:42:58.093878 : nsbasic_bsd:34 31 32 31 33 38 42 38 |412138B8|
            2012-04-25 10:42:58.093900 : nsbasic_bsd:37 37 38 33 43 45 37 38 |7783CE78|
            2012-04-25 10:42:58.093922 : nsbasic_bsd:43 30 30 37 34 32 32 33 |C0074223|
            2012-04-25 10:42:58.093944 : nsbasic_bsd:39 33 41 30 43 44 44 30 |93A0CDD0|
            2012-04-25 10:42:58.093966 : nsbasic_bsd:30 20 37 45 36 38 38 45 |0.7E688E|
            2012-04-25 10:42:58.093988 : nsbasic_bsd:36 35 42 33 41 38 39 35 |65B3A895|
            2012-04-25 10:42:58.094010 : nsbasic_bsd:34 32 38 31 41 39 36 41 |4281A96A|
            2012-04-25 10:42:58.094031 : nsbasic_bsd:44 33 37 35 45 46 43 46 |D375EFCF|
            2012-04-25 10:42:58.094054 : nsbasic_bsd:45 39 00 01 00 00 00 0D |E9......|
            2012-04-25 10:42:58.094076 : nsbasic_bsd:00 00 00 0D 41 55 54 48 |....AUTH|
            2012-04-25 10:42:58.094098 : nsbasic_bsd:5F 50 41 53 53 57 4F 52 |_PASSWOR|
            2012-04-25 10:42:58.094120 : nsbasic_bsd:44 40 00 00 00 40 35 39 |D@...@59|
            2012-04-25 10:42:58.094142 : nsbasic_bsd:33 35 43 37 44 33 33 38 |35C7D338|
            2012-04-25 10:42:58.094164 : nsbasic_bsd:36 37 38 34 45 32 33 34 |6784E234|
            2012-04-25 10:42:58.094186 : nsbasic_bsd:30 43 39 30 36 34 36 36 |0C906466|
            2012-04-25 10:42:58.094207 : nsbasic_bsd:46 44 35 46 37 42 34 38 |FD5F7B48|
            2012-04-25 10:42:58.094230 : nsbasic_bsd:33 43 41 43 39 37 43 38 |3CAC97C8|
            2012-04-25 10:42:58.094252 : nsbasic_bsd:42 35 36 31 34 36 33 41 |B561463A|
            2012-04-25 10:42:58.094273 : nsbasic_bsd:39 34 41 45 39 45 46 43 |94AE9EFC|
            2012-04-25 10:42:58.094295 : nsbasic_bsd:31 44 39 43 33 36 00 00 |1D9C36..|
            2012-04-25 10:42:58.094318 : nsbasic_bsd:00 00 08 00 00 00 08 41 |.......A|
            2012-04-25 10:42:58.094339 : nsbasic_bsd:55 54 48 5F 52 54 54 07 |UTH_RTT.|
            2012-04-25 10:42:58.094361 : nsbasic_bsd:00 00 00 07 31 31 30 36 |....1106|
            2012-04-25 10:42:58.094388 : nsbasic_bsd:39 34 39 00 00 00 00 0D |949.....|
            2012-04-25 10:42:58.094410 : nsbasic_bsd:00 00 00 0D 41 55 54 48 |....AUTH|
            2012-04-25 10:42:58.094432 : nsbasic_bsd:5F 43 4C 4E 54 5F 4D 45 |_CLNT_ME|
            2012-04-25 10:42:58.094454 : nsbasic_bsd:4D 04 00 00 00 04 34 30 |M.....40|
            2012-04-25 10:42:58.094476 : nsbasic_bsd:39 36 00 00 00 00 0D 00 |96......|
            2012-04-25 10:42:58.094498 : nsbasic_bsd:00 00 0D 41 55 54 48 5F |...AUTH_|
            2012-04-25 10:42:58.094520 : nsbasic_bsd:54 45 52 4D 49 4E 41 4C |TERMINAL|
            2012-04-25 10:42:58.094542 : nsbasic_bsd:06 00 00 00 06 42 53 49 |.....BSI|
            2012-04-25 10:42:58.094564 : nsbasic_bsd:32 34 32 00 00 00 00 0F |242.....|
            2012-04-25 10:42:58.094586 : nsbasic_bsd:00 00 00 0F 41 55 54 48 |....AUTH|
            2012-04-25 10:42:58.094608 : nsbasic_bsd:5F 50 52 4F 47 52 41 4D |_PROGRAM|
            2012-04-25 10:42:58.094630 : nsbasic_bsd:5F 4E 4D 0A 00 00 00 0A |_NM.....|
            2012-04-25 10:42:58.094652 : nsbasic_bsd:4D 41 50 31 39 30 2E 65 |MAP190.e|
            2012-04-25 10:42:58.094674 : nsbasic_bsd:78 65 00 00 00 00 0C 00 |xe......|
            2012-04-25 10:42:58.094696 : nsbasic_bsd:00 00 0C 41 55 54 48 5F |...AUTH_|
            2012-04-25 10:42:58.094718 : nsbasic_bsd:4D 41 43 48 49 4E 45 0C |MACHINE.|
            2012-04-25 10:42:58.094740 : nsbasic_bsd:00 00 00 0C 42 53 49 41 |....BSIA|
            2012-04-25 10:42:58.094762 : nsbasic_bsd:47 5C 42 53 49 32 34 32 |G\BSI242|
            2012-04-25 10:42:58.094783 : nsbasic_bsd:00 00 00 00 08 00 00 00 |........|
            2012-04-25 10:42:58.094806 : nsbasic_bsd:08 41 55 54 48 5F 50 49 |.AUTH_PI|
            2012-04-25 10:42:58.094827 : nsbasic_bsd:44 09 00 00 00 09 35 36 |D.....56|
            2012-04-25 10:42:58.094849 : nsbasic_bsd:36 30 3A 35 34 33 32 00 |60:5432.|
            2012-04-25 10:42:58.094871 : nsbasic_bsd:00 00 00 08 00 00 00 08 |........|
            2012-04-25 10:42:58.094893 : nsbasic_bsd:41 55 54 48 5F 53 49 44 |AUTH_SID|
            2012-04-25 10:42:58.094915 : nsbasic_bsd:03 00 00 00 03 61 73 63 |.....asc|
            2012-04-25 10:42:58.094937 : nsbasic_bsd:00 00 00 00 16 00 00 00 |........|
            2012-04-25 10:42:58.094959 : nsbasic_bsd:16 53 45 53 53 49 4F 4E |.SESSION|
            2012-04-25 10:42:58.094981 : nsbasic_bsd:5F 43 4C 49 45 4E 54 5F |_CLIENT_|
            2012-04-25 10:42:58.095003 : nsbasic_bsd:43 48 41 52 53 45 54 04 |CHARSET.|
            2012-04-25 10:42:58.095025 : nsbasic_bsd:00 00 00 04 31 30 30 30 |....1000|
            2012-04-25 10:42:58.095046 : nsbasic_bsd:00 00 00 00 17 00 00 00 |........|
            2012-04-25 10:42:58.095068 : nsbasic_bsd:17 53 45 53 53 49 4F 4E |.SESSION|
            2012-04-25 10:42:58.095090 : nsbasic_bsd:5F 43 4C 49 45 4E 54 5F |_CLIENT_|
            2012-04-25 10:42:58.095112 : nsbasic_bsd:4C 49 42 5F 54 59 50 45 |LIB_TYPE|
            2012-04-25 10:42:58.095134 : nsbasic_bsd:01 00 00 00 01 31 00 00 |.....1..|
            2012-04-25 10:42:58.095156 : nsbasic_bsd:00 00 1A 00 00 00 1A 53 |.......S|
            2012-04-25 10:42:58.095178 : nsbasic_bsd:45 53 53 49 4F 4E 5F 43 |ESSION_C|
            2012-04-25 10:42:58.095200 : nsbasic_bsd:4C 49 45 4E 54 5F 44 52 |LIENT_DR|
            2012-04-25 10:42:58.095222 : nsbasic_bsd:49 56 45 52 5F 4E 41 4D |IVER_NAM|
            2012-04-25 10:42:58.095244 : nsbasic_bsd:45 00 00 00 00 00 00 00 |E.......|
            2012-04-25 10:42:58.095265 : nsbasic_bsd:00 16 00 00 00 16 53 45 |......SE|
            2012-04-25 10:42:58.095287 : nsbasic_bsd:53 53 49 4F 4E 5F 43 4C |SSION_CL|
            2012-04-25 10:42:58.095309 : nsbasic_bsd:49 45 4E 54 5F 56 45 52 |IENT_VER|
            2012-04-25 10:42:58.095331 : nsbasic_bsd:53 49 4F 4E 09 00 00 00 |SION....|
            2012-04-25 10:42:58.095353 : nsbasic_bsd:09 31 38 36 36 34 37 32 |.1866472|
            2012-04-25 10:42:58.095375 : nsbasic_bsd:39 36 00 00 00 00 16 00 |96......|
            2012-04-25 10:42:58.095396 : nsbasic_bsd:00 00 16 53 45 53 53 49 |...SESSI|
            2012-04-25 10:42:58.095418 : nsbasic_bsd:4F 4E 5F 43 4C 49 45 4E |ON_CLIEN|
            2012-04-25 10:42:58.095441 : nsbasic_bsd:54 5F 4C 4F 42 41 54 54 |T_LOBATT|
            2012-04-25 10:42:58.095463 : nsbasic_bsd:52 01 00 00 00 01 31 00 |R.....1.|
            2012-04-25 10:42:58.095484 : nsbasic_bsd:00 00 00 08 00 00 00 08 |........|
            2012-04-25 10:42:58.095506 : nsbasic_bsd:41 55 54 48 5F 41 43 4C |AUTH_ACL|
            2012-04-25 10:42:58.095528 : nsbasic_bsd:04 00 00 00 04 34 34 30 |.....440|
            2012-04-25 10:42:58.095553 : nsbasic_bsd:30 00 00 00 00 12 00 00 |0.......|
            2012-04-25 10:42:58.095576 : nsbasic_bsd:00 12 41 55 54 48 5F 41 |..AUTH_A|
            2012-04-25 10:42:58.095598 : nsbasic_bsd:4C 54 45 52 5F 53 45 53 |LTER_SES|
            2012-04-25 10:42:58.095620 : nsbasic_bsd:53 49 4F 4E E2 01 00 00 |SION ...|
            2012-04-25 10:42:58.095642 : nsbasic_bsd:FE 40 41 4C 54 45 52 20 | @ALTER.|
            2012-04-25 10:42:58.095664 : nsbasic_bsd:53 45 53 53 49 4F 4E 20 |SESSION.|
            2012-04-25 10:42:58.095686 : nsbasic_bsd:53 45 54 20 4E 4C 53 5F |SET.NLS_|
            2012-04-25 10:42:58.095708 : nsbasic_bsd:4C 41 4E 47 55 41 47 45 |LANGUAGE|
            2012-04-25 10:42:58.095730 : nsbasic_bsd:3D 20 27 47 45 52 4D 41 |=.'GERMA|
            2012-04-25 10:42:58.095752 : nsbasic_bsd:4E 27 20 4E 4C 53 5F 54 |N'.NLS_T|
            2012-04-25 10:42:58.095774 : nsbasic_bsd:45 52 52 49 54 4F 52 59 |ERRITORY|
            2012-04-25 10:42:58.095796 : nsbasic_bsd:3D 20 27 47 45 52 4D 41 |=.'GERMA|
            2012-04-25 10:42:58.095818 : nsbasic_bsd:4E 59 40 27 20 4E 4C 53 |NY@'.NLS|
            2012-04-25 10:42:58.095840 : nsbasic_bsd:5F 43 55 52 52 45 4E 43 |_CURRENC|
            2012-04-25 10:42:58.095862 : nsbasic_bsd:59 3D 20 27 BF 27 20 4E |Y=.' '.N|
            2012-04-25 10:42:58.095884 : nsbasic_bsd:4C 53 5F 49 53 4F 5F 43 |LS_ISO_C|
            2012-04-25 10:42:58.095906 : nsbasic_bsd:55 52 52 45 4E 43 59 3D |URRENCY=|
            2012-04-25 10:42:58.095928 : nsbasic_bsd:20 27 47 45 52 4D 41 4E |.'GERMAN|
            2012-04-25 10:42:58.095950 : nsbasic_bsd:59 27 20 4E 4C 53 5F 4E |Y'.NLS_N|
            2012-04-25 10:42:58.095972 : nsbasic_bsd:55 4D 45 52 49 43 5F 43 |UMERIC_C|
            2012-04-25 10:42:58.095994 : nsbasic_bsd:48 41 52 40 41 43 54 45 |HAR@ACTE|
            2012-04-25 10:42:58.096016 : nsbasic_bsd:52 53 3D 20 27 2C 2E 27 |RS=.',.'|
            2012-04-25 10:42:58.096038 : nsbasic_bsd:20 4E 4C 53 5F 43 41 4C |.NLS_CAL|
            2012-04-25 10:42:58.096060 : nsbasic_bsd:45 4E 44 41 52 3D 20 27 |ENDAR=.'|
            2012-04-25 10:42:58.096082 : nsbasic_bsd:47 52 45 47 4F 52 49 41 |GREGORIA|
            2012-04-25 10:42:58.096104 : nsbasic_bsd:4E 27 20 4E 4C 53 5F 44 |N'.NLS_D|
            2012-04-25 10:42:58.096126 : nsbasic_bsd:41 54 45 5F 46 4F 52 4D |ATE_FORM|
            2012-04-25 10:42:58.096148 : nsbasic_bsd:41 54 3D 20 27 44 44 2E |AT=.'DD.|
            2012-04-25 10:42:58.096170 : nsbasic_bsd:4D 4D 2E 52 40 52 27 20 |MM.R@R'.|
            2012-04-25 10:42:58.096192 : nsbasic_bsd:4E 4C 53 5F 44 41 54 45 |NLS_DATE|
            2012-04-25 10:42:58.096214 : nsbasic_bsd:5F 4C 41 4E 47 55 41 47 |_LANGUAG|
            2012-04-25 10:42:58.096236 : nsbasic_bsd:45 3D 20 27 47 45 52 4D |E=.'GERM|
            2012-04-25 10:42:58.096258 : nsbasic_bsd:41 4E 27 20 4E 4C 53 5F |AN'.NLS_|
            2012-04-25 10:42:58.096280 : nsbasic_bsd:53 4F 52 54 3D 20 27 47 |SORT=.'G|
            2012-04-25 10:42:58.096302 : nsbasic_bsd:45 52 4D 41 4E 27 20 54 |ERMAN'.T|
            2012-04-25 10:42:58.096324 : nsbasic_bsd:49 4D 45 5F 5A 4F 4E 45 |IME_ZONE|
            2012-04-25 10:42:58.096346 : nsbasic_bsd:3D 20 27 2B 30 40 32 3A |=.'+0@2:|
            2012-04-25 10:42:58.096368 : nsbasic_bsd:30 30 27 20 4E 4C 53 5F |00'.NLS_|
            2012-04-25 10:42:58.096390 : nsbasic_bsd:43 4F 4D 50 3D 20 27 42 |COMP=.'B|
            2012-04-25 10:42:58.096412 : nsbasic_bsd:49 4E 41 52 59 27 20 4E |INARY'.N|
            2012-04-25 10:42:58.096435 : nsbasic_bsd:4C 53 5F 44 55 41 4C 5F |LS_DUAL_|
            2012-04-25 10:42:58.096457 : nsbasic_bsd:43 55 52 52 45 4E 43 59 |CURRENCY|
            2012-04-25 10:42:58.096479 : nsbasic_bsd:3D 20 27 BF 27 20 4E 4C |=.' '.NL|
            2012-04-25 10:42:58.096501 : nsbasic_bsd:53 5F 54 49 4D 45 5F 46 |S_TIME_F|
            2012-04-25 10:42:58.096523 : nsbasic_bsd:4F 52 4D 41 54 3D 40 20 |ORMAT=@.|
            2012-04-25 10:42:58.096545 : nsbasic_bsd:27 48 48 32 34 3A 4D 49 |'HH24:MI|
            2012-04-25 10:42:58.096567 : nsbasic_bsd:3A 53 53 58 46 46 27 20 |:SSXFF'.|
            2012-04-25 10:42:58.096589 : nsbasic_bsd:4E 4C 53 5F 54 49 4D 45 |NLS_TIME|
            2012-04-25 10:42:58.096611 : nsbasic_bsd:53 54 41 4D 50 5F 46 4F |STAMP_FO|
            2012-04-25 10:42:58.096633 : nsbasic_bsd:52 4D 41 54 3D 20 27 44 |RMAT=.'D|
            2012-04-25 10:42:58.096655 : nsbasic_bsd:44 2E 4D 4D 2E 52 52 20 |D.MM.RR.|
            2012-04-25 10:42:58.096676 : nsbasic_bsd:48 48 32 34 3A 4D 49 3A |HH24:MI:|
            2012-04-25 10:42:58.096742 : nsbasic_bsd:53 53 58 46 46 27 20 40 |SSXFF'.@|
            2012-04-25 10:42:58.096765 : nsbasic_bsd:4E 4C 53 5F 54 49 4D 45 |NLS_TIME|
            2012-04-25 10:42:58.096788 : nsbasic_bsd:5F 54 5A 5F 46 4F 52 4D |_TZ_FORM|
            2012-04-25 10:42:58.096810 : nsbasic_bsd:41 54 3D 20 27 48 48 32 |AT=.'HH2|
            2012-04-25 10:42:58.096832 : nsbasic_bsd:34 3A 4D 49 3A 53 53 58 |4:MI:SSX|
            2012-04-25 10:42:58.096854 : nsbasic_bsd:46 46 20 54 5A 52 27 20 |FF.TZR'.|
            2012-04-25 10:42:58.096876 : nsbasic_bsd:4E 4C 53 5F 54 49 4D 45 |NLS_TIME|
            2012-04-25 10:42:58.096898 : nsbasic_bsd:53 54 41 4D 50 5F 54 5A |STAMP_TZ|
            2012-04-25 10:42:58.096920 : nsbasic_bsd:5F 46 4F 52 4D 41 54 3D |_FORMAT=|
            2012-04-25 10:42:58.096942 : nsbasic_bsd:1E 20 27 44 44 2E 4D 4D |..'DD.MM|
            2012-04-25 10:42:58.096964 : nsbasic_bsd:2E 52 52 20 48 48 32 34 |.RR.HH24|
            2012-04-25 10:42:58.096986 : nsbasic_bsd:3A 4D 49 3A 53 53 58 46 |:MI:SSXF|
            2012-04-25 10:42:58.097008 : nsbasic_bsd:46 20 54 5A 52 27 00 00 |F.TZR'..|
            2012-04-25 10:42:58.097029 : nsbasic_bsd:00 00 00 00 17 00 00 00 |........|
            2012-04-25 10:42:58.097051 : nsbasic_bsd:17 41 55 54 48 5F 4C 4F |.AUTH_LO|
            2012-04-25 10:42:58.097073 : nsbasic_bsd:47 49 43 41 4C 5F 53 45 |GICAL_SE|
            2012-04-25 10:42:58.097095 : nsbasic_bsd:53 53 49 4F 4E 5F 49 44 |SSION_ID|
            2012-04-25 10:42:58.097117 : nsbasic_bsd:20 00 00 00 20 41 44 44 |.....ADD|
            2012-04-25 10:42:58.097139 : nsbasic_bsd:39 44 37 43 42 42 42 39 |9D7CBBB9|
            2012-04-25 10:42:58.097161 : nsbasic_bsd:42 34 38 38 37 42 38 35 |B4887B85|
            2012-04-25 10:42:58.097183 : nsbasic_bsd:38 38 35 42 38 33 32 30 |885B8320|
            2012-04-25 10:42:58.097205 : nsbasic_bsd:42 32 39 43 42 00 00 00 |B29CB...|
            2012-04-25 10:42:58.097227 : nsbasic_bsd:00 10 00 00 00 10 41 55 |......AU|
            2012-04-25 10:42:58.097249 : nsbasic_bsd:54 48 5F 46 41 49 4C 4F |TH_FAILO|
            2012-04-25 10:42:58.097271 : nsbasic_bsd:56 45 52 5F 49 44 00 00 |VER_ID..|
            2012-04-25 10:42:58.097292 : nsbasic_bsd:00 00 00 00 00 00 |...... |
            2012-04-25 10:42:58.097313 : nsbasic_bsd:exit (0)
            2012-04-25 10:42:58.097334 : nsbasic_brc:entry: oln/tot=0
            2012-04-25 10:42:58.097355 : nttfprd:entry
            2012-04-25 10:42:58.353896 : nttfprd:socket 1012 had bytes read=22
            2012-04-25 10:42:58.353943 : nttfprd:exit
            2012-04-25 10:42:58.353965 : nsbasic_brc:type=12, plen=11
            2012-04-25 10:42:58.353987 : nsbasic_brc:what=17, tot =22
            2012-04-25 10:42:58.354008 : nsbasic_brc:packet dump
            2012-04-25 10:42:58.354031 : nsbasic_brc:00 0B 00 00 0C 00 00 00 |........|
            2012-04-25 10:42:58.354053 : nsbasic_brc:01 00 01 |... |
            2012-04-25 10:42:58.354074 : nsbasic_brc:exit: oln=11, dln=1, tot=22, rc=0
            2012-04-25 10:42:58.354096 : nioqrc: found a break marker...
            2012-04-25 10:42:58.354117 : nioqrc: Recieve: returning error: 3111
            2012-04-25 10:42:58.354137 : nioqrc:exit

            ...

            2012-04-25 10:42:58.355752 : nserror:entry
            2012-04-25 10:42:58.355774 : nserror:nsres: id=0, op=77, ns=12630, ns2=0; nt[0]=0, nt[1]=0, nt[2]=0; ora[0]=0, ora[1]=0, ora[2]=0
            2012-04-25 10:42:58.355797 : nioqer:entry
            2012-04-25 10:42:58.355817 : nioqer: incoming err = 0
            2012-04-25 10:42:58.355837 : nioqce:entry
            2012-04-25 10:42:58.355857 : nioqce:exit
            2012-04-25 10:42:58.355877 : nioqer: returning err = 0
            2012-04-25 10:42:58.355897 : nioqer:exit
            2012-04-25 10:42:58.355917 : nioqrs:exit
            2012-04-25 10:42:58.355937 : nioqrc:entry
            2012-04-25 10:42:58.355958 : nsbasic_brc:entry: oln/tot=0
            2012-04-25 10:42:58.355979 : nttfprd:entry
            2012-04-25 10:42:58.595569 : nttfprd:socket 1012 had bytes read=128
            2012-04-25 10:42:58.595617 : nttfprd:exit
            2012-04-25 10:42:58.595640 : nsbasic_brc:type=6, plen=128
            2012-04-25 10:42:58.595662 : nsbasic_brc:what=1, tot =128
            2012-04-25 10:42:58.595683 : nsbasic_brc:packet dump
            2012-04-25 10:42:58.595706 : nsbasic_brc:00 80 00 00 06 00 00 00 |........|
            2012-04-25 10:42:58.595728 : nsbasic_brc:00 00 04 01 00 00 00 00 |........|
            2012-04-25 10:42:58.595751 : nsbasic_brc:00 00 00 00 00 F9 03 00 |..... ..|
            2012-04-25 10:42:58.595772 : nsbasic_brc:00 00 00 00 00 00 00 00 |........|
            2012-04-25 10:42:58.595794 : nsbasic_brc:00 00 00 00 00 00 00 00 |........|
            2012-04-25 10:42:58.595816 : nsbasic_brc:00 00 00 00 00 00 00 00 |........|
            2012-04-25 10:42:58.595845 : nsbasic_brc:00 00 00 00 00 00 00 03 |........|
            2012-04-25 10:42:58.595867 : nsbasic_brc:00 00 00 00 00 00 00 00 |........|
            2012-04-25 10:42:58.595889 : nsbasic_brc:00 00 00 00 00 00 00 00 |........|
            2012-04-25 10:42:58.595911 : nsbasic_brc:00 00 00 00 33 4F 52 41 |....3ORA|
            2012-04-25 10:42:58.595933 : nsbasic_brc:2D 30 31 30 31 37 3A 20 |-01017:.|
            2012-04-25 10:42:58.595955 : nsbasic_brc:69 6E 76 61 6C 69 64 20 |invalid.|
            2012-04-25 10:42:58.595977 : nsbasic_brc:75 73 65 72 6E 61 6D 65 |username|
            2012-04-25 10:42:58.595999 : nsbasic_brc:2F 70 61 73 73 77 6F 72 |/passwor|
            2012-04-25 10:42:58.596021 : nsbasic_brc:64 3B 20 6C 6F 67 6F 6E |d;.logon|
            2012-04-25 10:42:58.596043 : nsbasic_brc:20 64 65 6E 69 65 64 0A |.denied.|
            2012-04-25 10:42:58.596065 : nsbasic_brc:exit: oln=0, dln=118, tot=128, rc=0
            2012-04-25 10:42:58.596087 : nioqrc:exit
            2012-04-25 10:42:58.596521 : nioqds:entry
            2012-04-25 10:42:58.596545 : nioqds: disconnecting...
            2012-04-25 10:42:58.596567 : nsclose:entry

            ...

            The ns=12630 leads me to the following:

            ORA-12630: Native service operation not supported
            Cause: An operation requested by a user is not supported by the native services component.
            Action: This may be an internal error if the operation should have been supported.
            • 3. Re: invalid username/password; logon denied
              Alex Schroeder
              I was able to solve my problem!

              The developers had claimed that the username and password were hard coded into the application, but it turns out that it depended on the license key in use. On the main developer's laptop, the correct license key prevented the problem. Everybody else didn't know what was happening.

              How to discover the usernames used for failed logon attempts

              As a DBA, run:
              audit connect whenever not successful;

              In your init<SID>.ora file, make sure you have this line:
              audit_trail=db

              Restart the database (restart the service if on Windows).

              Attempt logons with correct and erroneous username/password combinations.

              As a DBA, run:
              select os_username, username, action_name, comment_text, returncode from dba_audit_trail where timestamp > sysdate - 1/24/4 order by timestamp;

              asc
              DEMO LOGON
              Authenticated by: DATABASE; Client address: (ADDRESS=(PROTOCOL=tcp)(HOST=xxx.xxx.xxx.xxx)(PORT=13389))
              1017

              As you can see, the application tried to connect using the username DEMO and got a 1017 error in return. I was expecting a different username.

              Problem solved!