Home » RDBMS Server » Server Administration » ORA-1031 while creating a new db manually
ORA-1031 while creating a new db manually [message #216354] Fri, 26 January 2007 15:03 Go to next message
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


Re: ORA-1031 while creating a new db manually [message #216357 is a reply to message #216354] Fri, 26 January 2007 15:12 Go to previous messageGo to next message
BlackSwan
Messages: 25037
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?
Re: ORA-1031 while creating a new db manually [message #216358 is a reply to message #216357] Fri, 26 January 2007 15:15 Go to previous messageGo to next message
Teresa
Messages: 36
Registered: May 2002
Member
Yes the oracle permissins and group its fine .. i really dont know what's causing this
Re: ORA-1031 while creating a new db manually [message #216361 is a reply to message #216354] Fri, 26 January 2007 15:21 Go to previous messageGo to next message
BlackSwan
Messages: 25037
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.
Re: ORA-1031 while creating a new db manually [message #216377 is a reply to message #216354] Fri, 26 January 2007 22:25 Go to previous messageGo to next message
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
Re: ORA-1031 while creating a new db manually [message #216416 is a reply to message #216354] Sat, 27 January 2007 07:25 Go to previous messageGo to next message
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 ...
Re: ORA-1031 while creating a new db manually [message #216420 is a reply to message #216354] Sat, 27 January 2007 09:07 Go to previous messageGo to next message
BlackSwan
Messages: 25037
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 Go to previous messageGo to next message
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
Re: ORA-1031 while creating a new db manually [message #217129 is a reply to message #216354] Wed, 31 January 2007 15:16 Go to previous messageGo to next message
BlackSwan
Messages: 25037
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 Go to previous messageGo to next message
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
Re: ORA-1031 while creating a new db manually [message #217347 is a reply to message #216354] Thu, 01 February 2007 15:05 Go to previous messageGo to next message
BlackSwan
Messages: 25037
Registered: January 2009
Location: SoCal
Senior Member
Please post the fix after you know what it is.
Re: ORA-1031 while creating a new db manually [message #217545 is a reply to message #217347] Fri, 02 February 2007 13:00 Go to previous message
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
Previous Topic: JREW.exe is not a valid Win32 Application
Next Topic: Problems with Archivelogmode
Goto Forum:
  


Current Time: Mon Dec 05 08:52:36 CST 2016

Total time taken to generate the page: 0.29789 seconds