In addition to Weibo, there is also WeChat
Please pay attention
WeChat public account
Shulou
2025-04-02 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >
Share
Shulou(Shulou.com)06/01 Report--
Neglected oracle user group
Chongqing day, unbearably hot, still running in the heat wave, a brother called to tell a single instance database to add field operation, has been stuck there, can not be carried out. Because I am busy talking about things, I simply give some advice, such as: copy a table, and then try to do this in the newly copied table. But still can not succeed, he is very anxious, keep calling, make me upset. He is once again advised to check the alarm log, look at the directory permissions, and so on. Later, he sent some warning logs one after another. I took Mobile QQ and squinted in the shining sun. I didn't see anything, so I had to tell him that when I was finished and surfing the Internet, I did it myself.
Because oracle is not installed by myself, the intuitive feeling should be a matter of permissions. Remote qq, log in to the system, and first check the group of the oracle user:
Id oracle
Uid=501 (oracle) gid=502 (dba) groups=502 (dba)
Dizzy, why not belong to the group oinstall, then check / etc/group file, oinstall exists ah.
Then get it!
Usermod-g oinstall-G dba oracle
Check the oracle property again
After the change, let him carry on the operation of the new field again, still can't. We have to ask the relevant personnel to suspend the business and restart the instance. When a sad thing comes, the instance cannot be closed. The error message is shown in the following figure:
You have to change the oracle group back, close the instance, modify it, and then start the instance, and everything is fine. In this process, I was in a hurry and reversed the order, so that it took a lot of time.
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.