Re: Connect internal Problem, please help

From: Howard J. Rogers <dba_at_hjrdba.com>
Date: Wed, 5 Dec 2001 06:47:22 +1100
Message-ID: <3c0d2834$0$27196$afc38c87@news.optusnet.com.au>

Look in sqlnet.ora. SQLNET.AUTHENTICATION needs to be set to NONE, if memory serves, if you are attempting to use a password file. If it's set to NTS, it's attempting authorisation via the NT users and groups.

Don't connect INTERNAL. It's deprecated from 8.0 upwards, and disappears in 9i. Switch to the functionally equivalent 'connect sys/oracle AS SYSDBA'. At least that's supported and has a future.

For that same reason, to change the internal password, you simply change SYS's password. Alter user sys identified by blah; will do it.

Regards
HJR

--
Resources for Oracle: http://www.hjrdba.com
===============================


"SALL" <ssall_at_pamorimali.org> wrote in message
news:38186330.0112040509.7ea5dcff_at_posting.google.com...


> We are tring to connect under svrmgr with internal/oracle but

> we allways receive the following message: ORA-01031 Not enough

> privilege.

>

> So ze try to put the DBA_AUTORIZATION key in regedit but we still have

> the problem. Do you have an idea to solve that ?

>

> Thank You.

>

> Also, is it possible to change the password of the user internal ?

Received on Tue Dec 04 2001 - 13:47:22 CST