| forget password [message #55341] |
Sun, 19 January 2003 00:40  |
momen
Messages: 9
Registered: May 2001
|
Junior Member |
|
|
i have an oracle database 8.0.5
and i changed internal,sys and system passwords
and now i have no user with dba privilegs
how can i create user with dba privs or change internal
password to connect to database with a dba user?
|
|
|
|
| Re: forget password [message #55342 is a reply to message #55341] |
Sun, 19 January 2003 01:14  |
sai sreenivas jeedigunta
Messages: 370
Registered: November 2001
|
Senior Member |
|
|
hi, login to Server manager using INTERNAL as user.
if it asks you for password, type ORACLE
once you login u can alter the passwords of sys and system by saying
alter user sys indentified by new_password
and similarly for system tooo.
sai
|
|
|
|
| Re: forget password [message #55358 is a reply to message #55341] |
Mon, 20 January 2003 11:44 |
Trifon Anguelov
Messages: 514
Registered: June 2002
|
Senior Member |
|
|
If you are on UNIX, login as 'oracle" user in the shell, then:
$ sqlplus /nolog
SQL> connect / as sysdba
...or...
SQL> connect internal
will both connect you as SYS. Then either create your user with DBA privileges, or change the lost passwords.
Hope that helps,
clio_usa
OCP - DBA
Visit our Web site
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
