APPSDBA Data Lake

  Overview OPMN will log the following errors when attempting to start the patched opmn process with a default MD5withRSA signed certificate: [opmn] [ERROR:1] [] [ons-secure] Connection server SSL set credentials failed (43084) [opmn] [ERROR:1] [222] [ons-secure] SSL initialization failed Generating and Deploying a New Wallet for TLS Enabled Release 12.2 Environments Log in as the user that owns the application tier installation (this is usually applmgr or oracle). Source the run file system environment and the $FMW_HOME/SetWebtier.env file. $ source <EBS base install directory>/EBSapps.env run $ source $FMW_HOME/SetWebtier.env For a new Oracle E-Business Suite Release 12.2 installation, all steps must be performed on the run edition file system, which is sourced by running the following command: $ source <EBS base install directory>/fs1/EBSapps/appl/APPS<CONTEXT_NAME>.env Set an alias for the correct orapki. $ alias orapki=$FMW_HOME/oracle_common/bin/orapki Create a

 During connection from SQL Developer to EBS database got below error message: Status : Failure - Test failed: IO Error: Got minus one from a read call Following solution can be done : 1. Go to directory $ORACLE_HOME / network / admin 2. Modify sqlnet.ora file with following parameter : tcp.validnode_checking = no 3. If you don 't want to disable this, you can put the machine names as follows: tcp.invited_nodes=(machine1, machine2) 3. Bounce the listener. Due to security enhancements it is not good to put tcp.validnode_checking = no or comment out will through error when we start listener like below: Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=shsebs7idb1.appsolworld.com)(PORT=1522))) TNS-00584: Valid node checking configuration error TNS-12560: TNS:protocol adapter error Better plan is to add localhost or IP address of client (Local Computer) in the sqlnet.ora file That will solve the problem NAMES.DIRECTORY_PATH=(TNSNAMES, ONAMES, HOSTNAME) SQLNET.EXPI

 To create a directory: CREATE OR REPLACE DIRECTORY alias AS 'pathname' ; To Grant: GRANT permission ON DIRECTORY alias TO { user | role | PUBLIC}; SQL > SELECT DIRECTORY_NAME , DIRECTORY_PATH FROM DBA_DIRECTORIES WHERE DIRECTORY_NAME = 'DUMP' ; DIRECTORY_NAME DIRECTORY_PATH ------------------------------ --------------- DUMP / home /appsolworld $ chmod 777 /home/appsolworld Just test run: DECLARE Handle UTL_FILE.FILE_TYPE; BEGIN Handle : = UTL_FILE.FOPEN ( 'DUMP' , 'abc.txt' , 'w' ); UTL_FILE.PUT ( 'This is the first line' ); UTL_FILE.FCLOSE (Handle); EXCEPTION WHEN OTHERS THEN DBMS_OUTPUT.PUT_LINE ( 'Exception: SQLCODE=' || SQLCODE || ' SQLERRM=' || SQLERRM); RAISE; END ; / DBA_DIRECTORIES view which we use to check directory information. Let us describe that. SQL> desc DBA_DIRECTORIES; Name Null?

================== Enter the APPS password: Connected. ============================================================== ADOP (C.Delta.12) Session Id: 4 Command: status Output: /apdascn7i/product/122/fs_ne/EBSapps/log/adop/4/20220217_232656/adzdshowstatus.out =============================================================== Node Name       Node Type  Phase           Status          Started              Finished             Elapsed --------------- ---------- --------------- --------------- -------------------- -------------------- ------------ shsebs7idb1     master     PREPARE         COMPLETED       2022/02/15 07:02:15  2022/02/15 12:52:39  5:50:24                            APPLY           COMPLETED       2022/02/15 16:22:33  2022/02/15 21:06:33  4:43:00                            FINALIZE        COMPLETED       2022/02/16 23:15:37  2022/02/16 23:49:17  0:33:40                            CUTOVER         COMPLETED       2022/02/17 06:42:44  2022/02/17 07:24:30 

  No backend server available for connection: timed out after 10 seconds or idempotent set to OFF or method not idempotent. If there is an issue with the oacore managed server, meaning apache is not able to connect to the oacore managed server, we'll see this error. It is possible that the managed server oacore is not yet started, and we try to access the EBS URL. It is possible that the managed server for oacore is not able to start up because of a port conflict. Login to weblogic console Access OACORE_SERVER1 ( Use force Shutdown) Start OACORE_SERVER1  Now application will be accessble.