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;

Linux Move (mv) Command

The Linux move command (mv) is one of the essential commands, which can be very useful in Linux, Unix, and AIX.  The primary purpose of the move command is obviously to move files, and of course, directories.   The move command may also be used to rename files and to make backups.

Move Command Syntax

$ mv [options] source (file or directory)  destination

Move Command options

option description
mv -f force move by overwriting destination file without prompt
mv -i interactive prompt before overwriting
mv -u update – move when the source is newer than the destination
mv -v verbose – print source and destination files
MV – t explicitly saying to move the file or directory here, rather trying to fit everything into the last argument.
mv * Move all (Multiple) files to a specific director without listing by name

For More move command details see the Linux documentation manuals using the man command

$ man mv

mv command examples

Here are some quick and very simple move command (MV) examples for reference.

Move Move to files  to the /Archive/ directory:

$ mv happy.txt garden.txt /Archive/

Move all “.txt” files in the current directory to subdirectory backup:

$ mv *.txt backup

Move all files in subdirectory ‘backup’ to current directory:

$ mv backup/*

Rename file happy.txt to happy.bak filename:

$ mv happy.txt happy.bak

Rename directory backup to backup2:

$ mv backup backup2

Update – move when happy.txt is newer or missing in target directory:

$ mv -u happy.txt backup

Move happy.txt and prompt before overwrite backup / happy.txt:

$ mv -v happy.txt backup

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