DBA in the Trenches

I have run across a problem of trying to view XML but then having some kind of hassle with the browser showing the XML. This is a little work around to show the XML in a local application, I use Notepad++ First need to add the option to view XML with Excel. Sys Admin \ Install \ Viewer Options The next is to change the default in the profile to view the XML with Excel as a default. If you leave this null it will ask you each time so you could do it that way. Sys Admin \ Profile \ System Next is the little work around. You need to save the file locally as xml. So instead of opening it with Excel you save it as xml and then you can open it locally and see all the data as required. Save locally

Needed to disable the firewall on a new Centos virtual machine I'm setting up. Used the following commands from NixCraft Disable Linux Firewall Type the following two commands: [ root@machine ~] /etc/init.d/iptables save [ root@machine ~] /etc/init.d/iptables stop Turn off firewall on boot: [ root@machine ~] chkconfig iptables off Enable Linux Firewall  Type the following command to turn on iptables firewall: [ root@machine ~] /etc/init.d/iptables start Turn on firewall on boot: [ root@machine ~]# chkconfig iptables on

The first thing do do is to check whether the history is set: set -o | grep history If it is off then add the following to the ~/.bashrc: set -o history At the same time set the environment variables for holding the history export HISTFILE=$HOME/.bash_history export HISTSIZE=500 export HISTFILESIZE=500 This should have you up and running to get the history To make sure the effects take place change the user with [test@server ~] oracle -

On the Application Tier cd $COMMON_TOP/admin/scripts/CONTEXT_NAME ./adstpall.sh apps/APPS_PWD ###############GOTCHA ############### The Concurrent manager takes quite a while to shutdown. To work around this first shutdown the Concurrent manager with the abort command. ./adcmctl.sh abort apps/APPS_PWD ./adstpall.sh apps/APPS_PWD ####################################### On the Database Tier cd $ORACLE_HOME/appsutil/scripts/ ./addlnctl.sh stop ./addbctl.sh stop immediate Resource: Oracle-Base (Great Resource in General)

So you want to create a Concurrent Program that will run some code on the environment your application is installed on? OK but you also want to use the environment variables that are setup. Seems reasonable. Well I ran into a problem when trying to build a string and then run it. The Story I have a table that I store various commands related to an object. For this example say I want to use FNDLOAD to upload or download a concurrent program I would use something like this: FNDLOAD apps/$APPLPWD 0 Y DOWNLOAD $FND_TOP/patch/115/import/afcpprog.lct ./MY_CONC.ldt PROGRAM APPLICATION_SHORT_NAME=XXX CONCURRENT_PROGRAM_NAME=MY_CONC So far makes sense but if I want to automate this and seeing as FNDLOAD is pretty standard with its layout i placed the data into the table and made some fields that I change using replace. Not that important but when running the program using a HOST concurrent I was running into trouble. All the fields can be setup using replace except for the apps password...

Dear Hilton Meyer, Thank you for your interest in the Oracle Public Cloud. We have now entered the preview availability phase. Over the next several months, we will be releasing capacity of our cloud in batches to early registrants. To request access and get in the queue, go to   cloud.oracle.com  and follow these two steps: Register to get your  oracle.com  account if you don't already have one Confirm the cloud service(s) you want to trial This information is required for us to activate your account for Oracle Public Cloud services when they become available. Register now at cloud.oracle.com.  On this site, you’ll also find additional background materials and an updated FAQ with more information on our preview availability phase. Start Now Stay Connected       Copyright © 2011, Oracle and/or its affiliates. All rights reserved. Contact Us  |  Legal Notices  |  Privacy

public class SimpleJava {       public void showMessage() {       System.out.println("Here we are");    } }    Ran into this small little problem when compiling java to use in an Oracle procedure. ORA-29516: Aurora assertion failure: Assertion failure at eox.c:359 Uncaught exception System error: java/lang/UnsupportedClassVersionError I could understand that I had somehow compiled the class using an incorrect version but seeing as I had done this from the server I thought I would have been OK. A bit of digging and I came up with the following: Find the version the class was actually compiled in: javap -verbose SimpleJava This gave the following output along with some other info: public class SimpleJava extends java.lang.Object SourceFile: "SimpleJava.java" minor version: 0 major version: 50 Table of versions: major  minor Java platform version  45       3       ...