Просторы интернета
19 Февраль 2015
Earlier
Пт, Дек 10, 2010
Whenever raise SR with Oracle support for R12 application logging related issue, they will ask you to produce the logging details by enabling the Apache, OC4J and OPMN components and its services. Compared to 11i, Oracle Applications R12 introduces new easy way in order to enable logging for any [...]
Source: oracleajidba.blogspot.ruВт, Дек 07, 2010
Always good to know the long running request SID information of apps for analysis and troubleshoot purpose. The following query will help to identify that, pass long running 'request id' as parameter
SELECT a.request_id, d.sid, d.serial# ,d.osuser,d.process
FROM apps.fnd_concurrent_requests a,
apps.fnd_concurrent_processes b,
v$process c,
v$session d
WHERE a.controlling_manager = [...]
Source: oracleajidba.blogspot.ruSELECT a.request_id, d.sid, d.serial# ,d.osuser,d.process
FROM apps.fnd_concurrent_requests a,
apps.fnd_concurrent_processes b,
v$process c,
v$session d
WHERE a.controlling_manager = [...]
Пн, Дек 06, 2010
Its better to know the relinking of oracle software manually when there is a situation like
An OS upgrade has occurred.A change has been made to the OS system libraries. This can occur during the application of an OS patch.A new install failed during the relinking phase.Individual Oracle [...]
Source: oracleajidba.blogspot.ruAn OS upgrade has occurred.A change has been made to the OS system libraries. This can occur during the application of an OS patch.A new install failed during the relinking phase.Individual Oracle [...]
Вс, Дек 05, 2010
As I have promised earlier post, I am writing the startup steps of OBIEE 11g on linux box. Before that make sure that FMW(Fusion Middle Ware) Repository database and the listener are up and running. If database status is running, we can start. Or else start the database and [...]
Source: oracleajidba.blogspot.ruПт, Дек 03, 2010
In this article we are going to create Dependent LOV [List of Values] without writing a single line of code.
Below are the two list of values – LOV we are going to create. Supplier is an independent Lov and SupplierSite would be the dependent to Supplier one..Supplier [...]
Source: oracleanil.blogspot.ruBelow are the two list of values – LOV we are going to create. Supplier is an independent Lov and SupplierSite would be the dependent to Supplier one..Supplier [...]
Пт, Дек 03, 2010
In this article we are going to create Dependent LOV [List of Values] without writing a single line of code.
Below are the two list of values – LOV we are going to create. Supplier is an independent Lov and SupplierSite would be the dependent to Supplier one. . Supplier [...]
Source: oracleanil.blogspot.ruBelow are the two list of values – LOV we are going to create. Supplier is an independent Lov and SupplierSite would be the dependent to Supplier one. . Supplier [...]
Пт, Дек 03, 2010
As part of Extended support for 11i, upgrade Developer 6i patchset 19 is a must, this post will help to you do so. I am writing the "step-by-step" upgrade instructions for linux box
*** All patches must be installed on all Application tier nodes
Stop all application processes by [...]
Source: oracleajidba.blogspot.ru*** All patches must be installed on all Application tier nodes
Stop all application processes by [...]
Чт, Дек 02, 2010
As we are all knows premier support for Oracle E-Business Suite Release 11i ends yesterday, November 30, 2010. Extended Support for EBS 11i begins today, December 1st, 2010. And a new set of minimum technical requirements for Apps 11i goes into effect. The new minimum baseline patch requirements for Extended [...]
Source: oracleajidba.blogspot.ruВт, Ноя 30, 2010
After successful intallation of OBIEE 11g on linux box, I am thinking about Admin tool.exe on my laptop, but required Windows box to run that. As a work around, did a fresh installation of OBIEE 11g software again on my local Windows XP machine. After than I have copied the [...]
Source: oracleajidba.blogspot.ruВт, Ноя 30, 2010
Yesterday, I have installed OBIEE11g to my laptop. Installation was successful and working fine to me. But after that I have encountered issues connecting to the database using my existing connection string. I have added these db connection string to the OBIEE11g home tnsnames.ora file but no luck.
I have [...]
Source: oracleajidba.blogspot.ruI have [...]
Сб, Ноя 27, 2010
Here is a way you can test & create DBC file from the application.
First of all Login to Oracle application for which you want to generate the DBC file referring below URL
http://hostname:port /OA_HTML/ jsp/fnd/aoljtest.jsplikehttp://anil.apps.com:8000/OA_HTML/jsp/fnd/aoljtest.jsp
In the below page enter the required details such as Apps schema [...]
Source: oracleanil.blogspot.ruFirst of all Login to Oracle application for which you want to generate the DBC file referring below URL
http://hostname:port /OA_HTML/ jsp/fnd/aoljtest.jsplikehttp://anil.apps.com:8000/OA_HTML/jsp/fnd/aoljtest.jsp
In the below page enter the required details such as Apps schema [...]
Сб, Ноя 27, 2010
Here is a way you can test & create DBC file from the application.
First of all Login to Oracle application for which you want to generate the DBC file referring below URL
http://hostname:port /OA_HTML/ jsp/fnd/aoljtest.jsp like http://anil.apps.com:8000/OA_HTML/jsp/fnd/aoljtest.jsp
In the below page enter the required details such as Apps schema name, Password, SID etc [...]
Source: oracleanil.blogspot.ruFirst of all Login to Oracle application for which you want to generate the DBC file referring below URL
http://hostname:port /OA_HTML/ jsp/fnd/aoljtest.jsp like http://anil.apps.com:8000/OA_HTML/jsp/fnd/aoljtest.jsp
In the below page enter the required details such as Apps schema name, Password, SID etc [...]
Пт, Ноя 26, 2010Source: oebsblog.ru
Внезапно обнаружил, что Visio 2007 считает, что в русском языке письмо происходит справа налево. Точнее, пишется-то слева на право, а вот курсор двигаться должен наоборот. Т.е. нажимаешь стрелку влево - курсор движется вправо. Оказывается связано это с языковыми параметрами - в русских шаблонах зашит атрибут справа-на-левного написания. Честно говоря, я [...]
Чт, Ноя 25, 2010
I would like to share my experience of installation of OBIEE 11g on linux with you all.
There are four steps
Oracle Enterprise Linux 5.5 InstallationOracle Database 11g R2 InstallationRepository Creation Utilityand Oracle Business Intelligence 11g InstallationOnce you have restarted your linux box, do the [...]
Source: oracleajidba.blogspot.ruThere are four steps
Oracle Enterprise Linux 5.5 InstallationOracle Database 11g R2 InstallationRepository Creation Utilityand Oracle Business Intelligence 11g InstallationOnce you have restarted your linux box, do the [...]
Чт, Ноя 25, 2010
Please makes sure that the following or later versions of packages are successfully installed along with operating system. These are pre-requisite for oracle 11g installation.
binutils-2.17.50.0.6compat-libstdc++-33-3.2.3elfutils-libelf-0.125elfutils-libelf-devel-0.125elfutils-libelf-devel-static-0.125gcc-4.1.2gcc-c++-4.1.2glibc-2.5-24glibc-common-2.5glibc-devel-2.5glibc-headers-2.5kernel-headers-2.6.18ksh-20060214libaio-0.3.106libaio-devel-0.3.106 libgcc-4.1.2libgomp-4.1.2libstdc++-4.1.2 libstdc++-devel-4.1.2make-3.81numactl-devel-0.9.8.i386sysstat-7.0.2
To use ODBC, you must also install the following additional 32-bit ODBC RPMs, depending on your operating system: unixODBC-2.2.11 (32-bit) or [...]
Source: oracleajidba.blogspot.rubinutils-2.17.50.0.6compat-libstdc++-33-3.2.3elfutils-libelf-0.125elfutils-libelf-devel-0.125elfutils-libelf-devel-static-0.125gcc-4.1.2gcc-c++-4.1.2glibc-2.5-24glibc-common-2.5glibc-devel-2.5glibc-headers-2.5kernel-headers-2.6.18ksh-20060214libaio-0.3.106libaio-devel-0.3.106 libgcc-4.1.2libgomp-4.1.2libstdc++-4.1.2 libstdc++-devel-4.1.2make-3.81numactl-devel-0.9.8.i386sysstat-7.0.2
To use ODBC, you must also install the following additional 32-bit ODBC RPMs, depending on your operating system: unixODBC-2.2.11 (32-bit) or [...]
Чт, Ноя 25, 2010
Download V22398-01.zip from edelivery.oracle.com Oracle Fusion Middleware Repository Creation Utility 11g (11.1.1.3.3) for Linux x86. To extract the contents of the zip file to the staging directoryHere I have created one user called applmgr for OBIEE installationWhen you have unzipped V22398-01.zip, this will produce a directory called rcuHome. Change [...]
Source: oracleajidba.blogspot.ruЧт, Ноя 25, 2010
Download the following from edelivery.oracle.comOracle Business Intelligence 11g (11.1.1.3.0) for Linux x86 (32-bit) (Disc 1 of 2) V22330-01 Part 1 of 2Oracle Business Intelligence 11g (11.1.1.3.0) for Linux x86 (32-bit) (Disc 1 of 2) V22330-01 Part 2 of 2 Oracle Business Intelligence 11g (11.1.1.3.0) for Linux x86 [...]Source: oracleajidba.blogspot.ru
Download the following from edelivery.oracle.comOracle Business Intelligence 11g (11.1.1.3.0) for Linux x86 (32-bit) (Disc 1 of 2) V22330-01 Part 1 of 2Oracle Business Intelligence 11g (11.1.1.3.0) for Linux x86 (32-bit) (Disc 1 of 2) V22330-01 Part 2 of 2 Oracle Business Intelligence 11g (11.1.1.3.0) for Linux x86 [...]
Сб, Ноя 13, 2010
Thanks Ajay for sharing this wonderful article on View Object extension
In the article we are going to extend QueryVO of EmployeeSearch page.
Our business requirement is to add employee Title and MiddleName column in the results table region
Analyzing the Page
[...]
Source: oracleanil.blogspot.ruIn the article we are going to extend QueryVO of EmployeeSearch page.
Our business requirement is to add employee Title and MiddleName column in the results table region
Analyzing the Page
[...]
Пн, Ноя 08, 2010
Application Module Extension in OAF
Like the Controller extension, AM extension is also not supported by Oracle. However for some business needs we have to extend it sometime.
In this exercise we have taken the standard LabSolutions project (shipped in Oracle Tutorial) for extending application module i.e. EmployeeAM.
[...]
Source: oracleanil.blogspot.ruLike the Controller extension, AM extension is also not supported by Oracle. However for some business needs we have to extend it sometime.
In this exercise we have taken the standard LabSolutions project (shipped in Oracle Tutorial) for extending application module i.e. EmployeeAM.
[...]
Пн, Окт 18, 2010Source: oebsblog.ru
В OEBS есть масса вьюшек, внутри которых зашиты пользователе-ориентированные условия, такие как определения языка, например. Т.е. если пользователь залогинился в русском интерфейсе, вьюха будет выдавать результат на русском. При использованнии "в лоб таких вьюх в SQL-инструментах (developer, navigator, toad и т.п.), они выдают пустой результат (ну оно и понятно). Чтобы [...]
Сб, Окт 16, 2010
Начиная с версии 11.2.0.2 patch set, Oracle Database является полной инсталяцией программного обеспечения базы данных. Теперь не требуется инсталировать Oracle Database 11g Release 2 (11.2.0.1) перед инсталяцией Oracle Database 11g Release 2 (11.2.0.2). [...]
Source: atyshenko.blogspot.comСр, Окт 06, 2010
Сохранить план запроса можно следующим образом:
create outline MY_OUTLN for CATEGORY special ON select * from dba_extents;
Просмотр сохраненного плана запроса:
select * from outln.ol$hints where ol_name='MY_OUTLN' order by hint# [...]
Source: atyshenko.blogspot.comcreate outline MY_OUTLN for CATEGORY special ON select * from dba_extents;
Просмотр сохраненного плана запроса:
select * from outln.ol$hints where ol_name='MY_OUTLN' order by hint# [...]
Ср, Сен 29, 2010
Несколько дней назад вышел первый набор патчей для базы данных 11GR2 под платформы Linux x86-64, x86.
Найти patch#[10098816] на support.oracle.com не получается даже по номеру патча.
Но скачать патч по номеру с updates.oracle.com возможно. [...]
Source: atyshenko.blogspot.comНайти patch#[10098816] на support.oracle.com не получается даже по номеру патча.
Но скачать патч по номеру с updates.oracle.com возможно. [...]
Ср, Сен 29, 2010
Oracle OpenWorld 2010 прошел без объявления о выходе Oracle 11g Express Edition (XE).Однако Bradley D. Brown at TUSC, Oracle подтвердил, что в настоящее время работают над Oracle 11g Express Edition.Ранее ACE Director community спрашивал Mark Townsend (менеджер по продуктам Oracle DB) о дате выхода XE и получил ответ, что [...]
Source: atyshenko.blogspot.comЧт, Авг 19, 2010
18 августа компания Oracle выпустила обновление APEX до версии 4.0.1.
С помощью этого пакета вы можете обновить свой APEX с версий 3.2.1 - 4.0 до версии 4.0.1.00.03.
С инструкцией по установке и списком исправленых ошибок можно ознакомиться здесь [...]
Source: atyshenko.blogspot.comС помощью этого пакета вы можете обновить свой APEX с версий 3.2.1 - 4.0 до версии 4.0.1.00.03.
С инструкцией по установке и списком исправленых ошибок можно ознакомиться здесь [...]
Чт, Июл 22, 2010
Two versions of an application to encapsulate the data dictionary views that have LONG columns. LONGs are converted to CLOBs in pipelined functions, enabling us to search, copy and manipulate these columns with string functions. A static version supports 9.2 and 10.1 and a dynamic ANYDATASET version supports 10.2 onwards. [...]
Source: www.oracle-developer.netСб, Июл 17, 2010
За не полностью прошедший месяц после выхода APEX 4.0 обнаружены первые ошибки связаные с переходом с предидущих версий, ошибками в визуальных темах и другие.
Ознакомиться с ними можно в постоянно обновляемом перечне ошибок [...]
Source: atyshenko.blogspot.comОзнакомиться с ними можно в постоянно обновляемом перечне ошибок [...]
Пт, Июл 16, 2010
Скачать Oracle Containers for J2EE Standalone Distributions (текущая версия 10.1.3.5.0)http://www.oracle.com/technology/software/products/ias/htdocs/utilsoft.html2.Развернуть например в каталог C:oc4j3. Установить Java SDK 4. Установить переменную окружения ORACLE_HOMEПод windows set ORACLE_HOME=C:oc4j5. Запустить OC4Ja. [...]
Source: atyshenko.blogspot.comВт, Июл 06, 2010
Часто возникает необходимость узнать какие данные в каких таблицах изменялись в последнее время. Сделать это можно с помощью запроса:
select *
from sys.MON_MODS$ m,
sys.all_objects o
where m.obj# = o.OBJECT_ID
and o.OWNER not in ('SYS','SYSTEM','SYSMAN','DBSNMP','SNMP_USER')
order by m.timestamp
Запрос не отображает изменения в [...]
Source: atyshenko.blogspot.comselect *
from sys.MON_MODS$ m,
sys.all_objects o
where m.obj# = o.OBJECT_ID
and o.OWNER not in ('SYS','SYSTEM','SYSMAN','DBSNMP','SNMP_USER')
order by m.timestamp
Запрос не отображает изменения в [...]
Пн, Июл 05, 2010
Two versions of an application to encapsulate the data dictionary views that have LONG columns. LONGs are converted to CLOBs in pipelined functions, enabling us to search, copy and manipulate these columns with string functions. A static version supports 9.2 and 10.1 and a dynamic ANYDATASET version supports 10.2 onwards. [...]
Source: www.oracle-developer.net