Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: ora-01031 /01017 when connecting as internal

RE: ora-01031 /01017 when connecting as internal

From: Kuan, Amy M <kuanam_at_texaco.com>
Date: Tue, 26 Sep 2000 14:40:56 -0500
Message-Id: <10631.117906@fatcity.com>


I have received this error before on 8.1.6 when the sqlnet.authentication_services in sqlnet.ora was set to (BEQ,NONE). Once I commented this line out, I was able to connect internal with a password. The remote_login_passwordfile was set to exclusive in my case.

-----Original Message-----
From: Radu Caulea [mailto:radu.caulea_at_chello.fr] Sent: Tuesday, September 26, 2000 1:40 PM To: Multiple recipients of list ORACLE-L Subject: Re: ora-01031 /01017 when connecting as internal

Hi

Look at your password file. Does it reflect your last oradim launch date ? If not, delete it manually, delete the services with oradim -delete -sid, etc and then recreate them.

Regards, Radu

On Tue, 26 Sep 2000 08:45:27 -0800, you wrote:

>Hi folks,
>
>I exported the database which is on NT. After importing the database I am
>not able to connect as internal.
>
>I came a cross that there is bug which modify the password file on NT on
>import if parameter "remote_login_passwordfile=exclusive or share".
>
>After that I deleted the services for sid and deleted the passwdfile and
>recreated as:
>
>1. deleted the sid (discover) with command
> oradim -delete -sid discover.
>
>2. deleted the PWDdiscover.ora file from d:\oracle\ora81\database
>
>3. started the service with new password as
>
> oradim -new -sid discover -startmode auto -pfile
>d:\oracle\ora81\database\initdiscover.ora
>
>services are running but still I receive
>ORA-01017 invalid username/passwd ; logon denied.
>
>I also deleted the passwd file and created with ORAPWD utility as :
>
>orapwd file=d:\oracle\ora81\database\PWDdiscover.ora password=manager
>entries=2
>
>It also did't works.
>
>Can anyone help ?
>
>Thanks.
>Arjun
>
>
>_________________________________________________________________________
>Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
>
>Share information about yourself, create your own public profile at
>http://profiles.msn.com.
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com

-- 
Radu 'kernel' Caulea, http://perso.club-internet.fr/caulea/
alternate eMail: caulea_at_usa.net (will always forward)
ICQ: 49088510
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Radu Caulea
  INET: radu.caulea_at_chello.fr

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
Received on Tue Sep 26 2000 - 14:40:56 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US