Temple of Oracle

Oracle DBA Startup guide Post 3

2012-01-05T21:10:00.000+05:30

Oracle Database 10g is an Relational Database or RDBMS. There are two part of this RDBMS and they are Physical Database and Oracle Instance. Physical files, redo log files and control file are comutatively called as physical database. Oracle instance consists of a big memory area and some background process. It provide a way to the users to do an activity on the data. i.e. to retrive, add, modify or delete.

Data files - Physically stores the data
Redo log file - It contains the changes made to data. It is required for recovery.
Control files - It contains tipical information about database

Datafile location
Synchronization Information
Backup and recovery information

Supporting files i.e. parameter file, password file, alert log are important to database but is not a part of the database.

Naming convention of the database objects

Max 30 characters are supported
It have to start with a latter
Can include latter, number and underscore
Should not user reserved words

Oracle DBA Startup guide Post 2

2012-01-05T20:59:00.000+05:30

Oracle Database 10g installation CD is required to do a basic installation. Minimum 4 GB free disk space and 250 MB memory is required to do the installed. It can take at around 30 minutes to install the database. It also does some system checks i.e. utility and file permission.

There are various features in instance configuration

DBCA ( Database configuration assistance)
Policy based database configuration
Initialization Parameter

You can create database both using DBCA or manually from command line.

Oracle DBA Startup guide Post 1

2012-01-05T20:47:00.000+05:30

First task of an Oracle DBA is to install the Oracle Database. But before installing the database, DBA has to estimate the configuration of the server on which it is going to be installed. He have to keep in mind the bellow points,

Operation System version and compatability
Number and speed of the server
Size of the disk for configuration
Size of Memory( Primary as RAM)
Amount of space for backups

Oracle Enterprise Manager(OEM) Database Control included in oracle database 10g is installed for managing local databases. You need to install OEM grid control ( from Oracle Enterprise Manager CD ) for controlling multiple hosts, database and other oracle services.

Before installing Oracle Database, Oracle Universal Installer( OUI ) does a system compatability check to confirm the hardware, free disk space, OS version and other required utility.

Oracle Apps DBA Future

2012-01-02T21:11:00.000+05:30

Now we have come to a stage where Oracle Apps ( E Business Suite) will face a dramatic change in its future.

Previously, Oracle Apps DBA were those persons who knows

Oracle E Business Suite System Administration
Oracle Core DBA Activities
Troubleshooting
Some Unix Knowledge
And some other knowledge

Now Oracle has planed to make it upgraded with Oracle Apps 12.2 which will

push the DBAs' to update themselves.

11g Oracle DBA -- Part 2

2011-11-30T17:24:00.001+05:30

11g Oracle DBA -- Part 2

Introduction of 11g Database

Here we will go through the basic concepts of 11g Database. As an Oracle DBA you have to do the bellow activities. You have to install a Database. You may have to create a database. If required a DBA sometimes have to do an upgrade of the Database Server and the Database also. As per requirements it is a general requirement in a project that the database need to be started, stopped or restarted. They have plan the storage and memory structure of the database. It is one of the primary duty of a DBA to maintain user list and their securities. You have to manage all the database objects such as views, tables, indexes etc. To do backups and recoveries whenever required.

Weather a DBA will do all these activities or there will be divisions in terms of responsibilities, that depends upon the requirement, scope, and size and budget of the project.

For doing the above activities a DBA uses the bellow tools. These are the weapons of a DBA to complete his tasks.

Oracle Universal Installer (OUI)
Oracle Database Configuration Assistant (DBCA)
Database Upgrade Assistant (DBUA)
Net Configuration Assistant (NETCA)
Oracle Enterprise Manager Database Control
SQL* Loader
Recovery Manager (RMAN)

11g Oracle DBA -- Part 1

2011-11-30T16:09:00.001+05:30

11g Oracle DBA -- Part 1

In this section we will cover the various section a DBA need to cope up to administering 11g Oracle Database.

Introduction of 11g Database
How to install Oracle Database and how to create a Database
Starting Oracle Database administration
How to configure Network for Oracle Database
How to manage Oracle Database Instance
How to manage Oracle Database storage Structures
How to control User Accounts and Security
How to manage Oracle Database Schema Objects
How to do backup and recovery objectives
How to Monitor and Tune a database
Managing and Troubleshooting Oracle Database
Managing ORacle Database Software

In this section we have given a brief idea about the Oracle 11g DBA Activities.

Oracle iRecruitment (iRec) External Candidate (Site Visitor) Configuration - Login Steps

2011-11-30T15:36:00.001+05:30

Oracle iRecruitment (iRec) External Candidate (Site Visitor) Configuration & Login Steps

1. Make sure that you are using seeded iRecruitment External candidate responsibilities.

2. Set the SSO Profile settings with the values.

Applications SSO Login Types - Both
Applications SSO Type - SSWA
Applications SSO User Creation and Updation Allowed - Enabled
Application SSO LDAP Synchronization - Enabled

3. Schedule the following concurrent processes:
• iRecruitment Index Synchronization
This ensures the job posting and document indexes are kept up to date and should be scheduled to run as follows:
– Online index rebuild – to run every 5 minutes
– Full index rebuild – to run each night

• Synchronize WF Roles

4. Check the IRC: Registration Business Group profile pointing to a correct business group for the iRecruitment External candidate Responsibility.

5. Add site visitor responsibilities to your Guest user
Assign the iRecruitment Employee Site Visitor and iRecruitment External Site Visitor responsibilities to your guest user (identified by the Guest User Password profile option). This step is required to allow
access to the site visitor screens without logging in to the application.

6. Also, download IrcVisitor.jsp page from the server and open the page in text editor and check if the Responsibility ID of 'iRecruitment Site Visitor' login page pointing to upon login. Pointing to a correct responsibility and this responsibility should be pointing in the login jsp page.

