AD ADMIN UTILITIES

AdAdmin

Ad admin is a utility which is used to perform

Login as a Applmgr user:
[applmgr@apps ~]$ adadmin


Preliminary Tasks:

1. Running the environment file.
2. Verifying that ORACLE_HOME set properly.
3. Ensuring that ORACLE_HOME/bin and AD_TOP/bin are in your path.
4. Shutting down the concurrent managers when relinking certain files or performing certain database tasks.
5. Ensuring Sufficient temporary disk space.


Ad administration prompts:

Your default directory is '/u01/app/apps/uatappl'.
Is this the correct APPL_TOP [Yes]

Filename [adadmin.log] :

APPL_TOP is set to /u01/app/apps/uatappl

Please enter the batchsize [1000] :

Enter the password for your 'SYSTEM' ORACLE schema: manager

Enter the ORACLE password of Application Object Library [APPS] : app
s







Ad admin Log files:


The main AD Administration log file is called adadmin.log by default. This name can be
Changed when starting up AD Administration.

Errors and warnings are listed in the log file
/u01/app/apps/uatappl/admin/UAT/log/adadmin.log



General Applications file menu


There are five functional choices in the generate applications file menu.

1. Generate Message Files:
This task generates message binary files in the $PROD_TOP/mesg directory from oracle application object library tables.

We generally perform this task only when instructed to do so in a readme file of a patch.

2. Generate Form Files:
This task generate binary oracle forms file for all installed languages from the form definition files. Extension (*.fmx)

Perform this task whenever we have issue with a form or set forms.

Oracle application uses these binary files to display the data entry forms.

When we choose Generate form files:
It prompts following:



Generate Report files:
This task generates binary report files for all installed languages. Extension of the file name like (*.rdf)

When we choose Generate report files menu, it prompts the following.


Generate Graphics files:
This task generates Oracle graphics files for all installed languages. Extension of the file name like (*.ogd)

The serious of prompts and actions in this task are very similar to the prompts and actions in the Generate form files task.


Generate Product JAR files:
This generate product jar files task prompts
Do you wish to force generation of all jar files? [No]
If we choose No, it only generates JAR (Jave Archive) files that are missing or out of date.
Choose yes for this option when generating JAR files after upgrading the developer technology stack or after updating your Java version.

Maintain Applications Files tasks


Relink Application programs:
This task relinks all your oracle applications binary executables.
Select this task after us:
1. Install new version of the database or a technology stack component.
2. Install an underlying technology component used with oracle applications.
3. Apply a patch to the application technology stack.
4. Apply a patch to the operating systems


These tasks execute AD relink utility. Use AD admin, not the AD relink utility directly, to relink non AD-executables.

Create Applications environment file:
Select this task when you want to:
1. Create an environment file with settings that are different from your current environment file.
2. Recreate an environment file that is missing or currept.

Copy files to destinations:
The copy files to destinations task copies files from each product area to central locations where they can easily referenced by oracle applications.

Use this option to update the java, HTML and media files in the common directories (such as JAVA_TOP, OA_TOP) when users have issues accessing them.

1. Java file are copied to JAVA_TOP
2. HTML files are copied to OAH_TOP
3. Media files are copied to OAM_TOP


Convert Character Set:


1. This task converts the character set of all translatable files in APPL_TOP.
2. You should select this task when changing the base language or adding additional languages to oracle applications
3. You may need to convert database character set and file system character set to one that will support the additional languages.


Maintain snapshot information:


1. This task record details for each file in the APPL_TOP (like file name and file version).
2. They also record summary information’s about patches that have been applied to the APPL_TOP.
3. The maintain snapshot information task stores information about files, file versions and bug fixes present in an APPL_TOP.
4. You must run Maintain snapshot information option once for each APPL_TOP before you apply any patch that contains a “compatible feature prereq” line on that APPL_TOP.


Check for Missing files:


1. The check for missing files task verifies files needed to install, upgrade, or run oracle applications for the current configuration are in the current APPL_TOP.
2. Choose this task if you suspect there are files missing in your APPL_TOP.


Maintain Database Entries tasks:



Validate Apps Schema:


