Friday, July 25, 2014

Some Tips on Exadata

Run Exacheck Report

The Exa-Check report needs to be run from the first DB node. 

Below are the steps : 

1. Login as oracle user(Database user), make a clean directory and load Exachk225(Oracle Exadata Database Machine exachk or HealthCheck (Doc ID 1070954.1). 
2. cd to the directory created 

4. export RAT_IBSWITCH_USER=root (if you do not have the password for the Nm2user) 
3. export RAT_TIMEOUT=120 
4. export RAT_ROOT_TIMEOUT=600 
5. export RAT_PASSWORDCHECK_TIMEOUT=10 
6. ./exachk -a 

answer the prompt to set crs home as "Y". 
select all databases 
answer the prompts for the root password on the storage servers 
answer the prompts for the root userid password on the database servers 
answer the prompts for the nm2user(root) password on the IB switches.


Change password for root User of Exadata DB & Cell Sever

Save all hostname in one file and call that filename into dcli command as follows,

[oracle@dbnode01 ~]$ cat /home/oracle/all_group
dbnode01
dbnode02
cellnode01
cellnode02
cellnode03

[root@dbnode01 ~]# PASSWORD=xxxxx (any password)
[root@dbnode01 ~]# dcli -l root -g /home/oracle/all_group "echo ${PASSWORD} | passwd --stdin root"
dbnode01: Changing password for user root.
dbnode01: passwd: all authentication tokens updated successfully.
dbnode02: Changing password for user root.
dbnode02: passwd: all authentication tokens updated successfully.
cellnode01: Changing password for user root.
cellnode01: passwd: all authentication tokens updated successfully.
cellnode02: Changing password for user root.
cellnode02: passwd: all authentication tokens updated successfully.
cellnode03: Changing password for user root.
cellnode03: passwd: all authentication tokens updated successfully.
[root@dbnode01 ~]#

The same way you can do for rest of the users too in exadata environment.

Wednesday, July 23, 2014

Useful Queries for Oracle Core/Apps/EBS/Exadata Database

1) Query to find out the responsibilities attached to a user in Oracle Application

select b.user_name, c.responsibility_name, a.START_DATE, a.END_DATE from fnd_user_resp_groups_direct a, fnd_user b, fnd_responsibility_tl c
where a.user_id = b.user_id
and a.responsibility_id = c.responsibility_id
and b.user_name='&Username';

2) Query to find out Free Tablespace with Graph in %

set lines 200
select  total.ts tablespace,
        DECODE(total.mb,null,'OFFLINE',dbat.status) status,
    total.mb total_mb,
    NVL(total.mb - free.mb,total.mb) used_mb,
    NVL(free.mb,0) free_mb,
        DECODE(total.mb,NULL,0,NVL(ROUND((total.mb - free.mb)/(total.mb)*100,2),100)) pct_used,
    CASE WHEN (total.mb IS NULL) THEN '['||RPAD(LPAD('OFFLINE',13,'-'),20,'-')||']'
    ELSE '['|| DECODE(free.mb,
                             null,'XXXXXXXXXXXXXXXXXXXX',
                             NVL(RPAD(LPAD('X',trunc((100-ROUND( (free.mb)/(total.mb) * 100, 2))/5),'X'),20,'-'),
        '--------------------'))||']'
         END as GRAPH
from
    (select tablespace_name ts, sum(bytes)/1024/1024 mb from dba_data_files group by tablespace_name) total,
    (select tablespace_name ts, sum(bytes)/1024/1024 mb from dba_free_space group by tablespace_name) free,
        dba_tablespaces dbat
where total.ts=free.ts(+) and
      total.ts=dbat.tablespace_name
