24 February 2011

How to Send the Mail using Telnet

[oracle@our12-test ~]$ telnet 10.1.0.209 25
Trying 10.1.0.209...
Connected to 10.1.0.209 (10.1.0.209).
Escape character is '^]'.
220 exccasggnfip01.optibilt.com Microsoft ESMTP MAIL Service ready at Thu, 24 Feb 2011 15:28:06 +0530
helo OPTIBILT
250 exccasggnfip01.optibilt.com Hello [10.2.0.187]
MAIL FROM: our12.mailtest@bilt.com
250 2.1.0 Sender OK
RCPT TO: thalaimuthu@gmail.com
250 2.1.5 Recipient OK
DATA
354 Start mail input; end with <CRLF>.<CRLF>
Welcome

.
250 2.6.0 <7aec04c1-057e-4fbc-9c4b-25cb2dea19a4@exccasggnfip01.optibilt.com> Queued mail for delivery

quit
221 2.0.0 Service closing transmission channel
Connection closed by foreign host.
[oracle@our12-test ~]$

APP-FND-01564: ORACLE error 6502 in afscpcon

Hi,

Am using 11.5.7   am trying to open on Internet explorer 9 .then am facing below error :-

APP-FND-01564: ORACLE error 6502 in afscpcon

Cause: afscpcon failed due to ORA-06502: PL/SQL: numeric or value error
ORA-06512: at "SYS.OWA_UTIL", line 325
ORA-06512: at "SYS.HTP", line 1322
ORA-06512: at "SYS.HTP", line 1397
ORA-06512: at "SYS.HTP", line 1689
ORA-06512: at "APPS.ICX_SEC", line 3457
ORA-06502: PL.

The SQL statement being executed at the time of the error was: SELECT SES.USER_ID, SES.RESPONSIBILITY_ID, SES.RESPONSIBILITY_APPLICATION_ID, SES.SECURITY_GROUP_ID, FSG.SECURITY_GROUP_KEY, U.USER_NAME, U.ENCRYPTED_USER_PASSWORD, SES.SESSION_ID, NVL(SES.LOGIN_ID, -1) FROM ICX_SESSIONS SES, FND_SECURITY_GROUPS FSG, FND_USER U WHERE SES.SESSION_ID = ICX_SEC.GetSessionCookie(:tik) AND NVL(SES.SECURITY_GROUP_ID, 0) = FSG.SECURITY_GROUP_ID AND SES.USER_ID = U.USER_ID AND DISABLED_FLAG = 'N' AND COUNTER + 1 < LIMIT_CONNECTS AND FIRST_CONNECT + LIMIT_TIME/24 > SYSDATE and was executed from the file &ERRFILE."



Solution :-
My url:-   http://backserver.bilt.com:8002


but now am using  :  http://backserver.bilt.com:8002/dev60cgi/f60cgi


Now its working fine

17 February 2011

How to format the Linux Hard disk

[root@muthu ~]# fdisk -l

Disk /dev/sda: 107.3 GB, 107374182400 bytes
255 heads, 63 sectors/track, 13054 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes

   Device Boot      Start         End      Blocks   Id  System
/dev/sda1   *           1          13      104391   83  Linux
/dev/sda2              14        1288    10241437+  83  Linux
/dev/sda3            1289        1549     2096482+  82  Linux swap
/dev/sda4            1550       13054    92413912+   5  Extended
/dev/sda5            1550       13054    92413881   83  Linux

Disk /dev/sdb: 75.1 GB, 75161927680 bytes
255 heads, 63 sectors/track, 9137 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes

Disk /dev/sdb doesn't contain a valid partition table
[root@muthu /]# fdisk /dev/sdb
Device contains neither a valid DOS partition table, nor Sun, SGI or OSF disklabel
Building a new DOS disklabel. Changes will remain in memory only,
until you decide to write them. After that, of course, the previous
content won't be recoverable.


The number of cylinders for this disk is set to 9137.
There is nothing wrong with that, but this is larger than 1024,
and could in certain setups cause problems with:
1) software that runs at boot time (e.g., old versions of LILO)
2) booting and partitioning software from other OSs
   (e.g., DOS FDISK, OS/2 FDISK)
Warning: invalid flag 0x0000 of partition table 4 will be corrected by w(rite)

Command (m for help): p

Disk /dev/sdb: 75.1 GB, 75161927680 bytes
255 heads, 63 sectors/track, 9137 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes

   Device Boot      Start         End      Blocks   Id  System

Command (m for help): n
Command action
   e   extended
   p   primary partition (1-4)
e
Partition number (1-4): 1
First cylinder (1-9137, default 1):
Using default value 1
Last cylinder or +size or +sizeM or +sizeK (1-9137, default 9137):
Using default value 9137

Command (m for help): wq
The partition table has been altered!

Calling ioctl() to re-read partition table.
Syncing disks.
[root@muthu /]# mkfs -t ext3 /dev/sdb
mke2fs 1.35 (28-Feb-2004)
/dev/sdb is entire device, not just one partition!
Proceed anyway? (y,n) y
Filesystem label=
OS type: Linux
Block size=4096 (log=2)
Fragment size=4096 (log=2)
9175040 inodes, 18350080 blocks
917504 blocks (5.00%) reserved for the super user
First data block=0
Maximum filesystem blocks=4294967296
560 block groups
32768 blocks per group, 32768 fragments per group
16384 inodes per group
Superblock backups stored on blocks:
        32768, 98304, 163840, 229376, 294912, 819200, 884736, 1605632, 2654208,
        4096000, 7962624, 11239424

