Migrate 11gR2(11.2.0.4) to 12cR2(12.2.0.1) using Full Tranportable

Posted On January 13, 2017

Filed under Uncategorized

Comments Dropped leave a response

This lab will guide to migrate 11.2.0.4 database to 12.2.0.1 from single database to pluggable database.

Create tablespace and users

SQL> create tablespace INMEM datafile '+DATA' size 5G autoextend on maxsize unlimited;
SQL> create temporary tablespace INMEM_TEMP tempfile '+DATA' size 1G autoextend on maxsize unlimited;

SQL> create user inmem identified by inmem default tablespace inmem temporary tablespace inmem_temp;
SQL> grant dba to inmem;

Create tables by using swingbench

SQL> @tab

==============================================================================================
== TABLE INFORMATION 2.0 ==
==============================================================================================

Please enter table name to get info:

Please enter object's owner to get info: INMEM

OWNER                TABLE_NAME                       NUM_ROWS     BLOCKS COMPRESS COMPRESS_FOR PARA DEGREE                               INI_TRANS  MAX_TRANS
-------------------- ------------------------------ ---------- ---------- -------- ------------ ---------------------------------------- ---------- ----------
INMEM                CUSTOMERS                         1000000      17254 DISABLED                       1                                       16        255
INMEM                ADDRESSES                         1500000      17254 DISABLED                       1                                       16        255
INMEM                CARD_DETAILS                      1500000      10114 DISABLED                       1                                       16        255
INMEM                WAREHOUSES                           1000          5 DISABLED                       1                                        1        255
INMEM                ORDER_ITEMS                       4291021      35614 DISABLED                       1                                       16        255
INMEM                ORDERS                            1429790      20314 DISABLED                       1                                       16        255
INMEM                INVENTORIES                        899494      22337 DISABLED                       1                                       16        255
INMEM                PRODUCT_INFORMATION                  1000         28 DISABLED                       1                                        1        255
INMEM                LOGON                             2382984       8074 DISABLED                       1                                       16        255
INMEM                PRODUCT_DESCRIPTIONS                 1000         35 DISABLED                       1                                        1        255
INMEM                ORDERENTRY_METADATA                     4          5 DISABLED                       1                                        1        255

11 rows selected.


col file_name for a50
col SizeMb for a20
SELECT tablespace_name tablespace,file_name,TO_CHAR(bytes /1024 /1024, '999,999,999,999' ) SizeMb ,status ,autoextensible autoextend,increment_by  FROM dba_data_files ORDER BY tablespace_name;

TABLESPACE                     FILE_NAME                                          SIZEMB               STATUS    AUT INCREMENT_BY
------------------------------ -------------------------------------------------- -------------------- --------- --- ------------
EXAMPLE                        +DATA/db11g/datafile/example.291.932338871                      313     AVAILABLE YES           80
INMEM                          +DATA/db11g/datafile/inmem.294.932399825                      5,120     AVAILABLE YES        12800
SYSAUX                         +DATA/db11g/datafile/sysaux.282.932338737                       550     AVAILABLE YES         1280
SYSTEM                         +DATA/db11g/datafile/system.292.932338737                       760     AVAILABLE YES         1280
UNDOTBS1                       +DATA/db11g/datafile/undotbs1.281.932338737                     105     AVAILABLE YES          640
USERS                          +DATA/db11g/datafile/users.280.932338737                          5     AVAILABLE YES          160

Put all tablespaces on source in read only mode.

SQL> alter tablespace users read only;
Tablespace altered.


SQL> alter tablespace inmem read only;
Tablespace altered.

SQL> alter tablespace example read only;
Tablespace altered.

Create directory and perform expert metadata.

SQL> create or replace directory expdumpdir1 as '/tmp';

# expdp \'sys/sys as sysdba\' dumpfile=fulltbs.dmp logfile=fulltbs.log directory=expdumpdir1 full=y transportable=always version=12.0 metrics=y exclude=statistics

 

Create a directory object in the source database that points to the datafiles.

SQL> create or replace directory tts_source as '+DATA/db11g/datafile/';

SQL> grant read,write on directory tts_source to system;

 

Create Pluggable Database on target database

SQL> create pluggable database pdb122 admin user pdbadmin identified by sysadmin role=(dba);

 SQL> alter pluggable database pdb122 open instances=all;

Pluggable database altered.

SQL> alter session set container=pdb122;

Session altered.

Create Database Link from source to target

SQL> create database link db11g connect to system identified by sysadmin using 'db11g';

Database link created.

 

Create all directories on source database

SQL> create or replace directory tts_dest as '+MGMT/CDB12R2/454F173160EA2660E0532901A8C0FEFC/DATAFILE/';

SQL> create or replace directory expdumdest as '/tmp';

 

Get all files from ASM

BEGIN
DBMS_FILE_TRANSFER.PUT_FILE(
source_directory_object      => 'tts_source',
source_file_name             => 'example.291.932338871',
source_database              => 'DB11G',
destination_directory_object => 'tts_dest',
destination_file_name        => 'example.dbf');
END;
/


BEGIN
DBMS_FILE_TRANSFER.PUT_FILE(
source_directory_object      => 'tts_source',
source_file_name             => 'inmem.294.932399825',
source_database              => 'DB11G',
destination_directory_object => 'tts_dest',
destination_file_name        => 'inmem.dbf');
END;
/


BEGIN
DBMS_FILE_TRANSFER.PUT_FILE(
source_directory_object      => 'tts_source',
source_file_name             => 'users.280.932338737',
source_database              => 'DB11G',
destination_directory_object => 'tts_dest',
destination_file_name        => 'user.dbf');
END;
/

Perform data files plug and metadata import.

impdp \'sys/sysadmin@pdb122 as sysdba\' directory=expdumdest dumpfile=fulltbs.dmp  version=12 full=y metrics=y logfile=expdumdest:fulltbs.log TRANSPORT_DATAFILES='+MGMT/cdb12r2/454F173160EA2660E0532901A8C0FEFC/DATAFILE/example.dbf','+MGMT/cdb12r2/454F173160EA2660E0532901A8C0FEFC/DATAFILE/user.dbf','+MGMT/cdb12r2/454F173160EA2660E0532901A8C0FEFC/DATAFILE/inmem.dbf'

Checking the pluggable database after successful import

[oracle@stbdb1 admin]$ sqlplus sys/sysadmin@pdb122 as sysdba

SQL*Plus: Release 12.2.0.1.0 Production on Wed Jan 4 21:49:11 2017

Copyright (c) 1982, 2016, Oracle.  All rights reserved.


Connected to:
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production

SQL> show pdbs

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         4 PDB122                         READ WRITE NO
         
SQL>@pdb_users

