Unable To Alter User Xxint To Change Password App-Fnd-02704

Unable To Alter User Xxint To Change Password App-Fnd-02704

Follow the metalink Note ID : [ID 753872.1]

FNDCPASS Failing When Using Underscore, Comma, Dollar Sign

Why is FNDCPASS Failing When Using Underscore, Comma, Dollar Sign, and Parentheses as Passwords? Follow the metalink Note ID [ID 553807.1]

How to Generate AUDIT and NOAUDIT Statements

SCRIPT: Generate AUDIT and NOAUDIT Statements for Current Audit Settings

Please follow the metalink Note ID [ID 287436.1]

ld.so.1: rman: fatal: relocation error

unable to connect to RMAN with the following error

ld.so.1: rman: fatal: relocation error: file /opt/app/oracle/product/10.2.0/db_2/bin/rman: symbol kgslctx_: referenced symbol not found
Killed

Reason: LD_LIBRARY_PATH not set 
Solution:

Set the library  path in the .profile for the changes to become permanent.

export ORACLE_HOME=/opt/app/oracle/product/10.2.0/db_1
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH

and then execute the rman command

NODE:TEST:/ora/admin>rman target /

Recovery Manager: Release 10.2.0.5.0 - Production on Fri Apr 1 09:42:12 2011

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

connected to target database:TEST (DBID=3415316409)

RMAN> exit

Recovery Manager complete.

DBV-00600: Fatal Error - [21] [2] [0] [0]

While I was performing a test restore of one of the datafiles, encountered the  following error when  checking the integrity of the file.
NODE:TEST:/ora/admin/testrestore>dbv  file=TEST_get_file_test.f

DBVERIFY: Release 10.2.0.5.0 - Production on Fri Apr 1 09:47:34 2011

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

DBV-00600: Fatal Error - [21] [2] [0] [0]

I have searched metalink for 10.2.0.5  nothing turned  up there is a solution for the same Bug if it appears in 11.1.0.6  - [ID 731546.1]

But I have found the below solution for 10.2.0.5 and it worked.

Solution: 
Provide the full path of  the file even though you are in the same location doesnt matter  you mention the blocksize or not but good to mention

NODE:TEST:/ora/admin/testrestore>dbv file=/ora/admin/testrestore/TEST_get_file_test.f blocksize=8192

DBVERIFY: Release 10.2.0.5.0 - Production on Fri Apr 1 09:59:16 2011

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

DBVERIFY - Verification starting : FILE = /ora/admin/testrestore/TEST_get_file_test.f


DBVERIFY - Verification complete

Total Pages Examined         : 64000
Total Pages Processed (Data) : 0
Total Pages Failing   (Data) : 0
Total Pages Processed (Index): 0
Total Pages Failing   (Index): 0
Total Pages Processed (Other): 14
Total Pages Processed (Seg)  : 0
Total Pages Failing   (Seg)  : 0
Total Pages Empty            : 63986
Total Pages Marked Corrupt   : 0
Total Pages Influx           : 0
Highest block SCN            : 249167 (0.249167)

.

How to Reorganize SYS.AUD$ Table

How to Reorganize SYS.AUD$ Table?

Please follow the metalink note ID: [ID 166301.1]

E-Business Suite Login Gives App-Fnd-01564

E-Business Suite Login Gives App-Fnd-01564: Oracle Error 6550 In Afpoload

Please follow the metalink note ID :[ID 1097297.1]

Master Note for RAC

Master Note for Real Application Clusters (RAC) Oracle Clusterware and Oracle Grid Infrastructure
 

Please follow the metalink  note   [ID 1096952.1]

How to tune sql using DBMS_SQLTUNE

The DBMS_SQLTUNE package provides the interface to tune SQL statements.

You use the CREATE_TUNING_TASK Functions to create a tuning task for tuning a single statement or a group of SQL statements.

The EXECUTE_TUNING_TASK Procedure executes a previously created tuning task.

The REPORT_TUNING_TASK Function displays the results of a tuning task.

You use the SCRIPT_TUNING_TASK Function to create a SQL*PLUS script which can then be executed to implement a set of Advisor recommendation

SQL> variable stmt_task VARCHAR2(64);

SQL> variable sts_task VARCHAR2(64);

