Aug 07, 2017
ORA-1691: unable to extend lobsegment
165

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
648

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 22, 2013
ins_precomp.mk:19: warning: overriding commands for target `pcscfg.cfg’
1.5K

ins_precomp.mk:19: warning: overriding commands for target `pcscfg.cfg’

When applying PSU 16619892, OPatch completed with errors as below: Error: OPatch found the word “warning” in the stderr of the make command. Please look at this stderr. You can re-run this make command. Stderr output: ins_precomp.mk:19: warning: overriding commands for target `pcscfg.cfg’ /u01/app/oracle/product/11.2.0/db/precomp/lib/env_precomp.mk:2160: warning: ignoring old commands for target `pcscfg.cfg’...
Jul 16, 2013
ORA-19815: WARNING: db_recovery_file_dest_size of 48318382080 bytes is 100.00% used, and has 0 remaining bytes available.
8.8K

ORA-19815: WARNING: db_recovery_file_dest_size of 48318382080 bytes is 100.00% used, and has 0 remaining bytes available.

Error: ORA-19815: WARNING: db_recovery_file_dest_size of 48318382080 bytes is 100.00% used, and has 0 remaining bytes available. ORA-16014: log 3 sequence# 51 not archived, no available destinations ARCH: Archival stopped, error occurred. Will continue retrying ORACLE Instance DB1 – Archival Error ORA-16038: log 3 sequence# 51 cannot be archived ORA-19809: limit...
Jun 10, 2013
export empty tables in oracle 11g using datapump
1K

export empty tables in oracle 11g using datapump

Export empty tables in oracle 11g using datapump Allocate an extent to an empty table using below command then do the export and import. ALTER TABLE <table_name> ALLOCATE EXTENT;
May 28, 2013
Oracle Database 11gR2 Installation
763

Oracle Database 11gR2 Installation

Oracle Database 11gR2 Installation on Oracle Enterprise Linux 5.7: Requirements: –>50GB of Hard disk –>2GB of RAM –>2 cpu’s Assumptions: –>Oracle Enterprise Linux 5.7 64bit Installed Machine. Click here for  Oracle Enterprise Linux 5.7 Installation Create Group and User: [root@apps oracle]# groupadd -g 1000 oinstall [root@apps oracle]# useradd -u 1100 -g oinstall oracle [root@apps oracle]#...
Apr 24, 2013
HOW TO CHECK HIDDEN PARAMETERS IN ORACLE 11G
6K

HOW TO CHECK HIDDEN PARAMETERS IN ORACLE 11G

Using below SQL we can check hidden parameters from Oracle 11g We should not change these parameters without the consent of Oracle Support. set linesize 200 col “Parameter” for a30 col “Session Value” for a10 col “Instance Value” for a10 col “Default value” for a5 col SESSMOD for a7 col...
Apr 12, 2013
Create Oracle database in silent mode
655

Create Oracle database in silent mode

How to create Oracle database in silent mode? COMMAND ========= dbca -silent -gdname dbname -sid dbname -responsefile NO_VALUE -createDatabase -templateName General_purpose.dbc -characterset AL32UTF8 -memorypercentage 30 -emconfiguration LOCAL OUTPUT ======= Enter SYSTEM user password: password Enter SYS user password: password Copying database files 1% complete 3% complete
Feb 26, 2013
Upgrade Oracle Database from 10g to 11g
1.3K

Upgrade Oracle Database from 10g to 11g

Upgrade Oracle Database from 10g to 11g Upgrade Oracle Database from 10g Release 2 to Oracle 11g Release 1 To Upgrade Oracle  Database from 10g to 11g, you should be on 10.2.0.4, so to install 10.2.0.4 patch set level follow the link Upgrade Oracle Database from 10.2.0.1 to 10.2.0.4 This article is a step by step guide to...
Jan 01, 2013
ADRCI Command Interpreter in 11g
678

ADRCI Command Interpreter in 11g

The ADR Command Interpreter (ADRCI) is a command-line tool that you use to manage Oracle Database diagnostic data. Automatic Diagnostic Repository (ADR) The ADR is a file-based repository for database diagnostic data such as traces, dumps, the alert log, health monitor reports, and more. It has a unified directory structure...