for creating new users-
create user username identified by password;
for permission-
grant resource to username;
Manju_1 0 Newbie Poster
Hemanth_4 0 Newbie Poster
for me .... SYSTEM as user name worked ,........thanks
Manisha Biradar 0 Newbie Poster
I installed oracle but it didn't gave me any password at the time of installation and directly its asking for confirm your password for system as username at the end of installation.so please can anyone tell me that what will be the password.
avila 0 Newbie Poster
Enter user-name: conn as sysdba
Enter password:
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> alter user scott account unlock;
User altered.
SQL> alter user scott identified by tiger
2 ;
User altered.
SQL> conn scott/tiger;
Connected.
SQL>
avila 0 Newbie Poster
Plz enter password as "sys"
abusayed 0 Newbie Poster
It works for me.. This is Great :)
You are Great
Ravinder123456 0 Newbie Poster
oracel user name "sys as sysdba" and password "orcl"
Anna_4 0 Newbie Poster
I've reinstalled oracle-xe and it didn't ask not for username neither for password during installation. Can anyone help?..
Navin_1 0 Newbie Poster
Just use SYSTEM in username and you must have saved some password while installing that you need to use in password section.
Vinay_11 0 Newbie Poster
thanks it works user name SYSTEM and and password that u have given at installation..
Satya_3 0 Newbie Poster
The problem is that you are not able to connect to sql. You first check whether environment variables(ORACLE_HOME,PATH,ORACLE_SID) are set or not. While installing the oracle software you must have created a user called "oracle" and you must have added him to dba group as that is a prerequisite to install.So you switch user to oracle(su - oracle) and check whether you set all the variables or not(echo $ORACLE_HOME).If not, you set those and if those are set you try to connect with "sqlplus / as sysdba". As the oracle user is already added in dba group, the SQL window will open with out any problem.And then you can change the password for SYS if you want to.
BTW the default password for SYS is "CHANGE_ON_INSTALL or INTERNAL".
You just have to check whether environment variables set for that user or not(you can set in .bash_profile file of that user) and have to check whether the credentials that you giving while connecting are having previleges or not.
Arslan_2 0 Newbie Poster
It is possible to connect to the database without specifying a password. Once you've done that you can then reset the passwords. I'm assuming that you've installed the database on your machine; if not you'll first need to connect to the machine the database is running on.
Ensure your user account is a member of the dba group. How you do this depends on what OS you are running.
Enter sqlplus / as sysdba in a Command Prompt/shell/Terminal window as appropriate. This should log you in to the database as SYS.
Once you're logged in, you can then enter
alter user SYS identified by "newpassword";
to reset the SYS password, and similarly for SYSTEM.
(Note: I haven't tried any of this on Oracle 12c; I'm assuming they haven't changed things since Oracle 11g.)
Varra 0 Newbie Poster
enter username: sys as sysdba
password: sys
Arindam_1 0 Newbie Poster
It should by SYSTEM and the passowrd you have entered during installation
Johan_3 0 Newbie Poster
the default password on the vbox distribution of oracle 11g is:
welcome1
the root username is oracle password oracle
and the weblogic console username is weblogic with password welcome1
hope this helps someone
Jawad_8 0 Newbie Poster
Shiwam_1 0 Newbie Poster
try Username: hr , Password: (the password that you set when you unlock hr during installation in most of the cases the password is 'hr')
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.