topic ORAPWD in Operating System - HP-UX

ORAPWD

Shalini Gupta — Wed, 07 Mar 2007 23:50:02 GMT

In windows platform if i am creating password file using oradim then it is working but if i am creating password file using orapwd then is not working, my database name is orcl

i am giving command
C:\>orapwd file=c:\oracle\ora92\database\PWDorcl.ora password=oracle

C:\>sqlplus "sys/oracle as sysdba

SQL*Plus: Release 9.0.1.3.0 - Production on Thu Mar 8 10:11:35 2007

(c) Copyright 2001 Oracle Corporation. All rights reserved.

ERROR:
ORA-01031: insufficient privileges

Enter user-name: desc v$fixed_tables
SP2-0306: Invalid option.
Usage: CONN[ECT] [logon] [AS {SYSDBA|SYSOPER}]
where ::= [/][@] | /
Enter user-name:
c:>orapwd file=c:\oracle\ora92\database\PWDorcl.ora password=oracle entries=20

Re: ORAPWD

Steven E. Protter — Thu, 08 Mar 2007 00:01:16 GMT

Shalom,

Review the procedures for properly generating this password.

I think you need to logon as sysdba to do what you are trying to do.

Any reason why this is posted in HP-UX? The windows guys might actually be familiar enough to help more than us.

SEP

Re: ORAPWD

Oviwan — Thu, 08 Mar 2007 03:16:20 GMT

Hy

check this site:
http://www.adp-gmbh.ch/ora/err/ora_01031.html

check the folder (c:\oracle\ora92\database\) to see whether the file was created. is it the right directory?

Regards