Register Login

ORA-01017: invalid username/password; logon denied

Updated Jun 25, 2018

I run sapdba_role.sql with command :
sqlplus/nolog
@sapdba_role SAPDBN: DBN NT
but on the log file :
Connected.
PL/SQL procedure successfully completed.
old 15: if `&&2` = `UNIX` then
new 15: if `DBN` = `UNIX` then
declare
ERROR at line 1:
ORA-01918: user `SAPR3` does not exist
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) The system cannot find the file specified.
ORA-06512: at "SYS.DBMS_SYS_SQL", line 826
ORA-06512: at "SYS.DBMS_SQL", line 32
ORA-06512: at line 113 

Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.

ERROR:
ORA-01017: invalid username/password; logon denied

Warning: You are no longer connected to ORACLE.
SP2-0640: Not connected
SP2-0640: Not connected
SP2-0640: Not connected
SP2-0640: Not connected
SP2-0640: Not connected
SP2-0640: Not connected
SP2-0640: Not connected
SP2-0640: Not connected
SP2-0640: Not connected
SP2-0640: Not connected
SP2-0640: Not connected
SP2-0640: Not connected
SP2-0640: Not connected
SP2-0640: Not connected
SP2-0640: Not connected
SP2-0640: Not connected
SP2-0640: Not connected
SP2-0640: Not connected
SP2-0640: Not connected
SP2-0640: Not connected
SP2-0640: Not connected
SP2-0640: Not connected
SP2-0640: Not connected
SP2-0640: Not connected
SP2-0640: Not connected
SP2-0640: Not connected
SP2-0640: Not connected
SP2-0640: Not connected
SP2-0640: Not connected
SP2-0640: Not connected
SP2-0640: Not connected
SP2-0640: Not connected
SP2-0640: Not connected
SP2-0640: Not connected
SP2-0640: Not connected
SP2-0640: Not connected
SP2-0640: Not connected
SP2-0640: Not connected
SP2-0640: Not connected
Connected.

PL/SQL procedure successfully completed.
for info SID : DBN
what does it mean?

check the access rights of the backup directories (log, etc.)
Dear all,
I execute DB13 to schedule my backup online.
and the job was succesfull with warning.
in the log file i found :
BR301W SQL error -1031 at location BrLicCheck-7
ORA-01031: insufficient privilages

Does anyone know to correct this problem?


"You come to love not by finding the perfect person, but by seeing an imperfect person perfectly. "
With lotsa luv and fun
Venkatesh Bye for now... Take Care...


 


 

 


Comments

  • 13 Apr 2009 1:44 pm Guest

    Hi Kumar,

    Run transaction SNOTE with note number 695859

    Hi all,
    Whenever i used the T-code DB02 it goes program Termination error.
    The error Message is :
    ABAP runtime errors DBIF_DSQL2_SQL_ERROR
    SQL error 207 occured when excuting EXEC SQL
    The error occured in the current database connection "DEFAULT"
    Please look in to this and let me know,

    By,
    saran

     

     

  • 13 Apr 2009 1:44 pm Guest

    Hi all,

    Whenever i used the T-code DB02 it goes program Termination error.
     
    The error Message is :
     
        ABAP runtime errors      DBIF_DSQL2_SQL_ERROR
      
       SQL error 207 occured when excuting EXEC SQL
     
    The error occured in the current database connection "DEFAULT"
     
    Please look in to this and let me know,


×