7. Set up proxy server
Use the following profiles to set up your proxy server:

• Applications Server Side Proxy Host and Domain
• Applications Proxy Bypass Domain
• IRC: Proxy Authorization Password
• IRC: Proxy Authorization User Name

8. Configure and Freeze your flexfields
Configure and Freeze all flexfields used in iRecruitment. This stops error messages appearing on the screen telling you that your flexfields have not been frozen.

9. Check the log–in URL for iRecruitment users
The URL for connecting to the iRecruitment system varies according to the user group. For example, the internal site visitor URL is different from the external site visitor URL.
For external site visitors, you access the IrcVisitor.jsp. The location of this jsp will depend on your applications server, however, it is of the form:
http://hostname:port/OA_HTML/IrcVisitor.jsp
For internal site visitors, you access the IrcEmpVisitor.jsp. The location of this jsp also depends on your applications server, however, it is of the form:
http://hostname:port/OA_HTML/IrcEmpVisitor.jsp
You should replace the http://hostname:port/OA_HTML part of the URL with the URL of the html directory on your applications server.
Note: If you have installed other languages, you activate iRecruitment in the required language by adding the following suffix to the log–in URLs:
?L=<language code>
For example,
http://hostname:port/OA_HTML/IrcVisitor.jsp?L=F would activate the French language version.
The language codes are available in the table FND_INSTALLED_LANGUAGES.
If you do not specify a language code, the default (US) is used

10. Configure the web pages for iRecruitment
You configure the web page layout using the Personalization Framework. If applicable, configure flexfields, instructions and tips, and the delivered logos.

Untitled

2011-11-29T17:40:00.001+05:30

Day to Day activities of Oracle Apps DBA:

A DBA has to do various activities, it can be listed down according to priority, frequency of that activity. It can be devided in bellow pattern.

Daily Activities: These are the activities a DBA needs to do daily.

VERIFY ALL INSTANCES ARE UP
LOOK FOR ANY NEW ALERT LOG ENTRIES
VERIFY DBSNMP IS RUNNING
VERIFY SUCCESS OF DATABASE BACKUP
VERIFY SUCCESS OF DATABASE ARCHIVING TO TAPE
VERIFY ENOUGH RESOURCES FOR ACCEPTABLE PERFORMANCE
READ DBA MANUALS FOR ONE HOUR

Weekly Activities: These are the activities a DBA needs to excersize weekly.

LOOK FOR OBJECTS THAT BREAK RULES
LOOK FOR SECURITY POLICY VIOLATIONS
LOOK IN SQL*NET LOGS FOR ERRORS, ISSUES
ARCHIVE ALL ALERT LOGS TO HISTORY
VISIT HOME PAGES OF KEY VENDORS

Monthly Procedure: These are the procedures

LOOK FOR HARMFUL GROWTH RATES
REVIEW TUNING OPPORTUNITIES
LOOK FOR I/O CONTENTION
REVIEW FRAGMENTATION
PROJECT PERFORMANCE INTO THE FUTURE
PERFORM TUNING AND MAINTENANCE

Untitled

2011-11-29T17:39:00.001+05:30

Day to Day activities of Oracle Apps DBA:

A DBA has to do various activities, it can be listed down according to priority, frequency of that activity. It can be devided in bellow pattern.

Daily Activities: These are the activities a DBA needs to do daily.

VERIFY ALL INSTANCES ARE UP
LOOK FOR ANY NEW ALERT LOG ENTRIES
VERIFY DBSNMP IS RUNNING
VERIFY SUCCESS OF DATABASE BACKUP
VERIFY SUCCESS OF DATABASE ARCHIVING TO TAPE
VERIFY ENOUGH RESOURCES FOR ACCEPTABLE PERFORMANCE
READ DBA MANUALS FOR ONE HOUR

Weekly Activities: These are the activities a DBA needs to excersize weekly.

LOOK FOR OBJECTS THAT BREAK RULES
LOOK FOR SECURITY POLICY VIOLATIONS
LOOK IN SQL*NET LOGS FOR ERRORS, ISSUES
ARCHIVE ALL ALERT LOGS TO HISTORY
VISIT HOME PAGES OF KEY VENDORS

Monthly Procedure: These are the procedures

LOOK FOR HARMFUL GROWTH RATES
REVIEW TUNING OPPORTUNITIES
LOOK FOR I/O CONTENTION
REVIEW FRAGMENTATION
PROJECT PERFORMANCE INTO THE FUTURE
PERFORM TUNING AND MAINTENANCE

How to setup network printer in Oracle Apps R12

2011-11-29T14:20:00.001+05:30

How to do printer setup in Oracle Application R12.

It is mainly required for automatic printing of concurrent request output. For this setup you have to setup a network printer in the Oracle Application. For setting up the printer you have to do the following activities.

First you have to install the printer at os level.

- Download CUPS software
- Download the driver for your printer
- Add the printer

Once the instllation has been done you have ot check the printer from the command line that you are able to print a file.

This can be tested by the lp command.

lpstat -a
printer accepting requests since Fri 25 Nov 2011 05:34:15 PM IST

lpstat -t
scheduler is running
system default destination: printer
device for printer: lpd://192.168.1.26
printer accepting requests since Fri 25 Nov 2011 05:34:15 PM IST
printer printer is idle. enabled since Fri 25 Nov 2011 05:34:15 PM IST

Go to http://www.cups.org and download the latest software and install it into the os.

Download the printer driver rpm and install it there in the server.

Configure the printer at OS level. Once done test the printer using the lp command.

lp <filename>

Then go to command promt, and modify the pasta_pdf.cfg file according to the requirement.

cd $FND_TOP/resource

cp pasta_pdf.cfg pasta_pdf.cfg_orig

