16 Kasım 2017 Perşembe

14 Kasım 2017 Salı

Oracle 12c Lab2 : PLUG / Clone PDB


CREATE PLUGGABLE DATABASE PDBORCL USING '/disk2/setup_files/pdborcl.xml‘ FILE_NAME_CONVERT=(…………………………);

 CREATE PLUGGABLE DATABASE PDBORCL USING '/disk2/setup_files/pdborcl.xml' NOCOPY || COPY || MOVE TEMPFILE REUSE; 

11 Kasım 2017 Cumartesi

Oracle 12c Lab 1 : Oracle 12c Unplug / Drop Databases

 

ALTER PLUGGABLE DATABASE PDBORCL CLOSE; 

SQL> SELECT name,open_mode FROM v$pdbs;
NAME                   OPEN_MODE 
PDB$SEED            READ ONLY 
PDBORCL              MOUNT 
PDBTST1               READ WRITE  


9 Mart 2017 Perşembe

"ORA-00245: control file backup failed; target is likely on a local file system"


Oracle RAC yapısında control file backup'ını alacağı dizin shared disk (ortak disk) değilse aşağıdaki hatayı alır.

Bunu düzeltmek için node ların görebileceği ortak bir diski RMAN'de aşağıdaki gibi tanımlamak lazım. 

Genellikle ASM kullanıldığından ortak disk alanını belirtmek gereklidir.   


RMAN-03009: failure of backup command on ORA_DISK_1 channel at 03/09/2017 02:34:06
ORA-00245: control file backup failed; target is likely on a local file system


oracle@test </backup/rman> rman target /
Recovery Manager: Release 11.2.0.4.0 - Production on Thu Mar 9 10:13:56 2017
Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.
connected to target database: TEST (DBID=1716363802)

RMAN> show all;

using target database control file instead of recovery catalog
RMAN configuration parameters for database with db_unique_name TEST are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP ON;

7 Nisan 2016 Perşembe

ODA - Create/Delete Database in Command Line

This article explains how to create Database with OAKCLI commands in Oracle Database Appliance.

CREATE Database
I'll create database on 2 nodes with ODA  as a single instance.

1- We have to run command on first node. If execute command on Node 2 then you can receive the following message.


When you run the command to seek the root and oracle password. At the same time we will determine the SYSASM password.

oakcli create database - db ozgurdb