OraFAQ Forum: Server Administration » ORA-1031 while creating a new db manually

Home » RDBMS Server » Server Administration » ORA-1031 while creating a new db manually

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

ORA-1031 while creating a new db manually [message #216354]

Fri, 26 January 2007 15:03

Teresa
Messages: 36
Registered: May 2002

Member

Hello all

I have installed oracle and then while trying to create a database manualy i get

sqlplus '/as sysdba'

SQL*Plus: Release 10.2.0.2.0 - Production on Fri Jan 26 16:00:54 2007
Copyright (c) 1982, 2005, Oracle. All Rights Reserved.
ERROR:
ORA-01031: insufficient privileges

my envs are all fine, I dont have oracle running it should show
Connected to an idle instance.
this works in other servers but not here, all of the servers are O/S solaris 5.8

Thanks
Teresa

Report message to a moderator

Re: ORA-1031 while creating a new db manually [message #216357 is a reply to message #216354]

Fri, 26 January 2007 15:12

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>my envs are all fine,
The error message would indicate otherwise.
is the current OSUSER in the same group as the "oracle" user?

Report message to a moderator

Re: ORA-1031 while creating a new db manually [message #216358 is a reply to message #216357]

Fri, 26 January 2007 15:15

Teresa
Messages: 36
Registered: May 2002

Member

Yes the oracle permissins and group its fine .. i really dont know what's causing this

Report message to a moderator

Re: ORA-1031 while creating a new db manually [message #216361 is a reply to message #216354]

Fri, 26 January 2007 15:21

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

You contend everything is fine or as it should be but offer NO proof this is the case.
OBVIOUSLY something is NOT fine, you have not provided any evidence one way or the other.

You should be able to obtain a clue or two if you have root access by using truss.

Report message to a moderator

Re: ORA-1031 while creating a new db manually [message #216377 is a reply to message #216354]

Fri, 26 January 2007 22:25

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

Hi,
Check your sqlnet.ora file.
(sqlnet.authentication_services = ?)
above value should be NTS if NONE then change to NTS.

regards
Taj

Report message to a moderator

Re: ORA-1031 while creating a new db manually [message #216416 is a reply to message #216354]

Sat, 27 January 2007 07:25

Teresa
Messages: 36
Registered: May 2002

Member

Hi I did run a truss no issues there, i compared with other servers where I dont have the problem ... i had the unix admin also to takea look we cant find anything, we beleive that could be underneath for permissions at o/s level, we dont manage the o/s for the server and im trying to request an umount of the file system and see if all permissions are given to oracle ...

Report message to a moderator

Re: ORA-1031 while creating a new db manually [message #216420 is a reply to message #216354]

Sat, 27 January 2007 09:07

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>Hi I did run a truss no issues there
Exactly what "issues" were you looking for?
truss should have shown what was being or attempted being accessed just before the ORA-01031 occurs.
You could have an error of omission (some thing is not there) as opposed to error of commission ( doing something wrong).
Your problem might have something to with orapwSID & initSID.ora parameter.

[Updated on: Sat, 27 January 2007 09:07] by Moderator

Report message to a moderator

Re: ORA-1031 while creating a new db manually [message #217128 is a reply to message #216354]

Wed, 31 January 2007 15:09

Teresa
Messages: 36
Registered: May 2002

Member

Hi

I cant create the datbase, I get the ora-01031 as soon as the sqlplus '/as sysdba' is issued, i believe that could be permissions underneath, i have asked to the unix team to umount and check permissions and they were wrong, now they tell me that they are fine, i'm not able to check them, so i dont really know for sure

Report message to a moderator

Re: ORA-1031 while creating a new db manually [message #217129 is a reply to message #216354]

Wed, 31 January 2007 15:16

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

was root.sh by root at the end of the installtion process?
Note:233223.1
You're On Your Own (YOYO)
P.S.
Are you really, really sure that the output from truss did not contain any clues to the underlying source of your problem?

[Updated on: Wed, 31 January 2007 15:28] by Moderator

Report message to a moderator

Re: ORA-1031 while creating a new db manually [message #217338 is a reply to message #217129]

Thu, 01 February 2007 14:42

Teresa
Messages: 36
Registered: May 2002

Member

yes everything is in place, i have a call open with oracle and the issue seems like permissions at O/S level, i may reisntall the software again perhaps in a different location

Report message to a moderator

Re: ORA-1031 while creating a new db manually [message #217347 is a reply to message #216354]

Thu, 01 February 2007 15:05

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Please post the fix after you know what it is.

Report message to a moderator

Re: ORA-1031 while creating a new db manually [message #217545 is a reply to message #217347]

Fri, 02 February 2007 13:00

Teresa
Messages: 36
Registered: May 2002

Member

The issue was veritas volume manager preventing oracle to execute under /opt/product which was where oracle was installed, as soon as oracle was installed in a diferent mount point the issue was gone. although oracle had full permissions, but the interesting part is that I have oracle installed in the same directory path in other servers and no issues.
Thanks
Teresa

Report message to a moderator

Previous Topic:	JREW.exe is not a valid Win32 Application
Next Topic:	Problems with Archivelogmode

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Jan 11 06:03:07 CST 2025