Travels in Technology!
-
Oracle eBusiness Submit Job – Command line
The below code is the simplest way of doing a job submission for a concurrent program in eBusiness Suite: CONCSUB <db user>/<db password> <user> <role> <application group> WAIT=<Y|N> CONCURRENT <application> <application short name> PROGRAM_NAME=”<long name>” So, as an example take the following command: CONCSUB apps/<password> SYSADMIN “System Administrator” SYSADMIN WAIT=N CONCURRENT FND FNDSCURS PROGRAM_NAME='”Active Users”‘…
-
User Certificates in Oracle Wallet
Since I spent an age getting Oracle Wallet working with User Certificates , so I decided to blog about it, collecting all that I needed into one place. Why do you need user certificates in an Oracle Wallet? We have several Oracle ApEx applications at work. A new one that is being proposed will need…
-
Configure BIEE BI Publisher Scheduler with MySQL
I was keen to use the BI Publisher Scheduler and configure it to use a MySQL database. The instructions for this imply that you need to hunt around and find out how to register the JDBC library for MySQL. The reality with the Oracle Application Server or standalone OC4J is much simpler than that. Put…
-
Configure BIEE Scheduler with MySQL
I am using a Windows PC to do this, so the instructions may not directly translate to UNIX/Linux. Create a database for BIEE to use.Create the objects required using this script (this is a tweaked version of the standard SAJOBS.DB2.sql script):CREATE TABLE S_NQ_JOB ( JOB_ID decimal(10,0) NOT Null, NAME varchar (50) , DESC_TEXT varchar (255) …
-
Installing Oracle InstantClient on Linux
This was very quick and easy to to actually! I transferred the 11i client (basic and the SQL*Plus bit) to my central server, and extracted out the software.Then I copied the executables to my bin directory, and the libraries to the lib directory.Finally, I moved glogin.sql to my sql directory.All I then had to do…
-
Running WinHlp32.exe on Vista
OK, we have an application at work who’s help wasn’t working under Vista SP1.Had a hunt, found this on the Microsoft web site. In short, download a patch from here to install the executable.There are 32bit and 64bit installation packages. You now need to create the following entries in the registry. Create the folder:HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\WinHelpNext create…
-
First batch is in.
Quite relieved to have the first chunk out of the way. I really must go back over some of them, and see how relevant they still are… You never know, someone else might be looking for a “What a DBA should really know about 10gAS R3!” document.I can also put in my warnings about Oracle…
-
Getting there….
… but it is taking a while though. I think I will try to focus on the performance based notes first. All that being said, I have transcribed my notes on my first installation of the Oracle eBusiness Suite and psychologically it feels good to get it all typed in! Gavin
-
Uggghhhh… first post.
As part of my continuing attempts to use this site I’ve made properly, I’ve decided to sort out my study. So, today I’ve mostly been reading old UKOUG notes… I seem to have several dozen pages worth of notes for when I’ve been to UKOUG Conferences over the last few years… I’m going to transfer…