This discussion is archived
3 Replies Latest reply: Oct 29, 2012 5:00 PM by mybro62 RSS

MW download patch R12 error during admsi ORA-12505 RAC

967559 Newbie
Currently Being Moderated
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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points