Writing inode tables: done
Creating journal (8192 blocks): done
Writing superblocks and filesystem accounting information:
done

This filesystem will be automatically checked every 36 mounts or
180 days, whichever comes first.  Use tune2fs -c or -i to override.
[root@muthu /]# mount /dev/sdb /backup/
[root@muthu /]# df -h
Filesystem            Size  Used Avail Use% Mounted on
/dev/sda2             9.7G  7.6G  1.7G  83% /
/dev/sda1              99M   20M   74M  22% /boot
none                  501M     0  501M   0% /dev/shm
/dev/sda5              87G   88M   83G   1% /oracle
/dev/hdc              2.6G  2.6G     0 100% /media/cdrom
/dev/sdb               69G   84M   66G   1% /backup
[root@muthu /]#

14 February 2011

ORA-12154: TNS:could not resolve the connect identifier specified or ORA-6413: Connection not open

Hi,
Am using Windows 7 64bit OS am faceed the below problem .

Error:-
ORA-12154: TNS:could not resolve the connect identifier specified
        or
     ORA-6413: Connection not open.

 

Solution:-

64-bit Microsoft OS's install 32-bit applications into the following location 
 C:\Program Files (x86)\QuestSoftware\Toad for Oracle 10.6   this is my installation Directory so i ll changed to 
C:\Program Files\QuestSoftware\Toad for Oracle 10.6   then my problem is resolved

java.net.SocketException: Unknown proxy type : HTTP

