In addition to Weibo, there is also WeChat
Please pay attention
WeChat public account
Shulou
2025-04-06 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >
Share
Shulou(Shulou.com)06/01 Report--
1. Background
I used to use oracle11g all the time, but I have no problem with creating users. Today, I reported an error when I created a user on oracle12c. As shown below:
I was so depressed that I opened the official oracle website and found that there was a limit to the creation of users.
two。 Solution
When you create a user, the user name starts with clocked # or Category #.
Misspelled: create user zhaojiedi identified by oracle
Correct way to write it: create user c##zhaojiedi identified by oracle
Note: if you don't worry about why, the above solution can meet your requirements, and you don't have to read the following.
=
=
3. Solution process
The following process is my process of solving this problem, which is also written and shared.
I have access to the oracle 12c official documentation
Go to the following pages in turn
Oracle12c home page
Administrator's Guide
Managing Users and Securing the Database
Oracle Database Security Guide
Creating User Accounts
After searching, the following figure is found on the Creating User Accounts page:
The above hint is very clear. To create a public user name, you must start with clocked # or clocked #. Our report above was wrong. It's because we create public users that don't start with clocked # or clocked #.
At this point, we know the specific cause of the error. Then there is a winning solution.
If you're still obsessed with what public and local users are, there's a profile on the Creating User Accounts page.
Summary
The above is introduced by the editor to solve the problem of oracle12c user prompt ORA-65096: invalid public user name or role. I hope it will be helpful to you. If you have any questions, please leave me a message and the editor will reply to you in time. Thank you very much for your support to the website!
If you think this article is helpful to you, you are welcome to reprint it, please indicate the source, thank you!
Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.
Views: 0
*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.
Continue with the installation of the previous hadoop.First, install zookooper1. Decompress zookoope
"Every 5-10 years, there's a rare product, a really special, very unusual product that's the most un
© 2024 shulou.com SLNews company. All rights reserved.