DanBrother的部落格

Issue:
When retrieving a "Ref Cursor" Parameter from Oracle Stored Procedure in ASP
receives the following error:

Table Compression Option in Oracle 11gR2

The compression clause can be specified at the tablespace, table, or partition level with the following three options:

Issue:
ORA-14300: partitioning key maps to a partition outside maximum permitted number of partitions

Introducing Pluggable Database, the star of Oracle Database 12c

Please refer to:

How to Disable Oracle Database Vault Option?

To disable Oracle Database Vault option, here are the steps to follow: 

Issue:
Opatch failed with error code = 41 (Windows Server 2008 x64)

How to Install Oracle Text Option on Oracle 11gR2 Database?

1. Install Oracle Text
SQL> conn / as sysdba

Steps for Installing Oracle Forms and Reports 11g on Linux:

1. Download & Install Java SE Development Kit 6u37 :

Issue:
FRM-91111 and FRM-10039 When Starting Oracle Forms Builder 11g on Linux:

Script for Purging All Tables in th Recyclebin:

Solution to ORA-14402: updating partition key column would cause a partition change

$ oerr ora 14402

-- Method 1
cd C:\app\oracle\product\11.2.0\dbhome_1\sysman\admin\emdrep\bin
set ORACLE_HOME=C:\app\oracle\product\11.2.0\dbhome_1

Remove ORACLE_OCM User Manually:

1.

SQL> select * from dba_tablespace_groups;

no rows selected

-- Modify Snapshot Retention:

select retention from dba_hist_wr_control;

Oracle Critical Patch Apply Steps  (RAC DB on Linux):

1.  (logon as oracle user)

Oracle Database Startup Sequence:
Oracle database normally goes through three stages (nomount, mount, open)
to be available for users accessing it.