Re: Finding out sys password

BS wrote:
> Thanks for the info and all the help!! Sorry about not mentioning the
> OS. Yes it is Unix. So my next question is, Which is the more safer
> way? using the password file or no?
>

It's not a question of safety but the ability to connect to the database as SYSDBA remotely. If you do not have a password file, then you can only connect AS SYSDBA locally on the database server. If you have a requirement to connect remotely as SYSDBA (ie. when using Enterprise Manager), then you will need a password file.

So I guess I should restate my original sentence. If you do not have a need to connect remotely AS SYSDBA, then it is safer to not have a password file at all.

HTH,
Brian

-- 
===================================================================

Brian Peasland
oracle_dba_at_nospam.peasland.net
http://www.peasland.net

Remove the "nospam." from the email address to email me.


"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown