Tuesday, September 11, 2012

How to change National character set from UTF8 or any in 11g


sqlplus / as sysdba
STARTUP MOUNT exclusive RESTRICT
ALTER SYSTEM ENABLE RESTRICTED SESSION; 
ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0; 
ALTER SYSTEM SET AQ_TM_PROCESSES=0; 
ALTER DATABASE OPEN ;
update props$ 
set value$=' WE8ISO8859P1' 
where name in ('NLS_CHARACTERSET', 'NLS_NCHAR_CHARACTERSET'); 
commit;
SHUTDOWN IMMEDIATE;

Saturday, April 28, 2012

ORA-29702: error occurred in Cluster Group Service operation


sqlplus "/as sysdba"

SQL*Plus: Release 11.2.0.2.0 Production on Sat Apr 28 08:50:11 2012

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

Connected to an idle instance.

SQL> startup
ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
ORA-29702: error occurred in Cluster Group Service operation
SQL> exit
=========================
* solution

cd $ORACLE_HOME/rdbms/lib
make -f ins_rdbms.mk rac_off
make -f ins_rdbms.mk ioracle
=======================

Thursday, April 26, 2012

Oracle Fusion Middleware Products

There are multiple installation CD-ROMs and DVDs, each containing a
separate piece of Oracle Fusion Middleware. This chapter describes the contents of these CD-ROMs and DVDs:
Oracle Repository Creation Utility (RCU)
Oracle WebLogic Server (10.3.1)
Oracle SOA Suite 11g (11.1.1.0.0)
Oracle WebCenter 11g (11.1.1.0.0)
Oracle Identity Management 11g (11.1.1.0.0)
Oracle Portal, Forms, Reports and Discoverer 11g (11.1.1.0.0)
Oracle Web Tier Utilities 11g (11.1.1.0.0)
Oracle Fusion Middleware Companion CD
Oracle Data Integrator 10g (10.1.3.2)
Oracle Business Intelligence Publisher 10g (10.1.3.4)
Oracle Business Process Analysis Suite 11 (11.1.1.0.0)
Oracle Access Manager 10g Core Components (10.1.4.3.0) DVD
Oracle Access Manager 10g Webgates (10.1.4.3.0) CD
Oracle Access Manager 10g NLS Packages (10.1.4.3.0) CD
Oracle Secure Enterprise Search (SES)
Oracle JDeveloper 11g and Oracle Application Development Framework (ADF) 11g DVD
Oracle Application Developer 11 (11.1.1.0)
Oracle Fusion Middleware Adapters and Connectors
Oracle WebLogic Operations Control CD
Oracle Clusterware 11g (11.1.1.1.0) - Linux Only
Oracle Fusion Middleware 11g Documentation Library

Wednesday, February 29, 2012

RDA Completing With Time Out Error - The test was interrupted because it ran longer than the allotted time (300 seconds)

Increase profile option the "Default timeout used by OSUtility" (OAM_DIAG_DEFAULT_TIMEOUT) to 600 seconds to resolve the following error: The test was interrupted because it ran longer than the allotted time (300 seconds) Re-Run the test.