Home » RDBMS Server » Server Administration » ORA-01031 insufficient privileges (Oracle 10G on windows server 2003)
icon1.gif  ORA-01031 insufficient privileges [message #343119] Tue, 26 August 2008 05:59 Go to next message
Messages: 1
Registered: August 2008
Junior Member

i m have instaled oracle 10g on windows 2003 server and i m able to logon as sysdba from the machine. but when i tried to connted to oracle from another win xp machine through network, it says insufficient privileges ora-01031 error.

i tried to solve the problem using SQLNET.ora enablng NTS. but its does't work

then i tried to set orapwd file=$oracle_home/dbs/orapwsid password=secure entries=5

but i was still unable to connect to Oracle db through win xp machine using SQL.

if somebody could help me on that
Re: ORA-01031 insufficient privileges [message #343157 is a reply to message #343119] Tue, 26 August 2008 08:38 Go to previous messageGo to next message
Messages: 25568
Registered: January 2009
Location: SoCal
Senior Member
Please read & FOLLOW the Posting Guidelines as stated in URL above
Re: ORA-01031 insufficient privileges [message #343194 is a reply to message #343119] Tue, 26 August 2008 10:28 Go to previous message
Michel Cadot
Messages: 65135
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
And don't rate your own question before there is any solution provided.

Previous Topic: Undo Tablespace
Next Topic: Problem: The install has detected that the primary IP address of the system is DHCP-assigned.
Goto Forum:

Current Time: Wed Aug 16 16:41:09 CDT 2017

Total time taken to generate the page: 0.09930 seconds