|
Re: Error login to the Oracle 11g [message #617762 is a reply to message #617760] |
Thu, 03 July 2014 07:31 |
John Watson
Messages: 8951 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: Database Backup and new instance [message #625715 is a reply to message #625694] |
Mon, 13 October 2014 07:50 |
|
EdStevens
Messages: 1376 Registered: September 2013
|
Senior Member |
|
|
tedinho123 wrote on Mon, 13 October 2014 05:28My 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 #625802 is a reply to message #625801] |
Tue, 14 October 2014 05:59 |
John Watson
Messages: 8951 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.
|
|
|