CONID USERNAME                  STATUS               Default Tablespace   Temp Tablespace      COM PROFILE                    PDB_NAME
----- ------------------------- -------------------- -------------------- -------------------- --- -------------------------- --------------------
    1 ANONYMOUS                 EXPIRED & LOCKED     SYSAUX               TEMP                 YES DEFAULT
    1 APEX_030200               EXPIRED & LOCKED     SYSAUX               TEMP                 NO  DEFAULT
    1 APEX_PUBLIC_USER          EXPIRED & LOCKED     USERS                TEMP                 NO  DEFAULT
    1 APPQOSSYS                 EXPIRED & LOCKED     SYSAUX               TEMP                 YES DEFAULT
    1 AUDSYS                    EXPIRED & LOCKED     SYSTEM               TEMP                 YES DEFAULT
    1 BI                        EXPIRED & LOCKED     USERS                TEMP                 NO  DEFAULT
    1 CTXSYS                    EXPIRED & LOCKED     SYSAUX               TEMP                 YES DEFAULT
    1 DBSFWUSER                 EXPIRED & LOCKED     SYSTEM               TEMP                 YES DEFAULT
    1 DBSNMP                    EXPIRED & LOCKED     SYSAUX               TEMP                 YES DEFAULT
    1 DIP                       EXPIRED & LOCKED     SYSTEM               TEMP                 YES DEFAULT
    1 DVF                       EXPIRED & LOCKED     SYSAUX               TEMP                 YES DEFAULT
    1 DVSYS                     EXPIRED & LOCKED     SYSAUX               TEMP                 YES DEFAULT
    1 FLOWS_FILES               EXPIRED & LOCKED     SYSAUX               TEMP                 NO  DEFAULT
    1 GGSYS                     EXPIRED & LOCKED     SYSAUX               TEMP                 YES DEFAULT
    1 GSMADMIN_INTERNAL         EXPIRED & LOCKED     SYSAUX               TEMP                 YES DEFAULT
    1 GSMCATUSER                EXPIRED & LOCKED     SYSTEM               TEMP                 YES DEFAULT
    1 GSMUSER                   EXPIRED & LOCKED     SYSTEM               TEMP                 YES DEFAULT
    1 HR                        EXPIRED & LOCKED     USERS                TEMP                 NO  DEFAULT
    1 IX                        EXPIRED & LOCKED     USERS                TEMP                 NO  DEFAULT
    1 LBACSYS                   EXPIRED & LOCKED     SYSTEM               TEMP                 YES DEFAULT
    1 MDDATA                    EXPIRED & LOCKED     SYSTEM               TEMP                 YES DEFAULT
    1 MDSYS                     EXPIRED & LOCKED     SYSAUX               TEMP                 YES DEFAULT
    1 MGMT_VIEW                 EXPIRED & LOCKED     SYSTEM               TEMP                 NO  DEFAULT
    1 OE                        EXPIRED & LOCKED     USERS                TEMP                 NO  DEFAULT
    1 OJVMSYS                   EXPIRED & LOCKED     SYSTEM               TEMP                 YES DEFAULT
    1 OLAPSYS                   EXPIRED & LOCKED     SYSAUX               TEMP                 YES DEFAULT
    1 ORACLE_OCM                EXPIRED & LOCKED     SYSTEM               TEMP                 YES DEFAULT
    1 ORDDATA                   EXPIRED & LOCKED     SYSAUX               TEMP                 YES DEFAULT
    1 ORDPLUGINS                EXPIRED & LOCKED     SYSAUX               TEMP                 YES DEFAULT
    1 ORDSYS                    EXPIRED & LOCKED     SYSAUX               TEMP                 YES DEFAULT
    1 OUTLN                     EXPIRED & LOCKED     SYSTEM               TEMP                 YES DEFAULT
    1 OWBSYS                    EXPIRED & LOCKED     SYSAUX               TEMP                 NO  DEFAULT
    1 OWBSYS_AUDIT              EXPIRED & LOCKED     SYSAUX               TEMP                 NO  DEFAULT
    1 PM                        EXPIRED & LOCKED     USERS                TEMP                 NO  DEFAULT
    1 REMOTE_SCHEDULER_AGENT    EXPIRED & LOCKED     SYSTEM               TEMP                 YES DEFAULT
    1 SCOTT                     EXPIRED & LOCKED     USERS                TEMP                 NO  DEFAULT
    1 SH                        EXPIRED & LOCKED     USERS                TEMP                 NO  DEFAULT
    1 SI_INFORMTN_SCHEMA        EXPIRED & LOCKED     SYSAUX               TEMP                 YES DEFAULT
    1 SPATIAL_CSW_ADMIN_USR     EXPIRED & LOCKED     SYSTEM               TEMP                 YES DEFAULT
    1 SPATIAL_WFS_ADMIN_USR     EXPIRED & LOCKED     USERS                TEMP                 NO  DEFAULT
    1 SYS$UMF                   EXPIRED & LOCKED     SYSTEM               TEMP                 YES DEFAULT
    1 SYSBACKUP                 EXPIRED & LOCKED     SYSTEM               TEMP                 YES DEFAULT
    1 SYSDG                     EXPIRED & LOCKED     SYSTEM               TEMP                 YES DEFAULT
    1 SYSKM                     EXPIRED & LOCKED     SYSTEM               TEMP                 YES DEFAULT
    1 SYSMAN                    EXPIRED & LOCKED     SYSAUX               TEMP                 NO  DEFAULT
    1 SYSRAC                    EXPIRED & LOCKED     SYSTEM               TEMP                 YES DEFAULT
    1 WMSYS                     EXPIRED & LOCKED     SYSAUX               TEMP                 YES DEFAULT
    1 XDB                       EXPIRED & LOCKED     SYSAUX               TEMP                 YES DEFAULT
    1 XS$NULL                   EXPIRED & LOCKED     SYSTEM               TEMP                 YES DEFAULT
    1 INMEM                     OPEN                 INMEM                INMEM_TEMP           NO  DEFAULT
    1 SYSTEM                    OPEN                 SYSTEM               TEMP                 YES DEFAULT
    1 SYS                       OPEN                 SYSTEM               TEMP                 YES DEFAULT
    9 PDBADM                    OPEN                 SYSTEM               TEMP                 NO  DEFAULT                    PDB122
    9 INMEM                     OPEN                 INMEM                INMEM_TEMP           NO  DEFAULT                    PDB122

Recompile all invalid objects

EXEC UTL_RECOMP.recomp_parallel(64);


SQL> @gather_schema.sql
==============================================================================================
== GATHER SCHEMA STATISTICS ==
==============================================================================================

Please enter scheme name:...INMEM

PL/SQL procedure successfully completed.


visit dborasol.wordpress.com for more information (DB Oracle Solutions)

SQL> show pdbs

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         9 PDB122                         READ WRITE NO
SQL> @tab

==============================================================================================
== TABLE INFORMATION 2.0 ==
==============================================================================================

Please enter table name to get info:

Please enter object's owner to get info: INMEM

