| SYS and SYSTEM password lost with Oracle 9i [message #60494] |
Wed, 11 February 2004 00:58  |
Patrick Tahiri
Messages: 119
Registered: January 2004
|
Senior Member |
|
|
Hi,
A partner lost both: the SYS and the SYSTEM passwords!! He asked us if it was possible to "recover" or to find out again which are these passwords? Or maybe to delete them and attribute them new ones!?
They are using Oracle 9i!
Have anyone experienced such problems or have a solution? Thank you for your help!
Regards,
Patrick Tahiri.
PS: See [[NOTE:114384.1]] --[>] How to see this referenced note? Where get it?
|
|
|
|
|
|
| Re: SYS and SYSTEM password lost with Oracle 9i [message #60499 is a reply to message #60494] |
Wed, 11 February 2004 04:21  |
Thiru
Messages: 1089
Registered: May 2002
|
Senior Member |
|
|
If you are logged into the database server as user belonging to 'dba' [[unix]] or 'ora_dba' [[windows]] group , typically 'oracle' , then you should be able to do this
FTST@psfndbt1:/f3/exports>sqlplus "/ as sysdba"
SQL*Plus: Release 9.0.1.4.0 - Production on Wed Feb 11 09:15:00 2004
(c) Copyright 2001 Oracle Corporation. All rights reserved.
Connected to:
Oracle9i Enterprise Edition Release 9.0.1.4.0 - Production
With the Partitioning option
JServer Release 9.0.1.4.0 - Production
SQL> show user
USER is "SYS"
Once logged in, you can change the passwords.
-Thiru
|
|
|
|
| Re: SYS and SYSTEM password lost with Oracle 9i [message #60501 is a reply to message #60499] |
Wed, 11 February 2004 05:25 |
Patrick Tahiri
Messages: 119
Registered: January 2004
|
Senior Member |
|
|
Thiru, you are really a master! Thank for your detailed tips!!
I'm a new DBA in Oracle (Used to work as a Sybase DBA and Developer): I'm an OCP DBA but I'm really working as a real Oracle DBA since 3 monthes! So I have "just" a very theorical experience of Oracle as I can discover each day...
Many thanks for your help again!! Really helpfull
Best regards,
Patrick Tahiri.
|
|
|
|
|
|
| Re: SYS and SYSTEM password lost with Oracle 9i [message #60849 is a reply to message #60499] |
Wed, 10 March 2004 00:44 |
Bebe
Messages: 5
Registered: March 2004
|
Junior Member |
|
|
Hi.I have a problem in OracleSOL+
I instale the soft an when i want to in,in SQL+ i have to put my password.And i can not.I recieve a error message:
ERROR:
ORA-12560: TNS:protocol adapter error
Please help me if U can,and sorry for my english
|
|
|
|
|
|
| Re: SYS and SYSTEM password lost with Oracle 9i [message #61236 is a reply to message #60496] |
Tue, 06 April 2004 12:03 |
Rafael
Messages: 4
Registered: February 2002
|
Junior Member |
|
|
Hi,
Can you explain with more details how to remove and create the password file? Like, where is the file? and how do I create a new one?
I am an intern developing Oracle 9i database but I do not have any previous experience with Oracle. Your help will be very appreciated. Thank you.
Rafael
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
