Skip to main content

Posts

Showing posts from 2013

How to check if your 11i exact version -- Specially 11.5.9

To check any 11i version, Oracle provides a standard table APPS.FND_PRODUCT_GROUPS.

Execute the statement below to get the exact version,

1. Following is on a 11.5.9 instance.

SQL> select release_name from apps.fnd_product_groups;

RELEASE_NAME
--------------------------------------------------
11.5.9


11.5.9 comes with 2 updates. 11.5.9.CU1 and 11.5.9.CU2.

To check if you are on 11.5.9.2, execute the following statement to check if CU2 update patch has been applied on your instance.

SQL> select 'You are on 11.5.9.2'
from ad_bugs
where bug_number = '3171663';

'YOUAREON11.5.9.2'
-------------------
You are on 11.5.9.2




2. Follwing is on a 11.5.10 instance.


SQL> select release_name from apps.fnd_product_groups;

RELEASE_NAME
--------------------------------------------------
11.5.10.2


3. Follwing is on a R12 instance.


SQL> select release_name from apps.fnd_product_groups;

RELEASE_NAME
--------------------------------------------------
12.1.3 


ORA-28000: the account is locked for SCOTT

First time you try to login as scott/tiger, it would throw an error as shown below,



To get rid of this error, login as SYSTEM for password use the password that was speficied during step3 of this installation process.
Once logged in, use the sql statement below to unlock scott user.

Once this is done, login as scott tiger and it should work. It might as to change the old password with a new one, In this case use "tiger" as old password.

IBM/AIX RISC System/6000 Error: 13: Permission denied

While starting listener on Oracle Applications through adalnctl.sh exited with,

adalnctl.sh: exiting with status 1

Following was found in the log file.

LSNRCTL for IBM/AIX RISC System/6000: Version 8.0.6.3.0 - Production on 25-JAN-2013 03:49:52

(c) Copyright 1999 Oracle Corporation.  All rights reserved.

Connecting to (ADDRESS=(PROTOCOL=TCP)(Host=XXX)(Port=1626))
TNS-12224: TNS:no listener
 TNS-12541: TNS:no listener
  TNS-12560: TNS:protocol adapter error
   TNS-00511: No listener
    IBM/AIX RISC System/6000 Error: 79: Connection refused
Starting listener process APPS_XXX.

LSNRCTL for IBM/AIX RISC System/6000: Version 8.0.6.3.0 - Production on 25-JAN-2013 03:49:55

(c) Copyright 1999 Oracle Corporation.  All rights reserved.

Starting /oraapp/ncrmprd6ora/8.0.6/bin/tnslsnr: please wait...

TNSLSNR for IBM/AIX RISC System/6000: Version 8.0.6.3.0 - Production
Log messages written to /oraapp/XX/8.0.6/network/admin/apps_XX.log
Listening on: (ADDRESS=(PROTOCOL=tcp)(DEV=6)(HOST=XXX7)(PORT=1…