OWNER                TABLE_NAME             NUM_ROWS     BLOCKS COMPRESS COMPRESS_FOR                   PARA DEGREE                               INI_TRANS  MAX_TRANS
-------------------- -------------------- ---------- ---------- -------- ------------------------------ ---------------------------------------- ---------- ----------
INMEM                ADDRESSES               1500000      17254 DISABLED                                         1                                       16        255
INMEM                CARD_DETAILS            1500000      10114 DISABLED                                         1                                       16        255
INMEM                CUSTOMERS               1000000      17254 DISABLED                                         1                                       16        255
INMEM                WAREHOUSES                 1000          5 DISABLED                                         1                                        1        255
INMEM                ORDER_ITEMS             4291021      35614 DISABLED                                         1                                       16        255
INMEM                ORDERS                  1429790      20314 DISABLED                                         1                                       16        255
INMEM                INVENTORIES              899494      22337 DISABLED                                         1                                       16        255
INMEM                PRODUCT_INFORMATION        1000         28 DISABLED                                         1                                        1        255
INMEM                LOGON                   2382984       8074 DISABLED                                         1                                       16        255
INMEM                PRODUCT_DESCRIPTIONS       1000         35 DISABLED                                         1                                        1        255
INMEM                ORDERENTRY_METADATA           4          5 DISABLED                                         1                                        1        255

11 rows selected.

 

All data moved, cheers!

 

 

DBaaS – Deploy a Service Instance

Posted On November 24, 2016

Filed under Uncategorized

Comments Dropped leave a response

This lab will guide you how to create a DB Service with Oracle DB Cloud Service.

Log in to the Oracle Database Cloud Service (DBaaS) console using the credentials provided by your Oracle Cloud account administrator.

Create Service

dbcs_createservice01

The two types of service level are Oracle Database Cloud Service and Oracle Database Cloud Service – Virtual Image.

  • You can choose the Oracle Database Cloud Service service level to have the wizard create a database instance for you, using configuration options provided in the wizard. This service level also makes additional cloud tooling available for backup, recovery and patching.
  • You can choose the Oracle Database Cloud Service – Virtual Image service level to define a database instance manually or using the Oracle Database Creation Assistant (DBCA).

dbcs_createservice02

 Oracle version 12.2.01

dbcs_createservice03

Enterprise Edition Extreme Performance

dbcs_createservice04

Name server and password

dbcs_createservice05

push Create button to create a service.

dbcs_createservice06

Logon to DB VM machine and check service runing.

dbcs_createservice07

Oracle IaaS – Private Cloud: Clone VM from Template

Posted On October 27, 2016

Filed under Uncategorized

Comments Dropped leave a response

This lab guide you how to clone from VM Template through Oracle Enterprise Manager 13cR2.

From Oracle VM Page.

iaas01

Click on OVMServer => Deploy Template

iaas02

Choice template to deploy

iaas03

Enter name for the Guest VM

iaas04

Input all information required

iaas05

iaas06

iaas07

Click on submit and then monitor job

iaas08

The Job cloning VM

iaas09

The VM OracleCloud_01 has been deployed.

iaas10

Cheers! 🙂

 

Troubleshooting with Wait Event enq: TX – row lock contention

Posted On August 30, 2016

Filed under Uncategorized

Comments Dropped leave a response

This post just show how to use AWR and ASH to identify wait event: enq: TX – row lock contention. With this wait event, please refer Oracle Doc ID for more information

WAITEVENT: “enq: TX – row lock contention” Reference Note (Doc ID 1966048.1)

“enq: TX – row lock contention” waits are generally related to the application code being executed and do not indicate a problem with the DB itself.

Identify the number of Average Active Session: the AAS suddenly increased and nearly reached to number of CPU Cores from 11:00  to 11:15

tx1

Continue to identify the wait event. You will see highest wait on DB Time is enq: TX – row lock contention with 85%.

tx2

Now get SQL information from the wait event you analysis. You will see the SQL ID 8qm55qq6guapj is the root cause.

tx3

Get Execution Plan from the SQL ID given. This is and UPDATE command. I believed the session did not commit after updating for a long time. Checking with application team to change code to reduce this.Altering code so that concurrent sessions work on non-intersecting data sets, committing more frequently if the blocker is a long running transaction, etc..

tx4

 

12cR2 Database Installation & Creation (Beta Testing)

Posted On May 31, 2016

Filed under Uncategorized

Comments Dropped leave a response

Run software installation:

# runInstaller

db1db2db3db4db5db6db7db8db9db10db11

Create ASM Diskgroups:

[oracle@pridb1 ~]$ . oraenv
ORACLE_SID = [db12c1] ? +ASM1
The Oracle base has been changed from /oracle/12.1.0.2 to /oracle/gridbase

# asmca

asm1asm2

Create CDB Database:

[oracle@pridb1 ~]$ . oraenv
ORACLE_SID = [+ASM1] ? db12c1
The Oracle base has been changed from /oracle/gridbase to /oracle/12.1.0.2

# dbca

dbca1dbca2dbca3dbca4dbca5dbca6dbca7dbca8dbca9dbca10dbca11dbca12dbca13dbca14dbca15dbca16dbca17dbca18dbca19

Testing 12cR2 new features.

12cR2 – Grid Infrastructure Installation (Beta Testing)

Posted On May 30, 2016

Filed under Uncategorized

Comments Dropped leave a response

These basic steps for Grid Infra setup (beta version), the main release for 12cR2 will be soon on June or July 🙂

Run GridSetup.sh and perform  installation

Grid1Grid2Grid3Grid4Grid5Grid6Grid7Grid8Grid9Grid10grid11Grid12Grid13Grid14

Grid15

Run root.sh on both nodes: pridb1 & pridb2

[root@pridb1 oracle]# /oracle/grid12cr2/root.sh
Performing root user operation.

The following environment variables are set as:
ORACLE_OWNER= oracle
ORACLE_HOME=  /oracle/grid12cr2

Enter the full pathname of the local bin directory: [/usr/local/bin]:
The contents of “dbhome” have not changed. No need to overwrite.
The contents of “oraenv” have not changed. No need to overwrite.
The contents of “coraenv” have not changed. No need to overwrite.

