About Me

My photo
I work for Fusion5 Australia . Connect with me on linked in here . I'm raising money for a good cause at the moment, follow donate to leukemia foundation

Friday, 26 November 2010

Want to search my blog

For some reason the search does not work.  It’s frustrating me and others.  Here is a little work around that I’ve trialed

http://www.google.com.au/search?q=PDF+site:http://shannonscncjdeblog.blogspot.com&hl=en&num=10&lr=&ft=i&cr=&safe=images

Above I’m searching for PDF on my blog, you can edit it how you want.

http://www.google.com.au/search?q=SEARCH TERM+site:http://shannonscncjdeblog.blogspot.com&hl=en&num=10&lr=&ft=i&cr=&safe=images

I might also look for a better solution, but what is better than google???  Nothing…

Thursday, 18 November 2010

Installing fusion middleware 11G

Read the instructions I always say…  I don’t always do…

I’ve installed the middleware, but nor run the rcu.bat “Repository Creation Utility”.

So, I had to download this from:  http://www.oracle.com/technetwork/middleware/downloads/fmw-11-download-092893.html, more specifically search for Repository Creation Utility (11.1.1.2.1)

download the 300ish Mb and extract zip file

goto bin dir and run rcu.bat

image

Create

image

Enter your database details

image

Check

image

Next

image

I needed to connect as user sys using sysdba privs.  Note that I did not select the identity management schemas, as they are a little sensitive

image

Enter your password

image

You need to change the two passwords as a minimum, above

image

create Table spaces

image

Create

image

Then, the process runs for ages (for us anyway, we are using an old VM machine)

image

Then you can run the SOA installer!

emctl show em status and URL

Quite often I struggle to remember the URL for oracle DB em and also struggle to know if it’s up…  Well, here is the solution.

login to DB machine as oracle

emctl status dbconsole

[oracle@E1DB ~]$ emctl status dbconsole
Oracle Enterprise Manager 11g Database Control Release 11.2.0.1.0
Copyright (c) 1996, 2009 Oracle Corporation.  All rights reserved.
https://E1DB.MITS.LOCAL:1158/em/console/aboutApplication
Oracle Enterprise Manager 11g is running.
------------------------------------------------------------------
Logs are generated in directory /u01/app/oracle/product/11ovm/db_1/E1DB.MITS.LOCAL_jdevm/sysman/log

I thought I blogged this, but I cannot find it.

New location, new professional attitude, new look

I’ve gone up market and moved from http://moistymoistymoisty.blogspot.com to http://shannonscncjdeblog.blogspot.com  for obvious reasons.  Hopefully followers can see the change and get told about it.

More BI Publisher

I’ve been doing some work on a POC for embedded BIP and will be writing a few things about it’s functionality.

Previously all intermediate files and PDF files were only available temporarily while the process was running, now this has all changed.

When BIP is enabled for a report in E1, the report produces an XML file which is the raw data and it also produces all of the output files - which JDE also stores - in tables!

· F95630 contains the XML data created from the UBE run.

· F95631 contains the actual output files.

So, VERY easily a UBE could be written or a DB procedure to extract the files to a flat file location.

Note that you can also activate some JDE.INI settings to write them to the local machine, and therefore script them out to another dir too:

[UBE] section
BipSaveOutputOnFs= 0 or 1

A value of 1 enables the archiving of Report Definition Output. The default value is 0 (zero).  If the value is 0, archiving is turned off and report output is saved only in the F96531 table, not in the file system.
BipOutputDirectory=

https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&doctype=HOWTO&id=816003.1

A client that does a lot of XMLP / BIP will need to be very wary of growth in this tablespace.

Wednesday, 17 November 2010

my DAD server

Data access driver I mean.

It’s a strange beast, so I thought that I write some things down about it.  Firstly you cannot start or stop it, so yeah…  That it a little weird.  Well, at least you cannot start and stop it from Server Manager.

You also don’t need to download a software component for it, it just seems to exist.

I installed BIP on OEL, which eventually installed to a path like:

/home/oracle/OraHome_1/oc4j_bi/j2ee/home/applications/xmlpserver/xmlpserver/WEB-INF/lib

The DAD install seems to bang a bunch of JAR files in the dir above, you can see this from the .properties file in the server manager agent directories.

