Posts

Showing posts from May, 2019

Oracle Database Error Solutions & DBA Knowledge Base

Welcome to Oracle Database Error Solutions, a professional technical knowledge base dedicated to helping Oracle Database Administrators, Oracle E-Business Suite administrators, developers, and IT professionals troubleshoot Oracle Database and Oracle Linux issues with confidence.

This website provides practical, real-world troubleshooting guides based on hands-on Oracle administration experience. You'll find detailed solutions for Oracle Database errors, RMAN backup and recovery, Data Guard, ASM, RAC, Oracle Linux administration, Oracle E-Business Suite (EBS), cloning, performance tuning, patching, installation, and day-to-day DBA tasks.

Whether you're resolving ORA-27101, ORA-28040, ORA-01555, ORA-12154, ORA-01017, or other Oracle errors, our step-by-step articles are designed to save you time and help you solve problems efficiently.

Unable to Connect Oracle Database Server from Oracle Client - Change Oracle Database Character Set

-
Unable to Connect Oracle Database Server from Oracle Client - Change Oracle Database Character Set Applies to:             Oracle Enterprise Linux – Version: 5             Oracle EBS R12             Description: I have installed a new VISION instance on Oracle Linux 5. All is going well, all configuration and setup completed successfully. All services of Database and Application started successfully. Application is also working fine from client side. I have a problem to connect database from client side. TNSNAMES.ORA file also configured on client side but unable to connect SQLPLUS. SQLPLUS session going to hang/close when trying to connect: CMD> Sqlplus apps/apps@VIS Solution: After some research I found that the character set of Database is default to “AL16UTF16” which create the problem to con...
1 comment
Read more

Late Charges Report Print Wrong Date - Less Than 1 Day of the Original Date

-
Late Charges Report Print Wrong Date - Less Than 1 Day of the Original Date Applies to:             Oracle Receivables R12 12.1.3             Oracle Database 11.1.0.7.0 Description: We have noted that the “Late Charges Report” print the wrong date less than 1 day of the original date. Responsibility: Receivables Manager Navigation: Late Charges à Generate Late Charges à Late Charges Generate Solution: After some research work I found the solution to apply the following patch: Patch 26500596             ·          You should take backup of your system before applying the patch ·          First apply patch in a TEST environment ·          Re-test the issue I have fixe...
Post a Comment
Read more