OraFAQ Forum: Server Administration » Privileges issue while create database through oracle user

Home » RDBMS Server » Server Administration » Privileges issue while create database through oracle user (11g, 11.2.0.3, linux6)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Privileges issue while create database through oracle user [message #644298]

Mon, 02 November 2015 22:59

ashishkumarmahanta80
Messages: 231
Registered: October 2006
Location: kolkatta

Senior Member

Hi all,

While installing oracle (Grid infrastructure stand alone), getting below error-

cannot create directory
/u01/app/oracle/cfgtiillogs/dbca/pridb

Below are the privileges I had used to install and configure grid -

groupadd -g 1300 oinstall
groupadd -g 1301 dba
useradd -g oinstall -G dba oracle
groupadd -g 1200 asmadmin 
groupadd -g 1201 asmdba 
groupadd -g 1202 asmoper 
useradd -m -u 1100 -g oinstall -G asmadmin,asmdba,asmoper -d /home/grid -s /bin/bash grid

#Creating directories for grid home
[root@test-host ~]#
mkdir -p /u01/app/grid
mkdir -p /u01/app/11.2.0/grid
chown -R grid:oinstall /u01
mkdir -p /u01/app/oracle 
chown oracle:oinstall /u01/app/oracle 
chmod -R 775 /u01
groupadd -g 1401 oper  
usermod -g oinstall -G dba,oper,asmdba oracle

should I use
chmod -R 777 /u01 -- will this help??

please let me know, how can I proceed further?

Regards,
Ashish Kumar Mahanta

Report message to a moderator

Re: Privileges issue while create database through oracle user [message #644299 is a reply to message #644298]

Mon, 02 November 2015 23:17

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>should I use
>chmod -R 777 /u01 -- will this help??

Depends upon how you define "help".
Yes, above should eliminate "cannot create directory",
but allows any OS use to impact any file on /u01 directory tree; which could have adverse impact on the content & availability of the database.

Report message to a moderator

Re: Privileges issue while create database through oracle user [message #644305 is a reply to message #644298]

Tue, 03 November 2015 01:42

John Watson
Messages: 8964
Registered: January 2010
Location: Global Village

Senior Member

Please can you check the accuracy of your statements? For example, you have posted this, which looks like a copy/paste:

cannot create directory
/u01/app/oracle/cfgtiillogs/dbca/pridb

but it isn't a copy/paste, it is just something you typed. And you typed it inaccurately, because there is no directory named /u01/app/oracle/cfgtiillogs. Presumably you meant /u01/app/oracle/cfgtoollogs. When I see something like that, it destroys any belief I might have in everything else you describe. Better start again, and this time show what you actually did.

Report message to a moderator

Re: Privileges issue while create database through oracle user [message #644327 is a reply to message #644305]

Tue, 03 November 2015 06:00

ashishkumarmahanta80
Messages: 231
Registered: October 2006
Location: kolkatta

Senior Member

Dear John,

You are correct. That was typo error. I have started it again. Will mention you the steps performed from the start.

Regards,
Ashish

Report message to a moderator

Re: Privileges issue while create database through oracle user [message #644392 is a reply to message #644298]

Wed, 04 November 2015 05:12

gazzag
Messages: 1119
Registered: November 2010
Location: Bedwas, UK

Senior Member

Quote:

should I use
chmod -R 777 /u01 -- will this help??

Absolutely not. Ascertain the correct permissions and assign accordingly. Don't leave the door wide open!

Report message to a moderator

Re: Privileges issue while create database through oracle user [message #644593 is a reply to message #644392]

Tue, 10 November 2015 14:34

ashishkumarmahanta80
Messages: 231
Registered: October 2006
Location: kolkatta

Senior Member

Dear All,

I had used below script for the privileges -

groupadd -g 1000 oinstall
groupadd -g 1100 asmadmin
groupadd -g 1200 dba
groupadd -g 1201 oper
groupadd -g 1300 asmdba
groupadd -g 1301 asmoper
useradd -u 1100 -g oinstall -G asmadmin,asmdba,asmoper grid
useradd -u 1101 -g oinstall -G dba,asmdba,oper oracle
mkdir -p /u01/app/grid
mkdir -p /u01/app/11.2.0/grid
mkdir -p /u01/app/oracle
chown -R grid:oinstall /u01
chown oracle:oinstall /u01/app/oracle
chmod -R 775 /u01

after that I had configured the asm grid standalone.

while installing the database through ./runInstaller (create database option), getting below error-

PRCR-1079: Failed to start resource ora test.db
ORA-01031; Insufficient privileges
ORA-01031; Insufficient privileges
CRS- 2674 Start of 'ora.test.db' on node1' failed

node1 >> hostname

screen shot is attached for the reference.

Here, linux_database software is unzipped in windows and shared it to virtual box.

Please assist me what and where i missed the steps? How can made it rectified?

Regards,
Ashish Kumar Mahanta

Attachment: privileges.jpg
(Size: 129.35KB, Downloaded 1894 times)

[Updated on: Tue, 10 November 2015 15:00]

Report message to a moderator

Re: Privileges issue while create database through oracle user [message #644666 is a reply to message #644593]

Thu, 12 November 2015 04:15

ashishkumarmahanta80
Messages: 231
Registered: October 2006
Location: kolkatta

Senior Member

Dear All,

My problem is resolved.

grid user should have dba privilege. After adding it in grid user. Below mentioned error is resolved.

Regards,
Ashish Kumar MAhanta

Report message to a moderator

Previous Topic:	ORA-38802: edition does not exist
Next Topic:	TNS-03502: Message 3502 not found

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Feb 02 00:02:45 CST 2025