For some reason the search does not work. It’s frustrating me and others. Here is a little work around that I’ve trialed
Above I’m searching for PDF on my blog, you can edit it how you want.
I might also look for a better solution, but what is better than google??? Nothing…
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
Create
Enter your database details
Check
Next
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
Enter your password
You need to change the two passwords as a minimum, above
create Table spaces
Create
Then, the process runs for ages (for us anyway, we are using an old VM machine)
Then you can run the SOA installer!
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.
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.
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.
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.
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.
Then in BIP you can use the DAD connection for queries:
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.
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:
“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
913Kb file above, install it. You can install this on 64 windows.
Yeah baby!
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!
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=$3cc -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.old -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
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.
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:
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:
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!
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!
Are you running OAS
Did you change the webguistylesheet.css
Are you getting one of these
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, <%@ 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
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.
