Oracle Database 19c ORA-28040 no matching authentication protocol from Toad

 Oracle Database 19c ORA-28040 no matching authentication protocol Error while connecting to TOAD etc.

Solution:

The problem is with Toad. 

Download latest SQL Developer and you will not see this issue there.

adapcctl.sh: exiting with status 204

 adapcctl.sh: exiting with status 204

Solution:

Stop All services

Rollback patch: 32287205

Start All Services

ERROR: The following required ports are in use

 Lines #(432-436):

Validating if ports listed in PATCH file system context file are free or occupied

 Checking  Node Manager Port on gglit:  Port Value = 5557

RC-50204: Error: - Node Manager Port in use: Port Value = 5557

 Checking  WLS Admin Server Port on gglit:  Port Value = 7002

   WLS Admin Server Port available:  Port Value = 7002

Lines #(476-480):

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

ERROR: The following required ports are in use:

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

5557 : Node Manager Port

/opt/oracle/TEST/fs_ne/EBSapps/log/adop/105/20221010_171032/fs_clone/validate/gglit/txkADOPValidations.log: 

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

Lines #(27-31):

[WARNING]: There could be issues while validating the ports used for E-Business Suite instance against ports used in /etc/services. Refer the log file for more details.

ValidatePatchFSPortPool:

[ERROR]: Some of the ports specified for the patch file system are not available.

ValidateETCHosts:

[SUCCESS]: All required entries exist in /etc/hosts.

/opt/oracle/TEST/fs_ne/EBSapps/log/adop/105/20221010_171032/adop.log: 

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

Lines #(85-90):

    [PROCEDURE] Calling: /opt/oracle/TEST/fs1/EBSapps/appl/ad/12.0.0/patch/115/bin/txkADOPValidations.pl

    [EVENT]     Log: /opt/oracle/TEST/fs_ne/EBSapps/log/adop/105/20221010_171032/fs_clone/validate/gglit

    [UNEXPECTED]Error occurred running "perl /opt/oracle/TEST/fs1/EBSapps/appl/ad/12.0.0/patch/115/bin/txkADOPValidations.pl  -contextfile=/opt/oracle/TEST/fs1/inst/apps/IT_gglit/appl/admin/IT_gglit.xml -patchctxfile=/opt/oracle/TEST/fs2/inst/apps/IT_gglit/appl/admin/IT_gglit.xml -phase=fs_clone -logloc=/opt/oracle/TEST/fs_ne/EBSapps/log/adop/105/20221010_171032/fs_clone/validate/gglit -promptmsg=hide"

    [UNEXPECTED]Error 1 occurred while Executing txkADOPValidation script on gglit

    [STATEMENT] Deleting row from ad_adop_defaults for failed session_id = 105

[PROCEDURE] [START 2022/10/10 17:12:15] Unlocking sessions table

Soluiton:

From the patch file system stop Admin Server and Node Manager

Set Patch FS

cd $ADMIN_SCRIPTS_HOME

sh adadminsrvctl.sh stop forcepatchfs

sh adnodemgrctl.sh stop forcepatchfs

Retry

EBS R12.2.10 Upgrade Patch Errors

 EBS R12.2.10 Upgrade Patch Errors

csdrtype.ldt Worker Failed

FNDFFVGN Worker Failed

Linux Change Mount Point Name

Let us change /mnt to /opt  on Linux 7.9

Rename the folder if it already exist.

[root@ip-172-31-27-116 opt]# mv opt optt

[root@ip-172-31-27-116 opt]# mount -l

Identify the volume information of existing mount point

[root@ip-172-31-27-116 opt]# ps -ef |grep mnt

Make sure no process is using. Either kill or restart OS

[root@ip-172-31-27-116 opt]# umount /mnt

Un mount the existing mount point which we need to rename

[root@ip-172-31-27-116 opt]# mkdir opt

Create the folder for our new mount point

[root@ip-172-31-27-116 opt]# mount /dev/nvme2n1 /opt

[root@ip-172-31-27-116 opt]# mount -l

[root@ip-172-31-27-116 opt]# cat /etc/fstab

[root@ip-172-31-27-116 opt]# vi /etc/fstab

[root@ip-172-31-27-116 opt]# mount -l

[root@ip-172-31-27-116 opt]# reboot

FDPSTP failed due to ORA-20100: ORA-20100: Temporary file creation for FND_FILE failed.

After upgrade to EBS R12.2.10 and Databse to 19c. Custom Concurrent Requests error out with below log/output:

[21-SEP-2022 14:59:38]: **Starts**

[21-SEP-2022 15:00:45]: **SQL error and free**

[21-SEP-2022 15:00:45]: ORACLE error 20100 in FDPSTP

Cause: FDPSTP failed due to ORA-20100: ORA-20100: Temporary file creation for FND_FILE failed.

Directory &FILE_DIR is invalid, contact your system administrator.

Action: Check that the directory is a valid directory with wri

+---------------------------------------------------------------------------+

Start of log messages from FND_FILE

+---------------------------------------------------------------------------+

+---------------------------------------------------------------------------+

End of log messages from FND_FILE

+---------------------------------------------------------------------------+

+---------------------------------------------------------------------------+

No completion options were requested.

Output file size: 

0

Deleting empty output file.

+---------------------------------------------------------------------------+

APP-FND-01388: Cannot read value for profile option CONC_KEEP_BLANK_FILES in routine &ROUTINE.

Concurrent request completed

Current system time is 21-SEP-2022 15:00:45

+---------------------------------------------------------------------------+

FAILED: file adinvset.pls on worker 1

 adadmin Shows:

ATTENTION: All workers either have failed or are waiting:

   FAILED: file adinvset.pls on worker  1.

ATTENTION: Please fix the above failed worker(s) so the manager can continue.

    Fixed: file adinvset.pls on worker  1 for product ad  username APPLSYS.

   FAILED: file adinvset.pls on worker  1 for product ad  username APPLSYS.

There are now 65 jobs remaining (current phase=iv_setup):

    0 running, 0 ready to run and 65 waiting.

adctrl says:

Worker  Code      Context            Filename                    Status

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

     1  Run       Invoker R120       adinvset.pls                FAILED        

Solution:

SELECT owner, object_name 

FROM all_objects

WHERE  object_name= 'APPS_ARRAY_DDL'

AND object_type = 'PACKAGE'

AND status = 'INVALID';

alter package asg.apps_array_ddl compile;

Restasrt Failed Worker