Home » RDBMS Server » Server Administration » Privileges issue while create database through oracle user (11g, 11.2.0.3, linux6)
Privileges issue while create database through oracle user [message #644298] Mon, 02 November 2015 22:59 Go to next message
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
Re: Privileges issue while create database through oracle user [message #644299 is a reply to message #644298] Mon, 02 November 2015 23:17 Go to previous messageGo to next message
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.
Re: Privileges issue while create database through oracle user [message #644305 is a reply to message #644298] Tue, 03 November 2015 01:42 Go to previous messageGo to next message
John Watson
Messages: 8922
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.
Re: Privileges issue while create database through oracle user [message #644327 is a reply to message #644305] Tue, 03 November 2015 06:00 Go to previous messageGo to next message
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
Re: Privileges issue while create database through oracle user [message #644392 is a reply to message #644298] Wed, 04 November 2015 05:12 Go to previous messageGo to next message
gazzag
Messages: 1118
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!
Re: Privileges issue while create database through oracle user [message #644593 is a reply to message #644392] Tue, 10 November 2015 14:34 Go to previous messageGo to next message
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

[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 Go to previous message
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
Previous Topic: ORA-38802: edition does not exist
Next Topic: TNS-03502: Message 3502 not found
Goto Forum:
  


Current Time: Thu Mar 28 07:16:36 CDT 2024