Re: shutdown/startup Oracle8 NT

First off, your English is fine. I know how to solve this in Oracle 7, but haven't tried it in 8... So it looks like you want users to connect remotely to your database as SYSDBA or SYSOPER. First you have to run the orapwd utility. As the Oracle Unix User at the Unix prompt type: orapwd (I am not at my database, so just type that and hit return to see the options, also make sure the password file is in the same location as your init<sid>.ora file) After you have sucessfully created a password file, edit the init<sid>.ora file and add the following line: remote_password ?something like that? = EXCLUSIVE shutdown and startup the database to let the new parameter take into effect. Then login as system/password and grant sysdba to whomever. I will give you the right info when I get back to my office.

Good Luck,
satar
In article <6vnua2$ciq$1_at_nnrp1.dejanews.com>,   manu7502_at_my-dejanews.com wrote:
> Hello,
>
> I am having a problem with Oracle 8 on NT.
> I have a Oracle8 book that tells me to do this:
>
> sql>connect sys/passwd
> sql>grant sysoper to scott;
> error message
> ORA-01031: insufficient privileges
>
> sql>grant sysdba to scott;
> ORA-01031: insufficient privileges
>
> Why???
>
> To try to understand, with svrmgr30 i do:
>
> svrmgr>connect internal/passwd as sysoper;
> connected.
> My reaction: sysoper role exists!
> svrmgr>grant sysoper to scott;
> ORA-01994: GRANT failed: cannot add users to public password file
> svrmgr>connect internal/passwd as sysdba;
> connected.
>
> if i try to do
> svrmgr>connect sys/passwd as sysoper
> i have the message
> ORA-01031: insufficient privileges
>
> It is my first experience with Oracle . If can, please help me.
> thanks in advance.
>
> ...And excuse me if i dont speak very well English.
>
> Manuel.
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
>

--
Oracle DBA/UNIX System Admin
Advanced Enterprise Solutions
(949) 756-0588
Oracle Re-Seller

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Sat Oct 10 1998 - 19:10:58 CDT