Oracle in Action

Subscribe to Oracle in Action feed
Let's do it simply...
Updated: 16 hours 43 min ago

CDB Fleet in Oracle Database 18c

Fri, 2019-05-03 03:21

RSS content

Oracle database 18c  introduces a new CDB Fleet feature  which allows many CDBs to be managed as one. A CDB fleet is a collection of CDBs and hosted PDBs that you can monitor and manage as one logical CDB from a centralized location.

There are two possible roles within a CDB Fleet:

  • Lead CDB: Only one CDB in the Fleet may be designated as the Lead CDB. The lead CDBis the central location for monitoring and managing all the CDBs in the fleet.
  • Member CDB: The CDBs registered with a lead CDB are called member CDBs. There can be one or more member CDB’s in a CDB fleet.

For every  member CDB,  proxy PDBs for the member CDB and its PDB(s) are automatically created in the lead CDB,.  Consequently, all the member CDBs  and their PDBs are now “visible” in the lead CDB . This enables management and monitoring of the entire estate of PDBs in the fleet, physically distributed across various CDBs, from the lead CDB.

Advantages

Reporting, monitoring, and management of the entire CDB fleet through a single interface:

  • Provides massive scalability of the underlying infrastructure
  • Reduces capital and operational costs
  • Provides greater efficiencies to the business.

Related Links:

‘STUB’ Status In DBA_PDBS

References:

https://docs.oracle.com/cd/E96517_01/newft/database-new-features-guide.pdf

https://docs.oracle.com/en/database/oracle/oracle-database/18/multi/administering-cdb-fleet.html#GUID-5951E81B-4351-4FA4-9F7B-52D2FEB0428D



Tags:  

Del.icio.us
Digg

Copyright © ORACLE IN ACTION [CDB Fleet in Oracle Database 18c], All Right Reserved. 2019.

The post CDB Fleet in Oracle Database 18c appeared first on ORACLE IN ACTION.

Categories: DBA Blogs

pdb_to_apppdb.sql returns ORA-65021- A workaround

Tue, 2018-01-09 01:26

RSS content

While exploring Oracle Multitenant Application Containers, I learnt that in order to convert a regular PDB  to an application PDB

  • Clone a regular PDB  into an application root
  • Connect to the cloned  PDB and execute the $ORACLE_HOME/rdbms/admin/pdb_to_apppdb.sql to convert the cloned regular PDB  to an application PDB

However, when I connected to cloned PDB remotely using @… and executed the script pdb_to_apppdb.sql, I got ORA-65021 :

SQL>@$ORACLE_HOME/rdbms/admin/pdb_to_apppdb

 

 

.

.

.

.

 

SQL>create or replace view sys.cdb$common_root_objects&pdbid sharing=object as

2  select u.name owner, o.name object_name, o.type# object_type, o.namespace nsp,

3         o.subname object_subname, o.signature object_sig,

4         decode(bitand(o.flags, &sharing_bits),

5                &edl+&mdl, 'EDL', &dl, 'DL', 'MDL') sharing

6    from sys.obj$ o, sys.user$ u

7   where o.owner#=u.user# and bitand(o.flags, &sharing_bits) <> 0

8     and bitand(o.flags,&fedobjflag)=&fedobjflag;

old   1: create or replace view sys.cdb$common_root_objects&pdbid sharing=object as

new   1: create or replace view sys.cdb$common_root_objects4 sharing=object as

old   4:        decode(bitand(o.flags, &sharing_bits),

new   4:        decode(bitand(o.flags, (65536+131072+4294967296)),

old   5:               &edl+&mdl, 'EDL', &dl, 'DL', 'MDL') sharing

new   5:               4294967296+65536, 'EDL', 131072, 'DL', 'MDL') sharing

old   7:  where o.owner#=u.user# and bitand(o.flags, &sharing_bits) <> 0

new   7:  where o.owner#=u.user# and bitand(o.flags, (65536+131072+4294967296)) <> 0

old   8:    and bitand(o.flags,&fedobjflag)=&fedobjflag

new   8:    and bitand(o.flags,134217728)=134217728

create or replace view sys.cdb$common_root_objects4 sharing=object as

*

ERROR at line 1:

ORA-65021: illegal use of SHARING clause

After various repeated trials, I realized that connecting to cloned PDB using “Alter session set container ..“ results in successful execution.

Here is the full article where I encountered this error and found out the workaround.

I faced similar issue while creating application seed from application root and resolved it by connecting to the  application seed  created from application root using Alter session set container …

