Vikram Das

I found this from Migration FAQ of Classic Metalink available on
http://www.oracle.com/us/support/040368

How do I view the old Service Request number on my Service Request?
As part of Oracle's move to a single system for tracking SRs, SR numbers were changed.

You can view the Classic MetaLink SR number in the Legacy SR Number field in the SR views on My Oracle Support. To add the Legacy SR Number field to the Service Request list region click the table icon in the upper left hand corner of the list view. Select Columns > Legacy SR. You may sort on this field by clicking the column header.

We went live with Sun JRE plugin on our first instance in the weekend. As expected, we got lot of calls for issues. Here's a list:
1. Proxy issues: All our ERPs are configured with load balancers. However, whenever a JVM like Jinitiator / Sun JRE is used, the connection is always between the forms server port and the user's PC directly. This is blocked by proxies. Being an internal site, we have configured IE to exclude the internal site's name in exclusion list. We also configured Java Control Panel applet to connect directly instead of using Browser Settings.
2. Popup windows don't popup but appear minimized: Described in Metalink Note 864861.1:
CauseThis issue is caused by a new 'feature' in Java 1.6.0_10 and aboveMore details of the feature can be found at:http://www.java.com/en/download/help/new_plugin.xml?jre=6.0
SolutionTo implement the solution, please execute the following steps:Note - this is a client machine specific solution:1. Click Start.2. Click Control Panel.3. Double click on Java Control Panel.4. Click Advance tab in Java Control Panel.5. Scroll to Java Plug-in entry.6. Uncheck the check box for Enable next-generation Java Plug-in
3. JRE refuses to install : This was a weird one as nothing happened when we clicked on the Sun JRE executable downloaded to local disk. It turns out that the user's PC had issues and many other executables could not be installed as well. I have suggested to install this after booting Windows in Safe Mode.
Will update as I learn more.

Steve asked me this question today. Many months back Srinivas Reddy had asked me a similar question and I had found out about the existance of Oracle Applications Framework Developer's Guide. So I searched My Oracle Support for this and landed up with two metalink notes:
Note 269138.1 Oracle Applications Framework Developer's Guide 11.5.10 RUP5
Note 858398.1 Oracle Applications Framework Developer's Guide 11.5.10 RUP7
Unfortunately, I was unable to locate a version for RUP6.

10g has a new package called DBMS_MONITOR
EXECUTE DBMS_MONITOR.SESSION_TRACE_ENABLE(&sid,&serial,waits=>true, binds=>false);
To disableEXECUTE DBMS_MONITOR.SESSION_TRACE_DISABLE(&sid,&serial)

My old article on tracing

http://oracleappstechnology.blogspot.com/2007/07/activate-extended-sql-trace-for-given.html

We were informed by Oracle that Classic Metalink will retire this weekend and everyone has to start using the new metalink or My Oracle Support. They sneaked in Oracle SSO (OTN user id) integration sometime back. I set up the relationship between my metalink id and existing Oracle SSO (OTN id). During the weekend, we had some issues and I was not able to login with my Oracle SSO (OTN id). It gave this message:

Account setup is still in progress. Please come back later.

I tested with different browsers:

IE6 gives this error:

My Oracle Support Serivces Error

A server connection error occurred.

IO Error Error #2032

Please Try again later.

Firefox, Chrome and Opera give this error:
Account setup is still in progress. Please come back later.

After googling for sometime I found that the new site has an html interface which can be accessed through

http://supporthtml.oracle.com

I tried logging in through this and was successful.

I called Oracle Support and they have logged in an SR on my behalf for this issue. They told me that it is a known issue and a lot of users are facing this. They will inform me via email, when this gets resolved.

In Solaris 10, lsof version 4.7 and lower gives incorrect results. To get correct results from lsof you must install lsof version 4.8 or higher.

First download lsof version 4.8 from sunfreeware
ftp://ftp.sunfreeware.com/pub/freeware/sparc/10/lsof_1106-4.80-sol10-sparc-local.gz

Login as root

Remove the existing lsof version which is lower than 4.8

# pkgrm SMClsof

# pkgadd -d lsof_1106-4.80-sol10-sparc-local

The following packages are available:
1 SMClsof lsof
(sparc) 4.80

Select package(s) you wish to process (or 'all' to process
all packages). (default: all) [?,??,q]: all

Processing package instance from

lsof(sparc) 4.80
Vic Abell
Using as the package base directory.
## Processing package information.
## Processing system information.
3 package pathnames are already properly installed.
## Verifying disk space requirements.
## Checking for conflicts with packages already installed.

