Apr 03, 2018
ORA-12012 ORA-20001 ORA-06512: at “SYS.DBMS_STATS”
1.4K

ORA-12012 ORA-20001 ORA-06512: at “SYS.DBMS_STATS”

Error in alert log crashing database: ORA-12012: error on auto execute of job “SYS”.”ORA$AT_OS_OPT_SY_88″ ORA-20001: Statistics Advisor: Invalid Task Name For the current user <== Note it ORA-06512: at “SYS.DBMS_STATS”, line 46861 ORA-06512: at “SYS.DBMS_STATS_ADVISOR”, line 734 ORA-06512: at “SYS.DBMS_STATS_INTERNAL”, line 19930 ORA-06512: at “SYS.DBMS_STATS_INTERNAL”, line 21934 ORA-06512: at “SYS.DBMS_STATS”,...
Oct 21, 2017
ORA-39142: incompatible version number 5.1 in dump file
3.3K

ORA-39142: incompatible version number 5.1 in dump file

Error:  ORA-39142: incompatible version number 5.1 in dump file. I did get this error while I was importing a schema. I did export a schema from Oracle Database 12.2.x and trying to import it to Oracle Database 12.2.x (version mismatch) Solution: User “Version” option while exporting from 12.2.x as below expdp...
Oct 13, 2017
Missing command fuser
2.1K

Missing command fuser

Issue: opatchauto apply is failing with below errors: Prerequisite check “CheckSystemCommandAvailable” failed. The details are: Missing command :fuser Solution: Install below package as a root user: yum install psmisc or cd $ORACLE_HOME/bin touch fuser chmod 755 fuser
Aug 24, 2017
PKI-02010: Invalid MAC for Wallet. Wallet verification failed
1.6K

PKI-02010: Invalid MAC for Wallet. Wallet verification failed

Issue While Creating Wallet:  PKI-02010: Invalid MAC for Wallet. Wallet verification failed. Solution:  Wallet is corrupt.  Delete the Wallet directory completely and recreate Wallet, but while providing password, avoid “$” “@” symbols as special characters.
Aug 07, 2017
ORA-1691: unable to extend lobsegment
1.2K

ORA-1691: unable to extend lobsegment

ERROR: ORA-1691: unable to extend lobsegment DWADM.SYS_LOB0000093603C00012$$ by 128 in tablespace STS_01 ORA-1691: unable to extend lobsegment DWADM.SYS_LOB0000093603C00012$$ by 128 in tablespace STS_01 ORA-1691: unable to extend lobsegment DWADM.SYS_LOB0000093603C00012$$ by 128 in tablespace STS_01 SOLUTION: Use ALTER TABLESPACE ADD DATAFILE statement to add one or more files to the tablespace...
Nov 18, 2015
1.4K

Oracle Database Free Trial in Oracle Cloud

Oracle is offering Database services in Cloud.  Oracle Cloud provides several Oracle Database offerings. We can choose between a single schema based service, or a virtual machine with a fully configured running Oracle Database Instance, or Exadata Service with all the database features, options, and workloads. You can even try a...
Jul 15, 2013
Online Oracle Database 12c Training
1.3K

Online Oracle Database 12c Training

Please find the course content: Introduction Course Objectives Course Schedule Overview of Oracle Database 12c Overview of Oracle Cloud Exploring the Oracle Database Architecture Oracle Database Architecture: Overview Oracle Database Instance Configurations Connecting to the Oracle Database Instance Oracle Database Memory Structures Process Architecture Process Structures Process Startup Sequence Database...
Jul 04, 2013
2.6K

Oracle RAC 12c Installation on Oracle Virtual Box

Step-by-step Installation of Oracle RAC 12c on Oracle Virtual Box Download Virtual Box Download Oracle Enterprise Linux 5.7 64-bit Download Oracle 12cR1 64-bit Database Software Installation of Oracle Enterprise Linux 5.7 by clicking on the link Linux Post Installation Steps: 1) To be consistent with the rest of the article, the following information should be set during the installation process. #vi /etc/hosts 127.0.0.1 localhost.localdomain localhost # Public 192.168.1.101 rac1.oracle.com rac1 192.168.1.109...
Jul 04, 2013
Upgrade database from 11g to 12c
4.4K

Upgrade database from 11g to 12c

Step by Step Procedure to update Oracle Database 11gR2 to 12cR1 There are different ways of upgrading to the latest release of Oracle database and Oracle provides multiple methods to upgrade. Few are listed below: 1)Database Upgrade Assistant (DBUA) 2)Manual Upgrade 3)Transportable Tablespaces 4)Datapump export/import 5)Oracle Streams 6)Oracle GoldenGate Now,...
Jun 30, 2013
Oracle Database 12c installation on linux
2.5K

Oracle Database 12c installation on linux

Oracle 12c Database installation step by step procedure on Linux: 1) Install OEL 5.7 Linux using the following link Oracle Enterprise Linux 5.7 Installation Here my hostname [root@12cdb ~]# hostname 12cdb.oracle.com 2) create user and group [root@12cdb /]# groupadd dba [root@12cdb /]# useradd -g dba oracle 3) Create required directory structure [root@12cdb /]# mkdir -p /u01/app/oracle/product/12.1.0 4) Copy...