This discussion is archived
4 Replies Latest reply: Nov 3, 2012 8:23 PM by cheesewizz RSS

After relink my APPS login internal error

cheesewizz Newbie
Currently Being Moderated
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 Newbie
    Currently Being Moderated
    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 Employee ACE
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Employee ACE
    Currently Being Moderated
    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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points