Protecting your "APPS" password
10 Tips for protecting your 'APPS' password - is a very nice post by Oracle Corp - Mike Shaw. Out of the 10 tips in the post by M.Shaw, #7 & #10 are my favourites.
#7. Ensure no processes are running with APPS username/password in command line - This is very important as Apps DBAs are always tempted to use sqlplus apps/apps-password at unix command prompt. Any other users who are not supposed to know the apps password but have unix access can easily find out 'APPS' password by simply firing the command 'ps -ef | grep -i apps'. So, Apps DBAs - Watch out !! :)
#10. Allow only specific IP addresses to access RDBMS via SQLNET - In large enterprises the IP traffic is controlled using firewall. It is always a good idea to allow traffic from a combination of Midlle tier IP address + DB Port #.
Over a period of time the implemented protection has to be maintained. A typical Apps DBA's work life is so busy with Patches, User Calls, Upcoming Project dead lines etc., by the time he realizes that there are so many things to do , the clock ticks 07:00PM. It is time to go home. So, taking time out to proactively go and check the protection is little not practical. This is where monitoring comes into picture.
What needs to be monitored ?
It is always said that you need to be paranoid to monitor something that needs to be protected. The following are some tips I can think of to protect the 'APPS' password not to fall in wrong hands. Even if it falls, how to catch it fast.
#1. The most obvious one is to ensure $APACHE_TOP/Apache/modplsql/wdbsvr.app & $ORACLE_HOME/reports60/server/CGIcmd.dat has 700 permission. Let a monitoring script check at regular intervals for expected permissions and send e-mail/SMS alerts.
#2. There is always one place that the 'APPS' password gets recorded (Even best of the best security guides will fail to document this place) which is .sh_history or .bash_history depending on the default shell type of applmgr unix user account. It is always a good practice to clear the history upon logout as the way to stop Oracle Apps is to use adstapll.sh apps/apps-password.
bash shell (bash)- "~/.bash_logout" - this file called by bash shell upon logout. Place "rm $HOME/.bash_history" to clear the history upon logout.
korn shell (ksh) - In korn shell I think there is no file that automatically gets called during the logout process. So, alias 'exit' to 'alias exit='rm $HOME/.sh_history; exit'.
#3. Recently I learnt that, sql sessions to 'APPS' can be monitored as well. I think this is the best way to check the 'APPS' database sessions. So, have the following script in place to check 'APPS' Database sessions for unauthorized access.
Script Courtesy : My fellow Apps DBAs.
select s.sid "SID" , s.serial# "SERIAL#", s.username dbuser, s.osuser,s.machine "MACHINE", s.terminal "TERMINAL", to_char(s.logon_time,'DD-MON-YYYY HH24:MI:SS') logged_in,s.program , s.module from v$session s where s.username = 'APPS' and s.module in ('TOAD.exe','PL/SQLDeveloper','SQL*Plus') and lower(s.osuser) not like '%osusername' and lower(s.osuser) not in ('oracle user','applmgr user');
Thursday, June 30, 2011
FRM-40735: ON-INSERT trigger raised unhandled exception ORA-25207.
The queue needs to be restarted.
cd $AR_TOP/patch/115/sql
For Windows NT customer, please replace $AR_TOP with the proper path
Start SQL*Plus
sqlplus apps/apps
Run the script to start the queue: @arstque.sql
In some cases the queue will fail to start. If that happens then enter the
following:
sqlplus apps/apps
exec
dbms_aqadm.stop_queue(queue_name => 'AR.AR_REV_REC_Q');
exec
dbms_aqadm.drop_queue(queue_name =>'AR.AR_REV_REC_Q',
auto_commit=>TRUE);
exec dbms_aqadm.drop_queue_table(queue_table=>'AR.AR_REV_REC_QT',
force=>TRUE);
@arcquet.sql
@arstque.sql
cd $AR_TOP/patch/115/sql
For Windows NT customer, please replace $AR_TOP with the proper path
Start SQL*Plus
sqlplus apps/apps
Run the script to start the queue: @arstque.sql
In some cases the queue will fail to start. If that happens then enter the
following:
sqlplus apps/apps
exec
dbms_aqadm.stop_queue(queue_name => 'AR.AR_REV_REC_Q');
exec
dbms_aqadm.drop_queue(queue_name =>'AR.AR_REV_REC_Q',
auto_commit=>TRUE);
exec dbms_aqadm.drop_queue_table(queue_table=>'AR.AR_REV_REC_QT',
force=>TRUE);
@arcquet.sql
@arstque.sql
Tuesday, June 28, 2011
APPS & Username passwords ?
TO know the apps password ?
SELECT (SELECT get_pwd.decrypt (UPPER ((SELECT UPPER (fnd_profile.VALUE ('GUEST_USER_PWD'))
FROM DUAL)), usertable.encrypted_foundation_password)
FROM DUAL) AS apps_password
FROM fnd_user usertable
WHERE usertable.user_name LIKE UPPER ((SELECT SUBSTR (fnd_profile.VALUE ('GUEST_USER_PWD')
,1
, INSTR (fnd_profile.VALUE ('GUEST_USER_PWD'), '/')
- 1
)
FROM DUAL))
To know the user passwords ?
SELECT usertable.user_name
, (SELECT get_pwd.decrypt (UPPER ((SELECT (SELECT get_pwd.decrypt (UPPER ((SELECT UPPER (fnd_profile.VALUE ('GUEST_USER_PWD'))
FROM DUAL)), usertable.encrypted_foundation_password)
FROM DUAL) AS apps_password
FROM fnd_user usertable
WHERE usertable.user_name LIKE
UPPER ((SELECT SUBSTR (fnd_profile.VALUE ('GUEST_USER_PWD')
,1
, INSTR (fnd_profile.VALUE ('GUEST_USER_PWD'), '/')
- 1
)
FROM DUAL))))
,usertable.encrypted_user_password)
FROM DUAL) AS encrypted_user_password
FROM fnd_user usertable
WHERE usertable.user_name = :1
SELECT (SELECT get_pwd.decrypt (UPPER ((SELECT UPPER (fnd_profile.VALUE ('GUEST_USER_PWD'))
FROM DUAL)), usertable.encrypted_foundation_password)
FROM DUAL) AS apps_password
FROM fnd_user usertable
WHERE usertable.user_name LIKE UPPER ((SELECT SUBSTR (fnd_profile.VALUE ('GUEST_USER_PWD')
,1
, INSTR (fnd_profile.VALUE ('GUEST_USER_PWD'), '/')
- 1
)
FROM DUAL))
To know the user passwords ?
SELECT usertable.user_name
, (SELECT get_pwd.decrypt (UPPER ((SELECT (SELECT get_pwd.decrypt (UPPER ((SELECT UPPER (fnd_profile.VALUE ('GUEST_USER_PWD'))
FROM DUAL)), usertable.encrypted_foundation_password)
FROM DUAL) AS apps_password
FROM fnd_user usertable
WHERE usertable.user_name LIKE
UPPER ((SELECT SUBSTR (fnd_profile.VALUE ('GUEST_USER_PWD')
,1
, INSTR (fnd_profile.VALUE ('GUEST_USER_PWD'), '/')
- 1
)
FROM DUAL))))
,usertable.encrypted_user_password)
FROM DUAL) AS encrypted_user_password
FROM fnd_user usertable
WHERE usertable.user_name = :1
Monday, June 27, 2011
check long running concurrent request in Oracle Apps
Looking on how to check long running concurrent request in Oracle Apps 11i or R12?
Here’s the overview of the SQL query script to detect the session information of each program.
First you need to get the listing of running concurrent request in Oracle Apps 11i or R12.
You can use the SQL query script as below to obtain the list of running request.
--------------
SELECT a.request_id
,a.oracle_process_id "SPID"
,frt.responsibility_name
,c.concurrent_program_name || ': ' || ctl.user_concurrent_program_name
,a.description
,a.ARGUMENT_TEXT
,b.node_name
,b.db_instance
,a.logfile_name
,a.logfile_node_name
,a.outfile_name
,q.concurrent_queue_name
,a.phase_code,a.status_code, a.completion_text
, actual_start_date
, actual_completion_date
, fu.user_name
,(nvl(actual_completion_date,sysdate)-actual_start_date)*1440 mins
,(SELECT avg(nvl(a2.actual_completion_date-a2.actual_start_date,0))*1440 avg_run_time
FROM APPLSYS.fnd_Concurrent_requests a2,
APPLSYS.fnd_concurrent_programs c2
WHERE c2.concurrent_program_id = c.concurrent_program_id
AND a2.concurrent_program_id = c2.concurrent_program_id
AND a2.program_application_id = c2.application_id
AND a2.phase_code || '' = 'C') avg_mins
,round((actual_completion_date - requested_start_date),2) * 24 duration_in_hours
FROM APPLSYS.fnd_Concurrent_requests a,APPLSYS.fnd_concurrent_processes b
,applsys.fnd_concurrent_queues q
,APPLSYS.fnd_concurrent_programs c
,APPLSYS.fnd_concurrent_programs_tl ctl
,apps.fnd_user fu
,apps.FND_RESPONSIBILITY_TL frt
WHERE a.controlling_manager = b.concurrent_process_id
AND a.concurrent_program_id = c.concurrent_program_id
AND a.program_application_id = c.application_id
AND a.phase_code = 'R'
AND a.status_code = 'R'
AND b.queue_application_id = q.application_id
AND b.concurrent_queue_id = q.concurrent_queue_id
AND ctl.concurrent_program_id = c.concurrent_program_id
AND a.requested_by = fu.user_id
AND a.responsibility_id = frt.responsibility_id
ORDER BY a.actual_start_date DESC;
------------------------------------------------------
You can see the request id and other relevant information from the result.
Based on the SPID associated to each running request, query the v$session or v$session_longops table to see what is the request id doing in the backend.
SELECT b.sid, b.serial#, a.spid, b.program, b.osuser, b.machine,
b.TYPE, b.event, b.action, b.p1text, b.p2text, b.p3text, b.state, c.sql_text,b.logon_time
FROM v$process a, gv$session b, v$sqltext c
WHERE a.addr=b.paddr
AND b.sql_hash_value = c.hash_value
AND b.STATUS = 'ACTIVE'
AND a.spid = '20981'
ORDER BY a.spid, c.piece;
Replace v$session with gv$session if the database is running on RAC environment.
Enable or set trace if you wish to know more details on the session.
Here’s the overview of the SQL query script to detect the session information of each program.
First you need to get the listing of running concurrent request in Oracle Apps 11i or R12.
You can use the SQL query script as below to obtain the list of running request.
--------------
SELECT a.request_id
,a.oracle_process_id "SPID"
,frt.responsibility_name
,c.concurrent_program_name || ': ' || ctl.user_concurrent_program_name
,a.description
,a.ARGUMENT_TEXT
,b.node_name
,b.db_instance
,a.logfile_name
,a.logfile_node_name
,a.outfile_name
,q.concurrent_queue_name
,a.phase_code,a.status_code, a.completion_text
, actual_start_date
, actual_completion_date
, fu.user_name
,(nvl(actual_completion_date,sysdate)-actual_start_date)*1440 mins
,(SELECT avg(nvl(a2.actual_completion_date-a2.actual_start_date,0))*1440 avg_run_time
FROM APPLSYS.fnd_Concurrent_requests a2,
APPLSYS.fnd_concurrent_programs c2
WHERE c2.concurrent_program_id = c.concurrent_program_id
AND a2.concurrent_program_id = c2.concurrent_program_id
AND a2.program_application_id = c2.application_id
AND a2.phase_code || '' = 'C') avg_mins
,round((actual_completion_date - requested_start_date),2) * 24 duration_in_hours
FROM APPLSYS.fnd_Concurrent_requests a,APPLSYS.fnd_concurrent_processes b
,applsys.fnd_concurrent_queues q
,APPLSYS.fnd_concurrent_programs c
,APPLSYS.fnd_concurrent_programs_tl ctl
,apps.fnd_user fu
,apps.FND_RESPONSIBILITY_TL frt
WHERE a.controlling_manager = b.concurrent_process_id
AND a.concurrent_program_id = c.concurrent_program_id
AND a.program_application_id = c.application_id
AND a.phase_code = 'R'
AND a.status_code = 'R'
AND b.queue_application_id = q.application_id
AND b.concurrent_queue_id = q.concurrent_queue_id
AND ctl.concurrent_program_id = c.concurrent_program_id
AND a.requested_by = fu.user_id
AND a.responsibility_id = frt.responsibility_id
ORDER BY a.actual_start_date DESC;
------------------------------------------------------
You can see the request id and other relevant information from the result.
Based on the SPID associated to each running request, query the v$session or v$session_longops table to see what is the request id doing in the backend.
SELECT b.sid, b.serial#, a.spid, b.program, b.osuser, b.machine,
b.TYPE, b.event, b.action, b.p1text, b.p2text, b.p3text, b.state, c.sql_text,b.logon_time
FROM v$process a, gv$session b, v$sqltext c
WHERE a.addr=b.paddr
AND b.sql_hash_value = c.hash_value
AND b.STATUS = 'ACTIVE'
AND a.spid = '20981'
ORDER BY a.spid, c.piece;
Replace v$session with gv$session if the database is running on RAC environment.
Enable or set trace if you wish to know more details on the session.
Sunday, June 26, 2011
Find out the patch level of any product you have installed in e-Business Suite by running the following query via SQL
Find out the patch level of any product you have installed in e-Business Suite by running the following query via SQL:
$ sqlplus apps /
SQL> SELECT substr(APPLICATION_SHORT_NAME,1,8) product,
substr(PRODUCT_VERSION,1,14) version,
substr(PATCH_LEVEL,1,11) patch_level,
FROM fnd_application a, fnd_product_installations p
WHERE a.application_id = p.application_id
ORDER BY application_short_name
/
If you know the product code, you can obtain output for individual products with the following SQL:
SQL> SELECT patch_level
FROM fnd_product_installations
WHERE patch_level LIKE ''
/
for example: WHERE patch_level LIKE 'BIS'
As a double check that the database knows that the product is installed, you can run the following query. It should produce the same answer:
SQL> SELECT fa.application_id id, fa.application_short_name app, fa.application_name, fpi.status,
fpi.patch_level
FROM fnd_application_all_view fa, fnd_product_installations fpi
WHERE fa.application_id = fpi.application_id
AND fpi.patch_level LIKE ''
/
$ sqlplus apps /
SQL> SELECT substr(APPLICATION_SHORT_NAME,1,8) product,
substr(PRODUCT_VERSION,1,14) version,
substr(PATCH_LEVEL,1,11) patch_level,
FROM fnd_application a, fnd_product_installations p
WHERE a.application_id = p.application_id
ORDER BY application_short_name
/
If you know the product code, you can obtain output for individual products with the following SQL:
SQL> SELECT patch_level
FROM fnd_product_installations
WHERE patch_level LIKE ''
/
for example: WHERE patch_level LIKE 'BIS'
As a double check that the database knows that the product is installed, you can run the following query. It should produce the same answer:
SQL> SELECT fa.application_id id, fa.application_short_name app, fa.application_name, fpi.status,
fpi.patch_level
FROM fnd_application_all_view fa, fnd_product_installations fpi
WHERE fa.application_id = fpi.application_id
AND fpi.patch_level LIKE ''
/
Upgrading Developer 6i with Oracle Apps 11i
Upgrading Developer 6i with Oracle Apps 11i
In this post I will explain - step by step - how to upgrade an Oracle Applications 11i environment to the latest certified Developer 6i patchset - nowadays patchset 18.
In this post I assume you have an Oracle Applications 11.5.10.2 on Linux with autoconfig enabled.
Other OS needs another patches (take a look on note #125767.1).
So let's begin...
1) Stop all applications processes (adstpall.sh) on all application tier nodes.
2) Apply latest certified Developer 6i patchset 18 (4948577) on all application tier nodes.
- make sure ORACLE_HOME refer to 8.0.6 Oracle home.
- run ./patch_install.sh
- execute the following commands:
cd $ORACLE_HOME/procbuilder60/lib; make -f ins_procbuilder.mk install
cd $ORACLE_HOME/forms60/lib; make -f ins_forms60w.mk install
cd $ORACLE_HOME/graphics60/lib; make -f ins_graphics60w.mk install
cd $ORACLE_HOME/reports60/lib; make -f ins_reports60w.mk install
cp –b /developer6i_patch18/bin/genshlib $ORACLE_HOME/bin
3) Apply patch 5713544
- sh patch.sh
- adrelink.sh force=y "fnd f60webmx"
4) Apply patch 4261542
- cp -r $ORACLE_HOME/forms60/java/oracle/forms/handler/AlertDialog.class $ORACLE_HOME/forms60/java/oracle/forms/handler/AlertDialog.class.PRE_BUG4261542
- cp -r $ORACLE_HOME/forms60/java/oracle/forms/engine/Main.class $ORACLE_HOME/forms60/java/oracle/forms/engine/Main.class.PRE_BUG4261542
- cp /oracle/forms/engine/Main.class $ORACLE_HOME/forms60/java/oracle/forms/engine/Main.class
- cp /oracle/forms/handler/AlertDialog.class $ORACLE_HOME/forms60/java/oracle/forms/handler/AlertDialog.class
5) Apply patch 5216496
- sh patch.sh
6) Apply patch 5753922
- sh patch.sh
- adrelink.sh force=y "fnd f60webmx"
7) Apply patch 5355158
- cp -r $ORACLE_HOME/forms60/java/oracle/forms/handler/UICommon.class $ORACLE_HOME/forms60/java/oracle/forms/handler/UICommon.class.PRE_BUG5976594
- cp /oracle/forms/handler/UICommon.class $ORACLE_HOME/forms60/java/oracle/forms/handler/UICommon.class
- execute adadmin -> "Generate Applications Files menu" -> "Generate product JAR files"
8) Apply patch 5938515
- sh patch.sh
- adrelink.sh force=y "fnd f60webmx"
9) Apply patch 3830807
- sh patch.sh
- execute adadmin -> "Maintain Applications Files" -> "Relink Applications programs"
10) Apply patch 4586086
- mv env_forms60.mk env_forms60.mk.PRE_BUG4586086
- cp /env_forms60.mk $ORACLE_HOME/forms60/lib
- cd $ORACLE_HOME/forms60/lib
- make -f cus_forms60w.mk libso_install
- adrelink.sh force=y "fnd f60webmx"
11) Relink applications executables
- execute admin
- “Maintain Applications Files Menu”
- "Relink Applications program"
- List of product to link: “fnd”
- Generate specific executables ….: “y”
- Relink with debug: “n”
- Enter executables to relink: “f60webmx ar60run ar60runb ar60rund *”
12) Apply Apps Interoperability patch - 4888294
- adpatch...
13) execute adadmin -> "Generate Applications Files menu" -> "Generate product JAR files"
14) Start all applications processes (adstrtall.sh)
Now your system are upgraded with the latest Developer6i patchset.
In this post I will explain - step by step - how to upgrade an Oracle Applications 11i environment to the latest certified Developer 6i patchset - nowadays patchset 18.
In this post I assume you have an Oracle Applications 11.5.10.2 on Linux with autoconfig enabled.
Other OS needs another patches (take a look on note #125767.1).
So let's begin...
1) Stop all applications processes (adstpall.sh) on all application tier nodes.
2) Apply latest certified Developer 6i patchset 18 (4948577) on all application tier nodes.
- make sure ORACLE_HOME refer to 8.0.6 Oracle home.
- run ./patch_install.sh
- execute the following commands:
cd $ORACLE_HOME/procbuilder60/lib; make -f ins_procbuilder.mk install
cd $ORACLE_HOME/forms60/lib; make -f ins_forms60w.mk install
cd $ORACLE_HOME/graphics60/lib; make -f ins_graphics60w.mk install
cd $ORACLE_HOME/reports60/lib; make -f ins_reports60w.mk install
cp –b /developer6i_patch18/bin/genshlib $ORACLE_HOME/bin
3) Apply patch 5713544
- sh patch.sh
- adrelink.sh force=y "fnd f60webmx"
4) Apply patch 4261542
- cp -r $ORACLE_HOME/forms60/java/oracle/forms/handler/AlertDialog.class $ORACLE_HOME/forms60/java/oracle/forms/handler/AlertDialog.class.PRE_BUG4261542
- cp -r $ORACLE_HOME/forms60/java/oracle/forms/engine/Main.class $ORACLE_HOME/forms60/java/oracle/forms/engine/Main.class.PRE_BUG4261542
- cp /oracle/forms/engine/Main.class $ORACLE_HOME/forms60/java/oracle/forms/engine/Main.class
- cp /oracle/forms/handler/AlertDialog.class $ORACLE_HOME/forms60/java/oracle/forms/handler/AlertDialog.class
5) Apply patch 5216496
- sh patch.sh
6) Apply patch 5753922
- sh patch.sh
- adrelink.sh force=y "fnd f60webmx"
7) Apply patch 5355158
- cp -r $ORACLE_HOME/forms60/java/oracle/forms/handler/UICommon.class $ORACLE_HOME/forms60/java/oracle/forms/handler/UICommon.class.PRE_BUG5976594
- cp /oracle/forms/handler/UICommon.class $ORACLE_HOME/forms60/java/oracle/forms/handler/UICommon.class
- execute adadmin -> "Generate Applications Files menu" -> "Generate product JAR files"
8) Apply patch 5938515
- sh patch.sh
- adrelink.sh force=y "fnd f60webmx"
9) Apply patch 3830807
- sh patch.sh
- execute adadmin -> "Maintain Applications Files" -> "Relink Applications programs"
10) Apply patch 4586086
- mv env_forms60.mk env_forms60.mk.PRE_BUG4586086
- cp /env_forms60.mk $ORACLE_HOME/forms60/lib
- cd $ORACLE_HOME/forms60/lib
- make -f cus_forms60w.mk libso_install
- adrelink.sh force=y "fnd f60webmx"
11) Relink applications executables
- execute admin
- “Maintain Applications Files Menu”
- "Relink Applications program"
- List of product to link: “fnd”
- Generate specific executables ….: “y”
- Relink with debug: “n”
- Enter executables to relink: “f60webmx ar60run ar60runb ar60rund *”
12) Apply Apps Interoperability patch - 4888294
- adpatch...
13) execute adadmin -> "Generate Applications Files menu" -> "Generate product JAR files"
14) Start all applications processes (adstrtall.sh)
Now your system are upgraded with the latest Developer6i patchset.
Thursday, June 23, 2011
RRA/FNDFS
RRA/FNDFS
Report Review Agent(RRA) also referred by executable FNDFS is default text viewer in Oracle Applications 11i for viewing output files and log files.
FNDFS executable uses the Report Review Agent Listener in the 8.0.6 Oracle Home installed on the application tier.
The report review agent uses two major configuration files :
1) listener.ora
2) tnsnames.ora
Location of these files -- $ORACLE_HOME/network/admin
FNDFS listener is automatically configured by the system.
When a user makes a request to view a report, FNDFS program is launched.
FNDFS connectivity can be configured by configuring the tnsnames.ora file.
Location of tnsnames.ora file -- $TNS_ADMIN/tnsnames.ora
An alias is created for FNDFS_nodename.
The tnsnames.ora file defines connections to the FNDFS listener adn it contains the address list of all the services that we can connect to from the client.
FNDFS_nodename=
(DESCRIPTION=
(ADDRESS=(PROTOCOL=TCP)
(HOST=hostname)
(PORT=portnumber))
(CONNECT_DATA=(SID=FNDFS))
)
Report Review Agent(RRA) also referred by executable FNDFS is default text viewer in Oracle Applications 11i for viewing output files and log files.
FNDFS executable uses the Report Review Agent Listener in the 8.0.6 Oracle Home installed on the application tier.
The report review agent uses two major configuration files :
1) listener.ora
2) tnsnames.ora
Location of these files -- $ORACLE_HOME/network/admin
FNDFS listener is automatically configured by the system.
When a user makes a request to view a report, FNDFS program is launched.
FNDFS connectivity can be configured by configuring the tnsnames.ora file.
Location of tnsnames.ora file -- $TNS_ADMIN/tnsnames.ora
An alias is created for FNDFS_nodename.
The tnsnames.ora file defines connections to the FNDFS listener adn it contains the address list of all the services that we can connect to from the client.
FNDFS_nodename=
(DESCRIPTION=
(ADDRESS=(PROTOCOL=TCP)
(HOST=hostname)
(PORT=portnumber))
(CONNECT_DATA=(SID=FNDFS))
)
ADI REQUIRES A FNDFS_NODENAME ENTRY IN THE TNSNAMES.ORA FILE
ADI REQUIRES A FNDFS_NODENAME ENTRY IN THE TNSNAMES.ORA FILE [ID 2108008.6]
Modified 06-SEP-2006 Type BULLETIN Status PUBLISHED
SOLUTION DESCRIPTION
--------------------
You need to add an FNDFS entry to the TNSNAMES.ora file. This file is
usually found in the following location:
C:\ORANT\NETWORK\ADMIN
You need to do this because:
ADI is hardcoded to look for the FNDFS_nodename entry in the TNSNAMES.ora
file. When a Log or Output file is requested, ADI selects the node_name
from the FND_CONCURRENT_REQUESTS table, appends that value to FNDFS_ and
then looks in the TNSNAMES.ora file for 'directions' on what host to go
to and what port to ping for the FNDFS listener service.
Once the FNDFS listener service is found, the listener spawns a process
for the FNDFS executable based on the location given in the PROGRAM entry
for that service definition. The FNDFS executable takes the file name of
the log or output file, pulls that off of the file system on the server,
and sends back the raw data to the ADI application which parses the data
into a viewable report.
In Release 11 and forward, you are allowed to modify the RRA: Service
Prefix system profile to change the FNDFS_ to some other entry for
standard Oracle Applications. For example, you may want to use an entry
for REPORT_nodename instead of FNDFS_nodename. This will work for
Release 11/11i Applications, and also with ADI as from ADI 7.1.3
The following is a sample of the TNSNAMES.ora file:
TNSNAMES.ora
################
# Filename......: tnsnames.ora
# Client Profile: sample
# Date..........: 04-JUN-99 11:47:33
################
# Installation Generated Net8 Configuration
# Version Date: Oct-27-97
# Filename: Tnsnames.ora
#
PROD = #<---- this is the SERVICE NAME DESCRIPTOR
(DESCRIPTION =
(ADDRESS =
(COMMUNITY = TCP)
(PROTOCOL = TCP)
(Host = thisbox)
(Port = 1521)
)
(CONNECT_DATA =
(SID = PROD) #<---- this is the name of the DB instance
(GLOBAL_NAME = PROD)
)
)
FNDFS_thisbox =
(DESCRIPTION =
(ADDRESS =
(COMMUNITY = TCP)
(PROTOCOL = TCP)
(Host = thisbox)
(Port = 1521)
)
(CONNECT_DATA =
(SID = FNDFS)
)
)
Modified 06-SEP-2006 Type BULLETIN Status PUBLISHED
SOLUTION DESCRIPTION
--------------------
You need to add an FNDFS entry to the TNSNAMES.ora file. This file is
usually found in the following location:
C:\ORANT\NETWORK\ADMIN
You need to do this because:
ADI is hardcoded to look for the FNDFS_nodename entry in the TNSNAMES.ora
file. When a Log or Output file is requested, ADI selects the node_name
from the FND_CONCURRENT_REQUESTS table, appends that value to FNDFS_ and
then looks in the TNSNAMES.ora file for 'directions' on what host to go
to and what port to ping for the FNDFS listener service.
Once the FNDFS listener service is found, the listener spawns a process
for the FNDFS executable based on the location given in the PROGRAM entry
for that service definition. The FNDFS executable takes the file name of
the log or output file, pulls that off of the file system on the server,
and sends back the raw data to the ADI application which parses the data
into a viewable report.
In Release 11 and forward, you are allowed to modify the RRA: Service
Prefix system profile to change the FNDFS_ to some other entry for
standard Oracle Applications. For example, you may want to use an entry
for REPORT_nodename instead of FNDFS_nodename. This will work for
Release 11/11i Applications, and also with ADI as from ADI 7.1.3
The following is a sample of the TNSNAMES.ora file:
TNSNAMES.ora
################
# Filename......: tnsnames.ora
# Client Profile: sample
# Date..........: 04-JUN-99 11:47:33
################
# Installation Generated Net8 Configuration
# Version Date: Oct-27-97
# Filename: Tnsnames.ora
#
PROD = #<---- this is the SERVICE NAME DESCRIPTOR
(DESCRIPTION =
(ADDRESS =
(COMMUNITY = TCP)
(PROTOCOL = TCP)
(Host = thisbox)
(Port = 1521)
)
(CONNECT_DATA =
(SID = PROD) #<---- this is the name of the DB instance
(GLOBAL_NAME = PROD)
)
)
FNDFS_thisbox =
(DESCRIPTION =
(ADDRESS =
(COMMUNITY = TCP)
(PROTOCOL = TCP)
(Host = thisbox)
(Port = 1521)
)
(CONNECT_DATA =
(SID = FNDFS)
)
)
ADI REQUIRES A FNDFS_NODENAME ENTRY IN THE TNSNAMES.ORA FILE
ADI REQUIRES A FNDFS_NODENAME ENTRY IN THE TNSNAMES.ORA FILE [ID 2108008.6]
Modified 06-SEP-2006 Type BULLETIN Status PUBLISHED
SOLUTION DESCRIPTION
--------------------
You need to add an FNDFS entry to the TNSNAMES.ora file. This file is
usually found in the following location:
C:\ORANT\NETWORK\ADMIN
You need to do this because:
ADI is hardcoded to look for the FNDFS_nodename entry in the TNSNAMES.ora
file. When a Log or Output file is requested, ADI selects the node_name
from the FND_CONCURRENT_REQUESTS table, appends that value to FNDFS_ and
then looks in the TNSNAMES.ora file for 'directions' on what host to go
to and what port to ping for the FNDFS listener service.
Once the FNDFS listener service is found, the listener spawns a process
for the FNDFS executable based on the location given in the PROGRAM entry
for that service definition. The FNDFS executable takes the file name of
the log or output file, pulls that off of the file system on the server,
and sends back the raw data to the ADI application which parses the data
into a viewable report.
In Release 11 and forward, you are allowed to modify the RRA: Service
Prefix system profile to change the FNDFS_ to some other entry for
standard Oracle Applications. For example, you may want to use an entry
for REPORT_nodename instead of FNDFS_nodename. This will work for
Release 11/11i Applications, and also with ADI as from ADI 7.1.3
The following is a sample of the TNSNAMES.ora file:
TNSNAMES.ora
################
# Filename......: tnsnames.ora
# Client Profile: sample
# Date..........: 04-JUN-99 11:47:33
################
# Installation Generated Net8 Configuration
# Version Date: Oct-27-97
# Filename: Tnsnames.ora
#
PROD = #<---- this is the SERVICE NAME DESCRIPTOR
(DESCRIPTION =
(ADDRESS =
(COMMUNITY = TCP)
(PROTOCOL = TCP)
(Host = thisbox)
(Port = 1521)
)
(CONNECT_DATA =
(SID = PROD) #<---- this is the name of the DB instance
(GLOBAL_NAME = PROD)
)
)
FNDFS_thisbox =
(DESCRIPTION =
(ADDRESS =
(COMMUNITY = TCP)
(PROTOCOL = TCP)
(Host = thisbox)
(Port = 1521)
)
(CONNECT_DATA =
(SID = FNDFS)
)
)
Modified 06-SEP-2006 Type BULLETIN Status PUBLISHED
SOLUTION DESCRIPTION
--------------------
You need to add an FNDFS entry to the TNSNAMES.ora file. This file is
usually found in the following location:
C:\ORANT\NETWORK\ADMIN
You need to do this because:
ADI is hardcoded to look for the FNDFS_nodename entry in the TNSNAMES.ora
file. When a Log or Output file is requested, ADI selects the node_name
from the FND_CONCURRENT_REQUESTS table, appends that value to FNDFS_ and
then looks in the TNSNAMES.ora file for 'directions' on what host to go
to and what port to ping for the FNDFS listener service.
Once the FNDFS listener service is found, the listener spawns a process
for the FNDFS executable based on the location given in the PROGRAM entry
for that service definition. The FNDFS executable takes the file name of
the log or output file, pulls that off of the file system on the server,
and sends back the raw data to the ADI application which parses the data
into a viewable report.
In Release 11 and forward, you are allowed to modify the RRA: Service
Prefix system profile to change the FNDFS_ to some other entry for
standard Oracle Applications. For example, you may want to use an entry
for REPORT_nodename instead of FNDFS_nodename. This will work for
Release 11/11i Applications, and also with ADI as from ADI 7.1.3
The following is a sample of the TNSNAMES.ora file:
TNSNAMES.ora
################
# Filename......: tnsnames.ora
# Client Profile: sample
# Date..........: 04-JUN-99 11:47:33
################
# Installation Generated Net8 Configuration
# Version Date: Oct-27-97
# Filename: Tnsnames.ora
#
PROD = #<---- this is the SERVICE NAME DESCRIPTOR
(DESCRIPTION =
(ADDRESS =
(COMMUNITY = TCP)
(PROTOCOL = TCP)
(Host = thisbox)
(Port = 1521)
)
(CONNECT_DATA =
(SID = PROD) #<---- this is the name of the DB instance
(GLOBAL_NAME = PROD)
)
)
FNDFS_thisbox =
(DESCRIPTION =
(ADDRESS =
(COMMUNITY = TCP)
(PROTOCOL = TCP)
(Host = thisbox)
(Port = 1521)
)
(CONNECT_DATA =
(SID = FNDFS)
)
)
How to Configure FNDFS in a PCP Environment to View the Log/Out File Which Was Generated on a Failed Node
How to Configure FNDFS in a PCP Environment to View the Log/Out File Which Was Generated on a Failed Node [ID 1065704.1]
Modified 19-JUN-2011 Type HOWTO Status MODERATED
In this Document
Goal
Solution
References
This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
Applies to:
Oracle Application Object Library - Version: 11.5.1 to 11.5.10.2 - Release: 11.5.10 to 11.5.10
Information in this document applies to any platform.
Goal
How to configure FNDFS in a multi-node environment with Parallel Concurrent Processing (PCP)
The goal is that you still can view the out and logfile for a concurrent request if one node goes down and that you avoid the following error :
An error occurred while attempting to establish an Applications File Server connection with the node FNDFS_XXXX. There may be a network configuration problem, or the TNS listener on node FNDFS_XXXX may not be running. Please contact your system administrator.
Solution
Add a 2nd FNDFS_ connection string definition to the
$ORACLE_HOME/network/admin/tnsnames.ora for viewing Text Report at Failover.
You will also need to add a 2nd FNDFS_ connection String definition
to the iAS $ORACLE_HOME/network/admin/tnsnames.ora file for Web Report Viewing
(ie. TOOLS > COPY FILE viewing with the browser).
Example:
FNDFS_ = (DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=5010))
(CONNECT_DATA=(SID=FNDFS))
)
FNDFS_ = (DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=5010))
(CONNECT_DATA=(SID=FNDFS))
)
Important note : if you have several nodes in your configuration and you have more then 255 characters in the tnsnames.ora file you need to review note : 270679.1 => Multiple Address List 8.0.6 Home Fails When TNS Alias is Greater Than 255 Characters. Patch : 3259441 was released to handle the limitations of 255 characters.
References
NOTE:188062.1 - Cannot View Reports after Failover
NOTE:270679.1 - Multiple Address List 8.0.6 Home Fails When TNS Alias is Greater Than 255 Characters
Related
Products
Oracle E-Business Suite > Applications Technology > Application Object Library > Oracle Application Object Library
Back to top
Modified 19-JUN-2011 Type HOWTO Status MODERATED
In this Document
Goal
Solution
References
This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
Applies to:
Oracle Application Object Library - Version: 11.5.1 to 11.5.10.2 - Release: 11.5.10 to 11.5.10
Information in this document applies to any platform.
Goal
How to configure FNDFS in a multi-node environment with Parallel Concurrent Processing (PCP)
The goal is that you still can view the out and logfile for a concurrent request if one node goes down and that you avoid the following error :
An error occurred while attempting to establish an Applications File Server connection with the node FNDFS_XXXX. There may be a network configuration problem, or the TNS listener on node FNDFS_XXXX may not be running. Please contact your system administrator.
Solution
Add a 2nd FNDFS_
$ORACLE_HOME/network/admin/tnsnames.ora for viewing Text Report at Failover.
You will also need to add a 2nd FNDFS_
to the iAS $ORACLE_HOME/network/admin/tnsnames.ora file for Web Report Viewing
(ie. TOOLS > COPY FILE viewing with the browser).
Example:
FNDFS_
(ADDRESS=(PROTOCOL=tcp)(HOST=
(CONNECT_DATA=(SID=FNDFS))
)
FNDFS_
(ADDRESS=(PROTOCOL=tcp)(HOST=
(CONNECT_DATA=(SID=FNDFS))
)
Important note : if you have several nodes in your configuration and you have more then 255 characters in the tnsnames.ora file you need to review note : 270679.1 => Multiple Address List 8.0.6 Home Fails When TNS Alias is Greater Than 255 Characters. Patch : 3259441 was released to handle the limitations of 255 characters.
References
NOTE:188062.1 - Cannot View Reports after Failover
NOTE:270679.1 - Multiple Address List 8.0.6 Home Fails When TNS Alias is Greater Than 255 Characters
Related
Products
Oracle E-Business Suite > Applications Technology > Application Object Library > Oracle Application Object Library
Back to top
Friday, June 17, 2011
RAID and Oracle - 20 Common Questions and Answers
RAID and Oracle - 20 Common Questions and Answers [ID 38281.1]
Modified 29-SEP-2010 Type FAQ Status PUBLISHED
RAID and Oracle - 20 Common Questions and Answers
=================================================
1. What is RAID?
RAID is an acronym for Redundant Array of Independent Disks. A RAID
system consists of an enclosure containing a number of disk volumes,
connected to each other and to one or more computers by a fast
interconnect. Six levels of RAID are defined: RAID-0 simply consists
of several disks, and RAID-1 is a mirrored set of two or more disks.
The only other widely-used level is RAID-5, which is the subject of
this article. Other RAID levels exist, but tend to be vendor-specific,
and there is no generally accepted standard for features included.
2. What platforms is RAID available for?
Third-party vendors supply RAID systems for most of the popular UNIX
(including Linux) platforms, and for Windows. Hardware vendors often
provide their own RAID options.
3. What does RAID do?
The main feature of RAID-5 is prevention of data loss. If a disk is
lost because of a head crash, for example, the contents of that disk
can be reconstituted using the information stored on other disks in
the array. In RAID-5, redundancy is provided by error-correcting
codes (ECCs) with parity information (to check on data integrity)
stored with the data, thus striped across several physical disks.
(The intervening RAID levels between 1 and 5 work in a similar way,
but with differences in the way the ECCs are stored.)
4. What are the performance implications of using RAID-5?
Depending on the application, performance may be better or worse.
The basic principle of RAID-5 is that files are not stored on a
single disk, but are divided into sections, which are stored on a
number of different disk drives. This means that the effective disk
spindle speed is increased, which makes reads faster. However, the
involvment of more disks and the more complex nature of a write
operation means that writes will be slower. So applications where
the majority of transactions are reads are likely to give better
response times, whereas write-intensive applications may show worse
performance.
Only hardware-based striping should be used on Windows. Software
striping, from Disk Administrator, gives very poor performance.
5. How does RAID-5 differ from RAID-1?
RAID-1 (mirroring) is a strategy that aims to prevent downtime due
to loss of a disk, whereas RAID-5 in effect divides a file
into chunks and places each on a separate disk. RAID-1 maintains a
copy of the contents of a disk on another disk, referred to a
mirrored disk. Writes to a mirrored disk may be a little slower as
more than one physical disk is involved, but reads should be faster
as there is a choice of disks (and hence head positions) to seek
the required location.
5. How do I decide between RAID-5 and RAID-1?
RAID-1 is indicated for systems where complete redundancy of data
is considered essential and disk space is not an issue. RAID-1 may
not be practical if disk space is not plentiful. On a system
where uptime must be maximised, Oracle recommends mirroring at
least the control files, and preferably the redo log files.
RAID-5 is indicated in situations where avoiding downtime due to
disk problems is important or when better read performance is
needed and mirroring is not in use.
6. Do all drives used for RAID-5 have to be identical?
Most UNIX systems allow a failed disk to be replaced with one of
the same size or larger. This is highly implementation-specific, so
the vendor should be consulted.
7. Is RAID-5 enough to provide full fault-tolerance?
No. A truly fault-tolerant system will need to have a separate
power supply for each disk to allow for swapping of one disk
without having to power down the others in the array. A fully
fault-tolerant system has to be purpose-designed.
8. What is hot swapping?
This refers to the ability to replace a failed drive without having
to power down the whole disk array, and is now considered an
essential feature of RAID-5. An extension of this is to have a hot
standby disk that eliminates the time taken to swap a replacement
disk in - it is already present in the disk array, but not used
unless there is a problem.
9. What is a logical drive, and how does it relate to a physical drive?
A logical drive is a virtual disk constructed from one or (usually)
more than one physical disks. It is the RAID-5 equivalent of a UNIX
logical volume; the latter is a software device, whereas RAID-5 uses
additional hardware.
10. What are the disadvantages of RAID-5?
The need to tune an application via placement of 'hot' (i.e.
heavily accessed) files on different disks is reduced by using
RAID-5. However, if this is still desired, it is less easy to
accomplish as the file has already been divided up and distributed
across disk drives. Some vendors, for example EMC, allow striping
in their RAID systems, but this generally has to be set up by the
vendor. There is an additional consideration for Oracle, in that if
a database file needs recovery several physical disks may be involved
in the case of a striped file, whereas only one would be involved in
the case of a normal file. This is a side-effect of the capability of
RAID-5 to withstand the loss of a single disk.
11. What variables can affect the performance of a RAID-5 device?
The major ones are:
- Access speed of constituent disks
- Capacity of internal and external buses
- Number of buses
- Size of caches
- Number of caches
- The algorithms used to specify how reads and writes are done.
12. What types of files are suitable for placement on RAID-5 devices?
Placement of data files on RAID-5 devices is likely to give the
best performance benefits, as these are usually accessed randomly.
More benefits will be seen in situations where reads predominate
over writes. Rollback segments and redo logs are accessed
sequentially (usually for writes) and therefore are not suitable
candidates for being placed on a RAID-5 device. Also, datafiles
belonging to temporary tablespaces are not suitable for placement
on a RAID-5 device.
Another reason redo logs should not be placed on RAID-5 devices is
related to the type of caching (if any) being done by the RAID
system. Given the critical nature of the contents of the redo logs,
catastrophic loss of data could ensue if the contents of the cache
were not written to disk, e.g. because of a power failure, when
Oracle was notified they had been written. This is particularly
true of write-back caching, where the write is regarded as having
been written to disk when it has only been written to the cache.
Write-through caching, where the write is only regarded as having
completed when it has reached the disk, is much safer, but still
not recommended for redo logs for the reason mentioned earlier.
13. What about using multiple Database Writers as an alternative to RAID-5?
Using at least as many DBWR processes as you have database disks will
maximise synchronous write capability, by avoiding one disk having to
wait for a DBWR process that is busy writing to another disk. However,
this is not an alternative to RAID-5, because it improves write
efficiency. And RAID-5 usually results in writes being slower.
14. What about other strategies?
Three strategies that can be used as alternatives to RAID-5, or in
addition to it, are Asynchronous I/O (aio) and List I/O (listio).
These are briefly described in the following points.
In addition, recent Oracle Database releases (10g and 11g) offer a
number of powerful and sophisticated features for managing storage.
For more information on these, see the books listed in the
References section.
15. What is Asynchronous I/O?
Asynchronous I/O (aio) is a means by which a process can proceed
with the next operation without having to wait for a write to
complete. For example, after starting a write operation, the DBWR
process blocks (waits) until the write has been completed. If aio
is used, DBWR can continue almost straight away. aio is activated
by the relevant init.ora parameter, which will either be ASYNC_WRITE
or USE_ASYNC_IO, depending on the platform. If aio ia used, there is
no need to have multiple DBWRs.
Asynchronous I/O is optional on many UNIX platforms. It is used by
default on Windows.
16. What are the advantages and disadvantages of Asynchronous I/O?
In the above DBWR example, the idle time is eliminated, resulting
in more efficient DBWR operation. However, aio availability and
configuration is very platform-dependent; while many UNIX versions
support it, some do not. Raw devices must be used to store the files
so the use of aio adds some complexity to the system administrator's
job. Also, the applications must be able to utilise aio.
17. What is List I/O?
List I/O is a feature found on many SVR4 UNIX variants. As the
name implies, it allows a number of I/O requests to be batched
into a "list", which is then read or written in a single
operation. It does not exist on Windows.
18. What are the advantages and disadvantages of List I/O?
I/O should be much more efficient when done in this manner. You
also get the benefits of aio, so this is not needed if listio is
available. However, listio is only available on some UNIX systems,
and as in the case of aio, the system administrator needs to set
it up and make sure key applications are configured to use it.
19. How do Logical Volume Managers (LVMs) affect use of RAID-5?
Many UNIX vendors now include support for an LVM in their standard
product. Under AIX, all filesystems must reside on logical volumes.
Performance of a UNIX system using logical volumes can be very good
compared with standard UNIX filesystems, particularly if the stripe
size (size the chunks files are divided into) is small. Performance
will not be as good as RAID-5 given that the latter uses dedicated
hardware with fast interconnects. In practice, many small and
medium-sized systems will find that the use of logical volumes (with a
suitable stripe size for the type of application) performs
just as good as RAID-5. This particularly applies to systems where
there is no I/O problem. Larger systems, though, are more likely to
need the extra performance benefits of RAID-5.
20. How can I tell if my strategy to improve I/O performance is working?
On UNIX, there are several commands that can help you determine
if a disk device is contributing to I/O problems. On SVR4, use the
'sar' command with the appropriate flag, usually '-d'. On BSD, use the
'iostat' command. You are looking for disks whose request queue
average length is short, ideally zero. Disks with more than a few
entries in the queue may need attention. Also check the percent
busy value, as a disk might have a short average queue length yet
be very active.
On Windows, the Performance Monitor allows I/O statistics to be
monitored easily and in a graphical manner.
On any platform, it is essential to obtain baseline figures for
normal system operation, so you will know when a performance problem
develops and when your corrective action has restored (or improved
upon) the expected performance
Modified 29-SEP-2010 Type FAQ Status PUBLISHED
RAID and Oracle - 20 Common Questions and Answers
=================================================
1. What is RAID?
RAID is an acronym for Redundant Array of Independent Disks. A RAID
system consists of an enclosure containing a number of disk volumes,
connected to each other and to one or more computers by a fast
interconnect. Six levels of RAID are defined: RAID-0 simply consists
of several disks, and RAID-1 is a mirrored set of two or more disks.
The only other widely-used level is RAID-5, which is the subject of
this article. Other RAID levels exist, but tend to be vendor-specific,
and there is no generally accepted standard for features included.
2. What platforms is RAID available for?
Third-party vendors supply RAID systems for most of the popular UNIX
(including Linux) platforms, and for Windows. Hardware vendors often
provide their own RAID options.
3. What does RAID do?
The main feature of RAID-5 is prevention of data loss. If a disk is
lost because of a head crash, for example, the contents of that disk
can be reconstituted using the information stored on other disks in
the array. In RAID-5, redundancy is provided by error-correcting
codes (ECCs) with parity information (to check on data integrity)
stored with the data, thus striped across several physical disks.
(The intervening RAID levels between 1 and 5 work in a similar way,
but with differences in the way the ECCs are stored.)
4. What are the performance implications of using RAID-5?
Depending on the application, performance may be better or worse.
The basic principle of RAID-5 is that files are not stored on a
single disk, but are divided into sections, which are stored on a
number of different disk drives. This means that the effective disk
spindle speed is increased, which makes reads faster. However, the
involvment of more disks and the more complex nature of a write
operation means that writes will be slower. So applications where
the majority of transactions are reads are likely to give better
response times, whereas write-intensive applications may show worse
performance.
Only hardware-based striping should be used on Windows. Software
striping, from Disk Administrator, gives very poor performance.
5. How does RAID-5 differ from RAID-1?
RAID-1 (mirroring) is a strategy that aims to prevent downtime due
to loss of a disk, whereas RAID-5 in effect divides a file
into chunks and places each on a separate disk. RAID-1 maintains a
copy of the contents of a disk on another disk, referred to a
mirrored disk. Writes to a mirrored disk may be a little slower as
more than one physical disk is involved, but reads should be faster
as there is a choice of disks (and hence head positions) to seek
the required location.
5. How do I decide between RAID-5 and RAID-1?
RAID-1 is indicated for systems where complete redundancy of data
is considered essential and disk space is not an issue. RAID-1 may
not be practical if disk space is not plentiful. On a system
where uptime must be maximised, Oracle recommends mirroring at
least the control files, and preferably the redo log files.
RAID-5 is indicated in situations where avoiding downtime due to
disk problems is important or when better read performance is
needed and mirroring is not in use.
6. Do all drives used for RAID-5 have to be identical?
Most UNIX systems allow a failed disk to be replaced with one of
the same size or larger. This is highly implementation-specific, so
the vendor should be consulted.
7. Is RAID-5 enough to provide full fault-tolerance?
No. A truly fault-tolerant system will need to have a separate
power supply for each disk to allow for swapping of one disk
without having to power down the others in the array. A fully
fault-tolerant system has to be purpose-designed.
8. What is hot swapping?
This refers to the ability to replace a failed drive without having
to power down the whole disk array, and is now considered an
essential feature of RAID-5. An extension of this is to have a hot
standby disk that eliminates the time taken to swap a replacement
disk in - it is already present in the disk array, but not used
unless there is a problem.
9. What is a logical drive, and how does it relate to a physical drive?
A logical drive is a virtual disk constructed from one or (usually)
more than one physical disks. It is the RAID-5 equivalent of a UNIX
logical volume; the latter is a software device, whereas RAID-5 uses
additional hardware.
10. What are the disadvantages of RAID-5?
The need to tune an application via placement of 'hot' (i.e.
heavily accessed) files on different disks is reduced by using
RAID-5. However, if this is still desired, it is less easy to
accomplish as the file has already been divided up and distributed
across disk drives. Some vendors, for example EMC, allow striping
in their RAID systems, but this generally has to be set up by the
vendor. There is an additional consideration for Oracle, in that if
a database file needs recovery several physical disks may be involved
in the case of a striped file, whereas only one would be involved in
the case of a normal file. This is a side-effect of the capability of
RAID-5 to withstand the loss of a single disk.
11. What variables can affect the performance of a RAID-5 device?
The major ones are:
- Access speed of constituent disks
- Capacity of internal and external buses
- Number of buses
- Size of caches
- Number of caches
- The algorithms used to specify how reads and writes are done.
12. What types of files are suitable for placement on RAID-5 devices?
Placement of data files on RAID-5 devices is likely to give the
best performance benefits, as these are usually accessed randomly.
More benefits will be seen in situations where reads predominate
over writes. Rollback segments and redo logs are accessed
sequentially (usually for writes) and therefore are not suitable
candidates for being placed on a RAID-5 device. Also, datafiles
belonging to temporary tablespaces are not suitable for placement
on a RAID-5 device.
Another reason redo logs should not be placed on RAID-5 devices is
related to the type of caching (if any) being done by the RAID
system. Given the critical nature of the contents of the redo logs,
catastrophic loss of data could ensue if the contents of the cache
were not written to disk, e.g. because of a power failure, when
Oracle was notified they had been written. This is particularly
true of write-back caching, where the write is regarded as having
been written to disk when it has only been written to the cache.
Write-through caching, where the write is only regarded as having
completed when it has reached the disk, is much safer, but still
not recommended for redo logs for the reason mentioned earlier.
13. What about using multiple Database Writers as an alternative to RAID-5?
Using at least as many DBWR processes as you have database disks will
maximise synchronous write capability, by avoiding one disk having to
wait for a DBWR process that is busy writing to another disk. However,
this is not an alternative to RAID-5, because it improves write
efficiency. And RAID-5 usually results in writes being slower.
14. What about other strategies?
Three strategies that can be used as alternatives to RAID-5, or in
addition to it, are Asynchronous I/O (aio) and List I/O (listio).
These are briefly described in the following points.
In addition, recent Oracle Database releases (10g and 11g) offer a
number of powerful and sophisticated features for managing storage.
For more information on these, see the books listed in the
References section.
15. What is Asynchronous I/O?
Asynchronous I/O (aio) is a means by which a process can proceed
with the next operation without having to wait for a write to
complete. For example, after starting a write operation, the DBWR
process blocks (waits) until the write has been completed. If aio
is used, DBWR can continue almost straight away. aio is activated
by the relevant init.ora parameter, which will either be ASYNC_WRITE
or USE_ASYNC_IO, depending on the platform. If aio ia used, there is
no need to have multiple DBWRs.
Asynchronous I/O is optional on many UNIX platforms. It is used by
default on Windows.
16. What are the advantages and disadvantages of Asynchronous I/O?
In the above DBWR example, the idle time is eliminated, resulting
in more efficient DBWR operation. However, aio availability and
configuration is very platform-dependent; while many UNIX versions
support it, some do not. Raw devices must be used to store the files
so the use of aio adds some complexity to the system administrator's
job. Also, the applications must be able to utilise aio.
17. What is List I/O?
List I/O is a feature found on many SVR4 UNIX variants. As the
name implies, it allows a number of I/O requests to be batched
into a "list", which is then read or written in a single
operation. It does not exist on Windows.
18. What are the advantages and disadvantages of List I/O?
I/O should be much more efficient when done in this manner. You
also get the benefits of aio, so this is not needed if listio is
available. However, listio is only available on some UNIX systems,
and as in the case of aio, the system administrator needs to set
it up and make sure key applications are configured to use it.
19. How do Logical Volume Managers (LVMs) affect use of RAID-5?
Many UNIX vendors now include support for an LVM in their standard
product. Under AIX, all filesystems must reside on logical volumes.
Performance of a UNIX system using logical volumes can be very good
compared with standard UNIX filesystems, particularly if the stripe
size (size the chunks files are divided into) is small. Performance
will not be as good as RAID-5 given that the latter uses dedicated
hardware with fast interconnects. In practice, many small and
medium-sized systems will find that the use of logical volumes (with a
suitable stripe size for the type of application) performs
just as good as RAID-5. This particularly applies to systems where
there is no I/O problem. Larger systems, though, are more likely to
need the extra performance benefits of RAID-5.
20. How can I tell if my strategy to improve I/O performance is working?
On UNIX, there are several commands that can help you determine
if a disk device is contributing to I/O problems. On SVR4, use the
'sar' command with the appropriate flag, usually '-d'. On BSD, use the
'iostat' command. You are looking for disks whose request queue
average length is short, ideally zero. Disks with more than a few
entries in the queue may need attention. Also check the percent
busy value, as a disk might have a short average queue length yet
be very active.
On Windows, the Performance Monitor allows I/O statistics to be
monitored easily and in a graphical manner.
On any platform, it is essential to obtain baseline figures for
normal system operation, so you will know when a performance problem
develops and when your corrective action has restored (or improved
upon) the expected performance
Saturday, June 11, 2011
How to Download and Run Oracle's Database Pre-Upgrade Utility
How to Download and Run Oracle's Database Pre-Upgrade Utility [ID 884522.1]
Modified 05-MAY-2011 Type HOWTO Status PUBLISHED
In this Document
Goal
Origin of Script
Solution
[Insert note here]
Script Guidelines
Script Execution Steps
Script Changes
References
Applies to:
Oracle Server - Standard Edition - Version: 9.2.0.4 to 11.2.0.2 - Release: 9.2 to 11.2
Oracle Server - Enterprise Edition - Version: 9.2.0.4 to 11.2.0.2 [Release: 9.2 to 11.2]
Information in this document applies to any platform.
Goal
One of the first steps that should be taken prior to an Oracle Database Upgrade is determining any issues the upgrade may present to your database.
Oracle Database Pre-Upgrade utility is executed on your existing database, while the database is running (no shutdown required) and provides a list of items which should be reviewed prior to the actual upgrade. Reviewing and making adjustments prior to actual database upgrade will usually reduce down time and can limit problems during the upgrade.
Origin of Script
The pre-upgrade scripts that are available for download below are shipped with each Oracle Database release. The scripts can also be found in the newly installed $ORACLE_HOME/rdbms/admin directory of the version you are planning to upgrade to. Getting a hold of the pre-upgrade script used to mean downloading the entire Oracle Database Release kit, unpacking it, and pulling it out of the admin directory. Allowing access to the script through this method will make the Oracle Database Upgrade planning easier.
Solution
[Insert note here]
Script Guidelines
The pre-upgrade scripts can be executed on a database without the need to shutdown or restart the database. It gathers information about the database configuration and reports on conditions, parameters and settings which may need attention prior to upgrading to the new version.
You must have DBA privilege to execute the script successfully.
The Database can not be in read-only mode. A few registry$ tables may be created, if they do not already exist, and some rows may be inserted into existing Upgrade tables.
Script Execution Steps
See the table below to determine which version of the pre-upgrade script you need. It will depend on which version you are upgrading from, and which version you are upgrading to
Save the file to a directory that will be accessible when you connect to your database
Run SQL*Plus and connect to the database to be upgraded using an account with DBA privileges
Set spool output to save data reported by the script
Execute the script
Review the output
Correct any deficiencies noted in the script output
Coming From Version
Script Build/Date
Upgrade Target Version
9.2.0 (9.2.0.8 and above),
10.1.0, 10.2.0,
11.1.0, 11.2.0.1
Build 4
December 2010 11gR2
(11.2.0.2) - utlu112i_2.sql
Use the above script when your target upgrade is 11.2.0.2. If you are planning to upgrade to 11.2.0.1, use the utlu112_1.sql script below.
9.2.0 (9.2.0.8 and above),
10.1.0, 10.2.0,
11.1.0
Build 4
December 2010 11gR2
(11.2.0.1) - utlu112i_1.sql
9.2.0 (9.2.0.4 and above),
10.1.0,10.2.0
Build 2
December 2010 11gR1- utlu111i.sql
8.1.7, 9.0.1,
9.2.0 (9.2.0.4 and above),
10.1.0
Build 2
December 2010 10gR2 - utlu102i.sql
Script Changes
utlu112i_2.sql - Upgrade to 11.2.0.2 - Build 4 - December 2010
This script should be used when upgrading to 11.2.0.2. The version of the timezone file shipped with 11.2.0.2 is newer than 11.2.0.1 and this version verifies you are at the right version for an upgrade to 11.2.0.2.
All changes fixed in utlu112i_1.sql
Timezone to version 14
utlu112i_1.sql - Upgrade to 11.2.0.1 - Build 4 - December 2010
Below are the enhancements and changes added into Build 4:
Timezone version updates
Obsolete cell_partition_large_extents
OLS & DV msgs to reflect 112 installer
Fix connect by statement
Add DMSYS recommendation coming from 11.1 to 11.2
Size tablespace with apex correctly
Fix invalid object list
Fix XML output for STATUS/VERSION of components
Fix for xml output
Change drop table to truncate if possible
Check for editioning views
utlu111i.sql - Build 2 - December 2010
Below are the enhancements and changes added into Build 2:
Timezone version updates
Optimize select statements for dba_queues
utlu102.sql - Build 2 - December 2010
Below are the enhancements and changes added into Build 2:
cursor_space_for_time is deprecated
Tablespace size updates
Invalid Object update
utlu112i.sql - Build 3 - June 2010
Below are the enhancements and changes added into Build 3:
Linesize decreased to 100
Check for Stale Statistics removed
Recommendation section added (Hidden parameter/events moved to this section)
utlu112i.sql - Build 2 - May 2010
Below are the enhancements and changes added into Build 2:
Warning issued about hidden parameters that are in use
Warning issued about non-default events
Warning issued about ldap dependencies
Warning issued if database in MOUNT state
Warning added relating to UltraSearch
Warning issued if run by non SYS-DBA
Warning for Recycle bin added (changed from recommend to MUST be purged)
Recommendations added on shared pool size for both 32/64 bit target systems
Stats check updated
Allow limited set of checks if database in read-only mode
Removed Network ACL check
Removed cursor_space_for_time warning
Removed text relating to auto-extent. Wording was too confusing
Removed ASM check (non-functioning)
References
NOTE:466181.1 - 10g Upgrade Companion
NOTE:601807.1 - Oracle 11gR1 Upgrade Companion
NOTE:785351.1 - Oracle 11gR2 Upgrade Companion
Attachments
Upgrade Script for 10.1 (130.5 KB)
Upgrade Script for 11.1 (157.09 KB)
Upgrade Script for 11.2.0.1 (200.03 KB)
Upgrade Script for 11.2.0.2 (200.11 KB)
Related
Products
Oracle Database Products > Oracle Database > Oracle Database > Oracle Server - Standard Edition
Oracle Database Products > Oracle Database > Oracle Database > Oracle Server - Enterprise Edition
Keywords
DATABASE UPGRADE; ORACLE DATABASE; PRE-UPGRADE UTILITY; UPGRADE; UPGRADE 10.2.0; UPGRADE 11.1.0.7; UPGRADE PREPARATION; UTILITY
Back to top
Rate this document
Modified 05-MAY-2011 Type HOWTO Status PUBLISHED
In this Document
Goal
Origin of Script
Solution
[Insert note here]
Script Guidelines
Script Execution Steps
Script Changes
References
Applies to:
Oracle Server - Standard Edition - Version: 9.2.0.4 to 11.2.0.2 - Release: 9.2 to 11.2
Oracle Server - Enterprise Edition - Version: 9.2.0.4 to 11.2.0.2 [Release: 9.2 to 11.2]
Information in this document applies to any platform.
Goal
One of the first steps that should be taken prior to an Oracle Database Upgrade is determining any issues the upgrade may present to your database.
Oracle Database Pre-Upgrade utility is executed on your existing database, while the database is running (no shutdown required) and provides a list of items which should be reviewed prior to the actual upgrade. Reviewing and making adjustments prior to actual database upgrade will usually reduce down time and can limit problems during the upgrade.
Origin of Script
The pre-upgrade scripts that are available for download below are shipped with each Oracle Database release. The scripts can also be found in the newly installed $ORACLE_HOME/rdbms/admin directory of the version you are planning to upgrade to. Getting a hold of the pre-upgrade script used to mean downloading the entire Oracle Database Release kit, unpacking it, and pulling it out of the admin directory. Allowing access to the script through this method will make the Oracle Database Upgrade planning easier.
Solution
[Insert note here]
Script Guidelines
The pre-upgrade scripts can be executed on a database without the need to shutdown or restart the database. It gathers information about the database configuration and reports on conditions, parameters and settings which may need attention prior to upgrading to the new version.
You must have DBA privilege to execute the script successfully.
The Database can not be in read-only mode. A few registry$ tables may be created, if they do not already exist, and some rows may be inserted into existing Upgrade tables.
Script Execution Steps
See the table below to determine which version of the pre-upgrade script you need. It will depend on which version you are upgrading from, and which version you are upgrading to
Save the file to a directory that will be accessible when you connect to your database
Run SQL*Plus and connect to the database to be upgraded using an account with DBA privileges
Set spool output to save data reported by the script
Execute the script
Review the output
Correct any deficiencies noted in the script output
Coming From Version
Script Build/Date
Upgrade Target Version
9.2.0 (9.2.0.8 and above),
10.1.0, 10.2.0,
11.1.0, 11.2.0.1
Build 4
December 2010 11gR2
(11.2.0.2) - utlu112i_2.sql
Use the above script when your target upgrade is 11.2.0.2. If you are planning to upgrade to 11.2.0.1, use the utlu112_1.sql script below.
9.2.0 (9.2.0.8 and above),
10.1.0, 10.2.0,
11.1.0
Build 4
December 2010 11gR2
(11.2.0.1) - utlu112i_1.sql
9.2.0 (9.2.0.4 and above),
10.1.0,10.2.0
Build 2
December 2010 11gR1- utlu111i.sql
8.1.7, 9.0.1,
9.2.0 (9.2.0.4 and above),
10.1.0
Build 2
December 2010 10gR2 - utlu102i.sql
Script Changes
utlu112i_2.sql - Upgrade to 11.2.0.2 - Build 4 - December 2010
This script should be used when upgrading to 11.2.0.2. The version of the timezone file shipped with 11.2.0.2 is newer than 11.2.0.1 and this version verifies you are at the right version for an upgrade to 11.2.0.2.
All changes fixed in utlu112i_1.sql
Timezone to version 14
utlu112i_1.sql - Upgrade to 11.2.0.1 - Build 4 - December 2010
Below are the enhancements and changes added into Build 4:
Timezone version updates
Obsolete cell_partition_large_extents
OLS & DV msgs to reflect 112 installer
Fix connect by statement
Add DMSYS recommendation coming from 11.1 to 11.2
Size tablespace with apex correctly
Fix invalid object list
Fix XML output for STATUS/VERSION of components
Fix for xml output
Change drop table to truncate if possible
Check for editioning views
utlu111i.sql - Build 2 - December 2010
Below are the enhancements and changes added into Build 2:
Timezone version updates
Optimize select statements for dba_queues
utlu102.sql - Build 2 - December 2010
Below are the enhancements and changes added into Build 2:
cursor_space_for_time is deprecated
Tablespace size updates
Invalid Object update
utlu112i.sql - Build 3 - June 2010
Below are the enhancements and changes added into Build 3:
Linesize decreased to 100
Check for Stale Statistics removed
Recommendation section added (Hidden parameter/events moved to this section)
utlu112i.sql - Build 2 - May 2010
Below are the enhancements and changes added into Build 2:
Warning issued about hidden parameters that are in use
Warning issued about non-default events
Warning issued about ldap dependencies
Warning issued if database in MOUNT state
Warning added relating to UltraSearch
Warning issued if run by non SYS-DBA
Warning for Recycle bin added (changed from recommend to MUST be purged)
Recommendations added on shared pool size for both 32/64 bit target systems
Stats check updated
Allow limited set of checks if database in read-only mode
Removed Network ACL check
Removed cursor_space_for_time warning
Removed text relating to auto-extent. Wording was too confusing
Removed ASM check (non-functioning)
References
NOTE:466181.1 - 10g Upgrade Companion
NOTE:601807.1 - Oracle 11gR1 Upgrade Companion
NOTE:785351.1 - Oracle 11gR2 Upgrade Companion
Attachments
Upgrade Script for 10.1 (130.5 KB)
Upgrade Script for 11.1 (157.09 KB)
Upgrade Script for 11.2.0.1 (200.03 KB)
Upgrade Script for 11.2.0.2 (200.11 KB)
Related
Products
Oracle Database Products > Oracle Database > Oracle Database > Oracle Server - Standard Edition
Oracle Database Products > Oracle Database > Oracle Database > Oracle Server - Enterprise Edition
Keywords
DATABASE UPGRADE; ORACLE DATABASE; PRE-UPGRADE UTILITY; UPGRADE; UPGRADE 10.2.0; UPGRADE 11.1.0.7; UPGRADE PREPARATION; UTILITY
Back to top
Rate this document
How To Find RDBMS patchsets on My Oracle Support
How To Find RDBMS patchsets on My Oracle Support [ID 438049.1]
Modified 05-NOV-2010 Type HOWTO Status PUBLISHED
In this Document
Goal
Solution
References
Applies to:
Oracle Server - Enterprise Edition - Version: 8.1.7.4 to 11.2.0.2 - Release: 8.1.7 to 11.2
Information in this document applies to any platform.
Oracle Server - Standard Edition - Version: 8.1.7.4 to 11.2.0.2 - Release: 8.1 to 11.2
Oracle Server - Personal Edition - Version: 8.1.7.4 to 11.2.0.2 - Release: 8.1 to 11.2 only to windows platform
Oracle Client - Version: 8.1.7.4 to 11.2.0.2 - Release: 8.1 to 11.2
Goal
This is a summary of the Database Server patchsets available in My Oracle Support . The intention is to keep this matrix up to date with the common patchset releases for the main OS platforms. Please note that this is a generic OS platform note and is possible that a given patchset number is not available for your platform.
This list should be valid for the most common OS platforms such as AIX, Solaris, HP-UX, Linux, and Windows. The patch NUMBER is valid and generally the same for all OS platforms, though the NAME of the file downloaded will be different for each OS platform.
Solution
1. How to download a patchset from Metalink?
Go to "Patches & Updates" menu option
Type the number of the patch that you want to download in the patch name of number field , that should be some of the following:
Patch Description
------ ------------
10098816 Patchset 11.2.0.2 PATCH SET FOR ORACLE DATABASE SERVER 11.2.0.2 Please note that 11.2 Patch Sets 11.2.0.2 and higher are supplied as full releases.See Note:1189783.1 for details.
6890831 Patchset 11.1.0.7 PATCH SET FOR ORACLE DATABASE SERVER 11.1.0.7
8202632 Patchset 10.2.0.5 PATCH SET FOR ORACLE DATABASE SERVER 10.2.0.5
6810189 Patchset 10.2.0.4 PATCH SET FOR ORACLE DATABASE SERVER 10.2.0.4
5337014 Patchset 10.2.0.3 PATCH SET FOR ORACLE DATABASE SERVER 10.2.0.3
4547817 Patchset 10.2.0.2 PATCH SET FOR ORACLE DATABASE SERVER 10.2.0.2
4505133 Patchset 10.1.0.5 PATCH SET FOR ORACLE DATABASE SERVER 10.1.0.5
4163362 Patchset 10.1.0.4 PATCH SET FOR ORACLE DATABASE SERVER 10.1.0.4
3761843 Patchset 10.1.0.3 PATCH SET FOR ORACLE DATABASE SERVER 10.1.0.3
4547809 Patchset 9.2.0.8 PATCH SET FOR ORACLE DATABASE SERVER 9.2.0.8
4163445 Patchset 9.2.0.7 PATCH SET FOR ORACLE DATABASE SERVER 9.2.0.7
3948480 Patchset 9.2.0.6 PATCH SET FOR ORACLE DATABASE SERVER 9.2.0.6
3501955 Patchset 9.2.0.5 PATCH SET FOR ORACLE DATABASE SERVER 9.2.0.5
3095277 Patchset 9.2.0.4 PATCH SET FOR ORACLE DATABASE SERVER 9.2.0.4
2761332 Patchset 9.2.0.3 PATCH SET FOR ORACLE DATABASE SERVER 9.2.0.3
2632931 Patchset 9.2.0.2 PATCH SET FOR ORACLE DATABASE SERVER 9.2.0.2
3301544 Patchset 9.0.1.5 PATCH SET FOR ORACLE DATABASE SERVER 9.0.1.5
2517300 Patchset 9.0.1.4 PATCH SET FOR ORACLE DATABASE SERVER 9.0.1.4
2376472 Patchset 8.1.7.4 PATCH SET FOR ORACLE DATABASE SERVER 8.1.7.4
Select your OS platform., you can choose 5 platform as same time .
Click "Search " button.
You can save the patchset media to the hard disk on your computer.
3. Additional Instructions.
c. Client Patchset.
For database and client upgrade use the same patch set. There is no separate patch set for client
a. UNIX specific instructions:
Often the patch was downloaded to a windows PC, and you should transfer the file to the UNIX server in binary mode using ftp tools or similar.
Double-check the size and cksum of the downloaded file on the UNIX system.
Uncompress the zip file using the unzip tools under the UNIX system. Please don't use any unzip arguments; for instance unzip -a could corrupt the Patch set Media.
Open the Readme.html file and follow it to install the Patch Set.
b. Windows specific instructions:
Check the size of the downloaded file.
Uncompress the zip file using the unzip tools. Please don't use any unzip arguments if you want to use the unzip command line tools; for instance unzip -a could corrupt the Patch set Media.
Open the Readme.html file and read instructions to install the Patch Set.
Modified 05-NOV-2010 Type HOWTO Status PUBLISHED
In this Document
Goal
Solution
References
Applies to:
Oracle Server - Enterprise Edition - Version: 8.1.7.4 to 11.2.0.2 - Release: 8.1.7 to 11.2
Information in this document applies to any platform.
Oracle Server - Standard Edition - Version: 8.1.7.4 to 11.2.0.2 - Release: 8.1 to 11.2
Oracle Server - Personal Edition - Version: 8.1.7.4 to 11.2.0.2 - Release: 8.1 to 11.2 only to windows platform
Oracle Client - Version: 8.1.7.4 to 11.2.0.2 - Release: 8.1 to 11.2
Goal
This is a summary of the Database Server patchsets available in My Oracle Support . The intention is to keep this matrix up to date with the common patchset releases for the main OS platforms. Please note that this is a generic OS platform note and is possible that a given patchset number is not available for your platform.
This list should be valid for the most common OS platforms such as AIX, Solaris, HP-UX, Linux, and Windows. The patch NUMBER is valid and generally the same for all OS platforms, though the NAME of the file downloaded will be different for each OS platform.
Solution
1. How to download a patchset from Metalink?
Go to "Patches & Updates" menu option
Type the number of the patch that you want to download in the patch name of number field , that should be some of the following:
Patch Description
------ ------------
10098816 Patchset 11.2.0.2 PATCH SET FOR ORACLE DATABASE SERVER 11.2.0.2 Please note that 11.2 Patch Sets 11.2.0.2 and higher are supplied as full releases.See Note:1189783.1 for details.
6890831 Patchset 11.1.0.7 PATCH SET FOR ORACLE DATABASE SERVER 11.1.0.7
8202632 Patchset 10.2.0.5 PATCH SET FOR ORACLE DATABASE SERVER 10.2.0.5
6810189 Patchset 10.2.0.4 PATCH SET FOR ORACLE DATABASE SERVER 10.2.0.4
5337014 Patchset 10.2.0.3 PATCH SET FOR ORACLE DATABASE SERVER 10.2.0.3
4547817 Patchset 10.2.0.2 PATCH SET FOR ORACLE DATABASE SERVER 10.2.0.2
4505133 Patchset 10.1.0.5 PATCH SET FOR ORACLE DATABASE SERVER 10.1.0.5
4163362 Patchset 10.1.0.4 PATCH SET FOR ORACLE DATABASE SERVER 10.1.0.4
3761843 Patchset 10.1.0.3 PATCH SET FOR ORACLE DATABASE SERVER 10.1.0.3
4547809 Patchset 9.2.0.8 PATCH SET FOR ORACLE DATABASE SERVER 9.2.0.8
4163445 Patchset 9.2.0.7 PATCH SET FOR ORACLE DATABASE SERVER 9.2.0.7
3948480 Patchset 9.2.0.6 PATCH SET FOR ORACLE DATABASE SERVER 9.2.0.6
3501955 Patchset 9.2.0.5 PATCH SET FOR ORACLE DATABASE SERVER 9.2.0.5
3095277 Patchset 9.2.0.4 PATCH SET FOR ORACLE DATABASE SERVER 9.2.0.4
2761332 Patchset 9.2.0.3 PATCH SET FOR ORACLE DATABASE SERVER 9.2.0.3
2632931 Patchset 9.2.0.2 PATCH SET FOR ORACLE DATABASE SERVER 9.2.0.2
3301544 Patchset 9.0.1.5 PATCH SET FOR ORACLE DATABASE SERVER 9.0.1.5
2517300 Patchset 9.0.1.4 PATCH SET FOR ORACLE DATABASE SERVER 9.0.1.4
2376472 Patchset 8.1.7.4 PATCH SET FOR ORACLE DATABASE SERVER 8.1.7.4
Select your OS platform., you can choose 5 platform as same time .
Click "Search " button.
You can save the patchset media to the hard disk on your computer.
3. Additional Instructions.
c. Client Patchset.
For database and client upgrade use the same patch set. There is no separate patch set for client
a. UNIX specific instructions:
Often the patch was downloaded to a windows PC, and you should transfer the file to the UNIX server in binary mode using ftp tools or similar.
Double-check the size and cksum of the downloaded file on the UNIX system.
Uncompress the zip file using the unzip tools under the UNIX system. Please don't use any unzip arguments; for instance unzip -a could corrupt the Patch set Media.
Open the Readme.html file and follow it to install the Patch Set.
b. Windows specific instructions:
Check the size of the downloaded file.
Uncompress the zip file using the unzip tools. Please don't use any unzip arguments if you want to use the unzip command line tools; for instance unzip -a could corrupt the Patch set Media.
Open the Readme.html file and read instructions to install the Patch Set.
Oracle Retail Business Process Documents for Implementing the Release 13.1.x Oracle Retail Merchandising Products
Oracle Retail Business Process Documents for Implementing the Release 13.1.x Oracle Retail Merchandising Products [ID 1072132.1]
Modified 12-MAR-2010 Type WHITE PAPER Status PUBLISHED
In this Document
Abstract
Document History
Oracle Retail Business Process Documents for Implementing the Release 13.1.x Oracle Retail Merchandising Products
Assumptions
Related Documents
Usage
Design Notes
Overview
Key Definitions and Acronyms
Process Naming Standard and Numbering Conventions
Process Maps (Swim lane Diagram)
Process Design (Spreadsheet)
Centralized Configuration Document
Applies to:
Oracle Retail Merchandising System - Version: 13.1 to 13.1 - Release: 13 to 13
Information in this document applies to any platform.
Abstract
This document explains how to use the Merchandising business processes. The processes are written assuming that version 13.1 of the following Oracle Retail products will be installed:
Merchandising System - RMS
Invoice Matching - ReIM
Sales Audit - ReSA
Price Management - RPM
Trade Management - RTM
Allocation
Document History
Update Date 12-March-2010
Oracle Retail Business Process Documents for Implementing the Release 13.1.x Oracle Retail Merchandising Products
While the processes are developed with the previous product set in mind, they can be applied to any retailer who has purchased the Oracle Retail Merchandising products. There are four general audiences for whom these processes are written:
Retail clients who have purchased and are implementing the Oracle Retail Merchandising products
Integrators and implementers who are implementing the Merchandising products
Business analysts who want to understand how the Merchandising System can be applied as a business solution
System analysts and system operations personnel who need additional functional understanding of the Merchandising products
Assumptions
Any application not in the standard list above (for example, store systems, financial systems, warehouse systems) does not have a step-by-step explanation within the process. The processes focus on the list of products above. Any other product referred to should be considered a generic product.
These business processes are tailored to the Oracle Retail applications; however, they do not include detailed technical information such as interfaces or batch programs. Additionally, these documents should not be viewed as a substitute for product training.
Each retailer will still modify some of the processes to tailor them to their specific business needs.
Related Documents
For more information, see the following Oracle Retail documentation:
Oracle Retail Allocation User Guide
Oracle Retail Invoice Matching User Guide
Oracle Retail Merchandising System User Guide
Oracle Retail Price Management User Guide
Oracle Retail Sales Audit User Guide
Oracle Retail Trade Management User Guide
Usage
The business process designs are intended to support an implementation of the Merchandising products. These designs are a guide for both the business and implementation teams. They explain some scenarios and factors that need to be considered for a successful implementation. The designs are created for a generic retailer, with some considerations made for hardlines, apparel (softlines) and grocery. Because of this, retailers may find that they want to change the business processes to meet their unique needs, but the documents should provide a solid initial foundation.
Design Notes
Overview
The Oracle Retail business process designs are separated into six functional categories:
1.0 Manage Foundation Data
2.0 Manage Items
3.0 Manage Pricing
4.0 Manage Purchase Orders
5.0 Manage Inventory
6.0 Manage Finance
Each category is then broken down into more specific functional subcategories. Every process map and design falls into one of the subcategories. For example, category 1 is divided as follows:
1.0 Manage Foundation Data
1.1 Manage Merchandise Foundation
1.1.1 Manage Merchandise Hierarchy
1.1.1.1 Create Merchandising Hierarchy (business process designs required)
1.1.1.2 Maintain Merchandising Hierarchy (business process designs required)
1.1.2 Manage Reclassification
1.1.3 Manage Diffs
1.2 Manage Organization Foundation
1.3 Manage Other Foundation Data
For each subcategory for which business process designs are required, a process map and process design are delivered:
Process Map (swim lane diagram) - The process map is a visual representation of how the end user would carry out a specific business process. This process shows how data flows through the system, decisions that users will need to make, and activities that the user will have to carry out to complete a particular process.
Process Design (spreadsheet) - The process design covers the same process as the swim lane diagram, but it offers a detailed step-by-step instruction set for the user to complete the process. The spreadsheet also offers a comprehensive look at all the factors that go into successfully carrying out the process, including key system parameters and implementation considerations.
Key Definitions and Acronyms
BPD - Business process designs
WH - Warehouse
POS - Point of sale system
Process Naming Standard and Numbering Conventions
Process Map 1.2.3.4 v##.vsd
1.2.3.4 = Process ID
Title numbering for the process maps is for categorizing purposes only, and is not to be interpreted as a sequential order of implementation.
Process Design 1.2.3.4 v##.xls
The activity shapes within a process map are numbered with the process ID, followed by sequential numbering, and correspond to the step-by-step directions used in the process design to list activity details. For example, 1.2.3.4.1 represents the first step in the process with the ID 1.2.3.4.
Process Maps (Swim lane Diagram)
For a detailed explanation of the symbols used, consult the Retail Business Process Modeling Symbols document.
Note: Roles documented in the process maps and process designs are subject to change, depending on the organizational structure of the retailer.
Process Design (Spreadsheet)
The process designs are a more detailed representation of the process maps. The process designs are detailed in five tabs:
Subprocess: The subprocess tab is an overview of the entire process, describing assumptions, functional areas and roles, user access, frequency of the process, key impacts for each role, benefits, benefit impacts, key performance indicators, and system availability requirements.
Activity and Task: The activity and task tab is a more detailed, step-by-step representation of the process maps. This tab identifies the system, screen name, and field name of each step the user needs to complete, and also calls out any Oracle Retail User Guide documentation available to support this process.
System Parameters: The system parameters tab details any system settings (typically from the system options, system variables, or unit options tables) and the suggested settings of these parameters to support the specific process.
Implementation Considerations: The implementation considerations tab highlights any key steps that may be need to be carried out before or during implementation of the system or process involved.
Issues: The issues tab is for retailers and implementers who might want to list any outstanding issues that apply to this process in their own unique environment.
Drop Down Lists: This tab contains the source of the lists used for the drop-down boxes within the other tabs of the spreadsheet.
Centralized Configuration Document
This document consolidates all the configuration requirements and the suggested settings by retail segments (hardlines, apparel [softlines], and grocery) in the Oracle Retail Merchandising System, Invoice Matching, Price Management, Allocation, Trade Management, and Sales Audit applications. The centralized configuration document includes the following tabs:
SE Configuration: This tab details the following for the configuration parameters that need to be defined and maintained in the Merchandising products, including the following:
System parameter settings - These are indicators set in the system parameter tables that enable certain functionalities within the products. Generally, these parameters are set during implementation and are not changed.
Codes - The code tables contain predefined lists that commonly appear in drop-down boxes and list-of-values fields in the products. The business can add additional values to the relevant code details based on the client specific business requirements; however, it is not recommended to remove any system-defined code detail values (especially those marked with "required"), unless there is a strong business reason behind the decision to do so. Code detail values may be referenced by various modules, and removing these values might have undesirable system impacts. Detailed analysis is recommended before removing the system-defined code detail values to ensure no system impact. It is also recommended that the original scripts for the code tables are not modified, so that the original values can always be referenced. Instead, new scripts can be created to update, add, or remove values from the original script to create the client-specific version. The code values that can be configured have been included in the centralized configuration document.
Configuration Master Data - Configuration data is more static in nature, and the frequency of the maintenance is very low (for example, inventory reason codes, price change reason codes)
Translations: This tab contains some additional configuration guidelines for retailers who want to use translated values in Merchandising products. This information can be used in conjunction with the detailed instructions available in the Operations Guide for each product.
VAT Reference: This tab illustrates how to set up VAT functionality in Oracle Retail Merchandising System.
Out of Scope Parameters: This tab includes all system parameters that affect functionalities that are not included in the Standard Edition scope (for example, contract, data warehouse).
Attachments
1Foundation.pdf (700.84 KB)
1ManageFoundation.zip (1,502.68 KB)
2ManageItems.pdf (478.3 KB)
2ManageItems.zip (979.42 KB)
3ManagePricingVendorCost.pdf (649.86 KB)
3ManagePricingVendorCost.zip (1,248.43 KB)
4ManagePOsAllocReplDealsRTM.pdf (705.77 KB)
4ManagePOsAllocReplDealsRTM.zip (1,690.88 KB)
5ManageInventoryRESA.pdf (834.78 KB)
5ManageInventorySalesAudit.zip (1,812.9 KB)
6FinancialCostAdStockLedgerInvoiceMatching.zip (769.21 KB)
6FinancialCostAdjStockLedgerREIM.pdf (326.53 KB)
Level1Categorization.zip (156.56 KB)
Level2ProcessDesigns.zip (602.98 KB)
MerchandiseSELevel2.pdf (197.04 KB)
RetailBusinessProcessModelingSymbols.pdf (60.1 KB)
SEBPDReadMeDocument.zip (45.66 KB)
SECentralizedConfiguration.zip (148.05 KB)
Related
Products
More Applications > Industry Solutions > Retail > Oracle Retail Merchandising System
Back to top
Modified 12-MAR-2010 Type WHITE PAPER Status PUBLISHED
In this Document
Abstract
Document History
Oracle Retail Business Process Documents for Implementing the Release 13.1.x Oracle Retail Merchandising Products
Assumptions
Related Documents
Usage
Design Notes
Overview
Key Definitions and Acronyms
Process Naming Standard and Numbering Conventions
Process Maps (Swim lane Diagram)
Process Design (Spreadsheet)
Centralized Configuration Document
Applies to:
Oracle Retail Merchandising System - Version: 13.1 to 13.1 - Release: 13 to 13
Information in this document applies to any platform.
Abstract
This document explains how to use the Merchandising business processes. The processes are written assuming that version 13.1 of the following Oracle Retail products will be installed:
Merchandising System - RMS
Invoice Matching - ReIM
Sales Audit - ReSA
Price Management - RPM
Trade Management - RTM
Allocation
Document History
Update Date 12-March-2010
Oracle Retail Business Process Documents for Implementing the Release 13.1.x Oracle Retail Merchandising Products
While the processes are developed with the previous product set in mind, they can be applied to any retailer who has purchased the Oracle Retail Merchandising products. There are four general audiences for whom these processes are written:
Retail clients who have purchased and are implementing the Oracle Retail Merchandising products
Integrators and implementers who are implementing the Merchandising products
Business analysts who want to understand how the Merchandising System can be applied as a business solution
System analysts and system operations personnel who need additional functional understanding of the Merchandising products
Assumptions
Any application not in the standard list above (for example, store systems, financial systems, warehouse systems) does not have a step-by-step explanation within the process. The processes focus on the list of products above. Any other product referred to should be considered a generic product.
These business processes are tailored to the Oracle Retail applications; however, they do not include detailed technical information such as interfaces or batch programs. Additionally, these documents should not be viewed as a substitute for product training.
Each retailer will still modify some of the processes to tailor them to their specific business needs.
Related Documents
For more information, see the following Oracle Retail documentation:
Oracle Retail Allocation User Guide
Oracle Retail Invoice Matching User Guide
Oracle Retail Merchandising System User Guide
Oracle Retail Price Management User Guide
Oracle Retail Sales Audit User Guide
Oracle Retail Trade Management User Guide
Usage
The business process designs are intended to support an implementation of the Merchandising products. These designs are a guide for both the business and implementation teams. They explain some scenarios and factors that need to be considered for a successful implementation. The designs are created for a generic retailer, with some considerations made for hardlines, apparel (softlines) and grocery. Because of this, retailers may find that they want to change the business processes to meet their unique needs, but the documents should provide a solid initial foundation.
Design Notes
Overview
The Oracle Retail business process designs are separated into six functional categories:
1.0 Manage Foundation Data
2.0 Manage Items
3.0 Manage Pricing
4.0 Manage Purchase Orders
5.0 Manage Inventory
6.0 Manage Finance
Each category is then broken down into more specific functional subcategories. Every process map and design falls into one of the subcategories. For example, category 1 is divided as follows:
1.0 Manage Foundation Data
1.1 Manage Merchandise Foundation
1.1.1 Manage Merchandise Hierarchy
1.1.1.1 Create Merchandising Hierarchy (business process designs required)
1.1.1.2 Maintain Merchandising Hierarchy (business process designs required)
1.1.2 Manage Reclassification
1.1.3 Manage Diffs
1.2 Manage Organization Foundation
1.3 Manage Other Foundation Data
For each subcategory for which business process designs are required, a process map and process design are delivered:
Process Map (swim lane diagram) - The process map is a visual representation of how the end user would carry out a specific business process. This process shows how data flows through the system, decisions that users will need to make, and activities that the user will have to carry out to complete a particular process.
Process Design (spreadsheet) - The process design covers the same process as the swim lane diagram, but it offers a detailed step-by-step instruction set for the user to complete the process. The spreadsheet also offers a comprehensive look at all the factors that go into successfully carrying out the process, including key system parameters and implementation considerations.
Key Definitions and Acronyms
BPD - Business process designs
WH - Warehouse
POS - Point of sale system
Process Naming Standard and Numbering Conventions
Process Map 1.2.3.4
1.2.3.4 = Process ID
Title numbering for the process maps is for categorizing purposes only, and is not to be interpreted as a sequential order of implementation.
Process Design 1.2.3.4
The activity shapes within a process map are numbered with the process ID, followed by sequential numbering, and correspond to the step-by-step directions used in the process design to list activity details. For example, 1.2.3.4.1 represents the first step in the process with the ID 1.2.3.4.
Process Maps (Swim lane Diagram)
For a detailed explanation of the symbols used, consult the Retail Business Process Modeling Symbols document.
Note: Roles documented in the process maps and process designs are subject to change, depending on the organizational structure of the retailer.
Process Design (Spreadsheet)
The process designs are a more detailed representation of the process maps. The process designs are detailed in five tabs:
Subprocess: The subprocess tab is an overview of the entire process, describing assumptions, functional areas and roles, user access, frequency of the process, key impacts for each role, benefits, benefit impacts, key performance indicators, and system availability requirements.
Activity and Task: The activity and task tab is a more detailed, step-by-step representation of the process maps. This tab identifies the system, screen name, and field name of each step the user needs to complete, and also calls out any Oracle Retail User Guide documentation available to support this process.
System Parameters: The system parameters tab details any system settings (typically from the system options, system variables, or unit options tables) and the suggested settings of these parameters to support the specific process.
Implementation Considerations: The implementation considerations tab highlights any key steps that may be need to be carried out before or during implementation of the system or process involved.
Issues: The issues tab is for retailers and implementers who might want to list any outstanding issues that apply to this process in their own unique environment.
Drop Down Lists: This tab contains the source of the lists used for the drop-down boxes within the other tabs of the spreadsheet.
Centralized Configuration Document
This document consolidates all the configuration requirements and the suggested settings by retail segments (hardlines, apparel [softlines], and grocery) in the Oracle Retail Merchandising System, Invoice Matching, Price Management, Allocation, Trade Management, and Sales Audit applications. The centralized configuration document includes the following tabs:
SE Configuration: This tab details the following for the configuration parameters that need to be defined and maintained in the Merchandising products, including the following:
System parameter settings - These are indicators set in the system parameter tables that enable certain functionalities within the products. Generally, these parameters are set during implementation and are not changed.
Codes - The code tables contain predefined lists that commonly appear in drop-down boxes and list-of-values fields in the products. The business can add additional values to the relevant code details based on the client specific business requirements; however, it is not recommended to remove any system-defined code detail values (especially those marked with "required"), unless there is a strong business reason behind the decision to do so. Code detail values may be referenced by various modules, and removing these values might have undesirable system impacts. Detailed analysis is recommended before removing the system-defined code detail values to ensure no system impact. It is also recommended that the original scripts for the code tables are not modified, so that the original values can always be referenced. Instead, new scripts can be created to update, add, or remove values from the original script to create the client-specific version. The code values that can be configured have been included in the centralized configuration document.
Configuration Master Data - Configuration data is more static in nature, and the frequency of the maintenance is very low (for example, inventory reason codes, price change reason codes)
Translations: This tab contains some additional configuration guidelines for retailers who want to use translated values in Merchandising products. This information can be used in conjunction with the detailed instructions available in the Operations Guide for each product.
VAT Reference: This tab illustrates how to set up VAT functionality in Oracle Retail Merchandising System.
Out of Scope Parameters: This tab includes all system parameters that affect functionalities that are not included in the Standard Edition scope (for example, contract, data warehouse).
Attachments
1Foundation.pdf (700.84 KB)
1ManageFoundation.zip (1,502.68 KB)
2ManageItems.pdf (478.3 KB)
2ManageItems.zip (979.42 KB)
3ManagePricingVendorCost.pdf (649.86 KB)
3ManagePricingVendorCost.zip (1,248.43 KB)
4ManagePOsAllocReplDealsRTM.pdf (705.77 KB)
4ManagePOsAllocReplDealsRTM.zip (1,690.88 KB)
5ManageInventoryRESA.pdf (834.78 KB)
5ManageInventorySalesAudit.zip (1,812.9 KB)
6FinancialCostAdStockLedgerInvoiceMatching.zip (769.21 KB)
6FinancialCostAdjStockLedgerREIM.pdf (326.53 KB)
Level1Categorization.zip (156.56 KB)
Level2ProcessDesigns.zip (602.98 KB)
MerchandiseSELevel2.pdf (197.04 KB)
RetailBusinessProcessModelingSymbols.pdf (60.1 KB)
SEBPDReadMeDocument.zip (45.66 KB)
SECentralizedConfiguration.zip (148.05 KB)
Related
Products
More Applications > Industry Solutions > Retail > Oracle Retail Merchandising System
Back to top
Thursday, June 9, 2011
Cannot Compile PA Task DFF - APP-FND-00874: Routine FDFBDF Found No Rows In Table FND_DESCRIPTIVE_FLEXS
Cannot Compile PA Task DFF - APP-FND-00874: Routine FDFBDF Found No Rows In Table FND_DESCRIPTIVE_FLEXS [ID 747081.1]
Modified 29-JAN-2010 Type PROBLEM Status PUBLISHED
In this Document
Symptoms
Changes
Cause
Solution
Applies to:
Oracle Project Foundation - Version: 12.0.4
Information in this document applies to any platform.
ConcurrentProgram:FDFCMPD - Compile Descriptive Flexfields
Symptoms
When trying to compile a task descriptive flexfield (DFF) the following error is encountered:
APP-FND-00874: Routine FDFBDF found no rows in table FND_DESCRIPTIVE_FLEXS.
Changes
A new language was installed.
Cause
Incomplete setup.
A new language was installed and the Maintain Multilingual Tables utility was not run.
Solution
To implement the solution, execute the following steps:
1. Using ADADMIN run 'Maintain Multilingual Tables'.
2. Retest the issue.
Modified 29-JAN-2010 Type PROBLEM Status PUBLISHED
In this Document
Symptoms
Changes
Cause
Solution
Applies to:
Oracle Project Foundation - Version: 12.0.4
Information in this document applies to any platform.
ConcurrentProgram:FDFCMPD - Compile Descriptive Flexfields
Symptoms
When trying to compile a task descriptive flexfield (DFF) the following error is encountered:
APP-FND-00874: Routine FDFBDF found no rows in table FND_DESCRIPTIVE_FLEXS.
Changes
A new language was installed.
Cause
Incomplete setup.
A new language was installed and the Maintain Multilingual Tables utility was not run.
Solution
To implement the solution, execute the following steps:
1. Using ADADMIN run 'Maintain Multilingual Tables'.
2. Retest the issue.
Step By Step Guide to Creating a Custom Application in Applications 11i
Step By Step Guide to Creating a Custom Application in Applications 11i [ID 216589.1]
Modified 05-MAY-2011 Type WHITE PAPER Status PUBLISHED
Applies to:
Oracle Application Object Library - Version: 11.5.10.0 to 11.5.10.2 [Release: 11.5.10 to 11.5.10]
Information in this document applies to any platform.
*************************************************************
This article is being delivered in Draft form and may contain
errors. Please use the MetaLink "Feedback" button to advise
Oracle of any issues related to this article.
*************************************************************
Abstract
PURPOSE
-------
This note describes the basic steps needed to setup a Custom Application within Oracle Applications 11i.
Step By Step Guide to Creating a Custom Application in Applications 11i
*******************************************************************************
*******************************************************************************
IMPORTANT NOTE - This note is retained for reference only. You should now follow note 270519.1 "Customizing an AutoConfig Environment" to make changes to your system configuration
*******************************************************************************
*******************************************************************************
Creating a Custom Application in Applications 11i
-------------------------------------------------
Custom Applications are required if you are creating new forms, reports, etc. This allows you to segregate your custom written files from the standard seeded functionality that Oracle Applications provide. Customizations can therefore be preserved when applying patches or upgrades to your environment.
1) Make the directory structure for your custom application files.
cd $APPL_TOP
mkdir xxmz
mkdir xxmz/11.5.0
mkdir xxmz/11.5.0/admin
mkdir xxmz/11.5.0/admin/sql
mkdir xxmz/11.5.0/admin/odf
mkdir xxmz/11.5.0/sql
mkdir xxmz/11.5.0/bin
mkdir xxmz/11.5.0/reports
mkdir xxmz/11.5.0/reports/US
mkdir xxmz/11.5.0/forms
mkdir xxmz/11.5.0/forms/US
mkdir xxmz/11.5.0/$APPLLIB
mkdir xxmz/11.5.0/$APPLOUT
mkdir xxmz/11.5.0/$APPLLOG
2) Add the custom module into the environment
Apply ADX.E.1 and add the entry to topfile.txt as a standard product top entry (follow the existing model in the file)
Customised environment variables can be added to AutoConfig by using the filename specificed by s_custom_file, which is then called from the APPSORA.env file.
If using Forms Listener Servlet, you may also need to add $CUSTOM_TOP to formsservlet.ini in $APACHE_TOP/Jserv/etc
3) Create new tablespace for database objects
create tablespace xxmz datafile '/emea/oracle/visuk09/visuk09data/xxmz.dbf' size 10M default storage(initial 10k next 10k)
4) Create schema
create user xxmz identified by xxmz
default tablespace xxmz
temporary tablespace temp
quota unlimited on xxmz
quota unlimited on temp;
grant connect, resource to xxmz;
5) Register your Oracle Schema.
Login to Applications with System Administrator responsibility
Navigate to Application-->Register
Application = xxmz Custom
Short Name = xxmz
Basepath = xxmz_TOP
Description = xxmz Custom Application
6) Register Oracle User
Naviate to Security-->Oracle-->Register
Database User Name = xxmz
Password = xxmz
Privilege = Enabled
Install Group = 0
Description = xxmz Custom Application User
7) Add Application to a Data Group
Navigate to Security-->Oracle-->DataGroup
Data Group = xxmzGroup
Description = xxmz Custom Data Group
Click on "Copy Applications from" and pick Standard data Group, then add the following entry.
Application = xxmz Custom
Oracle ID = APPS
Description = xxmz Custom Application
8) Create custom request group
This will act as a placeholder for any custom reports we wish to make available for the Custom Responsibility (which is defined at a later stage)
Navigate to Security-->responsibility-->Request
Group = xxmz Request Group
Application = xxmz Custom
Code = xxmz
Description = xxmz Custom Requests
We will not define any requests to add to the group at this stage, but you can add some now if required.
9) Create custom menu
This will act as a placeholder for any menu items we wish to make available for the Custom Responsibility (which is defined at a later stage) We will create two menus, one for Core Applications and one for Self Service.
Navigate to Application-->Menu
Menu = xxmz_CUSTOM_MENU
User Menu Name = xxmz Custom Application
Menu Type =
Description = xxmz Custom Application Menu
Seq = 100
Prompt = View Requests
Submenu =
Function = View All Concurrent Requests
Description = View Requests
Seq = 110
Prompt = Run Requests
Submenu =
Function = Requests: Submit
Description = Submit Requests
Menu = xxmz_CUSTOM_MENU_SSWA
User Menu Name = xxmz Custom Application SSWA
Menu Type =
Description = xxmz Custom Application Menu for SSWA
10) Create new responsibility. One for Core Applications and One for Self Service (SSWA)
Navigate to Security-->Responsibility-->Define
Responsibility Name = xxmz Custom
Application = xxmz Custom
Responsibility Key = xxmzCUSTOM
Description = xxmz Custom Responsibility
Available From = Oracle Applications
Data Group Name = xxmzGroup
Data Group Application = xxmz Custom
Menu = xxmz Custom Application
Request Group Name = xxmz Request Group
Responsibility Name = xxmz Custom SSWA
Application = xxmz Custom
Responsibility Key = xxmzCUSTOMSSWA
Description = xxmz Custom Responsibility SSWA
Available From = Oracle Self Service Web Applications
Data Group Name = xxmzGroup
Data Group Application = xxmz Custom
Menu = xxmz Custom Application SSWA
Request Group Name = xxmz Request Group
11) Add responsibility to user
Navigate to Security-->User-->Define
Add xxmz Custom responsibility to users as required.
12) Other considerations
You are now ready to create your database Objects, custom Reports, Forms, Packages, etc
Create the source code files in the xxmz_TOP directory appropriate for the type of object. For example forms would be located in $xxmz_TOP/forms/US or package source code in $xxmz_TOP/admin/sql for example.
Database Objects, such as tables, indexes and sequences should be created in the xxmz schema, then you need to
a) Grant all privilege from each custom data object to the APPS schema.
For example : logged in as xxmz user
grant all privileges on myTable to apps;
b) Create a synonym in APPS for each custom data object
For example : logged in as APPS user
create synonym myTable for xxmz.myTable;
Other database objects, such as views and packages should be created directly in the APPS schema.
Modified 05-MAY-2011 Type WHITE PAPER Status PUBLISHED
Applies to:
Oracle Application Object Library - Version: 11.5.10.0 to 11.5.10.2 [Release: 11.5.10 to 11.5.10]
Information in this document applies to any platform.
*************************************************************
This article is being delivered in Draft form and may contain
errors. Please use the MetaLink "Feedback" button to advise
Oracle of any issues related to this article.
*************************************************************
Abstract
PURPOSE
-------
This note describes the basic steps needed to setup a Custom Application within Oracle Applications 11i.
Step By Step Guide to Creating a Custom Application in Applications 11i
*******************************************************************************
*******************************************************************************
IMPORTANT NOTE - This note is retained for reference only. You should now follow note 270519.1 "Customizing an AutoConfig Environment" to make changes to your system configuration
*******************************************************************************
*******************************************************************************
Creating a Custom Application in Applications 11i
-------------------------------------------------
Custom Applications are required if you are creating new forms, reports, etc. This allows you to segregate your custom written files from the standard seeded functionality that Oracle Applications provide. Customizations can therefore be preserved when applying patches or upgrades to your environment.
1) Make the directory structure for your custom application files.
cd $APPL_TOP
mkdir xxmz
mkdir xxmz/11.5.0
mkdir xxmz/11.5.0/admin
mkdir xxmz/11.5.0/admin/sql
mkdir xxmz/11.5.0/admin/odf
mkdir xxmz/11.5.0/sql
mkdir xxmz/11.5.0/bin
mkdir xxmz/11.5.0/reports
mkdir xxmz/11.5.0/reports/US
mkdir xxmz/11.5.0/forms
mkdir xxmz/11.5.0/forms/US
mkdir xxmz/11.5.0/$APPLLIB
mkdir xxmz/11.5.0/$APPLOUT
mkdir xxmz/11.5.0/$APPLLOG
2) Add the custom module into the environment
Apply ADX.E.1 and add the entry to topfile.txt as a standard product top entry (follow the existing model in the file)
Customised environment variables can be added to AutoConfig by using the filename specificed by s_custom_file, which is then called from the APPSORA.env file.
If using Forms Listener Servlet, you may also need to add $CUSTOM_TOP to formsservlet.ini in $APACHE_TOP/Jserv/etc
3) Create new tablespace for database objects
create tablespace xxmz datafile '/emea/oracle/visuk09/visuk09data/xxmz.dbf' size 10M default storage(initial 10k next 10k)
4) Create schema
create user xxmz identified by xxmz
default tablespace xxmz
temporary tablespace temp
quota unlimited on xxmz
quota unlimited on temp;
grant connect, resource to xxmz;
5) Register your Oracle Schema.
Login to Applications with System Administrator responsibility
Navigate to Application-->Register
Application = xxmz Custom
Short Name = xxmz
Basepath = xxmz_TOP
Description = xxmz Custom Application
6) Register Oracle User
Naviate to Security-->Oracle-->Register
Database User Name = xxmz
Password = xxmz
Privilege = Enabled
Install Group = 0
Description = xxmz Custom Application User
7) Add Application to a Data Group
Navigate to Security-->Oracle-->DataGroup
Data Group = xxmzGroup
Description = xxmz Custom Data Group
Click on "Copy Applications from" and pick Standard data Group, then add the following entry.
Application = xxmz Custom
Oracle ID = APPS
Description = xxmz Custom Application
8) Create custom request group
This will act as a placeholder for any custom reports we wish to make available for the Custom Responsibility (which is defined at a later stage)
Navigate to Security-->responsibility-->Request
Group = xxmz Request Group
Application = xxmz Custom
Code = xxmz
Description = xxmz Custom Requests
We will not define any requests to add to the group at this stage, but you can add some now if required.
9) Create custom menu
This will act as a placeholder for any menu items we wish to make available for the Custom Responsibility (which is defined at a later stage) We will create two menus, one for Core Applications and one for Self Service.
Navigate to Application-->Menu
Menu = xxmz_CUSTOM_MENU
User Menu Name = xxmz Custom Application
Menu Type =
Description = xxmz Custom Application Menu
Seq = 100
Prompt = View Requests
Submenu =
Function = View All Concurrent Requests
Description = View Requests
Seq = 110
Prompt = Run Requests
Submenu =
Function = Requests: Submit
Description = Submit Requests
Menu = xxmz_CUSTOM_MENU_SSWA
User Menu Name = xxmz Custom Application SSWA
Menu Type =
Description = xxmz Custom Application Menu for SSWA
10) Create new responsibility. One for Core Applications and One for Self Service (SSWA)
Navigate to Security-->Responsibility-->Define
Responsibility Name = xxmz Custom
Application = xxmz Custom
Responsibility Key = xxmzCUSTOM
Description = xxmz Custom Responsibility
Available From = Oracle Applications
Data Group Name = xxmzGroup
Data Group Application = xxmz Custom
Menu = xxmz Custom Application
Request Group Name = xxmz Request Group
Responsibility Name = xxmz Custom SSWA
Application = xxmz Custom
Responsibility Key = xxmzCUSTOMSSWA
Description = xxmz Custom Responsibility SSWA
Available From = Oracle Self Service Web Applications
Data Group Name = xxmzGroup
Data Group Application = xxmz Custom
Menu = xxmz Custom Application SSWA
Request Group Name = xxmz Request Group
11) Add responsibility to user
Navigate to Security-->User-->Define
Add xxmz Custom responsibility to users as required.
12) Other considerations
You are now ready to create your database Objects, custom Reports, Forms, Packages, etc
Create the source code files in the xxmz_TOP directory appropriate for the type of object. For example forms would be located in $xxmz_TOP/forms/US or package source code in $xxmz_TOP/admin/sql for example.
Database Objects, such as tables, indexes and sequences should be created in the xxmz schema, then you need to
a) Grant all privilege from each custom data object to the APPS schema.
For example : logged in as xxmz user
grant all privileges on myTable to apps;
b) Create a synonym in APPS for each custom data object
For example : logged in as APPS user
create synonym myTable for xxmz.myTable;
Other database objects, such as views and packages should be created directly in the APPS schema.
How to Change and Verify CLASSPATH Settings for the Concurrent Manager
How to Change and Verify CLASSPATH Settings for the Concurrent Manager [ID 178766.1]
Modified 07-FEB-2011 Type HOWTO Status PUBLISHED
In this Document
Goal
Solution
Applies to:
Oracle Marketing
Information in this document applies to any platform.
Goal
This document is describing how to change the CLASSPATH variable so that Concurrent Requests will use it properly and also how to verify what is the value of CLASSPATH for a particular concurrent request.
Solution
1. Description of the CLASSPATH environment variable and the ways it can be used.
The CLASSPATH, being an environment variable, will differ depending on the environment, meaning the runtime environment of a particular process.
For example, if the CLASSPATH was set directly in a UNIX shell, then that would be the CLASSPATH echo'ed back within that shell and within any shell forked from that shell.
However, if CLASSPATH is set in a shell script file, then only processes running from within the context of that script will have that CLASSPATH.
In the Oracle Apps, there are a number of different runtime contexts.
One is the Apache - JServ - JSP engine which has it's CLASSPATH set in a file (usually jservctl, sometimes jserv.properties)
Another context is the Concurrent Manager where all Concurrent Processes are run. There is a separate script for running these, being as they are "concurrent" to the HTML stack. The script that starts up the Concurrent Manager is either adovars.env or some other file that calls adovars.env.
The adovars.env file has a separate setting of the CLASSPATH, since there may be different runtime requirements for Java classes for Concurrent Programs than for JSP pages.
The basic point is that the CLASSPATH is only valid within the runtime context for which it is set. Running the command "echo $CLASSPATH" only serves to tell you what the CLASSPATH is within the context from which you run the command.
2. Setting the CLASSPATH variable in the context of Concurrent Manager.
There are many places a CLASSPATH can be set. For Concurrent Programs, the important thing is that the file called adovars.env has the proper JDBC driver included in it's CLASSPATH.
For example: when using jdk1.1.8, this should be jdbc 8.0.6, for jdk1.2.2 or greater, it should be jdbc 8.1.6.2 or greater.
Since the Concurrent Manager uses adovars.env when running concurrent requests, this is the place where the CLASSPATH (and other environment variables) should be set correctly.
In case the CLASSPATH is not set correctly, the concurrent requests will end up with the following error: java.lang.NoClassDefFoundError.
It is crucially important that the entire Concurrent Manager be shutdown and restarted after changes were made to file adovars.env.
3. Verifying the value of CLASSPATH variable for a specific request.
To verify that the CLASSPATH change was successful, please follow the next steps:
1. Start a new concurrent request
2. Note the request id
3. Run the following query using the request id
select variable_name,
value
from fnd_env_context e,
fnd_concurrent_processes p,
fnd_concurrent_requests r
where p.concurrent_process_id = e.concurrent_process_id
and p.concurrent_process_id = r.controlling_manager
and e.variable_name='CLASSPATH'
and r.request_id = &REQUEST_ID
This will return the CLASSPATH being used by the concurrent request.
Modified 07-FEB-2011 Type HOWTO Status PUBLISHED
In this Document
Goal
Solution
Applies to:
Oracle Marketing
Information in this document applies to any platform.
Goal
This document is describing how to change the CLASSPATH variable so that Concurrent Requests will use it properly and also how to verify what is the value of CLASSPATH for a particular concurrent request.
Solution
1. Description of the CLASSPATH environment variable and the ways it can be used.
The CLASSPATH, being an environment variable, will differ depending on the environment, meaning the runtime environment of a particular process.
For example, if the CLASSPATH was set directly in a UNIX shell, then that would be the CLASSPATH echo'ed back within that shell and within any shell forked from that shell.
However, if CLASSPATH is set in a shell script file, then only processes running from within the context of that script will have that CLASSPATH.
In the Oracle Apps, there are a number of different runtime contexts.
One is the Apache - JServ - JSP engine which has it's CLASSPATH set in a file (usually jservctl, sometimes jserv.properties)
Another context is the Concurrent Manager where all Concurrent Processes are run. There is a separate script for running these, being as they are "concurrent" to the HTML stack. The script that starts up the Concurrent Manager is either adovars.env or some other file that calls adovars.env.
The adovars.env file has a separate setting of the CLASSPATH, since there may be different runtime requirements for Java classes for Concurrent Programs than for JSP pages.
The basic point is that the CLASSPATH is only valid within the runtime context for which it is set. Running the command "echo $CLASSPATH" only serves to tell you what the CLASSPATH is within the context from which you run the command.
2. Setting the CLASSPATH variable in the context of Concurrent Manager.
There are many places a CLASSPATH can be set. For Concurrent Programs, the important thing is that the file called adovars.env has the proper JDBC driver included in it's CLASSPATH.
For example: when using jdk1.1.8, this should be jdbc 8.0.6, for jdk1.2.2 or greater, it should be jdbc 8.1.6.2 or greater.
Since the Concurrent Manager uses adovars.env when running concurrent requests, this is the place where the CLASSPATH (and other environment variables) should be set correctly.
In case the CLASSPATH is not set correctly, the concurrent requests will end up with the following error: java.lang.NoClassDefFoundError.
It is crucially important that the entire Concurrent Manager be shutdown and restarted after changes were made to file adovars.env.
3. Verifying the value of CLASSPATH variable for a specific request.
To verify that the CLASSPATH change was successful, please follow the next steps:
1. Start a new concurrent request
2. Note the request id
3. Run the following query using the request id
select variable_name,
value
from fnd_env_context e,
fnd_concurrent_processes p,
fnd_concurrent_requests r
where p.concurrent_process_id = e.concurrent_process_id
and p.concurrent_process_id = r.controlling_manager
and e.variable_name='CLASSPATH'
and r.request_id = &REQUEST_ID
This will return the CLASSPATH being used by the concurrent request.
Wednesday, June 8, 2011
APP-FND-00362 error occurs
When running the 'Invoice on Hold Report' (shortname APXINROH), an APP-FND-00362 error occurs [ID 1127863.1]
Modified 13-DEC-2010 Type PROBLEM Status PUBLISHED
In this Document
Symptoms
Cause
Solution
Applies to:
Oracle Payables - Version: 11.5.0 to 12.1.2 - Release: 11.5.0 to 12.1
Information in this document applies to any platform.
Symptoms
When one runs the 'Invoice on Hold Report' (short name APXINROH), the following error occurs:
Error message
APP-FND-00362 Routine afpbep cannot execute request &REQUEST for program &PROGRAM, because the environment variable &BASEPATH is not set for the application to which the concurrent program executable &EXECUTABLE belongs.
Cause
The issue is caused by a custom executable name for the Invoice on Hold report: XXX_APXINROH
Solution
(R) : System Administrator
(N) : Concurrent > Program > Define
Search for short name : APXINROH
1 - Change the Executable Name from XXX_APXINROH to APXINROH
2 - Re-run the report and confirm the error is resolved.
Modified 13-DEC-2010 Type PROBLEM Status PUBLISHED
In this Document
Symptoms
Cause
Solution
Applies to:
Oracle Payables - Version: 11.5.0 to 12.1.2 - Release: 11.5.0 to 12.1
Information in this document applies to any platform.
Symptoms
When one runs the 'Invoice on Hold Report' (short name APXINROH), the following error occurs:
Error message
APP-FND-00362 Routine afpbep cannot execute request &REQUEST for program &PROGRAM, because the environment variable &BASEPATH is not set for the application to which the concurrent program executable &EXECUTABLE belongs.
Cause
The issue is caused by a custom executable name for the Invoice on Hold report: XXX_APXINROH
Solution
(R) : System Administrator
(N) : Concurrent > Program > Define
Search for short name : APXINROH
1 - Change the Executable Name from XXX_APXINROH to APXINROH
2 - Re-run the report and confirm the error is resolved.
Monday, June 6, 2011
How To Implement Row Level Security in EPM 11.1.1.2.0
How To Implement Row Level Security in EPM 11.1.1.2.0 [ID 970369.1]
Modified 01-APR-2011 Type HOWTO Status PUBLISHED
In this Document
Goal
Solution
Applies to:
Hyperion BI+ - Version: 11.1.1.2.00 and later [Release: 11.1 and later ]
Information in this document applies to any platform.
Goal
Implement Row Level Security in EPM Interactive Reporting 11.1.1.2.
Solution
A) Set background resources for Row Level Security (RLS)
1. Create a database to hold the RLS tables,
2. Create an ODBC connection to the RLS DataBase using appropriate Merant Wire Protocol for your RDBMS.
3. Create an OCE file with ODBC/ODBC connection types and publish it to the workspace, call it RLS.
4. Open Row_Level_Security.BQY (i.e, for system 9 it’s located in %Hyperion_Home%\BIPlus\docs\en; not bundled with EPM 11.1.1.x) and select the RLS.OCE file created in the previous step and connect to RLS database.
5. If this is the first time to establish a connection to the RLS database you will be asked to create these tables first, click yes.
6. Enter the username and password then on Create, now you should have three tables created in your database:
7. Define the OCE connection in DAS using Local Services Configurator, and then restart all the services.
8. Configure RLS in workspace, Navigate > Administer > Row Level Security, check Enable Row Level Security and enter your details of RLS OCE.
9. Restart all the services to ensure changes take effect
B) Define Users and Groups for RLS
1. Click on Work with Users\Groups button and Create a group called it AMERICAS
2. Create a user called "process" and add it as a member in AMERICAS.
3. Create a user called "process" and in shared services (it’s very important to spell it identically to the user in the RLS tables with the same letter case otherwise RLS will not work).
C) Build your report and publish it to the workspace, edit the permission for this report and grant “Full Access” and “View and Process” permissions for user called “process”.
D) Define Restrictions
1. We need to hide the column called “STORE_KEY” in “SALES_FACT” table to prevent the employess from tying back the sales figures with the stores. We can hide the column by adding a row in BRIOSECR to restrict access for “PUBLIC” group as below:
2. Then override this restriction for “AMERICAS” group by adding a second restriction to the BRIOSECR as below:
3. Now, I f we run the report using “admin” which is not a member of “AMERICAS” group we will not be able to see “STORE_KEY”.
4. If we open the same report using “process” user we will be able to see the values in STORE_KEY
5. Now, we will add another constraint to restrict access of AMERICAS group to Sales amount to the store named ‘BMV Lyon’ and to hide other rows of data. This condition will be applied as an inner join constraint.
6. Run the report again, you get only sales amount of ‘BMV Lyon’ store.
For more information, please refer to IR_user.pdf. This contains the official documentation for Row Level Security. Check Chapter 22 "Row Level Security in Interactive Reporting" page 505.
Modified 01-APR-2011 Type HOWTO Status PUBLISHED
In this Document
Goal
Solution
Applies to:
Hyperion BI+ - Version: 11.1.1.2.00 and later [Release: 11.1 and later ]
Information in this document applies to any platform.
Goal
Implement Row Level Security in EPM Interactive Reporting 11.1.1.2.
Solution
A) Set background resources for Row Level Security (RLS)
1. Create a database to hold the RLS tables,
2. Create an ODBC connection to the RLS DataBase using appropriate Merant Wire Protocol for your RDBMS.
3. Create an OCE file with ODBC/ODBC connection types and publish it to the workspace, call it RLS.
4. Open Row_Level_Security.BQY (i.e, for system 9 it’s located in %Hyperion_Home%\BIPlus\docs\en; not bundled with EPM 11.1.1.x) and select the RLS.OCE file created in the previous step and connect to RLS database.
5. If this is the first time to establish a connection to the RLS database you will be asked to create these tables first, click yes.
6. Enter the username and password then on Create, now you should have three tables created in your database:
7. Define the OCE connection in DAS using Local Services Configurator, and then restart all the services.
8. Configure RLS in workspace, Navigate > Administer > Row Level Security, check Enable Row Level Security and enter your details of RLS OCE.
9. Restart all the services to ensure changes take effect
B) Define Users and Groups for RLS
1. Click on Work with Users\Groups button and Create a group called it AMERICAS
2. Create a user called "process" and add it as a member in AMERICAS.
3. Create a user called "process" and in shared services (it’s very important to spell it identically to the user in the RLS tables with the same letter case otherwise RLS will not work).
C) Build your report and publish it to the workspace, edit the permission for this report and grant “Full Access” and “View and Process” permissions for user called “process”.
D) Define Restrictions
1. We need to hide the column called “STORE_KEY” in “SALES_FACT” table to prevent the employess from tying back the sales figures with the stores. We can hide the column by adding a row in BRIOSECR to restrict access for “PUBLIC” group as below:
2. Then override this restriction for “AMERICAS” group by adding a second restriction to the BRIOSECR as below:
3. Now, I f we run the report using “admin” which is not a member of “AMERICAS” group we will not be able to see “STORE_KEY”.
4. If we open the same report using “process” user we will be able to see the values in STORE_KEY
5. Now, we will add another constraint to restrict access of AMERICAS group to Sales amount to the store named ‘BMV Lyon’ and to hide other rows of data. This condition will be applied as an inner join constraint.
6. Run the report again, you get only sales amount of ‘BMV Lyon’ store.
For more information, please refer to IR_user.pdf. This contains the official documentation for Row Level Security. Check Chapter 22 "Row Level Security in Interactive Reporting" page 505.
Is Hyperion 11.1.1.2 Supported On Windows Server 2008
Is Hyperion 11.1.1.2 Supported On Windows Server 2008 [ID 860132.1]
Modified 26-FEB-2010 Type HOWTO Status PUBLISHED
In this Document
Goal
Solution
Applies to:
Hyperion BI+ - Version: 11.1.1.2.00 - Release: 11.1
Information in this document applies to any platform.
Goal
To obtain information on if Hyperion 11.1.1.2 will be supported On Windows Server 2008?
Solution
Oracle Hyperion Enterprise Management System release 11.1.1.2 does NOT support Microsoft Windows Server 2008 OS family.
However, this server OS is planned to be supported in future releases of the software. Please check the readme prior to doing any installation.
Windows Server 2008 support (IE8, MSSQL and Windows) is in the next release (Tallyrand 11.1.2), scheduled for release in April (this is subject to change and why there is no official documentation yet.)
Server 2008 support for prior versions will be covered by a future patch release (possibly 11.1.1.4), but not before 11.1.2 is released. After 11.1.2, there will be a 11.1.2 SP1 that will allow upgrades from 11.1.1.x versions.
At roughly the same time, there will be a patch for version 9.3.1. However, a patch for 11.1.1.3 has not yet been scheduled.
Modified 26-FEB-2010 Type HOWTO Status PUBLISHED
In this Document
Goal
Solution
Applies to:
Hyperion BI+ - Version: 11.1.1.2.00 - Release: 11.1
Information in this document applies to any platform.
Goal
To obtain information on if Hyperion 11.1.1.2 will be supported On Windows Server 2008?
Solution
Oracle Hyperion Enterprise Management System release 11.1.1.2 does NOT support Microsoft Windows Server 2008 OS family.
However, this server OS is planned to be supported in future releases of the software. Please check the readme prior to doing any installation.
Windows Server 2008 support (IE8, MSSQL and Windows) is in the next release (Tallyrand 11.1.2), scheduled for release in April (this is subject to change and why there is no official documentation yet.)
Server 2008 support for prior versions will be covered by a future patch release (possibly 11.1.1.4), but not before 11.1.2 is released. After 11.1.2, there will be a 11.1.2 SP1 that will allow upgrades from 11.1.1.x versions.
At roughly the same time, there will be a patch for version 9.3.1. However, a patch for 11.1.1.3 has not yet been scheduled.
EPM Uninstall Tool Hangs During The Initialization Step When Trying To Uninstall Essbase
EPM Uninstall Tool Hangs During The Initialization Step When Trying To Uninstall Essbase [ID 1074723.1]
Modified 12-JAN-2011 Type PROBLEM Status PUBLISHED
In this Document
Symptoms
Cause
Solution
References
Applies to:
Hyperion Essbase - Version: 11.1.1.2.00 to 11.1.1.2.00 - Release: 11.1 to 11.1
Information in this document applies to any platform.
Symptoms
When trying to uninstall Essbase, the uninstall tool hangs during the initializing step.
The following entry is found in the central-installer-uninstall.log file:
Uninstall, com.installshield.product.iterators.MultiProductTreeIterator, err, ProductException: (error code = 200; message="Java error"; exception = [ServiceException: (error code = 315; message = "Wizard home does not exist: D:\temp\ismp001\3087269\data\tools\9.5.0.0\assembly.dat"; severity = 0)])
STACK_TRACE: 16
ProductException: (error code = 200; message="Java error"; exception = [ServiceException: (error code = 315; message = "Wizard home does not exist: D:\temp\ismp001\3087269\data\tools\9.5.0.0\assembly.dat"; severity = 0)])
at com.installshield.product.iterators.MultiProductTreeIterator.updateIterator(Unknown Source)
at com.installshield.product.iterators.MultiProductTreeIterator.dereferenceNext(Unknown Source)
at com.installshield.product.iterators.MultiProductTreeIterator.getNext(Unknown Source)
Cause
This is a known issue in the EPM 11.1.1.2 as mentioned in the "epm_11112_readme.pdf".
Go to ---> Known Issues --> Uninstalling --> See this Paragraph:
"If you experience problems after uninstalling and then reinstalling products, install them in a new Hyperion home directory on the machine. For more information, see "Cannot Install after an Uninstall" in the Oracle Hyperion Enterprise Performance Management System Installation and Configuration Troubleshooting Guide."
Solution
To clean up your machine, try these steps:
1. Stop all the Hyperion Services.
2. Uninstall using the "Windows Add and Remove Programs" option.
3. Delete all "hyperion" environment variables, including HYPERION_HOME.
4. Delete the Hyperion entries from registry.
5. Delete the .oracle.products and set_hyphome_1.bat files in the "C:\Documents and Settings\install_user\" folder.
6. Rename the folder "Program Files\Common Files\InstallShield\Universal\common" to "Program Files\Common Files\InstallShield\Universal\common_hyperion".
7. Restart the system.
Modified 12-JAN-2011 Type PROBLEM Status PUBLISHED
In this Document
Symptoms
Cause
Solution
References
Applies to:
Hyperion Essbase - Version: 11.1.1.2.00 to 11.1.1.2.00 - Release: 11.1 to 11.1
Information in this document applies to any platform.
Symptoms
When trying to uninstall Essbase, the uninstall tool hangs during the initializing step.
The following entry is found in the central-installer-uninstall.log file:
Uninstall, com.installshield.product.iterators.MultiProductTreeIterator, err, ProductException: (error code = 200; message="Java error"; exception = [ServiceException: (error code = 315; message = "Wizard home does not exist: D:\temp\ismp001\3087269\data\tools\9.5.0.0\assembly.dat"; severity = 0)])
STACK_TRACE: 16
ProductException: (error code = 200; message="Java error"; exception = [ServiceException: (error code = 315; message = "Wizard home does not exist: D:\temp\ismp001\3087269\data\tools\9.5.0.0\assembly.dat"; severity = 0)])
at com.installshield.product.iterators.MultiProductTreeIterator.updateIterator(Unknown Source)
at com.installshield.product.iterators.MultiProductTreeIterator.dereferenceNext(Unknown Source)
at com.installshield.product.iterators.MultiProductTreeIterator.getNext(Unknown Source)
Cause
This is a known issue in the EPM 11.1.1.2 as mentioned in the "epm_11112_readme.pdf".
Go to ---> Known Issues --> Uninstalling --> See this Paragraph:
"If you experience problems after uninstalling and then reinstalling products, install them in a new Hyperion home directory on the machine. For more information, see "Cannot Install after an Uninstall" in the Oracle Hyperion Enterprise Performance Management System Installation and Configuration Troubleshooting Guide."
Solution
To clean up your machine, try these steps:
1. Stop all the Hyperion Services.
2. Uninstall using the "Windows Add and Remove Programs" option.
3. Delete all "hyperion" environment variables, including HYPERION_HOME.
4. Delete the Hyperion entries from registry.
5. Delete the .oracle.products and set_hyphome_1.bat files in the "C:\Documents and Settings\install_user\" folder.
6. Rename the folder "Program Files\Common Files\InstallShield\Universal\common" to "Program Files\Common Files\InstallShield\Universal\common_hyperion".
7. Restart the system.
When Will Hyperion EPM Support Windows 7 and Internet Explorer 8
When Will Hyperion EPM Support Windows 7 and Internet Explorer 8 (IE 8)? [ID 974937.1]
Modified 28-APR-2011 Type HOWTO Status PUBLISHED
In this Document
Goal
Solution
References
Applies to:
Hyperion Planning - Version: 4.1.0.0.00 to 11.1.1.3.00 - Release: 4.1 to 11.1
Hyperion BI+ - Version: 9.3.1.0.00 to 11.1.1.3.00 [Release: 9.3 to 11.1]
Hyperion BI+ - Version: 9.0.0.0.00 to 11.1.1.3.00 [Release: 9.0 to 11.1]
Hyperion BI+ - Version: 9.0.0.0.00 to 11.1.1.3.00 [Release: 9.0 to 11.1]
Hyperion Essbase Administration Services - Version: 9.0.0.0.00 to 11.1.1.3.00 [Release: 9.0 to 11.1]
Information in this document applies to any platform.
This knowledge document is a replacement for 975567.1, 947715.1, 860642.1 which have been deleted.
Goal
When will the Hyperion EPM System support Microsoft Windows 7 and Internet Explorer 8?
Solution
Standard Disclaimer:
THE FOLLOWING INFORMATION IS INTENDED TO OUTLINE OUR GENERAL PRODUCT DIRECTION. IT IS INTENDED FOR INFORMATION PURPOSES ONLY, AND MAY NOT BE INCORPORATED INTO ANY CONTRACT. IT IS NOT A COMMITMENT TO DELIVER ANY MATERIAL, CODE, OR FUNCTIONALITY, AND SHOULD NOT BE RELIED UPON IN MAKING PURCHASING DECISIONS. THE DEVELOPMENT, RELEASE, AND TIMING OF ANY FEATURES OR FUNCTIONALITY DESCRIBED FOR ORACLE PRODUCTS REMAINS AT THE SOLE DISCRETION OF ORACLE.
Oracle/Hyperion has already released: EPM 11.1.2, new install only. Hyperion System 9.3.3 patchset (number 9900557 on MyOracleSupport).
Oracle/Hyperion plans support for these platform components with the following release:
A 11.1.1.3 patchset (without additional patchset Internet Explorer 8 is certified).
Existing customers on releases 9.3.1 and 11.1.1.3 may apply the specified patch set. No major upgrade is required. There are no plans to support these platform components in 11.1.1.2.0 or earlier in the EPM series.
In August the Supported Platforms Matrix for the 11.1.1.3 release was updated with the following:
Internet Explorer 8 is supported only for: Shared Services, Performance Management Architect, Calculation Manager, Planning, Financial Management, EPM Workspace patch 9314073 , Financial Reporting (with patch 9657652), Interactive Reporting, Web Analysis, FDM.
You may also navagate to the Supported Platforms Matrix on the OTN where you can check for the most current certification information.
http://www.oracle.com/technetwork/middleware/bi-foundation/hyperion-supported-platforms-085957.html
References
PATCH:9900557 - Hyperion Reporting and Analysis System 9 Release 9.3.3.0.0
Modified 28-APR-2011 Type HOWTO Status PUBLISHED
In this Document
Goal
Solution
References
Applies to:
Hyperion Planning - Version: 4.1.0.0.00 to 11.1.1.3.00 - Release: 4.1 to 11.1
Hyperion BI+ - Version: 9.3.1.0.00 to 11.1.1.3.00 [Release: 9.3 to 11.1]
Hyperion BI+ - Version: 9.0.0.0.00 to 11.1.1.3.00 [Release: 9.0 to 11.1]
Hyperion BI+ - Version: 9.0.0.0.00 to 11.1.1.3.00 [Release: 9.0 to 11.1]
Hyperion Essbase Administration Services - Version: 9.0.0.0.00 to 11.1.1.3.00 [Release: 9.0 to 11.1]
Information in this document applies to any platform.
This knowledge document is a replacement for 975567.1, 947715.1, 860642.1 which have been deleted.
Goal
When will the Hyperion EPM System support Microsoft Windows 7 and Internet Explorer 8?
Solution
Standard Disclaimer:
THE FOLLOWING INFORMATION IS INTENDED TO OUTLINE OUR GENERAL PRODUCT DIRECTION. IT IS INTENDED FOR INFORMATION PURPOSES ONLY, AND MAY NOT BE INCORPORATED INTO ANY CONTRACT. IT IS NOT A COMMITMENT TO DELIVER ANY MATERIAL, CODE, OR FUNCTIONALITY, AND SHOULD NOT BE RELIED UPON IN MAKING PURCHASING DECISIONS. THE DEVELOPMENT, RELEASE, AND TIMING OF ANY FEATURES OR FUNCTIONALITY DESCRIBED FOR ORACLE PRODUCTS REMAINS AT THE SOLE DISCRETION OF ORACLE.
Oracle/Hyperion has already released: EPM 11.1.2, new install only. Hyperion System 9.3.3 patchset (number 9900557 on MyOracleSupport).
Oracle/Hyperion plans support for these platform components with the following release:
A 11.1.1.3 patchset (without additional patchset Internet Explorer 8 is certified).
Existing customers on releases 9.3.1 and 11.1.1.3 may apply the specified patch set. No major upgrade is required. There are no plans to support these platform components in 11.1.1.2.0 or earlier in the EPM series.
In August the Supported Platforms Matrix for the 11.1.1.3 release was updated with the following:
Internet Explorer 8 is supported only for: Shared Services, Performance Management Architect, Calculation Manager, Planning, Financial Management, EPM Workspace patch 9314073 , Financial Reporting (with patch 9657652), Interactive Reporting, Web Analysis, FDM.
You may also navagate to the Supported Platforms Matrix on the OTN where you can check for the most current certification information.
http://www.oracle.com/technetwork/middleware/bi-foundation/hyperion-supported-platforms-085957.html
References
PATCH:9900557 - Hyperion Reporting and Analysis System 9 Release 9.3.3.0.0
Unable to Login to Financial Reporting (FR) Studio After Upgrading to 11.1.2.1, Error: "You are not authorized"
Unable to Login to Financial Reporting (FR) Studio After Upgrading to 11.1.2.1, Error: "You are not authorized" [ID 1321851.1]
Modified 27-MAY-2011 Type PROBLEM Status PUBLISHED
In this Document
Symptoms
Cause
Solution
Applies to:
Hyperion BI+ - Version: 11.1.2.1.000 and later [Release: 11.1 and later ]
Information in this document applies to any platform.
Symptoms
You are trying to login to Financial Reporting Studio 11.1.2.1 and get the following error:
"You are not authorized to use this functionality. Contact your administrator."
Cause
While installing 11.1.2.1, did not run the standalone.exe for Financial Reporting Studio present in the installation pack. FR Studio needs to be upgraded to the same version as the server(s).
Solution
1. Uninstall FR studio 11.1.2 through EPM uninstaller.
2. Update the FR studio, by running the standalone exe file present in the installation pack.
Modified 27-MAY-2011 Type PROBLEM Status PUBLISHED
In this Document
Symptoms
Cause
Solution
Applies to:
Hyperion BI+ - Version: 11.1.2.1.000 and later [Release: 11.1 and later ]
Information in this document applies to any platform.
Symptoms
You are trying to login to Financial Reporting Studio 11.1.2.1 and get the following error:
"You are not authorized to use this functionality. Contact your administrator."
Cause
While installing 11.1.2.1, did not run the standalone.exe for Financial Reporting Studio present in the installation pack. FR Studio needs to be upgraded to the same version as the server(s).
Solution
1. Uninstall FR studio 11.1.2 through EPM uninstaller.
2. Update the FR studio, by running the standalone exe file present in the installation pack.
Oracle Epm 11.1.2 Crashed After Signing Off From Remote Server Using The Account Which Installed EPM Services
Oracle Epm 11.1.2 Crashed After Signing Off From Remote Server Using The Account Which Installed EPM Services [ID 1179893.1]
Modified 01-SEP-2010 Type PROBLEM Status PUBLISHED
In this Document
Symptoms
Cause
Solution
References
Applies to:
Hyperion BI+ - Version: 11.1.2.0.00 and later [Release: 11.1 and later ]
Information in this document applies to any platform.
Symptoms
When using Oracle EPM 11.1.2, the system crashes if you use Remote Desktop Connection to sign into the server running the Foundation/Framework/Oracle HTTP server and log off from the server. Issue happens ONLY when logging off from the server using the account which installed EPM services. There are no issues when logging off from the server using different account.
After logging off from the server, even without doing anything in the server, cannot run any jobs inside the workspace. Running the jobs will throw "Error loading ADF" warning. So if try to log off from the workspace browser and login back, cannot sign in again to the workspace and receive the error "Error 404--Not Found". No new connections will work. Have to restart all the services to make it work again.
Same issue exists for Shared Services also, giving "Error 404--Not Found" while logging.
Cause
If the user who installed EPM System products, signs into a remote session of EPM System and then logs out of the remote session, sometimes OS cleans out the temp files associated with this user. Since these temp files are in use by WebLogic, deleting them causes WebLogic to stop functioning.
Solution
Check the registry for the value of -Dweblogic.j2ee.application.tmpDir for both Workspace and SharedServices. This is in HKEY_LOCAL_MACHINE > Software > Hyperion Solutions > FoundationServices0 > Hys9FoundationServices
Once the location is found, check if the files in this directory are being deleted when you remote into the machine and then log off as an account that installed the application. If this is the case, please change the location of tmpDir.
Read the attachment TipsDocument53.pdf page 5 and following
Modified 01-SEP-2010 Type PROBLEM Status PUBLISHED
In this Document
Symptoms
Cause
Solution
References
Applies to:
Hyperion BI+ - Version: 11.1.2.0.00 and later [Release: 11.1 and later ]
Information in this document applies to any platform.
Symptoms
When using Oracle EPM 11.1.2, the system crashes if you use Remote Desktop Connection to sign into the server running the Foundation/Framework/Oracle HTTP server and log off from the server. Issue happens ONLY when logging off from the server using the account which installed EPM services. There are no issues when logging off from the server using different account.
After logging off from the server, even without doing anything in the server, cannot run any jobs inside the workspace. Running the jobs will throw "Error loading ADF" warning. So if try to log off from the workspace browser and login back, cannot sign in again to the workspace and receive the error "Error 404--Not Found". No new connections will work. Have to restart all the services to make it work again.
Same issue exists for Shared Services also, giving "Error 404--Not Found" while logging.
Cause
If the user who installed EPM System products, signs into a remote session of EPM System and then logs out of the remote session, sometimes OS cleans out the temp files associated with this user. Since these temp files are in use by WebLogic, deleting them causes WebLogic to stop functioning.
Solution
Check the registry for the value of -Dweblogic.j2ee.application.tmpDir for both Workspace and SharedServices. This is in HKEY_LOCAL_MACHINE > Software > Hyperion Solutions > FoundationServices0 > Hys9FoundationServices
Once the location is found, check if the files in this directory are being deleted when you remote into the machine and then log off as an account that installed the application. If this is the case, please change the location of tmpDir.
Read the attachment TipsDocument53.pdf page 5 and following
Preparing a Microsoft Windows Server for Installation of EPM 11.1.2.x
Preparing a Microsoft Windows Server for Installation of EPM 11.1.2.x [ID 1303078.1]
Modified 20-APR-2011 Type HOWTO Status PUBLISHED
In this Document
Goal
Solution
References
Applies to:
Hyperion Essbase - Version: 11.1.2.1.000 to 11.1.2.1.000 - Release: 11.1 to 11.1
Hyperion BI+ - Version: 11.1.2.0.00 to 11.1.2.1.000 [Release: 11.1 to 11.1]
Hyperion Planning - Version: 11.1.2.0.00 to 11.1.2.1.000 [Release: 11.1 to 11.1]
Microsoft Windows x64 (64-bit) - Version: 2008 R2
The compression/decompression utility should be capable of handling long file paths (a free utility which fulfills this requirement may be downloaded from http://www.7-zip.org)
Database clients (in a preferred 64-bit environment) should be installed in the order of 32-bit then 64-bit. Products which require 32-bit clients include Interactive Reporting and Financial Data Quality Management.
Goal
Many applications can be installed in EPM 11.1.2.0 and EPM 11.1.2.1 environments. These require careful preparation to prevent installation and configuration failures. This article makes some best practice recommendations that will allow a new installation to be robust. The EPM 11.1.2.0 release did not offer upgrade or migration features, so many customers are expected to move up to and take advantage of the new features of EPM 11.1.2.1. In most cases customers who have production environments containing earlier versions of the Hyperion System 9 or Oracle EPM 11 families will need to and want to move to higher specification environments to meet the certification requirements of the environment of this set of products.
Solution
(1) GREENFIELD/CLEAN INSTALL
It is recommended to start with a clean install. An attempt to install on top of a pre-existing Hyperion System 9.2.1, 9.3.3, or 11.1.1.3 installation would likely lead to the loss of essential data and configuration files needed for moving to 11.1.2.1 while simultaneously disabling the prior version.
(2) MICROSOFT WINDOWS VERSION
Earlier versions of Hyperion System 9 and Oracle Hyperion EPM 11.1.1.x were not certified against currently supported operating systems and databases so it is unlikely that they were installed in environments certified to work with EPM 11.1.2.1.
Since many of the applications of EPM 11.1.2.1 are 64-bit savvy and could benefit from the optimization features of Microsoft Windows 2008 R2 64-bit...that would be recommended.
(3) COMPRESSION/DECOMPRESSION
As mentioned above, ensure that your compression/decompression utility will handle long file path names (greater than the 260 character Microsoft Windows path limitation).
http://msdn.microsoft.com/en-us/library/aa365247%28VS.85%29.aspx#maxpath
(4) TURN OFF MICROSOFT'S USER ACCOUNT CONTROL
UAC (Microsoft User Account Control) is a feature of Microsoft Vista and Windows 2008.
When the hyperlink is clicked, the next window should NOT have a check box checked.
The screen layout for Microsoft Windows 2008 R2 is:
(5) ENSURE MEMORY AND CPU NUMBERS ARE ADEQUATE
If all Hyperion products that can be accessed via Oracle EPM Foundation 11.1.2.x were installed and activated it could easily require around 14 gigabytes or more of RAM. This pretty much eliminates consideration of a 32-bit install (where each machine can access at best 4 gigabytes of memory...and no less than 1 gigabyte of that would be for the operating system). The processing load for many separate Java virtual machines would also make it practical to have four or more CPUs. The memory and CPU requirements might be reduced somewhat if fewer applications or JVMs were run, but it would not be advisable to run even a test and development install with fewer than two CPUs and 8 gigabytes of RAM as there are around two dozen processes to support. Technical support is not equipped to estimate the actual production capacity of an environment...there are too many variables involved. It would be best to ramp up the system with actual processes and loads and project from that.
(6) PREPARING DATABASE CLIENTS
The following applications require the installation of a full Oracle database client on the machines where they will be installed.
Performance Management Architect Dimension server
Financial Management application server
FDM Application Server and any machine that has FDM Workbench
Strategic Finance
If an Oracle database is used, a full database client with Oracle Call Interface (Oracle 11.1.0.6 or later) must be installed. Ensure a Net Service Name/tnsnames.ora is configured for remote databases.
(7) PREPARING DATABASE REPOSITORIES
A number of different relational database repositories must be prepared if their matching applications will be configured, preferably with different schema owners. Ideally the database will be on a separate stand alone server behind a firewall.
CalcManager
DisclosureManagement
EnterprisePerformanceManagementArchitect
ERPIntegrator
Essbase
FDM
FinancialClose
FinancialManagement
PerformanceScorecard
PlanningApplication
PlanningSystem
ProfitabilityAndCostManagement
ReportingAndAnalysis
SharedServices
ORACLE DATABASE REPOSITORY:
Server versions supported include: Oracle 10.2.0.4+, 11.1.0.7+, or 11.2.0.1+
HFM, HSS, and/or EPMA instances require at least 1GB of RAM and Automatic Memory Management.
The database encoding should preferably be AL32UTF8 (UTF8 is fallback option) and NLS_NUMERIC_CHARACTERS should be in order ',.' (confirm by running: SELECT * FROM NLS_DATABASE_PARAMETERS;)
Each EPM user must have the RESOURCE role and the CREATE SESSION and
CREATE VIEW privileges.
Note that Oracle recommends a separate Oracle database instance and other specific adjustments to work with FDM.
Oracle Data Provider (ODP) for .NET 2.0 (from the Oracle Data Access Component (ODAC) package) is required and must be installed by a user with Windows administrator rights for the following products: FDM or Performance Management Architect Dimension Server.
MICROSOFT SQL SERVER DATABASE REPOSITORY
Microsoft SQL Server 2008 R2 is certified.
Run the following two commands against each database used by EPM:
alter database set READ_COMMITTED_SNAPSHOT ON
alter database set ALLOW_SNAPSHOT_ISOLATION ON
IBM DB2 DATABASE REPOSITORY
IBM DB2 9.7 FP3a+ is certified.
(8) MICROSOFT INTERNET INFORMATION SERVER
For Microsoft Windows 2008 servers, ensure that IIS 7 is installed with IIS 6 compatibility features (needed for HFM). Ensure that ASP.NET has been installed as well. In Windows 2008: Start > All Programs > Administrative Tools > Server Manager (or use icon in tool-bar) > Roles Summary > click Add Roles > ...complete verifications... > On Select Server Roles screen select Web Server (IIS) > et cetera.
(9) PREPARE A DOMAIN USER FOR INSTALL
The Microsoft Windows Services control panel should have a domain user with rights to start a service as the owner of each Oracle EPM service, so that user should be determined before installation.
(10) CONFIGURE INTERNET EXPLORER 8 (if not using Firefox)
Internet Options > Security Settings tab > Custom level...
Allow script-initiated windows without size or position constraints (Enable)
Allow websites to open windows without address or status bar (Enable)
Internet Options > Security tab > Enable Protected Mode (Uncheck)
If multiple open windows are needed: http://forums.oracle.com/forums/thread.jspa?messageID9391075
(11) INSTALL A 32-BIT GNU (7.06) or AFPL (8.5.4 or 8.51or 8.14 ) GHOSTSCRIPT OR ADOBE ACROBAT DISTILLER (6.0 or 8.0)
This is needed for Oracle Hyperion Financial Report PDF output.
Enhanced display of charts (via Adobe SVG Viewer) is only possible when using Adobe Acrobat Distiller.
(12) ENSURE THERE ARE NO SPACES IN THE INSTALL PATH
Modified 20-APR-2011 Type HOWTO Status PUBLISHED
In this Document
Goal
Solution
References
Applies to:
Hyperion Essbase - Version: 11.1.2.1.000 to 11.1.2.1.000 - Release: 11.1 to 11.1
Hyperion BI+ - Version: 11.1.2.0.00 to 11.1.2.1.000 [Release: 11.1 to 11.1]
Hyperion Planning - Version: 11.1.2.0.00 to 11.1.2.1.000 [Release: 11.1 to 11.1]
Microsoft Windows x64 (64-bit) - Version: 2008 R2
The compression/decompression utility should be capable of handling long file paths (a free utility which fulfills this requirement may be downloaded from http://www.7-zip.org)
Database clients (in a preferred 64-bit environment) should be installed in the order of 32-bit then 64-bit. Products which require 32-bit clients include Interactive Reporting and Financial Data Quality Management.
Goal
Many applications can be installed in EPM 11.1.2.0 and EPM 11.1.2.1 environments. These require careful preparation to prevent installation and configuration failures. This article makes some best practice recommendations that will allow a new installation to be robust. The EPM 11.1.2.0 release did not offer upgrade or migration features, so many customers are expected to move up to and take advantage of the new features of EPM 11.1.2.1. In most cases customers who have production environments containing earlier versions of the Hyperion System 9 or Oracle EPM 11 families will need to and want to move to higher specification environments to meet the certification requirements of the environment of this set of products.
Solution
(1) GREENFIELD/CLEAN INSTALL
It is recommended to start with a clean install. An attempt to install on top of a pre-existing Hyperion System 9.2.1, 9.3.3, or 11.1.1.3 installation would likely lead to the loss of essential data and configuration files needed for moving to 11.1.2.1 while simultaneously disabling the prior version.
(2) MICROSOFT WINDOWS VERSION
Earlier versions of Hyperion System 9 and Oracle Hyperion EPM 11.1.1.x were not certified against currently supported operating systems and databases so it is unlikely that they were installed in environments certified to work with EPM 11.1.2.1.
Since many of the applications of EPM 11.1.2.1 are 64-bit savvy and could benefit from the optimization features of Microsoft Windows 2008 R2 64-bit...that would be recommended.
(3) COMPRESSION/DECOMPRESSION
As mentioned above, ensure that your compression/decompression utility will handle long file path names (greater than the 260 character Microsoft Windows path limitation).
http://msdn.microsoft.com/en-us/library/aa365247%28VS.85%29.aspx#maxpath
(4) TURN OFF MICROSOFT'S USER ACCOUNT CONTROL
UAC (Microsoft User Account Control) is a feature of Microsoft Vista and Windows 2008.
When the hyperlink is clicked, the next window should NOT have a check box checked.
The screen layout for Microsoft Windows 2008 R2 is:
(5) ENSURE MEMORY AND CPU NUMBERS ARE ADEQUATE
If all Hyperion products that can be accessed via Oracle EPM Foundation 11.1.2.x were installed and activated it could easily require around 14 gigabytes or more of RAM. This pretty much eliminates consideration of a 32-bit install (where each machine can access at best 4 gigabytes of memory...and no less than 1 gigabyte of that would be for the operating system). The processing load for many separate Java virtual machines would also make it practical to have four or more CPUs. The memory and CPU requirements might be reduced somewhat if fewer applications or JVMs were run, but it would not be advisable to run even a test and development install with fewer than two CPUs and 8 gigabytes of RAM as there are around two dozen processes to support. Technical support is not equipped to estimate the actual production capacity of an environment...there are too many variables involved. It would be best to ramp up the system with actual processes and loads and project from that.
(6) PREPARING DATABASE CLIENTS
The following applications require the installation of a full Oracle database client on the machines where they will be installed.
Performance Management Architect Dimension server
Financial Management application server
FDM Application Server and any machine that has FDM Workbench
Strategic Finance
If an Oracle database is used, a full database client with Oracle Call Interface (Oracle 11.1.0.6 or later) must be installed. Ensure a Net Service Name/tnsnames.ora is configured for remote databases.
(7) PREPARING DATABASE REPOSITORIES
A number of different relational database repositories must be prepared if their matching applications will be configured, preferably with different schema owners. Ideally the database will be on a separate stand alone server behind a firewall.
CalcManager
DisclosureManagement
EnterprisePerformanceManagementArchitect
ERPIntegrator
Essbase
FDM
FinancialClose
FinancialManagement
PerformanceScorecard
PlanningApplication
PlanningSystem
ProfitabilityAndCostManagement
ReportingAndAnalysis
SharedServices
ORACLE DATABASE REPOSITORY:
Server versions supported include: Oracle 10.2.0.4+, 11.1.0.7+, or 11.2.0.1+
HFM, HSS, and/or EPMA instances require at least 1GB of RAM and Automatic Memory Management.
The database encoding should preferably be AL32UTF8 (UTF8 is fallback option) and NLS_NUMERIC_CHARACTERS should be in order ',.' (confirm by running: SELECT * FROM NLS_DATABASE_PARAMETERS;)
Each EPM user must have the RESOURCE role and the CREATE SESSION and
CREATE VIEW privileges.
Note that Oracle recommends a separate Oracle database instance and other specific adjustments to work with FDM.
Oracle Data Provider (ODP) for .NET 2.0 (from the Oracle Data Access Component (ODAC) package) is required and must be installed by a user with Windows administrator rights for the following products: FDM or Performance Management Architect Dimension Server.
MICROSOFT SQL SERVER DATABASE REPOSITORY
Microsoft SQL Server 2008 R2 is certified.
Run the following two commands against each database used by EPM:
alter database
alter database
IBM DB2 DATABASE REPOSITORY
IBM DB2 9.7 FP3a+ is certified.
(8) MICROSOFT INTERNET INFORMATION SERVER
For Microsoft Windows 2008 servers, ensure that IIS 7 is installed with IIS 6 compatibility features (needed for HFM). Ensure that ASP.NET has been installed as well. In Windows 2008: Start > All Programs > Administrative Tools > Server Manager (or use icon in tool-bar) > Roles Summary > click Add Roles > ...complete verifications... > On Select Server Roles screen select Web Server (IIS) > et cetera.
(9) PREPARE A DOMAIN USER FOR INSTALL
The Microsoft Windows Services control panel should have a domain user with rights to start a service as the owner of each Oracle EPM service, so that user should be determined before installation.
(10) CONFIGURE INTERNET EXPLORER 8 (if not using Firefox)
Internet Options > Security Settings tab > Custom level...
Allow script-initiated windows without size or position constraints (Enable)
Allow websites to open windows without address or status bar (Enable)
Internet Options > Security tab > Enable Protected Mode (Uncheck)
If multiple open windows are needed: http://forums.oracle.com/forums/thread.jspa?messageID9391075
(11) INSTALL A 32-BIT GNU (7.06) or AFPL (8.5.4 or 8.51or 8.14 ) GHOSTSCRIPT OR ADOBE ACROBAT DISTILLER (6.0 or 8.0)
This is needed for Oracle Hyperion Financial Report PDF output.
Enhanced display of charts (via Adobe SVG Viewer) is only possible when using Adobe Acrobat Distiller.
(12) ENSURE THERE ARE NO SPACES IN THE INSTALL PATH
Unable To Login to FDM Application 11.1.2.1 "Error: An Error occurred logging onto the system. -Unable to connect to database. Please check the databa
Unable To Login to FDM Application 11.1.2.1 "Error: An Error occurred logging onto the system. -Unable to connect to database. Please check the database information and verify database is accessible". [ID 1324896.1]
Modified 26-MAY-2011 Type PROBLEM Status PUBLISHED
In this Document
Symptoms
Cause
Solution
References
Applies to:
Hyperion Financial Data Quality Management - Version: 11.1.2.1.000 and later [Release: 11.1 and later ]
Information in this document applies to any platform.
Symptoms
When attempting to login to an Oracle FDM Application the following error is returned:
Error: An Error occurred logging onto the system. -Unable to connect to database. Please check the database information and verify database is accessible".
Cause
Currently the oracle 32 bit client is installed on the FDM application server and the 32 bit Oracle Provider for OLE DB is able to connect to the Oracle Database with "Test Connection". The issue is that the TnsNames.ora file is not currently located in the Oracle Client Home\Network\Admin directory. FDM looks to this directory in order to establish the connection with the Oracle Database, since the TNSNames.ora file is not in this location, it returns the database connection error.
does not exist and results in the error message returned.
Solution
A) Copy the TNSNames.ora file from the root of the C:\ drive on the FDM Application Server to the\Network\Admin directory on the FDM application server
B) Test the login to FDM.
Modified 26-MAY-2011 Type PROBLEM Status PUBLISHED
In this Document
Symptoms
Cause
Solution
References
Applies to:
Hyperion Financial Data Quality Management - Version: 11.1.2.1.000 and later [Release: 11.1 and later ]
Information in this document applies to any platform.
Symptoms
When attempting to login to an Oracle FDM Application the following error is returned:
Error: An Error occurred logging onto the system. -Unable to connect to database. Please check the database information and verify database is accessible".
Cause
Currently the oracle 32 bit client is installed on the FDM application server and the 32 bit Oracle Provider for OLE DB is able to connect to the Oracle Database with "Test Connection". The issue is that the TnsNames.ora file is not currently located in the Oracle Client Home\Network\Admin directory. FDM looks to this directory in order to establish the connection with the Oracle Database, since the TNSNames.ora file is not in this location, it returns the database connection error.
does not exist and results in the error message returned.
Solution
A) Copy the TNSNames.ora file from the root of the C:\ drive on the FDM Application Server to the
B) Test the login to FDM.
11.1.2.0.00 Workspace, OHS, Analytic Provider Services (APS), Shared Services (HSS) are Unavailable When User Logs Off
11.1.2.0.00 Workspace, OHS, Analytic Provider Services (APS), Shared Services (HSS) are Unavailable When User Logs Off [ID 1141553.1]
Modified 08-MAR-2011 Type PROBLEM Status PUBLISHED
In this Document
Symptoms
Changes
Cause
Solution
References
Applies to:
Hyperion Essbase - Version: 11.1.2.0.00 and later [Release: 11.1 and later ]
Microsoft Windows x64 (64-bit)
Symptoms
EPM 11.1.2 is installed in a distributed Environment.
Foundation Services are installed on Windows Server.
Working with the Shared Services Console works fine.
After after a period of time it becomes unavailable so that calling the application url /interop/ shows errors.
A Restart of FoundationServices0 WL server is necessary to get the system working again.
Changes
The User who started EPM 11.1.2 has logged out or has been logged out by system
Cause
Caused by the definition of the Services.
OHS needs the user logged on to work properly.
In some cases the existence of IPv6 on the server also causes this.
Solution
This issue has been fixed in version 11.1.2.1.
As a workaround, you can do one of the following:
a. Disable IPv6
b. Do not log out the user
c. Manually change the service owner
Modified 08-MAR-2011 Type PROBLEM Status PUBLISHED
In this Document
Symptoms
Changes
Cause
Solution
References
Applies to:
Hyperion Essbase - Version: 11.1.2.0.00 and later [Release: 11.1 and later ]
Microsoft Windows x64 (64-bit)
Symptoms
EPM 11.1.2 is installed in a distributed Environment.
Foundation Services are installed on Windows Server.
Working with the Shared Services Console works fine.
After after a period of time it becomes unavailable so that calling the application url /interop/ shows errors.
A Restart of FoundationServices0 WL server is necessary to get the system working again.
Changes
The User who started EPM 11.1.2 has logged out or has been logged out by system
Cause
Caused by the definition of the Services.
OHS needs the user logged on to work properly.
In some cases the existence of IPv6 on the server also causes this.
Solution
This issue has been fixed in version 11.1.2.1.
As a workaround, you can do one of the following:
a. Disable IPv6
b. Do not log out the user
c. Manually change the service owner
The Web Services Of HPCM 11.1.2.1 Can Not Used Normally Error"javax.xml.ws.soap.SOAPFaultException: FailedAuthentication"
The Web Services Of HPCM 11.1.2.1 Can Not Used Normally Error"javax.xml.ws.soap.SOAPFaultException: FailedAuthentication" [ID 1322913.1]
Modified 30-MAY-2011 Type PROBLEM Status PUBLISHED
In this Document
Symptoms
Cause
Solution
Applies to:
Hyperion Profitability - Version: 11.1.2.1.000 and later [Release: 11.1 and later ]
Information in this document applies to any platform.
Symptoms
On : 11.1.2.1.000 version, Deployment
When attempting to execute sample client to use HPCM Web services,
the following error occurs.
ERROR
-----------------------
javax.xml.ws.soap.SOAPFaultException: FailedAuthentication : ?????????
at oracle.j2ee.ws.client.jaxws.DispatchImpl.throwJAXWSSoapFaultException(DispatchImpl.java:1012)
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run the required to configure to execute hpm_ws_client.bat
2. From command prompt execute hpm_ws_client.bat getApplications
Cause
The issue is caused by the following setup: Incorrect authentication details in Security Realms > myrealm > Users and Groups > admin
Incorrect password for admin user in weblogic for shared services.
Solution
Take the following steps to resolve this issue:
1. Log into Weblogic server console.
http://weblogicserver:7001/console
2. Click on "Security Realms" link under the domain structure tree.
3. Click on "myrealm".
4. Click on the tab "Users and Groups".
5. Make sure admin user have all the available groups under Chosen area.
6. Make sure admin user password is same as shared service admin password and try again
Modified 30-MAY-2011 Type PROBLEM Status PUBLISHED
In this Document
Symptoms
Cause
Solution
Applies to:
Hyperion Profitability - Version: 11.1.2.1.000 and later [Release: 11.1 and later ]
Information in this document applies to any platform.
Symptoms
On : 11.1.2.1.000 version, Deployment
When attempting to execute sample client to use HPCM Web services,
the following error occurs.
ERROR
-----------------------
javax.xml.ws.soap.SOAPFaultException: FailedAuthentication : ?????????
at oracle.j2ee.ws.client.jaxws.DispatchImpl.throwJAXWSSoapFaultException(DispatchImpl.java:1012)
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run the required to configure to execute hpm_ws_client.bat
2. From command prompt execute hpm_ws_client.bat getApplications
Cause
The issue is caused by the following setup: Incorrect authentication details in Security Realms > myrealm > Users and Groups > admin
Incorrect password for admin user in weblogic for shared services.
Solution
Take the following steps to resolve this issue:
1. Log into Weblogic server console.
http://weblogicserver:7001/console
2. Click on "Security Realms" link under the domain structure tree.
3. Click on "myrealm".
4. Click on the tab "Users and Groups".
5. Make sure admin user have all the available groups under Chosen area.
6. Make sure admin user password is same as shared service admin password and try again
Apply Maintenance Release ' is Greyed out for 11.1.2.1 Disclosure Management Upgrade
'Apply Maintenance Release ' is Greyed out for 11.1.2.1 Disclosure Management Upgrade [ID 1314164.1]
Modified 20-APR-2011 Type PROBLEM Status PUBLISHED
In this Document
Symptoms
Changes
Cause
Solution
Applies to:
Hyperion Disclosure Management - Version: 11.1.2.1.000 and later [Release: 11.1 and later ]
Hyperion Financial Close Management - Version: 11.1.2.1.000 and later [Release: 11.1 and later]
Information in this document applies to any platform.
Symptoms
After launching the installtool.bat file with the intent of upgrading a base 11.1.2.0 release, the install GUI shows 'Apply Maintenance Release' as grayed out and is unelectable.
Changes
An upgrade to the 11.1.2.0 environment.
Cause
The.oracle.instance.products file was missing from the %MIDDLEWARE_HOME\user_projects\\config\foundation\11.1.2.0 directory.
Solution
A reinstall of the 11.1.2.0 environment will recreate the file.
However if a backup of the file system is available
a. simply copy the file into place.
b. If a identical Dev/Test environment is available, it can be copied from there as well.
c. Once completed, restart the InstallTool and the option should be available.
Modified 20-APR-2011 Type PROBLEM Status PUBLISHED
In this Document
Symptoms
Changes
Cause
Solution
Applies to:
Hyperion Disclosure Management - Version: 11.1.2.1.000 and later [Release: 11.1 and later ]
Hyperion Financial Close Management - Version: 11.1.2.1.000 and later [Release: 11.1 and later]
Information in this document applies to any platform.
Symptoms
After launching the installtool.bat file with the intent of upgrading a base 11.1.2.0 release, the install GUI shows 'Apply Maintenance Release' as grayed out and is unelectable.
Changes
An upgrade to the 11.1.2.0 environment.
Cause
The.oracle.instance.products file was missing from the %MIDDLEWARE_HOME\user_projects\
Solution
A reinstall of the 11.1.2.0 environment will recreate the file.
However if a backup of the file system is available
a. simply copy the file into place.
b. If a identical Dev/Test environment is available, it can be copied from there as well.
c. Once completed, restart the InstallTool and the option should be available.
How to Redirect the Output from a .cmd or .bat Script
How to Redirect the Output from a .cmd or .bat Script [ID 1315249.1]
Modified 29-APR-2011 Type HOWTO Status PUBLISHED
In this Document
Goal
Solution
References
Applies to:
Hyperion Essbase - Version: 11.1.2.1.000 and later [Release: 11.1 and later ]
Generic Windows
Goal
When running a .cmd or .bat script, is it possible to redirect the output that is written in the window? The window opens then closes immediately so any error that may occur cannot be determined.
Solution
When running a .cmd or .bat script, i.e. installTool.cmd, to capture what would be written to the window, you can try using the following command, replacing filename with a name of your choosing:
installTool.cmd -s -d >> filename
For example:
installTool.cmd -s -d >> C:\install.log
Modified 29-APR-2011 Type HOWTO Status PUBLISHED
In this Document
Goal
Solution
References
Applies to:
Hyperion Essbase - Version: 11.1.2.1.000 and later [Release: 11.1 and later ]
Generic Windows
Goal
When running a .cmd or .bat script, is it possible to redirect the output that is written in the window? The window opens then closes immediately so any error that may occur cannot be determined.
Solution
When running a .cmd or .bat script, i.e. installTool.cmd, to capture what would be written to the window, you can try using the following command, replacing filename with a name of your choosing:
installTool.cmd -s -d >> filename
For example:
installTool.cmd -s -d >> C:\install.log
Subscribe to:
Posts (Atom)