Nov 18, 2015
519

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.3K

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.
7.4K

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
820

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
593

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
5.2K

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
501

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
1K

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
546

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...
Dec 13, 2012
ORA-39000: bad dump file specification
1.1K

ORA-39000: bad dump file specification

When we take export using datapump, we faced following error: Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 – 64bit Production With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP, Data Mining and Real Application Testing options ORA-39001: invalid argument value ORA-39000: bad dump file specification ORA-31641: unable...