You are not authorized to view the report(s).

Posted by on February 9, 2010 No comments

Problem:

After creating clone (tramdmo), the DDDAUDIT report was run from Process Scheduler. The report completes successfully, but when trying the view the report (PeopleTools > Process Scheduler > Process Monitor, then Details > View Log/Trace), the fsdmo PIA login screen appears with the message:

You are not authorized to view the report(s).

Solution:

Navigate to PeopleTools > Process Scheduler > Report Nodes

Set URL to http://GLWEBAPP:8020/psreports/tramdmo
Set Description to TRAMDMO Reporting Node
Ensure Operating System is NT/Win200
Network Path is \glwebappe$psreports

The correct URL now appears:

Click to access DDDAUDIT_7311.PDF

Sample 11.5.9 to 12.1.1 Upgrade Steps

Posted by on January 7, 2010 No comments

1. Preparing for the Upgrade

Apply 11i.AD.I
Back up database, Applications, and customizations
Prepare an upgrade plan for customizations
Convert to Multiple Organizations architecture
Review sizes of old and new tablespaces
Review Upgrade Tasks and Apply 11i.AD.I

Convert Oracle Alert E-mail Processing to the Workflow Notification Mailer
Financials and Procurement Tasks
Gather schema statistics for CBO
Back up the database
Run Rapid Install
Migrate or upgrade your database to Oracle 10g Release 2
Port application to Linux servers

2. Upgrading to Release 12

Disable AOL Audit Trail
Migrate database to Oracle10g Release 2
Back up the database
Apply Release 12 AD minipack
Run the American English upgrade patch driver
Run the NLS upgrade patch driver
Apply latest product patches
Synchronize NLS and American English product patches
Back up Oracle Applications

Finish the Upgrade
Configure Applications client software for forms applet (required)
Reapply customizations (conditional)
Integrate custom objects and schemas (conditional)

Finish System Administration Tasks
Complete Workflow Notification Mailer configuration (required)
Complete setup for Oracle XML Gateway (required)
Enable PDF printing (required)

3. Post-upgrade Tasks
Install online help
Update/verify custom responsibilities
Migrate custom development to new technologies
Migrate the CUSTOM library
Copy and re-customize modified scripts or reports
Review user responsibility assignments
Associate organization names with custom Alert definitions
Set operating unit mode for customizations
Assign the Report Manager Data Migration Program to a request group
Run the Data Migration Program

Update Status Monitor URLs
Synchronize Product License and Workflow BES license status
Financials and Procurement Tasks
Additional Tasks

Clearing Linux File Cache

Posted by on December 19, 2009 No comments

To clear the Linux file system cache, use the following command:

sync ; echo 3 > /proc/sys/vm/drop_caches

REP-3000 Error

Posted by on December 17, 2009 No comments

To resolve REP-3000 while running PDF reports, try these solutions:

1. Set ‘s_display’ in SID_server.xml using vi or using Oracle Application Manager:

a. Use the ‘uname -n’ command to determine the correct name of the server eg vision.hostname.com

b. If the ‘echo $DISPLAY’ command is set to 0.0, then the s_display parameter to this value, for example:

vision.hostname.com:0.0

c. In a Terminal window, enter ‘xhost +’

d. Do not log off the console (0.0)
OR

2. If VNC is running on port 1 on the server:ex

set s_display to vision.hostname.com:1.0 or vision:1.0

Ensure that VNC server is not killed during the day.

Or set ‘headless’ in SID_server.xml to true and DisallowTCP to false in the /etc/X11/gdm/gdm.conf

Run AutoConfig after changing any SID_server.xml parameter.

Tape Commands for Linux

Posted by on December 15, 2009 No comments

To back up /etc folder:

tar -cvf /dev/st0 /etc

To list contents of tape:

tar -tf /dev/st0

To restore data from tape:

tar -xvf /dev/st0

Script To Export 11i Database

