Mobile Apps for Oracle E-Business Suite

August 25, 2014

With smart phones(android+ios) lots of people want to use apps on their business. Steven Chan published one nice post at his blog…
Enjoy it

 

Mobile Apps for Oracle E-Business Suite


ORA-39002: ORA-39166: during import from full export

August 20, 2014

As a DBA We are using export/import utulity many times during our daily process.
I have face this error trying to import only one table from full export.

ORA-39002: invalid operation
ORA-39166: ObjectUSER1.TABLE was not found.

Read the rest of this entry »


CRS-4402: The CSS daemon was started in exclusive mode but found an active CSS daemon on node oda2-1, number 1, and is terminating”

July 9, 2014

We face with this error while We are making 2 node RAC installation

Db version : 11.2.0.4
Os : AIX 7.1

We run root.sh on node 1 without any issue. While we run root.sh node 2 we face this message:

Adding Clusterware entries to inittab
CRS-4402: The CSS daemon was started in exclusive mode but found an active CSS daemon on node Node1, number 1, and is terminating
An active cluster was found during exclusive start-up, restarting to join the cluster
Configure Oracle Grid Infrastructure for a Cluster … succeeded

Read the rest of this entry »


WAIT FOR EMON PROCESS NTFNS

June 19, 2014

WAIT FOR EMON PROCESS NTFNS

We face this event on our 10.2.0.4.0 database. This is 2 node RAC system which is running on AIX 6.1

Read the rest of this entry »


Message 3511 not found; No message file for product=network, facility=TNSTNS-03505: Message 3505 not found; No message file for product=network, facility=TNS

February 14, 2014

You may hit TNSTNS-03505 Message 3511 error message while you are trying to use tnsping command.Complete error message is:

Message 3511 not found; No message file for product=network, facility=TNSTNS-03505: Message 3505 not found; No message file for product=network, facility=TNS

You may hit this error while on database machine or machine which only has client installataion.

I have been face this problem on machine which has 11g client. Also the user is not installation user,so  We have been created one other user and give that user to development team.

My installation user is oracle, development user is oracle1… Both user group are same(dba)

Even I can use tnsping with oracle user i can get response, but wiht oracle 1 I am hitting below error

With Oracle user:
[oracle@client_machine]</oracle11g/app/oracle/product/11.2.0/client_1/bin>tnsping DB_NAME

TNS Ping Utility for IBM/AIX RISC System/6000: Version 11.2.0.4.0 – Production on 14-FEB-2014 11:08:13

Copyright (c) 1997, 2013, Oracle. All rights reserved.

Used parameter files:
/oracle11g/app/oracle/product/11.2.0/client_1/network/admin/sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = xxx)(PORT = 1525)) (ADDRESS = (PROTOCOL = TCP)(HOST = xxx)(PORT = 1525)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = xxx)))
OK (0 msec)

With Oracle1 user:
[oracle1@client_machine]</oracle11g/app/oracle/product/11.2.0/client_1/bin> tnsping DB_NAME

TNS Ping Utility for IBM/AIX RISC System/6000: Version 11.2.0.4.0 – Production on 14-FEB-2014 11:05:05

Copyright (c) 1997, 2013, Oracle. All rights reserved.

Message 3511 not found; No message file for product=network, facility=TNSTNS-03505: Message 3505 not found; No message file for product=network, facility=TNS

So issue has been solved by below steps:

At oracle1 user I have been set below parameter to .profile

export ORACLE_BASE=/oracle11g/app/oracle
export ORACLE_HOME=/oracle11g/app/oracle/product/11.2.0/client_1
PATH=$ORACLE_HOME/bin:$ORACLE_HOME/OPatch:$PATH

[oracle1@client_machine]</oracle11g/app/oracle/product/11.2.0/client_1/bin> tnsping DB_NAME
TNS Ping Utility for IBM/AIX RISC System/6000: Version 11.2.0.4.0 – Production on 14-FEB-2014 11:08:13

Copyright (c) 1997, 2013, Oracle. All rights reserved.

Used parameter files:
/oracle11g/app/oracle/product/11.2.0/client_1/network/admin/sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = xxx)(PORT = 1525)) (ADDRESS = (PROTOCOL = TCP)(HOST = xxx)(PORT = 1525)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = xxx)))
OK (0 msec)

If you are on db server than you also need to set ORACLE_SID.


Oracle E-Business Suite Release 12.2.2 Media Pack v1 for Linux x86-64-bit avaliable NOW!

September 19, 2013

Hi Friends;

Finally Oracle E-Business Suite Release 12.2.2 Media Pack is available at e-delivery site.

For a now it has been published for linux x86-64.

Setup size almost 83G

Here is the some notes:

Read the rest of this entry »


LsInventorySession failed: OracleHomeInventory::load() gets null oracleHomeInfo

September 17, 2013

I faced with that error message while I was trying to apply 10.2.0.4 patch on AIX 6.1

Here is the my steps:

1. Error  Message:

[oracle@test]</u01/app/oracle/product/10.2.0/OPatch>opatch lsinventory

Invoking OPatch 10.2.0.3.0

Oracle interim Patch Installer version 10.2.0.3.0
Copyright (c) 2005, Oracle Corporation. All rights reserved..
Oracle Home : /u01/app/oracle/product/10.2.0
Central Inventory : /u01/app/oracle/oraInventory
from : /etc/oraInst.loc
OPatch version : 10.2.0.3.0
OUI version : 10.2.0.3.0
OUI location : /u01/app/oracle/product/10.2.0/oui
Log file location : /u01/app/oracle/product/10.2.0/cfgtoollogs/opatch/opatch2013-09-17_10-42-49AM.log

List of Homes on this system:

Inventory load failed… OPatch cannot load inventory for the given Oracle Home.
Possible causes are:
Oracle Home dir. path does not exist in Central Inventory
Oracle Home is a symbolic link
Oracle Home inventory is corrupted
LsInventorySession failed: OracleHomeInventory::load() gets null oracleHomeInfo

OPatch failed with error code 73

Read the rest of this entry »


Follow

Get every new post delivered to your Inbox.