Oracle database Import ORA-39001: invalid argument value ORA-39000: bad dump file specification

hello, I was trying to import dump file to my test oracle database using the following import line: Import: Release 11.2.0.4.0 – Production on Wed jan 10 10:52:34 2018 Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 – 64bit Production With the Partitioning, […]

Oracle Database Listener.log Analize

Hello, We are creating a new listener log file from listener.log file. ErmanTESTDB:/oracle/grid/diag/tnslsnr/ErmanTESTDB/listener/trace#cp listener.log a_listener.log   1. create a new directory for listener.log file. create directory erman_log_dir as ‘/oracle/grid/diag/tnslsnr/alioth/listener/trace’; 2. create a new table for listener.log file create table erman_log ( log_date date, connect_string varchar2(300), protocol_info varchar2(300), action varchar2(15), service_name varchar2(15), return_code number(10) ) organization […]

Oracle Database Listener.log File Location

Hello, I am just getting my feet wet with 11gR1. When I executed lsnrctl status, I get the following: Connect to terminal with Oracle user than run this command: {ermanTestDB:oracle}/home/oracle/>lsnrctl status LSNRCTL for IBM/AIX RISC System/6000: Version 11.2.0.4.0 – Production on 08-JAN-2018 10:59:28 Copyright (c) 1991, 2013, Oracle. All rights reserved. Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521)) STATUS of […]

Oracle Database Export

Hello,Step by step Oracle database export Schema, Tables, Procedure, Full Database etc. For the examples to work we must first unlock the SYS account and create a directory object it can access. The directory object is only a pointer to a physical directory, creating it does not actually create the physical directory on the file […]

ORA-01555 Error

Hello, how much is the tablepace size ? Connect to sqlplus from your terminal than run this sql commands. SELECT d.undo_size/(1024*1024) as UNDO_SIZE, SUBSTR(e.value,1,25) as UNDO_RETENTION, ROUND((d.undo_size / (to_number(f.value) * g.undo_block_per_sec))) as OPTIMUM_UNDO_RETENTION FROM ( SELECT SUM(a.bytes) undo_size FROM v$datafile a, v$tablespace b, dba_tablespaces c WHERE c.contents = ‘UNDO’ AND c.status = ‘ONLINE’ AND b.name […]

Check undo tablespace size oracle 11g or 12c

SELECT SUM(a.bytes) as UNDO_SIZE  FROM v$datafile a, v$tablespace b, dba_tablespaces c  WHERE c.contents = ‘UNDO’   AND c.status = ‘ONLINE’    AND b.name = c.tablespace_name   AND a.ts# = b.ts#; Output: UNDO_SIZE 3.7770E+10 find the number of undo block per second; SELECT TO_NUMBER(value) as DB_BLOCK_SIZE FROM v$parameter WHERE name = ‘db_block_size’; Output: DB_BLOCK_SIZE ————- 8192 1 row […]

How can we check if a partition of a table exists?

Hello, Partitions : Maintenance of large tables and indexes can become very time and resource consuming. At the same time, data access performance can reduce drastically for these objects. Partitioning of tables and indexes can benefit the performance and maintenance in several ways. Partition independance means backup and recovery operations can be performed on individual […]

ADDING DATAFILE TO TABLESPACE IN ASM

Datafile scripts : CREATE TABLESPACE USERS DATAFILE ‘+DATA’ SIZE 33511680K AUTOEXTEND ON NEXT 1280K MAXSIZE UNLIMITED, ‘+DATA’ SIZE 32724M AUTOEXTEND ON NEXT 100M MAXSIZE UNLIMITED, ‘+DATA’ SIZE 33554416K AUTOEXTEND ON NEXT 512M MAXSIZE UNLIMITED, ‘+DATA’ SIZE 30040M AUTOEXTEND ON NEXT 100M MAXSIZE UNLIMITED, ‘+DATA’ SIZE 100M AUTOEXTEND ON NEXT 100M MAXSIZE UNLIMITED, ‘+DATA’ SIZE 100M […]