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

    Can not sqlplus from apps or net

    Beauty_and_dBest

      EBS R12.1.3

      11gR1

      OL6

       

       

      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 10.1.0.5.0 - 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,

      jc