10 Replies Latest reply on Aug 10, 2015 1:12 PM by yoonas

    EBS db upgrade - Grant create procedure privilege on CTXSYS

    V. A. Nagpure

      Hi All,

       

      While upgrading EBS R12 database, as per note 1058763.1 from 11.1.0.7 to 11.2.0.4, I am getting following error at the stage given below:

       

      -bash-3.2$ sqlplus apps/apps @wfaqupfix.sql APPLSYS APPS

       

      SQL*Plus: Release 10.1.0.5.0 - Production on Mon Aug 10 14:21:15 2015

       

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

       

      ERROR:

      ORA-12541: TNS:no listener

       

      -bash-3.2$ sqlplus apps/apps

       

      SQL*Plus: Release 10.1.0.5.0 - Production on Mon Aug 10 14:22:34 2015

       

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

       

      ERROR:

      ORA-12541: TNS:no listener

       

      I checked the TNS_ADMIN vairable of the apps tier and found port 1522 in the tnsnames.ora file whereas the actual port of the database listener is 1521 and the database listener is already up.

       

      Any ideas?

       

      Regards,

      Vinod