SQL> EXEC :stmt_task := DBMS_SQLTUNE.CREATE_TUNING_TASK(begin_snap => 21965, end_snap => 21966, sql_id => 'at18ft6rsb6n4');

PL/SQL procedure successfully completed.

SQL> EXEC DBMS_SQLTUNE.EXECUTE_TUNING_TASK(:stmt_task);

PL/SQL procedure successfully completed.

SQL> EXEC DBMS_SQLTUNE.ACCEPT_SQL_PROFILE(:stmt_task);

How to check deprecated parameters

How to check deprecated  parameters  in any version of oracle:

Solution: From v$parameter view
Heres a sample from version 11.1.0.7

SQL> select NAME from v$parameter where ISDEPRECATED='TRUE';

NAME
--------------------------------------------------------------------------------
lock_name_space
instance_groups
resource_manager_cpu_allocation
buffer_pool_keep
buffer_pool_recycle
max_commit_propagation_delay
log_archive_start
standby_archive_dest
log_archive_local_first
parallel_server
parallel_server_instances

NAME
--------------------------------------------------------------------------------
fast_start_io_target
serial_reuse
max_enabled_roles
remote_os_authent
global_context_pool_size
cursor_space_for_time
plsql_v2_compatibility
plsql_debug
background_dump_dest
user_dump_dest
commit_write

NAME
--------------------------------------------------------------------------------
sql_trace
parallel_automatic_tuning
sql_version
drs_start

26 rows selected.

Tablespace Utilisation Query

 The below query gives a list of the tablespaces, total size, free size in MB, used size in MB and  tablespace  percentage full. This is a very useful query whenever I need  to make any changes to the tablespaces add or decrease the size of existing datafiles.

SQL> select a.tablespace_name, assigned_space "ASSIGNED (MB)", (nvl(free_space,0) + INCRM) "FREE (MB)", (assigned_space - nvl(free_space,0) - INCRM) "USED (MB)",
  ((assigned_space - nvl(free_space,0) - INCRM) / assigned_space)*100 "% Full"
from
(select  tablespace_name, count(*) num1, sum(DECODE(SIGN(maxbytes - bytes), -1, bytes, maxbytes))/(1024*1024) assigned_space, sum(DECODE(SIGN(maxbytes - bytes), -1, bytes, maxbytes))/(1024*1024) - sum(bytes)/(1024*1024) INCRM
from dba_data_files group by tablespace_name) A,
(select  tablespace_name, count(*) num2, (sum(bytes)/(1024*1024)) free_space
from dba_free_space a group by tablespace_name) B
where b.tablespace_name(+)=a.tablespace_name
union all select a.tablespace_name, assigned_space "ASSIGNED (MB)", (nvl(free_space,0) + INCRM) "FREE (MB)", (assigned_space - nvl(free_space,0) - INCRM) "USED (MB)",
((assigned_space - nvl(free_space,0) - INCRM ) / assigned_space)*100 "% Full"
from
(select  tablespace_name, count(*) num1, sum(DECODE(SIGN(maxbytes - bytes), -1, bytes, maxbytes))/(1024*1024) assigned_space,
sum(DECODE(SIGN(maxbytes - bytes), -1, bytes, maxbytes))/(1024*1024) - sum(bytes)/(1024*1024) INCRM from dba_temp_files group by tablespace_name) A,
(select  tablespace_name, count(*) num2, (sum(bytes)/(1024*1024)) free_space
from dba_free_space group by tablespace_name) B
where b.tablespace_name(+)=a.tablespace_name;

Adcfgclone.pl appsTier error: RC-50014: Fatal: Execution of AutoConfig

While performing 11i cloning  the following  error has  occured.

Adcfgclone.pl appsTier error: RC-50014: Fatal: Execution of AutoConfig

Solution:

Please refer to metalink note id [ID 1142333.1]

How to know timing of SQL statements

How to know how long does the sql statement take to return the result.

Solution:
set timing on.

sql> run  the sql statement

Adding Services to CRS stack in RAC

I was trying to add RAC database  services to the CRS stack after the RAC database has been built. I was getting the  following errors:

au11qapeo0tels2:RACDB2:/opt/app/crs/oracle/product/11.1.0/crs/bin>srvctl add service -d RACDB -s RACBD2 -r RACDB2 -a RACDB2 -P none
PRKP-1087 : RACDB2 is specified as both preferred and available instance lists for service RACDB2