I also think that this thing starts when you access it from BIP, i.e. when the jars are loaded into memory.  So you need to get all of the settings right first.

image

Once these are in, then you can test the connection.  If the test works, the SM will tell you DAD is working

Note also that you need to enter the tnsnames.ora details into the SM config for the application.

image

Then in BIP you can use the DAD connection for queries:

image

Tuesday, 16 November 2010

Oracle BI Publisher and 64 bit office

This combo will not work…  Well it did not work for me.  When I had office downgraded, everything worked like a peach!  What an awesome waste of time!  Office 2010 32 bit is fine, office 2010 64 bit does not work.

Monday, 15 November 2010

bi publisher desktop won’t install

I’m running windows 7 virtual on OVM with office 2010.  Have E1 fat boy and oracle 11G client.  I’m using this machine for some BIP prototype work – cool.

But, I keep getting:

image

“Template Builder Installer failed": Unexpected Error”

People are putting all sorts of stuff on forums that look like pot shots.  “Try uninstall and install again” – huh??? Call me Mr. Crazy trousers, but computers generally do the same thing given the same input.

How about I find some log files and go from there.

C:\Users\ShannonM\AppData\Local\Temp has TemplateBuilderInstaller.log – WOW!  direct hit.

This has:

Word process check start
Error No.: 339
Description: Component 'MSCOMCTL.OCX' or one of its dependencies not correctly registered: a file is missing or invalid

WOW again, direct hit.

I need to install this file, mscomctl.ocx does not exist on my machine

http://www.microsoft.com/downloads/en/details.aspx?FamilyID=25437d98-51d0-41c1-bb14-64662f5f62fe&displaylang=en

913Kb file above, install it.  You can install this on 64 windows.

image

Yeah baby!

image

Hmm, we’ll see

Right…  That did not work, even when I tried the repair…  Damn!

I tried a few other things, and then..

http://www.ascentive.com/support/new/support_dll.phtml?dllname=MSCOMCTL.OCX

Downloaded this file (the file only)

regsvr32 full path to mscomctl.ocx

restart the installation!

Friday, 12 November 2010

script to compile external function on AIX to link in JDE functions

I use the script below to compile an OSA program on AIX for 812 release.  This should be pasted into a ksh script and made executable.

You can then run it as you JDE user, it should find most things dynamically. Actually, there are heaps of paths that you are going to need to change.