Entries will be added to the /etc/oratab file as needed by
Database Configuration Assistant when a database is created
Finished running generic part of root script.
Now product-specific root actions will be performed.
Relinking oracle with rac_on option
Using configuration parameter file: /oracle/grid12cr2/crs/install/crsconfig_params
The log of current session can be found at:
/oracle/gridbase/crsdata/pridb1/crsconfig/rootcrs_pridb1_2016-05-31_05-50-41AM.log
2016/05/31 05:50:45 CLSRSC-594: Executing installation step 1 of 19: ‘SetupTFA’.
2016/05/31 05:50:45 CLSRSC-4001: Installing Oracle Trace File Analyzer (TFA) Collector.
2016/05/31 05:51:20 CLSRSC-4002: Successfully installed Oracle Trace File Analyzer (TFA) Collector.
2016/05/31 05:51:20 CLSRSC-594: Executing installation step 2 of 19: ‘ValidateEnv’.
2016/05/31 05:51:25 CLSRSC-594: Executing installation step 3 of 19: ‘CheckFirstNode’.
2016/05/31 05:51:26 CLSRSC-594: Executing installation step 4 of 19: ‘GenSiteGUIDs’.
2016/05/31 05:51:27 CLSRSC-594: Executing installation step 5 of 19: ‘SaveParamFile’.
2016/05/31 05:51:32 CLSRSC-594: Executing installation step 6 of 19: ‘SetupOSD’.
2016/05/31 05:51:32 CLSRSC-594: Executing installation step 7 of 19: ‘CheckCRSConfig’.
2016/05/31 05:51:33 CLSRSC-594: Executing installation step 8 of 19: ‘SetupLocalGPNP’.
root wallet
Operation is successfully completed.
root wallet cert
Operation is successfully completed.
root cert export
Operation is successfully completed.
peer wallet
Operation is successfully completed.
profile reader wallet
Operation is successfully completed.
pa wallet
Operation is successfully completed.
peer wallet keys
Operation is successfully completed.
pa wallet keys
Operation is successfully completed.
peer cert request
Operation is successfully completed.
pa cert request
Operation is successfully completed.
peer cert
pa cert
peer root cert TP
Operation is successfully completed.
profile reader root cert TP
Operation is successfully completed.
pa root cert TP
Operation is successfully completed.
peer pa cert TP
Operation is successfully completed.
pa peer cert TP
Operation is successfully completed.
profile reader pa cert TP
Operation is successfully completed.
profile reader peer cert TP
Operation is successfully completed.
peer user cert
Operation is successfully completed.
pa user cert
Operation is successfully completed.
2016/05/31 05:51:49 CLSRSC-594: Executing installation step 9 of 19: ‘ConfigOLR’.
OLR initialization – successful
2016/05/31 05:51:55 CLSRSC-594: Executing installation step 10 of 19: ‘ConfigCHMOS’.
2016/05/31 05:51:55 CLSRSC-594: Executing installation step 11 of 19: ‘CreateOHASD’.
2016/05/31 05:51:58 CLSRSC-594: Executing installation step 12 of 19: ‘ConfigOHASD’.
2016/05/31 05:52:13 CLSRSC-330: Adding Clusterware entries to file ‘oracle-ohasd.conf’
2016/05/31 05:52:34 CLSRSC-594: Executing installation step 13 of 19: ‘InstallAFD’.
2016/05/31 05:52:38 CLSRSC-594: Executing installation step 14 of 19: ‘InstallACFS’.
CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on ‘pridb1’
CRS-2793: Shutdown of Oracle High Availability Services-managed resources on ‘pridb1’ has completed
CRS-4133: Oracle High Availability Services has been stopped.
CRS-4123: Oracle High Availability Services has been started.
2016/05/31 05:53:12 CLSRSC-594: Executing installation step 15 of 19: ‘InstallKA’.
2016/05/31 05:53:16 CLSRSC-594: Executing installation step 16 of 19: ‘InitConfig’.
CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on ‘pridb1’
CRS-2793: Shutdown of Oracle High Availability Services-managed resources on ‘pridb1’ has completed
CRS-4133: Oracle High Availability Services has been stopped.
CRS-4123: Oracle High Availability Services has been started.
CRS-2672: Attempting to start ‘ora.evmd’ on ‘pridb1’
CRS-2672: Attempting to start ‘ora.mdnsd’ on ‘pridb1’
CRS-2676: Start of ‘ora.mdnsd’ on ‘pridb1’ succeeded
CRS-2676: Start of ‘ora.evmd’ on ‘pridb1’ succeeded
CRS-2672: Attempting to start ‘ora.gpnpd’ on ‘pridb1’
CRS-2676: Start of ‘ora.gpnpd’ on ‘pridb1’ succeeded
CRS-2672: Attempting to start ‘ora.cssdmonitor’ on ‘pridb1’
CRS-2672: Attempting to start ‘ora.gipcd’ on ‘pridb1’
CRS-2676: Start of ‘ora.cssdmonitor’ on ‘pridb1’ succeeded
CRS-2676: Start of ‘ora.gipcd’ on ‘pridb1’ succeeded
CRS-2672: Attempting to start ‘ora.cssd’ on ‘pridb1’
CRS-2672: Attempting to start ‘ora.diskmon’ on ‘pridb1’
CRS-2676: Start of ‘ora.diskmon’ on ‘pridb1’ succeeded
CRS-2676: Start of ‘ora.cssd’ on ‘pridb1’ succeeded

[TRIVIAL] [DBT-30001] Disk Groups created successfully. Check /oracle/gridbase/cfgtoollogs/asmca/asmca-160531AM055352.log for details.

