Home » RDBMS Server » Server Administration » ORA-01031: insufficient privileges (Oracle 10gR1 in HP_UX)
icon4.gif  ORA-01031: insufficient privileges [message #504011] Thu, 21 April 2011 01:07 Go to next message
shailjobgmailcom
Messages: 8
Registered: April 2011
Location: Bangalore, India
Junior Member
Hi can any one help me ,

I am getting this error , at the time of startup database

ORA-01031: insufficient privileges

ORA-12162: TNS:net service name is incorrectly specified

What may be the cause of this error,.


Please help me for the same , i got stuck in production database its urgent.

Report message to a moderator

Re: ORA-01031: insufficient privileges [message #504012 is a reply to message #504011] Thu, 21 April 2011 01:15 Go to previous messageGo to next message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Fix the errors and all will be fine.

Regards
Michel

Report message to a moderator

Re: ORA-01031: insufficient privileges [message #505973 is a reply to message #504012] Thu, 05 May 2011 15:57 Go to previous messageGo to next message
malalation
Messages: 12
Registered: April 2011
Junior Member
from which user are you trying to connect?
does the user have "create session" priv?
is your ORACLE_SID env var set correctly?

Report message to a moderator

Re: ORA-01031: insufficient privileges [message #505995 is a reply to message #504011] Fri, 06 May 2011 00:11 Go to previous message
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
shailjobgmailcom wrote on Thu, 21 April 2011 08:07
What may be the cause of this error


Oracle

ORA-12162: TNS:net service name is incorrectly specified

Cause: The connect descriptor corresponding to the net service name in TNSNAMES.ORA or in the directory server (Oracle Internet Directory) is incorrectly specified.

Action: If using local naming make sure there are no syntax errors in the corresponding connect descriptor in the TNSNAMES.ORA file. If using directory naming check the information provided through the administration used for directory naming.

Report message to a moderator

Previous Topic: OS authentication is not working in 11G
Next Topic: Use of Views in migration
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Dec 01 12:12:17 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.