OraFAQ Forum: Server Administration » forget my user id and password what to do ?

Home » RDBMS Server » Server Administration » forget my user id and password what to do ?

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

forget my user id and password what to do ? [message #380265]

Fri, 09 January 2009 22:05

msg2ajay
Messages: 51
Registered: June 2007
Location: KUALA LUMPUR

Member

hi,
I forget the UID and PWD which i have given in time of installation. How can i get back them.

I have some valuable tables inside that. Can some one help me.

Ajay

Report message to a moderator

Re: forget my user id and password what to do ? [message #380267 is a reply to message #380265]

Fri, 09 January 2009 22:10

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

http://www.orafaq.com/forum/t/88153/0/
You have not read or followed Posting Guideline as stated in URL above.

>I forget the UID
What is UID?

Is your question really about Oracle RDBMS?

Report message to a moderator

Re: forget my user id and password what to do ? [message #380268 is a reply to message #380267]

Fri, 09 January 2009 22:19

msg2ajay
Messages: 51
Registered: June 2007
Location: KUALA LUMPUR

Member

no actually not RDBMS question. I have seen like Server Administration. That's why i posted here. I forget my USER ID of Oracle Database XE. Can you tell me where can i ask this question ?

ThankQ

Report message to a moderator

Re: forget my user id and password what to do ? [message #380270 is a reply to message #380268]

Fri, 09 January 2009 22:38

babuknb
Messages: 1736
Registered: December 2005
Location: NJ

Senior Member

Quote:

no actually not RDBMS question. I have seen like Server Administration.

Quote:

That's why i posted here. I forget my USER ID of Oracle Database XE. Can you tell me where can i ask this question ?

Try to connect SYS

Report message to a moderator

Re: forget my user id and password what to do ? [message #380291 is a reply to message #380270]

Sat, 10 January 2009 03:55

msg2ajay
Messages: 51
Registered: June 2007
Location: KUALA LUMPUR

Member

hi thank for reply,
what will be the default userid and password for SYS

Report message to a moderator

Re: forget my user id and password what to do ? [message #380310 is a reply to message #380291]

Sat, 10 January 2009 09:19

Michel Cadot
Messages: 68729
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

0 and change_on_install

Regards
Michel

Report message to a moderator

Re: forget my user id and password what to do ? [message #380335 is a reply to message #380310]

Sat, 10 January 2009 23:38

babuknb
Messages: 1736
Registered: December 2005
Location: NJ

Senior Member

Hello Mr.Michel

>>change_on_install

Quote:

I forget my USER ID of Oracle Database XE.

Above password default for Oracle Database XE ??

Babu

Report message to a moderator

Re: forget my user id and password what to do ? [message #380336 is a reply to message #380265]

Sun, 11 January 2009 00:09

msg2ajay
Messages: 51
Registered: June 2007
Location: KUALA LUMPUR

Member

solution for above problem is

connect / as sysdba

To see all users(select * from all_users)

To change the password of a user(alter user wwp identified by ' mynewpassword')

To see the user (show user;)

commit;

thankQ guys

Report message to a moderator