Assumptions for adding the services
--------------------------------------------
RAC database: RACDB
Instances : RACDB1, RACDB2

Service_name : RACDB1 and RACDB2

Service RACDB1 will be running on only instance : RACDB1

Service RACDB2 will be running on only instance : RACDB2

Solution:

I Have ran using the following commands and it worked: srvctl add service -d RACDB -s RACDB2 -r RACDB2 -P none srvctl start service -d RACDB -s RACDB1 -i RACDB1 srvctl start service -d RACDB -s RACDB2 -i RACDB2 HA Resource Target State ----------- ------ ----- ebr_vip1 ONLINE ONLINE on node2 ora.RACDB.RACDB1.RACDB1.srv ONLINE ONLINE on node1 ora.RACDB.RACDB1.cs ONLINE ONLINE on node1 ora.RACDB.RACDB1.inst ONLINE ONLINE on node1 ora.RACDB.RACDB2.RACDB2.srv ONLINE ONLINE on node2 ora.RACDB.RACDB2.cs ONLINE ONLINE on node2 ora.RACDB.RACDB2.inst ONLINE ONLINE on node2 ora.RACDB.db ONLINE ONLINE on node1 ora.node1.LISTENER_node1.lsnr ONLINE ONLINE on node1 ora.node1.gsd ONLINE ONLINE on node1 ora.node1.ons ONLINE ONLINE on node1 ora.node1.vip ONLINE ONLINE on node1 ora.node2.LISTENER_node2.lsnr ONLINE ONLINE on node2 ora.node2.gsd ONLINE ONLINE on node2 ora.node2.ons ONLINE ONLINE on node2 ora.node2.vip ONLINE ONLINE on node2 node1:RACDB1:/opt/app/crs/oracle/product/11.1.0/crs/bin>srvctl status service -d RACDB Service RACDB1 is running on instance(s) RACDB1 Service RACDB2 is running on instance(s) RACDB2

ERROR IN INVOKING TARGET 'RELINK' OF MAKEFILE, LD: LIBRARY -LDCE: NOT FOUND

Problem Description: error when applying patchset 10205 on top of 10201. error invoking target relink of makefile .
ERROR IN INVOKING TARGET 'RELINK' OF MAKEFILE, LD: LIBRARY -LDCE: NOT FOUND

ld: fatal: library -lclntsh: not found

applied Patch 4589082: patch for 10201 binaries

10201 install was successful tried applying patchset 10205 failed . followed the below metalink note

Install 10gR2 on Solaris 64 bits fails with: 'library -ldce: not found' [ID 333348.1].


found the below error from this file /opt/app/oracle/product/10.2.0/db_1/lib/clntsh.fileslist

relink found an unidentified object in the library file
Undefined first referenced
symbol in file
nnfdboot /opt/app/oracle/product/10.2.0/db_1/lib32/libn10.a(nnfgt.o)
ld: fatal: Symbol referencing errors. No output written to /opt/app/oracle/product/10.2.0/db_1/lib32/libclntsh.so.10.1

Cause:
This is an issue with Oracle 10.2.0.5 and DCE installed on the given computer. It would also work if you first install Oracle all the way to 10.2.0.5 before installing DCE.


Solution:
 Here is a work around as recommended by Oracle Development
1. This leaves DCE running and we are going to reinstall all the back to Oracle 10.2.0.1
2. Unzip the file that has the 10.2.0.1 install files
3. Please install Patch 4589082 onto the "staging area" of the Oracle 10.2.0.1 install. Please thoroughly follow the directions to a "tee"
4. Install Oracle 10.2.0.1 process
5. After a successful install, within the Oracle 10.2.0.1 ORACLE_HOME directory, please remove these files:
lib/libncds10.a
network/install/ldflags.cds
lib/libndce10.a
network/install/ldflags.dce
6. Please install the Oracle 10.2.0.5 Patchset

ORA-04063: view "SYS.DBA_REGISTRY" has errors

One day I was building 11.1.0.7 standalone database. I messed up the catalog and catproc views and both of the packages became Invalid and I was unable to query DBA_REGISTRY. raised an SR with Oracle and the solution is as follows:

