The Neglected Oracle user group

the neglected Oracle User-owned group

Chongqing days, Heat can't stand, still in the heat wave, a brother to call, tell a single instance database new Field operation, has been stuck there, do not go on. Because you are busy talking about things, simply give some advice, such as: Copy a table, and then try to do this in the newly copied tables. But still can not succeed, he is very anxious, constantly to call, make me upset. It is recommended that he check the alarm log, read the directory permissions, and so on. Behind, he has sent a number of alarm logs, I hold the mobile phone QQ, squinting at the sun under the shaking to see Ah, also did not see what Ming Tang, had to tell him, and so I finished, the Internet when, personally hands.

because Oracle Not I installed, the intuitive sense should be the issue of permissions. Remote QQ, log in to the system, first view The Oracle user group:

ID Oracle uid=501 (Oracle) gid=502 (DBA) groups=502 (DBA)

halo, why not belong to group Oinstall , and then view /etc/group files, Oinstall there is AH.

650) this.width=650; "title=" oracle01.jpg "alt=" wkiom1e8rflsoly7aabkupr9fto028.jpg-wh_50 "src=" http://s1.51cto.com /wyfs02/m02/86/57/wkiom1e8rflsoly7aabkupr9fto028.jpg-wh_500x0-wm_3-wmp_4-s_3374488199.jpg "/>

Then get it!

Usermod–g oinstall–g dba Oracle

Re-check Oracle Properties

650) this.width=650; "title=" oracle03.jpg "src=" http://s3.51cto.com/wyfs02/M01/86/56/ Wkiol1e8rbhjxxbmaaa8ogv7hsi612.jpg-wh_500x0-wm_3-wmp_4-s_2269583304.jpg "alt=" Wkiol1e8rbhjxxbmaaa8ogv7hsi612.jpg-wh_50 "/>

After the change, let him do the new fields again, or not. Had to ask the relevant personnel, suspend business, restart the instance. Sad things come, incredibly close the instance, error message as shown:

650) this.width=650; "title=" oracle02.jpg "alt=" wkiol1e8rgqx16jaaadtq3bfwjw522.jpg-wh_50 "src=" http://s4.51cto.com /wyfs02/m01/86/56/wkiol1e8rgqx16jaaadtq3bfwjw522.jpg-wh_500x0-wm_3-wmp_4-s_63756078.jpg "/>

had to Oracle The group is changed back, after closing the instance, then modifying and then launching the instance, everything is OK. In this process, the urgent, the order of the reverse, so that more time spent.

This article is from the "Sery" blog, make sure to keep this source http://sery.blog.51cto.com/10037/1841674

The Neglected Oracle user group