Inventory is the index for the oracle installation. All the details about the ORACLE_HOME including different utility versions, patch details etc. If you do a fresh Oracle installation the inventory will be updated. But if you copy the ORACLE binaries from some other location and if you are not updating the inventory, we cannot read […]
All posts by Skant Gupta
Move Datafile From File System To ASM Disk In 11g
Below steps need to be followed to move the datafile to ASM disk group. SOLUTION: 1. Make the datafile offline; SQL> select file_name from dba_data_files; FILE_NAME ——————————————————————————– +DATA/RAC2/DATAFILE/system.260.934026715 +DATA/RAC2/DATAFILE/sysaux.261.934026717 +DATA/RAC2/DATAFILE/undotbs1.262.934026719 +DATA/RAC2/DATAFILE/undotbs2.264.934026727 +DATA/RAC2/DATAFILE/users.265.934026729 /export/home/oracle/user02.dbf alter database datafile ‘/export/home/oracle/user01.dbf’ offline; 2. Connect to RMAN and copy datafile to ASM DISKGROUP RMAN> copy datafile ‘/export/home/oracle/user02.dbf’ to ‘+DATA/RAC2/DATAFILE/user02.db’; Starting backup […]
How to change ASM SYS Password and Creating SYSASM user 11g.
First we can try with normal method SQL> select INSTANCE_NAME from v$instance; INSTANCE_NAME —————- +ASM SQL> ALTER USER sys IDENTIFIED BY <new_password> REPLACE <old_password>; ALTER USER sys IDENTIFIED BY <new_password> REPLACE <old_password> * ERROR at line 1: ORA-01109: database not open We cannot change the password for ASM databases via alter user command. Because passwords are […]
Applying the first RU for Oracle Grid Infrastructure 12.2.0.1
The first RU (Release Update) for Oracle 12.2 is available on most platforms since July 18, 2017. And of course I started applying the first RU for Oracle Grid 12.2.0.1 as soon as it got released. Download the RU 12.2.0.1.170718 for Linux First of all I downloaded the Database RU 12.2.0.1.170718 Patch 26133434 for Linux […]
RU and RUR patches for Oracle 12.2
The first RU (Release Update) for Oracle Database 12.2.0.1 has been released. And Oracle Support provides some very helpful documents to explain the implication of the new RU (Release Update) and RUR (Release Update Revision) patches. As of July 2017, Oracle is modifying the Proactive Patch program for Database and Grid Infrastructure release 12.2 and […]
Truncate table with cascade feature1 in oracle 12c
In oracle 12c TRUNCATE TABLE CASCADE will truncate its child tables, if ON DELETE CASCADE relationship is present on child table. Create one parent and child table with some data SQL> CREATE TABLE DBATEST ( EMPNO number, NAME varchar2(10) , empid number); Table created. SQL> alter table dbatest add constraint emp_pk primary key ( empid); […]
Row limiting clause in oracle 12c
Row limiting clause clause allows sql queries to limit the number of rows returned and to specify a starting row for the return set. 1. Fetch first N rows: SQL> select * from test2 fetch first 5 rows only; OWNER OBJECT_NAME STATUS ——– ——————— ——- SYS I_CCOL1 VALID SYS I_PROXY_ROLE_DATA$_1 VALID SYS C_OBJ# VALID SYS […]
PDB Lockdown Profiles in Oracle 12.2
Use the ALTER LOCKDOWN PROFILE statement to alter a PDB lockdown profile. You can use PDB lockdown profiles in a multitenant environment to restrict user operations in pluggable databases (PDBs). Pluggable databases bring a new separation of database administrator roles. The DBA administers the container database, the CDB, but can then delegate the administration of […]
Convert non partitioned table to partitioned online Oracle 12.2
This is one of the new feature of oracle 12.2 release . Non-partitioned tables can be converted to partitioned table online without any downtime to the application , i.e no impact to the DML activities. Till now for this activity, we were using dbms_redef methods. But in Oracle 12.2 release this has been simplified much. […]
Datapump New features in Oracle 12.2
A lot of enhancements has been done in Oracle 12.2 Release. In this article We will explain the new features of datapump utility in oracle 12.2 Release. 1.Parfile content written to logfile: Till now, log file of expdp or impdp, doesn’t store the content of parfile, The log file used to look as below. Export: Release […]