urlscan.io logo urlscan.io
SecurityTrails logo

www.nazmulhuda.info Open in urlscan Pro
2a00:1450:4001:82a::2013  Public Scan

Back to summary
Submitted URL: http://www.nazmulhuda.info/ora-01017-invalid-usernamepassword-logon-denied-using-database-link
Effective URL: https://www.nazmulhuda.info/ora-01017-invalid-usernamepassword-logon-denied-using-database-link
Submission: On July 12 via manual from IN — Scanned from DE

Form analysis 0 forms found in the DOM

Text Content

Auf dieser Website suchen





Zum Hauptinhalt springen

Zur Navigation springen

Mohammad Nazmul Huda
 * About Me
 * Certifications
 * Publications
 * Training
 * 
   Technical Docs
    * 
      Oracle
       * Managing Database
       * Cloud Control
       * Backup and Recovery
       * Performance Tuning
       * SQL Functions
       * Database Change
       * Replication
       * ASM
       * BACKUP AND RECOVERY
       * 12c Issues
       * RMAN
       * Data Guard
       * Bugs
       * LISTENER
       * OCM
       * ORA ERROR
       * SQL
       * PL/SQL
       * Parameters
       * Scripts
       * Security
       * Tools
       * Database Backup
   
    * SQL SERVER
    * Teradata
    * MySQL
    * Azure SQL Database
    * PostgreSQL
    * Linux
    * AWS
    * Data Science

 * Other
 * Contact

Mohammad Nazmul Huda





ORA-01017 : INVALID USERNAME/PASSWORD; LOGON DENIED (USING DATABASE LINK)



SQL> create database link test_link connect to scott identified by tiger using
'Test';



SQL> select * from dual@test_link;



ORA-01017: invalid username/password; logon denied

ORA-02063: preceding line from VODCMS



Reason:

Case sensitive logon enabled in target database.

Check in target database:

SQL> show parameter sec_case_sensitive_logon;



NAME TYPE VALUE

------------------------------ ---------------------------------
------------------------------

sec_case_sensitive_logon boolean TRUE



How to fix:

SQL> create database link test_link connect to "scott" identified by "tiger"
using 'Test';




Seite aktualisiert
Google Sites
Missbrauch melden
Diese Website verwendet Cookies von Google, um ihre Dienste bereitzustellen und
Zugriffe zu analysieren. Informationen darüber, wie Sie die Website verwenden,
werden an Google weitergegeben. Durch die Nutzung dieser Website erklären Sie
sich damit einverstanden, dass auf der Website Cookies verwendet werden.
Weitere Informationen
Ok