| Help! Old Problem - New Face [message #62073] |
Wed, 23 June 2004 15:14  |
Tony
Messages: 190
Registered: June 2001
|
Senior Member |
|
|
Ok. I know this question has been asked several times and I have already consolidated all the answers and checked it out and I can't figure what's wrong. And I already have 5 servers running fine with these settings.
Problem:
From a client (using sqlplus or Oracle OEM) I cannot connect to the database with 'sys' as SYSDBA role. All I get is ORA-01031 Insufficient Privileges.
I have set the remote password for 'sys' for 5 servers (Solaris) and all of them run well. Recently I got a new server for support (Solaris again) setup by someone else and I have this issue.
Ok . Now let me tell you what all I have done/see on this server. I checked all the below by the book:
*dba Group: dba
*Unix oracle Owner: oracle
*user 'oracle' is a member of the group 'dba'.
*parameter remote_login_passwordfile=exclusive is enabled in the init.ora file for that database
*I ran orapwd and set the remote password.
*The remote password set using 'orapwd' matches the password for 'sys'.
Here is more from the sqlplus:
$sqlplus /nolog
SQL*Plus: Release 8.1.7.0.0 - Production on Wed Jun 23 16:10:14 2004
(c) Copyright 2000 Oracle Corporation. All rights reserved.
SQL> connect / as sysdba
Connected.
SQL> show parameter remote_login_passwordfile;
NAME TYPE VALUE
------------------------------------ ------- ------------------------------
remote_login_passwordfile string EXCLUSIVE
SQL>show user;
USER is "SYS"
Now the only place I see nothing is from the query below:
SQL>select * from v$pwfile_users;
no rows selected
SQL>
Technically the above query should result atleast in 2 default users- SYS, Internal. But I don't get any results.
So How do I add them to this? Or is it even possible manually to do something to this query's base table (as it's a view). What else do I do to make this work?
Thanks
|
|
|
|
| Re: Help! Old Problem - New Face [message #62083 is a reply to message #62073] |
Thu, 24 June 2004 03:08  |
 |
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
|
Senior Member
Account Moderator |
|
|
-- passwordfile should be created when the datdabase is closed. did you do that?
do a clean shutdown of database.
create new passwordfile with orapwd.
restart the database
try again.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