The following files are already installed on the system and are being
used by another package:
/usr/local/doc
/usr/local/man
/usr/local/man/man8

Do you want to install these conflicting files [y,n,?,q] y
## Checking for setuid/setgid programs.

The following files are being installed with setuid and/or setgid
permissions:
/usr/local/bin/lsof
/usr/local/bin/sparcv7/lsof
/usr/local/bin/sparcv9/lsof

Do you want to install these as setuid/setgid files [y,n,?,q] y

Installing lsof as

## Installing part 1 of 1.
/usr/local/bin/lsof
/usr/local/bin/sparcv7/lsof
/usr/local/bin/sparcv9/lsof
/usr/local/doc/lsof/00.README.FIRST
/usr/local/doc/lsof/00CREDITS
/usr/local/doc/lsof/00DCACHE
/usr/local/doc/lsof/00DIALECTS
/usr/local/doc/lsof/00DIST
/usr/local/doc/lsof/00FAQ
/usr/local/doc/lsof/00LSOF-L
/usr/local/doc/lsof/00MANIFEST
/usr/local/doc/lsof/00PORTING
/usr/local/doc/lsof/00QUICKSTART
/usr/local/doc/lsof/00README
/usr/local/doc/lsof/00TEST
/usr/local/doc/lsof/00XCONFIG
/usr/local/doc/lsof/lsof.man
/usr/local/man/man8/lsof.8
[ verifying class ]

Installation of was successful.
# lsof -v
lsof version information:
revision: 4.80
latest revision: ftp://lsof.itap.purdue.edu/pub/tools/unix/lsof/
latest FAQ: ftp://lsof.itap.purdue.edu/pub/tools/unix/lsof/FAQ
latest man page: ftp://lsof.itap.purdue.edu/pub/tools/unix/lsof/lsof_man
configuration info: 64 bit kernel
constructed: Thu Jul 10 20:12:17 EDT 2008
constructed by and on: steve@v480
compiler: gcc
compiler version: 3.4.3 (csl-sol210-3_4-branch+sol_rpath)
compiler flags: -Dsolaris=100000 -DHASPR_GWINDOWS -m64 -DHASIPv6 -DHASSOUXSOUA -DHAS_IPCLASSIFIER_H -DHAS_CRED_IMPL_H -DHAS_V_PATH -DHASZONES -DHAS_ZFS=1 -DHASUTMPX -DHAS_VSOCK -DHAS_STRFTIME -DLSOF_VSTR="5.10" -O
loader flags: -L./lib -llsof -lkvm -lelf -lsocket -lnsl
system info: SunOS v480 5.10 Generic_118833-33 sun4u sparc SUNW,Sun-Fire-480R Solaris
Anyone can list all files.
/dev warnings are enabled.
Kernel ID check is enabled.
WARNING: privately defined ZFS structures may be incorrect.
Device cache file read-only paths:
Named via -D: none
Named in environment variable LSOFDEVCACHE: none
Personal path format (HASPERSDC): "%h/%p.lsof_%L"
Modified personal path environment variable: LSOFPERSDCPATH
LSOFPERSDCPATH value: none
Personal path: /.lsof_server1000
Device cache file write paths:
Named via -D: none
Named in environment variable LSOFDEVCACHE: none
Personal path format (HASPERSDC): "%h/%p.lsof_%L"
Modified personal path environment variable: LSOFPERSDCPATH
LSOFPERSDCPATH value: none
Personal path: /.lsof_server1000

Today, Bimal pinged me about a performance issue with Configurator in Order Entry. He told me that the page CZInitialize.jsp was taking 7 minutes to appear. In a different instance on the same server it was taking 30 seconds. I asked him whether he had collected statistics for ONT. He said he had collected for ONT and APPLSYS.
I searched in Metalink with keywords Configurator performance Order Entry and came across Note 130511.1 which gives this suggestion:
The first step in troubleshooting performance problems is to ensure that the customer has recently gathered statistics and that it was done correctly. The following schemas may impact performance in the OM product suite: ONT, WSH, QP, INV, AK, MRP, HZ, CZ, APPLSYS.
I told Bimal about this and he executed the following commands:
exec fnd_stats.gather_schema_statistics('ONT') ;exec fnd_stats.gather_schema_statistics('WSH') ;exec fnd_stats.gather_schema_statistics('QP') ;exec fnd_stats.gather_schema_statistics('INV') ;exec fnd_stats.gather_schema_statistics('AK') ;exec fnd_stats.gather_schema_statistics('MRP') ;exec fnd_stats.gather_schema_statistics('HZ') ;exec fnd_stats.gather_schema_statistics('CZ') ;exec fnd_stats.gather_schema_statistics('APPLSYS') ;
The issue was resolved immediately. Always check for statistics as a cause for performance problems in a CBO world.