UNION ALL
select  sh.tablespace_name,
        'TEMP',
    SUM(sh.bytes_used+sh.bytes_free)/1024/1024 total_mb,
    SUM(sh.bytes_used)/1024/1024 used_mb,
    SUM(sh.bytes_free)/1024/1024 free_mb,
        ROUND(SUM(sh.bytes_used)/SUM(sh.bytes_used+sh.bytes_free)*100,2) pct_used,
        '['||DECODE(SUM(sh.bytes_free),0,'XXXXXXXXXXXXXXXXXXXX',
              NVL(RPAD(LPAD('X',(TRUNC(ROUND((SUM(sh.bytes_used)/SUM(sh.bytes_used+sh.bytes_free))*100,2)/5)),'X'),20,'-'),
                '--------------------'))||']'
FROM v$temp_space_header sh
GROUP BY tablespace_name order by 6;

3) Query To Check Blocking & Waiting Sessions in RAC

select vsb.sid bsid, vsb.serial#, vsb.inst_id binst, vsb.username blocker, vsb.client_identifier bcid, vsb.module bmod,
       vsw.sid wsid, vsw.serial#,  vsw.inst_id winst, vsw.username waiter, vsw.client_identifier wcid, vsw.module wmod,
       trunc(vlw.ctime/60) minutes
  from (select inst_id,sid, id1, id2, ctime from gv$lock where request > 0) vlw,
       (select inst_id,sid, id1, id2, ctime from gv$lock where block > 0) vlb,
       gv$session vsb,
       gv$session vsw
  where vsw.sid=vlw.sid
    and vsb.sid=vlb.sid
    and vsb.inst_id=vlb.inst_id
    and vsw.inst_id=vlw.inst_id
    and vlb.id1=vlw.id1
    and vlb.id2=vlw.id2
order by blocker, minutes desc;

4) Query to find object or statement that is causing excessive redo generation

SELECT dhso.object_name,
sum(db_block_changes_delta)
FROM dba_hist_seg_stat dhss,
dba_hist_seg_stat_obj dhso,
dba_hist_snapshot dhs
WHERE dhs.snap_id = dhss.snap_id
AND dhs.instance_number = dhss.instance_number
AND dhss.obj# = dhso.obj#
AND dhss.dataobj# = dhso.dataobj#
AND begin_interval_time BETWEEN to_date('2012_05_02 04','YYYY_MM_DD HH24') AND to_date('2012_05_02 07','YYYY_MM_DD HH24')
GROUP BY dhso.object_name
order by sum(db_block_changes_delta) desc;

OBJECT_NAME                    SUM(DB_BLOCK_CHANGES_DELTA)
—————————— —————————
XXXXXXX                                     315744448
Find the statement related to it.
SELECT distinct dbms_lob.substr(sql_text,4000,1)
FROM dba_hist_sqlstat dhss,
dba_hist_snapshot dhs,
dba_hist_sqltext dhst
WHERE upper(dhst.sql_text) LIKE '%XXXXXXXXXX%'
AND dhss.snap_id=dhs.snap_id
AND dhss.instance_Number=dhs.instance_number
AND dhss.sql_id = dhst.sql_id and rownum<2;
DBMS_LOB.SUBSTR(SQL_TEXT,4000,1)
——————————————————————————–
update XXXXXXXX set LATEST_VERSION=:1  where ID=:2  and VERSION<:3

5) To find the sid from Concurrent Request ID and associated SQL Statement


SELECT a.request_id, d.sid, d.serial# ,d.osuser,d.process , c.SPID ,d.inst_id
FROM apps.fnd_concurrent_requests a,
apps.fnd_concurrent_processes b,
gv$process c,
gv$session d
WHERE a.controlling_manager = b.concurrent_process_id
AND c.pid = b.oracle_process_id
AND b.session_id=d.audsid
AND a.request_id =&req_id

AND a.phase_code = 'R';

select a.sid, a.serial#, b.sql_text
from gv$session a, gv$sqlarea b
where a.sql_address=b.address

and a.sid = &sid and a.inst_id=&inst_id;

6)  To find Problematic Particular Query through sid on Exadata

set long 50000000 
set pagesize 10000 

