Change Oracle SYS user Password

 . /opt/oracle/db/tech_st/19.3.0/prodcdb_erpdb.env

cd /opt/oracle/db/tech_st/19.3.0/dbs

cp orapwprodcdb orapwprodcdb.orig

mv orapwPROD orapwPROD.orig (File doesnot exists)

orapwd file=/opt/oracle/db/tech_st/19.3.0/dbs/orapwPROD password=manager123* entries=10 ignorecase=y

orapwd file=/opt/MG/oracle/PROD/db/tech_st/12.1.0/dbs/orapwPROD password=mikmanager entries=10 ignorecase=y

orapwd file=/opt/MG/oracle/PROD/db/tech_st/12.1.0/dbs/orapwTEST password=mikmanager entries=10 ignorecase=y

Now execute:

Connect Sqlplus / as sysdba

alter user sys identified by <password>

Bounce DB

If SYS user can connect with wrong password as well.

Edit sqlnet.ora file and add:

SQLNET.AUTHENTICATION_SERVICES=(NONE)

AutoPatch error: You must be in Maintenance Mode to apply patches.

Oracle R12.2 adop apply phase error out:

adop phase=apply 

AutoPatch error:

You must be in Maintenance Mode to apply patches.

You can use the AD Administration Utility to set Maintenance Mode.

Solution:

There should be one Service name which is CDBSID

SQL> show parameter service

NAME                                 TYPE        VALUE

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

service_names                        string      PROD, PROD_ebs_patch

SQL> alter system set service_names=prodcdb scope=both;

System altered.

SQL> show parameter service

NAME                                 TYPE        VALUE

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

service_names                        string      PRODCDB

ETCC not run in the database node

Below error while running adop phase=prepare

 [ERROR]     ETCC not run in the database node ip-172-31-27-116

                The EBS Technology Codelevel Checker needs to be run on the database node.

                It is available as Patch 17537119.

    Encountered the above errors when performing database validations.

    Resolve the above errors and restart adop.

Solution:

1. Execute  ./checkDBpatch.sh after downloaing ETCC patch 17537119 and placing in DB Oracle Home/appsutil/etcc

2. Check Node name should be same on all places:

txk_tcc_results

fnd_nodes

/etc/hosts

3. If nothing work insert below line based on your environment variables:

insert into txk_tcc_results

VALUES('120.0.12020000.60','120.0.12020000.56','ip-172-31-27-116','PROD','RDBMS','19.0.0.0.0.0','/opt/oracle/PROD/19.3.0',SYSDATE,'OK',NULL);

Re Test: adop phase=prepare should work now.

TAGS: adop phase=prepare, txk_tcc_results, fnd_nodes, ETCC

EPMINS-01087: Checking if the file exist and have read permissions: .../jre... Failed!

 EPMINS-01087: Checking if the file exist and have read permissions: .../jre... Failed!

There is a problem with your environment because the Application Express files have not been loaded

Error:

Executing APEX 21.1  URL Below error is appearing

There is a problem with your environment because the Application Express files have not been loaded. Please verify that you have copied the images directory to your application server as instructed in the Installation Guide. In addition, please verify that your image prefix path is correct. Your current path is <Images Folder> (it should contain both starting and ending forward slashes, such as the default /i/). Use the SQL script reset_image_prefix.sql if you need to change it.

Solution:

Use rest_image_prefix.sql script to reset the images folder.

edit ords.properties file and fix the imags folder path.

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