Re: shutdown/startup Oracle8 NT

Thank you very much for your help Jurij . Your solution is the good solution.
I am very happy.
Thank you.

:-)

>Have your remote_login_passwordfile parameter set to EXCLUSIVE.

>Don't use SQL*Plus, use svrmgr30 or enterprise manager instead.
>CONNECT SYS/ORACLE AS SYSDBA
>(ORACLE is the instance password you created with orapwd80)

>List all users with SYSDBA or SYSOPER privileges (initialy there
>should be onls SYS and INTERNAL):
>SELECT * FROM v$pwfile_users;

>Now grant the scott the desired privilege:
>GRANT SYSDBA TO SCOTT;

>Verify the grant was successfull by querying v$pwfile_users again:
>SELECT * FROM v$pwfile_users; (User SCOTT should be listed)

>Connect with svrmgr30 as scott with SYSDBA privilege:
>CONNECT SCOTT/TIGER AS SYSDBA
>Try shutting down the database connected as SCOTT AS SYSDBA to verify
>SCOTT has been given the power of SYSDBA.

>HTH,
-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Mon Oct 12 1998 - 09:43:05 CDT