#!/usr/bin/ksh
if [ $# -ne 3 ]
  then
    echo "Your parameter count of $# is wrong"
    echo "USAGE $0 <source module> <FULL PACKAGE> <output filename>"
    echo "Note this is WITHOUT extensions for the sourcefilename"
    echo "eg:  $0 CUBOutput DV9FA libCUBOSA.sl"
    exit
fi

SOURCE=$1
FULLPACKAGE=$2
OUTPUT=$3

cc -qalign=natural -qflag=I:I -c -O2 -DKERNEL -DPRODUCTION_VERSION -DNATURAL_ALIGNMENT -DUSESPECIALGPA4BB -DUSETABLEHEADERFROMINCLUDEA -I/apps/j
deapp/e812/packages/${FULLPACKAGE}/include/ -I/apps/jdeapp/e812/system/include -I/apps/jdeapp/e812/system/include/xml -I/apps/jdeapp/e812/system
/includev $SOURCE.c -o $SOURCE.o
if [ $? -ne 0 ]
  then
    echo "Compilation failed, please fix errors and try again"
    exit
fi
ls -l $SOURCE.o

ld -b32 /lib/crt0.o -bpT:0x10000000 -bpD:0x20000000  -bI:/apps/jdeapp/e812/system/bin32/funclist.imp -bM:SRE -bexpall -brtl -lc -lm -bnoentry -L
. -L/apps/jdeapp/e812/system/lib -ljdelib -lcallobj -lerror -lgentext -ljdb -ljde_erk -ljdecache -ljdeddapi -ljdeknet -ljderepl -ljdeschr -ljdes
ec -ljdespec -ljdetam -llanguage -lmisc -lpackage -lport -lqueueknl -lruntime -lsrc -ltransmon -lube -lworkflow -ljdesaw -ljdenet -lowver -ljdeu
nicode -lv_verify -lxerceswrapper -ltextsearch -lxmlpublisher -bloadmap:loadmap -o $OUTPUT $SOURCE.o -L/usr/vac/lib -lxlopt -L/usr/lib/threads -
lpthreads -lc
if [ $? -ne 0 ]
  then
    echo "Linking failed, please fix errors and try again"
    exit
fi

xm – xen manager for OVM

We are running a bunch of OVM in the office for our demo systems, it’s very cool.  I’m quite new to all of this, so apologies for the numpties view.

image

Above is the console that you do all your VM management from.  It’s pretty basic, but you can get the job done.  We have 10 virtual machines listed.

You can see the actual IRON that you’re using under the servers tab:

image

So I want to see what is going on on my host in terms of disk and CPU.  One of the guest machines is going bonkers and I want to see what the host is doing…  What do I do?

ssh (via putty [best software in the world{except for vi}]) to the server listed under the servers tab and execute:

xm top

This will give you a view of what the various machines are doing behind the scenes:

image

Note that top gives you nothing, you need to use the xm top function.

xm – xen management

from man:

DESCRIPTION
       The xm program is the main interface for managing Xen guest domains. The program can be used to create, pause, and shutdown domains. It can also be
       used to list current domains, enable or pin VCPUs, and attach or detach virtual block devices.

xm list

[root@MYRSVMH5D ~]# xm list
Name                                        ID   Mem VCPUs      State   Time(s)
130_E1BSS                                  128  2048     2     -b----   3909.9
135_CRAIGDB10                              129  2048     2     -b----  27540.2
151_E1DEV2                                 160  4096     1     -b----   2229.8
99_E1DEPR2                                 131  4096     2     r----- 197255.2
Domain-0                                     0   563    16     r----- 363896.7
E1DB                                        18  8192     4     ------ 221778.2
E1ENT                                       33  4096     2     -b---- 110251.5
E1WEB                                       43  2048     2     -b----  90064.1
MYRSOVMM                                     1  2048     2     -b----  33083.4

This stuff is too easy and too cool!

Wednesday, 10 November 2010

Check if oracle em is running and find the URL

At the command line, signed in as oracle:

[oracle@E1DB db_1]$ emctl status dbconsole
Oracle Enterprise Manager 11g Database Control Release 11.2.0.1.0
Copyright (c) 1996, 2009 Oracle Corporation.  All rights reserved.
https://E1DB.MITS.LOCAL:1158/em/console/aboutApplication
Oracle Enterprise Manager 11g is running.
------------------------------------------------------------------
Logs are generated in directory /u01/app/oracle/product/11ovm/db_1/E1DB.MITS.LOCAL_jdevm/sysman/log

This is going to help me a lot!

Wednesday, 3 November 2010

JDE login page without styles missing graphics – I changed the css - OAS

Are you running OAS

Did you change the webguistylesheet.css

Are you getting one of these

image

Don’t fear, there is a solution!

you have a corrupt web.xml

you’ll find the following in the log.xml, which will be in a location like

/u01/product/10.1.3.1/OracleAS_1/j2ee/TR812/log/TR812_default_group_1/oc4j

    <MSG_TEXT>Unable to dispatch JSP Page : Exception:oracle.jsp.parse.JspParseException: /share/css/webguistylesheet.jsp: Line # 2, &lt;%@ taglib prefix="webgui"       uri="http://java.peoplesoft.com/e1/webgui"%>

Error: "http://java.peoplesoft.com/e1/webgui" is not a registered TLD namespace. </MSG_TEXT>

You’ll need to follow steps in http://moistymoistymoisty.blogspot.com/2010/03/500-errors-logging-into-jde-and-then-on.html

gnome-session in OEL

I needed to run a graphical session on my OEL machine to change the date and time.  I have this post which shows me how to start an Z session via VNC: http://moistymoistymoisty.blogspot.com/2010/10/running-oracle-install-on-linux-oel.html – but I had to take this a step further and see a desktop and goto administration –> date and time.

Sure I could fumble my way through command line options – but this was bound to go wrong on a production machine.  I also needed to check the timezone settings, which could also take me a little bit of time.

The simple answer is to run “gnome-session” after setting up your vnc environment.  I know that this IS very simple, but when you don’t do it every day – it’s nice to write it down for next time.