vi pasta_pdf.cfg

Existing one - old value

preprocess=pdftops {inline} {outline}

New one - New value for PDF printing

preprocess=pdf2ps {inline} {outline}

Navigation: System Administrator ==>> Install ==>> Printer

We need to Register the Printer with the same name which has been derived at the Linux BOX level,

If Driver is not already setup you have to setup the printer driver.

Navigation: System Administrator ==>> Install ==>> Printer ==>> Driver

In this we will be having four options where we can define a Custom Printer as well as Custom
Printer Drivers for Printer.
We need to register a Printer in the following Steps: Driver ==>> Styles ==>> Types ==>> Register
In order to make use of PDF Printing Directly from a Concurrent Program we need to have
PASTA_PDF Driver existing in the Oracle Applications.
Navigation: System Administrator ==>> Install ==>> Printer ==>> Driver
Driver Name : PASTA_PDF
User Driver : Pasta PDF Driver
Description : Pasta driver to print pdf converted to PostScript by 3rd party utility
Driver Method : Program
Driver Method Parameters : Spool File
Program Name : FNDPSTAX
Arguments: -pn$PROFILES$.PRINTER -f$PROFILES$.FILENAME – c$PROFILES$.CONC_COPIES -Fpasta_pdf.cfg

Defining and Assigning the Printer at Concurrent Program Level
Let us consider the Example of Defining a printer for Concurrent Program.
Usually we define Portrait or Landscape for the Style in the Concurrent Program at Output Tab.
Here we need to specific PDF Publisher as the Style in Concurrent Program and as well we have to mention the Name of the Printer which was registered in the Oracle Applications.

Run this program to get the output at Printer Tray
Select Options to select printer name and give number of copies as 1
Bounce the Concurrent Managers in case things didn’t work

Untitled

2011-11-28T15:15:00.001+05:30

Password reset scripts:

This is the procedure to reset the password of Oracle Apps user password. It is a PL/SQL Procedure. Password reset scripts is mainly used for resetting all the apps user password, it is mainly used after cloning the development or test instance from production instance.

declare

CURSOR cur_user_dtl IS

SELECT USER_ID, USER_NAME FROM fnd_user WHERE user_id >1000

ORDER BY creation_DATE DESC;

result boolean;

BEGIN

FOR c_user_dtl IN cur_user_dtl LOOP

result := fnd_user_pkg.changepassword(username => c_user_dtl.user_name,

newpassword => 'password123');

IF result THEN

NULL;

ELSE

dbms_output.put_line('The password of ' || c_user_dtl.user_name || ' has failed to reset.');

END IF;

END LOOP;

result := fnd_user_pkg.changepassword(username => 'SYSADMIN',

newpassword => 'welcome1');

end;

Welcome

2011-11-28T14:42:00.001+05:30

How to reset Oracle Apps User Password from Backend?

Oracle Apps User password can be resetted form the front end. But if in some case it is not possible to reset the password from the Oracle Apps GUI Screen.

It can be done by two ways,

FNDCPASS utility
Oracle Apps Procedure

1. FNDCPASS utility: It is a command line utility provided by Oracle Application to change the password.

(i) SYSTEM ,It is used to change APPS/APPLSYS password

FNDCPASS < logon > 0 Y < system/password> SYSTEM < username > < new_password>

(ii) USER , It is used to change oracle applications user like SYSADMIN

FNDCPASS < logon> 0 Y < system/password> USER < username> < new_password>

(iii) ORACLE, It is used to change the password of oracle schema like GL,AP

FNDCPASS apps/apps 0 Y system/manager ORACLE GL gl1

(iv) ALLORACLE , It is used to change all passwords of all schema.

FNDCPASS apps/apps 0 Y system/manager ALLORACLE welcome

2. Oracle Apps Procedure

You can use the bellow procedure to reset any Oracle Application user password like SYSADMIN

declare

result boolean;

begin

result := fnd_user_pkg.changepassword(username => :username, newpassword => :newpassword);

end;

How to Install Oracle Database Software and Create a New Database

2011-10-26T12:48:00.000+05:30

How to Install Oracle Database Software and Create a New Database

For installing Oracle Database Software, you have to take the help of Oracle Universal Installer or OUI. It is graphical tool to install and maintain oracle products installed or to be installed. But before installing Oracle Database software you should fulfill the following requirement.
1. You have to fullfill minimum physical memory requirement. This is 512 MB for Microsoft Windows or Linux and 1024 MB or 1 GB for UNIX or other Operating Systems.
2. You should have enough paging space.
3. Your operation system should be updated to the required Service Pack Level or Kernel version level.
4. You should follow the required file format for the Oracle Database as per Oracle Guidelines.

Whenever you are going to install oracle database software, you have to decide which type of Oracle Database Software Installation you want. The list is like bellow,
• Enterprise Edition: It is the installation, where you will get the Oracle Database Product with full features, which is required for the data management at enterprise level.
• Standard Edition: It is the installation, where you will get the Oracle Database Product to provide support to a medium size organization. It will provide all the basic database services.
• Personal Edition: This type of installation is available only in Microsoft windows. It is same with the Enterprise Edition in case of Features but the limitation is single user option, which is mainly taken for development and deployment scenario.
• Custom Install: Here the features are customized from the enterprise edition according to the requirement of the USER.

At the time of installation you can pick the advance installation option. If you pick this option you will be asked some question, which will guide you for the completion of the installation.
 Install Sample Schema?
 What type of storage mechanism do you want your database to use?( File System/Automatic Storage Management/ Raw Devices)
 What are your database management options?
