Originally posted by suhasd75
Kevin
Check remote_login_passwordfile init.ora parameter.
If it is "exclusive", then u need to create a password file.
use the orapwd utility to create it
$orapwd file=orapwtest password=pwd entries=5
I suggest u create another user with DBA privileges and create the password file, and set the remote_login_passwordfile=exclusive.
SQL>create user dbmon identified by ...
SQL>grant connect, resource, dba, sysdba to dbmon;

Now on any client machine u can connect as sysdba.

c:\>>sqlplus /nolog
SQL>connect dbmon@ as sysdba
Enter password: -- enter the pwd
Connected.
SQL>

Hope this helps.
remote_login_passwordfile=exclusive and of course I have the password file. And moreover, I am running the command on the server side.