I have finally found how to find the no. of cores in a Solaris Box on newer T class servers. The clue was given on Steve Sistare's blog post CPU to Core Mapping. He mentioned that:
"psrinfo -pv" only prints the core information on systems running OpenSolaris or Solaris Express, because psrinfo was enhanced by this CR:
6316187 Need interface to determine core sharing by CPUswhich was never backported to a Solaris 10 update.
So I googled for psrinfo opensolaris and found this perl script.
Here's the ouptut of running this perl script on a T5220 server:
$ perl psrinfo.pl -pvThe physical processor has 4 cores and 13 virtual processors (-50) The core has 4 virtual processors (0-3) The core has 3 virtual processors (16-18) The core has 3 virtual processors (32-34) The core has 3 virtual processors (48-50) UltraSPARC-T2 (clock 1415 MHz)

Akhilesh asked me this question today. A metalink search revealed note 731257.1 which has the details. In short before issuing the get command you are required to issue the command site protected .

In fact if you directly issue the get command you get the error message which says the same:

ftp> bin
g200 TYPE changed to I.
ftp> et p8995444_11i_d.zip
200 PORT command OK.
550-File or directory not found.
550-This is a password protected patch.
550-Enter the password with site command:
550-quote site protected
550 Then get the patch again.

After issuing the site protected command it worked

ftp> site protected V5pIHQqk
200 The password was received successfully.
ftp> get p8995444_11i_d.zip
200 PORT command OK.
150 Opening BINARY mode data connection for file p8995444_11i_d.zip.

It worked with quote site protected command also:

ftp> quote site protected V5pIHQqk
200 The password was received successfully.
ftp> get p8995444_11i_d.zip
200 PORT command OK.
150 Opening BINARY mode data connection for file p8995444_11i_d.zip.

This is of limited use now as Oracle is decomissioning their ftp service and you'll need to use wget and URL from the patch download button in new metalink.

After R12.1.1 install, Apache wouldn't start and we had these errors in the log

libopmnoraclenls.so unable to load

One of the metalink notes advised running genclntsh on IAS_ORACLE_HOME.

$ ./genclntsh -32
cat: cannot open $IAS_ORACLE_HOME/lib32/ldflags
Undefined first referenced
symbol in file
nnfhboot $IAS_ORACLE_HOME/lib32/libn10.a(nnfgt.o)
nnflboot $IAS_ORACLE_HOME/lib32/libn10.a(nnfgt.o)
nnflgapc $IAS_ORACLE_HOME/lib32/libnl10.a(nlpa.o)
nnftboot $IAS_ORACLE_HOME/lib32/libn10.a(nnfgt.o)
nnflgav $IAS_ORACLE_HOME/lib32/libnl10.a(nlol.o)
nnflfrm $IAS_ORACLE_HOME/lib32/libnl10.a(nlol.o)
nnflrne $IAS_ORACLE_HOME/lib32/libnl10.a(nlol.o)
ntusini $IAS_ORACLE_HOME/lib32/libn10.a(ntcontab.o)
ntpini $IAS_ORACLE_HOME/lib32/libn10.a(ntcontab.o)
nttini $IAS_ORACLE_HOME/lib32/libn10.a(ntcontab.o)
ntzini $IAS_ORACLE_HOME/lib32/libn10.a(ntcontab.o)
ld: fatal: Symbol referencing errors. No output written to $IAS_ORACLE_HOME/lib32/libclntsh.so.10.1


We went through release notes for 12.1.1 present in Metalink note 798258.1 again and
unzipped the Rapidwiz patch 8626041 in stage and reinstalled, but we still faced the same issue.

One of the metalink notes mentioned recreating softlinks, so I checked the soft links and found that Oracle stage had hardcoded softlinks pointing to a mount name /d4/R12/ab/apps/R1211XB9 most probably on Oracle's test servers.

$ ls -ltr |grep d4
lrwxrwxrwx 1 applmgr dba 56 Sep 29 16:58 ldflags -> /d4/R12/ab/apps /R1211XB9/apps/tech_st/10.1.3/lib/ldflags
lrwxrwxrwx 1 applmgr dba 66 Sep 29 16:59 libocci.so -> /d4/R12/ab/a pps/R1211XB9/apps/tech_st/10.1.3/lib32/libocci.so.10.1


