The Oracle DBA's

Receiving error: Application is getting below error post up gradation while trying to connect to DB ORA-28040: No matching authentication protocol Cause: It might want you to upgrade the JDBC version. Resolution: You may  align one parameter mentioned below in sqlnet.ora file:   sqlnet.allowed_logon_version_server=8   (A setting of 8 permits most password versions, and allows any combination of the dba_users.password_versions values 10g, 11g, and 12c.) OR you update your JDBC version and try to connect again. Thanks & Regards Nikhil Kumar.

Issue: While importing from 11.2.0.4 to 12.2.0.1 DB: ORA-39083: Object type REF_CONSTRAINT:"TEST"."TK_COD_TYPE" failed to create with error: ORA-02298: cannot validate (TEST.TK_COD_TYPE) - parent keys not found Failing sql is: ALTER TABLE "TEST"."CODE" ADD CONSTRAINT "TK_COD_TYPE" FOREIGN KEY ("TYPE") REFERENCES "TEST"."CODEAREA" ("CODEAREA") ENABLE ORA-39083: Object type REF_CONSTRAINT:"TEST"."TK_PDE_RPP_ID" failed to create with error: ORA-02298: cannot validate (TEST.TK_PDE_RPP_ID) - parent keys not found Failing sql is: ALTER TABLE "TEST"."PDE_RPP_RPT_PARAM" ADD CONSTRAINT "TK_PDE_RPP_ID" FOREIGN KEY ("RPT_ID") REFERENCES "TEST"."RPT_REPORT" ("RPT_ID") ENABLE ORA-39083: Object type REF_CONSTRAINT:"TEST"."TK_COD_TYPE" failed to create with error: ORA-02298: cannot vali...

change account status from expired to open: SQL> select username,account_status from dba_users where account_status='EXPIRED'; USERNAME       ACCOUNT_STATUS ------------- -----------------   AUTO_CATT8     EXPIRED SQL> set long 9999999 SQL> set pages 333 lines 222 SQL> select dbms_metadata.get_ddl('USER','AUTO_CATT8') from dual; DBMS_METADATA.GET_DDL('USER','AUTO_CATT8') -------------------------------------------------------------------------------- CREATE USER "AUTO_CATT8" IDENTIFIED BY VALUES 'S:54C1468D29B1759BEF943066549E 4A6583425459428A27280143EEA3872266D9;T:BEC38C394DD6D61E87D51FD0E9C1685C949C8B9CA2F32 DB3626C7F16DE927C91D95FBB0F358AEA2100B5E8251F60C331B6173EAC91530BF3BF0EE84ECF9AB C3486A6D17F81BF2848F33AA7FE97BB0704'       DEFAULT TABLESPACE "AUTOMATION"       TEMPORARY TABLESPACE "TEMP"       PASSWORD EXPIRE SQL> alter USER "AUTO_CATT8" IDENTIFIED BY...

Create database link: CREATE  DATABASE LINK TESTROD_AUTO  CONNECT TO USERNAME IDENTIFIED BY PASSWORD   USING {Either service name from tns entry or lsitener address description}; Thanks & Regards Nikhil Kumar.

[oracle@Testing 30593149]$ opatch apply Oracle Interim Patch Installer version 12.2.0.1.17 Copyright (c) 2020, Oracle Corporation.  All rights reserved. Oracle Home       : /Test/oracle/product/12.2.0/dbhome_1 Central Inventory : /Test/oraInventory    from           : /Test/oracle/product/12.2.0/dbhome_1/oraInst.loc OPatch version    : 12.2.0.1.17 OUI version       : 12.2.0.1.4 Log file location : /Test/oracle/product/12.2.0/dbhome_1/cfgtoollogs/opatch/opatch2020-05-17_11-46-41AM_1.log Verifying environment and performing prerequisite checks... -------------------------------------------------------------------------------- Start OOP by Prereq process. Launch OOP... /Test/oracle/product/12.2.0/dbhome_1/OPatch/opatch: line 1397: /tmp/oracle-home-1589696209088388/OPatch/opatch: Permission denied /Test/oracle/product/12.2.0/dbhome_1/OPatch/opatch: line 1397: exec: /tmp/ora...

[oracle@Testing02 OPatch]$ ./datapatch -verbose SQL Patching tool version 12.2.0.1.0 Production on Fri May 15 15:54:19 2020 Copyright (c) 2012, 2019, Oracle.  All rights reserved. Log file for this invocation: /testing/app/oracle/cfgtoollogs/sqlpatch/sqlpatch_29313_2020_05_15_15_54_19/sqlpatch_invocation.log Connecting to database...OK Bootstrapping registry and package to current versions...done Queryable inventory could not determine the current opatch status. Execute 'select dbms_sqlpatch.verify_queryable_inventory from dual' and/or check the invocation log /testing/app/oracle/cfgtoollogs/sqlpatch/sqlpatch_29313_2020_05_15_15_54_19/sqlpatch_invocation.log for the complete error. Prereq check failed, exiting without installing any patches. Please refer to MOS Note 1609718.1 and/or the invocation log /testing/app/oracle/cfgtoollogs/sqlpatch/sqlpatch_29313_2020_05_15_15_54_19/sqlpatch_invocation.log for information on how to resolve the above errors. SQL...

OPatch found the word "error" in the stderr of the make command. Please look at this stderr. You can re-run this make command. Stderr output: chmod: changing permissions of ‘/testing/app/oracle/product/12.2.0/testing_1/bin/extjobO’: Operation not permitted make: [iextjob] Error 1 (ignored) Statement: This warning is ignorable, as files in bin directory ending with "O" are backups that are created when (re-)linking and it is owned by root hence, changing permission could not be performed. [oracle@Testing02 30593149]$ ll /testing/app/oracle/product/12.2.0/testing_1/bin/extjobO -rwsr-x--- 1 root oinstall 2241432 Nov 18 04:58 /testing/app/oracle/product/12.2.0/testing_1/bin/extjobO