1. We have moved from vBulletin to XenForo and you are viewing the site in the middle of the move. Though the functional aspect of everything is working fine, we are still working on other changes including the new design on Xenforo.
    Dismiss Notice

The Mystery of Scott/Tiger in Oracle

Discussion in 'Oracle' started by pradeep, Dec 15, 2006.

  1. pradeep

    pradeep Team Leader

    Joined:
    Apr 4, 2005
    Messages:
    1,646
    Likes Received:
    86
    Trophy Points:
    0
    Occupation:
    Programmer
    Location:
    Kolkata, India
    Home Page:
    You must have always wondered why there is a uname / pwd in Oracle called, Scott/Tiger....
    Who is this scott ? Here is the answer to ur query....
    So, who is Scott?

    Bruce Scott was one of the first employees at Oracle (then Software Development Laboratories). He co-founded Gupta Technology (now known as Centura Software) in 1984 with Umang Gupta, and later became CEO and founder of PointBase, Inc. Bruce was co-author and co-architect of Oracle V1, V2 and V3. The SCOTT schema (EMP and DEPT tables), with password TIGER, was created by him. Tiger was the name of his cat.
     
  2. coderzone

    coderzone Super Moderator

    Joined:
    Jul 25, 2004
    Messages:
    734
    Likes Received:
    37
    Trophy Points:
    0
    Thats a nice peace of info.
     
  3. stylishkishore

    stylishkishore New Member

    Joined:
    Jun 4, 2009
    Messages:
    11
    Likes Received:
    0
    Trophy Points:
    0
    very nice,,.
     
  4. xpi0t0s

    xpi0t0s Mentor

    Joined:
    Aug 6, 2004
    Messages:
    3,012
    Likes Received:
    203
    Trophy Points:
    0
    Occupation:
    Senior Support Engineer
    Location:
    England
    It's only there if you select it at install time. Having a user called scott is by no means compulsory.
     
  5. mayjune

    mayjune New Member

    Joined:
    Jun 14, 2009
    Messages:
    817
    Likes Received:
    33
    Trophy Points:
    0
    Occupation:
    Student
    Location:
    Pune,Delhi
    nice.... been wondering this for quite long :D
    In college we enter Scott/Tiger/Infotech
    any idea why infotech...or is it set by our college?
     
  6. mayjune

    mayjune New Member

    Joined:
    Jun 14, 2009
    Messages:
    817
    Likes Received:
    33
    Trophy Points:
    0
    Occupation:
    Student
    Location:
    Pune,Delhi
    nice.... been wondering this for quite long :D
    In college we enter Scott/Tiger/Infotech
    any idea why infotech...or is it set by our college?
     
  7. xpi0t0s

    xpi0t0s Mentor

    Joined:
    Aug 6, 2004
    Messages:
    3,012
    Likes Received:
    203
    Trophy Points:
    0
    Occupation:
    Senior Support Engineer
    Location:
    England
    Is it scott/tiger/infotech or scott/tiger@infotech?
    If @ then that's the database alias - you're connecting in a client/server configuration and infotech is defined in $ORACLE_HOME/network/admin/tnsnames.ora.
    Another way to do the same thing would be to set the environment variable TWO_TASK=infotech, then sqlplus scott/tiger would do the same thing.

    If scott/tiger/infotech, no idea, never seen that syntax before, unless the password is "tiger/infotech".
     
  8. mayjune

    mayjune New Member

    Joined:
    Jun 14, 2009
    Messages:
    817
    Likes Received:
    33
    Trophy Points:
    0
    Occupation:
    Student
    Location:
    Pune,Delhi
    @xp
    its @

    and what i asked was like scott tiger, is infotech come pre installed? if yes any reasons like above?
     
  9. xpi0t0s

    xpi0t0s Mentor

    Joined:
    Aug 6, 2004
    Messages:
    3,012
    Likes Received:
    203
    Trophy Points:
    0
    Occupation:
    Senior Support Engineer
    Location:
    England
    No, infotech will have been setup by your sys admin. Have a look at tnsnames.ora and you'll see how it's defined, not much of any interest in there though.
    The scott schema doesn't come pre-installed; you have to select it in the installer.
     
  10. nimesh

    nimesh New Member

    Joined:
    Apr 13, 2009
    Messages:
    770
    Likes Received:
    20
    Trophy Points:
    0
    Occupation:
    Oracle Apps Admin
    Location:
    Mumbai
    Home Page:
    I know about the tns file but what is TWO_TASK
    Is it used to asign the default database alias?
     
  11. xpi0t0s

    xpi0t0s Mentor

    Joined:
    Aug 6, 2004
    Messages:
    3,012
    Likes Received:
    203
    Trophy Points:
    0
    Occupation:
    Senior Support Engineer
    Location:
    England
    TWO_TASK is an environment variable. If you set TWO_TASK=foo, then "sqlplus scott/tiger" is equivalent to "sqlplus scott/tiger@foo". If TWO_TASK isn't set, then "sqlplus scott/tiger" will connect to the local database, and throw an error if there isn't one. That's all there is to it; it means you can do a TNS connection while thinking you're doing a local connection. You can think of it as a "default database alias" if you like, but probably best to think of it as what it is.
     
  12. 9648580081

    9648580081 New Member

    Joined:
    Jan 25, 2011
    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    0
    Occupation:
    student
    Location:
    lucknow
    thnks interesting
    could you please tell me all the default username and password in SQL
     
  13. xpi0t0s

    xpi0t0s Mentor

    Joined:
    Aug 6, 2004
    Messages:
    3,012
    Likes Received:
    203
    Trophy Points:
    0
    Occupation:
    Senior Support Engineer
    Location:
    England
    There isn't one. SQL is just a language; see http://en.wikipedia.org/wiki/SQL

    Often Microsoft SQL Server is abbreviated to just SQL; have you done the same?
     

Share This Page