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
contect2ss
Messages: 1
Registered: August 2008
Junior Member
hi

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
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
http://www.orafaq.com/forum/t/88153/0/
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: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
And don't rate your own question before there is any solution provided.

Regards
Michel
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: Sun Dec 01 22:34:19 CST 2024