3 Replies Latest reply: Oct 29, 2012 7:00 PM by mybro62 RSS

    MW download patch R12 error during admsi ORA-12505 RAC

    967559
      Hi,
      I have been able to download and apply 11i patches so far in my MW project.
      I am now getting to the categories where I need to download R12 patches.
      I am receiving an error towards the end of each R12 patch download.
      The error occurs during the admsi.pl run. It is trying to connect as SID=PTCH, when it should really use SERVICE_NAME=PTCH or SID=PTCH1.
      How can I fix this? I have already put my RAC database in single instance mode.
      Is it safe to ignore these errors? I am currently working on category "Upg to Rel 12.1.1", step "1-Check for critical pre-upgrade patches for Financials (Required)".
      ---
      Partial Log show below with error.
      ---
      ###############################################################################
      About to execute Manual Step Instruction Check: admsi.pl
      ###############################################################################

      Gathering Information..
      Logfile for this session is located at admsi.log
      SHOWING LOG: /home/appptch/MWiz/log
      Log for admsi_main.pl, started at 2012-10-26 12:49:02
      ************************************************
      Establishing connection to the database with the following parameters:
      SID : PTCH
      User : APPS
      Error:

      Unable to connect to PTCH database.

      ORA-12505: TNS:listener does not currently know of SID given in connect descriptor (DBD ERROR: OCIServerAttach)


      Warning: No install_10029457.html file created in /home/appptch/MWiz/log
      Process Returned: 0 Results in: /mwiz/oracle/mwizdb/10.2.0/eof/log/INSTANCE_1703/script_10714.sh (58 bytes)

      Thanks, Dean