Error:-
network: Connection http://our12apps.bilt.com:8002/OA_JAVA/oracle/apps/fnd/jar/fndforms.jar, isa-ggnfip01.optibilt.com/10.1.0.207:8080java.net.ConnectException: Connection timed out: connect failed: removed from proxy cache
network: Connecting http://our12apps.bilt.com:8002/ with proxy=HTTP @ isa-ggnfip01.optibilt.com/10.1.0.207:8080
network: Cache entry not found [url: http://our12apps.bilt.com:8002/OA_JAVA/oracle/apps/fnd/jar/fndformsi18n.jar, version: null]
network: Connecting http://our12apps.bilt.com:8002/OA_JAVA/oracle/apps/fnd/jar/fndformsi18n.jar with proxy=HTTP @ isa-ggnfip01.optibilt.com/10.1.0.207:8080
network: Connection http://our12apps.bilt.com:8002/OA_JAVA/oracle/apps/fnd/jar/fndformsi18n.jar, isa-ggnfip01.optibilt.com/10.1.0.207:8080java.net.ConnectException: Connection timed out: connect failed: removed from proxy cache
network: Connecting http://our12apps.bilt.com:8002/ with proxy=HTTP @ isa-ggnfip01.optibilt.com/10.1.0.207:8080
java.net.SocketException: Unknown proxy type : HTTP
at java.net.SocksSocketImpl.connect(Unknown Source)
at java.net.Socket.connect(Unknown Source)
at sun.net.NetworkClient.doConnect(Unknown Source)
at sun.net.www.http.HttpClient.openServer(Unknown Source)
at sun.net.www.http.HttpClient.openServer(Unknown Source)
at sun.net.www.http.HttpClient.<init>(Unknown Source)
at sun.net.www.http.HttpClient.New(Unknown Source)
at sun.net.www.protocol.http.HttpURLConnection.getNewHttpClient(Unknown Source)
at sun.net.www.protocol.http.HttpURLConnection.plainConnect(Unknown Source)
at sun.net.www.protocol.http.HttpURLConnection.connect(Unknown Source)
at sun.net.www.protocol.http.HttpURLConnection.getInputStream(Unknown Source)
at sun.plugin.PluginURLJarFileCallBack.downloadJAR(Unknown Source)
at sun.plugin.PluginURLJarFileCallBack.access$000(Unknown Source)
at sun.plugin.PluginURLJarFileCallBack$2.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at sun.plugin.PluginURLJarFileCallBack.retrieve(Unknown Source)
at sun.net.www.protocol.jar.URLJarFile.retrieve(Unknown Source)
at sun.net.www.protocol.jar.URLJarFile.getJarFile(Unknown Source)
at sun.net.www.protocol.jar.JarFileFactory.get(Unknown Source)
at sun.net.www.protocol.jar.JarURLConnection.connect(Unknown Source)
at sun.plugin.net.protocol.jar.CachedJarURLConnection.connect(Unknown Source)
at sun.plugin.net.protocol.jar.CachedJarURLConnection.getJarFileInternal(Unknown Source)
at sun.plugin.net.protocol.jar.CachedJarURLConnection.getJarFile(Unknown Source)
at sun.misc.URLClassPath$JarLoader.getJarFile(Unknown Source)
at sun.misc.URLClassPath$JarLoader.access$600(Unknown Source)
at sun.misc.URLClassPath$JarLoader$1.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at sun.misc.URLClassPath$JarLoader.ensureOpen(Unknown Source)
at sun.misc.URLClassPath$JarLoader.<init>(Unknown Source)
at sun.misc.URLClassPath$3.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at sun.misc.URLClassPath.getLoader(Unknown Source)
at sun.misc.URLClassPath.getLoader(Unknown Source)
at sun.misc.URLClassPath.getResource(Unknown Source)
at sun.plugin2.applet.Plugin2ClassLoader$2.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at sun.plugin2.applet.Plugin2ClassLoader.findClassHelper(Unknown Source)
at sun.plugin2.applet.Applet2ClassLoader.findClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at sun.plugin2.applet.Plugin2ClassLoader.loadCode(Unknown Source)
at sun.plugin2.applet.Plugin2Manager.createApplet(Unknown Source)
at sun.plugin2.applet.Plugin2Manager$AppletExecutionRunnable.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
network: Cache entry not found [url: http://our12apps.bilt.com:8002/OA_JAVA/oracle/apps/fnd/jar/fndformsi18n.jar, version: null]
network: Connecting http://our12apps.bilt.com:8002/OA_JAVA/oracle/apps/fnd/jar/fndformsi18n.jar with proxy=HTTP @ isa-ggnfip01.optibilt.com/10.1.0.207:8080
Solution:-
Please check your Java proxy setting in controlpanel .

11 February 2011

ORA-609 : opiodr aborting process unknown ospid

Error:-
Fatal NI connect error 12170.

  VERSION INFORMATION:
        TNS for Linux: Version 11.1.0.7.0 - Production
        Oracle Bequeath NT Protocol Adapter for Linux: Version 11.1.0.7.0 - Production
        TCP/IP NT Protocol Adapter for Linux: Version 11.1.0.7.0 - Production
  Time: 11-FEB-2011 15:15:25
  Tracing not turned on.
  Tns error struct:
    ns main err code: 12535

TNS-12535: TNS:operation timed out
    ns secondary err code: 12606
    nt main err code: 0
    nt secondary err code: 0
    nt OS err code: 0
  Client address: <unknown>
ORA-609 : opiodr aborting process unknown ospid

Solution :-

Sqlnet.ora: SQLNET.INBOUND_CONNECT_TIMEOUT=120
 

TNS errors in the alert.log by setting the following listener.ora file parameter:
 
INBOUND_CONNECT_TIMEOUT_listener_name=120
DIAG_ADR_ENABLED_listener_name=OFF

 

How to check the Long running Concurrent Process

SELECT a.request_id
,a.oracle_process_id "SPID"
,frt.responsibility_name
,c.concurrent_program_name || ': ' || ctl.user_concurrent_program_name
,a.description
,a.ARGUMENT_TEXT
,b.node_name
,b.db_instance
,a.logfile_name
,a.logfile_node_name
,a.outfile_name
,q.concurrent_queue_name
,a.phase_code,a.status_code, a.completion_text
, actual_start_date
, actual_completion_date
, fu.user_name
,(nvl(actual_completion_date,sysdate)-actual_start_date)*1440 mins
,(SELECT avg(nvl(a2.actual_completion_date-a2.actual_start_date,0))*1440 avg_run_time
FROM APPLSYS.fnd_Concurrent_requests a2,
APPLSYS.fnd_concurrent_programs c2
WHERE c2.concurrent_program_id = c.concurrent_program_id
AND a2.concurrent_program_id = c2.concurrent_program_id
AND a2.program_application_id = c2.application_id
AND a2.phase_code || '' = 'C') avg_mins
,round((actual_completion_date - requested_start_date),2) * 24 duration_in_hours
FROM APPLSYS.fnd_Concurrent_requests a,APPLSYS.fnd_concurrent_processes b
,applsys.fnd_concurrent_queues q
,APPLSYS.fnd_concurrent_programs c
,APPLSYS.fnd_concurrent_programs_tl ctl
,apps.fnd_user fu
,apps.FND_RESPONSIBILITY_TL frt
WHERE a.controlling_manager = b.concurrent_process_id
AND a.concurrent_program_id = c.concurrent_program_id
AND a.program_application_id = c.application_id
AND a.phase_code = 'R'
AND a.status_code = 'R'
AND b.queue_application_id = q.application_id
AND b.concurrent_queue_id = q.concurrent_queue_id
AND ctl.concurrent_program_id = c.concurrent_program_id
AND a.requested_by = fu.user_id
AND a.responsibility_id = frt.responsibility_id
ORDER BY a.actual_start_date DESC

Output:-
REQUEST_ID,SPID,RESPONSIBILITY_NAME,C.CONCURRENT_PROGRAM_NAME||':'||CTL.USER_CONCURRENT_PROGRAM_NAME,DESCRIPTION,ARGUMENT_TEXT,NODE_NAME,DB_INSTANCE,LOGFILE_NAME,LOGFILE_NODE_NAME,OUTFILE_NAME,CONCURRENT_QUEUE_NAME,PHASE_CODE,STATUS_CODE,COMPLETION_TEXT,ACTUAL_START_DATE,ACTUAL_COMPLETION_DATE,USER_NAME,MINS,AVG_MINS,DURATION_IN_HOURS
1655903,17481,Inventory,INCOIN: Import Items,,, 1, 1, 1, 1, 4100, 1,OUR12-APPS1,OURPROD,/applprod/conc_log/log/l1655903.req,OUR12-APPS1,/applprod/conc_log/out/o1655903.out,STANDARD,R,R,,11-Feb-11 12:08:44 PM,,SETUPUSER,9.23333333333333,162.816666666667,

10 February 2011

Changing Color Scheme and look and feel of Application 11i and R12

There are two database profile options that can be used to change look and feel.

1.Java Look and Feel.

Java Look and Feel can have two values: GENERIC or ORACLE.

If set to GENERIC, then set Java Color Scheme to blank. Which will leave look
and feel to generic. The Generic look and feel adheres to the native interface
and color scheme of the current operating system.

If set to ORACLE (or if the value is left blank), then the profile option 'Java
Color Scheme' can be used to personalize the colors of your screen.


2.Java Color Scheme.

If 'Java Look and Feel' is set to ORACLE (or if the value is left blank), then
'Java Color Scheme' can be set to the following values:

Blaf
Blue
Khaki
Olive
Purple
Red
Teal
Titanium

Do the following:
a. Login to Oracle Applications as the System Administator responsibility.
b. Navigate to Profile > System.
c. Ensure that the Site display is checked.
d. Query up 'Java Color Scheme' for the profile.
e. Select the appropriate color under the Site column.
f. Save the selection.
g. Sign off and back on (or change responsibility) for your new color
scheme to take effect.

Be aware that the 'Java Color Scheme' profile has no effect if 'Java Look and
Feel' is set to GENERIC.

09 February 2011

show memory allocations for the database sessions

show memory allocations for the database sessions

SELECT NVL(a.username,'(oracle)') AS username,
       a.module,
       a.program,
       Trunc(b.value/1024) AS memory_kb
FROM   v$session a,
       v$sesstat b,
       v$statname c
WHERE  a.sid = b.sid
AND    b.statistic# = c.statistic#
AND    c.name = 'session pga memory'
AND    a.program IS NOT NULL
ORDER BY b.value DESC;

How to check the general health of the system ?

How to check the general health of the system ?

SELECT file_id,
       tablespace_name,
       file_name,
       status
FROM   sys.dba_data_files;

SELECT file#,
       name,
       status,
       enabled
FROM   v$datafile;

SELECT *
FROM   v$backup;

SELECT *
FROM   v$recovery_status;

SELECT *
FROM   v$recover_file;

SELECT *
FROM   v$recovery_file_status;

SELECT *
FROM   v$recovery_log;

SELECT username,
       command,
       status,
       module
FROM   v$session;

Howto check the Locked objects?

Howto check the Locked objects?

SELECT b.session_id AS sid,
       NVL(b.oracle_username, '(oracle)') AS username,
       a.owner AS object_owner,
       a.object_name,
       Decode(b.locked_mode, 0, 'None',
                             1, 'Null (NULL)',
                             2, 'Row-S (SS)',
                             3, 'Row-X (SX)',
                             4, 'Share (S)',
                             5, 'S/Row-X (SSX)',
                             6, 'Exclusive (X)',
                             b.locked_mode) locked_mode,
       b.os_user_name
FROM   dba_objects a,
       v$locked_object b
WHERE  a.object_id = b.object_id
ORDER BY 1, 2, 3, 4;

How to check the Invalid ,database info status

SELECT owner,
       object_type,
       object_name,
       status
FROM   dba_objects
WHERE  status = 'INVALID'
ORDER BY owner, object_type, object_name;

How to check the database info?

SELECT *
FROM   v$version;

SELECT a.name,
       a.value
FROM   v$sga a;

SELECT Substr(c.name,1,60) "Controlfile",
       NVL(c.status,'UNKNOWN') "Status"
FROM   v$controlfile c
ORDER BY 1;

SELECT Substr(d.name,1,60) "Datafile",
       NVL(d.status,'UNKNOWN') "Status",
       d.enabled "Enabled",
       LPad(To_Char(Round(d.bytes/1024000,2),'9999990.00'),10,' ') "Size (M)"
FROM   v$datafile d
ORDER BY 1;

SELECT l.group# "Group",
       Substr(l.member,1,60) "Logfile",
       NVL(l.status,'UNKNOWN') "Status"
FROM   v$logfile l
ORDER BY 1,2;

How to check the connected session on Database

How to check the connected session on Database

SELECT NVL(s.username, '(oracle)') AS username,
       s.osuser,
       s.sid,
       s.serial#,
       p.spid,
       s.lockwait,
       s.status,
       s.module,
       s.machine,
       s.program,
       TO_CHAR(s.logon_Time,'DD-MON-YYYY HH24:MI:SS') AS logon_time
FROM   v$session s,
       v$process p
WHERE  s.paddr = p.addr
ORDER BY s.username, s.osuser;

Oracle Table Space Usage check Scripts

SELECT Substr(df.tablespace_name,1,20) "Tablespace Name",
       Substr(df.file_name,1,40) "File Name",
       Round(df.bytes/1024/1024,2) "Size (M)",
       Round(e.used_bytes/1024/1024,2) "Used (M)",
       Round(f.free_bytes/1024/1024,2) "Free (M)",
       Rpad(' '|| Rpad ('X',Round(e.used_bytes*10/df.bytes,0), 'X'),11,'-') "% Used"
FROM   DBA_DATA_FILES DF,
       (SELECT file_id,
               Sum(Decode(bytes,NULL,0,bytes)) used_bytes
        FROM dba_extents
        GROUP by file_id) E,
       (SELECT Max(bytes) free_bytes,
               file_id
        FROM dba_free_space
        GROUP BY file_id) f
WHERE  e.file_id (+) = df.file_id
AND    df.file_id  = f.file_id (+)
ORDER BY df.tablespace_name,
         df.file_name;

08 February 2011

ORA-02020: too many database links in use

I have created the 8 DB link but one DB link is not working below error

ORA-02020: too many database links in use

Solution:-

 [oracle@our12-test admin]$ sqlplus "/as sysdba"

SQL*Plus: Release 11.1.0.7.0 - Production on Tue Feb 8 12:31:05 2011

Copyright (c) 1982, 2008, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> show parameter open_links;

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
open_links                           integer     4
SQL>
Solution:-
Stop your Database then edit init<$ORACLE_SID>.ora
add below line *.open_links=10 then start your database 

SQL> show parameter open_links;

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
open_links                           integer     10

SQL>

then my problem is resolved

How to check the Locked tables

If you want check the Locked tables execute the below query

SELECT oracle_username os_user_name,
       owner,
       locked_mode,
       object_name,
       object_type
         FROM v$locked_object lo, dba_objects do
 WHERE lo.object_id = do.object_id;

Output:-
OS_USER_NAME,OWNER,LOCKED_MODE,OBJECT_NAME,OBJECT_TYPE
APPS,APPLSYS,3,FND_CONCURRENT_QUEUES,TABLE
APPS,APPLSYS,3,FND_CONCURRENT_REQUESTS,TABLE
APPS,INV,3,MTL_SYSTEM_ITEMS_INTERFACE,TABLE
APPS,INV,3,MTL_SYSTEM_ITEMS_INTERFACE,TABLE
APPS,INV,3,MTL_ITEM_REVISIONS_INTERFACE,TABLE
APPS,INV,3,MTL_ITEM_REVISIONS_INTERFACE,TABLE

How to unlock Blocked Tables

Execute below query if you found any row kill that session .
select
c.object_name,
b.sid,
b.serial#,
b.machine
from
v$locked_object a ,
v$session b,
dba_objects c
where
b.sid = a.session_id
and
a.object_id = c.object_id
and object_name='MTL_SYSTEM_ITEMS_INTERFACE';

Output:-

OBJECT_NAME,               SID,SERIAL#,MACHINE
MTL_SYSTEM_ITEMS_INTERFACE,2948,7,our12-test.bilt.com

Solution:-
alter system kill session '7,2948 ' Immediate;

07 February 2011

Fatal NI connect error 12170. VERSION INFORMATION: TNS for Linux: Version 11.1.0.7.0 - Production Oracle Bequeath NT Protocol Adapter for Linux: Version 11.1.0.7.0 - Production TCP/IP NT Protocol Adapter for Linux: Version 11.1.0.7.0 - Production Time: 07-FEB-2011 06:31:22 Tracing not turned on. Tns error struct: ns main err code: 12535 TNS-12535: TNS:operation timed out ns secondary err code: 12560 nt main err code: 505 TNS-00505: Operation timed out nt secondary err code: 110 nt OS err code: 0 Client address: (ADDRESS=(PROTOCOL=tcp)(HOST=10.49.15.145)(PORT=50669))

Fatal NI connect error 12170.

  VERSION INFORMATION:
        TNS for Linux: Version 11.1.0.7.0 - Production
        Oracle Bequeath NT Protocol Adapter for Linux: Version 11.1.0.7.0 - Production
        TCP/IP NT Protocol Adapter for Linux: Version 11.1.0.7.0 - Production
  Time: 07-FEB-2011 06:31:22
  Tracing not turned on.
  Tns error struct:
    ns main err code: 12535

TNS-12535: TNS:operation timed out
    ns secondary err code: 12560
    nt main err code: 505

TNS-00505: Operation timed out
    nt secondary err code: 110
    nt OS err code: 0
  Client address: (ADDRESS=(PROTOCOL=tcp)(HOST=10.49.15.145)(PORT=50669))
Mon Feb 07 06:51:20 2011

Solution:-
sqlnet.ora
SQLNET.INBOUND_CONNECT_TIMEOUT= 60
Listener.ora
DIAG_ADR_ENABLED_listener_name=OFF

How to find log files locations in 11i and R12

How to find log files locations in 11i and R12


The following log files location could help you to find-out issues and errors from your application 11i and R12 instance.

Database Tier Logs are

Alert Log File location:
$ORACLE_HOME/admin/$CONTEXT_NAME/bdump/alert_$SID.log

Logs for the adcfgclone.pl are located:

On the database tier: 
RDBMS $ORACLE_HOME/appsutil/log/< context >/ApplyDBTier_< timestamp >.log 

On the application tier: 
$INST_TOP/admin/log/ApplyAppsTier_< timestamp >.log
 
Database Tier :
$ORACLE_HOME/appsutil/log/SID_Hostname
  
Trace file location:
$ORACLE_HOME/admin/SID_Hostname/udump

Application Tier Logs

Start/Stop script log files location:
$COMMON_TOP/admin/log/CONTEXT_NAME/ 

OPMN log file location
$ORACLE_HOME/opmn/logs/ipm.log

Apache, Jserv, JVM log files locations:
$IAS_ORACLE_HOME/Apache/Apache/logs/ssl_engine_log
$IAS_ORACLE_HOME/Apache/Apache/logs/ssl_request_log
$IAS_ORACLE_HOME/Apache/Apache/logs/access_log
$IAS_ORACLE_HOME/Apache/Apache/logs/error_log
$IAS_ORACLE_HOME/Apache/JServ/logs

Concurrent log file location:
$APPL_TOP/admin/PROD/log or $APPLLOG/$APPLCSF

Patch log file location:
$APPL_TOP/admin/PROD/log

Worker Log file location:
$APPL_TOP/admin/PROD/log

AutoConfig log files location:
Application Tier:
$APPL_TOP/admin/SID_Hostname/log//DDMMTime/adconfig.log

Database Tier:
$ORACLE_HOME/appsutil/log/SID_Hostname/DDMMTime/adconfig.log

Error log file location:
Application Tier:
$APPL_TOP/admin/PROD/log


In Oracle Applications R12, the log files are located in $LOG_HOME (which moved to $INST_TOP/logs)
Below list of log file locations could be helpful for you:

Concurrent Reqeust related logs
$LOG_HOME/appl/conc - > location for concurrent requests log and out files
$LOG_HOME/appl/admin - > location for mid tier startup scripts log files

Apache Logs (10.1.3 Oracle Home which is equivalent to iAS Oracle Home - Apache, OC4J and OPMN)
$LOG_HOME/ora/10.1.3/Apache - > Location for Apache Error and Access log files
$LOG_HOME/ora/10.1.3/j2ee - > location for j2ee related log files
$LOG_HOME/ora/10.1.3/opmn - > location for opmn related log files

Forms & Reports related logs (10.1.2 Oracle home which is equivalent to 806 Oracle Home)
$LOG_HOME/ora/10.1.2/forms
$LOG_HOME/ora/10.1.2/reports

Startup/Shutdown Log files location:
$INST_TOP/apps/$CONTEXT_NAME/logs/appl/admin/log

Patch log files location:
$APPL_TOP/admin/$SID/log/ 

Clone and AutoConfig log files location in Oracle E-Business Suite Release 12 

Logs for the adpreclone.pl are located: 
On the database tier: 
RDBMS $ORACLE_HOME/appsutil/log/< context >/StageDBTier_< timestamp >.log 

On the application tier: 
$INST_TOP/admin/log/StageAppsTier_< timestamp >.log 

Where the logs for the admkappsutil.pl are located? 
On the application tier: 
$INST_TOP/admin/log/MakeAppsUtil_< timestamp >.log 


06 February 2011

Changing the Priority of a Pending or Inactive request

Changing the Priority of a Pending or Inactive request

Requests normally run according to start time, on "first-submitted, first-run" basis. However, a higher priority request starts before an earlier request. As System Administrator, you can change the priority of any Pending or Inactive request using the Requests window.

Request Priority is associated with an application User

The priority of a user's requests defaults to the value you, as System Administrator, set for their Concurrent:Priority user profile option. Users cannot change the priority of their requests. If a concurrent program has a defined priority, that priority overrides the user's profile option.

    • Priorities range from 1 (highest) to 99 (lowest).
    • The standard default is 50.
    • Concurrent programs submitted by the Internal Concurrent Manager have a priority of zero (0), and override all other requests.

How to Add Log file in Oracle Database

If you are executing below query you will get the current log file and location below query and sample output
Query:- 
select * from v$logfile;


Output:-
GROUP#,STATUS,TYPE,MEMBER,IS_RECOVERY_DEST_FILE
2,,ONLINE,/testdata/r02/oradata/log02a.dbf,NO
2,,ONLINE,/testdata/r02/oradata/log02b.dbf,NO
1,,ONLINE,/testdata/r03/oradata/log01a.dbf,NO
1,,ONLINE,/testdata/r03/oradata/log01b.dbf,NO

Adding LogFile

ALTER DATABASE ADD LOGFILE MEMBER '/testdata/r03/oradata/log01c.dbf' TO GROUP 1;
ALTER DATABASE ADD LOGFILE MEMBER '/testdata/r03/oradata/log02c.dbf' TO GROUP 2;


GROUP#,STATUS,TYPE,MEMBER,IS_RECOVERY_DEST_FILE

select * from v$logfile;

2,,ONLINE,/testdata/r02/oradata/log02a.dbf,NO
2,,ONLINE,/testdata/r02/oradata/log02b.dbf,NO
1,,ONLINE,/testdata/r03/oradata/log01a.dbf,NO
1,,ONLINE,/testdata/r03/oradata/log01b.dbf,NO
2,,INVALID,/testdata/r02/oradata/log02c.dbf,NO
1,,INVALID,/testdata/r03/oradata/log01c.dbf,NO
Your logfile is added but status is INVALID so please execute below Query

ALTER SYSTEM SWITCH LOGFILE;
ALTER SYSTEM SWITCH LOGFILE;

ALTER SYSTEM CHECKPOINT;

select * from v$logfile;
Output:-
GROUP#,STATUS,TYPE,MEMBER,IS_RECOVERY_DEST_FILE
2,,ONLINE,/testdata/r02/oradata/log02a.dbf,NO
2,,ONLINE,/testdata/r02/oradata/log02b.dbf,NO
1,,ONLINE,/testdata/r03/oradata/log01a.dbf,NO
1,,ONLINE,/testdata/r03/oradata/log01b.dbf,NO
2,,ONLINE,/testdata/r02/oradata/log02c.dbf,NO
1,,ONLINE,/testdata/r03/oradata/log01c.dbf,NO

03 February 2011

Unable to find PD KSH version.

Error:-
[oracle@our12-test bin]$ perl adcfgclone.pl dbTier

                     Copyright (c) 2002 Oracle Corporation
                        Redwood Shores, California, USA

                        Oracle Applications Rapid Clone

                                 Version 12.0.0

                      adcfgclone Version 120.31.12010000.1

Enter the APPS password :

Checking for make...    found - /usr/bin/make
 Checking for ld...     found - /usr/bin/ld
 Checking for gcc...    found - /usr/bin/gcc
 Checking for g++...    found - /usr/bin/g++
 Checking for ar...     found - /usr/bin/ar
 Checking for ksh...
 Unable to find PD KSH version.
 Unable to locate all utilities with system path.
 PATH = /testdb/db/tech_st/11.1.0/appsutil/clone/bin/../jre/bin:/usr/lib64/qt-3.3/bin:/usr/kerberos/bin:/usr/local/bin:/bin:/usr/bin:/etc/opt/emcpower/bin:/home/oracle/bin


WARNING: Could not find all the required OS utilities in the $PATH. Please review the checks above

[oracle@our12-test bin]$

Solution:-

$ export KSH_VERSION='@(#)PD KSH v5.2.14 99/07/13.2'

then problem is resolved

02 February 2011

Step by Step Workflow Mailer configuration

Source the Application ENV
. /VISTEST/PATCH/apps/apps_st/appl/APPSPATCH_our12-dev.env

keytool -genkey -alias bilt -keystore /home/oradev/.keystore

What is your first and last name?
[Unknown]:  Alice
What is the name of your organizational unit?
[Unknown]:  developerWorks
What is the name of your organization?
[Unknown]:  IBM
What is the name of your City or Locality?
[Unknown]:  Winchester
What is the name of your State or Province?
[Unknown]:  Hampshire
What is the two-letter country code for this unit?
[Unknown]:  UK
Is <CN=Alice, OU=developerWorks, O=IBM, L=Winchester, 
ST=Hampshire, C=UK> correct?
[no]:  yes
Get the Server Certification
openssl s_client -host 10.1.0.209 -port 993

keytool -import -file /home/oradev/bilt.crt -keystore /home/oradev/.keystore -alias our12-dev


$AFJVAPRG -classpath $AF_CLASSPATH -Dprotocol=imap \ -Ddbcfile=/VISTEST/PATCH/inst/apps/PATCH_our12-dev/appl/fnd/12.0.0/secure/PATCH.dbc  \ -Dport=993 -Dssl=Y \ -Dtruststore=/home/oradev/.keystore \ -Dserver=10.1.0.208 -Daccount=our12.mailtest -Dpassword=******** \ -Dconnect_timeout=120 -Ddebug=Y \ -DdebugMailSession=Y oracle.apps.fnd.wf.mailer.Mailer

Follow the below Metalink Note

IMAPSSL Workflow Mailer Setup Using Self Signed Certificate [ID 409026.1]
      Modified 22-SEP-2009     Type HOWTO     Status PUBLISHED    

In this Document
  Goal
  Solution

Applies to:
Oracle Workflow Cartridge - Version: 11.5.10 to 11.5.10.2
Information in this document applies to any platform.
4334965, '11i.ATG_PF.H RUP3'
4676589, '11i.ATG_PF.H.RUP4'
Goal

The purpose of this document is to enable customers to use a self signed certificate with the Workflow Mailer for IMAPSSL.  These steps must be followed in order to avoid the untrusted certificate error being thrown by the minimum supported J2SE (JDK) 1.4.2 for the concurrent manager node.  The Workflow Mailer uses the certificate keystore of the J2SE.  Patch 4676589, '11i.ATG_PF.H.RUP4' is minimum recommended version of ATG for users of IMAPSSL.

javax.mail.MessagingException: sun.security.validator.ValidatorException: No trusted certificate found;

ASSUMPTION

The 3rd party IMAP email server is already configured, tested and verified that it will work with IMAPSSL.  Oracle does not provide instructions on how to implement IMAPSSL on 3rd party products.
Solution

1. Source APPSORA.env

2. Place your self signed certificate created for your IMAP Email Server on the Concurrent Manager Node assigned to the Workflow Mailer Service.

3. Use J2SE 1.4.2 and the J2SE(JDK) keytool to create a standalone keystore or import and trust your self signed certificate into the JDK keystore.

    a. Login as the OS user that owns the appsTier containing the Concurrent Manager Server node running the Workflow Mailer Service.

    b. It is better to create a standalone keystore to mimimize maintenance as the J2SE keystore (cacert) will be different everytime the JDK is upgraded to a new version.

    c. Keytool will create a hidden file called .keystore in the OS user home directory.

NOTE:  Keytool is a 3rd party utility whose syntax is not supported by Oracle.  Please research on the Internet if unfamiliar with utility.

4. Test that your keystore is valid from the command line:

a. Connectivity of IMAP server
    ------------------------------
Test invocation is:
$AFJVAPRG -classpath $AF_CLASSPATH -Dprotocol=imap \
( -Ddbcfile=<dbcfileLocation_here> | -Ddbuser -Ddbpassword -Ddburl )\
-Dserver=<servername_here> [-Dport=<port> default 143] \
-Daccount=<accountname_here> -Dpassword=<password_here> \
[ -Dfolder=<foldername_here> ] \
[ -Dconnect_timeout=5 ] \
[ -Dssl= <Y|N> default N ] \
[ -Dtruststore=<truststore_here> ]\
[ -Dconnect_timeout=<seconds> default 5 ] \
[ -Ddebug=<Y|N> default N ]\
[ -Dlogfile=<log filename> default test.log ]\
oracle.apps.fnd.wf.mailer.Mailer

b. IMAPSSL Test Example and Valid Result
----------------------------------------------

 $AFJVAPRG -classpath $AF_CLASSPATH -Dprotocol=imap \
-Ddbcfile=$FND_TOP/secure/VIS_orlncatst-02/vis.dbc.dbc \
-Dport=993 -Dssl=Y \
-Dtruststore=/home/applmgr/.keystore \
-Dserver=gggrant2.us.oracle.com \
-Daccount=orlncatst02 -Dpassword=orlncatst02 \
-Dconnect_timeout=120 -Ddebug=Y \
-Dlogfile=/tmp/garyimaptest.log -DdebugMailSession=Y oracle.apps.fnd.wf.mailer.Mailer

Server gggrant2.us.oracle.com at port 993 is reachable
Debug property -> {true}

DEBUG: getProvider() returning javax.mail.Provider[STORE,imap,com.sun.mail.imap.IMAPStore,Sun Microsystems, Inc]
* OK dovecot ready.
A0 CAPABILITY
* CAPABILITY IMAP4rev1 SORT THREAD=REFERENCES MULTIAPPEND UNSELECT LITERAL+ IDLE CHILDREN LISTEXT LIST-SUBSCRIBED NAMESPACE AUTH=PLAIN
A0 OK Capability completed.
A1 LOGIN orlncatst02 orlncatst02
A1 OK Logged in.
A2 NOOP
A2 OK NOOP completed.
Successfully connected to the IMAP account
Note: Special folders like Inbox/Trash may not get listed on some IMAP servers
Folders defined are:
A3 LSUB "" "*"
* LSUB () "/" "Trash"
* LSUB () "/" "Processed"
A3 OK Lsub completed.
Trash
Processed
A4 LOGOUT
* BYE Logging out
A4 OK Logout completed.
A5 LOGOUT

5. Verify that you have the Workflow Mailer already configured and working on the default non-SSL port 143. If 143 is not available, login to E-Business Suite (EBS) and navigate to Workflow Mailer inside OAM and set Inbound Thread Count = 0 so that you can input the IMAP User Name and Password without validation.

Login to E-Business as a user assigned the System Administrator responsibility and navigate:

System Administrator > Oracle Applications Manager > Workflow > Notification Mailers > Edit > Advanced

6. Run $FND_TOP/sql/afsvcpup.sql from sqlplus to set the following parameters for the Workflow Mailer:

Working Example on ATG RUP3
----------------------------------
NOTE: You can get the component id and parameter id by running these queries:


SELECT component_id, component_name
FROM fnd_svc_components c
WHERE component_name like 'Workflow Notification Mailer'
order by component_id;

COMPONENT_ID COMPONENT_NAME
------------ --------------------------------------------------------------------------------
10006 Workflow Notification Mailer


set pagesize 100
set linesize 132
set feedback off
set verify off
set wrap off

col comp_param_id 999999999
col parameter_value format a35
col component_name format a30

select v.component_parameter_id comp_param_id, v.parameter_value, c.component_name
from fnd_svc_comp_param_vals_v v, fnd_svc_comp_params_b p, fnd_svc_components c, fnd_svc_comp_params_vl vl
where c.component_type = 'WF_MAILER'
and v.component_id = c.component_id
and v.parameter_id = p.parameter_id
and vl.parameter_id = p.parameter_id
and p.parameter_name in ('MAILER_SSL_TRUSTSTORE');

COMP_PARAM_ID PARAMETER_VALUE                     COMPONENT_NAME
------------- ----------------------------------- ----------------------------
        10475 /home/applmgr/.keystore             Workflow Notification Mailer
        11011 NONE                                Cs_MsgsMailer
        10741 NONE                                AG_Mailer
        10521 NONE                                Oracle Alert Email

    a. Example:

    Updating Debug Mail Session:

    sqlplus apps/<apps_pw> @$FND_TOP/sql/afsvcpup.sql


    Enter Component Id:<component id 10006 for Workflow Notification Mailer>


    Enter the Parameter Id to update : <parameter id  10025 for Debug Mail Session >

    You have selected parameter : Debug Mail Session
    Current value of parameter : N

    Enter a value for the parameter : Y

    b. Update the following Parameters:

    10082 Inbound Thread Count 1
    10025 Debug Mail Session Y (Optional setting to obtain diagnostics data and should be set to N after a successful test)
    10140 Inbound SSL Enabled Y
    10475 SSL Trust store /home/applmgr/.keystore (My standalone keystore)

7. Shutdown and restart the Workflow Mailer Service from inside OAM.

8. Confirm that the Workflow Mailer starts and will process inbound responses from the Workflow Mailer inbox.