Lỗi ora-01017 invalid username password logon denied năm 2024

Question

In PROD server (AIX), using an admin account, I have executed the script below to generate the control.sql and control.trc files:

Nội dung chính Show

Applies to:
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!

./ora_br_copy.sh -generateFiles -targetSid WEQ -password mypassword listenerPort 1521

But the script returned me with an error ORA-01017.

+ /usr/java14_64/bin/java -showversion -cp ./.:./orabrcopy.jar:/oracle/WEP/102_64/jdbc/lib/classes12.jar com.sap.inst.lib.app.SecureStartup com.sap.inst.orabrcopy.OraBRCopy -oracleHome /oracle/WEP/102_64 -sourceSid WEP -generateFiles -targetSid WEQ -password mypassword listenerPort 1521

What versions are you using?

platform.platform: Darwin-20.6.0-x86_64-i386-64bit

sys.maxsize > 2**32: True

platform.python_version: 3.7.13

oracledb.version: 1.0.1

Database Version: 12.1.0.2.0

Is it an error or a hang or a crash? Crash (error)
What error(s) or behavior you are seeing?


# test-2.py
import oracledb
import os
un = os.environ.get('USER_NAME')
pw = os.environ.get('PASSWORD')
cs = os.environ.get('CONNECT_STRING')
oracledb.init_oracle_client()
with oracledb.connect(user=un, password=pw, dsn=cs) as connection:
   with connection.cursor() as cursor:
      sql = """select version
               from   v$instance"""
      for r in cursor.execute(sql):
         print(r)

python test-2.py ('12.1.0.2.0',)


# test-2.py
import oracledb
import os
un = os.environ.get('USER_NAME')
pw = os.environ.get('PASSWORD')
cs = os.environ.get('CONNECT_STRING')

# oracledb.init_oracle_client()
with oracledb.connect(user=un, password=pw, dsn=cs) as connection:
   with connection.cursor() as cursor:
      sql = """select version
               from   v$instance"""
      for r in cursor.execute(sql):
         print(r)

python test-2.py Traceback (most recent call last): File "test-2.py", line 10, in with oracledb.connect(user=un, password=pw, dsn=cs) as connection: File "/Users/asrajag/miniconda3/envs/oracle/lib/python3.7/site-packages/oracledb/connection.py", line 1000, in connect return conn_class(dsn=dsn, pool=pool, params=params, **kwargs) File "/Users/asrajag/miniconda3/envs/oracle/lib/python3.7/site-packages/oracledb/connection.py", line 128, in init impl.connect(params_impl) File "src/oracledb/impl/thin/connection.pyx", line 345, in oracledb.thin_impl.ThinConnImpl.connect File "src/oracledb/impl/thin/connection.pyx", line 163, in oracledb.thin_impl.ThinConnImpl._connect_with_params File "src/oracledb/impl/thin/connection.pyx", line 129, in oracledb.thin_impl.ThinConnImpl._connect_with_description File "src/oracledb/impl/thin/connection.pyx", line 250, in oracledb.thin_impl.ThinConnImpl._connect_with_address File "src/oracledb/impl/thin/protocol.pyx", line 205, in oracledb.thin_impl.Protocol._connect_phase_two File "src/oracledb/impl/thin/protocol.pyx", line 296, in oracledb.thin_impl.Protocol._process_message oracledb.exceptions.DatabaseError: ORA-01017: invalid username/password; logon denied

Does your application call init_oracle_client()?

Thick mode works, thin mode does not. 5. Include a runnable Python script that shows the problem.


# test-2.py
import oracledb
import os
un = os.environ.get('USER_NAME')
pw = os.environ.get('PASSWORD')
cs = os.environ.get('CONNECT_STRING')

# oracledb.init_oracle_client()
with oracledb.connect(user=un, password=pw, dsn=cs) as connection:
   with connection.cursor() as cursor:
      sql = """select version
               from   v$instance"""
      for r in cursor.execute(sql):
         print(r)

Last updated on MARCH 06, 2023

Applies to:

Oracle Unified Directory - Version 11.1.2.3.0 and later Information in this document applies to any platform.

Symptoms

On : 11.1.2.3.0 version, EUS

Problems while getting OUD 11.1.2.3.0 to work with Oracle DB 18

Upgraded database from 11g to 18c.

Configuring EUS with the new DB in the following process:

- created a wallet via dbca - created a mapping to a global user inside the LDAP server via eusm - updated OUD to the patch 28355703 (unique Patch ID: 22376567).

sqlplus login with EUS user fails with: Login denied: Invalid username/password

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

DB trace file shows:

KZLD_ERR: failed the search 28304. KZLD_ERR: 28304