Andreas' Adventures

I just found a tool called Insider on http://www.fourthelephant.com/ Just have a look at the screenshots on their site or download it. Gives a very cool overview of the status of your database. You can't compare it with GridControl but the graphical capabilities rock!

An OC4J with its own Reports Server might hang (seen under Linux when starting Reports from Forms). In the trace file you might see Formatting page 1 and it will never return from there. Remedy is to set pdfcomp=no

Change the $ANT_HOME/bin/ant to perl $ANT_HOME/bin/runant.pl to get the coresv.sh start running.

When you still have a 10.1.2 version you need to apply patch 4325060. Later on you move into the OID and change the attribute of the orcluser and orcluserv2 from structural to auxiliary in order to add it to the workflow tab.

When configuring the CRS make sure that you choose the right network for the public and private connection. If the CRS root.sh scripts hangs during the installation and the error is oac_init:2: Could not connect to server, clsc retcode = 9 then the cause is almost certain a mismatch in the network setting.

Unpack the rpm.bin Install the rpm Change alternatives: update-alternatives --install /usr/bin/java java /usr/java/j2sdk1.4.2_07/bin/java 100 update-alternatives --config java There are 2 programs which provide 'java'. Selection Command ----------------------------------------------- *+ 1 /usr/share/java/libgcj-java-placeholder.sh 2 /usr/java/j2sdk1.4.2_07/bin/java Enter to keep the current selection[+], or type selection number: 2 Do the same with javac

To enable debug logging of the unidas process (DAS): Set the following parameters in unison.ini: [DAS] log_debug = TRUE log_trace = TRUE log_modulesinclude = { "CTLDAP*" } Restart the calendar server. The additonal debug information is recorded in (for example): $ORACLE_HOME/ocal/log/das.log file

Installation 9.0.4 Collaboration Suite with RH 3.0 needs the following setting: LD_ASSUME_KERNEL=2.4.19 If you receive a SSORunning INVALID move the /etc/oratab to a new file and create an oratab with only the asdb entry.

Yes, they will! DBMS_JOB executes in the context of a user. Use the following to test: Create a table: create table out_ctx (usr_ctx number); Create a procedure: create procedure test_ctx as usr_ctx number; begin select sys_context('MY_CONTEXT','USER_ID') into usr_ctx from dual; insert into out_ctx values (usr_ctx); commit; end; Spool the job: BEGIN DBMS_JOB.SUBMIT(:jobno, 'test_ctx;', SYSDATE, 'SYSDATE + 1/720'); COMMIT; END; / PRINT jobno Check the result: select * from out_ctx; Delete the job: BEGIN DBMS_JOB.REMOVE(&job_number); END; /

Use Note 69408.1 Create the kkoipt_table, set the event to 10060 and do some tests Another great source of information is http://www.petefinnigan.com/papers/rls.sql

This will be a quick guide on how to use the VPD feature in an Oracle database. Start with creating a package that will fill your context. create or replace package user.mypackage is procedure set_user_id_context; end; Here comes the package body: create or replace package body user.mypackage is procedure set_user_id_context is sec_user_id number; begin -- -- in this case we have a table that holds my users and each user has a code -- select code into sec_user_id from usr where upper(id) = upper( sys_context( 'USERENV' ,'SESSION_USER...