Steps to Install Oracle Database Software
For being Oracle Database basic installation you have to follow the bellow steps.
1. For doing the installation you have to logon as the administrator user. That means that the user should have the authority to install oracle database software, create and run the database.
2. If you are installing from a media, click or run the Oracle Universal Installer (OUI).
3. Then you have to select the Product, In this case Oracle Database 11g. Then Click Next.
4. Select Basic Installation type. You have to give the following input, Oracle Home, Oracle Base Location, Installation Type, UNIX DBA Group, Create Starter Database.
5. If you are doing first time installation, then specify a location which will be Oracle Inventory location. And it is different from ORACLE_HOME
6. It is for UNIX and Linux only; OUI will perform some environment checks and give a success or failure status.
7. In case of windows click next if all the Product-Specific Prerequisite check status succeeded. In case of failure take corrective actions.
8. Click next in the Oracle Configuration Manager Registration window.
9. Start the Install button, after reviewing the summary given in the screen.
10. An optional step is there as in Password Management you can unlock the required user accounts.
11. Click OK to continue installation.
12. At the end of the installation exit the OUI confirming YES.

How to use DBCA to create a Database and manage it?
Coming in Next post.

manually undeploy the application if you are not able to do so from dcm

2011-02-19T11:48:00.000+05:30

At the time of undeploying an application in Oracle Application Server 10.1.2 it is fiving the following error

Error

An error occured while undeploying the application. Base Exception:

No ApplicationInfo is associated with application named: Sth

Resolution:

You have to manually undeploy the application if you are not able to do so from dcm.

1. Shut down the HTTP server of the OAS

2. Shut down all the OC4J instances in the OAS

-bash-3.2$ cd /u01/10G_AS/Midd/

-bash-3.2$ ./opmn/bin/opmnctl status

Processes in Instance: midd.tcs186246.tcskolkata.co.in

-------------------+--------------------+---------+---------

ias-component
process-type
pid
status

-------------------+--------------------+---------+---------

DSA
DSA
N/A
Down

LogLoader
logloaderd
N/A
Down

dcm-daemon
dcm-daemon
17680
Alive

OC4J
home
17521
Alive

OC4J
OC4J_Portal
N/A
Down

WebCache
WebCache
17488
Alive

WebCache
WebCacheAdmin
17477
Alive

HTTP_Server
HTTP_Server
17479
Alive

-bash-3.2$ ./opmn/bin/opmnctl stopall

opmnctl: stopping opmn and all managed processes...

3. Run dcmctl getState -v -d and check if you are in synch or not

-bash-3.2$ ./dcm/bin/dcmctl getState -v -d

Current State for Instance:midd.tcs186246.tcskolkata.co.in

Component Type Up Status In Sync Status

================================================================================

1 HTTP_Server HTTP_Server Down True

2 OC4J_Portal OC4J Down True

3 home OC4J Down True

4. Goto the following path

-bash-3.2$ cd ./j2ee/OC4J_Portal/config

5. Take the Backup of server.xml and default-web-site.xml file.

-bash-3.2$ cp server.xml server.xml_bkp

-bash-3.2$ cp default-web-site.xml default-web-site.xml_bkp

6. Edit both files to delete the entries respective to the application, which you want to delete.

-bash-3.2$ vi server.xml

-bash-3.2$ vi default-web-site.xml

-bash-3.2$ vi server.xml

7. Go to the following directory and remove the ear and the directories of the specified applications.

-bash-3.2$ cd ../applications

-bash-3.2$ ls -lrt

total 17864

drwxrwx--- 4 oracletrg dba 4096 Feb 1 12:59 portalHelp2

-rw-rw---- 1 oracletrg dba 2687627 Feb 1 12:59 jpdk.ear

drwxrwx--- 5 oracletrg dba 4096 Feb 1 12:59 jpdk

drwxrwx--- 7 oracletrg dba 4096 Feb 1 12:59 UltrasearchQuery

drwxrwx--- 6 oracletrg dba 4096 Feb 1 12:59 UltrasearchAdmin

drwxrwx--- 4 oracletrg dba 4096 Feb 1 12:59 orauddi

drwxrwx--- 4 oracletrg dba 4096 Feb 1 12:59 portalHelp

drwxrwx--- 4 oracletrg dba 4096 Feb 1 12:59 UltrasearchPortlet

drwxrwx--- 8 oracletrg dba 4096 Feb 1 12:59 portalTools

drwxrwx--- 4 oracletrg dba 4096 Feb 1 12:59 portal

drwxrwx--- 5 oracletrg dba 4096 Feb 1 12:59 oraudrepl

-rw-r--r-- 1 oracletrg dba 5441117 Feb 11 18:15 SimpleStruts2.ear

drwxr-xr-x 4 oracletrg dba 4096 Feb 11 18:15 SimpleStruts2

-rw-r--r-- 1 oracletrg dba 10075940 Feb 14 10:58 Sth.ear

drwxr-xr-x 4 oracletrg dba 4096 Feb 14 10:58 Sth

-bash-3.2$ rm -rf SimpleStruts2.ear SimpleStruts2 Sth.ear Sth

8. Go to the following directory and remove the directories of the specified applications.

-bash-3.2$ cd ../application-deployments/

-bash-3.2$ ls -lrt

total 52

drwxrwx--- 4 oracletrg dba 4096 Feb 1 12:58 default

drwxrwx--- 6 oracletrg dba 4096 Feb 1 12:59 oraudrepl

drwxrwx--- 4 oracletrg dba 4096 Feb 1 12:59 orauddi

drwxrwx--- 5 oracletrg dba 4096 Feb 10 15:28 UltrasearchQuery

drwxrwx--- 4 oracletrg dba 4096 Feb 10 15:28 UltrasearchPortlet

drwxrwx--- 6 oracletrg dba 4096 Feb 10 15:28 UltrasearchAdmin

drwxrwx--- 8 oracletrg dba 4096 Feb 10 15:28 portalTools