2016/05/31 05:54:41 CLSRSC-482: Running command: ‘/oracle/grid12cr2/bin/ocrconfig -upgrade oracle oinstall’
CRS-2672: Attempting to start ‘ora.crf’ on ‘pridb1’
CRS-2672: Attempting to start ‘ora.storage’ on ‘pridb1’
CRS-2676: Start of ‘ora.storage’ on ‘pridb1’ succeeded
CRS-2676: Start of ‘ora.crf’ on ‘pridb1’ succeeded
CRS-2672: Attempting to start ‘ora.crsd’ on ‘pridb1’
CRS-2676: Start of ‘ora.crsd’ on ‘pridb1’ succeeded
CRS-4256: Updating the profile
Successful addition of voting disk 52747b0eeba94ff3bf06eb6641974f35.
Successfully replaced voting disk group with +OCR.
CRS-4256: Updating the profile
CRS-4266: Voting file(s) successfully replaced
##  STATE    File Universal Id                File Name Disk group
—  —–    —————–                ——— ———
1. ONLINE   52747b0eeba94ff3bf06eb6641974f35 (ORCL:DISK04) [OCR]
Located 1 voting disk(s).
CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on ‘pridb1’
CRS-2673: Attempting to stop ‘ora.crsd’ on ‘pridb1’
CRS-2677: Stop of ‘ora.crsd’ on ‘pridb1’ succeeded
CRS-2673: Attempting to stop ‘ora.asm’ on ‘pridb1’
CRS-2673: Attempting to stop ‘ora.crf’ on ‘pridb1’
CRS-2673: Attempting to stop ‘ora.drivers.acfs’ on ‘pridb1’
CRS-2673: Attempting to stop ‘ora.gpnpd’ on ‘pridb1’
CRS-2673: Attempting to stop ‘ora.mdnsd’ on ‘pridb1’
CRS-2677: Stop of ‘ora.drivers.acfs’ on ‘pridb1’ succeeded
CRS-2677: Stop of ‘ora.crf’ on ‘pridb1’ succeeded
CRS-2677: Stop of ‘ora.gpnpd’ on ‘pridb1’ succeeded
CRS-2677: Stop of ‘ora.mdnsd’ on ‘pridb1’ succeeded
CRS-2677: Stop of ‘ora.asm’ on ‘pridb1’ succeeded
CRS-2673: Attempting to stop ‘ora.cluster_interconnect.haip’ on ‘pridb1’
CRS-2677: Stop of ‘ora.cluster_interconnect.haip’ on ‘pridb1’ succeeded
CRS-2673: Attempting to stop ‘ora.ctssd’ on ‘pridb1’
CRS-2673: Attempting to stop ‘ora.evmd’ on ‘pridb1’
CRS-2677: Stop of ‘ora.ctssd’ on ‘pridb1’ succeeded
CRS-2677: Stop of ‘ora.evmd’ on ‘pridb1’ succeeded
CRS-2673: Attempting to stop ‘ora.cssd’ on ‘pridb1’
CRS-2677: Stop of ‘ora.cssd’ on ‘pridb1’ succeeded
CRS-2673: Attempting to stop ‘ora.gipcd’ on ‘pridb1’
CRS-2677: Stop of ‘ora.gipcd’ on ‘pridb1’ succeeded
CRS-2793: Shutdown of Oracle High Availability Services-managed resources on ‘pridb1’ has completed
CRS-4133: Oracle High Availability Services has been stopped.
2016/05/31 05:55:30 CLSRSC-594: Executing installation step 17 of 19: ‘StartCluster’.
CRS-4123: Starting Oracle High Availability Services-managed resources
CRS-2672: Attempting to start ‘ora.mdnsd’ on ‘pridb1’
CRS-2672: Attempting to start ‘ora.evmd’ on ‘pridb1’
CRS-2676: Start of ‘ora.mdnsd’ on ‘pridb1’ succeeded
CRS-2676: Start of ‘ora.evmd’ on ‘pridb1’ succeeded
CRS-2672: Attempting to start ‘ora.gpnpd’ on ‘pridb1’
CRS-2676: Start of ‘ora.gpnpd’ on ‘pridb1’ succeeded
CRS-2672: Attempting to start ‘ora.gipcd’ on ‘pridb1’
CRS-2676: Start of ‘ora.gipcd’ on ‘pridb1’ succeeded
CRS-2672: Attempting to start ‘ora.cssdmonitor’ on ‘pridb1’
CRS-2676: Start of ‘ora.cssdmonitor’ on ‘pridb1’ succeeded
CRS-2672: Attempting to start ‘ora.cssd’ on ‘pridb1’
CRS-2672: Attempting to start ‘ora.diskmon’ on ‘pridb1’
CRS-2676: Start of ‘ora.diskmon’ on ‘pridb1’ succeeded
CRS-2676: Start of ‘ora.cssd’ on ‘pridb1’ succeeded
CRS-2672: Attempting to start ‘ora.cluster_interconnect.haip’ on ‘pridb1’
CRS-2672: Attempting to start ‘ora.ctssd’ on ‘pridb1’
CRS-2676: Start of ‘ora.ctssd’ on ‘pridb1’ succeeded
CRS-2676: Start of ‘ora.cluster_interconnect.haip’ on ‘pridb1’ succeeded
CRS-2672: Attempting to start ‘ora.asm’ on ‘pridb1’
CRS-2676: Start of ‘ora.asm’ on ‘pridb1’ succeeded
CRS-2672: Attempting to start ‘ora.storage’ on ‘pridb1’
CRS-2676: Start of ‘ora.storage’ on ‘pridb1’ succeeded
CRS-2672: Attempting to start ‘ora.crf’ on ‘pridb1’
CRS-2676: Start of ‘ora.crf’ on ‘pridb1’ succeeded
CRS-2672: Attempting to start ‘ora.crsd’ on ‘pridb1’
CRS-2676: Start of ‘ora.crsd’ on ‘pridb1’ succeeded
CRS-6023: Starting Oracle Cluster Ready Services-managed resources
CRS-6017: Processing resource auto-start for servers: pridb1
CRS-6016: Resource auto-start has completed for server pridb1
CRS-6024: Completed start of Oracle Cluster Ready Services-managed resources
CRS-4123: Oracle High Availability Services has been started.
2016/05/31 05:57:45 CLSRSC-343: Successfully started Oracle Clusterware stack
2016/05/31 05:57:45 CLSRSC-594: Executing installation step 18 of 19: ‘ConfigNode’.
CRS-2672: Attempting to start ‘ora.ASMNET1LSNR_ASM.lsnr’ on ‘pridb1’
CRS-2676: Start of ‘ora.ASMNET1LSNR_ASM.lsnr’ on ‘pridb1’ succeeded
CRS-2672: Attempting to start ‘ora.asm’ on ‘pridb1’
CRS-2676: Start of ‘ora.asm’ on ‘pridb1’ succeeded
CRS-2672: Attempting to start ‘ora.OCR.dg’ on ‘pridb1’
CRS-2676: Start of ‘ora.OCR.dg’ on ‘pridb1’ succeeded
2016/05/31 05:59:46 CLSRSC-594: Executing installation step 19 of 19: ‘PostConfig’.
2016/05/31 06:00:05 CLSRSC-325: Configure Oracle Grid Infrastructure for a Cluster … succeeded

[root@pridb2 ~]# /oracle/grid12cr2/root.sh
Performing root user operation.

The following environment variables are set as:
ORACLE_OWNER= oracle
ORACLE_HOME=  /oracle/grid12cr2

Enter the full pathname of the local bin directory: [/usr/local/bin]:
The file “dbhome” already exists in /usr/local/bin.  Overwrite it? (y/n)
[n]: y
Copying dbhome to /usr/local/bin …
The file “oraenv” already exists in /usr/local/bin.  Overwrite it? (y/n)
[n]: y
Copying oraenv to /usr/local/bin …
The file “coraenv” already exists in /usr/local/bin.  Overwrite it? (y/n)
[n]: y
Copying coraenv to /usr/local/bin …

