Home » RDBMS Server » Server Administration » Error login to the Oracle 11g (3 merged by MC)
Error login to the Oracle 11g (3 merged by MC) [message #617760] Thu, 03 July 2014 07:25 Go to next message
tedinho123
Messages: 32
Registered: June 2014
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 1366 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: 8922
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: 1376
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: 68625
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: 32
Registered: June 2014
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: 32
Registered: June 2014
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: 26766
Registered: January 2009
Location: SoCal
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: 32
Registered: June 2014
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: 32
Registered: June 2014
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: 8922
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: 32
Registered: June 2014
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: 32
Registered: June 2014
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: 32
Registered: June 2014
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 messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
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/
Database Backup and new instance [message #625684 is a reply to message #617760] Mon, 13 October 2014 04:01 Go to previous messageGo to next message
tedinho123
Messages: 32
Registered: June 2014
Member
Hi everyone,

My old instance has failed to work, so i cannot login as sysdba anymore, i want to keep my database and create a new instance using the old database, how do i proceed???

Please help???

I have CTL files and DBF files and REDO files in my old instance (STATDB)
Re: Database Backup and new instance [message #625685 is a reply to message #625684] Mon, 13 October 2014 04:04 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

What do you mean by "My old instance has failed to work, so i cannot login as sysdba anymore"?

BlackSwan wrote on Fri, 04 July 2014 15:38
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/


And don't forget:

Michel Cadot wrote on Thu, 03 July 2014 14:56

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

Re: Database Backup and new instance [message #625688 is a reply to message #625685] Mon, 13 October 2014 04:21 Go to previous messageGo to next message
tedinho123
Messages: 32
Registered: June 2014
Member
I mean the old instance that was initially created when i did setup the database
Re: Database Backup and new instance [message #625690 is a reply to message #625688] Mon, 13 October 2014 05:18 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Ok let's explain:
"My old instance has failed to work" what this mean? What is an instance for you? what does mean "failed to work"? Note this is not an Oracle error message.

"so i cannot login as sysdba anymore", what does mean "cannot login"? An error? Which one? show us, use SQL*Plus and copy and paste your session.

Re: Database Backup and new instance [message #625694 is a reply to message #625690] Mon, 13 October 2014 05:28 Go to previous messageGo to next message
tedinho123
Messages: 32
Registered: June 2014
Member
My password fails even when i use the "connect sys as sydba" it gives an error, i want to create a new instance.
Re: Database Backup and new instance [message #625697 is a reply to message #625694] Mon, 13 October 2014 05:30 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

"it gives an error" and you think that not sharing this error with us will help us in any way to help you?

Re: Database Backup and new instance [message #625715 is a reply to message #625694] Mon, 13 October 2014 07:50 Go to previous messageGo to next message
EdStevens
Messages: 1376
Registered: September 2013
Senior Member
tedinho123 wrote on Mon, 13 October 2014 05:28
My password fails even when i use the "connect sys as sydba" it gives an error, i want to create a new instance.


If you lost the key to your house, would you decide the solution is to build a new house?

Instead of worrying about creating a new database, why not deal with what should be the rather simple problem of getting logged on to your existing database? Even if this is just a personal test database you have to ask yourself what you would do if it were the company's number one, customer facing, revenue generating, production database.

And to help you with the problem of getting logged in to your existing database, we need actual commands and actual error messages, not your vague descriptions of them.
Re: Database Backup and new instance [message #625772 is a reply to message #625715] Tue, 14 October 2014 02:48 Go to previous messageGo to next message
tedinho123
Messages: 32
Registered: June 2014
Member
When i connect to my database as sysdba it's asking for a password which fails to work, error ORA-12638:Extraction of preferences user....., i did then create a new password with orapwd then retried to get connected it still gives the error, i thought that it's my instance that has issues then i wanted to create a new one??
Re: Database Backup and new instance [message #625778 is a reply to message #625772] Tue, 14 October 2014 03:36 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
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.
Re: Database Backup and new instance [message #625779 is a reply to message #625778] Tue, 14 October 2014 03:38 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

So this is the same question than your previous topic in July; I will merge both.

Re: Database Backup and new instance [message #625796 is a reply to message #625779] Tue, 14 October 2014 05:40 Go to previous messageGo to next message
tedinho123
Messages: 32
Registered: June 2014
Member
I wanted to create a new instance and keep the same database...how can i proceed?
Re: Database Backup and new instance [message #625798 is a reply to message #625796] Tue, 14 October 2014 05:48 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

What do you mean by "instance" and "database"?

Re: Database Backup and new instance [message #625801 is a reply to message #625798] Tue, 14 October 2014 05:56 Go to previous messageGo to next message
tedinho123
Messages: 32
Registered: June 2014
Member
I mean i want to create a new SID and keep the same datafiles
Re: Database Backup and new instance [message #625802 is a reply to message #625801] Tue, 14 October 2014 05:59 Go to previous message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
In that case, you need to use the oradim utility to create the new windows service; use notepad to create a new parameter file, with the db_name set to the name of the database; set your ORACLE_SID environment variable to the name of the new instance; connect as sysdba; and startup.
Previous Topic: Temp tablespace NOT shrinking in oracle 11.2.0.3
Next Topic: Database Performance vs SGA size
Goto Forum:
  


Current Time: Thu Mar 28 14:28:00 CDT 2024