I need to get permisson to some users to connect from the same server running the database and from another server to connect to a database as sysdba.
What I did is:
1. used orapwd and created a new file pwd
2. changed the prameter remote_login_passwordfile = exclusive
3. create users and granted sysdba and sysoper to the users
4. SQL>connect user/password as sysdba
-sqlplus user/password@sid is not possible
-quering of v$pwfile_users shows no rows.
Any idea what is missing or wrong.