The Geek Diary

CONCEPTS | BASICS | HOWTO

oracle 12c

Oracle Database 12.2 RMAN Cross Platform Tablespace Transport Over Network

By

Oracle Database 12.1 introduced cross platform data transport using backup-sets. We could perform database/tablespace backups using FOR TRANSPORT/TO PLATFORM clause and restore the same to a different OS Platform. This typically involved 3 steps: create backup on source, copy backup-piece to destination and perform restoration on destination. Starting from 12.2, we can perform cross platform transport of datafiles directly over the network using the FROM SERVICE clause along with the RESTORE … [Read more...] about Oracle Database 12.2 RMAN Cross Platform Tablespace Transport Over Network

ORA-12547: TNS:lost Contact (Oracle 12c2)

By

The Problem While connecting the database as sysdba, we are getting below error: sqlplus /as sysdba SQL*Plus: Release 12.2.0.1.0 Production on Wed May 10 00:40:31 2017 Copyright (c) 1982, 2016, Oracle. All rights reserved. ERROR: ORA-12547: TNS:lost contact The version of Oracle database used here is 12.2.0.1.0. The Solution The solution is quite simple here. The OS variable ORACLE_BASE was not set specifically here. Just set this variable into the bash profile of oracle user … [Read more...] about ORA-12547: TNS:lost Contact (Oracle 12c2)

How to Create Interval-Reference Partitioned Tables in Oracle 12c

By

This is an example for the 12c new feature of creating interval partitioned tables as parent tables for reference partitioning. 1. Partitions in a reference-partitioned table corresponding to interval partitions in the parent table are created when inserting records into the reference partitioned table. CREATE TABLE parent (pk INT CONSTRAINT parent_pk PRIMARY KEY, i INT) PARTITION BY RANGE(i) INTERVAL (10) (partition p_p0 values less than ( 0), partition p_p1 values less than … [Read more...] about How to Create Interval-Reference Partitioned Tables in Oracle 12c

How To Create an Encrypted Tablespace in Oracle 12c Pluggable Database

By

Question: How to create an encrypted tablespace in a 12c pluggable database of multi tenant DB? To create an encrypted tablespace in a 12c pluggable database requires some additional steps as compared to previous version 11g. The reason is by default the wallet does not hold a tablespace key for the pluggable databases. 1. Set parameter encryption_wallet_location in sqlnet.ora Example sqlnet.ora: # sqlnet.ora Network Configuration File: … [Read more...] about How To Create an Encrypted Tablespace in Oracle 12c Pluggable Database

Oracle Database – How to Rename a Datafile with Special Characters Created by Mistake

By

Question: We have mistakenly create a datafile with special charatcers. Also we get error ORA-01516 when we try to rename it using the normal method: sql> alter database rename file 'old_file_name' to 'new_file_name'; The Solution 1. Bring the Tablespace offline. sql> alter tablespace [tablespace name] offline; 2. Copy/Move the File at the OS level specifying the correct file name. 3. If there is no special character then the solution is: sql> alter database rename file … [Read more...] about Oracle Database – How to Rename a Datafile with Special Characters Created by Mistake