drwxrwx--- 4 oracletrg dba 4096 Feb 10 15:28 portalHelp2

drwxrwx--- 4 oracletrg dba 4096 Feb 10 15:28 portalHelp

drwxrwx--- 4 oracletrg dba 4096 Feb 10 15:28 portal

drwxrwx--- 5 oracletrg dba 4096 Feb 10 15:28 jpdk

drwxr-xr-x 4 oracletrg dba 4096 Feb 11 18:15 SimpleStruts2

drwxr-xr-x 4 oracletrg dba 4096 Feb 14 10:58 Sth

-bash-3.2$ rm -rf SimpleStruts2 Sth

9. Go to $ORACLE_HOME(MID)/Apache/Apache/conf/

-bash-3.2$ cd ../../../Apache/Apache/conf/

10. Take a backup of mod_oc4j.conf file.

-bash-3.2$ cp mod_oc4j.conf mod_oc4j.conf_bkp

11. Edit the mod_oc4j.conf file to remove the entries regarding the applications.

-bash-3.2$ vi mod_oc4j.conf

12. Goto $ORACLE_HOME(MID)/dcm/bin/ and update the configuration

-bash-3.2$ cd dcm/bin/

-bash-3.2$ ./dcmctl updateConfig -v -d

13. Start the opmnctl

-bash-3.2$ ./../../opmn/bin/opmnctl startall

opmnctl: starting opmn and all managed processes...

14. Check the status of the opmnctl

-bash-3.2$ ./../../opmn/bin/opmnctl status

Processes in Instance: midd.tcs186246.tcskolkata.co.in

-------------------+--------------------+---------+---------
ias-component process-type         pid          status
-------------------+--------------------+---------+---------
DSA              DSA                        N/A       Down
LogLoader     LogLoader              N/A       Down
dcm-daemon dcm-daemon            14784   Alive
OC4J            home                        15646   Alive
OC4J            OC4J_Portal            15645   Alive
WebCache    WebCache               15618   Alive
WebCache    WebCacheAdmin     15607   Alive
HTTP_Server HTTP_Server          15609 Alive

On Sun Fire 3800/4800/4810/6800, V1280, and Netra 1280 Domains, Time of Day (TOD) May Drift or Jump

2010-08-19T15:30:00.001+05:30

Product
Sun Fire 3800 Server
Sun Fire 4800 Server
Sun Fire 4810 Server
Sun Fire 6800 Server
Sun Fire V1280 Server
Netra 1280 Server

Bug Id
SUNBUG: 4876369

Date of Workaround Release
10-SEP-2003

Date of Resolved Release
04-NOV-2003

Impact

On very rare occasions, the Time of Day (TOD) on Sun Fire 3800/4800/4810/6800, V1280, and Netra 1280 domains may be susceptible to a clock drift or jump. As a result, any functionality that relies upon the System Controller (SC) timer may be inaccurate.

Contributing Factors

This issue can occur in the following releases:

SPARC Platform

* Sun Fire V1280 and Netra 1280 with firmware (ScApp) 5.13.0014 or earlier
* Sun Fire 3800/4800/4810/6800 with firmware (ScApp) 5.12.x
* Sun Fire 3800/4800/4810/6800 with firmware (ScApp) 5.13.x
* Sun Fire 3800/4800/4810/6800 with firmware (ScApp) 5.14.x
* Sun Fire 3800/4800/4810/6800 with firmware (ScApp) 5.15.0, 5.15.1 and 5.15.2

Note: Systems with firmware 5.11.x are not affected by this issue. Use the "showsc -v" command to display the firmware version of the SC.

Symptoms

This issue may occur after 528 days of SC continuous uptime, where the TOD within a domain in the system may become random and unstable. The intervals reported have varied, but the behavior is generally that the TOD jumps backwards approximately one hour up to as much as one month. The TOD as seen by the SC itself does not jump.

There are no specific messages that would indicate this issue has occurred. It can only be discovered by the domain exhibiting unexpected behavior due to the domain TOD changing unexpectedly.

Resolution

This issue is addressed in the following releases:

* Sun Fire V1280 and Netra 1280 with firmware (ScApp) 5.13.0015 (as delivered in patch 113751-05 or later)
* Sun Fire 3800/4800/4810/6800 with firmware (ScApp) 5.15.3 (as delivered in patch 112884-04 or later)

Note: The patch must be added to both system controllers to remedy this issue.

Discoverer Startup Fails on Solaris

2010-08-19T15:20:00.001+05:30

Discoverer Startup Fails on Solaris

When running the addischtl.sh start script, you see the following message:

Registering Discoverer Preference Repository oadutil.reg:Failed to bind to OAD
Workaround

Set the TMPDIR environment variable to the Oracle home directory of the release 8.0.6 visibroker directory. The following is an example of commands required to make this change:

% TMPDIR=/mount_point/product/8.0.6/vbroker
% export TMPDIR

ADSSTATS.SQL fails while applying R12.1.1 NLS Upgrade Patch 6678700

2010-08-18T21:08:00.002+05:30

