Re: Connecting as INTERNAL

Yes, the name must be in the format orapw<SID> (without the chevrons, of course!).

And the file must be in the default directory (which from memory is something like ORACLE_HOME/dbs

I know of no way to persuade Oracle to look in a different place, or for a different name (symbolic links and shortcuts don't really count!). I'm not saying that there *isn't* a way to do it, just that I don't know it if it exists.

Regards
HJR "Sathish B" <SathishRani_at_home.com> wrote in message news:410L6.4099$R5.752853_at_news1.rdc1.va.home.com... I think the name of the password file matters . It has to be in a particular format to work . I have had this problem and when i changed it to a particular format it worked . Not sure what else did i change

• Sathish B "Gary Dodge" <Gary.Dodge_at_oracle.com> wrote in message news:3AEDEA6A.3D8B6739_at_oracle.com... Also, everyone should be advised that the CONNECT INTERNAL syntax has been deprecated for several releases and is scheduled to be eliminated as of Oracle9i. Everyone who still has CONNECT INTERNAL embedded in scripts should probably start evaluating the impact of changing these to the newer (and safer!) syntax of CONNECT username/pw as sysdba Gary * Comments to the ng are mine and not necessarily those of Oracle Corp. * Tho Nguyen wrote: Jon wrote:
  >
  >
  > Hi,
  >
  > I have tried to change internal password for an Oracle8i instance under
  > NT40, so I have created the file PWDCPL5500.ora using ORAPWD (orapwd
  > file=PWDCPL5500 password=admin entries=5 )utility and I have replaced the
  > older password file with the new one. The problem now is that I cannot
  > connect as INTERNAL either with the older password or with the new one
  as it
  > returns the "ORA 01031 - Insufficent privileges" error.
  >
  > I would appreciate any help. Thank in advanced,
  Hi, Did you shutdown and startup the database? And the new passwordfile is the same name with the old one? Another way: alter user sys identified by xxx; INTERNAL user will use xxx password. HTH, Tho Nguyen
  >
  >
  -- Posted via CNET Help.com http://www.help.com/