use the following command
first export the cert into .p7b with full chain
and after that use the following command to change the .p7b to .cer (PEM) format, openssl can be used on any linux box.
openssl pkcs7 -inform DER -outform PEM -in erpdummy-full-chain.p7b -print_certs > erpdummy.cer
Using Load Balancers with Oracle E-Business Suite Release 12.2
Please check the Oracle support (Doc ID 1375686.1)
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
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)
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
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.
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)
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)
use the following command first export the cert into .p7b with full chain and after that use the following command to change the .p7b to ....