Creating /etc/oratab file…
Entries will be added to the /etc/oratab file as needed by
Database Configuration Assistant when a database is created
Finished running generic part of root script.
Now product-specific root actions will be performed.
Relinking oracle with rac_on option
Using configuration parameter file: /oracle/grid12cr2/crs/install/crsconfig_params
The log of current session can be found at:
/oracle/gridbase/crsdata/pridb2/crsconfig/rootcrs_pridb2_2016-05-31_06-00-58AM.log
2016/05/31 06:01:04 CLSRSC-594: Executing installation step 1 of 19: ‘SetupTFA’.
2016/05/31 06:01:04 CLSRSC-4001: Installing Oracle Trace File Analyzer (TFA) Collector.
2016/05/31 06:01:45 CLSRSC-4002: Successfully installed Oracle Trace File Analyzer (TFA) Collector.
2016/05/31 06:01:45 CLSRSC-594: Executing installation step 2 of 19: ‘ValidateEnv’.
2016/05/31 06:01:47 CLSRSC-594: Executing installation step 3 of 19: ‘CheckFirstNode’.
2016/05/31 06:01:49 CLSRSC-594: Executing installation step 4 of 19: ‘GenSiteGUIDs’.
2016/05/31 06:01:49 CLSRSC-594: Executing installation step 5 of 19: ‘SaveParamFile’.
2016/05/31 06:01:52 CLSRSC-594: Executing installation step 6 of 19: ‘SetupOSD’.
2016/05/31 06:01:52 CLSRSC-594: Executing installation step 7 of 19: ‘CheckCRSConfig’.
2016/05/31 06:01:53 CLSRSC-594: Executing installation step 8 of 19: ‘SetupLocalGPNP’.
2016/05/31 06:01:56 CLSRSC-594: Executing installation step 9 of 19: ‘ConfigOLR’.
OLR initialization – successful
2016/05/31 06:01:58 CLSRSC-594: Executing installation step 10 of 19: ‘ConfigCHMOS’.
2016/05/31 06:01:58 CLSRSC-594: Executing installation step 11 of 19: ‘CreateOHASD’.
2016/05/31 06:01:58 CLSRSC-594: Executing installation step 12 of 19: ‘ConfigOHASD’.
2016/05/31 06:02:14 CLSRSC-330: Adding Clusterware entries to file ‘oracle-ohasd.conf’
2016/05/31 06:02:41 CLSRSC-594: Executing installation step 13 of 19: ‘InstallAFD’.
2016/05/31 06:02:42 CLSRSC-594: Executing installation step 14 of 19: ‘InstallACFS’.
CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on ‘pridb2’
CRS-2793: Shutdown of Oracle High Availability Services-managed resources on ‘pridb2’ has completed
CRS-4133: Oracle High Availability Services has been stopped.
CRS-4123: Oracle High Availability Services has been started.
2016/05/31 06:03:13 CLSRSC-594: Executing installation step 15 of 19: ‘InstallKA’.
2016/05/31 06:03:14 CLSRSC-594: Executing installation step 16 of 19: ‘InitConfig’.
CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on ‘pridb2’
CRS-2793: Shutdown of Oracle High Availability Services-managed resources on ‘pridb2’ has completed
CRS-4133: Oracle High Availability Services has been stopped.
CRS-4123: Oracle High Availability Services has been started.
CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on ‘pridb2’
CRS-2673: Attempting to stop ‘ora.drivers.acfs’ on ‘pridb2’
CRS-2677: Stop of ‘ora.drivers.acfs’ on ‘pridb2’ succeeded
CRS-2793: Shutdown of Oracle High Availability Services-managed resources on ‘pridb2’ has completed
CRS-4133: Oracle High Availability Services has been stopped.
2016/05/31 06:03:32 CLSRSC-594: Executing installation step 17 of 19: ‘StartCluster’.
CRS-4123: Starting Oracle High Availability Services-managed resources
CRS-2672: Attempting to start ‘ora.mdnsd’ on ‘pridb2’
CRS-2672: Attempting to start ‘ora.evmd’ on ‘pridb2’
CRS-2676: Start of ‘ora.mdnsd’ on ‘pridb2’ succeeded
CRS-2676: Start of ‘ora.evmd’ on ‘pridb2’ succeeded
CRS-2672: Attempting to start ‘ora.gpnpd’ on ‘pridb2’
CRS-2676: Start of ‘ora.gpnpd’ on ‘pridb2’ succeeded
CRS-2672: Attempting to start ‘ora.gipcd’ on ‘pridb2’
CRS-2676: Start of ‘ora.gipcd’ on ‘pridb2’ succeeded
CRS-2672: Attempting to start ‘ora.cssdmonitor’ on ‘pridb2’
CRS-2676: Start of ‘ora.cssdmonitor’ on ‘pridb2’ succeeded
CRS-2672: Attempting to start ‘ora.cssd’ on ‘pridb2’
CRS-2672: Attempting to start ‘ora.diskmon’ on ‘pridb2’
CRS-2676: Start of ‘ora.diskmon’ on ‘pridb2’ succeeded
CRS-2676: Start of ‘ora.cssd’ on ‘pridb2’ succeeded
CRS-2672: Attempting to start ‘ora.cluster_interconnect.haip’ on ‘pridb2’
CRS-2672: Attempting to start ‘ora.ctssd’ on ‘pridb2’
CRS-2676: Start of ‘ora.ctssd’ on ‘pridb2’ succeeded
CRS-2676: Start of ‘ora.cluster_interconnect.haip’ on ‘pridb2’ succeeded
CRS-2672: Attempting to start ‘ora.asm’ on ‘pridb2’
CRS-2676: Start of ‘ora.asm’ on ‘pridb2’ succeeded
CRS-2672: Attempting to start ‘ora.storage’ on ‘pridb2’
CRS-2676: Start of ‘ora.storage’ on ‘pridb2’ succeeded
CRS-2672: Attempting to start ‘ora.crf’ on ‘pridb2’
CRS-2676: Start of ‘ora.crf’ on ‘pridb2’ succeeded
CRS-2672: Attempting to start ‘ora.crsd’ on ‘pridb2’
CRS-2676: Start of ‘ora.crsd’ on ‘pridb2’ succeeded
CRS-6017: Processing resource auto-start for servers: pridb2
CRS-2673: Attempting to stop ‘ora.LISTENER_SCAN1.lsnr’ on ‘pridb1’
CRS-2672: Attempting to start ‘ora.net1.network’ on ‘pridb2’
CRS-2672: Attempting to start ‘ora.ASMNET1LSNR_ASM.lsnr’ on ‘pridb2’
CRS-2677: Stop of ‘ora.LISTENER_SCAN1.lsnr’ on ‘pridb1’ succeeded
CRS-2676: Start of ‘ora.net1.network’ on ‘pridb2’ succeeded
CRS-2673: Attempting to stop ‘ora.scan1.vip’ on ‘pridb1’
CRS-2672: Attempting to start ‘ora.ons’ on ‘pridb2’
CRS-2677: Stop of ‘ora.scan1.vip’ on ‘pridb1’ succeeded
CRS-2672: Attempting to start ‘ora.scan1.vip’ on ‘pridb2’
CRS-2676: Start of ‘ora.scan1.vip’ on ‘pridb2’ succeeded
CRS-2672: Attempting to start ‘ora.LISTENER_SCAN1.lsnr’ on ‘pridb2’
CRS-2676: Start of ‘ora.ASMNET1LSNR_ASM.lsnr’ on ‘pridb2’ succeeded
CRS-2672: Attempting to start ‘ora.asm’ on ‘pridb2’
CRS-2676: Start of ‘ora.ons’ on ‘pridb2’ succeeded
CRS-2676: Start of ‘ora.LISTENER_SCAN1.lsnr’ on ‘pridb2’ succeeded
CRS-2676: Start of ‘ora.asm’ on ‘pridb2’ succeeded
CRS-6016: Resource auto-start has completed for server pridb2
CRS-6024: Completed start of Oracle Cluster Ready Services-managed resources
CRS-4123: Oracle High Availability Services has been started.
2016/05/31 06:05:29 CLSRSC-343: Successfully started Oracle Clusterware stack
2016/05/31 06:05:29 CLSRSC-594: Executing installation step 18 of 19: ‘ConfigNode’.
2016/05/31 06:05:40 CLSRSC-594: Executing installation step 19 of 19: ‘PostConfig’.
2016/05/31 06:05:48 CLSRSC-325: Configure Oracle Grid Infrastructure for a Cluster … succeeded

 

