o/s privileges issues/WEIRD

[mike73]

Does any one come acorss with this problem ??? I am running windows 2000, oracle 8.1.7.2.5


let say I logged into windows a user id named JOE, I created the pfile and all the create scripts to run the database, everything ran ok, now I shutdown the databases and logged off the system.

I logged backin with different user on NT as SMITH and JOE and SMITH have the same privileges/security/ everything is the same. So I try to startup the database by iussing this command:

SVRMGRL> connect internal/manager
Connected

SVRMGRL> startup pfile=c:\oracle\ora817\admin\SID_NAME\pfile\initSID_NAME.ora
ORA-01031: INSUFFICIENT PRIVILEGES


anyone come across something like this before ????

[Shestakov]

Try :

connect internal/manager as sysdba

startup pfile=c:\oracle\ora817\admin\SID_NAME\pfile\initSID_NAME.ora
-----------------------------------------

because STARTUP you must execute as SYSDBA or SYSOPER .

[mike73]

Thanks for your reply, but that's not the problem. I changed the REMOTE LOGIN PASSWORD FILE=SHARED and it works fine. But this is just a workaround the problem b/c the remote login password file=NONE, it means that OS authentication will be performed(which is failing, for the above login ID).


Any one have any advises or come across this problem ???

JeFF or Jilian had any advises ?????

Thanks