Posts

Showing posts from June, 2014

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.

REP-0501 ORA-01017 unable to connect to the specified database

-
REP-0501 ORA-01017 unable to connect to the specified database Applies to:             Enterprise Linux Version 5.7             Database 11gR2             Oracle Forms/Reports 6i Description:             We have an in-house developed application on Oracle Form/Reports 6i with Oracle Database 9.2 32bit on Windows Server 2008 32bit. Application is working fine. I have assigned a task from my manager to upgrade the database and also migrate the database server on Linux. I have done all the activities successfully. After that, Application is working fine except reports. When I run any report from application the report engine log give me the following error: REP-0501: Unable to connect to the specified database. ORA-01017: invalid username/password...
6 comments
Read more

Auto startup and shutdown oracle database services on linux

-
Image
Auto startup and shutdown oracle database services on linux          Description:             I have oracle database 11gR2 on enterprise Linux 5.7. I want that all database services and listener should be stopped automatically when Linux going to shutdown. And after startup Linux all database services and listener start automatically. Solution:             To auto startup and shutdown all database services:    Following parameter in /etc/oratab file should be Y: orcl:/d01/app/oracle/product/11.2.0/dbhome_1:Y   Set the following parameter in $ORACLE_HOME/bin/dbstart :           ORACLE_HOME=/d01/app/oracle/product/11.2.0/dbhome_1;           export ORACLE_HOME           ORACLE_HOME_LISTNER=$ORACLE_HOME ...
Post a Comment
Read more