OraFAQ Forum: Server Administration » what's default setting for those user(sys,system,and so on) for oracle 10g

Home » RDBMS Server » Server Administration » what's default setting for those user(sys,system,and so on) for oracle 10g

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

what's default setting for those user(sys,system,and so on) for oracle 10g [message #215358]

Sun, 21 January 2007 20:48

bikachu
Messages: 4
Registered: January 2007

Junior Member

Could anybody help me with this issues?

many thanks ahead.

cheers

kevin

Report message to a moderator

Re: what's default setting for those user(sys,system,and so on) for oracle 10g [message #215359 is a reply to message #215358]

Sun, 21 January 2007 20:52

bikachu
Messages: 4
Registered: January 2007

Junior Member

Could anybody help me with this issues?
It seems that it was different between 10g and 8i/9i for default users' password?I am not sure it.

Really Hope I can get good ideas from all of you.

many thanks ahead.

cheers

kevin

Report message to a moderator

Re: what's default setting for those user(sys,system,and so on) for oracle 10g [message #215375 is a reply to message #215359]

Sun, 21 January 2007 22:10

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

Hi,
Don't know about 8i,
but In Oracle 9i
Default Password
1.sys ----> change_on_install
2.system --> Manager
3. scott ---> tiger ( a/c status is open)

In Oracle 10g.
We have to give password for "sys" and "system" during installation time and also we can also set others user with sys and system password some or different.
In 10g there is no default password for sys and system user.
even scott user password is tiger but a/c status is "LOCK" you have to unlock scott user.

regards
Taj

Report message to a moderator

Re: what's default setting for those user(sys,system,and so on) for oracle 10g [message #215393 is a reply to message #215375]

Mon, 22 January 2007 01:45

bikachu
Messages: 4
Registered: January 2007

Junior Member

hi user52
Thanks for your anwsers. It match what I had got. so thanks very much.
And BTW would you mind tell me what's the clause about unlock users?
Many many thanks to you.

cheers

kevin

Report message to a moderator

Re: what's default setting for those user(sys,system,and so on) for oracle 10g [message #215394 is a reply to message #215393]

Mon, 22 January 2007 01:56

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

Hi,

SQL> select  account_status from dba_users
  2  where username = 'SCOTT';

ACCOUNT_STATUS
--------------------------------
LOCKED

SQL> conn scott/tiger@db02
ERROR:
ORA-28000: the account is locked


Warning: You are no longer connected to ORACLE.
SQL> --we have to UNLOCK scott user account.
SQL> conn sys@db02 as sysdba
Enter password:
Connected.

SQL> alter user SCOTT account UNLOCK;

User altered.

SQL> conn scott/tiger@db02
Connected.
SQL>

regards
Taj

Report message to a moderator

Re: what's default setting for those user(sys,system,and so on) for oracle 10g [message #215401 is a reply to message #215394]

Mon, 22 January 2007 02:32

bikachu
Messages: 4
Registered: January 2007

Junior Member

It's so perfect for me.
many thanks to all of you.

I like this realm .

Thanks.

cheers

kevin

Report message to a moderator

Previous Topic:	ORA-27102: out of memory
Next Topic:	IGNORE COMMENTS IN EXTERNAL TABLE

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 04:51:47 CDT 2024