11 Replies Latest reply on Nov 1, 2017 4:03 AM by Beauty_and_dBest

    Can not sqlplus from apps or net


      EBS R12.1.3





      Hi ALL,


      Its just sudden, out apps can not connect  to the database, even if they are in one server


      I login at applmgr, and run sqlplus app/apps   and it hangs only:


      [applmgr@molina ~]$ sqlplus apps/apps


      SQL*Plus: Release - Production on Fri Oct 27 16:19:36 2017

      Copyright (c) 1982, 2005, Oracle.  All rights reserved.



      I tried to stop listener but it just hangs too


      [oracle@molina ~]$ addlnctl.sh stop PROD

      Logfile: /u01/oracle/PROD/db/tech_st/11.1.0/appsutil/log/PROD_molina/addlnctl.txt


      You are running addlnctl.sh version 120.1.12010000.4


      Shutting down listener process PROD ...


      Where do I get error log for listener?


      I already reboot the server but still the issue persist.


      Please help....


      Kind regards,