Oracle Database Patchset 11.2.0.3 is ready to download

Oleksandr Denysenko's Blog

Oracle RDBMS PatchSet version 11.2.0.3 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:

  • 11.2.0.3 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

Advertisements
Posted in Uncategorized | Leave a comment

ORA-39083: Object type TABLE, ORA-14460: only one COMPRESS or NOCOMPRESS clause may be specified

harshsamudraladb

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.

Error Details:

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

Posted in Uncategorized | Leave a comment

Firewall Enable/Disable Solaris 10

Muses Of IT Engineer

svcadm enable svc:/network/ipfilter:default

svcadm disable svc:/network/ipfilter:default

View original post

Posted in Uncategorized | Leave a comment

To resize the tempfile in Temp Tablespace

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;

View original post

Posted in Uncategorized | Leave a comment

Database upgrade from 11.2.0.1 to 11.2.0.4 on Linux-64bit

Oracle Application DBA

This post will cover simple step for database upgrade from 11201 to 11204 on Linux-64bit

  • Old Database: – 11.2.0.1
    11-DB version 2-Release 0-Application release 1-Component release/patch release
  • New Database: – 11.2.0.4
    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.

PIC1

>> Download the Software from My oracle Support with Patch No:13390677

PIC2

>> Check the status of source database version:

PIC3

>> Take back-up of source database11.2.0.1:

PIC4

>> Unzip the below zip files:
There are 7 files available, so that we need only first two files for database upgrade.
Unzip p13390677_112040_Linux-x86-64_1of7.zip
Unzip p13390677_112040_Linux-x86-64_2of7.zip

Go to the below step only if your database is created using DBCA method:
vi /etc/oratab
test:/u01/oracle/app/product/11.2.0/dbhome_1:N
replace it with
test:/u01/oracle/app/product/11.2.0.4/dbhome_1:N

>> Export new ORACLE_HOME in bash_profile:

pic5

>> Install Oracle 11g Software (11.2.0.4) on server with separate ORACLE_HOME:

pic6

Click…

View original post 194 more words

Posted in Uncategorized | Leave a comment

How to delete/remove non executing datapump jobs?

useful love this …

Pavan DBA's Blog

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,
state, attached_sessions
FROM dba_datapump_jobs
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

Posted in Uncategorized | Leave a comment

Useful Brocade FOS CLI Commands

THE SAN GUY

Below is a list of useful Brocade CLI commands that I keep at my desk for reference.  They’re divided up into categories for Zoning, Show, Port, Time/Date, License, Banner, Password, SNMP, User Config, Firmware, and Miscellaneous.

Zoning Commands

alicreate “Name”, “domain,port#” Used to create an alias
alicreate “Name”,”portname1; portname2″ To create multiple ports under a single alias
alidelete “Name” To delete an alias
aliadd “Name”, “domain,port#” To add additional ports to an alias
aliremove “Name”, “domain,port#” To remove a port from the alias
alishow “AliName” To show the alias configuration on the switch
zonecreate “Zone Name”, “alias1; alias2″ To create zones based on alias
zonedelete “ZoneName” To delete a zone
zoneadd “ZoneName”, “alias name” To add additional alias into the zone
zoneremove “ZoneName”, “alias name” To remove an alias from the zone
zoneshow “zoneName” To show the zone configuration information
cfgcreate “Configname”, “Zone1; Zone2″ To create configurations by adding in…

View original post 1,271 more words

Posted in Uncategorized | 1 Comment