Grid16

Check cluster components status:

[root@pridb1 oracle]# crsctl stat res -t
——————————————————————————–
Name           Target  State        Server                   State details
——————————————————————————–
Local Resources
——————————————————————————–
ora.ASMNET1LSNR_ASM.lsnr
ONLINE  ONLINE       pridb1                   STABLE
ONLINE  ONLINE       pridb2                   STABLE
ora.LISTENER.lsnr
ONLINE  ONLINE       pridb1                   STABLE
ONLINE  ONLINE       pridb2                   STABLE
ora.OCR.dg
ONLINE  ONLINE       pridb1                   STABLE
ONLINE  ONLINE       pridb2                   STABLE
ora.net1.network
ONLINE  ONLINE       pridb1                   STABLE
ONLINE  ONLINE       pridb2                   STABLE
ora.ons
ONLINE  ONLINE       pridb1                   STABLE
ONLINE  ONLINE       pridb2                   STABLE
ora.proxy_advm
OFFLINE OFFLINE      pridb1                   STABLE
OFFLINE OFFLINE      pridb2                   STABLE
——————————————————————————–
Cluster Resources
——————————————————————————–
ora.LISTENER_SCAN1.lsnr
1        ONLINE  ONLINE       pridb2                   STABLE
ora.LISTENER_SCAN2.lsnr
1        ONLINE  ONLINE       pridb1                   STABLE
ora.LISTENER_SCAN3.lsnr
1        ONLINE  ONLINE       pridb1                   STABLE
ora.MGMTLSNR
1        ONLINE  ONLINE       pridb1                   169.254.25.230 172.1
6.1.11,STABLE
ora.asm
1        ONLINE  ONLINE       pridb1                   Started,STABLE
2        ONLINE  ONLINE       pridb2                   Started,STABLE
3        OFFLINE OFFLINE                               STABLE
ora.cvu
1        ONLINE  ONLINE       pridb1                   STABLE
ora.mgmtdb
1        ONLINE  ONLINE       pridb1                   Open,STABLE
ora.pridb1.vip
1        ONLINE  ONLINE       pridb1                   STABLE
ora.pridb2.vip
1        ONLINE  ONLINE       pridb2                   STABLE
ora.qosmserver
1        ONLINE  ONLINE       pridb1                   STABLE
ora.scan1.vip
1        ONLINE  ONLINE       pridb2                   STABLE
ora.scan2.vip
1        ONLINE  ONLINE       pridb1                   STABLE
ora.scan3.vip
1        ONLINE  ONLINE       pridb1                   STABLE
——————————————————————————–

The End 🙂

 

 

 

 

 

 

DataGuard’s reaction when FarSync is off ?

Posted On December 28, 2015

Filed under Data Guard

Comments Dropped leave a response

One of the most advantages of Oracle DB 12c is Farsync, like the image below, but what happen when FarSync DB is down? How can DG automatic transport log to DR Site?
Image
All details about what is farsync DB, farsync statistics and how to config it in this link : https://dborasol.wordpress.com/2013/10/09/database-12c-far-sync-standby-database/
Today, I setup a lab to show you how to config for Primary DB automatic transport log to Standby DB when FarSync DB is down. Below config will help us in this case:
Init file in Primary (ServiceName: CHICAGO):
log_archive_config='DG_CONFIG=(CHICAGO,CBFS,BOSTON)'
log_archive_dest_2='SERVICE=CBFS SYNC AFFIRM MAX_FAILURE=5 REOPEN=60 ALTERNATE=LOG_ARCHIVE_DEST_3 VALID_FOR=(ONLINE_LOGFILES, PRIMARY_ROLE) DB_UNIQUE_NAME=CBFS'
log_archive_dest_3='SERVICE=BOSTON ASYNC NOAFFIRM ALTERNATE=LOG_ARCHIVE_DEST_2 VALID_FOR=(ONLINE_LOGFILES, PRIMARY_ROLE) DB_UNIQUE_NAME=BOSTON'
log_archive_dest_state_1='enable';
log_archive_dest_state_2='ENABLE'
log_archive_dest_state_3='ALTERNATE'
Init file in FarSync (ServiceName: CBFS):
log_archive_config='DG_CONFIG=(CHICAGO,CBFS,BOSTON)'
log_archive_dest_1='LOCATION=+CBFS VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=CBFS'
log_archive_dest_2='SERVICE=BOSTON ASYNC ALTERNATE =LOG_ARCHIVE_DEST_3 VALID_FOR=(STANDBY_LOGFILES, STANDBY_ROLE) DB_UNIQUE_NAME=BOSTON'
log_archive_dest_3='SERVICE=CHICAGO ASYNC ALTERNATE=LOG_ARCHIVE_DEST_2 VALID_FOR=(STANDBY_LOGFILES, STANDBY_ROLE) DB_UNIQUE_NAME=CHICAGO'
log_archive_dest_state_1='enable';
log_archive_dest_state_2='ENABLE';
log_archive_dest_state_3='ALTERNATE';
Init file in Standby (ServiceName: BOSTON):
log_archive_config='DG_CONFIG=(CHICAGO,CBFS,BOSTON)'
log_archive_dest_1='LOCATION=+BOSTON VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=BOSTON'
log_archive_dest_2='SERVICE=CBFS LGWR ASYNC MAX_FAILURE=2 ALTERNATE=LOG_ARCHIVE_DEST_3 VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=CBFS'
log_archive_dest_3='SERVICE=CHICAGO LGWR ASYNC ALTERNATE=LOG_ARCHIVE_DEST_2 VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=CHICAGO'
log_archive_dest_state_1='enable';
log_archive_dest_state_2='ENABLE';
log_archive_dest_state_3='ALTERNATE';
Normally, log will be tranport to LOG_ARCHIVE_DEST_2, now let see when I shutdown FarSync DB:

Primary:
Capture
Capture1

FarSync:
Capture2

Standby DB:
Capture3

Primary DB try to transport log to FarSync DB but it cannot, this will happend for time we set with REOPEN and MAX_FAILURE in Primary DB.
After REOPEN time (in seconds) x MAX_FAILURE, log will be transport to Standby DB, now log will be sent to LOG_ARCHIVE_DEST_3, and DataGuard is now back to traditional way:

Capture4

With above configurations, when FarSync DB is up, Primary will automatically transport log back to FarSync and log from FarSync will sent to Standby like before.

Hope this help :)

