|
Replies:
11
-
Pages:
1
-
Last Post:
Nov 23, 2009 4:17 PM
Last Post By: William Robertson
|
|
|
Posts:
1
Registered:
11/23/09
|
|
|
|
Oracle 11g SQL signon - The scott/tiger routine...
Posted:
Nov 23, 2009 1:52 PM
|
|
|
I just installed Oracle 11g.
First, what is the ID/PW into SQL - it used to be scott/tiger. I changed it to what I wanted on install. However, when I logon and type scott then tiger its says
account locked out. I tried scott and my own "created pw". It still didn't let me in. Is there an "easy" fix?
I have to get this aspect going to get to first base. How do I get around this or FIX it????
Walter Earl Roper
University of Illinois
roperw@uisalumni.org |
|
|
Posts:
5,558
Registered:
05/07/02
|
|
|
Posts:
3,436
Registered:
07/17/00
|
|
|
|
Re: Oracle 11g SQL signon - The scott/tiger routine...
Posted:
Nov 23, 2009 1:59 PM
in response to: user1936647
|
|
|
For security reasons account SCOTT/TIGER comes locked. Login as privileged user and issue:
ALTER USER SCOTT ACCOUNT UNLOCK;
SY. |
|
|
Posts:
24,284
Registered:
10/11/99
|
|
|
|
Re: Oracle 11g SQL signon - The scott/tiger routine...
Posted:
Nov 23, 2009 2:00 PM
in response to: user1936647
|
|
|
By default, most of the demo accounts are created but locked so that they are not security holes if they are inadvertently included in a production install. To unlock scott
- Connect as SYS, i.e. from the command line (DOS prompt in Windows)
sqlplus / as sysdba
- Unlock the account
SQL> ALTER USER scott ACCOUNT UNLOCK;
Now, you should be able to log in as SCOTT. If you want to log in as HR, OE, or any of the other demo accounts, you'd repeat the procedure.
Justin |
|
|
Posts:
7,649
Registered:
03/27/08
|
|
|
|
Re: Oracle 11g SQL signon - The scott/tiger routine...
Posted:
Nov 23, 2009 2:05 PM
in response to: user1936647
|
|
|
Hi,
Welcome to the forum!
SCOTT was created with the account_status = 'EXPIRED & LOCKED' to keep people from loggining in as SCOTT, which is a bad idea. It would be better to create a new user so that you don't have to connect as SCOTT.
If you want to do it anyway, first log in as SYSTEM and say:
ALTER USER scott
ACCOUNT UNLOCK
IDENTIFIED BY new_password
;
|
|
|
Posts:
761
Registered:
10/17/09
|
|
|
|
Re: Oracle 11g SQL signon - The scott/tiger routine...
Posted:
Nov 23, 2009 2:57 PM
in response to: user1936647
|
|
|
Well just contributing my bit although not much different from others 
SQLPLUS system/Manager@orcl /*assuming you did not change the SID and the default password for system */
SQL> alter user scott unlock identified by tiger;
Cheers!!!
Bhushan
P.S: I hope its not taboo to write system/manager and revealing the password.
Edited by: Buga on Nov 24, 2009 12:46 AM |
|
|
Posts:
6,651
Registered:
06/17/98
|
|
|
|
Re: Oracle 11g SQL signon - The scott/tiger routine...
Posted:
Nov 23, 2009 3:24 PM
in response to: Buga
|
|
|
|
"Manager" is not the default password for the system user. In fact there is no default password, and the documentation tells you specifically not to use "manager".
Edited by: William Robertson on Nov 24, 2009 12:15 AM
Not completely true - see below.
|
|
|
Posts:
5,558
Registered:
05/07/02
|
|
|
|
Re: Oracle 11g SQL signon - The scott/tiger routine...
Posted:
Nov 23, 2009 3:25 PM
in response to: Buga
|
|
|
Uhm, Bhushan,
P.S: I hope its not taboo to write system/manager and revealing the password.
I guess not, but this won't work either:
unlokc |
|
|
Posts:
761
Registered:
10/17/09
|
|
|
|
Re: Oracle 11g SQL signon - The scott/tiger routine...
Posted:
Nov 23, 2009 3:27 PM
in response to: William Robertson
|
|
|
|
hhmm..interesting.
Not sure how 11g is but i believe system/manager is true for 8,9 and 10 g versions.
am i correct?
Regards,
Bhushan
|
|
|
Posts:
5,558
Registered:
05/07/02
|
|
|
|
Re: Oracle 11g SQL signon - The scott/tiger routine...
Posted:
Nov 23, 2009 3:41 PM
in response to: Buga
|
|
|
am i correct?
No/whatever.
A (true) DBA, administrating a serious system, would have reset SYS and SYSTEM passwords. |
|
|
Posts:
761
Registered:
10/17/09
|
|
|
|
Re: Oracle 11g SQL signon - The scott/tiger routine...
Posted:
Nov 23, 2009 3:49 PM
in response to: hoek
|
|
|
lol thanks for pointing lokc
Resetting of system/sys password
On production --Yes
On Test --Yes
On Development --Yes
On personal experimental DB who cares
Cheers!!!
Bhushan |
|
|
Posts:
6,651
Registered:
06/17/98
|
|
|
|
Re: Oracle 11g SQL signon - The scott/tiger routine...
Posted:
Nov 23, 2009 4:13 PM
in response to: Buga
|
|
|
|
I should have checked. I've only ever created databases using the Universal Installer and the Database Creation Assistant (DBCA), and these tools have not provided any defaults or even allowed you to use "manager" since 10g. However it seems the traditional defaults are still used if you create the database manually. I suppose the idea is that people who create databases with the CREATE DATABASE statement rather than using the GUI should know what they are doing. Agreed it doesn't matter for home use.
|
|
|
|
Legend
|
|
Guru : 2500
- 1000000
pts
|
|
Expert : 1000
- 2499
pts
|
|
Pro : 500
- 999
pts
|
|
Journeyman : 200
- 499
pts
|
|
Newbie : 0
- 199
pts
|
|
Oracle ACE Director
|
|
Oracle ACE Member
|
|
Oracle Employee ACE
|
|
Helpful Answer
(5 pts)
|
|
Correct Answer
(10 pts)
|
|
