Home » RDBMS Server » Security » V$PWFILE_USERS is empty (Oracle Database 10.2 on AIX 5.3)
V$PWFILE_USERS is empty [message #410014] Wed, 24 June 2009 19:16 Go to next message
youngb912
Messages: 56
Registered: October 2007
Location: New York
Member

I can't connect remotely to my database using - sqlplus sys/sys@prod1 as sysdba
but can connect as
sqlplus "/as sysdba" or sqlplus sys/sys


SQL*Plus: Release 10.2.0.3.0 - Production on Wed Jun 24 20:10:39 2009 Copyright (c) 1982, 2006, Oracle. All Rights Reserved.
ERROR:
ORA-01031: insufficient privileges
Enter user-name:


When I ran select * from V$PWFILE_USERS; It returns -
no rows selected

Recreated the control file twice as follow -
orapwd file=$ORACLE_HOME/dbs/orapwprod1 password=sys entries=200

And bounce the database but still getting the above error. I connect like sqlplus "/as sysdba" and attempted to grant sysdba to sys and get the folling -

SQL> grant sysdba to sys;
grant sysdba to sys
*
ERROR at line 1:
ORA-01994: GRANT failed: password file missing or disabled

SQL> show parameter password

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
remote_login_passwordfile string EXCLUSIVE


I am on a two node RAC and recreated the passowrd file on both node. Node2 is working fine but node one is not.

Does anyone know why V$PWFILE_USERS willl be empty.
Re: V$PWFILE_USERS is empty [message #410015 is a reply to message #410014] Wed, 24 June 2009 19:26 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
Subject: Troubleshooting ORA-1031 Insufficient Privilege
Doc ID: 730067.1
Re: V$PWFILE_USERS is empty [message #410017 is a reply to message #410015] Wed, 24 June 2009 19:55 Go to previous messageGo to next message
youngb912
Messages: 56
Registered: October 2007
Location: New York
Member
I have gone through that entire documentation. Everything seems okay but still not working.

[Updated on: Wed, 24 June 2009 19:56]

Report message to a moderator

Re: V$PWFILE_USERS is empty [message #410020 is a reply to message #410014] Wed, 24 June 2009 20:05 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
Things work when they are done correctly.

sqlplus

SQL*Plus: Release 10.2.0.4.0 - Production on Wed Jun 24 17:58:48 2009

Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.

Enter user-name: / as sysdba

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> select * from V$PWFILE_USERS;

USERNAME		       SYSDB SYSOP
------------------------------ ----- -----
SYS			       TRUE  TRUE

SQL> shutdown immediate
ORA-01109: database not open


Database dismounted.
ORACLE instance shut down.
SQL> !mv orapwv102 temp-orapwv102

SQL> startup
ORACLE instance started.

Total System Global Area  276824064 bytes
Fixed Size		    1266996 bytes
Variable Size		  109054668 bytes
Database Buffers	  159383552 bytes
Redo Buffers		    7118848 bytes
Database mounted.
Database opened.
SQL> select * from V$PWFILE_USERS;

no rows selected

SQL> !mv temp-orapwv102 orapwv102          

SQL> select * from V$PWFILE_USERS;

USERNAME		       SYSDB SYSOP
------------------------------ ----- -----
SYS			       TRUE  TRUE
Re: V$PWFILE_USERS is empty [message #410096 is a reply to message #410020] Thu, 25 June 2009 03:52 Go to previous message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member

SQL*Plus: Release 10.2.0.3.0 - Production on Wed Jun 24 20:10:39 2009 Copyright (c) 1982, 2006, Oracle. All Rights Reserved.
ERROR:
ORA-01031: insufficient privileges
Enter user-name:


Also look SQLNET.ORA check SQLNET.AUTHENTICATION_SERVICES parameter.

Thanks
Previous Topic: ora-01950 no privileges on tablespace xxx
Next Topic: Username & password for Oracle 10g
Goto Forum:
  


Current Time: Thu Dec 12 08:23:15 CST 2024