Validate apps schema task run SQL script (advrfapp.sql) against the apps schema to verify the integrity of the schema.
It determines:


1. Problems you must fix(not specific to apps schema)
2. problems you must fix(specific to apps schema)
3. Issues you may want to address(specific to apps schema)

A report called APPSschemaname.lst is produced in APPL_TOP/admin//out.
This report contains information about how to fix the issues. We can find following things by running the Validate Apps schema.


1. Missing or invalid package.
2. Missing or invalid synonyms.
3. Invalid objects in apps schema.


This task is more effective if run:


1. Immediately after an upgrading or applying maintenance pack
2. After a patch is applied.
3. After performing export/import (migration)
4. When doing custom development in the apps schema.


Recreate Grants and Synonyms:


This task recreates grants and synonyms for oracle application public schema (applsyspub)
Recreate grants on some packages from system to apps

Run this task when grants and synonyms are missing from the database. This may occur as a result of
1. Custom development
2. Incomplete database migrations
3. Patches and administrative sessions that failed to run successfully to completion

Maintain multi-lingual tables:


MLS or multilingual support is oracle application’s ability to operate in a multi languages simultaneously. When running Maintain multi-lingual task you can select the number of parallel workers. In generally run during the NLS install and maintenance processes. This task runs the NLINS.sql script for every product. It invokes pl/sql routines that maintain multilingual tables and untranslated rows.

Check Dual Tables:


This task looks for a dual table accessible by oracle applications and ensures the correct grants are set up. If such table not exists or if an existing DUAL table has more than one row, AD administration displays error. If a DUAL table containing only one row exists, AD admin completes successfully.

Maintain multiple reporting currencies:


This option varies depending on whether you currently have multiple reporting currencies (MRC) enabled or not.
If MRC functionality is implemented in your database, the option reads maintain multiple reporting currencies.

Convert to multiple organizations:


To convert in to multiple-org does the following thing:


1. Confirms that you want to run the task
2. Asks for the number of parallel workers
3. Create script to disable and re-enable triggers in the APPS schema
4. Disable all triggers in the apps schema
5. Converts seed data and transaction data to multiple organizations in parallel.
6. Re-enable all previously disabled triggers in the apps schema.


Compile and Reload Database Entries tasks:


Compile Apps Schema:


This task compiles uncompiled program units (pl/sql and java) in the apps schema.
You can perform this task with multiple workers.
When running this task, AD administration prompts,
Run Invoker's Rights processing in incremental mode [No]?
Type Yes at this prompt to run Invoker Rights processing only on packages that have changed
Since Invoker Rights processing was last run or accept the default to run Invoker Rights
Processing on all packages.
During the upgrade progress.

Compile Menu Information:


This option compiles menu data structures.
Choose this task after uploading menu entries.


It asks if you want to force compilation for all menus,


1. If you choose the default [no] only menus with changes are saved
2. If you enter yes all menus are compiled


Compile flexfield:


Run this task if the readme of a patch indicates that this step should be performed.
Details of the task with a list of compilation status of every flexfield are written to a log file.
The name of the log file is in the format .req. The main AD Administration log file contains the exact name of this log file.

Reload JAR Files to Database:


This option runs the loadjava utility to reload all appropriate oracle applications
JAR files into the database.

Change Maintenance mode:


1. Must be enabled before patching oracle applications
2. Improves patching performance
3. Restricts users access to system
4. Is enabled and disabled using AD administration

Discoverer 10g Installation and Migration Plan

10g Infra and AS with Discoverer 10g Installation and Migration Plan

Software:
Application Server:
1. Oracle Identity Management 10g (10.1.4.0.1)
Download URL http://www.oracle.com/technology/software/products/ias/htdocs/101401.html
2. Oracle Application Server 10g Release 2 (10.1.2.0.2)
Download URL
http://www.oracle.com/technology/software/products/ias/htdocs/101202.html

What is Discoverer
http://www.epa.gov/ttn/airs/airsaqs/manuals/AQSDiscManDraftChapters1-3-29May07.pdf

Enivironment:

AIX Version 5.3 - EBIZ 11i
AIX Version 5.3 - Application Server(Separate Machine)




Index

