Home » RDBMS Server » Server Administration » ORA-01031: insufficient privileges
ORA-01031: insufficient privileges [message #51097] Thu, 25 April 2002 05:46 Go to next message
ki
Messages: 8
Registered: February 2002
Junior Member
Hi,
I have the following problem.
I just install new Oracle 8.1.7 database server and
I am getting "ORA-01031: insufficient privileges " when I am using the following command:
sqlplus internal@prod
SQL*Plus: Release 8.1.7.0.0 - Production on Wed Apr 24 16:07:49 2002

(c) Copyright 2000 Oracle Corporation. All rights reserved.

ERROR:
ORA-01031: insufficient privileges

However I can perform "sqlplus internal" works fine.
There are just one instace "prod" on the server.
I can tnsping prod.
Please help.
Thank you,
Inessa.

Report message to a moderator

Re: ORA-01031: insufficient privileges [message #51098 is a reply to message #51097] Thu, 25 April 2002 06:23 Go to previous messageGo to next message
Amit Patel
Messages: 3
Registered: April 2002
Junior Member
Hi Inessa
Its same happening with me.
Try this way
sql>connect sys@prod as sysdba
password :
This way its getting connected.
(connecting internal is as good as connecting as sys)

Anybody has other inputs?

Report message to a moderator

Re: ORA-01031: insufficient privileges [message #51102 is a reply to message #51097] Thu, 25 April 2002 08:36 Go to previous message
Radek
Messages: 33
Registered: April 2002
Member
hi,
check if oracle operating user user is in group dba. also check for orapassword file in $ORACLE_HOME/dbs. file should be name orapw$ORACLE_SID. you can create by "orapwd file=$ORACLE_HOME/dbs/orapw$ORACLE_SID password=kernel".
Radek
P.S. please specify platform next time

Report message to a moderator

Previous Topic: Re: ocp *.* - dumps,braindumps,kits,cbt,tbt,sts......
Next Topic: Re: ORA-27101: Shared Memory realm does not exist
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Dec 25 09:19:21 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.