Oracle Application DBA

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; logon denied Solution: After some research work I have found the following solution: If you have recently created an 11g database, one behavior change that you may find confusing is that passwords are now ca

Auto startup and shutdown oracle database services on linux Applies to:             Enterprise Linux – Version: 5             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 Set the following parameter in $ORACLE_HOME/bin/dbshut :          ORACLE_HOME=/d01/app/oracle/product/11.2.0/dbhome_1;          export ORACLE_HOME          ORACLE_HO