$ ls -ltr |grep d4
lrwxrwxrwx 1 applmgr dba 63 Sep 29 16:58 hsdb_odbc.so -> /d4/R12/ab/apps/R1211XB9/apps/tech_st/10.1.3/lib32/hsdb_odbc.so
lrwxrwxrwx 1 applmgr dba 63 Sep 29 16:58 hsdb_oing.so -> /d4/R12/ab/apps/R1211XB9/apps/tech_st/10.1.3/lib32/hsdb_oing.so
lrwxrwxrwx 1 applmgr dba 62 Sep 29 16:58 hsdb_ora.so -> /d4/R12/ab/apps/R1211XB9/apps/tech_st/10.1.3/lib32/hsdb_ora.so
lrwxrwxrwx 1 applmgr dba 62 Sep 29 16:58 hsdb_syb.so -> /d4/R12/ab/apps/R1211XB9/apps/tech_st/10.1.3/lib32/hsdb_syb.so
lrwxrwxrwx 1 applmgr dba 62 Sep 29 16:59 libnavhoa.a -> /d4/R12/ab/apps/R1211XB9/apps/tech_st/10.1.3/lib32/libnavhoa.a
applmgr@tsgsd2106 $ pwd
$IAS_ORACLE_HOME/lib

Once we removed these soft links and pointed them to the existing mounts, we were able to run relink all on 10.1.2 and 10.1.3 homes.

Apache started without issues after we did relink all on 10.1.3 IAS_ORACLE_HOME.

Recently on a Solaris 8 box when I executed this command, I go the error unable to get pty

$ /usr/dt/bin/dtterm &
[1] 7507
$ grantpt: Error 0
Warning:
Name: dtTerm
Class: DtTerm
unable to get pty

A google search returned this link from docs.sun.com:

http://docs.sun.com/app/docs/doc/806-1075/6jacsnin4?a=view

unable to get pty!

Cause
When trying to open a Terminal window (dtterm) in CDE, a pop-up window appears stating, Unable to get pty!

dtterm is not able to open /dev/pts/int (where int is an integer). The user cannot open this file because grantpt(3C) failed to change the permissions on the file. grantpt(3C) failed because the binary /usr/lib/pt_chmod is not setuid root. The permissions on /usr/lib/pt_chmod must be 4111.

Action
To restore the correct permissions to pt_chmod, use the following command (as root):

# chmod 4111 /usr/lib/pt_chmod

So I logged in as root and executed the above command.

Issue was resolved.

On accessing Extranet URL from Internet, we got this message:

Access Denied

You are not authorized to access this site.

The application you are attempting to access requires additional authorization. If you feel you have received this message in error, please contact your local business Help Desk.

This error is coming because we have SSO enabled our Extranet also. If the user exists in the SSO database and doesn't exist in the FND_USER table of Oracle E-Business Suite, this error would appear.

After creating the users locally in E-Business Suite, this error should disappear.

Recently we implemented a third party software for Mobile users called Ventureforth Mi2k Server. After doing the install which creates a custom schema and creates packages which call Oracle API to insert, update, delete data into APPS, we got this error when they executed a test call:

ORA-01031: insufficient privileges

We had a tough time figuring out which object didn't have the grant. After a lot of trials through Toad debugging and tracing through DBMS_SYSTEM, I recalled that we could trap any error message in alert log and get more details about the error by using this command:

alter system set events '1031 trace name errorstack level 3';

Here 1031 is ORA-01031. You can put any error code in this command by removing the 0 prefix from the error code. Once you execute this command as SYS/SYSTEM, anytime ORA-1031 is issued by the database, the alert log will record this error and a trace file will be generated to give more details about the error.

Once we did this, we immediately came to know that it was failing when the API was calling UPDATE APPS.JTF_TASK_ALL_RESPONSIBILITIES which was a synonym to JTF.JTF_TASK_RESPONSIBILITIES. The custom schema had rights on JTF.JTF_TASK_RESPONSIBILITIES but not on JTF_TASK_ALL_RESPONSIBILITIES synonym. So we granted the rights:

grant all on APPS.JTF_TASK_ALL_RESPONSIBILITIES TO I2K;

After this the error disappeared.

Internet Explorer proxy settings dialog box is usually accessed with this navigation:

Start Internet Explorer
Click on Tools Menu > Internet Options
Connections Tab
Lan Settings button

