Simpler Navigation for Servers and Operating Systems
Completed: a much simpler Servers and Operating Systems section of the Community. We combined many of the older boards, so you won't have to click through so many levels to get at the information you need. Check the consolidated boards here as many sub-forums are now single boards.
cancel
Showing results for 
Search instead for 
Did you mean: 

ORAPWD

Shalini Gupta
Occasional Visitor

ORAPWD

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
2 REPLIES
Steven E. Protter
Exalted Contributor

Re: ORAPWD

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
Steven E Protter
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
Oviwan
Honored Contributor

Re: ORAPWD

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