select name,value from v$sesstat a, v$statname b where 
(a.STATISTIC# = b.STATISTIC#) and 
(a.sid) = <sid> and 
(name in ( 'cell physical IO interconnect bytes returned by smart scan', 
'physical read IO requests', 
'physical read requests optimized', 
'cell physical IO bytes saved by storage index', 
'cell physical IO bytes eligible for predicate offload', 
'cell num smart IO sessions using passthru mode due to cellsrv', 
'cell num smart IO sessions using passthru mode due to user', 
'cell flash cache read hits', 
'db block gets', 
'db block gets from cache', 
'db block gets from cache (fastpath)', 
'db block gets direct')) order by name;

Tuesday, July 22, 2014

Make EBS R12 Compatible for Mac OS X v10.9.x with Safari Browser (as well as for Windows Client PC also)

We have requirement to open forms of our EBS R12 (12.1.3) Production Instance on Mac OS X v10.9 Client PC with their Safari Browser but it should be still compatible with Windows OS.

To implement this, we have followed below Metalink Note IDs,
  • Recommended Browsers for Oracle E-Business Suite Release 12 (Doc ID 389422.1)
  • Deploying JRE (Native Plug-in) for Windows Clients in Oracle E-Business Suite Release 12 (Doc ID 393931.1)
  • Upgrading OracleAS 10g Forms and Reports in Oracle E-Business Suite Release 12 (Doc ID 437878.1)
  • Using JDK 7.0 Latest Update with Oracle E-Business Suite Release 12.0 and 12.1 (Doc ID 1467892.1)

1) Issues Faced While Applying OPatch for 10g AS 10.1.2.3,


OPATCH_JAVA_ERROR=CHECKCONFLICT: OPATCH CANNOT PROCESS OVERLAY PATCHES BECAUSE OF NO OUI SUPPORT. PLEASE TAKE LATEST OUI 10.1 PATCHSET FROM "MY ORACLE SUPPORT" AND TRY AGAIN.
Solution: http://manishnashikkar.blogspot.in/2014/07/opatchjavaerrorcheckconflict-opatch.html

2) Issue faced while opening form in Windows :

Unsigned Entry in Resource Error

java.lang.SecurityException: com.sun.deploy.net.JARSigningException: Found unsigned entry in resource: http://server1.example.com:10403/OA_JAVA/oracle/apps/fnd/jar/fndforms.jar 

Workaround : 

If you are unable to upgrade your JDK at this time, you can workaround this issue by turning off Java caching through the Java Control Panel on the desktop:
Java Control Panel -> General (tab) -> Settings (button) -> Keep Temporary Files on the Computer (Uncheck)

Solution :

1. Upgrade the JDK version of your application tier node by following the appropriate document below: 
  • Using Latest Java 6.0 Update With Oracle E-Business Suite Release 12 (Document 455492.1)
  • Using JDK 7.0 Latest Update with Oracle E-Business Suite Release 12.0 and 12.1 (Document 1467892.1)
2. Regenerate the jar files using the 'force' option through adadmin.


Monday, July 21, 2014

OPATCH_JAVA_ERROR=CHECKCONFLICT: OPATCH CANNOT PROCESS OVERLAY PATCHES BECAUSE OF NO OUI SUPPORT. PLEASE TAKE LATEST OUI 10.1 PATCHSET FROM "MY ORACLE SUPPORT" AND TRY AGAIN.


[ebsmac@applusr 11710576]$ opatch apply

Oracle Interim Patch Installer version 1.0.0.0.64
Copyright (c) 2011 Oracle Corporation. All Rights Reserved..