select * from dba_registry;

ORA-04063: view "SYS.DBA_REGISTRY" has errors

Causes:
The probable causes for dba_registry components became invalid could be any of the following.

• Applied a patch and after the patch application because of some dependent object status change registry can become invalid

• Installed a new component and the new component installation got failed then registry components could become invalid

• catalog.sql or catproc.sql was not successfully ran after database creation. Any of them would have failed somewhere or any of the dependent object got invalid afterward

Normally this will be resolved by re- running catalog.sql and then catproc.sql as sysdba as per below metalink note
Note: 457861.1 CATPROC - Packages and Types Invalid in Dba_registry

This issue can happen if you run catproc.sql first and then catalog.sql. It should be run as following. This note is applicable to 11g database as well.

Solution:
$sqlplus "/as sysdba"
SQL> startup upgrade
-- Use 'startup migrate' if database version is lower than 9.2.
SQL > @?/rdbms/admin/catalog.sql
SQL > @?/rdbms/admin/catproc.sql
SQL > @?/rdbms/admin/utlrp.sql

ORA-27047: Unable to read the header block of file

We were performing 11i cloning but unfortunately the adcfgclone.pl failed on target while controlfile creation with the following error

• Creating the control file may report error ORA-27047 when OS block header is invalid for a particular datafile:

ORA-27047 : unable to read the header block of file.

Example taken from HPUX:

ORA-1503: CREATE CONTROLFILE failed
ORA-1565: error in identifying file '/oradata/users.dbf'
ORA-27047: unable to read the header block of file
HP-UX Error: 22: Invalid argument
Additional information: 2

• DBVerify does not report a corruption in the datafile.
  

Cause

OS block in the datafile is corrupted.

• The corruption is identified by the Oracle utility dbfsize:

$ dbfsize /oradata/users.dbf
Header block magic number is bad

For complete information follow metalink note ref: 360032.1

Compiling Invalid objects

DBMS_DDL.ALTER_COMPILE

Definition
This procedure is equivalent to the following SQL statement:
ALTER PROCEDUREFUNCTIONPACKAGE [.] COMPILE [BODY]

Syntax
Exec dbms_ddl.alter_compile ( type , schema, name);
Type : Must be either PROCEDURE, FUNCTION, PACKAGE, PACKAGE BODY or TRIGGER.
Schema : Database Username

Name : Objects name
Example
SQL> exec dbms_ddl.alter_compile ('PROCEDURE','SCOTT','TEST');

PL/SQL procedure successfully completed.

DBMS_UTILITY.COMPILE_SCHEMA

Definition
This procedure compiles all procedures, functions, packages, and triggers in the specified schema.

Syntax
Exec dbms_utility.compile_schema ( schema,compile all)

Schema : Database Username
Compile All : Object type ( procedure, function, packages,trigger)

Example
SQL> exec dbms_utility.compile_schema('SCOTT');

PL/SQL procedure successfully completed.

UTL_RECOMP

Definition
This script is particularly useful after a major-version upgrade that typically invalidates all PL/SQL and Java objects.

Syntax
Exec UTL_RECOMP.RECOMP_SERIAL ();

Example
SQL> Exec UTL_RECOMP.RECOMP_SERIAL ();

PL/SQL procedure successfully completed.

Note: Required SYS user to run this package.

UTLRP.SQL scripts

Definition
Recompiles all existing PL/SQL modules that were previously in an INVALID state, such as packages, procedures, and types.

Syntax
Located: $ORACLE_HOME/rdbms/admin

Example
SQL> @c:\oracle\product\10.1.0\db_1\rdbms\admin\UTLRP.SQL

TIMESTAMP
-----------------------------------------------------------------------
COMP_TIMESTAMP UTLRP_BGN 2007-08-04 12:47:21

PL/SQL procedure successfully completed.

TIMESTAMP
-----------------------------------------------------------------------
COMP_TIMESTAMP UTLRP_END 2007-08-04 12:47:26

PL/SQL procedure successfully completed.

Note: Required SYS user to run this script.
Recommended: After upgrade or migrate database.

Best Approach is manually recompiling all Invalid Objects

