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...

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/pro...