http://www.oraclelog.com Oracle web log. Sun, 06 Jul 2008 08:36:38 +0000 http://backend.userland.com/rss092 en 10.2.0.3 has a nasty bug, where one is not able to see what SQL is job actually executing, the following fix will resolve that partially. For parallel slaves the relevant v$session columns are still going to be empty. 5928612 SQL ADDRESS COLUMN IN V$SESSION VIEW FOR JOB IS ZERO This might be ... http://www.oraclelog.com/2008/07/06/oracle/empty-sql_id-and-other-columns-in-vsession-for-jobs-10203/ If you wonder what is the password for Oracle Internet Directory(OID) user cn=orcladmin after OIM installation, well, it is exactly the same as ias_admin password specified during installation of OIM. If you really want to reset the password, use included utility resetiASpasswd.sh in $ORACLE_HOME\bin as follows: First make sure your environment ... http://www.oraclelog.com/2008/04/04/oracle/oracle-identity-managementoim-how-to-reset-oid-cnorcladmin-password/ Oracle patchset 10.2.0.4 is now available via metalink for Windows(32bit) and Linux x86(32bit) platforms. Update 22.05.2008: Now available also for some 64 bit platforms like AIX5L 64. http://www.oraclelog.com/2008/04/02/oracle/oracle-patchset-10204/ [sql] ALTER SYSTEM SET GO_FASTER=TRUE; [/sql] http://www.oraclelog.com/2007/12/21/oracle/alter-system-set-go_faster/ If you've just upgraded from 9i to 10g, and you are using unsupported collection return types in pipelined functions you are no longer able to compile the code due to a more restrictive 10g compiler. Your pipelined functions compiled just fine on 9i. You are unable to compile the functions ... http://www.oraclelog.com/2007/12/21/oracle/pls-00630-unsupported-collection-return-types-10g-upgrade/ Microsoft Windows (1.7 GB) Linux x86 (1.7 GB) Linux x86-64 (1.8 GB) http://www.oraclelog.com/2007/10/24/oracle/oracle-11g-now-available-for-windows-and-64bit-linux/ I've recently came across excelent article/how-to for Oracle 11g RAC na Oracle Enterprise Linux 4(Update 5) a VMware Server 1.0.3. Thank you Frikkie. http://www.oraclelog.com/2007/10/02/oracle/oracle-11g-rac-na-oracle-enterprise-linux-4update-5-a-vmware-server-103/ Too much log switching is no good for database, you should see numbers not bigger than 6 per hour. Increasing the size of redo log groups is one way to lower log switch frequency, please refer to Oracle documentation on how to lower log switch frequency. You can use the following ... http://www.oraclelog.com/2007/07/17/oracle/determining-log-switch-frequency/ You can determine users idle time using the following query: [sql] SELECT SID, SERIAL#, USERNAME, (CASE WHEN EXTRACT (DAY FROM (NUMTODSINTERVAL (SYSDATE - (SYSDATE - LAST_CALL_ET), 'SECOND'))) > 0 THEN EXTRACT (DAY FROM (NUMTODSINTERVAL (SYSDATE - ... http://www.oraclelog.com/2007/07/17/oracle/how-to-determine-users-idle-time/ Our Linux OAS should be started using the same NLS_LANG as client is using, in our case NLS_LANG=SLOVAK_SLOVAKIA.EE8MSWIN1250 [css] export NLS_LANG=SLOVAK_SLOVAKIA.EE8MSWIN1250 cd $ORACLE_HOME/opmn/bin # restart OAS ./opmnctl stopall opmnctl: stopping opmn and all managed processes... ./opmnctl startall opmnctl: starting opmn and all managed processes... [/css] Assuming that there are eastern european characters used in your FMB files in labels, etc.. You ... http://www.oraclelog.com/2007/07/17/oracle/oracle-application-server-on-linux-with-eastern-european-characters-how-to/