This discussion is archived
1 2 Previous Next 17 Replies Latest reply: Mar 10, 2011 7:57 AM by mybro62 RSS

Issues with patch download

user649511 Guru
Currently Being Moderated
Running 2.18 and can't get the patch download to work. I've attempted single patch downloads in debug mode and I'm not finding enough information to troubleshoot this. I don't know if the problem is with the wizard or if it could be something on the Linux server. Here is information from an attempt to download patch 5259121. Any help on toubleshooting this would be greatly appreciated. I've lost many hours already. Thanks!
.
get_from_url_1704_5259121.sh
/u01/mwiz/mwizdb/10.2.0/jre/*/bin/java -Dbug_number="5259121" -Daction="download_file" -Dplatform="46" -Ddownload_directory="./" oracle.support.mw.AruExecutor
ls -l p5259121_*11i_*.zip
.
cat get_from_url_5259121.log
ERROR: Downloaded file: ./p5259121_11i_GENERIC.zip Problem: 0 Btyes, Try url manually: https://updates.oracle.com/Orion/XMLAPI/download_patch/p5259121_11i_GENERIC.zip?aru=8644093&email=<myemail>&userid=O-<myemail>&patch_file=p5259121_11i_GENERIC.zip or contact support.
ls: p5259121_*11i_*.zip: No such file or direct
.
From script_10433.sh.log
1) Have the administrator try running the ftp script manually.
OR
2) set HOME/.netrc, then try Script: /u01/mwiz/mwizdb/10.2.0/eof/log/INSTANCE_1704/get_from_url_1704_5259121.sh
.
If I just run the command above I get a java error.
/u01/mwiz/mwizdb/10.2.0/eof/log/INSTANCE_1704/get_from_url_1704_5259121.sh
Exception in thread "main" java.lang.NoClassDefFoundError: oracle/support/mw/AruExecutor
ls: p5259121_*11i_*.zip: No such file or directory
.
This java error might be because I didn't do the "et HOME/.netrc" part because I'm not clear on what that is.
  • 1. Re: Issues with patch download
    vikki - moderator - oracle Explorer
    Currently Being Moderated
    What happens if you put that URL in your browser?

    If I try:

    https://updates.oracle.com/Orion/XMLAPI/download_patch/p5259121_11i_GENERIC.zip?aru=8644093&email=victoria.pickard@oracle.com&userid=O-victoria.pickard@oracle.com&patch_file=p5259121_11i_GENERIC.zip

    It prompts me for my MOS username/password, then it downloads the patch. Does it behave the same way for you? (If this works, it would lend itself to MW somehow using the wrong username & password for MOS or maybe that there is a proxy issue on the MW box.)

    Ideally, you should also try the URL on the MW node itself, if you have a browser installed there. That'd narrow it even further if proxies are turned off in the browser and the URL succeeds.

    One other question, do other MW steps which access MOS work? For example, find a step which has a link to a MOS note... That should be using the same login info, so do THOSE work?

    -Vikki
  • 2. Re: Issues with patch download
    user649511 Guru
    Currently Being Moderated
    If I run it from my PC I get the same as you. It prompts for login and password and will find it if I provide that information.
    .
    If I ran if from the server as the owner of the wizard I get the following:
    $https://updates.oracle.com/Orion/XMLAPI/download_patch/p5259121_11i_GENERIC.zip?aru=8644093&email=<myemail>@<mydomain>.com&userid=O-<myemail>@<mydomain>.com&patch_file=p5259121_11i_GENERIC.zip
    [1] 4519
    -bash: https://updates.oracle.com/Orion/XMLAPI/download_patch/p5259121_11i_GENERIC.zip?aru=8644093: No such file or directory
    [2] 4520
    [3] 4521
    [1] Exit 127 https://updates.oracle.com/Orion/XMLAPI/download_patch/p5259121_11i_GENERIC.zip?aru=8644093
    [2] Done email=<myemail>@<mydomain>.com
    [3]+ Done userid=O-<myemail>@<mydomain>.com
    .
    I don't have a browser on the server to test with but I'm asking our Linux admin about this.
    .
    I did find a link to a MOS document and it worked fine.
    .
    I'm working with the Linux admin in the morning to make sure there isn't some port blocking or other security settings stopping this from working. I'm assuming that in order for the patch download to work it must be able to execute the full https:.... command as the wizard owner from the server. Is that correct or does that https command get sent out from inside of java or something else? Guess I'm just looking for the full valid method to test this as the app owner from the server command line. Thanks!

    Edited by: user649511 on Feb 24, 2011 4:20 PM
  • 3. Re: Issues with patch download
    user649511 Guru
    Currently Being Moderated
    I'm running out of things to try from the server to get better information on why this isn't working. Any more ideas for how to troubleshoot this would be appreciated. I'm "assuming" that the application is running the command below when it is trying to download the patch. But as noted in the previous post all I get is a java error trying to run it. I also passed it a verbose option but all that recored was the jar files it loaded..no information on the actual error or issue. Is there anything I can do from the server to get better information on why this is failing? Also the log says to "set HOME/.netrc" then run the get_from_url_1704_5259121.sh script. I'm not clear on what the "set HOME/.netrc" part of this means. I know there is a .netrc file EOF_HOME/config, is there something I need to do to invoke it before running the shell script? Thanks!
    .
    /u01/mwiz/mwizdb/10.2.0/jre/*/bin/java -Dbug_number="5259121" -Daction="download_file" -Dplatform="46" -Ddownload_directory="./" oracle.support.mw.AruExecutor

    Edited by: user649511 on Feb 25, 2011 8:26 AM
  • 4. Re: Issues with patch download
    vikki - moderator - oracle Explorer
    Currently Being Moderated
    In order to test that URL from the MW server you NEED a browser installed on it... The reason it's failing right now is because UNIX/Linux interprets the "&" in the URL to be "put this in the background", so that's how you're getting 4 background jobs instead of one big URL.

    I am pretty confident the stuff about the .netrc is just old information from our OLD method of doing it. I'll look into removing that part of the message.

    The https command does get executed from inside of Java.

    Have you verified the values for METALINK_USER, HTTP_PROXY_HOST and HTTP_PROXY_PORT in EOF_CONFIG are all correct?
    Have you tried resetting the MOS password via the utility to make sure it's correct? (Though I suspect if the MOS link works, then it should be... unless it prompted you previously for credentials and/or your browser had it saved...)

    -Vikki
  • 5. Re: Issues with patch download
    vikki - moderator - oracle Explorer
    Currently Being Moderated
    Let's try this:

    export ORACLE_HOME=<your OH>
    export JAVA_HOME=$ORACLE_HOME/jdk
    export JAVA=${ORACLE_HOME}/jre/*/bin/java

    MACHINE=`$ORACLE_HOME/bin/tnsping $TWO_TASK | awk -F"(" '{print $0}' | tr "(" "\n" | egrep -i 'HOST' | tr ")" " " | awk -F"=" '{print $2}' | sed 's/ //g' `
    PORT=`$ORACLE_HOME/bin/tnsping $TWO_TASK | awk -F"(" '{print $0}' | tr "(" "\n" | egrep -i 'PORT' | tr ")" " " | awk -F"=" '{print $2}' | sed 's/ //g'`
    CONNECT=`echo "${MACHINE}:${PORT}:${TWO_TASK}"`

    CLASSPATH=$CLASSPATH:.:${ORACLE_HOME}/jlib/oraclepki.jar
    CLASSPATH=$CLASSPATH:${ORACLE_HOME}/jdbc/lib/classes12.jar
    CLASSPATH=$CLASSPATH:${ORACLE_HOME}/lib/xmlparserv2.jar
    CLASSPATH=$CLASSPATH:${ORACLE_HOME}/lib/xsu12.jar
    CLASSPATH=$CLASSPATH:$EOF_HOME/bin/lib/aru.jar
    export CLASSPATH

    EOFUSER=<your MW DB user>
    EOFPASSWORD=<your MW DB pass>
    export EOFUSER EOFPASSWORD

    $JAVA -Dbug_number=5259121 -Daction="download_file" -Dplatform="46" -Ddownload_directory="./" -Ddebug=YES oracle.support.mw.AruExecutor

    -Vikki
  • 6. Re: Issues with patch download
    user649511 Guru
    Currently Being Moderated
    Here is what the above returned:
    .
    $JAVA -Dbug_number=5259121 -Daction="download_file" -Dplatform="46" -Ddownload_directory="./" -Ddebug=YES oracle.support.mw.AruExecutor
    <BR>DEBUG: Getting connection from: jdbc:oracle:thin:@$CONNECT
    ISSUE: MW connection is based on the CONNECT variable in rundb.sh
    SQLException in = AruExecutor.getConnection()
    Error message = Io exception: Unknown host specified
    CHECK: jdbc_url = jdbc:oracle:thin:@$CONNECT
    username = MW
    .
    I Ran the https command from firefox as the wizard owner from the Linux server and it worked. It did prompt me for my login and password. Once I provided that information I was able to download the patch to the server.
    .
    Our network group did some tracing on the firewall while I was running the download patch function from within the wizard. Here is their response.
    .
    Repeated ad nauseum – the java code on the server appears to re-request changing the cipher specification (ie, changing type of encryption) over and over.
    .
    They sent a log file and highlighted the "Change Cipher Spec" command.

    Edited by: user649511 on Feb 25, 2011 10:16 AM
  • 7. Re: Issues with patch download
    vikki - moderator - oracle Explorer
    Currently Being Moderated
    Is this part evaluating correctly?

    MACHINE=`$ORACLE_HOME/bin/tnsping $TWO_TASK | awk -F"(" '{print $0}' | tr "(" "\n" | egrep -i 'HOST' | tr ")" " " | awk -F"=" '{print $2}' | sed 's/ //g' `
    PORT=`$ORACLE_HOME/bin/tnsping $TWO_TASK | awk -F"(" '{print $0}' | tr "(" "\n" | egrep -i 'PORT' | tr ")" " " | awk -F"=" '{print $2}' | sed 's/ //g'`
    CONNECT=`echo "${MACHINE}:${PORT}:${TWO_TASK}"`

    If you do these manually from the O/S, does CONNECT have the correct value?

    -Vikki
  • 8. Re: Issues with patch download
    user649511 Guru
    Currently Being Moderated
    They all have valid values:
    .
    $CONNECT = <correct fully qualified server>:<correct database port>:<correct datbase SID>
    .
    $MACHINE = <correct fully qualified server>
    .
    $PORT = <correct database port>
  • 9. Re: Issues with patch download
    user649511 Guru
    Currently Being Moderated
    Can you think of anything else for me to try. I went ahead and manually downloaded and staged the previous patches so that I could proceed. I mentioned in a diffeent thread that I put in a dummy MOS password when I installed the wizard since I wasn't sure if we were going to use that functionality. Since then I updated it to the proper MOS value using the wizard. I noticed that it did not update the eof_home/config/.netrc file with the correct password so I saved that off and updated it to the correct value manually. It noticed that there may be some wallet configuration in the application. Is it possible that something in there needs to be updated. Thanks again for all of your help!!
  • 10. Re: Issues with patch download
    mybro62 Journeyer
    Currently Being Moderated
    I am currently working with another customer on 2.18 running AIX that is experiencing similar download issues exactly the same as you are experiencing. If you could post the contents of your firewall trace file.

    Thanks
  • 11. Re: Issues with patch download
    mybro62 Journeyer
    Currently Being Moderated
    Could you please tell me what version of java you have installed under your MW oracle home. Also what version of RDBMS are you running for the MW.

    example

    /u01/mwiz/mwizdb/10.2.0/jre/*/bin/java -version
  • 12. Re: Issues with patch download
    user649511 Guru
    Currently Being Moderated
    java version "1.4.2_14"
    Java(TM) 2 Runtime Environment, Standard Edition (build 1.4.2_14-b05)
    Java HotSpot(TM) Client VM (build 1.4.2_14-b05, mixed mode)
    .
    ORACLE RDBMS Version: 10.2.0.5.0
    .
    I looking at getting you information on the firewall log and will update once I have theinformation.
  • 13. Re: Issues with patch download
    user649511 Guru
    Currently Being Moderated
    Here is information from our firewall trace with IP addresses and such removed. What they pointed out was that the "Change Cipher Spec" is done over, and over, etc. This is just a small part of the trace but should give you an idea.
    .
    Client Hello
    Server Hello
    Certificate, Server Hello Done
    53044 > https [ACK] Seq=101 Ack=2157 Win=8832 Len=0 TSV=4018250336 TSER=1565986730
    Client Key Exchange
    Change Cipher Spec
    Encrypted Handshake Message
    https > 53044 [ACK] Seq=2157 Ack=246 Win=4385 Len=0 TSV=1565986847 TSER=4018250412
    Change Cipher Spec,
    Encrypted Handshake Message
    53044 > https [ACK] Seq=283 Ack=2200 Win=8832 Len=0 TSV=4018250456 TSER=1565986850
    Application Data
    https > 53044 [ACK] Seq=2200 Ack=560 Win=4699 Len=0 TSV=1565986991 TSER=4018250459
    [TCP segment of a reassembled PDU]
    Application Data, Application Data
    53044 > https [ACK] Seq=560 Ack=3652 Win=13056 Len=0 TSV=4018250671 TSER=1565987063
    Encrypted Alert
    53044 > https [FIN, ACK] Seq=583 Ack=3652 Win=13056 Len=0 TSV=4018250672 TSER=1565987063
    53045 > https [SYN] Seq=0 Win=5840 Len=0 MSS=1460 SACK_PERM=1 TSV=4018250678 TSER=0 WS=7
    https > 53044 [ACK] Seq=3652 Ack=584 Win=4722 Len=0 TSV=1565987104 TSER=4018250672
    https > 53045 [SYN, ACK] Seq=0 Ack=1 Win=4140 Len=0 MSS=1380 WS=0 TSV=1565987109 TSER=4018250678 SACK_PERM=1
    53045 > https [ACK] Seq=1 Ack=1 Win=5888 Len=0 TSV=4018250715 TSER=1565987109
    Client Hello
    Server Hello,
    Change Cipher Spec,
    Encrypted Handshake Message
    53045 > https [ACK] Seq=111 Ack=123 Win=5888 Len=0 TSV=4018250754 TSER=1565987148
    Change Cipher Spec
    Encrypted Handshake Message
    Application Data
    https > 53045 [ACK] Seq=123 Ack=154 Win=4256 Len=0 TSV=1565987189 TSER=4018250755
    https > 53045 [ACK] Seq=123 Ack=431 Win=4570 Len=0 TSV=1565987290 TSER=4018250758
    [TCP segment of a reassembled PDU]
    Application Data, Application Data
    53045 > https [ACK] Seq=431 Ack=1575 Win=8576 Len=0 TSV=4018250979 TSER=1565987373
    Encrypted Alert
    53045 > https [FIN, ACK] Seq=454 Ack=1575 Win=8576 Len=0 TSV=4018250981 TSER=1565987373
    https > 53045 [ACK] Seq=1575 Ack=455 Win=4593 Len=0 TSV=1565987412 TSER=4018250981
    53048 > https [SYN] Seq=0 Win=5840 Len=0 MSS=1460 SACK_PERM=1 TSV=4018251153 TSER=0 WS=7
    https > 53048 [SYN, ACK] Seq=0 Ack=1 Win=4140 Len=0 MSS=1380 WS=0 TSV=1565987585 TSER=4018251153 SACK_PERM=1
    53048 > https [ACK] Seq=1 Ack=1 Win=5888 Len=0 TSV=4018251191 TSER=1565987585
    Client Hello
    Server Hello,
    Change Cipher Spec,
    Encrypted Handshake Message
    53048 > https [ACK] Seq=111 Ack=123 Win=5888 Len=0 TSV=4018251230 TSER=1565987624
    Change Cipher Spec
    Encrypted Handshake Message
  • 14. Re: Issues with patch download
    Alan3 Newbie
    Currently Being Moderated
    Our dba here is working with mybro62 above and I've been called into the issue to look at it from the network side.
    I reinstalled MW onto one of our Linux servers and get the same results as we got in AIX.
    I have the full network capture, but it's encrypted (SSL) and I've asked in our SR if they can use their (Oracle's) private key to decrypt so we can see the full exchanges.
    (Anyone know how to use the negotiated cipher to decrypt from the client side?)
    Anyway... it attempts 3 connections and fails.
    I've narrowed it down to the URL.openConnection object from execWebService of AruWebService.class in the aru.jar file.
    I also managed to find the debug parameter for this class and I'm able to run it directly from the commandline and get more info.
    To run from the commandline, you have to have CONNECT, EOFUSER, EOFPASSWORD, CLASSPATH & a few other environment variables set. Add a -Ddebug="Y" parameter to the java call in get_from_url script.
    I'm 99% certain we have no firewall/filter/proxy causing this.
    Anyway - this is what we got from the debug... still no help...
    --------------------------
    $ ./get_from_url_1703_8487779.sh
    <BR>DEBUG: Getting connection from: jdbc:oracle:thin:@<host>:<port>:<sid>
    <BR>DEBUG: # jdbc_url =jdbc:oracle:thin:@<host>:<port>:<sid>
    <BR>DEBUG: # username =mw
    <BR>DEBUG: # password =<passwd>
    <BR>DEBUG: #################################################
    <BR>DEBUG: # LoadProperties() =AruExecutor.properties
    <BR>DEBUG: # user.home =/home/oracle
    <BR>DEBUG: # current Directory =/home/oracle/oracle/product/10.2.0/db_1/eof/patches
    <BR>DEBUG: # File.Separator =/
    <BR>DEBUG: # java.class.path =/home/oracle/oracle/product/10.2.0/db_1/eof/bin/lib/aru.jar:/home/oracle/oracle/product/10.2.0/db_1/lib/xmlparserv2.jar:/home/oracle/oracle/product/10.2.0/db_1/jdbc/lib/classes12.jar:.:/home/oracle/oracle/product/10.2.0/db_1/eof/lib:/home/oracle/oracle/product/10.2.0/db_1/lib/xsu12.jar:/home/oracle/oracle/product/10.2.0/db_1/jlib/oraclepki.jar:/home/oracle/oracle/product/10.2.0/db_1/jlib/ojpse.jar
    <BR>DEBUG: # jdbc_url =jdbc:oracle:thin:@<host>:<port>:<sid>
    <BR>DEBUG: # username =mw
    <BR>DEBUG: # metailink_username =<metalinkuser>
    <BR>DEBUG: # metailink_password =9 (length)
    <BR>DEBUG: # proxy_host =null
    <BR>DEBUG: # proxy_port =null
    <BR>DEBUG: # action =download_file
    <BR>DEBUG: # bug_number =8487779
    <BR>DEBUG: # instance_id =1703
    <BR>DEBUG: # max_levels =3
    <BR>DEBUG: # platform =319 (only need for action=download_file)
    <BR>DEBUG: # download_directory =./ (only need for action=download_file)
    <BR>DEBUG: # file =p8487779_11i_GENERIC.zip
    <BR>DEBUG: #################################################
    ERROR: Downloaded file: ./p8487779_11i_GENERIC.zip Problem: 0 Btyes, Try url manually: https://updates.oracle.com/Orion/XMLAPI/download_patch/p8487779_11i_GENERIC.zip?aru=11270684&email=<email&userid=O-<metalinkuser>&patch_file=p8487779_11i_GENERIC.zip or contact support.
    ls: p8487779_*11i_*.zip: No such file or directory
1 2 Previous Next

Legend

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