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; 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 case-sensitive by default. This behavior is controlled by the SEC_CASE_SENSITIVE_LOGON parameter.

Check the current value of above parameter:

SQL> connect system/oracle
Connected.
SQL> show parameter sec_case_sensitive_logon
NAME                     TYPE    VALUE
------------------------ ------- -----
sec_case_sensitive_logon boolean TRUE

Default value of this parameter is TRUE, change it to FALSE. After restart the database reports are working fine without any error.

Your comments, especially which will help us improve the functionality, will be greatly appreciated. :)

Auto startup and shutdown oracle database services on linux

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_HOME_LISTNER=$ORACLE_HOME

• Create a file “dbora” in /etc/init.d/ using root user

         Contents of dbora file is:

#!/bin/sh

# description: Oracle database auto start-stop script.

#

ORA_HOME=/d01/app/oracle/product/11.2.0/dbhome_1

ORACLE_HOME_LISTNER=$ORA_HOME

ORA_OWNER=oracle

if [ ! -f $ORA_HOME/bin/dbstart ]

then

    echo "Oracle startup: cannot start"

    exit

fi

case "$1" in

'start')

# Start the Oracle Database Instance Using the Script Created by Rana Abdul Wahid:

# The following command assumes that the oracle login

# will not prompt the user for any values

su $ORA_OWNER -c $ORA_HOME/bin/dbstart $ORACLE_HOME &

touch /var/lock/subsys/dbora

;;

'stop')

# Stop the Oracle Database Instance Using the Script Created by Rana Abdul Wahid:

# The following command assumes that the oracle login

# will not prompt the user for any values

su $ORA_OWNER -c $ORA_HOME/bin/dbshut $ORACLE_HOME

rm -f /var/lock/subsys/dbora

;;

esac

• Save the above file

• chmod 750 /etc/init.d/dbora

• chkconfig --add dbora

Now each time all database services shutdown normally when Linux shutdown. When Linux startup all database services automatically startup normally.

Your comments, especially which will help us improve the functionality, will be greatly appreciated. :)