Re: sys lost sysdba priv?

Gabriel,

If this is a multi-homed box, what orapwd.exe is first in your path? If you check the scripts that dbca creates, it uses full paths when executing binaries so as to remove possible PATH issues.

What is the value of ORACLE_SID in the command shell? What credentials is the OracleService%ORACLE_SID% set to?

You might want to stop and restart the service after creating the password file.

hth.

Paul

On Thu, 17 Mar 2005 11:49:09 -0500, Aragon, Gabriel (GE Commercial Finance) <gabriel.aragon_at_ge.com> wrote:
> Hi list Oracle 9.2.0.4 Win2k, this is a weird situation it seems to be =
> that sys lost its sysdba priv:
>
> ----------------------------------------------------
> D:\Oracle\Ora9i\database>del pwdproddb.ora
> D:\Oracle\Ora9i\database>orapwd file=3DPWDPRODDB.ora password=3Dxxxxx =
> entries=3D10
> D:\Oracle\Ora9i\database>sqlplus "sys_at_testing as sysdba"
>
> SQL*Plus: Release 9.2.0.4.0 - Production on Thu Mar 17 10:38:45 2005
> Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
>
> Enter password:
> Connected to an idle instance.
>
> ERROR at line 1:
> ORA-01034: ORACLE not available
>
> SQL> startup
> ORA-01031: insufficient privileges
>
> D:\Oracle\Ora9i\database>oradim -startup -sid proddb -usrpwd xxxxx
> ORA-01031: insufficient privileges
>
> D:\Oracle\Ora9i\database>sqlplus /nolog
>
> SQL*Plus: Release 9.2.0.4.0 - Production on Thu Mar 17 10:43:00 2005
> Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
>
> SP2-0640: Not connected
> SQL> connect / as sysdba;
> ERROR:
> ORA-01031: insufficient privileges
>
> SQL> connect sys as sysdba;
> Enter password:
> Connected to an idle instance.
> SQL>
> SQL> startup
> ORA-01031: insufficient privileges
> ----------------------------------------------------
>
> My windows user is at Administrator and ORA_DBA group, I've been =
> searching metalink w/o luck. What am I doing wrong? Though this is a =
> testing instance, I dont want to recreate the instance. Any suggestions? =
>
> TIA,
> GAP
> --
> http://www.freelists.org/webpage/oracle-l
>

-- 
#/etc/init.d/init.cssd stop
# f=ma, divide by 1, convert to moles.
--
http://www.freelists.org/webpage/oracle-l