From: Vitaly Sikolenko Subject: Re: How to set connect internal password Date: 1997/08/08 Message-ID: <33EB09C5.6136733F@ru.oracle.com>#1/1 References: <5rp8p3$b50$1@news01.btx.dtag.de> <33e88faa.9851166@news> To: Larry Rosen X-Priority: 3 (Normal) Organization: Oracle C.I.S. Reply-To: vsikolen@ru.oracle.com Newsgroups: comp.databases.oracle.server Larry Rosen wrote: > F.Hellweg@t-online.de (Frank Hellweg) wrote: > > > > >Hey, > >for security needs we want to know how to set a password for connect > >internal. We got a hint on a 'orapwd' tool, but we don´t know how to use > >the file created by orapwd. Oracle Version 7.2.3 / AIX. Please help ! > > How about setting a dummy value, like SID1, for the environment > variable ORACLE_SID in the oracle user's .profile script. The > user could not connect internal unless they knew how to change > the ORACLE_SID to the actual instance name. This can admittedly > be annoying during system maintenance. > > Larry Rosen > rosenl@magicnet.net Anyway orapwd doesn't restrict connect internal for "dba" group users under Unix (it's different under Windows NT). It rather permits to make remote connect as SYSDBA (internal) specifying the password you indicate when running orapwd. The utility is described in the "Server Administrator's guide", I may only add that the name of password file is fixed: it should be orapwSID in $ORACLE_HOME/dbs. Do not forget to set remote_login_passwordfile to EXCLUSIVE in your init.ora -- Vitaly Sikolenko Senior Sales Consultant Server & Gateways ORACLE C.I.S. Moscow Russia E-mail: vsikolen@ru.oracle.com The statements and opinions expressed here are my own and do not necessarily represent those of Oracle Corporation.