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: Procedure Execution time

2002-08-14 Thread ATIN KUMAR JAIN


Thanks Jack
But this is not my requirement,I want to know can I get the history of all
the procedure execution time..
regards,
---
Atin Kumar Jain
OCP 8i DBA
IBM Global Services
SO Jamshedpur
0657- 424478
[EMAIL PROTECTED]
[EMAIL PROTECTED]
---


   
 
  Jack van Zanen 
 
  [EMAIL PROTECTED] To:  Multiple recipients of list 
ORACLE-L
  Sent by: [EMAIL PROTECTED]  
 
  [EMAIL PROTECTED] cc: 
 
   Subject: Re: Procedure Execution time   
 
   
 
  08/13/02 07:23   
 
  PM   
 
  Please respond   
 
  to ORACLE-L  
 
   
 
   
 




Hi


Create a table and add a bit of code to the procedure to put an entry in
the table when executed. Can even trap the error code if you want


Jack



  ATIN KUMAR JAIN

  [EMAIL PROTECTED]To:   Multiple
recipients of list ORACLE-L [EMAIL PROTECTED]
  asteel.com  cc:   (bcc: Jack van
Zanen/nlzanen1/External/MEY/NL)
  Sent by: Subject:  Procedure
Execution time
  [EMAIL PROTECTED]



  13-08-2002 15:23

  Please respond to

  ORACLE-L







I want to know is there any way I can find out ,when particular procedure
is executed.??
Thanks  regards,
---
Atin Kumar Jain
OCP 8i DBA
IBM Global Services
SO Jamshedpur
0657- 424478
[EMAIL PROTECTED]
[EMAIL PROTECTED]
---


--
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).



===
De informatie verzonden in dit e-mailbericht is vertrouwelijk en is
uitsluitend bestemd voor de geadresseerde. Openbaarmaking,
vermenigvuldiging, verspreiding en/of verstrekking van deze informatie aan
derden is, behoudens voorafgaande schriftelijke toestemming van Ernst 
Young, niet toegestaan. Ernst  Young staat niet in voor de juiste en
volledige overbrenging van de inhoud van een verzonden e-mailbericht, noch
voor tijdige ontvangst daarvan. Ernst  Young kan niet garanderen dat een
verzonden e-mailbericht vrij is van virussen, noch dat e-mailberichten
worden overgebracht zonder inbreuk of tussenkomst van onbevoegde derden.

Indien bovenstaand e-mailbericht niet aan u is gericht, verzoeken wij u
vriendelijk doch dringend het e-mailbericht te retourneren aan de verzender
en het origineel en eventuele kopieën te verwijderen en te vernietigen.

Ernst  Young hanteert bij de uitoefening van haar werkzaamheden algemene
voorwaarden, waarin een beperking van aansprakelijkheid is opgenomen. De
algemene voorwaarden worden u op verzoek kosteloos toegezonden.
=
The information contained in this communication is confidential and is
intended solely for the use of the individual or entity to whom it is
addressed. You should not copy, disclose or distribute this communication
without the authority of Ernst  Young. Ernst  Young is neither liable for
the proper and complete transmission of the information contained

Procedure Execution time

2002-08-13 Thread ATIN KUMAR JAIN


I want to know is there any way I can find out ,when particular procedure
is executed.??
Thanks  regards,
---
Atin Kumar Jain
OCP 8i DBA
IBM Global Services
SO Jamshedpur
0657- 424478
[EMAIL PROTECTED]
[EMAIL PROTECTED]
---


-- 
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).