Wednesday, January 23, 2013

ORA-24324 & ORA-24323 & ORA-28547


Scenerio
----------
* When installing Oracle 10g Rel 2 (10.2.0.1) - 32 bit Windows
    (on Windows XP - SP3)  using DBCA
-----------------------------------------------------------------------------

ORA-24324: service handle not initialized
ORA-24323: value not allowed
ORA-28547: connection to server failed, probable Oracle Net admin error.



Work around
---------------
Change the sqlnet.ora file  to

SQLNET.AUTHENTICATION_SERVICES = (NONE)

Monday, January 14, 2013

OPatch cannot find a valid oraInst.loc file to locate Central Inventory. OPatch failed with error code 104

OPatch cannot find a valid oraInst.loc file to locate Central Inventory. OPatch failed with error code 104

$ opatch lsinventory
Invoking OPatch 10.2.0.3.0

Oracle Interim Patch Installer version 10.2.0.3.0
Copyright (c) 2010, Oracle Corporation. All rights reserved.

Oracle Home : /ora/app/product/10.2.0/db_1
Central Inventory : n/a
from :
OPatch version : 10.2.0.3.0
OUI version : 10.2.0.3.0
OUI location : /ora/app/product/10.2.0/db_1/oui
Log file location : n/a

Patch history file: /oracle/product/10.2.0/db_1/cfgtoollogs/opatch/opatch_history.txt

OPatch cannot find a valid oraInst.loc file to locate Central Inventory.

OPatch failed with error code 104


Scenerio
----------
oraInst.loc is there in Oracle Inventory directory. In my case, my oracle inventory is /oracle/oraInventory and oraInst was there in /oracle/oraInventory

Work around
---------------
copy oraInst.loc in /etc as oracle user and issue :

$/oracle/product/10.2.0/db_1/OPatch/opatch lsinventory