Home » RDBMS Server » Server Administration » ORA-01031: insufficient privileges
ORA-01031: insufficient privileges [message #259740] Thu, 16 August 2007 06:48 Go to next message
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,



Re: ORA-01031: insufficient privileges [message #259751 is a reply to message #259740] Thu, 16 August 2007 06:57 Go to previous messageGo to next message
Michel Cadot
Messages: 64130
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

Re: ORA-01031: insufficient privileges [message #259777 is a reply to message #259751] Thu, 16 August 2007 08:23 Go to previous messageGo to next message
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,

Re: ORA-01031: insufficient privileges [message #259786 is a reply to message #259777] Thu, 16 August 2007 09:06 Go to previous messageGo to next message
Michel Cadot
Messages: 64130
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
Re: ORA-01031: insufficient privileges [message #260350 is a reply to message #259740] Sat, 18 August 2007 22:24 Go to previous messageGo to next message
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?
Re: ORA-01031: insufficient privileges [message #260518 is a reply to message #259740] Mon, 20 August 2007 03:55 Go to previous messageGo to next message
Muhammad Ahmad
Messages: 30
Registered: November 2002
Member
Thanks Michel and other gurus,

Regards,
Re: ORA-01031: insufficient privileges [message #260646 is a reply to message #260350] Mon, 20 August 2007 10:17 Go to previous messageGo to next message
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>
Re: ORA-01031: insufficient privileges [message #260670 is a reply to message #259740] Mon, 20 August 2007 11:46 Go to previous message
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
Previous Topic: Data accessed from Undo Segment OR Buffer Cache
Next Topic: Manual Clone DB
Goto Forum:
  


Current Time: Wed Dec 07 10:51:50 CST 2016

Total time taken to generate the page: 0.20637 seconds