When attempting to Apply Patch 6678700,
the following error occurs.
ERROR
-----------------------
sqlplus -s APPS/***** AD_TOP\12.0.0\patch\115\sql\adsstats.sql



Error:

Program exited with status 1



Cause: The program terminated, returning status code 1.



Action: Check your installation manual for the meaning of this code on this operating system.declare

*

ERROR at line 1:

ORA-20000: ORA-20001: invalid column name or duplicate columns/column

groups/expressions in method_opt Error while executing

FND_STATS.GATHER_SCHEMA_STATISTICS package.

ORA-06512: at line 91



ERROR: While running adsstats.sql : 

object_name=FII.FII_FIN_ITEM_HIERARCHIES***ORA-20001: invalid column name or duplicate columns/column 

groups/expressions in method_opt Error while executing

FND_STATS.GATHER_SCHEMA_STATISTICS package.

ORA-06512: at line 9

Solution

 Please apply the following solution:

1. Make sure to have a valid backup for FND_HISTOGRAM_COLS table.



2. Run the following to delete column 'PARENT_FLEX_VALUE' from FND_HISTOGRAM_COLS.



delete from FND_HISTOGRAM_COLS

where table_name = 'FII_FIN_ITEM_HIERARCHIES'

and column_name = 'PARENT_FLEX_VALUE'



3- Restart the failed worker.

FRM-92101: Forms Server Java Exception: oracle.forms.net.ConnectionException: Forms session failed during startup:

2010-08-18T20:12:00.000+05:30

After installing E-Business Suite R12, try to access system by Forms and the following error is displayed:

FRM-92101: Forms Server Java Exception: oracle.forms.net.ConnectionException: Forms session <1> failed during startup: no response from runtime process at oracle.forms.net.ConnectionException.createConnectionException(Unknown Source) at oracle.forms.net.HTTPNStream.getResponse(Unknown Source) at oracle.forms.net.HTTPNStream.doFlush(Unknown Source) at oracle.forms.net.HTTPNStream.flush(Unknown Source) at java.io.DataOutputStream.flush(Unknown Source) at oracle.forms.net.HTTPConnection.connect(Unknown Source) at oracle.forms.engine.FormsDispatcher.initConnection(Unknown Source) at oracle.forms.engine.FormsDispatcher.init(Unknown Source) at oracle.forms.engine.Runform.initConnection(Unknown Source) at oracle.forms.engine.Runform.startRunform(Unknown Source) at oracle.forms.engine.Main.createRunform(Unknown Source) at oracle.forms.engine.Main.start(Unknown Source) at sun.applet.AppletPanel.run(Unknown Source) at java.lang.Thread.run(Unknown Source)
In $LOG_HOME/ora/10.1.3/j2ee//_/application.log next error is displayed:

yy/dd/mm 10.1.3.0.0 Started yy/dd/mm .773 formsweb: FormsServlet init(): configFileName: $ORACLE_HOME/forms/server/appsweb.cfg testMode: false yy/dd/mm .783 formsweb: 10.1.3.0.0 Started yy/dd/mm .288 formsweb: ListenerServlet init() yy/dd/mm .514 formsweb: Forms session <1> aborted: runtime process failed during startup with errors $ORACLE_HOME/bin/frmweb : error while loading shared libraries: libXm.so.2: cannot open shared object file: No such file or directory yy/dd/mm .514 formsweb: Forms session <1> exception stack trace: oracle.forms.engine.RunformException: Forms session <1> failed during startup: no response from runtime process at oracle.forms.servlet.RunformProcess.connect(Unknown Source) at oracle.forms.servlet.RunformProcess.dataToRunform(Unknown Source) at oracle.forms.servlet.RunformSession.dataToRunform(Unknown Source) at oracle.forms.servlet.ListenerServlet.doPost(Unknown Source) at javax.servlet.http.HttpServlet.service(HttpServlet.java:763) at javax.servlet.http.HttpServlet.service(HttpServlet.java:856) at com.evermind[Oracle Containers for J2EE 10g (10.1.3.0.0) ].server.http. ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:702) at com.evermind[Oracle Containers for J2EE 10g (10.1.3.0.0) ].server.http. ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:359) at com.evermind[Oracle Containers for J2EE 10g (10.1.3.0.0) ].server.http. HttpRequestHandler.doProcessRequest(HttpRequestHandler.java:870) at com.evermind[Oracle Containers for J2EE 10g (10.1.3.0.0) ].server.http. HttpRequestHandler.processRequest(HttpRequestHandler.java:451) at com.evermind[Oracle Containers for J2EE 10g (10.1.3.0.0) ].server.http. AJPRequestHandler.run(AJPRequestHandler.java:299) at com.evermind[Oracle Containers for J2EE 10g (10.1.3.0.0) ].server.http. AJPRequestHandler.run(AJPRequestHandler.java:187) at oracle.oc4j.network.ServerSocketReadHandler$SafeRunnable. run(ServerSocketReadHandler.java:260) at com.evermind[Oracle Containers for J2EE 10g (10.1.3.0.0) ].util. ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor. java:303) at java.lang.Thread.run(Thread.java:595) yy/dd/mm .214 formsweb: Forms session <2> aborted: runtime process failed during startup with errors $ORACLE_HOME/bin/frmweb: error while loading shared libraries: libXm.so.2: cannot open shared object file: No such file or directory

In formsstd.out next error is displayed:

$ORACLE_HOME/bin/frmweb: error while loading shared 

libraries: libXm.so.2: cannot open shared object file: No such file or directory

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



1. Install package openmotif rpm.

For example, for Oracle Enterprise Linux 5 or Red Hat Enterprise Linux 5 the missing package is: 

openmotif21-2.1.30-11.EL5.i386.rpm. 
2. Bounce the services.

3. Retest.

References
NOTE:402310.1 - Oracle Applications Installation and Upgrade Notes Release 12 (12.0.4) for Linux (32-bit)

IE 8 is Supported for the following cases in R12

2010-08-18T19:49:00.000+05:30

The Cases are given bellow:
E-Business Suite Release 12.0 Prerequisites

Oracle Applications Technology R12.ATG_PF.A.DELTA.6 (patch 7237006) or later
Oracle Forms Version 10.1.2.3 or later
Desktop client running Microsoft IE 8 on:

Windows XP Service Pack 2 or 3

Windows Vista Service Pack 1 or 2

E-Business Suite Release 12.1 Prerequisites

Oracle E-Business Suite 12.1.1
Desktop client running Microsoft IE 8 on:

Windows XP Service Pack 2 or 3

Windows Vista Service Pack 1 or 2

R12 Performance issue when clicking 'Monitor Request' after Submitting Concurrent Requests

2010-08-18T19:43:00.000+05:30

In R12, when clicking on the 'Monitor requests' button after submitting a request, It is taking longer time for this screen to open. This performance issue can be reproduced when invoking the standard concurrent request submission (or) View request page from Oracle Application Framework (OAF) from various modules like Quoting, Report Manager, etc.

Solution

To implement the solution, please execute the following steps:

1. Download and review the readme and pre-requisites for Patch 9747291
2. Ensure that you have taken a backup and Apply the patch in a test environment. .
3. Confirm the following file versions

RequestSummarySearchVO.xml 120.14.12010000.3

You can use the commands like the following:

strings -a $JAVA_TOP/oracle/apps/fnd/cp/viewreq/server/RequestSummarySearchVO.xml | grep Header

4. Retest the issue.
5. Migrate the solution as appropriate to other environments.

After Cloning Some files and symbolic links still contain references to the source system

2010-08-18T19:34:00.002+05:30

After Cloning Some files and symbolic links still contain references to the source system

$ORACLE_HOME/bin/qxmlctl
$ORACLE_HOME/bin/clscfg
$ORACLE_HOME/bin/clsfmt
$ORACLE_HOME/bin/dbca
$ORACLE_HOME/bin/dbua
$ORACLE_HOME/bin/dropjava
$ORACLE_HOME/bin/emagentdeploy.pl
$ORACLE_HOME/bin/emtgtctl
$ORACLE_HOME/bin/emutil
$ORACLE_HOME/bin/emca
$ORACLE_HOME/bin/emutil
$ORACLE_HOME/bin/netca
$ORACLE_HOME/lib32/ldflags
$ORACLE_HOME/lib/hsdb_inf.so -> /lib32/hsdb_inf.so
$ORACLE_HOME/lib/hsdb_odbc.so -> /lib32/hsdb_odbc.so
$ORACLE_HOME/lib/hsdb_oing.so -> /lib32/hsdb_oing.so
$ORACLE_HOME/lib/hsdb_ora.so -> /lib32/hsdb_ora.so
$ORACLE_HOME/lib/hsdb_syb.so -> /lib32/hsdb_syb.so

Cause
This can be caused by a failure with the OUI native clone process. If an ORACLE_HOME is already registered in the Global inventory, whether the purpose is to refresh an existing Target instance, or the original instance was removed from the file system (but not from the inventory), then OUI native cloning will assume the instance is already registered and no further configuration is required. This will result in an incomplete target system with files and links still referencing the source instance. This can also occur for any failure of runInstaller during cloning.

Any problems with ouicli.pl will be detailed in the log files :

/appsutil/log/$CONTEXT_NAME/ohclone.log

$INST_TOP/admin/log/ohclone.log

/logs/cloneActions.log

/logs/oraInstall.log

/logs/silentInstall.log

The following extract from ohclone.log shows a typical example of this problem:-

SEVERE: OUI-10197:Unable to create a new Oracle Home at .
Oracle Home already exists at this location. Select another location.
INFO: User Selected: Yes/OK
    
java.io.IOException: OUI-10197:Unable to create a new Oracle Home at
. Oracle Home already exists at this location. Select another
location.

Possible solutions to this are to rerun the native OUI cloning :

Solution 1 :
Use this if the Global Inventory is shared amongst multiple instances :

- Run OUI and "De-install" the unwanted ORACLE_HOME
- Recopy the files from Source system
- Reconfigure the Target system using the "perl adcfgclone.pl" scripts.

Solution 2 :
Use this if the Global Inventory is local to this ORACLE_HOME, i.e oraInst.loc "inventory_loc" points to :

inventory_loc=/admin/oui/$CONTEXT_NAME/oraInventory

or (for the Applications Tier)

inventory_loc=/admin/oraInventory

Rename the global inventory :

cd RDBMS $ORACLE_HOME>/admin/oui/$CONTEXT_NAME
mv oraInventory oraInventory.bkp

or (for the Applications Tier)

cd /admin
mv oraInventory oraInventory.bkp

Create an empty directory and set permissions :

mkdir oraInventory
chmod 777 oraInventory

Rerun the ouicli.pl scripts to register the ORACLE_HOME (repeat for all RDBMS, Tools and Web each if required) :

cd ORACLE_HOME/appsutil/clone/
./ouicli.pl

Check the log files as listed above

Database Tier clone fails with adlnkoh.sh on 64bit machines

2010-08-18T19:32:00.002+05:30

Database Tier clone fails with adlnkoh.sh on 64bit machines

When attempting to clone 'perl adcfgclone.pl dbtier' fails on db tier, adlnkoh.sh fails with the following error:

ERROR Failed linking target libnmarl on ... <$ORACLE_HOME>/sysman/lib cc -o <$ORACLE_HOME>/sysman/lib/emagent -L<$ORACLE_HOME>/lib32/ -L<$ORACLE_HOME>/sysman/lib32/ -L<$ORACLE_HOME>/lib32/stubs/ `cat <$ORACLE_HOME>/lib32/sysliblist` -lm `cat <$ORACLE_HOME>/lib32/sysliblist` -lm -lpthread -lrt -lpthread -Wl,-E +DD64 <$ORACLE_HOME>/sysman/lib32/s0nmem.o -lclntsh -L<$ORACLE_HOME>/lib32 -L<$ORACLE_HOME>/sysman/lib32/ -lnmemso -lcore11 -L/app/oracle/EBSCRP2A/db/tech_st/11.1.0/jdk/jre/lib/IA64W/hotspot -L/app/oracle/EBSCRP2A/db/tech_st/11.1.0/jdk/jre/lib/IA64W -ljava -ljvm -lverify `cat <$ORACLE_HOME>/lib32/sysliblist` -lm -lpthread -lrt -lpthread -lnsl -lm `cat <$ORACLE_HOME>/lib32/sysliblist` `cat <$ORACLE_HOME>/lib32/sysliblist` -lm -lpthread -lrt cat: Cannot open <$ORACLE_HOME>/lib32/sysliblist: No such file or directory cat: Cannot open <$ORACLE_HOME>/lib32/sysliblist: No such file or directory cat: Cannot open <$ORACLE_HOME>/lib32/sysliblist: No such file or directory cat: Cannot open <$ORACLE_HOME>/lib32/sysliblist: No such file or directory cat: Cannot open <$ORACLE_HOME>/lib32/sysliblist: No such file or directory (Bundled) cc: warning 1913: `<$ORACLE_HOME>/sysman/lib32/s0nmem.o' does not exist or cannot be read ld: Can't find library for -lclntsh Fatal error

CauseThe problem is linked to Note:471476.1 32 Bit Libraries Are Not Installed With Oracle11g (11.1.0.6)
For RapidClone, this was raised in Bug 7602049

Solution
Apply Patch:7207440 TXK - 12.0.4 Consolidated Patch 1 to the Source instance and redo the cloning steps.
This patch is already included in 12.0.6

sql to get the current JDBC driver version in the system

2010-08-18T19:18:00.000+05:30

For application version 11.5.10 onwards ensure ATG_PF.H is applied onto the instance. Also ensure that you are using the latest version of the JDBC driver. You may run the following sql to get the current JDBC driver version in the system :

select bug_number, decode(bug_number, 

         '3043762','JDBC drivers 8.1.7.3', 

         '2969248','JDBC drivers 9.2.0.2', 

         '3080729','JDBC drivers 9.2.0.4 (OCT-2003)', 

         '3423613','JDBC drivers 9.2.0.4 (MAR-2004)', 

         '3585217','JDBC drivers 9.2.0.4 (MAY-2004)', 

         '3882116','JDBC drivers 9.2.0.5 (OCT-2004)', 

         '3966003','JDBC drivers 9.2.0.5 (OCT-2004)', 

         '3981178','JDBC drivers 9.2.0.5 (NOV-2004)', 

         '4090504','JDBC drivers 9.2.0.5 (JAN-2005)', 

         '4201222','JDBC drivers 9.2.0.6 (MAY-2005)') Patch_description 

    from ad_bugs 

    where bug_number in 

         ( 

         '3043762', 

         '2969248', 

         '3080729', 

         '3423613', 

         '3585217', 

         '3882116', 

         '3966003', 

         '3981178', 

         '4090504', 

         '4201222' 

         ) 

    order by 2;

Killing the blocking session

2010-08-18T19:15:00.000+05:30

Killing the blocking session
===============================

Normally, you should use the KILL USER SESSION menu found in TopSessions.
You can also issue an ALTER SESSION KILL SESSION sid, serial#; in an sqlplus
session.

When on unix or vms,you can kill the unix/vms shadow process directly. Is is not recommended.
When killing the shadow process, please be careful of shared servers in a multi-threaded environment.
e.g.
kill -9 6246   (shadow process on unix)
stop/id= (PROC SPID=SESS SPID on vms running single task) 

To find process information, one can execute this query:

column "ORACLE USER" format a11
column SERIAL# format 9999999
column "OS USER" format a8

    select distinct substr(s.username,1,11) "ORACLE USER", p.pid "PROCESS ID",
       s.sid "SESSION ID", s.serial#, osuser "OS USER", p.spid "PROC SPID",
       s.process "SESS SPID", s.lockwait "LOCK WAIT"
    from v$process p, v$session s, v$access a
    where a.sid=s.sid and
       p.addr=s.paddr and
       s.username != 'SYS'
       and a.sid in (select l.sid from v$lock l
                      where (id1,id2) in
                            (select b.id1, b.id2 from v$lock b where b.id1=l.id1 and
                             b.id2=l.id2 and b.request>0));

ORACLE USER PROCESS ID SESSION ID  SERIAL# OS USER  PROC SPID SESS SPID LOCK WAI
----------- ---------- ---------- -------- -------- --------- --------- --------
SCOTT               17         11     3313 oracle8i 6247      6246      801113A4
SCOTT               20         19     3611 oracle8i 6258      6257

FRM-92050: Failed to connect to the server: /forms/formservlet: -1

2010-08-17T14:42:00.000+05:30

Internet Explorer 8 (IE8)

Multiple Sessions

Previous releases of Internet Explorer have allowed users to logon to the same Oracle E-Business Suite environment concurrently from the same desktop by launching each application session through a new browser session.
By default the ‘Session Merging’ feature within IE8 prevents this functionality from working correctly. This IE8 functionality causes the same session id to be used when accessing the same Oracle E-Business Suite environment despite opening a new browser window to launch a second session.
This can result in unusual behavior with invalid sessions causing errors such as “Your login session has become invalid" and failures to launch forms causing errors such as “FRM-92050: Failed to connect to the server: /forms/formservlet: -1"
To retain the use of multiple sessions to the same Oracle E-Business Suite environment with IE8, please use one of the workarounds below to ensure each browser session remains independent;

Open a new explorer window using its own session cookie by selecting 'File -> New Session' from an existing browser window.
Run from the command line adding the -nomerge parameter i.e. Start -> Run -> iexplore -nomerge
Create a new IE8 icon adding the -nomerge parameter i.e.
- Start -> Program Files
- Right click on the Internet Explorer icon and select Properties
- Add -nomerge to the end of the link in the Target field i.e.
  "C:\Program Files\Internet Explorer\iexplore.exe" -nomerge
- Click the OK button to close the window
- This icon may then be copied to the desktop if desired