This content has been marked as final. Show 4 replies
During Oracle DB creation, it may have asked you to setup the password for sys, system and dbsnmp. All other default account will have account locked. So you should use system account with the password you provided during db creation.
Oracle no longer create the old scott/tiger user.
Edited by: skvaish1 on May 11, 2010 4:24 PM
ok so here is what i did.
I dowm loaded Oracle 11G database from edelivery & installed it . When we do a installation it just asks for a Administrative Password & SID. It dosen't ask for a username. Once the database was installed i installed the client (Oracle SQL Developer) & I am trying to make a new database connection. I entered the same administrative password but not sure about the username & every time i test the new connection it comes up saying invalid Username & Password. I got a link on Oracle web site http://www.oracle.com/technology/obe/sqldev/sqldev.htm#t1 In this example he says to use Username as "HR" 7 i tried this but it didnt work :( ..This link is from 2007 & not sure if in the latest version of it we need to use some other username & BTW this installation that i have done is on my Laptop.
any help would be appreciated.
How did you create your database ?
If you created it with DBCA then, at one step, you should give a password for the SYS, SYSTEM, SYSMAN and DBSNMP account.
Else, if you created it manually you may use a syntax like that:
In this case, the password is given by the syntax you used.
CREATE DATABASE <database_name> USER SYS IDENTIFIED BY <sys_password> USER SYSTEM IDENTIFIED BY <system_password> ...
If in your syntax you didn't use the USER IDENTIFIED BY clause, then may be you created a database with default passwords which is not recommended.
In this case, you may try SYSTEM / MANAGER.
Hope this help.
If you still cannot connect to your database then you may reset the passwords as follow, being logged with the OS user on which you installed Oracle:
1. Set the ORACLE SID variable:
On Unix/Linux (shell):
2. Use OS authentication:
3. Reset User password:
sqlplus /nolog connect / as sysdba
Then, you may try again a connexion.
alter user sys identified by <new_password>; alter user system identified by <new_password>;
Hope this help.