North India Chapter Of AIOUG-A Beginning….

I come from North India region of India. Though this part of India is considered to the richest, both in terms of wealth and culture, one thing that it lacks really badly is the awareness about what’s going in the IT world currently! There are just so many colleges and universities but the number of IT companies, doing serious IT work can be counted on fingers of one hand itself. In such situation, awareness about what’s going on the world of Oracle technologies is just so little. And that did bother me for a very long time. I always wanted to start something at that place where I was born and brought up. I had this discussion several times with my friend Navneet Upneja and we did think about couple of initiatives as well. But finally, when I shared the same with Murali Vallath, he suggested something which he himself did for a long time i.e. arranging a tech-meet with few topics presented on monthly basis. And very kindly, he also mentioned that AIOUG would be completely supportive in this initiative. Well, that was it and immediately, I talked to Navneet who brought with him two more friend(who are now the part of  “A-team” of AIOUG-North India Chapter)-Deepak Sharma & Nikhil Kumar. Along came Rohan Walia to support the initiative. So on March 29th,2014, we organized the 1st ever tech-meet up under the banner of AIOUG’s North India Chapter. To be honest, we didn’t expect but we got a really really good response. We did two talks with me presenting the latest feature of database version 12c, Multitenancy and Navneet spoke about the new features for Developers in database 12c. And since that time onwards, we have been conducting our monthly tech-meet on the last Saturday of every month and trying to cover as much as possible part of North India. Did I mention that the response has been just superb all the time?

This month, we marked the 8th tech-meet and also, we did for the 1st time, a webinar using G+ Hangout starting with the inaugural note by PS Janakiram from AIOUG board, followed by session of Rohan on ADF and in the last, session from me giving introduction of Exadata and Smart Scan. We decided to go for the webinar as it was a festival season and we believed, almost all the places, professionals would be enjoying a time-off with their family. So instead of asking them to come out and attend a tech-event, we decided to bring the event to them. And for those, who wouldn’t be able to join us, the recording would be there on our AIOUG-NIC(YouTube) channel. Though it was our very first attempt to conduct such kind of event but it turned out to be great. There were some small technical hiccups as we were using this hangout thing for the first time for such kind of technical session but that was kind of expected and we did overcome the issues eventually. It turned out to be a great session and we have decided now to incorporate this webinar along with our in-person monthly tech-meetup. After every 6 weeks, we shall be conducting one such webinar with one expert. In our opinion, it would be bringing such technical sessions to a wider audience, especially for those who can’t come and attend such events in person. Also, it would give opportunity for speakers to present their sessions with much ease. Hopefully, we shall be able to bring great experts on-board. The recorded webinar session is available at the following link,

https://www.youtube.com/watch?v=q0MpT6qOoB0

It wouldn’t had been possible to start this journey without the continuous support of the All India Oracle Users Group(AIOUG) and without the awesome team of North India Chapter. A big thanks to all and also to all the attendees who have attended the past tech-meets ups. Without their encouragement and kind words, it would had been lot tougher to keep the ball rolling.

I am sharing the web-page of the group along with the social media links. If you are also willing to present, in either the in-person monthly event or in the webinar, feel free to ping us!

AIOUG-North India Chapter

AIOUG-North India Chapter(Facebook)

AIOUG-North India Chapter(Twitter)

AIOUG-North India Chapter(G+)

AIOUG-North India Chapter(YouTube)

Making the CDB Common User Without Using C## Prefix….

If you have done any play with the latest release of Oracle database 12c, you must have come across the concept of Common and Local users. I won’t rewrite what’s already there in the docs but for setting the context of the post, a Common user must be created with a prefix added to the username-C##. Miss that and you won’t be able to create one while being connected to the Container database. On the other hand, if you are working in a Pluggable database, this restriction is not there and you would be allowed to create the user just like we have been creating since we have started working with Oracle database. Like a picture is worth more than 10000 words, a demo is better than many definitions so have a look.

SQL> select * from V$version;

BANNER
——————————————————————————–
    CON_ID
———-
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 – 64bit Production
     0

PL/SQL Release 12.1.0.2.0 – Production
     0

CORE    12.1.0.2.0    Production
     0

TNS for Linux: Version 12.1.0.2.0 – Production
     0

NLSRTL Version 12.1.0.2.0 – Production
     0

Now, let’s confirm where we are right now!

SQL> show con_name

CON_NAME
——————————
CDB$ROOT
SQL> show con_id

