Go4Expert

Go4Expert (http://www.go4expert.com/)
-   Oracle (http://www.go4expert.com/forums/oracle-forum/)
-   -   The Mystery of Scott/Tiger in Oracle (http://www.go4expert.com/forums/mystery-scott-tiger-oracle-t2252/)

pradeep 15Dec2006 21:55

The Mystery of Scott/Tiger in Oracle
 
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.

coderzone 18Dec2006 10:58

Re: The Mystery of Scott/Tiger in Oracle
 
Thats a nice peace of info.

stylishkishore 26Jul2009 20:28

Re: The Mystery of Scott/Tiger in Oracle
 
very nice,,.

xpi0t0s 26Jul2009 22:56

Re: The Mystery of Scott/Tiger in Oracle
 
It's only there if you select it at install time. Having a user called scott is by no means compulsory.

mayjune 27Jul2009 00:51

Re: The Mystery of Scott/Tiger in Oracle
 
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?

mayjune 27Jul2009 00:51

Re: The Mystery of Scott/Tiger in Oracle
 
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?

xpi0t0s 27Jul2009 00:59

Re: The Mystery of Scott/Tiger in Oracle
 
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".

mayjune 27Jul2009 01:21

Re: The Mystery of Scott/Tiger in Oracle
 
@xp
its @

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

xpi0t0s 27Jul2009 01:53

Re: The Mystery of Scott/Tiger in Oracle
 
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.

nimesh 28Jul2009 01:12

Re: The Mystery of Scott/Tiger in Oracle
 
Quote:

Originally Posted by xpi0t0s (Post 53575)
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".

I know about the tns file but what is TWO_TASK
Is it used to asign the default database alias?


All times are GMT +5.5. The time now is 12:52.