Listener forks on 10.2.0.3 if LD_ASSUME_KERNEL is set

Found an interesting problem.

If the .bash_profile has LD_ASSUME_KERNEL parameter the listener forks itself as given below:
oratest 13305 1 0 16:59 ? 00:00:00 /u04/oracle/testdb/10.2.0//bin/tnslsnr TEST -inheritoratest 13306 13305 0 16:59 ? 00:00:00 /u04/oracle/testdb/10.2.0//bin/tnslsnr TEST -inheritoratest 13307 13306 0 16:59 ? 00:00:00 /u04/oracle/testdb/10.2.0//bin/tnslsnr TEST -inheritoratest 13308 13306 0 16:59 ? 00:00:00 /u04/oracle/testdb/10.2.0//bin/tnslsnr TEST -inherit

If this parameter is removed and the env file is resourced the listener behaves properly.

oratest 13370 1 0 17:01 ? 00:00:00 /u04/oracle/testdb/10.2.0//bin/tnslsnr TEST -inheritoratest 13374 13339 0 17:01 pts/4 00:00:00 grep tnslsnr

I also have another database which is running on 10.1.04 and I see the listener forking (this does not have the parameter in the .bash_profile)

oradev 12971 1 0 15:07 ? 00:00:00 /u01/oracle/devdb/10.1.0/bin/tnslsnr DEV -inheritoradev 12972 12971 0 15:07 ? 00:00:00 /u01/oracle/devdb/10.1.0/bin/tnslsnr DEV -inheritoradev 12973 12972 0 15:07 ? 00:00:00 /u01/oracle/devdb/10.1.0/bin/tnslsnr DEV -inheritoradev 12974 12972 0 15:07 ? 00:00:00 /u01/oracle/devdb/10.1.0/bin/tnslsnr DEV -inherit

I guess I have to get a patch from oracle for this or upgrade the same to 10.2.0.2.

Windows NT to Linux Migration - Unable to login to Self Service

While doing the migration to Linux I was stumped by an error. I was not able to login using Self Service but was able to login using dev60/f60cgi. This error kept haunting me and giving headaches for two weeks.

The error was as follows:

oracle.jsp.JspServlet: initOSS: Caught throwable in AppsLocalLogin.jsp : java.lang.NoClassDefFoundErrorjava.lang.NoClassDefFoundErrorat oracle.apps.fnd.sso.SSOManager.getAppsServletAgent(SSOManager.java:1998)at oracle.apps.fnd.sso.SSOManager.getLoginUrl(SSOManager.java:338)at _oa__html._AppsLocalLogin._jspService(_AppsLocalLogin.java:483)at oracle.jsp.runtime.HttpJsp.service(HttpJsp.java:119)at oracle.jsp.app.JspApplication.dispatchRequest(JspApplication.java:417)at oracle.jsp.JspServlet.doDispatch(JspServlet.java:267)at oracle.jsp.JspServlet.internalService(JspServlet.java:186)at oracle.jsp.JspServlet.service(JspServlet.java:156)at javax.servlet.http.HttpServlet.service(HttpServlet.java:588)at org.apache.jserv.JServConnection.processRequest(JServConnection.java:456)at org.apache.jserv.JServConnection.run(JServConnection.java:294)at java.lang.Thread.run(Thread.java:534)
I had enabled jserv logging but it was not giving any insights. After 2 weeks of intense followup with Oracle Support it turned out that while the copy of $JAVA_TOP/COM is done from Windows to Linux the COM directory needs to be moved to lowercase i.e. com as Windows is case insensitive and Linux is not.

Oracle Support has created a metalink note 604529.1 which is not published yet.

ORA-12505 TNS:listener could not resolve SID given in connect description

Recently we changed the port of the DB from default 1521 to 1532. After this change it was noticed that clients could not connect although tnsping was working.

Metalink note 111911.1 points to registration of the instance name with the listener. Did the steps in the note and clients could connect to the instance.
Reason is prior to Oracle 8i, a listener was statically configured (listener.ora) to service a given set of SIDs. From 8i, PMON dynamically registers a database service with the listener.

ORA-00600: internal error code, arguments: [LibraryCacheNotEmptyOnClose], [], [], [], [], [], [], []

I got this error while shutting down the db on 10.2.0.2.


ORA-00081: address range [0x60000000000A7DE0, 0x60000000000A7DE4) is not readable
ORA-00600: internal error code, arguments: [LibraryCacheNotEmptyOnClose], [], [], [], [], [], [], []
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options

Metalink Note 435926.1 says to ignore this error.

OAM Dashboard shows source and target machine node

I found metalink note 260887.1 to clean up non-existent nodes from FND_NODES

1. SQL> EXEC FND_CONC_CLONE.SETUP_CLEAN; COMMIT; EXIT;

2. Run autoconfig on DB tier followed by on Apps Tier.

UTL_MAIL package gives ORA-29261: bad argument

One of the developers sent this error while using UTL_MAIL package.

ORA-29261: bad argument
ORA-06512: at "SYS.UTL_TCP", line 28
ORA-06512: at "SYS.UTL_TCP", line 257
ORA-06512: at "SYS.UTL_SMTP", line 116
ORA-06512: at "SYS.UTL_SMTP", line 139
ORA-06512: at "SYS.UTL_MAIL", line 395
ORA-06512: at "SYS.UTL_MAIL", line 602
ORA-06512: at line 3

I found metalink note 339445.1 which says this can be due to two reasons.

1. SMTP_OUT_SERVER is not set as a database parameter.
2. This error can also occur if the SUBJECT parameter in the UTL_MAIL call is omitted.

In our case it was the first "SMTP_OUT_SERVER".

Added the parameter to the initialization parameter file and bounced the database.

SYSTEM OR APPS PASSWORD DISPLAYED ON THE SCREEN WHEN RUNNING ADPATCH

If you are on AD.I.2 you may have noticed the the system and/or apps password is visible on screen. To fix this move to 11i.AD.I.delta.4 (patch number 4605654) or better still to 11i.AD.I.4 (patch number 4712852).