This discussion is archived
6 Replies Latest reply: Jan 17, 2013 9:54 PM by Swapnil K RSS

ORA-01017: invalid username/password; logon denied

Swapnil K Newbie
Currently Being Moderated
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 Oracle ACE Director
    Currently Being Moderated
    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 Employee ACE
    Currently Being Moderated
    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 Oracle ACE Director
    Currently Being Moderated
    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 Employee ACE
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    ...

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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points