2 Replies Latest reply on Jul 26, 2017 4:42 AM by Shaik

    Unable to build xml file on db tier

    3178882

      Hello Team,

      While trying to build the xml file on db tier i'm getting invalid password error.

       

      1.  startup nomount

      2.  Re-create control file.

      3.  alter database open resetlogs.

      4. started the listener service .

      5. trying to build the xml file on db Tier getting below error.

      cd /u10/oraprod/fnprdnovdb/10.2.0/appsutil/bin

      perl adbldxml.pl tier=db appsuser=APPS

       

       

      Connection paramaters values:

           Database server hostname     ==>  NOVPRDDB1TEST.NOVELIS.BIZ

           Database listener port       ==>  1550

           Database SID                 ==>  PRODTEST

           Database schema name         ==>  apps

       

       

      Could not Connect to the Database : ORA-01017: invalid username/password; logon denied

       

       

       

      Source ; 11.5.9

      DB ; 10.2.0.3

      HP -tru64

        • 1. Re: Unable to build xml file on db tier
          mdtaylor

          Recreate your orapw file in $ORACLE_HOME/dbs.

           

          orapwd file=$ORACLE_HOME/dbs/orapw password=sys_password entries=20

          • 2. Re: Unable to build xml file on db tier
            Shaik

            Hi

             

            Try with complete syntax

            perl adbldxml.pl appsuser=apps apppass=apps

             

             

            I can create as below:

            bash-3.2$ perl adbldxml.pl

             

             

            Starting context file generation for db tier..

            Using JVM from /data/ora/testdb/11.2.0/jdk/jre/bin/java to execute java programs..

            APPS Password: apps

             

             

            The log file for this adbldxml session is located at:

            /data/ora/testdb/11.2.0/appsutil/log/adbldxml_07231814.log

             

             

            Enter the value for Display Variable: 0.0

             

             

            The context file has been created at:

            /data/ora/testdb/11.2.0/appsutil/TEST_test.xml

             

             

             

            Regards

            Shaik