Wednesday, December 28, 2011

Sungard Banner on Oracle 11g Middleware and Database


I have been working on this since last 8 months. The production is still at 10g iAS and Database. I am expecting it to get completed by first quarter of 2012.

The current strategy is to have:
1. Two separate domains for INB and SSB
2. INB would utilize Oracle PFR&D 11.1.1.4.0 + weblogic 10.3.4
3. SSB would utilize Oracle WebTier Utilities 11.1.1.4.0 + weblogic 10.3.4
4. Single installation of Oracle Weblogic 10.3.4
5. The domains are created in production mode
6. boot.properties is utilized to avoid prompting of username/password
7. Database is going to be upgraded to 11.2.0.2
8. Follow FAQ 1-XFTOI5 to take care of privileges for 11g database users.
5. Take care of creating ACLs - FAQ 1-648TQ0


Related FAQs from Sungard Support Center:
FAQ 1-BTZNOZ
FAQ 1-Z7JOUC
FAQ 1-XFTOI5
FAQ 1-648TQ0






13 comments:

  1. I'm working on installing on my SSB box. I'm working through FAQ 1-BTZNOZ. And I'm currently stuck at:

    4. Start the WebLogic Admin Server.

    Everytime I try to run this stuff I'm getting:
    The JRE was not found in directory /usr/bin/java. (JAVA_HOME)
    Please edit your environment and set the JAVA_HOME
    variable to point to the root directory of your Java installation.

    OR:
    The JRE was not found in directory /usr/lib/jvm/java-1.6.0-sun-1.6.0.29. (JAVA_HOME)
    Please edit your environment and set the JAVA_HOME
    variable to point to the root directory of your Java installation.

    I've went in an updated the *.sh files to hardcode the JAVA_HOME but it still isn't working.

    $ which java
    /usr/bin/java

    $ java -version
    java version "1.6.0_29"
    Java(TM) SE Runtime Environment (build 1.6.0_29-b11)
    Java HotSpot(TM) Client VM (build 20.4-b02, mixed mode, sharing)

    $ ls -lthr /usr/lib/jvm/java-1.6.0-sun-1.6.0.29
    total 8.0K
    drwxr-xr-x 4 root root 4.0K Dec 5 14:48 jre

    ReplyDelete
  2. Did you run setDomainEnv.sh before starting weblogic admin server? Try below:
    . $DOMAIN_HOME/bin/setDomainEnv.sh

    $DOMAIN_HOME/startWebLogic.sh

    ReplyDelete
  3. I get the same thing when trying to run that... I also posted on OTN. Someone mentioned that it may have to do with permissions? I didn't install the JDK but I did install the weblogic software as oracle. I'm thinking that the JDK got installed as root, would that matter?

    $ pwd
    /u01/app/oracle/Oracle/Middleware/user_projects/domains/base_domain/bin
    $ ./setDomainEnv.sh
    The JRE was not found in directory /usr/bin/java. (JAVA_HOME)
    Please edit your environment and set the JAVA_HOME
    variable to point to the root directory of your Java installation.

    Thanks for any suggestions!

    ReplyDelete
  4. What does JAVA_HOME code show up in setDomainEnv.sh

    e.g.
    BEA_JAVA_HOME=""
    export BEA_JAVA_HOME

    SUN_JAVA_HOME="/usr/lib/jvm/java-1.6.0-sun-1.6.0.22.x86_64"
    export SUN_JAVA_HOME

    if [ "${JAVA_VENDOR}" = "Oracle" ] ; then
    JAVA_HOME="${BEA_JAVA_HOME}"
    export JAVA_HOME
    else
    if [ "${JAVA_VENDOR}" = "Sun" ] ; then
    JAVA_HOME="${SUN_JAVA_HOME}"
    export JAVA_HOME
    else
    JAVA_VENDOR="Sun"
    export JAVA_VENDOR
    JAVA_HOME="/usr/lib/jvm/java-1.6.0-sun-1.6.0.22.x86_64"
    export JAVA_HOME
    fi
    fi

    ReplyDelete
  5. The JDK would be installed as root only. It doesnt have to be Oracle. You were able to install weblogic using the same JDK then you shouldnt have any issues. I think the issue is setting of JAVA_HOME or missing library.

    ReplyDelete
  6. BEA_JAVA_HOME=""
    export BEA_JAVA_HOME

    SUN_JAVA_HOME="/usr/bin/java"
    export SUN_JAVA_HOME

    if [ "${JAVA_VENDOR}" = "Oracle" ] ; then
    JAVA_HOME="${BEA_JAVA_HOME}"
    export JAVA_HOME
    else
    if [ "${JAVA_VENDOR}" = "Sun" ] ; then
    JAVA_HOME="${SUN_JAVA_HOME}"
    export JAVA_HOME
    else
    JAVA_VENDOR="Sun"
    export JAVA_VENDOR
    JAVA_HOME="/usr/bin/java"
    export JAVA_HOME
    fi
    fi



    I have edited SUN_JAVA_HOME to be /usr/bin/java and /usr/lib/jvm/java-1.6.0-sun-1.6.0.29. Either way I get the same message.

    ReplyDelete
  7. do you only have "jre" directory under your "/usr/lib/jvm/java-1.6.0-sun-1.6.0.29". In my case I have "jre, include, lib & bin". Can you check with your SAs who does the JDK install if thats the correct JAVA HOME.

    ReplyDelete
  8. Yes I only have "jre" directory under /usr/lib/jvm/java-1.6.0-sun-1.6.0.29

    That is the correct java home. But there are a a whole bunch of linking going on and I'm confused.

    $ ls -lthr /usr/bin/java
    lrwxrwxrwx 1 root root 22 May 12 2011 /usr/bin/java -> /etc/alternatives/java

    $ ls -lthr /etc/alternatives/java
    lrwxrwxrwx 1 root root 35 Dec 5 14:48 /etc/alternatives/java -> /usr/lib/jvm/jre-1.6.0-sun/bin/java

    $ ls -lthr /usr/lib/jvm/jre-1.6.0-sun/bin/java
    -rwxr-xr-x 1 root root 49K Oct 3 09:51 /usr/lib/jvm/jre-1.6.0-sun/bin/java

    $ ls -lthr /usr/lib/jvm/jre-1.6.0-sun/bin/java
    -rwxr-xr-x 1 root root 49K Oct 3 09:51 /usr/lib/jvm/jre-1.6.0-sun/bin/java

    ReplyDelete
  9. Ok...now set your SUN_JAVA_HOME in setDomainEnv.sh to /usr/lib/jvm/jre-1.6.0-sun instead of /usr/lib/jvm/java-1.6.0-sun-1.6.0.29 and then try.

    ReplyDelete
  10. THANK YOU!!! I set both JAVA_HOME and SUN_JAVA_HOME to /usr/lib/jvm/jre-1.6.0-sun and it is now working...

    DO you have any idea why that wasn't working as defualt?

    ReplyDelete
  11. Is this normal:

    $ ./startWebLogic.sh

    .
    ***************************************************
    * To start WebLogic Server, use a username and *
    * password assigned to an admin-level user. For *
    * server administration, use the WebLogic Server *
    * console at http://hostname:port/console *
    ***************************************************
    starting weblogic with Java version:
    /u01/app/oracle/Oracle/Middleware/user_projects/domains/base_domain/bin/startWebLogic.sh: line 171: $: command not found
    Starting WLS with line:
    /usr/lib/jvm/jre-1.6.0-sun/bin/java -client -Xms256m -Xmx512m -XX:CompileThreshold=8000 -XX:PermSize=128m -XX:MaxPermSize=512m -Dweblogic.Name=AdminServer -Djava.security.policy=/u01/app/oracle/Oracle/Middleware/wlserver_10.3/server/lib/weblogic.policy -Xverify:none -da -Dplatform.home=/u01/app/oracle/Oracle/Middleware/wlserver_10.3 -Dwls...........
    ....




    then it is just hanging there.

    Thank you so much for all your help. i've been kind of thrown into trying to get this all running and configured.

    ReplyDelete
  12. If you implement Self Service on Weblogic does it change the Self Servide user interface? Our DBA mentioned that we might want to leave Self Service on OAS as it would require a lot of development if we went to Weblogic because a new war file was deployed. I'm not sure if he's referring to the Common UI (which we do not have implemented). Do you have any insight to this?

    ReplyDelete
  13. I think when you Self Service, it means you are referring to SSB. I dont think the weblogic changes the user interface. What is your version of banner?

    ReplyDelete