Spool recompile.sql
Select 'alter 'object_type' 'object_name' compile;'
From user_objects
Where status <> 'VALID'
And object_type IN ('VIEW','SYNONYM',
'PROCEDURE','FUNCTION',
'PACKAGE','TRIGGER');
Spool off
@recompile.sql

Note: VIEW,SYNONYM,PROCEDURE,PACKAGE,FUNCTION,TRIGGER

Spool pkg_body.sql
Select 'alter package 'object_name' compile body;'
From user_objects
where status <> 'VALID'
And object_type = 'PACKAGE BODY';
Spool off
@pkg_body.sql

Spool undefined.sql
select 'alter materizlized view 'object_name' compile;'
From user_objects
where status <> 'VALID'
And object_type ='UNDEFINED';
Spool off
@undefined.sql

Spool javaclass.sql
Select ‘alter java class 'object_name' resolve;'
from user_objects
where status <> 'VALID'
And object_type ='JAVA CLASS';
Spool off
@javaclass.sql

Spool typebody.sql
Select ‘alter type 'object_name' compile body;'
From user_objects
where status <> 'VALID'
And object_type ='TYPE BODY';
Spool off
@typebody.sql

Spool public_synonym.sql
Select 'alter public synonym 'object_name' compile;'
From user_objects
Where status <> 'VALID'
And owner = ‘PUBLIC’
And object_type = 'SYNONYM';
Spool off
@public_synonym.sql

Troubleshooting listener issues in RAC

The backup kept failing to make a connection to the database using EBR_RACDB tns string.
This was because the service was not activated in CRS stack. First create the service and
add the service as follows and this will resolve the issue.

run this command to see if all service is running.

$ORA_CRS_HOME/bin>crsstat -t

HA Resource Target State
------------------------------- --------- -----------------
ora.RACDB.RACDB1.RACDB1.srv ONLINE ONLINE on node1
ora.RACDB.RACDB1.cs ONLINE ONLINE on node1
ora.RACDB.RACDB1.inst ONLINE ONLINE on node1
ora.RACDB.RACDB2.RACDB2.srv ONLINE ONLINE on node2
ora.RACDB.RACDB2.cs ONLINE ONLINE on node2
ora.RACDB.RACDB2.inst ONLINE ONLINE on node2

If any of the above services appear offline or doesnt appear at all. Then add the services to the CRS stack and start the services.

srvctl add service -d RACDB -s RACDB1 -r RACDB -a RACDB1 -P NONE

srvctl start service -d RACDB -s RACDB1 -i RACDB1

srvctl add service -d RACDB -s RACDB2 -r RACDB -a RACDB2 -P NONE

srvctl start service -d RACDB -s RACDB2 -i RACDB2

Once all the services are up and running check the connectivity.

node1:RACDB:/ora/admin>rman target ebr@ebr_RACDB

node1:RACDB1:/ora/admin>rman target ebr@EBR_RACDB

Recovery Manager: Release 10.2.0.3.0 - Production on Tue Feb 16 20:51:33 2010

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

target database Password: <-- feed it with the password
connected to target database: RACDB (DBID=1894566972)

Oracle RAC configuration for EBR.

We have decided to go with EBR as the backup startegy for RAC. This is bit tricky we have to first register the EBR VIP into the CRS Stack and then start the resources for the EBR to actually backup the database. First let us see few characteristics of EBR_VIP as follows:

The EBR_VIP is required to be configured on only one node of the cluster
• The EBR_VIP can be moved to any node in the cluster providing each node has NICs
configured on the EBR network
• The EBR_VIP exists on only one node in the cluster at any time
• The EBR_VIP IP address is provided in the EBR Client Design document, provided by
the EBR Team
• The EBR backup server only communicates with the node on which the EBR_VIP
resides, hence the entire backup or restore datastream is via this node
• The EBR_VIP is configured in DNS with the name provided in the Client EBR Design
document. This name is the Netbackup Client Name.


Creating EBR VIP
------------------------------------------------

crs_profile –create ebr_vip1 -t application \
-a $CRS_HOME/bin/usrvip \
-o oi=nxge6,ov=10.106.194.87,on=255.255.252.0

• ebr_vip1 is the name assigned to the new CRS resource

• $CRS_HOME is the home directory for the Oracle Clusterware installation.

• nxge6 is the name of the public network adapter

