Newsgroups: comp.databases.oracle.server Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!postnews.google.com!news4.google.com!news.glorb.com!sws1!ornl!news.er.usgs.gov!news From: Brian Peasland Subject: Re: Finding out sys password In-Reply-To: <1149622888.044979.281950@y43g2000cwc.googlegroups.com> X-Nntp-Posting-Host: edc-cv-160-55.cr.usgs.gov Content-Type: text/plain; charset=ISO-8859-1; format=flowed Message-ID: User-Agent: Thunderbird 1.5.0.4 (Windows/20060516) Sender: news@igsrsparc2.er.usgs.gov (Janet Walz (GD) x6739) Content-Transfer-Encoding: 7bit Organization: U.S. Geological Survey, Reston VA References: <1149607608.919106.125090@f6g2000cwb.googlegroups.com> <1149608130.296295.307290@c74g2000cwc.googlegroups.com> <1149609161.071928.314790@g10g2000cwb.googlegroups.com> <1149614520.375249.135040@f6g2000cwb.googlegroups.com> <1149616536.392027.123440@c74g2000cwc.googlegroups.com> <1149622888.044979.281950@y43g2000cwc.googlegroups.com> Mime-Version: 1.0 Date: Tue, 6 Jun 2006 20:26:22 GMT Lines: 31 Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:268651 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@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