Solved

ORACLE, DATABASE, 10g, SYSTEM account, Oracle

Posted on 2008-06-14
5
714 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
5 Comments
 
LVL 143

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 74

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

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
A question about syntax 5 53
Deleting multiple child tables from parent in one SQL statement 20 56
Read CLOB data from Oracle using JAVA 3 43
Shared Service Environment 2 54
Never store passwords in plain text or just their hash: it seems a no-brainier, but there are still plenty of people doing that. I present the why and how on this subject, offering my own real life solution that you can implement right away, bringin…
A company’s centralized system that manages user data, security, and distributed resources is often a focus of criminal attention. Active Directory (AD) is no exception. In truth, it’s even more likely to be targeted due to the number of companies …
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.

751 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