Results 1 to 17 of 17

Thread: What are the default username and password for oracle 10g?

  1. #1
    Junior Member
    Join Date
    Jul 2008
    Answers
    8

    What are the default username and password for oracle 10g?

    Hi all,

    I tried for sys/sys, system/msnsger and scott/tiger. But these are not working. How i regret the connected username/passwod?

    Can anybody suggest me regarding this one.


    regards,
    RK


  2. #2
    Contributing Member
    Join Date
    Jan 2009
    Answers
    31

    Re: What are the default username and password for oracle 10g?

    You should be knowing what password you have given for sys and system account while installing the Oracle sofware.

    In Oracle10g, by default Scott account will be locked.
    To unlock:-
    SQL> alter user scott account unlock;


  3. #3
    Moderator
    Join Date
    Jun 2007
    Answers
    2,074

    Re: What are the default username and password for oracle 10g?

    You must know the sys or system user login to create or change other logins. There is no default login in 10g (most people think SCOTT/TIGER). That account will be there but will be locked. so you need to unlock the same during installation or after wards by loggin in from the sys or system account. To log in as sys try the following

    conn sys/ as sysdba

    when prompted for password just hit enter

    try the above at command prompt.


  4. #4
    Junior Member
    Join Date
    Apr 2009
    Answers
    5

    Re: What are the default username and password for oracle 10g?

    The lots of user think is the tiger is the default password for scott user but it is not predefine we are define the oracle instalation time..


  5. #5
    Junior Member
    Join Date
    May 2010
    Answers
    5

    Re: What are the default username and password for oracle 10g?

    nothing defined above is working.


  6. #6
    Junior Member
    Join Date
    Oct 2010
    Answers
    1

    Re: What are the default username and password for oracle 10g?

    try sys or system


  7. #7
    Contributing Member
    Join Date
    Sep 2005
    Answers
    91

    Re: What are the default username and password for oracle 10g?

    Hello,

    As for as I know , You will need to enter your own password for each user at the end of the installation in 10g .. Try reinstalling

    Oracle 10g Free Training: Oracle Database Installation Page - 3

    this is third page where you can see the password management screen





    Cheers
    Chandra



    Cheers
    Chandra


  8. #8
    Junior Member
    Join Date
    Nov 2010
    Answers
    1

    Re: What are the default username and password for oracle 10g?

    For 10g Database
    If Database platform is windows than it will be hr/hr
    If its on linux than it will be 'system/manager' or use at user level '$sqlplus / as sysdba';


  9. #9
    Junior Member
    Join Date
    Feb 2011
    Answers
    1

    Re: What are the default username and password for oracle 10g?

    right....ok jeetu tell me i dint define any username and password during install so how wil i connect to isqlplus/dba


  10. #10
    Moderator
    Join Date
    Jun 2007
    Answers
    2,074

    Re: What are the default username and password for oracle 10g?

    try this

    sqlplus> / as sysdba


  11. #11
    Junior Member
    Join Date
    Dec 2006
    Answers
    5

    Re: What are the default username and password for oracle 10g?

    See there is no default password for any user.when u r installing oracle 10g mean time it will ask u to set 4 user pass word as dofferent or same.apart from 4 all user has locked.But u can log in by in run command as

    conn sys as sysdba

    it will ask u password just press enter, it will login.then just change the syatem password by
    alter user system identified by oracle.i mean ur system password will be oracle.then u can go ahead.

    ajay mohanty


  12. #12
    Junior Member
    Join Date
    Mar 2011
    Answers
    1

    Re: What are the default username and password for oracle 10g?

    See, we can say that sys is the default password for 10g. When we conn to oracle database as sys as sysdba. We can conn all the user which is under the sys user for all.

    Loverson(OCP).


  13. #13
    Junior Member
    Join Date
    Mar 2011
    Answers
    1

    Re: What are the default username and password for oracle 10g?

    system/manager


  14. #14
    Banned
    Join Date
    Oct 2011
    Answers
    1

    Re: What are the default username and password for oracle 10g?

    The lots of user think is the tiger is the default password for scott user but it is not predefine we are define the oracle instalation time..


  15. #15
    Contributing Member
    Join Date
    Sep 2005
    Answers
    91

    Re: What are the default username and password for oracle 10g?

    Quote Originally Posted by Edi8th99 View Post
    The lots of user think is the tiger is the default password for scott user but it is not predefine we are define the oracle instalation time..
    You are right.

    Best,
    Chandra


  16. #16
    Junior Member
    Join Date
    Dec 2012
    Answers
    1

    Re: What are the default username and password for oracle 10g?

    Probably he' s using windows 7 operating system.
    Just do these few change of settings then everything will get sorted.

    Right click on the sql plu > properties > compatibility> check in the 'Run this program in compatibility mode ' select windows 98/windows me in dropdown.

    Now issue is resolved - login with the sytem and password provided during installation.


  17. #17
    Junior Member
    Join Date
    Dec 2012
    Answers
    2

    Re: What are the default username and password for oracle 10g?

    The Default user in Oracle 10G is SYS USER and its default is change_in_install but we can change all users password at the time of installation.

    Cheers,
    Deepak Kumar Tyagi


  18.  Sponsored Ads
    Ad


     

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
About us
Applying for a job can be a stressful and frustrating experience, especially for someone who has never done it before. Considering that you are competing for the position with a at least a dozen other applicants, it is imperative that you thoroughly prepare for the job interview, in order to stand a good chance of getting hired. That's where GeekInterview can help.
Interact