• Feasible Architectures
• Installation
• Configuration
• Connectivity to Apps DB
• Post Installation Tasks
• EUL Migration
• Discoverer clients on Windows PC
• JInitiator upgradation

Steps

• Application Unix Account
• Oracle Unix account
• 10gAS Server Installation with Discoverer Component on separate ORACLE_HOME on existing 11i environment on application tier or separate server.
• Installation of Infra metadata database (If required) on separate server
• Configuration of Portal setup (If required)



Change ownership on application user like oracle or applmgr, etc …

chown -R applmgr:dba /etc/oraInventory

Configuration

1. Establish Connectivity between Discoverer 10g and Apps Database
2. Discoverer integration with 11i through changes in XML.
3. Discoverer Profile changes in 11i to point new Discoverer 10g


Connectivity to Apps DB

• Update tnsnames.ora file to connect Oracle Apps 11i
• Enable sqlnet access
• Connectivity check through Discoverer Home


Post Installation Tasks

• Configuring Oracle 11i to use Discoverer 10g and to load Application specific content and workbooks into discoverer 10g EUL
• Latest AutoConfig patch
• AD Patch application
• ICX Patch application


EUL Migration

• Schema creation for EUL
• EUL Creation
• Database Parameter setting (Rollback segment)
• DBA setup to migrate $AU_TOP to 10gAS server
• Import Discoverer Content for release 11i
• Refresh Discoverer 10g EUL
• Check grant privileges (Responsibility, Users, Workbooks )


Discoverer clients on Windows PC

Install Internet Developer Suit 10g, this will install Admin edition

• Edit Microsoft windows registry
• FTP DBC file from 11i to D:\secure on Windows PC
• TNS Connectivity to 11i Database
• Install Discoverer Desktop

JInitiator Upgradation

• Change in config.xml on 10gAS env.
• JVM setting for JInitiator 1.3.1.24
• JInitiator upgrade on 11i env.
• Application JInitiator patches



Oracle Application Server 10g 10.1.4.0.1

Installation Screenshots





















The following information is available in:
/u01/applmgr/disco10g/OraHome_10/install/setupinfo.txt

Oracle Application Server 10g 10.1.4.0.1 Usernames and Default password information:
Please refer to Oracle Application Server 10g Administrator Guide for more information.
Install Type: Identity Management and Metadata Repository

Configured Components: Oracle Application Server Metadata Repository Oracle HTTP Server Oracle Application Server Containers for J2EE Oracle Internet D
irectory Oracle Application Server Single Sign-On Oracle Application Server Delegated Administration Services Oracle Directory Integration Platform

New Database created with these properties:
Database File Location: /u01/applmgr/disco10g/oradata/
Database Global Name: bldisco.doyen-sys.com
Database SID:bldisco
Database Name:bldisco
Character Set: -characterset AL32UTF8

Use the following URL to access the Oracle HTTP Server and the Welcome Page:
http://doyen.doyen-sys.com:7777

Use the following URL to access the Oracle Enterprise Manager Application Server Control:
http://doyen.doyen-sys.com:1156

Instance Name: infra.doyen.doyen-sys.com


Oracle Application server 10g 10.1.2.0.2









Give the OID(10g Infra hostname and OID Port) hostname and port.


Provide the 10g Infra username (ias_admin) password : welcome1





Provide the below details

User Name : ias_admin
Instance name : disco
Password : welcome1









Oracle Application Server 10g 10.1.2.0.2 Usernames and Default password information:

Please refer to the Oracle Application Server 10g Administrator Guide for more information.

Install Type: All Services

Configured Components: Oracle HTTP Server, Oracle Application Server 10g Containers for J2EE, Oracle Application Server 10g Web Cache, Oracle Application Ser
ver 10g Portal, Oracle Application Server 10g Discoverer, Oracle Application Server 10g Personalization, Oracle Application Server 10g Reports Services, Orac
le Application Server 10g Forms Services,

Registered with Oracle Internet Directory: apollo:389

Use only SSL connections with this Oracle Internet Directory:No

Database Connection String: doyen.doyen-sys:1521:bldisco.doyen-sys:bldisco.doyen-sys

