APEX ADMIN account locked for workspace INTERNAL - password change procedure

 If APEX ADMIN account has locked  for INTERNAL workspace or need to change the password, use the following procedure, please test it first and do the necessary backups first.

INTERNAL Admin password change

==============================

login with sys as sysdba to the APEX database

SQL> show pdbs

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED

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

         2 PDB$SEED                       READ ONLY  NO

         3 APEXUAT                          READ WRITE NO

SQL> alter session set container=APEXUAT;

Session altered.

SQL>

SQL>

SQL> @apxchpwd.sql

...set_appun.sql

================================================================================

This script can be used to change the password of an Oracle APEX

instance administrator. If the user does not yet exist, a user record will be

created.

================================================================================

Enter the administrator's username [ADMIN]

User "ADMIN" exists.

Enter ADMIN's email [apexadmin@testlab.com]

Enter ADMIN's password []

Changed password of instance administrator ADMIN.

- test the login with ADMIN account for INTERNAL workspace

Oracle EBS Cloud manager deployment on OCI

 Please follow the Oracle support document.

Deploying Oracle E-Business Suite Cloud Manager Version 20.1.1.X on Oracle Cloud Infrastructure (Doc ID 2434500.1)

OCI APPS R12.2.8 - adstrtal.sh: exiting with status 1 - adstrtal.sh: Database connection could not be established

Introduction:

After stopping the APPS tier services and database tier services, got the following errors while starting up the APPS Tier services post database services.

 [oracle@test_oracle_cloud_app1 scripts]$ adstrtal.sh

You are running adstrtal.sh version 20.24.12020

Enter the APPS username: apps

Enter the APPS password:

Enter the WebLogic Server password:

adstrtal.sh: Database connection could not be established. Either the database is down or the APPS credentials supplied are wrong.

USAGE:  adstrtal.sh <appsusername/appspassword> [-nothreading]

        adstrtal.sh <applications_username/applications_password> -secureapps

        adstrtal.sh -nodbchk

        adstrtal.sh -mode=allnodes

        adstrtal.sh -msimode

adstrtal.sh: exiting with status 1

Resolution:

Issue is not related to do any thing with apps user password or any of the listener on APPS Tier or database tier.

The issue is related to one of the ERP Service which did not startup with the database start.

Check the services

select name,network_name from v$services;

select SERVICE_ID,NAME from dba_services;

login to the PDB of APPS 

show pdbs;

show con_name;

Alter session set container=APPS_DB_PDB_NAME;

start the required services, in our case it was ebs_ERPTEST

 

SQL> exec dbms_service.start_service(service_name=>'ebs_ERPTEST');

 

PL/SQL procedure successfully completed.

now start the APPS Tier services.

If you are not sure about the APPS Service, check the alert log and grep with ":Started" and start the service with the above procedure.

How to deploy Oracle EBS Cloud Manager on Oracle Cloud

 Please follow the Oracle support document

Deploying Oracle E-Business Suite Cloud Manager Version 20.1.1.X on Oracle Cloud Infrastructure (Doc ID 2434500.1)

Cloning an Oracle Base Database Service 19c DB System for Oracle E-Business Suite Release 12.2 on Oracle Cloud

 Introduction:

To clone the Oracle Base Database Service 19c DB system on Oracle cloud , check the following Oracle support doc.

Cloning an Oracle Base Database Service 19c DB System for Oracle E-Business Suite Release 12.2

(Doc ID 2800199.1)

Oracle Cloud - Cloning of Oracle EBS R12.2 Application Tier on OCI

Introduction:

How to clone Oracle EBS R12.2 APPS tier on Oracle Cloud.

Resolution:

Please follow the Oracle support document (Doc ID 2912000.1)

Cloning the Oracle E-Business Suite Release 12.2 Application Tier on 

Oracle Cloud Infrastructure Compute (Doc ID 2912000.1)

Lock the OCI Oracle cloud linux OS user

 Introduction:

Some times there is requirement not to delete the OS user but to lock it. Following can be followed to lock the user account on OCI Oracle cloud.

Resolution:

[root@oraclecloudlinuxserver ~]# passwd -l username

Locking password for user username.

passwd: Success