OraFAQ Forum: Server Administration » ORA-01031: insufficient privileges

Home » RDBMS Server » Server Administration » ORA-01031: insufficient privileges

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

ORA-01031: insufficient privileges [message #176970]

Mon, 12 June 2006 04:45

mademba
Messages: 23
Registered: July 2005

Junior Member

hi every body,
I'd cloned oracle applications 11.5.10 CU2 with rapid clone.
When i perform post cloning steps (configuring traget system database servr),
i 've the following error
$ sqlplus /nolog

SQL*Plus: Release 9.2.0.6.0 - Production on Mon Jun 12 09:33:45 2006

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

SQL> conn /as sysdba
ERROR:
ORA-01031: insufficient privileges

i'd set ORACLE_HOME and ORACLE_SID variable, unset TWO_TASK

what's going on?
Plz help fixe that

Report message to a moderator

Re: ORA-01031: insufficient privileges [message #176984 is a reply to message #176970]

Mon, 12 June 2006 05:23

ebrian
Messages: 2794
Registered: April 2006

Senior Member

Is the operating system user that is trying to connect thru SQL*Plus part of the DBA group?

[Updated on: Mon, 12 June 2006 05:24]

Report message to a moderator

Re: ORA-01031: insufficient privileges [message #176992 is a reply to message #176984]

Mon, 12 June 2006 06:01

mademba
Messages: 23
Registered: July 2005

Junior Member

Yes
The OS user who tries to connect tru sql*plus is a member of the dba group.

Report message to a moderator

Re: ORA-01031: insufficient privileges [message #176996 is a reply to message #176970]

Mon, 12 June 2006 06:11

mademba
Messages: 23
Registered: July 2005

Junior Member

Yes the OS user who tries to connect is member of dba group

Report message to a moderator

Re: ORA-01031: insufficient privileges [message #176999 is a reply to message #176996]

Mon, 12 June 2006 06:57

ebrian
Messages: 2794
Registered: April 2006

Senior Member

I'm not familiar with the rapid clone, so I don't know what all is involved with that process.

Have you tried connecting without a sqlnet.ora file?

Report message to a moderator

Previous Topic:	Upgrade from Oracle 9i R2 to Oracle 10g R2
Next Topic:	Mion script

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 12:32:09 CDT 2024