Posted by on December 15, 2009 No comments 
# expprod.sh
#
# Exports the Oracle E-Business Suite HRMS Production database
# which will then be copied over to the backup server
#
# source the environment
. /u0/oracle/proddb/9.2.0/PROD_ebusiness.env
# stop, then restart the production instance
# to overcome 'snapshot too old' error
# (commented out, as users on the system at 6:00 P.M. will be kicked off)
# cd /u0/oracle/proddb/9.2.0/appsutil/scripts/PROD_ebusiness/
# ./addbctl.sh stop immediate
# ./addbctl.sh start
# get name of log file and dump file
export LOGFILE=expprod_`date +%F_%k-%M-%S`.log
export DUMPFILE=expprod.dmp
export BACKUPDIR=/mnt/prodbkup
export EXPORTDIR=/u0/prodbkup
export ZIPFILE=expprod.tar.gz
export ZIPFILE2=expprod_`date +%F_%k-%M-%S`.tar.gz
# remove existing dump file
rm $EXPORTDIR/$DUMPFILE
rm $EXPORTDIR/$ZIPFILE
# export the ONT schema (for testing purposes)
# exp system/manager file=$EXPORTDIR/$DUMPFILE log=$EXPORTDIR/$LOGFILE owner=ONT
# export the database
exp system/manager file=$EXPORTDIR/$DUMPFILE log=$EXPORTDIR/$LOGFILE full=y consistent=y
# tar and gzip export file
tar -czvf $EXPORTDIR/$ZIPFILE $EXPORTDIR/$DUMPFILE
# remove the previous export dump from the test server, then copy the new one
# rm $BACKUPDIR/$DUMPFILE
# rm $BACKUPDIR/$ZIPFILE (Commented out by VS 10-Sep-09)
# copy the zip file and log file to the backup directory (remote NFS directory on ebusinesstest)
cp $EXPORTDIR/$ZIPFILE $BACKUPDIR/
cp $EXPORTDIR/$LOGFILE $BACKUPDIR/
# rename the zip file in the remote directory to reflect today's date
mv $BACKUPDIR/$ZIPFILE $BACKUPDIR/$ZIPFILE2
# rename the zip file in the local directory to reflect today's date (as an archive copy)
mv $EXPORTDIR/$ZIPFILE $EXPORTDIR/$ZIPFILE2

Page Not Found After SSL Setup

Posted by on December 9, 2009 No comments

Problem:

After setting up SSL on PeopleSoft instance, logon page appears. After logging on, the web browser displays the message:

This page cannot be displayed.

Solution:

Needed to change Web Profile from DEV to PROD in Application Server config file.

Backup Script for Oracle 10g

Posted by on December 8, 2009 No comments

Sample script to backup an Oracle 10g database on Linux.

#!/bin/sh
 # orahotbkup.sh
 #
 # Copies Oracle database data files to backup directory on disk
 # and individually gzips them
 #
# set up environment variables
 # need to export the Oracle environment variables
 export ORACLE_SID=orcl
 export ORACLE_HOME=/u01/app/oracle/product/10.2.0/db_1
 export PATH=$ORACLE_HOME/bin:$PATH
FMT_DATE=`/bin/date +%Y%m%d`
 BACKUP_BASE=/u01/app/oracle/oradata/backup/orcl
SCRIPT_LOC=/u01/app/oracle/admin/$ORACLE_SID/scripts/backup
 LOG_LOC=/u01/app/oracle/admin/$ORACLE_SID/scripts/log
 BACKUP_LOC=$BACKUP_BASE/$FMT_DATE
SCRIPT_FILE=$SCRIPT_LOC/dbf$FMT_DATE.sh
 LOG_FILE=$LOG_LOC/$FMT_DATE.log
# make destination directories
 mkdir -p $LOG_LOC
 mkdir -p $SCRIPT_LOC >> $LOG_FILE
 mkdir -p $BACKUP_LOC >> $LOG_FILE
# generate bash script file to copy database data files to destination
 sqlplus / as sysdba <
