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 #259740]

Thu, 16 August 2007 06:48

Muhammad Ahmad
Messages: 30
Registered: November 2002

Member

Hi,

Please have a look at the following output :-

$ echo $ORACLE_SID
mydb2

$ sqlplus sys/oracle@mydb2 as sysdba

SQL*Plus: Release 10.2.0.3.0 - Production on Thu Aug 16 16:32:07 2007

Copyright (c) 1982, 2006, Oracle. All Rights Reserved.

ERROR:
ORA-01031: insufficient privileges

Enter user-name: / as sysdba

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options

SQL>

Why "ORA-01031: insufficient privileges" occur ?
What should i check?

Thanks for your kind concern

Regards,

Report message to a moderator

Re: ORA-01031: insufficient privileges [message #259751 is a reply to message #259740]

Thu, 16 August 2007 06:57

Michel Cadot
Messages: 68686
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

"/ as sysdba" local database.
"sys/oracle@mydb2" remote database can only be accessed if you have a password file.

Regards
Michel

Report message to a moderator

Re: ORA-01031: insufficient privileges [message #259777 is a reply to message #259751]

Thu, 16 August 2007 08:23

Muhammad Ahmad
Messages: 30
Registered: November 2002

Member

Thanks Michel for your reply,

In both the cases I connect Locally through OS Superuser , on the server.

$ id
uid=106(oracle) gid=104(dba)
$ sqlplus sys/oracle@mydb2 as sysdba

SQL*Plus: Release 10.2.0.3.0 - Production on Thu Aug 16 18:04:12 2007

Copyright (c) 1982, 2006, Oracle. All Rights Reserved.

ERROR:
ORA-01031: insufficient privileges

Enter user-name: / as sysdba

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options

SQL>

------------------------------
-------------

Regards,

Report message to a moderator

Re: ORA-01031: insufficient privileges [message #259786 is a reply to message #259777]

Thu, 16 August 2007 09:06

Michel Cadot
Messages: 68686
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Syntax "@..." is remote syntax; even if you are on the same server you use net services and must follow their rules.

Regards
Michel

Report message to a moderator

Re: ORA-01031: insufficient privileges [message #260350 is a reply to message #259740]

Sat, 18 August 2007 22:24

Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...

Senior Member

 you use net services and must follow their rules.

As Michel suggest follow it.

Hai Ahmed, what is

mydb2

. I think you used database name here. Use computer name instead of Database name and then use database service name.

Format is

sqlplus user_name/pass@computer_name/service_name

Before use this make sure listener service_name is running or not?

Report message to a moderator

Re: ORA-01031: insufficient privileges [message #260518 is a reply to message #259740]

Mon, 20 August 2007 03:55

Muhammad Ahmad
Messages: 30
Registered: November 2002

Member

Thanks Michel and other gurus,

Regards,

Report message to a moderator

Re: ORA-01031: insufficient privileges [message #260646 is a reply to message #260350]

Mon, 20 August 2007 10:17

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

Senior Member

computer name instead

if your using @TNS_ENTRY for connect to database
please check TNSNAMES.ORA file for correct value of TNS_ENTRY.

Eg:
My oracle database name is ORAMFE
My instance name is ORAMFE
My TNS_ENTRY name is HGC
My computer name is ALWARID-TAJ

My tnsnames.ora file contents is

HGC =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = xxx.xxx.xxx.x)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = oramfe)
)
)

C:\>hostname
alwarid-taj

C:\>sqlplus oem/oracle@oramfe

SQL*Plus: Release 10.1.0.5.0 - Production on Mon Aug 20 19:13:28 2007

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

ERROR:
ORA-12154: TNS:could not resolve the connect identifier specified


Enter user-name: oem/oracle@alwarid-taj
ERROR:
ORA-12514: TNS:listener does not currently know of service requested in connect
descriptor

C:\>sqlplus oem/oracle@hgc

SQL*Plus: Release 10.1.0.5.0 - Production on Mon Aug 20 19:14:21 2007

Copyright (c) 1982, 2005, Oracle.  All rights reserved.


Connected to:
Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options

SQL>

Report message to a moderator

Re: ORA-01031: insufficient privileges [message #260670 is a reply to message #259740]

Mon, 20 August 2007 11:46

vikramjogi
Messages: 71
Registered: June 2005
Location: Scranton

Member

Check if a service exists in your listener.ora file. Check if an entry appears in your listener.log file when you try to make a connection "sys@xxx as sysdba"

-Vikram

Report message to a moderator

Previous Topic:	Data accessed from Undo Segment OR Buffer Cache
Next Topic:	Manual Clone DB

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Sep 19 20:03:05 CDT 2024