Use the following URL to access the Oracle HTTP Server and the Welcome Page:

http://doyen.doyen-sys:7778/

Use the following URL to access the Oracle Enterprise Manager Application Server Control:
http://doyen.doyen-sys:1810/

Instance Name: disco.doyen.doyen-sys.com


END OF INSTALLATION


1.1 Copy dbc file from 11i ebiz to 10g Discoverer Server

Oracle E-Business Suite 11.5.10 customers :


The default naming convention for the .dbc file for Oracle E-Business Suite Release 11.5.10 is .dbc.

Please copy the dbc file .dbc from your 11i instance, and save the file on your Discoverer 10.1.2 $ORACLE_HOME/discoverer/secure directory as .dbc.

$copy $FND_SECURE(11i) TO $ORACLE_HOME/discoverer/secure(10g Disco)

$cp $FND_SECURE $ORACLE_HOME/discoverer/secure


1.2 Update tnsnames.ora file

Copy $TNS_ADMIN/tnsnames.ora (11i) to ORACLE_HOME/network/admin/tnsnames.ora(Disco 10g)

dev=
(DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=apollo.fti-intra.com)(PORT=1535))
(CONNECT_DATA=
(SID=dev)
)
)





Migrate your existing Discoverer End User Layers to Discoverer 10.1.2.

Upgrade your existing Discoverer 4i or Discoverer 9.0.4 End User Layer to Discoverer 10.1.2 by using the following command on the standalone application server where Oracle Business Intelligence Server 10g Release 2

Pre Upgrade steps

1. export ORACLE_HOME=/progs/scr/disco10g/OraHome_11
2. export TNS_ADMIN=/progs/scr/disco10g/OraHome_11/network/ADMIN
3. tnsping uat
4. export eul_us schema in 11i instance(Just backup)


Backup 11i ebiz eul_us schema

oracle doyen> exp EUL_US/EUL_US file=pre_10g_upgrade_eul_backup.dmp

Run the following command to migrate 4i disco to 10g disco


10g Disco oracle home (not infra oracle home)

bash-2.05b$ pwd
/u01/applmgr/disco10g/OraHome_11/bin


bash-2.05b$ eulapi -CONNECT EUL_US/EUL_US@uat -AUTO_UPGRADE
-connect <**********>
-auto_upgrade
Command completed.

Now try to open Discoverer viewer





End Of the Installation

If need any query, please post your comments


The field PARAMETER.CONFIG could not be located or read

Problem Description:
================


"The field PARAMETER.CONFIG could not be located or read."
The adapcctl.log carries the following errors:
Cannot read value from field PARAMETER.CONFIG
Cause: The field PARAMETER.CONFIG could not be located or read.

Making AOL/J Test

ERROR:validateLogin returned false: failed to login as sysadmin, please try again.
AOLJ_JAVA_EXCEPTION (MESSAGE=Not able to create new database connection: FNDSECURITY_APPL_USERID_INVALID)
SECURITY_INVALID_DBC_PARAMETER (PARAMETER=GUEST_USER_PWD) (FILE=/progs/11i/prod/applmgr/prodappl/fnd/11.5.0/secure/prod_atlas/prod.dbc) (ROUTINE=AppsConnectionManager.makeGuestConnection)
FNDSECURITY_APPL_USERID_INVALID
SECURITY_APPL_USERID_INVALID
AOLJ_JAVA_EXCEPTION (MESSAGE=Profiles: getJDBCConnection() == null)
AOLJ_JAVA_EXCEPTION (MESSAGE=Not able to create new database connection: FNDSECURITY_APPL_USERID_INVALID)
SECURITY_INVALID_DBC_PARAMETER (PARAMETER=GUEST_USER_PWD) (FILE=/progs/11i/prod/applmgr/prodappl/fnd/11.5.0/secure/prod_atlas/prod.dbc) (ROUTINE=AppsConnectionManager.makeGuestConnection)
FNDSECURITY_APPL_USERID_INVALID
SECURITY_APPL_USERID_INVALID

Cause:

There is a problem with Guest user. So proceed checking Guest user.

Step 1 :

