Is there anyone know about thisLooks like you have missing entries in the listener.ora file. Please post the contents of the listener.ora file here.
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...
cheesewizz wrote:In this case, login as oracle user and source the database env file then issue "lsnrctl" followed by "start PROD".
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