Conclusion:  In order to execute the script $ORACLE_HOME/rdbms/admin/pdb_to_apppdb.sql to convert the cloned regular PDB  to an application PDB, connect to the target regular PDB by switching the container. (Do not connect remotely using @)

References:



Tags:  

Del.icio.us
Digg

Copyright © ORACLE IN ACTION [pdb_to_apppdb.sql returns ORA-65021- A workaround], All Right Reserved. 2018.

The post pdb_to_apppdb.sql returns ORA-65021- A workaround appeared first on ORACLE IN ACTION.

Categories: DBA Blogs

I Am Speaking at OTN Yathra 2017

Wed, 2017-06-14 00:42

RSS content

The Oracle ACE directors and Oracle Volunteers  in the region are organizing their third evangelist event called ‘OTNYathra 2017’ during the month of June 2017 in a time period of 3 weeks. This yathra, managed by ACE directors and Oracle Volunteers of the region, is to travel across the country covering over six major IT focused cities (Chennai, Bangalore, Hyderabad,  Pune, Mumbai and Gurgaon) . It aims  to bring the Oracle community together, giving them awareness and improve the level of knowledge and increase the networking opportunities in the region.

I will be speaking at this year’s OTNYathra  about “RAC server Pools: What’s new in Oracle 12c?”.

Oracle Clusterware 11g release 2 (11.2) laid the foundation of policy based cluster management by introducing  server pools as a means for specifying resource placement and administering server allocation and access. However, originally, server pools were restricted to a set of basic attributes characterizing servers as belonging to a given pool. There was no way to distinguish between types of servers; all servers were considered to be equal in relation to their processors, physical memory, and other characteristics. This can lead to  sub-optimal performance of some applications if the servers  assigned to the server pools hosting those applications do not meet the applications’ requirements.

Oracle Grid Infrastructure 12c enhances the use of server pools by introducing server attributes e.g. memory, CPU_count etc. which can be associated with each server. Server pools can be configured so that their members belong to a category of servers, which share a particular set of attributes. Moreover, the administrators can maintain a library of policies and switch between them as required rather than manually reallocating servers to various server pools based on workload.

My presentation discusses in detail the new features of RAC server pools in 12c.

My session will be held on Sunday 25th June, 2017   from 1.30 pm to 2.30 pm in
Room 1, Fidelity International, Unitech Cyber Park, Tower D, Sector 39, Durga Colony, Sector 39, Gurugram, Haryana 122001, India
Hope to meet you there!!



Tags:  

Del.icio.us
Digg

Copyright © ORACLE IN ACTION [I Am Speaking at OTN Yathra 2017], All Right Reserved. 2017.

The post I Am Speaking at OTN Yathra 2017 appeared first on ORACLE IN ACTION.

Categories: DBA Blogs

Oracle Database 12.2.0.1 – Application PDB unable to sync – An update

Tue, 2017-05-02 04:57

RSS content

In my last post, I had demonstrated that without OMF, If an  application creates new datafiles, application PDB’s always fails to sync with the  application.  When I mentioned it to Tim, he raised an SR with Oracle who have clarified that it is  Bug 21933632. Although  it is not documented yet but OMF is mandatory if using the Application Container feature. If it is attempted to sync application PDB’s  with an  application that creates   non-OMF datafile(s),   sync  will run into  problem while trying to replay a create tablespace or similar statement with a hard-coded file name.”

References:

Multitenant: Application Containers in Oracle Database 12c Release 2

————————————————————————————————————————-

Related Links:

Home

Oracle 12c Index

Oracle Database 12.2.0.1 – Application PDB unable to sync



Tags:  

Del.icio.us
Digg

Copyright © ORACLE IN ACTION [Oracle Database 12.2.0.1 – Application PDB unable to sync - An update], All Right Reserved. 2017.

The post Oracle Database 12.2.0.1 – Application PDB unable to sync – An update appeared first on ORACLE IN ACTION.

Categories: DBA Blogs

My Sangam 16 presentation: Policy Based Cluster Management In Oracle 12c

Mon, 2016-11-28 00:23

RSS content

Thanks to all those who attended my session on “Policy Based Cluster Management In Oracle 12c” during Sangam16. I have uploaded my presentation here.

Your comments and feedback are always welcome.



Tags:  

Del.icio.us
Digg

Copyright © ORACLE IN ACTION [My Sangam 16 presentation: Policy Based Cluster Management In Oracle 12c], All Right Reserved. 2016.

The post My Sangam 16 presentation: Policy Based Cluster Management In Oracle 12c appeared first on ORACLE IN ACTION.

Categories: DBA Blogs

I Am Speaking At SANGAM 16

Tue, 2016-11-01 23:11