Integrating OVM to OEM 13c Cloud Control

Posted On December 22, 2015

Filed under Uncategorized

Comments Dropped leave a response

Step 1: Plug in OVM to agent

Plug-ins => Oracle Virtualization => Deploy on => Management Agent
OVM1

OVM Plug in information displayed
OVM2

Choose Agent to deploy OVM Plug-ins
OVM3


Click Deploy
OVM4

Show Status
OVM5


Step 2: Register VM Manager to OEM

Click on Target Declarative
OVM6

Choose Agent monitor and target type Oracle VM Manager
OVM7.png
Provide OVM Connection Info
OVM8


Check the status

OVM9

Now test Cloud Infrastructure screen .
OVM10
Hope this help! :)

OEM 13c Installation

Posted On December 22, 2015

Filed under Uncategorized

Comments Dropped leave a response

Create Database repository for EM

dbca -silent -createDatabase -templateName General_Purpose.dbc -gdbName emrepos -sid emrepos -createAsContainerDatabase false -SysPassword sysadmin -SystemPassword sysadmin -emConfiguration NONE -redoLogFileSize 600 -storageType FS -datafileDestination /oracle/12.1.0.1/oradata -characterSet AL32UTF8 -memoryPercentage 40 -automaticMemoryManagement true -sampleSchema true -initParams filesystemio_options=setall,job_queue_processes=1000,log_buffer=10485760,processes=600,open_cursors=1000,session_cached_cursors=1000,shared_pool_size=800M,db_securefile=PERMITTED
Copying database files
1% complete
3% complete
11% complete
18% complete
26% complete
37% complete
Creating and starting Oracle instance
40% complete
45% complete
50% complete
55% complete
60% complete
61% complete
62% complete
65% complete
Completing Database Creation
69% complete
73% complete
76% complete
88% complete
99% complete
100% complete
Look at the log file "/home/oracle/cfgtoollogs/dbca/emrepos/emrepos.log" for further details.

Setup OEM13C installation:

13c_113c_213c_313c_413c_513c_613c_713c_813c_913c_1013c_1113c_1213c_1313c_1413c_1513c_1613c_1713c_1813c_19

For new and exciting features of OEM 13c, check link below

https://blogs.oracle.com/oem/entry/oracle_enterprise_manager_13c_new

Ready for Cloud 🙂

PDB Hot Clone – 12cR2

Posted On November 27, 2015

Filed under Uncategorized

Comments Dropped leave a response

Oracle Database 12c Release 2 PDB Hot Clone, this will make your database move easier than ever. This is just testing purpose, Oracle Database 12c will be release in 2016.

[oracle@db12c orcl12]$ ls -lart
total 2865720
drwxr-x---. 3 oracle vboxsf       4096 Oct 24 22:08 ..
drwxr-x---. 2 oracle vboxsf       4096 Oct 24 22:08 pdbseed
drwxr-x---. 2 oracle vboxsf       4096 Oct 24 22:08 pdb1
drwxr-x---. 4 oracle vboxsf       4096 Oct 24 22:08 .
-rw-r-----. 1 oracle vboxsf    5251072 Nov 26 22:06 users01.dbf
-rw-r-----. 1 oracle vboxsf   52429312 Nov 26 22:10 redo03.log
-rw-r-----. 1 oracle vboxsf   52429312 Nov 26 22:10 redo01.log
-rw-r-----. 1 oracle vboxsf  117448704 Nov 26 22:11 temp01.dbf
-rw-r-----. 1 oracle vboxsf  162537472 Nov 26 22:14 undotbs01.dbf
-rw-r-----. 1 oracle vboxsf 1646272512 Nov 26 22:14 sysaux01.dbf
-rw-r-----. 1 oracle vboxsf  922755072 Nov 26 22:14 system01.dbf
-rw-r-----. 1 oracle vboxsf   18726912 Nov 26 22:14 control01.ctl
-rw-r-----. 1 oracle vboxsf   18726912 Nov 26 22:14 control02.ctl
-rw-r-----. 1 oracle vboxsf   52429312 Nov 26 22:14 redo02.log

mkdir -p /u01/app/oracle/oradata/orcl12/pdb2

create pluggable database pdb2 from pdb1
FILE_NAME_CONVERT = ('/u01/app/oracle/oradata/orcl12/pdb1', '/u01/app/oracle/oradata/orcl12/pdb2');

SQL> col totalsize for 9999999 heading "TotalSize(Mb)"
SQL> select inst_id,con_id,dbid,name,open_mode,round(total_size/1024/1024,1) totalsize from GV$PDBS;

   INST_ID     CON_ID       DBID NAME            OPEN_MODE  TotalSize(Mb)
---------- ---------- ---------- --------------- ---------- -------------
         1          2 3543631094 PDB$SEED        READ ONLY            800
         1          3 3929371449 PDB1            READ WRITE          1086

SQL> create pluggable database pdb2 from pdb1
  2  FILE_NAME_CONVERT = ('/u01/app/oracle/oradata/orcl12/pdb1', '/u01/app/oracle/oradata/orcl12/pdb1');
create pluggable database pdb2 from pdb1
*
ERROR at line 1:
ORA-44607: Archive logging must be enabled.

SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount
ORACLE instance started.

Total System Global Area 1048576000 bytes
Fixed Size                  4590720 bytes
Variable Size             490734464 bytes
Database Buffers          549453824 bytes
Redo Buffers                3796992 bytes
Database mounted.
SQL> alter database archivelog;

Database altered.

SQL> alter system set log_archive_dest_1='LOCATION=/u01/app/oracle/archive' scope=both;

System altered.

SQL> alter database open;

Database altered.

SQL> create pluggable database pdb2 from pdb1
  2  FILE_NAME_CONVERT = ('/u01/app/oracle/oradata/orcl12/pdb1', '/u01/app/oracle/oradata/orcl12/pdb2');

Pluggable database created.

SQL> select inst_id,con_id,dbid,name,open_mode,round(total_size/1024/1024,1) totalsize from GV$PDBS;

   INST_ID     CON_ID       DBID NAME            OPEN_MODE  TotalSize(Mb)
---------- ---------- ---------- --------------- ---------- -------------
         1          2 3543631094 PDB$SEED        READ ONLY            800
         1          3 3929371449 PDB1            READ WRITE          1086
         1          4 4017322761 PDB2            MOUNTED                0

SQL> alter pluggable database pdb2 open;

Pluggable database altered.

SQL> select inst_id,con_id,dbid,name,open_mode,round(total_size/1024/1024,1) totalsize from GV$PDBS;

   INST_ID     CON_ID       DBID NAME            OPEN_MODE  TotalSize(Mb)
---------- ---------- ---------- --------------- ---------- -------------
         1          2 3543631094 PDB$SEED        READ ONLY            800
         1          3 3929371449 PDB1            READ WRITE          1086
         1          4 4017322761 PDB2            READ WRITE           995

Waiting 🙂

Next Page »