Recent Blogs

Oct 2016

Mar 2016

This is called Multitenant architect of Oracle Database introduced in 12c database version which consist of two terms CDB and PDB. CDB as container and PDB is pluggabled database. There will be one container database in which different PDB will be residing , we can plug and uplug the PDB

Various methods can be used to upgrade the database like – 1)Database Upgrade Assistant (DBUA)2)Manual Upgrade3)Transportable Tablespaces4)Datapump export/import5)Oracle Streams6)Oracle GoldenGateI am currently using DBUA method to upgrade the database .Steps to follow for upgrade the database: Take backup of database to be upgraded. Stop Database components (i.e. database

As we know that if you want to upgrade Oracle 11.2.0.1 database to 12.1.0.1 version that is not possible directly so we have to first upgrade from 11.2.0.1 to 11.2.0.4 version then 11.2.0.4 is upgraded to 12.1.0.1 version.I am using RMAN approach to upgrade 11.2.0.1 database versionSteps to follow :Backup

Various methods can be used to upgrade the database like – 1)Database Upgrade Assistant (DBUA)2)Manual Upgrade3)Transportable Tablespaces4)Datapump export/import5)Oracle Streams6)Oracle GoldenGateI am currently using DBUA method to upgrade the database . Steps to follow for upgrade the database . Take backup of database to be upgraded. Stop Database components

You will face error message during oracle 12c software installation that looks like this :You just need to check your machine IP address and Hostname and make a entry in /etc/hosts file then it will work fine.Installation time issue -- PRVF-0002 : Could Not Reterive Local Node Name[root@oellinux oracle]# vi

For adding new disk, there should be new disk added to the virtual machine using add harddisk option , or create a free space in your hard disk first.Check various disk/partition mounted on your linux OS and thier free space [root@oellinux ~]# df -hFilesystem

1.check the default port number entry from registry - regeditOn the left side of the Registry Editor, browse to the following folder:HKEY_LOCAL_MACHINESystemCurrentControlSetControlTerminalServerWinStationsRDP-TcpOn the right side, find and double-click the PortNumber key,On the editing dialog box, choose the Decimal option.Type in the allocated port number, click OK, and then close the

Jan 2016

Category: blogs
Comments: 0

Recently while building Exadata Simulator for Training my students I had issue in Connecting from Exadata Compute Node( DB Server) to Storage Cell.

Configuration:

DB server/Compute Node : 1 = exadbserver1
Storage Cell: 2 = exacell01 and exacell02

[root@exadbserver1 trace]# /grid/stage/ext/bin/kfod disk=all op=disks
--------------------------------------------------------------------------------
Disk Size Path User Group
================================================================================
1: 448 Mb o/192.168.56.151/DATA_CD_DISK01_stocell1
2: 448 Mb o/192.168.56.151/DATA_CD_DISK02_stocell1
3: 448



Recently while building Exadata Simulator for Training my students I had issue in Connecting from Exadata  Compute Node( DB Server) to Storage Cell.

Configuration:

DB server/Compute Node : 1 = exadbserver1
Storage Cell: 2  = exacell01 and exacell02

[root@exadbserver1 trace]# /grid/stage/ext/bin/kfod disk=all op=disks
--------------------------------------------------------------------------------
Disk          Size Path          

Dec 2015



This afernoon i was installing OE/HR Demo script supplied with Oracle 12c Binaries. When I try to install OE schema into one of my pluggable Database PDBOE01 it could not complete successfully as script are not compatible with Container/Pluggable database architecture.

you must modify the script before running otherwise you will

2