6 Replies Latest reply: Jan 17, 2013 11:54 PM by Swapnil K RSS

    ORA-01017: invalid username/password; logon denied

    Swapnil K
      Hi all,

      I am trying to execute a host script in Oracle application EBSR12 and I am getting following error as below :-

      Oracle error
      ORA-01017: invalid username/password; logon denied

      On googling I found out following causes to this error. CAN ANYONE PLEASE EXPLAIN WHAT THIS IS AND WHY IS IT OCCURING IN A DESCRIPTIVE WAY?

      The core issue with an ORA-01017 error is an invalid user ID and passwords combination, but other than an incorrect password, there are user ID issues that may contribute to the ORA-01017 error:

      It may be that the user ID is invalid for the target system - The user ID exists as the username column in the dba_users view.

      select username from dba_users;


      Check your $ORACLE_SID environmental parameter. If your $ORACLE_SID is set to the wrong system ID then you may get a ORA-01017 error because you are connecting to the wrong database.


      If using external OS user authentication (ops$ or remote_os_authent) you need to verify that the user ID is valid. You can tell if you are using external authentication because you connect without providing a user/password combination, and only provide a forward slash to the connect string, (e.g. connect / as sysdba;).

      Check your tnsnames.ora to ensure that the TNS service name points to the correct server and instance name. If you specify an incorrect tnsnames.ora service name, then the user ID and password may not exist in that database.
        • 1. Re: ORA-01017: invalid username/password; logon denied
          Srini Chavali-Oracle
          Pl post details of OS, database and EBS version, along with the contents of the concurrent log. Can you post the contents of the host script ?

          HTH
          Srini
          • 2. Re: ORA-01017: invalid username/password; logon denied
            Hussein Sawwan-Oracle
            I am trying to execute a host script in Oracle application EBSR12 and I am getting following error as below :-
            Have you completed the steps in these docs?

            How to Register a Host Concurrent Program in Applications [ID 156636.1]
            How To Setup A Custom Concurrent Host Program [ID 147455.1]
            How To Run Shellscripts as Concurrent Jobs in Release 10 [ID 29086.1]
            How Do You Run A Unix Host Script From Concurrent Managers On MS Windows Platform? [ID 412392.1]

            Thanks,
            Hussein
            • 4. Re: ORA-01017: invalid username/password; logon denied
              Srini Chavali-Oracle
              Swapnil M Kapote wrote:
              Hi Srini,

              OS - Windows7
              EBS - R12.1.3
              Database - 11g
              Win 7 is not a certified platform for installing EBS.

              >
              Following are the contents of concurrent log.

              Oracle error
              ORA-01017: invalid username/password; logon denied

              in "..."
              on line 0 of .

              /home/SSMY1/apps/apps_st/appl/fxitss/ssont/12.0.0/bin/SS_ALC_FILE_DAEMON
              Program exited with status 1


              ---------------------------------------------------------------------------
              Executing request completion options...

              Output file size:
              0


              Output is not being printed because:
              The print option has been disabled for this report.


              Following are the details of host script :-


              /* Result Sets Interface */
              #ifndef SQL_CRSR
              # define SQL_CRSR
              struct sql_cursor
              {
              unsigned int curocn;
              void *ptr1;
              void *ptr2;
              unsigned int magic;
              };
              typedef struct sql_cursor sql_cursor;
              typedef struct sql_cursor SQL_CURSOR;
              #endif /* SQL_CRSR */
              ........................<snip>...............................
              /* [002] Start */
              int IsDir( char *dirLoc )
              {
                   struct stat sbuf;
                   if(     stat(     dirLoc,     &sbuf     ) == -1     )
                        return(0);
                   if(     S_ISDIR( sbuf.st_mode )     )
                        return(1);
                   else
                        return(0);
              }
              /* [002] End */

              This is not a host program - a host program is a OS shell script. This looks like C code - you will need to correct the registration of this concurrent program to indicate that it is so.
              I am not getting this issue in my previous test instance. But when i run the same file i get the above error. Please tell me possible causes of this.
              Pl identify how this was registered in your test instance.
              Thanks
              Swapnil.

              Edited by: Swapnil M Kapote on Jul 23, 2012 11:35 AM
              HTH
              Srini
              • 5. Re: ORA-01017: invalid username/password; logon denied
                Hussein Sawwan-Oracle
                OS - Windows7
                EBS - R12.1.3
                Database - 11g


                Following are the contents of concurrent log.

                Oracle error
                ORA-01017: invalid username/password; logon denied
                I believe the OS version has nothing to do with the ORA-01017 error you get.
                in "..."
                on line 0 of .

                /home/SSMY1/apps/apps_st/appl/fxitss/ssont/12.0.0/bin/SS_ALC_FILE_DAEMON
                Program exited with status 1
                How was "SS_ALC_FILE_DAEMON" created?

                Have you completed the steps in the docs referenced in my previous reply?

                Thanks,
                Hussein
                • 6. Re: ORA-01017: invalid username/password; logon denied
                  Swapnil K
                  ...

                  Edited by: Swapnil M Kapote on Jan 18, 2013 11:24 AM