You can also access this directly from command line by this:

Start Button > Run > inetcpl.cpl

Makarand was doing a Fresh R12 install. The install was successful on the Database Node and Primary Application Node. On Primary Application node only 'Batch Processing Services' are enabled.

However while installing on the additonal application node the rapidwiz was giving errors

'AC-00002: Error: Unable to create log file - $INST_TOP/$CONTEXT_NAME/logs/08031631.log
Exception in thread "AWT-EventQueue-0" java.lang.RuntimeException: AC-00002: Unable to create log file -
$INST_TOP/$CONTEXT_NAME/logs/08031631.log

Makarand had tried installing multiple times but every time it failed with the same message

The truss of the rapidwiz process showed this:

/40: open64("$INST_TOP/$CONTEXT_NAME/logs/08200953.log",
O_WRONLY|O_APPEND|O_CREAT, 0666) Err#13 EACCES


Here’s the reason for the failure:

apps11i is the app tier and you are trying to write to an NFS mount. If you access an NFS mount from a server other than its origin, the root user of the application server is treated as nobody user. I verified this by touching a file while logged in as root:

-rw-r--r-- 1 nobody nobody 0 Aug 20 10:59 abc

This happens if the NFS share is shared without root= in the NFS mount command.

An examination of the /etc/dfs/dfstab file revealed that:

share -F nfs -o rw=visionerp.justanexample.com,root=visionerp.justanexample.com /gpshpc76/custom
share -F nfs -o rw=erpr12.justanexample.com,root=erpr12.justanexample.com /erpr12/erpapp
share -F nfs -o rw=erp11i.justanexample.com,root=erp11i.justanexample.com /erp11i/erpapp

If you compare the last line with a line for other instances it clearly shows that the application server has no read write rights and no root equivalence. I corrected this by executing this command:

share -F nfs -o rw=apps11i.justanexample.com,root=apps11i.justanexample.com /arpsysd1/erpapp

I also corrected it in the /etc/dfs/dfstab.

After this we retried the rapidwiz and it worked.

While running Update Current Snapshot during migration to shared application file system the DBAs reported this error:

“Update current view snapshot” throwing following error message.

Done processing object modules

File "INVRCVVB.pls"

Either has No Version or Unknown error(-4)


Failed in adusnapGetDetailFileInfo()

AD Administration error:

Failed store Snapshot file info

adusnapMaintainSnapshot() : Error calling adusnapUpdateCurrentView()

Error calling adusnapMaintainSnapshot


Backing up restart files, if any......Done.


You should check the file

$APPL_TOP/admin/$TWO_TASK/log/adadmin.log for errors.

The file INVRCVVB.pls in $INV_TOP/sql and $INV_TOP/patch/115/sql had a string _new in its version information:


$ adident Header INVRCVVB.pls.original

INVRCVVB.pls.original:

$Header INVRCVVB.pls 115.107.115100.85_new 2008/03/20 08:51:49 kagupta ship $

After removing the _new from the version information inside the file, the issue was resolved.

Recently, I was helping Ashok in installing Outlook 2003 on his Laptop which had Vista Home Premium running on Windows Vista.

The setup program cancelled with this message:

Cannot start Microsoft Outlook. MAPI32.DLL is
corrupt or the wrong version. This could have
been caused by installing other messaging system.
Please reinstall Outlook.

I found a technote from Microsoft which asked to run windows\system32\fixmapi.exe.

That didn't help.

I found some other posts on the net which advised doing this:

Locate the file MSMAPI32.DLL in Program Files\Common Files\System\MSMAPI\1033
Rename the file to something like MSMAPI32.XXX or MSMAPI32.OLD

This worked for us.

Sun has given this program to test the number of open file descriptors here.


vi fopentestcase.c

#include
#include

#define NoOfFILES 65536

int main()
{
char filename[10];
FILE *fds[NoOfFILES];
int i;

for (i = 0; i < NoOfFILES; ++i)
{
sprintf (filename, "/tmp/%d.log", i);
fds[i] = fopen(filename, "w");

if (fds[i] == NULL)
{
printf("\nNumber of open files = %d. " \
"fopen() failed with error: ", i);
perror("");
exit(1);
}
else
{
fprintf (fds[i], "some string");
}
}
return (0);
}

/usr/local/bin/gcc -o fopentestcase fopentestcase.c

$ ./fopentestcase

Number of open files = 253. fopen() failed with error: Too many open files
$

It errors out on the 254th file. This is because it is a 32 bit program.