Home » RDBMS Server » Server Administration » Error login to the Oracle 11g (2 merged by MC)
Error login to the Oracle 11g (2 merged by MC) [message #617760] Thu, 03 July 2014 07:25 Go to next message
tedinho123
Messages: 26
Registered: June 2014
Junior Member
Hi guys,

I'm trying to login to the database so that i can reset the sys password and create a user, however it gives me an error...Can PLEASE HELP?????
  • Attachment: SnapShot.jpg
    (Size: 109.16KB, Downloaded 32 times)
Re: Error login to the Oracle 11g [message #617762 is a reply to message #617760] Thu, 03 July 2014 07:31 Go to previous messageGo to next message
John Watson
Messages: 4577
Registered: January 2010
Location: Global Village
Senior Member
The password file you have created has the wrong name. Read the section "Creating and Maintaining a Password File" in the Administrator's Guide. It will tell you how to create the password, and how to connect as SYS when you have created it.
Re: Error login to the Oracle 11g [message #617763 is a reply to message #617760] Thu, 03 July 2014 07:34 Go to previous messageGo to next message
EdStevens
Messages: 286
Registered: September 2013
Senior Member
What did you discover when you googled "ora-12638"?

BTW, the syntax is 'sqlplus / as sysdba'. Note the space between "/" and "as".
Re: Error login to the Oracle 11g (2 merged by MC) [message #617767 is a reply to message #617760] Thu, 03 July 2014 07:56 Go to previous messageGo to next message
Michel Cadot
Messages: 59166
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

ORA-12638: Credential retrieval failed
 *Cause:  The authentication service failed to retrieve the credentials of a
          user.
 *Action: Enable tracing to determine the exact error.

You don't need to post an image to post a text, just post the text, inline and formatted.

Re: Error login to the Oracle 11g (2 merged by MC) [message #617809 is a reply to message #617767] Thu, 03 July 2014 14:10 Go to previous messageGo to next message
tedinho123
Messages: 26
Registered: June 2014
Junior Member
When i googled "ora-12638" it tells me to put the # before the SQLNET.AUTHENTICATION_SERVICES= (NTS)
but i still can't connect
Re: Error login to the Oracle 11g (2 merged by MC) [message #617811 is a reply to message #617809] Thu, 03 July 2014 14:13 Go to previous messageGo to next message
tedinho123
Messages: 26
Registered: June 2014
Junior Member
What do you mlean by the password file has the wrong name?? I did check the creating and maintaining a password file oracle and i don't see where i got wrong in the syntax
Re: Error login to the Oracle 11g (2 merged by MC) [message #617813 is a reply to message #617811] Thu, 03 July 2014 14:15 Go to previous messageGo to next message
BlackSwan
Messages: 22800
Registered: January 2009
Senior Member
filename itself is not correct

http://docs.oracle.com/cd/E16655_01/server.121/e17636/dba.htm#ADMIN12478
Re: Error login to the Oracle 11g (2 merged by MC) [message #617888 is a reply to message #617813] Fri, 04 July 2014 04:28 Go to previous messageGo to next message
tedinho123
Messages: 26
Registered: June 2014
Junior Member
is this syntax alright?? i followed the docs.oracle....
c:\app\yoka.gael\product\11.2.0\dbhome_1\DATABASE\PWDstatdb.ora password=P@ssw0rd entries=30 force=Y ignorecase=Y

nosysdba=N
Re: Error login to the Oracle 11g (2 merged by MC) [message #617892 is a reply to message #617888] Fri, 04 July 2014 04:41 Go to previous messageGo to next message
tedinho123
Messages: 26
Registered: June 2014
Junior Member
When i type this syntax it opens up the WordPad with encrypted data
Re: Error login to the Oracle 11g (2 merged by MC) [message #617897 is a reply to message #617892] Fri, 04 July 2014 05:00 Go to previous messageGo to next message
John Watson
Messages: 4577
Registered: January 2010
Location: Global Village
Senior Member
So now you are trying to execute the password file. I give up.
Re: Error login to the Oracle 11g (2 merged by MC) [message #617906 is a reply to message #617897] Fri, 04 July 2014 05:37 Go to previous messageGo to next message
tedinho123
Messages: 26
Registered: June 2014
Junior Member
I don't know how to proceed from there?? Please Help i'm stuck
Re: Error login to the Oracle 11g (2 merged by MC) [message #617908 is a reply to message #617906] Fri, 04 July 2014 05:39 Go to previous messageGo to next message
tedinho123
Messages: 26
Registered: June 2014
Junior Member
Do I need to create a file in the same folder as the PWDfile?
Re: Error login to the Oracle 11g (2 merged by MC) [message #617915 is a reply to message #617908] Fri, 04 July 2014 06:48 Go to previous messageGo to next message
tedinho123
Messages: 26
Registered: June 2014
Junior Member
Now i deleted the old pwdfile and have created the file such as orapwd file=C:\path.... and i get the error OPW-00001:unable to open password file
Re: Error login to the Oracle 11g (2 merged by MC) [message #617923 is a reply to message #617915] Fri, 04 July 2014 08:38 Go to previous message
BlackSwan
Messages: 22800
Registered: January 2009
Senior Member
Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/ and please read http://www.orafaq.com/forum/t/174502/102589/
Previous Topic: How do you rename User name and switch user to a new tablespace?
Next Topic: View to check user connections
Goto Forum:
  


Current Time: Mon Sep 22 15:24:19 CDT 2014

Total time taken to generate the page: 0.13098 seconds