CON_ID
——————————
1

Since it’s confirmed that we are in the Container database Root, let’s try to create a user without using the prefix C##.

SQL> create user aman identified by aman;
create user aman identified by aman
            *
ERROR at line 1:
ORA-65096: invalid common user or role name

As expected, it didn’t work. So let’s see the explanation that we have for the given error code.

SQL> !oerr ora 65096
65096, 00000, "invalid common user or role name"
// *Cause:  An attempt was made to create a common user or role with a name
//          that was not valid for common users or roles.  In addition to
//          the usual rules for user and role names, common user and role
//          names must start with C## or c## and consist only of ASCII
//          characters.
// *Action: Specify a valid common user or role name.
//

If you would read the doc link mentioned somewhere above, you would get the confirmation that to make a common user, prefixing the name with C## is a must. So let’s make a second attempt and this time, use the prefix along with the username.

SQL> create user c##aman identified by aman;

User created.

Now, I wasn’t really happy doing this and was wanted to change this behaviour. So the obvious place to look was at some internal parameter that was behind it. Say hello to _common_user_prefix-an internal parameter that is behind this prefix C##.

SQL> select a.ksppinm "Parameter",
b.ksppstvl "Session Value",
c.ksppstvl "Instance Value"
from x$ksppi a,
x$ksppcv b,
x$ksppsv c
where a.indx = b.indx and a.indx = c.indx
and substr(ksppinm,1,1)=’_’ and lower(c.ksppstvl) like ‘%c##%’
order by a.ksppinm;  2    3    4    5    6    7    8    9 

Parameter               Session Value              Instance Value
—————————— —————————— ——————————
_common_user_prefix           C##                  C##

Well, now it’s just about modifying this parameter to whatever value you want! I just wanted to make the Common user creation the way I have been creating users all the time so I decided to make it simply null as shown below.

SQL> select a.ksppinm "Parameter",
b.ksppstvl "Session Value",
c.ksppstvl "Instance Value"
from x$ksppi a,
x$ksppcv b,
x$ksppsv c
where a.indx = b.indx and a.indx = c.indx
and substr(ksppinm,1,1)=’_’ and lower(c.ksppstvl) like ‘%c##%’
order by a.ksppinm;  2    3    4    5    6    7    8    9 

Parameter               Session Value              Instance Value
—————————— —————————— ——————————
_common_user_prefix           C##                  C##

A database bounce is required to make the change come in effect. and this is what I got after the database was restarted.

SQL> select a.ksppinm "Parameter",
b.ksppstvl "Session Value",
c.ksppstvl "Instance Value"
from x$ksppi a,
x$ksppcv b,
x$ksppsv c
where a.indx = b.indx and a.indx = c.indx
and substr(ksppinm,1,1)=’_’ and lower(a.ksppinm) like ‘%common_user_prefix%’
order by a.ksppinm;  2    3    4    5    6    7    8    9 

Parameter               Session Value              Instance Value
—————————— —————————— ——————————
_common_user_prefix

Great! So let’s create a Common user once again but this time, we won’t need the prefix C## to be added with it.

SQL> show con_id

CON_ID
——————————
1
SQL> show con_name

CON_NAME
——————————
CDB$ROOT
SQL> drop user c##aman cascade;

User dropped.

SQL> create user aman identified by aman;

User created.

SQL> grant dba to aman;

Grant succeeded.

SQL> column username format a40
SQL> select username, common from dba_users where username=’AMAN’;

USERNAME                 COM
—————————————- —
AMAN                     YES

I haven’t got any ora-600 or anything else that has broken down my database but let’s see if something shows up. Also, it goes without saying that using any underscore/internal parameters like the one shown, without the consent of Oracle Support Services must be only done in a test database which is used for nothing but learning/testing. So if you are going to modify this parameter and will witness database being crashed or any other functionality being broken, don’t say that you haven’t been warned!

Say Hello To Oracle Linux 7.0….

Seems like it’s going to be a week of new releases only. Last night only, I downloaded and installed Oracle database 12c patchset(12102) and today, Oracle Linux’s latest release OL7 is released. The download is available from E-Delivery portal and mine is going on. I don’t think it would take long before 12c would be certified for Oracle Linux 7 but I would do the installation of both, database and Linux, as soon as my download is going to finish. Fun times :=) .

Oracle 12c(12.1.0.2) Has Arrived….

