Solved

ORACLE, DATABASE, 10g, SYSTEM account, Oracle

Posted on 2008-06-14
5
711 Views
Last Modified: 2013-12-19
We loss the SYSTEM account's password. How to get SYSTEM account on our oracle database 10g.
0
Comment
Question by:serkanakyol
5 Comments
 
LVL 142

Accepted Solution

by:
Guy Hengel [angelIII / a3] earned 63 total points
ID: 21785280
AFAIK, you canot "get" it. but you can connect with SYS (or another SYSDBA / SYSOPER) account and change the SYSTEM password.
0
 

Author Comment

by:serkanakyol
ID: 21785555
Ok.

How can I change it via sqlplus comman console?
0
 
LVL 73

Assisted Solution

by:sdstuber
sdstuber earned 62 total points
ID: 21785563
$ sqlplus "/ as sysdba"

SQL> alter user system identified by your_new_password

SQL> exit


done!

0

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
Creating and Managing Databases with phpMyAdmin in cPanel.
This video shows how to recover a database from a user managed backup
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.

803 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question