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: 25352
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: 64729
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: Fri Apr 28 09:30:22 CDT 2017

Total time taken to generate the page: 0.12673 seconds