SQL> select fnd_web_sec.validate_login('GUEST','GUEST') from dual;
FND_WEB_SEC.VALIDATE_LOGIN('GUEST','GUEST')
--------------------------------------------------------------------------------
N

SQL> select profile_option_value from fnd_profile_option_values where profile_option_id = 3805;
PROFILE_OPTION_VALUE
--------------------------------------------------------------------------------
GUEST/GUEST


SQL> select USER_NAME, END_DATE from fnd_user where USER_NAME like '%GUEST%'

USER_NAME END_DATE
------------------ --------------
GUEST 27/08/08
GUEST2
IBEGUEST


Fix :

Check the FND_USER table and check the end_date column for the Guest user. It will be end dated. So to make it null do the following.

Login as apps user.

Back up your FND_USER TABLE

Run the following command
update fnd_user set end_date=null where user_name='GUEST';

Check Again below query, Now end date is null.

SQL> select USER_NAME, END_DATE from fnd_user where USER_NAME like '%GUEST%'

USER_NAME END_DATE
------------------ ---------------
GUEST
GUEST2
IBEGUEST

Now Run the autoconfig.

Start Apps.

R12 Login issue on target after cloning

Symptoms

On 12.0 (Oracle Aplication R12 + RUP 1) in TEST:
Find when launching URL : http://host.domain:port
is redirected to
http://host.domain:port/OA_HTML/AppsLocalLogin.jsp
...
nothing happen , no error, ...


Solution

To implement the solution, please execute the following steps:

1. cd $FND_TOP/patch/115/bin
2. perl ojspCompile.pl --compile --flush -p 2
3. Bring up the services and test login

11i - perl ojspcompile.pl --compile -quiet

R12 Login issue on target after cloning Doc ID: Note:435550.1

How to use OS commands to diagnose Database Performance issues

$ man vmstat

Here is some sample output from these commands:

$ prtconf |grep -i "Memory size"

Memory size: 4096 Megabytes

$ swap -s
total: 7443040k bytes allocated + 997240k reserved = 8440280k used, 2777096k available

$ df -k

...

$ top



$ vmstat 5 100



$ iostat -c 2 100



$ iostat -D 2 100



$ mpstat 2 100



HP-UX 11.0:
============

$ grep Physical /var/adm/syslog/syslog.log
$ df -k
$ sar -w 2 100
$ sar -u 2 100
$ /bin/top
$ vmstat -n 5 100
$ iostat 2 100
$ top


For example:

$ grep Physical /var/adm/syslog/syslog.log
Nov 13 17:43:28 rmtdchp5 vmunix: Physical: 16777216 Kbytes, lockable: 13405388 Kbytes, available: 15381944 Kbytes

$ sar -w 1 100

HP-UX rmtdchp5 B.11.00 A 9000/800 12/20/02



$ sar -u 2 100 # This command generates CPU % usage information.

HP-UX rmtdchp5 B.11.00 A 9000/800 12/20/02


$ iostat 2 100



AIX:
=======

$ /usr/sbin/lsattr -E -l sys0 -a realmem
$ /usr/sbin/lsps -s
$ vmstat 5 100
$ iostat 2 100
$ /usr/local/bin/top # May not be installed by default in the server



For example:

$ /usr/sbin/lsattr -E -l sys0 -a realmem

realmem 33554432 Amount of usable physical memory in Kbytes False

NOTE: This is the total Physical + Swap memory in the system.
Use top or monitor command to get better breakup of the memory.



$ /usr/sbin/lsps -s

Total Paging Space Percent Used
30528MB 1%



Linux [RedHat 7.1 and RedHat AS 2.1]:
=======================================

$ dmesg | grep Memory
$ vmstat 5 100
$ /usr/bin/top

For example:

$ dmesg | grep Memory
Memory: 1027812k/1048568k available (1500k kernel code, 20372k reserved, 103k d)$ /sbin/swapon -s


Tru64:
========
$ vmstat -P| grep -i "Total Physical Memory ="
$ /sbin/swapon -s
$ vmstat 5 100



For example:

$ vmstat -P| grep -i "Total Physical Memory ="

Total Physical Memory = 8192.00 M


$ /sbin/swapon -s

Swap partition /dev/disk/dsk1g (default swap):