Bravery Family

Category: Oracle

  • eBusiness Autoconfig Customisation

    Why customise? Autoconfig Customisation has the potential to make life much easier for an Oracle Applications DBA. In short, it enables the creation of controlled templates that can make all of the things that have to be done after running autoconfig go away. For example, generally after you run adautocfg.sh you then have to remember…

  • Time zones, Oracle Agents, Java, and the paths to madness…..

    I was attempting to re-install the Grid Control agents on two RHEL 6 servers today today. They’d had been upgraded from RHEL 5 to 6 and I wanted to see what needed to be done to re-attach them to Grid Control if we didn’t take the existing installation. I was having some issues with it…

  • Using Oracle InstantClient 11g with PHP onto RHEL 5 with SELinux

    This is an example of using the Oracle InstantClient 11g with PHP. Installation InstantClient for PHP This is based on work from the past – but I appeared to have done the following: Installed InstantClient and Pear to manage the php installation. sudo yum install php-pear sudo rpm -ivh oracle-instantclient11.1-basic-11.1.0.7.0-1.i386.rpm sudo rpm -Uvh oracle-instantclient11.1-devel-11.1.0.7.0-1.i386.rpm Update…

  • Oracle eBusiness Submit Job – PL/SQL

    Again, a simple piece of code: This also runs Active User concurrent program: declare  v_request_id number := -1;begin  –fnd_global.apps_initialize(user_id, resp_id, appl_resp_id)  fnd_global.apps_initialize(0, 20420, 1); –So sysadmin using responsibility System Administrator in application System Administration  –v_request_id : fnd_request.submit_request(application short name,concurrent program short name,argument1 =>,  argument2 =>))  v_request_id := fnd_request.submit_request(application=>’FND’,program=>’FNDSCURS’);  commit;  if v_request_id > 0  then    dbms_output.put_line(‘Successfully…

  • 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…