RSS content

SANGAM is the Largest Independent Oracle Users Group Conference in India, organised annually in the month of November. This year’s Sangam (Sangam16 - 8th Annual Oracle Users Group Conference) will be held  on Friday 11th & Saturday 12th November 2016 at Crowne Plaza,  Bengaluru Electronics City, India .

I will be speaking at this year’s SANGAM about “Policy Based Cluster Management In Oracle 12c“.

Oracle Clusterware 11g R2 introduced server pools as a means for specifying resource placement and administering server allocation and access. However,   all servers were considered to be equal in relation to processors, memory and other characteristics. This can lead to  sub-optimal performance of some applications if the servers  assigned to the server pools hosting those applications do not meet applications’ requirements.

Oracle Grid Infrastructure 12c enhances the use of server pools by introducing server attributes e.g. memory, CPU_count etc. which can be associated with each server. Server pools can be configured so that their members belong to a category of servers, which share a particular set of attributes. Moreover,  administrators can maintain a library of policies and switch between them as required rather than manually reallocating servers to various server pools based on workload. My session will  discuss in detail the new features of policy based cluster management in 12c.

My session will be held on Saturday November 12, 2016 10:05am – 10:55am  in
Room 4.

Hope to meet you there!!



Tags:  

Del.icio.us
Digg

Copyright © ORACLE IN ACTION [I Am Speaking At SANGAM 16], All Right Reserved. 2016.

The post I Am Speaking At SANGAM 16 appeared first on ORACLE IN ACTION.

Categories: DBA Blogs

CRS-2615: Could not find server pool ‘smallpool’

Tue, 2016-09-06 04:37

RSS content

I received this error message when I was playing around with Extended Policy Framework in Oracle Clusterware 12c.

Policy-managed environment in Oracle clusterware 12c offers the capability to create policies to configure pools in accordance with business needs or application demand, so that pools provide the right service at the right time. Typically, administrators create multiple policies to reflect differences in requirements for the cluster based on business needs or demand, or based on calendar dates or times of the day. The collection of zero or more such user defined policies is called cluster policy set. Oracle Clusterware manages the server pools according to the active policy in the policy set. With a cluster configuration policy set, for example, more servers can be allocated to OLTP workload during weekly business, whereas on the weekends and evenings, batch workloads can be assigned more servers, while performing transitions of server pool configuration atomically.

I added Day policy for my Oracle 12.1.0.1 cluster.

[grid@host01 ~]$ crsctl add policy day -attr "DESCRIPTION='The Day Policy'"

When I tried to set  attributes of the  server pool smallpool for day policy, I received the error:

[root@host01 ~]# crsctl modify serverpool smallpool -attr "MAX_SIZE=2,MIN_SIZE=1,SERVER_CATEGORY=small" -policy day
CRS-2615: Could not find server pool 'smallpool'.
CRS-4000: Command Modify failed, or completed with errors.

[root@host01 ~]# oerr CRS 2615
2615, 1, "Could not find server pool '%s'."
// *Cause: An attempt was made to operate on a server pool that is not 
// registered.
// *Action: Check if the server pool is registered.

When I checked, serverpool smallpool existed and had two servers assigned to it

[root@host01 ~]# crsctl status serverpool smallpool
NAME=smallpool
ACTIVE_SERVERS=host04 host05

Reason:
Since server pool smallpool had not been specified to be in the scope of the cluster policy set, I was  getting above error.

Solution:
Add server pool name smallpool to the cluster  policyset

[root@host01 ~]# crsctl modify policyset -attr "SERVER_POOL_NAMES='smallpool free'" -ksp

Now that server pool smallpool has been added to the scope of the policyset, its configuration can be modified for day policy

[root@host01 ~]# crsctl modify serverpool smallpool -attr "MAX_SIZE=2,MIN_SIZE=1" -policy day

I hope this post was helpful.

Your comments and suggestions are always welcome!

Related Links :

Home

12c RAC Index

12c RAC : CRS-2917: The ‘Free’ server pool cannot be removed from the system



Tags:  

Del.icio.us
Digg

Copyright © ORACLE IN ACTION [CRS-2615: Could not find server pool 'smallpool'], All Right Reserved. 2016.

The post CRS-2615: Could not find server pool ‘smallpool’ appeared first on ORACLE IN ACTION.

Categories: DBA Blogs

java.lang nullpointerexception While Installing 12.1.0.2 RAC Database Software

Mon, 2016-04-18 04:41

RSS content

I have an Oracle  12.1.0.2c cluster having following 5 nodes :

  • Hub Nodes : host01, host02, host03
  • Leaf nodes: host04 and host05

