RE: ora-1017 invalid username/password when trying to login as internal

2002-08-30 Thread Bob Metelsky

 Oracle 8.1.6/WinNT
 
 I get ora-1017 invalid username/password when trying to 
 connect as internal.  I have recreated password file many 
 times to no avail. Usually this all I have had to do in the 
 past for this error. I have tried all combinations of 
 remote_login_passwordfile.  I was getting connected earlier. 
 I had to a shutdown but cannot get server up. Luckily it is a 
 relatively used development server.  Any ideas on how to correct?
 
After you create a new password file, stop and restart the  sid service
via oradim or through nt services

This happens here from time to time, not sure why, but the above works

bob
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Bob Metelsky
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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
also send the HELP command for other information (like subscribing).



RE: ora-1017 invalid username/password when trying to login as internal

2002-08-30 Thread ATIN KUMAR JAIN


Check init.ora parameter,remote_login_passwordfile should be exclusive.
regards,
---
Atin Kumar Jain
OCP 8i DBA
IBM Global Services
SO Jamshedpur
0657- 424478,147074
[EMAIL PROTECTED]
[EMAIL PROTECTED]
---



  Bob Metelsky
  bmetelsky@cps92 To:  Multiple recipients
of
list ORACLE-L
  .com[EMAIL PROTECTED]
  Sent by: cc:
  [EMAIL PROTECTED] Subject: RE: ora-1017
invalid
username/password when trying
   to login as internal

  08/30/02 07:38
  PM
  Please respond
  to ORACLE-L






 Oracle 8.1.6/WinNT

 I get ora-1017 invalid username/password when trying to
 connect as internal.  I have recreated password file many
 times to no avail. Usually this all I have had to do in the
 past for this error. I have tried all combinations of
 remote_login_passwordfile.  I was getting connected earlier.
 I had to a shutdown but cannot get server up. Luckily it is a
 relatively used development server.  Any ideas on how to correct?

After you create a new password file, stop and restart the  sid service
via oradim or through nt services

This happens here from time to time, not sure why, but the above works

bob
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Bob Metelsky
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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
also send the HELP command for other information (like subscribing).






DISCLAIMER
Information contained and transmitted by this e-mail is confidential and
proprietary to Tata Steel Ltd. and is intended for use only by the
addressee. If you are not the intended recipient , you are notified that
any dissemination or copying of this e-mail is strictly prohibited and you
are requested to delete this e-mail immediately and notify the originator.
Tata Steel does not enter into any binding agreement with any party by
e-mail. Any views expressed by an individual do not necessarily reflect the
view of Tata Steel. Tata Steel is not responsible for the consequences of
any actions taken on the basis of information provided.
While this e-mail has been checked for all known viruses the addressee
should also scan for viruses.
To know more about Tata Steel please visit www.tatasteel.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: ATIN KUMAR JAIN
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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
also send the HELP command for other information (like subscribing).



RE: ora-1017 invalid username/password when trying to login as internal

2002-08-30 Thread Naveen Nahata

Just my guess, look at the registry parameter ORA_SID_PWFILE(Sorry my
knowledge is limited to NT only) and see if it is pointing to the right file.
Try restarting the service.

Are you running more than one DB on the same server?

by the way, if you find out the exact reason why this is happening do put it
in the List. It bugged me too once, not sure exactly how i got rid of it.

naveen

-Original Message-
Sent: Friday, August 30, 2002 11:44 PM
To: Multiple recipients of list ORACLE-L
internal



Check init.ora parameter,remote_login_passwordfile should be exclusive.
regards,
---
Atin Kumar Jain
OCP 8i DBA
IBM Global Services
SO Jamshedpur
0657- 424478,147074
[EMAIL PROTECTED]
[EMAIL PROTECTED]
---



  Bob Metelsky
  bmetelsky@cps92 To:  Multiple recipients
of
list ORACLE-L
  .com[EMAIL PROTECTED]
  Sent by: cc:
  [EMAIL PROTECTED] Subject: RE: ora-1017
invalid
username/password when trying
   to login as internal

  08/30/02 07:38
  PM
  Please respond
  to ORACLE-L






 Oracle 8.1.6/WinNT

 I get ora-1017 invalid username/password when trying to
 connect as internal.  I have recreated password file many
 times to no avail. Usually this all I have had to do in the
 past for this error. I have tried all combinations of
 remote_login_passwordfile.  I was getting connected earlier.
 I had to a shutdown but cannot get server up. Luckily it is a
 relatively used development server.  Any ideas on how to correct?

After you create a new password file, stop and restart the  sid service
via oradim or through nt services

This happens here from time to time, not sure why, but the above works

bob
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Bob Metelsky
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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
also send the HELP command for other information (like subscribing).






DISCLAIMER
Information contained and transmitted by this e-mail is confidential and
proprietary to Tata Steel Ltd. and is intended for use only by the
addressee. If you are not the intended recipient , you are notified that
any dissemination or copying of this e-mail is strictly prohibited and you
are requested to delete this e-mail immediately and notify the originator.
Tata Steel does not enter into any binding agreement with any party by
e-mail. Any views expressed by an individual do not necessarily reflect the
view of Tata Steel. Tata Steel is not responsible for the consequences of
any actions taken on the basis of information provided.
While this e-mail has been checked for all known viruses the addressee
should also scan for viruses.
To know more about Tata Steel please visit www.tatasteel.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: ATIN KUMAR JAIN
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Naveen Nahata
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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
also send the HELP command for other information (like subscribing).



Re: ora-1017 invalid username/password when trying to login as internal

2002-08-29 Thread dmeng


I had this problem before and the cause was traced to sqlnet.ora. After
commenting out a line ( sorry don't remember which line ) in that file the
issue went away.
Dennis Meng
Database Administrator
Focal Communications Corp.


   

  Rick_Cale@teamhe 

  alth.com To:  Multiple recipients of list 
ORACLE-L [EMAIL PROTECTED]
  Sent by: cc: 

  [EMAIL PROTECTED] Subject: ora-1017 invalid 
username/password when trying to login as internal
   

   

  08/29/02 03:38   

  PM   

  Please respond   

  to ORACLE-L  

   

   





Hi All,

Oracle 8.1.6/WinNT

I get ora-1017 invalid username/password when trying to connect as
internal.  I have recreated password file many times to no avail.
Usually this all I have had to do in the past for this error.
I have tried all combinations of remote_login_passwordfile.  I was getting
connected earlier. I had to a shutdown but cannot get server up.
Luckily it is a relatively used development server.  Any ideas on how to
correct?

Thanks
Rick


--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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
also send the HELP command for other information (like subscribing).




-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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
also send the HELP command for other information (like subscribing).