1. Error Message:- I faced with that error message while I was trying to apply 13.2.0.0.0 patch [oracle@TESTOEM]$export ORACLE_HOME=/u01/app/oracle/product/agent13c/agent_13.2.0.0.0 [oracle@TESTOEM]$export PATH=$PATH:/u01/app/oracle/product/agent13c/agent_13.2.0.0.0/OPatch/ [oracle@TESTOEM]$ opatch lsinventory Oracle Interim Patch Installer version…
Read MoreNow from 12c database you can move/relocate datafiles ONLINE menaing users can still able to access the database and objects while the move/relocate is in process, prior to 12c it…
Read MorePROBLEM: While querying against a database link, got below error. select sysdate from dual@DBLINK * ERROR at line 1: ORA-02020: too many database links in use CAUSE & SOLUTION:…
Read MoreSymptoms: You have defined a setup for balance Forward billing, wherein you have: 1) Defined a Billing Cycle 2) Associated the Billing Cycle to a Payment Term 3) Created a…
Read MoreWorkaround You have to either Reject/Approve the Adjustment or change the GL Date to resolve all the adjustments prior to closing period. To remove adjustment from subledger period close exception…
Read MoreSolution: A. For payments that are cleared or reconciled in status: 1. In the Payments workbench click on Payment Overview. 2. In the Payments Overview window note the statement number…
Read MoreDownload sqlt_10g_11g_12c_18c_19c_5th_June_2020.zip set db environment cd /home/oracle unzip sqlt_10g_11g_12c_18c_19c_5th_June_2020.zip cd sqlt/install sqlplus / as sysdba sql> start sqlcreate.sql Enter password for SQLTXPLAIN Enter Tablespace name Enter Temp tablespace name…
Read MorePYTHON: If you’re using Oracle Linux 7, you can use yum to install the CLI. sudo yum install python36-oci-cli The CLI will be installed to the Python site packages: /usr/lib/python3.6/site-packages/oci_cli…
Read MoreBelow the steps for enable DIAGNOSTICS option to a specific user in R.12. 1.Login as a sysadmin user in front end. 2.In the EBS dashboard , choose SYSTEM ADMINISTRATOR Responsibility…
Read MoreINTRODUCTION The below steps showes us how to migrate a 19c database using Transportable Tablespace. MIGRATION FROM LINUX TO WINDOWS MIGRATION FROM LINUX TO WINDOWS BY TRANSPORTABLE TABLESPACE CREATED A TABLESPACE CREATED A TABLE BY HAVING DEFAULT TABLESPACE AS TBS(CREATED TABLESPACE), EXECUTED THE DBMS_TTS.TRANSPORT_SET_CHECK FOR TRANSPORTING TABLESPACE TBS THAT IS TRUE, ALSO CHECKED IF THERE IS ANY VIOLATIONS CHECKED THE ENDIAN FORMAT ON BOTH THE PLATFORMS PERFORMED EXPORT BY DATAPUMP FOR TRANSPORT TABLESPACE DATABASE IN THE WINDOWS PLATFORM PERFORMED AN IMPORT IN THE TARGET PLATFORM AFTER THE IMPORT HECK WHETHER THE TABLESPACE IS AVAILABLE AND MAKE IT READ WRITE, CHECK FOR THE TABLE CREATED WITH DEFAULT TABLESPACE(TBS)
Read More