4 Replies Latest reply: Nov 3, 2012 10:23 PM by cheesewizz RSS

    After relink my APPS login internal error

    cheesewizz
      Hi

      Is there anyone know about this

      After i relink under adadmin of our Production ERP
      then I restart the APPS
      i tried to login but it takes time to show the login
      supposed to be the login but it was Internal error

      then i tried to start the listener

      and here is the result

      LSNRCTL> start PROD
      Starting /u/oracle/PROD/apps/tech_st/10.1.2/bin/tnslsnr: please wait...

      TNSLSNR for Linux: Version 10.1.0.5.0 - Production
      System parameter file is /u/oracle/PROD/inst/apps/PROD_tailinapps/ora/10.1.2/network/admin/listener.ora
      Log messages written to /u/oracle/PROD/apps/tech_st/10.1.2/network/log/prod.log
      TNS-01151: Missing listener name, PROD, in LISTENER.ORA

      Listener failed to start. See the error message(s) above...

      LSNRCTL>

      Please help


      thanks
        • 1. Re: After relink my APPS login internal error
          cheesewizz
          Hi


          LSNRCTL> status PROD
          Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=tailindb.tailinsubic.com)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=PROD)(INSTANCE_NAME=PROD)))
          TNS-01189: The listener could not authenticate the user
          LSNRCTL> status
          Connecting to (ADDRESS=(PROTOCOL=tcp)(PORT=1521))
          TNS-12541: TNS:no listener
          TNS-12560: TNS:protocol adapter error
          TNS-00511: No listener
          Linux Error: 111: Connection refused
          LSNRCTL>




          Thanks
          • 2. Re: After relink my APPS login internal error
            Hussein Sawwan-Oracle
            Please post the details of the application release, database version and OS.
            Is there anyone know about this

            After i relink under adadmin of our Production ERP
            then I restart the APPS
            i tried to login but it takes time to show the login
            supposed to be the login but it was Internal error

            then i tried to start the listener

            and here is the result

            LSNRCTL> start PROD
            Starting /u/oracle/PROD/apps/tech_st/10.1.2/bin/tnslsnr: please wait...

            TNSLSNR for Linux: Version 10.1.0.5.0 - Production
            System parameter file is /u/oracle/PROD/inst/apps/PROD_tailinapps/ora/10.1.2/network/admin/listener.ora
            Log messages written to /u/oracle/PROD/apps/tech_st/10.1.2/network/log/prod.log
            TNS-01151: Missing listener name, PROD, in LISTENER.ORA

            Listener failed to start. See the error message(s) above...
            Looks like you have missing entries in the listener.ora file. Please post the contents of the listener.ora file here.

            Are you trying to start the application listener? Is should be APPS_PROD and not PROD.

            If your listener.ora is not correct, please run AutoConfig and it should correct the entries in the file for you.

            Thanks,
            Hussein
            • 3. Re: After relink my APPS login internal error
              cheesewizz
              Hi Hussein

              I think i made a mistake
              Im running the listener in APPS Tier it should be on DB

              Now i can able to login in our ERP


              thanks
              • 4. Re: After relink my APPS login internal error
                Hussein Sawwan-Oracle
                cheesewizz wrote:
                Hi Hussein

                I think i made a mistake
                Im running the listener in APPS Tier it should be on DB

                Now i can able to login in our ERP


                thanks
                In this case, login as oracle user and source the database env file then issue "lsnrctl" followed by "start PROD".

                Thanks,
                Hussein