• 10.106.194.87 is the EBR_VIP1 cluster IP address that will be used by EBR to

• connect regardless of the node it is running on.

• 255.255.252.0 is the netmask for the public IP address

Registering the EBR VIP in CRS stack
-----------------------------------------
crs_register ebr_vip1

as root user
-----------------------------------------
./crs_setperm ebr_vip1 –o root

./crs_setperm ebr_vip1 –u user:oracle:r-x

as oracle user start the ebr_vip1
----------------------------------------
crs_start ebr_vip1

check the resource is started
---------------------------------------
crs_stat | grep ebr_vip1

If there are two databases register EBR VIP per database create the EBR_VIP2 same as the above.

Check the resource has been started:

cd $ORA_CRS_HOME/bin

crs_stat | grep ebr_vip1

Once the VIP is registered create the TNS alias entries Add the service names to tnsnames.ora on both the nodes If its is two node RAC configuration as follows:

Node1:

EBR_RACDB =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = node1-oravip)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = node2-oravip)(PORT = 1521))
(LOAD_BALANCE=OFF)

)
(CONNECT_DATA = (SERVER = DEDICATED)(SERVICE_NAME = RACDB1))
)

Node2:

EBR_RACDB =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = node1-oravip)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = node2-oravip)(PORT = 1521))
(LOAD_BALANCE=OFF)

)
(CONNECT_DATA = (SERVER = DEDICATED)(SERVICE_NAME = RACDB2))
)

Create the EBR database user and grant necessary privileges
--------------------------------------------------------------
create user EBR identified by
2 default tablespace USERS
3 temporary tablespace TEMP;

grant SYSDBA to EBR;
grant create, Alter session privilege to EBR;

Now test the connectivity on both the nodes as follows:

Node1-> sqlplus EBR/password@EBR_RACDB as sysdba
SQL*Plus: Release 10.2.0.3.0 - Production on Thu Feb 21 14:19:46 2008
Copyright (c) 1982, 2006, Oracle. All Rights Reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit
Production
With the Partitioning, Real Application Clusters, OLAP and Data Mining
options

Oracle Configuration Manager

Today i have encountered some errors in the Alert log regarding ORACLE OCM.

ORA-12012: error on auto execute of job 32184
ORA-06550: line ORA-06550: line 1, column 476:
PLS-00201: identifier 'ORACLE_OCM.MGMT_DB_LL_METRICS' must be declared
ORA-06550: line 1, column 476:
PL/SQL: Statement ignored
, column :

Found out that OCM was installed along with the binaries. As we are not using OCM in any of our environments the solution to this problem is as follows:

Steps to uninstall OCM from DB tier:
-------------------------------------------------

1- Set your ORACLE_HOME
export ORACLE_HOME=

2- From your rdbms Oracle Home please connect using sqlplus as sysdba user to your database and run the following commands:

SQL> @ccr/admin/scripts/dropocm.sql;

3- To stop the Scheduler and remove the service or the crontab entry, enter the following command:

$ORACLE_HOME/ccr/bin/deployPackages -d /ccr/inventory/core.jar

4- Delete the ccr directory by entering the following command:

$rm -rf /ccr

5- Verify no services or cron entry. Run the following commands to confirm:
a- ps -ef|grep ccr|grep -v grep
b- crontab -l|grep ccr
c- crontab -l

If you dont find the admin directory under $ORACLE_HOME/ccr then follow the below solution.

Login to that DB with sys and confirm that you have :
"ORACLE_OCM" user exist or not ?
"ORACLE_OCM_CONFIG_DIR" directory exist or not ?

If this user and directory exist In order to manually remove the ORACLE_OCM user and associated objects from database, run:

SQL> drop user ORACLE_OCM cascade;
SQL> drop directory ORACLE_OCM_CONFIG_DIR;

Then also remove the $ORACLE_HOME/ccr directory.

This resolved the issue and couldn't find any more errors in the alert log.

First Post 21/02/2011

Today I felt like creating a blog for myself an Online Oracle journal with all the issues that I have come across and the workarounds/ Solutions I have implemented to overcome them. Here goes some of my experiences through this Blog. This is very much useful to me when I want to go back and see what the issues I have encountered. Instead of searching my desktop folders and don't find the correct resource and scratching my head for not able to recollect what I have implemented.