Oracle recommends you to use the latest OPatch version
and read the OPatch documentation available in the OPatch/docs
directory for usage. For information about the latest OPatch and
other support-related issues, refer to document ID 293369.1
available on My Oracle Support (https://myoraclesupport.oracle.com)

Oracle Home           : /s001/apps/tech_st/10.1.2
Oracle Home Inventory : /apps1/apps/tech_st/10.1.2/inventory
Central Inventory     : /apps1/oraInventory
   from               : /etc/oraInst.loc
OUI location          : /apps1/apps/tech_st/10.1.2/oui
OUI shared library    : /apps1/apps/tech_st/10.1.2/oui/lib/linux/liboraInstaller.so
Java location         : /apps1/apps/tech_st/10.1.2/jre/1.4.2/bin/java
Log file location     : /s001/apps/tech_st/10.1.2/.patch_storage/<patch ID>/*.log

Creating log file "/s001/apps/tech_st/10.1.2/.patch_storage/11710576/Apply_11710576_03-10-2013_21-02-24.log"

Invoking fuser to check for active processes.

OPATCH_JAVA_ERROR=CheckConflict: OPatch cannot process overlay patches because of no OUI support. Please take latest OUI 10.1 patchset from "My Oracle Support" and try again.
Cannot check bug/file conflict and component prerequisite checks.

ERROR: OPatch failed during prerequisite check.
[ebsmac@m1tstap01 11710576]$


Solution :-

Apply below OUI patch

p6640838_10106_Linux-x86-64.zip    OUI CD PLACE HOLDER ON ARU FOR 10106

IMPORTANT:
The OUI version must be 10.1.x.x.x. The latest 10.1.x.x.x version can be downloaded from MOS.
Refer to Patch 6640838
Please verify that you select a 10.1.x.x.x version.  Do NOT select 10.2.x.x.x or 11.x.x.x versions.

This patch should be applied to the Forms ORACLE_HOME that is going to be patched with the overlay technique. This means Forms Bundle Patch:9593176 - or higher needs to be installed in this ORACLE_HOME.
This is a requirement for installing overlay patches.
The overlay patch must have been built on top of the Bundle Patch installed.
Do not get confused when the version number of the OUI  patch is 10.1.0.6.0, the OUI version you have already installed.
The version number was not changed when creating the patch, but missing components have been added.

Reference :-

How to patch OUI for installing overlay patches on top of Forms Bundle Patch - 9593176 [ID 1301320.1]

Steps for the Installation of the OUI patch:

1. Unzip the patch.

2. Run 'runInstaller' from the ..cd\Disk1\install directory

3. Click "Next" on the Welcome page.

4. Select the ORACLE_HOME of your existing Forms installation with Bundle Patch applied.

5. Click <Next>.

6.  Choose the install type of "Custom".



7. Click <Next>.

8. On the "Available Product Components" page, check the "Show all components, including required dependencies" checkbox.
9. Click the "Expand All" button.



10.  Under "Oracle Universal Installer 10.1.0.6.0" -> "Required Dependencies" ->

Click on "Installer SDK Component 10.1.0.6.0".

This will automatically select the other two instances of this option.



11. Click <Next>.
Note:  Depending on the configuration of your machine you may receive a screen entitled "Locate JDK Home" if the JDK home is not automatically found.  If you do see this screen, then accomplish step 12.

12.  Select a valid JDK directory.  Choose the JDK from the ORACLE_HOME you are patching:

Choose directory ORACLE_HOME\jdk where ORACLE_HOME is the ORACLE_HOME of your existing Forms installation where the Bundle Patch (9593176) was applied.

13. Press <Next>

14. On the "Summary - Oracle Installation Products 10.1.6.0" screen, you will something similar to the following. It may differ slightly but generally should look as follows:

Reinstallations (1 product)

--Installer SDK Component 10.1.0.6.0

Upgrades (2 products) (Note: May say 1 product if JRE 1.4.2.4 was already installed)

--Java Runtime Environment 1.4.2.4.0
--Oracle One-off Patch Install 10.1.0.6.1

New Installations (2 products) (Note: May say 3 products and include Oracle Software Packager 10.1.0.6.0 if it needs to be installed)

--Oracle Installation Libraries 10.1.0.6.0
--Oracle Installation Products 10.1.0.6.0

Already Installed (2 Products) (Note: May say 3 Products if  JRE 1.4.2.0.4 needs to be installed)

--Oracle Universal Installer 10.1.0.6.0
--Sun JDK 1.4.2.0.6



15. Click <Install> to complete this installation


It is important that OPatch be  version 1.0.0.0.62 at this point so verify this patch installed OPatch 1.0.0.0.62

Verify the OPatch version by executing "opatch version" in the Forms ORACLE_HOME/OPatch
directory or by having this directory as part of the PATH environment variable.

After OPatch has been installed, ensure the PATH environment variable contains the correct location.

At this point, the OUI and OPatch utilities are installed and ready to apply overlay patches.
Each overlay patch will contain a README.txt file that will provide specific
installation instructions, but all will require this OUI and OPatch configuration.

Overlay patches can now be installed on top of Forms Bundle Patch.

Result:-
[ebsmac@applusr 11710576]$ opatch apply

Oracle Interim Patch Installer version 1.0.0.0.64
Copyright (c) 2009 Oracle Corporation. All Rights Reserved..

Oracle recommends you to use the latest OPatch version
and read the OPatch documentation available in the OPatch/docs
directory for usage. For information about the latest OPatch and
other support-related issues, refer to document ID 293369.1
available on My Oracle Support (https://myoraclesupport.oracle.com)

Oracle Home           : /s001/apps/tech_st/10.1.2
Oracle Home Inventory : /apps1/apps/tech_st/10.1.2/inventory
Central Inventory     : /apps1/oraInventory
   from               : /etc/oraInst.loc
OUI location          : /apps1/apps/tech_st/10.1.2/oui
OUI shared library    : /apps1/apps/tech_st/10.1.2/oui/lib/linux/liboraInstaller.so
Java location         : /apps1/apps/tech_st/10.1.2/jre/1.4.2/bin/java
Log file location     : /s001/apps/tech_st/10.1.2/.patch_storage/<patch ID>/*.log

Creating log file "/s001/apps/tech_st/10.1.2/.patch_storage/11710576/Apply_11710576_03-10-2013_21-18-39.log"

Invoking fuser to check for active processes.


Patch "11710576" overlays " 9593176 ". Conflict check between them is skipped.

Provide your email address to be informed of security issues, install and
initiate Oracle Configuration Manager. Easier for you if you use your My
Oracle Support Email address/User Name.
Visit http://www.oracle.com/support/policies.html for details.
Email address/User Name:

You have not provided an email address for notification of security issues.
Do you wish to remain uninformed of security issues ([Y]es, [N]o) [N]:  y
Oracle Configuration Manager has been installed but not configured. OCM enables
Oracle to provide superior, proactive support for our customers. Oracle
strongly recommends customers configure OCM. To complete the configuration of
OCM, refer to the OCM Installation and Administration Guide
(http://www.oracle.com/technology/documentation/ocm.html).
Backing up comps.xml ...

OPatch detected non-cluster Oracle Home from the inventory and will patch the local system only.


Please shut down Oracle instances running out of this ORACLE_HOME
(Oracle Home = /s001/M1DEV01/apps/tech_st/10.1.2)
Is this system ready for updating?
Please respond Y|N >
y
Applying patch 11710576...

Patching copy files...



Inventory is good and does not have any dangling patches.


Updating inventory...

Verifying patch...
Backing up comps.xml ...


OPatch succeeded.
[ebsmac@applusr 11710576]$

The same issue, I also faced for Patch 17303472: MERGE REQUEST ON TOP OF 10.1.2.3.2PSU FOR BUGS 16784403 6166808 13913713

Tuesday, July 15, 2014

Global Checkpoint, Log Switches & Kill Sessions in RAC


Below are 3 commands are useful in RAC Environment,

Make switching the logfile for all instances in a RAC environment with Single command,

SQL> ALTER SYSTEM SWITCH ALL LOGFILE; (Make sure that your RAC Database is in Archivelog Mode)

Make Checkpoint for all Instances in a RAC environment with single command,

SQL> ALTER SYSTEM CHECKPOINT GLOBAL; (LOCAL is default)

Suppose you want to kill inactive/particular multiple sessions from RAC Database, then below query might be useful,

SQL> set  pages 0
SQL> spool kill.sql
SQL> select 'alter system kill session ' ||''''||SID ||','||SERIAL#||''||',@'||INST_ID||''''||';' from gv$session where status='INACTIVE'; 
SQL>spool off
SQL> @kill.sql

## change in where clause, if you need to kill some different sessions

Cheers,
Manish

Sunday, July 13, 2014

Ora-7445 [Ioc_pin_shared_executable_object()]

Today, we have continuously hitting "Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x0] [PC:0x2FE4812, ioc_pin_shared_executable_object()+882] [flags: 0x0, count: 1] Mon Jul 14 11:21:45 2014" in the Alert log of 1st Node of our Production EBS RAC Database. (Version is 11.2.0.3)

After some troubleshooting, I got reason behind this issue, the error is most often related to an inconsistency that has been detected between the java shared object loaded in memory and the backing store image stored on disk as a result of calling java code and having the JIT compiler enabled. 

I.E. parameter java_jit_enabled=true (this is the default). 

These backing store images are created wherever shm_open() puts them. This can vary on different platforms. 

For Example:

On Solaris these files are written to /tmp and have names like .SHMDJOXSHM_EXT_... 

On Linux these files are written to /dev/shm and have names like JOXSHM_EXT_...


In our case somebody has by mistaken deleted files from /dev/shm and after which we started facing this issue.

Troubleshooting

The JIT compiler runs as an MMON slave. You can use a system tracer such as TUSC to see what it is doing as follows: 

1) Connect as sys 

2) Run the following command to get MMON process id for the instance

ps -ef | grep -i MMON


TIP: if several instances are running on the server then use the ORACLE_SID to identify the correct MMON process

3) Run tusc on the mmon process pid 

i.e attach to a running process. Send output to /tmp/tusc.out 

% tusc -faepo /tmp/tusc.out -p <pid> 

4) From the session in step 1 run, SELECT SYS.DBMS_JAVA.LONGNAME('FOO') FROM DUAL; that fails with the error. 

If ORA-7445 [ioc_pin_shared_executable_object] is encountered, one should look into the following: 

1) Is there any user or job that may have tried to clean up files in the directory where the backing store images are located? 

2) Is the location where the backing store files are located out of space? 

3) Is the location where the backing store files are located accessible? 


Workarounds

1) Disable the just-in-time(JIT) compiler for Oracle JVM environment by setting the following initialization parameter as shown: java_jit_enabled = false 

2) Cleanly shutdown and startup the database. This should clean out all old backing store images associated with this instance and start creating new ones as java is accessed again. 

Additional Information

It is sometimes asked if there is a way to redirect these backing store images to another location.

This functionality is available with the following bug fix:
Patch 13574534 - JAVA JIT COMPILER GENERATING LOT OF STALE FILES (IE) *JOXSHM* IN \TMP DIRECTORY

After the fix is applied, set the parameter _ncomp_shared_objects_dir to the location where you want to redirect the backing store images.

Reference: Ora-7445 [Ioc_pin_shared_executable_object()] (Doc ID 1316906.1)
Applies to: Oracle Database 11.1.0.7 and later

How to set Kernel Parameters in AIX?

One of my New IBM 7.1  Server, I was hitting this issue while working on Putty,

bash: fork: retry: There are no child processes.
bash: fork: retry: There are no child processes.
bash: fork: retry: There are no child processes.
bash: fork: retry: There are no child processes.

bash: fork: Resource temporarily unavailable

This was due to less maxuproc processes which later changed to higher value i.e.  8192 per user, and issue resolved.

Unlike many other UNIX operating systems, AIX does not provide the ability to directly configure most kernel parameters. Instead, the AIX kernel dynamically allocates and reallocates resources as they are needed (up to a predefined limit).
To see all the current values assigned to the kernel parameters, enter:
# lsattr -E -l sys0
or
# smit chgsys ( Change / Show Characteristics of Operating System)
To see the current values assigned to for example maxuproc, enter:
# lsattr -E -l sys0 -a maxuproc
maxuproc 128 Maximum number of PROCESSES allowed per user True

To change the value assigned to maxuproc parameter, enter:
# chdev -l sys0 -a maxuproc=1000
sys0 changed 

or
# smit chgsys
The following is another command that writes system wide configuration variable values to the standard output:
# getconf -a
AIO_LISTIO_MAX: 4096
AIO_MAX: 4096
AIO_PRIO_DELTA_MAX: 0
ARG_MAX: 24576
ATEXIT_MAX: 2048
BC_BASE_MAX: 99
BC_DIM_MAX: 2048
BC_SCALE_MAX: 99
BC_STRING_MAX: 2048
BOOT_DEVICE: hdisk0
CHARCLASS_NAME_MAX: 14
CHAR_BIT: 8
CHAR_MAX: 255
CHAR_MIN: 0
CHILD_MAX: 128
CLK_TCK: 100
COLL_WEIGHTS_MAX: 4
CS_PATH: /usr/bin:/usr/vac/bin
DELAYTIMER_MAX: 32
EXPR_NEST_MAX: 32
FILESIZEBITS: undefined
HARDWARE_BITMODE: 64
HOST_NAME_MAX: 256
To see the current value assigned to for example CS_PATH, enter:
# getconf CS_PATH
/usr/bin:/usr/vac/bin

How to find out the IBM XL C/C++ Compiler Version for EBS on AIX Server ?

# lslpp -l | grep vacpp

root@ebs01:/#lslpp -l | grep vacpp
  vacpp.Bnd                 12.1.0.0  COMMITTED  IBM XL C/C++ Media Defined
  vacpp.cmp.aix50.lib
  vacpp.cmp.aix50.tools
  vacpp.cmp.aix52.lib
  vacpp.cmp.aix52.tools
  vacpp.cmp.aix53.lib       12.1.0.0  COMMITTED  IBM XL C/C++ Libraries for AIX
  vacpp.cmp.aix53.tools     12.1.0.0  COMMITTED  IBM XL C/C++ Tools for AIX 5.3
  vacpp.cmp.core            12.1.0.0  COMMITTED  IBM XL C/C++ Compiler
  vacpp.cmp.include         12.1.0.0  COMMITTED  IBM XL C/C++ Compiler Include
  vacpp.cmp.lib             12.1.0.0  COMMITTED  IBM XL C/C++ Libraries
  vacpp.cmp.rte             12.1.0.0  COMMITTED  IBM XL C/C++ Compiler
  vacpp.cmp.tools           12.1.0.0  COMMITTED  IBM XL C/C++ Tools
  vacpp.lic                 12.1.0.0  COMMITTED  IBM XL C/C++ Licence Files
  vacpp.licAgreement        12.1.0.0  COMMITTED  IBM XL C++ Electronic License
  vacpp.man.en_US           12.1.0.0  COMMITTED  IBM XL C/C++ Compiler Man
  vacpp.memdbg.aix50.lib
  vacpp.memdbg.aix50.rte
  vacpp.memdbg.aix52.lib
  vacpp.memdbg.aix52.rte
  vacpp.memdbg.aix53.lib    12.1.0.0  COMMITTED  IBM XL C/C++ User Heap/Memory
  vacpp.memdbg.aix53.rte    12.1.0.0  COMMITTED  IBM XL C/C++ User Heap/Memory
  vacpp.memdbg.lib          12.1.0.0  COMMITTED  IBM XL C/C++ User Heap and
  vacpp.memdbg.rte          12.1.0.0  COMMITTED  IBM XL C/C++ User Heap and
  vacpp.msg.en_US.cmp.core  12.1.0.0  COMMITTED  IBM XL C/C++ Compiler
  vacpp.msg.en_US.cmp.tools
  vacpp.ndi                 12.1.0.0  COMMITTED  IBM XL C/C++ Non-Default
  vacpp.pdf.en_US           12.1.0.0  COMMITTED  IBM XL C/C++ Documentation
  vacpp.samples.ansicl      12.1.0.0  COMMITTED  IBM XL C/C++ Compiler ANSI

  vacpp.cmp.core            12.1.0.0  COMMITTED  IBM XL C/C++ Compiler

To get IBM AIX Server Details,

# prtconf | more

To Unlock user in AIX,

# chuser unsuccessful_login_count=0 <username>

# chuser account_locked=false <username>

To start X11 in AIX

Turn on X11Forwarding in /etc/ssh/sshd_config and restart sshd.

Find X11Forwarding and make sure its uncommented and set to yes.

X11Forwarding yes

#stopsrc -s sshd; startsrc -s sshd


vi /etc/ssh/sshd_config

Reference: 1294357.1 - New Oracle E-Business Suite R12 Operating System and Tools Requirements on IBM AIX on Power Systems

Oracle E-Business Suite Installation and Upgrade Notes Release 12 (12.1.1) for IBM AIX on Power Systems (64-bit) (Doc ID 761569.1)

Friday, July 11, 2014

After Cloning DB Tier Service Name Shows PROD (Source Database) Name

After Cloning DB Tier, Service Name shows like this. (The same also name also reflecting in lsnrctl status UAT)  This is wrong, So we need do the folloing steps.

Error Message:

sql > show parameter service

service_names string UAT, SYS$APPLSYS.WF_CONTROL.PROD.DOYENSYS.COM

Solutions:

Step 1: Shut down the Apps Tier, if it's up (adstpall.sh).

Then Go to respective Directory.

/UAT/oracle/uatappl/fnd/11.5.0/patch/115/sql

$ ls -lrt wfctqrec.sql

-----wfctqrec.sql

step 2:SQL> sqlplus apps/passwd
SQL> @wfctqrec.sql applsys passwd

Step 3: Bounce the DB and Local Listener in Both RAC Nodes (using srvctl)

Setp 4: Start Both Nodes and Listener

Step 5: Now check the show parameter service, It shows


After finishing above tasks, its changed.

sql > show parameter serviceservice_names string UAT

Tuesday, July 8, 2014

oracle.apps.fnd.framework.OAException: Illegal method call because there is no database connection

Issues while login to EBS R12

oracle.apps.fnd.framework.OAException: Illegal method call because there is no database connection

Error while invoking Main Menu. java.io.FileNotFoundException: /opt/oracle/EBSDEV/apps/inst/apps/EBSDEV_mkkappsserver1/appl/fnd/12.0.0/secure/EBSDEV.dbc (Too many open files)

# Shutdown EBS Services (adstpall.sh / adopmnctl.sh)
# Run the following command to clear out the states and persistence files
rm $ORA_CONFIG_HOME/10.1.3/opmn/logs/states/*
rm -fr $INST_TOP/ora/10.1.3/j2ee/oacore/persistence/*
rm -fr $INST_TOP/ora/10.1.3/j2ee/oafm/persistence/*
rm -fr $INST_TOP/ora/10.1.3/j2ee/forms/persistence/*

Restart services and monitor the instance


Cheers !!!!!!!!!!!!

CELL-02559:There is a communication error between MS and CELLSRV


To See the Exadata Storage cell status we can run the following command :

CellCLI> list cell detail

At the bottom of output there are following three lines to indicate the exadata storage software components and status 

         cellsrvStatus:          running
         msStatus:               running
         rsStatus:               running

Which represent that exadata storage is running fine.

This morning I was getting CELL-02559:There is a communication error between MS and CELLSRV.

I have restarted the services and then it becomes in good state again.
CellCLI> alter cell restart services all