In PROD server (AIX), using an admin account, I have executed the script below to generate the control.sql and control.trc files:
./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
Changes
Database has been upgraded from 11g to 18c
Cause
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.