Oracle Express Edition Error – ORA-65096: invalid common user or role name

While trying to create user in Oracle Database 18c Express Edition I kept getting an “ORA-65096: invalid common user or role name” error, which didn’t make sense to me so after validating my command, that I was signed in as an admin user, and determining that my “CREATE USER” was formatted correctly.  I did some additional research and determined that in the hidden parameter “_ORACLE_SCRIPT” needed to be set to “True” starting with the Oracle Version 12c and higher.

Setting the “_ORACLE_SCRIPT” values

To set the “_ORACLE_SCRIPT” hidden variable to “True” you need to run an “Alter” command. Then you will be able to create the desired user and run your grants commands as usual.

Alter SQL Command

alter session set “_oracle_script”=true;

How to Determine Your Oracle Database Name

Oracle provides a few ways to determine which database you are working in.  Admittedly, I usually know which database I’m working in, but recently I did an Oracle Database Express Edition (XE) install which did not goes has expected and I had reason to confirm which database I was actually in when the SQL*Plus session opened.  So, this lead me to consider how one would prove exactly which database they were connected to.  As it happens, Oracle has a few ways to quickly display which database you are connected to and here are two easy ways to find out your Oracle database name in SQL*Plus:

  • V$DATABASE
  • GLOBAL_NAME

Checking the GLOBAL_NAME table

The First method is to run a quick-select against the GLOBAL_NAME table, which. is publicly available to logged-in users of the database

Example GLOBAL_NAME Select Statement

select * from global_name;

Checking the V$DATABASE Variable

The second method is to run a quick-select a V$database. However, not everyone will have access to the V$database variable.

Example V$database Select Statement

select name from V$database;

How To write like it is your job

Writing and The Written Word

How to Write Like It Is Your Job

Many new writers come in the field with the mindset of “writing when inspiration strikes” or “writing what you understand.” Such myths deceive writers into thinking writing is not a job. Well, to build a career as a writer, you need to learn how to write like it is your job. A good starting point is doing away with away such myths.

On the other hand, what about others more experienced in writing? What fallacies and myths of the literary lifestyle can prevent you from writing like it is a job? Writing is not just a Job, it is also a business, and should such have a strategy and business plan to ensure career and personal success. It is vital for writing professionals to know the distinction of how essential a “job” is and…

View original post 1,681 more words

5 Basic Types of Blogs

Writing and The Written Word

If you’re new to blogging and are seeking to grow your audience, or have been doing it for a while now, then you understand the challenge of creating unique, compelling, and valuable content for your readers and potential leads. This is, perhaps, one of the main pain points of blogging. So, how can you ensure that you continually produce content that catches the reader’s attention, build their trust, and increase your conversions?

One way is to use different kinds of posts. By varying the format of your delivery, you can take charge of how well the content resonates with your readers/audience. This post will look at the different categories of blogs, their main characteristics and how you can use the various types of blog content to inspire variety on your website or blog.

Let’s dive in!

5 Different Types of Blog Content to Inspire Your…

View original post 709 more words

How You Can Leverage Pronouns To Improve Your Blog Article SEO

Writing and The Written Word

Search Engine Optimization (SEO) Search Engine Optimization (SEO)

Despite all the hype around search engine optimization (SEO), there are some very simple things that a writer can do while creating their blog posts which will improve their SEO and in some ways make the blog procedure read. Perhaps, the easiest way to do this is to replace pronouns with the actual name of the person object or subject being described or discussed. Instead of saying ‘it’, say car, barn, bus, or whatever ‘it’ refers to. With a little practice and some careful editing this is a simple approach which can add much SEO value to your writing.

Table of Pronouns

Here’s a quick list of pronouns to consider when writing and editing your blog post. This table of pronouns is by no means complete but it is an excellent starting point for some quick wins.

Subject
Pronoun

Object
Pronoun

Possessive
Adjective (Determiner)

Number

Gender

Person

I

me

my

singular

Neutral

first

View original post 216 more words

Why You Should Post Blogs Regularly

Writing and The Written Word

Just as we refuel our car engines every time they are almost empty, the blogs you post on your site perform the same function. It is the medium of attracting more traffic, sure way to get new visitors to your site, and a chance to create a strong social media presence. As a result, regular posting of blogs on your site is the backbone towards a successful blogging experience.

Unfortunately, many bloggers and website owners believe blogging works like billboard advertising. They only post few quality contents and then relax expecting magic to bring their website to the limelight. This concept doesn’t work anymore. Instead, you’d need to make regular editing, promote the contents, and most importantly, add more quality contents to your blog.

When you post content regularly, it strengthens your website by ranking higher in SEO. Based on the numerous factors search…

View original post 1,100 more words

Is a Multi-Cloud Strategy A Fit For your Enterprise?

Enterprises and cloud computing become more integrated and essential for gain or maintain a competitive advantage through big data and Analytics. Cloud is now essential in improving operations efficiency and synergy. To optimize the enterprise architecture with the cloud, there are a few strategic questions need to be considered;

  • First, how much cloud business does your enterprise need?
  • And, what cloud strategy best meets your enterprise operational and security needs?
  • Where do private, public clouds, or hybrid cloud fit in your enterprise’s information workload deployment strategy?
  • Does multi-cloud fit in the enterprise’s information workload deployment strategy?

What is A Multi-cloud Strategy?

This probably is the point where the narrative should introduce the principle of multi-cloud. A multi-cloud is an approach to cloud computing which seeks to optimize enterprise costs, Return-On-Investment (ROI), and enabling big data analytics, which is already evolving the information workload deployment strategy of many organizations. Multi-cloud has already affected the major software and Software-As-A-Service (SaaS) providers, which have been rapidly evolving their application suites to enable this new reality.  As recently as this week, IBM announced that they had moved its Cloud-native software architecture.

Is It Time To Consider A Multi-Cloud Strategy For Your Enterprise?

Multi-cloud is a cloud computing strategy seeks to align from different cloud providers capability to optimize different business operations and technical requirements. A multi-cloud strategy can be a way to reduce the dependence upon more traditional software vendors and or on a single cloud service provider.

Advantages Of A Multi-Cloud Strategy

The advantages of a multi-cloud enterprise information workload deployment strategy are:

  • the enterprise can still operate even if one or more of the clouds providers goes offline or encounter other difficulties.
  • enterprises can avoid vendor lock-in since the enterprise’s data is stored on different clouds service providers and could be migrated if need be.
  • Multi-cloud can provide a reduction in the scales of data breach vulnerability since breaching one cloud does not provide access to the entire data of your enterprise, even if your organization has not implemented hybrid-cloud (private/public) strategy because all the data simply isn’t all housed one cloud.
  • Importantly, multi-cloud solutions are customizable. Every enterprise can select what works best in order to achieve optimal efficiency.

Disadvantages Of The Multi-Cloud

The multi-cloud enterprise information workload deployment strategy has downsides as well. For instance:

  • integration across the multi-cloud providers may require more planning, relationship management, and strategic oversight.
  • Multi-cloud implementations, while reducing the potential scale of any one security breach, it does provide more than one potential breach point to be monitored, managed, and mitigated.

Conclusion

Based on your enterprise’s industry, use of big data technologies, information security needs and the use information analytics to gain or maintain a competitive advantage and or comparative advantage, a multi-cloud enterprise information workload deployment strategy has a place in optimizing your enterprises technical and information strategy.  Especially when your multi-cloud strategy includes a hybrid-cloud (public/private) as a major pillar in your cloud strategy. 

Related References