Readmeout Oracle DBA Blog Specifically Focusing on database administration, RMAN Backup and recovery, restore, cloning, performance tuning and sharing best practices.
In this post we will compile forms in oracle apps R12 after implementing shell script to automatic compile forms(.fmb), libraries(.pll), reports(.rdf) Compile forms using shell script: – We need to update the same in .bash_profile to execute it using alias.We can compile forms manually as well. Hidden file .bash_profile located under /home/applmgr. Open .bash_profile using … Read more
When I tried to create password using orapwd command, faced error OPW-00029: Password complexity failed for SYS user. Enter password for SYS:OPW-00029: Password complexity failed for SYS user : Password must contain at least 8 characters. Solution:- Here we have two solutions to resolve error OPW-00029: Password complexity failed for SYS user. By default, oracle … Read more
In this post we will resolve OPW-00001: Unable to open password-file. We are facing this issue while creating password file in oracle database. Error :- Solution :-1) The reason behind “OPW-00001” is normally syntax error. We have to specify the command in the proper format. In some cases we missed to mention the .ora in file … Read more
In this post we will discuss about OPW-00010: Could not create the password file. We faced the issue while creating the password file. Error :- Enter password for SYS: OPW-00010: Could not create the password file.RESOURCE LIST: ora.gbpatc.db Solution:- To solve OPW-00010, we should reset the location of password file. Then try to recreate it … Read more
In this post we will discuss about OPW-00014: Could not delete password file. Facing OPW-00014: Could not delete password file while executing $orapwd FILE=’+DATA/PRTEST/orapwprtestc’ delete=y. Error: – Solution:- Use the below command to delete the Password File which was previously created in oracle database.
To Covert .pld to .pll we must follow the steps as given below. Here we are generating .pll from .pld file. In 11i Converting .pld file in .PLL File f60gen Module=XXSXDO.pld Userid=apps/***** parse=yes Module_Type=LIBRARY In R12 Converting .pld file in .PLL File frmcmp_batch Module=XXSXDO.pld Userid=apps/***** parse=yes Module_Type=LIBRARY To Generate .plx from .pll Once you convert … Read more
One day i had faced error ora-01031 insufficient privilege while tried to connect database as sysdba using sys user. Normally we were able to connect database successfully, but today no luck to do so. Resolve ORA-01031 insufficient privileges Issue $sqlplus / as sysdba SQL*Plus: Release 19.2.0.3.0 – Production on Wed Apr 9 01:12:00 2022 Copyright … Read more
We know that ORA-01031 Insufficient Privileges means current user did not have the right privilege to access or process the SQL statement. We can see this error almost in every kind of SQL statement, sometimes you would never know what privilege you have required. We have several situation where we can face the ORA-01031 error. … Read more
In this post we will discuss How to change database name using nid in oracle. The “nid” (New Database Identifier) utility in Oracle cannot be used to directly update the database name, also known as the global database name. The Global Database Name, which is normally defined during the database creation process, serves as the … Read more
Running AutoConfig in parallel on a multi node EBS R12 environment presents an effective solution to improve performance, achieve configuration consistency, and speed up the setup process to address this issue. Enterprise systems must be flexible and scalable in the fast-paced corporate environment of today. The Oracle E-Business Suite Suite Release 12 (EBS R12) is a … Read more