Wednesday 26 October 2022

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


Wednesday 19 October 2022

Wednesday 12 October 2022

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.

Tuesday 11 October 2022

adapcctl.sh: exiting with status 204

 adapcctl.sh: exiting with status 204

Solution:
Stop All services
Rollback patch: 32287205
Start All Services