select '#!/bin/sh ' from dual;
 select 'sqlplus / as sysdba <<EOF'||chr(10)||
 'alter tablespace '||tablespace_name||
 ' begin backup; '||chr(10)||
 'exit'||chr(10)||
 'EOF'||chr(10)||chr(10)||
 'cp '||file_name||' $BACKUP_LOC/'||substr(file_name,instr(file_name,'/',-1)+1)
 ||chr(10)||chr(10)||
 'sqlplus / as sysdba <<EOF'||chr(10)||
 'alter tablespace '||tablespace_name||
 ' end backup; '||chr(10)||
 'exit'||chr(10)||
 'EOF'
 from dba_data_files
 order by file_id
spool $SCRIPT_FILE
/
spool off
 exit
 EOF
# change permission modes on script file to make it executable
 chmod 755 $SCRIPT_FILE
# execute the script file to copy the database data files
 $SCRIPT_FILE
# set name of second script file
 SCRIPT_FILE=$SCRIPT_LOC/arc$FMT_DATE.sh
# generate bash script file to copy archive logs to destination
 sqlplus / as sysdba <
alter system switch logfile;
 alter system switch logfile;
 alter system switch logfile;
alter database backup controlfile to '$BACKUP_LOC/control01.dbf';
select '#!/bin/sh ' from dual;
 select
 'cp '||name||' $BACKUP_LOC/'||substr(name,instr(name,'/',-1)+1)
 ||chr(10)||chr(10)
 from v$archived_log
 where completion_time > sysdate - 1.1
 order by completion_time
spool $SCRIPT_FILE
/
spool off
 exit
 EOF
# change permission modes on script file to make it executable
 chmod 755 $SCRIPT_FILE
# execute the script file to copy the archive log files
 $SCRIPT_FILE
