Oracle RDBMS PatchSet version 18.104.22.168 is available to download since 23-SEP-2011! some time earlier than OOW2011
But(as of 28-SEP-2011) it’s still available only for Linux x86 and Linux x86-64.
Based on NOTE:742060.1 Release Schedule of Current Database Releases:
- 22.214.171.124 will be available for other major Unix/Linux platforms(HP-UX Itanium, Oracle Solaris SPARC (64-bit), Oracle Solaris x86-64 (64-bit), IBM AIX on POWER Systems) during the October 2011, perhaps during Oracle Open World 2011 or after it
- for the rest popular platforms, like Microsoft Windows (32-bit) and Microsoft Windows x64 (64-bit), and not so popular like IBM Linux on System z, the release date is scheduled for Q4 2011
- for HP-UX PA-RISC (64-bit) is will be available during 1Q 2011
View original post 385 more words
Recently I have encountered this error when I am trying to import data in of our customer server.
Here export was taken using EXPDP and with SYS user and Import with IMPDP using SYSTEM user. Here system can import data unless it has privileges to import data which is exported by SYS user.
There are around 358 objects was not imported and failed with below error.
Starting “SYSTEM”.”SYS_IMPORT_FULL_02″: SYSTEM/******** directory=IMP_DIR dumpfile=TNTX_Tenant_01.dmp REMAP_SCHEMA=TCMP:CALCLD logfile=LOG_DIR:phase2_import.log
Processing object type TABLE_EXPORT/TABLE/TABLE
ORA-39083: Object type TABLE:”CALCLD”.”CS_xxxxxxxx” failed to create with error:
ORA-14460: only one COMPRESS or NOCOMPRESS clause may be specified
Failing sql is:
CREATE TABLE “CALCLD”.”CS_xxxxxxxx” (“Txxxxx” VARCHAR2(4 BYTE) DEFAULT user NOT NULL ENABLE, “NAME” VARCHAR2(30 BYTE) NOT NULL ENABLE, “NEXTVALUE” NUMBER(*,0) NOT NULL ENABLE) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE( BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE “TALLYDATA” PART
ORA-39083: Object type TABLE:”CALCLD”.”CS_xxxxx” failed to create with error:
View original post 29 more words
alter database tempfile '/u01/oradata/TESTDB/temp01.dbf' resize 250M alter database tempfile '/SID/oradata/data02/temp12.dbf' autoextend on maxsize 1800M; alter tablespace TEMP add tempfile '/SID/oradata/data02/temp05.dbf' size 1800m reuse;
This post will cover simple step for database upgrade from 11201 to 11204 on Linux-64bit
- Old Database: – 126.96.36.199
11-DB version 2-Release 0-Application release 1-Component release/patch release
- New Database: – 188.8.131.52
11-DB version 2-Release -Application release 4-Component release/patch release
The below mentioned diagram will give the idea of upgrade patch release with component details.
>> Download the Software from My oracle Support with Patch No:13390677
>> Check the status of source database version:
>> Take back-up of source database184.108.40.206:
>> Unzip the below zip files:
There are 7 files available, so that we need only first two files for database upgrade.
Go to the below step only if your database is created using DBCA method:
replace it with
>> Export new ORACLE_HOME in bash_profile:
>> Install Oracle 11g Software (220.127.116.11) on server with separate ORACLE_HOME:
View original post 194 more words
useful love this …
Sometimes, we may get a requirement to delete datapump jobs which are stopped abruptly due to some reason. The following steps will actually help us to do that
1. First we need to identify which jobs are in NOT RUNNING status. For this, we need to use below query (basically we are getting this info from dba_datapump_jobs)
SET lines 200
SELECT owner_name, job_name, operation, job_mode,
ORDER BY 1,2;
The above query will give the datapump jobs information and it will look like below
OWNER_NAME JOB_NAME OPERATION JOB_MODE STATE ATTACHED
———- ——————- ——— ——— ———– ——–
SCOTT SYS_EXPORT_TABLE_01 EXPORT TABLE NOT RUNNING …
SCOTT SYS_EXPORT_TABLE_02 EXPORT TABLE NOT RUNNING …
SYSTEM SYS_EXPORT_FULL_01 EXPORT FULL NOT RUNNING …
In the above output, you can see state is showing as NOT RUNNING and those jobs need to be removed.
Note: Please note that jobs state will be showing as NOT RUNNING even if a user…
View original post 226 more words