I wanted to install RAC database software on the 3 hub nodes i.e. host01, host02 and host03.

I invoked the OUI as oracle user (Owner of Database Home)

[oracle@host01 database_12_1_0_2]$ ./runInstaller

and chose the option to install RAC database software only on the 3 hub nodes.

After all the pre-requisite checks were successful , I clicked the Install button.
I got the error: java.lang nullpointerexception

On clicking OK, the OUI aborted.

To troubleshoot, I ran the OUI in debug mode as :

[oracle@host01 database_12_1_0_2]$ ./runInstaller -debug -J-DTRACING.ENABLED=true -J-DTRACING.LEVEL=2 -J-DSRVM_TRACE_LEVEL=2 -J-DFULLTRACE

The trace file showed that the leaf node host05 was not responding:

[setup.flowWorker] [ 2016-04-18 14:33:22.771 IST ]
[CRSCTLUtil.getClusterNodeConfigRoles:1198] outputs[4] = CRS-4404: The following nodes did not reply within the allotted time:
[setup.flowWorker] [ 2016-04-18 14:33:22.772 IST ]
[CRSCTLUtil.getClusterNodeConfigRoles:1200] values length = 2
[setup.flowWorker] [ 2016-04-18 14:33:22.772 IST ]
[CRSCTLUtil.getClusterNodeConfigRoles:1198] outputs[5] = host05
[setup.flowWorker] [ 2016-04-18 14:33:22.772 IST ]
[CRSCTLUtil.getClusterNodeConfigRoles:1200] values length = 1

I realized that although I wanted to install database software on 3 nodes only, all the nodes
needed to be up and running whereas in my case, the node host05 was down at that time.

When I started the node host05 and reinvoked OUI, the database software was installed
successfully.

References:
http://www.hhutzler.de/blog/oracle-installer-and-rac-installation/



Tags:  

Del.icio.us
Digg

Copyright © ORACLE IN ACTION [java.lang nullpointerexception While Installing 12.1.0.2 RAC Database Software], All Right Reserved. 2016.

The post java.lang nullpointerexception While Installing 12.1.0.2 RAC Database Software appeared first on ORACLE IN ACTION.

Categories: DBA Blogs

I am Oracle ACE

Fri, 2016-04-01 00:49

RSS content

It gives me immense pleasure to share the news that I have been honored with the prestigious  Oracle ACE award. I am grateful to Oracle ACE Program for accepting my nomination. I would like to thank to Murali Vallath Sir who nominated me for this award. I am also thankful to my family members without whose support and motivation, this would not have been possible.  Thanks a lot to all the readers of my blog whose comments and suggestions helped me to learn and share whatever little knowledge I have.

I will do my best to participate in the Oracle ACE program.

 

 



Tags:  

Del.icio.us
Digg

Copyright © ORACLE IN ACTION [I am Oracle ACE], All Right Reserved. 2016.

The post I am Oracle ACE appeared first on ORACLE IN ACTION.

Categories: DBA Blogs

I Am Speaking at OTN Yathra 2016

Tue, 2016-03-22 09:19

RSS content

The Oracle ACE directors and Oracle Volunteers  in the region are organizing their third evangelist event called ‘OTNYathra 2016’ from 23rd  April 2016 to 1st May 2016.  This yathra or tour will a series of 6 conferences across 6 major cities (Chennai, Bangalore, Hyderabad,  Pune, Mumbai and Delhi) managed by ACE directors and Oracle Volunteers of the region.

I will be speaking at this year’s OTNYathra  about Oracle Database 12c new feature : Highly Available NFS (HANFS) over ACFS.

HANFS over ACFS enables highly available NFS servers to be configured using Oracle ACFS clusters. The NFS exports are exposed through Highly Available VIPs (HAVIPs), and this allows Oracle’s Clusterware agents to ensure that HAVIPs and NFS exports are always available. If the node hosting the export(s) fails, the corresponding HAVIP and hence its corresponding NFS export(s) will automatically fail over to one of the surviving nodes so that the NFS client continues to receive uninterrupted service of NFS exported paths.

My session will be held on Sunday 1st May, 2016   from 3:00pm to 3:50pm in
Room 1, BirlaSoft, H–9, Sector 63, NOIDA – 201306, NCR Delhi
Hope to meet you there!!



Tags:  

Del.icio.us
Digg

Copyright © ORACLE IN ACTION [I Am Speaking at OTN Yathra 2016], All Right Reserved. 2016.

The post I Am Speaking at OTN Yathra 2016 appeared first on ORACLE IN ACTION.

Categories: DBA Blogs