# gzip each database file in the $BACKUP_LOC directory
 gzip $BACKUP_LOC/*
echo All done!

ORA-1654: unable to extend index

Posted by on November 12, 2009 No comments

This documentation shows the SQL*Plus output for resolving the ORA-01654 error.

Microsoft Windows [Version 5.2.3790]
(C) Copyright 1985-2003 Microsoft Corp.
C:Documents and Settingsoracle>f:
F:>cd oraclePRODdbtech_st10.2.0
F:oraclePRODdbtech_st10.2.0>PROD_mainfinsrv1.cmd
ECHO is off.
ECHO is off.
Thu 11/12/2009 08:04 PM
PROD_mainfinsrv1.cmd exiting with status 0
F:oraclePRODdbtech_st10.2.0>cd adminPROD_mainfinsrv1bdump
F:oraclePRODdbtech_st10.2.0adminPROD_mainfinsrv1bdump>tail -40 alert_prod.log
Thu Nov 12 19:54:51 2009
ORA-1654: unable to extend index APPLSYS.FND_CRM_HISTORY_U2 by 16 in tablespace
APPS_TS_TX_IDX
Thu Nov 12 19:55:21 2009
ORA-1654: unable to extend index APPLSYS.FND_CRM_HISTORY_U2 by 16 in tablespace
APPS_TS_TX_IDX
F:oraclePRODdbtech_st10.2.0adminPROD_mainfinsrv1bdump>sqlplus apps/apps
SQL*Plus: Release 10.2.0.3.0 - Production on Thu Nov 12 20:05:07 2009
Copyright (c) 1982, 2006, Oracle. All Rights Reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Production
With the Partitioning, OLAP and Data Mining options
SQL> desc dba_indexes
Name Null? Type
----------------------------------------- -------- ----------------------------
OWNER NOT NULL VARCHAR2(30)
INDEX_NAME NOT NULL VARCHAR2(30)
INDEX_TYPE VARCHAR2(27)
TABLE_OWNER NOT NULL VARCHAR2(30)
TABLE_NAME NOT NULL VARCHAR2(30)
TABLE_TYPE VARCHAR2(11)
UNIQUENESS VARCHAR2(9)
COMPRESSION VARCHAR2(8)
PREFIX_LENGTH NUMBER
TABLESPACE_NAME VARCHAR2(30)
INI_TRANS NUMBER
MAX_TRANS NUMBER
INITIAL_EXTENT NUMBER
NEXT_EXTENT NUMBER
MIN_EXTENTS NUMBER
MAX_EXTENTS NUMBER
PCT_INCREASE NUMBER
PCT_THRESHOLD NUMBER
INCLUDE_COLUMN NUMBER
FREELISTS NUMBER
FREELIST_GROUPS NUMBER
PCT_FREE NUMBER
LOGGING VARCHAR2(3)
BLEVEL NUMBER
LEAF_BLOCKS NUMBER
DISTINCT_KEYS NUMBER
AVG_LEAF_BLOCKS_PER_KEY NUMBER
AVG_DATA_BLOCKS_PER_KEY NUMBER
CLUSTERING_FACTOR NUMBER
STATUS VARCHAR2(8)
NUM_ROWS NUMBER
SAMPLE_SIZE NUMBER
LAST_ANALYZED DATE
DEGREE VARCHAR2(40)
INSTANCES VARCHAR2(40)
PARTITIONED VARCHAR2(3)
TEMPORARY VARCHAR2(1)
GENERATED VARCHAR2(1)
SECONDARY VARCHAR2(1)
BUFFER_POOL VARCHAR2(7)
USER_STATS VARCHAR2(3)
DURATION VARCHAR2(15)
PCT_DIRECT_ACCESS NUMBER
ITYP_OWNER VARCHAR2(30)
ITYP_NAME VARCHAR2(30)
PARAMETERS VARCHAR2(1000)
GLOBAL_STATS VARCHAR2(3)
DOMIDX_STATUS VARCHAR2(12)
DOMIDX_OPSTATUS VARCHAR2(6)
FUNCIDX_STATUS VARCHAR2(8)
JOIN_INDEX VARCHAR2(3)
IOT_REDUNDANT_PKEY_ELIM VARCHAR2(3)
DROPPED VARCHAR2(3)
SQL> select owner, index_name, index_type, tablespace_name, initial_extent, next_extent,
min_Extents, max_extents from dba_indexes where index_name = 'FND_CRM_HISTORY_U2';
OWNER INDEX_NAME
------------------------------ ------------------------------
INDEX_TYPE TABLESPACE_NAME INITIAL_EXTENT
--------------------------- ------------------------------ --------------
NEXT_EXTENT MIN_EXTENTS MAX_EXTENTS
----------- ----------- -----------
APPLSYS FND_CRM_HISTORY_U2
NORMAL APPS_TS_TX_IDX 131072
131072 1 2147483645
SQL> DESC DBA_DATA_FILES
Name Null? Type
----------------------------------------- -------- ----------------------------
FILE_NAME VARCHAR2(513)
FILE_ID NUMBER
TABLESPACE_NAME VARCHAR2(30)
BYTES NUMBER
BLOCKS NUMBER
STATUS VARCHAR2(9)
RELATIVE_FNO NUMBER
AUTOEXTENSIBLE VARCHAR2(3)
MAXBYTES NUMBER
MAXBLOCKS NUMBER
INCREMENT_BY NUMBER
USER_BYTES NUMBER
USER_BLOCKS NUMBER
ONLINE_STATUS VARCHAR2(7)
SQL> SELECT FILE_NAME, TABLESPACE_NAME, BYTES/1024/1024 FROM DBA_DATA_FILES WHERE TABLESPACE_NAME = 'APPS_TS_TX_IDX';
FILE_NAME
--------------------------------------------------------------------------------
TABLESPACE_NAME BYTES/1024/1024
------------------------------ ---------------
F:ORACLEPRODDBAPPS_STDATAA_TXN_IND05.DBF
APPS_TS_TX_IDX 1273
F:ORACLEPRODDBAPPS_STDATAA_TXN_IND04.DBF
APPS_TS_TX_IDX 1287
F:ORACLEPRODDBAPPS_STDATAA_TXN_IND03.DBF
APPS_TS_TX_IDX 1577
FILE_NAME
--------------------------------------------------------------------------------
TABLESPACE_NAME BYTES/1024/1024
------------------------------ ---------------
F:ORACLEPRODDBAPPS_STDATAA_TXN_IND02.DBF
APPS_TS_TX_IDX 1200
F:ORACLEPRODDBAPPS_STDATAA_TXN_IND01.DBF
APPS_TS_TX_IDX 1200
SQL> ALTER TABLESPACE APPS_TS_TX_IDX
2 ADD DATAFILE 'F:ORACLEPRODDBAPPS_STDATAA_TXN_IND06.DBF' SIZE 1200M;
ALTER TABLESPACE APPS_TS_TX_IDX
*
ERROR at line 1:
ORA-01031: insufficient privileges
SQL> CONNECT SYSTEM/MANAGER
Connected.
SQL> L
1 ALTER TABLESPACE APPS_TS_TX_IDX
2* ADD DATAFILE 'F:ORACLEPRODDBAPPS_STDATAA_TXN_IND06.DBF' SIZE 1200M
SQL> R
1 ALTER TABLESPACE APPS_TS_TX_IDX
2* ADD DATAFILE 'F:ORACLEPRODDBAPPS_STDATAA_TXN_IND06.DBF' SIZE 1200M
Tablespace altered.
SQL> DISC
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Production
With the Partitioning, OLAP and Data Mining options
SQL> EXIT
F:oraclePRODdbtech_st10.2.0adminPROD_mainfinsrv1bdump>

After R12 Vision Installation, Concurrent Manager Not Starting

Posted by on November 11, 2009 No comments

Problem: Oracle E-Business Suite R12 was installed on appswindows3. After installation, the Concurrent Manager is not starting.

Solution: Checked Event Viewer. The following messages appear:

Restart ICM (Retries left:0)
ICM process exited with error(1)
FNDLIBR Stopped(1)

Reference:
http://forums.oracle.com/forums/thread.jspa?threadID=591003&start=15&tstart=0

Checked directory: %APPLCSF%%APPLLOG%
G:oracleVIS12instappsVIS12_appswindows3logsapplconclog>

G:oracleVIS12instappsVIS12_appswindows3logsapplconclog>type CM_VIS12_appswindows3.log

List of errors encountered:
………………………………………………………..

_ 1 _
Routine AFPCAL received a return code of failure from routine spiini.

Review your concurrent request log file for more information.
………………………………………………………..

G:oracleVIS12instappsVIS12_appswindows3logsapplconclog>

Type CM_VIS12_appswindows3.log:
Routine AFPCAL received a return code of failure from routine spiini.

To reproduce error, source apps environment and run:

FNDCPUCF apps/apps 0 Y %AD_TOP%admintemplateadctxinf.tmp

Metalink Reference:
Subject: Concurrent Manager Service Fails To Start With Error Code 1067
Doc ID: 434444.1

Cause
The issue is caused because of uninitialized string (New Value #1) in the registry under APPL_CONFIG.

The uninitialized key is causing Concurrent Managers not to come up. In the Task manager FNDLIBR.exe comes up briefly and dies.

Solution
To implement the solution, please execute the following steps:

1. Go into the registry

2. Delete uninitialized key under APPL_CONFIG

3. Retest the issue by starting concurrent manager service

Ran AutoConfig on the database tier:

The above did not work, as there was no uninitialized key under APPL_CONFIG.

Stopped all Oracle application tier services and ran AutoConfig:
cd G:oracleVIS12instappsVIS12_appswindows3adminscripts
adautocfg.cmd

[AutoConfig Error Report]
The following report lists errors AutoConfig encountered during each
phase of its execution. Errors are grouped by directory and phase.
The report format is:

[PROFILE PHASE]
AutoConfig could not successfully execute the following scripts:
Directory: G:oracleVIS12instappsVIS12_appswindows3admininstall
afcpctx.cmd INSTE8_PRF 1

AutoConfig is exiting with status 1

Metalink Reference:
Bug No: 3815440 (AFCPCTX.CMD FAILS WHEN AUTOCONFIG IS RUN)

Subject: After Doing a Clone All the Concurrent Managers Do Not Start
Doc ID: 555081.1

Subject: After Doing a Clone All the Concurrent Managers Do Not Start
Doc ID: 555081.1

Subject: 11i : Oracle Application Object Library Concurrent Manager Setup Test
Doc ID: 200360.1

Subject: Oracle9i Application Server (9iAS) with Oracle E-Business Suite Release 11i Troubleshooting
Doc ID: 216208.1