Just checked Tim’s latest post and guess what, Oracle database 12c’s latest release, 12.1.0.2 is available now for download. It is available as an OTN download as well as from E-Delivery. Seems like that there is no documentation update available yet as the New Features guide still doesn’t have 12.1.0.2 included in it. But I am sure that it’s coming soon!

So grab your copy now and happy downloads :=).

Update: The documentation is updated and if you are looking for the new features introduced in 12102, check the following link.

http://docs.oracle.com/database/121/NEWFT/chapter12102.htm#NEWFT003

Packt Shares Its Full Range of eBook/Video For Just $10….

Yes, that’s correct! Packt Publications is celebrating 10 years of effective learning and information services to IT professionals. To make us part of this celebration, the good guys  are offering all eBooks and Videos at just $10 each until July 5th. So this would be a really good chance to get any e-book or Video of your choice in such a good price. Sounds good? Well follow this link then,http://goo.gl/Dnn5RP.

And since every book is just for 10$, why not use this opportunity to purchase my book as well :=)? If you need the link , here it is, http://www.packtpub.com/oracle-database-12c-backup-recovery-survival-guide/book.

Happy shopping and best wishes to Packt Publications!

Oracle University Learning Streams, Learning Would Never Stop….

Oracle technologies is like an ocean and with the introduction to more and more features, it’s becoming hard for almost all to match the pace. Surely one can attend a course (or several courses) to learn about a new technology or to furnish his skills on an existing one but at times, even that is not enough. For example, it’s tough to keep a control on the quality of the training as one would only come to know about the instructor i.e. how good(or not-so-good) he/she is, how well suited is a particular course for someone’s requirements etc. etc. Also it happens that at times, a course that one wants to attend, it may not be happening at his location or at a nearby location. Oracle University has taken several initiatives to solve these issues. Besides the standard ILT(Instructor Lead Training), now there is also an LVC(Live Virtual Class) that one can attend or can purchase Self-Study CD-Roms. But even that is not some times appreciated much depending on person’s liking. Some people prefer to see someone actually talking, delivering the session , making diagrams on the whiteboard and showing them how to perform the lab sessions along with the assurance that he/she is a really very knowledgeable instructor. Also, at times, doing a course for just N days is not enough and one wants to keep on listening the instructor sessions again and again, at one’s own pace to understand things. Fortunately, this is also now possible with the introduction of TOD(Training On Demand) learning mode where one can subscribe to a course’s pre-recorded sessions and keep on watching them without limits till 3 months. What’s more that you also get a 6 day’s lab time, e-kits of the course and a course attendance certificate which is also valid for the certification. Cool isn’t it! But hang on, this is something that I have already blogged about here. So what’s new?

Well, the newest thing is Oracle University | Oracle Learning Streams.

Think about it, you do know what is Exadata, how to manage it, administer it and you have also attended the course which teaches you all the aspects about Exadata Administration as well. But what you are interested to know more about the best practices in performing the Backup and Recovery over Exadata or how the Parallelism in Oracle database works or the best practices in upgrading and patching of database etc.-topics which are more specific and are targeted towards many many different areas for a particular technology and  you want to learn them at your own pace! That’s what the newest edition in learning from Oracle University is-Oracle Learning Streams. For an annual subscription for your desired technology(currently available for Database and Middleware) , you would get access to hundreds of pre-recorded videos covering a huge list of topics. If you ask me, I am really excited and I shall be definitely subscribing to my area of interest-Database. What about you?

Oracle Enterprise Manager(12c Cloud Control) Release 4 Is Available Now….

Just a quick shout-out , in case you haven’t heard about the news before, Enterprise Manager is now available with its 4th release now. You can download it from OTN along with the documentation. Additionally, you can watch and learn about the latest features from the EM’s YouTube Channel and also from OLL’s YouTube Channel. Tim Hall’s installation articles for the same are just too good to be missed. Last but certainly not the least, you can read these following books about the same,

Expert Oracle Enterprise Manager 12c

http://www.amazon.in/Expert-Oracle-Enterprise-Manager-Apress/dp/1430249382

Oracle Enterprise Manager Cloud Control 12c Deep Dive

http://www.amazon.in/Oracle-Enterprise-Manager-Cloud-Control/dp/9339203984/

Oracle Enterprise Manager Cloud Control 12c: Managing Data Center Chaos

http://www.amazon.in/Oracle-Enterprise-Manager-Cloud-Control/dp/1849684782/

 

Have fun!