There's so many way to solve your problem.
Before you try the solution from other, why don't you try a simple one:
You said that he gave you password of user system, so login using system and
that execute:
SQL> alter user sys identified by new_sys_password;
Other simple scenario:
Login to linux using user oracle:
$ export set ORACLE_SID=<SID_name>
$ sqlplus / as sysdba;
SQL> alter user sys identified by new_sys_password;
Regards,
_Aryadipa.Yudhana_
________________________________________________________________________
________________________________________________________________________
Message 11
From: "absantoso" [EMAIL PROTECTED]
Date: Wed May 17, 2006 8:35pm(PDT)
Subject: Re: HELP: How to open the sys password with sysdba privilage
I hope this will help , please try this :
1. restart linux server in level 1 ( init 1 ) (if the server can be reboot,
immediately )
this will make linux to administrative mode or restart the linux then
chose interactively
boot , then change the root password with command :
# passwd
or
2. run utility command orapwd for example
$ cd $ORACLE_HOME/dbs
$ mv orapwSID.ora orapwSID.ora.old
$ orapwd file=orapwSID.ora password=oracle entries=3
3. you can login as sysdba from oracle OS user , because it's use OS
authentication ,
for example :
$ sqlplus /nolog
sql> connect ardian/oracle as sysdba
(even though the user ardian is not available in your database)
good luck
On 5/18/06, yoga fm <[EMAIL PROTECTED]> wrote:
>
> Dear Gurus...
>
> Anyone can help me to open production database 9i R2 on red hat advanced
> server for sys username with sysdba privelage?
> Our senior dba resign and lock database by changing the sys password
> with sysdba privelage and wont give the new password, even the company
asked
> him.
> He also change the root password and only give as user oracle with the
> password.
> To open the database, he only give us the system password for oracle.
> IT-team with the support of management have several scenario to overcome
> this situation:
>
> 1. create new database on new server. Restore data into new database
> using dump file from export utility.
> 2. shutdown the production server, copy oracle files using hardisk to
> hardisk methood.
>
> anyone can suggest as better idea?
> because it will take a long time to copy the production data and we will
> have down time.
>
> Reply me ASAP
> Thanks and regards
> yoga
>
>
--
-----------I.N.D.O - O.R.A.C.L.E---------------
Keluar: [EMAIL PROTECTED]
Website: http://indo-oracle.lizt.org (NEW)
-----------------------------------------------
Bergabung dengan Indonesia Thin Client User Groups,
Terminal Server, Citrix, New Moon Caneveral, di:
http://indo-thin.vze.com
YAHOO! GROUPS LINKS
- Visit your group "indo-oracle" on the web.
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
