Re: sysdba or sysoper privilege for SYS ?

Thank you very much for your responce.

I tried 2 of your guys's suggestions. 1). For Mick's method, I fouund it partialy works in my database. First, I found it was lost [HK_LOCAL_MACHINE\SOFTWARE\ORACLE]DBA_AUTHORIZATION=BYPASS in my registry. After I typed it in, for svrmgr>connect internal, the database does not ask for 'password' again. Second, I can connect as 'sysdba' with the Enterprise Manager and Instance manager..with SYS/Change_on_install in my local server[that means, I did not type my service (host)string name]. In this situation, the system works well. However, after I type the service name(let's say 'orcltest'), I got 'insufficient prilivege' errors.

2). Then, I tried Angelo's way. When I tried to connect to Entiprise manager as 'sysdba' with sys/oracle for (orcltest), I got:

'XP-07015: An invalid connect string was used to connect to the database:ORA- 01017: invalid username/password; logon denied'

But when I connected instance manager as 'sysdba' with sys/oracle, it worked again, and I could shut down or start up my DB.

3) I did not tried Pavel's suggestion. because I remember that I did not create my repository as he mentioned way, so i did not completely understand his suggestion. But I thanks his response!

Is there any further idea about my results? I think I still need do something to make my DB
works well. But i do not have that idea myself. Please help me again!

Lauray

In article <729ams$8ie$1_at_nnrp1.dejanews.com>,   ryanm6741_at_my-dejanews.com wrote:
> Lauray - if you are running SVRMGR23 on the same box as the server is
> installed, set an environment variable HOME=2:<SID>.
>
> For instance, if your database SID is ORCL (default), then from a dos prompt,
> type SET HOME=2:ORCL
>
> Also, try the adding the following key to your registry:
> [HK_LOCAL_MACHINE\SOFTWARE\ORACLE]
> DBA_AUTHORIZATION=BYPASS
>
> Hope this helps,
> Mick
> Mick.Ryan_at_Hill-Rom.com
>
> In article <72807l$60b$1_at_nnrp1.dejanews.com>,
> lauray70821659_at_my-dejanews.com wrote:
> > I am trying to setup one oracle database recently.
> > However, I found something strange happened in my server:
> > I can not connect the enterprise manager(or any other manager)with 'sysdba'
or
> > 'sysoper' using SYS uid.
> > The only thing I can do just through the 'normal' way to connect them.
> >
> > It seems SYS already lost the privilege for them. But in the security
> > manager, I found the sysdba and sysoper already been granted to SYS as
> > default privileges! As the result, I can not enter the instance manager to
> > startup or shutdown my DB except using the internal/oracle.
> >
> > Another thing is: if i want use 'svrmgr>connect internal', the server always
> > ask me for P.W.(I knew other people's DB do not ask this)
> >
> > I guess something wrong in my server.
> >
> > If you have any idea about it, please help me. i worry about this error will
> > give me further trouble in future.
> >
> > Thanks a lot!
> >
> > Lauray
> >
> > yutongy_at_hotmail.com
> >
> > -----------== Posted via Deja News, The Discussion Network ==----------
> > http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
> >
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Fri Nov 13 1998 - 10:33:53 CST