Search This Blog

Blog for oracle basic 9i,10g,11g,12c

UNDO

Get link
Facebook
X
Pinterest
Email
Other Apps

- May 13, 2018

set head off pagesize 0 linesize 200
select 'alter database datafile ' || '''' || file_name || '''' || ' autoextend on maxsize
unlimited;' from dba_data_files where tablespace_name not like 'UNDO%';

Get link
Facebook
X
Pinterest
Email
Other Apps

Comments

ORA-12012 Error on auto execute of job "SYS"."ORA$AT_OS_OPT_SY_ in 12.2 Database

- May 13, 2018

Reference document for Doc ID 2127675.1 $ sqlplus / as sysdba EXEC dbms_stats.init_package(); Execute below statement & re-triggered stats for fixed objects . $ sqlplus / as sysdba EXEC dbms_stats.init_package();

How to check OS inventory

- February 25, 2019

Grid-1 [root@scnluatoradb02 lib]# su - grid Last login: Sun Nov 18 16:18:44 IST 2018 on pts/1 [grid@makuatoradb02 ~]$ [grid@makuatoradb02 ~]$ [grid@makuatoradb02 ~]$ /oracle/12.2.0/grid/OPatch/opatch lsinventory -oh /oracle/12.2.0/grid Oracle Interim Patch Installer version 12.2.0.1.14 Copyright (c) 2018, Oracle Corporation. All rights reserved. Oracle Home : /oracle/12.2.0/grid Central Inventory : /oracle/app/oraInventory from : /oracle/12.2.0/grid/oraInst.loc OPatch version : 12.2.0.1.14 OUI version : 12.2.0.1.4 Log file location : /oracle/12.2.0/grid/cfgtoollogs/opatch/opatch2018-11-18_17-57-39PM_1.log Lsinventory Output file location : /oracle/12.2.0/grid/cfgtoollogs/opatch/lsinv/lsinventory2018-11-18_17-57-39PM.txt -------------------------------------------------------------------------------- Local Machine Information:: Hostname:...

12c data file movement through rman

- May 17, 2018

backup as copy datafile 7 format '+ORADATA2'; switch datafile 7 to copy; DELETE DATAFILECOPY '+ORADATA1U*******_aml/datafile/*xxx_ts.272.949091579';