RAINSTORY.RAINMAKER

# Oracle Administrator Account Password.

# 오라클 관리자 계정 패스워드를 잃어버리셨을때는 우선 결론을 말씀드리면 잊어버린 암호는 찾을 수 없습니다. 따라서 새로운 암호를 설정하셔야 합니다.

OS] $ sqlplus "/as sysdba"
SQL> show user --> USER은 "SYS"입니다
SQL> alter user sys identified by 원하는암호;
SQL> alter user system identified by 원하는암호;
SQL> select username, password from dba_users;

USERNAME                PASSWORD
---------------------------------------------
SYS                            8A8F025737A9097A
SYSTEM                      2D594E86F93B17A1

# 보시는 것처럼 우리가 정한 암호는 일반 텍스트가 아닌 암호화되어서  저장됩니다. 그래서 DBA도 각 유저의 암호를 알 수 없습니다. 따라서  암호를 잊어먹었을 경우 새로운 암호를 설정하고 그것을 알려주어야  합니다.

이상입니다.

Written by RAINMAKER

I found up a program on the way surf of Internet. So I want to introduce you. This is a client program for Oracle Database. If you used SQL Plus client program, you're feeling some inconvenience. If you want to use to user interface easily. I'd like to recommend to use the program.

Probably the best bit about SQLpal though is the fact that it just unzips to a directory (no install needed), and it connects via JDBC, therefore not needing an Oracle Client install on your PC. Perfect for putting on a USB keychain drive, for use when you've not got the Oracle Client installed on a machine or you want to use something more user-friendly than SQL*Plus.   

As a replacement for SQL*Plus, SQLpal offers the following features:

• syntax highlighting (in Scratchpad tab)
• auto-completion of table names and columns (in Scratchpad tab)
• up arrow brings back previous command (in SQL Prompt tab)
• read-only schema browser, supports editing PL/SQL functions, procedures, packages
• F7 to view command history
• can bookmark frequent used sql statements
• assign hot key to frequently used sql statements
• save grid as html
• one click to open result grid in Excel
• can open multiple windows for connecting to multiple databases
• uncompromising native Windows user interface
• does not require Oracle client to be installed
• does not require tnsnames.ora, instead just enter the host, port and sid

I'm not good at english well. I'm trying to write english. Whenever you find wrong grammars or words,
I'd appreciate it if you point out mistakes to me.

Source : http://www.sqlpal.com